62: END LOOP;
63:
64: IF l_count > 1 THEN
65:
66: FND_MESSAGE.SET_NAME('JE','JE_IT_VAT_DUPLICATE');
67: g_vat_reg_error := FND_MESSAGE.get;
68: RETURN g_vat_reg_error;
69:
70: END IF;
63:
64: IF l_count > 1 THEN
65:
66: FND_MESSAGE.SET_NAME('JE','JE_IT_VAT_DUPLICATE');
67: g_vat_reg_error := FND_MESSAGE.get;
68: RETURN g_vat_reg_error;
69:
70: END IF;
71:
77: ,p_return_status => error_status
78: ,p_error_buffer => eror_buffer);
79:
80: IF error_status = 'E' THEN
81: FND_MESSAGE.SET_NAME('JE','JE_IT_VAT_INVALID');
82: g_vat_reg_error := FND_MESSAGE.get;
83: RETURN g_vat_reg_error;
84: END IF;
85: END IF;
78: ,p_error_buffer => eror_buffer);
79:
80: IF error_status = 'E' THEN
81: FND_MESSAGE.SET_NAME('JE','JE_IT_VAT_INVALID');
82: g_vat_reg_error := FND_MESSAGE.get;
83: RETURN g_vat_reg_error;
84: END IF;
85: END IF;
86:
91:
92: EXCEPTION
93: WHEN others THEN
94: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);
95: FND_MESSAGE.SET_NAME('JE','JE_IT_VAT_INVALID');
96: g_vat_reg_error := FND_MESSAGE.get;
97: RETURN g_vat_reg_error;
98:
99: END validate_vat_reg_num;
92: EXCEPTION
93: WHEN others THEN
94: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);
95: FND_MESSAGE.SET_NAME('JE','JE_IT_VAT_INVALID');
96: g_vat_reg_error := FND_MESSAGE.get;
97: RETURN g_vat_reg_error;
98:
99: END validate_vat_reg_num;
100:
811:
812: END LOOP;
813:
814: IF l_count > 1 THEN --if4
815: FND_MESSAGE.SET_NAME('JE','JE_IT_NIF_DUPLICATE');
816: g_vat_reg_error := FND_MESSAGE.get;
817: RETURN g_vat_reg_error;
818: END IF; --if4
819:
812: END LOOP;
813:
814: IF l_count > 1 THEN --if4
815: FND_MESSAGE.SET_NAME('JE','JE_IT_NIF_DUPLICATE');
816: g_vat_reg_error := FND_MESSAGE.get;
817: RETURN g_vat_reg_error;
818: END IF; --if4
819:
820: IF l_count < 2 THEN --if5
821:
822: VALIDATE_NIF_IT (pv_taxpayer_id,'P',error_status,g_vat_reg_error);
823:
824: IF error_status = 'F' THEN
825: FND_MESSAGE.SET_NAME('JE','JE_IT_NIF_INVALID');
826: g_vat_reg_error := FND_MESSAGE.get;
827: RETURN g_vat_reg_error;
828: END IF;
829:
822: VALIDATE_NIF_IT (pv_taxpayer_id,'P',error_status,g_vat_reg_error);
823:
824: IF error_status = 'F' THEN
825: FND_MESSAGE.SET_NAME('JE','JE_IT_NIF_INVALID');
826: g_vat_reg_error := FND_MESSAGE.get;
827: RETURN g_vat_reg_error;
828: END IF;
829:
830: END IF; --if5
846:
847: END LOOP;
848:
849: IF l_count > 1 THEN --if7
850: FND_MESSAGE.SET_NAME('JE','JE_IT_NIF_DUPLICATE');
851: g_vat_reg_error := FND_MESSAGE.get;
852: RETURN g_vat_reg_error;
853: END IF; --if7
854:
847: END LOOP;
848:
849: IF l_count > 1 THEN --if7
850: FND_MESSAGE.SET_NAME('JE','JE_IT_NIF_DUPLICATE');
851: g_vat_reg_error := FND_MESSAGE.get;
852: RETURN g_vat_reg_error;
853: END IF; --if7
854:
855: IF l_count < 2 THEN --if8
855: IF l_count < 2 THEN --if8
856:
857: VALIDATE_NIF_IT (pv_taxpayer_id,'P',error_status,g_vat_reg_error);
858: IF error_status = 'F' THEN
859: FND_MESSAGE.SET_NAME('JE','JE_IT_NIF_INVALID');
860: g_vat_reg_error := FND_MESSAGE.get;
861: RETURN g_vat_reg_error;
862: END IF;
863:
856:
857: VALIDATE_NIF_IT (pv_taxpayer_id,'P',error_status,g_vat_reg_error);
858: IF error_status = 'F' THEN
859: FND_MESSAGE.SET_NAME('JE','JE_IT_NIF_INVALID');
860: g_vat_reg_error := FND_MESSAGE.get;
861: RETURN g_vat_reg_error;
862: END IF;
863:
864: END IF; --if8
872: EXCEPTION
873: WHEN others THEN
874: fnd_file.put_line(fnd_file.log,'Error in Taxpayer ID validation');
875: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);
876: FND_MESSAGE.SET_NAME('JE','JE_IT_NIF_INVALID');
877: g_vat_reg_error := FND_MESSAGE.get;
878: RETURN g_vat_reg_error;
879:
880: END validate_taxpayer_id;
873: WHEN others THEN
874: fnd_file.put_line(fnd_file.log,'Error in Taxpayer ID validation');
875: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);
876: FND_MESSAGE.SET_NAME('JE','JE_IT_NIF_INVALID');
877: g_vat_reg_error := FND_MESSAGE.get;
878: RETURN g_vat_reg_error;
879:
880: END validate_taxpayer_id;
881: