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.

[Home] [Help]

APPS.IEX_CHECKLIST_UTILITY dependencies on FND_PROFILE

Line 305: SELECT fnd_profile.value_specific('IEX_COLLECTIONS_BUCKET_NAME', -1, -1, -1, -1, -1) COLLECTIONS_BUCKET,

301: PROCEDURE UPDATE_CHECKLIST_ITEM(
302: p_checklist_item_id IN NUMBER,
303: x_return_status OUT NOCOPY VARCHAR2) IS
304: CURSOR c_general_info IS
305: SELECT fnd_profile.value_specific('IEX_COLLECTIONS_BUCKET_NAME', -1, -1, -1, -1, -1) COLLECTIONS_BUCKET,
306: fnd_profile.value_specific('IEX_ENABLE_CUST_STATUS_EVENT', -1, -1, -1, -1, -1) CUST_STATUS_EVENT,
307: fnd_profile.value_specific('IEX_CUST_ACCESS', -1, -1, -1, -1, -1) WORK_QUEUE_ACCESS,
308: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
309: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE

Line 306: fnd_profile.value_specific('IEX_ENABLE_CUST_STATUS_EVENT', -1, -1, -1, -1, -1) CUST_STATUS_EVENT,

302: p_checklist_item_id IN NUMBER,
303: x_return_status OUT NOCOPY VARCHAR2) IS
304: CURSOR c_general_info IS
305: SELECT fnd_profile.value_specific('IEX_COLLECTIONS_BUCKET_NAME', -1, -1, -1, -1, -1) COLLECTIONS_BUCKET,
306: fnd_profile.value_specific('IEX_ENABLE_CUST_STATUS_EVENT', -1, -1, -1, -1, -1) CUST_STATUS_EVENT,
307: fnd_profile.value_specific('IEX_CUST_ACCESS', -1, -1, -1, -1, -1) WORK_QUEUE_ACCESS,
308: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
309: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
310: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,

Line 307: fnd_profile.value_specific('IEX_CUST_ACCESS', -1, -1, -1, -1, -1) WORK_QUEUE_ACCESS,

303: x_return_status OUT NOCOPY VARCHAR2) IS
304: CURSOR c_general_info IS
305: SELECT fnd_profile.value_specific('IEX_COLLECTIONS_BUCKET_NAME', -1, -1, -1, -1, -1) COLLECTIONS_BUCKET,
306: fnd_profile.value_specific('IEX_ENABLE_CUST_STATUS_EVENT', -1, -1, -1, -1, -1) CUST_STATUS_EVENT,
307: fnd_profile.value_specific('IEX_CUST_ACCESS', -1, -1, -1, -1, -1) WORK_QUEUE_ACCESS,
308: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
309: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
310: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
311: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,

Line 308: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,

304: CURSOR c_general_info IS
305: SELECT fnd_profile.value_specific('IEX_COLLECTIONS_BUCKET_NAME', -1, -1, -1, -1, -1) COLLECTIONS_BUCKET,
306: fnd_profile.value_specific('IEX_ENABLE_CUST_STATUS_EVENT', -1, -1, -1, -1, -1) CUST_STATUS_EVENT,
307: fnd_profile.value_specific('IEX_CUST_ACCESS', -1, -1, -1, -1, -1) WORK_QUEUE_ACCESS,
308: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
309: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
310: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
311: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
312: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,

Line 309: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE

305: SELECT fnd_profile.value_specific('IEX_COLLECTIONS_BUCKET_NAME', -1, -1, -1, -1, -1) COLLECTIONS_BUCKET,
306: fnd_profile.value_specific('IEX_ENABLE_CUST_STATUS_EVENT', -1, -1, -1, -1, -1) CUST_STATUS_EVENT,
307: fnd_profile.value_specific('IEX_CUST_ACCESS', -1, -1, -1, -1, -1) WORK_QUEUE_ACCESS,
308: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
309: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
310: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
311: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
312: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
313: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,

Line 310: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,

306: fnd_profile.value_specific('IEX_ENABLE_CUST_STATUS_EVENT', -1, -1, -1, -1, -1) CUST_STATUS_EVENT,
307: fnd_profile.value_specific('IEX_CUST_ACCESS', -1, -1, -1, -1, -1) WORK_QUEUE_ACCESS,
308: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
309: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
310: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
311: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
312: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
313: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
314: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,

Line 311: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,

307: fnd_profile.value_specific('IEX_CUST_ACCESS', -1, -1, -1, -1, -1) WORK_QUEUE_ACCESS,
308: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
309: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
310: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
311: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
312: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
313: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
314: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
315: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,

Line 312: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,

308: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
309: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
310: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
311: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
312: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
313: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
314: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
315: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,
316: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,

Line 313: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,

309: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
310: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
311: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
312: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
313: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
314: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
315: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,
316: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,
317: -- fnd_profile.value_specific('IEX_CREDIT_HOLD', -1, -1, -1, -1, -1) credit_hold,

Line 314: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,

310: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
311: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
312: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
313: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
314: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
315: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,
316: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,
317: -- fnd_profile.value_specific('IEX_CREDIT_HOLD', -1, -1, -1, -1, -1) credit_hold,
318: -- fnd_profile.value_specific('IEX_SERVICE_HOLD', -1, -1, -1, -1, -1) service_hold_delin

Line 315: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,

311: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
312: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
313: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
314: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
315: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,
316: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,
317: -- fnd_profile.value_specific('IEX_CREDIT_HOLD', -1, -1, -1, -1, -1) credit_hold,
318: -- fnd_profile.value_specific('IEX_SERVICE_HOLD', -1, -1, -1, -1, -1) service_hold_delin
319: FROM dual;

Line 316: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,

312: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
313: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
314: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
315: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,
316: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,
317: -- fnd_profile.value_specific('IEX_CREDIT_HOLD', -1, -1, -1, -1, -1) credit_hold,
318: -- fnd_profile.value_specific('IEX_SERVICE_HOLD', -1, -1, -1, -1, -1) service_hold_delin
319: FROM dual;
320:

Line 317: -- fnd_profile.value_specific('IEX_CREDIT_HOLD', -1, -1, -1, -1, -1) credit_hold,

313: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
314: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
315: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,
316: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,
317: -- fnd_profile.value_specific('IEX_CREDIT_HOLD', -1, -1, -1, -1, -1) credit_hold,
318: -- fnd_profile.value_specific('IEX_SERVICE_HOLD', -1, -1, -1, -1, -1) service_hold_delin
319: FROM dual;
320:
321: l_general_info_row c_general_info%ROWTYPE;

Line 318: -- fnd_profile.value_specific('IEX_SERVICE_HOLD', -1, -1, -1, -1, -1) service_hold_delin

314: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
315: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,
316: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,
317: -- fnd_profile.value_specific('IEX_CREDIT_HOLD', -1, -1, -1, -1, -1) credit_hold,
318: -- fnd_profile.value_specific('IEX_SERVICE_HOLD', -1, -1, -1, -1, -1) service_hold_delin
319: FROM dual;
320:
321: l_general_info_row c_general_info%ROWTYPE;
322: l_status VARCHAR2(30);

Line 732: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',

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',
733: x_value => 'Y',
734: x_level_name => 'SITE',
735: x_level_value => null,
736: x_level_value_app_id => '',

Line 738: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',

734: x_level_name => 'SITE',
735: x_level_value => null,
736: x_level_value_app_id => '',
737: x_level_value2 => null);
738: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',
739: x_value => 'N',
740: x_level_name => 'SITE',
741: x_level_value => null,
742: x_level_value_app_id => '',

Line 744: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',

740: x_level_name => 'SITE',
741: x_level_value => null,
742: x_level_value_app_id => '',
743: x_level_value2 => null);
744: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',
745: x_value => 'N',
746: x_level_name => 'SITE',
747: x_level_value => null,
748: x_level_value_app_id => '',

Line 750: l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',

746: x_level_name => 'SITE',
747: x_level_value => null,
748: x_level_value_app_id => '',
749: x_level_value2 => null);
750: l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',
751: x_value => 'N',
752: x_level_name => 'SITE',
753: x_level_value => null,
754: x_level_value_app_id => '',

Line 756: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',

752: x_level_name => 'SITE',
753: x_level_value => null,
754: x_level_value_app_id => '',
755: x_level_value2 => null);
756: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',
757: x_value => l_promise_enabled,
758: x_level_name => 'SITE',
759: x_level_value => null,
760: x_level_value_app_id => '',

Line 762: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',

758: x_level_name => 'SITE',
759: x_level_value => null,
760: x_level_value_app_id => '',
761: x_level_value2 => null);
762: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',
763: x_value => 'N',
764: x_level_name => 'SITE',
765: x_level_value => null,
766: x_level_value_app_id => '',

Line 768: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',

764: x_level_name => 'SITE',
765: x_level_value => null,
766: x_level_value_app_id => '',
767: x_level_value2 => null);
768: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',
769: x_value => 'N',
770: x_level_name => 'SITE',
771: x_level_value => null,
772: x_level_value_app_id => '',

Line 774: l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',

770: x_level_name => 'SITE',
771: x_level_value => null,
772: x_level_value_app_id => '',
773: x_level_value2 => null);
774: l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',
775: x_value => 'N',
776: x_level_name => 'SITE',
777: x_level_value => null,
778: x_level_value_app_id => '',

Line 780: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',

776: x_level_name => 'SITE',
777: x_level_value => null,
778: x_level_value_app_id => '',
779: x_level_value2 => null);
780: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',
781: x_value => l_strategy_enabled,
782: x_level_name => 'SITE',
783: x_level_value => null,
784: x_level_value_app_id => '',

Line 786: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',

782: x_level_name => 'SITE',
783: x_level_value => null,
784: x_level_value_app_id => '',
785: x_level_value2 => null);
786: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',
787: x_value => 'N',
788: x_level_name => 'SITE',
789: x_level_value => null,
790: x_level_value_app_id => '',

Line 792: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',

788: x_level_name => 'SITE',
789: x_level_value => null,
790: x_level_value_app_id => '',
791: x_level_value2 => null);
792: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',
793: x_value => 'N',
794: x_level_name => 'SITE',
795: x_level_value => null,
796: x_level_value_app_id => '',

Line 798: l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',

794: x_level_name => 'SITE',
795: x_level_value => null,
796: x_level_value_app_id => '',
797: x_level_value2 => null);
798: l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',
799: x_value => 'N',
800: x_level_name => 'SITE',
801: x_level_value => null,
802: x_level_value_app_id => '',

Line 805: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',

801: x_level_value => null,
802: x_level_value_app_id => '',
803: x_level_value2 => null);
804: ELSIF l_business_level = 'ACCOUNT' THEN
805: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',
806: x_value => 'N',
807: x_level_name => 'SITE',
808: x_level_value => null,
809: x_level_value_app_id => '',

Line 811: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',

807: x_level_name => 'SITE',
808: x_level_value => null,
809: x_level_value_app_id => '',
810: x_level_value2 => null);
811: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',
812: x_value => 'Y',
813: x_level_name => 'SITE',
814: x_level_value => null,
815: x_level_value_app_id => '',

Line 817: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',

813: x_level_name => 'SITE',
814: x_level_value => null,
815: x_level_value_app_id => '',
816: x_level_value2 => null);
817: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',
818: x_value => 'N',
819: x_level_name => 'SITE',
820: x_level_value => null,
821: x_level_value_app_id => '',

Line 823: l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',

819: x_level_name => 'SITE',
820: x_level_value => null,
821: x_level_value_app_id => '',
822: x_level_value2 => null);
823: l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',
824: x_value => 'N',
825: x_level_name => 'SITE',
826: x_level_value => null,
827: x_level_value_app_id => '',

Line 829: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',

825: x_level_name => 'SITE',
826: x_level_value => null,
827: x_level_value_app_id => '',
828: x_level_value2 => null);
829: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',
830: x_value => 'N',
831: x_level_name => 'SITE',
832: x_level_value => null,
833: x_level_value_app_id => '',

Line 835: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',

831: x_level_name => 'SITE',
832: x_level_value => null,
833: x_level_value_app_id => '',
834: x_level_value2 => null);
835: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',
836: x_value => l_promise_enabled,
837: x_level_name => 'SITE',
838: x_level_value => null,
839: x_level_value_app_id => '',

Line 841: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',

837: x_level_name => 'SITE',
838: x_level_value => null,
839: x_level_value_app_id => '',
840: x_level_value2 => null);
841: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',
842: x_value => 'N',
843: x_level_name => 'SITE',
844: x_level_value => null,
845: x_level_value_app_id => '',

Line 847: l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',

843: x_level_name => 'SITE',
844: x_level_value => null,
845: x_level_value_app_id => '',
846: x_level_value2 => null);
847: l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',
848: x_value => 'N',
849: x_level_name => 'SITE',
850: x_level_value => null,
851: x_level_value_app_id => '',

Line 853: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',

849: x_level_name => 'SITE',
850: x_level_value => null,
851: x_level_value_app_id => '',
852: x_level_value2 => null);
853: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',
854: x_value => 'N',
855: x_level_name => 'SITE',
856: x_level_value => null,
857: x_level_value_app_id => '',

Line 859: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',

855: x_level_name => 'SITE',
856: x_level_value => null,
857: x_level_value_app_id => '',
858: x_level_value2 => null);
859: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',
860: x_value => l_Strategy_enabled,
861: x_level_name => 'SITE',
862: x_level_value => null,
863: x_level_value_app_id => '',

Line 865: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',

861: x_level_name => 'SITE',
862: x_level_value => null,
863: x_level_value_app_id => '',
864: x_level_value2 => null);
865: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',
866: x_value => 'N',
867: x_level_name => 'SITE',
868: x_level_value => null,
869: x_level_value_app_id => '',

Line 871: l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',

867: x_level_name => 'SITE',
868: x_level_value => null,
869: x_level_value_app_id => '',
870: x_level_value2 => null);
871: l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',
872: x_value => 'N',
873: x_level_name => 'SITE',
874: x_level_value => null,
875: x_level_value_app_id => '',

Line 878: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',

874: x_level_value => null,
875: x_level_value_app_id => '',
876: x_level_value2 => null);
877: ELSIF l_business_level = 'BILL_TO' THEN
878: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',
879: x_value => 'N',
880: x_level_name => 'SITE',
881: x_level_value => null,
882: x_level_value_app_id => '',

Line 884: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',

880: x_level_name => 'SITE',
881: x_level_value => null,
882: x_level_value_app_id => '',
883: x_level_value2 => null);
884: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',
885: x_value => 'N',
886: x_level_name => 'SITE',
887: x_level_value => null,
888: x_level_value_app_id => '',

Line 890: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',

886: x_level_name => 'SITE',
887: x_level_value => null,
888: x_level_value_app_id => '',
889: x_level_value2 => null);
890: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',
891: x_value => 'Y',
892: x_level_name => 'SITE',
893: x_level_value => null,
894: x_level_value_app_id => '',

Line 896: l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',

892: x_level_name => 'SITE',
893: x_level_value => null,
894: x_level_value_app_id => '',
895: x_level_value2 => null);
896: l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',
897: x_value => 'N',
898: x_level_name => 'SITE',
899: x_level_value => null,
900: x_level_value_app_id => '',

Line 902: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',

898: x_level_name => 'SITE',
899: x_level_value => null,
900: x_level_value_app_id => '',
901: x_level_value2 => null);
902: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',
903: x_value => 'N',
904: x_level_name => 'SITE',
905: x_level_value => null,
906: x_level_value_app_id => '',

Line 908: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',

904: x_level_name => 'SITE',
905: x_level_value => null,
906: x_level_value_app_id => '',
907: x_level_value2 => null);
908: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',
909: x_value => 'N',
910: x_level_name => 'SITE',
911: x_level_value => null,
912: x_level_value_app_id => '',

Line 914: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',

910: x_level_name => 'SITE',
911: x_level_value => null,
912: x_level_value_app_id => '',
913: x_level_value2 => null);
914: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',
915: x_value => l_promise_enabled,
916: x_level_name => 'SITE',
917: x_level_value => null,
918: x_level_value_app_id => '',

Line 920: l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',

916: x_level_name => 'SITE',
917: x_level_value => null,
918: x_level_value_app_id => '',
919: x_level_value2 => null);
920: l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',
921: x_value => 'N',
922: x_level_name => 'SITE',
923: x_level_value => null,
924: x_level_value_app_id => '',

Line 926: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',

922: x_level_name => 'SITE',
923: x_level_value => null,
924: x_level_value_app_id => '',
925: x_level_value2 => null);
926: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',
927: x_value => 'N',
928: x_level_name => 'SITE',
929: x_level_value => null,
930: x_level_value_app_id => '',

Line 932: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',

928: x_level_name => 'SITE',
929: x_level_value => null,
930: x_level_value_app_id => '',
931: x_level_value2 => null);
932: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',
933: x_value => 'N',
934: x_level_name => 'SITE',
935: x_level_value => null,
936: x_level_value_app_id => '',

Line 938: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',

934: x_level_name => 'SITE',
935: x_level_value => null,
936: x_level_value_app_id => '',
937: x_level_value2 => null);
938: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',
939: x_value => l_Strategy_enabled,
940: x_level_name => 'SITE',
941: x_level_value => null,
942: x_level_value_app_id => '',

Line 944: l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',

940: x_level_name => 'SITE',
941: x_level_value => null,
942: x_level_value_app_id => '',
943: x_level_value2 => null);
944: l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',
945: x_value => 'N',
946: x_level_name => 'SITE',
947: x_level_value => null,
948: x_level_value_app_id => '',

Line 951: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',

947: x_level_value => null,
948: x_level_value_app_id => '',
949: x_level_value2 => null);
950: ELSIF l_business_level = 'DELINQUENCY' THEN
951: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',
952: x_value => 'N',
953: x_level_name => 'SITE',
954: x_level_value => null,
955: x_level_value_app_id => '',

Line 957: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',

953: x_level_name => 'SITE',
954: x_level_value => null,
955: x_level_value_app_id => '',
956: x_level_value2 => null);
957: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',
958: x_value => 'N',
959: x_level_name => 'SITE',
960: x_level_value => null,
961: x_level_value_app_id => '',

Line 963: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',

959: x_level_name => 'SITE',
960: x_level_value => null,
961: x_level_value_app_id => '',
962: x_level_value2 => null);
963: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',
964: x_value => 'N',
965: x_level_name => 'SITE',
966: x_level_value => null,
967: x_level_value_app_id => '',

Line 969: l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',

965: x_level_name => 'SITE',
966: x_level_value => null,
967: x_level_value_app_id => '',
968: x_level_value2 => null);
969: l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',
970: x_value => 'Y',
971: x_level_name => 'SITE',
972: x_level_value => null,
973: x_level_value_app_id => '',

Line 975: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',

971: x_level_name => 'SITE',
972: x_level_value => null,
973: x_level_value_app_id => '',
974: x_level_value2 => null);
975: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',
976: x_value => 'N',
977: x_level_name => 'SITE',
978: x_level_value => null,
979: x_level_value_app_id => '',

Line 981: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',

977: x_level_name => 'SITE',
978: x_level_value => null,
979: x_level_value_app_id => '',
980: x_level_value2 => null);
981: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',
982: x_value => 'N',
983: x_level_name => 'SITE',
984: x_level_value => null,
985: x_level_value_app_id => '',

Line 987: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',

983: x_level_name => 'SITE',
984: x_level_value => null,
985: x_level_value_app_id => '',
986: x_level_value2 => null);
987: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',
988: x_value => 'N',
989: x_level_name => 'SITE',
990: x_level_value => null,
991: x_level_value_app_id => '',

Line 993: l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',

989: x_level_name => 'SITE',
990: x_level_value => null,
991: x_level_value_app_id => '',
992: x_level_value2 => null);
993: l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',
994: x_value => l_promise_enabled,
995: x_level_name => 'SITE',
996: x_level_value => null,
997: x_level_value_app_id => '',

Line 999: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',

995: x_level_name => 'SITE',
996: x_level_value => null,
997: x_level_value_app_id => '',
998: x_level_value2 => null);
999: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',
1000: x_value => 'N',
1001: x_level_name => 'SITE',
1002: x_level_value => null,
1003: x_level_value_app_id => '',

Line 1005: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',

1001: x_level_name => 'SITE',
1002: x_level_value => null,
1003: x_level_value_app_id => '',
1004: x_level_value2 => null);
1005: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',
1006: x_value => 'N',
1007: x_level_name => 'SITE',
1008: x_level_value => null,
1009: x_level_value_app_id => '',

Line 1011: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',

1007: x_level_name => 'SITE',
1008: x_level_value => null,
1009: x_level_value_app_id => '',
1010: x_level_value2 => null);
1011: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',
1012: x_value => 'N',
1013: x_level_name => 'SITE',
1014: x_level_value => null,
1015: x_level_value_app_id => '',

Line 1017: l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',

1013: x_level_name => 'SITE',
1014: x_level_value => null,
1015: x_level_value_app_id => '',
1016: x_level_value2 => null);
1017: l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',
1018: x_value => l_Strategy_enabled,
1019: x_level_name => 'SITE',
1020: x_level_value => null,
1021: x_level_value_app_id => '',

Line 1030: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',

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',
1033: -- x_level_value => r_resp.responsibility_id,
1034: -- x_level_value_app_id => '695',

Line 1036: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',

1032: -- x_level_name => 'RESP',
1033: -- x_level_value => r_resp.responsibility_id,
1034: -- x_level_value_app_id => '695',
1035: -- x_level_value2 => null);
1036: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',
1037: -- x_value => 'N',
1038: -- x_level_name => 'RESP',
1039: -- x_level_value => r_resp.responsibility_id,
1040: -- x_level_value_app_id => '695',

Line 1042: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',

1038: -- x_level_name => 'RESP',
1039: -- x_level_value => r_resp.responsibility_id,
1040: -- x_level_value_app_id => '695',
1041: -- x_level_value2 => null);
1042: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',
1043: -- x_value => 'N',
1044: -- x_level_name => 'RESP',
1045: -- x_level_value => r_resp.responsibility_id,
1046: -- x_level_value_app_id => '695',

Line 1048: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',

1044: -- x_level_name => 'RESP',
1045: -- x_level_value => r_resp.responsibility_id,
1046: -- x_level_value_app_id => '695',
1047: -- x_level_value2 => null);
1048: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',
1049: -- x_value => 'N',
1050: -- x_level_name => 'RESP',
1051: -- x_level_value => r_resp.responsibility_id,
1052: -- x_level_value_app_id => '695',

Line 1054: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',

1050: -- x_level_name => 'RESP',
1051: -- x_level_value => r_resp.responsibility_id,
1052: -- x_level_value_app_id => '695',
1053: -- x_level_value2 => null);
1054: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',
1055: -- x_value => l_promise_enabled,
1056: -- x_level_name => 'RESP',
1057: -- x_level_value => r_resp.responsibility_id,
1058: -- x_level_value_app_id => '695',

Line 1060: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',

1056: -- x_level_name => 'RESP',
1057: -- x_level_value => r_resp.responsibility_id,
1058: -- x_level_value_app_id => '695',
1059: -- x_level_value2 => null);
1060: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',
1061: -- x_value => 'N',
1062: -- x_level_name => 'RESP',
1063: -- x_level_value => r_resp.responsibility_id,
1064: -- x_level_value_app_id => '695',

Line 1066: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',

1062: -- x_level_name => 'RESP',
1063: -- x_level_value => r_resp.responsibility_id,
1064: -- x_level_value_app_id => '695',
1065: -- x_level_value2 => null);
1066: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',
1067: -- x_value => 'N',
1068: -- x_level_name => 'RESP',
1069: -- x_level_value => r_resp.responsibility_id,
1070: -- x_level_value_app_id => '695',

Line 1072: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',

1068: -- x_level_name => 'RESP',
1069: -- x_level_value => r_resp.responsibility_id,
1070: -- x_level_value_app_id => '695',
1071: -- x_level_value2 => null);
1072: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',
1073: -- x_value => 'N',
1074: -- x_level_name => 'RESP',
1075: -- x_level_value => r_resp.responsibility_id,
1076: -- x_level_value_app_id => '695',

Line 1078: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',

1074: -- x_level_name => 'RESP',
1075: -- x_level_value => r_resp.responsibility_id,
1076: -- x_level_value_app_id => '695',
1077: -- x_level_value2 => null);
1078: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',
1079: -- x_value => l_strategy_enabled,
1080: -- x_level_name => 'RESP',
1081: -- x_level_value => r_resp.responsibility_id,
1082: -- x_level_value_app_id => '695',

Line 1084: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',

1080: -- x_level_name => 'RESP',
1081: -- x_level_value => r_resp.responsibility_id,
1082: -- x_level_value_app_id => '695',
1083: -- x_level_value2 => null);
1084: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',
1085: -- x_value => 'N',
1086: -- x_level_name => 'RESP',
1087: -- x_level_value => r_resp.responsibility_id,
1088: -- x_level_value_app_id => '695',

Line 1090: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',

1086: -- x_level_name => 'RESP',
1087: -- x_level_value => r_resp.responsibility_id,
1088: -- x_level_value_app_id => '695',
1089: -- x_level_value2 => null);
1090: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',
1091: -- x_value => 'N',
1092: -- x_level_name => 'RESP',
1093: -- x_level_value => r_resp.responsibility_id,
1094: -- x_level_value_app_id => '695',

Line 1096: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',

1092: -- x_level_name => 'RESP',
1093: -- x_level_value => r_resp.responsibility_id,
1094: -- x_level_value_app_id => '695',
1095: -- x_level_value2 => null);
1096: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',
1097: -- x_value => 'N',
1098: -- x_level_name => 'RESP',
1099: -- x_level_value => r_resp.responsibility_id,
1100: -- x_level_value_app_id => '695',

Line 1103: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',

1099: -- x_level_value => r_resp.responsibility_id,
1100: -- x_level_value_app_id => '695',
1101: -- x_level_value2 => null);
1102: -- ELSIF l_business_level = 'ACCOUNT' THEN
1103: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',
1104: -- x_value => 'N',
1105: -- x_level_name => 'RESP',
1106: -- x_level_value => r_resp.responsibility_id,
1107: -- x_level_value_app_id => '695',

Line 1109: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',

1105: -- x_level_name => 'RESP',
1106: -- x_level_value => r_resp.responsibility_id,
1107: -- x_level_value_app_id => '695',
1108: -- x_level_value2 => null);
1109: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',
1110: -- x_value => 'Y',
1111: -- x_level_name => 'RESP',
1112: -- x_level_value => r_resp.responsibility_id,
1113: -- x_level_value_app_id => '695',

Line 1115: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',

1111: -- x_level_name => 'RESP',
1112: -- x_level_value => r_resp.responsibility_id,
1113: -- x_level_value_app_id => '695',
1114: -- x_level_value2 => null);
1115: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',
1116: -- x_value => 'N',
1117: -- x_level_name => 'RESP',
1118: -- x_level_value => r_resp.responsibility_id,
1119: -- x_level_value_app_id => '695',

Line 1121: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',

1117: -- x_level_name => 'RESP',
1118: -- x_level_value => r_resp.responsibility_id,
1119: -- x_level_value_app_id => '695',
1120: -- x_level_value2 => null);
1121: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',
1122: -- x_value => 'N',
1123: -- x_level_name => 'RESP',
1124: -- x_level_value => r_resp.responsibility_id,
1125: -- x_level_value_app_id => '695',

Line 1127: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',

1123: -- x_level_name => 'RESP',
1124: -- x_level_value => r_resp.responsibility_id,
1125: -- x_level_value_app_id => '695',
1126: -- x_level_value2 => null);
1127: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',
1128: -- x_value => 'N',
1129: -- x_level_name => 'RESP',
1130: -- x_level_value => r_resp.responsibility_id,
1131: -- x_level_value_app_id => '695',

Line 1133: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',

1129: -- x_level_name => 'RESP',
1130: -- x_level_value => r_resp.responsibility_id,
1131: -- x_level_value_app_id => '695',
1132: -- x_level_value2 => null);
1133: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',
1134: -- x_value => l_promise_enabled,
1135: -- x_level_name => 'RESP',
1136: -- x_level_value => r_resp.responsibility_id,
1137: -- x_level_value_app_id => '695',

Line 1139: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',

1135: -- x_level_name => 'RESP',
1136: -- x_level_value => r_resp.responsibility_id,
1137: -- x_level_value_app_id => '695',
1138: -- x_level_value2 => null);
1139: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',
1140: -- x_value => 'N',
1141: -- x_level_name => 'RESP',
1142: -- x_level_value => r_resp.responsibility_id,
1143: -- x_level_value_app_id => '695',

Line 1145: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',

1141: -- x_level_name => 'RESP',
1142: -- x_level_value => r_resp.responsibility_id,
1143: -- x_level_value_app_id => '695',
1144: -- x_level_value2 => null);
1145: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',
1146: -- x_value => 'N',
1147: -- x_level_name => 'RESP',
1148: -- x_level_value => r_resp.responsibility_id,
1149: -- x_level_value_app_id => '695',

Line 1151: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',

1147: -- x_level_name => 'RESP',
1148: -- x_level_value => r_resp.responsibility_id,
1149: -- x_level_value_app_id => '695',
1150: -- x_level_value2 => null);
1151: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',
1152: -- x_value => 'N',
1153: -- x_level_name => 'RESP',
1154: -- x_level_value => r_resp.responsibility_id,
1155: -- x_level_value_app_id => '695',

Line 1157: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',

1153: -- x_level_name => 'RESP',
1154: -- x_level_value => r_resp.responsibility_id,
1155: -- x_level_value_app_id => '695',
1156: -- x_level_value2 => null);
1157: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',
1158: -- x_value => l_Strategy_enabled,
1159: -- x_level_name => 'RESP',
1160: -- x_level_value => r_resp.responsibility_id,
1161: -- x_level_value_app_id => '695',

Line 1163: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',

1159: -- x_level_name => 'RESP',
1160: -- x_level_value => r_resp.responsibility_id,
1161: -- x_level_value_app_id => '695',
1162: -- x_level_value2 => null);
1163: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',
1164: -- x_value => 'N',
1165: -- x_level_name => 'RESP',
1166: -- x_level_value => r_resp.responsibility_id,
1167: -- x_level_value_app_id => '695',

Line 1169: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',

1165: -- x_level_name => 'RESP',
1166: -- x_level_value => r_resp.responsibility_id,
1167: -- x_level_value_app_id => '695',
1168: -- x_level_value2 => null);
1169: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',
1170: -- x_value => 'N',
1171: -- x_level_name => 'RESP',
1172: -- x_level_value => r_resp.responsibility_id,
1173: -- x_level_value_app_id => '695',

Line 1176: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',

1172: -- x_level_value => r_resp.responsibility_id,
1173: -- x_level_value_app_id => '695',
1174: -- x_level_value2 => null);
1175: -- ELSIF l_business_level = 'BILL_TO' THEN
1176: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',
1177: -- x_value => 'N',
1178: -- x_level_name => 'RESP',
1179: -- x_level_value => r_resp.responsibility_id,
1180: -- x_level_value_app_id => '695',

Line 1182: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',

1178: -- x_level_name => 'RESP',
1179: -- x_level_value => r_resp.responsibility_id,
1180: -- x_level_value_app_id => '695',
1181: -- x_level_value2 => null);
1182: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',
1183: -- x_value => 'N',
1184: -- x_level_name => 'RESP',
1185: -- x_level_value => r_resp.responsibility_id,
1186: -- x_level_value_app_id => '695',

Line 1188: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',

1184: -- x_level_name => 'RESP',
1185: -- x_level_value => r_resp.responsibility_id,
1186: -- x_level_value_app_id => '695',
1187: -- x_level_value2 => null);
1188: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',
1189: -- x_value => 'Y',
1190: -- x_level_name => 'RESP',
1191: -- x_level_value => r_resp.responsibility_id,
1192: -- x_level_value_app_id => '695',

Line 1194: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',

1190: -- x_level_name => 'RESP',
1191: -- x_level_value => r_resp.responsibility_id,
1192: -- x_level_value_app_id => '695',
1193: -- x_level_value2 => null);
1194: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',
1195: -- x_value => 'N',
1196: -- x_level_name => 'RESP',
1197: -- x_level_value => r_resp.responsibility_id,
1198: -- x_level_value_app_id => '695',

Line 1200: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',

1196: -- x_level_name => 'RESP',
1197: -- x_level_value => r_resp.responsibility_id,
1198: -- x_level_value_app_id => '695',
1199: -- x_level_value2 => null);
1200: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',
1201: -- x_value => 'N',
1202: -- x_level_name => 'RESP',
1203: -- x_level_value => r_resp.responsibility_id,
1204: -- x_level_value_app_id => '695',

Line 1206: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',

1202: -- x_level_name => 'RESP',
1203: -- x_level_value => r_resp.responsibility_id,
1204: -- x_level_value_app_id => '695',
1205: -- x_level_value2 => null);
1206: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',
1207: -- x_value => 'N',
1208: -- x_level_name => 'RESP',
1209: -- x_level_value => r_resp.responsibility_id,
1210: -- x_level_value_app_id => '695',

Line 1212: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',

1208: -- x_level_name => 'RESP',
1209: -- x_level_value => r_resp.responsibility_id,
1210: -- x_level_value_app_id => '695',
1211: -- x_level_value2 => null);
1212: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',
1213: -- x_value => l_promise_enabled,
1214: -- x_level_name => 'RESP',
1215: -- x_level_value => r_resp.responsibility_id,
1216: -- x_level_value_app_id => '695',

Line 1218: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',

1214: -- x_level_name => 'RESP',
1215: -- x_level_value => r_resp.responsibility_id,
1216: -- x_level_value_app_id => '695',
1217: -- x_level_value2 => null);
1218: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',
1219: -- x_value => 'N',
1220: -- x_level_name => 'RESP',
1221: -- x_level_value => r_resp.responsibility_id,
1222: -- x_level_value_app_id => '695',

Line 1224: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',

1220: -- x_level_name => 'RESP',
1221: -- x_level_value => r_resp.responsibility_id,
1222: -- x_level_value_app_id => '695',
1223: -- x_level_value2 => null);
1224: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',
1225: -- x_value => 'N',
1226: -- x_level_name => 'RESP',
1227: -- x_level_value => r_resp.responsibility_id,
1228: -- x_level_value_app_id => '695',

Line 1230: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',

1226: -- x_level_name => 'RESP',
1227: -- x_level_value => r_resp.responsibility_id,
1228: -- x_level_value_app_id => '695',
1229: -- x_level_value2 => null);
1230: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',
1231: -- x_value => 'N',
1232: -- x_level_name => 'RESP',
1233: -- x_level_value => r_resp.responsibility_id,
1234: -- x_level_value_app_id => '695',

Line 1236: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',

1232: -- x_level_name => 'RESP',
1233: -- x_level_value => r_resp.responsibility_id,
1234: -- x_level_value_app_id => '695',
1235: -- x_level_value2 => null);
1236: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',
1237: -- x_value => l_Strategy_enabled,
1238: -- x_level_name => 'RESP',
1239: -- x_level_value => r_resp.responsibility_id,
1240: -- x_level_value_app_id => '695',

Line 1242: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',

1238: -- x_level_name => 'RESP',
1239: -- x_level_value => r_resp.responsibility_id,
1240: -- x_level_value_app_id => '695',
1241: -- x_level_value2 => null);
1242: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',
1243: -- x_value => 'N',
1244: -- x_level_name => 'RESP',
1245: -- x_level_value => r_resp.responsibility_id,
1246: -- x_level_value_app_id => '695',

Line 1249: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',

1245: -- x_level_value => r_resp.responsibility_id,
1246: -- x_level_value_app_id => '695',
1247: -- x_level_value2 => null);
1248: -- ELSIF l_business_level = 'DELINQUENCY' THEN
1249: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',
1250: -- x_value => 'N',
1251: -- x_level_name => 'RESP',
1252: -- x_level_value => r_resp.responsibility_id,
1253: -- x_level_value_app_id => '695',

Line 1255: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',

1251: -- x_level_name => 'RESP',
1252: -- x_level_value => r_resp.responsibility_id,
1253: -- x_level_value_app_id => '695',
1254: -- x_level_value2 => null);
1255: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',
1256: -- x_value => 'N',
1257: -- x_level_name => 'RESP',
1258: -- x_level_value => r_resp.responsibility_id,
1259: -- x_level_value_app_id => '695',

Line 1261: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',

1257: -- x_level_name => 'RESP',
1258: -- x_level_value => r_resp.responsibility_id,
1259: -- x_level_value_app_id => '695',
1260: -- x_level_value2 => null);
1261: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',
1262: -- x_value => 'N',
1263: -- x_level_name => 'RESP',
1264: -- x_level_value => r_resp.responsibility_id,
1265: -- x_level_value_app_id => '695',

Line 1267: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',

1263: -- x_level_name => 'RESP',
1264: -- x_level_value => r_resp.responsibility_id,
1265: -- x_level_value_app_id => '695',
1266: -- x_level_value2 => null);
1267: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',
1268: -- x_value => 'Y',
1269: -- x_level_name => 'RESP',
1270: -- x_level_value => r_resp.responsibility_id,
1271: -- x_level_value_app_id => '695',

Line 1273: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',

1269: -- x_level_name => 'RESP',
1270: -- x_level_value => r_resp.responsibility_id,
1271: -- x_level_value_app_id => '695',
1272: -- x_level_value2 => null);
1273: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',
1274: -- x_value => 'N',
1275: -- x_level_name => 'RESP',
1276: -- x_level_value => r_resp.responsibility_id,
1277: -- x_level_value_app_id => '695',

Line 1279: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',

1275: -- x_level_name => 'RESP',
1276: -- x_level_value => r_resp.responsibility_id,
1277: -- x_level_value_app_id => '695',
1278: -- x_level_value2 => null);
1279: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',
1280: -- x_value => 'N',
1281: -- x_level_name => 'RESP',
1282: -- x_level_value => r_resp.responsibility_id,
1283: -- x_level_value_app_id => '695',

Line 1285: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',

1281: -- x_level_name => 'RESP',
1282: -- x_level_value => r_resp.responsibility_id,
1283: -- x_level_value_app_id => '695',
1284: -- x_level_value2 => null);
1285: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',
1286: -- x_value => 'N',
1287: -- x_level_name => 'RESP',
1288: -- x_level_value => r_resp.responsibility_id,
1289: -- x_level_value_app_id => '695',

Line 1291: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',

1287: -- x_level_name => 'RESP',
1288: -- x_level_value => r_resp.responsibility_id,
1289: -- x_level_value_app_id => '695',
1290: -- x_level_value2 => null);
1291: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',
1292: -- x_value => l_promise_enabled,
1293: -- x_level_name => 'RESP',
1294: -- x_level_value => r_resp.responsibility_id,
1295: -- x_level_value_app_id => '695',

Line 1297: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',

1293: -- x_level_name => 'RESP',
1294: -- x_level_value => r_resp.responsibility_id,
1295: -- x_level_value_app_id => '695',
1296: -- x_level_value2 => null);
1297: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',
1298: -- x_value => 'N',
1299: -- x_level_name => 'RESP',
1300: -- x_level_value => r_resp.responsibility_id,
1301: -- x_level_value_app_id => '695',

Line 1303: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',

1299: -- x_level_name => 'RESP',
1300: -- x_level_value => r_resp.responsibility_id,
1301: -- x_level_value_app_id => '695',
1302: -- x_level_value2 => null);
1303: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',
1304: -- x_value => 'N',
1305: -- x_level_name => 'RESP',
1306: -- x_level_value => r_resp.responsibility_id,
1307: -- x_level_value_app_id => '695',

Line 1309: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',

1305: -- x_level_name => 'RESP',
1306: -- x_level_value => r_resp.responsibility_id,
1307: -- x_level_value_app_id => '695',
1308: -- x_level_value2 => null);
1309: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',
1310: -- x_value => 'N',
1311: -- x_level_name => 'RESP',
1312: -- x_level_value => r_resp.responsibility_id,
1313: -- x_level_value_app_id => '695',

Line 1315: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',

1311: -- x_level_name => 'RESP',
1312: -- x_level_value => r_resp.responsibility_id,
1313: -- x_level_value_app_id => '695',
1314: -- x_level_value2 => null);
1315: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',
1316: -- x_value => l_Strategy_enabled,
1317: -- x_level_name => 'RESP',
1318: -- x_level_value => r_resp.responsibility_id,
1319: -- x_level_value_app_id => '695',

Line 1359: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

1355:
1356: fnd_msg_pub.add;
1357: END UPDATE_CHECKLIST_ITEM_BY_NAME;
1358: BEGIN
1359: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
1360: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
1361: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
1362: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
1363: G_USER_ID := FND_GLOBAL.User_Id;