DBA Data[Home] [Help]

APPS.GMI_PICK_CONFIRM_PUB dependencies on FND_MESSAGE

Line 218: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_MO_LINE_ID');

214: THEN
215: CLOSE move_order_line_cur;
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;

Line 219: FND_MESSAGE.SET_TOKEN('MO_LINE_ID ',p_mo_line_id );

215: CLOSE move_order_line_cur;
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:

Line 237: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_DEL_DETAIL_ID');

233: THEN
234: PrintMsg('ERROR: No move order line found for this delivery_detail_id : '||
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;

Line 238: FND_MESSAGE.SET_TOKEN('DEL_DETAIL_ID',p_delivery_detail_id );

234: PrintMsg('ERROR: No move order line found for this delivery_detail_id : '||
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;

Line 246: FND_MESSAGE.SET_NAME('GMI','GMI_API_NO_INPUT_LINE_ID');

242: CLOSE move_order_line_cur2;
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:

Line 266: FND_MESSAGE.Set_Name('GMI','GMI_API_ITEM_NOT_FOUND');

262:
263: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
264: THEN
265: PrintMsg('ERROR - Get Item Details returned Error ');
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;

Line 267: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_mo_line_row.organization_id);

263: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
264: THEN
265: PrintMsg('ERROR - Get Item Details returned Error ');
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;

Line 268: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_mo_line_row.inventory_item_id);

264: THEN
265: PrintMsg('ERROR - Get Item Details returned Error ');
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;

Line 269: FND_MESSAGE.Set_Token('LINE_ID', l_mo_line_row.line_id);

265: PrintMsg('ERROR - Get Item Details returned Error ');
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:

Line 349: FND_MESSAGE.Set_Name('GMI','GMI_API_NO_ALLOCATIONS');

345: IF( l_count = 0) AND (UPPER(p_bk_ordr_if_no_alloc) <> 'Y')
346: THEN
347: PrintMsg('ERROR - No applicable allocations for mo_line_id : '||l_mo_line_row.line_id
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;

Line 350: FND_MESSAGE.Set_Token('MO_LINE_ID', l_mo_line_row.line_id);

346: THEN
347: PrintMsg('ERROR - No applicable allocations for mo_line_id : '||l_mo_line_row.line_id
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;

Line 351: FND_MESSAGE.Set_Token('DELIVERY_DETAIL_ID', p_delivery_detail_id);

347: PrintMsg('ERROR - No applicable allocations for mo_line_id : '||l_mo_line_row.line_id
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:

Line 375: FND_MESSAGE.Set_Name('GMI','GMI_API_MO_LINE_LOCKED');

371:
372: IF ( x_return_status = '54' )
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;

Line 376: FND_MESSAGE.Set_Token('MO_LINE_ID', l_mo_line_row.line_id);

372: IF ( x_return_status = '54' )
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:

Line 387: FND_MESSAGE.SET_NAME('GMI', 'GMI_API_NO_LINES_TO_PICK_CONF');

383:
384: IF ( l_mo_line_tbl.count = 0 )
385: THEN
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;

Line 388: FND_MESSAGE.Set_Token('MO_LINE_ID', l_mo_line_row.line_id);

384: IF ( l_mo_line_tbl.count = 0 )
385: THEN
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;

Line 389: FND_MESSAGE.Set_Token('DELIVERY_DETAIL_ID', p_delivery_detail_id);

385: THEN
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:

Line 419: FND_MESSAGE.SET_NAME('GMI','GMI_API_PICK_CONFIRM_WARNING');

415:
416: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )
417: THEN
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;

Line 420: FND_MESSAGE.SET_TOKEN('MO_LINE_ID',l_mo_line_rec.line_id);

416: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )
417: THEN
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:

Line 421: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);

417: THEN
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 )

Line 428: FND_MESSAGE.SET_NAME('GMI','GMI_API_PICK_CONFIRM_ERROR');

424:
425: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS )
426: THEN
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;

Line 429: FND_MESSAGE.SET_TOKEN('MO_LINE_ID',l_mo_line_rec.line_id);

425: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS )
426: THEN
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

Line 430: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);

426: THEN
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');