eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RLM_XML_API dependencies on RLM_CORE_SV

Line 17: rlm_core_sv.start_debug(x_SchedType || '-' || l_Timer);

13: --
14: SELECT hsecs INTO l_Timer FROM v$timer;
15: --
16: IF (l_debug <> -1) THEN
17: rlm_core_sv.start_debug(x_SchedType || '-' || l_Timer);
18: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.ValidateScheduleType');
19: rlm_core_sv.dlog(C_DEBUG, 'x_SchedType', x_SchedType);
20: END IF;
21: --

Line 18: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.ValidateScheduleType');

14: SELECT hsecs INTO l_Timer FROM v$timer;
15: --
16: IF (l_debug <> -1) THEN
17: rlm_core_sv.start_debug(x_SchedType || '-' || l_Timer);
18: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.ValidateScheduleType');
19: rlm_core_sv.dlog(C_DEBUG, 'x_SchedType', x_SchedType);
20: END IF;
21: --
22: IF (UPPER(x_SchedType) <> k_DEMAND) THEN

Line 19: rlm_core_sv.dlog(C_DEBUG, 'x_SchedType', x_SchedType);

15: --
16: IF (l_debug <> -1) THEN
17: rlm_core_sv.start_debug(x_SchedType || '-' || l_Timer);
18: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.ValidateScheduleType');
19: rlm_core_sv.dlog(C_DEBUG, 'x_SchedType', x_SchedType);
20: END IF;
21: --
22: IF (UPPER(x_SchedType) <> k_DEMAND) THEN
23: --

Line 33: rlm_core_sv.dlog(C_DEBUG, 'x_RetCode', x_RetCode);

29: --
30: END IF;
31: --
32: IF (l_debug <> -1) THEN
33: rlm_core_sv.dlog(C_DEBUG, 'x_RetCode', x_RetCode);
34: rlm_core_sv.dpop(C_SDEBUG);
35: END IF;
36: --
37: END ValidateScheduleType;

Line 34: rlm_core_sv.dpop(C_SDEBUG);

30: END IF;
31: --
32: IF (l_debug <> -1) THEN
33: rlm_core_sv.dlog(C_DEBUG, 'x_RetCode', x_RetCode);
34: rlm_core_sv.dpop(C_SDEBUG);
35: END IF;
36: --
37: END ValidateScheduleType;
38:

Line 67: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.SetSSSILineDetails');

63:
64: BEGIN
65: --
66: IF (l_debug <> -1) THEN
67: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.SetSSSILineDetails');
68: rlm_core_sv.dlog(C_DEBUG, 'x_LineType', x_LineType);
69: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);
70: rlm_core_sv.dlog(C_DEBUG, 'x_ReqdDt', to_char(x_ReqdDt, 'DD-MON-YYYY HH24:MI:SS'));
71: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));

Line 68: rlm_core_sv.dlog(C_DEBUG, 'x_LineType', x_LineType);

64: BEGIN
65: --
66: IF (l_debug <> -1) THEN
67: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.SetSSSILineDetails');
68: rlm_core_sv.dlog(C_DEBUG, 'x_LineType', x_LineType);
69: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);
70: rlm_core_sv.dlog(C_DEBUG, 'x_ReqdDt', to_char(x_ReqdDt, 'DD-MON-YYYY HH24:MI:SS'));
71: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
72: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));

Line 69: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);

65: --
66: IF (l_debug <> -1) THEN
67: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.SetSSSILineDetails');
68: rlm_core_sv.dlog(C_DEBUG, 'x_LineType', x_LineType);
69: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);
70: rlm_core_sv.dlog(C_DEBUG, 'x_ReqdDt', to_char(x_ReqdDt, 'DD-MON-YYYY HH24:MI:SS'));
71: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
72: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));
73: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);

Line 70: rlm_core_sv.dlog(C_DEBUG, 'x_ReqdDt', to_char(x_ReqdDt, 'DD-MON-YYYY HH24:MI:SS'));

66: IF (l_debug <> -1) THEN
67: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.SetSSSILineDetails');
68: rlm_core_sv.dlog(C_DEBUG, 'x_LineType', x_LineType);
69: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);
70: rlm_core_sv.dlog(C_DEBUG, 'x_ReqdDt', to_char(x_ReqdDt, 'DD-MON-YYYY HH24:MI:SS'));
71: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
72: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));
73: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);
74: rlm_core_sv.dlog(C_DEBUG, 'x_ShipQty and UOM', x_ShipQty || '-' || x_ShipUOM);

Line 71: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));

67: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.SetSSSILineDetails');
68: rlm_core_sv.dlog(C_DEBUG, 'x_LineType', x_LineType);
69: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);
70: rlm_core_sv.dlog(C_DEBUG, 'x_ReqdDt', to_char(x_ReqdDt, 'DD-MON-YYYY HH24:MI:SS'));
71: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
72: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));
73: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);
74: rlm_core_sv.dlog(C_DEBUG, 'x_ShipQty and UOM', x_ShipQty || '-' || x_ShipUOM);
75: rlm_core_sv.dlog(C_DEBUG, 'x_ItemQty and UOM', x_ItemQty || '-' || x_ItemUOM);

Line 72: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));

68: rlm_core_sv.dlog(C_DEBUG, 'x_LineType', x_LineType);
69: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);
70: rlm_core_sv.dlog(C_DEBUG, 'x_ReqdDt', to_char(x_ReqdDt, 'DD-MON-YYYY HH24:MI:SS'));
71: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
72: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));
73: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);
74: rlm_core_sv.dlog(C_DEBUG, 'x_ShipQty and UOM', x_ShipQty || '-' || x_ShipUOM);
75: rlm_core_sv.dlog(C_DEBUG, 'x_ItemQty and UOM', x_ItemQty || '-' || x_ItemUOM);
76: END IF;

Line 73: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);

69: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);
70: rlm_core_sv.dlog(C_DEBUG, 'x_ReqdDt', to_char(x_ReqdDt, 'DD-MON-YYYY HH24:MI:SS'));
71: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
72: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));
73: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);
74: rlm_core_sv.dlog(C_DEBUG, 'x_ShipQty and UOM', x_ShipQty || '-' || x_ShipUOM);
75: rlm_core_sv.dlog(C_DEBUG, 'x_ItemQty and UOM', x_ItemQty || '-' || x_ItemUOM);
76: END IF;
77: --

Line 74: rlm_core_sv.dlog(C_DEBUG, 'x_ShipQty and UOM', x_ShipQty || '-' || x_ShipUOM);

70: rlm_core_sv.dlog(C_DEBUG, 'x_ReqdDt', to_char(x_ReqdDt, 'DD-MON-YYYY HH24:MI:SS'));
71: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
72: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));
73: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);
74: rlm_core_sv.dlog(C_DEBUG, 'x_ShipQty and UOM', x_ShipQty || '-' || x_ShipUOM);
75: rlm_core_sv.dlog(C_DEBUG, 'x_ItemQty and UOM', x_ItemQty || '-' || x_ItemUOM);
76: END IF;
77: --
78: IF (UPPER(x_LineType) IN ('0', '1', '2') OR x_LineType is NULL) THEN

Line 75: rlm_core_sv.dlog(C_DEBUG, 'x_ItemQty and UOM', x_ItemQty || '-' || x_ItemUOM);

71: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
72: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));
73: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);
74: rlm_core_sv.dlog(C_DEBUG, 'x_ShipQty and UOM', x_ShipQty || '-' || x_ShipUOM);
75: rlm_core_sv.dlog(C_DEBUG, 'x_ItemQty and UOM', x_ItemQty || '-' || x_ItemUOM);
76: END IF;
77: --
78: IF (UPPER(x_LineType) IN ('0', '1', '2') OR x_LineType is NULL) THEN
79: --

Line 143: rlm_core_sv.dpop(C_SDEBUG);

139: --
140: END IF;
141: --
142: IF (l_debug <> -1) THEN
143: rlm_core_sv.dpop(C_SDEBUG);
144: END IF;
145: --
146: EXCEPTION
147: WHEN e_IncompleteData THEN

Line 151: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Required Data not on schedule');

147: WHEN e_IncompleteData THEN
148: x_ErrCode := x_ErrCode + 1;
149: x_ErrMsg := x_ErrMsg || ' Required data not present on schedule';
150: IF (l_debug <> -1) THEN
151: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Required Data not on schedule');
152: rlm_core_sv.dpop(C_SDEBUG);
153: END IF;
154:
155: WHEN e_UnknownData THEN

Line 152: rlm_core_sv.dpop(C_SDEBUG);

148: x_ErrCode := x_ErrCode + 1;
149: x_ErrMsg := x_ErrMsg || ' Required data not present on schedule';
150: IF (l_debug <> -1) THEN
151: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Required Data not on schedule');
152: rlm_core_sv.dpop(C_SDEBUG);
153: END IF;
154:
155: WHEN e_UnknownData THEN
156: x_ErrCode := x_ErrCode + 1;

Line 159: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unknown line type = ' || x_LineType);

155: WHEN e_UnknownData THEN
156: x_ErrCode := x_ErrCode + 1;
157: x_ErrMsg := x_ErrMsg || ' Unknown linetype ''' || x_LineType || '''';
158: IF (l_debug <> -1) THEN
159: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unknown line type = ' || x_LineType);
160: rlm_core_sv.dpop(C_SDEBUG);
161: END IF;
162:
163: WHEN OTHERS THEN

Line 160: rlm_core_sv.dpop(C_SDEBUG);

156: x_ErrCode := x_ErrCode + 1;
157: x_ErrMsg := x_ErrMsg || ' Unknown linetype ''' || x_LineType || '''';
158: IF (l_debug <> -1) THEN
159: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unknown line type = ' || x_LineType);
160: rlm_core_sv.dpop(C_SDEBUG);
161: END IF;
162:
163: WHEN OTHERS THEN
164: x_ErrCode := x_ErrCode + 1;

Line 167: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unknown error in SetSSSILineDetails');

163: WHEN OTHERS THEN
164: x_ErrCode := x_ErrCode + 1;
165: x_ErrMsg := x_ErrMsg || ' Unknown error in SetSSSILineDetails';
166: IF (l_debug <> -1) THEN
167: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unknown error in SetSSSILineDetails');
168: rlm_core_sv.dpop(C_SDEBUG);
169: END IF;
170: raise ecx_utils.PROGRAM_EXIT;
171:

Line 168: rlm_core_sv.dpop(C_SDEBUG);

164: x_ErrCode := x_ErrCode + 1;
165: x_ErrMsg := x_ErrMsg || ' Unknown error in SetSSSILineDetails';
166: IF (l_debug <> -1) THEN
167: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unknown error in SetSSSILineDetails');
168: rlm_core_sv.dpop(C_SDEBUG);
169: END IF;
170: raise ecx_utils.PROGRAM_EXIT;
171:
172: END SetSSSILineDetails;

Line 203: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.SetSPSILineDetails');

199: --
200: BEGIN
201: --
202: IF (l_debug <> -1) THEN
203: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.SetSPSILineDetails');
204: rlm_core_sv.dlog(C_DEBUG, 'x_LineType', x_LineType);
205: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);
206: rlm_core_sv.dlog(C_DEBUG, 'x_BktType', x_BktType);
207: rlm_core_sv.dlog(C_DEBUG, 'x_FromDt', to_char(x_FromDt, 'DD-MON-YYYY HH24:MI:SS'));

Line 204: rlm_core_sv.dlog(C_DEBUG, 'x_LineType', x_LineType);

200: BEGIN
201: --
202: IF (l_debug <> -1) THEN
203: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.SetSPSILineDetails');
204: rlm_core_sv.dlog(C_DEBUG, 'x_LineType', x_LineType);
205: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);
206: rlm_core_sv.dlog(C_DEBUG, 'x_BktType', x_BktType);
207: rlm_core_sv.dlog(C_DEBUG, 'x_FromDt', to_char(x_FromDt, 'DD-MON-YYYY HH24:MI:SS'));
208: rlm_core_sv.dlog(C_DEBUG, 'x_ToDt', to_char(x_ToDt, 'DD-MON-YYYY HH24:MI:SS'));

Line 205: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);

201: --
202: IF (l_debug <> -1) THEN
203: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.SetSPSILineDetails');
204: rlm_core_sv.dlog(C_DEBUG, 'x_LineType', x_LineType);
205: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);
206: rlm_core_sv.dlog(C_DEBUG, 'x_BktType', x_BktType);
207: rlm_core_sv.dlog(C_DEBUG, 'x_FromDt', to_char(x_FromDt, 'DD-MON-YYYY HH24:MI:SS'));
208: rlm_core_sv.dlog(C_DEBUG, 'x_ToDt', to_char(x_ToDt, 'DD-MON-YYYY HH24:MI:SS'));
209: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));

Line 206: rlm_core_sv.dlog(C_DEBUG, 'x_BktType', x_BktType);

202: IF (l_debug <> -1) THEN
203: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.SetSPSILineDetails');
204: rlm_core_sv.dlog(C_DEBUG, 'x_LineType', x_LineType);
205: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);
206: rlm_core_sv.dlog(C_DEBUG, 'x_BktType', x_BktType);
207: rlm_core_sv.dlog(C_DEBUG, 'x_FromDt', to_char(x_FromDt, 'DD-MON-YYYY HH24:MI:SS'));
208: rlm_core_sv.dlog(C_DEBUG, 'x_ToDt', to_char(x_ToDt, 'DD-MON-YYYY HH24:MI:SS'));
209: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
210: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));

Line 207: rlm_core_sv.dlog(C_DEBUG, 'x_FromDt', to_char(x_FromDt, 'DD-MON-YYYY HH24:MI:SS'));

203: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.SetSPSILineDetails');
204: rlm_core_sv.dlog(C_DEBUG, 'x_LineType', x_LineType);
205: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);
206: rlm_core_sv.dlog(C_DEBUG, 'x_BktType', x_BktType);
207: rlm_core_sv.dlog(C_DEBUG, 'x_FromDt', to_char(x_FromDt, 'DD-MON-YYYY HH24:MI:SS'));
208: rlm_core_sv.dlog(C_DEBUG, 'x_ToDt', to_char(x_ToDt, 'DD-MON-YYYY HH24:MI:SS'));
209: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
210: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));
211: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);

Line 208: rlm_core_sv.dlog(C_DEBUG, 'x_ToDt', to_char(x_ToDt, 'DD-MON-YYYY HH24:MI:SS'));

204: rlm_core_sv.dlog(C_DEBUG, 'x_LineType', x_LineType);
205: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);
206: rlm_core_sv.dlog(C_DEBUG, 'x_BktType', x_BktType);
207: rlm_core_sv.dlog(C_DEBUG, 'x_FromDt', to_char(x_FromDt, 'DD-MON-YYYY HH24:MI:SS'));
208: rlm_core_sv.dlog(C_DEBUG, 'x_ToDt', to_char(x_ToDt, 'DD-MON-YYYY HH24:MI:SS'));
209: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
210: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));
211: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);
212: rlm_core_sv.dlog(C_DEBUG, 'x_ShipQty and UOM', x_ShipQty || '-' || x_ShipUOM);

Line 209: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));

205: rlm_core_sv.dlog(C_DEBUG, 'x_DateType', x_DateType);
206: rlm_core_sv.dlog(C_DEBUG, 'x_BktType', x_BktType);
207: rlm_core_sv.dlog(C_DEBUG, 'x_FromDt', to_char(x_FromDt, 'DD-MON-YYYY HH24:MI:SS'));
208: rlm_core_sv.dlog(C_DEBUG, 'x_ToDt', to_char(x_ToDt, 'DD-MON-YYYY HH24:MI:SS'));
209: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
210: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));
211: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);
212: rlm_core_sv.dlog(C_DEBUG, 'x_ShipQty and UOM', x_ShipQty || '-' || x_ShipUOM);
213: rlm_core_sv.dlog(C_DEBUG, 'x_ItemQty and UOM', x_ItemQty || '-' || x_ItemUOM);

Line 210: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));

206: rlm_core_sv.dlog(C_DEBUG, 'x_BktType', x_BktType);
207: rlm_core_sv.dlog(C_DEBUG, 'x_FromDt', to_char(x_FromDt, 'DD-MON-YYYY HH24:MI:SS'));
208: rlm_core_sv.dlog(C_DEBUG, 'x_ToDt', to_char(x_ToDt, 'DD-MON-YYYY HH24:MI:SS'));
209: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
210: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));
211: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);
212: rlm_core_sv.dlog(C_DEBUG, 'x_ShipQty and UOM', x_ShipQty || '-' || x_ShipUOM);
213: rlm_core_sv.dlog(C_DEBUG, 'x_ItemQty and UOM', x_ItemQty || '-' || x_ItemUOM);
214: END IF;

Line 211: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);

207: rlm_core_sv.dlog(C_DEBUG, 'x_FromDt', to_char(x_FromDt, 'DD-MON-YYYY HH24:MI:SS'));
208: rlm_core_sv.dlog(C_DEBUG, 'x_ToDt', to_char(x_ToDt, 'DD-MON-YYYY HH24:MI:SS'));
209: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
210: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));
211: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);
212: rlm_core_sv.dlog(C_DEBUG, 'x_ShipQty and UOM', x_ShipQty || '-' || x_ShipUOM);
213: rlm_core_sv.dlog(C_DEBUG, 'x_ItemQty and UOM', x_ItemQty || '-' || x_ItemUOM);
214: END IF;
215:

Line 212: rlm_core_sv.dlog(C_DEBUG, 'x_ShipQty and UOM', x_ShipQty || '-' || x_ShipUOM);

208: rlm_core_sv.dlog(C_DEBUG, 'x_ToDt', to_char(x_ToDt, 'DD-MON-YYYY HH24:MI:SS'));
209: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
210: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));
211: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);
212: rlm_core_sv.dlog(C_DEBUG, 'x_ShipQty and UOM', x_ShipQty || '-' || x_ShipUOM);
213: rlm_core_sv.dlog(C_DEBUG, 'x_ItemQty and UOM', x_ItemQty || '-' || x_ItemUOM);
214: END IF;
215:
216: --

Line 213: rlm_core_sv.dlog(C_DEBUG, 'x_ItemQty and UOM', x_ItemQty || '-' || x_ItemUOM);

209: rlm_core_sv.dlog(C_DEBUG, 'x_RecdDt', to_char(x_RecdDt, 'DD-MON-YYYY HH24:MI:SS'));
210: rlm_core_sv.dlog(C_DEBUG, 'x_ShipDt', to_char(x_ShipDt, 'DD-MON-YYYY HH24:MI:SS'));
211: rlm_core_sv.dlog(C_DEBUG, 'x_RecdQty and UOM', x_RecdQty || '-' || x_RecdUOM);
212: rlm_core_sv.dlog(C_DEBUG, 'x_ShipQty and UOM', x_ShipQty || '-' || x_ShipUOM);
213: rlm_core_sv.dlog(C_DEBUG, 'x_ItemQty and UOM', x_ItemQty || '-' || x_ItemUOM);
214: END IF;
215:
216: --
217: IF (UPPER(x_LineType) IN ('0', '1', '2') OR x_LineType IS NULL) THEN

Line 285: rlm_core_sv.dpop(C_SDEBUG);

281: --
282: END IF;
283: --
284: IF (l_debug <> -1) THEN
285: rlm_core_sv.dpop(C_SDEBUG);
286: END IF;
287: --
288: EXCEPTION
289: WHEN e_IncompleteData THEN

Line 293: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Required Data not present on schedule');

289: WHEN e_IncompleteData THEN
290: x_ErrCode := x_ErrCode + 1;
291: x_ErrMsg := x_ErrMsg || ' Required data not on schedule';
292: IF (l_debug <> -1) THEN
293: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Required Data not present on schedule');
294: rlm_core_sv.dpop(C_SDEBUG);
295: END IF;
296:
297: WHEN e_UnknownData THEN

Line 294: rlm_core_sv.dpop(C_SDEBUG);

290: x_ErrCode := x_ErrCode + 1;
291: x_ErrMsg := x_ErrMsg || ' Required data not on schedule';
292: IF (l_debug <> -1) THEN
293: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Required Data not present on schedule');
294: rlm_core_sv.dpop(C_SDEBUG);
295: END IF;
296:
297: WHEN e_UnknownData THEN
298: x_ErrCode := x_ErrCode + 1;

Line 301: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unknown linetype = '|| x_LineType);

297: WHEN e_UnknownData THEN
298: x_ErrCode := x_ErrCode + 1;
299: x_ErrMsg := x_ErrMsg || ' Unknown linetype ''' || x_LineType || '''';
300: IF (l_debug <> -1) THEN
301: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unknown linetype = '|| x_LineType);
302: rlm_core_sv.dpop(C_SDEBUG);
303: END IF;
304:
305: WHEN OTHERS THEN

Line 302: rlm_core_sv.dpop(C_SDEBUG);

298: x_ErrCode := x_ErrCode + 1;
299: x_ErrMsg := x_ErrMsg || ' Unknown linetype ''' || x_LineType || '''';
300: IF (l_debug <> -1) THEN
301: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unknown linetype = '|| x_LineType);
302: rlm_core_sv.dpop(C_SDEBUG);
303: END IF;
304:
305: WHEN OTHERS THEN
306: x_ErrCode := x_ErrCode + 1;

Line 309: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unknown error in SetSPSILineDetails');

305: WHEN OTHERS THEN
306: x_ErrCode := x_ErrCode + 1;
307: x_ErrMsg := x_ErrMsg || ' Unknown error in SetSPSILineDetails';
308: IF (l_debug <> -1) THEN
309: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unknown error in SetSPSILineDetails');
310: rlm_core_sv.dpop(C_SDEBUG);
311: END IF;
312: raise ecx_utils.PROGRAM_EXIT;
313:

Line 310: rlm_core_sv.dpop(C_SDEBUG);

306: x_ErrCode := x_ErrCode + 1;
307: x_ErrMsg := x_ErrMsg || ' Unknown error in SetSPSILineDetails';
308: IF (l_debug <> -1) THEN
309: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unknown error in SetSPSILineDetails');
310: rlm_core_sv.dpop(C_SDEBUG);
311: END IF;
312: raise ecx_utils.PROGRAM_EXIT;
313:
314: END SetSPSILineDetails;

Line 329: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.SetScheduleItemNum');

325: --
326: BEGIN
327: --
328: IF (l_debug <> -1) THEN
329: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.SetScheduleItemNum');
330: END IF;
331: --
332: g_SchedItemTab.DELETE;
333: --

Line 339: rlm_core_sv.dlog(C_DEBUG, '# of rows in g_SchedItemTab ', g_SchedItemTab.COUNT);

335: --
336: PrintSchedItemTab;
337: --
338: IF (l_debug <> -1) THEN
339: rlm_core_sv.dlog(C_DEBUG, '# of rows in g_SchedItemTab ', g_SchedItemTab.COUNT);
340: END IF;
341: --
342: FOR i IN 1..g_SchedItemTab.COUNT LOOP
343: --

Line 372: rlm_core_sv.dlog(C_DEBUG, '# of rows updated', SQL%ROWCOUNT);

368: --
369: x_SchedItemNum := x_SchedItemNum + 1;
370: --
371: IF (l_debug <> -1) THEN
372: rlm_core_sv.dlog(C_DEBUG, '# of rows updated', SQL%ROWCOUNT);
373: END IF;
374: --
375: END LOOP;
376: --

Line 378: rlm_core_sv.dpop(C_SDEBUG);

374: --
375: END LOOP;
376: --
377: IF (l_debug <> -1) THEN
378: rlm_core_sv.dpop(C_SDEBUG);
379: END IF;
380: --
381: EXCEPTION
382: --

Line 388: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unknown error in SetScheduleItemNum');

384: --
385: x_ErrCode := x_ErrCode + 1;
386: x_ErrMsg := x_ErrMsg || ' Unknown error in RLM_XML_API.SetScheduleItemNum';
387: IF (l_debug <> -1) THEN
388: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unknown error in SetScheduleItemNum');
389: rlm_core_sv.dpop(C_SDEBUG);
390: END IF;
391: --
392: END SetScheduleItemNum;

Line 389: rlm_core_sv.dpop(C_SDEBUG);

385: x_ErrCode := x_ErrCode + 1;
386: x_ErrMsg := x_ErrMsg || ' Unknown error in RLM_XML_API.SetScheduleItemNum';
387: IF (l_debug <> -1) THEN
388: rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unknown error in SetScheduleItemNum');
389: rlm_core_sv.dpop(C_SDEBUG);
390: END IF;
391: --
392: END SetScheduleItemNum;
393:

Line 400: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.PrintSchedItemTab');

396: --
397: BEGIN
398: --
399: IF (l_debug <> -1) THEN
400: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.PrintSchedItemTab');
401: END IF;
402: --
403: FOR i in 1..g_SchedItemTab.COUNT LOOP
404: --

Line 406: rlm_core_sv.dlog(C_DEBUG, '--------------------------------------------');

402: --
403: FOR i in 1..g_SchedItemTab.COUNT LOOP
404: --
405: IF (l_debug <> -1) THEN
406: rlm_core_sv.dlog(C_DEBUG, '--------------------------------------------');
407: rlm_core_sv.dlog(C_DEBUG, 'Index', i);
408: rlm_core_sv.dlog(C_DEBUG,'Ship From', g_SchedItemTab(i).ship_from_ext);
409: rlm_core_sv.dlog(C_DEBUG,'Ship To', g_SchedItemTab(i).ship_to_ext);
410: rlm_core_sv.dlog(C_DEBUG,'Bill To', g_SchedItemTab(i).bill_to_ext);

Line 407: rlm_core_sv.dlog(C_DEBUG, 'Index', i);

403: FOR i in 1..g_SchedItemTab.COUNT LOOP
404: --
405: IF (l_debug <> -1) THEN
406: rlm_core_sv.dlog(C_DEBUG, '--------------------------------------------');
407: rlm_core_sv.dlog(C_DEBUG, 'Index', i);
408: rlm_core_sv.dlog(C_DEBUG,'Ship From', g_SchedItemTab(i).ship_from_ext);
409: rlm_core_sv.dlog(C_DEBUG,'Ship To', g_SchedItemTab(i).ship_to_ext);
410: rlm_core_sv.dlog(C_DEBUG,'Bill To', g_SchedItemTab(i).bill_to_ext);
411: rlm_core_sv.dlog(C_DEBUG,'Cust Item', g_SchedItemTab(i).cust_item_ext);

Line 408: rlm_core_sv.dlog(C_DEBUG,'Ship From', g_SchedItemTab(i).ship_from_ext);

404: --
405: IF (l_debug <> -1) THEN
406: rlm_core_sv.dlog(C_DEBUG, '--------------------------------------------');
407: rlm_core_sv.dlog(C_DEBUG, 'Index', i);
408: rlm_core_sv.dlog(C_DEBUG,'Ship From', g_SchedItemTab(i).ship_from_ext);
409: rlm_core_sv.dlog(C_DEBUG,'Ship To', g_SchedItemTab(i).ship_to_ext);
410: rlm_core_sv.dlog(C_DEBUG,'Bill To', g_SchedItemTab(i).bill_to_ext);
411: rlm_core_sv.dlog(C_DEBUG,'Cust Item', g_SchedItemTab(i).cust_item_ext);
412: rlm_core_sv.dlog(C_DEBUG,'Item Desc', g_SchedItemTab(i).item_desc_ext);

Line 409: rlm_core_sv.dlog(C_DEBUG,'Ship To', g_SchedItemTab(i).ship_to_ext);

405: IF (l_debug <> -1) THEN
406: rlm_core_sv.dlog(C_DEBUG, '--------------------------------------------');
407: rlm_core_sv.dlog(C_DEBUG, 'Index', i);
408: rlm_core_sv.dlog(C_DEBUG,'Ship From', g_SchedItemTab(i).ship_from_ext);
409: rlm_core_sv.dlog(C_DEBUG,'Ship To', g_SchedItemTab(i).ship_to_ext);
410: rlm_core_sv.dlog(C_DEBUG,'Bill To', g_SchedItemTab(i).bill_to_ext);
411: rlm_core_sv.dlog(C_DEBUG,'Cust Item', g_SchedItemTab(i).cust_item_ext);
412: rlm_core_sv.dlog(C_DEBUG,'Item Desc', g_SchedItemTab(i).item_desc_ext);
413: rlm_core_sv.dlog(C_DEBUG,'Dock Code', g_SchedItemTab(i).cust_dock_code);

Line 410: rlm_core_sv.dlog(C_DEBUG,'Bill To', g_SchedItemTab(i).bill_to_ext);

406: rlm_core_sv.dlog(C_DEBUG, '--------------------------------------------');
407: rlm_core_sv.dlog(C_DEBUG, 'Index', i);
408: rlm_core_sv.dlog(C_DEBUG,'Ship From', g_SchedItemTab(i).ship_from_ext);
409: rlm_core_sv.dlog(C_DEBUG,'Ship To', g_SchedItemTab(i).ship_to_ext);
410: rlm_core_sv.dlog(C_DEBUG,'Bill To', g_SchedItemTab(i).bill_to_ext);
411: rlm_core_sv.dlog(C_DEBUG,'Cust Item', g_SchedItemTab(i).cust_item_ext);
412: rlm_core_sv.dlog(C_DEBUG,'Item Desc', g_SchedItemTab(i).item_desc_ext);
413: rlm_core_sv.dlog(C_DEBUG,'Dock Code', g_SchedItemTab(i).cust_dock_code);
414: rlm_core_sv.dlog(C_DEBUG,'Haz Code', g_SchedItemTab(i).hazrd_code_ext);

Line 411: rlm_core_sv.dlog(C_DEBUG,'Cust Item', g_SchedItemTab(i).cust_item_ext);

407: rlm_core_sv.dlog(C_DEBUG, 'Index', i);
408: rlm_core_sv.dlog(C_DEBUG,'Ship From', g_SchedItemTab(i).ship_from_ext);
409: rlm_core_sv.dlog(C_DEBUG,'Ship To', g_SchedItemTab(i).ship_to_ext);
410: rlm_core_sv.dlog(C_DEBUG,'Bill To', g_SchedItemTab(i).bill_to_ext);
411: rlm_core_sv.dlog(C_DEBUG,'Cust Item', g_SchedItemTab(i).cust_item_ext);
412: rlm_core_sv.dlog(C_DEBUG,'Item Desc', g_SchedItemTab(i).item_desc_ext);
413: rlm_core_sv.dlog(C_DEBUG,'Dock Code', g_SchedItemTab(i).cust_dock_code);
414: rlm_core_sv.dlog(C_DEBUG,'Haz Code', g_SchedItemTab(i).hazrd_code_ext);
415: rlm_core_sv.dlog(C_DEBUG,'Item Rev', g_SchedItemTab(i).cust_item_rev);

Line 412: rlm_core_sv.dlog(C_DEBUG,'Item Desc', g_SchedItemTab(i).item_desc_ext);

408: rlm_core_sv.dlog(C_DEBUG,'Ship From', g_SchedItemTab(i).ship_from_ext);
409: rlm_core_sv.dlog(C_DEBUG,'Ship To', g_SchedItemTab(i).ship_to_ext);
410: rlm_core_sv.dlog(C_DEBUG,'Bill To', g_SchedItemTab(i).bill_to_ext);
411: rlm_core_sv.dlog(C_DEBUG,'Cust Item', g_SchedItemTab(i).cust_item_ext);
412: rlm_core_sv.dlog(C_DEBUG,'Item Desc', g_SchedItemTab(i).item_desc_ext);
413: rlm_core_sv.dlog(C_DEBUG,'Dock Code', g_SchedItemTab(i).cust_dock_code);
414: rlm_core_sv.dlog(C_DEBUG,'Haz Code', g_SchedItemTab(i).hazrd_code_ext);
415: rlm_core_sv.dlog(C_DEBUG,'Item Rev', g_SchedItemTab(i).cust_item_rev);
416: rlm_core_sv.dlog(C_DEBUG,'Item Note', g_SchedItemTab(i).item_note_text);

Line 413: rlm_core_sv.dlog(C_DEBUG,'Dock Code', g_SchedItemTab(i).cust_dock_code);

409: rlm_core_sv.dlog(C_DEBUG,'Ship To', g_SchedItemTab(i).ship_to_ext);
410: rlm_core_sv.dlog(C_DEBUG,'Bill To', g_SchedItemTab(i).bill_to_ext);
411: rlm_core_sv.dlog(C_DEBUG,'Cust Item', g_SchedItemTab(i).cust_item_ext);
412: rlm_core_sv.dlog(C_DEBUG,'Item Desc', g_SchedItemTab(i).item_desc_ext);
413: rlm_core_sv.dlog(C_DEBUG,'Dock Code', g_SchedItemTab(i).cust_dock_code);
414: rlm_core_sv.dlog(C_DEBUG,'Haz Code', g_SchedItemTab(i).hazrd_code_ext);
415: rlm_core_sv.dlog(C_DEBUG,'Item Rev', g_SchedItemTab(i).cust_item_rev);
416: rlm_core_sv.dlog(C_DEBUG,'Item Note', g_SchedItemTab(i).item_note_text);
417: rlm_core_sv.dlog(C_DEBUG,'PO Num', g_SchedItemTab(i).cust_po_num);

Line 414: rlm_core_sv.dlog(C_DEBUG,'Haz Code', g_SchedItemTab(i).hazrd_code_ext);

410: rlm_core_sv.dlog(C_DEBUG,'Bill To', g_SchedItemTab(i).bill_to_ext);
411: rlm_core_sv.dlog(C_DEBUG,'Cust Item', g_SchedItemTab(i).cust_item_ext);
412: rlm_core_sv.dlog(C_DEBUG,'Item Desc', g_SchedItemTab(i).item_desc_ext);
413: rlm_core_sv.dlog(C_DEBUG,'Dock Code', g_SchedItemTab(i).cust_dock_code);
414: rlm_core_sv.dlog(C_DEBUG,'Haz Code', g_SchedItemTab(i).hazrd_code_ext);
415: rlm_core_sv.dlog(C_DEBUG,'Item Rev', g_SchedItemTab(i).cust_item_rev);
416: rlm_core_sv.dlog(C_DEBUG,'Item Note', g_SchedItemTab(i).item_note_text);
417: rlm_core_sv.dlog(C_DEBUG,'PO Num', g_SchedItemTab(i).cust_po_num);
418: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', g_SchedItemTab(i).cust_po_linnum);

Line 415: rlm_core_sv.dlog(C_DEBUG,'Item Rev', g_SchedItemTab(i).cust_item_rev);

411: rlm_core_sv.dlog(C_DEBUG,'Cust Item', g_SchedItemTab(i).cust_item_ext);
412: rlm_core_sv.dlog(C_DEBUG,'Item Desc', g_SchedItemTab(i).item_desc_ext);
413: rlm_core_sv.dlog(C_DEBUG,'Dock Code', g_SchedItemTab(i).cust_dock_code);
414: rlm_core_sv.dlog(C_DEBUG,'Haz Code', g_SchedItemTab(i).hazrd_code_ext);
415: rlm_core_sv.dlog(C_DEBUG,'Item Rev', g_SchedItemTab(i).cust_item_rev);
416: rlm_core_sv.dlog(C_DEBUG,'Item Note', g_SchedItemTab(i).item_note_text);
417: rlm_core_sv.dlog(C_DEBUG,'PO Num', g_SchedItemTab(i).cust_po_num);
418: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', g_SchedItemTab(i).cust_po_linnum);
419: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', g_SchedItemTab(i).cust_po_relnum);

Line 416: rlm_core_sv.dlog(C_DEBUG,'Item Note', g_SchedItemTab(i).item_note_text);

412: rlm_core_sv.dlog(C_DEBUG,'Item Desc', g_SchedItemTab(i).item_desc_ext);
413: rlm_core_sv.dlog(C_DEBUG,'Dock Code', g_SchedItemTab(i).cust_dock_code);
414: rlm_core_sv.dlog(C_DEBUG,'Haz Code', g_SchedItemTab(i).hazrd_code_ext);
415: rlm_core_sv.dlog(C_DEBUG,'Item Rev', g_SchedItemTab(i).cust_item_rev);
416: rlm_core_sv.dlog(C_DEBUG,'Item Note', g_SchedItemTab(i).item_note_text);
417: rlm_core_sv.dlog(C_DEBUG,'PO Num', g_SchedItemTab(i).cust_po_num);
418: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', g_SchedItemTab(i).cust_po_linnum);
419: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', g_SchedItemTab(i).cust_po_relnum);
420: rlm_core_sv.dlog(C_DEBUG,'PO Date', g_SchedItemTab(i).cust_po_date);

Line 417: rlm_core_sv.dlog(C_DEBUG,'PO Num', g_SchedItemTab(i).cust_po_num);

413: rlm_core_sv.dlog(C_DEBUG,'Dock Code', g_SchedItemTab(i).cust_dock_code);
414: rlm_core_sv.dlog(C_DEBUG,'Haz Code', g_SchedItemTab(i).hazrd_code_ext);
415: rlm_core_sv.dlog(C_DEBUG,'Item Rev', g_SchedItemTab(i).cust_item_rev);
416: rlm_core_sv.dlog(C_DEBUG,'Item Note', g_SchedItemTab(i).item_note_text);
417: rlm_core_sv.dlog(C_DEBUG,'PO Num', g_SchedItemTab(i).cust_po_num);
418: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', g_SchedItemTab(i).cust_po_linnum);
419: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', g_SchedItemTab(i).cust_po_relnum);
420: rlm_core_sv.dlog(C_DEBUG,'PO Date', g_SchedItemTab(i).cust_po_date);
421: rlm_core_sv.dlog(C_DEBUG,'Sup Item', g_SchedItemTab(i).sup_item_ext);

Line 418: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', g_SchedItemTab(i).cust_po_linnum);

414: rlm_core_sv.dlog(C_DEBUG,'Haz Code', g_SchedItemTab(i).hazrd_code_ext);
415: rlm_core_sv.dlog(C_DEBUG,'Item Rev', g_SchedItemTab(i).cust_item_rev);
416: rlm_core_sv.dlog(C_DEBUG,'Item Note', g_SchedItemTab(i).item_note_text);
417: rlm_core_sv.dlog(C_DEBUG,'PO Num', g_SchedItemTab(i).cust_po_num);
418: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', g_SchedItemTab(i).cust_po_linnum);
419: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', g_SchedItemTab(i).cust_po_relnum);
420: rlm_core_sv.dlog(C_DEBUG,'PO Date', g_SchedItemTab(i).cust_po_date);
421: rlm_core_sv.dlog(C_DEBUG,'Sup Item', g_SchedItemTab(i).sup_item_ext);
422: END IF;

Line 419: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', g_SchedItemTab(i).cust_po_relnum);

415: rlm_core_sv.dlog(C_DEBUG,'Item Rev', g_SchedItemTab(i).cust_item_rev);
416: rlm_core_sv.dlog(C_DEBUG,'Item Note', g_SchedItemTab(i).item_note_text);
417: rlm_core_sv.dlog(C_DEBUG,'PO Num', g_SchedItemTab(i).cust_po_num);
418: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', g_SchedItemTab(i).cust_po_linnum);
419: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', g_SchedItemTab(i).cust_po_relnum);
420: rlm_core_sv.dlog(C_DEBUG,'PO Date', g_SchedItemTab(i).cust_po_date);
421: rlm_core_sv.dlog(C_DEBUG,'Sup Item', g_SchedItemTab(i).sup_item_ext);
422: END IF;
423: --

Line 420: rlm_core_sv.dlog(C_DEBUG,'PO Date', g_SchedItemTab(i).cust_po_date);

416: rlm_core_sv.dlog(C_DEBUG,'Item Note', g_SchedItemTab(i).item_note_text);
417: rlm_core_sv.dlog(C_DEBUG,'PO Num', g_SchedItemTab(i).cust_po_num);
418: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', g_SchedItemTab(i).cust_po_linnum);
419: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', g_SchedItemTab(i).cust_po_relnum);
420: rlm_core_sv.dlog(C_DEBUG,'PO Date', g_SchedItemTab(i).cust_po_date);
421: rlm_core_sv.dlog(C_DEBUG,'Sup Item', g_SchedItemTab(i).sup_item_ext);
422: END IF;
423: --
424: END LOOP;

Line 421: rlm_core_sv.dlog(C_DEBUG,'Sup Item', g_SchedItemTab(i).sup_item_ext);

417: rlm_core_sv.dlog(C_DEBUG,'PO Num', g_SchedItemTab(i).cust_po_num);
418: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', g_SchedItemTab(i).cust_po_linnum);
419: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', g_SchedItemTab(i).cust_po_relnum);
420: rlm_core_sv.dlog(C_DEBUG,'PO Date', g_SchedItemTab(i).cust_po_date);
421: rlm_core_sv.dlog(C_DEBUG,'Sup Item', g_SchedItemTab(i).sup_item_ext);
422: END IF;
423: --
424: END LOOP;
425: --

Line 427: rlm_core_sv.dpop(C_SDEBUG);

423: --
424: END LOOP;
425: --
426: IF (l_debug <> -1) THEN
427: rlm_core_sv.dpop(C_SDEBUG);
428: END IF;
429: --
430: END PrintSchedItemTab;
431:

Line 459: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.InitializeSchedItemTab');

455: --
456: BEGIN
457: --
458: IF (l_debug <> -1) THEN
459: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.InitializeSchedItemTab');
460: END IF;
461: --
462: OPEN c_ItemAttribs;
463: FETCH c_ItemAttribs INTO c_ItemAttribsRec;

Line 480: rlm_core_sv.dpop(C_SDEBUG);

476: --
477: CLOSE c_ItemAttribs; --bug 4570658
478:
479: IF (l_debug <> -1) THEN
480: rlm_core_sv.dpop(C_SDEBUG);
481: END IF;
482: --
483: END InitializeSchedItemTab;
484:

Line 495: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.IsDuplicate');

491: --
492: BEGIN
493: --
494: IF (l_debug <> -1) THEN
495: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.IsDuplicate');
496: END IF;
497: --
498: /*
499: IF (l_debug <> -1) THEN

Line 500: rlm_core_sv.dlog(C_DEBUG, 'Printing attribs rec');

496: END IF;
497: --
498: /*
499: IF (l_debug <> -1) THEN
500: rlm_core_sv.dlog(C_DEBUG, 'Printing attribs rec');
501: rlm_core_sv.dlog(C_DEBUG,'Ship From', x_ItemAttribsRec.ship_from_ext);
502: rlm_core_sv.dlog(C_DEBUG,'Ship To', x_ItemAttribsRec.ship_to_ext);
503: rlm_core_sv.dlog(C_DEBUG,'Bill To', x_ItemAttribsRec.bill_to_ext);
504: rlm_core_sv.dlog(C_DEBUG,'Cust Item', x_ItemAttribsRec.cust_item_ext);

Line 501: rlm_core_sv.dlog(C_DEBUG,'Ship From', x_ItemAttribsRec.ship_from_ext);

497: --
498: /*
499: IF (l_debug <> -1) THEN
500: rlm_core_sv.dlog(C_DEBUG, 'Printing attribs rec');
501: rlm_core_sv.dlog(C_DEBUG,'Ship From', x_ItemAttribsRec.ship_from_ext);
502: rlm_core_sv.dlog(C_DEBUG,'Ship To', x_ItemAttribsRec.ship_to_ext);
503: rlm_core_sv.dlog(C_DEBUG,'Bill To', x_ItemAttribsRec.bill_to_ext);
504: rlm_core_sv.dlog(C_DEBUG,'Cust Item', x_ItemAttribsRec.cust_item_ext);
505: rlm_core_sv.dlog(C_DEBUG,'Item Desc', x_ItemAttribsRec.item_desc_ext);

Line 502: rlm_core_sv.dlog(C_DEBUG,'Ship To', x_ItemAttribsRec.ship_to_ext);

498: /*
499: IF (l_debug <> -1) THEN
500: rlm_core_sv.dlog(C_DEBUG, 'Printing attribs rec');
501: rlm_core_sv.dlog(C_DEBUG,'Ship From', x_ItemAttribsRec.ship_from_ext);
502: rlm_core_sv.dlog(C_DEBUG,'Ship To', x_ItemAttribsRec.ship_to_ext);
503: rlm_core_sv.dlog(C_DEBUG,'Bill To', x_ItemAttribsRec.bill_to_ext);
504: rlm_core_sv.dlog(C_DEBUG,'Cust Item', x_ItemAttribsRec.cust_item_ext);
505: rlm_core_sv.dlog(C_DEBUG,'Item Desc', x_ItemAttribsRec.item_desc_ext);
506: rlm_core_sv.dlog(C_DEBUG,'Dock Code', x_ItemAttribsRec.cust_dock_code);

Line 503: rlm_core_sv.dlog(C_DEBUG,'Bill To', x_ItemAttribsRec.bill_to_ext);

499: IF (l_debug <> -1) THEN
500: rlm_core_sv.dlog(C_DEBUG, 'Printing attribs rec');
501: rlm_core_sv.dlog(C_DEBUG,'Ship From', x_ItemAttribsRec.ship_from_ext);
502: rlm_core_sv.dlog(C_DEBUG,'Ship To', x_ItemAttribsRec.ship_to_ext);
503: rlm_core_sv.dlog(C_DEBUG,'Bill To', x_ItemAttribsRec.bill_to_ext);
504: rlm_core_sv.dlog(C_DEBUG,'Cust Item', x_ItemAttribsRec.cust_item_ext);
505: rlm_core_sv.dlog(C_DEBUG,'Item Desc', x_ItemAttribsRec.item_desc_ext);
506: rlm_core_sv.dlog(C_DEBUG,'Dock Code', x_ItemAttribsRec.cust_dock_code);
507: rlm_core_sv.dlog(C_DEBUG,'Haz Code', x_ItemAttribsRec.hazrd_code_ext);

Line 504: rlm_core_sv.dlog(C_DEBUG,'Cust Item', x_ItemAttribsRec.cust_item_ext);

500: rlm_core_sv.dlog(C_DEBUG, 'Printing attribs rec');
501: rlm_core_sv.dlog(C_DEBUG,'Ship From', x_ItemAttribsRec.ship_from_ext);
502: rlm_core_sv.dlog(C_DEBUG,'Ship To', x_ItemAttribsRec.ship_to_ext);
503: rlm_core_sv.dlog(C_DEBUG,'Bill To', x_ItemAttribsRec.bill_to_ext);
504: rlm_core_sv.dlog(C_DEBUG,'Cust Item', x_ItemAttribsRec.cust_item_ext);
505: rlm_core_sv.dlog(C_DEBUG,'Item Desc', x_ItemAttribsRec.item_desc_ext);
506: rlm_core_sv.dlog(C_DEBUG,'Dock Code', x_ItemAttribsRec.cust_dock_code);
507: rlm_core_sv.dlog(C_DEBUG,'Haz Code', x_ItemAttribsRec.hazrd_code_ext);
508: rlm_core_sv.dlog(C_DEBUG,'Item Rev', x_ItemAttribsRec.cust_item_rev);

Line 505: rlm_core_sv.dlog(C_DEBUG,'Item Desc', x_ItemAttribsRec.item_desc_ext);

501: rlm_core_sv.dlog(C_DEBUG,'Ship From', x_ItemAttribsRec.ship_from_ext);
502: rlm_core_sv.dlog(C_DEBUG,'Ship To', x_ItemAttribsRec.ship_to_ext);
503: rlm_core_sv.dlog(C_DEBUG,'Bill To', x_ItemAttribsRec.bill_to_ext);
504: rlm_core_sv.dlog(C_DEBUG,'Cust Item', x_ItemAttribsRec.cust_item_ext);
505: rlm_core_sv.dlog(C_DEBUG,'Item Desc', x_ItemAttribsRec.item_desc_ext);
506: rlm_core_sv.dlog(C_DEBUG,'Dock Code', x_ItemAttribsRec.cust_dock_code);
507: rlm_core_sv.dlog(C_DEBUG,'Haz Code', x_ItemAttribsRec.hazrd_code_ext);
508: rlm_core_sv.dlog(C_DEBUG,'Item Rev', x_ItemAttribsRec.cust_item_rev);
509: rlm_core_sv.dlog(C_DEBUG,'Item Note', x_ItemAttribsRec.item_note_text);

Line 506: rlm_core_sv.dlog(C_DEBUG,'Dock Code', x_ItemAttribsRec.cust_dock_code);

502: rlm_core_sv.dlog(C_DEBUG,'Ship To', x_ItemAttribsRec.ship_to_ext);
503: rlm_core_sv.dlog(C_DEBUG,'Bill To', x_ItemAttribsRec.bill_to_ext);
504: rlm_core_sv.dlog(C_DEBUG,'Cust Item', x_ItemAttribsRec.cust_item_ext);
505: rlm_core_sv.dlog(C_DEBUG,'Item Desc', x_ItemAttribsRec.item_desc_ext);
506: rlm_core_sv.dlog(C_DEBUG,'Dock Code', x_ItemAttribsRec.cust_dock_code);
507: rlm_core_sv.dlog(C_DEBUG,'Haz Code', x_ItemAttribsRec.hazrd_code_ext);
508: rlm_core_sv.dlog(C_DEBUG,'Item Rev', x_ItemAttribsRec.cust_item_rev);
509: rlm_core_sv.dlog(C_DEBUG,'Item Note', x_ItemAttribsRec.item_note_text);
510: rlm_core_sv.dlog(C_DEBUG,'PO Num', x_ItemAttribsRec.cust_po_num);

Line 507: rlm_core_sv.dlog(C_DEBUG,'Haz Code', x_ItemAttribsRec.hazrd_code_ext);

503: rlm_core_sv.dlog(C_DEBUG,'Bill To', x_ItemAttribsRec.bill_to_ext);
504: rlm_core_sv.dlog(C_DEBUG,'Cust Item', x_ItemAttribsRec.cust_item_ext);
505: rlm_core_sv.dlog(C_DEBUG,'Item Desc', x_ItemAttribsRec.item_desc_ext);
506: rlm_core_sv.dlog(C_DEBUG,'Dock Code', x_ItemAttribsRec.cust_dock_code);
507: rlm_core_sv.dlog(C_DEBUG,'Haz Code', x_ItemAttribsRec.hazrd_code_ext);
508: rlm_core_sv.dlog(C_DEBUG,'Item Rev', x_ItemAttribsRec.cust_item_rev);
509: rlm_core_sv.dlog(C_DEBUG,'Item Note', x_ItemAttribsRec.item_note_text);
510: rlm_core_sv.dlog(C_DEBUG,'PO Num', x_ItemAttribsRec.cust_po_num);
511: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', x_ItemAttribsRec.cust_po_linnum);

Line 508: rlm_core_sv.dlog(C_DEBUG,'Item Rev', x_ItemAttribsRec.cust_item_rev);

504: rlm_core_sv.dlog(C_DEBUG,'Cust Item', x_ItemAttribsRec.cust_item_ext);
505: rlm_core_sv.dlog(C_DEBUG,'Item Desc', x_ItemAttribsRec.item_desc_ext);
506: rlm_core_sv.dlog(C_DEBUG,'Dock Code', x_ItemAttribsRec.cust_dock_code);
507: rlm_core_sv.dlog(C_DEBUG,'Haz Code', x_ItemAttribsRec.hazrd_code_ext);
508: rlm_core_sv.dlog(C_DEBUG,'Item Rev', x_ItemAttribsRec.cust_item_rev);
509: rlm_core_sv.dlog(C_DEBUG,'Item Note', x_ItemAttribsRec.item_note_text);
510: rlm_core_sv.dlog(C_DEBUG,'PO Num', x_ItemAttribsRec.cust_po_num);
511: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', x_ItemAttribsRec.cust_po_linnum);
512: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', x_ItemAttribsRec.cust_po_relnum);

Line 509: rlm_core_sv.dlog(C_DEBUG,'Item Note', x_ItemAttribsRec.item_note_text);

505: rlm_core_sv.dlog(C_DEBUG,'Item Desc', x_ItemAttribsRec.item_desc_ext);
506: rlm_core_sv.dlog(C_DEBUG,'Dock Code', x_ItemAttribsRec.cust_dock_code);
507: rlm_core_sv.dlog(C_DEBUG,'Haz Code', x_ItemAttribsRec.hazrd_code_ext);
508: rlm_core_sv.dlog(C_DEBUG,'Item Rev', x_ItemAttribsRec.cust_item_rev);
509: rlm_core_sv.dlog(C_DEBUG,'Item Note', x_ItemAttribsRec.item_note_text);
510: rlm_core_sv.dlog(C_DEBUG,'PO Num', x_ItemAttribsRec.cust_po_num);
511: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', x_ItemAttribsRec.cust_po_linnum);
512: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', x_ItemAttribsRec.cust_po_relnum);
513: rlm_core_sv.dlog(C_DEBUG,'PO Date', x_ItemAttribsRec.cust_po_date);

Line 510: rlm_core_sv.dlog(C_DEBUG,'PO Num', x_ItemAttribsRec.cust_po_num);

506: rlm_core_sv.dlog(C_DEBUG,'Dock Code', x_ItemAttribsRec.cust_dock_code);
507: rlm_core_sv.dlog(C_DEBUG,'Haz Code', x_ItemAttribsRec.hazrd_code_ext);
508: rlm_core_sv.dlog(C_DEBUG,'Item Rev', x_ItemAttribsRec.cust_item_rev);
509: rlm_core_sv.dlog(C_DEBUG,'Item Note', x_ItemAttribsRec.item_note_text);
510: rlm_core_sv.dlog(C_DEBUG,'PO Num', x_ItemAttribsRec.cust_po_num);
511: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', x_ItemAttribsRec.cust_po_linnum);
512: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', x_ItemAttribsRec.cust_po_relnum);
513: rlm_core_sv.dlog(C_DEBUG,'PO Date', x_ItemAttribsRec.cust_po_date);
514: rlm_core_sv.dlog(C_DEBUG,'Sup Item', x_ItemAttribsRec.sup_item_ext);

Line 511: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', x_ItemAttribsRec.cust_po_linnum);

507: rlm_core_sv.dlog(C_DEBUG,'Haz Code', x_ItemAttribsRec.hazrd_code_ext);
508: rlm_core_sv.dlog(C_DEBUG,'Item Rev', x_ItemAttribsRec.cust_item_rev);
509: rlm_core_sv.dlog(C_DEBUG,'Item Note', x_ItemAttribsRec.item_note_text);
510: rlm_core_sv.dlog(C_DEBUG,'PO Num', x_ItemAttribsRec.cust_po_num);
511: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', x_ItemAttribsRec.cust_po_linnum);
512: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', x_ItemAttribsRec.cust_po_relnum);
513: rlm_core_sv.dlog(C_DEBUG,'PO Date', x_ItemAttribsRec.cust_po_date);
514: rlm_core_sv.dlog(C_DEBUG,'Sup Item', x_ItemAttribsRec.sup_item_ext);
515: END IF;

Line 512: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', x_ItemAttribsRec.cust_po_relnum);

508: rlm_core_sv.dlog(C_DEBUG,'Item Rev', x_ItemAttribsRec.cust_item_rev);
509: rlm_core_sv.dlog(C_DEBUG,'Item Note', x_ItemAttribsRec.item_note_text);
510: rlm_core_sv.dlog(C_DEBUG,'PO Num', x_ItemAttribsRec.cust_po_num);
511: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', x_ItemAttribsRec.cust_po_linnum);
512: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', x_ItemAttribsRec.cust_po_relnum);
513: rlm_core_sv.dlog(C_DEBUG,'PO Date', x_ItemAttribsRec.cust_po_date);
514: rlm_core_sv.dlog(C_DEBUG,'Sup Item', x_ItemAttribsRec.sup_item_ext);
515: END IF;
516: */

Line 513: rlm_core_sv.dlog(C_DEBUG,'PO Date', x_ItemAttribsRec.cust_po_date);

509: rlm_core_sv.dlog(C_DEBUG,'Item Note', x_ItemAttribsRec.item_note_text);
510: rlm_core_sv.dlog(C_DEBUG,'PO Num', x_ItemAttribsRec.cust_po_num);
511: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', x_ItemAttribsRec.cust_po_linnum);
512: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', x_ItemAttribsRec.cust_po_relnum);
513: rlm_core_sv.dlog(C_DEBUG,'PO Date', x_ItemAttribsRec.cust_po_date);
514: rlm_core_sv.dlog(C_DEBUG,'Sup Item', x_ItemAttribsRec.sup_item_ext);
515: END IF;
516: */
517:

Line 514: rlm_core_sv.dlog(C_DEBUG,'Sup Item', x_ItemAttribsRec.sup_item_ext);

510: rlm_core_sv.dlog(C_DEBUG,'PO Num', x_ItemAttribsRec.cust_po_num);
511: rlm_core_sv.dlog(C_DEBUG,'PO Line Num', x_ItemAttribsRec.cust_po_linnum);
512: rlm_core_sv.dlog(C_DEBUG,'PO Rel Num', x_ItemAttribsRec.cust_po_relnum);
513: rlm_core_sv.dlog(C_DEBUG,'PO Date', x_ItemAttribsRec.cust_po_date);
514: rlm_core_sv.dlog(C_DEBUG,'Sup Item', x_ItemAttribsRec.sup_item_ext);
515: END IF;
516: */
517:
518: b_Match := FALSE;

Line 523: rlm_core_sv.dlog(C_DEBUG, '# of rows in g_SchedItemTab', g_SchedItemTab.COUNT);

519: --
520: IF (g_SchedItemTab.COUNT = 0) THEN
521: --
522: IF (l_debug <> -1) THEN
523: rlm_core_sv.dlog(C_DEBUG, '# of rows in g_SchedItemTab', g_SchedItemTab.COUNT);
524: rlm_core_sv.dpop(C_SDEBUG);
525: END IF;
526: RETURN (FALSE);
527: --

Line 524: rlm_core_sv.dpop(C_SDEBUG);

520: IF (g_SchedItemTab.COUNT = 0) THEN
521: --
522: IF (l_debug <> -1) THEN
523: rlm_core_sv.dlog(C_DEBUG, '# of rows in g_SchedItemTab', g_SchedItemTab.COUNT);
524: rlm_core_sv.dpop(C_SDEBUG);
525: END IF;
526: RETURN (FALSE);
527: --
528: END IF;

Line 536: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','SF did not match with entry ' || i);

532: BEGIN
533: --
534: IF (NVL(g_SchedItemTab(i).ship_from_ext, k_VNULL) <> NVL(x_ItemAttribsRec.ship_from_ext, k_VNULL)) THEN
535: IF (l_debug <> -1) THEN
536: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','SF did not match with entry ' || i);
537: END IF;
538: RAISE e_NoMatch;
539: END IF;
540:

Line 543: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','ST did not match with entry ' || i);

539: END IF;
540:
541: IF (NVL(g_SchedItemTab(i).ship_to_ext, k_VNULL) <> NVL(x_ItemAttribsRec.ship_to_ext, k_VNULL)) THEN
542: IF (l_debug <> -1) THEN
543: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','ST did not match with entry ' || i);
544: END IF;
545: RAISE e_NoMatch;
546: END IF;
547:

Line 550: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','BT did not match');

546: END IF;
547:
548: IF (NVL(g_SchedItemTab(i).bill_to_ext, k_VNULL) <> NVL(x_ItemAttribsRec.bill_to_ext, k_VNULL)) THEN
549: IF (l_debug <> -1) THEN
550: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','BT did not match');
551: END IF;
552: RAISE e_NoMatch;
553: END IF;
554:

Line 557: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','CI did not match with entry ' || i);

553: END IF;
554:
555: IF (NVL(g_SchedItemTab(i).cust_item_ext, k_VNULL) <> NVL(x_ItemAttribsRec.cust_item_ext, k_VNULL)) THEN
556: IF (l_debug <> -1) THEN
557: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','CI did not match with entry ' || i);
558: END IF;
559: RAISE e_NoMatch;
560: END IF;
561:

Line 564: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','Desc did not match with entry ' || i);

560: END IF;
561:
562: IF (NVL(g_SchedItemTab(i).item_desc_ext, k_VNULL) <> NVL(x_ItemAttribsRec.item_desc_ext, k_VNULL)) THEN
563: IF (l_debug <> -1) THEN
564: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','Desc did not match with entry ' || i);
565: END IF;
566: RAISE e_NoMatch;
567: END IF;
568:

Line 571: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','Dock did not match with entry ' || i);

567: END IF;
568:
569: IF (NVL(g_SchedItemTab(i).cust_dock_code, k_VNULL) <> NVL(x_ItemAttribsRec.cust_dock_code, k_VNULL)) THEN
570: IF (l_debug <> -1) THEN
571: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','Dock did not match with entry ' || i);
572: END IF;
573: RAISE e_NoMatch;
574: END IF;
575:

Line 578: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','Haz did not match with entry ' || i);

574: END IF;
575:
576: IF (NVL(g_SchedItemTab(i).hazrd_code_ext, k_VNULL) <> NVL(x_ItemAttribsRec.hazrd_code_ext, k_VNULL)) THEN
577: IF (l_debug <> -1) THEN
578: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','Haz did not match with entry ' || i);
579: END IF;
580: RAISE e_NoMatch;
581: END IF;
582:

Line 585: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','Item rev did not match with entry ' || i);

581: END IF;
582:
583: IF (NVL(g_SchedItemTab(i).cust_item_rev, k_VNULL) <> NVL(x_ItemAttribsRec.cust_item_rev, k_VNULL)) THEN
584: IF (l_debug <> -1) THEN
585: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','Item rev did not match with entry ' || i);
586: END IF;
587: RAISE e_NoMatch;
588: END IF;
589:

Line 592: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','Note did not match with entry ' || i);

588: END IF;
589:
590: IF (NVL(g_SchedItemTab(i).item_note_text, k_VNULL) <> NVL(x_ItemAttribsRec.item_note_text, k_VNULL)) THEN
591: IF (l_debug <> -1) THEN
592: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','Note did not match with entry ' || i);
593: END IF;
594: RAISE e_NoMatch;
595: END IF;
596:

Line 599: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','PO Num did not match with entry ' || i);

595: END IF;
596:
597: IF (NVL(g_SchedItemTab(i).cust_po_num, k_VNULL) <> NVL(x_ItemAttribsRec.cust_po_num, k_VNULL)) THEN
598: IF (l_debug <> -1) THEN
599: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','PO Num did not match with entry ' || i);
600: END IF;
601: RAISE e_NoMatch;
602: END IF;
603:

Line 606: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','POLnum did not match with entry ' || i);

602: END IF;
603:
604: IF (NVL(g_SchedItemTab(i).cust_po_linnum, k_VNULL) <> NVL(x_ItemAttribsRec.cust_po_linnum, k_VNULL)) THEN
605: IF (l_debug <> -1) THEN
606: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','POLnum did not match with entry ' || i);
607: END IF;
608: RAISE e_NoMatch;
609: END IF;
610:

Line 613: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','PORel did not match with entry ' || i);

609: END IF;
610:
611: IF (NVL(g_SchedItemTab(i).cust_po_relnum, k_VNULL) <> NVL(x_ItemAttribsRec.cust_po_relnum, k_VNULL)) THEN
612: IF (l_debug <> -1) THEN
613: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','PORel did not match with entry ' || i);
614: END IF;
615: RAISE e_NoMatch;
616: END IF;
617:

Line 620: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','commodity did not match with entry ' || i);

616: END IF;
617:
618: IF (NVL(g_SchedItemTab(i).commodity_ext, k_VNULL) <> NVL(x_ItemAttribsRec.commodity_ext, k_VNULL)) THEN
619: IF (l_debug <> -1) THEN
620: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','commodity did not match with entry ' || i);
621: END IF;
622: RAISE e_NoMatch;
623: END IF;
624:

Line 627: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','Sup item did not match with entry ' || i);

623: END IF;
624:
625: IF (NVL(g_SchedItemTab(i).sup_item_ext, k_VNULL) <> NVL(x_ItemAttribsRec.sup_item_ext, k_VNULL)) THEN
626: IF (l_debug <> -1) THEN
627: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','Sup item did not match with entry ' || i);
628: END IF;
629: RAISE e_NoMatch;
630: END IF;
631:

Line 634: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','PO Date did not match with entry ' || i);

630: END IF;
631:
632: IF (NVL(g_SchedItemTab(i).cust_po_date, k_DNULL) <> NVL(x_ItemAttribsRec.cust_po_date, k_DNULL)) THEN
633: IF (l_debug <> -1) THEN
634: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','PO Date did not match with entry ' || i);
635: END IF;
636: RAISE e_NoMatch;
637: END IF;
638:

Line 641: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','All attributes matched with entry ' || i);

637: END IF;
638:
639: b_Match := TRUE;
640: IF (l_debug <> -1) THEN
641: rlm_core_sv.dlog(C_DEBUG,'RLM_MSG','All attributes matched with entry ' || i);
642: END IF;
643: EXIT;
644:
645: EXCEPTION

Line 655: rlm_core_sv.dlog(C_DEBUG, 'b_Match', b_Match);

651: --
652: END LOOP;
653: --
654: IF (l_debug <> -1) THEN
655: rlm_core_sv.dlog(C_DEBUG, 'b_Match', b_Match);
656: rlm_core_sv.dpop(C_SDEBUG);
657: END IF;
658: RETURN (b_Match);
659: --

Line 656: rlm_core_sv.dpop(C_SDEBUG);

652: END LOOP;
653: --
654: IF (l_debug <> -1) THEN
655: rlm_core_sv.dlog(C_DEBUG, 'b_Match', b_Match);
656: rlm_core_sv.dpop(C_SDEBUG);
657: END IF;
658: RETURN (b_Match);
659: --
660: END IsDuplicate;

Line 670: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.InsertItemAttribs');

666: --
667: BEGIN
668: --
669: IF (l_debug <> -1) THEN
670: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.InsertItemAttribs');
671: END IF;
672: --
673: v_Index := g_SchedItemTab.COUNT;
674: --

Line 692: rlm_core_sv.dpop(C_SDEBUG);

688: g_SchedItemTab(v_Index+1).commodity_ext := x_ItemAttribsRec.commodity_ext;
689: g_SchedItemTab(v_Index+1).sup_item_ext := x_ItemAttribsRec.sup_item_ext;
690: --
691: IF (l_debug <> -1) THEN
692: rlm_core_sv.dpop(C_SDEBUG);
693: END IF;
694: --
695: END InsertItemAttribRec;
696:

Line 714: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.UpdateLineNumbers');

710: --
711: BEGIN
712: --
713: IF (l_debug <> -1) THEN
714: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.UpdateLineNumbers');
715: rlm_core_sv.dlog(C_DEBUG, 'x_HeaderID', x_HeaderID);
716: END IF;
717: --
718: OPEN c_Lines;

Line 715: rlm_core_sv.dlog(C_DEBUG, 'x_HeaderID', x_HeaderID);

711: BEGIN
712: --
713: IF (l_debug <> -1) THEN
714: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.UpdateLineNumbers');
715: rlm_core_sv.dlog(C_DEBUG, 'x_HeaderID', x_HeaderID);
716: END IF;
717: --
718: OPEN c_Lines;
719: FETCH c_Lines INTO v_lineid;

Line 735: rlm_core_sv.dpop(C_SDEBUG);

731: END LOOP;
732: CLOSE c_lines; --bug 4570658
733: --
734: IF (l_debug <> -1) THEN
735: rlm_core_sv.dpop(C_SDEBUG);
736: rlm_core_sv.stop_debug;
737: END IF;
738: --
739: EXCEPTION

Line 736: rlm_core_sv.stop_debug;

732: CLOSE c_lines; --bug 4570658
733: --
734: IF (l_debug <> -1) THEN
735: rlm_core_sv.dpop(C_SDEBUG);
736: rlm_core_sv.stop_debug;
737: END IF;
738: --
739: EXCEPTION
740: --

Line 746: rlm_core_sv.dlog(C_DEBUG,'RLM_ERROR', 'Unknown Error in UpdateLineNumbers');

742: --
743: x_ErrCode := x_ErrCode + 1;
744: x_ErrMsg := x_ErrMsg || ' Unknown error in UpdateLineNumbers';
745: IF (l_debug <> -1) THEN
746: rlm_core_sv.dlog(C_DEBUG,'RLM_ERROR', 'Unknown Error in UpdateLineNumbers');
747: rlm_core_sv.dpop(C_SDEBUG);
748: rlm_core_sv.stop_debug;
749: END IF;
750: --

Line 747: rlm_core_sv.dpop(C_SDEBUG);

743: x_ErrCode := x_ErrCode + 1;
744: x_ErrMsg := x_ErrMsg || ' Unknown error in UpdateLineNumbers';
745: IF (l_debug <> -1) THEN
746: rlm_core_sv.dlog(C_DEBUG,'RLM_ERROR', 'Unknown Error in UpdateLineNumbers');
747: rlm_core_sv.dpop(C_SDEBUG);
748: rlm_core_sv.stop_debug;
749: END IF;
750: --
751: END UpdateLineNumbers;

Line 748: rlm_core_sv.stop_debug;

744: x_ErrMsg := x_ErrMsg || ' Unknown error in UpdateLineNumbers';
745: IF (l_debug <> -1) THEN
746: rlm_core_sv.dlog(C_DEBUG,'RLM_ERROR', 'Unknown Error in UpdateLineNumbers');
747: rlm_core_sv.dpop(C_SDEBUG);
748: rlm_core_sv.stop_debug;
749: END IF;
750: --
751: END UpdateLineNumbers;
752:

Line 783: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.FlexBktAssignment');

779: --
780: BEGIN
781: --
782: IF (l_debug <> -1) THEN
783: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.FlexBktAssignment');
784: rlm_core_sv.dlog(C_DEBUG, 'x_HeaderID', x_header_id);
785: END IF;
786: --
787: OPEN c_Line;

Line 784: rlm_core_sv.dlog(C_DEBUG, 'x_HeaderID', x_header_id);

780: BEGIN
781: --
782: IF (l_debug <> -1) THEN
783: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.FlexBktAssignment');
784: rlm_core_sv.dlog(C_DEBUG, 'x_HeaderID', x_header_id);
785: END IF;
786: --
787: OPEN c_Line;
788: FETCH c_Line INTO v_lineID, v_flexbkt;

Line 796: rlm_core_sv.dlog(C_DEBUG, 'BKTYPE', v_flexbkt);

792: OPEN c_Bkt;
793: FETCH c_Bkt INTO v_line_ID, v_flexbktcode, v_start_date, v_end_date;
794: --
795: IF (l_debug <> -1) THEN
796: rlm_core_sv.dlog(C_DEBUG, 'BKTYPE', v_flexbkt);
797: END IF;
798: --
799: WHILE c_Bkt%FOUND LOOP
800: --

Line 802: rlm_core_sv.dlog(C_DEBUG, 'FLEXBKTID', v_flexbktcode);

798: --
799: WHILE c_Bkt%FOUND LOOP
800: --
801: IF (l_debug <> -1) THEN
802: rlm_core_sv.dlog(C_DEBUG, 'FLEXBKTID', v_flexbktcode);
803: END IF;
804: --
805: IF v_flexbktcode = v_flexbkt THEN
806: --

Line 808: rlm_core_sv.dlog(C_DEBUG, 'Match between FLEXBKTID and BKTYPE for line', v_lineID);

804: --
805: IF v_flexbktcode = v_flexbkt THEN
806: --
807: IF (l_debug <> -1) THEN
808: rlm_core_sv.dlog(C_DEBUG, 'Match between FLEXBKTID and BKTYPE for line', v_lineID);
809: END IF;
810: --
811: UPDATE rlm_interface_lines_all
812: SET start_date_time = v_start_date,

Line 819: rlm_core_sv.dlog(C_DEBUG, 'v_flexbkt', v_flexbkt);

815: --
816: IF v_flexbkt NOT IN ('1', '2', '4', '5', k_RECEIPT, k_SHIPMENT) THEN
817: --
818: IF (l_debug <> -1) THEN
819: rlm_core_sv.dlog(C_DEBUG, 'v_flexbkt', v_flexbkt);
820: rlm_core_sv.dlog(C_DEBUG, 'Replacing ' || v_flexbkt || ' with FLEXIBLE');
821: END IF;
822: --
823: UPDATE rlm_interface_lines_all

Line 820: rlm_core_sv.dlog(C_DEBUG, 'Replacing ' || v_flexbkt || ' with FLEXIBLE');

816: IF v_flexbkt NOT IN ('1', '2', '4', '5', k_RECEIPT, k_SHIPMENT) THEN
817: --
818: IF (l_debug <> -1) THEN
819: rlm_core_sv.dlog(C_DEBUG, 'v_flexbkt', v_flexbkt);
820: rlm_core_sv.dlog(C_DEBUG, 'Replacing ' || v_flexbkt || ' with FLEXIBLE');
821: END IF;
822: --
823: UPDATE rlm_interface_lines_all
824: SET item_detail_subtype = '3'

Line 850: rlm_core_sv.dpop(C_SDEBUG);

846: WHERE header_id = x_header_id
847: AND flex_bkt_flag = 'Y';
848: --
849: IF (l_debug <> -1) THEN
850: rlm_core_sv.dpop(C_SDEBUG);
851: END IF;
852: --
853: EXCEPTION
854: --

Line 860: rlm_core_sv.dlog(C_DEBUG,'RLM_ERROR', 'Unknown Error in FlexBktAssignment');

856: --
857: x_ErrCode := x_ErrCode + 1;
858: x_ErrMsg := x_ErrMsg || ' Unknown error in RLM_XML_API.FlexBktAssignment';
859: IF (l_debug <> -1) THEN
860: rlm_core_sv.dlog(C_DEBUG,'RLM_ERROR', 'Unknown Error in FlexBktAssignment');
861: rlm_core_sv.dpop(C_SDEBUG);
862: END IF;
863:
864: END FlexBktAssignment;

Line 861: rlm_core_sv.dpop(C_SDEBUG);

857: x_ErrCode := x_ErrCode + 1;
858: x_ErrMsg := x_ErrMsg || ' Unknown error in RLM_XML_API.FlexBktAssignment';
859: IF (l_debug <> -1) THEN
860: rlm_core_sv.dlog(C_DEBUG,'RLM_ERROR', 'Unknown Error in FlexBktAssignment');
861: rlm_core_sv.dpop(C_SDEBUG);
862: END IF;
863:
864: END FlexBktAssignment;
865:

Line 878: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.GetDefaultOU');

874: --
875: BEGIN
876: --
877: IF (l_debug <> -1) THEN
878: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.GetDefaultOU');
879: END IF;
880: --
881: FND_PROFILE.GET('DEFAULT_ORG_ID', l_default_org_id);
882: --

Line 892: rlm_core_sv.dlog(C_DEBUG, 'Default Org ID', x_default_ou);

888: x_default_ou := l_default_org_id;
889: END IF;
890: --
891: IF (l_debug <> -1) THEN
892: rlm_core_sv.dlog(C_DEBUG, 'Default Org ID', x_default_ou);
893: rlm_core_sv.dpop(C_SDEBUG);
894: END IF;
895: --
896: EXCEPTION

Line 893: rlm_core_sv.dpop(C_SDEBUG);

889: END IF;
890: --
891: IF (l_debug <> -1) THEN
892: rlm_core_sv.dlog(C_DEBUG, 'Default Org ID', x_default_ou);
893: rlm_core_sv.dpop(C_SDEBUG);
894: END IF;
895: --
896: EXCEPTION
897: WHEN OTHERS THEN

Line 902: Rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unspecified error when Deriving OU');

898: X_ErrCode := x_ErrCode + 1;
899: X_ErrMsg := 'Unknown error when determing Default Operating Unit';
900: --
901: IF (l_debug <> -1) THEN
902: Rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unspecified error when Deriving OU');
903: Rlm_core_sv.dpop(C_SDEBUG);
904: END IF;
905: END GetDefaultOU;
906:

Line 903: Rlm_core_sv.dpop(C_SDEBUG);

899: X_ErrMsg := 'Unknown error when determing Default Operating Unit';
900: --
901: IF (l_debug <> -1) THEN
902: Rlm_core_sv.dlog(C_DEBUG, 'RLM_ERROR', 'Unspecified error when Deriving OU');
903: Rlm_core_sv.dpop(C_SDEBUG);
904: END IF;
905: END GetDefaultOU;
906:
907:

Line 921: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.DeriveExtProcessID');

917: --
918: BEGIN
919: --
920: IF (l_debug <> -1) THEN
921: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.DeriveExtProcessID');
922: rlm_core_sv.dlog(C_DEBUG, 'Msg Std', p_msgStd);
923: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', p_txnType);
924: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', p_txnSubtype);
925: rlm_core_sv.dlog(C_DEBUG, 'Direction', v_Direction);

Line 922: rlm_core_sv.dlog(C_DEBUG, 'Msg Std', p_msgStd);

918: BEGIN
919: --
920: IF (l_debug <> -1) THEN
921: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.DeriveExtProcessID');
922: rlm_core_sv.dlog(C_DEBUG, 'Msg Std', p_msgStd);
923: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', p_txnType);
924: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', p_txnSubtype);
925: rlm_core_sv.dlog(C_DEBUG, 'Direction', v_Direction);
926: rlm_core_sv.dlog(C_DEBUG, 'Std Type', v_stdType);

Line 923: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', p_txnType);

919: --
920: IF (l_debug <> -1) THEN
921: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.DeriveExtProcessID');
922: rlm_core_sv.dlog(C_DEBUG, 'Msg Std', p_msgStd);
923: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', p_txnType);
924: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', p_txnSubtype);
925: rlm_core_sv.dlog(C_DEBUG, 'Direction', v_Direction);
926: rlm_core_sv.dlog(C_DEBUG, 'Std Type', v_stdType);
927: END IF;

Line 924: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', p_txnSubtype);

920: IF (l_debug <> -1) THEN
921: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.DeriveExtProcessID');
922: rlm_core_sv.dlog(C_DEBUG, 'Msg Std', p_msgStd);
923: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', p_txnType);
924: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', p_txnSubtype);
925: rlm_core_sv.dlog(C_DEBUG, 'Direction', v_Direction);
926: rlm_core_sv.dlog(C_DEBUG, 'Std Type', v_stdType);
927: END IF;
928: --

Line 925: rlm_core_sv.dlog(C_DEBUG, 'Direction', v_Direction);

921: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.DeriveExtProcessID');
922: rlm_core_sv.dlog(C_DEBUG, 'Msg Std', p_msgStd);
923: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', p_txnType);
924: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', p_txnSubtype);
925: rlm_core_sv.dlog(C_DEBUG, 'Direction', v_Direction);
926: rlm_core_sv.dlog(C_DEBUG, 'Std Type', v_stdType);
927: END IF;
928: --
929: SELECT standard_id

Line 926: rlm_core_sv.dlog(C_DEBUG, 'Std Type', v_stdType);

922: rlm_core_sv.dlog(C_DEBUG, 'Msg Std', p_msgStd);
923: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', p_txnType);
924: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', p_txnSubtype);
925: rlm_core_sv.dlog(C_DEBUG, 'Direction', v_Direction);
926: rlm_core_sv.dlog(C_DEBUG, 'Std Type', v_stdType);
927: END IF;
928: --
929: SELECT standard_id
930: INTO v_StdID

Line 936: rlm_core_sv.dlog(C_DEBUG, 'Standard ID', v_StdID);

932: WHERE standard_code = p_msgStd
933: AND standard_type = v_stdType;
934: --
935: IF (l_debug <> -1) THEN
936: rlm_core_sv.dlog(C_DEBUG, 'Standard ID', v_StdID);
937: END IF;
938: --
939: SELECT ext_process_id
940: INTO v_ExtProcessID

Line 948: rlm_core_sv.dlog(C_DEBUG, 'Ext Process ID', v_ExtProcessID);

944: AND ext_subtype = p_txnSubtype
945: AND direction = v_Direction;
946: --
947: IF (l_debug <> -1) THEN
948: rlm_core_sv.dlog(C_DEBUG, 'Ext Process ID', v_ExtProcessID);
949: rlm_core_sv.dpop(C_SDEBUG);
950: END IF;
951: --
952: RETURN v_ExtProcessID;

Line 949: rlm_core_sv.dpop(C_SDEBUG);

945: AND direction = v_Direction;
946: --
947: IF (l_debug <> -1) THEN
948: rlm_core_sv.dlog(C_DEBUG, 'Ext Process ID', v_ExtProcessID);
949: rlm_core_sv.dpop(C_SDEBUG);
950: END IF;
951: --
952: RETURN v_ExtProcessID;
953: --

Line 959: rlm_core_sv.dlog(C_DEBUG, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));

955: --
956: WHEN OTHERS THEN
957: --
958: IF (l_debug <> -1) THEN
959: rlm_core_sv.dlog(C_DEBUG, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));
960: rlm_core_sv.dpop(C_SDEBUG);
961: END IF;
962: --
963: RAISE;

Line 960: rlm_core_sv.dpop(C_SDEBUG);

956: WHEN OTHERS THEN
957: --
958: IF (l_debug <> -1) THEN
959: rlm_core_sv.dlog(C_DEBUG, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));
960: rlm_core_sv.dpop(C_SDEBUG);
961: END IF;
962: --
963: RAISE;
964: --

Line 1004: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.DeriveCustomerId');

1000: --
1001: BEGIN
1002: --
1003: IF (l_debug <> -1) THEN
1004: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.DeriveCustomerId');
1005: rlm_core_sv.dlog(C_DEBUG, 'Internal Control Num', x_internalControlNum);
1006: END IF;
1007: --
1008: ECX_TRADING_PARTNER_PVT.getEnvelopeInformation

Line 1005: rlm_core_sv.dlog(C_DEBUG, 'Internal Control Num', x_internalControlNum);

1001: BEGIN
1002: --
1003: IF (l_debug <> -1) THEN
1004: rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.DeriveCustomerId');
1005: rlm_core_sv.dlog(C_DEBUG, 'Internal Control Num', x_internalControlNum);
1006: END IF;
1007: --
1008: ECX_TRADING_PARTNER_PVT.getEnvelopeInformation
1009: (

Line 1032: rlm_core_sv.dlog(C_DEBUG, 'Party ID', v_partyId);

1028: retmsg => v_ErrMsg
1029: );
1030: --
1031: IF (l_debug <> -1) THEN
1032: rlm_core_sv.dlog(C_DEBUG, 'Party ID', v_partyId);
1033: rlm_core_sv.dlog(C_DEBUG, 'Source TP Location Code', v_SourceTPLocCode);
1034: rlm_core_sv.dlog(C_DEBUG, 'Protocal Type', v_protocolType);
1035: rlm_core_sv.dlog(C_DEBUG, 'Protocol Add', v_ProtocolAdd);
1036: rlm_core_sv.dlog(C_DEBUG, 'User name', v_Username);

Line 1033: rlm_core_sv.dlog(C_DEBUG, 'Source TP Location Code', v_SourceTPLocCode);

1029: );
1030: --
1031: IF (l_debug <> -1) THEN
1032: rlm_core_sv.dlog(C_DEBUG, 'Party ID', v_partyId);
1033: rlm_core_sv.dlog(C_DEBUG, 'Source TP Location Code', v_SourceTPLocCode);
1034: rlm_core_sv.dlog(C_DEBUG, 'Protocal Type', v_protocolType);
1035: rlm_core_sv.dlog(C_DEBUG, 'Protocol Add', v_ProtocolAdd);
1036: rlm_core_sv.dlog(C_DEBUG, 'User name', v_Username);
1037: rlm_core_Sv.dlog(C_DEBUG, 'Password', v_Passwd);

Line 1034: rlm_core_sv.dlog(C_DEBUG, 'Protocal Type', v_protocolType);

1030: --
1031: IF (l_debug <> -1) THEN
1032: rlm_core_sv.dlog(C_DEBUG, 'Party ID', v_partyId);
1033: rlm_core_sv.dlog(C_DEBUG, 'Source TP Location Code', v_SourceTPLocCode);
1034: rlm_core_sv.dlog(C_DEBUG, 'Protocal Type', v_protocolType);
1035: rlm_core_sv.dlog(C_DEBUG, 'Protocol Add', v_ProtocolAdd);
1036: rlm_core_sv.dlog(C_DEBUG, 'User name', v_Username);
1037: rlm_core_Sv.dlog(C_DEBUG, 'Password', v_Passwd);
1038: rlm_core_sv.dlog(C_DEBUG, 'Attrib1', v_attrib1);

Line 1035: rlm_core_sv.dlog(C_DEBUG, 'Protocol Add', v_ProtocolAdd);

1031: IF (l_debug <> -1) THEN
1032: rlm_core_sv.dlog(C_DEBUG, 'Party ID', v_partyId);
1033: rlm_core_sv.dlog(C_DEBUG, 'Source TP Location Code', v_SourceTPLocCode);
1034: rlm_core_sv.dlog(C_DEBUG, 'Protocal Type', v_protocolType);
1035: rlm_core_sv.dlog(C_DEBUG, 'Protocol Add', v_ProtocolAdd);
1036: rlm_core_sv.dlog(C_DEBUG, 'User name', v_Username);
1037: rlm_core_Sv.dlog(C_DEBUG, 'Password', v_Passwd);
1038: rlm_core_sv.dlog(C_DEBUG, 'Attrib1', v_attrib1);
1039: rlm_core_sv.dlog(C_DEBUG, 'Attrib2', v_attrib2);

Line 1036: rlm_core_sv.dlog(C_DEBUG, 'User name', v_Username);

1032: rlm_core_sv.dlog(C_DEBUG, 'Party ID', v_partyId);
1033: rlm_core_sv.dlog(C_DEBUG, 'Source TP Location Code', v_SourceTPLocCode);
1034: rlm_core_sv.dlog(C_DEBUG, 'Protocal Type', v_protocolType);
1035: rlm_core_sv.dlog(C_DEBUG, 'Protocol Add', v_ProtocolAdd);
1036: rlm_core_sv.dlog(C_DEBUG, 'User name', v_Username);
1037: rlm_core_Sv.dlog(C_DEBUG, 'Password', v_Passwd);
1038: rlm_core_sv.dlog(C_DEBUG, 'Attrib1', v_attrib1);
1039: rlm_core_sv.dlog(C_DEBUG, 'Attrib2', v_attrib2);
1040: rlm_core_sv.dlog(C_DEBUG, 'Attrib3', v_attrib3);

Line 1037: rlm_core_Sv.dlog(C_DEBUG, 'Password', v_Passwd);

1033: rlm_core_sv.dlog(C_DEBUG, 'Source TP Location Code', v_SourceTPLocCode);
1034: rlm_core_sv.dlog(C_DEBUG, 'Protocal Type', v_protocolType);
1035: rlm_core_sv.dlog(C_DEBUG, 'Protocol Add', v_ProtocolAdd);
1036: rlm_core_sv.dlog(C_DEBUG, 'User name', v_Username);
1037: rlm_core_Sv.dlog(C_DEBUG, 'Password', v_Passwd);
1038: rlm_core_sv.dlog(C_DEBUG, 'Attrib1', v_attrib1);
1039: rlm_core_sv.dlog(C_DEBUG, 'Attrib2', v_attrib2);
1040: rlm_core_sv.dlog(C_DEBUG, 'Attrib3', v_attrib3);
1041: rlm_core_sv.dlog(C_DEBUG, 'Attrib4', v_attrib4);

Line 1038: rlm_core_sv.dlog(C_DEBUG, 'Attrib1', v_attrib1);

1034: rlm_core_sv.dlog(C_DEBUG, 'Protocal Type', v_protocolType);
1035: rlm_core_sv.dlog(C_DEBUG, 'Protocol Add', v_ProtocolAdd);
1036: rlm_core_sv.dlog(C_DEBUG, 'User name', v_Username);
1037: rlm_core_Sv.dlog(C_DEBUG, 'Password', v_Passwd);
1038: rlm_core_sv.dlog(C_DEBUG, 'Attrib1', v_attrib1);
1039: rlm_core_sv.dlog(C_DEBUG, 'Attrib2', v_attrib2);
1040: rlm_core_sv.dlog(C_DEBUG, 'Attrib3', v_attrib3);
1041: rlm_core_sv.dlog(C_DEBUG, 'Attrib4', v_attrib4);
1042: rlm_core_sv.dlog(C_DEBUG, 'Attrib5', v_attrib5);

Line 1039: rlm_core_sv.dlog(C_DEBUG, 'Attrib2', v_attrib2);

1035: rlm_core_sv.dlog(C_DEBUG, 'Protocol Add', v_ProtocolAdd);
1036: rlm_core_sv.dlog(C_DEBUG, 'User name', v_Username);
1037: rlm_core_Sv.dlog(C_DEBUG, 'Password', v_Passwd);
1038: rlm_core_sv.dlog(C_DEBUG, 'Attrib1', v_attrib1);
1039: rlm_core_sv.dlog(C_DEBUG, 'Attrib2', v_attrib2);
1040: rlm_core_sv.dlog(C_DEBUG, 'Attrib3', v_attrib3);
1041: rlm_core_sv.dlog(C_DEBUG, 'Attrib4', v_attrib4);
1042: rlm_core_sv.dlog(C_DEBUG, 'Attrib5', v_attrib5);
1043: rlm_core_sv.dlog(C_DEBUG, 'Error Code', v_ErrCode);

Line 1040: rlm_core_sv.dlog(C_DEBUG, 'Attrib3', v_attrib3);

1036: rlm_core_sv.dlog(C_DEBUG, 'User name', v_Username);
1037: rlm_core_Sv.dlog(C_DEBUG, 'Password', v_Passwd);
1038: rlm_core_sv.dlog(C_DEBUG, 'Attrib1', v_attrib1);
1039: rlm_core_sv.dlog(C_DEBUG, 'Attrib2', v_attrib2);
1040: rlm_core_sv.dlog(C_DEBUG, 'Attrib3', v_attrib3);
1041: rlm_core_sv.dlog(C_DEBUG, 'Attrib4', v_attrib4);
1042: rlm_core_sv.dlog(C_DEBUG, 'Attrib5', v_attrib5);
1043: rlm_core_sv.dlog(C_DEBUG, 'Error Code', v_ErrCode);
1044: rlm_core_sv.dlog(C_DEBUG, 'Error Msg', v_Errmsg);

Line 1041: rlm_core_sv.dlog(C_DEBUG, 'Attrib4', v_attrib4);

1037: rlm_core_Sv.dlog(C_DEBUG, 'Password', v_Passwd);
1038: rlm_core_sv.dlog(C_DEBUG, 'Attrib1', v_attrib1);
1039: rlm_core_sv.dlog(C_DEBUG, 'Attrib2', v_attrib2);
1040: rlm_core_sv.dlog(C_DEBUG, 'Attrib3', v_attrib3);
1041: rlm_core_sv.dlog(C_DEBUG, 'Attrib4', v_attrib4);
1042: rlm_core_sv.dlog(C_DEBUG, 'Attrib5', v_attrib5);
1043: rlm_core_sv.dlog(C_DEBUG, 'Error Code', v_ErrCode);
1044: rlm_core_sv.dlog(C_DEBUG, 'Error Msg', v_Errmsg);
1045: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', v_Txntype);

Line 1042: rlm_core_sv.dlog(C_DEBUG, 'Attrib5', v_attrib5);

1038: rlm_core_sv.dlog(C_DEBUG, 'Attrib1', v_attrib1);
1039: rlm_core_sv.dlog(C_DEBUG, 'Attrib2', v_attrib2);
1040: rlm_core_sv.dlog(C_DEBUG, 'Attrib3', v_attrib3);
1041: rlm_core_sv.dlog(C_DEBUG, 'Attrib4', v_attrib4);
1042: rlm_core_sv.dlog(C_DEBUG, 'Attrib5', v_attrib5);
1043: rlm_core_sv.dlog(C_DEBUG, 'Error Code', v_ErrCode);
1044: rlm_core_sv.dlog(C_DEBUG, 'Error Msg', v_Errmsg);
1045: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', v_Txntype);
1046: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', v_txnSubtype);

Line 1043: rlm_core_sv.dlog(C_DEBUG, 'Error Code', v_ErrCode);

1039: rlm_core_sv.dlog(C_DEBUG, 'Attrib2', v_attrib2);
1040: rlm_core_sv.dlog(C_DEBUG, 'Attrib3', v_attrib3);
1041: rlm_core_sv.dlog(C_DEBUG, 'Attrib4', v_attrib4);
1042: rlm_core_sv.dlog(C_DEBUG, 'Attrib5', v_attrib5);
1043: rlm_core_sv.dlog(C_DEBUG, 'Error Code', v_ErrCode);
1044: rlm_core_sv.dlog(C_DEBUG, 'Error Msg', v_Errmsg);
1045: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', v_Txntype);
1046: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', v_txnSubtype);
1047: rlm_core_sv.dlog(C_DEBUG, 'Msg Type', v_msgtype);

Line 1044: rlm_core_sv.dlog(C_DEBUG, 'Error Msg', v_Errmsg);

1040: rlm_core_sv.dlog(C_DEBUG, 'Attrib3', v_attrib3);
1041: rlm_core_sv.dlog(C_DEBUG, 'Attrib4', v_attrib4);
1042: rlm_core_sv.dlog(C_DEBUG, 'Attrib5', v_attrib5);
1043: rlm_core_sv.dlog(C_DEBUG, 'Error Code', v_ErrCode);
1044: rlm_core_sv.dlog(C_DEBUG, 'Error Msg', v_Errmsg);
1045: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', v_Txntype);
1046: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', v_txnSubtype);
1047: rlm_core_sv.dlog(C_DEBUG, 'Msg Type', v_msgtype);
1048: rlm_core_sv.dlog(C_DEBUG, 'Doc Number', v_docnum);

Line 1045: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', v_Txntype);

1041: rlm_core_sv.dlog(C_DEBUG, 'Attrib4', v_attrib4);
1042: rlm_core_sv.dlog(C_DEBUG, 'Attrib5', v_attrib5);
1043: rlm_core_sv.dlog(C_DEBUG, 'Error Code', v_ErrCode);
1044: rlm_core_sv.dlog(C_DEBUG, 'Error Msg', v_Errmsg);
1045: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', v_Txntype);
1046: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', v_txnSubtype);
1047: rlm_core_sv.dlog(C_DEBUG, 'Msg Type', v_msgtype);
1048: rlm_core_sv.dlog(C_DEBUG, 'Doc Number', v_docnum);
1049: rlm_core_sv.dlog(C_DEBUG, 'Msg Std', v_msgStd);

Line 1046: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', v_txnSubtype);

1042: rlm_core_sv.dlog(C_DEBUG, 'Attrib5', v_attrib5);
1043: rlm_core_sv.dlog(C_DEBUG, 'Error Code', v_ErrCode);
1044: rlm_core_sv.dlog(C_DEBUG, 'Error Msg', v_Errmsg);
1045: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', v_Txntype);
1046: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', v_txnSubtype);
1047: rlm_core_sv.dlog(C_DEBUG, 'Msg Type', v_msgtype);
1048: rlm_core_sv.dlog(C_DEBUG, 'Doc Number', v_docnum);
1049: rlm_core_sv.dlog(C_DEBUG, 'Msg Std', v_msgStd);
1050: END IF;

Line 1047: rlm_core_sv.dlog(C_DEBUG, 'Msg Type', v_msgtype);

1043: rlm_core_sv.dlog(C_DEBUG, 'Error Code', v_ErrCode);
1044: rlm_core_sv.dlog(C_DEBUG, 'Error Msg', v_Errmsg);
1045: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', v_Txntype);
1046: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', v_txnSubtype);
1047: rlm_core_sv.dlog(C_DEBUG, 'Msg Type', v_msgtype);
1048: rlm_core_sv.dlog(C_DEBUG, 'Doc Number', v_docnum);
1049: rlm_core_sv.dlog(C_DEBUG, 'Msg Std', v_msgStd);
1050: END IF;
1051: --

Line 1048: rlm_core_sv.dlog(C_DEBUG, 'Doc Number', v_docnum);

1044: rlm_core_sv.dlog(C_DEBUG, 'Error Msg', v_Errmsg);
1045: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', v_Txntype);
1046: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', v_txnSubtype);
1047: rlm_core_sv.dlog(C_DEBUG, 'Msg Type', v_msgtype);
1048: rlm_core_sv.dlog(C_DEBUG, 'Doc Number', v_docnum);
1049: rlm_core_sv.dlog(C_DEBUG, 'Msg Std', v_msgStd);
1050: END IF;
1051: --
1052: x_SourceTPLocCode := v_SourceTPLocCode;

Line 1049: rlm_core_sv.dlog(C_DEBUG, 'Msg Std', v_msgStd);

1045: rlm_core_sv.dlog(C_DEBUG, 'Txn Type', v_Txntype);
1046: rlm_core_sv.dlog(C_DEBUG, 'Txn Subtype', v_txnSubtype);
1047: rlm_core_sv.dlog(C_DEBUG, 'Msg Type', v_msgtype);
1048: rlm_core_sv.dlog(C_DEBUG, 'Doc Number', v_docnum);
1049: rlm_core_sv.dlog(C_DEBUG, 'Msg Std', v_msgStd);
1050: END IF;
1051: --
1052: x_SourceTPLocCode := v_SourceTPLocCode;
1053: v_ExtProcessID := DeriveExtProcessID(v_msgStd, v_Txntype, v_txnSubtype);

Line 1056: rlm_core_sv.dlog(C_DEBUG, 'Ext Process ID', v_ExtProcessID);

1052: x_SourceTPLocCode := v_SourceTPLocCode;
1053: v_ExtProcessID := DeriveExtProcessID(v_msgStd, v_Txntype, v_txnSubtype);
1054: --
1055: IF (l_debug <> -1) THEN
1056: rlm_core_sv.dlog(C_DEBUG, 'Ext Process ID', v_ExtProcessID);
1057: END IF;
1058: --
1059: SELECT party_site_id, party_id
1060: INTO v_PartySiteID, v_party_id

Line 1068: rlm_core_sv.dlog(C_DEBUG, 'Party Site ID', v_partySiteID);

1064: WHERE source_tp_location_code = v_SourceTPLocCode
1065: AND ext_process_id = v_ExtProcessID);
1066: --
1067: IF (l_debug <> -1) THEN
1068: rlm_core_sv.dlog(C_DEBUG, 'Party Site ID', v_partySiteID);
1069: rlm_core_sv.dlog(C_DEBUG, 'Party ID', v_party_ID);
1070: END IF;
1071: --
1072: SELECT cust_acct_site_id, cust_account_id

Line 1069: rlm_core_sv.dlog(C_DEBUG, 'Party ID', v_party_ID);

1065: AND ext_process_id = v_ExtProcessID);
1066: --
1067: IF (l_debug <> -1) THEN
1068: rlm_core_sv.dlog(C_DEBUG, 'Party Site ID', v_partySiteID);
1069: rlm_core_sv.dlog(C_DEBUG, 'Party ID', v_party_ID);
1070: END IF;
1071: --
1072: SELECT cust_acct_site_id, cust_account_id
1073: INTO v_CustacctSiteId, v_CustAccountId

Line 1081: rlm_core_sv.dlog(C_DEBUG, 'Customer Site ID', v_CustacctSiteId);

1077: --
1078: x_CustomerId := v_CustAccountId;
1079: --
1080: IF (l_debug <> -1) THEN
1081: rlm_core_sv.dlog(C_DEBUG, 'Customer Site ID', v_CustacctSiteId);
1082: rlm_core_sv.dlog(C_DEBUG, 'Customer ID', v_CustAccountId);
1083: rlm_core_sv.dpop(C_SDEBUG);
1084: END IF;
1085: --

Line 1082: rlm_core_sv.dlog(C_DEBUG, 'Customer ID', v_CustAccountId);

1078: x_CustomerId := v_CustAccountId;
1079: --
1080: IF (l_debug <> -1) THEN
1081: rlm_core_sv.dlog(C_DEBUG, 'Customer Site ID', v_CustacctSiteId);
1082: rlm_core_sv.dlog(C_DEBUG, 'Customer ID', v_CustAccountId);
1083: rlm_core_sv.dpop(C_SDEBUG);
1084: END IF;
1085: --
1086: EXCEPTION

Line 1083: rlm_core_sv.dpop(C_SDEBUG);

1079: --
1080: IF (l_debug <> -1) THEN
1081: rlm_core_sv.dlog(C_DEBUG, 'Customer Site ID', v_CustacctSiteId);
1082: rlm_core_sv.dlog(C_DEBUG, 'Customer ID', v_CustAccountId);
1083: rlm_core_sv.dpop(C_SDEBUG);
1084: END IF;
1085: --
1086: EXCEPTION
1087: --

Line 1095: rlm_core_sv.dlog(C_DEBUG,'RLM_ERROR', 'Unknown Error in RLM_XML_API.DeriveCustomerId');

1091: x_ErrCode := x_ErrCode + 1;
1092: x_ErrMsg := x_ErrMsg || 'error in RLM_XML_API.DeriveCustomerId' || SUBSTRB(SQLERRM, 1, 200);
1093: --
1094: IF (l_debug <> -1) THEN
1095: rlm_core_sv.dlog(C_DEBUG,'RLM_ERROR', 'Unknown Error in RLM_XML_API.DeriveCustomerId');
1096: rlm_core_sv.dlog(C_DEBUG, 'Exception when others',
1097: SUBSTRB(SQLERRM, 1, 200));
1098: rlm_core_sv.dpop(C_SDEBUG);
1099: END IF;

Line 1096: rlm_core_sv.dlog(C_DEBUG, 'Exception when others',

1092: x_ErrMsg := x_ErrMsg || 'error in RLM_XML_API.DeriveCustomerId' || SUBSTRB(SQLERRM, 1, 200);
1093: --
1094: IF (l_debug <> -1) THEN
1095: rlm_core_sv.dlog(C_DEBUG,'RLM_ERROR', 'Unknown Error in RLM_XML_API.DeriveCustomerId');
1096: rlm_core_sv.dlog(C_DEBUG, 'Exception when others',
1097: SUBSTRB(SQLERRM, 1, 200));
1098: rlm_core_sv.dpop(C_SDEBUG);
1099: END IF;
1100: --

Line 1098: rlm_core_sv.dpop(C_SDEBUG);

1094: IF (l_debug <> -1) THEN
1095: rlm_core_sv.dlog(C_DEBUG,'RLM_ERROR', 'Unknown Error in RLM_XML_API.DeriveCustomerId');
1096: rlm_core_sv.dlog(C_DEBUG, 'Exception when others',
1097: SUBSTRB(SQLERRM, 1, 200));
1098: rlm_core_sv.dpop(C_SDEBUG);
1099: END IF;
1100: --
1101: END DeriveCustomerId;
1102: