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_PUB dependencies on FND_PROFILE

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

75: l_config_key csi_utility_grp.config_instance_key;
76: l_config_valid_status VARCHAR2(10);
77: l_return_message VARCHAR2(100);
78: -- Begin Add Code for Siebel Genesis Project
79: l_raise_bes_event VARCHAR2(1) := nvl(fnd_profile.value('CSI_RAISE_BES_CUST_OWNED_INSTANCES'),'N');
80: l_link_to_line_id NUMBER;
81: l_item_type_code VARCHAR2(30);
82: l_create_event_called VARCHAR2(1) := 'N'; --Added for bug 7156553, base bug 6996605
83: -- End Add Code for Siebel Genesis Project

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

166: -- Initialize API return status to success
167: x_return_status := FND_API.G_RET_STS_SUCCESS;
168:
169: -- Check the profile option debug_level for debug message reporting
170: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
171:
172: -- If debug_level = 1 then dump the procedure name
173: IF (l_debug_level > 0) THEN
174: csi_gen_utility_pvt.put_line( 'create_item_instance');

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

670: -- If version label is null, then we need read the the default value from the profile option
671:
672: IF ((p_instance_rec.version_label IS NULL) OR
673: (p_instance_rec.version_label = FND_API.G_MISS_CHAR)) THEN
674: l_version_label := FND_PROFILE.VALUE('CSI_DEFAULT_VERSION_LABEL');
675: IF l_version_label IS NULL THEN
676: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VERSION_LABEL');
677: FND_MSG_PUB.ADD;
678: RAISE FND_API.G_EXC_ERROR;

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

1310: l_tmp_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1311: l_bump_date DATE;
1312: -- Begin Add Code for Siebel Genesis Project
1313: l_source_code VARCHAR2(30);
1314: l_raise_bes_event VARCHAR2(1) := nvl(fnd_profile.value('CSI_RAISE_BES_CUST_OWNED_INSTANCES'),'N');
1315: l_link_to_line_Id NUMBER;
1316: l_item_type_code VARCHAR2(30);
1317: l_root_asset_id NUMBER;
1318: l_subject_id NUMBER;

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

1462: -- Initialize API return status to success
1463: x_return_status := FND_API.G_RET_STS_SUCCESS;
1464:
1465: -- Check the profile option debug_level for debug message reporting
1466: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1467:
1468: -- If debug_level = 1 then dump the procedure name
1469: IF (l_debug_level > 0) THEN
1470: csi_gen_utility_pvt.put_line( 'update_item_instance');

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

3597: -- Initialize API return status to success
3598: x_return_status := FND_API.G_RET_STS_SUCCESS;
3599:
3600: -- Check the profile option debug_level for debug message reporting
3601: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3602:
3603: -- If debug_level = 1 then dump the procedure name
3604: IF (l_debug_level > 0) THEN
3605: csi_gen_utility_pvt.put_line( 'expire_item_instance');

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

4188: -- Initialize API return status to success
4189: x_return_status := FND_API.G_RET_STS_SUCCESS;
4190:
4191: -- Check the profile option debug_level for debug message reporting
4192: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4193:
4194: -- If debug_level = 1 then dump the procedure name
4195: IF (l_debug_level > 0) THEN
4196: csi_gen_utility_pvt.put_line( 'get_item_instances');

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

4521: -- Initialize API return status to success
4522: x_return_status := FND_API.G_RET_STS_SUCCESS;
4523:
4524: -- Check the profile option debug_level for debug message reporting
4525: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4526:
4527: -- If debug_level = 1 then dump the procedure name
4528: IF (l_debug_level > 0) THEN
4529: csi_gen_utility_pvt.put_line( 'get_item_instance_details');

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

4976: -- Initialize API return status to success
4977: x_return_status := FND_API.G_RET_STS_SUCCESS;
4978:
4979: -- Check the profile option debug_level for debug message reporting
4980: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4981:
4982: -- If debug_level = 1 then dump the procedure name
4983: IF (l_debug_level > 0) THEN
4984: csi_gen_utility_pvt.put_line( 'get_version_label');

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

5160: -- Initialize API return status to success
5161: x_return_status := FND_API.G_RET_STS_SUCCESS;
5162:
5163: -- Check the profile option debug_level for debug message reporting
5164: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5165:
5166: -- If debug_level = 1 then dump the procedure name
5167: IF (l_debug_level > 0) THEN
5168: csi_gen_utility_pvt.put_line( 'create_version_label');

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

5331: -- Initialize API return status to success
5332: x_return_status := FND_API.G_RET_STS_SUCCESS;
5333:
5334: -- Check the profile option debug_level for debug message reporting
5335: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5336:
5337: -- If debug_level = 1 then dump the procedure name
5338: IF (l_debug_level > 0) THEN
5339: csi_gen_utility_pvt.put_line( 'update_version_label');

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

5401: END IF;
5402:
5403: /***** srramakr commented for bug # 3304439
5404: -- Check for the profile option and disable the trace
5405: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
5406: dbms_session.set_sql_trace(false);
5407: END IF;
5408: -- End disable trace
5409: ****/

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

5498: -- Initialize API return status to success
5499: x_return_status := FND_API.G_RET_STS_SUCCESS;
5500:
5501: -- Check the profile option debug_level for debug message reporting
5502: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5503:
5504: -- If debug_level = 1 then dump the procedure name
5505: IF (l_debug_level > 0) THEN
5506: csi_gen_utility_pvt.put_line( 'expire_version_label');

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

5563: END IF;
5564:
5565: /***** srramakr commented for bug # 3304439
5566: -- Check for the profile option and disable the trace
5567: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
5568: dbms_session.set_sql_trace(false);
5569: END IF;
5570: -- End disable trace
5571: ****/

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

5817: x_return_status := FND_API.G_RET_STS_SUCCESS;
5818:
5819:
5820: -- Check the profile option debug_level for debug message reporting
5821: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5822:
5823: -- If debug_level = 1 then dump the procedure name
5824: IF (l_debug_level > 0) THEN
5825: csi_gen_utility_pvt.put_line( 'get_extended_attrib_values');

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

6098:
6099:
6100: -- Check the profile option debug_level for debug message reporting
6101:
6102: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6103:
6104: -- If debug_level = 1 then dump the procedure name
6105: IF (l_debug_level > 0) THEN
6106: csi_gen_utility_pvt.put_line( 'create_extended_attrib_values');

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

6178: END IF;
6179:
6180: /***** srramakr commented for bug # 3304439
6181: -- Check for the profile option and disable the trace
6182: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
6183: dbms_session.set_sql_trace(false);
6184: END IF;
6185: -- End disable trace
6186: ****/

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

6294: x_return_status := FND_API.G_RET_STS_SUCCESS;
6295:
6296:
6297: -- Check the profile option debug_level for debug message reporting
6298: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6299:
6300: -- If debug_level = 1 then dump the procedure name
6301: IF (l_debug_level > 0) THEN
6302: csi_gen_utility_pvt.put_line( 'update_extended_attrib_values');

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

6483:
6484:
6485: -- Check the profile option debug_level for debug message reporting
6486:
6487: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6488:
6489: -- If debug_level = 1 then dump the procedure name
6490: IF (l_debug_level > 0) THEN
6491: csi_gen_utility_pvt.put_line( 'delete_extended_attrib_values');

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

6680: -- Initialize API return status to success
6681: x_return_status := FND_API.G_RET_STS_SUCCESS;
6682:
6683: -- Check the profile option debug_level for debug message reporting
6684: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6685:
6686: -- If debug_level = 1 then dump the procedure name
6687: IF (l_debug_level > 0) THEN
6688: csi_gen_utility_pvt.put_line('copy_item_instance ');