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_REPLACE_SV dependencies on RLM_CORE_SV

Line 24: rlm_core_sv.dpush(C_SDEBUG,'CompareReplaceSched');

20: --
21: BEGIN
22: --
23: IF (l_debug <> -1) THEN
24: rlm_core_sv.dpush(C_SDEBUG,'CompareReplaceSched');
25: END IF;
26: --
27: v_curr_header_id := x_sched_rec.header_id;
28: --

Line 30: rlm_core_sv.dlog(C_DEBUG, 'v_curr_header_id', v_curr_header_id);

26: --
27: v_curr_header_id := x_sched_rec.header_id;
28: --
29: IF (l_debug <> -1) THEN
30: rlm_core_sv.dlog(C_DEBUG, 'v_curr_header_id', v_curr_header_id);
31: END IF;
32: --
33: IF IsWarningNeeded(x_sched_rec, x_warn_dropped_items) THEN
34: --

Line 42: rlm_core_sv.dlog(C_DEBUG, 'v_prev_header_id',v_prev_header_id);

38: --
39: IF v_return_status <> FALSE THEN
40: --
41: IF (l_debug <> -1) THEN
42: rlm_core_sv.dlog(C_DEBUG, 'v_prev_header_id',v_prev_header_id);
43: END IF;
44: --
45: -- Populate the global list
46: --

Line 72: rlm_core_sv.dpop(C_SDEBUG);

68: --
69: END IF;
70: --
71: IF (l_debug <> -1) THEN
72: rlm_core_sv.dpop(C_SDEBUG);
73: END IF;
74: --
75: EXCEPTION
76: --

Line 82: rlm_core_sv.dpop(C_SDEBUG, 'EXCEPTION: OTHER - ' || SUBSTR(SQLERRM,1,200));

78: --
79: x_return_status := FALSE;
80: --
81: IF (l_debug <> -1) THEN
82: rlm_core_sv.dpop(C_SDEBUG, 'EXCEPTION: OTHER - ' || SUBSTR(SQLERRM,1,200));
83: END IF;
84: --
85: END CompareReplaceSched;
86:

Line 100: rlm_core_sv.dpush(C_SDEBUG,'IsWarningNeeded');

96: IS
97: BEGIN
98: --
99: IF (l_debug <> -1) THEN
100: rlm_core_sv.dpush(C_SDEBUG,'IsWarningNeeded');
101: rlm_core_sv.dlog(C_DEBUG, 'x_warn_dropped_items', x_warn_dropped_items);
102: rlm_core_sv.dlog(C_DEBUG, 'schedule source', x_sched_rec.schedule_source);
103: rlm_core_sv.dlog(C_DEBUG, 'schedule purpose', x_sched_rec.schedule_purpose);
104: END IF;

Line 101: rlm_core_sv.dlog(C_DEBUG, 'x_warn_dropped_items', x_warn_dropped_items);

97: BEGIN
98: --
99: IF (l_debug <> -1) THEN
100: rlm_core_sv.dpush(C_SDEBUG,'IsWarningNeeded');
101: rlm_core_sv.dlog(C_DEBUG, 'x_warn_dropped_items', x_warn_dropped_items);
102: rlm_core_sv.dlog(C_DEBUG, 'schedule source', x_sched_rec.schedule_source);
103: rlm_core_sv.dlog(C_DEBUG, 'schedule purpose', x_sched_rec.schedule_purpose);
104: END IF;
105: --

Line 102: rlm_core_sv.dlog(C_DEBUG, 'schedule source', x_sched_rec.schedule_source);

98: --
99: IF (l_debug <> -1) THEN
100: rlm_core_sv.dpush(C_SDEBUG,'IsWarningNeeded');
101: rlm_core_sv.dlog(C_DEBUG, 'x_warn_dropped_items', x_warn_dropped_items);
102: rlm_core_sv.dlog(C_DEBUG, 'schedule source', x_sched_rec.schedule_source);
103: rlm_core_sv.dlog(C_DEBUG, 'schedule purpose', x_sched_rec.schedule_purpose);
104: END IF;
105: --
106: IF x_warn_dropped_items <> 'Y'

Line 103: rlm_core_sv.dlog(C_DEBUG, 'schedule purpose', x_sched_rec.schedule_purpose);

99: IF (l_debug <> -1) THEN
100: rlm_core_sv.dpush(C_SDEBUG,'IsWarningNeeded');
101: rlm_core_sv.dlog(C_DEBUG, 'x_warn_dropped_items', x_warn_dropped_items);
102: rlm_core_sv.dlog(C_DEBUG, 'schedule source', x_sched_rec.schedule_source);
103: rlm_core_sv.dlog(C_DEBUG, 'schedule purpose', x_sched_rec.schedule_purpose);
104: END IF;
105: --
106: IF x_warn_dropped_items <> 'Y'
107: AND x_warn_dropped_items <> 'y' THEN

Line 110: rlm_core_sv.dpop(C_SDEBUG);

106: IF x_warn_dropped_items <> 'Y'
107: AND x_warn_dropped_items <> 'y' THEN
108: --
109: IF (l_debug <> -1) THEN
110: rlm_core_sv.dpop(C_SDEBUG);
111: END IF;
112: --
113: RETURN FALSE;
114: --

Line 120: rlm_core_sv.dpop(C_SDEBUG);

116: --
117: IF x_sched_rec.schedule_purpose not in ('REPLACE', 'REPLACE_ALL') THEN
118: --
119: IF (l_debug <> -1) THEN
120: rlm_core_sv.dpop(C_SDEBUG);
121: END IF;
122: --
123: RETURN FALSE;
124: --

Line 130: rlm_core_sv.dpop(C_SDEBUG);

126: --
127: IF x_sched_rec.schedule_source = 'MANUAL' THEN
128: --
129: IF (l_debug <> -1) THEN
130: rlm_core_sv.dpop(C_SDEBUG);
131: END IF;
132: --
133: RETURN FALSE;
134: --

Line 138: rlm_core_sv.dpop(C_SDEBUG);

134: --
135: END IF;
136: --
137: IF (l_debug <> -1) THEN
138: rlm_core_sv.dpop(C_SDEBUG);
139: END IF;
140: --
141: RETURN TRUE;
142: --

Line 176: rlm_core_sv.dpush(C_SDEBUG,'FindEligibleSched');

172: --
173: BEGIN
174: --
175: IF (l_debug <> -1) THEN
176: rlm_core_sv.dpush(C_SDEBUG,'FindEligibleSched');
177: rlm_core_sv.dlog(C_DEBUG,'Curr ece_tp_translator_code', x_sched_rec.ece_tp_translator_code);
178: rlm_core_sv.dlog(C_DEBUG,'Curr ece_tp_location_code_ext', x_sched_rec.ece_tp_location_code_ext);
179: rlm_core_sv.dlog(C_DEBUG,'Curr edi_test_indicator', x_sched_rec.edi_test_indicator);
180: rlm_core_sv.dlog(C_DEBUG,'Curr sched_generation_date', x_sched_rec.sched_generation_date);

Line 177: rlm_core_sv.dlog(C_DEBUG,'Curr ece_tp_translator_code', x_sched_rec.ece_tp_translator_code);

173: BEGIN
174: --
175: IF (l_debug <> -1) THEN
176: rlm_core_sv.dpush(C_SDEBUG,'FindEligibleSched');
177: rlm_core_sv.dlog(C_DEBUG,'Curr ece_tp_translator_code', x_sched_rec.ece_tp_translator_code);
178: rlm_core_sv.dlog(C_DEBUG,'Curr ece_tp_location_code_ext', x_sched_rec.ece_tp_location_code_ext);
179: rlm_core_sv.dlog(C_DEBUG,'Curr edi_test_indicator', x_sched_rec.edi_test_indicator);
180: rlm_core_sv.dlog(C_DEBUG,'Curr sched_generation_date', x_sched_rec.sched_generation_date);
181: END IF;

Line 178: rlm_core_sv.dlog(C_DEBUG,'Curr ece_tp_location_code_ext', x_sched_rec.ece_tp_location_code_ext);

174: --
175: IF (l_debug <> -1) THEN
176: rlm_core_sv.dpush(C_SDEBUG,'FindEligibleSched');
177: rlm_core_sv.dlog(C_DEBUG,'Curr ece_tp_translator_code', x_sched_rec.ece_tp_translator_code);
178: rlm_core_sv.dlog(C_DEBUG,'Curr ece_tp_location_code_ext', x_sched_rec.ece_tp_location_code_ext);
179: rlm_core_sv.dlog(C_DEBUG,'Curr edi_test_indicator', x_sched_rec.edi_test_indicator);
180: rlm_core_sv.dlog(C_DEBUG,'Curr sched_generation_date', x_sched_rec.sched_generation_date);
181: END IF;
182: --

Line 179: rlm_core_sv.dlog(C_DEBUG,'Curr edi_test_indicator', x_sched_rec.edi_test_indicator);

175: IF (l_debug <> -1) THEN
176: rlm_core_sv.dpush(C_SDEBUG,'FindEligibleSched');
177: rlm_core_sv.dlog(C_DEBUG,'Curr ece_tp_translator_code', x_sched_rec.ece_tp_translator_code);
178: rlm_core_sv.dlog(C_DEBUG,'Curr ece_tp_location_code_ext', x_sched_rec.ece_tp_location_code_ext);
179: rlm_core_sv.dlog(C_DEBUG,'Curr edi_test_indicator', x_sched_rec.edi_test_indicator);
180: rlm_core_sv.dlog(C_DEBUG,'Curr sched_generation_date', x_sched_rec.sched_generation_date);
181: END IF;
182: --
183: OPEN c_eligible_schedule;

Line 180: rlm_core_sv.dlog(C_DEBUG,'Curr sched_generation_date', x_sched_rec.sched_generation_date);

176: rlm_core_sv.dpush(C_SDEBUG,'FindEligibleSched');
177: rlm_core_sv.dlog(C_DEBUG,'Curr ece_tp_translator_code', x_sched_rec.ece_tp_translator_code);
178: rlm_core_sv.dlog(C_DEBUG,'Curr ece_tp_location_code_ext', x_sched_rec.ece_tp_location_code_ext);
179: rlm_core_sv.dlog(C_DEBUG,'Curr edi_test_indicator', x_sched_rec.edi_test_indicator);
180: rlm_core_sv.dlog(C_DEBUG,'Curr sched_generation_date', x_sched_rec.sched_generation_date);
181: END IF;
182: --
183: OPEN c_eligible_schedule;
184: -- Get the second highest generation date schedule only

Line 198: rlm_core_sv.dlog(C_DEBUG, 'x_return_status', x_return_status);

194: --
195: x_return_status := TRUE;
196: --
197: IF (l_debug <> -1) THEN
198: rlm_core_sv.dlog(C_DEBUG, 'x_return_status', x_return_status);
199: rlm_core_sv.dpop(C_SDEBUG);
200: END IF;
201: --
202: EXCEPTION

Line 199: rlm_core_sv.dpop(C_SDEBUG);

195: x_return_status := TRUE;
196: --
197: IF (l_debug <> -1) THEN
198: rlm_core_sv.dlog(C_DEBUG, 'x_return_status', x_return_status);
199: rlm_core_sv.dpop(C_SDEBUG);
200: END IF;
201: --
202: EXCEPTION
203: --

Line 209: rlm_core_sv.dpop(C_SDEBUG, 'e_no_eligible_schedule');

205: --
206: x_return_status := FALSE;
207: --
208: IF (l_debug <> -1) THEN
209: rlm_core_sv.dpop(C_SDEBUG, 'e_no_eligible_schedule');
210: END IF;
211: --
212: WHEN OTHERS THEN
213: --

Line 217: rlm_core_sv.dpop(C_SDEBUG, 'EXCEPTION: OTHER - ' || SUBSTR(SQLERRM,1,200));

213: --
214: x_return_status := FALSE;
215: --
216: IF (l_debug <> -1) THEN
217: rlm_core_sv.dpop(C_SDEBUG, 'EXCEPTION: OTHER - ' || SUBSTR(SQLERRM,1,200));
218: END IF;
219: --
220: END FindEligibleSched;
221:

Line 280: rlm_core_sv.dpush(C_SDEBUG, 'PopulateList');

276: --
277: BEGIN
278: --
279: IF (l_debug <> -1) THEN
280: rlm_core_sv.dpush(C_SDEBUG, 'PopulateList');
281: END IF;
282: --
283: FOR drop_list IN c_drop_list LOOP
284: --

Line 286: rlm_core_sv.dlog(C_DEBUG, 'Missing items on the schedule');

282: --
283: FOR drop_list IN c_drop_list LOOP
284: --
285: IF (l_debug <> -1) THEN
286: rlm_core_sv.dlog(C_DEBUG, 'Missing items on the schedule');
287: rlm_core_sv.dlog(C_DEBUG, 'Ship From:', drop_list.ship_from_org_id);
288: rlm_core_sv.dlog(C_DEBUG, 'Ship To Address Id:', drop_list.ship_to_address_id);
289: rlm_core_sv.dlog(C_DEBUG, 'ST Org Id:', drop_list.ship_to_org_id);
290: rlm_core_sv.dlog(C_DEBUG, 'Customer Item:', drop_list.customer_item_id);

Line 287: rlm_core_sv.dlog(C_DEBUG, 'Ship From:', drop_list.ship_from_org_id);

283: FOR drop_list IN c_drop_list LOOP
284: --
285: IF (l_debug <> -1) THEN
286: rlm_core_sv.dlog(C_DEBUG, 'Missing items on the schedule');
287: rlm_core_sv.dlog(C_DEBUG, 'Ship From:', drop_list.ship_from_org_id);
288: rlm_core_sv.dlog(C_DEBUG, 'Ship To Address Id:', drop_list.ship_to_address_id);
289: rlm_core_sv.dlog(C_DEBUG, 'ST Org Id:', drop_list.ship_to_org_id);
290: rlm_core_sv.dlog(C_DEBUG, 'Customer Item:', drop_list.customer_item_id);
291: END IF;

Line 288: rlm_core_sv.dlog(C_DEBUG, 'Ship To Address Id:', drop_list.ship_to_address_id);

284: --
285: IF (l_debug <> -1) THEN
286: rlm_core_sv.dlog(C_DEBUG, 'Missing items on the schedule');
287: rlm_core_sv.dlog(C_DEBUG, 'Ship From:', drop_list.ship_from_org_id);
288: rlm_core_sv.dlog(C_DEBUG, 'Ship To Address Id:', drop_list.ship_to_address_id);
289: rlm_core_sv.dlog(C_DEBUG, 'ST Org Id:', drop_list.ship_to_org_id);
290: rlm_core_sv.dlog(C_DEBUG, 'Customer Item:', drop_list.customer_item_id);
291: END IF;
292: --

Line 289: rlm_core_sv.dlog(C_DEBUG, 'ST Org Id:', drop_list.ship_to_org_id);

285: IF (l_debug <> -1) THEN
286: rlm_core_sv.dlog(C_DEBUG, 'Missing items on the schedule');
287: rlm_core_sv.dlog(C_DEBUG, 'Ship From:', drop_list.ship_from_org_id);
288: rlm_core_sv.dlog(C_DEBUG, 'Ship To Address Id:', drop_list.ship_to_address_id);
289: rlm_core_sv.dlog(C_DEBUG, 'ST Org Id:', drop_list.ship_to_org_id);
290: rlm_core_sv.dlog(C_DEBUG, 'Customer Item:', drop_list.customer_item_id);
291: END IF;
292: --
293: v_order_number := NULL;

Line 290: rlm_core_sv.dlog(C_DEBUG, 'Customer Item:', drop_list.customer_item_id);

286: rlm_core_sv.dlog(C_DEBUG, 'Missing items on the schedule');
287: rlm_core_sv.dlog(C_DEBUG, 'Ship From:', drop_list.ship_from_org_id);
288: rlm_core_sv.dlog(C_DEBUG, 'Ship To Address Id:', drop_list.ship_to_address_id);
289: rlm_core_sv.dlog(C_DEBUG, 'ST Org Id:', drop_list.ship_to_org_id);
290: rlm_core_sv.dlog(C_DEBUG, 'Customer Item:', drop_list.customer_item_id);
291: END IF;
292: --
293: v_order_number := NULL;
294: v_header_id := NULL;

Line 309: rlm_core_sv.dlog(C_DEBUG, 'RLM_DROPPED_ITEMS');

305: --
306: IF v_header_id is NOT NULL THEN
307: --
308: IF (l_debug <> -1) THEN
309: rlm_core_sv.dlog(C_DEBUG, 'RLM_DROPPED_ITEMS');
310: rlm_core_sv.dlog(C_DEBUG, 'SF', drop_list.ship_from_org_id);
311: rlm_core_sv.dlog(C_DEBUG, 'ST', drop_list.ship_to_address_id);
312: rlm_core_sv.dlog(C_DEBUG, 'CI', drop_list.customer_item_id);
313: rlm_core_sv.dlog(C_DEBUG, 'Order Number', v_order_number);

Line 310: rlm_core_sv.dlog(C_DEBUG, 'SF', drop_list.ship_from_org_id);

306: IF v_header_id is NOT NULL THEN
307: --
308: IF (l_debug <> -1) THEN
309: rlm_core_sv.dlog(C_DEBUG, 'RLM_DROPPED_ITEMS');
310: rlm_core_sv.dlog(C_DEBUG, 'SF', drop_list.ship_from_org_id);
311: rlm_core_sv.dlog(C_DEBUG, 'ST', drop_list.ship_to_address_id);
312: rlm_core_sv.dlog(C_DEBUG, 'CI', drop_list.customer_item_id);
313: rlm_core_sv.dlog(C_DEBUG, 'Order Number', v_order_number);
314: rlm_core_sv.dlog(C_DEBUG, 'Header_id', v_header_id);

Line 311: rlm_core_sv.dlog(C_DEBUG, 'ST', drop_list.ship_to_address_id);

307: --
308: IF (l_debug <> -1) THEN
309: rlm_core_sv.dlog(C_DEBUG, 'RLM_DROPPED_ITEMS');
310: rlm_core_sv.dlog(C_DEBUG, 'SF', drop_list.ship_from_org_id);
311: rlm_core_sv.dlog(C_DEBUG, 'ST', drop_list.ship_to_address_id);
312: rlm_core_sv.dlog(C_DEBUG, 'CI', drop_list.customer_item_id);
313: rlm_core_sv.dlog(C_DEBUG, 'Order Number', v_order_number);
314: rlm_core_sv.dlog(C_DEBUG, 'Header_id', v_header_id);
315: END IF;

Line 312: rlm_core_sv.dlog(C_DEBUG, 'CI', drop_list.customer_item_id);

308: IF (l_debug <> -1) THEN
309: rlm_core_sv.dlog(C_DEBUG, 'RLM_DROPPED_ITEMS');
310: rlm_core_sv.dlog(C_DEBUG, 'SF', drop_list.ship_from_org_id);
311: rlm_core_sv.dlog(C_DEBUG, 'ST', drop_list.ship_to_address_id);
312: rlm_core_sv.dlog(C_DEBUG, 'CI', drop_list.customer_item_id);
313: rlm_core_sv.dlog(C_DEBUG, 'Order Number', v_order_number);
314: rlm_core_sv.dlog(C_DEBUG, 'Header_id', v_header_id);
315: END IF;
316: --

Line 313: rlm_core_sv.dlog(C_DEBUG, 'Order Number', v_order_number);

309: rlm_core_sv.dlog(C_DEBUG, 'RLM_DROPPED_ITEMS');
310: rlm_core_sv.dlog(C_DEBUG, 'SF', drop_list.ship_from_org_id);
311: rlm_core_sv.dlog(C_DEBUG, 'ST', drop_list.ship_to_address_id);
312: rlm_core_sv.dlog(C_DEBUG, 'CI', drop_list.customer_item_id);
313: rlm_core_sv.dlog(C_DEBUG, 'Order Number', v_order_number);
314: rlm_core_sv.dlog(C_DEBUG, 'Header_id', v_header_id);
315: END IF;
316: --
317: rlm_message_sv.app_error(

Line 314: rlm_core_sv.dlog(C_DEBUG, 'Header_id', v_header_id);

310: rlm_core_sv.dlog(C_DEBUG, 'SF', drop_list.ship_from_org_id);
311: rlm_core_sv.dlog(C_DEBUG, 'ST', drop_list.ship_to_address_id);
312: rlm_core_sv.dlog(C_DEBUG, 'CI', drop_list.customer_item_id);
313: rlm_core_sv.dlog(C_DEBUG, 'Order Number', v_order_number);
314: rlm_core_sv.dlog(C_DEBUG, 'Header_id', v_header_id);
315: END IF;
316: --
317: rlm_message_sv.app_error(
318: x_ExceptionLevel => rlm_message_sv.k_warn_level,

Line 323: x_value1 => RLM_CORE_SV.get_ship_from(drop_list.ship_from_org_id),

319: x_MessageName => 'RLM_WARN_DROPPED_ITEMS',
320: x_InterfaceHeaderId => x_curr_header_id,
321: x_InterfaceLineId => NULL,
322: x_token1 => 'SF',
323: x_value1 => RLM_CORE_SV.get_ship_from(drop_list.ship_from_org_id),
324: x_token2 => 'ST',
325: x_value2 => RLM_CORE_SV.get_ship_to(drop_list.ship_to_address_id),
326: x_token3 => 'CI',
327: x_value3 => RLM_CORE_SV.get_item_number(drop_list.customer_item_id),

Line 325: x_value2 => RLM_CORE_SV.get_ship_to(drop_list.ship_to_address_id),

321: x_InterfaceLineId => NULL,
322: x_token1 => 'SF',
323: x_value1 => RLM_CORE_SV.get_ship_from(drop_list.ship_from_org_id),
324: x_token2 => 'ST',
325: x_value2 => RLM_CORE_SV.get_ship_to(drop_list.ship_to_address_id),
326: x_token3 => 'CI',
327: x_value3 => RLM_CORE_SV.get_item_number(drop_list.customer_item_id),
328: x_token4 => 'ORDER_NO',
329: x_value4 => v_order_number);

Line 327: x_value3 => RLM_CORE_SV.get_item_number(drop_list.customer_item_id),

323: x_value1 => RLM_CORE_SV.get_ship_from(drop_list.ship_from_org_id),
324: x_token2 => 'ST',
325: x_value2 => RLM_CORE_SV.get_ship_to(drop_list.ship_to_address_id),
326: x_token3 => 'CI',
327: x_value3 => RLM_CORE_SV.get_item_number(drop_list.customer_item_id),
328: x_token4 => 'ORDER_NO',
329: x_value4 => v_order_number);
330: --
331: ELSE

Line 334: rlm_core_sv.dlog(C_DEBUG, 'No Open order line exists for below combination of '|| 'SF' ||','|| 'ST'||' and '|| 'CI.' );

330: --
331: ELSE
332: --
333: IF (l_debug <> -1) THEN
334: rlm_core_sv.dlog(C_DEBUG, 'No Open order line exists for below combination of '|| 'SF' ||','|| 'ST'||' and '|| 'CI.' );
335: rlm_core_sv.dlog(C_DEBUG, 'SF', drop_list.ship_from_org_id);
336: rlm_core_sv.dlog(C_DEBUG, 'ST', drop_list.ship_to_address_id);
337: rlm_core_sv.dlog(C_DEBUG, 'CI', drop_list.customer_item_id);
338: END IF ;

Line 335: rlm_core_sv.dlog(C_DEBUG, 'SF', drop_list.ship_from_org_id);

331: ELSE
332: --
333: IF (l_debug <> -1) THEN
334: rlm_core_sv.dlog(C_DEBUG, 'No Open order line exists for below combination of '|| 'SF' ||','|| 'ST'||' and '|| 'CI.' );
335: rlm_core_sv.dlog(C_DEBUG, 'SF', drop_list.ship_from_org_id);
336: rlm_core_sv.dlog(C_DEBUG, 'ST', drop_list.ship_to_address_id);
337: rlm_core_sv.dlog(C_DEBUG, 'CI', drop_list.customer_item_id);
338: END IF ;
339: --

Line 336: rlm_core_sv.dlog(C_DEBUG, 'ST', drop_list.ship_to_address_id);

332: --
333: IF (l_debug <> -1) THEN
334: rlm_core_sv.dlog(C_DEBUG, 'No Open order line exists for below combination of '|| 'SF' ||','|| 'ST'||' and '|| 'CI.' );
335: rlm_core_sv.dlog(C_DEBUG, 'SF', drop_list.ship_from_org_id);
336: rlm_core_sv.dlog(C_DEBUG, 'ST', drop_list.ship_to_address_id);
337: rlm_core_sv.dlog(C_DEBUG, 'CI', drop_list.customer_item_id);
338: END IF ;
339: --
340: END IF ;

Line 337: rlm_core_sv.dlog(C_DEBUG, 'CI', drop_list.customer_item_id);

333: IF (l_debug <> -1) THEN
334: rlm_core_sv.dlog(C_DEBUG, 'No Open order line exists for below combination of '|| 'SF' ||','|| 'ST'||' and '|| 'CI.' );
335: rlm_core_sv.dlog(C_DEBUG, 'SF', drop_list.ship_from_org_id);
336: rlm_core_sv.dlog(C_DEBUG, 'ST', drop_list.ship_to_address_id);
337: rlm_core_sv.dlog(C_DEBUG, 'CI', drop_list.customer_item_id);
338: END IF ;
339: --
340: END IF ;
341: --

Line 347: rlm_core_sv.dlog(C_DEBUG, 'In the when others of Populate Lists');

343: --
344: WHEN OTHERS THEN
345: --
346: IF (l_debug <> -1) THEN
347: rlm_core_sv.dlog(C_DEBUG, 'In the when others of Populate Lists');
348: rlm_core_sv.dlog(C_DEBUG, 'EXCEPTION: OTHER - ' || SUBSTR(SQLERRM,1,200));
349: END IF ;
350: --
351: END ;

Line 348: rlm_core_sv.dlog(C_DEBUG, 'EXCEPTION: OTHER - ' || SUBSTR(SQLERRM,1,200));

344: WHEN OTHERS THEN
345: --
346: IF (l_debug <> -1) THEN
347: rlm_core_sv.dlog(C_DEBUG, 'In the when others of Populate Lists');
348: rlm_core_sv.dlog(C_DEBUG, 'EXCEPTION: OTHER - ' || SUBSTR(SQLERRM,1,200));
349: END IF ;
350: --
351: END ;
352: --

Line 358: -- rlm_core_sv.dlog(C_DEBUG, 'g_list_tbl.COUNT', g_list_tbl.COUNT);

354: --
355: x_return_status := TRUE;
356: --
357: IF (l_debug <> -1) THEN
358: -- rlm_core_sv.dlog(C_DEBUG, 'g_list_tbl.COUNT', g_list_tbl.COUNT);
359: rlm_core_sv.dlog(C_DEBUG, 'x_return_status', x_return_status);
360: rlm_core_sv.dpop(C_SDEBUG);
361: END IF;
362: --

Line 359: rlm_core_sv.dlog(C_DEBUG, 'x_return_status', x_return_status);

355: x_return_status := TRUE;
356: --
357: IF (l_debug <> -1) THEN
358: -- rlm_core_sv.dlog(C_DEBUG, 'g_list_tbl.COUNT', g_list_tbl.COUNT);
359: rlm_core_sv.dlog(C_DEBUG, 'x_return_status', x_return_status);
360: rlm_core_sv.dpop(C_SDEBUG);
361: END IF;
362: --
363: EXCEPTION

Line 360: rlm_core_sv.dpop(C_SDEBUG);

356: --
357: IF (l_debug <> -1) THEN
358: -- rlm_core_sv.dlog(C_DEBUG, 'g_list_tbl.COUNT', g_list_tbl.COUNT);
359: rlm_core_sv.dlog(C_DEBUG, 'x_return_status', x_return_status);
360: rlm_core_sv.dpop(C_SDEBUG);
361: END IF;
362: --
363: EXCEPTION
364: --

Line 370: rlm_core_sv.dpop(C_SDEBUG, 'EXCEPTION: OTHER - ' || SUBSTR(SQLERRM,1,200));

366: --
367: x_return_status := FALSE;
368: --
369: IF (l_debug <> -1) THEN
370: rlm_core_sv.dpop(C_SDEBUG, 'EXCEPTION: OTHER - ' || SUBSTR(SQLERRM,1,200));
371: END IF;
372: --
373:
374: END PopulateList;

Line 393: rlm_core_sv.dpush(C_SDEBUG, 'CompareList');

389: --
390: BEGIN
391: --
392: IF (l_debug <> -1) THEN
393: rlm_core_sv.dpush(C_SDEBUG, 'CompareList');
394: rlm_core_sv.dlog(C_DEBUG, 'g_list_tbl.COUNT', g_list_tbl.COUNT);
395: END IF;
396: --
397: --

Line 394: rlm_core_sv.dlog(C_DEBUG, 'g_list_tbl.COUNT', g_list_tbl.COUNT);

390: BEGIN
391: --
392: IF (l_debug <> -1) THEN
393: rlm_core_sv.dpush(C_SDEBUG, 'CompareList');
394: rlm_core_sv.dlog(C_DEBUG, 'g_list_tbl.COUNT', g_list_tbl.COUNT);
395: END IF;
396: --
397: --
398: -- Bug 2778728 : Proceed further only if g_list_tbl has any entries

Line 405: rlm_core_sv.dlog(C_DEBUG, 'Starting Loop');

401: --
402: i := g_list_tbl.FIRST;
403: --
404: IF (l_debug <> -1) THEN
405: rlm_core_sv.dlog(C_DEBUG, 'Starting Loop');
406: END IF;
407: --
408: LOOP
409: --

Line 411: rlm_core_sv.dlog(C_DEBUG, 'ship_from_org_id', g_list_tbl(i).ship_from_org_id);

407: --
408: LOOP
409: --
410: IF (l_debug <> -1) THEN
411: rlm_core_sv.dlog(C_DEBUG, 'ship_from_org_id', g_list_tbl(i).ship_from_org_id);
412: rlm_core_sv.dlog(C_DEBUG, 'ship_to_address_id', g_list_tbl(i).ship_to_address_id);
413: rlm_core_sv.dlog(C_DEBUG, 'customer_item_id', g_list_tbl(i).customer_item_id);
414: END IF;
415: --

Line 412: rlm_core_sv.dlog(C_DEBUG, 'ship_to_address_id', g_list_tbl(i).ship_to_address_id);

408: LOOP
409: --
410: IF (l_debug <> -1) THEN
411: rlm_core_sv.dlog(C_DEBUG, 'ship_from_org_id', g_list_tbl(i).ship_from_org_id);
412: rlm_core_sv.dlog(C_DEBUG, 'ship_to_address_id', g_list_tbl(i).ship_to_address_id);
413: rlm_core_sv.dlog(C_DEBUG, 'customer_item_id', g_list_tbl(i).customer_item_id);
414: END IF;
415: --
416: SELECT count(1)

Line 413: rlm_core_sv.dlog(C_DEBUG, 'customer_item_id', g_list_tbl(i).customer_item_id);

409: --
410: IF (l_debug <> -1) THEN
411: rlm_core_sv.dlog(C_DEBUG, 'ship_from_org_id', g_list_tbl(i).ship_from_org_id);
412: rlm_core_sv.dlog(C_DEBUG, 'ship_to_address_id', g_list_tbl(i).ship_to_address_id);
413: rlm_core_sv.dlog(C_DEBUG, 'customer_item_id', g_list_tbl(i).customer_item_id);
414: END IF;
415: --
416: SELECT count(1)
417: INTO v_exist_count

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

421: AND ship_to_address_id = g_list_tbl(i).ship_to_address_id
422: AND customer_item_id = g_list_tbl(i).customer_item_id;
423: --
424: IF (l_debug <> -1) THEN
425: rlm_core_sv.dlog(C_DEBUG, 'i', i);
426: rlm_core_sv.dlog(C_DEBUG, 'v_exist_count', v_exist_count);
427: END IF;
428: --
429: IF v_exist_count > 0 THEN

Line 426: rlm_core_sv.dlog(C_DEBUG, 'v_exist_count', v_exist_count);

422: AND customer_item_id = g_list_tbl(i).customer_item_id;
423: --
424: IF (l_debug <> -1) THEN
425: rlm_core_sv.dlog(C_DEBUG, 'i', i);
426: rlm_core_sv.dlog(C_DEBUG, 'v_exist_count', v_exist_count);
427: END IF;
428: --
429: IF v_exist_count > 0 THEN
430: --

Line 438: rlm_core_sv.dlog(C_DEBUG, 'RLM_DROPPED_ITEMS');

434: --
435: ELSE
436: --
437: IF (l_debug <> -1) THEN
438: rlm_core_sv.dlog(C_DEBUG, 'RLM_DROPPED_ITEMS');
439: rlm_core_sv.dlog(C_DEBUG, 'SF', g_list_tbl(i).ship_from_org_id);
440: rlm_core_sv.dlog(C_DEBUG, 'ST', g_list_tbl(i).ship_to_address_id);
441: rlm_core_sv.dlog(C_DEBUG, 'CI', g_list_tbl(i).customer_item_id);
442: rlm_core_sv.dlog(C_DEBUG, 'Order Number', g_list_tbl(i).order_number);

Line 439: rlm_core_sv.dlog(C_DEBUG, 'SF', g_list_tbl(i).ship_from_org_id);

435: ELSE
436: --
437: IF (l_debug <> -1) THEN
438: rlm_core_sv.dlog(C_DEBUG, 'RLM_DROPPED_ITEMS');
439: rlm_core_sv.dlog(C_DEBUG, 'SF', g_list_tbl(i).ship_from_org_id);
440: rlm_core_sv.dlog(C_DEBUG, 'ST', g_list_tbl(i).ship_to_address_id);
441: rlm_core_sv.dlog(C_DEBUG, 'CI', g_list_tbl(i).customer_item_id);
442: rlm_core_sv.dlog(C_DEBUG, 'Order Number', g_list_tbl(i).order_number);
443: END IF;

Line 440: rlm_core_sv.dlog(C_DEBUG, 'ST', g_list_tbl(i).ship_to_address_id);

436: --
437: IF (l_debug <> -1) THEN
438: rlm_core_sv.dlog(C_DEBUG, 'RLM_DROPPED_ITEMS');
439: rlm_core_sv.dlog(C_DEBUG, 'SF', g_list_tbl(i).ship_from_org_id);
440: rlm_core_sv.dlog(C_DEBUG, 'ST', g_list_tbl(i).ship_to_address_id);
441: rlm_core_sv.dlog(C_DEBUG, 'CI', g_list_tbl(i).customer_item_id);
442: rlm_core_sv.dlog(C_DEBUG, 'Order Number', g_list_tbl(i).order_number);
443: END IF;
444: --

Line 441: rlm_core_sv.dlog(C_DEBUG, 'CI', g_list_tbl(i).customer_item_id);

437: IF (l_debug <> -1) THEN
438: rlm_core_sv.dlog(C_DEBUG, 'RLM_DROPPED_ITEMS');
439: rlm_core_sv.dlog(C_DEBUG, 'SF', g_list_tbl(i).ship_from_org_id);
440: rlm_core_sv.dlog(C_DEBUG, 'ST', g_list_tbl(i).ship_to_address_id);
441: rlm_core_sv.dlog(C_DEBUG, 'CI', g_list_tbl(i).customer_item_id);
442: rlm_core_sv.dlog(C_DEBUG, 'Order Number', g_list_tbl(i).order_number);
443: END IF;
444: --
445: rlm_message_sv.app_error(

Line 442: rlm_core_sv.dlog(C_DEBUG, 'Order Number', g_list_tbl(i).order_number);

438: rlm_core_sv.dlog(C_DEBUG, 'RLM_DROPPED_ITEMS');
439: rlm_core_sv.dlog(C_DEBUG, 'SF', g_list_tbl(i).ship_from_org_id);
440: rlm_core_sv.dlog(C_DEBUG, 'ST', g_list_tbl(i).ship_to_address_id);
441: rlm_core_sv.dlog(C_DEBUG, 'CI', g_list_tbl(i).customer_item_id);
442: rlm_core_sv.dlog(C_DEBUG, 'Order Number', g_list_tbl(i).order_number);
443: END IF;
444: --
445: rlm_message_sv.app_error(
446: x_ExceptionLevel => rlm_message_sv.k_warn_level,

Line 451: x_value1 => RLM_CORE_SV.get_ship_from(g_list_tbl(i).ship_from_org_id),

447: x_MessageName => 'RLM_WARN_DROPPED_ITEMS',
448: x_InterfaceHeaderId => x_curr_header_id,
449: x_InterfaceLineId => NULL,
450: x_token1 => 'SF',
451: x_value1 => RLM_CORE_SV.get_ship_from(g_list_tbl(i).ship_from_org_id),
452: x_token2 => 'ST',
453: x_value2 => RLM_CORE_SV.get_ship_to(g_list_tbl(i).ship_to_address_id),
454: x_token3 => 'CI',
455: x_value3 => RLM_CORE_SV.get_item_number(g_list_tbl(i).customer_item_id),

Line 453: x_value2 => RLM_CORE_SV.get_ship_to(g_list_tbl(i).ship_to_address_id),

449: x_InterfaceLineId => NULL,
450: x_token1 => 'SF',
451: x_value1 => RLM_CORE_SV.get_ship_from(g_list_tbl(i).ship_from_org_id),
452: x_token2 => 'ST',
453: x_value2 => RLM_CORE_SV.get_ship_to(g_list_tbl(i).ship_to_address_id),
454: x_token3 => 'CI',
455: x_value3 => RLM_CORE_SV.get_item_number(g_list_tbl(i).customer_item_id),
456: x_token4 => 'ORDER_NO',
457: x_value4 => g_list_tbl(i).order_number);

Line 455: x_value3 => RLM_CORE_SV.get_item_number(g_list_tbl(i).customer_item_id),

451: x_value1 => RLM_CORE_SV.get_ship_from(g_list_tbl(i).ship_from_org_id),
452: x_token2 => 'ST',
453: x_value2 => RLM_CORE_SV.get_ship_to(g_list_tbl(i).ship_to_address_id),
454: x_token3 => 'CI',
455: x_value3 => RLM_CORE_SV.get_item_number(g_list_tbl(i).customer_item_id),
456: x_token4 => 'ORDER_NO',
457: x_value4 => g_list_tbl(i).order_number);
458: --
459: EXIT WHEN i = g_list_tbl.LAST;

Line 470: rlm_core_sv.dpop(C_SDEBUG);

466: --
467: END IF; /* g_list_tbl.COUNT > 0 */
468: --
469: IF (l_debug <> -1) THEN
470: rlm_core_sv.dpop(C_SDEBUG);
471: END IF;
472: --
473: EXCEPTION
474: --

Line 478: rlm_core_sv.dpop(C_SDEBUG, 'EXCEPTION: OTHER - ' || SUBSTR(SQLERRM,1,200));

474: --
475: WHEN OTHERS THEN
476: --
477: IF (l_debug <> -1) THEN
478: rlm_core_sv.dpop(C_SDEBUG, 'EXCEPTION: OTHER - ' || SUBSTR(SQLERRM,1,200));
479: END IF;
480: --
481:
482: END CompareList;