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

Line 7: g_wheretab RLM_CORE_SV.t_dynamic_tab;

3: /*===========================================================================*/
4:
5: --
6: l_DEBUG NUMBER := NVL(fnd_profile.value('RLM_DEBUG_MODE'),-1);
7: g_wheretab RLM_CORE_SV.t_dynamic_tab;
8: --
9: /*==============================================================================
10:
11: PROCEDURE BuildOELineTab(x_Op_tab IN rlm_rd_sv.t_generic_tab,

Line 24: rlm_core_sv.dpush(k_SDEBUG,'BuildOELineTab');

20:
21: BEGIN
22: --
23: IF (l_debug <> -1) THEN
24: rlm_core_sv.dpush(k_SDEBUG,'BuildOELineTab');
25: rlm_core_sv.dlog(k_DEBUG,'no of lines in oe interface table',
26: x_Op_Tab.COUNT);
27: END IF;
28: --

Line 25: rlm_core_sv.dlog(k_DEBUG,'no of lines in oe interface table',

21: BEGIN
22: --
23: IF (l_debug <> -1) THEN
24: rlm_core_sv.dpush(k_SDEBUG,'BuildOELineTab');
25: rlm_core_sv.dlog(k_DEBUG,'no of lines in oe interface table',
26: x_Op_Tab.COUNT);
27: END IF;
28: --
29: x_return_status := 'S';

Line 35: rlm_core_sv.dlog(k_DEBUG,'Loading the oe lines tables PL/SQL table: ', counter );

31: --
32: FOR counter IN 1..x_Op_Tab.COUNT LOOP
33: --
34: IF (l_debug <> -1) THEN
35: rlm_core_sv.dlog(k_DEBUG,'Loading the oe lines tables PL/SQL table: ', counter );
36: END IF;
37: --
38: x_linecount := counter;
39: --

Line 50: rlm_core_sv.dpop(k_SDEBUG);

46: --
47: x_return_status := 'S';
48: --
49: IF (l_debug <> -1) THEN
50: rlm_core_sv.dpop(k_SDEBUG);
51: END IF;
52: --
53: EXCEPTION
54: --

Line 60: rlm_core_sv.dlog(k_DEBUG,'When Other Exception',substr(sqlerrm,1,200));

56: --
57: x_return_status := 'E';
58: --
59: IF (l_debug <> -1) THEN
60: rlm_core_sv.dlog(k_DEBUG,'When Other Exception',substr(sqlerrm,1,200));
61: rlm_core_sv.dpop(k_SDEBUG);
62: END IF;
63:
64: END BuildOELineTab;

Line 61: rlm_core_sv.dpop(k_SDEBUG);

57: x_return_status := 'E';
58: --
59: IF (l_debug <> -1) THEN
60: rlm_core_sv.dlog(k_DEBUG,'When Other Exception',substr(sqlerrm,1,200));
61: rlm_core_sv.dpop(k_SDEBUG);
62: END IF;
63:
64: END BuildOELineTab;
65:

Line 99: rlm_core_sv.dpush(k_SDEBUG,'ProcessOperation');

95: --
96: BEGIN
97: --
98: IF (l_debug <> -1) THEN
99: rlm_core_sv.dpush(k_SDEBUG,'ProcessOperation');
100: END IF;
101: --
102: BuildOELineTab(x_Op_Tab,x_Return_Status);
103: --

Line 111: rlm_core_sv.dlog(k_DEBUG,'starting insert oe lines');

107: --
108: IF g_oe_line_tbl.count >0 THEN
109: --
110: IF (l_debug <> -1) THEN
111: rlm_core_sv.dlog(k_DEBUG,'starting insert oe lines');
112: END IF;
113: --
114: fnd_profile.get(rlm_core_sv.C_DEBUG_PROFILE, v_DebugMode);
115: --

Line 114: fnd_profile.get(rlm_core_sv.C_DEBUG_PROFILE, v_DebugMode);

110: IF (l_debug <> -1) THEN
111: rlm_core_sv.dlog(k_DEBUG,'starting insert oe lines');
112: END IF;
113: --
114: fnd_profile.get(rlm_core_sv.C_DEBUG_PROFILE, v_DebugMode);
115: --
116: oe_debug_pub.add('Calling Process_order from DSP',1);
117: --
118: IF (l_debug <> -1) THEN

Line 119: rlm_core_sv.dlog(k_DEBUG,'RLM DEBUG PROFILE :',v_DebugMode);

115: --
116: oe_debug_pub.add('Calling Process_order from DSP',1);
117: --
118: IF (l_debug <> -1) THEN
119: rlm_core_sv.dlog(k_DEBUG,'RLM DEBUG PROFILE :',v_DebugMode);
120: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.IsDebugOn);
121: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
122: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
123: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);

Line 120: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.IsDebugOn);

116: oe_debug_pub.add('Calling Process_order from DSP',1);
117: --
118: IF (l_debug <> -1) THEN
119: rlm_core_sv.dlog(k_DEBUG,'RLM DEBUG PROFILE :',v_DebugMode);
120: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.IsDebugOn);
121: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
122: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
123: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
124: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for details on process Order API errors');

Line 121: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));

117: --
118: IF (l_debug <> -1) THEN
119: rlm_core_sv.dlog(k_DEBUG,'RLM DEBUG PROFILE :',v_DebugMode);
120: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.IsDebugOn);
121: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
122: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
123: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
124: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for details on process Order API errors');
125: rlm_core_sv.dlog(k_DEBUG,'Om Debug File dir:',OE_DEBUG_PUB.G_DIR);

Line 122: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);

118: IF (l_debug <> -1) THEN
119: rlm_core_sv.dlog(k_DEBUG,'RLM DEBUG PROFILE :',v_DebugMode);
120: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.IsDebugOn);
121: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
122: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
123: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
124: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for details on process Order API errors');
125: rlm_core_sv.dlog(k_DEBUG,'Om Debug File dir:',OE_DEBUG_PUB.G_DIR);
126: END IF;

Line 123: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);

119: rlm_core_sv.dlog(k_DEBUG,'RLM DEBUG PROFILE :',v_DebugMode);
120: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.IsDebugOn);
121: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
122: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
123: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
124: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for details on process Order API errors');
125: rlm_core_sv.dlog(k_DEBUG,'Om Debug File dir:',OE_DEBUG_PUB.G_DIR);
126: END IF;
127: --

Line 124: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for details on process Order API errors');

120: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.IsDebugOn);
121: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
122: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
123: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
124: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for details on process Order API errors');
125: rlm_core_sv.dlog(k_DEBUG,'Om Debug File dir:',OE_DEBUG_PUB.G_DIR);
126: END IF;
127: --
128: v_FileName := OE_DEBUG_PUB.set_debug_mode ('FILE');

Line 125: rlm_core_sv.dlog(k_DEBUG,'Om Debug File dir:',OE_DEBUG_PUB.G_DIR);

121: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
122: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
123: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
124: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for details on process Order API errors');
125: rlm_core_sv.dlog(k_DEBUG,'Om Debug File dir:',OE_DEBUG_PUB.G_DIR);
126: END IF;
127: --
128: v_FileName := OE_DEBUG_PUB.set_debug_mode ('FILE');
129: --

Line 131: rlm_core_sv.dlog(k_DEBUG,'Om Debug File name:',v_FileName);

127: --
128: v_FileName := OE_DEBUG_PUB.set_debug_mode ('FILE');
129: --
130: IF (l_debug <> -1) THEN
131: rlm_core_sv.dlog(k_DEBUG,'Om Debug File name:',v_FileName);
132: END IF;
133: --
134: -- This setting ensures the pl/sql table returned by Process
135: -- order api contains messages from workflow scheduling activities

Line 145: rlm_core_sv.dlog(k_DEBUG,'x_Op_tab(1).schedule_type', x_Op_tab(1).schedule_type);

141: --
142: v_FileName := OE_DEBUG_PUB.set_debug_mode ('CONC');
143: --
144: IF (l_debug <> -1) THEN
145: rlm_core_sv.dlog(k_DEBUG,'x_Op_tab(1).schedule_type', x_Op_tab(1).schedule_type);
146: END IF;
147: --
148: SELECT hsecs INTO l_start_time from v$timer;
149: --

Line 240: rlm_core_sv.dlog(k_DEBUG,'# of lines in input tbl',g_oe_line_tbl.LAST);

236: x_return_status := l_return_status;
237: --
238: IF (l_debug <> -1) THEN
239: --
240: rlm_core_sv.dlog(k_DEBUG,'# of lines in input tbl',g_oe_line_tbl.LAST);
241: rlm_core_sv.dlog(k_DEBUG,'# of lines in output table',l_oe_line_tbl_out.LAST);
242: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status',x_return_Status);
243: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
244: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);

Line 241: rlm_core_sv.dlog(k_DEBUG,'# of lines in output table',l_oe_line_tbl_out.LAST);

237: --
238: IF (l_debug <> -1) THEN
239: --
240: rlm_core_sv.dlog(k_DEBUG,'# of lines in input tbl',g_oe_line_tbl.LAST);
241: rlm_core_sv.dlog(k_DEBUG,'# of lines in output table',l_oe_line_tbl_out.LAST);
242: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status',x_return_Status);
243: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
244: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
245: END IF;

Line 242: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status',x_return_Status);

238: IF (l_debug <> -1) THEN
239: --
240: rlm_core_sv.dlog(k_DEBUG,'# of lines in input tbl',g_oe_line_tbl.LAST);
241: rlm_core_sv.dlog(k_DEBUG,'# of lines in output table',l_oe_line_tbl_out.LAST);
242: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status',x_return_Status);
243: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
244: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
245: END IF;
246: --

Line 243: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);

239: --
240: rlm_core_sv.dlog(k_DEBUG,'# of lines in input tbl',g_oe_line_tbl.LAST);
241: rlm_core_sv.dlog(k_DEBUG,'# of lines in output table',l_oe_line_tbl_out.LAST);
242: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status',x_return_Status);
243: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
244: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
245: END IF;
246: --
247: g_total_lines := g_total_lines + g_oe_line_tbl.LAST;

Line 244: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);

240: rlm_core_sv.dlog(k_DEBUG,'# of lines in input tbl',g_oe_line_tbl.LAST);
241: rlm_core_sv.dlog(k_DEBUG,'# of lines in output table',l_oe_line_tbl_out.LAST);
242: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status',x_return_Status);
243: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
244: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
245: END IF;
246: --
247: g_total_lines := g_total_lines + g_oe_line_tbl.LAST;
248: g_total_time := g_total_time + ((l_end_time-l_start_time)/100);

Line 274: rlm_core_sv.dpop(k_SDEBUG,'successful');

270: --
271: END IF;
272: --
273: IF (l_debug <> -1) THEN
274: rlm_core_sv.dpop(k_SDEBUG,'successful');
275: END IF;
276: --
277: --x_return_status := 'E';
278: --

Line 297: rlm_core_sv.dlog(k_DEBUG, 'Line return status', l_oe_line_tbl_out(s).return_status);

293: --
294: FOR s IN 1 .. l_oe_line_tbl_out.COUNT LOOP
295: --
296: IF (l_debug <> -1) THEN
297: rlm_core_sv.dlog(k_DEBUG, 'Line return status', l_oe_line_tbl_out(s).return_status);
298: END IF;
299: --
300: IF l_oe_line_tbl_out(s).return_status <> FND_API.G_RET_STS_SUCCESS THEN
301: --

Line 303: SET process_status = rlm_core_sv.k_PS_ERROR

299: --
300: IF l_oe_line_tbl_out(s).return_status <> FND_API.G_RET_STS_SUCCESS THEN
301: --
302: UPDATE rlm_schedule_lines_all
303: SET process_status = rlm_core_sv.k_PS_ERROR
304: WHERE line_id = l_oe_line_tbl_out(s).source_document_line_id;
305: --
306: BEGIN
307: --

Line 309: SET process_status = rlm_core_sv.k_PS_ERROR

305: --
306: BEGIN
307: --
308: UPDATE rlm_interface_lines_all
309: SET process_status = rlm_core_sv.k_PS_ERROR
310: WHERE line_id =
311: (
312: SELECT interface_line_id
313: FROM rlm_schedule_lines_all

Line 318: rlm_core_sv.dlog(k_DEBUG, 'No of Interface Lines updated', SQL%ROWCOUNT);

314: WHERE line_id = l_oe_line_tbl_out(s).source_document_line_id
315: );
316: --
317: IF (l_debug <> -1) THEN
318: rlm_core_sv.dlog(k_DEBUG, 'No of Interface Lines updated', SQL%ROWCOUNT);
319: END IF;
320: --
321: EXCEPTION
322: --

Line 326: rlm_core_sv.dlog(k_DEBUG, 'Interface Line not found for

322: --
323: WHEN OTHERS THEN
324: --
325: IF (l_debug <> -1) THEN
326: rlm_core_sv.dlog(k_DEBUG, 'Interface Line not found for
327: Source Document Line Id', l_oe_line_tbl_out(s).source_document_line_id);
328: END IF;
329: --
330: END;

Line 335: SET process_status = rlm_core_sv.k_PS_PROCESSED

331: --
332: ELSE
333: --
334: UPDATE rlm_schedule_lines_all
335: SET process_status = rlm_core_sv.k_PS_PROCESSED
336: WHERE line_id = l_oe_line_tbl_out(s).source_document_line_id;
337: --
338: BEGIN
339: --

Line 341: SET process_status = rlm_core_sv.k_PS_PROCESSED

337: --
338: BEGIN
339: --
340: UPDATE rlm_interface_lines_all
341: SET process_status = rlm_core_sv.k_PS_PROCESSED
342: WHERE line_id =
343: (
344: SELECT interface_line_id
345: FROM rlm_schedule_lines_all

Line 350: rlm_core_sv.dlog(k_DEBUG, 'No of Interface Lines updated', SQL%ROWCOUNT);

346: WHERE line_id = l_oe_line_tbl_out(s).source_document_line_id
347: );
348: --
349: IF (l_debug <> -1) THEN
350: rlm_core_sv.dlog(k_DEBUG, 'No of Interface Lines updated', SQL%ROWCOUNT);
351: END IF;
352: --
353: EXCEPTION
354: --

Line 358: rlm_core_sv.dlog(k_DEBUG, 'Interface Line not found for

354: --
355: WHEN OTHERS THEN
356: --
357: IF (l_debug <> -1) THEN
358: rlm_core_sv.dlog(k_DEBUG, 'Interface Line not found for
359: Source Document Line Id', l_oe_line_tbl_out(s).source_document_line_id);
360: END IF;
361: --
362: END;

Line 371: rlm_core_sv.dpop(k_SDEBUG);

367: --
368: END IF;/*2342919*/
369: --
370: IF (l_debug <> -1) THEN
371: rlm_core_sv.dpop(k_SDEBUG);
372: END IF;
373: --
374: WHEN e_BuildOELineTab THEN
375: --

Line 389: rlm_core_sv.dlog(k_DEBUG,'Build OE Line Tab returned failed', x_return_Status);

385: x_Token1 => 'ERROR',
386: x_value1 => substr(sqlerrm,1,200));
387: --
388: IF (l_debug <> -1) THEN
389: rlm_core_sv.dlog(k_DEBUG,'Build OE Line Tab returned failed', x_return_Status);
390: rlm_core_sv.dlog(k_DEBUG,'Error',substr(sqlerrm,1,200));
391: rlm_core_sv.dpop(k_SDEBUG);
392: END IF;
393: --

Line 390: rlm_core_sv.dlog(k_DEBUG,'Error',substr(sqlerrm,1,200));

386: x_value1 => substr(sqlerrm,1,200));
387: --
388: IF (l_debug <> -1) THEN
389: rlm_core_sv.dlog(k_DEBUG,'Build OE Line Tab returned failed', x_return_Status);
390: rlm_core_sv.dlog(k_DEBUG,'Error',substr(sqlerrm,1,200));
391: rlm_core_sv.dpop(k_SDEBUG);
392: END IF;
393: --
394: WHEN OTHERS THEN

Line 391: rlm_core_sv.dpop(k_SDEBUG);

387: --
388: IF (l_debug <> -1) THEN
389: rlm_core_sv.dlog(k_DEBUG,'Build OE Line Tab returned failed', x_return_Status);
390: rlm_core_sv.dlog(k_DEBUG,'Error',substr(sqlerrm,1,200));
391: rlm_core_sv.dpop(k_SDEBUG);
392: END IF;
393: --
394: WHEN OTHERS THEN
395: --

Line 397: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

393: --
394: WHEN OTHERS THEN
395: --
396: IF (l_debug <> -1) THEN
397: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
398: END IF;
399: --
400: raise;
401: --

Line 448: rlm_core_sv.dpush(k_SDEBUG,'InsertOMMessages');

444: --
445: BEGIN
446: --
447: IF (l_debug <> -1) THEN
448: rlm_core_sv.dpush(k_SDEBUG,'InsertOMMessages');
449: rlm_core_sv.dlog(k_DEBUG,'x_msg_count',x_msg_count);
450: rlm_core_sv.dlog(k_DEBUG,'x_msg_name',x_msg_name);
451: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
452: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);

Line 449: rlm_core_sv.dlog(k_DEBUG,'x_msg_count',x_msg_count);

445: BEGIN
446: --
447: IF (l_debug <> -1) THEN
448: rlm_core_sv.dpush(k_SDEBUG,'InsertOMMessages');
449: rlm_core_sv.dlog(k_DEBUG,'x_msg_count',x_msg_count);
450: rlm_core_sv.dlog(k_DEBUG,'x_msg_name',x_msg_name);
451: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
452: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);
453: rlm_core_sv.dlog(k_DEBUG,'x_header_id',x_header_id);

Line 450: rlm_core_sv.dlog(k_DEBUG,'x_msg_name',x_msg_name);

446: --
447: IF (l_debug <> -1) THEN
448: rlm_core_sv.dpush(k_SDEBUG,'InsertOMMessages');
449: rlm_core_sv.dlog(k_DEBUG,'x_msg_count',x_msg_count);
450: rlm_core_sv.dlog(k_DEBUG,'x_msg_name',x_msg_name);
451: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
452: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);
453: rlm_core_sv.dlog(k_DEBUG,'x_header_id',x_header_id);
454: rlm_core_sv.dlog(k_DEBUG,'x_customer_item_id', x_customer_item_id);

Line 451: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);

447: IF (l_debug <> -1) THEN
448: rlm_core_sv.dpush(k_SDEBUG,'InsertOMMessages');
449: rlm_core_sv.dlog(k_DEBUG,'x_msg_count',x_msg_count);
450: rlm_core_sv.dlog(k_DEBUG,'x_msg_name',x_msg_name);
451: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
452: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);
453: rlm_core_sv.dlog(k_DEBUG,'x_header_id',x_header_id);
454: rlm_core_sv.dlog(k_DEBUG,'x_customer_item_id', x_customer_item_id);
455: rlm_core_sv.dlog(k_DEBUG,'oe_msg_pub.count_msg',oe_msg_pub.count_msg);

Line 452: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);

448: rlm_core_sv.dpush(k_SDEBUG,'InsertOMMessages');
449: rlm_core_sv.dlog(k_DEBUG,'x_msg_count',x_msg_count);
450: rlm_core_sv.dlog(k_DEBUG,'x_msg_name',x_msg_name);
451: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
452: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);
453: rlm_core_sv.dlog(k_DEBUG,'x_header_id',x_header_id);
454: rlm_core_sv.dlog(k_DEBUG,'x_customer_item_id', x_customer_item_id);
455: rlm_core_sv.dlog(k_DEBUG,'oe_msg_pub.count_msg',oe_msg_pub.count_msg);
456: END IF;

Line 453: rlm_core_sv.dlog(k_DEBUG,'x_header_id',x_header_id);

449: rlm_core_sv.dlog(k_DEBUG,'x_msg_count',x_msg_count);
450: rlm_core_sv.dlog(k_DEBUG,'x_msg_name',x_msg_name);
451: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
452: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);
453: rlm_core_sv.dlog(k_DEBUG,'x_header_id',x_header_id);
454: rlm_core_sv.dlog(k_DEBUG,'x_customer_item_id', x_customer_item_id);
455: rlm_core_sv.dlog(k_DEBUG,'oe_msg_pub.count_msg',oe_msg_pub.count_msg);
456: END IF;
457: --

Line 454: rlm_core_sv.dlog(k_DEBUG,'x_customer_item_id', x_customer_item_id);

450: rlm_core_sv.dlog(k_DEBUG,'x_msg_name',x_msg_name);
451: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
452: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);
453: rlm_core_sv.dlog(k_DEBUG,'x_header_id',x_header_id);
454: rlm_core_sv.dlog(k_DEBUG,'x_customer_item_id', x_customer_item_id);
455: rlm_core_sv.dlog(k_DEBUG,'oe_msg_pub.count_msg',oe_msg_pub.count_msg);
456: END IF;
457: --
458: -- Get message count and data

Line 455: rlm_core_sv.dlog(k_DEBUG,'oe_msg_pub.count_msg',oe_msg_pub.count_msg);

451: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
452: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);
453: rlm_core_sv.dlog(k_DEBUG,'x_header_id',x_header_id);
454: rlm_core_sv.dlog(k_DEBUG,'x_customer_item_id', x_customer_item_id);
455: rlm_core_sv.dlog(k_DEBUG,'oe_msg_pub.count_msg',oe_msg_pub.count_msg);
456: END IF;
457: --
458: -- Get message count and data
459: -- Bug 4297984

Line 464: rlm_core_sv.dlog(k_DEBUG,'v_PO_msg',v_PO_msg);

460: fnd_message.set_name ('ONT','OE_VAL_DUP_PO_NUMBER');
461: v_PO_msg := fnd_message.get;
462: --
463: IF (l_debug <> -1) THEN
464: rlm_core_sv.dlog(k_DEBUG,'v_PO_msg',v_PO_msg);
465: END IF;
466: --
467: IF x_msg_count > 0 THEN
468: --{

Line 475: rlm_core_sv.dlog(k_DEBUG, 'Message at index', I);

471: x_msg := oe_msg_pub.get(p_msg_index => I,
472: p_encoded => 'F');
473: --
474: IF (l_debug <> -1) THEN
475: rlm_core_sv.dlog(k_DEBUG, 'Message at index', I);
476: rlm_core_sv.dlog(k_DEBUG,'Message Found', substr(x_msg,1,200));
477: rlm_core_sv.dlog(k_DEBUG,'get message context');
478: END IF;
479: --

Line 476: rlm_core_sv.dlog(k_DEBUG,'Message Found', substr(x_msg,1,200));

472: p_encoded => 'F');
473: --
474: IF (l_debug <> -1) THEN
475: rlm_core_sv.dlog(k_DEBUG, 'Message at index', I);
476: rlm_core_sv.dlog(k_DEBUG,'Message Found', substr(x_msg,1,200));
477: rlm_core_sv.dlog(k_DEBUG,'get message context');
478: END IF;
479: --
480: IF (substr(x_msg,1,200) <> v_PO_msg) THEN -- Bug 4297984

Line 477: rlm_core_sv.dlog(k_DEBUG,'get message context');

473: --
474: IF (l_debug <> -1) THEN
475: rlm_core_sv.dlog(k_DEBUG, 'Message at index', I);
476: rlm_core_sv.dlog(k_DEBUG,'Message Found', substr(x_msg,1,200));
477: rlm_core_sv.dlog(k_DEBUG,'get message context');
478: END IF;
479: --
480: IF (substr(x_msg,1,200) <> v_PO_msg) THEN -- Bug 4297984
481: --

Line 505: rlm_core_sv.dlog(k_DEBUG, 'schedule line',

501: ,x_type => l_type
502: );
503: --
504: IF (l_debug <> -1) THEN
505: rlm_core_sv.dlog(k_DEBUG, 'schedule line',
506: l_source_document_line_id);
507: rlm_core_sv.dlog(k_DEBUG, 'ProcessOrderAPI Error',
508: substr(x_msg,1,200));
509: END IF;

Line 507: rlm_core_sv.dlog(k_DEBUG, 'ProcessOrderAPI Error',

503: --
504: IF (l_debug <> -1) THEN
505: rlm_core_sv.dlog(k_DEBUG, 'schedule line',
506: l_source_document_line_id);
507: rlm_core_sv.dlog(k_DEBUG, 'ProcessOrderAPI Error',
508: substr(x_msg,1,200));
509: END IF;
510: --
511: IF NVL(l_source_document_line_id,FND_API.G_MISS_NUM) <>

Line 521: rlm_core_sv.dlog(k_DEBUG,'interface line',v_interface_line_id);

517: FROM rlm_schedule_lines
518: WHERE line_id = l_source_document_line_id;
519: --
520: IF (l_debug <> -1) THEN
521: rlm_core_sv.dlog(k_DEBUG,'interface line',v_interface_line_id);
522: END IF;
523: --
524: EXCEPTION
525: --

Line 529: rlm_core_sv.dlog(k_DEBUG,'Could not get interface line');

525: --
526: WHEN OTHERS THEN
527: --
528: IF (l_debug <> -1) THEN
529: rlm_core_sv.dlog(k_DEBUG,'Could not get interface line');
530: END IF;
531: --
532: END;
533: END IF;

Line 536: rlm_core_sv.dlog(k_DEBUG,'l_source_document_id', l_source_document_id);

532: END;
533: END IF;
534: --
535: IF (l_debug <> -1) THEN
536: rlm_core_sv.dlog(k_DEBUG,'l_source_document_id', l_source_document_id);
537: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id', v_schedule_header_id);
538: rlm_core_sv.dlog(k_DEBUG,'l_header_id', l_header_id);
539: rlm_core_sv.dlog(k_DEBUG,'order_header_id', v_order_header_id);
540: rlm_core_sv.dlog(k_DEBUG,'x_msg_level', x_msg_level);

Line 537: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id', v_schedule_header_id);

533: END IF;
534: --
535: IF (l_debug <> -1) THEN
536: rlm_core_sv.dlog(k_DEBUG,'l_source_document_id', l_source_document_id);
537: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id', v_schedule_header_id);
538: rlm_core_sv.dlog(k_DEBUG,'l_header_id', l_header_id);
539: rlm_core_sv.dlog(k_DEBUG,'order_header_id', v_order_header_id);
540: rlm_core_sv.dlog(k_DEBUG,'x_msg_level', x_msg_level);
541: rlm_core_sv.dlog(k_DEBUG,'x_msg_name', x_msg_name);

Line 538: rlm_core_sv.dlog(k_DEBUG,'l_header_id', l_header_id);

534: --
535: IF (l_debug <> -1) THEN
536: rlm_core_sv.dlog(k_DEBUG,'l_source_document_id', l_source_document_id);
537: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id', v_schedule_header_id);
538: rlm_core_sv.dlog(k_DEBUG,'l_header_id', l_header_id);
539: rlm_core_sv.dlog(k_DEBUG,'order_header_id', v_order_header_id);
540: rlm_core_sv.dlog(k_DEBUG,'x_msg_level', x_msg_level);
541: rlm_core_sv.dlog(k_DEBUG,'x_msg_name', x_msg_name);
542: END IF;

Line 539: rlm_core_sv.dlog(k_DEBUG,'order_header_id', v_order_header_id);

535: IF (l_debug <> -1) THEN
536: rlm_core_sv.dlog(k_DEBUG,'l_source_document_id', l_source_document_id);
537: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id', v_schedule_header_id);
538: rlm_core_sv.dlog(k_DEBUG,'l_header_id', l_header_id);
539: rlm_core_sv.dlog(k_DEBUG,'order_header_id', v_order_header_id);
540: rlm_core_sv.dlog(k_DEBUG,'x_msg_level', x_msg_level);
541: rlm_core_sv.dlog(k_DEBUG,'x_msg_name', x_msg_name);
542: END IF;
543: --

Line 540: rlm_core_sv.dlog(k_DEBUG,'x_msg_level', x_msg_level);

536: rlm_core_sv.dlog(k_DEBUG,'l_source_document_id', l_source_document_id);
537: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id', v_schedule_header_id);
538: rlm_core_sv.dlog(k_DEBUG,'l_header_id', l_header_id);
539: rlm_core_sv.dlog(k_DEBUG,'order_header_id', v_order_header_id);
540: rlm_core_sv.dlog(k_DEBUG,'x_msg_level', x_msg_level);
541: rlm_core_sv.dlog(k_DEBUG,'x_msg_name', x_msg_name);
542: END IF;
543: --
544: oe_debug_pub.add(substr(x_msg,1,200));

Line 541: rlm_core_sv.dlog(k_DEBUG,'x_msg_name', x_msg_name);

537: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id', v_schedule_header_id);
538: rlm_core_sv.dlog(k_DEBUG,'l_header_id', l_header_id);
539: rlm_core_sv.dlog(k_DEBUG,'order_header_id', v_order_header_id);
540: rlm_core_sv.dlog(k_DEBUG,'x_msg_level', x_msg_level);
541: rlm_core_sv.dlog(k_DEBUG,'x_msg_name', x_msg_name);
542: END IF;
543: --
544: oe_debug_pub.add(substr(x_msg,1,200));
545: --

Line 563: rlm_core_sv.dlog(k_DEBUG, 'l_msg_level', l_msg_level);

559: l_msg_level := x_msg_level;
560: END IF;
561: --
562: IF (l_debug<> -1) THEN
563: rlm_core_sv.dlog(k_DEBUG, 'l_msg_level', l_msg_level);
564: END IF;
565: --
566: rlm_message_sv.app_error(
567: x_ExceptionLevel => l_msg_level,

Line 578: x_value2 => rlm_core_sv.get_item_number(x_customer_item_id),

574: x_OrderLineId => l_line_id,
575: x_Token1 => x_token,
576: x_value1 => substr(x_msg,1,200),
577: x_Token2 => 'CUST_ITEM',
578: x_value2 => rlm_core_sv.get_item_number(x_customer_item_id),
579: x_Token3 => 'REQ_DATE',
580: x_value3 => v_request_date);
581: --
582: IF (l_debug <> -1) THEN

Line 583: rlm_core_sv.dlog(k_DEBUG,'x_msg', substr(x_msg,1,200));

579: x_Token3 => 'REQ_DATE',
580: x_value3 => v_request_date);
581: --
582: IF (l_debug <> -1) THEN
583: rlm_core_sv.dlog(k_DEBUG,'x_msg', substr(x_msg,1,200));
584: END IF;
585: --
586: END IF; -- Bug 4297984
587: --

Line 594: rlm_core_sv.dlog(k_DEBUG, 'Inserting RLM_PROCESS_ORDER_ERROR_E msg');

590: ELSIF (x_msg_count = 0 AND
591: (x_msg_level = 'U' OR x_msg_level = 'E')) THEN
592: --{
593: IF (l_debug <> -1) THEN
594: rlm_core_sv.dlog(k_DEBUG, 'Inserting RLM_PROCESS_ORDER_ERROR_E msg');
595: END IF;
596: --
597: rlm_message_sv.app_error(
598: x_ExceptionLevel => rlm_message_sv.k_error_level,

Line 609: x_Value2 => rlm_core_sv.get_item_number(x_customer_item_id)

605: x_OrderLineId => NULL,
606: x_Token1 => 'ERROR',
607: x_value1 => substr(sqlerrm,1,200),
608: x_Token2 => 'CUST_ITEM',
609: x_Value2 => rlm_core_sv.get_item_number(x_customer_item_id)
610: );
611: --}
612: END IF;
613: --

Line 615: rlm_core_sv.dpop(k_SDEBUG,'successful');

611: --}
612: END IF;
613: --
614: IF (l_debug <> -1) THEN
615: rlm_core_sv.dpop(k_SDEBUG,'successful');
616: END IF;
617: --
618: EXCEPTION
619: --

Line 623: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

619: --
620: WHEN OTHERS THEN
621: --
622: IF (l_debug <> -1) THEN
623: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
624: END IF;
625: --
626: raise;
627: END InsertOMMessages;

Line 683: rlm_core_sv.dpush(k_SDEBUG,'CallProcessConstraintAPI');

679: --
680: BEGIN
681: --
682: IF (l_debug <> -1) THEN
683: rlm_core_sv.dpush(k_SDEBUG,'CallProcessConstraintAPI');
684: rlm_core_sv.dlog(k_DEBUG,'x_Operation',x_Operation);
685: END IF;
686: --
687: l_line_tbl(1) := oe_order_pub.g_miss_line_rec;

Line 684: rlm_core_sv.dlog(k_DEBUG,'x_Operation',x_Operation);

680: BEGIN
681: --
682: IF (l_debug <> -1) THEN
683: rlm_core_sv.dpush(k_SDEBUG,'CallProcessConstraintAPI');
684: rlm_core_sv.dlog(k_DEBUG,'x_Operation',x_Operation);
685: END IF;
686: --
687: l_line_tbl(1) := oe_order_pub.g_miss_line_rec;
688: RLM_TPA_SV.BuildOELine(l_line_tbl(1),x_Key_rec.req_rec);

Line 694: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).operation',

690: l_line_tbl(1).operation := x_Operation;
691: l_line_tbl(1).ordered_quantity := x_OperationQty;
692: --
693: IF (l_debug <> -1) THEN
694: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).operation',
695: l_line_tbl(1).operation);
696: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).line_id',
697: l_line_tbl(1).line_id);
698: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).ordered_quantity',

Line 696: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).line_id',

692: --
693: IF (l_debug <> -1) THEN
694: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).operation',
695: l_line_tbl(1).operation);
696: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).line_id',
697: l_line_tbl(1).line_id);
698: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).ordered_quantity',
699: l_line_tbl(1).ordered_quantity);
700: END IF;

Line 698: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).ordered_quantity',

694: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).operation',
695: l_line_tbl(1).operation);
696: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).line_id',
697: l_line_tbl(1).line_id);
698: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).ordered_quantity',
699: l_line_tbl(1).ordered_quantity);
700: END IF;
701: --
702: fnd_profile.get(rlm_core_sv.C_DEBUG_PROFILE, v_DebugMode);

Line 702: fnd_profile.get(rlm_core_sv.C_DEBUG_PROFILE, v_DebugMode);

698: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).ordered_quantity',
699: l_line_tbl(1).ordered_quantity);
700: END IF;
701: --
702: fnd_profile.get(rlm_core_sv.C_DEBUG_PROFILE, v_DebugMode);
703: --
704: oe_debug_pub.add('Calling Process_order from DSP');
705: --
706: IF (l_debug <> -1) THEN

Line 707: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.G_DEBUG);

703: --
704: oe_debug_pub.add('Calling Process_order from DSP');
705: --
706: IF (l_debug <> -1) THEN
707: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.G_DEBUG);
708: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
709: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
710: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);
711: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);

Line 708: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));

704: oe_debug_pub.add('Calling Process_order from DSP');
705: --
706: IF (l_debug <> -1) THEN
707: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.G_DEBUG);
708: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
709: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
710: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);
711: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
712: rlm_core_sv.dlog(k_DEBUG,'G_FILE',OE_DEBUG_PUB.G_FILE);

Line 709: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);

705: --
706: IF (l_debug <> -1) THEN
707: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.G_DEBUG);
708: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
709: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
710: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);
711: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
712: rlm_core_sv.dlog(k_DEBUG,'G_FILE',OE_DEBUG_PUB.G_FILE);
713: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for process Constraints in DSP concurrent request log');

Line 710: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);

706: IF (l_debug <> -1) THEN
707: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.G_DEBUG);
708: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
709: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
710: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);
711: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
712: rlm_core_sv.dlog(k_DEBUG,'G_FILE',OE_DEBUG_PUB.G_FILE);
713: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for process Constraints in DSP concurrent request log');
714: END IF;

Line 711: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);

707: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.G_DEBUG);
708: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
709: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
710: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);
711: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
712: rlm_core_sv.dlog(k_DEBUG,'G_FILE',OE_DEBUG_PUB.G_FILE);
713: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for process Constraints in DSP concurrent request log');
714: END IF;
715: --

Line 712: rlm_core_sv.dlog(k_DEBUG,'G_FILE',OE_DEBUG_PUB.G_FILE);

708: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
709: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
710: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);
711: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
712: rlm_core_sv.dlog(k_DEBUG,'G_FILE',OE_DEBUG_PUB.G_FILE);
713: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for process Constraints in DSP concurrent request log');
714: END IF;
715: --
716: oe_order_grp.Process_order

Line 713: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for process Constraints in DSP concurrent request log');

709: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
710: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);
711: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
712: rlm_core_sv.dlog(k_DEBUG,'G_FILE',OE_DEBUG_PUB.G_FILE);
713: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for process Constraints in DSP concurrent request log');
714: END IF;
715: --
716: oe_order_grp.Process_order
717: ( p_api_version_number => x_api_version_number

Line 748: rlm_core_sv.dlog(k_DEBUG,'File Name',OE_DEBUG_PUB.G_FILE);

744: , x_lot_serial_val_tbl => l_lot_serial_val_tbl
745: );
746: --
747: IF (l_debug <> -1) THEN
748: rlm_core_sv.dlog(k_DEBUG,'File Name',OE_DEBUG_PUB.G_FILE);
749: rlm_core_sv.dlog(k_DEBUG,'l_return_status',l_return_status);
750: END IF;
751: --
752: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 749: rlm_core_sv.dlog(k_DEBUG,'l_return_status',l_return_status);

745: );
746: --
747: IF (l_debug <> -1) THEN
748: rlm_core_sv.dlog(k_DEBUG,'File Name',OE_DEBUG_PUB.G_FILE);
749: rlm_core_sv.dlog(k_DEBUG,'l_return_status',l_return_status);
750: END IF;
751: --
752: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 761: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);

757: --
758: b_result := FALSE;
759: --
760: IF (l_debug <> -1) THEN
761: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
762: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
763: rlm_core_sv.dlog(k_DEBUG,'no of lines in g_oe_line_tbl',g_oe_line_tbl.LAST);
764: rlm_core_sv.dpop(k_SDEBUG,' no process constraints found -- returning false');
765: END IF;

Line 762: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);

758: b_result := FALSE;
759: --
760: IF (l_debug <> -1) THEN
761: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
762: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
763: rlm_core_sv.dlog(k_DEBUG,'no of lines in g_oe_line_tbl',g_oe_line_tbl.LAST);
764: rlm_core_sv.dpop(k_SDEBUG,' no process constraints found -- returning false');
765: END IF;
766: --

Line 763: rlm_core_sv.dlog(k_DEBUG,'no of lines in g_oe_line_tbl',g_oe_line_tbl.LAST);

759: --
760: IF (l_debug <> -1) THEN
761: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
762: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
763: rlm_core_sv.dlog(k_DEBUG,'no of lines in g_oe_line_tbl',g_oe_line_tbl.LAST);
764: rlm_core_sv.dpop(k_SDEBUG,' no process constraints found -- returning false');
765: END IF;
766: --
767: END IF;

Line 764: rlm_core_sv.dpop(k_SDEBUG,' no process constraints found -- returning false');

760: IF (l_debug <> -1) THEN
761: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
762: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
763: rlm_core_sv.dlog(k_DEBUG,'no of lines in g_oe_line_tbl',g_oe_line_tbl.LAST);
764: rlm_core_sv.dpop(k_SDEBUG,' no process constraints found -- returning false');
765: END IF;
766: --
767: END IF;
768: --

Line 778: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status

774: --
775: b_result := TRUE;
776: --
777: IF (l_debug <> -1) THEN
778: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
779: FND_API.G_RET_STS_ERROR');
780: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
781: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
782: END IF;

Line 780: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);

776: --
777: IF (l_debug <> -1) THEN
778: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
779: FND_API.G_RET_STS_ERROR');
780: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
781: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
782: END IF;
783: --
784: --x_Qty_rec.reconcile := l_line_out_Tbl(1).ordered_quantity;

Line 781: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);

777: IF (l_debug <> -1) THEN
778: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
779: FND_API.G_RET_STS_ERROR');
780: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
781: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
782: END IF;
783: --
784: --x_Qty_rec.reconcile := l_line_out_Tbl(1).ordered_quantity;
785: --x_Qty_rec.available_to_cancel := l_line_out_Tbl(1).ordered_quantity;

Line 793: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);

789: x_msg_name := 'RLM_PROC_CONS_FOUND';
790: x_Token := 'CONSTRAINT';
791: --
792: IF (l_debug <> -1) THEN
793: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
794: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
795: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
796: x_Key_rec.req_rec.schedule_header_id);
797: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',

Line 794: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);

790: x_Token := 'CONSTRAINT';
791: --
792: IF (l_debug <> -1) THEN
793: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
794: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
795: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
796: x_Key_rec.req_rec.schedule_header_id);
797: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
798: x_Key_rec.req_rec.schedule_line_id);

Line 795: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',

791: --
792: IF (l_debug <> -1) THEN
793: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
794: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
795: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
796: x_Key_rec.req_rec.schedule_header_id);
797: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
798: x_Key_rec.req_rec.schedule_line_id);
799: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id', x_Key_rec.dem_rec.header_id);

Line 797: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',

793: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
794: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
795: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
796: x_Key_rec.req_rec.schedule_header_id);
797: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
798: x_Key_rec.req_rec.schedule_line_id);
799: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id', x_Key_rec.dem_rec.header_id);
800: rlm_core_sv.dlog(k_DEBUG,'dem_rec.line_id', x_Key_rec.dem_rec.line_id);
801: END IF;

Line 799: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id', x_Key_rec.dem_rec.header_id);

795: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
796: x_Key_rec.req_rec.schedule_header_id);
797: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
798: x_Key_rec.req_rec.schedule_line_id);
799: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id', x_Key_rec.dem_rec.header_id);
800: rlm_core_sv.dlog(k_DEBUG,'dem_rec.line_id', x_Key_rec.dem_rec.line_id);
801: END IF;
802: --
803: InsertOMMessages(x_Key_rec.req_rec.header_id,x_Key_rec.req_rec.customer_item_id,x_msg_count,

Line 800: rlm_core_sv.dlog(k_DEBUG,'dem_rec.line_id', x_Key_rec.dem_rec.line_id);

796: x_Key_rec.req_rec.schedule_header_id);
797: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
798: x_Key_rec.req_rec.schedule_line_id);
799: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id', x_Key_rec.dem_rec.header_id);
800: rlm_core_sv.dlog(k_DEBUG,'dem_rec.line_id', x_Key_rec.dem_rec.line_id);
801: END IF;
802: --
803: InsertOMMessages(x_Key_rec.req_rec.header_id,x_Key_rec.req_rec.customer_item_id,x_msg_count,
804: x_msg_level, x_token, x_msg_name);

Line 807: rlm_core_sv.dpop(k_SDEBUG,'in process Constraint found');

803: InsertOMMessages(x_Key_rec.req_rec.header_id,x_Key_rec.req_rec.customer_item_id,x_msg_count,
804: x_msg_level, x_token, x_msg_name);
805: --
806: IF (l_debug <> -1) THEN
807: rlm_core_sv.dpop(k_SDEBUG,'in process Constraint found');
808: END IF;
809: --
810: RETURN(b_Result);
811: --

Line 817: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status

813: --
814: b_result := TRUE;
815: --
816: IF (l_debug <> -1) THEN
817: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
818: FND_API.G_RET_STS_UNEXP_ERROR');
819: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
820: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
821: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);

Line 819: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);

815: --
816: IF (l_debug <> -1) THEN
817: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
818: FND_API.G_RET_STS_UNEXP_ERROR');
819: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
820: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
821: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
822: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
823: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',

Line 820: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);

816: IF (l_debug <> -1) THEN
817: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
818: FND_API.G_RET_STS_UNEXP_ERROR');
819: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
820: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
821: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
822: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
823: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
824: x_Key_rec.req_rec.schedule_header_id);

Line 821: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);

817: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
818: FND_API.G_RET_STS_UNEXP_ERROR');
819: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
820: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
821: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
822: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
823: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
824: x_Key_rec.req_rec.schedule_header_id);
825: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',

Line 822: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);

818: FND_API.G_RET_STS_UNEXP_ERROR');
819: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
820: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
821: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
822: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
823: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
824: x_Key_rec.req_rec.schedule_header_id);
825: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
826: x_Key_rec.req_rec.schedule_line_id);

Line 823: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',

819: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
820: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
821: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
822: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
823: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
824: x_Key_rec.req_rec.schedule_header_id);
825: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
826: x_Key_rec.req_rec.schedule_line_id);
827: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id',

Line 825: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',

821: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
822: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
823: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
824: x_Key_rec.req_rec.schedule_header_id);
825: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
826: x_Key_rec.req_rec.schedule_line_id);
827: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id',
828: x_Key_rec.dem_rec.header_id);
829: rlm_core_sv.dlog(k_DEBUG,'dem_rec.line_id',

Line 827: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id',

823: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
824: x_Key_rec.req_rec.schedule_header_id);
825: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
826: x_Key_rec.req_rec.schedule_line_id);
827: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id',
828: x_Key_rec.dem_rec.header_id);
829: rlm_core_sv.dlog(k_DEBUG,'dem_rec.line_id',
830: x_Key_rec.dem_rec.line_id);
831: END IF;

Line 829: rlm_core_sv.dlog(k_DEBUG,'dem_rec.line_id',

825: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
826: x_Key_rec.req_rec.schedule_line_id);
827: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id',
828: x_Key_rec.dem_rec.header_id);
829: rlm_core_sv.dlog(k_DEBUG,'dem_rec.line_id',
830: x_Key_rec.dem_rec.line_id);
831: END IF;
832: --
833: x_msg_level := rlm_message_sv.k_warn_level;

Line 841: rlm_core_sv.dpop(k_SDEBUG,'In process Constraint Unexpected error');

837: InsertOMMessages(x_Key_rec.req_rec.header_id,x_Key_rec.req_rec.customer_item_id,x_msg_count,
838: x_msg_level,x_token, x_msg_name);
839: --
840: IF (l_debug <> -1) THEN
841: rlm_core_sv.dpop(k_SDEBUG,'In process Constraint Unexpected error');
842: END IF;
843: --
844: RETURN(b_Result);
845: --

Line 851: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status', l_return_status);

847: --
848: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
849: --
850: IF (l_debug <> -1) THEN
851: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status', l_return_status);
852: rlm_core_sv.dlog(k_DEBUG,'EXCEPTION',SUBSTR(SQLERRM,1,200));
853: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
854: END IF;
855: --

Line 852: rlm_core_sv.dlog(k_DEBUG,'EXCEPTION',SUBSTR(SQLERRM,1,200));

848: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
849: --
850: IF (l_debug <> -1) THEN
851: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status', l_return_status);
852: rlm_core_sv.dlog(k_DEBUG,'EXCEPTION',SUBSTR(SQLERRM,1,200));
853: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
854: END IF;
855: --
856: raise;

Line 853: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

849: --
850: IF (l_debug <> -1) THEN
851: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status', l_return_status);
852: rlm_core_sv.dlog(k_DEBUG,'EXCEPTION',SUBSTR(SQLERRM,1,200));
853: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
854: END IF;
855: --
856: raise;
857:

Line 877: x_MatchWithin IN RLM_CORE_SV.T_MATCH_REC,

873: x_OrgId In NUMBER,
874: x_SchedType In VARCHAR2,
875: x_ShipperRecs In WSH_RLM_INTERFACE.t_shipper_rec,
876: x_ShipmentDate IN DATE,
877: x_MatchWithin IN RLM_CORE_SV.T_MATCH_REC,
878: x_MatchAcross IN RLM_CORE_SV.T_MATCH_REC,
879: x_Match_Rec IN WSH_RLM_INTERFACE.t_optional_match_rec,
880: x_header_id IN NUMBER,
881: x_InTransitQty OUT NOCOPY NUMBER,

Line 878: x_MatchAcross IN RLM_CORE_SV.T_MATCH_REC,

874: x_SchedType In VARCHAR2,
875: x_ShipperRecs In WSH_RLM_INTERFACE.t_shipper_rec,
876: x_ShipmentDate IN DATE,
877: x_MatchWithin IN RLM_CORE_SV.T_MATCH_REC,
878: x_MatchAcross IN RLM_CORE_SV.T_MATCH_REC,
879: x_Match_Rec IN WSH_RLM_INTERFACE.t_optional_match_rec,
880: x_header_id IN NUMBER,
881: x_InTransitQty OUT NOCOPY NUMBER,
882: x_return_status OUT NOCOPY VARCHAR2)

Line 892: v_MatchWithin RLM_CORE_SV.T_MATCH_REC;

888: v_details VARCHAR2(3000);
889: v_get_msg_count NUMBER;
890: -- global_atp
891: v_ship_from_org_id NUMBER;
892: v_MatchWithin RLM_CORE_SV.T_MATCH_REC;
893: v_MatchAcross RLM_CORE_SV.T_MATCH_REC;
894:
895: BEGIN
896: --

Line 893: v_MatchAcross RLM_CORE_SV.T_MATCH_REC;

889: v_get_msg_count NUMBER;
890: -- global_atp
891: v_ship_from_org_id NUMBER;
892: v_MatchWithin RLM_CORE_SV.T_MATCH_REC;
893: v_MatchAcross RLM_CORE_SV.T_MATCH_REC;
894:
895: BEGIN
896: --
897: IF (l_debug <> -1) THEN

Line 898: rlm_core_sv.dpush(k_SDEBUG,'GetIntransitQty');

894:
895: BEGIN
896: --
897: IF (l_debug <> -1) THEN
898: rlm_core_sv.dpush(k_SDEBUG,'GetIntransitQty');
899: --
900: -- Call shipping API
901: --
902: rlm_core_sv.dlog(k_DEBUG,'x_CustomerId', x_CustomerId);

Line 902: rlm_core_sv.dlog(k_DEBUG,'x_CustomerId', x_CustomerId);

898: rlm_core_sv.dpush(k_SDEBUG,'GetIntransitQty');
899: --
900: -- Call shipping API
901: --
902: rlm_core_sv.dlog(k_DEBUG,'x_CustomerId', x_CustomerId);
903: rlm_core_sv.dlog(k_DEBUG,'x_ShipToId', x_ShipToId);
904: rlm_core_sv.dlog(k_DEBUG,'x_intmed_ship_to_org_id', x_intmed_ship_to_org_id); --Bugfix 5911991
905: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
906: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);

Line 903: rlm_core_sv.dlog(k_DEBUG,'x_ShipToId', x_ShipToId);

899: --
900: -- Call shipping API
901: --
902: rlm_core_sv.dlog(k_DEBUG,'x_CustomerId', x_CustomerId);
903: rlm_core_sv.dlog(k_DEBUG,'x_ShipToId', x_ShipToId);
904: rlm_core_sv.dlog(k_DEBUG,'x_intmed_ship_to_org_id', x_intmed_ship_to_org_id); --Bugfix 5911991
905: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
906: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
907: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);

Line 904: rlm_core_sv.dlog(k_DEBUG,'x_intmed_ship_to_org_id', x_intmed_ship_to_org_id); --Bugfix 5911991

900: -- Call shipping API
901: --
902: rlm_core_sv.dlog(k_DEBUG,'x_CustomerId', x_CustomerId);
903: rlm_core_sv.dlog(k_DEBUG,'x_ShipToId', x_ShipToId);
904: rlm_core_sv.dlog(k_DEBUG,'x_intmed_ship_to_org_id', x_intmed_ship_to_org_id); --Bugfix 5911991
905: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
906: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
907: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
908: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);

Line 905: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);

901: --
902: rlm_core_sv.dlog(k_DEBUG,'x_CustomerId', x_CustomerId);
903: rlm_core_sv.dlog(k_DEBUG,'x_ShipToId', x_ShipToId);
904: rlm_core_sv.dlog(k_DEBUG,'x_intmed_ship_to_org_id', x_intmed_ship_to_org_id); --Bugfix 5911991
905: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
906: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
907: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
908: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
909: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);

Line 906: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);

902: rlm_core_sv.dlog(k_DEBUG,'x_CustomerId', x_CustomerId);
903: rlm_core_sv.dlog(k_DEBUG,'x_ShipToId', x_ShipToId);
904: rlm_core_sv.dlog(k_DEBUG,'x_intmed_ship_to_org_id', x_intmed_ship_to_org_id); --Bugfix 5911991
905: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
906: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
907: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
908: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
909: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);
910: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);

Line 907: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);

903: rlm_core_sv.dlog(k_DEBUG,'x_ShipToId', x_ShipToId);
904: rlm_core_sv.dlog(k_DEBUG,'x_intmed_ship_to_org_id', x_intmed_ship_to_org_id); --Bugfix 5911991
905: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
906: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
907: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
908: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
909: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);
910: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
911: rlm_core_sv.dlog(k_DEBUG,'x_ShipmentDate', x_ShipmentDate);

Line 908: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);

904: rlm_core_sv.dlog(k_DEBUG,'x_intmed_ship_to_org_id', x_intmed_ship_to_org_id); --Bugfix 5911991
905: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
906: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
907: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
908: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
909: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);
910: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
911: rlm_core_sv.dlog(k_DEBUG,'x_ShipmentDate', x_ShipmentDate);
912: rlm_core_sv.dlog(k_DEBUG,'x_orgId', x_OrgId);

Line 909: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);

905: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
906: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
907: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
908: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
909: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);
910: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
911: rlm_core_sv.dlog(k_DEBUG,'x_ShipmentDate', x_ShipmentDate);
912: rlm_core_sv.dlog(k_DEBUG,'x_orgId', x_OrgId);
913: END IF;

Line 910: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);

906: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
907: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
908: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
909: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);
910: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
911: rlm_core_sv.dlog(k_DEBUG,'x_ShipmentDate', x_ShipmentDate);
912: rlm_core_sv.dlog(k_DEBUG,'x_orgId', x_OrgId);
913: END IF;
914: --

Line 911: rlm_core_sv.dlog(k_DEBUG,'x_ShipmentDate', x_ShipmentDate);

907: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
908: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
909: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);
910: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
911: rlm_core_sv.dlog(k_DEBUG,'x_ShipmentDate', x_ShipmentDate);
912: rlm_core_sv.dlog(k_DEBUG,'x_orgId', x_OrgId);
913: END IF;
914: --
915: --global_atp

Line 912: rlm_core_sv.dlog(k_DEBUG,'x_orgId', x_OrgId);

908: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
909: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);
910: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
911: rlm_core_sv.dlog(k_DEBUG,'x_ShipmentDate', x_ShipmentDate);
912: rlm_core_sv.dlog(k_DEBUG,'x_orgId', x_OrgId);
913: END IF;
914: --
915: --global_atp
916:

Line 947: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute2', v_MatchWithin.industry_attribute2);

943: v_MatchWithin.schedule_date := 'N';
944: v_MatchAcross.schedule_date := 'N';
945: --
946: IF (l_debug <> -1) THEN
947: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute2', v_MatchWithin.industry_attribute2);
948: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute2', v_MatchAcross.industry_attribute2);
949: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute15', v_MatchWithin.industry_attribute15);
950: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
951: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);

Line 948: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute2', v_MatchAcross.industry_attribute2);

944: v_MatchAcross.schedule_date := 'N';
945: --
946: IF (l_debug <> -1) THEN
947: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute2', v_MatchWithin.industry_attribute2);
948: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute2', v_MatchAcross.industry_attribute2);
949: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute15', v_MatchWithin.industry_attribute15);
950: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
951: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);
952: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.request_date', v_MatchAcross.request_date);

Line 949: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute15', v_MatchWithin.industry_attribute15);

945: --
946: IF (l_debug <> -1) THEN
947: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute2', v_MatchWithin.industry_attribute2);
948: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute2', v_MatchAcross.industry_attribute2);
949: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute15', v_MatchWithin.industry_attribute15);
950: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
951: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);
952: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.request_date', v_MatchAcross.request_date);
953: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.schedule_date', v_MatchWithin.schedule_date);

Line 950: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);

946: IF (l_debug <> -1) THEN
947: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute2', v_MatchWithin.industry_attribute2);
948: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute2', v_MatchAcross.industry_attribute2);
949: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute15', v_MatchWithin.industry_attribute15);
950: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
951: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);
952: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.request_date', v_MatchAcross.request_date);
953: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.schedule_date', v_MatchWithin.schedule_date);
954: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.schedule_date', v_MatchAcross.schedule_date);

Line 951: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);

947: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute2', v_MatchWithin.industry_attribute2);
948: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute2', v_MatchAcross.industry_attribute2);
949: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute15', v_MatchWithin.industry_attribute15);
950: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
951: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);
952: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.request_date', v_MatchAcross.request_date);
953: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.schedule_date', v_MatchWithin.schedule_date);
954: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.schedule_date', v_MatchAcross.schedule_date);
955: END IF;

Line 952: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.request_date', v_MatchAcross.request_date);

948: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute2', v_MatchAcross.industry_attribute2);
949: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute15', v_MatchWithin.industry_attribute15);
950: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
951: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);
952: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.request_date', v_MatchAcross.request_date);
953: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.schedule_date', v_MatchWithin.schedule_date);
954: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.schedule_date', v_MatchAcross.schedule_date);
955: END IF;
956: --

Line 953: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.schedule_date', v_MatchWithin.schedule_date);

949: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute15', v_MatchWithin.industry_attribute15);
950: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
951: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);
952: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.request_date', v_MatchAcross.request_date);
953: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.schedule_date', v_MatchWithin.schedule_date);
954: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.schedule_date', v_MatchAcross.schedule_date);
955: END IF;
956: --
957: WSH_RLM_INTERFACE.Get_In_Transit_Qty(

Line 954: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.schedule_date', v_MatchAcross.schedule_date);

950: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
951: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);
952: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.request_date', v_MatchAcross.request_date);
953: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.schedule_date', v_MatchWithin.schedule_date);
954: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.schedule_date', v_MatchAcross.schedule_date);
955: END IF;
956: --
957: WSH_RLM_INTERFACE.Get_In_Transit_Qty(
958: p_source_code => 'OE',

Line 988: rlm_core_sv.dlog(k_DEBUG,'x_InTransitQty', x_InTransitQty);

984: --
985: ELSE
986: --
987: IF (l_debug <> -1) THEN
988: rlm_core_sv.dlog(k_DEBUG,'x_InTransitQty', x_InTransitQty);
989: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
990: END IF;
991: --
992: END IF;

Line 989: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);

985: ELSE
986: --
987: IF (l_debug <> -1) THEN
988: rlm_core_sv.dlog(k_DEBUG,'x_InTransitQty', x_InTransitQty);
989: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
990: END IF;
991: --
992: END IF;
993: --

Line 995: rlm_core_sv.dpop(k_SDEBUG);

991: --
992: END IF;
993: --
994: IF (l_debug <> -1) THEN
995: rlm_core_sv.dpop(k_SDEBUG);
996: END IF;
997: --
998: EXCEPTION
999: --

Line 1006: rlm_core_sv.dlog(k_DEBUG,'v_summary', v_summary );

1002: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1003: WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1004: --
1005: IF (l_debug <> -1) THEN
1006: rlm_core_sv.dlog(k_DEBUG,'v_summary', v_summary );
1007: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );
1008: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1009: END IF;
1010: --

Line 1007: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );

1003: WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1004: --
1005: IF (l_debug <> -1) THEN
1006: rlm_core_sv.dlog(k_DEBUG,'v_summary', v_summary );
1007: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );
1008: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1009: END IF;
1010: --
1011: rlm_message_sv.app_error(

Line 1008: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );

1004: --
1005: IF (l_debug <> -1) THEN
1006: rlm_core_sv.dlog(k_DEBUG,'v_summary', v_summary );
1007: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );
1008: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1009: END IF;
1010: --
1011: rlm_message_sv.app_error(
1012: x_ExceptionLevel => rlm_message_sv.k_error_level,

Line 1024: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);

1020: x_Token1 => 'ERROR',
1021: x_value1 => substr(v_summary,1,200));
1022: --
1023: IF (l_debug <> -1) THEN
1024: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1025: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: GetInstransitQty');
1026: END IF;
1027: --
1028: WHEN e_APIUnExpError THEN

Line 1025: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: GetInstransitQty');

1021: x_value1 => substr(v_summary,1,200));
1022: --
1023: IF (l_debug <> -1) THEN
1024: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1025: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: GetInstransitQty');
1026: END IF;
1027: --
1028: WHEN e_APIUnExpError THEN
1029: --

Line 1035: rlm_core_sv.dlog(k_DEBUG,'v_summary', v_summary );

1031: --
1032: WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1033: --
1034: IF (l_debug <> -1) THEN
1035: rlm_core_sv.dlog(k_DEBUG,'v_summary', v_summary );
1036: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );
1037: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1038: END IF;
1039: --

Line 1036: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );

1032: WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1033: --
1034: IF (l_debug <> -1) THEN
1035: rlm_core_sv.dlog(k_DEBUG,'v_summary', v_summary );
1036: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );
1037: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1038: END IF;
1039: --
1040: rlm_message_sv.app_error(

Line 1037: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );

1033: --
1034: IF (l_debug <> -1) THEN
1035: rlm_core_sv.dlog(k_DEBUG,'v_summary', v_summary );
1036: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );
1037: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1038: END IF;
1039: --
1040: rlm_message_sv.app_error(
1041: x_ExceptionLevel => rlm_message_sv.k_error_level,

Line 1053: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);

1049: x_Token1 => 'ERROR',
1050: x_value1 => substr(v_summary,1,200));
1051: --
1052: IF (l_debug <> -1) THEN
1053: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1054: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: GetInstransitQty');
1055: END IF;
1056: --
1057: WHEN OTHERS THEN

Line 1054: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: GetInstransitQty');

1050: x_value1 => substr(v_summary,1,200));
1051: --
1052: IF (l_debug <> -1) THEN
1053: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1054: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: GetInstransitQty');
1055: END IF;
1056: --
1057: WHEN OTHERS THEN
1058: --

Line 1060: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

1056: --
1057: WHEN OTHERS THEN
1058: --
1059: IF (l_debug <> -1) THEN
1060: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1061: END IF;
1062: --
1063: raise;
1064: --

Line 1092: rlm_core_sv.dpush(k_SDEBUG,'CheckShippingConstraints');

1088:
1089: BEGIN
1090: --
1091: IF (l_debug <> -1) THEN
1092: rlm_core_sv.dpush(k_SDEBUG,'CheckShippingConstraints');
1093: --
1094: -- Call shipping API
1095: --
1096: rlm_core_sv.dlog(k_DEBUG,'x_source_code', x_source_code);

Line 1096: rlm_core_sv.dlog(k_DEBUG,'x_source_code', x_source_code);

1092: rlm_core_sv.dpush(k_SDEBUG,'CheckShippingConstraints');
1093: --
1094: -- Call shipping API
1095: --
1096: rlm_core_sv.dlog(k_DEBUG,'x_source_code', x_source_code);
1097: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.source_line_id',x_changed_attributes.source_line_id);
1098: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.action_flag', x_changed_attributes.action_flag);
1099: rlm_core_sv.dlog(k_DEBUG,'x_log_level', x_log_level);
1100: rlm_core_sv.dlog(k_DEBUG,'x_header_id', x_header_id);

Line 1097: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.source_line_id',x_changed_attributes.source_line_id);

1093: --
1094: -- Call shipping API
1095: --
1096: rlm_core_sv.dlog(k_DEBUG,'x_source_code', x_source_code);
1097: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.source_line_id',x_changed_attributes.source_line_id);
1098: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.action_flag', x_changed_attributes.action_flag);
1099: rlm_core_sv.dlog(k_DEBUG,'x_log_level', x_log_level);
1100: rlm_core_sv.dlog(k_DEBUG,'x_header_id', x_header_id);
1101: rlm_core_sv.dlog(k_DEBUG,'x_order_header_id', x_order_header_id);

Line 1098: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.action_flag', x_changed_attributes.action_flag);

1094: -- Call shipping API
1095: --
1096: rlm_core_sv.dlog(k_DEBUG,'x_source_code', x_source_code);
1097: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.source_line_id',x_changed_attributes.source_line_id);
1098: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.action_flag', x_changed_attributes.action_flag);
1099: rlm_core_sv.dlog(k_DEBUG,'x_log_level', x_log_level);
1100: rlm_core_sv.dlog(k_DEBUG,'x_header_id', x_header_id);
1101: rlm_core_sv.dlog(k_DEBUG,'x_order_header_id', x_order_header_id);
1102: END IF;

Line 1099: rlm_core_sv.dlog(k_DEBUG,'x_log_level', x_log_level);

1095: --
1096: rlm_core_sv.dlog(k_DEBUG,'x_source_code', x_source_code);
1097: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.source_line_id',x_changed_attributes.source_line_id);
1098: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.action_flag', x_changed_attributes.action_flag);
1099: rlm_core_sv.dlog(k_DEBUG,'x_log_level', x_log_level);
1100: rlm_core_sv.dlog(k_DEBUG,'x_header_id', x_header_id);
1101: rlm_core_sv.dlog(k_DEBUG,'x_order_header_id', x_order_header_id);
1102: END IF;
1103: --

Line 1100: rlm_core_sv.dlog(k_DEBUG,'x_header_id', x_header_id);

1096: rlm_core_sv.dlog(k_DEBUG,'x_source_code', x_source_code);
1097: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.source_line_id',x_changed_attributes.source_line_id);
1098: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.action_flag', x_changed_attributes.action_flag);
1099: rlm_core_sv.dlog(k_DEBUG,'x_log_level', x_log_level);
1100: rlm_core_sv.dlog(k_DEBUG,'x_header_id', x_header_id);
1101: rlm_core_sv.dlog(k_DEBUG,'x_order_header_id', x_order_header_id);
1102: END IF;
1103: --
1104: WSH_SHIPPING_CONSTRAINTS_PKG.check_shipping_constraints(

Line 1101: rlm_core_sv.dlog(k_DEBUG,'x_order_header_id', x_order_header_id);

1097: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.source_line_id',x_changed_attributes.source_line_id);
1098: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.action_flag', x_changed_attributes.action_flag);
1099: rlm_core_sv.dlog(k_DEBUG,'x_log_level', x_log_level);
1100: rlm_core_sv.dlog(k_DEBUG,'x_header_id', x_header_id);
1101: rlm_core_sv.dlog(k_DEBUG,'x_order_header_id', x_order_header_id);
1102: END IF;
1103: --
1104: WSH_SHIPPING_CONSTRAINTS_PKG.check_shipping_constraints(
1105: p_source_code => x_source_code,

Line 1124: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);

1120: --
1121: ELSE
1122: --
1123: IF (l_debug <> -1) THEN
1124: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1125: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1126: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1127: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1128: END IF;

Line 1125: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);

1121: ELSE
1122: --
1123: IF (l_debug <> -1) THEN
1124: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1125: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1126: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1127: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1128: END IF;
1129: --

Line 1126: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);

1122: --
1123: IF (l_debug <> -1) THEN
1124: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1125: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1126: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1127: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1128: END IF;
1129: --
1130: END IF;

Line 1127: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);

1123: IF (l_debug <> -1) THEN
1124: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1125: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1126: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1127: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1128: END IF;
1129: --
1130: END IF;
1131: --

Line 1133: rlm_core_sv.dpop(k_SDEBUG);

1129: --
1130: END IF;
1131: --
1132: IF (l_debug <> -1) THEN
1133: rlm_core_sv.dpop(k_SDEBUG);
1134: END IF;
1135: --
1136: EXCEPTION
1137: --

Line 1145: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);

1141: --
1142: --WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1143: --
1144: IF (l_debug <> -1) THEN
1145: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1146: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1147: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1148: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1149: END IF;

Line 1146: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);

1142: --WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1143: --
1144: IF (l_debug <> -1) THEN
1145: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1146: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1147: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1148: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1149: END IF;
1150: --

Line 1147: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);

1143: --
1144: IF (l_debug <> -1) THEN
1145: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1146: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1147: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1148: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1149: END IF;
1150: --
1151: rlm_message_sv.app_error(

Line 1148: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);

1144: IF (l_debug <> -1) THEN
1145: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1146: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1147: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1148: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1149: END IF;
1150: --
1151: rlm_message_sv.app_error(
1152: x_ExceptionLevel => rlm_message_sv.k_error_level,

Line 1164: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);

1160: x_Token1 => 'ERROR',
1161: x_value1 => SUBSTR(SQLERRM,1,200));
1162: --
1163: IF (l_debug <> -1) THEN
1164: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1165: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: CallShippingConstraintsAPI');
1166: END IF;
1167: --
1168:

Line 1165: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: CallShippingConstraintsAPI');

1161: x_value1 => SUBSTR(SQLERRM,1,200));
1162: --
1163: IF (l_debug <> -1) THEN
1164: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1165: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: CallShippingConstraintsAPI');
1166: END IF;
1167: --
1168:
1169: WHEN e_APIExpError THEN

Line 1176: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);

1172: --
1173: --WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1174: --
1175: IF (l_debug <> -1) THEN
1176: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1177: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1178: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1179: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1180: END IF;

Line 1177: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);

1173: --WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1174: --
1175: IF (l_debug <> -1) THEN
1176: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1177: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1178: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1179: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1180: END IF;
1181: --

Line 1178: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);

1174: --
1175: IF (l_debug <> -1) THEN
1176: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1177: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1178: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1179: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1180: END IF;
1181: --
1182: rlm_message_sv.app_error(

Line 1179: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);

1175: IF (l_debug <> -1) THEN
1176: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1177: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1178: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1179: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1180: END IF;
1181: --
1182: rlm_message_sv.app_error(
1183: x_ExceptionLevel => rlm_message_sv.k_error_level,

Line 1195: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);

1191: x_Token1 => 'ERROR',
1192: x_value1 => x_action_message);
1193: --
1194: IF (l_debug <> -1) THEN
1195: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1196: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: CallShippingConstraintsAPI');
1197: END IF;
1198: --
1199:

Line 1196: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: CallShippingConstraintsAPI');

1192: x_value1 => x_action_message);
1193: --
1194: IF (l_debug <> -1) THEN
1195: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1196: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: CallShippingConstraintsAPI');
1197: END IF;
1198: --
1199:
1200: WHEN OTHERS THEN

Line 1203: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

1199:
1200: WHEN OTHERS THEN
1201: --
1202: IF (l_debug <> -1) THEN
1203: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1204: END IF;
1205: --
1206: RAISE;
1207: --

Line 1261: rlm_core_sv.dpush(k_SDEBUG,'BuildTPOELine');

1257: IS
1258: BEGIN
1259: --
1260: IF (l_debug <> -1) THEN
1261: rlm_core_sv.dpush(k_SDEBUG,'BuildTPOELine');
1262: END IF;
1263: --
1264: x_oe_line_rec.tp_attribute1 := x_Op_rec.tp_attribute1;
1265: x_oe_line_rec.tp_attribute2 := x_Op_rec.tp_attribute2;

Line 1282: rlm_core_sv.dlog(k_DEBUG,'tp_attribute1',

1278: x_oe_line_rec.tp_attribute15:= x_Op_rec.tp_attribute15;
1279: x_oe_line_rec.tp_context:= x_Op_rec.tp_attribute_category;
1280: --
1281: IF (l_debug <> -1) THEN
1282: rlm_core_sv.dlog(k_DEBUG,'tp_attribute1',
1283: x_Op_rec.tp_attribute1);
1284: rlm_core_sv.dlog(k_DEBUG,'tp_attribute2',
1285: x_Op_rec.tp_attribute2);
1286: rlm_core_sv.dlog(k_DEBUG,'tp_attribute3',

Line 1284: rlm_core_sv.dlog(k_DEBUG,'tp_attribute2',

1280: --
1281: IF (l_debug <> -1) THEN
1282: rlm_core_sv.dlog(k_DEBUG,'tp_attribute1',
1283: x_Op_rec.tp_attribute1);
1284: rlm_core_sv.dlog(k_DEBUG,'tp_attribute2',
1285: x_Op_rec.tp_attribute2);
1286: rlm_core_sv.dlog(k_DEBUG,'tp_attribute3',
1287: x_Op_rec.tp_attribute3);
1288: rlm_core_sv.dlog(k_DEBUG,'tp_attribute4',

Line 1286: rlm_core_sv.dlog(k_DEBUG,'tp_attribute3',

1282: rlm_core_sv.dlog(k_DEBUG,'tp_attribute1',
1283: x_Op_rec.tp_attribute1);
1284: rlm_core_sv.dlog(k_DEBUG,'tp_attribute2',
1285: x_Op_rec.tp_attribute2);
1286: rlm_core_sv.dlog(k_DEBUG,'tp_attribute3',
1287: x_Op_rec.tp_attribute3);
1288: rlm_core_sv.dlog(k_DEBUG,'tp_attribute4',
1289: x_Op_rec.tp_attribute4);
1290: rlm_core_sv.dlog(k_DEBUG,'tp_attribute5',

Line 1288: rlm_core_sv.dlog(k_DEBUG,'tp_attribute4',

1284: rlm_core_sv.dlog(k_DEBUG,'tp_attribute2',
1285: x_Op_rec.tp_attribute2);
1286: rlm_core_sv.dlog(k_DEBUG,'tp_attribute3',
1287: x_Op_rec.tp_attribute3);
1288: rlm_core_sv.dlog(k_DEBUG,'tp_attribute4',
1289: x_Op_rec.tp_attribute4);
1290: rlm_core_sv.dlog(k_DEBUG,'tp_attribute5',
1291: x_Op_rec.tp_attribute5);
1292: rlm_core_sv.dlog(k_DEBUG,'tp_attribute6',

Line 1290: rlm_core_sv.dlog(k_DEBUG,'tp_attribute5',

1286: rlm_core_sv.dlog(k_DEBUG,'tp_attribute3',
1287: x_Op_rec.tp_attribute3);
1288: rlm_core_sv.dlog(k_DEBUG,'tp_attribute4',
1289: x_Op_rec.tp_attribute4);
1290: rlm_core_sv.dlog(k_DEBUG,'tp_attribute5',
1291: x_Op_rec.tp_attribute5);
1292: rlm_core_sv.dlog(k_DEBUG,'tp_attribute6',
1293: x_Op_rec.tp_attribute6);
1294: rlm_core_sv.dlog(k_DEBUG,'tp_attribute7',

Line 1292: rlm_core_sv.dlog(k_DEBUG,'tp_attribute6',

1288: rlm_core_sv.dlog(k_DEBUG,'tp_attribute4',
1289: x_Op_rec.tp_attribute4);
1290: rlm_core_sv.dlog(k_DEBUG,'tp_attribute5',
1291: x_Op_rec.tp_attribute5);
1292: rlm_core_sv.dlog(k_DEBUG,'tp_attribute6',
1293: x_Op_rec.tp_attribute6);
1294: rlm_core_sv.dlog(k_DEBUG,'tp_attribute7',
1295: x_Op_rec.tp_attribute7);
1296: rlm_core_sv.dlog(k_DEBUG,'tp_attribute8',

Line 1294: rlm_core_sv.dlog(k_DEBUG,'tp_attribute7',

1290: rlm_core_sv.dlog(k_DEBUG,'tp_attribute5',
1291: x_Op_rec.tp_attribute5);
1292: rlm_core_sv.dlog(k_DEBUG,'tp_attribute6',
1293: x_Op_rec.tp_attribute6);
1294: rlm_core_sv.dlog(k_DEBUG,'tp_attribute7',
1295: x_Op_rec.tp_attribute7);
1296: rlm_core_sv.dlog(k_DEBUG,'tp_attribute8',
1297: x_Op_rec.tp_attribute8);
1298: rlm_core_sv.dlog(k_DEBUG,'tp_attribute9',

Line 1296: rlm_core_sv.dlog(k_DEBUG,'tp_attribute8',

1292: rlm_core_sv.dlog(k_DEBUG,'tp_attribute6',
1293: x_Op_rec.tp_attribute6);
1294: rlm_core_sv.dlog(k_DEBUG,'tp_attribute7',
1295: x_Op_rec.tp_attribute7);
1296: rlm_core_sv.dlog(k_DEBUG,'tp_attribute8',
1297: x_Op_rec.tp_attribute8);
1298: rlm_core_sv.dlog(k_DEBUG,'tp_attribute9',
1299: x_Op_rec.tp_attribute9);
1300: rlm_core_sv.dlog(k_DEBUG,'tp_attribute10',

Line 1298: rlm_core_sv.dlog(k_DEBUG,'tp_attribute9',

1294: rlm_core_sv.dlog(k_DEBUG,'tp_attribute7',
1295: x_Op_rec.tp_attribute7);
1296: rlm_core_sv.dlog(k_DEBUG,'tp_attribute8',
1297: x_Op_rec.tp_attribute8);
1298: rlm_core_sv.dlog(k_DEBUG,'tp_attribute9',
1299: x_Op_rec.tp_attribute9);
1300: rlm_core_sv.dlog(k_DEBUG,'tp_attribute10',
1301: x_Op_rec.tp_attribute10);
1302: rlm_core_sv.dlog(k_DEBUG,'tp_attribute11',

Line 1300: rlm_core_sv.dlog(k_DEBUG,'tp_attribute10',

1296: rlm_core_sv.dlog(k_DEBUG,'tp_attribute8',
1297: x_Op_rec.tp_attribute8);
1298: rlm_core_sv.dlog(k_DEBUG,'tp_attribute9',
1299: x_Op_rec.tp_attribute9);
1300: rlm_core_sv.dlog(k_DEBUG,'tp_attribute10',
1301: x_Op_rec.tp_attribute10);
1302: rlm_core_sv.dlog(k_DEBUG,'tp_attribute11',
1303: x_Op_rec.tp_attribute11);
1304: rlm_core_sv.dlog(k_DEBUG,'tp_attribute12',

Line 1302: rlm_core_sv.dlog(k_DEBUG,'tp_attribute11',

1298: rlm_core_sv.dlog(k_DEBUG,'tp_attribute9',
1299: x_Op_rec.tp_attribute9);
1300: rlm_core_sv.dlog(k_DEBUG,'tp_attribute10',
1301: x_Op_rec.tp_attribute10);
1302: rlm_core_sv.dlog(k_DEBUG,'tp_attribute11',
1303: x_Op_rec.tp_attribute11);
1304: rlm_core_sv.dlog(k_DEBUG,'tp_attribute12',
1305: x_Op_rec.tp_attribute12);
1306: rlm_core_sv.dlog(k_DEBUG,'tp_attribute13',

Line 1304: rlm_core_sv.dlog(k_DEBUG,'tp_attribute12',

1300: rlm_core_sv.dlog(k_DEBUG,'tp_attribute10',
1301: x_Op_rec.tp_attribute10);
1302: rlm_core_sv.dlog(k_DEBUG,'tp_attribute11',
1303: x_Op_rec.tp_attribute11);
1304: rlm_core_sv.dlog(k_DEBUG,'tp_attribute12',
1305: x_Op_rec.tp_attribute12);
1306: rlm_core_sv.dlog(k_DEBUG,'tp_attribute13',
1307: x_Op_rec.tp_attribute13);
1308: rlm_core_sv.dlog(k_DEBUG,'tp_attribute14',

Line 1306: rlm_core_sv.dlog(k_DEBUG,'tp_attribute13',

1302: rlm_core_sv.dlog(k_DEBUG,'tp_attribute11',
1303: x_Op_rec.tp_attribute11);
1304: rlm_core_sv.dlog(k_DEBUG,'tp_attribute12',
1305: x_Op_rec.tp_attribute12);
1306: rlm_core_sv.dlog(k_DEBUG,'tp_attribute13',
1307: x_Op_rec.tp_attribute13);
1308: rlm_core_sv.dlog(k_DEBUG,'tp_attribute14',
1309: x_Op_rec.tp_attribute14);
1310: rlm_core_sv.dlog(k_DEBUG,'tp_attribute15',

Line 1308: rlm_core_sv.dlog(k_DEBUG,'tp_attribute14',

1304: rlm_core_sv.dlog(k_DEBUG,'tp_attribute12',
1305: x_Op_rec.tp_attribute12);
1306: rlm_core_sv.dlog(k_DEBUG,'tp_attribute13',
1307: x_Op_rec.tp_attribute13);
1308: rlm_core_sv.dlog(k_DEBUG,'tp_attribute14',
1309: x_Op_rec.tp_attribute14);
1310: rlm_core_sv.dlog(k_DEBUG,'tp_attribute15',
1311: x_Op_rec.tp_attribute15);
1312: rlm_core_sv.dlog(k_DEBUG,'tp_context',

Line 1310: rlm_core_sv.dlog(k_DEBUG,'tp_attribute15',

1306: rlm_core_sv.dlog(k_DEBUG,'tp_attribute13',
1307: x_Op_rec.tp_attribute13);
1308: rlm_core_sv.dlog(k_DEBUG,'tp_attribute14',
1309: x_Op_rec.tp_attribute14);
1310: rlm_core_sv.dlog(k_DEBUG,'tp_attribute15',
1311: x_Op_rec.tp_attribute15);
1312: rlm_core_sv.dlog(k_DEBUG,'tp_context',
1313: x_Op_rec.tp_attribute_category);
1314: rlm_core_sv.dpop(k_SDEBUG);

Line 1312: rlm_core_sv.dlog(k_DEBUG,'tp_context',

1308: rlm_core_sv.dlog(k_DEBUG,'tp_attribute14',
1309: x_Op_rec.tp_attribute14);
1310: rlm_core_sv.dlog(k_DEBUG,'tp_attribute15',
1311: x_Op_rec.tp_attribute15);
1312: rlm_core_sv.dlog(k_DEBUG,'tp_context',
1313: x_Op_rec.tp_attribute_category);
1314: rlm_core_sv.dpop(k_SDEBUG);
1315: END IF;
1316: --

Line 1314: rlm_core_sv.dpop(k_SDEBUG);

1310: rlm_core_sv.dlog(k_DEBUG,'tp_attribute15',
1311: x_Op_rec.tp_attribute15);
1312: rlm_core_sv.dlog(k_DEBUG,'tp_context',
1313: x_Op_rec.tp_attribute_category);
1314: rlm_core_sv.dpop(k_SDEBUG);
1315: END IF;
1316: --
1317: EXCEPTION
1318: WHEN OTHERS THEN

Line 1321: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

1317: EXCEPTION
1318: WHEN OTHERS THEN
1319: --
1320: IF (l_debug <> -1) THEN
1321: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1322: END IF;
1323: --
1324: raise;
1325:

Line 1340: rlm_core_sv.dpush(k_SDEBUG,'BuildOELine');

1336: b_ATP BOOLEAN;
1337: BEGIN
1338: --
1339: IF (l_debug <> -1) THEN
1340: rlm_core_sv.dpush(k_SDEBUG,'BuildOELine');
1341: END IF;
1342: --
1343: -- Added by JAUTOMO 11/02/00 Bug# 1467525
1344: -- Added by JAUTOMO 11/08/01 Bug# 2096968

Line 1371: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);

1367: x_oe_line_rec.header_id := x_Op_rec.order_header_id;
1368: x_oe_line_rec.line_id := x_Op_rec.line_id;
1369: --
1370: IF (l_debug <> -1) THEN
1371: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1372: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',x_oe_line_rec.ordered_quantity);
1373: rlm_core_sv.dlog(k_DEBUG,'line_id ',x_oe_line_rec.line_id);
1374: END IF;
1375: --

Line 1372: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',x_oe_line_rec.ordered_quantity);

1368: x_oe_line_rec.line_id := x_Op_rec.line_id;
1369: --
1370: IF (l_debug <> -1) THEN
1371: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1372: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',x_oe_line_rec.ordered_quantity);
1373: rlm_core_sv.dlog(k_DEBUG,'line_id ',x_oe_line_rec.line_id);
1374: END IF;
1375: --
1376: ELSE

Line 1373: rlm_core_sv.dlog(k_DEBUG,'line_id ',x_oe_line_rec.line_id);

1369: --
1370: IF (l_debug <> -1) THEN
1371: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1372: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',x_oe_line_rec.ordered_quantity);
1373: rlm_core_sv.dlog(k_DEBUG,'line_id ',x_oe_line_rec.line_id);
1374: END IF;
1375: --
1376: ELSE
1377: --

Line 1404: rlm_core_sv.dlog(k_DEBUG,'b_ATP', b_ATP);

1400: END IF;
1401: --
1402: --
1403: IF (l_debug <> -1) THEN
1404: rlm_core_sv.dlog(k_DEBUG,'b_ATP', b_ATP);
1405: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1406: x_oe_line_rec.schedule_ship_date);
1407: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1408: x_oe_line_rec.ship_from_org_id);

Line 1405: rlm_core_sv.dlog(k_DEBUG,'schedule_date',

1401: --
1402: --
1403: IF (l_debug <> -1) THEN
1404: rlm_core_sv.dlog(k_DEBUG,'b_ATP', b_ATP);
1405: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1406: x_oe_line_rec.schedule_ship_date);
1407: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1408: x_oe_line_rec.ship_from_org_id);
1409: rlm_core_sv.dlog(k_DEBUG,'schedule_action_code',

Line 1407: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',

1403: IF (l_debug <> -1) THEN
1404: rlm_core_sv.dlog(k_DEBUG,'b_ATP', b_ATP);
1405: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1406: x_oe_line_rec.schedule_ship_date);
1407: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1408: x_oe_line_rec.ship_from_org_id);
1409: rlm_core_sv.dlog(k_DEBUG,'schedule_action_code',
1410: x_oe_line_rec.schedule_action_code);
1411: END IF;

Line 1409: rlm_core_sv.dlog(k_DEBUG,'schedule_action_code',

1405: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1406: x_oe_line_rec.schedule_ship_date);
1407: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1408: x_oe_line_rec.ship_from_org_id);
1409: rlm_core_sv.dlog(k_DEBUG,'schedule_action_code',
1410: x_oe_line_rec.schedule_action_code);
1411: END IF;
1412: --
1413: --

Line 1602: rlm_core_sv.dlog(k_DEBUG,'customer_item_revision', x_Op_rec.customer_item_revision);

1598: END IF;
1599: --
1600: --x_oe_line_rec.item_type_code := fnd_api.g_miss_char;
1601: IF (l_debug <> -1) THEN
1602: rlm_core_sv.dlog(k_DEBUG,'customer_item_revision', x_Op_rec.customer_item_revision);
1603: END IF;
1604: --
1605: IF x_Op_rec.customer_item_revision IS NOT NULL THEN
1606: x_oe_line_rec.item_revision := x_Op_rec.customer_item_revision;

Line 1689: rlm_core_sv.dlog(k_DEBUG,'created_by',FND_GLOBAL.USER_ID);

1685: --
1686: x_oe_line_rec.org_id := MO_GLOBAL.get_current_org_id;
1687: --
1688: IF (l_debug <> -1) THEN
1689: rlm_core_sv.dlog(k_DEBUG,'created_by',FND_GLOBAL.USER_ID);
1690: rlm_core_sv.dlog(k_DEBUG,'creation_date',SYSDATE);
1691: rlm_core_sv.dlog(k_DEBUG,'cust_dock_code',x_oe_line_rec.customer_dock_code);
1692: rlm_core_sv.dlog(k_DEBUG,'Customer job', x_oe_line_rec.customer_job);
1693: rlm_core_sv.dlog(k_DEBUG,'delivery_lead_time',

Line 1690: rlm_core_sv.dlog(k_DEBUG,'creation_date',SYSDATE);

1686: x_oe_line_rec.org_id := MO_GLOBAL.get_current_org_id;
1687: --
1688: IF (l_debug <> -1) THEN
1689: rlm_core_sv.dlog(k_DEBUG,'created_by',FND_GLOBAL.USER_ID);
1690: rlm_core_sv.dlog(k_DEBUG,'creation_date',SYSDATE);
1691: rlm_core_sv.dlog(k_DEBUG,'cust_dock_code',x_oe_line_rec.customer_dock_code);
1692: rlm_core_sv.dlog(k_DEBUG,'Customer job', x_oe_line_rec.customer_job);
1693: rlm_core_sv.dlog(k_DEBUG,'delivery_lead_time',
1694: x_oe_line_rec.delivery_lead_time);

Line 1691: rlm_core_sv.dlog(k_DEBUG,'cust_dock_code',x_oe_line_rec.customer_dock_code);

1687: --
1688: IF (l_debug <> -1) THEN
1689: rlm_core_sv.dlog(k_DEBUG,'created_by',FND_GLOBAL.USER_ID);
1690: rlm_core_sv.dlog(k_DEBUG,'creation_date',SYSDATE);
1691: rlm_core_sv.dlog(k_DEBUG,'cust_dock_code',x_oe_line_rec.customer_dock_code);
1692: rlm_core_sv.dlog(k_DEBUG,'Customer job', x_oe_line_rec.customer_job);
1693: rlm_core_sv.dlog(k_DEBUG,'delivery_lead_time',
1694: x_oe_line_rec.delivery_lead_time);
1695: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',

Line 1692: rlm_core_sv.dlog(k_DEBUG,'Customer job', x_oe_line_rec.customer_job);

1688: IF (l_debug <> -1) THEN
1689: rlm_core_sv.dlog(k_DEBUG,'created_by',FND_GLOBAL.USER_ID);
1690: rlm_core_sv.dlog(k_DEBUG,'creation_date',SYSDATE);
1691: rlm_core_sv.dlog(k_DEBUG,'cust_dock_code',x_oe_line_rec.customer_dock_code);
1692: rlm_core_sv.dlog(k_DEBUG,'Customer job', x_oe_line_rec.customer_job);
1693: rlm_core_sv.dlog(k_DEBUG,'delivery_lead_time',
1694: x_oe_line_rec.delivery_lead_time);
1695: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',
1696: x_oe_line_rec.ordered_quantity);

Line 1693: rlm_core_sv.dlog(k_DEBUG,'delivery_lead_time',

1689: rlm_core_sv.dlog(k_DEBUG,'created_by',FND_GLOBAL.USER_ID);
1690: rlm_core_sv.dlog(k_DEBUG,'creation_date',SYSDATE);
1691: rlm_core_sv.dlog(k_DEBUG,'cust_dock_code',x_oe_line_rec.customer_dock_code);
1692: rlm_core_sv.dlog(k_DEBUG,'Customer job', x_oe_line_rec.customer_job);
1693: rlm_core_sv.dlog(k_DEBUG,'delivery_lead_time',
1694: x_oe_line_rec.delivery_lead_time);
1695: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',
1696: x_oe_line_rec.ordered_quantity);
1697: rlm_core_sv.dlog(k_DEBUG,'uom_code',

Line 1695: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',

1691: rlm_core_sv.dlog(k_DEBUG,'cust_dock_code',x_oe_line_rec.customer_dock_code);
1692: rlm_core_sv.dlog(k_DEBUG,'Customer job', x_oe_line_rec.customer_job);
1693: rlm_core_sv.dlog(k_DEBUG,'delivery_lead_time',
1694: x_oe_line_rec.delivery_lead_time);
1695: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',
1696: x_oe_line_rec.ordered_quantity);
1697: rlm_core_sv.dlog(k_DEBUG,'uom_code',
1698: x_Op_rec.uom_code);
1699: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);

Line 1697: rlm_core_sv.dlog(k_DEBUG,'uom_code',

1693: rlm_core_sv.dlog(k_DEBUG,'delivery_lead_time',
1694: x_oe_line_rec.delivery_lead_time);
1695: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',
1696: x_oe_line_rec.ordered_quantity);
1697: rlm_core_sv.dlog(k_DEBUG,'uom_code',
1698: x_Op_rec.uom_code);
1699: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1700: rlm_core_sv.dlog(k_DEBUG,'change_reason ',x_oe_line_rec.change_reason);
1701: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);

Line 1699: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);

1695: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',
1696: x_oe_line_rec.ordered_quantity);
1697: rlm_core_sv.dlog(k_DEBUG,'uom_code',
1698: x_Op_rec.uom_code);
1699: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1700: rlm_core_sv.dlog(k_DEBUG,'change_reason ',x_oe_line_rec.change_reason);
1701: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);
1702: rlm_core_sv.dlog(k_DEBUG,'request_date',x_oe_line_rec.request_date);
1703: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);

Line 1700: rlm_core_sv.dlog(k_DEBUG,'change_reason ',x_oe_line_rec.change_reason);

1696: x_oe_line_rec.ordered_quantity);
1697: rlm_core_sv.dlog(k_DEBUG,'uom_code',
1698: x_Op_rec.uom_code);
1699: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1700: rlm_core_sv.dlog(k_DEBUG,'change_reason ',x_oe_line_rec.change_reason);
1701: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);
1702: rlm_core_sv.dlog(k_DEBUG,'request_date',x_oe_line_rec.request_date);
1703: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);
1704: rlm_core_sv.dlog(k_DEBUG,'intmed_ship_to_org_id',x_oe_line_rec.intermed_ship_to_org_id);

Line 1701: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);

1697: rlm_core_sv.dlog(k_DEBUG,'uom_code',
1698: x_Op_rec.uom_code);
1699: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1700: rlm_core_sv.dlog(k_DEBUG,'change_reason ',x_oe_line_rec.change_reason);
1701: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);
1702: rlm_core_sv.dlog(k_DEBUG,'request_date',x_oe_line_rec.request_date);
1703: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);
1704: rlm_core_sv.dlog(k_DEBUG,'intmed_ship_to_org_id',x_oe_line_rec.intermed_ship_to_org_id);
1705: rlm_core_sv.dlog(k_DEBUG,'schedule_date',

Line 1702: rlm_core_sv.dlog(k_DEBUG,'request_date',x_oe_line_rec.request_date);

1698: x_Op_rec.uom_code);
1699: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1700: rlm_core_sv.dlog(k_DEBUG,'change_reason ',x_oe_line_rec.change_reason);
1701: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);
1702: rlm_core_sv.dlog(k_DEBUG,'request_date',x_oe_line_rec.request_date);
1703: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);
1704: rlm_core_sv.dlog(k_DEBUG,'intmed_ship_to_org_id',x_oe_line_rec.intermed_ship_to_org_id);
1705: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1706: x_oe_line_rec.schedule_ship_date);

Line 1703: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);

1699: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1700: rlm_core_sv.dlog(k_DEBUG,'change_reason ',x_oe_line_rec.change_reason);
1701: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);
1702: rlm_core_sv.dlog(k_DEBUG,'request_date',x_oe_line_rec.request_date);
1703: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);
1704: rlm_core_sv.dlog(k_DEBUG,'intmed_ship_to_org_id',x_oe_line_rec.intermed_ship_to_org_id);
1705: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1706: x_oe_line_rec.schedule_ship_date);
1707: rlm_core_sv.dlog(k_DEBUG,'deliver_to_org_id',

Line 1704: rlm_core_sv.dlog(k_DEBUG,'intmed_ship_to_org_id',x_oe_line_rec.intermed_ship_to_org_id);

1700: rlm_core_sv.dlog(k_DEBUG,'change_reason ',x_oe_line_rec.change_reason);
1701: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);
1702: rlm_core_sv.dlog(k_DEBUG,'request_date',x_oe_line_rec.request_date);
1703: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);
1704: rlm_core_sv.dlog(k_DEBUG,'intmed_ship_to_org_id',x_oe_line_rec.intermed_ship_to_org_id);
1705: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1706: x_oe_line_rec.schedule_ship_date);
1707: rlm_core_sv.dlog(k_DEBUG,'deliver_to_org_id',
1708: x_oe_line_rec.deliver_to_org_id);

Line 1705: rlm_core_sv.dlog(k_DEBUG,'schedule_date',

1701: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);
1702: rlm_core_sv.dlog(k_DEBUG,'request_date',x_oe_line_rec.request_date);
1703: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);
1704: rlm_core_sv.dlog(k_DEBUG,'intmed_ship_to_org_id',x_oe_line_rec.intermed_ship_to_org_id);
1705: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1706: x_oe_line_rec.schedule_ship_date);
1707: rlm_core_sv.dlog(k_DEBUG,'deliver_to_org_id',
1708: x_oe_line_rec.deliver_to_org_id);
1709: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',

Line 1707: rlm_core_sv.dlog(k_DEBUG,'deliver_to_org_id',

1703: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);
1704: rlm_core_sv.dlog(k_DEBUG,'intmed_ship_to_org_id',x_oe_line_rec.intermed_ship_to_org_id);
1705: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1706: x_oe_line_rec.schedule_ship_date);
1707: rlm_core_sv.dlog(k_DEBUG,'deliver_to_org_id',
1708: x_oe_line_rec.deliver_to_org_id);
1709: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1710: x_oe_line_rec.ship_from_org_id);
1711: rlm_core_sv.dlog(k_DEBUG,'ship_to_org_id',

Line 1709: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',

1705: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1706: x_oe_line_rec.schedule_ship_date);
1707: rlm_core_sv.dlog(k_DEBUG,'deliver_to_org_id',
1708: x_oe_line_rec.deliver_to_org_id);
1709: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1710: x_oe_line_rec.ship_from_org_id);
1711: rlm_core_sv.dlog(k_DEBUG,'ship_to_org_id',
1712: x_oe_line_rec.ship_to_org_id);
1713: rlm_core_sv.dlog(k_DEBUG,'invoice to org id ',

Line 1711: rlm_core_sv.dlog(k_DEBUG,'ship_to_org_id',

1707: rlm_core_sv.dlog(k_DEBUG,'deliver_to_org_id',
1708: x_oe_line_rec.deliver_to_org_id);
1709: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1710: x_oe_line_rec.ship_from_org_id);
1711: rlm_core_sv.dlog(k_DEBUG,'ship_to_org_id',
1712: x_oe_line_rec.ship_to_org_id);
1713: rlm_core_sv.dlog(k_DEBUG,'invoice to org id ',
1714: x_oe_line_rec.invoice_to_org_id);
1715: rlm_core_sv.dlog(k_DEBUG,'authorized_to_ship_flag',

Line 1713: rlm_core_sv.dlog(k_DEBUG,'invoice to org id ',

1709: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1710: x_oe_line_rec.ship_from_org_id);
1711: rlm_core_sv.dlog(k_DEBUG,'ship_to_org_id',
1712: x_oe_line_rec.ship_to_org_id);
1713: rlm_core_sv.dlog(k_DEBUG,'invoice to org id ',
1714: x_oe_line_rec.invoice_to_org_id);
1715: rlm_core_sv.dlog(k_DEBUG,'authorized_to_ship_flag',
1716: x_oe_line_rec.authorized_to_ship_flag);
1717: rlm_core_sv.dlog(k_DEBUG,'Header ID',x_oe_line_rec.header_id);

Line 1715: rlm_core_sv.dlog(k_DEBUG,'authorized_to_ship_flag',

1711: rlm_core_sv.dlog(k_DEBUG,'ship_to_org_id',
1712: x_oe_line_rec.ship_to_org_id);
1713: rlm_core_sv.dlog(k_DEBUG,'invoice to org id ',
1714: x_oe_line_rec.invoice_to_org_id);
1715: rlm_core_sv.dlog(k_DEBUG,'authorized_to_ship_flag',
1716: x_oe_line_rec.authorized_to_ship_flag);
1717: rlm_core_sv.dlog(k_DEBUG,'Header ID',x_oe_line_rec.header_id);
1718: rlm_core_sv.dlog(k_DEBUG,'Inventory_item_id',
1719: x_oe_line_rec.inventory_item_id);

Line 1717: rlm_core_sv.dlog(k_DEBUG,'Header ID',x_oe_line_rec.header_id);

1713: rlm_core_sv.dlog(k_DEBUG,'invoice to org id ',
1714: x_oe_line_rec.invoice_to_org_id);
1715: rlm_core_sv.dlog(k_DEBUG,'authorized_to_ship_flag',
1716: x_oe_line_rec.authorized_to_ship_flag);
1717: rlm_core_sv.dlog(k_DEBUG,'Header ID',x_oe_line_rec.header_id);
1718: rlm_core_sv.dlog(k_DEBUG,'Inventory_item_id',
1719: x_oe_line_rec.inventory_item_id);
1720: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type ',
1721: x_oe_line_rec.item_identifier_type);

Line 1718: rlm_core_sv.dlog(k_DEBUG,'Inventory_item_id',

1714: x_oe_line_rec.invoice_to_org_id);
1715: rlm_core_sv.dlog(k_DEBUG,'authorized_to_ship_flag',
1716: x_oe_line_rec.authorized_to_ship_flag);
1717: rlm_core_sv.dlog(k_DEBUG,'Header ID',x_oe_line_rec.header_id);
1718: rlm_core_sv.dlog(k_DEBUG,'Inventory_item_id',
1719: x_oe_line_rec.inventory_item_id);
1720: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type ',
1721: x_oe_line_rec.item_identifier_type);
1722: rlm_core_sv.dlog(k_DEBUG,'ordered_item_id ',

Line 1720: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type ',

1716: x_oe_line_rec.authorized_to_ship_flag);
1717: rlm_core_sv.dlog(k_DEBUG,'Header ID',x_oe_line_rec.header_id);
1718: rlm_core_sv.dlog(k_DEBUG,'Inventory_item_id',
1719: x_oe_line_rec.inventory_item_id);
1720: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type ',
1721: x_oe_line_rec.item_identifier_type);
1722: rlm_core_sv.dlog(k_DEBUG,'ordered_item_id ',
1723: x_oe_line_rec.ordered_item_id);
1724: rlm_core_sv.dlog(k_DEBUG,'ordered_item',

Line 1722: rlm_core_sv.dlog(k_DEBUG,'ordered_item_id ',

1718: rlm_core_sv.dlog(k_DEBUG,'Inventory_item_id',
1719: x_oe_line_rec.inventory_item_id);
1720: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type ',
1721: x_oe_line_rec.item_identifier_type);
1722: rlm_core_sv.dlog(k_DEBUG,'ordered_item_id ',
1723: x_oe_line_rec.ordered_item_id);
1724: rlm_core_sv.dlog(k_DEBUG,'ordered_item',
1725: x_oe_line_rec.ordered_item);
1726: rlm_core_sv.dlog(k_DEBUG,'item_detail_type',

Line 1724: rlm_core_sv.dlog(k_DEBUG,'ordered_item',

1720: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type ',
1721: x_oe_line_rec.item_identifier_type);
1722: rlm_core_sv.dlog(k_DEBUG,'ordered_item_id ',
1723: x_oe_line_rec.ordered_item_id);
1724: rlm_core_sv.dlog(k_DEBUG,'ordered_item',
1725: x_oe_line_rec.ordered_item);
1726: rlm_core_sv.dlog(k_DEBUG,'item_detail_type',
1727: x_oe_line_rec.item_type_code);
1728: rlm_core_sv.dlog(k_DEBUG,'line_id ',

Line 1726: rlm_core_sv.dlog(k_DEBUG,'item_detail_type',

1722: rlm_core_sv.dlog(k_DEBUG,'ordered_item_id ',
1723: x_oe_line_rec.ordered_item_id);
1724: rlm_core_sv.dlog(k_DEBUG,'ordered_item',
1725: x_oe_line_rec.ordered_item);
1726: rlm_core_sv.dlog(k_DEBUG,'item_detail_type',
1727: x_oe_line_rec.item_type_code);
1728: rlm_core_sv.dlog(k_DEBUG,'line_id ',
1729: x_oe_line_rec.line_id);
1730: rlm_core_sv.dlog(k_DEBUG,'agreement_id ',

Line 1728: rlm_core_sv.dlog(k_DEBUG,'line_id ',

1724: rlm_core_sv.dlog(k_DEBUG,'ordered_item',
1725: x_oe_line_rec.ordered_item);
1726: rlm_core_sv.dlog(k_DEBUG,'item_detail_type',
1727: x_oe_line_rec.item_type_code);
1728: rlm_core_sv.dlog(k_DEBUG,'line_id ',
1729: x_oe_line_rec.line_id);
1730: rlm_core_sv.dlog(k_DEBUG,'agreement_id ',
1731: x_oe_line_rec.agreement_id);
1732: rlm_core_sv.dlog(k_DEBUG,'price_list_id ',

Line 1730: rlm_core_sv.dlog(k_DEBUG,'agreement_id ',

1726: rlm_core_sv.dlog(k_DEBUG,'item_detail_type',
1727: x_oe_line_rec.item_type_code);
1728: rlm_core_sv.dlog(k_DEBUG,'line_id ',
1729: x_oe_line_rec.line_id);
1730: rlm_core_sv.dlog(k_DEBUG,'agreement_id ',
1731: x_oe_line_rec.agreement_id);
1732: rlm_core_sv.dlog(k_DEBUG,'price_list_id ',
1733: x_oe_line_rec.price_list_id);
1734: rlm_core_sv.dlog(k_DEBUG,'sold_to_org_id ',

Line 1732: rlm_core_sv.dlog(k_DEBUG,'price_list_id ',

1728: rlm_core_sv.dlog(k_DEBUG,'line_id ',
1729: x_oe_line_rec.line_id);
1730: rlm_core_sv.dlog(k_DEBUG,'agreement_id ',
1731: x_oe_line_rec.agreement_id);
1732: rlm_core_sv.dlog(k_DEBUG,'price_list_id ',
1733: x_oe_line_rec.price_list_id);
1734: rlm_core_sv.dlog(k_DEBUG,'sold_to_org_id ',
1735: x_oe_line_rec.sold_to_org_id);
1736: rlm_core_sv.dlog(k_DEBUG,'source_document_line_id ',

Line 1734: rlm_core_sv.dlog(k_DEBUG,'sold_to_org_id ',

1730: rlm_core_sv.dlog(k_DEBUG,'agreement_id ',
1731: x_oe_line_rec.agreement_id);
1732: rlm_core_sv.dlog(k_DEBUG,'price_list_id ',
1733: x_oe_line_rec.price_list_id);
1734: rlm_core_sv.dlog(k_DEBUG,'sold_to_org_id ',
1735: x_oe_line_rec.sold_to_org_id);
1736: rlm_core_sv.dlog(k_DEBUG,'source_document_line_id ',
1737: x_oe_line_rec.source_document_line_id);
1738: rlm_core_sv.dlog(k_DEBUG,'source_document_id ',

Line 1736: rlm_core_sv.dlog(k_DEBUG,'source_document_line_id ',

1732: rlm_core_sv.dlog(k_DEBUG,'price_list_id ',
1733: x_oe_line_rec.price_list_id);
1734: rlm_core_sv.dlog(k_DEBUG,'sold_to_org_id ',
1735: x_oe_line_rec.sold_to_org_id);
1736: rlm_core_sv.dlog(k_DEBUG,'source_document_line_id ',
1737: x_oe_line_rec.source_document_line_id);
1738: rlm_core_sv.dlog(k_DEBUG,'source_document_id ',
1739: x_oe_line_rec.source_document_id);
1740: rlm_core_sv.dlog(k_DEBUG,'source_document_type_id ',

Line 1738: rlm_core_sv.dlog(k_DEBUG,'source_document_id ',

1734: rlm_core_sv.dlog(k_DEBUG,'sold_to_org_id ',
1735: x_oe_line_rec.sold_to_org_id);
1736: rlm_core_sv.dlog(k_DEBUG,'source_document_line_id ',
1737: x_oe_line_rec.source_document_line_id);
1738: rlm_core_sv.dlog(k_DEBUG,'source_document_id ',
1739: x_oe_line_rec.source_document_id);
1740: rlm_core_sv.dlog(k_DEBUG,'source_document_type_id ',
1741: x_oe_line_rec.source_document_type_id);
1742: rlm_core_sv.dlog(k_DEBUG,'PO Line number ',

Line 1740: rlm_core_sv.dlog(k_DEBUG,'source_document_type_id ',

1736: rlm_core_sv.dlog(k_DEBUG,'source_document_line_id ',
1737: x_oe_line_rec.source_document_line_id);
1738: rlm_core_sv.dlog(k_DEBUG,'source_document_id ',
1739: x_oe_line_rec.source_document_id);
1740: rlm_core_sv.dlog(k_DEBUG,'source_document_type_id ',
1741: x_oe_line_rec.source_document_type_id);
1742: rlm_core_sv.dlog(k_DEBUG,'PO Line number ',
1743: x_oe_line_rec.customer_line_number);
1744: rlm_core_sv.dlog(k_DEBUG,'customer_production_line', x_oe_line_rec.customer_production_line);

Line 1742: rlm_core_sv.dlog(k_DEBUG,'PO Line number ',

1738: rlm_core_sv.dlog(k_DEBUG,'source_document_id ',
1739: x_oe_line_rec.source_document_id);
1740: rlm_core_sv.dlog(k_DEBUG,'source_document_type_id ',
1741: x_oe_line_rec.source_document_type_id);
1742: rlm_core_sv.dlog(k_DEBUG,'PO Line number ',
1743: x_oe_line_rec.customer_line_number);
1744: rlm_core_sv.dlog(k_DEBUG,'customer_production_line', x_oe_line_rec.customer_production_line);
1745: rlm_core_sv.dlog(k_DEBUG,'cust_model_serial_number', x_oe_line_rec.cust_model_serial_number);
1746: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);

Line 1744: rlm_core_sv.dlog(k_DEBUG,'customer_production_line', x_oe_line_rec.customer_production_line);

1740: rlm_core_sv.dlog(k_DEBUG,'source_document_type_id ',
1741: x_oe_line_rec.source_document_type_id);
1742: rlm_core_sv.dlog(k_DEBUG,'PO Line number ',
1743: x_oe_line_rec.customer_line_number);
1744: rlm_core_sv.dlog(k_DEBUG,'customer_production_line', x_oe_line_rec.customer_production_line);
1745: rlm_core_sv.dlog(k_DEBUG,'cust_model_serial_number', x_oe_line_rec.cust_model_serial_number);
1746: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);
1747: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1748: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);

Line 1745: rlm_core_sv.dlog(k_DEBUG,'cust_model_serial_number', x_oe_line_rec.cust_model_serial_number);

1741: x_oe_line_rec.source_document_type_id);
1742: rlm_core_sv.dlog(k_DEBUG,'PO Line number ',
1743: x_oe_line_rec.customer_line_number);
1744: rlm_core_sv.dlog(k_DEBUG,'customer_production_line', x_oe_line_rec.customer_production_line);
1745: rlm_core_sv.dlog(k_DEBUG,'cust_model_serial_number', x_oe_line_rec.cust_model_serial_number);
1746: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);
1747: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1748: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1749: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);

Line 1746: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);

1742: rlm_core_sv.dlog(k_DEBUG,'PO Line number ',
1743: x_oe_line_rec.customer_line_number);
1744: rlm_core_sv.dlog(k_DEBUG,'customer_production_line', x_oe_line_rec.customer_production_line);
1745: rlm_core_sv.dlog(k_DEBUG,'cust_model_serial_number', x_oe_line_rec.cust_model_serial_number);
1746: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);
1747: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1748: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1749: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1750: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);

Line 1747: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);

1743: x_oe_line_rec.customer_line_number);
1744: rlm_core_sv.dlog(k_DEBUG,'customer_production_line', x_oe_line_rec.customer_production_line);
1745: rlm_core_sv.dlog(k_DEBUG,'cust_model_serial_number', x_oe_line_rec.cust_model_serial_number);
1746: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);
1747: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1748: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1749: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1750: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1751: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);

Line 1748: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);

1744: rlm_core_sv.dlog(k_DEBUG,'customer_production_line', x_oe_line_rec.customer_production_line);
1745: rlm_core_sv.dlog(k_DEBUG,'cust_model_serial_number', x_oe_line_rec.cust_model_serial_number);
1746: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);
1747: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1748: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1749: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1750: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1751: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1752: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);

Line 1749: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);

1745: rlm_core_sv.dlog(k_DEBUG,'cust_model_serial_number', x_oe_line_rec.cust_model_serial_number);
1746: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);
1747: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1748: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1749: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1750: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1751: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1752: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1753: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);

Line 1750: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);

1746: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);
1747: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1748: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1749: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1750: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1751: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1752: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1753: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1754: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);

Line 1751: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);

1747: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1748: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1749: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1750: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1751: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1752: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1753: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1754: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1755: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);

Line 1752: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);

1748: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1749: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1750: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1751: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1752: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1753: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1754: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1755: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1756: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);

Line 1753: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);

1749: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1750: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1751: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1752: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1753: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1754: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1755: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1756: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1757: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);

Line 1754: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);

1750: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1751: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1752: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1753: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1754: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1755: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1756: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1757: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1758: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);

Line 1755: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);

1751: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1752: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1753: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1754: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1755: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1756: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1757: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1758: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1759: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);

Line 1756: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);

1752: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1753: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1754: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1755: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1756: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1757: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1758: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1759: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1760: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);

Line 1757: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);

1753: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1754: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1755: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1756: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1757: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1758: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1759: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1760: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1761: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);

Line 1758: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);

1754: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1755: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1756: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1757: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1758: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1759: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1760: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1761: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1762: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);

Line 1759: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);

1755: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1756: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1757: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1758: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1759: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1760: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1761: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1762: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1763: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);

Line 1760: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);

1756: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1757: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1758: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1759: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1760: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1761: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1762: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1763: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1764: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);

Line 1761: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);

1757: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1758: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1759: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1760: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1761: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1762: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1763: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1764: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1765: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);

Line 1762: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);

1758: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1759: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1760: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1761: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1762: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1763: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1764: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1765: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1766: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);

Line 1763: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);

1759: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1760: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1761: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1762: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1763: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1764: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1765: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1766: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1767: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);

Line 1764: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);

1760: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1761: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1762: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1763: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1764: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1765: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1766: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1767: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1768: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);

Line 1765: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);

1761: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1762: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1763: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1764: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1765: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1766: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1767: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1768: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1769: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);

Line 1766: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);

1762: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1763: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1764: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1765: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1766: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1767: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1768: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1769: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1770: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);

Line 1767: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);

1763: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1764: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1765: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1766: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1767: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1768: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1769: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1770: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1771: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);

Line 1768: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);

1764: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1765: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1766: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1767: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1768: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1769: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1770: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1771: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1772: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);

Line 1769: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);

1765: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1766: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1767: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1768: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1769: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1770: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1771: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1772: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1773: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);

Line 1770: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);

1766: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1767: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1768: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1769: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1770: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1771: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1772: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1773: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1774: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);

Line 1771: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);

1767: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1768: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1769: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1770: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1771: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1772: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1773: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1774: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1775: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);

Line 1772: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);

1768: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1769: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1770: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1771: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1772: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1773: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1774: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1775: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1776: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);

Line 1773: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);

1769: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1770: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1771: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1772: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1773: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1774: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1775: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1776: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1777: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);

Line 1774: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);

1770: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1771: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1772: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1773: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1774: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1775: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1776: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1777: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1778: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);

Line 1775: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);

1771: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1772: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1773: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1774: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1775: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1776: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1777: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1778: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1779: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);

Line 1776: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);

1772: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1773: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1774: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1775: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1776: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1777: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1778: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1779: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1780: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);

Line 1777: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);

1773: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1774: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1775: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1776: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1777: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1778: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1779: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1780: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);
1781: rlm_core_sv.dlog(k_DEBUG,'attribute_category',x_oe_line_rec.context);

Line 1778: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);

1774: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1775: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1776: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1777: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1778: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1779: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1780: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);
1781: rlm_core_sv.dlog(k_DEBUG,'attribute_category',x_oe_line_rec.context);
1782: rlm_core_sv.dlog(k_DEBUG,'blanket_number',x_oe_line_rec.blanket_number);

Line 1779: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);

1775: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1776: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1777: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1778: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1779: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1780: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);
1781: rlm_core_sv.dlog(k_DEBUG,'attribute_category',x_oe_line_rec.context);
1782: rlm_core_sv.dlog(k_DEBUG,'blanket_number',x_oe_line_rec.blanket_number);
1783: rlm_core_sv.dlog(k_DEBUG,'Org ID', x_oe_line_rec.org_id);

Line 1780: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);

1776: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1777: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1778: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1779: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1780: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);
1781: rlm_core_sv.dlog(k_DEBUG,'attribute_category',x_oe_line_rec.context);
1782: rlm_core_sv.dlog(k_DEBUG,'blanket_number',x_oe_line_rec.blanket_number);
1783: rlm_core_sv.dlog(k_DEBUG,'Org ID', x_oe_line_rec.org_id);
1784: END IF;

Line 1781: rlm_core_sv.dlog(k_DEBUG,'attribute_category',x_oe_line_rec.context);

1777: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1778: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1779: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1780: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);
1781: rlm_core_sv.dlog(k_DEBUG,'attribute_category',x_oe_line_rec.context);
1782: rlm_core_sv.dlog(k_DEBUG,'blanket_number',x_oe_line_rec.blanket_number);
1783: rlm_core_sv.dlog(k_DEBUG,'Org ID', x_oe_line_rec.org_id);
1784: END IF;
1785: END IF;

Line 1782: rlm_core_sv.dlog(k_DEBUG,'blanket_number',x_oe_line_rec.blanket_number);

1778: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1779: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1780: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);
1781: rlm_core_sv.dlog(k_DEBUG,'attribute_category',x_oe_line_rec.context);
1782: rlm_core_sv.dlog(k_DEBUG,'blanket_number',x_oe_line_rec.blanket_number);
1783: rlm_core_sv.dlog(k_DEBUG,'Org ID', x_oe_line_rec.org_id);
1784: END IF;
1785: END IF;
1786: --

Line 1783: rlm_core_sv.dlog(k_DEBUG,'Org ID', x_oe_line_rec.org_id);

1779: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1780: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);
1781: rlm_core_sv.dlog(k_DEBUG,'attribute_category',x_oe_line_rec.context);
1782: rlm_core_sv.dlog(k_DEBUG,'blanket_number',x_oe_line_rec.blanket_number);
1783: rlm_core_sv.dlog(k_DEBUG,'Org ID', x_oe_line_rec.org_id);
1784: END IF;
1785: END IF;
1786: --
1787: IF (l_debug <> -1) THEN

Line 1788: rlm_core_sv.dpop(k_SDEBUG);

1784: END IF;
1785: END IF;
1786: --
1787: IF (l_debug <> -1) THEN
1788: rlm_core_sv.dpop(k_SDEBUG);
1789: END IF;
1790: --
1791: EXCEPTION
1792: WHEN OTHERS THEN

Line 1795: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

1791: EXCEPTION
1792: WHEN OTHERS THEN
1793: --
1794: IF (l_debug <> -1) THEN
1795: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1796: END IF;
1797: --
1798: raise;
1799:

Line 1898: rlm_core_sv.dlog(k_DEBUG,'EXCEPTION',SUBSTR(SQLERRM,1,200));

1894: --
1895: WHEN OTHERS THEN
1896: --
1897: IF (l_debug <> -1) THEN
1898: rlm_core_sv.dlog(k_DEBUG,'EXCEPTION',SUBSTR(SQLERRM,1,200));
1899: END IF;
1900: --
1901: raise;
1902:

Line 2008: rlm_core_sv.dpush(k_SDEBUG,'GetTPContext');

2004: --
2005: BEGIN
2006: --
2007: IF (l_debug <> -1) THEN
2008: rlm_core_sv.dpush(k_SDEBUG,'GetTPContext');
2009: rlm_core_sv.dlog(k_DEBUG,'customer_id', x_Op_rec.customer_id);
2010: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.ship_to_org_id',
2011: x_Op_rec.ship_to_org_id);
2012: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.intmed_ship_to_org_id',

Line 2009: rlm_core_sv.dlog(k_DEBUG,'customer_id', x_Op_rec.customer_id);

2005: BEGIN
2006: --
2007: IF (l_debug <> -1) THEN
2008: rlm_core_sv.dpush(k_SDEBUG,'GetTPContext');
2009: rlm_core_sv.dlog(k_DEBUG,'customer_id', x_Op_rec.customer_id);
2010: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.ship_to_org_id',
2011: x_Op_rec.ship_to_org_id);
2012: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.intmed_ship_to_org_id',
2013: x_Op_rec.intmed_ship_to_org_id);

Line 2010: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.ship_to_org_id',

2006: --
2007: IF (l_debug <> -1) THEN
2008: rlm_core_sv.dpush(k_SDEBUG,'GetTPContext');
2009: rlm_core_sv.dlog(k_DEBUG,'customer_id', x_Op_rec.customer_id);
2010: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.ship_to_org_id',
2011: x_Op_rec.ship_to_org_id);
2012: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.intmed_ship_to_org_id',
2013: x_Op_rec.intmed_ship_to_org_id);
2014: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.invoice_to_org_id',

Line 2012: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.intmed_ship_to_org_id',

2008: rlm_core_sv.dpush(k_SDEBUG,'GetTPContext');
2009: rlm_core_sv.dlog(k_DEBUG,'customer_id', x_Op_rec.customer_id);
2010: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.ship_to_org_id',
2011: x_Op_rec.ship_to_org_id);
2012: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.intmed_ship_to_org_id',
2013: x_Op_rec.intmed_ship_to_org_id);
2014: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.invoice_to_org_id',
2015: x_Op_rec.invoice_to_org_id);
2016: END IF;

Line 2014: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.invoice_to_org_id',

2010: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.ship_to_org_id',
2011: x_Op_rec.ship_to_org_id);
2012: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.intmed_ship_to_org_id',
2013: x_Op_rec.intmed_ship_to_org_id);
2014: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.invoice_to_org_id',
2015: x_Op_rec.invoice_to_org_id);
2016: END IF;
2017: --
2018: BEGIN

Line 2053: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

2049: x_bill_to_ece_locn_code := NULL;
2050: WHEN OTHERS THEN
2051: --
2052: IF (l_debug <> -1) THEN
2053: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2054: END IF;
2055: --
2056: raise;
2057: --

Line 2102: rlm_core_sv.dlog(k_DEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

2098: x_customer_number := NULL;
2099: WHEN OTHERS THEN
2100: --
2101: IF (l_debug <> -1) THEN
2102: rlm_core_sv.dlog(k_DEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2103: END IF;
2104: --
2105: raise;
2106: END;

Line 2111: rlm_core_sv.dlog(k_DEBUG, 'customer_number', x_customer_number);

2107:
2108: END IF;
2109: --
2110: IF (l_debug <> -1) THEN
2111: rlm_core_sv.dlog(k_DEBUG, 'customer_number', x_customer_number);
2112: rlm_core_sv.dlog(k_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2113: rlm_core_sv.dlog(k_DEBUG,'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2114: rlm_core_sv.dlog(k_DEBUG,'x_inter_ship_to_ece_locn_code',
2115: x_inter_ship_to_ece_locn_code);

Line 2112: rlm_core_sv.dlog(k_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);

2108: END IF;
2109: --
2110: IF (l_debug <> -1) THEN
2111: rlm_core_sv.dlog(k_DEBUG, 'customer_number', x_customer_number);
2112: rlm_core_sv.dlog(k_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2113: rlm_core_sv.dlog(k_DEBUG,'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2114: rlm_core_sv.dlog(k_DEBUG,'x_inter_ship_to_ece_locn_code',
2115: x_inter_ship_to_ece_locn_code);
2116: rlm_core_sv.dlog(k_DEBUG,'x_tp_Group_code', x_tp_Group_code);

Line 2113: rlm_core_sv.dlog(k_DEBUG,'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);

2109: --
2110: IF (l_debug <> -1) THEN
2111: rlm_core_sv.dlog(k_DEBUG, 'customer_number', x_customer_number);
2112: rlm_core_sv.dlog(k_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2113: rlm_core_sv.dlog(k_DEBUG,'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2114: rlm_core_sv.dlog(k_DEBUG,'x_inter_ship_to_ece_locn_code',
2115: x_inter_ship_to_ece_locn_code);
2116: rlm_core_sv.dlog(k_DEBUG,'x_tp_Group_code', x_tp_Group_code);
2117: rlm_core_sv.dpop(k_SDEBUG);

Line 2114: rlm_core_sv.dlog(k_DEBUG,'x_inter_ship_to_ece_locn_code',

2110: IF (l_debug <> -1) THEN
2111: rlm_core_sv.dlog(k_DEBUG, 'customer_number', x_customer_number);
2112: rlm_core_sv.dlog(k_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2113: rlm_core_sv.dlog(k_DEBUG,'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2114: rlm_core_sv.dlog(k_DEBUG,'x_inter_ship_to_ece_locn_code',
2115: x_inter_ship_to_ece_locn_code);
2116: rlm_core_sv.dlog(k_DEBUG,'x_tp_Group_code', x_tp_Group_code);
2117: rlm_core_sv.dpop(k_SDEBUG);
2118: END IF;

Line 2116: rlm_core_sv.dlog(k_DEBUG,'x_tp_Group_code', x_tp_Group_code);

2112: rlm_core_sv.dlog(k_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2113: rlm_core_sv.dlog(k_DEBUG,'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2114: rlm_core_sv.dlog(k_DEBUG,'x_inter_ship_to_ece_locn_code',
2115: x_inter_ship_to_ece_locn_code);
2116: rlm_core_sv.dlog(k_DEBUG,'x_tp_Group_code', x_tp_Group_code);
2117: rlm_core_sv.dpop(k_SDEBUG);
2118: END IF;
2119: --
2120: EXCEPTION

Line 2117: rlm_core_sv.dpop(k_SDEBUG);

2113: rlm_core_sv.dlog(k_DEBUG,'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2114: rlm_core_sv.dlog(k_DEBUG,'x_inter_ship_to_ece_locn_code',
2115: x_inter_ship_to_ece_locn_code);
2116: rlm_core_sv.dlog(k_DEBUG,'x_tp_Group_code', x_tp_Group_code);
2117: rlm_core_sv.dpop(k_SDEBUG);
2118: END IF;
2119: --
2120: EXCEPTION
2121: --

Line 2127: rlm_core_sv.dlog(k_DEBUG, 'No data found for' , x_Op_rec.customer_id);

2123: --
2124: x_customer_number := NULL;
2125: --
2126: IF (l_debug <> -1) THEN
2127: rlm_core_sv.dlog(k_DEBUG, 'No data found for' , x_Op_rec.customer_id);
2128: rlm_core_sv.dpop(k_SDEBUG);
2129: END IF;
2130: --
2131: WHEN OTHERS THEN

Line 2128: rlm_core_sv.dpop(k_SDEBUG);

2124: x_customer_number := NULL;
2125: --
2126: IF (l_debug <> -1) THEN
2127: rlm_core_sv.dlog(k_DEBUG, 'No data found for' , x_Op_rec.customer_id);
2128: rlm_core_sv.dpop(k_SDEBUG);
2129: END IF;
2130: --
2131: WHEN OTHERS THEN
2132: --

Line 2136: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

2132: --
2133: rlm_message_sv.sql_error('rlm_validatedemand_sv.GetTPContext',v_Progress);
2134: --
2135: IF (l_debug <> -1) THEN
2136: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2137: END IF;
2138: --
2139: raise;
2140: --

Line 2173: rlm_core_sv.dpush(k_SDEBUG,'GetIntransitShippedLines');

2169: BEGIN
2170:
2171: --
2172: IF (l_debug <> -1) THEN
2173: rlm_core_sv.dpush(k_SDEBUG,'GetIntransitShippedLines');
2174: END IF;
2175:
2176: --ITS should be complete before a WDD/OM line can be considered intransit.
2177: --OE tables are referenced while considered shipped lines.

Line 2195: rlm_core_sv.dlog(k_DEBUG,'Reconciling against all the Blanket Release orders');

2191:
2192: IF TO_DATE(x_optional_match_rec.industry_attribute2,'RRRR/MM/DD HH24:MI:SS') < trunc(l_effective_start_date) THEN
2193:
2194: IF (l_debug <> -1) THEN
2195: rlm_core_sv.dlog(k_DEBUG,'Reconciling against all the Blanket Release orders');
2196: END IF;
2197:
2198: v_where_clause := ' WHERE o.header_id IN'||
2199: ' (SELECT rbr.rso_hdr_id FROM rlm_blanket_rso rbr,oe_order_headers oh WHERE rbr.blanket_number = '||x_Group_rec.blanket_number||

Line 3072: rlm_core_sv.dlog(k_DEBUG,'Dynamic SQL',v_final_sql);

3068: --
3069: v_final_sql := v_select_clause||v_where_clause;
3070: --
3071: IF (l_debug <> -1) THEN
3072: rlm_core_sv.dlog(k_DEBUG,'Dynamic SQL',v_final_sql);
3073: rlm_core_sv.dlog(k_DEBUG,'g_wheretab count', g_whereTab.COUNT);
3074: END IF;
3075: -- print bind variables
3076: FOR i in 1..g_whereTab.COUNT

Line 3073: rlm_core_sv.dlog(k_DEBUG,'g_wheretab count', g_whereTab.COUNT);

3069: v_final_sql := v_select_clause||v_where_clause;
3070: --
3071: IF (l_debug <> -1) THEN
3072: rlm_core_sv.dlog(k_DEBUG,'Dynamic SQL',v_final_sql);
3073: rlm_core_sv.dlog(k_DEBUG,'g_wheretab count', g_whereTab.COUNT);
3074: END IF;
3075: -- print bind variables
3076: FOR i in 1..g_whereTab.COUNT
3077: LOOP

Line 3079: rlm_core_sv.dlog(k_DEBUG,'Value for g_where_tab('||to_char(i)||')', g_whereTab(i));

3075: -- print bind variables
3076: FOR i in 1..g_whereTab.COUNT
3077: LOOP
3078: IF (l_debug <> -1) THEN
3079: rlm_core_sv.dlog(k_DEBUG,'Value for g_where_tab('||to_char(i)||')', g_whereTab(i));
3080: END IF;
3081: END LOOP;
3082: --
3083: RLM_CORE_SV.OpenDynamicCursor(c_sum,v_final_sql,g_wheretab);

Line 3083: RLM_CORE_SV.OpenDynamicCursor(c_sum,v_final_sql,g_wheretab);

3079: rlm_core_sv.dlog(k_DEBUG,'Value for g_where_tab('||to_char(i)||')', g_whereTab(i));
3080: END IF;
3081: END LOOP;
3082: --
3083: RLM_CORE_SV.OpenDynamicCursor(c_sum,v_final_sql,g_wheretab);
3084: FETCH c_sum INTO x_intransit_qty;
3085: CLOSE c_sum;
3086: --
3087: g_wheretab.delete;

Line 3090: rlm_core_sv.dlog(k_DEBUG,'Intransit Qty', x_intransit_qty);

3086: --
3087: g_wheretab.delete;
3088: --
3089: IF (l_debug <> -1) THEN
3090: rlm_core_sv.dlog(k_DEBUG,'Intransit Qty', x_intransit_qty);
3091: rlm_core_sv.dpop(k_SDEBUG,'GetIntransitShippedLines');
3092: END IF;
3093: --
3094: EXCEPTION

Line 3091: rlm_core_sv.dpop(k_SDEBUG,'GetIntransitShippedLines');

3087: g_wheretab.delete;
3088: --
3089: IF (l_debug <> -1) THEN
3090: rlm_core_sv.dlog(k_DEBUG,'Intransit Qty', x_intransit_qty);
3091: rlm_core_sv.dpop(k_SDEBUG,'GetIntransitShippedLines');
3092: END IF;
3093: --
3094: EXCEPTION
3095: When others then

Line 3097: rlm_core_sv.dpop(k_SDEBUG,'GetIntransitShippedLines'||substr(sqlerrm,1,200));

3093: --
3094: EXCEPTION
3095: When others then
3096: IF (l_debug <> -1) THEN
3097: rlm_core_sv.dpop(k_SDEBUG,'GetIntransitShippedLines'||substr(sqlerrm,1,200));
3098: END IF;
3099: raise;
3100: END GetIntransitShippedLines;
3101: