APPS.CLN_3A9_CANCELPO_PKG dependencies on CLN_3A9_CANCELPO_PKG

Line 1: PACKAGE BODY CLN_3A9_CANCELPO_PKG AS

1: PACKAGE BODY CLN_3A9_CANCELPO_PKG AS
2: /* $Header: CLN3A9PB.pls 115.6 2003/06/27 16:16:00 kkram noship $ */
3: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
4:
5: /*

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 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 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 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 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 301: END CLN_3A9_CANCELPO_PKG;

297: NULL;
298: END IS_XML_CHOSEN;
299:
300:
301: END CLN_3A9_CANCELPO_PKG;