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_CONC_PROG_PKG dependencies on FUN_NET_CONC_PROG_PKG

Line 1: PACKAGE BODY FUN_NET_CONC_PROG_PKG AS

1: PACKAGE BODY FUN_NET_CONC_PROG_PKG AS
2: /* $Header: funntcpb.pls 120.8 2011/04/27 12:05:29 srampure ship $ */
3:
4: PROCEDURE Create_Net_Batch(
5: errbuf OUT NOCOPY VARCHAR2,

Line 14: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.create_net_batch','Before calling create batch API');

10: l_msg_count NUMBER;
11: l_msg_data VARCHAR2(2000);
12:
13: BEGIN
14: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.create_net_batch','Before calling create batch API');
15: FUN_NET_ARAP_PKG.create_net_batch(
16: p_init_msg_list => FND_API.G_TRUE,
17: p_commit => FND_API.G_TRUE,
18: x_return_status => l_return_status,

Line 22: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.create_net_batch','return from create batch API');

18: x_return_status => l_return_status,
19: x_msg_count => l_msg_count,
20: x_msg_data => l_msg_data,
21: p_batch_id => p_batch_id);
22: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.create_net_batch','return from create batch API');
23: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
24: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.create_net_batch','Success');
25: retcode := 0;
26: ELSE

Line 24: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.create_net_batch','Success');

20: x_msg_data => l_msg_data,
21: p_batch_id => p_batch_id);
22: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.create_net_batch','return from create batch API');
23: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
24: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.create_net_batch','Success');
25: retcode := 0;
26: ELSE
27: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.create_net_batch','Error');
28: retcode := 2;

Line 27: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.create_net_batch','Error');

23: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
24: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.create_net_batch','Success');
25: retcode := 0;
26: ELSE
27: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.create_net_batch','Error');
28: retcode := 2;
29: END IF;
30: EXCEPTION
31: WHEN OTHERS THEN

Line 203: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch','Begin');

199: l_batch_name fun_net_batches_all.batch_name%TYPE;
200: l_batch_status fun_net_batches_all.batch_status_code%TYPE;
201:
202: BEGIN
203: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch','Begin');
204:
205: select hr.name
206: into l_org_name
207: from hr_operating_units hr

Line 210: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'p_org_id :'||p_org_id);

206: into l_org_name
207: from hr_operating_units hr
208: where hr.organization_id = p_org_id;
209:
210: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'p_org_id :'||p_org_id);
211:
212: IF p_agreement_id is not NULL THEN
213:
214: SELECT agreement_name, ALLOW_DISC_FLAG

Line 221: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Operating Unit :'||l_org_name);

217: WHERE AGREEMENT_ID = p_agreement_id;
218:
219: END IF;
220:
221: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Operating Unit :'||l_org_name);
222: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Agreement Name :'||l_agreement_name);
223: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Settlement Date:'|| p_settlement_date);
224: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Response Date :'|| p_response_date);
225: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Batch Name :'||p_batch_name);

Line 222: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Agreement Name :'||l_agreement_name);

218:
219: END IF;
220:
221: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Operating Unit :'||l_org_name);
222: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Agreement Name :'||l_agreement_name);
223: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Settlement Date:'|| p_settlement_date);
224: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Response Date :'|| p_response_date);
225: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Batch Name :'||p_batch_name);
226: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Transaction Due Date :'||p_transaction_due_date);

Line 223: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Settlement Date:'|| p_settlement_date);

219: END IF;
220:
221: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Operating Unit :'||l_org_name);
222: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Agreement Name :'||l_agreement_name);
223: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Settlement Date:'|| p_settlement_date);
224: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Response Date :'|| p_response_date);
225: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Batch Name :'||p_batch_name);
226: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Transaction Due Date :'||p_transaction_due_date);
227: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'GL Date :'|| p_gl_date);

Line 224: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Response Date :'|| p_response_date);

220:
221: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Operating Unit :'||l_org_name);
222: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Agreement Name :'||l_agreement_name);
223: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Settlement Date:'|| p_settlement_date);
224: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Response Date :'|| p_response_date);
225: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Batch Name :'||p_batch_name);
226: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Transaction Due Date :'||p_transaction_due_date);
227: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'GL Date :'|| p_gl_date);
228: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate Type :'||p_exchange_rate_type);

Line 225: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Batch Name :'||p_batch_name);

221: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Operating Unit :'||l_org_name);
222: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Agreement Name :'||l_agreement_name);
223: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Settlement Date:'|| p_settlement_date);
224: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Response Date :'|| p_response_date);
225: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Batch Name :'||p_batch_name);
226: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Transaction Due Date :'||p_transaction_due_date);
227: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'GL Date :'|| p_gl_date);
228: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate Type :'||p_exchange_rate_type);
229: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate :'||p_exchange_rate);

Line 226: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Transaction Due Date :'||p_transaction_due_date);

222: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Agreement Name :'||l_agreement_name);
223: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Settlement Date:'|| p_settlement_date);
224: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Response Date :'|| p_response_date);
225: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Batch Name :'||p_batch_name);
226: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Transaction Due Date :'||p_transaction_due_date);
227: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'GL Date :'|| p_gl_date);
228: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate Type :'||p_exchange_rate_type);
229: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate :'||p_exchange_rate);
230: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Review Netting Batch Flag :'||p_review_netting_batch_flag);

Line 227: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'GL Date :'|| p_gl_date);

223: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Settlement Date:'|| p_settlement_date);
224: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Response Date :'|| p_response_date);
225: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Batch Name :'||p_batch_name);
226: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Transaction Due Date :'||p_transaction_due_date);
227: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'GL Date :'|| p_gl_date);
228: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate Type :'||p_exchange_rate_type);
229: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate :'||p_exchange_rate);
230: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Review Netting Batch Flag :'||p_review_netting_batch_flag);
231: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'l_agreement_name :'||l_agreement_name);

Line 228: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate Type :'||p_exchange_rate_type);

224: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Response Date :'|| p_response_date);
225: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Batch Name :'||p_batch_name);
226: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Transaction Due Date :'||p_transaction_due_date);
227: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'GL Date :'|| p_gl_date);
228: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate Type :'||p_exchange_rate_type);
229: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate :'||p_exchange_rate);
230: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Review Netting Batch Flag :'||p_review_netting_batch_flag);
231: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'l_agreement_name :'||l_agreement_name);
232: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'l_allow_disc_flag :'||l_allow_disc_flag);

Line 229: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate :'||p_exchange_rate);

225: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Batch Name :'||p_batch_name);
226: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Transaction Due Date :'||p_transaction_due_date);
227: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'GL Date :'|| p_gl_date);
228: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate Type :'||p_exchange_rate_type);
229: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate :'||p_exchange_rate);
230: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Review Netting Batch Flag :'||p_review_netting_batch_flag);
231: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'l_agreement_name :'||l_agreement_name);
232: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'l_allow_disc_flag :'||l_allow_disc_flag);
233:

Line 230: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Review Netting Batch Flag :'||p_review_netting_batch_flag);

226: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Transaction Due Date :'||p_transaction_due_date);
227: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'GL Date :'|| p_gl_date);
228: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate Type :'||p_exchange_rate_type);
229: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate :'||p_exchange_rate);
230: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Review Netting Batch Flag :'||p_review_netting_batch_flag);
231: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'l_agreement_name :'||l_agreement_name);
232: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'l_allow_disc_flag :'||l_allow_disc_flag);
233:
234: l_batch_id := FUN_NET_BATCHES_S.nextval;

Line 231: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'l_agreement_name :'||l_agreement_name);

227: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'GL Date :'|| p_gl_date);
228: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate Type :'||p_exchange_rate_type);
229: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate :'||p_exchange_rate);
230: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Review Netting Batch Flag :'||p_review_netting_batch_flag);
231: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'l_agreement_name :'||l_agreement_name);
232: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'l_allow_disc_flag :'||l_allow_disc_flag);
233:
234: l_batch_id := FUN_NET_BATCHES_S.nextval;
235:

Line 232: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'l_allow_disc_flag :'||l_allow_disc_flag);

228: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate Type :'||p_exchange_rate_type);
229: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Exchange Rate :'||p_exchange_rate);
230: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'Review Netting Batch Flag :'||p_review_netting_batch_flag);
231: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'l_agreement_name :'||l_agreement_name);
232: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'l_allow_disc_flag :'||l_allow_disc_flag);
233:
234: l_batch_id := FUN_NET_BATCHES_S.nextval;
235:
236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Generate Netting Batch Date: '||to_char(sysdate,'DD-MON-YYYY HH:MM'));

Line 270: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'INSERT INTO FUN_NET_BATCHES_ALL');

266:
267: l_transaction_due_date := to_char(fnd_date.canonical_to_date(p_settlement_date));
268: END IF;
269:
270: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'INSERT INTO FUN_NET_BATCHES_ALL');
271:
272: INSERT INTO FUN_NET_BATCHES_ALL
273: (batch_id,
274: object_version_number,

Line 355: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch','Before calling FUN_NET_ARAP_PKG.create_net_batch');

351: NULL,
352: NULL,
353: NULL);
354:
355: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch','Before calling FUN_NET_ARAP_PKG.create_net_batch');
356: FUN_NET_ARAP_PKG.create_net_batch(
357: p_init_msg_list => FND_API.G_TRUE,
358: p_commit => FND_API.G_TRUE,
359: x_return_status => l_return_status,

Line 363: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch','Return FUN_NET_ARAP_PKG.create_net_batch');

359: x_return_status => l_return_status,
360: x_msg_count => l_msg_count,
361: x_msg_data => l_msg_data,
362: p_batch_id => l_batch_id);
363: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch','Return FUN_NET_ARAP_PKG.create_net_batch');
364: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch','l_return_status :'||l_return_status);
365: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
366: OPEN c_batch(l_batch_id);
367: LOOP

Line 364: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch','l_return_status :'||l_return_status);

360: x_msg_count => l_msg_count,
361: x_msg_data => l_msg_data,
362: p_batch_id => l_batch_id);
363: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch','Return FUN_NET_ARAP_PKG.create_net_batch');
364: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch','l_return_status :'||l_return_status);
365: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
366: OPEN c_batch(l_batch_id);
367: LOOP
368: FETCH c_batch INTO l_batch_id, l_batch_name, l_agreement_name, l_batch_currency, l_batch_status;

Line 375: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch','Error');

371: END LOOP;
372: CLOSE c_batch;
373: retcode := 0;
374: ELSE
375: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch','Error');
376: retcode := 2;
377: END IF;
378: END IF;
379:

Line 390: END FUN_NET_CONC_PROG_PKG;

386: retcode := 2;
387:
388: END Generate_Net_Batch;
389:
390: END FUN_NET_CONC_PROG_PKG;