DBA Data[Home] [Help]

APPS.INV_SHORTCHECKEXEC_PUB dependencies on FND_MSG_PUB

Line 75: FND_MSG_PUB.initialize;

71: END IF;
72: --
73: -- Initialize message list if p_init_msg_list is set to true
74: IF FND_API.to_Boolean(p_init_msg_list) THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77: --
78: -- Initialize API return status to access
79: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 89: FND_MSG_PUB.Add;

85: FETCH L_Item_crs INTO L_Object_Exists;
86: IF L_Item_crs%NOTFOUND THEN
87: FND_MESSAGE.SET_NAME('INV','INV_SHORT_ITEM_NOT_FOUND');
88: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',TO_CHAR(p_inventory_item_id));
89: FND_MSG_PUB.Add;
90: RAISE FND_API.G_EXC_ERROR;
91: END IF;
92: CLOSE L_Item_crs;
93: END IF;

Line 116: FND_MSG_PUB.Count_And_Get

112: IF FND_API.to_Boolean(p_commit) THEN
113: COMMIT;
114: END IF;
115: -- Standard call to get message count and if count is 1, get message info
116: FND_MSG_PUB.Count_And_Get
117: (p_count => x_msg_count
118: , p_data => x_msg_data);
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN

Line 124: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

120: WHEN FND_API.G_EXC_ERROR THEN
121: --
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: --
124: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
125: , p_data => x_msg_data);
126: --
127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: --

Line 131: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: --
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: --
131: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
132: , p_data => x_msg_data);
133: --
134: WHEN OTHERS THEN
135: --

Line 138: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

134: WHEN OTHERS THEN
135: --
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: --
138: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
139: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
140: END IF;
141: --
142: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

135: --
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: --
138: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
139: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
140: END IF;
141: --
142: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
143: , p_data => x_msg_data);

Line 142: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

138: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
139: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
140: END IF;
141: --
142: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
143: , p_data => x_msg_data);
144: END;
145: -- Start OF comments
146: -- API name : CheckPrerequisites

Line 216: FND_MSG_PUB.initialize;

212: END IF;
213: --
214: -- Initialize message list if p_init_msg_list is set to true
215: IF FND_API.to_Boolean(p_init_msg_list) THEN
216: FND_MSG_PUB.initialize;
217: END IF;
218: --
219: -- Initialize API return status to access
220: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 229: FND_MSG_PUB.Add;

225: FETCH L_Item_crs INTO L_Object_Exists;
226: IF L_Item_crs%NOTFOUND THEN
227: FND_MESSAGE.SET_NAME('INV','INV_ITEM_NOT_FOUND');
228: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',TO_CHAR(p_inventory_item_id));
229: FND_MSG_PUB.Add;
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232: CLOSE L_Item_crs;
233: --

Line 242: FND_MSG_PUB.Add;

238: IF L_TransType_crs%NOTFOUND THEN
239: FND_MESSAGE.SET_NAME('INV','INV_TRANSACTION_TYPE_NOT_FOUND');
240: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE_ID',
241: TO_CHAR(p_transaction_type_id));
242: FND_MSG_PUB.Add;
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245: CLOSE L_TransType_crs;
246: END IF;

Line 262: FND_MSG_PUB.Count_And_Get

258: x_check_result => x_check_result
259: );
260: --
261: -- Standard call to get message count and if count is 1, get message info
262: FND_MSG_PUB.Count_And_Get
263: (p_count => x_msg_count
264: , p_data => x_msg_data);
265: EXCEPTION
266: WHEN FND_API.G_EXC_ERROR THEN

Line 270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

266: WHEN FND_API.G_EXC_ERROR THEN
267: --
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: --
270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
271: , p_data => x_msg_data);
272: --
273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
274: --

Line 277: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
274: --
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: --
277: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
278: , p_data => x_msg_data);
279: --
280: WHEN OTHERS THEN
281: --

Line 284: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

280: WHEN OTHERS THEN
281: --
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: --
284: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
285: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
286: END IF;
287: --
288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

281: --
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: --
284: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
285: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
286: END IF;
287: --
288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
289: , p_data => x_msg_data);

Line 288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

284: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
285: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
286: END IF;
287: --
288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
289: , p_data => x_msg_data);
290: END;
291: -- Start OF comments
292: -- API name : PurgeTempTable

Line 349: FND_MSG_PUB.initialize;

345: END IF;
346: --
347: -- Initialize message list if p_init_msg_list is set to true
348: IF FND_API.to_Boolean(p_init_msg_list) THEN
349: FND_MSG_PUB.initialize;
350: END IF;
351: --
352: -- Initialize API return status to access
353: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 370: FND_MSG_PUB.Count_And_Get

366: IF FND_API.to_Boolean(p_commit) THEN
367: COMMIT;
368: END IF;
369: -- Standard call to get message count and if count is 1, get message info
370: FND_MSG_PUB.Count_And_Get
371: (p_count => x_msg_count
372: , p_data => x_msg_data);
373: EXCEPTION
374: WHEN FND_API.G_EXC_ERROR THEN

Line 378: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

374: WHEN FND_API.G_EXC_ERROR THEN
375: --
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: --
378: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
379: , p_data => x_msg_data);
380: --
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: --

Line 385: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: --
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
384: --
385: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
386: , p_data => x_msg_data);
387: --
388: WHEN OTHERS THEN
389: --

Line 392: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

388: WHEN OTHERS THEN
389: --
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: --
392: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
393: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
394: END IF;
395: --
396: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

389: --
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: --
392: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
393: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
394: END IF;
395: --
396: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
397: , p_data => x_msg_data);

Line 396: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

392: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
393: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
394: END IF;
395: --
396: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
397: , p_data => x_msg_data);
398: END;
399: END INV_ShortCheckExec_PUB;