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

Line 83: x_return_status := fnd_api.g_ret_sts_success;

79:
80:
81: SAVEPOINT create_resource_team_pvt;
82:
83: x_return_status := fnd_api.g_ret_sts_success;
84:
85: -- DBMS_OUTPUT.put_line(' Started Create Resource Team Pvt ');
86:
87:

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

84:
85: -- DBMS_OUTPUT.put_line(' Started Create Resource Team Pvt ');
86:
87:
88: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
89:
90: RAISE fnd_api.g_exc_unexpected_error;
91:
92: END IF;

Line 90: RAISE fnd_api.g_exc_unexpected_error;

86:
87:
88: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
89:
90: RAISE fnd_api.g_exc_unexpected_error;
91:
92: END IF;
93:
94:

Line 95: IF fnd_api.to_boolean(p_init_msg_list) THEN

91:
92: END IF;
93:
94:
95: IF fnd_api.to_boolean(p_init_msg_list) THEN
96:
97: fnd_msg_pub.initialize;
98:
99: END IF;

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

124: p_start_date_active => l_start_date_active,
125: p_end_date_active => l_end_date_active,
126: x_return_status => x_return_status);
127:
128: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
129:
130: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
131:
132: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 132: x_return_status := fnd_api.g_ret_sts_unexp_error;

128: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
129:
130: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
131:
132: x_return_status := fnd_api.g_ret_sts_unexp_error;
133:
134: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
135: fnd_msg_pub.add;
136:

Line 137: RAISE fnd_api.g_exc_unexpected_error;

133:
134: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
135: fnd_msg_pub.add;
136:
137: RAISE fnd_api.g_exc_unexpected_error;
138:
139: END IF;
140:
141: END IF;

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

165: p_start_date_active => l_start_date_active,
166: p_end_date_active => l_end_date_active,
167: x_return_status => x_return_status);
168:
169: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
170:
171: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
172:
173: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 173: x_return_status := fnd_api.g_ret_sts_unexp_error;

169: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
170:
171: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
172:
173: x_return_status := fnd_api.g_ret_sts_unexp_error;
174:
175: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
176: fnd_msg_pub.add;
177:

Line 178: RAISE fnd_api.g_exc_unexpected_error;

174:
175: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
176: fnd_msg_pub.add;
177:
178: RAISE fnd_api.g_exc_unexpected_error;
179:
180: END IF;
181:
182: END IF;

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

206: p_start_date_active => l_start_date_active,
207: p_end_date_active => l_end_date_active,
208: x_return_status => x_return_status);
209:
210: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
211:
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213:
214: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

Line 212: x_return_status := fnd_api.g_ret_sts_unexp_error;

208: x_return_status => x_return_status);
209:
210: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
211:
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213:
214: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
215: fnd_msg_pub.add;
216:

Line 217: RAISE fnd_api.g_exc_unexpected_error;

213:
214: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
215: fnd_msg_pub.add;
216:
217: RAISE fnd_api.g_exc_unexpected_error;
218:
219: END IF;
220:
221: END IF;

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

229: p_end_date_active => l_end_date_active,
230: x_return_status => x_return_status
231: );
232:
233: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
234:
235: x_return_status := fnd_api.g_ret_sts_unexp_error;
236:
237: RAISE fnd_api.g_exc_unexpected_error;

Line 235: x_return_status := fnd_api.g_ret_sts_unexp_error;

231: );
232:
233: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
234:
235: x_return_status := fnd_api.g_ret_sts_unexp_error;
236:
237: RAISE fnd_api.g_exc_unexpected_error;
238:
239: END IF;

Line 237: RAISE fnd_api.g_exc_unexpected_error;

233: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
234:
235: x_return_status := fnd_api.g_ret_sts_unexp_error;
236:
237: RAISE fnd_api.g_exc_unexpected_error;
238:
239: END IF;
240:
241:

Line 310: x_return_status := fnd_api.g_ret_sts_unexp_error;

306: CLOSE c_jtf_rs_teams;
307:
308: END IF;
309:
310: x_return_status := fnd_api.g_ret_sts_unexp_error;
311:
312: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
313: fnd_msg_pub.add;
314:

Line 315: RAISE fnd_api.g_exc_unexpected_error;

311:
312: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
313: fnd_msg_pub.add;
314:
315: RAISE fnd_api.g_exc_unexpected_error;
316:
317: ELSE
318:
319: -- dbms_output.put_line('Team Successfully Created');

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

360: p_start_date_active => l_start_date_active,
361: p_end_date_active => l_end_date_active,
362: x_return_status => x_return_status);
363:
364: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
365:
366: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
367:
368: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 368: x_return_status := fnd_api.g_ret_sts_unexp_error;

364: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
365:
366: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
367:
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369:
370: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
371: fnd_msg_pub.add;
372:

Line 373: RAISE fnd_api.g_exc_unexpected_error;

369:
370: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
371: fnd_msg_pub.add;
372:
373: RAISE fnd_api.g_exc_unexpected_error;
374:
375: END IF;
376:
377: END IF;

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

402: p_start_date_active => l_start_date_active,
403: p_end_date_active => l_end_date_active,
404: x_return_status => x_return_status);
405:
406: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
407:
408: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
409:
410: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 410: x_return_status := fnd_api.g_ret_sts_unexp_error;

406: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
407:
408: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
409:
410: x_return_status := fnd_api.g_ret_sts_unexp_error;
411:
412: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
413: fnd_msg_pub.add;
414:

Line 415: RAISE fnd_api.g_exc_unexpected_error;

411:
412: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
413: fnd_msg_pub.add;
414:
415: RAISE fnd_api.g_exc_unexpected_error;
416:
417: END IF;
418:
419: END IF;

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

444: p_start_date_active => l_start_date_active,
445: p_end_date_active => l_end_date_active,
446: x_return_status => x_return_status);
447:
448: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
449:
450: x_return_status := fnd_api.g_ret_sts_unexp_error;
451:
452: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

Line 450: x_return_status := fnd_api.g_ret_sts_unexp_error;

446: x_return_status => x_return_status);
447:
448: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
449:
450: x_return_status := fnd_api.g_ret_sts_unexp_error;
451:
452: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
453: fnd_msg_pub.add;
454:

Line 455: RAISE fnd_api.g_exc_unexpected_error;

451:
452: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
453: fnd_msg_pub.add;
454:
455: RAISE fnd_api.g_exc_unexpected_error;
456:
457: END IF;
458:
459: END IF;

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

499: p_bind_data_id => l_bind_data_id,
500: x_return_code => x_return_status);
501:
502:
503: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
504:
505: -- dbms_output.put_line('Returned Error status from the Message Generation API');
506:
507: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 507: x_return_status := fnd_api.g_ret_sts_unexp_error;

503: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
504:
505: -- dbms_output.put_line('Returned Error status from the Message Generation API');
506:
507: x_return_status := fnd_api.g_ret_sts_unexp_error;
508:
509: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
510: fnd_msg_pub.add;
511:

Line 512: RAISE fnd_api.g_exc_unexpected_error;

508:
509: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
510: fnd_msg_pub.add;
511:
512: RAISE fnd_api.g_exc_unexpected_error;
513:
514: END IF;
515:
516: END IF;

Line 540: IF fnd_api.to_boolean(p_commit) THEN

536: NULL;
537: END;
538:
539:
540: IF fnd_api.to_boolean(p_commit) THEN
541:
542: COMMIT WORK;
543:
544: END IF;

Line 552: WHEN fnd_api.g_exc_unexpected_error THEN

548:
549: EXCEPTION
550:
551:
552: WHEN fnd_api.g_exc_unexpected_error THEN
553:
554: -- DBMS_OUTPUT.put_line (' ========================================== ');
555:
556: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');

Line 560: x_return_status := fnd_api.g_ret_sts_unexp_error;

556: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');
557:
558: ROLLBACK TO create_resource_team_pvt;
559:
560: x_return_status := fnd_api.g_ret_sts_unexp_error;
561:
562: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
563:
564:

Line 575: x_return_status := fnd_api.g_ret_sts_unexp_error;

571: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
572:
573: ROLLBACK TO create_resource_team_pvt;
574:
575: x_return_status := fnd_api.g_ret_sts_unexp_error;
576:
577: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
578:
579:

Line 644: DECODE(p_team_name, fnd_api.g_miss_char, team_name, p_team_name) team_name,

640: l_team_id IN NUMBER )
641: IS
642: SELECT
643: team_number,
644: DECODE(p_team_name, fnd_api.g_miss_char, team_name, p_team_name) team_name,
645: DECODE(p_team_desc, fnd_api.g_miss_char, team_desc, p_team_desc) team_desc,
646: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
647: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
648: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,

Line 645: DECODE(p_team_desc, fnd_api.g_miss_char, team_desc, p_team_desc) team_desc,

641: IS
642: SELECT
643: team_number,
644: DECODE(p_team_name, fnd_api.g_miss_char, team_name, p_team_name) team_name,
645: DECODE(p_team_desc, fnd_api.g_miss_char, team_desc, p_team_desc) team_desc,
646: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
647: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
648: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
649: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,

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

642: SELECT
643: team_number,
644: DECODE(p_team_name, fnd_api.g_miss_char, team_name, p_team_name) team_name,
645: DECODE(p_team_desc, fnd_api.g_miss_char, team_desc, p_team_desc) team_desc,
646: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
647: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
648: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
649: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
650: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,

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

643: team_number,
644: DECODE(p_team_name, fnd_api.g_miss_char, team_name, p_team_name) team_name,
645: DECODE(p_team_desc, fnd_api.g_miss_char, team_desc, p_team_desc) team_desc,
646: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
647: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
648: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
649: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
650: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
651: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,

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

644: DECODE(p_team_name, fnd_api.g_miss_char, team_name, p_team_name) team_name,
645: DECODE(p_team_desc, fnd_api.g_miss_char, team_desc, p_team_desc) team_desc,
646: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
647: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
648: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
649: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
650: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
651: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
652: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,

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

645: DECODE(p_team_desc, fnd_api.g_miss_char, team_desc, p_team_desc) team_desc,
646: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
647: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
648: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
649: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
650: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
651: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
652: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
653: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,

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

646: DECODE(p_exclusive_flag, fnd_api.g_miss_char, exclusive_flag, NULL, 'N', p_exclusive_flag) exclusive_flag,
647: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
648: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
649: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
650: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
651: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
652: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
653: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
654: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,

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

647: DECODE(p_email_address, fnd_api.g_miss_char, email_address, p_email_address) email_address,
648: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
649: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
650: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
651: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
652: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
653: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
654: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
655: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,

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

648: DECODE(p_start_date_active, fnd_api.g_miss_date, start_date_active, trunc(p_start_date_active)) start_date_active,
649: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
650: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
651: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
652: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
653: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
654: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
655: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
656: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,

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

649: DECODE(p_end_date_active, fnd_api.g_miss_date, end_date_active, trunc(p_end_date_active)) end_date_active,
650: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
651: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
652: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
653: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
654: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
655: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
656: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
657: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,

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

650: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
651: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
652: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
653: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
654: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
655: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
656: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
657: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
658: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,

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

651: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
652: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
653: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
654: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
655: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
656: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
657: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
658: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
659: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,

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

652: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
653: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
654: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
655: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
656: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
657: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
658: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
659: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
660: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,

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

653: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,
654: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
655: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
656: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
657: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
658: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
659: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
660: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
661: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,

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

654: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) attribute5,
655: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
656: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
657: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
658: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
659: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
660: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
661: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
662: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,

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

655: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) attribute6,
656: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
657: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
658: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
659: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
660: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
661: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
662: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
663: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,

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

656: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) attribute7,
657: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
658: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
659: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
660: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
661: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
662: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
663: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
664: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,

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

657: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) attribute8,
658: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
659: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
660: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
661: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
662: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
663: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
664: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
665: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category

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

658: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) attribute9,
659: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
660: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
661: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
662: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
663: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
664: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
665: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category
666: FROM jtf_rs_teams_vl

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

659: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) attribute10,
660: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
661: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
662: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
663: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
664: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
665: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category
666: FROM jtf_rs_teams_vl
667: WHERE team_id = l_team_id;

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

660: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) attribute11,
661: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
662: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
663: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
664: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
665: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category
666: FROM jtf_rs_teams_vl
667: WHERE team_id = l_team_id;
668:

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

661: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) attribute12,
662: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) attribute13,
663: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) attribute14,
664: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) attribute15,
665: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) attribute_category
666: FROM jtf_rs_teams_vl
667: WHERE team_id = l_team_id;
668:
669: team_rec c_team_update%ROWTYPE;

Line 767: x_return_status := fnd_api.g_ret_sts_success;

763:
764:
765: SAVEPOINT update_resource_team_pvt;
766:
767: x_return_status := fnd_api.g_ret_sts_success;
768:
769: -- DBMS_OUTPUT.put_line(' Started Update Resource Team Pvt ');
770:
771:

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

768:
769: -- DBMS_OUTPUT.put_line(' Started Update Resource Team Pvt ');
770:
771:
772: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
773:
774: RAISE fnd_api.g_exc_unexpected_error;
775:
776: END IF;

Line 774: RAISE fnd_api.g_exc_unexpected_error;

770:
771:
772: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
773:
774: RAISE fnd_api.g_exc_unexpected_error;
775:
776: END IF;
777:
778:

Line 779: IF fnd_api.to_boolean(p_init_msg_list) THEN

775:
776: END IF;
777:
778:
779: IF fnd_api.to_boolean(p_init_msg_list) THEN
780:
781: fnd_msg_pub.initialize;
782:
783: END IF;

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

809: p_start_date_active => l_start_date_active,
810: p_end_date_active => l_end_date_active,
811: x_return_status => x_return_status);
812:
813: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
814:
815: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
816:
817: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 817: x_return_status := fnd_api.g_ret_sts_unexp_error;

813: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
814:
815: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
816:
817: x_return_status := fnd_api.g_ret_sts_unexp_error;
818:
819: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
820: fnd_msg_pub.add;
821:

Line 822: RAISE fnd_api.g_exc_unexpected_error;

818:
819: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
820: fnd_msg_pub.add;
821:
822: RAISE fnd_api.g_exc_unexpected_error;
823:
824: END IF;
825:
826: END IF;

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

851: p_start_date_active => l_start_date_active,
852: p_end_date_active => l_end_date_active,
853: x_return_status => x_return_status);
854:
855: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
856:
857: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
858:
859: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 859: x_return_status := fnd_api.g_ret_sts_unexp_error;

855: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
856:
857: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
858:
859: x_return_status := fnd_api.g_ret_sts_unexp_error;
860:
861: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
862: fnd_msg_pub.add;
863:

Line 864: RAISE fnd_api.g_exc_unexpected_error;

860:
861: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
862: fnd_msg_pub.add;
863:
864: RAISE fnd_api.g_exc_unexpected_error;
865:
866: END IF;
867:
868: END IF;

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

893: p_start_date_active => l_start_date_active,
894: p_end_date_active => l_end_date_active,
895: x_return_status => x_return_status);
896:
897: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
898:
899: x_return_status := fnd_api.g_ret_sts_unexp_error;
900:
901: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

Line 899: x_return_status := fnd_api.g_ret_sts_unexp_error;

895: x_return_status => x_return_status);
896:
897: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
898:
899: x_return_status := fnd_api.g_ret_sts_unexp_error;
900:
901: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
902: fnd_msg_pub.add;
903:

Line 904: RAISE fnd_api.g_exc_unexpected_error;

900:
901: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
902: fnd_msg_pub.add;
903:
904: RAISE fnd_api.g_exc_unexpected_error;
905:
906: END IF;
907:
908: END IF;

Line 929: x_return_status := fnd_api.g_ret_sts_unexp_error;

925: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TEAM');
926: fnd_message.set_token('P_TEAM_ID', l_team_id);
927: fnd_msg_pub.add;
928:
929: x_return_status := fnd_api.g_ret_sts_unexp_error;
930:
931: RAISE fnd_api.g_exc_unexpected_error;
932:
933: END IF;

Line 931: RAISE fnd_api.g_exc_unexpected_error;

927: fnd_msg_pub.add;
928:
929: x_return_status := fnd_api.g_ret_sts_unexp_error;
930:
931: RAISE fnd_api.g_exc_unexpected_error;
932:
933: END IF;
934:
935:

Line 945: x_return_status := fnd_api.g_ret_sts_unexp_error;

941:
942: fnd_message.set_name('JTF', 'JTF_RS_TEAM_NAME_NULL');
943: fnd_msg_pub.add;
944:
945: x_return_status := fnd_api.g_ret_sts_unexp_error;
946:
947: RAISE fnd_api.g_exc_unexpected_error;
948:
949: END IF;

Line 947: RAISE fnd_api.g_exc_unexpected_error;

943: fnd_msg_pub.add;
944:
945: x_return_status := fnd_api.g_ret_sts_unexp_error;
946:
947: RAISE fnd_api.g_exc_unexpected_error;
948:
949: END IF;
950:
951:

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

960: p_end_date_active => l_end_date_active,
961: x_return_status => x_return_status
962: );
963:
964: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
965:
966: x_return_status := fnd_api.g_ret_sts_unexp_error;
967:
968: RAISE fnd_api.g_exc_unexpected_error;

Line 966: x_return_status := fnd_api.g_ret_sts_unexp_error;

962: );
963:
964: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
965:
966: x_return_status := fnd_api.g_ret_sts_unexp_error;
967:
968: RAISE fnd_api.g_exc_unexpected_error;
969:
970: END IF;

Line 968: RAISE fnd_api.g_exc_unexpected_error;

964: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
965:
966: x_return_status := fnd_api.g_ret_sts_unexp_error;
967:
968: RAISE fnd_api.g_exc_unexpected_error;
969:
970: END IF;
971:
972:

Line 992: x_return_status := fnd_api.g_ret_sts_unexp_error;

988:
989: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_START_DATE');
990: fnd_msg_pub.add;
991:
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993:
994: RAISE fnd_api.g_exc_unexpected_error;
995:
996: END IF;

Line 994: RAISE fnd_api.g_exc_unexpected_error;

990: fnd_msg_pub.add;
991:
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993:
994: RAISE fnd_api.g_exc_unexpected_error;
995:
996: END IF;
997:
998: IF ( l_max_end_date > l_end_date_active AND l_end_date_active IS NOT NULL ) THEN

Line 1003: x_return_status := fnd_api.g_ret_sts_unexp_error;

999:
1000: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_END_DATE');
1001: fnd_msg_pub.add;
1002:
1003: x_return_status := fnd_api.g_ret_sts_unexp_error;
1004:
1005: RAISE fnd_api.g_exc_unexpected_error;
1006:
1007: END IF;

Line 1005: RAISE fnd_api.g_exc_unexpected_error;

1001: fnd_msg_pub.add;
1002:
1003: x_return_status := fnd_api.g_ret_sts_unexp_error;
1004:
1005: RAISE fnd_api.g_exc_unexpected_error;
1006:
1007: END IF;
1008:
1009: END IF;

Line 1037: x_return_status := fnd_api.g_ret_sts_unexp_error;

1033:
1034: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_START_DATE');
1035: fnd_msg_pub.add;
1036:
1037: x_return_status := fnd_api.g_ret_sts_unexp_error;
1038:
1039: RAISE fnd_api.g_exc_unexpected_error;
1040:
1041: END IF;

Line 1039: RAISE fnd_api.g_exc_unexpected_error;

1035: fnd_msg_pub.add;
1036:
1037: x_return_status := fnd_api.g_ret_sts_unexp_error;
1038:
1039: RAISE fnd_api.g_exc_unexpected_error;
1040:
1041: END IF;
1042:
1043: IF l_end_date_active IS NOT NULL THEN

Line 1048: x_return_status := fnd_api.g_ret_sts_unexp_error;

1044:
1045: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_END_DATE');
1046: fnd_msg_pub.add;
1047:
1048: x_return_status := fnd_api.g_ret_sts_unexp_error;
1049:
1050: RAISE fnd_api.g_exc_unexpected_error;
1051:
1052: END IF;

Line 1050: RAISE fnd_api.g_exc_unexpected_error;

1046: fnd_msg_pub.add;
1047:
1048: x_return_status := fnd_api.g_ret_sts_unexp_error;
1049:
1050: RAISE fnd_api.g_exc_unexpected_error;
1051:
1052: END IF;
1053:
1054: END IF;

Line 1085: x_return_status := fnd_api.g_ret_sts_unexp_error;

1081:
1082: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_START_DATE');
1083: fnd_msg_pub.add;
1084:
1085: x_return_status := fnd_api.g_ret_sts_unexp_error;
1086:
1087: RAISE fnd_api.g_exc_unexpected_error;
1088:
1089: END IF;

Line 1087: RAISE fnd_api.g_exc_unexpected_error;

1083: fnd_msg_pub.add;
1084:
1085: x_return_status := fnd_api.g_ret_sts_unexp_error;
1086:
1087: RAISE fnd_api.g_exc_unexpected_error;
1088:
1089: END IF;
1090:
1091: IF ( l_max_end_date > l_end_date_active AND l_end_date_active IS NOT NULL ) THEN

Line 1096: x_return_status := fnd_api.g_ret_sts_unexp_error;

1092:
1093: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_END_DATE');
1094: fnd_msg_pub.add;
1095:
1096: x_return_status := fnd_api.g_ret_sts_unexp_error;
1097:
1098: RAISE fnd_api.g_exc_unexpected_error;
1099:
1100: END IF;

Line 1098: RAISE fnd_api.g_exc_unexpected_error;

1094: fnd_msg_pub.add;
1095:
1096: x_return_status := fnd_api.g_ret_sts_unexp_error;
1097:
1098: RAISE fnd_api.g_exc_unexpected_error;
1099:
1100: END IF;
1101:
1102: END IF;

Line 1130: x_return_status := fnd_api.g_ret_sts_unexp_error;

1126:
1127: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_START_DATE');
1128: fnd_msg_pub.add;
1129:
1130: x_return_status := fnd_api.g_ret_sts_unexp_error;
1131:
1132: RAISE fnd_api.g_exc_unexpected_error;
1133:
1134: END IF;

Line 1132: RAISE fnd_api.g_exc_unexpected_error;

1128: fnd_msg_pub.add;
1129:
1130: x_return_status := fnd_api.g_ret_sts_unexp_error;
1131:
1132: RAISE fnd_api.g_exc_unexpected_error;
1133:
1134: END IF;
1135:
1136: IF l_end_date_active IS NOT NULL THEN

Line 1141: x_return_status := fnd_api.g_ret_sts_unexp_error;

1137:
1138: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_END_DATE');
1139: fnd_msg_pub.add;
1140:
1141: x_return_status := fnd_api.g_ret_sts_unexp_error;
1142:
1143: RAISE fnd_api.g_exc_unexpected_error;
1144:
1145: END IF;

Line 1143: RAISE fnd_api.g_exc_unexpected_error;

1139: fnd_msg_pub.add;
1140:
1141: x_return_status := fnd_api.g_ret_sts_unexp_error;
1142:
1143: RAISE fnd_api.g_exc_unexpected_error;
1144:
1145: END IF;
1146:
1147: END IF;

Line 1182: x_return_status := fnd_api.g_ret_sts_unexp_error;

1178: CLOSE c_exclusive_team_check;
1179:
1180: END IF;
1181:
1182: x_return_status := fnd_api.g_ret_sts_unexp_error;
1183:
1184: fnd_message.set_name('JTF', 'JTF_RS_EXCLUSIVE_TEAM_ERR');
1185: fnd_msg_pub.add;
1186:

Line 1187: RAISE fnd_api.g_exc_unexpected_error;

1183:
1184: fnd_message.set_name('JTF', 'JTF_RS_EXCLUSIVE_TEAM_ERR');
1185: fnd_msg_pub.add;
1186:
1187: RAISE fnd_api.g_exc_unexpected_error;
1188:
1189: END IF;
1190:
1191:

Line 1218: x_return_status := fnd_api.g_ret_sts_unexp_error;

1214: WHEN OTHERS THEN
1215:
1216: -- dbms_output.put_line('Error in Locking the Row');
1217:
1218: x_return_status := fnd_api.g_ret_sts_unexp_error;
1219:
1220: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1221: fnd_msg_pub.add;
1222:

Line 1223: RAISE fnd_api.g_exc_unexpected_error;

1219:
1220: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1221: fnd_msg_pub.add;
1222:
1223: RAISE fnd_api.g_exc_unexpected_error;
1224:
1225: END;
1226:
1227:

Line 1308: x_return_status := fnd_api.g_ret_sts_unexp_error;

1304: CLOSE c_team_update;
1305:
1306: END IF;
1307:
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;
1309:
1310: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1311: fnd_msg_pub.add;
1312:

Line 1313: RAISE fnd_api.g_exc_unexpected_error;

1309:
1310: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1311: fnd_msg_pub.add;
1312:
1313: RAISE fnd_api.g_exc_unexpected_error;
1314:
1315: END;
1316:
1317: -- dbms_output.put_line('Team Successfully Updated');

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

1352: p_start_date_active => l_start_date_active,
1353: p_end_date_active => l_end_date_active,
1354: x_return_status => x_return_status);
1355:
1356: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1357:
1358: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1359:
1360: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1360: x_return_status := fnd_api.g_ret_sts_unexp_error;

1356: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1357:
1358: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1359:
1360: x_return_status := fnd_api.g_ret_sts_unexp_error;
1361:
1362: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1363: fnd_msg_pub.add;
1364:

Line 1365: RAISE fnd_api.g_exc_unexpected_error;

1361:
1362: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1363: fnd_msg_pub.add;
1364:
1365: RAISE fnd_api.g_exc_unexpected_error;
1366:
1367: END IF;
1368:
1369: END IF;

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

1394: p_start_date_active => l_start_date_active,
1395: p_end_date_active => l_end_date_active,
1396: x_return_status => x_return_status);
1397:
1398: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1399:
1400: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
1401:
1402: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1402: x_return_status := fnd_api.g_ret_sts_unexp_error;

1398: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1399:
1400: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
1401:
1402: x_return_status := fnd_api.g_ret_sts_unexp_error;
1403:
1404: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1405: fnd_msg_pub.add;
1406:

Line 1407: RAISE fnd_api.g_exc_unexpected_error;

1403:
1404: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1405: fnd_msg_pub.add;
1406:
1407: RAISE fnd_api.g_exc_unexpected_error;
1408:
1409: END IF;
1410:
1411: END IF;

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

1436: p_start_date_active => l_start_date_active,
1437: p_end_date_active => l_end_date_active,
1438: x_return_status => x_return_status);
1439:
1440: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1441:
1442: x_return_status := fnd_api.g_ret_sts_unexp_error;
1443:
1444: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

Line 1442: x_return_status := fnd_api.g_ret_sts_unexp_error;

1438: x_return_status => x_return_status);
1439:
1440: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1441:
1442: x_return_status := fnd_api.g_ret_sts_unexp_error;
1443:
1444: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1445: fnd_msg_pub.add;
1446:

Line 1447: RAISE fnd_api.g_exc_unexpected_error;

1443:
1444: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1445: fnd_msg_pub.add;
1446:
1447: RAISE fnd_api.g_exc_unexpected_error;
1448:
1449: END IF;
1450:
1451: END IF;

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

1491: p_bind_data_id => l_bind_data_id,
1492: x_return_code => x_return_status);
1493:
1494:
1495: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1496:
1497: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1498:
1499: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1499: x_return_status := fnd_api.g_ret_sts_unexp_error;

1495: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1496:
1497: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1498:
1499: x_return_status := fnd_api.g_ret_sts_unexp_error;
1500:
1501: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1502: fnd_msg_pub.add;
1503:

Line 1504: RAISE fnd_api.g_exc_unexpected_error;

1500:
1501: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1502: fnd_msg_pub.add;
1503:
1504: RAISE fnd_api.g_exc_unexpected_error;
1505:
1506: END IF;
1507:
1508: END IF;

Line 1514: IF fnd_api.to_boolean(p_commit) THEN

1510: END IF;
1511: END IF;
1512:
1513:
1514: IF fnd_api.to_boolean(p_commit) THEN
1515:
1516: COMMIT WORK;
1517:
1518: END IF;

Line 1526: WHEN fnd_api.g_exc_unexpected_error THEN

1522:
1523: EXCEPTION
1524:
1525:
1526: WHEN fnd_api.g_exc_unexpected_error THEN
1527:
1528: -- DBMS_OUTPUT.put_line (' ========================================== ');
1529:
1530: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');

Line 1534: x_return_status := fnd_api.g_ret_sts_unexp_error;

1530: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');
1531:
1532: ROLLBACK TO update_resource_team_pvt;
1533:
1534: x_return_status := fnd_api.g_ret_sts_unexp_error;
1535:
1536: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1537:
1538:

Line 1549: x_return_status := fnd_api.g_ret_sts_unexp_error;

1545: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
1546:
1547: ROLLBACK TO update_resource_team_pvt;
1548:
1549: x_return_status := fnd_api.g_ret_sts_unexp_error;
1550:
1551: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1552:
1553: