APPS.CN_SCA_RULES_BATCH_GEN_PVT dependencies on FND_API

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

739: END;
740: --
741: PROCEDURE gen_sca_rules_batch_dyn(
742: p_api_version IN NUMBER,
743: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
744: p_commit IN VARCHAR2 := FND_API.G_FALSE,
745: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
746: p_org_id IN NUMBER,
747: x_return_status OUT NOCOPY VARCHAR2,

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

740: --
741: PROCEDURE gen_sca_rules_batch_dyn(
742: p_api_version IN NUMBER,
743: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
744: p_commit IN VARCHAR2 := FND_API.G_FALSE,
745: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
746: p_org_id IN NUMBER,
747: x_return_status OUT NOCOPY VARCHAR2,
748: x_msg_count OUT NOCOPY NUMBER,

Line 745: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

741: PROCEDURE gen_sca_rules_batch_dyn(
742: p_api_version IN NUMBER,
743: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
744: p_commit IN VARCHAR2 := FND_API.G_FALSE,
745: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
746: p_org_id IN NUMBER,
747: x_return_status OUT NOCOPY VARCHAR2,
748: x_msg_count OUT NOCOPY NUMBER,
749: x_msg_data OUT NOCOPY VARCHAR2,

Line 780: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

776: --codeCheck: For a concurrent program this kind of code is not required.
777: --codeCheck: I may need to change this one.
778:
779: -- Standard call to check for call compatibility.
780: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
781: p_api_version ,
782: l_api_name ,
783: G_PKG_NAME )
784: THEN

Line 785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

781: p_api_version ,
782: l_api_name ,
783: G_PKG_NAME )
784: THEN
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: END IF;
787:
788: -- Initialize message list if p_init_msg_list is set to TRUE.
789: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 789: IF FND_API.to_Boolean( p_init_msg_list ) THEN

785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: END IF;
787:
788: -- Initialize message list if p_init_msg_list is set to TRUE.
789: IF FND_API.to_Boolean( p_init_msg_list ) THEN
790: FND_MSG_PUB.initialize;
791: END IF;
792:
793: -- Initialize API return status to success

Line 794: x_return_status := FND_API.G_RET_STS_SUCCESS;

790: FND_MSG_PUB.initialize;
791: END IF;
792:
793: -- Initialize API return status to success
794: x_return_status := FND_API.G_RET_STS_SUCCESS;
795:
796:
797: -- Codes start here
798: -- SELECT org_id INTO l_org_id FROM cn_repositories;

Line 872: x_return_status := FND_API.g_ret_sts_error;

868: IF l_error_count = 0 THEN
869: NULL;
870: --dbms_output.put_line('sucess compilation');
871: ELSE
872: x_return_status := FND_API.g_ret_sts_error;
873:
874: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
875: THEN
876: fnd_message.set_name('CN', 'CN_DYN_PKG_COMPILE_ERR');

Line 881: x_return_status := FND_API.g_ret_sts_error;

877: FND_MSG_PUB.ADD;
878: END IF;
879: END IF;
880: ELSE
881: x_return_status := FND_API.g_ret_sts_error;
882:
883: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
884: THEN
885: fnd_message.set_name('CN', 'CN_DYN_PKG_COMPILE_ERR');

Line 890: IF FND_API.To_Boolean( p_commit ) THEN

886: FND_MSG_PUB.ADD;
887: END IF;
888: END IF;
889:
890: IF FND_API.To_Boolean( p_commit ) THEN
891: COMMIT WORK;
892: END IF;
893:
894: EXCEPTION

Line 895: WHEN FND_API.G_EXC_ERROR THEN

891: COMMIT WORK;
892: END IF;
893:
894: EXCEPTION
895: WHEN FND_API.G_EXC_ERROR THEN
896: -- codeCheck: This needs to be changed
897: --ROLLBACK TO generate_formula;
898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: FND_MSG_PUB.Count_And_Get

Line 898: x_return_status := FND_API.G_RET_STS_ERROR ;

894: EXCEPTION
895: WHEN FND_API.G_EXC_ERROR THEN
896: -- codeCheck: This needs to be changed
897: --ROLLBACK TO generate_formula;
898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: FND_MSG_PUB.Count_And_Get
900: (p_count => x_msg_count ,
901: p_data => x_msg_data ,
902: p_encoded => FND_API.G_FALSE

Line 902: p_encoded => FND_API.G_FALSE

898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: FND_MSG_PUB.Count_And_Get
900: (p_count => x_msg_count ,
901: p_data => x_msg_data ,
902: p_encoded => FND_API.G_FALSE
903: );
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: --ROLLBACK TO generate_formula;
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

900: (p_count => x_msg_count ,
901: p_data => x_msg_data ,
902: p_encoded => FND_API.G_FALSE
903: );
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: --ROLLBACK TO generate_formula;
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: FND_MSG_PUB.Count_And_Get
908: (p_count => x_msg_count ,

Line 906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

902: p_encoded => FND_API.G_FALSE
903: );
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: --ROLLBACK TO generate_formula;
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: FND_MSG_PUB.Count_And_Get
908: (p_count => x_msg_count ,
909: p_data => x_msg_data ,
910: p_encoded => FND_API.G_FALSE

Line 910: p_encoded => FND_API.G_FALSE

906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: FND_MSG_PUB.Count_And_Get
908: (p_count => x_msg_count ,
909: p_data => x_msg_data ,
910: p_encoded => FND_API.G_FALSE
911: );
912: WHEN OTHERS THEN
913: --ROLLBACK TO generate_formula;
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

910: p_encoded => FND_API.G_FALSE
911: );
912: WHEN OTHERS THEN
913: --ROLLBACK TO generate_formula;
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
915: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
916: THEN
917: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
918: END IF;

Line 922: p_encoded => FND_API.G_FALSE

918: END IF;
919: FND_MSG_PUB.Count_And_Get
920: (p_count => x_msg_count ,
921: p_data => x_msg_data ,
922: p_encoded => FND_API.G_FALSE
923: );
924: END gen_sca_rules_batch_dyn;
925: --
926: END cn_sca_rules_batch_gen_pvt;