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

Line 130: RAISE FND_API.G_EXC_ERROR ;

126: FND_MESSAGE.SET_TOKEN('SALES_REP_NAME', l_salesrep_name);
127: FND_MESSAGE.SET_TOKEN('ROLE_NAME', l_role_name);
128: fnd_msg_pub.ADD;
129: END IF;
130: RAISE FND_API.G_EXC_ERROR ;
131: END IF;
132:
133: -- get pay groups start and end dates
134: select start_date, end_date

Line 401: x_return_status := FND_API.G_RET_STS_SUCCESS;

397:
398: BEGIN
399:
400: -- Initialize API return status to success
401: x_return_status := FND_API.G_RET_STS_SUCCESS;
402: l_loading_status := p_loading_status;
403: x_loading_status := p_loading_status;
404:
405:

Line 415: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN

411: IF (cn_api.chk_miss_null_char_para
412: (p_char_para => p_role_pay_groups_rec.role_name,
413: p_obj_name => G_ROLE_NAME,
414: p_loading_status => l_loading_status,
415: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN
416: RAISE FND_API.G_EXC_ERROR ;
417: END IF;
418:
419: -- pay_group_name can not be missing or null

Line 416: RAISE FND_API.G_EXC_ERROR ;

412: (p_char_para => p_role_pay_groups_rec.role_name,
413: p_obj_name => G_ROLE_NAME,
414: p_loading_status => l_loading_status,
415: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN
416: RAISE FND_API.G_EXC_ERROR ;
417: END IF;
418:
419: -- pay_group_name can not be missing or null
420: IF (cn_api.chk_miss_null_char_para

Line 424: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN

420: IF (cn_api.chk_miss_null_char_para
421: (p_char_para => p_role_pay_groups_rec.pay_groups_name,
422: p_obj_name => G_PG_NAME,
423: p_loading_status => l_loading_status,
424: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN
425: RAISE FND_API.G_EXC_ERROR ;
426: END IF;
427:
428: -- start_date can not be null

Line 425: RAISE FND_API.G_EXC_ERROR ;

421: (p_char_para => p_role_pay_groups_rec.pay_groups_name,
422: p_obj_name => G_PG_NAME,
423: p_loading_status => l_loading_status,
424: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN
425: RAISE FND_API.G_EXC_ERROR ;
426: END IF;
427:
428: -- start_date can not be null
429: -- start_date can not be missing

Line 434: p_end_date_nullable => FND_API.G_TRUE,

430: -- start_date < end_date if end_date is null
431: IF ( (cn_api.invalid_date_range
432: (p_start_date => p_role_pay_groups_rec.start_date,
433: p_end_date => p_role_pay_groups_rec.end_date,
434: p_end_date_nullable => FND_API.G_TRUE,
435: p_loading_status => l_loading_status,
436: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN
437: RAISE FND_API.G_EXC_ERROR ;
438: END IF;

Line 436: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN

432: (p_start_date => p_role_pay_groups_rec.start_date,
433: p_end_date => p_role_pay_groups_rec.end_date,
434: p_end_date_nullable => FND_API.G_TRUE,
435: p_loading_status => l_loading_status,
436: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN
437: RAISE FND_API.G_EXC_ERROR ;
438: END IF;
439:
440: -- role_name must exist in cn_roles

Line 437: RAISE FND_API.G_EXC_ERROR ;

433: p_end_date => p_role_pay_groups_rec.end_date,
434: p_end_date_nullable => FND_API.G_TRUE,
435: p_loading_status => l_loading_status,
436: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN
437: RAISE FND_API.G_EXC_ERROR ;
438: END IF;
439:
440: -- role_name must exist in cn_roles
441: IF NOT valid_role_name(p_role_pay_groups_rec.role_name) THEN

Line 448: RAISE fnd_api.g_exc_error;

444: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pay_groups_rec.role_name);
445: fnd_msg_pub.ADD;
446: END IF;
447: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
448: RAISE fnd_api.g_exc_error;
449: ELSE
450: x_role_id := cn_api.get_role_id(p_role_pay_groups_rec.role_name);
451: END IF;
452: -- pay_group_name must exist in cn_pay_groups

Line 460: RAISE fnd_api.g_exc_error;

456: fnd_message.set_token('PAY_GROUP',p_role_pay_groups_rec.pay_groups_name);
457: fnd_msg_pub.ADD;
458: END IF;
459: x_loading_status := 'CN_RL_ASGN_PG_NOT_EXIST';
460: RAISE fnd_api.g_exc_error;
461: ELSE
462: x_pay_group_id := get_pg_id(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id);
463: END IF;
464:

Line 486: RAISE FND_API.G_EXC_ERROR;

482: fnd_msg_pub.add;
483: END IF;
484:
485: x_loading_status := 'CN_INVALID_ROLE_PGRP_ASGN_DT';
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488:
489: --
490: -- Check for overlapping assignments

Line 533: RAISE FND_API.G_EXC_ERROR;

529: x_loading_status := 'CN_RL_ROLE_PAY_GROUP_OVERLAP';
530:
531: --x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
532:
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535: END LOOP;
536:
537: --Commented the code as the overlap conditions are handled in the code above

Line 557: RAISE FND_API.G_EXC_ERROR;

553: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
554: fnd_msg_pub.add;
555: END IF;
556: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;
559:
560: SELECT count(1)
561: INTO l_count

Line 578: RAISE FND_API.G_EXC_ERROR;

574: fnd_msg_pub.add;
575: END IF;
576:
577: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
578: RAISE FND_API.G_EXC_ERROR;
579: END IF; */
580:
581: --End of API body
582: -- Standard call to get message count and if count is 1, get message info.

Line 587: p_encoded => FND_API.G_FALSE

583: FND_MSG_PUB.Count_And_Get
584: (
585: p_count => x_msg_count ,
586: p_data => x_msg_data ,
587: p_encoded => FND_API.G_FALSE
588: );
589:
590: EXCEPTION
591: WHEN FND_API.G_EXC_ERROR THEN

Line 591: WHEN FND_API.G_EXC_ERROR THEN

587: p_encoded => FND_API.G_FALSE
588: );
589:
590: EXCEPTION
591: WHEN FND_API.G_EXC_ERROR THEN
592: x_return_status := FND_API.G_RET_STS_ERROR ;
593: FND_MSG_PUB.Count_And_Get
594: (
595: p_count => x_msg_count ,

Line 592: x_return_status := FND_API.G_RET_STS_ERROR ;

588: );
589:
590: EXCEPTION
591: WHEN FND_API.G_EXC_ERROR THEN
592: x_return_status := FND_API.G_RET_STS_ERROR ;
593: FND_MSG_PUB.Count_And_Get
594: (
595: p_count => x_msg_count ,
596: p_data => x_msg_data ,

Line 597: p_encoded => FND_API.G_FALSE

593: FND_MSG_PUB.Count_And_Get
594: (
595: p_count => x_msg_count ,
596: p_data => x_msg_data ,
597: p_encoded => FND_API.G_FALSE
598: );
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
601: x_loading_status := 'UNEXPECTED_ERR';

Line 599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

595: p_count => x_msg_count ,
596: p_data => x_msg_data ,
597: p_encoded => FND_API.G_FALSE
598: );
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
601: x_loading_status := 'UNEXPECTED_ERR';
602: FND_MSG_PUB.Count_And_Get
603: (

Line 600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

596: p_data => x_msg_data ,
597: p_encoded => FND_API.G_FALSE
598: );
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
601: x_loading_status := 'UNEXPECTED_ERR';
602: FND_MSG_PUB.Count_And_Get
603: (
604: p_count => x_msg_count ,

Line 606: p_encoded => FND_API.G_FALSE

602: FND_MSG_PUB.Count_And_Get
603: (
604: p_count => x_msg_count ,
605: p_data => x_msg_data ,
606: p_encoded => FND_API.G_FALSE
607: );
608: WHEN OTHERS THEN
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610: x_loading_status := 'UNEXPECTED_ERR';

Line 609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

605: p_data => x_msg_data ,
606: p_encoded => FND_API.G_FALSE
607: );
608: WHEN OTHERS THEN
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610: x_loading_status := 'UNEXPECTED_ERR';
611: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
612: THEN
613: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 619: p_encoded => FND_API.G_FALSE

615: FND_MSG_PUB.Count_And_Get
616: (
617: p_count => x_msg_count ,
618: p_data => x_msg_data ,
619: p_encoded => FND_API.G_FALSE
620: );
621: END check_valid_insert;
622:
623:

Line 646: x_return_status := FND_API.G_RET_STS_SUCCESS;

642:
643: BEGIN
644:
645: -- Initialize API return status to success
646: x_return_status := FND_API.G_RET_STS_SUCCESS;
647: x_loading_status := p_loading_status;
648:
649: -- Start of API body
650:

Line 666: RAISE FND_API.G_EXC_ERROR ;

662: FND_MESSAGE.SET_NAME('CN' ,'CN_RL_DEL_ROLE_PLAN_NOT_EXIST');
663: FND_MSG_PUB.Add;
664: END IF;
665: x_loading_status := 'CN_RL_DEL_ROLE_PLAN_NOT_EXIST';
666: RAISE FND_API.G_EXC_ERROR ;
667: END IF;
668:
669:
670:

Line 679: p_encoded => FND_API.G_FALSE

675: FND_MSG_PUB.Count_And_Get
676: (
677: p_count => x_msg_count ,
678: p_data => x_msg_data ,
679: p_encoded => FND_API.G_FALSE
680: );
681:
682: EXCEPTION
683: WHEN FND_API.G_EXC_ERROR THEN

Line 683: WHEN FND_API.G_EXC_ERROR THEN

679: p_encoded => FND_API.G_FALSE
680: );
681:
682: EXCEPTION
683: WHEN FND_API.G_EXC_ERROR THEN
684: x_return_status := FND_API.G_RET_STS_ERROR ;
685: FND_MSG_PUB.Count_And_Get
686: (
687: p_count => x_msg_count ,

Line 684: x_return_status := FND_API.G_RET_STS_ERROR ;

680: );
681:
682: EXCEPTION
683: WHEN FND_API.G_EXC_ERROR THEN
684: x_return_status := FND_API.G_RET_STS_ERROR ;
685: FND_MSG_PUB.Count_And_Get
686: (
687: p_count => x_msg_count ,
688: p_data => x_msg_data ,

Line 689: p_encoded => FND_API.G_FALSE

685: FND_MSG_PUB.Count_And_Get
686: (
687: p_count => x_msg_count ,
688: p_data => x_msg_data ,
689: p_encoded => FND_API.G_FALSE
690: );
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
693: x_loading_status := 'UNEXPECTED_ERR';

Line 691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

687: p_count => x_msg_count ,
688: p_data => x_msg_data ,
689: p_encoded => FND_API.G_FALSE
690: );
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
693: x_loading_status := 'UNEXPECTED_ERR';
694: FND_MSG_PUB.Count_And_Get
695: (

Line 692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

688: p_data => x_msg_data ,
689: p_encoded => FND_API.G_FALSE
690: );
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
693: x_loading_status := 'UNEXPECTED_ERR';
694: FND_MSG_PUB.Count_And_Get
695: (
696: p_count => x_msg_count ,

Line 698: p_encoded => FND_API.G_FALSE

694: FND_MSG_PUB.Count_And_Get
695: (
696: p_count => x_msg_count ,
697: p_data => x_msg_data ,
698: p_encoded => FND_API.G_FALSE
699: );
700: WHEN OTHERS THEN
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
702: x_loading_status := 'UNEXPECTED_ERR';

Line 701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

697: p_data => x_msg_data ,
698: p_encoded => FND_API.G_FALSE
699: );
700: WHEN OTHERS THEN
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
702: x_loading_status := 'UNEXPECTED_ERR';
703: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
704: THEN
705: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 711: p_encoded => FND_API.G_FALSE

707: FND_MSG_PUB.Count_And_Get
708: (
709: p_count => x_msg_count ,
710: p_data => x_msg_data ,
711: p_encoded => FND_API.G_FALSE
712: );
713:
714: END check_valid_delete;
715:

Line 746: x_return_status := FND_API.G_RET_STS_SUCCESS;

742:
743: BEGIN
744:
745: -- Initialize API return status to success
746: x_return_status := FND_API.G_RET_STS_SUCCESS;
747: x_loading_status := p_loading_status;
748:
749: FOR l_rec IN l_cur
750: LOOP

Line 755: p_init_msg_list => fnd_api.g_false,

751:
752: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
753: (
754: p_api_version => 1.0,
755: p_init_msg_list => fnd_api.g_false,
756: p_commit => fnd_api.g_false,
757: p_validation_level => fnd_api.g_valid_level_full,
758: x_return_status => l_return_status,
759: x_msg_count => l_msg_count,

Line 756: p_commit => fnd_api.g_false,

752: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
753: (
754: p_api_version => 1.0,
755: p_init_msg_list => fnd_api.g_false,
756: p_commit => fnd_api.g_false,
757: p_validation_level => fnd_api.g_valid_level_full,
758: x_return_status => l_return_status,
759: x_msg_count => l_msg_count,
760: x_msg_data => l_msg_data,

Line 757: p_validation_level => fnd_api.g_valid_level_full,

753: (
754: p_api_version => 1.0,
755: p_init_msg_list => fnd_api.g_false,
756: p_commit => fnd_api.g_false,
757: p_validation_level => fnd_api.g_valid_level_full,
758: x_return_status => l_return_status,
759: x_msg_count => l_msg_count,
760: x_msg_data => l_msg_data,
761: p_srp_role_id => l_rec.srp_role_id,

Line 765: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

761: p_srp_role_id => l_rec.srp_role_id,
762: p_role_plan_id => p_role_plan_id,
763: x_loading_status => l_loading_status);
764:
765: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
766: x_return_status := l_return_status;
767: x_loading_status := l_loading_status;
768: EXIT;
769: END IF;

Line 781: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

777: -- --------------------------------------------------------------------------*
778: PROCEDURE Create_Role_Pay_Groups
779: (
780: p_api_version IN NUMBER,
781: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
782: p_commit IN VARCHAR2 := FND_API.G_FALSE,
783: p_validation_level IN NUMBER :=FND_API.g_valid_level_full,
784: x_return_status OUT NOCOPY VARCHAR2,
785: x_loading_status OUT NOCOPY VARCHAR2,

Line 782: p_commit IN VARCHAR2 := FND_API.G_FALSE,

778: PROCEDURE Create_Role_Pay_Groups
779: (
780: p_api_version IN NUMBER,
781: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
782: p_commit IN VARCHAR2 := FND_API.G_FALSE,
783: p_validation_level IN NUMBER :=FND_API.g_valid_level_full,
784: x_return_status OUT NOCOPY VARCHAR2,
785: x_loading_status OUT NOCOPY VARCHAR2,
786: x_msg_count OUT NOCOPY NUMBER,

Line 783: p_validation_level IN NUMBER :=FND_API.g_valid_level_full,

779: (
780: p_api_version IN NUMBER,
781: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
782: p_commit IN VARCHAR2 := FND_API.G_FALSE,
783: p_validation_level IN NUMBER :=FND_API.g_valid_level_full,
784: x_return_status OUT NOCOPY VARCHAR2,
785: x_loading_status OUT NOCOPY VARCHAR2,
786: x_msg_count OUT NOCOPY NUMBER,
787: x_msg_data OUT NOCOPY VARCHAR2,

Line 873: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

869: -- Standard Start of API savepoint
870: SAVEPOINT Create_Role_Pay_Groups;
871:
872: -- Standard call to check for call compatibility.
873: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
874: p_api_version ,
875: l_api_name ,
876: G_PKG_NAME )
877: THEN

Line 878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

874: p_api_version ,
875: l_api_name ,
876: G_PKG_NAME )
877: THEN
878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
879: END IF;
880:
881: -- Initialize message list if p_init_msg_list is set to TRUE.
882: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 882: IF FND_API.to_Boolean( p_init_msg_list ) THEN

878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
879: END IF;
880:
881: -- Initialize message list if p_init_msg_list is set to TRUE.
882: IF FND_API.to_Boolean( p_init_msg_list ) THEN
883: FND_MSG_PUB.initialize;
884: END IF;
885:
886: -- Initialize API return status to success

Line 887: x_return_status := FND_API.G_RET_STS_SUCCESS;

883: FND_MSG_PUB.initialize;
884: END IF;
885:
886: -- Initialize API return status to success
887: x_return_status := FND_API.G_RET_STS_SUCCESS;
888: x_loading_status := 'CN_INSERTED';
889:
890: -- Assign the parameter to a local variable to be passed to Pre, Post
891: -- and Business APIs

Line 908: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

904: p_loading_status => l_loading_status, -- in
905: x_loading_status => x_loading_status -- out
906: );
907:
908: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
909: RAISE FND_API.G_EXC_ERROR ;
910: END IF;
911: l_role_pay_group_id := p_role_pay_groups_rec.role_pay_group_id;
912:

Line 909: RAISE FND_API.G_EXC_ERROR ;

905: x_loading_status => x_loading_status -- out
906: );
907:
908: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
909: RAISE FND_API.G_EXC_ERROR ;
910: END IF;
911: l_role_pay_group_id := p_role_pay_groups_rec.role_pay_group_id;
912:
913: cn_role_pay_groups_pkg.INSERT_ROW

Line 1064: p_init_msg_list => FND_API.G_FALSE,

1060: FOR role_plans IN get_role_plans(roles.role_id,roles.org_id) LOOP
1061: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1062: (
1063: p_api_version => 1.0,
1064: p_init_msg_list => FND_API.G_FALSE,
1065: p_commit => FND_API.G_FALSE,
1066: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1067: x_return_status => x_return_status,
1068: x_msg_count => x_msg_count,

Line 1065: p_commit => FND_API.G_FALSE,

1061: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1062: (
1063: p_api_version => 1.0,
1064: p_init_msg_list => FND_API.G_FALSE,
1065: p_commit => FND_API.G_FALSE,
1066: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1067: x_return_status => x_return_status,
1068: x_msg_count => x_msg_count,
1069: x_msg_data => x_msg_data,

Line 1066: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1062: (
1063: p_api_version => 1.0,
1064: p_init_msg_list => FND_API.G_FALSE,
1065: p_commit => FND_API.G_FALSE,
1066: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1067: x_return_status => x_return_status,
1068: x_msg_count => x_msg_count,
1069: x_msg_data => x_msg_data,
1070: p_srp_role_id => roles.srp_role_id,

Line 1073: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1069: x_msg_data => x_msg_data,
1070: p_srp_role_id => roles.srp_role_id,
1071: p_role_plan_id => role_plans.role_plan_id,
1072: x_loading_status => x_loading_status );
1073: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1074: RAISE fnd_api.g_exc_error;
1075: END IF;
1076:
1077: END LOOP;

Line 1074: RAISE fnd_api.g_exc_error;

1070: p_srp_role_id => roles.srp_role_id,
1071: p_role_plan_id => role_plans.role_plan_id,
1072: x_loading_status => x_loading_status );
1073: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1074: RAISE fnd_api.g_exc_error;
1075: END IF;
1076:
1077: END LOOP;
1078: END IF;

Line 1096: p_init_msg_list => fnd_api.g_false,

1092: IF nvl(plans.end_date, l_null_date) > plans.start_date THEN
1093:
1094: cn_srp_periods_pvt.create_srp_periods
1095: ( p_api_version => p_api_version,
1096: p_init_msg_list => fnd_api.g_false,
1097: p_commit => fnd_api.g_false,
1098: p_validation_level => p_validation_level,
1099: x_return_status => x_return_status,
1100: x_msg_count => x_msg_count,

Line 1097: p_commit => fnd_api.g_false,

1093:
1094: cn_srp_periods_pvt.create_srp_periods
1095: ( p_api_version => p_api_version,
1096: p_init_msg_list => fnd_api.g_false,
1097: p_commit => fnd_api.g_false,
1098: p_validation_level => p_validation_level,
1099: x_return_status => x_return_status,
1100: x_msg_count => x_msg_count,
1101: x_msg_data => x_msg_data,

Line 1108: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1104: p_comp_plan_id => plans.comp_plan_id,
1105: p_start_date => plans.start_date,
1106: p_end_date => plans.end_date,
1107: x_loading_status => x_loading_status);
1108: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1109: RAISE fnd_api.g_exc_error;
1110: END IF;
1111:
1112: END IF;

Line 1109: RAISE fnd_api.g_exc_error;

1105: p_start_date => plans.start_date,
1106: p_end_date => plans.end_date,
1107: x_loading_status => x_loading_status);
1108: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1109: RAISE fnd_api.g_exc_error;
1110: END IF;
1111:
1112: END IF;
1113: END LOOP;

Line 1123: IF FND_API.To_Boolean( p_commit ) THEN

1119:
1120: -- End of API body
1121: -- Standard check of p_commit.
1122:
1123: IF FND_API.To_Boolean( p_commit ) THEN
1124: COMMIT WORK;
1125: END IF;
1126:
1127:

Line 1134: p_encoded => FND_API.G_FALSE

1130: FND_MSG_PUB.Count_And_Get
1131: (
1132: p_count => x_msg_count ,
1133: p_data => x_msg_data ,
1134: p_encoded => FND_API.G_FALSE
1135: );
1136:
1137: EXCEPTION
1138: WHEN FND_API.G_EXC_ERROR THEN

Line 1138: WHEN FND_API.G_EXC_ERROR THEN

1134: p_encoded => FND_API.G_FALSE
1135: );
1136:
1137: EXCEPTION
1138: WHEN FND_API.G_EXC_ERROR THEN
1139: ROLLBACK TO Create_Role_Pay_Groups;
1140: x_return_status := FND_API.G_RET_STS_ERROR ;
1141: FND_MSG_PUB.Count_And_Get
1142: (

Line 1140: x_return_status := FND_API.G_RET_STS_ERROR ;

1136:
1137: EXCEPTION
1138: WHEN FND_API.G_EXC_ERROR THEN
1139: ROLLBACK TO Create_Role_Pay_Groups;
1140: x_return_status := FND_API.G_RET_STS_ERROR ;
1141: FND_MSG_PUB.Count_And_Get
1142: (
1143: p_count => x_msg_count ,
1144: p_data => x_msg_data ,

Line 1145: p_encoded => FND_API.G_FALSE

1141: FND_MSG_PUB.Count_And_Get
1142: (
1143: p_count => x_msg_count ,
1144: p_data => x_msg_data ,
1145: p_encoded => FND_API.G_FALSE
1146: );
1147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1148: ROLLBACK TO Create_Role_Pay_Groups;
1149: x_loading_status := 'UNEXPECTED_ERR';

Line 1147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1143: p_count => x_msg_count ,
1144: p_data => x_msg_data ,
1145: p_encoded => FND_API.G_FALSE
1146: );
1147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1148: ROLLBACK TO Create_Role_Pay_Groups;
1149: x_loading_status := 'UNEXPECTED_ERR';
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1151: FND_MSG_PUB.Count_And_Get

Line 1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1146: );
1147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1148: ROLLBACK TO Create_Role_Pay_Groups;
1149: x_loading_status := 'UNEXPECTED_ERR';
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1151: FND_MSG_PUB.Count_And_Get
1152: (
1153: p_count => x_msg_count ,
1154: p_data => x_msg_data ,

Line 1155: p_encoded => FND_API.G_FALSE

1151: FND_MSG_PUB.Count_And_Get
1152: (
1153: p_count => x_msg_count ,
1154: p_data => x_msg_data ,
1155: p_encoded => FND_API.G_FALSE
1156: );
1157: WHEN OTHERS THEN
1158: ROLLBACK TO Create_Role_Pay_Groups;
1159: x_loading_status := 'UNEXPECTED_ERR';

Line 1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1156: );
1157: WHEN OTHERS THEN
1158: ROLLBACK TO Create_Role_Pay_Groups;
1159: x_loading_status := 'UNEXPECTED_ERR';
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1162: THEN
1163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1164: END IF;

Line 1169: p_encoded => FND_API.G_FALSE

1165: FND_MSG_PUB.Count_And_Get
1166: (
1167: p_count => x_msg_count ,
1168: p_data => x_msg_data ,
1169: p_encoded => FND_API.G_FALSE
1170: );
1171:
1172: END Create_Role_Pay_Groups;
1173:

Line 1182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

1178: -- Procedure: Delete_Role_Pay_Groups
1179: -- --------------------------------------------------------------------------*
1180: PROCEDURE Delete_Role_Pay_Groups
1181: ( p_api_version IN NUMBER ,
1182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1183: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1185: x_return_status OUT NOCOPY VARCHAR2 ,
1186: x_loading_status OUT NOCOPY VARCHAR2 ,

Line 1183: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

1179: -- --------------------------------------------------------------------------*
1180: PROCEDURE Delete_Role_Pay_Groups
1181: ( p_api_version IN NUMBER ,
1182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1183: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1185: x_return_status OUT NOCOPY VARCHAR2 ,
1186: x_loading_status OUT NOCOPY VARCHAR2 ,
1187: x_msg_count OUT NOCOPY NUMBER ,

Line 1184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1180: PROCEDURE Delete_Role_Pay_Groups
1181: ( p_api_version IN NUMBER ,
1182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1183: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1185: x_return_status OUT NOCOPY VARCHAR2 ,
1186: x_loading_status OUT NOCOPY VARCHAR2 ,
1187: x_msg_count OUT NOCOPY NUMBER ,
1188: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 1253: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1249: SAVEPOINT delete_role_pay_groups;
1250:
1251: -- Standard call to check for call compatibility.
1252:
1253: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1254: p_api_version ,
1255: l_api_name ,
1256: G_PKG_NAME )
1257: THEN

Line 1258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1254: p_api_version ,
1255: l_api_name ,
1256: G_PKG_NAME )
1257: THEN
1258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1259: END IF;
1260:
1261: -- Initialize message list if p_init_msg_list is set to TRUE.
1262: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1262: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1259: END IF;
1260:
1261: -- Initialize message list if p_init_msg_list is set to TRUE.
1262: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1263: FND_MSG_PUB.initialize;
1264: END IF;
1265:
1266: -- Initialize API return status to success

Line 1267: x_return_status := FND_API.G_RET_STS_SUCCESS;

1263: FND_MSG_PUB.initialize;
1264: END IF;
1265:
1266: -- Initialize API return status to success
1267: x_return_status := FND_API.G_RET_STS_SUCCESS;
1268: x_loading_status := 'CN_DELETED';
1269:
1270:
1271: -- Assign the parameter to a local variable to be passed to Pre, Post

Line 1289: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1285: p_loading_status => l_loading_status, -- in
1286: x_loading_status => x_loading_status -- out
1287: );
1288:
1289: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1290: RAISE FND_API.G_EXC_ERROR ;
1291: ELSE
1292: -- delete_row
1293:

Line 1290: RAISE FND_API.G_EXC_ERROR ;

1286: x_loading_status => x_loading_status -- out
1287: );
1288:
1289: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1290: RAISE FND_API.G_EXC_ERROR ;
1291: ELSE
1292: -- delete_row
1293:
1294: l_role_id := cn_api.get_role_id(p_role_pay_groups_rec.role_name);

Line 1334: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1330: x_return_status => x_return_status,
1331: p_loading_status => l_loading_status,
1332: x_loading_status => x_loading_status);
1333:
1334: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1335: RAISE fnd_api.g_exc_error;
1336: END IF;
1337: END LOOP ;
1338:

Line 1335: RAISE fnd_api.g_exc_error;

1331: p_loading_status => l_loading_status,
1332: x_loading_status => x_loading_status);
1333:
1334: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1335: RAISE fnd_api.g_exc_error;
1336: END IF;
1337: END LOOP ;
1338:
1339: select count (*),min(start_date),nvl(max(end_date),l_null_date) end_date

Line 1358: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1354: x_return_status => x_return_status,
1355: p_loading_status => l_loading_status,
1356: x_loading_status => x_loading_status);
1357:
1358: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1359: RAISE FND_API.G_EXC_ERROR;
1360: END IF;
1361: END LOOP ;
1362: END LOOP;

Line 1359: RAISE FND_API.G_EXC_ERROR;

1355: p_loading_status => l_loading_status,
1356: x_loading_status => x_loading_status);
1357:
1358: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1359: RAISE FND_API.G_EXC_ERROR;
1360: END IF;
1361: END LOOP ;
1362: END LOOP;
1363: END IF;

Line 1381: p_init_msg_list => FND_API.G_FALSE,

1377: LOOP
1378: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1379: (
1380: p_api_version => 1.0,
1381: p_init_msg_list => FND_API.G_FALSE,
1382: p_commit => FND_API.G_FALSE,
1383: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1384: x_return_status => x_return_status,
1385: x_msg_count => x_msg_count,

Line 1382: p_commit => FND_API.G_FALSE,

1378: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1379: (
1380: p_api_version => 1.0,
1381: p_init_msg_list => FND_API.G_FALSE,
1382: p_commit => FND_API.G_FALSE,
1383: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1384: x_return_status => x_return_status,
1385: x_msg_count => x_msg_count,
1386: x_msg_data => x_msg_data,

Line 1383: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1379: (
1380: p_api_version => 1.0,
1381: p_init_msg_list => FND_API.G_FALSE,
1382: p_commit => FND_API.G_FALSE,
1383: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1384: x_return_status => x_return_status,
1385: x_msg_count => x_msg_count,
1386: x_msg_data => x_msg_data,
1387: p_srp_role_id => roles.srp_role_id,--changed this to support my new change(Harlen.Renu)

Line 1390: IF ( x_return_status <> FND_API.g_ret_sts_success) THEN

1386: x_msg_data => x_msg_data,
1387: p_srp_role_id => roles.srp_role_id,--changed this to support my new change(Harlen.Renu)
1388: p_role_plan_id => role_plans.role_plan_id,
1389: x_loading_status => x_loading_status );
1390: IF ( x_return_status <> FND_API.g_ret_sts_success) THEN
1391: RAISE fnd_api.g_exc_error;
1392: END IF;
1393: END LOOP;
1394: END IF;

Line 1391: RAISE fnd_api.g_exc_error;

1387: p_srp_role_id => roles.srp_role_id,--changed this to support my new change(Harlen.Renu)
1388: p_role_plan_id => role_plans.role_plan_id,
1389: x_loading_status => x_loading_status );
1390: IF ( x_return_status <> FND_API.g_ret_sts_success) THEN
1391: RAISE fnd_api.g_exc_error;
1392: END IF;
1393: END LOOP;
1394: END IF;
1395:

Line 1414: p_init_msg_list => fnd_api.g_false,

1410: IF nvl(plans.end_date, l_null_date) > plans.start_date THEN
1411:
1412: cn_srp_periods_pvt.create_srp_periods
1413: ( p_api_version => p_api_version,
1414: p_init_msg_list => fnd_api.g_false,
1415: p_commit => fnd_api.g_false,
1416: p_validation_level => p_validation_level,
1417: x_return_status => x_return_status,
1418: x_msg_count => x_msg_count,

Line 1415: p_commit => fnd_api.g_false,

1411:
1412: cn_srp_periods_pvt.create_srp_periods
1413: ( p_api_version => p_api_version,
1414: p_init_msg_list => fnd_api.g_false,
1415: p_commit => fnd_api.g_false,
1416: p_validation_level => p_validation_level,
1417: x_return_status => x_return_status,
1418: x_msg_count => x_msg_count,
1419: x_msg_data => x_msg_data,

Line 1426: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1422: p_comp_plan_id => plans.comp_plan_id,
1423: p_start_date => plans.start_date,
1424: p_end_date => plans.end_date,
1425: x_loading_status => x_loading_status);
1426: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1427: RAISE fnd_api.g_exc_error;
1428: END IF;
1429:
1430: END IF;

Line 1427: RAISE fnd_api.g_exc_error;

1423: p_start_date => plans.start_date,
1424: p_end_date => plans.end_date,
1425: x_loading_status => x_loading_status);
1426: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1427: RAISE fnd_api.g_exc_error;
1428: END IF;
1429:
1430: END IF;
1431: END LOOP;

Line 1455: IF FND_API.To_Boolean( p_commit ) THEN

1451: -- End of API body
1452:
1453: -- Standard check of p_commit.
1454:
1455: IF FND_API.To_Boolean( p_commit ) THEN
1456: COMMIT WORK;
1457: END IF;
1458:
1459:

Line 1466: p_encoded => FND_API.G_FALSE

1462: FND_MSG_PUB.Count_And_Get
1463: (
1464: p_count => x_msg_count ,
1465: p_data => x_msg_data ,
1466: p_encoded => FND_API.G_FALSE
1467: );
1468:
1469: EXCEPTION
1470: WHEN FND_API.G_EXC_ERROR THEN

Line 1470: WHEN FND_API.G_EXC_ERROR THEN

1466: p_encoded => FND_API.G_FALSE
1467: );
1468:
1469: EXCEPTION
1470: WHEN FND_API.G_EXC_ERROR THEN
1471: ROLLBACK TO Delete_Role_Pay_Groups;
1472: x_return_status := FND_API.G_RET_STS_ERROR ;
1473: FND_MSG_PUB.Count_And_Get
1474:

Line 1472: x_return_status := FND_API.G_RET_STS_ERROR ;

1468:
1469: EXCEPTION
1470: WHEN FND_API.G_EXC_ERROR THEN
1471: ROLLBACK TO Delete_Role_Pay_Groups;
1472: x_return_status := FND_API.G_RET_STS_ERROR ;
1473: FND_MSG_PUB.Count_And_Get
1474:
1475:
1476: (

Line 1479: p_encoded => FND_API.G_FALSE

1475:
1476: (
1477: p_count => x_msg_count ,
1478: p_data => x_msg_data ,
1479: p_encoded => FND_API.G_FALSE
1480: );
1481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1482: ROLLBACK TO Delete_Role_Pay_Groups;
1483: x_loading_status := 'UNEXPECTED_ERR';

Line 1481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1477: p_count => x_msg_count ,
1478: p_data => x_msg_data ,
1479: p_encoded => FND_API.G_FALSE
1480: );
1481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1482: ROLLBACK TO Delete_Role_Pay_Groups;
1483: x_loading_status := 'UNEXPECTED_ERR';
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1485: FND_MSG_PUB.Count_And_Get

Line 1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1480: );
1481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1482: ROLLBACK TO Delete_Role_Pay_Groups;
1483: x_loading_status := 'UNEXPECTED_ERR';
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1485: FND_MSG_PUB.Count_And_Get
1486: (
1487: p_count => x_msg_count ,
1488: p_data => x_msg_data ,

Line 1489: p_encoded => FND_API.G_FALSE

1485: FND_MSG_PUB.Count_And_Get
1486: (
1487: p_count => x_msg_count ,
1488: p_data => x_msg_data ,
1489: p_encoded => FND_API.G_FALSE
1490: );
1491: WHEN OTHERS THEN
1492: ROLLBACK TO Delete_Role_Pay_Groups;
1493: x_loading_status := 'UNEXPECTED_ERR';

Line 1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1490: );
1491: WHEN OTHERS THEN
1492: ROLLBACK TO Delete_Role_Pay_Groups;
1493: x_loading_status := 'UNEXPECTED_ERR';
1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1496: THEN
1497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1498: END IF;

Line 1503: p_encoded => FND_API.G_FALSE

1499: FND_MSG_PUB.Count_And_Get
1500: (
1501: p_count => x_msg_count ,
1502: p_data => x_msg_data ,
1503: p_encoded => FND_API.G_FALSE
1504: );
1505: END Delete_Role_Pay_Groups;
1506:
1507: