DBA Data[Home] [Help]

APPS.BSC_COLOR_PUB dependencies on FND_MSG_PUB

Line 42: FND_MSG_PUB.Initialize;

38:
39: l_Count NUMBER;
40: BEGIN
41:
42: FND_MSG_PUB.Initialize;
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44:
45: SAVEPOINT BscColorPub_CrtColor;
46:

Line 59: FND_MSG_PUB.Count_And_Get

55: EXCEPTION
56: WHEN FND_API.G_EXC_ERROR THEN
57: IF (x_msg_data IS NULL) THEN
58: ROLLBACK TO BscColorPub_CrtColor;
59: FND_MSG_PUB.Count_And_Get
60: ( p_encoded => FND_API.G_FALSE
61: , p_count => x_msg_count
62: , p_data => x_msg_data
63: );

Line 68: FND_MSG_PUB.Count_And_Get

64: END IF;
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
67: IF (x_msg_data IS NULL) THEN
68: FND_MSG_PUB.Count_And_Get
69: ( p_encoded => FND_API.G_FALSE
70: , p_count => x_msg_count
71: , p_data => x_msg_data
72: );

Line 122: FND_MSG_PUB.Initialize;

118: color_rollup_type = BSC_COLOR_CALC_UTIL.WEIGHTED_AVERAGE AND
119: prototype_flag = BSC_DESIGNER_PVT.C_PRODUCTION;
120:
121: BEGIN
122: FND_MSG_PUB.Initialize;
123: x_return_status := FND_API.G_RET_STS_SUCCESS;
124:
125: SAVEPOINT BscColorPvt_UpdColor;
126: -- Update by id or short_name

Line 191: FND_MSG_PUB.Initialize;

187: ,x_msg_count OUT NOCOPY NUMBER
188: ,x_msg_data OUT NOCOPY VARCHAR2
189: ) IS
190: BEGIN
191: FND_MSG_PUB.Initialize;
192: x_return_status := FND_API.G_RET_STS_SUCCESS;
193:
194: SAVEPOINT BscColorPvt_DelColor;
195:

Line 198: FND_MSG_PUB.ADD;

194: SAVEPOINT BscColorPvt_DelColor;
195:
196: IF(p_Bsc_Color_Id IS NULL AND p_Bsc_Color_SN IS NULL) THEN
197: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_ID_SN');
198: FND_MSG_PUB.ADD;
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201: BSC_COLOR_PKG.DELETE_ROW(p_Bsc_Color_Id
202: ,p_Bsc_Color_SN);

Line 220: FND_MSG_PUB.Initialize;

216: ,x_msg_data OUT NOCOPY VARCHAR2
217: ) IS
218: l_def_color_code VARCHAR2(15):= 'DEF_COLOR_COUNT';
219: BEGIN
220: FND_MSG_PUB.Initialize;
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222:
223: UPDATE bsc_sys_init
224: SET property_value = p_color_count