262: IF NOT (GR_VALIDATE.validate_item(p_organization_id, p_item, l_inventory_item_id)) THEN
263: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
264: log_msg('Item provided - item validation failed.');
265: END IF;
266: FND_MESSAGE.SET_NAME('GR','GR_INVALID_ITEM');
267: FND_MESSAGE.SET_TOKEN('ITEM',p_item);
268: FND_MSG_PUB.Add;
269: RAISE INVALID_VALUE;
270: END IF;
263: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
264: log_msg('Item provided - item validation failed.');
265: END IF;
266: FND_MESSAGE.SET_NAME('GR','GR_INVALID_ITEM');
267: FND_MESSAGE.SET_TOKEN('ITEM',p_item);
268: FND_MSG_PUB.Add;
269: RAISE INVALID_VALUE;
270: END IF;
271:
277: IF NOT (GR_VALIDATE.validate_cas_number(p_organization_id, p_cas_number, l_item, l_inventory_item_id)) THEN
278: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
279: log_msg('CAS Number provided - CAS Number validation failed.');
280: END IF;
281: FND_MESSAGE.SET_NAME('GR','GR_INVALID_CAS_NUMBER');
282: FND_MESSAGE.SET_TOKEN('CAS_NUMBER',p_cas_number);
283: FND_MSG_PUB.Add;
284: RAISE INVALID_VALUE;
285: END IF;
278: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
279: log_msg('CAS Number provided - CAS Number validation failed.');
280: END IF;
281: FND_MESSAGE.SET_NAME('GR','GR_INVALID_CAS_NUMBER');
282: FND_MESSAGE.SET_TOKEN('CAS_NUMBER',p_cas_number);
283: FND_MSG_PUB.Add;
284: RAISE INVALID_VALUE;
285: END IF;
286:
294: (p_inventory_item_id <> l_inventory_item_id)) THEN
295: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
296: log_msg('Inventory Item ID provided - No match to item provided.');
297: END IF;
298: FND_MESSAGE.SET_NAME('GR','GR_NO_ITEM_ID_MATCH');
299: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_inventory_item_id);
300: FND_MESSAGE.SET_TOKEN('ITEM',l_item);
301: FND_MSG_PUB.Add;
302: RAISE INVALID_VALUE;
295: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
296: log_msg('Inventory Item ID provided - No match to item provided.');
297: END IF;
298: FND_MESSAGE.SET_NAME('GR','GR_NO_ITEM_ID_MATCH');
299: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_inventory_item_id);
300: FND_MESSAGE.SET_TOKEN('ITEM',l_item);
301: FND_MSG_PUB.Add;
302: RAISE INVALID_VALUE;
303:
296: log_msg('Inventory Item ID provided - No match to item provided.');
297: END IF;
298: FND_MESSAGE.SET_NAME('GR','GR_NO_ITEM_ID_MATCH');
299: FND_MESSAGE.SET_TOKEN('ITEM_ID',p_inventory_item_id);
300: FND_MESSAGE.SET_TOKEN('ITEM',l_item);
301: FND_MSG_PUB.Add;
302: RAISE INVALID_VALUE;
303:
304: END IF; -- ID matches item
426: /* Java concurrent program failed, to print the attached document to an output file */
427: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
428: log_msg('Document upload to temp table failed.');
429: END IF;
430: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_FILE_UPLOAD');
431: FND_MESSAGE.SET_TOKEN('FILE_NAME', p_document_name, FALSE);
432: FND_MSG_PUB.Add;
433: RAISE FILE_ERROR;
434: ELSE
427: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
428: log_msg('Document upload to temp table failed.');
429: END IF;
430: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_FILE_UPLOAD');
431: FND_MESSAGE.SET_TOKEN('FILE_NAME', p_document_name, FALSE);
432: FND_MSG_PUB.Add;
433: RAISE FILE_ERROR;
434: ELSE
435: COMMIT;
455: IF c_get_file_data%NOTFOUND THEN
456: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
457: log_msg('Document cannot be read from temp table.');
458: END IF;
459: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_FILE_UPLOAD');
460: FND_MESSAGE.SET_TOKEN('FILE_NAME', p_document_name, FALSE);
461: FND_MSG_PUB.Add;
462: RAISE FILE_ERROR;
463: END IF;
456: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
457: log_msg('Document cannot be read from temp table.');
458: END IF;
459: FND_MESSAGE.SET_NAME('GR','GR_CONC_REQ_FILE_UPLOAD');
460: FND_MESSAGE.SET_TOKEN('FILE_NAME', p_document_name, FALSE);
461: FND_MSG_PUB.Add;
462: RAISE FILE_ERROR;
463: END IF;
464: CLOSE c_get_file_data;
716: p_count => x_msg_count,
717: p_data => x_msg_data );
718:
719: WHEN INVALID_USER_ID THEN
720: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_USER_ID');
721: FND_MESSAGE.SET_TOKEN('USER_ID', p_user_id);
722: FND_MSG_PUB.Add;
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: FND_MSG_PUB.Count_And_Get (
717: p_data => x_msg_data );
718:
719: WHEN INVALID_USER_ID THEN
720: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_USER_ID');
721: FND_MESSAGE.SET_TOKEN('USER_ID', p_user_id);
722: FND_MSG_PUB.Add;
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: FND_MSG_PUB.Count_And_Get (
725: p_count => x_msg_count,
725: p_count => x_msg_count,
726: p_data => x_msg_data );
727:
728: WHEN INVALID_DOCUMENT_ID THEN
729: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOCUMENT_ID');
730: FND_MESSAGE.SET_TOKEN('DOCUMENT_ID', p_document_id);
731: FND_MSG_PUB.Add;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MSG_PUB.Count_And_Get (
726: p_data => x_msg_data );
727:
728: WHEN INVALID_DOCUMENT_ID THEN
729: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOCUMENT_ID');
730: FND_MESSAGE.SET_TOKEN('DOCUMENT_ID', p_document_id);
731: FND_MSG_PUB.Add;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MSG_PUB.Count_And_Get (
734: p_count => x_msg_count,
734: p_count => x_msg_count,
735: p_data => x_msg_data );
736:
737: WHEN INVALID_DOCUMENT_CATEGORY THEN
738: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOCUMENT_CATEGORY');
739: FND_MESSAGE.SET_TOKEN('DOC_CATEGORY', p_document_category);
740: FND_MSG_PUB.Add;
741: x_return_status := FND_API.G_RET_STS_ERROR;
742: FND_MSG_PUB.Count_And_Get (
735: p_data => x_msg_data );
736:
737: WHEN INVALID_DOCUMENT_CATEGORY THEN
738: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOCUMENT_CATEGORY');
739: FND_MESSAGE.SET_TOKEN('DOC_CATEGORY', p_document_category);
740: FND_MSG_PUB.Add;
741: x_return_status := FND_API.G_RET_STS_ERROR;
742: FND_MSG_PUB.Count_And_Get (
743: p_count => x_msg_count,
743: p_count => x_msg_count,
744: p_data => x_msg_data );
745:
746: WHEN INVALID_DISPATCH_METHOD_CODE THEN
747: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DISPATCH_METHOD');
748: FND_MESSAGE.SET_TOKEN('DISPATCH_METHOD_CODE', p_dispatch_method_code);
749: FND_MSG_PUB.Add;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: FND_MSG_PUB.Count_And_Get (
744: p_data => x_msg_data );
745:
746: WHEN INVALID_DISPATCH_METHOD_CODE THEN
747: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DISPATCH_METHOD');
748: FND_MESSAGE.SET_TOKEN('DISPATCH_METHOD_CODE', p_dispatch_method_code);
749: FND_MSG_PUB.Add;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: FND_MSG_PUB.Count_And_Get (
752: p_count => x_msg_count,
752: p_count => x_msg_count,
753: p_data => x_msg_data );
754:
755: WHEN INVALID_DISCLOSURE_CODE THEN
756: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DISCLOSURE_CODE');
757: FND_MESSAGE.SET_TOKEN('CODE', p_disclosure_code);
758: FND_MSG_PUB.Add;
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: FND_MSG_PUB.Count_And_Get (
753: p_data => x_msg_data );
754:
755: WHEN INVALID_DISCLOSURE_CODE THEN
756: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DISCLOSURE_CODE');
757: FND_MESSAGE.SET_TOKEN('CODE', p_disclosure_code);
758: FND_MSG_PUB.Add;
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: FND_MSG_PUB.Count_And_Get (
761: p_count => x_msg_count,
761: p_count => x_msg_count,
762: p_data => x_msg_data );
763:
764: WHEN INVALID_DOCUMENT_LANGUAGE THEN
765: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_LANGUAGE');
766: FND_MESSAGE.SET_TOKEN('LANGUAGE', p_language);
767: FND_MSG_PUB.Add;
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: FND_MSG_PUB.Count_And_Get (
762: p_data => x_msg_data );
763:
764: WHEN INVALID_DOCUMENT_LANGUAGE THEN
765: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_LANGUAGE');
766: FND_MESSAGE.SET_TOKEN('LANGUAGE', p_language);
767: FND_MSG_PUB.Add;
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: FND_MSG_PUB.Count_And_Get (
770: p_count => x_msg_count,
770: p_count => x_msg_count,
771: p_data => x_msg_data );
772:
773: WHEN INVALID_DOCUMENT_VERSION THEN
774: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DOC_VERSION');
775: FND_MSG_PUB.Add;
776: x_return_status := FND_API.G_RET_STS_ERROR;
777: FND_MSG_PUB.Count_And_Get (
778: p_count => x_msg_count,
778: p_count => x_msg_count,
779: p_data => x_msg_data );
780:
781: WHEN INVALID_DATE_SENT THEN
782: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DATE_SENT');
783: FND_MESSAGE.SET_TOKEN('DATE_SENT', p_date_sent);
784: FND_MSG_PUB.Add;
785: x_return_status := FND_API.G_RET_STS_ERROR;
786: FND_MSG_PUB.Count_And_Get (
779: p_data => x_msg_data );
780:
781: WHEN INVALID_DATE_SENT THEN
782: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_DATE_SENT');
783: FND_MESSAGE.SET_TOKEN('DATE_SENT', p_date_sent);
784: FND_MSG_PUB.Add;
785: x_return_status := FND_API.G_RET_STS_ERROR;
786: FND_MSG_PUB.Count_And_Get (
787: p_count => x_msg_count,
787: p_count => x_msg_count,
788: p_data => x_msg_data );
789:
790: WHEN INVALID_CREATION_SOURCE THEN
791: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_CREATION_SOURCE');
792: FND_MESSAGE.SET_TOKEN('CREATION_SOURCE', p_creation_source);
793: FND_MSG_PUB.Add;
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: FND_MSG_PUB.Count_And_Get (
788: p_data => x_msg_data );
789:
790: WHEN INVALID_CREATION_SOURCE THEN
791: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_CREATION_SOURCE');
792: FND_MESSAGE.SET_TOKEN('CREATION_SOURCE', p_creation_source);
793: FND_MSG_PUB.Add;
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: FND_MSG_PUB.Count_And_Get (
796: p_count => x_msg_count,
796: p_count => x_msg_count,
797: p_data => x_msg_data );
798:
799: WHEN INVALID_RECIPIENT_ID THEN
800: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_RECIPIENT_ID');
801: FND_MESSAGE.SET_TOKEN('RECIPIENT_ID', p_recipient_id);
802: FND_MSG_PUB.Add;
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: FND_MSG_PUB.Count_And_Get (
797: p_data => x_msg_data );
798:
799: WHEN INVALID_RECIPIENT_ID THEN
800: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_RECIPIENT_ID');
801: FND_MESSAGE.SET_TOKEN('RECIPIENT_ID', p_recipient_id);
802: FND_MSG_PUB.Add;
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: FND_MSG_PUB.Count_And_Get (
805: p_count => x_msg_count,
805: p_count => x_msg_count,
806: p_data => x_msg_data );
807:
808: WHEN INVALID_RECIPIENT_SITE_ID THEN
809: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_RECIPIENT_SITE_ID');
810: FND_MESSAGE.SET_TOKEN('RECIPIENT_SITE_ID', p_recipient_site_id);
811: FND_MSG_PUB.Add;
812: x_return_status := FND_API.G_RET_STS_ERROR;
813: FND_MSG_PUB.Count_And_Get (
806: p_data => x_msg_data );
807:
808: WHEN INVALID_RECIPIENT_SITE_ID THEN
809: FND_MESSAGE.SET_NAME('GR', 'GR_INVALID_RECIPIENT_SITE_ID');
810: FND_MESSAGE.SET_TOKEN('RECIPIENT_SITE_ID', p_recipient_site_id);
811: FND_MSG_PUB.Add;
812: x_return_status := FND_API.G_RET_STS_ERROR;
813: FND_MSG_PUB.Count_And_Get (
814: p_count => x_msg_count,
813: FND_MSG_PUB.Count_And_Get (
814: p_count => x_msg_count,
815: p_data => x_msg_data );
816: WHEN FILE_ERROR THEN
817: FND_MESSAGE.SET_NAME('GR', 'GR_FILE_ERROR');
818: FND_MESSAGE.SET_TOKEN('FILE', p_document_location||'/'||p_document_name);
819: FND_MSG_PUB.Add;
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: FND_MSG_PUB.Count_And_Get (
814: p_count => x_msg_count,
815: p_data => x_msg_data );
816: WHEN FILE_ERROR THEN
817: FND_MESSAGE.SET_NAME('GR', 'GR_FILE_ERROR');
818: FND_MESSAGE.SET_TOKEN('FILE', p_document_location||'/'||p_document_name);
819: FND_MSG_PUB.Add;
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: FND_MSG_PUB.Count_And_Get (
822: p_count => x_msg_count,
908: -------------------------------------------------------------------------------
909: PROCEDURE log_msg(p_msg_text IN VARCHAR2) IS
910: BEGIN
911:
912: FND_MESSAGE.SET_NAME('GR','GR_DEBUG_API');
913: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
914: FND_MSG_PUB.Add;
915:
916: END log_msg ;
909: PROCEDURE log_msg(p_msg_text IN VARCHAR2) IS
910: BEGIN
911:
912: FND_MESSAGE.SET_NAME('GR','GR_DEBUG_API');
913: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
914: FND_MSG_PUB.Add;
915:
916: END log_msg ;
917: