657: END IF;
658: --
659: /*
660: ** Obtain the exception id from the
661: ** sequence rlm_demand_exceptions_s .
662: */
663: --
664: SELECT rlm_demand_exceptions_s.nextval
665: INTO v_ExceptionId
660: ** Obtain the exception id from the
661: ** sequence rlm_demand_exceptions_s .
662: */
663: --
664: SELECT rlm_demand_exceptions_s.nextval
665: INTO v_ExceptionId
666: FROM sys.dual;
667: --
668: /*
748: --rlm_core_sv.dlog(C_DEBUG, 'ST', v_ShipTo);
749: --rlm_core_sv.dlog(C_DEBUG, 'BT', v_BillTo);
750: --rlm_core_sv.dlog(C_DEBUG, 'IST', v_IntrmdShipTo);
751: --
752: INSERT INTO RLM_DEMAND_EXCEPTIONS
753: (
754: exception_id,
755: exception_level,
756: message_name,
986:
987:
988: /*
989: ** Obtain the exception id from the
990: ** sequence rlm_demand_exceptions_s .
991: */
992:
993: SELECT rlm_demand_exceptions_s.nextval
994: INTO v_ExceptionId
989: ** Obtain the exception id from the
990: ** sequence rlm_demand_exceptions_s .
991: */
992:
993: SELECT rlm_demand_exceptions_s.nextval
994: INTO v_ExceptionId
995: FROM sys.dual;
996:
997:
1026:
1027:
1028: v_progress := '020';
1029:
1030: INSERT INTO RLM_DEMAND_EXCEPTIONS(
1031: exception_id,
1032: exception_level,
1033: message_name,
1034: message_text,