eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ITEM_INSTANCE_PVT dependencies on FND_PROFILE

Line 4037: l_flag := nvl(FND_PROFILE.VALUE('CSI_CONTRACTS_ENABLED'), 'N');

4033: --sk added
4034: IF (( p_instance_query_rec.contract_number IS NOT NULL) AND
4035: ( p_instance_query_rec.contract_number <> FND_API.G_MISS_CHAR)) THEN
4036: BEGIN
4037: l_flag := nvl(FND_PROFILE.VALUE('CSI_CONTRACTS_ENABLED'), 'N');
4038: l_inp_rec.contract_number := p_instance_query_rec.contract_number;
4039: l_inp_rec.party_id := NULL;
4040: l_inp_rec.site_id := NULL;
4041: l_inp_rec.cust_acct_id := NULL;

Line 4610: l_call_counters VARCHAR2(1) := FND_PROFILE.VALUE('CSI_COUNTERS_ENABLED');

4606: l_uom_code VARCHAR2(3);
4607: l_rev_control NUMBER;
4608: l_exists_flag VARCHAR2(1);
4609: l_valid_flag VARCHAR2(1);
4610: l_call_counters VARCHAR2(1) := FND_PROFILE.VALUE('CSI_COUNTERS_ENABLED');
4611: l_config_key csi_utility_grp.config_instance_key;
4612: l_config_valid_status VARCHAR2(10);
4613: l_return_message VARCHAR2(100);
4614: l_component_ins_type VARCHAR2(1):=NULL ;

Line 4672: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

4668: -- Initialize API return status to success
4669: x_return_status := FND_API.G_RET_STS_SUCCESS;
4670:
4671: -- Check the profile option debug_level for debug message reporting
4672: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4673: -- If debug_level = 1 then dump the procedure name
4674: IF (l_debug_level > 0) THEN
4675: csi_gen_utility_pvt.put_line ('create_item_instance_pvt');
4676: END IF;

Line 5558: l_instance_status := FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');

5554: l_valid_flag := 'Y';
5555: l_exists_flag := 'N';
5556: IF ((p_instance_rec.instance_status_id IS NULL) OR
5557: (p_instance_rec.instance_status_id = FND_API.G_MISS_NUM)) THEN
5558: l_instance_status := FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
5559: BEGIN
5560: SELECT instance_status_id,terminated_flag
5561: INTO p_instance_rec.instance_status_id
5562: ,l_terminated_flag

Line 6932: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

6928: -- Initialize API return status to success
6929: x_return_status := FND_API.G_RET_STS_SUCCESS;
6930:
6931: -- Check the profile option debug_level for debug message reporting
6932: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6933: -- If debug_level = 1 then dump the procedure name
6934: IF (l_debug_level > 0) THEN
6935: csi_gen_utility_pvt.put_line ('get_and_update_acct_class');
6936: END IF;

Line 7122: l_raise_bes_event VARCHAR2(1) := nvl(fnd_profile.value('CSI_RAISE_BES_CUST_OWNED_INSTANCES'),'N');

7118: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
7119: --End of:Added for bug 5615169
7120:
7121: --Added for bug 7708851, base bug 7239642
7122: l_raise_bes_event VARCHAR2(1) := nvl(fnd_profile.value('CSI_RAISE_BES_CUST_OWNED_INSTANCES'),'N');
7123: l_create_event_called VARCHAR2(1) := 'N';
7124:
7125: CURSOR curr_instance_rec(p_instance_id IN NUMBER) IS
7126: SELECT

Line 7516: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

7512: -- Initialize API return status to success
7513: x_return_status := FND_API.G_RET_STS_SUCCESS;
7514:
7515: -- Check the profile option debug_level for debug message reporting
7516: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
7517:
7518: -- If debug_level = 1 then dump the procedure name
7519: IF (l_debug_level > 0) THEN
7520: csi_gen_utility_pvt.put_line ( 'update_child_instance_pvt');

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

11078:
11079: -- Initialize API return status to success
11080: x_return_status := FND_API.G_RET_STS_SUCCESS;
11081: --
11082: l_contracts_status := FND_PROFILE.VALUE('CSI_CONTRACTS_ENABLED');
11083: --
11084: IF UPPER(l_contracts_status) <> 'Y' THEN
11085: RETURN;
11086: END IF;

Line 12228: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

12224:
12225: -- Initialize API return status to success
12226: x_return_status := FND_API.G_RET_STS_SUCCESS;
12227: -- Check the profile option debug_level for debug message reporting
12228: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
12229: -- If debug_level = 1 then dump the procedure name
12230: IF (l_debug_level > 0) THEN
12231: csi_gen_utility_pvt.put_line ( 'update_item_instance_pvt');
12232: END IF;

Line 14432: p_instance_rec.instance_status_id:=fnd_profile.value('CSI_SYS_TERM_INST_STATUS_ID');

14428: --
14429: IF NOT (CSI_Item_Instance_vld_pvt.val_inst_ter_flag(
14430: p_instance_rec.instance_status_id)) THEN
14431: -- Added by sguthiva for bug 2520978
14432: p_instance_rec.instance_status_id:=fnd_profile.value('CSI_SYS_TERM_INST_STATUS_ID');
14433: IF p_instance_rec.instance_status_id IS NULL
14434: OR p_instance_rec.instance_status_id=fnd_api.g_miss_num
14435: THEN
14436: p_instance_rec.instance_status_id := 1;

Line 14537: l_allow_earlier_installdt_flag := fnd_profile.value('CSI_INSTALLDT_EARLIER_THAN_SHIPDT');

14533: -- Bug 13887020
14534: -- Validation for Install Date will be done based on value of profile
14535: -- CSI: Allow Install Dates To Be Earlier Than Ship Dates
14536:
14537: l_allow_earlier_installdt_flag := fnd_profile.value('CSI_INSTALLDT_EARLIER_THAN_SHIPDT');
14538:
14539: IF NVL(l_allow_earlier_installdt_flag, 'N') = 'N' THEN
14540: --Validation of Install date added for Bug 8892299
14541: IF NVL(p_instance_rec.INSTALL_DATE,fnd_api.g_miss_date) <> fnd_api.g_miss_date THEN

Line 19516: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

19512: -- Initialize API return status to success
19513: x_return_status := FND_API.G_RET_STS_SUCCESS;
19514:
19515: -- Check the profile option debug_level for debug message reporting
19516: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
19517:
19518: -- If debug_level = 1 then dump the procedure name
19519: IF (l_debug_level > 0) THEN
19520: csi_gen_utility_pvt.put_line ( 'expire_child_instance_pvt');

Line 19619: l_instance_rec.instance_status_id := fnd_profile.value('CSI_SYS_TERM_INST_STATUS_ID');

19615: RAISE FND_API.G_EXC_ERROR;
19616: END IF;
19617: l_instance_rec.instance_status_id := p_instance_rec.instance_status_id;
19618: ELSE
19619: l_instance_rec.instance_status_id := fnd_profile.value('CSI_SYS_TERM_INST_STATUS_ID');
19620: IF l_instance_rec.instance_status_id IS NULL
19621: OR l_instance_rec.instance_status_id=fnd_api.g_miss_num
19622: THEN
19623: l_instance_rec.instance_status_id := 1;

Line 20640: l_debug_level:=fnd_profile.value('DEBUG_LEVEL');

20636: -- Initialize API return status to success
20637: x_return_status := FND_API.G_RET_STS_SUCCESS;
20638:
20639: -- Check the profile option debug_level for debug message reporting
20640: l_debug_level:=fnd_profile.value('DEBUG_LEVEL');
20641:
20642: -- If debug_level = 1 then dump the procedure name
20643: IF (l_debug_level > 0) THEN
20644: csi_gen_utility_pvt.put_line ( 'expire_item_instance_pvt');

Line 20837: l_instance_rec.instance_status_id := fnd_profile.value('CSI_SYS_TERM_INST_STATUS_ID');

20833: RAISE FND_API.G_EXC_ERROR;
20834: END IF;
20835: l_instance_rec.instance_status_id := p_instance_rec.instance_status_id;
20836: ELSE
20837: l_instance_rec.instance_status_id := fnd_profile.value('CSI_SYS_TERM_INST_STATUS_ID');
20838: IF l_instance_rec.instance_status_id IS NULL
20839: OR l_instance_rec.instance_status_id=fnd_api.g_miss_num
20840: THEN
20841: l_instance_rec.instance_status_id := 1;

Line 22056: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

22052: -- Initialize API return status to success
22053: x_return_status := FND_API.G_RET_STS_SUCCESS;
22054:
22055: -- Check the profile option debug_level for debug message reporting
22056: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
22057:
22058: -- If debug_level = 1 then dump the procedure name
22059: IF (l_debug_level > 0) THEN
22060: csi_gen_utility_pvt.put_line ( 'split_item_instance_pvt');

Line 22559: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

22555: -- Initialize API return status to success
22556: x_return_status := FND_API.G_RET_STS_SUCCESS;
22557:
22558: -- Check the profile option debug_level for debug message reporting
22559: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
22560:
22561: -- If debug_level = 1 then dump the procedure name
22562: IF (l_debug_level > 0) THEN
22563: csi_gen_utility_pvt.put_line ( 'split_item_instance_lines_pvt');

Line 23627: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

23623: -- Initialize API return status to success
23624: x_return_status := FND_API.G_RET_STS_SUCCESS;
23625:
23626: -- Check the profile option debug_level for debug message reporting
23627: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
23628:
23629: -- If debug_level = 1 then dump the procedure name
23630: IF (l_debug_level > 0) THEN
23631: csi_gen_utility_pvt.put_line ( 'create_version_label');

Line 23990: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

23986: -- Initialize API return status to success
23987: x_return_status := FND_API.G_RET_STS_SUCCESS;
23988:
23989: -- Check the profile option debug_level for debug message reporting
23990: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
23991:
23992: -- If debug_level = 1 then dump the procedure name
23993: IF (l_debug_level > 0) THEN
23994: CSI_gen_utility_pvt.put_line( 'update_version_label');

Line 25107: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

25103: -- Initialize API return status to success
25104: x_return_status := FND_API.G_RET_STS_SUCCESS;
25105:
25106: -- Check the profile option debug_level for debug message reporting
25107: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
25108:
25109: -- If debug_level = 1 then dump the procedure name
25110: IF (l_debug_level > 0) THEN
25111: CSI_gen_utility_pvt.put_line( 'update_version_label');

Line 26041: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

26037: x_return_status := FND_API.G_RET_STS_SUCCESS;
26038:
26039:
26040: -- Check the profile option debug_level for debug message reporting
26041: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
26042:
26043: -- If debug_level = 1 then dump the procedure name
26044: IF (l_debug_level > 0) THEN
26045: csi_gen_utility_pvt.put_line( 'create_extended_attrib_values');

Line 26625: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

26621: x_return_status := FND_API.G_RET_STS_SUCCESS;
26622:
26623:
26624: -- Check the profile option debug_level for debug message reporting
26625: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
26626:
26627: -- If debug_level = 1 then dump the procedure name
26628: IF (l_debug_level > 0) THEN
26629: csi_gen_utility_pvt.put_line( 'update_extended_attrib_values');

Line 27704: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

27700:
27701:
27702: -- Check the profile option debug_level for debug message reporting
27703:
27704: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
27705:
27706: -- If debug_level = 1 then dump the procedure name
27707: IF (l_debug_level > 0) THEN
27708: csi_gen_utility_pvt.put_line( 'expire_extended_attrib_values');

Line 27954: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

27950: END IF;
27951: -- Initialize API return status to success
27952: x_return_status := FND_API.G_RET_STS_SUCCESS;
27953: -- Check the profile option debug_level for debug message reporting
27954: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
27955: -- If debug_level = 1 then dump the procedure name
27956: IF (l_debug_level > 0) THEN
27957: csi_gen_utility_pvt.put_line('copy_single_item_instance ');
27958: END IF;

Line 29560: l_version_label := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');

29556: -- Added by rtalluri for Bug: 2420897 on 08/19/02
29557: -- If version label is null, then we need read the the default value from the profile option
29558: IF (p_source_instance_rec.VERSION_LABEL IS NULL ) OR
29559: (p_source_instance_rec.VERSION_LABEL = FND_API.G_MISS_CHAR) THEN
29560: l_version_label := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
29561: IF l_version_label IS NULL THEN
29562: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VERSION_LABEL');
29563: FND_MSG_PUB.ADD;
29564: RAISE FND_API.G_EXC_ERROR;

Line 29804: l_csi_explode_bom VARCHAR2(30) := fnd_profile.value('CSI_EXPLODE_BOM');

29800: l_parent_child_tbl csi_item_instance_pvt.parent_child_tbl;
29801: l_parent_count NUMBER := 0;
29802: l_per_parent NUMBER := 0;
29803: l_temp_per_parent NUMBER := 0;
29804: l_csi_explode_bom VARCHAR2(30) := fnd_profile.value('CSI_EXPLODE_BOM');
29805: l_csi_bom_explosion_level NUMBER;
29806: l_ins_count NUMBER := 0;
29807: l_curr_parent VARCHAR2(240);
29808: x_ins_tbl csi_datastructures_pub.instance_tbl;

Line 29872: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

29868: END IF;
29869: -- Initialize API return status to success
29870: x_return_status := FND_API.G_RET_STS_SUCCESS;
29871: -- Check the profile option debug_level for debug message reporting
29872: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
29873: -- If debug_level = 1 then dump the procedure name
29874: IF (l_debug_level > 0) THEN
29875: csi_gen_utility_pvt.put_line( 'explode_bom');
29876: END IF;

Line 29895: l_bom_expl_org_flag := nvl(FND_PROFILE.VALUE('CSI_BOM_EXPLOSION_ORG'), 'N');

29891: -- If Y => Shipping/Warehouse Org will be used for BOM child component
29892: -- validation and creation
29893: -- If N => Item validation Org will be used for BOM child component
29894: -- validation and creation
29895: l_bom_expl_org_flag := nvl(FND_PROFILE.VALUE('CSI_BOM_EXPLOSION_ORG'), 'N');
29896: csi_gen_utility_pvt.put_line('l_bom_expl_org_flag - ' || l_bom_expl_org_flag);
29897:
29898: IF l_csi_explode_bom = 'Y' THEN
29899: -- Verify if the a Valid item and Org id is being passed

Line 29960: l_csi_bom_explosion_level := to_number(fnd_profile.value('CSI_BOM_EXPLOSION_LEVEL'));

29956: END IF;
29957: --
29958: IF p_explosion_level IS NULL OR
29959: p_explosion_level = FND_API.G_MISS_NUM THEN
29960: l_csi_bom_explosion_level := to_number(fnd_profile.value('CSI_BOM_EXPLOSION_LEVEL'));
29961: ELSE
29962: l_csi_bom_explosion_level := p_explosion_level;
29963: END IF;
29964: --

Line 30438: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

30434: x_return_status := FND_API.G_RET_STS_SUCCESS;
30435:
30436: /***** srramakr commented for bug # 3304439
30437: -- Check for the profile option and enable trace
30438: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
30439: dbms_session.set_sql_trace(TRUE);
30440: END IF;
30441: -- End enable trace
30442: ****/

Line 32262: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

32258: */
32259:
32260: /***** srramakr commented for bug # 3304439
32261: -- Check for the profile option and disable the trace
32262: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
32263: dbms_session.set_sql_trace(false);
32264: END IF;
32265: -- End disable trace
32266: ****/

Line 32400: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

32396: x_return_status := FND_API.G_RET_STS_SUCCESS;
32397:
32398: /***** srramakr commented for bug # 3304439
32399: -- Check for the profile option and enable trace
32400: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
32401: dbms_session.set_sql_trace(TRUE);
32402: END IF;
32403: -- End enable trace
32404: ****/

Line 32647: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN

32643: */
32644:
32645: /***** srramakr commented for bug # 3304439
32646: -- Check for the profile option and disable the trace
32647: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
32648: dbms_session.set_sql_trace(false);
32649: END IF;
32650: -- End disable trace
32651: ****/

Line 32789: l_raise_bes_event VARCHAR2(1) := nvl(fnd_profile.value('CSI_RAISE_BES_CUST_OWNED_INSTANCES'),'N');

32785: l_batch_type VARCHAR2(50);
32786: l_batch_id NUMBER;
32787: --
32788: -- Begin Add Code for Siebel Genesis Project
32789: l_raise_bes_event VARCHAR2(1) := nvl(fnd_profile.value('CSI_RAISE_BES_CUST_OWNED_INSTANCES'),'N');
32790: l_link_to_line_id NUMBER;
32791: l_item_type_code VARCHAR2(30);
32792: l_owner_party_id NUMBER;
32793: -- End Add Code for Siebel Genesis Project

Line 32818: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

32814: -- Initialize API return status to success
32815: x_return_status := FND_API.G_RET_STS_SUCCESS;
32816:
32817: -- Check the profile option debug_level for debug message reporting
32818: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
32819:
32820: -- If debug_level = 1 then dump the procedure name
32821: IF (l_debug_level > 0) THEN
32822: csi_gen_utility_pvt.put_line('copy_item_instance ');

Line 34367: l_version_label := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');

34363: -- Added by rtalluri for Bug: 2420897 on 08/19/02
34364: -- If version label is null, then we need read the the default value from the profile option
34365: IF (p_source_instance_rec.VERSION_LABEL IS NULL ) OR
34366: (p_source_instance_rec.VERSION_LABEL = FND_API.G_MISS_CHAR) THEN
34367: l_version_label := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
34368: IF l_version_label IS NULL THEN
34369: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VERSION_LABEL');
34370: FND_MSG_PUB.ADD;
34371: RAISE FND_API.G_EXC_ERROR;

Line 34950: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

34946: -- Initialize API return status to success
34947: x_return_status := FND_API.G_RET_STS_SUCCESS;
34948:
34949: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
34950: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
34951:
34952: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
34953: IF (l_csi_debug_level > 0) THEN
34954: csi_gen_utility_pvt.put_line( 'get_version_label_history');

Line 35137: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

35133: -- Initialize API return status to success
35134: x_return_status := FND_API.G_RET_STS_SUCCESS;
35135:
35136: -- Check the profile option debug_level for debug message reporting
35137: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
35138:
35139: -- If debug_level = 1 then dump the procedure name
35140: IF (l_debug_level > 0) THEN
35141: csi_gen_utility_pvt.put_line( 'get_instance_link_locations');

Line 35503: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

35499: -- Initialize API return status to success
35500: x_return_status := FND_API.G_RET_STS_SUCCESS;
35501:
35502: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
35503: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
35504:
35505: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
35506: IF (l_csi_debug_level > 0) THEN
35507: csi_gen_utility_pvt.put_line( 'lock_item_instances');

Line 36282: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');

36278: -- Initialize API return status to success
36279: x_return_status := FND_API.G_RET_STS_SUCCESS;
36280:
36281: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
36282: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
36283:
36284: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
36285: IF (l_csi_debug_level > 0) THEN
36286: csi_gen_utility_pvt.put_line( 'unlock_item_instances');