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_II_GEOLOC_INTERFACE

Line 142: UPDATE csi_ii_geoloc_interface

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,
145: process_date=sysdate
146: WHERE instance_number = (select instance_number

Line 188: UPDATE csi_ii_geoloc_interface

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,
191: process_date=sysdate
192: WHERE instance_number = (select instance_number

Line 221: UPDATE csi_ii_geoloc_interface

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,
224: process_date=sysdate
225: WHERE instance_number = (select instance_number

Line 257: UPDATE csi_ii_geoloc_interface

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',
259: error_message=l_msg_data,
260: process_date=sysdate
261: WHERE instance_number = (select instance_number

Line 295: UPDATE csi_ii_geoloc_interface

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,
298: process_date=sysdate
299: WHERE instance_number = (select instance_number

Line 329: UPDATE csi_ii_geoloc_interface

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,
332: process_date=sysdate
333: WHERE instance_number = (select instance_number

Line 367: UPDATE csi_ii_geoloc_interface

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,
370: process_date=sysdate
371: WHERE instance_number = (select instance_number

Line 382: UPDATE csi_ii_geoloc_interface

378: RAISE FND_API.G_EXC_ERROR;
379: END IF;
380:
381: IF FND_API.To_Boolean( p_commit ) THEN
382: UPDATE csi_ii_geoloc_interface
383: SET process_flag = 'P',
384: process_date = sysdate
385: WHERE instance_number = (select instance_number
386: FROM CSI_ITEM_INSTANCES

Line 410: UPDATE csi_ii_geoloc_interface

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,
413: process_date = sysdate
414: WHERE instance_number = (select instance_number

Line 425: UPDATE csi_ii_geoloc_interface

421: RAISE FND_API.G_EXC_ERROR;
422: END IF;
423:
424: IF FND_API.To_Boolean( p_commit ) THEN
425: UPDATE csi_ii_geoloc_interface
426: SET process_flag = 'P',
427: process_date = sysdate
428: WHERE instance_number = (select instance_number
429: FROM CSI_ITEM_INSTANCES

Line 524: FROM csi_ii_geoloc_interface

520: l_geocode_format VARCHAR2(3);
521:
522: CURSOR import_inst_geo_loc_cur IS
523: SELECT *
524: FROM csi_ii_geoloc_interface
525: WHERE process_flag = 'R';
526:
527: TYPE import_inst_geo_loc_tbl_type IS TABLE OF csi_ii_geoloc_interface%ROWTYPE;
528: import_inst_geo_loc_tbl import_inst_geo_loc_tbl_type;

Line 527: TYPE import_inst_geo_loc_tbl_type IS TABLE OF csi_ii_geoloc_interface%ROWTYPE;

523: SELECT *
524: FROM csi_ii_geoloc_interface
525: WHERE process_flag = 'R';
526:
527: TYPE import_inst_geo_loc_tbl_type IS TABLE OF csi_ii_geoloc_interface%ROWTYPE;
528: import_inst_geo_loc_tbl import_inst_geo_loc_tbl_type;
529: BEGIN
530:
531: -- Standard call to check for call compatibility.

Line 561: FROM csi_ii_geoloc_interface

557:
558: BEGIN
559: SELECT Count(instance_number)
560: INTO l_count
561: FROM csi_ii_geoloc_interface
562: WHERE instance_number = import_inst_geo_loc_tbl(i).instance_number
563: AND PROCESS_FLAG = 'R';
564:
565: /*checking for duplicate instances*/

Line 569: UPDATE csi_ii_geoloc_interface

565: /*checking for duplicate instances*/
566: IF l_count > 1 OR l_count = 0 THEN
567: l_error_count := l_error_count + 1;
568: l_record_status:='E';
569: UPDATE csi_ii_geoloc_interface
570: SET process_flag = 'E',
571: error_message = FND_MESSAGE.Get_String('CSI', 'CSI_GIS_DUP_INST_ASSET'),
572: process_date=sysdate
573: WHERE instance_number = import_inst_geo_loc_tbl(i).instance_number

Line 588: UPDATE csi_ii_geoloc_interface

584: WHEN NO_DATA_FOUND THEN
585:
586: l_error_count := l_error_count + 1;
587: l_record_status:='E';
588: UPDATE csi_ii_geoloc_interface
589: SET process_flag = 'E',
590: error_message = FND_MESSAGE.Get_String('CSI', 'CSI_INSTANCE_NOT_FOUND'),
591: process_date=sysdate
592: WHERE instance_number = import_inst_geo_loc_tbl(i).instance_number

Line 610: UPDATE csi_ii_geoloc_interface

606: OR Length(l_geocode_format)IS NULL) THEN
607:
608: l_error_count := l_error_count + 1;
609: l_record_status:='E';
610: UPDATE csi_ii_geoloc_interface
611: SET process_flag = 'E',
612: error_message = FND_MESSAGE.Get_String('CSI', 'CSI_INVALID_GEOCODE_FORMAT'),
613: process_date=sysdate
614: WHERE instance_number = import_inst_geo_loc_tbl(i).instance_number