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_PO_AMT_MATCH_PKG dependencies on FND_MESSAGE

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

926:
927: IF g_recurring_payment_id is null THEN --Bug 7305223
928:
929: IF (g_accounting_date IS NULL) THEN
930: fnd_message.set_name('SQLAP','AP_DISTS_NO_OPEN_FUT_PERIOD');
931: app_exception.raise_exception;
932: ELSE
933: g_line_accounting_date := g_accounting_date;
934: END IF;

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

949:
950: EXCEPTION
951: WHEN OTHERS THEN
952: IF (SQLCODE <> -20001) THEN
953: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
954: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
955: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
956: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));
957: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

950: EXCEPTION
951: WHEN OTHERS THEN
952: IF (SQLCODE <> -20001) THEN
953: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
954: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
955: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
956: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));
957: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
958: END IF;

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

951: WHEN OTHERS THEN
952: IF (SQLCODE <> -20001) THEN
953: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
954: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
955: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
956: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));
957: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
958: END IF;
959: app_exception.raise_exception;

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

952: IF (SQLCODE <> -20001) THEN
953: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
954: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
955: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
956: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));
957: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
958: END IF;
959: app_exception.raise_exception;
960:

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

953: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
954: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
955: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
956: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));
957: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
958: END IF;
959: app_exception.raise_exception;
960:
961: END Get_Info;

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

1467: EXCEPTION
1468:
1469: WHEN OTHERS THEN
1470: IF (SQLCODE <> -20001) THEN
1471: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1472: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1473: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1474: FND_MESSAGE.SET_TOKEN('PARAMETERS','Shipment id '||to_char(x_po_line_location_id)
1475: ||', Match_mode = '||X_match_mode

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

1468:
1469: WHEN OTHERS THEN
1470: IF (SQLCODE <> -20001) THEN
1471: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1472: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1473: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1474: FND_MESSAGE.SET_TOKEN('PARAMETERS','Shipment id '||to_char(x_po_line_location_id)
1475: ||', Match_mode = '||X_match_mode
1476: ||', Match Quantity = '||x_match_quantity

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

1469: WHEN OTHERS THEN
1470: IF (SQLCODE <> -20001) THEN
1471: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1472: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1473: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1474: FND_MESSAGE.SET_TOKEN('PARAMETERS','Shipment id '||to_char(x_po_line_location_id)
1475: ||', Match_mode = '||X_match_mode
1476: ||', Match Quantity = '||x_match_quantity
1477: ||', Match Amount = '||x_match_amount

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

1470: IF (SQLCODE <> -20001) THEN
1471: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1472: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1473: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1474: FND_MESSAGE.SET_TOKEN('PARAMETERS','Shipment id '||to_char(x_po_line_location_id)
1475: ||', Match_mode = '||X_match_mode
1476: ||', Match Quantity = '||x_match_quantity
1477: ||', Match Amount = '||x_match_amount
1478: ||', Exchange Rate = '||g_exchange_rate

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

1477: ||', Match Amount = '||x_match_amount
1478: ||', Exchange Rate = '||g_exchange_rate
1479: ||', Base Currency = '||g_base_currency_code
1480: ||', Overbill = '||X_overbill_flag);
1481: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1482: END IF;
1483: APP_EXCEPTION.RAISE_EXCEPTION;
1484: END Get_Dist_Proration_Info;
1485:

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

1539:
1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: IF (SQLCODE <> -20001) THEN
1543: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1544: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1545: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1546: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode
1547: ||', Shipment_id = '||TO_CHAR(X_PO_Line_Location_id)

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

1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: IF (SQLCODE <> -20001) THEN
1543: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1544: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1545: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1546: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode
1547: ||', Shipment_id = '||TO_CHAR(X_PO_Line_Location_id)
1548: ||', Overbill = '||X_overbill_flag);

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

1541: WHEN OTHERS THEN
1542: IF (SQLCODE <> -20001) THEN
1543: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1544: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1545: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1546: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode
1547: ||', Shipment_id = '||TO_CHAR(X_PO_Line_Location_id)
1548: ||', Overbill = '||X_overbill_flag);
1549: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

1542: IF (SQLCODE <> -20001) THEN
1543: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1544: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1545: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1546: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode
1547: ||', Shipment_id = '||TO_CHAR(X_PO_Line_Location_id)
1548: ||', Overbill = '||X_overbill_flag);
1549: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1550: END IF;

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

1545: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1546: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode
1547: ||', Shipment_id = '||TO_CHAR(X_PO_Line_Location_id)
1548: ||', Overbill = '||X_overbill_flag);
1549: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1550: END IF;
1551: APP_EXCEPTION.RAISE_EXCEPTION;
1552:
1553: END Get_Total_Proration_Amount;

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

1684:
1685: EXCEPTION
1686: WHEN OTHERS THEN
1687: IF (SQLCODE <> -20001) THEN
1688: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1689: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1690: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1691: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));
1692: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

1685: EXCEPTION
1686: WHEN OTHERS THEN
1687: IF (SQLCODE <> -20001) THEN
1688: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1689: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1690: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1691: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));
1692: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1693: END IF;

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

1686: WHEN OTHERS THEN
1687: IF (SQLCODE <> -20001) THEN
1688: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1689: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1690: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1691: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));
1692: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1693: END IF;
1694:

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

1687: IF (SQLCODE <> -20001) THEN
1688: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1689: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1690: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1691: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));
1692: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1693: END IF;
1694:
1695: --Clean up the PL/SQL table

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

1688: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1689: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1690: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1691: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));
1692: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1693: END IF;
1694:
1695: --Clean up the PL/SQL table
1696: X_DIST_TAB.DELETE;

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

1723:
1724: EXCEPTION
1725: WHEN OTHERS THEN
1726: IF (SQLCODE <> -20001) THEN
1727: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1728: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1729: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1730: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Line Location Id = '||TO_CHAR(X_Po_line_location_id)
1731: ||', Match amount = '||to_char(x_match_amount));

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

1724: EXCEPTION
1725: WHEN OTHERS THEN
1726: IF (SQLCODE <> -20001) THEN
1727: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1728: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1729: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1730: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Line Location Id = '||TO_CHAR(X_Po_line_location_id)
1731: ||', Match amount = '||to_char(x_match_amount));
1732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

1725: WHEN OTHERS THEN
1726: IF (SQLCODE <> -20001) THEN
1727: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1728: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1729: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1730: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Line Location Id = '||TO_CHAR(X_Po_line_location_id)
1731: ||', Match amount = '||to_char(x_match_amount));
1732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1733: END IF;

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

1726: IF (SQLCODE <> -20001) THEN
1727: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1728: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1729: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1730: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Line Location Id = '||TO_CHAR(X_Po_line_location_id)
1731: ||', Match amount = '||to_char(x_match_amount));
1732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1733: END IF;
1734: APP_EXCEPTION.RAISE_EXCEPTION;

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

1728: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1729: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1730: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Line Location Id = '||TO_CHAR(X_Po_line_location_id)
1731: ||', Match amount = '||to_char(x_match_amount));
1732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1733: END IF;
1734: APP_EXCEPTION.RAISE_EXCEPTION;
1735: END Update_PO_Line_Locations;
1736:

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

2509: g_max_invoice_line_number := g_max_invoice_line_number + 1;
2510:
2511: EXCEPTION WHEN OTHERS THEN
2512: IF (SQLCODE <> -20001) THEN
2513: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2515: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2516: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2517: ||', Invoice Line Number = '||to_char(x_invoice_line_number)

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

2510:
2511: EXCEPTION WHEN OTHERS THEN
2512: IF (SQLCODE <> -20001) THEN
2513: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2515: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2516: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2517: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
2518: ||', PO Distribution Id = '||to_char(x_po_distribution_id)

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

2511: EXCEPTION WHEN OTHERS THEN
2512: IF (SQLCODE <> -20001) THEN
2513: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2515: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2516: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2517: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
2518: ||', PO Distribution Id = '||to_char(x_po_distribution_id)
2519: ||', Project Id = '||to_char(g_project_id)

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

2512: IF (SQLCODE <> -20001) THEN
2513: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2514: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2515: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2516: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2517: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
2518: ||', PO Distribution Id = '||to_char(x_po_distribution_id)
2519: ||', Project Id = '||to_char(g_project_id)
2520: ||', Task_Id ='||to_char(g_task_id)

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

2519: ||', Project Id = '||to_char(g_project_id)
2520: ||', Task_Id ='||to_char(g_task_id)
2521: ||', Expenditure Type ='||g_expenditure_type
2522: ||', Expenditure_Organization_id ='||to_char(g_expenditure_organization_id));
2523: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2524: END IF;
2525: APP_EXCEPTION.RAISE_EXCEPTION;
2526:
2527: END Insert_Invoice_Line;

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

2948: EXCEPTION
2949: WHEN OTHERS THEN
2950:
2951: IF (SQLCODE <> -20001) THEN
2952: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2953: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2954: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2955: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
2956: ||', Invoice_id = '||TO_CHAR(X_invoice_id)

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

2949: WHEN OTHERS THEN
2950:
2951: IF (SQLCODE <> -20001) THEN
2952: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2953: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2954: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2955: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
2956: ||', Invoice_id = '||TO_CHAR(X_invoice_id)
2957: ||', Invoice Line Number = '||X_Invoice_Line_Number

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

2950:
2951: IF (SQLCODE <> -20001) THEN
2952: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2953: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2954: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2955: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
2956: ||', Invoice_id = '||TO_CHAR(X_invoice_id)
2957: ||', Invoice Line Number = '||X_Invoice_Line_Number
2958: ||', Dist_num = '||l_distribution_line_number

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

2951: IF (SQLCODE <> -20001) THEN
2952: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2953: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2954: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2955: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
2956: ||', Invoice_id = '||TO_CHAR(X_invoice_id)
2957: ||', Invoice Line Number = '||X_Invoice_Line_Number
2958: ||', Dist_num = '||l_distribution_line_number
2959: ||', Allow_PA_Override = '||g_allow_pa_override

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

2957: ||', Invoice Line Number = '||X_Invoice_Line_Number
2958: ||', Dist_num = '||l_distribution_line_number
2959: ||', Allow_PA_Override = '||g_allow_pa_override
2960: ||', Transfer_Desc_Flag = '||g_Transfer_Flag);
2961: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2962: END IF;
2963: --Clean up the PL/SQL table
2964: X_DIST_TAB.DELETE;
2965:

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

3041:
3042: EXCEPTION
3043: WHEN OTHERS THEN
3044: IF (SQLCODE <> -20001) THEN
3045: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3046: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3047: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3048: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3049: ||', Freight Amount = '||to_char(x_freight_amount)

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

3042: EXCEPTION
3043: WHEN OTHERS THEN
3044: IF (SQLCODE <> -20001) THEN
3045: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3046: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3047: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3048: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3049: ||', Freight Amount = '||to_char(x_freight_amount)
3050: ||', Freight Description = '||x_freight_description

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

3043: WHEN OTHERS THEN
3044: IF (SQLCODE <> -20001) THEN
3045: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3046: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3047: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3048: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3049: ||', Freight Amount = '||to_char(x_freight_amount)
3050: ||', Freight Description = '||x_freight_description
3051: ||', Misc Amount = '||to_char(x_misc_amount)

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

3044: IF (SQLCODE <> -20001) THEN
3045: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3046: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3047: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3048: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3049: ||', Freight Amount = '||to_char(x_freight_amount)
3050: ||', Freight Description = '||x_freight_description
3051: ||', Misc Amount = '||to_char(x_misc_amount)
3052: ||', Misc Description = '||x_misc_description

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

3050: ||', Freight Description = '||x_freight_description
3051: ||', Misc Amount = '||to_char(x_misc_amount)
3052: ||', Misc Description = '||x_misc_description
3053: ||', Item Line Number = '||TO_CHAR(X_Item_Line_Number));
3054: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3055: END IF;
3056: APP_EXCEPTION.RAISE_EXCEPTION;
3057:
3058: END Create_Charge_Lines;

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

3261:
3262: EXCEPTION
3263: WHEN others then
3264: If (SQLCODE <> -20001) Then
3265: fnd_message.set_name('SQLAP','AP_DEBUG');
3266: fnd_message.set_token('ERROR',SQLERRM);
3267: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3268: fnd_message.set_token('PARAMETERS',
3269: ' invoice_id = '||to_char(x_invoice_id)

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

3262: EXCEPTION
3263: WHEN others then
3264: If (SQLCODE <> -20001) Then
3265: fnd_message.set_name('SQLAP','AP_DEBUG');
3266: fnd_message.set_token('ERROR',SQLERRM);
3267: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3268: fnd_message.set_token('PARAMETERS',
3269: ' invoice_id = '||to_char(x_invoice_id)
3270: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)

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

3263: WHEN others then
3264: If (SQLCODE <> -20001) Then
3265: fnd_message.set_name('SQLAP','AP_DEBUG');
3266: fnd_message.set_token('ERROR',SQLERRM);
3267: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3268: fnd_message.set_token('PARAMETERS',
3269: ' invoice_id = '||to_char(x_invoice_id)
3270: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3271: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)

Line 3268: fnd_message.set_token('PARAMETERS',

3264: If (SQLCODE <> -20001) Then
3265: fnd_message.set_name('SQLAP','AP_DEBUG');
3266: fnd_message.set_token('ERROR',SQLERRM);
3267: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3268: fnd_message.set_token('PARAMETERS',
3269: ' invoice_id = '||to_char(x_invoice_id)
3270: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3271: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3272: ||', corrected_line_number = '||to_char(x_corrected_line_number)

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

3273: ||', match_mode = '||x_match_mode
3274: ||', correction amount = '||to_char(x_correction_amount)
3275: ||', final_match_flag = '||x_final_match_flag
3276: ||', po_line_location_id = '||to_char(x_po_line_location_id));
3277: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3278: End if;
3279:
3280: --Clean up the PL/SQL tables
3281: x_corr_dist_tab.delete;

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

3444:
3445: EXCEPTION
3446: WHEN others then
3447: If (SQLCODE <> -20001) Then
3448: fnd_message.set_name('SQLAP','AP_DEBUG');
3449: fnd_message.set_token('ERROR',SQLERRM);
3450: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3451: fnd_message.set_token('PARAMETERS',
3452: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)

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

3445: EXCEPTION
3446: WHEN others then
3447: If (SQLCODE <> -20001) Then
3448: fnd_message.set_name('SQLAP','AP_DEBUG');
3449: fnd_message.set_token('ERROR',SQLERRM);
3450: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3451: fnd_message.set_token('PARAMETERS',
3452: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3453: ||', corrected_line_number = '||to_char(x_corrected_line_number)

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

3446: WHEN others then
3447: If (SQLCODE <> -20001) Then
3448: fnd_message.set_name('SQLAP','AP_DEBUG');
3449: fnd_message.set_token('ERROR',SQLERRM);
3450: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3451: fnd_message.set_token('PARAMETERS',
3452: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3453: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3454: ||', correction amount = '||to_char(x_correction_amount));

Line 3451: fnd_message.set_token('PARAMETERS',

3447: If (SQLCODE <> -20001) Then
3448: fnd_message.set_name('SQLAP','AP_DEBUG');
3449: fnd_message.set_token('ERROR',SQLERRM);
3450: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3451: fnd_message.set_token('PARAMETERS',
3452: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3453: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3454: ||', correction amount = '||to_char(x_correction_amount));
3455: fnd_message.set_token('DEBUG_INFO',l_debug_info);

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

3451: fnd_message.set_token('PARAMETERS',
3452: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3453: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3454: ||', correction amount = '||to_char(x_correction_amount));
3455: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3456: End if;
3457: --Clean up the PL/SQL tables on error
3458: x_corr_dist_tab.delete;
3459:

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

3553:
3554: EXCEPTION
3555: WHEN others then
3556: If (SQLCODE <> -20001) Then
3557: fnd_message.set_name('SQLAP','AP_DEBUG');
3558: fnd_message.set_token('ERROR',SQLERRM);
3559: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3560: fnd_message.set_token('PARAMETERS',
3561: ' po_line_location_id = '||to_char(x_po_line_location_id));

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

3554: EXCEPTION
3555: WHEN others then
3556: If (SQLCODE <> -20001) Then
3557: fnd_message.set_name('SQLAP','AP_DEBUG');
3558: fnd_message.set_token('ERROR',SQLERRM);
3559: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3560: fnd_message.set_token('PARAMETERS',
3561: ' po_line_location_id = '||to_char(x_po_line_location_id));
3562: fnd_message.set_token('DEBUG_INFO',l_debug_info);

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

3555: WHEN others then
3556: If (SQLCODE <> -20001) Then
3557: fnd_message.set_name('SQLAP','AP_DEBUG');
3558: fnd_message.set_token('ERROR',SQLERRM);
3559: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3560: fnd_message.set_token('PARAMETERS',
3561: ' po_line_location_id = '||to_char(x_po_line_location_id));
3562: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3563: End if;

Line 3560: fnd_message.set_token('PARAMETERS',

3556: If (SQLCODE <> -20001) Then
3557: fnd_message.set_name('SQLAP','AP_DEBUG');
3558: fnd_message.set_token('ERROR',SQLERRM);
3559: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3560: fnd_message.set_token('PARAMETERS',
3561: ' po_line_location_id = '||to_char(x_po_line_location_id));
3562: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3563: End if;
3564:

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

3558: fnd_message.set_token('ERROR',SQLERRM);
3559: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3560: fnd_message.set_token('PARAMETERS',
3561: ' po_line_location_id = '||to_char(x_po_line_location_id));
3562: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3563: End if;
3564:
3565: app_exception.raise_exception;
3566:

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

3595:
3596: EXCEPTION
3597: WHEN others then
3598: If (SQLCODE <> -20001) Then
3599: fnd_message.set_name('SQLAP','AP_DEBUG');
3600: fnd_message.set_token('ERROR',SQLERRM);
3601: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3602: fnd_message.set_token('PARAMETERS',
3603: ' po_line_location_id = '||to_char(x_po_line_location_id)

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

3596: EXCEPTION
3597: WHEN others then
3598: If (SQLCODE <> -20001) Then
3599: fnd_message.set_name('SQLAP','AP_DEBUG');
3600: fnd_message.set_token('ERROR',SQLERRM);
3601: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3602: fnd_message.set_token('PARAMETERS',
3603: ' po_line_location_id = '||to_char(x_po_line_location_id)
3604: ||', amount = '|| to_char(x_amount));

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

3597: WHEN others then
3598: If (SQLCODE <> -20001) Then
3599: fnd_message.set_name('SQLAP','AP_DEBUG');
3600: fnd_message.set_token('ERROR',SQLERRM);
3601: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3602: fnd_message.set_token('PARAMETERS',
3603: ' po_line_location_id = '||to_char(x_po_line_location_id)
3604: ||', amount = '|| to_char(x_amount));
3605: fnd_message.set_token('DEBUG_INFO',l_debug_info);

Line 3602: fnd_message.set_token('PARAMETERS',

3598: If (SQLCODE <> -20001) Then
3599: fnd_message.set_name('SQLAP','AP_DEBUG');
3600: fnd_message.set_token('ERROR',SQLERRM);
3601: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3602: fnd_message.set_token('PARAMETERS',
3603: ' po_line_location_id = '||to_char(x_po_line_location_id)
3604: ||', amount = '|| to_char(x_amount));
3605: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3606: End if;

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

3601: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3602: fnd_message.set_token('PARAMETERS',
3603: ' po_line_location_id = '||to_char(x_po_line_location_id)
3604: ||', amount = '|| to_char(x_amount));
3605: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3606: End if;
3607: app_exception.raise_exception;
3608:
3609: END Update_Corr_Po_Line_Locations;

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

3953:
3954: EXCEPTION
3955: WHEN others then
3956: If (SQLCODE <> -20001) Then
3957: fnd_message.set_name('SQLAP','AP_DEBUG');
3958: fnd_message.set_token('ERROR',SQLERRM);
3959: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3960: fnd_message.set_token('PARAMETERS',
3961: ' invoice_id = '||to_char(x_invoice_id)

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

3954: EXCEPTION
3955: WHEN others then
3956: If (SQLCODE <> -20001) Then
3957: fnd_message.set_name('SQLAP','AP_DEBUG');
3958: fnd_message.set_token('ERROR',SQLERRM);
3959: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3960: fnd_message.set_token('PARAMETERS',
3961: ' invoice_id = '||to_char(x_invoice_id)
3962: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)

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

3955: WHEN others then
3956: If (SQLCODE <> -20001) Then
3957: fnd_message.set_name('SQLAP','AP_DEBUG');
3958: fnd_message.set_token('ERROR',SQLERRM);
3959: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3960: fnd_message.set_token('PARAMETERS',
3961: ' invoice_id = '||to_char(x_invoice_id)
3962: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3963: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)

Line 3960: fnd_message.set_token('PARAMETERS',

3956: If (SQLCODE <> -20001) Then
3957: fnd_message.set_name('SQLAP','AP_DEBUG');
3958: fnd_message.set_token('ERROR',SQLERRM);
3959: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3960: fnd_message.set_token('PARAMETERS',
3961: ' invoice_id = '||to_char(x_invoice_id)
3962: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3963: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3964: ||', corrected_line_number = '||to_char(x_corrected_line_number)

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

3964: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3965: ||', amount = '||to_char(x_amount)
3966: ||', final_match_flag = '||x_final_match_flag
3967: ||', po_distribution_id = '||to_char(x_po_distribution_id));
3968: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3969: End if;
3970: app_exception.raise_exception;
3971:
3972: END Insert_Corr_Invoice_Line;

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

4357:
4358: EXCEPTION
4359: WHEN others then
4360: If (SQLCODE <> -20001) Then
4361: fnd_message.set_name('SQLAP','AP_DEBUG');
4362: fnd_message.set_token('ERROR',SQLERRM);
4363: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4364: fnd_message.set_token('PARAMETERS',
4365: ' invoice_id = '||to_char(x_invoice_id)

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

4358: EXCEPTION
4359: WHEN others then
4360: If (SQLCODE <> -20001) Then
4361: fnd_message.set_name('SQLAP','AP_DEBUG');
4362: fnd_message.set_token('ERROR',SQLERRM);
4363: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4364: fnd_message.set_token('PARAMETERS',
4365: ' invoice_id = '||to_char(x_invoice_id)
4366: ||', invoice_line_number =' ||to_char(x_invoice_line_number)

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

4359: WHEN others then
4360: If (SQLCODE <> -20001) Then
4361: fnd_message.set_name('SQLAP','AP_DEBUG');
4362: fnd_message.set_token('ERROR',SQLERRM);
4363: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4364: fnd_message.set_token('PARAMETERS',
4365: ' invoice_id = '||to_char(x_invoice_id)
4366: ||', invoice_line_number =' ||to_char(x_invoice_line_number)
4367: ||', final_match_flag = '||x_final_match_flag

Line 4364: fnd_message.set_token('PARAMETERS',

4360: If (SQLCODE <> -20001) Then
4361: fnd_message.set_name('SQLAP','AP_DEBUG');
4362: fnd_message.set_token('ERROR',SQLERRM);
4363: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4364: fnd_message.set_token('PARAMETERS',
4365: ' invoice_id = '||to_char(x_invoice_id)
4366: ||', invoice_line_number =' ||to_char(x_invoice_line_number)
4367: ||', final_match_flag = '||x_final_match_flag
4368: ||', total_amount = '||to_char(x_total_amount));

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

4365: ' invoice_id = '||to_char(x_invoice_id)
4366: ||', invoice_line_number =' ||to_char(x_invoice_line_number)
4367: ||', final_match_flag = '||x_final_match_flag
4368: ||', total_amount = '||to_char(x_total_amount));
4369: fnd_message.set_token('DEBUG_INFO',l_debug_info);
4370: End if;
4371:
4372: --Clean up the PL/SQL tables on error
4373: x_corr_dist_tab.delete;