DBA Data[Home] [Help]

APPS.PO_CONC_MODS_PVT dependencies on PO_LOG

Line 5: PO_LOG.get_package_base('PO_CONC_MODS_PVT');

1: PACKAGE BODY PO_CONC_MODS_PVT AS
2: /* $Header: PO_CONC_MODS_PVT.plb 120.2.12020000.4 2013/03/08 09:08:36 inagdeo ship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_CONC_MODS_PVT');
6: -------------------------------------------------------
7: -------------- PUBLIC PROCEDURES ----------------------
8: -------------------------------------------------------
9: -----------------------------------------------------------------------

Line 66: IF (PO_LOG.d_proc) THEN

62: l_view_par_url VARCHAR2(1000);
63:
64: BEGIN
65:
66: IF (PO_LOG.d_proc) THEN
67: PO_LOG.proc_begin(d_module);
68: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
69: PO_LOG.proc_begin(d_module, 'p_lock_by_draft_id ', p_lock_by_draft_id);
70: PO_LOG.proc_begin(d_module, 'p_requestor_id', p_requestor_id);

Line 67: PO_LOG.proc_begin(d_module);

63:
64: BEGIN
65:
66: IF (PO_LOG.d_proc) THEN
67: PO_LOG.proc_begin(d_module);
68: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
69: PO_LOG.proc_begin(d_module, 'p_lock_by_draft_id ', p_lock_by_draft_id);
70: PO_LOG.proc_begin(d_module, 'p_requestor_id', p_requestor_id);
71: PO_LOG.proc_begin(d_module, 'p_actioner_id', p_actioner_id);

Line 68: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

64: BEGIN
65:
66: IF (PO_LOG.d_proc) THEN
67: PO_LOG.proc_begin(d_module);
68: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
69: PO_LOG.proc_begin(d_module, 'p_lock_by_draft_id ', p_lock_by_draft_id);
70: PO_LOG.proc_begin(d_module, 'p_requestor_id', p_requestor_id);
71: PO_LOG.proc_begin(d_module, 'p_actioner_id', p_actioner_id);
72: PO_LOG.proc_begin(d_module, 'p_action_requested',

Line 69: PO_LOG.proc_begin(d_module, 'p_lock_by_draft_id ', p_lock_by_draft_id);

65:
66: IF (PO_LOG.d_proc) THEN
67: PO_LOG.proc_begin(d_module);
68: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
69: PO_LOG.proc_begin(d_module, 'p_lock_by_draft_id ', p_lock_by_draft_id);
70: PO_LOG.proc_begin(d_module, 'p_requestor_id', p_requestor_id);
71: PO_LOG.proc_begin(d_module, 'p_actioner_id', p_actioner_id);
72: PO_LOG.proc_begin(d_module, 'p_action_requested',
73: p_action_requested);

Line 70: PO_LOG.proc_begin(d_module, 'p_requestor_id', p_requestor_id);

66: IF (PO_LOG.d_proc) THEN
67: PO_LOG.proc_begin(d_module);
68: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
69: PO_LOG.proc_begin(d_module, 'p_lock_by_draft_id ', p_lock_by_draft_id);
70: PO_LOG.proc_begin(d_module, 'p_requestor_id', p_requestor_id);
71: PO_LOG.proc_begin(d_module, 'p_actioner_id', p_actioner_id);
72: PO_LOG.proc_begin(d_module, 'p_action_requested',
73: p_action_requested);
74: PO_LOG.proc_begin(d_module, 'p_action_req_details', p_action_req_details);

Line 71: PO_LOG.proc_begin(d_module, 'p_actioner_id', p_actioner_id);

67: PO_LOG.proc_begin(d_module);
68: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
69: PO_LOG.proc_begin(d_module, 'p_lock_by_draft_id ', p_lock_by_draft_id);
70: PO_LOG.proc_begin(d_module, 'p_requestor_id', p_requestor_id);
71: PO_LOG.proc_begin(d_module, 'p_actioner_id', p_actioner_id);
72: PO_LOG.proc_begin(d_module, 'p_action_requested',
73: p_action_requested);
74: PO_LOG.proc_begin(d_module, 'p_action_req_details', p_action_req_details);
75: END IF;

Line 72: PO_LOG.proc_begin(d_module, 'p_action_requested',

68: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
69: PO_LOG.proc_begin(d_module, 'p_lock_by_draft_id ', p_lock_by_draft_id);
70: PO_LOG.proc_begin(d_module, 'p_requestor_id', p_requestor_id);
71: PO_LOG.proc_begin(d_module, 'p_actioner_id', p_actioner_id);
72: PO_LOG.proc_begin(d_module, 'p_action_requested',
73: p_action_requested);
74: PO_LOG.proc_begin(d_module, 'p_action_req_details', p_action_req_details);
75: END IF;
76:

Line 74: PO_LOG.proc_begin(d_module, 'p_action_req_details', p_action_req_details);

70: PO_LOG.proc_begin(d_module, 'p_requestor_id', p_requestor_id);
71: PO_LOG.proc_begin(d_module, 'p_actioner_id', p_actioner_id);
72: PO_LOG.proc_begin(d_module, 'p_action_requested',
73: p_action_requested);
74: PO_LOG.proc_begin(d_module, 'p_action_req_details', p_action_req_details);
75: END IF;
76:
77: d_position := 10;
78:

Line 91: IF (PO_LOG.d_stmt) THEN

87: WHEN no_data_found THEN
88: RAISE;
89: END;
90:
91: IF (PO_LOG.d_stmt) THEN
92: PO_LOG.stmt(d_module, d_position, 'l_mod_number', l_mod_number);
93: PO_LOG.stmt(d_module, d_position, 'l_document_id', l_document_id);
94: END IF;
95:

Line 92: PO_LOG.stmt(d_module, d_position, 'l_mod_number', l_mod_number);

88: RAISE;
89: END;
90:
91: IF (PO_LOG.d_stmt) THEN
92: PO_LOG.stmt(d_module, d_position, 'l_mod_number', l_mod_number);
93: PO_LOG.stmt(d_module, d_position, 'l_document_id', l_document_id);
94: END IF;
95:
96: d_position := 20;

Line 93: PO_LOG.stmt(d_module, d_position, 'l_document_id', l_document_id);

89: END;
90:
91: IF (PO_LOG.d_stmt) THEN
92: PO_LOG.stmt(d_module, d_position, 'l_mod_number', l_mod_number);
93: PO_LOG.stmt(d_module, d_position, 'l_document_id', l_document_id);
94: END IF;
95:
96: d_position := 20;
97:

Line 132: IF (PO_LOG.d_stmt) THEN

128: --actioner user name
129: PO_REQAPPROVAL_INIT1.get_user_name
130: (p_actioner_id,l_actioner_user_name,l_actioner_display_name);
131:
132: IF (PO_LOG.d_stmt) THEN
133: PO_LOG.stmt(d_module, d_position,'l_requestor_user_name', l_requestor_user_name);
134: PO_LOG.stmt(d_module, d_position,'l_actioner_user_name', l_actioner_user_name);
135: END IF;
136:

Line 133: PO_LOG.stmt(d_module, d_position,'l_requestor_user_name', l_requestor_user_name);

129: PO_REQAPPROVAL_INIT1.get_user_name
130: (p_actioner_id,l_actioner_user_name,l_actioner_display_name);
131:
132: IF (PO_LOG.d_stmt) THEN
133: PO_LOG.stmt(d_module, d_position,'l_requestor_user_name', l_requestor_user_name);
134: PO_LOG.stmt(d_module, d_position,'l_actioner_user_name', l_actioner_user_name);
135: END IF;
136:
137: wf_engine.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname =>

Line 134: PO_LOG.stmt(d_module, d_position,'l_actioner_user_name', l_actioner_user_name);

130: (p_actioner_id,l_actioner_user_name,l_actioner_display_name);
131:
132: IF (PO_LOG.d_stmt) THEN
133: PO_LOG.stmt(d_module, d_position,'l_requestor_user_name', l_requestor_user_name);
134: PO_LOG.stmt(d_module, d_position,'l_actioner_user_name', l_actioner_user_name);
135: END IF;
136:
137: wf_engine.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname =>
138: 'REQUESTOR' , avalue => l_requestor_user_name);

Line 180: IF (PO_LOG.d_proc) THEN

176:
177: wf_engine.StartProcess( itemtype => l_itemtype, itemkey => l_itemkey );
178:
179: COMMIT;
180: IF (PO_LOG.d_proc) THEN
181: PO_LOG.proc_end (d_module);
182: END IF;
183:
184: EXCEPTION

Line 181: PO_LOG.proc_end (d_module);

177: wf_engine.StartProcess( itemtype => l_itemtype, itemkey => l_itemkey );
178:
179: COMMIT;
180: IF (PO_LOG.d_proc) THEN
181: PO_LOG.proc_end (d_module);
182: END IF;
183:
184: EXCEPTION
185: WHEN OTHERS THEN