APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_INVOICES_S

Line 3514: debug_info := '(Insert ap invoices step 1) Get new invoice_id for base ' ||

3510: -- Step 1
3511: -- get new invoice_id for base table ap_invoices
3512: -----------------------------------------------------------------------------
3513:
3514: debug_info := '(Insert ap invoices step 1) Get new invoice_id for base ' ||
3515: 'table ap_invoices';
3516: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
3517: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
3518: END IF;

Line 3521: SELECT ap_invoices_s.nextval

3517: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
3518: END IF;
3519: -- Bug 5448579
3520: /*
3521: SELECT ap_invoices_s.nextval
3522: INTO l_invoice_id
3523: FROM sys.dual;
3524: */
3525: -----------------------------------------------------------------------------

Line 3530: debug_info := '(Insert ap invoices step 2)-Get wfapproval_status ' ||

3526: -- Step 2
3527: -- get wfapproval_status from profile value - ASP.approval_workflow_flag
3528: -----------------------------------------------------------------------------
3529:
3530: debug_info := '(Insert ap invoices step 2)-Get wfapproval_status ' ||
3531: 'depends on profile value';
3532: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
3533: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
3534: END IF;

Line 3564: debug_info := '(Insert ap invoices step 3) - Call ' ||

3560: -----------------------------------------------------------------------------
3561: -- Step 3
3562: -- Insert jg_zz_invoice_info
3563: -----------------------------------------------------------------------------
3564: debug_info := '(Insert ap invoices step 3) - Call ' ||
3565: 'jg_globe_flex_val.insert_jg_zz_invoice_info';
3566: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
3567: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
3568: END IF;

Line 3603: debug_info := '(Insert ap invoices step 3) Calculate earliest settlement date for Prepayment type invoices';

3599:
3600: */
3601:
3602:
3603: debug_info := '(Insert ap invoices step 3) Calculate earliest settlement date for Prepayment type invoices';
3604: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
3605: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
3606: END IF;
3607:

Line 3618: debug_info := '(Insert ap invoices step 4) - Insert into ap_invoices';

3614: -- Step 4
3615: -- Insert into ap_invoices table
3616: -----------------------------------------------------------------------------
3617:
3618: debug_info := '(Insert ap invoices step 4) - Insert into ap_invoices';
3619: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
3620: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
3621: END IF;
3622:

Line 3774: VALUES (ap_invoices_s.nextval, -- l_invoice_id, Bug 5448579

3770: REMIT_TO_SUPPLIER_SITE,
3771: REMIT_TO_SUPPLIER_SITE_ID,
3772: RELATIONSHIP_ID
3773: )
3774: VALUES (ap_invoices_s.nextval, -- l_invoice_id, Bug 5448579
3775: p_invoice_rec.org_id,
3776: p_invoice_rec.last_update_date,
3777: --bug 6951863 fix -start
3778: --p_invoice_rec.last_update_login,

Line 3943: debug_info := '(Insert ap invoices step 5) before copy attachments: '||

3939: -----------------------------------------------------------------------------
3940: -- Step 5
3941: -- copy attachment for the invoice
3942: -----------------------------------------------------------------------------
3943: debug_info := '(Insert ap invoices step 5) before copy attachments: '||
3944: 'source = ' || p_invoice_rec.source || ', from_invoice_id = ' ||
3945: p_invoice_rec.invoice_id || ', to_invoice_id = ' || l_invoice_id;
3946: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
3947: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);

Line 3952: debug_info := '(Insert ap invoices step 5) copy attachments done: ' ||

3948: END IF;
3949:
3950: l_attachments_count :=
3951: copy_attachments(p_invoice_rec.invoice_id, l_invoice_id);
3952: debug_info := '(Insert ap invoices step 5) copy attachments done: ' ||
3953: l_attachments_count;
3954: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
3955: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
3956: END IF;

Line 3962: debug_info := '(Insert ap invoices step 6) - Return the new invoice_id-> ' ||

3958: -----------------------------------------------------------------------------
3959: -- Step 6
3960: -- Assign the out parameter for new invoice_id
3961: -----------------------------------------------------------------------------
3962: debug_info := '(Insert ap invoices step 6) - Return the new invoice_id-> ' ||
3963: to_char(l_invoice_id);
3964: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
3965: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
3966: END IF;