DBA Data[Home] [Help]

APPS.GMD_ITEM_TECHNICAL_DATA_PUB dependencies on FND_MSG_PUB

Line 63: FND_MSG_PUB.initialize;

59: SAVEPOINT Insert_Item_Tech_Data_PUB; /* Changed in Bug No.7489645*/
60:
61: -- Initialize message list if p_init_msg_list is set to TRUE.
62: IF FND_API.to_Boolean( p_init_msg_list ) THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: -- Standard call to check for call compatibility.
67: IF NOT FND_API.Compatible_API_Call ( l_api_version

Line 90: FND_MSG_PUB.ADD;

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:
94: -- Insert Item Technical Data header

Line 175: fnd_msg_pub.count_and_get (

171: WHEN FND_API.G_EXC_ERROR THEN
172:
173: ROLLBACK TO Insert_Item_Tech_Data_PUB;
174: x_return_status := FND_API.G_RET_STS_ERROR ;
175: fnd_msg_pub.count_and_get (
176: p_count => x_msg_count
177: ,p_encoded => FND_API.g_false
178: ,p_data => x_msg_data);
179:

Line 186: fnd_msg_pub.count_and_get (

182:
183: ROLLBACK TO Insert_Item_Tech_Data_PUB;
184:
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
186: fnd_msg_pub.count_and_get (
187: p_count => x_msg_count
188: ,p_encoded => FND_API.g_false
189: ,p_data => x_msg_data);
190:

Line 196: fnd_msg_pub.count_and_get (

192:
193: ROLLBACK TO Insert_Item_Tech_Data_PUB;
194:
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
196: fnd_msg_pub.count_and_get (
197: p_count => x_msg_count
198: ,p_encoded => FND_API.g_false
199: ,p_data => x_msg_data);
200:

Line 279: FND_MSG_PUB.initialize;

275: l_tech_data_id := p_tech_data_id;
276: -- Initialize message list if p_init_msg_list is set to TRUE.
277: IF FND_API.to_Boolean( p_init_msg_list )
278: THEN
279: FND_MSG_PUB.initialize;
280: END IF;
281:
282:
283: -- Standard call to check for call compatibility.

Line 309: FND_MSG_PUB.ADD;

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:
313: --Checked for valid tech data id

Line 321: FND_MSG_PUB.ADD;

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;
325: ELSE

Line 328: FND_MSG_PUB.ADD;

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:
332: OPEN get_Orgn_id;

Line 419: fnd_msg_pub.count_and_get (

415: WHEN FND_API.G_EXC_ERROR THEN
416:
417: ROLLBACK TO Update_Item_Tech_Data_PUB;
418: x_return_status := FND_API.G_RET_STS_ERROR ;
419: fnd_msg_pub.count_and_get (
420: p_count => x_msg_count
421: ,p_encoded => FND_API.g_false
422: ,p_data => x_msg_data);
423:

Line 428: fnd_msg_pub.count_and_get (

424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
425:
426: ROLLBACK TO Update_Item_Tech_Data_PUB;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: fnd_msg_pub.count_and_get (
429: p_count => x_msg_count
430: ,p_encoded => FND_API.g_false
431: ,p_data => x_msg_data);
432:

Line 436: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

432:
433: WHEN no_tech_data_value THEN
434: ROLLBACK TO Update_Item_Tech_Data_PUB;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
437: P_data => x_msg_data);
438: WHEN invalid_tech_data_value THEN
439: ROLLBACK TO Update_Item_Tech_Data_PUB;
440: x_return_status := FND_API.G_RET_STS_ERROR;

Line 441: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

437: P_data => x_msg_data);
438: WHEN invalid_tech_data_value THEN
439: ROLLBACK TO Update_Item_Tech_Data_PUB;
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
442: P_data => x_msg_data);
443:
444: WHEN OTHERS THEN
445:

Line 448: fnd_msg_pub.count_and_get (

444: WHEN OTHERS THEN
445:
446: ROLLBACK TO Update_Item_Tech_Data_PUB;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
448: fnd_msg_pub.count_and_get (
449: p_count => x_msg_count
450: ,p_encoded => FND_API.g_false
451: ,p_data => x_msg_data);
452:

Line 488: FND_MSG_PUB.initialize;

484:
485: -- Initialize message list if p_init_msg_list is set to TRUE.
486: IF FND_API.to_Boolean( p_init_msg_list )
487: THEN
488: FND_MSG_PUB.initialize;
489: END IF;
490:
491: -- Standard call to check for call compatibility.
492: IF NOT FND_API.Compatible_API_Call (l_api_version ,

Line 523: fnd_msg_pub.count_and_get (

519: WHEN FND_API.G_EXC_ERROR THEN
520:
521: ROLLBACK TO Delete_Item_Tech_Data_PUB;
522: x_return_status := FND_API.G_RET_STS_ERROR ;
523: fnd_msg_pub.count_and_get (
524: p_count => x_msg_count
525: ,p_encoded => FND_API.g_false
526: ,p_data => x_msg_data);
527:

Line 533: fnd_msg_pub.count_and_get (

529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
530:
531: ROLLBACK TO Delete_Item_Tech_Data_PUB;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
533: fnd_msg_pub.count_and_get (
534: p_count => x_msg_count
535: ,p_encoded => FND_API.g_false
536: ,p_data => x_msg_data);
537:

Line 542: fnd_msg_pub.count_and_get (

538: WHEN OTHERS THEN
539:
540: ROLLBACK TO Delete_Item_Tech_Data_PUB;
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
542: fnd_msg_pub.count_and_get (
543: p_count => x_msg_count
544: ,p_encoded => FND_API.g_false
545: ,p_data => x_msg_data);
546:

Line 687: FND_MSG_PUB.ADD;

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;*/
691:

Line 710: FND_MSG_PUB.ADD;

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;
714: END IF;

Line 730: FND_MSG_PUB.ADD;

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
734: FND_MESSAGE.SET_NAME('GMP','PS_DUP_REC');

Line 735: 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
739: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

Line 741: FND_MSG_PUB.ADD;

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
745: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

Line 747: FND_MSG_PUB.ADD;

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
751: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

Line 753: FND_MSG_PUB.ADD;

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
757: FND_MESSAGE.SET_NAME ('GMI', 'IC_INVALID_ITEM_NO');

Line 758: 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
762: FND_MESSAGE.SET_NAME ('GMD', 'LM_BAD_LAB_TYPE');

Line 763: 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
767: FND_MESSAGE.SET_NAME ('GMI', 'IC_INVALID_LOT/SUBLOT');

Line 768: 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
772: FND_MESSAGE.SET_NAME ('GMD', 'LM_NOT_PROD');

Line 773: 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;
777:

Line 812: FND_MSG_PUB.initialize;

808: BEGIN
809:
810: -- Initialize message list if p_init_msg_list is set to TRUE.
811: IF FND_API.to_Boolean( p_init_msg_list ) THEN
812: FND_MSG_PUB.initialize;
813: END IF;
814:
815: -- Standard call to check for call compatibility.
816: IF NOT FND_API.Compatible_API_Call (l_api_version ,

Line 842: fnd_msg_pub.count_and_get (

838: EXCEPTION
839:
840: WHEN FND_API.G_EXC_ERROR THEN
841: x_return_status := FND_API.G_RET_STS_ERROR ;
842: fnd_msg_pub.count_and_get (
843: p_count => x_msg_count
844: ,p_encoded => FND_API.g_false
845: ,p_data => x_msg_data);
846:

Line 850: fnd_msg_pub.count_and_get (

846:
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
850: fnd_msg_pub.count_and_get (
851: p_count => x_msg_count
852: ,p_encoded => FND_API.g_false
853: ,p_data => x_msg_data);
854:

Line 858: fnd_msg_pub.count_and_get (

854:
855:
856: WHEN OTHERS THEN
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
858: fnd_msg_pub.count_and_get (
859: p_count => x_msg_count
860: ,p_encoded => FND_API.g_false
861: ,p_data => x_msg_data);
862: