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.JTF_RS_WF_EVENTS_PUB dependencies on FND_API

Line 53: x_return_status := fnd_api.g_ret_sts_success;

49: l_user_id jtf_rs_resource_extns.user_id%type := p_user_id;
50:
51: BEGIN
52:
53: x_return_status := fnd_api.g_ret_sts_success;
54: savepoint cr_emp_publish_save;
55:
56: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
57: RAISE fnd_api.g_exc_unexpected_error;

Line 56: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

52:
53: x_return_status := fnd_api.g_ret_sts_success;
54: savepoint cr_emp_publish_save;
55:
56: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
57: RAISE fnd_api.g_exc_unexpected_error;
58: END IF;
59:
60: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 57: RAISE fnd_api.g_exc_unexpected_error;

53: x_return_status := fnd_api.g_ret_sts_success;
54: savepoint cr_emp_publish_save;
55:
56: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
57: RAISE fnd_api.g_exc_unexpected_error;
58: END IF;
59:
60: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
61: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

Line 61: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

57: RAISE fnd_api.g_exc_unexpected_error;
58: END IF;
59:
60: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
61: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
62: then
63: fnd_msg_pub.Initialize;
64: end if;
65:

Line 89: x_return_status := fnd_api.g_ret_sts_unexp_error;

85: l_list.DELETE;
86:
87: EXCEPTION when OTHERS then
88: ROLLBACK TO cr_emp_publish_save;
89: x_return_status := fnd_api.g_ret_sts_unexp_error;
90:
91: END create_resource;
92:
93: PROCEDURE merge_resource

Line 118: x_return_status := fnd_api.g_ret_sts_success;

114: l_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_end_date_active);
115:
116: BEGIN
117:
118: x_return_status := fnd_api.g_ret_sts_success;
119: savepoint merge_res_publish_save;
120:
121: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
122: RAISE fnd_api.g_exc_unexpected_error;

Line 121: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

117:
118: x_return_status := fnd_api.g_ret_sts_success;
119: savepoint merge_res_publish_save;
120:
121: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
122: RAISE fnd_api.g_exc_unexpected_error;
123: END IF;
124:
125: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 122: RAISE fnd_api.g_exc_unexpected_error;

118: x_return_status := fnd_api.g_ret_sts_success;
119: savepoint merge_res_publish_save;
120:
121: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
122: RAISE fnd_api.g_exc_unexpected_error;
123: END IF;
124:
125: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
126: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

Line 126: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

122: RAISE fnd_api.g_exc_unexpected_error;
123: END IF;
124:
125: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
126: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
127: then
128: fnd_msg_pub.Initialize;
129: end if;
130:

Line 151: x_return_status := fnd_api.g_ret_sts_unexp_error;

147: l_list.DELETE;
148:
149: EXCEPTION when OTHERS then
150: ROLLBACK TO merge_res_publish_save;
151: x_return_status := fnd_api.g_ret_sts_unexp_error;
152:
153: END merge_resource;
154:
155:

Line 225: x_return_status := fnd_api.g_ret_sts_success;

221: res_rec res_cur%rowtype;
222:
223: BEGIN
224:
225: x_return_status := fnd_api.g_ret_sts_success;
226: savepoint upd_emp_publish_save;
227:
228: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
229: RAISE fnd_api.g_exc_unexpected_error;

Line 228: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

224:
225: x_return_status := fnd_api.g_ret_sts_success;
226: savepoint upd_emp_publish_save;
227:
228: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
229: RAISE fnd_api.g_exc_unexpected_error;
230: END IF;
231:
232: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 229: RAISE fnd_api.g_exc_unexpected_error;

225: x_return_status := fnd_api.g_ret_sts_success;
226: savepoint upd_emp_publish_save;
227:
228: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
229: RAISE fnd_api.g_exc_unexpected_error;
230: END IF;
231:
232: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
233: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

Line 233: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

229: RAISE fnd_api.g_exc_unexpected_error;
230: END IF;
231:
232: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
233: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
234: then
235: fnd_msg_pub.Initialize;
236: end if;
237:

Line 410: x_return_status := fnd_api.g_ret_sts_unexp_error;

406: CLOSE res_cur;
407:
408: EXCEPTION when OTHERS then
409: ROLLBACK TO upd_emp_publish_save;
410: x_return_status := fnd_api.g_ret_sts_unexp_error;
411:
412: END update_resource;
413:
414: PROCEDURE delete_resource

Line 437: x_return_status := fnd_api.g_ret_sts_success;

433: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;
434:
435: BEGIN
436:
437: x_return_status := fnd_api.g_ret_sts_success;
438: savepoint del_emp_publish_save;
439:
440: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
441: RAISE fnd_api.g_exc_unexpected_error;

Line 440: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

436:
437: x_return_status := fnd_api.g_ret_sts_success;
438: savepoint del_emp_publish_save;
439:
440: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
441: RAISE fnd_api.g_exc_unexpected_error;
442: END IF;
443:
444: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 441: RAISE fnd_api.g_exc_unexpected_error;

437: x_return_status := fnd_api.g_ret_sts_success;
438: savepoint del_emp_publish_save;
439:
440: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
441: RAISE fnd_api.g_exc_unexpected_error;
442: END IF;
443:
444: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
445: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

Line 445: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

441: RAISE fnd_api.g_exc_unexpected_error;
442: END IF;
443:
444: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
445: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
446: then
447: fnd_msg_pub.Initialize;
448: end if;
449:

Line 468: x_return_status := fnd_api.g_ret_sts_unexp_error;

464: l_list.DELETE;
465:
466: EXCEPTION when OTHERS then
467: ROLLBACK TO del_emp_publish_save;
468: x_return_status := fnd_api.g_ret_sts_unexp_error;
469: END delete_resource;
470:
471:
472: PROCEDURE create_resource_role

Line 513: x_return_status := fnd_api.g_ret_sts_success;

509: l_manager_flag jtf_rs_roles_b.manager_flag%type := p_manager_flag;
510:
511: BEGIN
512:
513: x_return_status := fnd_api.g_ret_sts_success;
514: savepoint cr_res_role_publish_save;
515:
516: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
517: RAISE fnd_api.g_exc_unexpected_error;

Line 516: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

512:
513: x_return_status := fnd_api.g_ret_sts_success;
514: savepoint cr_res_role_publish_save;
515:
516: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
517: RAISE fnd_api.g_exc_unexpected_error;
518: END IF;
519:
520: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 517: RAISE fnd_api.g_exc_unexpected_error;

513: x_return_status := fnd_api.g_ret_sts_success;
514: savepoint cr_res_role_publish_save;
515:
516: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
517: RAISE fnd_api.g_exc_unexpected_error;
518: END IF;
519:
520: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
521: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

Line 521: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

517: RAISE fnd_api.g_exc_unexpected_error;
518: END IF;
519:
520: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
521: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
522: then
523: fnd_msg_pub.Initialize;
524: end if;
525:

Line 553: x_return_status := fnd_api.g_ret_sts_unexp_error;

549: l_list.DELETE;
550:
551: EXCEPTION when OTHERS then
552: ROLLBACK TO cr_res_role_publish_save;
553: x_return_status := fnd_api.g_ret_sts_unexp_error;
554:
555: END create_resource_role;
556:
557:

Line 608: x_return_status := fnd_api.g_ret_sts_success;

604: res_role_rec res_role_cur%rowtype;
605:
606: BEGIN
607:
608: x_return_status := fnd_api.g_ret_sts_success;
609: savepoint upd_res_role_publish_save;
610:
611: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
612: RAISE fnd_api.g_exc_unexpected_error;

Line 611: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

607:
608: x_return_status := fnd_api.g_ret_sts_success;
609: savepoint upd_res_role_publish_save;
610:
611: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
612: RAISE fnd_api.g_exc_unexpected_error;
613: END IF;
614:
615: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 612: RAISE fnd_api.g_exc_unexpected_error;

608: x_return_status := fnd_api.g_ret_sts_success;
609: savepoint upd_res_role_publish_save;
610:
611: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
612: RAISE fnd_api.g_exc_unexpected_error;
613: END IF;
614:
615: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
616: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

Line 616: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

612: RAISE fnd_api.g_exc_unexpected_error;
613: END IF;
614:
615: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
616: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
617: then
618: fnd_msg_pub.Initialize;
619: end if;
620:

Line 679: x_return_status := fnd_api.g_ret_sts_unexp_error;

675: CLOSE res_role_cur;
676:
677: EXCEPTION when OTHERS then
678: ROLLBACK TO upd_res_role_publish_save;
679: x_return_status := fnd_api.g_ret_sts_unexp_error;
680:
681: END update_resource_role;
682:
683: PROCEDURE delete_resource_role

Line 707: x_return_status := fnd_api.g_ret_sts_success;

703: l_role_id jtf_rs_roles_b.role_id%type := p_role_id;
704:
705: BEGIN
706:
707: x_return_status := fnd_api.g_ret_sts_success;
708: savepoint del_res_role_publish_save;
709:
710: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
711: RAISE fnd_api.g_exc_unexpected_error;

Line 710: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

706:
707: x_return_status := fnd_api.g_ret_sts_success;
708: savepoint del_res_role_publish_save;
709:
710: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
711: RAISE fnd_api.g_exc_unexpected_error;
712: END IF;
713:
714: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 711: RAISE fnd_api.g_exc_unexpected_error;

707: x_return_status := fnd_api.g_ret_sts_success;
708: savepoint del_res_role_publish_save;
709:
710: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
711: RAISE fnd_api.g_exc_unexpected_error;
712: END IF;
713:
714: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
715: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

Line 715: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

711: RAISE fnd_api.g_exc_unexpected_error;
712: END IF;
713:
714: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
715: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
716: then
717: fnd_msg_pub.Initialize;
718: end if;
719:

Line 738: x_return_status := fnd_api.g_ret_sts_unexp_error;

734: l_list.DELETE;
735:
736: EXCEPTION when OTHERS then
737: ROLLBACK TO del_res_role_publish_save;
738: x_return_status := fnd_api.g_ret_sts_unexp_error;
739: END delete_resource_role;
740:
741:
742: PROCEDURE create_resource_role_relate

Line 776: x_return_status := fnd_api.g_ret_sts_success;

772:
773:
774: BEGIN
775:
776: x_return_status := fnd_api.g_ret_sts_success;
777: savepoint cr_rolerelate_publish_save;
778:
779: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
780: RAISE fnd_api.g_exc_unexpected_error;

Line 779: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

775:
776: x_return_status := fnd_api.g_ret_sts_success;
777: savepoint cr_rolerelate_publish_save;
778:
779: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
780: RAISE fnd_api.g_exc_unexpected_error;
781: END IF;
782:
783: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 780: RAISE fnd_api.g_exc_unexpected_error;

776: x_return_status := fnd_api.g_ret_sts_success;
777: savepoint cr_rolerelate_publish_save;
778:
779: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
780: RAISE fnd_api.g_exc_unexpected_error;
781: END IF;
782:
783: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
784: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

Line 784: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

780: RAISE fnd_api.g_exc_unexpected_error;
781: END IF;
782:
783: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
784: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
785: then
786: fnd_msg_pub.Initialize;
787: end if;
788:

Line 812: x_return_status := fnd_api.g_ret_sts_unexp_error;

808: l_list.DELETE;
809:
810: EXCEPTION when OTHERS then
811: ROLLBACK TO cr_rolerelate_publish_save;
812: x_return_status := fnd_api.g_ret_sts_unexp_error;
813:
814: END create_resource_role_relate;
815:
816:

Line 859: x_return_status := fnd_api.g_ret_sts_success;

855: res_rolerelate_rec res_rolerelate_cur%rowtype;
856:
857: BEGIN
858:
859: x_return_status := fnd_api.g_ret_sts_success;
860: savepoint upd_rolerelate_publish_save;
861:
862: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
863: RAISE fnd_api.g_exc_unexpected_error;

Line 862: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

858:
859: x_return_status := fnd_api.g_ret_sts_success;
860: savepoint upd_rolerelate_publish_save;
861:
862: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
863: RAISE fnd_api.g_exc_unexpected_error;
864: END IF;
865:
866: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 863: RAISE fnd_api.g_exc_unexpected_error;

859: x_return_status := fnd_api.g_ret_sts_success;
860: savepoint upd_rolerelate_publish_save;
861:
862: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
863: RAISE fnd_api.g_exc_unexpected_error;
864: END IF;
865:
866: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
867: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

Line 867: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

863: RAISE fnd_api.g_exc_unexpected_error;
864: END IF;
865:
866: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
867: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
868: then
869: fnd_msg_pub.Initialize;
870: end if;
871:

Line 912: x_return_status := fnd_api.g_ret_sts_unexp_error;

908: CLOSE res_rolerelate_cur;
909:
910: EXCEPTION when OTHERS then
911: ROLLBACK TO upd_rolerelate_publish_save;
912: x_return_status := fnd_api.g_ret_sts_unexp_error;
913:
914: END update_resource_role_relate;
915:
916: PROCEDURE delete_resource_role_relate

Line 950: x_return_status := fnd_api.g_ret_sts_success;

946: del_rolerelate_rec del_rolerelate_cur%rowtype;
947:
948: BEGIN
949:
950: x_return_status := fnd_api.g_ret_sts_success;
951: savepoint del_rolerelate_publish_save;
952:
953: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
954: RAISE fnd_api.g_exc_unexpected_error;

Line 953: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

949:
950: x_return_status := fnd_api.g_ret_sts_success;
951: savepoint del_rolerelate_publish_save;
952:
953: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
954: RAISE fnd_api.g_exc_unexpected_error;
955: END IF;
956:
957: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 954: RAISE fnd_api.g_exc_unexpected_error;

950: x_return_status := fnd_api.g_ret_sts_success;
951: savepoint del_rolerelate_publish_save;
952:
953: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
954: RAISE fnd_api.g_exc_unexpected_error;
955: END IF;
956:
957: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
958: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

Line 958: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

954: RAISE fnd_api.g_exc_unexpected_error;
955: END IF;
956:
957: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
958: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
959: then
960: fnd_msg_pub.Initialize;
961: end if;
962:

Line 989: x_return_status := fnd_api.g_ret_sts_unexp_error;

985: CLOSE del_rolerelate_cur;
986:
987: EXCEPTION when OTHERS then
988: ROLLBACK TO del_rolerelate_publish_save;
989: x_return_status := fnd_api.g_ret_sts_unexp_error;
990: END delete_resource_role_relate;
991:
992: END jtf_rs_wf_events_pub;