[Home] [Help]
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,
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: --
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';
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: --
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: --
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;
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:
113: --
114: BEGIN
115: --
116: IF (l_debug <> -1) THEN
117: rlm_core_sv.dpush(k_SDEBUG,'ProcessOperation');
118: END IF;
119: --
120: BuildOELineTab(x_Op_Tab,x_Return_Status);
121: --
125: --
126: IF g_oe_line_tbl.count >0 THEN
127: --
128: IF (l_debug <> -1) THEN
129: rlm_core_sv.dlog(k_DEBUG,'starting insert oe lines');
130: END IF;
131: --
132: fnd_profile.get(rlm_core_sv.C_DEBUG_PROFILE, v_DebugMode);
133: --
128: IF (l_debug <> -1) THEN
129: rlm_core_sv.dlog(k_DEBUG,'starting insert oe lines');
130: END IF;
131: --
132: fnd_profile.get(rlm_core_sv.C_DEBUG_PROFILE, v_DebugMode);
133: --
134: oe_debug_pub.add('Calling Process_order from DSP',1);
135: --
136: IF (l_debug <> -1) THEN
133: --
134: oe_debug_pub.add('Calling Process_order from DSP',1);
135: --
136: IF (l_debug <> -1) THEN
137: rlm_core_sv.dlog(k_DEBUG,'RLM DEBUG PROFILE :',v_DebugMode);
138: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.IsDebugOn);
139: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
140: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
141: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
134: oe_debug_pub.add('Calling Process_order from DSP',1);
135: --
136: IF (l_debug <> -1) THEN
137: rlm_core_sv.dlog(k_DEBUG,'RLM DEBUG PROFILE :',v_DebugMode);
138: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.IsDebugOn);
139: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
140: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
141: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
142: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for details on process Order API errors');
135: --
136: IF (l_debug <> -1) THEN
137: rlm_core_sv.dlog(k_DEBUG,'RLM DEBUG PROFILE :',v_DebugMode);
138: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.IsDebugOn);
139: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
140: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
141: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
142: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for details on process Order API errors');
143: rlm_core_sv.dlog(k_DEBUG,'Om Debug File dir:',OE_DEBUG_PUB.G_DIR);
136: IF (l_debug <> -1) THEN
137: rlm_core_sv.dlog(k_DEBUG,'RLM DEBUG PROFILE :',v_DebugMode);
138: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.IsDebugOn);
139: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
140: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
141: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
142: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for details on process Order API errors');
143: rlm_core_sv.dlog(k_DEBUG,'Om Debug File dir:',OE_DEBUG_PUB.G_DIR);
144: END IF;
137: rlm_core_sv.dlog(k_DEBUG,'RLM DEBUG PROFILE :',v_DebugMode);
138: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.IsDebugOn);
139: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
140: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
141: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
142: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for details on process Order API errors');
143: rlm_core_sv.dlog(k_DEBUG,'Om Debug File dir:',OE_DEBUG_PUB.G_DIR);
144: END IF;
145: --
138: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.IsDebugOn);
139: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
140: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
141: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
142: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for details on process Order API errors');
143: rlm_core_sv.dlog(k_DEBUG,'Om Debug File dir:',OE_DEBUG_PUB.G_DIR);
144: END IF;
145: --
146: v_FileName := OE_DEBUG_PUB.set_debug_mode ('FILE');
139: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
140: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
141: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
142: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for details on process Order API errors');
143: rlm_core_sv.dlog(k_DEBUG,'Om Debug File dir:',OE_DEBUG_PUB.G_DIR);
144: END IF;
145: --
146: v_FileName := OE_DEBUG_PUB.set_debug_mode ('FILE');
147: --
145: --
146: v_FileName := OE_DEBUG_PUB.set_debug_mode ('FILE');
147: --
148: IF (l_debug <> -1) THEN
149: rlm_core_sv.dlog(k_DEBUG,'Om Debug File name:',v_FileName);
150: END IF;
151: --
152: -- This setting ensures the pl/sql table returned by Process
153: -- order api contains messages from workflow scheduling activities
159: --
160: v_FileName := OE_DEBUG_PUB.set_debug_mode ('CONC');
161: --
162: IF (l_debug <> -1) THEN
163: rlm_core_sv.dlog(k_DEBUG,'x_Op_tab(1).schedule_type', x_Op_tab(1).schedule_type);
164: END IF;
165: --
166: SELECT hsecs INTO l_start_time from v$timer;
167: --
174:
175: WHILE i IS NOT NULL LOOP
176:
177: IF (l_debug <> -1) THEN
178: rlm_core_sv.dlog(k_DEBUG,'g_oe_line_tbl(i).operation', g_oe_line_tbl(i).operation);
179: rlm_core_sv.dlog(k_DEBUG,'g_oe_line_tbl(i).line_id', g_oe_line_tbl(i).line_id);
180: END IF;
181:
182: IF g_oe_line_tbl(i).operation <> OE_GLOBALS.G_OPR_CREATE THEN
175: WHILE i IS NOT NULL LOOP
176:
177: IF (l_debug <> -1) THEN
178: rlm_core_sv.dlog(k_DEBUG,'g_oe_line_tbl(i).operation', g_oe_line_tbl(i).operation);
179: rlm_core_sv.dlog(k_DEBUG,'g_oe_line_tbl(i).line_id', g_oe_line_tbl(i).line_id);
180: END IF;
181:
182: IF g_oe_line_tbl(i).operation <> OE_GLOBALS.G_OPR_CREATE THEN
183: l_line_tbl(j).line_id := g_oe_line_tbl(i).line_id;
189:
190: IF l_line_tbl.count > 0 THEN --{
191:
192: IF (l_debug <> -1) THEN
193: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl.count',l_line_tbl.count);
194: END IF;
195:
196: OE_ORDER_PUB.Lock_Order(
197: p_api_version_number => x_oe_api_version
224: );
225:
226:
227: IF (l_debug <> -1) THEN
228: rlm_core_sv.dlog(k_DEBUG,'Lock Order l_lock_status',l_lock_status);
229: rlm_core_sv.dlog(k_DEBUG,'Lock Order Error Count',x_msg_count);
230: rlm_core_sv.dlog(k_DEBUG,'Lock Order Error',x_msg_data);
231: END IF;
232: --
225:
226:
227: IF (l_debug <> -1) THEN
228: rlm_core_sv.dlog(k_DEBUG,'Lock Order l_lock_status',l_lock_status);
229: rlm_core_sv.dlog(k_DEBUG,'Lock Order Error Count',x_msg_count);
230: rlm_core_sv.dlog(k_DEBUG,'Lock Order Error',x_msg_data);
231: END IF;
232: --
233: END IF; --}
226:
227: IF (l_debug <> -1) THEN
228: rlm_core_sv.dlog(k_DEBUG,'Lock Order l_lock_status',l_lock_status);
229: rlm_core_sv.dlog(k_DEBUG,'Lock Order Error Count',x_msg_count);
230: rlm_core_sv.dlog(k_DEBUG,'Lock Order Error',x_msg_data);
231: END IF;
232: --
233: END IF; --}
234:
235: IF l_lock_status = FND_API.G_RET_STS_UNEXP_ERROR OR
236: l_lock_status = FND_API.G_RET_STS_ERROR THEN
237: --
238: IF (l_debug <> -1) THEN
239: rlm_core_sv.dlog(k_DEBUG,'Raising e_LockOrderFailed');
240: END IF;
241: x_return_status := l_lock_status;
242: RAISE e_LockOrderFailed;
243: --
244: END IF;
245: --
246:
247: IF (l_debug <> -1) THEN
248: rlm_core_sv.dlog(k_DEBUG,'x_Op_tab(1).schedule_type',x_Op_tab(1).schedule_type);
249: END IF;
250: /* Bugfix 12863728 End */
251:
252: IF x_Op_tab(1).schedule_type <> k_SEQUENCED THEN
251:
252: IF x_Op_tab(1).schedule_type <> k_SEQUENCED THEN
253: --
254: IF (l_debug <> -1) THEN
255: rlm_core_sv.dlog(k_DEBUG,'Calling OE_Order_GRP.Process_order');
256: END IF;
257:
258: OE_Order_GRP.Process_order
259: ( p_api_version_number => x_oe_api_version
295: l_control_rec.controlled_operation := TRUE;
296: l_control_rec.process_partial := TRUE;
297: --
298: IF (l_debug <> -1) THEN
299: rlm_core_sv.dlog(k_DEBUG,'Calling OE_Order_GRP.Process_order');
300: END IF;
301:
302: OE_Order_GRP.Process_order
303: ( p_api_version_number => x_oe_api_version
346: x_return_status := l_return_status;
347: --
348: IF (l_debug <> -1) THEN
349: --
350: rlm_core_sv.dlog(k_DEBUG,'# of lines in input tbl',g_oe_line_tbl.LAST);
351: rlm_core_sv.dlog(k_DEBUG,'# of lines in output table',l_oe_line_tbl_out.LAST);
352: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status',x_return_Status);
353: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
354: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
347: --
348: IF (l_debug <> -1) THEN
349: --
350: rlm_core_sv.dlog(k_DEBUG,'# of lines in input tbl',g_oe_line_tbl.LAST);
351: rlm_core_sv.dlog(k_DEBUG,'# of lines in output table',l_oe_line_tbl_out.LAST);
352: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status',x_return_Status);
353: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
354: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
355: END IF;
348: IF (l_debug <> -1) THEN
349: --
350: rlm_core_sv.dlog(k_DEBUG,'# of lines in input tbl',g_oe_line_tbl.LAST);
351: rlm_core_sv.dlog(k_DEBUG,'# of lines in output table',l_oe_line_tbl_out.LAST);
352: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status',x_return_Status);
353: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
354: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
355: END IF;
356: --
349: --
350: rlm_core_sv.dlog(k_DEBUG,'# of lines in input tbl',g_oe_line_tbl.LAST);
351: rlm_core_sv.dlog(k_DEBUG,'# of lines in output table',l_oe_line_tbl_out.LAST);
352: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status',x_return_Status);
353: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
354: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
355: END IF;
356: --
357: g_total_lines := g_total_lines + g_oe_line_tbl.LAST;
350: rlm_core_sv.dlog(k_DEBUG,'# of lines in input tbl',g_oe_line_tbl.LAST);
351: rlm_core_sv.dlog(k_DEBUG,'# of lines in output table',l_oe_line_tbl_out.LAST);
352: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status',x_return_Status);
353: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
354: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
355: END IF;
356: --
357: g_total_lines := g_total_lines + g_oe_line_tbl.LAST;
358: g_total_time := g_total_time + ((l_end_time-l_start_time)/100);
380: --
381: END IF;
382: --
383: IF (l_debug <> -1) THEN
384: rlm_core_sv.dpop(k_SDEBUG,'successful');
385: END IF;
386: --
387: --x_return_status := 'E';
388: --
403: --
404: FOR s IN 1 .. l_oe_line_tbl_out.COUNT LOOP
405: --
406: IF (l_debug <> -1) THEN
407: rlm_core_sv.dlog(k_DEBUG, 'Line return status', l_oe_line_tbl_out(s).return_status);
408: END IF;
409: --
410: IF l_oe_line_tbl_out(s).return_status <> FND_API.G_RET_STS_SUCCESS THEN
411: --
409: --
410: IF l_oe_line_tbl_out(s).return_status <> FND_API.G_RET_STS_SUCCESS THEN
411: --
412: UPDATE rlm_schedule_lines_all
413: SET process_status = rlm_core_sv.k_PS_ERROR
414: WHERE line_id = l_oe_line_tbl_out(s).source_document_line_id;
415: --
416: BEGIN
417: --
415: --
416: BEGIN
417: --
418: UPDATE rlm_interface_lines_all
419: SET process_status = rlm_core_sv.k_PS_ERROR
420: WHERE line_id =
421: (
422: SELECT interface_line_id
423: FROM rlm_schedule_lines_all
424: WHERE line_id = l_oe_line_tbl_out(s).source_document_line_id
425: );
426: --
427: IF (l_debug <> -1) THEN
428: rlm_core_sv.dlog(k_DEBUG, 'No of Interface Lines updated', SQL%ROWCOUNT);
429: END IF;
430: --
431: EXCEPTION
432: --
432: --
433: WHEN OTHERS THEN
434: --
435: IF (l_debug <> -1) THEN
436: rlm_core_sv.dlog(k_DEBUG, 'Interface Line not found for
437: Source Document Line Id', l_oe_line_tbl_out(s).source_document_line_id);
438: END IF;
439: --
440: END;
441: --
442: ELSE
443: --
444: UPDATE rlm_schedule_lines_all
445: SET process_status = rlm_core_sv.k_PS_PROCESSED
446: WHERE line_id = l_oe_line_tbl_out(s).source_document_line_id;
447: --
448: BEGIN
449: --
447: --
448: BEGIN
449: --
450: UPDATE rlm_interface_lines_all
451: SET process_status = rlm_core_sv.k_PS_PROCESSED
452: WHERE line_id =
453: (
454: SELECT interface_line_id
455: FROM rlm_schedule_lines_all
456: WHERE line_id = l_oe_line_tbl_out(s).source_document_line_id
457: );
458: --
459: IF (l_debug <> -1) THEN
460: rlm_core_sv.dlog(k_DEBUG, 'No of Interface Lines updated', SQL%ROWCOUNT);
461: END IF;
462: --
463: EXCEPTION
464: --
464: --
465: WHEN OTHERS THEN
466: --
467: IF (l_debug <> -1) THEN
468: rlm_core_sv.dlog(k_DEBUG, 'Interface Line not found for
469: Source Document Line Id', l_oe_line_tbl_out(s).source_document_line_id);
470: END IF;
471: --
472: END;
477: --
478: END IF;/*2342919*/
479: --
480: IF (l_debug <> -1) THEN
481: rlm_core_sv.dpop(k_SDEBUG);
482: END IF;
483: --
484: WHEN e_LockOrderFailed THEN -- Bugfix 12863728
485: --
496: x_ScheduleLineId => NULL,
497: x_OrderHeaderId => NULL,
498: x_OrderLineId => NULL,
499: x_Token1 => 'ORD',
500: x_value1 => rlm_core_sv.get_order_number(x_Op_Tab(1).order_header_id),
501: x_Token2 => 'ORG',
502: x_value2 => rlm_core_sv.get_ship_from(x_Op_Tab(1).ship_from_org_id),
503: x_Token3 => 'SHIP_TO',
504: x_value3 => l_location_code,
498: x_OrderLineId => NULL,
499: x_Token1 => 'ORD',
500: x_value1 => rlm_core_sv.get_order_number(x_Op_Tab(1).order_header_id),
501: x_Token2 => 'ORG',
502: x_value2 => rlm_core_sv.get_ship_from(x_Op_Tab(1).ship_from_org_id),
503: x_Token3 => 'SHIP_TO',
504: x_value3 => l_location_code,
505: x_Token4 => 'CUST_ITEM',
506: x_value4 => rlm_core_sv.get_item_number(x_Op_Tab(1).customer_item_id));
502: x_value2 => rlm_core_sv.get_ship_from(x_Op_Tab(1).ship_from_org_id),
503: x_Token3 => 'SHIP_TO',
504: x_value3 => l_location_code,
505: x_Token4 => 'CUST_ITEM',
506: x_value4 => rlm_core_sv.get_item_number(x_Op_Tab(1).customer_item_id));
507: --
508: IF (l_debug <> -1) THEN
509: rlm_core_sv.dlog(k_DEBUG,'Order Lines Locking failed', x_return_Status);
510: rlm_core_sv.dpop(k_SDEBUG);
505: x_Token4 => 'CUST_ITEM',
506: x_value4 => rlm_core_sv.get_item_number(x_Op_Tab(1).customer_item_id));
507: --
508: IF (l_debug <> -1) THEN
509: rlm_core_sv.dlog(k_DEBUG,'Order Lines Locking failed', x_return_Status);
510: rlm_core_sv.dpop(k_SDEBUG);
511: END IF;
512: --
513: WHEN e_BuildOELineTab THEN
506: x_value4 => rlm_core_sv.get_item_number(x_Op_Tab(1).customer_item_id));
507: --
508: IF (l_debug <> -1) THEN
509: rlm_core_sv.dlog(k_DEBUG,'Order Lines Locking failed', x_return_Status);
510: rlm_core_sv.dpop(k_SDEBUG);
511: END IF;
512: --
513: WHEN e_BuildOELineTab THEN
514: --
524: x_Token1 => 'ERROR',
525: x_value1 => substr(sqlerrm,1,200));
526: --
527: IF (l_debug <> -1) THEN
528: rlm_core_sv.dlog(k_DEBUG,'Build OE Line Tab returned failed', x_return_Status);
529: rlm_core_sv.dlog(k_DEBUG,'Error',substr(sqlerrm,1,200));
530: rlm_core_sv.dpop(k_SDEBUG);
531: END IF;
532: --
525: x_value1 => substr(sqlerrm,1,200));
526: --
527: IF (l_debug <> -1) THEN
528: rlm_core_sv.dlog(k_DEBUG,'Build OE Line Tab returned failed', x_return_Status);
529: rlm_core_sv.dlog(k_DEBUG,'Error',substr(sqlerrm,1,200));
530: rlm_core_sv.dpop(k_SDEBUG);
531: END IF;
532: --
533: WHEN OTHERS THEN
526: --
527: IF (l_debug <> -1) THEN
528: rlm_core_sv.dlog(k_DEBUG,'Build OE Line Tab returned failed', x_return_Status);
529: rlm_core_sv.dlog(k_DEBUG,'Error',substr(sqlerrm,1,200));
530: rlm_core_sv.dpop(k_SDEBUG);
531: END IF;
532: --
533: WHEN OTHERS THEN
534: --
532: --
533: WHEN OTHERS THEN
534: --
535: IF (l_debug <> -1) THEN
536: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
537: END IF;
538: --
539: raise;
540: --
585: --
586: BEGIN
587: --
588: IF (l_debug <> -1) THEN
589: rlm_core_sv.dpush(k_SDEBUG,'InsertOMMessages');
590: rlm_core_sv.dlog(k_DEBUG,'x_msg_count',x_msg_count);
591: rlm_core_sv.dlog(k_DEBUG,'x_msg_name',x_msg_name);
592: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
593: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);
586: BEGIN
587: --
588: IF (l_debug <> -1) THEN
589: rlm_core_sv.dpush(k_SDEBUG,'InsertOMMessages');
590: rlm_core_sv.dlog(k_DEBUG,'x_msg_count',x_msg_count);
591: rlm_core_sv.dlog(k_DEBUG,'x_msg_name',x_msg_name);
592: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
593: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);
594: rlm_core_sv.dlog(k_DEBUG,'x_header_id',x_header_id);
587: --
588: IF (l_debug <> -1) THEN
589: rlm_core_sv.dpush(k_SDEBUG,'InsertOMMessages');
590: rlm_core_sv.dlog(k_DEBUG,'x_msg_count',x_msg_count);
591: rlm_core_sv.dlog(k_DEBUG,'x_msg_name',x_msg_name);
592: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
593: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);
594: rlm_core_sv.dlog(k_DEBUG,'x_header_id',x_header_id);
595: rlm_core_sv.dlog(k_DEBUG,'x_customer_item_id', x_customer_item_id);
588: IF (l_debug <> -1) THEN
589: rlm_core_sv.dpush(k_SDEBUG,'InsertOMMessages');
590: rlm_core_sv.dlog(k_DEBUG,'x_msg_count',x_msg_count);
591: rlm_core_sv.dlog(k_DEBUG,'x_msg_name',x_msg_name);
592: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
593: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);
594: rlm_core_sv.dlog(k_DEBUG,'x_header_id',x_header_id);
595: rlm_core_sv.dlog(k_DEBUG,'x_customer_item_id', x_customer_item_id);
596: rlm_core_sv.dlog(k_DEBUG,'oe_msg_pub.count_msg',oe_msg_pub.count_msg);
589: rlm_core_sv.dpush(k_SDEBUG,'InsertOMMessages');
590: rlm_core_sv.dlog(k_DEBUG,'x_msg_count',x_msg_count);
591: rlm_core_sv.dlog(k_DEBUG,'x_msg_name',x_msg_name);
592: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
593: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);
594: rlm_core_sv.dlog(k_DEBUG,'x_header_id',x_header_id);
595: rlm_core_sv.dlog(k_DEBUG,'x_customer_item_id', x_customer_item_id);
596: rlm_core_sv.dlog(k_DEBUG,'oe_msg_pub.count_msg',oe_msg_pub.count_msg);
597: END IF;
590: rlm_core_sv.dlog(k_DEBUG,'x_msg_count',x_msg_count);
591: rlm_core_sv.dlog(k_DEBUG,'x_msg_name',x_msg_name);
592: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
593: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);
594: rlm_core_sv.dlog(k_DEBUG,'x_header_id',x_header_id);
595: rlm_core_sv.dlog(k_DEBUG,'x_customer_item_id', x_customer_item_id);
596: rlm_core_sv.dlog(k_DEBUG,'oe_msg_pub.count_msg',oe_msg_pub.count_msg);
597: END IF;
598: --
591: rlm_core_sv.dlog(k_DEBUG,'x_msg_name',x_msg_name);
592: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
593: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);
594: rlm_core_sv.dlog(k_DEBUG,'x_header_id',x_header_id);
595: rlm_core_sv.dlog(k_DEBUG,'x_customer_item_id', x_customer_item_id);
596: rlm_core_sv.dlog(k_DEBUG,'oe_msg_pub.count_msg',oe_msg_pub.count_msg);
597: END IF;
598: --
599: -- Get message count and data
592: rlm_core_sv.dlog(k_DEBUG,'x_msg_level',x_msg_level);
593: rlm_core_sv.dlog(k_DEBUG,'x_token',x_token);
594: rlm_core_sv.dlog(k_DEBUG,'x_header_id',x_header_id);
595: rlm_core_sv.dlog(k_DEBUG,'x_customer_item_id', x_customer_item_id);
596: rlm_core_sv.dlog(k_DEBUG,'oe_msg_pub.count_msg',oe_msg_pub.count_msg);
597: END IF;
598: --
599: -- Get message count and data
600: -- Bug 4297984
601: fnd_message.set_name ('ONT','OE_VAL_DUP_PO_NUMBER');
602: v_PO_msg := fnd_message.get;
603: --
604: IF (l_debug <> -1) THEN
605: rlm_core_sv.dlog(k_DEBUG,'v_PO_msg',v_PO_msg);
606: END IF;
607: --
608: IF x_msg_count > 0 THEN
609: --{
615: --Bugfix 11671199 Start
616: x_msg_line_number := OE_ORDER_MISC_PUB.GET_CONCAT_LINE_NUMBER(oe_msg_pub.g_msg_tbl(I).line_id);
617:
618: IF (l_debug <> -1) THEN
619: rlm_core_sv.dlog(k_DEBUG,'x_msg_line_number',x_msg_line_number);
620: END IF;
621:
622: BEGIN
623:
626: FROM oe_order_lines_all
627: WHERE line_id = oe_msg_pub.g_msg_tbl(i).line_id;
628:
629: IF (l_debug <> -1) THEN
630: rlm_core_sv.dlog(k_DEBUG,'v_item_name',v_item_name);
631: END IF;
632:
633: EXCEPTION
634: WHEN NO_DATA_FOUND THEN
633: EXCEPTION
634: WHEN NO_DATA_FOUND THEN
635: --
636: IF (l_debug <> -1) THEN
637: rlm_core_sv.dlog(k_DEBUG,'No line id exists');
638: END IF;
639: --
640: END;
641: IF x_msg_line_number IS NOT NULL THEN
643: END IF;
644: --Bugfix 11671199 End
645:
646: IF (l_debug <> -1) THEN
647: rlm_core_sv.dlog(k_DEBUG, 'Message at index', I);
648: rlm_core_sv.dlog(k_DEBUG,'Message Found', substr(x_msg,1,200));
649: rlm_core_sv.dlog(k_DEBUG,'get message context');
650: END IF;
651: --
644: --Bugfix 11671199 End
645:
646: IF (l_debug <> -1) THEN
647: rlm_core_sv.dlog(k_DEBUG, 'Message at index', I);
648: rlm_core_sv.dlog(k_DEBUG,'Message Found', substr(x_msg,1,200));
649: rlm_core_sv.dlog(k_DEBUG,'get message context');
650: END IF;
651: --
652: IF (substr(x_msg,1,200) <> v_PO_msg) THEN -- Bug 4297984
645:
646: IF (l_debug <> -1) THEN
647: rlm_core_sv.dlog(k_DEBUG, 'Message at index', I);
648: rlm_core_sv.dlog(k_DEBUG,'Message Found', substr(x_msg,1,200));
649: rlm_core_sv.dlog(k_DEBUG,'get message context');
650: END IF;
651: --
652: IF (substr(x_msg,1,200) <> v_PO_msg) THEN -- Bug 4297984
653: --
673: ,x_type => l_type
674: );
675: --
676: IF (l_debug <> -1) THEN
677: rlm_core_sv.dlog(k_DEBUG, 'schedule line',
678: l_source_document_line_id);
679: rlm_core_sv.dlog(k_DEBUG, 'ProcessOrderAPI Error',
680: substr(x_msg,1,200));
681: END IF;
675: --
676: IF (l_debug <> -1) THEN
677: rlm_core_sv.dlog(k_DEBUG, 'schedule line',
678: l_source_document_line_id);
679: rlm_core_sv.dlog(k_DEBUG, 'ProcessOrderAPI Error',
680: substr(x_msg,1,200));
681: END IF;
682: --
683: IF NVL(l_source_document_line_id,FND_API.G_MISS_NUM) <>
689: FROM rlm_schedule_lines
690: WHERE line_id = l_source_document_line_id;
691: --
692: IF (l_debug <> -1) THEN
693: rlm_core_sv.dlog(k_DEBUG,'interface line',v_interface_line_id);
694: END IF;
695: --
696: EXCEPTION
697: --
697: --
698: WHEN OTHERS THEN
699: --
700: IF (l_debug <> -1) THEN
701: rlm_core_sv.dlog(k_DEBUG,'Could not get interface line');
702: END IF;
703: --
704: END;
705: END IF;
704: END;
705: END IF;
706: --
707: IF (l_debug <> -1) THEN
708: rlm_core_sv.dlog(k_DEBUG,'l_source_document_id', l_source_document_id);
709: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id', v_schedule_header_id);
710: rlm_core_sv.dlog(k_DEBUG,'l_header_id', l_header_id);
711: rlm_core_sv.dlog(k_DEBUG,'order_header_id', v_order_header_id);
712: rlm_core_sv.dlog(k_DEBUG,'x_msg_level', x_msg_level);
705: END IF;
706: --
707: IF (l_debug <> -1) THEN
708: rlm_core_sv.dlog(k_DEBUG,'l_source_document_id', l_source_document_id);
709: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id', v_schedule_header_id);
710: rlm_core_sv.dlog(k_DEBUG,'l_header_id', l_header_id);
711: rlm_core_sv.dlog(k_DEBUG,'order_header_id', v_order_header_id);
712: rlm_core_sv.dlog(k_DEBUG,'x_msg_level', x_msg_level);
713: rlm_core_sv.dlog(k_DEBUG,'x_msg_name', x_msg_name);
706: --
707: IF (l_debug <> -1) THEN
708: rlm_core_sv.dlog(k_DEBUG,'l_source_document_id', l_source_document_id);
709: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id', v_schedule_header_id);
710: rlm_core_sv.dlog(k_DEBUG,'l_header_id', l_header_id);
711: rlm_core_sv.dlog(k_DEBUG,'order_header_id', v_order_header_id);
712: rlm_core_sv.dlog(k_DEBUG,'x_msg_level', x_msg_level);
713: rlm_core_sv.dlog(k_DEBUG,'x_msg_name', x_msg_name);
714: END IF;
707: IF (l_debug <> -1) THEN
708: rlm_core_sv.dlog(k_DEBUG,'l_source_document_id', l_source_document_id);
709: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id', v_schedule_header_id);
710: rlm_core_sv.dlog(k_DEBUG,'l_header_id', l_header_id);
711: rlm_core_sv.dlog(k_DEBUG,'order_header_id', v_order_header_id);
712: rlm_core_sv.dlog(k_DEBUG,'x_msg_level', x_msg_level);
713: rlm_core_sv.dlog(k_DEBUG,'x_msg_name', x_msg_name);
714: END IF;
715: --
708: rlm_core_sv.dlog(k_DEBUG,'l_source_document_id', l_source_document_id);
709: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id', v_schedule_header_id);
710: rlm_core_sv.dlog(k_DEBUG,'l_header_id', l_header_id);
711: rlm_core_sv.dlog(k_DEBUG,'order_header_id', v_order_header_id);
712: rlm_core_sv.dlog(k_DEBUG,'x_msg_level', x_msg_level);
713: rlm_core_sv.dlog(k_DEBUG,'x_msg_name', x_msg_name);
714: END IF;
715: --
716: oe_debug_pub.add(substr(x_msg,1,200));
709: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id', v_schedule_header_id);
710: rlm_core_sv.dlog(k_DEBUG,'l_header_id', l_header_id);
711: rlm_core_sv.dlog(k_DEBUG,'order_header_id', v_order_header_id);
712: rlm_core_sv.dlog(k_DEBUG,'x_msg_level', x_msg_level);
713: rlm_core_sv.dlog(k_DEBUG,'x_msg_name', x_msg_name);
714: END IF;
715: --
716: oe_debug_pub.add(substr(x_msg,1,200));
717: --
731: l_msg_level := x_msg_level;
732: END IF;
733: --
734: IF (l_debug<> -1) THEN
735: rlm_core_sv.dlog(k_DEBUG, 'l_msg_level', l_msg_level);
736: END IF;
737: --
738: rlm_message_sv.app_error(
739: x_ExceptionLevel => l_msg_level,
746: x_OrderLineId => l_line_id,
747: x_Token1 => x_token,
748: x_value1 => substr(x_msg,1,200),
749: x_Token2 => 'CUST_ITEM',
750: x_value2 => rlm_core_sv.get_item_number(x_customer_item_id),
751: x_Token3 => 'REQ_DATE',
752: x_value3 => v_request_date);
753: --
754: IF (l_debug <> -1) THEN
751: x_Token3 => 'REQ_DATE',
752: x_value3 => v_request_date);
753: --
754: IF (l_debug <> -1) THEN
755: rlm_core_sv.dlog(k_DEBUG,'x_msg', substr(x_msg,1,200));
756: END IF;
757: --
758: END IF; -- Bug 4297984
759: --
762: ELSIF (x_msg_count = 0 AND
763: (x_msg_level = 'U' OR x_msg_level = 'E')) THEN
764: --{
765: IF (l_debug <> -1) THEN
766: rlm_core_sv.dlog(k_DEBUG, 'Inserting RLM_PROCESS_ORDER_ERROR_E msg');
767: END IF;
768: --
769: rlm_message_sv.app_error(
770: x_ExceptionLevel => rlm_message_sv.k_error_level,
777: x_OrderLineId => NULL,
778: x_Token1 => 'ERROR',
779: x_value1 => substr(sqlerrm,1,200),
780: x_Token2 => 'CUST_ITEM',
781: x_Value2 => rlm_core_sv.get_item_number(x_customer_item_id)
782: );
783: --}
784: END IF;
785: --
783: --}
784: END IF;
785: --
786: IF (l_debug <> -1) THEN
787: rlm_core_sv.dpop(k_SDEBUG,'successful');
788: END IF;
789: --
790: EXCEPTION
791: --
791: --
792: WHEN OTHERS THEN
793: --
794: IF (l_debug <> -1) THEN
795: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
796: END IF;
797: --
798: raise;
799: END InsertOMMessages;
851: --
852: BEGIN
853: --
854: IF (l_debug <> -1) THEN
855: rlm_core_sv.dpush(k_SDEBUG,'CallProcessConstraintAPI');
856: rlm_core_sv.dlog(k_DEBUG,'x_Operation',x_Operation);
857: END IF;
858: --
859: l_line_tbl(1) := oe_order_pub.g_miss_line_rec;
852: BEGIN
853: --
854: IF (l_debug <> -1) THEN
855: rlm_core_sv.dpush(k_SDEBUG,'CallProcessConstraintAPI');
856: rlm_core_sv.dlog(k_DEBUG,'x_Operation',x_Operation);
857: END IF;
858: --
859: l_line_tbl(1) := oe_order_pub.g_miss_line_rec;
860: RLM_TPA_SV.BuildOELine(l_line_tbl(1),x_Key_rec.req_rec);
862: l_line_tbl(1).operation := x_Operation;
863: l_line_tbl(1).ordered_quantity := x_OperationQty;
864: --
865: IF (l_debug <> -1) THEN
866: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).operation',
867: l_line_tbl(1).operation);
868: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).line_id',
869: l_line_tbl(1).line_id);
870: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).ordered_quantity',
864: --
865: IF (l_debug <> -1) THEN
866: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).operation',
867: l_line_tbl(1).operation);
868: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).line_id',
869: l_line_tbl(1).line_id);
870: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).ordered_quantity',
871: l_line_tbl(1).ordered_quantity);
872: END IF;
866: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).operation',
867: l_line_tbl(1).operation);
868: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).line_id',
869: l_line_tbl(1).line_id);
870: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).ordered_quantity',
871: l_line_tbl(1).ordered_quantity);
872: END IF;
873: --
874: fnd_profile.get(rlm_core_sv.C_DEBUG_PROFILE, v_DebugMode);
870: rlm_core_sv.dlog(k_DEBUG,'l_line_tbl(1).ordered_quantity',
871: l_line_tbl(1).ordered_quantity);
872: END IF;
873: --
874: fnd_profile.get(rlm_core_sv.C_DEBUG_PROFILE, v_DebugMode);
875: --
876: oe_debug_pub.add('Calling Process_order from DSP');
877: --
878: IF (l_debug <> -1) THEN
875: --
876: oe_debug_pub.add('Calling Process_order from DSP');
877: --
878: IF (l_debug <> -1) THEN
879: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.G_DEBUG);
880: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
881: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
882: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);
883: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
876: oe_debug_pub.add('Calling Process_order from DSP');
877: --
878: IF (l_debug <> -1) THEN
879: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.G_DEBUG);
880: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
881: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
882: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);
883: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
884: rlm_core_sv.dlog(k_DEBUG,'G_FILE',OE_DEBUG_PUB.G_FILE);
877: --
878: IF (l_debug <> -1) THEN
879: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.G_DEBUG);
880: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
881: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
882: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);
883: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
884: rlm_core_sv.dlog(k_DEBUG,'G_FILE',OE_DEBUG_PUB.G_FILE);
885: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for process Constraints in DSP concurrent request log');
878: IF (l_debug <> -1) THEN
879: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.G_DEBUG);
880: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
881: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
882: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);
883: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
884: rlm_core_sv.dlog(k_DEBUG,'G_FILE',OE_DEBUG_PUB.G_FILE);
885: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for process Constraints in DSP concurrent request log');
886: END IF;
879: rlm_core_sv.dlog(k_DEBUG,'IS OM Debug On:', OE_DEBUG_PUB.G_DEBUG);
880: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
881: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
882: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);
883: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
884: rlm_core_sv.dlog(k_DEBUG,'G_FILE',OE_DEBUG_PUB.G_FILE);
885: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for process Constraints in DSP concurrent request log');
886: END IF;
887: --
880: rlm_core_sv.dlog(k_DEBUG,'OM Debug Level:', to_char(OE_DEBUG_PUB.G_DEBUG_LEVEL));
881: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
882: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);
883: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
884: rlm_core_sv.dlog(k_DEBUG,'G_FILE',OE_DEBUG_PUB.G_FILE);
885: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for process Constraints in DSP concurrent request log');
886: END IF;
887: --
888: oe_order_grp.Process_order
881: rlm_core_sv.dlog(k_DEBUG,'G_UI_FLAG',OE_GLOBALS.G_UI_FLAG);
882: rlm_core_sv.dlog(k_DEBUG,'ISDebugOn',OE_DEBUG_PUB.ISDebugOn);
883: rlm_core_sv.dlog(k_DEBUG,'G_DEBUG_MODE',OE_DEBUG_PUB.G_DEBUG_MODE);
884: rlm_core_sv.dlog(k_DEBUG,'G_FILE',OE_DEBUG_PUB.G_FILE);
885: rlm_core_sv.dlog(k_DEBUG,'See OE DEBUG FILE for process Constraints in DSP concurrent request log');
886: END IF;
887: --
888: oe_order_grp.Process_order
889: ( p_api_version_number => x_api_version_number
916: , x_lot_serial_val_tbl => l_lot_serial_val_tbl
917: );
918: --
919: IF (l_debug <> -1) THEN
920: rlm_core_sv.dlog(k_DEBUG,'File Name',OE_DEBUG_PUB.G_FILE);
921: rlm_core_sv.dlog(k_DEBUG,'l_return_status',l_return_status);
922: END IF;
923: --
924: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
917: );
918: --
919: IF (l_debug <> -1) THEN
920: rlm_core_sv.dlog(k_DEBUG,'File Name',OE_DEBUG_PUB.G_FILE);
921: rlm_core_sv.dlog(k_DEBUG,'l_return_status',l_return_status);
922: END IF;
923: --
924: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: --
930: b_result := FALSE;
931: --
932: IF (l_debug <> -1) THEN
933: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
934: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
935: rlm_core_sv.dlog(k_DEBUG,'no of lines in g_oe_line_tbl',g_oe_line_tbl.LAST);
936: rlm_core_sv.dpop(k_SDEBUG,' no process constraints found -- returning false');
937: END IF;
930: b_result := FALSE;
931: --
932: IF (l_debug <> -1) THEN
933: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
934: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
935: rlm_core_sv.dlog(k_DEBUG,'no of lines in g_oe_line_tbl',g_oe_line_tbl.LAST);
936: rlm_core_sv.dpop(k_SDEBUG,' no process constraints found -- returning false');
937: END IF;
938: --
931: --
932: IF (l_debug <> -1) THEN
933: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
934: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
935: rlm_core_sv.dlog(k_DEBUG,'no of lines in g_oe_line_tbl',g_oe_line_tbl.LAST);
936: rlm_core_sv.dpop(k_SDEBUG,' no process constraints found -- returning false');
937: END IF;
938: --
939: END IF;
932: IF (l_debug <> -1) THEN
933: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
934: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
935: rlm_core_sv.dlog(k_DEBUG,'no of lines in g_oe_line_tbl',g_oe_line_tbl.LAST);
936: rlm_core_sv.dpop(k_SDEBUG,' no process constraints found -- returning false');
937: END IF;
938: --
939: END IF;
940: --
946: --
947: b_result := TRUE;
948: --
949: IF (l_debug <> -1) THEN
950: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
951: FND_API.G_RET_STS_ERROR');
952: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
953: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
954: END IF;
948: --
949: IF (l_debug <> -1) THEN
950: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
951: FND_API.G_RET_STS_ERROR');
952: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
953: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
954: END IF;
955: --
956: --x_Qty_rec.reconcile := l_line_out_Tbl(1).ordered_quantity;
949: IF (l_debug <> -1) THEN
950: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
951: FND_API.G_RET_STS_ERROR');
952: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
953: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
954: END IF;
955: --
956: --x_Qty_rec.reconcile := l_line_out_Tbl(1).ordered_quantity;
957: --x_Qty_rec.available_to_cancel := l_line_out_Tbl(1).ordered_quantity;
961: x_msg_name := 'RLM_PROC_CONS_FOUND';
962: x_Token := 'CONSTRAINT';
963: --
964: IF (l_debug <> -1) THEN
965: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
966: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
967: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
968: x_Key_rec.req_rec.schedule_header_id);
969: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
962: x_Token := 'CONSTRAINT';
963: --
964: IF (l_debug <> -1) THEN
965: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
966: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
967: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
968: x_Key_rec.req_rec.schedule_header_id);
969: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
970: x_Key_rec.req_rec.schedule_line_id);
963: --
964: IF (l_debug <> -1) THEN
965: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
966: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
967: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
968: x_Key_rec.req_rec.schedule_header_id);
969: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
970: x_Key_rec.req_rec.schedule_line_id);
971: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id', x_Key_rec.dem_rec.header_id);
965: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
966: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
967: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
968: x_Key_rec.req_rec.schedule_header_id);
969: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
970: x_Key_rec.req_rec.schedule_line_id);
971: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id', x_Key_rec.dem_rec.header_id);
972: rlm_core_sv.dlog(k_DEBUG,'dem_rec.line_id', x_Key_rec.dem_rec.line_id);
973: END IF;
967: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
968: x_Key_rec.req_rec.schedule_header_id);
969: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
970: x_Key_rec.req_rec.schedule_line_id);
971: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id', x_Key_rec.dem_rec.header_id);
972: rlm_core_sv.dlog(k_DEBUG,'dem_rec.line_id', x_Key_rec.dem_rec.line_id);
973: END IF;
974: --
975: InsertOMMessages(x_Key_rec.req_rec.header_id,x_Key_rec.req_rec.customer_item_id,x_msg_count,
968: x_Key_rec.req_rec.schedule_header_id);
969: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
970: x_Key_rec.req_rec.schedule_line_id);
971: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id', x_Key_rec.dem_rec.header_id);
972: rlm_core_sv.dlog(k_DEBUG,'dem_rec.line_id', x_Key_rec.dem_rec.line_id);
973: END IF;
974: --
975: InsertOMMessages(x_Key_rec.req_rec.header_id,x_Key_rec.req_rec.customer_item_id,x_msg_count,
976: x_msg_level, x_token, x_msg_name);
975: InsertOMMessages(x_Key_rec.req_rec.header_id,x_Key_rec.req_rec.customer_item_id,x_msg_count,
976: x_msg_level, x_token, x_msg_name);
977: --
978: IF (l_debug <> -1) THEN
979: rlm_core_sv.dpop(k_SDEBUG,'in process Constraint found');
980: END IF;
981: --
982: RETURN(b_Result);
983: --
985: --
986: b_result := TRUE;
987: --
988: IF (l_debug <> -1) THEN
989: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
990: FND_API.G_RET_STS_UNEXP_ERROR');
991: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
992: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
993: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
987: --
988: IF (l_debug <> -1) THEN
989: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
990: FND_API.G_RET_STS_UNEXP_ERROR');
991: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
992: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
993: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
994: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
995: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
988: IF (l_debug <> -1) THEN
989: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
990: FND_API.G_RET_STS_UNEXP_ERROR');
991: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
992: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
993: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
994: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
995: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
996: x_Key_rec.req_rec.schedule_header_id);
989: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status
990: FND_API.G_RET_STS_UNEXP_ERROR');
991: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
992: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
993: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
994: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
995: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
996: x_Key_rec.req_rec.schedule_header_id);
997: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
990: FND_API.G_RET_STS_UNEXP_ERROR');
991: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
992: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
993: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
994: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
995: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
996: x_Key_rec.req_rec.schedule_header_id);
997: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
998: x_Key_rec.req_rec.schedule_line_id);
991: rlm_core_sv.dlog(k_DEBUG,'Process Order Error Count',x_msg_count);
992: rlm_core_sv.dlog(k_DEBUG,'Process Order Error',x_msg_data);
993: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
994: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
995: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
996: x_Key_rec.req_rec.schedule_header_id);
997: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
998: x_Key_rec.req_rec.schedule_line_id);
999: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id',
993: rlm_core_sv.dlog(k_DEBUG,'header_id',x_Key_rec.req_rec.header_id);
994: rlm_core_sv.dlog(k_DEBUG,'line_id',x_Key_rec.req_rec.line_id);
995: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
996: x_Key_rec.req_rec.schedule_header_id);
997: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
998: x_Key_rec.req_rec.schedule_line_id);
999: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id',
1000: x_Key_rec.dem_rec.header_id);
1001: rlm_core_sv.dlog(k_DEBUG,'dem_rec.line_id',
995: rlm_core_sv.dlog(k_DEBUG,'schedule_header_id',
996: x_Key_rec.req_rec.schedule_header_id);
997: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
998: x_Key_rec.req_rec.schedule_line_id);
999: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id',
1000: x_Key_rec.dem_rec.header_id);
1001: rlm_core_sv.dlog(k_DEBUG,'dem_rec.line_id',
1002: x_Key_rec.dem_rec.line_id);
1003: END IF;
997: rlm_core_sv.dlog(k_DEBUG,'schedule_line_id',
998: x_Key_rec.req_rec.schedule_line_id);
999: rlm_core_sv.dlog(k_DEBUG,'dem_rec.header_id',
1000: x_Key_rec.dem_rec.header_id);
1001: rlm_core_sv.dlog(k_DEBUG,'dem_rec.line_id',
1002: x_Key_rec.dem_rec.line_id);
1003: END IF;
1004: --
1005: x_msg_level := rlm_message_sv.k_warn_level;
1009: InsertOMMessages(x_Key_rec.req_rec.header_id,x_Key_rec.req_rec.customer_item_id,x_msg_count,
1010: x_msg_level,x_token, x_msg_name);
1011: --
1012: IF (l_debug <> -1) THEN
1013: rlm_core_sv.dpop(k_SDEBUG,'In process Constraint Unexpected error');
1014: END IF;
1015: --
1016: RETURN(b_Result);
1017: --
1019: --
1020: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1021: --
1022: IF (l_debug <> -1) THEN
1023: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status', l_return_status);
1024: rlm_core_sv.dlog(k_DEBUG,'EXCEPTION',SUBSTR(SQLERRM,1,200));
1025: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1026: END IF;
1027: --
1020: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1021: --
1022: IF (l_debug <> -1) THEN
1023: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status', l_return_status);
1024: rlm_core_sv.dlog(k_DEBUG,'EXCEPTION',SUBSTR(SQLERRM,1,200));
1025: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1026: END IF;
1027: --
1028: raise;
1021: --
1022: IF (l_debug <> -1) THEN
1023: rlm_core_sv.dlog(k_DEBUG,'Process Order return Status', l_return_status);
1024: rlm_core_sv.dlog(k_DEBUG,'EXCEPTION',SUBSTR(SQLERRM,1,200));
1025: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1026: END IF;
1027: --
1028: raise;
1029:
1045: x_OrgId In NUMBER,
1046: x_SchedType In VARCHAR2,
1047: x_ShipperRecs In WSH_RLM_INTERFACE.t_shipper_rec,
1048: x_ShipmentDate IN DATE,
1049: x_MatchWithin IN RLM_CORE_SV.T_MATCH_REC,
1050: x_MatchAcross IN RLM_CORE_SV.T_MATCH_REC,
1051: x_Match_Rec IN WSH_RLM_INTERFACE.t_optional_match_rec,
1052: x_header_id IN NUMBER,
1053: x_InTransitQty OUT NOCOPY NUMBER,
1046: x_SchedType In VARCHAR2,
1047: x_ShipperRecs In WSH_RLM_INTERFACE.t_shipper_rec,
1048: x_ShipmentDate IN DATE,
1049: x_MatchWithin IN RLM_CORE_SV.T_MATCH_REC,
1050: x_MatchAcross IN RLM_CORE_SV.T_MATCH_REC,
1051: x_Match_Rec IN WSH_RLM_INTERFACE.t_optional_match_rec,
1052: x_header_id IN NUMBER,
1053: x_InTransitQty OUT NOCOPY NUMBER,
1054: x_return_status OUT NOCOPY VARCHAR2)
1060: v_details VARCHAR2(3000);
1061: v_get_msg_count NUMBER;
1062: -- global_atp
1063: v_ship_from_org_id NUMBER;
1064: v_MatchWithin RLM_CORE_SV.T_MATCH_REC;
1065: v_MatchAcross RLM_CORE_SV.T_MATCH_REC;
1066:
1067: BEGIN
1068: --
1061: v_get_msg_count NUMBER;
1062: -- global_atp
1063: v_ship_from_org_id NUMBER;
1064: v_MatchWithin RLM_CORE_SV.T_MATCH_REC;
1065: v_MatchAcross RLM_CORE_SV.T_MATCH_REC;
1066:
1067: BEGIN
1068: --
1069: IF (l_debug <> -1) THEN
1066:
1067: BEGIN
1068: --
1069: IF (l_debug <> -1) THEN
1070: rlm_core_sv.dpush(k_SDEBUG,'GetIntransitQty');
1071: --
1072: -- Call shipping API
1073: --
1074: rlm_core_sv.dlog(k_DEBUG,'x_CustomerId', x_CustomerId);
1070: rlm_core_sv.dpush(k_SDEBUG,'GetIntransitQty');
1071: --
1072: -- Call shipping API
1073: --
1074: rlm_core_sv.dlog(k_DEBUG,'x_CustomerId', x_CustomerId);
1075: rlm_core_sv.dlog(k_DEBUG,'x_ShipToId', x_ShipToId);
1076: rlm_core_sv.dlog(k_DEBUG,'x_intmed_ship_to_org_id', x_intmed_ship_to_org_id); --Bugfix 5911991
1077: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
1078: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
1071: --
1072: -- Call shipping API
1073: --
1074: rlm_core_sv.dlog(k_DEBUG,'x_CustomerId', x_CustomerId);
1075: rlm_core_sv.dlog(k_DEBUG,'x_ShipToId', x_ShipToId);
1076: rlm_core_sv.dlog(k_DEBUG,'x_intmed_ship_to_org_id', x_intmed_ship_to_org_id); --Bugfix 5911991
1077: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
1078: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
1079: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
1072: -- Call shipping API
1073: --
1074: rlm_core_sv.dlog(k_DEBUG,'x_CustomerId', x_CustomerId);
1075: rlm_core_sv.dlog(k_DEBUG,'x_ShipToId', x_ShipToId);
1076: rlm_core_sv.dlog(k_DEBUG,'x_intmed_ship_to_org_id', x_intmed_ship_to_org_id); --Bugfix 5911991
1077: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
1078: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
1079: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
1080: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
1073: --
1074: rlm_core_sv.dlog(k_DEBUG,'x_CustomerId', x_CustomerId);
1075: rlm_core_sv.dlog(k_DEBUG,'x_ShipToId', x_ShipToId);
1076: rlm_core_sv.dlog(k_DEBUG,'x_intmed_ship_to_org_id', x_intmed_ship_to_org_id); --Bugfix 5911991
1077: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
1078: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
1079: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
1080: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
1081: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);
1074: rlm_core_sv.dlog(k_DEBUG,'x_CustomerId', x_CustomerId);
1075: rlm_core_sv.dlog(k_DEBUG,'x_ShipToId', x_ShipToId);
1076: rlm_core_sv.dlog(k_DEBUG,'x_intmed_ship_to_org_id', x_intmed_ship_to_org_id); --Bugfix 5911991
1077: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
1078: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
1079: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
1080: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
1081: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);
1082: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1075: rlm_core_sv.dlog(k_DEBUG,'x_ShipToId', x_ShipToId);
1076: rlm_core_sv.dlog(k_DEBUG,'x_intmed_ship_to_org_id', x_intmed_ship_to_org_id); --Bugfix 5911991
1077: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
1078: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
1079: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
1080: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
1081: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);
1082: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1083: rlm_core_sv.dlog(k_DEBUG,'x_ShipmentDate', x_ShipmentDate);
1076: rlm_core_sv.dlog(k_DEBUG,'x_intmed_ship_to_org_id', x_intmed_ship_to_org_id); --Bugfix 5911991
1077: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
1078: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
1079: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
1080: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
1081: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);
1082: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1083: rlm_core_sv.dlog(k_DEBUG,'x_ShipmentDate', x_ShipmentDate);
1084: rlm_core_sv.dlog(k_DEBUG,'x_orgId', x_OrgId);
1077: rlm_core_sv.dlog(k_DEBUG,'x_ShipFromOrgId', x_ShipFromOrgId);
1078: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
1079: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
1080: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
1081: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);
1082: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1083: rlm_core_sv.dlog(k_DEBUG,'x_ShipmentDate', x_ShipmentDate);
1084: rlm_core_sv.dlog(k_DEBUG,'x_orgId', x_OrgId);
1085: END IF;
1078: rlm_core_sv.dlog(k_DEBUG,'x_InventoryItemId', x_InventoryItemId);
1079: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
1080: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
1081: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);
1082: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1083: rlm_core_sv.dlog(k_DEBUG,'x_ShipmentDate', x_ShipmentDate);
1084: rlm_core_sv.dlog(k_DEBUG,'x_orgId', x_OrgId);
1085: END IF;
1086: --
1079: rlm_core_sv.dlog(k_DEBUG,'x_CustomerItemId', x_CustomerItemId);
1080: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
1081: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);
1082: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1083: rlm_core_sv.dlog(k_DEBUG,'x_ShipmentDate', x_ShipmentDate);
1084: rlm_core_sv.dlog(k_DEBUG,'x_orgId', x_OrgId);
1085: END IF;
1086: --
1087: --global_atp
1080: rlm_core_sv.dlog(k_DEBUG,'x_OrderHeaderId', x_OrderHeaderId);
1081: rlm_core_sv.dlog(k_DEBUG,'x_BlanketNumber', x_BlanketNumber);
1082: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1083: rlm_core_sv.dlog(k_DEBUG,'x_ShipmentDate', x_ShipmentDate);
1084: rlm_core_sv.dlog(k_DEBUG,'x_orgId', x_OrgId);
1085: END IF;
1086: --
1087: --global_atp
1088:
1115: v_MatchWithin.schedule_date := 'N';
1116: v_MatchAcross.schedule_date := 'N';
1117: --
1118: IF (l_debug <> -1) THEN
1119: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute2', v_MatchWithin.industry_attribute2);
1120: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute2', v_MatchAcross.industry_attribute2);
1121: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute15', v_MatchWithin.industry_attribute15);
1122: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
1123: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);
1116: v_MatchAcross.schedule_date := 'N';
1117: --
1118: IF (l_debug <> -1) THEN
1119: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute2', v_MatchWithin.industry_attribute2);
1120: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute2', v_MatchAcross.industry_attribute2);
1121: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute15', v_MatchWithin.industry_attribute15);
1122: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
1123: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);
1124: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.request_date', v_MatchAcross.request_date);
1117: --
1118: IF (l_debug <> -1) THEN
1119: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute2', v_MatchWithin.industry_attribute2);
1120: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute2', v_MatchAcross.industry_attribute2);
1121: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute15', v_MatchWithin.industry_attribute15);
1122: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
1123: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);
1124: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.request_date', v_MatchAcross.request_date);
1125: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.schedule_date', v_MatchWithin.schedule_date);
1118: IF (l_debug <> -1) THEN
1119: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute2', v_MatchWithin.industry_attribute2);
1120: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute2', v_MatchAcross.industry_attribute2);
1121: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute15', v_MatchWithin.industry_attribute15);
1122: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
1123: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);
1124: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.request_date', v_MatchAcross.request_date);
1125: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.schedule_date', v_MatchWithin.schedule_date);
1126: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.schedule_date', v_MatchAcross.schedule_date);
1119: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute2', v_MatchWithin.industry_attribute2);
1120: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute2', v_MatchAcross.industry_attribute2);
1121: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute15', v_MatchWithin.industry_attribute15);
1122: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
1123: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);
1124: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.request_date', v_MatchAcross.request_date);
1125: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.schedule_date', v_MatchWithin.schedule_date);
1126: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.schedule_date', v_MatchAcross.schedule_date);
1127: END IF;
1120: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute2', v_MatchAcross.industry_attribute2);
1121: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute15', v_MatchWithin.industry_attribute15);
1122: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
1123: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);
1124: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.request_date', v_MatchAcross.request_date);
1125: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.schedule_date', v_MatchWithin.schedule_date);
1126: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.schedule_date', v_MatchAcross.schedule_date);
1127: END IF;
1128: --
1121: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.industry_attribute15', v_MatchWithin.industry_attribute15);
1122: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
1123: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);
1124: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.request_date', v_MatchAcross.request_date);
1125: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.schedule_date', v_MatchWithin.schedule_date);
1126: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.schedule_date', v_MatchAcross.schedule_date);
1127: END IF;
1128: --
1129: WSH_RLM_INTERFACE.Get_In_Transit_Qty(
1122: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.industry_attribute15', v_MatchAcross.industry_attribute15);
1123: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.request_date', v_MatchWithin.request_date);
1124: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.request_date', v_MatchAcross.request_date);
1125: rlm_core_sv.dlog(k_DEBUG,'v_MatchWithin.schedule_date', v_MatchWithin.schedule_date);
1126: rlm_core_sv.dlog(k_DEBUG,'v_MatchAcross.schedule_date', v_MatchAcross.schedule_date);
1127: END IF;
1128: --
1129: WSH_RLM_INTERFACE.Get_In_Transit_Qty(
1130: p_source_code => 'OE',
1156: --
1157: ELSE
1158: --
1159: IF (l_debug <> -1) THEN
1160: rlm_core_sv.dlog(k_DEBUG,'x_InTransitQty', x_InTransitQty);
1161: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1162: END IF;
1163: --
1164: END IF;
1157: ELSE
1158: --
1159: IF (l_debug <> -1) THEN
1160: rlm_core_sv.dlog(k_DEBUG,'x_InTransitQty', x_InTransitQty);
1161: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1162: END IF;
1163: --
1164: END IF;
1165: --
1163: --
1164: END IF;
1165: --
1166: IF (l_debug <> -1) THEN
1167: rlm_core_sv.dpop(k_SDEBUG);
1168: END IF;
1169: --
1170: EXCEPTION
1171: --
1174: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1175: WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1176: --
1177: IF (l_debug <> -1) THEN
1178: rlm_core_sv.dlog(k_DEBUG,'v_summary', v_summary );
1179: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );
1180: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1181: END IF;
1182: --
1175: WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1176: --
1177: IF (l_debug <> -1) THEN
1178: rlm_core_sv.dlog(k_DEBUG,'v_summary', v_summary );
1179: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );
1180: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1181: END IF;
1182: --
1183: rlm_message_sv.app_error(
1176: --
1177: IF (l_debug <> -1) THEN
1178: rlm_core_sv.dlog(k_DEBUG,'v_summary', v_summary );
1179: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );
1180: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1181: END IF;
1182: --
1183: rlm_message_sv.app_error(
1184: x_ExceptionLevel => rlm_message_sv.k_error_level,
1192: x_Token1 => 'ERROR',
1193: x_value1 => substr(v_summary,1,200));
1194: --
1195: IF (l_debug <> -1) THEN
1196: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1197: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: GetInstransitQty');
1198: END IF;
1199: --
1200: WHEN e_APIUnExpError THEN
1193: x_value1 => substr(v_summary,1,200));
1194: --
1195: IF (l_debug <> -1) THEN
1196: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1197: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: GetInstransitQty');
1198: END IF;
1199: --
1200: WHEN e_APIUnExpError THEN
1201: --
1203: --
1204: WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1205: --
1206: IF (l_debug <> -1) THEN
1207: rlm_core_sv.dlog(k_DEBUG,'v_summary', v_summary );
1208: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );
1209: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1210: END IF;
1211: --
1204: WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1205: --
1206: IF (l_debug <> -1) THEN
1207: rlm_core_sv.dlog(k_DEBUG,'v_summary', v_summary );
1208: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );
1209: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1210: END IF;
1211: --
1212: rlm_message_sv.app_error(
1205: --
1206: IF (l_debug <> -1) THEN
1207: rlm_core_sv.dlog(k_DEBUG,'v_summary', v_summary );
1208: rlm_core_sv.dlog(k_DEBUG,'v_details', v_details );
1209: rlm_core_sv.dlog(k_DEBUG,'v_get_msg_count', v_get_msg_count );
1210: END IF;
1211: --
1212: rlm_message_sv.app_error(
1213: x_ExceptionLevel => rlm_message_sv.k_error_level,
1221: x_Token1 => 'ERROR',
1222: x_value1 => substr(v_summary,1,200));
1223: --
1224: IF (l_debug <> -1) THEN
1225: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1226: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: GetInstransitQty');
1227: END IF;
1228: --
1229: WHEN OTHERS THEN
1222: x_value1 => substr(v_summary,1,200));
1223: --
1224: IF (l_debug <> -1) THEN
1225: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1226: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: GetInstransitQty');
1227: END IF;
1228: --
1229: WHEN OTHERS THEN
1230: --
1228: --
1229: WHEN OTHERS THEN
1230: --
1231: IF (l_debug <> -1) THEN
1232: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1233: END IF;
1234: --
1235: raise;
1236: --
1260:
1261: BEGIN
1262: --
1263: IF (l_debug <> -1) THEN
1264: rlm_core_sv.dpush(k_SDEBUG,'CheckShippingConstraints');
1265: --
1266: -- Call shipping API
1267: --
1268: rlm_core_sv.dlog(k_DEBUG,'x_source_code', x_source_code);
1264: rlm_core_sv.dpush(k_SDEBUG,'CheckShippingConstraints');
1265: --
1266: -- Call shipping API
1267: --
1268: rlm_core_sv.dlog(k_DEBUG,'x_source_code', x_source_code);
1269: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.source_line_id',x_changed_attributes.source_line_id);
1270: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.action_flag', x_changed_attributes.action_flag);
1271: rlm_core_sv.dlog(k_DEBUG,'x_log_level', x_log_level);
1272: rlm_core_sv.dlog(k_DEBUG,'x_header_id', x_header_id);
1265: --
1266: -- Call shipping API
1267: --
1268: rlm_core_sv.dlog(k_DEBUG,'x_source_code', x_source_code);
1269: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.source_line_id',x_changed_attributes.source_line_id);
1270: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.action_flag', x_changed_attributes.action_flag);
1271: rlm_core_sv.dlog(k_DEBUG,'x_log_level', x_log_level);
1272: rlm_core_sv.dlog(k_DEBUG,'x_header_id', x_header_id);
1273: rlm_core_sv.dlog(k_DEBUG,'x_order_header_id', x_order_header_id);
1266: -- Call shipping API
1267: --
1268: rlm_core_sv.dlog(k_DEBUG,'x_source_code', x_source_code);
1269: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.source_line_id',x_changed_attributes.source_line_id);
1270: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.action_flag', x_changed_attributes.action_flag);
1271: rlm_core_sv.dlog(k_DEBUG,'x_log_level', x_log_level);
1272: rlm_core_sv.dlog(k_DEBUG,'x_header_id', x_header_id);
1273: rlm_core_sv.dlog(k_DEBUG,'x_order_header_id', x_order_header_id);
1274: END IF;
1267: --
1268: rlm_core_sv.dlog(k_DEBUG,'x_source_code', x_source_code);
1269: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.source_line_id',x_changed_attributes.source_line_id);
1270: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.action_flag', x_changed_attributes.action_flag);
1271: rlm_core_sv.dlog(k_DEBUG,'x_log_level', x_log_level);
1272: rlm_core_sv.dlog(k_DEBUG,'x_header_id', x_header_id);
1273: rlm_core_sv.dlog(k_DEBUG,'x_order_header_id', x_order_header_id);
1274: END IF;
1275: --
1268: rlm_core_sv.dlog(k_DEBUG,'x_source_code', x_source_code);
1269: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.source_line_id',x_changed_attributes.source_line_id);
1270: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.action_flag', x_changed_attributes.action_flag);
1271: rlm_core_sv.dlog(k_DEBUG,'x_log_level', x_log_level);
1272: rlm_core_sv.dlog(k_DEBUG,'x_header_id', x_header_id);
1273: rlm_core_sv.dlog(k_DEBUG,'x_order_header_id', x_order_header_id);
1274: END IF;
1275: --
1276: WSH_SHIPPING_CONSTRAINTS_PKG.check_shipping_constraints(
1269: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.source_line_id',x_changed_attributes.source_line_id);
1270: rlm_core_sv.dlog(k_DEBUG,'x_changed_attributes.action_flag', x_changed_attributes.action_flag);
1271: rlm_core_sv.dlog(k_DEBUG,'x_log_level', x_log_level);
1272: rlm_core_sv.dlog(k_DEBUG,'x_header_id', x_header_id);
1273: rlm_core_sv.dlog(k_DEBUG,'x_order_header_id', x_order_header_id);
1274: END IF;
1275: --
1276: WSH_SHIPPING_CONSTRAINTS_PKG.check_shipping_constraints(
1277: p_source_code => x_source_code,
1292: --
1293: ELSE
1294: --
1295: IF (l_debug <> -1) THEN
1296: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1297: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1298: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1299: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1300: END IF;
1293: ELSE
1294: --
1295: IF (l_debug <> -1) THEN
1296: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1297: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1298: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1299: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1300: END IF;
1301: --
1294: --
1295: IF (l_debug <> -1) THEN
1296: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1297: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1298: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1299: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1300: END IF;
1301: --
1302: END IF;
1295: IF (l_debug <> -1) THEN
1296: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1297: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1298: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1299: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1300: END IF;
1301: --
1302: END IF;
1303: --
1301: --
1302: END IF;
1303: --
1304: IF (l_debug <> -1) THEN
1305: rlm_core_sv.dpop(k_SDEBUG);
1306: END IF;
1307: --
1308: EXCEPTION
1309: --
1313: --
1314: --WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1315: --
1316: IF (l_debug <> -1) THEN
1317: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1318: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1319: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1320: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1321: END IF;
1314: --WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1315: --
1316: IF (l_debug <> -1) THEN
1317: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1318: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1319: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1320: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1321: END IF;
1322: --
1315: --
1316: IF (l_debug <> -1) THEN
1317: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1318: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1319: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1320: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1321: END IF;
1322: --
1323: rlm_message_sv.app_error(
1316: IF (l_debug <> -1) THEN
1317: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1318: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1319: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1320: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1321: END IF;
1322: --
1323: rlm_message_sv.app_error(
1324: x_ExceptionLevel => rlm_message_sv.k_error_level,
1332: x_Token1 => 'ERROR',
1333: x_value1 => SUBSTR(SQLERRM,1,200));
1334: --
1335: IF (l_debug <> -1) THEN
1336: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1337: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: CallShippingConstraintsAPI');
1338: END IF;
1339: --
1340:
1333: x_value1 => SUBSTR(SQLERRM,1,200));
1334: --
1335: IF (l_debug <> -1) THEN
1336: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1337: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: CallShippingConstraintsAPI');
1338: END IF;
1339: --
1340:
1341: WHEN e_APIExpError THEN
1344: --
1345: --WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1346: --
1347: IF (l_debug <> -1) THEN
1348: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1349: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1350: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1351: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1352: END IF;
1345: --WSH_UTIL_CORE.Get_Messages('N',v_summary, v_details, v_get_msg_count);
1346: --
1347: IF (l_debug <> -1) THEN
1348: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1349: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1350: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1351: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1352: END IF;
1353: --
1346: --
1347: IF (l_debug <> -1) THEN
1348: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1349: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1350: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1351: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1352: END IF;
1353: --
1354: rlm_message_sv.app_error(
1347: IF (l_debug <> -1) THEN
1348: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1349: rlm_core_sv.dlog(k_DEBUG,'x_action_allowed', x_action_allowed);
1350: rlm_core_sv.dlog(k_DEBUG,'x_action_message', x_action_message);
1351: rlm_core_sv.dlog(k_DEBUG,'x_ord_qty_allowed', x_ord_qty_allowed);
1352: END IF;
1353: --
1354: rlm_message_sv.app_error(
1355: x_ExceptionLevel => rlm_message_sv.k_error_level,
1363: x_Token1 => 'ERROR',
1364: x_value1 => x_action_message);
1365: --
1366: IF (l_debug <> -1) THEN
1367: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1368: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: CallShippingConstraintsAPI');
1369: END IF;
1370: --
1371:
1364: x_value1 => x_action_message);
1365: --
1366: IF (l_debug <> -1) THEN
1367: rlm_core_sv.dlog(k_DEBUG,'x_return_status', x_return_status);
1368: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: CallShippingConstraintsAPI');
1369: END IF;
1370: --
1371:
1372: WHEN OTHERS THEN
1371:
1372: WHEN OTHERS THEN
1373: --
1374: IF (l_debug <> -1) THEN
1375: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1376: END IF;
1377: --
1378: RAISE;
1379: --
1429: IS
1430: BEGIN
1431: --
1432: IF (l_debug <> -1) THEN
1433: rlm_core_sv.dpush(k_SDEBUG,'BuildTPOELine');
1434: END IF;
1435: --
1436: x_oe_line_rec.tp_attribute1 := x_Op_rec.tp_attribute1;
1437: x_oe_line_rec.tp_attribute2 := x_Op_rec.tp_attribute2;
1450: x_oe_line_rec.tp_attribute15:= x_Op_rec.tp_attribute15;
1451: x_oe_line_rec.tp_context:= x_Op_rec.tp_attribute_category;
1452: --
1453: IF (l_debug <> -1) THEN
1454: rlm_core_sv.dlog(k_DEBUG,'tp_attribute1',
1455: x_Op_rec.tp_attribute1);
1456: rlm_core_sv.dlog(k_DEBUG,'tp_attribute2',
1457: x_Op_rec.tp_attribute2);
1458: rlm_core_sv.dlog(k_DEBUG,'tp_attribute3',
1452: --
1453: IF (l_debug <> -1) THEN
1454: rlm_core_sv.dlog(k_DEBUG,'tp_attribute1',
1455: x_Op_rec.tp_attribute1);
1456: rlm_core_sv.dlog(k_DEBUG,'tp_attribute2',
1457: x_Op_rec.tp_attribute2);
1458: rlm_core_sv.dlog(k_DEBUG,'tp_attribute3',
1459: x_Op_rec.tp_attribute3);
1460: rlm_core_sv.dlog(k_DEBUG,'tp_attribute4',
1454: rlm_core_sv.dlog(k_DEBUG,'tp_attribute1',
1455: x_Op_rec.tp_attribute1);
1456: rlm_core_sv.dlog(k_DEBUG,'tp_attribute2',
1457: x_Op_rec.tp_attribute2);
1458: rlm_core_sv.dlog(k_DEBUG,'tp_attribute3',
1459: x_Op_rec.tp_attribute3);
1460: rlm_core_sv.dlog(k_DEBUG,'tp_attribute4',
1461: x_Op_rec.tp_attribute4);
1462: rlm_core_sv.dlog(k_DEBUG,'tp_attribute5',
1456: rlm_core_sv.dlog(k_DEBUG,'tp_attribute2',
1457: x_Op_rec.tp_attribute2);
1458: rlm_core_sv.dlog(k_DEBUG,'tp_attribute3',
1459: x_Op_rec.tp_attribute3);
1460: rlm_core_sv.dlog(k_DEBUG,'tp_attribute4',
1461: x_Op_rec.tp_attribute4);
1462: rlm_core_sv.dlog(k_DEBUG,'tp_attribute5',
1463: x_Op_rec.tp_attribute5);
1464: rlm_core_sv.dlog(k_DEBUG,'tp_attribute6',
1458: rlm_core_sv.dlog(k_DEBUG,'tp_attribute3',
1459: x_Op_rec.tp_attribute3);
1460: rlm_core_sv.dlog(k_DEBUG,'tp_attribute4',
1461: x_Op_rec.tp_attribute4);
1462: rlm_core_sv.dlog(k_DEBUG,'tp_attribute5',
1463: x_Op_rec.tp_attribute5);
1464: rlm_core_sv.dlog(k_DEBUG,'tp_attribute6',
1465: x_Op_rec.tp_attribute6);
1466: rlm_core_sv.dlog(k_DEBUG,'tp_attribute7',
1460: rlm_core_sv.dlog(k_DEBUG,'tp_attribute4',
1461: x_Op_rec.tp_attribute4);
1462: rlm_core_sv.dlog(k_DEBUG,'tp_attribute5',
1463: x_Op_rec.tp_attribute5);
1464: rlm_core_sv.dlog(k_DEBUG,'tp_attribute6',
1465: x_Op_rec.tp_attribute6);
1466: rlm_core_sv.dlog(k_DEBUG,'tp_attribute7',
1467: x_Op_rec.tp_attribute7);
1468: rlm_core_sv.dlog(k_DEBUG,'tp_attribute8',
1462: rlm_core_sv.dlog(k_DEBUG,'tp_attribute5',
1463: x_Op_rec.tp_attribute5);
1464: rlm_core_sv.dlog(k_DEBUG,'tp_attribute6',
1465: x_Op_rec.tp_attribute6);
1466: rlm_core_sv.dlog(k_DEBUG,'tp_attribute7',
1467: x_Op_rec.tp_attribute7);
1468: rlm_core_sv.dlog(k_DEBUG,'tp_attribute8',
1469: x_Op_rec.tp_attribute8);
1470: rlm_core_sv.dlog(k_DEBUG,'tp_attribute9',
1464: rlm_core_sv.dlog(k_DEBUG,'tp_attribute6',
1465: x_Op_rec.tp_attribute6);
1466: rlm_core_sv.dlog(k_DEBUG,'tp_attribute7',
1467: x_Op_rec.tp_attribute7);
1468: rlm_core_sv.dlog(k_DEBUG,'tp_attribute8',
1469: x_Op_rec.tp_attribute8);
1470: rlm_core_sv.dlog(k_DEBUG,'tp_attribute9',
1471: x_Op_rec.tp_attribute9);
1472: rlm_core_sv.dlog(k_DEBUG,'tp_attribute10',
1466: rlm_core_sv.dlog(k_DEBUG,'tp_attribute7',
1467: x_Op_rec.tp_attribute7);
1468: rlm_core_sv.dlog(k_DEBUG,'tp_attribute8',
1469: x_Op_rec.tp_attribute8);
1470: rlm_core_sv.dlog(k_DEBUG,'tp_attribute9',
1471: x_Op_rec.tp_attribute9);
1472: rlm_core_sv.dlog(k_DEBUG,'tp_attribute10',
1473: x_Op_rec.tp_attribute10);
1474: rlm_core_sv.dlog(k_DEBUG,'tp_attribute11',
1468: rlm_core_sv.dlog(k_DEBUG,'tp_attribute8',
1469: x_Op_rec.tp_attribute8);
1470: rlm_core_sv.dlog(k_DEBUG,'tp_attribute9',
1471: x_Op_rec.tp_attribute9);
1472: rlm_core_sv.dlog(k_DEBUG,'tp_attribute10',
1473: x_Op_rec.tp_attribute10);
1474: rlm_core_sv.dlog(k_DEBUG,'tp_attribute11',
1475: x_Op_rec.tp_attribute11);
1476: rlm_core_sv.dlog(k_DEBUG,'tp_attribute12',
1470: rlm_core_sv.dlog(k_DEBUG,'tp_attribute9',
1471: x_Op_rec.tp_attribute9);
1472: rlm_core_sv.dlog(k_DEBUG,'tp_attribute10',
1473: x_Op_rec.tp_attribute10);
1474: rlm_core_sv.dlog(k_DEBUG,'tp_attribute11',
1475: x_Op_rec.tp_attribute11);
1476: rlm_core_sv.dlog(k_DEBUG,'tp_attribute12',
1477: x_Op_rec.tp_attribute12);
1478: rlm_core_sv.dlog(k_DEBUG,'tp_attribute13',
1472: rlm_core_sv.dlog(k_DEBUG,'tp_attribute10',
1473: x_Op_rec.tp_attribute10);
1474: rlm_core_sv.dlog(k_DEBUG,'tp_attribute11',
1475: x_Op_rec.tp_attribute11);
1476: rlm_core_sv.dlog(k_DEBUG,'tp_attribute12',
1477: x_Op_rec.tp_attribute12);
1478: rlm_core_sv.dlog(k_DEBUG,'tp_attribute13',
1479: x_Op_rec.tp_attribute13);
1480: rlm_core_sv.dlog(k_DEBUG,'tp_attribute14',
1474: rlm_core_sv.dlog(k_DEBUG,'tp_attribute11',
1475: x_Op_rec.tp_attribute11);
1476: rlm_core_sv.dlog(k_DEBUG,'tp_attribute12',
1477: x_Op_rec.tp_attribute12);
1478: rlm_core_sv.dlog(k_DEBUG,'tp_attribute13',
1479: x_Op_rec.tp_attribute13);
1480: rlm_core_sv.dlog(k_DEBUG,'tp_attribute14',
1481: x_Op_rec.tp_attribute14);
1482: rlm_core_sv.dlog(k_DEBUG,'tp_attribute15',
1476: rlm_core_sv.dlog(k_DEBUG,'tp_attribute12',
1477: x_Op_rec.tp_attribute12);
1478: rlm_core_sv.dlog(k_DEBUG,'tp_attribute13',
1479: x_Op_rec.tp_attribute13);
1480: rlm_core_sv.dlog(k_DEBUG,'tp_attribute14',
1481: x_Op_rec.tp_attribute14);
1482: rlm_core_sv.dlog(k_DEBUG,'tp_attribute15',
1483: x_Op_rec.tp_attribute15);
1484: rlm_core_sv.dlog(k_DEBUG,'tp_context',
1478: rlm_core_sv.dlog(k_DEBUG,'tp_attribute13',
1479: x_Op_rec.tp_attribute13);
1480: rlm_core_sv.dlog(k_DEBUG,'tp_attribute14',
1481: x_Op_rec.tp_attribute14);
1482: rlm_core_sv.dlog(k_DEBUG,'tp_attribute15',
1483: x_Op_rec.tp_attribute15);
1484: rlm_core_sv.dlog(k_DEBUG,'tp_context',
1485: x_Op_rec.tp_attribute_category);
1486: rlm_core_sv.dpop(k_SDEBUG);
1480: rlm_core_sv.dlog(k_DEBUG,'tp_attribute14',
1481: x_Op_rec.tp_attribute14);
1482: rlm_core_sv.dlog(k_DEBUG,'tp_attribute15',
1483: x_Op_rec.tp_attribute15);
1484: rlm_core_sv.dlog(k_DEBUG,'tp_context',
1485: x_Op_rec.tp_attribute_category);
1486: rlm_core_sv.dpop(k_SDEBUG);
1487: END IF;
1488: --
1482: rlm_core_sv.dlog(k_DEBUG,'tp_attribute15',
1483: x_Op_rec.tp_attribute15);
1484: rlm_core_sv.dlog(k_DEBUG,'tp_context',
1485: x_Op_rec.tp_attribute_category);
1486: rlm_core_sv.dpop(k_SDEBUG);
1487: END IF;
1488: --
1489: EXCEPTION
1490: WHEN OTHERS THEN
1489: EXCEPTION
1490: WHEN OTHERS THEN
1491: --
1492: IF (l_debug <> -1) THEN
1493: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1494: END IF;
1495: --
1496: raise;
1497:
1508: b_ATP BOOLEAN;
1509: BEGIN
1510: --
1511: IF (l_debug <> -1) THEN
1512: rlm_core_sv.dpush(k_SDEBUG,'BuildOELine');
1513: END IF;
1514: --
1515: -- Added by JAUTOMO 11/02/00 Bug# 1467525
1516: -- Added by JAUTOMO 11/08/01 Bug# 2096968
1539: x_oe_line_rec.header_id := x_Op_rec.order_header_id;
1540: x_oe_line_rec.line_id := x_Op_rec.line_id;
1541: --
1542: IF (l_debug <> -1) THEN
1543: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1544: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',x_oe_line_rec.ordered_quantity);
1545: rlm_core_sv.dlog(k_DEBUG,'line_id ',x_oe_line_rec.line_id);
1546: END IF;
1547: --
1540: x_oe_line_rec.line_id := x_Op_rec.line_id;
1541: --
1542: IF (l_debug <> -1) THEN
1543: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1544: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',x_oe_line_rec.ordered_quantity);
1545: rlm_core_sv.dlog(k_DEBUG,'line_id ',x_oe_line_rec.line_id);
1546: END IF;
1547: --
1548: ELSE
1541: --
1542: IF (l_debug <> -1) THEN
1543: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1544: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',x_oe_line_rec.ordered_quantity);
1545: rlm_core_sv.dlog(k_DEBUG,'line_id ',x_oe_line_rec.line_id);
1546: END IF;
1547: --
1548: ELSE
1549: --
1572: END IF;
1573: --
1574: --
1575: IF (l_debug <> -1) THEN
1576: rlm_core_sv.dlog(k_DEBUG,'b_ATP', b_ATP);
1577: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1578: x_oe_line_rec.schedule_ship_date);
1579: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1580: x_oe_line_rec.ship_from_org_id);
1573: --
1574: --
1575: IF (l_debug <> -1) THEN
1576: rlm_core_sv.dlog(k_DEBUG,'b_ATP', b_ATP);
1577: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1578: x_oe_line_rec.schedule_ship_date);
1579: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1580: x_oe_line_rec.ship_from_org_id);
1581: rlm_core_sv.dlog(k_DEBUG,'schedule_action_code',
1575: IF (l_debug <> -1) THEN
1576: rlm_core_sv.dlog(k_DEBUG,'b_ATP', b_ATP);
1577: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1578: x_oe_line_rec.schedule_ship_date);
1579: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1580: x_oe_line_rec.ship_from_org_id);
1581: rlm_core_sv.dlog(k_DEBUG,'schedule_action_code',
1582: x_oe_line_rec.schedule_action_code);
1583: END IF;
1577: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1578: x_oe_line_rec.schedule_ship_date);
1579: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1580: x_oe_line_rec.ship_from_org_id);
1581: rlm_core_sv.dlog(k_DEBUG,'schedule_action_code',
1582: x_oe_line_rec.schedule_action_code);
1583: END IF;
1584: --
1585: --
1772: END IF;
1773: --
1774: --x_oe_line_rec.item_type_code := fnd_api.g_miss_char;
1775: IF (l_debug <> -1) THEN
1776: rlm_core_sv.dlog(k_DEBUG,'customer_item_revision', x_Op_rec.customer_item_revision);
1777: END IF;
1778: --
1779: IF x_Op_rec.customer_item_revision IS NOT NULL THEN
1780: x_oe_line_rec.item_revision := x_Op_rec.customer_item_revision;
1859: --
1860: x_oe_line_rec.org_id := MO_GLOBAL.get_current_org_id;
1861: --
1862: IF (l_debug <> -1) THEN
1863: rlm_core_sv.dlog(k_DEBUG,'created_by',x_oe_line_rec.created_by ); --Bugfix 9223338
1864: rlm_core_sv.dlog(k_DEBUG,'creation_date',x_oe_line_rec.creation_date); --Bugfix 9223338
1865: rlm_core_sv.dlog(k_DEBUG,'last_updated_by',x_oe_line_rec.last_updated_by ); --Bugfix 9223338
1866: rlm_core_sv.dlog(k_DEBUG,'last_update_date',x_oe_line_rec.last_update_date); --Bugfix 9223338
1867: rlm_core_sv.dlog(k_DEBUG,'cust_dock_code',x_oe_line_rec.customer_dock_code);
1860: x_oe_line_rec.org_id := MO_GLOBAL.get_current_org_id;
1861: --
1862: IF (l_debug <> -1) THEN
1863: rlm_core_sv.dlog(k_DEBUG,'created_by',x_oe_line_rec.created_by ); --Bugfix 9223338
1864: rlm_core_sv.dlog(k_DEBUG,'creation_date',x_oe_line_rec.creation_date); --Bugfix 9223338
1865: rlm_core_sv.dlog(k_DEBUG,'last_updated_by',x_oe_line_rec.last_updated_by ); --Bugfix 9223338
1866: rlm_core_sv.dlog(k_DEBUG,'last_update_date',x_oe_line_rec.last_update_date); --Bugfix 9223338
1867: rlm_core_sv.dlog(k_DEBUG,'cust_dock_code',x_oe_line_rec.customer_dock_code);
1868: rlm_core_sv.dlog(k_DEBUG,'Customer job', x_oe_line_rec.customer_job);
1861: --
1862: IF (l_debug <> -1) THEN
1863: rlm_core_sv.dlog(k_DEBUG,'created_by',x_oe_line_rec.created_by ); --Bugfix 9223338
1864: rlm_core_sv.dlog(k_DEBUG,'creation_date',x_oe_line_rec.creation_date); --Bugfix 9223338
1865: rlm_core_sv.dlog(k_DEBUG,'last_updated_by',x_oe_line_rec.last_updated_by ); --Bugfix 9223338
1866: rlm_core_sv.dlog(k_DEBUG,'last_update_date',x_oe_line_rec.last_update_date); --Bugfix 9223338
1867: rlm_core_sv.dlog(k_DEBUG,'cust_dock_code',x_oe_line_rec.customer_dock_code);
1868: rlm_core_sv.dlog(k_DEBUG,'Customer job', x_oe_line_rec.customer_job);
1869: rlm_core_sv.dlog(k_DEBUG,'delivery_lead_time',
1862: IF (l_debug <> -1) THEN
1863: rlm_core_sv.dlog(k_DEBUG,'created_by',x_oe_line_rec.created_by ); --Bugfix 9223338
1864: rlm_core_sv.dlog(k_DEBUG,'creation_date',x_oe_line_rec.creation_date); --Bugfix 9223338
1865: rlm_core_sv.dlog(k_DEBUG,'last_updated_by',x_oe_line_rec.last_updated_by ); --Bugfix 9223338
1866: rlm_core_sv.dlog(k_DEBUG,'last_update_date',x_oe_line_rec.last_update_date); --Bugfix 9223338
1867: rlm_core_sv.dlog(k_DEBUG,'cust_dock_code',x_oe_line_rec.customer_dock_code);
1868: rlm_core_sv.dlog(k_DEBUG,'Customer job', x_oe_line_rec.customer_job);
1869: rlm_core_sv.dlog(k_DEBUG,'delivery_lead_time',
1870: x_oe_line_rec.delivery_lead_time);
1863: rlm_core_sv.dlog(k_DEBUG,'created_by',x_oe_line_rec.created_by ); --Bugfix 9223338
1864: rlm_core_sv.dlog(k_DEBUG,'creation_date',x_oe_line_rec.creation_date); --Bugfix 9223338
1865: rlm_core_sv.dlog(k_DEBUG,'last_updated_by',x_oe_line_rec.last_updated_by ); --Bugfix 9223338
1866: rlm_core_sv.dlog(k_DEBUG,'last_update_date',x_oe_line_rec.last_update_date); --Bugfix 9223338
1867: rlm_core_sv.dlog(k_DEBUG,'cust_dock_code',x_oe_line_rec.customer_dock_code);
1868: rlm_core_sv.dlog(k_DEBUG,'Customer job', x_oe_line_rec.customer_job);
1869: rlm_core_sv.dlog(k_DEBUG,'delivery_lead_time',
1870: x_oe_line_rec.delivery_lead_time);
1871: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',
1864: rlm_core_sv.dlog(k_DEBUG,'creation_date',x_oe_line_rec.creation_date); --Bugfix 9223338
1865: rlm_core_sv.dlog(k_DEBUG,'last_updated_by',x_oe_line_rec.last_updated_by ); --Bugfix 9223338
1866: rlm_core_sv.dlog(k_DEBUG,'last_update_date',x_oe_line_rec.last_update_date); --Bugfix 9223338
1867: rlm_core_sv.dlog(k_DEBUG,'cust_dock_code',x_oe_line_rec.customer_dock_code);
1868: rlm_core_sv.dlog(k_DEBUG,'Customer job', x_oe_line_rec.customer_job);
1869: rlm_core_sv.dlog(k_DEBUG,'delivery_lead_time',
1870: x_oe_line_rec.delivery_lead_time);
1871: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',
1872: x_oe_line_rec.ordered_quantity);
1865: rlm_core_sv.dlog(k_DEBUG,'last_updated_by',x_oe_line_rec.last_updated_by ); --Bugfix 9223338
1866: rlm_core_sv.dlog(k_DEBUG,'last_update_date',x_oe_line_rec.last_update_date); --Bugfix 9223338
1867: rlm_core_sv.dlog(k_DEBUG,'cust_dock_code',x_oe_line_rec.customer_dock_code);
1868: rlm_core_sv.dlog(k_DEBUG,'Customer job', x_oe_line_rec.customer_job);
1869: rlm_core_sv.dlog(k_DEBUG,'delivery_lead_time',
1870: x_oe_line_rec.delivery_lead_time);
1871: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',
1872: x_oe_line_rec.ordered_quantity);
1873: rlm_core_sv.dlog(k_DEBUG,'uom_code',
1867: rlm_core_sv.dlog(k_DEBUG,'cust_dock_code',x_oe_line_rec.customer_dock_code);
1868: rlm_core_sv.dlog(k_DEBUG,'Customer job', x_oe_line_rec.customer_job);
1869: rlm_core_sv.dlog(k_DEBUG,'delivery_lead_time',
1870: x_oe_line_rec.delivery_lead_time);
1871: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',
1872: x_oe_line_rec.ordered_quantity);
1873: rlm_core_sv.dlog(k_DEBUG,'uom_code',
1874: x_Op_rec.uom_code);
1875: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1869: rlm_core_sv.dlog(k_DEBUG,'delivery_lead_time',
1870: x_oe_line_rec.delivery_lead_time);
1871: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',
1872: x_oe_line_rec.ordered_quantity);
1873: rlm_core_sv.dlog(k_DEBUG,'uom_code',
1874: x_Op_rec.uom_code);
1875: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1876: rlm_core_sv.dlog(k_DEBUG,'change_reason ',x_oe_line_rec.change_reason);
1877: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);
1871: rlm_core_sv.dlog(k_DEBUG,'ordered_quantity ',
1872: x_oe_line_rec.ordered_quantity);
1873: rlm_core_sv.dlog(k_DEBUG,'uom_code',
1874: x_Op_rec.uom_code);
1875: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1876: rlm_core_sv.dlog(k_DEBUG,'change_reason ',x_oe_line_rec.change_reason);
1877: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);
1878: rlm_core_sv.dlog(k_DEBUG,'request_date',x_oe_line_rec.request_date);
1879: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);
1872: x_oe_line_rec.ordered_quantity);
1873: rlm_core_sv.dlog(k_DEBUG,'uom_code',
1874: x_Op_rec.uom_code);
1875: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1876: rlm_core_sv.dlog(k_DEBUG,'change_reason ',x_oe_line_rec.change_reason);
1877: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);
1878: rlm_core_sv.dlog(k_DEBUG,'request_date',x_oe_line_rec.request_date);
1879: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);
1880: rlm_core_sv.dlog(k_DEBUG,'intmed_ship_to_org_id',x_oe_line_rec.intermed_ship_to_org_id);
1873: rlm_core_sv.dlog(k_DEBUG,'uom_code',
1874: x_Op_rec.uom_code);
1875: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1876: rlm_core_sv.dlog(k_DEBUG,'change_reason ',x_oe_line_rec.change_reason);
1877: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);
1878: rlm_core_sv.dlog(k_DEBUG,'request_date',x_oe_line_rec.request_date);
1879: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);
1880: rlm_core_sv.dlog(k_DEBUG,'intmed_ship_to_org_id',x_oe_line_rec.intermed_ship_to_org_id);
1881: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1874: x_Op_rec.uom_code);
1875: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1876: rlm_core_sv.dlog(k_DEBUG,'change_reason ',x_oe_line_rec.change_reason);
1877: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);
1878: rlm_core_sv.dlog(k_DEBUG,'request_date',x_oe_line_rec.request_date);
1879: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);
1880: rlm_core_sv.dlog(k_DEBUG,'intmed_ship_to_org_id',x_oe_line_rec.intermed_ship_to_org_id);
1881: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1882: x_oe_line_rec.schedule_ship_date);
1875: rlm_core_sv.dlog(k_DEBUG,'operation ',x_oe_line_rec.operation);
1876: rlm_core_sv.dlog(k_DEBUG,'change_reason ',x_oe_line_rec.change_reason);
1877: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);
1878: rlm_core_sv.dlog(k_DEBUG,'request_date',x_oe_line_rec.request_date);
1879: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);
1880: rlm_core_sv.dlog(k_DEBUG,'intmed_ship_to_org_id',x_oe_line_rec.intermed_ship_to_org_id);
1881: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1882: x_oe_line_rec.schedule_ship_date);
1883: rlm_core_sv.dlog(k_DEBUG,'deliver_to_org_id',
1876: rlm_core_sv.dlog(k_DEBUG,'change_reason ',x_oe_line_rec.change_reason);
1877: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);
1878: rlm_core_sv.dlog(k_DEBUG,'request_date',x_oe_line_rec.request_date);
1879: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);
1880: rlm_core_sv.dlog(k_DEBUG,'intmed_ship_to_org_id',x_oe_line_rec.intermed_ship_to_org_id);
1881: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1882: x_oe_line_rec.schedule_ship_date);
1883: rlm_core_sv.dlog(k_DEBUG,'deliver_to_org_id',
1884: x_oe_line_rec.deliver_to_org_id);
1877: rlm_core_sv.dlog(k_DEBUG,'pricing_date',x_oe_line_rec.pricing_date);
1878: rlm_core_sv.dlog(k_DEBUG,'request_date',x_oe_line_rec.request_date);
1879: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);
1880: rlm_core_sv.dlog(k_DEBUG,'intmed_ship_to_org_id',x_oe_line_rec.intermed_ship_to_org_id);
1881: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1882: x_oe_line_rec.schedule_ship_date);
1883: rlm_core_sv.dlog(k_DEBUG,'deliver_to_org_id',
1884: x_oe_line_rec.deliver_to_org_id);
1885: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1879: rlm_core_sv.dlog(k_DEBUG,'promise_date',x_oe_line_rec.promise_date);
1880: rlm_core_sv.dlog(k_DEBUG,'intmed_ship_to_org_id',x_oe_line_rec.intermed_ship_to_org_id);
1881: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1882: x_oe_line_rec.schedule_ship_date);
1883: rlm_core_sv.dlog(k_DEBUG,'deliver_to_org_id',
1884: x_oe_line_rec.deliver_to_org_id);
1885: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1886: x_oe_line_rec.ship_from_org_id);
1887: rlm_core_sv.dlog(k_DEBUG,'ship_to_org_id',
1881: rlm_core_sv.dlog(k_DEBUG,'schedule_date',
1882: x_oe_line_rec.schedule_ship_date);
1883: rlm_core_sv.dlog(k_DEBUG,'deliver_to_org_id',
1884: x_oe_line_rec.deliver_to_org_id);
1885: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1886: x_oe_line_rec.ship_from_org_id);
1887: rlm_core_sv.dlog(k_DEBUG,'ship_to_org_id',
1888: x_oe_line_rec.ship_to_org_id);
1889: rlm_core_sv.dlog(k_DEBUG,'invoice to org id ',
1883: rlm_core_sv.dlog(k_DEBUG,'deliver_to_org_id',
1884: x_oe_line_rec.deliver_to_org_id);
1885: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1886: x_oe_line_rec.ship_from_org_id);
1887: rlm_core_sv.dlog(k_DEBUG,'ship_to_org_id',
1888: x_oe_line_rec.ship_to_org_id);
1889: rlm_core_sv.dlog(k_DEBUG,'invoice to org id ',
1890: x_oe_line_rec.invoice_to_org_id);
1891: rlm_core_sv.dlog(k_DEBUG,'authorized_to_ship_flag',
1885: rlm_core_sv.dlog(k_DEBUG,'ship_from_org_id',
1886: x_oe_line_rec.ship_from_org_id);
1887: rlm_core_sv.dlog(k_DEBUG,'ship_to_org_id',
1888: x_oe_line_rec.ship_to_org_id);
1889: rlm_core_sv.dlog(k_DEBUG,'invoice to org id ',
1890: x_oe_line_rec.invoice_to_org_id);
1891: rlm_core_sv.dlog(k_DEBUG,'authorized_to_ship_flag',
1892: x_oe_line_rec.authorized_to_ship_flag);
1893: rlm_core_sv.dlog(k_DEBUG,'Header ID',x_oe_line_rec.header_id);
1887: rlm_core_sv.dlog(k_DEBUG,'ship_to_org_id',
1888: x_oe_line_rec.ship_to_org_id);
1889: rlm_core_sv.dlog(k_DEBUG,'invoice to org id ',
1890: x_oe_line_rec.invoice_to_org_id);
1891: rlm_core_sv.dlog(k_DEBUG,'authorized_to_ship_flag',
1892: x_oe_line_rec.authorized_to_ship_flag);
1893: rlm_core_sv.dlog(k_DEBUG,'Header ID',x_oe_line_rec.header_id);
1894: rlm_core_sv.dlog(k_DEBUG,'Inventory_item_id',
1895: x_oe_line_rec.inventory_item_id);
1889: rlm_core_sv.dlog(k_DEBUG,'invoice to org id ',
1890: x_oe_line_rec.invoice_to_org_id);
1891: rlm_core_sv.dlog(k_DEBUG,'authorized_to_ship_flag',
1892: x_oe_line_rec.authorized_to_ship_flag);
1893: rlm_core_sv.dlog(k_DEBUG,'Header ID',x_oe_line_rec.header_id);
1894: rlm_core_sv.dlog(k_DEBUG,'Inventory_item_id',
1895: x_oe_line_rec.inventory_item_id);
1896: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type ',
1897: x_oe_line_rec.item_identifier_type);
1890: x_oe_line_rec.invoice_to_org_id);
1891: rlm_core_sv.dlog(k_DEBUG,'authorized_to_ship_flag',
1892: x_oe_line_rec.authorized_to_ship_flag);
1893: rlm_core_sv.dlog(k_DEBUG,'Header ID',x_oe_line_rec.header_id);
1894: rlm_core_sv.dlog(k_DEBUG,'Inventory_item_id',
1895: x_oe_line_rec.inventory_item_id);
1896: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type ',
1897: x_oe_line_rec.item_identifier_type);
1898: rlm_core_sv.dlog(k_DEBUG,'ordered_item_id ',
1892: x_oe_line_rec.authorized_to_ship_flag);
1893: rlm_core_sv.dlog(k_DEBUG,'Header ID',x_oe_line_rec.header_id);
1894: rlm_core_sv.dlog(k_DEBUG,'Inventory_item_id',
1895: x_oe_line_rec.inventory_item_id);
1896: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type ',
1897: x_oe_line_rec.item_identifier_type);
1898: rlm_core_sv.dlog(k_DEBUG,'ordered_item_id ',
1899: x_oe_line_rec.ordered_item_id);
1900: rlm_core_sv.dlog(k_DEBUG,'ordered_item',
1894: rlm_core_sv.dlog(k_DEBUG,'Inventory_item_id',
1895: x_oe_line_rec.inventory_item_id);
1896: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type ',
1897: x_oe_line_rec.item_identifier_type);
1898: rlm_core_sv.dlog(k_DEBUG,'ordered_item_id ',
1899: x_oe_line_rec.ordered_item_id);
1900: rlm_core_sv.dlog(k_DEBUG,'ordered_item',
1901: x_oe_line_rec.ordered_item);
1902: rlm_core_sv.dlog(k_DEBUG,'item_detail_type',
1896: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type ',
1897: x_oe_line_rec.item_identifier_type);
1898: rlm_core_sv.dlog(k_DEBUG,'ordered_item_id ',
1899: x_oe_line_rec.ordered_item_id);
1900: rlm_core_sv.dlog(k_DEBUG,'ordered_item',
1901: x_oe_line_rec.ordered_item);
1902: rlm_core_sv.dlog(k_DEBUG,'item_detail_type',
1903: x_oe_line_rec.item_type_code);
1904: rlm_core_sv.dlog(k_DEBUG,'line_id ',
1898: rlm_core_sv.dlog(k_DEBUG,'ordered_item_id ',
1899: x_oe_line_rec.ordered_item_id);
1900: rlm_core_sv.dlog(k_DEBUG,'ordered_item',
1901: x_oe_line_rec.ordered_item);
1902: rlm_core_sv.dlog(k_DEBUG,'item_detail_type',
1903: x_oe_line_rec.item_type_code);
1904: rlm_core_sv.dlog(k_DEBUG,'line_id ',
1905: x_oe_line_rec.line_id);
1906: rlm_core_sv.dlog(k_DEBUG,'agreement_id ',
1900: rlm_core_sv.dlog(k_DEBUG,'ordered_item',
1901: x_oe_line_rec.ordered_item);
1902: rlm_core_sv.dlog(k_DEBUG,'item_detail_type',
1903: x_oe_line_rec.item_type_code);
1904: rlm_core_sv.dlog(k_DEBUG,'line_id ',
1905: x_oe_line_rec.line_id);
1906: rlm_core_sv.dlog(k_DEBUG,'agreement_id ',
1907: x_oe_line_rec.agreement_id);
1908: rlm_core_sv.dlog(k_DEBUG,'price_list_id ',
1902: rlm_core_sv.dlog(k_DEBUG,'item_detail_type',
1903: x_oe_line_rec.item_type_code);
1904: rlm_core_sv.dlog(k_DEBUG,'line_id ',
1905: x_oe_line_rec.line_id);
1906: rlm_core_sv.dlog(k_DEBUG,'agreement_id ',
1907: x_oe_line_rec.agreement_id);
1908: rlm_core_sv.dlog(k_DEBUG,'price_list_id ',
1909: x_oe_line_rec.price_list_id);
1910: rlm_core_sv.dlog(k_DEBUG,'sold_to_org_id ',
1904: rlm_core_sv.dlog(k_DEBUG,'line_id ',
1905: x_oe_line_rec.line_id);
1906: rlm_core_sv.dlog(k_DEBUG,'agreement_id ',
1907: x_oe_line_rec.agreement_id);
1908: rlm_core_sv.dlog(k_DEBUG,'price_list_id ',
1909: x_oe_line_rec.price_list_id);
1910: rlm_core_sv.dlog(k_DEBUG,'sold_to_org_id ',
1911: x_oe_line_rec.sold_to_org_id);
1912: rlm_core_sv.dlog(k_DEBUG,'source_document_line_id ',
1906: rlm_core_sv.dlog(k_DEBUG,'agreement_id ',
1907: x_oe_line_rec.agreement_id);
1908: rlm_core_sv.dlog(k_DEBUG,'price_list_id ',
1909: x_oe_line_rec.price_list_id);
1910: rlm_core_sv.dlog(k_DEBUG,'sold_to_org_id ',
1911: x_oe_line_rec.sold_to_org_id);
1912: rlm_core_sv.dlog(k_DEBUG,'source_document_line_id ',
1913: x_oe_line_rec.source_document_line_id);
1914: rlm_core_sv.dlog(k_DEBUG,'source_document_id ',
1908: rlm_core_sv.dlog(k_DEBUG,'price_list_id ',
1909: x_oe_line_rec.price_list_id);
1910: rlm_core_sv.dlog(k_DEBUG,'sold_to_org_id ',
1911: x_oe_line_rec.sold_to_org_id);
1912: rlm_core_sv.dlog(k_DEBUG,'source_document_line_id ',
1913: x_oe_line_rec.source_document_line_id);
1914: rlm_core_sv.dlog(k_DEBUG,'source_document_id ',
1915: x_oe_line_rec.source_document_id);
1916: rlm_core_sv.dlog(k_DEBUG,'source_document_type_id ',
1910: rlm_core_sv.dlog(k_DEBUG,'sold_to_org_id ',
1911: x_oe_line_rec.sold_to_org_id);
1912: rlm_core_sv.dlog(k_DEBUG,'source_document_line_id ',
1913: x_oe_line_rec.source_document_line_id);
1914: rlm_core_sv.dlog(k_DEBUG,'source_document_id ',
1915: x_oe_line_rec.source_document_id);
1916: rlm_core_sv.dlog(k_DEBUG,'source_document_type_id ',
1917: x_oe_line_rec.source_document_type_id);
1918: rlm_core_sv.dlog(k_DEBUG,'PO Line number ',
1912: rlm_core_sv.dlog(k_DEBUG,'source_document_line_id ',
1913: x_oe_line_rec.source_document_line_id);
1914: rlm_core_sv.dlog(k_DEBUG,'source_document_id ',
1915: x_oe_line_rec.source_document_id);
1916: rlm_core_sv.dlog(k_DEBUG,'source_document_type_id ',
1917: x_oe_line_rec.source_document_type_id);
1918: rlm_core_sv.dlog(k_DEBUG,'PO Line number ',
1919: x_oe_line_rec.customer_line_number);
1920: rlm_core_sv.dlog(k_DEBUG,'customer_production_line', x_oe_line_rec.customer_production_line);
1914: rlm_core_sv.dlog(k_DEBUG,'source_document_id ',
1915: x_oe_line_rec.source_document_id);
1916: rlm_core_sv.dlog(k_DEBUG,'source_document_type_id ',
1917: x_oe_line_rec.source_document_type_id);
1918: rlm_core_sv.dlog(k_DEBUG,'PO Line number ',
1919: x_oe_line_rec.customer_line_number);
1920: rlm_core_sv.dlog(k_DEBUG,'customer_production_line', x_oe_line_rec.customer_production_line);
1921: rlm_core_sv.dlog(k_DEBUG,'cust_model_serial_number', x_oe_line_rec.cust_model_serial_number);
1922: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);
1916: rlm_core_sv.dlog(k_DEBUG,'source_document_type_id ',
1917: x_oe_line_rec.source_document_type_id);
1918: rlm_core_sv.dlog(k_DEBUG,'PO Line number ',
1919: x_oe_line_rec.customer_line_number);
1920: rlm_core_sv.dlog(k_DEBUG,'customer_production_line', x_oe_line_rec.customer_production_line);
1921: rlm_core_sv.dlog(k_DEBUG,'cust_model_serial_number', x_oe_line_rec.cust_model_serial_number);
1922: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);
1923: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1924: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1917: x_oe_line_rec.source_document_type_id);
1918: rlm_core_sv.dlog(k_DEBUG,'PO Line number ',
1919: x_oe_line_rec.customer_line_number);
1920: rlm_core_sv.dlog(k_DEBUG,'customer_production_line', x_oe_line_rec.customer_production_line);
1921: rlm_core_sv.dlog(k_DEBUG,'cust_model_serial_number', x_oe_line_rec.cust_model_serial_number);
1922: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);
1923: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1924: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1925: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1918: rlm_core_sv.dlog(k_DEBUG,'PO Line number ',
1919: x_oe_line_rec.customer_line_number);
1920: rlm_core_sv.dlog(k_DEBUG,'customer_production_line', x_oe_line_rec.customer_production_line);
1921: rlm_core_sv.dlog(k_DEBUG,'cust_model_serial_number', x_oe_line_rec.cust_model_serial_number);
1922: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);
1923: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1924: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1925: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1926: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1919: x_oe_line_rec.customer_line_number);
1920: rlm_core_sv.dlog(k_DEBUG,'customer_production_line', x_oe_line_rec.customer_production_line);
1921: rlm_core_sv.dlog(k_DEBUG,'cust_model_serial_number', x_oe_line_rec.cust_model_serial_number);
1922: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);
1923: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1924: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1925: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1926: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1927: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1920: rlm_core_sv.dlog(k_DEBUG,'customer_production_line', x_oe_line_rec.customer_production_line);
1921: rlm_core_sv.dlog(k_DEBUG,'cust_model_serial_number', x_oe_line_rec.cust_model_serial_number);
1922: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);
1923: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1924: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1925: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1926: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1927: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1928: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1921: rlm_core_sv.dlog(k_DEBUG,'cust_model_serial_number', x_oe_line_rec.cust_model_serial_number);
1922: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);
1923: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1924: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1925: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1926: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1927: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1928: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1929: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1922: rlm_core_sv.dlog(k_DEBUG,'cust_po_number', x_oe_line_rec.cust_po_number);
1923: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1924: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1925: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1926: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1927: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1928: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1929: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1930: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1923: rlm_core_sv.dlog(k_DEBUG,'demand_bucket_type_code', x_oe_line_rec.demand_bucket_type_code);
1924: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1925: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1926: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1927: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1928: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1929: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1930: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1931: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1924: rlm_core_sv.dlog(k_DEBUG,'cust_production_seq_num', x_oe_line_rec.cust_production_seq_num);
1925: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1926: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1927: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1928: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1929: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1930: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1931: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1932: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1925: rlm_core_sv.dlog(k_DEBUG,'item_identifier_type', x_oe_line_rec.item_identifier_type);
1926: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1927: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1928: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1929: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1930: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1931: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1932: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1933: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1926: rlm_core_sv.dlog(k_DEBUG,'industry_attribute1 ', x_oe_line_rec.industry_attribute1);
1927: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1928: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1929: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1930: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1931: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1932: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1933: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1934: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1927: rlm_core_sv.dlog(k_DEBUG,'industry_attribute2 ', x_oe_line_rec.industry_attribute2);
1928: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1929: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1930: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1931: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1932: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1933: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1934: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1935: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1928: rlm_core_sv.dlog(k_DEBUG,'industry_attribute3 ', x_oe_line_rec.industry_attribute3);
1929: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1930: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1931: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1932: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1933: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1934: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1935: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1936: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1929: rlm_core_sv.dlog(k_DEBUG,'industry_attribute4 ', x_oe_line_rec.industry_attribute4);
1930: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1931: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1932: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1933: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1934: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1935: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1936: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1937: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1930: rlm_core_sv.dlog(k_DEBUG,'industry_attribute5 ', x_oe_line_rec.industry_attribute5);
1931: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1932: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1933: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1934: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1935: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1936: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1937: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1938: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1931: rlm_core_sv.dlog(k_DEBUG,'industry_attribute6 ', x_oe_line_rec.industry_attribute6);
1932: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1933: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1934: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1935: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1936: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1937: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1938: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1939: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1932: rlm_core_sv.dlog(k_DEBUG,'industry_attribute7 ', x_oe_line_rec.industry_attribute7);
1933: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1934: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1935: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1936: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1937: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1938: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1939: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1940: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1933: rlm_core_sv.dlog(k_DEBUG,'industry_attribute8 ', x_oe_line_rec.industry_attribute8);
1934: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1935: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1936: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1937: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1938: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1939: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1940: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1941: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1934: rlm_core_sv.dlog(k_DEBUG,'industry_attribute9 ', x_oe_line_rec.industry_attribute9);
1935: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1936: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1937: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1938: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1939: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1940: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1941: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1942: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1935: rlm_core_sv.dlog(k_DEBUG,'industry_attribute10', x_oe_line_rec.industry_attribute10);
1936: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1937: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1938: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1939: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1940: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1941: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1942: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1943: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1936: rlm_core_sv.dlog(k_DEBUG,'industry_attribute11', x_oe_line_rec.industry_attribute11);
1937: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1938: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1939: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1940: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1941: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1942: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1943: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1944: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1937: rlm_core_sv.dlog(k_DEBUG,'industry_attribute12', x_oe_line_rec.industry_attribute12);
1938: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1939: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1940: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1941: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1942: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1943: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1944: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1945: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1938: rlm_core_sv.dlog(k_DEBUG,'industry_attribute13', x_oe_line_rec.industry_attribute13);
1939: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1940: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1941: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1942: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1943: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1944: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1945: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1946: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1939: rlm_core_sv.dlog(k_DEBUG,'industry_attribute14', x_oe_line_rec.industry_attribute14);
1940: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1941: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1942: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1943: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1944: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1945: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1946: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1947: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1940: rlm_core_sv.dlog(k_DEBUG,'industry_attribute15', x_oe_line_rec.industry_attribute15);
1941: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1942: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1943: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1944: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1945: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1946: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1947: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1948: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1941: rlm_core_sv.dlog(k_DEBUG,'industry_context', x_oe_line_rec.industry_context);
1942: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1943: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1944: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1945: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1946: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1947: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1948: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1949: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1942: rlm_core_sv.dlog(k_DEBUG,'attribute1 ', x_oe_line_rec.attribute1);
1943: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1944: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1945: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1946: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1947: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1948: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1949: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1950: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1943: rlm_core_sv.dlog(k_DEBUG,'attribute2', x_oe_line_rec.attribute2);
1944: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1945: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1946: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1947: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1948: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1949: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1950: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1951: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1944: rlm_core_sv.dlog(k_DEBUG,'attribute3 ', x_oe_line_rec.attribute3);
1945: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1946: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1947: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1948: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1949: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1950: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1951: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1952: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1945: rlm_core_sv.dlog(k_DEBUG,'attribute4 ', x_oe_line_rec.attribute4);
1946: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1947: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1948: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1949: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1950: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1951: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1952: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1953: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1946: rlm_core_sv.dlog(k_DEBUG,'attribute5 ', x_oe_line_rec.attribute5);
1947: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1948: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1949: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1950: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1951: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1952: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1953: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1954: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1947: rlm_core_sv.dlog(k_DEBUG,'attribute6', x_oe_line_rec.attribute6);
1948: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1949: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1950: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1951: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1952: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1953: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1954: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1955: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1948: rlm_core_sv.dlog(k_DEBUG,'attribute7 ', x_oe_line_rec.attribute7);
1949: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1950: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1951: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1952: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1953: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1954: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1955: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1956: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);
1949: rlm_core_sv.dlog(k_DEBUG,'attribute8 ', x_oe_line_rec.attribute8);
1950: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1951: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1952: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1953: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1954: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1955: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1956: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);
1957: rlm_core_sv.dlog(k_DEBUG,'attribute_category',x_oe_line_rec.context);
1950: rlm_core_sv.dlog(k_DEBUG,'attribute9 ', x_oe_line_rec.attribute9);
1951: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1952: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1953: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1954: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1955: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1956: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);
1957: rlm_core_sv.dlog(k_DEBUG,'attribute_category',x_oe_line_rec.context);
1958: rlm_core_sv.dlog(k_DEBUG,'blanket_number',x_oe_line_rec.blanket_number);
1951: rlm_core_sv.dlog(k_DEBUG,'attribute10', x_oe_line_rec.attribute10);
1952: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1953: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1954: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1955: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1956: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);
1957: rlm_core_sv.dlog(k_DEBUG,'attribute_category',x_oe_line_rec.context);
1958: rlm_core_sv.dlog(k_DEBUG,'blanket_number',x_oe_line_rec.blanket_number);
1959: rlm_core_sv.dlog(k_DEBUG,'Org ID', x_oe_line_rec.org_id);
1952: rlm_core_sv.dlog(k_DEBUG,'attribute11', x_oe_line_rec.attribute11);
1953: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1954: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1955: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1956: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);
1957: rlm_core_sv.dlog(k_DEBUG,'attribute_category',x_oe_line_rec.context);
1958: rlm_core_sv.dlog(k_DEBUG,'blanket_number',x_oe_line_rec.blanket_number);
1959: rlm_core_sv.dlog(k_DEBUG,'Org ID', x_oe_line_rec.org_id);
1960: END IF;
1953: rlm_core_sv.dlog(k_DEBUG,'attribute12', x_oe_line_rec.attribute12);
1954: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1955: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1956: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);
1957: rlm_core_sv.dlog(k_DEBUG,'attribute_category',x_oe_line_rec.context);
1958: rlm_core_sv.dlog(k_DEBUG,'blanket_number',x_oe_line_rec.blanket_number);
1959: rlm_core_sv.dlog(k_DEBUG,'Org ID', x_oe_line_rec.org_id);
1960: END IF;
1961: END IF;
1954: rlm_core_sv.dlog(k_DEBUG,'attribute13', x_oe_line_rec.attribute13);
1955: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1956: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);
1957: rlm_core_sv.dlog(k_DEBUG,'attribute_category',x_oe_line_rec.context);
1958: rlm_core_sv.dlog(k_DEBUG,'blanket_number',x_oe_line_rec.blanket_number);
1959: rlm_core_sv.dlog(k_DEBUG,'Org ID', x_oe_line_rec.org_id);
1960: END IF;
1961: END IF;
1962: --
1955: rlm_core_sv.dlog(k_DEBUG,'attribute14', x_oe_line_rec.attribute14);
1956: rlm_core_sv.dlog(k_DEBUG,'attribute15', x_oe_line_rec.attribute15);
1957: rlm_core_sv.dlog(k_DEBUG,'attribute_category',x_oe_line_rec.context);
1958: rlm_core_sv.dlog(k_DEBUG,'blanket_number',x_oe_line_rec.blanket_number);
1959: rlm_core_sv.dlog(k_DEBUG,'Org ID', x_oe_line_rec.org_id);
1960: END IF;
1961: END IF;
1962: --
1963: IF (l_debug <> -1) THEN
1960: END IF;
1961: END IF;
1962: --
1963: IF (l_debug <> -1) THEN
1964: rlm_core_sv.dpop(k_SDEBUG);
1965: END IF;
1966: --
1967: EXCEPTION
1968: WHEN OTHERS THEN
1967: EXCEPTION
1968: WHEN OTHERS THEN
1969: --
1970: IF (l_debug <> -1) THEN
1971: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
1972: END IF;
1973: --
1974: raise;
1975:
2070: --
2071: WHEN OTHERS THEN
2072: --
2073: IF (l_debug <> -1) THEN
2074: rlm_core_sv.dlog(k_DEBUG,'EXCEPTION',SUBSTR(SQLERRM,1,200));
2075: END IF;
2076: --
2077: raise;
2078:
2180: --
2181: BEGIN
2182: --
2183: IF (l_debug <> -1) THEN
2184: rlm_core_sv.dpush(k_SDEBUG,'GetTPContext');
2185: rlm_core_sv.dlog(k_DEBUG,'customer_id', x_Op_rec.customer_id);
2186: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.ship_to_org_id',
2187: x_Op_rec.ship_to_org_id);
2188: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.intmed_ship_to_org_id',
2181: BEGIN
2182: --
2183: IF (l_debug <> -1) THEN
2184: rlm_core_sv.dpush(k_SDEBUG,'GetTPContext');
2185: rlm_core_sv.dlog(k_DEBUG,'customer_id', x_Op_rec.customer_id);
2186: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.ship_to_org_id',
2187: x_Op_rec.ship_to_org_id);
2188: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.intmed_ship_to_org_id',
2189: x_Op_rec.intmed_ship_to_org_id);
2182: --
2183: IF (l_debug <> -1) THEN
2184: rlm_core_sv.dpush(k_SDEBUG,'GetTPContext');
2185: rlm_core_sv.dlog(k_DEBUG,'customer_id', x_Op_rec.customer_id);
2186: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.ship_to_org_id',
2187: x_Op_rec.ship_to_org_id);
2188: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.intmed_ship_to_org_id',
2189: x_Op_rec.intmed_ship_to_org_id);
2190: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.invoice_to_org_id',
2184: rlm_core_sv.dpush(k_SDEBUG,'GetTPContext');
2185: rlm_core_sv.dlog(k_DEBUG,'customer_id', x_Op_rec.customer_id);
2186: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.ship_to_org_id',
2187: x_Op_rec.ship_to_org_id);
2188: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.intmed_ship_to_org_id',
2189: x_Op_rec.intmed_ship_to_org_id);
2190: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.invoice_to_org_id',
2191: x_Op_rec.invoice_to_org_id);
2192: END IF;
2186: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.ship_to_org_id',
2187: x_Op_rec.ship_to_org_id);
2188: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.intmed_ship_to_org_id',
2189: x_Op_rec.intmed_ship_to_org_id);
2190: rlm_core_sv.dlog(k_DEBUG,'x_Op_rec.invoice_to_org_id',
2191: x_Op_rec.invoice_to_org_id);
2192: END IF;
2193: --
2194: BEGIN
2225: x_bill_to_ece_locn_code := NULL;
2226: WHEN OTHERS THEN
2227: --
2228: IF (l_debug <> -1) THEN
2229: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2230: END IF;
2231: --
2232: raise;
2233: --
2274: x_customer_number := NULL;
2275: WHEN OTHERS THEN
2276: --
2277: IF (l_debug <> -1) THEN
2278: rlm_core_sv.dlog(k_DEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2279: END IF;
2280: --
2281: raise;
2282: END;
2283:
2284: END IF;
2285: --
2286: IF (l_debug <> -1) THEN
2287: rlm_core_sv.dlog(k_DEBUG, 'customer_number', x_customer_number);
2288: rlm_core_sv.dlog(k_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2289: rlm_core_sv.dlog(k_DEBUG,'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2290: rlm_core_sv.dlog(k_DEBUG,'x_inter_ship_to_ece_locn_code',
2291: x_inter_ship_to_ece_locn_code);
2284: END IF;
2285: --
2286: IF (l_debug <> -1) THEN
2287: rlm_core_sv.dlog(k_DEBUG, 'customer_number', x_customer_number);
2288: rlm_core_sv.dlog(k_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2289: rlm_core_sv.dlog(k_DEBUG,'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2290: rlm_core_sv.dlog(k_DEBUG,'x_inter_ship_to_ece_locn_code',
2291: x_inter_ship_to_ece_locn_code);
2292: rlm_core_sv.dlog(k_DEBUG,'x_tp_Group_code', x_tp_Group_code);
2285: --
2286: IF (l_debug <> -1) THEN
2287: rlm_core_sv.dlog(k_DEBUG, 'customer_number', x_customer_number);
2288: rlm_core_sv.dlog(k_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2289: rlm_core_sv.dlog(k_DEBUG,'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2290: rlm_core_sv.dlog(k_DEBUG,'x_inter_ship_to_ece_locn_code',
2291: x_inter_ship_to_ece_locn_code);
2292: rlm_core_sv.dlog(k_DEBUG,'x_tp_Group_code', x_tp_Group_code);
2293: rlm_core_sv.dpop(k_SDEBUG);
2286: IF (l_debug <> -1) THEN
2287: rlm_core_sv.dlog(k_DEBUG, 'customer_number', x_customer_number);
2288: rlm_core_sv.dlog(k_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2289: rlm_core_sv.dlog(k_DEBUG,'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2290: rlm_core_sv.dlog(k_DEBUG,'x_inter_ship_to_ece_locn_code',
2291: x_inter_ship_to_ece_locn_code);
2292: rlm_core_sv.dlog(k_DEBUG,'x_tp_Group_code', x_tp_Group_code);
2293: rlm_core_sv.dpop(k_SDEBUG);
2294: END IF;
2288: rlm_core_sv.dlog(k_DEBUG,'x_ship_to_ece_locn_code', x_ship_to_ece_locn_code);
2289: rlm_core_sv.dlog(k_DEBUG,'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2290: rlm_core_sv.dlog(k_DEBUG,'x_inter_ship_to_ece_locn_code',
2291: x_inter_ship_to_ece_locn_code);
2292: rlm_core_sv.dlog(k_DEBUG,'x_tp_Group_code', x_tp_Group_code);
2293: rlm_core_sv.dpop(k_SDEBUG);
2294: END IF;
2295: --
2296: EXCEPTION
2289: rlm_core_sv.dlog(k_DEBUG,'x_bill_to_ece_locn_code', x_bill_to_ece_locn_code);
2290: rlm_core_sv.dlog(k_DEBUG,'x_inter_ship_to_ece_locn_code',
2291: x_inter_ship_to_ece_locn_code);
2292: rlm_core_sv.dlog(k_DEBUG,'x_tp_Group_code', x_tp_Group_code);
2293: rlm_core_sv.dpop(k_SDEBUG);
2294: END IF;
2295: --
2296: EXCEPTION
2297: --
2299: --
2300: x_customer_number := NULL;
2301: --
2302: IF (l_debug <> -1) THEN
2303: rlm_core_sv.dlog(k_DEBUG, 'No data found for' , x_Op_rec.customer_id);
2304: rlm_core_sv.dpop(k_SDEBUG);
2305: END IF;
2306: --
2307: WHEN OTHERS THEN
2300: x_customer_number := NULL;
2301: --
2302: IF (l_debug <> -1) THEN
2303: rlm_core_sv.dlog(k_DEBUG, 'No data found for' , x_Op_rec.customer_id);
2304: rlm_core_sv.dpop(k_SDEBUG);
2305: END IF;
2306: --
2307: WHEN OTHERS THEN
2308: --
2308: --
2309: rlm_message_sv.sql_error('rlm_validatedemand_sv.GetTPContext',v_Progress);
2310: --
2311: IF (l_debug <> -1) THEN
2312: rlm_core_sv.dpop(k_SDEBUG,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
2313: END IF;
2314: --
2315: raise;
2316: --
2345: BEGIN
2346:
2347: --
2348: IF (l_debug <> -1) THEN
2349: rlm_core_sv.dpush(k_SDEBUG,'GetIntransitShippedLines');
2350: END IF;
2351:
2352: --ITS should be complete before a WDD/OM line can be considered intransit.
2353: --OE tables are referenced while considered shipped lines.
2367:
2368: IF TO_DATE(x_optional_match_rec.industry_attribute2,'RRRR/MM/DD HH24:MI:SS') < trunc(l_effective_start_date) THEN
2369:
2370: IF (l_debug <> -1) THEN
2371: rlm_core_sv.dlog(k_DEBUG,'Reconciling against all the Blanket Release orders');
2372: END IF;
2373:
2374: v_where_clause := ' WHERE o.header_id IN'||
2375: ' (SELECT rbr.rso_hdr_id FROM rlm_blanket_rso rbr,oe_order_headers oh WHERE rbr.blanket_number = '||x_Group_rec.blanket_number||
3244: --
3245: v_final_sql := v_select_clause||v_where_clause;
3246: --
3247: IF (l_debug <> -1) THEN
3248: rlm_core_sv.dlog(k_DEBUG,'Dynamic SQL',v_final_sql);
3249: rlm_core_sv.dlog(k_DEBUG,'g_wheretab count', g_whereTab.COUNT);
3250: END IF;
3251: -- print bind variables
3252: FOR i in 1..g_whereTab.COUNT
3245: v_final_sql := v_select_clause||v_where_clause;
3246: --
3247: IF (l_debug <> -1) THEN
3248: rlm_core_sv.dlog(k_DEBUG,'Dynamic SQL',v_final_sql);
3249: rlm_core_sv.dlog(k_DEBUG,'g_wheretab count', g_whereTab.COUNT);
3250: END IF;
3251: -- print bind variables
3252: FOR i in 1..g_whereTab.COUNT
3253: LOOP
3251: -- print bind variables
3252: FOR i in 1..g_whereTab.COUNT
3253: LOOP
3254: IF (l_debug <> -1) THEN
3255: rlm_core_sv.dlog(k_DEBUG,'Value for g_where_tab('||to_char(i)||')', g_whereTab(i));
3256: END IF;
3257: END LOOP;
3258: --
3259: RLM_CORE_SV.OpenDynamicCursor(c_sum,v_final_sql,g_wheretab);
3255: rlm_core_sv.dlog(k_DEBUG,'Value for g_where_tab('||to_char(i)||')', g_whereTab(i));
3256: END IF;
3257: END LOOP;
3258: --
3259: RLM_CORE_SV.OpenDynamicCursor(c_sum,v_final_sql,g_wheretab);
3260: FETCH c_sum INTO x_intransit_qty;
3261: CLOSE c_sum;
3262: --
3263: g_wheretab.delete;
3262: --
3263: g_wheretab.delete;
3264: --
3265: IF (l_debug <> -1) THEN
3266: rlm_core_sv.dlog(k_DEBUG,'Intransit Qty', x_intransit_qty);
3267: rlm_core_sv.dpop(k_SDEBUG,'GetIntransitShippedLines');
3268: END IF;
3269: --
3270: EXCEPTION
3263: g_wheretab.delete;
3264: --
3265: IF (l_debug <> -1) THEN
3266: rlm_core_sv.dlog(k_DEBUG,'Intransit Qty', x_intransit_qty);
3267: rlm_core_sv.dpop(k_SDEBUG,'GetIntransitShippedLines');
3268: END IF;
3269: --
3270: EXCEPTION
3271: When others then
3269: --
3270: EXCEPTION
3271: When others then
3272: IF (l_debug <> -1) THEN
3273: rlm_core_sv.dpop(k_SDEBUG,'GetIntransitShippedLines'||substr(sqlerrm,1,200));
3274: END IF;
3275: raise;
3276: END GetIntransitShippedLines;
3277: