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_SYSTEMS_PUB dependencies on FND_API

Line 49: IF NOT fnd_api.compatible_api_call ( l_api_version,

45: csi_utility_grp.check_ib_active;
46:
47:
48: -- standard call to check for call compatibility.
49: IF NOT fnd_api.compatible_api_call ( l_api_version,
50: p_api_version,
51: l_api_name,
52: g_pkg_name)
53: THEN

Line 54: RAISE fnd_api.g_exc_unexpected_error;

50: p_api_version,
51: l_api_name,
52: g_pkg_name)
53: THEN
54: RAISE fnd_api.g_exc_unexpected_error;
55: END IF;
56:
57:
58: -- initialize message list if p_init_msg_list is set to true.

Line 59: IF fnd_api.to_boolean( p_init_msg_list )

55: END IF;
56:
57:
58: -- initialize message list if p_init_msg_list is set to true.
59: IF fnd_api.to_boolean( p_init_msg_list )
60: THEN
61: fnd_msg_pub.initialize;
62: END IF;
63:

Line 67: x_return_status := fnd_api.g_ret_sts_success;

63:
64:
65:
66: -- initialize api return status to success
67: x_return_status := fnd_api.g_ret_sts_success;
68:
69: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
70: -- if debug_level = 1 then dump the procedure name
71: IF (l_debug_level > 0) THEN

Line 101: p_commit => fnd_api.g_false,

97: -- debug message
98:
99: csi_systems_pvt.get_systems(
100: p_api_version => p_api_version,
101: p_commit => fnd_api.g_false,
102: p_init_msg_list => p_init_msg_list,
103: p_validation_level => p_validation_level,
104: p_system_query_rec => p_system_query_rec,
105: p_time_stamp => p_time_stamp,

Line 117: IF x_return_status = fnd_api.g_ret_sts_error THEN

113:
114:
115:
116: -- check return status from the above procedure call
117: IF x_return_status = fnd_api.g_ret_sts_error THEN
118: RAISE fnd_api.g_exc_error;
119: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
120: RAISE fnd_api.g_exc_unexpected_error;
121: END IF;

Line 118: RAISE fnd_api.g_exc_error;

114:
115:
116: -- check return status from the above procedure call
117: IF x_return_status = fnd_api.g_ret_sts_error THEN
118: RAISE fnd_api.g_exc_error;
119: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
120: RAISE fnd_api.g_exc_unexpected_error;
121: END IF;
122:

Line 119: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

115:
116: -- check return status from the above procedure call
117: IF x_return_status = fnd_api.g_ret_sts_error THEN
118: RAISE fnd_api.g_exc_error;
119: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
120: RAISE fnd_api.g_exc_unexpected_error;
121: END IF;
122:
123: --

Line 120: RAISE fnd_api.g_exc_unexpected_error;

116: -- check return status from the above procedure call
117: IF x_return_status = fnd_api.g_ret_sts_error THEN
118: RAISE fnd_api.g_exc_error;
119: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
120: RAISE fnd_api.g_exc_unexpected_error;
121: END IF;
122:
123: --
124: -- end of api body

Line 139: WHEN fnd_api.g_exc_error THEN

135: p_data => x_msg_data
136: );
137:
138: EXCEPTION
139: WHEN fnd_api.g_exc_error THEN
140: -- ROLLBACK TO get_systems_pub;
141: x_return_status := fnd_api.g_ret_sts_error ;
142: fnd_msg_pub.count_and_get
143: (p_count => x_msg_count ,

Line 141: x_return_status := fnd_api.g_ret_sts_error ;

137:
138: EXCEPTION
139: WHEN fnd_api.g_exc_error THEN
140: -- ROLLBACK TO get_systems_pub;
141: x_return_status := fnd_api.g_ret_sts_error ;
142: fnd_msg_pub.count_and_get
143: (p_count => x_msg_count ,
144: p_data => x_msg_data
145: );

Line 147: WHEN fnd_api.g_exc_unexpected_error THEN

143: (p_count => x_msg_count ,
144: p_data => x_msg_data
145: );
146:
147: WHEN fnd_api.g_exc_unexpected_error THEN
148: -- ROLLBACK TO get_systems_pub;
149: x_return_status := fnd_api.g_ret_sts_unexp_error ;
150: fnd_msg_pub.count_and_get
151: (p_count => x_msg_count ,

Line 149: x_return_status := fnd_api.g_ret_sts_unexp_error ;

145: );
146:
147: WHEN fnd_api.g_exc_unexpected_error THEN
148: -- ROLLBACK TO get_systems_pub;
149: x_return_status := fnd_api.g_ret_sts_unexp_error ;
150: fnd_msg_pub.count_and_get
151: (p_count => x_msg_count ,
152: p_data => x_msg_data
153: );

Line 157: x_return_status := fnd_api.g_ret_sts_unexp_error ;

153: );
154:
155: WHEN OTHERS THEN
156: -- ROLLBACK TO get_systems_pub;
157: x_return_status := fnd_api.g_ret_sts_unexp_error ;
158: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
159: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
160: END IF;
161: fnd_msg_pub.count_and_get

Line 201: IF NOT fnd_api.compatible_api_call ( l_api_version,

197: csi_utility_grp.check_ib_active;
198:
199:
200: -- standard call to check for call compatibility.
201: IF NOT fnd_api.compatible_api_call ( l_api_version,
202: p_api_version,
203: l_api_name,
204: g_pkg_name)
205: THEN

Line 206: RAISE fnd_api.g_exc_unexpected_error;

202: p_api_version,
203: l_api_name,
204: g_pkg_name)
205: THEN
206: RAISE fnd_api.g_exc_unexpected_error;
207: END IF;
208:
209:
210: -- initialize message list if p_init_msg_list is set to true.

Line 211: IF fnd_api.to_boolean( p_init_msg_list )

207: END IF;
208:
209:
210: -- initialize message list if p_init_msg_list is set to true.
211: IF fnd_api.to_boolean( p_init_msg_list )
212: THEN
213: fnd_msg_pub.initialize;
214: END IF;
215:

Line 219: x_return_status := fnd_api.g_ret_sts_success;

215:
216:
217:
218: -- initialize api return status to success
219: x_return_status := fnd_api.g_ret_sts_success;
220:
221: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
222: -- if debug_level = 1 then dump the procedure name
223: IF (l_debug_level > 0) THEN

Line 255: p_commit =>fnd_api.g_false,

251:
252:
253: csi_systems_pvt.create_system(
254: p_api_version =>p_api_version,
255: p_commit =>fnd_api.g_false,
256: p_init_msg_list =>p_init_msg_list,
257: p_validation_level =>p_validation_level,
258: p_system_rec =>p_system_rec,
259: p_txn_rec =>p_txn_rec,

Line 269: IF x_return_status = fnd_api.g_ret_sts_error THEN

265:
266:
267:
268: -- check return status from the above procedure call
269: IF x_return_status = fnd_api.g_ret_sts_error THEN
270: RAISE fnd_api.g_exc_error;
271: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
272: RAISE fnd_api.g_exc_unexpected_error;
273: END IF;

Line 270: RAISE fnd_api.g_exc_error;

266:
267:
268: -- check return status from the above procedure call
269: IF x_return_status = fnd_api.g_ret_sts_error THEN
270: RAISE fnd_api.g_exc_error;
271: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
272: RAISE fnd_api.g_exc_unexpected_error;
273: END IF;
274:

Line 271: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

267:
268: -- check return status from the above procedure call
269: IF x_return_status = fnd_api.g_ret_sts_error THEN
270: RAISE fnd_api.g_exc_error;
271: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
272: RAISE fnd_api.g_exc_unexpected_error;
273: END IF;
274:
275: --

Line 272: RAISE fnd_api.g_exc_unexpected_error;

268: -- check return status from the above procedure call
269: IF x_return_status = fnd_api.g_ret_sts_error THEN
270: RAISE fnd_api.g_exc_error;
271: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
272: RAISE fnd_api.g_exc_unexpected_error;
273: END IF;
274:
275: --
276: -- end of api body.

Line 280: IF fnd_api.to_boolean( p_commit )

276: -- end of api body.
277: --
278:
279: -- standard check for p_commit
280: IF fnd_api.to_boolean( p_commit )
281: THEN
282: COMMIT WORK;
283: END IF;
284:

Line 298: WHEN fnd_api.g_exc_error THEN

294: p_data => x_msg_data
295: );
296:
297: EXCEPTION
298: WHEN fnd_api.g_exc_error THEN
299: ROLLBACK TO create_system_pub;
300: x_return_status := fnd_api.g_ret_sts_error ;
301: fnd_msg_pub.count_and_get
302: (p_count => x_msg_count ,

Line 300: x_return_status := fnd_api.g_ret_sts_error ;

296:
297: EXCEPTION
298: WHEN fnd_api.g_exc_error THEN
299: ROLLBACK TO create_system_pub;
300: x_return_status := fnd_api.g_ret_sts_error ;
301: fnd_msg_pub.count_and_get
302: (p_count => x_msg_count ,
303: p_data => x_msg_data
304: );

Line 306: WHEN fnd_api.g_exc_unexpected_error THEN

302: (p_count => x_msg_count ,
303: p_data => x_msg_data
304: );
305:
306: WHEN fnd_api.g_exc_unexpected_error THEN
307: ROLLBACK TO create_system_pub;
308: x_return_status := fnd_api.g_ret_sts_unexp_error ;
309: fnd_msg_pub.count_and_get
310: (p_count => x_msg_count ,

Line 308: x_return_status := fnd_api.g_ret_sts_unexp_error ;

304: );
305:
306: WHEN fnd_api.g_exc_unexpected_error THEN
307: ROLLBACK TO create_system_pub;
308: x_return_status := fnd_api.g_ret_sts_unexp_error ;
309: fnd_msg_pub.count_and_get
310: (p_count => x_msg_count ,
311: p_data => x_msg_data
312: );

Line 316: x_return_status := fnd_api.g_ret_sts_unexp_error ;

312: );
313:
314: WHEN OTHERS THEN
315: ROLLBACK TO create_system_pub;
316: x_return_status := fnd_api.g_ret_sts_unexp_error ;
317: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
318: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
319: END IF;
320: fnd_msg_pub.count_and_get

Line 358: IF NOT fnd_api.compatible_api_call ( l_api_version,

354: csi_utility_grp.check_ib_active;
355:
356:
357: -- standard call to check for call compatibility.
358: IF NOT fnd_api.compatible_api_call ( l_api_version,
359: p_api_version,
360: l_api_name,
361: g_pkg_name)
362: THEN

Line 363: RAISE fnd_api.g_exc_unexpected_error;

359: p_api_version,
360: l_api_name,
361: g_pkg_name)
362: THEN
363: RAISE fnd_api.g_exc_unexpected_error;
364: END IF;
365:
366:
367: -- initialize message list if p_init_msg_list is set to true.

Line 368: IF fnd_api.to_boolean( p_init_msg_list )

364: END IF;
365:
366:
367: -- initialize message list if p_init_msg_list is set to true.
368: IF fnd_api.to_boolean( p_init_msg_list )
369: THEN
370: fnd_msg_pub.initialize;
371: END IF;
372:

Line 375: x_return_status := fnd_api.g_ret_sts_success;

371: END IF;
372:
373:
374: -- initialize api return status to success
375: x_return_status := fnd_api.g_ret_sts_success;
376:
377: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
378: -- if debug_level = 1 then dump the procedure name
379: IF (l_debug_level > 0) THEN

Line 407: p_commit => fnd_api.g_false,

403: ****/
404:
405: csi_systems_pvt.update_system(
406: p_api_version => p_api_version,
407: p_commit => fnd_api.g_false,
408: p_init_msg_list => p_init_msg_list,
409: p_validation_level => p_validation_level,
410: p_system_rec => p_system_rec,
411: p_txn_rec => p_txn_rec,

Line 421: IF x_return_status = fnd_api.g_ret_sts_error THEN

417:
418:
419:
420: -- check return status from the above procedure call
421: IF x_return_status = fnd_api.g_ret_sts_error THEN
422: RAISE fnd_api.g_exc_error;
423: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
424: RAISE fnd_api.g_exc_unexpected_error;
425: END IF;

Line 422: RAISE fnd_api.g_exc_error;

418:
419:
420: -- check return status from the above procedure call
421: IF x_return_status = fnd_api.g_ret_sts_error THEN
422: RAISE fnd_api.g_exc_error;
423: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
424: RAISE fnd_api.g_exc_unexpected_error;
425: END IF;
426:

Line 423: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

419:
420: -- check return status from the above procedure call
421: IF x_return_status = fnd_api.g_ret_sts_error THEN
422: RAISE fnd_api.g_exc_error;
423: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
424: RAISE fnd_api.g_exc_unexpected_error;
425: END IF;
426:
427: --

Line 424: RAISE fnd_api.g_exc_unexpected_error;

420: -- check return status from the above procedure call
421: IF x_return_status = fnd_api.g_ret_sts_error THEN
422: RAISE fnd_api.g_exc_error;
423: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
424: RAISE fnd_api.g_exc_unexpected_error;
425: END IF;
426:
427: --
428: -- end of api body

Line 432: IF fnd_api.to_boolean( p_commit )

428: -- end of api body
429: --
430:
431: -- standard check for p_commit
432: IF fnd_api.to_boolean( p_commit )
433: THEN
434: COMMIT WORK;
435: END IF;
436:

Line 450: WHEN fnd_api.g_exc_error THEN

446: p_data => x_msg_data
447: );
448:
449: EXCEPTION
450: WHEN fnd_api.g_exc_error THEN
451: ROLLBACK TO update_system_pub;
452: x_return_status := fnd_api.g_ret_sts_error ;
453: fnd_msg_pub.count_and_get
454: (p_count => x_msg_count ,

Line 452: x_return_status := fnd_api.g_ret_sts_error ;

448:
449: EXCEPTION
450: WHEN fnd_api.g_exc_error THEN
451: ROLLBACK TO update_system_pub;
452: x_return_status := fnd_api.g_ret_sts_error ;
453: fnd_msg_pub.count_and_get
454: (p_count => x_msg_count ,
455: p_data => x_msg_data
456: );

Line 458: WHEN fnd_api.g_exc_unexpected_error THEN

454: (p_count => x_msg_count ,
455: p_data => x_msg_data
456: );
457:
458: WHEN fnd_api.g_exc_unexpected_error THEN
459: ROLLBACK TO update_system_pub;
460: x_return_status := fnd_api.g_ret_sts_unexp_error ;
461: fnd_msg_pub.count_and_get
462: (p_count => x_msg_count ,

Line 460: x_return_status := fnd_api.g_ret_sts_unexp_error ;

456: );
457:
458: WHEN fnd_api.g_exc_unexpected_error THEN
459: ROLLBACK TO update_system_pub;
460: x_return_status := fnd_api.g_ret_sts_unexp_error ;
461: fnd_msg_pub.count_and_get
462: (p_count => x_msg_count ,
463: p_data => x_msg_data
464: );

Line 468: x_return_status := fnd_api.g_ret_sts_unexp_error ;

464: );
465:
466: WHEN OTHERS THEN
467: ROLLBACK TO update_system_pub;
468: x_return_status := fnd_api.g_ret_sts_unexp_error ;
469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
470: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
471: END IF;
472: fnd_msg_pub.count_and_get

Line 510: IF NOT fnd_api.compatible_api_call ( l_api_version,

506: csi_utility_grp.check_ib_active;
507:
508:
509: -- standard call to check for call compatibility.
510: IF NOT fnd_api.compatible_api_call ( l_api_version,
511: p_api_version,
512: l_api_name,
513: g_pkg_name)
514: THEN

Line 515: RAISE fnd_api.g_exc_unexpected_error;

511: p_api_version,
512: l_api_name,
513: g_pkg_name)
514: THEN
515: RAISE fnd_api.g_exc_unexpected_error;
516: END IF;
517:
518:
519: -- initialize message list if p_init_msg_list is set to true.

Line 520: IF fnd_api.to_boolean( p_init_msg_list )

516: END IF;
517:
518:
519: -- initialize message list if p_init_msg_list is set to true.
520: IF fnd_api.to_boolean( p_init_msg_list )
521: THEN
522: fnd_msg_pub.initialize;
523: END IF;
524:

Line 527: x_return_status := fnd_api.g_ret_sts_success;

523: END IF;
524:
525:
526: -- initialize api return status to success
527: x_return_status := fnd_api.g_ret_sts_success;
528:
529: l_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
530: -- if debug_level = 1 then dump the procedure name
531: IF (l_debug_level > 0) THEN

Line 561: p_commit => fnd_api.g_false,

557: ****/
558:
559: csi_systems_pvt.expire_system(
560: p_api_version => p_api_version,
561: p_commit => fnd_api.g_false,
562: p_init_msg_list => p_init_msg_list,
563: p_validation_level => p_validation_level,
564: p_system_rec => p_system_rec,
565: p_txn_rec => p_txn_rec,

Line 576: IF x_return_status = fnd_api.g_ret_sts_error THEN

572:
573:
574:
575: -- check return status from the above procedure call
576: IF x_return_status = fnd_api.g_ret_sts_error THEN
577: RAISE fnd_api.g_exc_error;
578: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
579: RAISE fnd_api.g_exc_unexpected_error;
580: END IF;

Line 577: RAISE fnd_api.g_exc_error;

573:
574:
575: -- check return status from the above procedure call
576: IF x_return_status = fnd_api.g_ret_sts_error THEN
577: RAISE fnd_api.g_exc_error;
578: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
579: RAISE fnd_api.g_exc_unexpected_error;
580: END IF;
581:

Line 578: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

574:
575: -- check return status from the above procedure call
576: IF x_return_status = fnd_api.g_ret_sts_error THEN
577: RAISE fnd_api.g_exc_error;
578: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
579: RAISE fnd_api.g_exc_unexpected_error;
580: END IF;
581:
582: --

Line 579: RAISE fnd_api.g_exc_unexpected_error;

575: -- check return status from the above procedure call
576: IF x_return_status = fnd_api.g_ret_sts_error THEN
577: RAISE fnd_api.g_exc_error;
578: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
579: RAISE fnd_api.g_exc_unexpected_error;
580: END IF;
581:
582: --
583: -- end of api body

Line 587: IF fnd_api.to_boolean( p_commit )

583: -- end of api body
584: --
585:
586: -- standard check for p_commit
587: IF fnd_api.to_boolean( p_commit )
588: THEN
589: COMMIT WORK;
590: END IF;
591:

Line 605: WHEN fnd_api.g_exc_error THEN

601: p_data => x_msg_data
602: );
603:
604: EXCEPTION
605: WHEN fnd_api.g_exc_error THEN
606: ROLLBACK TO expire_system_pub;
607: x_return_status := fnd_api.g_ret_sts_error ;
608: fnd_msg_pub.count_and_get
609: (p_count => x_msg_count ,

Line 607: x_return_status := fnd_api.g_ret_sts_error ;

603:
604: EXCEPTION
605: WHEN fnd_api.g_exc_error THEN
606: ROLLBACK TO expire_system_pub;
607: x_return_status := fnd_api.g_ret_sts_error ;
608: fnd_msg_pub.count_and_get
609: (p_count => x_msg_count ,
610: p_data => x_msg_data
611: );

Line 613: WHEN fnd_api.g_exc_unexpected_error THEN

609: (p_count => x_msg_count ,
610: p_data => x_msg_data
611: );
612:
613: WHEN fnd_api.g_exc_unexpected_error THEN
614: ROLLBACK TO expire_system_pub;
615: x_return_status := fnd_api.g_ret_sts_unexp_error ;
616: fnd_msg_pub.count_and_get
617: (p_count => x_msg_count ,

Line 615: x_return_status := fnd_api.g_ret_sts_unexp_error ;

611: );
612:
613: WHEN fnd_api.g_exc_unexpected_error THEN
614: ROLLBACK TO expire_system_pub;
615: x_return_status := fnd_api.g_ret_sts_unexp_error ;
616: fnd_msg_pub.count_and_get
617: (p_count => x_msg_count ,
618: p_data => x_msg_data
619: );

Line 623: x_return_status := fnd_api.g_ret_sts_unexp_error ;

619: );
620:
621: WHEN OTHERS THEN
622: ROLLBACK TO expire_system_pub;
623: x_return_status := fnd_api.g_ret_sts_unexp_error ;
624: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
625: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
626: END IF;
627: fnd_msg_pub.count_and_get