APPS.M4U_UCC_UTILS dependencies on FND_API

Line 580: RAISE FND_API.G_EXC_ERROR;

576:
577: select length(p_attr_value) into l_attr_len from dual;
578:
579: If(l_attr_len <> 13) THEN
580: RAISE FND_API.G_EXC_ERROR;
581: END IF;
582:
583: l_msg_data := 'Validation Failed: GLN should be a numeric value';
584:

Line 596: RAISE FND_API.G_EXC_ERROR;

592: FND_MESSAGE.SET_NAME('CLN','M4U_ATTRVAL_GLN_3');
593: x_msg_data := FND_MESSAGE.GET;
594:
595: IF(NOT validate_checkdigit_gln(p_attr_value)) THEN
596: RAISE FND_API.G_EXC_ERROR;
597: END IF;
598: return TRUE;
599: l_msg_data := 'GLN validated';
600:

Line 614: RAISE FND_API.G_EXC_ERROR;

610:
611: select length(p_attr_value) into l_attr_len from dual;
612:
613: If(l_attr_len <> 14) THEN
614: RAISE FND_API.G_EXC_ERROR;
615: END IF;
616:
617:
618: -- 2. GTIN should be a numeric entity

Line 631: RAISE FND_API.G_EXC_ERROR;

627: FND_MESSAGE.SET_NAME('CLN','M4U_ATTRVAL_GTIN_3');
628: x_msg_data := FND_MESSAGE.GET;
629:
630: IF(NOT validate_checkdigit_gtin(p_attr_value)) THEN
631: RAISE FND_API.G_EXC_ERROR;
632: END IF;
633: return TRUE;
634:
635: l_msg_data := 'GTIN validated';

Line 654: RAISE FND_API.G_EXC_ERROR;

650:
651: select length(p_attr_value) into l_attr_len from dual;
652:
653: If(l_attr_len > 3) THEN
654: RAISE FND_API.G_EXC_ERROR;
655: END IF;
656: return TRUE;
657: END IF;
658:

Line 661: WHEN FND_API.G_EXC_ERROR THEN

657: END IF;
658:
659: -- Exception Handling
660: EXCEPTION
661: WHEN FND_API.G_EXC_ERROR THEN
662: x_return_status := FND_API.G_RET_STS_ERROR ;
663: IF (l_Debug_Level <= 4) THEN
664: cln_debug_pub.Add(l_msg_data,4);
665: cln_debug_pub.Add('------- Exiting validate_uccnet_attr API --------- ',2);

Line 662: x_return_status := FND_API.G_RET_STS_ERROR ;

658:
659: -- Exception Handling
660: EXCEPTION
661: WHEN FND_API.G_EXC_ERROR THEN
662: x_return_status := FND_API.G_RET_STS_ERROR ;
663: IF (l_Debug_Level <= 4) THEN
664: cln_debug_pub.Add(l_msg_data,4);
665: cln_debug_pub.Add('------- Exiting validate_uccnet_attr API --------- ',2);
666: END IF;

Line 673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

669: WHEN OTHERS THEN
670: l_error_code :=SQLCODE;
671: l_error_msg :=SQLERRM;
672:
673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
674: x_msg_data :=l_error_code||' : '||l_error_msg||' : '||x_msg_data;
675:
676: IF (l_Debug_Level <= 5) THEN
677: cln_debug_pub.Add(x_msg_data,5);