DBA Data[Home] [Help]

APPS.BSC_COLOR_RANGE_PVT dependencies on FND_MSG_PUB

Line 45: FND_MSG_PUB.Initialize;

41: l_user_id bsc_color_type_props.last_updated_by%TYPE;
42: l_count NUMBER;
43: BEGIN
44:
45: FND_MSG_PUB.Initialize;
46: x_return_status := FND_API.G_RET_STS_SUCCESS;
47:
48: SAVEPOINT BscColorRangePvt_CrtColorRng;
49:

Line 52: FND_MSG_PUB.ADD;

48: SAVEPOINT BscColorRangePvt_CrtColorRng;
49:
50: IF(p_objective_id IS NULL) THEN
51: FND_MESSAGE.SET_NAME('BSC','BSC_OBJECTIVE_ID_NULL');
52: FND_MSG_PUB.ADD;
53: RAISE FND_API.G_EXC_ERROR;
54: END IF;
55:
56: IF (p_kpi_measure_id IS NULL) THEN

Line 73: FND_MSG_PUB.ADD;

69: END IF;
70:
71: IF(l_count > 0 ) THEN
72: FND_MESSAGE.SET_NAME('BSC','BSC_RANGES_ALREADY_EXISTS');
73: FND_MSG_PUB.ADD;
74: RAISE FND_API.G_EXC_ERROR;
75: END IF;
76:
77: l_user_id := FND_GLOBAL.USER_ID;

Line 103: FND_MSG_PUB.Count_And_Get

99: EXCEPTION
100: WHEN FND_API.G_EXC_ERROR THEN
101: IF (x_msg_data IS NULL) THEN
102: ROLLBACK TO BscColorRangePvt_CrtColorRng;
103: FND_MSG_PUB.Count_And_Get
104: ( p_encoded => FND_API.G_FALSE
105: , p_count => x_msg_count
106: , p_data => x_msg_data
107: );

Line 112: FND_MSG_PUB.Count_And_Get

108: END IF;
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
111: IF (x_msg_data IS NULL) THEN
112: FND_MSG_PUB.Count_And_Get
113: ( p_encoded => FND_API.G_FALSE
114: , p_count => x_msg_count
115: , p_data => x_msg_data
116: );

Line 150: FND_MSG_PUB.Initialize;

146: l_bsc_kpi_color_range_rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
147: l_th_count NUMBER;
148: BEGIN
149:
150: FND_MSG_PUB.Initialize;
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152:
153: SAVEPOINT BscColorRangePvt_CrtColorRng;
154: l_bsc_kpi_color_range_rec := p_Bsc_Kpi_Color_Range_Rec;

Line 174: FND_MSG_PUB.Count_And_Get

170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: IF (x_msg_data IS NULL) THEN
173: ROLLBACK TO BscColorRangePvt_CrtColorRng;
174: FND_MSG_PUB.Count_And_Get
175: ( p_encoded => FND_API.G_FALSE
176: , p_count => x_msg_count
177: , p_data => x_msg_data
178: );

Line 183: FND_MSG_PUB.Count_And_Get

179: END IF;
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
182: IF (x_msg_data IS NULL) THEN
183: FND_MSG_PUB.Count_And_Get
184: ( p_encoded => FND_API.G_FALSE
185: , p_count => x_msg_count
186: , p_data => x_msg_data
187: );

Line 217: FND_MSG_PUB.Initialize;

213: ,x_msg_data OUT NOCOPY VARCHAR2
214: ) IS
215: l_color_id NUMBER;
216: BEGIN
217: FND_MSG_PUB.Initialize;
218: x_return_status := FND_API.G_RET_STS_SUCCESS;
219:
220: SAVEPOINT BscCRangePvt_DelColorRng;
221: -- Update by id or short_name

Line 224: FND_MSG_PUB.ADD;

220: SAVEPOINT BscCRangePvt_DelColorRng;
221: -- Update by id or short_name
222: IF(p_color_range_id IS NULL) THEN
223: FND_MESSAGE.SET_NAME('BSC','BSC_RANGE_ID_NULL');
224: FND_MSG_PUB.ADD;
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227:
228: DELETE bsc_color_ranges

Line 236: FND_MSG_PUB.Count_And_Get

232: WHEN OTHERS THEN
233: ROLLBACK TO BscCRangePvt_DelColorRng;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: IF (x_msg_data IS NULL) THEN
236: FND_MSG_PUB.Count_And_Get
237: ( p_encoded => FND_API.G_FALSE
238: ,p_count => x_msg_count
239: ,p_data => x_msg_data
240: );

Line 255: FND_MSG_PUB.Initialize;

251: ,x_msg_count OUT NOCOPY NUMBER
252: ,x_msg_data OUT NOCOPY VARCHAR2
253: ) IS
254: BEGIN
255: FND_MSG_PUB.Initialize;
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257:
258: SAVEPOINT BscCRangePvt_DelColorRngProp;
259:

Line 262: FND_MSG_PUB.ADD;

258: SAVEPOINT BscCRangePvt_DelColorRngProp;
259:
260: IF(p_color_range_id IS NULL) THEN
261: FND_MESSAGE.SET_NAME('BSC','BSC_RANGE_ID_NULL');
262: FND_MSG_PUB.ADD;
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265:
266: DELETE bsc_color_type_props

Line 283: FND_MSG_PUB.Count_And_Get

279: WHEN OTHERS THEN
280: ROLLBACK TO BscCRangePvt_DelColorRngProp;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: IF (x_msg_data IS NULL) THEN
283: FND_MSG_PUB.Count_And_Get
284: ( p_encoded => FND_API.G_FALSE
285: ,p_count => x_msg_count
286: ,p_data => x_msg_data
287: );