APPS.BSC_COLOR_PVT dependencies on FND_MSG_PUB

Line 50: FND_MSG_PUB.Initialize;

46: l_Count NUMBER;
47: l_forecast_color NUMBER;
48: BEGIN
49:
50: FND_MSG_PUB.Initialize;
51: x_return_status := FND_API.G_RET_STS_SUCCESS;
52:
53: SAVEPOINT BscColorPvt_CrtColor;
54:

Line 63: FND_MSG_PUB.ADD;

59:
60: IF (l_Count > 0) THEN
61: FND_MESSAGE.SET_NAME('BSC','BSC_COLOR_ID_EXISTS');
62: FND_MESSAGE.SET_TOKEN('BSC_COLOR_ID', p_Bsc_Color_Rec.Color_Id);
63: FND_MSG_PUB.ADD;
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;
66: ELSE
67: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_ID');

Line 69: FND_MSG_PUB.ADD;

65: END IF;
66: ELSE
67: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_ID');
68: FND_MESSAGE.SET_TOKEN('BSC_COLOR_ID', p_Bsc_Color_Rec.Color_Id);
69: FND_MSG_PUB.ADD;
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72: IF (p_Bsc_Color_Rec.Short_Name IS NULL) THEN
73: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_SN');

Line 75: FND_MSG_PUB.ADD;

71: END IF;
72: IF (p_Bsc_Color_Rec.Short_Name IS NULL) THEN
73: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_SN');
74: FND_MESSAGE.SET_TOKEN('BSC_COLOR_SN', p_Bsc_Color_Rec.short_name);
75: FND_MSG_PUB.ADD;
76: RAISE FND_API.G_EXC_ERROR;
77: END IF;
78: BSC_COLOR_PKG.INSERT_ROW(p_Bsc_Color_Rec.color_id
79: ,p_Bsc_Color_Rec.Short_Name

Line 99: FND_MSG_PUB.Count_And_Get

95: EXCEPTION
96: WHEN FND_API.G_EXC_ERROR THEN
97: IF (x_msg_data IS NULL) THEN
98: ROLLBACK TO BscColorPvt_CrtColor;
99: FND_MSG_PUB.Count_And_Get
100: ( p_encoded => FND_API.G_FALSE
101: , p_count => x_msg_count
102: , p_data => x_msg_data
103: );

Line 108: FND_MSG_PUB.Count_And_Get

104: END IF;
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
107: IF (x_msg_data IS NULL) THEN
108: FND_MSG_PUB.Count_And_Get
109: ( p_encoded => FND_API.G_FALSE
110: , p_count => x_msg_count
111: , p_data => x_msg_data
112: );

Line 147: FND_MSG_PUB.Initialize;

143:
144: l_user_id NUMBER;
145: l_login_id NUMBER;
146: BEGIN
147: FND_MSG_PUB.Initialize;
148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149:
150: SAVEPOINT BscColorPvt_UpdColor;
151: /*BSC_COLOR_PKG.UPDATE_ROW(p_Bsc_Color_Rec.color_id

Line 231: FND_MSG_PUB.Initialize;

227: ,x_msg_count OUT NOCOPY NUMBER
228: ,x_msg_data OUT NOCOPY VARCHAR2
229: ) IS
230: BEGIN
231: FND_MSG_PUB.Initialize;
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
233:
234: SAVEPOINT BscColorPvt_DelColor;
235:

Line 238: FND_MSG_PUB.ADD;

234: SAVEPOINT BscColorPvt_DelColor;
235:
236: IF(p_Bsc_Color_Id IS NULL AND p_Bsc_Color_SN IS NULL) THEN
237: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_ID_SN');
238: FND_MSG_PUB.ADD;
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241: BSC_COLOR_PKG.DELETE_ROW(p_Bsc_Color_Id
242: ,p_Bsc_Color_SN);

Line 341: FND_MSG_PUB.Initialize;

337: l_Bsc_Color_Rec BSC_COLOR_PUB.Bsc_Color_Rec;
338: l_user_id NUMBER;
339: l_login_id NUMBER;
340: BEGIN
341: FND_MSG_PUB.Initialize;
342: x_return_status := FND_API.G_RET_STS_SUCCESS;
343:
344: SAVEPOINT BscColorPvt_LdTrnsColor;
345:

Line 431: FND_MSG_PUB.Initialize;

427: color, user_color, forecast_color, user_forecast_color, numeric_equivalent, user_numeric_equivalent, last_update_date
428: FROM bsc_sys_colors_vl
429: WHERE short_name = p_Bsc_Color_SN;
430: BEGIN
431: FND_MSG_PUB.Initialize;
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433:
434: SAVEPOINT BscColorPvt_RetColor;
435:

Line 438: FND_MSG_PUB.ADD;

434: SAVEPOINT BscColorPvt_RetColor;
435:
436: IF(p_Bsc_Color_Id IS NULL AND p_Bsc_Color_SN IS NULL) THEN
437: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_ID_SN');
438: FND_MSG_PUB.ADD;
439: RAISE FND_API.G_EXC_ERROR;
440: END IF;
441:
442: IF(p_Bsc_Color_Id IS NOT NULL) THEN

Line 505: FND_MSG_PUB.Initialize;

501: l_user_id NUMBER;
502: l_login_id NUMBER;
503: l_count NUMBER;
504: BEGIN
505: FND_MSG_PUB.Initialize;
506: x_return_status := FND_API.G_RET_STS_SUCCESS;
507:
508: SAVEPOINT BscColorPvt_LoadColor;
509: