APPS.PO_COPYDOC_S1 dependencies on PO_LOG

Line 15: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base(g_pkg_name);

11: --< Shared Proc FPJ End >
12:
13: --
14: -- The module base for this package.
15: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base(g_pkg_name);
16:
17: -- The module base for the subprogram.
18: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
19: --

Line 18: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');

14: -- The module base for this package.
15: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base(g_pkg_name);
16:
17: -- The module base for the subprogram.
18: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
19: --
20:
21: -- Cursor definitions:
22:

Line 308: IF (PO_LOG.d_proc) THEN

304: d_pos NUMBER;
305: d_module VARCHAR2(70) := 'po.plsql.PO_COPYDOC_S1.RET_AND_DEL_ONLINE_REPORT_REC';
306: d_log_msg VARCHAR2(200);
307: BEGIN
308: IF (PO_LOG.d_proc) THEN
309: PO_LOG.proc_begin(d_module);
310: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);
311: END IF;
312: d_pos := 10;

Line 309: PO_LOG.proc_begin(d_module);

305: d_module VARCHAR2(70) := 'po.plsql.PO_COPYDOC_S1.RET_AND_DEL_ONLINE_REPORT_REC';
306: d_log_msg VARCHAR2(200);
307: BEGIN
308: IF (PO_LOG.d_proc) THEN
309: PO_LOG.proc_begin(d_module);
310: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);
311: END IF;
312: d_pos := 10;
313: DELETE PO_ONLINE_REPORT_TEXT

Line 310: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);

306: d_log_msg VARCHAR2(200);
307: BEGIN
308: IF (PO_LOG.d_proc) THEN
309: PO_LOG.proc_begin(d_module);
310: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);
311: END IF;
312: d_pos := 10;
313: DELETE PO_ONLINE_REPORT_TEXT
314: WHERE ONLINE_REPORT_ID = p_online_report_id

Line 318: IF PO_LOG.d_stmt THEN

314: WHERE ONLINE_REPORT_ID = p_online_report_id
315: RETURNING MESSAGE_TYPE, TEXT_LINE
316: INTO x_message_type, x_message;
317: d_pos := 20;
318: IF PO_LOG.d_stmt THEN
319: PO_LOG.stmt(d_module,d_pos,'x_message_type',x_message_type);
320: PO_LOG.stmt(d_module,d_pos,'x_message',x_message);
321: END IF;
322: COMMIT;

Line 319: PO_LOG.stmt(d_module,d_pos,'x_message_type',x_message_type);

315: RETURNING MESSAGE_TYPE, TEXT_LINE
316: INTO x_message_type, x_message;
317: d_pos := 20;
318: IF PO_LOG.d_stmt THEN
319: PO_LOG.stmt(d_module,d_pos,'x_message_type',x_message_type);
320: PO_LOG.stmt(d_module,d_pos,'x_message',x_message);
321: END IF;
322: COMMIT;
323: d_pos := 30;

Line 320: PO_LOG.stmt(d_module,d_pos,'x_message',x_message);

316: INTO x_message_type, x_message;
317: d_pos := 20;
318: IF PO_LOG.d_stmt THEN
319: PO_LOG.stmt(d_module,d_pos,'x_message_type',x_message_type);
320: PO_LOG.stmt(d_module,d_pos,'x_message',x_message);
321: END IF;
322: COMMIT;
323: d_pos := 30;
324: IF PO_LOG.d_event THEN

Line 324: IF PO_LOG.d_event THEN

320: PO_LOG.stmt(d_module,d_pos,'x_message',x_message);
321: END IF;
322: COMMIT;
323: d_pos := 30;
324: IF PO_LOG.d_event THEN
325: PO_LOG.event(d_module,d_pos,'Committed after Deleting Record from PO_Online_Report_Text');
326: END IF;
327: IF PO_LOG.d_proc THEN
328: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);

Line 325: PO_LOG.event(d_module,d_pos,'Committed after Deleting Record from PO_Online_Report_Text');

321: END IF;
322: COMMIT;
323: d_pos := 30;
324: IF PO_LOG.d_event THEN
325: PO_LOG.event(d_module,d_pos,'Committed after Deleting Record from PO_Online_Report_Text');
326: END IF;
327: IF PO_LOG.d_proc THEN
328: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);
329: PO_LOG.proc_end(d_module,'x_message',x_message);

Line 327: IF PO_LOG.d_proc THEN

323: d_pos := 30;
324: IF PO_LOG.d_event THEN
325: PO_LOG.event(d_module,d_pos,'Committed after Deleting Record from PO_Online_Report_Text');
326: END IF;
327: IF PO_LOG.d_proc THEN
328: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);
329: PO_LOG.proc_end(d_module,'x_message',x_message);
330: PO_LOG.proc_end(d_module);
331: END IF;

Line 328: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);

324: IF PO_LOG.d_event THEN
325: PO_LOG.event(d_module,d_pos,'Committed after Deleting Record from PO_Online_Report_Text');
326: END IF;
327: IF PO_LOG.d_proc THEN
328: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);
329: PO_LOG.proc_end(d_module,'x_message',x_message);
330: PO_LOG.proc_end(d_module);
331: END IF;
332: EXCEPTION

Line 329: PO_LOG.proc_end(d_module,'x_message',x_message);

325: PO_LOG.event(d_module,d_pos,'Committed after Deleting Record from PO_Online_Report_Text');
326: END IF;
327: IF PO_LOG.d_proc THEN
328: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);
329: PO_LOG.proc_end(d_module,'x_message',x_message);
330: PO_LOG.proc_end(d_module);
331: END IF;
332: EXCEPTION
333: WHEN OTHERS THEN

Line 330: PO_LOG.proc_end(d_module);

326: END IF;
327: IF PO_LOG.d_proc THEN
328: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);
329: PO_LOG.proc_end(d_module,'x_message',x_message);
330: PO_LOG.proc_end(d_module);
331: END IF;
332: EXCEPTION
333: WHEN OTHERS THEN
334: d_log_msg := 'Unhandled Exception in ' || d_module;

Line 335: IF PO_LOG.d_exc THEN

331: END IF;
332: EXCEPTION
333: WHEN OTHERS THEN
334: d_log_msg := 'Unhandled Exception in ' || d_module;
335: IF PO_LOG.d_exc THEN
336: PO_LOG.exc(d_module,d_pos,d_log_msg);
337: END IF;
338: RAISE;
339: END ret_and_del_online_report_rec;

Line 336: PO_LOG.exc(d_module,d_pos,d_log_msg);

332: EXCEPTION
333: WHEN OTHERS THEN
334: d_log_msg := 'Unhandled Exception in ' || d_module;
335: IF PO_LOG.d_exc THEN
336: PO_LOG.exc(d_module,d_pos,d_log_msg);
337: END IF;
338: RAISE;
339: END ret_and_del_online_report_rec;
340: --

Line 2530: IF PO_LOG.d_proc THEN

2526:
2527: BEGIN
2528: l_progress := '010';
2529:
2530: IF PO_LOG.d_proc THEN
2531: PO_LOG.proc_begin(d_mod,'p_orig_po_line_id',p_orig_po_line_id);
2532: PO_LOG.proc_begin(d_mod,'p_new_po_line_id',p_new_po_line_id);
2533: PO_LOG.proc_begin(d_mod,'p_line_num',p_line_num);
2534: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);

Line 2531: PO_LOG.proc_begin(d_mod,'p_orig_po_line_id',p_orig_po_line_id);

2527: BEGIN
2528: l_progress := '010';
2529:
2530: IF PO_LOG.d_proc THEN
2531: PO_LOG.proc_begin(d_mod,'p_orig_po_line_id',p_orig_po_line_id);
2532: PO_LOG.proc_begin(d_mod,'p_new_po_line_id',p_new_po_line_id);
2533: PO_LOG.proc_begin(d_mod,'p_line_num',p_line_num);
2534: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);
2535: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);

Line 2532: PO_LOG.proc_begin(d_mod,'p_new_po_line_id',p_new_po_line_id);

2528: l_progress := '010';
2529:
2530: IF PO_LOG.d_proc THEN
2531: PO_LOG.proc_begin(d_mod,'p_orig_po_line_id',p_orig_po_line_id);
2532: PO_LOG.proc_begin(d_mod,'p_new_po_line_id',p_new_po_line_id);
2533: PO_LOG.proc_begin(d_mod,'p_line_num',p_line_num);
2534: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);
2535: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);
2536: END IF;

Line 2533: PO_LOG.proc_begin(d_mod,'p_line_num',p_line_num);

2529:
2530: IF PO_LOG.d_proc THEN
2531: PO_LOG.proc_begin(d_mod,'p_orig_po_line_id',p_orig_po_line_id);
2532: PO_LOG.proc_begin(d_mod,'p_new_po_line_id',p_new_po_line_id);
2533: PO_LOG.proc_begin(d_mod,'p_line_num',p_line_num);
2534: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);
2535: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);
2536: END IF;
2537:

Line 2534: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);

2530: IF PO_LOG.d_proc THEN
2531: PO_LOG.proc_begin(d_mod,'p_orig_po_line_id',p_orig_po_line_id);
2532: PO_LOG.proc_begin(d_mod,'p_new_po_line_id',p_new_po_line_id);
2533: PO_LOG.proc_begin(d_mod,'p_line_num',p_line_num);
2534: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);
2535: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);
2536: END IF;
2537:
2538: PO_ATTRIBUTE_VALUES_PVT.copy_attributes

Line 2535: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);

2531: PO_LOG.proc_begin(d_mod,'p_orig_po_line_id',p_orig_po_line_id);
2532: PO_LOG.proc_begin(d_mod,'p_new_po_line_id',p_new_po_line_id);
2533: PO_LOG.proc_begin(d_mod,'p_line_num',p_line_num);
2534: PO_LOG.proc_begin(d_mod,'p_online_report_id',p_online_report_id);
2535: PO_LOG.proc_begin(d_mod,'x_sequence',x_sequence);
2536: END IF;
2537:
2538: PO_ATTRIBUTE_VALUES_PVT.copy_attributes
2539: (

Line 2544: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

2540: p_orig_po_line_id => p_orig_po_line_id
2541: , p_new_po_line_id => p_new_po_line_id
2542: );
2543:
2544: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2545: EXCEPTION
2546: WHEN OTHERS THEN
2547: copydoc_sql_error(x_routine => d_mod,
2548: x_progress => l_progress,

Line 2555: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

2551: x_sequence => x_sequence,
2552: x_line_num => p_line_num,
2553: x_shipment_num => 0,
2554: x_distribution_num => 0);
2555: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
2556: RAISE;
2557: END copy_attributes;
2558: --
2559:

Line 3814: IF (PO_LOG.d_proc) THEN

3810: d_log_msg VARCHAR2(200);
3811: BEGIN
3812: --Initialise the variables
3813: d_pos := 0;
3814: IF (PO_LOG.d_proc) THEN
3815: PO_LOG.proc_begin(d_module);
3816: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
3817: PO_LOG.proc_begin(d_module, 'p_copy_attachment', p_copy_attachment);
3818: PO_LOG.proc_begin(d_module, 'p_copy_terms', p_copy_terms);

Line 3815: PO_LOG.proc_begin(d_module);

3811: BEGIN
3812: --Initialise the variables
3813: d_pos := 0;
3814: IF (PO_LOG.d_proc) THEN
3815: PO_LOG.proc_begin(d_module);
3816: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
3817: PO_LOG.proc_begin(d_module, 'p_copy_attachment', p_copy_attachment);
3818: PO_LOG.proc_begin(d_module, 'p_copy_terms', p_copy_terms);
3819: PO_LOG.proc_begin(d_module, 'x_new_segment1', x_new_segment1);

Line 3816: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);

3812: --Initialise the variables
3813: d_pos := 0;
3814: IF (PO_LOG.d_proc) THEN
3815: PO_LOG.proc_begin(d_module);
3816: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
3817: PO_LOG.proc_begin(d_module, 'p_copy_attachment', p_copy_attachment);
3818: PO_LOG.proc_begin(d_module, 'p_copy_terms', p_copy_terms);
3819: PO_LOG.proc_begin(d_module, 'x_new_segment1', x_new_segment1);
3820: END IF;

Line 3817: PO_LOG.proc_begin(d_module, 'p_copy_attachment', p_copy_attachment);

3813: d_pos := 0;
3814: IF (PO_LOG.d_proc) THEN
3815: PO_LOG.proc_begin(d_module);
3816: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
3817: PO_LOG.proc_begin(d_module, 'p_copy_attachment', p_copy_attachment);
3818: PO_LOG.proc_begin(d_module, 'p_copy_terms', p_copy_terms);
3819: PO_LOG.proc_begin(d_module, 'x_new_segment1', x_new_segment1);
3820: END IF;
3821: d_pos := 10;

Line 3818: PO_LOG.proc_begin(d_module, 'p_copy_terms', p_copy_terms);

3814: IF (PO_LOG.d_proc) THEN
3815: PO_LOG.proc_begin(d_module);
3816: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
3817: PO_LOG.proc_begin(d_module, 'p_copy_attachment', p_copy_attachment);
3818: PO_LOG.proc_begin(d_module, 'p_copy_terms', p_copy_terms);
3819: PO_LOG.proc_begin(d_module, 'x_new_segment1', x_new_segment1);
3820: END IF;
3821: d_pos := 10;
3822: x_return_status := FND_API.g_ret_sts_success;

Line 3819: PO_LOG.proc_begin(d_module, 'x_new_segment1', x_new_segment1);

3815: PO_LOG.proc_begin(d_module);
3816: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
3817: PO_LOG.proc_begin(d_module, 'p_copy_attachment', p_copy_attachment);
3818: PO_LOG.proc_begin(d_module, 'p_copy_terms', p_copy_terms);
3819: PO_LOG.proc_begin(d_module, 'x_new_segment1', x_new_segment1);
3820: END IF;
3821: d_pos := 10;
3822: x_return_status := FND_API.g_ret_sts_success;
3823: x_errmsg_code := NULL;

Line 3841: IF PO_LOG.d_stmt THEN

3837: FROM po_headers_all POH, financials_system_params_all FSP
3838: WHERE po_header_id = p_po_header_id
3839: AND poh.org_id = fsp.org_id;
3840:
3841: IF PO_LOG.d_stmt THEN
3842: PO_LOG.stmt(d_module,d_pos,'l_doc_org_id',l_doc_org_id);
3843: PO_LOG.stmt(d_module,d_pos,'l_type_lookup_code',l_type_lookup_code);
3844: PO_LOG.stmt(d_module,d_pos,'l_global_agreement_flag',l_global_agreement_flag);
3845: PO_LOG.stmt(d_module,d_pos,'l_inv_org_id',l_inv_org_id);

Line 3842: PO_LOG.stmt(d_module,d_pos,'l_doc_org_id',l_doc_org_id);

3838: WHERE po_header_id = p_po_header_id
3839: AND poh.org_id = fsp.org_id;
3840:
3841: IF PO_LOG.d_stmt THEN
3842: PO_LOG.stmt(d_module,d_pos,'l_doc_org_id',l_doc_org_id);
3843: PO_LOG.stmt(d_module,d_pos,'l_type_lookup_code',l_type_lookup_code);
3844: PO_LOG.stmt(d_module,d_pos,'l_global_agreement_flag',l_global_agreement_flag);
3845: PO_LOG.stmt(d_module,d_pos,'l_inv_org_id',l_inv_org_id);
3846: PO_LOG.stmt(d_module,d_pos,'l_sob_id',l_sob_id);

Line 3843: PO_LOG.stmt(d_module,d_pos,'l_type_lookup_code',l_type_lookup_code);

3839: AND poh.org_id = fsp.org_id;
3840:
3841: IF PO_LOG.d_stmt THEN
3842: PO_LOG.stmt(d_module,d_pos,'l_doc_org_id',l_doc_org_id);
3843: PO_LOG.stmt(d_module,d_pos,'l_type_lookup_code',l_type_lookup_code);
3844: PO_LOG.stmt(d_module,d_pos,'l_global_agreement_flag',l_global_agreement_flag);
3845: PO_LOG.stmt(d_module,d_pos,'l_inv_org_id',l_inv_org_id);
3846: PO_LOG.stmt(d_module,d_pos,'l_sob_id',l_sob_id);
3847: END IF;

Line 3844: PO_LOG.stmt(d_module,d_pos,'l_global_agreement_flag',l_global_agreement_flag);

3840:
3841: IF PO_LOG.d_stmt THEN
3842: PO_LOG.stmt(d_module,d_pos,'l_doc_org_id',l_doc_org_id);
3843: PO_LOG.stmt(d_module,d_pos,'l_type_lookup_code',l_type_lookup_code);
3844: PO_LOG.stmt(d_module,d_pos,'l_global_agreement_flag',l_global_agreement_flag);
3845: PO_LOG.stmt(d_module,d_pos,'l_inv_org_id',l_inv_org_id);
3846: PO_LOG.stmt(d_module,d_pos,'l_sob_id',l_sob_id);
3847: END IF;
3848:

Line 3845: PO_LOG.stmt(d_module,d_pos,'l_inv_org_id',l_inv_org_id);

3841: IF PO_LOG.d_stmt THEN
3842: PO_LOG.stmt(d_module,d_pos,'l_doc_org_id',l_doc_org_id);
3843: PO_LOG.stmt(d_module,d_pos,'l_type_lookup_code',l_type_lookup_code);
3844: PO_LOG.stmt(d_module,d_pos,'l_global_agreement_flag',l_global_agreement_flag);
3845: PO_LOG.stmt(d_module,d_pos,'l_inv_org_id',l_inv_org_id);
3846: PO_LOG.stmt(d_module,d_pos,'l_sob_id',l_sob_id);
3847: END IF;
3848:
3849: d_pos := 20;

Line 3846: PO_LOG.stmt(d_module,d_pos,'l_sob_id',l_sob_id);

3842: PO_LOG.stmt(d_module,d_pos,'l_doc_org_id',l_doc_org_id);
3843: PO_LOG.stmt(d_module,d_pos,'l_type_lookup_code',l_type_lookup_code);
3844: PO_LOG.stmt(d_module,d_pos,'l_global_agreement_flag',l_global_agreement_flag);
3845: PO_LOG.stmt(d_module,d_pos,'l_inv_org_id',l_inv_org_id);
3846: PO_LOG.stmt(d_module,d_pos,'l_sob_id',l_sob_id);
3847: END IF;
3848:
3849: d_pos := 20;
3850: --Check if the PO Number Provided by the user is unique

Line 3857: IF PO_LOG.d_exc THEN

3853: IF(NOT PO_CORE_S.Check_Doc_Number_Unique(x_new_segment1,
3854: l_doc_org_id,
3855: l_type_lookup_code)) THEN
3856: x_errmsg_code := 'PO_ALL_ENTER_UNIQUE_VAL';
3857: IF PO_LOG.d_exc THEN
3858: PO_LOG.exc(d_module,d_pos,'Segment1 value not unique');
3859: END IF;
3860: RAISE FND_API.g_exc_error;
3861: END IF;

Line 3858: PO_LOG.exc(d_module,d_pos,'Segment1 value not unique');

3854: l_doc_org_id,
3855: l_type_lookup_code)) THEN
3856: x_errmsg_code := 'PO_ALL_ENTER_UNIQUE_VAL';
3857: IF PO_LOG.d_exc THEN
3858: PO_LOG.exc(d_module,d_pos,'Segment1 value not unique');
3859: END IF;
3860: RAISE FND_API.g_exc_error;
3861: END IF;
3862: END IF;

Line 3868: IF PO_LOG.d_exc THEN

3864: --Check if the PO is a drop ship PO
3865: IF(PO_COPYDOC_S1.po_is_dropship(p_po_header_id)) THEN
3866: d_pos := 35;
3867: x_errmsg_code := 'PO_NOT_SUPPORT_COPY_DROPSHIPPO';
3868: IF PO_LOG.d_exc THEN
3869: PO_LOG.exc(d_module,d_pos,'Duplicate Document not supported for DropShip PO');
3870: END IF;
3871: RAISE FND_API.g_exc_error;
3872: END IF;

Line 3869: PO_LOG.exc(d_module,d_pos,'Duplicate Document not supported for DropShip PO');

3865: IF(PO_COPYDOC_S1.po_is_dropship(p_po_header_id)) THEN
3866: d_pos := 35;
3867: x_errmsg_code := 'PO_NOT_SUPPORT_COPY_DROPSHIPPO';
3868: IF PO_LOG.d_exc THEN
3869: PO_LOG.exc(d_module,d_pos,'Duplicate Document not supported for DropShip PO');
3870: END IF;
3871: RAISE FND_API.g_exc_error;
3872: END IF;
3873: d_pos := 40;

Line 3878: IF PO_LOG.d_exc THEN

3874: --Check if the PO has a config id associated with it
3875: IF(PO_COPYDOC_S1.po_has_config_id(p_po_header_id)) THEN
3876: d_pos := 45;
3877: x_errmsg_code := 'PO_CANNOT_COPY_CONFIG_ID_DOC';
3878: IF PO_LOG.d_exc THEN
3879: PO_LOG.exc(d_module,d_pos,'Duplicate Document not supported for PO with Config ID');
3880: END IF;
3881: RAISE FND_API.g_exc_error;
3882: END IF;

Line 3879: PO_LOG.exc(d_module,d_pos,'Duplicate Document not supported for PO with Config ID');

3875: IF(PO_COPYDOC_S1.po_has_config_id(p_po_header_id)) THEN
3876: d_pos := 45;
3877: x_errmsg_code := 'PO_CANNOT_COPY_CONFIG_ID_DOC';
3878: IF PO_LOG.d_exc THEN
3879: PO_LOG.exc(d_module,d_pos,'Duplicate Document not supported for PO with Config ID');
3880: END IF;
3881: RAISE FND_API.g_exc_error;
3882: END IF;
3883: d_pos := 50;

Line 3885: IF PO_LOG.d_event THEN

3881: RAISE FND_API.g_exc_error;
3882: END IF;
3883: d_pos := 50;
3884: --If validations go thru fine invoke the copy_document procedure
3885: IF PO_LOG.d_event THEN
3886: PO_LOG.event(d_module,d_pos,'Invoking PO_COPYDOC_S1.Copy Document Procedure');
3887: END IF;
3888:
3889: copy_document (

Line 3886: PO_LOG.event(d_module,d_pos,'Invoking PO_COPYDOC_S1.Copy Document Procedure');

3882: END IF;
3883: d_pos := 50;
3884: --If validations go thru fine invoke the copy_document procedure
3885: IF PO_LOG.d_event THEN
3886: PO_LOG.event(d_module,d_pos,'Invoking PO_COPYDOC_S1.Copy Document Procedure');
3887: END IF;
3888:
3889: copy_document (
3890: x_action_code => 'PO',

Line 3907: IF PO_LOG.d_event THEN

3903: x_return_code => l_return_code,
3904: x_copy_terms => p_copy_terms,
3905: p_api_commit => FALSE); --Do not Commit
3906:
3907: IF PO_LOG.d_event THEN
3908: PO_LOG.event(d_module,d_pos,'PO_COPYDOC_S1.Copy Document Procedure call completed');
3909: END IF;
3910: d_pos := 60;
3911: --If online_report_id is not null get the message

Line 3908: PO_LOG.event(d_module,d_pos,'PO_COPYDOC_S1.Copy Document Procedure call completed');

3904: x_copy_terms => p_copy_terms,
3905: p_api_commit => FALSE); --Do not Commit
3906:
3907: IF PO_LOG.d_event THEN
3908: PO_LOG.event(d_module,d_pos,'PO_COPYDOC_S1.Copy Document Procedure call completed');
3909: END IF;
3910: d_pos := 60;
3911: --If online_report_id is not null get the message
3912: IF (l_online_report_id is NOT NULL) THEN

Line 3917: IF PO_LOG.d_stmt THEN

3913: d_pos := 65;
3914: PO_COPYDOC_S1.ret_and_del_online_report_rec( l_online_report_id
3915: ,x_message_type
3916: ,x_text_line);
3917: IF PO_LOG.d_stmt THEN
3918: PO_LOG.stmt(d_module,d_pos,'l_online_report_id',l_online_report_id);
3919: PO_LOG.stmt(d_module,d_pos,'x_message_type',x_message_type);
3920: PO_LOG.stmt(d_module,d_pos,'x_text_line',x_text_line);
3921: END IF;

Line 3918: PO_LOG.stmt(d_module,d_pos,'l_online_report_id',l_online_report_id);

3914: PO_COPYDOC_S1.ret_and_del_online_report_rec( l_online_report_id
3915: ,x_message_type
3916: ,x_text_line);
3917: IF PO_LOG.d_stmt THEN
3918: PO_LOG.stmt(d_module,d_pos,'l_online_report_id',l_online_report_id);
3919: PO_LOG.stmt(d_module,d_pos,'x_message_type',x_message_type);
3920: PO_LOG.stmt(d_module,d_pos,'x_text_line',x_text_line);
3921: END IF;
3922: END IF;

Line 3919: PO_LOG.stmt(d_module,d_pos,'x_message_type',x_message_type);

3915: ,x_message_type
3916: ,x_text_line);
3917: IF PO_LOG.d_stmt THEN
3918: PO_LOG.stmt(d_module,d_pos,'l_online_report_id',l_online_report_id);
3919: PO_LOG.stmt(d_module,d_pos,'x_message_type',x_message_type);
3920: PO_LOG.stmt(d_module,d_pos,'x_text_line',x_text_line);
3921: END IF;
3922: END IF;
3923: d_pos := 70;

Line 3920: PO_LOG.stmt(d_module,d_pos,'x_text_line',x_text_line);

3916: ,x_text_line);
3917: IF PO_LOG.d_stmt THEN
3918: PO_LOG.stmt(d_module,d_pos,'l_online_report_id',l_online_report_id);
3919: PO_LOG.stmt(d_module,d_pos,'x_message_type',x_message_type);
3920: PO_LOG.stmt(d_module,d_pos,'x_text_line',x_text_line);
3921: END IF;
3922: END IF;
3923: d_pos := 70;
3924: IF(l_return_code < 0) THEN

Line 3929: IF PO_LOG.d_proc THEN

3925: d_pos := 75;
3926: RAISE FND_API.g_exc_unexpected_error;
3927: END IF;
3928:
3929: IF PO_LOG.d_proc THEN
3930: PO_LOG.proc_end(d_module,'x_new_segment1',x_new_segment1);
3931: PO_LOG.proc_end(d_module,'x_new_po_header_id',x_new_po_header_id);
3932: PO_LOG.proc_end(d_module,'x_errmsg_code',x_errmsg_code);
3933: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);

Line 3930: PO_LOG.proc_end(d_module,'x_new_segment1',x_new_segment1);

3926: RAISE FND_API.g_exc_unexpected_error;
3927: END IF;
3928:
3929: IF PO_LOG.d_proc THEN
3930: PO_LOG.proc_end(d_module,'x_new_segment1',x_new_segment1);
3931: PO_LOG.proc_end(d_module,'x_new_po_header_id',x_new_po_header_id);
3932: PO_LOG.proc_end(d_module,'x_errmsg_code',x_errmsg_code);
3933: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);
3934: PO_LOG.proc_end(d_module,'x_text_line',x_text_line);

Line 3931: PO_LOG.proc_end(d_module,'x_new_po_header_id',x_new_po_header_id);

3927: END IF;
3928:
3929: IF PO_LOG.d_proc THEN
3930: PO_LOG.proc_end(d_module,'x_new_segment1',x_new_segment1);
3931: PO_LOG.proc_end(d_module,'x_new_po_header_id',x_new_po_header_id);
3932: PO_LOG.proc_end(d_module,'x_errmsg_code',x_errmsg_code);
3933: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);
3934: PO_LOG.proc_end(d_module,'x_text_line',x_text_line);
3935: PO_LOG.proc_end(d_module,'x_return_status',x_return_status);

Line 3932: PO_LOG.proc_end(d_module,'x_errmsg_code',x_errmsg_code);

3928:
3929: IF PO_LOG.d_proc THEN
3930: PO_LOG.proc_end(d_module,'x_new_segment1',x_new_segment1);
3931: PO_LOG.proc_end(d_module,'x_new_po_header_id',x_new_po_header_id);
3932: PO_LOG.proc_end(d_module,'x_errmsg_code',x_errmsg_code);
3933: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);
3934: PO_LOG.proc_end(d_module,'x_text_line',x_text_line);
3935: PO_LOG.proc_end(d_module,'x_return_status',x_return_status);
3936: PO_LOG.proc_end(d_module,'x_exception_msg',x_exception_msg);

Line 3933: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);

3929: IF PO_LOG.d_proc THEN
3930: PO_LOG.proc_end(d_module,'x_new_segment1',x_new_segment1);
3931: PO_LOG.proc_end(d_module,'x_new_po_header_id',x_new_po_header_id);
3932: PO_LOG.proc_end(d_module,'x_errmsg_code',x_errmsg_code);
3933: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);
3934: PO_LOG.proc_end(d_module,'x_text_line',x_text_line);
3935: PO_LOG.proc_end(d_module,'x_return_status',x_return_status);
3936: PO_LOG.proc_end(d_module,'x_exception_msg',x_exception_msg);
3937: PO_LOG.proc_end(d_module);

Line 3934: PO_LOG.proc_end(d_module,'x_text_line',x_text_line);

3930: PO_LOG.proc_end(d_module,'x_new_segment1',x_new_segment1);
3931: PO_LOG.proc_end(d_module,'x_new_po_header_id',x_new_po_header_id);
3932: PO_LOG.proc_end(d_module,'x_errmsg_code',x_errmsg_code);
3933: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);
3934: PO_LOG.proc_end(d_module,'x_text_line',x_text_line);
3935: PO_LOG.proc_end(d_module,'x_return_status',x_return_status);
3936: PO_LOG.proc_end(d_module,'x_exception_msg',x_exception_msg);
3937: PO_LOG.proc_end(d_module);
3938: END IF;

Line 3935: PO_LOG.proc_end(d_module,'x_return_status',x_return_status);

3931: PO_LOG.proc_end(d_module,'x_new_po_header_id',x_new_po_header_id);
3932: PO_LOG.proc_end(d_module,'x_errmsg_code',x_errmsg_code);
3933: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);
3934: PO_LOG.proc_end(d_module,'x_text_line',x_text_line);
3935: PO_LOG.proc_end(d_module,'x_return_status',x_return_status);
3936: PO_LOG.proc_end(d_module,'x_exception_msg',x_exception_msg);
3937: PO_LOG.proc_end(d_module);
3938: END IF;
3939: EXCEPTION

Line 3936: PO_LOG.proc_end(d_module,'x_exception_msg',x_exception_msg);

3932: PO_LOG.proc_end(d_module,'x_errmsg_code',x_errmsg_code);
3933: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);
3934: PO_LOG.proc_end(d_module,'x_text_line',x_text_line);
3935: PO_LOG.proc_end(d_module,'x_return_status',x_return_status);
3936: PO_LOG.proc_end(d_module,'x_exception_msg',x_exception_msg);
3937: PO_LOG.proc_end(d_module);
3938: END IF;
3939: EXCEPTION
3940: WHEN FND_API.g_exc_error THEN

Line 3937: PO_LOG.proc_end(d_module);

3933: PO_LOG.proc_end(d_module,'x_message_type',x_message_type);
3934: PO_LOG.proc_end(d_module,'x_text_line',x_text_line);
3935: PO_LOG.proc_end(d_module,'x_return_status',x_return_status);
3936: PO_LOG.proc_end(d_module,'x_exception_msg',x_exception_msg);
3937: PO_LOG.proc_end(d_module);
3938: END IF;
3939: EXCEPTION
3940: WHEN FND_API.g_exc_error THEN
3941: x_return_status := FND_API.g_ret_sts_error;

Line 3949: IF PO_LOG.d_exc THEN

3945: x_exception_msg := x_text_line;
3946: ELSE
3947: x_exception_msg := 'Unexpected Error in ' || d_module||'-'||d_pos;
3948: END IF;
3949: IF PO_LOG.d_exc THEN
3950: PO_LOG.exc(d_module,d_pos,x_exception_msg);
3951: END IF;
3952: WHEN OTHERS THEN
3953: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 3950: PO_LOG.exc(d_module,d_pos,x_exception_msg);

3946: ELSE
3947: x_exception_msg := 'Unexpected Error in ' || d_module||'-'||d_pos;
3948: END IF;
3949: IF PO_LOG.d_exc THEN
3950: PO_LOG.exc(d_module,d_pos,x_exception_msg);
3951: END IF;
3952: WHEN OTHERS THEN
3953: x_return_status := FND_API.g_ret_sts_unexp_error;
3954: IF (l_online_report_id is NOT NULL) THEN

Line 3964: IF PO_LOG.d_exc THEN

3960: x_exception_msg := x_text_line;
3961: ELSE
3962: x_exception_msg := 'Unhandled Exception in ' || d_module||'-'||d_pos;
3963: END IF;
3964: IF PO_LOG.d_exc THEN
3965: PO_LOG.exc(d_module,d_pos,x_exception_msg);
3966: END IF;
3967: END val_params_and_duplicate_doc;
3968: --

Line 3965: PO_LOG.exc(d_module,d_pos,x_exception_msg);

3961: ELSE
3962: x_exception_msg := 'Unhandled Exception in ' || d_module||'-'||d_pos;
3963: END IF;
3964: IF PO_LOG.d_exc THEN
3965: PO_LOG.exc(d_module,d_pos,x_exception_msg);
3966: END IF;
3967: END val_params_and_duplicate_doc;
3968: --
3969: END po_copydoc_s1;