DBA Data[Home] [Help]

APPS.GMI_LOTUPDATE_PUB dependencies on FND_MSG_PUB

Line 49: FND_MSG_PUB.Initialize;

45: l_api_version CONSTANT NUMBER := 1.0 ;
46: l_count NUMBER;
47: BEGIN
48: IF FND_API.to_boolean(p_init_msg_list) THEN
49: FND_MSG_PUB.Initialize;
50: END IF;
51:
52: -- Standard call to check for call compatibility.
53: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 64: FND_MSG_PUB.Add;

60:
61: /* Transactions are not allowed for the default lots */
62: IF (p_lot_rec.lot_id = 0) THEN
63: FND_MESSAGE.SET_NAME ( 'GMI', 'IC_DEFAULTLOTERR');
64: FND_MSG_PUB.Add;
65: RAISE FND_API.G_EXC_ERROR;
66: END IF;
67:
68: /* Validate Item */

Line 76: FND_MSG_PUB.Add;

72: FROM ic_item_mst_b
73: WHERE item_id = p_lot_rec.item_id;
74: IF l_count = 0 THEN
75: FND_MESSAGE.SET_NAME ( 'GMI', 'IC_ITEMERR');
76: FND_MSG_PUB.Add;
77: RAISE FND_API.G_EXC_ERROR;
78: END IF;
79:
80: UPDATE ic_lots_mst

Line 117: FND_MSG_PUB.Add;

113: item_id = p_lot_rec.item_id and
114: lot_id = p_lot_rec.lot_id;
115: IF SQL%NOTFOUND THEN
116: FND_MESSAGE.SET_NAME ( 'GMI', 'IC_NO_REC_GIVEN_PARAM');
117: FND_MSG_PUB.Add;
118: RAISE FND_API.G_EXC_ERROR;
119: END IF;
120:
121: IF FND_API.To_Boolean(p_commit) THEN

Line 125: FND_MSG_PUB.Count_AND_GET

121: IF FND_API.To_Boolean(p_commit) THEN
122: COMMIT WORK;
123: END IF;
124:
125: FND_MSG_PUB.Count_AND_GET
126: (p_count => x_msg_count, p_data => x_msg_data);
127:
128: EXCEPTION
129: WHEN FND_API.G_EXC_ERROR THEN

Line 131: FND_MSG_PUB.Count_AND_GET

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

Line 136: FND_MSG_PUB.Count_AND_GET

132: (p_count => x_msg_count, p_data => x_msg_data);
133:
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: FND_MSG_PUB.Count_AND_GET
137: (p_count => x_msg_count, p_data => x_msg_data);
138:
139: WHEN OTHERS THEN
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 141: FND_MSG_PUB.Count_AND_GET

137: (p_count => x_msg_count, p_data => x_msg_data);
138:
139: WHEN OTHERS THEN
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: FND_MSG_PUB.Count_AND_GET
142: (p_count => x_msg_count, p_data => x_msg_data);
143: END;
144:
145:

Line 187: FND_MSG_PUB.Initialize;

183: l_old_rec cur_old_lot%ROWTYPE;
184:
185: BEGIN
186: IF FND_API.to_boolean(p_init_msg_list) THEN
187: FND_MSG_PUB.Initialize;
188: END IF;
189:
190: -- Standard call to check for call compatibility.
191: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 206: FND_MSG_PUB.Add;

202:
203: /* Transactions are not allowed for the default lots */
204: IF (l_old_rec.lot_id = 0) THEN
205: FND_MESSAGE.SET_NAME ( 'GMI', 'IC_DEFAULTLOTERR');
206: FND_MSG_PUB.Add;
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209:
210: /* Validate Item */

Line 218: FND_MSG_PUB.Add;

214: FROM ic_item_mst_b
215: WHERE item_id = l_old_rec.item_id;
216: IF l_count = 0 THEN
217: FND_MESSAGE.SET_NAME ( 'GMI', 'IC_ITEMERR');
218: FND_MSG_PUB.Add;
219: RAISE FND_API.G_EXC_ERROR;
220: END IF;
221:
222: /* Validate EXPIRE Date */

Line 226: FND_MSG_PUB.Add;

222: /* Validate EXPIRE Date */
223: IF (NVL(p_lot_rec.expire_date, SYSDATE ) <> NVL(l_old_rec.expire_date, SYSDATE)) THEN
224: IF p_lot_rec.expire_date IS NOT NULL AND p_lot_rec.expire_date < NVL(p_lot_rec.lot_created, l_old_rec.lot_created) THEN
225: FND_MESSAGE.SET_NAME('GMI','IC_PAST_EXPIRE_DATE');
226: FND_MSG_PUB.Add;
227: RAISE FND_API.G_EXC_ERROR;
228: END IF;
229: END IF;
230:

Line 272: FND_MSG_PUB.Add;

268:
269:
270: IF SQL%NOTFOUND THEN
271: FND_MESSAGE.SET_NAME ( 'GMI', 'IC_NO_REC_GIVEN_PARAM');
272: FND_MSG_PUB.Add;
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;
275:
276: IF FND_API.To_Boolean(p_commit) THEN

Line 280: FND_MSG_PUB.Count_AND_GET

276: IF FND_API.To_Boolean(p_commit) THEN
277: COMMIT WORK;
278: END IF;
279:
280: FND_MSG_PUB.Count_AND_GET
281: (p_count => x_msg_count, p_data => x_msg_data);
282:
283: EXCEPTION
284: WHEN FND_API.G_EXC_ERROR THEN

Line 286: FND_MSG_PUB.Count_AND_GET

282:
283: EXCEPTION
284: WHEN FND_API.G_EXC_ERROR THEN
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: FND_MSG_PUB.Count_AND_GET
287: (p_count => x_msg_count, p_data => x_msg_data);
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 291: FND_MSG_PUB.Count_AND_GET

287: (p_count => x_msg_count, p_data => x_msg_data);
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
291: FND_MSG_PUB.Count_AND_GET
292: (p_count => x_msg_count, p_data => x_msg_data);
293:
294: WHEN OTHERS THEN
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 296: FND_MSG_PUB.Count_AND_GET

292: (p_count => x_msg_count, p_data => x_msg_data);
293:
294: WHEN OTHERS THEN
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: FND_MSG_PUB.Count_AND_GET
297: (p_count => x_msg_count, p_data => x_msg_data);
298: END;
299:
300: END GMI_LotUpdate_PUB;