DBA Data[Home] [Help]

APPS.PO_MOAC_UTILS_PVT dependencies on PO_LOG

Line 10: D_PACKAGE_BASE CONSTANT VARCHAR2(100) := PO_LOG.get_package_base(g_pkg_name);

6: -----------------------------------------------------------------------------
7: g_pkg_name CONSTANT VARCHAR2(30)
8: := 'PO_MOAC_UTILS_PVT';
9:
10: D_PACKAGE_BASE CONSTANT VARCHAR2(100) := PO_LOG.get_package_base(g_pkg_name);
11:
12:
13: -------------------------------------------------------------------------------
14: --Start of Comments

Line 702: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, l_module_name);

698: IS
699: l_org_id HR_ALL_ORGANIZATION_UNITS.organization_id%type := NULL;
700: l_module_name CONSTANT VARCHAR2(100) := 'get_entity_org_id';
701: d_module_base CONSTANT VARCHAR2(100) :=
702: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, l_module_name);
703: d_progress NUMBER := 0;
704: BEGIN
705:
706: IF (PO_LOG.d_proc) THEN

Line 706: IF (PO_LOG.d_proc) THEN

702: PO_LOG.get_subprogram_base(D_PACKAGE_BASE, l_module_name);
703: d_progress NUMBER := 0;
704: BEGIN
705:
706: IF (PO_LOG.d_proc) THEN
707: PO_LOG.proc_begin(d_module_base);
708: PO_LOG.proc_begin(d_module_base, 'p_doc_type', p_doc_type);
709: PO_LOG.proc_begin(d_module_base, 'p_doc_level', p_doc_level);
710: PO_LOG.proc_begin(d_module_base, 'p_doc_level_id', p_doc_level_id);

Line 707: PO_LOG.proc_begin(d_module_base);

703: d_progress NUMBER := 0;
704: BEGIN
705:
706: IF (PO_LOG.d_proc) THEN
707: PO_LOG.proc_begin(d_module_base);
708: PO_LOG.proc_begin(d_module_base, 'p_doc_type', p_doc_type);
709: PO_LOG.proc_begin(d_module_base, 'p_doc_level', p_doc_level);
710: PO_LOG.proc_begin(d_module_base, 'p_doc_level_id', p_doc_level_id);
711: END IF;

Line 708: PO_LOG.proc_begin(d_module_base, 'p_doc_type', p_doc_type);

704: BEGIN
705:
706: IF (PO_LOG.d_proc) THEN
707: PO_LOG.proc_begin(d_module_base);
708: PO_LOG.proc_begin(d_module_base, 'p_doc_type', p_doc_type);
709: PO_LOG.proc_begin(d_module_base, 'p_doc_level', p_doc_level);
710: PO_LOG.proc_begin(d_module_base, 'p_doc_level_id', p_doc_level_id);
711: END IF;
712:

Line 709: PO_LOG.proc_begin(d_module_base, 'p_doc_level', p_doc_level);

705:
706: IF (PO_LOG.d_proc) THEN
707: PO_LOG.proc_begin(d_module_base);
708: PO_LOG.proc_begin(d_module_base, 'p_doc_type', p_doc_type);
709: PO_LOG.proc_begin(d_module_base, 'p_doc_level', p_doc_level);
710: PO_LOG.proc_begin(d_module_base, 'p_doc_level_id', p_doc_level_id);
711: END IF;
712:
713: IF p_doc_type = g_doc_type_REQUISITION THEN

Line 710: PO_LOG.proc_begin(d_module_base, 'p_doc_level_id', p_doc_level_id);

706: IF (PO_LOG.d_proc) THEN
707: PO_LOG.proc_begin(d_module_base);
708: PO_LOG.proc_begin(d_module_base, 'p_doc_type', p_doc_type);
709: PO_LOG.proc_begin(d_module_base, 'p_doc_level', p_doc_level);
710: PO_LOG.proc_begin(d_module_base, 'p_doc_level_id', p_doc_level_id);
711: END IF;
712:
713: IF p_doc_type = g_doc_type_REQUISITION THEN
714: d_progress:=100;

Line 795: IF (PO_LOG.d_proc) THEN

791:
792: END IF; -- p_doc_type is Requisition or not
793:
794: d_progress := 300;
795: IF (PO_LOG.d_proc) THEN
796: PO_LOG.proc_return(d_module_base, l_org_id);
797: END IF;
798:
799: RETURN l_org_id;

Line 796: PO_LOG.proc_return(d_module_base, l_org_id);

792: END IF; -- p_doc_type is Requisition or not
793:
794: d_progress := 300;
795: IF (PO_LOG.d_proc) THEN
796: PO_LOG.proc_return(d_module_base, l_org_id);
797: END IF;
798:
799: RETURN l_org_id;
800:

Line 803: IF (PO_LOG.d_exc) THEN

799: RETURN l_org_id;
800:
801: EXCEPTION
802: WHEN OTHERS THEN
803: IF (PO_LOG.d_exc) THEN
804: PO_LOG.exc(d_module_base,d_progress,SQLERRM);
805: END IF;
806: RAISE;
807: END;

Line 804: PO_LOG.exc(d_module_base,d_progress,SQLERRM);

800:
801: EXCEPTION
802: WHEN OTHERS THEN
803: IF (PO_LOG.d_exc) THEN
804: PO_LOG.exc(d_module_base,d_progress,SQLERRM);
805: END IF;
806: RAISE;
807: END;
808: --

Line 834: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, l_module_name);

830: PROCEDURE validate_orgid_pub_api(x_org_id IN OUT NOCOPY NUMBER)
831: IS
832: l_status varchar2(1);
833: l_module_name CONSTANT VARCHAR2(100) := 'validate_orgid_pub_api';
834: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, l_module_name);
835: d_progress NUMBER := 0;
836: BEGIN
837:
838: IF (PO_LOG.d_proc) THEN

Line 838: IF (PO_LOG.d_proc) THEN

834: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE, l_module_name);
835: d_progress NUMBER := 0;
836: BEGIN
837:
838: IF (PO_LOG.d_proc) THEN
839: PO_LOG.proc_begin(d_module_base);
840: PO_LOG.proc_begin(d_module_base, 'x_org_id', x_org_id);
841: END IF;
842:

Line 839: PO_LOG.proc_begin(d_module_base);

835: d_progress NUMBER := 0;
836: BEGIN
837:
838: IF (PO_LOG.d_proc) THEN
839: PO_LOG.proc_begin(d_module_base);
840: PO_LOG.proc_begin(d_module_base, 'x_org_id', x_org_id);
841: END IF;
842:
843: MO_GLOBAL.validate_orgid_pub_api(org_id => x_org_id,

Line 840: PO_LOG.proc_begin(d_module_base, 'x_org_id', x_org_id);

836: BEGIN
837:
838: IF (PO_LOG.d_proc) THEN
839: PO_LOG.proc_begin(d_module_base);
840: PO_LOG.proc_begin(d_module_base, 'x_org_id', x_org_id);
841: END IF;
842:
843: MO_GLOBAL.validate_orgid_pub_api(org_id => x_org_id,
844: error_mesg_suppr => 'N',

Line 847: IF (PO_LOG.d_proc) THEN

843: MO_GLOBAL.validate_orgid_pub_api(org_id => x_org_id,
844: error_mesg_suppr => 'N',
845: status => l_status);
846:
847: IF (PO_LOG.d_proc) THEN
848: PO_LOG.proc_end(d_module_base, 'x_org_id', x_org_id);
849: PO_LOG.proc_end(d_module_base);
850: END IF;
851:

Line 848: PO_LOG.proc_end(d_module_base, 'x_org_id', x_org_id);

844: error_mesg_suppr => 'N',
845: status => l_status);
846:
847: IF (PO_LOG.d_proc) THEN
848: PO_LOG.proc_end(d_module_base, 'x_org_id', x_org_id);
849: PO_LOG.proc_end(d_module_base);
850: END IF;
851:
852: EXCEPTION

Line 849: PO_LOG.proc_end(d_module_base);

845: status => l_status);
846:
847: IF (PO_LOG.d_proc) THEN
848: PO_LOG.proc_end(d_module_base, 'x_org_id', x_org_id);
849: PO_LOG.proc_end(d_module_base);
850: END IF;
851:
852: EXCEPTION
853: WHEN OTHERS THEN

Line 854: IF (PO_LOG.d_exc) THEN

850: END IF;
851:
852: EXCEPTION
853: WHEN OTHERS THEN
854: IF (PO_LOG.d_exc) THEN
855: PO_LOG.exc(d_module_base,d_progress,SQLERRM);
856: END IF;
857: RAISE;
858: END validate_orgid_pub_api;

Line 855: PO_LOG.exc(d_module_base,d_progress,SQLERRM);

851:
852: EXCEPTION
853: WHEN OTHERS THEN
854: IF (PO_LOG.d_exc) THEN
855: PO_LOG.exc(d_module_base,d_progress,SQLERRM);
856: END IF;
857: RAISE;
858: END validate_orgid_pub_api;
859: --