APPS.CN_FORMULA_GEN_PKG dependencies on FND_MSG_PUB

Line 5046: FND_MSG_PUB.initialize;

5042: END IF;
5043:
5044: -- Initialize message list if p_init_msg_list is set to TRUE.
5045: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5046: FND_MSG_PUB.initialize;
5047: END IF;
5048:
5049: -- Initialize API return status to success
5050: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5139: WHERE calc_formula_id = p_formula_id
5140: AND org_id = g_org_id;
5141:
5142: x_return_status := FND_API.g_ret_sts_error;
5143: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5144: THEN
5145: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');
5146: FND_MSG_PUB.ADD;
5147: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5146: FND_MSG_PUB.ADD;

5142: x_return_status := FND_API.g_ret_sts_error;
5143: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5144: THEN
5145: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');
5146: FND_MSG_PUB.ADD;
5147: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5148: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
5149: 'cn.plsql.cn_formula_gen_pkg.generate_formula.error',
5150: FALSE);

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

5172: AND org_id = g_org_id;
5173:
5174: x_return_status := FND_API.g_ret_sts_error;
5175:
5176: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5177: THEN
5178: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');
5179: FND_MSG_PUB.ADD;
5180: END IF;

Line 5179: FND_MSG_PUB.ADD;

5175:
5176: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5177: THEN
5178: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');
5179: FND_MSG_PUB.ADD;
5180: END IF;
5181:
5182: END IF;
5183:

Line 5197: FND_MSG_PUB.Count_And_Get

5193: COMMIT WORK;
5194: END IF;
5195:
5196: -- Standard call to get message count and if count is 1, get message info.
5197: FND_MSG_PUB.Count_And_Get
5198: ( p_count => x_msg_count ,
5199: p_data => x_msg_data ,
5200: p_encoded => FND_API.G_FALSE
5201: );

Line 5206: FND_MSG_PUB.Count_And_Get

5202: EXCEPTION
5203: WHEN FND_API.G_EXC_ERROR THEN
5204: ROLLBACK TO generate_formula;
5205: x_return_status := FND_API.G_RET_STS_ERROR ;
5206: FND_MSG_PUB.Count_And_Get
5207: (p_count => x_msg_count ,
5208: p_data => x_msg_data ,
5209: p_encoded => FND_API.G_FALSE
5210: );

Line 5214: FND_MSG_PUB.Count_And_Get

5210: );
5211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5212: ROLLBACK TO generate_formula;
5213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5214: FND_MSG_PUB.Count_And_Get
5215: (p_count => x_msg_count ,
5216: p_data => x_msg_data ,
5217: p_encoded => FND_API.G_FALSE
5218: );

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

5218: );
5219: WHEN OTHERS THEN
5220: ROLLBACK TO generate_formula;
5221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5223: THEN
5224: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
5225: END IF;
5226: FND_MSG_PUB.Count_And_Get

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

5220: ROLLBACK TO generate_formula;
5221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5223: THEN
5224: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
5225: END IF;
5226: FND_MSG_PUB.Count_And_Get
5227: (p_count => x_msg_count ,
5228: p_data => x_msg_data ,

Line 5226: FND_MSG_PUB.Count_And_Get

5222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5223: THEN
5224: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
5225: END IF;
5226: FND_MSG_PUB.Count_And_Get
5227: (p_count => x_msg_count ,
5228: p_data => x_msg_data ,
5229: p_encoded => FND_API.G_FALSE
5230: );