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_GROUPS_PVT dependencies on FND_API

Line 90: x_return_status := fnd_api.g_ret_sts_success;

86: BEGIN
87:
88: SAVEPOINT create_resource_group_pvt;
89:
90: x_return_status := fnd_api.g_ret_sts_success;
91:
92: -- DBMS_OUTPUT.put_line(' Started Create Resource Group Pvt ');
93:
94:

Line 95: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

91:
92: -- DBMS_OUTPUT.put_line(' Started Create Resource Group Pvt ');
93:
94:
95: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
96:
97: RAISE fnd_api.g_exc_unexpected_error;
98:
99: END IF;

Line 97: RAISE fnd_api.g_exc_unexpected_error;

93:
94:
95: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
96:
97: RAISE fnd_api.g_exc_unexpected_error;
98:
99: END IF;
100:
101:

Line 102: IF fnd_api.to_boolean(p_init_msg_list) THEN

98:
99: END IF;
100:
101:
102: IF fnd_api.to_boolean(p_init_msg_list) THEN
103:
104: fnd_msg_pub.initialize;
105:
106: END IF;

Line 136: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

132: p_end_date_active => l_end_date_active,
133: p_accounting_code => l_accounting_code,
134: x_return_status => x_return_status);
135:
136: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
137:
138: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
139: fnd_msg_pub.add;
140: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

Line 140: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

136: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
137:
138: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
139: fnd_msg_pub.add;
140: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
141: RAISE FND_API.G_EXC_ERROR;
142: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;

Line 141: RAISE FND_API.G_EXC_ERROR;

137:
138: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
139: fnd_msg_pub.add;
140: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
141: RAISE FND_API.G_EXC_ERROR;
142: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145:

Line 142: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

138: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
139: fnd_msg_pub.add;
140: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
141: RAISE FND_API.G_EXC_ERROR;
142: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145:
146: END IF;

Line 143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

139: fnd_msg_pub.add;
140: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
141: RAISE FND_API.G_EXC_ERROR;
142: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145:
146: END IF;
147:

Line 177: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

173: p_end_date_active => l_end_date_active,
174: p_accounting_code => l_accounting_code,
175: x_return_status => x_return_status);
176:
177: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
178:
179: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
180:
181: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

Line 184: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

180:
181: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
182: fnd_msg_pub.add;
183:
184: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;

Line 185: RAISE FND_API.G_EXC_ERROR;

181: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
182: fnd_msg_pub.add;
183:
184: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;
189:

Line 186: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

182: fnd_msg_pub.add;
183:
184: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;
189:
190: END IF;

Line 187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

183:
184: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;
189:
190: END IF;
191:

Line 221: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

217: p_end_date_active => l_end_date_active,
218: p_accounting_code => l_accounting_code,
219: x_return_status => x_return_status);
220:
221: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
222:
223: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
224:
225:

Line 229: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

225:
226: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
227: fnd_msg_pub.add;
228:
229: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
230: RAISE FND_API.G_EXC_ERROR;
231: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;

Line 230: RAISE FND_API.G_EXC_ERROR;

226: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
227: fnd_msg_pub.add;
228:
229: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
230: RAISE FND_API.G_EXC_ERROR;
231: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234:

Line 231: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

227: fnd_msg_pub.add;
228:
229: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
230: RAISE FND_API.G_EXC_ERROR;
231: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234:
235: END IF;

Line 232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

228:
229: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
230: RAISE FND_API.G_EXC_ERROR;
231: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234:
235: END IF;
236:

Line 249: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

245: p_end_date_active => l_end_date_active,
246: x_return_status => x_return_status
247: );
248:
249: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
250:
251: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 251: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

247: );
248:
249: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
250:
251: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;

Line 252: RAISE FND_API.G_EXC_ERROR;

248:
249: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
250:
251: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256:

Line 253: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

249: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
250:
251: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256:
257: END IF;

Line 254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

250:
251: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
252: RAISE FND_API.G_EXC_ERROR;
253: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256:
257: END IF;
258:

Line 269: RAISE fnd_api.g_exc_error;

265:
266: IF l_exclusive_flag <> 'Y' AND l_exclusive_flag <> 'N' THEN
267: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
268: fnd_msg_pub.add;
269: RAISE fnd_api.g_exc_error;
270: END IF;
271:
272: /* This portion of the code was modified to accomodate the calls to Migration API */
273: /* Check if the Global Variable Flag for Group ID is Y or N */

Line 309: P_INIT_MSG_LIST => fnd_api.g_false,

305: /* Make a call to the group Audit API */
306:
307: jtf_rs_groups_aud_pvt.insert_group
308: (P_API_VERSION => 1,
309: P_INIT_MSG_LIST => fnd_api.g_false,
310: P_COMMIT => fnd_api.g_false,
311: P_GROUP_ID => l_group_id,
312: P_GROUP_NUMBER => l_group_number,
313: P_GROUP_NAME => l_group_name,

Line 310: P_COMMIT => fnd_api.g_false,

306:
307: jtf_rs_groups_aud_pvt.insert_group
308: (P_API_VERSION => 1,
309: P_INIT_MSG_LIST => fnd_api.g_false,
310: P_COMMIT => fnd_api.g_false,
311: P_GROUP_ID => l_group_id,
312: P_GROUP_NUMBER => l_group_number,
313: P_GROUP_NAME => l_group_name,
314: P_GROUP_DESC => l_group_desc,

Line 327: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

323: X_MSG_DATA => x_msg_data,
324: P_TIME_ZONE => l_time_zone
325: );
326:
327: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
328:
329: -- dbms_output.put_line('Failed status from call to audit procedure');
330:
331: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

Line 331: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

327: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
328:
329: -- dbms_output.put_line('Failed status from call to audit procedure');
330:
331: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
332: RAISE FND_API.G_EXC_ERROR;
333: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;

Line 332: RAISE FND_API.G_EXC_ERROR;

328:
329: -- dbms_output.put_line('Failed status from call to audit procedure');
330:
331: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
332: RAISE FND_API.G_EXC_ERROR;
333: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336:

Line 333: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

329: -- dbms_output.put_line('Failed status from call to audit procedure');
330:
331: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
332: RAISE FND_API.G_EXC_ERROR;
333: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336:
337:

Line 334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

330:
331: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
332: RAISE FND_API.G_EXC_ERROR;
333: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336:
337:
338: END IF;

Line 400: RAISE fnd_api.g_exc_error;

396:
397: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
398: fnd_msg_pub.add;
399:
400: RAISE fnd_api.g_exc_error;
401:
402:
403: ELSE
404:

Line 427: P_INIT_MSG_LIST => fnd_api.g_false,

423: /* Make a call to the Group Denorm API */
424:
425: jtf_rs_group_denorm_pvt.create_res_groups
426: (P_API_VERSION => 1,
427: P_INIT_MSG_LIST => fnd_api.g_false,
428: P_COMMIT => fnd_api.g_false,
429: P_GROUP_ID => l_group_id,
430: X_RETURN_STATUS => x_return_status,
431: X_MSG_COUNT => x_msg_count,

Line 428: P_COMMIT => fnd_api.g_false,

424:
425: jtf_rs_group_denorm_pvt.create_res_groups
426: (P_API_VERSION => 1,
427: P_INIT_MSG_LIST => fnd_api.g_false,
428: P_COMMIT => fnd_api.g_false,
429: P_GROUP_ID => l_group_id,
430: X_RETURN_STATUS => x_return_status,
431: X_MSG_COUNT => x_msg_count,
432: X_MSG_DATA => x_msg_data

Line 435: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

431: X_MSG_COUNT => x_msg_count,
432: X_MSG_DATA => x_msg_data
433: );
434:
435: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
436:
437: -- dbms_output.put_line('Failed status from call to Group Denorm procedure');
438:
439: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

Line 439: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

435: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
436:
437: -- dbms_output.put_line('Failed status from call to Group Denorm procedure');
438:
439: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
440: RAISE FND_API.G_EXC_ERROR;
441: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;

Line 440: RAISE FND_API.G_EXC_ERROR;

436:
437: -- dbms_output.put_line('Failed status from call to Group Denorm procedure');
438:
439: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
440: RAISE FND_API.G_EXC_ERROR;
441: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:

Line 441: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

437: -- dbms_output.put_line('Failed status from call to Group Denorm procedure');
438:
439: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
440: RAISE FND_API.G_EXC_ERROR;
441: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:
445: END IF;

Line 442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

438:
439: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
440: RAISE FND_API.G_EXC_ERROR;
441: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:
445: END IF;
446:

Line 471: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

467: p_end_date_active => l_end_date_active,
468: p_accounting_code => l_accounting_code,
469: x_return_status => x_return_status);
470:
471: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
472:
473: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
474:
475:

Line 479: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

475:
476: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
477: fnd_msg_pub.add;
478:
479: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
480: RAISE FND_API.G_EXC_ERROR;
481: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;

Line 480: RAISE FND_API.G_EXC_ERROR;

476: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
477: fnd_msg_pub.add;
478:
479: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
480: RAISE FND_API.G_EXC_ERROR;
481: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;
484:

Line 481: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

477: fnd_msg_pub.add;
478:
479: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
480: RAISE FND_API.G_EXC_ERROR;
481: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;
484:
485: END IF;

Line 482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

478:
479: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
480: RAISE FND_API.G_EXC_ERROR;
481: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;
484:
485: END IF;
486:

Line 510: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

506: p_end_date_active => l_end_date_active,
507: p_accounting_code => l_accounting_code,
508: x_return_status => x_return_status);
509:
510: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
511:
512: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
513:
514:

Line 518: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

514:
515: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
516: fnd_msg_pub.add;
517:
518: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
519: RAISE FND_API.G_EXC_ERROR;
520: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: END IF;

Line 519: RAISE FND_API.G_EXC_ERROR;

515: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
516: fnd_msg_pub.add;
517:
518: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
519: RAISE FND_API.G_EXC_ERROR;
520: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: END IF;
523:

Line 520: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

516: fnd_msg_pub.add;
517:
518: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
519: RAISE FND_API.G_EXC_ERROR;
520: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: END IF;
523:
524:

Line 521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

517:
518: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
519: RAISE FND_API.G_EXC_ERROR;
520: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: END IF;
523:
524:
525: END IF;

Line 550: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

546: p_end_date_active => l_end_date_active,
547: p_accounting_code => l_accounting_code,
548: x_return_status => x_return_status);
549:
550: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
551:
552: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
553:
554:

Line 558: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

554:
555: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
556: fnd_msg_pub.add;
557:
558: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
559: RAISE FND_API.G_EXC_ERROR;
560: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
562: END IF;

Line 559: RAISE FND_API.G_EXC_ERROR;

555: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
556: fnd_msg_pub.add;
557:
558: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
559: RAISE FND_API.G_EXC_ERROR;
560: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
562: END IF;
563:

Line 560: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

556: fnd_msg_pub.add;
557:
558: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
559: RAISE FND_API.G_EXC_ERROR;
560: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
562: END IF;
563:
564: END IF;

Line 561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

557:
558: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
559: RAISE FND_API.G_EXC_ERROR;
560: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
562: END IF;
563:
564: END IF;
565:

Line 603: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

599: p_bind_data_id => l_bind_data_id,
600: x_return_code => x_return_status);
601:
602:
603: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
604:
605: -- dbms_output.put_line('Returned Error status from the Message Generation API');
606:
607:

Line 611: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

607:
608: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
609: fnd_msg_pub.add;
610:
611: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;

Line 612: RAISE FND_API.G_EXC_ERROR;

608: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
609: fnd_msg_pub.add;
610:
611: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616:

Line 613: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

609: fnd_msg_pub.add;
610:
611: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616:
617: END IF;

Line 614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

610:
611: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616:
617: END IF;
618:

Line 642: IF fnd_api.to_boolean(p_commit) THEN

638: NULL;
639: END;
640:
641:
642: IF fnd_api.to_boolean(p_commit) THEN
643:
644: COMMIT WORK;
645:
646: END IF;

Line 653: WHEN fnd_api.g_exc_error THEN

649:
650: EXCEPTION
651:
652:
653: WHEN fnd_api.g_exc_error THEN
654: ROLLBACK TO create_resource_group_pvt;
655: x_return_status := fnd_api.g_ret_sts_error;
656: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
657: p_data => x_msg_data);

Line 655: x_return_status := fnd_api.g_ret_sts_error;

651:
652:
653: WHEN fnd_api.g_exc_error THEN
654: ROLLBACK TO create_resource_group_pvt;
655: x_return_status := fnd_api.g_ret_sts_error;
656: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
657: p_data => x_msg_data);
658: WHEN fnd_api.g_exc_unexpected_error THEN
659: ROLLBACK TO create_resource_group_pvt;

Line 658: WHEN fnd_api.g_exc_unexpected_error THEN

654: ROLLBACK TO create_resource_group_pvt;
655: x_return_status := fnd_api.g_ret_sts_error;
656: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
657: p_data => x_msg_data);
658: WHEN fnd_api.g_exc_unexpected_error THEN
659: ROLLBACK TO create_resource_group_pvt;
660: x_return_status := fnd_api.g_ret_sts_unexp_error;
661: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
662: p_data => x_msg_data);

Line 660: x_return_status := fnd_api.g_ret_sts_unexp_error;

656: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
657: p_data => x_msg_data);
658: WHEN fnd_api.g_exc_unexpected_error THEN
659: ROLLBACK TO create_resource_group_pvt;
660: x_return_status := fnd_api.g_ret_sts_unexp_error;
661: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
662: p_data => x_msg_data);
663: WHEN OTHERS THEN
664: ROLLBACK TO create_resource_group_pvt;

Line 670: x_return_status := fnd_api.g_ret_sts_unexp_error;

666: fnd_message.set_token('P_SQLCODE',SQLCODE);
667: fnd_message.set_token('P_SQLERRM',SQLERRM);
668: fnd_message.set_token('P_API_NAME', l_api_name);
669: FND_MSG_PUB.add;
670: x_return_status := fnd_api.g_ret_sts_unexp_error;
671: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
672: p_data => x_msg_data);
673:
674: END create_resource_group;

Line 815: DECODE(p_group_name, fnd_api.g_miss_char, group_name, p_group_name) group_name,

811: l_group_id IN NUMBER )
812: IS
813: SELECT
814: group_number,
815: DECODE(p_group_name, fnd_api.g_miss_char, group_name, p_group_name) group_name,
816: DECODE(p_group_desc, fnd_api.g_miss_char, group_desc, p_group_desc) group_desc,
817: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
818: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
819: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,

Line 816: DECODE(p_group_desc, fnd_api.g_miss_char, group_desc, p_group_desc) group_desc,

812: IS
813: SELECT
814: group_number,
815: DECODE(p_group_name, fnd_api.g_miss_char, group_name, p_group_name) group_name,
816: DECODE(p_group_desc, fnd_api.g_miss_char, group_desc, p_group_desc) group_desc,
817: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
818: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
819: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
820: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,

Line 817: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,

813: SELECT
814: group_number,
815: DECODE(p_group_name, fnd_api.g_miss_char, group_name, p_group_name) group_name,
816: DECODE(p_group_desc, fnd_api.g_miss_char, group_desc, p_group_desc) group_desc,
817: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
818: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
819: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
820: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
821: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,

Line 818: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,

814: group_number,
815: DECODE(p_group_name, fnd_api.g_miss_char, group_name, p_group_name) group_name,
816: DECODE(p_group_desc, fnd_api.g_miss_char, group_desc, p_group_desc) group_desc,
817: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
818: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
819: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
820: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
821: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
822: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,

Line 819: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,

815: DECODE(p_group_name, fnd_api.g_miss_char, group_name, p_group_name) group_name,
816: DECODE(p_group_desc, fnd_api.g_miss_char, group_desc, p_group_desc) group_desc,
817: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
818: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
819: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
820: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
821: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
822: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
823: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,

Line 820: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,

816: DECODE(p_group_desc, fnd_api.g_miss_char, group_desc, p_group_desc) group_desc,
817: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
818: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
819: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
820: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
821: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
822: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
823: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
824: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,

Line 821: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,

817: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
818: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
819: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
820: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
821: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
822: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
823: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
824: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
825: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,

Line 822: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,

818: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
819: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
820: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
821: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
822: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
823: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
824: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
825: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
826: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,

Line 823: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,

819: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
820: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
821: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
822: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
823: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
824: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
825: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
826: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
827: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,

Line 824: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,

820: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
821: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
822: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
823: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
824: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
825: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
826: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
827: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
828: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,

Line 825: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,

821: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
822: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
823: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
824: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
825: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
826: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
827: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
828: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
829: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,

Line 826: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,

822: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
823: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
824: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
825: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
826: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
827: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
828: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
829: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
830: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,

Line 827: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,

823: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
824: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
825: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
826: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
827: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
828: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
829: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
830: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
831: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,

Line 828: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,

824: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
825: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
826: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
827: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
828: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
829: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
830: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
831: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
832: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,

Line 829: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,

825: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
826: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
827: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
828: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
829: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
830: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
831: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
832: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
833: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,

Line 830: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,

826: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
827: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
828: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
829: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
830: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
831: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
832: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
833: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
834: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,

Line 831: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,

827: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
828: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
829: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
830: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
831: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
832: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
833: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
834: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
835: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,

Line 832: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,

828: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
829: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
830: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
831: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
832: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
833: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
834: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
835: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
836: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,

Line 833: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,

829: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
830: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
831: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
832: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
833: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
834: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
835: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
836: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
837: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category,

Line 834: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,

830: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
831: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
832: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
833: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
834: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
835: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
836: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
837: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category,
838: DECODE(p_time_zone,fnd_api.g_miss_num,time_zone,p_time_zone) time_zone

Line 835: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,

831: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
832: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
833: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
834: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
835: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
836: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
837: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category,
838: DECODE(p_time_zone,fnd_api.g_miss_num,time_zone,p_time_zone) time_zone
839: FROM jtf_rs_groups_vl

Line 836: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,

832: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
833: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
834: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
835: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
836: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
837: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category,
838: DECODE(p_time_zone,fnd_api.g_miss_num,time_zone,p_time_zone) time_zone
839: FROM jtf_rs_groups_vl
840: WHERE group_id = l_group_id;

Line 837: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category,

833: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
834: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
835: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
836: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
837: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category,
838: DECODE(p_time_zone,fnd_api.g_miss_num,time_zone,p_time_zone) time_zone
839: FROM jtf_rs_groups_vl
840: WHERE group_id = l_group_id;
841:

Line 838: DECODE(p_time_zone,fnd_api.g_miss_num,time_zone,p_time_zone) time_zone

834: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
835: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
836: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
837: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category,
838: DECODE(p_time_zone,fnd_api.g_miss_num,time_zone,p_time_zone) time_zone
839: FROM jtf_rs_groups_vl
840: WHERE group_id = l_group_id;
841:
842: group_rec c_group_update%ROWTYPE;

Line 1001: x_return_status := fnd_api.g_ret_sts_success;

997:
998:
999: SAVEPOINT update_resource_group_pvt;
1000:
1001: x_return_status := fnd_api.g_ret_sts_success;
1002:
1003: -- DBMS_OUTPUT.put_line(' Started Update Resource Group Pvt ');
1004:
1005:

Line 1006: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

1002:
1003: -- DBMS_OUTPUT.put_line(' Started Update Resource Group Pvt ');
1004:
1005:
1006: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1007:
1008: RAISE fnd_api.g_exc_unexpected_error;
1009:
1010: END IF;

Line 1008: RAISE fnd_api.g_exc_unexpected_error;

1004:
1005:
1006: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1007:
1008: RAISE fnd_api.g_exc_unexpected_error;
1009:
1010: END IF;
1011:
1012:

Line 1013: IF fnd_api.to_boolean(p_init_msg_list) THEN

1009:
1010: END IF;
1011:
1012:
1013: IF fnd_api.to_boolean(p_init_msg_list) THEN
1014:
1015: fnd_msg_pub.initialize;
1016:
1017: END IF;

Line 1047: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1043: p_end_date_active => l_end_date_active,
1044: p_accounting_code => l_accounting_code,
1045: x_return_status => x_return_status);
1046:
1047: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1048:
1049: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
1050:
1051: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

Line 1054: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1050:
1051: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1052: fnd_msg_pub.add;
1053:
1054: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1055: RAISE FND_API.G_EXC_ERROR;
1056: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;

Line 1055: RAISE FND_API.G_EXC_ERROR;

1051: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1052: fnd_msg_pub.add;
1053:
1054: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1055: RAISE FND_API.G_EXC_ERROR;
1056: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;
1059:

Line 1056: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1052: fnd_msg_pub.add;
1053:
1054: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1055: RAISE FND_API.G_EXC_ERROR;
1056: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;
1059:
1060:

Line 1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1053:
1054: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1055: RAISE FND_API.G_EXC_ERROR;
1056: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;
1059:
1060:
1061: END IF;

Line 1093: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1089: p_end_date_active => l_end_date_active,
1090: p_accounting_code => l_accounting_code,
1091: x_return_status => x_return_status);
1092:
1093: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1094:
1095: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
1096:
1097:

Line 1101: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1097:
1098: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1099: fnd_msg_pub.add;
1100:
1101: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;

Line 1102: RAISE FND_API.G_EXC_ERROR;

1098: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1099: fnd_msg_pub.add;
1100:
1101: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;
1106:

Line 1103: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1099: fnd_msg_pub.add;
1100:
1101: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;
1106:
1107:

Line 1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1100:
1101: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;
1106:
1107:
1108: END IF;

Line 1140: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1136: p_end_date_active => l_end_date_active,
1137: p_accounting_code => l_accounting_code,
1138: x_return_status => x_return_status);
1139:
1140: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1141:
1142:
1143: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1144: fnd_msg_pub.add;

Line 1146: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1142:
1143: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1144: fnd_msg_pub.add;
1145:
1146: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1147: RAISE FND_API.G_EXC_ERROR;
1148: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END IF;

Line 1147: RAISE FND_API.G_EXC_ERROR;

1143: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1144: fnd_msg_pub.add;
1145:
1146: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1147: RAISE FND_API.G_EXC_ERROR;
1148: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END IF;
1151:

Line 1148: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1144: fnd_msg_pub.add;
1145:
1146: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1147: RAISE FND_API.G_EXC_ERROR;
1148: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END IF;
1151:
1152: END IF;

Line 1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1145:
1146: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1147: RAISE FND_API.G_EXC_ERROR;
1148: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END IF;
1151:
1152: END IF;
1153:

Line 1176: RAISE fnd_api.g_exc_error;

1172: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP');
1173: fnd_message.set_token('P_GROUP_ID', l_group_id);
1174: fnd_msg_pub.add;
1175:
1176: RAISE fnd_api.g_exc_error;
1177:
1178: END IF;
1179:
1180:

Line 1188: IF group_rec.exclusive_flag <> 'Y' AND group_rec.exclusive_flag <> 'N' AND group_rec.exclusive_flag <> fnd_api.g_miss_char THEN

1184: Below block to validate Exclusive Flag
1185: value before creating Resource Group.
1186: */
1187:
1188: IF group_rec.exclusive_flag <> 'Y' AND group_rec.exclusive_flag <> 'N' AND group_rec.exclusive_flag <> fnd_api.g_miss_char THEN
1189: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
1190: fnd_msg_pub.add;
1191: RAISE fnd_api.g_exc_error;
1192: END IF;

Line 1191: RAISE fnd_api.g_exc_error;

1187:
1188: IF group_rec.exclusive_flag <> 'Y' AND group_rec.exclusive_flag <> 'N' AND group_rec.exclusive_flag <> fnd_api.g_miss_char THEN
1189: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
1190: fnd_msg_pub.add;
1191: RAISE fnd_api.g_exc_error;
1192: END IF;
1193:
1194: /* Validate that the Group Name is specified */
1195:

Line 1203: RAISE fnd_api.g_exc_error;

1199:
1200: fnd_message.set_name('JTF', 'JTF_RS_GROUP_NAME_NULL');
1201: fnd_msg_pub.add;
1202:
1203: RAISE fnd_api.g_exc_error;
1204:
1205: END IF;
1206:
1207:

Line 1220: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1216: p_end_date_active => l_end_date_active,
1217: x_return_status => x_return_status
1218: );
1219:
1220: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1221:
1222: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1223: RAISE FND_API.G_EXC_ERROR;
1224: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1222: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1218: );
1219:
1220: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1221:
1222: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1223: RAISE FND_API.G_EXC_ERROR;
1224: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1226: END IF;

Line 1223: RAISE FND_API.G_EXC_ERROR;

1219:
1220: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1221:
1222: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1223: RAISE FND_API.G_EXC_ERROR;
1224: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1226: END IF;
1227:

Line 1224: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1220: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1221:
1222: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1223: RAISE FND_API.G_EXC_ERROR;
1224: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1226: END IF;
1227:
1228:

Line 1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1221:
1222: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1223: RAISE FND_API.G_EXC_ERROR;
1224: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1226: END IF;
1227:
1228:
1229: END IF;

Line 1251: RAISE fnd_api.g_exc_error;

1247:
1248: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_START_DATE');
1249: fnd_msg_pub.add;
1250:
1251: RAISE fnd_api.g_exc_error;
1252:
1253:
1254: END IF;
1255:

Line 1261: RAISE fnd_api.g_exc_error;

1257:
1258: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_END_DATE');
1259: fnd_msg_pub.add;
1260:
1261: RAISE fnd_api.g_exc_error;
1262:
1263: END IF;
1264:
1265: END IF;

Line 1293: RAISE fnd_api.g_exc_error;

1289:
1290: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_START_DATE');
1291: fnd_msg_pub.add;
1292:
1293: RAISE fnd_api.g_exc_error;
1294:
1295:
1296: END IF;
1297:

Line 1303: RAISE fnd_api.g_exc_error;

1299:
1300: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_END_DATE');
1301: fnd_msg_pub.add;
1302:
1303: RAISE fnd_api.g_exc_error;
1304:
1305:
1306: END IF;
1307:

Line 1339: RAISE fnd_api.g_exc_error;

1335:
1336: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_START_DATE');
1337: fnd_msg_pub.add;
1338:
1339: RAISE fnd_api.g_exc_error;
1340:
1341: END IF;
1342:
1343: IF ( l_max_end_date > l_end_date_active AND l_end_date_active IS NOT NULL ) THEN

Line 1348: RAISE fnd_api.g_exc_error;

1344:
1345: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_END_DATE');
1346: fnd_msg_pub.add;
1347:
1348: RAISE fnd_api.g_exc_error;
1349:
1350:
1351: END IF;
1352:

Line 1381: RAISE fnd_api.g_exc_error;

1377:
1378: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_START_DATE');
1379: fnd_msg_pub.add;
1380:
1381: RAISE fnd_api.g_exc_error;
1382:
1383:
1384: END IF;
1385:

Line 1391: RAISE fnd_api.g_exc_error;

1387:
1388: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_END_DATE');
1389: fnd_msg_pub.add;
1390:
1391: RAISE fnd_api.g_exc_error;
1392:
1393:
1394: END IF;
1395:

Line 1427: RAISE fnd_api.g_exc_error;

1423:
1424: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_START_DATE');
1425: fnd_msg_pub.add;
1426:
1427: RAISE fnd_api.g_exc_error;
1428:
1429:
1430: END IF;
1431:

Line 1437: RAISE fnd_api.g_exc_error;

1433:
1434: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_END_DATE');
1435: fnd_msg_pub.add;
1436:
1437: RAISE fnd_api.g_exc_error;
1438:
1439:
1440: END IF;
1441:

Line 1470: RAISE fnd_api.g_exc_error;

1466:
1467: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_START_DATE');
1468: fnd_msg_pub.add;
1469:
1470: RAISE fnd_api.g_exc_error;
1471:
1472: END IF;
1473:
1474: IF l_end_date_active IS NOT NULL THEN

Line 1479: RAISE fnd_api.g_exc_error;

1475:
1476: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_END_DATE');
1477: fnd_msg_pub.add;
1478:
1479: RAISE fnd_api.g_exc_error;
1480:
1481: END IF;
1482:
1483: END IF;

Line 1514: RAISE fnd_api.g_exc_error;

1510:
1511: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_START_DATE');
1512: fnd_msg_pub.add;
1513:
1514: RAISE fnd_api.g_exc_error;
1515:
1516: END IF;
1517:
1518: IF ( l_max_end_date > l_end_date_active AND l_end_date_active IS NOT NULL ) THEN

Line 1523: RAISE fnd_api.g_exc_error;

1519:
1520: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_END_DATE');
1521: fnd_msg_pub.add;
1522:
1523: RAISE fnd_api.g_exc_error;
1524:
1525: END IF;
1526:
1527: END IF;

Line 1555: RAISE fnd_api.g_exc_error;

1551:
1552: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_START_DATE');
1553: fnd_msg_pub.add;
1554:
1555: RAISE fnd_api.g_exc_error;
1556:
1557: END IF;
1558:
1559: IF l_end_date_active IS NOT NULL THEN

Line 1564: RAISE fnd_api.g_exc_error;

1560:
1561: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_END_DATE');
1562: fnd_msg_pub.add;
1563:
1564: RAISE fnd_api.g_exc_error;
1565:
1566: END IF;
1567:
1568: END IF;

Line 1581: IF p_time_zone <> fnd_api.g_miss_num AND p_time_zone IS NOT NULL THEN

1577: END IF;
1578:
1579: /* Validate the Time Zone */
1580:
1581: IF p_time_zone <> fnd_api.g_miss_num AND p_time_zone IS NOT NULL THEN
1582:
1583: jtf_resource_utl.validate_time_zone(
1584: p_time_zone_id => p_time_zone,
1585: x_return_status => x_return_status

Line 1588: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1584: p_time_zone_id => p_time_zone,
1585: x_return_status => x_return_status
1586: );
1587:
1588: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1589: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1590: RAISE FND_API.G_EXC_ERROR;
1591: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1589: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1585: x_return_status => x_return_status
1586: );
1587:
1588: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1589: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1590: RAISE FND_API.G_EXC_ERROR;
1591: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1593: END IF;

Line 1590: RAISE FND_API.G_EXC_ERROR;

1586: );
1587:
1588: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1589: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1590: RAISE FND_API.G_EXC_ERROR;
1591: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1593: END IF;
1594: END IF;

Line 1591: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1587:
1588: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1589: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1590: RAISE FND_API.G_EXC_ERROR;
1591: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1593: END IF;
1594: END IF;
1595: END IF;

Line 1592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1588: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1589: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1590: RAISE FND_API.G_EXC_ERROR;
1591: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1593: END IF;
1594: END IF;
1595: END IF;
1596:

Line 1625: RAISE fnd_api.g_exc_error;

1621:
1622: fnd_message.set_name('JTF', 'JTF_RS_EXCLUSIVE_GROUP');
1623: fnd_msg_pub.add;
1624:
1625: RAISE fnd_api.g_exc_error;
1626:
1627: END IF;
1628: END IF;
1629:

Line 1660: RAISE fnd_api.g_exc_error;

1656:
1657: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1658: fnd_msg_pub.add;
1659:
1660: RAISE fnd_api.g_exc_error;
1661:
1662:
1663: END;
1664:

Line 1670: P_INIT_MSG_LIST => fnd_api.g_false,

1666: /* Make a call to the group Audit API */
1667:
1668: jtf_rs_groups_aud_pvt.update_group
1669: (P_API_VERSION => 1,
1670: P_INIT_MSG_LIST => fnd_api.g_false,
1671: P_COMMIT => fnd_api.g_false,
1672: P_GROUP_ID => l_group_id,
1673: P_GROUP_NUMBER => group_rec.group_number,
1674: P_GROUP_NAME => group_rec.group_name,

Line 1671: P_COMMIT => fnd_api.g_false,

1667:
1668: jtf_rs_groups_aud_pvt.update_group
1669: (P_API_VERSION => 1,
1670: P_INIT_MSG_LIST => fnd_api.g_false,
1671: P_COMMIT => fnd_api.g_false,
1672: P_GROUP_ID => l_group_id,
1673: P_GROUP_NUMBER => group_rec.group_number,
1674: P_GROUP_NAME => group_rec.group_name,
1675: P_GROUP_DESC => group_rec.group_desc,

Line 1688: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1684: X_MSG_DATA => x_msg_data,
1685: P_TIME_ZONE => group_rec.time_zone
1686: );
1687:
1688: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1689:
1690: -- dbms_output.put_line('Failed status from call to audit procedure');
1691:
1692: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

Line 1692: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1688: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1689:
1690: -- dbms_output.put_line('Failed status from call to audit procedure');
1691:
1692: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1693: RAISE FND_API.G_EXC_ERROR;
1694: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1696: END IF;

Line 1693: RAISE FND_API.G_EXC_ERROR;

1689:
1690: -- dbms_output.put_line('Failed status from call to audit procedure');
1691:
1692: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1693: RAISE FND_API.G_EXC_ERROR;
1694: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1696: END IF;
1697:

Line 1694: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1690: -- dbms_output.put_line('Failed status from call to audit procedure');
1691:
1692: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1693: RAISE FND_API.G_EXC_ERROR;
1694: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1696: END IF;
1697:
1698: END IF;

Line 1695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1691:
1692: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1693: RAISE FND_API.G_EXC_ERROR;
1694: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1696: END IF;
1697:
1698: END IF;
1699:

Line 1786: RAISE fnd_api.g_exc_error;

1782:
1783: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1784: fnd_msg_pub.add;
1785:
1786: RAISE fnd_api.g_exc_error;
1787:
1788: END;
1789:
1790: -- dbms_output.put_line('Group Successfully Updated');

Line 1806: P_INIT_MSG_LIST => fnd_api.g_false,

1802: /* Make a call to the Group Denorm API */
1803:
1804: jtf_rs_group_denorm_pvt.update_res_groups
1805: (P_API_VERSION => 1,
1806: P_INIT_MSG_LIST => fnd_api.g_false,
1807: P_COMMIT => fnd_api.g_false,
1808: P_GROUP_ID => l_group_id,
1809: X_RETURN_STATUS => x_return_status,
1810: X_MSG_COUNT => x_msg_count,

Line 1807: P_COMMIT => fnd_api.g_false,

1803:
1804: jtf_rs_group_denorm_pvt.update_res_groups
1805: (P_API_VERSION => 1,
1806: P_INIT_MSG_LIST => fnd_api.g_false,
1807: P_COMMIT => fnd_api.g_false,
1808: P_GROUP_ID => l_group_id,
1809: X_RETURN_STATUS => x_return_status,
1810: X_MSG_COUNT => x_msg_count,
1811: X_MSG_DATA => x_msg_data

Line 1814: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1810: X_MSG_COUNT => x_msg_count,
1811: X_MSG_DATA => x_msg_data
1812: );
1813:
1814: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1815:
1816: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1817: RAISE FND_API.G_EXC_ERROR;
1818: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1816: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1812: );
1813:
1814: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1815:
1816: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1817: RAISE FND_API.G_EXC_ERROR;
1818: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1820: END IF;

Line 1817: RAISE FND_API.G_EXC_ERROR;

1813:
1814: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1815:
1816: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1817: RAISE FND_API.G_EXC_ERROR;
1818: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1820: END IF;
1821:

Line 1818: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1814: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1815:
1816: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1817: RAISE FND_API.G_EXC_ERROR;
1818: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1820: END IF;
1821:
1822:

Line 1819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1815:
1816: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1817: RAISE FND_API.G_EXC_ERROR;
1818: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1820: END IF;
1821:
1822:
1823: END IF;

Line 1854: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1850: p_end_date_active => l_end_date_active,
1851: p_accounting_code => l_accounting_code,
1852: x_return_status => x_return_status);
1853:
1854: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1855:
1856: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1857:
1858:

Line 1861: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1857:
1858:
1859: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1860: fnd_msg_pub.add;
1861: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1862: RAISE FND_API.G_EXC_ERROR;
1863: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1865: END IF;

Line 1862: RAISE FND_API.G_EXC_ERROR;

1858:
1859: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1860: fnd_msg_pub.add;
1861: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1862: RAISE FND_API.G_EXC_ERROR;
1863: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1865: END IF;
1866:

Line 1863: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1859: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1860: fnd_msg_pub.add;
1861: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1862: RAISE FND_API.G_EXC_ERROR;
1863: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1865: END IF;
1866:
1867: END IF;

Line 1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1860: fnd_msg_pub.add;
1861: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1862: RAISE FND_API.G_EXC_ERROR;
1863: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1865: END IF;
1866:
1867: END IF;
1868:

Line 1899: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1895: p_end_date_active => l_end_date_active,
1896: p_accounting_code => l_accounting_code,
1897: x_return_status => x_return_status);
1898:
1899: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1900:
1901: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
1902:
1903:

Line 1907: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1903:
1904: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1905: fnd_msg_pub.add;
1906:
1907: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1908: RAISE FND_API.G_EXC_ERROR;
1909: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1911: END IF;

Line 1908: RAISE FND_API.G_EXC_ERROR;

1904: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1905: fnd_msg_pub.add;
1906:
1907: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1908: RAISE FND_API.G_EXC_ERROR;
1909: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1911: END IF;
1912:

Line 1909: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1905: fnd_msg_pub.add;
1906:
1907: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1908: RAISE FND_API.G_EXC_ERROR;
1909: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1911: END IF;
1912:
1913:

Line 1910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1906:
1907: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1908: RAISE FND_API.G_EXC_ERROR;
1909: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1911: END IF;
1912:
1913:
1914: END IF;

Line 1946: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1942: p_end_date_active => l_end_date_active,
1943: p_accounting_code => l_accounting_code,
1944: x_return_status => x_return_status);
1945:
1946: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1947:
1948:
1949: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1950: fnd_msg_pub.add;

Line 1952: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1948:
1949: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1950: fnd_msg_pub.add;
1951:
1952: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1953: RAISE FND_API.G_EXC_ERROR;
1954: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1956: END IF;

Line 1953: RAISE FND_API.G_EXC_ERROR;

1949: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1950: fnd_msg_pub.add;
1951:
1952: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1953: RAISE FND_API.G_EXC_ERROR;
1954: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1956: END IF;
1957:

Line 1954: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1950: fnd_msg_pub.add;
1951:
1952: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1953: RAISE FND_API.G_EXC_ERROR;
1954: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1956: END IF;
1957:
1958: END IF;

Line 1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1951:
1952: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1953: RAISE FND_API.G_EXC_ERROR;
1954: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1956: END IF;
1957:
1958: END IF;
1959:

Line 2004: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

2000: p_bind_data_id => l_bind_data_id,
2001: x_return_code => x_return_status);
2002:
2003:
2004: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2005:
2006: -- dbms_output.put_line('Returned Error status from the Message Generation API');
2007:
2008:

Line 2012: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

2008:
2009: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
2010: fnd_msg_pub.add;
2011:
2012: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2013: RAISE FND_API.G_EXC_ERROR;
2014: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2016: END IF;

Line 2013: RAISE FND_API.G_EXC_ERROR;

2009: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
2010: fnd_msg_pub.add;
2011:
2012: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2013: RAISE FND_API.G_EXC_ERROR;
2014: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2016: END IF;
2017:

Line 2014: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

2010: fnd_msg_pub.add;
2011:
2012: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2013: RAISE FND_API.G_EXC_ERROR;
2014: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2016: END IF;
2017:
2018: END IF;

Line 2015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2011:
2012: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2013: RAISE FND_API.G_EXC_ERROR;
2014: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
2015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2016: END IF;
2017:
2018: END IF;
2019:

Line 2026: IF fnd_api.to_boolean(p_commit) THEN

2022: END IF;
2023: END IF;
2024:
2025:
2026: IF fnd_api.to_boolean(p_commit) THEN
2027:
2028: COMMIT WORK;
2029:
2030: END IF;

Line 2037: WHEN fnd_api.g_exc_error THEN

2033:
2034:
2035: EXCEPTION
2036:
2037: WHEN fnd_api.g_exc_error THEN
2038: ROLLBACK TO update_resource_group_pvt;
2039: x_return_status := fnd_api.g_ret_sts_error;
2040: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2041: p_data => x_msg_data);

Line 2039: x_return_status := fnd_api.g_ret_sts_error;

2035: EXCEPTION
2036:
2037: WHEN fnd_api.g_exc_error THEN
2038: ROLLBACK TO update_resource_group_pvt;
2039: x_return_status := fnd_api.g_ret_sts_error;
2040: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2041: p_data => x_msg_data);
2042: WHEN fnd_api.g_exc_unexpected_error THEN
2043: ROLLBACK TO update_resource_group_pvt;

Line 2042: WHEN fnd_api.g_exc_unexpected_error THEN

2038: ROLLBACK TO update_resource_group_pvt;
2039: x_return_status := fnd_api.g_ret_sts_error;
2040: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2041: p_data => x_msg_data);
2042: WHEN fnd_api.g_exc_unexpected_error THEN
2043: ROLLBACK TO update_resource_group_pvt;
2044: x_return_status := fnd_api.g_ret_sts_unexp_error;
2045: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2046: p_data => x_msg_data);

Line 2044: x_return_status := fnd_api.g_ret_sts_unexp_error;

2040: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2041: p_data => x_msg_data);
2042: WHEN fnd_api.g_exc_unexpected_error THEN
2043: ROLLBACK TO update_resource_group_pvt;
2044: x_return_status := fnd_api.g_ret_sts_unexp_error;
2045: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2046: p_data => x_msg_data);
2047: WHEN OTHERS THEN
2048: ROLLBACK TO update_resource_group_pvt;

Line 2054: x_return_status := fnd_api.g_ret_sts_unexp_error;

2050: fnd_message.set_token('P_SQLCODE',SQLCODE);
2051: fnd_message.set_token('P_SQLERRM',SQLERRM);
2052: fnd_message.set_token('P_API_NAME', l_api_name);
2053: FND_MSG_PUB.add;
2054: x_return_status := fnd_api.g_ret_sts_unexp_error;
2055: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2056: p_data => x_msg_data);
2057:
2058: END update_resource_group;