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 224: IEX_DEBUG_PUB.logmessage('IN checkUpgradeStrategie ');

220: l_Upgrades NUMBER := 0;
221: l_max_group NUMBER := 0;
222: l_next_seq NUMBER := 0;
223: BEGIN
224: IEX_DEBUG_PUB.logmessage('IN checkUpgradeStrategie ');
225: Open c_CheckStrategyGroups;
226: FETCH C_CheckStrategyGroups INTO l_Upgrades;
227: close c_CheckStrategyGroups;
228: if l_Upgrades > 0 then

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

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

Line 301: IEX_DEBUG_PUB.logmessage('Exception in sequence '|| sqlerrm);

297: end loop;
298:
299: exception
300: when others then
301: IEX_DEBUG_PUB.logmessage('Exception in sequence '|| sqlerrm);
302: end;
303: end if;
304: commit;
305: IEX_DEBUG_PUB.logmessage('End checkUpgradeStrategie ');

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

301: IEX_DEBUG_PUB.logmessage('Exception in sequence '|| sqlerrm);
302: end;
303: end if;
304: commit;
305: IEX_DEBUG_PUB.logmessage('End checkUpgradeStrategie ');
306: EXCEPTION
307: WHEN OTHERS THEN
308: x_return_status := 'F';
309: fnd_message.set_name ('IEX', 'IEX_ADMIN_UNKNOWN_ERROR');

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

349: BEGIN
350: x_return_status := 'S';
351: l_status := 'COMPLETE';
352:
353: IEX_DEBUG_PUB.logmessage('Update CheckList ' || p_checklist_item_id);
354:
355: -- Bug 8479638 by ehuh 5/6/2009
356: For rec_object_filter IN c_object_filter LOOP
357: update iex_strategy_template_groups

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

360: End LOOP;
361:
362: -- Begin kasreeni 12-16-2005 4887338
363: if (p_checklist_item_id = 100 ) then
364: IEX_DEBUG_PUB.logmessage('Calling checkUpgradeStrategie ');
365: checkUpgradeStrategies(x_return_status);
366: return ;
367: end if;
368: -- End kasreeni 12-16-2005 4887338

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

391: ELSE
392: l_status := 'INPROGRESS';
393: END IF;
394:
395: iex_debug_pub.logmessage('l_status=' || l_status);
396:
397: UPDATE iex_checklist_items_b
398: SET status = l_status, task_last_modified_date = SYSDATE, last_update_date = SYSDATE,
399: last_updated_by = G_USER_ID, last_update_login = G_LOGIN_ID

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

454:
455: IF l_enabled_flag = 'N' THEN
456: FOR r_resp IN c_resp LOOP
457: l_function_name := 'IEX_COLL_CNTR';
458: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
459: OPEN c_funct(r_resp.responsibility_id, l_function_name);
460: FETCH c_funct INTO r_funct;
461: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
462: IF r_funct.action_id IS NULL THEN

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

457: l_function_name := 'IEX_COLL_CNTR';
458: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
459: OPEN c_funct(r_resp.responsibility_id, l_function_name);
460: FETCH c_funct INTO r_funct;
461: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
462: IF r_funct.action_id IS NULL THEN
463: fnd_resp_functions_pkg.insert_row(x_rowid => l_rowid,
464: x_application_id => r_resp.application_id,
465: x_responsibility_id => r_resp.responsibility_id,

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

470: x_last_updated_by => 1,
471: x_last_update_date => SYSDATE,
472: x_last_update_login => 1);
473:
474: iex_debug_pub.logmessage('x_rowid=' || l_rowid);
475:
476: END IF;
477:
478: CLOSE c_funct;

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

479:
480: l_function_name := 'IEX_COLL_CASE';
481: r_funct.action_id := NULL;
482: r_funct.function_id := NULL;
483: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
484: OPEN c_funct(r_resp.responsibility_id, l_function_name);
485: FETCH c_funct INTO r_funct;
486: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
487: IF r_funct.action_id IS NULL THEN

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

482: r_funct.function_id := NULL;
483: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
484: OPEN c_funct(r_resp.responsibility_id, l_function_name);
485: FETCH c_funct INTO r_funct;
486: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
487: IF r_funct.action_id IS NULL THEN
488: fnd_resp_functions_pkg.insert_row(x_rowid => l_rowid,
489: x_application_id => r_resp.application_id,
490: x_responsibility_id => r_resp.responsibility_id,

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

495: x_last_updated_by => 1,
496: x_last_update_date => SYSDATE,
497: x_last_update_login => 1);
498:
499: iex_debug_pub.logmessage('x_rowid=' || l_rowid);
500: END IF;
501:
502: CLOSE c_funct;
503: END LOOP;

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

503: END LOOP;
504: ELSE
505: FOR r_resp IN c_resp LOOP
506: l_function_name := 'IEX_COLL_CNTR';
507: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
508: OPEN c_funct(r_resp.responsibility_id, l_function_name);
509: FETCH c_funct INTO r_funct;
510: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
511: IF r_funct.action_id IS NOT NULL THEN

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

506: l_function_name := 'IEX_COLL_CNTR';
507: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
508: OPEN c_funct(r_resp.responsibility_id, l_function_name);
509: FETCH c_funct INTO r_funct;
510: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
511: IF r_funct.action_id IS NOT NULL THEN
512: fnd_resp_functions_pkg.delete_row(x_application_id => r_resp.application_id,
513: x_responsibility_id => r_resp.responsibility_id,
514: x_action_id => r_funct.action_id,

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

519:
520: l_function_name := 'IEX_COLL_CASE';
521: r_funct.action_id := NULL;
522: r_funct.function_id := NULL;
523: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
524: OPEN c_funct(r_resp.responsibility_id, l_function_name);
525: FETCH c_funct INTO r_funct;
526: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
527: IF r_funct.action_id IS NOT NULL THEN

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

522: r_funct.function_id := NULL;
523: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
524: OPEN c_funct(r_resp.responsibility_id, l_function_name);
525: FETCH c_funct INTO r_funct;
526: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
527: IF r_funct.action_id IS NOT NULL THEN
528: fnd_resp_functions_pkg.delete_row(x_application_id => r_resp.application_id,
529: x_responsibility_id => r_resp.responsibility_id,
530: x_action_id => r_funct.action_id,

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

529: x_responsibility_id => r_resp.responsibility_id,
530: x_action_id => r_funct.action_id,
531: x_rule_type => 'F');
532:
533: iex_debug_pub.logmessage('x_rowid=' || l_rowid);
534: END IF;
535:
536: CLOSE c_funct;
537: END LOOP;

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

630:
631: IF l_enabled_flag = 'N' THEN
632: FOR r_resp IN c_resp LOOP
633: l_function_name := 'IEX_COLL_LOAN';
634: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
635: OPEN c_funct(r_resp.responsibility_id, l_function_name);
636: FETCH c_funct INTO r_funct;
637: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
638: IF r_funct.action_id IS NULL THEN

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

633: l_function_name := 'IEX_COLL_LOAN';
634: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
635: OPEN c_funct(r_resp.responsibility_id, l_function_name);
636: FETCH c_funct INTO r_funct;
637: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
638: IF r_funct.action_id IS NULL THEN
639: fnd_resp_functions_pkg.insert_row(x_rowid => l_rowid,
640: x_application_id => r_resp.application_id,
641: x_responsibility_id => r_resp.responsibility_id,

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

646: x_last_updated_by => 1,
647: x_last_update_date => SYSDATE,
648: x_last_update_login => 1);
649:
650: iex_debug_pub.logmessage('x_rowid=' || l_rowid);
651:
652: END IF;
653:
654: CLOSE c_funct;

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

655: END LOOP;
656: ELSE
657: FOR r_resp IN c_resp LOOP
658: l_function_name := 'IEX_COLL_LOAN';
659: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
660: OPEN c_funct(r_resp.responsibility_id, l_function_name);
661: FETCH c_funct INTO r_funct;
662: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
663: IF r_funct.action_id IS NOT NULL THEN

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

658: l_function_name := 'IEX_COLL_LOAN';
659: iex_debug_pub.logmessage('r.resp.responsibility_id=' || r_resp.responsibility_id || ':l_function_name=' || l_function_name);
660: OPEN c_funct(r_resp.responsibility_id, l_function_name);
661: FETCH c_funct INTO r_funct;
662: iex_debug_pub.logmessage('r_funct.action_id=' || r_funct.action_id || ':r_funct.function_id=' || r_funct.function_id);
663: IF r_funct.action_id IS NOT NULL THEN
664: fnd_resp_functions_pkg.delete_row(x_application_id => r_resp.application_id,
665: x_responsibility_id => r_resp.responsibility_id,
666: x_action_id => r_funct.action_id,

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

674: -- Begin by Ehuh to fix a bug 4639561
675: Begin
676: OPEN get_function_id;
677: FETCH get_function_id into l_func_id;
678: iex_debug_pub.logmessage('Function ID = '||l_func_id);
679:
680: if get_function_id%NOTFOUND then
681: iex_debug_pub.logmessage('NOt found FUNCTION ID ');
682: null;

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

677: FETCH get_function_id into l_func_id;
678: iex_debug_pub.logmessage('Function ID = '||l_func_id);
679:
680: if get_function_id%NOTFOUND then
681: iex_debug_pub.logmessage('NOt found FUNCTION ID ');
682: null;
683: end if;
684:
685: close get_function_id;

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

687: OPEN get_menu_id;
688: FETCH get_menu_id into l_menu_id;
689:
690: if get_menu_id%NOTFOUND then
691: iex_debug_pub.logmessage('NOt found MENU ID ');
692: null;
693: end if;
694:
695: close get_menu_id;

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

698: OPEN get_entry_sequence(l_menu_id , l_func_id );
699: FETCH get_entry_sequence into l_entry_sequence;
700:
701: if get_entry_sequence%NOTFOUND then
702: iex_debug_pub.logmessage('NOt found ENTRY SEQ ');
703: null;
704: end if;
705:
706: close get_entry_sequence;

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

719: end if;
720:
721: Exception
722: When others then
723: iex_debug_pub.logmessage('Exceptopn ');
724: null;
725: End;
726: -- End to fix bug 4639561
727:

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

755: ELSE
756: l_strategy_enabled := 'Y';
757: END IF;
758:
759: iex_debug_pub.logmessage('Starting ....');
760:
761: iex_debug_pub.logmessage('l_promise_enabled=' || l_promise_enabled || ': l_strategy_enabled=' || l_strategy_enabled);
762:
763: -- Start bug 7454867

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

757: END IF;
758:
759: iex_debug_pub.logmessage('Starting ....');
760:
761: iex_debug_pub.logmessage('l_promise_enabled=' || l_promise_enabled || ': l_strategy_enabled=' || l_strategy_enabled);
762:
763: -- Start bug 7454867
764: begin
765: iex_debug_pub.logmessage('Starting Update menu for Stategy Tab based on Questionnaire ....');

Line 765: iex_debug_pub.logmessage('Starting Update menu for Stategy Tab based on Questionnaire ....');

761: iex_debug_pub.logmessage('l_promise_enabled=' || l_promise_enabled || ': l_strategy_enabled=' || l_strategy_enabled);
762:
763: -- Start bug 7454867
764: begin
765: iex_debug_pub.logmessage('Starting Update menu for Stategy Tab based on Questionnaire ....');
766: iex_debug_pub.logmessage('p_collections_methods...... '||p_collections_methods);
767: -- if p_collections_methods = 'STRATEGIES' then
768: -- commented above if and added below Added by snuthala for bug 10221334 21/10/2010
769:

Line 766: iex_debug_pub.logmessage('p_collections_methods...... '||p_collections_methods);

762:
763: -- Start bug 7454867
764: begin
765: iex_debug_pub.logmessage('Starting Update menu for Stategy Tab based on Questionnaire ....');
766: iex_debug_pub.logmessage('p_collections_methods...... '||p_collections_methods);
767: -- if p_collections_methods = 'STRATEGIES' then
768: -- commented above if and added below Added by snuthala for bug 10221334 21/10/2010
769:
770: if p_collections_methods <> 'DUNNING' then

Line 778: iex_debug_pub.logmessage('Exception ....Starting Update menu for Stategy Tab based on Questionnaire');

774: end if;
775: exception
776: when others then
777: null;
778: iex_debug_pub.logmessage('Exception ....Starting Update menu for Stategy Tab based on Questionnaire');
779: end;
780: -- End bug 7454867
781:
782: -- Start for bug 8708271 pnaveenk multi level strategy

Line 792: iex_debug_pub.logmessage( 'Exception in finding number of strategy levels being used');

788: WHERE LOOKUP_TYPE='IEX_RUNNING_LEVEL'
789: AND iex_utilities.validate_running_level(LOOKUP_CODE)='Y';
790: Exception
791: when others then
792: iex_debug_pub.logmessage( 'Exception in finding number of strategy levels being used');
793: End;
794:
795: IF l_str_levels > 1 then
796: iex_debug_pub.logmessage(' Multi level strategy is being used. No need to setup profiles here.');

Line 796: iex_debug_pub.logmessage(' Multi level strategy is being used. No need to setup profiles here.');

792: iex_debug_pub.logmessage( 'Exception in finding number of strategy levels being used');
793: End;
794:
795: IF l_str_levels > 1 then
796: iex_debug_pub.logmessage(' Multi level strategy is being used. No need to setup profiles here.');
797: return;
798: End if;
799:
800: -- End for bug 8708271 pnaveenk

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

1095: -- End fix bug #5142565-JYPARK-Change site level profile too
1096:
1097: -- Begin fix bug #5142565-JYPARK-remove change profile at resp level
1098: -- FOR r_resp IN c_resp LOOP
1099: -- iex_debug_pub.logmessage('responsibility_key=' || r_resp.responsibility_key);
1100: -- IF l_business_level = 'CUSTOMER' THEN
1101: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',
1102: -- x_value => 'Y',
1103: -- x_level_name => 'RESP',

Line 1463: iex_debug_pub.logmessage(' Start IEX_CHECKLIST_UTILITY.CHANGE_MULTIPLE_LEVEL procedure. Setting profiles');

1459: ELSE
1460: l_strategy_enabled := 'Y';
1461: END IF;
1462:
1463: iex_debug_pub.logmessage(' Start IEX_CHECKLIST_UTILITY.CHANGE_MULTIPLE_LEVEL procedure. Setting profiles');
1464: iex_debug_pub.logmessage (' Values of levels set -- Customer Level' || p_customer_level || 'Account Level' || p_account_level || 'BillTo Level' || p_billto_level);
1465: iex_debug_pub.logmessage ( ' Delinquency Level ' || p_delinquency_level || 'Party Override' || p_override_party_level || 'Operating Unit Override' || p_ou_running_level);
1466: iex_debug_pub.logmessage ( ' Promise enabled ' || l_promise_enabled || 'Strategy enabled ' || l_strategy_enabled);
1467:

Line 1464: iex_debug_pub.logmessage (' Values of levels set -- Customer Level' || p_customer_level || 'Account Level' || p_account_level || 'BillTo Level' || p_billto_level);

1460: l_strategy_enabled := 'Y';
1461: END IF;
1462:
1463: iex_debug_pub.logmessage(' Start IEX_CHECKLIST_UTILITY.CHANGE_MULTIPLE_LEVEL procedure. Setting profiles');
1464: iex_debug_pub.logmessage (' Values of levels set -- Customer Level' || p_customer_level || 'Account Level' || p_account_level || 'BillTo Level' || p_billto_level);
1465: iex_debug_pub.logmessage ( ' Delinquency Level ' || p_delinquency_level || 'Party Override' || p_override_party_level || 'Operating Unit Override' || p_ou_running_level);
1466: iex_debug_pub.logmessage ( ' Promise enabled ' || l_promise_enabled || 'Strategy enabled ' || l_strategy_enabled);
1467:
1468: IF p_customer_level = 'Y' then

Line 1465: iex_debug_pub.logmessage ( ' Delinquency Level ' || p_delinquency_level || 'Party Override' || p_override_party_level || 'Operating Unit Override' || p_ou_running_level);

1461: END IF;
1462:
1463: iex_debug_pub.logmessage(' Start IEX_CHECKLIST_UTILITY.CHANGE_MULTIPLE_LEVEL procedure. Setting profiles');
1464: iex_debug_pub.logmessage (' Values of levels set -- Customer Level' || p_customer_level || 'Account Level' || p_account_level || 'BillTo Level' || p_billto_level);
1465: iex_debug_pub.logmessage ( ' Delinquency Level ' || p_delinquency_level || 'Party Override' || p_override_party_level || 'Operating Unit Override' || p_ou_running_level);
1466: iex_debug_pub.logmessage ( ' Promise enabled ' || l_promise_enabled || 'Strategy enabled ' || l_strategy_enabled);
1467:
1468: IF p_customer_level = 'Y' then
1469: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',

Line 1466: iex_debug_pub.logmessage ( ' Promise enabled ' || l_promise_enabled || 'Strategy enabled ' || l_strategy_enabled);

1462:
1463: iex_debug_pub.logmessage(' Start IEX_CHECKLIST_UTILITY.CHANGE_MULTIPLE_LEVEL procedure. Setting profiles');
1464: iex_debug_pub.logmessage (' Values of levels set -- Customer Level' || p_customer_level || 'Account Level' || p_account_level || 'BillTo Level' || p_billto_level);
1465: iex_debug_pub.logmessage ( ' Delinquency Level ' || p_delinquency_level || 'Party Override' || p_override_party_level || 'Operating Unit Override' || p_ou_running_level);
1466: iex_debug_pub.logmessage ( ' Promise enabled ' || l_promise_enabled || 'Strategy enabled ' || l_strategy_enabled);
1467:
1468: IF p_customer_level = 'Y' then
1469: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',
1470: x_value => 'Y',

Line 1476: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Customer View Delinquencies.');

1472: x_level_value => null,
1473: x_level_value_app_id => '',
1474: x_level_value2 => null);
1475: IF l_return = FALSE then
1476: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Customer View Delinquencies.');
1477: END IF;
1478: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',
1479: x_value => l_promise_enabled,
1480: x_level_name => 'SITE',

Line 1485: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Customer View Promises.');

1481: x_level_value => null,
1482: x_level_value_app_id => '',
1483: x_level_value2 => null);
1484: IF l_return = FALSE then
1485: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Customer View Promises.');
1486: END IF;
1487: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',
1488: x_value => l_strategy_enabled,
1489: x_level_name => 'SITE',

Line 1494: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Customer View Strategies.');

1490: x_level_value => null,
1491: x_level_value_app_id => '',
1492: x_level_value2 => null);
1493: IF l_return = FALSE then
1494: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Customer View Strategies.');
1495: END IF;
1496: ELSE
1497: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',
1498: x_value => 'N',

Line 1504: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Customer View Delinquencies.');

1500: x_level_value => null,
1501: x_level_value_app_id => '',
1502: x_level_value2 => null);
1503: IF l_return = FALSE then
1504: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Customer View Delinquencies.');
1505: END IF;
1506: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',
1507: x_value => 'N',
1508: x_level_name => 'SITE',

Line 1513: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Customer View Promises.');

1509: x_level_value => null,
1510: x_level_value_app_id => '',
1511: x_level_value2 => null);
1512: IF l_return = FALSE then
1513: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Customer View Promises.');
1514: END IF;
1515: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',
1516: x_value => 'N',
1517: x_level_name => 'SITE',

Line 1522: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Customer View Strategies.');

1518: x_level_value => null,
1519: x_level_value_app_id => '',
1520: x_level_value2 => null);
1521: IF l_return = FALSE then
1522: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Customer View Strategies.');
1523: END IF;
1524:
1525: END IF;
1526:

Line 1535: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Account View Delinquencies.');

1531: x_level_value => null,
1532: x_level_value_app_id => '',
1533: x_level_value2 => null);
1534: IF l_return = FALSE then
1535: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Account View Delinquencies.');
1536: END IF;
1537: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',
1538: x_value => l_promise_enabled,
1539: x_level_name => 'SITE',

Line 1544: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Account View Promises.');

1540: x_level_value => null,
1541: x_level_value_app_id => '',
1542: x_level_value2 => null);
1543: IF l_return = FALSE then
1544: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Account View Promises.');
1545: END IF;
1546: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',
1547: x_value => l_Strategy_enabled,
1548: x_level_name => 'SITE',

Line 1553: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Account View Strategies.');

1549: x_level_value => null,
1550: x_level_value_app_id => '',
1551: x_level_value2 => null);
1552: IF l_return = FALSE then
1553: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Account View Strategies.');
1554: END IF;
1555:
1556: ELSE
1557: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',

Line 1564: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Account View Delinquencies.');

1560: x_level_value => null,
1561: x_level_value_app_id => '',
1562: x_level_value2 => null);
1563: IF l_return = FALSE then
1564: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Account View Delinquencies.');
1565: END IF;
1566: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',
1567: x_value => 'N',
1568: x_level_name => 'SITE',

Line 1573: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Account View Promises.');

1569: x_level_value => null,
1570: x_level_value_app_id => '',
1571: x_level_value2 => null);
1572: IF l_return = FALSE then
1573: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Account View Promises.');
1574: END IF;
1575: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',
1576: x_value => 'N',
1577: x_level_name => 'SITE',

Line 1582: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Account View Strategies.');

1578: x_level_value => null,
1579: x_level_value_app_id => '',
1580: x_level_value2 => null);
1581: IF l_return = FALSE then
1582: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Account View Strategies.');
1583: END IF;
1584: END IF;
1585:
1586: IF p_billto_level = 'Y' then

Line 1594: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Bill-to View Delinquencies.');

1590: x_level_value => null,
1591: x_level_value_app_id => '',
1592: x_level_value2 => null);
1593: IF l_return = FALSE then
1594: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Bill-to View Delinquencies.');
1595: END IF;
1596: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',
1597: x_value => l_promise_enabled,
1598: x_level_name => 'SITE',

Line 1603: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Bill-to View Promises.');

1599: x_level_value => null,
1600: x_level_value_app_id => '',
1601: x_level_value2 => null);
1602: IF l_return = FALSE then
1603: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Bill-to View Promises.');
1604: END IF;
1605: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',
1606: x_value => l_Strategy_enabled,
1607: x_level_name => 'SITE',

Line 1612: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Bill-to View Strategies.');

1608: x_level_value => null,
1609: x_level_value_app_id => '',
1610: x_level_value2 => null);
1611: IF l_return = FALSE then
1612: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Bill-to View Strategies.');
1613: END IF;
1614:
1615: ELSE
1616:

Line 1624: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Bill-to View Delinquencies.');

1620: x_level_value => null,
1621: x_level_value_app_id => '',
1622: x_level_value2 => null);
1623: IF l_return = FALSE then
1624: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Bill-to View Delinquencies.');
1625: END IF;
1626: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',
1627: x_value => 'N',
1628: x_level_name => 'SITE',

Line 1633: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Bill-to View Promises.');

1629: x_level_value => null,
1630: x_level_value_app_id => '',
1631: x_level_value2 => null);
1632: IF l_return = FALSE then
1633: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Bill-to View Promises.');
1634: END IF;
1635: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',
1636: x_value => 'N',
1637: x_level_name => 'SITE',

Line 1642: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Bill-to View Strategies.');

1638: x_level_value => null,
1639: x_level_value_app_id => '',
1640: x_level_value2 => null);
1641: IF l_return = FALSE then
1642: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Bill-to View Strategies.');
1643: END IF;
1644:
1645: END IF;
1646:

Line 1655: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Delinquency View Delinquencies.');

1651: x_level_value => null,
1652: x_level_value_app_id => '',
1653: x_level_value2 => null);
1654: IF l_return = FALSE then
1655: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Delinquency View Delinquencies.');
1656: END IF;
1657: l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',
1658: x_value => l_promise_enabled,
1659: x_level_name => 'SITE',

Line 1664: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Delinquency View Promises.');

1660: x_level_value => null,
1661: x_level_value_app_id => '',
1662: x_level_value2 => null);
1663: IF l_return = FALSE then
1664: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Delinquency View Promises.');
1665: END IF;
1666: l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',
1667: x_value => l_Strategy_enabled,
1668: x_level_name => 'SITE',

Line 1673: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Delinquency View Strategies.');

1669: x_level_value => null,
1670: x_level_value_app_id => '',
1671: x_level_value2 => null);
1672: IF l_return = FALSE then
1673: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Delinquency View Strategies.');
1674: END IF;
1675:
1676: ELSE
1677:

Line 1685: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Delinquency View Delinquencies.');

1681: x_level_value => null,
1682: x_level_value_app_id => '',
1683: x_level_value2 => null);
1684: IF l_return = FALSE then
1685: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Delinquency View Delinquencies.');
1686: END IF;
1687: l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',
1688: x_value => 'N',
1689: x_level_name => 'SITE',

Line 1694: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Delinquency View Promises.');

1690: x_level_value => null,
1691: x_level_value_app_id => '',
1692: x_level_value2 => null);
1693: IF l_return = FALSE then
1694: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Delinquency View Promises.');
1695: END IF;
1696: l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',
1697: x_value => 'N',
1698: x_level_name => 'SITE',

Line 1703: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Delinquency View Strategies.');

1699: x_level_value => null,
1700: x_level_value_app_id => '',
1701: x_level_value2 => null);
1702: IF l_return = FALSE then
1703: iex_debug_pub.logmessage('Failed to set the profile IEU: Queue: Delinquency View Strategies.');
1704: END IF;
1705:
1706: END IF;
1707:

Line 1716: iex_debug_pub.logmessage('Failed to set the profile IEX: Process Strategies by Operating Unit.');

1712: x_level_value => null,
1713: x_level_value_app_id => '',
1714: x_level_value2 => null);
1715: IF l_return = FALSE then
1716: iex_debug_pub.logmessage('Failed to set the profile IEX: Process Strategies by Operating Unit.');
1717: END IF;
1718: -- bug 9818211 begin
1719: elsif p_ou_running_level = 'N' then
1720: l_return := fnd_profile.save(x_name => 'IEX_PROC_STR_ORG',

Line 1727: iex_debug_pub.logmessage('Failed to set the profile IEX: Process Strategies by Operating Unit.');

1723: x_level_value => null,
1724: x_level_value_app_id => '',
1725: x_level_value2 => null);
1726: IF l_return = FALSE then
1727: iex_debug_pub.logmessage('Failed to set the profile IEX: Process Strategies by Operating Unit.');
1728: END IF;
1729: -- end bug 9818211
1730: END IF;
1731: x_return_status := 'S';

Line 1732: iex_debug_pub.logmessage(' End procedure IEX_CHECKLIST_UTILITY.CHANGE_MULTIPLE_LEVEL . Successfully set the profile values');

1728: END IF;
1729: -- end bug 9818211
1730: END IF;
1731: x_return_status := 'S';
1732: iex_debug_pub.logmessage(' End procedure IEX_CHECKLIST_UTILITY.CHANGE_MULTIPLE_LEVEL . Successfully set the profile values');
1733:
1734: EXCEPTION
1735: WHEN OTHERS THEN
1736: x_return_status := 'F';

Line 1771: iex_debug_pub.logmessage(' In procedure IEX_CHECKLIST_UTILITY.UPDATE_MLSETUP Begin updating multi level strategy set up in questionnaire table');

1767: open c_questionnaire_details;
1768: fetch c_questionnaire_details into l_business_level,l_using_customer_level,l_using_account_level,l_using_billto_level,
1769: l_using_delinquency_level,l_define_ou_running_level,l_define_party_running_level;
1770: close c_questionnaire_details;
1771: iex_debug_pub.logmessage(' In procedure IEX_CHECKLIST_UTILITY.UPDATE_MLSETUP Begin updating multi level strategy set up in questionnaire table');
1772:
1773: c_str_upd := 'update iex_questionnaire_items set ';
1774: l_count := 0;
1775:

Line 1855: iex_debug_pub.logmessage( ' Update Statement constructed before execution ' || c_str_upd);

1851: Begin
1852: IF l_count > 0 then
1853:
1854: c_str_upd := c_str_upd || ' , last_update_date = sysdate , last_updated_by = ' || l_last_updated_by || ' , last_update_login = ' || l_last_update_login;
1855: iex_debug_pub.logmessage( ' Update Statement constructed before execution ' || c_str_upd);
1856: execute immediate c_str_upd;
1857: commit;
1858: END IF;
1859:

Line 1862: iex_debug_pub.logmessage( ' Exception in executing SQL statement ' );

1858: END IF;
1859:
1860: Exception
1861: when others then
1862: iex_debug_pub.logmessage( ' Exception in executing SQL statement ' );
1863: End;
1864: iex_debug_pub.logmessage('End Procedure IEX_CHECKLIST_UTILITY.UPDATE_MLSETUP updating multi level set up in questionnaire table');
1865:
1866: Exception

Line 1864: iex_debug_pub.logmessage('End Procedure IEX_CHECKLIST_UTILITY.UPDATE_MLSETUP updating multi level set up in questionnaire table');

1860: Exception
1861: when others then
1862: iex_debug_pub.logmessage( ' Exception in executing SQL statement ' );
1863: End;
1864: iex_debug_pub.logmessage('End Procedure IEX_CHECKLIST_UTILITY.UPDATE_MLSETUP updating multi level set up in questionnaire table');
1865:
1866: Exception
1867: When Others then
1868: iex_debug_pub.logmessage( ' Exception in updating ml set up' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

Line 1868: iex_debug_pub.logmessage( ' Exception in updating ml set up' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

1864: iex_debug_pub.logmessage('End Procedure IEX_CHECKLIST_UTILITY.UPDATE_MLSETUP updating multi level set up in questionnaire table');
1865:
1866: Exception
1867: When Others then
1868: iex_debug_pub.logmessage( ' Exception in updating ml set up' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1869:
1870: End UPDATE_MLSETUP;
1871:
1872: