DBA Data[Home] [Help]

APPS.AP_ISP_UTILITIES_PKG dependencies on FND_MESSAGE

Line 623: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

619: EXCEPTION
620: WHEN OTHERS THEN
621: IF (SQLCODE <> -20001) THEN
622: rollback;
623: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
624: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
625: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
626: FND_MESSAGE.SET_TOKEN('PARAMETERS',
627: ' P_invoice_id = ' || P_invoice_id

Line 624: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

620: WHEN OTHERS THEN
621: IF (SQLCODE <> -20001) THEN
622: rollback;
623: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
624: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
625: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
626: FND_MESSAGE.SET_TOKEN('PARAMETERS',
627: ' P_invoice_id = ' || P_invoice_id
628: ||' P_last_updated_by = ' || P_last_updated_by

Line 625: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

621: IF (SQLCODE <> -20001) THEN
622: rollback;
623: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
624: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
625: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
626: FND_MESSAGE.SET_TOKEN('PARAMETERS',
627: ' P_invoice_id = ' || P_invoice_id
628: ||' P_last_updated_by = ' || P_last_updated_by
629: ||' P_last_update_login = ' || P_last_update_login

Line 626: FND_MESSAGE.SET_TOKEN('PARAMETERS',

622: rollback;
623: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
624: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
625: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
626: FND_MESSAGE.SET_TOKEN('PARAMETERS',
627: ' P_invoice_id = ' || P_invoice_id
628: ||' P_last_updated_by = ' || P_last_updated_by
629: ||' P_last_update_login = ' || P_last_update_login
630: ||' P_accounting_date = ' || P_accounting_date);

Line 631: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

627: ' P_invoice_id = ' || P_invoice_id
628: ||' P_last_updated_by = ' || P_last_updated_by
629: ||' P_last_update_login = ' || P_last_update_login
630: ||' P_accounting_date = ' || P_accounting_date);
631: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
632: END IF;
633:
634: APP_EXCEPTION.RAISE_EXCEPTION;
635:

Line 748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

744: EXCEPTION
745: WHEN OTHERS THEN
746: IF (SQLCODE <> -20001) THEN
747: rollback;
748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
751: FND_MESSAGE.SET_TOKEN('PARAMETERS',
752: ' P_invoice_id = ' || p_invoice_id

Line 749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

745: WHEN OTHERS THEN
746: IF (SQLCODE <> -20001) THEN
747: rollback;
748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
751: FND_MESSAGE.SET_TOKEN('PARAMETERS',
752: ' P_invoice_id = ' || p_invoice_id
753: ||' P_line_number = ' || p_line_number

Line 750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

746: IF (SQLCODE <> -20001) THEN
747: rollback;
748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
751: FND_MESSAGE.SET_TOKEN('PARAMETERS',
752: ' P_invoice_id = ' || p_invoice_id
753: ||' P_line_number = ' || p_line_number
754: ||' P_last_updated_by = ' || P_last_updated_by

Line 751: FND_MESSAGE.SET_TOKEN('PARAMETERS',

747: rollback;
748: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
749: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
750: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
751: FND_MESSAGE.SET_TOKEN('PARAMETERS',
752: ' P_invoice_id = ' || p_invoice_id
753: ||' P_line_number = ' || p_line_number
754: ||' P_last_updated_by = ' || P_last_updated_by
755: ||' P_last_update_login = ' || P_last_update_login

Line 757: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

753: ||' P_line_number = ' || p_line_number
754: ||' P_last_updated_by = ' || P_last_updated_by
755: ||' P_last_update_login = ' || P_last_update_login
756: ||' P_calling_mode = ' || p_calling_mode);
757: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
758: END IF;
759:
760: APP_EXCEPTION.RAISE_EXCEPTION;
761:

Line 913: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

909: EXCEPTION
910: WHEN OTHERS THEN
911: IF (SQLCODE <> -20001) THEN
912: rollback;
913: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
914: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
915: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
916: FND_MESSAGE.SET_TOKEN('PARAMETERS',
917: ' P_invoice_id = ' || p_invoice_id

Line 914: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

910: WHEN OTHERS THEN
911: IF (SQLCODE <> -20001) THEN
912: rollback;
913: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
914: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
915: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
916: FND_MESSAGE.SET_TOKEN('PARAMETERS',
917: ' P_invoice_id = ' || p_invoice_id
918: ||' P_org_id = ' || p_org_id);

Line 915: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

911: IF (SQLCODE <> -20001) THEN
912: rollback;
913: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
914: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
915: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
916: FND_MESSAGE.SET_TOKEN('PARAMETERS',
917: ' P_invoice_id = ' || p_invoice_id
918: ||' P_org_id = ' || p_org_id);
919: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 916: FND_MESSAGE.SET_TOKEN('PARAMETERS',

912: rollback;
913: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
914: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
915: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
916: FND_MESSAGE.SET_TOKEN('PARAMETERS',
917: ' P_invoice_id = ' || p_invoice_id
918: ||' P_org_id = ' || p_org_id);
919: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
920: END IF;

Line 919: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

915: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
916: FND_MESSAGE.SET_TOKEN('PARAMETERS',
917: ' P_invoice_id = ' || p_invoice_id
918: ||' P_org_id = ' || p_org_id);
919: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
920: END IF;
921:
922: APP_EXCEPTION.RAISE_EXCEPTION;
923:

Line 993: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

989: EXCEPTION
990: WHEN OTHERS THEN
991: IF (SQLCODE <> -20001) THEN
992: rollback;
993: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
994: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
995: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
996: FND_MESSAGE.SET_TOKEN('PARAMETERS',
997: ' P_invoice_id = ' || p_invoice_id

Line 994: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

990: WHEN OTHERS THEN
991: IF (SQLCODE <> -20001) THEN
992: rollback;
993: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
994: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
995: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
996: FND_MESSAGE.SET_TOKEN('PARAMETERS',
997: ' P_invoice_id = ' || p_invoice_id
998: ||', P_calling_mode = ' || p_calling_mode

Line 995: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

991: IF (SQLCODE <> -20001) THEN
992: rollback;
993: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
994: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
995: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
996: FND_MESSAGE.SET_TOKEN('PARAMETERS',
997: ' P_invoice_id = ' || p_invoice_id
998: ||', P_calling_mode = ' || p_calling_mode
999: ||', P_override_status = ' || p_override_status

Line 996: FND_MESSAGE.SET_TOKEN('PARAMETERS',

992: rollback;
993: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
994: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
995: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
996: FND_MESSAGE.SET_TOKEN('PARAMETERS',
997: ' P_invoice_id = ' || p_invoice_id
998: ||', P_calling_mode = ' || p_calling_mode
999: ||', P_override_status = ' || p_override_status
1000: ||', P_event_id = ' || P_event_id

Line 1002: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

998: ||', P_calling_mode = ' || p_calling_mode
999: ||', P_override_status = ' || p_override_status
1000: ||', P_event_id = ' || P_event_id
1001: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1002: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1003: END IF;
1004:
1005: APP_EXCEPTION.RAISE_EXCEPTION;
1006:

Line 1061: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1057: EXCEPTION
1058: WHEN OTHERS THEN
1059: IF (SQLCODE <> -20001) THEN
1060: rollback;
1061: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1062: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1063: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1064: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1065: ' P_invoice_id = ' || p_invoice_id

Line 1062: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1058: WHEN OTHERS THEN
1059: IF (SQLCODE <> -20001) THEN
1060: rollback;
1061: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1062: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1063: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1064: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1065: ' P_invoice_id = ' || p_invoice_id
1066: ||', P_calling_sequence = ' || l_curr_calling_sequence);

Line 1063: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

1059: IF (SQLCODE <> -20001) THEN
1060: rollback;
1061: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1062: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1063: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1064: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1065: ' P_invoice_id = ' || p_invoice_id
1066: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1067: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 1064: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1060: rollback;
1061: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1062: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1063: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1064: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1065: ' P_invoice_id = ' || p_invoice_id
1066: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1067: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1068: END IF;

Line 1067: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1063: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1064: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1065: ' P_invoice_id = ' || p_invoice_id
1066: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1067: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1068: END IF;
1069:
1070: APP_EXCEPTION.RAISE_EXCEPTION;
1071:

Line 1140: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1136: EXCEPTION
1137: WHEN OTHERS THEN
1138: IF (SQLCODE <> -20001) THEN
1139: rollback;
1140: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1141: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1143: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1144: ' P_invoice_id = ' || p_invoice_id

Line 1141: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1137: WHEN OTHERS THEN
1138: IF (SQLCODE <> -20001) THEN
1139: rollback;
1140: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1141: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1143: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1144: ' P_invoice_id = ' || p_invoice_id
1145: ||', P_calling_sequence = ' || l_curr_calling_sequence);

Line 1142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

1138: IF (SQLCODE <> -20001) THEN
1139: rollback;
1140: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1141: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1143: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1144: ' P_invoice_id = ' || p_invoice_id
1145: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1146: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 1143: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1139: rollback;
1140: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1141: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1143: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1144: ' P_invoice_id = ' || p_invoice_id
1145: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1146: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1147: END IF;

Line 1146: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1143: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1144: ' P_invoice_id = ' || p_invoice_id
1145: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1146: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1147: END IF;
1148:
1149: APP_EXCEPTION.RAISE_EXCEPTION;
1150:

Line 1311: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1307: EXCEPTION
1308: WHEN OTHERS THEN
1309: IF (SQLCODE <> -20001) THEN
1310: rollback;
1311: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1312: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1313: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1314: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1315: ' P_invoice_id = ' || p_invoice_id

Line 1312: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1308: WHEN OTHERS THEN
1309: IF (SQLCODE <> -20001) THEN
1310: rollback;
1311: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1312: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1313: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1314: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1315: ' P_invoice_id = ' || p_invoice_id
1316: || ', sequence_numbering = ' || p_sequence_numbering

Line 1313: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

1309: IF (SQLCODE <> -20001) THEN
1310: rollback;
1311: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1312: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1313: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1314: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1315: ' P_invoice_id = ' || p_invoice_id
1316: || ', sequence_numbering = ' || p_sequence_numbering
1317: ||', P_calling_sequence = ' || l_curr_calling_sequence);

Line 1314: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1310: rollback;
1311: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1312: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1313: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1314: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1315: ' P_invoice_id = ' || p_invoice_id
1316: || ', sequence_numbering = ' || p_sequence_numbering
1317: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1318: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 1318: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1314: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1315: ' P_invoice_id = ' || p_invoice_id
1316: || ', sequence_numbering = ' || p_sequence_numbering
1317: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1318: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1319: END IF;
1320:
1321: APP_EXCEPTION.RAISE_EXCEPTION;
1322:

Line 1442: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1438: EXCEPTION
1439: WHEN OTHERS THEN
1440: IF (SQLCODE <> -20001) THEN
1441: rollback;
1442: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1443: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1444: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1445: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1446: ' P_invoice_id = ' || p_invoice_id

Line 1443: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1439: WHEN OTHERS THEN
1440: IF (SQLCODE <> -20001) THEN
1441: rollback;
1442: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1443: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1444: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1445: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1446: ' P_invoice_id = ' || p_invoice_id
1447: ||', P_calling_sequence = ' || l_curr_calling_sequence);

Line 1444: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

1440: IF (SQLCODE <> -20001) THEN
1441: rollback;
1442: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1443: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1444: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1445: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1446: ' P_invoice_id = ' || p_invoice_id
1447: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1448: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 1445: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1441: rollback;
1442: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1443: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1444: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1445: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1446: ' P_invoice_id = ' || p_invoice_id
1447: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1448: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1449: END IF;

Line 1448: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1444: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1445: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1446: ' P_invoice_id = ' || p_invoice_id
1447: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1448: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1449: END IF;
1450:
1451: APP_EXCEPTION.RAISE_EXCEPTION;
1452:

Line 1673: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1669: EXCEPTION
1670: WHEN OTHERS THEN
1671: IF (SQLCODE <> -20001) THEN
1672: rollback;
1673: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1674: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1675: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1676: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1677: ' P_invoice_id = ' || p_invoice_id

Line 1674: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1670: WHEN OTHERS THEN
1671: IF (SQLCODE <> -20001) THEN
1672: rollback;
1673: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1674: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1675: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1676: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1677: ' P_invoice_id = ' || p_invoice_id
1678: ||', P_calling_sequence = ' || l_curr_calling_sequence);

Line 1675: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

1671: IF (SQLCODE <> -20001) THEN
1672: rollback;
1673: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1674: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1675: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1676: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1677: ' P_invoice_id = ' || p_invoice_id
1678: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1679: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 1676: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1672: rollback;
1673: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1674: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1675: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1676: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1677: ' P_invoice_id = ' || p_invoice_id
1678: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1679: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1680: END IF;

Line 1679: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1675: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1676: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1677: ' P_invoice_id = ' || p_invoice_id
1678: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1679: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1680: END IF;
1681:
1682: APP_EXCEPTION.RAISE_EXCEPTION;
1683:

Line 1792: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1788: EXCEPTION
1789: WHEN OTHERS THEN
1790: IF (SQLCODE <> -20001) THEN
1791: rollback;
1792: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1793: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1794: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1795: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1796: ' P_invoice_id = ' || p_invoice_id

Line 1793: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1789: WHEN OTHERS THEN
1790: IF (SQLCODE <> -20001) THEN
1791: rollback;
1792: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1793: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1794: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1795: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1796: ' P_invoice_id = ' || p_invoice_id
1797: || ', invoice_line_number = ' || l_invoice_line_number

Line 1794: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

1790: IF (SQLCODE <> -20001) THEN
1791: rollback;
1792: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1793: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1794: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1795: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1796: ' P_invoice_id = ' || p_invoice_id
1797: || ', invoice_line_number = ' || l_invoice_line_number
1798: ||', P_calling_sequence = ' || l_curr_calling_sequence);

Line 1795: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1791: rollback;
1792: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1793: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1794: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1795: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1796: ' P_invoice_id = ' || p_invoice_id
1797: || ', invoice_line_number = ' || l_invoice_line_number
1798: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1799: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 1799: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1795: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1796: ' P_invoice_id = ' || p_invoice_id
1797: || ', invoice_line_number = ' || l_invoice_line_number
1798: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1799: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1800: END IF;
1801:
1802: If (Invoice_Lines_Cur%ISOPEN) Then
1803: CLOSE invoice_lines_cur;

Line 1897: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1893: EXCEPTION
1894: WHEN OTHERS THEN
1895: IF (SQLCODE <> -20001) THEN
1896: rollback;
1897: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1898: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1899: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1900: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1901: ' P_user_id = ' || p_user_id

Line 1898: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1894: WHEN OTHERS THEN
1895: IF (SQLCODE <> -20001) THEN
1896: rollback;
1897: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1898: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1899: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1900: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1901: ' P_user_id = ' || p_user_id
1902: || ', p_attr_code = ' || p_attr_code

Line 1899: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

1895: IF (SQLCODE <> -20001) THEN
1896: rollback;
1897: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1898: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1899: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1900: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1901: ' P_user_id = ' || p_user_id
1902: || ', p_attr_code = ' || p_attr_code
1903: ||', P_calling_sequence = ' || l_curr_calling_sequence);

Line 1900: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1896: rollback;
1897: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1898: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1899: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1900: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1901: ' P_user_id = ' || p_user_id
1902: || ', p_attr_code = ' || p_attr_code
1903: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1904: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 1904: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1900: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1901: ' P_user_id = ' || p_user_id
1902: || ', p_attr_code = ' || p_attr_code
1903: ||', P_calling_sequence = ' || l_curr_calling_sequence);
1904: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1905: END IF;
1906:
1907: APP_EXCEPTION.RAISE_EXCEPTION;
1908:

Line 1935: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

1931:
1932: EXCEPTION when others then
1933:
1934: IF (SQLCODE <> -20001) THEN
1935: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1936: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1937: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'P_hold_id = '|| p_hold_id);
1938: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1939: END IF;

Line 1936: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1932: EXCEPTION when others then
1933:
1934: IF (SQLCODE <> -20001) THEN
1935: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1936: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1937: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'P_hold_id = '|| p_hold_id);
1938: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1939: END IF;
1940:

Line 1937: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'P_hold_id = '|| p_hold_id);

1933:
1934: IF (SQLCODE <> -20001) THEN
1935: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1936: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1937: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'P_hold_id = '|| p_hold_id);
1938: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1939: END IF;
1940:
1941: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1938: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

1934: IF (SQLCODE <> -20001) THEN
1935: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1936: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1937: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'P_hold_id = '|| p_hold_id);
1938: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1939: END IF;
1940:
1941: APP_EXCEPTION.RAISE_EXCEPTION;
1942: END Release_Hold;

Line 2197: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

2193:
2194: EXCEPTION
2195: WHEN OTHERS THEN
2196: IF (SQLCODE <> -20001) THEN
2197: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2198: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2199: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2200: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2201: END IF;

Line 2198: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

2194: EXCEPTION
2195: WHEN OTHERS THEN
2196: IF (SQLCODE <> -20001) THEN
2197: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2198: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2199: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2200: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2201: END IF;
2202:

Line 2199: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

2195: WHEN OTHERS THEN
2196: IF (SQLCODE <> -20001) THEN
2197: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2198: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2199: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2200: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2201: END IF;
2202:
2203: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2200: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

2196: IF (SQLCODE <> -20001) THEN
2197: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2198: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2199: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2200: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2201: END IF;
2202:
2203: APP_EXCEPTION.RAISE_EXCEPTION;
2204: