61: END IF;
62:
63: xProgress := 'SPSO-10-1005';
64: BEGIN
65: SELECT ece_output_runs_s.NEXTVAL
66: INTO p_run_id
67: FROM sys.dual;
68: EXCEPTION
69: WHEN NO_DATA_FOUND THEN
72: 'ECE_GET_NEXT_SEQ_FAILED',
73: 'PROGRESS_LEVEL',
74: xProgress,
75: 'SEQ',
76: 'ECE_OUTPUT_RUNS_S' );
77: END;
78: ec_debug.pl ( 3, 'p_run_id: ',p_run_id );
79:
80: xProgress := 'SPSO-10-1010';
331: END IF;
332:
333: xProgress := 'SSSO-10-1005';
334: BEGIN
335: SELECT ece_output_runs_s.NEXTVAL
336: INTO p_run_id
337: FROM sys.dual;
338: EXCEPTION
339: WHEN NO_DATA_FOUND THEN
342: 'ECE_GET_NEXT_SEQ_FAILED',
343: 'PROGRESS_LEVEL',
344: xProgress,
345: 'SEQ',
346: 'ECE_OUTPUT_RUNS_S' );
347: END;
348: ec_debug.pl(3, 'p_run_id: ',p_run_id);
349:
350: xProgress := 'SSSO-10-1010';