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

Line 429: x_return_status := fnd_api.g_ret_sts_success;

425:
426: BEGIN
427:
428: SAVEPOINT import_resources;
429: x_return_status := fnd_api.g_ret_sts_success;
430:
431: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
432: RAISE fnd_api.g_exc_unexpected_error;
433: END IF;

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

427:
428: SAVEPOINT import_resources;
429: x_return_status := fnd_api.g_ret_sts_success;
430:
431: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
432: RAISE fnd_api.g_exc_unexpected_error;
433: END IF;
434:
435: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 432: RAISE fnd_api.g_exc_unexpected_error;

428: SAVEPOINT import_resources;
429: x_return_status := fnd_api.g_ret_sts_success;
430:
431: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
432: RAISE fnd_api.g_exc_unexpected_error;
433: END IF;
434:
435: IF fnd_api.to_boolean(p_init_msg_list) THEN
436: fnd_msg_pub.initialize;

Line 435: IF fnd_api.to_boolean(p_init_msg_list) THEN

431: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
432: RAISE fnd_api.g_exc_unexpected_error;
433: END IF;
434:
435: IF fnd_api.to_boolean(p_init_msg_list) THEN
436: fnd_msg_pub.initialize;
437: END IF;
438:
439: -- initializing the transaction number

Line 467: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

463: x_msg_data => l_msg_data,
464: x_role_relate_id => l_role_relate_id
465: );
466:
467: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
468: RAISE fnd_api.g_exc_error;
469: END IF;
470: END IF;
471: ELSIF (p_imp_res_tbl(i).comment_code = 'NEW') THEN

Line 468: RAISE fnd_api.g_exc_error;

464: x_role_relate_id => l_role_relate_id
465: );
466:
467: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
468: RAISE fnd_api.g_exc_error;
469: END IF;
470: END IF;
471: ELSIF (p_imp_res_tbl(i).comment_code = 'NEW') THEN
472: --if resource does not exist for the person then insert both resource

Line 564: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

560: p_source_mailstop => emp_rec.mailstop,
561: p_source_office => emp_rec.office_number,
562: p_source_location => emp_rec.internal_location
563: );
564: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
565: RAISE fnd_api.g_exc_error;
566: END IF;
567:
568: x_res_id_tbl(i).res_id := l_resource_id;

Line 565: RAISE fnd_api.g_exc_error;

561: p_source_office => emp_rec.office_number,
562: p_source_location => emp_rec.internal_location
563: );
564: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
565: RAISE fnd_api.g_exc_error;
566: END IF;
567:
568: x_res_id_tbl(i).res_id := l_resource_id;
569:

Line 575: RAISE fnd_api.g_exc_error;

571: IF p_imp_res_tbl(i).salesperson_number IS NULL THEN
572: fnd_message.set_name('JTF','JTF_RS_NO_SRP_NUM_ENT_FOR_EMP');
573: fnd_message.set_token('P_EMP_NAME',p_imp_res_tbl(i).name);
574: fnd_msg_pub.add;
575: RAISE fnd_api.g_exc_error;
576: ELSE
577: --Create a Salesperson for the Resource Created above
578: JTF_RS_SALESREPS_PUB.CREATE_SALESREP (
579: p_api_version => 1.0,

Line 603: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

599: x_msg_count => l_msg_count,
600: x_msg_data => l_msg_data,
601: x_salesrep_id => l_salesrep_id
602: );
603: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
604: RAISE fnd_api.g_exc_error;
605: END IF;
606: END IF;
607: END IF;

Line 604: RAISE fnd_api.g_exc_error;

600: x_msg_data => l_msg_data,
601: x_salesrep_id => l_salesrep_id
602: );
603: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
604: RAISE fnd_api.g_exc_error;
605: END IF;
606: END IF;
607: END IF;
608:

Line 638: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

634: x_msg_count => l_msg_count,
635: x_msg_data => l_msg_data,
636: x_role_relate_id => l_role_relate_id
637: );
638: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
639: RAISE fnd_api.g_exc_error;
640: END IF; -- end of check for l_return_status
641: END IF; -- end of check for SALES_COMP
642: END IF; -- end of check for j.role_id

Line 639: RAISE fnd_api.g_exc_error;

635: x_msg_data => l_msg_data,
636: x_role_relate_id => l_role_relate_id
637: );
638: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
639: RAISE fnd_api.g_exc_error;
640: END IF; -- end of check for l_return_status
641: END IF; -- end of check for SALES_COMP
642: END IF; -- end of check for j.role_id
643: END LOOP;

Line 703: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

699: p_source_category => null,
700: p_source_status => null,
701: p_user_name => p_imp_res_tbl(i).user_name
702: );
703: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
704: RAISE fnd_api.g_exc_error;
705: END IF;
706:
707: x_res_id_tbl(i).res_id := l_resource_id;

Line 704: RAISE fnd_api.g_exc_error;

700: p_source_status => null,
701: p_user_name => p_imp_res_tbl(i).user_name
702: );
703: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
704: RAISE fnd_api.g_exc_error;
705: END IF;
706:
707: x_res_id_tbl(i).res_id := l_resource_id;
708:

Line 787: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

783: p_source_category => null,
784: p_source_status => null,
785: p_user_name => p_imp_res_tbl(i).user_name
786: );
787: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
788: RAISE fnd_api.g_exc_error;
789: END IF;
790:
791: x_res_id_tbl(i).res_id := l_resource_id;

Line 788: RAISE fnd_api.g_exc_error;

784: p_source_status => null,
785: p_user_name => p_imp_res_tbl(i).user_name
786: );
787: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
788: RAISE fnd_api.g_exc_error;
789: END IF;
790:
791: x_res_id_tbl(i).res_id := l_resource_id;
792:

Line 844: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

840: p_source_category => null,
841: p_source_status => null,
842: p_user_name => p_imp_res_tbl(i).user_name
843: );
844: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
845: RAISE fnd_api.g_exc_error;
846: END IF;
847:
848: x_res_id_tbl(i).res_id := l_resource_id;

Line 845: RAISE fnd_api.g_exc_error;

841: p_source_status => null,
842: p_user_name => p_imp_res_tbl(i).user_name
843: );
844: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
845: RAISE fnd_api.g_exc_error;
846: END IF;
847:
848: x_res_id_tbl(i).res_id := l_resource_id;
849:

Line 874: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

870: p_source_name => p_imp_res_tbl(i).name,
871: p_resource_name => p_imp_res_tbl(i).name,
872: p_user_name => p_imp_res_tbl(i).user_name
873: );
874: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
875: RAISE fnd_api.g_exc_error;
876: END IF;
877:
878: x_res_id_tbl(i).res_id := l_resource_id;

Line 875: RAISE fnd_api.g_exc_error;

871: p_resource_name => p_imp_res_tbl(i).name,
872: p_user_name => p_imp_res_tbl(i).user_name
873: );
874: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
875: RAISE fnd_api.g_exc_error;
876: END IF;
877:
878: x_res_id_tbl(i).res_id := l_resource_id;
879:

Line 898: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

894: x_msg_count => l_msg_count,
895: x_msg_data => l_msg_data,
896: x_role_relate_id => l_role_relate_id
897: );
898: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
899: RAISE fnd_api.g_exc_error;
900: END IF;
901: END IF;
902: END IF;

Line 899: RAISE fnd_api.g_exc_error;

895: x_msg_data => l_msg_data,
896: x_role_relate_id => l_role_relate_id
897: );
898: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
899: RAISE fnd_api.g_exc_error;
900: END IF;
901: END IF;
902: END IF;
903: END IF;

Line 910: IF fnd_api.to_boolean(p_commit) THEN

906: i := p_imp_res_tbl.NEXT(i);
907: END LOOP;
908: END IF;
909:
910: IF fnd_api.to_boolean(p_commit) THEN
911: COMMIT WORK;
912: END IF;
913:
914: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 917: WHEN fnd_api.g_exc_error THEN

913:
914: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
915:
916: EXCEPTION
917: WHEN fnd_api.g_exc_error THEN
918: ROLLBACK TO import_resources;
919: x_return_status := fnd_api.g_ret_sts_error;
920: x_transaction_num := NULL;
921: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

Line 919: x_return_status := fnd_api.g_ret_sts_error;

915:
916: EXCEPTION
917: WHEN fnd_api.g_exc_error THEN
918: ROLLBACK TO import_resources;
919: x_return_status := fnd_api.g_ret_sts_error;
920: x_transaction_num := NULL;
921: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
922: p_data => x_msg_data);
923: WHEN fnd_api.g_exc_unexpected_error THEN

Line 923: WHEN fnd_api.g_exc_unexpected_error THEN

919: x_return_status := fnd_api.g_ret_sts_error;
920: x_transaction_num := NULL;
921: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
922: p_data => x_msg_data);
923: WHEN fnd_api.g_exc_unexpected_error THEN
924: ROLLBACK TO import_resources;
925: x_return_status := fnd_api.g_ret_sts_unexp_error;
926: x_transaction_num := NULL;
927: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

Line 925: x_return_status := fnd_api.g_ret_sts_unexp_error;

921: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
922: p_data => x_msg_data);
923: WHEN fnd_api.g_exc_unexpected_error THEN
924: ROLLBACK TO import_resources;
925: x_return_status := fnd_api.g_ret_sts_unexp_error;
926: x_transaction_num := NULL;
927: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
928: p_data => x_msg_data);
929: WHEN OTHERS THEN

Line 936: x_return_status := fnd_api.g_ret_sts_unexp_error;

932: fnd_message.set_token('P_SQLCODE',SQLCODE);
933: fnd_message.set_token('P_SQLERRM',SQLERRM);
934: fnd_message.set_token('P_API_NAME',l_api_name);
935: FND_MSG_PUB.add;
936: x_return_status := fnd_api.g_ret_sts_unexp_error;
937: x_transaction_num := NULL;
938: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
939: p_data => x_msg_data);
940: