329: where task_seq = last_task;
330:
331: else
332: --log no tasks found
333: FND_MESSAGE.SET_NAME('ZPB','ZPB_WRITEMGR_NO_TASKS_FOUND');
334: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
335: end if;
336:
337: --remove records timed by ZPB_WRITEBACK_TABLE_NUMBER_OF_DAYS profile
330:
331: else
332: --log no tasks found
333: FND_MESSAGE.SET_NAME('ZPB','ZPB_WRITEMGR_NO_TASKS_FOUND');
334: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
335: end if;
336:
337: --remove records timed by ZPB_WRITEBACK_TABLE_NUMBER_OF_DAYS profile
338: l_remove_old_records;
547: BEGIN
548: ZPB_AW.EXECUTE(v_task.token);
549: EXCEPTION
550: WHEN OTHERS THEN
551: fnd_message.set_name('ZPB','ZPB_MNTDATASEC_FAILED');
552:
553: l_status := fnd_message.get;
554: l_err_msg := SQLERRM;
555:
549: EXCEPTION
550: WHEN OTHERS THEN
551: fnd_message.set_name('ZPB','ZPB_MNTDATASEC_FAILED');
552:
553: l_status := fnd_message.get;
554: l_err_msg := SQLERRM;
555:
556: IF INSTR(v_task.token, 'ReadAccess',1) > 0 THEN
557:
1110: END IF;
1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: fnd_message.set_name('ZPB','ZPB_WRITEMGR_AW_CREATE_FAILED');
1115: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1116:
1117: retcode := 2;
1118:
1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: fnd_message.set_name('ZPB','ZPB_WRITEMGR_AW_CREATE_FAILED');
1115: fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
1116:
1117: retcode := 2;
1118:
1119: END process_create_personal_aw;