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

APPS.RLM_PS_SV dependencies on RLM_CORE_SV

Line 7: g_BindVarTab RLM_CORE_SV.t_dynamic_tab;

3: /*========================== rlm_ps_sv========================*/
4: --
5: l_DEBUG NUMBER := NVL(fnd_profile.value('RLM_DEBUG_MODE'),-1);
6: TYPE g_number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
7: g_BindVarTab RLM_CORE_SV.t_dynamic_tab;
8: g_interface_headers_tab g_number_tbl_type;
9: g_schedule_headers_tab g_number_tbl_type;
10: --
11: PROCEDURE PurgeSchedule(errbuf OUT NOCOPY VARCHAR2,

Line 80: rlm_core_sv.start_debug;

76: MO_GLOBAL.set_policy_context(p_access_mode => 'S',
77: p_org_id => p_org_id);
78: --
79: IF (l_debug <> -1) THEN
80: rlm_core_sv.start_debug;
81: rlm_core_sv.dpush(C_SDEBUG,'PurgeSchedule');
82: END IF;
83: --
84: rlm_message_sv.populate_req_id;

Line 81: rlm_core_sv.dpush(C_SDEBUG,'PurgeSchedule');

77: p_org_id => p_org_id);
78: --
79: IF (l_debug <> -1) THEN
80: rlm_core_sv.start_debug;
81: rlm_core_sv.dpush(C_SDEBUG,'PurgeSchedule');
82: END IF;
83: --
84: rlm_message_sv.populate_req_id;
85: --

Line 132: rlm_core_sv.dlog(C_DEBUG, 'v_arch_statement', v_arch_statement);

128:
129: g_BindVarTab(g_BindVarTab.COUNT+1):=5;
130: --
131: IF (l_debug <> -1) THEN
132: rlm_core_sv.dlog(C_DEBUG, 'v_arch_statement', v_arch_statement);
133: rlm_core_sv.dlog(C_DEBUG, 'v_int_statement', v_int_statement);
134: rlm_core_sv.dlog(C_DEBUG, 'v_schedule_source', v_schedule_source);
135: rlm_core_sv.dlog(C_DEBUG, '============================');
136: rlm_core_sv.dlog(C_DEBUG, 'Printing Bind Variable Values');

Line 133: rlm_core_sv.dlog(C_DEBUG, 'v_int_statement', v_int_statement);

129: g_BindVarTab(g_BindVarTab.COUNT+1):=5;
130: --
131: IF (l_debug <> -1) THEN
132: rlm_core_sv.dlog(C_DEBUG, 'v_arch_statement', v_arch_statement);
133: rlm_core_sv.dlog(C_DEBUG, 'v_int_statement', v_int_statement);
134: rlm_core_sv.dlog(C_DEBUG, 'v_schedule_source', v_schedule_source);
135: rlm_core_sv.dlog(C_DEBUG, '============================');
136: rlm_core_sv.dlog(C_DEBUG, 'Printing Bind Variable Values');
137: rlm_core_sv.dlog(C_DEBUG, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);

Line 134: rlm_core_sv.dlog(C_DEBUG, 'v_schedule_source', v_schedule_source);

130: --
131: IF (l_debug <> -1) THEN
132: rlm_core_sv.dlog(C_DEBUG, 'v_arch_statement', v_arch_statement);
133: rlm_core_sv.dlog(C_DEBUG, 'v_int_statement', v_int_statement);
134: rlm_core_sv.dlog(C_DEBUG, 'v_schedule_source', v_schedule_source);
135: rlm_core_sv.dlog(C_DEBUG, '============================');
136: rlm_core_sv.dlog(C_DEBUG, 'Printing Bind Variable Values');
137: rlm_core_sv.dlog(C_DEBUG, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);
138: --

Line 135: rlm_core_sv.dlog(C_DEBUG, '============================');

131: IF (l_debug <> -1) THEN
132: rlm_core_sv.dlog(C_DEBUG, 'v_arch_statement', v_arch_statement);
133: rlm_core_sv.dlog(C_DEBUG, 'v_int_statement', v_int_statement);
134: rlm_core_sv.dlog(C_DEBUG, 'v_schedule_source', v_schedule_source);
135: rlm_core_sv.dlog(C_DEBUG, '============================');
136: rlm_core_sv.dlog(C_DEBUG, 'Printing Bind Variable Values');
137: rlm_core_sv.dlog(C_DEBUG, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);
138: --
139: FOR i IN 1..g_BindVarTab.COUNT LOOP

Line 136: rlm_core_sv.dlog(C_DEBUG, 'Printing Bind Variable Values');

132: rlm_core_sv.dlog(C_DEBUG, 'v_arch_statement', v_arch_statement);
133: rlm_core_sv.dlog(C_DEBUG, 'v_int_statement', v_int_statement);
134: rlm_core_sv.dlog(C_DEBUG, 'v_schedule_source', v_schedule_source);
135: rlm_core_sv.dlog(C_DEBUG, '============================');
136: rlm_core_sv.dlog(C_DEBUG, 'Printing Bind Variable Values');
137: rlm_core_sv.dlog(C_DEBUG, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);
138: --
139: FOR i IN 1..g_BindVarTab.COUNT LOOP
140: rlm_core_sv.dlog(C_DEBUG, 'g_BindVarTab('||i||')', g_BindVarTab(i));

Line 137: rlm_core_sv.dlog(C_DEBUG, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);

133: rlm_core_sv.dlog(C_DEBUG, 'v_int_statement', v_int_statement);
134: rlm_core_sv.dlog(C_DEBUG, 'v_schedule_source', v_schedule_source);
135: rlm_core_sv.dlog(C_DEBUG, '============================');
136: rlm_core_sv.dlog(C_DEBUG, 'Printing Bind Variable Values');
137: rlm_core_sv.dlog(C_DEBUG, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);
138: --
139: FOR i IN 1..g_BindVarTab.COUNT LOOP
140: rlm_core_sv.dlog(C_DEBUG, 'g_BindVarTab('||i||')', g_BindVarTab(i));
141: END LOOP;

Line 140: rlm_core_sv.dlog(C_DEBUG, 'g_BindVarTab('||i||')', g_BindVarTab(i));

136: rlm_core_sv.dlog(C_DEBUG, 'Printing Bind Variable Values');
137: rlm_core_sv.dlog(C_DEBUG, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);
138: --
139: FOR i IN 1..g_BindVarTab.COUNT LOOP
140: rlm_core_sv.dlog(C_DEBUG, 'g_BindVarTab('||i||')', g_BindVarTab(i));
141: END LOOP;
142: --
143: rlm_core_sv.dlog(C_DEBUG, '============================');
144: END IF;

Line 143: rlm_core_sv.dlog(C_DEBUG, '============================');

139: FOR i IN 1..g_BindVarTab.COUNT LOOP
140: rlm_core_sv.dlog(C_DEBUG, 'g_BindVarTab('||i||')', g_BindVarTab(i));
141: END LOOP;
142: --
143: rlm_core_sv.dlog(C_DEBUG, '============================');
144: END IF;
145: --
146: -- interface only
147: --

Line 150: RLM_CORE_SV.OpenDynamicCursor(c_demand, v_int_statement, g_BindVarTab);

146: -- interface only
147: --
148: IF(p_status = 1 or p_status = 2 or p_status = 3) THEN
149: --{
150: RLM_CORE_SV.OpenDynamicCursor(c_demand, v_int_statement, g_BindVarTab);
151: FETCH c_demand INTO v_sched_header_id;
152: --
153: IF c_demand%NOTFOUND THEN
154: raise e_no_data_found;

Line 177: RLM_CORE_SV.OpenDynamicCursor(c_demand, v_arch_statement, g_BindVarTab);

173: ELSIF(p_status = 4) THEN
174: --{
175: -- Test for no schedules matching the criteria
176: --
177: RLM_CORE_SV.OpenDynamicCursor(c_demand, v_arch_statement, g_BindVarTab);
178: FETCH c_demand INTO v_sched_header_id;
179: --
180: IF c_demand%NOTFOUND THEN
181: raise e_no_data_found;

Line 202: RLM_CORE_SV.OpenDynamicCursor(c_demand, v_int_statement, g_BindVarTab);

198: ELSE
199: --{
200: -- check for matching interface and archive schedules
201: --
202: RLM_CORE_SV.OpenDynamicCursor(c_demand, v_int_statement, g_BindVarTab);
203: FETCH c_demand INTO v_sched_header_id;
204: --
205: IF c_demand%NOTFOUND THEN
206: --{

Line 208: RLM_CORE_SV.OpenDynamicCursor(c_demand, v_arch_statement, g_BindVarTab);

204: --
205: IF c_demand%NOTFOUND THEN
206: --{
207: CLOSE c_demand;
208: RLM_CORE_SV.OpenDynamicCursor(c_demand, v_arch_statement, g_BindVarTab);
209: FETCH c_demand INTO v_sched_header_id;
210: --
211: IF c_demand%NOTFOUND THEN
212: --

Line 251: rlm_core_sv.dlog(C_DEBUG, 'No of Schedule Exception Lines Deleted ', SQL%ROWCOUNT);

247: where schedule_header_id= g_schedule_headers_tab(counter)
248: and request_id <> fnd_global.conc_request_id;
249: --
250: IF (l_debug <> -1) THEN
251: rlm_core_sv.dlog(C_DEBUG, 'No of Schedule Exception Lines Deleted ', SQL%ROWCOUNT);
252: END IF;
253: --
254: FORALL counter in 1..g_interface_headers_tab.COUNT
255: --

Line 261: rlm_core_sv.dlog(C_DEBUG, 'No of Interface Exception Lines Deleted ', SQL%ROWCOUNT);

257: where interface_header_id= g_interface_headers_tab(counter)
258: and request_id <> fnd_global.conc_request_id;
259: --
260: IF (l_debug <> -1) THEN
261: rlm_core_sv.dlog(C_DEBUG, 'No of Interface Exception Lines Deleted ', SQL%ROWCOUNT);
262: END IF;
263: --
264: -- runreport
265: --

Line 282: rlm_core_sv.dpop(C_SDEBUG);

278: p_authorization => p_authorization,
279: p_status => p_status);
280: --
281: IF (l_debug <> -1) THEN
282: rlm_core_sv.dpop(C_SDEBUG);
283: rlm_core_sv.stop_debug;
284: END IF;
285: --
286: EXCEPTION

Line 283: rlm_core_sv.stop_debug;

279: p_status => p_status);
280: --
281: IF (l_debug <> -1) THEN
282: rlm_core_sv.dpop(C_SDEBUG);
283: rlm_core_sv.stop_debug;
284: END IF;
285: --
286: EXCEPTION
287: --

Line 291: rlm_core_sv.dlog(C_DEBUG, 'No schedules to delete' );

287: --
288: WHEN e_no_data_found THEN
289: --
290: IF (l_debug <> -1) THEN
291: rlm_core_sv.dlog(C_DEBUG, 'No schedules to delete' );
292: END IF;
293: --
294: --runreport
295: --

Line 314: rlm_core_sv.dpop(C_SDEBUG);

310: --
311: rlm_message_sv.sql_error('rlm_ps_sv.PurgeSchedule', v_Progress);
312: --
313: IF (l_debug <> -1) THEN
314: rlm_core_sv.dpop(C_SDEBUG);
315: END IF;
316: --
317: WHEN OTHERS THEN
318: --

Line 320: rlm_core_sv.dlog(C_DEBUG, 'When others - Purge Schedule' );

316: --
317: WHEN OTHERS THEN
318: --
319: IF (l_debug <> -1) THEN
320: rlm_core_sv.dlog(C_DEBUG, 'When others - Purge Schedule' );
321: END IF;
322: --
323: --runreport
324: --

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

340: rlm_message_sv.sql_error('rlm_ps_sv.PurgeSchedule', v_Progress);
341: rlm_message_sv.dump_messages;
342: --
343: IF (l_debug <> -1) THEN
344: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
345: END IF;
346: raise;
347: --
348: END PurgeSchedule;

Line 405: rlm_core_sv.dpush(C_SDEBUG,'PurgeArchive');

401: --
402: BEGIN
403:
404: IF (l_debug <> -1) THEN
405: rlm_core_sv.dpush(C_SDEBUG,'PurgeArchive');
406: END IF;
407: --fetch header_id from the select statement
408: RLM_CORE_SV.OpenDynamicCursor(c_demand, p_statement, g_BindVarTab);
409:

Line 408: RLM_CORE_SV.OpenDynamicCursor(c_demand, p_statement, g_BindVarTab);

404: IF (l_debug <> -1) THEN
405: rlm_core_sv.dpush(C_SDEBUG,'PurgeArchive');
406: END IF;
407: --fetch header_id from the select statement
408: RLM_CORE_SV.OpenDynamicCursor(c_demand, p_statement, g_BindVarTab);
409:
410: LOOP
411:
412: BEGIN

Line 417: rlm_core_sv.dlog(C_DEBUG,'Schedule Header Id',v_sched_header_id);

413:
414: FETCH c_demand INTO v_sched_header_id;
415:
416: IF (l_debug <> -1) THEN
417: rlm_core_sv.dlog(C_DEBUG,'Schedule Header Id',v_sched_header_id);
418: END IF;
419:
420: EXIT WHEN c_demand%NOTFOUND;
421:

Line 446: rlm_core_sv.dlog(C_DEBUG,'v_line_count1',v_line_count);

442: AND ship_to_address_id between p_ship_to_address_id_from
443: AND nvl(p_ship_to_address_id_to, p_ship_to_address_id_from);
444:
445: IF (l_debug <> -1) THEN
446: rlm_core_sv.dlog(C_DEBUG,'v_line_count1',v_line_count);
447: END IF;
448:
449: select count(*) into v_line_count2 from rlm_schedule_lines
450: where header_id = v_sched_header_id;

Line 453: rlm_core_sv.dlog(C_DEBUG,'v_line_count2',v_line_count2);

449: select count(*) into v_line_count2 from rlm_schedule_lines
450: where header_id = v_sched_header_id;
451:
452: IF (l_debug <> -1) THEN
453: rlm_core_sv.dlog(C_DEBUG,'v_line_count2',v_line_count2);
454: END IF;
455:
456: v_partial_schedule :=FALSE;
457:

Line 463: rlm_core_sv.dlog(C_DEBUG,'partial ship to location selection for',v_sched_header_id);

459:
460: --partial selection of a schedule
461:
462: IF (l_debug <> -1) THEN
463: rlm_core_sv.dlog(C_DEBUG,'partial ship to location selection for',v_sched_header_id);
464: END IF;
465:
466: --insert exception
467:

Line 497: rlm_core_sv.dlog(C_DEBUG,'Open Order found or Partial Schedule For Schedule Header Id',

493:
494: IF (v_order_exists = TRUE OR v_partial_schedule = TRUE) THEN
495:
496: IF (l_debug <> -1) THEN
497: rlm_core_sv.dlog(C_DEBUG,'Open Order found or Partial Schedule For Schedule Header Id',
498: v_sched_header_id);
499: END IF;
500:
501: null;

Line 508: rlm_core_sv.dlog(C_DEBUG,'Execution Mode',p_execution_mode);

504:
505: IF(p_execution_mode = 'P') THEN
506:
507: IF (l_debug <> -1) THEN
508: rlm_core_sv.dlog(C_DEBUG,'Execution Mode',p_execution_mode);
509: END IF;
510:
511: --delete schedules
512:

Line 516: rlm_core_sv.dlog(C_DEBUG,'v_line_count_process',v_line_count);

512:
513: select count(*) into v_line_count from rlm_schedule_headers where header_id = v_sched_header_id;
514:
515: IF (l_debug <> -1) THEN
516: rlm_core_sv.dlog(C_DEBUG,'v_line_count_process',v_line_count);
517: END IF;
518:
519:
520: IF(v_line_count > 0) THEN

Line 524: rlm_core_sv.dlog(C_DEBUG,'checking for authorization...');

520: IF(v_line_count > 0) THEN
521:
522: --check for delete schedules with authorization
523: IF (l_debug <> -1) THEN
524: rlm_core_sv.dlog(C_DEBUG,'checking for authorization...');
525: END IF;
526:
527: IF(p_authorization = 'Y') THEN
528:

Line 530: rlm_core_sv.dlog(C_DEBUG,'Deleting...',v_sched_header_id);

526:
527: IF(p_authorization = 'Y') THEN
528:
529: IF (l_debug <> -1) THEN
530: rlm_core_sv.dlog(C_DEBUG,'Deleting...',v_sched_header_id);
531: END IF;
532:
533:
534: --store exception

Line 554: rlm_core_sv.dlog(C_DEBUG,'v_line_count_detail',v_line_count);

550:
551: select count(*) into v_line_count from rlm_schedule_lines where header_id = v_sched_header_id and item_detail_type = '3';
552:
553: IF (l_debug <> -1) THEN
554: rlm_core_sv.dlog(C_DEBUG,'v_line_count_detail',v_line_count);
555: END IF;
556:
557:
558: IF(v_line_count > 0) THEN

Line 562: rlm_core_sv.dlog(C_DEBUG,'Authorization exists, Retaining....',v_sched_header_id);

558: IF(v_line_count > 0) THEN
559:
560:
561: IF (l_debug <> -1) THEN
562: rlm_core_sv.dlog(C_DEBUG,'Authorization exists, Retaining....',v_sched_header_id);
563: END IF;
564:
565: --store exception retained
566: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',

Line 591: rlm_core_sv.dlog(C_DEBUG,'Authorization not found, deleting....',v_sched_header_id);

587:
588:
589:
590: IF (l_debug <> -1) THEN
591: rlm_core_sv.dlog(C_DEBUG,'Authorization not found, deleting....',v_sched_header_id);
592: END IF;
593:
594: delete from rlm_schedule_lines where header_id = v_sched_header_id;
595: delete from rlm_schedule_headers where header_id = v_sched_header_id;

Line 614: rlm_core_sv.dlog(C_DEBUG,'Execution Mode',p_execution_mode);

610:
611: --view mode
612:
613: IF (l_debug <> -1) THEN
614: rlm_core_sv.dlog(C_DEBUG,'Execution Mode',p_execution_mode);
615: END IF;
616:
617: --check for process status in view mode
618:

Line 622: rlm_core_sv.dlog(C_DEBUG,'v_line_count_status',v_line_count);

618:
619: select count(*) into v_line_count from rlm_schedule_headers where header_id = v_sched_header_id;
620:
621: IF (l_debug <> -1) THEN
622: rlm_core_sv.dlog(C_DEBUG,'v_line_count_status',v_line_count);
623: END IF;
624:
625: IF(v_line_count > 0) THEN
626:

Line 628: rlm_core_sv.dlog(C_DEBUG,'checking for authorization...');

624:
625: IF(v_line_count > 0) THEN
626:
627: IF (l_debug <> -1) THEN
628: rlm_core_sv.dlog(C_DEBUG,'checking for authorization...');
629: END IF;
630:
631: IF(p_authorization = 'Y') THEN
632:

Line 643: rlm_core_sv.dlog(C_DEBUG,'Purgable...(view)',v_sched_header_id);

639: x_PurgeStatus => 'Y',
640: x_PurgeExp_rec=>x_purge_rec );
641:
642: IF (l_debug <> -1) THEN
643: rlm_core_sv.dlog(C_DEBUG,'Purgable...(view)',v_sched_header_id);
644: END IF;
645:
646: null;
647:

Line 654: rlm_core_sv.dlog(C_DEBUG,'v_line_count_detail',v_line_count);

650:
651: select count(*) into v_line_count from rlm_schedule_lines where header_id = v_sched_header_id and item_detail_type = '3';
652:
653: IF (l_debug <> -1) THEN
654: rlm_core_sv.dlog(C_DEBUG,'v_line_count_detail',v_line_count);
655: END IF;
656:
657: IF(v_line_count > 0) THEN
658:

Line 670: rlm_core_sv.dlog(C_DEBUG,'Authorization found..not purgable..(view)',v_sched_header_id);

666: x_PurgeExp_rec=>x_purge_rec );
667:
668:
669: IF (l_debug <> -1) THEN
670: rlm_core_sv.dlog(C_DEBUG,'Authorization found..not purgable..(view)',v_sched_header_id);
671: END IF;
672:
673: null;
674:

Line 690: rlm_core_sv.dlog(C_DEBUG,'Authorization not found.. purgable..(view)',v_sched_header_id);

686: x_PurgeExp_rec=>x_purge_rec );
687:
688:
689: IF (l_debug <> -1) THEN
690: rlm_core_sv.dlog(C_DEBUG,'Authorization not found.. purgable..(view)',v_sched_header_id);
691: END IF;
692:
693:
694: END IF; --check for item_detail = 3

Line 711: rlm_core_sv.dlog(C_DEBUG,'success');

707: --
708: commit;
709: --
710: IF (l_debug <> -1) THEN
711: rlm_core_sv.dlog(C_DEBUG,'success');
712: rlm_core_sv.dpop(C_SDEBUG,'PurgeArchive');
713: END IF;
714:
715:

Line 712: rlm_core_sv.dpop(C_SDEBUG,'PurgeArchive');

708: commit;
709: --
710: IF (l_debug <> -1) THEN
711: rlm_core_sv.dlog(C_DEBUG,'success');
712: rlm_core_sv.dpop(C_SDEBUG,'PurgeArchive');
713: END IF;
714:
715:
716: EXCEPTION

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

720: rlm_message_sv.sql_error('rlm_ps_sv.PurgeArchive', v_Progress);
721: rlm_message_sv.dump_messages;
722: --
723: IF (l_debug <> -1) THEN
724: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
725: END IF;
726: --
727: raise;
728:

Line 788: rlm_core_sv.dpush(C_SDEBUG,'PurgeInterface');

784: --
785: BEGIN
786: --
787: IF (l_debug <> -1) THEN
788: rlm_core_sv.dpush(C_SDEBUG,'PurgeInterface');
789: END IF;
790: --
791: --fetch header_id from the select statement
792: --

Line 793: RLM_CORE_SV.OpenDynamicCursor(c_demand, p_statement, g_BindVarTab);

789: END IF;
790: --
791: --fetch header_id from the select statement
792: --
793: RLM_CORE_SV.OpenDynamicCursor(c_demand, p_statement, g_BindVarTab);
794: --
795: LOOP
796: --{
797: BEGIN

Line 801: rlm_core_sv.dlog(C_DEBUG,'Schedule Header Id',v_sched_header_id);

797: BEGIN
798: --{
799: FETCH c_demand INTO v_sched_header_id;
800: IF (l_debug <> -1) THEN
801: rlm_core_sv.dlog(C_DEBUG,'Schedule Header Id',v_sched_header_id);
802: END IF;
803:
804: EXIT WHEN c_demand%NOTFOUND;
805:

Line 830: rlm_core_sv.dlog(C_DEBUG,'v_line_count1',v_line_count);

826: AND ship_to_address_id between p_ship_to_address_id_from
827: AND nvl(p_ship_to_address_id_to, p_ship_to_address_id_from);
828:
829: IF (l_debug <> -1) THEN
830: rlm_core_sv.dlog(C_DEBUG,'v_line_count1',v_line_count);
831: END IF;
832:
833: select count(*) into v_line_count2 from rlm_interface_lines
834: where header_id = v_sched_header_id;

Line 837: rlm_core_sv.dlog(C_DEBUG,'v_line_count2',v_line_count2);

833: select count(*) into v_line_count2 from rlm_interface_lines
834: where header_id = v_sched_header_id;
835:
836: IF (l_debug <> -1) THEN
837: rlm_core_sv.dlog(C_DEBUG,'v_line_count2',v_line_count2);
838: END IF;
839:
840: v_partial_schedule :=FALSE;
841:

Line 847: rlm_core_sv.dlog(C_DEBUG,'partial ship to location selection for',v_sched_header_id);

843:
844: --partial selection of a schedule
845:
846: IF (l_debug <> -1) THEN
847: rlm_core_sv.dlog(C_DEBUG,'partial ship to location selection for',v_sched_header_id);
848: END IF;
849:
850: --insert exception
851:

Line 885: rlm_core_sv.dlog(C_DEBUG,'No link to any archive schedule for ',v_sched_header_id);

881: EXCEPTION
882: WHEN NO_DATA_FOUND THEN
883: --
884: IF (l_debug <> -1) THEN
885: rlm_core_sv.dlog(C_DEBUG,'No link to any archive schedule for ',v_sched_header_id);
886: END IF;
887: --
888: END;
889: --

Line 894: rlm_core_sv.dlog(C_DEBUG,'Open Order or Partial Schedule For Interface Header Id',

890: END IF;
891: --
892: IF (v_order_exists =TRUE or v_partial_schedule = TRUE) THEN
893: IF (l_debug <> -1) THEN
894: rlm_core_sv.dlog(C_DEBUG,'Open Order or Partial Schedule For Interface Header Id',
895: v_sched_header_id);
896: END IF;
897: null;
898: ELSE

Line 901: rlm_core_sv.dlog(C_DEBUG,'Execution Mode',p_execution_mode);

897: null;
898: ELSE
899: IF(p_execution_mode = 'P') THEN
900: IF (l_debug <> -1) THEN
901: rlm_core_sv.dlog(C_DEBUG,'Execution Mode',p_execution_mode);
902: END IF;
903: --delete schedules
904: IF(p_authorization = 'Y') THEN
905:

Line 907: rlm_core_sv.dlog(C_DEBUG,'Deleting...',v_sched_header_id);

903: --delete schedules
904: IF(p_authorization = 'Y') THEN
905:
906: IF (l_debug <> -1) THEN
907: rlm_core_sv.dlog(C_DEBUG,'Deleting...',v_sched_header_id);
908: END IF;
909:
910: --store exception
911: rlm_message_sv.insert_purge_row (x_ExceptionLevel => 'X',

Line 940: rlm_core_sv.dlog(C_DEBUG,'v_line_count_detail',v_line_count);

936:
937: select count(*) into v_line_count from rlm_interface_lines where header_id = v_sched_header_id and item_detail_type = '3';
938:
939: IF (l_debug <> -1) THEN
940: rlm_core_sv.dlog(C_DEBUG,'v_line_count_detail',v_line_count);
941: END IF;
942:
943:
944: IF(v_line_count > 0) THEN

Line 948: rlm_core_sv.dlog(C_DEBUG,'Authorization exists, Retaining....',v_sched_header_id);

944: IF(v_line_count > 0) THEN
945:
946:
947: IF (l_debug <> -1) THEN
948: rlm_core_sv.dlog(C_DEBUG,'Authorization exists, Retaining....',v_sched_header_id);
949: END IF;
950:
951: --store exception retained
952: rlm_message_sv.app_purge_error (x_ExceptionLevel => 'E',

Line 975: rlm_core_sv.dlog(C_DEBUG,'Authorization not found, deleting....',v_sched_header_id);

971:
972:
973:
974: IF (l_debug <> -1) THEN
975: rlm_core_sv.dlog(C_DEBUG,'Authorization not found, deleting....',v_sched_header_id);
976: END IF;
977:
978: delete from rlm_interface_lines where header_id = v_sched_header_id;
979: delete from rlm_interface_headers where header_id = v_sched_header_id;

Line 1002: rlm_core_sv.dlog(C_DEBUG,'Execution Mode',p_execution_mode);

998:
999: --view mode-------------------------------------------------
1000:
1001: IF (l_debug <> -1) THEN
1002: rlm_core_sv.dlog(C_DEBUG,'Execution Mode',p_execution_mode);
1003: END IF;
1004:
1005: IF(p_authorization = 'Y') THEN
1006:

Line 1017: rlm_core_sv.dlog(C_DEBUG,'Purgable...(view)',v_sched_header_id);

1013: x_PurgeStatus => 'Y',
1014: x_PurgeExp_rec=>x_purge_rec );
1015:
1016: IF (l_debug <> -1) THEN
1017: rlm_core_sv.dlog(C_DEBUG,'Purgable...(view)',v_sched_header_id);
1018: END IF;
1019:
1020: null;
1021:

Line 1027: rlm_core_sv.dlog(C_DEBUG,'v_line_count_detail',v_line_count);

1023:
1024: select count(*) into v_line_count from rlm_interface_lines where header_id = v_sched_header_id and item_detail_type = '3';
1025:
1026: IF (l_debug <> -1) THEN
1027: rlm_core_sv.dlog(C_DEBUG,'v_line_count_detail',v_line_count);
1028: END IF;
1029:
1030: IF(v_line_count > 0) THEN
1031:

Line 1043: rlm_core_sv.dlog(C_DEBUG,'Authorization found..not purgable..(view)',v_sched_header_id);

1039: x_PurgeExp_rec=>x_purge_rec );
1040:
1041:
1042: IF (l_debug <> -1) THEN
1043: rlm_core_sv.dlog(C_DEBUG,'Authorization found..not purgable..(view)',v_sched_header_id);
1044: END IF;
1045: null;
1046:
1047: ELSE

Line 1062: rlm_core_sv.dlog(C_DEBUG,'Authorization not found.. purgable..(view)',v_sched_header_id);

1058: x_PurgeExp_rec=>x_purge_rec );
1059:
1060:
1061: IF (l_debug <> -1) THEN
1062: rlm_core_sv.dlog(C_DEBUG,'Authorization not found.. purgable..(view)',v_sched_header_id);
1063: END IF;
1064:
1065:
1066: END IF; --check for item_detail = 3

Line 1081: rlm_core_sv.dlog(C_DEBUG,'success');

1077: --}
1078: commit;
1079: --
1080: IF (l_debug <> -1) THEN
1081: rlm_core_sv.dlog(C_DEBUG,'success');
1082: rlm_core_sv.dpop(C_SDEBUG,'PurgeInterface');
1083: END IF;
1084: --
1085: EXCEPTION

Line 1082: rlm_core_sv.dpop(C_SDEBUG,'PurgeInterface');

1078: commit;
1079: --
1080: IF (l_debug <> -1) THEN
1081: rlm_core_sv.dlog(C_DEBUG,'success');
1082: rlm_core_sv.dpop(C_SDEBUG,'PurgeInterface');
1083: END IF;
1084: --
1085: EXCEPTION
1086: WHEN OTHERS THEN

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

1088: rlm_message_sv.sql_error('rlm_ps_sv.PurgeInterface', v_Progress);
1089: rlm_message_sv.dump_messages;
1090: --
1091: IF (l_debug <> -1) THEN
1092: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
1093: END IF;
1094: --
1095: raise;
1096:

Line 1124: rlm_core_sv.dpush(C_SDEBUG,'RunReport');

1120:
1121: BEGIN
1122: --
1123: IF (l_debug <> -1) THEN
1124: rlm_core_sv.dpush(C_SDEBUG,'RunReport');
1125: rlm_core_sv.dlog(C_DEBUG,'Begin Report');
1126: END IF;
1127: --
1128: --MOAC Changes fnd_profile.get('ORG_ID', p_org_id);

Line 1125: rlm_core_sv.dlog(C_DEBUG,'Begin Report');

1121: BEGIN
1122: --
1123: IF (l_debug <> -1) THEN
1124: rlm_core_sv.dpush(C_SDEBUG,'RunReport');
1125: rlm_core_sv.dlog(C_DEBUG,'Begin Report');
1126: END IF;
1127: --
1128: --MOAC Changes fnd_profile.get('ORG_ID', p_org_id);
1129: --

Line 1131: rlm_core_sv.dlog(C_DEBUG,'Operating unit', p_org_id);

1127: --
1128: --MOAC Changes fnd_profile.get('ORG_ID', p_org_id);
1129: --
1130: IF (l_debug <> -1) THEN
1131: rlm_core_sv.dlog(C_DEBUG,'Operating unit', p_org_id);
1132: END IF;
1133: --
1134: fnd_request.set_org_id(p_org_id);
1135: --

Line 1156: rlm_core_sv.dlog(C_DEBUG,'Report Request ID', x_request_id);

1152: argument15 =>p_org_id
1153: );
1154: --
1155: IF (l_debug <> -1) THEN
1156: rlm_core_sv.dlog(C_DEBUG,'Report Request ID', x_request_id);
1157: rlm_core_sv.dlog(C_DEBUG,'End Report');
1158: rlm_core_sv.dpop(C_SDEBUG,'RunReport');
1159: END IF;
1160: --

Line 1157: rlm_core_sv.dlog(C_DEBUG,'End Report');

1153: );
1154: --
1155: IF (l_debug <> -1) THEN
1156: rlm_core_sv.dlog(C_DEBUG,'Report Request ID', x_request_id);
1157: rlm_core_sv.dlog(C_DEBUG,'End Report');
1158: rlm_core_sv.dpop(C_SDEBUG,'RunReport');
1159: END IF;
1160: --
1161: EXCEPTION

Line 1158: rlm_core_sv.dpop(C_SDEBUG,'RunReport');

1154: --
1155: IF (l_debug <> -1) THEN
1156: rlm_core_sv.dlog(C_DEBUG,'Report Request ID', x_request_id);
1157: rlm_core_sv.dlog(C_DEBUG,'End Report');
1158: rlm_core_sv.dpop(C_SDEBUG,'RunReport');
1159: END IF;
1160: --
1161: EXCEPTION
1162: --

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

1165: rlm_message_sv.sql_error('rlm_ps_sv.RunReport', v_Progress);
1166: rlm_message_sv.dump_messages;
1167: --
1168: IF (l_debug <> -1) THEN
1169: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
1170: END IF;
1171: --
1172: raise;
1173: --

Line 1205: rlm_core_sv.dpush(C_SDEBUG,'BuildQuery');

1201:
1202: BEGIN
1203:
1204: IF (l_debug <> -1) THEN
1205: rlm_core_sv.dpush(C_SDEBUG,'BuildQuery');
1206: END IF;
1207: --
1208: IF (p_execution_mode IS NOT NULL) THEN
1209: --

Line 1211: rlm_core_sv.dlog(C_DEBUG,'p_execution_mode',p_execution_mode);

1207: --
1208: IF (p_execution_mode IS NOT NULL) THEN
1209: --
1210: IF (l_debug <> -1) THEN
1211: rlm_core_sv.dlog(C_DEBUG,'p_execution_mode',p_execution_mode);
1212: END IF;
1213: --
1214: END IF;
1215: --

Line 1223: rlm_core_sv.dlog(C_DEBUG,'p_translator_code_from',

1219: --
1220: IF(p_translator_code_from IS NOT NULL) THEN
1221: --
1222: IF (l_debug <> -1) THEN
1223: rlm_core_sv.dlog(C_DEBUG,'p_translator_code_from',
1224: p_translator_code_from);
1225: rlm_core_sv.dlog(C_DEBUG,'p_translator_code_to',
1226: p_translator_code_to);
1227: END IF;

Line 1225: rlm_core_sv.dlog(C_DEBUG,'p_translator_code_to',

1221: --
1222: IF (l_debug <> -1) THEN
1223: rlm_core_sv.dlog(C_DEBUG,'p_translator_code_from',
1224: p_translator_code_from);
1225: rlm_core_sv.dlog(C_DEBUG,'p_translator_code_to',
1226: p_translator_code_to);
1227: END IF;
1228: --
1229: v_where_clause := v_where_clause ||

Line 1241: rlm_core_sv.dlog(C_DEBUG,'p_customer',p_customer);

1237: --
1238: IF(p_customer IS NOT NULL) THEN
1239: --
1240: IF (l_debug <> -1) THEN
1241: rlm_core_sv.dlog(C_DEBUG,'p_customer',p_customer);
1242: END IF;
1243: --
1244: -- 2261960
1245: --

Line 1264: rlm_core_sv.dlog(C_DEBUG,'p_ship_to_address_id_from',

1260: --
1261: IF(p_ship_to_address_id_from IS NOT NULL) THEN
1262: --
1263: IF (l_debug <> -1) THEN
1264: rlm_core_sv.dlog(C_DEBUG,'p_ship_to_address_id_from',
1265: p_ship_to_address_id_from);
1266: rlm_core_sv.dlog(C_DEBUG,'p_ship_to_address_id_to',
1267: p_ship_to_address_id_to);
1268: END IF;

Line 1266: rlm_core_sv.dlog(C_DEBUG,'p_ship_to_address_id_to',

1262: --
1263: IF (l_debug <> -1) THEN
1264: rlm_core_sv.dlog(C_DEBUG,'p_ship_to_address_id_from',
1265: p_ship_to_address_id_from);
1266: rlm_core_sv.dlog(C_DEBUG,'p_ship_to_address_id_to',
1267: p_ship_to_address_id_to);
1268: END IF;
1269: --
1270: v_where_clause := v_where_clause ||' AND rl.ship_to_address_id between :p_ship_to_address_id_from AND nvl(:p_ship_to_address_id_to, :p_ship_to_address_id_from)';

Line 1281: rlm_core_sv.dlog(C_DEBUG,'p_issue_date_from',p_issue_date_from);

1277: --
1278: IF (p_issue_date_from IS NOT NULL) THEN
1279: --
1280: IF (l_debug <> -1) THEN
1281: rlm_core_sv.dlog(C_DEBUG,'p_issue_date_from',p_issue_date_from);
1282: rlm_core_sv.dlog(C_DEBUG,'p_issue_date_to',p_issue_date_to);
1283: END IF;
1284: --
1285: v_where_clause := v_where_clause || ' AND rh.sched_generation_date between to_date(:p_issue_date_from,''YYYY/MM/DD HH24:MI:SS'') AND to_date(nvl(:p_issue_date_to,:p_issue_date_from), ''YYYY/MM/DD HH24:MI:SS'')';

Line 1282: rlm_core_sv.dlog(C_DEBUG,'p_issue_date_to',p_issue_date_to);

1278: IF (p_issue_date_from IS NOT NULL) THEN
1279: --
1280: IF (l_debug <> -1) THEN
1281: rlm_core_sv.dlog(C_DEBUG,'p_issue_date_from',p_issue_date_from);
1282: rlm_core_sv.dlog(C_DEBUG,'p_issue_date_to',p_issue_date_to);
1283: END IF;
1284: --
1285: v_where_clause := v_where_clause || ' AND rh.sched_generation_date between to_date(:p_issue_date_from,''YYYY/MM/DD HH24:MI:SS'') AND to_date(nvl(:p_issue_date_to,:p_issue_date_from), ''YYYY/MM/DD HH24:MI:SS'')';
1286: --

Line 1296: rlm_core_sv.dlog(C_DEBUG,'p_schedule_type',p_schedule_type);

1292: --
1293: IF(p_schedule_type IS NOT NULL) THEN
1294: --
1295: IF (l_debug <> -1) THEN
1296: rlm_core_sv.dlog(C_DEBUG,'p_schedule_type',p_schedule_type);
1297: END IF;
1298: --
1299: v_where_clause := v_where_clause || ' AND rh.schedule_type = :p_schedule_type ';
1300: --

Line 1308: rlm_core_sv.dlog(C_DEBUG,'p_delete_beyond_days',p_delete_beyond_days);

1304: --
1305: IF (p_delete_beyond_days IS NOT NULL) THEN
1306: --
1307: IF (l_debug <> -1) THEN
1308: rlm_core_sv.dlog(C_DEBUG,'p_delete_beyond_days',p_delete_beyond_days);
1309: rlm_core_sv.dlog(C_DEBUG,'prior to',sysdate-p_delete_beyond_days);
1310: END IF;
1311: --
1312: v_where_clause := v_where_clause || ' AND rh.sched_generation_date < sysdate-:p_delete_beyond_days';

Line 1309: rlm_core_sv.dlog(C_DEBUG,'prior to',sysdate-p_delete_beyond_days);

1305: IF (p_delete_beyond_days IS NOT NULL) THEN
1306: --
1307: IF (l_debug <> -1) THEN
1308: rlm_core_sv.dlog(C_DEBUG,'p_delete_beyond_days',p_delete_beyond_days);
1309: rlm_core_sv.dlog(C_DEBUG,'prior to',sysdate-p_delete_beyond_days);
1310: END IF;
1311: --
1312: v_where_clause := v_where_clause || ' AND rh.sched_generation_date < sysdate-:p_delete_beyond_days';
1313: --

Line 1321: rlm_core_sv.dlog(C_DEBUG,'p_authorization',p_authorization);

1317: --
1318: IF (p_authorization IS NOT NULL) THEN
1319: --
1320: IF (l_debug <> -1) THEN
1321: rlm_core_sv.dlog(C_DEBUG,'p_authorization',p_authorization);
1322: END IF;
1323: --
1324: END IF;
1325: --

Line 1334: rlm_core_sv.dlog(C_DEBUG,'p_schedule_ref_no',p_schedule_ref_no);

1330: --
1331: g_BindVarTab.DELETE;
1332: --
1333: IF (l_debug <> -1) THEN
1334: rlm_core_sv.dlog(C_DEBUG,'p_schedule_ref_no',p_schedule_ref_no);
1335: END IF;
1336: --
1337: v_where_clause := ' where rh.header_id = rl.header_id AND rh.header_id =:p_schedule_ref_no';
1338: --

Line 1346: rlm_core_sv.dlog(C_DEBUG,'p_status',p_status);

1342: --
1343: IF(p_status IS NOT NULL) THEN
1344: --{
1345: IF (l_debug <> -1) THEN
1346: rlm_core_sv.dlog(C_DEBUG,'p_status',p_status);
1347: END IF;
1348: --
1349: -- to be processed
1350: --

Line 1397: rlm_core_sv.dlog(C_DEBUG, 'Where Clause', v_where_clause);

1393: --}
1394: END IF;
1395: --
1396: IF (l_debug <> -1) THEN
1397: rlm_core_sv.dlog(C_DEBUG, 'Where Clause', v_where_clause);
1398: rlm_core_sv.dlog(C_DEBUG, '# of bind variables', g_BindVarTab.COUNT);
1399: rlm_core_sv.dpop(C_SDEBUG);
1400: END IF;
1401: --

Line 1398: rlm_core_sv.dlog(C_DEBUG, '# of bind variables', g_BindVarTab.COUNT);

1394: END IF;
1395: --
1396: IF (l_debug <> -1) THEN
1397: rlm_core_sv.dlog(C_DEBUG, 'Where Clause', v_where_clause);
1398: rlm_core_sv.dlog(C_DEBUG, '# of bind variables', g_BindVarTab.COUNT);
1399: rlm_core_sv.dpop(C_SDEBUG);
1400: END IF;
1401: --
1402: return v_where_clause;

Line 1399: rlm_core_sv.dpop(C_SDEBUG);

1395: --
1396: IF (l_debug <> -1) THEN
1397: rlm_core_sv.dlog(C_DEBUG, 'Where Clause', v_where_clause);
1398: rlm_core_sv.dlog(C_DEBUG, '# of bind variables', g_BindVarTab.COUNT);
1399: rlm_core_sv.dpop(C_SDEBUG);
1400: END IF;
1401: --
1402: return v_where_clause;
1403: --

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

1407: rlm_message_sv.sql_error('rlm_ps_sv.BuildQuery', v_Progress);
1408: rlm_message_sv.dump_messages;
1409: --
1410: IF (l_debug <> -1) THEN
1411: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
1412: END IF;
1413: --
1414: return v_where_clause;
1415:

Line 1475: rlm_core_sv.dpush(C_SDEBUG,'CheckOpenOrder');

1471:
1472: BEGIN
1473:
1474: IF (l_debug <> -1) THEN
1475: rlm_core_sv.dpush(C_SDEBUG,'CheckOpenOrder');
1476: END IF;
1477:
1478: v_order_exists := FALSE;
1479:

Line 1514: rlm_core_sv.dlog(C_DEBUG,'For Schedule Header Id',p_schedule_header_id);

1510:
1511: EXIT WHEN oe_demand%NOTFOUND;
1512:
1513: IF (l_debug <> -1) THEN
1514: rlm_core_sv.dlog(C_DEBUG,'For Schedule Header Id',p_schedule_header_id);
1515: rlm_core_sv.dlog(C_DEBUG,'v_open_flag',v_open_flag);
1516: rlm_core_sv.dlog(C_DEBUG,'v_order_header',v_order_header);
1517: rlm_core_sv.dlog(C_DEBUG,'v_order_line',v_order_line);
1518: rlm_core_sv.dlog(C_DEBUG,'Schedule Line Id',v_sched_line_id);

Line 1515: rlm_core_sv.dlog(C_DEBUG,'v_open_flag',v_open_flag);

1511: EXIT WHEN oe_demand%NOTFOUND;
1512:
1513: IF (l_debug <> -1) THEN
1514: rlm_core_sv.dlog(C_DEBUG,'For Schedule Header Id',p_schedule_header_id);
1515: rlm_core_sv.dlog(C_DEBUG,'v_open_flag',v_open_flag);
1516: rlm_core_sv.dlog(C_DEBUG,'v_order_header',v_order_header);
1517: rlm_core_sv.dlog(C_DEBUG,'v_order_line',v_order_line);
1518: rlm_core_sv.dlog(C_DEBUG,'Schedule Line Id',v_sched_line_id);
1519: rlm_core_sv.dlog(C_DEBUG,'Schedule Line Number',v_line_number); --bugfix 6319027

Line 1516: rlm_core_sv.dlog(C_DEBUG,'v_order_header',v_order_header);

1512:
1513: IF (l_debug <> -1) THEN
1514: rlm_core_sv.dlog(C_DEBUG,'For Schedule Header Id',p_schedule_header_id);
1515: rlm_core_sv.dlog(C_DEBUG,'v_open_flag',v_open_flag);
1516: rlm_core_sv.dlog(C_DEBUG,'v_order_header',v_order_header);
1517: rlm_core_sv.dlog(C_DEBUG,'v_order_line',v_order_line);
1518: rlm_core_sv.dlog(C_DEBUG,'Schedule Line Id',v_sched_line_id);
1519: rlm_core_sv.dlog(C_DEBUG,'Schedule Line Number',v_line_number); --bugfix 6319027
1520: END IF;

Line 1517: rlm_core_sv.dlog(C_DEBUG,'v_order_line',v_order_line);

1513: IF (l_debug <> -1) THEN
1514: rlm_core_sv.dlog(C_DEBUG,'For Schedule Header Id',p_schedule_header_id);
1515: rlm_core_sv.dlog(C_DEBUG,'v_open_flag',v_open_flag);
1516: rlm_core_sv.dlog(C_DEBUG,'v_order_header',v_order_header);
1517: rlm_core_sv.dlog(C_DEBUG,'v_order_line',v_order_line);
1518: rlm_core_sv.dlog(C_DEBUG,'Schedule Line Id',v_sched_line_id);
1519: rlm_core_sv.dlog(C_DEBUG,'Schedule Line Number',v_line_number); --bugfix 6319027
1520: END IF;
1521:

Line 1518: rlm_core_sv.dlog(C_DEBUG,'Schedule Line Id',v_sched_line_id);

1514: rlm_core_sv.dlog(C_DEBUG,'For Schedule Header Id',p_schedule_header_id);
1515: rlm_core_sv.dlog(C_DEBUG,'v_open_flag',v_open_flag);
1516: rlm_core_sv.dlog(C_DEBUG,'v_order_header',v_order_header);
1517: rlm_core_sv.dlog(C_DEBUG,'v_order_line',v_order_line);
1518: rlm_core_sv.dlog(C_DEBUG,'Schedule Line Id',v_sched_line_id);
1519: rlm_core_sv.dlog(C_DEBUG,'Schedule Line Number',v_line_number); --bugfix 6319027
1520: END IF;
1521:
1522: IF (v_open_flag = 'Y') THEN

Line 1519: rlm_core_sv.dlog(C_DEBUG,'Schedule Line Number',v_line_number); --bugfix 6319027

1515: rlm_core_sv.dlog(C_DEBUG,'v_open_flag',v_open_flag);
1516: rlm_core_sv.dlog(C_DEBUG,'v_order_header',v_order_header);
1517: rlm_core_sv.dlog(C_DEBUG,'v_order_line',v_order_line);
1518: rlm_core_sv.dlog(C_DEBUG,'Schedule Line Id',v_sched_line_id);
1519: rlm_core_sv.dlog(C_DEBUG,'Schedule Line Number',v_line_number); --bugfix 6319027
1520: END IF;
1521:
1522: IF (v_open_flag = 'Y') THEN
1523:

Line 1529: rlm_core_sv.dlog(C_DEBUG,'Order_exists',v_order_exists);

1525:
1526: v_order_exists := TRUE;
1527:
1528: IF (l_debug <> -1) THEN
1529: rlm_core_sv.dlog(C_DEBUG,'Order_exists',v_order_exists);
1530: END IF;
1531:
1532: --insert exception
1533:

Line 1557: rlm_core_sv.dpop(C_SDEBUG,'CheckOpenOrder');

1553:
1554: CLOSE oe_demand;
1555: --
1556: IF (l_debug <> -1) THEN
1557: rlm_core_sv.dpop(C_SDEBUG,'CheckOpenOrder');
1558: END IF;
1559: --
1560: return v_order_exists;
1561:

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

1565: rlm_message_sv.sql_error('rlm_ps_sv.CheckOpenOrder', v_Progress);
1566: rlm_message_sv.dump_messages;
1567: --
1568: IF (l_debug <> -1) THEN
1569: rlm_core_sv.dpop(C_SDEBUG,'EXCEPTION: '|| SUBSTR(SQLERRM,1,200));
1570: END IF;
1571: --
1572: return FALSE;
1573: