DBA Data[Home] [Help]

APPS.GMI_PICK_CONFIRM_PUB dependencies on FND_MSG_PUB

Line 180: FND_MSG_PUB.initialize;

176: /* Check p_init_msg_list
177: =========================================*/
178: IF FND_API.to_boolean(p_init_msg_list)
179: THEN
180: FND_MSG_PUB.initialize;
181: END IF;
182:
183:
184:

Line 220: FND_MSG_PUB.Add;

216: PrintMsg('No move order line found for this mo_line_id : '||
217: p_mo_line_id);
218: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_MO_LINE_ID');
219: FND_MESSAGE.SET_TOKEN('MO_LINE_ID ',p_mo_line_id );
220: FND_MSG_PUB.Add;
221: RAISE FND_API.G_EXC_ERROR;
222: END IF;
223:
224: CLOSE move_order_line_cur;

Line 239: FND_MSG_PUB.Add;

235: p_delivery_detail_id);
236: CLOSE move_order_line_cur2;
237: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_DEL_DETAIL_ID');
238: FND_MESSAGE.SET_TOKEN('DEL_DETAIL_ID',p_delivery_detail_id );
239: FND_MSG_PUB.Add;
240: RAISE FND_API.G_EXC_ERROR;
241: END IF;
242: CLOSE move_order_line_cur2;
243: /* Neither the move order nor the delivery detail is passed */

Line 247: FND_MSG_PUB.Add;

243: /* Neither the move order nor the delivery detail is passed */
244: ELSE
245: PrintMsg('ERROR: No move order line or delivery delivery detail line is passed ');
246: FND_MESSAGE.SET_NAME('GMI','GMI_API_NO_INPUT_LINE_ID');
247: FND_MSG_PUB.Add;
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250:
251:

Line 270: FND_MSG_PUB.Add;

266: FND_MESSAGE.Set_Name('GMI','GMI_API_ITEM_NOT_FOUND');
267: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_mo_line_row.organization_id);
268: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_mo_line_row.inventory_item_id);
269: FND_MESSAGE.Set_Token('LINE_ID', l_mo_line_row.line_id);
270: FND_MSG_PUB.Add;
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273:
274: /* Print the Item Details */

Line 352: FND_MSG_PUB.Add;

348: ||' and delivery_detail_id : '||p_delivery_detail_id );
349: FND_MESSAGE.Set_Name('GMI','GMI_API_NO_ALLOCATIONS');
350: FND_MESSAGE.Set_Token('MO_LINE_ID', l_mo_line_row.line_id);
351: FND_MESSAGE.Set_Token('DELIVERY_DETAIL_ID', p_delivery_detail_id);
352: FND_MSG_PUB.Add;
353: RAISE FND_API.G_EXC_ERROR;
354: END IF;
355:
356: /* Get The Move Order line (1 line) in to l_mo_line_tbl(1)

Line 377: FND_MSG_PUB.Add;

373: THEN
374: PrintMsg('ERROR : Pick_Confirm : the MO is locked for line_id= '|| l_mo_line_row.line_id);
375: FND_MESSAGE.Set_Name('GMI','GMI_API_MO_LINE_LOCKED');
376: FND_MESSAGE.Set_Token('MO_LINE_ID', l_mo_line_row.line_id);
377: FND_MSG_PUB.Add;
378: RAISE FND_API.G_EXC_ERROR;
379: END IF;
380:
381:

Line 390: FND_MSG_PUB.Add;

386: PrintMsg('No rows to pick confirm');
387: FND_MESSAGE.SET_NAME('GMI', 'GMI_API_NO_LINES_TO_PICK_CONF');
388: FND_MESSAGE.Set_Token('MO_LINE_ID', l_mo_line_row.line_id);
389: FND_MESSAGE.Set_Token('DELIVERY_DETAIL_ID', p_delivery_detail_id);
390: FND_MSG_PUB.Add;
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: PrintMsg('Before calling GMI_PICK_WAVE_CONFIRM_PVT.PICK_CONFIRM');

Line 422: FND_MSG_PUB.Add;

418: PrintMsg('WARNING : Returning from Pick_Confirm_Pvt with Warning');
419: FND_MESSAGE.SET_NAME('GMI','GMI_API_PICK_CONFIRM_WARNING');
420: FND_MESSAGE.SET_TOKEN('MO_LINE_ID',l_mo_line_rec.line_id);
421: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
422: FND_MSG_PUB.Add;
423: RAISE L_WARNING;
424:
425: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS )
426: THEN

Line 431: FND_MSG_PUB.Add;

427: PrintMsg('ERROR : Returning from Pick_Confirm_Pvt with error');
428: FND_MESSAGE.SET_NAME('GMI','GMI_API_PICK_CONFIRM_ERROR');
429: FND_MESSAGE.SET_TOKEN('MO_LINE_ID',l_mo_line_rec.line_id);
430: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
431: FND_MSG_PUB.Add;
432: RAISE FND_API.G_EXC_ERROR;
433: ELSE
434: PrintMsg('SUCCESS : Returning from Pick_Confirm_Pvt with success');
435: END IF;

Line 449: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

445:
446:
447: x_return_status := FND_API.G_RET_STS_ERROR;
448:
449: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
450: , l_api_name
451: );
452: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
453: , p_count => x_msg_count

Line 452: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

448:
449: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
450: , l_api_name
451: );
452: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
453: , p_count => x_msg_count
454: , p_data => x_msg_data
455: );
456:

Line 461: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: --ROLLBACK TO SAVEPOINT Pick_Confirm_SP;
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
460:
461: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
462: , l_api_name
463: );
464: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
465: , p_count => x_msg_count

Line 464: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

460:
461: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
462: , l_api_name
463: );
464: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
465: , p_count => x_msg_count
466: , p_data => x_msg_data
467: );
468: WHEN L_WARNING THEN

Line 472: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

468: WHEN L_WARNING THEN
469: --ROLLBACK TO SAVEPOINT Pick_Confirm_SP;
470: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
471:
472: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
473: , l_api_name
474: );
475: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
476: , p_count => x_msg_count

Line 475: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

471:
472: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
473: , l_api_name
474: );
475: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
476: , p_count => x_msg_count
477: , p_data => x_msg_data);
478:
479: WHEN OTHERS THEN

Line 481: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

477: , p_data => x_msg_data);
478:
479: WHEN OTHERS THEN
480: --ROLLBACK TO SAVEPOINT Pick_Confirm_SP;
481: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
482: , l_api_name
483: );
484:
485: /* Get message count and data */

Line 486: FND_MSG_PUB.count_and_get

482: , l_api_name
483: );
484:
485: /* Get message count and data */
486: FND_MSG_PUB.count_and_get
487: ( p_count => x_msg_count
488: , p_data => x_msg_data
489: );
490: END Pick_Confirm;