DBA Data[Home] [Help]

APPS.RLM_SHIP_DELIVERY_PATTERN_SV dependencies on RLM_MESSAGE_SV

Line 253: rlm_message_sv.get_msg_text('RLM_NULL_LEAD_TIME',

249: rlm_core_sv.dlog(g_DEBUG,' Lead time is NULL, ERROR condition');
250: END IF;
251: --
252: --v_ReturnMessage.
253: rlm_message_sv.get_msg_text('RLM_NULL_LEAD_TIME',
254: x_message);
255:
256: get_err_message(x_message, 'RLM_NULL_LEAD_TIME',-1, v_ReturnMessage);
257: --

Line 270: rlm_message_sv.get_msg_text('RLM_NULL_LEAD_TIME',

266: IF (l_debug <> -1) THEN
267: rlm_core_sv.dlog(g_DEBUG,' Lead time is NULL, WARNING condition');
268: END IF;
269: --
270: rlm_message_sv.get_msg_text('RLM_NULL_LEAD_TIME',
271: x_message);
272: get_err_message( x_message,'RLM_NULL_LEAD_TIME',0, v_ReturnMessage);
273: --
274: END IF;

Line 473: rlm_message_sv.get_msg_text(

469: -- Bug 2955782 : Added CUST_ITEM and QTY tokens to the message
470: -- RLM_SHIP_DATE_OUTOFSYNC.
471:
472: IF v_loop > 0 AND v_loop < 40 THEN --bug 3682051
473: rlm_message_sv.get_msg_text(
474: x_message_name => 'RLM_SHIP_DATE_OUTOFSYNC',
475: x_text => x_message,
476: x_token1 => 'SHIP_DATE',
477: x_value1 => v_temp_shipdate,

Line 510: rlm_message_sv.get_msg_text(

506: --
507: -- Bug 2955782 : Added CUST_ITEM and QTY tokens to the message
508: -- RLM_RECVD_DATE_CLOSED.
509:
510: rlm_message_sv.get_msg_text(
511: x_message_name => 'RLM_RECVD_DATE_CLOSED',
512: x_text => x_message,
513: x_token1 => 'CUST_ITEM',
514: x_value1 => rlm_core_sv.get_item_number(x_input.CustomerItemId),

Line 561: rlm_message_sv.get_msg_text(

557: --
558: -- Bug 2955782 : Added CUST_ITEM and QTY tokens to the message
559: -- RLM_SHIP_DATE_CLOSED.
560:
561: rlm_message_sv.get_msg_text(
562: x_message_name => 'RLM_SHIP_DATE_CLOSED',
563: x_text => x_message,
564: x_token1 => 'CUST_ITEM',
565: x_value1 => rlm_core_sv.get_item_number(x_input.CustomerItemId),

Line 600: rlm_message_sv.get_msg_text(

596: rlm_core_sv.dlog(g_DEBUG,'RLM_RECVD_DATE_CLOSED',
597: x_QuantityDate(i).PlannedReceiveDate);
598: END IF;
599:
600: rlm_message_sv.get_msg_text(
601: x_message_name => 'RLM_RECVD_DATE_CLOSED',
602: x_text => x_message,
603: x_token1 => 'CALENDAR',
604: x_value1 => v_Input.customer_rcv_calendar_cd,

Line 635: rlm_message_sv.get_msg_text(

631: --
632: WHEN e_ShpCalAPINULL THEN
633: --
634: set_return_status(x_ReturnStatus,g_Error);
635: rlm_message_sv.get_msg_text(
636: x_message_name => 'RLM_NO_SHP_CALENDAR',
637: x_text => x_message,
638: x_token1 => 'ORG',
639: x_value1 => rlm_core_sv.get_ship_from(v_Input.ShipFromOrgId));

Line 656: rlm_message_sv.get_msg_text(

652: --
653: WHEN e_RcvCalAPINULL THEN
654: --
655: set_return_status(x_ReturnStatus,g_Error);
656: rlm_message_sv.get_msg_text(
657: x_message_name => 'RLM_NO_RCV_CALENDAR',
658: x_text => x_message,
659: x_token1 => 'CUSTOMER',
660: x_value1 => rlm_core_sv.get_customer_name(v_Input.CustomerId));

Line 717: rlm_message_sv.get_msg_text(

713: --
714: -- Bug 3671477
715: --
716: set_return_status(x_ReturnStatus,g_Error);
717: rlm_message_sv.get_msg_text(
718: x_message_name => 'RLM_INVALID_SDP_INTRANSIT',
719: x_text => x_message);
720: get_err_message( x_message,'RLM_INVALID_SDP_INTRANSIT',-1, v_ReturnMessage);
721: x_ReturnMessage := v_ReturnMessage;

Line 749: rlm_message_sv.get_msg_text(

745: v_entity := rlm_core_sv.get_ship_from(v_Input.ShipFromOrgId);
746: ELSE
747: v_entity := rlm_core_sv.get_ship_to(v_Input.ShipToAddressId);
748: END IF;
749: rlm_message_sv.get_msg_text(
750: x_message_name => 'RLM_NO_LOCATION_CODE',
751: x_text => x_message,
752: x_token1 => 'ENTITY',
753: x_value1 => v_entity);

Line 783: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.calc_scheduled_ship_date', v_Progress);

779: END IF;
780: --
781: WHEN OTHERS THEN
782: --
783: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.calc_scheduled_ship_date', v_Progress);
784: --
785: IF (l_debug <> -1) THEN
786: rlm_core_sv.dpop(g_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
787: END IF;

Line 849: rlm_message_sv.get_msg_text(

845: --
846: /*WARNING RLM_INVALID_SDP*/
847: x_ReturnStatus := g_WARNING;
848: --
849: rlm_message_sv.get_msg_text(
850: x_message_name => 'RLM_INVALID_SDP',
851: x_text => x_message,
852: x_token1 => 'SDP_CODE',
853: x_value1 => x_SdpCode);

Line 864: rlm_message_sv.get_msg_text(

860: IF (l_debug <> -1) THEN
861: rlm_core_sv.dlog(g_DEBUG,'Error Default SDP is NULL');
862: END IF;
863: --
864: rlm_message_sv.get_msg_text(
865: x_message_name => 'RLM_NULL_SDP',
866: x_text => x_message,
867: x_token1 => 'SHIPFROM',
868: x_value1 => rlm_core_sv.get_ship_from(x_shipFromOrg),

Line 898: rlm_message_sv.get_msg_text(

894: IF (l_debug <> -1) THEN
895: rlm_core_sv.dlog(g_DEBUG,'Error Default SDP is NULL');
896: END IF;
897: --
898: rlm_message_sv.get_msg_text(
899: x_message_name => 'RLM_NULL_SDP',
900: x_text => x_message,
901: x_token1 => 'SHIPFROM',
902: x_value1 => rlm_core_sv.get_ship_from(x_shipFromOrg),

Line 914: rlm_message_sv.get_msg_text(

910: ELSE
911: x_SdpCode := DefaultSDP;
912: x_ReturnStatus := g_WARNING;
913: BEGIN
914: rlm_message_sv.get_msg_text(
915: x_message_name => 'RLM_NULL_SDP_ON_EDI',
916: x_text => x_message,
917: x_token1 => 'SHIPFROM',
918: x_value1 => rlm_core_sv.get_ship_from(x_shipFromOrg),

Line 963: rlm_message_sv.get_msg_text(

959: --
960: /*ERROR RLM_NULL_SDP*/
961: x_SdpCode := DefaultSDP;
962: x_ReturnStatus := g_ERROR;
963: rlm_message_sv.get_msg_text(
964: x_message_name => 'RLM_NULL_SDP',
965: x_text => x_message,
966: x_token1 => 'SHIPFROM',
967: x_value1 => rlm_core_sv.get_ship_from(x_shipFromOrg),

Line 1003: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.determine_sdp_code'

999: --
1000: WHEN OTHERS THEN
1001: --
1002: x_ReturnStatus := g_ERROR;
1003: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.determine_sdp_code'
1004: ,v_Progress);
1005: IF (l_debug <> -1) THEN
1006: rlm_core_sv.dpop(g_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1007: END IF;

Line 1122: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.find_daily_percent', v_Progress);

1118: EXCEPTION
1119: --
1120: WHEN NO_DATA_FOUND THEN
1121: --
1122: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.find_daily_percent', v_Progress);
1123: --
1124: IF (l_debug <> -1) THEN
1125: rlm_core_sv.dlog(g_DEBUG,'EXCEPTION: When no data found sql error');
1126: rlm_core_sv.dpop(g_SDEBUG);

Line 1133: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.find_daily_percent', v_Progress);

1129: raise;
1130: --
1131: WHEN OTHERS THEN
1132: --
1133: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.find_daily_percent', v_Progress);
1134: --
1135: IF (l_debug <> -1) THEN
1136: rlm_core_sv.dpop(g_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1137: END IF;

Line 1449: rlm_message_sv.get_msg_text(x_message_name => 'RLM_INVALID_DATE_FOR_BUCKET',

1445: IF (l_debug <> -1) THEN
1446: rlm_core_sv.dlog(g_DEBUG,' x_ReturnStatus ',x_ReturnStatus);
1447: END IF;
1448: --
1449: rlm_message_sv.get_msg_text(x_message_name => 'RLM_INVALID_DATE_FOR_BUCKET',
1450: x_text => x_message,
1451: x_token1 => 'START_DATE',
1452: x_value1 => x_Input.StartDateTime,
1453: x_token2 => 'BUCKET',

Line 1677: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.apply_sdp_to_weekly_bucket', v_Progress);

1673: EXCEPTION
1674: --
1675: WHEN OTHERS THEN
1676: --
1677: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.apply_sdp_to_weekly_bucket', v_Progress);
1678: --
1679: IF (l_debug <> -1) THEN
1680: rlm_core_sv.dpop(g_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1681: END IF;

Line 2489: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.GetTPContext',v_Progress);

2485: END IF;
2486: --
2487: WHEN OTHERS THEN
2488: --
2489: rlm_message_sv.sql_error('rlm_ship_delivery_pattern_sv.GetTPContext',v_Progress);
2490: --
2491: IF (l_debug <> -1) THEN
2492: rlm_core_sv.dpop(g_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2493: END IF;