DBA Data[Home] [Help]

APPS.RLM_EXTINTERFACE_SV dependencies on RLM_MESSAGE_SV

Line 377: x_msg_count,rlm_message_sv.k_warn_level,

373: x_msg_name := 'RLM_PROCESS_ORDER_WARN';
374: --
375: InsertOMMessages(x_header_id,
376: x_Op_tab(1).customer_item_id,
377: x_msg_count,rlm_message_sv.k_warn_level,
378: x_token,
379: x_msg_name);
380: --
381: END IF;

Line 398: x_msg_count,rlm_message_sv.k_error_level,

394: x_msg_name := 'RLM_OE_API_FAILED';
395: --
396: InsertOMMessages(x_header_id,
397: x_Op_tab(1).customer_item_id,
398: x_msg_count,rlm_message_sv.k_error_level,
399: x_token,
400: x_msg_name);
401: --
402: IF x_Op_tab(1).schedule_type = k_SEQUENCED THEN/*2342919*/

Line 490: rlm_message_sv.app_error(

486: OPEN get_ship_to_address(x_Op_Tab(1).ship_to_org_id);
487: FETCH get_ship_to_address INTO l_location_code ;
488: CLOSE get_ship_to_address;
489:
490: rlm_message_sv.app_error(
491: x_ExceptionLevel => rlm_message_sv.k_error_level,
492: x_MessageName => 'RLM_LOCK_OE_LINES_GROUP',
493: x_InterfaceHeaderId => x_header_id,
494: x_InterfaceLineId => NULL,

Line 491: x_ExceptionLevel => rlm_message_sv.k_error_level,

487: FETCH get_ship_to_address INTO l_location_code ;
488: CLOSE get_ship_to_address;
489:
490: rlm_message_sv.app_error(
491: x_ExceptionLevel => rlm_message_sv.k_error_level,
492: x_MessageName => 'RLM_LOCK_OE_LINES_GROUP',
493: x_InterfaceHeaderId => x_header_id,
494: x_InterfaceLineId => NULL,
495: x_ScheduleHeaderId => x_Op_Tab(1).schedule_header_id,

Line 515: rlm_message_sv.app_error(

511: END IF;
512: --
513: WHEN e_BuildOELineTab THEN
514: --
515: rlm_message_sv.app_error(
516: x_ExceptionLevel => rlm_message_sv.k_error_level,
517: x_MessageName => 'RLM_BUILD_OE_LINE_TAB',
518: x_InterfaceHeaderId => x_header_id,
519: x_InterfaceLineId => NULL,

Line 516: x_ExceptionLevel => rlm_message_sv.k_error_level,

512: --
513: WHEN e_BuildOELineTab THEN
514: --
515: rlm_message_sv.app_error(
516: x_ExceptionLevel => rlm_message_sv.k_error_level,
517: x_MessageName => 'RLM_BUILD_OE_LINE_TAB',
518: x_InterfaceHeaderId => x_header_id,
519: x_InterfaceLineId => NULL,
520: x_ScheduleHeaderId => x_Op_Tab(1).schedule_header_id,

Line 727: l_msg_level := rlm_message_sv.k_info_level;

723: --
724: IF l_type = 'ERROR' THEN
725: l_msg_level := x_msg_level;
726: ELSE
727: l_msg_level := rlm_message_sv.k_info_level;
728: END IF;
729: --
730: ELSE
731: l_msg_level := x_msg_level;

Line 738: rlm_message_sv.app_error(

734: IF (l_debug<> -1) THEN
735: rlm_core_sv.dlog(k_DEBUG, 'l_msg_level', l_msg_level);
736: END IF;
737: --
738: rlm_message_sv.app_error(
739: x_ExceptionLevel => l_msg_level,
740: x_MessageName => x_msg_name,
741: x_InterfaceHeaderId => x_header_id,
742: x_InterfaceLineId => v_interface_line_id,

Line 769: rlm_message_sv.app_error(

765: IF (l_debug <> -1) THEN
766: rlm_core_sv.dlog(k_DEBUG, 'Inserting RLM_PROCESS_ORDER_ERROR_E msg');
767: END IF;
768: --
769: rlm_message_sv.app_error(
770: x_ExceptionLevel => rlm_message_sv.k_error_level,
771: x_MessageName => 'RLM_PROCESS_ORDER_ERROR_E',
772: x_InterfaceHeaderId => x_header_id,
773: x_InterfaceLineId => NULL,

Line 770: x_ExceptionLevel => rlm_message_sv.k_error_level,

766: rlm_core_sv.dlog(k_DEBUG, 'Inserting RLM_PROCESS_ORDER_ERROR_E msg');
767: END IF;
768: --
769: rlm_message_sv.app_error(
770: x_ExceptionLevel => rlm_message_sv.k_error_level,
771: x_MessageName => 'RLM_PROCESS_ORDER_ERROR_E',
772: x_InterfaceHeaderId => x_header_id,
773: x_InterfaceLineId => NULL,
774: x_ScheduleHeaderId => NULL,

Line 960: x_msg_level := rlm_message_sv.k_warn_level;

956: --x_Qty_rec.reconcile := l_line_out_Tbl(1).ordered_quantity;
957: --x_Qty_rec.available_to_cancel := l_line_out_Tbl(1).ordered_quantity;
958: --x_Qty_rec.shipped := l_line_out_Tbl(1).shipped_quantity;
959: --
960: x_msg_level := rlm_message_sv.k_warn_level;
961: x_msg_name := 'RLM_PROC_CONS_FOUND';
962: x_Token := 'CONSTRAINT';
963: --
964: IF (l_debug <> -1) THEN

Line 1005: x_msg_level := rlm_message_sv.k_warn_level;

1001: rlm_core_sv.dlog(k_DEBUG,'dem_rec.line_id',
1002: x_Key_rec.dem_rec.line_id);
1003: END IF;
1004: --
1005: x_msg_level := rlm_message_sv.k_warn_level;
1006: x_msg_name := 'RLM_OE_API_ERROR';
1007: x_Token := 'CONSTRAINT';
1008: --
1009: InsertOMMessages(x_Key_rec.req_rec.header_id,x_Key_rec.req_rec.customer_item_id,x_msg_count,

Line 1183: rlm_message_sv.app_error(

1179: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );
1180: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1181: END IF;
1182: --
1183: rlm_message_sv.app_error(
1184: x_ExceptionLevel => rlm_message_sv.k_error_level,
1185: x_MessageName => 'RLM_INTRANSIT_API_FAILED',
1186: x_InterfaceHeaderId => x_header_id,
1187: x_InterfaceLineId => NULL,

Line 1184: x_ExceptionLevel => rlm_message_sv.k_error_level,

1180: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1181: END IF;
1182: --
1183: rlm_message_sv.app_error(
1184: x_ExceptionLevel => rlm_message_sv.k_error_level,
1185: x_MessageName => 'RLM_INTRANSIT_API_FAILED',
1186: x_InterfaceHeaderId => x_header_id,
1187: x_InterfaceLineId => NULL,
1188: x_ScheduleHeaderId =>NULL,

Line 1212: rlm_message_sv.app_error(

1208: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );
1209: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1210: END IF;
1211: --
1212: rlm_message_sv.app_error(
1213: x_ExceptionLevel => rlm_message_sv.k_error_level,
1214: x_MessageName => 'RLM_INTRANSIT_API_FAILED',
1215: x_InterfaceHeaderId => x_header_id,
1216: x_InterfaceLineId => NULL,

Line 1213: x_ExceptionLevel => rlm_message_sv.k_error_level,

1209: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1210: END IF;
1211: --
1212: rlm_message_sv.app_error(
1213: x_ExceptionLevel => rlm_message_sv.k_error_level,
1214: x_MessageName => 'RLM_INTRANSIT_API_FAILED',
1215: x_InterfaceHeaderId => x_header_id,
1216: x_InterfaceLineId => NULL,
1217: x_ScheduleHeaderId =>NULL,

Line 1323: rlm_message_sv.app_error(

1319: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1320: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1321: END IF;
1322: --
1323: rlm_message_sv.app_error(
1324: x_ExceptionLevel => rlm_message_sv.k_error_level,
1325: x_MessageName => 'RLM_WSH_CONSTRAINT_API_FAILED',
1326: x_InterfaceHeaderId => x_header_id,
1327: x_InterfaceLineId => NULL,

Line 1324: x_ExceptionLevel => rlm_message_sv.k_error_level,

1320: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1321: END IF;
1322: --
1323: rlm_message_sv.app_error(
1324: x_ExceptionLevel => rlm_message_sv.k_error_level,
1325: x_MessageName => 'RLM_WSH_CONSTRAINT_API_FAILED',
1326: x_InterfaceHeaderId => x_header_id,
1327: x_InterfaceLineId => NULL,
1328: x_ScheduleHeaderId =>NULL,

Line 1354: rlm_message_sv.app_error(

1350: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1351: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1352: END IF;
1353: --
1354: rlm_message_sv.app_error(
1355: x_ExceptionLevel => rlm_message_sv.k_error_level,
1356: x_MessageName => 'RLM_WSH_CONSTRAINT_API_FAILED',
1357: x_InterfaceHeaderId => x_header_id,
1358: x_InterfaceLineId => NULL,

Line 1355: x_ExceptionLevel => rlm_message_sv.k_error_level,

1351: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1352: END IF;
1353: --
1354: rlm_message_sv.app_error(
1355: x_ExceptionLevel => rlm_message_sv.k_error_level,
1356: x_MessageName => 'RLM_WSH_CONSTRAINT_API_FAILED',
1357: x_InterfaceHeaderId => x_header_id,
1358: x_InterfaceLineId => NULL,
1359: x_ScheduleHeaderId =>NULL,

Line 2309: rlm_message_sv.sql_error('rlm_validatedemand_sv.GetTPContext',v_Progress);

2305: END IF;
2306: --
2307: WHEN OTHERS THEN
2308: --
2309: rlm_message_sv.sql_error('rlm_validatedemand_sv.GetTPContext',v_Progress);
2310: --
2311: IF (l_debug <> -1) THEN
2312: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2313: END IF;