DBA Data[Home] [Help]

APPS.AP_MATCHING_PKG dependencies on FND_MESSAGE

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

692:
693: EXCEPTION
694: WHEN OTHERS THEN
695: IF (SQLCODE <> -20001) THEN
696: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
697: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
698: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
699: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Mode = '||x_match_mode
700: ||', Invoice Id = '||to_char(x_invoice_id)

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

693: EXCEPTION
694: WHEN OTHERS THEN
695: IF (SQLCODE <> -20001) THEN
696: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
697: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
698: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
699: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Mode = '||x_match_mode
700: ||', Invoice Id = '||to_char(x_invoice_id)
701: ||', Invoice Line Number = '||to_char(x_invoice_line_number)

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

694: WHEN OTHERS THEN
695: IF (SQLCODE <> -20001) THEN
696: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
697: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
698: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
699: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Mode = '||x_match_mode
700: ||', Invoice Id = '||to_char(x_invoice_id)
701: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
702: ||', Shipment ID = '||to_char(x_po_line_location_id)

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

695: IF (SQLCODE <> -20001) THEN
696: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
697: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
698: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
699: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match Mode = '||x_match_mode
700: ||', Invoice Id = '||to_char(x_invoice_id)
701: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
702: ||', Shipment ID = '||to_char(x_po_line_location_id)
703: ||', Match amount = '||to_char(x_amount)

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

708: ||', Freight Amount = '||to_char(x_freight_amount)
709: ||', Freight Description = '||x_freight_description
710: ||', Misc Amount = '||to_char(x_misc_amount)
711: ||', Misc Description = '||x_misc_description);
712: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
713: END IF;
714:
715: --Clean up the PL/SQL table
716: X_DIST_TAB.DELETE;

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

944: --any period.
945:
946: IF g_recurring_payment_id is null THEN --Bug 7305223
947: IF (g_accounting_date IS NULL) THEN
948: fnd_message.set_name('SQLAP','AP_DISTS_NO_OPEN_FUT_PERIOD');
949: app_exception.raise_exception;
950: ELSE
951: g_line_accounting_date := g_accounting_date;
952: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1580: ||', Match Amount = '||x_match_amount
1581: ||', Exchange Rate = '||g_exchange_rate
1582: ||', Base Currency = '||g_base_currency_code
1583: ||', Overbill = '||X_overbill_flag);
1584: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1585: END IF;
1586: APP_EXCEPTION.RAISE_EXCEPTION;
1587:
1588: END Get_Dist_Proration_Info;

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

1674:
1675: EXCEPTION
1676: WHEN OTHERS THEN
1677: IF (SQLCODE <> -20001) THEN
1678: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1679: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1680: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1681: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode
1682: ||', Shipment_id = '||TO_CHAR(X_PO_Line_Location_id)

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

1675: EXCEPTION
1676: WHEN OTHERS THEN
1677: IF (SQLCODE <> -20001) THEN
1678: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1679: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1680: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1681: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode
1682: ||', Shipment_id = '||TO_CHAR(X_PO_Line_Location_id)
1683: ||', Overbill = '||X_overbill_flag);

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

1676: WHEN OTHERS THEN
1677: IF (SQLCODE <> -20001) THEN
1678: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1679: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1680: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1681: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode
1682: ||', Shipment_id = '||TO_CHAR(X_PO_Line_Location_id)
1683: ||', Overbill = '||X_overbill_flag);
1684: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

1677: IF (SQLCODE <> -20001) THEN
1678: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1679: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1680: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1681: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode
1682: ||', Shipment_id = '||TO_CHAR(X_PO_Line_Location_id)
1683: ||', Overbill = '||X_overbill_flag);
1684: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1685: END IF;

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

1680: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1681: FND_MESSAGE.SET_TOKEN('PARAMETERS','Match_mode = '||X_match_mode
1682: ||', Shipment_id = '||TO_CHAR(X_PO_Line_Location_id)
1683: ||', Overbill = '||X_overbill_flag);
1684: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1685: END IF;
1686: APP_EXCEPTION.RAISE_EXCEPTION;
1687:
1688: END Get_Total_Proration_Quantity;

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

2466:
2467:
2468: EXCEPTION WHEN OTHERS THEN
2469: IF (SQLCODE <> -20001) THEN
2470: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2471: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2472: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2473: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2474: ||', Invoice Line Number = '||to_char(x_invoice_line_number)

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

2467:
2468: EXCEPTION WHEN OTHERS THEN
2469: IF (SQLCODE <> -20001) THEN
2470: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2471: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2472: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2473: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2474: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
2475: ||', PO Distribution Id = '||to_char(x_po_distribution_id)

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

2468: EXCEPTION WHEN OTHERS THEN
2469: IF (SQLCODE <> -20001) THEN
2470: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2471: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2472: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2473: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2474: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
2475: ||', PO Distribution Id = '||to_char(x_po_distribution_id)
2476: ||', Project Id = '||to_char(g_project_id)

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

2469: IF (SQLCODE <> -20001) THEN
2470: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2471: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2472: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2473: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_Id = '||to_char(x_invoice_id)
2474: ||', Invoice Line Number = '||to_char(x_invoice_line_number)
2475: ||', PO Distribution Id = '||to_char(x_po_distribution_id)
2476: ||', Project Id = '||to_char(g_project_id)
2477: ||', Task_Id ='||to_char(g_task_id)

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

2476: ||', Project Id = '||to_char(g_project_id)
2477: ||', Task_Id ='||to_char(g_task_id)
2478: ||', Expenditure Type ='||g_expenditure_type
2479: ||', Expenditure_Organization_id ='||to_char(g_expenditure_organization_id));
2480: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2481: END IF;
2482: APP_EXCEPTION.RAISE_EXCEPTION;
2483:
2484: END Insert_Invoice_Line;

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

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

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

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

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

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

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

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

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

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

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

3067:
3068: EXCEPTION
3069: WHEN OTHERS THEN
3070: IF (SQLCODE <> -20001) THEN
3071: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3072: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3073: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3074: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id)
3075: ||', UOM= '||X_uom_lookup_code);

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

3068: EXCEPTION
3069: WHEN OTHERS THEN
3070: IF (SQLCODE <> -20001) THEN
3071: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3072: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3073: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3074: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id)
3075: ||', UOM= '||X_uom_lookup_code);
3076: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

3069: WHEN OTHERS THEN
3070: IF (SQLCODE <> -20001) THEN
3071: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3072: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3073: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3074: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id)
3075: ||', UOM= '||X_uom_lookup_code);
3076: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3077: END IF;

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

3070: IF (SQLCODE <> -20001) THEN
3071: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3072: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3073: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3074: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id)
3075: ||', UOM= '||X_uom_lookup_code);
3076: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3077: END IF;
3078:

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

3072: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3073: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3074: FND_MESSAGE.SET_TOKEN('PARAMETERS','PO Distribution Id = '||TO_CHAR(X_Dist_tab(i).po_distribution_id)
3075: ||', UOM= '||X_uom_lookup_code);
3076: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3077: END IF;
3078:
3079: --Clean up the PL/SQL table
3080: X_DIST_TAB.DELETE;

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

3178:
3179: EXCEPTION
3180: WHEN OTHERS THEN
3181: IF (SQLCODE <> -20001) THEN
3182: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3183: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3184: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3185: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3186: ||', Freight Amount = '||to_char(x_freight_amount)

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

3179: EXCEPTION
3180: WHEN OTHERS THEN
3181: IF (SQLCODE <> -20001) THEN
3182: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3183: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3184: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3185: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3186: ||', Freight Amount = '||to_char(x_freight_amount)
3187: ||', Freight Description = '||x_freight_description

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

3180: WHEN OTHERS THEN
3181: IF (SQLCODE <> -20001) THEN
3182: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3183: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3184: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3185: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3186: ||', Freight Amount = '||to_char(x_freight_amount)
3187: ||', Freight Description = '||x_freight_description
3188: ||', Misc Amount = '||to_char(x_misc_amount)

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

3181: IF (SQLCODE <> -20001) THEN
3182: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3183: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3184: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
3185: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||to_char(X_Invoice_Id)
3186: ||', Freight Amount = '||to_char(x_freight_amount)
3187: ||', Freight Description = '||x_freight_description
3188: ||', Misc Amount = '||to_char(x_misc_amount)
3189: ||', Misc Description = '||x_misc_description

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

3196: ||', Income Tax Region = '||g_income_tax_region
3197: ||', Awt Group Id = '||g_awt_group_id
3198: ||', Transfer Flag = '||g_transfer_flag
3199: ||', Pay Awt Group Id = '||g_pay_awt_group_id); --bug 8222382
3200: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3201: END IF;
3202: APP_EXCEPTION.RAISE_EXCEPTION;
3203:
3204: END Create_Charge_Lines;

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

3462:
3463: EXCEPTION
3464: WHEN others then
3465: If (SQLCODE <> -20001) Then
3466: fnd_message.set_name('SQLAP','AP_DEBUG');
3467: fnd_message.set_token('ERROR',SQLERRM);
3468: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3469: fnd_message.set_token('PARAMETERS',
3470: ' invoice_id = '||to_char(x_invoice_id)

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

3463: EXCEPTION
3464: WHEN others then
3465: If (SQLCODE <> -20001) Then
3466: fnd_message.set_name('SQLAP','AP_DEBUG');
3467: fnd_message.set_token('ERROR',SQLERRM);
3468: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3469: fnd_message.set_token('PARAMETERS',
3470: ' invoice_id = '||to_char(x_invoice_id)
3471: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)

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

3464: WHEN others then
3465: If (SQLCODE <> -20001) Then
3466: fnd_message.set_name('SQLAP','AP_DEBUG');
3467: fnd_message.set_token('ERROR',SQLERRM);
3468: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3469: fnd_message.set_token('PARAMETERS',
3470: ' invoice_id = '||to_char(x_invoice_id)
3471: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3472: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)

Line 3469: fnd_message.set_token('PARAMETERS',

3465: If (SQLCODE <> -20001) Then
3466: fnd_message.set_name('SQLAP','AP_DEBUG');
3467: fnd_message.set_token('ERROR',SQLERRM);
3468: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3469: fnd_message.set_token('PARAMETERS',
3470: ' invoice_id = '||to_char(x_invoice_id)
3471: ||', invoice_line_number = ' ||to_char(x_invoice_line_number)
3472: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3473: ||', corrected_line_number = '||to_char(x_corrected_line_number)

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

3477: ||', correction amount = '||to_char(x_correction_amount)
3478: ||', correction price = '||to_char(x_correction_price)
3479: ||', final_match_flag = '||x_final_match_flag
3480: ||', po_line_location_id = '||to_char(x_po_line_location_id));
3481: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3482: End if;
3483:
3484: --Clean up the PL/SQL tables
3485: x_corr_dist_tab.delete;

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

3792:
3793: EXCEPTION
3794: WHEN others then
3795: If (SQLCODE <> -20001) Then
3796: fnd_message.set_name('SQLAP','AP_DEBUG');
3797: fnd_message.set_token('ERROR',SQLERRM);
3798: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3799: fnd_message.set_token('PARAMETERS',
3800: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)

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

3793: EXCEPTION
3794: WHEN others then
3795: If (SQLCODE <> -20001) Then
3796: fnd_message.set_name('SQLAP','AP_DEBUG');
3797: fnd_message.set_token('ERROR',SQLERRM);
3798: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3799: fnd_message.set_token('PARAMETERS',
3800: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3801: ||', corrected_line_number = '||to_char(x_corrected_line_number)

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

3794: WHEN others then
3795: If (SQLCODE <> -20001) Then
3796: fnd_message.set_name('SQLAP','AP_DEBUG');
3797: fnd_message.set_token('ERROR',SQLERRM);
3798: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3799: fnd_message.set_token('PARAMETERS',
3800: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3801: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3802: ||', correction quantity ='||to_char(x_correction_quantity)

Line 3799: fnd_message.set_token('PARAMETERS',

3795: If (SQLCODE <> -20001) Then
3796: fnd_message.set_name('SQLAP','AP_DEBUG');
3797: fnd_message.set_token('ERROR',SQLERRM);
3798: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3799: fnd_message.set_token('PARAMETERS',
3800: ' corrected_invoice_id = '||to_char(x_corrected_invoice_id)
3801: ||', corrected_line_number = '||to_char(x_corrected_line_number)
3802: ||', correction quantity ='||to_char(x_correction_quantity)
3803: ||', correction amount = '||to_char(x_correction_amount)

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

3802: ||', correction quantity ='||to_char(x_correction_quantity)
3803: ||', correction amount = '||to_char(x_correction_amount)
3804: ||', correction price = '||to_char(x_correction_price)
3805: ||', correction type = '||x_correction_type);
3806: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3807: End if;
3808: --Clean up the PL/SQL tables on error
3809: x_corr_dist_tab.delete;
3810:

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

3950:
3951: EXCEPTION
3952: WHEN others then
3953: If (SQLCODE <> -20001) Then
3954: fnd_message.set_name('SQLAP','AP_DEBUG');
3955: fnd_message.set_token('ERROR',SQLERRM);
3956: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3957: fnd_message.set_token('PARAMETERS',
3958: ' po_distribution_id = '||to_char(x_corr_dist_tab(i).po_distribution_id)

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

3951: EXCEPTION
3952: WHEN others then
3953: If (SQLCODE <> -20001) Then
3954: fnd_message.set_name('SQLAP','AP_DEBUG');
3955: fnd_message.set_token('ERROR',SQLERRM);
3956: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3957: fnd_message.set_token('PARAMETERS',
3958: ' po_distribution_id = '||to_char(x_corr_dist_tab(i).po_distribution_id)
3959: ||', correction_type = '||x_correction_type);

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

3952: WHEN others then
3953: If (SQLCODE <> -20001) Then
3954: fnd_message.set_name('SQLAP','AP_DEBUG');
3955: fnd_message.set_token('ERROR',SQLERRM);
3956: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3957: fnd_message.set_token('PARAMETERS',
3958: ' po_distribution_id = '||to_char(x_corr_dist_tab(i).po_distribution_id)
3959: ||', correction_type = '||x_correction_type);
3960: fnd_message.set_token('DEBUG_INFO',l_debug_info);

Line 3957: fnd_message.set_token('PARAMETERS',

3953: If (SQLCODE <> -20001) Then
3954: fnd_message.set_name('SQLAP','AP_DEBUG');
3955: fnd_message.set_token('ERROR',SQLERRM);
3956: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3957: fnd_message.set_token('PARAMETERS',
3958: ' po_distribution_id = '||to_char(x_corr_dist_tab(i).po_distribution_id)
3959: ||', correction_type = '||x_correction_type);
3960: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3961: End if;

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

3956: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
3957: fnd_message.set_token('PARAMETERS',
3958: ' po_distribution_id = '||to_char(x_corr_dist_tab(i).po_distribution_id)
3959: ||', correction_type = '||x_correction_type);
3960: fnd_message.set_token('DEBUG_INFO',l_debug_info);
3961: End if;
3962:
3963: app_exception.raise_exception;
3964:

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

4012:
4013: EXCEPTION
4014: WHEN others then
4015: If (SQLCODE <> -20001) Then
4016: fnd_message.set_name('SQLAP','AP_DEBUG');
4017: fnd_message.set_token('ERROR',SQLERRM);
4018: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4019: fnd_message.set_token('PARAMETERS',
4020: ' po_line_location_id = '||to_char(x_po_line_location_id)

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

4013: EXCEPTION
4014: WHEN others then
4015: If (SQLCODE <> -20001) Then
4016: fnd_message.set_name('SQLAP','AP_DEBUG');
4017: fnd_message.set_token('ERROR',SQLERRM);
4018: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4019: fnd_message.set_token('PARAMETERS',
4020: ' po_line_location_id = '||to_char(x_po_line_location_id)
4021: ||', quantity = '|| to_char(x_quantity)

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

4014: WHEN others then
4015: If (SQLCODE <> -20001) Then
4016: fnd_message.set_name('SQLAP','AP_DEBUG');
4017: fnd_message.set_token('ERROR',SQLERRM);
4018: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4019: fnd_message.set_token('PARAMETERS',
4020: ' po_line_location_id = '||to_char(x_po_line_location_id)
4021: ||', quantity = '|| to_char(x_quantity)
4022: ||', amount = '|| to_char(x_amount)

Line 4019: fnd_message.set_token('PARAMETERS',

4015: If (SQLCODE <> -20001) Then
4016: fnd_message.set_name('SQLAP','AP_DEBUG');
4017: fnd_message.set_token('ERROR',SQLERRM);
4018: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4019: fnd_message.set_token('PARAMETERS',
4020: ' po_line_location_id = '||to_char(x_po_line_location_id)
4021: ||', quantity = '|| to_char(x_quantity)
4022: ||', amount = '|| to_char(x_amount)
4023: ||', correction_type = '||x_correction_type);

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

4020: ' po_line_location_id = '||to_char(x_po_line_location_id)
4021: ||', quantity = '|| to_char(x_quantity)
4022: ||', amount = '|| to_char(x_amount)
4023: ||', correction_type = '||x_correction_type);
4024: fnd_message.set_token('DEBUG_INFO',l_debug_info);
4025: End if;
4026: app_exception.raise_exception;
4027:
4028: END Update_Corr_Po_Line_Locations;

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: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)

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: ||', corrected_invoice_id = '||to_char(x_corrected_invoice_id)
4400: ||', corrected_line_number = '||to_char(x_corrected_line_number)

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

4403: ||', unit_price = '||to_char(x_unit_price)
4404: ||', correction_type = '||x_correction_type
4405: ||', final_match_flag = '||x_final_match_flag
4406: ||', po_distribution_id = '||to_char(x_po_distribution_id));
4407: fnd_message.set_token('DEBUG_INFO',l_debug_info);
4408: End if;
4409: app_exception.raise_exception;
4410:
4411:

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

4808:
4809: EXCEPTION
4810: WHEN others then
4811: If (SQLCODE <> -20001) Then
4812: fnd_message.set_name('SQLAP','AP_DEBUG');
4813: fnd_message.set_token('ERROR',SQLERRM);
4814: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4815: fnd_message.set_token('PARAMETERS',
4816: ' invoice_id = '||to_char(x_invoice_id)

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

4809: EXCEPTION
4810: WHEN others then
4811: If (SQLCODE <> -20001) Then
4812: fnd_message.set_name('SQLAP','AP_DEBUG');
4813: fnd_message.set_token('ERROR',SQLERRM);
4814: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4815: fnd_message.set_token('PARAMETERS',
4816: ' invoice_id = '||to_char(x_invoice_id)
4817: ||', invoice_line_number =' ||to_char(x_invoice_line_number)

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

4810: WHEN others then
4811: If (SQLCODE <> -20001) Then
4812: fnd_message.set_name('SQLAP','AP_DEBUG');
4813: fnd_message.set_token('ERROR',SQLERRM);
4814: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4815: fnd_message.set_token('PARAMETERS',
4816: ' invoice_id = '||to_char(x_invoice_id)
4817: ||', invoice_line_number =' ||to_char(x_invoice_line_number)
4818: ||', correction_type = '||x_correction_type

Line 4815: fnd_message.set_token('PARAMETERS',

4811: If (SQLCODE <> -20001) Then
4812: fnd_message.set_name('SQLAP','AP_DEBUG');
4813: fnd_message.set_token('ERROR',SQLERRM);
4814: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4815: fnd_message.set_token('PARAMETERS',
4816: ' invoice_id = '||to_char(x_invoice_id)
4817: ||', invoice_line_number =' ||to_char(x_invoice_line_number)
4818: ||', correction_type = '||x_correction_type
4819: ||', final_match_flag = '||x_final_match_flag

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

4817: ||', invoice_line_number =' ||to_char(x_invoice_line_number)
4818: ||', correction_type = '||x_correction_type
4819: ||', final_match_flag = '||x_final_match_flag
4820: ||', total_amount = '||to_char(x_total_amount));
4821: fnd_message.set_token('DEBUG_INFO',l_debug_info);
4822: End if;
4823:
4824: --Clean up the PL/SQL tables on error
4825: x_corr_dist_tab.delete;

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

4912:
4913: EXCEPTION
4914: WHEN others then
4915: If (SQLCODE <> -20001) Then
4916: fnd_message.set_name('SQLAP','AP_DEBUG');
4917: fnd_message.set_token('ERROR',SQLERRM);
4918: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4919: fnd_message.set_token('PARAMETERS',
4920: ' invoice_id = '||to_char(x_invoice_id)

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

4913: EXCEPTION
4914: WHEN others then
4915: If (SQLCODE <> -20001) Then
4916: fnd_message.set_name('SQLAP','AP_DEBUG');
4917: fnd_message.set_token('ERROR',SQLERRM);
4918: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4919: fnd_message.set_token('PARAMETERS',
4920: ' invoice_id = '||to_char(x_invoice_id)
4921: ||', Po header id = '||to_char(x_po_header_id)

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

4914: WHEN others then
4915: If (SQLCODE <> -20001) Then
4916: fnd_message.set_name('SQLAP','AP_DEBUG');
4917: fnd_message.set_token('ERROR',SQLERRM);
4918: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4919: fnd_message.set_token('PARAMETERS',
4920: ' invoice_id = '||to_char(x_invoice_id)
4921: ||', Po header id = '||to_char(x_po_header_id)
4922: ||', match option = '||x_match_option

Line 4919: fnd_message.set_token('PARAMETERS',

4915: If (SQLCODE <> -20001) Then
4916: fnd_message.set_name('SQLAP','AP_DEBUG');
4917: fnd_message.set_token('ERROR',SQLERRM);
4918: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
4919: fnd_message.set_token('PARAMETERS',
4920: ' invoice_id = '||to_char(x_invoice_id)
4921: ||', Po header id = '||to_char(x_po_header_id)
4922: ||', match option = '||x_match_option
4923: ||', invoice_amount = '||to_char(x_invoice_amount));

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

4920: ' invoice_id = '||to_char(x_invoice_id)
4921: ||', Po header id = '||to_char(x_po_header_id)
4922: ||', match option = '||x_match_option
4923: ||', invoice_amount = '||to_char(x_invoice_amount));
4924: fnd_message.set_token('DEBUG_INFO',l_debug_info);
4925: End if;
4926: --Clean up the PL/SQL tables on error
4927: l_shipment_table.delete;
4928:

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

5634:
5635: EXCEPTION
5636: WHEN others then
5637: If (SQLCODE <> -20001) Then
5638: fnd_message.set_name('SQLAP','AP_DEBUG');
5639: fnd_message.set_token('ERROR',SQLERRM);
5640: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
5641: fnd_message.set_token('PARAMETERS',
5642: ' invoice_id = '||to_char(x_invoice_id)

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

5635: EXCEPTION
5636: WHEN others then
5637: If (SQLCODE <> -20001) Then
5638: fnd_message.set_name('SQLAP','AP_DEBUG');
5639: fnd_message.set_token('ERROR',SQLERRM);
5640: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
5641: fnd_message.set_token('PARAMETERS',
5642: ' invoice_id = '||to_char(x_invoice_id)
5643: ||', Po header id = '||to_char(x_po_header_id)

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

5636: WHEN others then
5637: If (SQLCODE <> -20001) Then
5638: fnd_message.set_name('SQLAP','AP_DEBUG');
5639: fnd_message.set_token('ERROR',SQLERRM);
5640: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
5641: fnd_message.set_token('PARAMETERS',
5642: ' invoice_id = '||to_char(x_invoice_id)
5643: ||', Po header id = '||to_char(x_po_header_id)
5644: ||', match option = '||x_match_option

Line 5641: fnd_message.set_token('PARAMETERS',

5637: If (SQLCODE <> -20001) Then
5638: fnd_message.set_name('SQLAP','AP_DEBUG');
5639: fnd_message.set_token('ERROR',SQLERRM);
5640: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
5641: fnd_message.set_token('PARAMETERS',
5642: ' invoice_id = '||to_char(x_invoice_id)
5643: ||', Po header id = '||to_char(x_po_header_id)
5644: ||', match option = '||x_match_option
5645: ||', match_amount = '||to_char(x_match_amount));

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

5642: ' invoice_id = '||to_char(x_invoice_id)
5643: ||', Po header id = '||to_char(x_po_header_id)
5644: ||', match option = '||x_match_option
5645: ||', match_amount = '||to_char(x_match_amount));
5646: fnd_message.set_token('DEBUG_INFO',l_debug_info);
5647: End if;
5648: --Clean up the PL/SQL tables on error
5649: x_shipment_table.delete;
5650:

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

6010:
6011: EXCEPTION
6012: WHEN others then
6013: If (SQLCODE <> -20001) Then
6014: fnd_message.set_name('SQLAP','AP_DEBUG');
6015: fnd_message.set_token('ERROR',SQLERRM);
6016: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
6017: fnd_message.set_token('PARAMETERS',
6018: ' invoice_id = '||to_char(x_invoice_id)

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

6011: EXCEPTION
6012: WHEN others then
6013: If (SQLCODE <> -20001) Then
6014: fnd_message.set_name('SQLAP','AP_DEBUG');
6015: fnd_message.set_token('ERROR',SQLERRM);
6016: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
6017: fnd_message.set_token('PARAMETERS',
6018: ' invoice_id = '||to_char(x_invoice_id)
6019: ||', match option = '||x_match_option);

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

6012: WHEN others then
6013: If (SQLCODE <> -20001) Then
6014: fnd_message.set_name('SQLAP','AP_DEBUG');
6015: fnd_message.set_token('ERROR',SQLERRM);
6016: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
6017: fnd_message.set_token('PARAMETERS',
6018: ' invoice_id = '||to_char(x_invoice_id)
6019: ||', match option = '||x_match_option);
6020: fnd_message.set_token('DEBUG_INFO',l_debug_info);

Line 6017: fnd_message.set_token('PARAMETERS',

6013: If (SQLCODE <> -20001) Then
6014: fnd_message.set_name('SQLAP','AP_DEBUG');
6015: fnd_message.set_token('ERROR',SQLERRM);
6016: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
6017: fnd_message.set_token('PARAMETERS',
6018: ' invoice_id = '||to_char(x_invoice_id)
6019: ||', match option = '||x_match_option);
6020: fnd_message.set_token('DEBUG_INFO',l_debug_info);
6021: End if;

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

6016: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
6017: fnd_message.set_token('PARAMETERS',
6018: ' invoice_id = '||to_char(x_invoice_id)
6019: ||', match option = '||x_match_option);
6020: fnd_message.set_token('DEBUG_INFO',l_debug_info);
6021: End if;
6022:
6023: app_exception.raise_exception;
6024:

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

6108:
6109: EXCEPTION
6110: WHEN others then
6111: If (SQLCODE <> -20001) Then
6112: fnd_message.set_name('SQLAP','AP_DEBUG');
6113: fnd_message.set_token('ERROR',SQLERRM);
6114: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
6115: fnd_message.set_token('PARAMETERS',
6116: ' invoice_id = '||to_char(p_invoice_id));

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

6109: EXCEPTION
6110: WHEN others then
6111: If (SQLCODE <> -20001) Then
6112: fnd_message.set_name('SQLAP','AP_DEBUG');
6113: fnd_message.set_token('ERROR',SQLERRM);
6114: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
6115: fnd_message.set_token('PARAMETERS',
6116: ' invoice_id = '||to_char(p_invoice_id));
6117: fnd_message.set_token('DEBUG_INFO',l_debug_info);

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

6110: WHEN others then
6111: If (SQLCODE <> -20001) Then
6112: fnd_message.set_name('SQLAP','AP_DEBUG');
6113: fnd_message.set_token('ERROR',SQLERRM);
6114: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
6115: fnd_message.set_token('PARAMETERS',
6116: ' invoice_id = '||to_char(p_invoice_id));
6117: fnd_message.set_token('DEBUG_INFO',l_debug_info);
6118: End if;

Line 6115: fnd_message.set_token('PARAMETERS',

6111: If (SQLCODE <> -20001) Then
6112: fnd_message.set_name('SQLAP','AP_DEBUG');
6113: fnd_message.set_token('ERROR',SQLERRM);
6114: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
6115: fnd_message.set_token('PARAMETERS',
6116: ' invoice_id = '||to_char(p_invoice_id));
6117: fnd_message.set_token('DEBUG_INFO',l_debug_info);
6118: End if;
6119:

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

6113: fnd_message.set_token('ERROR',SQLERRM);
6114: fnd_message.set_token('CALLING_SEQUENCE',current_calling_sequence);
6115: fnd_message.set_token('PARAMETERS',
6116: ' invoice_id = '||to_char(p_invoice_id));
6117: fnd_message.set_token('DEBUG_INFO',l_debug_info);
6118: End if;
6119:
6120: app_exception.raise_exception;
6121:

Line 6191: l_debug_info := 'Charge Account is Invalid -> '||FND_MESSAGE.GET;

6187: -- Print reason why flex failed
6188: P_result_ccid := -1;
6189: P_reason_unbuilt_flex := 'INVALID ACCOUNT';
6190:
6191: l_debug_info := 'Charge Account is Invalid -> '||FND_MESSAGE.GET;
6192: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6193: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6194: END IF;
6195:

Line 6209: l_debug_info := 'Overlay Account is Invalid -> '||FND_MESSAGE.GET;

6205: -- Print reason why flex failed
6206: P_result_ccid := -1;
6207: P_reason_unbuilt_flex := 'INVALID ACCOUNT';
6208:
6209: l_debug_info := 'Overlay Account is Invalid -> '||FND_MESSAGE.GET;
6210: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6211: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6212: END IF;
6213:

Line 6254: l_debug_info := 'Account Based on Overlayed Segments can not be build -> '||FND_MESSAGE.GET;

6250: -- Store reason why flex failed
6251: P_result_ccid := -1;
6252: P_reason_unbuilt_flex := 'INVALID ACCOUNT';
6253:
6254: l_debug_info := 'Account Based on Overlayed Segments can not be build -> '||FND_MESSAGE.GET;
6255: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6256: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6257: END IF;
6258:

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

6260:
6261: EXCEPTION
6262: WHEN OTHERS THEN
6263: IF (SQLCODE <> -20001) THEN
6264: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6265: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6266: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6267: FND_MESSAGE.SET_TOKEN('PARAMETERS','Base CCID = '||to_char(p_base_ccid)
6268: ||', Overlay CCID = '||to_char(p_overlay_ccid));

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

6261: EXCEPTION
6262: WHEN OTHERS THEN
6263: IF (SQLCODE <> -20001) THEN
6264: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6265: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6266: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6267: FND_MESSAGE.SET_TOKEN('PARAMETERS','Base CCID = '||to_char(p_base_ccid)
6268: ||', Overlay CCID = '||to_char(p_overlay_ccid));
6269: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

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

6262: WHEN OTHERS THEN
6263: IF (SQLCODE <> -20001) THEN
6264: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6265: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6266: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6267: FND_MESSAGE.SET_TOKEN('PARAMETERS','Base CCID = '||to_char(p_base_ccid)
6268: ||', Overlay CCID = '||to_char(p_overlay_ccid));
6269: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
6270:

Line 6267: FND_MESSAGE.SET_TOKEN('PARAMETERS','Base CCID = '||to_char(p_base_ccid)

6263: IF (SQLCODE <> -20001) THEN
6264: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6265: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6266: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6267: FND_MESSAGE.SET_TOKEN('PARAMETERS','Base CCID = '||to_char(p_base_ccid)
6268: ||', Overlay CCID = '||to_char(p_overlay_ccid));
6269: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
6270:
6271: l_debug_info := 'Exception occured in Building Prepay Account> '||FND_MESSAGE.GET;

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

6265: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6266: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6267: FND_MESSAGE.SET_TOKEN('PARAMETERS','Base CCID = '||to_char(p_base_ccid)
6268: ||', Overlay CCID = '||to_char(p_overlay_ccid));
6269: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
6270:
6271: l_debug_info := 'Exception occured in Building Prepay Account> '||FND_MESSAGE.GET;
6272: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6273: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

Line 6271: l_debug_info := 'Exception occured in Building Prepay Account> '||FND_MESSAGE.GET;

6267: FND_MESSAGE.SET_TOKEN('PARAMETERS','Base CCID = '||to_char(p_base_ccid)
6268: ||', Overlay CCID = '||to_char(p_overlay_ccid));
6269: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
6270:
6271: l_debug_info := 'Exception occured in Building Prepay Account> '||FND_MESSAGE.GET;
6272: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6273: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6274: END IF;
6275: END IF;