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_MSG_PUB

Line 520: FND_MSG_PUB.initialize;

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;
524: x_loading_status := 'CN_INSERTED';

Line 618: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

614: CLOSE c_quota_csr;
615:
616: END LOOP ; -- pay group assign loop
617: IF l_pg_found = FALSE then
618: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
619: THEN
620: FND_MESSAGE.SET_NAME('CN' , 'CN_SRP_PAY_GROUP_NOT_FOUND');
621: FND_MSG_PUB.Add;
622: END IF;

Line 621: FND_MSG_PUB.Add;

617: IF l_pg_found = FALSE then
618: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
619: THEN
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;

Line 697: FND_MSG_PUB.Count_And_Get

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
698: (
699: p_count => x_msg_count ,
700: p_data => x_msg_data ,
701: p_encoded => FND_API.G_FALSE

Line 709: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
713: FND_MSG_PUB.Count_And_Get

Line 711: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

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;
713: FND_MSG_PUB.Count_And_Get
714: (
715: p_count => x_msg_count ,

Line 713: FND_MSG_PUB.Count_And_Get

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;
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

Line 722: FND_MSG_PUB.Count_And_Get

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 ,
726: p_encoded => FND_API.G_FALSE

Line 732: FND_MSG_PUB.Count_And_Get

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 ,
736: p_encoded => FND_API.G_FALSE

Line 745: fnd_msg_pub.ADD;

741: ROLLBACK TO Create_Srp_Periods;
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:

Line 752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
756: FND_MSG_PUB.Count_And_Get

Line 754: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

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;
756: FND_MSG_PUB.Count_And_Get
757: (
758: p_count => x_msg_count ,

Line 756: FND_MSG_PUB.Count_And_Get

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;
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

Line 793: FND_MSG_PUB.initialize;

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;
797: x_loading_status := 'CN_UPDATED';

Line 831: FND_MSG_PUB.Count_And_Get

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
832: (
833: p_count => x_msg_count ,
834: p_data => x_msg_data ,
835: p_encoded => FND_API.G_FALSE

Line 842: FND_MSG_PUB.Count_And_Get

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 ,
846: p_encoded => FND_API.G_FALSE

Line 852: FND_MSG_PUB.Count_And_Get

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 ,
856: p_encoded => FND_API.G_FALSE

Line 862: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
866: FND_MSG_PUB.Count_And_Get

Line 864: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

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;
866: FND_MSG_PUB.Count_And_Get
867: (
868: p_count => x_msg_count ,

Line 866: FND_MSG_PUB.Count_And_Get

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;
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

Line 910: FND_MSG_PUB.initialize;

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;
914: x_loading_status := 'CN_UPDATED';

Line 925: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

921: FROM cn_srp_periods_all
922: WHERE srp_period_id = p_del_srp_prd_rec.srp_period_id;
923: EXCEPTION
924: WHEN NO_DATA_FOUND THEN
925: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
926: THEN
927: FND_MESSAGE.SET_NAME('CN' , 'CN_SRP_PERIOD_NOT_EXIST');
928: FND_MSG_PUB.Add;
929: END IF;

Line 928: FND_MSG_PUB.Add;

924: WHEN NO_DATA_FOUND THEN
925: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
926: THEN
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;

Line 956: FND_MSG_PUB.Count_And_Get

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
957: (
958: p_count => x_msg_count ,
959: p_data => x_msg_data ,
960: p_encoded => FND_API.G_FALSE

Line 967: FND_MSG_PUB.Count_And_Get

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 ,
971: p_encoded => FND_API.G_FALSE

Line 977: FND_MSG_PUB.Count_And_Get

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 ,
981: p_encoded => FND_API.G_FALSE

Line 987: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
991: FND_MSG_PUB.Count_And_Get

Line 989: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

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;
991: FND_MSG_PUB.Count_And_Get
992: (
993: p_count => x_msg_count ,

Line 991: FND_MSG_PUB.Count_And_Get

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;
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