355: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
356: END;
357: BEGIN
358: SELECT
359: JE_NO_GEI_CONTROLS_S.NEXTVAL
360: INTO TMP_NUMBER
361: FROM
362: DUAL;
363: TMP_TEXT := TO_CHAR(TMP_NUMBER);
598: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
599: DBMS_SESSION.SET_SQL_TRACE(FALSE);
600: END;
601: BEGIN
602: INSERT INTO JE_NO_GEI_CONTROLS
603: (ORDER_NUMBER
604: ,CREATED_BY
605: ,CREATION_DATE
606: ,LAST_UPDATED_BY
614: ,FND_GLOBAL.LOGIN_ID);
615: EXCEPTION
616: WHEN OTHERS THEN
617: /*SRW.MESSAGE('118'
618: ,'Unable to assign values to JE_NO_GEI_CONTROLS')*/NULL;
619: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
620: END;
621: COMMIT;
622: END P_INSERT_PERIOD_NAME;