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.IEX_UWQ_POP_SUM_TBL_PVT dependencies on FND_FILE

Line 51: fnd_file.put_line(FND_FILE.LOG, p_msg);

47: if (p_msg_level >= G_MSG_LEVEL) then
48:
49: FND_LOG.STRING(p_msg_level, G_PKG_NAME, p_msg);
50: if FND_GLOBAL.Conc_Request_Id is not null then
51: fnd_file.put_line(FND_FILE.LOG, p_msg);
52: end if;
53:
54: end if;
55:

Line 83: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_noof_active_busi_events: '||l_noof_active_busi_events);

79: AND wes.status = 'ENABLED'
80: AND we.status = 'ENABLED';
81:
82: iex_debug_pub.logmessage( 'l_noof_active_busi_events: '||l_noof_active_busi_events );
83: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_noof_active_busi_events: '||l_noof_active_busi_events);
84:
85: IF ( l_noof_active_busi_events > 0 ) THEN
86: SELECT count(1) INTO l_count
87: FROM fnd_concurrent_requests

Line 94: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_count: '||l_count);

90: WHERE concurrent_program_name = 'IEXDLMGB')
91: AND ((phase_code = 'R') OR (phase_code = 'P' AND status_code = 'C'));
92:
93: iex_debug_pub.logmessage( 'l_count :'||l_count );
94: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_count: '||l_count);
95: IF l_count > 0 THEN
96: RETURN TRUE;
97: ELSE
98: RETURN FALSE;

Line 180: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting to update ar_trx_bal_summary with reference_1 = 1...');

176: --Start bug 6876187 gnramasa 14th mar 08
177: --update ar_trx_bal_summary set reference_1 = 1;
178: --Begin bug#7133605 schekuri 09-Jun-2008
179: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Starting to update ar_trx_bal_summary with reference_1 = 1...');
180: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting to update ar_trx_bal_summary with reference_1 = 1...');
181: BEGIN
182: OPEN c_cust_account_id_1;
183: LOOP
184: FETCH c_cust_account_id_1 BULK COLLECT INTO

Line 203: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Rows updated in ar_trx_bal_summary with reference_1 = 1-->'||l_cust_account_id_1.count);

199:
200: commit;
201:
202: IEX_DEBUG_PUB.LOGMESSAGE(SQL%ROWCOUNT || ' Rows updated in ar_trx_bal_summary with reference_1 = 1');
203: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Rows updated in ar_trx_bal_summary with reference_1 = 1-->'||l_cust_account_id_1.count);
204:
205: END IF;
206: END LOOP;
207: EXCEPTION

Line 210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deadlock detected when updating ar_trx_bal_summary.reference to 1' || sqlerrm);

206: END LOOP;
207: EXCEPTION
208:
209: WHEN deadlock_detected THEN
210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deadlock detected when updating ar_trx_bal_summary.reference to 1' || sqlerrm);
211: LogMessage(FND_LOG.LEVEL_STATEMENT,' Deadlock detected when updating ar_trx_bal_summary.reference to 1.');
212: ROLLBACK;
213: l_cust_account_id_1.delete;
214: if c_cust_account_id_1%ISOPEN then

Line 236: FND_FILE.PUT_LINE(FND_FILE.LOG,'updated records- '||l_cust_account_id_1.count);

232: UPDATE AR_TRX_BAL_SUMMARY
233: SET REFERENCE_1 = '1'
234: WHERE cust_account_id=l_cust_account_id1
235: and REFERENCE_1 is null;
236: FND_FILE.PUT_LINE(FND_FILE.LOG,'updated records- '||l_cust_account_id_1.count);
237:
238: CLOSE C_CUST_ACCOUNT_ID_DL1;
239: EXCEPTION
240: WHEN LOCKED_BY_ANOTHER_SESSION THEN

Line 261: FND_FILE.PUT_LINE(FND_FILE.LOG,'Locked by another session when updating ar_trx_bal_summary.reference to 1');

257:
258: END IF;
259: END LOOP;
260: WHEN locked_by_another_session THEN
261: FND_FILE.PUT_LINE(FND_FILE.LOG,'Locked by another session when updating ar_trx_bal_summary.reference to 1');
262: if c_cust_account_id_1%ISOPEN then
263: close c_cust_account_id_1;
264: end if;
265: ROLLBACK;

Line 279: -- FND_FILE.PUT_LINE(FND_FILE.LOG,SQL%ROWCOUNT || ' Rows updated in ar_trx_bal_summary with reference_1 = Null');

275: FETCH c_cust_account_id_n BULK COLLECT INTO
276: l_cust_account_id_n LIMIT G_BATCH_SIZE;
277: IF l_cust_account_id_n.count = 0 THEN
278: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Exit after Update ar_trx_bal_summary on complete with reference_1 = Null...');
279: -- FND_FILE.PUT_LINE(FND_FILE.LOG,SQL%ROWCOUNT || ' Rows updated in ar_trx_bal_summary with reference_1 = Null');
280: CLOSE c_cust_account_id_n;
281: EXIT;
282: ELSE
283: FORALL I IN l_cust_account_id_n.first..l_cust_account_id_n.last

Line 290: FND_FILE.PUT_LINE(FND_FILE.LOG,' Rows updated in ar_trx_bal_summary with reference_1 = Null->'||l_cust_account_id_n.count);

286: WHERE CUST_ACCOUNT_ID = l_cust_account_id_n(I)
287: and reference_1='1';
288: l_cust_account_id_n.delete;
289: commit;
290: FND_FILE.PUT_LINE(FND_FILE.LOG,' Rows updated in ar_trx_bal_summary with reference_1 = Null->'||l_cust_account_id_n.count);
291: LogMessage(FND_LOG.LEVEL_UNEXPECTED,l_cust_account_id_n.count || 'Rows updated in ar_trx_bal_summary with reference_1 = Null');
292: END IF;
293: END LOOP;
294: EXCEPTION

Line 296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deadlock detected when updating ar_trx_bal_summary.reference to null' || sqlerrm);

292: END IF;
293: END LOOP;
294: EXCEPTION
295: WHEN deadlock_detected THEN
296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deadlock detected when updating ar_trx_bal_summary.reference to null' || sqlerrm);
297: LogMessage(FND_LOG.LEVEL_STATEMENT,' Deadlock detected when updating ar_trx_bal_summary.reference to null.');
298: ROLLBACK;
299: l_cust_account_id_n.delete;
300: if c_cust_account_id_n%ISOPEN then

Line 322: FND_FILE.PUT_LINE(FND_FILE.LOG,'updated records '||sql%rowcount);

318: UPDATE AR_TRX_BAL_SUMMARY
319: SET REFERENCE_1 = null
320: WHERE cust_account_id=l_cust_account_id1
321: and REFERENCE_1 = '1';
322: FND_FILE.PUT_LINE(FND_FILE.LOG,'updated records '||sql%rowcount);
323:
324: CLOSE C_CUST_ACCOUNT_ID_DLN;
325: EXCEPTION
326: WHEN LOCKED_BY_ANOTHER_SESSION THEN

Line 347: FND_FILE.PUT_LINE(FND_FILE.LOG,'Locked by another session when updating ar_trx_bal_summary.reference to 1');

343:
344: END IF;
345: END LOOP;
346: WHEN locked_by_another_session THEN
347: FND_FILE.PUT_LINE(FND_FILE.LOG,'Locked by another session when updating ar_trx_bal_summary.reference to 1');
348: if c_cust_account_id_1%ISOPEN then
349: close c_cust_account_id_1;
350: end if;
351: ROLLBACK;

Line 436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing Org_id value to set the multi level strategy at OU..Please pass the org_id value' );

432: --if (l_from_date is null and p_mode = 'CP' and G_LEVEL_COUNT=0 ) then --Bug5691098
433: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Fully repopulating IEX_DLN_UWQ_SUMMARY table...');
434:
435: /* if p_org_id is null and G_OU_LVL_ENB='Y' then
436: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing Org_id value to set the multi level strategy at OU..Please pass the org_id value' );
437: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Missing Org_id value to set the multi level strategy at OU..Please pass the org_id value');
438: return;
439: end if;*/--will be handled in parameter window
440:

Line 447: FND_FILE.PUT_LINE(FND_FILE.LOG,'Input FROM_DATE = ' || l_from_date);

443:
444: l_return_status := 'S';
445: l_from_date := to_date(substr(FROM_DATE, 1, 10), 'YYYY/MM/DD');
446: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Input FROM_DATE = ' || l_from_date);
447: FND_FILE.PUT_LINE(FND_FILE.LOG,'Input FROM_DATE = ' || l_from_date);
448:
449: x := fnd_installation.get_app_info ('FND',l_out_status,l_out_industry,l_out_oracle_schema);
450: LogMessage(FND_LOG.LEVEL_STATEMENT,'IEX Schema:'||l_out_oracle_schema);
451:

Line 458: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');

454: if G_OU_LVL_ENB='Y' then
455: mo_global.init('IEX');
456: if p_org_id is null then
457: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
458: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
459: --open c_org(l_org_id);
460: else
461: MO_GLOBAL.SET_POLICY_CONTEXT('S',p_ORG_ID);
462: end if;

Line 466: FND_FILE.PUT_LINE(FND_FILE.LOG, 'org_id is-->'||l_curr_org_id);

462: end if;
463:
464: for i in c_org(p_org_id) loop
465: l_curr_org_id:=i.organization_id;
466: FND_FILE.PUT_LINE(FND_FILE.LOG, 'org_id is-->'||l_curr_org_id);
467: if (l_from_date is null and p_truncate_table='Y') then
468: /*OPEN c_get_table;
469: FETCH c_get_table INTO l_truncate_table;
470: CLOSE c_get_table;

Line 486: FND_FILE.PUT_LINE(FND_FILE.LOG,'records deleted for org_id-'||l_curr_org_id);

482: delete from iex_dln_uwq_summary
483: where org_id=l_curr_org_id;
484: elsif l_from_date is not null then
485:
486: FND_FILE.PUT_LINE(FND_FILE.LOG,'records deleted for org_id-'||l_curr_org_id);
487:
488: open c_get_ou_biz_lvl(l_curr_org_id);
489: fetch c_get_ou_biz_lvl into G_SYSTEM_LEVEL;
490: close c_get_ou_biz_lvl;

Line 491: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OU lvl is-->'||G_SYSTEM_LEVEL);

487:
488: open c_get_ou_biz_lvl(l_curr_org_id);
489: fetch c_get_ou_biz_lvl into G_SYSTEM_LEVEL;
490: close c_get_ou_biz_lvl;
491: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OU lvl is-->'||G_SYSTEM_LEVEL);
492:
493: for r_allowed_levels in c_allowed_levels loop
494: l_allowed_lvl:=r_allowed_LEVELS.lookup_code;
495: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in ou-->'||r_allowed_LEVELS.lookup_code);

Line 495: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in ou-->'||r_allowed_LEVELS.lookup_code);

491: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OU lvl is-->'||G_SYSTEM_LEVEL);
492:
493: for r_allowed_levels in c_allowed_levels loop
494: l_allowed_lvl:=r_allowed_LEVELS.lookup_code;
495: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in ou-->'||r_allowed_LEVELS.lookup_code);
496: if (g_party_lvl_enb='N' and l_allowed_lvl=g_system_level) or g_party_lvl_enb='Y' then
497: IF l_allowed_lvl = 'CUSTOMER' THEN
498: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Customer level--in OU');
499: delete from IEX_DLN_UWQ_SUMMARY where (party_id,org_id) in

Line 498: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Customer level--in OU');

494: l_allowed_lvl:=r_allowed_LEVELS.lookup_code;
495: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in ou-->'||r_allowed_LEVELS.lookup_code);
496: if (g_party_lvl_enb='N' and l_allowed_lvl=g_system_level) or g_party_lvl_enb='Y' then
497: IF l_allowed_lvl = 'CUSTOMER' THEN
498: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Customer level--in OU');
499: delete from IEX_DLN_UWQ_SUMMARY where (party_id,org_id) in
500: (select hza.party_id,trb.org_id from ar_trx_bal_summary trb, hz_cust_accounts hza
501: where hza.cust_account_id = trb.cust_account_id and trunc(trb.LAST_UPDATE_DATE) >= trunc(l_from_date)
502: and trb.org_id=nvl(l_curr_org_id,trb.org_id))

Line 504: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at Cust level-->'||sql%rowcount);

500: (select hza.party_id,trb.org_id from ar_trx_bal_summary trb, hz_cust_accounts hza
501: where hza.cust_account_id = trb.cust_account_id and trunc(trb.LAST_UPDATE_DATE) >= trunc(l_from_date)
502: and trb.org_id=nvl(l_curr_org_id,trb.org_id))
503: and cust_account_id is null and site_use_id is null;--Added for Bug 8707923 27-Jul-2009 barathsr
504: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at Cust level-->'||sql%rowcount);
505: ELSIF l_allowed_lvl = 'ACCOUNT' THEN
506: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Account level--in OU');
507: delete from IEX_DLN_UWQ_SUMMARY where (cust_account_id, org_id) in
508: (select cust_account_id, org_id from ar_trx_bal_summary trb where trunc(LAST_UPDATE_DATE) >= trunc(l_from_date)

Line 506: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Account level--in OU');

502: and trb.org_id=nvl(l_curr_org_id,trb.org_id))
503: and cust_account_id is null and site_use_id is null;--Added for Bug 8707923 27-Jul-2009 barathsr
504: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at Cust level-->'||sql%rowcount);
505: ELSIF l_allowed_lvl = 'ACCOUNT' THEN
506: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Account level--in OU');
507: delete from IEX_DLN_UWQ_SUMMARY where (cust_account_id, org_id) in
508: (select cust_account_id, org_id from ar_trx_bal_summary trb where trunc(LAST_UPDATE_DATE) >= trunc(l_from_date)
509: and trb.org_id=nvl(l_curr_org_id,trb.org_id))
510: and site_use_id is null;--Added for Bug 8707923 27-Jul-2009 barathsr

Line 511: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at A/c level-->'||sql%rowcount);

507: delete from IEX_DLN_UWQ_SUMMARY where (cust_account_id, org_id) in
508: (select cust_account_id, org_id from ar_trx_bal_summary trb where trunc(LAST_UPDATE_DATE) >= trunc(l_from_date)
509: and trb.org_id=nvl(l_curr_org_id,trb.org_id))
510: and site_use_id is null;--Added for Bug 8707923 27-Jul-2009 barathsr
511: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at A/c level-->'||sql%rowcount);
512: ELSIF l_allowed_lvl = 'BILL_TO' THEN
513: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at BillTo level--in OU');
514: delete from IEX_DLN_UWQ_SUMMARY where (cust_account_id, site_use_id, org_id) in
515: (select cust_account_id, site_use_id, org_id from ar_trx_bal_summary trb where trunc(LAST_UPDATE_DATE) >= trunc(l_from_date)

Line 513: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at BillTo level--in OU');

509: and trb.org_id=nvl(l_curr_org_id,trb.org_id))
510: and site_use_id is null;--Added for Bug 8707923 27-Jul-2009 barathsr
511: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at A/c level-->'||sql%rowcount);
512: ELSIF l_allowed_lvl = 'BILL_TO' THEN
513: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at BillTo level--in OU');
514: delete from IEX_DLN_UWQ_SUMMARY where (cust_account_id, site_use_id, org_id) in
515: (select cust_account_id, site_use_id, org_id from ar_trx_bal_summary trb where trunc(LAST_UPDATE_DATE) >= trunc(l_from_date)
516: and trb.org_id=nvl(l_curr_org_id,trb.org_id))
517: and site_use_id is not null;--Added for Bug 8707923 27-Jul-2009 barathsr

Line 518: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at Billto level-->'||sql%rowcount);

514: delete from IEX_DLN_UWQ_SUMMARY where (cust_account_id, site_use_id, org_id) in
515: (select cust_account_id, site_use_id, org_id from ar_trx_bal_summary trb where trunc(LAST_UPDATE_DATE) >= trunc(l_from_date)
516: and trb.org_id=nvl(l_curr_org_id,trb.org_id))
517: and site_use_id is not null;--Added for Bug 8707923 27-Jul-2009 barathsr
518: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at Billto level-->'||sql%rowcount);
519: END IF;
520: end if;
521: end loop;
522: end if;

Line 544: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside party level');

540: 'IEX_DLN_UWQ_SUMMARY' );
541:
542: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncated IEX_DLN_UWQ_SUMMARY');
543: elsif l_from_date is not null then
544: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside party level');
545: open c_get_level;
546: fetch c_get_level into G_SYSTEM_LEVEL;
547: close c_get_level;
548: FND_FILE.PUT_LINE(FND_FILE.LOG, 'party lvl is-->'||G_SYSTEM_LEVEL);

Line 548: FND_FILE.PUT_LINE(FND_FILE.LOG, 'party lvl is-->'||G_SYSTEM_LEVEL);

544: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside party level');
545: open c_get_level;
546: fetch c_get_level into G_SYSTEM_LEVEL;
547: close c_get_level;
548: FND_FILE.PUT_LINE(FND_FILE.LOG, 'party lvl is-->'||G_SYSTEM_LEVEL);
549: for r_allowed_levels in c_allowed_levels loop
550: l_allowed_lvl:=r_allowed_LEVELS.lookup_code;
551: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in party-->'||r_allowed_LEVELS.lookup_code);
552: IF l_allowed_lvl = 'CUSTOMER' THEN

Line 551: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in party-->'||r_allowed_LEVELS.lookup_code);

547: close c_get_level;
548: FND_FILE.PUT_LINE(FND_FILE.LOG, 'party lvl is-->'||G_SYSTEM_LEVEL);
549: for r_allowed_levels in c_allowed_levels loop
550: l_allowed_lvl:=r_allowed_LEVELS.lookup_code;
551: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in party-->'||r_allowed_LEVELS.lookup_code);
552: IF l_allowed_lvl = 'CUSTOMER' THEN
553: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Customer level--in party ');
554: delete from IEX_DLN_UWQ_SUMMARY where (party_id,org_id) in
555: (select hza.party_id,trb.org_id from ar_trx_bal_summary trb, hz_cust_accounts hza

Line 553: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Customer level--in party ');

549: for r_allowed_levels in c_allowed_levels loop
550: l_allowed_lvl:=r_allowed_LEVELS.lookup_code;
551: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in party-->'||r_allowed_LEVELS.lookup_code);
552: IF l_allowed_lvl = 'CUSTOMER' THEN
553: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Customer level--in party ');
554: delete from IEX_DLN_UWQ_SUMMARY where (party_id,org_id) in
555: (select hza.party_id,trb.org_id from ar_trx_bal_summary trb, hz_cust_accounts hza
556: where hza.cust_account_id = trb.cust_account_id and trunc(trb.LAST_UPDATE_DATE) >= trunc(l_from_date))
557: -- and trb.org_id=nvl(l_curr_org_id,trb.org_id)

Line 559: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at Cust level-->'||sql%rowcount);

555: (select hza.party_id,trb.org_id from ar_trx_bal_summary trb, hz_cust_accounts hza
556: where hza.cust_account_id = trb.cust_account_id and trunc(trb.LAST_UPDATE_DATE) >= trunc(l_from_date))
557: -- and trb.org_id=nvl(l_curr_org_id,trb.org_id)
558: and cust_account_id is null and site_use_id is null;--Added for Bug 8707923 27-Jul-2009 barathsr
559: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at Cust level-->'||sql%rowcount);
560: ELSIF l_allowed_lvl = 'ACCOUNT' THEN
561: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Account level--in party ');
562: delete from IEX_DLN_UWQ_SUMMARY where (cust_account_id, org_id) in
563: (select cust_account_id, org_id from ar_trx_bal_summary trb where trunc(LAST_UPDATE_DATE) >= trunc(l_from_date))

Line 561: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Account level--in party ');

557: -- and trb.org_id=nvl(l_curr_org_id,trb.org_id)
558: and cust_account_id is null and site_use_id is null;--Added for Bug 8707923 27-Jul-2009 barathsr
559: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at Cust level-->'||sql%rowcount);
560: ELSIF l_allowed_lvl = 'ACCOUNT' THEN
561: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Account level--in party ');
562: delete from IEX_DLN_UWQ_SUMMARY where (cust_account_id, org_id) in
563: (select cust_account_id, org_id from ar_trx_bal_summary trb where trunc(LAST_UPDATE_DATE) >= trunc(l_from_date))
564: -- and trb.org_id=nvl(l_curr_org_id,trb.org_id)
565: and site_use_id is null;--Added for Bug 8707923 27-Jul-2009 barathsr

Line 566: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at A/C level-->'||sql%rowcount);

562: delete from IEX_DLN_UWQ_SUMMARY where (cust_account_id, org_id) in
563: (select cust_account_id, org_id from ar_trx_bal_summary trb where trunc(LAST_UPDATE_DATE) >= trunc(l_from_date))
564: -- and trb.org_id=nvl(l_curr_org_id,trb.org_id)
565: and site_use_id is null;--Added for Bug 8707923 27-Jul-2009 barathsr
566: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at A/C level-->'||sql%rowcount);
567: ELSIF l_allowed_lvl = 'BILL_TO' THEN
568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at BillTo level--in party ');
569: delete from IEX_DLN_UWQ_SUMMARY where (cust_account_id, site_use_id, org_id) in
570: (select cust_account_id, site_use_id, org_id from ar_trx_bal_summary trb where trunc(LAST_UPDATE_DATE) >= trunc(l_from_date))

Line 568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at BillTo level--in party ');

564: -- and trb.org_id=nvl(l_curr_org_id,trb.org_id)
565: and site_use_id is null;--Added for Bug 8707923 27-Jul-2009 barathsr
566: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at A/C level-->'||sql%rowcount);
567: ELSIF l_allowed_lvl = 'BILL_TO' THEN
568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at BillTo level--in party ');
569: delete from IEX_DLN_UWQ_SUMMARY where (cust_account_id, site_use_id, org_id) in
570: (select cust_account_id, site_use_id, org_id from ar_trx_bal_summary trb where trunc(LAST_UPDATE_DATE) >= trunc(l_from_date))
571: -- and trb.org_id=nvl(l_curr_org_id,trb.org_id))
572: and site_use_id is not null;--Added for Bug 8707923 27-Jul-2009 barathsr

Line 573: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at Billto level-->'||sql%rowcount);

569: delete from IEX_DLN_UWQ_SUMMARY where (cust_account_id, site_use_id, org_id) in
570: (select cust_account_id, site_use_id, org_id from ar_trx_bal_summary trb where trunc(LAST_UPDATE_DATE) >= trunc(l_from_date))
571: -- and trb.org_id=nvl(l_curr_org_id,trb.org_id))
572: and site_use_id is not null;--Added for Bug 8707923 27-Jul-2009 barathsr
573: FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of records deleted at Billto level-->'||sql%rowcount);
574: END IF;
575: end loop;
576: end if;
577: end if;

Line 599: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside system level-->'||G_SYSTEM_LEVEL);

595: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncated IEX_DLN_UWQ_SUMMARY');
596: elsif l_from_date is not null then
597: open c_get_level;
598: fetch c_get_level into G_SYSTEM_LEVEL;
599: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside system level-->'||G_SYSTEM_LEVEL);
600: if G_SYSTEM_LEVEL is not null then
601: IF g_system_level = 'CUSTOMER' THEN
602: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Customer level--in sys lvl ');
603: delete from IEX_DLN_UWQ_SUMMARY where (party_id,org_id) in

Line 602: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Customer level--in sys lvl ');

598: fetch c_get_level into G_SYSTEM_LEVEL;
599: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside system level-->'||G_SYSTEM_LEVEL);
600: if G_SYSTEM_LEVEL is not null then
601: IF g_system_level = 'CUSTOMER' THEN
602: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Customer level--in sys lvl ');
603: delete from IEX_DLN_UWQ_SUMMARY where (party_id,org_id) in
604: (select hza.party_id,trb.org_id from ar_trx_bal_summary trb, hz_cust_accounts hza
605: where hza.cust_account_id = trb.cust_account_id and trunc(trb.LAST_UPDATE_DATE) >= trunc(l_from_date))
606: -- and trb.org_id=nvl(l_curr_org_id,trb.org_id)

Line 609: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Account level--in sys lvl ');

605: where hza.cust_account_id = trb.cust_account_id and trunc(trb.LAST_UPDATE_DATE) >= trunc(l_from_date))
606: -- and trb.org_id=nvl(l_curr_org_id,trb.org_id)
607: and cust_account_id is null and site_use_id is null;--Added for Bug 8707923 27-Jul-2009 barathsr
608: ELSIF g_system_level = 'ACCOUNT' THEN
609: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at Account level--in sys lvl ');
610: delete from IEX_DLN_UWQ_SUMMARY where (cust_account_id, org_id) in
611: (select cust_account_id, org_id from ar_trx_bal_summary trb where trunc(LAST_UPDATE_DATE) >= trunc(l_from_date))
612: -- and trb.org_id=nvl(l_curr_org_id,trb.org_id)
613: and site_use_id is null;--Added for Bug 8707923 27-Jul-2009 barathsr

Line 615: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at BillTo level--in sys lvl');

611: (select cust_account_id, org_id from ar_trx_bal_summary trb where trunc(LAST_UPDATE_DATE) >= trunc(l_from_date))
612: -- and trb.org_id=nvl(l_curr_org_id,trb.org_id)
613: and site_use_id is null;--Added for Bug 8707923 27-Jul-2009 barathsr
614: ELSIF g_system_level = 'BILL_TO' THEN
615: FND_FILE.PUT_LINE(FND_FILE.LOG,'Deleting records at BillTo level--in sys lvl');
616: delete from IEX_DLN_UWQ_SUMMARY where (cust_account_id, site_use_id, org_id) in
617: (select cust_account_id, site_use_id, org_id from ar_trx_bal_summary trb where trunc(LAST_UPDATE_DATE) >= trunc(l_from_date))
618: -- and trb.org_id=nvl(l_curr_org_id,trb.org_id))
619: and site_use_id is not null;--Added for Bug 8707923 27-Jul-2009 barathsr

Line 652: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');

648: else
649: mo_global.init('IEX');
650: if p_org_id is null then
651: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
652: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
653: else
654: MO_GLOBAL.SET_POLICY_CONTEXT('S',p_ORG_ID);
655: end if;
656: for i in c_org(p_org_id) loop

Line 661: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of rows selected: ' || l_cnt);

657: l_org_id:=i.organization_id;
658: LogMessage(FND_LOG.LEVEL_STATEMENT,'Delete records corresponding to the org_id passed-->'||l_org_id);
659: select count(*) into l_cnt
660: from iex_dln_uwq_summary where org_id=l_org_id;
661: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of rows selected: ' || l_cnt);
662: delete from iex_dln_uwq_summary
663: where org_id=l_org_id;
664: LogMessage(FND_LOG.LEVEL_STATEMENT,'Records deleted for the org_id passed');
665: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED,'No of rows deleted: ' || SQL%ROWCOUNT);

Line 666: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'No of rows deleted: ' || SQL%ROWCOUNT);

662: delete from iex_dln_uwq_summary
663: where org_id=l_org_id;
664: LogMessage(FND_LOG.LEVEL_STATEMENT,'Records deleted for the org_id passed');
665: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED,'No of rows deleted: ' || SQL%ROWCOUNT);
666: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'No of rows deleted: ' || SQL%ROWCOUNT);
667: select count(*) into l_cnt1
668: from iex_dln_uwq_summary where org_id=l_org_id;
669: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of rows selected: ' || l_cnt);
670: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of rows remaining: ' || l_cnt1);

Line 669: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of rows selected: ' || l_cnt);

665: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED,'No of rows deleted: ' || SQL%ROWCOUNT);
666: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'No of rows deleted: ' || SQL%ROWCOUNT);
667: select count(*) into l_cnt1
668: from iex_dln_uwq_summary where org_id=l_org_id;
669: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of rows selected: ' || l_cnt);
670: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of rows remaining: ' || l_cnt1);
671: end loop;
672: end if;
673: end if;

Line 670: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of rows remaining: ' || l_cnt1);

666: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'No of rows deleted: ' || SQL%ROWCOUNT);
667: select count(*) into l_cnt1
668: from iex_dln_uwq_summary where org_id=l_org_id;
669: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of rows selected: ' || l_cnt);
670: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of rows remaining: ' || l_cnt1);
671: end loop;
672: end if;
673: end if;
674: end if;*/

Line 699: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQLERRM: ' || sqlerrm);

695:
696: when others then
697: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Exception in delete_rows_from_uwq_summ');
698: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'SQLCODE: ' || to_char(SQLCODE) || ' SQLERRM: ' || sqlerrm);
699: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQLERRM: ' || sqlerrm);
700: l_return_status := 'E';
701: Rollback;
702: DELETE from AR_CONC_PROCESS_REQUESTS
703: where REQUEST_ID = FND_GLOBAL.conc_request_id;

Line 761: FND_FILE.PUT_LINE(FND_FILE.LOG,'from date...-->'||from_date);

757: l_update_contact varchar2(5); -- Added for bug13713264 bibeura 15-Feb-2012
758: BEGIN
759: --Bug5691098. Start.
760: LogMessage(FND_LOG.LEVEL_STATEMENT,' Populate_uwq_sum_concur Started.');
761: FND_FILE.PUT_LINE(FND_FILE.LOG,'from date...-->'||from_date);
762: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id...-->'||p_org_id);
763: FND_FILE.PUT_LINE(FND_FILE.LOG,'truncate_table...-->'||p_truncate_table);
764: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_update_contact...-->'||p_update_contact);
765: LogMessage(FND_LOG.LEVEL_STATEMENT,' p_update_contact: ' || p_update_contact);

Line 762: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id...-->'||p_org_id);

758: BEGIN
759: --Bug5691098. Start.
760: LogMessage(FND_LOG.LEVEL_STATEMENT,' Populate_uwq_sum_concur Started.');
761: FND_FILE.PUT_LINE(FND_FILE.LOG,'from date...-->'||from_date);
762: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id...-->'||p_org_id);
763: FND_FILE.PUT_LINE(FND_FILE.LOG,'truncate_table...-->'||p_truncate_table);
764: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_update_contact...-->'||p_update_contact);
765: LogMessage(FND_LOG.LEVEL_STATEMENT,' p_update_contact: ' || p_update_contact);
766:

Line 763: FND_FILE.PUT_LINE(FND_FILE.LOG,'truncate_table...-->'||p_truncate_table);

759: --Bug5691098. Start.
760: LogMessage(FND_LOG.LEVEL_STATEMENT,' Populate_uwq_sum_concur Started.');
761: FND_FILE.PUT_LINE(FND_FILE.LOG,'from date...-->'||from_date);
762: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id...-->'||p_org_id);
763: FND_FILE.PUT_LINE(FND_FILE.LOG,'truncate_table...-->'||p_truncate_table);
764: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_update_contact...-->'||p_update_contact);
765: LogMessage(FND_LOG.LEVEL_STATEMENT,' p_update_contact: ' || p_update_contact);
766:
767: -- Bug13987015 by bibeura

Line 764: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_update_contact...-->'||p_update_contact);

760: LogMessage(FND_LOG.LEVEL_STATEMENT,' Populate_uwq_sum_concur Started.');
761: FND_FILE.PUT_LINE(FND_FILE.LOG,'from date...-->'||from_date);
762: FND_FILE.PUT_LINE(FND_FILE.LOG,'org_id...-->'||p_org_id);
763: FND_FILE.PUT_LINE(FND_FILE.LOG,'truncate_table...-->'||p_truncate_table);
764: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_update_contact...-->'||p_update_contact);
765: LogMessage(FND_LOG.LEVEL_STATEMENT,' p_update_contact: ' || p_update_contact);
766:
767: -- Bug13987015 by bibeura
768: -- If event subscriptions are enabled and IEX: Delinquencies Management concurrent program

Line 773: fnd_file.put_line(FND_FILE.LOG,'**************************************************************************************************************************************************');

769: -- is running, IEX: Populate UWQ Summary concurrent program should not be allowed to proceed.
770: -- Function is_incompatible is used to achieve the same
771:
772: IF is_incompatible THEN
773: fnd_file.put_line(FND_FILE.LOG,'**************************************************************************************************************************************************');
774: fnd_file.put_line(FND_FILE.LOG,'Populate UWQ Summary is not allowed to be run when event subscriptions are enabled and IEX: Delinquencies Management concurrent program is running');
775: fnd_file.put_line(FND_FILE.LOG,'**************************************************************************************************************************************************');
776: l_return := fnd_concurrent.set_completion_status (status => 'WARNING',
777: message => 'Other Incompatible programs are running. Please check concurrent request log for details');

Line 774: fnd_file.put_line(FND_FILE.LOG,'Populate UWQ Summary is not allowed to be run when event subscriptions are enabled and IEX: Delinquencies Management concurrent program is running');

770: -- Function is_incompatible is used to achieve the same
771:
772: IF is_incompatible THEN
773: fnd_file.put_line(FND_FILE.LOG,'**************************************************************************************************************************************************');
774: fnd_file.put_line(FND_FILE.LOG,'Populate UWQ Summary is not allowed to be run when event subscriptions are enabled and IEX: Delinquencies Management concurrent program is running');
775: fnd_file.put_line(FND_FILE.LOG,'**************************************************************************************************************************************************');
776: l_return := fnd_concurrent.set_completion_status (status => 'WARNING',
777: message => 'Other Incompatible programs are running. Please check concurrent request log for details');
778: return;

Line 775: fnd_file.put_line(FND_FILE.LOG,'**************************************************************************************************************************************************');

771:
772: IF is_incompatible THEN
773: fnd_file.put_line(FND_FILE.LOG,'**************************************************************************************************************************************************');
774: fnd_file.put_line(FND_FILE.LOG,'Populate UWQ Summary is not allowed to be run when event subscriptions are enabled and IEX: Delinquencies Management concurrent program is running');
775: fnd_file.put_line(FND_FILE.LOG,'**************************************************************************************************************************************************');
776: l_return := fnd_concurrent.set_completion_status (status => 'WARNING',
777: message => 'Other Incompatible programs are running. Please check concurrent request log for details');
778: return;
779: END IF;

Line 784: FND_FILE.PUT_LINE(FND_FILE.LOG,'populate party,ou global vars...');

780: -- Bug13987015 by bibeura
781:
782: IEX_CHECKLIST_UTILITY.UPDATE_MLSETUP;
783:
784: FND_FILE.PUT_LINE(FND_FILE.LOG,'populate party,ou global vars...');
785:
786: select DEFINE_PARTY_RUNNING_LEVEL,DEFINE_OU_RUNNING_LEVEL
787: into G_PARTY_LVL_ENB,G_OU_LVL_ENB
788: from IEX_QUESTIONNAIRE_ITEMS;

Line 803: fnd_file.put_line(FND_FILE.LOG,'Invalid set of parameters..Pl modify the set of parameters provided.');

799: l_return := fnd_concurrent.set_completion_status (status => 'WARNING',
800: message => 'Invalid set of parameters..Pl modify the set of parameters provided.');
801: end if;
802: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Invalid set of parameters..Pl modify the set of parameters provided.');
803: fnd_file.put_line(FND_FILE.LOG,'Invalid set of parameters..Pl modify the set of parameters provided.');
804: return;
805: end if;
806:
807: if from_date is null and l_truncate_table='N' and g_ou_lvl_enb='N' then

Line 813: fnd_file.put_line(FND_FILE.LOG,'Invalid set of parameters..Pl modify the set of parameters provided.');

809: l_return := fnd_concurrent.set_completion_status (status => 'WARNING',
810: message => 'Invalid set of parameters..Pl modify the set of parameters provided.');
811: end if;
812: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Invalid set of parameters..Pl modify the set of parameters provided.');
813: fnd_file.put_line(FND_FILE.LOG,'Invalid set of parameters..Pl modify the set of parameters provided.');
814: return;
815: end if;
816:
817: --End Bug 9079404 04-Nov-2009 barathsr

Line 824: fnd_file.put_line(FND_FILE.LOG, ' Delete or Truncate on table iex_dln_uwq_summary is not success. Ending the program');

820:
821: delete_rows_from_uwq_summ(from_date,p_org_id,l_truncate_table,l_return_status);
822: -- added for bug 13454263 pnaveenk
823: IF l_return_status <> 'S' THEN
824: fnd_file.put_line(FND_FILE.LOG, ' Delete or Truncate on table iex_dln_uwq_summary is not success. Ending the program');
825: return;
826: END IF;
827:
828:

Line 836: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');

832: mo_global.init('IEX');
833: if p_org_id is null then
834:
835: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
836: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
837: --open c_org(l_org_id);
838: else
839: MO_GLOBAL.SET_POLICY_CONTEXT('S',p_ORG_ID);
840: end if;

Line 844: FND_FILE.PUT_LINE(FND_FILE.LOG, 'org_id is-->'||l_curr_org_id);

840: end if;
841:
842: for i in c_org(p_org_id) loop
843: l_curr_org_id:=i.organization_id;
844: FND_FILE.PUT_LINE(FND_FILE.LOG, 'org_id is-->'||l_curr_org_id);
845: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_curr_org_id );
846:
847: -- update_trx_bal_summ('CP',l_curr_org_id);
848: FND_FILE.PUT_LINE(FND_FILE.LOG,'into OU level');

Line 848: FND_FILE.PUT_LINE(FND_FILE.LOG,'into OU level');

844: FND_FILE.PUT_LINE(FND_FILE.LOG, 'org_id is-->'||l_curr_org_id);
845: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_curr_org_id );
846:
847: -- update_trx_bal_summ('CP',l_curr_org_id);
848: FND_FILE.PUT_LINE(FND_FILE.LOG,'into OU level');
849:
850: open c_get_ou_biz_lvl(l_curr_org_id);
851: fetch c_get_ou_biz_lvl into G_SYSTEM_LEVEL;
852: close c_get_ou_biz_lvl;

Line 853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OU lvl is-->'||G_SYSTEM_LEVEL);

849:
850: open c_get_ou_biz_lvl(l_curr_org_id);
851: fetch c_get_ou_biz_lvl into G_SYSTEM_LEVEL;
852: close c_get_ou_biz_lvl;
853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OU lvl is-->'||G_SYSTEM_LEVEL);
854:
855: for r_allowed_levels in c_allowed_levels loop
856: l_allowed_lvl:=r_allowed_LEVELS.lookup_code;
857: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in ou-->'||r_allowed_LEVELS.lookup_code);

Line 857: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in ou-->'||r_allowed_LEVELS.lookup_code);

853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OU lvl is-->'||G_SYSTEM_LEVEL);
854:
855: for r_allowed_levels in c_allowed_levels loop
856: l_allowed_lvl:=r_allowed_LEVELS.lookup_code;
857: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in ou-->'||r_allowed_LEVELS.lookup_code);
858: if (g_party_lvl_enb='N' and l_allowed_lvl=g_system_level) or g_party_lvl_enb='Y' then
859: Insert_Summary(x_errbuf,x_retcode,FROM_DATE,l_curr_org_id,l_allowed_lvl,'CP',l_update_contact);
860: end if;
861: G_LEVEL_COUNT:=G_LEVEL_COUNT+1;

Line 868: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside party level');

864:
865:
866: elsif G_PARTY_LVL_ENB='Y' then
867: -- update_trx_bal_summ('CP',null);
868: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside party level');
869: open c_get_level;
870: fetch c_get_level into G_SYSTEM_LEVEL;
871: close c_get_level;
872: FND_FILE.PUT_LINE(FND_FILE.LOG, 'party lvl is-->'||G_SYSTEM_LEVEL);

Line 872: FND_FILE.PUT_LINE(FND_FILE.LOG, 'party lvl is-->'||G_SYSTEM_LEVEL);

868: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside party level');
869: open c_get_level;
870: fetch c_get_level into G_SYSTEM_LEVEL;
871: close c_get_level;
872: FND_FILE.PUT_LINE(FND_FILE.LOG, 'party lvl is-->'||G_SYSTEM_LEVEL);
873: for r_allowed_levels in c_allowed_levels loop
874: l_allowed_lvl:=r_allowed_LEVELS.lookup_code;
875: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in party-->'||r_allowed_LEVELS.lookup_code);
876: Insert_Summary(x_errbuf,x_retcode,FROM_DATE,null,l_allowed_lvl,'CP',l_update_contact);

Line 875: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in party-->'||r_allowed_LEVELS.lookup_code);

871: close c_get_level;
872: FND_FILE.PUT_LINE(FND_FILE.LOG, 'party lvl is-->'||G_SYSTEM_LEVEL);
873: for r_allowed_levels in c_allowed_levels loop
874: l_allowed_lvl:=r_allowed_LEVELS.lookup_code;
875: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in party-->'||r_allowed_LEVELS.lookup_code);
876: Insert_Summary(x_errbuf,x_retcode,FROM_DATE,null,l_allowed_lvl,'CP',l_update_contact);
877: G_LEVEL_COUNT:=G_LEVEL_COUNT+1;
878: end loop;
879:

Line 886: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside system level-->'||G_SYSTEM_LEVEL);

882: else
883: -- update_trx_bal_summ('CP',null);
884: open c_get_level;
885: fetch c_get_level into G_SYSTEM_LEVEL;
886: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside system level-->'||G_SYSTEM_LEVEL);
887: if G_SYSTEM_LEVEL is not null then
888: Insert_Summary(x_errbuf,x_retcode,FROM_DATE,null,G_SYSTEM_LEVEL,'CP',l_update_contact);
889: end if;
890: close c_get_level;

Line 896: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQLERRM: ' || sqlerrm);

892: exception
893: when others then
894: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Exception in populate_uwq_sum_concur');
895: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'SQLCODE: ' || to_char(SQLCODE) || ' SQLERRM: ' || sqlerrm);
896: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQLERRM: ' || sqlerrm);
897: END populate_uwq_sum_concur;
898:
899: --End Bug 8707923 27-Jul-2009 barathsr
900:

Line 4978: FND_FILE.PUT_LINE(FND_FILE.LOG,'Input FROM_DATE = ' || l_from_date);

4974: insert_conc_req;
4975:
4976: l_from_date := to_date(substr(FROM_DATE, 1, 10), 'YYYY/MM/DD');
4977: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Input FROM_DATE = ' || l_from_date);
4978: FND_FILE.PUT_LINE(FND_FILE.LOG,'Input FROM_DATE = ' || l_from_date);
4979:
4980: l_max_fetches := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));
4981: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Batch size = ' || l_max_fetches);
4982: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch size = ' || l_max_fetches);

Line 4982: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch size = ' || l_max_fetches);

4978: FND_FILE.PUT_LINE(FND_FILE.LOG,'Input FROM_DATE = ' || l_from_date);
4979:
4980: l_max_fetches := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));
4981: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Batch size = ' || l_max_fetches);
4982: FND_FILE.PUT_LINE(FND_FILE.LOG,'Batch size = ' || l_max_fetches);
4983:
4984: l_enable_work_queue := nvl(fnd_profile.value('IEX_ENABLE_UWQ_STATUS'), 'N');
4985: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'l_enable_work_queue = ' || l_enable_work_queue);
4986:

Line 5046: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);

5042:
5043:
5044: IF p_level = 'CUSTOMER' THEN
5045: if (l_from_date is null) then
5046: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);
5047: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);
5048: OPEN c_iex_cu_uwq_summary(G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5049: else
5050: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);

Line 5047: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);

5043:
5044: IF p_level = 'CUSTOMER' THEN
5045: if (l_from_date is null) then
5046: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);
5047: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);
5048: OPEN c_iex_cu_uwq_summary(G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5049: else
5050: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);
5051: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);

Line 5050: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);

5046: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);
5047: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);
5048: OPEN c_iex_cu_uwq_summary(G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5049: else
5050: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);
5051: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);
5052: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_date = ' || l_from_date);
5053: OPEN c_iex_cu_uwq_dt_sum(l_from_date,G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5054: end if;

Line 5051: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);

5047: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);
5048: OPEN c_iex_cu_uwq_summary(G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5049: else
5050: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);
5051: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);
5052: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_date = ' || l_from_date);
5053: OPEN c_iex_cu_uwq_dt_sum(l_from_date,G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5054: end if;
5055: ELSIF p_level = 'ACCOUNT' THEN

Line 5052: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_date = ' || l_from_date);

5048: OPEN c_iex_cu_uwq_summary(G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5049: else
5050: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);
5051: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);
5052: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_date = ' || l_from_date);
5053: OPEN c_iex_cu_uwq_dt_sum(l_from_date,G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5054: end if;
5055: ELSIF p_level = 'ACCOUNT' THEN
5056: -- If the date is not null we will not read only the new/updated records

Line 5065: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);

5061: end if;
5062: ELSIF p_level = 'BILL_TO' THEN
5063: -- If the date is not null we will not read only the new/updated records
5064: if (l_from_date is null) then
5065: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);
5066: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);
5067: open c_iex_billto_uwq_summary(G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5068: else
5069: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside BillTo');

Line 5066: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);

5062: ELSIF p_level = 'BILL_TO' THEN
5063: -- If the date is not null we will not read only the new/updated records
5064: if (l_from_date is null) then
5065: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);
5066: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);
5067: open c_iex_billto_uwq_summary(G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5068: else
5069: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside BillTo');
5070: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);

Line 5069: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside BillTo');

5065: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);
5066: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);
5067: open c_iex_billto_uwq_summary(G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5068: else
5069: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside BillTo');
5070: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);
5071: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);
5072: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_date = ' || l_from_date);
5073: open c_iex_billto_uwq_dt_sum(l_from_date,G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr

Line 5070: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);

5066: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);
5067: open c_iex_billto_uwq_summary(G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5068: else
5069: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside BillTo');
5070: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);
5071: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);
5072: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_date = ' || l_from_date);
5073: open c_iex_billto_uwq_dt_sum(l_from_date,G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5074: end if;

Line 5071: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);

5067: open c_iex_billto_uwq_summary(G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5068: else
5069: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside BillTo');
5070: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);
5071: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);
5072: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_date = ' || l_from_date);
5073: open c_iex_billto_uwq_dt_sum(l_from_date,G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5074: end if;
5075: END IF;

Line 5072: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_date = ' || l_from_date);

5068: else
5069: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside BillTo');
5070: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_level = ' || p_level);
5071: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id = ' || p_org_id);
5072: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_date = ' || l_from_date);
5073: open c_iex_billto_uwq_dt_sum(l_from_date,G_SYSTEM_LEVEL,p_org_id);--Added for Bug 8707923 27-Jul-2009 barathsr
5074: end if;
5075: END IF;
5076:

Line 5426: FND_FILE.PUT_LINE(FND_FILE.LOG,'no.of records fetched ' || L_IEU_OBJECT_FUNCTION.COUNT);

5422: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'No records found - processing complete. Exiting the loop');
5423: EXIT;
5424:
5425: ELSE
5426: FND_FILE.PUT_LINE(FND_FILE.LOG,'no.of records fetched ' || L_IEU_OBJECT_FUNCTION.COUNT);
5427: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'End fetching time: ' || to_char(sysdate, 'MM/DD/YYYY HH:MI:SS'));
5428: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Fetched ' || L_IEU_OBJECT_FUNCTION.COUNT || ' rows.');
5429: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting...');
5430: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Start inserting time: ' || to_char(sysdate, 'MM/DD/YYYY HH:MI:SS'));

Line 6125: FND_FILE.PUT_LINE(FND_FILE.LOG, ' C_cust_DETAILS_dt updated ' || L_party_id.count || ' rows ') ;

6121: WHERE
6122: party_id = L_party_id(i)
6123: and org_id= L_ORG_ID(i);
6124: LogMessage(FND_LOG.LEVEL_UNEXPECTED,' C_cust_DETAILS_dt updated ' || L_party_id.count || ' rows ');
6125: FND_FILE.PUT_LINE(FND_FILE.LOG, ' C_cust_DETAILS_dt updated ' || L_party_id.count || ' rows ') ;
6126: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'------------------------');
6127: END IF;
6128: END LOOP;
6129: IF C_cust_DETAILS_dt % ISOPEN THEN

Line 9986: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_cash = ' || l_cash);

9982: l_max_fetches := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));
9983: -- Bug 14197188 bibeura 26-Jun-2012
9984: l_cash := IEX_UTILITIES.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE','select NVL(FND_PROFILE.VALUE(''IEX_EXCHANGE_RATE_TYPE''),''Corporate'') from dual');
9985: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'DEFAULT_EXCHANGE_RATE_TYPE = ' || l_cash);
9986: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_cash = ' || l_cash);
9987:
9988: if p_mode='DLN' then
9989: LogMessage(FND_LOG.LEVEL_STATEMENT,'Starting..');
9990: -- Start Bug #6251657 bibeura 25-OCT-2007

Line 10013: FND_FILE.PUT_LINE(FND_FILE.LOG, 'fetched records '||L_SITE_USE_ID.COUNT) ;

10009: L_COMPLETE_DELINQUENCIES,
10010: L_ACTIVE_DELINQUENCIES,
10011: L_ORG_ID
10012: limit l_max_fetches;
10013: FND_FILE.PUT_LINE(FND_FILE.LOG, 'fetched records '||L_SITE_USE_ID.COUNT) ;
10014: IF L_SITE_USE_ID.COUNT = 0 THEN
10015: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'End fetching time: c_billto_del_dln ' || to_char(sysdate, 'MM/DD/YYYY HH:MI:SS'));
10016: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'No records found - processing complete. Exiting the loop');
10017: EXIT;

Line 10045: FND_FILE.PUT_LINE(FND_FILE.LOG, 'delete frm GT table at billto level');

10041: -- End Bug #6251657 bibeura 25-OCT-2007
10042:
10043: --Begin Bug 8707923 27-Jul-2009 barathsr
10044:
10045: FND_FILE.PUT_LINE(FND_FILE.LOG, 'delete frm GT table at billto level');
10046:
10047: delete from iex_pop_uwq_summ_gt;
10048:
10049: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into bill_to gt');

Line 10049: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into bill_to gt');

10045: FND_FILE.PUT_LINE(FND_FILE.LOG, 'delete frm GT table at billto level');
10046:
10047: delete from iex_pop_uwq_summ_gt;
10048:
10049: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into bill_to gt');
10050: insert into iex_pop_uwq_summ_gt(object_id,object_type,org_id)
10051: select del.customer_site_use_id,'IEX_BILLTO',del.org_id from iex_delinquencies del,hz_party_preferences party_pref
10052: where del.status in ('DELINQUENT','PRE-DELINQUENT')
10053: and del.party_cust_id=party_pref.party_id(+)

Line 10065: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserted into bill_to gt-->'||sql%rowcount);

10061: group by customer_site_use_id,del.org_id;
10062: if sql%rowcount<=0 then
10063: return;
10064: else
10065: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserted into bill_to gt-->'||sql%rowcount);
10066: end if;
10067: else
10068: NULL;
10069: end if;

Line 11309: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_cash = ' || l_cash);

11305:
11306: -- Bug 14197188 bibeura 26-Jun-2012
11307: l_cash := IEX_UTILITIES.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE','select NVL(FND_PROFILE.VALUE(''IEX_EXCHANGE_RATE_TYPE''),''Corporate'') from dual');
11308: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'DEFAULT_EXCHANGE_RATE_TYPE = ' || l_cash);
11309: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_cash = ' || l_cash);
11310:
11311:
11312: if p_mode='DLN' then
11313: LogMessage(FND_LOG.LEVEL_STATEMENT,'Starting..');

Line 11367: FND_FILE.PUT_LINE(FND_FILE.LOG,'deleting rows from A/C gt table');

11363: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Delinquency update received' || SQLERRM);
11364: END;
11365:
11366: --Begin Bug 8707923 27-Jul-2009 barathsr
11367: FND_FILE.PUT_LINE(FND_FILE.LOG,'deleting rows from A/C gt table');
11368:
11369: delete from iex_pop_uwq_summ_gt;
11370: -- End Bug #6251657 bibeura 25-OCT-2007
11371: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into account gt');

Line 11371: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into account gt');

11367: FND_FILE.PUT_LINE(FND_FILE.LOG,'deleting rows from A/C gt table');
11368:
11369: delete from iex_pop_uwq_summ_gt;
11370: -- End Bug #6251657 bibeura 25-OCT-2007
11371: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into account gt');
11372: insert into iex_pop_uwq_summ_gt(object_id,object_type,org_id)
11373: select del.cust_account_id,'IEX_ACCOUNT',del.org_id from iex_delinquencies del,hz_party_preferences party_pref
11374: where del.status in ('DELINQUENT','PRE-DELINQUENT')
11375: and del.party_cust_id=party_pref.party_id(+)

Line 11387: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserted into account gt-->'||sql%rowcount);

11383: group by del.cust_account_id,del.org_id;
11384: if sql%rowcount<=0 then
11385: return;
11386: else
11387: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserted into account gt-->'||sql%rowcount);
11388: end if;
11389: else
11390: null;
11391: end if;

Line 12620: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_cash = ' || l_cash);

12616:
12617: -- Bug 14197188 bibeura 26-Jun-2012
12618: l_cash := IEX_UTILITIES.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE','select NVL(FND_PROFILE.VALUE(''IEX_EXCHANGE_RATE_TYPE''),''Corporate'') from dual');
12619: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'DEFAULT_EXCHANGE_RATE_TYPE = ' || l_cash);
12620: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_cash = ' || l_cash);
12621: if p_mode='DLN' then
12622: LogMessage(FND_LOG.LEVEL_STATEMENT,'Starting..');
12623: -- Start Bug #6251657 bibeura 25-OCT-2007
12624: BEGIN

Line 12677: FND_FILE.PUT_LINE(FND_FILE.LOG,'delete rows from customer gt');

12673: --End Bug #6251657 bibeura 25-OCT-2007
12674:
12675: --Begin Bug 8707923 27-Jul-2009 barathsr
12676:
12677: FND_FILE.PUT_LINE(FND_FILE.LOG,'delete rows from customer gt');
12678: delete from iex_pop_uwq_summ_gt;
12679: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into customer gt');
12680:
12681: insert into iex_pop_uwq_summ_gt(object_id,object_type,org_id)

Line 12679: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into customer gt');

12675: --Begin Bug 8707923 27-Jul-2009 barathsr
12676:
12677: FND_FILE.PUT_LINE(FND_FILE.LOG,'delete rows from customer gt');
12678: delete from iex_pop_uwq_summ_gt;
12679: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into customer gt');
12680:
12681: insert into iex_pop_uwq_summ_gt(object_id,object_type,org_id)
12682: select del.party_cust_id,'PARTY',del.org_id from iex_delinquencies del,hz_party_preferences party_pref
12683: where del.status in ('DELINQUENT','PRE-DELINQUENT')

Line 12696: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserted into customer gt-->'||sql%rowcount);

12692: group by del.party_cust_id,del.org_id;
12693: if sql%rowcount<=0 then
12694: return;
12695: else
12696: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserted into customer gt-->'||sql%rowcount);
12697: end if;
12698: else
12699: null;
12700: end if;

Line 13536: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ou_lvl_enb-->'||g_ou_lvl_enb);

13532: select DEFINE_PARTY_RUNNING_LEVEL,DEFINE_OU_RUNNING_LEVEL
13533: into G_PARTY_LVL_ENB,G_OU_LVL_ENB
13534: from IEX_QUESTIONNAIRE_ITEMS;
13535:
13536: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ou_lvl_enb-->'||g_ou_lvl_enb);
13537: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_party_lvl_enb-->'||g_party_lvl_enb);
13538:
13539:
13540:

Line 13537: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_party_lvl_enb-->'||g_party_lvl_enb);

13533: into G_PARTY_LVL_ENB,G_OU_LVL_ENB
13534: from IEX_QUESTIONNAIRE_ITEMS;
13535:
13536: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ou_lvl_enb-->'||g_ou_lvl_enb);
13537: FND_FILE.PUT_LINE(FND_FILE.LOG,'g_party_lvl_enb-->'||g_party_lvl_enb);
13538:
13539:
13540:
13541: if (G_OU_LVL_ENB='Y' or G_PARTY_LVL_ENB='Y') then

Line 13552: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');

13548: where request_id=FND_GLOBAL.CONC_REQUEST_ID;
13549:
13550: if l_org_id is null then
13551: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
13552: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
13553: --open c_org(l_org_id);
13554: else
13555: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_ORG_ID);
13556: end if;

Line 13560: FND_FILE.PUT_LINE(FND_FILE.LOG,'into OU level');

13556: end if;
13557: for i in c_org(l_org_id) loop
13558: l_curr_org_id:=i.organization_id;
13559: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_curr_org_id );
13560: FND_FILE.PUT_LINE(FND_FILE.LOG,'into OU level');
13561: FND_FILE.PUT_LINE(FND_FILE.LOG,'into OU level-->'||l_curr_org_id);
13562: open c_get_level(l_curr_org_id);
13563: fetch c_get_level into G_SYSTEM_LEVEL;
13564: close c_get_level;

Line 13561: FND_FILE.PUT_LINE(FND_FILE.LOG,'into OU level-->'||l_curr_org_id);

13557: for i in c_org(l_org_id) loop
13558: l_curr_org_id:=i.organization_id;
13559: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_curr_org_id );
13560: FND_FILE.PUT_LINE(FND_FILE.LOG,'into OU level');
13561: FND_FILE.PUT_LINE(FND_FILE.LOG,'into OU level-->'||l_curr_org_id);
13562: open c_get_level(l_curr_org_id);
13563: fetch c_get_level into G_SYSTEM_LEVEL;
13564: close c_get_level;
13565: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OU lvl is-->'||G_SYSTEM_LEVEL);

Line 13565: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OU lvl is-->'||G_SYSTEM_LEVEL);

13561: FND_FILE.PUT_LINE(FND_FILE.LOG,'into OU level-->'||l_curr_org_id);
13562: open c_get_level(l_curr_org_id);
13563: fetch c_get_level into G_SYSTEM_LEVEL;
13564: close c_get_level;
13565: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OU lvl is-->'||G_SYSTEM_LEVEL);
13566:
13567: for r_allowed_levels in c_allowed_levels loop
13568: l_allowed_level:=r_allowed_LEVELS.lookup_code;
13569: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in ou-->'||r_allowed_LEVELS.lookup_code);

Line 13569: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in ou-->'||r_allowed_LEVELS.lookup_code);

13565: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OU lvl is-->'||G_SYSTEM_LEVEL);
13566:
13567: for r_allowed_levels in c_allowed_levels loop
13568: l_allowed_level:=r_allowed_LEVELS.lookup_code;
13569: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in ou-->'||r_allowed_LEVELS.lookup_code);
13570: if (g_party_lvl_enb='N' and l_allowed_level=g_system_level) or g_party_lvl_enb='Y' then
13571: IF l_allowed_level = 'CUSTOMER' THEN
13572:
13573: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call customer cursor for lvl enb at OU-->'||l_allowed_level);

Line 13573: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call customer cursor for lvl enb at OU-->'||l_allowed_level);

13569: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in ou-->'||r_allowed_LEVELS.lookup_code);
13570: if (g_party_lvl_enb='N' and l_allowed_level=g_system_level) or g_party_lvl_enb='Y' then
13571: IF l_allowed_level = 'CUSTOMER' THEN
13572:
13573: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call customer cursor for lvl enb at OU-->'||l_allowed_level);
13574:
13575: customer_refresh_summary_incr(x_errbuf,
13576: x_retcode,
13577: from_date,

Line 13587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call account cursor for lvl enb at OU-->'||l_allowed_level);

13583: end if;
13584: --End Bug 8823567 22-Oct-2009 barathsr
13585:
13586: ELSIF l_allowed_level = 'ACCOUNT' THEN
13587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call account cursor for lvl enb at OU-->'||l_allowed_level);
13588: account_refresh_summary_incr(x_errbuf,
13589: x_retcode,
13590: from_date,
13591: p_mode,

Line 13599: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call billto cursor for lvl enb at OU-->'||l_allowed_level);

13595: calculate_net_balance(l_allowed_level,from_date,l_curr_org_id);
13596: end if;
13597: --End Bug 8823567 22-Oct-2009 barathsr
13598: ELSIF l_allowed_level = 'BILL_TO' THEN
13599: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call billto cursor for lvl enb at OU-->'||l_allowed_level);
13600: billto_refresh_summary_incr(x_errbuf,
13601: x_retcode,
13602: from_date,
13603: p_mode,

Line 13615: FND_FILE.PUT_LINE(FND_FILE.LOG, 'end of allowed level loop');

13611: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Delinquency level is not implemented at this time. Exiting.');
13612: return;
13613: end if;
13614: end if;
13615: FND_FILE.PUT_LINE(FND_FILE.LOG, 'end of allowed level loop');
13616: end loop;
13617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'end of org_id loop');
13618: end loop;
13619:

Line 13617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'end of org_id loop');

13613: end if;
13614: end if;
13615: FND_FILE.PUT_LINE(FND_FILE.LOG, 'end of allowed level loop');
13616: end loop;
13617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'end of org_id loop');
13618: end loop;
13619:
13620: elsif G_PARTY_LVL_ENB='Y' then
13621: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside party level');

Line 13621: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside party level');

13617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'end of org_id loop');
13618: end loop;
13619:
13620: elsif G_PARTY_LVL_ENB='Y' then
13621: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside party level');
13622: open c_get_level(null);
13623: fetch c_get_level into G_SYSTEM_LEVEL;
13624: close c_get_level;
13625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'party lvl is-->'||G_SYSTEM_LEVEL);

Line 13625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'party lvl is-->'||G_SYSTEM_LEVEL);

13621: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside party level');
13622: open c_get_level(null);
13623: fetch c_get_level into G_SYSTEM_LEVEL;
13624: close c_get_level;
13625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'party lvl is-->'||G_SYSTEM_LEVEL);
13626: for r_allowed_levels in c_allowed_levels loop
13627: l_allowed_level:=r_allowed_LEVELS.lookup_code;
13628: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in party-->'||r_allowed_LEVELS.lookup_code);
13629: IF l_allowed_level = 'CUSTOMER' THEN

Line 13628: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in party-->'||r_allowed_LEVELS.lookup_code);

13624: close c_get_level;
13625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'party lvl is-->'||G_SYSTEM_LEVEL);
13626: for r_allowed_levels in c_allowed_levels loop
13627: l_allowed_level:=r_allowed_LEVELS.lookup_code;
13628: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in party-->'||r_allowed_LEVELS.lookup_code);
13629: IF l_allowed_level = 'CUSTOMER' THEN
13630: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call customer cursor for lvl enb at party-->'||l_allowed_level);
13631: customer_refresh_summary_incr(x_errbuf,
13632: x_retcode,

Line 13630: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call customer cursor for lvl enb at party-->'||l_allowed_level);

13626: for r_allowed_levels in c_allowed_levels loop
13627: l_allowed_level:=r_allowed_LEVELS.lookup_code;
13628: FND_FILE.PUT_LINE(FND_FILE.LOG,'looping for other levels in party-->'||r_allowed_LEVELS.lookup_code);
13629: IF l_allowed_level = 'CUSTOMER' THEN
13630: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call customer cursor for lvl enb at party-->'||l_allowed_level);
13631: customer_refresh_summary_incr(x_errbuf,
13632: x_retcode,
13633: from_date,
13634: p_mode,

Line 13643: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call account cursor for lvl enb at party-->'||l_allowed_level);

13639: end if;
13640: --End Bug 8823567 22-Oct-2009 barathsr
13641:
13642: ELSIF l_allowed_level = 'ACCOUNT' THEN
13643: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call account cursor for lvl enb at party-->'||l_allowed_level);
13644: account_refresh_summary_incr(x_errbuf,
13645: x_retcode,
13646: from_date,
13647: p_mode,

Line 13655: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call billto cursor for lvl enb at party-->'||l_allowed_level);

13651: calculate_net_balance(l_allowed_level,from_date,null);
13652: end if;
13653: --End Bug 8823567 22-Oct-2009 barathsr
13654: ELSIF l_allowed_level = 'BILL_TO' THEN
13655: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call billto cursor for lvl enb at party-->'||l_allowed_level);
13656: billto_refresh_summary_incr(x_errbuf,
13657: x_retcode,
13658: from_date,
13659: p_mode,

Line 13670: FND_FILE.PUT_LINE(FND_FILE.LOG, 'end of allowed level loop');

13666: ELSE
13667: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'Delinquency level is not implemented at this time. Exiting.');
13668: return;
13669: end if;
13670: FND_FILE.PUT_LINE(FND_FILE.LOG, 'end of allowed level loop');
13671: end loop;
13672:
13673: end if;
13674:

Line 13678: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside system level-->'||G_SYSTEM_LEVEL);

13674:
13675: else
13676: open c_get_level(null);
13677: fetch c_get_level into G_SYSTEM_LEVEL;
13678: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside system level-->'||G_SYSTEM_LEVEL);
13679: -- l_allowed_level:=G_SYSTEM_LEVEL;
13680: IF G_SYSTEM_LEVEL= 'CUSTOMER' THEN
13681: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call customer cursor for lvl enb at system-->'||G_SYSTEM_LEVEL);
13682: customer_refresh_summary_incr(x_errbuf,

Line 13681: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call customer cursor for lvl enb at system-->'||G_SYSTEM_LEVEL);

13677: fetch c_get_level into G_SYSTEM_LEVEL;
13678: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside system level-->'||G_SYSTEM_LEVEL);
13679: -- l_allowed_level:=G_SYSTEM_LEVEL;
13680: IF G_SYSTEM_LEVEL= 'CUSTOMER' THEN
13681: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call customer cursor for lvl enb at system-->'||G_SYSTEM_LEVEL);
13682: customer_refresh_summary_incr(x_errbuf,
13683: x_retcode,
13684: from_date,
13685: p_mode,

Line 13694: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call account cursor for lvl enb at system-->'||G_SYSTEM_LEVEL);

13690: end if;
13691: --End Bug 8823567 22-Oct-2009 barathsr
13692:
13693: ELSIF G_SYSTEM_LEVEL = 'ACCOUNT' THEN
13694: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call account cursor for lvl enb at system-->'||G_SYSTEM_LEVEL);
13695: account_refresh_summary_incr(x_errbuf,
13696: x_retcode,
13697: from_date,
13698: p_mode,

Line 13707: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call billto cursor for lvl enb at system-->'||G_SYSTEM_LEVEL);

13703: end if;
13704: --End Bug 8823567 22-Oct-2009 barathsr
13705:
13706: ELSIF G_SYSTEM_LEVEL = 'BILL_TO' THEN
13707: FND_FILE.PUT_LINE(FND_FILE.LOG, 'call billto cursor for lvl enb at system-->'||G_SYSTEM_LEVEL);
13708: billto_refresh_summary_incr(x_errbuf,
13709: x_retcode,
13710: from_date,
13711: p_mode,

Line 13726: FND_FILE.PUT_LINE(FND_FILE.LOG, 'end of a level');

13722: end if;
13723: close c_get_level;
13724: end if;
13725:
13726: FND_FILE.PUT_LINE(FND_FILE.LOG, 'end of a level');
13727:
13728: EXCEPTION
13729: WHEN OTHERS THEN
13730: LogMessage(FND_LOG.LEVEL_STATEMENT,sqlerrm);

Line 14171: FND_FILE.PUT_LINE(FND_FILE.LOG,'net bal calc--inside org loop--'||i.org_id);

14167: l_org_id number_list;
14168: l_batch_size number:=1000;
14169: begin
14170: for i in c_orgs loop
14171: FND_FILE.PUT_LINE(FND_FILE.LOG,'net bal calc--inside org loop--'||i.org_id);
14172: open c_get_details(i.org_id);
14173: l_party_id.delete;
14174: l_cust_acct_id.delete;
14175: l_site_use_id.delete;

Line 14204: FND_FILE.PUT_LINE(FND_FILE.LOG,'rows updated-'||sql%rowcount);

14200: and cust_account_id is null
14201: and site_use_id is null
14202: and dln_summ.org_id=l_org_id(cnt);
14203: -- and business_level=p_fmode;
14204: FND_FILE.PUT_LINE(FND_FILE.LOG,'rows updated-'||sql%rowcount);
14205: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside customer');
14206: elsif p_fmode='ACCOUNT' then
14207: FORALL cnt IN l_cust_acct_id.first..l_cust_acct_id.last
14208: update iex_dln_uwq_summary dln_summ

Line 14205: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside customer');

14201: and site_use_id is null
14202: and dln_summ.org_id=l_org_id(cnt);
14203: -- and business_level=p_fmode;
14204: FND_FILE.PUT_LINE(FND_FILE.LOG,'rows updated-'||sql%rowcount);
14205: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside customer');
14206: elsif p_fmode='ACCOUNT' then
14207: FORALL cnt IN l_cust_acct_id.first..l_cust_acct_id.last
14208: update iex_dln_uwq_summary dln_summ
14209: set net_balance=(select SUM(NVL(aps.acctd_amount_due_remaining,0))

Line 14224: FND_FILE.PUT_LINE(FND_FILE.LOG,'rows_updated-'||sql%rowcount);

14220: and dln_summ.ieu_param_pk_col='CUST_ACCOUNT_ID'
14221: --and nvl(site_use_id,1)=nvl(l_site_use_id(cnt),1)
14222: and dln_summ.org_id=l_org_id(cnt);
14223: -- and business_level=p_fmode;
14224: FND_FILE.PUT_LINE(FND_FILE.LOG,'rows_updated-'||sql%rowcount);
14225: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside account');
14226: elsif p_fmode='BILL_TO' then
14227: FORALL cnt IN l_party_id.first..l_party_id.last
14228: update iex_dln_uwq_summary dln_summ

Line 14225: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside account');

14221: --and nvl(site_use_id,1)=nvl(l_site_use_id(cnt),1)
14222: and dln_summ.org_id=l_org_id(cnt);
14223: -- and business_level=p_fmode;
14224: FND_FILE.PUT_LINE(FND_FILE.LOG,'rows_updated-'||sql%rowcount);
14225: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside account');
14226: elsif p_fmode='BILL_TO' then
14227: FORALL cnt IN l_party_id.first..l_party_id.last
14228: update iex_dln_uwq_summary dln_summ
14229: set net_balance=(select SUM(NVL(aps.acctd_amount_due_remaining,0))

Line 14243: FND_FILE.PUT_LINE(FND_FILE.LOG,'rows_updated-'||sql%rowcount);

14239: and site_use_id=l_site_use_id(cnt)
14240: and dln_summ.ieu_param_pk_col='CUSTOMER_SITE_USE_ID'
14241: and org_id=l_org_id(cnt);
14242: --and business_level=p_fmode;
14243: FND_FILE.PUT_LINE(FND_FILE.LOG,'rows_updated-'||sql%rowcount);
14244: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside billto');
14245: else
14246: FND_FILE.PUT_LINE(FND_FILE.LOG,'Net Balance calculation--Delinquency level is not implemented at this time');
14247: end if;

Line 14244: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside billto');

14240: and dln_summ.ieu_param_pk_col='CUSTOMER_SITE_USE_ID'
14241: and org_id=l_org_id(cnt);
14242: --and business_level=p_fmode;
14243: FND_FILE.PUT_LINE(FND_FILE.LOG,'rows_updated-'||sql%rowcount);
14244: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside billto');
14245: else
14246: FND_FILE.PUT_LINE(FND_FILE.LOG,'Net Balance calculation--Delinquency level is not implemented at this time');
14247: end if;
14248: end if;

Line 14246: FND_FILE.PUT_LINE(FND_FILE.LOG,'Net Balance calculation--Delinquency level is not implemented at this time');

14242: --and business_level=p_fmode;
14243: FND_FILE.PUT_LINE(FND_FILE.LOG,'rows_updated-'||sql%rowcount);
14244: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside billto');
14245: else
14246: FND_FILE.PUT_LINE(FND_FILE.LOG,'Net Balance calculation--Delinquency level is not implemented at this time');
14247: end if;
14248: end if;
14249: end loop;
14250: end loop;

Line 14258: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in net balance calculation--'||sqlerrm);

14254:
14255:
14256: exception
14257: when others then
14258: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in net balance calculation--'||sqlerrm);
14259: LogMessage(FND_LOG.LEVEL_STATEMENT,sqlerrm);
14260: end ;
14261:
14262: --End Bug 8823567 22-Oct-2009 barathsr