1: PACKAGE BODY PO_CLM_OKC_INTEG_PKG AS
2: /* $Header: PO_CLM_OKC_INTEG_PKG.plb 120.0.12020000.7 2013/02/27 10:43:19 vpeddi noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_CLM_OKC_INTEG_PKG');
6:
7:
8: -----------------------------------------------------------------------
9: --Start of Comments
49:
50: BEGIN
51:
52: d_position := 0;
53: IF (PO_LOG.d_proc) THEN
54: PO_LOG.proc_begin(d_module);
55: END IF;
56:
57: PO_EXHIBITS_PVT.insert_exhibits
50: BEGIN
51:
52: d_position := 0;
53: IF (PO_LOG.d_proc) THEN
54: PO_LOG.proc_begin(d_module);
55: END IF;
56:
57: PO_EXHIBITS_PVT.insert_exhibits
58: (
69: x_return_status := l_return_status;
70: x_return_msg := l_return_msg;
71:
72: d_position := 10;
73: IF (PO_LOG.d_proc) THEN
74: PO_LOG.proc_end(d_module);
75: END IF;
76:
77:
70: x_return_msg := l_return_msg;
71:
72: d_position := 10;
73: IF (PO_LOG.d_proc) THEN
74: PO_LOG.proc_end(d_module);
75: END IF;
76:
77:
78: EXCEPTION
123:
124: BEGIN
125:
126: d_position := 0;
127: IF (PO_LOG.d_proc) THEN
128: PO_LOG.proc_begin(d_module);
129: END IF;
130:
131: PO_EXHIBITS_PVT.delete_exhibits
124: BEGIN
125:
126: d_position := 0;
127: IF (PO_LOG.d_proc) THEN
128: PO_LOG.proc_begin(d_module);
129: END IF;
130:
131: PO_EXHIBITS_PVT.delete_exhibits
132: (
141: x_return_status := l_return_status;
142: x_return_msg := l_return_msg;
143:
144: d_position := 10;
145: IF (PO_LOG.d_proc) THEN
146: PO_LOG.proc_end(d_module);
147: END IF;
148:
149:
142: x_return_msg := l_return_msg;
143:
144: d_position := 10;
145: IF (PO_LOG.d_proc) THEN
146: PO_LOG.proc_end(d_module);
147: END IF;
148:
149:
150: EXCEPTION
179:
180: BEGIN
181:
182: d_position := 0;
183: IF (PO_LOG.d_proc) THEN
184: PO_LOG.proc_begin(d_module);
185: PO_LOG.proc_begin(d_module, 'p_doc_id', p_doc_id);
186: END IF;
187:
180: BEGIN
181:
182: d_position := 0;
183: IF (PO_LOG.d_proc) THEN
184: PO_LOG.proc_begin(d_module);
185: PO_LOG.proc_begin(d_module, 'p_doc_id', p_doc_id);
186: END IF;
187:
188: PO_CLOSEOUT_PVT.start_closeout_wf_process(p_doc_id => p_doc_id,
181:
182: d_position := 0;
183: IF (PO_LOG.d_proc) THEN
184: PO_LOG.proc_begin(d_module);
185: PO_LOG.proc_begin(d_module, 'p_doc_id', p_doc_id);
186: END IF;
187:
188: PO_CLOSEOUT_PVT.start_closeout_wf_process(p_doc_id => p_doc_id,
189: x_return_status => l_return_status);
190:
191: x_return_status := l_return_status;
192:
193: d_position := 10;
194: IF (PO_LOG.d_proc) THEN
195: PO_LOG.proc_end(d_module);
196: END IF;
197:
198: EXCEPTION
191: x_return_status := l_return_status;
192:
193: d_position := 10;
194: IF (PO_LOG.d_proc) THEN
195: PO_LOG.proc_end(d_module);
196: END IF;
197:
198: EXCEPTION
199: WHEN OTHERS THEN