801:
802: EXCEPTION
803: WHEN OTHERS THEN
804: IF (SQLCODE <> -20001) THEN
805: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
806: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
807: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
808: FND_MESSAGE.SET_TOKEN('PARAMETERS',
809: ' P_Invoice_Id = '||P_Invoice_Id||
802: EXCEPTION
803: WHEN OTHERS THEN
804: IF (SQLCODE <> -20001) THEN
805: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
806: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
807: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
808: FND_MESSAGE.SET_TOKEN('PARAMETERS',
809: ' P_Invoice_Id = '||P_Invoice_Id||
810: ' P_Calling_Mode ='||P_Calling_Mode||
803: WHEN OTHERS THEN
804: IF (SQLCODE <> -20001) THEN
805: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
806: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
807: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
808: FND_MESSAGE.SET_TOKEN('PARAMETERS',
809: ' P_Invoice_Id = '||P_Invoice_Id||
810: ' P_Calling_Mode ='||P_Calling_Mode||
811: ' P_Error_Code = '||P_Error_Code||
804: IF (SQLCODE <> -20001) THEN
805: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
806: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
807: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
808: FND_MESSAGE.SET_TOKEN('PARAMETERS',
809: ' P_Invoice_Id = '||P_Invoice_Id||
810: ' P_Calling_Mode ='||P_Calling_Mode||
811: ' P_Error_Code = '||P_Error_Code||
812: ' P_Calling_Sequence = '||P_Calling_Sequence);
809: ' P_Invoice_Id = '||P_Invoice_Id||
810: ' P_Calling_Mode ='||P_Calling_Mode||
811: ' P_Error_Code = '||P_Error_Code||
812: ' P_Calling_Sequence = '||P_Calling_Sequence);
813: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
814: END IF;
815:
816: APP_EXCEPTION.RAISE_EXCEPTION;
817:
1095:
1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: IF (SQLCODE <> -20001) THEN
1099: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1100: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1101: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1102: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1103: ' P_Invoice_Id = '||P_Invoice_Id||
1096: EXCEPTION
1097: WHEN OTHERS THEN
1098: IF (SQLCODE <> -20001) THEN
1099: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1100: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1101: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1102: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1103: ' P_Invoice_Id = '||P_Invoice_Id||
1104: ' P_Calling_Mode ='||P_Calling_Mode||
1097: WHEN OTHERS THEN
1098: IF (SQLCODE <> -20001) THEN
1099: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1100: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1101: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1102: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1103: ' P_Invoice_Id = '||P_Invoice_Id||
1104: ' P_Calling_Mode ='||P_Calling_Mode||
1105: ' P_Error_Code = '||P_Error_Code||
1098: IF (SQLCODE <> -20001) THEN
1099: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1100: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1101: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1102: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1103: ' P_Invoice_Id = '||P_Invoice_Id||
1104: ' P_Calling_Mode ='||P_Calling_Mode||
1105: ' P_Error_Code = '||P_Error_Code||
1106: ' P_Calling_Sequence = '||P_Calling_Sequence);
1103: ' P_Invoice_Id = '||P_Invoice_Id||
1104: ' P_Calling_Mode ='||P_Calling_Mode||
1105: ' P_Error_Code = '||P_Error_Code||
1106: ' P_Calling_Sequence = '||P_Calling_Sequence);
1107: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1108: END IF;
1109:
1110: APP_EXCEPTION.RAISE_EXCEPTION;
1111:
1669:
1670: EXCEPTION
1671: WHEN OTHERS THEN
1672: IF (SQLCODE <> -20001) THEN
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||
1670: EXCEPTION
1671: WHEN OTHERS THEN
1672: IF (SQLCODE <> -20001) THEN
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_Mode ='||P_Calling_Mode||
1671: WHEN OTHERS THEN
1672: IF (SQLCODE <> -20001) THEN
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_Mode ='||P_Calling_Mode||
1679: ' P_Error_Code = '||P_Error_Code||
1672: IF (SQLCODE <> -20001) THEN
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_Mode ='||P_Calling_Mode||
1679: ' P_Error_Code = '||P_Error_Code||
1680: ' P_Calling_Sequence = '||P_Calling_Sequence);
1677: ' P_Invoice_Id = '||P_Invoice_Id||
1678: ' P_Calling_Mode ='||P_Calling_Mode||
1679: ' P_Error_Code = '||P_Error_Code||
1680: ' P_Calling_Sequence = '||P_Calling_Sequence);
1681: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1682: END IF;
1683:
1684: APP_EXCEPTION.RAISE_EXCEPTION;
1685:
1814:
1815: EXCEPTION
1816: WHEN OTHERS THEN
1817: IF (SQLCODE <> -20001) THEN
1818: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1819: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1820: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1821: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1822: ' P_Invoice_Id = '||P_Invoice_Id||
1815: EXCEPTION
1816: WHEN OTHERS THEN
1817: IF (SQLCODE <> -20001) THEN
1818: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1819: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1820: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1821: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1822: ' P_Invoice_Id = '||P_Invoice_Id||
1823: ' P_Calling_Mode ='||P_Calling_Mode||
1816: WHEN OTHERS THEN
1817: IF (SQLCODE <> -20001) THEN
1818: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1819: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1820: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1821: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1822: ' P_Invoice_Id = '||P_Invoice_Id||
1823: ' P_Calling_Mode ='||P_Calling_Mode||
1824: ' P_Error_Code = '||P_Error_Code||
1817: IF (SQLCODE <> -20001) THEN
1818: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1819: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1820: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1821: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1822: ' P_Invoice_Id = '||P_Invoice_Id||
1823: ' P_Calling_Mode ='||P_Calling_Mode||
1824: ' P_Error_Code = '||P_Error_Code||
1825: ' P_Calling_Sequence = '||P_Calling_Sequence);
1822: ' P_Invoice_Id = '||P_Invoice_Id||
1823: ' P_Calling_Mode ='||P_Calling_Mode||
1824: ' P_Error_Code = '||P_Error_Code||
1825: ' P_Calling_Sequence = '||P_Calling_Sequence);
1826: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1827: END IF;
1828:
1829: APP_EXCEPTION.RAISE_EXCEPTION;
1830:
2026:
2027: EXCEPTION
2028: WHEN OTHERS THEN
2029: IF (SQLCODE <> -20001) THEN
2030: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2031: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2032: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2033: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2034: ' P_Invoice_Id = '||P_Invoice_Id||
2027: EXCEPTION
2028: WHEN OTHERS THEN
2029: IF (SQLCODE <> -20001) THEN
2030: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2031: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2032: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2033: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2034: ' P_Invoice_Id = '||P_Invoice_Id||
2035: ' P_Calling_Mode ='||P_Calling_Mode||
2028: WHEN OTHERS THEN
2029: IF (SQLCODE <> -20001) THEN
2030: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2031: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2032: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2033: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2034: ' P_Invoice_Id = '||P_Invoice_Id||
2035: ' P_Calling_Mode ='||P_Calling_Mode||
2036: ' P_Error_Code = '||P_Error_Code||
2029: IF (SQLCODE <> -20001) THEN
2030: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2031: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2032: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2033: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2034: ' P_Invoice_Id = '||P_Invoice_Id||
2035: ' P_Calling_Mode ='||P_Calling_Mode||
2036: ' P_Error_Code = '||P_Error_Code||
2037: ' P_Calling_Sequence = '||P_Calling_Sequence);
2034: ' P_Invoice_Id = '||P_Invoice_Id||
2035: ' P_Calling_Mode ='||P_Calling_Mode||
2036: ' P_Error_Code = '||P_Error_Code||
2037: ' P_Calling_Sequence = '||P_Calling_Sequence);
2038: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2039: END IF;
2040:
2041: APP_EXCEPTION.RAISE_EXCEPTION;
2042: END Import_Interface;
2402:
2403: EXCEPTION
2404: WHEN OTHERS THEN
2405: IF (SQLCODE <> -20001) THEN
2406: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2407: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2408: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2409: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2410: ' P_Invoice_Id = '||P_Invoice_Id||
2403: EXCEPTION
2404: WHEN OTHERS THEN
2405: IF (SQLCODE <> -20001) THEN
2406: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2407: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2408: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2409: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2410: ' P_Invoice_Id = '||P_Invoice_Id||
2411: ' P_Calling_Mode ='||P_Calling_Mode||
2404: WHEN OTHERS THEN
2405: IF (SQLCODE <> -20001) THEN
2406: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2407: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2408: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2409: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2410: ' P_Invoice_Id = '||P_Invoice_Id||
2411: ' P_Calling_Mode ='||P_Calling_Mode||
2412: ' P_Error_Code = '||P_Error_Code||
2405: IF (SQLCODE <> -20001) THEN
2406: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2407: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2408: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2409: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2410: ' P_Invoice_Id = '||P_Invoice_Id||
2411: ' P_Calling_Mode ='||P_Calling_Mode||
2412: ' P_Error_Code = '||P_Error_Code||
2413: ' P_Calling_Sequence = '||P_Calling_Sequence);
2410: ' P_Invoice_Id = '||P_Invoice_Id||
2411: ' P_Calling_Mode ='||P_Calling_Mode||
2412: ' P_Error_Code = '||P_Error_Code||
2413: ' P_Calling_Sequence = '||P_Calling_Sequence);
2414: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2415: END IF;
2416:
2417: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2418: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,sqlerrm);
2606: WHEN NO_DATA_FOUND THEN NULL;
2607:
2608: WHEN OTHERS THEN
2609: IF (SQLCODE <> -20001) THEN
2610: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2611: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2612: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2613: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2614: ' P_Invoice_Id = '||P_Invoice_Id||
2607:
2608: WHEN OTHERS THEN
2609: IF (SQLCODE <> -20001) THEN
2610: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2611: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2612: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2613: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2614: ' P_Invoice_Id = '||P_Invoice_Id||
2615: ' P_Error_Code = '||P_Error_Code||
2608: WHEN OTHERS THEN
2609: IF (SQLCODE <> -20001) THEN
2610: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2611: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2612: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2613: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2614: ' P_Invoice_Id = '||P_Invoice_Id||
2615: ' P_Error_Code = '||P_Error_Code||
2616: ' P_Calling_Sequence = '||P_Calling_Sequence);
2609: IF (SQLCODE <> -20001) THEN
2610: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2611: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2612: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2613: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2614: ' P_Invoice_Id = '||P_Invoice_Id||
2615: ' P_Error_Code = '||P_Error_Code||
2616: ' P_Calling_Sequence = '||P_Calling_Sequence);
2617: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2613: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2614: ' P_Invoice_Id = '||P_Invoice_Id||
2615: ' P_Error_Code = '||P_Error_Code||
2616: ' P_Calling_Sequence = '||P_Calling_Sequence);
2617: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2618: END IF;
2619:
2620: APP_EXCEPTION.RAISE_EXCEPTION;
2621: END;
2850:
2851: EXCEPTION
2852: WHEN OTHERS THEN
2853: IF (SQLCODE <> -20001) THEN
2854: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2855: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2856: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2857: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2858: ' P_Invoice_Id = '||P_Invoice_Id||
2851: EXCEPTION
2852: WHEN OTHERS THEN
2853: IF (SQLCODE <> -20001) THEN
2854: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2855: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2856: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2857: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2858: ' P_Invoice_Id = '||P_Invoice_Id||
2859: ' P_Calling_Mode ='||P_Calling_Mode||
2852: WHEN OTHERS THEN
2853: IF (SQLCODE <> -20001) THEN
2854: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2855: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2856: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2857: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2858: ' P_Invoice_Id = '||P_Invoice_Id||
2859: ' P_Calling_Mode ='||P_Calling_Mode||
2860: ' P_Error_Code = '||P_Error_Code||
2853: IF (SQLCODE <> -20001) THEN
2854: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2855: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2856: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2857: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2858: ' P_Invoice_Id = '||P_Invoice_Id||
2859: ' P_Calling_Mode ='||P_Calling_Mode||
2860: ' P_Error_Code = '||P_Error_Code||
2861: ' P_Calling_Sequence = '||P_Calling_Sequence);
2858: ' P_Invoice_Id = '||P_Invoice_Id||
2859: ' P_Calling_Mode ='||P_Calling_Mode||
2860: ' P_Error_Code = '||P_Error_Code||
2861: ' P_Calling_Sequence = '||P_Calling_Sequence);
2862: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2863: END IF;
2864:
2865: APP_EXCEPTION.RAISE_EXCEPTION;
2866:
3076:
3077: EXCEPTION
3078: WHEN OTHERS THEN
3079: IF (SQLCODE <> -20001) THEN
3080: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3081: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3082: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3083: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3084: ' P_Invoice_Id = '||P_Invoice_Id||
3077: EXCEPTION
3078: WHEN OTHERS THEN
3079: IF (SQLCODE <> -20001) THEN
3080: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3081: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3082: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3083: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3084: ' P_Invoice_Id = '||P_Invoice_Id||
3085: ' P_Calling_Mode ='||P_Calling_Mode||
3078: WHEN OTHERS THEN
3079: IF (SQLCODE <> -20001) THEN
3080: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3081: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3082: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3083: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3084: ' P_Invoice_Id = '||P_Invoice_Id||
3085: ' P_Calling_Mode ='||P_Calling_Mode||
3086: ' P_Error_Code = '||P_Error_Code||
3079: IF (SQLCODE <> -20001) THEN
3080: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3081: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3082: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3083: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3084: ' P_Invoice_Id = '||P_Invoice_Id||
3085: ' P_Calling_Mode ='||P_Calling_Mode||
3086: ' P_Error_Code = '||P_Error_Code||
3087: ' P_Calling_Sequence = '||P_Calling_Sequence);
3084: ' P_Invoice_Id = '||P_Invoice_Id||
3085: ' P_Calling_Mode ='||P_Calling_Mode||
3086: ' P_Error_Code = '||P_Error_Code||
3087: ' P_Calling_Sequence = '||P_Calling_Sequence);
3088: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3089: END IF;
3090:
3091: APP_EXCEPTION.RAISE_EXCEPTION;
3092:
3442:
3443: EXCEPTION
3444: WHEN OTHERS THEN
3445: IF (SQLCODE <> -20001) THEN
3446: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3447: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3448: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3449: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3450: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
3443: EXCEPTION
3444: WHEN OTHERS THEN
3445: IF (SQLCODE <> -20001) THEN
3446: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3447: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3448: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3449: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3450: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
3451: ' P_Calling_Mode ='||P_Calling_Mode||
3444: WHEN OTHERS THEN
3445: IF (SQLCODE <> -20001) THEN
3446: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3447: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3448: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3449: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3450: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
3451: ' P_Calling_Mode ='||P_Calling_Mode||
3452: ' P_Error_Code = '||P_Error_Code||
3445: IF (SQLCODE <> -20001) THEN
3446: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3447: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3448: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3449: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3450: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
3451: ' P_Calling_Mode ='||P_Calling_Mode||
3452: ' P_Error_Code = '||P_Error_Code||
3453: ' P_Calling_Sequence = '||P_Calling_Sequence);
3450: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
3451: ' P_Calling_Mode ='||P_Calling_Mode||
3452: ' P_Error_Code = '||P_Error_Code||
3453: ' P_Calling_Sequence = '||P_Calling_Sequence);
3454: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3455: END IF;
3456:
3457: IF ( Itm_Dist%ISOPEN ) THEN
3458: CLOSE Itm_Dist;
3875:
3876: EXCEPTION
3877: WHEN OTHERS THEN
3878: IF (SQLCODE <> -20001) THEN
3879: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3880: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3881: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3882: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3883: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
3876: EXCEPTION
3877: WHEN OTHERS THEN
3878: IF (SQLCODE <> -20001) THEN
3879: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3880: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3881: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3882: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3883: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
3884: ' P_Calling_Mode ='||P_Calling_Mode||
3877: WHEN OTHERS THEN
3878: IF (SQLCODE <> -20001) THEN
3879: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3880: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3881: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3882: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3883: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
3884: ' P_Calling_Mode ='||P_Calling_Mode||
3885: ' P_Error_Code = '||P_Error_Code||
3878: IF (SQLCODE <> -20001) THEN
3879: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3880: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3881: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3882: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3883: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
3884: ' P_Calling_Mode ='||P_Calling_Mode||
3885: ' P_Error_Code = '||P_Error_Code||
3886: ' P_Calling_Sequence = '||P_Calling_Sequence);
3883: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
3884: ' P_Calling_Mode ='||P_Calling_Mode||
3885: ' P_Error_Code = '||P_Error_Code||
3886: ' P_Calling_Sequence = '||P_Calling_Sequence);
3887: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3888: END IF;
3889:
3890: IF ( tax_dist%ISOPEN ) THEN
3891: CLOSE tax_dist;
4233:
4234: EXCEPTION
4235: WHEN OTHERS THEN
4236: IF (SQLCODE <> -20001) THEN
4237: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4238: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4239: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4240: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4241: ' P_Invoice_Id = '||P_Invoice_Id||
4234: EXCEPTION
4235: WHEN OTHERS THEN
4236: IF (SQLCODE <> -20001) THEN
4237: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4238: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4239: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4240: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4241: ' P_Invoice_Id = '||P_Invoice_Id||
4242: ' P_Calling_Mode ='||P_Calling_Mode||
4235: WHEN OTHERS THEN
4236: IF (SQLCODE <> -20001) THEN
4237: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4238: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4239: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4240: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4241: ' P_Invoice_Id = '||P_Invoice_Id||
4242: ' P_Calling_Mode ='||P_Calling_Mode||
4243: ' P_Error_Code = '||P_Error_Code||
4236: IF (SQLCODE <> -20001) THEN
4237: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4238: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4239: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4240: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4241: ' P_Invoice_Id = '||P_Invoice_Id||
4242: ' P_Calling_Mode ='||P_Calling_Mode||
4243: ' P_Error_Code = '||P_Error_Code||
4244: ' P_Calling_Sequence = '||P_Calling_Sequence);
4241: ' P_Invoice_Id = '||P_Invoice_Id||
4242: ' P_Calling_Mode ='||P_Calling_Mode||
4243: ' P_Error_Code = '||P_Error_Code||
4244: ' P_Calling_Sequence = '||P_Calling_Sequence);
4245: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4246: END IF;
4247:
4248: APP_EXCEPTION.RAISE_EXCEPTION;
4249:
4432:
4433: EXCEPTION
4434: WHEN OTHERS THEN
4435: IF (SQLCODE <> -20001) THEN
4436: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4437: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4438: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4439: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4440: ' P_Invoice_Id = '||P_Invoice_Id||
4433: EXCEPTION
4434: WHEN OTHERS THEN
4435: IF (SQLCODE <> -20001) THEN
4436: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4437: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4438: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4439: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4440: ' P_Invoice_Id = '||P_Invoice_Id||
4441: ' P_Calling_Mode ='||P_Calling_Mode||
4434: WHEN OTHERS THEN
4435: IF (SQLCODE <> -20001) THEN
4436: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4437: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4438: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4439: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4440: ' P_Invoice_Id = '||P_Invoice_Id||
4441: ' P_Calling_Mode ='||P_Calling_Mode||
4442: ' P_Error_Code = '||P_Error_Code||
4435: IF (SQLCODE <> -20001) THEN
4436: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4437: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4438: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4439: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4440: ' P_Invoice_Id = '||P_Invoice_Id||
4441: ' P_Calling_Mode ='||P_Calling_Mode||
4442: ' P_Error_Code = '||P_Error_Code||
4443: ' P_Calling_Sequence = '||P_Calling_Sequence);
4440: ' P_Invoice_Id = '||P_Invoice_Id||
4441: ' P_Calling_Mode ='||P_Calling_Mode||
4442: ' P_Error_Code = '||P_Error_Code||
4443: ' P_Calling_Sequence = '||P_Calling_Sequence);
4444: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4445: END IF;
4446:
4447: APP_EXCEPTION.RAISE_EXCEPTION;
4448:
4601:
4602: EXCEPTION
4603: WHEN OTHERS THEN
4604: IF (SQLCODE <> -20001) THEN
4605: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4606: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4607: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4608: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4609: ' P_Invoice_Id = '||P_Invoice_Id||
4602: EXCEPTION
4603: WHEN OTHERS THEN
4604: IF (SQLCODE <> -20001) THEN
4605: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4606: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4607: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4608: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4609: ' P_Invoice_Id = '||P_Invoice_Id||
4610: ' P_Line_Number_To_Delete = '||P_Line_Number_To_Delete||
4603: WHEN OTHERS THEN
4604: IF (SQLCODE <> -20001) THEN
4605: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4606: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4607: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4608: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4609: ' P_Invoice_Id = '||P_Invoice_Id||
4610: ' P_Line_Number_To_Delete = '||P_Line_Number_To_Delete||
4611: ' P_Calling_Mode ='||P_Calling_Mode||
4604: IF (SQLCODE <> -20001) THEN
4605: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4606: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4607: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4608: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4609: ' P_Invoice_Id = '||P_Invoice_Id||
4610: ' P_Line_Number_To_Delete = '||P_Line_Number_To_Delete||
4611: ' P_Calling_Mode ='||P_Calling_Mode||
4612: ' P_Error_Code = '||P_Error_Code||
4610: ' P_Line_Number_To_Delete = '||P_Line_Number_To_Delete||
4611: ' P_Calling_Mode ='||P_Calling_Mode||
4612: ' P_Error_Code = '||P_Error_Code||
4613: ' P_Calling_Sequence = '||P_Calling_Sequence);
4614: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4615: END IF;
4616:
4617: APP_EXCEPTION.RAISE_EXCEPTION;
4618:
5066:
5067: EXCEPTION
5068: WHEN OTHERS THEN
5069: IF (SQLCODE <> -20001) THEN
5070: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5071: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5072: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5073: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5074: ' Invoice_Id = '||P_Invoice_Rec.Invoice_Id||
5067: EXCEPTION
5068: WHEN OTHERS THEN
5069: IF (SQLCODE <> -20001) THEN
5070: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5071: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5072: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5073: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5074: ' Invoice_Id = '||P_Invoice_Rec.Invoice_Id||
5075: ' P_Calling_Mode ='||P_Calling_Mode||
5068: WHEN OTHERS THEN
5069: IF (SQLCODE <> -20001) THEN
5070: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5071: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5072: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5073: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5074: ' Invoice_Id = '||P_Invoice_Rec.Invoice_Id||
5075: ' P_Calling_Mode ='||P_Calling_Mode||
5076: ' P_Error_Code = '||P_Error_Code||
5069: IF (SQLCODE <> -20001) THEN
5070: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5071: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5072: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5073: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5074: ' Invoice_Id = '||P_Invoice_Rec.Invoice_Id||
5075: ' P_Calling_Mode ='||P_Calling_Mode||
5076: ' P_Error_Code = '||P_Error_Code||
5077: ' P_Calling_Sequence = '||P_Calling_Sequence);
5074: ' Invoice_Id = '||P_Invoice_Rec.Invoice_Id||
5075: ' P_Calling_Mode ='||P_Calling_Mode||
5076: ' P_Error_Code = '||P_Error_Code||
5077: ' P_Calling_Sequence = '||P_Calling_Sequence);
5078: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5079: END IF;
5080:
5081: APP_EXCEPTION.RAISE_EXCEPTION;
5082:
5462:
5463: EXCEPTION
5464: WHEN OTHERS THEN
5465: IF (SQLCODE <> -20001) THEN
5466: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5467: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5468: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5469: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5470: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
5463: EXCEPTION
5464: WHEN OTHERS THEN
5465: IF (SQLCODE <> -20001) THEN
5466: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5467: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5468: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5469: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5470: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
5471: ' P_Calling_Mode ='||P_Calling_Mode||
5464: WHEN OTHERS THEN
5465: IF (SQLCODE <> -20001) THEN
5466: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5467: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5468: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5469: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5470: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
5471: ' P_Calling_Mode ='||P_Calling_Mode||
5472: ' P_Error_Code = '||P_Error_Code||
5465: IF (SQLCODE <> -20001) THEN
5466: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5467: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5468: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5469: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5470: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
5471: ' P_Calling_Mode ='||P_Calling_Mode||
5472: ' P_Error_Code = '||P_Error_Code||
5473: ' P_Calling_Sequence = '||P_Calling_Sequence);
5470: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
5471: ' P_Calling_Mode ='||P_Calling_Mode||
5472: ' P_Error_Code = '||P_Error_Code||
5473: ' P_Calling_Sequence = '||P_Calling_Sequence);
5474: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5475: END IF;
5476:
5477: IF ( tax_related_invoice%ISOPEN ) THEN
5478: CLOSE tax_related_invoice;
5829:
5830: EXCEPTION
5831: WHEN OTHERS THEN
5832: IF (SQLCODE <> -20001) THEN
5833: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5834: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5835: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5836: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5837: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
5830: EXCEPTION
5831: WHEN OTHERS THEN
5832: IF (SQLCODE <> -20001) THEN
5833: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5834: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5835: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5836: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5837: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
5838: ' P_Calling_Mode ='||P_Calling_Mode||
5831: WHEN OTHERS THEN
5832: IF (SQLCODE <> -20001) THEN
5833: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5834: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5835: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5836: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5837: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
5838: ' P_Calling_Mode ='||P_Calling_Mode||
5839: ' P_Error_Code = '||P_Error_Code||
5832: IF (SQLCODE <> -20001) THEN
5833: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5834: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5835: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5836: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5837: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
5838: ' P_Calling_Mode ='||P_Calling_Mode||
5839: ' P_Error_Code = '||P_Error_Code||
5840: ' P_Calling_Sequence = '||P_Calling_Sequence);
5837: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
5838: ' P_Calling_Mode ='||P_Calling_Mode||
5839: ' P_Error_Code = '||P_Error_Code||
5840: ' P_Calling_Sequence = '||P_Calling_Sequence);
5841: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5842: END IF;
5843:
5844: IF ( tax_related_invoice%ISOPEN ) THEN
5845: CLOSE tax_related_invoice;
6702:
6703: EXCEPTION
6704: WHEN OTHERS THEN
6705: IF (SQLCODE <> -20001) THEN
6706: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6707: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6708: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6709: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6710: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
6703: EXCEPTION
6704: WHEN OTHERS THEN
6705: IF (SQLCODE <> -20001) THEN
6706: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6707: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6708: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6709: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6710: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
6711: ' P_Calling_Mode ='||P_Calling_Mode||
6704: WHEN OTHERS THEN
6705: IF (SQLCODE <> -20001) THEN
6706: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6707: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6708: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6709: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6710: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
6711: ' P_Calling_Mode ='||P_Calling_Mode||
6712: ' P_Error_Code = '||P_Error_Code||
6705: IF (SQLCODE <> -20001) THEN
6706: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6707: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6708: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6709: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6710: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
6711: ' P_Calling_Mode ='||P_Calling_Mode||
6712: ' P_Error_Code = '||P_Error_Code||
6713: ' P_Calling_Sequence = '||P_Calling_Sequence);
6710: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
6711: ' P_Calling_Mode ='||P_Calling_Mode||
6712: ' P_Error_Code = '||P_Error_Code||
6713: ' P_Calling_Sequence = '||P_Calling_Sequence);
6714: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
6715: END IF;
6716:
6717: APP_EXCEPTION.RAISE_EXCEPTION;
6718:
7844:
7845: EXCEPTION
7846: WHEN OTHERS THEN
7847: IF (SQLCODE <> -20001) THEN
7848: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7849: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7850: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
7851: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7852: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
7845: EXCEPTION
7846: WHEN OTHERS THEN
7847: IF (SQLCODE <> -20001) THEN
7848: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7849: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7850: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
7851: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7852: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
7853: ' P_Calling_Mode ='||P_Calling_Mode||
7846: WHEN OTHERS THEN
7847: IF (SQLCODE <> -20001) THEN
7848: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7849: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7850: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
7851: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7852: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
7853: ' P_Calling_Mode ='||P_Calling_Mode||
7854: ' P_Error_Code = '||P_Error_Code||
7847: IF (SQLCODE <> -20001) THEN
7848: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7849: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7850: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
7851: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7852: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
7853: ' P_Calling_Mode ='||P_Calling_Mode||
7854: ' P_Error_Code = '||P_Error_Code||
7855: ' P_Calling_Sequence = '||P_Calling_Sequence);
7852: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
7853: ' P_Calling_Mode ='||P_Calling_Mode||
7854: ' P_Error_Code = '||P_Error_Code||
7855: ' P_Calling_Sequence = '||P_Calling_Sequence);
7856: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
7857: END IF;
7858:
7859: APP_EXCEPTION.RAISE_EXCEPTION;
7860:
8583:
8584: EXCEPTION
8585: WHEN OTHERS THEN
8586: IF (SQLCODE <> -20001) THEN
8587: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
8588: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8589: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
8590: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8591: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
8584: EXCEPTION
8585: WHEN OTHERS THEN
8586: IF (SQLCODE <> -20001) THEN
8587: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
8588: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8589: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
8590: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8591: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
8592: ' P_Calling_Mode ='||P_Calling_Mode||
8585: WHEN OTHERS THEN
8586: IF (SQLCODE <> -20001) THEN
8587: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
8588: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8589: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
8590: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8591: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
8592: ' P_Calling_Mode ='||P_Calling_Mode||
8593: ' P_Error_Code = '||P_Error_Code||
8586: IF (SQLCODE <> -20001) THEN
8587: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
8588: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8589: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
8590: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8591: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
8592: ' P_Calling_Mode ='||P_Calling_Mode||
8593: ' P_Error_Code = '||P_Error_Code||
8594: ' P_Calling_Sequence = '||P_Calling_Sequence);
8591: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
8592: ' P_Calling_Mode ='||P_Calling_Mode||
8593: ' P_Error_Code = '||P_Error_Code||
8594: ' P_Calling_Sequence = '||P_Calling_Sequence);
8595: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
8596: END IF;
8597:
8598: APP_EXCEPTION.RAISE_EXCEPTION;
8599:
9065:
9066: EXCEPTION
9067: WHEN OTHERS THEN
9068: IF (SQLCODE <> -20001) THEN
9069: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9070: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9071: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9072: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9073: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
9066: EXCEPTION
9067: WHEN OTHERS THEN
9068: IF (SQLCODE <> -20001) THEN
9069: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9070: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9071: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9072: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9073: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
9074: ' P_Calling_Mode ='||P_Calling_Mode||
9067: WHEN OTHERS THEN
9068: IF (SQLCODE <> -20001) THEN
9069: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9070: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9071: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9072: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9073: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
9074: ' P_Calling_Mode ='||P_Calling_Mode||
9075: ' P_Error_Code = '||P_Error_Code||
9068: IF (SQLCODE <> -20001) THEN
9069: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9070: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9071: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9072: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9073: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
9074: ' P_Calling_Mode ='||P_Calling_Mode||
9075: ' P_Error_Code = '||P_Error_Code||
9076: ' P_Calling_Sequence = '||P_Calling_Sequence);
9073: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
9074: ' P_Calling_Mode ='||P_Calling_Mode||
9075: ' P_Error_Code = '||P_Error_Code||
9076: ' P_Calling_Sequence = '||P_Calling_Sequence);
9077: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
9078: END IF;
9079:
9080: APP_EXCEPTION.RAISE_EXCEPTION;
9081: END Populate_Distributions_GT;
9198:
9199: EXCEPTION
9200: WHEN OTHERS THEN
9201: IF (SQLCODE <> -20001) THEN
9202: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9203: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9204: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9205: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9206: ' P_Invoice_Id = '||P_Invoice_header_rec.Invoice_Id||
9199: EXCEPTION
9200: WHEN OTHERS THEN
9201: IF (SQLCODE <> -20001) THEN
9202: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9203: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9204: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9205: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9206: ' P_Invoice_Id = '||P_Invoice_header_rec.Invoice_Id||
9207: ' P_Calling_Mode ='||P_Calling_Mode||
9200: WHEN OTHERS THEN
9201: IF (SQLCODE <> -20001) THEN
9202: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9203: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9204: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9205: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9206: ' P_Invoice_Id = '||P_Invoice_header_rec.Invoice_Id||
9207: ' P_Calling_Mode ='||P_Calling_Mode||
9208: ' P_Error_Code = '||P_Error_Code||
9201: IF (SQLCODE <> -20001) THEN
9202: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9203: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9204: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9205: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9206: ' P_Invoice_Id = '||P_Invoice_header_rec.Invoice_Id||
9207: ' P_Calling_Mode ='||P_Calling_Mode||
9208: ' P_Error_Code = '||P_Error_Code||
9209: ' P_Calling_Sequence = '||P_Calling_Sequence);
9206: ' P_Invoice_Id = '||P_Invoice_header_rec.Invoice_Id||
9207: ' P_Calling_Mode ='||P_Calling_Mode||
9208: ' P_Error_Code = '||P_Error_Code||
9209: ' P_Calling_Sequence = '||P_Calling_Sequence);
9210: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
9211: END IF;
9212:
9213: APP_EXCEPTION.RAISE_EXCEPTION;
9214:
9692: EXCEPTION
9693: WHEN OTHERS THEN
9694: IF (SQLCODE <> -20001) THEN
9695:
9696: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9697: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9698: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9699: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9700: ' P_Invoice_Header_Rec.Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
9693: WHEN OTHERS THEN
9694: IF (SQLCODE <> -20001) THEN
9695:
9696: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9697: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9698: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9699: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9700: ' P_Invoice_Header_Rec.Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
9701: ' P_Calling_Mode ='||P_Calling_Mode||
9694: IF (SQLCODE <> -20001) THEN
9695:
9696: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9697: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9698: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9699: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9700: ' P_Invoice_Header_Rec.Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
9701: ' P_Calling_Mode ='||P_Calling_Mode||
9702: ' P_Error_Code = '||P_Error_Code);
9695:
9696: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9697: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9698: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9699: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9700: ' P_Invoice_Header_Rec.Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
9701: ' P_Calling_Mode ='||P_Calling_Mode||
9702: ' P_Error_Code = '||P_Error_Code);
9703: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
9699: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9700: ' P_Invoice_Header_Rec.Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
9701: ' P_Calling_Mode ='||P_Calling_Mode||
9702: ' P_Error_Code = '||P_Error_Code);
9703: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
9704: END IF;
9705:
9706: APP_EXCEPTION.RAISE_EXCEPTION;
9707:
12311: END IF;
12312:
12313: IF (SQLCODE <> -20001) THEN
12314:
12315: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12316: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12317: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12318: FND_MESSAGE.SET_TOKEN('PARAMETERS',
12319: ' P_Invoice_Id = '||P_Invoice_Id);
12312:
12313: IF (SQLCODE <> -20001) THEN
12314:
12315: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12316: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12317: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12318: FND_MESSAGE.SET_TOKEN('PARAMETERS',
12319: ' P_Invoice_Id = '||P_Invoice_Id);
12320: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
12313: IF (SQLCODE <> -20001) THEN
12314:
12315: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12316: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12317: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12318: FND_MESSAGE.SET_TOKEN('PARAMETERS',
12319: ' P_Invoice_Id = '||P_Invoice_Id);
12320: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
12321: END IF;
12314:
12315: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12316: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12317: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12318: FND_MESSAGE.SET_TOKEN('PARAMETERS',
12319: ' P_Invoice_Id = '||P_Invoice_Id);
12320: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
12321: END IF;
12322:
12316: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12317: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12318: FND_MESSAGE.SET_TOKEN('PARAMETERS',
12319: ' P_Invoice_Id = '||P_Invoice_Id);
12320: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
12321: END IF;
12322:
12323: APP_EXCEPTION.RAISE_EXCEPTION;
12324:
12554: END IF;
12555:
12556: IF (SQLCODE <> -20001) THEN
12557:
12558: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12559: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12560: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12561: FND_MESSAGE.SET_TOKEN('PARAMETERS',
12562: ' P_Invoice_Id = '||P_Invoice_Id);
12555:
12556: IF (SQLCODE <> -20001) THEN
12557:
12558: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12559: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12560: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12561: FND_MESSAGE.SET_TOKEN('PARAMETERS',
12562: ' P_Invoice_Id = '||P_Invoice_Id);
12563: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
12556: IF (SQLCODE <> -20001) THEN
12557:
12558: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12559: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12560: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12561: FND_MESSAGE.SET_TOKEN('PARAMETERS',
12562: ' P_Invoice_Id = '||P_Invoice_Id);
12563: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
12564: END IF;
12557:
12558: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12559: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12560: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12561: FND_MESSAGE.SET_TOKEN('PARAMETERS',
12562: ' P_Invoice_Id = '||P_Invoice_Id);
12563: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
12564: END IF;
12565:
12559: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12560: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12561: FND_MESSAGE.SET_TOKEN('PARAMETERS',
12562: ' P_Invoice_Id = '||P_Invoice_Id);
12563: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
12564: END IF;
12565:
12566: DELETE FROM ZX_TRX_HEADERS_GT;
12567: DELETE FROM ZX_TRANSACTION_LINES_GT;
12752: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Exception: '||sqlerrm);
12753: END IF;
12754:
12755: IF (SQLCODE <> -20001) THEN
12756: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12757: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12758: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12759: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = '||P_Invoice_Id);
12760: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
12753: END IF;
12754:
12755: IF (SQLCODE <> -20001) THEN
12756: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12757: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12758: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12759: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = '||P_Invoice_Id);
12760: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
12761: END IF;
12754:
12755: IF (SQLCODE <> -20001) THEN
12756: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12757: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12758: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12759: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = '||P_Invoice_Id);
12760: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
12761: END IF;
12762:
12755: IF (SQLCODE <> -20001) THEN
12756: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12757: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12758: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12759: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = '||P_Invoice_Id);
12760: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
12761: END IF;
12762:
12763: APP_EXCEPTION.RAISE_EXCEPTION;
12756: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12757: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12758: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12759: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = '||P_Invoice_Id);
12760: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
12761: END IF;
12762:
12763: APP_EXCEPTION.RAISE_EXCEPTION;
12764:
13113:
13114: EXCEPTION
13115: WHEN OTHERS THEN
13116: IF (SQLCODE <> -20001) THEN
13117: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
13118: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
13119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
13120: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Id ||
13121: ' P_Calling_Mode =' ||P_Calling_Mode||
13114: EXCEPTION
13115: WHEN OTHERS THEN
13116: IF (SQLCODE <> -20001) THEN
13117: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
13118: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
13119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
13120: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Id ||
13121: ' P_Calling_Mode =' ||P_Calling_Mode||
13122: ' P_Error_Code = ' ||P_Error_Code ||
13115: WHEN OTHERS THEN
13116: IF (SQLCODE <> -20001) THEN
13117: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
13118: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
13119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
13120: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Id ||
13121: ' P_Calling_Mode =' ||P_Calling_Mode||
13122: ' P_Error_Code = ' ||P_Error_Code ||
13123: ' P_Calling_Sequence = '||P_Calling_Sequence);
13116: IF (SQLCODE <> -20001) THEN
13117: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
13118: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
13119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
13120: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Id ||
13121: ' P_Calling_Mode =' ||P_Calling_Mode||
13122: ' P_Error_Code = ' ||P_Error_Code ||
13123: ' P_Calling_Sequence = '||P_Calling_Sequence);
13124: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
13120: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Id ||
13121: ' P_Calling_Mode =' ||P_Calling_Mode||
13122: ' P_Error_Code = ' ||P_Error_Code ||
13123: ' P_Calling_Sequence = '||P_Calling_Sequence);
13124: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
13125:
13126: END IF;
13127:
13128: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13488:
13489: EXCEPTION
13490: WHEN OTHERS THEN
13491: IF (SQLCODE <> -20001) THEN
13492: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
13493: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
13494: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
13495: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id ||
13496: ' P_Error_Code = ' ||P_Error_Code ||
13489: EXCEPTION
13490: WHEN OTHERS THEN
13491: IF (SQLCODE <> -20001) THEN
13492: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
13493: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
13494: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
13495: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id ||
13496: ' P_Error_Code = ' ||P_Error_Code ||
13497: ' P_Calling_Sequence = '||P_Calling_Sequence);
13490: WHEN OTHERS THEN
13491: IF (SQLCODE <> -20001) THEN
13492: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
13493: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
13494: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
13495: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id ||
13496: ' P_Error_Code = ' ||P_Error_Code ||
13497: ' P_Calling_Sequence = '||P_Calling_Sequence);
13498: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
13491: IF (SQLCODE <> -20001) THEN
13492: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
13493: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
13494: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
13495: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id ||
13496: ' P_Error_Code = ' ||P_Error_Code ||
13497: ' P_Calling_Sequence = '||P_Calling_Sequence);
13498: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
13499:
13494: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
13495: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id ||
13496: ' P_Error_Code = ' ||P_Error_Code ||
13497: ' P_Calling_Sequence = '||P_Calling_Sequence);
13498: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
13499:
13500: END IF;
13501:
13502: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
14097: END IF;
14098:
14099: WHEN OTHERS THEN
14100: IF (SQLCODE <> -20001) THEN
14101: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14102: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14103: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14104: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14105: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14098:
14099: WHEN OTHERS THEN
14100: IF (SQLCODE <> -20001) THEN
14101: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14102: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14103: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14104: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14105: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14106: ' P_Error_Code = '||P_Error_Code||
14099: WHEN OTHERS THEN
14100: IF (SQLCODE <> -20001) THEN
14101: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14102: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14103: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14104: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14105: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14106: ' P_Error_Code = '||P_Error_Code||
14107: ' P_Calling_Sequence = '||P_Calling_Sequence);
14100: IF (SQLCODE <> -20001) THEN
14101: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14102: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14103: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14104: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14105: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14106: ' P_Error_Code = '||P_Error_Code||
14107: ' P_Calling_Sequence = '||P_Calling_Sequence);
14108: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14104: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14105: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14106: ' P_Error_Code = '||P_Error_Code||
14107: ' P_Calling_Sequence = '||P_Calling_Sequence);
14108: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14109: END IF;
14110:
14111: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
14112: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
14170:
14171: EXCEPTION
14172: WHEN OTHERS THEN
14173: IF (SQLCODE <> -20001) THEN
14174: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14175: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14176: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
14177: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14178: END IF;
14171: EXCEPTION
14172: WHEN OTHERS THEN
14173: IF (SQLCODE <> -20001) THEN
14174: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14175: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14176: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
14177: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14178: END IF;
14179: APP_EXCEPTION.RAISE_EXCEPTION;
14172: WHEN OTHERS THEN
14173: IF (SQLCODE <> -20001) THEN
14174: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14175: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14176: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
14177: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14178: END IF;
14179: APP_EXCEPTION.RAISE_EXCEPTION;
14180: END Cache_Line_Defaults;
14173: IF (SQLCODE <> -20001) THEN
14174: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14175: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14176: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
14177: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14178: END IF;
14179: APP_EXCEPTION.RAISE_EXCEPTION;
14180: END Cache_Line_Defaults;
14181:
14317: NULL;
14318:
14319: WHEN OTHERS THEN
14320: IF (SQLCODE <> -20001) THEN
14321: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14322: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14323: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14324: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14325: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
14318:
14319: WHEN OTHERS THEN
14320: IF (SQLCODE <> -20001) THEN
14321: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14322: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14323: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14324: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14325: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
14326: ' P_Error_Code = '||P_Error_Code||
14319: WHEN OTHERS THEN
14320: IF (SQLCODE <> -20001) THEN
14321: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14322: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14323: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14324: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14325: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
14326: ' P_Error_Code = '||P_Error_Code||
14327: ' P_Calling_Sequence = '||P_Calling_Sequence);
14320: IF (SQLCODE <> -20001) THEN
14321: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14322: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14323: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14324: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14325: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
14326: ' P_Error_Code = '||P_Error_Code||
14327: ' P_Calling_Sequence = '||P_Calling_Sequence);
14328: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14324: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14325: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
14326: ' P_Error_Code = '||P_Error_Code||
14327: ' P_Calling_Sequence = '||P_Calling_Sequence);
14328: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14329: END IF;
14330:
14331: APP_EXCEPTION.RAISE_EXCEPTION;
14332: END;
14748: NULL;
14749:
14750: WHEN OTHERS THEN
14751: IF (SQLCODE <> -20001) THEN
14752: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14753: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14754: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14755: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14756: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14749:
14750: WHEN OTHERS THEN
14751: IF (SQLCODE <> -20001) THEN
14752: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14753: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14754: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14755: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14756: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14757: ' P_Error_Code = '||P_Error_Code||
14750: WHEN OTHERS THEN
14751: IF (SQLCODE <> -20001) THEN
14752: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14753: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14754: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14755: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14756: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14757: ' P_Error_Code = '||P_Error_Code||
14758: ' P_Calling_Sequence = '||P_Calling_Sequence);
14751: IF (SQLCODE <> -20001) THEN
14752: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14753: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14754: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14755: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14756: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14757: ' P_Error_Code = '||P_Error_Code||
14758: ' P_Calling_Sequence = '||P_Calling_Sequence);
14759: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14755: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14756: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14757: ' P_Error_Code = '||P_Error_Code||
14758: ' P_Calling_Sequence = '||P_Calling_Sequence);
14759: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14760: END IF;
14761:
14762: APP_EXCEPTION.RAISE_EXCEPTION;
14763: END;
14785: NULL;
14786:
14787: WHEN OTHERS THEN
14788: IF (SQLCODE <> -20001) THEN
14789: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14790: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14791: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14792: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14793: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14786:
14787: WHEN OTHERS THEN
14788: IF (SQLCODE <> -20001) THEN
14789: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14790: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14791: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14792: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14793: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14794: ' P_Error_Code = '||P_Error_Code||
14787: WHEN OTHERS THEN
14788: IF (SQLCODE <> -20001) THEN
14789: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14790: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14791: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14792: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14793: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14794: ' P_Error_Code = '||P_Error_Code||
14795: ' P_Calling_Sequence = '||P_Calling_Sequence);
14788: IF (SQLCODE <> -20001) THEN
14789: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14790: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14791: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14792: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14793: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14794: ' P_Error_Code = '||P_Error_Code||
14795: ' P_Calling_Sequence = '||P_Calling_Sequence);
14796: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14792: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14793: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14794: ' P_Error_Code = '||P_Error_Code||
14795: ' P_Calling_Sequence = '||P_Calling_Sequence);
14796: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14797: END IF;
14798:
14799: APP_EXCEPTION.RAISE_EXCEPTION;
14800: END;
14830: NULL;
14831:
14832: WHEN OTHERS THEN
14833: IF (SQLCODE <> -20001) THEN
14834: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14835: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14836: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14837: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14838: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14831:
14832: WHEN OTHERS THEN
14833: IF (SQLCODE <> -20001) THEN
14834: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14835: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14836: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14837: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14838: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14839: ' P_Error_Code = '||P_Error_Code||
14832: WHEN OTHERS THEN
14833: IF (SQLCODE <> -20001) THEN
14834: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14835: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14836: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14837: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14838: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14839: ' P_Error_Code = '||P_Error_Code||
14840: ' P_Calling_Sequence = '||P_Calling_Sequence);
14833: IF (SQLCODE <> -20001) THEN
14834: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14835: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14836: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14837: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14838: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14839: ' P_Error_Code = '||P_Error_Code||
14840: ' P_Calling_Sequence = '||P_Calling_Sequence);
14841: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14837: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14838: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
14839: ' P_Error_Code = '||P_Error_Code||
14840: ' P_Calling_Sequence = '||P_Calling_Sequence);
14841: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14842: END IF;
14843:
14844: APP_EXCEPTION.RAISE_EXCEPTION;
14845: END;
14868:
14869: EXCEPTION
14870: WHEN OTHERS THEN
14871: IF (SQLCODE <> -20001) THEN
14872: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14873: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14874: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14875: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14876: ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id||
14869: EXCEPTION
14870: WHEN OTHERS THEN
14871: IF (SQLCODE <> -20001) THEN
14872: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14873: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14874: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14875: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14876: ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id||
14877: ' P_Error_Code = ' ||P_Error_Code||
14870: WHEN OTHERS THEN
14871: IF (SQLCODE <> -20001) THEN
14872: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14873: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14874: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14875: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14876: ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id||
14877: ' P_Error_Code = ' ||P_Error_Code||
14878: ' P_Calling_Sequence = '||P_Calling_Sequence);
14871: IF (SQLCODE <> -20001) THEN
14872: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14873: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14874: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14875: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14876: ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id||
14877: ' P_Error_Code = ' ||P_Error_Code||
14878: ' P_Calling_Sequence = '||P_Calling_Sequence);
14879: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14875: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14876: ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id||
14877: ' P_Error_Code = ' ||P_Error_Code||
14878: ' P_Calling_Sequence = '||P_Calling_Sequence);
14879: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14880: END IF;
14881:
14882: APP_EXCEPTION.RAISE_EXCEPTION;
14883: