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_GIS_INSTANCE_LOC_UTL_PKG dependencies on CSI_T_GEN_UTILITY_PVT

Line 50: csi_t_gen_utility_pvt.add( 'In Validate Instance Number');

46: l_debug_level NUMBER;
47:
48: BEGIN
49: l_debug_level:=to_number(fnd_profile.value('CSI_DEBUG_LEVEL'));
50: csi_t_gen_utility_pvt.add( 'In Validate Instance Number');
51: x_return_status := FND_API.G_RET_STS_SUCCESS;
52:
53: /* check if the Instance exists */
54: BEGIN

Line 63: csi_t_gen_utility_pvt.add( 'Instance exists in csi_item_instances');

59: WHERE INSTANCE_ID = p_instance_id;
60:
61:
62: IF l_debug_level > 0 THEN
63: csi_t_gen_utility_pvt.add( 'Instance exists in csi_item_instances');
64: csi_t_gen_utility_pvt.add( 'Inventory Item Id:'||l_inventory_item_id);
65: csi_t_gen_utility_pvt.add( 'Organization Id:'||l_organization_id);
66: csi_t_gen_utility_pvt.add( 'Serial Number:'||l_serial_number);
67: csi_t_gen_utility_pvt.add( 'Instance Number:'||l_instance_number);

Line 64: csi_t_gen_utility_pvt.add( 'Inventory Item Id:'||l_inventory_item_id);

60:
61:
62: IF l_debug_level > 0 THEN
63: csi_t_gen_utility_pvt.add( 'Instance exists in csi_item_instances');
64: csi_t_gen_utility_pvt.add( 'Inventory Item Id:'||l_inventory_item_id);
65: csi_t_gen_utility_pvt.add( 'Organization Id:'||l_organization_id);
66: csi_t_gen_utility_pvt.add( 'Serial Number:'||l_serial_number);
67: csi_t_gen_utility_pvt.add( 'Instance Number:'||l_instance_number);
68: END IF;

Line 65: csi_t_gen_utility_pvt.add( 'Organization Id:'||l_organization_id);

61:
62: IF l_debug_level > 0 THEN
63: csi_t_gen_utility_pvt.add( 'Instance exists in csi_item_instances');
64: csi_t_gen_utility_pvt.add( 'Inventory Item Id:'||l_inventory_item_id);
65: csi_t_gen_utility_pvt.add( 'Organization Id:'||l_organization_id);
66: csi_t_gen_utility_pvt.add( 'Serial Number:'||l_serial_number);
67: csi_t_gen_utility_pvt.add( 'Instance Number:'||l_instance_number);
68: END IF;
69:

Line 66: csi_t_gen_utility_pvt.add( 'Serial Number:'||l_serial_number);

62: IF l_debug_level > 0 THEN
63: csi_t_gen_utility_pvt.add( 'Instance exists in csi_item_instances');
64: csi_t_gen_utility_pvt.add( 'Inventory Item Id:'||l_inventory_item_id);
65: csi_t_gen_utility_pvt.add( 'Organization Id:'||l_organization_id);
66: csi_t_gen_utility_pvt.add( 'Serial Number:'||l_serial_number);
67: csi_t_gen_utility_pvt.add( 'Instance Number:'||l_instance_number);
68: END IF;
69:
70: SELECT Nvl((SELECT 'EAM'

Line 67: csi_t_gen_utility_pvt.add( 'Instance Number:'||l_instance_number);

63: csi_t_gen_utility_pvt.add( 'Instance exists in csi_item_instances');
64: csi_t_gen_utility_pvt.add( 'Inventory Item Id:'||l_inventory_item_id);
65: csi_t_gen_utility_pvt.add( 'Organization Id:'||l_organization_id);
66: csi_t_gen_utility_pvt.add( 'Serial Number:'||l_serial_number);
67: csi_t_gen_utility_pvt.add( 'Instance Number:'||l_instance_number);
68: END IF;
69:
70: SELECT Nvl((SELECT 'EAM'
71: From MFG_LOOKUPS ml1, MTL_SYSTEM_ITEMS_B_KFV msi,csi_item_instances cii

Line 85: csi_t_gen_utility_pvt.add( 'Instance Type:'||l_instance_type);

81: ),'CSE' )
82: INTO l_instance_type
83: FROM DUAL;
84:
85: csi_t_gen_utility_pvt.add( 'Instance Type:'||l_instance_type);
86:
87: EXCEPTION WHEN NO_DATA_FOUND THEN
88: csi_t_gen_utility_pvt.add( 'Instance does not exist in csi_item_instances');
89: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_NOT_FOUND');

Line 88: csi_t_gen_utility_pvt.add( 'Instance does not exist in csi_item_instances');

84:
85: csi_t_gen_utility_pvt.add( 'Instance Type:'||l_instance_type);
86:
87: EXCEPTION WHEN NO_DATA_FOUND THEN
88: csi_t_gen_utility_pvt.add( 'Instance does not exist in csi_item_instances');
89: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_NOT_FOUND');
90: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
91: FND_MSG_PUB.ADD;
92: x_return_status := FND_API.G_RET_STS_ERROR;

Line 100: csi_t_gen_utility_pvt.add( 'Validating EAM Asset');

96:
97:
98: /*If the asset is EAM asset validate it */
99: IF l_instance_type = 'EAM' THEN
100: csi_t_gen_utility_pvt.add( 'Validating EAM Asset');
101: SELECT EAM_ITEM_TYPE,SERIAL_NUMBER_CONTROL_CODE
102: INTO l_csi_item_type,l_serial_number_control_code
103: FROM MTL_SYSTEM_ITEMS_B_KFV
104: WHERE INVENTORY_ITEM_ID = l_inventory_item_id

Line 172: csi_t_gen_utility_pvt.add( 'Converting latitude or longitude value to DD format');

168: l_direction VARCHAR2(1);
169: l_sign VARCHAR2(1);
170:
171: BEGIN
172: csi_t_gen_utility_pvt.add( 'Converting latitude or longitude value to DD format');
173:
174: l_value := UPPER(TRIM(p_value));
175: l_length := LENGTH(l_value);
176:

Line 293: csi_t_gen_utility_pvt.add( 'Calculating DD value');

289: l_s_pos NUMBER:=0;
290: l_value VARCHAR2(100);
291: Invalid_Decimal Exception;
292: BEGIN
293: csi_t_gen_utility_pvt.add( 'Calculating DD value');
294: l_value := Trim(Upper(p_value));
295:
296: l_d_pos := INSTR(l_value,'D');
297: l_m_pos := INSTR(l_value,'M');

Line 500: csi_t_gen_utility_pvt.add( 'In Validate latitude/longitude');

496: l_error_count NUMBER:=0;
497:
498:
499: BEGIN
500: csi_t_gen_utility_pvt.add( 'In Validate latitude/longitude');
501:
502: l_latitude := UPPER(TRIM(p_latitude));
503: l_latitude_length := LENGTH(l_latitude);
504: l_longitude := UPPER(TRIM(p_longitude));