APPS.M4U_UCC_UTILS dependencies on DUAL

Line 577: select length(p_attr_value) into l_attr_len from dual;

573: l_msg_data := 'Validation Failed: GLN should be 13 length digits';
574: FND_MESSAGE.SET_NAME('CLN','M4U_ATTRVAL_GLN_1');
575: x_msg_data := FND_MESSAGE.GET;
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;

Line 587: select to_number(p_attr_value,'9999999999999') into l_attr_value from dual;

583: l_msg_data := 'Validation Failed: GLN should be a numeric value';
584:
585: FND_MESSAGE.SET_NAME('CLN','M4U_ATTRVAL_GLN_2');
586: x_msg_data := FND_MESSAGE.GET;
587: select to_number(p_attr_value,'9999999999999') into l_attr_value from dual;
588:
589:
590: l_msg_data := 'Validation Failed: GLN check digitsum is wrong';
591:

Line 611: select length(p_attr_value) into l_attr_len from dual;

607: l_msg_data := 'Validation Failed: GTIN should be 14 length digits';
608: FND_MESSAGE.SET_NAME('CLN','M4U_ATTRVAL_GTIN_1');
609: x_msg_data := FND_MESSAGE.GET;
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;

Line 623: select to_number(p_attr_value,'99999999999999') into l_attr_value from dual;

619: l_msg_data := 'Validation Failed: GTIN should be a numeric value';
620: FND_MESSAGE.SET_NAME('CLN','M4U_ATTRVAL_GTIN_2');
621: x_msg_data := FND_MESSAGE.GET;
622:
623: select to_number(p_attr_value,'99999999999999') into l_attr_value from dual;
624:
625: -- 3. Checksum should be correct
626: l_msg_data := 'Validation Failed: GTIN check digitsum is wrong';
627: FND_MESSAGE.SET_NAME('CLN','M4U_ATTRVAL_GTIN_3');

Line 651: select length(p_attr_value) into l_attr_len from dual;

647: l_msg_data := 'Validation Failed: Target Market should be 1-3 digits';
648: FND_MESSAGE.SET_NAME('CLN','M4U_ATTRVAL_TRGMKT_1');
649: x_msg_data := FND_MESSAGE.GET;
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;

Line 729: FROM DUAL;

725: SELECT FND_PROFILE.VALUE('ORG_ID'),
726: FND_PROFILE.VALUE('M4U_UCCNET_GLN'),
727: FND_PROFILE.VALUE('M4U_SUPP_GLN')
728: INTO g_org_id,g_host_gln,g_supp_gln
729: FROM DUAL;
730:
731: IF (l_Debug_Level <= 1) THEN
732: cln_debug_pub.Add('Org ID -'||g_org_id,1);
733: cln_debug_pub.Add('Host GLN -'||g_host_gln,1);