389: FROM dual;
390:
391:
392: CURSOR c_get_packet_id IS
393: SELECT gl_bc_packets_s.NEXTVAL
394: FROM dual;
395:
396: --local Variables
397: l_log_module VARCHAR2(240);
438: else
439: CLOSE c_get_arrival_seq;
440: l_packet_id := -1;
441: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
442: fnd_message.set_token('SEQUENCE', 'GL_BC_PACKETS_S');
443: app_exception.raise_exception;
444: END IF;
445:
446: --
705: ELSE
706: CLOSE c_get_packet_id;
707: l_packet_id := -1;
708: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
709: fnd_message.set_token('SEQUENCE', 'GL_BC_PACKETS_S');
710: app_exception.raise_exception;
711: END IF;
712:
713: RETURN l_packet_id;