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: -- End Add Code for Siebel Genesis Project
83: -- end addition

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

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

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

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

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

1292: l_tmp_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1293: l_bump_date DATE;
1294: -- Begin Add Code for Siebel Genesis Project
1295: l_source_code VARCHAR2(30);
1296: l_raise_bes_event VARCHAR2(1) := nvl(fnd_profile.value('CSI_RAISE_BES_CUST_OWNED_INSTANCES'),'N');
1297: l_link_to_line_Id NUMBER;
1298: l_item_type_code VARCHAR2(30);
1299: l_root_asset_id NUMBER;
1300: l_subject_id NUMBER;

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

1441: -- Initialize API return status to success
1442: x_return_status := FND_API.G_RET_STS_SUCCESS;
1443:
1444: -- Check the profile option debug_level for debug message reporting
1445: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1446:
1447: -- If debug_level = 1 then dump the procedure name
1448: IF (l_debug_level > 0) THEN
1449: csi_gen_utility_pvt.put_line( 'update_item_instance');

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

3560: -- Initialize API return status to success
3561: x_return_status := FND_API.G_RET_STS_SUCCESS;
3562:
3563: -- Check the profile option debug_level for debug message reporting
3564: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
3565:
3566: -- If debug_level = 1 then dump the procedure name
3567: IF (l_debug_level > 0) THEN
3568: csi_gen_utility_pvt.put_line( 'expire_item_instance');

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

4146: -- Initialize API return status to success
4147: x_return_status := FND_API.G_RET_STS_SUCCESS;
4148:
4149: -- Check the profile option debug_level for debug message reporting
4150: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4151:
4152: -- If debug_level = 1 then dump the procedure name
4153: IF (l_debug_level > 0) THEN
4154: csi_gen_utility_pvt.put_line( 'get_item_instances');

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

4475: -- Initialize API return status to success
4476: x_return_status := FND_API.G_RET_STS_SUCCESS;
4477:
4478: -- Check the profile option debug_level for debug message reporting
4479: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4480:
4481: -- If debug_level = 1 then dump the procedure name
4482: IF (l_debug_level > 0) THEN
4483: csi_gen_utility_pvt.put_line( 'get_item_instance_details');

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

4924: -- Initialize API return status to success
4925: x_return_status := FND_API.G_RET_STS_SUCCESS;
4926:
4927: -- Check the profile option debug_level for debug message reporting
4928: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
4929:
4930: -- If debug_level = 1 then dump the procedure name
4931: IF (l_debug_level > 0) THEN
4932: csi_gen_utility_pvt.put_line( 'get_version_label');

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

5104: -- Initialize API return status to success
5105: x_return_status := FND_API.G_RET_STS_SUCCESS;
5106:
5107: -- Check the profile option debug_level for debug message reporting
5108: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5109:
5110: -- If debug_level = 1 then dump the procedure name
5111: IF (l_debug_level > 0) THEN
5112: csi_gen_utility_pvt.put_line( 'create_version_label');

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

5271: -- Initialize API return status to success
5272: x_return_status := FND_API.G_RET_STS_SUCCESS;
5273:
5274: -- Check the profile option debug_level for debug message reporting
5275: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5276:
5277: -- If debug_level = 1 then dump the procedure name
5278: IF (l_debug_level > 0) THEN
5279: csi_gen_utility_pvt.put_line( 'update_version_label');

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

5341: END IF;
5342:
5343: /***** srramakr commented for bug # 3304439
5344: -- Check for the profile option and disable the trace
5345: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
5346: dbms_session.set_sql_trace(false);
5347: END IF;
5348: -- End disable trace
5349: ****/

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

5434: -- Initialize API return status to success
5435: x_return_status := FND_API.G_RET_STS_SUCCESS;
5436:
5437: -- Check the profile option debug_level for debug message reporting
5438: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5439:
5440: -- If debug_level = 1 then dump the procedure name
5441: IF (l_debug_level > 0) THEN
5442: csi_gen_utility_pvt.put_line( 'expire_version_label');

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

5499: END IF;
5500:
5501: /***** srramakr commented for bug # 3304439
5502: -- Check for the profile option and disable the trace
5503: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
5504: dbms_session.set_sql_trace(false);
5505: END IF;
5506: -- End disable trace
5507: ****/

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

5749: x_return_status := FND_API.G_RET_STS_SUCCESS;
5750:
5751:
5752: -- Check the profile option debug_level for debug message reporting
5753: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
5754:
5755: -- If debug_level = 1 then dump the procedure name
5756: IF (l_debug_level > 0) THEN
5757: csi_gen_utility_pvt.put_line( 'get_extended_attrib_values');

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

6026:
6027:
6028: -- Check the profile option debug_level for debug message reporting
6029:
6030: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6031:
6032: -- If debug_level = 1 then dump the procedure name
6033: IF (l_debug_level > 0) THEN
6034: csi_gen_utility_pvt.put_line( 'create_extended_attrib_values');

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

6106: END IF;
6107:
6108: /***** srramakr commented for bug # 3304439
6109: -- Check for the profile option and disable the trace
6110: IF (fnd_profile.value('CSI_ENABLE_SQL_TRACE') = 'Y') THEN
6111: dbms_session.set_sql_trace(false);
6112: END IF;
6113: -- End disable trace
6114: ****/

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

6218: x_return_status := FND_API.G_RET_STS_SUCCESS;
6219:
6220:
6221: -- Check the profile option debug_level for debug message reporting
6222: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6223:
6224: -- If debug_level = 1 then dump the procedure name
6225: IF (l_debug_level > 0) THEN
6226: csi_gen_utility_pvt.put_line( 'update_extended_attrib_values');

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

6403:
6404:
6405: -- Check the profile option debug_level for debug message reporting
6406:
6407: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6408:
6409: -- If debug_level = 1 then dump the procedure name
6410: IF (l_debug_level > 0) THEN
6411: csi_gen_utility_pvt.put_line( 'delete_extended_attrib_values');

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

6596: -- Initialize API return status to success
6597: x_return_status := FND_API.G_RET_STS_SUCCESS;
6598:
6599: -- Check the profile option debug_level for debug message reporting
6600: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
6601:
6602: -- If debug_level = 1 then dump the procedure name
6603: IF (l_debug_level > 0) THEN
6604: csi_gen_utility_pvt.put_line('copy_item_instance ');