DBA Data[Home] [Help]

APPS.RLM_AD_SV dependencies on RLM_MESSAGE_SV

Line 265: rlm_message_sv.app_error(

261: IF (l_debug <> -1) THEN
262: rlm_core_sv.dlog(C_DEBUG, 'Null Org ID found at header level');
263: END IF;
264: --
265: rlm_message_sv.app_error(
266: x_ExceptionLevel => rlm_message_sv.k_error_level,
267: x_MessageName => 'RLM_OU_CONTEXT_NOT_SET',
268: x_InterfaceHeaderId => x_InterfaceHeaderId,
269: x_ScheduleHeaderId => x_RLMScheduleID);

Line 266: x_ExceptionLevel => rlm_message_sv.k_error_level,

262: rlm_core_sv.dlog(C_DEBUG, 'Null Org ID found at header level');
263: END IF;
264: --
265: rlm_message_sv.app_error(
266: x_ExceptionLevel => rlm_message_sv.k_error_level,
267: x_MessageName => 'RLM_OU_CONTEXT_NOT_SET',
268: x_InterfaceHeaderId => x_InterfaceHeaderId,
269: x_ScheduleHeaderId => x_RLMScheduleID);
270: --

Line 278: rlm_message_sv.sql_error ('rlm_archive_demand_sv.Archive_Headers',

274: --
275: RETURN FALSE;
276: --
277: WHEN OTHERS THEN
278: rlm_message_sv.sql_error ('rlm_archive_demand_sv.Archive_Headers',
279: x_progress);
280: IF (l_debug <> -1) THEN
281: --
282: rlm_core_sv.dlog(C_DEBUG,'x_progress',x_progress);

Line 856: SET request_id = rlm_message_sv.g_conc_req_id,

852: --
853: ELSE
854: --
855: UPDATE rlm_schedule_lines_all
856: SET request_id = rlm_message_sv.g_conc_req_id,
857: interface_line_id = c_rec.interface_line_id,
858: order_header_id = c_rec.order_header_id,
859: blanket_number = c_rec.blanket_number,
860: last_update_date = sysdate,

Line 926: rlm_message_sv.app_error(

922: IF (l_debug <> -1) THEN
923: rlm_core_sv.dlog(C_DEBUG, 'Null Org ID found');
924: END IF;
925: --
926: rlm_message_sv.app_error(
927: x_ExceptionLevel => rlm_message_sv.k_error_level,
928: x_MessageName => 'RLM_OU_CONTEXT_NOT_SET',
929: x_InterfaceHeaderId => x_InterfaceHeaderId,
930: x_ScheduleHeaderId => x_RLMScheduleID);

Line 927: x_ExceptionLevel => rlm_message_sv.k_error_level,

923: rlm_core_sv.dlog(C_DEBUG, 'Null Org ID found');
924: END IF;
925: --
926: rlm_message_sv.app_error(
927: x_ExceptionLevel => rlm_message_sv.k_error_level,
928: x_MessageName => 'RLM_OU_CONTEXT_NOT_SET',
929: x_InterfaceHeaderId => x_InterfaceHeaderId,
930: x_ScheduleHeaderId => x_RLMScheduleID);
931: --

Line 939: rlm_message_sv.sql_error ('rlm_archive_demand_sv.Archive_Lines', x_progress);

935: --
936: RETURN FALSE;
937: --
938: WHEN OTHERS THEN
939: rlm_message_sv.sql_error ('rlm_archive_demand_sv.Archive_Lines', x_progress);
940: IF (l_debug <> -1) THEN
941: rlm_core_sv.dlog(C_DEBUG,'Error',sqlerrm);
942: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: OTHER - sql error');
943: END IF;

Line 981: rlm_core_sv.dlog(C_DEBUG, 'request_id ',rlm_message_sv.g_conc_req_id );

977: --
978: IF (l_debug <> -1) THEN
979: rlm_core_sv.dlog(C_DEBUG, 'Schedule Header Already Archived',
980: c_rec.schedule_header_id);
981: rlm_core_sv.dlog(C_DEBUG, 'request_id ',rlm_message_sv.g_conc_req_id );
982: END IF;
983: --
984: Update rlm_schedule_headers_all
985: SET request_id = rlm_message_sv.g_conc_req_id ,

Line 985: SET request_id = rlm_message_sv.g_conc_req_id ,

981: rlm_core_sv.dlog(C_DEBUG, 'request_id ',rlm_message_sv.g_conc_req_id );
982: END IF;
983: --
984: Update rlm_schedule_headers_all
985: SET request_id = rlm_message_sv.g_conc_req_id ,
986: last_update_date = sysdate,
987: last_updated_by = fnd_global.user_id
988: WHERE header_id = c_rec.schedule_header_id;
989: --

Line 998: SET request_id = rlm_message_sv.g_conc_req_id ,

994: -- The lines are updated in Archive Lines no need to do this again
995: --
996: /*
997: Update rlm_schedule_lines
998: SET request_id = rlm_message_sv.g_conc_req_id ,
999: last_update_date = sysdate,
1000: last_updated_by = fnd_global.user_id
1001: WHERE header_id = c_rec.schedule_header_id;
1002: --

Line 1092: rlm_message_sv.sql_error ('rlm_archive_demand_sv.Archive_demand',

1088: return TRUE;
1089: --
1090: EXCEPTION
1091: WHEN OTHERS THEN
1092: rlm_message_sv.sql_error ('rlm_archive_demand_sv.Archive_demand',
1093: x_progress);
1094: IF (l_debug <> -1) THEN
1095: rlm_core_sv.dlog(C_DEBUG,'x_progress',x_progress);
1096: rlm_core_sv.dlog(C_DEBUG,'Error',sqlerrm);