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.CN_ROLE_PLANS_PUB dependencies on FND_API

Line 245: x_return_status := fnd_api.g_ret_sts_success;

241:
242: l_cp_rec l_cp_cur%ROWTYPE;
243: BEGIN
244: -- Initialize API return status to success
245: x_return_status := fnd_api.g_ret_sts_success;
246: x_loading_status := p_loading_status;
247:
248: -- Start of API body
249:

Line 258: ) = fnd_api.g_true

254: (p_char_para => p_role_plan_rec.role_name,
255: p_obj_name => g_role_name,
256: p_loading_status => x_loading_status,
257: x_loading_status => x_loading_status
258: ) = fnd_api.g_true
259: )
260: THEN
261: RAISE fnd_api.g_exc_error;
262: END IF;

Line 261: RAISE fnd_api.g_exc_error;

257: x_loading_status => x_loading_status
258: ) = fnd_api.g_true
259: )
260: THEN
261: RAISE fnd_api.g_exc_error;
262: END IF;
263:
264: -- comp_plan_name can not be missing or null
265: IF (cn_api.chk_miss_null_char_para

Line 270: ) = fnd_api.g_true

266: (p_char_para => p_role_plan_rec.comp_plan_name,
267: p_obj_name => g_cp_name,
268: p_loading_status => x_loading_status,
269: x_loading_status => x_loading_status
270: ) = fnd_api.g_true
271: )
272: THEN
273: RAISE fnd_api.g_exc_error;
274: END IF;

Line 273: RAISE fnd_api.g_exc_error;

269: x_loading_status => x_loading_status
270: ) = fnd_api.g_true
271: )
272: THEN
273: RAISE fnd_api.g_exc_error;
274: END IF;
275:
276: -- start_date can not be null
277: -- start_date can not be missing

Line 282: p_end_date_nullable => fnd_api.g_true,

278: -- start_date < end_date if end_date is null
279: IF ((cn_api.invalid_date_range
280: (p_start_date => p_role_plan_rec.start_date,
281: p_end_date => p_role_plan_rec.end_date,
282: p_end_date_nullable => fnd_api.g_true,
283: p_loading_status => x_loading_status,
284: x_loading_status => x_loading_status
285: )
286: ) = fnd_api.g_true

Line 286: ) = fnd_api.g_true

282: p_end_date_nullable => fnd_api.g_true,
283: p_loading_status => x_loading_status,
284: x_loading_status => x_loading_status
285: )
286: ) = fnd_api.g_true
287: )
288: THEN
289: RAISE fnd_api.g_exc_error;
290: END IF;

Line 289: RAISE fnd_api.g_exc_error;

285: )
286: ) = fnd_api.g_true
287: )
288: THEN
289: RAISE fnd_api.g_exc_error;
290: END IF;
291:
292: -- role_name must exist in cn_roles
293: IF NOT valid_role_name (p_role_plan_rec.role_name)

Line 303: RAISE fnd_api.g_exc_error;

299: fnd_msg_pub.ADD;
300: END IF;
301:
302: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
303: RAISE fnd_api.g_exc_error;
304: ELSE
305: -- CHANTHON: ORG_ID need not be passed here
306: x_role_id := cn_api.get_role_id (p_role_plan_rec.role_name);
307: END IF;

Line 324: RAISE fnd_api.g_exc_error;

320: fnd_msg_pub.ADD;
321: END IF;
322:
323: x_loading_status := 'CN_RL_ASGN_CP_NOT_EXIST';
324: RAISE fnd_api.g_exc_error;
325: ELSE
326: x_comp_plan_id :=
327: cn_api.get_cp_id (p_role_plan_rec.comp_plan_name,
328: p_role_plan_rec.org_id

Line 354: RAISE fnd_api.g_exc_error;

350: x_loading_status := 'CN_RL_ASGN_CP_NOT_EXIST';
351:
352: CLOSE l_cp_cur;
353:
354: RAISE fnd_api.g_exc_error;
355: ELSE
356: IF NOT cn_api.date_range_within (p_role_plan_rec.start_date,
357: p_role_plan_rec.end_date,
358: l_cp_rec.start_date,

Line 381: RAISE fnd_api.g_exc_error;

377: x_loading_status := 'CN_RL_CP_DATE_RANGE_NOT_WITHIN';
378:
379: CLOSE l_cp_cur;
380:
381: RAISE fnd_api.g_exc_error;
382: END IF;
383:
384: CLOSE l_cp_cur;
385: END IF;

Line 410: RAISE fnd_api.g_exc_error;

406: fnd_msg_pub.ADD;
407: END IF;
408:
409: x_loading_status := 'CN_RL_ROLE_PLAN_OVERLAP';
410: RAISE fnd_api.g_exc_error;
411: END IF;
412: END LOOP;
413:
414: -- End of API body.

Line 419: p_encoded => fnd_api.g_false

415:
416: -- Standard call to get message count and if count is 1, get message info.
417: fnd_msg_pub.count_and_get (p_count => x_msg_count,
418: p_data => x_msg_data,
419: p_encoded => fnd_api.g_false
420: );
421: EXCEPTION
422: WHEN fnd_api.g_exc_error
423: THEN

Line 422: WHEN fnd_api.g_exc_error

418: p_data => x_msg_data,
419: p_encoded => fnd_api.g_false
420: );
421: EXCEPTION
422: WHEN fnd_api.g_exc_error
423: THEN
424: x_return_status := fnd_api.g_ret_sts_error;
425: fnd_msg_pub.count_and_get (p_count => x_msg_count,
426: p_data => x_msg_data,

Line 424: x_return_status := fnd_api.g_ret_sts_error;

420: );
421: EXCEPTION
422: WHEN fnd_api.g_exc_error
423: THEN
424: x_return_status := fnd_api.g_ret_sts_error;
425: fnd_msg_pub.count_and_get (p_count => x_msg_count,
426: p_data => x_msg_data,
427: p_encoded => fnd_api.g_false
428: );

Line 427: p_encoded => fnd_api.g_false

423: THEN
424: x_return_status := fnd_api.g_ret_sts_error;
425: fnd_msg_pub.count_and_get (p_count => x_msg_count,
426: p_data => x_msg_data,
427: p_encoded => fnd_api.g_false
428: );
429: WHEN fnd_api.g_exc_unexpected_error
430: THEN
431: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 429: WHEN fnd_api.g_exc_unexpected_error

425: fnd_msg_pub.count_and_get (p_count => x_msg_count,
426: p_data => x_msg_data,
427: p_encoded => fnd_api.g_false
428: );
429: WHEN fnd_api.g_exc_unexpected_error
430: THEN
431: x_return_status := fnd_api.g_ret_sts_unexp_error;
432: x_loading_status := 'UNEXPECTED_ERR';
433: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 431: x_return_status := fnd_api.g_ret_sts_unexp_error;

427: p_encoded => fnd_api.g_false
428: );
429: WHEN fnd_api.g_exc_unexpected_error
430: THEN
431: x_return_status := fnd_api.g_ret_sts_unexp_error;
432: x_loading_status := 'UNEXPECTED_ERR';
433: fnd_msg_pub.count_and_get (p_count => x_msg_count,
434: p_data => x_msg_data,
435: p_encoded => fnd_api.g_false

Line 435: p_encoded => fnd_api.g_false

431: x_return_status := fnd_api.g_ret_sts_unexp_error;
432: x_loading_status := 'UNEXPECTED_ERR';
433: fnd_msg_pub.count_and_get (p_count => x_msg_count,
434: p_data => x_msg_data,
435: p_encoded => fnd_api.g_false
436: );
437: WHEN OTHERS
438: THEN
439: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 439: x_return_status := fnd_api.g_ret_sts_unexp_error;

435: p_encoded => fnd_api.g_false
436: );
437: WHEN OTHERS
438: THEN
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: x_loading_status := 'UNEXPECTED_ERR';
441:
442: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
443: THEN

Line 449: p_encoded => fnd_api.g_false

445: END IF;
446:
447: fnd_msg_pub.count_and_get (p_count => x_msg_count,
448: p_data => x_msg_data,
449: p_encoded => fnd_api.g_false
450: );
451: END check_valid_insert;
452:
453: -- ----------------------------------------------------------------------------*

Line 510: x_return_status := fnd_api.g_ret_sts_success;

506:
507: l_cp_rec l_cp_cur%ROWTYPE;
508: BEGIN
509: -- Initialize API return status to success
510: x_return_status := fnd_api.g_ret_sts_success;
511: x_loading_status := p_loading_status;
512: -- Start of API body
513:
514: -- validate the following issues

Line 534: RAISE fnd_api.g_exc_error;

530: fnd_msg_pub.ADD;
531: END IF;
532:
533: x_loading_status := 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST';
534: RAISE fnd_api.g_exc_error;
535: END IF;
536:
537: -- new role_name can not be null
538: -- note that new role_name can be missing

Line 544: ) = fnd_api.g_true

540: (p_char_para => p_role_plan_rec_new.role_name,
541: p_obj_name => g_role_name,
542: p_loading_status => x_loading_status,
543: x_loading_status => x_loading_status
544: ) = fnd_api.g_true
545: )
546: THEN
547: RAISE fnd_api.g_exc_error;
548: END IF;

Line 547: RAISE fnd_api.g_exc_error;

543: x_loading_status => x_loading_status
544: ) = fnd_api.g_true
545: )
546: THEN
547: RAISE fnd_api.g_exc_error;
548: END IF;
549:
550: -- new comp_plan_name can not be null
551: -- note that new comp_plan_name can be missing

Line 557: ) = fnd_api.g_true

553: (p_char_para => p_role_plan_rec_new.comp_plan_name,
554: p_obj_name => g_cp_name,
555: p_loading_status => x_loading_status,
556: x_loading_status => x_loading_status
557: ) = fnd_api.g_true
558: )
559: THEN
560: RAISE fnd_api.g_exc_error;
561: END IF;

Line 560: RAISE fnd_api.g_exc_error;

556: x_loading_status => x_loading_status
557: ) = fnd_api.g_true
558: )
559: THEN
560: RAISE fnd_api.g_exc_error;
561: END IF;
562:
563: -- new start_date can not be null
564: -- note that new start_date can be missing

Line 570: ) = fnd_api.g_true

566: (p_date_para => p_role_plan_rec_new.start_date,
567: p_obj_name => g_start_date,
568: p_loading_status => x_loading_status,
569: x_loading_status => x_loading_status
570: ) = fnd_api.g_true
571: )
572: THEN
573: RAISE fnd_api.g_exc_error;
574: END IF;

Line 573: RAISE fnd_api.g_exc_error;

569: x_loading_status => x_loading_status
570: ) = fnd_api.g_true
571: )
572: THEN
573: RAISE fnd_api.g_exc_error;
574: END IF;
575:
576: -- if new start_date is missing then
577: -- tmp_start_date := old start_date

Line 608: RAISE fnd_api.g_exc_error;

604: x_loading_status := 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST';
605:
606: CLOSE l_old_cur;
607:
608: RAISE fnd_api.g_exc_error;
609: ELSE
610: IF (p_role_plan_rec_new.start_date = fnd_api.g_miss_date)
611: THEN
612: tmp_start_date := l_old_rec.start_date;

Line 610: IF (p_role_plan_rec_new.start_date = fnd_api.g_miss_date)

606: CLOSE l_old_cur;
607:
608: RAISE fnd_api.g_exc_error;
609: ELSE
610: IF (p_role_plan_rec_new.start_date = fnd_api.g_miss_date)
611: THEN
612: tmp_start_date := l_old_rec.start_date;
613: ELSE
614: tmp_start_date := p_role_plan_rec_new.start_date;

Line 617: IF (p_role_plan_rec_new.end_date = fnd_api.g_miss_date)

613: ELSE
614: tmp_start_date := p_role_plan_rec_new.start_date;
615: END IF;
616:
617: IF (p_role_plan_rec_new.end_date = fnd_api.g_miss_date)
618: THEN
619: tmp_end_date := l_old_rec.end_date;
620: ELSE
621: tmp_end_date := p_role_plan_rec_new.end_date;

Line 638: RAISE fnd_api.g_exc_error;

634: x_loading_status := 'CN_RL_INVALID_DATE_RANGE';
635:
636: CLOSE l_old_cur;
637:
638: RAISE fnd_api.g_exc_error;
639: END IF;
640:
641: CLOSE l_old_cur;
642: END IF;

Line 658: RAISE fnd_api.g_exc_error;

654: fnd_msg_pub.ADD;
655: END IF;
656:
657: x_loading_status := 'CN_RP_CREATED_IN_SFP';
658: RAISE fnd_api.g_exc_error;
659: END IF;
660:
661: -- if new role_name is not missing then new role_name must exist in cn_roles
662: IF (p_role_plan_rec_new.role_name <> fnd_api.g_miss_char)

Line 662: IF (p_role_plan_rec_new.role_name <> fnd_api.g_miss_char)

658: RAISE fnd_api.g_exc_error;
659: END IF;
660:
661: -- if new role_name is not missing then new role_name must exist in cn_roles
662: IF (p_role_plan_rec_new.role_name <> fnd_api.g_miss_char)
663: THEN
664: x_role_id := cn_api.get_role_id (p_role_plan_rec_new.role_name);
665:
666: IF (x_role_id IS NULL)

Line 678: RAISE fnd_api.g_exc_error;

674: fnd_msg_pub.ADD;
675: END IF;
676:
677: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
678: RAISE fnd_api.g_exc_error;
679: END IF;
680: ELSE
681: OPEN l_old_cur (x_role_plan_id_old);
682:

Line 700: RAISE fnd_api.g_exc_error;

696: x_loading_status := 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST';
697:
698: CLOSE l_old_cur;
699:
700: RAISE fnd_api.g_exc_error;
701: ELSE
702: x_role_id := l_old_rec.role_id;
703:
704: CLOSE l_old_cur;

Line 710: IF (p_role_plan_rec_new.comp_plan_name <> fnd_api.g_miss_char)

706: END IF;
707:
708: -- if new comp_plan_name is not missing then
709: -- new comp_plan_name must exist in cn_comp_plans
710: IF (p_role_plan_rec_new.comp_plan_name <> fnd_api.g_miss_char)
711: THEN
712: x_comp_plan_id :=
713: cn_api.get_cp_id (p_role_plan_rec_new.comp_plan_name,
714: p_role_plan_rec_new.org_id

Line 729: RAISE fnd_api.g_exc_error;

725: fnd_msg_pub.ADD;
726: END IF;
727:
728: x_loading_status := 'CN_RL_ASGN_CP_NOT_EXIST';
729: RAISE fnd_api.g_exc_error;
730: END IF;
731: ELSE
732: OPEN l_old_cur (x_role_plan_id_old);
733:

Line 751: RAISE fnd_api.g_exc_error;

747: x_loading_status := 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST';
748:
749: CLOSE l_old_cur;
750:
751: RAISE fnd_api.g_exc_error;
752: ELSE
753: x_comp_plan_id := l_old_rec.comp_plan_id;
754:
755: CLOSE l_old_cur;

Line 772: RAISE fnd_api.g_exc_error;

768: x_loading_status := 'CN_RL_ASGN_CP_NOT_EXIST';
769:
770: CLOSE l_cp_cur;
771:
772: RAISE fnd_api.g_exc_error;
773: ELSE
774: IF NOT cn_api.date_range_within (tmp_start_date,
775: tmp_end_date,
776: l_cp_rec.start_date,

Line 797: RAISE fnd_api.g_exc_error;

793: x_loading_status := 'CN_RL_CP_DATE_RANGE_NOT_WITHIN';
794:
795: CLOSE l_cp_cur;
796:
797: RAISE fnd_api.g_exc_error;
798: END IF;
799:
800: CLOSE l_cp_cur;
801: END IF;

Line 829: RAISE fnd_api.g_exc_error;

825: fnd_msg_pub.ADD;
826: END IF;
827:
828: x_loading_status := 'CN_RL_ROLE_PLAN_OVERLAP';
829: RAISE fnd_api.g_exc_error;
830: END IF;
831: END LOOP;
832:
833: -- Checking if it is date_update_only

Line 847: RAISE fnd_api.g_exc_error;

843: x_loading_status := 'CN_RL_UPD_ROLE_PLAN_NOT_EXIST';
844:
845: CLOSE l_old_cur;
846:
847: RAISE fnd_api.g_exc_error;
848: ELSE
849: IF ( (x_role_id <> l_old_rec.role_id)
850: OR (x_comp_plan_id <> l_old_rec.comp_plan_id)
851: )

Line 853: x_date_update_only := fnd_api.g_false;

849: IF ( (x_role_id <> l_old_rec.role_id)
850: OR (x_comp_plan_id <> l_old_rec.comp_plan_id)
851: )
852: THEN
853: x_date_update_only := fnd_api.g_false;
854: ELSE
855: x_date_update_only := fnd_api.g_true;
856: END IF;
857:

Line 855: x_date_update_only := fnd_api.g_true;

851: )
852: THEN
853: x_date_update_only := fnd_api.g_false;
854: ELSE
855: x_date_update_only := fnd_api.g_true;
856: END IF;
857:
858: CLOSE l_old_cur;
859: END IF;

Line 866: p_encoded => fnd_api.g_false

862:
863: -- Standard call to get message count and if count is 1, get message info.
864: fnd_msg_pub.count_and_get (p_count => x_msg_count,
865: p_data => x_msg_data,
866: p_encoded => fnd_api.g_false
867: );
868: EXCEPTION
869: WHEN fnd_api.g_exc_error
870: THEN

Line 869: WHEN fnd_api.g_exc_error

865: p_data => x_msg_data,
866: p_encoded => fnd_api.g_false
867: );
868: EXCEPTION
869: WHEN fnd_api.g_exc_error
870: THEN
871: x_return_status := fnd_api.g_ret_sts_error;
872: fnd_msg_pub.count_and_get (p_count => x_msg_count,
873: p_data => x_msg_data,

Line 871: x_return_status := fnd_api.g_ret_sts_error;

867: );
868: EXCEPTION
869: WHEN fnd_api.g_exc_error
870: THEN
871: x_return_status := fnd_api.g_ret_sts_error;
872: fnd_msg_pub.count_and_get (p_count => x_msg_count,
873: p_data => x_msg_data,
874: p_encoded => fnd_api.g_false
875: );

Line 874: p_encoded => fnd_api.g_false

870: THEN
871: x_return_status := fnd_api.g_ret_sts_error;
872: fnd_msg_pub.count_and_get (p_count => x_msg_count,
873: p_data => x_msg_data,
874: p_encoded => fnd_api.g_false
875: );
876: WHEN fnd_api.g_exc_unexpected_error
877: THEN
878: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 876: WHEN fnd_api.g_exc_unexpected_error

872: fnd_msg_pub.count_and_get (p_count => x_msg_count,
873: p_data => x_msg_data,
874: p_encoded => fnd_api.g_false
875: );
876: WHEN fnd_api.g_exc_unexpected_error
877: THEN
878: x_return_status := fnd_api.g_ret_sts_unexp_error;
879: x_loading_status := 'UNEXPECTED_ERR';
880: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 878: x_return_status := fnd_api.g_ret_sts_unexp_error;

874: p_encoded => fnd_api.g_false
875: );
876: WHEN fnd_api.g_exc_unexpected_error
877: THEN
878: x_return_status := fnd_api.g_ret_sts_unexp_error;
879: x_loading_status := 'UNEXPECTED_ERR';
880: fnd_msg_pub.count_and_get (p_count => x_msg_count,
881: p_data => x_msg_data,
882: p_encoded => fnd_api.g_false

Line 882: p_encoded => fnd_api.g_false

878: x_return_status := fnd_api.g_ret_sts_unexp_error;
879: x_loading_status := 'UNEXPECTED_ERR';
880: fnd_msg_pub.count_and_get (p_count => x_msg_count,
881: p_data => x_msg_data,
882: p_encoded => fnd_api.g_false
883: );
884: WHEN OTHERS
885: THEN
886: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 886: x_return_status := fnd_api.g_ret_sts_unexp_error;

882: p_encoded => fnd_api.g_false
883: );
884: WHEN OTHERS
885: THEN
886: x_return_status := fnd_api.g_ret_sts_unexp_error;
887: x_loading_status := 'UNEXPECTED_ERR';
888:
889: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
890: THEN

Line 896: p_encoded => fnd_api.g_false

892: END IF;
893:
894: fnd_msg_pub.count_and_get (p_count => x_msg_count,
895: p_data => x_msg_data,
896: p_encoded => fnd_api.g_false
897: );
898: END check_valid_update;
899:
900: -- ----------------------------------------------------------------------------*

Line 918: x_return_status := fnd_api.g_ret_sts_success;

914: IS
915: l_api_name CONSTANT VARCHAR2 (30) := 'check_valid_delete';
916: BEGIN
917: -- Initialize API return status to success
918: x_return_status := fnd_api.g_ret_sts_success;
919: x_loading_status := p_loading_status;
920: -- Start of API body
921:
922: -- Valide the following issues

Line 942: RAISE fnd_api.g_exc_error;

938: fnd_msg_pub.ADD;
939: END IF;
940:
941: x_loading_status := 'CN_RL_DEL_ROLE_PLAN_NOT_EXIST';
942: RAISE fnd_api.g_exc_error;
943: END IF;
944:
945: -- End of API body.
946:

Line 950: p_encoded => fnd_api.g_false

946:
947: -- Standard call to get message count and if count is 1, get message info.
948: fnd_msg_pub.count_and_get (p_count => x_msg_count,
949: p_data => x_msg_data,
950: p_encoded => fnd_api.g_false
951: );
952: EXCEPTION
953: WHEN fnd_api.g_exc_error
954: THEN

Line 953: WHEN fnd_api.g_exc_error

949: p_data => x_msg_data,
950: p_encoded => fnd_api.g_false
951: );
952: EXCEPTION
953: WHEN fnd_api.g_exc_error
954: THEN
955: x_return_status := fnd_api.g_ret_sts_error;
956: fnd_msg_pub.count_and_get (p_count => x_msg_count,
957: p_data => x_msg_data,

Line 955: x_return_status := fnd_api.g_ret_sts_error;

951: );
952: EXCEPTION
953: WHEN fnd_api.g_exc_error
954: THEN
955: x_return_status := fnd_api.g_ret_sts_error;
956: fnd_msg_pub.count_and_get (p_count => x_msg_count,
957: p_data => x_msg_data,
958: p_encoded => fnd_api.g_false
959: );

Line 958: p_encoded => fnd_api.g_false

954: THEN
955: x_return_status := fnd_api.g_ret_sts_error;
956: fnd_msg_pub.count_and_get (p_count => x_msg_count,
957: p_data => x_msg_data,
958: p_encoded => fnd_api.g_false
959: );
960: WHEN fnd_api.g_exc_unexpected_error
961: THEN
962: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 960: WHEN fnd_api.g_exc_unexpected_error

956: fnd_msg_pub.count_and_get (p_count => x_msg_count,
957: p_data => x_msg_data,
958: p_encoded => fnd_api.g_false
959: );
960: WHEN fnd_api.g_exc_unexpected_error
961: THEN
962: x_return_status := fnd_api.g_ret_sts_unexp_error;
963: x_loading_status := 'UNEXPECTED_ERR';
964: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 962: x_return_status := fnd_api.g_ret_sts_unexp_error;

958: p_encoded => fnd_api.g_false
959: );
960: WHEN fnd_api.g_exc_unexpected_error
961: THEN
962: x_return_status := fnd_api.g_ret_sts_unexp_error;
963: x_loading_status := 'UNEXPECTED_ERR';
964: fnd_msg_pub.count_and_get (p_count => x_msg_count,
965: p_data => x_msg_data,
966: p_encoded => fnd_api.g_false

Line 966: p_encoded => fnd_api.g_false

962: x_return_status := fnd_api.g_ret_sts_unexp_error;
963: x_loading_status := 'UNEXPECTED_ERR';
964: fnd_msg_pub.count_and_get (p_count => x_msg_count,
965: p_data => x_msg_data,
966: p_encoded => fnd_api.g_false
967: );
968: WHEN OTHERS
969: THEN
970: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 970: x_return_status := fnd_api.g_ret_sts_unexp_error;

966: p_encoded => fnd_api.g_false
967: );
968: WHEN OTHERS
969: THEN
970: x_return_status := fnd_api.g_ret_sts_unexp_error;
971: x_loading_status := 'UNEXPECTED_ERR';
972:
973: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
974: THEN

Line 980: p_encoded => fnd_api.g_false

976: END IF;
977:
978: fnd_msg_pub.count_and_get (p_count => x_msg_count,
979: p_data => x_msg_data,
980: p_encoded => fnd_api.g_false
981: );
982: END check_valid_delete;
983:
984: -- --------------------------------------------------------------------------*

Line 1022: x_return_status := fnd_api.g_ret_sts_success;

1018: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
1019: l_loading_status VARCHAR2 (2000);
1020: BEGIN
1021: -- Initialize API return status to success
1022: x_return_status := fnd_api.g_ret_sts_success;
1023: x_loading_status := p_loading_status;
1024:
1025: FOR l_rec IN l_cur
1026: LOOP

Line 1049: IF (l_return_status <> fnd_api.g_ret_sts_success)

1045: x_srp_plan_assign_id => l_srp_plan_assign_id,
1046: x_loading_status => l_loading_status
1047: );
1048:
1049: IF (l_return_status <> fnd_api.g_ret_sts_success)
1050: THEN
1051: x_return_status := l_return_status;
1052: x_loading_status := l_loading_status;
1053: EXIT;

Line 1105: x_return_status := fnd_api.g_ret_sts_success;

1101: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
1102: l_loading_status VARCHAR2 (2000);
1103: BEGIN
1104: -- Initialize API return status to success
1105: x_return_status := fnd_api.g_ret_sts_success;
1106: x_loading_status := p_loading_status;
1107:
1108: -- see here if it is necessary to update cn_srp_plan_assigns...
1109: -- the create_module here is OSC.

Line 1113: IF (p_date_update_only = fnd_api.g_true)

1109: -- the create_module here is OSC.
1110: -- if the job title not assigned yet (original OSC case) or
1111: -- status is PUSHED (salesrep push done, treat as OSC record), then
1112: -- call SPA.update
1113: IF (p_date_update_only = fnd_api.g_true)
1114: THEN
1115: FOR l_rec IN l_cur
1116: LOOP
1117: -- if l_rec.job_title_id = G_MISS_JOB_TITLE OR

Line 1129: IF (l_return_status <> fnd_api.g_ret_sts_success)

1125: p_role_plan_id => p_role_plan_id,
1126: x_loading_status => l_loading_status
1127: );
1128:
1129: IF (l_return_status <> fnd_api.g_ret_sts_success)
1130: THEN
1131: x_return_status := l_return_status;
1132: x_loading_status := l_loading_status;
1133: EXIT;

Line 1154: IF (l_return_status <> fnd_api.g_ret_sts_success)

1150: p_role_plan_id => p_role_plan_id,
1151: x_loading_status => l_loading_status
1152: );
1153:
1154: IF (l_return_status <> fnd_api.g_ret_sts_success)
1155: THEN
1156: x_return_status := l_return_status;
1157: x_loading_status := l_loading_status;
1158: EXIT;

Line 1175: IF (l_return_status <> fnd_api.g_ret_sts_success)

1171: x_srp_plan_assign_id => l_srp_plan_assign_id,
1172: x_loading_status => l_loading_status
1173: );
1174:
1175: IF (l_return_status <> fnd_api.g_ret_sts_success)
1176: THEN
1177: x_return_status := l_return_status;
1178: x_loading_status := l_loading_status;
1179: EXIT;

Line 1212: x_return_status := fnd_api.g_ret_sts_success;

1208: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
1209: l_loading_status VARCHAR2 (2000);
1210: BEGIN
1211: -- Initialize API return status to success
1212: x_return_status := fnd_api.g_ret_sts_success;
1213: x_loading_status := p_loading_status;
1214:
1215: FOR l_rec IN l_cur
1216: LOOP

Line 1219: p_validation_level => fnd_api.g_valid_level_full,

1215: FOR l_rec IN l_cur
1216: LOOP
1217: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
1218: (p_api_version => 1.0,
1219: p_validation_level => fnd_api.g_valid_level_full,
1220: x_return_status => l_return_status,
1221: x_msg_count => l_msg_count,
1222: x_msg_data => l_msg_data,
1223: p_srp_role_id => l_rec.srp_role_id,

Line 1228: IF (l_return_status <> fnd_api.g_ret_sts_success)

1224: p_role_plan_id => p_role_plan_id,
1225: x_loading_status => l_loading_status
1226: );
1227:
1228: IF (l_return_status <> fnd_api.g_ret_sts_success)
1229: THEN
1230: x_return_status := l_return_status;
1231: x_loading_status := l_loading_status;
1232: EXIT;

Line 1243: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1239: -- --------------------------------------------------------------------------*
1240: -- CHANTHON: Added the out params role plan id and obj ver num
1241: PROCEDURE create_role_plan (
1242: p_api_version IN NUMBER,
1243: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1244: p_commit IN VARCHAR2 := fnd_api.g_false,
1245: p_validation_level IN NUMBER
1246: := fnd_api.g_valid_level_full,
1247: x_return_status OUT NOCOPY VARCHAR2,

Line 1244: p_commit IN VARCHAR2 := fnd_api.g_false,

1240: -- CHANTHON: Added the out params role plan id and obj ver num
1241: PROCEDURE create_role_plan (
1242: p_api_version IN NUMBER,
1243: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1244: p_commit IN VARCHAR2 := fnd_api.g_false,
1245: p_validation_level IN NUMBER
1246: := fnd_api.g_valid_level_full,
1247: x_return_status OUT NOCOPY VARCHAR2,
1248: x_loading_status OUT NOCOPY VARCHAR2,

Line 1246: := fnd_api.g_valid_level_full,

1242: p_api_version IN NUMBER,
1243: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1244: p_commit IN VARCHAR2 := fnd_api.g_false,
1245: p_validation_level IN NUMBER
1246: := fnd_api.g_valid_level_full,
1247: x_return_status OUT NOCOPY VARCHAR2,
1248: x_loading_status OUT NOCOPY VARCHAR2,
1249: x_msg_count OUT NOCOPY NUMBER,
1250: x_msg_data OUT NOCOPY VARCHAR2,

Line 1276: IF NOT fnd_api.compatible_api_call (l_api_version,

1272: -- Standard Start of API savepoint
1273: SAVEPOINT create_role_plan;
1274:
1275: -- Standard call to check for call compatibility.
1276: IF NOT fnd_api.compatible_api_call (l_api_version,
1277: p_api_version,
1278: l_api_name,
1279: g_pkg_name
1280: )

Line 1282: RAISE fnd_api.g_exc_unexpected_error;

1278: l_api_name,
1279: g_pkg_name
1280: )
1281: THEN
1282: RAISE fnd_api.g_exc_unexpected_error;
1283: END IF;
1284:
1285: -- Initialize message list if p_init_msg_list is set to TRUE.
1286: IF fnd_api.to_boolean (p_init_msg_list)

Line 1286: IF fnd_api.to_boolean (p_init_msg_list)

1282: RAISE fnd_api.g_exc_unexpected_error;
1283: END IF;
1284:
1285: -- Initialize message list if p_init_msg_list is set to TRUE.
1286: IF fnd_api.to_boolean (p_init_msg_list)
1287: THEN
1288: fnd_msg_pub.initialize;
1289: END IF;
1290:

Line 1292: x_return_status := fnd_api.g_ret_sts_success;

1288: fnd_msg_pub.initialize;
1289: END IF;
1290:
1291: -- Initialize API return status to success
1292: x_return_status := fnd_api.g_ret_sts_success;
1293: x_loading_status := 'CN_INSERTED';
1294:
1295: -- START OF MOAC ORG_ID VALIDATION
1296:

Line 1341: IF (x_return_status = fnd_api.g_ret_sts_error)

1337: x_msg_data => x_msg_data,
1338: p_role_plan_rec => l_rec
1339: );
1340:
1341: IF (x_return_status = fnd_api.g_ret_sts_error)
1342: THEN
1343: RAISE fnd_api.g_exc_error;
1344: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1345: THEN

Line 1343: RAISE fnd_api.g_exc_error;

1339: );
1340:
1341: IF (x_return_status = fnd_api.g_ret_sts_error)
1342: THEN
1343: RAISE fnd_api.g_exc_error;
1344: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1345: THEN
1346: RAISE fnd_api.g_exc_unexpected_error;
1347: END IF;

Line 1344: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1340:
1341: IF (x_return_status = fnd_api.g_ret_sts_error)
1342: THEN
1343: RAISE fnd_api.g_exc_error;
1344: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1345: THEN
1346: RAISE fnd_api.g_exc_unexpected_error;
1347: END IF;
1348: END IF;

Line 1346: RAISE fnd_api.g_exc_unexpected_error;

1342: THEN
1343: RAISE fnd_api.g_exc_error;
1344: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1345: THEN
1346: RAISE fnd_api.g_exc_unexpected_error;
1347: END IF;
1348: END IF;
1349:
1350: -- Vertical industry pre-processing section

Line 1369: IF (x_return_status = fnd_api.g_ret_sts_error)

1365: x_msg_data => x_msg_data,
1366: p_role_plan_rec => l_rec
1367: );
1368:
1369: IF (x_return_status = fnd_api.g_ret_sts_error)
1370: THEN
1371: RAISE fnd_api.g_exc_error;
1372: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1373: THEN

Line 1371: RAISE fnd_api.g_exc_error;

1367: );
1368:
1369: IF (x_return_status = fnd_api.g_ret_sts_error)
1370: THEN
1371: RAISE fnd_api.g_exc_error;
1372: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1373: THEN
1374: RAISE fnd_api.g_exc_unexpected_error;
1375: END IF;

Line 1372: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1368:
1369: IF (x_return_status = fnd_api.g_ret_sts_error)
1370: THEN
1371: RAISE fnd_api.g_exc_error;
1372: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1373: THEN
1374: RAISE fnd_api.g_exc_unexpected_error;
1375: END IF;
1376: END IF;

Line 1374: RAISE fnd_api.g_exc_unexpected_error;

1370: THEN
1371: RAISE fnd_api.g_exc_error;
1372: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1373: THEN
1374: RAISE fnd_api.g_exc_unexpected_error;
1375: END IF;
1376: END IF;
1377:
1378: -- Start of API body

Line 1391: IF (x_return_status <> fnd_api.g_ret_sts_success)

1387: p_loading_status => x_loading_status, -- in
1388: x_loading_status => x_loading_status -- out
1389: );
1390:
1391: IF (x_return_status <> fnd_api.g_ret_sts_success)
1392: THEN
1393: RAISE fnd_api.g_exc_error;
1394: ELSE
1395: SELECT cn_role_plans_s.NEXTVAL

Line 1393: RAISE fnd_api.g_exc_error;

1389: );
1390:
1391: IF (x_return_status <> fnd_api.g_ret_sts_success)
1392: THEN
1393: RAISE fnd_api.g_exc_error;
1394: ELSE
1395: SELECT cn_role_plans_s.NEXTVAL
1396: INTO l_role_plan_id
1397: FROM DUAL;

Line 1472: IF (x_return_status <> fnd_api.g_ret_sts_success)

1468: x_loading_status => x_loading_status,
1469: p_org_id => l_rec.org_id
1470: );
1471:
1472: IF (x_return_status <> fnd_api.g_ret_sts_success)
1473: THEN
1474: RAISE fnd_api.g_exc_error;
1475: END IF;
1476: END IF;

Line 1474: RAISE fnd_api.g_exc_error;

1470: );
1471:
1472: IF (x_return_status <> fnd_api.g_ret_sts_success)
1473: THEN
1474: RAISE fnd_api.g_exc_error;
1475: END IF;
1476: END IF;
1477:
1478: -- End of API body

Line 1503: IF (x_return_status = fnd_api.g_ret_sts_error)

1499: x_msg_data => x_msg_data,
1500: p_role_plan_rec => l_rec
1501: );
1502:
1503: IF (x_return_status = fnd_api.g_ret_sts_error)
1504: THEN
1505: RAISE fnd_api.g_exc_error;
1506: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1507: THEN

Line 1505: RAISE fnd_api.g_exc_error;

1501: );
1502:
1503: IF (x_return_status = fnd_api.g_ret_sts_error)
1504: THEN
1505: RAISE fnd_api.g_exc_error;
1506: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1507: THEN
1508: RAISE fnd_api.g_exc_unexpected_error;
1509: END IF;

Line 1506: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1502:
1503: IF (x_return_status = fnd_api.g_ret_sts_error)
1504: THEN
1505: RAISE fnd_api.g_exc_error;
1506: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1507: THEN
1508: RAISE fnd_api.g_exc_unexpected_error;
1509: END IF;
1510: END IF;

Line 1508: RAISE fnd_api.g_exc_unexpected_error;

1504: THEN
1505: RAISE fnd_api.g_exc_error;
1506: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1507: THEN
1508: RAISE fnd_api.g_exc_unexpected_error;
1509: END IF;
1510: END IF;
1511:
1512: -- Vertical industry post-processing section

Line 1531: IF (x_return_status = fnd_api.g_ret_sts_error)

1527: x_msg_data => x_msg_data,
1528: p_role_plan_rec => l_rec
1529: );
1530:
1531: IF (x_return_status = fnd_api.g_ret_sts_error)
1532: THEN
1533: RAISE fnd_api.g_exc_error;
1534: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1535: THEN

Line 1533: RAISE fnd_api.g_exc_error;

1529: );
1530:
1531: IF (x_return_status = fnd_api.g_ret_sts_error)
1532: THEN
1533: RAISE fnd_api.g_exc_error;
1534: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1535: THEN
1536: RAISE fnd_api.g_exc_unexpected_error;
1537: END IF;

Line 1534: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1530:
1531: IF (x_return_status = fnd_api.g_ret_sts_error)
1532: THEN
1533: RAISE fnd_api.g_exc_error;
1534: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1535: THEN
1536: RAISE fnd_api.g_exc_unexpected_error;
1537: END IF;
1538: END IF;

Line 1536: RAISE fnd_api.g_exc_unexpected_error;

1532: THEN
1533: RAISE fnd_api.g_exc_error;
1534: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1535: THEN
1536: RAISE fnd_api.g_exc_unexpected_error;
1537: END IF;
1538: END IF;
1539:
1540: -- Message enable hook

Line 1577: IF (x_return_status = fnd_api.g_ret_sts_error)

1573: p_oai_array => l_oai_array,
1574: x_return_code => x_return_status
1575: );
1576:
1577: IF (x_return_status = fnd_api.g_ret_sts_error)
1578: THEN
1579: RAISE fnd_api.g_exc_error;
1580: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1581: THEN

Line 1579: RAISE fnd_api.g_exc_error;

1575: );
1576:
1577: IF (x_return_status = fnd_api.g_ret_sts_error)
1578: THEN
1579: RAISE fnd_api.g_exc_error;
1580: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1581: THEN
1582: RAISE fnd_api.g_exc_unexpected_error;
1583: END IF;

Line 1580: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1576:
1577: IF (x_return_status = fnd_api.g_ret_sts_error)
1578: THEN
1579: RAISE fnd_api.g_exc_error;
1580: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1581: THEN
1582: RAISE fnd_api.g_exc_unexpected_error;
1583: END IF;
1584: END IF;

Line 1582: RAISE fnd_api.g_exc_unexpected_error;

1578: THEN
1579: RAISE fnd_api.g_exc_error;
1580: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1581: THEN
1582: RAISE fnd_api.g_exc_unexpected_error;
1583: END IF;
1584: END IF;
1585: END IF;
1586:

Line 1599: IF fnd_api.to_boolean (p_commit)

1595: p_role_plan_rec => l_rec);
1596:
1597:
1598: -- Standard check of p_commit.
1599: IF fnd_api.to_boolean (p_commit)
1600: THEN
1601: COMMIT WORK;
1602: END IF;
1603:

Line 1607: p_encoded => fnd_api.g_false

1603:
1604: -- Standard call to get message count and if count is 1, get message info.
1605: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1606: p_data => x_msg_data,
1607: p_encoded => fnd_api.g_false
1608: );
1609: EXCEPTION
1610: WHEN fnd_api.g_exc_error
1611: THEN

Line 1610: WHEN fnd_api.g_exc_error

1606: p_data => x_msg_data,
1607: p_encoded => fnd_api.g_false
1608: );
1609: EXCEPTION
1610: WHEN fnd_api.g_exc_error
1611: THEN
1612: ROLLBACK TO create_role_plan;
1613: x_return_status := fnd_api.g_ret_sts_error;
1614: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 1613: x_return_status := fnd_api.g_ret_sts_error;

1609: EXCEPTION
1610: WHEN fnd_api.g_exc_error
1611: THEN
1612: ROLLBACK TO create_role_plan;
1613: x_return_status := fnd_api.g_ret_sts_error;
1614: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1615: p_data => x_msg_data,
1616: p_encoded => fnd_api.g_false
1617: );

Line 1616: p_encoded => fnd_api.g_false

1612: ROLLBACK TO create_role_plan;
1613: x_return_status := fnd_api.g_ret_sts_error;
1614: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1615: p_data => x_msg_data,
1616: p_encoded => fnd_api.g_false
1617: );
1618: WHEN fnd_api.g_exc_unexpected_error
1619: THEN
1620: ROLLBACK TO create_role_plan;

Line 1618: WHEN fnd_api.g_exc_unexpected_error

1614: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1615: p_data => x_msg_data,
1616: p_encoded => fnd_api.g_false
1617: );
1618: WHEN fnd_api.g_exc_unexpected_error
1619: THEN
1620: ROLLBACK TO create_role_plan;
1621: x_loading_status := 'UNEXPECTED_ERR';
1622: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1622: x_return_status := fnd_api.g_ret_sts_unexp_error;

1618: WHEN fnd_api.g_exc_unexpected_error
1619: THEN
1620: ROLLBACK TO create_role_plan;
1621: x_loading_status := 'UNEXPECTED_ERR';
1622: x_return_status := fnd_api.g_ret_sts_unexp_error;
1623: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1624: p_data => x_msg_data,
1625: p_encoded => fnd_api.g_false
1626: );

Line 1625: p_encoded => fnd_api.g_false

1621: x_loading_status := 'UNEXPECTED_ERR';
1622: x_return_status := fnd_api.g_ret_sts_unexp_error;
1623: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1624: p_data => x_msg_data,
1625: p_encoded => fnd_api.g_false
1626: );
1627: WHEN OTHERS
1628: THEN
1629: ROLLBACK TO create_role_plan;

Line 1631: x_return_status := fnd_api.g_ret_sts_unexp_error;

1627: WHEN OTHERS
1628: THEN
1629: ROLLBACK TO create_role_plan;
1630: x_loading_status := 'UNEXPECTED_ERR';
1631: x_return_status := fnd_api.g_ret_sts_unexp_error;
1632:
1633: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1634: THEN
1635: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1640: p_encoded => fnd_api.g_false

1636: END IF;
1637:
1638: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1639: p_data => x_msg_data,
1640: p_encoded => fnd_api.g_false
1641: );
1642: END create_role_plan;
1643:
1644: -- --------------------------------------------------------------------------*

Line 1650: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1646: -- CHANTHON: Modified p_ovn to IN OUT param
1647: -- --------------------------------------------------------------------------*
1648: PROCEDURE update_role_plan (
1649: p_api_version IN NUMBER,
1650: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1651: p_commit IN VARCHAR2 := fnd_api.g_false,
1652: p_validation_level IN NUMBER
1653: := fnd_api.g_valid_level_full,
1654: x_return_status OUT NOCOPY VARCHAR2,

Line 1651: p_commit IN VARCHAR2 := fnd_api.g_false,

1647: -- --------------------------------------------------------------------------*
1648: PROCEDURE update_role_plan (
1649: p_api_version IN NUMBER,
1650: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1651: p_commit IN VARCHAR2 := fnd_api.g_false,
1652: p_validation_level IN NUMBER
1653: := fnd_api.g_valid_level_full,
1654: x_return_status OUT NOCOPY VARCHAR2,
1655: x_loading_status OUT NOCOPY VARCHAR2,

Line 1653: := fnd_api.g_valid_level_full,

1649: p_api_version IN NUMBER,
1650: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1651: p_commit IN VARCHAR2 := fnd_api.g_false,
1652: p_validation_level IN NUMBER
1653: := fnd_api.g_valid_level_full,
1654: x_return_status OUT NOCOPY VARCHAR2,
1655: x_loading_status OUT NOCOPY VARCHAR2,
1656: x_msg_count OUT NOCOPY NUMBER,
1657: x_msg_data OUT NOCOPY VARCHAR2,

Line 1689: IF NOT fnd_api.compatible_api_call (l_api_version,

1685: -- Standard Start of API savepoint
1686: SAVEPOINT update_role_plan;
1687:
1688: -- Standard call to check for call compatibility.
1689: IF NOT fnd_api.compatible_api_call (l_api_version,
1690: p_api_version,
1691: l_api_name,
1692: g_pkg_name
1693: )

Line 1695: RAISE fnd_api.g_exc_unexpected_error;

1691: l_api_name,
1692: g_pkg_name
1693: )
1694: THEN
1695: RAISE fnd_api.g_exc_unexpected_error;
1696: END IF;
1697:
1698: -- Initialize message list if p_init_msg_list is set to TRUE.
1699: IF fnd_api.to_boolean (p_init_msg_list)

Line 1699: IF fnd_api.to_boolean (p_init_msg_list)

1695: RAISE fnd_api.g_exc_unexpected_error;
1696: END IF;
1697:
1698: -- Initialize message list if p_init_msg_list is set to TRUE.
1699: IF fnd_api.to_boolean (p_init_msg_list)
1700: THEN
1701: fnd_msg_pub.initialize;
1702: END IF;
1703:

Line 1705: x_return_status := fnd_api.g_ret_sts_success;

1701: fnd_msg_pub.initialize;
1702: END IF;
1703:
1704: -- Initialize API return status to success
1705: x_return_status := fnd_api.g_ret_sts_success;
1706: x_loading_status := 'CN_UPDATED';
1707:
1708: -- Assign the parameter to a local variable to be passed to Pre, Post
1709: -- and Business APIs

Line 1774: RAISE FND_API.G_EXC_ERROR ;

1770: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
1771: FND_MSG_PUB.Add;
1772: END IF;
1773:
1774: RAISE FND_API.G_EXC_ERROR ;
1775: end if;
1776: -- END OF MOAC ORG_ID VALIDATION
1777:
1778: -- CHANTHON: Added to get the comp plan and role names given the ids

Line 1812: IF (x_return_status = fnd_api.g_ret_sts_error)

1808: p_role_plan_rec_old => l_rec_old,
1809: p_role_plan_rec_new => l_rec_new
1810: );
1811:
1812: IF (x_return_status = fnd_api.g_ret_sts_error)
1813: THEN
1814: RAISE fnd_api.g_exc_error;
1815: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1816: THEN

Line 1814: RAISE fnd_api.g_exc_error;

1810: );
1811:
1812: IF (x_return_status = fnd_api.g_ret_sts_error)
1813: THEN
1814: RAISE fnd_api.g_exc_error;
1815: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1816: THEN
1817: RAISE fnd_api.g_exc_unexpected_error;
1818: END IF;

Line 1815: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1811:
1812: IF (x_return_status = fnd_api.g_ret_sts_error)
1813: THEN
1814: RAISE fnd_api.g_exc_error;
1815: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1816: THEN
1817: RAISE fnd_api.g_exc_unexpected_error;
1818: END IF;
1819: END IF;

Line 1817: RAISE fnd_api.g_exc_unexpected_error;

1813: THEN
1814: RAISE fnd_api.g_exc_error;
1815: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1816: THEN
1817: RAISE fnd_api.g_exc_unexpected_error;
1818: END IF;
1819: END IF;
1820:
1821: -- Vertical industry pre-processing section

Line 1841: IF (x_return_status = fnd_api.g_ret_sts_error)

1837: p_role_plan_rec_old => l_rec_old,
1838: p_role_plan_rec_new => l_rec_new
1839: );
1840:
1841: IF (x_return_status = fnd_api.g_ret_sts_error)
1842: THEN
1843: RAISE fnd_api.g_exc_error;
1844: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1845: THEN

Line 1843: RAISE fnd_api.g_exc_error;

1839: );
1840:
1841: IF (x_return_status = fnd_api.g_ret_sts_error)
1842: THEN
1843: RAISE fnd_api.g_exc_error;
1844: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1845: THEN
1846: RAISE fnd_api.g_exc_unexpected_error;
1847: END IF;

Line 1844: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1840:
1841: IF (x_return_status = fnd_api.g_ret_sts_error)
1842: THEN
1843: RAISE fnd_api.g_exc_error;
1844: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1845: THEN
1846: RAISE fnd_api.g_exc_unexpected_error;
1847: END IF;
1848: END IF;

Line 1846: RAISE fnd_api.g_exc_unexpected_error;

1842: THEN
1843: RAISE fnd_api.g_exc_error;
1844: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1845: THEN
1846: RAISE fnd_api.g_exc_unexpected_error;
1847: END IF;
1848: END IF;
1849:
1850: --CHANTHON:

Line 1869: IF (x_return_status <> fnd_api.g_ret_sts_success)

1865: x_loading_status => x_loading_status -- out
1866: );
1867:
1868: -- x_return_status is failure for all failure cases,
1869: IF (x_return_status <> fnd_api.g_ret_sts_success)
1870: THEN
1871: RAISE fnd_api.g_exc_error;
1872: ELSE
1873: -- CHANTHON: Added ORG_ID in the update

Line 1871: RAISE fnd_api.g_exc_error;

1867:
1868: -- x_return_status is failure for all failure cases,
1869: IF (x_return_status <> fnd_api.g_ret_sts_success)
1870: THEN
1871: RAISE fnd_api.g_exc_error;
1872: ELSE
1873: -- CHANTHON: Added ORG_ID in the update
1874:
1875: --- *** Business Events *** ---

Line 1916: IF (l_rec_new.role_name <> fnd_api.g_miss_char AND l_rec_new.role_name IS NOT NULL

1912:
1913: l_consolidated_note := '';
1914: l_consolidated_note_new := '';
1915: --Notes when the Role is changed in RolePlam Assignment
1916: IF (l_rec_new.role_name <> fnd_api.g_miss_char AND l_rec_new.role_name IS NOT NULL
1917: AND l_rec_old.role_name <> fnd_api.g_miss_char AND l_rec_old.role_name IS NOT NULL
1918: AND l_rec_new.role_name <> l_rec_old.role_name)
1919: THEN
1920: --Notes for Old Role being unassigned

Line 1917: AND l_rec_old.role_name <> fnd_api.g_miss_char AND l_rec_old.role_name IS NOT NULL

1913: l_consolidated_note := '';
1914: l_consolidated_note_new := '';
1915: --Notes when the Role is changed in RolePlam Assignment
1916: IF (l_rec_new.role_name <> fnd_api.g_miss_char AND l_rec_new.role_name IS NOT NULL
1917: AND l_rec_old.role_name <> fnd_api.g_miss_char AND l_rec_old.role_name IS NOT NULL
1918: AND l_rec_new.role_name <> l_rec_old.role_name)
1919: THEN
1920: --Notes for Old Role being unassigned
1921: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');

Line 1960: ELSE IF (l_rec_new.comp_plan_name <> fnd_api.g_miss_char AND l_rec_new.comp_plan_name IS NOT NULL

1956: p_note_type => 'CN_SYSGEN', -- for system generated
1957: x_jtf_note_id => l_note_id -- returned
1958: );
1959: */
1960: ELSE IF (l_rec_new.comp_plan_name <> fnd_api.g_miss_char AND l_rec_new.comp_plan_name IS NOT NULL
1961: AND l_rec_old.comp_plan_name <> fnd_api.g_miss_char AND l_rec_old.comp_plan_name IS NOT NULL
1962: AND l_rec_new.comp_plan_name <> l_rec_old.comp_plan_name)
1963: THEN
1964: --Notes for Role being unassigned from Old Compplan

Line 1961: AND l_rec_old.comp_plan_name <> fnd_api.g_miss_char AND l_rec_old.comp_plan_name IS NOT NULL

1957: x_jtf_note_id => l_note_id -- returned
1958: );
1959: */
1960: ELSE IF (l_rec_new.comp_plan_name <> fnd_api.g_miss_char AND l_rec_new.comp_plan_name IS NOT NULL
1961: AND l_rec_old.comp_plan_name <> fnd_api.g_miss_char AND l_rec_old.comp_plan_name IS NOT NULL
1962: AND l_rec_new.comp_plan_name <> l_rec_old.comp_plan_name)
1963: THEN
1964: --Notes for Role being unassigned from Old Compplan
1965: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');

Line 2028: IF ((l_rec_old.end_date is null OR l_rec_old.end_date = fnd_api.G_MISS_DATE)

2024: x_jtf_note_id => l_note_id -- returned
2025: );
2026: */
2027: END IF;
2028: IF ((l_rec_old.end_date is null OR l_rec_old.end_date = fnd_api.G_MISS_DATE)
2029: AND (l_rec_new.end_date is not null AND l_rec_new.end_date <> fnd_api.G_MISS_DATE))
2030: THEN
2031: --Notes for setting end date for RolePlan assignment
2032: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_NULL_UPD');

Line 2029: AND (l_rec_new.end_date is not null AND l_rec_new.end_date <> fnd_api.G_MISS_DATE))

2025: );
2026: */
2027: END IF;
2028: IF ((l_rec_old.end_date is null OR l_rec_old.end_date = fnd_api.G_MISS_DATE)
2029: AND (l_rec_new.end_date is not null AND l_rec_new.end_date <> fnd_api.G_MISS_DATE))
2030: THEN
2031: --Notes for setting end date for RolePlan assignment
2032: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_NULL_UPD');
2033: fnd_message.set_token ('NEWVALUE', l_rec_new.end_date);

Line 2051: ELSE IF ((l_rec_new.end_date is null OR l_rec_new.end_date = fnd_api.G_MISS_DATE)

2047: p_note_type => 'CN_SYSGEN', -- for system generated
2048: x_jtf_note_id => l_note_id -- returned
2049: );
2050: */
2051: ELSE IF ((l_rec_new.end_date is null OR l_rec_new.end_date = fnd_api.G_MISS_DATE)
2052: AND (l_rec_old.end_date is not null AND l_rec_old.end_date <> fnd_api.G_MISS_DATE))
2053: THEN
2054: --Notes for removing end date for RolePlan assignment
2055: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_UPD_NULL');

Line 2052: AND (l_rec_old.end_date is not null AND l_rec_old.end_date <> fnd_api.G_MISS_DATE))

2048: x_jtf_note_id => l_note_id -- returned
2049: );
2050: */
2051: ELSE IF ((l_rec_new.end_date is null OR l_rec_new.end_date = fnd_api.G_MISS_DATE)
2052: AND (l_rec_old.end_date is not null AND l_rec_old.end_date <> fnd_api.G_MISS_DATE))
2053: THEN
2054: --Notes for removing end date for RolePlan assignment
2055: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_END_DATE_UPD_NULL');
2056: fnd_message.set_token ('NAME', l_rec_new.role_name);

Line 2156: IF (x_return_status <> fnd_api.g_ret_sts_success)

2152: p_org_id => l_rec_new.org_id,
2153: p_org_id_old => l_rec_old.org_id
2154: );
2155:
2156: IF (x_return_status <> fnd_api.g_ret_sts_success)
2157: THEN
2158: RAISE fnd_api.g_exc_error;
2159: END IF;
2160: END IF;

Line 2158: RAISE fnd_api.g_exc_error;

2154: );
2155:
2156: IF (x_return_status <> fnd_api.g_ret_sts_success)
2157: THEN
2158: RAISE fnd_api.g_exc_error;
2159: END IF;
2160: END IF;
2161:
2162: -- End of API body

Line 2196: IF (x_return_status = fnd_api.g_ret_sts_error)

2192: p_role_plan_rec_old => l_rec_old,
2193: p_role_plan_rec_new => l_rec_new
2194: );
2195:
2196: IF (x_return_status = fnd_api.g_ret_sts_error)
2197: THEN
2198: RAISE fnd_api.g_exc_error;
2199: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2200: THEN

Line 2198: RAISE fnd_api.g_exc_error;

2194: );
2195:
2196: IF (x_return_status = fnd_api.g_ret_sts_error)
2197: THEN
2198: RAISE fnd_api.g_exc_error;
2199: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2200: THEN
2201: RAISE fnd_api.g_exc_unexpected_error;
2202: END IF;

Line 2199: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2195:
2196: IF (x_return_status = fnd_api.g_ret_sts_error)
2197: THEN
2198: RAISE fnd_api.g_exc_error;
2199: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2200: THEN
2201: RAISE fnd_api.g_exc_unexpected_error;
2202: END IF;
2203: END IF;

Line 2201: RAISE fnd_api.g_exc_unexpected_error;

2197: THEN
2198: RAISE fnd_api.g_exc_error;
2199: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2200: THEN
2201: RAISE fnd_api.g_exc_unexpected_error;
2202: END IF;
2203: END IF;
2204:
2205: -- Vertical industry post-processing section

Line 2225: IF (x_return_status = fnd_api.g_ret_sts_error)

2221: p_role_plan_rec_old => l_rec_old,
2222: p_role_plan_rec_new => l_rec_new
2223: );
2224:
2225: IF (x_return_status = fnd_api.g_ret_sts_error)
2226: THEN
2227: RAISE fnd_api.g_exc_error;
2228: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2229: THEN

Line 2227: RAISE fnd_api.g_exc_error;

2223: );
2224:
2225: IF (x_return_status = fnd_api.g_ret_sts_error)
2226: THEN
2227: RAISE fnd_api.g_exc_error;
2228: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2229: THEN
2230: RAISE fnd_api.g_exc_unexpected_error;
2231: END IF;

Line 2228: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2224:
2225: IF (x_return_status = fnd_api.g_ret_sts_error)
2226: THEN
2227: RAISE fnd_api.g_exc_error;
2228: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2229: THEN
2230: RAISE fnd_api.g_exc_unexpected_error;
2231: END IF;
2232: END IF;

Line 2230: RAISE fnd_api.g_exc_unexpected_error;

2226: THEN
2227: RAISE fnd_api.g_exc_error;
2228: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2229: THEN
2230: RAISE fnd_api.g_exc_unexpected_error;
2231: END IF;
2232: END IF;
2233:
2234: -- Message enable hook

Line 2271: IF (x_return_status = fnd_api.g_ret_sts_error)

2267: p_oai_array => l_oai_array,
2268: x_return_code => x_return_status
2269: );
2270:
2271: IF (x_return_status = fnd_api.g_ret_sts_error)
2272: THEN
2273: RAISE fnd_api.g_exc_error;
2274: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2275: THEN

Line 2273: RAISE fnd_api.g_exc_error;

2269: );
2270:
2271: IF (x_return_status = fnd_api.g_ret_sts_error)
2272: THEN
2273: RAISE fnd_api.g_exc_error;
2274: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2275: THEN
2276: RAISE fnd_api.g_exc_unexpected_error;
2277: END IF;

Line 2274: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2270:
2271: IF (x_return_status = fnd_api.g_ret_sts_error)
2272: THEN
2273: RAISE fnd_api.g_exc_error;
2274: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2275: THEN
2276: RAISE fnd_api.g_exc_unexpected_error;
2277: END IF;
2278: END IF;

Line 2276: RAISE fnd_api.g_exc_unexpected_error;

2272: THEN
2273: RAISE fnd_api.g_exc_error;
2274: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2275: THEN
2276: RAISE fnd_api.g_exc_unexpected_error;
2277: END IF;
2278: END IF;
2279: END IF;
2280:

Line 2282: IF fnd_api.to_boolean (p_commit)

2278: END IF;
2279: END IF;
2280:
2281: -- Standard check of p_commit.
2282: IF fnd_api.to_boolean (p_commit)
2283: THEN
2284: COMMIT WORK;
2285: END IF;
2286:

Line 2290: p_encoded => fnd_api.g_false

2286:
2287: -- Standard call to get message count and if count is 1, get message info.
2288: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2289: p_data => x_msg_data,
2290: p_encoded => fnd_api.g_false
2291: );
2292: EXCEPTION
2293: WHEN fnd_api.g_exc_error
2294: THEN

Line 2293: WHEN fnd_api.g_exc_error

2289: p_data => x_msg_data,
2290: p_encoded => fnd_api.g_false
2291: );
2292: EXCEPTION
2293: WHEN fnd_api.g_exc_error
2294: THEN
2295: ROLLBACK TO update_role_plan;
2296: x_return_status := fnd_api.g_ret_sts_error;
2297: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 2296: x_return_status := fnd_api.g_ret_sts_error;

2292: EXCEPTION
2293: WHEN fnd_api.g_exc_error
2294: THEN
2295: ROLLBACK TO update_role_plan;
2296: x_return_status := fnd_api.g_ret_sts_error;
2297: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2298: p_data => x_msg_data,
2299: p_encoded => fnd_api.g_false
2300: );

Line 2299: p_encoded => fnd_api.g_false

2295: ROLLBACK TO update_role_plan;
2296: x_return_status := fnd_api.g_ret_sts_error;
2297: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2298: p_data => x_msg_data,
2299: p_encoded => fnd_api.g_false
2300: );
2301: WHEN fnd_api.g_exc_unexpected_error
2302: THEN
2303: ROLLBACK TO update_role_plan;

Line 2301: WHEN fnd_api.g_exc_unexpected_error

2297: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2298: p_data => x_msg_data,
2299: p_encoded => fnd_api.g_false
2300: );
2301: WHEN fnd_api.g_exc_unexpected_error
2302: THEN
2303: ROLLBACK TO update_role_plan;
2304: x_loading_status := 'UNEXPECTED_ERR';
2305: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2305: x_return_status := fnd_api.g_ret_sts_unexp_error;

2301: WHEN fnd_api.g_exc_unexpected_error
2302: THEN
2303: ROLLBACK TO update_role_plan;
2304: x_loading_status := 'UNEXPECTED_ERR';
2305: x_return_status := fnd_api.g_ret_sts_unexp_error;
2306: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2307: p_data => x_msg_data,
2308: p_encoded => fnd_api.g_false
2309: );

Line 2308: p_encoded => fnd_api.g_false

2304: x_loading_status := 'UNEXPECTED_ERR';
2305: x_return_status := fnd_api.g_ret_sts_unexp_error;
2306: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2307: p_data => x_msg_data,
2308: p_encoded => fnd_api.g_false
2309: );
2310: WHEN OTHERS
2311: THEN
2312: ROLLBACK TO update_role_plan;

Line 2314: x_return_status := fnd_api.g_ret_sts_unexp_error;

2310: WHEN OTHERS
2311: THEN
2312: ROLLBACK TO update_role_plan;
2313: x_loading_status := 'UNEXPECTED_ERR';
2314: x_return_status := fnd_api.g_ret_sts_unexp_error;
2315:
2316: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2317: THEN
2318: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 2323: p_encoded => fnd_api.g_false

2319: END IF;
2320:
2321: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2322: p_data => x_msg_data,
2323: p_encoded => fnd_api.g_false
2324: );
2325: END update_role_plan;
2326:
2327: -- --------------------------------------------------------------------------*

Line 2332: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

2328: -- Procedure: Delete_Role_Plan
2329: -- --------------------------------------------------------------------------*
2330: PROCEDURE delete_role_plan (
2331: p_api_version IN NUMBER,
2332: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2333: p_commit IN VARCHAR2 := fnd_api.g_false,
2334: p_validation_level IN NUMBER
2335: := fnd_api.g_valid_level_full,
2336: x_return_status OUT NOCOPY VARCHAR2,

Line 2333: p_commit IN VARCHAR2 := fnd_api.g_false,

2329: -- --------------------------------------------------------------------------*
2330: PROCEDURE delete_role_plan (
2331: p_api_version IN NUMBER,
2332: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2333: p_commit IN VARCHAR2 := fnd_api.g_false,
2334: p_validation_level IN NUMBER
2335: := fnd_api.g_valid_level_full,
2336: x_return_status OUT NOCOPY VARCHAR2,
2337: x_loading_status OUT NOCOPY VARCHAR2,

Line 2335: := fnd_api.g_valid_level_full,

2331: p_api_version IN NUMBER,
2332: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2333: p_commit IN VARCHAR2 := fnd_api.g_false,
2334: p_validation_level IN NUMBER
2335: := fnd_api.g_valid_level_full,
2336: x_return_status OUT NOCOPY VARCHAR2,
2337: x_loading_status OUT NOCOPY VARCHAR2,
2338: x_msg_count OUT NOCOPY NUMBER,
2339: x_msg_data OUT NOCOPY VARCHAR2,

Line 2361: IF NOT fnd_api.compatible_api_call (l_api_version,

2357: -- Standard Start of API savepoint
2358: SAVEPOINT delete_role_plan;
2359:
2360: -- Standard call to check for call compatibility.
2361: IF NOT fnd_api.compatible_api_call (l_api_version,
2362: p_api_version,
2363: l_api_name,
2364: g_pkg_name
2365: )

Line 2367: RAISE fnd_api.g_exc_unexpected_error;

2363: l_api_name,
2364: g_pkg_name
2365: )
2366: THEN
2367: RAISE fnd_api.g_exc_unexpected_error;
2368: END IF;
2369:
2370: -- Initialize message list if p_init_msg_list is set to TRUE.
2371: IF fnd_api.to_boolean (p_init_msg_list)

Line 2371: IF fnd_api.to_boolean (p_init_msg_list)

2367: RAISE fnd_api.g_exc_unexpected_error;
2368: END IF;
2369:
2370: -- Initialize message list if p_init_msg_list is set to TRUE.
2371: IF fnd_api.to_boolean (p_init_msg_list)
2372: THEN
2373: fnd_msg_pub.initialize;
2374: END IF;
2375:

Line 2377: x_return_status := fnd_api.g_ret_sts_success;

2373: fnd_msg_pub.initialize;
2374: END IF;
2375:
2376: -- Initialize API return status to success
2377: x_return_status := fnd_api.g_ret_sts_success;
2378: x_loading_status := 'CN_DELETED';
2379:
2380: -- START OF MOAC ORG_ID VALIDATION
2381: l_org_id := p_role_plan_rec.org_id;

Line 2426: IF (x_return_status = fnd_api.g_ret_sts_error)

2422: x_msg_data => x_msg_data,
2423: p_role_plan_rec => l_rec
2424: );
2425:
2426: IF (x_return_status = fnd_api.g_ret_sts_error)
2427: THEN
2428: RAISE fnd_api.g_exc_error;
2429: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2430: THEN

Line 2428: RAISE fnd_api.g_exc_error;

2424: );
2425:
2426: IF (x_return_status = fnd_api.g_ret_sts_error)
2427: THEN
2428: RAISE fnd_api.g_exc_error;
2429: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2430: THEN
2431: RAISE fnd_api.g_exc_unexpected_error;
2432: END IF;

Line 2429: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2425:
2426: IF (x_return_status = fnd_api.g_ret_sts_error)
2427: THEN
2428: RAISE fnd_api.g_exc_error;
2429: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2430: THEN
2431: RAISE fnd_api.g_exc_unexpected_error;
2432: END IF;
2433: END IF;

Line 2431: RAISE fnd_api.g_exc_unexpected_error;

2427: THEN
2428: RAISE fnd_api.g_exc_error;
2429: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2430: THEN
2431: RAISE fnd_api.g_exc_unexpected_error;
2432: END IF;
2433: END IF;
2434:
2435: -- Vertical industry pre-processing section

Line 2454: IF (x_return_status = fnd_api.g_ret_sts_error)

2450: x_msg_data => x_msg_data,
2451: p_role_plan_rec => l_rec
2452: );
2453:
2454: IF (x_return_status = fnd_api.g_ret_sts_error)
2455: THEN
2456: RAISE fnd_api.g_exc_error;
2457: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2458: THEN

Line 2456: RAISE fnd_api.g_exc_error;

2452: );
2453:
2454: IF (x_return_status = fnd_api.g_ret_sts_error)
2455: THEN
2456: RAISE fnd_api.g_exc_error;
2457: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2458: THEN
2459: RAISE fnd_api.g_exc_unexpected_error;
2460: END IF;

Line 2457: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2453:
2454: IF (x_return_status = fnd_api.g_ret_sts_error)
2455: THEN
2456: RAISE fnd_api.g_exc_error;
2457: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2458: THEN
2459: RAISE fnd_api.g_exc_unexpected_error;
2460: END IF;
2461: END IF;

Line 2459: RAISE fnd_api.g_exc_unexpected_error;

2455: THEN
2456: RAISE fnd_api.g_exc_error;
2457: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2458: THEN
2459: RAISE fnd_api.g_exc_unexpected_error;
2460: END IF;
2461: END IF;
2462:
2463: -- Start of API body

Line 2483: IF (x_return_status <> fnd_api.g_ret_sts_success)

2479: p_loading_status => x_loading_status, -- in
2480: x_loading_status => x_loading_status -- out
2481: );
2482:
2483: IF (x_return_status <> fnd_api.g_ret_sts_success)
2484: THEN
2485: RAISE fnd_api.g_exc_error;
2486: ELSE
2487: -- need to call srp assignment API to delete

Line 2485: RAISE fnd_api.g_exc_error;

2481: );
2482:
2483: IF (x_return_status <> fnd_api.g_ret_sts_success)
2484: THEN
2485: RAISE fnd_api.g_exc_error;
2486: ELSE
2487: -- need to call srp assignment API to delete
2488: l_role_id := cn_api.get_role_id(l_rec.role_name);
2489: srp_plan_assignment_for_delete

Line 2498: IF (x_return_status <> fnd_api.g_ret_sts_success)

2494: x_loading_status => x_loading_status,
2495: p_org_id => l_rec.org_id
2496: );
2497:
2498: IF (x_return_status <> fnd_api.g_ret_sts_success)
2499: THEN
2500: RAISE fnd_api.g_exc_error;
2501: END IF;
2502:

Line 2500: RAISE fnd_api.g_exc_error;

2496: );
2497:
2498: IF (x_return_status <> fnd_api.g_ret_sts_success)
2499: THEN
2500: RAISE fnd_api.g_exc_error;
2501: END IF;
2502:
2503: -- Added as part of 12+ enhancment
2504: -- When a plan has been unassigned from role

Line 2519: IF (x_return_status = fnd_api.g_ret_sts_error)

2515: x_return_status => x_return_status,
2516: x_msg_count => x_msg_count,
2517: x_msg_data => x_msg_data);
2518:
2519: IF (x_return_status = fnd_api.g_ret_sts_error)
2520: THEN
2521: RAISE fnd_api.g_exc_error;
2522: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2523: THEN

Line 2521: RAISE fnd_api.g_exc_error;

2517: x_msg_data => x_msg_data);
2518:
2519: IF (x_return_status = fnd_api.g_ret_sts_error)
2520: THEN
2521: RAISE fnd_api.g_exc_error;
2522: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2523: THEN
2524: RAISE fnd_api.g_exc_unexpected_error;
2525: END IF;

Line 2522: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2518:
2519: IF (x_return_status = fnd_api.g_ret_sts_error)
2520: THEN
2521: RAISE fnd_api.g_exc_error;
2522: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2523: THEN
2524: RAISE fnd_api.g_exc_unexpected_error;
2525: END IF;
2526: -- Ends 12+ enhancement

Line 2524: RAISE fnd_api.g_exc_unexpected_error;

2520: THEN
2521: RAISE fnd_api.g_exc_error;
2522: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2523: THEN
2524: RAISE fnd_api.g_exc_unexpected_error;
2525: END IF;
2526: -- Ends 12+ enhancement
2527:
2528: -- delete_row

Line 2583: IF (x_return_status = fnd_api.g_ret_sts_error)

2579: x_msg_data => x_msg_data,
2580: p_role_plan_rec => l_rec
2581: );
2582:
2583: IF (x_return_status = fnd_api.g_ret_sts_error)
2584: THEN
2585: RAISE fnd_api.g_exc_error;
2586: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2587: THEN

Line 2585: RAISE fnd_api.g_exc_error;

2581: );
2582:
2583: IF (x_return_status = fnd_api.g_ret_sts_error)
2584: THEN
2585: RAISE fnd_api.g_exc_error;
2586: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2587: THEN
2588: RAISE fnd_api.g_exc_unexpected_error;
2589: END IF;

Line 2586: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2582:
2583: IF (x_return_status = fnd_api.g_ret_sts_error)
2584: THEN
2585: RAISE fnd_api.g_exc_error;
2586: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2587: THEN
2588: RAISE fnd_api.g_exc_unexpected_error;
2589: END IF;
2590: END IF;

Line 2588: RAISE fnd_api.g_exc_unexpected_error;

2584: THEN
2585: RAISE fnd_api.g_exc_error;
2586: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2587: THEN
2588: RAISE fnd_api.g_exc_unexpected_error;
2589: END IF;
2590: END IF;
2591:
2592: -- Vertical industry post-processing section

Line 2611: IF (x_return_status = fnd_api.g_ret_sts_error)

2607: x_msg_data => x_msg_data,
2608: p_role_plan_rec => l_rec
2609: );
2610:
2611: IF (x_return_status = fnd_api.g_ret_sts_error)
2612: THEN
2613: RAISE fnd_api.g_exc_error;
2614: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2615: THEN

Line 2613: RAISE fnd_api.g_exc_error;

2609: );
2610:
2611: IF (x_return_status = fnd_api.g_ret_sts_error)
2612: THEN
2613: RAISE fnd_api.g_exc_error;
2614: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2615: THEN
2616: RAISE fnd_api.g_exc_unexpected_error;
2617: END IF;

Line 2614: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2610:
2611: IF (x_return_status = fnd_api.g_ret_sts_error)
2612: THEN
2613: RAISE fnd_api.g_exc_error;
2614: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2615: THEN
2616: RAISE fnd_api.g_exc_unexpected_error;
2617: END IF;
2618: END IF;

Line 2616: RAISE fnd_api.g_exc_unexpected_error;

2612: THEN
2613: RAISE fnd_api.g_exc_error;
2614: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2615: THEN
2616: RAISE fnd_api.g_exc_unexpected_error;
2617: END IF;
2618: END IF;
2619:
2620: -- Message enable hook

Line 2657: IF (x_return_status = fnd_api.g_ret_sts_error)

2653: p_oai_array => l_oai_array,
2654: x_return_code => x_return_status
2655: );
2656:
2657: IF (x_return_status = fnd_api.g_ret_sts_error)
2658: THEN
2659: RAISE fnd_api.g_exc_error;
2660: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2661: THEN

Line 2659: RAISE fnd_api.g_exc_error;

2655: );
2656:
2657: IF (x_return_status = fnd_api.g_ret_sts_error)
2658: THEN
2659: RAISE fnd_api.g_exc_error;
2660: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2661: THEN
2662: RAISE fnd_api.g_exc_unexpected_error;
2663: END IF;

Line 2660: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2656:
2657: IF (x_return_status = fnd_api.g_ret_sts_error)
2658: THEN
2659: RAISE fnd_api.g_exc_error;
2660: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2661: THEN
2662: RAISE fnd_api.g_exc_unexpected_error;
2663: END IF;
2664: END IF;

Line 2662: RAISE fnd_api.g_exc_unexpected_error;

2658: THEN
2659: RAISE fnd_api.g_exc_error;
2660: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2661: THEN
2662: RAISE fnd_api.g_exc_unexpected_error;
2663: END IF;
2664: END IF;
2665: END IF;
2666:

Line 2668: IF fnd_api.to_boolean (p_commit)

2664: END IF;
2665: END IF;
2666:
2667: -- Standard check of p_commit.
2668: IF fnd_api.to_boolean (p_commit)
2669: THEN
2670: COMMIT WORK;
2671: END IF;
2672:

Line 2676: p_encoded => fnd_api.g_false

2672:
2673: -- Standard call to get message count and if count is 1, get message info.
2674: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2675: p_data => x_msg_data,
2676: p_encoded => fnd_api.g_false
2677: );
2678: EXCEPTION
2679: WHEN fnd_api.g_exc_error
2680: THEN

Line 2679: WHEN fnd_api.g_exc_error

2675: p_data => x_msg_data,
2676: p_encoded => fnd_api.g_false
2677: );
2678: EXCEPTION
2679: WHEN fnd_api.g_exc_error
2680: THEN
2681: ROLLBACK TO delete_role_plan;
2682: x_return_status := fnd_api.g_ret_sts_error;
2683: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 2682: x_return_status := fnd_api.g_ret_sts_error;

2678: EXCEPTION
2679: WHEN fnd_api.g_exc_error
2680: THEN
2681: ROLLBACK TO delete_role_plan;
2682: x_return_status := fnd_api.g_ret_sts_error;
2683: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2684: p_data => x_msg_data,
2685: p_encoded => fnd_api.g_false
2686: );

Line 2685: p_encoded => fnd_api.g_false

2681: ROLLBACK TO delete_role_plan;
2682: x_return_status := fnd_api.g_ret_sts_error;
2683: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2684: p_data => x_msg_data,
2685: p_encoded => fnd_api.g_false
2686: );
2687: WHEN fnd_api.g_exc_unexpected_error
2688: THEN
2689: ROLLBACK TO delete_role_plan;

Line 2687: WHEN fnd_api.g_exc_unexpected_error

2683: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2684: p_data => x_msg_data,
2685: p_encoded => fnd_api.g_false
2686: );
2687: WHEN fnd_api.g_exc_unexpected_error
2688: THEN
2689: ROLLBACK TO delete_role_plan;
2690: x_loading_status := 'UNEXPECTED_ERR';
2691: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2691: x_return_status := fnd_api.g_ret_sts_unexp_error;

2687: WHEN fnd_api.g_exc_unexpected_error
2688: THEN
2689: ROLLBACK TO delete_role_plan;
2690: x_loading_status := 'UNEXPECTED_ERR';
2691: x_return_status := fnd_api.g_ret_sts_unexp_error;
2692: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2693: p_data => x_msg_data,
2694: p_encoded => fnd_api.g_false
2695: );

Line 2694: p_encoded => fnd_api.g_false

2690: x_loading_status := 'UNEXPECTED_ERR';
2691: x_return_status := fnd_api.g_ret_sts_unexp_error;
2692: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2693: p_data => x_msg_data,
2694: p_encoded => fnd_api.g_false
2695: );
2696: WHEN OTHERS
2697: THEN
2698: ROLLBACK TO delete_role_plan;

Line 2700: x_return_status := fnd_api.g_ret_sts_unexp_error;

2696: WHEN OTHERS
2697: THEN
2698: ROLLBACK TO delete_role_plan;
2699: x_loading_status := 'UNEXPECTED_ERR';
2700: x_return_status := fnd_api.g_ret_sts_unexp_error;
2701:
2702: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2703: THEN
2704: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 2709: p_encoded => fnd_api.g_false

2705: END IF;
2706:
2707: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2708: p_data => x_msg_data,
2709: p_encoded => fnd_api.g_false
2710: );
2711: END delete_role_plan;
2712:
2713: END cn_role_plans_pub;