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_MSG_PUB

Line 102: FND_MSG_PUB.add;

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:
106: for grp_mem_rec in grp_mem_cur

Line 123: FND_MSG_PUB.add;

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
127:

Line 145: FND_MSG_PUB.add;

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
149:

Line 507: FND_MSG_PUB.Initialize;

503:
504: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
505: IF FND_API.To_boolean(P_INIT_MSG_LIST)
506: THEN
507: FND_MSG_PUB.Initialize;
508: END IF;
509:
510: --dbms_output.put_line ('Debug Message 10');
511:

Line 537: FND_MSG_PUB.add;

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
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 564: FND_MSG_PUB.add;

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
568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 591: FND_MSG_PUB.add;

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
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 610: FND_MSG_PUB.add;

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:
614:

Line 619: FND_MSG_PUB.add;

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:
623: IF(l_role_resource_type = 'RS_TEAM' or

Line 634: FND_MSG_PUB.add;

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;
638:

Line 686: FND_MSG_PUB.add;

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
690:

Line 711: fnd_msg_pub.add;

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;
715:

Line 739: FND_MSG_PUB.add;

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;
743: ELSIF((l_role_resource_type = 'RS_TEAM_MEMBER') AND

Line 763: FND_MSG_PUB.add;

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;
767: END IF;

Line 788: FND_MSG_PUB.add;

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:
792: IF(team_rec.end_date_active is not null AND l_end_date_active is null)

Line 795: FND_MSG_PUB.add;

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:
799: --dbms_output.put_line ('Debug Message 17');

Line 814: FND_MSG_PUB.add;

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:
818:

Line 822: FND_MSG_PUB.add;

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:
826: --exclusive flag validation

Line 835: FND_MSG_PUB.add;

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:
839: close c_exclusive_group_check_cur;

Line 852: FND_MSG_PUB.add;

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')
856: --check against group start and end dates

Line 868: FND_MSG_PUB.add;

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')
872: --check against team start and end dates

Line 884: FND_MSG_PUB.add;

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;
888:

Line 1023: FND_MSG_PUB.add;

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:
1027: end;

Line 1043: FND_MSG_PUB.add;

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');
1047: fnd_message.set_token('P_SQLCODE',SQLCODE);

Line 1050: FND_MSG_PUB.add;

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:
1054: else

Line 1092: FND_MSG_PUB.add;

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
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1121: FND_MSG_PUB.add;

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
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1148: FND_MSG_PUB.add;

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
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1223: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1219: COMMIT WORK;
1220: END IF;
1221:
1222:
1223: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1224:
1225: /* Calling publish API to raise create resource role relation event. */
1226: /* added by baianand on 04/09/2003 */
1227:

Line 1253: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

1249: EXCEPTION
1250: WHEN fnd_api.g_exc_error THEN
1251: ROLLBACK TO ROLE_RELATE_SP;
1252: x_return_status := fnd_api.g_ret_sts_error;
1253: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1254: p_data => x_msg_data);
1255: WHEN fnd_api.g_exc_unexpected_error THEN
1256: ROLLBACK TO ROLE_RELATE_SP;
1257: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1258: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

1254: p_data => x_msg_data);
1255: WHEN fnd_api.g_exc_unexpected_error THEN
1256: ROLLBACK TO ROLE_RELATE_SP;
1257: x_return_status := fnd_api.g_ret_sts_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');

Line 1266: FND_MSG_PUB.add;

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);
1270:

Line 1268: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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);
1270:
1271: END create_resource_role_relate;
1272:

Line 1663: FND_MSG_PUB.Initialize;

1659:
1660: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1661: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1662: THEN
1663: FND_MSG_PUB.Initialize;
1664: END IF;
1665:
1666:
1667: --GET USER ID AND SYSDATE

Line 1687: FND_MSG_PUB.add;

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
1691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1714: FND_MSG_PUB.add;

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
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1741: FND_MSG_PUB.add;

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
1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1892: FND_MSG_PUB.add;

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:
1896:

Line 1903: FND_MSG_PUB.add;

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:
1907:

Line 1919: FND_MSG_PUB.add;

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;
1923:

Line 1974: FND_MSG_PUB.add;

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:
1978: --end of overlapping date range check

Line 2000: fnd_msg_pub.add;

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;
2004:

Line 2030: FND_MSG_PUB.add;

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;
2034: ELSIF((l_role_resource_type = 'RS_TEAM_MEMBER') AND

Line 2053: FND_MSG_PUB.add;

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;
2057:

Line 2073: FND_MSG_PUB.add;

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:
2077: IF(team_rec.end_date_active is not null AND l_end_date_active is null)

Line 2080: FND_MSG_PUB.add;

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:
2084: ELSIF(l_role_resource_type = 'RS_GROUP_MEMBER')

Line 2096: FND_MSG_PUB.add;

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:
2100:

Line 2105: FND_MSG_PUB.add;

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:
2109: --exclusive flag validation

Line 2118: FND_MSG_PUB.add;

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:
2122: close c_exclusive_group_check_cur;

Line 2136: FND_MSG_PUB.add;

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:
2140: ELSIF(l_role_resource_type = 'RS_GROUP')

Line 2152: FND_MSG_PUB.add;

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')
2156: THEN

Line 2167: FND_MSG_PUB.add;

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;
2171:

Line 2187: FND_MSG_PUB.add;

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;
2191:

Line 2201: FND_MSG_PUB.add;

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;
2205:

Line 2221: --FND_MSG_PUB.add;

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:
2225: END IF;

Line 2239: fnd_msg_pub.add;

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;
2243:

Line 2265: FND_MSG_PUB.add;

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
2269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2386: FND_MSG_PUB.add;

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:
2390: end;

Line 2405: FND_MSG_PUB.add;

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

Line 2413: FND_MSG_PUB.add;

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:
2417: else

Line 2457: FND_MSG_PUB.add;

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
2461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2483: FND_MSG_PUB.add;

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
2487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2512: FND_MSG_PUB.add;

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
2516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2567: fnd_msg_pub.add;

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
2571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2592: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2588: COMMIT WORK;
2589: END IF;
2590:
2591:
2592: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2593:
2594: EXCEPTION
2595: WHEN fnd_api.g_exc_error THEN
2596: ROLLBACK TO ROLE_RELATE_SP;

Line 2598: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

2594: EXCEPTION
2595: WHEN fnd_api.g_exc_error THEN
2596: ROLLBACK TO ROLE_RELATE_SP;
2597: x_return_status := fnd_api.g_ret_sts_error;
2598: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2599: p_data => x_msg_data);
2600: WHEN fnd_api.g_exc_unexpected_error THEN
2601: ROLLBACK TO ROLE_RELATE_SP;
2602: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2603: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

2599: p_data => x_msg_data);
2600: WHEN fnd_api.g_exc_unexpected_error THEN
2601: ROLLBACK TO ROLE_RELATE_SP;
2602: x_return_status := fnd_api.g_ret_sts_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');

Line 2611: FND_MSG_PUB.add;

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);
2615:

Line 2613: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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);
2615:
2616: END update_resource_role_relate;
2617:

Line 2795: FND_MSG_PUB.Initialize;

2791:
2792: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2793: IF FND_API.To_boolean(P_INIT_MSG_LIST)
2794: THEN
2795: FND_MSG_PUB.Initialize;
2796: END IF;
2797:
2798: -- user hook calls for customer
2799: -- Customer pre- processing section - mandatory

Line 2811: FND_MSG_PUB.add;

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
2815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2836: FND_MSG_PUB.add;

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
2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2861: FND_MSG_PUB.add;

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
2865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2911: FND_MSG_PUB.add;

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;
2915: CLOSE chk_team_cur;

Line 2923: FND_MSG_PUB.add;

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;
2927: CLOSE chk_grp_cur;

Line 2953: --FND_MSG_PUB.add;

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
2957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3050: FND_MSG_PUB.add;

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:
3054: end;

Line 3069: FND_MSG_PUB.add;

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');
3073: fnd_message.set_token('P_SQLCODE',SQLCODE);

Line 3076: FND_MSG_PUB.add;

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;
3080:

Line 3119: FND_MSG_PUB.add;

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
3123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3144: FND_MSG_PUB.add;

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
3148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3170: FND_MSG_PUB.add;

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
3174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3224: fnd_msg_pub.add;

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;
3228: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3266: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

3262: end;
3263:
3264: /* End of publish API call */
3265:
3266: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3267:
3268: EXCEPTION
3269: WHEN fnd_api.g_exc_error THEN
3270: ROLLBACK TO ROLE_RELATE_SP;

Line 3272: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

3268: EXCEPTION
3269: WHEN fnd_api.g_exc_error THEN
3270: ROLLBACK TO ROLE_RELATE_SP;
3271: x_return_status := fnd_api.g_ret_sts_error;
3272: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3273: p_data => x_msg_data);
3274: WHEN fnd_api.g_exc_unexpected_error THEN
3275: ROLLBACK TO ROLE_RELATE_SP;
3276: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3277: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

3273: p_data => x_msg_data);
3274: WHEN fnd_api.g_exc_unexpected_error THEN
3275: ROLLBACK TO ROLE_RELATE_SP;
3276: x_return_status := fnd_api.g_ret_sts_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');

Line 3285: FND_MSG_PUB.add;

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);
3289:

Line 3287: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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);
3289:
3290: END delete_resource_role_relate;
3291: