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.M4R_7B5_OSFM_PKG dependencies on CLN_DEBUG_PUB

Line 53: cln_debug_pub.Add('ENTERING M4R_7B5_OSFM_PKG.SET_WF_ATTRIBUTES procedure with the following parameters:', 2);

49:
50: BEGIN
51:
52: IF (g_debug_level <= 2) THEN
53: cln_debug_pub.Add('ENTERING M4R_7B5_OSFM_PKG.SET_WF_ATTRIBUTES procedure with the following parameters:', 2);
54: cln_debug_pub.Add('itemtype:' || p_itemtype, 2);
55: cln_debug_pub.Add('itemkey:' || p_itemkey, 2);
56: cln_debug_pub.Add('actid:' || p_actid, 2);
57: cln_debug_pub.Add('funcmode:' || p_funcmode, 2);

Line 54: cln_debug_pub.Add('itemtype:' || p_itemtype, 2);

50: BEGIN
51:
52: IF (g_debug_level <= 2) THEN
53: cln_debug_pub.Add('ENTERING M4R_7B5_OSFM_PKG.SET_WF_ATTRIBUTES procedure with the following parameters:', 2);
54: cln_debug_pub.Add('itemtype:' || p_itemtype, 2);
55: cln_debug_pub.Add('itemkey:' || p_itemkey, 2);
56: cln_debug_pub.Add('actid:' || p_actid, 2);
57: cln_debug_pub.Add('funcmode:' || p_funcmode, 2);
58: cln_debug_pub.Add('resultout:' || x_resultout, 2);

Line 55: cln_debug_pub.Add('itemkey:' || p_itemkey, 2);

51:
52: IF (g_debug_level <= 2) THEN
53: cln_debug_pub.Add('ENTERING M4R_7B5_OSFM_PKG.SET_WF_ATTRIBUTES procedure with the following parameters:', 2);
54: cln_debug_pub.Add('itemtype:' || p_itemtype, 2);
55: cln_debug_pub.Add('itemkey:' || p_itemkey, 2);
56: cln_debug_pub.Add('actid:' || p_actid, 2);
57: cln_debug_pub.Add('funcmode:' || p_funcmode, 2);
58: cln_debug_pub.Add('resultout:' || x_resultout, 2);
59: END IF;

Line 56: cln_debug_pub.Add('actid:' || p_actid, 2);

52: IF (g_debug_level <= 2) THEN
53: cln_debug_pub.Add('ENTERING M4R_7B5_OSFM_PKG.SET_WF_ATTRIBUTES procedure with the following parameters:', 2);
54: cln_debug_pub.Add('itemtype:' || p_itemtype, 2);
55: cln_debug_pub.Add('itemkey:' || p_itemkey, 2);
56: cln_debug_pub.Add('actid:' || p_actid, 2);
57: cln_debug_pub.Add('funcmode:' || p_funcmode, 2);
58: cln_debug_pub.Add('resultout:' || x_resultout, 2);
59: END IF;
60:

Line 57: cln_debug_pub.Add('funcmode:' || p_funcmode, 2);

53: cln_debug_pub.Add('ENTERING M4R_7B5_OSFM_PKG.SET_WF_ATTRIBUTES procedure with the following parameters:', 2);
54: cln_debug_pub.Add('itemtype:' || p_itemtype, 2);
55: cln_debug_pub.Add('itemkey:' || p_itemkey, 2);
56: cln_debug_pub.Add('actid:' || p_actid, 2);
57: cln_debug_pub.Add('funcmode:' || p_funcmode, 2);
58: cln_debug_pub.Add('resultout:' || x_resultout, 2);
59: END IF;
60:
61: l_po_doc_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'DOCUMENT_ID');

Line 58: cln_debug_pub.Add('resultout:' || x_resultout, 2);

54: cln_debug_pub.Add('itemtype:' || p_itemtype, 2);
55: cln_debug_pub.Add('itemkey:' || p_itemkey, 2);
56: cln_debug_pub.Add('actid:' || p_actid, 2);
57: cln_debug_pub.Add('funcmode:' || p_funcmode, 2);
58: cln_debug_pub.Add('resultout:' || x_resultout, 2);
59: END IF;
60:
61: l_po_doc_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'DOCUMENT_ID');
62: IF (g_debug_level <= 1) THEN

Line 63: cln_debug_pub.Add('PO Document ID ' || l_po_doc_id, 1);

59: END IF;
60:
61: l_po_doc_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'DOCUMENT_ID');
62: IF (g_debug_level <= 1) THEN
63: cln_debug_pub.Add('PO Document ID ' || l_po_doc_id, 1);
64: END IF;
65:
66: l_po_doc_type := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'DOCUMENT_TYPE');
67: IF (g_debug_level <= 1) THEN

Line 68: cln_debug_pub.Add('PO Document Type ' || l_po_doc_type, 1);

64: END IF;
65:
66: l_po_doc_type := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'DOCUMENT_TYPE');
67: IF (g_debug_level <= 1) THEN
68: cln_debug_pub.Add('PO Document Type ' || l_po_doc_type, 1);
69: END IF;
70:
71: l_po_rev_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_REVISION_NUM');
72: IF (g_debug_level <= 1) THEN

Line 73: cln_debug_pub.Add('PO Document Revision Number ' || l_po_rev_num, 1);

69: END IF;
70:
71: l_po_rev_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_REVISION_NUM');
72: IF (g_debug_level <= 1) THEN
73: cln_debug_pub.Add('PO Document Revision Number ' || l_po_rev_num, 1);
74: END IF;
75:
76: IF l_po_doc_type = 'RELEASE' THEN ---- Get the PO Release ID if the PO is a Release
77:

Line 90: cln_debug_pub.Add('PO Header ID ' || l_po_header_id, 1);

86: WHERE po_release_id = l_po_rel_id
87: AND revision_num = l_po_rel_rev_num;
88:
89: IF (g_debug_level <= 1) THEN
90: cln_debug_pub.Add('PO Header ID ' || l_po_header_id, 1);
91: cln_debug_pub.Add('PO Release ID ' || l_po_rel_id, 1);
92: cln_debug_pub.Add('PO Release Number ' || l_po_rel_num, 1);
93: cln_debug_pub.Add('Release Revision Number ' || l_po_rel_rev_num, 1);
94: END IF;

Line 91: cln_debug_pub.Add('PO Release ID ' || l_po_rel_id, 1);

87: AND revision_num = l_po_rel_rev_num;
88:
89: IF (g_debug_level <= 1) THEN
90: cln_debug_pub.Add('PO Header ID ' || l_po_header_id, 1);
91: cln_debug_pub.Add('PO Release ID ' || l_po_rel_id, 1);
92: cln_debug_pub.Add('PO Release Number ' || l_po_rel_num, 1);
93: cln_debug_pub.Add('Release Revision Number ' || l_po_rel_rev_num, 1);
94: END IF;
95: ELSE

Line 92: cln_debug_pub.Add('PO Release Number ' || l_po_rel_num, 1);

88:
89: IF (g_debug_level <= 1) THEN
90: cln_debug_pub.Add('PO Header ID ' || l_po_header_id, 1);
91: cln_debug_pub.Add('PO Release ID ' || l_po_rel_id, 1);
92: cln_debug_pub.Add('PO Release Number ' || l_po_rel_num, 1);
93: cln_debug_pub.Add('Release Revision Number ' || l_po_rel_rev_num, 1);
94: END IF;
95: ELSE
96: l_po_header_id := l_po_doc_id;

Line 93: cln_debug_pub.Add('Release Revision Number ' || l_po_rel_rev_num, 1);

89: IF (g_debug_level <= 1) THEN
90: cln_debug_pub.Add('PO Header ID ' || l_po_header_id, 1);
91: cln_debug_pub.Add('PO Release ID ' || l_po_rel_id, 1);
92: cln_debug_pub.Add('PO Release Number ' || l_po_rel_num, 1);
93: cln_debug_pub.Add('Release Revision Number ' || l_po_rel_rev_num, 1);
94: END IF;
95: ELSE
96: l_po_header_id := l_po_doc_id;
97:

Line 99: cln_debug_pub.Add('PO Header ID' || l_po_header_id, 1);

95: ELSE
96: l_po_header_id := l_po_doc_id;
97:
98: IF (g_debug_level <= 1) THEN
99: cln_debug_pub.Add('PO Header ID' || l_po_header_id, 1);
100: END IF;
101:
102: END IF;
103:

Line 128: cln_debug_pub.Add('x_resultout = ' || x_resultout, 5);

124: WHEN NO_DATA_FOUND THEN
125: x_resultout := 'F';
126:
127: IF (g_debug_level <= 5) THEN
128: cln_debug_pub.Add('x_resultout = ' || x_resultout, 5);
129: cln_debug_pub.Add('There are NO OSP items in the PO', 5);
130: END IF;
131: END;
132:

Line 129: cln_debug_pub.Add('There are NO OSP items in the PO', 5);

125: x_resultout := 'F';
126:
127: IF (g_debug_level <= 5) THEN
128: cln_debug_pub.Add('x_resultout = ' || x_resultout, 5);
129: cln_debug_pub.Add('There are NO OSP items in the PO', 5);
130: END IF;
131: END;
132:
133: IF l_osp_item_exists = 'YES' THEN

Line 155: cln_debug_pub.Add('x_resultout = ' || x_resultout, 1);

151: AND revision_num = l_po_rev_num;
152: END IF;
153:
154: IF (g_debug_level <= 1) THEN
155: cln_debug_pub.Add('x_resultout = ' || x_resultout, 1);
156: cln_debug_pub.Add('There are OSP items in the PO, The WF attributes are set as below.', 1);
157: cln_debug_pub.Add('PARTY ID = ' || l_party_id, 1);
158: cln_debug_pub.Add('PARTY SITE ID = '|| l_party_site_id , 1);
159: cln_debug_pub.Add('PO_HEADER_ID = '|| l_po_header_id , 1);

Line 156: cln_debug_pub.Add('There are OSP items in the PO, The WF attributes are set as below.', 1);

152: END IF;
153:
154: IF (g_debug_level <= 1) THEN
155: cln_debug_pub.Add('x_resultout = ' || x_resultout, 1);
156: cln_debug_pub.Add('There are OSP items in the PO, The WF attributes are set as below.', 1);
157: cln_debug_pub.Add('PARTY ID = ' || l_party_id, 1);
158: cln_debug_pub.Add('PARTY SITE ID = '|| l_party_site_id , 1);
159: cln_debug_pub.Add('PO_HEADER_ID = '|| l_po_header_id , 1);
160: cln_debug_pub.Add('PO_REVISION_NUM = '|| l_po_rev_num , 1);

Line 157: cln_debug_pub.Add('PARTY ID = ' || l_party_id, 1);

153:
154: IF (g_debug_level <= 1) THEN
155: cln_debug_pub.Add('x_resultout = ' || x_resultout, 1);
156: cln_debug_pub.Add('There are OSP items in the PO, The WF attributes are set as below.', 1);
157: cln_debug_pub.Add('PARTY ID = ' || l_party_id, 1);
158: cln_debug_pub.Add('PARTY SITE ID = '|| l_party_site_id , 1);
159: cln_debug_pub.Add('PO_HEADER_ID = '|| l_po_header_id , 1);
160: cln_debug_pub.Add('PO_REVISION_NUM = '|| l_po_rev_num , 1);
161: cln_debug_pub.Add('PO_RELEASE_ID = ' || l_po_rel_id, 1);

Line 158: cln_debug_pub.Add('PARTY SITE ID = '|| l_party_site_id , 1);

154: IF (g_debug_level <= 1) THEN
155: cln_debug_pub.Add('x_resultout = ' || x_resultout, 1);
156: cln_debug_pub.Add('There are OSP items in the PO, The WF attributes are set as below.', 1);
157: cln_debug_pub.Add('PARTY ID = ' || l_party_id, 1);
158: cln_debug_pub.Add('PARTY SITE ID = '|| l_party_site_id , 1);
159: cln_debug_pub.Add('PO_HEADER_ID = '|| l_po_header_id , 1);
160: cln_debug_pub.Add('PO_REVISION_NUM = '|| l_po_rev_num , 1);
161: cln_debug_pub.Add('PO_RELEASE_ID = ' || l_po_rel_id, 1);
162: cln_debug_pub.Add('PO_RELEASE_NUM = '|| l_po_rel_num , 1);

Line 159: cln_debug_pub.Add('PO_HEADER_ID = '|| l_po_header_id , 1);

155: cln_debug_pub.Add('x_resultout = ' || x_resultout, 1);
156: cln_debug_pub.Add('There are OSP items in the PO, The WF attributes are set as below.', 1);
157: cln_debug_pub.Add('PARTY ID = ' || l_party_id, 1);
158: cln_debug_pub.Add('PARTY SITE ID = '|| l_party_site_id , 1);
159: cln_debug_pub.Add('PO_HEADER_ID = '|| l_po_header_id , 1);
160: cln_debug_pub.Add('PO_REVISION_NUM = '|| l_po_rev_num , 1);
161: cln_debug_pub.Add('PO_RELEASE_ID = ' || l_po_rel_id, 1);
162: cln_debug_pub.Add('PO_RELEASE_NUM = '|| l_po_rel_num , 1);
163: cln_debug_pub.Add('PO_REL_REV_NUM = '|| l_po_rel_rev_num , 1);

Line 160: cln_debug_pub.Add('PO_REVISION_NUM = '|| l_po_rev_num , 1);

156: cln_debug_pub.Add('There are OSP items in the PO, The WF attributes are set as below.', 1);
157: cln_debug_pub.Add('PARTY ID = ' || l_party_id, 1);
158: cln_debug_pub.Add('PARTY SITE ID = '|| l_party_site_id , 1);
159: cln_debug_pub.Add('PO_HEADER_ID = '|| l_po_header_id , 1);
160: cln_debug_pub.Add('PO_REVISION_NUM = '|| l_po_rev_num , 1);
161: cln_debug_pub.Add('PO_RELEASE_ID = ' || l_po_rel_id, 1);
162: cln_debug_pub.Add('PO_RELEASE_NUM = '|| l_po_rel_num , 1);
163: cln_debug_pub.Add('PO_REL_REV_NUM = '|| l_po_rel_rev_num , 1);
164: END IF;

Line 161: cln_debug_pub.Add('PO_RELEASE_ID = ' || l_po_rel_id, 1);

157: cln_debug_pub.Add('PARTY ID = ' || l_party_id, 1);
158: cln_debug_pub.Add('PARTY SITE ID = '|| l_party_site_id , 1);
159: cln_debug_pub.Add('PO_HEADER_ID = '|| l_po_header_id , 1);
160: cln_debug_pub.Add('PO_REVISION_NUM = '|| l_po_rev_num , 1);
161: cln_debug_pub.Add('PO_RELEASE_ID = ' || l_po_rel_id, 1);
162: cln_debug_pub.Add('PO_RELEASE_NUM = '|| l_po_rel_num , 1);
163: cln_debug_pub.Add('PO_REL_REV_NUM = '|| l_po_rel_rev_num , 1);
164: END IF;
165:

Line 162: cln_debug_pub.Add('PO_RELEASE_NUM = '|| l_po_rel_num , 1);

158: cln_debug_pub.Add('PARTY SITE ID = '|| l_party_site_id , 1);
159: cln_debug_pub.Add('PO_HEADER_ID = '|| l_po_header_id , 1);
160: cln_debug_pub.Add('PO_REVISION_NUM = '|| l_po_rev_num , 1);
161: cln_debug_pub.Add('PO_RELEASE_ID = ' || l_po_rel_id, 1);
162: cln_debug_pub.Add('PO_RELEASE_NUM = '|| l_po_rel_num , 1);
163: cln_debug_pub.Add('PO_REL_REV_NUM = '|| l_po_rel_rev_num , 1);
164: END IF;
165:
166: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', 'M4R');

Line 163: cln_debug_pub.Add('PO_REL_REV_NUM = '|| l_po_rel_rev_num , 1);

159: cln_debug_pub.Add('PO_HEADER_ID = '|| l_po_header_id , 1);
160: cln_debug_pub.Add('PO_REVISION_NUM = '|| l_po_rev_num , 1);
161: cln_debug_pub.Add('PO_RELEASE_ID = ' || l_po_rel_id, 1);
162: cln_debug_pub.Add('PO_RELEASE_NUM = '|| l_po_rel_num , 1);
163: cln_debug_pub.Add('PO_REL_REV_NUM = '|| l_po_rel_rev_num , 1);
164: END IF;
165:
166: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', 'M4R');
167: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO');

Line 179: cln_debug_pub.Add('Workflow Attributes set', 1);

175: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REVISION_NUM', l_po_rev_num);
176: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PO_REL_REV_NUM', l_po_rel_rev_num);
177:
178: IF (g_debug_level <= 1) THEN
179: cln_debug_pub.Add('Workflow Attributes set', 1);
180: END IF;
181:
182: END IF; -- l_osp_item_exists = 'YES'
183:

Line 188: cln_debug_pub.Add('The Document Type is either BLANKET OR PLANNED', 1);

184: ELSE
185: x_resultout := 'F';
186:
187: IF (g_debug_level <= 1) THEN
188: cln_debug_pub.Add('The Document Type is either BLANKET OR PLANNED', 1);
189: cln_debug_pub.Add('x_resultout = ' || x_resultout, 1);
190: END IF;
191:
192: END IF; -- If doc type is Release, PO or Standard

Line 189: cln_debug_pub.Add('x_resultout = ' || x_resultout, 1);

185: x_resultout := 'F';
186:
187: IF (g_debug_level <= 1) THEN
188: cln_debug_pub.Add('The Document Type is either BLANKET OR PLANNED', 1);
189: cln_debug_pub.Add('x_resultout = ' || x_resultout, 1);
190: END IF;
191:
192: END IF; -- If doc type is Release, PO or Standard
193:

Line 195: cln_debug_pub.Add('Exiting the M4R_7B5_OSFM_PKG.SET_WF_ATTRIBUTES procedure', 2);

191:
192: END IF; -- If doc type is Release, PO or Standard
193:
194: IF (g_debug_level <= 2) THEN
195: cln_debug_pub.Add('Exiting the M4R_7B5_OSFM_PKG.SET_WF_ATTRIBUTES procedure', 2);
196: END IF;
197:
198: EXCEPTION
199: WHEN OTHERS THEN

Line 205: cln_debug_pub.Add('g_exception_tracking_msg : '|| g_exception_tracking_msg,5);

201: l_errmsg := SQLERRM;
202: x_resultout := 'ERROR:'||l_error_code||'-'||l_errmsg;
203:
204: IF (g_debug_level <= 5) THEN
205: cln_debug_pub.Add('g_exception_tracking_msg : '|| g_exception_tracking_msg,5);
206: cln_debug_pub.Add('Exception - In SET_WF_ATTRIBUTES API', 5);
207: cln_debug_pub.Add('Error is ' || l_error_code || ':' || l_errmsg, 5);
208: END IF;
209:

Line 206: cln_debug_pub.Add('Exception - In SET_WF_ATTRIBUTES API', 5);

202: x_resultout := 'ERROR:'||l_error_code||'-'||l_errmsg;
203:
204: IF (g_debug_level <= 5) THEN
205: cln_debug_pub.Add('g_exception_tracking_msg : '|| g_exception_tracking_msg,5);
206: cln_debug_pub.Add('Exception - In SET_WF_ATTRIBUTES API', 5);
207: cln_debug_pub.Add('Error is ' || l_error_code || ':' || l_errmsg, 5);
208: END IF;
209:
210: END SET_WF_ATTRIBUTES;

Line 207: cln_debug_pub.Add('Error is ' || l_error_code || ':' || l_errmsg, 5);

203:
204: IF (g_debug_level <= 5) THEN
205: cln_debug_pub.Add('g_exception_tracking_msg : '|| g_exception_tracking_msg,5);
206: cln_debug_pub.Add('Exception - In SET_WF_ATTRIBUTES API', 5);
207: cln_debug_pub.Add('Error is ' || l_error_code || ':' || l_errmsg, 5);
208: END IF;
209:
210: END SET_WF_ATTRIBUTES;
211:

Line 302: cln_debug_pub.Add('ENTERING M4R_7B5_OSFM_PKG.PROCESS_WO procedure with the following parameters:', 2);

298:
299: BEGIN
300:
301: IF (g_debug_level <= 2) THEN
302: cln_debug_pub.Add('ENTERING M4R_7B5_OSFM_PKG.PROCESS_WO procedure with the following parameters:', 2);
303: cln_debug_pub.Add('itemtype:' || p_itemtype, 2);
304: cln_debug_pub.Add('itemkey:' || p_itemkey, 2);
305: cln_debug_pub.Add('actid:' || p_actid, 2);
306: cln_debug_pub.Add('funcmode:' || p_funcmode, 2);

Line 303: cln_debug_pub.Add('itemtype:' || p_itemtype, 2);

299: BEGIN
300:
301: IF (g_debug_level <= 2) THEN
302: cln_debug_pub.Add('ENTERING M4R_7B5_OSFM_PKG.PROCESS_WO procedure with the following parameters:', 2);
303: cln_debug_pub.Add('itemtype:' || p_itemtype, 2);
304: cln_debug_pub.Add('itemkey:' || p_itemkey, 2);
305: cln_debug_pub.Add('actid:' || p_actid, 2);
306: cln_debug_pub.Add('funcmode:' || p_funcmode, 2);
307: cln_debug_pub.Add('resultout:' || x_resultout, 2);

Line 304: cln_debug_pub.Add('itemkey:' || p_itemkey, 2);

300:
301: IF (g_debug_level <= 2) THEN
302: cln_debug_pub.Add('ENTERING M4R_7B5_OSFM_PKG.PROCESS_WO procedure with the following parameters:', 2);
303: cln_debug_pub.Add('itemtype:' || p_itemtype, 2);
304: cln_debug_pub.Add('itemkey:' || p_itemkey, 2);
305: cln_debug_pub.Add('actid:' || p_actid, 2);
306: cln_debug_pub.Add('funcmode:' || p_funcmode, 2);
307: cln_debug_pub.Add('resultout:' || x_resultout, 2);
308: END IF;

Line 305: cln_debug_pub.Add('actid:' || p_actid, 2);

301: IF (g_debug_level <= 2) THEN
302: cln_debug_pub.Add('ENTERING M4R_7B5_OSFM_PKG.PROCESS_WO procedure with the following parameters:', 2);
303: cln_debug_pub.Add('itemtype:' || p_itemtype, 2);
304: cln_debug_pub.Add('itemkey:' || p_itemkey, 2);
305: cln_debug_pub.Add('actid:' || p_actid, 2);
306: cln_debug_pub.Add('funcmode:' || p_funcmode, 2);
307: cln_debug_pub.Add('resultout:' || x_resultout, 2);
308: END IF;
309:

Line 306: cln_debug_pub.Add('funcmode:' || p_funcmode, 2);

302: cln_debug_pub.Add('ENTERING M4R_7B5_OSFM_PKG.PROCESS_WO procedure with the following parameters:', 2);
303: cln_debug_pub.Add('itemtype:' || p_itemtype, 2);
304: cln_debug_pub.Add('itemkey:' || p_itemkey, 2);
305: cln_debug_pub.Add('actid:' || p_actid, 2);
306: cln_debug_pub.Add('funcmode:' || p_funcmode, 2);
307: cln_debug_pub.Add('resultout:' || x_resultout, 2);
308: END IF;
309:
310:

Line 307: cln_debug_pub.Add('resultout:' || x_resultout, 2);

303: cln_debug_pub.Add('itemtype:' || p_itemtype, 2);
304: cln_debug_pub.Add('itemkey:' || p_itemkey, 2);
305: cln_debug_pub.Add('actid:' || p_actid, 2);
306: cln_debug_pub.Add('funcmode:' || p_funcmode, 2);
307: cln_debug_pub.Add('resultout:' || x_resultout, 2);
308: END IF;
309:
310:
311: -- read wf item attributes into local variable, begins

Line 314: cln_debug_pub.Add('PO Header ID ' || l_po_header_id, 1);

310:
311: -- read wf item attributes into local variable, begins
312: l_po_header_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_HEADER_ID');
313: IF (g_debug_level <= 1) THEN
314: cln_debug_pub.Add('PO Header ID ' || l_po_header_id, 1);
315: END IF;
316:
317: l_po_rel_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_RELEASE_ID');
318: IF (g_debug_level <= 1) THEN

Line 319: cln_debug_pub.Add('PO Release ID ' || l_po_rel_id, 1);

315: END IF;
316:
317: l_po_rel_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_RELEASE_ID');
318: IF (g_debug_level <= 1) THEN
319: cln_debug_pub.Add('PO Release ID ' || l_po_rel_id, 1);
320: END IF;
321:
322: l_po_doc_type := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'DOCUMENT_TYPE');
323: IF (g_debug_level <= 1) THEN

Line 324: cln_debug_pub.Add('PO Document Type ' || l_po_doc_type, 1);

320: END IF;
321:
322: l_po_doc_type := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'DOCUMENT_TYPE');
323: IF (g_debug_level <= 1) THEN
324: cln_debug_pub.Add('PO Document Type ' || l_po_doc_type, 1);
325: END IF;
326:
327: l_po_rev_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_REVISION_NUM');
328: IF (g_debug_level <= 1) THEN

Line 329: cln_debug_pub.Add('PO Revision Number ' || l_po_rev_num, 1);

325: END IF;
326:
327: l_po_rev_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_REVISION_NUM');
328: IF (g_debug_level <= 1) THEN
329: cln_debug_pub.Add('PO Revision Number ' || l_po_rev_num, 1);
330: END IF;
331:
332: l_po_rel_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_RELEASE_NUM');
333: IF (g_debug_level <= 1) THEN

Line 334: cln_debug_pub.Add('PO Release Number ' || l_po_rel_num, 1);

330: END IF;
331:
332: l_po_rel_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_RELEASE_NUM');
333: IF (g_debug_level <= 1) THEN
334: cln_debug_pub.Add('PO Release Number ' || l_po_rel_num, 1);
335: END IF;
336:
337: l_po_rel_rev_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_REL_REV_NUM');
338: IF (g_debug_level <= 1) THEN

Line 339: cln_debug_pub.Add('PO Release Revision Number ' || l_po_rel_rev_num, 1);

335: END IF;
336:
337: l_po_rel_rev_num := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'PO_REL_REV_NUM');
338: IF (g_debug_level <= 1) THEN
339: cln_debug_pub.Add('PO Release Revision Number ' || l_po_rel_rev_num, 1);
340: END IF;
341:
342: l_org_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'ORG_ID');
343: IF (g_debug_level <= 1) THEN

Line 344: cln_debug_pub.Add('Org ID ' || l_org_id, 1);

340: END IF;
341:
342: l_org_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'ORG_ID');
343: IF (g_debug_level <= 1) THEN
344: cln_debug_pub.Add('Org ID ' || l_org_id, 1);
345: END IF;
346:
347: l_party_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'ECX_PARTY_ID');
348: IF (g_debug_level <= 1) THEN

Line 349: cln_debug_pub.Add('Party ID ' || l_party_id, 1);

345: END IF;
346:
347: l_party_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'ECX_PARTY_ID');
348: IF (g_debug_level <= 1) THEN
349: cln_debug_pub.Add('Party ID ' || l_party_id, 1);
350: END IF;
351:
352: l_party_site_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'ECX_PARTY_SITE_ID');
353: IF (g_debug_level <= 1) THEN

Line 354: cln_debug_pub.Add('Party Site ID ' || l_party_site_id, 1);

350: END IF;
351:
352: l_party_site_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid,'ECX_PARTY_SITE_ID');
353: IF (g_debug_level <= 1) THEN
354: cln_debug_pub.Add('Party Site ID ' || l_party_site_id, 1);
355: END IF;
356: -- read wf item attributes into local variable, ends
357:
358: -- query date attributes and cancel flags for the po/release

Line 380: cln_debug_pub.Add('From po_releases_all Table',1);

376: WHERE po_release_id = l_po_rel_id
377: AND revision_num = l_po_rel_rev_num;
378:
379: IF (g_debug_level <= 1) THEN
380: cln_debug_pub.Add('From po_releases_all Table',1);
381: cln_debug_pub.Add('creation_date - ' ||l_creation_date,1);
382: cln_debug_pub.Add('revised_date - ' ||l_rev_date,1);
383: cln_debug_pub.Add('cancel_flag - ' ||l_cancel_flag,1);
384: END IF;

Line 381: cln_debug_pub.Add('creation_date - ' ||l_creation_date,1);

377: AND revision_num = l_po_rel_rev_num;
378:
379: IF (g_debug_level <= 1) THEN
380: cln_debug_pub.Add('From po_releases_all Table',1);
381: cln_debug_pub.Add('creation_date - ' ||l_creation_date,1);
382: cln_debug_pub.Add('revised_date - ' ||l_rev_date,1);
383: cln_debug_pub.Add('cancel_flag - ' ||l_cancel_flag,1);
384: END IF;
385:

Line 382: cln_debug_pub.Add('revised_date - ' ||l_rev_date,1);

378:
379: IF (g_debug_level <= 1) THEN
380: cln_debug_pub.Add('From po_releases_all Table',1);
381: cln_debug_pub.Add('creation_date - ' ||l_creation_date,1);
382: cln_debug_pub.Add('revised_date - ' ||l_rev_date,1);
383: cln_debug_pub.Add('cancel_flag - ' ||l_cancel_flag,1);
384: END IF;
385:
386: g_exception_tracking_msg := 'Query po_releases_all for cance_flag';

Line 383: cln_debug_pub.Add('cancel_flag - ' ||l_cancel_flag,1);

379: IF (g_debug_level <= 1) THEN
380: cln_debug_pub.Add('From po_releases_all Table',1);
381: cln_debug_pub.Add('creation_date - ' ||l_creation_date,1);
382: cln_debug_pub.Add('revised_date - ' ||l_rev_date,1);
383: cln_debug_pub.Add('cancel_flag - ' ||l_cancel_flag,1);
384: END IF;
385:
386: g_exception_tracking_msg := 'Query po_releases_all for cance_flag';
387:

Line 395: cln_debug_pub.Add('cancel_flag - '||l_cancel_flag,1);

391: FROM po_releases_all
392: WHERE po_release_id = l_po_rel_id;
393:
394: IF (g_debug_level <= 1) THEN
395: cln_debug_pub.Add('cancel_flag - '||l_cancel_flag,1);
396: END IF;
397:
398: ELSE
399:

Line 409: cln_debug_pub.Add('From po_headers_all Table',1);

405: WHERE po_header_id = l_po_header_id
406: AND ((revision_num = l_po_rev_num) OR (revision_num IS NULL));
407:
408: IF (g_debug_level <= 1) THEN
409: cln_debug_pub.Add('From po_headers_all Table',1);
410: cln_debug_pub.Add('creation_date - ' ||l_creation_date,1);
411: cln_debug_pub.Add('revised_date - ' ||l_rev_date,1);
412: cln_debug_pub.Add('cancel_flag - ' ||l_cancel_flag,1);
413: END IF;

Line 410: cln_debug_pub.Add('creation_date - ' ||l_creation_date,1);

406: AND ((revision_num = l_po_rev_num) OR (revision_num IS NULL));
407:
408: IF (g_debug_level <= 1) THEN
409: cln_debug_pub.Add('From po_headers_all Table',1);
410: cln_debug_pub.Add('creation_date - ' ||l_creation_date,1);
411: cln_debug_pub.Add('revised_date - ' ||l_rev_date,1);
412: cln_debug_pub.Add('cancel_flag - ' ||l_cancel_flag,1);
413: END IF;
414:

Line 411: cln_debug_pub.Add('revised_date - ' ||l_rev_date,1);

407:
408: IF (g_debug_level <= 1) THEN
409: cln_debug_pub.Add('From po_headers_all Table',1);
410: cln_debug_pub.Add('creation_date - ' ||l_creation_date,1);
411: cln_debug_pub.Add('revised_date - ' ||l_rev_date,1);
412: cln_debug_pub.Add('cancel_flag - ' ||l_cancel_flag,1);
413: END IF;
414:
415: END IF;

Line 412: cln_debug_pub.Add('cancel_flag - ' ||l_cancel_flag,1);

408: IF (g_debug_level <= 1) THEN
409: cln_debug_pub.Add('From po_headers_all Table',1);
410: cln_debug_pub.Add('creation_date - ' ||l_creation_date,1);
411: cln_debug_pub.Add('revised_date - ' ||l_rev_date,1);
412: cln_debug_pub.Add('cancel_flag - ' ||l_cancel_flag,1);
413: END IF;
414:
415: END IF;
416: -- query date attributes and cancel flags for the po/release ends here

Line 436: cln_debug_pub.Add('Cancel Flag is Y. Document Type is Standard or PO and Action Code is WON', 1);

432: l_action_code := 'WON';
433: l_raise_flag := 'Y';
434:
435: IF (g_debug_level <= 1) THEN
436: cln_debug_pub.Add('Cancel Flag is Y. Document Type is Standard or PO and Action Code is WON', 1);
437: END IF;
438: END IF;
439: END IF;
440: -- Finished checking if it is new PO/Release or Cancelled PO/release

Line 443: cln_debug_pub.Add('Raise Flag: ' || l_raise_flag, 1);

439: END IF;
440: -- Finished checking if it is new PO/Release or Cancelled PO/release
441:
442: IF (g_debug_level <= 1) THEN
443: cln_debug_pub.Add('Raise Flag: ' || l_raise_flag, 1);
444: cln_debug_pub.Add('l_all_cancel_flag: ' || l_all_cancel_flag, 1);
445: cln_debug_pub.Add('l_all_new_flag: ' || l_all_new_flag, 1);
446: cln_debug_pub.Add('l_action_code: ' || l_action_code, 1);
447: END IF;

Line 444: cln_debug_pub.Add('l_all_cancel_flag: ' || l_all_cancel_flag, 1);

440: -- Finished checking if it is new PO/Release or Cancelled PO/release
441:
442: IF (g_debug_level <= 1) THEN
443: cln_debug_pub.Add('Raise Flag: ' || l_raise_flag, 1);
444: cln_debug_pub.Add('l_all_cancel_flag: ' || l_all_cancel_flag, 1);
445: cln_debug_pub.Add('l_all_new_flag: ' || l_all_new_flag, 1);
446: cln_debug_pub.Add('l_action_code: ' || l_action_code, 1);
447: END IF;
448:

Line 445: cln_debug_pub.Add('l_all_new_flag: ' || l_all_new_flag, 1);

441:
442: IF (g_debug_level <= 1) THEN
443: cln_debug_pub.Add('Raise Flag: ' || l_raise_flag, 1);
444: cln_debug_pub.Add('l_all_cancel_flag: ' || l_all_cancel_flag, 1);
445: cln_debug_pub.Add('l_all_new_flag: ' || l_all_new_flag, 1);
446: cln_debug_pub.Add('l_action_code: ' || l_action_code, 1);
447: END IF;
448:
449: -- Check for header change

Line 446: cln_debug_pub.Add('l_action_code: ' || l_action_code, 1);

442: IF (g_debug_level <= 1) THEN
443: cln_debug_pub.Add('Raise Flag: ' || l_raise_flag, 1);
444: cln_debug_pub.Add('l_all_cancel_flag: ' || l_all_cancel_flag, 1);
445: cln_debug_pub.Add('l_all_new_flag: ' || l_all_new_flag, 1);
446: cln_debug_pub.Add('l_action_code: ' || l_action_code, 1);
447: END IF;
448:
449: -- Check for header change
450: -- IF it is not a new or cancelled release

Line 464: cln_debug_pub.Add('l_po_rev_num_x - ' ||l_po_rev_num_x,1);

460: l_po_rev_num_x := l_po_rev_num;
461: END IF;
462:
463: IF (g_debug_level <= 1) THEN
464: cln_debug_pub.Add('l_po_rev_num_x - ' ||l_po_rev_num_x,1);
465: END IF;
466:
467: compare_headers(l_po_header_id,l_po_rel_id,l_po_rev_num_x,x_header_change_flag);
468:

Line 470: cln_debug_pub.Add('x_header_change_flag - ' ||x_header_change_flag,1);

466:
467: compare_headers(l_po_header_id,l_po_rel_id,l_po_rev_num_x,x_header_change_flag);
468:
469: IF (g_debug_level <= 1) THEN
470: cln_debug_pub.Add('x_header_change_flag - ' ||x_header_change_flag,1);
471: END IF;
472:
473: END IF;
474: -- Check for header change

Line 489: cln_debug_pub.Add('Inside Cursor for',1);

485: l_lines_loc_chk := NULL;
486: l_lines_chk := NULL;
487:
488: IF (g_debug_level <= 1) THEN
489: cln_debug_pub.Add('Inside Cursor for',1);
490: cln_debug_pub.Add('Line ID - ' || lines_rec.po_line_id,1);
491: cln_debug_pub.Add('Line Location ID - '|| lines_rec.line_location_id,1);
492: cln_debug_pub.Add('Distribution ID - ' || lines_rec.po_distribution_id,1);
493: END IF;

Line 490: cln_debug_pub.Add('Line ID - ' || lines_rec.po_line_id,1);

486: l_lines_chk := NULL;
487:
488: IF (g_debug_level <= 1) THEN
489: cln_debug_pub.Add('Inside Cursor for',1);
490: cln_debug_pub.Add('Line ID - ' || lines_rec.po_line_id,1);
491: cln_debug_pub.Add('Line Location ID - '|| lines_rec.line_location_id,1);
492: cln_debug_pub.Add('Distribution ID - ' || lines_rec.po_distribution_id,1);
493: END IF;
494:

Line 491: cln_debug_pub.Add('Line Location ID - '|| lines_rec.line_location_id,1);

487:
488: IF (g_debug_level <= 1) THEN
489: cln_debug_pub.Add('Inside Cursor for',1);
490: cln_debug_pub.Add('Line ID - ' || lines_rec.po_line_id,1);
491: cln_debug_pub.Add('Line Location ID - '|| lines_rec.line_location_id,1);
492: cln_debug_pub.Add('Distribution ID - ' || lines_rec.po_distribution_id,1);
493: END IF;
494:
495: IF l_all_new_flag = 'Y' THEN

Line 492: cln_debug_pub.Add('Distribution ID - ' || lines_rec.po_distribution_id,1);

488: IF (g_debug_level <= 1) THEN
489: cln_debug_pub.Add('Inside Cursor for',1);
490: cln_debug_pub.Add('Line ID - ' || lines_rec.po_line_id,1);
491: cln_debug_pub.Add('Line Location ID - '|| lines_rec.line_location_id,1);
492: cln_debug_pub.Add('Distribution ID - ' || lines_rec.po_distribution_id,1);
493: END IF;
494:
495: IF l_all_new_flag = 'Y' THEN
496: l_raise_flag := 'Y';

Line 521: cln_debug_pub.Add('l_this_line_loc_cancel - '||l_this_line_loc_cancel,1);

517: l_this_line_loc_cancel := 'Y';
518: END IF;
519:
520: IF (g_debug_level <= 1) THEN
521: cln_debug_pub.Add('l_this_line_loc_cancel - '||l_this_line_loc_cancel,1);
522: END IF;
523: EXCEPTION
524: WHEN NO_DATA_FOUND THEN
525: l_this_line_loc_cancel := 'N';

Line 528: cln_debug_pub.Add('No Rows Found',5);

524: WHEN NO_DATA_FOUND THEN
525: l_this_line_loc_cancel := 'N';
526:
527: IF (g_debug_level <= 5) THEN
528: cln_debug_pub.Add('No Rows Found',5);
529: cln_debug_pub.Add('l_this_line_loc_cancel - '||l_this_line_loc_cancel,5);
530: END IF;
531: END;
532:

Line 529: cln_debug_pub.Add('l_this_line_loc_cancel - '||l_this_line_loc_cancel,5);

525: l_this_line_loc_cancel := 'N';
526:
527: IF (g_debug_level <= 5) THEN
528: cln_debug_pub.Add('No Rows Found',5);
529: cln_debug_pub.Add('l_this_line_loc_cancel - '||l_this_line_loc_cancel,5);
530: END IF;
531: END;
532:
533: IF (l_this_line_loc_cancel <> 'Y') THEN

Line 574: cln_debug_pub.Add('l_lines_chk - ' ||l_lines_chk,1);

570: l_this_line_changed := 'Y';
571: END IF;
572:
573: IF (g_debug_level <= 1) THEN
574: cln_debug_pub.Add('l_lines_chk - ' ||l_lines_chk,1);
575: cln_debug_pub.Add('l_this_line_changed - ' ||l_this_line_changed,1);
576: END IF;
577:
578: EXCEPTION

Line 575: cln_debug_pub.Add('l_this_line_changed - ' ||l_this_line_changed,1);

571: END IF;
572:
573: IF (g_debug_level <= 1) THEN
574: cln_debug_pub.Add('l_lines_chk - ' ||l_lines_chk,1);
575: cln_debug_pub.Add('l_this_line_changed - ' ||l_this_line_changed,1);
576: END IF;
577:
578: EXCEPTION
579: WHEN NO_DATA_FOUND THEN

Line 582: cln_debug_pub.Add('No Rows Found',5);

578: EXCEPTION
579: WHEN NO_DATA_FOUND THEN
580: l_this_line_changed := 'N';
581: IF (g_debug_level <= 5) THEN
582: cln_debug_pub.Add('No Rows Found',5);
583: cln_debug_pub.Add('l_this_line_changed - '||l_this_line_changed,5);
584: END IF;
585: END;
586: END IF;

Line 583: cln_debug_pub.Add('l_this_line_changed - '||l_this_line_changed,5);

579: WHEN NO_DATA_FOUND THEN
580: l_this_line_changed := 'N';
581: IF (g_debug_level <= 5) THEN
582: cln_debug_pub.Add('No Rows Found',5);
583: cln_debug_pub.Add('l_this_line_changed - '||l_this_line_changed,5);
584: END IF;
585: END;
586: END IF;
587:

Line 605: cln_debug_pub.Add('Before Setting the WF attributes', 1);

601:
602: END IF;
603:
604: IF (g_debug_level <= 1) THEN
605: cln_debug_pub.Add('Before Setting the WF attributes', 1);
606: cln_debug_pub.Add('l_action_code : ' || l_action_code, 1);
607: cln_debug_pub.Add('l_raise_flag : ' || l_raise_flag, 1);
608: END IF;
609:

Line 606: cln_debug_pub.Add('l_action_code : ' || l_action_code, 1);

602: END IF;
603:
604: IF (g_debug_level <= 1) THEN
605: cln_debug_pub.Add('Before Setting the WF attributes', 1);
606: cln_debug_pub.Add('l_action_code : ' || l_action_code, 1);
607: cln_debug_pub.Add('l_raise_flag : ' || l_raise_flag, 1);
608: END IF;
609:
610: IF l_raise_flag = 'Y' THEN --- Set the event parameters for Generic Outbound WF

Line 607: cln_debug_pub.Add('l_raise_flag : ' || l_raise_flag, 1);

603:
604: IF (g_debug_level <= 1) THEN
605: cln_debug_pub.Add('Before Setting the WF attributes', 1);
606: cln_debug_pub.Add('l_action_code : ' || l_action_code, 1);
607: cln_debug_pub.Add('l_raise_flag : ' || l_raise_flag, 1);
608: END IF;
609:
610: IF l_raise_flag = 'Y' THEN --- Set the event parameters for Generic Outbound WF
611:

Line 623: cln_debug_pub.Add('Line Revision Number : ' || l_line_rev_num, 1);

619: AND po_line_id = lines_rec.po_line_id
620: AND latest_external_flag = 'Y';
621:
622: IF (g_debug_level <= 1) THEN
623: cln_debug_pub.Add('Line Revision Number : ' || l_line_rev_num, 1);
624: END IF;
625:
626: g_exception_tracking_msg := 'Query po_line_locations_archive_all for line_location_id,revision_num';
627:

Line 647: cln_debug_pub.Add('Line Location ID : ' || l_line_loc_id, 1);

643: AND ((po_release_id = l_po_rel_id) OR (po_release_id IS NULL))
644: );
645:
646: IF (g_debug_level <= 1) THEN
647: cln_debug_pub.Add('Line Location ID : ' || l_line_loc_id, 1);
648: cln_debug_pub.Add('Line Location Revision Number : ' || l_line_loc_rev_num, 1);
649: END IF;
650:
651: g_exception_tracking_msg := 'Query PO_DISTRIBUTIONS_ALL for WIP parameters';

Line 648: cln_debug_pub.Add('Line Location Revision Number : ' || l_line_loc_rev_num, 1);

644: );
645:
646: IF (g_debug_level <= 1) THEN
647: cln_debug_pub.Add('Line Location ID : ' || l_line_loc_id, 1);
648: cln_debug_pub.Add('Line Location Revision Number : ' || l_line_loc_rev_num, 1);
649: END IF;
650:
651: g_exception_tracking_msg := 'Query PO_DISTRIBUTIONS_ALL for WIP parameters';
652:

Line 664: cln_debug_pub.Add('WIP Entity ID : ' || l_wip_entity_id, 1);

660: AND line_location_id = l_line_loc_id
661: AND po_distribution_id = lines_rec.po_distribution_id;
662:
663: IF (g_debug_level <= 1) THEN
664: cln_debug_pub.Add('WIP Entity ID : ' || l_wip_entity_id, 1);
665: cln_debug_pub.Add('WIP Routing Seq Number : ' || l_rout_seq_num, 1);
666: cln_debug_pub.Add('OSFM Org ID : ' || l_osfm_org_id, 1);
667: END IF;
668:

Line 665: cln_debug_pub.Add('WIP Routing Seq Number : ' || l_rout_seq_num, 1);

661: AND po_distribution_id = lines_rec.po_distribution_id;
662:
663: IF (g_debug_level <= 1) THEN
664: cln_debug_pub.Add('WIP Entity ID : ' || l_wip_entity_id, 1);
665: cln_debug_pub.Add('WIP Routing Seq Number : ' || l_rout_seq_num, 1);
666: cln_debug_pub.Add('OSFM Org ID : ' || l_osfm_org_id, 1);
667: END IF;
668:
669: g_exception_tracking_msg := 'Query WSM_WIP_GENEALOGY_V for Assembly parameters';

Line 666: cln_debug_pub.Add('OSFM Org ID : ' || l_osfm_org_id, 1);

662:
663: IF (g_debug_level <= 1) THEN
664: cln_debug_pub.Add('WIP Entity ID : ' || l_wip_entity_id, 1);
665: cln_debug_pub.Add('WIP Routing Seq Number : ' || l_rout_seq_num, 1);
666: cln_debug_pub.Add('OSFM Org ID : ' || l_osfm_org_id, 1);
667: END IF;
668:
669: g_exception_tracking_msg := 'Query WSM_WIP_GENEALOGY_V for Assembly parameters';
670:

Line 679: cln_debug_pub.Add('WIP Job Number/ Entity Name' || l_job_num, 1);

675: WHERE WIP_ENTITY_ID = l_wip_entity_id
676: AND organization_id = l_osfm_org_id;
677:
678: IF (g_debug_level <= 1) THEN
679: cln_debug_pub.Add('WIP Job Number/ Entity Name' || l_job_num, 1);
680: cln_debug_pub.Add('Assembly Name' || l_assembly_name, 1);
681: END IF;
682:
683: l_doc_num := l_job_num ||':' || l_rout_seq_num;

Line 680: cln_debug_pub.Add('Assembly Name' || l_assembly_name, 1);

676: AND organization_id = l_osfm_org_id;
677:
678: IF (g_debug_level <= 1) THEN
679: cln_debug_pub.Add('WIP Job Number/ Entity Name' || l_job_num, 1);
680: cln_debug_pub.Add('Assembly Name' || l_assembly_name, 1);
681: END IF;
682:
683: l_doc_num := l_job_num ||':' || l_rout_seq_num;
684:

Line 686: cln_debug_pub.Add('Document Number' || l_doc_num, 1);

682:
683: l_doc_num := l_job_num ||':' || l_rout_seq_num;
684:
685: IF (g_debug_level <= 1) THEN
686: cln_debug_pub.Add('Document Number' || l_doc_num, 1);
687: END IF;
688:
689: g_exception_tracking_msg := 'Query M4R_7B5_OSFM_S1 into l_doc_id';
690:

Line 698: cln_debug_pub.Add('l_event_key' || l_event_key, 1);

694:
695: l_event_key := '7B5:'|| l_doc_id || to_char(cast(sysdate as timestamp),'DD/MM/YY:HHMMSS');
696:
697: IF (g_debug_level <= 1) THEN
698: cln_debug_pub.Add('l_event_key' || l_event_key, 1);
699: END IF;
700:
701: g_exception_tracking_msg := 'Query wip_operations for Assembly Description';
702:

Line 710: cln_debug_pub.Add('Operation Desc' || l_op_desc, 1);

706: WHERE wip_entity_id = l_wip_entity_id
707: AND operation_seq_num = l_rout_seq_num;
708:
709: IF (g_debug_level <= 1) THEN
710: cln_debug_pub.Add('Operation Desc' || l_op_desc, 1);
711: END IF;
712:
713: IF (g_debug_level <= 2) THEN
714: cln_debug_pub.Add('Raising Generic WF with the following parameters', 2);

Line 714: cln_debug_pub.Add('Raising Generic WF with the following parameters', 2);

710: cln_debug_pub.Add('Operation Desc' || l_op_desc, 1);
711: END IF;
712:
713: IF (g_debug_level <= 2) THEN
714: cln_debug_pub.Add('Raising Generic WF with the following parameters', 2);
715: cln_debug_pub.Add('Party Type : ' || l_party_type,2);
716: cln_debug_pub.Add('Party ID : ' || l_party_id,2);
717: cln_debug_pub.Add('Party Site ID : ' || l_party_site_id,2);
718: cln_debug_pub.Add('Org ID : ' || l_org_id,2);

Line 715: cln_debug_pub.Add('Party Type : ' || l_party_type,2);

711: END IF;
712:
713: IF (g_debug_level <= 2) THEN
714: cln_debug_pub.Add('Raising Generic WF with the following parameters', 2);
715: cln_debug_pub.Add('Party Type : ' || l_party_type,2);
716: cln_debug_pub.Add('Party ID : ' || l_party_id,2);
717: cln_debug_pub.Add('Party Site ID : ' || l_party_site_id,2);
718: cln_debug_pub.Add('Org ID : ' || l_org_id,2);
719: cln_debug_pub.Add('Document Number : ' || l_doc_num,2);

Line 716: cln_debug_pub.Add('Party ID : ' || l_party_id,2);

712:
713: IF (g_debug_level <= 2) THEN
714: cln_debug_pub.Add('Raising Generic WF with the following parameters', 2);
715: cln_debug_pub.Add('Party Type : ' || l_party_type,2);
716: cln_debug_pub.Add('Party ID : ' || l_party_id,2);
717: cln_debug_pub.Add('Party Site ID : ' || l_party_site_id,2);
718: cln_debug_pub.Add('Org ID : ' || l_org_id,2);
719: cln_debug_pub.Add('Document Number : ' || l_doc_num,2);
720: cln_debug_pub.Add('Document ID : ' || l_doc_id,2);

Line 717: cln_debug_pub.Add('Party Site ID : ' || l_party_site_id,2);

713: IF (g_debug_level <= 2) THEN
714: cln_debug_pub.Add('Raising Generic WF with the following parameters', 2);
715: cln_debug_pub.Add('Party Type : ' || l_party_type,2);
716: cln_debug_pub.Add('Party ID : ' || l_party_id,2);
717: cln_debug_pub.Add('Party Site ID : ' || l_party_site_id,2);
718: cln_debug_pub.Add('Org ID : ' || l_org_id,2);
719: cln_debug_pub.Add('Document Number : ' || l_doc_num,2);
720: cln_debug_pub.Add('Document ID : ' || l_doc_id,2);
721: cln_debug_pub.Add('PO Header ID : ' || l_po_header_id,2);

Line 718: cln_debug_pub.Add('Org ID : ' || l_org_id,2);

714: cln_debug_pub.Add('Raising Generic WF with the following parameters', 2);
715: cln_debug_pub.Add('Party Type : ' || l_party_type,2);
716: cln_debug_pub.Add('Party ID : ' || l_party_id,2);
717: cln_debug_pub.Add('Party Site ID : ' || l_party_site_id,2);
718: cln_debug_pub.Add('Org ID : ' || l_org_id,2);
719: cln_debug_pub.Add('Document Number : ' || l_doc_num,2);
720: cln_debug_pub.Add('Document ID : ' || l_doc_id,2);
721: cln_debug_pub.Add('PO Header ID : ' || l_po_header_id,2);
722: cln_debug_pub.Add('PO Release ID : ' || l_po_rel_id,2);

Line 719: cln_debug_pub.Add('Document Number : ' || l_doc_num,2);

715: cln_debug_pub.Add('Party Type : ' || l_party_type,2);
716: cln_debug_pub.Add('Party ID : ' || l_party_id,2);
717: cln_debug_pub.Add('Party Site ID : ' || l_party_site_id,2);
718: cln_debug_pub.Add('Org ID : ' || l_org_id,2);
719: cln_debug_pub.Add('Document Number : ' || l_doc_num,2);
720: cln_debug_pub.Add('Document ID : ' || l_doc_id,2);
721: cln_debug_pub.Add('PO Header ID : ' || l_po_header_id,2);
722: cln_debug_pub.Add('PO Release ID : ' || l_po_rel_id,2);
723:

Line 720: cln_debug_pub.Add('Document ID : ' || l_doc_id,2);

716: cln_debug_pub.Add('Party ID : ' || l_party_id,2);
717: cln_debug_pub.Add('Party Site ID : ' || l_party_site_id,2);
718: cln_debug_pub.Add('Org ID : ' || l_org_id,2);
719: cln_debug_pub.Add('Document Number : ' || l_doc_num,2);
720: cln_debug_pub.Add('Document ID : ' || l_doc_id,2);
721: cln_debug_pub.Add('PO Header ID : ' || l_po_header_id,2);
722: cln_debug_pub.Add('PO Release ID : ' || l_po_rel_id,2);
723:
724: cln_debug_pub.Add('PO Line ID : ' || lines_rec.po_line_id,2);

Line 721: cln_debug_pub.Add('PO Header ID : ' || l_po_header_id,2);

717: cln_debug_pub.Add('Party Site ID : ' || l_party_site_id,2);
718: cln_debug_pub.Add('Org ID : ' || l_org_id,2);
719: cln_debug_pub.Add('Document Number : ' || l_doc_num,2);
720: cln_debug_pub.Add('Document ID : ' || l_doc_id,2);
721: cln_debug_pub.Add('PO Header ID : ' || l_po_header_id,2);
722: cln_debug_pub.Add('PO Release ID : ' || l_po_rel_id,2);
723:
724: cln_debug_pub.Add('PO Line ID : ' || lines_rec.po_line_id,2);
725: cln_debug_pub.Add('PO Line Location ID : ' || l_line_loc_id,2);

Line 722: cln_debug_pub.Add('PO Release ID : ' || l_po_rel_id,2);

718: cln_debug_pub.Add('Org ID : ' || l_org_id,2);
719: cln_debug_pub.Add('Document Number : ' || l_doc_num,2);
720: cln_debug_pub.Add('Document ID : ' || l_doc_id,2);
721: cln_debug_pub.Add('PO Header ID : ' || l_po_header_id,2);
722: cln_debug_pub.Add('PO Release ID : ' || l_po_rel_id,2);
723:
724: cln_debug_pub.Add('PO Line ID : ' || lines_rec.po_line_id,2);
725: cln_debug_pub.Add('PO Line Location ID : ' || l_line_loc_id,2);
726: cln_debug_pub.Add('PO Revision Number : ' || l_po_rev_num,2);

Line 724: cln_debug_pub.Add('PO Line ID : ' || lines_rec.po_line_id,2);

720: cln_debug_pub.Add('Document ID : ' || l_doc_id,2);
721: cln_debug_pub.Add('PO Header ID : ' || l_po_header_id,2);
722: cln_debug_pub.Add('PO Release ID : ' || l_po_rel_id,2);
723:
724: cln_debug_pub.Add('PO Line ID : ' || lines_rec.po_line_id,2);
725: cln_debug_pub.Add('PO Line Location ID : ' || l_line_loc_id,2);
726: cln_debug_pub.Add('PO Revision Number : ' || l_po_rev_num,2);
727: cln_debug_pub.Add('PO Release Number : ' || l_po_rel_num,2);
728: cln_debug_pub.Add('PO Release Revision Number : ' || l_po_rel_rev_num,2);

Line 725: cln_debug_pub.Add('PO Line Location ID : ' || l_line_loc_id,2);

721: cln_debug_pub.Add('PO Header ID : ' || l_po_header_id,2);
722: cln_debug_pub.Add('PO Release ID : ' || l_po_rel_id,2);
723:
724: cln_debug_pub.Add('PO Line ID : ' || lines_rec.po_line_id,2);
725: cln_debug_pub.Add('PO Line Location ID : ' || l_line_loc_id,2);
726: cln_debug_pub.Add('PO Revision Number : ' || l_po_rev_num,2);
727: cln_debug_pub.Add('PO Release Number : ' || l_po_rel_num,2);
728: cln_debug_pub.Add('PO Release Revision Number : ' || l_po_rel_rev_num,2);
729: cln_debug_pub.Add('PO Lines Revision Number : ' || l_line_rev_num,2);

Line 726: cln_debug_pub.Add('PO Revision Number : ' || l_po_rev_num,2);

722: cln_debug_pub.Add('PO Release ID : ' || l_po_rel_id,2);
723:
724: cln_debug_pub.Add('PO Line ID : ' || lines_rec.po_line_id,2);
725: cln_debug_pub.Add('PO Line Location ID : ' || l_line_loc_id,2);
726: cln_debug_pub.Add('PO Revision Number : ' || l_po_rev_num,2);
727: cln_debug_pub.Add('PO Release Number : ' || l_po_rel_num,2);
728: cln_debug_pub.Add('PO Release Revision Number : ' || l_po_rel_rev_num,2);
729: cln_debug_pub.Add('PO Lines Revision Number : ' || l_line_rev_num,2);
730: cln_debug_pub.Add('Line Locations Revision Number : ' || l_line_loc_rev_num,2);

Line 727: cln_debug_pub.Add('PO Release Number : ' || l_po_rel_num,2);

723:
724: cln_debug_pub.Add('PO Line ID : ' || lines_rec.po_line_id,2);
725: cln_debug_pub.Add('PO Line Location ID : ' || l_line_loc_id,2);
726: cln_debug_pub.Add('PO Revision Number : ' || l_po_rev_num,2);
727: cln_debug_pub.Add('PO Release Number : ' || l_po_rel_num,2);
728: cln_debug_pub.Add('PO Release Revision Number : ' || l_po_rel_rev_num,2);
729: cln_debug_pub.Add('PO Lines Revision Number : ' || l_line_rev_num,2);
730: cln_debug_pub.Add('Line Locations Revision Number : ' || l_line_loc_rev_num,2);
731: cln_debug_pub.Add('Document Creation Date : ' || l_cn_create_date,2);

Line 728: cln_debug_pub.Add('PO Release Revision Number : ' || l_po_rel_rev_num,2);

724: cln_debug_pub.Add('PO Line ID : ' || lines_rec.po_line_id,2);
725: cln_debug_pub.Add('PO Line Location ID : ' || l_line_loc_id,2);
726: cln_debug_pub.Add('PO Revision Number : ' || l_po_rev_num,2);
727: cln_debug_pub.Add('PO Release Number : ' || l_po_rel_num,2);
728: cln_debug_pub.Add('PO Release Revision Number : ' || l_po_rel_rev_num,2);
729: cln_debug_pub.Add('PO Lines Revision Number : ' || l_line_rev_num,2);
730: cln_debug_pub.Add('Line Locations Revision Number : ' || l_line_loc_rev_num,2);
731: cln_debug_pub.Add('Document Creation Date : ' || l_cn_create_date,2);
732:

Line 729: cln_debug_pub.Add('PO Lines Revision Number : ' || l_line_rev_num,2);

725: cln_debug_pub.Add('PO Line Location ID : ' || l_line_loc_id,2);
726: cln_debug_pub.Add('PO Revision Number : ' || l_po_rev_num,2);
727: cln_debug_pub.Add('PO Release Number : ' || l_po_rel_num,2);
728: cln_debug_pub.Add('PO Release Revision Number : ' || l_po_rel_rev_num,2);
729: cln_debug_pub.Add('PO Lines Revision Number : ' || l_line_rev_num,2);
730: cln_debug_pub.Add('Line Locations Revision Number : ' || l_line_loc_rev_num,2);
731: cln_debug_pub.Add('Document Creation Date : ' || l_cn_create_date,2);
732:
733: cln_debug_pub.Add('Document Revision Date : ' || l_cn_rev_date,2);

Line 730: cln_debug_pub.Add('Line Locations Revision Number : ' || l_line_loc_rev_num,2);

726: cln_debug_pub.Add('PO Revision Number : ' || l_po_rev_num,2);
727: cln_debug_pub.Add('PO Release Number : ' || l_po_rel_num,2);
728: cln_debug_pub.Add('PO Release Revision Number : ' || l_po_rel_rev_num,2);
729: cln_debug_pub.Add('PO Lines Revision Number : ' || l_line_rev_num,2);
730: cln_debug_pub.Add('Line Locations Revision Number : ' || l_line_loc_rev_num,2);
731: cln_debug_pub.Add('Document Creation Date : ' || l_cn_create_date,2);
732:
733: cln_debug_pub.Add('Document Revision Date : ' || l_cn_rev_date,2);
734: cln_debug_pub.Add('Action Code : ' || l_action_code,2);

Line 731: cln_debug_pub.Add('Document Creation Date : ' || l_cn_create_date,2);

727: cln_debug_pub.Add('PO Release Number : ' || l_po_rel_num,2);
728: cln_debug_pub.Add('PO Release Revision Number : ' || l_po_rel_rev_num,2);
729: cln_debug_pub.Add('PO Lines Revision Number : ' || l_line_rev_num,2);
730: cln_debug_pub.Add('Line Locations Revision Number : ' || l_line_loc_rev_num,2);
731: cln_debug_pub.Add('Document Creation Date : ' || l_cn_create_date,2);
732:
733: cln_debug_pub.Add('Document Revision Date : ' || l_cn_rev_date,2);
734: cln_debug_pub.Add('Action Code : ' || l_action_code,2);
735: cln_debug_pub.Add('WIP Entity ID : ' || l_wip_entity_id,2);

Line 733: cln_debug_pub.Add('Document Revision Date : ' || l_cn_rev_date,2);

729: cln_debug_pub.Add('PO Lines Revision Number : ' || l_line_rev_num,2);
730: cln_debug_pub.Add('Line Locations Revision Number : ' || l_line_loc_rev_num,2);
731: cln_debug_pub.Add('Document Creation Date : ' || l_cn_create_date,2);
732:
733: cln_debug_pub.Add('Document Revision Date : ' || l_cn_rev_date,2);
734: cln_debug_pub.Add('Action Code : ' || l_action_code,2);
735: cln_debug_pub.Add('WIP Entity ID : ' || l_wip_entity_id,2);
736: cln_debug_pub.Add('Assembly Name : ' || l_assembly_name,2);
737: cln_debug_pub.Add('Operation Desc : ' || l_op_desc,2);

Line 734: cln_debug_pub.Add('Action Code : ' || l_action_code,2);

730: cln_debug_pub.Add('Line Locations Revision Number : ' || l_line_loc_rev_num,2);
731: cln_debug_pub.Add('Document Creation Date : ' || l_cn_create_date,2);
732:
733: cln_debug_pub.Add('Document Revision Date : ' || l_cn_rev_date,2);
734: cln_debug_pub.Add('Action Code : ' || l_action_code,2);
735: cln_debug_pub.Add('WIP Entity ID : ' || l_wip_entity_id,2);
736: cln_debug_pub.Add('Assembly Name : ' || l_assembly_name,2);
737: cln_debug_pub.Add('Operation Desc : ' || l_op_desc,2);
738: cln_debug_pub.Add('Operation Sequence Number : ' || l_rout_seq_num,2);

Line 735: cln_debug_pub.Add('WIP Entity ID : ' || l_wip_entity_id,2);

731: cln_debug_pub.Add('Document Creation Date : ' || l_cn_create_date,2);
732:
733: cln_debug_pub.Add('Document Revision Date : ' || l_cn_rev_date,2);
734: cln_debug_pub.Add('Action Code : ' || l_action_code,2);
735: cln_debug_pub.Add('WIP Entity ID : ' || l_wip_entity_id,2);
736: cln_debug_pub.Add('Assembly Name : ' || l_assembly_name,2);
737: cln_debug_pub.Add('Operation Desc : ' || l_op_desc,2);
738: cln_debug_pub.Add('Operation Sequence Number : ' || l_rout_seq_num,2);
739: cln_debug_pub.Add('Reference ID : ' || l_event_key,2);

Line 736: cln_debug_pub.Add('Assembly Name : ' || l_assembly_name,2);

732:
733: cln_debug_pub.Add('Document Revision Date : ' || l_cn_rev_date,2);
734: cln_debug_pub.Add('Action Code : ' || l_action_code,2);
735: cln_debug_pub.Add('WIP Entity ID : ' || l_wip_entity_id,2);
736: cln_debug_pub.Add('Assembly Name : ' || l_assembly_name,2);
737: cln_debug_pub.Add('Operation Desc : ' || l_op_desc,2);
738: cln_debug_pub.Add('Operation Sequence Number : ' || l_rout_seq_num,2);
739: cln_debug_pub.Add('Reference ID : ' || l_event_key,2);
740: cln_debug_pub.Add('UOM : ' || l_uom,2);

Line 737: cln_debug_pub.Add('Operation Desc : ' || l_op_desc,2);

733: cln_debug_pub.Add('Document Revision Date : ' || l_cn_rev_date,2);
734: cln_debug_pub.Add('Action Code : ' || l_action_code,2);
735: cln_debug_pub.Add('WIP Entity ID : ' || l_wip_entity_id,2);
736: cln_debug_pub.Add('Assembly Name : ' || l_assembly_name,2);
737: cln_debug_pub.Add('Operation Desc : ' || l_op_desc,2);
738: cln_debug_pub.Add('Operation Sequence Number : ' || l_rout_seq_num,2);
739: cln_debug_pub.Add('Reference ID : ' || l_event_key,2);
740: cln_debug_pub.Add('UOM : ' || l_uom,2);
741: END IF;

Line 738: cln_debug_pub.Add('Operation Sequence Number : ' || l_rout_seq_num,2);

734: cln_debug_pub.Add('Action Code : ' || l_action_code,2);
735: cln_debug_pub.Add('WIP Entity ID : ' || l_wip_entity_id,2);
736: cln_debug_pub.Add('Assembly Name : ' || l_assembly_name,2);
737: cln_debug_pub.Add('Operation Desc : ' || l_op_desc,2);
738: cln_debug_pub.Add('Operation Sequence Number : ' || l_rout_seq_num,2);
739: cln_debug_pub.Add('Reference ID : ' || l_event_key,2);
740: cln_debug_pub.Add('UOM : ' || l_uom,2);
741: END IF;
742:

Line 739: cln_debug_pub.Add('Reference ID : ' || l_event_key,2);

735: cln_debug_pub.Add('WIP Entity ID : ' || l_wip_entity_id,2);
736: cln_debug_pub.Add('Assembly Name : ' || l_assembly_name,2);
737: cln_debug_pub.Add('Operation Desc : ' || l_op_desc,2);
738: cln_debug_pub.Add('Operation Sequence Number : ' || l_rout_seq_num,2);
739: cln_debug_pub.Add('Reference ID : ' || l_event_key,2);
740: cln_debug_pub.Add('UOM : ' || l_uom,2);
741: END IF;
742:
743: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'M4R', l_gen_wf_param);

Line 740: cln_debug_pub.Add('UOM : ' || l_uom,2);

736: cln_debug_pub.Add('Assembly Name : ' || l_assembly_name,2);
737: cln_debug_pub.Add('Operation Desc : ' || l_op_desc,2);
738: cln_debug_pub.Add('Operation Sequence Number : ' || l_rout_seq_num,2);
739: cln_debug_pub.Add('Reference ID : ' || l_event_key,2);
740: cln_debug_pub.Add('UOM : ' || l_uom,2);
741: END IF;
742:
743: WF_EVENT.AddParameterToList('ECX_TRANSACTION_TYPE', 'M4R', l_gen_wf_param);
744: WF_EVENT.AddParameterToList('ECX_TRANSACTION_SUBTYPE', '7B5_OSFM_WO', l_gen_wf_param);

Line 802: cln_debug_pub.Add('ATTRIBUTE4 : ' || l_po_rev_num || ' Header Revision Number' ,2);

798: WF_EVENT.AddParameterToList('ATTRIBUTE4', l_po_rev_num, l_gen_wf_param); ---- PO Revision Number
799: END IF;
800:
801: IF (g_debug_level <= 2) THEN
802: cln_debug_pub.Add('ATTRIBUTE4 : ' || l_po_rev_num || ' Header Revision Number' ,2);
803: END IF;
804:
805: WF_EVENT.AddParameterToList('REFERENCE_ID', l_event_key, l_gen_wf_param);
806:

Line 810: cln_debug_pub.Add('---------Generic Workflow Triggered ---------', 1);

806:
807: WF_EVENT.Raise('oracle.apps.cln.common.xml.out',l_event_key, NULL, l_gen_wf_param, NULL);
808:
809: IF (g_debug_Level <= 1) THEN
810: cln_debug_pub.Add('---------Generic Workflow Triggered ---------', 1);
811: END IF;
812: END IF; -- For Raise Flag = Y
813: -- reset l_raise_flag before next iteration
814: l_raise_flag := 'N';

Line 821: cln_debug_pub.Add('Exiting the M4R_7B5_OSFM_PKG.PROCESS_WO procedure', 2);

817:
818: x_resultout := wf_engine.eng_completed;
819:
820: IF (g_debug_level <= 2) THEN
821: cln_debug_pub.Add('Exiting the M4R_7B5_OSFM_PKG.PROCESS_WO procedure', 2);
822: END IF;
823:
824: EXCEPTION
825: WHEN OTHERS THEN

Line 830: cln_debug_pub.Add('g_exception_tracking_msg : ' || g_exception_tracking_msg,5);

826: l_error_code := SQLCODE;
827: l_errmsg := SQLERRM;
828:
829: IF (g_debug_level <= 5) THEN
830: cln_debug_pub.Add('g_exception_tracking_msg : ' || g_exception_tracking_msg,5);
831: cln_debug_pub.Add('Exception in PROCESS_WO proc', 5);
832: cln_debug_pub.Add('Error is ' || l_error_code || ':' || l_errmsg, 5);
833: END IF;
834:

Line 831: cln_debug_pub.Add('Exception in PROCESS_WO proc', 5);

827: l_errmsg := SQLERRM;
828:
829: IF (g_debug_level <= 5) THEN
830: cln_debug_pub.Add('g_exception_tracking_msg : ' || g_exception_tracking_msg,5);
831: cln_debug_pub.Add('Exception in PROCESS_WO proc', 5);
832: cln_debug_pub.Add('Error is ' || l_error_code || ':' || l_errmsg, 5);
833: END IF;
834:
835: END PROCESS_WO;

Line 832: cln_debug_pub.Add('Error is ' || l_error_code || ':' || l_errmsg, 5);

828:
829: IF (g_debug_level <= 5) THEN
830: cln_debug_pub.Add('g_exception_tracking_msg : ' || g_exception_tracking_msg,5);
831: cln_debug_pub.Add('Exception in PROCESS_WO proc', 5);
832: cln_debug_pub.Add('Error is ' || l_error_code || ':' || l_errmsg, 5);
833: END IF;
834:
835: END PROCESS_WO;
836:

Line 876: cln_debug_pub.Add('Entering M4R_7B5_OSFM_PKG.compare_headers', 2);

872:
873: BEGIN
874:
875: IF (g_debug_level <= 2) THEN
876: cln_debug_pub.Add('Entering M4R_7B5_OSFM_PKG.compare_headers', 2);
877: END IF;
878:
879: IF p_revision_num <= 0
880: THEN

Line 917: cln_debug_pub.Add('Exception in COMPARE_PO proc - headers query - NO DATA FOUND', 5);

913: EXCEPTION
914: WHEN no_data_found THEN
915:
916: IF (g_debug_level <= 5) THEN
917: cln_debug_pub.Add('Exception in COMPARE_PO proc - headers query - NO DATA FOUND', 5);
918: END IF;
919: END;
920:
921: IF ((NVL( l_from_ship_to_location_id, -99 ) <> NVL( l_to_ship_to_location_id, -99 )) OR

Line 953: cln_debug_pub.Add('Exception in COMPARE_PO proc - releases query - NO DATA FOUND', 5);

949:
950: EXCEPTION
951: WHEN NO_DATA_FOUND THEN
952: IF (g_debug_level <= 5) THEN
953: cln_debug_pub.Add('Exception in COMPARE_PO proc - releases query - NO DATA FOUND', 5);
954: END IF;
955:
956: END;
957:

Line 972: cln_debug_pub.Add('g_exception_tracking_msg :' || g_exception_tracking_msg,5);

968: l_error_code := SQLCODE;
969: l_errmsg := SQLERRM;
970:
971: IF (g_debug_level <= 5) THEN
972: cln_debug_pub.Add('g_exception_tracking_msg :' || g_exception_tracking_msg,5);
973: cln_debug_pub.Add('Exception in PROCESS_WO proc', 5);
974: cln_debug_pub.Add('Error is ' || l_error_code || ':' || l_errmsg, 5);
975: END IF;
976:

Line 973: cln_debug_pub.Add('Exception in PROCESS_WO proc', 5);

969: l_errmsg := SQLERRM;
970:
971: IF (g_debug_level <= 5) THEN
972: cln_debug_pub.Add('g_exception_tracking_msg :' || g_exception_tracking_msg,5);
973: cln_debug_pub.Add('Exception in PROCESS_WO proc', 5);
974: cln_debug_pub.Add('Error is ' || l_error_code || ':' || l_errmsg, 5);
975: END IF;
976:
977: END compare_headers;

Line 974: cln_debug_pub.Add('Error is ' || l_error_code || ':' || l_errmsg, 5);

970:
971: IF (g_debug_level <= 5) THEN
972: cln_debug_pub.Add('g_exception_tracking_msg :' || g_exception_tracking_msg,5);
973: cln_debug_pub.Add('Exception in PROCESS_WO proc', 5);
974: cln_debug_pub.Add('Error is ' || l_error_code || ':' || l_errmsg, 5);
975: END IF;
976:
977: END compare_headers;
978: