eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_HEADERS_SV1 dependencies on PO_LOG

Line 220: IF (PO_LOG.d_proc) THEN

216: d_pos NUMBER := 10;
217: l_api_name CONSTANT VARCHAR2(30) := 'delete_children';
218: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.delete_children';
219: BEGIN
220: IF (PO_LOG.d_proc) THEN
221: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'X_type_lookup_code', X_type_lookup_code);
222: PO_LOG.proc_begin(d_module,'X_po_header_id', X_po_header_id);
223: END IF;
224:

Line 221: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'X_type_lookup_code', X_type_lookup_code);

217: l_api_name CONSTANT VARCHAR2(30) := 'delete_children';
218: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.delete_children';
219: BEGIN
220: IF (PO_LOG.d_proc) THEN
221: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'X_type_lookup_code', X_type_lookup_code);
222: PO_LOG.proc_begin(d_module,'X_po_header_id', X_po_header_id);
223: END IF;
224:
225: -- Bug: 13948625 - Start

Line 222: PO_LOG.proc_begin(d_module,'X_po_header_id', X_po_header_id);

218: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.delete_children';
219: BEGIN
220: IF (PO_LOG.d_proc) THEN
221: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'X_type_lookup_code', X_type_lookup_code);
222: PO_LOG.proc_begin(d_module,'X_po_header_id', X_po_header_id);
223: END IF;
224:
225: -- Bug: 13948625 - Start
226: -- Re-written the logic to send the requisitions back to pool when CLM document or its lines/distributions deleted.

Line 251: IF (PO_LOG.d_stmt) THEN

247: FROM po_distributions_all
248: WHERE po_header_id = X_po_header_id;
249:
250:
251: IF (PO_LOG.d_stmt) THEN
252: PO_LOG.stmt(d_module,d_pos,'l_deleted_line_list',l_deleted_line_list);
253: PO_LOG.stmt(d_module,d_pos,'l_deleted_dist_list',l_deleted_dist_list);
254: END IF;
255:

Line 252: PO_LOG.stmt(d_module,d_pos,'l_deleted_line_list',l_deleted_line_list);

248: WHERE po_header_id = X_po_header_id;
249:
250:
251: IF (PO_LOG.d_stmt) THEN
252: PO_LOG.stmt(d_module,d_pos,'l_deleted_line_list',l_deleted_line_list);
253: PO_LOG.stmt(d_module,d_pos,'l_deleted_dist_list',l_deleted_dist_list);
254: END IF;
255:
256: -- Call update_req_for_linked_po_count, where the linked_po_count is updated for unlinked requisitions

Line 253: PO_LOG.stmt(d_module,d_pos,'l_deleted_dist_list',l_deleted_dist_list);

249:
250:
251: IF (PO_LOG.d_stmt) THEN
252: PO_LOG.stmt(d_module,d_pos,'l_deleted_line_list',l_deleted_line_list);
253: PO_LOG.stmt(d_module,d_pos,'l_deleted_dist_list',l_deleted_dist_list);
254: END IF;
255:
256: -- Call update_req_for_linked_po_count, where the linked_po_count is updated for unlinked requisitions
257: -- and those reqs CLINs(Autocreated/SoftLinked) and PSlins(Softlinked) inserted into GT table for

Line 594: IF (PO_LOG.d_proc) THEN

590: d_pos NUMBER := 10;
591: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_document';
592: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.validate_delete_document';
593: BEGIN
594: IF (PO_LOG.d_proc) THEN
595: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module,'p_doc_header_id', p_doc_header_id); PO_LOG.proc_begin(d_module,'p_doc_approved_date', p_doc_approved_date);
596: PO_LOG.proc_begin(d_module,'p_auth_status', p_auth_status); PO_LOG.proc_begin(d_module,'p_style_disp_name', p_style_disp_name);
597: END IF;
598:

Line 595: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module,'p_doc_header_id', p_doc_header_id); PO_LOG.proc_begin(d_module,'p_doc_approved_date', p_doc_approved_date);

591: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_document';
592: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.validate_delete_document';
593: BEGIN
594: IF (PO_LOG.d_proc) THEN
595: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module,'p_doc_header_id', p_doc_header_id); PO_LOG.proc_begin(d_module,'p_doc_approved_date', p_doc_approved_date);
596: PO_LOG.proc_begin(d_module,'p_auth_status', p_auth_status); PO_LOG.proc_begin(d_module,'p_style_disp_name', p_style_disp_name);
597: END IF;
598:
599: IF p_doc_approved_date IS NOT NULL THEN

Line 596: PO_LOG.proc_begin(d_module,'p_auth_status', p_auth_status); PO_LOG.proc_begin(d_module,'p_style_disp_name', p_style_disp_name);

592: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.validate_delete_document';
593: BEGIN
594: IF (PO_LOG.d_proc) THEN
595: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module,'p_doc_header_id', p_doc_header_id); PO_LOG.proc_begin(d_module,'p_doc_approved_date', p_doc_approved_date);
596: PO_LOG.proc_begin(d_module,'p_auth_status', p_auth_status); PO_LOG.proc_begin(d_module,'p_style_disp_name', p_style_disp_name);
597: END IF;
598:
599: IF p_doc_approved_date IS NOT NULL THEN
600: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_APRVD_PO3'

Line 615: IF (PO_LOG.d_stmt) THEN

611: p_doc_level_id => p_doc_header_id,
612: x_some_dists_reserved_flag => l_some_dists_reserved_flag);
613: d_pos:= 30;
614:
615: IF (PO_LOG.d_stmt) THEN
616: PO_LOG.stmt(d_module,d_pos,'l_some_dists_reserved_flag',l_some_dists_reserved_flag);
617: END IF;
618:
619: IF l_some_dists_reserved_flag = 'Y'

Line 616: PO_LOG.stmt(d_module,d_pos,'l_some_dists_reserved_flag',l_some_dists_reserved_flag);

612: x_some_dists_reserved_flag => l_some_dists_reserved_flag);
613: d_pos:= 30;
614:
615: IF (PO_LOG.d_stmt) THEN
616: PO_LOG.stmt(d_module,d_pos,'l_some_dists_reserved_flag',l_some_dists_reserved_flag);
617: END IF;
618:
619: IF l_some_dists_reserved_flag = 'Y'
620: THEN

Line 625: IF (PO_LOG.d_proc) THEN

621: x_message_text := PO_CORE_S.get_translated_text('PO_PO_USE_CANCEL_ON_ENCUMB_PO');
622: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
623: END IF;
624:
625: IF (PO_LOG.d_proc) THEN
626: PO_LOG.proc_end(d_module);
627: END IF;
628:
629: EXCEPTION

Line 626: PO_LOG.proc_end(d_module);

622: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;
623: END IF;
624:
625: IF (PO_LOG.d_proc) THEN
626: PO_LOG.proc_end(d_module);
627: END IF;
628:
629: EXCEPTION
630: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN

Line 631: IF (PO_LOG.d_stmt) THEN

627: END IF;
628:
629: EXCEPTION
630: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN
631: IF (PO_LOG.d_stmt) THEN
632: PO_LOG.stmt(d_module,d_pos,'x_message_text',x_message_text);
633: END IF;
634: WHEN OTHERS THEN
635: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);

Line 632: PO_LOG.stmt(d_module,d_pos,'x_message_text',x_message_text);

628:
629: EXCEPTION
630: WHEN PO_CORE_S.G_EARLY_RETURN_EXC THEN
631: IF (PO_LOG.d_stmt) THEN
632: PO_LOG.stmt(d_module,d_pos,'x_message_text',x_message_text);
633: END IF;
634: WHEN OTHERS THEN
635: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
636: IF PO_LOG.d_exc THEN

Line 636: IF PO_LOG.d_exc THEN

632: PO_LOG.stmt(d_module,d_pos,'x_message_text',x_message_text);
633: END IF;
634: WHEN OTHERS THEN
635: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
636: IF PO_LOG.d_exc THEN
637: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
638: END IF;
639: RAISE;
640: END validate_delete_document;

Line 637: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);

633: END IF;
634: WHEN OTHERS THEN
635: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
636: IF PO_LOG.d_exc THEN
637: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
638: END IF;
639: RAISE;
640: END validate_delete_document;
641:

Line 689: IF (PO_LOG.d_proc) THEN

685: l_api_name CONSTANT VARCHAR2(30) := 'delete_document';
686: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.delete_document';
687:
688: BEGIN
689: IF (PO_LOG.d_proc) THEN
690: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module,'p_doc_header_id', p_doc_header_id); PO_LOG.proc_begin(d_module,'p_ga_flag', p_ga_flag);
691: PO_LOG.proc_begin(d_module,'p_conterms_exist_flag', p_conterms_exist_flag);
692: END IF;
693: d_pos := 10;

Line 690: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module,'p_doc_header_id', p_doc_header_id); PO_LOG.proc_begin(d_module,'p_ga_flag', p_ga_flag);

686: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.delete_document';
687:
688: BEGIN
689: IF (PO_LOG.d_proc) THEN
690: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module,'p_doc_header_id', p_doc_header_id); PO_LOG.proc_begin(d_module,'p_ga_flag', p_ga_flag);
691: PO_LOG.proc_begin(d_module,'p_conterms_exist_flag', p_conterms_exist_flag);
692: END IF;
693: d_pos := 10;
694: -- By default return status is SUCCESS if no exception occurs

Line 691: PO_LOG.proc_begin(d_module,'p_conterms_exist_flag', p_conterms_exist_flag);

687:
688: BEGIN
689: IF (PO_LOG.d_proc) THEN
690: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module,'p_doc_header_id', p_doc_header_id); PO_LOG.proc_begin(d_module,'p_ga_flag', p_ga_flag);
691: PO_LOG.proc_begin(d_module,'p_conterms_exist_flag', p_conterms_exist_flag);
692: END IF;
693: d_pos := 10;
694: -- By default return status is SUCCESS if no exception occurs
695: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 726: IF (PO_LOG.d_stmt) THEN

722: x_msg_data => l_msg_data,
723: x_msg_count => l_msg_count);
724:
725: d_pos := 60;
726: IF (PO_LOG.d_stmt) THEN
727: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status); PO_LOG.stmt(d_module,d_pos,'l_msg_count',l_msg_count); PO_LOG.stmt(d_module,d_pos,'l_msg_data',l_msg_data);
728: END IF;
729:
730: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 727: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status); PO_LOG.stmt(d_module,d_pos,'l_msg_count',l_msg_count); PO_LOG.stmt(d_module,d_pos,'l_msg_data',l_msg_data);

723: x_msg_count => l_msg_count);
724:
725: d_pos := 60;
726: IF (PO_LOG.d_stmt) THEN
727: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status); PO_LOG.stmt(d_module,d_pos,'l_msg_count',l_msg_count); PO_LOG.stmt(d_module,d_pos,'l_msg_data',l_msg_data);
728: END IF;
729:
730: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
731: d_pos := 70;

Line 749: IF (PO_LOG.d_proc) THEN

745: d_pos := 80;
746: RAISE FND_API.g_exc_error;
747: END IF;--PO_HEADERS_SV1.delete_po
748:
749: IF (PO_LOG.d_proc) THEN
750: PO_LOG.proc_end(d_module);
751: END IF;
752:
753: EXCEPTION

Line 750: PO_LOG.proc_end(d_module);

746: RAISE FND_API.g_exc_error;
747: END IF;--PO_HEADERS_SV1.delete_po
748:
749: IF (PO_LOG.d_proc) THEN
750: PO_LOG.proc_end(d_module);
751: END IF;
752:
753: EXCEPTION
754: WHEN FND_API.g_exc_error THEN

Line 758: IF PO_LOG.d_exc THEN

754: WHEN FND_API.g_exc_error THEN
755: x_return_status := FND_API.g_ret_sts_error;
756: WHEN OTHERS THEN
757: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
758: IF PO_LOG.d_exc THEN
759: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
760: END IF;
761: RAISE;
762: END;

Line 759: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);

755: x_return_status := FND_API.g_ret_sts_error;
756: WHEN OTHERS THEN
757: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||':'||d_pos);
758: IF PO_LOG.d_exc THEN
759: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
760: END IF;
761: RAISE;
762: END;
763: