103: --
104: -- IF(l_return_status <> fnd_api.g_ret_sts_success)
105: -- THEN
106: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
107: -- fnd_message.set_name ('JTF', 'JTF_RS_USAGE_ERR');
108: -- FND_MSG_PUB.add;
109: -- RAISE fnd_api.g_exc_unexpected_error;
110: -- END IF;
111:
138: /*
139: IF(l_return_status <> fnd_api.g_ret_sts_success)
140: THEN
141: x_return_status := fnd_api.g_ret_sts_unexp_error;
142: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_INS_ERR');
143: FND_MSG_PUB.add;
144: RAISE fnd_api.g_exc_unexpected_error;
145: END IF;
146: */
162: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
163: p_data => x_msg_data);
164: WHEN OTHERS THEN
165: ROLLBACK TO group_dynamic_sp;
166: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
167: fnd_message.set_token('P_SQLCODE',SQLCODE);
168: fnd_message.set_token('P_SQLERRM',SQLERRM);
169: fnd_message.set_token('P_API_NAME', l_api_name);
170: FND_MSG_PUB.add;
163: p_data => x_msg_data);
164: WHEN OTHERS THEN
165: ROLLBACK TO group_dynamic_sp;
166: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
167: fnd_message.set_token('P_SQLCODE',SQLCODE);
168: fnd_message.set_token('P_SQLERRM',SQLERRM);
169: fnd_message.set_token('P_API_NAME', l_api_name);
170: FND_MSG_PUB.add;
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
164: WHEN OTHERS THEN
165: ROLLBACK TO group_dynamic_sp;
166: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
167: fnd_message.set_token('P_SQLCODE',SQLCODE);
168: fnd_message.set_token('P_SQLERRM',SQLERRM);
169: fnd_message.set_token('P_API_NAME', l_api_name);
170: FND_MSG_PUB.add;
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
165: ROLLBACK TO group_dynamic_sp;
166: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
167: fnd_message.set_token('P_SQLCODE',SQLCODE);
168: fnd_message.set_token('P_SQLERRM',SQLERRM);
169: fnd_message.set_token('P_API_NAME', l_api_name);
170: FND_MSG_PUB.add;
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
173: p_data => x_msg_data);
174: /*
175: WHEN fnd_api.g_exc_unexpected_error
176: THEN
177: ROLLBACK TO GROUP_DYNAMIC_SP;
178: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PUB_ERR');
179: FND_MSG_PUB.add;
180: x_return_status := fnd_api.g_ret_sts_unexp_error;
181: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
182: WHEN OTHERS
181: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
182: WHEN OTHERS
183: THEN
184: ROLLBACK TO GROUP_DYNAMIC_SP;
185: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PUB_ERR');
186: FND_MSG_PUB.add;
187: x_return_status := fnd_api.g_ret_sts_unexp_error;
188: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
189: */
305: /*
306: IF(l_return_status <> fnd_api.g_ret_sts_success)
307: THEN
308: x_return_status := fnd_api.g_ret_sts_unexp_error;
309: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_UPDATE_ERR');
310: FND_MSG_PUB.add;
311: RAISE fnd_api.g_exc_unexpected_error;
312: END IF;
313: */
324: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
325: p_data => x_msg_data);
326: WHEN OTHERS THEN
327: ROLLBACK TO group_dynamic_sp;
328: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
329: fnd_message.set_token('P_SQLCODE',SQLCODE);
330: fnd_message.set_token('P_SQLERRM',SQLERRM);
331: fnd_message.set_token('P_API_NAME', l_api_name);
332: FND_MSG_PUB.add;
325: p_data => x_msg_data);
326: WHEN OTHERS THEN
327: ROLLBACK TO group_dynamic_sp;
328: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
329: fnd_message.set_token('P_SQLCODE',SQLCODE);
330: fnd_message.set_token('P_SQLERRM',SQLERRM);
331: fnd_message.set_token('P_API_NAME', l_api_name);
332: FND_MSG_PUB.add;
333: x_return_status := fnd_api.g_ret_sts_unexp_error;
326: WHEN OTHERS THEN
327: ROLLBACK TO group_dynamic_sp;
328: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
329: fnd_message.set_token('P_SQLCODE',SQLCODE);
330: fnd_message.set_token('P_SQLERRM',SQLERRM);
331: fnd_message.set_token('P_API_NAME', l_api_name);
332: FND_MSG_PUB.add;
333: x_return_status := fnd_api.g_ret_sts_unexp_error;
334: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
327: ROLLBACK TO group_dynamic_sp;
328: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
329: fnd_message.set_token('P_SQLCODE',SQLCODE);
330: fnd_message.set_token('P_SQLERRM',SQLERRM);
331: fnd_message.set_token('P_API_NAME', l_api_name);
332: FND_MSG_PUB.add;
333: x_return_status := fnd_api.g_ret_sts_unexp_error;
334: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
335: p_data => x_msg_data);
336: /*
337: WHEN fnd_api.g_exc_unexpected_error
338: THEN
339: ROLLBACK TO GROUP_DYNAMIC_SP;
340: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PUB_ERR');
341: FND_MSG_PUB.add;
342: x_return_status := fnd_api.g_ret_sts_unexp_error;
343: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
344: WHEN OTHERS
343: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
344: WHEN OTHERS
345: THEN
346: ROLLBACK TO GROUP_DYNAMIC_SP;
347: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PUB_ERR');
348: FND_MSG_PUB.add;
349: x_return_status := fnd_api.g_ret_sts_unexp_error;
350: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
351: */
432: /*
433: IF(l_return_status <> fnd_api.g_ret_sts_success)
434: THEN
435: x_return_status := fnd_api.g_ret_sts_unexp_error;
436: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_DELETE_ERR');
437: FND_MSG_PUB.add;
438: RAISE fnd_api.g_exc_unexpected_error;
439: END IF;
440: */
451: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
452: p_data => x_msg_data);
453: WHEN OTHERS THEN
454: ROLLBACK TO group_dynamic_sp;
455: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
456: fnd_message.set_token('P_SQLCODE',SQLCODE);
457: fnd_message.set_token('P_SQLERRM',SQLERRM);
458: fnd_message.set_token('P_API_NAME', l_api_name);
459: FND_MSG_PUB.add;
452: p_data => x_msg_data);
453: WHEN OTHERS THEN
454: ROLLBACK TO group_dynamic_sp;
455: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
456: fnd_message.set_token('P_SQLCODE',SQLCODE);
457: fnd_message.set_token('P_SQLERRM',SQLERRM);
458: fnd_message.set_token('P_API_NAME', l_api_name);
459: FND_MSG_PUB.add;
460: x_return_status := fnd_api.g_ret_sts_unexp_error;
453: WHEN OTHERS THEN
454: ROLLBACK TO group_dynamic_sp;
455: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
456: fnd_message.set_token('P_SQLCODE',SQLCODE);
457: fnd_message.set_token('P_SQLERRM',SQLERRM);
458: fnd_message.set_token('P_API_NAME', l_api_name);
459: FND_MSG_PUB.add;
460: x_return_status := fnd_api.g_ret_sts_unexp_error;
461: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
454: ROLLBACK TO group_dynamic_sp;
455: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
456: fnd_message.set_token('P_SQLCODE',SQLCODE);
457: fnd_message.set_token('P_SQLERRM',SQLERRM);
458: fnd_message.set_token('P_API_NAME', l_api_name);
459: FND_MSG_PUB.add;
460: x_return_status := fnd_api.g_ret_sts_unexp_error;
461: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
462: p_data => x_msg_data);
463: /*
464: WHEN fnd_api.g_exc_unexpected_error
465: THEN
466: ROLLBACK TO GROUP_DYNAMIC_SP;
467: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PUB_ERR');
468: FND_MSG_PUB.add;
469: x_return_status := fnd_api.g_ret_sts_unexp_error;
470: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
471: WHEN OTHERS
470: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
471: WHEN OTHERS
472: THEN
473: ROLLBACK TO GROUP_DYNAMIC_SP;
474: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PUB_ERR');
475: FND_MSG_PUB.add;
476: x_return_status := fnd_api.g_ret_sts_unexp_error;
477: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
478: */