DBA Data[Home] [Help]

APPS.CN_SEASONALITIES_PVT dependencies on FND_MSG_PUB

Line 68: FND_MSG_PUB.initialize;

64: END IF;
65:
66: -- Initialize message list if p_init_msg_list is set to TRUE.
67: IF FND_API.to_Boolean( p_init_msg_list ) THEN
68: FND_MSG_PUB.initialize;
69: END IF;
70: -- Initialize API return status to success
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72: l_validation_status := 'INVALID';

Line 98: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

94: );
95: --DBMS_OUTPUT.PUT_LINE('Call CN_SEAS_SCHEDULES completed validating the output');
96: IF l_return_status <> 'S' THEN
97: --DBMS_OUTPUT.PUT_LINE('Updation on CN_SEAS_SCHEDULES Failed');
98: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
99: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_SCH_UPD_FAIL');
100: FND_MSG_PUB.Add;
101: END IF;
102: RAISE FND_API.G_EXC_ERROR ;

Line 100: FND_MSG_PUB.Add;

96: IF l_return_status <> 'S' THEN
97: --DBMS_OUTPUT.PUT_LINE('Updation on CN_SEAS_SCHEDULES Failed');
98: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
99: FND_MESSAGE.SET_NAME ('CN' , 'CN_SEAS_SCH_UPD_FAIL');
100: FND_MSG_PUB.Add;
101: END IF;
102: RAISE FND_API.G_EXC_ERROR ;
103: END IF;
104:

Line 126: FND_MSG_PUB.Count_And_Get

122: IF FND_API.To_Boolean( p_commit ) THEN
123: COMMIT WORK;
124: END IF;
125: -- Standard call to get message count and if count is 1, get message info.
126: FND_MSG_PUB.Count_And_Get
127: (
128: p_count => x_msg_count ,
129: p_data => x_msg_data ,
130: p_encoded => FND_API.G_FALSE

Line 137: FND_MSG_PUB.Count_And_Get

133: EXCEPTION
134: WHEN FND_API.G_EXC_ERROR THEN
135: ROLLBACK TO Update_Seasonalities ;
136: x_return_status := FND_API.G_RET_STS_ERROR ;
137: FND_MSG_PUB.Count_And_Get
138: (
139: p_count => x_msg_count ,
140: p_data => x_msg_data ,
141: p_encoded => FND_API.G_FALSE

Line 147: FND_MSG_PUB.Count_And_Get

143:
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: ROLLBACK TO Update_Seasonalities ;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
147: FND_MSG_PUB.Count_And_Get
148: (
149: p_count => x_msg_count ,
150: p_data => x_msg_data ,
151: p_encoded => FND_API.G_FALSE

Line 159: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
156: l_error_code := SQLCODE;
157: IF l_error_code = -54 THEN
158: x_return_status := FND_API.G_RET_STS_ERROR ;
159: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
160: THEN
161: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
162: FND_MSG_PUB.Add;
163: END IF;

Line 162: FND_MSG_PUB.Add;

158: x_return_status := FND_API.G_RET_STS_ERROR ;
159: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
160: THEN
161: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
162: FND_MSG_PUB.Add;
163: END IF;
164: ELSE
165: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
166: THEN

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

161: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
162: FND_MSG_PUB.Add;
163: END IF;
164: ELSE
165: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
166: THEN
167: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
168: END IF;
169: END IF;

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

163: END IF;
164: ELSE
165: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
166: THEN
167: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
168: END IF;
169: END IF;
170: FND_MSG_PUB.Count_And_Get
171: (

Line 170: FND_MSG_PUB.Count_And_Get

166: THEN
167: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
168: END IF;
169: END IF;
170: FND_MSG_PUB.Count_And_Get
171: (
172: p_count => x_msg_count ,
173: p_data => x_msg_data ,
174: p_encoded => FND_API.G_FALSE

Line 242: FND_MSG_PUB.initialize;

238: END IF;
239:
240: -- Initialize message list if p_init_msg_list is set to TRUE.
241: IF FND_API.to_Boolean( p_init_msg_list ) THEN
242: FND_MSG_PUB.initialize;
243: END IF;
244: -- Initialize API return status to success
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246:

Line 290: FND_MSG_PUB.Count_And_Get

286: IF FND_API.To_Boolean( p_commit ) THEN
287: COMMIT WORK;
288: END IF;
289: -- Standard call to get message count and if count is 1, get message info.
290: FND_MSG_PUB.Count_And_Get
291: (
292: p_count => x_msg_count ,
293: p_data => x_msg_data ,
294: p_encoded => FND_API.G_FALSE

Line 301: FND_MSG_PUB.Count_And_Get

297: EXCEPTION
298: WHEN FND_API.G_EXC_ERROR THEN
299: ROLLBACK TO Validate_Seasonalities ;
300: x_return_status := FND_API.G_RET_STS_ERROR ;
301: FND_MSG_PUB.Count_And_Get
302: (
303: p_count => x_msg_count ,
304: p_data => x_msg_data ,
305: p_encoded => FND_API.G_FALSE

Line 311: FND_MSG_PUB.Count_And_Get

307:
308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
309: ROLLBACK TO Validate_Seasonalities ;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311: FND_MSG_PUB.Count_And_Get
312: (
313: p_count => x_msg_count ,
314: p_data => x_msg_data ,
315: p_encoded => FND_API.G_FALSE

Line 323: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
320: l_error_code := SQLCODE;
321: IF l_error_code = -54 THEN
322: x_return_status := FND_API.G_RET_STS_ERROR ;
323: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
324: THEN
325: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
326: FND_MSG_PUB.Add;
327: END IF;

Line 326: FND_MSG_PUB.Add;

322: x_return_status := FND_API.G_RET_STS_ERROR ;
323: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
324: THEN
325: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
326: FND_MSG_PUB.Add;
327: END IF;
328: ELSE
329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
330: THEN

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

325: FND_MESSAGE.SET_NAME ('CN' , 'CN_LOCK_FAIL');
326: FND_MSG_PUB.Add;
327: END IF;
328: ELSE
329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
330: THEN
331: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
332: END IF;
333: END IF;

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

327: END IF;
328: ELSE
329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
330: THEN
331: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
332: END IF;
333: END IF;
334: FND_MSG_PUB.Count_And_Get
335: (

Line 334: FND_MSG_PUB.Count_And_Get

330: THEN
331: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
332: END IF;
333: END IF;
334: FND_MSG_PUB.Count_And_Get
335: (
336: p_count => x_msg_count ,
337: p_data => x_msg_data ,
338: p_encoded => FND_API.G_FALSE