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:
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;
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:
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;
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;
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:
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;
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;
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:
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;
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');
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:
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;
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:
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:
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:
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');
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;
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:
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;
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;
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:
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;
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');
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:
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;
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;
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:
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;
556: NULL;
557: END;
558:
559:
560: IF fnd_api.to_boolean(p_commit) THEN
561:
562: COMMIT WORK;
563:
564: END IF;
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 ======= ======== ');
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:
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:
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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
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 ;
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:
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 ;
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;
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
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;
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 */
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;
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;
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:
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;
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;
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:
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;
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;
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:
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 */
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
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:
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 ;
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 ;
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;
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;
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;
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:
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;
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;
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:
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;
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;
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:
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;
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;
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;
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);
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
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) ;
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. */
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:
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;
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:
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;
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;
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:
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;
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;
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:
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;
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');
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:
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;
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;
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:
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
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
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;
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;
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:
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:
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:
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:
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;
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:
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;
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;
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:
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;
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;
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:
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;
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;
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:
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;
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;
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 ======= ======== ');
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:
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: