DBA Data[Home] [Help]

APPS.AP_RCT_AMT_MATCH_PKG dependencies on FND_MESSAGE

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

730:
731: EXCEPTION
732: WHEN OTHERS THEN
733: IF (SQLCODE <> -20001) THEN
734: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
735: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
736: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
737: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Mode = '||x_match_mode
738: ||', Invoice Id = '||to_char(x_invoice_id)

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

731: EXCEPTION
732: WHEN OTHERS THEN
733: IF (SQLCODE <> -20001) THEN
734: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
735: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
736: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
737: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Mode = '||x_match_mode
738: ||', Invoice Id = '||to_char(x_invoice_id)
739: ||', Invoice Line Number = '||to_char(x_invoice_line_number)

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

732: WHEN OTHERS THEN
733: IF (SQLCODE <> -20001) THEN
734: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
735: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
736: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
737: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Mode = '||x_match_mode
738: ||', Invoice Id = '||to_char(x_invoice_id)
739: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
740: ||', Shipment ID = '||to_char(x_po_line_location_id)

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

733: IF (SQLCODE <> -20001) THEN
734: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
735: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
736: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
737: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Mode = '||x_match_mode
738: ||', Invoice Id = '||to_char(x_invoice_id)
739: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
740: ||', Shipment ID = '||to_char(x_po_line_location_id)
741: ||', Rcv Transaction ID = '||TO_CHAR(X_Rcv_Transaction_id)

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

745: ||', Freight Amount = '||to_char(x_freight_amount)
746: ||', Freight Description = '||x_freight_description
747: ||', Misc Amount = '||to_char(x_misc_amount)
748: ||', Misc Description = '||x_misc_description);
749: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
750: END IF;
751:
752: --Clean up the PL/SQL table
753: x_dist_tab.delete;

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

956:
957: g_accounting_date := l_accounting_date; --Bug16216470
958:
959: IF (g_accounting_date IS NULL) THEN
960: fnd_message.set_name('SQLAP','AP_DISTS_NO_OPEN_FUT_PERIOD');
961: app_exception.raise_exception;
962: ELSE
963: g_line_accounting_date := g_accounting_date;
964: END IF;

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

976:
977: EXCEPTION
978: WHEN OTHERS THEN
979: IF (SQLCODE <> -20001) THEN
980: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
981: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
982: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
983: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));
984: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

977: EXCEPTION
978: WHEN OTHERS THEN
979: IF (SQLCODE <> -20001) THEN
980: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
981: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
982: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
983: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));
984: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
985: END IF;

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

978: WHEN OTHERS THEN
979: IF (SQLCODE <> -20001) THEN
980: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
981: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
982: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
983: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));
984: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
985: END IF;
986: app_exception.raise_exception;

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

979: IF (SQLCODE <> -20001) THEN
980: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
981: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
982: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
983: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));
984: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
985: END IF;
986: app_exception.raise_exception;
987:

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

980: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
981: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
982: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
983: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_Invoice_Id));
984: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
985: END IF;
986: app_exception.raise_exception;
987:
988: END Get_Info;

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

1567: EXCEPTION
1568:
1569: WHEN OTHERS THEN
1570: IF (SQLCODE <> -20001) THEN
1571: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1572: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1573: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1574: FND_MESSAGE.SET_TOKEN('PARAMETERS','Shipment id '||to_char(x_po_line_location_id)
1575: ||', Match_mode = '||X_match_mode

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

1568:
1569: WHEN OTHERS THEN
1570: IF (SQLCODE <> -20001) THEN
1571: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1572: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1573: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1574: FND_MESSAGE.SET_TOKEN('PARAMETERS','Shipment id '||to_char(x_po_line_location_id)
1575: ||', Match_mode = '||X_match_mode
1576: ||', Match Quantity = '||x_match_quantity

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

1569: WHEN OTHERS THEN
1570: IF (SQLCODE <> -20001) THEN
1571: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1572: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1573: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1574: FND_MESSAGE.SET_TOKEN('PARAMETERS','Shipment id '||to_char(x_po_line_location_id)
1575: ||', Match_mode = '||X_match_mode
1576: ||', Match Quantity = '||x_match_quantity
1577: ||', Match Amount = '||x_match_amount

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

1570: IF (SQLCODE <> -20001) THEN
1571: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1572: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1573: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1574: FND_MESSAGE.SET_TOKEN('PARAMETERS','Shipment id '||to_char(x_po_line_location_id)
1575: ||', Match_mode = '||X_match_mode
1576: ||', Match Quantity = '||x_match_quantity
1577: ||', Match Amount = '||x_match_amount
1578: ||', Exchange Rate = '||g_exchange_rate

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

1576: ||', Match Quantity = '||x_match_quantity
1577: ||', Match Amount = '||x_match_amount
1578: ||', Exchange Rate = '||g_exchange_rate
1579: ||', Base Currency = '||g_base_currency_code);
1580: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1581: END IF;
1582: APP_EXCEPTION.RAISE_EXCEPTION;
1583: END Get_Dist_Proration_Info;
1584:

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

1689:
1690: EXCEPTION
1691: WHEN OTHERS THEN
1692: IF (SQLCODE <> -20001) THEN
1693: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1694: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1695: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1696: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1697: ' X_Rcv_Transaction_Id = '||TO_CHAR(X_Rcv_Transaction_id)

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

1690: EXCEPTION
1691: WHEN OTHERS THEN
1692: IF (SQLCODE <> -20001) THEN
1693: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1694: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1695: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1696: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1697: ' X_Rcv_Transaction_Id = '||TO_CHAR(X_Rcv_Transaction_id)
1698: ||', X_Match_Amount = '||X_Match_amount);

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

1691: WHEN OTHERS THEN
1692: IF (SQLCODE <> -20001) THEN
1693: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1694: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1695: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1696: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1697: ' X_Rcv_Transaction_Id = '||TO_CHAR(X_Rcv_Transaction_id)
1698: ||', X_Match_Amount = '||X_Match_amount);
1699: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 1696: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1692: IF (SQLCODE <> -20001) THEN
1693: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1694: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1695: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1696: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1697: ' X_Rcv_Transaction_Id = '||TO_CHAR(X_Rcv_Transaction_id)
1698: ||', X_Match_Amount = '||X_Match_amount);
1699: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1700: END IF;

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

1695: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1696: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1697: ' X_Rcv_Transaction_Id = '||TO_CHAR(X_Rcv_Transaction_id)
1698: ||', X_Match_Amount = '||X_Match_amount);
1699: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1700: END IF;
1701: APP_EXCEPTION.RAISE_EXCEPTION;
1702:
1703: END Get_Total_Proration_Amount;

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

1835:
1836: EXCEPTION
1837: WHEN OTHERS THEN
1838: IF (SQLCODE <> -20001) THEN
1839: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1840: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1841: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1842: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));
1843: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

1836: EXCEPTION
1837: WHEN OTHERS THEN
1838: IF (SQLCODE <> -20001) THEN
1839: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1840: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1841: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1842: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));
1843: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1844: END IF;

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

1837: WHEN OTHERS THEN
1838: IF (SQLCODE <> -20001) THEN
1839: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1840: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1841: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1842: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));
1843: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1844: END IF;
1845:

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

1838: IF (SQLCODE <> -20001) THEN
1839: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1840: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1841: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1842: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));
1843: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1844: END IF;
1845:
1846: --Clean up the PL/SQL table

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

1839: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1840: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1841: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1842: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id));
1843: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1844: END IF;
1845:
1846: --Clean up the PL/SQL table
1847: X_DIST_TAB.DELETE;

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

1879:
1880: EXCEPTION
1881: WHEN OTHERS THEN
1882: IF (SQLCODE <> -20001) THEN
1883: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1884: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1885: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1886: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1887: 'Rcv Transaction ID = '||TO_CHAR(X_Rcv_Transaction_id)

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

1880: EXCEPTION
1881: WHEN OTHERS THEN
1882: IF (SQLCODE <> -20001) THEN
1883: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1884: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1885: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1886: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1887: 'Rcv Transaction ID = '||TO_CHAR(X_Rcv_Transaction_id)
1888: ||', Match amount = '||to_char(x_match_amount)

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

1881: WHEN OTHERS THEN
1882: IF (SQLCODE <> -20001) THEN
1883: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1884: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1885: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1886: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1887: 'Rcv Transaction ID = '||TO_CHAR(X_Rcv_Transaction_id)
1888: ||', Match amount = '||to_char(x_match_amount)
1889: ||', PO Uom = '||x_uom_lookup_code);

Line 1886: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1882: IF (SQLCODE <> -20001) THEN
1883: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1884: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1885: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1886: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1887: 'Rcv Transaction ID = '||TO_CHAR(X_Rcv_Transaction_id)
1888: ||', Match amount = '||to_char(x_match_amount)
1889: ||', PO Uom = '||x_uom_lookup_code);
1890: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

1886: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1887: 'Rcv Transaction ID = '||TO_CHAR(X_Rcv_Transaction_id)
1888: ||', Match amount = '||to_char(x_match_amount)
1889: ||', PO Uom = '||x_uom_lookup_code);
1890: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1891: END IF;
1892: APP_EXCEPTION.RAISE_EXCEPTION;
1893:
1894: END Update_RCV_Transaction;

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

2577: g_max_invoice_line_number := g_max_invoice_line_number + 1;
2578:
2579: EXCEPTION WHEN OTHERS THEN
2580: IF (SQLCODE <> -20001) THEN
2581: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2582: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2583: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2584: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2585: ||', Invoice Line Number = '||to_char(x_invoice_line_number)

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

2578:
2579: EXCEPTION WHEN OTHERS THEN
2580: IF (SQLCODE <> -20001) THEN
2581: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2582: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2583: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2584: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2585: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
2586: ||', PO Distribution Id = '||to_char(x_po_distribution_id)

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

2579: EXCEPTION WHEN OTHERS THEN
2580: IF (SQLCODE <> -20001) THEN
2581: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2582: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2583: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2584: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2585: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
2586: ||', PO Distribution Id = '||to_char(x_po_distribution_id)
2587: ||', Project Id = '||to_char(g_project_id)

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

2580: IF (SQLCODE <> -20001) THEN
2581: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2582: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2583: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2584: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2585: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
2586: ||', PO Distribution Id = '||to_char(x_po_distribution_id)
2587: ||', Project Id = '||to_char(g_project_id)
2588: ||', Task_Id ='||to_char(g_task_id)

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

2587: ||', Project Id = '||to_char(g_project_id)
2588: ||', Task_Id ='||to_char(g_task_id)
2589: ||', Expenditure Type ='||g_expenditure_type
2590: ||', Expenditure_Organization_id ='||to_char(g_expenditure_organization_id));
2591: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2592: END IF;
2593: APP_EXCEPTION.RAISE_EXCEPTION;
2594:
2595: END Insert_Invoice_Line;

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

3018: EXCEPTION
3019: WHEN OTHERS THEN
3020:
3021: IF (SQLCODE <> -20001) THEN
3022: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3023: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3024: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3025: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
3026: ||', Invoice_id = '||TO_CHAR(X_invoice_id)

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

3019: WHEN OTHERS THEN
3020:
3021: IF (SQLCODE <> -20001) THEN
3022: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3023: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3024: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3025: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
3026: ||', Invoice_id = '||TO_CHAR(X_invoice_id)
3027: ||', Invoice Line Number = '||X_Invoice_Line_Number

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

3020:
3021: IF (SQLCODE <> -20001) THEN
3022: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3023: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3024: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3025: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
3026: ||', Invoice_id = '||TO_CHAR(X_invoice_id)
3027: ||', Invoice Line Number = '||X_Invoice_Line_Number
3028: ||', Dist_num = '||l_distribution_line_number

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

3021: IF (SQLCODE <> -20001) THEN
3022: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3023: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3024: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3025: FND_MESSAGE.SET_TOKEN('PARAMETERS','Batch_Id = '||TO_CHAR(g_Batch_Id)
3026: ||', Invoice_id = '||TO_CHAR(X_invoice_id)
3027: ||', Invoice Line Number = '||X_Invoice_Line_Number
3028: ||', Dist_num = '||l_distribution_line_number
3029: ||', Allow_PA_Override = '||g_allow_pa_override

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

3027: ||', Invoice Line Number = '||X_Invoice_Line_Number
3028: ||', Dist_num = '||l_distribution_line_number
3029: ||', Allow_PA_Override = '||g_allow_pa_override
3030: ||', Transfer_Desc_Flag = '||g_Transfer_Flag);
3031: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3032: END IF;
3033: --Clean up the PL/SQL table
3034: X_DIST_TAB.DELETE;
3035:

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

3114:
3115: EXCEPTION
3116: WHEN OTHERS THEN
3117: IF (SQLCODE <> -20001) THEN
3118: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3119: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3120: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3121: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3122: ||', Freight Amount = '||to_char(x_freight_amount)

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

3115: EXCEPTION
3116: WHEN OTHERS THEN
3117: IF (SQLCODE <> -20001) THEN
3118: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3119: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3120: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3121: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3122: ||', Freight Amount = '||to_char(x_freight_amount)
3123: ||', Freight Description = '||x_freight_description

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

3116: WHEN OTHERS THEN
3117: IF (SQLCODE <> -20001) THEN
3118: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3119: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3120: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3121: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3122: ||', Freight Amount = '||to_char(x_freight_amount)
3123: ||', Freight Description = '||x_freight_description
3124: ||', Misc Amount = '||to_char(x_misc_amount)

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

3117: IF (SQLCODE <> -20001) THEN
3118: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3119: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3120: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3121: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3122: ||', Freight Amount = '||to_char(x_freight_amount)
3123: ||', Freight Description = '||x_freight_description
3124: ||', Misc Amount = '||to_char(x_misc_amount)
3125: ||', Misc Description = '||x_misc_description

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

3123: ||', Freight Description = '||x_freight_description
3124: ||', Misc Amount = '||to_char(x_misc_amount)
3125: ||', Misc Description = '||x_misc_description
3126: ||', Item Line Number = '||TO_CHAR(X_Item_Line_Number));
3127: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3128: END IF;
3129: APP_EXCEPTION.RAISE_EXCEPTION;
3130:
3131: END Create_Charge_Lines;

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

3337:
3338: EXCEPTION
3339: WHEN others then
3340: If (SQLCODE <> -20001) Then
3341: fnd_message.set_name('SQLAP','AP_DEBUG');
3342: fnd_message.set_token('ERROR',SQLERRM);
3343: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3344: fnd_message.set_token('PARAMETERS',
3345: ' invoice_id = '||to_char(x_invoice_id)

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

3338: EXCEPTION
3339: WHEN others then
3340: If (SQLCODE <> -20001) Then
3341: fnd_message.set_name('SQLAP','AP_DEBUG');
3342: fnd_message.set_token('ERROR',SQLERRM);
3343: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3344: fnd_message.set_token('PARAMETERS',
3345: ' invoice_id = '||to_char(x_invoice_id)
3346: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)

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

3339: WHEN others then
3340: If (SQLCODE <> -20001) Then
3341: fnd_message.set_name('SQLAP','AP_DEBUG');
3342: fnd_message.set_token('ERROR',SQLERRM);
3343: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3344: fnd_message.set_token('PARAMETERS',
3345: ' invoice_id = '||to_char(x_invoice_id)
3346: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3347: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)

Line 3344: fnd_message.set_token('PARAMETERS',

3340: If (SQLCODE <> -20001) Then
3341: fnd_message.set_name('SQLAP','AP_DEBUG');
3342: fnd_message.set_token('ERROR',SQLERRM);
3343: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3344: fnd_message.set_token('PARAMETERS',
3345: ' invoice_id = '||to_char(x_invoice_id)
3346: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3347: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3348: ||', corrected_line_number = '||to_char(x_corrected_line_number)

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

3349: ||', match_mode = '||x_match_mode
3350: ||', correction amount = '||to_char(x_correction_amount)
3351: ||', po_line_location_id = '||to_char(x_po_line_location_id)
3352: ||', rcv_transaction_id = '||to_char(x_rcv_transaction_id));
3353: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3354: End if;
3355:
3356: --Clean up the PL/SQL table
3357: x_corr_dist_tab.delete;

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

3520:
3521: EXCEPTION
3522: WHEN others then
3523: If (SQLCODE <> -20001) Then
3524: fnd_message.set_name('SQLAP','AP_DEBUG');
3525: fnd_message.set_token('ERROR',SQLERRM);
3526: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3527: fnd_message.set_token('PARAMETERS',
3528: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)

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

3521: EXCEPTION
3522: WHEN others then
3523: If (SQLCODE <> -20001) Then
3524: fnd_message.set_name('SQLAP','AP_DEBUG');
3525: fnd_message.set_token('ERROR',SQLERRM);
3526: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3527: fnd_message.set_token('PARAMETERS',
3528: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3529: ||', corrected_line_number = '||to_char(x_corrected_line_number)

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

3522: WHEN others then
3523: If (SQLCODE <> -20001) Then
3524: fnd_message.set_name('SQLAP','AP_DEBUG');
3525: fnd_message.set_token('ERROR',SQLERRM);
3526: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3527: fnd_message.set_token('PARAMETERS',
3528: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3529: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3530: ||', correction amount = '||to_char(x_correction_amount));

Line 3527: fnd_message.set_token('PARAMETERS',

3523: If (SQLCODE <> -20001) Then
3524: fnd_message.set_name('SQLAP','AP_DEBUG');
3525: fnd_message.set_token('ERROR',SQLERRM);
3526: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3527: fnd_message.set_token('PARAMETERS',
3528: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3529: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3530: ||', correction amount = '||to_char(x_correction_amount));
3531: fnd_message.set_token('DEBUG_INFO',l_debug_info);

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

3527: fnd_message.set_token('PARAMETERS',
3528: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3529: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3530: ||', correction amount = '||to_char(x_correction_amount));
3531: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3532: End if;
3533: --Clean up the PL/SQL tables on error
3534: x_corr_dist_tab.delete;
3535:

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

3628:
3629: EXCEPTION
3630: WHEN others then
3631: If (SQLCODE <> -20001) Then
3632: fnd_message.set_name('SQLAP','AP_DEBUG');
3633: fnd_message.set_token('ERROR',SQLERRM);
3634: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3635: fnd_message.set_token('PARAMETERS',
3636: ' po_line_location_id = '||to_char(x_po_line_location_id));

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

3629: EXCEPTION
3630: WHEN others then
3631: If (SQLCODE <> -20001) Then
3632: fnd_message.set_name('SQLAP','AP_DEBUG');
3633: fnd_message.set_token('ERROR',SQLERRM);
3634: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3635: fnd_message.set_token('PARAMETERS',
3636: ' po_line_location_id = '||to_char(x_po_line_location_id));
3637: fnd_message.set_token('DEBUG_INFO',l_debug_info);

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

3630: WHEN others then
3631: If (SQLCODE <> -20001) Then
3632: fnd_message.set_name('SQLAP','AP_DEBUG');
3633: fnd_message.set_token('ERROR',SQLERRM);
3634: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3635: fnd_message.set_token('PARAMETERS',
3636: ' po_line_location_id = '||to_char(x_po_line_location_id));
3637: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3638: End if;

Line 3635: fnd_message.set_token('PARAMETERS',

3631: If (SQLCODE <> -20001) Then
3632: fnd_message.set_name('SQLAP','AP_DEBUG');
3633: fnd_message.set_token('ERROR',SQLERRM);
3634: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3635: fnd_message.set_token('PARAMETERS',
3636: ' po_line_location_id = '||to_char(x_po_line_location_id));
3637: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3638: End if;
3639:

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

3633: fnd_message.set_token('ERROR',SQLERRM);
3634: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3635: fnd_message.set_token('PARAMETERS',
3636: ' po_line_location_id = '||to_char(x_po_line_location_id));
3637: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3638: End if;
3639:
3640: app_exception.raise_exception;
3641:

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

3987:
3988: EXCEPTION
3989: WHEN others then
3990: If (SQLCODE <> -20001) Then
3991: fnd_message.set_name('SQLAP','AP_DEBUG');
3992: fnd_message.set_token('ERROR',SQLERRM);
3993: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3994: fnd_message.set_token('PARAMETERS',
3995: ' invoice_id = '||to_char(x_invoice_id)

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

3988: EXCEPTION
3989: WHEN others then
3990: If (SQLCODE <> -20001) Then
3991: fnd_message.set_name('SQLAP','AP_DEBUG');
3992: fnd_message.set_token('ERROR',SQLERRM);
3993: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3994: fnd_message.set_token('PARAMETERS',
3995: ' invoice_id = '||to_char(x_invoice_id)
3996: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)

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

3989: WHEN others then
3990: If (SQLCODE <> -20001) Then
3991: fnd_message.set_name('SQLAP','AP_DEBUG');
3992: fnd_message.set_token('ERROR',SQLERRM);
3993: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3994: fnd_message.set_token('PARAMETERS',
3995: ' invoice_id = '||to_char(x_invoice_id)
3996: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3997: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)

Line 3994: fnd_message.set_token('PARAMETERS',

3990: If (SQLCODE <> -20001) Then
3991: fnd_message.set_name('SQLAP','AP_DEBUG');
3992: fnd_message.set_token('ERROR',SQLERRM);
3993: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3994: fnd_message.set_token('PARAMETERS',
3995: ' invoice_id = '||to_char(x_invoice_id)
3996: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3997: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3998: ||', corrected_line_number = '||to_char(x_corrected_line_number)

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

3997: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3998: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3999: ||', amount = '||to_char(x_amount)
4000: ||', po_distribution_id = '||to_char(x_po_distribution_id));
4001: fnd_message.set_token('DEBUG_INFO',l_debug_info);
4002: End if;
4003: app_exception.raise_exception;
4004:
4005: END Insert_Corr_Invoice_Line;

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

4389:
4390: EXCEPTION
4391: WHEN others then
4392: If (SQLCODE <> -20001) Then
4393: fnd_message.set_name('SQLAP','AP_DEBUG');
4394: fnd_message.set_token('ERROR',SQLERRM);
4395: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4396: fnd_message.set_token('PARAMETERS',
4397: ' invoice_id = '||to_char(x_invoice_id)

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

4390: EXCEPTION
4391: WHEN others then
4392: If (SQLCODE <> -20001) Then
4393: fnd_message.set_name('SQLAP','AP_DEBUG');
4394: fnd_message.set_token('ERROR',SQLERRM);
4395: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4396: fnd_message.set_token('PARAMETERS',
4397: ' invoice_id = '||to_char(x_invoice_id)
4398: ||', invoice_line_number =' ||to_char(x_invoice_line_number)

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

4391: WHEN others then
4392: If (SQLCODE <> -20001) Then
4393: fnd_message.set_name('SQLAP','AP_DEBUG');
4394: fnd_message.set_token('ERROR',SQLERRM);
4395: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4396: fnd_message.set_token('PARAMETERS',
4397: ' invoice_id = '||to_char(x_invoice_id)
4398: ||', invoice_line_number =' ||to_char(x_invoice_line_number)
4399: ||', total_amount = '||to_char(x_total_amount));

Line 4396: fnd_message.set_token('PARAMETERS',

4392: If (SQLCODE <> -20001) Then
4393: fnd_message.set_name('SQLAP','AP_DEBUG');
4394: fnd_message.set_token('ERROR',SQLERRM);
4395: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4396: fnd_message.set_token('PARAMETERS',
4397: ' invoice_id = '||to_char(x_invoice_id)
4398: ||', invoice_line_number =' ||to_char(x_invoice_line_number)
4399: ||', total_amount = '||to_char(x_total_amount));
4400: fnd_message.set_token('DEBUG_INFO',l_debug_info);

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

4396: fnd_message.set_token('PARAMETERS',
4397: ' invoice_id = '||to_char(x_invoice_id)
4398: ||', invoice_line_number =' ||to_char(x_invoice_line_number)
4399: ||', total_amount = '||to_char(x_total_amount));
4400: fnd_message.set_token('DEBUG_INFO',l_debug_info);
4401: End if;
4402:
4403: END Insert_Corr_Invoice_Dists;
4404: