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.FUN_NET_APPROVAL_WF dependencies on FUN_NET_UTIL

Line 26: fun_net_util.Log_String(g_state_level,l_path,'Start of Raise_Approval_Event');

22: l_event_name VARCHAR2(50);
23: l_path VARCHAR2(100);
24: BEGIN
25: l_path := g_path || 'Raise_Approval_Event';
26: fun_net_util.Log_String(g_state_level,l_path,'Start of Raise_Approval_Event');
27: fun_net_util.Log_String(g_state_level,l_path,'Batch ID: '||p_batch_id);
28:
29: l_event_name := 'oracle.apps.fun.netting.batchApproval';
30: wf_event.AddParameterToList

Line 27: fun_net_util.Log_String(g_state_level,l_path,'Batch ID: '||p_batch_id);

23: l_path VARCHAR2(100);
24: BEGIN
25: l_path := g_path || 'Raise_Approval_Event';
26: fun_net_util.Log_String(g_state_level,l_path,'Start of Raise_Approval_Event');
27: fun_net_util.Log_String(g_state_level,l_path,'Batch ID: '||p_batch_id);
28:
29: l_event_name := 'oracle.apps.fun.netting.batchApproval';
30: wf_event.AddParameterToList
31: ( p_name => 'BATCH_ID',

Line 35: fun_net_util.Log_String(g_state_level,l_path,'Before raising business event');

31: ( p_name => 'BATCH_ID',
32: p_value => p_batch_id,
33: p_parameterlist => l_parameter_list );
34:
35: fun_net_util.Log_String(g_state_level,l_path,'Before raising business event');
36: wf_event.Raise3
37: (
38: p_event_name => l_event_name,
39: p_event_key => to_char(p_batch_id)||' '||to_char(sysdate,'DD-MM-YY HH:MM:SS'),

Line 42: fun_net_util.Log_String(g_state_level,l_path,'After raising business event');

38: p_event_name => l_event_name,
39: p_event_key => to_char(p_batch_id)||' '||to_char(sysdate,'DD-MM-YY HH:MM:SS'),
40: p_parameter_list => l_parameter_list
41: );
42: fun_net_util.Log_String(g_state_level,l_path,'After raising business event');
43: l_parameter_list.DELETE;
44: fun_net_util.Log_String(g_state_level,l_path,'End of Raise_Approval_Event');
45: EXCEPTION
46: WHEN others THEN

Line 44: fun_net_util.Log_String(g_state_level,l_path,'End of Raise_Approval_Event');

40: p_parameter_list => l_parameter_list
41: );
42: fun_net_util.Log_String(g_state_level,l_path,'After raising business event');
43: l_parameter_list.DELETE;
44: fun_net_util.Log_String(g_state_level,l_path,'End of Raise_Approval_Event');
45: EXCEPTION
46: WHEN others THEN
47: --wf_core.CONTEXT(l_path_name,l_api_name,l_path_name);
48: APP_EXCEPTION.RAISE_EXCEPTION;

Line 95: fun_net_util.Log_String(g_state_level,l_path,'Batch Id :'||l_batch_id);

91: l_path varchar2(100);
92: BEGIN
93: l_path := g_path || 'Initialize';
94: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');
95: fun_net_util.Log_String(g_state_level,l_path,'Batch Id :'||l_batch_id);
96:
97: OPEN c_get_batch_details(l_batch_id);
98: FETCH c_get_batch_details INTO l_batch_number,
99: l_batch_name,

Line 106: fun_net_util.Log_String(g_state_level,l_path,'Setting WF Attributes');

102: l_netting_amount,
103: l_agreement_id,
104: l_batch_currency;
105: CLOSE c_get_batch_details;
106: fun_net_util.Log_String(g_state_level,l_path,'Setting WF Attributes');
107: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'BATCH_NUMBER',l_batch_number);
108: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'BATCH_NAME',l_batch_name);
109: WF_ENGINE.SetItemAttrDate(p_item_type, p_item_key, 'RESPONSE_DATE',l_response_date);
110: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'NETTING_AMOUNT',l_netting_amount);

Line 112: fun_net_util.Log_String(g_state_level,l_path,'After Setting WF Attributes');

108: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'BATCH_NAME',l_batch_name);
109: WF_ENGINE.SetItemAttrDate(p_item_type, p_item_key, 'RESPONSE_DATE',l_response_date);
110: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'NETTING_AMOUNT',l_netting_amount);
111: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'BATCH_CURRENCY',l_batch_currency);
112: fun_net_util.Log_String(g_state_level,l_path,'After Setting WF Attributes');
113:
114: OPEN c_get_preparer_id(l_created_by);
115: FETCH c_get_preparer_id INTO l_netting_analyst_id;
116: CLOSE c_get_preparer_id;

Line 117: fun_net_util.Log_String(g_state_level,l_path,'Preparer ID :'||l_netting_analyst_id);

113:
114: OPEN c_get_preparer_id(l_created_by);
115: FETCH c_get_preparer_id INTO l_netting_analyst_id;
116: CLOSE c_get_preparer_id;
117: fun_net_util.Log_String(g_state_level,l_path,'Preparer ID :'||l_netting_analyst_id);
118:
119: WF_DIRECTORY.GetUserName('PER',
120: l_netting_analyst_id,
121: l_analyst_name,

Line 124: fun_net_util.Log_String(g_state_level,l_path,'Analyst Name :'||l_analyst_name);

120: l_netting_analyst_id,
121: l_analyst_name,
122: l_analyst_display_name);
123:
124: fun_net_util.Log_String(g_state_level,l_path,'Analyst Name :'||l_analyst_name);
125:
126: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'ANALYST_NAME',l_analyst_name);
127: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'ANALYST_DISP_NAME',l_analyst_display_name);
128:

Line 132: fun_net_util.Log_String(g_state_level,l_path,'Approver Name:'||l_approver_name);

128:
129: OPEN c_get_approver_name(l_agreement_id);
130: FETCH c_get_approver_name INTO l_approver_name;
131: CLOSE c_get_approver_name;
132: fun_net_util.Log_String(g_state_level,l_path,'Approver Name:'||l_approver_name);
133:
134: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'APPROVER_NAME',l_approver_name);
135:
136: p_result := 'COMPLETE';

Line 137: fun_net_util.Log_String(g_state_level,l_path,'End of Initialization');

133:
134: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'APPROVER_NAME',l_approver_name);
135:
136: p_result := 'COMPLETE';
137: fun_net_util.Log_String(g_state_level,l_path,'End of Initialization');
138:
139: EXCEPTION
140: WHEN OTHERS THEN
141: fun_net_util.Log_String(g_state_level,l_path,sqlerrm);

Line 141: fun_net_util.Log_String(g_state_level,l_path,sqlerrm);

137: fun_net_util.Log_String(g_state_level,l_path,'End of Initialization');
138:
139: EXCEPTION
140: WHEN OTHERS THEN
141: fun_net_util.Log_String(g_state_level,l_path,sqlerrm);
142: END Initialize;
143:
144: PROCEDURE Validate_Settle_Batch(p_item_type IN VARCHAR2,
145: p_item_key IN VARCHAR2,

Line 159: fun_net_util.Log_String(g_state_level,l_path,'Batch IdIASDASD: '||l_batch_id);

155: l_org_id NUMBER;
156: l_status VARCHAR2(50);
157: BEGIN
158:
159: fun_net_util.Log_String(g_state_level,l_path,'Batch IdIASDASD: '||l_batch_id);
160: l_path := g_path||'Validate_Settle_Batch';
161: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');
162: fun_net_util.Log_String(g_state_level,l_path,'Batch Id: '||l_batch_id);
163:

Line 162: fun_net_util.Log_String(g_state_level,l_path,'Batch Id: '||l_batch_id);

158:
159: fun_net_util.Log_String(g_state_level,l_path,'Batch IdIASDASD: '||l_batch_id);
160: l_path := g_path||'Validate_Settle_Batch';
161: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');
162: fun_net_util.Log_String(g_state_level,l_path,'Batch Id: '||l_batch_id);
163:
164:
165: -- Set the Multi Org Context
166:

Line 185: fun_net_util.Log_String(g_state_level,l_path,'Settle batch SUCCESS');

181: x_msg_data => l_msg_data,
182: p_batch_id => l_batch_id);
183:
184: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
185: fun_net_util.Log_String(g_state_level,l_path,'Settle batch SUCCESS');
186: p_result := 'COMPLETE:Y';
187: ELSE
188: select batch_status_code into l_status from fun_net_batches_all
189: where batch_id=l_batch_id;

Line 191: fun_net_util.Log_String(g_state_level,l_path,'Setting batch FAILURE');

187: ELSE
188: select batch_status_code into l_status from fun_net_batches_all
189: where batch_id=l_batch_id;
190: IF l_status='ERROR' THEN
191: fun_net_util.Log_String(g_state_level,l_path,'Setting batch FAILURE');
192: p_result := 'COMPLETE:N';
193: ELSIF l_status='CANCELLED' THEN
194: fun_net_util.Log_String(g_state_level,l_path,'Setting batch CANCELLED');
195: p_result := 'COMPLETE:C';

Line 194: fun_net_util.Log_String(g_state_level,l_path,'Setting batch CANCELLED');

190: IF l_status='ERROR' THEN
191: fun_net_util.Log_String(g_state_level,l_path,'Setting batch FAILURE');
192: p_result := 'COMPLETE:N';
193: ELSIF l_status='CANCELLED' THEN
194: fun_net_util.Log_String(g_state_level,l_path,'Setting batch CANCELLED');
195: p_result := 'COMPLETE:C';
196: END IF;
197: END IF;
198: fun_net_util.Log_String(g_state_level,l_path,'End Validate_Settle_Batch');

Line 198: fun_net_util.Log_String(g_state_level,l_path,'End Validate_Settle_Batch');

194: fun_net_util.Log_String(g_state_level,l_path,'Setting batch CANCELLED');
195: p_result := 'COMPLETE:C';
196: END IF;
197: END IF;
198: fun_net_util.Log_String(g_state_level,l_path,'End Validate_Settle_Batch');
199: END Validate_Settle_Batch;
200:
201: PROCEDURE Get_NoResponse_Action(p_item_type IN VARCHAR2,
202: p_item_key IN VARCHAR2,

Line 219: fun_net_util.Log_String(g_state_level,l_path,'Start of Get_NoResponse_Action');

215: l_nonresponse_code fun_net_agreements_all.non_response_action_code%TYPE;
216: l_path VARCHAR2(100);
217: BEGIN
218: l_path := g_path||'Get_NoResponse_Action';
219: fun_net_util.Log_String(g_state_level,l_path,'Start of Get_NoResponse_Action');
220: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');
221: fun_net_util.Log_String(g_state_level,l_path,'Batch ID: '||l_batch_id);
222:
223: OPEN c_get_nonresponse_code(l_batch_id);

Line 221: fun_net_util.Log_String(g_state_level,l_path,'Batch ID: '||l_batch_id);

217: BEGIN
218: l_path := g_path||'Get_NoResponse_Action';
219: fun_net_util.Log_String(g_state_level,l_path,'Start of Get_NoResponse_Action');
220: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');
221: fun_net_util.Log_String(g_state_level,l_path,'Batch ID: '||l_batch_id);
222:
223: OPEN c_get_nonresponse_code(l_batch_id);
224: FETCH c_get_nonresponse_code INTO l_nonresponse_code;
225: CLOSE c_get_nonresponse_code;

Line 228: fun_net_util.Log_String(g_state_level,l_path,'No response action:'||'APPROVE');

224: FETCH c_get_nonresponse_code INTO l_nonresponse_code;
225: CLOSE c_get_nonresponse_code;
226:
227: IF l_nonresponse_code = 'APPROVE' THEN
228: fun_net_util.Log_String(g_state_level,l_path,'No response action:'||'APPROVE');
229: p_result := 'COMPLETE:APPROVED';
230: ELSE
231: fun_net_util.Log_String(g_state_level,l_path,'No response action:'||'REJECT');
232: p_result := 'COMPLETE:REJECTED';

Line 231: fun_net_util.Log_String(g_state_level,l_path,'No response action:'||'REJECT');

227: IF l_nonresponse_code = 'APPROVE' THEN
228: fun_net_util.Log_String(g_state_level,l_path,'No response action:'||'APPROVE');
229: p_result := 'COMPLETE:APPROVED';
230: ELSE
231: fun_net_util.Log_String(g_state_level,l_path,'No response action:'||'REJECT');
232: p_result := 'COMPLETE:REJECTED';
233: END IF;
234: fun_net_util.Log_String(g_state_level,l_path,'End of Get_NoResponse_Action');
235: END Get_NoResponse_Action;

Line 234: fun_net_util.Log_String(g_state_level,l_path,'End of Get_NoResponse_Action');

230: ELSE
231: fun_net_util.Log_String(g_state_level,l_path,'No response action:'||'REJECT');
232: p_result := 'COMPLETE:REJECTED';
233: END IF;
234: fun_net_util.Log_String(g_state_level,l_path,'End of Get_NoResponse_Action');
235: END Get_NoResponse_Action;
236:
237: PROCEDURE Update_Batch_status_rej(p_item_type IN VARCHAR2,
238: p_item_key IN VARCHAR2,

Line 249: fun_net_util.Log_String(g_state_level,l_path,'Begin Update Batch Status');

245: l_path VARCHAR2(100);
246: BEGIN
247: l_path := g_path||'Update_Batch_status';
248:
249: fun_net_util.Log_String(g_state_level,l_path,'Begin Update Batch Status');
250: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');
251: fun_net_util.Log_String(g_state_level,l_path,'Batch Id: '||l_batch_id);
252:
253: FUN_NET_BATCHES_PKG.Update_Row

Line 251: fun_net_util.Log_String(g_state_level,l_path,'Batch Id: '||l_batch_id);

247: l_path := g_path||'Update_Batch_status';
248:
249: fun_net_util.Log_String(g_state_level,l_path,'Begin Update Batch Status');
250: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');
251: fun_net_util.Log_String(g_state_level,l_path,'Batch Id: '||l_batch_id);
252:
253: FUN_NET_BATCHES_PKG.Update_Row
254: (x_batch_id => l_batch_id,
255: x_batch_status_code => 'REJECTED');

Line 259: fun_net_util.Log_String(g_state_level,l_path,'End Update Batch Status');

255: x_batch_status_code => 'REJECTED');
256:
257: p_result := 'COMPLETE';
258:
259: fun_net_util.Log_String(g_state_level,l_path,'End Update Batch Status');
260:
261: END Update_Batch_status_rej;
262:
263: PROCEDURE Update_Batch_status_err(p_item_type IN VARCHAR2,

Line 275: fun_net_util.Log_String(g_state_level,l_path,'Begin Update Batch Status');

271: l_path VARCHAR2(100);
272: BEGIN
273: l_path := g_path||'Update_Batch_status';
274:
275: fun_net_util.Log_String(g_state_level,l_path,'Begin Update Batch Status');
276: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');
277: fun_net_util.Log_String(g_state_level,l_path,'Batch Id: '||l_batch_id);
278:
279: FUN_NET_BATCHES_PKG.Update_Row

Line 277: fun_net_util.Log_String(g_state_level,l_path,'Batch Id: '||l_batch_id);

273: l_path := g_path||'Update_Batch_status';
274:
275: fun_net_util.Log_String(g_state_level,l_path,'Begin Update Batch Status');
276: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');
277: fun_net_util.Log_String(g_state_level,l_path,'Batch Id: '||l_batch_id);
278:
279: FUN_NET_BATCHES_PKG.Update_Row
280: (x_batch_id => l_batch_id,
281: x_batch_status_code => 'ERROR');

Line 285: fun_net_util.Log_String(g_state_level,l_path,'End Update Batch Status');

281: x_batch_status_code => 'ERROR');
282:
283: p_result := 'COMPLETE';
284:
285: fun_net_util.Log_String(g_state_level,l_path,'End Update Batch Status');
286:
287: END Update_Batch_status_err;
288:
289: