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

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

49:
50: EXCEPTION
51: WHEN OTHERS THEN
52: ROLLBACK TO assign_value_sp;
53: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
54: fnd_message.set_token('P_SQLCODE',SQLCODE);
55: fnd_message.set_token('P_SQLERRM',SQLERRM);
56: fnd_message.set_token('P_API_NAME',l_api_name);
57: FND_MSG_PUB.add;

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

50: EXCEPTION
51: WHEN OTHERS THEN
52: ROLLBACK TO assign_value_sp;
53: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
54: fnd_message.set_token('P_SQLCODE',SQLCODE);
55: fnd_message.set_token('P_SQLERRM',SQLERRM);
56: fnd_message.set_token('P_API_NAME',l_api_name);
57: FND_MSG_PUB.add;
58: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

51: WHEN OTHERS THEN
52: ROLLBACK TO assign_value_sp;
53: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
54: fnd_message.set_token('P_SQLCODE',SQLCODE);
55: fnd_message.set_token('P_SQLERRM',SQLERRM);
56: fnd_message.set_token('P_API_NAME',l_api_name);
57: FND_MSG_PUB.add;
58: x_return_status := fnd_api.g_ret_sts_unexp_error;
59: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

52: ROLLBACK TO assign_value_sp;
53: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
54: fnd_message.set_token('P_SQLCODE',SQLCODE);
55: fnd_message.set_token('P_SQLERRM',SQLERRM);
56: fnd_message.set_token('P_API_NAME',l_api_name);
57: FND_MSG_PUB.add;
58: x_return_status := fnd_api.g_ret_sts_unexp_error;
59: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
60:

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

183: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
184:
185: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
186:
187: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
188: fnd_msg_pub.add;
189:
190: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
191: RAISE FND_API.G_EXC_ERROR;

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

222: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
223:
224: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
225:
226: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
227: fnd_msg_pub.add;
228:
229: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
230: RAISE FND_API.G_EXC_ERROR;

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

260:
261: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
262:
263:
264: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
265: fnd_msg_pub.add;
266:
267: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
268: RAISE FND_API.G_EXC_ERROR;

Line 297: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_EXISTS');

293: -- dbms_output.put_line('Resource already exists in the group');
294:
295: x_return_status := fnd_api.g_ret_sts_error;
296:
297: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_EXISTS');
298: fnd_msg_pub.add;
299:
300: RAISE fnd_api.g_exc_error;
301:

Line 402: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

398:
399: -- dbms_output.put_line('Error in Table Handler');
400:
401:
402: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
403: fnd_msg_pub.add;
404:
405: IF c_jtf_rs_group_members%ISOPEN THEN
406:

Line 442: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

438:
439:
440: IF c_jtf_rs_active_grp_mbrs%NOTFOUND THEN
441:
442: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
443: fnd_msg_pub.add;
444:
445: IF c_jtf_rs_active_grp_mbrs%ISOPEN THEN
446:

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

510:
511: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
512:
513:
514: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
515: fnd_msg_pub.add;
516:
517: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
518: RAISE FND_API.G_EXC_ERROR;

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

551:
552: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
553:
554:
555: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
556: fnd_msg_pub.add;
557:
558:
559: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

591:
592: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
593:
594:
595: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
596: fnd_msg_pub.add;
597:
598:
599: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

653: -- dbms_output.put_line('Returned Error status from the Message Generation API');
654:
655: x_return_status := fnd_api.g_ret_sts_unexp_error;
656:
657: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
658: fnd_msg_pub.add;
659:
660:
661: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

710: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
711: p_data => x_msg_data);
712: WHEN OTHERS THEN
713: ROLLBACK TO create_resource_member_pvt;
714: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
715: fnd_message.set_token('P_SQLCODE',SQLCODE);
716: fnd_message.set_token('P_SQLERRM',SQLERRM);
717: fnd_message.set_token('P_API_NAME', l_api_name);
718: FND_MSG_PUB.add;

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

711: p_data => x_msg_data);
712: WHEN OTHERS THEN
713: ROLLBACK TO create_resource_member_pvt;
714: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
715: fnd_message.set_token('P_SQLCODE',SQLCODE);
716: fnd_message.set_token('P_SQLERRM',SQLERRM);
717: fnd_message.set_token('P_API_NAME', l_api_name);
718: FND_MSG_PUB.add;
719: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

712: WHEN OTHERS THEN
713: ROLLBACK TO create_resource_member_pvt;
714: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
715: fnd_message.set_token('P_SQLCODE',SQLCODE);
716: fnd_message.set_token('P_SQLERRM',SQLERRM);
717: fnd_message.set_token('P_API_NAME', l_api_name);
718: FND_MSG_PUB.add;
719: x_return_status := fnd_api.g_ret_sts_unexp_error;
720: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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

713: ROLLBACK TO create_resource_member_pvt;
714: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
715: fnd_message.set_token('P_SQLCODE',SQLCODE);
716: fnd_message.set_token('P_SQLERRM',SQLERRM);
717: fnd_message.set_token('P_API_NAME', l_api_name);
718: FND_MSG_PUB.add;
719: x_return_status := fnd_api.g_ret_sts_unexp_error;
720: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
721: p_data => x_msg_data);

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

842: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
843:
844: x_return_status := fnd_api.g_ret_sts_unexp_error;
845:
846: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
847: fnd_msg_pub.add;
848:
849: RAISE fnd_api.g_exc_unexpected_error;
850:

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

878: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
879:
880: x_return_status := fnd_api.g_ret_sts_unexp_error;
881:
882: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
883: fnd_msg_pub.add;
884:
885: RAISE fnd_api.g_exc_unexpected_error;
886:

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

912: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
913:
914: x_return_status := fnd_api.g_ret_sts_unexp_error;
915:
916: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
917: fnd_msg_pub.add;
918:
919: RAISE fnd_api.g_exc_unexpected_error;
920:

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

927: OPEN c_rs_group_members_update(l_group_member_id);
928: FETCH c_rs_group_members_update INTO rs_group_member_rec;
929: IF c_rs_group_members_update%NOTFOUND THEN
930: CLOSE c_rs_group_members_update;
931: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GRP_MBR_ID');
932: fnd_message.set_token('P_GRP_MBR_ID', p_group_member_id);
933: fnd_msg_pub.add;
934: x_return_status := fnd_api.g_ret_sts_unexp_error;
935: RAISE fnd_api.g_exc_unexpected_error;

Line 932: fnd_message.set_token('P_GRP_MBR_ID', p_group_member_id);

928: FETCH c_rs_group_members_update INTO rs_group_member_rec;
929: IF c_rs_group_members_update%NOTFOUND THEN
930: CLOSE c_rs_group_members_update;
931: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GRP_MBR_ID');
932: fnd_message.set_token('P_GRP_MBR_ID', p_group_member_id);
933: fnd_msg_pub.add;
934: x_return_status := fnd_api.g_ret_sts_unexp_error;
935: RAISE fnd_api.g_exc_unexpected_error;
936: END IF;

Line 1010: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

1006: EXCEPTION
1007: WHEN NO_DATA_FOUND THEN
1008: CLOSE c_rs_group_members_update;
1009: x_return_status := fnd_api.g_ret_sts_unexp_error;
1010: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1011: fnd_msg_pub.add;
1012: RAISE fnd_api.g_exc_unexpected_error;
1013: END;
1014:

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

1038: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1039:
1040: x_return_status := fnd_api.g_ret_sts_unexp_error;
1041:
1042: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1043: fnd_msg_pub.add;
1044:
1045: RAISE fnd_api.g_exc_unexpected_error;
1046:

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

1074: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
1075:
1076: x_return_status := fnd_api.g_ret_sts_unexp_error;
1077:
1078: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1079: fnd_msg_pub.add;
1080:
1081: RAISE fnd_api.g_exc_unexpected_error;
1082:

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

1108: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1109:
1110: x_return_status := fnd_api.g_ret_sts_unexp_error;
1111:
1112: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1113: fnd_msg_pub.add;
1114:
1115: RAISE fnd_api.g_exc_unexpected_error;
1116:

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

1165: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1166:
1167: x_return_status := fnd_api.g_ret_sts_unexp_error;
1168:
1169: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1170: fnd_msg_pub.add;
1171:
1172: RAISE fnd_api.g_exc_unexpected_error;
1173:

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

1198: --DBMS_OUTPUT.put_line (' ========================================== ');
1199: --DBMS_OUTPUT.put_line (' =========== Raised Others in Update Resource Role Pub =============');
1200: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
1201: ROLLBACK TO update_rs_group_members_pvt;
1202: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1203: fnd_message.set_token('P_SQLCODE',SQLCODE);
1204: fnd_message.set_token('P_SQLERRM',SQLERRM);
1205: fnd_message.set_token('P_API_NAME',l_api_name);
1206: FND_MSG_PUB.add;

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

1199: --DBMS_OUTPUT.put_line (' =========== Raised Others in Update Resource Role Pub =============');
1200: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
1201: ROLLBACK TO update_rs_group_members_pvt;
1202: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1203: fnd_message.set_token('P_SQLCODE',SQLCODE);
1204: fnd_message.set_token('P_SQLERRM',SQLERRM);
1205: fnd_message.set_token('P_API_NAME',l_api_name);
1206: FND_MSG_PUB.add;
1207: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1200: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
1201: ROLLBACK TO update_rs_group_members_pvt;
1202: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1203: fnd_message.set_token('P_SQLCODE',SQLCODE);
1204: fnd_message.set_token('P_SQLERRM',SQLERRM);
1205: fnd_message.set_token('P_API_NAME',l_api_name);
1206: FND_MSG_PUB.add;
1207: x_return_status := fnd_api.g_ret_sts_unexp_error;
1208: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1201: ROLLBACK TO update_rs_group_members_pvt;
1202: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1203: fnd_message.set_token('P_SQLCODE',SQLCODE);
1204: fnd_message.set_token('P_SQLERRM',SQLERRM);
1205: fnd_message.set_token('P_API_NAME',l_api_name);
1206: FND_MSG_PUB.add;
1207: x_return_status := fnd_api.g_ret_sts_unexp_error;
1208: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1209:

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

1316: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1317:
1318: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
1319:
1320: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1321: fnd_msg_pub.add;
1322:
1323:
1324: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

1357: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1358:
1359: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
1360:
1361: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1362: fnd_msg_pub.add;
1363:
1364:
1365: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

1396:
1397: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1398:
1399:
1400: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1401: fnd_msg_pub.add;
1402:
1403: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1404: RAISE FND_API.G_EXC_ERROR;

Line 1433: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP_MEMBER');

1429: CLOSE c_group_member_id;
1430:
1431: END IF;
1432:
1433: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP_MEMBER');
1434: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);
1435: fnd_msg_pub.add;
1436:
1437: RAISE fnd_api.g_exc_error;

Line 1434: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);

1430:
1431: END IF;
1432:
1433: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP_MEMBER');
1434: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);
1435: fnd_msg_pub.add;
1436:
1437: RAISE fnd_api.g_exc_error;
1438:

Line 1470: fnd_message.set_name('JTF', 'JTF_RS_ERROR_ROLE_COUNT');

1466: CLOSE c_related_role_count;
1467:
1468: END IF;
1469:
1470: fnd_message.set_name('JTF', 'JTF_RS_ERROR_ROLE_COUNT');
1471: fnd_msg_pub.add;
1472:
1473: RAISE fnd_api.g_exc_error;
1474:

Line 1487: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_ROLE_EXIST');

1483: CLOSE c_related_role_count;
1484:
1485: END IF;
1486:
1487: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_ROLE_EXIST');
1488: fnd_msg_pub.add;
1489:
1490: x_return_status := fnd_api.g_ret_sts_unexp_error;
1491:

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

1514: -- dbms_output.put_line('Error in Locking the Row');
1515:
1516: x_return_status := fnd_api.g_ret_sts_unexp_error;
1517:
1518: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1519: fnd_msg_pub.add;
1520:
1521: RAISE fnd_api.g_exc_error;
1522:

Line 1595: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

1591: WHEN NO_DATA_FOUND THEN
1592:
1593: -- dbms_output.put_line('Error in Table Handler');
1594:
1595: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1596: fnd_msg_pub.add;
1597:
1598: RAISE fnd_api.g_exc_error;
1599:

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

1626:
1627: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1628:
1629:
1630: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1631: fnd_msg_pub.add;
1632:
1633:
1634: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

1666: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1667:
1668: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
1669:
1670: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1671: fnd_msg_pub.add;
1672:
1673:
1674: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

1704: x_return_status => x_return_status);
1705:
1706: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1707:
1708: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1709: fnd_msg_pub.add;
1710:
1711:
1712: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

1764: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1765:
1766: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1767:
1768: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1769: fnd_msg_pub.add;
1770:
1771:
1772: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

1805: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1806: p_data => x_msg_data);
1807: WHEN OTHERS THEN
1808: ROLLBACK TO delete_resource_member_pvt;
1809: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1810: fnd_message.set_token('P_SQLCODE',SQLCODE);
1811: fnd_message.set_token('P_SQLERRM',SQLERRM);
1812: fnd_message.set_token('P_API_NAME', l_api_name);
1813: FND_MSG_PUB.add;

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

1806: p_data => x_msg_data);
1807: WHEN OTHERS THEN
1808: ROLLBACK TO delete_resource_member_pvt;
1809: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1810: fnd_message.set_token('P_SQLCODE',SQLCODE);
1811: fnd_message.set_token('P_SQLERRM',SQLERRM);
1812: fnd_message.set_token('P_API_NAME', l_api_name);
1813: FND_MSG_PUB.add;
1814: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1807: WHEN OTHERS THEN
1808: ROLLBACK TO delete_resource_member_pvt;
1809: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1810: fnd_message.set_token('P_SQLCODE',SQLCODE);
1811: fnd_message.set_token('P_SQLERRM',SQLERRM);
1812: fnd_message.set_token('P_API_NAME', l_api_name);
1813: FND_MSG_PUB.add;
1814: x_return_status := fnd_api.g_ret_sts_unexp_error;
1815: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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

1808: ROLLBACK TO delete_resource_member_pvt;
1809: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1810: fnd_message.set_token('P_SQLCODE',SQLCODE);
1811: fnd_message.set_token('P_SQLERRM',SQLERRM);
1812: fnd_message.set_token('P_API_NAME', l_api_name);
1813: FND_MSG_PUB.add;
1814: x_return_status := fnd_api.g_ret_sts_unexp_error;
1815: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1816: p_data => x_msg_data);