DBA Data[Home] [Help]

APPS.JTF_AM_WF_EVENTS_PUB dependencies on FND_API

Line 80: x_return_status := fnd_api.g_ret_sts_success;

76: l_event_name varchar2(240) := 'oracle.apps.jtf.jasg.sr.assign';
77:
78: BEGIN
79:
80: x_return_status := fnd_api.g_ret_sts_success;
81: savepoint asg_publish_save;
82:
83: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
84: RAISE fnd_api.g_exc_unexpected_error;

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

79:
80: x_return_status := fnd_api.g_ret_sts_success;
81: savepoint asg_publish_save;
82:
83: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
84: RAISE fnd_api.g_exc_unexpected_error;
85: END IF;
86:
87: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 84: RAISE fnd_api.g_exc_unexpected_error;

80: x_return_status := fnd_api.g_ret_sts_success;
81: savepoint asg_publish_save;
82:
83: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
84: RAISE fnd_api.g_exc_unexpected_error;
85: END IF;
86:
87: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
88: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

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

84: RAISE fnd_api.g_exc_unexpected_error;
85: END IF;
86:
87: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
88: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
89: then
90: fnd_msg_pub.Initialize;
91: end if;
92:

Line 346: x_return_status := fnd_api.g_ret_sts_unexp_error;

342: l_list.DELETE;
343:
344: EXCEPTION when OTHERS then
345: ROLLBACK TO asg_publish_save;
346: x_return_status := fnd_api.g_ret_sts_unexp_error;
347:
348: END assign_sr_resource;
349:
350: /*********** Added by SBARAT on 01/11/2004 for Enh-3919046 ***********/

Line 381: x_return_status := fnd_api.g_ret_sts_success;

377: l_event_name varchar2(240) := 'oracle.apps.jtf.jasg.dr.assign';
378:
379: BEGIN
380:
381: x_return_status := fnd_api.g_ret_sts_success;
382: savepoint asg_publish_save;
383:
384: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
385: RAISE fnd_api.g_exc_unexpected_error;

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

380:
381: x_return_status := fnd_api.g_ret_sts_success;
382: savepoint asg_publish_save;
383:
384: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
385: RAISE fnd_api.g_exc_unexpected_error;
386: END IF;
387:
388: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 385: RAISE fnd_api.g_exc_unexpected_error;

381: x_return_status := fnd_api.g_ret_sts_success;
382: savepoint asg_publish_save;
383:
384: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
385: RAISE fnd_api.g_exc_unexpected_error;
386: END IF;
387:
388: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
389: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

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

385: RAISE fnd_api.g_exc_unexpected_error;
386: END IF;
387:
388: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
389: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
390: then
391: fnd_msg_pub.Initialize;
392: end if;
393:

Line 482: x_return_status := fnd_api.g_ret_sts_unexp_error;

478: l_list.DELETE;
479:
480: EXCEPTION when OTHERS then
481: ROLLBACK TO asg_publish_save;
482: x_return_status := fnd_api.g_ret_sts_unexp_error;
483:
484: END assign_dr_resource;
485:
486: /*********** End of addition by SBARAT on 01/11/2004 for Enh-3919046 ***********/

Line 517: x_return_status := fnd_api.g_ret_sts_success;

513: l_event_name varchar2(240) := 'oracle.apps.jtf.jasg.task.assign';
514:
515: BEGIN
516:
517: x_return_status := fnd_api.g_ret_sts_success;
518: savepoint asg_task_publish_save;
519:
520: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
521: RAISE fnd_api.g_exc_unexpected_error;

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

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

Line 521: RAISE fnd_api.g_exc_unexpected_error;

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

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

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

Line 555: x_return_status := fnd_api.g_ret_sts_unexp_error;

551: l_list.DELETE;
552:
553: EXCEPTION when OTHERS then
554: ROLLBACK TO asg_task_publish_save;
555: x_return_status := fnd_api.g_ret_sts_unexp_error;
556:
557: END assign_task_resource;
558:
559:

Line 583: x_return_status := fnd_api.g_ret_sts_success;

579: l_event_name varchar2(240) := 'oracle.apps.jtf.jasg.esc.assign';
580:
581: BEGIN
582:
583: x_return_status := fnd_api.g_ret_sts_success;
584: savepoint asg_esc_publish_save;
585:
586: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
587: RAISE fnd_api.g_exc_unexpected_error;

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

582:
583: x_return_status := fnd_api.g_ret_sts_success;
584: savepoint asg_esc_publish_save;
585:
586: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
587: RAISE fnd_api.g_exc_unexpected_error;
588: END IF;
589:
590: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 587: RAISE fnd_api.g_exc_unexpected_error;

583: x_return_status := fnd_api.g_ret_sts_success;
584: savepoint asg_esc_publish_save;
585:
586: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
587: RAISE fnd_api.g_exc_unexpected_error;
588: END IF;
589:
590: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
591: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

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

587: RAISE fnd_api.g_exc_unexpected_error;
588: END IF;
589:
590: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
591: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
592: then
593: fnd_msg_pub.Initialize;
594: end if;
595:

Line 619: x_return_status := fnd_api.g_ret_sts_unexp_error;

615: l_list.DELETE;
616:
617: EXCEPTION when OTHERS then
618: ROLLBACK TO asg_esc_publish_save;
619: x_return_status := fnd_api.g_ret_sts_unexp_error;
620:
621: END assign_esc_resource;
622:
623:

Line 651: x_return_status := fnd_api.g_ret_sts_success;

647: l_event_name varchar2(240) := 'oracle.apps.jtf.jasg.def.assign';
648:
649: BEGIN
650:
651: x_return_status := fnd_api.g_ret_sts_success;
652: savepoint asg_def_publish_save;
653:
654: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
655: RAISE fnd_api.g_exc_unexpected_error;

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

650:
651: x_return_status := fnd_api.g_ret_sts_success;
652: savepoint asg_def_publish_save;
653:
654: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
655: RAISE fnd_api.g_exc_unexpected_error;
656: END IF;
657:
658: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 655: RAISE fnd_api.g_exc_unexpected_error;

651: x_return_status := fnd_api.g_ret_sts_success;
652: savepoint asg_def_publish_save;
653:
654: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
655: RAISE fnd_api.g_exc_unexpected_error;
656: END IF;
657:
658: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
659: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

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

655: RAISE fnd_api.g_exc_unexpected_error;
656: END IF;
657:
658: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
659: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
660: then
661: fnd_msg_pub.Initialize;
662: end if;
663:

Line 758: x_return_status := fnd_api.g_ret_sts_unexp_error;

754: l_list.DELETE;
755:
756: EXCEPTION when OTHERS then
757: ROLLBACK TO asg_def_publish_save;
758: x_return_status := fnd_api.g_ret_sts_unexp_error;
759:
760: END assign_def_resource;
761:
762:

Line 786: x_return_status := fnd_api.g_ret_sts_success;

782: l_event_name varchar2(240) := 'oracle.apps.jtf.jasg.acc.assign';
783:
784: BEGIN
785:
786: x_return_status := fnd_api.g_ret_sts_success;
787: savepoint asg_acc_publish_save;
788:
789: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
790: RAISE fnd_api.g_exc_unexpected_error;

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

785:
786: x_return_status := fnd_api.g_ret_sts_success;
787: savepoint asg_acc_publish_save;
788:
789: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
790: RAISE fnd_api.g_exc_unexpected_error;
791: END IF;
792:
793: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 790: RAISE fnd_api.g_exc_unexpected_error;

786: x_return_status := fnd_api.g_ret_sts_success;
787: savepoint asg_acc_publish_save;
788:
789: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
790: RAISE fnd_api.g_exc_unexpected_error;
791: END IF;
792:
793: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
794: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

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

790: RAISE fnd_api.g_exc_unexpected_error;
791: END IF;
792:
793: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
794: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
795: then
796: fnd_msg_pub.Initialize;
797: end if;
798:

Line 857: x_return_status := fnd_api.g_ret_sts_unexp_error;

853: l_list.DELETE;
854:
855: EXCEPTION when OTHERS then
856: ROLLBACK TO asg_acc_publish_save;
857: x_return_status := fnd_api.g_ret_sts_unexp_error;
858:
859: END assign_acc_resource;
860:
861:

Line 886: x_return_status := fnd_api.g_ret_sts_success;

882: l_event_name varchar2(240) := 'oracle.apps.jtf.jasg.oppr.assign';
883:
884: BEGIN
885:
886: x_return_status := fnd_api.g_ret_sts_success;
887: savepoint asg_oppr_publish_save;
888:
889: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
890: RAISE fnd_api.g_exc_unexpected_error;

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

885:
886: x_return_status := fnd_api.g_ret_sts_success;
887: savepoint asg_oppr_publish_save;
888:
889: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
890: RAISE fnd_api.g_exc_unexpected_error;
891: END IF;
892:
893: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 890: RAISE fnd_api.g_exc_unexpected_error;

886: x_return_status := fnd_api.g_ret_sts_success;
887: savepoint asg_oppr_publish_save;
888:
889: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
890: RAISE fnd_api.g_exc_unexpected_error;
891: END IF;
892:
893: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
894: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

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

890: RAISE fnd_api.g_exc_unexpected_error;
891: END IF;
892:
893: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
894: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
895: then
896: fnd_msg_pub.Initialize;
897: end if;
898:

Line 973: x_return_status := fnd_api.g_ret_sts_unexp_error;

969: l_list.DELETE;
970:
971: EXCEPTION when OTHERS then
972: ROLLBACK TO asg_oppr_publish_save;
973: x_return_status := fnd_api.g_ret_sts_unexp_error;
974:
975: END assign_oppr_resource;
976:
977:

Line 1003: x_return_status := fnd_api.g_ret_sts_success;

999: i Number;
1000:
1001: BEGIN
1002:
1003: x_return_status := fnd_api.g_ret_sts_success;
1004: savepoint asg_lead_publish_save;
1005:
1006: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1007: RAISE fnd_api.g_exc_unexpected_error;

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

1002:
1003: x_return_status := fnd_api.g_ret_sts_success;
1004: savepoint asg_lead_publish_save;
1005:
1006: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1007: RAISE fnd_api.g_exc_unexpected_error;
1008: END IF;
1009:
1010: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE

Line 1007: RAISE fnd_api.g_exc_unexpected_error;

1003: x_return_status := fnd_api.g_ret_sts_success;
1004: savepoint asg_lead_publish_save;
1005:
1006: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1007: RAISE fnd_api.g_exc_unexpected_error;
1008: END IF;
1009:
1010: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
1011: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)

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

1007: RAISE fnd_api.g_exc_unexpected_error;
1008: END IF;
1009:
1010: --Initialize the message List if P_INIT_MSG_LIST is NOT NULL and set to TRUE
1011: if p_init_msg_list is not NULL AND fnd_api.to_boolean(p_init_msg_list)
1012: then
1013: fnd_msg_pub.Initialize;
1014: end if;
1015:

Line 1454: x_return_status := fnd_api.g_ret_sts_unexp_error;

1450: END IF;
1451:
1452: EXCEPTION when OTHERS then
1453: ROLLBACK TO asg_lead_publish_save;
1454: x_return_status := fnd_api.g_ret_sts_unexp_error;
1455:
1456: END assign_lead_resource;
1457:
1458: /********************** End of Addition for Enh. No 3076744 by SBARAT, 20/09/2004 ************************/