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

Line 514: IF NOT FND_API.compatible_api_call

510: BEGIN
511: -- Standard Start of API savepoint
512: SAVEPOINT Create_Srp_Periods;
513: -- Standard call to check for call compatibility.
514: IF NOT FND_API.compatible_api_call
515: (l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
516: RAISE FND_API.g_exc_unexpected_error;
517: END IF ;
518: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 516: RAISE FND_API.g_exc_unexpected_error;

512: SAVEPOINT Create_Srp_Periods;
513: -- Standard call to check for call compatibility.
514: IF NOT FND_API.compatible_api_call
515: (l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
516: RAISE FND_API.g_exc_unexpected_error;
517: END IF ;
518: -- Initialize message list if p_init_msg_list is set to TRUE.
519: IF FND_API.to_Boolean( p_init_msg_list ) THEN
520: FND_MSG_PUB.initialize;

Line 519: IF FND_API.to_Boolean( p_init_msg_list ) THEN

515: (l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
516: RAISE FND_API.g_exc_unexpected_error;
517: END IF ;
518: -- Initialize message list if p_init_msg_list is set to TRUE.
519: IF FND_API.to_Boolean( p_init_msg_list ) THEN
520: FND_MSG_PUB.initialize;
521: END IF;
522: -- Initialize API return status to success
523: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 523: x_return_status := FND_API.G_RET_STS_SUCCESS;

519: IF FND_API.to_Boolean( p_init_msg_list ) THEN
520: FND_MSG_PUB.initialize;
521: END IF;
522: -- Initialize API return status to success
523: x_return_status := FND_API.G_RET_STS_SUCCESS;
524: x_loading_status := 'CN_INSERTED';
525:
526: -- API body
527:

Line 624: RAISE FND_API.G_EXC_ERROR ;

620: FND_MESSAGE.SET_NAME('CN' , 'CN_SRP_PAY_GROUP_NOT_FOUND');
621: FND_MSG_PUB.Add;
622: END IF;
623: x_loading_status := 'CN_SRP_PAY_GROUP_NOT_FOUND' ;
624: RAISE FND_API.G_EXC_ERROR ;
625: END IF;
626: CLOSE c_srp_pay_grp_csr;
627:
628: -- Create summary srp period records where necessary for all applicable

Line 686: IF p_sync_flag = FND_API.G_TRUE THEN

682: end loop; -- periods
683:
684: -- populate begin balance columns and summary records
685: -- only if p_sync_flag is true... fixed for bug 3193482
686: IF p_sync_flag = FND_API.G_TRUE THEN
687: Sync_Accum_Balances(p_salesrep_id, l_org_id, ct.credit_type_id, p_role_id);
688: END IF;
689: end loop; -- credit types
690:

Line 693: IF FND_API.To_Boolean( p_commit ) THEN

689: end loop; -- credit types
690:
691: -- End of API body.
692: -- Standard check of p_commit.
693: IF FND_API.To_Boolean( p_commit ) THEN
694: COMMIT WORK;
695: END IF;
696: -- Standard call to get message count and if count is 1, get message info.
697: FND_MSG_PUB.Count_And_Get

Line 701: p_encoded => FND_API.G_FALSE

697: FND_MSG_PUB.Count_And_Get
698: (
699: p_count => x_msg_count ,
700: p_data => x_msg_data ,
701: p_encoded => FND_API.G_FALSE
702: );
703:
704: EXCEPTION
705: WHEN COLLECTION_IS_NULL THEN

Line 708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

704: EXCEPTION
705: WHEN COLLECTION_IS_NULL THEN
706: ROLLBACK TO Create_Srp_Periods;
707: x_loading_status := 'CN_PAY_PERIOD_NOT_EXIST';
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
709: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
710: THEN
711: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
712: END IF;

Line 717: p_encoded => FND_API.G_FALSE

713: FND_MSG_PUB.Count_And_Get
714: (
715: p_count => x_msg_count ,
716: p_data => x_msg_data ,
717: p_encoded => FND_API.G_FALSE
718: );
719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK TO Create_Srp_Periods;
721: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 719: WHEN FND_API.G_EXC_ERROR THEN

715: p_count => x_msg_count ,
716: p_data => x_msg_data ,
717: p_encoded => FND_API.G_FALSE
718: );
719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK TO Create_Srp_Periods;
721: x_return_status := FND_API.G_RET_STS_ERROR ;
722: FND_MSG_PUB.Count_And_Get
723: (

Line 721: x_return_status := FND_API.G_RET_STS_ERROR ;

717: p_encoded => FND_API.G_FALSE
718: );
719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK TO Create_Srp_Periods;
721: x_return_status := FND_API.G_RET_STS_ERROR ;
722: FND_MSG_PUB.Count_And_Get
723: (
724: p_count => x_msg_count ,
725: p_data => x_msg_data ,

Line 726: p_encoded => FND_API.G_FALSE

722: FND_MSG_PUB.Count_And_Get
723: (
724: p_count => x_msg_count ,
725: p_data => x_msg_data ,
726: p_encoded => FND_API.G_FALSE
727: );
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO Create_Srp_Periods;
730: x_loading_status := 'UNEXPECTED_ERR';

Line 728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

724: p_count => x_msg_count ,
725: p_data => x_msg_data ,
726: p_encoded => FND_API.G_FALSE
727: );
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO Create_Srp_Periods;
730: x_loading_status := 'UNEXPECTED_ERR';
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
732: FND_MSG_PUB.Count_And_Get

Line 731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

727: );
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO Create_Srp_Periods;
730: x_loading_status := 'UNEXPECTED_ERR';
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
732: FND_MSG_PUB.Count_And_Get
733: (
734: p_count => x_msg_count ,
735: p_data => x_msg_data ,

Line 736: p_encoded => FND_API.G_FALSE

732: FND_MSG_PUB.Count_And_Get
733: (
734: p_count => x_msg_count ,
735: p_data => x_msg_data ,
736: p_encoded => FND_API.G_FALSE
737: );
738: WHEN OTHERS THEN
739: ROLLBACK TO Create_Srp_Periods;
740: /* Change Made By hithanki -- Start*/

Line 746: RAISE fnd_api.g_exc_error;

742: IF SQLCODE = '-1'
743: THEN
744: fnd_message.set_name('CN', 'CN_CREATE_ROLE_PLAN_ERR');
745: fnd_msg_pub.ADD;
746: RAISE fnd_api.g_exc_error;
747: END IF;
748: /* Change Made By hithanki -- End */
749:
750: x_loading_status := 'UNEXPECTED_ERR';

Line 751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

747: END IF;
748: /* Change Made By hithanki -- End */
749:
750: x_loading_status := 'UNEXPECTED_ERR';
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
753: THEN
754: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
755: END IF;

Line 760: p_encoded => FND_API.G_FALSE

756: FND_MSG_PUB.Count_And_Get
757: (
758: p_count => x_msg_count ,
759: p_data => x_msg_data ,
760: p_encoded => FND_API.G_FALSE
761: );
762: END Create_Srp_Periods_Per_Quota;
763:
764: --| -----------------------------------------------------------------------+

Line 787: IF NOT FND_API.compatible_api_call

783: BEGIN
784: -- Standard Start of API savepoint
785: SAVEPOINT Update_Delta_Srp_Pds_No_Sync;
786: -- Standard call to check for call compatibility.
787: IF NOT FND_API.compatible_api_call
788: (l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
789: RAISE FND_API.g_exc_unexpected_error;
790: END IF ;
791: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 789: RAISE FND_API.g_exc_unexpected_error;

785: SAVEPOINT Update_Delta_Srp_Pds_No_Sync;
786: -- Standard call to check for call compatibility.
787: IF NOT FND_API.compatible_api_call
788: (l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
789: RAISE FND_API.g_exc_unexpected_error;
790: END IF ;
791: -- Initialize message list if p_init_msg_list is set to TRUE.
792: IF FND_API.to_Boolean( p_init_msg_list ) THEN
793: FND_MSG_PUB.initialize;

Line 792: IF FND_API.to_Boolean( p_init_msg_list ) THEN

788: (l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
789: RAISE FND_API.g_exc_unexpected_error;
790: END IF ;
791: -- Initialize message list if p_init_msg_list is set to TRUE.
792: IF FND_API.to_Boolean( p_init_msg_list ) THEN
793: FND_MSG_PUB.initialize;
794: END IF;
795: -- Initialize API return status to success
796: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 796: x_return_status := FND_API.G_RET_STS_SUCCESS;

792: IF FND_API.to_Boolean( p_init_msg_list ) THEN
793: FND_MSG_PUB.initialize;
794: END IF;
795: -- Initialize API return status to success
796: x_return_status := FND_API.G_RET_STS_SUCCESS;
797: x_loading_status := 'CN_UPDATED';
798: -- API body
799:
800: -- Update record's ctd and dtd

Line 827: IF FND_API.To_Boolean( p_commit ) THEN

823: WHERE srp_period_id = p_del_srp_prd_rec.srp_period_id;
824:
825: -- End of API body.
826: -- Standard check of p_commit.
827: IF FND_API.To_Boolean( p_commit ) THEN
828: COMMIT WORK;
829: END IF;
830: -- Standard call to get message count and if count is 1, get message info.
831: FND_MSG_PUB.Count_And_Get

Line 835: p_encoded => FND_API.G_FALSE

831: FND_MSG_PUB.Count_And_Get
832: (
833: p_count => x_msg_count ,
834: p_data => x_msg_data ,
835: p_encoded => FND_API.G_FALSE
836: );
837:
838: EXCEPTION
839: WHEN FND_API.G_EXC_ERROR THEN

Line 839: WHEN FND_API.G_EXC_ERROR THEN

835: p_encoded => FND_API.G_FALSE
836: );
837:
838: EXCEPTION
839: WHEN FND_API.G_EXC_ERROR THEN
840: ROLLBACK TO Update_Delta_Srp_Pds_No_Sync;
841: x_return_status := FND_API.G_RET_STS_ERROR ;
842: FND_MSG_PUB.Count_And_Get
843: (

Line 841: x_return_status := FND_API.G_RET_STS_ERROR ;

837:
838: EXCEPTION
839: WHEN FND_API.G_EXC_ERROR THEN
840: ROLLBACK TO Update_Delta_Srp_Pds_No_Sync;
841: x_return_status := FND_API.G_RET_STS_ERROR ;
842: FND_MSG_PUB.Count_And_Get
843: (
844: p_count => x_msg_count ,
845: p_data => x_msg_data ,

Line 846: p_encoded => FND_API.G_FALSE

842: FND_MSG_PUB.Count_And_Get
843: (
844: p_count => x_msg_count ,
845: p_data => x_msg_data ,
846: p_encoded => FND_API.G_FALSE
847: );
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: ROLLBACK TO Update_Delta_Srp_Pds_No_Sync;
850: x_loading_status := 'UNEXPECTED_ERR';

Line 848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

844: p_count => x_msg_count ,
845: p_data => x_msg_data ,
846: p_encoded => FND_API.G_FALSE
847: );
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: ROLLBACK TO Update_Delta_Srp_Pds_No_Sync;
850: x_loading_status := 'UNEXPECTED_ERR';
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
852: FND_MSG_PUB.Count_And_Get

Line 851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

847: );
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: ROLLBACK TO Update_Delta_Srp_Pds_No_Sync;
850: x_loading_status := 'UNEXPECTED_ERR';
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
852: FND_MSG_PUB.Count_And_Get
853: (
854: p_count => x_msg_count ,
855: p_data => x_msg_data ,

Line 856: p_encoded => FND_API.G_FALSE

852: FND_MSG_PUB.Count_And_Get
853: (
854: p_count => x_msg_count ,
855: p_data => x_msg_data ,
856: p_encoded => FND_API.G_FALSE
857: );
858: WHEN OTHERS THEN
859: ROLLBACK TO Update_Delta_Srp_Pds_No_Sync;
860: x_loading_status := 'UNEXPECTED_ERR';

Line 861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

857: );
858: WHEN OTHERS THEN
859: ROLLBACK TO Update_Delta_Srp_Pds_No_Sync;
860: x_loading_status := 'UNEXPECTED_ERR';
861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
862: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
863: THEN
864: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
865: END IF;

Line 870: p_encoded => FND_API.G_FALSE

866: FND_MSG_PUB.Count_And_Get
867: (
868: p_count => x_msg_count ,
869: p_data => x_msg_data ,
870: p_encoded => FND_API.G_FALSE
871: );
872: END Update_Delta_Srp_Pds_No_Sync;
873:
874: --| -----------------------------------------------------------------------+

Line 904: IF NOT FND_API.compatible_api_call

900: BEGIN
901: -- Standard Start of API savepoint
902: SAVEPOINT Update_Delta_Srp_Periods;
903: -- Standard call to check for call compatibility.
904: IF NOT FND_API.compatible_api_call
905: (l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
906: RAISE FND_API.g_exc_unexpected_error;
907: END IF ;
908: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 906: RAISE FND_API.g_exc_unexpected_error;

902: SAVEPOINT Update_Delta_Srp_Periods;
903: -- Standard call to check for call compatibility.
904: IF NOT FND_API.compatible_api_call
905: (l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
906: RAISE FND_API.g_exc_unexpected_error;
907: END IF ;
908: -- Initialize message list if p_init_msg_list is set to TRUE.
909: IF FND_API.to_Boolean( p_init_msg_list ) THEN
910: FND_MSG_PUB.initialize;

Line 909: IF FND_API.to_Boolean( p_init_msg_list ) THEN

905: (l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
906: RAISE FND_API.g_exc_unexpected_error;
907: END IF ;
908: -- Initialize message list if p_init_msg_list is set to TRUE.
909: IF FND_API.to_Boolean( p_init_msg_list ) THEN
910: FND_MSG_PUB.initialize;
911: END IF;
912: -- Initialize API return status to success
913: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 913: x_return_status := FND_API.G_RET_STS_SUCCESS;

909: IF FND_API.to_Boolean( p_init_msg_list ) THEN
910: FND_MSG_PUB.initialize;
911: END IF;
912: -- Initialize API return status to success
913: x_return_status := FND_API.G_RET_STS_SUCCESS;
914: x_loading_status := 'CN_UPDATED';
915: -- API body
916:
917: -- populate header info of delta srp period rec

Line 931: RAISE FND_API.G_EXC_ERROR ;

927: FND_MESSAGE.SET_NAME('CN' , 'CN_SRP_PERIOD_NOT_EXIST');
928: FND_MSG_PUB.Add;
929: END IF;
930: x_loading_status := 'CN_SRP_PERIOD_NOT_EXIST' ;
931: RAISE FND_API.G_EXC_ERROR ;
932: END;
933:
934: -- update balances
935: Update_Delta_Srp_Pds_No_Sync

Line 943: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

939: x_msg_data => x_msg_data,
940: p_del_srp_prd_rec => p_del_srp_prd_rec,
941: x_loading_status => x_loading_status);
942:
943: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
944: RAISE FND_API.G_EXC_ERROR;
945: end if;
946:
947: -- populate begin balance columns and summary records

Line 944: RAISE FND_API.G_EXC_ERROR;

940: p_del_srp_prd_rec => p_del_srp_prd_rec,
941: x_loading_status => x_loading_status);
942:
943: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
944: RAISE FND_API.G_EXC_ERROR;
945: end if;
946:
947: -- populate begin balance columns and summary records
948: Sync_Accum_Balances(l_salesrep_id, l_org_id, l_credit_type_id, l_role_id);

Line 952: IF FND_API.To_Boolean( p_commit ) THEN

948: Sync_Accum_Balances(l_salesrep_id, l_org_id, l_credit_type_id, l_role_id);
949:
950: -- End of API body.
951: -- Standard check of p_commit.
952: IF FND_API.To_Boolean( p_commit ) THEN
953: COMMIT WORK;
954: END IF;
955: -- Standard call to get message count and if count is 1, get message info.
956: FND_MSG_PUB.Count_And_Get

Line 960: p_encoded => FND_API.G_FALSE

956: FND_MSG_PUB.Count_And_Get
957: (
958: p_count => x_msg_count ,
959: p_data => x_msg_data ,
960: p_encoded => FND_API.G_FALSE
961: );
962:
963: EXCEPTION
964: WHEN FND_API.G_EXC_ERROR THEN

Line 964: WHEN FND_API.G_EXC_ERROR THEN

960: p_encoded => FND_API.G_FALSE
961: );
962:
963: EXCEPTION
964: WHEN FND_API.G_EXC_ERROR THEN
965: ROLLBACK TO Update_Delta_Srp_Periods;
966: x_return_status := FND_API.G_RET_STS_ERROR ;
967: FND_MSG_PUB.Count_And_Get
968: (

Line 966: x_return_status := FND_API.G_RET_STS_ERROR ;

962:
963: EXCEPTION
964: WHEN FND_API.G_EXC_ERROR THEN
965: ROLLBACK TO Update_Delta_Srp_Periods;
966: x_return_status := FND_API.G_RET_STS_ERROR ;
967: FND_MSG_PUB.Count_And_Get
968: (
969: p_count => x_msg_count ,
970: p_data => x_msg_data ,

Line 971: p_encoded => FND_API.G_FALSE

967: FND_MSG_PUB.Count_And_Get
968: (
969: p_count => x_msg_count ,
970: p_data => x_msg_data ,
971: p_encoded => FND_API.G_FALSE
972: );
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
974: ROLLBACK TO Update_Delta_Srp_Periods;
975: x_loading_status := 'UNEXPECTED_ERR';

Line 973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

969: p_count => x_msg_count ,
970: p_data => x_msg_data ,
971: p_encoded => FND_API.G_FALSE
972: );
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
974: ROLLBACK TO Update_Delta_Srp_Periods;
975: x_loading_status := 'UNEXPECTED_ERR';
976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
977: FND_MSG_PUB.Count_And_Get

Line 976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

972: );
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
974: ROLLBACK TO Update_Delta_Srp_Periods;
975: x_loading_status := 'UNEXPECTED_ERR';
976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
977: FND_MSG_PUB.Count_And_Get
978: (
979: p_count => x_msg_count ,
980: p_data => x_msg_data ,

Line 981: p_encoded => FND_API.G_FALSE

977: FND_MSG_PUB.Count_And_Get
978: (
979: p_count => x_msg_count ,
980: p_data => x_msg_data ,
981: p_encoded => FND_API.G_FALSE
982: );
983: WHEN OTHERS THEN
984: ROLLBACK TO Update_Delta_Srp_Periods;
985: x_loading_status := 'UNEXPECTED_ERR';

Line 986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

982: );
983: WHEN OTHERS THEN
984: ROLLBACK TO Update_Delta_Srp_Periods;
985: x_loading_status := 'UNEXPECTED_ERR';
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
987: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
988: THEN
989: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
990: END IF;

Line 995: p_encoded => FND_API.G_FALSE

991: FND_MSG_PUB.Count_And_Get
992: (
993: p_count => x_msg_count ,
994: p_data => x_msg_data ,
995: p_encoded => FND_API.G_FALSE
996: );
997:
998: END Update_Delta_Srp_Periods;
999: