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

Line 74: csi_t_gen_utility_pvt.build_file_name( p_file_segment1 => 'csi_gis',

70: -- Check the profile option debug_level for debug message reporting
71: l_debug_level:=to_number(fnd_profile.value('CSI_DEBUG_LEVEL'));
72:
73:
74: csi_t_gen_utility_pvt.build_file_name( p_file_segment1 => 'csi_gis',
75: p_file_segment2 => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
76:
77: csi_t_gen_utility_pvt.add('In createupdate_inst_geoloc_info');
78: l_instance_tbl('init'):='Y';

Line 77: csi_t_gen_utility_pvt.add('In createupdate_inst_geoloc_info');

73:
74: csi_t_gen_utility_pvt.build_file_name( p_file_segment1 => 'csi_gis',
75: p_file_segment2 => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
76:
77: csi_t_gen_utility_pvt.add('In createupdate_inst_geoloc_info');
78: l_instance_tbl('init'):='Y';
79:
80: IF p_csi_instance_geoloc_tbl.COUNT > 0 THEN
81:

Line 85: csi_t_gen_utility_pvt.add( 'Processing Record : '||i);

81:
82: FOR i in p_csi_instance_geoloc_tbl.FIRST..p_csi_instance_geoloc_tbl.LAST LOOP
83:
84: BEGIN
85: csi_t_gen_utility_pvt.add( 'Processing Record : '||i);
86: IF l_debug_level > 0 THEN
87: csi_t_gen_utility_pvt.add( 'Instance Id:'||p_csi_instance_geoloc_tbl(i).instance_id);
88: csi_t_gen_utility_pvt.add( 'Latitude:'||p_csi_instance_geoloc_tbl(i).inst_latitude);
89: csi_t_gen_utility_pvt.add( 'Longitude:'||p_csi_instance_geoloc_tbl(i).inst_longitude);

Line 87: csi_t_gen_utility_pvt.add( 'Instance Id:'||p_csi_instance_geoloc_tbl(i).instance_id);

83:
84: BEGIN
85: csi_t_gen_utility_pvt.add( 'Processing Record : '||i);
86: IF l_debug_level > 0 THEN
87: csi_t_gen_utility_pvt.add( 'Instance Id:'||p_csi_instance_geoloc_tbl(i).instance_id);
88: csi_t_gen_utility_pvt.add( 'Latitude:'||p_csi_instance_geoloc_tbl(i).inst_latitude);
89: csi_t_gen_utility_pvt.add( 'Longitude:'||p_csi_instance_geoloc_tbl(i).inst_longitude);
90: csi_t_gen_utility_pvt.add( 'Geocode Format:'||p_csi_instance_geoloc_tbl(i).geocode_format);
91: csi_t_gen_utility_pvt.add( 'Valid Flag:'||p_csi_instance_geoloc_tbl(i).Valid_flag);

Line 88: csi_t_gen_utility_pvt.add( 'Latitude:'||p_csi_instance_geoloc_tbl(i).inst_latitude);

84: BEGIN
85: csi_t_gen_utility_pvt.add( 'Processing Record : '||i);
86: IF l_debug_level > 0 THEN
87: csi_t_gen_utility_pvt.add( 'Instance Id:'||p_csi_instance_geoloc_tbl(i).instance_id);
88: csi_t_gen_utility_pvt.add( 'Latitude:'||p_csi_instance_geoloc_tbl(i).inst_latitude);
89: csi_t_gen_utility_pvt.add( 'Longitude:'||p_csi_instance_geoloc_tbl(i).inst_longitude);
90: csi_t_gen_utility_pvt.add( 'Geocode Format:'||p_csi_instance_geoloc_tbl(i).geocode_format);
91: csi_t_gen_utility_pvt.add( 'Valid Flag:'||p_csi_instance_geoloc_tbl(i).Valid_flag);
92: END IF;

Line 89: csi_t_gen_utility_pvt.add( 'Longitude:'||p_csi_instance_geoloc_tbl(i).inst_longitude);

85: csi_t_gen_utility_pvt.add( 'Processing Record : '||i);
86: IF l_debug_level > 0 THEN
87: csi_t_gen_utility_pvt.add( 'Instance Id:'||p_csi_instance_geoloc_tbl(i).instance_id);
88: csi_t_gen_utility_pvt.add( 'Latitude:'||p_csi_instance_geoloc_tbl(i).inst_latitude);
89: csi_t_gen_utility_pvt.add( 'Longitude:'||p_csi_instance_geoloc_tbl(i).inst_longitude);
90: csi_t_gen_utility_pvt.add( 'Geocode Format:'||p_csi_instance_geoloc_tbl(i).geocode_format);
91: csi_t_gen_utility_pvt.add( 'Valid Flag:'||p_csi_instance_geoloc_tbl(i).Valid_flag);
92: END IF;
93:

Line 90: csi_t_gen_utility_pvt.add( 'Geocode Format:'||p_csi_instance_geoloc_tbl(i).geocode_format);

86: IF l_debug_level > 0 THEN
87: csi_t_gen_utility_pvt.add( 'Instance Id:'||p_csi_instance_geoloc_tbl(i).instance_id);
88: csi_t_gen_utility_pvt.add( 'Latitude:'||p_csi_instance_geoloc_tbl(i).inst_latitude);
89: csi_t_gen_utility_pvt.add( 'Longitude:'||p_csi_instance_geoloc_tbl(i).inst_longitude);
90: csi_t_gen_utility_pvt.add( 'Geocode Format:'||p_csi_instance_geoloc_tbl(i).geocode_format);
91: csi_t_gen_utility_pvt.add( 'Valid Flag:'||p_csi_instance_geoloc_tbl(i).Valid_flag);
92: END IF;
93:
94: csi_t_gen_utility_pvt.add( 'calling validate instance');

Line 91: csi_t_gen_utility_pvt.add( 'Valid Flag:'||p_csi_instance_geoloc_tbl(i).Valid_flag);

87: csi_t_gen_utility_pvt.add( 'Instance Id:'||p_csi_instance_geoloc_tbl(i).instance_id);
88: csi_t_gen_utility_pvt.add( 'Latitude:'||p_csi_instance_geoloc_tbl(i).inst_latitude);
89: csi_t_gen_utility_pvt.add( 'Longitude:'||p_csi_instance_geoloc_tbl(i).inst_longitude);
90: csi_t_gen_utility_pvt.add( 'Geocode Format:'||p_csi_instance_geoloc_tbl(i).geocode_format);
91: csi_t_gen_utility_pvt.add( 'Valid Flag:'||p_csi_instance_geoloc_tbl(i).Valid_flag);
92: END IF;
93:
94: csi_t_gen_utility_pvt.add( 'calling validate instance');
95:

Line 94: csi_t_gen_utility_pvt.add( 'calling validate instance');

90: csi_t_gen_utility_pvt.add( 'Geocode Format:'||p_csi_instance_geoloc_tbl(i).geocode_format);
91: csi_t_gen_utility_pvt.add( 'Valid Flag:'||p_csi_instance_geoloc_tbl(i).Valid_flag);
92: END IF;
93:
94: csi_t_gen_utility_pvt.add( 'calling validate instance');
95:
96: IF p_csi_instance_geoloc_tbl(i).instance_id IS NULL
97: OR p_csi_instance_geoloc_tbl(i).instance_id = FND_API.G_MISS_NUM THEN
98: IF p_asset_context = 'EAM' THEN

Line 125: csi_t_gen_utility_pvt.add( 'Invalidating Instance geo location info');

121: AND TRIM(p_csi_instance_geoloc_tbl(i).inst_longitude) = 'DMS') THEN
122:
123: IF l_create_update = 'U' THEN
124: IF (l_debug_level > 0) THEN
125: csi_t_gen_utility_pvt.add( 'Invalidating Instance geo location info');
126: END IF;
127:
128:
129: CSI_GIS_INSTANCE_GEO_LOC_PVT.UPDATE_ROW

Line 140: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);

136:
137: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
138:
139: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
140: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);
141: IF FND_API.To_Boolean(p_commit) THEN
142: UPDATE csi_ii_geoloc_interface
143: SET process_flag = 'E',
144: error_message=l_msg_data,

Line 176: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);

172: END IF;
173:
174: l_instance_tbl(p_csi_instance_geoloc_tbl(i).instance_id) := 'Y' ;
175:
176: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);
177: IF l_debug_level > 0 THEN
178: csi_t_gen_utility_pvt.add( 'l_create_update:'||l_create_update);
179: csi_t_gen_utility_pvt.add( 'l_instance_number:'||l_instance_number);
180: END IF;

Line 178: csi_t_gen_utility_pvt.add( 'l_create_update:'||l_create_update);

174: l_instance_tbl(p_csi_instance_geoloc_tbl(i).instance_id) := 'Y' ;
175:
176: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);
177: IF l_debug_level > 0 THEN
178: csi_t_gen_utility_pvt.add( 'l_create_update:'||l_create_update);
179: csi_t_gen_utility_pvt.add( 'l_instance_number:'||l_instance_number);
180: END IF;
181:
182: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 179: csi_t_gen_utility_pvt.add( 'l_instance_number:'||l_instance_number);

175:
176: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);
177: IF l_debug_level > 0 THEN
178: csi_t_gen_utility_pvt.add( 'l_create_update:'||l_create_update);
179: csi_t_gen_utility_pvt.add( 'l_instance_number:'||l_instance_number);
180: END IF;
181:
182: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
183:

Line 186: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);

182: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
183:
184: l_error_count:=l_error_count+1;
185: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
186: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);
187: IF FND_API.To_Boolean(p_commit) THEN
188: UPDATE csi_ii_geoloc_interface
189: SET process_flag = 'E',
190: error_message=l_msg_data,

Line 205: csi_t_gen_utility_pvt.add( 'Invalidating Instance geo location info');

201: /*If delete from UI, this invalidates the geolocation information for asset/instance */
202: IF p_CSI_instance_geoloc_tbl(i).valid_flag = 'N' THEN
203:
204: IF (l_debug_level > 0) THEN
205: csi_t_gen_utility_pvt.add( 'Invalidating Instance geo location info');
206: END IF;
207:
208: CSI_GIS_INSTANCE_GEO_LOC_PVT.UPDATE_ROW
209: ( p_instance_id => p_csi_instance_geoloc_tbl(i).instance_id

Line 219: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);

215:
216: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
217:
218: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
219: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);
220: IF FND_API.To_Boolean(p_commit) THEN
221: UPDATE csi_ii_geoloc_interface
222: SET process_flag = 'E',
223: error_message=l_msg_data,

Line 237: csi_t_gen_utility_pvt.add( 'calling validate latitude longitude');

233: END IF;
234: Return;
235: END IF;
236:
237: csi_t_gen_utility_pvt.add( 'calling validate latitude longitude');
238:
239: /*This procedure is called to validate the latitude and longitude values*/
240: CSI_GIS_INSTANCE_LOC_UTL_PKG.VALIDATE_LATITUDE_LONGITUDE
241: (p_latitude => p_csi_instance_geoloc_tbl(i).inst_latitude

Line 250: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);

246: ,x_msg_count => l_msg_count
247: ,x_msg_data => l_msg_data
248: ) ;
249:
250: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);
251:
252: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
253: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
254: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);

Line 254: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);

250: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);
251:
252: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
253: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
254: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);
255:
256: IF FND_API.To_Boolean(p_commit) THEN
257: UPDATE csi_ii_geoloc_interface
258: SET process_flag = 'E',

Line 275: csi_t_gen_utility_pvt.add( 'Convert Latitude value to DD');

271:
272: /*IF geocode format is 'DD' no need to convert latitude and longitude values*/
273: IF p_CSI_instance_geoloc_tbl(i).geocode_format IN ('DMS','DM') THEN
274:
275: csi_t_gen_utility_pvt.add( 'Convert Latitude value to DD');
276:
277: /* calling procedure to convert latitude to DD value */
278: CSI_GIS_INSTANCE_LOC_UTL_PKG.CONVERT_DMS_OR_DM_TO_DD
279: (p_value => p_csi_instance_geoloc_tbl(i).inst_latitude

Line 289: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);

285: ,x_msg_count => l_msg_count
286: ,x_msg_data => l_msg_data
287: );
288:
289: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);
290:
291: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
292: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
293: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);

Line 293: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);

289: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);
290:
291: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
292: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
293: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);
294: IF FND_API.To_Boolean(p_commit) THEN
295: UPDATE csi_ii_geoloc_interface
296: SET process_flag = 'E',
297: error_message=l_msg_data,

Line 309: csi_t_gen_utility_pvt.add( 'Convert Latitude value to DD');

305: -- Continue processing other records
306: RAISE FND_API.G_EXC_ERROR;
307: END IF;
308:
309: csi_t_gen_utility_pvt.add( 'Convert Latitude value to DD');
310:
311: /* calling procedure to convert longitude to DD value */
312: CSI_GIS_INSTANCE_LOC_UTL_PKG.CONVERT_DMS_OR_DM_TO_DD
313: (p_value => p_csi_instance_geoloc_tbl(i).inst_longitude

Line 323: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);

319: ,x_msg_count => l_msg_count
320: ,x_msg_data => l_msg_data
321: );
322:
323: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);
324:
325: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
326: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
327: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);

Line 327: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);

323: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);
324:
325: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
326: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
327: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);
328: IF FND_API.To_Boolean(p_commit) THEN
329: UPDATE csi_ii_geoloc_interface
330: SET process_flag = 'E',
331: error_message=l_msg_data,

Line 352: csi_t_gen_utility_pvt.add( 'Calling Insert row');

348:
349: /*l_create_update = 'C' indicates that latitude and longitude values are being entered for the first time for asset/instance */
350: IF l_create_update = 'C' THEN
351:
352: csi_t_gen_utility_pvt.add( 'Calling Insert row');
353:
354: CSI_GIS_INSTANCE_GEO_LOC_PVT.INSERT_ROW
355: ( p_instance_id => p_CSI_instance_geoloc_tbl(i).instance_id
356: ,p_inst_latitude => l_inst_latitude_dd_value

Line 361: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);

357: ,p_inst_longitude => l_inst_longitude_dd_value
358: , x_return_status => l_return_status
359: );
360:
361: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);
362:
363: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
364: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
365: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);

Line 365: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);

361: csi_t_gen_utility_pvt.add( 'Return Status:'||l_return_status);
362:
363: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
364: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
365: csi_t_gen_utility_pvt.add('Error Message:'||l_msg_data);
366: IF FND_API.To_Boolean(p_commit) THEN
367: UPDATE csi_ii_geoloc_interface
368: SET process_flag = 'E',
369: error_message=l_msg_data,

Line 390: csi_t_gen_utility_pvt.add( 'Completed Processing Record#:'||i);

386: FROM CSI_ITEM_INSTANCES
387: WHERE instance_id = p_csi_instance_geoloc_tbl(i).instance_id)
388: AND PROCESS_FLAG = 'R';
389: COMMIT WORK;
390: csi_t_gen_utility_pvt.add( 'Completed Processing Record#:'||i);
391: END IF;
392:
393: /*l_create_update = 'U' indicates that latitude and longitude values are already present for the asset/instance and they are just being updated*/
394: ELSIF l_create_update = 'U' THEN

Line 396: csi_t_gen_utility_pvt.add( 'Calling Update row');

392:
393: /*l_create_update = 'U' indicates that latitude and longitude values are already present for the asset/instance and they are just being updated*/
394: ELSIF l_create_update = 'U' THEN
395:
396: csi_t_gen_utility_pvt.add( 'Calling Update row');
397: /* Updating information for an existing instance */
398: CSI_GIS_INSTANCE_GEO_LOC_PVT.UPDATE_ROW
399: ( p_instance_id => p_CSI_instance_geoloc_tbl(i).instance_id
400: ,p_inst_latitude => l_inst_latitude_dd_value

Line 408: csi_t_gen_utility_pvt.add(l_msg_data);

404: );
405:
406: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
407: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
408: csi_t_gen_utility_pvt.add(l_msg_data);
409: IF FND_API.To_Boolean(p_commit) THEN
410: UPDATE csi_ii_geoloc_interface
411: SET process_flag = 'E',
412: error_message=l_msg_data,

Line 433: csi_t_gen_utility_pvt.add( 'Completed Processing Record#:'||i);

429: FROM CSI_ITEM_INSTANCES
430: WHERE instance_id = p_csi_instance_geoloc_tbl(i).instance_id)
431: AND PROCESS_FLAG = 'R' ;
432: COMMIT WORK;
433: csi_t_gen_utility_pvt.add( 'Completed Processing Record#:'||i);
434: END IF;
435: END IF;
436: EXCEPTION
437: WHEN FND_API.G_EXC_ERROR THEN

Line 445: csi_t_gen_utility_pvt.add( 'Returning to Import API');

441: END LOOP;
442: END IF;
443:
444: IF FND_API.To_Boolean( p_commit ) THEN
445: csi_t_gen_utility_pvt.add( 'Returning to Import API');
446: return;
447: END IF;
448:
449: IF l_error_count > 0 THEN

Line 455: csi_t_gen_utility_pvt.add( 'Completed Processing Records');

451: END IF;
452:
453: COMMIT WORK;
454:
455: csi_t_gen_utility_pvt.add( 'Completed Processing Records');
456:
457: EXCEPTION
458:
459: WHEN FND_API.G_EXC_ERROR THEN

Line 461: csi_t_gen_utility_pvt.add( 'Error in Processing Records');

457: EXCEPTION
458:
459: WHEN FND_API.G_EXC_ERROR THEN
460: x_return_status := FND_API.G_RET_STS_ERROR ;
461: csi_t_gen_utility_pvt.add( 'Error in Processing Records');
462: csi_t_gen_utility_pvt.add( 'Error Count:'||l_error_count);
463: ROLLBACK TO CREATEUPDATE_INST_GEOLOC_INFO;
464: FND_MSG_PUB.Count_And_Get
465: ( p_encoded => FND_API.G_FALSE,

Line 462: csi_t_gen_utility_pvt.add( 'Error Count:'||l_error_count);

458:
459: WHEN FND_API.G_EXC_ERROR THEN
460: x_return_status := FND_API.G_RET_STS_ERROR ;
461: csi_t_gen_utility_pvt.add( 'Error in Processing Records');
462: csi_t_gen_utility_pvt.add( 'Error Count:'||l_error_count);
463: ROLLBACK TO CREATEUPDATE_INST_GEOLOC_INFO;
464: FND_MSG_PUB.Count_And_Get
465: ( p_encoded => FND_API.G_FALSE,
466: p_count => x_msg_count,

Line 472: csi_t_gen_utility_pvt.add( 'Error in Processing Records');

468: );
469:
470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
472: csi_t_gen_utility_pvt.add( 'Error in Processing Records');
473: ROLLBACK TO CREATEUPDATE_INST_GEOLOC_INFO;
474: FND_MSG_PUB.Count_And_Get
475: ( p_encoded => FND_API.G_FALSE,
476: p_count => x_msg_count,

Line 482: csi_t_gen_utility_pvt.add( 'Error in Processing Records');

478: );
479:
480: WHEN OTHERS THEN
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
482: csi_t_gen_utility_pvt.add( 'Error in Processing Records');
483: ROLLBACK TO CREATEUPDATE_INST_GEOLOC_INFO;
484: IF FND_MSG_PUB.Check_Msg_Level
485: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
486: THEN

Line 547: csi_t_gen_utility_pvt.add( 'IMPORT_INSTANCE_GEO_LOCATION');

543: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
544:
545: -- If debug_level >0 then dump the procedure name
546: IF (l_debug_level > 0) THEN
547: csi_t_gen_utility_pvt.add( 'IMPORT_INSTANCE_GEO_LOCATION');
548: END IF;
549:
550: OPEN import_inst_geo_loc_cur;
551: FETCH import_inst_geo_loc_cur BULK COLLECT INTO import_inst_geo_loc_tbl;

Line 645: csi_t_gen_utility_pvt.add( 'No of errored records: '||to_char(l_msg_count + l_error_count));

641: ,x_msg_count => l_msg_count
642: ,x_msg_data => l_msg_data);
643: END IF;
644:
645: csi_t_gen_utility_pvt.add( 'No of errored records: '||to_char(l_msg_count + l_error_count));
646: csi_t_gen_utility_pvt.add( 'Completed processing records');
647:
648: END IMPORT_INSTANCE_GEO_LOCATION;
649:

Line 646: csi_t_gen_utility_pvt.add( 'Completed processing records');

642: ,x_msg_data => l_msg_data);
643: END IF;
644:
645: csi_t_gen_utility_pvt.add( 'No of errored records: '||to_char(l_msg_count + l_error_count));
646: csi_t_gen_utility_pvt.add( 'Completed processing records');
647:
648: END IMPORT_INSTANCE_GEO_LOCATION;
649:
650: END CSI_GIS_INSTANCE_LOC_PUB;