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.

[Home] [Help]

APPS.AP_RECT_MATCH_PKG dependencies on FND_MESSAGE

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

701:
702: EXCEPTION
703: WHEN OTHERS THEN
704: IF (SQLCODE <> -20001) THEN
705: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
706: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
707: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
708: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Mode = '||x_match_mode
709: ||', Invoice Id = '||to_char(x_invoice_id)

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

702: EXCEPTION
703: WHEN OTHERS THEN
704: IF (SQLCODE <> -20001) THEN
705: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
706: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
707: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
708: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Mode = '||x_match_mode
709: ||', Invoice Id = '||to_char(x_invoice_id)
710: ||', Invoice Line Number = '||to_char(x_invoice_line_number)

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

703: WHEN OTHERS THEN
704: IF (SQLCODE <> -20001) THEN
705: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
706: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
707: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
708: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Mode = '||x_match_mode
709: ||', Invoice Id = '||to_char(x_invoice_id)
710: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
711: ||', Shipment ID = '||to_char(x_po_line_location_id)

Line 708: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Mode = '||x_match_mode

704: IF (SQLCODE <> -20001) THEN
705: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
706: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
707: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
708: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Mode = '||x_match_mode
709: ||', Invoice Id = '||to_char(x_invoice_id)
710: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
711: ||', Shipment ID = '||to_char(x_po_line_location_id)
712: ||', Rcv Transaction ID = '||TO_CHAR(X_Rcv_Transaction_id)

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

716: ||', Freight Amount = '||to_char(x_freight_amount)
717: ||', Freight Description = '||x_freight_description
718: ||', Misc Amount = '||to_char(x_misc_amount)
719: ||', Misc Description = '||x_misc_description);
720: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
721: END IF;
722:
723: --Clean up the PL/SQL table
724: x_dist_tab.delete;

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

929: p_gl_date => g_accounting_date,
930: p_org_id => g_org_id); /*bug 5174518 */
931:
932: IF (g_accounting_date IS NULL) THEN
933: fnd_message.set_name('SQLAP','AP_DISTS_NO_OPEN_FUT_PERIOD');
934: app_exception.raise_exception;
935: ELSE
936: g_line_accounting_date := g_accounting_date;
937: END IF;

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

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

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

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

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

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

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

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

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

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

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','Shipment id '||to_char(x_po_line_location_id)
1591: ||', Match Quantity = '||x_match_quantity

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','Shipment id '||to_char(x_po_line_location_id)
1591: ||', Match Quantity = '||x_match_quantity
1592: ||', Match Amount = '||x_match_amount

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','Shipment id '||to_char(x_po_line_location_id)
1591: ||', Match Quantity = '||x_match_quantity
1592: ||', Match Amount = '||x_match_amount
1593: ||', Exchange Rate = '||g_exchange_rate

Line 1590: FND_MESSAGE.SET_TOKEN('PARAMETERS','Shipment id '||to_char(x_po_line_location_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','Shipment id '||to_char(x_po_line_location_id)
1591: ||', Match Quantity = '||x_match_quantity
1592: ||', Match Amount = '||x_match_amount
1593: ||', Exchange Rate = '||g_exchange_rate
1594: ||', Base Currency = '||g_base_currency_code

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

1592: ||', Match Amount = '||x_match_amount
1593: ||', Exchange Rate = '||g_exchange_rate
1594: ||', Base Currency = '||g_base_currency_code
1595: );
1596: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1597: END IF;
1598:
1599: --Clean up the PL/SQL table
1600: x_dist_tab.delete;

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

1724:
1725: EXCEPTION
1726: WHEN OTHERS THEN
1727: IF (SQLCODE <> -20001) THEN
1728: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1729: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1730: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1731: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Option = '||g_match_option
1732: ||', Shipment_id = '||to_char(X_PO_Line_Location_id)

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

1725: EXCEPTION
1726: WHEN OTHERS THEN
1727: IF (SQLCODE <> -20001) THEN
1728: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1729: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1730: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1731: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Option = '||g_match_option
1732: ||', Shipment_id = '||to_char(X_PO_Line_Location_id)
1733: ||', Rcv Transaction Id = '||to_char(x_rcv_transaction_id)

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

1726: WHEN OTHERS THEN
1727: IF (SQLCODE <> -20001) THEN
1728: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1729: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1730: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1731: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Option = '||g_match_option
1732: ||', Shipment_id = '||to_char(X_PO_Line_Location_id)
1733: ||', Rcv Transaction Id = '||to_char(x_rcv_transaction_id)
1734: ||', Match Quantity = '||to_char(x_match_quantity));

Line 1731: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Option = '||g_match_option

1727: IF (SQLCODE <> -20001) THEN
1728: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1729: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1730: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1731: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Option = '||g_match_option
1732: ||', Shipment_id = '||to_char(X_PO_Line_Location_id)
1733: ||', Rcv Transaction Id = '||to_char(x_rcv_transaction_id)
1734: ||', Match Quantity = '||to_char(x_match_quantity));
1735: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

1731: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Option = '||g_match_option
1732: ||', Shipment_id = '||to_char(X_PO_Line_Location_id)
1733: ||', Rcv Transaction Id = '||to_char(x_rcv_transaction_id)
1734: ||', Match Quantity = '||to_char(x_match_quantity));
1735: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1736: END IF;
1737: APP_EXCEPTION.RAISE_EXCEPTION;
1738:
1739: END Get_Total_Proration_Quantity;

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

2490: g_max_invoice_line_number := g_max_invoice_line_number + 1;
2491:
2492: EXCEPTION WHEN OTHERS THEN
2493: IF (SQLCODE <> -20001) THEN
2494: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2495: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2496: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2497: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2498: ||', Invoice Line Number = '||to_char(x_invoice_line_number)

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

2491:
2492: EXCEPTION WHEN OTHERS THEN
2493: IF (SQLCODE <> -20001) THEN
2494: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2495: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2496: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2497: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2498: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
2499: ||', PO Distribution Id = '||to_char(x_po_distribution_id)

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

2492: EXCEPTION WHEN OTHERS THEN
2493: IF (SQLCODE <> -20001) THEN
2494: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2495: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2496: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2497: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2498: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
2499: ||', PO Distribution Id = '||to_char(x_po_distribution_id)
2500: ||', Project Id = '||to_char(g_project_id)

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

2493: IF (SQLCODE <> -20001) THEN
2494: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2495: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2496: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2497: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2498: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
2499: ||', PO Distribution Id = '||to_char(x_po_distribution_id)
2500: ||', Project Id = '||to_char(g_project_id)
2501: ||', Task_Id ='||to_char(g_task_id)

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

2500: ||', Project Id = '||to_char(g_project_id)
2501: ||', Task_Id ='||to_char(g_task_id)
2502: ||', Expenditure Type ='||g_expenditure_type
2503: ||', Expenditure_Organization_id ='||to_char(g_expenditure_organization_id));
2504: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2505: END IF;
2506: APP_EXCEPTION.RAISE_EXCEPTION;
2507:
2508: END Insert_Invoice_Line;

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

2916: EXCEPTION
2917: WHEN OTHERS THEN
2918:
2919: IF (SQLCODE <> -20001) THEN
2920: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2921: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2922: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2923: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
2924: ||', Invoice_id = '||TO_CHAR(X_invoice_id)

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

2917: WHEN OTHERS THEN
2918:
2919: IF (SQLCODE <> -20001) THEN
2920: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2921: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2922: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2923: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
2924: ||', Invoice_id = '||TO_CHAR(X_invoice_id)
2925: ||', Invoice Line Number = '||X_Invoice_Line_Number

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

2918:
2919: IF (SQLCODE <> -20001) THEN
2920: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2921: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2922: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2923: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
2924: ||', Invoice_id = '||TO_CHAR(X_invoice_id)
2925: ||', Invoice Line Number = '||X_Invoice_Line_Number
2926: ||', Dist_num = '||l_distribution_line_number

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

2919: IF (SQLCODE <> -20001) THEN
2920: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2921: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2922: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2923: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
2924: ||', Invoice_id = '||TO_CHAR(X_invoice_id)
2925: ||', Invoice Line Number = '||X_Invoice_Line_Number
2926: ||', Dist_num = '||l_distribution_line_number
2927: ||', Allow_PA_Override = '||g_allow_pa_override

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

2925: ||', Invoice Line Number = '||X_Invoice_Line_Number
2926: ||', Dist_num = '||l_distribution_line_number
2927: ||', Allow_PA_Override = '||g_allow_pa_override
2928: ||', Transfer_Desc_Flag = '||g_Transfer_Flag);
2929: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2930: END IF;
2931:
2932: --Clean up the PL/SQL table
2933: x_dist_tab.delete;

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

3074:
3075: EXCEPTION
3076: WHEN OTHERS THEN
3077: IF (SQLCODE <> -20001) THEN
3078: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3079: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3081: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3082: 'PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id)

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

3075: EXCEPTION
3076: WHEN OTHERS THEN
3077: IF (SQLCODE <> -20001) THEN
3078: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3079: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3081: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3082: 'PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id)
3083: ||', UOM= '||X_uom_lookup_code);

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

3076: WHEN OTHERS THEN
3077: IF (SQLCODE <> -20001) THEN
3078: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3079: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3081: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3082: 'PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id)
3083: ||', UOM= '||X_uom_lookup_code);
3084: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 3081: FND_MESSAGE.SET_TOKEN('PARAMETERS',

3077: IF (SQLCODE <> -20001) THEN
3078: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3079: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3081: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3082: 'PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id)
3083: ||', UOM= '||X_uom_lookup_code);
3084: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3085: END IF;

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

3080: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3081: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3082: 'PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id)
3083: ||', UOM= '||X_uom_lookup_code);
3084: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3085: END IF;
3086: APP_EXCEPTION.RAISE_EXCEPTION;
3087:
3088: END Update_PO_Shipments_Dists;

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

3127:
3128: EXCEPTION
3129: WHEN OTHERS THEN
3130: IF (SQLCODE <> -20001) THEN
3131: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3132: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3133: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3134: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3135: 'Rcv Transaction ID = '||TO_CHAR(X_Rcv_Transaction_id)

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

3128: EXCEPTION
3129: WHEN OTHERS THEN
3130: IF (SQLCODE <> -20001) THEN
3131: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3132: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3133: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3134: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3135: 'Rcv Transaction ID = '||TO_CHAR(X_Rcv_Transaction_id)
3136: ||', Match amount = '||to_char(x_match_amount)

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

3129: WHEN OTHERS THEN
3130: IF (SQLCODE <> -20001) THEN
3131: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3132: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3133: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3134: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3135: 'Rcv Transaction ID = '||TO_CHAR(X_Rcv_Transaction_id)
3136: ||', Match amount = '||to_char(x_match_amount)
3137: ||', Match quantity = '||to_char(x_match_quantity)

Line 3134: FND_MESSAGE.SET_TOKEN('PARAMETERS',

3130: IF (SQLCODE <> -20001) THEN
3131: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3132: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3133: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3134: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3135: 'Rcv Transaction ID = '||TO_CHAR(X_Rcv_Transaction_id)
3136: ||', Match amount = '||to_char(x_match_amount)
3137: ||', Match quantity = '||to_char(x_match_quantity)
3138: ||', PO Uom = '||x_uom_lookup_code);

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

3135: 'Rcv Transaction ID = '||TO_CHAR(X_Rcv_Transaction_id)
3136: ||', Match amount = '||to_char(x_match_amount)
3137: ||', Match quantity = '||to_char(x_match_quantity)
3138: ||', PO Uom = '||x_uom_lookup_code);
3139: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3140: END IF;
3141: APP_EXCEPTION.RAISE_EXCEPTION;
3142:
3143: END Update_RCV_Transaction;

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

3230:
3231: EXCEPTION
3232: WHEN OTHERS THEN
3233: IF (SQLCODE <> -20001) THEN
3234: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3235: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3236: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3237: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3238: ||', Freight Amount = '||to_char(x_freight_amount)

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

3231: EXCEPTION
3232: WHEN OTHERS THEN
3233: IF (SQLCODE <> -20001) THEN
3234: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3235: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3236: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3237: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3238: ||', Freight Amount = '||to_char(x_freight_amount)
3239: ||', Freight Description = '||x_freight_description

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

3232: WHEN OTHERS THEN
3233: IF (SQLCODE <> -20001) THEN
3234: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3235: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3236: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3237: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3238: ||', Freight Amount = '||to_char(x_freight_amount)
3239: ||', Freight Description = '||x_freight_description
3240: ||', Misc Amount = '||to_char(x_misc_amount)

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

3233: IF (SQLCODE <> -20001) THEN
3234: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3235: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3236: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3237: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3238: ||', Freight Amount = '||to_char(x_freight_amount)
3239: ||', Freight Description = '||x_freight_description
3240: ||', Misc Amount = '||to_char(x_misc_amount)
3241: ||', Misc Description = '||x_misc_description

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

3247: ||', Base Currency Code = '||g_base_currency_code
3248: ||', Income Tax Region = '||g_income_tax_region
3249: ||', Awt Group Id = '||g_awt_group_id
3250: ||', Transfer Flag = '||g_transfer_flag);
3251: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3252: END IF;
3253: APP_EXCEPTION.RAISE_EXCEPTION;
3254:
3255: END Create_Charge_Lines;

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

3500:
3501: EXCEPTION
3502: WHEN others then
3503: If (SQLCODE <> -20001) Then
3504: fnd_message.set_name('SQLAP','AP_DEBUG');
3505: fnd_message.set_token('ERROR',SQLERRM);
3506: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3507: fnd_message.set_token('PARAMETERS',
3508: ' invoice_id = '||to_char(x_invoice_id)

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

3501: EXCEPTION
3502: WHEN others then
3503: If (SQLCODE <> -20001) Then
3504: fnd_message.set_name('SQLAP','AP_DEBUG');
3505: fnd_message.set_token('ERROR',SQLERRM);
3506: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3507: fnd_message.set_token('PARAMETERS',
3508: ' invoice_id = '||to_char(x_invoice_id)
3509: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)

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

3502: WHEN others then
3503: If (SQLCODE <> -20001) Then
3504: fnd_message.set_name('SQLAP','AP_DEBUG');
3505: fnd_message.set_token('ERROR',SQLERRM);
3506: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3507: fnd_message.set_token('PARAMETERS',
3508: ' invoice_id = '||to_char(x_invoice_id)
3509: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3510: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)

Line 3507: fnd_message.set_token('PARAMETERS',

3503: If (SQLCODE <> -20001) Then
3504: fnd_message.set_name('SQLAP','AP_DEBUG');
3505: fnd_message.set_token('ERROR',SQLERRM);
3506: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3507: fnd_message.set_token('PARAMETERS',
3508: ' invoice_id = '||to_char(x_invoice_id)
3509: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3510: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3511: ||', corrected_line_number = '||to_char(x_corrected_line_number)

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

3515: ||', correction amount = '||to_char(x_correction_amount)
3516: ||', correction price = '||to_char(x_correction_price)
3517: ||', po_line_location_id = '||to_char(x_po_line_location_id)
3518: ||', rcv_transaction_id = '||to_char(x_rcv_transaction_id));
3519: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3520: End if;
3521:
3522: --Clean up the PL/SQL table
3523: x_corr_dist_tab.delete;

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

3812:
3813: EXCEPTION
3814: WHEN others then
3815: If (SQLCODE <> -20001) Then
3816: fnd_message.set_name('SQLAP','AP_DEBUG');
3817: fnd_message.set_token('ERROR',SQLERRM);
3818: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3819: fnd_message.set_token('PARAMETERS',
3820: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)

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

3813: EXCEPTION
3814: WHEN others then
3815: If (SQLCODE <> -20001) Then
3816: fnd_message.set_name('SQLAP','AP_DEBUG');
3817: fnd_message.set_token('ERROR',SQLERRM);
3818: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3819: fnd_message.set_token('PARAMETERS',
3820: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3821: ||', corrected_line_number = '||to_char(x_corrected_line_number)

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

3814: WHEN others then
3815: If (SQLCODE <> -20001) Then
3816: fnd_message.set_name('SQLAP','AP_DEBUG');
3817: fnd_message.set_token('ERROR',SQLERRM);
3818: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3819: fnd_message.set_token('PARAMETERS',
3820: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3821: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3822: ||', correction quantity ='||to_char(x_correction_quantity)

Line 3819: fnd_message.set_token('PARAMETERS',

3815: If (SQLCODE <> -20001) Then
3816: fnd_message.set_name('SQLAP','AP_DEBUG');
3817: fnd_message.set_token('ERROR',SQLERRM);
3818: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3819: fnd_message.set_token('PARAMETERS',
3820: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3821: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3822: ||', correction quantity ='||to_char(x_correction_quantity)
3823: ||', correction amount = '||to_char(x_correction_amount)

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

3821: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3822: ||', correction quantity ='||to_char(x_correction_quantity)
3823: ||', correction amount = '||to_char(x_correction_amount)
3824: ||', correction type = '||x_correction_type);
3825: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3826: End if;
3827:
3828: --Clean up the PL/SQL table
3829: x_corr_dist_tab.delete;

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

3970:
3971: EXCEPTION
3972: WHEN others then
3973: If (SQLCODE <> -20001) Then
3974: fnd_message.set_name('SQLAP','AP_DEBUG');
3975: fnd_message.set_token('ERROR',SQLERRM);
3976: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3977: fnd_message.set_token('PARAMETERS',
3978: ' po_distribution_id = '||to_char(x_corr_dist_tab(i).po_distribution_id)

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

3971: EXCEPTION
3972: WHEN others then
3973: If (SQLCODE <> -20001) Then
3974: fnd_message.set_name('SQLAP','AP_DEBUG');
3975: fnd_message.set_token('ERROR',SQLERRM);
3976: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3977: fnd_message.set_token('PARAMETERS',
3978: ' po_distribution_id = '||to_char(x_corr_dist_tab(i).po_distribution_id)
3979: ||', correction_type = '||x_correction_type);

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

3972: WHEN others then
3973: If (SQLCODE <> -20001) Then
3974: fnd_message.set_name('SQLAP','AP_DEBUG');
3975: fnd_message.set_token('ERROR',SQLERRM);
3976: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3977: fnd_message.set_token('PARAMETERS',
3978: ' po_distribution_id = '||to_char(x_corr_dist_tab(i).po_distribution_id)
3979: ||', correction_type = '||x_correction_type);
3980: fnd_message.set_token('DEBUG_INFO',l_debug_info);

Line 3977: fnd_message.set_token('PARAMETERS',

3973: If (SQLCODE <> -20001) Then
3974: fnd_message.set_name('SQLAP','AP_DEBUG');
3975: fnd_message.set_token('ERROR',SQLERRM);
3976: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3977: fnd_message.set_token('PARAMETERS',
3978: ' po_distribution_id = '||to_char(x_corr_dist_tab(i).po_distribution_id)
3979: ||', correction_type = '||x_correction_type);
3980: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3981: End if;

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

3976: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3977: fnd_message.set_token('PARAMETERS',
3978: ' po_distribution_id = '||to_char(x_corr_dist_tab(i).po_distribution_id)
3979: ||', correction_type = '||x_correction_type);
3980: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3981: End if;
3982: app_exception.raise_exception;
3983:
3984: END Update_Corr_Po_Shipments_Dists;

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

4329:
4330: EXCEPTION
4331: WHEN others then
4332: If (SQLCODE <> -20001) Then
4333: fnd_message.set_name('SQLAP','AP_DEBUG');
4334: fnd_message.set_token('ERROR',SQLERRM);
4335: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4336: fnd_message.set_token('PARAMETERS',
4337: ' invoice_id = '||to_char(x_invoice_id)

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

4330: EXCEPTION
4331: WHEN others then
4332: If (SQLCODE <> -20001) Then
4333: fnd_message.set_name('SQLAP','AP_DEBUG');
4334: fnd_message.set_token('ERROR',SQLERRM);
4335: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4336: fnd_message.set_token('PARAMETERS',
4337: ' invoice_id = '||to_char(x_invoice_id)
4338: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)

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

4331: WHEN others then
4332: If (SQLCODE <> -20001) Then
4333: fnd_message.set_name('SQLAP','AP_DEBUG');
4334: fnd_message.set_token('ERROR',SQLERRM);
4335: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4336: fnd_message.set_token('PARAMETERS',
4337: ' invoice_id = '||to_char(x_invoice_id)
4338: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
4339: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)

Line 4336: fnd_message.set_token('PARAMETERS',

4332: If (SQLCODE <> -20001) Then
4333: fnd_message.set_name('SQLAP','AP_DEBUG');
4334: fnd_message.set_token('ERROR',SQLERRM);
4335: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4336: fnd_message.set_token('PARAMETERS',
4337: ' invoice_id = '||to_char(x_invoice_id)
4338: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
4339: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)
4340: ||', corrected_line_number = '||to_char(x_corrected_line_number)

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

4342: ||', amount = '||to_char(x_amount)
4343: ||', unit_price = '||to_char(x_unit_price)
4344: ||', correction_type = '||x_correction_type
4345: ||', po_distribution_id = '||to_char(x_po_distribution_id));
4346: fnd_message.set_token('DEBUG_INFO',l_debug_info);
4347: End if;
4348: app_exception.raise_exception;
4349:
4350: END Insert_Corr_Invoice_Line;

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

4732:
4733: EXCEPTION
4734: WHEN others then
4735: If (SQLCODE <> -20001) Then
4736: fnd_message.set_name('SQLAP','AP_DEBUG');
4737: fnd_message.set_token('ERROR',SQLERRM);
4738: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4739: fnd_message.set_token('PARAMETERS',
4740: ' invoice_id = '||to_char(x_invoice_id)

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

4733: EXCEPTION
4734: WHEN others then
4735: If (SQLCODE <> -20001) Then
4736: fnd_message.set_name('SQLAP','AP_DEBUG');
4737: fnd_message.set_token('ERROR',SQLERRM);
4738: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4739: fnd_message.set_token('PARAMETERS',
4740: ' invoice_id = '||to_char(x_invoice_id)
4741: ||', invoice_line_number =' ||to_char(x_invoice_line_number)

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

4734: WHEN others then
4735: If (SQLCODE <> -20001) Then
4736: fnd_message.set_name('SQLAP','AP_DEBUG');
4737: fnd_message.set_token('ERROR',SQLERRM);
4738: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4739: fnd_message.set_token('PARAMETERS',
4740: ' invoice_id = '||to_char(x_invoice_id)
4741: ||', invoice_line_number =' ||to_char(x_invoice_line_number)
4742: ||', correction_type = '||x_correction_type

Line 4739: fnd_message.set_token('PARAMETERS',

4735: If (SQLCODE <> -20001) Then
4736: fnd_message.set_name('SQLAP','AP_DEBUG');
4737: fnd_message.set_token('ERROR',SQLERRM);
4738: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4739: fnd_message.set_token('PARAMETERS',
4740: ' invoice_id = '||to_char(x_invoice_id)
4741: ||', invoice_line_number =' ||to_char(x_invoice_line_number)
4742: ||', correction_type = '||x_correction_type
4743: ||', total_amount = '||to_char(x_total_amount));

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

4740: ' invoice_id = '||to_char(x_invoice_id)
4741: ||', invoice_line_number =' ||to_char(x_invoice_line_number)
4742: ||', correction_type = '||x_correction_type
4743: ||', total_amount = '||to_char(x_total_amount));
4744: fnd_message.set_token('DEBUG_INFO',l_debug_info);
4745: End if;
4746:
4747: --Clean up the PL/SQL table
4748: x_corr_dist_tab.delete;