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 378: x_return_status := FND_API.G_RET_STS_SUCCESS;

374:
375: BEGIN
376:
377: -- Initialize API return status to success
378: x_return_status := FND_API.G_RET_STS_SUCCESS;
379: l_loading_status := p_loading_status;
380: x_loading_status := p_loading_status;
381:
382:

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

388: IF (cn_api.chk_miss_null_char_para
389: (p_char_para => p_role_pay_groups_rec.role_name,
390: p_obj_name => G_ROLE_NAME,
391: p_loading_status => l_loading_status,
392: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN
393: RAISE FND_API.G_EXC_ERROR ;
394: END IF;
395:
396: -- pay_group_name can not be missing or null

Line 393: RAISE FND_API.G_EXC_ERROR ;

389: (p_char_para => p_role_pay_groups_rec.role_name,
390: p_obj_name => G_ROLE_NAME,
391: p_loading_status => l_loading_status,
392: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN
393: RAISE FND_API.G_EXC_ERROR ;
394: END IF;
395:
396: -- pay_group_name can not be missing or null
397: IF (cn_api.chk_miss_null_char_para

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

397: IF (cn_api.chk_miss_null_char_para
398: (p_char_para => p_role_pay_groups_rec.pay_groups_name,
399: p_obj_name => G_PG_NAME,
400: p_loading_status => l_loading_status,
401: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN
402: RAISE FND_API.G_EXC_ERROR ;
403: END IF;
404:
405: -- start_date can not be null

Line 402: RAISE FND_API.G_EXC_ERROR ;

398: (p_char_para => p_role_pay_groups_rec.pay_groups_name,
399: p_obj_name => G_PG_NAME,
400: p_loading_status => l_loading_status,
401: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN
402: RAISE FND_API.G_EXC_ERROR ;
403: END IF;
404:
405: -- start_date can not be null
406: -- start_date can not be missing

Line 411: p_end_date_nullable => FND_API.G_TRUE,

407: -- start_date < end_date if end_date is null
408: IF ( (cn_api.invalid_date_range
409: (p_start_date => p_role_pay_groups_rec.start_date,
410: p_end_date => p_role_pay_groups_rec.end_date,
411: p_end_date_nullable => FND_API.G_TRUE,
412: p_loading_status => l_loading_status,
413: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN
414: RAISE FND_API.G_EXC_ERROR ;
415: END IF;

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

409: (p_start_date => p_role_pay_groups_rec.start_date,
410: p_end_date => p_role_pay_groups_rec.end_date,
411: p_end_date_nullable => FND_API.G_TRUE,
412: p_loading_status => l_loading_status,
413: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN
414: RAISE FND_API.G_EXC_ERROR ;
415: END IF;
416:
417: -- role_name must exist in cn_roles

Line 414: RAISE FND_API.G_EXC_ERROR ;

410: p_end_date => p_role_pay_groups_rec.end_date,
411: p_end_date_nullable => FND_API.G_TRUE,
412: p_loading_status => l_loading_status,
413: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN
414: RAISE FND_API.G_EXC_ERROR ;
415: END IF;
416:
417: -- role_name must exist in cn_roles
418: IF NOT valid_role_name(p_role_pay_groups_rec.role_name) THEN

Line 425: RAISE fnd_api.g_exc_error;

421: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pay_groups_rec.role_name);
422: fnd_msg_pub.ADD;
423: END IF;
424: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
425: RAISE fnd_api.g_exc_error;
426: ELSE
427: x_role_id := cn_api.get_role_id(p_role_pay_groups_rec.role_name);
428: END IF;
429: -- pay_group_name must exist in cn_pay_groups

Line 437: RAISE fnd_api.g_exc_error;

433: fnd_message.set_token('PAY_GROUP',p_role_pay_groups_rec.pay_groups_name);
434: fnd_msg_pub.ADD;
435: END IF;
436: x_loading_status := 'CN_RL_ASGN_PG_NOT_EXIST';
437: RAISE fnd_api.g_exc_error;
438: ELSE
439: x_pay_group_id := get_pg_id(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id);
440: END IF;
441:

Line 463: RAISE FND_API.G_EXC_ERROR;

459: fnd_msg_pub.add;
460: END IF;
461:
462: x_loading_status := 'CN_INVALID_ROLE_PGRP_ASGN_DT';
463: RAISE FND_API.G_EXC_ERROR;
464: END IF;
465:
466: --
467: -- Check for overlapping assignments

Line 510: RAISE FND_API.G_EXC_ERROR;

506: x_loading_status := 'CN_RL_ROLE_PAY_GROUP_OVERLAP';
507:
508: --x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
509:
510: RAISE FND_API.G_EXC_ERROR;
511: END IF;
512: END LOOP;
513:
514: --Commented the code as the overlap conditions are handled in the code above

Line 534: RAISE FND_API.G_EXC_ERROR;

530: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
531: fnd_msg_pub.add;
532: END IF;
533: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
534: RAISE FND_API.G_EXC_ERROR;
535: END IF;
536:
537: SELECT count(1)
538: INTO l_count

Line 555: RAISE FND_API.G_EXC_ERROR;

551: fnd_msg_pub.add;
552: END IF;
553:
554: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
555: RAISE FND_API.G_EXC_ERROR;
556: END IF; */
557:
558: --End of API body
559: -- Standard call to get message count and if count is 1, get message info.

Line 564: p_encoded => FND_API.G_FALSE

560: FND_MSG_PUB.Count_And_Get
561: (
562: p_count => x_msg_count ,
563: p_data => x_msg_data ,
564: p_encoded => FND_API.G_FALSE
565: );
566:
567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN

Line 568: WHEN FND_API.G_EXC_ERROR THEN

564: p_encoded => FND_API.G_FALSE
565: );
566:
567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN
569: x_return_status := FND_API.G_RET_STS_ERROR ;
570: FND_MSG_PUB.Count_And_Get
571: (
572: p_count => x_msg_count ,

Line 569: x_return_status := FND_API.G_RET_STS_ERROR ;

565: );
566:
567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN
569: x_return_status := FND_API.G_RET_STS_ERROR ;
570: FND_MSG_PUB.Count_And_Get
571: (
572: p_count => x_msg_count ,
573: p_data => x_msg_data ,

Line 574: p_encoded => FND_API.G_FALSE

570: FND_MSG_PUB.Count_And_Get
571: (
572: p_count => x_msg_count ,
573: p_data => x_msg_data ,
574: p_encoded => FND_API.G_FALSE
575: );
576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
578: x_loading_status := 'UNEXPECTED_ERR';

Line 576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

572: p_count => x_msg_count ,
573: p_data => x_msg_data ,
574: p_encoded => FND_API.G_FALSE
575: );
576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
578: x_loading_status := 'UNEXPECTED_ERR';
579: FND_MSG_PUB.Count_And_Get
580: (

Line 577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

573: p_data => x_msg_data ,
574: p_encoded => FND_API.G_FALSE
575: );
576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
578: x_loading_status := 'UNEXPECTED_ERR';
579: FND_MSG_PUB.Count_And_Get
580: (
581: p_count => x_msg_count ,

Line 583: p_encoded => FND_API.G_FALSE

579: FND_MSG_PUB.Count_And_Get
580: (
581: p_count => x_msg_count ,
582: p_data => x_msg_data ,
583: p_encoded => FND_API.G_FALSE
584: );
585: WHEN OTHERS THEN
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
587: x_loading_status := 'UNEXPECTED_ERR';

Line 586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

582: p_data => x_msg_data ,
583: p_encoded => FND_API.G_FALSE
584: );
585: WHEN OTHERS THEN
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
587: x_loading_status := 'UNEXPECTED_ERR';
588: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
589: THEN
590: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 596: p_encoded => FND_API.G_FALSE

592: FND_MSG_PUB.Count_And_Get
593: (
594: p_count => x_msg_count ,
595: p_data => x_msg_data ,
596: p_encoded => FND_API.G_FALSE
597: );
598: END check_valid_insert;
599:
600:

Line 623: x_return_status := FND_API.G_RET_STS_SUCCESS;

619:
620: BEGIN
621:
622: -- Initialize API return status to success
623: x_return_status := FND_API.G_RET_STS_SUCCESS;
624: x_loading_status := p_loading_status;
625:
626: -- Start of API body
627:

Line 643: RAISE FND_API.G_EXC_ERROR ;

639: FND_MESSAGE.SET_NAME('CN' ,'CN_RL_DEL_ROLE_PLAN_NOT_EXIST');
640: FND_MSG_PUB.Add;
641: END IF;
642: x_loading_status := 'CN_RL_DEL_ROLE_PLAN_NOT_EXIST';
643: RAISE FND_API.G_EXC_ERROR ;
644: END IF;
645:
646:
647:

Line 656: p_encoded => FND_API.G_FALSE

652: FND_MSG_PUB.Count_And_Get
653: (
654: p_count => x_msg_count ,
655: p_data => x_msg_data ,
656: p_encoded => FND_API.G_FALSE
657: );
658:
659: EXCEPTION
660: WHEN FND_API.G_EXC_ERROR THEN

Line 660: WHEN FND_API.G_EXC_ERROR THEN

656: p_encoded => FND_API.G_FALSE
657: );
658:
659: EXCEPTION
660: WHEN FND_API.G_EXC_ERROR THEN
661: x_return_status := FND_API.G_RET_STS_ERROR ;
662: FND_MSG_PUB.Count_And_Get
663: (
664: p_count => x_msg_count ,

Line 661: x_return_status := FND_API.G_RET_STS_ERROR ;

657: );
658:
659: EXCEPTION
660: WHEN FND_API.G_EXC_ERROR THEN
661: x_return_status := FND_API.G_RET_STS_ERROR ;
662: FND_MSG_PUB.Count_And_Get
663: (
664: p_count => x_msg_count ,
665: p_data => x_msg_data ,

Line 666: p_encoded => FND_API.G_FALSE

662: FND_MSG_PUB.Count_And_Get
663: (
664: p_count => x_msg_count ,
665: p_data => x_msg_data ,
666: p_encoded => FND_API.G_FALSE
667: );
668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
670: x_loading_status := 'UNEXPECTED_ERR';

Line 668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

664: p_count => x_msg_count ,
665: p_data => x_msg_data ,
666: p_encoded => FND_API.G_FALSE
667: );
668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
670: x_loading_status := 'UNEXPECTED_ERR';
671: FND_MSG_PUB.Count_And_Get
672: (

Line 669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

665: p_data => x_msg_data ,
666: p_encoded => FND_API.G_FALSE
667: );
668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
670: x_loading_status := 'UNEXPECTED_ERR';
671: FND_MSG_PUB.Count_And_Get
672: (
673: p_count => x_msg_count ,

Line 675: p_encoded => FND_API.G_FALSE

671: FND_MSG_PUB.Count_And_Get
672: (
673: p_count => x_msg_count ,
674: p_data => x_msg_data ,
675: p_encoded => FND_API.G_FALSE
676: );
677: WHEN OTHERS THEN
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
679: x_loading_status := 'UNEXPECTED_ERR';

Line 678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

674: p_data => x_msg_data ,
675: p_encoded => FND_API.G_FALSE
676: );
677: WHEN OTHERS THEN
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
679: x_loading_status := 'UNEXPECTED_ERR';
680: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 688: p_encoded => FND_API.G_FALSE

684: FND_MSG_PUB.Count_And_Get
685: (
686: p_count => x_msg_count ,
687: p_data => x_msg_data ,
688: p_encoded => FND_API.G_FALSE
689: );
690:
691: END check_valid_delete;
692:

Line 723: x_return_status := FND_API.G_RET_STS_SUCCESS;

719:
720: BEGIN
721:
722: -- Initialize API return status to success
723: x_return_status := FND_API.G_RET_STS_SUCCESS;
724: x_loading_status := p_loading_status;
725:
726: FOR l_rec IN l_cur
727: LOOP

Line 732: p_init_msg_list => fnd_api.g_false,

728:
729: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
730: (
731: p_api_version => 1.0,
732: p_init_msg_list => fnd_api.g_false,
733: p_commit => fnd_api.g_false,
734: p_validation_level => fnd_api.g_valid_level_full,
735: x_return_status => l_return_status,
736: x_msg_count => l_msg_count,

Line 733: p_commit => fnd_api.g_false,

729: cn_srp_plan_assigns_pvt.delete_srp_plan_assigns
730: (
731: p_api_version => 1.0,
732: p_init_msg_list => fnd_api.g_false,
733: p_commit => fnd_api.g_false,
734: p_validation_level => fnd_api.g_valid_level_full,
735: x_return_status => l_return_status,
736: x_msg_count => l_msg_count,
737: x_msg_data => l_msg_data,

Line 734: p_validation_level => fnd_api.g_valid_level_full,

730: (
731: p_api_version => 1.0,
732: p_init_msg_list => fnd_api.g_false,
733: p_commit => fnd_api.g_false,
734: p_validation_level => fnd_api.g_valid_level_full,
735: x_return_status => l_return_status,
736: x_msg_count => l_msg_count,
737: x_msg_data => l_msg_data,
738: p_srp_role_id => l_rec.srp_role_id,

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

738: p_srp_role_id => l_rec.srp_role_id,
739: p_role_plan_id => p_role_plan_id,
740: x_loading_status => l_loading_status);
741:
742: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
743: x_return_status := l_return_status;
744: x_loading_status := l_loading_status;
745: EXIT;
746: END IF;

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

754: -- --------------------------------------------------------------------------*
755: PROCEDURE Create_Role_Pay_Groups
756: (
757: p_api_version IN NUMBER,
758: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
759: p_commit IN VARCHAR2 := FND_API.G_FALSE,
760: p_validation_level IN NUMBER :=FND_API.g_valid_level_full,
761: x_return_status OUT NOCOPY VARCHAR2,
762: x_loading_status OUT NOCOPY VARCHAR2,

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

755: PROCEDURE Create_Role_Pay_Groups
756: (
757: p_api_version IN NUMBER,
758: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
759: p_commit IN VARCHAR2 := FND_API.G_FALSE,
760: p_validation_level IN NUMBER :=FND_API.g_valid_level_full,
761: x_return_status OUT NOCOPY VARCHAR2,
762: x_loading_status OUT NOCOPY VARCHAR2,
763: x_msg_count OUT NOCOPY NUMBER,

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

756: (
757: p_api_version IN NUMBER,
758: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
759: p_commit IN VARCHAR2 := FND_API.G_FALSE,
760: p_validation_level IN NUMBER :=FND_API.g_valid_level_full,
761: x_return_status OUT NOCOPY VARCHAR2,
762: x_loading_status OUT NOCOPY VARCHAR2,
763: x_msg_count OUT NOCOPY NUMBER,
764: x_msg_data OUT NOCOPY VARCHAR2,

Line 823: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

819: -- Standard Start of API savepoint
820: SAVEPOINT Create_Role_Pay_Groups;
821:
822: -- Standard call to check for call compatibility.
823: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
824: p_api_version ,
825: l_api_name ,
826: G_PKG_NAME )
827: THEN

Line 828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

824: p_api_version ,
825: l_api_name ,
826: G_PKG_NAME )
827: THEN
828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
830:
831: -- Initialize message list if p_init_msg_list is set to TRUE.
832: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 832: IF FND_API.to_Boolean( p_init_msg_list ) THEN

828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
829: END IF;
830:
831: -- Initialize message list if p_init_msg_list is set to TRUE.
832: IF FND_API.to_Boolean( p_init_msg_list ) THEN
833: FND_MSG_PUB.initialize;
834: END IF;
835:
836: -- Initialize API return status to success

Line 837: x_return_status := FND_API.G_RET_STS_SUCCESS;

833: FND_MSG_PUB.initialize;
834: END IF;
835:
836: -- Initialize API return status to success
837: x_return_status := FND_API.G_RET_STS_SUCCESS;
838: x_loading_status := 'CN_INSERTED';
839:
840: -- Assign the parameter to a local variable to be passed to Pre, Post
841: -- and Business APIs

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

854: p_loading_status => l_loading_status, -- in
855: x_loading_status => x_loading_status -- out
856: );
857:
858: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
859: RAISE FND_API.G_EXC_ERROR ;
860: END IF;
861: l_role_pay_group_id := p_role_pay_groups_rec.role_pay_group_id;
862:

Line 859: RAISE FND_API.G_EXC_ERROR ;

855: x_loading_status => x_loading_status -- out
856: );
857:
858: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
859: RAISE FND_API.G_EXC_ERROR ;
860: END IF;
861: l_role_pay_group_id := p_role_pay_groups_rec.role_pay_group_id;
862:
863: cn_role_pay_groups_pkg.INSERT_ROW

Line 1014: p_init_msg_list => FND_API.G_FALSE,

1010: FOR role_plans IN get_role_plans(roles.role_id,roles.org_id) LOOP
1011: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1012: (
1013: p_api_version => 1.0,
1014: p_init_msg_list => FND_API.G_FALSE,
1015: p_commit => FND_API.G_FALSE,
1016: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1017: x_return_status => x_return_status,
1018: x_msg_count => x_msg_count,

Line 1015: p_commit => FND_API.G_FALSE,

1011: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1012: (
1013: p_api_version => 1.0,
1014: p_init_msg_list => FND_API.G_FALSE,
1015: p_commit => FND_API.G_FALSE,
1016: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1017: x_return_status => x_return_status,
1018: x_msg_count => x_msg_count,
1019: x_msg_data => x_msg_data,

Line 1016: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1012: (
1013: p_api_version => 1.0,
1014: p_init_msg_list => FND_API.G_FALSE,
1015: p_commit => FND_API.G_FALSE,
1016: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1017: x_return_status => x_return_status,
1018: x_msg_count => x_msg_count,
1019: x_msg_data => x_msg_data,
1020: p_srp_role_id => roles.srp_role_id,

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

1019: x_msg_data => x_msg_data,
1020: p_srp_role_id => roles.srp_role_id,
1021: p_role_plan_id => role_plans.role_plan_id,
1022: x_loading_status => x_loading_status );
1023: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1024: RAISE fnd_api.g_exc_error;
1025: END IF;
1026:
1027: END LOOP;

Line 1024: RAISE fnd_api.g_exc_error;

1020: p_srp_role_id => roles.srp_role_id,
1021: p_role_plan_id => role_plans.role_plan_id,
1022: x_loading_status => x_loading_status );
1023: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1024: RAISE fnd_api.g_exc_error;
1025: END IF;
1026:
1027: END LOOP;
1028: END IF;

Line 1046: p_init_msg_list => fnd_api.g_false,

1042: IF nvl(plans.end_date, l_null_date) > plans.start_date THEN
1043:
1044: cn_srp_periods_pvt.create_srp_periods
1045: ( p_api_version => p_api_version,
1046: p_init_msg_list => fnd_api.g_false,
1047: p_commit => fnd_api.g_false,
1048: p_validation_level => p_validation_level,
1049: x_return_status => x_return_status,
1050: x_msg_count => x_msg_count,

Line 1047: p_commit => fnd_api.g_false,

1043:
1044: cn_srp_periods_pvt.create_srp_periods
1045: ( p_api_version => p_api_version,
1046: p_init_msg_list => fnd_api.g_false,
1047: p_commit => fnd_api.g_false,
1048: p_validation_level => p_validation_level,
1049: x_return_status => x_return_status,
1050: x_msg_count => x_msg_count,
1051: x_msg_data => x_msg_data,

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

1054: p_comp_plan_id => plans.comp_plan_id,
1055: p_start_date => plans.start_date,
1056: p_end_date => plans.end_date,
1057: x_loading_status => x_loading_status);
1058: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1059: RAISE fnd_api.g_exc_error;
1060: END IF;
1061:
1062: END IF;

Line 1059: RAISE fnd_api.g_exc_error;

1055: p_start_date => plans.start_date,
1056: p_end_date => plans.end_date,
1057: x_loading_status => x_loading_status);
1058: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1059: RAISE fnd_api.g_exc_error;
1060: END IF;
1061:
1062: END IF;
1063: END LOOP;

Line 1073: IF FND_API.To_Boolean( p_commit ) THEN

1069:
1070: -- End of API body
1071: -- Standard check of p_commit.
1072:
1073: IF FND_API.To_Boolean( p_commit ) THEN
1074: COMMIT WORK;
1075: END IF;
1076:
1077:

Line 1084: p_encoded => FND_API.G_FALSE

1080: FND_MSG_PUB.Count_And_Get
1081: (
1082: p_count => x_msg_count ,
1083: p_data => x_msg_data ,
1084: p_encoded => FND_API.G_FALSE
1085: );
1086:
1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN

Line 1088: WHEN FND_API.G_EXC_ERROR THEN

1084: p_encoded => FND_API.G_FALSE
1085: );
1086:
1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: ROLLBACK TO Create_Role_Pay_Groups;
1090: x_return_status := FND_API.G_RET_STS_ERROR ;
1091: FND_MSG_PUB.Count_And_Get
1092: (

Line 1090: x_return_status := FND_API.G_RET_STS_ERROR ;

1086:
1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: ROLLBACK TO Create_Role_Pay_Groups;
1090: x_return_status := FND_API.G_RET_STS_ERROR ;
1091: FND_MSG_PUB.Count_And_Get
1092: (
1093: p_count => x_msg_count ,
1094: p_data => x_msg_data ,

Line 1095: p_encoded => FND_API.G_FALSE

1091: FND_MSG_PUB.Count_And_Get
1092: (
1093: p_count => x_msg_count ,
1094: p_data => x_msg_data ,
1095: p_encoded => FND_API.G_FALSE
1096: );
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: ROLLBACK TO Create_Role_Pay_Groups;
1099: x_loading_status := 'UNEXPECTED_ERR';

Line 1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1093: p_count => x_msg_count ,
1094: p_data => x_msg_data ,
1095: p_encoded => FND_API.G_FALSE
1096: );
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: ROLLBACK TO Create_Role_Pay_Groups;
1099: x_loading_status := 'UNEXPECTED_ERR';
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1101: FND_MSG_PUB.Count_And_Get

Line 1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1096: );
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: ROLLBACK TO Create_Role_Pay_Groups;
1099: x_loading_status := 'UNEXPECTED_ERR';
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1101: FND_MSG_PUB.Count_And_Get
1102: (
1103: p_count => x_msg_count ,
1104: p_data => x_msg_data ,

Line 1105: p_encoded => FND_API.G_FALSE

1101: FND_MSG_PUB.Count_And_Get
1102: (
1103: p_count => x_msg_count ,
1104: p_data => x_msg_data ,
1105: p_encoded => FND_API.G_FALSE
1106: );
1107: WHEN OTHERS THEN
1108: ROLLBACK TO Create_Role_Pay_Groups;
1109: x_loading_status := 'UNEXPECTED_ERR';

Line 1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1106: );
1107: WHEN OTHERS THEN
1108: ROLLBACK TO Create_Role_Pay_Groups;
1109: x_loading_status := 'UNEXPECTED_ERR';
1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1112: THEN
1113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1114: END IF;

Line 1119: p_encoded => FND_API.G_FALSE

1115: FND_MSG_PUB.Count_And_Get
1116: (
1117: p_count => x_msg_count ,
1118: p_data => x_msg_data ,
1119: p_encoded => FND_API.G_FALSE
1120: );
1121:
1122: END Create_Role_Pay_Groups;
1123:

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

1128: -- Procedure: Delete_Role_Pay_Groups
1129: -- --------------------------------------------------------------------------*
1130: PROCEDURE Delete_Role_Pay_Groups
1131: ( p_api_version IN NUMBER ,
1132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1133: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1135: x_return_status OUT NOCOPY VARCHAR2 ,
1136: x_loading_status OUT NOCOPY VARCHAR2 ,

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

1129: -- --------------------------------------------------------------------------*
1130: PROCEDURE Delete_Role_Pay_Groups
1131: ( p_api_version IN NUMBER ,
1132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1133: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1135: x_return_status OUT NOCOPY VARCHAR2 ,
1136: x_loading_status OUT NOCOPY VARCHAR2 ,
1137: x_msg_count OUT NOCOPY NUMBER ,

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

1130: PROCEDURE Delete_Role_Pay_Groups
1131: ( p_api_version IN NUMBER ,
1132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1133: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1135: x_return_status OUT NOCOPY VARCHAR2 ,
1136: x_loading_status OUT NOCOPY VARCHAR2 ,
1137: x_msg_count OUT NOCOPY NUMBER ,
1138: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 1203: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1199: SAVEPOINT delete_role_pay_groups;
1200:
1201: -- Standard call to check for call compatibility.
1202:
1203: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1204: p_api_version ,
1205: l_api_name ,
1206: G_PKG_NAME )
1207: THEN

Line 1208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1204: p_api_version ,
1205: l_api_name ,
1206: G_PKG_NAME )
1207: THEN
1208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1209: END IF;
1210:
1211: -- Initialize message list if p_init_msg_list is set to TRUE.
1212: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1212: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1209: END IF;
1210:
1211: -- Initialize message list if p_init_msg_list is set to TRUE.
1212: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1213: FND_MSG_PUB.initialize;
1214: END IF;
1215:
1216: -- Initialize API return status to success

Line 1217: x_return_status := FND_API.G_RET_STS_SUCCESS;

1213: FND_MSG_PUB.initialize;
1214: END IF;
1215:
1216: -- Initialize API return status to success
1217: x_return_status := FND_API.G_RET_STS_SUCCESS;
1218: x_loading_status := 'CN_DELETED';
1219:
1220:
1221: -- Assign the parameter to a local variable to be passed to Pre, Post

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

1235: p_loading_status => l_loading_status, -- in
1236: x_loading_status => x_loading_status -- out
1237: );
1238:
1239: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1240: RAISE FND_API.G_EXC_ERROR ;
1241: ELSE
1242: -- delete_row
1243:

Line 1240: RAISE FND_API.G_EXC_ERROR ;

1236: x_loading_status => x_loading_status -- out
1237: );
1238:
1239: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1240: RAISE FND_API.G_EXC_ERROR ;
1241: ELSE
1242: -- delete_row
1243:
1244: l_role_id := cn_api.get_role_id(p_role_pay_groups_rec.role_name);

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

1280: x_return_status => x_return_status,
1281: p_loading_status => l_loading_status,
1282: x_loading_status => x_loading_status);
1283:
1284: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1285: RAISE fnd_api.g_exc_error;
1286: END IF;
1287: END LOOP ;
1288:

Line 1285: RAISE fnd_api.g_exc_error;

1281: p_loading_status => l_loading_status,
1282: x_loading_status => x_loading_status);
1283:
1284: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1285: RAISE fnd_api.g_exc_error;
1286: END IF;
1287: END LOOP ;
1288:
1289: select count (*),min(start_date),nvl(max(end_date),l_null_date) end_date

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

1304: x_return_status => x_return_status,
1305: p_loading_status => l_loading_status,
1306: x_loading_status => x_loading_status);
1307:
1308: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1309: RAISE FND_API.G_EXC_ERROR;
1310: END IF;
1311: END LOOP ;
1312: END LOOP;

Line 1309: RAISE FND_API.G_EXC_ERROR;

1305: p_loading_status => l_loading_status,
1306: x_loading_status => x_loading_status);
1307:
1308: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1309: RAISE FND_API.G_EXC_ERROR;
1310: END IF;
1311: END LOOP ;
1312: END LOOP;
1313: END IF;

Line 1331: p_init_msg_list => FND_API.G_FALSE,

1327: LOOP
1328: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1329: (
1330: p_api_version => 1.0,
1331: p_init_msg_list => FND_API.G_FALSE,
1332: p_commit => FND_API.G_FALSE,
1333: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1334: x_return_status => x_return_status,
1335: x_msg_count => x_msg_count,

Line 1332: p_commit => FND_API.G_FALSE,

1328: cn_srp_plan_assigns_pvt.Update_Srp_Plan_Assigns
1329: (
1330: p_api_version => 1.0,
1331: p_init_msg_list => FND_API.G_FALSE,
1332: p_commit => FND_API.G_FALSE,
1333: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1334: x_return_status => x_return_status,
1335: x_msg_count => x_msg_count,
1336: x_msg_data => x_msg_data,

Line 1333: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1329: (
1330: p_api_version => 1.0,
1331: p_init_msg_list => FND_API.G_FALSE,
1332: p_commit => FND_API.G_FALSE,
1333: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1334: x_return_status => x_return_status,
1335: x_msg_count => x_msg_count,
1336: x_msg_data => x_msg_data,
1337: p_srp_role_id => roles.srp_role_id,--changed this to support my new change(Harlen.Renu)

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

1336: x_msg_data => x_msg_data,
1337: p_srp_role_id => roles.srp_role_id,--changed this to support my new change(Harlen.Renu)
1338: p_role_plan_id => role_plans.role_plan_id,
1339: x_loading_status => x_loading_status );
1340: IF ( x_return_status <> FND_API.g_ret_sts_success) THEN
1341: RAISE fnd_api.g_exc_error;
1342: END IF;
1343: END LOOP;
1344: END IF;

Line 1341: RAISE fnd_api.g_exc_error;

1337: p_srp_role_id => roles.srp_role_id,--changed this to support my new change(Harlen.Renu)
1338: p_role_plan_id => role_plans.role_plan_id,
1339: x_loading_status => x_loading_status );
1340: IF ( x_return_status <> FND_API.g_ret_sts_success) THEN
1341: RAISE fnd_api.g_exc_error;
1342: END IF;
1343: END LOOP;
1344: END IF;
1345:

Line 1364: p_init_msg_list => fnd_api.g_false,

1360: IF nvl(plans.end_date, l_null_date) > plans.start_date THEN
1361:
1362: cn_srp_periods_pvt.create_srp_periods
1363: ( p_api_version => p_api_version,
1364: p_init_msg_list => fnd_api.g_false,
1365: p_commit => fnd_api.g_false,
1366: p_validation_level => p_validation_level,
1367: x_return_status => x_return_status,
1368: x_msg_count => x_msg_count,

Line 1365: p_commit => fnd_api.g_false,

1361:
1362: cn_srp_periods_pvt.create_srp_periods
1363: ( p_api_version => p_api_version,
1364: p_init_msg_list => fnd_api.g_false,
1365: p_commit => fnd_api.g_false,
1366: p_validation_level => p_validation_level,
1367: x_return_status => x_return_status,
1368: x_msg_count => x_msg_count,
1369: x_msg_data => x_msg_data,

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

1372: p_comp_plan_id => plans.comp_plan_id,
1373: p_start_date => plans.start_date,
1374: p_end_date => plans.end_date,
1375: x_loading_status => x_loading_status);
1376: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1377: RAISE fnd_api.g_exc_error;
1378: END IF;
1379:
1380: END IF;

Line 1377: RAISE fnd_api.g_exc_error;

1373: p_start_date => plans.start_date,
1374: p_end_date => plans.end_date,
1375: x_loading_status => x_loading_status);
1376: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1377: RAISE fnd_api.g_exc_error;
1378: END IF;
1379:
1380: END IF;
1381: END LOOP;

Line 1405: IF FND_API.To_Boolean( p_commit ) THEN

1401: -- End of API body
1402:
1403: -- Standard check of p_commit.
1404:
1405: IF FND_API.To_Boolean( p_commit ) THEN
1406: COMMIT WORK;
1407: END IF;
1408:
1409:

Line 1416: p_encoded => FND_API.G_FALSE

1412: FND_MSG_PUB.Count_And_Get
1413: (
1414: p_count => x_msg_count ,
1415: p_data => x_msg_data ,
1416: p_encoded => FND_API.G_FALSE
1417: );
1418:
1419: EXCEPTION
1420: WHEN FND_API.G_EXC_ERROR THEN

Line 1420: WHEN FND_API.G_EXC_ERROR THEN

1416: p_encoded => FND_API.G_FALSE
1417: );
1418:
1419: EXCEPTION
1420: WHEN FND_API.G_EXC_ERROR THEN
1421: ROLLBACK TO Delete_Role_Pay_Groups;
1422: x_return_status := FND_API.G_RET_STS_ERROR ;
1423: FND_MSG_PUB.Count_And_Get
1424:

Line 1422: x_return_status := FND_API.G_RET_STS_ERROR ;

1418:
1419: EXCEPTION
1420: WHEN FND_API.G_EXC_ERROR THEN
1421: ROLLBACK TO Delete_Role_Pay_Groups;
1422: x_return_status := FND_API.G_RET_STS_ERROR ;
1423: FND_MSG_PUB.Count_And_Get
1424:
1425:
1426: (

Line 1429: p_encoded => FND_API.G_FALSE

1425:
1426: (
1427: p_count => x_msg_count ,
1428: p_data => x_msg_data ,
1429: p_encoded => FND_API.G_FALSE
1430: );
1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: ROLLBACK TO Delete_Role_Pay_Groups;
1433: x_loading_status := 'UNEXPECTED_ERR';

Line 1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1427: p_count => x_msg_count ,
1428: p_data => x_msg_data ,
1429: p_encoded => FND_API.G_FALSE
1430: );
1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: ROLLBACK TO Delete_Role_Pay_Groups;
1433: x_loading_status := 'UNEXPECTED_ERR';
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1435: FND_MSG_PUB.Count_And_Get

Line 1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1430: );
1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: ROLLBACK TO Delete_Role_Pay_Groups;
1433: x_loading_status := 'UNEXPECTED_ERR';
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1435: FND_MSG_PUB.Count_And_Get
1436: (
1437: p_count => x_msg_count ,
1438: p_data => x_msg_data ,

Line 1439: p_encoded => FND_API.G_FALSE

1435: FND_MSG_PUB.Count_And_Get
1436: (
1437: p_count => x_msg_count ,
1438: p_data => x_msg_data ,
1439: p_encoded => FND_API.G_FALSE
1440: );
1441: WHEN OTHERS THEN
1442: ROLLBACK TO Delete_Role_Pay_Groups;
1443: x_loading_status := 'UNEXPECTED_ERR';

Line 1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1440: );
1441: WHEN OTHERS THEN
1442: ROLLBACK TO Delete_Role_Pay_Groups;
1443: x_loading_status := 'UNEXPECTED_ERR';
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1445: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1446: THEN
1447: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1448: END IF;

Line 1453: p_encoded => FND_API.G_FALSE

1449: FND_MSG_PUB.Count_And_Get
1450: (
1451: p_count => x_msg_count ,
1452: p_data => x_msg_data ,
1453: p_encoded => FND_API.G_FALSE
1454: );
1455: END Delete_Role_Pay_Groups;
1456:
1457: