APPS.CN_FORMULA_GEN_PKG dependencies on FND_MSG_PUB

Line 5125: FND_MSG_PUB.initialize;

5121: END IF;
5122:
5123: -- Initialize message list if p_init_msg_list is set to TRUE.
5124: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5125: FND_MSG_PUB.initialize;
5126: END IF;
5127:
5128: -- Initialize API return status to success
5129: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5222: WHERE calc_formula_id = p_formula_id
5223: AND org_id = g_org_id;
5224:
5225: x_return_status := FND_API.g_ret_sts_error;
5226: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5227: THEN
5228: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');
5229: FND_MSG_PUB.ADD;
5230: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5229: FND_MSG_PUB.ADD;

5225: x_return_status := FND_API.g_ret_sts_error;
5226: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5227: THEN
5228: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');
5229: FND_MSG_PUB.ADD;
5230: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5231: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
5232: 'cn.plsql.cn_formula_gen_pkg.generate_formula.error',
5233: FALSE);

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

5255: AND org_id = g_org_id;
5256:
5257: x_return_status := FND_API.g_ret_sts_error;
5258:
5259: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5260: THEN
5261: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');
5262: FND_MSG_PUB.ADD;
5263: END IF;

Line 5262: FND_MSG_PUB.ADD;

5258:
5259: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5260: THEN
5261: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');
5262: FND_MSG_PUB.ADD;
5263: END IF;
5264:
5265: END IF;
5266:

Line 5280: FND_MSG_PUB.Count_And_Get

5276: COMMIT WORK;
5277: END IF;
5278:
5279: -- Standard call to get message count and if count is 1, get message info.
5280: FND_MSG_PUB.Count_And_Get
5281: ( p_count => x_msg_count ,
5282: p_data => x_msg_data ,
5283: p_encoded => FND_API.G_FALSE
5284: );

Line 5289: FND_MSG_PUB.Count_And_Get

5285: EXCEPTION
5286: WHEN FND_API.G_EXC_ERROR THEN
5287: ROLLBACK TO generate_formula;
5288: x_return_status := FND_API.G_RET_STS_ERROR ;
5289: FND_MSG_PUB.Count_And_Get
5290: (p_count => x_msg_count ,
5291: p_data => x_msg_data ,
5292: p_encoded => FND_API.G_FALSE
5293: );

Line 5297: FND_MSG_PUB.Count_And_Get

5293: );
5294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5295: ROLLBACK TO generate_formula;
5296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5297: FND_MSG_PUB.Count_And_Get
5298: (p_count => x_msg_count ,
5299: p_data => x_msg_data ,
5300: p_encoded => FND_API.G_FALSE
5301: );

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

5301: );
5302: WHEN OTHERS THEN
5303: ROLLBACK TO generate_formula;
5304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5305: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5306: THEN
5307: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
5308: END IF;
5309: FND_MSG_PUB.Count_And_Get

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

5303: ROLLBACK TO generate_formula;
5304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5305: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5306: THEN
5307: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
5308: END IF;
5309: FND_MSG_PUB.Count_And_Get
5310: (p_count => x_msg_count ,
5311: p_data => x_msg_data ,

Line 5309: FND_MSG_PUB.Count_And_Get

5305: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5306: THEN
5307: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
5308: END IF;
5309: FND_MSG_PUB.Count_And_Get
5310: (p_count => x_msg_count ,
5311: p_data => x_msg_data ,
5312: p_encoded => FND_API.G_FALSE
5313: );