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 FND_FILE

Line 63: FND_FILE.PUT_LINE(FND_FILE.LOG,errbuf);

59: errbuf := FND_MESSAGE.GET;
60: IF errbuf IS NULL THEN
61: EXIT;
62: ELSE
63: FND_FILE.PUT_LINE(FND_FILE.LOG,errbuf);
64: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
65: END IF;
66: END LOOP;
67:

Line 64: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

60: IF errbuf IS NULL THEN
61: EXIT;
62: ELSE
63: FND_FILE.PUT_LINE(FND_FILE.LOG,errbuf);
64: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
65: END IF;
66: END LOOP;
67:
68: retcode := 2;

Line 107: FND_FILE.PUT_LINE(FND_FILE.LOG,errbuf);

103: errbuf := FND_MESSAGE.GET;
104: IF errbuf IS NULL THEN
105: EXIT;
106: ELSE
107: FND_FILE.PUT_LINE(FND_FILE.LOG,errbuf);
108: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
109: END IF;
110: END LOOP;
111:

Line 108: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

104: IF errbuf IS NULL THEN
105: EXIT;
106: ELSE
107: FND_FILE.PUT_LINE(FND_FILE.LOG,errbuf);
108: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
109: END IF;
110: END LOOP;
111:
112: retcode := 2;

Line 151: FND_FILE.PUT_LINE(FND_FILE.LOG,errbuf);

147: errbuf := FND_MESSAGE.GET;
148: IF errbuf IS NULL THEN
149: EXIT;
150: ELSE
151: FND_FILE.PUT_LINE(FND_FILE.LOG,errbuf);
152: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
153: END IF;
154: END LOOP;
155:

Line 152: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

148: IF errbuf IS NULL THEN
149: EXIT;
150: ELSE
151: FND_FILE.PUT_LINE(FND_FILE.LOG,errbuf);
152: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
153: END IF;
154: END LOOP;
155:
156: retcode := 2;

Line 236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Generate Netting Batch Date: '||to_char(sysdate,'DD-MON-YYYY HH:MM'));

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'));
237: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Operating Unit : '||l_org_name);
239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Agreement Name : '||l_agreement_name);
240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Settlement Date : '|| fnd_date.canonical_to_date(p_settlement_date));

Line 237: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );

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'));
237: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Operating Unit : '||l_org_name);
239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Agreement Name : '||l_agreement_name);
240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Settlement Date : '|| fnd_date.canonical_to_date(p_settlement_date));
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Response Date : '|| fnd_date.canonical_to_date(p_response_date));

Line 238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Operating Unit : '||l_org_name);

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'));
237: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Operating Unit : '||l_org_name);
239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Agreement Name : '||l_agreement_name);
240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Settlement Date : '|| fnd_date.canonical_to_date(p_settlement_date));
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Response Date : '|| fnd_date.canonical_to_date(p_response_date));
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Name : '||p_batch_name);

Line 239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Agreement Name : '||l_agreement_name);

235:
236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Generate Netting Batch Date: '||to_char(sysdate,'DD-MON-YYYY HH:MM'));
237: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Operating Unit : '||l_org_name);
239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Agreement Name : '||l_agreement_name);
240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Settlement Date : '|| fnd_date.canonical_to_date(p_settlement_date));
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Response Date : '|| fnd_date.canonical_to_date(p_response_date));
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Name : '||p_batch_name);
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transaction Due Date : '||p_transaction_due_date);

Line 240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Settlement Date : '|| fnd_date.canonical_to_date(p_settlement_date));

236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Generate Netting Batch Date: '||to_char(sysdate,'DD-MON-YYYY HH:MM'));
237: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Operating Unit : '||l_org_name);
239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Agreement Name : '||l_agreement_name);
240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Settlement Date : '|| fnd_date.canonical_to_date(p_settlement_date));
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Response Date : '|| fnd_date.canonical_to_date(p_response_date));
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Name : '||p_batch_name);
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transaction Due Date : '||p_transaction_due_date);
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' GL Date : '|| fnd_date.canonical_to_date(p_gl_date));

Line 241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Response Date : '|| fnd_date.canonical_to_date(p_response_date));

237: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Operating Unit : '||l_org_name);
239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Agreement Name : '||l_agreement_name);
240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Settlement Date : '|| fnd_date.canonical_to_date(p_settlement_date));
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Response Date : '|| fnd_date.canonical_to_date(p_response_date));
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Name : '||p_batch_name);
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transaction Due Date : '||p_transaction_due_date);
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' GL Date : '|| fnd_date.canonical_to_date(p_gl_date));
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate Type : '||p_exchange_rate_type);

Line 242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Name : '||p_batch_name);

238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Operating Unit : '||l_org_name);
239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Agreement Name : '||l_agreement_name);
240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Settlement Date : '|| fnd_date.canonical_to_date(p_settlement_date));
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Response Date : '|| fnd_date.canonical_to_date(p_response_date));
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Name : '||p_batch_name);
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transaction Due Date : '||p_transaction_due_date);
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' GL Date : '|| fnd_date.canonical_to_date(p_gl_date));
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate Type : '||p_exchange_rate_type);
246:

Line 243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transaction Due Date : '||p_transaction_due_date);

239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Agreement Name : '||l_agreement_name);
240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Settlement Date : '|| fnd_date.canonical_to_date(p_settlement_date));
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Response Date : '|| fnd_date.canonical_to_date(p_response_date));
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Name : '||p_batch_name);
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transaction Due Date : '||p_transaction_due_date);
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' GL Date : '|| fnd_date.canonical_to_date(p_gl_date));
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate Type : '||p_exchange_rate_type);
246:
247: IF p_exchange_rate_type = 'User' THEN

Line 244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' GL Date : '|| fnd_date.canonical_to_date(p_gl_date));

240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Settlement Date : '|| fnd_date.canonical_to_date(p_settlement_date));
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Response Date : '|| fnd_date.canonical_to_date(p_response_date));
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Name : '||p_batch_name);
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transaction Due Date : '||p_transaction_due_date);
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' GL Date : '|| fnd_date.canonical_to_date(p_gl_date));
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate Type : '||p_exchange_rate_type);
246:
247: IF p_exchange_rate_type = 'User' THEN
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate : '||p_exchange_rate);

Line 245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate Type : '||p_exchange_rate_type);

241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Response Date : '|| fnd_date.canonical_to_date(p_response_date));
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Name : '||p_batch_name);
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transaction Due Date : '||p_transaction_due_date);
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' GL Date : '|| fnd_date.canonical_to_date(p_gl_date));
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate Type : '||p_exchange_rate_type);
246:
247: IF p_exchange_rate_type = 'User' THEN
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate : '||p_exchange_rate);
249: END IF;

Line 248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate : '||p_exchange_rate);

244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' GL Date : '|| fnd_date.canonical_to_date(p_gl_date));
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate Type : '||p_exchange_rate_type);
246:
247: IF p_exchange_rate_type = 'User' THEN
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate : '||p_exchange_rate);
249: END IF;
250:
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Review Netting Batch Flag : '||p_review_netting_batch_flag);
252: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );

Line 251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Review Netting Batch Flag : '||p_review_netting_batch_flag);

247: IF p_exchange_rate_type = 'User' THEN
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate : '||p_exchange_rate);
249: END IF;
250:
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Review Netting Batch Flag : '||p_review_netting_batch_flag);
252: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
253:
254: IF(to_date(substr(p_settlement_date,0,11), 'YYYY-MM-DD')) < trunc(sysdate) THEN
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error Message:');

Line 252: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );

248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate : '||p_exchange_rate);
249: END IF;
250:
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Review Netting Batch Flag : '||p_review_netting_batch_flag);
252: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
253:
254: IF(to_date(substr(p_settlement_date,0,11), 'YYYY-MM-DD')) < trunc(sysdate) THEN
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error Message:');
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Please enter a Settlement Date which is on or after today''s date.');

Line 255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error Message:');

251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Review Netting Batch Flag : '||p_review_netting_batch_flag);
252: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
253:
254: IF(to_date(substr(p_settlement_date,0,11), 'YYYY-MM-DD')) < trunc(sysdate) THEN
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error Message:');
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Please enter a Settlement Date which is on or after today''s date.');
257: retcode := 1;
258: ELSE
259:

Line 256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Please enter a Settlement Date which is on or after today''s date.');

252: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
253:
254: IF(to_date(substr(p_settlement_date,0,11), 'YYYY-MM-DD')) < trunc(sysdate) THEN
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error Message:');
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Please enter a Settlement Date which is on or after today''s date.');
257: retcode := 1;
258: ELSE
259:
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Batch Name Agreement Names Status Currency' );

Line 260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Batch Name Agreement Names Status Currency' );

256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Please enter a Settlement Date which is on or after today''s date.');
257: retcode := 1;
258: ELSE
259:
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Batch Name Agreement Names Status Currency' );
261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ---------- --------------- ------ --------');
262:
263: l_transaction_due_date := p_transaction_due_date;
264:

Line 261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ---------- --------------- ------ --------');

257: retcode := 1;
258: ELSE
259:
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Batch Number Batch Name Agreement Names Status Currency' );
261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ---------- --------------- ------ --------');
262:
263: l_transaction_due_date := p_transaction_due_date;
264:
265: IF nvl(l_allow_disc_flag, 'N') = 'Y' THEN

Line 370: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(substr(l_batch_id,1,15),15)||rpad(substr(l_batch_name,1,80),20)||rpad(substr(l_agreement_name,1,80),40)||rpad(substr(l_batch_status,1,15),15)||l_batch_currency);

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;
369: EXIT WHEN c_batch%NOTFOUND;
370: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,rpad(substr(l_batch_id,1,15),15)||rpad(substr(l_batch_name,1,80),20)||rpad(substr(l_agreement_name,1,80),40)||rpad(substr(l_batch_status,1,15),15)||l_batch_currency);
371: END LOOP;
372: CLOSE c_batch;
373: retcode := 0;
374: ELSE

Line 382: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Data Found');

378: END IF;
379:
380: EXCEPTION
381: WHEN NO_DATA_FOUND THEN
382: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Data Found');
383: retcode := 2;
384: WHEN OTHERS THEN
385: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);
386: retcode := 2;

Line 385: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);

381: WHEN NO_DATA_FOUND THEN
382: FND_FILE.PUT_LINE(FND_FILE.LOG,'No Data Found');
383: retcode := 2;
384: WHEN OTHERS THEN
385: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error:' || sqlcode || sqlerrm);
386: retcode := 2;
387:
388: END Generate_Net_Batch;
389: