DBA Data[Home] [Help]

APPS.GMD_ITEM_TECHNICAL_DATA_PUB dependencies on FND_MESSAGE

Line 89: FND_MESSAGE.SET_NAME('GMD','GMD_API_NO_ROWS_INS');

85: , x_return_status => l_return_status
86: );
87:
88: IF l_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
89: FND_MESSAGE.SET_NAME('GMD','GMD_API_NO_ROWS_INS');
90: FND_MSG_PUB.ADD;
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93:

Line 308: FND_MESSAGE.SET_NAME('GMD','GMF_API_NO_ROWS_UPD');

304: );
305:
306:
307: IF l_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
308: FND_MESSAGE.SET_NAME('GMD','GMF_API_NO_ROWS_UPD');
309: FND_MSG_PUB.ADD;
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;*/
312:

Line 318: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');

314: IF p_tech_data_id IS NOT NULL THEN
315: OPEN Cur_check_valid;
316: FETCH Cur_check_valid INTO l_temp;
317: IF (Cur_check_valid%NOTFOUND) THEN
318: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
319: FND_MESSAGE.SET_TOKEN('FIELD','TECH_DATA_ID');
320: FND_MESSAGE.SET_TOKEN('VALUE',l_tech_data_id);
321: FND_MSG_PUB.ADD;
322: RAISE invalid_tech_data_value;

Line 319: FND_MESSAGE.SET_TOKEN('FIELD','TECH_DATA_ID');

315: OPEN Cur_check_valid;
316: FETCH Cur_check_valid INTO l_temp;
317: IF (Cur_check_valid%NOTFOUND) THEN
318: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
319: FND_MESSAGE.SET_TOKEN('FIELD','TECH_DATA_ID');
320: FND_MESSAGE.SET_TOKEN('VALUE',l_tech_data_id);
321: FND_MSG_PUB.ADD;
322: RAISE invalid_tech_data_value;
323: END IF;

Line 320: FND_MESSAGE.SET_TOKEN('VALUE',l_tech_data_id);

316: FETCH Cur_check_valid INTO l_temp;
317: IF (Cur_check_valid%NOTFOUND) THEN
318: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
319: FND_MESSAGE.SET_TOKEN('FIELD','TECH_DATA_ID');
320: FND_MESSAGE.SET_TOKEN('VALUE',l_tech_data_id);
321: FND_MSG_PUB.ADD;
322: RAISE invalid_tech_data_value;
323: END IF;
324: CLOSE Cur_check_valid;

Line 326: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

322: RAISE invalid_tech_data_value;
323: END IF;
324: CLOSE Cur_check_valid;
325: ELSE
326: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
327: FND_MESSAGE.SET_TOKEN ('MISSING', 'TECHDATAID');
328: FND_MSG_PUB.ADD;
329: RAISE no_tech_data_value;
330: END IF;

Line 327: FND_MESSAGE.SET_TOKEN ('MISSING', 'TECHDATAID');

323: END IF;
324: CLOSE Cur_check_valid;
325: ELSE
326: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
327: FND_MESSAGE.SET_TOKEN ('MISSING', 'TECHDATAID');
328: FND_MSG_PUB.ADD;
329: RAISE no_tech_data_value;
330: END IF;
331:

Line 685: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

681: END IF;
682:
683: /*-- Check that formula and batch id are both not present
684: IF (p_header_rec.FORMULA_ID IS NOT NULL AND p_header_rec.BATCH_ID IS NOT NULL) THEN
685: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
686: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULA_ID');
687: FND_MSG_PUB.ADD;
688: x_return_status := FND_API.G_RET_STS_ERROR ;
689: RAISE FND_API.G_EXC_ERROR;

Line 686: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULA_ID');

682:
683: /*-- Check that formula and batch id are both not present
684: IF (p_header_rec.FORMULA_ID IS NOT NULL AND p_header_rec.BATCH_ID IS NOT NULL) THEN
685: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
686: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULA_ID');
687: FND_MSG_PUB.ADD;
688: x_return_status := FND_API.G_RET_STS_ERROR ;
689: RAISE FND_API.G_EXC_ERROR;
690: END IF;*/

Line 709: FND_MESSAGE.SET_NAME ('GMD', 'GMD_BATCH_NOT_FOUND');

705: IF (p_header_rec.BATCH_ID) IS NOT NULL THEN
706: OPEN check_batch(p_header_rec.batch_id);
707: FETCH check_batch INTO l_count;
708: IF check_batch%NOTFOUND THEN
709: FND_MESSAGE.SET_NAME ('GMD', 'GMD_BATCH_NOT_FOUND');
710: FND_MSG_PUB.ADD;
711: x_return_status := FND_API.G_RET_STS_ERROR ;
712: CLOSE check_batch;
713: RAISE FND_API.G_EXC_ERROR;

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

724:
725: EXCEPTION
726:
727: WHEN ITEM_MISSING THEN
728: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
729: FND_MESSAGE.SET_TOKEN ('MISSING', 'INVENTORY_ITEM_ID');
730: FND_MSG_PUB.ADD;
731: x_return_status := FND_API.G_RET_STS_ERROR ;
732:

Line 729: FND_MESSAGE.SET_TOKEN ('MISSING', 'INVENTORY_ITEM_ID');

725: EXCEPTION
726:
727: WHEN ITEM_MISSING THEN
728: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
729: FND_MESSAGE.SET_TOKEN ('MISSING', 'INVENTORY_ITEM_ID');
730: FND_MSG_PUB.ADD;
731: x_return_status := FND_API.G_RET_STS_ERROR ;
732:
733: WHEN DUPLICATE_RECORD THEN

Line 734: FND_MESSAGE.SET_NAME('GMP','PS_DUP_REC');

730: FND_MSG_PUB.ADD;
731: x_return_status := FND_API.G_RET_STS_ERROR ;
732:
733: WHEN DUPLICATE_RECORD THEN
734: FND_MESSAGE.SET_NAME('GMP','PS_DUP_REC');
735: FND_MSG_PUB.ADD;
736: x_return_status := FND_API.G_RET_STS_ERROR ;
737:
738: WHEN ORGANIZATION_MISSING THEN

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

735: FND_MSG_PUB.ADD;
736: x_return_status := FND_API.G_RET_STS_ERROR ;
737:
738: WHEN ORGANIZATION_MISSING THEN
739: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
740: FND_MESSAGE.SET_TOKEN ('MISSING', 'ORGANIZATION_ID');
741: FND_MSG_PUB.ADD;
742: x_return_status := FND_API.G_RET_STS_ERROR ;
743:

Line 740: FND_MESSAGE.SET_TOKEN ('MISSING', 'ORGANIZATION_ID');

736: x_return_status := FND_API.G_RET_STS_ERROR ;
737:
738: WHEN ORGANIZATION_MISSING THEN
739: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
740: FND_MESSAGE.SET_TOKEN ('MISSING', 'ORGANIZATION_ID');
741: FND_MSG_PUB.ADD;
742: x_return_status := FND_API.G_RET_STS_ERROR ;
743:
744: WHEN LOT_MISSING THEN

Line 745: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

741: FND_MSG_PUB.ADD;
742: x_return_status := FND_API.G_RET_STS_ERROR ;
743:
744: WHEN LOT_MISSING THEN
745: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
746: FND_MESSAGE.SET_TOKEN ('MISSING', 'LOT_NO');
747: FND_MSG_PUB.ADD;
748: x_return_status := FND_API.G_RET_STS_ERROR ;
749:

Line 746: FND_MESSAGE.SET_TOKEN ('MISSING', 'LOT_NO');

742: x_return_status := FND_API.G_RET_STS_ERROR ;
743:
744: WHEN LOT_MISSING THEN
745: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
746: FND_MESSAGE.SET_TOKEN ('MISSING', 'LOT_NO');
747: FND_MSG_PUB.ADD;
748: x_return_status := FND_API.G_RET_STS_ERROR ;
749:
750: WHEN LOT_ORGN_MISSING THEN

Line 751: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

747: FND_MSG_PUB.ADD;
748: x_return_status := FND_API.G_RET_STS_ERROR ;
749:
750: WHEN LOT_ORGN_MISSING THEN
751: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
752: FND_MESSAGE.SET_TOKEN ('MISSING', 'LOT_ORGANIZATION_ID');
753: FND_MSG_PUB.ADD;
754: x_return_status := FND_API.G_RET_STS_ERROR ;
755:

Line 752: FND_MESSAGE.SET_TOKEN ('MISSING', 'LOT_ORGANIZATION_ID');

748: x_return_status := FND_API.G_RET_STS_ERROR ;
749:
750: WHEN LOT_ORGN_MISSING THEN
751: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
752: FND_MESSAGE.SET_TOKEN ('MISSING', 'LOT_ORGANIZATION_ID');
753: FND_MSG_PUB.ADD;
754: x_return_status := FND_API.G_RET_STS_ERROR ;
755:
756: WHEN INVALID_ITEM_NO THEN

Line 757: FND_MESSAGE.SET_NAME ('GMI', 'IC_INVALID_ITEM_NO');

753: FND_MSG_PUB.ADD;
754: x_return_status := FND_API.G_RET_STS_ERROR ;
755:
756: WHEN INVALID_ITEM_NO THEN
757: FND_MESSAGE.SET_NAME ('GMI', 'IC_INVALID_ITEM_NO');
758: FND_MSG_PUB.ADD;
759: x_return_status := FND_API.G_RET_STS_ERROR ;
760:
761: WHEN INVALID_LAB_ORGN THEN

Line 762: FND_MESSAGE.SET_NAME ('GMD', 'LM_BAD_LAB_TYPE');

758: FND_MSG_PUB.ADD;
759: x_return_status := FND_API.G_RET_STS_ERROR ;
760:
761: WHEN INVALID_LAB_ORGN THEN
762: FND_MESSAGE.SET_NAME ('GMD', 'LM_BAD_LAB_TYPE');
763: FND_MSG_PUB.ADD;
764: x_return_status := FND_API.G_RET_STS_ERROR ;
765:
766: WHEN INVALID_LOT THEN

Line 767: FND_MESSAGE.SET_NAME ('GMI', 'IC_INVALID_LOT/SUBLOT');

763: FND_MSG_PUB.ADD;
764: x_return_status := FND_API.G_RET_STS_ERROR ;
765:
766: WHEN INVALID_LOT THEN
767: FND_MESSAGE.SET_NAME ('GMI', 'IC_INVALID_LOT/SUBLOT');
768: FND_MSG_PUB.ADD;
769: x_return_status := FND_API.G_RET_STS_ERROR ;
770:
771: WHEN INVALID_FORMULA THEN

Line 772: FND_MESSAGE.SET_NAME ('GMD', 'LM_NOT_PROD');

768: FND_MSG_PUB.ADD;
769: x_return_status := FND_API.G_RET_STS_ERROR ;
770:
771: WHEN INVALID_FORMULA THEN
772: FND_MESSAGE.SET_NAME ('GMD', 'LM_NOT_PROD');
773: FND_MSG_PUB.ADD;
774: x_return_status := FND_API.G_RET_STS_ERROR ;
775:
776: END VALIDATE_INPUT_PARAMS;