DBA Data[Home] [Help]

APPS.PO_COPYDOC_S1 dependencies on PO_DEBUG

Line 6: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

2: /* $Header: POXCPO1B.pls 120.63.12020000.4 2013/02/25 09:23:49 mabaig ship $*/
3:
4: --< Shared Proc FPJ Start >
5: -- Debugging booleans used to bypass logging when turned off
6: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
7: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
8:
9: g_pkg_name CONSTANT VARCHAR2(20) := 'PO_COPYDOC_S1';
10: g_module_prefix CONSTANT VARCHAR2(30) := 'po.plsql.' || g_pkg_name || '.';

Line 7: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

3:
4: --< Shared Proc FPJ Start >
5: -- Debugging booleans used to bypass logging when turned off
6: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
7: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
8:
9: g_pkg_name CONSTANT VARCHAR2(20) := 'PO_COPYDOC_S1';
10: g_module_prefix CONSTANT VARCHAR2(30) := 'po.plsql.' || g_pkg_name || '.';
11: --< Shared Proc FPJ End >

Line 476: PO_DEBUG.debug_stmt

472:
473: l_progress := '000';
474:
475: IF g_debug_stmt THEN --< Shared Proc FPJ > Add correct debugging
476: PO_DEBUG.debug_stmt
477: (p_log_head => g_module_prefix||'insert_header',
478: p_token => 'invoked',
479: p_message => 'header ID: '||x_po_header_record.po_header_id||
480: ' online_report ID: '||x_online_report_id);

Line 899: PO_DEBUG.debug_exc

895: x_sequence,
896: 0, 0, 0);
897: x_return_code := -1;
898: IF g_debug_unexp THEN --< Shared Proc FPJ > Add correct debugging
899: PO_DEBUG.debug_exc
900: (p_log_head => g_module_prefix||'insert_header',
901: p_progress => l_progress);
902: END IF;
903: END insert_header;

Line 933: PO_DEBUG.debug_stmt

929:
930: l_progress := '001';
931:
932: IF g_debug_stmt THEN --< Shared Proc FPJ > Add correct debugging
933: PO_DEBUG.debug_stmt
934: (p_log_head => g_module_prefix||'insert_line',
935: p_token => 'invoked',
936: p_message => 'line ID: '||x_po_line_record.po_line_id||
937: ' online_report ID: '||x_online_report_id);

Line 1275: PO_DEBUG.debug_exc

1271: x_sequence,
1272: x_po_line_record.line_num, 0, 0);
1273: x_return_code := -1;
1274: IF g_debug_unexp THEN --< Shared Proc FPJ > Add correct debugging
1275: PO_DEBUG.debug_exc
1276: (p_log_head => g_module_prefix||'insert_line',
1277: p_progress => l_progress);
1278: END IF;
1279: END insert_line;

Line 1358: PO_DEBUG.debug_stmt

1354:
1355: l_progress := '000';
1356:
1357: IF g_debug_stmt THEN --< Shared Proc FPJ > Add correct debugging
1358: PO_DEBUG.debug_stmt
1359: (p_log_head => g_module_prefix||'insert_shipment',
1360: p_token => 'invoked',
1361: p_message => 'ship ID: '||x_po_shipment_record.line_location_id||
1362: ' inv_org ID: '||x_inv_org_id||' accrue_on_receipt_flag: '||

Line 1996: PO_DEBUG.debug_exc

1992: x_sequence,
1993: x_line_num, x_po_shipment_record.shipment_num, 0);
1994: x_return_code := -1;
1995: IF g_debug_unexp THEN --< Shared Proc FPJ > Add correct debugging
1996: PO_DEBUG.debug_exc
1997: (p_log_head => g_module_prefix||'insert_shipment',
1998: p_progress => l_progress);
1999: END IF;
2000: END insert_shipment;

Line 2029: PO_DEBUG.debug_stmt

2025: BEGIN
2026:
2027: l_progress := '000';
2028: IF g_debug_stmt THEN --< Shared Proc FPJ > Add correct debugging
2029: PO_DEBUG.debug_stmt
2030: (p_log_head => g_module_prefix||'insert_distribution',
2031: p_token => 'invoked',
2032: p_message => 'dist ID: '||
2033: x_po_distribution_record.po_distribution_id||

Line 2343: PO_DEBUG.debug_stmt

2339: END LOOP;
2340: x_return_code := -1;
2341: --
2342: IF g_debug_stmt THEN --< Shared Proc FPJ > Add correct debugging
2343: PO_DEBUG.debug_stmt
2344: (p_log_head => g_module_prefix||'insert_distribution',
2345: p_token => l_progress,
2346: p_message => 'FND_API.g_exc_error exception caught.');
2347: END IF;

Line 2350: PO_DEBUG.debug_exc

2346: p_message => 'FND_API.g_exc_error exception caught.');
2347: END IF;
2348:
2349: IF g_debug_unexp THEN --< Shared Proc FPJ > Add correct debugging
2350: PO_DEBUG.debug_exc
2351: (p_log_head => g_module_prefix||'insert_distribution',
2352: p_progress => l_progress);
2353: END IF;
2354:

Line 2363: PO_DEBUG.debug_exc

2359: x_sequence,
2360: x_line_num, x_shipment_num, x_po_distribution_record.distribution_num);
2361: x_return_code := -1;
2362: IF g_debug_unexp THEN --< Shared Proc FPJ > Add correct debugging
2363: PO_DEBUG.debug_exc
2364: (p_log_head => g_module_prefix||'insert_distribution',
2365: p_progress => l_progress);
2366: END IF;
2367: END insert_distribution;

Line 2444: PO_DEBUG.debug_stmt

2440: BEGIN
2441:
2442: l_progress := '000';
2443: IF g_debug_stmt THEN --< Shared Proc FPJ > Add correct debugging
2444: PO_DEBUG.debug_stmt
2445: (p_log_head => g_module_prefix||'process_header',
2446: p_token => 'invoked',
2447: p_message => 'action_code: ' ||x_action_code||' to_doc_subtype: '||
2448: x_to_doc_subtype||' from header ID: '||x_from_po_header_id||

Line 2648: PO_DEBUG.debug_exc

2644: x_online_report_id,
2645: x_sequence,
2646: 0, 0, 0);
2647: IF g_debug_unexp THEN --< Shared Proc FPJ > Add correct debugging
2648: PO_DEBUG.debug_exc
2649: (p_log_head => g_module_prefix||'process_header',
2650: p_progress => l_progress);
2651: END IF;
2652: END process_header;

Line 2785: PO_DEBUG.debug_begin(l_log_head);

2781: BEGIN
2782: l_progress := '010';
2783:
2784: IF g_debug_stmt THEN
2785: PO_DEBUG.debug_begin(l_log_head);
2786: PO_DEBUG.debug_var(l_log_head,l_progress,'p_orig_po_line_id',p_orig_po_line_id);
2787: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_header_id',p_new_po_header_id);
2788: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_line_id',p_new_po_line_id);
2789: PO_DEBUG.debug_var(l_log_head,l_progress,'p_line_num',p_line_num);

Line 2786: PO_DEBUG.debug_var(l_log_head,l_progress,'p_orig_po_line_id',p_orig_po_line_id);

2782: l_progress := '010';
2783:
2784: IF g_debug_stmt THEN
2785: PO_DEBUG.debug_begin(l_log_head);
2786: PO_DEBUG.debug_var(l_log_head,l_progress,'p_orig_po_line_id',p_orig_po_line_id);
2787: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_header_id',p_new_po_header_id);
2788: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_line_id',p_new_po_line_id);
2789: PO_DEBUG.debug_var(l_log_head,l_progress,'p_line_num',p_line_num);
2790: PO_DEBUG.debug_var(l_log_head,l_progress,'p_online_report_id',p_online_report_id);

Line 2787: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_header_id',p_new_po_header_id);

2783:
2784: IF g_debug_stmt THEN
2785: PO_DEBUG.debug_begin(l_log_head);
2786: PO_DEBUG.debug_var(l_log_head,l_progress,'p_orig_po_line_id',p_orig_po_line_id);
2787: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_header_id',p_new_po_header_id);
2788: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_line_id',p_new_po_line_id);
2789: PO_DEBUG.debug_var(l_log_head,l_progress,'p_line_num',p_line_num);
2790: PO_DEBUG.debug_var(l_log_head,l_progress,'p_online_report_id',p_online_report_id);
2791: PO_DEBUG.debug_var(l_log_head,l_progress,'x_sequence',x_sequence);

Line 2788: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_line_id',p_new_po_line_id);

2784: IF g_debug_stmt THEN
2785: PO_DEBUG.debug_begin(l_log_head);
2786: PO_DEBUG.debug_var(l_log_head,l_progress,'p_orig_po_line_id',p_orig_po_line_id);
2787: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_header_id',p_new_po_header_id);
2788: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_line_id',p_new_po_line_id);
2789: PO_DEBUG.debug_var(l_log_head,l_progress,'p_line_num',p_line_num);
2790: PO_DEBUG.debug_var(l_log_head,l_progress,'p_online_report_id',p_online_report_id);
2791: PO_DEBUG.debug_var(l_log_head,l_progress,'x_sequence',x_sequence);
2792: END IF;

Line 2789: PO_DEBUG.debug_var(l_log_head,l_progress,'p_line_num',p_line_num);

2785: PO_DEBUG.debug_begin(l_log_head);
2786: PO_DEBUG.debug_var(l_log_head,l_progress,'p_orig_po_line_id',p_orig_po_line_id);
2787: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_header_id',p_new_po_header_id);
2788: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_line_id',p_new_po_line_id);
2789: PO_DEBUG.debug_var(l_log_head,l_progress,'p_line_num',p_line_num);
2790: PO_DEBUG.debug_var(l_log_head,l_progress,'p_online_report_id',p_online_report_id);
2791: PO_DEBUG.debug_var(l_log_head,l_progress,'x_sequence',x_sequence);
2792: END IF;
2793:

Line 2790: PO_DEBUG.debug_var(l_log_head,l_progress,'p_online_report_id',p_online_report_id);

2786: PO_DEBUG.debug_var(l_log_head,l_progress,'p_orig_po_line_id',p_orig_po_line_id);
2787: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_header_id',p_new_po_header_id);
2788: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_line_id',p_new_po_line_id);
2789: PO_DEBUG.debug_var(l_log_head,l_progress,'p_line_num',p_line_num);
2790: PO_DEBUG.debug_var(l_log_head,l_progress,'p_online_report_id',p_online_report_id);
2791: PO_DEBUG.debug_var(l_log_head,l_progress,'x_sequence',x_sequence);
2792: END IF;
2793:
2794: l_progress := '020';

Line 2791: PO_DEBUG.debug_var(l_log_head,l_progress,'x_sequence',x_sequence);

2787: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_header_id',p_new_po_header_id);
2788: PO_DEBUG.debug_var(l_log_head,l_progress,'p_new_po_line_id',p_new_po_line_id);
2789: PO_DEBUG.debug_var(l_log_head,l_progress,'p_line_num',p_line_num);
2790: PO_DEBUG.debug_var(l_log_head,l_progress,'p_online_report_id',p_online_report_id);
2791: PO_DEBUG.debug_var(l_log_head,l_progress,'x_sequence',x_sequence);
2792: END IF;
2793:
2794: l_progress := '020';
2795: PO_PRICE_ADJUSTMENTS_PKG.copy_line_adjustments

Line 2811: PO_DEBUG.debug_stmt(l_log_head,l_progress,l_return_status_text);

2807: p_line_num,
2808: 0,
2809: 0);
2810: IF g_debug_stmt THEN
2811: PO_DEBUG.debug_stmt(l_log_head,l_progress,l_return_status_text);
2812: END IF;
2813: END IF;
2814:
2815: IF g_debug_stmt THEN

Line 2816: PO_DEBUG.debug_end(l_log_head);

2812: END IF;
2813: END IF;
2814:
2815: IF g_debug_stmt THEN
2816: PO_DEBUG.debug_end(l_log_head);
2817: PO_DEBUG.debug_var(l_log_head,l_progress,'x_sequence',x_sequence);
2818: END IF;
2819: EXCEPTION
2820: WHEN OTHERS THEN

Line 2817: PO_DEBUG.debug_var(l_log_head,l_progress,'x_sequence',x_sequence);

2813: END IF;
2814:
2815: IF g_debug_stmt THEN
2816: PO_DEBUG.debug_end(l_log_head);
2817: PO_DEBUG.debug_var(l_log_head,l_progress,'x_sequence',x_sequence);
2818: END IF;
2819: EXCEPTION
2820: WHEN OTHERS THEN
2821: copydoc_sql_error(x_routine => d_mod,

Line 2830: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Unhandled exception');

2826: x_line_num => p_line_num,
2827: x_shipment_num => 0,
2828: x_distribution_num => 0);
2829: IF g_debug_unexp THEN
2830: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Unhandled exception');
2831: END IF;
2832: RAISE;
2833: END copy_line_adjustments;
2834: --

Line 2865: PO_DEBUG.debug_stmt

2861: BEGIN
2862:
2863: l_progress := '000';
2864: IF g_debug_stmt THEN --< Shared Proc FPJ > Add correct debugging
2865: PO_DEBUG.debug_stmt
2866: (p_log_head => g_module_prefix||'process_line',
2867: p_token => 'invoked',
2868: p_message => 'action_code: ' ||x_action_code||' to_doc_subtype: '||
2869: x_to_doc_subtype||' header ID: '||x_po_header_id||

Line 3031: PO_DEBUG.debug_exc

3027: x_online_report_id,
3028: x_sequence,
3029: x_po_line_record.line_num, 0, 0);
3030: IF g_debug_unexp THEN --< Shared Proc FPJ > Add correct debugging
3031: PO_DEBUG.debug_exc
3032: (p_log_head => g_module_prefix||'process_line',
3033: p_progress => l_progress);
3034: END IF;
3035: END process_line;

Line 3092: PO_DEBUG.debug_stmt

3088: BEGIN
3089:
3090: l_progress := '000';
3091: IF g_debug_stmt THEN --< Shared Proc FPJ > Add correct debugging
3092: PO_DEBUG.debug_stmt
3093: (p_log_head => g_module_prefix||'process_shipment',
3094: p_token => 'invoked',
3095: p_message => 'action_code: ' ||p_action_code||' to_doc_subtype: '||
3096: p_to_doc_subtype||' header ID: '||p_po_header_id||

Line 3296: PO_DEBUG.debug_exc

3292: p_online_report_id,
3293: x_sequence,
3294: p_line_num, x_po_shipment_record.shipment_num, 0);
3295: IF g_debug_unexp THEN --< Shared Proc FPJ > Add correct debugging
3296: PO_DEBUG.debug_exc
3297: (p_log_head => g_module_prefix||'process_shipment',
3298: p_progress => l_progress);
3299: END IF;
3300: END process_shipment;

Line 3358: PO_DEBUG.debug_stmt

3354: END IF;
3355: --
3356:
3357: IF g_debug_stmt THEN --< Shared Proc FPJ > Add correct debugging
3358: PO_DEBUG.debug_stmt
3359: (p_log_head => g_module_prefix||'process_distribution',
3360: p_token => 'invoked',
3361: p_message => 'action_code: '||p_action_code||' to_doc_subtype: '||
3362: p_to_doc_subtype||' header ID: '||

Line 3469: PO_DEBUG.debug_stmt

3465: --< Shared Proc FPJ Start >
3466: WHEN FND_API.g_exc_error THEN
3467: x_return_code := -1;
3468: IF g_debug_stmt THEN
3469: PO_DEBUG.debug_stmt
3470: (p_log_head => g_module_prefix||'process_distribution',
3471: p_token => l_progress,
3472: p_message => 'FND_API.g_exc_error exception caught.');
3473: END IF;

Line 3484: PO_DEBUG.debug_exc

3480: l_line_num,
3481: l_shipment_num,
3482: x_po_distribution_rec.distribution_num);
3483: IF g_debug_unexp THEN --< Shared Proc FPJ > Add correct debugging
3484: PO_DEBUG.debug_exc
3485: (p_log_head => g_module_prefix||'process_distribution',
3486: p_progress => l_progress);
3487: END IF;
3488: END process_distribution;

Line 3578: PO_DEBUG.debug_stmt

3574: d_module VARCHAR2(70) := 'po.plsql.PO_COPYDOC_S1.copy_document';
3575:
3576: BEGIN
3577: IF g_debug_stmt THEN --< Shared Proc FPJ > Add correct debugging
3578: PO_DEBUG.debug_stmt
3579: (p_log_head => g_module_prefix||'copy_document',
3580: p_token => 'invoked',
3581: p_message => 'action_code: ' ||x_action_code||' to_doc_subtype: '||
3582: x_to_doc_subtype||' from header ID: '||x_from_po_header_id||

Line 4194: PO_DEBUG.debug_stmt

4190: --< HTML Agreements R12 End>
4191: END IF;
4192:
4193: IF g_debug_stmt THEN --< Shared Proc FPJ > Add correct debugging
4194: PO_DEBUG.debug_stmt
4195: (p_log_head => g_module_prefix||'copy_document',
4196: p_token => 'end',
4197: p_message => 'x_return_code = '||x_return_code||
4198: ' x_sequence = '||x_sequence);

Line 4205: PO_DEBUG.debug_stmt

4201: EXCEPTION
4202: WHEN COPYDOC_FATAL THEN
4203: ROLLBACK TO SAVEPOINT COPY_DOCUMENT_PVT; --< HTML Agreements R12>
4204: IF g_debug_stmt THEN --< Shared Proc FPJ > Add correct debugging
4205: PO_DEBUG.debug_stmt
4206: (p_log_head => g_module_prefix||'copy_document',
4207: p_token => x_progress,
4208: p_message => 'COPYDOC_FATAL exception caught.');
4209: END IF;

Line 4215: PO_DEBUG.debug_exc

4211: RAISE;
4212: WHEN OTHERS THEN
4213: ROLLBACK TO SAVEPOINT COPY_DOCUMENT_PVT; --< HTML Agreements R12>
4214: IF g_debug_unexp THEN --< Shared Proc FPJ > Add correct debugging
4215: PO_DEBUG.debug_exc
4216: (p_log_head => g_module_prefix||'copy_document',
4217: p_progress => x_progress);
4218: END IF;
4219: copydoc_sql_error('copy_document', x_progress, sqlcode,

Line 4667: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Starting code for UDA Submission check');

4663: l_clm_delivery_event_code po_lines_all.clm_delivery_event_code%type;
4664:
4665: BEGIN
4666: l_progress := '8880';
4667: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Starting code for UDA Submission check');
4668: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'PK VALUE IS :' || p_to_pk_value);
4669:
4670: IF p_level = 'HEADER' THEN
4671:

Line 4668: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'PK VALUE IS :' || p_to_pk_value);

4664:
4665: BEGIN
4666: l_progress := '8880';
4667: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Starting code for UDA Submission check');
4668: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'PK VALUE IS :' || p_to_pk_value);
4669:
4670: IF p_level = 'HEADER' THEN
4671:
4672: IF PO_CLM_CLO_UTIL.Isclminstalled THEN

Line 4708: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Template id is ' || l_template_id);

4704: INTO l_template_id
4705: FROM po_headers_all
4706: WHERE PO_HEADER_ID = p_from_pk_value;
4707:
4708: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Template id is ' || l_template_id);
4709:
4710: IF l_template_id IS NULL THEN
4711: RETURN;
4712: END IF;

Line 4822: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Before collecting data');

4818: l_pk_col_name := 'PO_DISTRIBUTION_ID';
4819:
4820: END IF;
4821:
4822: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Before collecting data');
4823:
4824:
4825: SELECT 'PURCHASING', TYPE_LOOKUP_CODE, STYLE_ID
4826: INTO l_functional_area_code, l_document_type_code, l_document_style_id

Line 4831: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Fetched template details');

4827: FROM po_headers_all
4828: WHERE PO_HEADER_ID = p_from_po_header_id;
4829:
4830: l_progress := '8881';
4831: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Fetched template details');
4832: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_functional_area_code :' || l_functional_area_code);
4833: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_document_type_code : ' || l_document_type_code);
4834: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_document_style_id : ' || l_document_style_id);
4835:

Line 4832: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_functional_area_code :' || l_functional_area_code);

4828: WHERE PO_HEADER_ID = p_from_po_header_id;
4829:
4830: l_progress := '8881';
4831: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Fetched template details');
4832: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_functional_area_code :' || l_functional_area_code);
4833: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_document_type_code : ' || l_document_type_code);
4834: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_document_style_id : ' || l_document_style_id);
4835:
4836: l_progress := '8882';

Line 4833: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_document_type_code : ' || l_document_type_code);

4829:
4830: l_progress := '8881';
4831: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Fetched template details');
4832: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_functional_area_code :' || l_functional_area_code);
4833: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_document_type_code : ' || l_document_type_code);
4834: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_document_style_id : ' || l_document_style_id);
4835:
4836: l_progress := '8882';
4837: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Before Check_Uda_Enabled');

Line 4834: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_document_style_id : ' || l_document_style_id);

4830: l_progress := '8881';
4831: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Fetched template details');
4832: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_functional_area_code :' || l_functional_area_code);
4833: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_document_type_code : ' || l_document_type_code);
4834: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_document_style_id : ' || l_document_style_id);
4835:
4836: l_progress := '8882';
4837: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Before Check_Uda_Enabled');
4838:

Line 4837: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Before Check_Uda_Enabled');

4833: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_document_type_code : ' || l_document_type_code);
4834: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'l_document_style_id : ' || l_document_style_id);
4835:
4836: l_progress := '8882';
4837: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Before Check_Uda_Enabled');
4838:
4839: PO_CLM_CLO_UTIL.Check_Uda_Enabled
4840: (
4841: p_functional_area_code => l_functional_area_code

Line 4852: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'After Check_Uda_Enabled with x_return_status : ' || x_return_status);

4848: ,x_msg_data => x_msg_data
4849: );
4850:
4851: l_progress := '8883';
4852: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'After Check_Uda_Enabled with x_return_status : ' || x_return_status);
4853: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Check_Uda_Enabled with x_enabled_flag : ' || l_enabled_flag);
4854:
4855: l_progress := '8884';
4856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

Line 4853: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Check_Uda_Enabled with x_enabled_flag : ' || l_enabled_flag);

4849: );
4850:
4851: l_progress := '8883';
4852: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'After Check_Uda_Enabled with x_return_status : ' || x_return_status);
4853: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Check_Uda_Enabled with x_enabled_flag : ' || l_enabled_flag);
4854:
4855: l_progress := '8884';
4856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4857: THEN

Line 4961: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, SQLERRM);

4957: (
4958: p_pkg_name => 'po_copydoc_s1',
4959: p_procedure_name => 'COPY_UDA_ATTRS' || '.' || l_progress
4960: );
4961: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, SQLERRM);
4962: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Exception in COPY_UDA_ATTRS');
4963: x_return_status := 'U';
4964: END COPY_UDA_ATTRS;
4965:

Line 4962: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Exception in COPY_UDA_ATTRS');

4958: p_pkg_name => 'po_copydoc_s1',
4959: p_procedure_name => 'COPY_UDA_ATTRS' || '.' || l_progress
4960: );
4961: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, SQLERRM);
4962: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Exception in COPY_UDA_ATTRS');
4963: x_return_status := 'U';
4964: END COPY_UDA_ATTRS;
4965:
4966: