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

Line 91: x_return_status := fnd_api.g_ret_sts_success;

87: l_resource_type := upper(p_resource_type);
88:
89: SAVEPOINT create_resource_member_pvt;
90:
91: x_return_status := fnd_api.g_ret_sts_success;
92:
93: -- DBMS_OUTPUT.put_line(' Started Create Resource Member Pvt ');
94:
95:

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

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

Line 98: RAISE fnd_api.g_exc_unexpected_error;

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

Line 103: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

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

130: p_team_resource_id => l_team_resource_id,
131: p_resource_type => l_resource_type,
132: x_return_status => x_return_status);
133:
134: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
135:
136: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
137:
138: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 138: x_return_status := fnd_api.g_ret_sts_unexp_error;

134: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
135:
136: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
137:
138: x_return_status := fnd_api.g_ret_sts_unexp_error;
139:
140: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
141: fnd_msg_pub.add;
142:

Line 143: RAISE fnd_api.g_exc_unexpected_error;

139:
140: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
141: fnd_msg_pub.add;
142:
143: RAISE fnd_api.g_exc_unexpected_error;
144:
145: END IF;
146:
147: END IF;

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

168: p_team_resource_id => l_team_resource_id,
169: p_resource_type => l_resource_type,
170: x_return_status => x_return_status);
171:
172: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
173:
174: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
175:
176: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 176: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 181: RAISE fnd_api.g_exc_unexpected_error;

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

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

206: p_team_resource_id => l_team_resource_id,
207: p_resource_type => l_resource_type,
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 241: x_return_status := fnd_api.g_ret_sts_error;

237: IF l_check_count > 0 THEN
238:
239: -- dbms_output.put_line('Resource already exists in the team');
240:
241: x_return_status := fnd_api.g_ret_sts_error;
242:
243: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_EXISTS_TEAM');
244: fnd_msg_pub.add;
245:

Line 246: RAISE fnd_api.g_exc_unexpected_error;

242:
243: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_EXISTS_TEAM');
244: fnd_msg_pub.add;
245:
246: RAISE fnd_api.g_exc_unexpected_error;
247:
248: END IF;
249:
250:

Line 323: x_return_status := fnd_api.g_ret_sts_unexp_error;

319: IF c_jtf_rs_team_members%NOTFOUND THEN
320:
321: -- dbms_output.put_line('Error in Table Handler');
322:
323: x_return_status := fnd_api.g_ret_sts_unexp_error;
324:
325: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
326: fnd_msg_pub.add;
327:

Line 334: RAISE fnd_api.g_exc_unexpected_error;

330: CLOSE c_jtf_rs_team_members;
331:
332: END IF;
333:
334: RAISE fnd_api.g_exc_unexpected_error;
335:
336: ELSE
337:
338: -- dbms_output.put_line('Team Member Successfully Created');

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

380: p_team_resource_id => l_team_resource_id,
381: p_resource_type => l_resource_type,
382: x_return_status => x_return_status);
383:
384: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
385:
386: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
387:
388: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 388: x_return_status := fnd_api.g_ret_sts_unexp_error;

384: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
385:
386: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
387:
388: x_return_status := fnd_api.g_ret_sts_unexp_error;
389:
390: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
391: fnd_msg_pub.add;
392:

Line 393: RAISE fnd_api.g_exc_unexpected_error;

389:
390: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
391: fnd_msg_pub.add;
392:
393: RAISE fnd_api.g_exc_unexpected_error;
394:
395: END IF;
396:
397: END IF;

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

419: p_team_resource_id => l_team_resource_id,
420: p_resource_type => l_resource_type,
421: x_return_status => x_return_status);
422:
423: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
424:
425: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
426:
427: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 427: x_return_status := fnd_api.g_ret_sts_unexp_error;

423: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
424:
425: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
426:
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428:
429: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
430: fnd_msg_pub.add;
431:

Line 432: RAISE fnd_api.g_exc_unexpected_error;

428:
429: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
430: fnd_msg_pub.add;
431:
432: RAISE fnd_api.g_exc_unexpected_error;
433:
434: END IF;
435:
436: END IF;

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

458: p_team_resource_id => l_team_resource_id,
459: p_resource_type => l_resource_type,
460: x_return_status => x_return_status);
461:
462: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
463:
464: x_return_status := fnd_api.g_ret_sts_unexp_error;
465:
466: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

Line 464: x_return_status := fnd_api.g_ret_sts_unexp_error;

460: x_return_status => x_return_status);
461:
462: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
463:
464: x_return_status := fnd_api.g_ret_sts_unexp_error;
465:
466: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
467: fnd_msg_pub.add;
468:

Line 469: RAISE fnd_api.g_exc_unexpected_error;

465:
466: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
467: fnd_msg_pub.add;
468:
469: RAISE fnd_api.g_exc_unexpected_error;
470:
471: END IF;
472:
473: END IF;

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

513: p_bind_data_id => l_bind_data_id,
514: x_return_code => x_return_status);
515:
516:
517: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
518:
519: -- dbms_output.put_line('Returned Error status from the Message Generation API');
520:
521: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 521: x_return_status := fnd_api.g_ret_sts_unexp_error;

517: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
518:
519: -- dbms_output.put_line('Returned Error status from the Message Generation API');
520:
521: x_return_status := fnd_api.g_ret_sts_unexp_error;
522:
523: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
524: fnd_msg_pub.add;
525:

Line 526: RAISE fnd_api.g_exc_unexpected_error;

522:
523: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
524: fnd_msg_pub.add;
525:
526: RAISE fnd_api.g_exc_unexpected_error;
527:
528: END IF;
529:
530: END IF;

Line 560: IF fnd_api.to_boolean(p_commit) THEN

556: NULL;
557: END;
558:
559:
560: IF fnd_api.to_boolean(p_commit) THEN
561:
562: COMMIT WORK;
563:
564: END IF;

Line 572: WHEN fnd_api.g_exc_unexpected_error THEN

568:
569: EXCEPTION
570:
571:
572: WHEN fnd_api.g_exc_unexpected_error THEN
573:
574: -- DBMS_OUTPUT.put_line (' ========================================== ');
575:
576: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');

Line 580: x_return_status := fnd_api.g_ret_sts_unexp_error;

576: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');
577:
578: ROLLBACK TO create_resource_member_pvt;
579:
580: x_return_status := fnd_api.g_ret_sts_unexp_error;
581:
582: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
583:
584:

Line 595: x_return_status := fnd_api.g_ret_sts_unexp_error;

591: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
592:
593: ROLLBACK TO create_resource_member_pvt;
594:
595: x_return_status := fnd_api.g_ret_sts_unexp_error;
596:
597: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
598:
599:

Line 669: SELECT DECODE(p_team_id, fnd_api.g_miss_num, team_id, p_team_id) l_team_id,

665: l_check_count NUMBER;
666: l_bind_data_id NUMBER;
667:
668: CURSOR c_rs_team_members_update(l_team_member_id IN NUMBER) IS
669: SELECT DECODE(p_team_id, fnd_api.g_miss_num, team_id, p_team_id) l_team_id,
670: DECODE(p_team_resource_id, fnd_api.g_miss_num, team_resource_id, p_team_resource_id) l_team_resource_id,
671: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,
672: DECODE(p_resource_type, fnd_api.g_miss_char, resource_type, p_resource_type) l_resource_type,
673: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,

Line 670: DECODE(p_team_resource_id, fnd_api.g_miss_num, team_resource_id, p_team_resource_id) l_team_resource_id,

666: l_bind_data_id NUMBER;
667:
668: CURSOR c_rs_team_members_update(l_team_member_id IN NUMBER) IS
669: SELECT DECODE(p_team_id, fnd_api.g_miss_num, team_id, p_team_id) l_team_id,
670: DECODE(p_team_resource_id, fnd_api.g_miss_num, team_resource_id, p_team_resource_id) l_team_resource_id,
671: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,
672: DECODE(p_resource_type, fnd_api.g_miss_char, resource_type, p_resource_type) l_resource_type,
673: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
674: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,

Line 671: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,

667:
668: CURSOR c_rs_team_members_update(l_team_member_id IN NUMBER) IS
669: SELECT DECODE(p_team_id, fnd_api.g_miss_num, team_id, p_team_id) l_team_id,
670: DECODE(p_team_resource_id, fnd_api.g_miss_num, team_resource_id, p_team_resource_id) l_team_resource_id,
671: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,
672: DECODE(p_resource_type, fnd_api.g_miss_char, resource_type, p_resource_type) l_resource_type,
673: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
674: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
675: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,

Line 672: DECODE(p_resource_type, fnd_api.g_miss_char, resource_type, p_resource_type) l_resource_type,

668: CURSOR c_rs_team_members_update(l_team_member_id IN NUMBER) IS
669: SELECT DECODE(p_team_id, fnd_api.g_miss_num, team_id, p_team_id) l_team_id,
670: DECODE(p_team_resource_id, fnd_api.g_miss_num, team_resource_id, p_team_resource_id) l_team_resource_id,
671: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,
672: DECODE(p_resource_type, fnd_api.g_miss_char, resource_type, p_resource_type) l_resource_type,
673: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
674: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
675: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
676: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,

Line 673: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,

669: SELECT DECODE(p_team_id, fnd_api.g_miss_num, team_id, p_team_id) l_team_id,
670: DECODE(p_team_resource_id, fnd_api.g_miss_num, team_resource_id, p_team_resource_id) l_team_resource_id,
671: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,
672: DECODE(p_resource_type, fnd_api.g_miss_char, resource_type, p_resource_type) l_resource_type,
673: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
674: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
675: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
676: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
677: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,

Line 674: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,

670: DECODE(p_team_resource_id, fnd_api.g_miss_num, team_resource_id, p_team_resource_id) l_team_resource_id,
671: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,
672: DECODE(p_resource_type, fnd_api.g_miss_char, resource_type, p_resource_type) l_resource_type,
673: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
674: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
675: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
676: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
677: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
678: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,

Line 675: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,

671: DECODE(p_person_id, fnd_api.g_miss_num, person_id, p_person_id) l_person_id,
672: DECODE(p_resource_type, fnd_api.g_miss_char, resource_type, p_resource_type) l_resource_type,
673: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
674: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
675: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
676: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
677: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
678: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
679: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,

Line 676: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,

672: DECODE(p_resource_type, fnd_api.g_miss_char, resource_type, p_resource_type) l_resource_type,
673: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
674: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
675: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
676: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
677: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
678: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
679: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
680: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,

Line 677: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,

673: DECODE(p_delete_flag, fnd_api.g_miss_char, delete_flag, p_delete_flag) l_delete_flag,
674: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
675: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
676: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
677: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
678: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
679: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
680: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
681: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,

Line 678: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,

674: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
675: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
676: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
677: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
678: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
679: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
680: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
681: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
682: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,

Line 679: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,

675: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
676: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
677: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
678: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
679: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
680: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
681: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
682: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
683: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,

Line 680: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,

676: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
677: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
678: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
679: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
680: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
681: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
682: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
683: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
684: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,

Line 681: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,

677: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
678: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
679: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
680: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
681: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
682: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
683: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
684: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
685: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,

Line 682: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,

678: DECODE(p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
679: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
680: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
681: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
682: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
683: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
684: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
685: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
686: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,

Line 683: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,

679: DECODE(p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
680: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
681: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
682: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
683: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
684: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
685: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
686: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
687: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,

Line 684: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,

680: DECODE(p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
681: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
682: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
683: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
684: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
685: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
686: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
687: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
688: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,

Line 685: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,

681: DECODE(p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
682: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
683: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
684: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
685: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
686: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
687: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
688: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
689: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) l_attribute_category

Line 686: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,

682: DECODE(p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
683: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
684: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
685: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
686: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
687: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
688: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
689: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) l_attribute_category
690: FROM jtf_rs_team_members

Line 687: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,

683: DECODE(p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
684: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
685: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
686: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
687: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
688: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
689: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) l_attribute_category
690: FROM jtf_rs_team_members
691: WHERE team_member_id = l_team_member_id ;

Line 688: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,

684: DECODE(p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
685: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
686: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
687: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
688: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
689: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) l_attribute_category
690: FROM jtf_rs_team_members
691: WHERE team_member_id = l_team_member_id ;
692:

Line 689: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) l_attribute_category

685: DECODE(p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
686: DECODE(p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
687: DECODE(p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
688: DECODE(p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
689: DECODE(p_attribute_category, fnd_api.g_miss_char, attribute_category, p_attribute_category) l_attribute_category
690: FROM jtf_rs_team_members
691: WHERE team_member_id = l_team_member_id ;
692:
693: rs_team_member_rec c_rs_team_members_update%ROWTYPE ;

Line 722: x_return_status := fnd_api.g_ret_sts_success;

718: l_attribute15 := p_attribute15 ;
719: l_attribute_catgory := p_attribute_category ;
720:
721: SAVEPOINT update_resource_member_pvt;
722: x_return_status := fnd_api.g_ret_sts_success;
723:
724: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
725: RAISE fnd_api.g_exc_unexpected_error;
726: END IF;

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

720:
721: SAVEPOINT update_resource_member_pvt;
722: x_return_status := fnd_api.g_ret_sts_success;
723:
724: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
725: RAISE fnd_api.g_exc_unexpected_error;
726: END IF;
727:
728: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 725: RAISE fnd_api.g_exc_unexpected_error;

721: SAVEPOINT update_resource_member_pvt;
722: x_return_status := fnd_api.g_ret_sts_success;
723:
724: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
725: RAISE fnd_api.g_exc_unexpected_error;
726: END IF;
727:
728: IF fnd_api.to_boolean(p_init_msg_list) THEN
729: fnd_msg_pub.initialize;

Line 728: IF fnd_api.to_boolean(p_init_msg_list) THEN

724: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
725: RAISE fnd_api.g_exc_unexpected_error;
726: END IF;
727:
728: IF fnd_api.to_boolean(p_init_msg_list) THEN
729: fnd_msg_pub.initialize;
730: END IF;
731:
732: /* Make the pre processing call to the user hooks */

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

748: jtf_rs_team_member_cuhk.update_team_members_pre(
749: p_team_member_id => l_team_member_id,
750: x_return_status => x_return_status);
751:
752: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
753: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
754: x_return_status := fnd_api.g_ret_sts_unexp_error;
755: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
756: fnd_msg_pub.add;

Line 754: x_return_status := fnd_api.g_ret_sts_unexp_error;

750: x_return_status => x_return_status);
751:
752: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
753: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
754: x_return_status := fnd_api.g_ret_sts_unexp_error;
755: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
756: fnd_msg_pub.add;
757: RAISE fnd_api.g_exc_unexpected_error;
758: END IF;

Line 757: RAISE fnd_api.g_exc_unexpected_error;

753: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
754: x_return_status := fnd_api.g_ret_sts_unexp_error;
755: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
756: fnd_msg_pub.add;
757: RAISE fnd_api.g_exc_unexpected_error;
758: END IF;
759: END IF;
760: END IF;
761:

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

776: jtf_rs_team_member_vuhk.update_team_members_pre(
777: p_team_member_id => l_team_member_id,
778: x_return_status => x_return_status);
779:
780: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
781: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
782: x_return_status := fnd_api.g_ret_sts_unexp_error;
783: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
784: fnd_msg_pub.add;

Line 782: x_return_status := fnd_api.g_ret_sts_unexp_error;

778: x_return_status => x_return_status);
779:
780: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
781: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
782: x_return_status := fnd_api.g_ret_sts_unexp_error;
783: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
784: fnd_msg_pub.add;
785: RAISE fnd_api.g_exc_unexpected_error;
786: END IF;

Line 785: RAISE fnd_api.g_exc_unexpected_error;

781: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
782: x_return_status := fnd_api.g_ret_sts_unexp_error;
783: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
784: fnd_msg_pub.add;
785: RAISE fnd_api.g_exc_unexpected_error;
786: END IF;
787: END IF;
788: END IF;
789:

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

803: THEN
804: jtf_rs_team_member_iuhk.update_team_members_pre(
805: p_team_member_id => l_team_member_id,
806: x_return_status => x_return_status);
807: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
808: x_return_status := fnd_api.g_ret_sts_unexp_error;
809: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
810: fnd_msg_pub.add;
811: RAISE fnd_api.g_exc_unexpected_error;

Line 808: x_return_status := fnd_api.g_ret_sts_unexp_error;

804: jtf_rs_team_member_iuhk.update_team_members_pre(
805: p_team_member_id => l_team_member_id,
806: x_return_status => x_return_status);
807: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
808: x_return_status := fnd_api.g_ret_sts_unexp_error;
809: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
810: fnd_msg_pub.add;
811: RAISE fnd_api.g_exc_unexpected_error;
812: END IF;

Line 811: RAISE fnd_api.g_exc_unexpected_error;

807: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
808: x_return_status := fnd_api.g_ret_sts_unexp_error;
809: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
810: fnd_msg_pub.add;
811: RAISE fnd_api.g_exc_unexpected_error;
812: END IF;
813: END IF;
814: END IF;
815:

Line 826: x_return_status := fnd_api.g_ret_sts_unexp_error;

822: CLOSE c_rs_team_members_update ;
823: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TEAM_MBR_ID');
824: fnd_message.set_token('P_TEAM_MBR_ID', p_team_member_id);
825: fnd_msg_pub.add;
826: x_return_status := fnd_api.g_ret_sts_unexp_error;
827: RAISE fnd_api.g_exc_unexpected_error;
828: END IF ;
829:
830: /* Call the Lock Row Table Handler before updating the record */

Line 827: RAISE fnd_api.g_exc_unexpected_error;

823: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TEAM_MBR_ID');
824: fnd_message.set_token('P_TEAM_MBR_ID', p_team_member_id);
825: fnd_msg_pub.add;
826: x_return_status := fnd_api.g_ret_sts_unexp_error;
827: RAISE fnd_api.g_exc_unexpected_error;
828: END IF ;
829:
830: /* Call the Lock Row Table Handler before updating the record */
831: BEGIN

Line 837: x_return_status := fnd_api.g_ret_sts_unexp_error;

833: x_team_member_id => l_team_member_id,
834: x_object_version_number => l_object_version_number) ;
835: EXCEPTION
836: WHEN OTHERS THEN
837: x_return_status := fnd_api.g_ret_sts_unexp_error;
838:
839: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
840: fnd_msg_pub.add;
841:

Line 842: RAISE fnd_api.g_exc_unexpected_error;

838:
839: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
840: fnd_msg_pub.add;
841:
842: RAISE fnd_api.g_exc_unexpected_error;
843: END;
844:
845: /* Update the Object Version Number by Incrementing It */
846: l_object_version_number := l_object_version_number + 1 ;

Line 885: x_return_status := fnd_api.g_ret_sts_unexp_error ;

881:
882: EXCEPTION
883: WHEN NO_DATA_FOUND THEN
884: CLOSE c_rs_team_members_update ;
885: x_return_status := fnd_api.g_ret_sts_unexp_error ;
886: fnd_message.set_name('JTF','JTF_RS_TABLE_HANDLER_ERROR') ;
887: fnd_msg_pub.add ;
888: RAISE fnd_api.g_exc_unexpected_error ;
889: END ;

Line 888: RAISE fnd_api.g_exc_unexpected_error ;

884: CLOSE c_rs_team_members_update ;
885: x_return_status := fnd_api.g_ret_sts_unexp_error ;
886: fnd_message.set_name('JTF','JTF_RS_TABLE_HANDLER_ERROR') ;
887: fnd_msg_pub.add ;
888: RAISE fnd_api.g_exc_unexpected_error ;
889: END ;
890:
891: IF c_rs_team_members_update%ISOPEN THEN
892: CLOSE c_rs_team_members_update;

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

911: jtf_rs_team_member_cuhk.update_team_members_post(
912: p_team_member_id => l_team_member_id,
913: x_return_status => x_return_status);
914:
915: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
916: x_return_status := fnd_api.g_ret_sts_unexp_error;
917: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
918: fnd_msg_pub.add;
919: RAISE fnd_api.g_exc_unexpected_error;

Line 916: x_return_status := fnd_api.g_ret_sts_unexp_error;

912: p_team_member_id => l_team_member_id,
913: x_return_status => x_return_status);
914:
915: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
916: x_return_status := fnd_api.g_ret_sts_unexp_error;
917: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
918: fnd_msg_pub.add;
919: RAISE fnd_api.g_exc_unexpected_error;
920: END IF;

Line 919: RAISE fnd_api.g_exc_unexpected_error;

915: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
916: x_return_status := fnd_api.g_ret_sts_unexp_error;
917: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
918: fnd_msg_pub.add;
919: RAISE fnd_api.g_exc_unexpected_error;
920: END IF;
921: END IF;
922: END IF;
923:

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

938: jtf_rs_team_member_vuhk.update_team_members_post(
939: p_team_member_id => l_team_member_id,
940: x_return_status => x_return_status);
941:
942: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
943: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
944: x_return_status := fnd_api.g_ret_sts_unexp_error;
945: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
946: fnd_msg_pub.add;

Line 944: x_return_status := fnd_api.g_ret_sts_unexp_error;

940: x_return_status => x_return_status);
941:
942: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
943: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
944: x_return_status := fnd_api.g_ret_sts_unexp_error;
945: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
946: fnd_msg_pub.add;
947: RAISE fnd_api.g_exc_unexpected_error;
948: END IF;

Line 947: RAISE fnd_api.g_exc_unexpected_error;

943: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
944: x_return_status := fnd_api.g_ret_sts_unexp_error;
945: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
946: fnd_msg_pub.add;
947: RAISE fnd_api.g_exc_unexpected_error;
948: END IF;
949: END IF;
950: END IF;
951:

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

966: jtf_rs_team_member_iuhk.update_team_members_post(
967: p_team_member_id => l_team_member_id,
968: x_return_status => x_return_status);
969:
970: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
971: x_return_status := fnd_api.g_ret_sts_unexp_error;
972: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
973: fnd_msg_pub.add;
974: RAISE fnd_api.g_exc_unexpected_error;

Line 971: x_return_status := fnd_api.g_ret_sts_unexp_error;

967: p_team_member_id => l_team_member_id,
968: x_return_status => x_return_status);
969:
970: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
971: x_return_status := fnd_api.g_ret_sts_unexp_error;
972: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
973: fnd_msg_pub.add;
974: RAISE fnd_api.g_exc_unexpected_error;
975: END IF;

Line 974: RAISE fnd_api.g_exc_unexpected_error;

970: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
971: x_return_status := fnd_api.g_ret_sts_unexp_error;
972: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
973: fnd_msg_pub.add;
974: RAISE fnd_api.g_exc_unexpected_error;
975: END IF;
976: END IF;
977: END IF;
978:

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

1013: p_bind_data_id => l_bind_data_id,
1014: x_return_code => x_return_status);
1015:
1016:
1017: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1018: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1019: x_return_status := fnd_api.g_ret_sts_unexp_error;
1020: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1021: fnd_msg_pub.add;

Line 1019: x_return_status := fnd_api.g_ret_sts_unexp_error;

1015:
1016:
1017: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1018: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1019: x_return_status := fnd_api.g_ret_sts_unexp_error;
1020: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1021: fnd_msg_pub.add;
1022: RAISE fnd_api.g_exc_unexpected_error;
1023: END IF;

Line 1022: RAISE fnd_api.g_exc_unexpected_error;

1018: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1019: x_return_status := fnd_api.g_ret_sts_unexp_error;
1020: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1021: fnd_msg_pub.add;
1022: RAISE fnd_api.g_exc_unexpected_error;
1023: END IF;
1024: END IF;
1025: END IF;
1026: END IF;

Line 1028: IF fnd_api.to_boolean(p_commit) THEN

1024: END IF;
1025: END IF;
1026: END IF;
1027:
1028: IF fnd_api.to_boolean(p_commit) THEN
1029: COMMIT WORK;
1030: END IF;
1031:
1032: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1035: WHEN fnd_api.g_exc_unexpected_error THEN

1031:
1032: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1033:
1034: EXCEPTION
1035: WHEN fnd_api.g_exc_unexpected_error THEN
1036: ROLLBACK TO update_resource_member_pvt;
1037: x_return_status := fnd_api.g_ret_sts_unexp_error;
1038: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1039: WHEN OTHERS THEN

Line 1037: x_return_status := fnd_api.g_ret_sts_unexp_error;

1033:
1034: EXCEPTION
1035: WHEN fnd_api.g_exc_unexpected_error THEN
1036: ROLLBACK TO update_resource_member_pvt;
1037: x_return_status := fnd_api.g_ret_sts_unexp_error;
1038: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1039: WHEN OTHERS THEN
1040: ROLLBACK TO update_resource_member_pvt;
1041: fnd_message.set_token('P_SQLCODE',SQLCODE) ;

Line 1045: x_return_status := fnd_api.g_ret_sts_unexp_error;

1041: fnd_message.set_token('P_SQLCODE',SQLCODE) ;
1042: fnd_message.set_token('P_SQLERRM',SQLERRM) ;
1043: fnd_message.set_token('P_API_NAME',l_api_name) ;
1044: fnd_msg_pub.add ;
1045: x_return_status := fnd_api.g_ret_sts_unexp_error;
1046: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1047: END update_resource_team_members;
1048:
1049: /* Procedure to delete the resource team members. */

Line 1111: x_return_status := fnd_api.g_ret_sts_success;

1107: l_resource_type := upper(p_resource_type);
1108:
1109: SAVEPOINT delete_resource_member_pvt;
1110:
1111: x_return_status := fnd_api.g_ret_sts_success;
1112:
1113: -- DBMS_OUTPUT.put_line(' Started Delete Resource Member Pvt ');
1114:
1115:

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

1112:
1113: -- DBMS_OUTPUT.put_line(' Started Delete Resource Member Pvt ');
1114:
1115:
1116: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1117:
1118: RAISE fnd_api.g_exc_unexpected_error;
1119:
1120: END IF;

Line 1118: RAISE fnd_api.g_exc_unexpected_error;

1114:
1115:
1116: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1117:
1118: RAISE fnd_api.g_exc_unexpected_error;
1119:
1120: END IF;
1121:
1122:

Line 1123: IF fnd_api.to_boolean(p_init_msg_list) THEN

1119:
1120: END IF;
1121:
1122:
1123: IF fnd_api.to_boolean(p_init_msg_list) THEN
1124:
1125: fnd_msg_pub.initialize;
1126:
1127: END IF;

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

1149: p_team_resource_id => l_team_resource_id,
1150: p_resource_type => l_resource_type,
1151: x_return_status => x_return_status);
1152:
1153: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1154:
1155: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
1156:
1157: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1157: x_return_status := fnd_api.g_ret_sts_unexp_error;

1153: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1154:
1155: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
1156:
1157: x_return_status := fnd_api.g_ret_sts_unexp_error;
1158:
1159: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1160: fnd_msg_pub.add;
1161:

Line 1162: RAISE fnd_api.g_exc_unexpected_error;

1158:
1159: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1160: fnd_msg_pub.add;
1161:
1162: RAISE fnd_api.g_exc_unexpected_error;
1163:
1164: END IF;
1165:
1166: END IF;

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

1187: p_team_resource_id => l_team_resource_id,
1188: p_resource_type => l_resource_type,
1189: x_return_status => x_return_status);
1190:
1191: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1192:
1193: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
1194:
1195: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1195: x_return_status := fnd_api.g_ret_sts_unexp_error;

1191: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1192:
1193: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
1194:
1195: x_return_status := fnd_api.g_ret_sts_unexp_error;
1196:
1197: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1198: fnd_msg_pub.add;
1199:

Line 1200: RAISE fnd_api.g_exc_unexpected_error;

1196:
1197: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1198: fnd_msg_pub.add;
1199:
1200: RAISE fnd_api.g_exc_unexpected_error;
1201:
1202: END IF;
1203:
1204: END IF;

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

1225: p_team_resource_id => l_team_resource_id,
1226: p_resource_type => l_resource_type,
1227: x_return_status => x_return_status);
1228:
1229: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1230:
1231: x_return_status := fnd_api.g_ret_sts_unexp_error;
1232:
1233: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

Line 1231: x_return_status := fnd_api.g_ret_sts_unexp_error;

1227: x_return_status => x_return_status);
1228:
1229: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1230:
1231: x_return_status := fnd_api.g_ret_sts_unexp_error;
1232:
1233: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1234: fnd_msg_pub.add;
1235:

Line 1236: RAISE fnd_api.g_exc_unexpected_error;

1232:
1233: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1234: fnd_msg_pub.add;
1235:
1236: RAISE fnd_api.g_exc_unexpected_error;
1237:
1238: END IF;
1239:
1240: END IF;

Line 1266: x_return_status := fnd_api.g_ret_sts_unexp_error;

1262: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TEAM_MEMBER');
1263: fnd_message.set_token('P_TEAM_RESOURCE_ID', l_team_resource_id);
1264: fnd_msg_pub.add;
1265:
1266: x_return_status := fnd_api.g_ret_sts_unexp_error;
1267:
1268: RAISE fnd_api.g_exc_unexpected_error;
1269:
1270: END IF;

Line 1268: RAISE fnd_api.g_exc_unexpected_error;

1264: fnd_msg_pub.add;
1265:
1266: x_return_status := fnd_api.g_ret_sts_unexp_error;
1267:
1268: RAISE fnd_api.g_exc_unexpected_error;
1269:
1270: END IF;
1271:
1272:

Line 1303: x_return_status := fnd_api.g_ret_sts_unexp_error;

1299:
1300: fnd_message.set_name('JTF', 'JTF_RS_ERROR_ROLE_COUNT');
1301: fnd_msg_pub.add;
1302:
1303: x_return_status := fnd_api.g_ret_sts_unexp_error;
1304:
1305: RAISE fnd_api.g_exc_unexpected_error;
1306:
1307: ELSE

Line 1305: RAISE fnd_api.g_exc_unexpected_error;

1301: fnd_msg_pub.add;
1302:
1303: x_return_status := fnd_api.g_ret_sts_unexp_error;
1304:
1305: RAISE fnd_api.g_exc_unexpected_error;
1306:
1307: ELSE
1308:
1309: IF l_role_relate_count > 0 THEN

Line 1322: x_return_status := fnd_api.g_ret_sts_unexp_error;

1318:
1319: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TEAM_ROLE_EXIST');
1320: fnd_msg_pub.add;
1321:
1322: x_return_status := fnd_api.g_ret_sts_unexp_error;
1323:
1324: RAISE fnd_api.g_exc_unexpected_error;
1325:
1326: END IF;

Line 1324: RAISE fnd_api.g_exc_unexpected_error;

1320: fnd_msg_pub.add;
1321:
1322: x_return_status := fnd_api.g_ret_sts_unexp_error;
1323:
1324: RAISE fnd_api.g_exc_unexpected_error;
1325:
1326: END IF;
1327:
1328: END IF;

Line 1348: x_return_status := fnd_api.g_ret_sts_unexp_error;

1344: WHEN OTHERS THEN
1345:
1346: -- dbms_output.put_line('Error in Locking the Row');
1347:
1348: x_return_status := fnd_api.g_ret_sts_unexp_error;
1349:
1350: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1351: fnd_msg_pub.add;
1352:

Line 1353: RAISE fnd_api.g_exc_unexpected_error;

1349:
1350: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1351: fnd_msg_pub.add;
1352:
1353: RAISE fnd_api.g_exc_unexpected_error;
1354:
1355: END;
1356:
1357:

Line 1399: x_return_status := fnd_api.g_ret_sts_unexp_error;

1395: WHEN NO_DATA_FOUND THEN
1396:
1397: -- dbms_output.put_line('Error in Table Handler');
1398:
1399: x_return_status := fnd_api.g_ret_sts_unexp_error;
1400:
1401: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1402: fnd_msg_pub.add;
1403:

Line 1404: RAISE fnd_api.g_exc_unexpected_error;

1400:
1401: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1402: fnd_msg_pub.add;
1403:
1404: RAISE fnd_api.g_exc_unexpected_error;
1405:
1406: END;
1407:
1408:

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

1428: p_team_resource_id => l_team_resource_id,
1429: p_resource_type => l_resource_type,
1430: x_return_status => x_return_status);
1431:
1432: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1433:
1434: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1435:
1436: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1436: x_return_status := fnd_api.g_ret_sts_unexp_error;

1432: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1433:
1434: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1435:
1436: x_return_status := fnd_api.g_ret_sts_unexp_error;
1437:
1438: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1439: fnd_msg_pub.add;
1440:

Line 1441: RAISE fnd_api.g_exc_unexpected_error;

1437:
1438: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1439: fnd_msg_pub.add;
1440:
1441: RAISE fnd_api.g_exc_unexpected_error;
1442:
1443: END IF;
1444:
1445: END IF;

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

1466: p_team_resource_id => l_team_resource_id,
1467: p_resource_type => l_resource_type,
1468: x_return_status => x_return_status);
1469:
1470: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1471:
1472: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
1473:
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1474: x_return_status := fnd_api.g_ret_sts_unexp_error;

1470: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1471:
1472: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
1473:
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475:
1476: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1477: fnd_msg_pub.add;
1478:

Line 1479: RAISE fnd_api.g_exc_unexpected_error;

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

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

1504: p_team_resource_id => l_team_resource_id,
1505: p_resource_type => l_resource_type,
1506: x_return_status => x_return_status);
1507:
1508: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1509:
1510: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1511:
1512: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1512: x_return_status := fnd_api.g_ret_sts_unexp_error;

1508: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1509:
1510: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1511:
1512: x_return_status := fnd_api.g_ret_sts_unexp_error;
1513:
1514: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1515: fnd_msg_pub.add;
1516:

Line 1517: RAISE fnd_api.g_exc_unexpected_error;

1513:
1514: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1515: fnd_msg_pub.add;
1516:
1517: RAISE fnd_api.g_exc_unexpected_error;
1518:
1519: END IF;
1520:
1521: END IF;

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

1561: p_bind_data_id => l_bind_data_id,
1562: x_return_code => x_return_status);
1563:
1564:
1565: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1566:
1567: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1568:
1569: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1569: x_return_status := fnd_api.g_ret_sts_unexp_error;

1565: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1566:
1567: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1568:
1569: x_return_status := fnd_api.g_ret_sts_unexp_error;
1570:
1571: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1572: fnd_msg_pub.add;
1573:

Line 1574: RAISE fnd_api.g_exc_unexpected_error;

1570:
1571: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1572: fnd_msg_pub.add;
1573:
1574: RAISE fnd_api.g_exc_unexpected_error;
1575:
1576: END IF;
1577:
1578: END IF;

Line 1584: IF fnd_api.to_boolean(p_commit) THEN

1580: END IF;
1581: END IF;
1582:
1583:
1584: IF fnd_api.to_boolean(p_commit) THEN
1585:
1586: COMMIT WORK;
1587:
1588: END IF;

Line 1596: WHEN fnd_api.g_exc_unexpected_error THEN

1592:
1593: EXCEPTION
1594:
1595:
1596: WHEN fnd_api.g_exc_unexpected_error THEN
1597:
1598: -- DBMS_OUTPUT.put_line (' ========================================== ');
1599:
1600: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');

Line 1604: x_return_status := fnd_api.g_ret_sts_unexp_error;

1600: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');
1601:
1602: ROLLBACK TO delete_resource_member_pvt;
1603:
1604: x_return_status := fnd_api.g_ret_sts_unexp_error;
1605:
1606: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1607:
1608:

Line 1619: x_return_status := fnd_api.g_ret_sts_unexp_error;

1615: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
1616:
1617: ROLLBACK TO delete_resource_member_pvt;
1618:
1619: x_return_status := fnd_api.g_ret_sts_unexp_error;
1620:
1621: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1622:
1623: