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 534: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

725: l_role_valid := TRUE;
726:
727: ELSE
728: l_role_valid := FALSE;
729: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_OR_DATE_ERR');
730: FND_MSG_PUB.add;
731: RAISE fnd_api.g_exc_error;
732: END IF;
733: close res_role_cur;

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

749: l_role_valid := TRUE;
750:
751: ELSE
752: l_role_valid := FALSE;
753: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_OR_DATE_ERR');
754: FND_MSG_PUB.add;
755: RAISE fnd_api.g_exc_error;
756: END IF;
757: close grp_role_cur;

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

770: close team_cur;
771: IF((trunc(team_rec.start_date_active) > trunc(l_start_date_active))
772: 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'))
773: THEN
774: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
775: FND_MSG_PUB.add;
776: RAISE fnd_api.g_exc_error;
777: END IF;
778:

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

777: END IF;
778:
779: IF(team_rec.end_date_active is not null AND l_end_date_active is null)
780: THEN
781: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
782: FND_MSG_PUB.add;
783: RAISE fnd_api.g_exc_error;
784: END IF;
785:

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

795:
796: IF((trunc(group_rec.start_date_active) > trunc(l_start_date_active))
797: 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'))
798: THEN
799: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
800: FND_MSG_PUB.add;
801: RAISE fnd_api.g_exc_error;
802: END IF;
803:

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

803:
804:
805: IF(group_rec.end_date_active is not null AND l_end_date_active is null)
806: THEN
807: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
808: FND_MSG_PUB.add;
809: RAISE fnd_api.g_exc_error;
810: END IF;
811:

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

816:
817: fetch c_exclusive_group_check_cur into c_exclusive_group_check_rec;
818: IF(c_exclusive_group_check_cur%FOUND)
819: THEN
820: fnd_message.set_name ('JTF', 'JTF_RS_RES_USAGE_ERR');
821: FND_MSG_PUB.add;
822: RAISE fnd_api.g_exc_error;
823: END IF;
824:

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

833: IF((rsc_rec.start_date_active > l_start_date_active)
834: -- changed by sudarsana 11 feb 2002
835: 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')))
836: THEN
837: fnd_message.set_name ('JTF', 'JTF_RS_RES_DATE_ERR');
838: FND_MSG_PUB.add;
839: RAISE fnd_api.g_exc_error;
840: END IF;
841: ELSIF(l_role_resource_type = 'RS_GROUP')

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

849: --OR (group_dt_rec.end_date_active < l_end_date_active))
850: OR (to_date(to_char(nvl(group_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
851: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
852: THEN
853: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DT_ERR');
854: FND_MSG_PUB.add;
855: RAISE fnd_api.g_exc_error;
856: END IF;
857: ELSIF(l_role_resource_type = 'RS_TEAM')

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

865: --OR (team_dt_rec.end_date_active < l_end_date_active))
866: OR (to_date(to_char(nvl(team_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
867: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
868: THEN
869: fnd_message.set_name ('JTF', 'JTF_RS_TEAM_DT_ERR');
870: FND_MSG_PUB.add;
871: RAISE fnd_api.g_exc_error;
872: END IF;
873: END IF;

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

1001: l_login_id);
1002:
1003: exception
1004: when others then
1005: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1006: fnd_message.set_token('P_SQLCODE',SQLCODE);
1007: fnd_message.set_token('P_SQLERRM',SQLERRM);
1008: fnd_message.set_token('P_API_NAME', l_api_name);
1009: FND_MSG_PUB.add;

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

1002:
1003: exception
1004: when others then
1005: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1006: fnd_message.set_token('P_SQLCODE',SQLCODE);
1007: fnd_message.set_token('P_SQLERRM',SQLERRM);
1008: fnd_message.set_token('P_API_NAME', l_api_name);
1009: FND_MSG_PUB.add;
1010: RAISE fnd_api.g_exc_unexpected_error;

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

1003: exception
1004: when others then
1005: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1006: fnd_message.set_token('P_SQLCODE',SQLCODE);
1007: fnd_message.set_token('P_SQLERRM',SQLERRM);
1008: fnd_message.set_token('P_API_NAME', l_api_name);
1009: FND_MSG_PUB.add;
1010: RAISE fnd_api.g_exc_unexpected_error;
1011:

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

1004: when others then
1005: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1006: fnd_message.set_token('P_SQLCODE',SQLCODE);
1007: fnd_message.set_token('P_SQLERRM',SQLERRM);
1008: fnd_message.set_token('P_API_NAME', l_api_name);
1009: FND_MSG_PUB.add;
1010: RAISE fnd_api.g_exc_unexpected_error;
1011:
1012:

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

1022: open conc_prog_cur;
1023: fetch conc_prog_cur into g_name;
1024: close conc_prog_cur;
1025:
1026: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
1027: fnd_message.set_token('P_NAME',g_name);
1028: fnd_message.set_token('P_ID',l_request);
1029: FND_MSG_PUB.add;
1030:

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

1023: fetch conc_prog_cur into g_name;
1024: close conc_prog_cur;
1025:
1026: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
1027: fnd_message.set_token('P_NAME',g_name);
1028: fnd_message.set_token('P_ID',l_request);
1029: FND_MSG_PUB.add;
1030:
1031: exception when others then

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

1024: close conc_prog_cur;
1025:
1026: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
1027: fnd_message.set_token('P_NAME',g_name);
1028: fnd_message.set_token('P_ID',l_request);
1029: FND_MSG_PUB.add;
1030:
1031: exception when others then
1032: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

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

1028: fnd_message.set_token('P_ID',l_request);
1029: FND_MSG_PUB.add;
1030:
1031: exception when others then
1032: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1033: fnd_message.set_token('P_SQLCODE',SQLCODE);
1034: fnd_message.set_token('P_SQLERRM',SQLERRM);
1035: fnd_message.set_token('P_API_NAME', l_api_name);
1036: FND_MSG_PUB.add;

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

1029: FND_MSG_PUB.add;
1030:
1031: exception when others then
1032: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1033: fnd_message.set_token('P_SQLCODE',SQLCODE);
1034: fnd_message.set_token('P_SQLERRM',SQLERRM);
1035: fnd_message.set_token('P_API_NAME', l_api_name);
1036: FND_MSG_PUB.add;
1037: RAISE fnd_api.g_exc_unexpected_error;

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

1030:
1031: exception when others then
1032: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1033: fnd_message.set_token('P_SQLCODE',SQLCODE);
1034: fnd_message.set_token('P_SQLERRM',SQLERRM);
1035: fnd_message.set_token('P_API_NAME', l_api_name);
1036: FND_MSG_PUB.add;
1037: RAISE fnd_api.g_exc_unexpected_error;
1038: end;

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

1031: exception when others then
1032: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1033: fnd_message.set_token('P_SQLCODE',SQLCODE);
1034: fnd_message.set_token('P_SQLERRM',SQLERRM);
1035: fnd_message.set_token('P_API_NAME', l_api_name);
1036: FND_MSG_PUB.add;
1037: RAISE fnd_api.g_exc_unexpected_error;
1038: end;
1039:

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

1073: p_data => L_data,
1074: p_count => L_count,
1075: P_return_code => l_return_code);
1076: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1077: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1078: FND_MSG_PUB.add;
1079: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1080: RAISE FND_API.G_EXC_ERROR;
1081: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

1102: p_data => L_data,
1103: p_count => L_count,
1104: P_return_code => l_return_code);
1105: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1106: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1107: FND_MSG_PUB.add;
1108: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1109: RAISE FND_API.G_EXC_ERROR;
1110: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

1129: p_data => L_data,
1130: p_count => L_count,
1131: P_return_code => l_return_code);
1132: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1133: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1134: FND_MSG_PUB.add;
1135: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1136: RAISE FND_API.G_EXC_ERROR;
1137: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

1244: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1245: p_data => x_msg_data);
1246: WHEN OTHERS THEN
1247: ROLLBACK TO ROLE_RELATE_SP;
1248: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1249: fnd_message.set_token('P_SQLCODE',SQLCODE);
1250: fnd_message.set_token('P_SQLERRM',SQLERRM);
1251: fnd_message.set_token('P_API_NAME', l_api_name);
1252: FND_MSG_PUB.add;

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

1245: p_data => x_msg_data);
1246: WHEN OTHERS THEN
1247: ROLLBACK TO ROLE_RELATE_SP;
1248: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1249: fnd_message.set_token('P_SQLCODE',SQLCODE);
1250: fnd_message.set_token('P_SQLERRM',SQLERRM);
1251: fnd_message.set_token('P_API_NAME', l_api_name);
1252: FND_MSG_PUB.add;
1253: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1246: WHEN OTHERS THEN
1247: ROLLBACK TO ROLE_RELATE_SP;
1248: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1249: fnd_message.set_token('P_SQLCODE',SQLCODE);
1250: fnd_message.set_token('P_SQLERRM',SQLERRM);
1251: fnd_message.set_token('P_API_NAME', l_api_name);
1252: FND_MSG_PUB.add;
1253: x_return_status := fnd_api.g_ret_sts_unexp_error;
1254: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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

1247: ROLLBACK TO ROLE_RELATE_SP;
1248: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1249: fnd_message.set_token('P_SQLCODE',SQLCODE);
1250: fnd_message.set_token('P_SQLERRM',SQLERRM);
1251: fnd_message.set_token('P_API_NAME', l_api_name);
1252: FND_MSG_PUB.add;
1253: x_return_status := fnd_api.g_ret_sts_unexp_error;
1254: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1255: p_data => x_msg_data);

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

1668: p_data => L_data,
1669: p_count => L_count,
1670: P_return_code => l_return_code);
1671: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1672: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1673: FND_MSG_PUB.add;
1674: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1675: RAISE FND_API.G_EXC_ERROR;
1676: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

1695: p_data => L_data,
1696: p_count => L_count,
1697: P_return_code => l_return_code);
1698: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1699: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1700: FND_MSG_PUB.add;
1701: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1702: RAISE FND_API.G_EXC_ERROR;
1703: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

1722: p_data => L_data,
1723: p_count => L_count,
1724: P_return_code => l_return_code);
1725: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
1726: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1727: FND_MSG_PUB.add;
1728: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
1729: RAISE FND_API.G_EXC_ERROR;
1730: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

1870:
1871: --check start date null
1872: IF(l_start_date_active is NULL)
1873: THEN
1874: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
1875: FND_MSG_PUB.add;
1876: RAISE fnd_api.g_exc_error;
1877: END IF;
1878:

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

1881: --check start date less than end date
1882: IF(l_start_date_active > l_end_date_active)
1883: THEN
1884:
1885: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
1886: FND_MSG_PUB.add;
1887: RAISE fnd_api.g_exc_error;
1888: END IF;
1889:

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

1897: l_end_date_active,
1898: l_role_type_valid);
1899:
1900: if (l_role_type_valid = false) then
1901: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_TYPE_INACTIVE');
1902: FND_MSG_PUB.add;
1903: RAISE fnd_api.g_exc_error;
1904: end if;
1905: END IF;

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

1952: end loop;
1953: CLOSE check_date_cur;
1954: IF(l_date_invalid)
1955: THEN
1956: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
1957: FND_MSG_PUB.add;
1958: RAISE fnd_api.g_exc_error;
1959: END IF;
1960:

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

2001:
2002: ELSE
2003:
2004: l_role_valid := FALSE;
2005: fnd_message.set_name ('JTF', 'JTF_RS_ROLE_OR_DATE_ERR');
2006: FND_MSG_PUB.add;
2007: RAISE fnd_api.g_exc_error;
2008: END IF;
2009: close res_role_cur;

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

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

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

2043: close team_cur;
2044: IF((trunc(team_rec.start_date_active) > trunc(l_start_date_active))
2045: 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'))
2046: THEN
2047: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
2048: FND_MSG_PUB.add;
2049: RAISE fnd_api.g_exc_error;
2050: END IF;
2051:

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

2050: END IF;
2051:
2052: IF(team_rec.end_date_active is not null AND l_end_date_active is null)
2053: THEN
2054: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
2055: FND_MSG_PUB.add;
2056: RAISE fnd_api.g_exc_error;
2057: END IF;
2058:

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

2065: IF((trunc(group_rec.start_date_active) > trunc(l_start_date_active))
2066: 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'))
2067: THEN
2068:
2069: fnd_message.set_name ('JTF', 'JTF_RS_TM_GRP_DT_ERR');
2070: FND_MSG_PUB.add;
2071: RAISE fnd_api.g_exc_error;
2072: END IF;
2073:

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

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

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

2087:
2088: fetch c_exclusive_group_check_cur into c_exclusive_group_check_rec;
2089: IF(c_exclusive_group_check_cur%FOUND)
2090: THEN
2091: fnd_message.set_name ('JTF', 'JTF_RS_RES_USAGE_ERR');
2092: FND_MSG_PUB.add;
2093: RAISE fnd_api.g_exc_error;
2094: END IF;
2095:

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

2105: --changed by sudarsana 11 feb 2002
2106: 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')))
2107: -- OR (rsc_rec.end_date_active < l_end_date_active))
2108: THEN
2109: fnd_message.set_name ('JTF', 'JTF_RS_RES_DATE_ERR');
2110: FND_MSG_PUB.add;
2111: RAISE fnd_api.g_exc_error;
2112: END IF;
2113:

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

2121: --OR (group_dt_rec.end_date_active < l_end_date_active))
2122: OR (to_date(to_char(nvl(group_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
2123: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
2124: THEN
2125: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DT_ERR');
2126: FND_MSG_PUB.add;
2127: RAISE fnd_api.g_exc_error;
2128: END IF;
2129: ELSIF(l_role_resource_type = 'RS_TEAM')

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

2136: --OR (team_dt_rec.end_date_active < l_end_date_active))
2137: OR (to_date(to_char(nvl(team_dt_rec.end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR')
2138: < (to_date(to_char(nvl(l_end_date_active,fnd_api.g_miss_date),'DD-MM-RRRR'),'DD-MM-RRRR'))))
2139: THEN
2140: fnd_message.set_name ('JTF', 'JTF_RS_TEAM_DT_ERR');
2141: FND_MSG_PUB.add;
2142: RAISE fnd_api.g_exc_error;
2143: END IF;
2144: END IF;

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

2156: If(res_team_cur%found)
2157: THEN
2158:
2159: x_return_status := fnd_api.g_ret_sts_error;
2160: fnd_message.set_name ('JTF', 'JTF_RS_RES_MEM_DT_ERR');
2161: FND_MSG_PUB.add;
2162: RAISE fnd_api.g_exc_error;
2163: END IF;
2164: close res_team_cur;

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

2170: fetch res_group_cur INTO res_group_rec;
2171:
2172: If(res_group_cur%found)
2173: THEN
2174: fnd_message.set_name ('JTF', 'JTF_RS_RES_MEM_DT_ERR');
2175: FND_MSG_PUB.add;
2176: RAISE fnd_api.g_exc_error;
2177: END IF;
2178: close res_group_cur;

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

2190: p_valid => l_valid);
2191:
2192: If NOT(l_valid)
2193: THEN
2194: --fnd_message.set_name ('JTF', 'JTF_RS_RES_UPD_DT_ERR');
2195: --FND_MSG_PUB.add;
2196: RAISE fnd_api.g_exc_error;
2197: END IF;
2198:

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

2208:
2209: EXCEPTION
2210:
2211: WHEN OTHERS THEN
2212: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
2213: fnd_msg_pub.add;
2214: RAISE fnd_api.g_exc_error;
2215:
2216: END;

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

2234: X_MSG_DATA => l_msg_data );
2235:
2236: IF(l_return_status <> fnd_api.g_ret_sts_success)
2237: THEN
2238: fnd_message.set_name ('JTF', 'JTF_RS_AUDIT_ERR');
2239: FND_MSG_PUB.add;
2240: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2241: RAISE FND_API.G_EXC_ERROR;
2242: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

2352: l_login_id);
2353:
2354: exception
2355: when others then
2356: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2357: fnd_message.set_token('P_SQLCODE',SQLCODE);
2358: fnd_message.set_token('P_SQLERRM',SQLERRM);
2359: fnd_message.set_token('P_API_NAME', l_api_name);
2360: FND_MSG_PUB.add;

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

2353:
2354: exception
2355: when others then
2356: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2357: fnd_message.set_token('P_SQLCODE',SQLCODE);
2358: fnd_message.set_token('P_SQLERRM',SQLERRM);
2359: fnd_message.set_token('P_API_NAME', l_api_name);
2360: FND_MSG_PUB.add;
2361: RAISE fnd_api.g_exc_unexpected_error;

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

2354: exception
2355: when others then
2356: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2357: fnd_message.set_token('P_SQLCODE',SQLCODE);
2358: fnd_message.set_token('P_SQLERRM',SQLERRM);
2359: fnd_message.set_token('P_API_NAME', l_api_name);
2360: FND_MSG_PUB.add;
2361: RAISE fnd_api.g_exc_unexpected_error;
2362:

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

2355: when others then
2356: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2357: fnd_message.set_token('P_SQLCODE',SQLCODE);
2358: fnd_message.set_token('P_SQLERRM',SQLERRM);
2359: fnd_message.set_token('P_API_NAME', l_api_name);
2360: FND_MSG_PUB.add;
2361: RAISE fnd_api.g_exc_unexpected_error;
2362:
2363:

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

2372:
2373: open conc_prog_cur;
2374: fetch conc_prog_cur into g_name;
2375: close conc_prog_cur;
2376: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
2377: fnd_message.set_token('P_NAME',g_name);
2378: fnd_message.set_token('P_ID',l_request);
2379: FND_MSG_PUB.add;
2380:

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

2373: open conc_prog_cur;
2374: fetch conc_prog_cur into g_name;
2375: close conc_prog_cur;
2376: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
2377: fnd_message.set_token('P_NAME',g_name);
2378: fnd_message.set_token('P_ID',l_request);
2379: FND_MSG_PUB.add;
2380:
2381:

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

2374: fetch conc_prog_cur into g_name;
2375: close conc_prog_cur;
2376: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
2377: fnd_message.set_token('P_NAME',g_name);
2378: fnd_message.set_token('P_ID',l_request);
2379: FND_MSG_PUB.add;
2380:
2381:
2382: exception when others then

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

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

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

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

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

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

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

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

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

2426: p_data => L_data,
2427: p_count => L_count,
2428: P_return_code => l_return_code);
2429: if( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2430: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
2431: FND_MSG_PUB.add;
2432: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2433: RAISE FND_API.G_EXC_ERROR;
2434: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2456: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_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_VERT_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 2485: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

2481: p_count => L_count,
2482: P_return_code => l_return_code);
2483: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS)
2484: then
2485: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
2486: FND_MSG_PUB.add;
2487: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2488: RAISE FND_API.G_EXC_ERROR;
2489: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

2536:
2537: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2538: -- x_return_status := fnd_api.g_ret_sts_error;
2539:
2540: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
2541: fnd_msg_pub.add;
2542: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2543: RAISE FND_API.G_EXC_ERROR;
2544: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

2577: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2578: p_data => x_msg_data);
2579: WHEN OTHERS THEN
2580: ROLLBACK TO ROLE_RELATE_SP;
2581: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2582: fnd_message.set_token('P_SQLCODE',SQLCODE);
2583: fnd_message.set_token('P_SQLERRM',SQLERRM);
2584: fnd_message.set_token('P_API_NAME', l_api_name);
2585: FND_MSG_PUB.add;

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

2578: p_data => x_msg_data);
2579: WHEN OTHERS THEN
2580: ROLLBACK TO ROLE_RELATE_SP;
2581: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2582: fnd_message.set_token('P_SQLCODE',SQLCODE);
2583: fnd_message.set_token('P_SQLERRM',SQLERRM);
2584: fnd_message.set_token('P_API_NAME', l_api_name);
2585: FND_MSG_PUB.add;
2586: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2579: WHEN OTHERS THEN
2580: ROLLBACK TO ROLE_RELATE_SP;
2581: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2582: fnd_message.set_token('P_SQLCODE',SQLCODE);
2583: fnd_message.set_token('P_SQLERRM',SQLERRM);
2584: fnd_message.set_token('P_API_NAME', l_api_name);
2585: FND_MSG_PUB.add;
2586: x_return_status := fnd_api.g_ret_sts_unexp_error;
2587: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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

2580: ROLLBACK TO ROLE_RELATE_SP;
2581: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2582: fnd_message.set_token('P_SQLCODE',SQLCODE);
2583: fnd_message.set_token('P_SQLERRM',SQLERRM);
2584: fnd_message.set_token('P_API_NAME', l_api_name);
2585: FND_MSG_PUB.add;
2586: x_return_status := fnd_api.g_ret_sts_unexp_error;
2587: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2588: p_data => x_msg_data);

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

2780: p_data => L_data,
2781: p_count => L_count,
2782: P_return_code => l_return_code);
2783: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
2784: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
2785: FND_MSG_PUB.add;
2786: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
2787: RAISE FND_API.G_EXC_ERROR;
2788: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

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

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

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

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

2880: chk_type_rec.start_date_active,
2881: chk_type_rec.end_date_active);
2882: FETCH chk_team_cur INTO chk_team_rec;
2883: IF(chk_team_cur%FOUND) THEN
2884: fnd_message.set_name ('JTF', 'JTF_RS_MEM_ROLE_EXIST_ERR');
2885: FND_MSG_PUB.add;
2886: CLOSE chk_team_cur;
2887: RAISE fnd_api.g_exc_error;
2888: END IF;

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

2892: chk_type_rec.start_date_active,
2893: chk_type_rec.end_date_active);
2894: FETCH chk_grp_cur INTO chk_grp_rec;
2895: IF(chk_grp_cur%FOUND) THEN
2896: fnd_message.set_name ('JTF', 'JTF_RS_MEM_ROLE_EXIST_ERR');
2897: FND_MSG_PUB.add;
2898: CLOSE chk_grp_cur;
2899: RAISE fnd_api.g_exc_error;
2900: END IF;

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

2922: X_MSG_DATA => l_msg_data );
2923:
2924: IF(l_return_status <> fnd_api.g_ret_sts_success)
2925: THEN
2926: --fnd_message.set_name ('JTF', 'JTF_RS_AUDIT_ERR');
2927: --FND_MSG_PUB.add;
2928: IF L_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2929: RAISE FND_API.G_EXC_ERROR;
2930: ELSIF L_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

3016: l_login_id);
3017:
3018: exception
3019: when others then
3020: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3021: fnd_message.set_token('P_SQLCODE',SQLCODE);
3022: fnd_message.set_token('P_SQLERRM',SQLERRM);
3023: fnd_message.set_token('P_API_NAME', l_api_name);
3024: FND_MSG_PUB.add;

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

3017:
3018: exception
3019: when others then
3020: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3021: fnd_message.set_token('P_SQLCODE',SQLCODE);
3022: fnd_message.set_token('P_SQLERRM',SQLERRM);
3023: fnd_message.set_token('P_API_NAME', l_api_name);
3024: FND_MSG_PUB.add;
3025: RAISE fnd_api.g_exc_unexpected_error;

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

3018: exception
3019: when others then
3020: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3021: fnd_message.set_token('P_SQLCODE',SQLCODE);
3022: fnd_message.set_token('P_SQLERRM',SQLERRM);
3023: fnd_message.set_token('P_API_NAME', l_api_name);
3024: FND_MSG_PUB.add;
3025: RAISE fnd_api.g_exc_unexpected_error;
3026:

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

3019: when others then
3020: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3021: fnd_message.set_token('P_SQLCODE',SQLCODE);
3022: fnd_message.set_token('P_SQLERRM',SQLERRM);
3023: fnd_message.set_token('P_API_NAME', l_api_name);
3024: FND_MSG_PUB.add;
3025: RAISE fnd_api.g_exc_unexpected_error;
3026:
3027:

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

3036: open conc_prog_cur;
3037: fetch conc_prog_cur into g_name;
3038: close conc_prog_cur;
3039:
3040: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
3041: fnd_message.set_token('P_NAME',g_name);
3042: fnd_message.set_token('P_ID',l_request);
3043: FND_MSG_PUB.add;
3044:

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

3037: fetch conc_prog_cur into g_name;
3038: close conc_prog_cur;
3039:
3040: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
3041: fnd_message.set_token('P_NAME',g_name);
3042: fnd_message.set_token('P_ID',l_request);
3043: FND_MSG_PUB.add;
3044:
3045: exception when others then

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

3038: close conc_prog_cur;
3039:
3040: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
3041: fnd_message.set_token('P_NAME',g_name);
3042: fnd_message.set_token('P_ID',l_request);
3043: FND_MSG_PUB.add;
3044:
3045: exception when others then
3046: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

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

3042: fnd_message.set_token('P_ID',l_request);
3043: FND_MSG_PUB.add;
3044:
3045: exception 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: FND_MSG_PUB.add;
3044:
3045: exception 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:

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

3044:
3045: exception 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:
3052: RAISE fnd_api.g_exc_unexpected_error;

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

3045: exception 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:
3052: RAISE fnd_api.g_exc_unexpected_error;
3053: end;

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

3088: p_data => L_data,
3089: p_count => L_count,
3090: P_return_code => l_return_code);
3091: if ( l_return_code <> FND_API.G_RET_STS_SUCCESS) then
3092: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
3093: FND_MSG_PUB.add;
3094: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
3095: RAISE FND_API.G_EXC_ERROR;
3096: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

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

Line 3143: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_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_INT_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 3197: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

3193:
3194: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
3195: --x_return_status := fnd_api.g_ret_sts_error;
3196:
3197: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
3198: fnd_msg_pub.add;
3199:
3200: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3201: RAISE FND_API.G_EXC_ERROR;

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

3251: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3252: p_data => x_msg_data);
3253: WHEN OTHERS THEN
3254: ROLLBACK TO ROLE_RELATE_SP;
3255: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3256: fnd_message.set_token('P_SQLCODE',SQLCODE);
3257: fnd_message.set_token('P_SQLERRM',SQLERRM);
3258: fnd_message.set_token('P_API_NAME', l_api_name);
3259: FND_MSG_PUB.add;

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

3252: p_data => x_msg_data);
3253: WHEN OTHERS THEN
3254: ROLLBACK TO ROLE_RELATE_SP;
3255: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3256: fnd_message.set_token('P_SQLCODE',SQLCODE);
3257: fnd_message.set_token('P_SQLERRM',SQLERRM);
3258: fnd_message.set_token('P_API_NAME', l_api_name);
3259: FND_MSG_PUB.add;
3260: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3253: WHEN OTHERS THEN
3254: ROLLBACK TO ROLE_RELATE_SP;
3255: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3256: fnd_message.set_token('P_SQLCODE',SQLCODE);
3257: fnd_message.set_token('P_SQLERRM',SQLERRM);
3258: fnd_message.set_token('P_API_NAME', l_api_name);
3259: FND_MSG_PUB.add;
3260: x_return_status := fnd_api.g_ret_sts_unexp_error;
3261: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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

3254: ROLLBACK TO ROLE_RELATE_SP;
3255: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3256: fnd_message.set_token('P_SQLCODE',SQLCODE);
3257: fnd_message.set_token('P_SQLERRM',SQLERRM);
3258: fnd_message.set_token('P_API_NAME', l_api_name);
3259: FND_MSG_PUB.add;
3260: x_return_status := fnd_api.g_ret_sts_unexp_error;
3261: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3262: p_data => x_msg_data);