DBA Data[Home] [Help]

APPS.GME_REROUTE_BATCH_PVT dependencies on GME_DEBUG

Line 109: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

105: l_M_count NUMBER := 0;
106: l_B_count NUMBER := 0;
107: BEGIN
108: IF (NVL (g_debug, 0) IN
109: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
110: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
111: || 'Entering');
112: END IF;
113:

Line 110: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

106: l_B_count NUMBER := 0;
107: BEGIN
108: IF (NVL (g_debug, 0) IN
109: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
110: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
111: || 'Entering');
112: END IF;
113:
114: /* Set the return status to success initially */

Line 305: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

301:
302: gme_common_pvt.g_routing_scale_factor :=
303: l_total_output_qty_b / l_total_output_qty_c;
304:
305: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
306: gme_debug.put_line ( 'Routing scale factor is '
307: || gme_common_pvt.g_routing_scale_factor);
308: END IF;
309: ELSE

Line 306: gme_debug.put_line ( 'Routing scale factor is '

302: gme_common_pvt.g_routing_scale_factor :=
303: l_total_output_qty_b / l_total_output_qty_c;
304:
305: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
306: gme_debug.put_line ( 'Routing scale factor is '
307: || gme_common_pvt.g_routing_scale_factor);
308: END IF;
309: ELSE
310: gme_common_pvt.g_routing_scale_factor := 1;

Line 441: IF (g_debug = gme_debug.g_log_statement) THEN

437: x_batch_header_rec.plan_cmplt_date :=
438: gme_common_pvt.g_timestamp;
439: END IF;
440:
441: IF (g_debug = gme_debug.g_log_statement) THEN
442: gme_debug.put_line
443: ( 'production rule start_date '
444: || TO_CHAR
445: (x_batch_header_rec.plan_start_date

Line 442: gme_debug.put_line

438: gme_common_pvt.g_timestamp;
439: END IF;
440:
441: IF (g_debug = gme_debug.g_log_statement) THEN
442: gme_debug.put_line
443: ( 'production rule start_date '
444: || TO_CHAR
445: (x_batch_header_rec.plan_start_date
446: ,'DD-MON-YYYY HH24:MI:SS') );

Line 447: gme_debug.put_line

443: ( 'production rule start_date '
444: || TO_CHAR
445: (x_batch_header_rec.plan_start_date
446: ,'DD-MON-YYYY HH24:MI:SS') );
447: gme_debug.put_line
448: ( 'production rule end_date '
449: || TO_CHAR
450: (x_batch_header_rec.plan_cmplt_date
451: ,'DD-MON-YYYY HH24:MI:SS') );

Line 472: IF (g_debug = gme_debug.g_log_statement) THEN

468: gme_common_pvt.material_date_change
469: (p_material_detail_id => l_material_detail_rec.material_detail_id
470: ,p_material_date => NULL
471: ,x_return_status => x_return_status);
472: IF (g_debug = gme_debug.g_log_statement) THEN
473: gme_debug.put_line
474: ( 'after call to gme_common_pvt.material_date_change
475: material_detail_id is='
476: ||to_char(l_material_detail_ids_tab (i))

Line 473: gme_debug.put_line

469: (p_material_detail_id => l_material_detail_rec.material_detail_id
470: ,p_material_date => NULL
471: ,x_return_status => x_return_status);
472: IF (g_debug = gme_debug.g_log_statement) THEN
473: gme_debug.put_line
474: ( 'after call to gme_common_pvt.material_date_change
475: material_detail_id is='
476: ||to_char(l_material_detail_ids_tab (i))
477: ||' return status = '||x_return_status);

Line 522: gme_debug.put_line('sc l_phantom_batch_header_rec.batch_id is '||l_phantom_batch_header_rec.batch_id);

518: ,p_use_workday_cal => fnd_api.g_false
519: ,x_batch_step_rec => x_batch_step_rec
520: ,x_return_status => x_return_status);
521: ELSE
522: gme_debug.put_line('sc l_phantom_batch_header_rec.batch_id is '||l_phantom_batch_header_rec.batch_id);
523: l_phantom_batch_header_rec.plan_cmplt_date:=l_material_detail_rec.material_requirement_date;
524: gme_debug.put_line('sc l_phantom_batch_header_rec.plan_cmplt_date is '||to_char(l_phantom_batch_step_rec.plan_cmplt_date, 'DD-MON-YY HH24:MI:SS'));
525: gme_reschedule_batch_pvt.reschedule_batch
526: (p_batch_header_rec => l_phantom_batch_header_rec

Line 524: gme_debug.put_line('sc l_phantom_batch_header_rec.plan_cmplt_date is '||to_char(l_phantom_batch_step_rec.plan_cmplt_date, 'DD-MON-YY HH24:MI:SS'));

520: ,x_return_status => x_return_status);
521: ELSE
522: gme_debug.put_line('sc l_phantom_batch_header_rec.batch_id is '||l_phantom_batch_header_rec.batch_id);
523: l_phantom_batch_header_rec.plan_cmplt_date:=l_material_detail_rec.material_requirement_date;
524: gme_debug.put_line('sc l_phantom_batch_header_rec.plan_cmplt_date is '||to_char(l_phantom_batch_step_rec.plan_cmplt_date, 'DD-MON-YY HH24:MI:SS'));
525: gme_reschedule_batch_pvt.reschedule_batch
526: (p_batch_header_rec => l_phantom_batch_header_rec
527: ,p_use_workday_cal => fnd_api.g_false
528: ,p_contiguity_override => fnd_api.g_true

Line 531: gme_debug.put_line('sc l_phantom_batch_header_rec_out.plan_cmplt_date is '||to_char(l_phantom_batch_header_rec_out.plan_cmplt_date, 'DD-MON-YY HH24:MI:SS'));

527: ,p_use_workday_cal => fnd_api.g_false
528: ,p_contiguity_override => fnd_api.g_true
529: ,x_batch_header_rec => l_phantom_batch_header_rec_out
530: ,x_return_status => x_return_status);
531: gme_debug.put_line('sc l_phantom_batch_header_rec_out.plan_cmplt_date is '||to_char(l_phantom_batch_header_rec_out.plan_cmplt_date, 'DD-MON-YY HH24:MI:SS'));
532: gme_debug.put_line('sc l_phantom_batch_header_rec_out.batch_id is '||l_phantom_batch_header_rec_out.batch_id);
533: END IF;
534: END IF;
535:

Line 532: gme_debug.put_line('sc l_phantom_batch_header_rec_out.batch_id is '||l_phantom_batch_header_rec_out.batch_id);

528: ,p_contiguity_override => fnd_api.g_true
529: ,x_batch_header_rec => l_phantom_batch_header_rec_out
530: ,x_return_status => x_return_status);
531: gme_debug.put_line('sc l_phantom_batch_header_rec_out.plan_cmplt_date is '||to_char(l_phantom_batch_header_rec_out.plan_cmplt_date, 'DD-MON-YY HH24:MI:SS'));
532: gme_debug.put_line('sc l_phantom_batch_header_rec_out.batch_id is '||l_phantom_batch_header_rec_out.batch_id);
533: END IF;
534: END IF;
535:
536: --FPBug#4585491 Begin

Line 592: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

588: RAISE fnd_api.g_exc_error;
589: END IF;
590:
591: IF (NVL (g_debug, 0) IN
592: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
593: gme_debug.put_line ( g_pkg_name
594: || '.'
595: || l_api_name
596: || ':'

Line 593: gme_debug.put_line ( g_pkg_name

589: END IF;
590:
591: IF (NVL (g_debug, 0) IN
592: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
593: gme_debug.put_line ( g_pkg_name
594: || '.'
595: || l_api_name
596: || ':'
597: || 'Exiting with '

Line 609: gme_debug.put_line ( g_pkg_name

605: WHEN fnd_api.g_exc_unexpected_error THEN
606: x_return_status := fnd_api.g_ret_sts_unexp_error;
607:
608: IF (NVL (g_debug, 0) > 0) THEN
609: gme_debug.put_line ( g_pkg_name
610: || '.'
611: || l_api_name
612: || ':'
613: || 'UNEXPECTED:'

Line 620: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

616: WHEN error_dbl THEN
617: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
618: x_return_status := FND_API.g_ret_sts_unexp_error;
619:
620: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
621: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ': '
622: || l_proc|| ' unexpected error: '|| SQLERRM);
623: END IF;
624: WHEN OTHERS THEN

Line 621: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ': '

617: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
618: x_return_status := FND_API.g_ret_sts_unexp_error;
619:
620: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
621: gme_debug.put_line (g_pkg_name||'.'||l_api_name|| ': '
622: || l_proc|| ' unexpected error: '|| SQLERRM);
623: END IF;
624: WHEN OTHERS THEN
625: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 629: gme_debug.put_line ( g_pkg_name

625: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
626: x_return_status := fnd_api.g_ret_sts_unexp_error;
627:
628: IF (NVL (g_debug, 0) > 0) THEN
629: gme_debug.put_line ( g_pkg_name
630: || '.'
631: || l_api_name
632: || ':'
633: || 'OTHERS:'

Line 657: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

653: IS
654: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_ALL_STEPS';
655: BEGIN
656: IF (NVL (g_debug, 0) IN
657: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
658: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
659: || 'Entering');
660: END IF;
661:

Line 658: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

654: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_ALL_STEPS';
655: BEGIN
656: IF (NVL (g_debug, 0) IN
657: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
658: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
659: || 'Entering');
660: END IF;
661:
662: /* Set the return status to success initially */

Line 693: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

689: DELETE FROM gme_batch_steps
690: WHERE batch_id = p_batch_id;
691:
692: IF (NVL (g_debug, 0) IN
693: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
694: gme_debug.put_line ( g_pkg_name
695: || '.'
696: || l_api_name
697: || ':'

Line 694: gme_debug.put_line ( g_pkg_name

690: WHERE batch_id = p_batch_id;
691:
692: IF (NVL (g_debug, 0) IN
693: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
694: gme_debug.put_line ( g_pkg_name
695: || '.'
696: || l_api_name
697: || ':'
698: || 'Exiting with '

Line 708: gme_debug.put_line ( g_pkg_name

704: WHEN fnd_api.g_exc_unexpected_error THEN
705: x_return_status := fnd_api.g_ret_sts_unexp_error;
706:
707: IF (NVL (g_debug, 0) > 0) THEN
708: gme_debug.put_line ( g_pkg_name
709: || '.'
710: || l_api_name
711: || ':'
712: || 'UNEXPECTED:'

Line 720: gme_debug.put_line ( g_pkg_name

716: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
717: x_return_status := fnd_api.g_ret_sts_unexp_error;
718:
719: IF (NVL (g_debug, 0) > 0) THEN
720: gme_debug.put_line ( g_pkg_name
721: || '.'
722: || l_api_name
723: || ':'
724: || 'OTHERS:'

Line 759: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

755: l_plan_qty NUMBER;
756: l_dtl_um gme_material_details.dtl_um%TYPE;
757: BEGIN
758: IF (NVL (g_debug, 0) IN
759: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
760: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
761: || 'Entering');
762: END IF;
763:

Line 760: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

756: l_dtl_um gme_material_details.dtl_um%TYPE;
757: BEGIN
758: IF (NVL (g_debug, 0) IN
759: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
760: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
761: || 'Entering');
762: END IF;
763:
764: /* Set the return status to success initially */

Line 824: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

820: RAISE fnd_api.g_exc_error;
821: END IF;
822:
823: IF (NVL (g_debug, 0) IN
824: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
825: gme_debug.put_line ( g_pkg_name
826: || '.'
827: || l_api_name
828: || ':'

Line 825: gme_debug.put_line ( g_pkg_name

821: END IF;
822:
823: IF (NVL (g_debug, 0) IN
824: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
825: gme_debug.put_line ( g_pkg_name
826: || '.'
827: || l_api_name
828: || ':'
829: || 'Exiting with '

Line 839: gme_debug.put_line ( g_pkg_name

835: WHEN fnd_api.g_exc_unexpected_error THEN
836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837:
838: IF (NVL (g_debug, 0) > 0) THEN
839: gme_debug.put_line ( g_pkg_name
840: || '.'
841: || l_api_name
842: || ':'
843: || 'UNEXPECTED:'

Line 851: gme_debug.put_line ( g_pkg_name

847: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
848: x_return_status := fnd_api.g_ret_sts_unexp_error;
849:
850: IF (NVL (g_debug, 0) > 0) THEN
851: gme_debug.put_line ( g_pkg_name
852: || '.'
853: || l_api_name
854: || ':'
855: || 'OTHERS:'

Line 916: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

912: l_conv_qty NUMBER;
913: l_count PLS_INTEGER;
914: BEGIN
915: IF (NVL (g_debug, 0) IN
916: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
917: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
918: || 'Entering');
919: END IF;
920:

Line 917: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

913: l_count PLS_INTEGER;
914: BEGIN
915: IF (NVL (g_debug, 0) IN
916: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
917: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
918: || 'Entering');
919: END IF;
920:
921: /* Set the return status to success initially */

Line 974: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

970: RAISE fnd_api.g_exc_error;
971: END IF;
972:
973: IF (NVL (g_debug, 0) IN
974: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
975: gme_debug.put_line ( g_pkg_name
976: || '.'
977: || l_api_name
978: || ':'

Line 975: gme_debug.put_line ( g_pkg_name

971: END IF;
972:
973: IF (NVL (g_debug, 0) IN
974: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
975: gme_debug.put_line ( g_pkg_name
976: || '.'
977: || l_api_name
978: || ':'
979: || 'Exiting with '

Line 989: gme_debug.put_line ( g_pkg_name

985: WHEN fnd_api.g_exc_unexpected_error THEN
986: x_return_status := fnd_api.g_ret_sts_unexp_error;
987:
988: IF (NVL (g_debug, 0) > 0) THEN
989: gme_debug.put_line ( g_pkg_name
990: || '.'
991: || l_api_name
992: || ':'
993: || 'UNEXPECTED:'

Line 1001: gme_debug.put_line ( g_pkg_name

997: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
998: x_return_status := fnd_api.g_ret_sts_unexp_error;
999:
1000: IF (NVL (g_debug, 0) > 0) THEN
1001: gme_debug.put_line ( g_pkg_name
1002: || '.'
1003: || l_api_name
1004: || ':'
1005: || 'OTHERS:'