306:
307: UPDATE XDP_FA_RESUBMISSION_LOG
308: SET status_code = 'IN PROGRESS',
309: last_update_date = sysdate,
310: last_updated_by = fnd_global.user_id,
311: last_update_login = fnd_global.login_id
312: WHERE resubmission_job_id = l_ResubmissionJobID;
313:
314: EXCEPTION
307: UPDATE XDP_FA_RESUBMISSION_LOG
308: SET status_code = 'IN PROGRESS',
309: last_update_date = sysdate,
310: last_updated_by = fnd_global.user_id,
311: last_update_login = fnd_global.login_id
312: WHERE resubmission_job_id = l_ResubmissionJobID;
313:
314: EXCEPTION
315: WHEN others THEN
335: UPDATE XDP_FA_RESUBMISSION_LOG
336: SET status_code = 'SUCCESS',
337: completion_date = sysdate,
338: last_update_date = sysdate,
339: last_updated_by = fnd_global.user_id,
340: last_update_login = fnd_global.login_id
341: WHERE resubmission_job_id = l_ResubmissionJobID;
342:
343: EXCEPTION
336: SET status_code = 'SUCCESS',
337: completion_date = sysdate,
338: last_update_date = sysdate,
339: last_updated_by = fnd_global.user_id,
340: last_update_login = fnd_global.login_id
341: WHERE resubmission_job_id = l_ResubmissionJobID;
342:
343: EXCEPTION
344: WHEN others THEN