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 4018: l_flag := nvl(FND_PROFILE.VALUE('CSI_CONTRACTS_ENABLED'), 'N');

4014: --sk added
4015: IF (( p_instance_query_rec.contract_number IS NOT NULL) AND
4016: ( p_instance_query_rec.contract_number <> FND_API.G_MISS_CHAR)) THEN
4017: BEGIN
4018: l_flag := nvl(FND_PROFILE.VALUE('CSI_CONTRACTS_ENABLED'), 'N');
4019: l_inp_rec.contract_number := p_instance_query_rec.contract_number;
4020: l_inp_rec.party_id := NULL;
4021: l_inp_rec.site_id := NULL;
4022: l_inp_rec.cust_acct_id := NULL;

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

4586: l_uom_code VARCHAR2(3);
4587: l_rev_control NUMBER;
4588: l_exists_flag VARCHAR2(1);
4589: l_valid_flag VARCHAR2(1);
4590: l_call_counters VARCHAR2(1) := FND_PROFILE.VALUE('CSI_COUNTERS_ENABLED');
4591: l_config_key csi_utility_grp.config_instance_key;
4592: l_config_valid_status VARCHAR2(10);
4593: l_return_message VARCHAR2(100);
4594: l_component_ins_type VARCHAR2(1):=NULL ;

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

4637: -- Initialize API return status to success
4638: x_return_status := FND_API.G_RET_STS_SUCCESS;
4639:
4640: -- Check the profile option debug_level for debug message reporting
4641: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4642: -- If debug_level = 1 then dump the procedure name
4643: IF (l_debug_level > 0) THEN
4644: csi_gen_utility_pvt.put_line ('create_item_instance_pvt');
4645: END IF;

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

5490: l_valid_flag := 'Y';
5491: l_exists_flag := 'N';
5492: IF ((p_instance_rec.instance_status_id IS NULL) OR
5493: (p_instance_rec.instance_status_id = FND_API.G_MISS_NUM)) THEN
5494: l_instance_status := FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
5495: BEGIN
5496: SELECT instance_status_id,terminated_flag
5497: INTO p_instance_rec.instance_status_id
5498: ,l_terminated_flag

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

6851: -- Initialize API return status to success
6852: x_return_status := FND_API.G_RET_STS_SUCCESS;
6853:
6854: -- Check the profile option debug_level for debug message reporting
6855: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6856: -- If debug_level = 1 then dump the procedure name
6857: IF (l_debug_level > 0) THEN
6858: csi_gen_utility_pvt.put_line ('get_and_update_acct_class');
6859: END IF;

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

7426: -- Initialize API return status to success
7427: x_return_status := FND_API.G_RET_STS_SUCCESS;
7428:
7429: -- Check the profile option debug_level for debug message reporting
7430: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
7431:
7432: -- If debug_level = 1 then dump the procedure name
7433: IF (l_debug_level > 0) THEN
7434: csi_gen_utility_pvt.put_line ( 'update_child_instance_pvt');

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

10825:
10826: -- Initialize API return status to success
10827: x_return_status := FND_API.G_RET_STS_SUCCESS;
10828: --
10829: l_contracts_status := FND_PROFILE.VALUE('CSI_CONTRACTS_ENABLED');
10830: --
10831: IF UPPER(l_contracts_status) <> 'Y' THEN
10832: RETURN;
10833: END IF;

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

11906:
11907: -- Initialize API return status to success
11908: x_return_status := FND_API.G_RET_STS_SUCCESS;
11909: -- Check the profile option debug_level for debug message reporting
11910: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
11911: -- If debug_level = 1 then dump the procedure name
11912: IF (l_debug_level > 0) THEN
11913: csi_gen_utility_pvt.put_line ( 'update_item_instance_pvt');
11914: END IF;

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

14036: --
14037: IF NOT (CSI_Item_Instance_vld_pvt.val_inst_ter_flag(
14038: p_instance_rec.instance_status_id)) THEN
14039: -- Added by sguthiva for bug 2520978
14040: p_instance_rec.instance_status_id:=fnd_profile.value('CSI_SYS_TERM_INST_STATUS_ID');
14041: IF p_instance_rec.instance_status_id IS NULL
14042: OR p_instance_rec.instance_status_id=fnd_api.g_miss_num
14043: THEN
14044: p_instance_rec.instance_status_id := 1;

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

19015: -- Initialize API return status to success
19016: x_return_status := FND_API.G_RET_STS_SUCCESS;
19017:
19018: -- Check the profile option debug_level for debug message reporting
19019: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
19020:
19021: -- If debug_level = 1 then dump the procedure name
19022: IF (l_debug_level > 0) THEN
19023: csi_gen_utility_pvt.put_line ( 'expire_child_instance_pvt');

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

19118: RAISE FND_API.G_EXC_ERROR;
19119: END IF;
19120: l_instance_rec.instance_status_id := p_instance_rec.instance_status_id;
19121: ELSE
19122: l_instance_rec.instance_status_id := fnd_profile.value('CSI_SYS_TERM_INST_STATUS_ID');
19123: IF l_instance_rec.instance_status_id IS NULL
19124: OR l_instance_rec.instance_status_id=fnd_api.g_miss_num
19125: THEN
19126: l_instance_rec.instance_status_id := 1;

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

20132: -- Initialize API return status to success
20133: x_return_status := FND_API.G_RET_STS_SUCCESS;
20134:
20135: -- Check the profile option debug_level for debug message reporting
20136: l_debug_level:=fnd_profile.value('DEBUG_LEVEL');
20137:
20138: -- If debug_level = 1 then dump the procedure name
20139: IF (l_debug_level > 0) THEN
20140: csi_gen_utility_pvt.put_line ( 'expire_item_instance_pvt');

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

20299: RAISE FND_API.G_EXC_ERROR;
20300: END IF;
20301: l_instance_rec.instance_status_id := p_instance_rec.instance_status_id;
20302: ELSE
20303: l_instance_rec.instance_status_id := fnd_profile.value('CSI_SYS_TERM_INST_STATUS_ID');
20304: IF l_instance_rec.instance_status_id IS NULL
20305: OR l_instance_rec.instance_status_id=fnd_api.g_miss_num
20306: THEN
20307: l_instance_rec.instance_status_id := 1;

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

21511: -- Initialize API return status to success
21512: x_return_status := FND_API.G_RET_STS_SUCCESS;
21513:
21514: -- Check the profile option debug_level for debug message reporting
21515: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
21516:
21517: -- If debug_level = 1 then dump the procedure name
21518: IF (l_debug_level > 0) THEN
21519: csi_gen_utility_pvt.put_line ( 'split_item_instance_pvt');

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

22010: -- Initialize API return status to success
22011: x_return_status := FND_API.G_RET_STS_SUCCESS;
22012:
22013: -- Check the profile option debug_level for debug message reporting
22014: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
22015:
22016: -- If debug_level = 1 then dump the procedure name
22017: IF (l_debug_level > 0) THEN
22018: csi_gen_utility_pvt.put_line ( 'split_item_instance_lines_pvt');

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

23070: -- Initialize API return status to success
23071: x_return_status := FND_API.G_RET_STS_SUCCESS;
23072:
23073: -- Check the profile option debug_level for debug message reporting
23074: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
23075:
23076: -- If debug_level = 1 then dump the procedure name
23077: IF (l_debug_level > 0) THEN
23078: csi_gen_utility_pvt.put_line ( 'create_version_label');

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

23429: -- Initialize API return status to success
23430: x_return_status := FND_API.G_RET_STS_SUCCESS;
23431:
23432: -- Check the profile option debug_level for debug message reporting
23433: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
23434:
23435: -- If debug_level = 1 then dump the procedure name
23436: IF (l_debug_level > 0) THEN
23437: CSI_gen_utility_pvt.put_line( 'update_version_label');

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

24542: -- Initialize API return status to success
24543: x_return_status := FND_API.G_RET_STS_SUCCESS;
24544:
24545: -- Check the profile option debug_level for debug message reporting
24546: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
24547:
24548: -- If debug_level = 1 then dump the procedure name
24549: IF (l_debug_level > 0) THEN
24550: CSI_gen_utility_pvt.put_line( 'update_version_label');

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

25472: x_return_status := FND_API.G_RET_STS_SUCCESS;
25473:
25474:
25475: -- Check the profile option debug_level for debug message reporting
25476: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
25477:
25478: -- If debug_level = 1 then dump the procedure name
25479: IF (l_debug_level > 0) THEN
25480: csi_gen_utility_pvt.put_line( 'create_extended_attrib_values');

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

26052: x_return_status := FND_API.G_RET_STS_SUCCESS;
26053:
26054:
26055: -- Check the profile option debug_level for debug message reporting
26056: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
26057:
26058: -- If debug_level = 1 then dump the procedure name
26059: IF (l_debug_level > 0) THEN
26060: csi_gen_utility_pvt.put_line( 'update_extended_attrib_values');

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

27127:
27128:
27129: -- Check the profile option debug_level for debug message reporting
27130:
27131: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
27132:
27133: -- If debug_level = 1 then dump the procedure name
27134: IF (l_debug_level > 0) THEN
27135: csi_gen_utility_pvt.put_line( 'expire_extended_attrib_values');

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

27373: END IF;
27374: -- Initialize API return status to success
27375: x_return_status := FND_API.G_RET_STS_SUCCESS;
27376: -- Check the profile option debug_level for debug message reporting
27377: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
27378: -- If debug_level = 1 then dump the procedure name
27379: IF (l_debug_level > 0) THEN
27380: csi_gen_utility_pvt.put_line('copy_single_item_instance ');
27381: END IF;

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

28979: -- Added by rtalluri for Bug: 2420897 on 08/19/02
28980: -- If version label is null, then we need read the the default value from the profile option
28981: IF (p_source_instance_rec.VERSION_LABEL IS NULL ) OR
28982: (p_source_instance_rec.VERSION_LABEL = FND_API.G_MISS_CHAR) THEN
28983: l_version_label := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
28984: IF l_version_label IS NULL THEN
28985: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VERSION_LABEL');
28986: FND_MSG_PUB.ADD;
28987: RAISE FND_API.G_EXC_ERROR;

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

29219: l_parent_child_tbl csi_item_instance_pvt.parent_child_tbl;
29220: l_parent_count NUMBER := 0;
29221: l_per_parent NUMBER := 0;
29222: l_temp_per_parent NUMBER := 0;
29223: l_csi_explode_bom VARCHAR2(30) := fnd_profile.value('CSI_EXPLODE_BOM');
29224: l_csi_bom_explosion_level NUMBER;
29225: l_ins_count NUMBER := 0;
29226: l_curr_parent VARCHAR2(240);
29227: x_ins_tbl csi_datastructures_pub.instance_tbl;

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

29286: END IF;
29287: -- Initialize API return status to success
29288: x_return_status := FND_API.G_RET_STS_SUCCESS;
29289: -- Check the profile option debug_level for debug message reporting
29290: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
29291: -- If debug_level = 1 then dump the procedure name
29292: IF (l_debug_level > 0) THEN
29293: csi_gen_utility_pvt.put_line( 'explode_bom');
29294: END IF;

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

29365: END IF;
29366: --
29367: IF p_explosion_level IS NULL OR
29368: p_explosion_level = FND_API.G_MISS_NUM THEN
29369: l_csi_bom_explosion_level := to_number(fnd_profile.value('CSI_BOM_EXPLOSION_LEVEL'));
29370: ELSE
29371: l_csi_bom_explosion_level := p_explosion_level;
29372: END IF;
29373: --

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

29832: x_return_status := FND_API.G_RET_STS_SUCCESS;
29833:
29834: /***** srramakr commented for bug # 3304439
29835: -- Check for the profile option and enable trace
29836: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
29837: dbms_session.set_sql_trace(TRUE);
29838: END IF;
29839: -- End enable trace
29840: ****/

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

31642: */
31643:
31644: /***** srramakr commented for bug # 3304439
31645: -- Check for the profile option and disable the trace
31646: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
31647: dbms_session.set_sql_trace(false);
31648: END IF;
31649: -- End disable trace
31650: ****/

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

31778: x_return_status := FND_API.G_RET_STS_SUCCESS;
31779:
31780: /***** srramakr commented for bug # 3304439
31781: -- Check for the profile option and enable trace
31782: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
31783: dbms_session.set_sql_trace(TRUE);
31784: END IF;
31785: -- End enable trace
31786: ****/

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

32025: */
32026:
32027: /***** srramakr commented for bug # 3304439
32028: -- Check for the profile option and disable the trace
32029: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
32030: dbms_session.set_sql_trace(false);
32031: END IF;
32032: -- End disable trace
32033: ****/

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

32165: l_batch_type VARCHAR2(50);
32166: l_batch_id NUMBER;
32167: --
32168: -- Begin Add Code for Siebel Genesis Project
32169: l_raise_bes_event VARCHAR2(1) := nvl(fnd_profile.value('CSI_RAISE_BES_CUST_OWNED_INSTANCES'),'N');
32170: l_link_to_line_id NUMBER;
32171: l_item_type_code VARCHAR2(30);
32172: l_owner_party_id NUMBER;
32173: -- End Add Code for Siebel Genesis Project

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

32193: -- Initialize API return status to success
32194: x_return_status := FND_API.G_RET_STS_SUCCESS;
32195:
32196: -- Check the profile option debug_level for debug message reporting
32197: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
32198:
32199: -- If debug_level = 1 then dump the procedure name
32200: IF (l_debug_level > 0) THEN
32201: csi_gen_utility_pvt.put_line('copy_item_instance ');

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

33735: -- Added by rtalluri for Bug: 2420897 on 08/19/02
33736: -- If version label is null, then we need read the the default value from the profile option
33737: IF (p_source_instance_rec.VERSION_LABEL IS NULL ) OR
33738: (p_source_instance_rec.VERSION_LABEL = FND_API.G_MISS_CHAR) THEN
33739: l_version_label := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
33740: IF l_version_label IS NULL THEN
33741: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VERSION_LABEL');
33742: FND_MSG_PUB.ADD;
33743: RAISE FND_API.G_EXC_ERROR;

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

34299: -- Initialize API return status to success
34300: x_return_status := FND_API.G_RET_STS_SUCCESS;
34301:
34302: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
34303: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
34304:
34305: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
34306: IF (l_csi_debug_level > 0) THEN
34307: csi_gen_utility_pvt.put_line( 'get_version_label_history');

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

34482: -- Initialize API return status to success
34483: x_return_status := FND_API.G_RET_STS_SUCCESS;
34484:
34485: -- Check the profile option debug_level for debug message reporting
34486: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
34487:
34488: -- If debug_level = 1 then dump the procedure name
34489: IF (l_debug_level > 0) THEN
34490: csi_gen_utility_pvt.put_line( 'get_instance_link_locations');

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

34842: -- Initialize API return status to success
34843: x_return_status := FND_API.G_RET_STS_SUCCESS;
34844:
34845: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
34846: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
34847:
34848: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
34849: IF (l_csi_debug_level > 0) THEN
34850: csi_gen_utility_pvt.put_line( 'lock_item_instances');

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

35617: -- Initialize API return status to success
35618: x_return_status := FND_API.G_RET_STS_SUCCESS;
35619:
35620: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
35621: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
35622:
35623: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
35624: IF (l_csi_debug_level > 0) THEN
35625: csi_gen_utility_pvt.put_line( 'unlock_item_instances');