B MM Queue Conditions and System Tags
This topic describes the MM queue conditions and system tags.
Table B-1 MM Queue Conditions
| Module | ACTION | Cond Text | Cond Action | Queue Reason |
|---|---|---|---|---|
|
MM |
NEW |
INVALID_CUSTOMER |
DESTINATION_Q:= 'REPAIR'; |
Invalid Base No - Product Code defaulted |
|
MM |
NEW |
INVALID_CCY |
DESTINATION_Q:= 'REPAIR'; |
Invalid Currency |
|
MM |
NEW |
PRODUCT_TYPE = 'D' AND VALUE_HOLIDAY = 'H' |
DESTINATION_Q:= 'SPECIAL'; |
Receive date is Holiday |
|
MM |
NEW |
PRODUCT_TYPE = 'D' AND MATURITY_HOLIDAY = 'H' |
DESTINATION_Q:= 'SPECIAL'; |
Pay date is Holiday |
|
MM |
NEW |
PRODUCT_TYPE = 'L' AND VALUE_HOLIDAY = 'H' |
DESTINATION_Q:= 'SPECIAL'; |
Pay date is Holiday |
|
MM |
NEW |
PRODUCT_TYPE = 'L' AND MATURITY_HOLIDAY = 'H' |
DESTINATION_Q:= 'SPECIAL'; |
Receive date is Holiday |
|
MM |
NEW |
MATURITY_HOLIDAY = 'X' |
DESTINATION_Q:= 'REPAIR'; |
Currency holiday not maintained |
|
MM |
NEW |
VALUE_HOLIDAY = 'X' |
DESTINATION_Q:= 'REPAIR'; |
Currency holiday not maintained |
|
MM |
NEW |
NOT IS_FULLY_ENRICHED |
DESTINATION_Q:= 'ENRICH';DESTINATION_Q:= 'STP'; |
Not fully enriched |
|
MM |
NEW |
MAIN.SPECIAL_HANDLING_CODE IN ('Y','HVP','DVP','FOP') |
DESTINATION_Q:= 'SPECIAL' |
Special handling requested by trader |
|
MM |
NEW |
MAIN.SPECIAL_HANDLING_CODE IN ('Y','HVP','DVP','FOP') |
DESTINATION_Q:= 'SPECIAL'; |
Special handling requested by trader |
|
MM |
NEW |
MAIN.VALUE_DATE < GLOBAL.Application_date OR MAIN.MATURITY_DATE < GLOBAL.Application_date |
DESTINATION_Q:= 'SPECIAL'; |
Back Valued Contract |
|
MM |
NEW |
(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 |
|
MM |
NEW |
CHECK_NAME |
DESTINATION_Q:= 'SPECIAL'; |
Counterparty has Check Name Flag |
|
MM |
NEW |
(MAIN.VALUE_DATE = GLOBAL.APPLICATION_DATE) AND NOT IS_FULLY_ENRICHED |
DESTINATION_Q:= 'SPECIAL'; |
Special handling requested for Current dated Unenriched Trade |
|
MM |
NEW |
SI_TYPE_FOUND = 'U' |
DESTINATION_Q:= 'ENRICH'; |
Usual SI Exists |
|
MM |
NEW |
SI_TYPE_FOUND = 'S' |
DESTINATION_Q:= 'ENRICH'; |
Standard SI Exists |
|
MM |
NEW |
SI_TYPE_FOUND IS NULL |
DESTINATION_Q:= 'ENRICH'; |
SI Not found |
|
MM |
NEW |
SI_TYPE_FOUND = 'N' |
DESTINATION_Q:= 'ENRICH'; |
|
|
MM |
NEW |
SI_TYPE_FOUND = 'S' |
DESTINATION_Q:= 'ENRICH'; |
STANDARD SI EXISTS |
|
MM |
ROLL |
PARENT_CONT_NOT_FOUND |
DESTINATION_Q:= 'REPAIR'; |
Parent Contract Not Found |
|
MM |
AMEND |
CONTRACT_NOT_FOUND |
DESTINATION_Q:= 'REPAIR'; |
Contract not found in Product Processor |
|
MM |
AMEND |
MSG_SENT_OUT |
DESTINATION_Q:= 'AMEND'; |
Settlement message handed off |
|
MM |
AMEND |
MAIN.SPECIAL_Q = 'Y' |
DESTINATION_Q:= 'SPECIAL'; |
Already in Special Queue |
|
MM |
AMEND |
NOT IS_FULLY_ENRICHED |
DESTINATION_Q:= 'ENRICH'; |
Not fully enriched |
|
MM |
AMEND |
MAIN.SPECIAL_HANDLING_CODE IN ('Y','HVP','DVP','FOP') |
DESTINATION_Q:= 'SPECIAL'; |
Special handling requested by trader |
|
MM |
AMEND |
PRODUCT_TYPE = 'L' AND MATURITY_HOLIDAY = 'H' |
DESTINATION_Q:= 'SPECIAL'; |
Receive date is Holiday |
|
MM |
AMEND |
PRODUCT_TYPE = 'D' AND VALUE_HOLIDAY = 'H' |
DESTINATION_Q:= 'SPECIAL'; |
Receive date is Holiday |
|
MM |
AMEND |
PRODUCT_TYPE = 'D' AND MATURITY_HOLIDAY = 'H' |
DESTINATION_Q:= 'SPECIAL'; |
Pay date is Holiday |
|
MM |
AMEND |
PRODUCT_TYPE = 'L' AND VALUE_HOLIDAY = 'H' |
DESTINATION_Q:= 'SPECIAL'; |
Pay date is Holiday |
|
MM |
AMEND |
MATURITY_HOLIDAY = 'X' |
DESTINATION_Q:= 'REPAIR'; |
Currency Holiday not maintained |
|
MM |
AMEND |
VALUE_HOLIDAY = 'X' |
DESTINATION_Q:= 'REPAIR'; |
Currency Holiday not maintained |
|
MM |
AMEND |
DEAL_MATURED |
DESTINATION_Q:= 'AMEND'; |
Original deal has liquidated |
|
MM |
AMEND |
MAIN.REPAIR_Q = 'Y' |
DESTINATION_Q:= 'AMEND'; |
Amendment for a Repair Contract |
|
MM |
AMEND |
MAIN.REPAIR_Q = 'Y' |
DESTINATION_Q:= 'AMEND'; |
Amendment for a Repair Contract |
|
MM |
AMEND |
NVL(PREV_REC.PAY_GEN_MESSAGE,'N')='N' AND NVL(TXN_REC.PAY_GEN_MESSAGE,'N')='Y' |
DESTINATION_Q:= 'AMEND'; |
Original deal had pay message suppressed |
|
MM |
AMEND |
(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 |
|
MM |
AMEND |
SAME_AS_PREV_APPROVED |
DESTINATION_Q:= 'STP'; |
Same as prev version |
|
MM |
AMEND |
MAIN.SETTLE_MSG_SENT = 'Y' |
DESTINATION_Q:= 'AMEND'; |
Sgen done |
|
MM |
AMEND |
MAIN.MATURITY_DATE >= GLOBAL.Application_date |
DESTINATION_Q:= 'AMEND'; |
Deal matured |
|
MM |
AMEND |
MAIN.CONTRACT_STATUS = 'L' |
DESTINATION_Q:= 'AMEND'; |
Deal is liquidated |
|
MM |
CANC |
CONTRACT_NOT_FOUND |
DESTINATION_Q:= 'REPAIR'; |
Contract not found in Product Processor |
|
MM |
CANC |
MAIN.SPECIAL_Q = 'Y' |
DESTINATION_Q:= 'SPECIAL'; |
|
|
MM |
CANC |
MAIN.REPAIR_Q = 'Y' |
DESTINATION_Q:= 'AMEND'; |
Amendment for a Repair Contract |
|
MM |
CANC |
MSG_SENT_OUT |
DESTINATION_Q:= 'AMEND'; |
Settlement message handed off |
|
MM |
CANC |
DEAL_MATURED |
DESTINATION_Q:= 'AMEND'; |
Original deal has liquidated |
|
MM |
CANC |
NVL(MAIN.AMEND_Q,'N')='Y' |
DESTINATION_Q:= 'AMEND'; |
|
|
MM |
CANC |
MAIN.SPECIAL_HANDLING_CODE IN ('Y','HVP','DVP','FOP') |
DESTINATION_Q:= 'SPECIAL'; |
Special handling requested by trader |
|
MM |
Roll |
NVL(MAIN.ROLLOVER_ALLOWED,'N')='Y' AND PARENT_SGEN_DONE |
DESTINATION_Q:= 'REPAIR'; |
Cannot rollover deal. Settlement message sent out for parent. |
|
MM |
Roll |
NVL(MAIN.ROLLOVER_ALLOWED,'N')='Y' AND ROLL_DIFF |
DESTINATION_Q:= 'REPAIR'; |
Cannot rollover deal. Parent deal rolled with different amount. |
|
MM |
Roll |
NVL(MAIN.ROLLOVER_ALLOWED,'N')='Y' AND PARENT_LIQUIDATED |
DESTINATION_Q:= 'REPAIR'; |
Cannot rollover deal. Parent contract already liquidated without rolling over. |
|
MM |
Roll |
NOT IS_FULLY_ENRICHED |
DESTINATION_Q:= 'ENRICH';DESTINATION_Q:= 'STP'; |
Not fully enriched |
|
MM |
Roll |
MAIN.MATURITY_DATE < GLOBAL.Application_date |
DESTINATION_Q:= 'SPECIAL'; |
Back Valued roll |
|
MM |
Roll |
MAIN.SPECIAL_HANDLING_CODE IN ('Y','HVP','DVP','FOP') |
DESTINATION_Q:= 'SPECIAL'; |
Special handling requested by trader |
|
MM |
Roll |
((NVL(PARENT.AMOUNT,0) + NVL(PARENT.INTEREST_AMOUNT,0)) = NVL(MAIN.AMOUNT,0)) AND PARENT.ENRICH_Q = 'Y' |
DESTINATION_Q:= 'ENRICH'; |
Settlement Incomplete |
|
MM |
Roll |
((NVL(PARENT.AMOUNT,0) + NVL(PARENT.INTEREST_AMOUNT,0)) = NVL(MAIN.AMOUNT,0)) AND PARENT.ENRICH_Q = 'N' |
DESTINATION_Q:= 'ENRICH';PARENT.ENRICH_Q:= 'Y'; |
Re - Enter Settlements |
Table B-2 MM System Tags
| Tag | Module | Data Type | Prog Tag |
|---|---|---|---|
|
APPROVED. |
MM |
Character |
MMQP.PKG_APPRVD.REC. |
|
APP_DATE_TIME |
MM |
Date |
MMQP.APP_DATE_TIME |
|
BUSINESS_DATE |
MM |
Date |
GLOBAL.APPLICATION_DATE |
|
CHECK_NAME |
MM |
Boolean |
MMQP.CHK_NAME |
|
CONTRACT_NOT_FOUND |
MM |
Boolean |
MMQP.PKG_CONT_MISSING |
|
DEAL_MATURED |
MM |
Boolean |
MMQP.DEAL_MATURED |
|
INVALID_AFTER_PMSG1 |
MM |
Boolean |
MMQP.PKG_INVALID_AGENT_AFTER_PMSG |
|
INVALID_BEFORE_PMSG |
MM |
Boolean |
MMQP.PKG_INVALID_AGENT_BEFORE_PMSG |
|
INVALID_CCY |
MM |
Boolean |
MMQP.INV_CCY |
|
INVALID_CUSTOMER |
MM |
Boolean |
MMQP.INV_CUST |
|
INVALID_SI |
MM |
Boolean |
MMQP.PKG_INVALID_SI |
|
INVALID_SI_SENT |
MM |
Boolean |
MMQP.PKG_INVALID_SI |
|
IS_FIN_AMEND |
MM |
Boolean |
MMQP.IS_FIN_AMEND |
|
IS_FULLY_ENRICHED |
MM |
Boolean |
MMQP.IS_FULLY_ENRICHED |
|
IS_PAY_ENRICHED |
MM |
Boolean |
MMQP.IS_PAY_ENRICHED |
|
IS_RECV_ENRICHED |
MM |
Boolean |
MMQP.IS_RECV_ENRICHED |
|
MAIN. |
MM |
Character |
MMQP.PKG_TXN_REC. |
|
MATCH_SI |
MM |
Boolean |
MMQP.MATCH_SI |
|
MATURITY_HOLIDAY |
MM |
Character |
MMQP.MATURITY_HOLIDAY |
|
MM_BREAK |
MM |
Boolean |
MMQP.MM_BREAK |
|
MSG_SENT_OUT |
MM |
Boolean |
MMQP.MSG_SENT_OUT |
|
NO_APPROVED_RECORD |
MM |
Boolean |
MMQP.PKG_APPRVD_MISSING |
|
PARENT. |
MM |
Character |
MMQP.PKG_PRNT_REC. |
|
PARENT_CONT_NOT_FOUND |
MM |
Boolean |
MMQP.PKG_PRNT_MISSING |
|
PKG_APRVD_MISSING |
MM |
Boolean |
MMQP.PKG_APRVD_MISSING |
|
PARENT_LIQUIDATED |
MM |
Boolean |
MMQP.PKG_PARENT_DEAL_MATURED |
|
PARENT_SETTLE. |
MM |
MMQP.PKG_PRNT_SETTLE |
|
|
PARENT_SGEN_DONE |
MM |
Boolean |
MMQP.PKG_PARENT_SGEN_DONE |
|
PREV_REC |
MM |
Record |
MMQP.PKG_PREV_REC MWTBS_CONTRACT_MASTER |
|
PRNT_REC |
MM |
Record |
MMQP.PKG_PRNT_REC |
|
PRODUCT_TYPE |
MM |
Character |
MMQP.PKG_PRODUCT_TYPE |
|
QUEUE_REASON |
MM |
Character |
P_Q_REASON |
|
RESOLVE_SI |
MM |
MMQP.RESOLVE_SI |
|
|
RESULT_OF_RULE- |
MM |
Rule Result |
RES_RL |
|
RETURN_FAILURE |
MM |
RET:= -1; RETURN |
|
|
RETURN_SUCCESS |
MM |
RET:= 0; RETURN |
|
|
ROLL_DIFF |
MM |
Boolean |
MMQP.PKG_ROLL_DIFF |
|
SAME_AS_PREV_APPROVED |
MM |
Boolean |
MMQP.SAME_AS_APRVD |
|
SETTLE. |
MM |
Character |
MMQP.PKG_SETTLE_REC. |
|
SI_AUTO_UPL_FOUND |
MM |
Boolean |
MMQP.SI_AUTOUPL_FND |
|
SI_MATCHED |
MM |
Boolean |
MMQP.SI_MATCHED |
|
SI_REC |
MM |
Record |
MMQP.PKG_SETTLE_REC |
|
SI_SENT |
MM |
Boolean |
MMQP.SI_SENT |
|
SI_TYPE_FOUND |
MM |
Character |
MMQP.SITYP_FND |
|
TXN_REC |
MM |
Record |
MMQP.PKG_TXN_REC |
|
VALUE_HOLIDAY |
MM |
Character |
MMQP.VALUE_HOLIDAY |
|
WALKIN_CUST |
MM |
Boolean |
MMQP.WALKIN |