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

Line 32: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');

28: l_error_msg VARCHAR2(1000);
29: l_not_msg VARCHAR2(1000);
30: BEGIN
31: -- Sets the debug mode to FILE
32: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
33:
34: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.RAISE_CLN_EVENT CALLED', 2);
35:
36: -- Raise event if it is a Standard PO or Release, else return

Line 34: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.RAISE_CLN_EVENT CALLED', 2);

30: BEGIN
31: -- Sets the debug mode to FILE
32: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
33:
34: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.RAISE_CLN_EVENT CALLED', 2);
35:
36: -- Raise event if it is a Standard PO or Release, else return
37: -- If the PO/Release is not approved then return
38: l_cln_not_parameters := wf_parameter_list_t();

Line 74: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.RAISE_CLN_EVENT EXITED', 2);

70:
71: -- Raise Cancel PO event
72: WF_EVENT.Raise('oracle.apps.cln.po.cancelpo', 'clncpo-' || l_cln_event_key, NULL, l_cln_not_parameters, NULL);
73:
74: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.RAISE_CLN_EVENT EXITED', 2);
75: EXCEPTION
76: WHEN OTHERS THEN
77: l_error_code := SQLCODE;
78: l_error_msg := SQLERRM;

Line 84: cln_debug_pub.Add(l_not_msg, 6);

80: FND_MESSAGE.SET_NAME('CLN','CLN_3A9_EVENT_RAISE_ERROR');
81: FND_MESSAGE.SET_TOKEN('POHEADERID', p_document_id);
82: FND_MESSAGE.SET_TOKEN('DBERRMSG', l_error_code || ':' || l_error_msg);
83: l_not_msg := FND_MESSAGE.GET;
84: cln_debug_pub.Add(l_not_msg, 6);
85: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_not_msg);
86: cln_debug_pub.Add('RAISE_CLN_EVENT EXITED', 2);
87: END RAISE_CANCEL_PO_EVENT;
88: */

Line 86: cln_debug_pub.Add('RAISE_CLN_EVENT EXITED', 2);

82: FND_MESSAGE.SET_TOKEN('DBERRMSG', l_error_code || ':' || l_error_msg);
83: l_not_msg := FND_MESSAGE.GET;
84: cln_debug_pub.Add(l_not_msg, 6);
85: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_not_msg);
86: cln_debug_pub.Add('RAISE_CLN_EVENT EXITED', 2);
87: END RAISE_CANCEL_PO_EVENT;
88: */
89:
90:

Line 125: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');

121: l_error_msg VARCHAR2(1000);
122: l_not_msg VARCHAR2(1000);
123: BEGIN
124: -- Sets the debug mode to FILE
125: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
126:
127: IF (l_Debug_Level <= 2) THEN
128: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.SETATTRIBUTES CALLED', 2);
129: END IF;

Line 128: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.SETATTRIBUTES CALLED', 2);

124: -- Sets the debug mode to FILE
125: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
126:
127: IF (l_Debug_Level <= 2) THEN
128: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.SETATTRIBUTES CALLED', 2);
129: END IF;
130:
131: l_po_header_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'POHEADERID'));
132: l_po_release_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PORELEASEID'));

Line 135: cln_debug_pub.Add('l_po_header_id:' || l_po_header_id, 1);

131: l_po_header_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'POHEADERID'));
132: l_po_release_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PORELEASEID'));
133:
134: IF (l_Debug_Level <= 1) THEN
135: cln_debug_pub.Add('l_po_header_id:' || l_po_header_id, 1);
136: cln_debug_pub.Add('l_po_release_id:' || l_po_release_id, 1);
137: END IF;
138:
139: -- Query PO base tables/views to get PO Number, release number, revision number,

Line 136: cln_debug_pub.Add('l_po_release_id:' || l_po_release_id, 1);

132: l_po_release_id := TO_NUMBER(wf_engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'PORELEASEID'));
133:
134: IF (l_Debug_Level <= 1) THEN
135: cln_debug_pub.Add('l_po_header_id:' || l_po_header_id, 1);
136: cln_debug_pub.Add('l_po_release_id:' || l_po_release_id, 1);
137: END IF;
138:
139: -- Query PO base tables/views to get PO Number, release number, revision number,
140: -- and Sales Order Number based on PO Header ID or Po Release ID

Line 157: cln_debug_pub.Add('l_po_header_id:' || l_po_header_id, 1);

153: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'POHEADERID', l_po_header_id);
154: END IF;
155:
156: IF (l_Debug_Level <= 1) THEN
157: cln_debug_pub.Add('l_po_header_id:' || l_po_header_id, 1);
158: cln_debug_pub.Add('l_po_release_id:' || l_po_release_id, 1);
159: cln_debug_pub.Add('l_po_number:' || l_po_number, 1);
160: cln_debug_pub.Add('l_rel_number:' || l_rel_number, 1);
161: cln_debug_pub.Add('l_rev_number:' || l_rev_number, 1);

Line 158: cln_debug_pub.Add('l_po_release_id:' || l_po_release_id, 1);

154: END IF;
155:
156: IF (l_Debug_Level <= 1) THEN
157: cln_debug_pub.Add('l_po_header_id:' || l_po_header_id, 1);
158: cln_debug_pub.Add('l_po_release_id:' || l_po_release_id, 1);
159: cln_debug_pub.Add('l_po_number:' || l_po_number, 1);
160: cln_debug_pub.Add('l_rel_number:' || l_rel_number, 1);
161: cln_debug_pub.Add('l_rev_number:' || l_rev_number, 1);
162: cln_debug_pub.Add('l_supp_ord_number:' || l_supp_ord_number, 1);

Line 159: cln_debug_pub.Add('l_po_number:' || l_po_number, 1);

155:
156: IF (l_Debug_Level <= 1) THEN
157: cln_debug_pub.Add('l_po_header_id:' || l_po_header_id, 1);
158: cln_debug_pub.Add('l_po_release_id:' || l_po_release_id, 1);
159: cln_debug_pub.Add('l_po_number:' || l_po_number, 1);
160: cln_debug_pub.Add('l_rel_number:' || l_rel_number, 1);
161: cln_debug_pub.Add('l_rev_number:' || l_rev_number, 1);
162: cln_debug_pub.Add('l_supp_ord_number:' || l_supp_ord_number, 1);
163: END IF;

Line 160: cln_debug_pub.Add('l_rel_number:' || l_rel_number, 1);

156: IF (l_Debug_Level <= 1) THEN
157: cln_debug_pub.Add('l_po_header_id:' || l_po_header_id, 1);
158: cln_debug_pub.Add('l_po_release_id:' || l_po_release_id, 1);
159: cln_debug_pub.Add('l_po_number:' || l_po_number, 1);
160: cln_debug_pub.Add('l_rel_number:' || l_rel_number, 1);
161: cln_debug_pub.Add('l_rev_number:' || l_rev_number, 1);
162: cln_debug_pub.Add('l_supp_ord_number:' || l_supp_ord_number, 1);
163: END IF;
164:

Line 161: cln_debug_pub.Add('l_rev_number:' || l_rev_number, 1);

157: cln_debug_pub.Add('l_po_header_id:' || l_po_header_id, 1);
158: cln_debug_pub.Add('l_po_release_id:' || l_po_release_id, 1);
159: cln_debug_pub.Add('l_po_number:' || l_po_number, 1);
160: cln_debug_pub.Add('l_rel_number:' || l_rel_number, 1);
161: cln_debug_pub.Add('l_rev_number:' || l_rev_number, 1);
162: cln_debug_pub.Add('l_supp_ord_number:' || l_supp_ord_number, 1);
163: END IF;
164:
165: /* -- This is not required since it is taken care in XMG query

Line 162: cln_debug_pub.Add('l_supp_ord_number:' || l_supp_ord_number, 1);

158: cln_debug_pub.Add('l_po_release_id:' || l_po_release_id, 1);
159: cln_debug_pub.Add('l_po_number:' || l_po_number, 1);
160: cln_debug_pub.Add('l_rel_number:' || l_rel_number, 1);
161: cln_debug_pub.Add('l_rev_number:' || l_rev_number, 1);
162: cln_debug_pub.Add('l_supp_ord_number:' || l_supp_ord_number, 1);
163: END IF;
164:
165: /* -- This is not required since it is taken care in XMG query
166: -- Upon PO cancellation, PO revision number is incremented by 1 in the PO Header table

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

185: FROM PO_HEADERS_ALL
186: WHERE PO_HEADER_ID = l_po_header_id;
187:
188: IF (l_Debug_Level <= 1) THEN
189: cln_debug_pub.Add('l_party_id:' || l_party_id, 1);
190: cln_debug_pub.Add('l_party_site_id:' || l_party_site_id, 1);
191: END IF;
192:
193: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTYID', l_party_id);

Line 190: cln_debug_pub.Add('l_party_site_id:' || l_party_site_id, 1);

186: WHERE PO_HEADER_ID = l_po_header_id;
187:
188: IF (l_Debug_Level <= 1) THEN
189: cln_debug_pub.Add('l_party_id:' || l_party_id, 1);
190: cln_debug_pub.Add('l_party_site_id:' || l_party_site_id, 1);
191: END IF;
192:
193: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTYID', l_party_id);
194: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTYSIDEID', l_party_site_id);

Line 210: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.SETATTRIBUTES EXITED', 2);

206: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRANSACTIONSUBTYPE', 'CANCELPO');
207:
208: x_resultout:='Yes';
209: IF (l_Debug_Level <= 2) THEN
210: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.SETATTRIBUTES EXITED', 2);
211: END IF;
212: EXCEPTION
213: WHEN OTHERS THEN
214: l_error_code := SQLCODE;

Line 221: cln_debug_pub.Add(l_not_msg, 6);

217: FND_MESSAGE.SET_TOKEN('POHEADERID', l_po_header_id);
218: FND_MESSAGE.SET_TOKEN('DBERRMSG', l_error_code || ':' || l_error_msg);
219: l_not_msg := FND_MESSAGE.GET;
220: IF (l_Debug_Level <= 6) THEN
221: cln_debug_pub.Add(l_not_msg, 6);
222: END IF;
223: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_not_msg);
224: END SETATTRIBUTES;
225:

Line 252: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.IS_XML_CHOSEN CALLED', 2);

248: l_error_msg VARCHAR2(1000);
249: l_not_msg VARCHAR2(1000);
250: BEGIN
251: IF (l_Debug_Level <= 2) THEN
252: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.IS_XML_CHOSEN CALLED', 2);
253: END IF;
254:
255: x_resultout := 'COMPLETE:F';
256:

Line 279: cln_debug_pub.Add('l_xml_flag:' || l_xml_flag, 1);

275: x_resultout := 'COMPLETE:T';
276: END IF;
277:
278: IF (l_Debug_Level <= 1) THEN
279: cln_debug_pub.Add('l_xml_flag:' || l_xml_flag, 1);
280: END IF;
281: IF (l_Debug_Level <= 2) THEN
282: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.IS_XML_CHOSEN EXITED', 2);
283: END IF;

Line 282: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.IS_XML_CHOSEN EXITED', 2);

278: IF (l_Debug_Level <= 1) THEN
279: cln_debug_pub.Add('l_xml_flag:' || l_xml_flag, 1);
280: END IF;
281: IF (l_Debug_Level <= 2) THEN
282: cln_debug_pub.Add('CLN_3A9_CANCELPO_PKG.IS_XML_CHOSEN EXITED', 2);
283: END IF;
284: EXCEPTION
285: WHEN OTHERS THEN
286: x_resultout := 'COMPLETE:F';

Line 294: cln_debug_pub.Add(l_not_msg, 6);

290: FND_MESSAGE.SET_TOKEN('POHEADERID', l_po_header_id);
291: FND_MESSAGE.SET_TOKEN('DBERRMSG', l_error_code || ':' || l_error_msg);
292: l_not_msg := FND_MESSAGE.GET;
293: IF (l_Debug_Level <= 6) THEN
294: cln_debug_pub.Add(l_not_msg, 6);
295: END IF;
296: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_not_msg);
297: NULL;
298: END IS_XML_CHOSEN;