90: RETURN 'TRUE';
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:
107: VALUES
108: (appl_id,
109: col_data);
110: gn_row_inserted := gn_row_inserted + 1;
111: fnd_file.put_line(fnd_file.log,'Rows Inserted:'||gn_row_inserted);
112: EXCEPTION
113: WHEN others THEN
114: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);
115: END insert_into_table;
110: gn_row_inserted := gn_row_inserted + 1;
111: fnd_file.put_line(fnd_file.log,'Rows Inserted:'||gn_row_inserted);
112: EXCEPTION
113: WHEN others THEN
114: fnd_file.put_line(fnd_file.log,'Error Message:'||SQLERRM||'Error Code:'||SQLCODE);
115: END insert_into_table;
116:
117: PROCEDURE concatenate(pv_code VARCHAR2, pv_field VARCHAR2, pn_appl_id NUMBER)
118: AS
870: RETURN 'TRUE';
871:
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;
871:
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: