199:
200: BEGIN
201:
202: DELETE
203: FROM FV_SF1080_HEADER_TEMP;
204: ---FV_UTILITY.DEBUG_MESG('Deleting from FV_SF1080_HEADER_TEMP');
205: EXCEPTION
206: WHEN NO_DATA_FOUND THEN
207: NULL;
200: BEGIN
201:
202: DELETE
203: FROM FV_SF1080_HEADER_TEMP;
204: ---FV_UTILITY.DEBUG_MESG('Deleting from FV_SF1080_HEADER_TEMP');
205: EXCEPTION
206: WHEN NO_DATA_FOUND THEN
207: NULL;
208: WHEN OTHERS THEN
381: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error3',g_error_message);
382: END;
383:
384: Begin
385: INSERT INTO FV_SF1080_HEADER_TEMP
386: ( CUSTOMER_TRX_ID,
387: TRX_NUMBER,
388: CUSTOMER_NAME,
389: CUST_ADDRESS1,