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_MESSAGE

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

265: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
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;

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

290: P_return_code => l_return_code);
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;

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

315: P_return_code => l_return_code);
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;

Line 361: fnd_message.set_name ('JTF', 'JTF_RS_GRP_REL_OVERLAP');

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

Line 377: fnd_message.set_name ('JTF', 'JTF_RS_CHILD_GRP_DT_ERR');

373: FETCH check_group_dt_cur INTO check_group_dt_rec;
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;

Line 392: fnd_message.set_name ('JTF', 'JTF_RS_RELATED_GRP_DT_ERR');

388: FETCH check_group_dt_cur INTO check_group_dt_rec;
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;

Line 407: fnd_message.set_name ('JTF', 'JTF_RS_CHILD_REL_DT_ERR');

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

Line 423: fnd_message.set_name ('JTF', 'JTF_RS_CYCLIC_DEP_ERR');

419: fetch dep_cur into dep_rec;
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;

Line 456: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');

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

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

552: open conc_prog_cur;
553: fetch conc_prog_cur into g_name;
554: close conc_prog_cur;
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

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

553: fetch conc_prog_cur into g_name;
554: close conc_prog_cur;
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');

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

554: close conc_prog_cur;
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);

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

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);
564: fnd_message.set_token('P_API_NAME', l_api_name);
565: FND_MSG_PUB.add;

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

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

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

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

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

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

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

568: RAISE fnd_api.g_exc_unexpected_error;
569: end;
570: exception when others then
571:
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;

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

569: end;
570: exception when others then
571:
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;

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

570: exception when others then
571:
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);

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

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

Line 597: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DENORM_ERR');

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

Line 619: fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_ERR');

615: IF(l_return_status <> fnd_api.g_ret_sts_success)
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; */

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

642: P_return_code => l_return_code);
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;

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

668: P_return_code => l_return_code);
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;

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

694: P_return_code => l_return_code);
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;

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

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

Line 777: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');

773: EXCEPTION
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

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

785:
786: WHEN OTHERS
787: THEN
788: ROLLBACK TO group_relate_sp;
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;

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

786: WHEN OTHERS
787: THEN
788: ROLLBACK TO group_relate_sp;
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;

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

787: THEN
788: ROLLBACK TO group_relate_sp;
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);

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

788: ROLLBACK TO group_relate_sp;
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:

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

1087: P_return_code => l_return_code);
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;

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

1111: P_return_code => l_return_code);
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;

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

1135: P_return_code => l_return_code);
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;

Line 1308: fnd_message.set_name ('JTF', 'JTF_RS_GRP_REL_OVERLAP');

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

Line 1328: fnd_message.set_name ('JTF', 'JTF_RS_CYCLIC_DEP_ERR');

1324: fetch dep_cur into dep_rec;
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;

Line 1345: fnd_message.set_name ('JTF', 'JTF_RS_CHILD_GRP_DT_ERR');

1341: FETCH check_group_dt_cur INTO check_group_dt_rec;
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;

Line 1360: fnd_message.set_name ('JTF', 'JTF_RS_RELATED_GRP_DT_ERR');

1356: FETCH check_group_dt_cur INTO check_group_dt_rec;
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;

Line 1374: fnd_message.set_name ('JTF', 'JTF_RS_CHILD_REL_DT_ERR');

1370: FETCH check_dates_cur INTO check_dates_rec;
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;

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

1392: EXCEPTION
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;

Line 1426: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');

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

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

1523: l_date,
1524: l_login_id);
1525:
1526: exception when others then
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;

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

1524: l_login_id);
1525:
1526: exception when others then
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;

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

1525:
1526: exception when others then
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);

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

1526: exception when others then
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;

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

1543: open conc_prog_cur;
1544: fetch conc_prog_cur into g_name;
1545: close conc_prog_cur;
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:

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

1544: fetch conc_prog_cur into g_name;
1545: close conc_prog_cur;
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

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

1545: close conc_prog_cur;
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:

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

1550: FND_MSG_PUB.add;
1551:
1552: exception when others then
1553:
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;

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

1551:
1552: exception when others then
1553:
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;

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

1552: exception when others then
1553:
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);

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

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

Line 1577: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DENORM_ERR');

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

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

1603: P_return_code => l_return_code);
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;

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

1626: P_return_code => l_return_code);
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;

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

1649: P_return_code => l_return_code);
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;

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

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

Line 1727: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');

1723: EXCEPTION
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

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

1735:
1736: WHEN OTHERS
1737: THEN
1738: ROLLBACK TO group_relate_sp;
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;

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

1736: WHEN OTHERS
1737: THEN
1738: ROLLBACK TO group_relate_sp;
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;

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

1737: THEN
1738: ROLLBACK TO group_relate_sp;
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);

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

1738: ROLLBACK TO group_relate_sp;
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:

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

1891: P_return_code => l_return_code);
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;

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

1914: P_return_code => l_return_code);
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;

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

1939: P_return_code => l_return_code);
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;

Line 1971: fnd_message.set_name ('JTF', 'JTF_RS_GRP_RELATE_AUDIT_ERR');

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

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

1988: EXCEPTION
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;

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

2079: l_user_id,
2080: l_date,
2081: l_login_id);
2082: exception when others then
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;

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

2080: l_date,
2081: l_login_id);
2082: exception when others then
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;

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

2081: l_login_id);
2082: exception when others then
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);

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

2082: exception when others then
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;

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

2098: open conc_prog_cur;
2099: fetch conc_prog_cur into g_name;
2100: close conc_prog_cur;
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:

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

2099: fetch conc_prog_cur into g_name;
2100: close conc_prog_cur;
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

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

2100: close conc_prog_cur;
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');

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

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);
2110: fnd_message.set_token('P_SQLERRM',SQLERRM);
2111: fnd_message.set_token('P_API_NAME', l_api_name);
2112: FND_MSG_PUB.add;

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

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

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

2106:
2107: exception when others then
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);

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

2107: exception when others then
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;

Line 2142: fnd_message.set_name ('JTF', 'JTF_RS_GRP_DENORM_ERR');

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

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

2161: P_return_code => l_return_code);
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;

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

2183: P_return_code => l_return_code);
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;

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

2205: P_return_code => l_return_code);
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;

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

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

Line 2282: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');

2278: EXCEPTION
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

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

2290:
2291: WHEN OTHERS
2292: THEN
2293: -- ROLLBACK TO group_relate_sp;
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;

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

2291: WHEN OTHERS
2292: THEN
2293: -- ROLLBACK TO group_relate_sp;
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;

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

2292: THEN
2293: -- ROLLBACK TO group_relate_sp;
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);

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

2293: -- ROLLBACK TO group_relate_sp;
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: