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_API

Line 181: x_return_status := fnd_api.g_ret_sts_success;

177:
178: --Standard Start of API SAVEPOINT
179: SAVEPOINT group_denormalize;
180:
181: x_return_status := fnd_api.g_ret_sts_success;
182:
183: --Standard Call to check API compatibility
184: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
185: THEN

Line 184: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

180:
181: x_return_status := fnd_api.g_ret_sts_success;
182:
183: --Standard Call to check API compatibility
184: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
185: THEN
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
188:

Line 186: RAISE FND_API.G_EXC_ERROR;

182:
183: --Standard Call to check API compatibility
184: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
185: THEN
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
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)

Line 190: IF FND_API.To_boolean(P_INIT_MSG_LIST)

186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
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:

Line 202: x_return_status := fnd_api.g_ret_sts_error;

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

Line 205: RAISE fnd_api.g_exc_error;

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:
209: l_date := sysdate;

Line 274: IF fnd_api.to_boolean (p_commit)

270: END IF;
271: CLOSE c_dup;
272:
273:
274: IF fnd_api.to_boolean (p_commit)
275: THEN
276: COMMIT WORK;
277: END IF;
278:

Line 283: WHEN fnd_api.g_exc_unexpected_error

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
285: ROLLBACK TO group_denormalize;
286: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
287: --FND_MSG_PUB.add;

Line 288: --x_return_status := fnd_api.g_ret_sts_unexp_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
292: ROLLBACK TO group_denormalize;

Line 290: WHEN fnd_api.g_exc_error

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);
294:

Line 303: x_return_status := fnd_api.g_ret_sts_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:
307:

Line 332: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;

328: l_start_date_1 Date;
329: l_end_date_1 Date;
330: l_DENORM_GRP_ID JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE;
331: x_row_id varchar2(24) := null;
332: l_return_status VARCHAR2(30) := fnd_api.g_ret_sts_success;
333: L_MSG_DATA VARCHAR2(200);
334: L_MSG_COUNT number;
335:
336:

Line 349: x_return_status := fnd_api.g_ret_sts_success;

345:
346: --Standard Start of API SAVEPOINT
347: SAVEPOINT group_denormalize;
348:
349: x_return_status := fnd_api.g_ret_sts_success;
350:
351: --Standard Call to check API compatibility
352: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
353: THEN

Line 352: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

348:
349: x_return_status := fnd_api.g_ret_sts_success;
350:
351: --Standard Call to check API compatibility
352: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
353: THEN
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:

Line 354: RAISE FND_API.G_EXC_ERROR;

350:
351: --Standard Call to check API compatibility
352: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
353: THEN
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
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)

Line 358: IF FND_API.To_boolean(P_INIT_MSG_LIST)

354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
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:

Line 370: x_return_status := fnd_api.g_ret_sts_error;

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

Line 373: RAISE fnd_api.g_exc_error;

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:
377: l_date := sysdate;

Line 403: IF fnd_api.to_boolean (p_commit)

399: END IF;
400: CLOSE denorm_cur;
401:
402:
403: IF fnd_api.to_boolean (p_commit)
404: THEN
405: COMMIT WORK;
406: END IF;
407:

Line 412: WHEN fnd_api.g_exc_unexpected_error

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
414: ROLLBACK TO group_denormalize;
415: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
416: --FND_MSG_PUB.add;

Line 417: --x_return_status := fnd_api.g_ret_sts_unexp_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
421: ROLLBACK TO group_denormalize;

Line 419: WHEN fnd_api.g_exc_error

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);
423:

Line 432: x_return_status := fnd_api.g_ret_sts_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:
436:

Line 555: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

551: l_user_id Number;
552: l_login_id Number;
553: l_start_date Date;
554: l_end_date Date;
555: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
556: l_msg_count number;
557: l_msg_data varchar2(2000);
558:
559: l_start_date_active Date;

Line 705: x_return_status := fnd_api.g_ret_sts_success;

701:
702: --Standard Start of API SAVEPOINT
703: SAVEPOINT group_denormalize;
704:
705: x_return_status := fnd_api.g_ret_sts_success;
706:
707: --Standard Call to check API compatibility
708: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
709: THEN

Line 708: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

704:
705: x_return_status := fnd_api.g_ret_sts_success;
706:
707: --Standard Call to check API compatibility
708: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
709: THEN
710: RAISE FND_API.G_EXC_ERROR;
711: END IF;
712:

Line 710: RAISE FND_API.G_EXC_ERROR;

706:
707: --Standard Call to check API compatibility
708: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
709: THEN
710: RAISE FND_API.G_EXC_ERROR;
711: END IF;
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)

Line 714: IF FND_API.To_boolean(P_INIT_MSG_LIST)

710: RAISE FND_API.G_EXC_ERROR;
711: END IF;
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:

Line 726: x_return_status := fnd_api.g_ret_sts_error;

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

Line 729: RAISE fnd_api.g_exc_error;

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:
733: l_date := sysdate;

Line 879: IF(l_return_status <> fnd_api.g_ret_sts_success)

875: X_RETURN_STATUS => l_return_status,
876: X_MSG_COUNT => l_msg_count,
877: X_MSG_DATA => l_msg_data ) ;
878:
879: IF(l_return_status <> fnd_api.g_ret_sts_success)
880: THEN
881: x_return_status := fnd_api.g_ret_sts_error;
882: RAISE fnd_api.g_exc_error;
883: END IF;

Line 881: x_return_status := fnd_api.g_ret_sts_error;

877: X_MSG_DATA => l_msg_data ) ;
878:
879: IF(l_return_status <> fnd_api.g_ret_sts_success)
880: THEN
881: x_return_status := fnd_api.g_ret_sts_error;
882: RAISE fnd_api.g_exc_error;
883: END IF;
884:
885: END IF; -- end of duplicate check

Line 882: RAISE fnd_api.g_exc_error;

878:
879: IF(l_return_status <> fnd_api.g_ret_sts_success)
880: THEN
881: x_return_status := fnd_api.g_ret_sts_error;
882: RAISE fnd_api.g_exc_error;
883: END IF;
884:
885: END IF; -- end of duplicate check
886: CLOSE c_dup;

Line 1008: IF(l_return_status <> fnd_api.g_ret_sts_success)

1004: X_RETURN_STATUS => l_return_status,
1005: X_MSG_COUNT => l_msg_count,
1006: X_MSG_DATA => l_msg_data ) ;
1007:
1008: IF(l_return_status <> fnd_api.g_ret_sts_success)
1009: THEN
1010: x_return_status := fnd_api.g_ret_sts_error;
1011: RAISE fnd_api.g_exc_error;
1012: END IF;

Line 1010: x_return_status := fnd_api.g_ret_sts_error;

1006: X_MSG_DATA => l_msg_data ) ;
1007:
1008: IF(l_return_status <> fnd_api.g_ret_sts_success)
1009: THEN
1010: x_return_status := fnd_api.g_ret_sts_error;
1011: RAISE fnd_api.g_exc_error;
1012: END IF;
1013: END IF;
1014: CLOSE c_dup;

Line 1011: RAISE fnd_api.g_exc_error;

1007:
1008: IF(l_return_status <> fnd_api.g_ret_sts_success)
1009: THEN
1010: x_return_status := fnd_api.g_ret_sts_error;
1011: RAISE fnd_api.g_exc_error;
1012: END IF;
1013: END IF;
1014: CLOSE c_dup;
1015:

Line 1121: IF(l_return_status <> fnd_api.g_ret_sts_success)

1117: X_RETURN_STATUS => l_return_status,
1118: X_MSG_COUNT => l_msg_count,
1119: X_MSG_DATA => l_msg_data ) ;
1120:
1121: IF(l_return_status <> fnd_api.g_ret_sts_success)
1122: THEN
1123: x_return_status := fnd_api.g_ret_sts_error;
1124: RAISE fnd_api.g_exc_error;
1125: END IF;

Line 1123: x_return_status := fnd_api.g_ret_sts_error;

1119: X_MSG_DATA => l_msg_data ) ;
1120:
1121: IF(l_return_status <> fnd_api.g_ret_sts_success)
1122: THEN
1123: x_return_status := fnd_api.g_ret_sts_error;
1124: RAISE fnd_api.g_exc_error;
1125: END IF;
1126:
1127: END IF; -- end of duplicate check

Line 1124: RAISE fnd_api.g_exc_error;

1120:
1121: IF(l_return_status <> fnd_api.g_ret_sts_success)
1122: THEN
1123: x_return_status := fnd_api.g_ret_sts_error;
1124: RAISE fnd_api.g_exc_error;
1125: END IF;
1126:
1127: END IF; -- end of duplicate check
1128: CLOSE c_dup;

Line 1155: IF fnd_api.to_boolean (p_commit)

1151: END LOOP;
1152: CLOSE c_parents;
1153:
1154:
1155: IF fnd_api.to_boolean (p_commit)
1156: THEN
1157: COMMIT WORK;
1158: END IF;
1159:

Line 1184: x_return_status := fnd_api.g_ret_sts_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
1188: THEN

Line 1187: WHEN fnd_api.g_exc_unexpected_error

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;
1190:
1191: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');

Line 1193: --x_return_status := fnd_api.g_ret_sts_unexp_error;

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
1196: THEN
1197: ROLLBACK TO group_denormalize;

Line 1195: WHEN fnd_api.g_exc_error

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);
1199:

Line 1208: x_return_status := fnd_api.g_ret_sts_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:
1212:

Line 1275: l_return_status VARCHAR2(200) := fnd_api.g_ret_sts_success;

1271:
1272: l_date DATE;
1273: l_user_id NUMBER := 1;
1274: l_login_id NUMBER := 1;
1275: l_return_status VARCHAR2(200) := fnd_api.g_ret_sts_success;
1276: l_msg_count NUMBER;
1277: l_msg_data VARCHAR2(200);
1278: BEGIN
1279:

Line 1283: x_return_status := fnd_api.g_ret_sts_success;

1279:
1280: --Standard Start of API SAVEPOINT
1281: SAVEPOINT group_denormalize;
1282:
1283: x_return_status := fnd_api.g_ret_sts_success;
1284:
1285: --Standard Call to check API compatibility
1286: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1287: THEN

Line 1286: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

1282:
1283: x_return_status := fnd_api.g_ret_sts_success;
1284:
1285: --Standard Call to check API compatibility
1286: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1287: THEN
1288: RAISE FND_API.G_EXC_ERROR;
1289: END IF;
1290:

Line 1288: RAISE FND_API.G_EXC_ERROR;

1284:
1285: --Standard Call to check API compatibility
1286: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1287: THEN
1288: RAISE FND_API.G_EXC_ERROR;
1289: END IF;
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)

Line 1292: IF FND_API.To_boolean(P_INIT_MSG_LIST)

1288: RAISE FND_API.G_EXC_ERROR;
1289: END IF;
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:

Line 1299: IF FND_API.To_boolean(P_INIT_MSG_LIST)

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

Line 1320: IF(l_return_status <> fnd_api.g_ret_sts_success)

1316: X_MSG_DATA => l_msg_data);
1317:
1318:
1319:
1320: IF(l_return_status <> fnd_api.g_ret_sts_success)
1321: THEN
1322: x_return_status := fnd_api.g_ret_sts_error;
1323: RAISE fnd_api.g_exc_error;
1324: END IF;

Line 1322: x_return_status := fnd_api.g_ret_sts_error;

1318:
1319:
1320: IF(l_return_status <> fnd_api.g_ret_sts_success)
1321: THEN
1322: x_return_status := fnd_api.g_ret_sts_error;
1323: RAISE fnd_api.g_exc_error;
1324: END IF;
1325: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);
1326: end loop;

Line 1323: RAISE fnd_api.g_exc_error;

1319:
1320: IF(l_return_status <> fnd_api.g_ret_sts_success)
1321: THEN
1322: x_return_status := fnd_api.g_ret_sts_error;
1323: RAISE fnd_api.g_exc_error;
1324: END IF;
1325: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);
1326: end loop;
1327:

Line 1344: IF(l_return_status <> fnd_api.g_ret_sts_success)

1340: X_RETURN_STATUS => l_return_status,
1341: X_MSG_COUNT => l_msg_count,
1342: X_MSG_DATA => l_msg_data);
1343:
1344: IF(l_return_status <> fnd_api.g_ret_sts_success)
1345: THEN
1346: x_return_status := fnd_api.g_ret_sts_error;
1347: RAISE fnd_api.g_exc_error;
1348: END IF;

Line 1346: x_return_status := fnd_api.g_ret_sts_error;

1342: X_MSG_DATA => l_msg_data);
1343:
1344: IF(l_return_status <> fnd_api.g_ret_sts_success)
1345: THEN
1346: x_return_status := fnd_api.g_ret_sts_error;
1347: RAISE fnd_api.g_exc_error;
1348: END IF;
1349:
1350: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);

Line 1347: RAISE fnd_api.g_exc_error;

1343:
1344: IF(l_return_status <> fnd_api.g_ret_sts_success)
1345: THEN
1346: x_return_status := fnd_api.g_ret_sts_error;
1347: RAISE fnd_api.g_exc_error;
1348: END IF;
1349:
1350: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);
1351: end loop;

Line 1364: IF fnd_api.to_boolean (p_commit)

1360:
1361: --rebuild the group hiearchy again
1362: JTF_RS_GROUP_DENORM_PVT.Insert_Groups(1.0,NULL, NULL,p_group_id, x_return_status, x_msg_count, x_msg_data);
1363:
1364: IF fnd_api.to_boolean (p_commit)
1365: THEN
1366: COMMIT WORK;
1367: END IF;
1368:

Line 1392: x_return_status := fnd_api.g_ret_sts_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
1396: THEN

Line 1395: WHEN fnd_api.g_exc_unexpected_error

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;
1398: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
1399: --FND_MSG_PUB.add;

Line 1400: --x_return_status := fnd_api.g_ret_sts_unexp_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
1404: ROLLBACK TO group_denormalize;

Line 1402: WHEN fnd_api.g_exc_error

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);
1406:

Line 1415: x_return_status := fnd_api.g_ret_sts_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;
1419:

Line 1565: l_return_status VARCHAR2(200) := fnd_api.g_ret_sts_success;

1561: l_date Date;
1562: l_user_id Number;
1563: l_login_id Number;
1564:
1565: l_return_status VARCHAR2(200) := fnd_api.g_ret_sts_success;
1566: l_msg_count NUMBER;
1567: l_found BOOLEAN := FALSE;
1568:
1569: ---------------------------------------------------------

Line 1590: x_return_status := fnd_api.g_ret_sts_success;

1586:
1587: --Standard Start of API SAVEPOINT
1588: SAVEPOINT group_denormalize;
1589:
1590: x_return_status := fnd_api.g_ret_sts_success;
1591:
1592: --Standard Call to check API compatibility
1593: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1594: THEN

Line 1593: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

1589:
1590: x_return_status := fnd_api.g_ret_sts_success;
1591:
1592: --Standard Call to check API compatibility
1593: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1594: THEN
1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;
1597:

Line 1595: RAISE FND_API.G_EXC_ERROR;

1591:
1592: --Standard Call to check API compatibility
1593: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1594: THEN
1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;
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)

Line 1599: IF FND_API.To_boolean(P_INIT_MSG_LIST)

1595: RAISE FND_API.G_EXC_ERROR;
1596: END IF;
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:

Line 1721: x_return_status := fnd_api.g_ret_sts_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:
1725: end;

Line 1723: RAISE fnd_api.g_exc_unexpected_error;

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:
1727: end loop; -- end of child

Line 1749: x_return_status := fnd_api.g_ret_sts_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;
1753:

Line 1751: RAISE fnd_api.g_exc_unexpected_error;

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
1755: end loop; -- end of parent

Line 1781: IF(x_return_status <> fnd_api.g_ret_sts_success)

1777: x_return_status => x_return_status,
1778: x_msg_count => x_msg_count,
1779: x_msg_data => x_msg_data);
1780:
1781: IF(x_return_status <> fnd_api.g_ret_sts_success)
1782: THEN
1783: x_return_status := fnd_api.g_ret_sts_error;
1784: RAISE fnd_api.g_exc_error;
1785: END IF;

Line 1783: x_return_status := fnd_api.g_ret_sts_error;

1779: x_msg_data => x_msg_data);
1780:
1781: IF(x_return_status <> fnd_api.g_ret_sts_success)
1782: THEN
1783: x_return_status := fnd_api.g_ret_sts_error;
1784: RAISE fnd_api.g_exc_error;
1785: END IF;
1786:
1787: else

Line 1784: RAISE fnd_api.g_exc_error;

1780:
1781: IF(x_return_status <> fnd_api.g_ret_sts_success)
1782: THEN
1783: x_return_status := fnd_api.g_ret_sts_error;
1784: RAISE fnd_api.g_exc_error;
1785: END IF;
1786:
1787: else
1788: close check_parent_cur;

Line 1845: x_return_status := fnd_api.g_ret_sts_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
1849: THEN

Line 1848: WHEN fnd_api.g_exc_unexpected_error

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

Line 1853: WHEN fnd_api.g_exc_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);
1857:

Line 1866: x_return_status := fnd_api.g_ret_sts_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;
1870:

Line 1949: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

1945: l_user_id Number;
1946: l_login_id Number;
1947: l_start_date Date;
1948: l_end_date Date;
1949: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1950: l_msg_count number;
1951: l_msg_data varchar2(2000);
1952:
1953: l_start_date_active Date;

Line 2045: x_return_status := fnd_api.g_ret_sts_success;

2041:
2042: --Standard Start of API SAVEPOINT
2043: SAVEPOINT group_denormalize;
2044:
2045: x_return_status := fnd_api.g_ret_sts_success;
2046:
2047: --Standard Call to check API compatibility
2048: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
2049: THEN

Line 2048: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

2044:
2045: x_return_status := fnd_api.g_ret_sts_success;
2046:
2047: --Standard Call to check API compatibility
2048: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
2049: THEN
2050: RAISE FND_API.G_EXC_ERROR;
2051: END IF;
2052:

Line 2050: RAISE FND_API.G_EXC_ERROR;

2046:
2047: --Standard Call to check API compatibility
2048: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
2049: THEN
2050: RAISE FND_API.G_EXC_ERROR;
2051: END IF;
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)

Line 2054: IF FND_API.To_boolean(P_INIT_MSG_LIST)

2050: RAISE FND_API.G_EXC_ERROR;
2051: END IF;
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:

Line 2066: x_return_status := fnd_api.g_ret_sts_error;

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

Line 2069: RAISE fnd_api.g_exc_error;

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:
2073: l_date := sysdate;

Line 2194: IF(l_return_status <> fnd_api.g_ret_sts_success)

2190: X_RETURN_STATUS => l_return_status,
2191: X_MSG_COUNT => l_msg_count,
2192: X_MSG_DATA => l_msg_data ) ;
2193:
2194: IF(l_return_status <> fnd_api.g_ret_sts_success)
2195: THEN
2196: x_return_status := fnd_api.g_ret_sts_error;
2197: RAISE fnd_api.g_exc_error;
2198: END IF;

Line 2196: x_return_status := fnd_api.g_ret_sts_error;

2192: X_MSG_DATA => l_msg_data ) ;
2193:
2194: IF(l_return_status <> fnd_api.g_ret_sts_success)
2195: THEN
2196: x_return_status := fnd_api.g_ret_sts_error;
2197: RAISE fnd_api.g_exc_error;
2198: END IF;
2199: END IF;
2200: CLOSE c_dup;

Line 2197: RAISE fnd_api.g_exc_error;

2193:
2194: IF(l_return_status <> fnd_api.g_ret_sts_success)
2195: THEN
2196: x_return_status := fnd_api.g_ret_sts_error;
2197: RAISE fnd_api.g_exc_error;
2198: END IF;
2199: END IF;
2200: CLOSE c_dup;
2201: END IF; -- end of st dt check

Line 2215: IF fnd_api.to_boolean (p_commit)

2211: CLOSE c_parents;
2212:
2213:
2214:
2215: IF fnd_api.to_boolean (p_commit)
2216: THEN
2217: COMMIT WORK;
2218: END IF;
2219:

Line 2244: x_return_status := fnd_api.g_ret_sts_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
2248: THEN

Line 2247: WHEN fnd_api.g_exc_unexpected_error

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;
2250:
2251: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');

Line 2253: --x_return_status := fnd_api.g_ret_sts_unexp_error;

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
2256: THEN
2257: ROLLBACK TO group_denormalize;

Line 2255: WHEN fnd_api.g_exc_error

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);
2259:

Line 2268: x_return_status := fnd_api.g_ret_sts_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:
2272: --Start of procedure Body

Line 2342: l_return_status VARCHAR2(200) := fnd_api.g_ret_sts_success;

2338: l_date Date;
2339: l_user_id Number;
2340: l_login_id Number;
2341:
2342: l_return_status VARCHAR2(200) := fnd_api.g_ret_sts_success;
2343: l_msg_count NUMBER;
2344: l_msg_data VARCHAR2(200);
2345: BEGIN
2346:

Line 2350: x_return_status := fnd_api.g_ret_sts_success;

2346:
2347: --Standard Start of API SAVEPOINT
2348: SAVEPOINT group_denormalize;
2349:
2350: x_return_status := fnd_api.g_ret_sts_success;
2351:
2352: --Standard Call to check API compatibility
2353: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
2354: THEN

Line 2353: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

2349:
2350: x_return_status := fnd_api.g_ret_sts_success;
2351:
2352: --Standard Call to check API compatibility
2353: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
2354: THEN
2355: RAISE FND_API.G_EXC_ERROR;
2356: END IF;
2357:

Line 2355: RAISE FND_API.G_EXC_ERROR;

2351:
2352: --Standard Call to check API compatibility
2353: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
2354: THEN
2355: RAISE FND_API.G_EXC_ERROR;
2356: END IF;
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)

Line 2359: IF FND_API.To_boolean(P_INIT_MSG_LIST)

2355: RAISE FND_API.G_EXC_ERROR;
2356: END IF;
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:

Line 2366: IF FND_API.To_boolean(P_INIT_MSG_LIST)

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

Line 2407: IF(l_return_status <> fnd_api.g_ret_sts_success)

2403: P_DENORM_GRP_ID => r_group_denorm.denorm_grp_id,
2404: X_RETURN_STATUS => l_return_status,
2405: X_MSG_COUNT => l_msg_count,
2406: X_MSG_DATA => l_msg_data);
2407: IF(l_return_status <> fnd_api.g_ret_sts_success)
2408: THEN
2409: x_return_status := fnd_api.g_ret_sts_error;
2410: RAISE fnd_api.g_exc_error;
2411: END IF;

Line 2409: x_return_status := fnd_api.g_ret_sts_error;

2405: X_MSG_COUNT => l_msg_count,
2406: X_MSG_DATA => l_msg_data);
2407: IF(l_return_status <> fnd_api.g_ret_sts_success)
2408: THEN
2409: x_return_status := fnd_api.g_ret_sts_error;
2410: RAISE fnd_api.g_exc_error;
2411: END IF;
2412: IF(r_group_denorm.parent_group_id <> p_group_id)
2413: THEN

Line 2410: RAISE fnd_api.g_exc_error;

2406: X_MSG_DATA => l_msg_data);
2407: IF(l_return_status <> fnd_api.g_ret_sts_success)
2408: THEN
2409: x_return_status := fnd_api.g_ret_sts_error;
2410: RAISE fnd_api.g_exc_error;
2411: END IF;
2412: IF(r_group_denorm.parent_group_id <> p_group_id)
2413: THEN
2414:

Line 2435: IF(l_return_status <> fnd_api.g_ret_sts_success)

2431: P_DENORM_GRP_ID => r_child_denorm.denorm_grp_id,
2432: X_RETURN_STATUS => l_return_status,
2433: X_MSG_COUNT => l_msg_count,
2434: X_MSG_DATA => l_msg_data);
2435: IF(l_return_status <> fnd_api.g_ret_sts_success)
2436: THEN
2437: x_return_status := fnd_api.g_ret_sts_error;
2438: RAISE fnd_api.g_exc_error;
2439: END IF;

Line 2437: x_return_status := fnd_api.g_ret_sts_error;

2433: X_MSG_COUNT => l_msg_count,
2434: X_MSG_DATA => l_msg_data);
2435: IF(l_return_status <> fnd_api.g_ret_sts_success)
2436: THEN
2437: x_return_status := fnd_api.g_ret_sts_error;
2438: RAISE fnd_api.g_exc_error;
2439: END IF;
2440:
2441:

Line 2438: RAISE fnd_api.g_exc_error;

2434: X_MSG_DATA => l_msg_data);
2435: IF(l_return_status <> fnd_api.g_ret_sts_success)
2436: THEN
2437: x_return_status := fnd_api.g_ret_sts_error;
2438: RAISE fnd_api.g_exc_error;
2439: END IF;
2440:
2441:
2442:

Line 2463: IF fnd_api.to_boolean (p_commit)

2459: JTF_RS_GROUP_DENORM_PVT.Insert_Groups(1.0,NULL, NULL, p_group_id, x_return_status, x_msg_count, x_msg_data);
2460:
2461: --rebuild the hierarchy for reporting managers
2462:
2463: IF fnd_api.to_boolean (p_commit)
2464: THEN
2465: COMMIT WORK;
2466: END IF;
2467:

Line 2471: WHEN fnd_api.g_exc_unexpected_error

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
2473:
2474: ROLLBACK TO group_denormalize;
2475: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');

Line 2477: --x_return_status := fnd_api.g_ret_sts_unexp_error;

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
2481: ROLLBACK TO group_denormalize;

Line 2479: WHEN fnd_api.g_exc_error

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);
2483:

Line 2492: x_return_status := fnd_api.g_ret_sts_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;
2496: ------ CONNECT BY PRIOR - SECTION - Ends

Line 2530: AND least(nvl(end_date_active, to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR')),

2526: FROM jtf_rs_grp_relations rel
2527: WHERE relation_type = 'PARENT_GROUP'
2528: AND rel.group_id = p_group_id
2529: AND NVL(rel.delete_flag, 'N') <> 'Y'
2530: AND least(nvl(end_date_active, to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR')),
2531: nvl(p_least_end_date, to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR'))) >=
2532: trunc(greatest(start_date_active,
2533: nvl(p_greatest_start_date, start_date_active)));
2534: i INTEGER := 0;

Line 2531: nvl(p_least_end_date, to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR'))) >=

2527: WHERE relation_type = 'PARENT_GROUP'
2528: AND rel.group_id = p_group_id
2529: AND NVL(rel.delete_flag, 'N') <> 'Y'
2530: AND least(nvl(end_date_active, to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR')),
2531: nvl(p_least_end_date, to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR'))) >=
2532: trunc(greatest(start_date_active,
2533: nvl(p_greatest_start_date, start_date_active)));
2534: i INTEGER := 0;
2535: BEGIN

Line 2587: AND least(nvl(end_date_active, to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR')),

2583: FROM jtf_rs_grp_relations rel
2584: WHERE relation_type = 'PARENT_GROUP'
2585: AND rel.related_group_id = p_group_id
2586: AND NVL(rel.delete_flag, 'N') <> 'Y'
2587: AND least(nvl(end_date_active, to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR')),
2588: nvl(p_least_end_date, to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR'))) >=
2589:
2590: trunc(greatest(start_date_active,
2591: nvl(p_greatest_start_date, start_date_active)));

Line 2588: nvl(p_least_end_date, to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR'))) >=

2584: WHERE relation_type = 'PARENT_GROUP'
2585: AND rel.related_group_id = p_group_id
2586: AND NVL(rel.delete_flag, 'N') <> 'Y'
2587: AND least(nvl(end_date_active, to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR')),
2588: nvl(p_least_end_date, to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR'))) >=
2589:
2590: trunc(greatest(start_date_active,
2591: nvl(p_greatest_start_date, start_date_active)));
2592: i INTEGER := 0;

Line 2685: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

2681: l_user_id Number;
2682: l_login_id Number;
2683: l_start_date Date;
2684: l_end_date Date;
2685: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2686: l_msg_count number;
2687: l_msg_data varchar2(2000);
2688:
2689: l_start_date_active Date;

Line 2836: x_return_status := fnd_api.g_ret_sts_success;

2832:
2833: --Standard Start of API SAVEPOINT
2834: SAVEPOINT group_denormalize_no_con;
2835:
2836: x_return_status := fnd_api.g_ret_sts_success;
2837:
2838: --Standard Call to check API compatibility
2839: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
2840: THEN

Line 2839: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

2835:
2836: x_return_status := fnd_api.g_ret_sts_success;
2837:
2838: --Standard Call to check API compatibility
2839: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
2840: THEN
2841: RAISE FND_API.G_EXC_ERROR;
2842: END IF;
2843:

Line 2841: RAISE FND_API.G_EXC_ERROR;

2837:
2838: --Standard Call to check API compatibility
2839: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
2840: THEN
2841: RAISE FND_API.G_EXC_ERROR;
2842: END IF;
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)

Line 2845: IF FND_API.To_boolean(P_INIT_MSG_LIST)

2841: RAISE FND_API.G_EXC_ERROR;
2842: END IF;
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:

Line 2857: x_return_status := fnd_api.g_ret_sts_error;

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

Line 2860: RAISE fnd_api.g_exc_error;

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:
2864: l_date := sysdate;

Line 2999: IF(l_return_status <> fnd_api.g_ret_sts_success)

2995: X_RETURN_STATUS => l_return_status,
2996: X_MSG_COUNT => l_msg_count,
2997: X_MSG_DATA => l_msg_data ) ;
2998:
2999: IF(l_return_status <> fnd_api.g_ret_sts_success)
3000: THEN
3001: x_return_status := fnd_api.g_ret_sts_error;
3002: RAISE fnd_api.g_exc_error;
3003: END IF;

Line 3001: x_return_status := fnd_api.g_ret_sts_error;

2997: X_MSG_DATA => l_msg_data ) ;
2998:
2999: IF(l_return_status <> fnd_api.g_ret_sts_success)
3000: THEN
3001: x_return_status := fnd_api.g_ret_sts_error;
3002: RAISE fnd_api.g_exc_error;
3003: END IF;
3004:
3005: END IF; -- end of duplicate check

Line 3002: RAISE fnd_api.g_exc_error;

2998:
2999: IF(l_return_status <> fnd_api.g_ret_sts_success)
3000: THEN
3001: x_return_status := fnd_api.g_ret_sts_error;
3002: RAISE fnd_api.g_exc_error;
3003: END IF;
3004:
3005: END IF; -- end of duplicate check
3006: CLOSE c_dup;

Line 3126: IF(l_return_status <> fnd_api.g_ret_sts_success)

3122: X_RETURN_STATUS => l_return_status,
3123: X_MSG_COUNT => l_msg_count,
3124: X_MSG_DATA => l_msg_data ) ;
3125:
3126: IF(l_return_status <> fnd_api.g_ret_sts_success)
3127: THEN
3128: x_return_status := fnd_api.g_ret_sts_error;
3129: RAISE fnd_api.g_exc_error;
3130: END IF;

Line 3128: x_return_status := fnd_api.g_ret_sts_error;

3124: X_MSG_DATA => l_msg_data ) ;
3125:
3126: IF(l_return_status <> fnd_api.g_ret_sts_success)
3127: THEN
3128: x_return_status := fnd_api.g_ret_sts_error;
3129: RAISE fnd_api.g_exc_error;
3130: END IF;
3131: END IF;
3132: CLOSE c_dup;

Line 3129: RAISE fnd_api.g_exc_error;

3125:
3126: IF(l_return_status <> fnd_api.g_ret_sts_success)
3127: THEN
3128: x_return_status := fnd_api.g_ret_sts_error;
3129: RAISE fnd_api.g_exc_error;
3130: END IF;
3131: END IF;
3132: CLOSE c_dup;
3133:

Line 3239: IF(l_return_status <> fnd_api.g_ret_sts_success)

3235: X_RETURN_STATUS => l_return_status,
3236: X_MSG_COUNT => l_msg_count,
3237: X_MSG_DATA => l_msg_data ) ;
3238:
3239: IF(l_return_status <> fnd_api.g_ret_sts_success)
3240: THEN
3241: x_return_status := fnd_api.g_ret_sts_error;
3242: RAISE fnd_api.g_exc_error;
3243: END IF;

Line 3241: x_return_status := fnd_api.g_ret_sts_error;

3237: X_MSG_DATA => l_msg_data ) ;
3238:
3239: IF(l_return_status <> fnd_api.g_ret_sts_success)
3240: THEN
3241: x_return_status := fnd_api.g_ret_sts_error;
3242: RAISE fnd_api.g_exc_error;
3243: END IF;
3244:
3245: END IF; -- end of duplicate check

Line 3242: RAISE fnd_api.g_exc_error;

3238:
3239: IF(l_return_status <> fnd_api.g_ret_sts_success)
3240: THEN
3241: x_return_status := fnd_api.g_ret_sts_error;
3242: RAISE fnd_api.g_exc_error;
3243: END IF;
3244:
3245: END IF; -- end of duplicate check
3246: CLOSE c_dup;

Line 3266: IF fnd_api.to_boolean (p_commit)

3262: END IF; --end of group id check
3263:
3264: END LOOP;
3265:
3266: IF fnd_api.to_boolean (p_commit)
3267: THEN
3268: COMMIT WORK;
3269: END IF;
3270:

Line 3275: WHEN fnd_api.g_exc_unexpected_error

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
3277: ROLLBACK TO group_denormalize_no_con;
3278:
3279: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');

Line 3281: --x_return_status := fnd_api.g_ret_sts_unexp_error;

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
3284: THEN
3285: ROLLBACK TO group_denormalize_no_con;

Line 3283: WHEN fnd_api.g_exc_error

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);
3287:

Line 3296: x_return_status := fnd_api.g_ret_sts_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:
3300:

Line 3349: l_return_status VARCHAR2(200) := fnd_api.g_ret_sts_success;

3345:
3346: l_date DATE;
3347: l_user_id NUMBER := 1;
3348: l_login_id NUMBER := 1;
3349: l_return_status VARCHAR2(200) := fnd_api.g_ret_sts_success;
3350: l_msg_count NUMBER;
3351: l_msg_data VARCHAR2(200);
3352: i BINARY_INTEGER := 0;
3353: l_child_tab rel_table;

Line 3360: x_return_status := fnd_api.g_ret_sts_success;

3356:
3357: --Standard Start of API SAVEPOINT
3358: SAVEPOINT group_denormalize_no_con;
3359:
3360: x_return_status := fnd_api.g_ret_sts_success;
3361:
3362: --Standard Call to check API compatibility
3363: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
3364: THEN

Line 3363: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

3359:
3360: x_return_status := fnd_api.g_ret_sts_success;
3361:
3362: --Standard Call to check API compatibility
3363: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
3364: THEN
3365: RAISE FND_API.G_EXC_ERROR;
3366: END IF;
3367:

Line 3365: RAISE FND_API.G_EXC_ERROR;

3361:
3362: --Standard Call to check API compatibility
3363: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
3364: THEN
3365: RAISE FND_API.G_EXC_ERROR;
3366: END IF;
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)

Line 3369: IF FND_API.To_boolean(P_INIT_MSG_LIST)

3365: RAISE FND_API.G_EXC_ERROR;
3366: END IF;
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:

Line 3391: IF(l_return_status <> fnd_api.g_ret_sts_success)

3387: X_MSG_DATA => l_msg_data);
3388:
3389:
3390:
3391: IF(l_return_status <> fnd_api.g_ret_sts_success)
3392: THEN
3393: x_return_status := fnd_api.g_ret_sts_error;
3394: RAISE fnd_api.g_exc_error;
3395: END IF;

Line 3393: x_return_status := fnd_api.g_ret_sts_error;

3389:
3390:
3391: IF(l_return_status <> fnd_api.g_ret_sts_success)
3392: THEN
3393: x_return_status := fnd_api.g_ret_sts_error;
3394: RAISE fnd_api.g_exc_error;
3395: END IF;
3396: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);
3397: end loop;

Line 3394: RAISE fnd_api.g_exc_error;

3390:
3391: IF(l_return_status <> fnd_api.g_ret_sts_success)
3392: THEN
3393: x_return_status := fnd_api.g_ret_sts_error;
3394: RAISE fnd_api.g_exc_error;
3395: END IF;
3396: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);
3397: end loop;
3398:

Line 3417: IF(l_return_status <> fnd_api.g_ret_sts_success)

3413: X_RETURN_STATUS => l_return_status,
3414: X_MSG_COUNT => l_msg_count,
3415: X_MSG_DATA => l_msg_data);
3416:
3417: IF(l_return_status <> fnd_api.g_ret_sts_success)
3418: THEN
3419: x_return_status := fnd_api.g_ret_sts_error;
3420: RAISE fnd_api.g_exc_error;
3421: END IF;

Line 3419: x_return_status := fnd_api.g_ret_sts_error;

3415: X_MSG_DATA => l_msg_data);
3416:
3417: IF(l_return_status <> fnd_api.g_ret_sts_success)
3418: THEN
3419: x_return_status := fnd_api.g_ret_sts_error;
3420: RAISE fnd_api.g_exc_error;
3421: END IF;
3422:
3423: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);

Line 3420: RAISE fnd_api.g_exc_error;

3416:
3417: IF(l_return_status <> fnd_api.g_ret_sts_success)
3418: THEN
3419: x_return_status := fnd_api.g_ret_sts_error;
3420: RAISE fnd_api.g_exc_error;
3421: END IF;
3422:
3423: jtf_rs_groups_denorm_pkg.delete_row(r_group_denorm.DENORM_GRP_ID);
3424: end loop;

Line 3437: IF fnd_api.to_boolean (p_commit)

3433:
3434: --rebuild the group hiearchy again
3435: JTF_RS_GROUP_DENORM_PVT.insert_groups_no_con(1.0,NULL, NULL,p_group_id, x_return_status, x_msg_count, x_msg_data);
3436:
3437: IF fnd_api.to_boolean (p_commit)
3438: THEN
3439: COMMIT WORK;
3440: END IF;
3441:

Line 3445: WHEN fnd_api.g_exc_unexpected_error

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
3447: ROLLBACK TO group_denormalize_no_con;
3448: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');
3449: --FND_MSG_PUB.add;

Line 3450: --x_return_status := fnd_api.g_ret_sts_unexp_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
3454: ROLLBACK TO group_denormalize_no_con;

Line 3452: WHEN fnd_api.g_exc_error

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);
3456:

Line 3465: x_return_status := fnd_api.g_ret_sts_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;
3469:

Line 3586: l_return_status VARCHAR2(200) := fnd_api.g_ret_sts_success;

3582: l_date Date;
3583: l_user_id Number;
3584: l_login_id Number;
3585:
3586: l_return_status VARCHAR2(200) := fnd_api.g_ret_sts_success;
3587: l_msg_count NUMBER;
3588: l_found BOOLEAN := FALSE;
3589:
3590: begin

Line 3595: x_return_status := fnd_api.g_ret_sts_success;

3591:
3592: --Standard Start of API SAVEPOINT
3593: SAVEPOINT group_denormalize_no_con;
3594:
3595: x_return_status := fnd_api.g_ret_sts_success;
3596:
3597: --Standard Call to check API compatibility
3598: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
3599: THEN

Line 3598: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

3594:
3595: x_return_status := fnd_api.g_ret_sts_success;
3596:
3597: --Standard Call to check API compatibility
3598: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
3599: THEN
3600: RAISE FND_API.G_EXC_ERROR;
3601: END IF;
3602:

Line 3600: RAISE FND_API.G_EXC_ERROR;

3596:
3597: --Standard Call to check API compatibility
3598: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
3599: THEN
3600: RAISE FND_API.G_EXC_ERROR;
3601: END IF;
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)

Line 3604: IF FND_API.To_boolean(P_INIT_MSG_LIST)

3600: RAISE FND_API.G_EXC_ERROR;
3601: END IF;
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:

Line 3709: x_return_status := fnd_api.g_ret_sts_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:
3713: end;

Line 3711: RAISE fnd_api.g_exc_unexpected_error;

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:
3715: end loop; -- end of child

Line 3737: x_return_status := fnd_api.g_ret_sts_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;
3741:

Line 3739: RAISE fnd_api.g_exc_unexpected_error;

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
3743: end loop; -- end of parent

Line 3771: IF(x_return_status <> fnd_api.g_ret_sts_success)

3767: x_return_status => x_return_status,
3768: x_msg_count => x_msg_count,
3769: x_msg_data => x_msg_data);
3770:
3771: IF(x_return_status <> fnd_api.g_ret_sts_success)
3772: THEN
3773: x_return_status := fnd_api.g_ret_sts_error;
3774: RAISE fnd_api.g_exc_error;
3775: END IF;

Line 3773: x_return_status := fnd_api.g_ret_sts_error;

3769: x_msg_data => x_msg_data);
3770:
3771: IF(x_return_status <> fnd_api.g_ret_sts_success)
3772: THEN
3773: x_return_status := fnd_api.g_ret_sts_error;
3774: RAISE fnd_api.g_exc_error;
3775: END IF;
3776:
3777: else

Line 3774: RAISE fnd_api.g_exc_error;

3770:
3771: IF(x_return_status <> fnd_api.g_ret_sts_success)
3772: THEN
3773: x_return_status := fnd_api.g_ret_sts_error;
3774: RAISE fnd_api.g_exc_error;
3775: END IF;
3776:
3777: else
3778: close check_parent_cur;

Line 3797: WHEN fnd_api.g_exc_unexpected_error

3793: end if;
3794:
3795: END LOOP; -- end of child tab loop
3796: EXCEPTION
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);

Line 3802: WHEN fnd_api.g_exc_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);
3806:

Line 3815: x_return_status := fnd_api.g_ret_sts_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;
3819:

Line 3881: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

3877: l_user_id Number;
3878: l_login_id Number;
3879: l_start_date Date;
3880: l_end_date Date;
3881: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3882: l_msg_count number;
3883: l_msg_data varchar2(2000);
3884:
3885: l_start_date_active Date;

Line 3978: x_return_status := fnd_api.g_ret_sts_success;

3974:
3975: --Standard Start of API SAVEPOINT
3976: SAVEPOINT group_denormalize_no_con;
3977:
3978: x_return_status := fnd_api.g_ret_sts_success;
3979:
3980: --Standard Call to check API compatibility
3981: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
3982: THEN

Line 3981: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

3977:
3978: x_return_status := fnd_api.g_ret_sts_success;
3979:
3980: --Standard Call to check API compatibility
3981: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
3982: THEN
3983: RAISE FND_API.G_EXC_ERROR;
3984: END IF;
3985:

Line 3983: RAISE FND_API.G_EXC_ERROR;

3979:
3980: --Standard Call to check API compatibility
3981: IF NOT FND_API.Compatible_API_CALL(l_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
3982: THEN
3983: RAISE FND_API.G_EXC_ERROR;
3984: END IF;
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)

Line 3987: IF FND_API.To_boolean(P_INIT_MSG_LIST)

3983: RAISE FND_API.G_EXC_ERROR;
3984: END IF;
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:

Line 3999: x_return_status := fnd_api.g_ret_sts_error;

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

Line 4002: RAISE fnd_api.g_exc_error;

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:
4006: l_date := sysdate;

Line 4124: IF(l_return_status <> fnd_api.g_ret_sts_success)

4120: X_RETURN_STATUS => l_return_status,
4121: X_MSG_COUNT => l_msg_count,
4122: X_MSG_DATA => l_msg_data ) ;
4123:
4124: IF(l_return_status <> fnd_api.g_ret_sts_success)
4125: THEN
4126: x_return_status := fnd_api.g_ret_sts_error;
4127: RAISE fnd_api.g_exc_error;
4128: END IF;

Line 4126: x_return_status := fnd_api.g_ret_sts_error;

4122: X_MSG_DATA => l_msg_data ) ;
4123:
4124: IF(l_return_status <> fnd_api.g_ret_sts_success)
4125: THEN
4126: x_return_status := fnd_api.g_ret_sts_error;
4127: RAISE fnd_api.g_exc_error;
4128: END IF;
4129: END IF;
4130: CLOSE c_dup;

Line 4127: RAISE fnd_api.g_exc_error;

4123:
4124: IF(l_return_status <> fnd_api.g_ret_sts_success)
4125: THEN
4126: x_return_status := fnd_api.g_ret_sts_error;
4127: RAISE fnd_api.g_exc_error;
4128: END IF;
4129: END IF;
4130: CLOSE c_dup;
4131: END IF; -- end of st dt check

Line 4142: IF fnd_api.to_boolean (p_commit)

4138: END LOOP;
4139:
4140:
4141:
4142: IF fnd_api.to_boolean (p_commit)
4143: THEN
4144: COMMIT WORK;
4145: END IF;
4146:

Line 4151: WHEN fnd_api.g_exc_unexpected_error

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
4153: ROLLBACK TO group_denormalize_no_con;
4154:
4155: --fnd_message.set_name ('JTF', 'JTF_RS_GROUP_DENORM_ERR');

Line 4157: --x_return_status := fnd_api.g_ret_sts_unexp_error;

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
4160: THEN
4161: ROLLBACK TO group_denormalize_no_con;

Line 4159: WHEN fnd_api.g_exc_error

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);
4163:

Line 4172: x_return_status := fnd_api.g_ret_sts_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
4176: