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 437: x_return_status := fnd_api.g_ret_sts_success;

433:
434: BEGIN
435:
436: SAVEPOINT import_resources;
437: x_return_status := fnd_api.g_ret_sts_success;
438:
439: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
440: RAISE fnd_api.g_exc_unexpected_error;
441: END IF;

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

435:
436: SAVEPOINT import_resources;
437: x_return_status := fnd_api.g_ret_sts_success;
438:
439: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
440: RAISE fnd_api.g_exc_unexpected_error;
441: END IF;
442:
443: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 440: RAISE fnd_api.g_exc_unexpected_error;

436: SAVEPOINT import_resources;
437: x_return_status := fnd_api.g_ret_sts_success;
438:
439: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
440: RAISE fnd_api.g_exc_unexpected_error;
441: END IF;
442:
443: IF fnd_api.to_boolean(p_init_msg_list) THEN
444: fnd_msg_pub.initialize;

Line 443: IF fnd_api.to_boolean(p_init_msg_list) THEN

439: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
440: RAISE fnd_api.g_exc_unexpected_error;
441: END IF;
442:
443: IF fnd_api.to_boolean(p_init_msg_list) THEN
444: fnd_msg_pub.initialize;
445: END IF;
446:
447: -- initializing the transaction number

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

471: x_msg_data => l_msg_data,
472: x_role_relate_id => l_role_relate_id
473: );
474:
475: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
476: RAISE fnd_api.g_exc_error;
477: END IF;
478: END IF;
479: ELSIF (p_imp_res_tbl(i).comment_code = 'NEW') THEN

Line 476: RAISE fnd_api.g_exc_error;

472: x_role_relate_id => l_role_relate_id
473: );
474:
475: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
476: RAISE fnd_api.g_exc_error;
477: END IF;
478: END IF;
479: ELSIF (p_imp_res_tbl(i).comment_code = 'NEW') THEN
480: --if resource does not exist for the person then insert both resource

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

568: p_source_mailstop => emp_rec.mailstop,
569: p_source_office => emp_rec.office_number,
570: p_source_location => emp_rec.internal_location
571: );
572: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
573: RAISE fnd_api.g_exc_error;
574: END IF;
575:
576: x_res_id_tbl(i).res_id := l_resource_id;

Line 573: RAISE fnd_api.g_exc_error;

569: p_source_office => emp_rec.office_number,
570: p_source_location => emp_rec.internal_location
571: );
572: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
573: RAISE fnd_api.g_exc_error;
574: END IF;
575:
576: x_res_id_tbl(i).res_id := l_resource_id;
577:

Line 583: RAISE fnd_api.g_exc_error;

579: IF p_imp_res_tbl(i).salesperson_number IS NULL THEN
580: fnd_message.set_name('JTF','JTF_RS_NO_SRP_NUM_ENT_FOR_EMP');
581: fnd_message.set_token('P_EMP_NAME',p_imp_res_tbl(i).name);
582: fnd_msg_pub.add;
583: RAISE fnd_api.g_exc_error;
584: ELSE
585: --Create a Salesperson for the Resource Created above
586: JTF_RS_SALESREPS_PUB.CREATE_SALESREP (
587: p_api_version => 1.0,

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

607: x_msg_count => l_msg_count,
608: x_msg_data => l_msg_data,
609: x_salesrep_id => l_salesrep_id
610: );
611: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
612: RAISE fnd_api.g_exc_error;
613: END IF;
614: END IF;
615: END IF;

Line 612: RAISE fnd_api.g_exc_error;

608: x_msg_data => l_msg_data,
609: x_salesrep_id => l_salesrep_id
610: );
611: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
612: RAISE fnd_api.g_exc_error;
613: END IF;
614: END IF;
615: END IF;
616:

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

642: x_msg_count => l_msg_count,
643: x_msg_data => l_msg_data,
644: x_role_relate_id => l_role_relate_id
645: );
646: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
647: RAISE fnd_api.g_exc_error;
648: END IF; -- end of check for l_return_status
649: END IF; -- end of check for SALES_COMP
650: END IF; -- end of check for j.role_id

Line 647: RAISE fnd_api.g_exc_error;

643: x_msg_data => l_msg_data,
644: x_role_relate_id => l_role_relate_id
645: );
646: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
647: RAISE fnd_api.g_exc_error;
648: END IF; -- end of check for l_return_status
649: END IF; -- end of check for SALES_COMP
650: END IF; -- end of check for j.role_id
651: END LOOP;

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

707: p_source_category => null,
708: p_source_status => null,
709: p_user_name => p_imp_res_tbl(i).user_name
710: );
711: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
712: RAISE fnd_api.g_exc_error;
713: END IF;
714:
715: x_res_id_tbl(i).res_id := l_resource_id;

Line 712: RAISE fnd_api.g_exc_error;

708: p_source_status => null,
709: p_user_name => p_imp_res_tbl(i).user_name
710: );
711: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
712: RAISE fnd_api.g_exc_error;
713: END IF;
714:
715: x_res_id_tbl(i).res_id := l_resource_id;
716:

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

791: p_source_category => null,
792: p_source_status => null,
793: p_user_name => p_imp_res_tbl(i).user_name
794: );
795: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
796: RAISE fnd_api.g_exc_error;
797: END IF;
798:
799: x_res_id_tbl(i).res_id := l_resource_id;

Line 796: RAISE fnd_api.g_exc_error;

792: p_source_status => null,
793: p_user_name => p_imp_res_tbl(i).user_name
794: );
795: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
796: RAISE fnd_api.g_exc_error;
797: END IF;
798:
799: x_res_id_tbl(i).res_id := l_resource_id;
800:

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

848: p_source_category => null,
849: p_source_status => null,
850: p_user_name => p_imp_res_tbl(i).user_name
851: );
852: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
853: RAISE fnd_api.g_exc_error;
854: END IF;
855:
856: x_res_id_tbl(i).res_id := l_resource_id;

Line 853: RAISE fnd_api.g_exc_error;

849: p_source_status => null,
850: p_user_name => p_imp_res_tbl(i).user_name
851: );
852: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
853: RAISE fnd_api.g_exc_error;
854: END IF;
855:
856: x_res_id_tbl(i).res_id := l_resource_id;
857:

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

878: p_source_name => p_imp_res_tbl(i).name,
879: p_resource_name => p_imp_res_tbl(i).name,
880: p_user_name => p_imp_res_tbl(i).user_name
881: );
882: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
883: RAISE fnd_api.g_exc_error;
884: END IF;
885:
886: x_res_id_tbl(i).res_id := l_resource_id;

Line 883: RAISE fnd_api.g_exc_error;

879: p_resource_name => p_imp_res_tbl(i).name,
880: p_user_name => p_imp_res_tbl(i).user_name
881: );
882: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
883: RAISE fnd_api.g_exc_error;
884: END IF;
885:
886: x_res_id_tbl(i).res_id := l_resource_id;
887:

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

902: x_msg_count => l_msg_count,
903: x_msg_data => l_msg_data,
904: x_role_relate_id => l_role_relate_id
905: );
906: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
907: RAISE fnd_api.g_exc_error;
908: END IF;
909: END IF;
910: END IF;

Line 907: RAISE fnd_api.g_exc_error;

903: x_msg_data => l_msg_data,
904: x_role_relate_id => l_role_relate_id
905: );
906: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
907: RAISE fnd_api.g_exc_error;
908: END IF;
909: END IF;
910: END IF;
911: END IF;

Line 918: IF fnd_api.to_boolean(p_commit) THEN

914: i := p_imp_res_tbl.NEXT(i);
915: END LOOP;
916: END IF;
917:
918: IF fnd_api.to_boolean(p_commit) THEN
919: COMMIT WORK;
920: END IF;
921:
922: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 925: WHEN fnd_api.g_exc_error THEN

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

Line 927: x_return_status := fnd_api.g_ret_sts_error;

923:
924: EXCEPTION
925: WHEN fnd_api.g_exc_error THEN
926: ROLLBACK TO import_resources;
927: x_return_status := fnd_api.g_ret_sts_error;
928: x_transaction_num := NULL;
929: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
930: p_data => x_msg_data);
931: WHEN fnd_api.g_exc_unexpected_error THEN

Line 931: WHEN fnd_api.g_exc_unexpected_error THEN

927: x_return_status := fnd_api.g_ret_sts_error;
928: x_transaction_num := NULL;
929: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
930: p_data => x_msg_data);
931: WHEN fnd_api.g_exc_unexpected_error THEN
932: ROLLBACK TO import_resources;
933: x_return_status := fnd_api.g_ret_sts_unexp_error;
934: x_transaction_num := NULL;
935: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

Line 933: x_return_status := fnd_api.g_ret_sts_unexp_error;

929: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
930: p_data => x_msg_data);
931: WHEN fnd_api.g_exc_unexpected_error THEN
932: ROLLBACK TO import_resources;
933: x_return_status := fnd_api.g_ret_sts_unexp_error;
934: x_transaction_num := NULL;
935: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
936: p_data => x_msg_data);
937: WHEN OTHERS THEN

Line 944: x_return_status := fnd_api.g_ret_sts_unexp_error;

940: fnd_message.set_token('P_SQLCODE',SQLCODE);
941: fnd_message.set_token('P_SQLERRM',SQLERRM);
942: fnd_message.set_token('P_API_NAME',l_api_name);
943: FND_MSG_PUB.add;
944: x_return_status := fnd_api.g_ret_sts_unexp_error;
945: x_transaction_num := NULL;
946: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
947: p_data => x_msg_data);
948: