525:
526:
527: CURSOR get_next_rank_id IS
528: SELECT fte_carrier_rank_list_s.nextval
529: FROM sys.dual;
530:
531: l_temp_id NUMBER;
532: EMPTY_TRIP_ID EXCEPTION;
533: EMPTY_RANK_SEQUENCE EXCEPTION;
3320: EXCEPTION
3321: WHEN NO_DATA_FOUND THEN
3322:
3323: SELECT FTE_CARRIER_RANK_LIST_S.NEXTVAL INTO
3324: p_ranklist.RANK_ID(i) FROM DUAL;
3325:
3326: IF l_debug_on
3327: THEN
3328: Log(l_module_name,' Rank Id ' || p_ranklist.RANK_ID(i) || ' i value ' || i,