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

Line 203: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_IS_NULL');

199: -- if no group id is passed in then raise error
200: IF p_group_id IS NULL
201: THEN
202: x_return_status := fnd_api.g_ret_sts_error;
203: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_IS_NULL');
204: FND_MSG_PUB.add;
205: RAISE fnd_api.g_exc_error;
206: RETURN;
207: END IF;

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

282: EXCEPTION
283: WHEN fnd_api.g_exc_unexpected_error
284: THEN
285: ROLLBACK TO group_denormalize;
286: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
287: --FND_MSG_PUB.add;
288: --x_return_status := fnd_api.g_ret_sts_unexp_error;
289: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
290: WHEN fnd_api.g_exc_error

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

294:
295: WHEN OTHERS
296: THEN
297: ROLLBACK TO group_denormalize;
298: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
299: fnd_message.set_token('P_SQLCODE',SQLCODE);
300: fnd_message.set_token('P_SQLERRM',SQLERRM);
301: fnd_message.set_token('P_API_NAME',l_api_name);
302: FND_MSG_PUB.add;

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

295: WHEN OTHERS
296: THEN
297: ROLLBACK TO group_denormalize;
298: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
299: fnd_message.set_token('P_SQLCODE',SQLCODE);
300: fnd_message.set_token('P_SQLERRM',SQLERRM);
301: fnd_message.set_token('P_API_NAME',l_api_name);
302: FND_MSG_PUB.add;
303: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

296: THEN
297: ROLLBACK TO group_denormalize;
298: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
299: fnd_message.set_token('P_SQLCODE',SQLCODE);
300: fnd_message.set_token('P_SQLERRM',SQLERRM);
301: fnd_message.set_token('P_API_NAME',l_api_name);
302: FND_MSG_PUB.add;
303: x_return_status := fnd_api.g_ret_sts_unexp_error;
304: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

297: ROLLBACK TO group_denormalize;
298: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
299: fnd_message.set_token('P_SQLCODE',SQLCODE);
300: fnd_message.set_token('P_SQLERRM',SQLERRM);
301: fnd_message.set_token('P_API_NAME',l_api_name);
302: FND_MSG_PUB.add;
303: x_return_status := fnd_api.g_ret_sts_unexp_error;
304: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
305: END CREATE_RES_GROUPS;

Line 371: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_IS_NULL');

367: -- if no group id is passed in then raise error
368: IF p_group_id IS NULL
369: THEN
370: x_return_status := fnd_api.g_ret_sts_error;
371: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_IS_NULL');
372: FND_MSG_PUB.add;
373: RAISE fnd_api.g_exc_error;
374: RETURN;
375: END IF;

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

411: EXCEPTION
412: WHEN fnd_api.g_exc_unexpected_error
413: THEN
414: ROLLBACK TO group_denormalize;
415: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
416: --FND_MSG_PUB.add;
417: --x_return_status := fnd_api.g_ret_sts_unexp_error;
418: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
419: WHEN fnd_api.g_exc_error

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

423:
424: WHEN OTHERS
425: THEN
426: ROLLBACK TO group_denormalize;
427: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
428: fnd_message.set_token('P_SQLCODE',SQLCODE);
429: fnd_message.set_token('P_SQLERRM',SQLERRM);
430: fnd_message.set_token('P_API_NAME',l_api_name);
431: FND_MSG_PUB.add;

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

424: WHEN OTHERS
425: THEN
426: ROLLBACK TO group_denormalize;
427: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
428: fnd_message.set_token('P_SQLCODE',SQLCODE);
429: fnd_message.set_token('P_SQLERRM',SQLERRM);
430: fnd_message.set_token('P_API_NAME',l_api_name);
431: FND_MSG_PUB.add;
432: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

425: THEN
426: ROLLBACK TO group_denormalize;
427: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
428: fnd_message.set_token('P_SQLCODE',SQLCODE);
429: fnd_message.set_token('P_SQLERRM',SQLERRM);
430: fnd_message.set_token('P_API_NAME',l_api_name);
431: FND_MSG_PUB.add;
432: x_return_status := fnd_api.g_ret_sts_unexp_error;
433: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

426: ROLLBACK TO group_denormalize;
427: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
428: fnd_message.set_token('P_SQLCODE',SQLCODE);
429: fnd_message.set_token('P_SQLERRM',SQLERRM);
430: fnd_message.set_token('P_API_NAME',l_api_name);
431: FND_MSG_PUB.add;
432: x_return_status := fnd_api.g_ret_sts_unexp_error;
433: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
434: END UPDATE_RES_GROUPS;

Line 727: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_IS_NULL');

723: -- if no group id is passed in then raise error
724: IF p_group_id IS NULL
725: THEN
726: x_return_status := fnd_api.g_ret_sts_error;
727: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_IS_NULL');
728: FND_MSG_PUB.add;
729: RAISE fnd_api.g_exc_error;
730: RETURN;
731: END IF;

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

1175: X_MSG_DATA => x_msg_data );
1176: EXCEPTION
1177: WHEN OTHERS
1178: THEN
1179: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1180: fnd_message.set_token('P_SQLCODE',SQLCODE);
1181: fnd_message.set_token('P_SQLERRM',SQLERRM);
1182: fnd_message.set_token('P_API_NAME',l_api_name);
1183: FND_MSG_PUB.add;

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

1176: EXCEPTION
1177: WHEN OTHERS
1178: THEN
1179: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1180: fnd_message.set_token('P_SQLCODE',SQLCODE);
1181: fnd_message.set_token('P_SQLERRM',SQLERRM);
1182: fnd_message.set_token('P_API_NAME',l_api_name);
1183: FND_MSG_PUB.add;
1184: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1177: WHEN OTHERS
1178: THEN
1179: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1180: fnd_message.set_token('P_SQLCODE',SQLCODE);
1181: fnd_message.set_token('P_SQLERRM',SQLERRM);
1182: fnd_message.set_token('P_API_NAME',l_api_name);
1183: FND_MSG_PUB.add;
1184: x_return_status := fnd_api.g_ret_sts_unexp_error;
1185: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1178: THEN
1179: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1180: fnd_message.set_token('P_SQLCODE',SQLCODE);
1181: fnd_message.set_token('P_SQLERRM',SQLERRM);
1182: fnd_message.set_token('P_API_NAME',l_api_name);
1183: FND_MSG_PUB.add;
1184: x_return_status := fnd_api.g_ret_sts_unexp_error;
1185: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1186: END;

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

1187: WHEN fnd_api.g_exc_unexpected_error
1188: THEN
1189: ROLLBACK TO group_denormalize;
1190:
1191: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
1192: --ND_MSG_PUB.add;
1193: --x_return_status := fnd_api.g_ret_sts_unexp_error;
1194: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1195: WHEN fnd_api.g_exc_error

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

1199:
1200: WHEN OTHERS
1201: THEN
1202: ROLLBACK TO group_denormalize;
1203: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1204: fnd_message.set_token('P_SQLCODE',SQLCODE);
1205: fnd_message.set_token('P_SQLERRM',SQLERRM);
1206: fnd_message.set_token('P_API_NAME',l_api_name);
1207: FND_MSG_PUB.add;

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

1200: WHEN OTHERS
1201: THEN
1202: ROLLBACK TO group_denormalize;
1203: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1204: fnd_message.set_token('P_SQLCODE',SQLCODE);
1205: fnd_message.set_token('P_SQLERRM',SQLERRM);
1206: fnd_message.set_token('P_API_NAME',l_api_name);
1207: FND_MSG_PUB.add;
1208: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1201: THEN
1202: ROLLBACK TO group_denormalize;
1203: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1204: fnd_message.set_token('P_SQLCODE',SQLCODE);
1205: fnd_message.set_token('P_SQLERRM',SQLERRM);
1206: fnd_message.set_token('P_API_NAME',l_api_name);
1207: FND_MSG_PUB.add;
1208: x_return_status := fnd_api.g_ret_sts_unexp_error;
1209: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1202: ROLLBACK TO group_denormalize;
1203: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1204: fnd_message.set_token('P_SQLCODE',SQLCODE);
1205: fnd_message.set_token('P_SQLERRM',SQLERRM);
1206: fnd_message.set_token('P_API_NAME',l_api_name);
1207: FND_MSG_PUB.add;
1208: x_return_status := fnd_api.g_ret_sts_unexp_error;
1209: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1210: END INSERT_GROUPS;

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

1383: X_MSG_DATA => x_msg_data );
1384: EXCEPTION
1385: WHEN OTHERS
1386: THEN
1387: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1388: fnd_message.set_token('P_SQLCODE',SQLCODE);
1389: fnd_message.set_token('P_SQLERRM',SQLERRM);
1390: fnd_message.set_token('P_API_NAME',l_api_name);
1391: FND_MSG_PUB.add;

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

1384: EXCEPTION
1385: WHEN OTHERS
1386: THEN
1387: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1388: fnd_message.set_token('P_SQLCODE',SQLCODE);
1389: fnd_message.set_token('P_SQLERRM',SQLERRM);
1390: fnd_message.set_token('P_API_NAME',l_api_name);
1391: FND_MSG_PUB.add;
1392: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1385: WHEN OTHERS
1386: THEN
1387: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1388: fnd_message.set_token('P_SQLCODE',SQLCODE);
1389: fnd_message.set_token('P_SQLERRM',SQLERRM);
1390: fnd_message.set_token('P_API_NAME',l_api_name);
1391: FND_MSG_PUB.add;
1392: x_return_status := fnd_api.g_ret_sts_unexp_error;
1393: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1386: THEN
1387: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1388: fnd_message.set_token('P_SQLCODE',SQLCODE);
1389: fnd_message.set_token('P_SQLERRM',SQLERRM);
1390: fnd_message.set_token('P_API_NAME',l_api_name);
1391: FND_MSG_PUB.add;
1392: x_return_status := fnd_api.g_ret_sts_unexp_error;
1393: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1394: END;

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

1394: END;
1395: WHEN fnd_api.g_exc_unexpected_error
1396: THEN
1397: ROLLBACK TO group_denormalize;
1398: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
1399: --FND_MSG_PUB.add;
1400: --x_return_status := fnd_api.g_ret_sts_unexp_error;
1401: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1402: WHEN fnd_api.g_exc_error

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

1406:
1407: WHEN OTHERS
1408: THEN
1409: ROLLBACK TO group_denormalize;
1410: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1411: fnd_message.set_token('P_SQLCODE',SQLCODE);
1412: fnd_message.set_token('P_SQLERRM',SQLERRM);
1413: fnd_message.set_token('P_API_NAME',l_api_name);
1414: FND_MSG_PUB.add;

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

1407: WHEN OTHERS
1408: THEN
1409: ROLLBACK TO group_denormalize;
1410: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1411: fnd_message.set_token('P_SQLCODE',SQLCODE);
1412: fnd_message.set_token('P_SQLERRM',SQLERRM);
1413: fnd_message.set_token('P_API_NAME',l_api_name);
1414: FND_MSG_PUB.add;
1415: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1408: THEN
1409: ROLLBACK TO group_denormalize;
1410: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1411: fnd_message.set_token('P_SQLCODE',SQLCODE);
1412: fnd_message.set_token('P_SQLERRM',SQLERRM);
1413: fnd_message.set_token('P_API_NAME',l_api_name);
1414: FND_MSG_PUB.add;
1415: x_return_status := fnd_api.g_ret_sts_unexp_error;
1416: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1409: ROLLBACK TO group_denormalize;
1410: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1411: fnd_message.set_token('P_SQLCODE',SQLCODE);
1412: fnd_message.set_token('P_SQLERRM',SQLERRM);
1413: fnd_message.set_token('P_API_NAME',l_api_name);
1414: FND_MSG_PUB.add;
1415: x_return_status := fnd_api.g_ret_sts_unexp_error;
1416: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1417:

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

1712: where group_id = l_child_tab(i).p_group_id
1713: and parent_group_id = l_parent_tab(j).p_related_group_id;
1714: exception
1715: when others then
1716: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1717: fnd_message.set_token('P_SQLCODE',SQLCODE);
1718: fnd_message.set_token('P_SQLERRM',SQLERRM);
1719: fnd_message.set_token('P_API_NAME', l_api_name);
1720: FND_MSG_PUB.add;

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

1713: and parent_group_id = l_parent_tab(j).p_related_group_id;
1714: exception
1715: when others then
1716: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1717: fnd_message.set_token('P_SQLCODE',SQLCODE);
1718: fnd_message.set_token('P_SQLERRM',SQLERRM);
1719: fnd_message.set_token('P_API_NAME', l_api_name);
1720: FND_MSG_PUB.add;
1721: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1714: exception
1715: when others then
1716: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1717: fnd_message.set_token('P_SQLCODE',SQLCODE);
1718: fnd_message.set_token('P_SQLERRM',SQLERRM);
1719: fnd_message.set_token('P_API_NAME', l_api_name);
1720: FND_MSG_PUB.add;
1721: x_return_status := fnd_api.g_ret_sts_unexp_error;
1722: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1715: when others then
1716: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1717: fnd_message.set_token('P_SQLCODE',SQLCODE);
1718: fnd_message.set_token('P_SQLERRM',SQLERRM);
1719: fnd_message.set_token('P_API_NAME', l_api_name);
1720: FND_MSG_PUB.add;
1721: x_return_status := fnd_api.g_ret_sts_unexp_error;
1722: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1723: RAISE fnd_api.g_exc_unexpected_error;

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

1740: and child_role_relate_id = l_child_rol_rel_tab(k).role_relate_id;
1741:
1742: exception
1743: when others then
1744: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1745: fnd_message.set_token('P_SQLCODE',SQLCODE);
1746: fnd_message.set_token('P_SQLERRM',SQLERRM);
1747: fnd_message.set_token('P_API_NAME', l_api_name);
1748: FND_MSG_PUB.add;

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

1741:
1742: exception
1743: when others then
1744: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1745: fnd_message.set_token('P_SQLCODE',SQLCODE);
1746: fnd_message.set_token('P_SQLERRM',SQLERRM);
1747: fnd_message.set_token('P_API_NAME', l_api_name);
1748: FND_MSG_PUB.add;
1749: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1742: exception
1743: when others then
1744: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1745: fnd_message.set_token('P_SQLCODE',SQLCODE);
1746: fnd_message.set_token('P_SQLERRM',SQLERRM);
1747: fnd_message.set_token('P_API_NAME', l_api_name);
1748: FND_MSG_PUB.add;
1749: x_return_status := fnd_api.g_ret_sts_unexp_error;
1750: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1743: when others then
1744: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1745: fnd_message.set_token('P_SQLCODE',SQLCODE);
1746: fnd_message.set_token('P_SQLERRM',SQLERRM);
1747: fnd_message.set_token('P_API_NAME', l_api_name);
1748: FND_MSG_PUB.add;
1749: x_return_status := fnd_api.g_ret_sts_unexp_error;
1750: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1751: RAISE fnd_api.g_exc_unexpected_error;

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

1836: X_MSG_DATA => x_msg_data );
1837: EXCEPTION
1838: WHEN OTHERS
1839: THEN
1840: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1841: fnd_message.set_token('P_SQLCODE',SQLCODE);
1842: fnd_message.set_token('P_SQLERRM',SQLERRM);
1843: fnd_message.set_token('P_API_NAME',l_api_name);
1844: FND_MSG_PUB.add;

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

1837: EXCEPTION
1838: WHEN OTHERS
1839: THEN
1840: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1841: fnd_message.set_token('P_SQLCODE',SQLCODE);
1842: fnd_message.set_token('P_SQLERRM',SQLERRM);
1843: fnd_message.set_token('P_API_NAME',l_api_name);
1844: FND_MSG_PUB.add;
1845: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1838: WHEN OTHERS
1839: THEN
1840: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1841: fnd_message.set_token('P_SQLCODE',SQLCODE);
1842: fnd_message.set_token('P_SQLERRM',SQLERRM);
1843: fnd_message.set_token('P_API_NAME',l_api_name);
1844: FND_MSG_PUB.add;
1845: x_return_status := fnd_api.g_ret_sts_unexp_error;
1846: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1839: THEN
1840: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1841: fnd_message.set_token('P_SQLCODE',SQLCODE);
1842: fnd_message.set_token('P_SQLERRM',SQLERRM);
1843: fnd_message.set_token('P_API_NAME',l_api_name);
1844: FND_MSG_PUB.add;
1845: x_return_status := fnd_api.g_ret_sts_unexp_error;
1846: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1847: END;

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

1857:
1858: WHEN OTHERS
1859: THEN
1860: ROLLBACK TO group_denormalize;
1861: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1862: fnd_message.set_token('P_SQLCODE',SQLCODE);
1863: fnd_message.set_token('P_SQLERRM',SQLERRM);
1864: fnd_message.set_token('P_API_NAME',l_api_name);
1865: FND_MSG_PUB.add;

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

1858: WHEN OTHERS
1859: THEN
1860: ROLLBACK TO group_denormalize;
1861: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1862: fnd_message.set_token('P_SQLCODE',SQLCODE);
1863: fnd_message.set_token('P_SQLERRM',SQLERRM);
1864: fnd_message.set_token('P_API_NAME',l_api_name);
1865: FND_MSG_PUB.add;
1866: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1859: THEN
1860: ROLLBACK TO group_denormalize;
1861: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1862: fnd_message.set_token('P_SQLCODE',SQLCODE);
1863: fnd_message.set_token('P_SQLERRM',SQLERRM);
1864: fnd_message.set_token('P_API_NAME',l_api_name);
1865: FND_MSG_PUB.add;
1866: x_return_status := fnd_api.g_ret_sts_unexp_error;
1867: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1860: ROLLBACK TO group_denormalize;
1861: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1862: fnd_message.set_token('P_SQLCODE',SQLCODE);
1863: fnd_message.set_token('P_SQLERRM',SQLERRM);
1864: fnd_message.set_token('P_API_NAME',l_api_name);
1865: FND_MSG_PUB.add;
1866: x_return_status := fnd_api.g_ret_sts_unexp_error;
1867: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1868:

Line 2067: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_IS_NULL');

2063: -- if no group id is passed in then raise error
2064: IF p_group_id IS NULL
2065: THEN
2066: x_return_status := fnd_api.g_ret_sts_error;
2067: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_IS_NULL');
2068: FND_MSG_PUB.add;
2069: RAISE fnd_api.g_exc_error;
2070: RETURN;
2071: END IF;

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

2235: X_MSG_DATA => x_msg_data );
2236: EXCEPTION
2237: WHEN OTHERS
2238: THEN
2239: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2240: fnd_message.set_token('P_SQLCODE',SQLCODE);
2241: fnd_message.set_token('P_SQLERRM',SQLERRM);
2242: fnd_message.set_token('P_API_NAME',l_api_name);
2243: FND_MSG_PUB.add;

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

2236: EXCEPTION
2237: WHEN OTHERS
2238: THEN
2239: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2240: fnd_message.set_token('P_SQLCODE',SQLCODE);
2241: fnd_message.set_token('P_SQLERRM',SQLERRM);
2242: fnd_message.set_token('P_API_NAME',l_api_name);
2243: FND_MSG_PUB.add;
2244: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2237: WHEN OTHERS
2238: THEN
2239: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2240: fnd_message.set_token('P_SQLCODE',SQLCODE);
2241: fnd_message.set_token('P_SQLERRM',SQLERRM);
2242: fnd_message.set_token('P_API_NAME',l_api_name);
2243: FND_MSG_PUB.add;
2244: x_return_status := fnd_api.g_ret_sts_unexp_error;
2245: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2238: THEN
2239: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2240: fnd_message.set_token('P_SQLCODE',SQLCODE);
2241: fnd_message.set_token('P_SQLERRM',SQLERRM);
2242: fnd_message.set_token('P_API_NAME',l_api_name);
2243: FND_MSG_PUB.add;
2244: x_return_status := fnd_api.g_ret_sts_unexp_error;
2245: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2246: END;

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

2247: WHEN fnd_api.g_exc_unexpected_error
2248: THEN
2249: ROLLBACK TO group_denormalize;
2250:
2251: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
2252: --ND_MSG_PUB.add;
2253: --x_return_status := fnd_api.g_ret_sts_unexp_error;
2254: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2255: WHEN fnd_api.g_exc_error

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

2259:
2260: WHEN OTHERS
2261: THEN
2262: ROLLBACK TO group_denormalize;
2263: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2264: fnd_message.set_token('P_SQLCODE',SQLCODE);
2265: fnd_message.set_token('P_SQLERRM',SQLERRM);
2266: fnd_message.set_token('P_API_NAME',l_api_name);
2267: FND_MSG_PUB.add;

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

2260: WHEN OTHERS
2261: THEN
2262: ROLLBACK TO group_denormalize;
2263: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2264: fnd_message.set_token('P_SQLCODE',SQLCODE);
2265: fnd_message.set_token('P_SQLERRM',SQLERRM);
2266: fnd_message.set_token('P_API_NAME',l_api_name);
2267: FND_MSG_PUB.add;
2268: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2261: THEN
2262: ROLLBACK TO group_denormalize;
2263: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2264: fnd_message.set_token('P_SQLCODE',SQLCODE);
2265: fnd_message.set_token('P_SQLERRM',SQLERRM);
2266: fnd_message.set_token('P_API_NAME',l_api_name);
2267: FND_MSG_PUB.add;
2268: x_return_status := fnd_api.g_ret_sts_unexp_error;
2269: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2262: ROLLBACK TO group_denormalize;
2263: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2264: fnd_message.set_token('P_SQLCODE',SQLCODE);
2265: fnd_message.set_token('P_SQLERRM',SQLERRM);
2266: fnd_message.set_token('P_API_NAME',l_api_name);
2267: FND_MSG_PUB.add;
2268: x_return_status := fnd_api.g_ret_sts_unexp_error;
2269: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2270: END INSERT_GROUPS_PARENT;

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

2471: WHEN fnd_api.g_exc_unexpected_error
2472: THEN
2473:
2474: ROLLBACK TO group_denormalize;
2475: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
2476: --FND_MSG_PUB.add;
2477: --x_return_status := fnd_api.g_ret_sts_unexp_error;
2478: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2479: WHEN fnd_api.g_exc_error

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

2483:
2484: WHEN OTHERS
2485: THEN
2486: ROLLBACK TO group_denormalize;
2487: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2488: fnd_message.set_token('P_SQLCODE',SQLCODE);
2489: fnd_message.set_token('P_SQLERRM',SQLERRM);
2490: fnd_message.set_token('P_API_NAME',l_api_name);
2491: FND_MSG_PUB.add;

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

2484: WHEN OTHERS
2485: THEN
2486: ROLLBACK TO group_denormalize;
2487: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2488: fnd_message.set_token('P_SQLCODE',SQLCODE);
2489: fnd_message.set_token('P_SQLERRM',SQLERRM);
2490: fnd_message.set_token('P_API_NAME',l_api_name);
2491: FND_MSG_PUB.add;
2492: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2485: THEN
2486: ROLLBACK TO group_denormalize;
2487: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2488: fnd_message.set_token('P_SQLCODE',SQLCODE);
2489: fnd_message.set_token('P_SQLERRM',SQLERRM);
2490: fnd_message.set_token('P_API_NAME',l_api_name);
2491: FND_MSG_PUB.add;
2492: x_return_status := fnd_api.g_ret_sts_unexp_error;
2493: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2486: ROLLBACK TO group_denormalize;
2487: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2488: fnd_message.set_token('P_SQLCODE',SQLCODE);
2489: fnd_message.set_token('P_SQLERRM',SQLERRM);
2490: fnd_message.set_token('P_API_NAME',l_api_name);
2491: FND_MSG_PUB.add;
2492: x_return_status := fnd_api.g_ret_sts_unexp_error;
2493: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2494:

Line 2858: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_IS_NULL');

2854: -- if no group id is passed in then raise error
2855: IF p_group_id IS NULL
2856: THEN
2857: x_return_status := fnd_api.g_ret_sts_error;
2858: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_IS_NULL');
2859: FND_MSG_PUB.add;
2860: RAISE fnd_api.g_exc_error;
2861: RETURN;
2862: END IF;

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

3275: WHEN fnd_api.g_exc_unexpected_error
3276: THEN
3277: ROLLBACK TO group_denormalize_no_con;
3278:
3279: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
3280: --ND_MSG_PUB.add;
3281: --x_return_status := fnd_api.g_ret_sts_unexp_error;
3282: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3283: WHEN fnd_api.g_exc_error

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

3287:
3288: WHEN OTHERS
3289: THEN
3290: ROLLBACK TO group_denormalize_no_con;
3291: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3292: fnd_message.set_token('P_SQLCODE',SQLCODE);
3293: fnd_message.set_token('P_SQLERRM',SQLERRM);
3294: fnd_message.set_token('P_API_NAME',l_api_name);
3295: FND_MSG_PUB.add;

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

3288: WHEN OTHERS
3289: THEN
3290: ROLLBACK TO group_denormalize_no_con;
3291: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3292: fnd_message.set_token('P_SQLCODE',SQLCODE);
3293: fnd_message.set_token('P_SQLERRM',SQLERRM);
3294: fnd_message.set_token('P_API_NAME',l_api_name);
3295: FND_MSG_PUB.add;
3296: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3289: THEN
3290: ROLLBACK TO group_denormalize_no_con;
3291: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3292: fnd_message.set_token('P_SQLCODE',SQLCODE);
3293: fnd_message.set_token('P_SQLERRM',SQLERRM);
3294: fnd_message.set_token('P_API_NAME',l_api_name);
3295: FND_MSG_PUB.add;
3296: x_return_status := fnd_api.g_ret_sts_unexp_error;
3297: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3290: ROLLBACK TO group_denormalize_no_con;
3291: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3292: fnd_message.set_token('P_SQLCODE',SQLCODE);
3293: fnd_message.set_token('P_SQLERRM',SQLERRM);
3294: fnd_message.set_token('P_API_NAME',l_api_name);
3295: FND_MSG_PUB.add;
3296: x_return_status := fnd_api.g_ret_sts_unexp_error;
3297: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3298: END INSERT_GROUPS_NO_CON;

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

3444: EXCEPTION
3445: WHEN fnd_api.g_exc_unexpected_error
3446: THEN
3447: ROLLBACK TO group_denormalize_no_con;
3448: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
3449: --FND_MSG_PUB.add;
3450: --x_return_status := fnd_api.g_ret_sts_unexp_error;
3451: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3452: WHEN fnd_api.g_exc_error

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

3456:
3457: WHEN OTHERS
3458: THEN
3459: ROLLBACK TO group_denormalize_no_con;
3460: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3461: fnd_message.set_token('P_SQLCODE',SQLCODE);
3462: fnd_message.set_token('P_SQLERRM',SQLERRM);
3463: fnd_message.set_token('P_API_NAME',l_api_name);
3464: FND_MSG_PUB.add;

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

3457: WHEN OTHERS
3458: THEN
3459: ROLLBACK TO group_denormalize_no_con;
3460: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3461: fnd_message.set_token('P_SQLCODE',SQLCODE);
3462: fnd_message.set_token('P_SQLERRM',SQLERRM);
3463: fnd_message.set_token('P_API_NAME',l_api_name);
3464: FND_MSG_PUB.add;
3465: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3458: THEN
3459: ROLLBACK TO group_denormalize_no_con;
3460: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3461: fnd_message.set_token('P_SQLCODE',SQLCODE);
3462: fnd_message.set_token('P_SQLERRM',SQLERRM);
3463: fnd_message.set_token('P_API_NAME',l_api_name);
3464: FND_MSG_PUB.add;
3465: x_return_status := fnd_api.g_ret_sts_unexp_error;
3466: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3459: ROLLBACK TO group_denormalize_no_con;
3460: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3461: fnd_message.set_token('P_SQLCODE',SQLCODE);
3462: fnd_message.set_token('P_SQLERRM',SQLERRM);
3463: fnd_message.set_token('P_API_NAME',l_api_name);
3464: FND_MSG_PUB.add;
3465: x_return_status := fnd_api.g_ret_sts_unexp_error;
3466: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3467:

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

3700: where group_id = l_child_tab(i).p_group_id
3701: and parent_group_id = l_parent_tab(j).p_related_group_id;
3702: exception
3703: when others then
3704: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3705: fnd_message.set_token('P_SQLCODE',SQLCODE);
3706: fnd_message.set_token('P_SQLERRM',SQLERRM);
3707: fnd_message.set_token('P_API_NAME', l_api_name);
3708: FND_MSG_PUB.add;

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

3701: and parent_group_id = l_parent_tab(j).p_related_group_id;
3702: exception
3703: when others then
3704: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3705: fnd_message.set_token('P_SQLCODE',SQLCODE);
3706: fnd_message.set_token('P_SQLERRM',SQLERRM);
3707: fnd_message.set_token('P_API_NAME', l_api_name);
3708: FND_MSG_PUB.add;
3709: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3702: exception
3703: when others then
3704: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3705: fnd_message.set_token('P_SQLCODE',SQLCODE);
3706: fnd_message.set_token('P_SQLERRM',SQLERRM);
3707: fnd_message.set_token('P_API_NAME', l_api_name);
3708: FND_MSG_PUB.add;
3709: x_return_status := fnd_api.g_ret_sts_unexp_error;
3710: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3703: when others then
3704: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3705: fnd_message.set_token('P_SQLCODE',SQLCODE);
3706: fnd_message.set_token('P_SQLERRM',SQLERRM);
3707: fnd_message.set_token('P_API_NAME', l_api_name);
3708: FND_MSG_PUB.add;
3709: x_return_status := fnd_api.g_ret_sts_unexp_error;
3710: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3711: RAISE fnd_api.g_exc_unexpected_error;

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

3728: and child_role_relate_id = l_child_rol_rel_tab(k).role_relate_id;
3729:
3730: exception
3731: when others then
3732: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3733: fnd_message.set_token('P_SQLCODE',SQLCODE);
3734: fnd_message.set_token('P_SQLERRM',SQLERRM);
3735: fnd_message.set_token('P_API_NAME', l_api_name);
3736: FND_MSG_PUB.add;

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

3729:
3730: exception
3731: when others then
3732: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3733: fnd_message.set_token('P_SQLCODE',SQLCODE);
3734: fnd_message.set_token('P_SQLERRM',SQLERRM);
3735: fnd_message.set_token('P_API_NAME', l_api_name);
3736: FND_MSG_PUB.add;
3737: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3730: exception
3731: when others then
3732: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3733: fnd_message.set_token('P_SQLCODE',SQLCODE);
3734: fnd_message.set_token('P_SQLERRM',SQLERRM);
3735: fnd_message.set_token('P_API_NAME', l_api_name);
3736: FND_MSG_PUB.add;
3737: x_return_status := fnd_api.g_ret_sts_unexp_error;
3738: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3731: when others then
3732: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3733: fnd_message.set_token('P_SQLCODE',SQLCODE);
3734: fnd_message.set_token('P_SQLERRM',SQLERRM);
3735: fnd_message.set_token('P_API_NAME', l_api_name);
3736: FND_MSG_PUB.add;
3737: x_return_status := fnd_api.g_ret_sts_unexp_error;
3738: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3739: RAISE fnd_api.g_exc_unexpected_error;

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

3806:
3807: WHEN OTHERS
3808: THEN
3809: ROLLBACK TO group_denormalize_no_con;
3810: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3811: fnd_message.set_token('P_SQLCODE',SQLCODE);
3812: fnd_message.set_token('P_SQLERRM',SQLERRM);
3813: fnd_message.set_token('P_API_NAME',l_api_name);
3814: FND_MSG_PUB.add;

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

3807: WHEN OTHERS
3808: THEN
3809: ROLLBACK TO group_denormalize_no_con;
3810: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3811: fnd_message.set_token('P_SQLCODE',SQLCODE);
3812: fnd_message.set_token('P_SQLERRM',SQLERRM);
3813: fnd_message.set_token('P_API_NAME',l_api_name);
3814: FND_MSG_PUB.add;
3815: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3808: THEN
3809: ROLLBACK TO group_denormalize_no_con;
3810: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3811: fnd_message.set_token('P_SQLCODE',SQLCODE);
3812: fnd_message.set_token('P_SQLERRM',SQLERRM);
3813: fnd_message.set_token('P_API_NAME',l_api_name);
3814: FND_MSG_PUB.add;
3815: x_return_status := fnd_api.g_ret_sts_unexp_error;
3816: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3809: ROLLBACK TO group_denormalize_no_con;
3810: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3811: fnd_message.set_token('P_SQLCODE',SQLCODE);
3812: fnd_message.set_token('P_SQLERRM',SQLERRM);
3813: fnd_message.set_token('P_API_NAME',l_api_name);
3814: FND_MSG_PUB.add;
3815: x_return_status := fnd_api.g_ret_sts_unexp_error;
3816: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3817:

Line 4000: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_IS_NULL');

3996: -- if no group id is passed in then raise error
3997: IF p_group_id IS NULL
3998: THEN
3999: x_return_status := fnd_api.g_ret_sts_error;
4000: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_IS_NULL');
4001: FND_MSG_PUB.add;
4002: RAISE fnd_api.g_exc_error;
4003: RETURN;
4004: END IF;

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

4151: WHEN fnd_api.g_exc_unexpected_error
4152: THEN
4153: ROLLBACK TO group_denormalize_no_con;
4154:
4155: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
4156: --ND_MSG_PUB.add;
4157: --x_return_status := fnd_api.g_ret_sts_unexp_error;
4158: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4159: WHEN fnd_api.g_exc_error

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

4163:
4164: WHEN OTHERS
4165: THEN
4166: ROLLBACK TO group_denormalize_no_con;
4167: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
4168: fnd_message.set_token('P_SQLCODE',SQLCODE);
4169: fnd_message.set_token('P_SQLERRM',SQLERRM);
4170: fnd_message.set_token('P_API_NAME',l_api_name);
4171: FND_MSG_PUB.add;

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

4164: WHEN OTHERS
4165: THEN
4166: ROLLBACK TO group_denormalize_no_con;
4167: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
4168: fnd_message.set_token('P_SQLCODE',SQLCODE);
4169: fnd_message.set_token('P_SQLERRM',SQLERRM);
4170: fnd_message.set_token('P_API_NAME',l_api_name);
4171: FND_MSG_PUB.add;
4172: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

4165: THEN
4166: ROLLBACK TO group_denormalize_no_con;
4167: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
4168: fnd_message.set_token('P_SQLCODE',SQLCODE);
4169: fnd_message.set_token('P_SQLERRM',SQLERRM);
4170: fnd_message.set_token('P_API_NAME',l_api_name);
4171: FND_MSG_PUB.add;
4172: x_return_status := fnd_api.g_ret_sts_unexp_error;
4173: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

4166: ROLLBACK TO group_denormalize_no_con;
4167: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
4168: fnd_message.set_token('P_SQLCODE',SQLCODE);
4169: fnd_message.set_token('P_SQLERRM',SQLERRM);
4170: fnd_message.set_token('P_API_NAME',l_api_name);
4171: FND_MSG_PUB.add;
4172: x_return_status := fnd_api.g_ret_sts_unexp_error;
4173: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4174: END INSERT_GROUPS_PARENT_NO_CON;