A FW Queue Conditions and System Tags
This topic describes FW queue conditions.
Table A-1 FW Queue conditions
S.No | Module | Action | Cond Text | Cond Action | Queue REASON |
---|---|---|---|---|---|
1 |
FX |
NEW |
INVALID_CUSTOMER |
DESTINATION_Q:= 'REPAIR'; |
Invalid counterparty |
2 |
FX |
NEW |
INVALID_CCY_PAIR |
DESTINATION_Q:= 'REPAIR'; |
Invalid currency pair |
3 |
FX |
NEW |
BOT_HOLIDAY = 'H' |
DESTINATION_Q:= 'REPAIR'; |
Bought Value Date is Holiday |
4 |
FX |
NEW |
SOLD_HOLIDAY = 'H' |
DESTINATION_Q:= 'REPAIR'; |
Sold Value Date is Holiday |
5 |
FX |
NEW |
BOT_HOLIDAY = 'X' |
DESTINATION_Q:= 'REPAIR'; |
Bought currency holiday not maintained |
6 |
FX |
NEW |
SOLD_HOLIDAY = 'X' |
DESTINATION_Q:= 'REPAIR'; |
Sold currency holiday not maintained |
7 |
FX |
NEW |
CUTOFF_NOT_FOUND = 'BOTH ' |
DESTINATION_Q:= 'REPAIR'; |
Cutoff Maintenance NOT found for both pay and recv side |
8 |
FX |
NEW |
CUTOFF_NOT_FOUND = 'PAY' |
DESTINATION_Q:= 'REPAIR'; |
Cutoff Maintenance NOT found for pay side |
9 |
FX |
NEW |
CUTOFF_NOT_FOUND = 'RECV' |
DESTINATION_Q:= 'REPAIR'; |
Cutoff Maintenance NOT found for receive side |
10 |
FX |
NEW |
MAIN.SPECIAL_HANDLING_CODE IN ('Y','HVP','DVP','FOP') |
DESTINATION_Q:= 'SPECIAL'; |
Special handling requested by trader |
11 |
FX |
NEW |
NVL(TXN_REC.CLS_ELIGIBLE,'N') = 'N' AND ((NVL(MAIN.PAY_CUTOFF,GLOBAL.Application_date+1) < GLOBAL.Application_date AND si_rec.PAY_INSTRUCTION_TYPE='O') OR (NVL(MAIN.RECV_CUTOFF,GLOBAL.Application_date+1) < GLOBAL.Application_date AND si_rec.RECV_INSTRUCTION_TYPE='O')) |
DESTINATION_Q:= 'SPECIAL'; |
Past Cut off Time |
12 |
FX |
NEW |
MAIN.BOT_VALUE_DATE < GLOBAL.Application_date |
DESTINATION_Q:= 'SPECIAL'; |
Back Valued Contract |
13 |
FX |
NEW |
CHECK_NAME |
DESTINATION_Q:= 'SPECIAL'; |
Counterparty has Check Name Flag |
14 |
FX |
NEW |
NVL(MAIN.CLS_SWAP_FLAG,'X') = 'I' |
DESTINATION_Q:= 'SPECIAL'; |
CLS In/Out Swap In Leg |
15 |
FX |
NEW |
NVL(MAIN.CLS_SWAP_FLAG,'X') = 'O' |
DESTINATION_Q:= 'SPECIAL'; |
CLS In/Out Swap Out Leg |
16 |
FX |
NEW |
NOT IS_FULLY_ENRICHED |
DESTINATION_Q:= 'ENRICH'; |
Not fully enriched |
17 |
FX |
NEW |
CONTRACT_NOT_FOUND |
DESTINATION_Q:= 'REPAIR'; |
Contract not found in Product Processor |
18 |
FX |
AMEND |
BOT_HOLIDAY = 'H' |
DESTINATION_Q:= 'REPAIR'; |
Bought Value Date is Holiday |
19 |
FX |
AMEND |
SOLD_HOLIDAY = 'H' |
DESTINATION_Q:= 'REPAIR'; |
Sold Value Date is Holiday |
20 |
FX |
AMEND |
BOT_HOLIDAY = 'X' |
DESTINATION_Q:= 'REPAIR'; |
Bought currency holiday not maintained |
21 |
FX |
AMEND |
SOLD_HOLIDAY = 'X' |
DESTINATION_Q:= 'REPAIR'; |
Sold currency holiday not maintained |
22 |
FX |
AMEND |
CUTOFF_NOT_FOUND = 'BOTH' |
DESTINATION_Q:= 'REPAIR'; |
Cutoff Maintenance NOT found for both pay and recv side |
23 |
FX |
AMEND |
CUTOFF_NOT_FOUND = 'PAY' |
DESTINATION_Q:= 'REPAIR'; |
Cutoff Maintenance NOT found for pay side |
24 |
FX |
AMEND |
CUTOFF_NOT_FOUND = 'RECV' |
DESTINATION_Q:= 'REPAIR'; |
Cutoff Maintenance NOT found for receive side |
25 |
FX |
AMEND |
MAIN.SPECIAL_Q = 'Y' |
DESTINATION_Q:= 'SPECIAL'; |
|
26 |
FX |
AMEND |
(NOT IS_FULLY_ENRICHED) |
DESTINATION_Q:= 'ENRICH'; |
Not fully enriched |
27 |
FX |
AMEND |
MAIN.SPECIAL_HANDLING_CODE IN ('Y','HVP','DVP','FOP') |
DESTINATION_Q:= 'SPECIAL'; |
Special handling requested by trader |
28 |
FX |
AMEND |
NVL(TXN_REC.CLS_ELIGIBLE,'N') = 'N' AND ((NVL(MAIN.PAY_CUTOFF,GLOBAL.Application_date+1) < GLOBAL.Application_date AND si_rec.PAY_INSTRUCTION_TYPE='O') OR (NVL(MAIN.RECV_CUTOFF,GLOBAL.Application_date+1) < GLOBAL.Application_date AND si_rec.RECV_INSTRUCTION_TYPE='O')) |
DESTINATION_Q:= 'SPECIAL'; |
Past Cut off Time |
29 |
FX |
AMEND |
MSG_SENT_OUT AND NVL(MAIN.CANC_RE_BOOK,'N') = 'Y' |
DESTINATION_Q:= 'AMEND'; |
Settlement message handed off |
30 |
FX |
AMEND |
DEAL_MATURED |
DESTINATION_Q:= 'AMEND'; |
Original deal has liquidated |
31 |
FX |
AMEND |
MAIN.REPAIR_Q = 'Y' |
DESTINATION_Q:= 'AMEND'; |
Amendment for a Repair Contract |
32 |
FX |
AMEND |
NVL(MAIN.CANC_RE_BOOK,'N') = 'Y' |
DESTINATION_Q:= 'REBOOK'; |
Financial Amendment |
33 |
FX |
AMEND |
MAIN.AMEND_Q = 'Y' |
DESTINATION_Q:= 'AMEND'; |
|
34 |
FX |
AMEND |
DESTINATION_Q IS NULL |
DESTINATION_Q:= 'AMEND'; |
Incoming amendment |
35 |
FX |
CANC |
CONTRACT_NOT_FOUND |
DESTINATION_Q:= 'REPAIR'; |
Contract not found in Product Processor |
36 |
FX |
CANC |
MAIN.SPECIAL_Q = 'Y' |
DESTINATION_Q:= 'SPECIAL'; |
|
37 |
FX |
CANC |
MAIN.SPECIAL_HANDLING_CODE IN ('Y','HVP','DVP','FOP') |
DESTINATION_Q:= 'SPECIAL'; |
Special handling requested by trader |
38 |
FX |
CANC |
MAIN.SPECIAL_Q = 'Y' |
DESTINATION_Q:= 'SPECIAL'; |
|
39 |
FX |
CANC |
DEAL_MATURED |
DESTINATION_Q:= 'AMEND'; |
Original deal has liquidated |
40 |
FX |
CANC |
MAIN.REPAIR_Q = 'Y' |
DESTINATION_Q:= 'AMEND'; |
Amendment for a Repair Contract |
41 |
FX |
CANC |
NVL(MAIN.AMEND_Q,'N')='Y' |
DESTINATION_Q:= 'AMEND'; |
Table A-2 System Tags
S.No | Tag | Module | Data Type | Prog Tag |
---|---|---|---|---|
1 |
APP_DATE_TIME |
FX |
Date |
FXQP.APP_DATE_TIME |
2 |
APRVD_REC |
FX |
Record |
FXQP.PKG_APRVD_REC |
3 |
BOT_AUTOUPLD |
FX |
Character |
FXQP.BOT_AUTOUPLD |
4 |
BOT_HOLIDAY |
FX |
Character |
FXQP.HOL_BOT_DATE |
5 |
BUSINESS_DATE |
FX |
Date |
GLOBAL.APPLICATION_DATE |
6 |
CHECK_NAME |
FX |
Boolean |
FXQP.CHK_NAME |
7 |
CLS_WITHIN_CUTOFF |
FX |
Boolean |
FXQP.CLS_WITHIN_CUTOFF |
8 |
CONTRACT_NOT_FOUND |
FX |
Boolean |
FXQP.PKG_CONT_MISSING |
9 |
CONT_REC |
FX |
Record |
FXQP.PKG_CONT_REC |
10 |
CUTOFF_NOT_FOUND |
FX |
Character |
FXQP.G_NO_CUTOFF_MAINT |
11 |
DEAL_MATURED |
FX |
Boolean |
FXQP.DEAL_MATURED |
12 |
ENRICH_SI |
FX |
FXQP.ENRICH_SI |
|
13 |
INVALID_AFTER_PMSG |
FX |
Boolean |
FXQP.PKG_INVALID_AGENT_AFTER_PMSG |
14 |
INVALID_AFTER_PMSG1 |
FX |
Boolean |
FXQP.PKG_INVALID_AGENT_AFTER_PMSG |
15 |
INVALID_BEFORE_PMSG |
FX |
Boolean |
FXQP.PKG_INVALID_AGENT_BEFORE_PMSG |
16 |
INVALID_BEFORE_PMSG1 |
FX |
Boolean |
FXQP.PKG_INVALID_AGENT_BEFORE_PMSG |
17 |
INVALID_CCY_PAIR |
FX |
Boolean |
FXQP.INV_CCY_PAIR |
18 |
INVALID_CUSTOMER |
FX |
Boolean |
FXQP.INV_CUST |
19 |
IS_FIN_AMEND |
FX |
Boolean |
FXQP.IS_FIN_AMEND |
20 |
IS_FULLY_ENRICHED |
FX |
Boolean |
FXQP.IS_FULLY_ENRICHED |
21 |
IS_PAY_ENRICHED |
FX |
Boolean |
FXQP.IS_PAY_ENRICHED |
22 |
IS_RECV_ENRICHED |
FX |
Boolean |
FXQP.IS_RECV_ENRICHED |
23 |
MAIN |
FX |
Character |
TXN_REC. |
24 |
MATCH_SI |
FX |
Boolean |
FXQP.MATCH_SI |
25 |
MSG_SENT_OUT |
FX |
Boolean |
FXQP.MSG_SENT_OUT |
26 |
NDF_DEAL |
FX |
Character |
FXQP.NDF_DEAL |
27 |
PARENT_CONT_NOT_FOUND |
FX |
Boolean |
FXQP.PKG_PRNT_MISSING |
28 |
PKG_APRVD_MISSING |
FX |
Boolean |
FXQP.PKG_APRVD_MISSING |
29 |
PREV_REC |
FX |
Record |
FXQP.PKG_PREV_REC |
30 |
PRNT_REC |
FX |
Record |
FXQP.PKG_PRNT_REC |
31 |
QUEUE_REASON |
FX |
Character |
P_Q_REASON |
32 |
RESOLVE_SI |
FX |
ALL |
|
33 |
RETURN_FAILURE |
FX |
RET:= -1; RETURN |
|
34 |
RETURN_SUCCESS |
FX |
RET:= 0; RETURN |
|
35 |
SAME_AS_PREV_APPROVED |
FX |
Boolean |
FXQP.SAME_AS_APRVD |
36 |
SI_AUTO_UPL_FOUND |
FX |
Boolean |
FXQP.SI_AUTOUPL_FND |
37 |
SI_MATCHED |
FX |
Boolean |
FXQP.SI_MATCHED |
38 |
SI_REC |
FX |
Record |
FXQP.PKG_SETTLE_REC |
39 |
SI_SENT |
FX |
Boolean |
FXQP.SI_SENT |
40 |
SI_TYPE_FOUND |
FX |
Character |
FXQP.SITYP_FND |
41 |
SOLD_AUTOUPLD |
FX |
Character |
FXQP.SOLD_AUTOUPLD |
42 |
SOLD_HOLIDAY |
FX |
Character |
FXQP.HOL_SOLD_DATE |
43 |
SUNDRY_DEAL_MATCHED |
FX |
Character |
FXQP.G_SUNDRY_MATCH_IND |
44 |
TRADE_DATE |
FX |
Character |
|
45 |
TXN_REC |
FX |
Record |
FXQP.PKG_TXN_REC |