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_OM_CONF_PKG dependencies on CLN_DEBUG_PUB

Line 61: cln_debug_pub.Add('ENTERING GET_OM_CONF_PARAMS', 1);

57: l_eventkey VARCHAR2(100);
58: l_transaction_type_passed_in VARCHAR2(100);
59: BEGIN
60: IF (l_debug_level <= 1) THEN
61: cln_debug_pub.Add('ENTERING GET_OM_CONF_PARAMS', 1);
62: cln_debug_pub.Add('With the following parameters:', 1);
63: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);
64: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
65: cln_debug_pub.Add('actid:' || p_actid, 1);

Line 62: cln_debug_pub.Add('With the following parameters:', 1);

58: l_transaction_type_passed_in VARCHAR2(100);
59: BEGIN
60: IF (l_debug_level <= 1) THEN
61: cln_debug_pub.Add('ENTERING GET_OM_CONF_PARAMS', 1);
62: cln_debug_pub.Add('With the following parameters:', 1);
63: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);
64: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
65: cln_debug_pub.Add('actid:' || p_actid, 1);
66: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);

Line 63: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);

59: BEGIN
60: IF (l_debug_level <= 1) THEN
61: cln_debug_pub.Add('ENTERING GET_OM_CONF_PARAMS', 1);
62: cln_debug_pub.Add('With the following parameters:', 1);
63: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);
64: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
65: cln_debug_pub.Add('actid:' || p_actid, 1);
66: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);
67: cln_debug_pub.Add('resultout:' || x_resultout, 1);

Line 64: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);

60: IF (l_debug_level <= 1) THEN
61: cln_debug_pub.Add('ENTERING GET_OM_CONF_PARAMS', 1);
62: cln_debug_pub.Add('With the following parameters:', 1);
63: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);
64: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
65: cln_debug_pub.Add('actid:' || p_actid, 1);
66: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);
67: cln_debug_pub.Add('resultout:' || x_resultout, 1);
68: cln_debug_pub.Add('party_id:' || l_party_id, 1);

Line 65: cln_debug_pub.Add('actid:' || p_actid, 1);

61: cln_debug_pub.Add('ENTERING GET_OM_CONF_PARAMS', 1);
62: cln_debug_pub.Add('With the following parameters:', 1);
63: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);
64: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
65: cln_debug_pub.Add('actid:' || p_actid, 1);
66: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);
67: cln_debug_pub.Add('resultout:' || x_resultout, 1);
68: cln_debug_pub.Add('party_id:' || l_party_id, 1);
69: cln_debug_pub.Add('party_site_id:' || l_party_site_id, 1);

Line 66: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);

62: cln_debug_pub.Add('With the following parameters:', 1);
63: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);
64: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
65: cln_debug_pub.Add('actid:' || p_actid, 1);
66: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);
67: cln_debug_pub.Add('resultout:' || x_resultout, 1);
68: cln_debug_pub.Add('party_id:' || l_party_id, 1);
69: cln_debug_pub.Add('party_site_id:' || l_party_site_id, 1);
70: cln_debug_pub.Add('doc_transfer_id:' || l_doc_transfer_id, 1);

Line 67: cln_debug_pub.Add('resultout:' || x_resultout, 1);

63: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);
64: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
65: cln_debug_pub.Add('actid:' || p_actid, 1);
66: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);
67: cln_debug_pub.Add('resultout:' || x_resultout, 1);
68: cln_debug_pub.Add('party_id:' || l_party_id, 1);
69: cln_debug_pub.Add('party_site_id:' || l_party_site_id, 1);
70: cln_debug_pub.Add('doc_transfer_id:' || l_doc_transfer_id, 1);
71: cln_debug_pub.Add('party_type:' || l_party_type, 1);

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

64: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
65: cln_debug_pub.Add('actid:' || p_actid, 1);
66: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);
67: cln_debug_pub.Add('resultout:' || x_resultout, 1);
68: cln_debug_pub.Add('party_id:' || l_party_id, 1);
69: cln_debug_pub.Add('party_site_id:' || l_party_site_id, 1);
70: cln_debug_pub.Add('doc_transfer_id:' || l_doc_transfer_id, 1);
71: cln_debug_pub.Add('party_type:' || l_party_type, 1);
72: END IF;

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

65: cln_debug_pub.Add('actid:' || p_actid, 1);
66: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);
67: cln_debug_pub.Add('resultout:' || x_resultout, 1);
68: cln_debug_pub.Add('party_id:' || l_party_id, 1);
69: cln_debug_pub.Add('party_site_id:' || l_party_site_id, 1);
70: cln_debug_pub.Add('doc_transfer_id:' || l_doc_transfer_id, 1);
71: cln_debug_pub.Add('party_type:' || l_party_type, 1);
72: END IF;
73: l_document_direction := 'OUT';

Line 70: cln_debug_pub.Add('doc_transfer_id:' || l_doc_transfer_id, 1);

66: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);
67: cln_debug_pub.Add('resultout:' || x_resultout, 1);
68: cln_debug_pub.Add('party_id:' || l_party_id, 1);
69: cln_debug_pub.Add('party_site_id:' || l_party_site_id, 1);
70: cln_debug_pub.Add('doc_transfer_id:' || l_doc_transfer_id, 1);
71: cln_debug_pub.Add('party_type:' || l_party_type, 1);
72: END IF;
73: l_document_direction := 'OUT';
74: l_party_type := 'C';

Line 71: cln_debug_pub.Add('party_type:' || l_party_type, 1);

67: cln_debug_pub.Add('resultout:' || x_resultout, 1);
68: cln_debug_pub.Add('party_id:' || l_party_id, 1);
69: cln_debug_pub.Add('party_site_id:' || l_party_site_id, 1);
70: cln_debug_pub.Add('doc_transfer_id:' || l_doc_transfer_id, 1);
71: cln_debug_pub.Add('party_type:' || l_party_type, 1);
72: END IF;
73: l_document_direction := 'OUT';
74: l_party_type := 'C';
75: l_result := FALSE;

Line 96: cln_debug_pub.Add('Exception - Query for Party ID failed', 1);

92: WHERE party_site_id = l_party_site_id;
93: EXCEPTION
94: WHEN OTHERS THEN
95: IF (l_debug_level <= 1) THEN
96: cln_debug_pub.Add('Exception - Query for Party ID failed', 1);
97: END IF;
98: END;
99:
100: IF (l_debug_level <= 1) THEN

Line 101: cln_debug_pub.Add('GET_OM_CONF_PARAMS: Parameter Lookups Completed', 1);

97: END IF;
98: END;
99:
100: IF (l_debug_level <= 1) THEN
101: cln_debug_pub.Add('GET_OM_CONF_PARAMS: Parameter Lookups Completed', 1);
102: cln_debug_pub.Add('With the following parameters:', 1);
103: cln_debug_pub.Add('party_id:' || l_party_id, 1);
104: cln_debug_pub.Add('party_site_id:' || l_party_site_id, 1);
105: cln_debug_pub.Add('doc_transfer_id:' || l_doc_transfer_id, 1);

Line 102: cln_debug_pub.Add('With the following parameters:', 1);

98: END;
99:
100: IF (l_debug_level <= 1) THEN
101: cln_debug_pub.Add('GET_OM_CONF_PARAMS: Parameter Lookups Completed', 1);
102: cln_debug_pub.Add('With the following parameters:', 1);
103: cln_debug_pub.Add('party_id:' || l_party_id, 1);
104: cln_debug_pub.Add('party_site_id:' || l_party_site_id, 1);
105: cln_debug_pub.Add('doc_transfer_id:' || l_doc_transfer_id, 1);
106: cln_debug_pub.Add('party_type:' || l_party_type, 1);

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

99:
100: IF (l_debug_level <= 1) THEN
101: cln_debug_pub.Add('GET_OM_CONF_PARAMS: Parameter Lookups Completed', 1);
102: cln_debug_pub.Add('With the following parameters:', 1);
103: cln_debug_pub.Add('party_id:' || l_party_id, 1);
104: cln_debug_pub.Add('party_site_id:' || l_party_site_id, 1);
105: cln_debug_pub.Add('doc_transfer_id:' || l_doc_transfer_id, 1);
106: cln_debug_pub.Add('party_type:' || l_party_type, 1);
107: END IF;

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

100: IF (l_debug_level <= 1) THEN
101: cln_debug_pub.Add('GET_OM_CONF_PARAMS: Parameter Lookups Completed', 1);
102: cln_debug_pub.Add('With the following parameters:', 1);
103: cln_debug_pub.Add('party_id:' || l_party_id, 1);
104: cln_debug_pub.Add('party_site_id:' || l_party_site_id, 1);
105: cln_debug_pub.Add('doc_transfer_id:' || l_doc_transfer_id, 1);
106: cln_debug_pub.Add('party_type:' || l_party_type, 1);
107: END IF;
108:

Line 105: cln_debug_pub.Add('doc_transfer_id:' || l_doc_transfer_id, 1);

101: cln_debug_pub.Add('GET_OM_CONF_PARAMS: Parameter Lookups Completed', 1);
102: cln_debug_pub.Add('With the following parameters:', 1);
103: cln_debug_pub.Add('party_id:' || l_party_id, 1);
104: cln_debug_pub.Add('party_site_id:' || l_party_site_id, 1);
105: cln_debug_pub.Add('doc_transfer_id:' || l_doc_transfer_id, 1);
106: cln_debug_pub.Add('party_type:' || l_party_type, 1);
107: END IF;
108:
109: IF (l_debug_level <= 1) THEN

Line 106: cln_debug_pub.Add('party_type:' || l_party_type, 1);

102: cln_debug_pub.Add('With the following parameters:', 1);
103: cln_debug_pub.Add('party_id:' || l_party_id, 1);
104: cln_debug_pub.Add('party_site_id:' || l_party_site_id, 1);
105: cln_debug_pub.Add('doc_transfer_id:' || l_doc_transfer_id, 1);
106: cln_debug_pub.Add('party_type:' || l_party_type, 1);
107: END IF;
108:
109: IF (l_debug_level <= 1) THEN
110: cln_debug_pub.Add('XML Trading Partner Setup Check Succeeded', 1);

Line 110: cln_debug_pub.Add('XML Trading Partner Setup Check Succeeded', 1);

106: cln_debug_pub.Add('party_type:' || l_party_type, 1);
107: END IF;
108:
109: IF (l_debug_level <= 1) THEN
110: cln_debug_pub.Add('XML Trading Partner Setup Check Succeeded', 1);
111: END IF;
112:
113: IF (l_transaction_type_passed_in ='POI') THEN
114: l_transaction_type := 'ONT';

Line 127: cln_debug_pub.Add('ECX_TRANSACTION_TYPE'|| l_transaction_type, 1);

123:
124:
125: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_TYPE', l_transaction_type);
126: IF (l_debug_level <= 1) THEN
127: cln_debug_pub.Add('ECX_TRANSACTION_TYPE'|| l_transaction_type, 1);
128: END IF;
129: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', l_transaction_subtype);
130: IF (l_debug_level <= 1) THEN
131: cln_debug_pub.Add('ECX_TRANSACTION_SUBTYPE'|| l_transaction_subtype, 1);

Line 131: cln_debug_pub.Add('ECX_TRANSACTION_SUBTYPE'|| l_transaction_subtype, 1);

127: cln_debug_pub.Add('ECX_TRANSACTION_TYPE'|| l_transaction_type, 1);
128: END IF;
129: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_TRANSACTION_SUBTYPE', l_transaction_subtype);
130: IF (l_debug_level <= 1) THEN
131: cln_debug_pub.Add('ECX_TRANSACTION_SUBTYPE'|| l_transaction_subtype, 1);
132: END IF;
133: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
134: IF (l_debug_level <= 1) THEN
135: cln_debug_pub.Add('ECX_PARTY_ID'|| l_party_id, 1);

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

131: cln_debug_pub.Add('ECX_TRANSACTION_SUBTYPE'|| l_transaction_subtype, 1);
132: END IF;
133: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_ID', l_party_id);
134: IF (l_debug_level <= 1) THEN
135: cln_debug_pub.Add('ECX_PARTY_ID'|| l_party_id, 1);
136: END IF;
137: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
138: IF (l_debug_level <= 1) THEN
139: cln_debug_pub.Add('ECX_PARTY_SITE_ID'|| l_party_site_id, 1);

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

135: cln_debug_pub.Add('ECX_PARTY_ID'|| l_party_id, 1);
136: END IF;
137: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_SITE_ID', l_party_site_id);
138: IF (l_debug_level <= 1) THEN
139: cln_debug_pub.Add('ECX_PARTY_SITE_ID'|| l_party_site_id, 1);
140: END IF;
141: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', l_party_type);
142: IF (l_debug_level <= 1) THEN
143: cln_debug_pub.Add('ECX_PARTY_TYPE'|| l_party_type, 1);

Line 143: cln_debug_pub.Add('ECX_PARTY_TYPE'|| l_party_type, 1);

139: cln_debug_pub.Add('ECX_PARTY_SITE_ID'|| l_party_site_id, 1);
140: END IF;
141: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_PARTY_TYPE', l_party_type);
142: IF (l_debug_level <= 1) THEN
143: cln_debug_pub.Add('ECX_PARTY_TYPE'|| l_party_type, 1);
144: END IF;
145: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_DOCUMENT_ID', l_doc_transfer_id);
146: IF (l_debug_level <= 1) THEN
147: cln_debug_pub.Add('ECX_DOCUMENT_ID'|| l_doc_transfer_id, 1);

Line 147: cln_debug_pub.Add('ECX_DOCUMENT_ID'|| l_doc_transfer_id, 1);

143: cln_debug_pub.Add('ECX_PARTY_TYPE'|| l_party_type, 1);
144: END IF;
145: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'ECX_DOCUMENT_ID', l_doc_transfer_id);
146: IF (l_debug_level <= 1) THEN
147: cln_debug_pub.Add('ECX_DOCUMENT_ID'|| l_doc_transfer_id, 1);
148: END IF;
149:
150:
151: l_eventkey := p_itemkey;

Line 154: cln_debug_pub.Add('EVENTKEY'|| l_eventkey, 1);

150:
151: l_eventkey := p_itemkey;
152: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'EVENTKEY',l_eventkey);
153: IF (l_debug_level <= 1) THEN
154: cln_debug_pub.Add('EVENTKEY'|| l_eventkey, 1);
155: END IF;
156: -- Reached Here. Successful execution.
157: x_resultout := 'SUCCESS';
158: IF (l_debug_level <= 1) THEN

Line 159: cln_debug_pub.Add('Result out '|| x_resultout, 1);

155: END IF;
156: -- Reached Here. Successful execution.
157: x_resultout := 'SUCCESS';
158: IF (l_debug_level <= 1) THEN
159: cln_debug_pub.Add('Result out '|| x_resultout, 1);
160: END IF;
161: IF (l_debug_level <= 2) THEN
162: cln_debug_pub.Add('EXITING GET_OM_CONF_PARAMS Successfully', 2);
163: END IF;

Line 162: cln_debug_pub.Add('EXITING GET_OM_CONF_PARAMS Successfully', 2);

158: IF (l_debug_level <= 1) THEN
159: cln_debug_pub.Add('Result out '|| x_resultout, 1);
160: END IF;
161: IF (l_debug_level <= 2) THEN
162: cln_debug_pub.Add('EXITING GET_OM_CONF_PARAMS Successfully', 2);
163: END IF;
164:
165: EXCEPTION
166: WHEN OTHERS THEN

Line 170: cln_debug_pub.Add('Exception ' || ':' || l_error_code || ':' || l_error_msg, 1);

166: WHEN OTHERS THEN
167: l_error_code := SQLCODE;
168: l_error_msg := SQLERRM;
169: IF (l_debug_level <= 1) THEN
170: cln_debug_pub.Add('Exception ' || ':' || l_error_code || ':' || l_error_msg, 1);
171: END IF;
172: x_resultout := 'ERROR';
173: IF (l_debug_level <= 1) THEN
174: cln_debug_pub.Add('Result out '|| x_resultout, 1);

Line 174: cln_debug_pub.Add('Result out '|| x_resultout, 1);

170: cln_debug_pub.Add('Exception ' || ':' || l_error_code || ':' || l_error_msg, 1);
171: END IF;
172: x_resultout := 'ERROR';
173: IF (l_debug_level <= 1) THEN
174: cln_debug_pub.Add('Result out '|| x_resultout, 1);
175: END IF;
176: IF (l_debug_level <= 1) THEN
177: cln_debug_pub.Add('Exiting GET_OM_CONF_PARAMS with Error', 1);
178: END IF;

Line 177: cln_debug_pub.Add('Exiting GET_OM_CONF_PARAMS with Error', 1);

173: IF (l_debug_level <= 1) THEN
174: cln_debug_pub.Add('Result out '|| x_resultout, 1);
175: END IF;
176: IF (l_debug_level <= 1) THEN
177: cln_debug_pub.Add('Exiting GET_OM_CONF_PARAMS with Error', 1);
178: END IF;
179:
180: END GET_OM_CONF_PARAMS;
181:

Line 205: cln_debug_pub.Add('ENTERING M4R_OM_CONF_PKG.IS_OAG_OR_ROSETTANET',1);

201: l_error_code NUMBER;
202: l_error_msg VARCHAR2(1000);
203: BEGIN
204: IF (l_debug_level <= 1) THEN
205: cln_debug_pub.Add('ENTERING M4R_OM_CONF_PKG.IS_OAG_OR_ROSETTANET',1);
206: cln_debug_pub.Add('With the following parameters:', 1);
207: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);
208: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
209: cln_debug_pub.Add('actid:' || p_actid, 1);

Line 206: cln_debug_pub.Add('With the following parameters:', 1);

202: l_error_msg VARCHAR2(1000);
203: BEGIN
204: IF (l_debug_level <= 1) THEN
205: cln_debug_pub.Add('ENTERING M4R_OM_CONF_PKG.IS_OAG_OR_ROSETTANET',1);
206: cln_debug_pub.Add('With the following parameters:', 1);
207: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);
208: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
209: cln_debug_pub.Add('actid:' || p_actid, 1);
210: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);

Line 207: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);

203: BEGIN
204: IF (l_debug_level <= 1) THEN
205: cln_debug_pub.Add('ENTERING M4R_OM_CONF_PKG.IS_OAG_OR_ROSETTANET',1);
206: cln_debug_pub.Add('With the following parameters:', 1);
207: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);
208: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
209: cln_debug_pub.Add('actid:' || p_actid, 1);
210: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);
211: cln_debug_pub.Add('resultout:' || x_resultout, 1);

Line 208: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);

204: IF (l_debug_level <= 1) THEN
205: cln_debug_pub.Add('ENTERING M4R_OM_CONF_PKG.IS_OAG_OR_ROSETTANET',1);
206: cln_debug_pub.Add('With the following parameters:', 1);
207: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);
208: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
209: cln_debug_pub.Add('actid:' || p_actid, 1);
210: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);
211: cln_debug_pub.Add('resultout:' || x_resultout, 1);
212: END IF;

Line 209: cln_debug_pub.Add('actid:' || p_actid, 1);

205: cln_debug_pub.Add('ENTERING M4R_OM_CONF_PKG.IS_OAG_OR_ROSETTANET',1);
206: cln_debug_pub.Add('With the following parameters:', 1);
207: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);
208: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
209: cln_debug_pub.Add('actid:' || p_actid, 1);
210: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);
211: cln_debug_pub.Add('resultout:' || x_resultout, 1);
212: END IF;
213: -- Retrieve Activity Attributes

Line 210: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);

206: cln_debug_pub.Add('With the following parameters:', 1);
207: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);
208: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
209: cln_debug_pub.Add('actid:' || p_actid, 1);
210: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);
211: cln_debug_pub.Add('resultout:' || x_resultout, 1);
212: END IF;
213: -- Retrieve Activity Attributes
214: l_party_site_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_PARTY_SITE_ID');

Line 211: cln_debug_pub.Add('resultout:' || x_resultout, 1);

207: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);
208: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
209: cln_debug_pub.Add('actid:' || p_actid, 1);
210: cln_debug_pub.Add('funcmode:' || p_funcmode, 1);
211: cln_debug_pub.Add('resultout:' || x_resultout, 1);
212: END IF;
213: -- Retrieve Activity Attributes
214: l_party_site_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_PARTY_SITE_ID');
215: l_party_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_PARTY_ID');

Line 232: cln_debug_pub.Add('EVENTKEY: '|| l_eventkey, 1);

228: x_resultout := 'COMPLETE:F';
229: l_eventkey :=p_itemkey;
230: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'EVENTKEY',l_eventkey);
231: IF (l_debug_level <= 1) THEN
232: cln_debug_pub.Add('EVENTKEY: '|| l_eventkey, 1);
233: END IF;
234: end if;
235:
236: IF (l_debug_level <= 2) THEN

Line 237: cln_debug_pub.Add('EXITING IS_OAG_OR_ROSETTANET Successfully', 2);

233: END IF;
234: end if;
235:
236: IF (l_debug_level <= 2) THEN
237: cln_debug_pub.Add('EXITING IS_OAG_OR_ROSETTANET Successfully', 2);
238: END IF;
239:
240: EXCEPTION
241: WHEN OTHERS THEN

Line 245: cln_debug_pub.Add('Exception ' || ':' || l_error_code || ':' || l_error_msg, 1);

241: WHEN OTHERS THEN
242: l_error_code := SQLCODE;
243: l_error_msg := SQLERRM;
244: IF (l_debug_level <= 1) THEN
245: cln_debug_pub.Add('Exception ' || ':' || l_error_code || ':' || l_error_msg, 1);
246: END IF;
247: x_resultout := 'ERROR';
248: IF (l_debug_level <= 1) THEN
249: cln_debug_pub.Add('Result out '|| x_resultout, 1);

Line 249: cln_debug_pub.Add('Result out '|| x_resultout, 1);

245: cln_debug_pub.Add('Exception ' || ':' || l_error_code || ':' || l_error_msg, 1);
246: END IF;
247: x_resultout := 'ERROR';
248: IF (l_debug_level <= 1) THEN
249: cln_debug_pub.Add('Result out '|| x_resultout, 1);
250: END IF;
251: IF (l_debug_level <= 1) THEN
252: cln_debug_pub.Add('Exiting IS_OAG_OR_ROSETTANET with Error', 1);
253: END IF;

Line 252: cln_debug_pub.Add('Exiting IS_OAG_OR_ROSETTANET with Error', 1);

248: IF (l_debug_level <= 1) THEN
249: cln_debug_pub.Add('Result out '|| x_resultout, 1);
250: END IF;
251: IF (l_debug_level <= 1) THEN
252: cln_debug_pub.Add('Exiting IS_OAG_OR_ROSETTANET with Error', 1);
253: END IF;
254: END IS_OAG_OR_ROSETTANET;
255:
256: FUNCTION UPDATE_CH_OM_EVENT_SUB(

Line 271: cln_debug_pub.Add('==========ENTERING UPDATE_CH_OM_EVENT_SUB===========', 2);

267: l_return_tmp VARCHAR2(100);
268: l_processing_stage VARCHAR2(100);
269: BEGIN
270: IF (l_Debug_Level <= 2) THEN
271: cln_debug_pub.Add('==========ENTERING UPDATE_CH_OM_EVENT_SUB===========', 2);
272: END IF;
273:
274: l_evt_parameters := p_event.getParameterList();
275:

Line 277: cln_debug_pub.Add('----------- PARAMETERS OBTAINED ----------', 1);

273:
274: l_evt_parameters := p_event.getParameterList();
275:
276: IF (l_Debug_Level <= 1) THEN
277: cln_debug_pub.Add('----------- PARAMETERS OBTAINED ----------', 1);
278: END IF;
279: l_xmlg_txn_type:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_TYPE',l_evt_parameters);
280: IF (l_Debug_Level <= 1) THEN
281: cln_debug_pub.Add('XMLG_INTERNAL_TXN_TYPE: '||l_xmlg_txn_type, 1);

Line 281: cln_debug_pub.Add('XMLG_INTERNAL_TXN_TYPE: '||l_xmlg_txn_type, 1);

277: cln_debug_pub.Add('----------- PARAMETERS OBTAINED ----------', 1);
278: END IF;
279: l_xmlg_txn_type:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_TYPE',l_evt_parameters);
280: IF (l_Debug_Level <= 1) THEN
281: cln_debug_pub.Add('XMLG_INTERNAL_TXN_TYPE: '||l_xmlg_txn_type, 1);
282: END IF;
283: l_xmlg_txn_subtype:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_SUBTYPE',l_evt_parameters);
284: IF (l_Debug_Level <= 1) THEN
285: cln_debug_pub.Add('XMLG_INTERNAL_TXN_SUBTYPE: '||l_xmlg_txn_subtype, 1);

Line 285: cln_debug_pub.Add('XMLG_INTERNAL_TXN_SUBTYPE: '||l_xmlg_txn_subtype, 1);

281: cln_debug_pub.Add('XMLG_INTERNAL_TXN_TYPE: '||l_xmlg_txn_type, 1);
282: END IF;
283: l_xmlg_txn_subtype:= WF_EVENT.getValueForParameter('XMLG_INTERNAL_TXN_SUBTYPE',l_evt_parameters);
284: IF (l_Debug_Level <= 1) THEN
285: cln_debug_pub.Add('XMLG_INTERNAL_TXN_SUBTYPE: '||l_xmlg_txn_subtype, 1);
286: END IF;
287: l_processing_stage:= WF_EVENT.getValueForParameter('PROCESSING_STAGE',l_evt_parameters);
288: IF (l_Debug_Level <= 1) THEN
289: cln_debug_pub.Add('PROCESSING_STAGE: '||l_processing_stage, 1);

Line 289: cln_debug_pub.Add('PROCESSING_STAGE: '||l_processing_stage, 1);

285: cln_debug_pub.Add('XMLG_INTERNAL_TXN_SUBTYPE: '||l_xmlg_txn_subtype, 1);
286: END IF;
287: l_processing_stage:= WF_EVENT.getValueForParameter('PROCESSING_STAGE',l_evt_parameters);
288: IF (l_Debug_Level <= 1) THEN
289: cln_debug_pub.Add('PROCESSING_STAGE: '||l_processing_stage, 1);
290: END IF;
291:
292: IF (l_xmlg_txn_type = 'ONT' and l_xmlg_txn_subtype = 'POA' and l_processing_stage = 'OUTBOUND_SENT') THEN
293: IF (l_Debug_Level <= 1) THEN

Line 294: cln_debug_pub.Add('Getting the Message Standard', 1);

290: END IF;
291:
292: IF (l_xmlg_txn_type = 'ONT' and l_xmlg_txn_subtype = 'POA' and l_processing_stage = 'OUTBOUND_SENT') THEN
293: IF (l_Debug_Level <= 1) THEN
294: cln_debug_pub.Add('Getting the Message Standard', 1);
295: END IF;
296:
297: l_tr_partner_id := WF_EVENT.getValueForParameter('TRADING_PARTNER_ID',l_evt_parameters);
298: IF (l_Debug_Level <= 1) THEN

Line 299: cln_debug_pub.Add('Trading Partner ID ----'||l_tr_partner_id, 1);

295: END IF;
296:
297: l_tr_partner_id := WF_EVENT.getValueForParameter('TRADING_PARTNER_ID',l_evt_parameters);
298: IF (l_Debug_Level <= 1) THEN
299: cln_debug_pub.Add('Trading Partner ID ----'||l_tr_partner_id, 1);
300: END IF;
301:
302: l_tr_partner_site := WF_EVENT.getValueForParameter('TRADING_PARTNER_SITE',l_evt_parameters);
303: IF (l_Debug_Level <= 1) THEN

Line 304: cln_debug_pub.Add('Trading Partner Site ----'||l_tr_partner_site, 1);

300: END IF;
301:
302: l_tr_partner_site := WF_EVENT.getValueForParameter('TRADING_PARTNER_SITE',l_evt_parameters);
303: IF (l_Debug_Level <= 1) THEN
304: cln_debug_pub.Add('Trading Partner Site ----'||l_tr_partner_site, 1);
305: END IF;
306:
307: BEGIN
308: SELECT standard_code

Line 321: cln_debug_pub.Add('In valid paramerers passed to the event', 4);

317: EXCEPTION
318: WHEN OTHERS THEN
319: -- Nothing to do
320: IF (l_Debug_Level <= 4) THEN
321: cln_debug_pub.Add('In valid paramerers passed to the event', 4);
322: END IF;
323: END;
324:
325: IF l_standard = 'ROSETTANET' THEN

Line 328: cln_debug_pub.Add('==========EXITING UPDATE_CH_OM_EVENT_SUB WITHOUT UPDATING COLLABORATION HISTORY ===========', 2);

324:
325: IF l_standard = 'ROSETTANET' THEN
326: -- For rosettan net standard this event shoudl be ignored
327: IF (l_Debug_Level <= 2) THEN
328: cln_debug_pub.Add('==========EXITING UPDATE_CH_OM_EVENT_SUB WITHOUT UPDATING COLLABORATION HISTORY ===========', 2);
329: END IF;
330: RETURN 'SUCCESS';
331: END IF;
332: END IF;

Line 338: cln_debug_pub.Add('==========EXITING UPDATE_CH_OM_EVENT_SUB===========', 2);

334: -- If the control reaches here, it mesans that collaboration history needs to be updated
335: l_return_tmp := CLN_CH_EVENT_SUBSCRIPTION_PKG.ADD_COLLABORATION_EVENT_SUB(p_subscription_guid,p_event);
336:
337: IF (l_Debug_Level <= 2) THEN
338: cln_debug_pub.Add('==========EXITING UPDATE_CH_OM_EVENT_SUB===========', 2);
339: END IF;
340: RETURN 'SUCCESS';
341: END;
342: