DBA Data[Home] [Help]

APPS.AP_PO_AMT_MATCH_PKG dependencies on FND_MESSAGE

Line 832: fnd_message.set_name('SQLAP','AP_DISTS_NO_OPEN_FUT_PERIOD');

828:
829: IF g_recurring_payment_id is null THEN --Bug 7305223
830:
831: IF (g_accounting_date IS NULL) THEN
832: fnd_message.set_name('SQLAP','AP_DISTS_NO_OPEN_FUT_PERIOD');
833: app_exception.raise_exception;
834: ELSE
835: g_line_accounting_date := g_accounting_date;
836: END IF;

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

851:
852: EXCEPTION
853: WHEN OTHERS THEN
854: IF (SQLCODE <> -20001) THEN
855: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
856: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
857: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
858: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));
859: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

852: EXCEPTION
853: WHEN OTHERS THEN
854: IF (SQLCODE <> -20001) THEN
855: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
856: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
857: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
858: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));
859: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
860: END IF;

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

853: WHEN OTHERS THEN
854: IF (SQLCODE <> -20001) THEN
855: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
856: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
857: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
858: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));
859: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
860: END IF;
861: app_exception.raise_exception;

Line 858: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));

854: IF (SQLCODE <> -20001) THEN
855: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
856: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
857: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
858: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));
859: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
860: END IF;
861: app_exception.raise_exception;
862:

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

855: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
856: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
857: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
858: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));
859: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
860: END IF;
861: app_exception.raise_exception;
862:
863: END Get_Info;

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

1366: EXCEPTION
1367:
1368: WHEN OTHERS THEN
1369: IF (SQLCODE <> -20001) THEN
1370: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1371: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1372: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1373: FND_MESSAGE.SET_TOKEN('PARAMETERS','Shipment id '||to_char(x_po_line_location_id)
1374: ||', Match_mode = '||X_match_mode

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

1367:
1368: WHEN OTHERS THEN
1369: IF (SQLCODE <> -20001) THEN
1370: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1371: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1372: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1373: FND_MESSAGE.SET_TOKEN('PARAMETERS','Shipment id '||to_char(x_po_line_location_id)
1374: ||', Match_mode = '||X_match_mode
1375: ||', Match Quantity = '||x_match_quantity

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

1368: WHEN OTHERS THEN
1369: IF (SQLCODE <> -20001) THEN
1370: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1371: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1372: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1373: FND_MESSAGE.SET_TOKEN('PARAMETERS','Shipment id '||to_char(x_po_line_location_id)
1374: ||', Match_mode = '||X_match_mode
1375: ||', Match Quantity = '||x_match_quantity
1376: ||', Match Amount = '||x_match_amount

Line 1373: FND_MESSAGE.SET_TOKEN('PARAMETERS','Shipment id '||to_char(x_po_line_location_id)

1369: IF (SQLCODE <> -20001) THEN
1370: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1371: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1372: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1373: FND_MESSAGE.SET_TOKEN('PARAMETERS','Shipment id '||to_char(x_po_line_location_id)
1374: ||', Match_mode = '||X_match_mode
1375: ||', Match Quantity = '||x_match_quantity
1376: ||', Match Amount = '||x_match_amount
1377: ||', Exchange Rate = '||g_exchange_rate

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

1376: ||', Match Amount = '||x_match_amount
1377: ||', Exchange Rate = '||g_exchange_rate
1378: ||', Base Currency = '||g_base_currency_code
1379: ||', Overbill = '||X_overbill_flag);
1380: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1381: END IF;
1382: APP_EXCEPTION.RAISE_EXCEPTION;
1383: END Get_Dist_Proration_Info;
1384:

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

1438:
1439: EXCEPTION
1440: WHEN OTHERS THEN
1441: IF (SQLCODE <> -20001) THEN
1442: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1443: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1444: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1445: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode
1446: ||', Shipment_id = '||TO_CHAR(X_PO_Line_Location_id)

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

1439: EXCEPTION
1440: WHEN OTHERS THEN
1441: IF (SQLCODE <> -20001) THEN
1442: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1443: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1444: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1445: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode
1446: ||', Shipment_id = '||TO_CHAR(X_PO_Line_Location_id)
1447: ||', Overbill = '||X_overbill_flag);

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

1440: WHEN OTHERS THEN
1441: IF (SQLCODE <> -20001) THEN
1442: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1443: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1444: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1445: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode
1446: ||', Shipment_id = '||TO_CHAR(X_PO_Line_Location_id)
1447: ||', Overbill = '||X_overbill_flag);
1448: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 1445: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode

1441: IF (SQLCODE <> -20001) THEN
1442: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1443: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1444: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1445: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode
1446: ||', Shipment_id = '||TO_CHAR(X_PO_Line_Location_id)
1447: ||', Overbill = '||X_overbill_flag);
1448: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1449: END IF;

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

1444: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1445: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode
1446: ||', Shipment_id = '||TO_CHAR(X_PO_Line_Location_id)
1447: ||', Overbill = '||X_overbill_flag);
1448: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1449: END IF;
1450: APP_EXCEPTION.RAISE_EXCEPTION;
1451:
1452: END Get_Total_Proration_Amount;

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

1583:
1584: EXCEPTION
1585: WHEN OTHERS THEN
1586: IF (SQLCODE <> -20001) THEN
1587: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1588: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1589: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1590: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));
1591: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

1584: EXCEPTION
1585: WHEN OTHERS THEN
1586: IF (SQLCODE <> -20001) THEN
1587: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1588: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1589: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1590: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));
1591: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1592: END IF;

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

1585: WHEN OTHERS THEN
1586: IF (SQLCODE <> -20001) THEN
1587: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1588: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1589: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1590: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));
1591: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1592: END IF;
1593:

Line 1590: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));

1586: IF (SQLCODE <> -20001) THEN
1587: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1588: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1589: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1590: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));
1591: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1592: END IF;
1593:
1594: --Clean up the PL/SQL table

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

1587: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1588: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1589: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1590: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));
1591: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1592: END IF;
1593:
1594: --Clean up the PL/SQL table
1595: X_DIST_TAB.DELETE;

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

1622:
1623: EXCEPTION
1624: WHEN OTHERS THEN
1625: IF (SQLCODE <> -20001) THEN
1626: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1627: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1628: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1629: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Line Location Id = '||TO_CHAR(X_Po_line_location_id)
1630: ||', Match amount = '||to_char(x_match_amount));

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

1623: EXCEPTION
1624: WHEN OTHERS THEN
1625: IF (SQLCODE <> -20001) THEN
1626: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1627: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1628: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1629: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Line Location Id = '||TO_CHAR(X_Po_line_location_id)
1630: ||', Match amount = '||to_char(x_match_amount));
1631: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

1624: WHEN OTHERS THEN
1625: IF (SQLCODE <> -20001) THEN
1626: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1627: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1628: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1629: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Line Location Id = '||TO_CHAR(X_Po_line_location_id)
1630: ||', Match amount = '||to_char(x_match_amount));
1631: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1632: END IF;

Line 1629: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Line Location Id = '||TO_CHAR(X_Po_line_location_id)

1625: IF (SQLCODE <> -20001) THEN
1626: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1627: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1628: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1629: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Line Location Id = '||TO_CHAR(X_Po_line_location_id)
1630: ||', Match amount = '||to_char(x_match_amount));
1631: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1632: END IF;
1633: APP_EXCEPTION.RAISE_EXCEPTION;

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

1627: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1628: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1629: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Line Location Id = '||TO_CHAR(X_Po_line_location_id)
1630: ||', Match amount = '||to_char(x_match_amount));
1631: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1632: END IF;
1633: APP_EXCEPTION.RAISE_EXCEPTION;
1634: END Update_PO_Line_Locations;
1635:

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

2386: g_max_invoice_line_number := g_max_invoice_line_number + 1;
2387:
2388: EXCEPTION WHEN OTHERS THEN
2389: IF (SQLCODE <> -20001) THEN
2390: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2391: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2392: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2393: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2394: ||', Invoice Line Number = '||to_char(x_invoice_line_number)

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

2387:
2388: EXCEPTION WHEN OTHERS THEN
2389: IF (SQLCODE <> -20001) THEN
2390: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2391: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2392: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2393: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2394: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
2395: ||', PO Distribution Id = '||to_char(x_po_distribution_id)

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

2388: EXCEPTION WHEN OTHERS THEN
2389: IF (SQLCODE <> -20001) THEN
2390: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2391: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2392: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2393: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2394: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
2395: ||', PO Distribution Id = '||to_char(x_po_distribution_id)
2396: ||', Project Id = '||to_char(g_project_id)

Line 2393: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)

2389: IF (SQLCODE <> -20001) THEN
2390: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2391: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2392: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2393: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2394: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
2395: ||', PO Distribution Id = '||to_char(x_po_distribution_id)
2396: ||', Project Id = '||to_char(g_project_id)
2397: ||', Task_Id ='||to_char(g_task_id)

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

2396: ||', Project Id = '||to_char(g_project_id)
2397: ||', Task_Id ='||to_char(g_task_id)
2398: ||', Expenditure Type ='||g_expenditure_type
2399: ||', Expenditure_Organization_id ='||to_char(g_expenditure_organization_id));
2400: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2401: END IF;
2402: APP_EXCEPTION.RAISE_EXCEPTION;
2403:
2404: END Insert_Invoice_Line;

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

2795: EXCEPTION
2796: WHEN OTHERS THEN
2797:
2798: IF (SQLCODE <> -20001) THEN
2799: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2800: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2801: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2802: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
2803: ||', Invoice_id = '||TO_CHAR(X_invoice_id)

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

2796: WHEN OTHERS THEN
2797:
2798: IF (SQLCODE <> -20001) THEN
2799: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2800: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2801: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2802: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
2803: ||', Invoice_id = '||TO_CHAR(X_invoice_id)
2804: ||', Invoice Line Number = '||X_Invoice_Line_Number

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

2797:
2798: IF (SQLCODE <> -20001) THEN
2799: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2800: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2801: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2802: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
2803: ||', Invoice_id = '||TO_CHAR(X_invoice_id)
2804: ||', Invoice Line Number = '||X_Invoice_Line_Number
2805: ||', Dist_num = '||l_distribution_line_number

Line 2802: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)

2798: IF (SQLCODE <> -20001) THEN
2799: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2800: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2801: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2802: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
2803: ||', Invoice_id = '||TO_CHAR(X_invoice_id)
2804: ||', Invoice Line Number = '||X_Invoice_Line_Number
2805: ||', Dist_num = '||l_distribution_line_number
2806: ||', Allow_PA_Override = '||g_allow_pa_override

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

2804: ||', Invoice Line Number = '||X_Invoice_Line_Number
2805: ||', Dist_num = '||l_distribution_line_number
2806: ||', Allow_PA_Override = '||g_allow_pa_override
2807: ||', Transfer_Desc_Flag = '||g_Transfer_Flag);
2808: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2809: END IF;
2810: --Clean up the PL/SQL table
2811: X_DIST_TAB.DELETE;
2812:

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

2888:
2889: EXCEPTION
2890: WHEN OTHERS THEN
2891: IF (SQLCODE <> -20001) THEN
2892: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2893: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2894: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2895: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
2896: ||', Freight Amount = '||to_char(x_freight_amount)

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

2889: EXCEPTION
2890: WHEN OTHERS THEN
2891: IF (SQLCODE <> -20001) THEN
2892: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2893: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2894: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2895: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
2896: ||', Freight Amount = '||to_char(x_freight_amount)
2897: ||', Freight Description = '||x_freight_description

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

2890: WHEN OTHERS THEN
2891: IF (SQLCODE <> -20001) THEN
2892: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2893: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2894: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2895: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
2896: ||', Freight Amount = '||to_char(x_freight_amount)
2897: ||', Freight Description = '||x_freight_description
2898: ||', Misc Amount = '||to_char(x_misc_amount)

Line 2895: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)

2891: IF (SQLCODE <> -20001) THEN
2892: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2893: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2894: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2895: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
2896: ||', Freight Amount = '||to_char(x_freight_amount)
2897: ||', Freight Description = '||x_freight_description
2898: ||', Misc Amount = '||to_char(x_misc_amount)
2899: ||', Misc Description = '||x_misc_description

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

2897: ||', Freight Description = '||x_freight_description
2898: ||', Misc Amount = '||to_char(x_misc_amount)
2899: ||', Misc Description = '||x_misc_description
2900: ||', Item Line Number = '||TO_CHAR(X_Item_Line_Number));
2901: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2902: END IF;
2903: APP_EXCEPTION.RAISE_EXCEPTION;
2904:
2905: END Create_Charge_Lines;

Line 3112: fnd_message.set_name('SQLAP','AP_DEBUG');

3108:
3109: EXCEPTION
3110: WHEN others then
3111: If (SQLCODE <> -20001) Then
3112: fnd_message.set_name('SQLAP','AP_DEBUG');
3113: fnd_message.set_token('ERROR',SQLERRM);
3114: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3115: fnd_message.set_token('PARAMETERS',
3116: ' invoice_id = '||to_char(x_invoice_id)

Line 3113: fnd_message.set_token('ERROR',SQLERRM);

3109: EXCEPTION
3110: WHEN others then
3111: If (SQLCODE <> -20001) Then
3112: fnd_message.set_name('SQLAP','AP_DEBUG');
3113: fnd_message.set_token('ERROR',SQLERRM);
3114: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3115: fnd_message.set_token('PARAMETERS',
3116: ' invoice_id = '||to_char(x_invoice_id)
3117: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)

Line 3114: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);

3110: WHEN others then
3111: If (SQLCODE <> -20001) Then
3112: fnd_message.set_name('SQLAP','AP_DEBUG');
3113: fnd_message.set_token('ERROR',SQLERRM);
3114: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3115: fnd_message.set_token('PARAMETERS',
3116: ' invoice_id = '||to_char(x_invoice_id)
3117: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3118: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)

Line 3115: fnd_message.set_token('PARAMETERS',

3111: If (SQLCODE <> -20001) Then
3112: fnd_message.set_name('SQLAP','AP_DEBUG');
3113: fnd_message.set_token('ERROR',SQLERRM);
3114: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3115: fnd_message.set_token('PARAMETERS',
3116: ' invoice_id = '||to_char(x_invoice_id)
3117: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3118: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3119: ||', corrected_line_number = '||to_char(x_corrected_line_number)

Line 3124: fnd_message.set_token('DEBUG_INFO',l_debug_info);

3120: ||', match_mode = '||x_match_mode
3121: ||', correction amount = '||to_char(x_correction_amount)
3122: ||', final_match_flag = '||x_final_match_flag
3123: ||', po_line_location_id = '||to_char(x_po_line_location_id));
3124: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3125: End if;
3126:
3127: --Clean up the PL/SQL tables
3128: x_corr_dist_tab.delete;

Line 3293: fnd_message.set_name('SQLAP','AP_DEBUG');

3289:
3290: EXCEPTION
3291: WHEN others then
3292: If (SQLCODE <> -20001) Then
3293: fnd_message.set_name('SQLAP','AP_DEBUG');
3294: fnd_message.set_token('ERROR',SQLERRM);
3295: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3296: fnd_message.set_token('PARAMETERS',
3297: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)

Line 3294: fnd_message.set_token('ERROR',SQLERRM);

3290: EXCEPTION
3291: WHEN others then
3292: If (SQLCODE <> -20001) Then
3293: fnd_message.set_name('SQLAP','AP_DEBUG');
3294: fnd_message.set_token('ERROR',SQLERRM);
3295: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3296: fnd_message.set_token('PARAMETERS',
3297: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3298: ||', corrected_line_number = '||to_char(x_corrected_line_number)

Line 3295: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);

3291: WHEN others then
3292: If (SQLCODE <> -20001) Then
3293: fnd_message.set_name('SQLAP','AP_DEBUG');
3294: fnd_message.set_token('ERROR',SQLERRM);
3295: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3296: fnd_message.set_token('PARAMETERS',
3297: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3298: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3299: ||', correction amount = '||to_char(x_correction_amount));

Line 3296: fnd_message.set_token('PARAMETERS',

3292: If (SQLCODE <> -20001) Then
3293: fnd_message.set_name('SQLAP','AP_DEBUG');
3294: fnd_message.set_token('ERROR',SQLERRM);
3295: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3296: fnd_message.set_token('PARAMETERS',
3297: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3298: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3299: ||', correction amount = '||to_char(x_correction_amount));
3300: fnd_message.set_token('DEBUG_INFO',l_debug_info);

Line 3300: fnd_message.set_token('DEBUG_INFO',l_debug_info);

3296: fnd_message.set_token('PARAMETERS',
3297: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3298: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3299: ||', correction amount = '||to_char(x_correction_amount));
3300: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3301: End if;
3302: --Clean up the PL/SQL tables on error
3303: x_corr_dist_tab.delete;
3304:

Line 3402: fnd_message.set_name('SQLAP','AP_DEBUG');

3398:
3399: EXCEPTION
3400: WHEN others then
3401: If (SQLCODE <> -20001) Then
3402: fnd_message.set_name('SQLAP','AP_DEBUG');
3403: fnd_message.set_token('ERROR',SQLERRM);
3404: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3405: fnd_message.set_token('PARAMETERS',
3406: ' po_line_location_id = '||to_char(x_po_line_location_id));

Line 3403: fnd_message.set_token('ERROR',SQLERRM);

3399: EXCEPTION
3400: WHEN others then
3401: If (SQLCODE <> -20001) Then
3402: fnd_message.set_name('SQLAP','AP_DEBUG');
3403: fnd_message.set_token('ERROR',SQLERRM);
3404: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3405: fnd_message.set_token('PARAMETERS',
3406: ' po_line_location_id = '||to_char(x_po_line_location_id));
3407: fnd_message.set_token('DEBUG_INFO',l_debug_info);

Line 3404: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);

3400: WHEN others then
3401: If (SQLCODE <> -20001) Then
3402: fnd_message.set_name('SQLAP','AP_DEBUG');
3403: fnd_message.set_token('ERROR',SQLERRM);
3404: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3405: fnd_message.set_token('PARAMETERS',
3406: ' po_line_location_id = '||to_char(x_po_line_location_id));
3407: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3408: End if;

Line 3405: fnd_message.set_token('PARAMETERS',

3401: If (SQLCODE <> -20001) Then
3402: fnd_message.set_name('SQLAP','AP_DEBUG');
3403: fnd_message.set_token('ERROR',SQLERRM);
3404: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3405: fnd_message.set_token('PARAMETERS',
3406: ' po_line_location_id = '||to_char(x_po_line_location_id));
3407: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3408: End if;
3409:

Line 3407: fnd_message.set_token('DEBUG_INFO',l_debug_info);

3403: fnd_message.set_token('ERROR',SQLERRM);
3404: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3405: fnd_message.set_token('PARAMETERS',
3406: ' po_line_location_id = '||to_char(x_po_line_location_id));
3407: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3408: End if;
3409:
3410: app_exception.raise_exception;
3411:

Line 3444: fnd_message.set_name('SQLAP','AP_DEBUG');

3440:
3441: EXCEPTION
3442: WHEN others then
3443: If (SQLCODE <> -20001) Then
3444: fnd_message.set_name('SQLAP','AP_DEBUG');
3445: fnd_message.set_token('ERROR',SQLERRM);
3446: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3447: fnd_message.set_token('PARAMETERS',
3448: ' po_line_location_id = '||to_char(x_po_line_location_id)

Line 3445: fnd_message.set_token('ERROR',SQLERRM);

3441: EXCEPTION
3442: WHEN others then
3443: If (SQLCODE <> -20001) Then
3444: fnd_message.set_name('SQLAP','AP_DEBUG');
3445: fnd_message.set_token('ERROR',SQLERRM);
3446: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3447: fnd_message.set_token('PARAMETERS',
3448: ' po_line_location_id = '||to_char(x_po_line_location_id)
3449: ||', amount = '|| to_char(x_amount));

Line 3446: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);

3442: WHEN others then
3443: If (SQLCODE <> -20001) Then
3444: fnd_message.set_name('SQLAP','AP_DEBUG');
3445: fnd_message.set_token('ERROR',SQLERRM);
3446: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3447: fnd_message.set_token('PARAMETERS',
3448: ' po_line_location_id = '||to_char(x_po_line_location_id)
3449: ||', amount = '|| to_char(x_amount));
3450: fnd_message.set_token('DEBUG_INFO',l_debug_info);

Line 3447: fnd_message.set_token('PARAMETERS',

3443: If (SQLCODE <> -20001) Then
3444: fnd_message.set_name('SQLAP','AP_DEBUG');
3445: fnd_message.set_token('ERROR',SQLERRM);
3446: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3447: fnd_message.set_token('PARAMETERS',
3448: ' po_line_location_id = '||to_char(x_po_line_location_id)
3449: ||', amount = '|| to_char(x_amount));
3450: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3451: End if;

Line 3450: fnd_message.set_token('DEBUG_INFO',l_debug_info);

3446: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3447: fnd_message.set_token('PARAMETERS',
3448: ' po_line_location_id = '||to_char(x_po_line_location_id)
3449: ||', amount = '|| to_char(x_amount));
3450: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3451: End if;
3452: app_exception.raise_exception;
3453:
3454: END Update_Corr_Po_Line_Locations;

Line 3800: fnd_message.set_name('SQLAP','AP_DEBUG');

3796:
3797: EXCEPTION
3798: WHEN others then
3799: If (SQLCODE <> -20001) Then
3800: fnd_message.set_name('SQLAP','AP_DEBUG');
3801: fnd_message.set_token('ERROR',SQLERRM);
3802: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3803: fnd_message.set_token('PARAMETERS',
3804: ' invoice_id = '||to_char(x_invoice_id)

Line 3801: fnd_message.set_token('ERROR',SQLERRM);

3797: EXCEPTION
3798: WHEN others then
3799: If (SQLCODE <> -20001) Then
3800: fnd_message.set_name('SQLAP','AP_DEBUG');
3801: fnd_message.set_token('ERROR',SQLERRM);
3802: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3803: fnd_message.set_token('PARAMETERS',
3804: ' invoice_id = '||to_char(x_invoice_id)
3805: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)

Line 3802: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);

3798: WHEN others then
3799: If (SQLCODE <> -20001) Then
3800: fnd_message.set_name('SQLAP','AP_DEBUG');
3801: fnd_message.set_token('ERROR',SQLERRM);
3802: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3803: fnd_message.set_token('PARAMETERS',
3804: ' invoice_id = '||to_char(x_invoice_id)
3805: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3806: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)

Line 3803: fnd_message.set_token('PARAMETERS',

3799: If (SQLCODE <> -20001) Then
3800: fnd_message.set_name('SQLAP','AP_DEBUG');
3801: fnd_message.set_token('ERROR',SQLERRM);
3802: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3803: fnd_message.set_token('PARAMETERS',
3804: ' invoice_id = '||to_char(x_invoice_id)
3805: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3806: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3807: ||', corrected_line_number = '||to_char(x_corrected_line_number)

Line 3811: fnd_message.set_token('DEBUG_INFO',l_debug_info);

3807: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3808: ||', amount = '||to_char(x_amount)
3809: ||', final_match_flag = '||x_final_match_flag
3810: ||', po_distribution_id = '||to_char(x_po_distribution_id));
3811: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3812: End if;
3813: app_exception.raise_exception;
3814:
3815: END Insert_Corr_Invoice_Line;

Line 4198: fnd_message.set_name('SQLAP','AP_DEBUG');

4194:
4195: EXCEPTION
4196: WHEN others then
4197: If (SQLCODE <> -20001) Then
4198: fnd_message.set_name('SQLAP','AP_DEBUG');
4199: fnd_message.set_token('ERROR',SQLERRM);
4200: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4201: fnd_message.set_token('PARAMETERS',
4202: ' invoice_id = '||to_char(x_invoice_id)

Line 4199: fnd_message.set_token('ERROR',SQLERRM);

4195: EXCEPTION
4196: WHEN others then
4197: If (SQLCODE <> -20001) Then
4198: fnd_message.set_name('SQLAP','AP_DEBUG');
4199: fnd_message.set_token('ERROR',SQLERRM);
4200: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4201: fnd_message.set_token('PARAMETERS',
4202: ' invoice_id = '||to_char(x_invoice_id)
4203: ||', invoice_line_number =' ||to_char(x_invoice_line_number)

Line 4200: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);

4196: WHEN others then
4197: If (SQLCODE <> -20001) Then
4198: fnd_message.set_name('SQLAP','AP_DEBUG');
4199: fnd_message.set_token('ERROR',SQLERRM);
4200: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4201: fnd_message.set_token('PARAMETERS',
4202: ' invoice_id = '||to_char(x_invoice_id)
4203: ||', invoice_line_number =' ||to_char(x_invoice_line_number)
4204: ||', final_match_flag = '||x_final_match_flag

Line 4201: fnd_message.set_token('PARAMETERS',

4197: If (SQLCODE <> -20001) Then
4198: fnd_message.set_name('SQLAP','AP_DEBUG');
4199: fnd_message.set_token('ERROR',SQLERRM);
4200: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4201: fnd_message.set_token('PARAMETERS',
4202: ' invoice_id = '||to_char(x_invoice_id)
4203: ||', invoice_line_number =' ||to_char(x_invoice_line_number)
4204: ||', final_match_flag = '||x_final_match_flag
4205: ||', total_amount = '||to_char(x_total_amount));

Line 4206: fnd_message.set_token('DEBUG_INFO',l_debug_info);

4202: ' invoice_id = '||to_char(x_invoice_id)
4203: ||', invoice_line_number =' ||to_char(x_invoice_line_number)
4204: ||', final_match_flag = '||x_final_match_flag
4205: ||', total_amount = '||to_char(x_total_amount));
4206: fnd_message.set_token('DEBUG_INFO',l_debug_info);
4207: End if;
4208:
4209: --Clean up the PL/SQL tables on error
4210: x_corr_dist_tab.delete;