APPS.HZ_IMP_LOAD_STAGE1 dependencies on FND_FILE

Line 24: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 1 WORKER_PROCESS+');

20: l_pp_status VARCHAR2(30);
21:
22: BEGIN
23:
24: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 1 WORKER_PROCESS+');
25:
26: /* Avoid skip scans in matching */
27: execute immediate 'alter session set events ''10196 trace name context forever, level 1''';
28:

Line 35: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_OS = ' || P_OS);

31: -- Bug 4594407
32: HZ_IMP_LOAD_WRAPPER.RETRIEVE_WORK_UNIT(P_BATCH_ID, '1' , P_OS, P_FROM_OSR, P_TO_OSR,
33: l_hwm_stage, l_pp_status);
34:
35: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_OS = ' || P_OS);
36: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);
37: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);
38:
39:

Line 36: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);

32: HZ_IMP_LOAD_WRAPPER.RETRIEVE_WORK_UNIT(P_BATCH_ID, '1' , P_OS, P_FROM_OSR, P_TO_OSR,
33: l_hwm_stage, l_pp_status);
34:
35: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_OS = ' || P_OS);
36: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);
37: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);
38:
39:
40: IF (P_OS IS NULL) Then

Line 37: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);

33: l_hwm_stage, l_pp_status);
34:
35: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_OS = ' || P_OS);
36: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_FROM_OSR = ' || P_FROM_OSR);
37: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_TO_OSR = ' || P_TO_OSR);
38:
39:
40: IF (P_OS IS NULL) Then
41: EXIT;

Line 85: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 1 WORKER_PROCESS-');

81: COMMIT;
82:
83: END LOOP;
84:
85: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Stage 1 WORKER_PROCESS-');
86:
87: RETURN;
88:
89: EXCEPTION

Line 111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in stage 1 worker: ' || SQLERRM);

107: WHERE batch_id = P_BATCH_ID);
108:
109: COMMIT;
110:
111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception in stage 1 worker: ' || SQLERRM);
112:
113: END WORKER_PROCESS;
114:
115: