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_MSG_PUB

Line 192: FND_MSG_PUB.Initialize;

188:
189: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
190: IF FND_API.To_boolean(P_INIT_MSG_LIST)
191: THEN
192: FND_MSG_PUB.Initialize;
193: END IF;
194:
195: l_date := sysdate;
196: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 204: FND_MSG_PUB.add;

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

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

276: COMMIT WORK;
277: END IF;
278:
279:
280: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
281:
282: EXCEPTION
283: WHEN fnd_api.g_exc_unexpected_error
284: THEN

Line 287: --FND_MSG_PUB.add;

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

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

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
291: THEN
292: ROLLBACK TO group_denormalize;
293: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

289: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
290: WHEN fnd_api.g_exc_error
291: THEN
292: ROLLBACK TO group_denormalize;
293: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
294:
295: WHEN OTHERS
296: THEN
297: ROLLBACK TO group_denormalize;

Line 302: FND_MSG_PUB.add;

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

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

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;
306:
307:
308:

Line 360: FND_MSG_PUB.Initialize;

356:
357: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
358: IF FND_API.To_boolean(P_INIT_MSG_LIST)
359: THEN
360: FND_MSG_PUB.Initialize;
361: END IF;
362:
363: l_date := sysdate;
364: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 372: FND_MSG_PUB.add;

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

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

405: COMMIT WORK;
406: END IF;
407:
408:
409: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
410:
411: EXCEPTION
412: WHEN fnd_api.g_exc_unexpected_error
413: THEN

Line 416: --FND_MSG_PUB.add;

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

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

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
420: THEN
421: ROLLBACK TO group_denormalize;
422: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

418: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
419: WHEN fnd_api.g_exc_error
420: THEN
421: ROLLBACK TO group_denormalize;
422: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
423:
424: WHEN OTHERS
425: THEN
426: ROLLBACK TO group_denormalize;

Line 431: FND_MSG_PUB.add;

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

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

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;
435:
436:
437:

Line 716: FND_MSG_PUB.Initialize;

712:
713: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
714: IF FND_API.To_boolean(P_INIT_MSG_LIST)
715: THEN
716: FND_MSG_PUB.Initialize;
717: END IF;
718:
719: l_date := sysdate;
720: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 728: FND_MSG_PUB.add;

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

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

1157: COMMIT WORK;
1158: END IF;
1159:
1160:
1161: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1162:
1163: EXCEPTION
1164: WHEN l_connect_by_loop_error
1165: THEN

Line 1183: FND_MSG_PUB.add;

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;
1187: WHEN fnd_api.g_exc_unexpected_error

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

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;
1187: WHEN fnd_api.g_exc_unexpected_error
1188: THEN
1189: ROLLBACK TO group_denormalize;

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

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
1196: THEN
1197: ROLLBACK TO group_denormalize;
1198: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1194: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1195: WHEN fnd_api.g_exc_error
1196: THEN
1197: ROLLBACK TO group_denormalize;
1198: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1199:
1200: WHEN OTHERS
1201: THEN
1202: ROLLBACK TO group_denormalize;

Line 1207: FND_MSG_PUB.add;

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

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

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;
1211:
1212:
1213: --Start of procedure Body

Line 1294: FND_MSG_PUB.Initialize;

1290:
1291: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1292: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1293: THEN
1294: FND_MSG_PUB.Initialize;
1295: END IF;
1296:
1297:
1298: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE

Line 1301: FND_MSG_PUB.Initialize;

1297:
1298: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1299: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1300: THEN
1301: FND_MSG_PUB.Initialize;
1302: END IF;
1303:
1304: l_date := sysdate;
1305: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

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

1365: THEN
1366: COMMIT WORK;
1367: END IF;
1368:
1369: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1370:
1371: EXCEPTION
1372: WHEN l_connect_by_loop_error
1373: THEN

Line 1391: FND_MSG_PUB.add;

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;
1395: WHEN fnd_api.g_exc_unexpected_error

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

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;
1395: WHEN fnd_api.g_exc_unexpected_error
1396: THEN
1397: ROLLBACK TO group_denormalize;

Line 1399: --FND_MSG_PUB.add;

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

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

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
1403: THEN
1404: ROLLBACK TO group_denormalize;
1405: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1401: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1402: WHEN fnd_api.g_exc_error
1403: THEN
1404: ROLLBACK TO group_denormalize;
1405: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1406:
1407: WHEN OTHERS
1408: THEN
1409: ROLLBACK TO group_denormalize;

Line 1414: FND_MSG_PUB.add;

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:
1418: END UPDATE_GROUPS;

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

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:
1418: END UPDATE_GROUPS;
1419:
1420:

Line 1601: FND_MSG_PUB.Initialize;

1597:
1598: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1599: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1600: THEN
1601: FND_MSG_PUB.Initialize;
1602: END IF;
1603:
1604:
1605: l_date := sysdate;

Line 1720: FND_MSG_PUB.add;

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

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

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;
1724:
1725: end;
1726:

Line 1748: FND_MSG_PUB.add;

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;
1752: end;

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

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;
1752: end;
1753:
1754: end loop; -- end of child

Line 1844: FND_MSG_PUB.add;

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;
1848: WHEN fnd_api.g_exc_unexpected_error

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

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;
1848: WHEN fnd_api.g_exc_unexpected_error
1849: THEN
1850:

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

1848: WHEN fnd_api.g_exc_unexpected_error
1849: THEN
1850:
1851: ROLLBACK TO group_denormalize;
1852: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1853: WHEN fnd_api.g_exc_error
1854: THEN
1855: ROLLBACK TO group_denormalize;
1856: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1852: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1853: WHEN fnd_api.g_exc_error
1854: THEN
1855: ROLLBACK TO group_denormalize;
1856: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1857:
1858: WHEN OTHERS
1859: THEN
1860: ROLLBACK TO group_denormalize;

Line 1865: FND_MSG_PUB.add;

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:
1869: end delete_grp_relations;

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

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:
1869: end delete_grp_relations;
1870:
1871: PROCEDURE INSERT_GROUPS_PARENT(

Line 2056: FND_MSG_PUB.Initialize;

2052:
2053: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2054: IF FND_API.To_boolean(P_INIT_MSG_LIST)
2055: THEN
2056: FND_MSG_PUB.Initialize;
2057: END IF;
2058:
2059: l_date := sysdate;
2060: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 2068: FND_MSG_PUB.add;

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

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

2217: COMMIT WORK;
2218: END IF;
2219:
2220:
2221: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2222:
2223: EXCEPTION
2224: WHEN l_connect_by_loop_error
2225: THEN

Line 2243: FND_MSG_PUB.add;

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;
2247: WHEN fnd_api.g_exc_unexpected_error

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

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;
2247: WHEN fnd_api.g_exc_unexpected_error
2248: THEN
2249: ROLLBACK TO group_denormalize;

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

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
2256: THEN
2257: ROLLBACK TO group_denormalize;
2258: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2254: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2255: WHEN fnd_api.g_exc_error
2256: THEN
2257: ROLLBACK TO group_denormalize;
2258: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2259:
2260: WHEN OTHERS
2261: THEN
2262: ROLLBACK TO group_denormalize;

Line 2267: FND_MSG_PUB.add;

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

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

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;
2271:
2272: --Start of procedure Body
2273: --FOR DELETE

Line 2361: FND_MSG_PUB.Initialize;

2357:
2358: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2359: IF FND_API.To_boolean(P_INIT_MSG_LIST)
2360: THEN
2361: FND_MSG_PUB.Initialize;
2362: END IF;
2363:
2364:
2365: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE

Line 2368: FND_MSG_PUB.Initialize;

2364:
2365: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2366: IF FND_API.To_boolean(P_INIT_MSG_LIST)
2367: THEN
2368: FND_MSG_PUB.Initialize;
2369: END IF;
2370:
2371: l_date := sysdate;
2372: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

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

2464: THEN
2465: COMMIT WORK;
2466: END IF;
2467:
2468: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2469:
2470: EXCEPTION
2471: WHEN fnd_api.g_exc_unexpected_error
2472: THEN

Line 2476: --FND_MSG_PUB.add;

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

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

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
2480: THEN
2481: ROLLBACK TO group_denormalize;
2482: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2478: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2479: WHEN fnd_api.g_exc_error
2480: THEN
2481: ROLLBACK TO group_denormalize;
2482: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2483:
2484: WHEN OTHERS
2485: THEN
2486: ROLLBACK TO group_denormalize;

Line 2491: FND_MSG_PUB.add;

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:
2495: END DELETE_GROUPS;

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

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:
2495: END DELETE_GROUPS;
2496: ------ CONNECT BY PRIOR - SECTION - Ends
2497:

Line 2847: FND_MSG_PUB.Initialize;

2843:
2844: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2845: IF FND_API.To_boolean(P_INIT_MSG_LIST)
2846: THEN
2847: FND_MSG_PUB.Initialize;
2848: END IF;
2849:
2850: l_date := sysdate;
2851: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 2859: FND_MSG_PUB.add;

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

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

3268: COMMIT WORK;
3269: END IF;
3270:
3271:
3272: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3273:
3274: EXCEPTION
3275: WHEN fnd_api.g_exc_unexpected_error
3276: THEN

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

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
3284: THEN
3285: ROLLBACK TO group_denormalize_no_con;
3286: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3282: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3283: WHEN fnd_api.g_exc_error
3284: THEN
3285: ROLLBACK TO group_denormalize_no_con;
3286: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3287:
3288: WHEN OTHERS
3289: THEN
3290: ROLLBACK TO group_denormalize_no_con;

Line 3295: FND_MSG_PUB.add;

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

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

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;
3299:
3300:
3301: --Start of procedure Body

Line 3371: FND_MSG_PUB.Initialize;

3367:
3368: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
3369: IF FND_API.To_boolean(P_INIT_MSG_LIST)
3370: THEN
3371: FND_MSG_PUB.Initialize;
3372: END IF;
3373:
3374:
3375: l_date := sysdate;

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

3438: THEN
3439: COMMIT WORK;
3440: END IF;
3441:
3442: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3443:
3444: EXCEPTION
3445: WHEN fnd_api.g_exc_unexpected_error
3446: THEN

Line 3449: --FND_MSG_PUB.add;

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

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

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
3453: THEN
3454: ROLLBACK TO group_denormalize_no_con;
3455: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3451: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3452: WHEN fnd_api.g_exc_error
3453: THEN
3454: ROLLBACK TO group_denormalize_no_con;
3455: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3456:
3457: WHEN OTHERS
3458: THEN
3459: ROLLBACK TO group_denormalize_no_con;

Line 3464: FND_MSG_PUB.add;

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:
3468: END UPDATE_GROUPS_NO_CON;

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

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:
3468: END UPDATE_GROUPS_NO_CON;
3469:
3470:

Line 3606: FND_MSG_PUB.Initialize;

3602:
3603: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
3604: IF FND_API.To_boolean(P_INIT_MSG_LIST)
3605: THEN
3606: FND_MSG_PUB.Initialize;
3607: END IF;
3608:
3609:
3610: l_date := sysdate;

Line 3708: FND_MSG_PUB.add;

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

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

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;
3712:
3713: end;
3714:

Line 3736: FND_MSG_PUB.add;

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;
3740: end;

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

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;
3740: end;
3741:
3742: end loop; -- end of child

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

3797: WHEN fnd_api.g_exc_unexpected_error
3798: THEN
3799:
3800: ROLLBACK TO group_denormalize_no_con;
3801: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3802: WHEN fnd_api.g_exc_error
3803: THEN
3804: ROLLBACK TO group_denormalize_no_con;
3805: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3801: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3802: WHEN fnd_api.g_exc_error
3803: THEN
3804: ROLLBACK TO group_denormalize_no_con;
3805: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3806:
3807: WHEN OTHERS
3808: THEN
3809: ROLLBACK TO group_denormalize_no_con;

Line 3814: FND_MSG_PUB.add;

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:
3818: end delete_grp_relations_no_con;

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

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:
3818: end delete_grp_relations_no_con;
3819:
3820: /* These are the procedures which are clones of correponding

Line 3989: FND_MSG_PUB.Initialize;

3985:
3986: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
3987: IF FND_API.To_boolean(P_INIT_MSG_LIST)
3988: THEN
3989: FND_MSG_PUB.Initialize;
3990: END IF;
3991:
3992: l_date := sysdate;
3993: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 4001: FND_MSG_PUB.add;

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

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

4144: COMMIT WORK;
4145: END IF;
4146:
4147:
4148: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4149:
4150: EXCEPTION
4151: WHEN fnd_api.g_exc_unexpected_error
4152: THEN

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

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
4160: THEN
4161: ROLLBACK TO group_denormalize_no_con;
4162: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

4158: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4159: WHEN fnd_api.g_exc_error
4160: THEN
4161: ROLLBACK TO group_denormalize_no_con;
4162: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4163:
4164: WHEN OTHERS
4165: THEN
4166: ROLLBACK TO group_denormalize_no_con;

Line 4171: FND_MSG_PUB.add;

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;
4175: ------ NO CONNECT BY - SECTION - Ends

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

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;
4175: ------ NO CONNECT BY - SECTION - Ends
4176:
4177: END JTF_RS_GROUP_DENORM_PVT;