DBA Data[Home] [Help]

APPS.IEX_CHECKLIST_UTILITY dependencies on FND_PROFILE

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

317: PROCEDURE UPDATE_CHECKLIST_ITEM(
318: p_checklist_item_id IN NUMBER,
319: x_return_status OUT NOCOPY VARCHAR2) IS
320: CURSOR c_general_info IS
321: SELECT fnd_profile.value_specific('IEX_COLLECTIONS_BUCKET_NAME', -1, -1, -1, -1, -1) COLLECTIONS_BUCKET,
322: fnd_profile.value_specific('IEX_ENABLE_CUST_STATUS_EVENT', -1, -1, -1, -1, -1) CUST_STATUS_EVENT,
323: fnd_profile.value_specific('IEX_CUST_ACCESS', -1, -1, -1, -1, -1) WORK_QUEUE_ACCESS,
324: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
325: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE

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

318: p_checklist_item_id IN NUMBER,
319: x_return_status OUT NOCOPY VARCHAR2) IS
320: CURSOR c_general_info IS
321: SELECT fnd_profile.value_specific('IEX_COLLECTIONS_BUCKET_NAME', -1, -1, -1, -1, -1) COLLECTIONS_BUCKET,
322: fnd_profile.value_specific('IEX_ENABLE_CUST_STATUS_EVENT', -1, -1, -1, -1, -1) CUST_STATUS_EVENT,
323: fnd_profile.value_specific('IEX_CUST_ACCESS', -1, -1, -1, -1, -1) WORK_QUEUE_ACCESS,
324: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
325: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
326: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,

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

319: x_return_status OUT NOCOPY VARCHAR2) IS
320: CURSOR c_general_info IS
321: SELECT fnd_profile.value_specific('IEX_COLLECTIONS_BUCKET_NAME', -1, -1, -1, -1, -1) COLLECTIONS_BUCKET,
322: fnd_profile.value_specific('IEX_ENABLE_CUST_STATUS_EVENT', -1, -1, -1, -1, -1) CUST_STATUS_EVENT,
323: fnd_profile.value_specific('IEX_CUST_ACCESS', -1, -1, -1, -1, -1) WORK_QUEUE_ACCESS,
324: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
325: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
326: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
327: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,

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

320: CURSOR c_general_info IS
321: SELECT fnd_profile.value_specific('IEX_COLLECTIONS_BUCKET_NAME', -1, -1, -1, -1, -1) COLLECTIONS_BUCKET,
322: fnd_profile.value_specific('IEX_ENABLE_CUST_STATUS_EVENT', -1, -1, -1, -1, -1) CUST_STATUS_EVENT,
323: fnd_profile.value_specific('IEX_CUST_ACCESS', -1, -1, -1, -1, -1) WORK_QUEUE_ACCESS,
324: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
325: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
326: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
327: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
328: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,

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

321: SELECT fnd_profile.value_specific('IEX_COLLECTIONS_BUCKET_NAME', -1, -1, -1, -1, -1) COLLECTIONS_BUCKET,
322: fnd_profile.value_specific('IEX_ENABLE_CUST_STATUS_EVENT', -1, -1, -1, -1, -1) CUST_STATUS_EVENT,
323: fnd_profile.value_specific('IEX_CUST_ACCESS', -1, -1, -1, -1, -1) WORK_QUEUE_ACCESS,
324: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
325: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
326: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
327: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
328: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
329: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,

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

322: fnd_profile.value_specific('IEX_ENABLE_CUST_STATUS_EVENT', -1, -1, -1, -1, -1) CUST_STATUS_EVENT,
323: fnd_profile.value_specific('IEX_CUST_ACCESS', -1, -1, -1, -1, -1) WORK_QUEUE_ACCESS,
324: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
325: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
326: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
327: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
328: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
329: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
330: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,

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

323: fnd_profile.value_specific('IEX_CUST_ACCESS', -1, -1, -1, -1, -1) WORK_QUEUE_ACCESS,
324: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
325: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
326: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
327: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
328: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
329: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
330: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
331: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,

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

324: fnd_profile.value_specific('IEX_ACCESS_LEVEL', -1, -1, -1, -1, -1) ACCESS_LEVEL,
325: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
326: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
327: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
328: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
329: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
330: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
331: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,
332: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,

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

325: fnd_profile.value_specific('IEX_COLLECTIONS_RATE_TYPE', -1, -1, -1, -1, -1) RATE_TYPE
326: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
327: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
328: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
329: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
330: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
331: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,
332: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,
333: -- fnd_profile.value_specific('IEX_CREDIT_HOLD', -1, -1, -1, -1, -1) credit_hold,

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

326: -- fnd_profile.value_specific('ACCOUNT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) ACCOUNT_ACTIVITY,
327: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
328: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
329: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
330: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
331: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,
332: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,
333: -- fnd_profile.value_specific('IEX_CREDIT_HOLD', -1, -1, -1, -1, -1) credit_hold,
334: -- fnd_profile.value_specific('IEX_SERVICE_HOLD', -1, -1, -1, -1, -1) service_hold_delin

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

327: -- fnd_profile.value_specific('IEX_DELINQUENCY_ACTIVITY', -1, -1, -1, -1, -1) DELINQUENCY_ACTIVITY,
328: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
329: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
330: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
331: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,
332: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,
333: -- fnd_profile.value_specific('IEX_CREDIT_HOLD', -1, -1, -1, -1, -1) credit_hold,
334: -- fnd_profile.value_specific('IEX_SERVICE_HOLD', -1, -1, -1, -1, -1) service_hold_delin
335: FROM dual;

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

328: -- fnd_profile.value_specific('DISPUTE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) DISPUTE_ACTIVITY,
329: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
330: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
331: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,
332: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,
333: -- fnd_profile.value_specific('IEX_CREDIT_HOLD', -1, -1, -1, -1, -1) credit_hold,
334: -- fnd_profile.value_specific('IEX_SERVICE_HOLD', -1, -1, -1, -1, -1) service_hold_delin
335: FROM dual;
336:

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

329: -- fnd_profile.value_specific('IEX_ADJUSTMENT_ACTIVITY', -1, -1, -1, -1, -1) ADJUSTMENT_ACTIVITY,
330: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
331: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,
332: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,
333: -- fnd_profile.value_specific('IEX_CREDIT_HOLD', -1, -1, -1, -1, -1) credit_hold,
334: -- fnd_profile.value_specific('IEX_SERVICE_HOLD', -1, -1, -1, -1, -1) service_hold_delin
335: FROM dual;
336:
337: l_general_info_row c_general_info%ROWTYPE;

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

330: -- fnd_profile.value_specific('PAYMENT_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PAYMENT_ACTIVITY,
331: -- fnd_profile.value_specific('PROMISE_INTERACTION_ACTIVITY', -1, -1, -1, -1, -1) PROMISE_ACTIVITY,
332: -- fnd_profile.value_specific('IEX_STRATEGY_ACTIVITY', -1, -1, -1, -1, -1) STRATEGY_ACTIVITY,
333: -- fnd_profile.value_specific('IEX_CREDIT_HOLD', -1, -1, -1, -1, -1) credit_hold,
334: -- fnd_profile.value_specific('IEX_SERVICE_HOLD', -1, -1, -1, -1, -1) service_hold_delin
335: FROM dual;
336:
337: l_general_info_row c_general_info%ROWTYPE;
338: l_status VARCHAR2(30);

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

799:
800: -- End for bug 8708271 pnaveenk
801: -- Begin fix bug #5142565-JYPARK-Change site level profile too
802: IF l_business_level = 'CUSTOMER' THEN
803: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',
804: x_value => 'Y',
805: x_level_name => 'SITE',
806: x_level_value => null,
807: x_level_value_app_id => '',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1018: x_level_value => null,
1019: x_level_value_app_id => '',
1020: x_level_value2 => null);
1021: ELSIF l_business_level = 'DELINQUENCY' THEN
1022: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',
1023: x_value => 'N',
1024: x_level_name => 'SITE',
1025: x_level_value => null,
1026: x_level_value_app_id => '',

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

1024: x_level_name => 'SITE',
1025: x_level_value => null,
1026: x_level_value_app_id => '',
1027: x_level_value2 => null);
1028: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',
1029: x_value => 'N',
1030: x_level_name => 'SITE',
1031: x_level_value => null,
1032: x_level_value_app_id => '',

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

1030: x_level_name => 'SITE',
1031: x_level_value => null,
1032: x_level_value_app_id => '',
1033: x_level_value2 => null);
1034: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',
1035: x_value => 'N',
1036: x_level_name => 'SITE',
1037: x_level_value => null,
1038: x_level_value_app_id => '',

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

1036: x_level_name => 'SITE',
1037: x_level_value => null,
1038: x_level_value_app_id => '',
1039: x_level_value2 => null);
1040: l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',
1041: x_value => 'Y',
1042: x_level_name => 'SITE',
1043: x_level_value => null,
1044: x_level_value_app_id => '',

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

1042: x_level_name => 'SITE',
1043: x_level_value => null,
1044: x_level_value_app_id => '',
1045: x_level_value2 => null);
1046: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',
1047: x_value => 'N',
1048: x_level_name => 'SITE',
1049: x_level_value => null,
1050: x_level_value_app_id => '',

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

1048: x_level_name => 'SITE',
1049: x_level_value => null,
1050: x_level_value_app_id => '',
1051: x_level_value2 => null);
1052: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',
1053: x_value => 'N',
1054: x_level_name => 'SITE',
1055: x_level_value => null,
1056: x_level_value_app_id => '',

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

1054: x_level_name => 'SITE',
1055: x_level_value => null,
1056: x_level_value_app_id => '',
1057: x_level_value2 => null);
1058: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',
1059: x_value => 'N',
1060: x_level_name => 'SITE',
1061: x_level_value => null,
1062: x_level_value_app_id => '',

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

1060: x_level_name => 'SITE',
1061: x_level_value => null,
1062: x_level_value_app_id => '',
1063: x_level_value2 => null);
1064: l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',
1065: x_value => l_promise_enabled,
1066: x_level_name => 'SITE',
1067: x_level_value => null,
1068: x_level_value_app_id => '',

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

1066: x_level_name => 'SITE',
1067: x_level_value => null,
1068: x_level_value_app_id => '',
1069: x_level_value2 => null);
1070: l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',
1071: x_value => 'N',
1072: x_level_name => 'SITE',
1073: x_level_value => null,
1074: x_level_value_app_id => '',

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

1072: x_level_name => 'SITE',
1073: x_level_value => null,
1074: x_level_value_app_id => '',
1075: x_level_value2 => null);
1076: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',
1077: x_value => 'N',
1078: x_level_name => 'SITE',
1079: x_level_value => null,
1080: x_level_value_app_id => '',

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

1078: x_level_name => 'SITE',
1079: x_level_value => null,
1080: x_level_value_app_id => '',
1081: x_level_value2 => null);
1082: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',
1083: x_value => 'N',
1084: x_level_name => 'SITE',
1085: x_level_value => null,
1086: x_level_value_app_id => '',

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

1084: x_level_name => 'SITE',
1085: x_level_value => null,
1086: x_level_value_app_id => '',
1087: x_level_value2 => null);
1088: l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',
1089: x_value => l_Strategy_enabled,
1090: x_level_name => 'SITE',
1091: x_level_value => null,
1092: x_level_value_app_id => '',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1316: -- x_level_value => r_resp.responsibility_id,
1317: -- x_level_value_app_id => '695',
1318: -- x_level_value2 => null);
1319: -- ELSIF l_business_level = 'DELINQUENCY' THEN
1320: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_DELINQUENCIES',
1321: -- x_value => 'N',
1322: -- x_level_name => 'RESP',
1323: -- x_level_value => r_resp.responsibility_id,
1324: -- x_level_value_app_id => '695',

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

1322: -- x_level_name => 'RESP',
1323: -- x_level_value => r_resp.responsibility_id,
1324: -- x_level_value_app_id => '695',
1325: -- x_level_value2 => null);
1326: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',
1327: -- x_value => 'N',
1328: -- x_level_name => 'RESP',
1329: -- x_level_value => r_resp.responsibility_id,
1330: -- x_level_value_app_id => '695',

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

1328: -- x_level_name => 'RESP',
1329: -- x_level_value => r_resp.responsibility_id,
1330: -- x_level_value_app_id => '695',
1331: -- x_level_value2 => null);
1332: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',
1333: -- x_value => 'N',
1334: -- x_level_name => 'RESP',
1335: -- x_level_value => r_resp.responsibility_id,
1336: -- x_level_value_app_id => '695',

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

1334: -- x_level_name => 'RESP',
1335: -- x_level_value => r_resp.responsibility_id,
1336: -- x_level_value_app_id => '695',
1337: -- x_level_value2 => null);
1338: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',
1339: -- x_value => 'Y',
1340: -- x_level_name => 'RESP',
1341: -- x_level_value => r_resp.responsibility_id,
1342: -- x_level_value_app_id => '695',

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

1340: -- x_level_name => 'RESP',
1341: -- x_level_value => r_resp.responsibility_id,
1342: -- x_level_value_app_id => '695',
1343: -- x_level_value2 => null);
1344: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_PROMISES',
1345: -- x_value => 'N',
1346: -- x_level_name => 'RESP',
1347: -- x_level_value => r_resp.responsibility_id,
1348: -- x_level_value_app_id => '695',

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

1346: -- x_level_name => 'RESP',
1347: -- x_level_value => r_resp.responsibility_id,
1348: -- x_level_value_app_id => '695',
1349: -- x_level_value2 => null);
1350: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_PROMISES',
1351: -- x_value => 'N',
1352: -- x_level_name => 'RESP',
1353: -- x_level_value => r_resp.responsibility_id,
1354: -- x_level_value_app_id => '695',

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

1352: -- x_level_name => 'RESP',
1353: -- x_level_value => r_resp.responsibility_id,
1354: -- x_level_value_app_id => '695',
1355: -- x_level_value2 => null);
1356: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_PROMISES',
1357: -- x_value => 'N',
1358: -- x_level_name => 'RESP',
1359: -- x_level_value => r_resp.responsibility_id,
1360: -- x_level_value_app_id => '695',

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

1358: -- x_level_name => 'RESP',
1359: -- x_level_value => r_resp.responsibility_id,
1360: -- x_level_value_app_id => '695',
1361: -- x_level_value2 => null);
1362: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_PROMISES',
1363: -- x_value => l_promise_enabled,
1364: -- x_level_name => 'RESP',
1365: -- x_level_value => r_resp.responsibility_id,
1366: -- x_level_value_app_id => '695',

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

1364: -- x_level_name => 'RESP',
1365: -- x_level_value => r_resp.responsibility_id,
1366: -- x_level_value_app_id => '695',
1367: -- x_level_value2 => null);
1368: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_CUST_STRATEGIES',
1369: -- x_value => 'N',
1370: -- x_level_name => 'RESP',
1371: -- x_level_value => r_resp.responsibility_id,
1372: -- x_level_value_app_id => '695',

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

1370: -- x_level_name => 'RESP',
1371: -- x_level_value => r_resp.responsibility_id,
1372: -- x_level_value_app_id => '695',
1373: -- x_level_value2 => null);
1374: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_STRATEGIES',
1375: -- x_value => 'N',
1376: -- x_level_name => 'RESP',
1377: -- x_level_value => r_resp.responsibility_id,
1378: -- x_level_value_app_id => '695',

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

1376: -- x_level_name => 'RESP',
1377: -- x_level_value => r_resp.responsibility_id,
1378: -- x_level_value_app_id => '695',
1379: -- x_level_value2 => null);
1380: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_STRATEGIES',
1381: -- x_value => 'N',
1382: -- x_level_name => 'RESP',
1383: -- x_level_value => r_resp.responsibility_id,
1384: -- x_level_value_app_id => '695',

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

1382: -- x_level_name => 'RESP',
1383: -- x_level_value => r_resp.responsibility_id,
1384: -- x_level_value_app_id => '695',
1385: -- x_level_value2 => null);
1386: -- l_return := fnd_profile.save(x_name => 'IEX_QEN_STRATEGY',
1387: -- x_value => l_Strategy_enabled,
1388: -- x_level_name => 'RESP',
1389: -- x_level_value => r_resp.responsibility_id,
1390: -- x_level_value_app_id => '695',

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

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',
1471: x_level_name => 'SITE',
1472: x_level_value => null,
1473: x_level_value_app_id => '',

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

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',
1481: x_level_value => null,
1482: x_level_value_app_id => '',

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

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',
1490: x_level_value => null,
1491: x_level_value_app_id => '',

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

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',
1499: x_level_name => 'SITE',
1500: x_level_value => null,
1501: x_level_value_app_id => '',

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

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',
1509: x_level_value => null,
1510: x_level_value_app_id => '',

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

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',
1518: x_level_value => null,
1519: x_level_value_app_id => '',

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

1524:
1525: END IF;
1526:
1527: IF p_account_level = 'Y' then
1528: l_return := fnd_profile.save(x_name => 'IEX_QEN_ACC_DELINQUENCIES',
1529: x_value => 'Y',
1530: x_level_name => 'SITE',
1531: x_level_value => null,
1532: x_level_value_app_id => '',

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

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',
1540: x_level_value => null,
1541: x_level_value_app_id => '',

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

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',
1549: x_level_value => null,
1550: x_level_value_app_id => '',

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

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',
1558: x_value => 'N',
1559: x_level_name => 'SITE',
1560: x_level_value => null,
1561: x_level_value_app_id => '',

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

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',
1569: x_level_value => null,
1570: x_level_value_app_id => '',

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

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',
1578: x_level_value => null,
1579: x_level_value_app_id => '',

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

1583: END IF;
1584: END IF;
1585:
1586: IF p_billto_level = 'Y' then
1587: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',
1588: x_value => 'Y',
1589: x_level_name => 'SITE',
1590: x_level_value => null,
1591: x_level_value_app_id => '',

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

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',
1599: x_level_value => null,
1600: x_level_value_app_id => '',

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

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',
1608: x_level_value => null,
1609: x_level_value_app_id => '',

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

1613: END IF;
1614:
1615: ELSE
1616:
1617: l_return := fnd_profile.save(x_name => 'IEX_QEN_BILLTO_DELINQUENCIES',
1618: x_value => 'N',
1619: x_level_name => 'SITE',
1620: x_level_value => null,
1621: x_level_value_app_id => '',

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

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',
1629: x_level_value => null,
1630: x_level_value_app_id => '',

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

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',
1638: x_level_value => null,
1639: x_level_value_app_id => '',

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

1644:
1645: END IF;
1646:
1647: IF p_delinquency_level = 'Y' then
1648: l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',
1649: x_value => 'Y',
1650: x_level_name => 'SITE',
1651: x_level_value => null,
1652: x_level_value_app_id => '',

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

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',
1660: x_level_value => null,
1661: x_level_value_app_id => '',

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

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',
1669: x_level_value => null,
1670: x_level_value_app_id => '',

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

1674: END IF;
1675:
1676: ELSE
1677:
1678: l_return := fnd_profile.save(x_name => 'IEX_QEN_DELINQUENCIES',
1679: x_value => 'N',
1680: x_level_name => 'SITE',
1681: x_level_value => null,
1682: x_level_value_app_id => '',

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

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',
1690: x_level_value => null,
1691: x_level_value_app_id => '',

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

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',
1699: x_level_value => null,
1700: x_level_value_app_id => '',

Line 1709: l_return := fnd_profile.save(x_name => 'IEX_PROC_STR_ORG',

1705:
1706: END IF;
1707:
1708: IF p_ou_running_level = 'Y' then
1709: l_return := fnd_profile.save(x_name => 'IEX_PROC_STR_ORG',
1710: x_value => 'Y',
1711: x_level_name => 'SITE',
1712: x_level_value => null,
1713: x_level_value_app_id => '',

Line 1720: l_return := fnd_profile.save(x_name => 'IEX_PROC_STR_ORG',

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',
1721: x_value => 'N',
1722: x_level_name => 'SITE',
1723: x_level_value => null,
1724: x_level_value_app_id => '',

Line 1762: l_last_update_login number := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),0);

1758: c_str_upd varchar2(2000);
1759: l_count number;
1760:
1761: l_last_updated_by number := FND_GLOBAL.USER_ID;
1762: l_last_update_login number := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),0);
1763:
1764:
1765: Begin
1766:

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

1872:
1873: -- End for bug 8708271 multi level strategy
1874:
1875: BEGIN
1876: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
1877: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
1878: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
1879: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
1880: G_USER_ID := FND_GLOBAL.User_Id;