APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_INVOICES_S

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

2822: -- Step 1
2823: -- get new invoice_id for base table ap_invoices
2824: -----------------------------------------------------------------------------
2825:
2826: debug_info := '(Insert ap invoices step 1) Get new invoice_id for base ' ||
2827: 'table ap_invoices';
2828: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
2829: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
2830: END IF;

Line 2833: SELECT ap_invoices_s.nextval

2829: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
2830: END IF;
2831: -- Bug 5448579
2832: /*
2833: SELECT ap_invoices_s.nextval
2834: INTO l_invoice_id
2835: FROM sys.dual;
2836: */
2837: -----------------------------------------------------------------------------

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

2838: -- Step 2
2839: -- get wfapproval_status from profile value - ASP.approval_workflow_flag
2840: -----------------------------------------------------------------------------
2841:
2842: debug_info := '(Insert ap invoices step 2)-Get wfapproval_status ' ||
2843: 'depends on profile value';
2844: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
2845: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
2846: END IF;

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

2872: -----------------------------------------------------------------------------
2873: -- Step 3
2874: -- Insert jg_zz_invoice_info
2875: -----------------------------------------------------------------------------
2876: debug_info := '(Insert ap invoices step 3) - Call ' ||
2877: 'jg_globe_flex_val.insert_jg_zz_invoice_info';
2878: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
2879: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
2880: END IF;

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

2911:
2912: */
2913:
2914:
2915: debug_info := '(Insert ap invoices step 3) Calculate earliest settlement date for Prepayment type invoices';
2916: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
2917: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
2918: END IF;
2919:

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

2926: -- Step 4
2927: -- Insert into ap_invoices table
2928: -----------------------------------------------------------------------------
2929:
2930: debug_info := '(Insert ap invoices step 4) - Insert into ap_invoices';
2931: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
2932: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
2933: END IF;
2934:

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

3081: REMIT_TO_SUPPLIER_SITE,
3082: REMIT_TO_SUPPLIER_SITE_ID,
3083: RELATIONSHIP_ID
3084: )
3085: VALUES (ap_invoices_s.nextval, -- l_invoice_id, Bug 5448579
3086: p_invoice_rec.org_id,
3087: p_invoice_rec.last_update_date,
3088: --bug 6951863 fix -start
3089: --p_invoice_rec.last_update_login,

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

3244: -----------------------------------------------------------------------------
3245: -- Step 5
3246: -- copy attachment for the invoice
3247: -----------------------------------------------------------------------------
3248: debug_info := '(Insert ap invoices step 5) before copy attachments: '||
3249: 'source = ' || p_invoice_rec.source || ', from_invoice_id = ' ||
3250: p_invoice_rec.invoice_id || ', to_invoice_id = ' || l_invoice_id;
3251: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
3252: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);

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

3253: END IF;
3254:
3255: l_attachments_count :=
3256: copy_attachments(p_invoice_rec.invoice_id, l_invoice_id);
3257: debug_info := '(Insert ap invoices step 5) copy attachments done: ' ||
3258: l_attachments_count;
3259: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
3260: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
3261: END IF;

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

3263: -----------------------------------------------------------------------------
3264: -- Step 6
3265: -- Assign the out parameter for new invoice_id
3266: -----------------------------------------------------------------------------
3267: debug_info := '(Insert ap invoices step 6) - Return the new invoice_id-> ' ||
3268: to_char(l_invoice_id);
3269: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
3270: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch, debug_info);
3271: END IF;