DBA Data[Home] [Help]

APPS.RLM_BLANKET_SV dependencies on RLM_MESSAGE_SV

Line 154: rlm_message_sv.app_error(

150: IF (l_debug <> -1) THEN
151: rlm_core_sv.dlog(C_DEBUG, 'Orphan record in RLM table, so recreate RSO and log exception');
152: END IF;
153: --
154: rlm_message_sv.app_error(
155: x_ExceptionLevel => rlm_message_sv.k_warn_level,
156: x_MessageName => 'RLM_ORPHAN_RSO_FOUND',
157: x_InterfaceHeaderId => x_Sched_rec.header_id,
158: x_InterfaceLineId => c_lines_rec.line_id,

Line 155: x_ExceptionLevel => rlm_message_sv.k_warn_level,

151: rlm_core_sv.dlog(C_DEBUG, 'Orphan record in RLM table, so recreate RSO and log exception');
152: END IF;
153: --
154: rlm_message_sv.app_error(
155: x_ExceptionLevel => rlm_message_sv.k_warn_level,
156: x_MessageName => 'RLM_ORPHAN_RSO_FOUND',
157: x_InterfaceHeaderId => x_Sched_rec.header_id,
158: x_InterfaceLineId => c_lines_rec.line_id,
159: x_ScheduleHeaderId => x_Sched_rec.schedule_header_id,

Line 252: rlm_message_sv.sql_error('RLM_BLANKET_SV.DeriveRSO', '040');

248: END IF;
249: --
250: WHEN OTHERS THEN
251: x_return_Status := RLM_CORE_SV.k_PROC_ERROR;
252: rlm_message_sv.sql_error('RLM_BLANKET_SV.DeriveRSO', '040');
253: --
254: IF (l_debug <> -1) THEN
255: rlm_core_sv.dlog(C_DEBUG, 'When others of DeriveRSO');
256: rlm_core_sv.dpop(C_SDEBUG,'DeriveRSO EXCEPTION: '||SUBSTR(SQLERRM,1,200));

Line 717: x_msg_count, rlm_message_sv.k_INFO_LEVEL,

713: x_token := 'INFO';
714: x_msg_name := 'RLM_RSO_CREATION_INFO';
715: --
716: RLM_TPA_SV.InsertOMMessages(x_Sched_rec, x_Group_rec,
717: x_msg_count, rlm_message_sv.k_INFO_LEVEL,
718: x_token, x_msg_name);
719: --
720: END IF;
721: --

Line 743: x_msg_count, rlm_message_sv.k_ERROR_LEVEL,

739: x_token := 'ERROR';
740: x_msg_name := 'RLM_RSO_CREATION_ERROR';
741: --
742: RLM_TPA_SV.InsertOMMessages(x_Sched_rec, x_Group_rec,
743: x_msg_count, rlm_message_sv.k_ERROR_LEVEL,
744: x_token, x_msg_name);
745: --
746: IF (l_debug <> -1) THEN
747: rlm_core_sv.dlog(C_DEBUG, 'RSO Creation Error: ' || x_msg_data);

Line 754: rlm_message_sv.sql_error('rlm_blanket_sv.CreateRSOHeader', v_progress);

750: --
751: RAISE e_RSOCreationError;
752: --
753: WHEN OTHERS THEN
754: rlm_message_sv.sql_error('rlm_blanket_sv.CreateRSOHeader', v_progress);
755: --
756: IF (l_debug <> -1) THEN
757: rlm_core_sv.dpop(C_SDEBUG, 'CreateRSOHeader');
758: END IF;

Line 810: rlm_message_sv.sql_error('rlm_blanket_sv.UpdateLinesWithRSO', v_Progress);

806: EXCEPTION
807: --
808: WHEN OTHERS THEN
809: --
810: rlm_message_sv.sql_error('rlm_blanket_sv.UpdateLinesWithRSO', v_Progress);
811: --
812: IF (l_debug <> -1) THEN
813: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
814: END IF;

Line 929: l_msg_level := rlm_message_sv.k_INFO_LEVEL;

925: IF x_msg_name = 'RLM_RSO_CREATION_ERROR' THEN
926: IF (l_type = 'ERROR') THEN
927: l_msg_level := x_msg_level;
928: ELSE
929: l_msg_level := rlm_message_sv.k_INFO_LEVEL;
930: END IF;
931: ELSE
932: l_msg_level := x_msg_level;
933: END IF;

Line 941: rlm_message_sv.app_error(

937: END IF;
938: --
939: --Bugfix 6884912 Start
940: IF g_req_flag = 1 THEN
941: rlm_message_sv.app_error(
942: x_ExceptionLevel => l_msg_level,
943: x_MessageName => x_msg_name,
944: x_InterfaceHeaderId => x_Sched_rec.header_id,
945: x_InterfaceLineId => v_InterfaceLineId,

Line 964: rlm_message_sv.app_error(

960: x_Value3 => RLM_VALIDATEDEMAND_SV.GetOrderNumber(l_header_id));
961:
962: ELSE
963: -- bug fix 4198330
964: rlm_message_sv.app_error(
965: x_ExceptionLevel => l_msg_level,
966: x_MessageName => x_msg_name,
967: x_InterfaceHeaderId => x_Sched_rec.header_id,
968: x_InterfaceLineId => v_InterfaceLineId,

Line 998: rlm_message_sv.sql_error('rlm_blanket_sv.InsertOMMessages', v_Progress);

994: EXCEPTION
995: --
996: WHEN OTHERS THEN
997: --
998: rlm_message_sv.sql_error('rlm_blanket_sv.InsertOMMessages', v_Progress);
999: --
1000: IF (l_debug <> -1) THEN
1001: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
1002: END IF;

Line 1105: rlm_message_sv.sql_error('rlm_blanket_sv.GetTPContext',v_Progress);

1101: END IF;
1102: --
1103: WHEN OTHERS THEN
1104: --
1105: rlm_message_sv.sql_error('rlm_blanket_sv.GetTPContext',v_Progress);
1106: --
1107: IF (l_debug <> -1) THEN
1108: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1109: END IF;