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.CSI_DIAGNOSTICS_PKG dependencies on FND_PROFILE

Line 204: fnd_profile.put('CSI_DEBUG_LEVEL',0);

200:
201: --
202: PROCEDURE debug_off IS
203: BEGIN
204: fnd_profile.put('CSI_DEBUG_LEVEL',0);
205: fnd_profile.put('CSE_DEBUG_OPTION','N');
206: fnd_profile.put('OKS_DEBUG','N');
207: csi_t_gen_utility_pvt.g_debug_level := 0;
208: END debug_off;

Line 205: fnd_profile.put('CSE_DEBUG_OPTION','N');

201: --
202: PROCEDURE debug_off IS
203: BEGIN
204: fnd_profile.put('CSI_DEBUG_LEVEL',0);
205: fnd_profile.put('CSE_DEBUG_OPTION','N');
206: fnd_profile.put('OKS_DEBUG','N');
207: csi_t_gen_utility_pvt.g_debug_level := 0;
208: END debug_off;
209:

Line 206: fnd_profile.put('OKS_DEBUG','N');

202: PROCEDURE debug_off IS
203: BEGIN
204: fnd_profile.put('CSI_DEBUG_LEVEL',0);
205: fnd_profile.put('CSE_DEBUG_OPTION','N');
206: fnd_profile.put('OKS_DEBUG','N');
207: csi_t_gen_utility_pvt.g_debug_level := 0;
208: END debug_off;
209:
210: --

Line 3315: SELECT fnd_Profile.value('csi_upgrading_from_release')

3311: skip_message exception;
3312:
3313: BEGIN
3314:
3315: SELECT fnd_Profile.value('csi_upgrading_from_release')
3316: INTO l_release
3317: FROM sys.dual;
3318:
3319: decode_queue;

Line 3430: SELECT fnd_Profile.value('CSI_UPGRADING_FROM_RELEASE')

3426: BEGIN
3427:
3428: l_missing_tbl.delete;
3429:
3430: SELECT fnd_Profile.value('CSI_UPGRADING_FROM_RELEASE')
3431: INTO l_release
3432: FROM sys.dual;
3433: --
3434: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

Line 3565: SELECT fnd_Profile.value('csi_upgrading_from_release')

3561:
3562:
3563: l_missing_tbl.delete;
3564:
3565: SELECT fnd_Profile.value('csi_upgrading_from_release')
3566: INTO l_release
3567: FROM sys.dual;
3568:
3569: FOR all_txn_rec in all_txn_cur(

Line 4057: SELECT fnd_Profile.value('csi_upgrading_from_release')

4053: truncate_table(l_object_name);
4054:
4055: log(date_time_stamp||' begin get_srldata');
4056:
4057: SELECT fnd_Profile.value('csi_upgrading_from_release')
4058: INTO l_release
4059: FROM sys.dual;
4060: --
4061: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

Line 8914: SELECT fnd_Profile.value('csi_upgrading_from_release')

8910: BEGIN
8911:
8912: decode_queue;
8913:
8914: SELECT fnd_Profile.value('csi_upgrading_from_release')
8915: INTO l_release
8916: FROM sys.dual;
8917: --
8918: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

Line 9495: v_batch NUMBER := nvl(FND_PROFILE.VALUE('CS_UPG_BATCHSIZE'),100);

9491: v_min NUMBER;
9492: v_max NUMBER;
9493: v_low NUMBER;
9494: v_high NUMBER;
9495: v_batch NUMBER := nvl(FND_PROFILE.VALUE('CS_UPG_BATCHSIZE'),100);
9496: v_start NUMBER;
9497: v_end NUMBER;
9498: v_diff NUMBER;
9499: v_batch_counter NUMBER := 0;

Line 10340: v_status := nvl(FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS'), 'Latest');

10336: end if;
10337: --
10338: -- Added a check for the case of status id being null. shegde
10339: if v_status_id is NULL then
10340: v_status := nvl(FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS'), 'Latest');
10341: select instance_status_id
10342: into v_status_id
10343: from CSI_INSTANCE_STATUSES
10344: where name = v_status;

Line 11519: l_contracts_status := FND_PROFILE.VALUE('CSI_CONTRACTS_ENABLED');

11515: IF CSI_CUR%ISOPEN THEN
11516: CLOSE CSI_CUR;
11517: END IF;
11518: -- Call Expire_Item_Instance wraper to Expire Contracts
11519: l_contracts_status := FND_PROFILE.VALUE('CSI_CONTRACTS_ENABLED');
11520: IF UPPER(l_contracts_status) = 'Y' THEN
11521: UPDATE CSI_TRANSACTIONS
11522: set contracts_invoked = 'Y'
11523: where transaction_id = v_txn_id;

Line 12184: l_upg_profile VARCHAR2(30) := fnd_Profile.value('CSI_UPGRADING_FROM_RELEASE');

12180: from mtl_transaction_lot_numbers
12181: where transaction_id = p_txn_id;
12182: --
12183: v_txn_id NUMBER;
12184: l_upg_profile VARCHAR2(30) := fnd_Profile.value('CSI_UPGRADING_FROM_RELEASE');
12185: v_freeze_date DATE;
12186: v_txn_type_id NUMBER;
12187: v_nl_trackable VARCHAR2(1);
12188: v_mast_org_id NUMBER;

Line 13606: l_upg_profile VARCHAR2(30) := fnd_Profile.value('CSI_UPGRADING_FROM_RELEASE');

13602: --
13603: v_txn_id NUMBER;
13604: v_freeze_date DATE;
13605: v_txn_type_id NUMBER;
13606: l_upg_profile VARCHAR2(30) := fnd_Profile.value('CSI_UPGRADING_FROM_RELEASE');
13607: v_mast_org_id NUMBER;
13608: v_nl_trackable VARCHAR2(1);
13609: v_location_id NUMBER;
13610: v_ins_condition_id NUMBER;

Line 15678: SELECT fnd_Profile.value('csi_upgrading_from_release')

15674:
15675:
15676: BEGIN
15677:
15678: SELECT fnd_Profile.value('csi_upgrading_from_release')
15679: INTO l_release
15680: FROM sys.dual;
15681:
15682: FOR err_rec IN err_cur

Line 16750: l_auto_populate_allowed := FND_PROFILE.VALUE('CSI_AUTO_POPULATE_INSTANCE'); --bug 5248037--

16746:
16747: log(date_time_stamp||'create_or_update_shipping_inst');
16748: csi_diagnostics_pkg.create_or_update_shipping_inst;
16749:
16750: l_auto_populate_allowed := FND_PROFILE.VALUE('CSI_AUTO_POPULATE_INSTANCE'); --bug 5248037--
16751: log('Auto population allowed '||l_auto_populate_allowed);
16752:
16753: --Added IF condition for bug 5248037--
16754: IF UPPER(l_auto_populate_allowed) = 'Y' THEN