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

APPS.AP_ETAX_SERVICES_PKG dependencies on FND_MESSAGE

Line 633: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_VENDOR_SITE_CODE');

629: ,p_vendor_site_id => l_inv_header_rec.party_site_id
630: ,p_calling_sequence => l_curr_calling_sequence);
631: EXCEPTION
632: WHEN NO_DATA_FOUND THEN
633: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_VENDOR_SITE_CODE');
634: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN
635: APP_EXCEPTION.RAISE_EXCEPTION;
636: ELSE
637:

Line 664: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_VENDOR_SITE_CODE');

660: ,p_vendor_site_id => l_inv_header_rec.vendor_site_id
661: ,p_calling_sequence => l_curr_calling_sequence);
662: EXCEPTION
663: WHEN NO_DATA_FOUND THEN
664: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_VENDOR_SITE_CODE');
665: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN
666: APP_EXCEPTION.RAISE_EXCEPTION;
667: ELSE
668: --Bug15914464: Start

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

1107:
1108: EXCEPTION
1109: WHEN OTHERS THEN
1110: IF (SQLCODE <> -20001) THEN
1111: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1112: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1113: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1114: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1115: ' P_Invoice_Id = '||P_Invoice_Id||

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

1108: EXCEPTION
1109: WHEN OTHERS THEN
1110: IF (SQLCODE <> -20001) THEN
1111: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1112: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1113: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1114: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1115: ' P_Invoice_Id = '||P_Invoice_Id||
1116: ' P_Calling_Mode ='||P_Calling_Mode||

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

1109: WHEN OTHERS THEN
1110: IF (SQLCODE <> -20001) THEN
1111: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1112: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1113: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1114: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1115: ' P_Invoice_Id = '||P_Invoice_Id||
1116: ' P_Calling_Mode ='||P_Calling_Mode||
1117: ' P_Error_Code = '||P_Error_Code||

Line 1114: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1110: IF (SQLCODE <> -20001) THEN
1111: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1112: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1113: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1114: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1115: ' P_Invoice_Id = '||P_Invoice_Id||
1116: ' P_Calling_Mode ='||P_Calling_Mode||
1117: ' P_Error_Code = '||P_Error_Code||
1118: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

1115: ' P_Invoice_Id = '||P_Invoice_Id||
1116: ' P_Calling_Mode ='||P_Calling_Mode||
1117: ' P_Error_Code = '||P_Error_Code||
1118: ' P_Calling_Sequence = '||P_Calling_Sequence);
1119: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1120: END IF;
1121:
1122: APP_EXCEPTION.RAISE_EXCEPTION;
1123:

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

1457:
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: IF (SQLCODE <> -20001) THEN
1461: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1462: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1463: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1464: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1465: ' P_Invoice_Id = '||P_Invoice_Id||

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

1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: IF (SQLCODE <> -20001) THEN
1461: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1462: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1463: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1464: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1465: ' P_Invoice_Id = '||P_Invoice_Id||
1466: ' P_Calling_Mode ='||P_Calling_Mode||

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

1459: WHEN OTHERS THEN
1460: IF (SQLCODE <> -20001) THEN
1461: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1462: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1463: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1464: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1465: ' P_Invoice_Id = '||P_Invoice_Id||
1466: ' P_Calling_Mode ='||P_Calling_Mode||
1467: ' P_Error_Code = '||P_Error_Code||

Line 1464: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1460: IF (SQLCODE <> -20001) THEN
1461: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1462: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1463: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1464: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1465: ' P_Invoice_Id = '||P_Invoice_Id||
1466: ' P_Calling_Mode ='||P_Calling_Mode||
1467: ' P_Error_Code = '||P_Error_Code||
1468: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

1465: ' P_Invoice_Id = '||P_Invoice_Id||
1466: ' P_Calling_Mode ='||P_Calling_Mode||
1467: ' P_Error_Code = '||P_Error_Code||
1468: ' P_Calling_Sequence = '||P_Calling_Sequence);
1469: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1470: END IF;
1471:
1472: APP_EXCEPTION.RAISE_EXCEPTION;
1473:

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

2166:
2167: EXCEPTION
2168: WHEN OTHERS THEN
2169: IF (SQLCODE <> -20001) THEN
2170: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2171: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2172: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2173: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2174: ' P_Invoice_Id = '||P_Invoice_Id||

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

2167: EXCEPTION
2168: WHEN OTHERS THEN
2169: IF (SQLCODE <> -20001) THEN
2170: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2171: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2172: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2173: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2174: ' P_Invoice_Id = '||P_Invoice_Id||
2175: ' P_Calling_Mode ='||P_Calling_Mode||

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

2168: WHEN OTHERS THEN
2169: IF (SQLCODE <> -20001) THEN
2170: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2171: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2172: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2173: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2174: ' P_Invoice_Id = '||P_Invoice_Id||
2175: ' P_Calling_Mode ='||P_Calling_Mode||
2176: ' P_Error_Code = '||P_Error_Code||

Line 2173: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2169: IF (SQLCODE <> -20001) THEN
2170: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2171: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2172: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2173: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2174: ' P_Invoice_Id = '||P_Invoice_Id||
2175: ' P_Calling_Mode ='||P_Calling_Mode||
2176: ' P_Error_Code = '||P_Error_Code||
2177: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

2174: ' P_Invoice_Id = '||P_Invoice_Id||
2175: ' P_Calling_Mode ='||P_Calling_Mode||
2176: ' P_Error_Code = '||P_Error_Code||
2177: ' P_Calling_Sequence = '||P_Calling_Sequence);
2178: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2179: END IF;
2180:
2181: APP_EXCEPTION.RAISE_EXCEPTION;
2182:

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

2351:
2352: EXCEPTION
2353: WHEN OTHERS THEN
2354: IF (SQLCODE <> -20001) THEN
2355: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2356: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2357: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2358: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2359: ' P_Invoice_Id = '||P_Invoice_Id||

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

2352: EXCEPTION
2353: WHEN OTHERS THEN
2354: IF (SQLCODE <> -20001) THEN
2355: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2356: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2357: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2358: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2359: ' P_Invoice_Id = '||P_Invoice_Id||
2360: ' P_Calling_Mode ='||P_Calling_Mode||

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

2353: WHEN OTHERS THEN
2354: IF (SQLCODE <> -20001) THEN
2355: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2356: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2357: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2358: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2359: ' P_Invoice_Id = '||P_Invoice_Id||
2360: ' P_Calling_Mode ='||P_Calling_Mode||
2361: ' P_Error_Code = '||P_Error_Code||

Line 2358: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2354: IF (SQLCODE <> -20001) THEN
2355: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2356: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2357: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2358: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2359: ' P_Invoice_Id = '||P_Invoice_Id||
2360: ' P_Calling_Mode ='||P_Calling_Mode||
2361: ' P_Error_Code = '||P_Error_Code||
2362: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

2359: ' P_Invoice_Id = '||P_Invoice_Id||
2360: ' P_Calling_Mode ='||P_Calling_Mode||
2361: ' P_Error_Code = '||P_Error_Code||
2362: ' P_Calling_Sequence = '||P_Calling_Sequence);
2363: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2364: END IF;
2365:
2366: APP_EXCEPTION.RAISE_EXCEPTION;
2367:

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

2708:
2709: EXCEPTION
2710: WHEN OTHERS THEN
2711: IF (SQLCODE <> -20001) THEN
2712: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2713: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2714: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2715: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2716: ' P_Invoice_Id = '||P_Invoice_Id||

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

2709: EXCEPTION
2710: WHEN OTHERS THEN
2711: IF (SQLCODE <> -20001) THEN
2712: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2713: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2714: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2715: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2716: ' P_Invoice_Id = '||P_Invoice_Id||
2717: ' P_Calling_Mode ='||P_Calling_Mode||

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

2710: WHEN OTHERS THEN
2711: IF (SQLCODE <> -20001) THEN
2712: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2713: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2714: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2715: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2716: ' P_Invoice_Id = '||P_Invoice_Id||
2717: ' P_Calling_Mode ='||P_Calling_Mode||
2718: ' P_Error_Code = '||P_Error_Code||

Line 2715: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2711: IF (SQLCODE <> -20001) THEN
2712: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2713: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2714: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
2715: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2716: ' P_Invoice_Id = '||P_Invoice_Id||
2717: ' P_Calling_Mode ='||P_Calling_Mode||
2718: ' P_Error_Code = '||P_Error_Code||
2719: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

2716: ' P_Invoice_Id = '||P_Invoice_Id||
2717: ' P_Calling_Mode ='||P_Calling_Mode||
2718: ' P_Error_Code = '||P_Error_Code||
2719: ' P_Calling_Sequence = '||P_Calling_Sequence);
2720: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2721: END IF;
2722:
2723: APP_EXCEPTION.RAISE_EXCEPTION;
2724: END Import_Interface;

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

3092:
3093: EXCEPTION
3094: WHEN OTHERS THEN
3095: IF (SQLCODE <> -20001) THEN
3096: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3097: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3098: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3099: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3100: ' P_Invoice_Id = '||P_Invoice_Id||

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

3093: EXCEPTION
3094: WHEN OTHERS THEN
3095: IF (SQLCODE <> -20001) THEN
3096: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3097: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3098: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3099: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3100: ' P_Invoice_Id = '||P_Invoice_Id||
3101: ' P_Calling_Mode ='||P_Calling_Mode||

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

3094: WHEN OTHERS THEN
3095: IF (SQLCODE <> -20001) THEN
3096: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3097: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3098: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3099: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3100: ' P_Invoice_Id = '||P_Invoice_Id||
3101: ' P_Calling_Mode ='||P_Calling_Mode||
3102: ' P_Error_Code = '||P_Error_Code||

Line 3099: FND_MESSAGE.SET_TOKEN('PARAMETERS',

3095: IF (SQLCODE <> -20001) THEN
3096: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3097: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3098: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3099: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3100: ' P_Invoice_Id = '||P_Invoice_Id||
3101: ' P_Calling_Mode ='||P_Calling_Mode||
3102: ' P_Error_Code = '||P_Error_Code||
3103: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

3100: ' P_Invoice_Id = '||P_Invoice_Id||
3101: ' P_Calling_Mode ='||P_Calling_Mode||
3102: ' P_Error_Code = '||P_Error_Code||
3103: ' P_Calling_Sequence = '||P_Calling_Sequence);
3104: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3105: END IF;
3106:
3107: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3108: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,sqlerrm);

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

3312: WHEN NO_DATA_FOUND THEN NULL;
3313:
3314: WHEN OTHERS THEN
3315: IF (SQLCODE <> -20001) THEN
3316: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3317: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3318: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3319: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3320: ' P_Invoice_Id = '||P_Invoice_Id||

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

3313:
3314: WHEN OTHERS THEN
3315: IF (SQLCODE <> -20001) THEN
3316: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3317: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3318: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3319: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3320: ' P_Invoice_Id = '||P_Invoice_Id||
3321: ' P_Error_Code = '||P_Error_Code||

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

3314: WHEN OTHERS THEN
3315: IF (SQLCODE <> -20001) THEN
3316: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3317: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3318: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3319: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3320: ' P_Invoice_Id = '||P_Invoice_Id||
3321: ' P_Error_Code = '||P_Error_Code||
3322: ' P_Calling_Sequence = '||P_Calling_Sequence);

Line 3319: FND_MESSAGE.SET_TOKEN('PARAMETERS',

3315: IF (SQLCODE <> -20001) THEN
3316: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3317: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3318: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3319: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3320: ' P_Invoice_Id = '||P_Invoice_Id||
3321: ' P_Error_Code = '||P_Error_Code||
3322: ' P_Calling_Sequence = '||P_Calling_Sequence);
3323: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

3319: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3320: ' P_Invoice_Id = '||P_Invoice_Id||
3321: ' P_Error_Code = '||P_Error_Code||
3322: ' P_Calling_Sequence = '||P_Calling_Sequence);
3323: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3324: END IF;
3325:
3326: APP_EXCEPTION.RAISE_EXCEPTION;
3327: END;

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

3620:
3621: EXCEPTION
3622: WHEN OTHERS THEN
3623: IF (SQLCODE <> -20001) THEN
3624: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3625: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3626: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3627: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3628: ' P_Invoice_Id = '||P_Invoice_Id||

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

3621: EXCEPTION
3622: WHEN OTHERS THEN
3623: IF (SQLCODE <> -20001) THEN
3624: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3625: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3626: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3627: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3628: ' P_Invoice_Id = '||P_Invoice_Id||
3629: ' P_Calling_Mode ='||P_Calling_Mode||

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

3622: WHEN OTHERS THEN
3623: IF (SQLCODE <> -20001) THEN
3624: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3625: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3626: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3627: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3628: ' P_Invoice_Id = '||P_Invoice_Id||
3629: ' P_Calling_Mode ='||P_Calling_Mode||
3630: ' P_Error_Code = '||P_Error_Code||

Line 3627: FND_MESSAGE.SET_TOKEN('PARAMETERS',

3623: IF (SQLCODE <> -20001) THEN
3624: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3625: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3626: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3627: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3628: ' P_Invoice_Id = '||P_Invoice_Id||
3629: ' P_Calling_Mode ='||P_Calling_Mode||
3630: ' P_Error_Code = '||P_Error_Code||
3631: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

3628: ' P_Invoice_Id = '||P_Invoice_Id||
3629: ' P_Calling_Mode ='||P_Calling_Mode||
3630: ' P_Error_Code = '||P_Error_Code||
3631: ' P_Calling_Sequence = '||P_Calling_Sequence);
3632: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3633: END IF;
3634:
3635: APP_EXCEPTION.RAISE_EXCEPTION;
3636:

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

3864:
3865: EXCEPTION
3866: WHEN OTHERS THEN
3867: IF (SQLCODE <> -20001) THEN
3868: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3869: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3870: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3871: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3872: ' P_Invoice_Id = '||P_Invoice_Id||

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

3865: EXCEPTION
3866: WHEN OTHERS THEN
3867: IF (SQLCODE <> -20001) THEN
3868: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3869: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3870: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3871: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3872: ' P_Invoice_Id = '||P_Invoice_Id||
3873: ' P_Calling_Mode ='||P_Calling_Mode||

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

3866: WHEN OTHERS THEN
3867: IF (SQLCODE <> -20001) THEN
3868: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3869: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3870: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3871: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3872: ' P_Invoice_Id = '||P_Invoice_Id||
3873: ' P_Calling_Mode ='||P_Calling_Mode||
3874: ' P_Error_Code = '||P_Error_Code||

Line 3871: FND_MESSAGE.SET_TOKEN('PARAMETERS',

3867: IF (SQLCODE <> -20001) THEN
3868: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3869: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3870: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
3871: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3872: ' P_Invoice_Id = '||P_Invoice_Id||
3873: ' P_Calling_Mode ='||P_Calling_Mode||
3874: ' P_Error_Code = '||P_Error_Code||
3875: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

3872: ' P_Invoice_Id = '||P_Invoice_Id||
3873: ' P_Calling_Mode ='||P_Calling_Mode||
3874: ' P_Error_Code = '||P_Error_Code||
3875: ' P_Calling_Sequence = '||P_Calling_Sequence);
3876: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3877: END IF;
3878:
3879: APP_EXCEPTION.RAISE_EXCEPTION;
3880:

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

4282:
4283: EXCEPTION
4284: WHEN OTHERS THEN
4285: IF (SQLCODE <> -20001) THEN
4286: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4287: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4288: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4289: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4290: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||

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

4283: EXCEPTION
4284: WHEN OTHERS THEN
4285: IF (SQLCODE <> -20001) THEN
4286: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4287: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4288: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4289: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4290: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
4291: ' P_Calling_Mode ='||P_Calling_Mode||

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

4284: WHEN OTHERS THEN
4285: IF (SQLCODE <> -20001) THEN
4286: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4287: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4288: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4289: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4290: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
4291: ' P_Calling_Mode ='||P_Calling_Mode||
4292: ' P_Error_Code = '||P_Error_Code||

Line 4289: FND_MESSAGE.SET_TOKEN('PARAMETERS',

4285: IF (SQLCODE <> -20001) THEN
4286: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4287: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4288: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4289: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4290: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
4291: ' P_Calling_Mode ='||P_Calling_Mode||
4292: ' P_Error_Code = '||P_Error_Code||
4293: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

4290: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
4291: ' P_Calling_Mode ='||P_Calling_Mode||
4292: ' P_Error_Code = '||P_Error_Code||
4293: ' P_Calling_Sequence = '||P_Calling_Sequence);
4294: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4295: END IF;
4296:
4297: IF ( Itm_Dist%ISOPEN ) THEN
4298: CLOSE Itm_Dist;

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

4781:
4782: EXCEPTION
4783: WHEN OTHERS THEN
4784: IF (SQLCODE <> -20001) THEN
4785: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4786: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4787: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4788: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4789: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||

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

4782: EXCEPTION
4783: WHEN OTHERS THEN
4784: IF (SQLCODE <> -20001) THEN
4785: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4786: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4787: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4788: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4789: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
4790: ' P_Calling_Mode ='||P_Calling_Mode||

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

4783: WHEN OTHERS THEN
4784: IF (SQLCODE <> -20001) THEN
4785: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4786: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4787: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4788: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4789: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
4790: ' P_Calling_Mode ='||P_Calling_Mode||
4791: ' P_Error_Code = '||P_Error_Code||

Line 4788: FND_MESSAGE.SET_TOKEN('PARAMETERS',

4784: IF (SQLCODE <> -20001) THEN
4785: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4786: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4787: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4788: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4789: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
4790: ' P_Calling_Mode ='||P_Calling_Mode||
4791: ' P_Error_Code = '||P_Error_Code||
4792: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

4789: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_id||
4790: ' P_Calling_Mode ='||P_Calling_Mode||
4791: ' P_Error_Code = '||P_Error_Code||
4792: ' P_Calling_Sequence = '||P_Calling_Sequence);
4793: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4794: END IF;
4795:
4796: IF ( tax_dist%ISOPEN ) THEN
4797: CLOSE tax_dist;

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

4912:
4913: EXCEPTION
4914: WHEN OTHERS THEN
4915: IF (SQLCODE <> -20001) THEN
4916: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4917: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4918: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4919: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4920: ' P_Invoice_Id = '||P_Invoice_Id||

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

4913: EXCEPTION
4914: WHEN OTHERS THEN
4915: IF (SQLCODE <> -20001) THEN
4916: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4917: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4918: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4919: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4920: ' P_Invoice_Id = '||P_Invoice_Id||
4921: ' P_Calling_Mode ='||P_Calling_Mode||

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

4914: WHEN OTHERS THEN
4915: IF (SQLCODE <> -20001) THEN
4916: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4917: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4918: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4919: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4920: ' P_Invoice_Id = '||P_Invoice_Id||
4921: ' P_Calling_Mode ='||P_Calling_Mode||
4922: ' P_Error_Code = '||P_Error_Code||

Line 4919: FND_MESSAGE.SET_TOKEN('PARAMETERS',

4915: IF (SQLCODE <> -20001) THEN
4916: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4917: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4918: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
4919: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4920: ' P_Invoice_Id = '||P_Invoice_Id||
4921: ' P_Calling_Mode ='||P_Calling_Mode||
4922: ' P_Error_Code = '||P_Error_Code||
4923: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

4920: ' P_Invoice_Id = '||P_Invoice_Id||
4921: ' P_Calling_Mode ='||P_Calling_Mode||
4922: ' P_Error_Code = '||P_Error_Code||
4923: ' P_Calling_Sequence = '||P_Calling_Sequence);
4924: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4925: END IF;
4926:
4927: APP_EXCEPTION.RAISE_EXCEPTION;
4928:

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

5140:
5141: EXCEPTION
5142: WHEN OTHERS THEN
5143: IF (SQLCODE <> -20001) THEN
5144: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5145: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5146: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5147: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5148: ' P_Invoice_Id = '||P_Invoice_Id||

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

5141: EXCEPTION
5142: WHEN OTHERS THEN
5143: IF (SQLCODE <> -20001) THEN
5144: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5145: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5146: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5147: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5148: ' P_Invoice_Id = '||P_Invoice_Id||
5149: ' P_Calling_Mode ='||P_Calling_Mode||

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

5142: WHEN OTHERS THEN
5143: IF (SQLCODE <> -20001) THEN
5144: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5145: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5146: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5147: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5148: ' P_Invoice_Id = '||P_Invoice_Id||
5149: ' P_Calling_Mode ='||P_Calling_Mode||
5150: ' P_Error_Code = '||P_Error_Code||

Line 5147: FND_MESSAGE.SET_TOKEN('PARAMETERS',

5143: IF (SQLCODE <> -20001) THEN
5144: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5145: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5146: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5147: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5148: ' P_Invoice_Id = '||P_Invoice_Id||
5149: ' P_Calling_Mode ='||P_Calling_Mode||
5150: ' P_Error_Code = '||P_Error_Code||
5151: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

5148: ' P_Invoice_Id = '||P_Invoice_Id||
5149: ' P_Calling_Mode ='||P_Calling_Mode||
5150: ' P_Error_Code = '||P_Error_Code||
5151: ' P_Calling_Sequence = '||P_Calling_Sequence);
5152: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5153: END IF;
5154:
5155: APP_EXCEPTION.RAISE_EXCEPTION;
5156:

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

5365:
5366: EXCEPTION
5367: WHEN OTHERS THEN
5368: IF (SQLCODE <> -20001) THEN
5369: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5370: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5371: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5372: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5373: ' P_Invoice_Id = '||P_Invoice_Id||

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

5366: EXCEPTION
5367: WHEN OTHERS THEN
5368: IF (SQLCODE <> -20001) THEN
5369: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5370: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5371: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5372: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5373: ' P_Invoice_Id = '||P_Invoice_Id||
5374: ' P_Line_Number_To_Delete = '||P_Line_Number_To_Delete||

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

5367: WHEN OTHERS THEN
5368: IF (SQLCODE <> -20001) THEN
5369: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5370: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5371: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5372: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5373: ' P_Invoice_Id = '||P_Invoice_Id||
5374: ' P_Line_Number_To_Delete = '||P_Line_Number_To_Delete||
5375: ' P_Calling_Mode ='||P_Calling_Mode||

Line 5372: FND_MESSAGE.SET_TOKEN('PARAMETERS',

5368: IF (SQLCODE <> -20001) THEN
5369: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5370: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5371: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5372: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5373: ' P_Invoice_Id = '||P_Invoice_Id||
5374: ' P_Line_Number_To_Delete = '||P_Line_Number_To_Delete||
5375: ' P_Calling_Mode ='||P_Calling_Mode||
5376: ' P_Error_Code = '||P_Error_Code||

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

5374: ' P_Line_Number_To_Delete = '||P_Line_Number_To_Delete||
5375: ' P_Calling_Mode ='||P_Calling_Mode||
5376: ' P_Error_Code = '||P_Error_Code||
5377: ' P_Calling_Sequence = '||P_Calling_Sequence);
5378: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5379: END IF;
5380:
5381: APP_EXCEPTION.RAISE_EXCEPTION;
5382:

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

5998: the whole the import program and all the imported invoices are rolled back
5999: The invoice causing the exception will be rejected and we will continue
6000: with import program
6001: IF (SQLCODE <> -20001) THEN
6002: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6003: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6004: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6005: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6006: ' Invoice_Id = '||P_Invoice_Rec.Invoice_Id||

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

5999: The invoice causing the exception will be rejected and we will continue
6000: with import program
6001: IF (SQLCODE <> -20001) THEN
6002: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6003: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6004: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6005: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6006: ' Invoice_Id = '||P_Invoice_Rec.Invoice_Id||
6007: ' P_Calling_Mode ='||P_Calling_Mode||

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

6000: with import program
6001: IF (SQLCODE <> -20001) THEN
6002: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6003: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6004: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6005: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6006: ' Invoice_Id = '||P_Invoice_Rec.Invoice_Id||
6007: ' P_Calling_Mode ='||P_Calling_Mode||
6008: ' P_Error_Code = '||P_Error_Code||

Line 6005: FND_MESSAGE.SET_TOKEN('PARAMETERS',

6001: IF (SQLCODE <> -20001) THEN
6002: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6003: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6004: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6005: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6006: ' Invoice_Id = '||P_Invoice_Rec.Invoice_Id||
6007: ' P_Calling_Mode ='||P_Calling_Mode||
6008: ' P_Error_Code = '||P_Error_Code||
6009: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

6006: ' Invoice_Id = '||P_Invoice_Rec.Invoice_Id||
6007: ' P_Calling_Mode ='||P_Calling_Mode||
6008: ' P_Error_Code = '||P_Error_Code||
6009: ' P_Calling_Sequence = '||P_Calling_Sequence);
6010: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
6011: END IF;
6012:
6013: APP_EXCEPTION.RAISE_EXCEPTION;*/
6014: --IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

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

6446:
6447: EXCEPTION
6448: WHEN OTHERS THEN
6449: IF (SQLCODE <> -20001) THEN
6450: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6451: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6452: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6453: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6454: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||

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

6447: EXCEPTION
6448: WHEN OTHERS THEN
6449: IF (SQLCODE <> -20001) THEN
6450: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6451: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6452: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6453: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6454: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
6455: ' P_Calling_Mode ='||P_Calling_Mode||

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

6448: WHEN OTHERS THEN
6449: IF (SQLCODE <> -20001) THEN
6450: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6451: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6452: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6453: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6454: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
6455: ' P_Calling_Mode ='||P_Calling_Mode||
6456: ' P_Error_Code = '||P_Error_Code||

Line 6453: FND_MESSAGE.SET_TOKEN('PARAMETERS',

6449: IF (SQLCODE <> -20001) THEN
6450: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6451: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6452: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6453: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6454: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
6455: ' P_Calling_Mode ='||P_Calling_Mode||
6456: ' P_Error_Code = '||P_Error_Code||
6457: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

6454: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
6455: ' P_Calling_Mode ='||P_Calling_Mode||
6456: ' P_Error_Code = '||P_Error_Code||
6457: ' P_Calling_Sequence = '||P_Calling_Sequence);
6458: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
6459: END IF;
6460:
6461: IF ( tax_related_invoice%ISOPEN ) THEN
6462: CLOSE tax_related_invoice;

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

6841:
6842: EXCEPTION
6843: WHEN OTHERS THEN
6844: IF (SQLCODE <> -20001) THEN
6845: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6846: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6847: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6848: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6849: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||

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

6842: EXCEPTION
6843: WHEN OTHERS THEN
6844: IF (SQLCODE <> -20001) THEN
6845: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6846: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6847: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6848: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6849: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
6850: ' P_Calling_Mode ='||P_Calling_Mode||

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

6843: WHEN OTHERS THEN
6844: IF (SQLCODE <> -20001) THEN
6845: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6846: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6847: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6848: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6849: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
6850: ' P_Calling_Mode ='||P_Calling_Mode||
6851: ' P_Error_Code = '||P_Error_Code||

Line 6848: FND_MESSAGE.SET_TOKEN('PARAMETERS',

6844: IF (SQLCODE <> -20001) THEN
6845: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6846: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6847: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6848: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6849: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
6850: ' P_Calling_Mode ='||P_Calling_Mode||
6851: ' P_Error_Code = '||P_Error_Code||
6852: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

6849: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
6850: ' P_Calling_Mode ='||P_Calling_Mode||
6851: ' P_Error_Code = '||P_Error_Code||
6852: ' P_Calling_Sequence = '||P_Calling_Sequence);
6853: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
6854: END IF;
6855:
6856: IF ( tax_related_invoice%ISOPEN ) THEN
6857: CLOSE tax_related_invoice;

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

8118:
8119: EXCEPTION
8120: WHEN OTHERS THEN
8121: IF (SQLCODE <> -20001) THEN
8122: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
8123: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8124: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
8125: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8126: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||

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

8119: EXCEPTION
8120: WHEN OTHERS THEN
8121: IF (SQLCODE <> -20001) THEN
8122: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
8123: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8124: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
8125: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8126: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
8127: ' P_Calling_Mode ='||P_Calling_Mode||

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

8120: WHEN OTHERS THEN
8121: IF (SQLCODE <> -20001) THEN
8122: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
8123: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8124: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
8125: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8126: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
8127: ' P_Calling_Mode ='||P_Calling_Mode||
8128: ' P_Error_Code = '||P_Error_Code||

Line 8125: FND_MESSAGE.SET_TOKEN('PARAMETERS',

8121: IF (SQLCODE <> -20001) THEN
8122: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
8123: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8124: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
8125: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8126: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
8127: ' P_Calling_Mode ='||P_Calling_Mode||
8128: ' P_Error_Code = '||P_Error_Code||
8129: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

8126: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
8127: ' P_Calling_Mode ='||P_Calling_Mode||
8128: ' P_Error_Code = '||P_Error_Code||
8129: ' P_Calling_Sequence = '||P_Calling_Sequence);
8130: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
8131: END IF;
8132:
8133: --bug10140354
8134: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN

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

9947:
9948: EXCEPTION
9949: WHEN OTHERS THEN
9950: IF (SQLCODE <> -20001) THEN
9951: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9952: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9953: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9954: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9955: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||

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

9948: EXCEPTION
9949: WHEN OTHERS THEN
9950: IF (SQLCODE <> -20001) THEN
9951: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9952: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9953: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9954: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9955: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
9956: ' P_Calling_Mode ='||P_Calling_Mode||

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

9949: WHEN OTHERS THEN
9950: IF (SQLCODE <> -20001) THEN
9951: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9952: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9953: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9954: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9955: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
9956: ' P_Calling_Mode ='||P_Calling_Mode||
9957: ' P_Error_Code = '||P_Error_Code||

Line 9954: FND_MESSAGE.SET_TOKEN('PARAMETERS',

9950: IF (SQLCODE <> -20001) THEN
9951: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
9952: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
9953: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
9954: FND_MESSAGE.SET_TOKEN('PARAMETERS',
9955: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
9956: ' P_Calling_Mode ='||P_Calling_Mode||
9957: ' P_Error_Code = '||P_Error_Code||
9958: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

9955: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
9956: ' P_Calling_Mode ='||P_Calling_Mode||
9957: ' P_Error_Code = '||P_Error_Code||
9958: ' P_Calling_Sequence = '||P_Calling_Sequence);
9959: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
9960: END IF;
9961:
9962: APP_EXCEPTION.RAISE_EXCEPTION;
9963:

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

10956:
10957: EXCEPTION
10958: WHEN OTHERS THEN
10959: IF (SQLCODE <> -20001) THEN
10960: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
10961: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
10962: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
10963: FND_MESSAGE.SET_TOKEN('PARAMETERS',
10964: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||

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

10957: EXCEPTION
10958: WHEN OTHERS THEN
10959: IF (SQLCODE <> -20001) THEN
10960: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
10961: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
10962: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
10963: FND_MESSAGE.SET_TOKEN('PARAMETERS',
10964: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
10965: ' P_Calling_Mode ='||P_Calling_Mode||

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

10958: WHEN OTHERS THEN
10959: IF (SQLCODE <> -20001) THEN
10960: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
10961: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
10962: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
10963: FND_MESSAGE.SET_TOKEN('PARAMETERS',
10964: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
10965: ' P_Calling_Mode ='||P_Calling_Mode||
10966: ' P_Error_Code = '||P_Error_Code||

Line 10963: FND_MESSAGE.SET_TOKEN('PARAMETERS',

10959: IF (SQLCODE <> -20001) THEN
10960: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
10961: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
10962: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
10963: FND_MESSAGE.SET_TOKEN('PARAMETERS',
10964: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
10965: ' P_Calling_Mode ='||P_Calling_Mode||
10966: ' P_Error_Code = '||P_Error_Code||
10967: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

10964: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
10965: ' P_Calling_Mode ='||P_Calling_Mode||
10966: ' P_Error_Code = '||P_Error_Code||
10967: ' P_Calling_Sequence = '||P_Calling_Sequence);
10968: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
10969: END IF;
10970:
10971: --bug10140354
10972: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN

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

11622:
11623: EXCEPTION
11624: WHEN OTHERS THEN
11625: IF (SQLCODE <> -20001) THEN
11626: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
11627: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
11628: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
11629: FND_MESSAGE.SET_TOKEN('PARAMETERS',
11630: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||

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

11623: EXCEPTION
11624: WHEN OTHERS THEN
11625: IF (SQLCODE <> -20001) THEN
11626: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
11627: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
11628: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
11629: FND_MESSAGE.SET_TOKEN('PARAMETERS',
11630: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
11631: ' P_Calling_Mode ='||P_Calling_Mode||

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

11624: WHEN OTHERS THEN
11625: IF (SQLCODE <> -20001) THEN
11626: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
11627: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
11628: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
11629: FND_MESSAGE.SET_TOKEN('PARAMETERS',
11630: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
11631: ' P_Calling_Mode ='||P_Calling_Mode||
11632: ' P_Error_Code = '||P_Error_Code||

Line 11629: FND_MESSAGE.SET_TOKEN('PARAMETERS',

11625: IF (SQLCODE <> -20001) THEN
11626: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
11627: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
11628: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
11629: FND_MESSAGE.SET_TOKEN('PARAMETERS',
11630: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
11631: ' P_Calling_Mode ='||P_Calling_Mode||
11632: ' P_Error_Code = '||P_Error_Code||
11633: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

11630: ' P_Invoice_Header_Rec = '||P_Invoice_Header_Rec.Invoice_Id||
11631: ' P_Calling_Mode ='||P_Calling_Mode||
11632: ' P_Error_Code = '||P_Error_Code||
11633: ' P_Calling_Sequence = '||P_Calling_Sequence);
11634: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
11635: END IF;
11636:
11637: APP_EXCEPTION.RAISE_EXCEPTION;
11638: END Populate_Distributions_GT;

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

11779:
11780: EXCEPTION
11781: WHEN OTHERS THEN
11782: IF (SQLCODE <> -20001) THEN
11783: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
11784: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
11785: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
11786: FND_MESSAGE.SET_TOKEN('PARAMETERS',
11787: ' P_Invoice_Id = '||P_Invoice_header_rec.Invoice_Id||

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

11780: EXCEPTION
11781: WHEN OTHERS THEN
11782: IF (SQLCODE <> -20001) THEN
11783: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
11784: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
11785: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
11786: FND_MESSAGE.SET_TOKEN('PARAMETERS',
11787: ' P_Invoice_Id = '||P_Invoice_header_rec.Invoice_Id||
11788: ' P_Calling_Mode ='||P_Calling_Mode||

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

11781: WHEN OTHERS THEN
11782: IF (SQLCODE <> -20001) THEN
11783: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
11784: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
11785: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
11786: FND_MESSAGE.SET_TOKEN('PARAMETERS',
11787: ' P_Invoice_Id = '||P_Invoice_header_rec.Invoice_Id||
11788: ' P_Calling_Mode ='||P_Calling_Mode||
11789: ' P_Error_Code = '||P_Error_Code||

Line 11786: FND_MESSAGE.SET_TOKEN('PARAMETERS',

11782: IF (SQLCODE <> -20001) THEN
11783: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
11784: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
11785: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
11786: FND_MESSAGE.SET_TOKEN('PARAMETERS',
11787: ' P_Invoice_Id = '||P_Invoice_header_rec.Invoice_Id||
11788: ' P_Calling_Mode ='||P_Calling_Mode||
11789: ' P_Error_Code = '||P_Error_Code||
11790: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

11787: ' P_Invoice_Id = '||P_Invoice_header_rec.Invoice_Id||
11788: ' P_Calling_Mode ='||P_Calling_Mode||
11789: ' P_Error_Code = '||P_Error_Code||
11790: ' P_Calling_Sequence = '||P_Calling_Sequence);
11791: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
11792: END IF;
11793:
11794: --bug10140354
11795: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN

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

12295: EXCEPTION
12296: WHEN OTHERS THEN
12297: IF (SQLCODE <> -20001) THEN
12298:
12299: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12300: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12301: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12302: FND_MESSAGE.SET_TOKEN('PARAMETERS',
12303: ' P_Invoice_Header_Rec.Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||

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

12296: WHEN OTHERS THEN
12297: IF (SQLCODE <> -20001) THEN
12298:
12299: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12300: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12301: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12302: FND_MESSAGE.SET_TOKEN('PARAMETERS',
12303: ' P_Invoice_Header_Rec.Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
12304: ' P_Calling_Mode ='||P_Calling_Mode||

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

12297: IF (SQLCODE <> -20001) THEN
12298:
12299: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12300: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12301: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12302: FND_MESSAGE.SET_TOKEN('PARAMETERS',
12303: ' P_Invoice_Header_Rec.Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
12304: ' P_Calling_Mode ='||P_Calling_Mode||
12305: ' P_Error_Code = '||P_Error_Code);

Line 12302: FND_MESSAGE.SET_TOKEN('PARAMETERS',

12298:
12299: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
12300: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
12301: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
12302: FND_MESSAGE.SET_TOKEN('PARAMETERS',
12303: ' P_Invoice_Header_Rec.Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
12304: ' P_Calling_Mode ='||P_Calling_Mode||
12305: ' P_Error_Code = '||P_Error_Code);
12306: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

12302: FND_MESSAGE.SET_TOKEN('PARAMETERS',
12303: ' P_Invoice_Header_Rec.Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
12304: ' P_Calling_Mode ='||P_Calling_Mode||
12305: ' P_Error_Code = '||P_Error_Code);
12306: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
12307: END IF;
12308:
12309: APP_EXCEPTION.RAISE_EXCEPTION;
12310:

Line 13772: FND_MESSAGE.SET_NAME('SQLAP','AP_ERR_TAX_DIST_SYNC');

13768: END IF;
13769: -----------------------------------------------------------------
13770:
13771: IF l_unrev_dist_count > 0 THEN
13772: FND_MESSAGE.SET_NAME('SQLAP','AP_ERR_TAX_DIST_SYNC');
13773: APP_EXCEPTION.RAISE_EXCEPTION;
13774: END IF ;
13775: END IF;
13776: -- Bug 10140793 End

Line 13900: FND_MESSAGE.SET_NAME('SQLAP','AP_ERR_TAX_DIST_SYNC');

13896: END IF;
13897: -----------------------------------------------------------------
13898:
13899: IF l_unrev_sa_dist_count > 0 THEN
13900: FND_MESSAGE.SET_NAME('SQLAP','AP_ERR_TAX_DIST_SYNC');
13901: APP_EXCEPTION.RAISE_EXCEPTION;
13902: END IF ;
13903: END IF;
13904: -- Bug 10140793 End

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

14095: WHEN NO_DATA_FOUND THEN
14096: NULL;
14097: WHEN OTHERS THEN
14098: IF (SQLCODE <> -20001) THEN
14099: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14100: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14101: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14102: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14103: ' P_Invoice_Id = '||P_Invoice_Id||

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

14096: NULL;
14097: WHEN OTHERS THEN
14098: IF (SQLCODE <> -20001) THEN
14099: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14100: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14101: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14102: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14103: ' P_Invoice_Id = '||P_Invoice_Id||
14104: ' P_Calling_Sequence = '||l_curr_calling_sequence);

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

14097: WHEN OTHERS THEN
14098: IF (SQLCODE <> -20001) THEN
14099: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14100: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14101: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14102: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14103: ' P_Invoice_Id = '||P_Invoice_Id||
14104: ' P_Calling_Sequence = '||l_curr_calling_sequence);
14105: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 14102: FND_MESSAGE.SET_TOKEN('PARAMETERS',

14098: IF (SQLCODE <> -20001) THEN
14099: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
14100: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
14101: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14102: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14103: ' P_Invoice_Id = '||P_Invoice_Id||
14104: ' P_Calling_Sequence = '||l_curr_calling_sequence);
14105: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14106: END IF;

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

14101: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
14102: FND_MESSAGE.SET_TOKEN('PARAMETERS',
14103: ' P_Invoice_Id = '||P_Invoice_Id||
14104: ' P_Calling_Sequence = '||l_curr_calling_sequence);
14105: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
14106: END IF;
14107: APP_EXCEPTION.RAISE_EXCEPTION;
14108: END;
14109:

Line 14576: FND_MESSAGE.SET_NAME('SQLAP','AP_ERR_TAX_DIST_SYNC');

14572: END IF;
14573: -----------------------------------------------------------------
14574:
14575: IF ( l_reverse_dist_count <> 0 AND l_rev_dist_cursor_count = 0 ) THEN
14576: FND_MESSAGE.SET_NAME('SQLAP','AP_ERR_TAX_DIST_SYNC');
14577: APP_EXCEPTION.RAISE_EXCEPTION;
14578: END IF ;
14579: -- Bug 10140793 End
14580:

Line 14980: FND_MESSAGE.SET_NAME('SQLAP','AP_ERR_TAX_DIST_SYNC');

14976: END IF;
14977: -----------------------------------------------------------------
14978:
14979: IF ( l_rev_sa_dist_count <> 0 AND l_rev_sa_dist_cursor_count = 0 ) THEN
14980: FND_MESSAGE.SET_NAME('SQLAP','AP_ERR_TAX_DIST_SYNC');
14981: APP_EXCEPTION.RAISE_EXCEPTION;
14982: END IF ;
14983: -- Bug 10140793 End
14984:

Line 15368: FND_MESSAGE.SET_NAME('SQLAP','AP_ERR_TAX_DIST_SYNC');

15364: END IF;
15365: -----------------------------------------------------------------
15366:
15367: IF ( l_reverse_dist_count <> 0 AND l_rev_dist_cursor_count = 0 ) THEN
15368: FND_MESSAGE.SET_NAME('SQLAP','AP_ERR_TAX_DIST_SYNC');
15369: APP_EXCEPTION.RAISE_EXCEPTION;
15370: END IF ;
15371: -- Bug 10140793 End
15372:

Line 15722: FND_MESSAGE.SET_NAME('SQLAP','AP_ERR_TAX_DIST_SYNC');

15718: END IF;
15719: -----------------------------------------------------------------
15720:
15721: IF ( l_rev_sa_dist_count <> 0 AND l_rev_sa_dist_cursor_count = 0 ) THEN
15722: FND_MESSAGE.SET_NAME('SQLAP','AP_ERR_TAX_DIST_SYNC');
15723: APP_EXCEPTION.RAISE_EXCEPTION;
15724: END IF ;
15725: -- Bug 10140793 End
15726:

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

15867: END IF;
15868:
15869: IF (SQLCODE <> -20001) THEN
15870:
15871: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
15872: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
15873: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
15874: FND_MESSAGE.SET_TOKEN('PARAMETERS',
15875: ' P_Invoice_Id = '||P_Invoice_Id);

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

15868:
15869: IF (SQLCODE <> -20001) THEN
15870:
15871: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
15872: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
15873: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
15874: FND_MESSAGE.SET_TOKEN('PARAMETERS',
15875: ' P_Invoice_Id = '||P_Invoice_Id);
15876: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

15869: IF (SQLCODE <> -20001) THEN
15870:
15871: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
15872: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
15873: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
15874: FND_MESSAGE.SET_TOKEN('PARAMETERS',
15875: ' P_Invoice_Id = '||P_Invoice_Id);
15876: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
15877: END IF;

Line 15874: FND_MESSAGE.SET_TOKEN('PARAMETERS',

15870:
15871: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
15872: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
15873: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
15874: FND_MESSAGE.SET_TOKEN('PARAMETERS',
15875: ' P_Invoice_Id = '||P_Invoice_Id);
15876: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
15877: END IF;
15878:

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

15872: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
15873: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
15874: FND_MESSAGE.SET_TOKEN('PARAMETERS',
15875: ' P_Invoice_Id = '||P_Invoice_Id);
15876: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
15877: END IF;
15878:
15879: APP_EXCEPTION.RAISE_EXCEPTION;
15880:

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

16125: END IF;
16126:
16127: IF (SQLCODE <> -20001) THEN
16128:
16129: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
16130: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
16131: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
16132: FND_MESSAGE.SET_TOKEN('PARAMETERS',
16133: ' P_Invoice_Id = '||P_Invoice_Id);

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

16126:
16127: IF (SQLCODE <> -20001) THEN
16128:
16129: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
16130: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
16131: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
16132: FND_MESSAGE.SET_TOKEN('PARAMETERS',
16133: ' P_Invoice_Id = '||P_Invoice_Id);
16134: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

16127: IF (SQLCODE <> -20001) THEN
16128:
16129: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
16130: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
16131: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
16132: FND_MESSAGE.SET_TOKEN('PARAMETERS',
16133: ' P_Invoice_Id = '||P_Invoice_Id);
16134: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
16135: END IF;

Line 16132: FND_MESSAGE.SET_TOKEN('PARAMETERS',

16128:
16129: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
16130: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
16131: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
16132: FND_MESSAGE.SET_TOKEN('PARAMETERS',
16133: ' P_Invoice_Id = '||P_Invoice_Id);
16134: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
16135: END IF;
16136:

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

16130: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
16131: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
16132: FND_MESSAGE.SET_TOKEN('PARAMETERS',
16133: ' P_Invoice_Id = '||P_Invoice_Id);
16134: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
16135: END IF;
16136:
16137: DELETE FROM ZX_TRX_HEADERS_GT;
16138: DELETE FROM ZX_TRANSACTION_LINES_GT;

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

16362: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Exception: '||sqlerrm);
16363: END IF;
16364:
16365: IF (SQLCODE <> -20001) THEN
16366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
16367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
16368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
16369: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = '||P_Invoice_Id);
16370: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

16363: END IF;
16364:
16365: IF (SQLCODE <> -20001) THEN
16366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
16367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
16368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
16369: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = '||P_Invoice_Id);
16370: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
16371: END IF;

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

16364:
16365: IF (SQLCODE <> -20001) THEN
16366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
16367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
16368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
16369: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = '||P_Invoice_Id);
16370: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
16371: END IF;
16372:

Line 16369: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = '||P_Invoice_Id);

16365: IF (SQLCODE <> -20001) THEN
16366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
16367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
16368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
16369: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = '||P_Invoice_Id);
16370: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
16371: END IF;
16372:
16373: APP_EXCEPTION.RAISE_EXCEPTION;

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

16366: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
16367: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
16368: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
16369: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = '||P_Invoice_Id);
16370: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
16371: END IF;
16372:
16373: APP_EXCEPTION.RAISE_EXCEPTION;
16374:

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

16742:
16743: EXCEPTION
16744: WHEN OTHERS THEN
16745: IF (SQLCODE <> -20001) THEN
16746: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
16747: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
16748: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
16749: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Id ||
16750: ' P_Calling_Mode =' ||P_Calling_Mode||

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

16743: EXCEPTION
16744: WHEN OTHERS THEN
16745: IF (SQLCODE <> -20001) THEN
16746: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
16747: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
16748: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
16749: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Id ||
16750: ' P_Calling_Mode =' ||P_Calling_Mode||
16751: ' P_Error_Code = ' ||P_Error_Code ||

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

16744: WHEN OTHERS THEN
16745: IF (SQLCODE <> -20001) THEN
16746: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
16747: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
16748: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
16749: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Id ||
16750: ' P_Calling_Mode =' ||P_Calling_Mode||
16751: ' P_Error_Code = ' ||P_Error_Code ||
16752: ' P_Calling_Sequence = '||P_Calling_Sequence);

Line 16749: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Id ||

16745: IF (SQLCODE <> -20001) THEN
16746: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
16747: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
16748: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
16749: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Id ||
16750: ' P_Calling_Mode =' ||P_Calling_Mode||
16751: ' P_Error_Code = ' ||P_Error_Code ||
16752: ' P_Calling_Sequence = '||P_Calling_Sequence);
16753: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

16749: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Id ||
16750: ' P_Calling_Mode =' ||P_Calling_Mode||
16751: ' P_Error_Code = ' ||P_Error_Code ||
16752: ' P_Calling_Sequence = '||P_Calling_Sequence);
16753: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
16754:
16755: END IF;
16756:
16757: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

17131:
17132: EXCEPTION
17133: WHEN OTHERS THEN
17134: IF (SQLCODE <> -20001) THEN
17135: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
17136: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
17137: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
17138: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id ||
17139: ' P_Error_Code = ' ||P_Error_Code ||

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

17132: EXCEPTION
17133: WHEN OTHERS THEN
17134: IF (SQLCODE <> -20001) THEN
17135: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
17136: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
17137: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
17138: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id ||
17139: ' P_Error_Code = ' ||P_Error_Code ||
17140: ' P_Calling_Sequence = '||P_Calling_Sequence);

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

17133: WHEN OTHERS THEN
17134: IF (SQLCODE <> -20001) THEN
17135: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
17136: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
17137: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
17138: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id ||
17139: ' P_Error_Code = ' ||P_Error_Code ||
17140: ' P_Calling_Sequence = '||P_Calling_Sequence);
17141: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 17138: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id ||

17134: IF (SQLCODE <> -20001) THEN
17135: FND_MESSAGE.SET_NAME ('SQLAP', 'AP_DEBUG');
17136: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
17137: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
17138: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id ||
17139: ' P_Error_Code = ' ||P_Error_Code ||
17140: ' P_Calling_Sequence = '||P_Calling_Sequence);
17141: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
17142:

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

17137: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
17138: FND_MESSAGE.SET_TOKEN('PARAMETERS', ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id ||
17139: ' P_Error_Code = ' ||P_Error_Code ||
17140: ' P_Calling_Sequence = '||P_Calling_Sequence);
17141: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
17142:
17143: END IF;
17144:
17145: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

17898: END IF;
17899:
17900: WHEN OTHERS THEN
17901: IF (SQLCODE <> -20001) THEN
17902: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
17903: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
17904: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
17905: FND_MESSAGE.SET_TOKEN('PARAMETERS',
17906: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||

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

17899:
17900: WHEN OTHERS THEN
17901: IF (SQLCODE <> -20001) THEN
17902: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
17903: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
17904: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
17905: FND_MESSAGE.SET_TOKEN('PARAMETERS',
17906: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
17907: ' P_Error_Code = '||P_Error_Code||

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

17900: WHEN OTHERS THEN
17901: IF (SQLCODE <> -20001) THEN
17902: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
17903: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
17904: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
17905: FND_MESSAGE.SET_TOKEN('PARAMETERS',
17906: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
17907: ' P_Error_Code = '||P_Error_Code||
17908: ' P_Calling_Sequence = '||P_Calling_Sequence);

Line 17905: FND_MESSAGE.SET_TOKEN('PARAMETERS',

17901: IF (SQLCODE <> -20001) THEN
17902: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
17903: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
17904: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
17905: FND_MESSAGE.SET_TOKEN('PARAMETERS',
17906: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
17907: ' P_Error_Code = '||P_Error_Code||
17908: ' P_Calling_Sequence = '||P_Calling_Sequence);
17909: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

17905: FND_MESSAGE.SET_TOKEN('PARAMETERS',
17906: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
17907: ' P_Error_Code = '||P_Error_Code||
17908: ' P_Calling_Sequence = '||P_Calling_Sequence);
17909: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
17910: END IF;
17911:
17912: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
17913: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

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

17994:
17995: EXCEPTION
17996: WHEN OTHERS THEN
17997: IF (SQLCODE <> -20001) THEN
17998: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
17999: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18000: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
18001: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
18002: END IF;

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

17995: EXCEPTION
17996: WHEN OTHERS THEN
17997: IF (SQLCODE <> -20001) THEN
17998: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
17999: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18000: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
18001: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
18002: END IF;
18003: APP_EXCEPTION.RAISE_EXCEPTION;

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

17996: WHEN OTHERS THEN
17997: IF (SQLCODE <> -20001) THEN
17998: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
17999: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18000: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
18001: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
18002: END IF;
18003: APP_EXCEPTION.RAISE_EXCEPTION;
18004: END Cache_Line_Defaults;

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

17997: IF (SQLCODE <> -20001) THEN
17998: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
17999: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18000: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
18001: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
18002: END IF;
18003: APP_EXCEPTION.RAISE_EXCEPTION;
18004: END Cache_Line_Defaults;
18005:

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

18146: NULL;
18147:
18148: WHEN OTHERS THEN
18149: IF (SQLCODE <> -20001) THEN
18150: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18151: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18152: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18153: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18154: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||

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

18147:
18148: WHEN OTHERS THEN
18149: IF (SQLCODE <> -20001) THEN
18150: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18151: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18152: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18153: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18154: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
18155: ' P_Error_Code = '||P_Error_Code||

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

18148: WHEN OTHERS THEN
18149: IF (SQLCODE <> -20001) THEN
18150: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18151: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18152: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18153: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18154: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
18155: ' P_Error_Code = '||P_Error_Code||
18156: ' P_Calling_Sequence = '||P_Calling_Sequence);

Line 18153: FND_MESSAGE.SET_TOKEN('PARAMETERS',

18149: IF (SQLCODE <> -20001) THEN
18150: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18151: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18152: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18153: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18154: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
18155: ' P_Error_Code = '||P_Error_Code||
18156: ' P_Calling_Sequence = '||P_Calling_Sequence);
18157: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

18153: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18154: ' P_Invoice_Id = '||P_Invoice_Header_Rec.Invoice_Id||
18155: ' P_Error_Code = '||P_Error_Code||
18156: ' P_Calling_Sequence = '||P_Calling_Sequence);
18157: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
18158: END IF;
18159:
18160: APP_EXCEPTION.RAISE_EXCEPTION;
18161: END;

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

18579: NULL;
18580:
18581: WHEN OTHERS THEN
18582: IF (SQLCODE <> -20001) THEN
18583: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18584: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18585: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18586: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18587: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||

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

18580:
18581: WHEN OTHERS THEN
18582: IF (SQLCODE <> -20001) THEN
18583: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18584: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18585: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18586: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18587: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
18588: ' P_Error_Code = '||P_Error_Code||

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

18581: WHEN OTHERS THEN
18582: IF (SQLCODE <> -20001) THEN
18583: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18584: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18585: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18586: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18587: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
18588: ' P_Error_Code = '||P_Error_Code||
18589: ' P_Calling_Sequence = '||P_Calling_Sequence);

Line 18586: FND_MESSAGE.SET_TOKEN('PARAMETERS',

18582: IF (SQLCODE <> -20001) THEN
18583: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18584: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18585: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18586: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18587: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
18588: ' P_Error_Code = '||P_Error_Code||
18589: ' P_Calling_Sequence = '||P_Calling_Sequence);
18590: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

18586: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18587: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
18588: ' P_Error_Code = '||P_Error_Code||
18589: ' P_Calling_Sequence = '||P_Calling_Sequence);
18590: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
18591: END IF;
18592:
18593: APP_EXCEPTION.RAISE_EXCEPTION;
18594: END;

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

18616: NULL;
18617:
18618: WHEN OTHERS THEN
18619: IF (SQLCODE <> -20001) THEN
18620: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18621: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18622: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18623: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18624: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||

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

18617:
18618: WHEN OTHERS THEN
18619: IF (SQLCODE <> -20001) THEN
18620: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18621: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18622: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18623: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18624: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
18625: ' P_Error_Code = '||P_Error_Code||

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

18618: WHEN OTHERS THEN
18619: IF (SQLCODE <> -20001) THEN
18620: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18621: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18622: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18623: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18624: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
18625: ' P_Error_Code = '||P_Error_Code||
18626: ' P_Calling_Sequence = '||P_Calling_Sequence);

Line 18623: FND_MESSAGE.SET_TOKEN('PARAMETERS',

18619: IF (SQLCODE <> -20001) THEN
18620: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18621: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18622: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18623: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18624: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
18625: ' P_Error_Code = '||P_Error_Code||
18626: ' P_Calling_Sequence = '||P_Calling_Sequence);
18627: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

18623: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18624: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
18625: ' P_Error_Code = '||P_Error_Code||
18626: ' P_Calling_Sequence = '||P_Calling_Sequence);
18627: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
18628: END IF;
18629:
18630: APP_EXCEPTION.RAISE_EXCEPTION;
18631: END;

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

18673: NULL;
18674:
18675: WHEN OTHERS THEN
18676: IF (SQLCODE <> -20001) THEN
18677: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18678: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18679: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18680: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18681: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||

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

18674:
18675: WHEN OTHERS THEN
18676: IF (SQLCODE <> -20001) THEN
18677: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18678: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18679: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18680: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18681: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
18682: ' P_Error_Code = '||P_Error_Code||

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

18675: WHEN OTHERS THEN
18676: IF (SQLCODE <> -20001) THEN
18677: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18678: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18679: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18680: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18681: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
18682: ' P_Error_Code = '||P_Error_Code||
18683: ' P_Calling_Sequence = '||P_Calling_Sequence);

Line 18680: FND_MESSAGE.SET_TOKEN('PARAMETERS',

18676: IF (SQLCODE <> -20001) THEN
18677: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18678: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18679: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18680: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18681: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
18682: ' P_Error_Code = '||P_Error_Code||
18683: ' P_Calling_Sequence = '||P_Calling_Sequence);
18684: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

18680: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18681: ' P_Invoice_Id = '||P_Invoice_Header_Rec.invoice_id||
18682: ' P_Error_Code = '||P_Error_Code||
18683: ' P_Calling_Sequence = '||P_Calling_Sequence);
18684: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
18685: END IF;
18686:
18687: APP_EXCEPTION.RAISE_EXCEPTION;
18688: END;

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

18717:
18718: EXCEPTION
18719: WHEN OTHERS THEN
18720: IF (SQLCODE <> -20001) THEN
18721: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18722: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18723: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18724: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18725: ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id||

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

18718: EXCEPTION
18719: WHEN OTHERS THEN
18720: IF (SQLCODE <> -20001) THEN
18721: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18722: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18723: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18724: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18725: ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id||
18726: ' P_Error_Code = ' ||P_Error_Code||

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

18719: WHEN OTHERS THEN
18720: IF (SQLCODE <> -20001) THEN
18721: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18722: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18723: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18724: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18725: ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id||
18726: ' P_Error_Code = ' ||P_Error_Code||
18727: ' P_Calling_Sequence = '||P_Calling_Sequence);

Line 18724: FND_MESSAGE.SET_TOKEN('PARAMETERS',

18720: IF (SQLCODE <> -20001) THEN
18721: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18722: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18723: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18724: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18725: ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id||
18726: ' P_Error_Code = ' ||P_Error_Code||
18727: ' P_Calling_Sequence = '||P_Calling_Sequence);
18728: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

18724: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18725: ' P_Invoice_Id = ' ||P_Invoice_Header_Rec.Invoice_Id||
18726: ' P_Error_Code = ' ||P_Error_Code||
18727: ' P_Calling_Sequence = '||P_Calling_Sequence);
18728: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
18729: END IF;
18730:
18731: APP_EXCEPTION.RAISE_EXCEPTION;
18732:

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

18959: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
18960: END IF;
18961: --Print(l_api_name,l_debug_info);
18962:
18963: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18964: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18965: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18966: FND_MESSAGE.SET_TOKEN('PARAMETERS',' P_Invoice_Id = '||p_invoice_id||
18967: ' l_curr_calling_sequence = '||l_curr_calling_sequence);

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

18960: END IF;
18961: --Print(l_api_name,l_debug_info);
18962:
18963: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18964: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18965: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18966: FND_MESSAGE.SET_TOKEN('PARAMETERS',' P_Invoice_Id = '||p_invoice_id||
18967: ' l_curr_calling_sequence = '||l_curr_calling_sequence);
18968: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

18961: --Print(l_api_name,l_debug_info);
18962:
18963: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18964: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18965: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18966: FND_MESSAGE.SET_TOKEN('PARAMETERS',' P_Invoice_Id = '||p_invoice_id||
18967: ' l_curr_calling_sequence = '||l_curr_calling_sequence);
18968: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
18969:

Line 18966: FND_MESSAGE.SET_TOKEN('PARAMETERS',' P_Invoice_Id = '||p_invoice_id||

18962:
18963: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18964: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18965: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18966: FND_MESSAGE.SET_TOKEN('PARAMETERS',' P_Invoice_Id = '||p_invoice_id||
18967: ' l_curr_calling_sequence = '||l_curr_calling_sequence);
18968: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
18969:
18970: APP_EXCEPTION.RAISE_EXCEPTION;

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

18964: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18965: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18966: FND_MESSAGE.SET_TOKEN('PARAMETERS',' P_Invoice_Id = '||p_invoice_id||
18967: ' l_curr_calling_sequence = '||l_curr_calling_sequence);
18968: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
18969:
18970: APP_EXCEPTION.RAISE_EXCEPTION;
18971:
18972: END IF; -- IF p_invoice_id IS NOT NULL THEN

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

18975: Print(l_api_name,l_debug_info);
18976: EXCEPTION
18977: WHEN OTHERS THEN
18978: IF (SQLCODE <> -20001) THEN
18979: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18980: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18981: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18982: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18983: ' P_Invoice_Id = '||p_invoice_id||

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

18976: EXCEPTION
18977: WHEN OTHERS THEN
18978: IF (SQLCODE <> -20001) THEN
18979: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18980: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18981: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18982: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18983: ' P_Invoice_Id = '||p_invoice_id||
18984: ' l_Error_Code ='||l_Error_Code||

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

18977: WHEN OTHERS THEN
18978: IF (SQLCODE <> -20001) THEN
18979: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18980: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18981: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18982: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18983: ' P_Invoice_Id = '||p_invoice_id||
18984: ' l_Error_Code ='||l_Error_Code||
18985: ' l_curr_calling_sequence = '||l_curr_calling_sequence);

Line 18982: FND_MESSAGE.SET_TOKEN('PARAMETERS',

18978: IF (SQLCODE <> -20001) THEN
18979: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
18980: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
18981: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
18982: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18983: ' P_Invoice_Id = '||p_invoice_id||
18984: ' l_Error_Code ='||l_Error_Code||
18985: ' l_curr_calling_sequence = '||l_curr_calling_sequence);
18986: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

18982: FND_MESSAGE.SET_TOKEN('PARAMETERS',
18983: ' P_Invoice_Id = '||p_invoice_id||
18984: ' l_Error_Code ='||l_Error_Code||
18985: ' l_curr_calling_sequence = '||l_curr_calling_sequence);
18986: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
18987: END IF;
18988: APP_EXCEPTION.RAISE_EXCEPTION;
18989: END synchronize_for_doc_seq;
18990: --Bug 7570234 End

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

19222:
19223: EXCEPTION
19224: WHEN OTHERS THEN
19225: IF (SQLCODE <> -20001) THEN
19226: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
19227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
19228: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
19229: FND_MESSAGE.SET_TOKEN('PARAMETERS',
19230: ' P_Invoice_Id = '||p_invoice_id||

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

19223: EXCEPTION
19224: WHEN OTHERS THEN
19225: IF (SQLCODE <> -20001) THEN
19226: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
19227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
19228: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
19229: FND_MESSAGE.SET_TOKEN('PARAMETERS',
19230: ' P_Invoice_Id = '||p_invoice_id||
19231: ' l_Error_Code ='||l_Error_Code||

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

19224: WHEN OTHERS THEN
19225: IF (SQLCODE <> -20001) THEN
19226: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
19227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
19228: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
19229: FND_MESSAGE.SET_TOKEN('PARAMETERS',
19230: ' P_Invoice_Id = '||p_invoice_id||
19231: ' l_Error_Code ='||l_Error_Code||
19232: ' l_curr_calling_sequence = '||l_curr_calling_sequence);

Line 19229: FND_MESSAGE.SET_TOKEN('PARAMETERS',

19225: IF (SQLCODE <> -20001) THEN
19226: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
19227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
19228: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
19229: FND_MESSAGE.SET_TOKEN('PARAMETERS',
19230: ' P_Invoice_Id = '||p_invoice_id||
19231: ' l_Error_Code ='||l_Error_Code||
19232: ' l_curr_calling_sequence = '||l_curr_calling_sequence);
19233: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

19229: FND_MESSAGE.SET_TOKEN('PARAMETERS',
19230: ' P_Invoice_Id = '||p_invoice_id||
19231: ' l_Error_Code ='||l_Error_Code||
19232: ' l_curr_calling_sequence = '||l_curr_calling_sequence);
19233: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
19234: END IF;
19235: APP_EXCEPTION.RAISE_EXCEPTION;
19236: END synchronize_tax_dff;
19237: --Bug9819170