DBA Data[Home] [Help]

APPS.WSH_ITM_ERROR_PKG dependencies on FND_MSG_PUB

Line 64: FND_MSG_PUB.ADD;

60: l_api_name ,
61: G_PKG_NAME )
62: THEN
63: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
64: FND_MSG_PUB.ADD;
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;
67:
68: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 70: FND_MSG_PUB.initialize;

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

Line 101: FND_MSG_PUB.ADD;

97: ) ;
98:
99: IF SQL%NOTFOUND THEN
100: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');
101: FND_MSG_PUB.ADD;
102: x_return_status := FND_API.G_RET_STS_ERROR;
103: RAISE FND_API.G_EXC_ERROR ;
104: END IF;
105:

Line 127: FND_MSG_PUB.Count_And_Get

123:
124: -- Standard call to get message count and if count is 1,
125: -- get message info.
126:
127: FND_MSG_PUB.Count_And_Get
128: ( p_count => x_msg_count,
129: p_data => x_msg_data
130: );
131:

Line 136: FND_MSG_PUB.Count_And_Get

132: EXCEPTION
133: WHEN FND_API.G_EXC_ERROR THEN
134: ROLLBACK TO WSH_ITM_ERROR_PKG;
135: x_return_status := FND_API.G_RET_STS_ERROR;
136: FND_MSG_PUB.Count_And_Get
137: ( p_count => x_msg_count,
138: p_data => x_msg_data
139: );
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 143: FND_MSG_PUB.Count_And_Get

139: );
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
141: ROLLBACK TO WSH_ITM_ERROR_PKG;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: FND_MSG_PUB.Count_And_Get
144: ( p_count => x_msg_count,
145: p_data => x_msg_data
146: );
147: WHEN OTHERS THEN

Line 150: IF FND_MSG_PUB.Check_Msg_Level

146: );
147: WHEN OTHERS THEN
148: ROLLBACK TO WSH_ITM_ERROR_PKG;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: IF FND_MSG_PUB.Check_Msg_Level
151: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
152: THEN
153: FND_MSG_PUB.Add_Exc_Msg
154: ( G_PKG_NAME ,

Line 151: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

147: WHEN OTHERS THEN
148: ROLLBACK TO WSH_ITM_ERROR_PKG;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: IF FND_MSG_PUB.Check_Msg_Level
151: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
152: THEN
153: FND_MSG_PUB.Add_Exc_Msg
154: ( G_PKG_NAME ,
155: l_api_name

Line 153: FND_MSG_PUB.Add_Exc_Msg

149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: IF FND_MSG_PUB.Check_Msg_Level
151: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
152: THEN
153: FND_MSG_PUB.Add_Exc_Msg
154: ( G_PKG_NAME ,
155: l_api_name
156: );
157: END IF;

Line 158: FND_MSG_PUB.Count_And_Get

154: ( G_PKG_NAME ,
155: l_api_name
156: );
157: END IF;
158: FND_MSG_PUB.Count_And_Get
159: ( p_count => x_msg_count,
160: p_data => x_msg_data
161: );
162: End Insert_Row;

Line 239: FND_MSG_PUB.ADD;

235: l_api_name ,
236: G_PKG_NAME )
237: THEN
238: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
239: FND_MSG_PUB.ADD;
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: END IF;
242:
243: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 245: FND_MSG_PUB.initialize;

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

Line 267: FND_MSG_PUB.ADD;

263: WHERE rowid = p_rowid;
264:
265: IF SQL%NOTFOUND THEN
266: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');
267: FND_MSG_PUB.ADD;
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: RAISE FND_API.G_EXC_ERROR ;
270: END IF;
271:

Line 283: FND_MSG_PUB.Count_And_Get

279: END IF;
280:
281: -- Standard call to get message count and if count is 1,
282: -- get message info.
283: FND_MSG_PUB.Count_And_Get
284: ( p_count => x_msg_count,
285: p_data => x_msg_data
286: );
287:

Line 292: FND_MSG_PUB.Count_And_Get

288: EXCEPTION
289: WHEN FND_API.G_EXC_ERROR THEN
290: ROLLBACK TO WSH_ITM_ERROR_PKG;
291: x_return_status := FND_API.G_RET_STS_ERROR;
292: FND_MSG_PUB.Count_And_Get
293: ( p_count => x_msg_count,
294: p_data => x_msg_data
295: );
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 299: FND_MSG_PUB.Count_And_Get

295: );
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: ROLLBACK TO WSH_ITM_ERROR_PKG;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: FND_MSG_PUB.Count_And_Get
300: ( p_count => x_msg_count,
301: p_data => x_msg_data
302: );
303: WHEN OTHERS THEN

Line 306: IF FND_MSG_PUB.Check_Msg_Level

302: );
303: WHEN OTHERS THEN
304: ROLLBACK TO WSH_ITM_ERROR_PKG;
305: x_return_status := 'W';
306: IF FND_MSG_PUB.Check_Msg_Level
307: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
308: THEN
309: FND_MSG_PUB.Add_Exc_Msg
310: ( G_PKG_NAME ,

Line 307: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

303: WHEN OTHERS THEN
304: ROLLBACK TO WSH_ITM_ERROR_PKG;
305: x_return_status := 'W';
306: IF FND_MSG_PUB.Check_Msg_Level
307: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
308: THEN
309: FND_MSG_PUB.Add_Exc_Msg
310: ( G_PKG_NAME ,
311: l_api_name

Line 309: FND_MSG_PUB.Add_Exc_Msg

305: x_return_status := 'W';
306: IF FND_MSG_PUB.Check_Msg_Level
307: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
308: THEN
309: FND_MSG_PUB.Add_Exc_Msg
310: ( G_PKG_NAME ,
311: l_api_name
312: );
313: END IF;

Line 314: FND_MSG_PUB.Count_And_Get

310: ( G_PKG_NAME ,
311: l_api_name
312: );
313: END IF;
314: FND_MSG_PUB.Count_And_Get
315: ( p_count => x_msg_count,
316: p_data => x_msg_data
317: );
318:

Line 387: FND_MSG_PUB.ADD;

383: l_api_name ,
384: G_PKG_NAME )
385: THEN
386: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
387: FND_MSG_PUB.ADD;
388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: END IF;
390:
391: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 393: FND_MSG_PUB.initialize;

389: END IF;
390:
391: -- Initialize message list if p_init_msg_list is set to TRUE.
392: IF FND_API.to_Boolean( p_init_msg_list ) THEN
393: FND_MSG_PUB.initialize;
394: END IF;
395:
396: -- Initialize API return status to success
397: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 405: FND_MSG_PUB.ADD;

401: WHERE rowid = p_rowid;
402:
403: IF SQL%NOTFOUND THEN
404: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');
405: FND_MSG_PUB.ADD;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: RAISE FND_API.G_EXC_ERROR ;
408: END IF;
409:

Line 422: FND_MSG_PUB.Count_And_Get

418:
419: -- Standard call to get message count and if count is 1,
420: -- get message info.
421:
422: FND_MSG_PUB.Count_And_Get
423: ( p_count => x_msg_count,
424: p_data => x_msg_data
425: );
426:

Line 431: FND_MSG_PUB.Count_And_Get

427: EXCEPTION
428: WHEN FND_API.G_EXC_ERROR THEN
429: ROLLBACK TO WSH_ITM_ERROR_PKG;
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: FND_MSG_PUB.Count_And_Get
432: ( p_count => x_msg_count,
433: p_data => x_msg_data
434: );
435:

Line 439: FND_MSG_PUB.Count_And_Get

435:
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO WSH_ITM_ERROR_PKG;
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: FND_MSG_PUB.Count_And_Get
440: ( p_count => x_msg_count,
441: p_data => x_msg_data
442: );
443:

Line 447: IF FND_MSG_PUB.Check_Msg_Level

443:
444: WHEN OTHERS THEN
445: ROLLBACK TO WSH_ITM_ERROR_PKG;
446: x_return_status := 'W';
447: IF FND_MSG_PUB.Check_Msg_Level
448: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
449: THEN
450: FND_MSG_PUB.Add_Exc_Msg
451: ( G_PKG_NAME ,

Line 448: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

444: WHEN OTHERS THEN
445: ROLLBACK TO WSH_ITM_ERROR_PKG;
446: x_return_status := 'W';
447: IF FND_MSG_PUB.Check_Msg_Level
448: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
449: THEN
450: FND_MSG_PUB.Add_Exc_Msg
451: ( G_PKG_NAME ,
452: l_api_name

Line 450: FND_MSG_PUB.Add_Exc_Msg

446: x_return_status := 'W';
447: IF FND_MSG_PUB.Check_Msg_Level
448: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
449: THEN
450: FND_MSG_PUB.Add_Exc_Msg
451: ( G_PKG_NAME ,
452: l_api_name
453: );
454: END IF;

Line 455: FND_MSG_PUB.Count_And_Get

451: ( G_PKG_NAME ,
452: l_api_name
453: );
454: END IF;
455: FND_MSG_PUB.Count_And_Get
456: ( p_count => x_msg_count,
457: p_data => x_msg_data
458: );
459:

Line 546: FND_MSG_PUB.ADD;

542: l_api_name ,
543: G_PKG_NAME )
544: THEN
545: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
546: FND_MSG_PUB.ADD;
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: END IF;
549:
550: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 552: FND_MSG_PUB.initialize;

548: END IF;
549:
550: -- Initialize message list if p_init_msg_list is set to TRUE.
551: IF FND_API.to_Boolean( p_init_msg_list ) THEN
552: FND_MSG_PUB.initialize;
553: END IF;
554:
555: -- Initialize API return status to success
556: x_return_status := FND_API.G_RET_STS_SUCCESS;