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 88: x_return_status := fnd_api.g_ret_sts_success;

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

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

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

Line 95: RAISE fnd_api.g_exc_unexpected_error;

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

Line 100: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

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

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

Line 138: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

Line 139: RAISE FND_API.G_EXC_ERROR;

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

Line 140: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 182: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

Line 183: RAISE FND_API.G_EXC_ERROR;

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

Line 184: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 227: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

Line 228: RAISE FND_API.G_EXC_ERROR;

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

Line 229: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 249: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

Line 250: RAISE FND_API.G_EXC_ERROR;

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

Line 251: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 294: P_INIT_MSG_LIST => fnd_api.g_false,

290: /* Make a call to the group Audit API */
291:
292: jtf_rs_groups_aud_pvt.insert_group
293: (P_API_VERSION => 1,
294: P_INIT_MSG_LIST => fnd_api.g_false,
295: P_COMMIT => fnd_api.g_false,
296: P_GROUP_ID => l_group_id,
297: P_GROUP_NUMBER => l_group_number,
298: P_GROUP_NAME => l_group_name,

Line 295: P_COMMIT => fnd_api.g_false,

291:
292: jtf_rs_groups_aud_pvt.insert_group
293: (P_API_VERSION => 1,
294: P_INIT_MSG_LIST => fnd_api.g_false,
295: P_COMMIT => fnd_api.g_false,
296: P_GROUP_ID => l_group_id,
297: P_GROUP_NUMBER => l_group_number,
298: P_GROUP_NAME => l_group_name,
299: P_GROUP_DESC => l_group_desc,

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

307: X_MSG_COUNT => x_msg_count,
308: X_MSG_DATA => x_msg_data
309: );
310:
311: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
312:
313: -- dbms_output.put_line('Failed status from call to audit procedure');
314:
315: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

Line 315: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

311: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
312:
313: -- dbms_output.put_line('Failed status from call to audit procedure');
314:
315: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
316: RAISE FND_API.G_EXC_ERROR;
317: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
319: END IF;

Line 316: RAISE FND_API.G_EXC_ERROR;

312:
313: -- dbms_output.put_line('Failed status from call to audit procedure');
314:
315: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
316: RAISE FND_API.G_EXC_ERROR;
317: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
319: END IF;
320:

Line 317: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

313: -- dbms_output.put_line('Failed status from call to audit procedure');
314:
315: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
316: RAISE FND_API.G_EXC_ERROR;
317: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
319: END IF;
320:
321:

Line 318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

314:
315: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
316: RAISE FND_API.G_EXC_ERROR;
317: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
319: END IF;
320:
321:
322: END IF;

Line 383: RAISE fnd_api.g_exc_error;

379:
380: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
381: fnd_msg_pub.add;
382:
383: RAISE fnd_api.g_exc_error;
384:
385:
386: ELSE
387:

Line 410: P_INIT_MSG_LIST => fnd_api.g_false,

406: /* Make a call to the Group Denorm API */
407:
408: jtf_rs_group_denorm_pvt.create_res_groups
409: (P_API_VERSION => 1,
410: P_INIT_MSG_LIST => fnd_api.g_false,
411: P_COMMIT => fnd_api.g_false,
412: P_GROUP_ID => l_group_id,
413: X_RETURN_STATUS => x_return_status,
414: X_MSG_COUNT => x_msg_count,

Line 411: P_COMMIT => fnd_api.g_false,

407:
408: jtf_rs_group_denorm_pvt.create_res_groups
409: (P_API_VERSION => 1,
410: P_INIT_MSG_LIST => fnd_api.g_false,
411: P_COMMIT => fnd_api.g_false,
412: P_GROUP_ID => l_group_id,
413: X_RETURN_STATUS => x_return_status,
414: X_MSG_COUNT => x_msg_count,
415: X_MSG_DATA => x_msg_data

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

414: X_MSG_COUNT => x_msg_count,
415: X_MSG_DATA => x_msg_data
416: );
417:
418: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
419:
420: -- dbms_output.put_line('Failed status from call to Group Denorm procedure');
421:
422: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

Line 422: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

418: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
419:
420: -- dbms_output.put_line('Failed status from call to Group Denorm procedure');
421:
422: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
423: RAISE FND_API.G_EXC_ERROR;
424: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;

Line 423: RAISE FND_API.G_EXC_ERROR;

419:
420: -- dbms_output.put_line('Failed status from call to Group Denorm procedure');
421:
422: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
423: RAISE FND_API.G_EXC_ERROR;
424: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427:

Line 424: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

420: -- dbms_output.put_line('Failed status from call to Group Denorm procedure');
421:
422: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
423: RAISE FND_API.G_EXC_ERROR;
424: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427:
428: END IF;

Line 425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

421:
422: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
423: RAISE FND_API.G_EXC_ERROR;
424: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427:
428: END IF;
429:

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

450: p_end_date_active => l_end_date_active,
451: p_accounting_code => l_accounting_code,
452: x_return_status => x_return_status);
453:
454: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
455:
456: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
457:
458:

Line 462: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

458:
459: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
460: fnd_msg_pub.add;
461:
462: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
463: RAISE FND_API.G_EXC_ERROR;
464: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: END IF;

Line 463: RAISE FND_API.G_EXC_ERROR;

459: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
460: fnd_msg_pub.add;
461:
462: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
463: RAISE FND_API.G_EXC_ERROR;
464: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: END IF;
467:

Line 464: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

460: fnd_msg_pub.add;
461:
462: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
463: RAISE FND_API.G_EXC_ERROR;
464: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: END IF;
467:
468: END IF;

Line 465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

461:
462: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
463: RAISE FND_API.G_EXC_ERROR;
464: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: END IF;
467:
468: END IF;
469:

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

489: p_end_date_active => l_end_date_active,
490: p_accounting_code => l_accounting_code,
491: x_return_status => x_return_status);
492:
493: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
494:
495: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
496:
497:

Line 501: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

497:
498: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
499: fnd_msg_pub.add;
500:
501: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
502: RAISE FND_API.G_EXC_ERROR;
503: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END IF;

Line 502: RAISE FND_API.G_EXC_ERROR;

498: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
499: fnd_msg_pub.add;
500:
501: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
502: RAISE FND_API.G_EXC_ERROR;
503: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END IF;
506:

Line 503: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

499: fnd_msg_pub.add;
500:
501: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
502: RAISE FND_API.G_EXC_ERROR;
503: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END IF;
506:
507:

Line 504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

500:
501: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
502: RAISE FND_API.G_EXC_ERROR;
503: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
505: END IF;
506:
507:
508: END IF;

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

529: p_end_date_active => l_end_date_active,
530: p_accounting_code => l_accounting_code,
531: x_return_status => x_return_status);
532:
533: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
534:
535: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
536:
537:

Line 541: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

537:
538: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
539: fnd_msg_pub.add;
540:
541: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
542: RAISE FND_API.G_EXC_ERROR;
543: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: END IF;

Line 542: RAISE FND_API.G_EXC_ERROR;

538: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
539: fnd_msg_pub.add;
540:
541: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
542: RAISE FND_API.G_EXC_ERROR;
543: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: END IF;
546:

Line 543: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

539: fnd_msg_pub.add;
540:
541: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
542: RAISE FND_API.G_EXC_ERROR;
543: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: END IF;
546:
547: END IF;

Line 544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

540:
541: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
542: RAISE FND_API.G_EXC_ERROR;
543: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: END IF;
546:
547: END IF;
548:

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

582: p_bind_data_id => l_bind_data_id,
583: x_return_code => x_return_status);
584:
585:
586: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
587:
588: -- dbms_output.put_line('Returned Error status from the Message Generation API');
589:
590:

Line 594: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

590:
591: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
592: fnd_msg_pub.add;
593:
594: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;

Line 595: RAISE FND_API.G_EXC_ERROR;

591: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
592: fnd_msg_pub.add;
593:
594: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;
599:

Line 596: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

592: fnd_msg_pub.add;
593:
594: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;
599:
600: END IF;

Line 597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

593:
594: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;
599:
600: END IF;
601:

Line 625: IF fnd_api.to_boolean(p_commit) THEN

621: NULL;
622: END;
623:
624:
625: IF fnd_api.to_boolean(p_commit) THEN
626:
627: COMMIT WORK;
628:
629: END IF;

Line 636: WHEN fnd_api.g_exc_error THEN

632:
633: EXCEPTION
634:
635:
636: WHEN fnd_api.g_exc_error THEN
637: ROLLBACK TO create_resource_group_pvt;
638: x_return_status := fnd_api.g_ret_sts_error;
639: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
640: p_data => x_msg_data);

Line 638: x_return_status := fnd_api.g_ret_sts_error;

634:
635:
636: WHEN fnd_api.g_exc_error THEN
637: ROLLBACK TO create_resource_group_pvt;
638: x_return_status := fnd_api.g_ret_sts_error;
639: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
640: p_data => x_msg_data);
641: WHEN fnd_api.g_exc_unexpected_error THEN
642: ROLLBACK TO create_resource_group_pvt;

Line 641: WHEN fnd_api.g_exc_unexpected_error THEN

637: ROLLBACK TO create_resource_group_pvt;
638: x_return_status := fnd_api.g_ret_sts_error;
639: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
640: p_data => x_msg_data);
641: WHEN fnd_api.g_exc_unexpected_error THEN
642: ROLLBACK TO create_resource_group_pvt;
643: x_return_status := fnd_api.g_ret_sts_unexp_error;
644: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
645: p_data => x_msg_data);

Line 643: x_return_status := fnd_api.g_ret_sts_unexp_error;

639: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
640: p_data => x_msg_data);
641: WHEN fnd_api.g_exc_unexpected_error THEN
642: ROLLBACK TO create_resource_group_pvt;
643: x_return_status := fnd_api.g_ret_sts_unexp_error;
644: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
645: p_data => x_msg_data);
646: WHEN OTHERS THEN
647: ROLLBACK TO create_resource_group_pvt;

Line 653: x_return_status := fnd_api.g_ret_sts_unexp_error;

649: fnd_message.set_token('P_SQLCODE',SQLCODE);
650: fnd_message.set_token('P_SQLERRM',SQLERRM);
651: fnd_message.set_token('P_API_NAME', l_api_name);
652: FND_MSG_PUB.add;
653: x_return_status := fnd_api.g_ret_sts_unexp_error;
654: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
655: p_data => x_msg_data);
656:
657: END create_resource_group;

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

790: l_group_id IN NUMBER )
791: IS
792: SELECT
793: group_number,
794: DECODE(p_group_name, fnd_api.g_miss_char, group_name, p_group_name) group_name,
795: DECODE(p_group_desc, fnd_api.g_miss_char, group_desc, p_group_desc) group_desc,
796: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
797: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
798: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,

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

791: IS
792: SELECT
793: group_number,
794: DECODE(p_group_name, fnd_api.g_miss_char, group_name, p_group_name) group_name,
795: DECODE(p_group_desc, fnd_api.g_miss_char, group_desc, p_group_desc) group_desc,
796: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
797: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
798: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
799: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,

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

792: SELECT
793: group_number,
794: DECODE(p_group_name, fnd_api.g_miss_char, group_name, p_group_name) group_name,
795: DECODE(p_group_desc, fnd_api.g_miss_char, group_desc, p_group_desc) group_desc,
796: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
797: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
798: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
799: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
800: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,

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

793: group_number,
794: DECODE(p_group_name, fnd_api.g_miss_char, group_name, p_group_name) group_name,
795: DECODE(p_group_desc, fnd_api.g_miss_char, group_desc, p_group_desc) group_desc,
796: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
797: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
798: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
799: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
800: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
801: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,

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

794: DECODE(p_group_name, fnd_api.g_miss_char, group_name, p_group_name) group_name,
795: DECODE(p_group_desc, fnd_api.g_miss_char, group_desc, p_group_desc) group_desc,
796: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
797: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
798: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
799: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
800: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
801: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
802: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,

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

795: DECODE(p_group_desc, fnd_api.g_miss_char, group_desc, p_group_desc) group_desc,
796: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
797: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
798: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
799: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
800: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
801: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
802: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
803: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,

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

796: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
797: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
798: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
799: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
800: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
801: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
802: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
803: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
804: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,

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

797: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
798: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
799: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
800: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
801: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
802: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
803: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
804: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
805: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,

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

798: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
799: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
800: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
801: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
802: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
803: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
804: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
805: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
806: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,

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

799: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
800: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
801: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
802: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
803: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
804: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
805: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
806: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
807: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,

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

800: DECODE(p_accounting_code, fnd_api.g_miss_char, accounting_code, p_accounting_code) accounting_code,
801: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
802: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
803: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
804: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
805: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
806: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
807: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
808: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,

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

801: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
802: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
803: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
804: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
805: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
806: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
807: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
808: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
809: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,

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

802: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
803: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
804: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
805: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
806: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
807: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
808: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
809: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
810: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,

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

803: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
804: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
805: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
806: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
807: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
808: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
809: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
810: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
811: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,

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

804: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
805: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
806: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
807: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
808: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
809: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
810: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
811: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
812: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,

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

805: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
806: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
807: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
808: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
809: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
810: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
811: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
812: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
813: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,

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

806: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
807: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
808: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
809: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
810: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
811: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
812: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
813: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
814: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,

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

807: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
808: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
809: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
810: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
811: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
812: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
813: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
814: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
815: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,

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

808: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
809: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
810: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
811: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
812: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
813: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
814: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
815: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
816: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category

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

809: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
810: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
811: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
812: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
813: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
814: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
815: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
816: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category
817: FROM jtf_rs_groups_vl

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

810: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
811: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
812: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
813: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
814: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
815: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
816: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category
817: FROM jtf_rs_groups_vl
818: WHERE group_id = l_group_id;

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

811: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
812: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
813: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
814: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
815: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
816: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category
817: FROM jtf_rs_groups_vl
818: WHERE group_id = l_group_id;
819:

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

812: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
813: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
814: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
815: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
816: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category
817: FROM jtf_rs_groups_vl
818: WHERE group_id = l_group_id;
819:
820: group_rec c_group_update%ROWTYPE;

Line 979: x_return_status := fnd_api.g_ret_sts_success;

975:
976:
977: SAVEPOINT update_resource_group_pvt;
978:
979: x_return_status := fnd_api.g_ret_sts_success;
980:
981: -- DBMS_OUTPUT.put_line(' Started Update Resource Group Pvt ');
982:
983:

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

980:
981: -- DBMS_OUTPUT.put_line(' Started Update Resource Group Pvt ');
982:
983:
984: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
985:
986: RAISE fnd_api.g_exc_unexpected_error;
987:
988: END IF;

Line 986: RAISE fnd_api.g_exc_unexpected_error;

982:
983:
984: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
985:
986: RAISE fnd_api.g_exc_unexpected_error;
987:
988: END IF;
989:
990:

Line 991: IF fnd_api.to_boolean(p_init_msg_list) THEN

987:
988: END IF;
989:
990:
991: IF fnd_api.to_boolean(p_init_msg_list) THEN
992:
993: fnd_msg_pub.initialize;
994:
995: END IF;

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

1021: p_end_date_active => l_end_date_active,
1022: p_accounting_code => l_accounting_code,
1023: x_return_status => x_return_status);
1024:
1025: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1026:
1027: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
1028:
1029: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

Line 1032: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1028:
1029: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1030: fnd_msg_pub.add;
1031:
1032: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: END IF;

Line 1033: RAISE FND_API.G_EXC_ERROR;

1029: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1030: fnd_msg_pub.add;
1031:
1032: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: END IF;
1037:

Line 1034: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1030: fnd_msg_pub.add;
1031:
1032: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: END IF;
1037:
1038:

Line 1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1031:
1032: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: END IF;
1037:
1038:
1039: END IF;

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

1067: p_end_date_active => l_end_date_active,
1068: p_accounting_code => l_accounting_code,
1069: x_return_status => x_return_status);
1070:
1071: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1072:
1073: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
1074:
1075:

Line 1079: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1075:
1076: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1077: fnd_msg_pub.add;
1078:
1079: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1080: RAISE FND_API.G_EXC_ERROR;
1081: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: END IF;

Line 1080: RAISE FND_API.G_EXC_ERROR;

1076: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1077: fnd_msg_pub.add;
1078:
1079: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1080: RAISE FND_API.G_EXC_ERROR;
1081: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: END IF;
1084:

Line 1081: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1077: fnd_msg_pub.add;
1078:
1079: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1080: RAISE FND_API.G_EXC_ERROR;
1081: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: END IF;
1084:
1085:

Line 1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1078:
1079: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1080: RAISE FND_API.G_EXC_ERROR;
1081: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: END IF;
1084:
1085:
1086: END IF;

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

1114: p_end_date_active => l_end_date_active,
1115: p_accounting_code => l_accounting_code,
1116: x_return_status => x_return_status);
1117:
1118: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1119:
1120:
1121: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1122: fnd_msg_pub.add;

Line 1124: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1120:
1121: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1122: fnd_msg_pub.add;
1123:
1124: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1125: RAISE FND_API.G_EXC_ERROR;
1126: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1128: END IF;

Line 1125: RAISE FND_API.G_EXC_ERROR;

1121: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1122: fnd_msg_pub.add;
1123:
1124: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1125: RAISE FND_API.G_EXC_ERROR;
1126: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1128: END IF;
1129:

Line 1126: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1122: fnd_msg_pub.add;
1123:
1124: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1125: RAISE FND_API.G_EXC_ERROR;
1126: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1128: END IF;
1129:
1130: END IF;

Line 1127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1123:
1124: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1125: RAISE FND_API.G_EXC_ERROR;
1126: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1128: END IF;
1129:
1130: END IF;
1131:

Line 1154: RAISE fnd_api.g_exc_error;

1150: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP');
1151: fnd_message.set_token('P_GROUP_ID', l_group_id);
1152: fnd_msg_pub.add;
1153:
1154: RAISE fnd_api.g_exc_error;
1155:
1156: END IF;
1157:
1158: /* Validate that the Group Name is specified */

Line 1167: RAISE fnd_api.g_exc_error;

1163:
1164: fnd_message.set_name('JTF', 'JTF_RS_GROUP_NAME_NULL');
1165: fnd_msg_pub.add;
1166:
1167: RAISE fnd_api.g_exc_error;
1168:
1169: END IF;
1170:
1171:

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

1180: p_end_date_active => l_end_date_active,
1181: x_return_status => x_return_status
1182: );
1183:
1184: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1185:
1186: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1187: RAISE FND_API.G_EXC_ERROR;
1188: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1186: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1182: );
1183:
1184: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1185:
1186: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1187: RAISE FND_API.G_EXC_ERROR;
1188: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: END IF;

Line 1187: RAISE FND_API.G_EXC_ERROR;

1183:
1184: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1185:
1186: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1187: RAISE FND_API.G_EXC_ERROR;
1188: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: END IF;
1191:

Line 1188: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1184: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1185:
1186: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1187: RAISE FND_API.G_EXC_ERROR;
1188: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: END IF;
1191:
1192:

Line 1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1185:
1186: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1187: RAISE FND_API.G_EXC_ERROR;
1188: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: END IF;
1191:
1192:
1193: END IF;

Line 1215: RAISE fnd_api.g_exc_error;

1211:
1212: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_START_DATE');
1213: fnd_msg_pub.add;
1214:
1215: RAISE fnd_api.g_exc_error;
1216:
1217:
1218: END IF;
1219:

Line 1225: RAISE fnd_api.g_exc_error;

1221:
1222: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_END_DATE');
1223: fnd_msg_pub.add;
1224:
1225: RAISE fnd_api.g_exc_error;
1226:
1227: END IF;
1228:
1229: END IF;

Line 1257: RAISE fnd_api.g_exc_error;

1253:
1254: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_START_DATE');
1255: fnd_msg_pub.add;
1256:
1257: RAISE fnd_api.g_exc_error;
1258:
1259:
1260: END IF;
1261:

Line 1267: RAISE fnd_api.g_exc_error;

1263:
1264: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_END_DATE');
1265: fnd_msg_pub.add;
1266:
1267: RAISE fnd_api.g_exc_error;
1268:
1269:
1270: END IF;
1271:

Line 1303: RAISE fnd_api.g_exc_error;

1299:
1300: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_START_DATE');
1301: fnd_msg_pub.add;
1302:
1303: RAISE fnd_api.g_exc_error;
1304:
1305: END IF;
1306:
1307: IF ( l_max_end_date > l_end_date_active AND l_end_date_active IS NOT NULL ) THEN

Line 1312: RAISE fnd_api.g_exc_error;

1308:
1309: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_END_DATE');
1310: fnd_msg_pub.add;
1311:
1312: RAISE fnd_api.g_exc_error;
1313:
1314:
1315: END IF;
1316:

Line 1345: RAISE fnd_api.g_exc_error;

1341:
1342: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_START_DATE');
1343: fnd_msg_pub.add;
1344:
1345: RAISE fnd_api.g_exc_error;
1346:
1347:
1348: END IF;
1349:

Line 1355: RAISE fnd_api.g_exc_error;

1351:
1352: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_END_DATE');
1353: fnd_msg_pub.add;
1354:
1355: RAISE fnd_api.g_exc_error;
1356:
1357:
1358: END IF;
1359:

Line 1391: RAISE fnd_api.g_exc_error;

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

Line 1401: RAISE fnd_api.g_exc_error;

1397:
1398: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_END_DATE');
1399: fnd_msg_pub.add;
1400:
1401: RAISE fnd_api.g_exc_error;
1402:
1403:
1404: END IF;
1405:

Line 1434: RAISE fnd_api.g_exc_error;

1430:
1431: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_START_DATE');
1432: fnd_msg_pub.add;
1433:
1434: RAISE fnd_api.g_exc_error;
1435:
1436: END IF;
1437:
1438: IF l_end_date_active IS NOT NULL THEN

Line 1443: RAISE fnd_api.g_exc_error;

1439:
1440: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_END_DATE');
1441: fnd_msg_pub.add;
1442:
1443: RAISE fnd_api.g_exc_error;
1444:
1445: END IF;
1446:
1447: END IF;

Line 1478: RAISE fnd_api.g_exc_error;

1474:
1475: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_START_DATE');
1476: fnd_msg_pub.add;
1477:
1478: RAISE fnd_api.g_exc_error;
1479:
1480: END IF;
1481:
1482: IF ( l_max_end_date > l_end_date_active AND l_end_date_active IS NOT NULL ) THEN

Line 1487: RAISE fnd_api.g_exc_error;

1483:
1484: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_END_DATE');
1485: fnd_msg_pub.add;
1486:
1487: RAISE fnd_api.g_exc_error;
1488:
1489: END IF;
1490:
1491: END IF;

Line 1519: RAISE fnd_api.g_exc_error;

1515:
1516: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_START_DATE');
1517: fnd_msg_pub.add;
1518:
1519: RAISE fnd_api.g_exc_error;
1520:
1521: END IF;
1522:
1523: IF l_end_date_active IS NOT NULL THEN

Line 1528: RAISE fnd_api.g_exc_error;

1524:
1525: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_END_DATE');
1526: fnd_msg_pub.add;
1527:
1528: RAISE fnd_api.g_exc_error;
1529:
1530: END IF;
1531:
1532: END IF;

Line 1572: RAISE fnd_api.g_exc_error;

1568:
1569: fnd_message.set_name('JTF', 'JTF_RS_EXCLUSIVE_GROUP');
1570: fnd_msg_pub.add;
1571:
1572: RAISE fnd_api.g_exc_error;
1573:
1574: END IF;
1575: END IF;
1576:

Line 1607: RAISE fnd_api.g_exc_error;

1603:
1604: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1605: fnd_msg_pub.add;
1606:
1607: RAISE fnd_api.g_exc_error;
1608:
1609:
1610: END;
1611:

Line 1617: P_INIT_MSG_LIST => fnd_api.g_false,

1613: /* Make a call to the group Audit API */
1614:
1615: jtf_rs_groups_aud_pvt.update_group
1616: (P_API_VERSION => 1,
1617: P_INIT_MSG_LIST => fnd_api.g_false,
1618: P_COMMIT => fnd_api.g_false,
1619: P_GROUP_ID => l_group_id,
1620: P_GROUP_NUMBER => group_rec.group_number,
1621: P_GROUP_NAME => group_rec.group_name,

Line 1618: P_COMMIT => fnd_api.g_false,

1614:
1615: jtf_rs_groups_aud_pvt.update_group
1616: (P_API_VERSION => 1,
1617: P_INIT_MSG_LIST => fnd_api.g_false,
1618: P_COMMIT => fnd_api.g_false,
1619: P_GROUP_ID => l_group_id,
1620: P_GROUP_NUMBER => group_rec.group_number,
1621: P_GROUP_NAME => group_rec.group_name,
1622: P_GROUP_DESC => group_rec.group_desc,

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

1630: X_MSG_COUNT => x_msg_count,
1631: X_MSG_DATA => x_msg_data
1632: );
1633:
1634: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1635:
1636: -- dbms_output.put_line('Failed status from call to audit procedure');
1637:
1638: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

Line 1638: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1634: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1635:
1636: -- dbms_output.put_line('Failed status from call to audit procedure');
1637:
1638: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1639: RAISE FND_API.G_EXC_ERROR;
1640: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: END IF;

Line 1639: RAISE FND_API.G_EXC_ERROR;

1635:
1636: -- dbms_output.put_line('Failed status from call to audit procedure');
1637:
1638: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1639: RAISE FND_API.G_EXC_ERROR;
1640: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: END IF;
1643:

Line 1640: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1636: -- dbms_output.put_line('Failed status from call to audit procedure');
1637:
1638: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1639: RAISE FND_API.G_EXC_ERROR;
1640: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: END IF;
1643:
1644: END IF;

Line 1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1637:
1638: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1639: RAISE FND_API.G_EXC_ERROR;
1640: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: END IF;
1643:
1644: END IF;
1645:

Line 1731: RAISE fnd_api.g_exc_error;

1727:
1728: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1729: fnd_msg_pub.add;
1730:
1731: RAISE fnd_api.g_exc_error;
1732:
1733: END;
1734:
1735: -- dbms_output.put_line('Group Successfully Updated');

Line 1751: P_INIT_MSG_LIST => fnd_api.g_false,

1747: /* Make a call to the Group Denorm API */
1748:
1749: jtf_rs_group_denorm_pvt.update_res_groups
1750: (P_API_VERSION => 1,
1751: P_INIT_MSG_LIST => fnd_api.g_false,
1752: P_COMMIT => fnd_api.g_false,
1753: P_GROUP_ID => l_group_id,
1754: X_RETURN_STATUS => x_return_status,
1755: X_MSG_COUNT => x_msg_count,

Line 1752: P_COMMIT => fnd_api.g_false,

1748:
1749: jtf_rs_group_denorm_pvt.update_res_groups
1750: (P_API_VERSION => 1,
1751: P_INIT_MSG_LIST => fnd_api.g_false,
1752: P_COMMIT => fnd_api.g_false,
1753: P_GROUP_ID => l_group_id,
1754: X_RETURN_STATUS => x_return_status,
1755: X_MSG_COUNT => x_msg_count,
1756: X_MSG_DATA => x_msg_data

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

1755: X_MSG_COUNT => x_msg_count,
1756: X_MSG_DATA => x_msg_data
1757: );
1758:
1759: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1760:
1761: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1762: RAISE FND_API.G_EXC_ERROR;
1763: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1761: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1757: );
1758:
1759: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1760:
1761: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1762: RAISE FND_API.G_EXC_ERROR;
1763: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765: END IF;

Line 1762: RAISE FND_API.G_EXC_ERROR;

1758:
1759: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1760:
1761: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1762: RAISE FND_API.G_EXC_ERROR;
1763: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765: END IF;
1766:

Line 1763: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1759: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1760:
1761: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1762: RAISE FND_API.G_EXC_ERROR;
1763: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765: END IF;
1766:
1767:

Line 1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1760:
1761: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1762: RAISE FND_API.G_EXC_ERROR;
1763: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765: END IF;
1766:
1767:
1768: END IF;

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

1795: p_end_date_active => l_end_date_active,
1796: p_accounting_code => l_accounting_code,
1797: x_return_status => x_return_status);
1798:
1799: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1800:
1801: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1802:
1803:

Line 1806: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1802:
1803:
1804: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1805: fnd_msg_pub.add;
1806: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1807: RAISE FND_API.G_EXC_ERROR;
1808: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1810: END IF;

Line 1807: RAISE FND_API.G_EXC_ERROR;

1803:
1804: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1805: fnd_msg_pub.add;
1806: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1807: RAISE FND_API.G_EXC_ERROR;
1808: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1810: END IF;
1811:

Line 1808: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1804: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1805: fnd_msg_pub.add;
1806: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1807: RAISE FND_API.G_EXC_ERROR;
1808: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1810: END IF;
1811:
1812: END IF;

Line 1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1805: fnd_msg_pub.add;
1806: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1807: RAISE FND_API.G_EXC_ERROR;
1808: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1810: END IF;
1811:
1812: END IF;
1813:

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

1840: p_end_date_active => l_end_date_active,
1841: p_accounting_code => l_accounting_code,
1842: x_return_status => x_return_status);
1843:
1844: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1845:
1846: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
1847:
1848:

Line 1852: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1848:
1849: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1850: fnd_msg_pub.add;
1851:
1852: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1853: RAISE FND_API.G_EXC_ERROR;
1854: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1856: END IF;

Line 1853: RAISE FND_API.G_EXC_ERROR;

1849: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1850: fnd_msg_pub.add;
1851:
1852: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1853: RAISE FND_API.G_EXC_ERROR;
1854: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1856: END IF;
1857:

Line 1854: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1850: fnd_msg_pub.add;
1851:
1852: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1853: RAISE FND_API.G_EXC_ERROR;
1854: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1856: END IF;
1857:
1858:

Line 1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1851:
1852: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1853: RAISE FND_API.G_EXC_ERROR;
1854: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1856: END IF;
1857:
1858:
1859: END IF;

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

1887: p_end_date_active => l_end_date_active,
1888: p_accounting_code => l_accounting_code,
1889: x_return_status => x_return_status);
1890:
1891: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1892:
1893:
1894: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1895: fnd_msg_pub.add;

Line 1897: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1893:
1894: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1895: fnd_msg_pub.add;
1896:
1897: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1898: RAISE FND_API.G_EXC_ERROR;
1899: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1901: END IF;

Line 1898: RAISE FND_API.G_EXC_ERROR;

1894: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1895: fnd_msg_pub.add;
1896:
1897: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1898: RAISE FND_API.G_EXC_ERROR;
1899: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1901: END IF;
1902:

Line 1899: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1895: fnd_msg_pub.add;
1896:
1897: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1898: RAISE FND_API.G_EXC_ERROR;
1899: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1901: END IF;
1902:
1903: END IF;

Line 1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1896:
1897: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1898: RAISE FND_API.G_EXC_ERROR;
1899: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1901: END IF;
1902:
1903: END IF;
1904:

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

1945: p_bind_data_id => l_bind_data_id,
1946: x_return_code => x_return_status);
1947:
1948:
1949: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1950:
1951: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1952:
1953:

Line 1957: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1953:
1954: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1955: fnd_msg_pub.add;
1956:
1957: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1958: RAISE FND_API.G_EXC_ERROR;
1959: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1961: END IF;

Line 1958: RAISE FND_API.G_EXC_ERROR;

1954: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1955: fnd_msg_pub.add;
1956:
1957: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1958: RAISE FND_API.G_EXC_ERROR;
1959: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1961: END IF;
1962:

Line 1959: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1955: fnd_msg_pub.add;
1956:
1957: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1958: RAISE FND_API.G_EXC_ERROR;
1959: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1961: END IF;
1962:
1963: END IF;

Line 1960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1956:
1957: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1958: RAISE FND_API.G_EXC_ERROR;
1959: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1961: END IF;
1962:
1963: END IF;
1964:

Line 1971: IF fnd_api.to_boolean(p_commit) THEN

1967: END IF;
1968: END IF;
1969:
1970:
1971: IF fnd_api.to_boolean(p_commit) THEN
1972:
1973: COMMIT WORK;
1974:
1975: END IF;

Line 1982: WHEN fnd_api.g_exc_error THEN

1978:
1979:
1980: EXCEPTION
1981:
1982: WHEN fnd_api.g_exc_error THEN
1983: ROLLBACK TO update_resource_group_pvt;
1984: x_return_status := fnd_api.g_ret_sts_error;
1985: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1986: p_data => x_msg_data);

Line 1984: x_return_status := fnd_api.g_ret_sts_error;

1980: EXCEPTION
1981:
1982: WHEN fnd_api.g_exc_error THEN
1983: ROLLBACK TO update_resource_group_pvt;
1984: x_return_status := fnd_api.g_ret_sts_error;
1985: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1986: p_data => x_msg_data);
1987: WHEN fnd_api.g_exc_unexpected_error THEN
1988: ROLLBACK TO update_resource_group_pvt;

Line 1987: WHEN fnd_api.g_exc_unexpected_error THEN

1983: ROLLBACK TO update_resource_group_pvt;
1984: x_return_status := fnd_api.g_ret_sts_error;
1985: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1986: p_data => x_msg_data);
1987: WHEN fnd_api.g_exc_unexpected_error THEN
1988: ROLLBACK TO update_resource_group_pvt;
1989: x_return_status := fnd_api.g_ret_sts_unexp_error;
1990: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1991: p_data => x_msg_data);

Line 1989: x_return_status := fnd_api.g_ret_sts_unexp_error;

1985: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1986: p_data => x_msg_data);
1987: WHEN fnd_api.g_exc_unexpected_error THEN
1988: ROLLBACK TO update_resource_group_pvt;
1989: x_return_status := fnd_api.g_ret_sts_unexp_error;
1990: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1991: p_data => x_msg_data);
1992: WHEN OTHERS THEN
1993: ROLLBACK TO update_resource_group_pvt;

Line 1999: x_return_status := fnd_api.g_ret_sts_unexp_error;

1995: fnd_message.set_token('P_SQLCODE',SQLCODE);
1996: fnd_message.set_token('P_SQLERRM',SQLERRM);
1997: fnd_message.set_token('P_API_NAME', l_api_name);
1998: FND_MSG_PUB.add;
1999: x_return_status := fnd_api.g_ret_sts_unexp_error;
2000: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2001: p_data => x_msg_data);
2002:
2003: END update_resource_group;