eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TEST_API dependencies on FND_MSG_PUB

Line 639: FND_MSG_PUB.Add;

635: WHEN NO_DATA_FOUND THEN
636: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
637: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','BATCH_SOURCE_ID: '||sqlerrm);
638: write_message(substr(fnd_message.get,1,200));
639: FND_MSG_PUB.Add;
640: x_user_key_id := -9999;
641: WHEN OTHERS THEN
642: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
643: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','BATCH_SOURCE_ID: '||sqlerrm);

Line 645: FND_MSG_PUB.Add;

641: WHEN OTHERS THEN
642: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
643: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','BATCH_SOURCE_ID: '||sqlerrm);
644: write_message(substr(fnd_message.get,1,200));
645: FND_MSG_PUB.Add;
646: x_user_key_id := -9999;
647: END;
648: END IF;
649:

Line 679: FND_MSG_PUB.Add;

675: WHEN NO_DATA_FOUND THEN
676: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
677: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INTERNAL_ORG_ID: '||sqlerrm);
678: write_message(substr(fnd_message.get,1,200));
679: FND_MSG_PUB.Add;
680: x_user_key_id := -9999;
681: WHEN OTHERS THEN
682: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
683: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INTERNAL_ORG_ID: '||sqlerrm);

Line 685: FND_MSG_PUB.Add;

681: WHEN OTHERS THEN
682: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
683: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INTERNAL_ORG_ID: '||sqlerrm);
684: write_message(substr(fnd_message.get,1,200));
685: FND_MSG_PUB.Add;
686: x_user_key_id := -9999;
687: END;
688: END IF;
689:

Line 730: FND_MSG_PUB.Add;

726: WHEN NO_DATA_FOUND THEN
727: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
728: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error for '||p_user_key_type||' '||sqlerrm);
729: write_message(substr(fnd_message.get,1,200));
730: FND_MSG_PUB.Add;
731: x_user_key_id := -9999;
732: WHEN OTHERS THEN
733: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
734: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error for '||p_user_key_type||' '||sqlerrm);

Line 736: FND_MSG_PUB.Add;

732: WHEN OTHERS THEN
733: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
734: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error for '||p_user_key_type||' '||sqlerrm);
735: write_message(substr(fnd_message.get,1,200));
736: FND_MSG_PUB.Add;
737: x_user_key_id := -9999;
738: END;
739: END IF;
740:

Line 773: FND_MSG_PUB.Add;

769: WHEN NO_DATA_FOUND THEN
770: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
771: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','LEDGER_ID: '||sqlerrm);
772: write_message(substr(fnd_message.get,1,200));
773: FND_MSG_PUB.Add;
774: x_user_key_id := -9999;
775: WHEN OTHERS THEN
776: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
777: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','LEDGER_ID: '||sqlerrm);

Line 779: FND_MSG_PUB.Add;

775: WHEN OTHERS THEN
776: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
777: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','LEDGER_ID: '||sqlerrm);
778: write_message(substr(fnd_message.get,1,200));
779: FND_MSG_PUB.Add;
780: x_user_key_id := -9999;
781: END;
782: END IF;
783:

Line 848: FND_MSG_PUB.Add;

844: WHEN NO_DATA_FOUND THEN
845: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
846: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','LEGAL ENTITY ID: '||sqlerrm);
847: write_message(substr(fnd_message.get,1,200));
848: FND_MSG_PUB.Add;
849: RAISE_APPLICATION_ERROR (-20000,'Error while calculating LEGAL_ENTITY_ID with user key'||p_user_key_string|| sqlerrm);
850:
851: WHEN OTHERS THEN
852: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

Line 855: FND_MSG_PUB.Add;

851: WHEN OTHERS THEN
852: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
853: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','LEGAL ENTITY ID: '||sqlerrm);
854: write_message(substr(fnd_message.get,1,200));
855: FND_MSG_PUB.Add;
856: RAISE_APPLICATION_ERROR (-20000, 'Error while calculating LEGAL_ENTITY_ID with user key'||p_user_key_string||sqlerrm);
857: END;
858: END IF;
859:

Line 1077: FND_MSG_PUB.Add;

1073: write_message('No location was found. Please review your data');
1074: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1075: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','SHIP TO LOCATION ID: '||sqlerrm);
1076: write_message(substr(fnd_message.get,1,200));
1077: FND_MSG_PUB.Add;
1078:
1079: WHEN TOO_MANY_ROWS THEN
1080: ----------------------------------------------------------------------
1081: -- If multiple locations are found, error out.

Line 1087: FND_MSG_PUB.Add;

1083: write_message('Multiple locations were found. Please review your data');
1084: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1085: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','SHIP TO LOCATION ID: '||sqlerrm);
1086: write_message(substr(fnd_message.get,1,200));
1087: FND_MSG_PUB.Add;
1088:
1089: WHEN OTHERS THEN
1090: ----------------------------------------------------------------------
1091: --If other issue, error out.

Line 1097: FND_MSG_PUB.Add;

1093: write_message('Not able to retrieve the Location. Please review your data');
1094: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1095: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','SHIP TO LOCATION ID: '||sqlerrm);
1096: write_message(substr(fnd_message.get,1,200));
1097: FND_MSG_PUB.Add;
1098: END;
1099:
1100: ELSIF l_flow = 'O2C' THEN
1101: write_message('~ Table to get Ship to Location is HZ_LOCATIONS');

Line 1138: FND_MSG_PUB.Add;

1134: write_message(' No Data Found. Location cannot be found. Please review your data');
1135: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1136: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','SHIP TO LOCATION ID: '||sqlerrm);
1137: write_message(substr(fnd_message.get,1,200));
1138: FND_MSG_PUB.Add;
1139:
1140: WHEN OTHERS THEN
1141: --------------------------------------------------------------------
1142: -- If location not found, error out

Line 1148: FND_MSG_PUB.Add;

1144: write_message(' Others error. Location cannot be found. Please review your data');
1145: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1146: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','SHIP TO LOCATION ID: '||sqlerrm);
1147: write_message(substr(fnd_message.get,1,200));
1148: FND_MSG_PUB.Add;
1149:
1150: END;
1151:
1152: WHEN TOO_MANY_ROWS THEN

Line 1160: FND_MSG_PUB.Add;

1156: write_message('Multiple locations were found. Please review your data');
1157: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1158: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','SHIP TO LOCATION ID: '||sqlerrm);
1159: write_message(substr(fnd_message.get,1,200));
1160: FND_MSG_PUB.Add;
1161:
1162: WHEN OTHERS THEN
1163: ----------------------------------------------------------------------
1164: -- In multiple locations are found, the error out.

Line 1170: FND_MSG_PUB.Add;

1166: write_message('Multiple locations were found. Please review your data');
1167: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1168: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','SHIP TO LOCATION ID: '||sqlerrm);
1169: write_message(substr(fnd_message.get,1,200));
1170: FND_MSG_PUB.Add;
1171:
1172: END;
1173: END IF;
1174: END IF;

Line 1280: FND_MSG_PUB.Add;

1276: WHEN NO_DATA_FOUND THEN
1277: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1278: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACCOUNT_CCID: '||sqlerrm);
1279: write_message(substr(fnd_message.get,1,200));
1280: FND_MSG_PUB.Add;
1281: x_user_key_id := -9999;
1282: WHEN OTHERS THEN
1283: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1284: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACCOUNT_CCID: '||sqlerrm);

Line 1286: FND_MSG_PUB.Add;

1282: WHEN OTHERS THEN
1283: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1284: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACCOUNT_CCID: '||sqlerrm);
1285: write_message(substr(fnd_message.get,1,200));
1286: FND_MSG_PUB.Add;
1287: x_user_key_id := -9999;
1288: END;
1289: END IF;
1290:

Line 1320: FND_MSG_PUB.Add;

1316: WHEN NO_DATA_FOUND THEN
1317: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1318: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','DOC SEQ ID: '||sqlerrm);
1319: write_message(substr(fnd_message.get,1,200));
1320: FND_MSG_PUB.Add;
1321: x_user_key_id := -9999;
1322: WHEN OTHERS THEN
1323: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1324: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','DOC SEQ ID: '||sqlerrm);

Line 1326: FND_MSG_PUB.Add;

1322: WHEN OTHERS THEN
1323: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1324: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','DOC SEQ ID: '||sqlerrm);
1325: write_message(substr(fnd_message.get,1,200));
1326: FND_MSG_PUB.Add;
1327: x_user_key_id := -9999;
1328: END;
1329: END IF;
1330:

Line 1472: FND_MSG_PUB.Add;

1468: WHEN NO_DATA_FOUND THEN
1469: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1470: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error for'||p_user_key_type||' '||sqlerrm);
1471: write_message(substr(sqlerrm,1,200));
1472: FND_MSG_PUB.Add;
1473: x_user_key_id := -9999;
1474:
1475: WHEN TOO_MANY_ROWS THEN
1476: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

Line 1481: FND_MSG_PUB.Add;

1477: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error for'||
1478: p_user_key_type|| ' the vendor_site_code'|| l_varchar2_id1 ||
1479: 'is not unique in table PO_VENDOR_SITES_ALL. '||sqlerrm);
1480: write_message(substr(sqlerrm,1,200));
1481: FND_MSG_PUB.Add;
1482: x_user_key_id := -9999;
1483: WHEN OTHERS THEN
1484: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1485: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error for'||p_user_key_type||' '||sqlerrm);

Line 1487: FND_MSG_PUB.Add;

1483: WHEN OTHERS THEN
1484: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1485: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error for'||p_user_key_type||' '||sqlerrm);
1486: write_message(substr(sqlerrm,1,200));
1487: FND_MSG_PUB.Add;
1488: x_user_key_id := -9999;
1489: FND_MSG_PUB.Add;
1490: x_user_key_id := -9999;
1491: END;

Line 1489: FND_MSG_PUB.Add;

1485: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error for'||p_user_key_type||' '||sqlerrm);
1486: write_message(substr(sqlerrm,1,200));
1487: FND_MSG_PUB.Add;
1488: x_user_key_id := -9999;
1489: FND_MSG_PUB.Add;
1490: x_user_key_id := -9999;
1491: END;
1492: END;
1493: END IF;

Line 1631: FND_MSG_PUB.Add;

1627: WHEN TOO_MANY_ROWS THEN
1628: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1629: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','TOO MANY ROWS PARTY_REC: '||sqlerrm);
1630: write_message(substr(fnd_message.get,1,200));
1631: FND_MSG_PUB.Add;
1632: WHEN NO_DATA_FOUND THEN
1633: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1634: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','NO DATA FOUND PARTY_REC: '||sqlerrm);
1635: write_message(substr(fnd_message.get,1,200));

Line 1636: FND_MSG_PUB.Add;

1632: WHEN NO_DATA_FOUND THEN
1633: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1634: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','NO DATA FOUND PARTY_REC: '||sqlerrm);
1635: write_message(substr(fnd_message.get,1,200));
1636: FND_MSG_PUB.Add;
1637: WHEN OTHERS THEN
1638: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1639: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','OTHERS PARTY_REC: '||sqlerrm);
1640: write_message(substr(fnd_message.get,1,200));

Line 1641: FND_MSG_PUB.Add;

1637: WHEN OTHERS THEN
1638: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
1639: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','OTHERS PARTY_REC: '||sqlerrm);
1640: write_message(substr(fnd_message.get,1,200));
1641: FND_MSG_PUB.Add;
1642: END put_data_in_party_rec;
1643:
1644:
1645: /* ================================================================================*

Line 7429: FND_MSG_PUB.Add;

7425: WHEN NO_DATA_FOUND THEN
7426: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7427: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Fetching event type code in cancel logic: '||sqlerrm);
7428: write_message(substr(fnd_message.get,1,200));
7429: FND_MSG_PUB.Add;
7430: WHEN OTHERS THEN
7431: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7432: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Fetching Event type Code in cancel logic: '||sqlerrm);
7433: write_message(substr(fnd_message.get,1,200));

Line 7434: FND_MSG_PUB.Add;

7430: WHEN OTHERS THEN
7431: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7432: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Fetching Event type Code in cancel logic: '||sqlerrm);
7433: write_message(substr(fnd_message.get,1,200));
7434: FND_MSG_PUB.Add;
7435: END;
7436:
7437:
7438: -----------------------------------------------------------

Line 7532: FND_MSG_PUB.Add;

7528: WHEN NO_DATA_FOUND THEN
7529: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7530: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Tax Only Lines Flag: '||sqlerrm);
7531: write_message(substr(fnd_message.get,1,200));
7532: FND_MSG_PUB.Add;
7533: WHEN OTHERS THEN
7534: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7535: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Tax Only Lines Flag: '||sqlerrm);
7536: write_message(substr(fnd_message.get,1,200));

Line 7537: FND_MSG_PUB.Add;

7533: WHEN OTHERS THEN
7534: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7535: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Tax Only Lines Flag: '||sqlerrm);
7536: write_message(substr(fnd_message.get,1,200));
7537: FND_MSG_PUB.Add;
7538: END;
7539:
7540: IF l_flag = 'X' THEN
7541:

Line 7641: FND_MSG_PUB.Add;

7637: WHEN NO_DATA_FOUND THEN
7638: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7639: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Event Type for Tax event type CANCEL in Cancel Logic: '||sqlerrm);
7640: write_message(substr(fnd_message.get,1,200));
7641: FND_MSG_PUB.Add;
7642: WHEN OTHERS THEN
7643: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7644: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Event Type Code for Tax Event type CANCEL in Cancel Logic: '||sqlerrm);
7645: write_message(substr(fnd_message.get,1,200));

Line 7646: FND_MSG_PUB.Add;

7642: WHEN OTHERS THEN
7643: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7644: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Event Type Code for Tax Event type CANCEL in Cancel Logic: '||sqlerrm);
7645: write_message(substr(fnd_message.get,1,200));
7646: FND_MSG_PUB.Add;
7647: END;
7648:
7649: ----------------------------------------------------------------------
7650: -- Call global_document_update

Line 7685: FND_MSG_PUB.Add;

7681: WHEN NO_DATA_FOUND THEN
7682: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7683: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Deriving Event type code for Tax event type release_code in Cancel Logic: '||sqlerrm);
7684: write_message(substr(fnd_message.get,1,200));
7685: FND_MSG_PUB.Add;
7686: WHEN OTHERS THEN
7687: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7688: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Deriving Event type code for Tax event type release_code in Cancel Logic: '||sqlerrm);
7689: write_message(substr(fnd_message.get,1,200));

Line 7690: FND_MSG_PUB.Add;

7686: WHEN OTHERS THEN
7687: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
7688: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Deriving Event type code for Tax event type release_code in Cancel Logic: '||sqlerrm);
7689: write_message(substr(fnd_message.get,1,200));
7690: FND_MSG_PUB.Add;
7691: END;
7692:
7693: ----------------------------------------------------------------------
7694: -- Call global_document_update

Line 7768: l_mesg := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);

7764: --loop and put the messages in a PL/SQL table.
7765: -----------------------------------------------------------
7766: write_message('Retrieving multiple messages returned by API...');
7767: LOOP
7768: l_mesg := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
7769: IF l_mesg IS NULL THEN
7770: EXIT;
7771: ELSE
7772: write_message(l_mesg);

Line 8152: FND_MSG_PUB.Add;

8148: write_message('~ EVENT_CLS_CODE:'||p_evnt_cls_code);
8149: write_message('~ EVENT_TYP_CODE:'||p_evnt_typ_code);
8150:
8151: FND_MESSAGE.SET_NAME('ZX','ZX_EVNT_TYP_MPG_INVALID');
8152: FND_MSG_PUB.Add;
8153: Return null;
8154:
8155: END Get_Tax_Event_Type;
8156: