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

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

128: p_data => L_data,
129: p_count => L_count,
130: P_return_code => l_return_code);
131: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
132: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
133: fnd_msg_pub.add;
134:
135: IF l_return_code = fnd_api.g_ret_sts_error THEN
136: raise fnd_api.g_exc_error;

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

141: /*
142: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
143: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
145: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
146: FND_MSG_PUB.add;
147: RAISE fnd_api.g_exc_unexpected_error;
148: end if;
149: */

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

167: p_data => L_data,
168: p_count => L_count,
169: P_return_code => l_return_code);
170: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
171: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
172: fnd_msg_pub.add;
173:
174: IF l_return_code = fnd_api.g_ret_sts_error THEN
175: raise fnd_api.g_exc_error;

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

180: /*
181: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
182: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
183: x_return_status := fnd_api.g_ret_sts_unexp_error;
184: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
185: FND_MSG_PUB.add;
186: RAISE fnd_api.g_exc_unexpected_error;
187: end if;
188: */

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

206: p_data => L_data,
207: p_count => L_count,
208: P_return_code => l_return_code);
209: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
210: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
211: fnd_msg_pub.add;
212:
213: IF l_return_code = fnd_api.g_ret_sts_error THEN
214: raise fnd_api.g_exc_error;

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

219: /*
220: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
221: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
224: FND_MSG_PUB.add;
225: RAISE fnd_api.g_exc_unexpected_error;
226: end if;
227: */

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

250: /*
251: IF(l_return_status <> fnd_api.g_ret_sts_success)
252: THEN
253: x_return_status := fnd_api.g_ret_sts_unexp_error;
254: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
255: FND_MSG_PUB.add;
256: RAISE fnd_api.g_exc_unexpected_error;
257: END IF;
258: */

Line 275: fnd_message.set_name ('JTF', 'JTF_RS_USAGE_ERR');

271: /*
272: IF(l_return_status <> fnd_api.g_ret_sts_success)
273: THEN
274: x_return_status := fnd_api.g_ret_sts_unexp_error;
275: fnd_message.set_name ('JTF', 'JTF_RS_USAGE_ERR');
276: FND_MSG_PUB.add;
277: RAISE fnd_api.g_exc_unexpected_error;
278: END IF;
279: */

Line 290: fnd_message.set_name ('JTF', 'JTF_RS_SQL_TEXT_ERR');

286: DBMS_SQL.PARSE(l_cursorid, l_sql_text, DBMS_SQL.V7);
287: EXCEPTION
288: WHEN OTHERS THEN
289: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
290: fnd_message.set_name ('JTF', 'JTF_RS_SQL_TEXT_ERR');
291: FND_MSG_PUB.add;
292: -- RAISE fnd_api.g_exc_unexpected_error;
293: RAISE fnd_api.g_exc_error;
294: END;

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

293: RAISE fnd_api.g_exc_error;
294: END;
295: else
296: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
297: fnd_message.set_name ('JTF', 'JTF_RS_SQL_NOT_A_SELECT');
298: FND_MSG_PUB.add;
299: -- RAISE fnd_api.g_exc_unexpected_error;
300: RAISE fnd_api.g_exc_error;
301: end if;

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

359: p_data => L_data,
360: p_count => L_count,
361: P_return_code => l_return_code);
362: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
363: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
364: fnd_msg_pub.add;
365:
366: IF l_return_code = fnd_api.g_ret_sts_error THEN
367: raise fnd_api.g_exc_error;

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

372: /*
373: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
374: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
375: x_return_status := fnd_api.g_ret_sts_unexp_error;
376: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
377: FND_MSG_PUB.add;
378: RAISE fnd_api.g_exc_unexpected_error;
379: end if;
380: */

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

399: p_data => L_data,
400: p_count => L_count,
401: P_return_code => l_return_code);
402: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
403: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
404: fnd_msg_pub.add;
405:
406: IF l_return_code = fnd_api.g_ret_sts_error THEN
407: raise fnd_api.g_exc_error;

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

412: /*
413: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
414: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
415: x_return_status := fnd_api.g_ret_sts_unexp_error;
416: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
417: FND_MSG_PUB.add;
418: RAISE fnd_api.g_exc_unexpected_error;
419: end if;
420: */

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

439: p_data => L_data,
440: p_count => L_count,
441: P_return_code => l_return_code);
442: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
443: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
444: fnd_msg_pub.add;
445:
446: IF l_return_code = fnd_api.g_ret_sts_error THEN
447: raise fnd_api.g_exc_error;

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

452: /*
453: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
454: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
455: x_return_status := fnd_api.g_ret_sts_unexp_error;
456: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
457: FND_MSG_PUB.add;
458: RAISE fnd_api.g_exc_unexpected_error;
459: end if;
460: */

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

501: p_bind_data_id => l_bind_data_id,
502: x_return_code => x_return_status);
503:
504: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
505: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
506: fnd_msg_pub.add;
507:
508: IF x_return_status = fnd_api.g_ret_sts_error THEN
509: raise fnd_api.g_exc_error;

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

514: /*
515: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
516: x_return_status := fnd_api.g_ret_sts_unexp_error;
517:
518: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
519: fnd_msg_pub.add;
520:
521: RAISE fnd_api.g_exc_unexpected_error;
522:

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

551: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
552: p_data => x_msg_data);
553: WHEN OTHERS THEN
554: ROLLBACK TO group_dynamic_sp;
555: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
556: fnd_message.set_token('P_SQLCODE',SQLCODE);
557: fnd_message.set_token('P_SQLERRM',SQLERRM);
558: fnd_message.set_token('P_API_NAME', l_api_name);
559: FND_MSG_PUB.add;

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

552: p_data => x_msg_data);
553: WHEN OTHERS THEN
554: ROLLBACK TO group_dynamic_sp;
555: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
556: fnd_message.set_token('P_SQLCODE',SQLCODE);
557: fnd_message.set_token('P_SQLERRM',SQLERRM);
558: fnd_message.set_token('P_API_NAME', l_api_name);
559: FND_MSG_PUB.add;
560: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

553: WHEN OTHERS THEN
554: ROLLBACK TO group_dynamic_sp;
555: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
556: fnd_message.set_token('P_SQLCODE',SQLCODE);
557: fnd_message.set_token('P_SQLERRM',SQLERRM);
558: fnd_message.set_token('P_API_NAME', l_api_name);
559: FND_MSG_PUB.add;
560: x_return_status := fnd_api.g_ret_sts_unexp_error;
561: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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

554: ROLLBACK TO group_dynamic_sp;
555: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
556: fnd_message.set_token('P_SQLCODE',SQLCODE);
557: fnd_message.set_token('P_SQLERRM',SQLERRM);
558: fnd_message.set_token('P_API_NAME', l_api_name);
559: FND_MSG_PUB.add;
560: x_return_status := fnd_api.g_ret_sts_unexp_error;
561: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
562: p_data => x_msg_data);

Line 567: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');

563: /*
564: WHEN fnd_api.g_exc_unexpected_error
565: THEN
566: ROLLBACK TO GROUP_DYNAMIC_SP;
567: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');
568: FND_MSG_PUB.add;
569: x_return_status := fnd_api.g_ret_sts_unexp_error;
570: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
571: WHEN OTHERS

Line 574: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');

570: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
571: WHEN OTHERS
572: THEN
573: ROLLBACK TO GROUP_DYNAMIC_SP;
574: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');
575: FND_MSG_PUB.add;
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
578: */

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

745: p_data => L_data,
746: p_count => L_count,
747: P_return_code => l_return_code);
748: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
749: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
750: fnd_msg_pub.add;
751:
752: IF l_return_code = fnd_api.g_ret_sts_error THEN
753: raise fnd_api.g_exc_error;

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

758: /*
759: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
760: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
761: x_return_status := fnd_api.g_ret_sts_unexp_error;
762: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
763: FND_MSG_PUB.add;
764: RAISE fnd_api.g_exc_unexpected_error;
765: end if;
766: */

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

787: p_data => L_data,
788: p_count => L_count,
789: P_return_code => l_return_code);
790: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
791: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
792: fnd_msg_pub.add;
793:
794: IF l_return_code = fnd_api.g_ret_sts_error THEN
795: raise fnd_api.g_exc_error;

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

800: /*
801: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
802: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
803: x_return_status := fnd_api.g_ret_sts_unexp_error;
804: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
805: FND_MSG_PUB.add;
806: RAISE fnd_api.g_exc_unexpected_error;
807: end if;
808: */

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

829: p_data => L_data,
830: p_count => L_count,
831: P_return_code => l_return_code);
832: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
833: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
834: fnd_msg_pub.add;
835:
836: IF l_return_code = fnd_api.g_ret_sts_error THEN
837: raise fnd_api.g_exc_error;

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

842: /*
843: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
844: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
845: x_return_status := fnd_api.g_ret_sts_unexp_error;
846: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
847: FND_MSG_PUB.add;
848: RAISE fnd_api.g_exc_unexpected_error;
849: end if;
850: */

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

1027: /*
1028: IF(l_return_status <> fnd_api.g_ret_sts_success)
1029: THEN
1030: x_return_status := fnd_api.g_ret_sts_unexp_error;
1031: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
1032: FND_MSG_PUB.add;
1033: RAISE fnd_api.g_exc_unexpected_error;
1034: END IF;
1035: */

Line 1051: fnd_message.set_name ('JTF', 'JTF_RS_USAGE_ERR');

1047: /*
1048: IF(l_return_status <> fnd_api.g_ret_sts_success)
1049: THEN
1050: x_return_status := fnd_api.g_ret_sts_unexp_error;
1051: fnd_message.set_name ('JTF', 'JTF_RS_USAGE_ERR');
1052: FND_MSG_PUB.add;
1053: RAISE fnd_api.g_exc_unexpected_error;
1054: END IF;
1055: */

Line 1068: fnd_message.set_name ('JTF', 'JTF_RS_SQL_TEXT_ERR');

1064:
1065: EXCEPTION
1066: WHEN OTHERS THEN
1067: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1068: fnd_message.set_name ('JTF', 'JTF_RS_SQL_TEXT_ERR');
1069: FND_MSG_PUB.add;
1070: -- RAISE fnd_api.g_exc_unexpected_error;
1071: RAISE fnd_api.g_exc_error;
1072: END;

Line 1075: fnd_message.set_name ('JTF', 'JTF_RS_SQL_NOT_A_SELECT');

1071: RAISE fnd_api.g_exc_error;
1072: END;
1073: else
1074: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1075: fnd_message.set_name ('JTF', 'JTF_RS_SQL_NOT_A_SELECT');
1076: FND_MSG_PUB.add;
1077: -- RAISE fnd_api.g_exc_unexpected_error;
1078: RAISE fnd_api.g_exc_error;
1079: end if;

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

1091: EXCEPTION
1092:
1093: WHEN OTHERS THEN
1094: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1095: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1096: fnd_msg_pub.add;
1097: -- RAISE fnd_api.g_exc_unexpected_error;
1098: RAISE fnd_api.g_exc_error;
1099:

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

1153: p_data => L_data,
1154: p_count => L_count,
1155: P_return_code => l_return_code);
1156: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1157: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1158: fnd_msg_pub.add;
1159:
1160: IF l_return_code = fnd_api.g_ret_sts_error THEN
1161: raise fnd_api.g_exc_error;

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

1166: /*
1167: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1168: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1169: x_return_status := fnd_api.g_ret_sts_unexp_error;
1170: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1171: FND_MSG_PUB.add;
1172: RAISE fnd_api.g_exc_unexpected_error;
1173: end if;
1174: */

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

1195: p_data => L_data,
1196: p_count => L_count,
1197: P_return_code => l_return_code);
1198: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1199: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1200: fnd_msg_pub.add;
1201:
1202: IF l_return_code = fnd_api.g_ret_sts_error THEN
1203: raise fnd_api.g_exc_error;

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

1208: /*
1209: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1210: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1211: x_return_status := fnd_api.g_ret_sts_unexp_error;
1212: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1213: FND_MSG_PUB.add;
1214: RAISE fnd_api.g_exc_unexpected_error;
1215: end if;
1216: */

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

1237: p_data => L_data,
1238: p_count => L_count,
1239: P_return_code => l_return_code);
1240: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1241: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1242: fnd_msg_pub.add;
1243:
1244: IF l_return_code = fnd_api.g_ret_sts_error THEN
1245: raise fnd_api.g_exc_error;

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

1250: /*
1251: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1252: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1253: x_return_status := fnd_api.g_ret_sts_unexp_error;
1254: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1255: FND_MSG_PUB.add;
1256: RAISE fnd_api.g_exc_unexpected_error;
1257: end if;
1258: */

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

1300: p_bind_data_id => l_bind_data_id,
1301: x_return_code => x_return_status);
1302:
1303: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1304: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1305: fnd_msg_pub.add;
1306:
1307: IF x_return_status = fnd_api.g_ret_sts_error THEN
1308: raise fnd_api.g_exc_error;

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

1313: /*
1314: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1315: x_return_status := fnd_api.g_ret_sts_unexp_error;
1316:
1317: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1318: fnd_msg_pub.add;
1319:
1320: RAISE fnd_api.g_exc_unexpected_error;
1321:

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

1350: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1351: p_data => x_msg_data);
1352: WHEN OTHERS THEN
1353: ROLLBACK TO group_dynamic_sp;
1354: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1355: fnd_message.set_token('P_SQLCODE',SQLCODE);
1356: fnd_message.set_token('P_SQLERRM',SQLERRM);
1357: fnd_message.set_token('P_API_NAME', l_api_name);
1358: FND_MSG_PUB.add;

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

1351: p_data => x_msg_data);
1352: WHEN OTHERS THEN
1353: ROLLBACK TO group_dynamic_sp;
1354: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1355: fnd_message.set_token('P_SQLCODE',SQLCODE);
1356: fnd_message.set_token('P_SQLERRM',SQLERRM);
1357: fnd_message.set_token('P_API_NAME', l_api_name);
1358: FND_MSG_PUB.add;
1359: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1352: WHEN OTHERS THEN
1353: ROLLBACK TO group_dynamic_sp;
1354: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1355: fnd_message.set_token('P_SQLCODE',SQLCODE);
1356: fnd_message.set_token('P_SQLERRM',SQLERRM);
1357: fnd_message.set_token('P_API_NAME', l_api_name);
1358: FND_MSG_PUB.add;
1359: x_return_status := fnd_api.g_ret_sts_unexp_error;
1360: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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

1353: ROLLBACK TO group_dynamic_sp;
1354: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1355: fnd_message.set_token('P_SQLCODE',SQLCODE);
1356: fnd_message.set_token('P_SQLERRM',SQLERRM);
1357: fnd_message.set_token('P_API_NAME', l_api_name);
1358: FND_MSG_PUB.add;
1359: x_return_status := fnd_api.g_ret_sts_unexp_error;
1360: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1361: p_data => x_msg_data);

Line 1366: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');

1362: /*
1363: WHEN fnd_api.g_exc_unexpected_error
1364: THEN
1365: ROLLBACK TO GROUP_DYNAMIC_SP;
1366: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');
1367: FND_MSG_PUB.add;
1368: x_return_status := fnd_api.g_ret_sts_unexp_error;
1369: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1370: WHEN OTHERS

Line 1373: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');

1369: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1370: WHEN OTHERS
1371: THEN
1372: ROLLBACK TO GROUP_DYNAMIC_SP;
1373: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');
1374: FND_MSG_PUB.add;
1375: x_return_status := fnd_api.g_ret_sts_unexp_error;
1376: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1377: */

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

1443: p_data => L_data,
1444: p_count => L_count,
1445: P_return_code => l_return_code);
1446: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1447: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1448: fnd_msg_pub.add;
1449:
1450: IF l_return_code = fnd_api.g_ret_sts_error THEN
1451: raise fnd_api.g_exc_error;

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

1456: /*
1457: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1458: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1459: x_return_status := fnd_api.g_ret_sts_unexp_error;
1460: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1461: FND_MSG_PUB.add;
1462: RAISE fnd_api.g_exc_unexpected_error;
1463: end if;
1464: */

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

1478: p_data => L_data,
1479: p_count => L_count,
1480: P_return_code => l_return_code);
1481: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1482: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1483: fnd_msg_pub.add;
1484:
1485: IF l_return_code = fnd_api.g_ret_sts_error THEN
1486: raise fnd_api.g_exc_error;

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

1491: /*
1492: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1493: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1494: x_return_status := fnd_api.g_ret_sts_unexp_error;
1495: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1496: FND_MSG_PUB.add;
1497: RAISE fnd_api.g_exc_unexpected_error;
1498: end if;
1499: */

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

1513: p_data => L_data,
1514: p_count => L_count,
1515: P_return_code => l_return_code);
1516: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1517: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1518: fnd_msg_pub.add;
1519:
1520: IF l_return_code = fnd_api.g_ret_sts_error THEN
1521: raise fnd_api.g_exc_error;

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

1526: /*
1527: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1528: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1529: x_return_status := fnd_api.g_ret_sts_unexp_error;
1530: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1531: FND_MSG_PUB.add;
1532: RAISE fnd_api.g_exc_unexpected_error;
1533: end if;
1534: */

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

1550: EXCEPTION
1551:
1552: WHEN OTHERS THEN
1553: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1554: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1555: fnd_msg_pub.add;
1556: -- RAISE fnd_api.g_exc_unexpected_error;
1557: RAISE fnd_api.g_exc_error;
1558:

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

1574: p_data => L_data,
1575: p_count => L_count,
1576: P_return_code => l_return_code);
1577: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1578: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1579: fnd_msg_pub.add;
1580:
1581: IF l_return_code = fnd_api.g_ret_sts_error THEN
1582: raise fnd_api.g_exc_error;

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

1587: /*
1588: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1589: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1592: FND_MSG_PUB.add;
1593: RAISE fnd_api.g_exc_unexpected_error;
1594: end if;
1595: */

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

1609: p_data => L_data,
1610: p_count => L_count,
1611: P_return_code => l_return_code);
1612: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1613: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1614: fnd_msg_pub.add;
1615:
1616: IF l_return_code = fnd_api.g_ret_sts_error THEN
1617: raise fnd_api.g_exc_error;

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

1622: /*
1623: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1624: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1625: x_return_status := fnd_api.g_ret_sts_unexp_error;
1626: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1627: FND_MSG_PUB.add;
1628: RAISE fnd_api.g_exc_unexpected_error;
1629: end if;
1630: */

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

1644: p_data => L_data,
1645: p_count => L_count,
1646: P_return_code => l_return_code);
1647: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1648: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1649: fnd_msg_pub.add;
1650:
1651: IF l_return_code = fnd_api.g_ret_sts_error THEN
1652: raise fnd_api.g_exc_error;

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

1657: /*
1658: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1659: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1660: x_return_status := fnd_api.g_ret_sts_unexp_error;
1661: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1662: FND_MSG_PUB.add;
1663: RAISE fnd_api.g_exc_unexpected_error;
1664: end if;
1665: */

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

1709: x_return_code => x_return_status);
1710:
1711:
1712: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1713: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1714: fnd_msg_pub.add;
1715:
1716: IF x_return_status = fnd_api.g_ret_sts_error THEN
1717: raise fnd_api.g_exc_error;

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

1722: /*
1723: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1724: x_return_status := fnd_api.g_ret_sts_unexp_error;
1725:
1726: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1727: fnd_msg_pub.add;
1728:
1729: RAISE fnd_api.g_exc_unexpected_error;
1730:

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

1758: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1759: p_data => x_msg_data);
1760: WHEN OTHERS THEN
1761: ROLLBACK TO group_dynamic_sp;
1762: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1763: fnd_message.set_token('P_SQLCODE',SQLCODE);
1764: fnd_message.set_token('P_SQLERRM',SQLERRM);
1765: fnd_message.set_token('P_API_NAME', l_api_name);
1766: FND_MSG_PUB.add;

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

1759: p_data => x_msg_data);
1760: WHEN OTHERS THEN
1761: ROLLBACK TO group_dynamic_sp;
1762: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1763: fnd_message.set_token('P_SQLCODE',SQLCODE);
1764: fnd_message.set_token('P_SQLERRM',SQLERRM);
1765: fnd_message.set_token('P_API_NAME', l_api_name);
1766: FND_MSG_PUB.add;
1767: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1760: WHEN OTHERS THEN
1761: ROLLBACK TO group_dynamic_sp;
1762: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1763: fnd_message.set_token('P_SQLCODE',SQLCODE);
1764: fnd_message.set_token('P_SQLERRM',SQLERRM);
1765: fnd_message.set_token('P_API_NAME', l_api_name);
1766: FND_MSG_PUB.add;
1767: x_return_status := fnd_api.g_ret_sts_unexp_error;
1768: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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

1761: ROLLBACK TO group_dynamic_sp;
1762: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1763: fnd_message.set_token('P_SQLCODE',SQLCODE);
1764: fnd_message.set_token('P_SQLERRM',SQLERRM);
1765: fnd_message.set_token('P_API_NAME', l_api_name);
1766: FND_MSG_PUB.add;
1767: x_return_status := fnd_api.g_ret_sts_unexp_error;
1768: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1769: p_data => x_msg_data);

Line 1774: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');

1770: /*
1771: WHEN fnd_api.g_exc_unexpected_error
1772: THEN
1773: ROLLBACK TO GROUP_DYNAMIC_SP;
1774: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');
1775: FND_MSG_PUB.add;
1776: x_return_status := fnd_api.g_ret_sts_unexp_error;
1777: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1778: WHEN OTHERS

Line 1781: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');

1777: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1778: WHEN OTHERS
1779: THEN
1780: ROLLBACK TO GROUP_DYNAMIC_SP;
1781: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');
1782: FND_MSG_PUB.add;
1783: x_return_status := fnd_api.g_ret_sts_unexp_error;
1784: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1785: */