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_ROLE_RELATE_PVT dependencies on FND_MESSAGE

Line 101: fnd_message.set_name ('JTF', 'JTF_RS_RES_DATE_ERR');

97: IF((rsc_rec.start_date_active > p_new_start_date)
98: -- changed by sudarsana 11 feb 2002
99: OR (rsc_rec.end_date_active < to_date(to_char(nvl(p_new_end_date, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR')))
100: THEN
101: fnd_message.set_name ('JTF', 'JTF_RS_RES_DATE_ERR');
102: FND_MSG_PUB.add;
103: l_valid := FALSE;
104: END IF;
105:

Line 122: fnd_message.set_name ('JTF', 'JTF_RS_RES_UPD_DT_ERR');

118: end if;
119:
120: if NOT(l_grp_valid)
121: then
122: fnd_message.set_name ('JTF', 'JTF_RS_RES_UPD_DT_ERR');
123: FND_MSG_PUB.add;
124: exit;
125: end if;
126: end loop; --end of grp_mem_cur

Line 144: fnd_message.set_name ('JTF', 'JTF_RS_RES_UPD_DT_ERR');

140: end if;
141:
142: if NOT(l_team_valid)
143: then
144: fnd_message.set_name ('JTF', 'JTF_RS_RES_UPD_DT_ERR');
145: FND_MSG_PUB.add;
146: exit;
147: end if;
148: end loop; --end of grp_mem_cur

Line 536: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

532: p_data => L_data,
533: p_count => L_count,
534: P_return_code => l_return_code);
535: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
536: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
537: FND_MSG_PUB.add;
538: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
539: RAISE FND_API.G_EXC_ERROR;
540: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 563: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

559: p_data => L_data,
560: p_count => L_count,
561: P_return_code => l_return_code);
562: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
563: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
564: FND_MSG_PUB.add;
565: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
566: RAISE FND_API.G_EXC_ERROR;
567: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 590: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

586: p_data => L_data,
587: p_count => L_count,
588: P_return_code => l_return_code);
589: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
590: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
591: FND_MSG_PUB.add;
592: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
593: RAISE FND_API.G_EXC_ERROR;
594: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 609: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');

605:
606: --check start date null
607: IF(l_start_date_active is NULL)
608: THEN
609: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
610: FND_MSG_PUB.add;
611: RAISE fnd_api.g_exc_error;
612: END IF;
613:

Line 618: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');

614:
615: --check start date less than end date
616: IF(l_start_date_active > l_end_date_active)
617: THEN
618: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
619: FND_MSG_PUB.add;
620: RAISE fnd_api.g_exc_error;
621: END IF;
622:

Line 633: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_TYPE_INACTIVE');

629: l_end_date_active,
630: l_role_type_valid);
631:
632: if (l_role_type_valid = false) then
633: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_TYPE_INACTIVE');
634: FND_MSG_PUB.add;
635: RAISE fnd_api.g_exc_error;
636: end if;
637: END IF;

Line 685: fnd_message.set_name ('JTF', 'JTF_RS_OVERLAP_DATE_ERR');

681: CLOSE check_date_cur;
682:
683: IF(l_date_invalid)
684: THEN
685: fnd_message.set_name ('JTF', 'JTF_RS_OVERLAP_DATE_ERR');
686: FND_MSG_PUB.add;
687: RAISE fnd_api.g_exc_error;
688: END IF;
689: --end of overlapping date range check

Line 709: fnd_message.set_name('JTF','JTF_RS_INVALID_GRP_MBR_ID');

705: OPEN grp_mem_cur(l_role_resource_id);
706: FETCH grp_mem_cur INTO l_rsc_id;
707: IF(grp_mem_cur%notfound)
708: THEN
709: fnd_message.set_name('JTF','JTF_RS_INVALID_GRP_MBR_ID');
710: fnd_message.set_token('P_GRP_MBR_ID',l_role_resource_id);
711: fnd_msg_pub.add;
712: RAISE fnd_api.g_exc_error;
713: END IF;

Line 710: fnd_message.set_token('P_GRP_MBR_ID',l_role_resource_id);

706: FETCH grp_mem_cur INTO l_rsc_id;
707: IF(grp_mem_cur%notfound)
708: THEN
709: fnd_message.set_name('JTF','JTF_RS_INVALID_GRP_MBR_ID');
710: fnd_message.set_token('P_GRP_MBR_ID',l_role_resource_id);
711: fnd_msg_pub.add;
712: RAISE fnd_api.g_exc_error;
713: END IF;
714: CLOSE grp_mem_cur;

Line 738: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_OR_DATE_ERR');

734: l_role_valid := TRUE;
735:
736: ELSE
737: l_role_valid := FALSE;
738: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_OR_DATE_ERR');
739: FND_MSG_PUB.add;
740: RAISE fnd_api.g_exc_error;
741: END IF;
742: close res_role_cur;

Line 762: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_OR_DATE_ERR');

758: l_role_valid := TRUE;
759:
760: ELSE
761: l_role_valid := FALSE;
762: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_OR_DATE_ERR');
763: FND_MSG_PUB.add;
764: RAISE fnd_api.g_exc_error;
765: END IF;
766: close grp_role_cur;

Line 787: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');

783: -- IF((trunc(team_rec.start_date_active) > trunc(l_start_date_active))
784: IF (( to_date(to_char(nvl(team_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
785: OR to_date(to_char(nvl(team_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
786: THEN
787: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
788: FND_MSG_PUB.add;
789: RAISE fnd_api.g_exc_error;
790: END IF;
791:

Line 794: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');

790: END IF;
791:
792: IF(team_rec.end_date_active is not null AND l_end_date_active is null)
793: THEN
794: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
795: FND_MSG_PUB.add;
796: RAISE fnd_api.g_exc_error;
797: END IF;
798:

Line 813: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');

809: --IF((trunc(group_rec.start_date_active) > trunc(l_start_date_active))
810: IF (( to_date(to_char(nvl(group_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
811: OR to_date(to_char(nvl(group_rec.end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR'))
812: THEN
813: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
814: FND_MSG_PUB.add;
815: RAISE fnd_api.g_exc_error;
816: END IF;
817:

Line 821: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');

817:
818:
819: IF(group_rec.end_date_active is not null AND l_end_date_active is null)
820: THEN
821: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
822: FND_MSG_PUB.add;
823: RAISE fnd_api.g_exc_error;
824: END IF;
825:

Line 834: fnd_message.set_name ('JTF', 'JTF_RS_RES_USAGE_ERR');

830:
831: fetch c_exclusive_group_check_cur into c_exclusive_group_check_rec;
832: IF(c_exclusive_group_check_cur%FOUND)
833: THEN
834: fnd_message.set_name ('JTF', 'JTF_RS_RES_USAGE_ERR');
835: FND_MSG_PUB.add;
836: RAISE fnd_api.g_exc_error;
837: END IF;
838:

Line 851: fnd_message.set_name ('JTF', 'JTF_RS_RES_DATE_ERR');

847: IF((rsc_rec.start_date_active > l_start_date_active)
848: -- changed by sudarsana 11 feb 2002
849: OR (rsc_rec.end_date_active < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date), 'DD-MM-RRRR'), 'DD-MM-RRRR')))
850: THEN
851: fnd_message.set_name ('JTF', 'JTF_RS_RES_DATE_ERR');
852: FND_MSG_PUB.add;
853: RAISE fnd_api.g_exc_error;
854: END IF;
855: ELSIF(l_role_resource_type = 'RS_GROUP')

Line 867: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DT_ERR');

863: --OR (group_dt_rec.end_date_active < l_end_date_active))
864: OR (to_date(to_char(nvl(group_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
865: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
866: THEN
867: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DT_ERR');
868: FND_MSG_PUB.add;
869: RAISE fnd_api.g_exc_error;
870: END IF;
871: ELSIF(l_role_resource_type = 'RS_TEAM')

Line 883: fnd_message.set_name ('JTF', 'JTF_RS_TEAM_DT_ERR');

879: --OR (team_dt_rec.end_date_active < l_end_date_active))
880: OR (to_date(to_char(nvl(team_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
881: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
882: THEN
883: fnd_message.set_name ('JTF', 'JTF_RS_TEAM_DT_ERR');
884: FND_MSG_PUB.add;
885: RAISE fnd_api.g_exc_error;
886: END IF;
887: END IF;

Line 1019: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

1015: l_login_id);
1016:
1017: exception
1018: when others then
1019: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1020: fnd_message.set_token('P_SQLCODE',SQLCODE);
1021: fnd_message.set_token('P_SQLERRM',SQLERRM);
1022: fnd_message.set_token('P_API_NAME', l_api_name);
1023: FND_MSG_PUB.add;

Line 1020: fnd_message.set_token('P_SQLCODE',SQLCODE);

1016:
1017: exception
1018: when others then
1019: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1020: fnd_message.set_token('P_SQLCODE',SQLCODE);
1021: fnd_message.set_token('P_SQLERRM',SQLERRM);
1022: fnd_message.set_token('P_API_NAME', l_api_name);
1023: FND_MSG_PUB.add;
1024: RAISE fnd_api.g_exc_unexpected_error;

Line 1021: fnd_message.set_token('P_SQLERRM',SQLERRM);

1017: exception
1018: when others then
1019: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1020: fnd_message.set_token('P_SQLCODE',SQLCODE);
1021: fnd_message.set_token('P_SQLERRM',SQLERRM);
1022: fnd_message.set_token('P_API_NAME', l_api_name);
1023: FND_MSG_PUB.add;
1024: RAISE fnd_api.g_exc_unexpected_error;
1025:

Line 1022: fnd_message.set_token('P_API_NAME', l_api_name);

1018: when others then
1019: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1020: fnd_message.set_token('P_SQLCODE',SQLCODE);
1021: fnd_message.set_token('P_SQLERRM',SQLERRM);
1022: fnd_message.set_token('P_API_NAME', l_api_name);
1023: FND_MSG_PUB.add;
1024: RAISE fnd_api.g_exc_unexpected_error;
1025:
1026:

Line 1040: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');

1036: open conc_prog_cur;
1037: fetch conc_prog_cur into g_name;
1038: close conc_prog_cur;
1039:
1040: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
1041: fnd_message.set_token('P_NAME',g_name);
1042: fnd_message.set_token('P_ID',l_request);
1043: FND_MSG_PUB.add;
1044:

Line 1041: fnd_message.set_token('P_NAME',g_name);

1037: fetch conc_prog_cur into g_name;
1038: close conc_prog_cur;
1039:
1040: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
1041: fnd_message.set_token('P_NAME',g_name);
1042: fnd_message.set_token('P_ID',l_request);
1043: FND_MSG_PUB.add;
1044:
1045: exception when others then

Line 1042: fnd_message.set_token('P_ID',l_request);

1038: close conc_prog_cur;
1039:
1040: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
1041: fnd_message.set_token('P_NAME',g_name);
1042: fnd_message.set_token('P_ID',l_request);
1043: FND_MSG_PUB.add;
1044:
1045: exception when others then
1046: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 1046: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

1042: fnd_message.set_token('P_ID',l_request);
1043: FND_MSG_PUB.add;
1044:
1045: exception when others then
1046: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1047: fnd_message.set_token('P_SQLCODE',SQLCODE);
1048: fnd_message.set_token('P_SQLERRM',SQLERRM);
1049: fnd_message.set_token('P_API_NAME', l_api_name);
1050: FND_MSG_PUB.add;

Line 1047: fnd_message.set_token('P_SQLCODE',SQLCODE);

1043: FND_MSG_PUB.add;
1044:
1045: exception when others then
1046: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1047: fnd_message.set_token('P_SQLCODE',SQLCODE);
1048: fnd_message.set_token('P_SQLERRM',SQLERRM);
1049: fnd_message.set_token('P_API_NAME', l_api_name);
1050: FND_MSG_PUB.add;
1051: RAISE fnd_api.g_exc_unexpected_error;

Line 1048: fnd_message.set_token('P_SQLERRM',SQLERRM);

1044:
1045: exception when others then
1046: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1047: fnd_message.set_token('P_SQLCODE',SQLCODE);
1048: fnd_message.set_token('P_SQLERRM',SQLERRM);
1049: fnd_message.set_token('P_API_NAME', l_api_name);
1050: FND_MSG_PUB.add;
1051: RAISE fnd_api.g_exc_unexpected_error;
1052: end;

Line 1049: fnd_message.set_token('P_API_NAME', l_api_name);

1045: exception when others then
1046: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1047: fnd_message.set_token('P_SQLCODE',SQLCODE);
1048: fnd_message.set_token('P_SQLERRM',SQLERRM);
1049: fnd_message.set_token('P_API_NAME', l_api_name);
1050: FND_MSG_PUB.add;
1051: RAISE fnd_api.g_exc_unexpected_error;
1052: end;
1053:

Line 1091: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

1087: p_data => L_data,
1088: p_count => L_count,
1089: P_return_code => l_return_code);
1090: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1091: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1092: FND_MSG_PUB.add;
1093: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1094: RAISE FND_API.G_EXC_ERROR;
1095: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1120: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

1116: p_data => L_data,
1117: p_count => L_count,
1118: P_return_code => l_return_code);
1119: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1120: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1121: FND_MSG_PUB.add;
1122: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1123: RAISE FND_API.G_EXC_ERROR;
1124: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1147: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

1143: p_data => L_data,
1144: p_count => L_count,
1145: P_return_code => l_return_code);
1146: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1147: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1148: FND_MSG_PUB.add;
1149: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1150: RAISE FND_API.G_EXC_ERROR;
1151: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1262: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

1258: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1259: p_data => x_msg_data);
1260: WHEN OTHERS THEN
1261: ROLLBACK TO ROLE_RELATE_SP;
1262: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1263: fnd_message.set_token('P_SQLCODE',SQLCODE);
1264: fnd_message.set_token('P_SQLERRM',SQLERRM);
1265: fnd_message.set_token('P_API_NAME', l_api_name);
1266: FND_MSG_PUB.add;

Line 1263: fnd_message.set_token('P_SQLCODE',SQLCODE);

1259: p_data => x_msg_data);
1260: WHEN OTHERS THEN
1261: ROLLBACK TO ROLE_RELATE_SP;
1262: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1263: fnd_message.set_token('P_SQLCODE',SQLCODE);
1264: fnd_message.set_token('P_SQLERRM',SQLERRM);
1265: fnd_message.set_token('P_API_NAME', l_api_name);
1266: FND_MSG_PUB.add;
1267: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1264: fnd_message.set_token('P_SQLERRM',SQLERRM);

1260: WHEN OTHERS THEN
1261: ROLLBACK TO ROLE_RELATE_SP;
1262: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1263: fnd_message.set_token('P_SQLCODE',SQLCODE);
1264: fnd_message.set_token('P_SQLERRM',SQLERRM);
1265: fnd_message.set_token('P_API_NAME', l_api_name);
1266: FND_MSG_PUB.add;
1267: x_return_status := fnd_api.g_ret_sts_unexp_error;
1268: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

Line 1265: fnd_message.set_token('P_API_NAME', l_api_name);

1261: ROLLBACK TO ROLE_RELATE_SP;
1262: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1263: fnd_message.set_token('P_SQLCODE',SQLCODE);
1264: fnd_message.set_token('P_SQLERRM',SQLERRM);
1265: fnd_message.set_token('P_API_NAME', l_api_name);
1266: FND_MSG_PUB.add;
1267: x_return_status := fnd_api.g_ret_sts_unexp_error;
1268: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1269: p_data => x_msg_data);

Line 1686: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

1682: p_data => L_data,
1683: p_count => L_count,
1684: P_return_code => l_return_code);
1685: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1686: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1687: FND_MSG_PUB.add;
1688: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1689: RAISE FND_API.G_EXC_ERROR;
1690: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1713: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

1709: p_data => L_data,
1710: p_count => L_count,
1711: P_return_code => l_return_code);
1712: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1713: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1714: FND_MSG_PUB.add;
1715: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1716: RAISE FND_API.G_EXC_ERROR;
1717: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1740: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

1736: p_data => L_data,
1737: p_count => L_count,
1738: P_return_code => l_return_code);
1739: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1740: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1741: FND_MSG_PUB.add;
1742: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1743: RAISE FND_API.G_EXC_ERROR;
1744: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1891: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');

1887:
1888: --check start date null
1889: IF(l_start_date_active is NULL)
1890: THEN
1891: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
1892: FND_MSG_PUB.add;
1893: RAISE fnd_api.g_exc_error;
1894: END IF;
1895:

Line 1902: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');

1898: --check start date less than end date
1899: IF(l_start_date_active > l_end_date_active)
1900: THEN
1901:
1902: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
1903: FND_MSG_PUB.add;
1904: RAISE fnd_api.g_exc_error;
1905: END IF;
1906:

Line 1918: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_TYPE_INACTIVE');

1914: l_end_date_active,
1915: l_role_type_valid);
1916:
1917: if (l_role_type_valid = false) then
1918: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_TYPE_INACTIVE');
1919: FND_MSG_PUB.add;
1920: RAISE fnd_api.g_exc_error;
1921: end if;
1922: END IF;

Line 1973: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');

1969: end loop;
1970: CLOSE check_date_cur;
1971: IF(l_date_invalid)
1972: THEN
1973: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
1974: FND_MSG_PUB.add;
1975: RAISE fnd_api.g_exc_error;
1976: END IF;
1977:

Line 1998: fnd_message.set_name('JTF','JTF_RS_INVALID_GRP_MBR_ID');

1994: OPEN grp_mem_cur(l_role_resource_id);
1995: FETCH grp_mem_cur INTO l_rsc_id;
1996: IF(grp_mem_cur%notfound)
1997: THEN
1998: fnd_message.set_name('JTF','JTF_RS_INVALID_GRP_MBR_ID');
1999: fnd_message.set_token('P_GRP_MBR_ID',l_role_resource_id);
2000: fnd_msg_pub.add;
2001: RAISE fnd_api.g_exc_error;
2002: END IF;

Line 1999: fnd_message.set_token('P_GRP_MBR_ID',l_role_resource_id);

1995: FETCH grp_mem_cur INTO l_rsc_id;
1996: IF(grp_mem_cur%notfound)
1997: THEN
1998: fnd_message.set_name('JTF','JTF_RS_INVALID_GRP_MBR_ID');
1999: fnd_message.set_token('P_GRP_MBR_ID',l_role_resource_id);
2000: fnd_msg_pub.add;
2001: RAISE fnd_api.g_exc_error;
2002: END IF;
2003: CLOSE grp_mem_cur;

Line 2029: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_OR_DATE_ERR');

2025:
2026: ELSE
2027:
2028: l_role_valid := FALSE;
2029: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_OR_DATE_ERR');
2030: FND_MSG_PUB.add;
2031: RAISE fnd_api.g_exc_error;
2032: END IF;
2033: close res_role_cur;

Line 2052: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_OR_DATE_ERR');

2048: l_role_valid := TRUE;
2049:
2050: ELSE
2051: l_role_valid := FALSE;
2052: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_OR_DATE_ERR');
2053: FND_MSG_PUB.add;
2054: RAISE fnd_api.g_exc_error;
2055: END IF;
2056: close grp_role_cur;

Line 2072: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');

2068: -- IF((trunc(team_rec.start_date_active) > trunc(l_start_date_active))
2069: IF (( to_date(to_char(nvl(team_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2070: OR to_date(to_char(nvl(team_rec.end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2071: THEN
2072: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
2073: FND_MSG_PUB.add;
2074: RAISE fnd_api.g_exc_error;
2075: END IF;
2076:

Line 2079: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');

2075: END IF;
2076:
2077: IF(team_rec.end_date_active is not null AND l_end_date_active is null)
2078: THEN
2079: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
2080: FND_MSG_PUB.add;
2081: RAISE fnd_api.g_exc_error;
2082: END IF;
2083:

Line 2095: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');

2091: IF (( to_date(to_char(nvl(group_rec.start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') > to_date(to_char(nvl(l_start_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2092: OR to_date(to_char(nvl(group_rec.end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR') < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))
2093: THEN
2094:
2095: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
2096: FND_MSG_PUB.add;
2097: RAISE fnd_api.g_exc_error;
2098: END IF;
2099:

Line 2104: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');

2100:
2101:
2102: IF(group_rec.end_date_active is not null AND l_end_date_active is null)
2103: THEN
2104: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
2105: FND_MSG_PUB.add;
2106: RAISE fnd_api.g_exc_error;
2107: END IF;
2108:

Line 2117: fnd_message.set_name ('JTF', 'JTF_RS_RES_USAGE_ERR');

2113:
2114: fetch c_exclusive_group_check_cur into c_exclusive_group_check_rec;
2115: IF(c_exclusive_group_check_cur%FOUND)
2116: THEN
2117: fnd_message.set_name ('JTF', 'JTF_RS_RES_USAGE_ERR');
2118: FND_MSG_PUB.add;
2119: RAISE fnd_api.g_exc_error;
2120: END IF;
2121:

Line 2135: fnd_message.set_name ('JTF', 'JTF_RS_RES_DATE_ERR');

2131: --changed by sudarsana 11 feb 2002
2132: OR (rsc_rec.end_date_active < to_date(to_char(nvl(l_end_date_active, fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')))
2133: -- OR (rsc_rec.end_date_active < l_end_date_active))
2134: THEN
2135: fnd_message.set_name ('JTF', 'JTF_RS_RES_DATE_ERR');
2136: FND_MSG_PUB.add;
2137: RAISE fnd_api.g_exc_error;
2138: END IF;
2139:

Line 2151: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DT_ERR');

2147: --OR (group_dt_rec.end_date_active < l_end_date_active))
2148: OR (to_date(to_char(nvl(group_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
2149: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
2150: THEN
2151: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DT_ERR');
2152: FND_MSG_PUB.add;
2153: RAISE fnd_api.g_exc_error;
2154: END IF;
2155: ELSIF(l_role_resource_type = 'RS_TEAM')

Line 2166: fnd_message.set_name ('JTF', 'JTF_RS_TEAM_DT_ERR');

2162: --OR (team_dt_rec.end_date_active < l_end_date_active))
2163: OR (to_date(to_char(nvl(team_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
2164: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
2165: THEN
2166: fnd_message.set_name ('JTF', 'JTF_RS_TEAM_DT_ERR');
2167: FND_MSG_PUB.add;
2168: RAISE fnd_api.g_exc_error;
2169: END IF;
2170: END IF;

Line 2186: fnd_message.set_name ('JTF', 'JTF_RS_RES_MEM_DT_ERR');

2182: If(res_team_cur%found)
2183: THEN
2184:
2185: x_return_status := fnd_api.g_ret_sts_error;
2186: fnd_message.set_name ('JTF', 'JTF_RS_RES_MEM_DT_ERR');
2187: FND_MSG_PUB.add;
2188: RAISE fnd_api.g_exc_error;
2189: END IF;
2190: close res_team_cur;

Line 2200: fnd_message.set_name ('JTF', 'JTF_RS_RES_MEM_DT_ERR');

2196: fetch res_group_cur INTO res_group_rec;
2197:
2198: If(res_group_cur%found)
2199: THEN
2200: fnd_message.set_name ('JTF', 'JTF_RS_RES_MEM_DT_ERR');
2201: FND_MSG_PUB.add;
2202: RAISE fnd_api.g_exc_error;
2203: END IF;
2204: close res_group_cur;

Line 2220: --fnd_message.set_name ('JTF', 'JTF_RS_RES_UPD_DT_ERR');

2216: p_valid => l_valid);
2217:
2218: If NOT(l_valid)
2219: THEN
2220: --fnd_message.set_name ('JTF', 'JTF_RS_RES_UPD_DT_ERR');
2221: --FND_MSG_PUB.add;
2222: RAISE fnd_api.g_exc_error;
2223: END IF;
2224:

Line 2238: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');

2234:
2235: EXCEPTION
2236:
2237: WHEN OTHERS THEN
2238: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
2239: fnd_msg_pub.add;
2240: RAISE fnd_api.g_exc_error;
2241:
2242: END;

Line 2264: fnd_message.set_name ('JTF', 'JTF_RS_AUDIT_ERR');

2260: X_MSG_DATA => l_msg_data );
2261:
2262: IF(l_return_status <> fnd_api.g_ret_sts_success)
2263: THEN
2264: fnd_message.set_name ('JTF', 'JTF_RS_AUDIT_ERR');
2265: FND_MSG_PUB.add;
2266: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2267: RAISE FND_API.G_EXC_ERROR;
2268: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2382: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

2378: l_login_id);
2379:
2380: exception
2381: when others then
2382: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2383: fnd_message.set_token('P_SQLCODE',SQLCODE);
2384: fnd_message.set_token('P_SQLERRM',SQLERRM);
2385: fnd_message.set_token('P_API_NAME', l_api_name);
2386: FND_MSG_PUB.add;

Line 2383: fnd_message.set_token('P_SQLCODE',SQLCODE);

2379:
2380: exception
2381: when others then
2382: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2383: fnd_message.set_token('P_SQLCODE',SQLCODE);
2384: fnd_message.set_token('P_SQLERRM',SQLERRM);
2385: fnd_message.set_token('P_API_NAME', l_api_name);
2386: FND_MSG_PUB.add;
2387: RAISE fnd_api.g_exc_unexpected_error;

Line 2384: fnd_message.set_token('P_SQLERRM',SQLERRM);

2380: exception
2381: when others then
2382: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2383: fnd_message.set_token('P_SQLCODE',SQLCODE);
2384: fnd_message.set_token('P_SQLERRM',SQLERRM);
2385: fnd_message.set_token('P_API_NAME', l_api_name);
2386: FND_MSG_PUB.add;
2387: RAISE fnd_api.g_exc_unexpected_error;
2388:

Line 2385: fnd_message.set_token('P_API_NAME', l_api_name);

2381: when others then
2382: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2383: fnd_message.set_token('P_SQLCODE',SQLCODE);
2384: fnd_message.set_token('P_SQLERRM',SQLERRM);
2385: fnd_message.set_token('P_API_NAME', l_api_name);
2386: FND_MSG_PUB.add;
2387: RAISE fnd_api.g_exc_unexpected_error;
2388:
2389:

Line 2402: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');

2398:
2399: open conc_prog_cur;
2400: fetch conc_prog_cur into g_name;
2401: close conc_prog_cur;
2402: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
2403: fnd_message.set_token('P_NAME',g_name);
2404: fnd_message.set_token('P_ID',l_request);
2405: FND_MSG_PUB.add;
2406:

Line 2403: fnd_message.set_token('P_NAME',g_name);

2399: open conc_prog_cur;
2400: fetch conc_prog_cur into g_name;
2401: close conc_prog_cur;
2402: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
2403: fnd_message.set_token('P_NAME',g_name);
2404: fnd_message.set_token('P_ID',l_request);
2405: FND_MSG_PUB.add;
2406:
2407:

Line 2404: fnd_message.set_token('P_ID',l_request);

2400: fetch conc_prog_cur into g_name;
2401: close conc_prog_cur;
2402: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
2403: fnd_message.set_token('P_NAME',g_name);
2404: fnd_message.set_token('P_ID',l_request);
2405: FND_MSG_PUB.add;
2406:
2407:
2408: exception when others then

Line 2409: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

2405: FND_MSG_PUB.add;
2406:
2407:
2408: exception when others then
2409: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2410: fnd_message.set_token('P_SQLCODE',SQLCODE);
2411: fnd_message.set_token('P_SQLERRM',SQLERRM);
2412: fnd_message.set_token('P_API_NAME', l_api_name);
2413: FND_MSG_PUB.add;

Line 2410: fnd_message.set_token('P_SQLCODE',SQLCODE);

2406:
2407:
2408: exception when others then
2409: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2410: fnd_message.set_token('P_SQLCODE',SQLCODE);
2411: fnd_message.set_token('P_SQLERRM',SQLERRM);
2412: fnd_message.set_token('P_API_NAME', l_api_name);
2413: FND_MSG_PUB.add;
2414: RAISE fnd_api.g_exc_unexpected_error;

Line 2411: fnd_message.set_token('P_SQLERRM',SQLERRM);

2407:
2408: exception when others then
2409: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2410: fnd_message.set_token('P_SQLCODE',SQLCODE);
2411: fnd_message.set_token('P_SQLERRM',SQLERRM);
2412: fnd_message.set_token('P_API_NAME', l_api_name);
2413: FND_MSG_PUB.add;
2414: RAISE fnd_api.g_exc_unexpected_error;
2415: end;

Line 2412: fnd_message.set_token('P_API_NAME', l_api_name);

2408: exception when others then
2409: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2410: fnd_message.set_token('P_SQLCODE',SQLCODE);
2411: fnd_message.set_token('P_SQLERRM',SQLERRM);
2412: fnd_message.set_token('P_API_NAME', l_api_name);
2413: FND_MSG_PUB.add;
2414: RAISE fnd_api.g_exc_unexpected_error;
2415: end;
2416:

Line 2456: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

2452: p_data => L_data,
2453: p_count => L_count,
2454: P_return_code => l_return_code);
2455: if( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2456: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
2457: FND_MSG_PUB.add;
2458: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2459: RAISE FND_API.G_EXC_ERROR;
2460: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2482: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

2478: p_data => L_data,
2479: p_count => L_count,
2480: P_return_code => l_return_code);
2481: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2482: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
2483: FND_MSG_PUB.add;
2484: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2485: RAISE FND_API.G_EXC_ERROR;
2486: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2511: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

2507: p_count => L_count,
2508: P_return_code => l_return_code);
2509: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS)
2510: then
2511: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
2512: FND_MSG_PUB.add;
2513: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2514: RAISE FND_API.G_EXC_ERROR;
2515: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2566: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

2562:
2563: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2564: -- x_return_status := fnd_api.g_ret_sts_error;
2565:
2566: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
2567: fnd_msg_pub.add;
2568: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2569: RAISE FND_API.G_EXC_ERROR;
2570: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2607: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

2603: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2604: p_data => x_msg_data);
2605: WHEN OTHERS THEN
2606: ROLLBACK TO ROLE_RELATE_SP;
2607: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2608: fnd_message.set_token('P_SQLCODE',SQLCODE);
2609: fnd_message.set_token('P_SQLERRM',SQLERRM);
2610: fnd_message.set_token('P_API_NAME', l_api_name);
2611: FND_MSG_PUB.add;

Line 2608: fnd_message.set_token('P_SQLCODE',SQLCODE);

2604: p_data => x_msg_data);
2605: WHEN OTHERS THEN
2606: ROLLBACK TO ROLE_RELATE_SP;
2607: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2608: fnd_message.set_token('P_SQLCODE',SQLCODE);
2609: fnd_message.set_token('P_SQLERRM',SQLERRM);
2610: fnd_message.set_token('P_API_NAME', l_api_name);
2611: FND_MSG_PUB.add;
2612: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2609: fnd_message.set_token('P_SQLERRM',SQLERRM);

2605: WHEN OTHERS THEN
2606: ROLLBACK TO ROLE_RELATE_SP;
2607: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2608: fnd_message.set_token('P_SQLCODE',SQLCODE);
2609: fnd_message.set_token('P_SQLERRM',SQLERRM);
2610: fnd_message.set_token('P_API_NAME', l_api_name);
2611: FND_MSG_PUB.add;
2612: x_return_status := fnd_api.g_ret_sts_unexp_error;
2613: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

Line 2610: fnd_message.set_token('P_API_NAME', l_api_name);

2606: ROLLBACK TO ROLE_RELATE_SP;
2607: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2608: fnd_message.set_token('P_SQLCODE',SQLCODE);
2609: fnd_message.set_token('P_SQLERRM',SQLERRM);
2610: fnd_message.set_token('P_API_NAME', l_api_name);
2611: FND_MSG_PUB.add;
2612: x_return_status := fnd_api.g_ret_sts_unexp_error;
2613: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2614: p_data => x_msg_data);

Line 2810: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

2806: p_data => L_data,
2807: p_count => L_count,
2808: P_return_code => l_return_code);
2809: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2810: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
2811: FND_MSG_PUB.add;
2812: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2813: RAISE FND_API.G_EXC_ERROR;
2814: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2835: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

2831: p_data => L_data,
2832: p_count => L_count,
2833: P_return_code => l_return_code);
2834: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2835: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
2836: FND_MSG_PUB.add;
2837: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2838: RAISE FND_API.G_EXC_ERROR;
2839: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2860: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

2856: p_data => L_data,
2857: p_count => L_count,
2858: P_return_code => l_return_code);
2859: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2860: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
2861: FND_MSG_PUB.add;
2862: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2863: RAISE FND_API.G_EXC_ERROR;
2864: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2910: fnd_message.set_name ('JTF', 'JTF_RS_MEM_ROLE_EXIST_ERR');

2906: chk_type_rec.start_date_active,
2907: chk_type_rec.end_date_active);
2908: FETCH chk_team_cur INTO chk_team_rec;
2909: IF(chk_team_cur%FOUND) THEN
2910: fnd_message.set_name ('JTF', 'JTF_RS_MEM_ROLE_EXIST_ERR');
2911: FND_MSG_PUB.add;
2912: CLOSE chk_team_cur;
2913: RAISE fnd_api.g_exc_error;
2914: END IF;

Line 2922: fnd_message.set_name ('JTF', 'JTF_RS_MEM_ROLE_EXIST_ERR');

2918: chk_type_rec.start_date_active,
2919: chk_type_rec.end_date_active);
2920: FETCH chk_grp_cur INTO chk_grp_rec;
2921: IF(chk_grp_cur%FOUND) THEN
2922: fnd_message.set_name ('JTF', 'JTF_RS_MEM_ROLE_EXIST_ERR');
2923: FND_MSG_PUB.add;
2924: CLOSE chk_grp_cur;
2925: RAISE fnd_api.g_exc_error;
2926: END IF;

Line 2952: --fnd_message.set_name ('JTF', 'JTF_RS_AUDIT_ERR');

2948: X_MSG_DATA => l_msg_data );
2949:
2950: IF(l_return_status <> fnd_api.g_ret_sts_success)
2951: THEN
2952: --fnd_message.set_name ('JTF', 'JTF_RS_AUDIT_ERR');
2953: --FND_MSG_PUB.add;
2954: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2955: RAISE FND_API.G_EXC_ERROR;
2956: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3046: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

3042: l_login_id);
3043:
3044: exception
3045: when others then
3046: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3047: fnd_message.set_token('P_SQLCODE',SQLCODE);
3048: fnd_message.set_token('P_SQLERRM',SQLERRM);
3049: fnd_message.set_token('P_API_NAME', l_api_name);
3050: FND_MSG_PUB.add;

Line 3047: fnd_message.set_token('P_SQLCODE',SQLCODE);

3043:
3044: exception
3045: when others then
3046: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3047: fnd_message.set_token('P_SQLCODE',SQLCODE);
3048: fnd_message.set_token('P_SQLERRM',SQLERRM);
3049: fnd_message.set_token('P_API_NAME', l_api_name);
3050: FND_MSG_PUB.add;
3051: RAISE fnd_api.g_exc_unexpected_error;

Line 3048: fnd_message.set_token('P_SQLERRM',SQLERRM);

3044: exception
3045: when others then
3046: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3047: fnd_message.set_token('P_SQLCODE',SQLCODE);
3048: fnd_message.set_token('P_SQLERRM',SQLERRM);
3049: fnd_message.set_token('P_API_NAME', l_api_name);
3050: FND_MSG_PUB.add;
3051: RAISE fnd_api.g_exc_unexpected_error;
3052:

Line 3049: fnd_message.set_token('P_API_NAME', l_api_name);

3045: when others then
3046: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3047: fnd_message.set_token('P_SQLCODE',SQLCODE);
3048: fnd_message.set_token('P_SQLERRM',SQLERRM);
3049: fnd_message.set_token('P_API_NAME', l_api_name);
3050: FND_MSG_PUB.add;
3051: RAISE fnd_api.g_exc_unexpected_error;
3052:
3053:

Line 3066: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');

3062: open conc_prog_cur;
3063: fetch conc_prog_cur into g_name;
3064: close conc_prog_cur;
3065:
3066: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
3067: fnd_message.set_token('P_NAME',g_name);
3068: fnd_message.set_token('P_ID',l_request);
3069: FND_MSG_PUB.add;
3070:

Line 3067: fnd_message.set_token('P_NAME',g_name);

3063: fetch conc_prog_cur into g_name;
3064: close conc_prog_cur;
3065:
3066: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
3067: fnd_message.set_token('P_NAME',g_name);
3068: fnd_message.set_token('P_ID',l_request);
3069: FND_MSG_PUB.add;
3070:
3071: exception when others then

Line 3068: fnd_message.set_token('P_ID',l_request);

3064: close conc_prog_cur;
3065:
3066: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
3067: fnd_message.set_token('P_NAME',g_name);
3068: fnd_message.set_token('P_ID',l_request);
3069: FND_MSG_PUB.add;
3070:
3071: exception when others then
3072: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 3072: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

3068: fnd_message.set_token('P_ID',l_request);
3069: FND_MSG_PUB.add;
3070:
3071: exception when others then
3072: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3073: fnd_message.set_token('P_SQLCODE',SQLCODE);
3074: fnd_message.set_token('P_SQLERRM',SQLERRM);
3075: fnd_message.set_token('P_API_NAME', l_api_name);
3076: FND_MSG_PUB.add;

Line 3073: fnd_message.set_token('P_SQLCODE',SQLCODE);

3069: FND_MSG_PUB.add;
3070:
3071: exception when others then
3072: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3073: fnd_message.set_token('P_SQLCODE',SQLCODE);
3074: fnd_message.set_token('P_SQLERRM',SQLERRM);
3075: fnd_message.set_token('P_API_NAME', l_api_name);
3076: FND_MSG_PUB.add;
3077:

Line 3074: fnd_message.set_token('P_SQLERRM',SQLERRM);

3070:
3071: exception when others then
3072: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3073: fnd_message.set_token('P_SQLCODE',SQLCODE);
3074: fnd_message.set_token('P_SQLERRM',SQLERRM);
3075: fnd_message.set_token('P_API_NAME', l_api_name);
3076: FND_MSG_PUB.add;
3077:
3078: RAISE fnd_api.g_exc_unexpected_error;

Line 3075: fnd_message.set_token('P_API_NAME', l_api_name);

3071: exception when others then
3072: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3073: fnd_message.set_token('P_SQLCODE',SQLCODE);
3074: fnd_message.set_token('P_SQLERRM',SQLERRM);
3075: fnd_message.set_token('P_API_NAME', l_api_name);
3076: FND_MSG_PUB.add;
3077:
3078: RAISE fnd_api.g_exc_unexpected_error;
3079: end;

Line 3118: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

3114: p_data => L_data,
3115: p_count => L_count,
3116: P_return_code => l_return_code);
3117: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
3118: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
3119: FND_MSG_PUB.add;
3120: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3121: RAISE FND_API.G_EXC_ERROR;
3122: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3143: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

3139: p_data => L_data,
3140: p_count => L_count,
3141: P_return_code => l_return_code);
3142: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
3143: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
3144: FND_MSG_PUB.add;
3145: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3146: RAISE FND_API.G_EXC_ERROR;
3147: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3169: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

3165: p_data => L_data,
3166: p_count => L_count,
3167: P_return_code => l_return_code);
3168: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
3169: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
3170: FND_MSG_PUB.add;
3171: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3172: RAISE FND_API.G_EXC_ERROR;
3173: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3223: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

3219:
3220: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3221: --x_return_status := fnd_api.g_ret_sts_error;
3222:
3223: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
3224: fnd_msg_pub.add;
3225:
3226: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3227: RAISE FND_API.G_EXC_ERROR;

Line 3281: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

3277: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3278: p_data => x_msg_data);
3279: WHEN OTHERS THEN
3280: ROLLBACK TO ROLE_RELATE_SP;
3281: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3282: fnd_message.set_token('P_SQLCODE',SQLCODE);
3283: fnd_message.set_token('P_SQLERRM',SQLERRM);
3284: fnd_message.set_token('P_API_NAME', l_api_name);
3285: FND_MSG_PUB.add;

Line 3282: fnd_message.set_token('P_SQLCODE',SQLCODE);

3278: p_data => x_msg_data);
3279: WHEN OTHERS THEN
3280: ROLLBACK TO ROLE_RELATE_SP;
3281: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3282: fnd_message.set_token('P_SQLCODE',SQLCODE);
3283: fnd_message.set_token('P_SQLERRM',SQLERRM);
3284: fnd_message.set_token('P_API_NAME', l_api_name);
3285: FND_MSG_PUB.add;
3286: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3283: fnd_message.set_token('P_SQLERRM',SQLERRM);

3279: WHEN OTHERS THEN
3280: ROLLBACK TO ROLE_RELATE_SP;
3281: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3282: fnd_message.set_token('P_SQLCODE',SQLCODE);
3283: fnd_message.set_token('P_SQLERRM',SQLERRM);
3284: fnd_message.set_token('P_API_NAME', l_api_name);
3285: FND_MSG_PUB.add;
3286: x_return_status := fnd_api.g_ret_sts_unexp_error;
3287: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

Line 3284: fnd_message.set_token('P_API_NAME', l_api_name);

3280: ROLLBACK TO ROLE_RELATE_SP;
3281: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3282: fnd_message.set_token('P_SQLCODE',SQLCODE);
3283: fnd_message.set_token('P_SQLERRM',SQLERRM);
3284: fnd_message.set_token('P_API_NAME', l_api_name);
3285: FND_MSG_PUB.add;
3286: x_return_status := fnd_api.g_ret_sts_unexp_error;
3287: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3288: p_data => x_msg_data);