APPS.GMI_OM_ALLOC_API_PUB dependencies on FND_MESSAGE

Line 357: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_ACTION_CODE');

353:
354: IF( UPPER(NVL(l_tran_rec.action_code, 'N')) not in ('INSERT', 'UPDATE', 'DELETE'))
355: THEN
356: PrintMsg('ERROR - Validation failed on action_code Only ');
357: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_ACTION_CODE');
358: FND_MESSAGE.SET_TOKEN('ACTION_CODE ',l_tran_rec.action_code );
359: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
360: FND_MSG_PUB.Add;
361: RAISE FND_API.G_EXC_ERROR;

Line 358: FND_MESSAGE.SET_TOKEN('ACTION_CODE ',l_tran_rec.action_code );

354: IF( UPPER(NVL(l_tran_rec.action_code, 'N')) not in ('INSERT', 'UPDATE', 'DELETE'))
355: THEN
356: PrintMsg('ERROR - Validation failed on action_code Only ');
357: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_ACTION_CODE');
358: FND_MESSAGE.SET_TOKEN('ACTION_CODE ',l_tran_rec.action_code );
359: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
360: FND_MSG_PUB.Add;
361: RAISE FND_API.G_EXC_ERROR;
362: END IF;

Line 359: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );

355: THEN
356: PrintMsg('ERROR - Validation failed on action_code Only ');
357: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_ACTION_CODE');
358: FND_MESSAGE.SET_TOKEN('ACTION_CODE ',l_tran_rec.action_code );
359: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
360: FND_MSG_PUB.Add;
361: RAISE FND_API.G_EXC_ERROR;
362: END IF;
363:

Line 377: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_ID_REQUIRED');

373: IF( NVL(l_tran_rec.trans_id,0) = 0 )
374: THEN
375: PrintMsg('ERROR - Validation failed for trans_id');
376: l_error_flag := FND_API.G_TRUE;
377: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_ID_REQUIRED');
378: FND_MESSAGE.SET_TOKEN('ACTION_CODE ',l_tran_rec.action_code );
379: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
380: FND_MSG_PUB.Add;
381: RAISE FND_API.G_EXC_ERROR;

Line 378: FND_MESSAGE.SET_TOKEN('ACTION_CODE ',l_tran_rec.action_code );

374: THEN
375: PrintMsg('ERROR - Validation failed for trans_id');
376: l_error_flag := FND_API.G_TRUE;
377: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_ID_REQUIRED');
378: FND_MESSAGE.SET_TOKEN('ACTION_CODE ',l_tran_rec.action_code );
379: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
380: FND_MSG_PUB.Add;
381: RAISE FND_API.G_EXC_ERROR;
382: END IF;

Line 379: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );

375: PrintMsg('ERROR - Validation failed for trans_id');
376: l_error_flag := FND_API.G_TRUE;
377: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_ID_REQUIRED');
378: FND_MESSAGE.SET_TOKEN('ACTION_CODE ',l_tran_rec.action_code );
379: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
380: FND_MSG_PUB.Add;
381: RAISE FND_API.G_EXC_ERROR;
382: END IF;
383: ELSIF( NVL(l_tran_rec.trans_id,0) <> 0)

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

383: ELSIF( NVL(l_tran_rec.trans_id,0) <> 0)
384: THEN
385: PrintMsg('ERROR - Trans_id not required for INSERT');
386: l_error_flag := FND_API.G_TRUE;
387: FND_MESSAGE.SET_NAME('GMI','GMI_API_TRANS_ID_NOT_REQUIRED');
388: FND_MESSAGE.SET_TOKEN('ACTION_CODE ',l_tran_rec.action_code );
389: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
390: FND_MSG_PUB.Add;
391: RAISE FND_API.G_EXC_ERROR;

Line 388: FND_MESSAGE.SET_TOKEN('ACTION_CODE ',l_tran_rec.action_code );

384: THEN
385: PrintMsg('ERROR - Trans_id not required for INSERT');
386: l_error_flag := FND_API.G_TRUE;
387: FND_MESSAGE.SET_NAME('GMI','GMI_API_TRANS_ID_NOT_REQUIRED');
388: FND_MESSAGE.SET_TOKEN('ACTION_CODE ',l_tran_rec.action_code );
389: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
390: FND_MSG_PUB.Add;
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;

Line 389: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );

385: PrintMsg('ERROR - Trans_id not required for INSERT');
386: l_error_flag := FND_API.G_TRUE;
387: FND_MESSAGE.SET_NAME('GMI','GMI_API_TRANS_ID_NOT_REQUIRED');
388: FND_MESSAGE.SET_TOKEN('ACTION_CODE ',l_tran_rec.action_code );
389: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
390: FND_MSG_PUB.Add;
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:

Line 406: FND_MESSAGE.SET_NAME('GML','GMI_API_INVALID_TRANS_ID');

402: THEN
403: CLOSE validate_trans_id_cur;
404: PrintMsg('ERROR - Invalid Trans_id for action code : '||l_tran_rec.action_code);
405: l_error_flag := FND_API.G_TRUE;
406: FND_MESSAGE.SET_NAME('GML','GMI_API_INVALID_TRANS_ID');
407: FND_MESSAGE.SET_TOKEN('TRANS_ID',l_tran_rec.trans_id );
408: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.LINE_ID );
409: FND_MSG_PUB.Add;
410: RAISE FND_API.G_EXC_ERROR;

Line 407: FND_MESSAGE.SET_TOKEN('TRANS_ID',l_tran_rec.trans_id );

403: CLOSE validate_trans_id_cur;
404: PrintMsg('ERROR - Invalid Trans_id for action code : '||l_tran_rec.action_code);
405: l_error_flag := FND_API.G_TRUE;
406: FND_MESSAGE.SET_NAME('GML','GMI_API_INVALID_TRANS_ID');
407: FND_MESSAGE.SET_TOKEN('TRANS_ID',l_tran_rec.trans_id );
408: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.LINE_ID );
409: FND_MSG_PUB.Add;
410: RAISE FND_API.G_EXC_ERROR;
411: ELSIF (l_delete_mark = 1)

Line 408: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.LINE_ID );

404: PrintMsg('ERROR - Invalid Trans_id for action code : '||l_tran_rec.action_code);
405: l_error_flag := FND_API.G_TRUE;
406: FND_MESSAGE.SET_NAME('GML','GMI_API_INVALID_TRANS_ID');
407: FND_MESSAGE.SET_TOKEN('TRANS_ID',l_tran_rec.trans_id );
408: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.LINE_ID );
409: FND_MSG_PUB.Add;
410: RAISE FND_API.G_EXC_ERROR;
411: ELSIF (l_delete_mark = 1)
412: THEN

Line 416: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_DELETED');

412: THEN
413: CLOSE validate_trans_id_cur;
414: PrintMsg('ERROR - Invalid Trans_id Transaction is already deleted : '||l_tran_rec.trans_id);
415: l_error_flag := FND_API.G_TRUE;
416: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_DELETED');
417: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id );
418: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
419: FND_MSG_PUB.Add;
420: RAISE FND_API.G_EXC_ERROR;

Line 417: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id );

413: CLOSE validate_trans_id_cur;
414: PrintMsg('ERROR - Invalid Trans_id Transaction is already deleted : '||l_tran_rec.trans_id);
415: l_error_flag := FND_API.G_TRUE;
416: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_DELETED');
417: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id );
418: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
419: FND_MSG_PUB.Add;
420: RAISE FND_API.G_EXC_ERROR;
421: ELSIF (l_completed_ind = 1)

Line 418: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );

414: PrintMsg('ERROR - Invalid Trans_id Transaction is already deleted : '||l_tran_rec.trans_id);
415: l_error_flag := FND_API.G_TRUE;
416: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_DELETED');
417: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id );
418: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
419: FND_MSG_PUB.Add;
420: RAISE FND_API.G_EXC_ERROR;
421: ELSIF (l_completed_ind = 1)
422: THEN

Line 426: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_COMPLETED');

422: THEN
423: CLOSE validate_trans_id_cur;
424: PrintMsg('ERROR - Invalid Trans_id Transaction is already completed : '||l_tran_rec.trans_id);
425: l_error_flag := FND_API.G_TRUE;
426: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_COMPLETED');
427: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id );
428: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
429: FND_MSG_PUB.Add;
430: RAISE FND_API.G_EXC_ERROR;

Line 427: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id );

423: CLOSE validate_trans_id_cur;
424: PrintMsg('ERROR - Invalid Trans_id Transaction is already completed : '||l_tran_rec.trans_id);
425: l_error_flag := FND_API.G_TRUE;
426: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_COMPLETED');
427: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id );
428: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
429: FND_MSG_PUB.Add;
430: RAISE FND_API.G_EXC_ERROR;
431: ELSIF (l_staged_ind = 1)

Line 428: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );

424: PrintMsg('ERROR - Invalid Trans_id Transaction is already completed : '||l_tran_rec.trans_id);
425: l_error_flag := FND_API.G_TRUE;
426: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_COMPLETED');
427: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id );
428: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
429: FND_MSG_PUB.Add;
430: RAISE FND_API.G_EXC_ERROR;
431: ELSIF (l_staged_ind = 1)
432: THEN

Line 436: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_STAGED');

432: THEN
433: CLOSE validate_trans_id_cur;
434: PrintMsg('ERROR - Invalid Trans_id Transaction is already staged : '||l_tran_rec.trans_id);
435: l_error_flag := FND_API.G_TRUE;
436: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_STAGED');
437: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id );
438: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
439: FND_MSG_PUB.Add;
440: RAISE FND_API.G_EXC_ERROR;

Line 437: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id );

433: CLOSE validate_trans_id_cur;
434: PrintMsg('ERROR - Invalid Trans_id Transaction is already staged : '||l_tran_rec.trans_id);
435: l_error_flag := FND_API.G_TRUE;
436: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_STAGED');
437: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id );
438: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
439: FND_MSG_PUB.Add;
440: RAISE FND_API.G_EXC_ERROR;
441: END IF;

Line 438: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );

434: PrintMsg('ERROR - Invalid Trans_id Transaction is already staged : '||l_tran_rec.trans_id);
435: l_error_flag := FND_API.G_TRUE;
436: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_STAGED');
437: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id );
438: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
439: FND_MSG_PUB.Add;
440: RAISE FND_API.G_EXC_ERROR;
441: END IF;
442:

Line 456: FND_MESSAGE.SET_NAME('GMI','MISSING');

452: IF (NVL(l_tran_rec.line_id,0) = 0 )
453: THEN
454: PrintMsg('ERROR - validation failed on line id');
455: l_error_flag := FND_API.G_TRUE;
456: FND_MESSAGE.SET_NAME('GMI','MISSING');
457: FND_MESSAGE.SET_TOKEN('MISSING','line_id');
458: FND_MSG_PUB.Add;
459: RAISE FND_API.G_EXC_ERROR;
460: ELSE

Line 457: FND_MESSAGE.SET_TOKEN('MISSING','line_id');

453: THEN
454: PrintMsg('ERROR - validation failed on line id');
455: l_error_flag := FND_API.G_TRUE;
456: FND_MESSAGE.SET_NAME('GMI','MISSING');
457: FND_MESSAGE.SET_TOKEN('MISSING','line_id');
458: FND_MSG_PUB.Add;
459: RAISE FND_API.G_EXC_ERROR;
460: ELSE
461:

Line 472: FND_MESSAGE.SET_NAME('GML','GMI_API_INVALID_LINE_ID');

468: THEN
469: PrintMsg('ERROR - in oe_order_lines_cur%NOTFOUND : Invalid line_id');
470: l_error_flag := FND_API.G_TRUE;
471: CLOSE oe_order_lines_cur;
472: FND_MESSAGE.SET_NAME('GML','GMI_API_INVALID_LINE_ID');
473: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
474: FND_MSG_PUB.Add;
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;

Line 473: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);

469: PrintMsg('ERROR - in oe_order_lines_cur%NOTFOUND : Invalid line_id');
470: l_error_flag := FND_API.G_TRUE;
471: CLOSE oe_order_lines_cur;
472: FND_MESSAGE.SET_NAME('GML','GMI_API_INVALID_LINE_ID');
473: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
474: FND_MSG_PUB.Add;
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477:

Line 497: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LINE_STATUS');

493: THEN
494:
495: PrintMsg('ERROR - Invalid line_status : '||l_line_status);
496: l_error_flag := FND_API.G_TRUE;
497: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LINE_STATUS');
498: FND_MESSAGE.SET_TOKEN('LINE_STATUS ',l_line_status);
499: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
500: FND_MSG_PUB.Add;
501: RAISE FND_API.G_EXC_ERROR;

Line 498: FND_MESSAGE.SET_TOKEN('LINE_STATUS ',l_line_status);

494:
495: PrintMsg('ERROR - Invalid line_status : '||l_line_status);
496: l_error_flag := FND_API.G_TRUE;
497: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LINE_STATUS');
498: FND_MESSAGE.SET_TOKEN('LINE_STATUS ',l_line_status);
499: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
500: FND_MSG_PUB.Add;
501: RAISE FND_API.G_EXC_ERROR;
502:

Line 499: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);

495: PrintMsg('ERROR - Invalid line_status : '||l_line_status);
496: l_error_flag := FND_API.G_TRUE;
497: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LINE_STATUS');
498: FND_MESSAGE.SET_TOKEN('LINE_STATUS ',l_line_status);
499: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
500: FND_MSG_PUB.Add;
501: RAISE FND_API.G_EXC_ERROR;
502:
503: END IF;

Line 540: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LINE_DETAIL_ID');

536: IF (l_line_id <> l_tran_rec.line_id)
537: THEN
538: PrintMsg('ERROR - Invalid line_detail_id : '||l_line_detail_id);
539: l_error_flag := FND_API.G_TRUE;
540: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LINE_DETAIL_ID');
541: FND_MESSAGE.SET_TOKEN('LINE_DETAIL_ID ',l_tran_rec.line_detail_id);
542: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
543: FND_MSG_PUB.Add; /**** Define this message ****/
544: RAISE FND_API.G_EXC_ERROR;

Line 541: FND_MESSAGE.SET_TOKEN('LINE_DETAIL_ID ',l_tran_rec.line_detail_id);

537: THEN
538: PrintMsg('ERROR - Invalid line_detail_id : '||l_line_detail_id);
539: l_error_flag := FND_API.G_TRUE;
540: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LINE_DETAIL_ID');
541: FND_MESSAGE.SET_TOKEN('LINE_DETAIL_ID ',l_tran_rec.line_detail_id);
542: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
543: FND_MSG_PUB.Add; /**** Define this message ****/
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;

Line 542: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);

538: PrintMsg('ERROR - Invalid line_detail_id : '||l_line_detail_id);
539: l_error_flag := FND_API.G_TRUE;
540: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LINE_DETAIL_ID');
541: FND_MESSAGE.SET_TOKEN('LINE_DETAIL_ID ',l_tran_rec.line_detail_id);
542: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
543: FND_MSG_PUB.Add; /**** Define this message ****/
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546:

Line 581: FND_MESSAGE.SET_NAME('GMI','MISSING');

577: THEN
578: PrintMsg(' There are more than one delivery lines for this line_id : '||
579: l_tran_rec.line_id || 'Please specify one');
580: l_error_flag := FND_API.G_TRUE;
581: FND_MESSAGE.SET_NAME('GMI','MISSING');
582: FND_MESSAGE.SET_TOKEN('MISSING','Line_detail_id');
583: FND_MSG_PUB.Add;
584: RAISE FND_API.G_EXC_ERROR;
585: ELSIF (l_count = 1)

Line 582: FND_MESSAGE.SET_TOKEN('MISSING','Line_detail_id');

578: PrintMsg(' There are more than one delivery lines for this line_id : '||
579: l_tran_rec.line_id || 'Please specify one');
580: l_error_flag := FND_API.G_TRUE;
581: FND_MESSAGE.SET_NAME('GMI','MISSING');
582: FND_MESSAGE.SET_TOKEN('MISSING','Line_detail_id');
583: FND_MSG_PUB.Add;
584: RAISE FND_API.G_EXC_ERROR;
585: ELSIF (l_count = 1)
586: THEN

Line 596: FND_MESSAGE.SET_NAME('GMI','MISSING');

592: PrintMsg('ERROR - line_detail_id_cur%NOTFOUND for line_id'||
593: l_tran_rec.line_id);
594: l_error_flag := FND_API.G_TRUE;
595: CLOSE line_detail_id_cur;
596: FND_MESSAGE.SET_NAME('GMI','MISSING');
597: FND_MESSAGE.SET_TOKEN('MISSING','Line_detail_id');
598: FND_MSG_PUB.Add;
599: RAISE FND_API.G_EXC_ERROR;
600:

Line 597: FND_MESSAGE.SET_TOKEN('MISSING','Line_detail_id');

593: l_tran_rec.line_id);
594: l_error_flag := FND_API.G_TRUE;
595: CLOSE line_detail_id_cur;
596: FND_MESSAGE.SET_NAME('GMI','MISSING');
597: FND_MESSAGE.SET_TOKEN('MISSING','Line_detail_id');
598: FND_MSG_PUB.Add;
599: RAISE FND_API.G_EXC_ERROR;
600:
601: END IF;

Line 633: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_REASON_CODE');

629: THEN
630: PrintMsg('ERROR - Invalid reason_ code : '||l_tran_rec.reason_code);
631: CLOSE reas_code_cur;
632: l_error_flag := FND_API.G_TRUE;
633: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_REASON_CODE');
634: FND_MESSAGE.SET_TOKEN('REASON_CODE ',l_tran_rec.reason_code);
635: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
636: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id);
637: FND_MESSAGE.SET_TOKEN('LINE_DETAIL_ID ',l_tran_rec.line_detail_id);

Line 634: FND_MESSAGE.SET_TOKEN('REASON_CODE ',l_tran_rec.reason_code);

630: PrintMsg('ERROR - Invalid reason_ code : '||l_tran_rec.reason_code);
631: CLOSE reas_code_cur;
632: l_error_flag := FND_API.G_TRUE;
633: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_REASON_CODE');
634: FND_MESSAGE.SET_TOKEN('REASON_CODE ',l_tran_rec.reason_code);
635: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
636: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id);
637: FND_MESSAGE.SET_TOKEN('LINE_DETAIL_ID ',l_tran_rec.line_detail_id);
638: FND_MSG_PUB.Add;

Line 635: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);

631: CLOSE reas_code_cur;
632: l_error_flag := FND_API.G_TRUE;
633: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_REASON_CODE');
634: FND_MESSAGE.SET_TOKEN('REASON_CODE ',l_tran_rec.reason_code);
635: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
636: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id);
637: FND_MESSAGE.SET_TOKEN('LINE_DETAIL_ID ',l_tran_rec.line_detail_id);
638: FND_MSG_PUB.Add;
639: RAISE FND_API.G_EXC_ERROR;

Line 636: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id);

632: l_error_flag := FND_API.G_TRUE;
633: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_REASON_CODE');
634: FND_MESSAGE.SET_TOKEN('REASON_CODE ',l_tran_rec.reason_code);
635: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
636: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id);
637: FND_MESSAGE.SET_TOKEN('LINE_DETAIL_ID ',l_tran_rec.line_detail_id);
638: FND_MSG_PUB.Add;
639: RAISE FND_API.G_EXC_ERROR;
640: END IF;

Line 637: FND_MESSAGE.SET_TOKEN('LINE_DETAIL_ID ',l_tran_rec.line_detail_id);

633: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_REASON_CODE');
634: FND_MESSAGE.SET_TOKEN('REASON_CODE ',l_tran_rec.reason_code);
635: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
636: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id);
637: FND_MESSAGE.SET_TOKEN('LINE_DETAIL_ID ',l_tran_rec.line_detail_id);
638: FND_MSG_PUB.Add;
639: RAISE FND_API.G_EXC_ERROR;
640: END IF;
641:

Line 665: FND_MESSAGE.SET_NAME('GMI','GMI_API_WHSE_NOT_FOUND');

661: THEN
662: PrintMsg('ic_whse_mst_cur%NOTFOUND for Organization '||l_ship_from_org_id);
663: CLOSE ic_whse_mst_cur;
664: l_error_flag := FND_API.G_TRUE;
665: FND_MESSAGE.SET_NAME('GMI','GMI_API_WHSE_NOT_FOUND');
666: FND_MESSAGE.SET_TOKEN('ORG', l_ship_from_org_id);
667: FND_MESSAGE.SET_TOKEN('LINE_ID', l_tran_rec.line_id);
668: FND_MSG_PUB.Add;
669: RAISE FND_API.G_EXC_ERROR;

Line 666: FND_MESSAGE.SET_TOKEN('ORG', l_ship_from_org_id);

662: PrintMsg('ic_whse_mst_cur%NOTFOUND for Organization '||l_ship_from_org_id);
663: CLOSE ic_whse_mst_cur;
664: l_error_flag := FND_API.G_TRUE;
665: FND_MESSAGE.SET_NAME('GMI','GMI_API_WHSE_NOT_FOUND');
666: FND_MESSAGE.SET_TOKEN('ORG', l_ship_from_org_id);
667: FND_MESSAGE.SET_TOKEN('LINE_ID', l_tran_rec.line_id);
668: FND_MSG_PUB.Add;
669: RAISE FND_API.G_EXC_ERROR;
670: ELSE

Line 667: FND_MESSAGE.SET_TOKEN('LINE_ID', l_tran_rec.line_id);

663: CLOSE ic_whse_mst_cur;
664: l_error_flag := FND_API.G_TRUE;
665: FND_MESSAGE.SET_NAME('GMI','GMI_API_WHSE_NOT_FOUND');
666: FND_MESSAGE.SET_TOKEN('ORG', l_ship_from_org_id);
667: FND_MESSAGE.SET_TOKEN('LINE_ID', l_tran_rec.line_id);
668: FND_MSG_PUB.Add;
669: RAISE FND_API.G_EXC_ERROR;
670: ELSE
671: CLOSE ic_whse_mst_cur;

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

693: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
694: THEN
695: PrintMsg('ERROR - Get Item Details returned Error ');
696: l_error_flag := FND_API.G_TRUE;
697: FND_MESSAGE.Set_Name('GMI','GMI_API_ITEM_NOT_FOUND');
698: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
699: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_ship_from_org_id);
700: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
701: FND_MSG_PUB.Add;

Line 698: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);

694: THEN
695: PrintMsg('ERROR - Get Item Details returned Error ');
696: l_error_flag := FND_API.G_TRUE;
697: FND_MESSAGE.Set_Name('GMI','GMI_API_ITEM_NOT_FOUND');
698: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
699: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_ship_from_org_id);
700: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
701: FND_MSG_PUB.Add;
702: RAISE FND_API.G_EXC_ERROR;

Line 699: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_ship_from_org_id);

695: PrintMsg('ERROR - Get Item Details returned Error ');
696: l_error_flag := FND_API.G_TRUE;
697: FND_MESSAGE.Set_Name('GMI','GMI_API_ITEM_NOT_FOUND');
698: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
699: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_ship_from_org_id);
700: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
701: FND_MSG_PUB.Add;
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;

Line 700: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

696: l_error_flag := FND_API.G_TRUE;
697: FND_MESSAGE.Set_Name('GMI','GMI_API_ITEM_NOT_FOUND');
698: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
699: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_ship_from_org_id);
700: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
701: FND_MSG_PUB.Add;
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704:

Line 717: FND_MESSAGE.SET_NAME('GMI','GMI_API_NONINV_ITEM');

713: IF (l_ic_item_mst_rec.noninv_ind = 1)
714: THEN
715: PrintMsg('ERROR - Item is a non inventory item :'|| l_ic_item_mst_rec.item_no);
716: l_error_flag := FND_API.G_TRUE;
717: FND_MESSAGE.SET_NAME('GMI','GMI_API_NONINV_ITEM');
718: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
719: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
720: FND_MSG_PUB.Add;
721: RAISE FND_API.G_EXC_ERROR;

Line 718: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);

714: THEN
715: PrintMsg('ERROR - Item is a non inventory item :'|| l_ic_item_mst_rec.item_no);
716: l_error_flag := FND_API.G_TRUE;
717: FND_MESSAGE.SET_NAME('GMI','GMI_API_NONINV_ITEM');
718: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
719: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
720: FND_MSG_PUB.Add;
721: RAISE FND_API.G_EXC_ERROR;
722:

Line 719: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);

715: PrintMsg('ERROR - Item is a non inventory item :'|| l_ic_item_mst_rec.item_no);
716: l_error_flag := FND_API.G_TRUE;
717: FND_MESSAGE.SET_NAME('GMI','GMI_API_NONINV_ITEM');
718: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
719: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
720: FND_MSG_PUB.Add;
721: RAISE FND_API.G_EXC_ERROR;
722:
723: /* Must be active */

Line 728: FND_MESSAGE.SET_NAME('GMI','GMI_API_INACTIVE_ITEM');

724: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)
725: THEN
726: PrintMsg('ERROR - Inactive item :'|| l_ic_item_mst_rec.item_no);
727: l_error_flag := FND_API.G_TRUE;
728: FND_MESSAGE.SET_NAME('GMI','GMI_API_INACTIVE_ITEM');
729: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
730: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
731: FND_MSG_PUB.Add;
732: RAISE FND_API.G_EXC_ERROR;

Line 729: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);

725: THEN
726: PrintMsg('ERROR - Inactive item :'|| l_ic_item_mst_rec.item_no);
727: l_error_flag := FND_API.G_TRUE;
728: FND_MESSAGE.SET_NAME('GMI','GMI_API_INACTIVE_ITEM');
729: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
730: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
731: FND_MSG_PUB.Add;
732: RAISE FND_API.G_EXC_ERROR;
733:

Line 730: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);

726: PrintMsg('ERROR - Inactive item :'|| l_ic_item_mst_rec.item_no);
727: l_error_flag := FND_API.G_TRUE;
728: FND_MESSAGE.SET_NAME('GMI','GMI_API_INACTIVE_ITEM');
729: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
730: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
731: FND_MSG_PUB.Add;
732: RAISE FND_API.G_EXC_ERROR;
733:
734: /* Item should not be a no control item */

Line 739: FND_MESSAGE.SET_NAME('GMI','GMI_API_NO_CONTROL_ITEM');

735: ELSIF (l_ic_item_mst_rec.lot_ctl = 0 AND (l_ic_item_mst_rec.loct_ctl = 0) )
736: THEN
737: PrintMsg('ERROR - No Controls item :'|| l_ic_item_mst_rec.item_no);
738: l_error_flag := FND_API.G_TRUE;
739: FND_MESSAGE.SET_NAME('GMI','GMI_API_NO_CONTROL_ITEM');
740: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
741: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
742: FND_MSG_PUB.Add;
743: RAISE FND_API.G_EXC_ERROR;

Line 740: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);

736: THEN
737: PrintMsg('ERROR - No Controls item :'|| l_ic_item_mst_rec.item_no);
738: l_error_flag := FND_API.G_TRUE;
739: FND_MESSAGE.SET_NAME('GMI','GMI_API_NO_CONTROL_ITEM');
740: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
741: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
742: FND_MSG_PUB.Add;
743: RAISE FND_API.G_EXC_ERROR;
744:

Line 741: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);

737: PrintMsg('ERROR - No Controls item :'|| l_ic_item_mst_rec.item_no);
738: l_error_flag := FND_API.G_TRUE;
739: FND_MESSAGE.SET_NAME('GMI','GMI_API_NO_CONTROL_ITEM');
740: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
741: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
742: FND_MSG_PUB.Add;
743: RAISE FND_API.G_EXC_ERROR;
744:
745: END IF;

Line 768: FND_MESSAGE.SET_NAME('GMI','GMI_API_NOT_LOT_CONTROL_ITEM');

764: THEN
765: PrintMsg('ERROR - lot is specified but item is
766: not lot controlled'|| l_ic_item_mst_rec.item_no);
767: l_error_flag := FND_API.G_TRUE;
768: FND_MESSAGE.SET_NAME('GMI','GMI_API_NOT_LOT_CONTROL_ITEM');
769: FND_MESSAGE.SET_TOKEN('ITEM_NO_',l_ic_item_mst_rec.item_no);
770: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
771: FND_MSG_PUB.Add;
772: RAISE FND_API.G_EXC_ERROR;

Line 769: FND_MESSAGE.SET_TOKEN('ITEM_NO_',l_ic_item_mst_rec.item_no);

765: PrintMsg('ERROR - lot is specified but item is
766: not lot controlled'|| l_ic_item_mst_rec.item_no);
767: l_error_flag := FND_API.G_TRUE;
768: FND_MESSAGE.SET_NAME('GMI','GMI_API_NOT_LOT_CONTROL_ITEM');
769: FND_MESSAGE.SET_TOKEN('ITEM_NO_',l_ic_item_mst_rec.item_no);
770: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
771: FND_MSG_PUB.Add;
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;

Line 770: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);

766: not lot controlled'|| l_ic_item_mst_rec.item_no);
767: l_error_flag := FND_API.G_TRUE;
768: FND_MESSAGE.SET_NAME('GMI','GMI_API_NOT_LOT_CONTROL_ITEM');
769: FND_MESSAGE.SET_TOKEN('ITEM_NO_',l_ic_item_mst_rec.item_no);
770: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
771: FND_MSG_PUB.Add;
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774:

Line 781: FND_MESSAGE.SET_NAME('GMI','GMI_API_SUBLOT_NOT_REQUIRED');

777: THEN
778: PrintMsg('ERROR - sublot is specified but item is not sublot controlled , Item_no : '||
779: l_ic_item_mst_rec.item_no ||' Sublot_no : '|| p_tran_rec.sublot_no);
780: l_error_flag := FND_API.G_TRUE;
781: FND_MESSAGE.SET_NAME('GMI','GMI_API_SUBLOT_NOT_REQUIRED');
782: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_ic_item_mst_rec.item_no);
783: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
784: FND_MSG_PUB.Add;
785: RAISE FND_API.G_EXC_ERROR;

Line 782: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_ic_item_mst_rec.item_no);

778: PrintMsg('ERROR - sublot is specified but item is not sublot controlled , Item_no : '||
779: l_ic_item_mst_rec.item_no ||' Sublot_no : '|| p_tran_rec.sublot_no);
780: l_error_flag := FND_API.G_TRUE;
781: FND_MESSAGE.SET_NAME('GMI','GMI_API_SUBLOT_NOT_REQUIRED');
782: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_ic_item_mst_rec.item_no);
783: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
784: FND_MSG_PUB.Add;
785: RAISE FND_API.G_EXC_ERROR;
786: END IF;

Line 783: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);

779: l_ic_item_mst_rec.item_no ||' Sublot_no : '|| p_tran_rec.sublot_no);
780: l_error_flag := FND_API.G_TRUE;
781: FND_MESSAGE.SET_NAME('GMI','GMI_API_SUBLOT_NOT_REQUIRED');
782: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_ic_item_mst_rec.item_no);
783: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
784: FND_MSG_PUB.Add;
785: RAISE FND_API.G_EXC_ERROR;
786: END IF;
787:

Line 804: FND_MESSAGE.SET_NAME('GMI','GMI_API_NON_LOCT_CTL_ITEM_WHSE');

800: THEN
801: PrintMsg('location is specified but either the item or the warehouse not location controlled :'
802: || l_ic_item_mst_rec.item_no);
803: l_error_flag := FND_API.G_TRUE;
804: FND_MESSAGE.SET_NAME('GMI','GMI_API_NON_LOCT_CTL_ITEM_WHSE');
805: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
806: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);
807: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
808: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);

Line 805: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);

801: PrintMsg('location is specified but either the item or the warehouse not location controlled :'
802: || l_ic_item_mst_rec.item_no);
803: l_error_flag := FND_API.G_TRUE;
804: FND_MESSAGE.SET_NAME('GMI','GMI_API_NON_LOCT_CTL_ITEM_WHSE');
805: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
806: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);
807: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
808: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
809: FND_MSG_PUB.Add;

Line 806: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);

802: || l_ic_item_mst_rec.item_no);
803: l_error_flag := FND_API.G_TRUE;
804: FND_MESSAGE.SET_NAME('GMI','GMI_API_NON_LOCT_CTL_ITEM_WHSE');
805: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
806: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);
807: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
808: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
809: FND_MSG_PUB.Add;
810: RAISE FND_API.G_EXC_ERROR;

Line 807: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);

803: l_error_flag := FND_API.G_TRUE;
804: FND_MESSAGE.SET_NAME('GMI','GMI_API_NON_LOCT_CTL_ITEM_WHSE');
805: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
806: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);
807: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
808: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
809: FND_MSG_PUB.Add;
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;

Line 808: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);

804: FND_MESSAGE.SET_NAME('GMI','GMI_API_NON_LOCT_CTL_ITEM_WHSE');
805: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
806: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);
807: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
808: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
809: FND_MSG_PUB.Add;
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;
812:

Line 821: FND_MESSAGE.SET_NAME('GMI','GMI_API_LOCATION_REQUIRED');

817: THEN
818: PrintMsg('location is NOT specified but item and warehouse are location controlled :'||
819: l_ic_item_mst_rec.item_no);
820: l_error_flag := FND_API.G_TRUE;
821: FND_MESSAGE.SET_NAME('GMI','GMI_API_LOCATION_REQUIRED');
822: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
823: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);
824: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
825: FND_MSG_PUB.Add;

Line 822: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);

818: PrintMsg('location is NOT specified but item and warehouse are location controlled :'||
819: l_ic_item_mst_rec.item_no);
820: l_error_flag := FND_API.G_TRUE;
821: FND_MESSAGE.SET_NAME('GMI','GMI_API_LOCATION_REQUIRED');
822: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
823: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);
824: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
825: FND_MSG_PUB.Add;
826: RAISE FND_API.G_EXC_ERROR;

Line 823: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);

819: l_ic_item_mst_rec.item_no);
820: l_error_flag := FND_API.G_TRUE;
821: FND_MESSAGE.SET_NAME('GMI','GMI_API_LOCATION_REQUIRED');
822: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
823: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);
824: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
825: FND_MSG_PUB.Add;
826: RAISE FND_API.G_EXC_ERROR;
827: END IF;

Line 824: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);

820: l_error_flag := FND_API.G_TRUE;
821: FND_MESSAGE.SET_NAME('GMI','GMI_API_LOCATION_REQUIRED');
822: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
823: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);
824: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
825: FND_MSG_PUB.Add;
826: RAISE FND_API.G_EXC_ERROR;
827: END IF;
828:

Line 840: FND_MESSAGE.SET_NAME('GMI','GMI_API_LOCT_INVALID_LENGTH');

836: THEN
837: PrintMsg('Non validated location length can not be > 16 : '||
838: l_ic_item_mst_rec.item_no);
839: l_error_flag := FND_API.G_TRUE;
840: FND_MESSAGE.SET_NAME('GMI','GMI_API_LOCT_INVALID_LENGTH');
841: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
842: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
843: FND_MSG_PUB.Add;
844: RAISE FND_API.G_EXC_ERROR;

Line 841: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);

837: PrintMsg('Non validated location length can not be > 16 : '||
838: l_ic_item_mst_rec.item_no);
839: l_error_flag := FND_API.G_TRUE;
840: FND_MESSAGE.SET_NAME('GMI','GMI_API_LOCT_INVALID_LENGTH');
841: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
842: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
843: FND_MSG_PUB.Add;
844: RAISE FND_API.G_EXC_ERROR;
845: END IF;

Line 842: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);

838: l_ic_item_mst_rec.item_no);
839: l_error_flag := FND_API.G_TRUE;
840: FND_MESSAGE.SET_NAME('GMI','GMI_API_LOCT_INVALID_LENGTH');
841: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
842: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
843: FND_MSG_PUB.Add;
844: RAISE FND_API.G_EXC_ERROR;
845: END IF;
846:

Line 862: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LOCATION');

858: THEN
859: close ic_loct_mst_cur;
860: PrintMsg('ic_loct_mst_cur%NOTFOUND - Location is not found : '|| l_tran_rec.location);
861: l_error_flag := FND_API.G_TRUE;
862: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LOCATION');
863: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
864: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
865: FND_MSG_PUB.Add;
866: RAISE FND_API.G_EXC_ERROR;

Line 863: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);

859: close ic_loct_mst_cur;
860: PrintMsg('ic_loct_mst_cur%NOTFOUND - Location is not found : '|| l_tran_rec.location);
861: l_error_flag := FND_API.G_TRUE;
862: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LOCATION');
863: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
864: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
865: FND_MSG_PUB.Add;
866: RAISE FND_API.G_EXC_ERROR;
867: END IF;

Line 864: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);

860: PrintMsg('ic_loct_mst_cur%NOTFOUND - Location is not found : '|| l_tran_rec.location);
861: l_error_flag := FND_API.G_TRUE;
862: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LOCATION');
863: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
864: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
865: FND_MSG_PUB.Add;
866: RAISE FND_API.G_EXC_ERROR;
867: END IF;
868:

Line 873: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_LOCATION');

869: IF (l_loc_inactive = 1)
870: THEN
871: PrintMsg('Location Specified is NOT Active : '|| l_tran_rec.location);
872: l_error_flag := FND_API.G_TRUE;
873: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_LOCATION');
874: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
875: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
876: FND_MSG_PUB.Add;
877: RAISE FND_API.G_EXC_ERROR;

Line 874: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);

870: THEN
871: PrintMsg('Location Specified is NOT Active : '|| l_tran_rec.location);
872: l_error_flag := FND_API.G_TRUE;
873: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_LOCATION');
874: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
875: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
876: FND_MSG_PUB.Add;
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;

Line 875: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);

871: PrintMsg('Location Specified is NOT Active : '|| l_tran_rec.location);
872: l_error_flag := FND_API.G_TRUE;
873: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_LOCATION');
874: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
875: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
876: FND_MSG_PUB.Add;
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;
879:

Line 909: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');

905: THEN
906: PrintMsg(' Get_Lot_Details failed, Lot_no :'||l_tran_rec.lot_no||
907: ' lot_id : '||l_tran_rec.lot_id);
908: l_error_flag := FND_API.G_TRUE;
909: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');
910: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
911: FND_MESSAGE.Set_Token('SUBLOT_NO', l_tran_rec.sublot_no);
912: FND_MESSAGE.Set_Token('LOT_ID', l_tran_rec.lot_id);
913: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);

Line 910: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);

906: PrintMsg(' Get_Lot_Details failed, Lot_no :'||l_tran_rec.lot_no||
907: ' lot_id : '||l_tran_rec.lot_id);
908: l_error_flag := FND_API.G_TRUE;
909: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');
910: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
911: FND_MESSAGE.Set_Token('SUBLOT_NO', l_tran_rec.sublot_no);
912: FND_MESSAGE.Set_Token('LOT_ID', l_tran_rec.lot_id);
913: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
914: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

Line 911: FND_MESSAGE.Set_Token('SUBLOT_NO', l_tran_rec.sublot_no);

907: ' lot_id : '||l_tran_rec.lot_id);
908: l_error_flag := FND_API.G_TRUE;
909: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');
910: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
911: FND_MESSAGE.Set_Token('SUBLOT_NO', l_tran_rec.sublot_no);
912: FND_MESSAGE.Set_Token('LOT_ID', l_tran_rec.lot_id);
913: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
914: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
915: FND_MSG_PUB.Add;

Line 912: FND_MESSAGE.Set_Token('LOT_ID', l_tran_rec.lot_id);

908: l_error_flag := FND_API.G_TRUE;
909: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');
910: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
911: FND_MESSAGE.Set_Token('SUBLOT_NO', l_tran_rec.sublot_no);
912: FND_MESSAGE.Set_Token('LOT_ID', l_tran_rec.lot_id);
913: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
914: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
915: FND_MSG_PUB.Add;
916: RAISE FND_API.G_EXC_ERROR;

Line 913: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);

909: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');
910: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
911: FND_MESSAGE.Set_Token('SUBLOT_NO', l_tran_rec.sublot_no);
912: FND_MESSAGE.Set_Token('LOT_ID', l_tran_rec.lot_id);
913: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
914: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
915: FND_MSG_PUB.Add;
916: RAISE FND_API.G_EXC_ERROR;
917: END IF;

Line 914: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

910: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
911: FND_MESSAGE.Set_Token('SUBLOT_NO', l_tran_rec.sublot_no);
912: FND_MESSAGE.Set_Token('LOT_ID', l_tran_rec.lot_id);
913: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
914: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
915: FND_MSG_PUB.Add;
916: RAISE FND_API.G_EXC_ERROR;
917: END IF;
918:

Line 927: FND_MESSAGE.Set_Name('GMI','GMI_API_INACTIVE_LOT');

923: THEN
924: PrintMsg(' ERROR : Lot is not active , Lot_no : '||l_tran_rec.lot_no||
925: ' lot_id : '||l_tran_rec.lot_id);
926: l_error_flag := FND_API.G_TRUE;
927: FND_MESSAGE.Set_Name('GMI','GMI_API_INACTIVE_LOT');
928: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
929: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
930: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
931: FND_MSG_PUB.Add;

Line 928: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);

924: PrintMsg(' ERROR : Lot is not active , Lot_no : '||l_tran_rec.lot_no||
925: ' lot_id : '||l_tran_rec.lot_id);
926: l_error_flag := FND_API.G_TRUE;
927: FND_MESSAGE.Set_Name('GMI','GMI_API_INACTIVE_LOT');
928: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
929: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
930: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
931: FND_MSG_PUB.Add;
932: RAISE FND_API.G_EXC_ERROR;

Line 929: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);

925: ' lot_id : '||l_tran_rec.lot_id);
926: l_error_flag := FND_API.G_TRUE;
927: FND_MESSAGE.Set_Name('GMI','GMI_API_INACTIVE_LOT');
928: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
929: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
930: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
931: FND_MSG_PUB.Add;
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;

Line 930: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

926: l_error_flag := FND_API.G_TRUE;
927: FND_MESSAGE.Set_Name('GMI','GMI_API_INACTIVE_LOT');
928: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
929: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
930: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
931: FND_MSG_PUB.Add;
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934:

Line 941: FND_MESSAGE.Set_Name('GMI','GMI_API_EXPIRED_LOT');

937: THEN
938: PrintMsg(' Lot is Expired , Lot_no '||l_tran_rec.lot_no||
939: ', lot_id : '||l_tran_rec.lot_id);
940: l_error_flag := FND_API.G_TRUE;
941: FND_MESSAGE.Set_Name('GMI','GMI_API_EXPIRED_LOT');
942: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
943: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
944: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
945: FND_MSG_PUB.Add;

Line 942: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);

938: PrintMsg(' Lot is Expired , Lot_no '||l_tran_rec.lot_no||
939: ', lot_id : '||l_tran_rec.lot_id);
940: l_error_flag := FND_API.G_TRUE;
941: FND_MESSAGE.Set_Name('GMI','GMI_API_EXPIRED_LOT');
942: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
943: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
944: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
945: FND_MSG_PUB.Add;
946: RAISE FND_API.G_EXC_ERROR;

Line 943: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);

939: ', lot_id : '||l_tran_rec.lot_id);
940: l_error_flag := FND_API.G_TRUE;
941: FND_MESSAGE.Set_Name('GMI','GMI_API_EXPIRED_LOT');
942: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
943: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
944: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
945: FND_MSG_PUB.Add;
946: RAISE FND_API.G_EXC_ERROR;
947: END IF;

Line 944: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

940: l_error_flag := FND_API.G_TRUE;
941: FND_MESSAGE.Set_Name('GMI','GMI_API_EXPIRED_LOT');
942: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
943: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
944: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
945: FND_MSG_PUB.Add;
946: RAISE FND_API.G_EXC_ERROR;
947: END IF;
948:

Line 955: FND_MESSAGE.Set_Name('GMI','GMI_API_DELETED_LOT');

951: THEN
952: PrintMsg(' Lot is Deleted , Lot_no '||l_tran_rec.lot_no||
953: 'lot_id : '||l_tran_rec.lot_id);
954: l_error_flag := FND_API.G_TRUE;
955: FND_MESSAGE.Set_Name('GMI','GMI_API_DELETED_LOT');
956: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
957: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
958: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
959: FND_MSG_PUB.Add;

Line 956: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);

952: PrintMsg(' Lot is Deleted , Lot_no '||l_tran_rec.lot_no||
953: 'lot_id : '||l_tran_rec.lot_id);
954: l_error_flag := FND_API.G_TRUE;
955: FND_MESSAGE.Set_Name('GMI','GMI_API_DELETED_LOT');
956: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
957: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
958: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
959: FND_MSG_PUB.Add;
960: RAISE FND_API.G_EXC_ERROR;

Line 957: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);

953: 'lot_id : '||l_tran_rec.lot_id);
954: l_error_flag := FND_API.G_TRUE;
955: FND_MESSAGE.Set_Name('GMI','GMI_API_DELETED_LOT');
956: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
957: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
958: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
959: FND_MSG_PUB.Add;
960: RAISE FND_API.G_EXC_ERROR;
961: END IF;

Line 958: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

954: l_error_flag := FND_API.G_TRUE;
955: FND_MESSAGE.Set_Name('GMI','GMI_API_DELETED_LOT');
956: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
957: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
958: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
959: FND_MSG_PUB.Add;
960: RAISE FND_API.G_EXC_ERROR;
961: END IF;
962:

Line 969: FND_MESSAGE.Set_Name('GMI','IC_INVALID_QC_GRADE');

965: IF( NVL(l_ic_item_mst_rec.grade_ctl, 0) > 0 AND l_ic_lots_mst_rec.qc_grade IS NULL)
966: THEN
967: PrintMsg(' GRADE for LOT '||l_tran_rec.lot_no ||' IS NOT VALID');
968: l_error_flag := FND_API.G_TRUE;
969: FND_MESSAGE.Set_Name('GMI','IC_INVALID_QC_GRADE');
970: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
971: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
972: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
973: FND_MSG_PUB.Add;

Line 970: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);

966: THEN
967: PrintMsg(' GRADE for LOT '||l_tran_rec.lot_no ||' IS NOT VALID');
968: l_error_flag := FND_API.G_TRUE;
969: FND_MESSAGE.Set_Name('GMI','IC_INVALID_QC_GRADE');
970: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
971: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
972: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
973: FND_MSG_PUB.Add;
974: RAISE FND_API.G_EXC_ERROR;

Line 971: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);

967: PrintMsg(' GRADE for LOT '||l_tran_rec.lot_no ||' IS NOT VALID');
968: l_error_flag := FND_API.G_TRUE;
969: FND_MESSAGE.Set_Name('GMI','IC_INVALID_QC_GRADE');
970: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
971: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
972: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
973: FND_MSG_PUB.Add;
974: RAISE FND_API.G_EXC_ERROR;
975: END IF;

Line 972: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

968: l_error_flag := FND_API.G_TRUE;
969: FND_MESSAGE.Set_Name('GMI','IC_INVALID_QC_GRADE');
970: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
971: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
972: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
973: FND_MSG_PUB.Add;
974: RAISE FND_API.G_EXC_ERROR;
975: END IF;
976: --END BUG 2966077

Line 1019: --FND_MESSAGE.Set_Name('GMI','GMI_API_NO_INVENTORY');

1015: THEN
1016: CLOSE get_loct_inv_dtls_cur2;
1017: PrintMsg('No inventory in ic_loct_inv for the item, whse,lot combination ');
1018: --l_error_flag := FND_API.G_TRUE;
1019: --FND_MESSAGE.Set_Name('GMI','GMI_API_NO_INVENTORY');
1020: --FND_MESSAGE.Set_Token('item_no', l_ic_item_mst_rec.item_no);
1021: --FND_MESSAGE.Set_Token('lot_no', l_tran_rec.lot_no);
1022: --FND_MSG_PUB.Add;
1023: --RAISE FND_API.G_EXC_ERROR;

Line 1020: --FND_MESSAGE.Set_Token('item_no', l_ic_item_mst_rec.item_no);

1016: CLOSE get_loct_inv_dtls_cur2;
1017: PrintMsg('No inventory in ic_loct_inv for the item, whse,lot combination ');
1018: --l_error_flag := FND_API.G_TRUE;
1019: --FND_MESSAGE.Set_Name('GMI','GMI_API_NO_INVENTORY');
1020: --FND_MESSAGE.Set_Token('item_no', l_ic_item_mst_rec.item_no);
1021: --FND_MESSAGE.Set_Token('lot_no', l_tran_rec.lot_no);
1022: --FND_MSG_PUB.Add;
1023: --RAISE FND_API.G_EXC_ERROR;
1024: ELSE

Line 1021: --FND_MESSAGE.Set_Token('lot_no', l_tran_rec.lot_no);

1017: PrintMsg('No inventory in ic_loct_inv for the item, whse,lot combination ');
1018: --l_error_flag := FND_API.G_TRUE;
1019: --FND_MESSAGE.Set_Name('GMI','GMI_API_NO_INVENTORY');
1020: --FND_MESSAGE.Set_Token('item_no', l_ic_item_mst_rec.item_no);
1021: --FND_MESSAGE.Set_Token('lot_no', l_tran_rec.lot_no);
1022: --FND_MSG_PUB.Add;
1023: --RAISE FND_API.G_EXC_ERROR;
1024: ELSE
1025: CLOSE get_loct_inv_dtls_cur2;

Line 1033: --FND_MESSAGE.Set_Name('GMI','GMI_API_NO_INVENTORY');

1029:
1030: CLOSE get_loct_inv_dtls_cur;
1031: PrintMsg('No inventory in ic_loct_inv for the item, whse,lot,location combination ');
1032: --l_error_flag := FND_API.G_TRUE;
1033: --FND_MESSAGE.Set_Name('GMI','GMI_API_NO_INVENTORY');
1034: --FND_MESSAGE.Set_Token('item_no', l_ic_item_mst_rec.item_no);
1035: --FND_MESSAGE.Set_Token('lot_no', l_tran_rec.lot_no);
1036: --FND_MSG_PUB.Add;
1037: --RAISE FND_API.G_EXC_ERROR;

Line 1034: --FND_MESSAGE.Set_Token('item_no', l_ic_item_mst_rec.item_no);

1030: CLOSE get_loct_inv_dtls_cur;
1031: PrintMsg('No inventory in ic_loct_inv for the item, whse,lot,location combination ');
1032: --l_error_flag := FND_API.G_TRUE;
1033: --FND_MESSAGE.Set_Name('GMI','GMI_API_NO_INVENTORY');
1034: --FND_MESSAGE.Set_Token('item_no', l_ic_item_mst_rec.item_no);
1035: --FND_MESSAGE.Set_Token('lot_no', l_tran_rec.lot_no);
1036: --FND_MSG_PUB.Add;
1037: --RAISE FND_API.G_EXC_ERROR;
1038: END IF;

Line 1035: --FND_MESSAGE.Set_Token('lot_no', l_tran_rec.lot_no);

1031: PrintMsg('No inventory in ic_loct_inv for the item, whse,lot,location combination ');
1032: --l_error_flag := FND_API.G_TRUE;
1033: --FND_MESSAGE.Set_Name('GMI','GMI_API_NO_INVENTORY');
1034: --FND_MESSAGE.Set_Token('item_no', l_ic_item_mst_rec.item_no);
1035: --FND_MESSAGE.Set_Token('lot_no', l_tran_rec.lot_no);
1036: --FND_MSG_PUB.Add;
1037: --RAISE FND_API.G_EXC_ERROR;
1038: END IF;
1039:

Line 1062: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_STATUS_NOT_FOUND');

1058: THEN
1059: CLOSE lot_status_cur;
1060: PrintMsg('ERROR - No row in ic_lots_sts');
1061: l_error_flag := FND_API.G_TRUE;
1062: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_STATUS_NOT_FOUND');
1063: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1064: FND_MESSAGE.Set_Token('LOT_STATUS', l_loct_inv_rec.lot_status);
1065: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1066: FND_MSG_PUB.Add;

Line 1063: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);

1059: CLOSE lot_status_cur;
1060: PrintMsg('ERROR - No row in ic_lots_sts');
1061: l_error_flag := FND_API.G_TRUE;
1062: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_STATUS_NOT_FOUND');
1063: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1064: FND_MESSAGE.Set_Token('LOT_STATUS', l_loct_inv_rec.lot_status);
1065: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1066: FND_MSG_PUB.Add;
1067: RAISE FND_API.G_EXC_ERROR;

Line 1064: FND_MESSAGE.Set_Token('LOT_STATUS', l_loct_inv_rec.lot_status);

1060: PrintMsg('ERROR - No row in ic_lots_sts');
1061: l_error_flag := FND_API.G_TRUE;
1062: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_STATUS_NOT_FOUND');
1063: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1064: FND_MESSAGE.Set_Token('LOT_STATUS', l_loct_inv_rec.lot_status);
1065: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1066: FND_MSG_PUB.Add;
1067: RAISE FND_API.G_EXC_ERROR;
1068:

Line 1065: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1061: l_error_flag := FND_API.G_TRUE;
1062: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_STATUS_NOT_FOUND');
1063: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1064: FND_MESSAGE.Set_Token('LOT_STATUS', l_loct_inv_rec.lot_status);
1065: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1066: FND_MSG_PUB.Add;
1067: RAISE FND_API.G_EXC_ERROR;
1068:
1069: ELSE

Line 1077: FND_MESSAGE.SET_NAME('GMI','GMI_API_REJECTED_LOT');

1073: IF( l_lot_status_rec.rejected_ind = 1 )
1074: THEN
1075: PrintMsg('Rejected ind is 1 - unusable lot'|| l_ic_lots_mst_rec.lot_no);
1076: l_error_flag := FND_API.G_TRUE;
1077: FND_MESSAGE.SET_NAME('GMI','GMI_API_REJECTED_LOT');
1078: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1079: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1080: FND_MSG_PUB.Add;
1081: RAISE FND_API.G_EXC_ERROR;

Line 1078: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);

1074: THEN
1075: PrintMsg('Rejected ind is 1 - unusable lot'|| l_ic_lots_mst_rec.lot_no);
1076: l_error_flag := FND_API.G_TRUE;
1077: FND_MESSAGE.SET_NAME('GMI','GMI_API_REJECTED_LOT');
1078: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1079: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1080: FND_MSG_PUB.Add;
1081: RAISE FND_API.G_EXC_ERROR;
1082:

Line 1079: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1075: PrintMsg('Rejected ind is 1 - unusable lot'|| l_ic_lots_mst_rec.lot_no);
1076: l_error_flag := FND_API.G_TRUE;
1077: FND_MESSAGE.SET_NAME('GMI','GMI_API_REJECTED_LOT');
1078: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1079: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1080: FND_MSG_PUB.Add;
1081: RAISE FND_API.G_EXC_ERROR;
1082:
1083: END IF;

Line 1089: FND_MESSAGE.SET_NAME('GMI', 'GMI_API_LOT_NOT_ORDERABLE');

1085: IF(l_lot_status_rec.order_proc_ind = 0)
1086: THEN
1087: PrintMsg('Order_proc_ind is 0 - unusable lot'|| l_ic_lots_mst_rec.lot_no);
1088: l_error_flag := FND_API.G_TRUE;
1089: FND_MESSAGE.SET_NAME('GMI', 'GMI_API_LOT_NOT_ORDERABLE');
1090: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1091: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1092: FND_MSG_PUB.Add;
1093: RAISE FND_API.G_EXC_ERROR;

Line 1090: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);

1086: THEN
1087: PrintMsg('Order_proc_ind is 0 - unusable lot'|| l_ic_lots_mst_rec.lot_no);
1088: l_error_flag := FND_API.G_TRUE;
1089: FND_MESSAGE.SET_NAME('GMI', 'GMI_API_LOT_NOT_ORDERABLE');
1090: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1091: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1092: FND_MSG_PUB.Add;
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;

Line 1091: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1087: PrintMsg('Order_proc_ind is 0 - unusable lot'|| l_ic_lots_mst_rec.lot_no);
1088: l_error_flag := FND_API.G_TRUE;
1089: FND_MESSAGE.SET_NAME('GMI', 'GMI_API_LOT_NOT_ORDERABLE');
1090: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1091: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1092: FND_MSG_PUB.Add;
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095:

Line 1100: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_NETTABLE');

1096: IF(l_lot_status_rec.nettable_ind <> 1)
1097: THEN
1098: PrintMsg('Lot is not Nettable Lot_no :'||l_ic_lots_mst_rec.lot_no);
1099: l_error_flag := FND_API.G_TRUE;
1100: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_NETTABLE');
1101: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1102: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1103: FND_MSG_PUB.Add;
1104: RAISE FND_API.G_EXC_ERROR;

Line 1101: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);

1097: THEN
1098: PrintMsg('Lot is not Nettable Lot_no :'||l_ic_lots_mst_rec.lot_no);
1099: l_error_flag := FND_API.G_TRUE;
1100: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_NETTABLE');
1101: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1102: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1103: FND_MSG_PUB.Add;
1104: RAISE FND_API.G_EXC_ERROR;
1105: END IF;

Line 1102: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1098: PrintMsg('Lot is not Nettable Lot_no :'||l_ic_lots_mst_rec.lot_no);
1099: l_error_flag := FND_API.G_TRUE;
1100: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_NETTABLE');
1101: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1102: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1103: FND_MSG_PUB.Add;
1104: RAISE FND_API.G_EXC_ERROR;
1105: END IF;
1106:

Line 1132: FND_MESSAGE.Set_Name('GMI','GMI_API_UOM_REQUIRED');

1128: IF ( NVL(l_tran_rec.trans_um,' ') = ' ')
1129: THEN
1130: PrintMsg('ERROR - Trans_um is not passed ');
1131: l_error_flag := FND_API.G_TRUE;
1132: FND_MESSAGE.Set_Name('GMI','GMI_API_UOM_REQUIRED');
1133: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1134: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1135: FND_MSG_PUB.Add;
1136: RAISE FND_API.G_EXC_ERROR;

Line 1133: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);

1129: THEN
1130: PrintMsg('ERROR - Trans_um is not passed ');
1131: l_error_flag := FND_API.G_TRUE;
1132: FND_MESSAGE.Set_Name('GMI','GMI_API_UOM_REQUIRED');
1133: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1134: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1135: FND_MSG_PUB.Add;
1136: RAISE FND_API.G_EXC_ERROR;
1137:

Line 1134: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1130: PrintMsg('ERROR - Trans_um is not passed ');
1131: l_error_flag := FND_API.G_TRUE;
1132: FND_MESSAGE.Set_Name('GMI','GMI_API_UOM_REQUIRED');
1133: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1134: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1135: FND_MSG_PUB.Add;
1136: RAISE FND_API.G_EXC_ERROR;
1137:
1138: ELSE /* l_tran_rec.trans_um is NOT NULL */

Line 1151: FND_MESSAGE.Set_Name('GMI','GMI_API_APPS_UOM_NOT_FOUND');

1147: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1148: THEN
1149: PrintMsg('ERROR - uom conversion does not exist for: '||l_ic_item_mst_rec.item_um);
1150: l_error_flag := FND_API.G_TRUE;
1151: FND_MESSAGE.Set_Name('GMI','GMI_API_APPS_UOM_NOT_FOUND');
1152: FND_MESSAGE.Set_Token('OPM_UOM',l_ic_item_mst_rec.item_um);
1153: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1154: FND_MSG_PUB.Add;
1155: RAISE FND_API.G_EXC_ERROR;

Line 1152: FND_MESSAGE.Set_Token('OPM_UOM',l_ic_item_mst_rec.item_um);

1148: THEN
1149: PrintMsg('ERROR - uom conversion does not exist for: '||l_ic_item_mst_rec.item_um);
1150: l_error_flag := FND_API.G_TRUE;
1151: FND_MESSAGE.Set_Name('GMI','GMI_API_APPS_UOM_NOT_FOUND');
1152: FND_MESSAGE.Set_Token('OPM_UOM',l_ic_item_mst_rec.item_um);
1153: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1154: FND_MSG_PUB.Add;
1155: RAISE FND_API.G_EXC_ERROR;
1156: END IF;

Line 1153: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1149: PrintMsg('ERROR - uom conversion does not exist for: '||l_ic_item_mst_rec.item_um);
1150: l_error_flag := FND_API.G_TRUE;
1151: FND_MESSAGE.Set_Name('GMI','GMI_API_APPS_UOM_NOT_FOUND');
1152: FND_MESSAGE.Set_Token('OPM_UOM',l_ic_item_mst_rec.item_um);
1153: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1154: FND_MSG_PUB.Add;
1155: RAISE FND_API.G_EXC_ERROR;
1156: END IF;
1157:

Line 1172: FND_MESSAGE.Set_Name('GMI','GMI_API_OPM_UOM_NOT_FOUND');

1168:
1169: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1170: PrintMsg('ERROR: OPM UOM not found for apps uom : '|| l_tran_rec.trans_um);
1171: l_error_flag := FND_API.G_TRUE;
1172: FND_MESSAGE.Set_Name('GMI','GMI_API_OPM_UOM_NOT_FOUND');
1173: FND_MESSAGE.Set_Token('APPS_UOM', l_tran_rec.trans_um);
1174: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1175: FND_MSG_PUB.Add;
1176: RAISE FND_API.G_EXC_ERROR;

Line 1173: FND_MESSAGE.Set_Token('APPS_UOM', l_tran_rec.trans_um);

1169: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1170: PrintMsg('ERROR: OPM UOM not found for apps uom : '|| l_tran_rec.trans_um);
1171: l_error_flag := FND_API.G_TRUE;
1172: FND_MESSAGE.Set_Name('GMI','GMI_API_OPM_UOM_NOT_FOUND');
1173: FND_MESSAGE.Set_Token('APPS_UOM', l_tran_rec.trans_um);
1174: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1175: FND_MSG_PUB.Add;
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;

Line 1174: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1170: PrintMsg('ERROR: OPM UOM not found for apps uom : '|| l_tran_rec.trans_um);
1171: l_error_flag := FND_API.G_TRUE;
1172: FND_MESSAGE.Set_Name('GMI','GMI_API_OPM_UOM_NOT_FOUND');
1173: FND_MESSAGE.Set_Token('APPS_UOM', l_tran_rec.trans_um);
1174: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1175: FND_MSG_PUB.Add;
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;
1178: PrintMsg('to uom (OPM) '||l_opm_um);

Line 1201: FND_MESSAGE.Set_Name('GMI','GMI_API_UOM_CONV_NOT_FOUND');

1197: --IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1198: THEN
1199: PrintMsg('ERROR - from GMICUOM.icuomcv, pcur_uom : ' || l_opm_um || 'pnew_uom : '||l_ic_item_mst_rec.item_um);
1200: l_error_flag := FND_API.G_TRUE;
1201: FND_MESSAGE.Set_Name('GMI','GMI_API_UOM_CONV_NOT_FOUND');
1202: FND_MESSAGE.Set_Token('FROM_UOM', l_opm_um);
1203: FND_MESSAGE.Set_Token('TO_UOM', l_ic_item_mst_rec.item_um);
1204: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1205: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

Line 1202: FND_MESSAGE.Set_Token('FROM_UOM', l_opm_um);

1198: THEN
1199: PrintMsg('ERROR - from GMICUOM.icuomcv, pcur_uom : ' || l_opm_um || 'pnew_uom : '||l_ic_item_mst_rec.item_um);
1200: l_error_flag := FND_API.G_TRUE;
1201: FND_MESSAGE.Set_Name('GMI','GMI_API_UOM_CONV_NOT_FOUND');
1202: FND_MESSAGE.Set_Token('FROM_UOM', l_opm_um);
1203: FND_MESSAGE.Set_Token('TO_UOM', l_ic_item_mst_rec.item_um);
1204: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1205: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1206: FND_MSG_PUB.Add;

Line 1203: FND_MESSAGE.Set_Token('TO_UOM', l_ic_item_mst_rec.item_um);

1199: PrintMsg('ERROR - from GMICUOM.icuomcv, pcur_uom : ' || l_opm_um || 'pnew_uom : '||l_ic_item_mst_rec.item_um);
1200: l_error_flag := FND_API.G_TRUE;
1201: FND_MESSAGE.Set_Name('GMI','GMI_API_UOM_CONV_NOT_FOUND');
1202: FND_MESSAGE.Set_Token('FROM_UOM', l_opm_um);
1203: FND_MESSAGE.Set_Token('TO_UOM', l_ic_item_mst_rec.item_um);
1204: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1205: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1206: FND_MSG_PUB.Add;
1207: RAISE FND_API.G_EXC_ERROR;

Line 1204: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);

1200: l_error_flag := FND_API.G_TRUE;
1201: FND_MESSAGE.Set_Name('GMI','GMI_API_UOM_CONV_NOT_FOUND');
1202: FND_MESSAGE.Set_Token('FROM_UOM', l_opm_um);
1203: FND_MESSAGE.Set_Token('TO_UOM', l_ic_item_mst_rec.item_um);
1204: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1205: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1206: FND_MSG_PUB.Add;
1207: RAISE FND_API.G_EXC_ERROR;
1208:

Line 1205: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1201: FND_MESSAGE.Set_Name('GMI','GMI_API_UOM_CONV_NOT_FOUND');
1202: FND_MESSAGE.Set_Token('FROM_UOM', l_opm_um);
1203: FND_MESSAGE.Set_Token('TO_UOM', l_ic_item_mst_rec.item_um);
1204: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1205: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1206: FND_MSG_PUB.Add;
1207: RAISE FND_API.G_EXC_ERROR;
1208:
1209: ELSE

Line 1264: FND_MESSAGE.Set_Name('GMI','GMI_API_QTY2_REQUIRED_DUAL3');

1260: THEN
1261: PrintMsg('ERROR - Trans_qty2 for a dual3 item Can not be NULL. Please provide
1262: a valid trans_qty2 ');
1263: l_error_flag := FND_API.G_TRUE;
1264: FND_MESSAGE.Set_Name('GMI','GMI_API_QTY2_REQUIRED_DUAL3');
1265: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1266: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1267: FND_MSG_PUB.Add;
1268: RAISE FND_API.G_EXC_ERROR;

Line 1265: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);

1261: PrintMsg('ERROR - Trans_qty2 for a dual3 item Can not be NULL. Please provide
1262: a valid trans_qty2 ');
1263: l_error_flag := FND_API.G_TRUE;
1264: FND_MESSAGE.Set_Name('GMI','GMI_API_QTY2_REQUIRED_DUAL3');
1265: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1266: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1267: FND_MSG_PUB.Add;
1268: RAISE FND_API.G_EXC_ERROR;
1269: END IF;

Line 1266: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1262: a valid trans_qty2 ');
1263: l_error_flag := FND_API.G_TRUE;
1264: FND_MESSAGE.Set_Name('GMI','GMI_API_QTY2_REQUIRED_DUAL3');
1265: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1266: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1267: FND_MSG_PUB.Add;
1268: RAISE FND_API.G_EXC_ERROR;
1269: END IF;
1270:

Line 1277: FND_MESSAGE.SET_NAME('GMI','GMI_API_DEVIATION_ERR');

1273: IF (nvl(l_ic_item_mst_rec.deviation_hi,0) <> 0 AND
1274: l_tran_rec.trans_qty2 > l_tmp_qty2 *(1 + l_ic_item_mst_rec.deviation_hi)) THEN
1275: PrintMsg('ERROR - Trans_qty2 Deviation Hi error ');
1276: l_error_flag := FND_API.G_TRUE;
1277: FND_MESSAGE.SET_NAME('GMI','GMI_API_DEVIATION_ERR');
1278: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1279: FND_MESSAGE.Set_Token('QTY', l_pick_lots_rec.trans_qty);
1280: FND_MESSAGE.Set_Token('QTY2', l_tran_rec.trans_qty2);
1281: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

Line 1278: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);

1274: l_tran_rec.trans_qty2 > l_tmp_qty2 *(1 + l_ic_item_mst_rec.deviation_hi)) THEN
1275: PrintMsg('ERROR - Trans_qty2 Deviation Hi error ');
1276: l_error_flag := FND_API.G_TRUE;
1277: FND_MESSAGE.SET_NAME('GMI','GMI_API_DEVIATION_ERR');
1278: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1279: FND_MESSAGE.Set_Token('QTY', l_pick_lots_rec.trans_qty);
1280: FND_MESSAGE.Set_Token('QTY2', l_tran_rec.trans_qty2);
1281: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1282: FND_MSG_PUB.Add;

Line 1279: FND_MESSAGE.Set_Token('QTY', l_pick_lots_rec.trans_qty);

1275: PrintMsg('ERROR - Trans_qty2 Deviation Hi error ');
1276: l_error_flag := FND_API.G_TRUE;
1277: FND_MESSAGE.SET_NAME('GMI','GMI_API_DEVIATION_ERR');
1278: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1279: FND_MESSAGE.Set_Token('QTY', l_pick_lots_rec.trans_qty);
1280: FND_MESSAGE.Set_Token('QTY2', l_tran_rec.trans_qty2);
1281: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1282: FND_MSG_PUB.Add;
1283: RAISE FND_API.G_EXC_ERROR;

Line 1280: FND_MESSAGE.Set_Token('QTY2', l_tran_rec.trans_qty2);

1276: l_error_flag := FND_API.G_TRUE;
1277: FND_MESSAGE.SET_NAME('GMI','GMI_API_DEVIATION_ERR');
1278: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1279: FND_MESSAGE.Set_Token('QTY', l_pick_lots_rec.trans_qty);
1280: FND_MESSAGE.Set_Token('QTY2', l_tran_rec.trans_qty2);
1281: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1282: FND_MSG_PUB.Add;
1283: RAISE FND_API.G_EXC_ERROR;
1284:

Line 1281: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1277: FND_MESSAGE.SET_NAME('GMI','GMI_API_DEVIATION_ERR');
1278: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1279: FND_MESSAGE.Set_Token('QTY', l_pick_lots_rec.trans_qty);
1280: FND_MESSAGE.Set_Token('QTY2', l_tran_rec.trans_qty2);
1281: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1282: FND_MSG_PUB.Add;
1283: RAISE FND_API.G_EXC_ERROR;
1284:
1285: ELSIF (nvl(l_ic_item_mst_rec.deviation_lo,0)<>0 AND

Line 1289: FND_MESSAGE.SET_NAME('GMI','GMI_API_DEVIATION_ERR');

1285: ELSIF (nvl(l_ic_item_mst_rec.deviation_lo,0)<>0 AND
1286: l_tran_rec.trans_qty2 < l_tmp_qty2 * (1-l_ic_item_mst_rec.deviation_lo)) THEN
1287: PrintMsg('ERROR - Trans_qty2 Deviation Lo error ');
1288: l_error_flag := FND_API.G_TRUE;
1289: FND_MESSAGE.SET_NAME('GMI','GMI_API_DEVIATION_ERR');
1290: FND_MESSAGE.Set_Token('QTY', l_pick_lots_rec.trans_qty);
1291: FND_MESSAGE.Set_Token('QTY2', l_tran_rec.trans_qty2);
1292: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1293: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

Line 1290: FND_MESSAGE.Set_Token('QTY', l_pick_lots_rec.trans_qty);

1286: l_tran_rec.trans_qty2 < l_tmp_qty2 * (1-l_ic_item_mst_rec.deviation_lo)) THEN
1287: PrintMsg('ERROR - Trans_qty2 Deviation Lo error ');
1288: l_error_flag := FND_API.G_TRUE;
1289: FND_MESSAGE.SET_NAME('GMI','GMI_API_DEVIATION_ERR');
1290: FND_MESSAGE.Set_Token('QTY', l_pick_lots_rec.trans_qty);
1291: FND_MESSAGE.Set_Token('QTY2', l_tran_rec.trans_qty2);
1292: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1293: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1294: FND_MSG_PUB.Add;

Line 1291: FND_MESSAGE.Set_Token('QTY2', l_tran_rec.trans_qty2);

1287: PrintMsg('ERROR - Trans_qty2 Deviation Lo error ');
1288: l_error_flag := FND_API.G_TRUE;
1289: FND_MESSAGE.SET_NAME('GMI','GMI_API_DEVIATION_ERR');
1290: FND_MESSAGE.Set_Token('QTY', l_pick_lots_rec.trans_qty);
1291: FND_MESSAGE.Set_Token('QTY2', l_tran_rec.trans_qty2);
1292: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1293: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1294: FND_MSG_PUB.Add;
1295: RAISE FND_API.G_EXC_ERROR;

Line 1292: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);

1288: l_error_flag := FND_API.G_TRUE;
1289: FND_MESSAGE.SET_NAME('GMI','GMI_API_DEVIATION_ERR');
1290: FND_MESSAGE.Set_Token('QTY', l_pick_lots_rec.trans_qty);
1291: FND_MESSAGE.Set_Token('QTY2', l_tran_rec.trans_qty2);
1292: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1293: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1294: FND_MSG_PUB.Add;
1295: RAISE FND_API.G_EXC_ERROR;
1296:

Line 1293: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1289: FND_MESSAGE.SET_NAME('GMI','GMI_API_DEVIATION_ERR');
1290: FND_MESSAGE.Set_Token('QTY', l_pick_lots_rec.trans_qty);
1291: FND_MESSAGE.Set_Token('QTY2', l_tran_rec.trans_qty2);
1292: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1293: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1294: FND_MSG_PUB.Add;
1295: RAISE FND_API.G_EXC_ERROR;
1296:
1297: END IF;

Line 1318: FND_MESSAGE.Set_Name('GMI','GMI_API_QTY_REQ_FOR_ACT_CODE');

1314: IF( NVL(l_tran_rec.trans_qty,0) <= 0 )
1315: THEN
1316: PrintMsg('ERROR - trans_qty Has to be > 0 For actions INSERT and Update ');
1317: l_error_flag := FND_API.G_TRUE;
1318: FND_MESSAGE.Set_Name('GMI','GMI_API_QTY_REQ_FOR_ACT_CODE');
1319: FND_MESSAGE.Set_Token('ACTION_CODE', l_tran_rec.action_code);
1320: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1321: FND_MSG_PUB.Add;
1322: RAISE FND_API.G_EXC_ERROR;

Line 1319: FND_MESSAGE.Set_Token('ACTION_CODE', l_tran_rec.action_code);

1315: THEN
1316: PrintMsg('ERROR - trans_qty Has to be > 0 For actions INSERT and Update ');
1317: l_error_flag := FND_API.G_TRUE;
1318: FND_MESSAGE.Set_Name('GMI','GMI_API_QTY_REQ_FOR_ACT_CODE');
1319: FND_MESSAGE.Set_Token('ACTION_CODE', l_tran_rec.action_code);
1320: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1321: FND_MSG_PUB.Add;
1322: RAISE FND_API.G_EXC_ERROR;
1323: END IF;

Line 1320: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1316: PrintMsg('ERROR - trans_qty Has to be > 0 For actions INSERT and Update ');
1317: l_error_flag := FND_API.G_TRUE;
1318: FND_MESSAGE.Set_Name('GMI','GMI_API_QTY_REQ_FOR_ACT_CODE');
1319: FND_MESSAGE.Set_Token('ACTION_CODE', l_tran_rec.action_code);
1320: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1321: FND_MSG_PUB.Add;
1322: RAISE FND_API.G_EXC_ERROR;
1323: END IF;
1324:

Line 1361: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVQTYNEG');

1357: THEN
1358: IF(l_allow_negative_inv = 0) THEN
1359: PrintMsg('ERROR - -ve inventory is not allowed. This allocation would drive the inventory -ve. ');
1360: l_error_flag := FND_API.G_TRUE;
1361: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVQTYNEG');
1362: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1363: FND_MSG_PUB.Add;
1364: RAISE FND_API.G_EXC_ERROR;
1365:

Line 1362: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1358: IF(l_allow_negative_inv = 0) THEN
1359: PrintMsg('ERROR - -ve inventory is not allowed. This allocation would drive the inventory -ve. ');
1360: l_error_flag := FND_API.G_TRUE;
1361: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVQTYNEG');
1362: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1363: FND_MSG_PUB.Add;
1364: RAISE FND_API.G_EXC_ERROR;
1365:
1366: ELSIF(l_allow_negative_inv = 2) THEN

Line 1368: FND_MESSAGE.SET_NAME('GMI','GMI_API_WARNINVQTYNEG');

1364: RAISE FND_API.G_EXC_ERROR;
1365:
1366: ELSIF(l_allow_negative_inv = 2) THEN
1367: PrintMsg('Warning - This allocation would drive the inventory -ve. ');
1368: FND_MESSAGE.SET_NAME('GMI','GMI_API_WARNINVQTYNEG');
1369: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1370: FND_MSG_PUB.Add;
1371: END IF;
1372: END IF;

Line 1369: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1365:
1366: ELSIF(l_allow_negative_inv = 2) THEN
1367: PrintMsg('Warning - This allocation would drive the inventory -ve. ');
1368: FND_MESSAGE.SET_NAME('GMI','GMI_API_WARNINVQTYNEG');
1369: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1370: FND_MSG_PUB.Add;
1371: END IF;
1372: END IF;
1373: END IF; /* Check -ve inventory */

Line 1454: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_INDIV_NO_OVEPIC');

1450: ELSE /* Over Picking is not enabled and the lot is indivisible. so error */
1451: PrintMsg('ERROR - lot is indivisible. trans_qty is less than
1452: available qty and over picking is not enabled');
1453: l_error_flag := FND_API.G_TRUE;
1454: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_INDIV_NO_OVEPIC');
1455: FND_MESSAGE.Set_Token('LOT_NO', l_ic_lots_mst_rec.lot_no);
1456: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1457: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1458: FND_MSG_PUB.Add;

Line 1455: FND_MESSAGE.Set_Token('LOT_NO', l_ic_lots_mst_rec.lot_no);

1451: PrintMsg('ERROR - lot is indivisible. trans_qty is less than
1452: available qty and over picking is not enabled');
1453: l_error_flag := FND_API.G_TRUE;
1454: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_INDIV_NO_OVEPIC');
1455: FND_MESSAGE.Set_Token('LOT_NO', l_ic_lots_mst_rec.lot_no);
1456: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1457: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1458: FND_MSG_PUB.Add;
1459: RAISE FND_API.G_EXC_ERROR;

Line 1456: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);

1452: available qty and over picking is not enabled');
1453: l_error_flag := FND_API.G_TRUE;
1454: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_INDIV_NO_OVEPIC');
1455: FND_MESSAGE.Set_Token('LOT_NO', l_ic_lots_mst_rec.lot_no);
1456: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1457: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1458: FND_MSG_PUB.Add;
1459: RAISE FND_API.G_EXC_ERROR;
1460:

Line 1457: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1453: l_error_flag := FND_API.G_TRUE;
1454: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_INDIV_NO_OVEPIC');
1455: FND_MESSAGE.Set_Token('LOT_NO', l_ic_lots_mst_rec.lot_no);
1456: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1457: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1458: FND_MSG_PUB.Add;
1459: RAISE FND_API.G_EXC_ERROR;
1460:
1461: END IF;

Line 1531: FND_MESSAGE.Set_Name('GMI','GMI_API_OPM_UOM_NOT_FOUND');

1527:
1528: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1529: PrintMsg('ERROR: OPM UOM not found for apps uom : '|| l_ordered_quantity_uom);
1530: l_error_flag := FND_API.G_TRUE;
1531: FND_MESSAGE.Set_Name('GMI','GMI_API_OPM_UOM_NOT_FOUND');
1532: FND_MESSAGE.Set_Token('APPS_UOM', l_ordered_quantity_uom);
1533: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1534: FND_MSG_PUB.Add;
1535: RAISE FND_API.G_EXC_ERROR;

Line 1532: FND_MESSAGE.Set_Token('APPS_UOM', l_ordered_quantity_uom);

1528: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1529: PrintMsg('ERROR: OPM UOM not found for apps uom : '|| l_ordered_quantity_uom);
1530: l_error_flag := FND_API.G_TRUE;
1531: FND_MESSAGE.Set_Name('GMI','GMI_API_OPM_UOM_NOT_FOUND');
1532: FND_MESSAGE.Set_Token('APPS_UOM', l_ordered_quantity_uom);
1533: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1534: FND_MSG_PUB.Add;
1535: RAISE FND_API.G_EXC_ERROR;
1536: END IF;

Line 1533: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1529: PrintMsg('ERROR: OPM UOM not found for apps uom : '|| l_ordered_quantity_uom);
1530: l_error_flag := FND_API.G_TRUE;
1531: FND_MESSAGE.Set_Name('GMI','GMI_API_OPM_UOM_NOT_FOUND');
1532: FND_MESSAGE.Set_Token('APPS_UOM', l_ordered_quantity_uom);
1533: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1534: FND_MSG_PUB.Add;
1535: RAISE FND_API.G_EXC_ERROR;
1536: END IF;
1537:

Line 1590: FND_MESSAGE.Set_Name('GMI','GMI_API_OVERPICK_NOT_ALLOWED');

1586: PrintMsg('picked_qty2 : '|| l_picked_qty2);
1587: PrintMsg(' ');
1588: PrintMsg('ERROR - Over picking is not enabled');
1589: l_error_flag := FND_API.G_TRUE;
1590: FND_MESSAGE.Set_Name('GMI','GMI_API_OVERPICK_NOT_ALLOWED');
1591: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1592: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1593: FND_MSG_PUB.Add;
1594: RAISE FND_API.G_EXC_ERROR;

Line 1591: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);

1587: PrintMsg(' ');
1588: PrintMsg('ERROR - Over picking is not enabled');
1589: l_error_flag := FND_API.G_TRUE;
1590: FND_MESSAGE.Set_Name('GMI','GMI_API_OVERPICK_NOT_ALLOWED');
1591: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1592: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1593: FND_MSG_PUB.Add;
1594: RAISE FND_API.G_EXC_ERROR;
1595: END IF;

Line 1592: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);

1588: PrintMsg('ERROR - Over picking is not enabled');
1589: l_error_flag := FND_API.G_TRUE;
1590: FND_MESSAGE.Set_Name('GMI','GMI_API_OVERPICK_NOT_ALLOWED');
1591: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1592: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1593: FND_MSG_PUB.Add;
1594: RAISE FND_API.G_EXC_ERROR;
1595: END IF;
1596:

Line 1631: FND_MESSAGE.SET_NAME('GMI','IC_CAL_FISCALYR_ERR');

1627:
1628: IF l_return_val <> 0 THEN
1629:
1630: IF l_return_val = GMICCAL.INVCAL_FISCALYR_ERR THEN
1631: FND_MESSAGE.SET_NAME('GMI','IC_CAL_FISCALYR_ERR');
1632: FND_MSG_PUB.Add;
1633: ELSIF l_return_val = GMICCAL.INVCAL_PERIOD_ERR THEN
1634: FND_MESSAGE.SET_NAME('GMI','IC_CAL_CLOSED_IND_ERR');
1635: FND_MSG_PUB.Add;

Line 1634: FND_MESSAGE.SET_NAME('GMI','IC_CAL_CLOSED_IND_ERR');

1630: IF l_return_val = GMICCAL.INVCAL_FISCALYR_ERR THEN
1631: FND_MESSAGE.SET_NAME('GMI','IC_CAL_FISCALYR_ERR');
1632: FND_MSG_PUB.Add;
1633: ELSIF l_return_val = GMICCAL.INVCAL_PERIOD_ERR THEN
1634: FND_MESSAGE.SET_NAME('GMI','IC_CAL_CLOSED_IND_ERR');
1635: FND_MSG_PUB.Add;
1636: ELSIF l_return_val = GMICCAL.INVCAL_ORGN_PARM_ERR THEN
1637: FND_MESSAGE.SET_NAME('GMI','IC_INVALID_ORGN_ERR');
1638: FND_MSG_PUB.Add;

Line 1637: FND_MESSAGE.SET_NAME('GMI','IC_INVALID_ORGN_ERR');

1633: ELSIF l_return_val = GMICCAL.INVCAL_PERIOD_ERR THEN
1634: FND_MESSAGE.SET_NAME('GMI','IC_CAL_CLOSED_IND_ERR');
1635: FND_MSG_PUB.Add;
1636: ELSIF l_return_val = GMICCAL.INVCAL_ORGN_PARM_ERR THEN
1637: FND_MESSAGE.SET_NAME('GMI','IC_INVALID_ORGN_ERR');
1638: FND_MSG_PUB.Add;
1639: ELSIF l_return_val = GMICCAL.INVCAL_CO_ERR THEN
1640: FND_MESSAGE.SET_NAME('GMI','IC_COCODEERR');
1641: FND_MSG_PUB.Add;

Line 1640: FND_MESSAGE.SET_NAME('GMI','IC_COCODEERR');

1636: ELSIF l_return_val = GMICCAL.INVCAL_ORGN_PARM_ERR THEN
1637: FND_MESSAGE.SET_NAME('GMI','IC_INVALID_ORGN_ERR');
1638: FND_MSG_PUB.Add;
1639: ELSIF l_return_val = GMICCAL.INVCAL_CO_ERR THEN
1640: FND_MESSAGE.SET_NAME('GMI','IC_COCODEERR');
1641: FND_MSG_PUB.Add;
1642: ELSIF l_return_val = GMICCAL.INVCAL_WHSE_PARM_ERR THEN
1643: FND_MESSAGE.SET_NAME('GMI','IC_BLANKWHSE');
1644: FND_MSG_PUB.Add;

Line 1643: FND_MESSAGE.SET_NAME('GMI','IC_BLANKWHSE');

1639: ELSIF l_return_val = GMICCAL.INVCAL_CO_ERR THEN
1640: FND_MESSAGE.SET_NAME('GMI','IC_COCODEERR');
1641: FND_MSG_PUB.Add;
1642: ELSIF l_return_val = GMICCAL.INVCAL_WHSE_PARM_ERR THEN
1643: FND_MESSAGE.SET_NAME('GMI','IC_BLANKWHSE');
1644: FND_MSG_PUB.Add;
1645: ELSIF l_return_val = GMICCAL.INVCAL_WHSE_ERR THEN
1646: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');
1647: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);

Line 1646: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');

1642: ELSIF l_return_val = GMICCAL.INVCAL_WHSE_PARM_ERR THEN
1643: FND_MESSAGE.SET_NAME('GMI','IC_BLANKWHSE');
1644: FND_MSG_PUB.Add;
1645: ELSIF l_return_val = GMICCAL.INVCAL_WHSE_ERR THEN
1646: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');
1647: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);
1648: FND_MSG_PUB.Add;
1649: ELSIF l_return_val IN (GMICCAL.INVCAL_PERIOD_CLOSED,
1650: GMICCAL.INVCAL_WHSE_CLOSED) THEN

Line 1647: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);

1643: FND_MESSAGE.SET_NAME('GMI','IC_BLANKWHSE');
1644: FND_MSG_PUB.Add;
1645: ELSIF l_return_val = GMICCAL.INVCAL_WHSE_ERR THEN
1646: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');
1647: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);
1648: FND_MSG_PUB.Add;
1649: ELSIF l_return_val IN (GMICCAL.INVCAL_PERIOD_CLOSED,
1650: GMICCAL.INVCAL_WHSE_CLOSED) THEN
1651:

Line 1652: FND_MESSAGE.SET_NAME('GMI','IC_API_TXN_POST_CLOSED');

1648: FND_MSG_PUB.Add;
1649: ELSIF l_return_val IN (GMICCAL.INVCAL_PERIOD_CLOSED,
1650: GMICCAL.INVCAL_WHSE_CLOSED) THEN
1651:
1652: FND_MESSAGE.SET_NAME('GMI','IC_API_TXN_POST_CLOSED');
1653: FND_MESSAGE.SET_TOKEN('DATE',l_tran_rec.trans_date);
1654: FND_MESSAGE.SET_TOKEN('WAREH',l_ic_whse_mst_rec.whse_code);
1655: FND_MSG_PUB.Add;
1656: ELSE

Line 1653: FND_MESSAGE.SET_TOKEN('DATE',l_tran_rec.trans_date);

1649: ELSIF l_return_val IN (GMICCAL.INVCAL_PERIOD_CLOSED,
1650: GMICCAL.INVCAL_WHSE_CLOSED) THEN
1651:
1652: FND_MESSAGE.SET_NAME('GMI','IC_API_TXN_POST_CLOSED');
1653: FND_MESSAGE.SET_TOKEN('DATE',l_tran_rec.trans_date);
1654: FND_MESSAGE.SET_TOKEN('WAREH',l_ic_whse_mst_rec.whse_code);
1655: FND_MSG_PUB.Add;
1656: ELSE
1657: FND_MESSAGE.SET_NAME('GMI','ICCAL_GENL_ERR');

Line 1654: FND_MESSAGE.SET_TOKEN('WAREH',l_ic_whse_mst_rec.whse_code);

1650: GMICCAL.INVCAL_WHSE_CLOSED) THEN
1651:
1652: FND_MESSAGE.SET_NAME('GMI','IC_API_TXN_POST_CLOSED');
1653: FND_MESSAGE.SET_TOKEN('DATE',l_tran_rec.trans_date);
1654: FND_MESSAGE.SET_TOKEN('WAREH',l_ic_whse_mst_rec.whse_code);
1655: FND_MSG_PUB.Add;
1656: ELSE
1657: FND_MESSAGE.SET_NAME('GMI','ICCAL_GENL_ERR');
1658: FND_MSG_PUB.Add;

Line 1657: FND_MESSAGE.SET_NAME('GMI','ICCAL_GENL_ERR');

1653: FND_MESSAGE.SET_TOKEN('DATE',l_tran_rec.trans_date);
1654: FND_MESSAGE.SET_TOKEN('WAREH',l_ic_whse_mst_rec.whse_code);
1655: FND_MSG_PUB.Add;
1656: ELSE
1657: FND_MESSAGE.SET_NAME('GMI','ICCAL_GENL_ERR');
1658: FND_MSG_PUB.Add;
1659: END IF;
1660: l_error_flag := FND_API.G_TRUE;
1661: RAISE FND_API.G_EXC_ERROR;

Line 1689: FND_MESSAGE.Set_Name('GMI','GMI_SET_PIC_LOTS_ERROR');

1685: THEN
1686: PrintMsg('in allocate_opm_orders.call to
1687: set_pick_lots returns error');
1688: x_return_status := FND_API.G_RET_STS_ERROR;
1689: FND_MESSAGE.Set_Name('GMI','GMI_SET_PIC_LOTS_ERROR');
1690: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_ship_from_org_id);
1691: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
1692: FND_MSG_PUB.Add;
1693: RAISE FND_API.G_EXC_ERROR;

Line 1690: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_ship_from_org_id);

1686: PrintMsg('in allocate_opm_orders.call to
1687: set_pick_lots returns error');
1688: x_return_status := FND_API.G_RET_STS_ERROR;
1689: FND_MESSAGE.Set_Name('GMI','GMI_SET_PIC_LOTS_ERROR');
1690: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_ship_from_org_id);
1691: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
1692: FND_MSG_PUB.Add;
1693: RAISE FND_API.G_EXC_ERROR;
1694: RETURN;

Line 1691: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);

1687: set_pick_lots returns error');
1688: x_return_status := FND_API.G_RET_STS_ERROR;
1689: FND_MESSAGE.Set_Name('GMI','GMI_SET_PIC_LOTS_ERROR');
1690: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_ship_from_org_id);
1691: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
1692: FND_MSG_PUB.Add;
1693: RAISE FND_API.G_EXC_ERROR;
1694: RETURN;
1695: ELSE

Line 1811: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');

1807: CLOSE ic_lots_mst_c2;
1808: PrintMsg('Error : In Get_Lot_Details .Invalid Lot_id = '||
1809: p_lot_id||', item_id = '||p_item_id);
1810:
1811: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');
1812: FND_MESSAGE.Set_Token('LOT_NO', p_lot_no);
1813: FND_MESSAGE.Set_Token('SUBLOT_NO', p_sublot_no);
1814: FND_MESSAGE.Set_Token('LOT_ID', p_lot_id);
1815: FND_MSG_PUB.Add;

Line 1812: FND_MESSAGE.Set_Token('LOT_NO', p_lot_no);

1808: PrintMsg('Error : In Get_Lot_Details .Invalid Lot_id = '||
1809: p_lot_id||', item_id = '||p_item_id);
1810:
1811: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');
1812: FND_MESSAGE.Set_Token('LOT_NO', p_lot_no);
1813: FND_MESSAGE.Set_Token('SUBLOT_NO', p_sublot_no);
1814: FND_MESSAGE.Set_Token('LOT_ID', p_lot_id);
1815: FND_MSG_PUB.Add;
1816:

Line 1813: FND_MESSAGE.Set_Token('SUBLOT_NO', p_sublot_no);

1809: p_lot_id||', item_id = '||p_item_id);
1810:
1811: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');
1812: FND_MESSAGE.Set_Token('LOT_NO', p_lot_no);
1813: FND_MESSAGE.Set_Token('SUBLOT_NO', p_sublot_no);
1814: FND_MESSAGE.Set_Token('LOT_ID', p_lot_id);
1815: FND_MSG_PUB.Add;
1816:
1817: RAISE FND_API.G_EXC_ERROR;

Line 1814: FND_MESSAGE.Set_Token('LOT_ID', p_lot_id);

1810:
1811: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');
1812: FND_MESSAGE.Set_Token('LOT_NO', p_lot_no);
1813: FND_MESSAGE.Set_Token('SUBLOT_NO', p_sublot_no);
1814: FND_MESSAGE.Set_Token('LOT_ID', p_lot_id);
1815: FND_MSG_PUB.Add;
1816:
1817: RAISE FND_API.G_EXC_ERROR;
1818:

Line 1835: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');

1831: CLOSE ic_lots_mst_c1;
1832: PrintMsg('Error :in Get_Lot_Details .Invalid Lot_No/Sublot_no = '
1833: ||p_lot_no|| ', Sublot_no = '||p_sublot_no);
1834:
1835: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');
1836: FND_MESSAGE.Set_Token('LOT_NO', p_lot_no);
1837: FND_MESSAGE.Set_Token('SUBLOT_NO', p_sublot_no);
1838: FND_MESSAGE.Set_Token('LOT_ID', p_lot_id);
1839: FND_MSG_PUB.Add;

Line 1836: FND_MESSAGE.Set_Token('LOT_NO', p_lot_no);

1832: PrintMsg('Error :in Get_Lot_Details .Invalid Lot_No/Sublot_no = '
1833: ||p_lot_no|| ', Sublot_no = '||p_sublot_no);
1834:
1835: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');
1836: FND_MESSAGE.Set_Token('LOT_NO', p_lot_no);
1837: FND_MESSAGE.Set_Token('SUBLOT_NO', p_sublot_no);
1838: FND_MESSAGE.Set_Token('LOT_ID', p_lot_id);
1839: FND_MSG_PUB.Add;
1840:

Line 1837: FND_MESSAGE.Set_Token('SUBLOT_NO', p_sublot_no);

1833: ||p_lot_no|| ', Sublot_no = '||p_sublot_no);
1834:
1835: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');
1836: FND_MESSAGE.Set_Token('LOT_NO', p_lot_no);
1837: FND_MESSAGE.Set_Token('SUBLOT_NO', p_sublot_no);
1838: FND_MESSAGE.Set_Token('LOT_ID', p_lot_id);
1839: FND_MSG_PUB.Add;
1840:
1841: RAISE FND_API.G_EXC_ERROR;

Line 1838: FND_MESSAGE.Set_Token('LOT_ID', p_lot_id);

1834:
1835: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');
1836: FND_MESSAGE.Set_Token('LOT_NO', p_lot_no);
1837: FND_MESSAGE.Set_Token('SUBLOT_NO', p_sublot_no);
1838: FND_MESSAGE.Set_Token('LOT_ID', p_lot_id);
1839: FND_MSG_PUB.Add;
1840:
1841: RAISE FND_API.G_EXC_ERROR;
1842:

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

1927: IF ic_item_mst_cur%NOTFOUND THEN
1928: CLOSE ic_item_mst_cur;
1929: PrintMsg('Error ic_item_mst_cur%NOTFOUND inv_item_ id='
1930: ||p_inventory_item_id||', org_id='||p_organization_id);
1931: FND_MESSAGE.Set_Name('GMI','GMI_API_ITEM_NOT_FOUND');
1932: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1933: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1934:
1935: FND_MSG_PUB.Add;

Line 1932: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);

1928: CLOSE ic_item_mst_cur;
1929: PrintMsg('Error ic_item_mst_cur%NOTFOUND inv_item_ id='
1930: ||p_inventory_item_id||', org_id='||p_organization_id);
1931: FND_MESSAGE.Set_Name('GMI','GMI_API_ITEM_NOT_FOUND');
1932: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1933: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1934:
1935: FND_MSG_PUB.Add;
1936: RAISE FND_API.G_EXC_ERROR;

Line 1933: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);

1929: PrintMsg('Error ic_item_mst_cur%NOTFOUND inv_item_ id='
1930: ||p_inventory_item_id||', org_id='||p_organization_id);
1931: FND_MESSAGE.Set_Name('GMI','GMI_API_ITEM_NOT_FOUND');
1932: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1933: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1934:
1935: FND_MSG_PUB.Add;
1936: RAISE FND_API.G_EXC_ERROR;
1937: ELSE