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_CHECKLIST_UTILITY dependencies on IEX_DEBUG_PUB

Line 222: IEX_DEBUG_PUB.logmessage('IN checkUpgradeStrategie ');

218: WHERE istg.STRATEGY_TEMP_ID = ISTL.STRATEGY_TEMP_ID);
219:
220: l_Upgrades NUMBER := 0;
221: BEGIN
222: IEX_DEBUG_PUB.logmessage('IN checkUpgradeStrategie ');
223: Open c_CheckStrategyGroups;
224: FETCH C_CheckStrategyGroups INTO l_Upgrades;
225: close c_CheckStrategyGroups;
226: if l_Upgrades > 0 then

Line 227: IEX_DEBUG_PUB.logmessage('Inserting into StrategyGroups');

223: Open c_CheckStrategyGroups;
224: FETCH C_CheckStrategyGroups INTO l_Upgrades;
225: close c_CheckStrategyGroups;
226: if l_Upgrades > 0 then
227: IEX_DEBUG_PUB.logmessage('Inserting into StrategyGroups');
228: INSERT INTO IEX_STRATEGY_TEMPLATE_GROUPS (
229: OBJECT_VERSION_NUMBER,
230: CREATED_BY,
231: CREATION_DATE,

Line 289: IEX_DEBUG_PUB.logmessage('End checkUpgradeStrategie ');

285:
286: commit;
287:
288: end if;
289: IEX_DEBUG_PUB.logmessage('End checkUpgradeStrategie ');
290: EXCEPTION
291: WHEN OTHERS THEN
292: x_return_status := 'F';
293: fnd_message.set_name ('IEX', 'IEX_ADMIN_UNKNOWN_ERROR');

Line 328: IEX_DEBUG_PUB.logmessage('Update CheckList ' || p_checklist_item_id);

324: BEGIN
325: x_return_status := 'S';
326: l_status := 'COMPLETE';
327:
328: IEX_DEBUG_PUB.logmessage('Update CheckList ' || p_checklist_item_id);
329:
330: -- Begin kasreeni 12-16-2005 4887338
331: if (p_checklist_item_id = 100 ) then
332: IEX_DEBUG_PUB.logmessage('Calling checkUpgradeStrategie ');

Line 332: IEX_DEBUG_PUB.logmessage('Calling checkUpgradeStrategie ');

328: IEX_DEBUG_PUB.logmessage('Update CheckList ' || p_checklist_item_id);
329:
330: -- Begin kasreeni 12-16-2005 4887338
331: if (p_checklist_item_id = 100 ) then
332: IEX_DEBUG_PUB.logmessage('Calling checkUpgradeStrategie ');
333: checkUpgradeStrategies(x_return_status);
334: return ;
335: end if;
336: -- End kasreeni 12-16-2005 4887338

Line 363: iex_debug_pub.logmessage('l_status=' || l_status);

359: ELSE
360: l_status := 'INPROGRESS';
361: END IF;
362:
363: iex_debug_pub.logmessage('l_status=' || l_status);
364:
365: UPDATE iex_checklist_items_b
366: SET status = l_status, task_last_modified_date = SYSDATE, last_update_date = SYSDATE,
367: last_updated_by = G_USER_ID, last_update_login = G_LOGIN_ID

Line 426: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);

422:
423: IF l_enabled_flag = 'N' THEN
424: FOR r_resp IN c_resp LOOP
425: l_function_name := 'IEX_COLL_CNTR';
426: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
427: OPEN c_funct(r_resp.responsibility_id, l_function_name);
428: FETCH c_funct INTO r_funct;
429: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
430: IF r_funct.action_id IS NULL THEN

Line 429: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);

425: l_function_name := 'IEX_COLL_CNTR';
426: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
427: OPEN c_funct(r_resp.responsibility_id, l_function_name);
428: FETCH c_funct INTO r_funct;
429: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
430: IF r_funct.action_id IS NULL THEN
431: fnd_resp_functions_pkg.insert_row(x_rowid => l_rowid,
432: x_application_id => r_resp.application_id,
433: x_responsibility_id => r_resp.responsibility_id,

Line 442: iex_debug_pub.logmessage('x_rowid=' || l_rowid);

438: x_last_updated_by => 1,
439: x_last_update_date => SYSDATE,
440: x_last_update_login => 1);
441:
442: iex_debug_pub.logmessage('x_rowid=' || l_rowid);
443:
444: END IF;
445:
446: CLOSE c_funct;

Line 451: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);

447:
448: l_function_name := 'IEX_COLL_CASE';
449: r_funct.action_id := NULL;
450: r_funct.function_id := NULL;
451: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
452: OPEN c_funct(r_resp.responsibility_id, l_function_name);
453: FETCH c_funct INTO r_funct;
454: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
455: IF r_funct.action_id IS NULL THEN

Line 454: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);

450: r_funct.function_id := NULL;
451: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
452: OPEN c_funct(r_resp.responsibility_id, l_function_name);
453: FETCH c_funct INTO r_funct;
454: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
455: IF r_funct.action_id IS NULL THEN
456: fnd_resp_functions_pkg.insert_row(x_rowid => l_rowid,
457: x_application_id => r_resp.application_id,
458: x_responsibility_id => r_resp.responsibility_id,

Line 467: iex_debug_pub.logmessage('x_rowid=' || l_rowid);

463: x_last_updated_by => 1,
464: x_last_update_date => SYSDATE,
465: x_last_update_login => 1);
466:
467: iex_debug_pub.logmessage('x_rowid=' || l_rowid);
468: END IF;
469:
470: CLOSE c_funct;
471: END LOOP;

Line 475: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);

471: END LOOP;
472: ELSE
473: FOR r_resp IN c_resp LOOP
474: l_function_name := 'IEX_COLL_CNTR';
475: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
476: OPEN c_funct(r_resp.responsibility_id, l_function_name);
477: FETCH c_funct INTO r_funct;
478: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
479: IF r_funct.action_id IS NOT NULL THEN

Line 478: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);

474: l_function_name := 'IEX_COLL_CNTR';
475: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
476: OPEN c_funct(r_resp.responsibility_id, l_function_name);
477: FETCH c_funct INTO r_funct;
478: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
479: IF r_funct.action_id IS NOT NULL THEN
480: fnd_resp_functions_pkg.delete_row(x_application_id => r_resp.application_id,
481: x_responsibility_id => r_resp.responsibility_id,
482: x_action_id => r_funct.action_id,

Line 491: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);

487:
488: l_function_name := 'IEX_COLL_CASE';
489: r_funct.action_id := NULL;
490: r_funct.function_id := NULL;
491: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
492: OPEN c_funct(r_resp.responsibility_id, l_function_name);
493: FETCH c_funct INTO r_funct;
494: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
495: IF r_funct.action_id IS NOT NULL THEN

Line 494: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);

490: r_funct.function_id := NULL;
491: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
492: OPEN c_funct(r_resp.responsibility_id, l_function_name);
493: FETCH c_funct INTO r_funct;
494: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
495: IF r_funct.action_id IS NOT NULL THEN
496: fnd_resp_functions_pkg.delete_row(x_application_id => r_resp.application_id,
497: x_responsibility_id => r_resp.responsibility_id,
498: x_action_id => r_funct.action_id,

Line 501: iex_debug_pub.logmessage('x_rowid=' || l_rowid);

497: x_responsibility_id => r_resp.responsibility_id,
498: x_action_id => r_funct.action_id,
499: x_rule_type => 'F');
500:
501: iex_debug_pub.logmessage('x_rowid=' || l_rowid);
502: END IF;
503:
504: CLOSE c_funct;
505: END LOOP;

Line 602: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);

598:
599: IF l_enabled_flag = 'N' THEN
600: FOR r_resp IN c_resp LOOP
601: l_function_name := 'IEX_COLL_LOAN';
602: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
603: OPEN c_funct(r_resp.responsibility_id, l_function_name);
604: FETCH c_funct INTO r_funct;
605: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
606: IF r_funct.action_id IS NULL THEN

Line 605: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);

601: l_function_name := 'IEX_COLL_LOAN';
602: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
603: OPEN c_funct(r_resp.responsibility_id, l_function_name);
604: FETCH c_funct INTO r_funct;
605: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
606: IF r_funct.action_id IS NULL THEN
607: fnd_resp_functions_pkg.insert_row(x_rowid => l_rowid,
608: x_application_id => r_resp.application_id,
609: x_responsibility_id => r_resp.responsibility_id,

Line 618: iex_debug_pub.logmessage('x_rowid=' || l_rowid);

614: x_last_updated_by => 1,
615: x_last_update_date => SYSDATE,
616: x_last_update_login => 1);
617:
618: iex_debug_pub.logmessage('x_rowid=' || l_rowid);
619:
620: END IF;
621:
622: CLOSE c_funct;

Line 627: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);

623: END LOOP;
624: ELSE
625: FOR r_resp IN c_resp LOOP
626: l_function_name := 'IEX_COLL_LOAN';
627: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
628: OPEN c_funct(r_resp.responsibility_id, l_function_name);
629: FETCH c_funct INTO r_funct;
630: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
631: IF r_funct.action_id IS NOT NULL THEN

Line 630: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);

626: l_function_name := 'IEX_COLL_LOAN';
627: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
628: OPEN c_funct(r_resp.responsibility_id, l_function_name);
629: FETCH c_funct INTO r_funct;
630: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
631: IF r_funct.action_id IS NOT NULL THEN
632: fnd_resp_functions_pkg.delete_row(x_application_id => r_resp.application_id,
633: x_responsibility_id => r_resp.responsibility_id,
634: x_action_id => r_funct.action_id,

Line 646: iex_debug_pub.logmessage('Function ID = '||l_func_id);

642: -- Begin by Ehuh to fix a bug 4639561
643: Begin
644: OPEN get_function_id;
645: FETCH get_function_id into l_func_id;
646: iex_debug_pub.logmessage('Function ID = '||l_func_id);
647:
648: if get_function_id%NOTFOUND then
649: iex_debug_pub.logmessage('NOt found FUNCTION ID ');
650: null;

Line 649: iex_debug_pub.logmessage('NOt found FUNCTION ID ');

645: FETCH get_function_id into l_func_id;
646: iex_debug_pub.logmessage('Function ID = '||l_func_id);
647:
648: if get_function_id%NOTFOUND then
649: iex_debug_pub.logmessage('NOt found FUNCTION ID ');
650: null;
651: end if;
652:
653: close get_function_id;

Line 659: iex_debug_pub.logmessage('NOt found MENU ID ');

655: OPEN get_menu_id;
656: FETCH get_menu_id into l_menu_id;
657:
658: if get_menu_id%NOTFOUND then
659: iex_debug_pub.logmessage('NOt found MENU ID ');
660: null;
661: end if;
662:
663: close get_menu_id;

Line 670: iex_debug_pub.logmessage('NOt found ENTRY SEQ ');

666: OPEN get_entry_sequence(l_menu_id , l_func_id );
667: FETCH get_entry_sequence into l_entry_sequence;
668:
669: if get_entry_sequence%NOTFOUND then
670: iex_debug_pub.logmessage('NOt found ENTRY SEQ ');
671: null;
672: end if;
673:
674: close get_entry_sequence;

Line 691: iex_debug_pub.logmessage('Exceptopn ');

687: end if;
688:
689: Exception
690: When others then
691: iex_debug_pub.logmessage('Exceptopn ');
692: null;
693: End;
694: -- End to fix bug 4639561
695:

Line 726: iex_debug_pub.logmessage('Starting ....');

722: ELSE
723: l_strategy_enabled := 'Y';
724: END IF;
725:
726: iex_debug_pub.logmessage('Starting ....');
727:
728: iex_debug_pub.logmessage('l_promise_enabled=' || l_promise_enabled || ': l_strategy_enabled=' || l_strategy_enabled);
729:
730: -- Begin fix bug #5142565-JYPARK-Change site level profile too

Line 728: iex_debug_pub.logmessage('l_promise_enabled=' || l_promise_enabled || ': l_strategy_enabled=' || l_strategy_enabled);

724: END IF;
725:
726: iex_debug_pub.logmessage('Starting ....');
727:
728: iex_debug_pub.logmessage('l_promise_enabled=' || l_promise_enabled || ': l_strategy_enabled=' || l_strategy_enabled);
729:
730: -- Begin fix bug #5142565-JYPARK-Change site level profile too
731: IF l_business_level = 'CUSTOMER' THEN
732: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',

Line 1028: -- iex_debug_pub.logmessage('responsibility_key=' || r_resp.responsibility_key);

1024: -- End fix bug #5142565-JYPARK-Change site level profile too
1025:
1026: -- Begin fix bug #5142565-JYPARK-remove change profile at resp level
1027: -- FOR r_resp IN c_resp LOOP
1028: -- iex_debug_pub.logmessage('responsibility_key=' || r_resp.responsibility_key);
1029: -- IF l_business_level = 'CUSTOMER' THEN
1030: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',
1031: -- x_value => 'Y',
1032: -- x_level_name => 'RESP',