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_RELATE_PVT dependencies on FND_MSG_PUB

Line 241: FND_MSG_PUB.Initialize;

237:
238: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
239: IF FND_API.To_boolean(P_INIT_MSG_LIST)
240: THEN
241: FND_MSG_PUB.Initialize;
242: END IF;
243:
244: --GET USER ID AND SYSDATE
245: l_date := sysdate;

Line 270: FND_MSG_PUB.add;

266: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
267:
268: x_return_status := fnd_api.g_ret_sts_error;
269: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
270: FND_MSG_PUB.add;
271: RAISE fnd_api.g_exc_error;
272: end if;
273: end if;
274: end if;

Line 295: FND_MSG_PUB.add;

291: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
292: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
293: x_return_status := fnd_api.g_ret_sts_error;
294: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
295: FND_MSG_PUB.add;
296: RAISE fnd_api.g_exc_error;
297: end if;
298: end if;
299: end if;

Line 320: FND_MSG_PUB.add;

316: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
317: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
318: x_return_status := fnd_api.g_ret_sts_error;
319: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
320: FND_MSG_PUB.add;
321: RAISE fnd_api.g_exc_error;
322: end if;
323: end if;
324: end if;

Line 362: FND_MSG_PUB.add;

358: IF(check_overlap_cur%FOUND)
359: THEN
360: x_return_status := fnd_api.g_ret_sts_error;
361: fnd_message.set_name ('JTF', 'JTF_RS_GRP_REL_OVERLAP');
362: FND_MSG_PUB.add;
363: RAISE fnd_api.g_exc_error;
364: END IF;
365: CLOSE check_overlap_cur;
366:

Line 378: FND_MSG_PUB.add;

374: IF(check_group_dt_cur%NOTFOUND)
375: THEN
376: x_return_status := fnd_api.g_ret_sts_error;
377: fnd_message.set_name ('JTF', 'JTF_RS_CHILD_GRP_DT_ERR');
378: FND_MSG_PUB.add;
379: RAISE fnd_api.g_exc_error;
380:
381: END IF;
382: CLOSE check_group_dt_cur;

Line 393: FND_MSG_PUB.add;

389: IF(check_group_dt_cur%NOTFOUND)
390: THEN
391: x_return_status := fnd_api.g_ret_sts_error;
392: fnd_message.set_name ('JTF', 'JTF_RS_RELATED_GRP_DT_ERR');
393: FND_MSG_PUB.add;
394: RAISE fnd_api.g_exc_error;
395:
396: END IF;
397: CLOSE check_group_dt_cur;

Line 408: FND_MSG_PUB.add;

404: IF(check_dates_cur%NOTFOUND)
405: THEN
406: x_return_status := fnd_api.g_ret_sts_error;
407: fnd_message.set_name ('JTF', 'JTF_RS_CHILD_REL_DT_ERR');
408: FND_MSG_PUB.add;
409: RAISE fnd_api.g_exc_error;
410:
411: END IF;
412: CLOSE check_dates_cur;*/

Line 424: FND_MSG_PUB.add;

420: if(dep_cur%found)
421: then
422: x_return_status := fnd_api.g_ret_sts_error;
423: fnd_message.set_name ('JTF', 'JTF_RS_CYCLIC_DEP_ERR');
424: FND_MSG_PUB.add;
425: RAISE fnd_api.g_exc_error;
426: end if;
427: close dep_cur;
428:

Line 457: FND_MSG_PUB.add;

453: IF(l_return_status <> fnd_api.g_ret_sts_success)
454: THEN
455: x_return_status := fnd_api.g_ret_sts_error;
456: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
457: FND_MSG_PUB.add;
458: RAISE fnd_api.g_exc_error;
459:
460: END IF;
461:

Line 559: FND_MSG_PUB.add;

555:
556: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
557: fnd_message.set_token('P_NAME',g_name);
558: fnd_message.set_token('P_ID',l_request);
559: FND_MSG_PUB.add;
560: exception when others then
561: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
562: fnd_message.set_token('P_SQLCODE',SQLCODE);
563: fnd_message.set_token('P_SQLERRM',SQLERRM);

Line 565: FND_MSG_PUB.add;

561: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
562: fnd_message.set_token('P_SQLCODE',SQLCODE);
563: fnd_message.set_token('P_SQLERRM',SQLERRM);
564: fnd_message.set_token('P_API_NAME', l_api_name);
565: FND_MSG_PUB.add;
566: x_return_status := fnd_api.g_ret_sts_unexp_error;
567: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
568: RAISE fnd_api.g_exc_unexpected_error;
569: end;

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

563: fnd_message.set_token('P_SQLERRM',SQLERRM);
564: fnd_message.set_token('P_API_NAME', l_api_name);
565: FND_MSG_PUB.add;
566: x_return_status := fnd_api.g_ret_sts_unexp_error;
567: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
568: RAISE fnd_api.g_exc_unexpected_error;
569: end;
570: exception when others then
571:

Line 576: FND_MSG_PUB.add;

572: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
573: fnd_message.set_token('P_SQLCODE',SQLCODE);
574: fnd_message.set_token('P_SQLERRM',SQLERRM);
575: fnd_message.set_token('P_API_NAME', l_api_name);
576: FND_MSG_PUB.add;
577: x_return_status := fnd_api.g_ret_sts_unexp_error;
578: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
579: RAISE fnd_api.g_exc_unexpected_error;
580:

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

574: fnd_message.set_token('P_SQLERRM',SQLERRM);
575: fnd_message.set_token('P_API_NAME', l_api_name);
576: FND_MSG_PUB.add;
577: x_return_status := fnd_api.g_ret_sts_unexp_error;
578: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
579: RAISE fnd_api.g_exc_unexpected_error;
580:
581: end;
582:

Line 598: FND_MSG_PUB.add;

594: IF(l_return_status <> fnd_api.g_ret_sts_success)
595: THEN
596: x_return_status := fnd_api.g_ret_sts_error;
597: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DENORM_ERR');
598: FND_MSG_PUB.add;
599: RAISE fnd_api.g_exc_error;
600:
601: END IF;
602:

Line 620: FND_MSG_PUB.add;

616: THEN
617:
618: x_return_status := fnd_api.g_ret_sts_error;
619: fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_ERR');
620: FND_MSG_PUB.add;
621: RAISE fnd_api.g_exc_error;
622:
623: END IF; */
624: END IF; -- end of count check

Line 647: FND_MSG_PUB.add;

643: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
644: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
645: x_return_status := fnd_api.g_ret_sts_error;
646: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
647: FND_MSG_PUB.add;
648: RAISE fnd_api.g_exc_error;
649: end if;
650: end if;
651: end if;

Line 673: FND_MSG_PUB.add;

669: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
670: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
671: x_return_status := fnd_api.g_ret_sts_error;
672: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
673: FND_MSG_PUB.add;
674: RAISE fnd_api.g_exc_error;
675: end if;
676: end if;
677: end if;

Line 699: FND_MSG_PUB.add;

695: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
696: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
697: x_return_status := fnd_api.g_ret_sts_error;
698: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
699: FND_MSG_PUB.add;
700: RAISE fnd_api.g_exc_error;
701: end if;
702: end if;
703: end if;

Line 755: fnd_msg_pub.add;

751:
752: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
753: x_return_status := fnd_api.g_ret_sts_error;
754: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
755: fnd_msg_pub.add;
756: RAISE fnd_api.g_exc_error;
757: END IF;
758: END IF;
759: END IF;

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

767: COMMIT WORK;
768: END IF;
769:
770:
771: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
772:
773: EXCEPTION
774: WHEN fnd_api.g_exc_unexpected_error
775: THEN

Line 778: --FND_MSG_PUB.add;

774: WHEN fnd_api.g_exc_unexpected_error
775: THEN
776: ROLLBACK TO group_relate_sp;
777: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
778: --FND_MSG_PUB.add;
779: --x_return_status := fnd_api.g_ret_sts_unexp_error;
780: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
781: WHEN fnd_api.g_exc_error
782: THEN

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

776: ROLLBACK TO group_relate_sp;
777: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
778: --FND_MSG_PUB.add;
779: --x_return_status := fnd_api.g_ret_sts_unexp_error;
780: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
781: WHEN fnd_api.g_exc_error
782: THEN
783: ROLLBACK TO group_relate_sp;
784: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

780: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
781: WHEN fnd_api.g_exc_error
782: THEN
783: ROLLBACK TO group_relate_sp;
784: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
785:
786: WHEN OTHERS
787: THEN
788: ROLLBACK TO group_relate_sp;

Line 793: FND_MSG_PUB.add;

789: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
790: fnd_message.set_token('P_SQLCODE',SQLCODE);
791: fnd_message.set_token('P_SQLERRM',SQLERRM);
792: fnd_message.set_token('P_API_NAME',l_api_name);
793: FND_MSG_PUB.add;
794: x_return_status := fnd_api.g_ret_sts_unexp_error;
795: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
796:
797:

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

791: fnd_message.set_token('P_SQLERRM',SQLERRM);
792: fnd_message.set_token('P_API_NAME',l_api_name);
793: FND_MSG_PUB.add;
794: x_return_status := fnd_api.g_ret_sts_unexp_error;
795: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
796:
797:
798: END create_resource_group_relate;
799:

Line 1067: FND_MSG_PUB.Initialize;

1063:
1064: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1065: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1066: THEN
1067: FND_MSG_PUB.Initialize;
1068: END IF;
1069:
1070: --GET USER ID AND SYSDATE
1071: l_date := sysdate;

Line 1092: FND_MSG_PUB.add;

1088: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1089: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1090: x_return_status := fnd_api.g_ret_sts_error;
1091: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1092: FND_MSG_PUB.add;
1093: RAISE fnd_api.g_exc_error;
1094: end if;
1095: end if;
1096: end if;

Line 1116: FND_MSG_PUB.add;

1112: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1113: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1114: x_return_status := fnd_api.g_ret_sts_error;
1115: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1116: FND_MSG_PUB.add;
1117: RAISE fnd_api.g_exc_error;
1118: end if;
1119: end if;
1120: end if;

Line 1140: FND_MSG_PUB.add;

1136: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1137: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1138: x_return_status := fnd_api.g_ret_sts_error;
1139: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1140: FND_MSG_PUB.add;
1141: RAISE fnd_api.g_exc_error;
1142: end if;
1143: end if;
1144: end if;

Line 1309: FND_MSG_PUB.add;

1305: IF(check_overlap_cur%FOUND)
1306: THEN
1307: x_return_status := fnd_api.g_ret_sts_error;
1308: fnd_message.set_name ('JTF', 'JTF_RS_GRP_REL_OVERLAP');
1309: FND_MSG_PUB.add;
1310: RAISE fnd_api.g_exc_error;
1311: END IF;
1312: CLOSE check_overlap_cur;
1313:

Line 1329: FND_MSG_PUB.add;

1325: if(dep_cur%found)
1326: then
1327: x_return_status := fnd_api.g_ret_sts_error;
1328: fnd_message.set_name ('JTF', 'JTF_RS_CYCLIC_DEP_ERR');
1329: FND_MSG_PUB.add;
1330: RAISE fnd_api.g_exc_error;
1331: end if;
1332: close dep_cur;
1333: END IF;

Line 1346: FND_MSG_PUB.add;

1342: IF(check_group_dt_cur%NOTFOUND)
1343: THEN
1344: x_return_status := fnd_api.g_ret_sts_error;
1345: fnd_message.set_name ('JTF', 'JTF_RS_CHILD_GRP_DT_ERR');
1346: FND_MSG_PUB.add;
1347: RAISE fnd_api.g_exc_error;
1348:
1349: END IF;
1350: CLOSE check_group_dt_cur;

Line 1361: FND_MSG_PUB.add;

1357: IF(check_group_dt_cur%NOTFOUND)
1358: THEN
1359: x_return_status := fnd_api.g_ret_sts_error;
1360: fnd_message.set_name ('JTF', 'JTF_RS_RELATED_GRP_DT_ERR');
1361: FND_MSG_PUB.add;
1362: RAISE fnd_api.g_exc_error;
1363:
1364: END IF;
1365: CLOSE check_group_dt_cur;

Line 1375: FND_MSG_PUB.add;

1371: IF(check_dates_cur%NOTFOUND)
1372: THEN
1373: x_return_status := fnd_api.g_ret_sts_error;
1374: fnd_message.set_name ('JTF', 'JTF_RS_CHILD_REL_DT_ERR');
1375: FND_MSG_PUB.add;
1376: RAISE fnd_api.g_exc_error;
1377:
1378: END IF;
1379: CLOSE check_dates_cur;*/

Line 1397: fnd_msg_pub.add;

1393:
1394: WHEN OTHERS THEN
1395: x_return_status := fnd_api.g_ret_sts_error;
1396: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1397: fnd_msg_pub.add;
1398: RAISE fnd_api.g_exc_error;
1399:
1400: END;
1401:

Line 1427: FND_MSG_PUB.add;

1423: IF(l_return_status <> fnd_api.g_ret_sts_success)
1424: THEN
1425: x_return_status := fnd_api.g_ret_sts_error;
1426: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
1427: FND_MSG_PUB.add;
1428: RAISE fnd_api.g_exc_error;
1429:
1430: END IF;
1431:

Line 1531: FND_MSG_PUB.add;

1527: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1528: fnd_message.set_token('P_SQLCODE',SQLCODE);
1529: fnd_message.set_token('P_SQLERRM',SQLERRM);
1530: fnd_message.set_token('P_API_NAME', l_api_name);
1531: FND_MSG_PUB.add;
1532: x_return_status := fnd_api.g_ret_sts_unexp_error;
1533: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1534: RAISE fnd_api.g_exc_unexpected_error;
1535:

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

1529: fnd_message.set_token('P_SQLERRM',SQLERRM);
1530: fnd_message.set_token('P_API_NAME', l_api_name);
1531: FND_MSG_PUB.add;
1532: x_return_status := fnd_api.g_ret_sts_unexp_error;
1533: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1534: RAISE fnd_api.g_exc_unexpected_error;
1535:
1536: end;
1537:

Line 1550: FND_MSG_PUB.add;

1546:
1547: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
1548: fnd_message.set_token('P_NAME',g_name);
1549: fnd_message.set_token('P_ID',l_request);
1550: FND_MSG_PUB.add;
1551:
1552: exception when others then
1553:
1554: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 1558: FND_MSG_PUB.add;

1554: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1555: fnd_message.set_token('P_SQLCODE',SQLCODE);
1556: fnd_message.set_token('P_SQLERRM',SQLERRM);
1557: fnd_message.set_token('P_API_NAME', l_api_name);
1558: FND_MSG_PUB.add;
1559: x_return_status := fnd_api.g_ret_sts_unexp_error;
1560: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1561: RAISE fnd_api.g_exc_unexpected_error;
1562:

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

1556: fnd_message.set_token('P_SQLERRM',SQLERRM);
1557: fnd_message.set_token('P_API_NAME', l_api_name);
1558: FND_MSG_PUB.add;
1559: x_return_status := fnd_api.g_ret_sts_unexp_error;
1560: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1561: RAISE fnd_api.g_exc_unexpected_error;
1562:
1563: end;
1564: ELSE

Line 1578: FND_MSG_PUB.add;

1574: IF(l_return_status <> fnd_api.g_ret_sts_success)
1575: THEN
1576: x_return_status := fnd_api.g_ret_sts_error;
1577: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DENORM_ERR');
1578: FND_MSG_PUB.add;
1579: RAISE fnd_api.g_exc_error;
1580:
1581: END IF;
1582: END IF; --end of count check

Line 1608: FND_MSG_PUB.add;

1604: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1605: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1606: x_return_status := fnd_api.g_ret_sts_error;
1607: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1608: FND_MSG_PUB.add;
1609: RAISE fnd_api.g_exc_error;
1610: end if;
1611: end if;
1612: end if;

Line 1631: FND_MSG_PUB.add;

1627: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1628: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1629: x_return_status := fnd_api.g_ret_sts_error;
1630: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1631: FND_MSG_PUB.add;
1632: RAISE fnd_api.g_exc_error;
1633: end if;
1634: end if;
1635: end if;

Line 1654: FND_MSG_PUB.add;

1650: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1651: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1652: x_return_status := fnd_api.g_ret_sts_error;
1653: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1654: FND_MSG_PUB.add;
1655: RAISE fnd_api.g_exc_error;
1656: end if;
1657: end if;
1658: end if;

Line 1704: fnd_msg_pub.add;

1700:
1701: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1702: x_return_status := fnd_api.g_ret_sts_error;
1703: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1704: fnd_msg_pub.add;
1705: RAISE fnd_api.g_exc_error;
1706: END IF;
1707: END IF;
1708: END IF;

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

1716: COMMIT WORK;
1717: END IF;
1718:
1719:
1720: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1721:
1722:
1723: EXCEPTION
1724: WHEN fnd_api.g_exc_unexpected_error

Line 1728: --FND_MSG_PUB.add;

1724: WHEN fnd_api.g_exc_unexpected_error
1725: THEN
1726: ROLLBACK TO group_relate_sp;
1727: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
1728: --FND_MSG_PUB.add;
1729: --x_return_status := fnd_api.g_ret_sts_unexp_error;
1730: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1731: WHEN fnd_api.g_exc_error
1732: THEN

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

1726: ROLLBACK TO group_relate_sp;
1727: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
1728: --FND_MSG_PUB.add;
1729: --x_return_status := fnd_api.g_ret_sts_unexp_error;
1730: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1731: WHEN fnd_api.g_exc_error
1732: THEN
1733: ROLLBACK TO group_relate_sp;
1734: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1730: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1731: WHEN fnd_api.g_exc_error
1732: THEN
1733: ROLLBACK TO group_relate_sp;
1734: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1735:
1736: WHEN OTHERS
1737: THEN
1738: ROLLBACK TO group_relate_sp;

Line 1743: FND_MSG_PUB.add;

1739: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1740: fnd_message.set_token('P_SQLCODE',SQLCODE);
1741: fnd_message.set_token('P_SQLERRM',SQLERRM);
1742: fnd_message.set_token('P_API_NAME',l_api_name);
1743: FND_MSG_PUB.add;
1744: x_return_status := fnd_api.g_ret_sts_unexp_error;
1745: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1746:
1747: END update_resource_group_relate;

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

1741: fnd_message.set_token('P_SQLERRM',SQLERRM);
1742: fnd_message.set_token('P_API_NAME',l_api_name);
1743: FND_MSG_PUB.add;
1744: x_return_status := fnd_api.g_ret_sts_unexp_error;
1745: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1746:
1747: END update_resource_group_relate;
1748:
1749:

Line 1873: FND_MSG_PUB.Initialize;

1869:
1870: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1871: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1872: THEN
1873: FND_MSG_PUB.Initialize;
1874: END IF;
1875:
1876: --GET USER ID AND SYSDATE
1877: l_date := sysdate;

Line 1896: FND_MSG_PUB.add;

1892: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1893: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1894: x_return_status := fnd_api.g_ret_sts_error;
1895: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1896: FND_MSG_PUB.add;
1897: RAISE fnd_api.g_exc_error;
1898: end if;
1899: end if;
1900: end if;

Line 1919: FND_MSG_PUB.add;

1915: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1916: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1917: x_return_status := fnd_api.g_ret_sts_error;
1918: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1919: FND_MSG_PUB.add;
1920: RAISE fnd_api.g_exc_error;
1921: end if;
1922: end if;
1923: end if;

Line 1944: FND_MSG_PUB.add;

1940: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1941: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1942: x_return_status := fnd_api.g_ret_sts_error;
1943: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1944: FND_MSG_PUB.add;
1945: RAISE fnd_api.g_exc_error;
1946: end if;
1947: end if;
1948: end if;

Line 1972: FND_MSG_PUB.add;

1968: IF(l_return_status <> fnd_api.g_ret_sts_success)
1969: THEN
1970: x_return_status := fnd_api.g_ret_sts_error;
1971: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');
1972: FND_MSG_PUB.add;
1973: RAISE fnd_api.g_exc_error;
1974:
1975: END IF;
1976:

Line 1993: fnd_msg_pub.add;

1989:
1990: WHEN OTHERS THEN
1991: x_return_status := fnd_api.g_ret_sts_error;
1992: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1993: fnd_msg_pub.add;
1994: RAISE fnd_api.g_exc_error;
1995:
1996: END;
1997:

Line 2087: FND_MSG_PUB.add;

2083: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2084: fnd_message.set_token('P_SQLCODE',SQLCODE);
2085: fnd_message.set_token('P_SQLERRM',SQLERRM);
2086: fnd_message.set_token('P_API_NAME', l_api_name);
2087: FND_MSG_PUB.add;
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2090: RAISE fnd_api.g_exc_unexpected_error;
2091:

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

2085: fnd_message.set_token('P_SQLERRM',SQLERRM);
2086: fnd_message.set_token('P_API_NAME', l_api_name);
2087: FND_MSG_PUB.add;
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2090: RAISE fnd_api.g_exc_unexpected_error;
2091:
2092: end;
2093: begin

Line 2105: FND_MSG_PUB.add;

2101:
2102: fnd_message.set_name ('JTF', 'JTF_RS_CONC_START');
2103: fnd_message.set_token('P_NAME',g_name);
2104: fnd_message.set_token('P_ID',l_request);
2105: FND_MSG_PUB.add;
2106:
2107: exception when others then
2108: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2109: fnd_message.set_token('P_SQLCODE',SQLCODE);

Line 2112: FND_MSG_PUB.add;

2108: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2109: fnd_message.set_token('P_SQLCODE',SQLCODE);
2110: fnd_message.set_token('P_SQLERRM',SQLERRM);
2111: fnd_message.set_token('P_API_NAME', l_api_name);
2112: FND_MSG_PUB.add;
2113: x_return_status := fnd_api.g_ret_sts_unexp_error;
2114: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2115: RAISE fnd_api.g_exc_unexpected_error;
2116:

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

2110: fnd_message.set_token('P_SQLERRM',SQLERRM);
2111: fnd_message.set_token('P_API_NAME', l_api_name);
2112: FND_MSG_PUB.add;
2113: x_return_status := fnd_api.g_ret_sts_unexp_error;
2114: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2115: RAISE fnd_api.g_exc_unexpected_error;
2116:
2117: end;
2118: ELSE

Line 2143: FND_MSG_PUB.add;

2139: IF(l_return_status <> fnd_api.g_ret_sts_success)
2140: THEN
2141: x_return_status := fnd_api.g_ret_sts_error;
2142: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DENORM_ERR');
2143: FND_MSG_PUB.add;
2144: RAISE fnd_api.g_exc_error;
2145:
2146: END IF;
2147: END IF; -- end of count

Line 2166: FND_MSG_PUB.add;

2162: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
2163: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
2164: x_return_status := fnd_api.g_ret_sts_error;
2165: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
2166: FND_MSG_PUB.add;
2167: RAISE fnd_api.g_exc_error;
2168: end if;
2169: end if;
2170: end if;

Line 2188: FND_MSG_PUB.add;

2184: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
2185: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
2186: x_return_status := fnd_api.g_ret_sts_error;
2187: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
2188: FND_MSG_PUB.add;
2189: RAISE fnd_api.g_exc_error;
2190: end if;
2191: end if;
2192: end if;

Line 2210: FND_MSG_PUB.add;

2206: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
2207: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
2208: x_return_status := fnd_api.g_ret_sts_error;
2209: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
2210: FND_MSG_PUB.add;
2211: RAISE fnd_api.g_exc_error;
2212: end if;
2213: end if;
2214: end if;

Line 2260: fnd_msg_pub.add;

2256:
2257: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2258: x_return_status := fnd_api.g_ret_sts_error;
2259: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
2260: fnd_msg_pub.add;
2261: RAISE fnd_api.g_exc_error;
2262: END IF;
2263: END IF;
2264: END IF;

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

2271: COMMIT WORK;
2272: END IF;
2273:
2274:
2275: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2276:
2277:
2278: EXCEPTION
2279: WHEN fnd_api.g_exc_unexpected_error

Line 2283: --FND_MSG_PUB.add;

2279: WHEN fnd_api.g_exc_unexpected_error
2280: THEN
2281: -- ROLLBACK TO group_relate_sp;
2282: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
2283: --FND_MSG_PUB.add;
2284: --x_return_status := fnd_api.g_ret_sts_unexp_error;
2285: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2286: WHEN fnd_api.g_exc_error
2287: THEN

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

2281: -- ROLLBACK TO group_relate_sp;
2282: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
2283: --FND_MSG_PUB.add;
2284: --x_return_status := fnd_api.g_ret_sts_unexp_error;
2285: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2286: WHEN fnd_api.g_exc_error
2287: THEN
2288: -- ROLLBACK TO group_relate_sp;
2289: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2285: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2286: WHEN fnd_api.g_exc_error
2287: THEN
2288: -- ROLLBACK TO group_relate_sp;
2289: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2290:
2291: WHEN OTHERS
2292: THEN
2293: -- ROLLBACK TO group_relate_sp;

Line 2298: FND_MSG_PUB.add;

2294: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2295: fnd_message.set_token('P_SQLCODE',SQLCODE);
2296: fnd_message.set_token('P_SQLERRM',SQLERRM);
2297: fnd_message.set_token('P_API_NAME',l_api_name);
2298: FND_MSG_PUB.add;
2299: x_return_status := fnd_api.g_ret_sts_unexp_error;
2300: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2301:
2302:

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

2296: fnd_message.set_token('P_SQLERRM',SQLERRM);
2297: fnd_message.set_token('P_API_NAME',l_api_name);
2298: FND_MSG_PUB.add;
2299: x_return_status := fnd_api.g_ret_sts_unexp_error;
2300: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2301:
2302:
2303: END delete_resource_group_relate;
2304: END jtf_rs_group_relate_pvt;