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_MSG_PUB

Line 108: FND_MSG_PUB.Initialize;

104:
105: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
106: IF FND_API.To_boolean(P_INIT_MSG_LIST)
107: THEN
108: FND_MSG_PUB.Initialize;
109: END IF;
110:
111: --GET USER ID AND SYSDATE
112: l_date := sysdate;

Line 133: fnd_msg_pub.add;

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;
137: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 146: FND_MSG_PUB.add;

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: */
150: end if;

Line 172: fnd_msg_pub.add;

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;
176: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 185: FND_MSG_PUB.add;

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: */
189: end if;

Line 211: fnd_msg_pub.add;

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;
215: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 224: FND_MSG_PUB.add;

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: */
228: end if;

Line 255: FND_MSG_PUB.add;

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: */
259: --call usage validation

Line 276: FND_MSG_PUB.add;

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: */
280: IF l_sql_text is NOT NULL

Line 291: FND_MSG_PUB.add;

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;
295: else

Line 298: FND_MSG_PUB.add;

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

Line 364: fnd_msg_pub.add;

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;
368: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 377: FND_MSG_PUB.add;

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: */
381: end if;

Line 404: fnd_msg_pub.add;

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;
408: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 417: FND_MSG_PUB.add;

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: */
421: end if;

Line 444: fnd_msg_pub.add;

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;
448: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 457: FND_MSG_PUB.add;

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: */
461: end if;

Line 506: fnd_msg_pub.add;

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;
510: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 519: fnd_msg_pub.add;

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

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

535: COMMIT WORK;
536: END IF;
537:
538:
539: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
540:
541: EXCEPTION
542:
543: WHEN fnd_api.g_exc_error THEN

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

542:
543: WHEN fnd_api.g_exc_error THEN
544: ROLLBACK TO group_dynamic_sp;
545: x_return_status := fnd_api.g_ret_sts_error;
546: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
547: p_data => x_msg_data);
548: WHEN fnd_api.g_exc_unexpected_error THEN
549: ROLLBACK TO group_dynamic_sp;
550: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

547: p_data => x_msg_data);
548: WHEN fnd_api.g_exc_unexpected_error THEN
549: ROLLBACK TO group_dynamic_sp;
550: x_return_status := fnd_api.g_ret_sts_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');

Line 559: FND_MSG_PUB.add;

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);
563: /*

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

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);
563: /*
564: WHEN fnd_api.g_exc_unexpected_error
565: THEN

Line 568: FND_MSG_PUB.add;

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
572: THEN

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

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
572: THEN
573: ROLLBACK TO GROUP_DYNAMIC_SP;
574: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');

Line 575: FND_MSG_PUB.add;

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: */
579:

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

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: */
579:
580: END create_dynamic_groups;
581:

Line 722: FND_MSG_PUB.Initialize;

718:
719: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
720: IF FND_API.To_boolean(P_INIT_MSG_LIST)
721: THEN
722: FND_MSG_PUB.Initialize;
723: END IF;
724:
725: --GET USER ID AND SYSDATE
726: l_date := sysdate;

Line 750: fnd_msg_pub.add;

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;
754: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 763: FND_MSG_PUB.add;

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: */
767: end if;

Line 792: fnd_msg_pub.add;

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;
796: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 805: FND_MSG_PUB.add;

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: */
809: end if;

Line 834: fnd_msg_pub.add;

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;
838: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 847: FND_MSG_PUB.add;

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: */
851: end if;

Line 1032: FND_MSG_PUB.add;

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: */
1036: --call usage validation

Line 1052: FND_MSG_PUB.add;

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: */
1056:

Line 1069: FND_MSG_PUB.add;

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;
1073: else

Line 1076: FND_MSG_PUB.add;

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

Line 1096: fnd_msg_pub.add;

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:
1100: END;

Line 1158: fnd_msg_pub.add;

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;
1162: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 1171: FND_MSG_PUB.add;

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: */
1175: end if;

Line 1200: fnd_msg_pub.add;

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;
1204: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 1213: FND_MSG_PUB.add;

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: */
1217: end if;

Line 1242: fnd_msg_pub.add;

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;
1246: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 1255: FND_MSG_PUB.add;

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: */
1259: end if;

Line 1305: fnd_msg_pub.add;

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;
1309: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1318: fnd_msg_pub.add;

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

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

1334: COMMIT WORK;
1335: END IF;
1336:
1337:
1338: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1339:
1340: EXCEPTION
1341:
1342: WHEN fnd_api.g_exc_error THEN

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

1341:
1342: WHEN fnd_api.g_exc_error THEN
1343: ROLLBACK TO group_dynamic_sp;
1344: x_return_status := fnd_api.g_ret_sts_error;
1345: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1346: p_data => x_msg_data);
1347: WHEN fnd_api.g_exc_unexpected_error THEN
1348: ROLLBACK TO group_dynamic_sp;
1349: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1346: p_data => x_msg_data);
1347: WHEN fnd_api.g_exc_unexpected_error THEN
1348: ROLLBACK TO group_dynamic_sp;
1349: x_return_status := fnd_api.g_ret_sts_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');

Line 1358: FND_MSG_PUB.add;

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);
1362: /*

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

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);
1362: /*
1363: WHEN fnd_api.g_exc_unexpected_error
1364: THEN

Line 1367: FND_MSG_PUB.add;

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
1371: THEN

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

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
1371: THEN
1372: ROLLBACK TO GROUP_DYNAMIC_SP;
1373: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');

Line 1374: FND_MSG_PUB.add;

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: */
1378:

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

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: */
1378:
1379: END;
1380:

Line 1427: FND_MSG_PUB.Initialize;

1423:
1424: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1425: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1426: THEN
1427: FND_MSG_PUB.Initialize;
1428: END IF;
1429:
1430: --GET USER ID AND SYSDATE
1431: l_date := sysdate;

Line 1448: fnd_msg_pub.add;

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;
1452: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 1461: FND_MSG_PUB.add;

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: */
1465: end if;

Line 1483: fnd_msg_pub.add;

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;
1487: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 1496: FND_MSG_PUB.add;

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: */
1500: end if;

Line 1518: fnd_msg_pub.add;

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;
1522: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 1531: FND_MSG_PUB.add;

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: */
1535: end if;

Line 1555: fnd_msg_pub.add;

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:
1559: END;

Line 1579: fnd_msg_pub.add;

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;
1583: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 1592: FND_MSG_PUB.add;

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: */
1596: end if;

Line 1614: fnd_msg_pub.add;

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;
1618: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 1627: FND_MSG_PUB.add;

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: */
1631: end if;

Line 1649: fnd_msg_pub.add;

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;
1653: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

Line 1662: FND_MSG_PUB.add;

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: */
1666: end if;

Line 1714: fnd_msg_pub.add;

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;
1718: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1727: fnd_msg_pub.add;

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

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

1742: COMMIT WORK;
1743: END IF;
1744:
1745:
1746: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1747:
1748: EXCEPTION
1749:
1750: WHEN fnd_api.g_exc_error THEN

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

1749:
1750: WHEN fnd_api.g_exc_error THEN
1751: ROLLBACK TO group_dynamic_sp;
1752: x_return_status := fnd_api.g_ret_sts_error;
1753: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1754: p_data => x_msg_data);
1755: WHEN fnd_api.g_exc_unexpected_error THEN
1756: ROLLBACK TO group_dynamic_sp;
1757: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1754: p_data => x_msg_data);
1755: WHEN fnd_api.g_exc_unexpected_error THEN
1756: ROLLBACK TO group_dynamic_sp;
1757: x_return_status := fnd_api.g_ret_sts_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');

Line 1766: FND_MSG_PUB.add;

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);
1770: /*

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

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);
1770: /*
1771: WHEN fnd_api.g_exc_unexpected_error
1772: THEN

Line 1775: FND_MSG_PUB.add;

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
1779: THEN

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

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
1779: THEN
1780: ROLLBACK TO GROUP_DYNAMIC_SP;
1781: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');

Line 1782: FND_MSG_PUB.add;

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: */
1786: END;

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

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: */
1786: END;
1787: END jtf_rs_dynamic_groups_pvt;