[Home] [Help]
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;
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:
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: --
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;
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
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(
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
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
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;
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;
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;
12175: from mtl_transaction_lot_numbers
12176: where transaction_id = p_txn_id;
12177: --
12178: v_txn_id NUMBER;
12179: l_upg_profile VARCHAR2(30) := fnd_Profile.value('CSI_UPGRADING_FROM_RELEASE');
12180: v_freeze_date DATE;
12181: v_txn_type_id NUMBER;
12182: v_nl_trackable VARCHAR2(1);
12183: v_mast_org_id NUMBER;
13597: --
13598: v_txn_id NUMBER;
13599: v_freeze_date DATE;
13600: v_txn_type_id NUMBER;
13601: l_upg_profile VARCHAR2(30) := fnd_Profile.value('CSI_UPGRADING_FROM_RELEASE');
13602: v_mast_org_id NUMBER;
13603: v_nl_trackable VARCHAR2(1);
13604: v_location_id NUMBER;
13605: v_ins_condition_id NUMBER;
15663:
15664:
15665: BEGIN
15666:
15667: SELECT fnd_Profile.value('csi_upgrading_from_release')
15668: INTO l_release
15669: FROM sys.dual;
15670:
15671: FOR err_rec IN err_cur
16735:
16736: log(date_time_stamp||'create_or_update_shipping_inst');
16737: csi_diagnostics_pkg.create_or_update_shipping_inst;
16738:
16739: l_auto_populate_allowed := FND_PROFILE.VALUE('CSI_AUTO_POPULATE_INSTANCE'); --bug 5248037--
16740: log('Auto population allowed '||l_auto_populate_allowed);
16741:
16742: --Added IF condition for bug 5248037--
16743: IF UPPER(l_auto_populate_allowed) = 'Y' THEN