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_MESSAGE

Line 636: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

632: where org_id = l_num_id
633: and name = l_varchar2_id;
634: EXCEPTION
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;

Line 637: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','BATCH_SOURCE_ID: '||sqlerrm);

633: and name = l_varchar2_id;
634: EXCEPTION
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

Line 638: write_message(substr(fnd_message.get,1,200));

634: EXCEPTION
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');

Line 642: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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);
644: write_message(substr(fnd_message.get,1,200));
645: FND_MSG_PUB.Add;
646: x_user_key_id := -9999;

Line 643: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','BATCH_SOURCE_ID: '||sqlerrm);

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);
644: write_message(substr(fnd_message.get,1,200));
645: FND_MSG_PUB.Add;
646: x_user_key_id := -9999;
647: END;

Line 644: write_message(substr(fnd_message.get,1,200));

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);
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;

Line 676: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

672: where business_group_id = l_num_id
673: and name = l_varchar2_id;
674: EXCEPTION
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;

Line 677: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INTERNAL_ORG_ID: '||sqlerrm);

673: and name = l_varchar2_id;
674: EXCEPTION
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

Line 678: write_message(substr(fnd_message.get,1,200));

674: EXCEPTION
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');

Line 682: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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);
684: write_message(substr(fnd_message.get,1,200));
685: FND_MSG_PUB.Add;
686: x_user_key_id := -9999;

Line 683: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','INTERNAL_ORG_ID: '||sqlerrm);

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);
684: write_message(substr(fnd_message.get,1,200));
685: FND_MSG_PUB.Add;
686: x_user_key_id := -9999;
687: END;

Line 684: write_message(substr(fnd_message.get,1,200));

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);
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;

Line 727: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

723: where application_short_name = l_varchar2_id;
724:
725: EXCEPTION
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;

Line 728: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error for '||p_user_key_type||' '||sqlerrm);

724:
725: EXCEPTION
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

Line 729: write_message(substr(fnd_message.get,1,200));

725: EXCEPTION
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');

Line 733: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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);
735: write_message(substr(fnd_message.get,1,200));
736: FND_MSG_PUB.Add;
737: x_user_key_id := -9999;

Line 734: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error for '||p_user_key_type||' '||sqlerrm);

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);
735: write_message(substr(fnd_message.get,1,200));
736: FND_MSG_PUB.Add;
737: x_user_key_id := -9999;
738: END;

Line 735: write_message(substr(fnd_message.get,1,200));

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);
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;

Line 770: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

766: where name = l_varchar2_id;
767:
768: EXCEPTION
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;

Line 771: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','LEDGER_ID: '||sqlerrm);

767:
768: EXCEPTION
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

Line 772: write_message(substr(fnd_message.get,1,200));

768: EXCEPTION
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');

Line 776: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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);
778: write_message(substr(fnd_message.get,1,200));
779: FND_MSG_PUB.Add;
780: x_user_key_id := -9999;

Line 777: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','LEDGER_ID: '||sqlerrm);

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);
778: write_message(substr(fnd_message.get,1,200));
779: FND_MSG_PUB.Add;
780: x_user_key_id := -9999;
781: END;

Line 778: write_message(substr(fnd_message.get,1,200));

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);
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;

Line 845: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

841: and hz_pty.party_number = l_party_number;
842:
843: EXCEPTION
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);

Line 846: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','LEGAL ENTITY ID: '||sqlerrm);

842:
843: EXCEPTION
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:

Line 847: write_message(substr(fnd_message.get,1,200));

843: EXCEPTION
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

Line 852: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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');
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);

Line 853: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','LEGAL ENTITY ID: '||sqlerrm);

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');
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;

Line 854: write_message(substr(fnd_message.get,1,200));

850:
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;

Line 1074: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1070: ----------------------------------------------------------------------
1071: -- If no location is found, error out.
1072: ----------------------------------------------------------------------
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:

Line 1075: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','SHIP TO LOCATION ID: '||sqlerrm);

1071: -- If no location is found, error out.
1072: ----------------------------------------------------------------------
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

Line 1076: write_message(substr(fnd_message.get,1,200));

1072: ----------------------------------------------------------------------
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: ----------------------------------------------------------------------

Line 1084: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1080: ----------------------------------------------------------------------
1081: -- If multiple locations are found, error out.
1082: ----------------------------------------------------------------------
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:

Line 1085: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','SHIP TO LOCATION ID: '||sqlerrm);

1081: -- If multiple locations are found, error out.
1082: ----------------------------------------------------------------------
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

Line 1086: write_message(substr(fnd_message.get,1,200));

1082: ----------------------------------------------------------------------
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: ----------------------------------------------------------------------

Line 1094: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1090: ----------------------------------------------------------------------
1091: --If other issue, error out.
1092: ----------------------------------------------------------------------
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;

Line 1095: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','SHIP TO LOCATION ID: '||sqlerrm);

1091: --If other issue, error out.
1092: ----------------------------------------------------------------------
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:

Line 1096: write_message(substr(fnd_message.get,1,200));

1092: ----------------------------------------------------------------------
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

Line 1135: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1131: --------------------------------------------------------------------
1132: -- If location not found, error out
1133: --------------------------------------------------------------------
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:

Line 1136: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','SHIP TO LOCATION ID: '||sqlerrm);

1132: -- If location not found, error out
1133: --------------------------------------------------------------------
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

Line 1137: write_message(substr(fnd_message.get,1,200));

1133: --------------------------------------------------------------------
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: --------------------------------------------------------------------

Line 1145: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1141: --------------------------------------------------------------------
1142: -- If location not found, error out
1143: --------------------------------------------------------------------
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:

Line 1146: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','SHIP TO LOCATION ID: '||sqlerrm);

1142: -- If location not found, error out
1143: --------------------------------------------------------------------
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;

Line 1147: write_message(substr(fnd_message.get,1,200));

1143: --------------------------------------------------------------------
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:

Line 1157: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1153: ----------------------------------------------------------------------
1154: -- If multiple locations are found, the error out.
1155: ----------------------------------------------------------------------
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:

Line 1158: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','SHIP TO LOCATION ID: '||sqlerrm);

1154: -- If multiple locations are found, the error out.
1155: ----------------------------------------------------------------------
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

Line 1159: write_message(substr(fnd_message.get,1,200));

1155: ----------------------------------------------------------------------
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: ----------------------------------------------------------------------

Line 1167: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1163: ----------------------------------------------------------------------
1164: -- In multiple locations are found, the error out.
1165: ----------------------------------------------------------------------
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:

Line 1168: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','SHIP TO LOCATION ID: '||sqlerrm);

1164: -- In multiple locations are found, the error out.
1165: ----------------------------------------------------------------------
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;

Line 1169: write_message(substr(fnd_message.get,1,200));

1165: ----------------------------------------------------------------------
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;

Line 1277: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1273: x_user_key_id := FND_FLEX_EXT.GET_CCID('SQLGL','GL#',l_chrt_acct_id,sysdate,p_user_key_string);
1274:
1275: EXCEPTION
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;

Line 1278: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACCOUNT_CCID: '||sqlerrm);

1274:
1275: EXCEPTION
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

Line 1279: write_message(substr(fnd_message.get,1,200));

1275: EXCEPTION
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');

Line 1283: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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);
1285: write_message(substr(fnd_message.get,1,200));
1286: FND_MSG_PUB.Add;
1287: x_user_key_id := -9999;

Line 1284: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ACCOUNT_CCID: '||sqlerrm);

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);
1285: write_message(substr(fnd_message.get,1,200));
1286: FND_MSG_PUB.Add;
1287: x_user_key_id := -9999;
1288: END;

Line 1285: write_message(substr(fnd_message.get,1,200));

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);
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;

Line 1317: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1313: where name = l_varchar2_id;
1314:
1315: EXCEPTION
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;

Line 1318: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','DOC SEQ ID: '||sqlerrm);

1314:
1315: EXCEPTION
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

Line 1319: write_message(substr(fnd_message.get,1,200));

1315: EXCEPTION
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');

Line 1323: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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);
1325: write_message(substr(fnd_message.get,1,200));
1326: FND_MSG_PUB.Add;
1327: x_user_key_id := -9999;

Line 1324: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','DOC SEQ ID: '||sqlerrm);

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);
1325: write_message(substr(fnd_message.get,1,200));
1326: FND_MSG_PUB.Add;
1327: x_user_key_id := -9999;
1328: END;

Line 1325: write_message(substr(fnd_message.get,1,200));

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);
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;

Line 1469: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1465: and org_id = l_num_id;*/
1466: END IF;
1467: EXCEPTION
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;

Line 1470: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error for'||p_user_key_type||' '||sqlerrm);

1466: END IF;
1467: EXCEPTION
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:

Line 1476: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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');
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));

Line 1477: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error for'||

1473: x_user_key_id := -9999;
1474:
1475: WHEN TOO_MANY_ROWS THEN
1476: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');
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;

Line 1484: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

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);
1486: write_message(substr(sqlerrm,1,200));
1487: FND_MSG_PUB.Add;
1488: x_user_key_id := -9999;

Line 1485: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Error for'||p_user_key_type||' '||sqlerrm);

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);
1486: write_message(substr(sqlerrm,1,200));
1487: FND_MSG_PUB.Add;
1488: x_user_key_id := -9999;
1489: FND_MSG_PUB.Add;

Line 1628: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

1624: and event_class_code = g_suite_rec_tbl.event_class_code(p_header_row) ;
1625: END IF;
1626: EXCEPTION
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

Line 1629: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','TOO MANY ROWS PARTY_REC: '||sqlerrm);

1625: END IF;
1626: EXCEPTION
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');

Line 1630: write_message(substr(fnd_message.get,1,200));

1626: EXCEPTION
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);

Line 1633: 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));
1636: FND_MSG_PUB.Add;
1637: WHEN OTHERS THEN

Line 1634: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','NO DATA FOUND 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));
1636: FND_MSG_PUB.Add;
1637: WHEN OTHERS THEN
1638: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

Line 1635: 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));
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);

Line 1638: 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));
1641: FND_MSG_PUB.Add;
1642: END put_data_in_party_rec;

Line 1639: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','OTHERS 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));
1641: FND_MSG_PUB.Add;
1642: END put_data_in_party_rec;
1643:

Line 1640: 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));
1641: FND_MSG_PUB.Add;
1642: END put_data_in_party_rec;
1643:
1644:

Line 7426: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

7422: AND tax_event_type_code = 'UPDATE';
7423:
7424: EXCEPTION
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

Line 7427: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Fetching event type code in cancel logic: '||sqlerrm);

7423:
7424: EXCEPTION
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');

Line 7428: write_message(substr(fnd_message.get,1,200));

7424: EXCEPTION
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);

Line 7431: 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));
7434: FND_MSG_PUB.Add;
7435: END;

Line 7432: 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));
7434: FND_MSG_PUB.Add;
7435: END;
7436:

Line 7433: 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));
7434: FND_MSG_PUB.Add;
7435: END;
7436:
7437:

Line 7529: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

7525: AND tax_only_line_flag= 'Y';
7526:
7527: EXCEPTION
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

Line 7530: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Tax Only Lines Flag: '||sqlerrm);

7526:
7527: EXCEPTION
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');

Line 7531: write_message(substr(fnd_message.get,1,200));

7527: EXCEPTION
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);

Line 7534: 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));
7537: FND_MSG_PUB.Add;
7538: END;

Line 7535: 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));
7537: FND_MSG_PUB.Add;
7538: END;
7539:

Line 7536: 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));
7537: FND_MSG_PUB.Add;
7538: END;
7539:
7540: IF l_flag = 'X' THEN

Line 7638: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

7634: AND tax_event_type_code = 'CANCEL';
7635:
7636: EXCEPTION
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

Line 7639: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Event Type for Tax event type CANCEL in Cancel Logic: '||sqlerrm);

7635:
7636: EXCEPTION
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');

Line 7640: write_message(substr(fnd_message.get,1,200));

7636: EXCEPTION
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);

Line 7643: 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));
7646: FND_MSG_PUB.Add;
7647: END;

Line 7644: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Event Type Code 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));
7646: FND_MSG_PUB.Add;
7647: END;
7648:

Line 7645: 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));
7646: FND_MSG_PUB.Add;
7647: END;
7648:
7649: ----------------------------------------------------------------------

Line 7682: FND_MESSAGE.SET_NAME('ZX','GENERIC_MESSAGE');

7678: AND event_class_code = g_suite_rec_tbl.EVENT_CLASS_CODE(l_initial_row)
7679: AND tax_event_type_code = 'RELEASE_HOLD';
7680: EXCEPTION
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

Line 7683: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Deriving Event type code for Tax event type release_code in Cancel Logic: '||sqlerrm);

7679: AND tax_event_type_code = 'RELEASE_HOLD';
7680: EXCEPTION
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');

Line 7684: write_message(substr(fnd_message.get,1,200));

7680: EXCEPTION
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);

Line 7687: 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));
7690: FND_MSG_PUB.Add;
7691: END;

Line 7688: 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));
7690: FND_MSG_PUB.Add;
7691: END;
7692:

Line 7689: 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));
7690: FND_MSG_PUB.Add;
7691: END;
7692:
7693: ----------------------------------------------------------------------

Line 8151: FND_MESSAGE.SET_NAME('ZX','ZX_EVNT_TYP_MPG_INVALID');

8147: write_message('~ ENTITY_CODE :'||p_entity_code);
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;