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.GME_CREATE_BATCH_PVT dependencies on GME_DEBUG

Line 69: IF g_debug <= gme_debug.g_log_procedure THEN

65: IS
66: l_count NUMBER;
67: l_api_name CONSTANT VARCHAR2 (30) := 'CONSTRUCT_BATCH_HEADER';
68: BEGIN
69: IF g_debug <= gme_debug.g_log_procedure THEN
70: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
71: || l_api_name);
72: END IF;
73:

Line 70: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

66: l_count NUMBER;
67: l_api_name CONSTANT VARCHAR2 (30) := 'CONSTRUCT_BATCH_HEADER';
68: BEGIN
69: IF g_debug <= gme_debug.g_log_procedure THEN
70: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
71: || l_api_name);
72: END IF;
73:
74: /* Create defaults for mandatory columns that have not been specified */

Line 111: IF g_debug <= gme_debug.g_log_unexpected THEN

107: RETURN TRUE;
108: END IF;
109: EXCEPTION
110: WHEN OTHERS THEN
111: IF g_debug <= gme_debug.g_log_unexpected THEN
112: gme_debug.put_line ( 'When others exception in '
113: || g_pkg_name
114: || '.'
115: || l_api_name

Line 112: gme_debug.put_line ( 'When others exception in '

108: END IF;
109: EXCEPTION
110: WHEN OTHERS THEN
111: IF g_debug <= gme_debug.g_log_unexpected THEN
112: gme_debug.put_line ( 'When others exception in '
113: || g_pkg_name
114: || '.'
115: || l_api_name
116: || ' Error is '

Line 151: IF g_debug <= gme_debug.g_log_unexpected THEN

147: WHEN duplicate_wip_entity THEN
148: x_return_status := fnd_api.g_ret_sts_error;
149: gme_common_pvt.log_message('GME_WIP_ENTITY_EXISTS');
150: WHEN OTHERS THEN
151: IF g_debug <= gme_debug.g_log_unexpected THEN
152: gme_debug.put_line ( 'When others exception in '
153: || g_pkg_name
154: || '.'
155: || l_api_name

Line 152: gme_debug.put_line ( 'When others exception in '

148: x_return_status := fnd_api.g_ret_sts_error;
149: gme_common_pvt.log_message('GME_WIP_ENTITY_EXISTS');
150: WHEN OTHERS THEN
151: IF g_debug <= gme_debug.g_log_unexpected THEN
152: gme_debug.put_line ( 'When others exception in '
153: || g_pkg_name
154: || '.'
155: || l_api_name
156: || ' Error is '

Line 417: IF g_debug <= gme_debug.g_log_procedure THEN

413: Fixed_process_loss_failure EXCEPTION;
414: -- Rajesh Patangya Bug # 6752637
415: update_step_mtq_failure EXCEPTION;
416: BEGIN
417: IF g_debug <= gme_debug.g_log_procedure THEN
418: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
419: || l_api_name);
420: END IF;
421: x_return_status := fnd_api.g_ret_sts_success;

Line 418: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

414: -- Rajesh Patangya Bug # 6752637
415: update_step_mtq_failure EXCEPTION;
416: BEGIN
417: IF g_debug <= gme_debug.g_log_procedure THEN
418: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
419: || l_api_name);
420: END IF;
421: x_return_status := fnd_api.g_ret_sts_success;
422: -- Initialize output batch header

Line 444: IF g_debug <= gme_debug.g_log_procedure THEN

440: FETCH cur_get_doc_ord
441: INTO l_doc_numbering;
442:
443: CLOSE cur_get_doc_ord;
444: IF g_debug <= gme_debug.g_log_procedure THEN
445: gme_debug.put_line ('BEfore document numbering check' || g_pkg_name || '.'
446: || l_api_name);
447: END IF;
448: IF l_doc_numbering = 1 THEN

Line 445: gme_debug.put_line ('BEfore document numbering check' || g_pkg_name || '.'

441: INTO l_doc_numbering;
442:
443: CLOSE cur_get_doc_ord;
444: IF g_debug <= gme_debug.g_log_procedure THEN
445: gme_debug.put_line ('BEfore document numbering check' || g_pkg_name || '.'
446: || l_api_name);
447: END IF;
448: IF l_doc_numbering = 1 THEN
449: IF x_batch_header_rec.batch_no IS NULL THEN

Line 466: IF g_debug <= gme_debug.g_log_procedure THEN

462: RAISE gme_duplicate_batch;
463: END IF;
464: END IF; /* x_batch_header_rec.batch_no IS NULL */
465: END IF; /* IF l_doc_numbering = 1 */
466: IF g_debug <= gme_debug.g_log_procedure THEN
467: gme_debug.put_line ('before laboratory check' || g_pkg_name || '.'
468: || l_api_name);
469: END IF;
470:

Line 467: gme_debug.put_line ('before laboratory check' || g_pkg_name || '.'

463: END IF;
464: END IF; /* x_batch_header_rec.batch_no IS NULL */
465: END IF; /* IF l_doc_numbering = 1 */
466: IF g_debug <= gme_debug.g_log_procedure THEN
467: gme_debug.put_line ('before laboratory check' || g_pkg_name || '.'
468: || l_api_name);
469: END IF;
470:
471: IF (gme_common_pvt.g_lab_ind = 1 AND gme_common_pvt.g_plant_ind = 1) THEN

Line 488: IF g_debug <= gme_debug.g_log_procedure THEN

484: ELSIF (gme_common_pvt.g_plant_ind = 1) THEN
485: x_batch_header_rec.laboratory_ind := 0;
486: x_batch_header_rec.update_inventory_ind := 'Y';
487: END IF;
488: IF g_debug <= gme_debug.g_log_procedure THEN
489: gme_debug.put_line ('After laboratory check' || g_pkg_name || '.'
490: || l_api_name);
491: END IF;
492:

Line 489: gme_debug.put_line ('After laboratory check' || g_pkg_name || '.'

485: x_batch_header_rec.laboratory_ind := 0;
486: x_batch_header_rec.update_inventory_ind := 'Y';
487: END IF;
488: IF g_debug <= gme_debug.g_log_procedure THEN
489: gme_debug.put_line ('After laboratory check' || g_pkg_name || '.'
490: || l_api_name);
491: END IF;
492:
493: -- Validate/fill in batch header columns

Line 501: IF g_debug <= gme_debug.g_log_procedure THEN

497:
498: IF NOT l_return THEN
499: RAISE invalid_header_values;
500: END IF;
501: IF g_debug <= gme_debug.g_log_procedure THEN
502: gme_debug.put_line ('After contruct batch header' || g_pkg_name || '.'
503: || l_api_name);
504: END IF;
505:

Line 502: gme_debug.put_line ('After contruct batch header' || g_pkg_name || '.'

498: IF NOT l_return THEN
499: RAISE invalid_header_values;
500: END IF;
501: IF g_debug <= gme_debug.g_log_procedure THEN
502: gme_debug.put_line ('After contruct batch header' || g_pkg_name || '.'
503: || l_api_name);
504: END IF;
505:
506: IF g_debug <= gme_debug.g_log_statement THEN

Line 506: IF g_debug <= gme_debug.g_log_statement THEN

502: gme_debug.put_line ('After contruct batch header' || g_pkg_name || '.'
503: || l_api_name);
504: END IF;
505:
506: IF g_debug <= gme_debug.g_log_statement THEN
507: gme_debug.put_line ( g_pkg_name
508: || '.'
509: || l_api_name
510: || 'Starting Validity rule processing');

Line 507: gme_debug.put_line ( g_pkg_name

503: || l_api_name);
504: END IF;
505:
506: IF g_debug <= gme_debug.g_log_statement THEN
507: gme_debug.put_line ( g_pkg_name
508: || '.'
509: || l_api_name
510: || 'Starting Validity rule processing');
511: END IF;

Line 539: IF g_debug <= gme_debug.g_log_statement THEN

535: gme_common_pvt.log_message ('GME_API_INVALID_RULE');
536: RAISE expected_error;
537: END IF;
538:
539: IF g_debug <= gme_debug.g_log_statement THEN
540: gme_debug.put_line ( g_pkg_name
541: || '.'
542: || l_api_name
543: || 'Calling gmd_recipe_data_pub.get_recipe_data');

Line 540: gme_debug.put_line ( g_pkg_name

536: RAISE expected_error;
537: END IF;
538:
539: IF g_debug <= gme_debug.g_log_statement THEN
540: gme_debug.put_line ( g_pkg_name
541: || '.'
542: || l_api_name
543: || 'Calling gmd_recipe_data_pub.get_recipe_data');
544: END IF;

Line 564: IF g_debug <= gme_debug.g_log_statement THEN

560: ,x_oprn_resc_rec => gme_common_pvt.resources
561: ,x_formula_header_rec => l_formula_master
562: ,x_formula_dtl_tbl => gme_common_pvt.materials
563: ,x_recp_resc_proc_param_tbl => gme_common_pvt.process_parameters);
564: IF g_debug <= gme_debug.g_log_statement THEN
565: gme_debug.put_line
566: ( g_pkg_name
567: || '.'
568: || l_api_name

Line 565: gme_debug.put_line

561: ,x_formula_header_rec => l_formula_master
562: ,x_formula_dtl_tbl => gme_common_pvt.materials
563: ,x_recp_resc_proc_param_tbl => gme_common_pvt.process_parameters);
564: IF g_debug <= gme_debug.g_log_statement THEN
565: gme_debug.put_line
566: ( g_pkg_name
567: || '.'
568: || l_api_name
569: || 'Return from gmd_recipe_data_pub.get_recipe_data '

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

582: l_recipe.routing_id := gme_common_pvt.routings(1).routing_id;
583: END IF;
584: END IF; /* IF p_creation_mode <> 'LCF' THEN */
585:
586: IF (g_debug = gme_debug.g_log_statement) THEN
587: gme_debug.put_line ( g_pkg_name
588: || ':Creation mode '
589: || p_creation_mode
590: || ' Batch size '

Line 587: gme_debug.put_line ( g_pkg_name

583: END IF;
584: END IF; /* IF p_creation_mode <> 'LCF' THEN */
585:
586: IF (g_debug = gme_debug.g_log_statement) THEN
587: gme_debug.put_line ( g_pkg_name
588: || ':Creation mode '
589: || p_creation_mode
590: || ' Batch size '
591: || p_batch_size

Line 594: gme_debug.put_line ('Return Status was ' || l_return_status);

590: || ' Batch size '
591: || p_batch_size
592: || ' '
593: || p_batch_size_uom);
594: gme_debug.put_line ('Return Status was ' || l_return_status);
595: gme_debug.put_line ('return_code = ' || TO_CHAR (l_return_code) );
596: gme_debug.put_line ( '# of Steps = '
597: || TO_CHAR (gme_common_pvt.steps.COUNT) );
598: gme_debug.put_line ( '# of Acts = '

Line 595: gme_debug.put_line ('return_code = ' || TO_CHAR (l_return_code) );

591: || p_batch_size
592: || ' '
593: || p_batch_size_uom);
594: gme_debug.put_line ('Return Status was ' || l_return_status);
595: gme_debug.put_line ('return_code = ' || TO_CHAR (l_return_code) );
596: gme_debug.put_line ( '# of Steps = '
597: || TO_CHAR (gme_common_pvt.steps.COUNT) );
598: gme_debug.put_line ( '# of Acts = '
599: || TO_CHAR (gme_common_pvt.activities.COUNT) );

Line 596: gme_debug.put_line ( '# of Steps = '

592: || ' '
593: || p_batch_size_uom);
594: gme_debug.put_line ('Return Status was ' || l_return_status);
595: gme_debug.put_line ('return_code = ' || TO_CHAR (l_return_code) );
596: gme_debug.put_line ( '# of Steps = '
597: || TO_CHAR (gme_common_pvt.steps.COUNT) );
598: gme_debug.put_line ( '# of Acts = '
599: || TO_CHAR (gme_common_pvt.activities.COUNT) );
600: gme_debug.put_line ( '# of Rsrc = '

Line 598: gme_debug.put_line ( '# of Acts = '

594: gme_debug.put_line ('Return Status was ' || l_return_status);
595: gme_debug.put_line ('return_code = ' || TO_CHAR (l_return_code) );
596: gme_debug.put_line ( '# of Steps = '
597: || TO_CHAR (gme_common_pvt.steps.COUNT) );
598: gme_debug.put_line ( '# of Acts = '
599: || TO_CHAR (gme_common_pvt.activities.COUNT) );
600: gme_debug.put_line ( '# of Rsrc = '
601: || TO_CHAR (gme_common_pvt.resources.COUNT) );
602: gme_debug.put_line ( '# of Matl = '

Line 600: gme_debug.put_line ( '# of Rsrc = '

596: gme_debug.put_line ( '# of Steps = '
597: || TO_CHAR (gme_common_pvt.steps.COUNT) );
598: gme_debug.put_line ( '# of Acts = '
599: || TO_CHAR (gme_common_pvt.activities.COUNT) );
600: gme_debug.put_line ( '# of Rsrc = '
601: || TO_CHAR (gme_common_pvt.resources.COUNT) );
602: gme_debug.put_line ( '# of Matl = '
603: || TO_CHAR
604: (gme_common_pvt.routing_materials.COUNT) );

Line 602: gme_debug.put_line ( '# of Matl = '

598: gme_debug.put_line ( '# of Acts = '
599: || TO_CHAR (gme_common_pvt.activities.COUNT) );
600: gme_debug.put_line ( '# of Rsrc = '
601: || TO_CHAR (gme_common_pvt.resources.COUNT) );
602: gme_debug.put_line ( '# of Matl = '
603: || TO_CHAR
604: (gme_common_pvt.routing_materials.COUNT) );
605: gme_debug.put_line ( '# of Depd = '
606: || TO_CHAR

Line 605: gme_debug.put_line ( '# of Depd = '

601: || TO_CHAR (gme_common_pvt.resources.COUNT) );
602: gme_debug.put_line ( '# of Matl = '
603: || TO_CHAR
604: (gme_common_pvt.routing_materials.COUNT) );
605: gme_debug.put_line ( '# of Depd = '
606: || TO_CHAR
607: (gme_common_pvt.step_dependencies.COUNT) );
608: gme_debug.put_line ( '# of Lines = '
609: || TO_CHAR (gme_common_pvt.materials.COUNT) );

Line 608: gme_debug.put_line ( '# of Lines = '

604: (gme_common_pvt.routing_materials.COUNT) );
605: gme_debug.put_line ( '# of Depd = '
606: || TO_CHAR
607: (gme_common_pvt.step_dependencies.COUNT) );
608: gme_debug.put_line ( '# of Lines = '
609: || TO_CHAR (gme_common_pvt.materials.COUNT) );
610: END IF;
611:
612: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 645: IF g_debug <= gme_debug.g_log_statement THEN

641: l_number_of_formula_lines := 0;
642: l_total_input_qty := 0;
643: l_total_output_qty := 0;
644:
645: IF g_debug <= gme_debug.g_log_statement THEN
646: gme_debug.put_line ( g_pkg_name
647: || '.'
648: || l_api_name
649: || 'Start material processing');

Line 646: gme_debug.put_line ( g_pkg_name

642: l_total_input_qty := 0;
643: l_total_output_qty := 0;
644:
645: IF g_debug <= gme_debug.g_log_statement THEN
646: gme_debug.put_line ( g_pkg_name
647: || '.'
648: || l_api_name
649: || 'Start material processing');
650: END IF;

Line 754: IF g_debug <= gme_debug.g_log_statement THEN

750: END IF;
751: END IF; /* l_item_master.inventory_item_id IS NULL OR */
752: END LOOP; /* l_formula_material IN formula_details_cursor */
753:
754: IF g_debug <= gme_debug.g_log_statement THEN
755: gme_debug.put_line ( g_pkg_name
756: || '.'
757: || l_api_name
758: || 'Finished material processing');

Line 755: gme_debug.put_line ( g_pkg_name

751: END IF; /* l_item_master.inventory_item_id IS NULL OR */
752: END LOOP; /* l_formula_material IN formula_details_cursor */
753:
754: IF g_debug <= gme_debug.g_log_statement THEN
755: gme_debug.put_line ( g_pkg_name
756: || '.'
757: || l_api_name
758: || 'Finished material processing');
759: END IF;

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

845: ,NULL
846: ,NULL);
847:
848: IF l_temp_qty < 0 THEN
849: IF (g_debug = gme_debug.g_log_statement) THEN
850: gme_debug.put_line
851: ('Failed in UOM Conv from formula product UOM to requested UOM');
852: END IF;
853:

Line 850: gme_debug.put_line

846: ,NULL);
847:
848: IF l_temp_qty < 0 THEN
849: IF (g_debug = gme_debug.g_log_statement) THEN
850: gme_debug.put_line
851: ('Failed in UOM Conv from formula product UOM to requested UOM');
852: END IF;
853:
854: l_item_id :=

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

902: IF production_rules_cursor%NOTFOUND THEN
903: l_primaries := 'OUTPUTS';
904: gme_common_pvt.g_batch_scale_factor := 1;
905:
906: IF (g_debug = gme_debug.g_log_statement) THEN
907: gme_debug.put_line
908: ('CREATING BY RECIPE/VERSION WITHOUT SCALING');
909: END IF;
910: ELSE

Line 907: gme_debug.put_line

903: l_primaries := 'OUTPUTS';
904: gme_common_pvt.g_batch_scale_factor := 1;
905:
906: IF (g_debug = gme_debug.g_log_statement) THEN
907: gme_debug.put_line
908: ('CREATING BY RECIPE/VERSION WITHOUT SCALING');
909: END IF;
910: ELSE
911: l_total_output_qty := 0;

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

929: ,NULL
930: ,NULL);
931:
932: IF l_temp_qty < 0 THEN
933: IF (g_debug = gme_debug.g_log_statement) THEN
934: gme_debug.put_line
935: ('Failed in UOM Conv from formula product UOM to requested UOM');
936: END IF;
937:

Line 934: gme_debug.put_line

930: ,NULL);
931:
932: IF l_temp_qty < 0 THEN
933: IF (g_debug = gme_debug.g_log_statement) THEN
934: gme_debug.put_line
935: ('Failed in UOM Conv from formula product UOM to requested UOM');
936: END IF;
937:
938: l_item_id :=

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

1032: ,NULL
1033: ,NULL);
1034:
1035: IF l_temp_qty < 0 THEN
1036: IF (g_debug = gme_debug.g_log_statement) THEN
1037: gme_debug.put_line
1038: ('Failed in UOM Conv from formula product UOM to routing UOM');
1039: END IF;
1040:

Line 1037: gme_debug.put_line

1033: ,NULL);
1034:
1035: IF l_temp_qty < 0 THEN
1036: IF (g_debug = gme_debug.g_log_statement) THEN
1037: gme_debug.put_line
1038: ('Failed in UOM Conv from formula product UOM to routing UOM');
1039: END IF;
1040:
1041: l_item_id :=

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

1051: END IF;
1052: /* l_material_details(loop_count).line_type IN (1, 2) */
1053: END LOOP; /* loop_count IN 1 .. l_number_of_formula_lines */
1054:
1055: IF (g_debug = gme_debug.g_log_statement) THEN
1056: gme_debug.put_line ( 'tot_output before scaling is '
1057: || TO_CHAR (l_total_output_qty_c) );
1058: END IF;
1059: END IF; /* IF gme_common_pvt.routings.COUNT <> 0 */

Line 1056: gme_debug.put_line ( 'tot_output before scaling is '

1052: /* l_material_details(loop_count).line_type IN (1, 2) */
1053: END LOOP; /* loop_count IN 1 .. l_number_of_formula_lines */
1054:
1055: IF (g_debug = gme_debug.g_log_statement) THEN
1056: gme_debug.put_line ( 'tot_output before scaling is '
1057: || TO_CHAR (l_total_output_qty_c) );
1058: END IF;
1059: END IF; /* IF gme_common_pvt.routings.COUNT <> 0 */
1060:

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

1058: END IF;
1059: END IF; /* IF gme_common_pvt.routings.COUNT <> 0 */
1060:
1061: IF gme_common_pvt.g_batch_scale_factor <> 1 THEN
1062: IF (g_debug = gme_debug.g_log_statement) THEN
1063: gme_debug.put_line
1064: ( 'scale factor is '
1065: || TO_CHAR
1066: (gme_common_pvt.g_batch_scale_factor) );

Line 1063: gme_debug.put_line

1059: END IF; /* IF gme_common_pvt.routings.COUNT <> 0 */
1060:
1061: IF gme_common_pvt.g_batch_scale_factor <> 1 THEN
1062: IF (g_debug = gme_debug.g_log_statement) THEN
1063: gme_debug.put_line
1064: ( 'scale factor is '
1065: || TO_CHAR
1066: (gme_common_pvt.g_batch_scale_factor) );
1067: END IF;

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

1091: /* Create batch does not need any values from here so dummy variable */
1092: x_return_status => x_return_status);
1093: x_batch_header_rec.batch_status := gme_common_pvt.g_batch_pending;
1094:
1095: IF (g_debug = gme_debug.g_log_statement) THEN
1096: gme_debug.put_line ( 'return from scale_batch is: '
1097: || x_return_status);
1098: END IF;
1099:

Line 1096: gme_debug.put_line ( 'return from scale_batch is: '

1092: x_return_status => x_return_status);
1093: x_batch_header_rec.batch_status := gme_common_pvt.g_batch_pending;
1094:
1095: IF (g_debug = gme_debug.g_log_statement) THEN
1096: gme_debug.put_line ( 'return from scale_batch is: '
1097: || x_return_status);
1098: END IF;
1099:
1100: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

1152: ,NULL
1153: ,NULL);
1154:
1155: IF l_temp_qty < 0 THEN
1156: IF (g_debug = gme_debug.g_log_statement) THEN
1157: gme_debug.put_line
1158: ('Failed in UOM Conv from formula product UOM to routing UOM');
1159: END IF;
1160:

Line 1157: gme_debug.put_line

1153: ,NULL);
1154:
1155: IF l_temp_qty < 0 THEN
1156: IF (g_debug = gme_debug.g_log_statement) THEN
1157: gme_debug.put_line
1158: ('Failed in UOM Conv from formula product UOM to routing UOM');
1159: END IF;
1160:
1161: l_item_id :=

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

1171: END IF; /* IF routing and formula uoms are same */
1172: END IF; /* If line type > 0 */
1173: END LOOP;
1174:
1175: IF (g_debug = gme_debug.g_log_statement) THEN
1176: gme_debug.put_line ( 'Total Output after scaling is '
1177: || TO_CHAR (l_total_output_qty_b) );
1178: END IF;
1179: END IF; /* IF gme_common_pvt.routings.COUNT <> 0 */

Line 1176: gme_debug.put_line ( 'Total Output after scaling is '

1172: END IF; /* If line type > 0 */
1173: END LOOP;
1174:
1175: IF (g_debug = gme_debug.g_log_statement) THEN
1176: gme_debug.put_line ( 'Total Output after scaling is '
1177: || TO_CHAR (l_total_output_qty_b) );
1178: END IF;
1179: END IF; /* IF gme_common_pvt.routings.COUNT <> 0 */
1180: END IF; /* IF gme_common_pvt.g_batch_scale_factor <> 1 */

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

1216: l_material_details (l_row_count).original_qty :=
1217: l_material_details (l_row_count).plan_qty;
1218: END LOOP; /* l_row_count IN 1 .. l_number_of_formula_lines */
1219:
1220: IF (g_debug = gme_debug.g_log_statement) THEN
1221: gme_debug.put_line ( 'Total Output after Process Loss is '
1222: || TO_CHAR (l_total_output_qty_b) );
1223: END IF;
1224: END IF; /* IF p_creation_mode <> 'LCF' THEN */

Line 1221: gme_debug.put_line ( 'Total Output after Process Loss is '

1217: l_material_details (l_row_count).plan_qty;
1218: END LOOP; /* l_row_count IN 1 .. l_number_of_formula_lines */
1219:
1220: IF (g_debug = gme_debug.g_log_statement) THEN
1221: gme_debug.put_line ( 'Total Output after Process Loss is '
1222: || TO_CHAR (l_total_output_qty_b) );
1223: END IF;
1224: END IF; /* IF p_creation_mode <> 'LCF' THEN */
1225:

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

1273:
1274: gme_common_pvt.g_routing_scale_factor :=
1275: l_total_output_qty_b / l_total_output_qty_c;
1276:
1277: IF (g_debug = gme_debug.g_log_statement) THEN
1278: gme_debug.put_line ( 'Routing scale factor is '
1279: || gme_common_pvt.g_routing_scale_factor);
1280: END IF;
1281: END IF; /* IF gme_common_pvt.routings.COUNT <> 0 */

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

1274: gme_common_pvt.g_routing_scale_factor :=
1275: l_total_output_qty_b / l_total_output_qty_c;
1276:
1277: IF (g_debug = gme_debug.g_log_statement) THEN
1278: gme_debug.put_line ( 'Routing scale factor is '
1279: || gme_common_pvt.g_routing_scale_factor);
1280: END IF;
1281: END IF; /* IF gme_common_pvt.routings.COUNT <> 0 */
1282: ELSE /* IF l_formula_master.scale_type <> 1 */

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

1286: END IF;
1287:
1288: -- Fixed Process Loss ME
1289:
1290: IF (g_debug = gme_debug.g_log_statement) THEN
1291: gme_debug.put_line ('Before calling the Fixed Proccess Loss '
1292: || p_batch_header_rec.fixed_process_loss_applied);
1293: END IF;
1294:

Line 1291: gme_debug.put_line ('Before calling the Fixed Proccess Loss '

1287:
1288: -- Fixed Process Loss ME
1289:
1290: IF (g_debug = gme_debug.g_log_statement) THEN
1291: gme_debug.put_line ('Before calling the Fixed Proccess Loss '
1292: || p_batch_header_rec.fixed_process_loss_applied);
1293: END IF;
1294:
1295: IF(p_batch_header_rec.fixed_process_loss_applied = 'Y') THEN

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

1304: ,x_batch_header_rec => x_batch_header_rec
1305: ,x_material_tbl => l_material_details
1306: ,x_return_status => x_return_status
1307: );
1308: IF (g_debug = gme_debug.g_log_statement) THEN
1309: gme_debug.put_line ('Return status after apply Fixed Proccess Loss '
1310: || x_return_status);
1311: END IF;
1312: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 1309: gme_debug.put_line ('Return status after apply Fixed Proccess Loss '

1305: ,x_material_tbl => l_material_details
1306: ,x_return_status => x_return_status
1307: );
1308: IF (g_debug = gme_debug.g_log_statement) THEN
1309: gme_debug.put_line ('Return status after apply Fixed Proccess Loss '
1310: || x_return_status);
1311: END IF;
1312: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1313: RAISE Fixed_process_loss_failure;

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

1311: END IF;
1312: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1313: RAISE Fixed_process_loss_failure;
1314: ELSE
1315: IF (g_debug = gme_debug.g_log_statement) THEN
1316: gme_debug.put_line ('Return from Apply Fixed Proccess Loss is ' || x_return_status);
1317: END IF;
1318: END IF;
1319: END IF;

Line 1316: gme_debug.put_line ('Return from Apply Fixed Proccess Loss is ' || x_return_status);

1312: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1313: RAISE Fixed_process_loss_failure;
1314: ELSE
1315: IF (g_debug = gme_debug.g_log_statement) THEN
1316: gme_debug.put_line ('Return from Apply Fixed Proccess Loss is ' || x_return_status);
1317: END IF;
1318: END IF;
1319: END IF;
1320:

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

1318: END IF;
1319: END IF;
1320:
1321: -- Fixed Process Loss ME
1322: IF (g_debug = gme_debug.g_log_statement) THEN
1323: gme_debug.put_line ('After calling Apply Fixed Proccess Loss return is' || x_return_status);
1324: gme_debug.put_line ('fnd return is ' || fnd_api.g_ret_sts_success);
1325: END IF;
1326:

Line 1323: gme_debug.put_line ('After calling Apply Fixed Proccess Loss return is' || x_return_status);

1319: END IF;
1320:
1321: -- Fixed Process Loss ME
1322: IF (g_debug = gme_debug.g_log_statement) THEN
1323: gme_debug.put_line ('After calling Apply Fixed Proccess Loss return is' || x_return_status);
1324: gme_debug.put_line ('fnd return is ' || fnd_api.g_ret_sts_success);
1325: END IF;
1326:
1327: -- If we've found any errors, don't start the updates.

Line 1324: gme_debug.put_line ('fnd return is ' || fnd_api.g_ret_sts_success);

1320:
1321: -- Fixed Process Loss ME
1322: IF (g_debug = gme_debug.g_log_statement) THEN
1323: gme_debug.put_line ('After calling Apply Fixed Proccess Loss return is' || x_return_status);
1324: gme_debug.put_line ('fnd return is ' || fnd_api.g_ret_sts_success);
1325: END IF;
1326:
1327: -- If we've found any errors, don't start the updates.
1328: -- IF gme_common_pvt.g_error_count > 0 THEN

Line 1332: IF g_debug <= gme_debug.g_log_statement THEN

1328: -- IF gme_common_pvt.g_error_count > 0 THEN
1329: -- RAISE expected_error;
1330: -- END IF;
1331:
1332: IF g_debug <= gme_debug.g_log_statement THEN
1333: gme_debug.put_line ( g_pkg_name
1334: || '.'
1335: || l_api_name
1336: || 'Start dbl pcrocessing');

Line 1333: gme_debug.put_line ( g_pkg_name

1329: -- RAISE expected_error;
1330: -- END IF;
1331:
1332: IF g_debug <= gme_debug.g_log_statement THEN
1333: gme_debug.put_line ( g_pkg_name
1334: || '.'
1335: || l_api_name
1336: || 'Start dbl pcrocessing');
1337: END IF;

Line 1350: IF g_debug <= gme_debug.g_log_statement THEN

1346: gme_common_pvt.create_document_no (l_in_batch_header
1347: ,x_batch_header_rec);*/
1348: SELECT trim(TO_CHAR(systimestamp,'DD:MM:YYYY HH24:MI:SS:FF6')) INTO l_doc_timestamp FROM DUAL;
1349:
1350: IF g_debug <= gme_debug.g_log_statement THEN
1351: gme_debug.put_line ( g_pkg_name
1352: || '.'
1353: || l_api_name
1354: || 'Initial Doc No(timestamp): '||l_doc_timestamp);

Line 1351: gme_debug.put_line ( g_pkg_name

1347: ,x_batch_header_rec);*/
1348: SELECT trim(TO_CHAR(systimestamp,'DD:MM:YYYY HH24:MI:SS:FF6')) INTO l_doc_timestamp FROM DUAL;
1349:
1350: IF g_debug <= gme_debug.g_log_statement THEN
1351: gme_debug.put_line ( g_pkg_name
1352: || '.'
1353: || l_api_name
1354: || 'Initial Doc No(timestamp): '||l_doc_timestamp);
1355: END IF;

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

1385:
1386: l_number_of_text_lines := 0;
1387:
1388: --Bug#5112133 add some debug messages for copy formula text GME Parameter
1389: IF (g_debug = gme_debug.g_log_statement) THEN
1390: gme_debug.put_line ('copy_formula_text_ind = '||gme_common_pvt.g_copy_formula_text_ind);
1391: END IF;
1392: -- If the formula has text and we have to copy it then generate
1393: -- the text header row first as database constraints impose this

Line 1390: gme_debug.put_line ('copy_formula_text_ind = '||gme_common_pvt.g_copy_formula_text_ind);

1386: l_number_of_text_lines := 0;
1387:
1388: --Bug#5112133 add some debug messages for copy formula text GME Parameter
1389: IF (g_debug = gme_debug.g_log_statement) THEN
1390: gme_debug.put_line ('copy_formula_text_ind = '||gme_common_pvt.g_copy_formula_text_ind);
1391: END IF;
1392: -- If the formula has text and we have to copy it then generate
1393: -- the text header row first as database constraints impose this
1394: IF gme_common_pvt.g_copy_formula_text_ind = 1

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

1399: IF l_return THEN
1400: x_batch_header_rec.text_code := l_text_header.text_code;
1401: ELSE
1402: --Bug#5112133
1403: IF (g_debug = gme_debug.g_log_statement) THEN
1404: gme_debug.put_line ('Error in inserting text code = '||l_formula_master.text_code);
1405: END IF;
1406: -- We could not insert the text header. Panic
1407: RAISE expected_error;

Line 1404: gme_debug.put_line ('Error in inserting text code = '||l_formula_master.text_code);

1400: x_batch_header_rec.text_code := l_text_header.text_code;
1401: ELSE
1402: --Bug#5112133
1403: IF (g_debug = gme_debug.g_log_statement) THEN
1404: gme_debug.put_line ('Error in inserting text code = '||l_formula_master.text_code);
1405: END IF;
1406: -- We could not insert the text header. Panic
1407: RAISE expected_error;
1408: END IF;

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

1455: IF l_return = TRUE THEN
1456:
1457: IF x_batch_header_rec.text_code IS NOT NULL THEN
1458: --Bug#5112133
1459: IF (g_debug = gme_debug.g_log_statement) THEN
1460: gme_debug.put_line ('x_batch_header_rec.text_code = '||x_batch_header_rec.text_code);
1461: gme_debug.put_line ('Inserting formula header text in batch header edit text');
1462: END IF;
1463: FOR l_fm_text_tbl_row IN

Line 1460: gme_debug.put_line ('x_batch_header_rec.text_code = '||x_batch_header_rec.text_code);

1456:
1457: IF x_batch_header_rec.text_code IS NOT NULL THEN
1458: --Bug#5112133
1459: IF (g_debug = gme_debug.g_log_statement) THEN
1460: gme_debug.put_line ('x_batch_header_rec.text_code = '||x_batch_header_rec.text_code);
1461: gme_debug.put_line ('Inserting formula header text in batch header edit text');
1462: END IF;
1463: FOR l_fm_text_tbl_row IN
1464: fm_text_tbl_cursor (l_formula_master.text_code) LOOP

Line 1461: gme_debug.put_line ('Inserting formula header text in batch header edit text');

1457: IF x_batch_header_rec.text_code IS NOT NULL THEN
1458: --Bug#5112133
1459: IF (g_debug = gme_debug.g_log_statement) THEN
1460: gme_debug.put_line ('x_batch_header_rec.text_code = '||x_batch_header_rec.text_code);
1461: gme_debug.put_line ('Inserting formula header text in batch header edit text');
1462: END IF;
1463: FOR l_fm_text_tbl_row IN
1464: fm_text_tbl_cursor (l_formula_master.text_code) LOOP
1465: l_number_of_text_lines := l_number_of_text_lines + 1;

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

1488: END LOOP;
1489: END IF;
1490:
1491: --Bug#5112133
1492: IF (g_debug = gme_debug.g_log_statement) THEN
1493: gme_debug.put_line ('l_number_of_formula_lines = '||l_number_of_formula_lines);
1494: END IF;
1495:
1496: FOR l_row_count IN 1 .. l_number_of_formula_lines LOOP

Line 1493: gme_debug.put_line ('l_number_of_formula_lines = '||l_number_of_formula_lines);

1489: END IF;
1490:
1491: --Bug#5112133
1492: IF (g_debug = gme_debug.g_log_statement) THEN
1493: gme_debug.put_line ('l_number_of_formula_lines = '||l_number_of_formula_lines);
1494: END IF;
1495:
1496: FOR l_row_count IN 1 .. l_number_of_formula_lines LOOP
1497: -- Create rows for details' text.

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

1494: END IF;
1495:
1496: FOR l_row_count IN 1 .. l_number_of_formula_lines LOOP
1497: -- Create rows for details' text.
1498: IF (g_debug = gme_debug.g_log_statement) THEN
1499: gme_debug.put_line ('l text code is '||l_material_details (l_row_count).text_code);
1500: END IF;
1501: IF l_material_details (l_row_count).text_code IS NOT NULL
1502: AND gme_common_pvt.g_copy_formula_text_ind = 1 THEN

Line 1499: gme_debug.put_line ('l text code is '||l_material_details (l_row_count).text_code);

1495:
1496: FOR l_row_count IN 1 .. l_number_of_formula_lines LOOP
1497: -- Create rows for details' text.
1498: IF (g_debug = gme_debug.g_log_statement) THEN
1499: gme_debug.put_line ('l text code is '||l_material_details (l_row_count).text_code);
1500: END IF;
1501: IF l_material_details (l_row_count).text_code IS NOT NULL
1502: AND gme_common_pvt.g_copy_formula_text_ind = 1 THEN
1503: l_text_code := l_material_details (l_row_count).text_code;

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

1547: END LOOP; -- text lines loop.
1548: ELSE
1549: -- We could not insert the text header. Panic
1550: --Bug#5112133
1551: IF (g_debug = gme_debug.g_log_statement) THEN
1552: gme_debug.put_line ('Error in inserting text header');
1553: END IF;
1554: RAISE expected_error;
1555: END IF;

Line 1552: gme_debug.put_line ('Error in inserting text header');

1548: ELSE
1549: -- We could not insert the text header. Panic
1550: --Bug#5112133
1551: IF (g_debug = gme_debug.g_log_statement) THEN
1552: gme_debug.put_line ('Error in inserting text header');
1553: END IF;
1554: RAISE expected_error;
1555: END IF;
1556: END IF;

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

1593: END IF;
1594:
1595: END IF;
1596: -- GMO changes end
1597: IF (g_debug = gme_debug.g_log_statement) THEN
1598: gme_debug.put_line ('MATERTIAL lines to be INSERTED ' || l_row_count);
1599: END IF;
1600:
1601: l_return :=

Line 1598: gme_debug.put_line ('MATERTIAL lines to be INSERTED ' || l_row_count);

1594:
1595: END IF;
1596: -- GMO changes end
1597: IF (g_debug = gme_debug.g_log_statement) THEN
1598: gme_debug.put_line ('MATERTIAL lines to be INSERTED ' || l_row_count);
1599: END IF;
1600:
1601: l_return :=
1602: gme_material_details_dbl.insert_row

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

1602: gme_material_details_dbl.insert_row
1603: (l_material_details (l_row_count)
1604: ,l_material_details (l_row_count) );
1605:
1606: IF (g_debug = gme_debug.g_log_statement) THEN
1607: gme_debug.put_line ('MATERTIAL_INSERTED');
1608: END IF;
1609:
1610: IF NOT l_return THEN

Line 1607: gme_debug.put_line ('MATERTIAL_INSERTED');

1603: (l_material_details (l_row_count)
1604: ,l_material_details (l_row_count) );
1605:
1606: IF (g_debug = gme_debug.g_log_statement) THEN
1607: gme_debug.put_line ('MATERTIAL_INSERTED');
1608: END IF;
1609:
1610: IF NOT l_return THEN
1611: RAISE unexpected_error;

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

1612: END IF;
1613: -- Pawan Kumar added for bug 4947535
1614:
1615: IF (l_config_id IS NOT NULL AND l_material_details(l_row_count).dispense_ind = 'Y') then
1616: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1617: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'Instantiating material line id'
1618: || l_material_details (l_row_count).material_detail_id);
1619: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' config id ' || l_config_id);
1620: END IF;

Line 1617: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'Instantiating material line id'

1613: -- Pawan Kumar added for bug 4947535
1614:
1615: IF (l_config_id IS NOT NULL AND l_material_details(l_row_count).dispense_ind = 'Y') then
1616: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1617: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'Instantiating material line id'
1618: || l_material_details (l_row_count).material_detail_id);
1619: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' config id ' || l_config_id);
1620: END IF;
1621: GMO_DISPENSE_GRP.INSTANTIATE_DISPENSE_SETUP

Line 1619: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' config id ' || l_config_id);

1615: IF (l_config_id IS NOT NULL AND l_material_details(l_row_count).dispense_ind = 'Y') then
1616: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1617: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'Instantiating material line id'
1618: || l_material_details (l_row_count).material_detail_id);
1619: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' config id ' || l_config_id);
1620: END IF;
1621: GMO_DISPENSE_GRP.INSTANTIATE_DISPENSE_SETUP
1622: (p_api_version => 1.0
1623: ,p_dispense_config_id => l_config_id

Line 1680: IF g_debug <= gme_debug.g_log_statement THEN

1676: END IF;
1677:
1678: CLOSE get_prim_prod;
1679:
1680: IF g_debug <= gme_debug.g_log_statement THEN
1681: gme_debug.put_line ( g_pkg_name
1682: || '.'
1683: || l_api_name
1684: || 'Start step processing');

Line 1681: gme_debug.put_line ( g_pkg_name

1677:
1678: CLOSE get_prim_prod;
1679:
1680: IF g_debug <= gme_debug.g_log_statement THEN
1681: gme_debug.put_line ( g_pkg_name
1682: || '.'
1683: || l_api_name
1684: || 'Start step processing');
1685: END IF;

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

1759: x_batch_header_rec.plan_cmplt_date :=
1760: gme_common_pvt.g_timestamp;
1761: END IF;
1762:
1763: IF (g_debug = gme_debug.g_log_statement) THEN
1764: gme_debug.put_line
1765: ( 'production rule start_date '
1766: || TO_CHAR
1767: (x_batch_header_rec.plan_start_date

Line 1764: gme_debug.put_line

1760: gme_common_pvt.g_timestamp;
1761: END IF;
1762:
1763: IF (g_debug = gme_debug.g_log_statement) THEN
1764: gme_debug.put_line
1765: ( 'production rule start_date '
1766: || TO_CHAR
1767: (x_batch_header_rec.plan_start_date
1768: ,'DD-MON-YYYY HH24:MI:SS') );

Line 1769: gme_debug.put_line

1765: ( 'production rule start_date '
1766: || TO_CHAR
1767: (x_batch_header_rec.plan_start_date
1768: ,'DD-MON-YYYY HH24:MI:SS') );
1769: gme_debug.put_line
1770: ( 'production rule end_date '
1771: || TO_CHAR
1772: (x_batch_header_rec.plan_cmplt_date
1773: ,'DD-MON-YYYY HH24:MI:SS') );

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

1781: ,x_contiguous_ind => l_cont_ind
1782: ,x_return_status => l_return_status);
1783:
1784: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1785: IF (g_debug = gme_debug.g_log_statement) THEN
1786: gme_debug.put_line
1787: ( 'GMD_RECIPE_FETCH_PUB.FETCH_CONTIGUOUS_IND returned error '
1788: || l_return_status);
1789: END IF;

Line 1786: gme_debug.put_line

1782: ,x_return_status => l_return_status);
1783:
1784: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1785: IF (g_debug = gme_debug.g_log_statement) THEN
1786: gme_debug.put_line
1787: ( 'GMD_RECIPE_FETCH_PUB.FETCH_CONTIGUOUS_IND returned error '
1788: || l_return_status);
1789: END IF;
1790:

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

1790:
1791: l_cont_ind := 0;
1792: END IF;
1793:
1794: IF (g_debug = gme_debug.g_log_statement) THEN
1795: gme_debug.put_line ( 'Calendar code found '
1796: || gme_common_pvt.g_calendar_code);
1797: gme_debug.put_line ('Cont ID found ' || l_cont_ind);
1798: END IF;

Line 1795: gme_debug.put_line ( 'Calendar code found '

1791: l_cont_ind := 0;
1792: END IF;
1793:
1794: IF (g_debug = gme_debug.g_log_statement) THEN
1795: gme_debug.put_line ( 'Calendar code found '
1796: || gme_common_pvt.g_calendar_code);
1797: gme_debug.put_line ('Cont ID found ' || l_cont_ind);
1798: END IF;
1799:

Line 1797: gme_debug.put_line ('Cont ID found ' || l_cont_ind);

1793:
1794: IF (g_debug = gme_debug.g_log_statement) THEN
1795: gme_debug.put_line ( 'Calendar code found '
1796: || gme_common_pvt.g_calendar_code);
1797: gme_debug.put_line ('Cont ID found ' || l_cont_ind);
1798: END IF;
1799:
1800: l_duration :=
1801: ( x_batch_header_rec.plan_cmplt_date

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

1801: ( x_batch_header_rec.plan_cmplt_date
1802: - x_batch_header_rec.plan_start_date)
1803: * 24;
1804:
1805: IF (g_debug = gme_debug.g_log_statement) THEN
1806: gme_debug.put_line ('l duration ' || l_duration);
1807: END IF;
1808:
1809: IF p_batch_header_rec.plan_start_date IS NOT NULL

Line 1806: gme_debug.put_line ('l duration ' || l_duration);

1802: - x_batch_header_rec.plan_start_date)
1803: * 24;
1804:
1805: IF (g_debug = gme_debug.g_log_statement) THEN
1806: gme_debug.put_line ('l duration ' || l_duration);
1807: END IF;
1808:
1809: IF p_batch_header_rec.plan_start_date IS NOT NULL
1810: OR ( p_batch_header_rec.plan_start_date IS NULL

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

1826: END IF;
1827:
1828: l_cal_count := l_contig_period_tbl.COUNT;
1829:
1830: IF (g_debug = gme_debug.g_log_statement) THEN
1831: gme_debug.put_line ('l cal_count ' || l_cal_count);
1832: gme_debug.put_line ( 'p_contiguity_override '
1833: || p_contiguity_override);
1834: END IF;

Line 1831: gme_debug.put_line ('l cal_count ' || l_cal_count);

1827:
1828: l_cal_count := l_contig_period_tbl.COUNT;
1829:
1830: IF (g_debug = gme_debug.g_log_statement) THEN
1831: gme_debug.put_line ('l cal_count ' || l_cal_count);
1832: gme_debug.put_line ( 'p_contiguity_override '
1833: || p_contiguity_override);
1834: END IF;
1835:

Line 1832: gme_debug.put_line ( 'p_contiguity_override '

1828: l_cal_count := l_contig_period_tbl.COUNT;
1829:
1830: IF (g_debug = gme_debug.g_log_statement) THEN
1831: gme_debug.put_line ('l cal_count ' || l_cal_count);
1832: gme_debug.put_line ( 'p_contiguity_override '
1833: || p_contiguity_override);
1834: END IF;
1835:
1836: IF l_cont_ind = 1

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

1859: END IF;
1860:
1861: l_cal_count := l_contig_period_tbl.COUNT;
1862:
1863: IF (g_debug = gme_debug.g_log_statement) THEN
1864: gme_debug.put_line ('l cal_count ' || l_cal_count);
1865: gme_debug.put_line ( 'p_contiguity_override '
1866: || p_contiguity_override);
1867: END IF;

Line 1864: gme_debug.put_line ('l cal_count ' || l_cal_count);

1860:
1861: l_cal_count := l_contig_period_tbl.COUNT;
1862:
1863: IF (g_debug = gme_debug.g_log_statement) THEN
1864: gme_debug.put_line ('l cal_count ' || l_cal_count);
1865: gme_debug.put_line ( 'p_contiguity_override '
1866: || p_contiguity_override);
1867: END IF;
1868:

Line 1865: gme_debug.put_line ( 'p_contiguity_override '

1861: l_cal_count := l_contig_period_tbl.COUNT;
1862:
1863: IF (g_debug = gme_debug.g_log_statement) THEN
1864: gme_debug.put_line ('l cal_count ' || l_cal_count);
1865: gme_debug.put_line ( 'p_contiguity_override '
1866: || p_contiguity_override);
1867: END IF;
1868:
1869: IF l_cont_ind = 1

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

1915: AND wip_entity_name = l_prefix||l_doc_timestamp;
1916: --5698727
1917: END IF;
1918:
1919: IF (g_debug = gme_debug.g_log_statement) THEN
1920: gme_debug.put_line ( 'Calculated Start date is '
1921: || TO_CHAR (x_batch_header_rec.plan_start_date
1922: ,'DD-MON-YYYY HH24:MI:SS') );
1923: gme_debug.put_line ( 'Calculated Cmplt date is '

Line 1920: gme_debug.put_line ( 'Calculated Start date is '

1916: --5698727
1917: END IF;
1918:
1919: IF (g_debug = gme_debug.g_log_statement) THEN
1920: gme_debug.put_line ( 'Calculated Start date is '
1921: || TO_CHAR (x_batch_header_rec.plan_start_date
1922: ,'DD-MON-YYYY HH24:MI:SS') );
1923: gme_debug.put_line ( 'Calculated Cmplt date is '
1924: || TO_CHAR (x_batch_header_rec.plan_cmplt_date

Line 1923: gme_debug.put_line ( 'Calculated Cmplt date is '

1919: IF (g_debug = gme_debug.g_log_statement) THEN
1920: gme_debug.put_line ( 'Calculated Start date is '
1921: || TO_CHAR (x_batch_header_rec.plan_start_date
1922: ,'DD-MON-YYYY HH24:MI:SS') );
1923: gme_debug.put_line ( 'Calculated Cmplt date is '
1924: || TO_CHAR (x_batch_header_rec.plan_cmplt_date
1925: ,'DD-MON-YYYY HH24:MI:SS') );
1926: END IF;
1927:

Line 1979: IF g_debug <= gme_debug.g_log_statement THEN

1975: ,x_batch_header_rec) ) THEN
1976: RAISE batch_header_fetch_failure;
1977: END IF;
1978:
1979: IF g_debug <= gme_debug.g_log_statement THEN
1980: gme_debug.put_line ( g_pkg_name
1981: || '.'
1982: || l_api_name
1983: || 'Calculate mtl req date');

Line 1980: gme_debug.put_line ( g_pkg_name

1976: RAISE batch_header_fetch_failure;
1977: END IF;
1978:
1979: IF g_debug <= gme_debug.g_log_statement THEN
1980: gme_debug.put_line ( g_pkg_name
1981: || '.'
1982: || l_api_name
1983: || 'Calculate mtl req date');
1984: END IF;

Line 2019: IF g_debug <= gme_debug.g_log_statement THEN

2015: ELSIF gme_common_pvt.g_ingr_sub_date = 3 THEN
2016: l_ingred_req_date := NVL(p_batch_header_rec.plan_cmplt_date, x_batch_header_rec.plan_cmplt_date);
2017: END IF;
2018:
2019: IF g_debug <= gme_debug.g_log_statement THEN
2020: gme_debug.put_line ( g_pkg_name||'.'|| l_api_name
2021: || ' l_ingred_req_date '||TO_CHAR(l_ingred_req_date, 'MON-DD-YYYY HH24:MI:SS'));
2022: END IF;
2023:

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

2016: l_ingred_req_date := NVL(p_batch_header_rec.plan_cmplt_date, x_batch_header_rec.plan_cmplt_date);
2017: END IF;
2018:
2019: IF g_debug <= gme_debug.g_log_statement THEN
2020: gme_debug.put_line ( g_pkg_name||'.'|| l_api_name
2021: || ' l_ingred_req_date '||TO_CHAR(l_ingred_req_date, 'MON-DD-YYYY HH24:MI:SS'));
2022: END IF;
2023:
2024: gmdfmval_pub.get_substitute_line_item (

Line 2050: IF (g_debug <= gme_debug.g_log_statement) THEN

2046: ( l_new_item_rec.ENG_ITEM_FLAG = 'Y' AND NVL(x_batch_header_rec.laboratory_ind,0) <> 1 ) THEN
2047: RAISE invalid_item_substitute;
2048: END IF;
2049:
2050: IF (g_debug <= gme_debug.g_log_statement) THEN
2051: gme_debug.put_line('Calculated mtl req date: '||l_material_details (l_row_count).material_requirement_date);
2052: gme_debug.put_line('Initial Item ID: '||l_material_details (l_row_count).inventory_item_id);
2053: gme_debug.put_line('Initial Plan Qty: '||l_material_details (l_row_count).plan_qty);
2054: gme_debug.put_line('Initial Detail UOM: '||l_material_details (l_row_count).dtl_um);

Line 2051: gme_debug.put_line('Calculated mtl req date: '||l_material_details (l_row_count).material_requirement_date);

2047: RAISE invalid_item_substitute;
2048: END IF;
2049:
2050: IF (g_debug <= gme_debug.g_log_statement) THEN
2051: gme_debug.put_line('Calculated mtl req date: '||l_material_details (l_row_count).material_requirement_date);
2052: gme_debug.put_line('Initial Item ID: '||l_material_details (l_row_count).inventory_item_id);
2053: gme_debug.put_line('Initial Plan Qty: '||l_material_details (l_row_count).plan_qty);
2054: gme_debug.put_line('Initial Detail UOM: '||l_material_details (l_row_count).dtl_um);
2055: gme_debug.put_line('Initial Scale multiple: '||l_material_details (l_row_count).scale_multiple);

Line 2052: gme_debug.put_line('Initial Item ID: '||l_material_details (l_row_count).inventory_item_id);

2048: END IF;
2049:
2050: IF (g_debug <= gme_debug.g_log_statement) THEN
2051: gme_debug.put_line('Calculated mtl req date: '||l_material_details (l_row_count).material_requirement_date);
2052: gme_debug.put_line('Initial Item ID: '||l_material_details (l_row_count).inventory_item_id);
2053: gme_debug.put_line('Initial Plan Qty: '||l_material_details (l_row_count).plan_qty);
2054: gme_debug.put_line('Initial Detail UOM: '||l_material_details (l_row_count).dtl_um);
2055: gme_debug.put_line('Initial Scale multiple: '||l_material_details (l_row_count).scale_multiple);
2056: END IF;

Line 2053: gme_debug.put_line('Initial Plan Qty: '||l_material_details (l_row_count).plan_qty);

2049:
2050: IF (g_debug <= gme_debug.g_log_statement) THEN
2051: gme_debug.put_line('Calculated mtl req date: '||l_material_details (l_row_count).material_requirement_date);
2052: gme_debug.put_line('Initial Item ID: '||l_material_details (l_row_count).inventory_item_id);
2053: gme_debug.put_line('Initial Plan Qty: '||l_material_details (l_row_count).plan_qty);
2054: gme_debug.put_line('Initial Detail UOM: '||l_material_details (l_row_count).dtl_um);
2055: gme_debug.put_line('Initial Scale multiple: '||l_material_details (l_row_count).scale_multiple);
2056: END IF;
2057:

Line 2054: gme_debug.put_line('Initial Detail UOM: '||l_material_details (l_row_count).dtl_um);

2050: IF (g_debug <= gme_debug.g_log_statement) THEN
2051: gme_debug.put_line('Calculated mtl req date: '||l_material_details (l_row_count).material_requirement_date);
2052: gme_debug.put_line('Initial Item ID: '||l_material_details (l_row_count).inventory_item_id);
2053: gme_debug.put_line('Initial Plan Qty: '||l_material_details (l_row_count).plan_qty);
2054: gme_debug.put_line('Initial Detail UOM: '||l_material_details (l_row_count).dtl_um);
2055: gme_debug.put_line('Initial Scale multiple: '||l_material_details (l_row_count).scale_multiple);
2056: END IF;
2057:
2058: l_item_substituted := TRUE;

Line 2055: gme_debug.put_line('Initial Scale multiple: '||l_material_details (l_row_count).scale_multiple);

2051: gme_debug.put_line('Calculated mtl req date: '||l_material_details (l_row_count).material_requirement_date);
2052: gme_debug.put_line('Initial Item ID: '||l_material_details (l_row_count).inventory_item_id);
2053: gme_debug.put_line('Initial Plan Qty: '||l_material_details (l_row_count).plan_qty);
2054: gme_debug.put_line('Initial Detail UOM: '||l_material_details (l_row_count).dtl_um);
2055: gme_debug.put_line('Initial Scale multiple: '||l_material_details (l_row_count).scale_multiple);
2056: END IF;
2057:
2058: l_item_substituted := TRUE;
2059: l_curr_item_substituted := TRUE;

Line 2068: IF (g_debug <= gme_debug.g_log_statement) THEN

2064: l_material_details (l_row_count).original_qty := l_formula_tbl(1).qty;
2065: l_material_details (l_row_count).dtl_um := l_formula_tbl(1).detail_uom;
2066: l_material_details (l_row_count).scale_multiple := l_formula_tbl(1).scale_multiple;
2067:
2068: IF (g_debug <= gme_debug.g_log_statement) THEN
2069: gme_debug.put_line('Substitued Item ID: '||l_formula_tbl(1).inventory_item_id);
2070: gme_debug.put_line('Substitued Plan Qty: '||l_formula_tbl(1).qty);
2071: gme_debug.put_line('Substituted Detail UOM: '||l_formula_tbl(1).detail_uom);
2072: gme_debug.put_line('Substituted Scale multiple: '||l_formula_tbl(1).scale_multiple);

Line 2069: gme_debug.put_line('Substitued Item ID: '||l_formula_tbl(1).inventory_item_id);

2065: l_material_details (l_row_count).dtl_um := l_formula_tbl(1).detail_uom;
2066: l_material_details (l_row_count).scale_multiple := l_formula_tbl(1).scale_multiple;
2067:
2068: IF (g_debug <= gme_debug.g_log_statement) THEN
2069: gme_debug.put_line('Substitued Item ID: '||l_formula_tbl(1).inventory_item_id);
2070: gme_debug.put_line('Substitued Plan Qty: '||l_formula_tbl(1).qty);
2071: gme_debug.put_line('Substituted Detail UOM: '||l_formula_tbl(1).detail_uom);
2072: gme_debug.put_line('Substituted Scale multiple: '||l_formula_tbl(1).scale_multiple);
2073: END IF;

Line 2070: gme_debug.put_line('Substitued Plan Qty: '||l_formula_tbl(1).qty);

2066: l_material_details (l_row_count).scale_multiple := l_formula_tbl(1).scale_multiple;
2067:
2068: IF (g_debug <= gme_debug.g_log_statement) THEN
2069: gme_debug.put_line('Substitued Item ID: '||l_formula_tbl(1).inventory_item_id);
2070: gme_debug.put_line('Substitued Plan Qty: '||l_formula_tbl(1).qty);
2071: gme_debug.put_line('Substituted Detail UOM: '||l_formula_tbl(1).detail_uom);
2072: gme_debug.put_line('Substituted Scale multiple: '||l_formula_tbl(1).scale_multiple);
2073: END IF;
2074:

Line 2071: gme_debug.put_line('Substituted Detail UOM: '||l_formula_tbl(1).detail_uom);

2067:
2068: IF (g_debug <= gme_debug.g_log_statement) THEN
2069: gme_debug.put_line('Substitued Item ID: '||l_formula_tbl(1).inventory_item_id);
2070: gme_debug.put_line('Substitued Plan Qty: '||l_formula_tbl(1).qty);
2071: gme_debug.put_line('Substituted Detail UOM: '||l_formula_tbl(1).detail_uom);
2072: gme_debug.put_line('Substituted Scale multiple: '||l_formula_tbl(1).scale_multiple);
2073: END IF;
2074:
2075: /*if the new item uom is not the primary uom then calculate the primary quantity*/

Line 2072: gme_debug.put_line('Substituted Scale multiple: '||l_formula_tbl(1).scale_multiple);

2068: IF (g_debug <= gme_debug.g_log_statement) THEN
2069: gme_debug.put_line('Substitued Item ID: '||l_formula_tbl(1).inventory_item_id);
2070: gme_debug.put_line('Substitued Plan Qty: '||l_formula_tbl(1).qty);
2071: gme_debug.put_line('Substituted Detail UOM: '||l_formula_tbl(1).detail_uom);
2072: gme_debug.put_line('Substituted Scale multiple: '||l_formula_tbl(1).scale_multiple);
2073: END IF;
2074:
2075: /*if the new item uom is not the primary uom then calculate the primary quantity*/
2076: IF l_formula_tbl(1).detail_uom <> l_new_item_rec.primary_uom_code THEN

Line 2089: IF (g_debug < gme_debug.g_log_statement) THEN

2085: ELSE
2086: l_temp_qty := l_material_details(l_row_count).plan_qty;
2087: END IF;
2088:
2089: IF (g_debug < gme_debug.g_log_statement) THEN
2090: gme_debug.put_line('Initial Original Primary Qty: '||l_material_details (l_row_count).original_primary_qty);
2091: gme_debug.put_line('Substituted Original Priamry Qty: '||l_temp_qty);
2092: END IF;
2093:

Line 2090: gme_debug.put_line('Initial Original Primary Qty: '||l_material_details (l_row_count).original_primary_qty);

2086: l_temp_qty := l_material_details(l_row_count).plan_qty;
2087: END IF;
2088:
2089: IF (g_debug < gme_debug.g_log_statement) THEN
2090: gme_debug.put_line('Initial Original Primary Qty: '||l_material_details (l_row_count).original_primary_qty);
2091: gme_debug.put_line('Substituted Original Priamry Qty: '||l_temp_qty);
2092: END IF;
2093:
2094: /* assign to original primary qty */

Line 2091: gme_debug.put_line('Substituted Original Priamry Qty: '||l_temp_qty);

2087: END IF;
2088:
2089: IF (g_debug < gme_debug.g_log_statement) THEN
2090: gme_debug.put_line('Initial Original Primary Qty: '||l_material_details (l_row_count).original_primary_qty);
2091: gme_debug.put_line('Substituted Original Priamry Qty: '||l_temp_qty);
2092: END IF;
2093:
2094: /* assign to original primary qty */
2095: l_material_details (l_row_count).original_primary_qty := l_temp_qty;

Line 2119: IF (g_debug <= gme_debug.g_log_statement) THEN

2115: OPEN c_batchsteps (l_material_details(l_row_count).material_detail_id);
2116: FETCH c_batchsteps INTO l_batchstep_rec;
2117: CLOSE c_batchsteps;
2118:
2119: IF (g_debug <= gme_debug.g_log_statement) THEN
2120: gme_debug.put_line ('Before updating step qty after the substitution');
2121: END IF;
2122: gme_update_step_qty_pvt.update_step_qty (p_batch_step_rec => l_batchstep_rec,
2123: x_message_count => l_message_count,

Line 2120: gme_debug.put_line ('Before updating step qty after the substitution');

2116: FETCH c_batchsteps INTO l_batchstep_rec;
2117: CLOSE c_batchsteps;
2118:
2119: IF (g_debug <= gme_debug.g_log_statement) THEN
2120: gme_debug.put_line ('Before updating step qty after the substitution');
2121: END IF;
2122: gme_update_step_qty_pvt.update_step_qty (p_batch_step_rec => l_batchstep_rec,
2123: x_message_count => l_message_count,
2124: x_message_list => l_message_list,

Line 2128: IF (g_debug <= gme_debug.g_log_statement) THEN

2124: x_message_list => l_message_list,
2125: x_return_status => x_return_status,
2126: x_batch_step_rec => x_batchstep_rec
2127: );
2128: IF (g_debug <= gme_debug.g_log_statement) THEN
2129: gme_debug.put_line ('After update step qty, return status is:' || x_return_status);
2130: END IF;
2131: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2132: -- We could not update the step qty

Line 2129: gme_debug.put_line ('After update step qty, return status is:' || x_return_status);

2125: x_return_status => x_return_status,
2126: x_batch_step_rec => x_batchstep_rec
2127: );
2128: IF (g_debug <= gme_debug.g_log_statement) THEN
2129: gme_debug.put_line ('After update step qty, return status is:' || x_return_status);
2130: END IF;
2131: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2132: -- We could not update the step qty
2133: RAISE unexpected_error;

Line 2164: IF (g_debug <= gme_debug.g_log_statement) THEN

2160: x_batch_header_rec => x_batch_header_rec,
2161: x_return_status => x_return_status
2162: );
2163:
2164: IF (g_debug <= gme_debug.g_log_statement) THEN
2165: gme_debug.put_line('Batch Planned Start Date '||TO_CHAR(x_batch_header_rec.plan_start_date,'MON-DD-YYYY HH24:MI:SS'));
2166: gme_debug.put_line('Batch Planned Completion Date '||TO_CHAR(x_batch_header_rec.plan_cmplt_date,'MON-DD-YYYY HH24:MI:SS'));
2167: END IF;
2168:

Line 2165: gme_debug.put_line('Batch Planned Start Date '||TO_CHAR(x_batch_header_rec.plan_start_date,'MON-DD-YYYY HH24:MI:SS'));

2161: x_return_status => x_return_status
2162: );
2163:
2164: IF (g_debug <= gme_debug.g_log_statement) THEN
2165: gme_debug.put_line('Batch Planned Start Date '||TO_CHAR(x_batch_header_rec.plan_start_date,'MON-DD-YYYY HH24:MI:SS'));
2166: gme_debug.put_line('Batch Planned Completion Date '||TO_CHAR(x_batch_header_rec.plan_cmplt_date,'MON-DD-YYYY HH24:MI:SS'));
2167: END IF;
2168:
2169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2166: gme_debug.put_line('Batch Planned Completion Date '||TO_CHAR(x_batch_header_rec.plan_cmplt_date,'MON-DD-YYYY HH24:MI:SS'));

2162: );
2163:
2164: IF (g_debug <= gme_debug.g_log_statement) THEN
2165: gme_debug.put_line('Batch Planned Start Date '||TO_CHAR(x_batch_header_rec.plan_start_date,'MON-DD-YYYY HH24:MI:SS'));
2166: gme_debug.put_line('Batch Planned Completion Date '||TO_CHAR(x_batch_header_rec.plan_cmplt_date,'MON-DD-YYYY HH24:MI:SS'));
2167: END IF;
2168:
2169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2170: RAISE unexpected_error;

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

2188: END IF; /* ASQC */
2189: END IF; /* Update inventory*/
2190: -- nsinghi bug#5674398 END
2191:
2192: IF (g_debug = gme_debug.g_log_statement) THEN
2193: gme_debug.put_line ('p_creation_mode=' || p_creation_mode);
2194: gme_debug.put_line ('prim_prod_qty=' || l_prim_prod_qty);
2195: gme_debug.put_line ('prim_prod_um=' || l_prim_prod_um);
2196: gme_debug.put_line ('p_batch_size=' || p_batch_size);

Line 2193: gme_debug.put_line ('p_creation_mode=' || p_creation_mode);

2189: END IF; /* Update inventory*/
2190: -- nsinghi bug#5674398 END
2191:
2192: IF (g_debug = gme_debug.g_log_statement) THEN
2193: gme_debug.put_line ('p_creation_mode=' || p_creation_mode);
2194: gme_debug.put_line ('prim_prod_qty=' || l_prim_prod_qty);
2195: gme_debug.put_line ('prim_prod_um=' || l_prim_prod_um);
2196: gme_debug.put_line ('p_batch_size=' || p_batch_size);
2197: gme_debug.put_line ('p_batch_size_uom=' || p_batch_size_uom);

Line 2194: gme_debug.put_line ('prim_prod_qty=' || l_prim_prod_qty);

2190: -- nsinghi bug#5674398 END
2191:
2192: IF (g_debug = gme_debug.g_log_statement) THEN
2193: gme_debug.put_line ('p_creation_mode=' || p_creation_mode);
2194: gme_debug.put_line ('prim_prod_qty=' || l_prim_prod_qty);
2195: gme_debug.put_line ('prim_prod_um=' || l_prim_prod_um);
2196: gme_debug.put_line ('p_batch_size=' || p_batch_size);
2197: gme_debug.put_line ('p_batch_size_uom=' || p_batch_size_uom);
2198: gme_debug.put_line ( 'User passed Start date is '

Line 2195: gme_debug.put_line ('prim_prod_um=' || l_prim_prod_um);

2191:
2192: IF (g_debug = gme_debug.g_log_statement) THEN
2193: gme_debug.put_line ('p_creation_mode=' || p_creation_mode);
2194: gme_debug.put_line ('prim_prod_qty=' || l_prim_prod_qty);
2195: gme_debug.put_line ('prim_prod_um=' || l_prim_prod_um);
2196: gme_debug.put_line ('p_batch_size=' || p_batch_size);
2197: gme_debug.put_line ('p_batch_size_uom=' || p_batch_size_uom);
2198: gme_debug.put_line ( 'User passed Start date is '
2199: || TO_CHAR (p_batch_header_rec.plan_start_date

Line 2196: gme_debug.put_line ('p_batch_size=' || p_batch_size);

2192: IF (g_debug = gme_debug.g_log_statement) THEN
2193: gme_debug.put_line ('p_creation_mode=' || p_creation_mode);
2194: gme_debug.put_line ('prim_prod_qty=' || l_prim_prod_qty);
2195: gme_debug.put_line ('prim_prod_um=' || l_prim_prod_um);
2196: gme_debug.put_line ('p_batch_size=' || p_batch_size);
2197: gme_debug.put_line ('p_batch_size_uom=' || p_batch_size_uom);
2198: gme_debug.put_line ( 'User passed Start date is '
2199: || TO_CHAR (p_batch_header_rec.plan_start_date
2200: ,'DD-MON-YYYY HH24:MI:SS') );

Line 2197: gme_debug.put_line ('p_batch_size_uom=' || p_batch_size_uom);

2193: gme_debug.put_line ('p_creation_mode=' || p_creation_mode);
2194: gme_debug.put_line ('prim_prod_qty=' || l_prim_prod_qty);
2195: gme_debug.put_line ('prim_prod_um=' || l_prim_prod_um);
2196: gme_debug.put_line ('p_batch_size=' || p_batch_size);
2197: gme_debug.put_line ('p_batch_size_uom=' || p_batch_size_uom);
2198: gme_debug.put_line ( 'User passed Start date is '
2199: || TO_CHAR (p_batch_header_rec.plan_start_date
2200: ,'DD-MON-YYYY HH24:MI:SS') );
2201: gme_debug.put_line ( 'User passed Cmplt date is '

Line 2198: gme_debug.put_line ( 'User passed Start date is '

2194: gme_debug.put_line ('prim_prod_qty=' || l_prim_prod_qty);
2195: gme_debug.put_line ('prim_prod_um=' || l_prim_prod_um);
2196: gme_debug.put_line ('p_batch_size=' || p_batch_size);
2197: gme_debug.put_line ('p_batch_size_uom=' || p_batch_size_uom);
2198: gme_debug.put_line ( 'User passed Start date is '
2199: || TO_CHAR (p_batch_header_rec.plan_start_date
2200: ,'DD-MON-YYYY HH24:MI:SS') );
2201: gme_debug.put_line ( 'User passed Cmplt date is '
2202: || TO_CHAR (p_batch_header_rec.plan_cmplt_date

Line 2201: gme_debug.put_line ( 'User passed Cmplt date is '

2197: gme_debug.put_line ('p_batch_size_uom=' || p_batch_size_uom);
2198: gme_debug.put_line ( 'User passed Start date is '
2199: || TO_CHAR (p_batch_header_rec.plan_start_date
2200: ,'DD-MON-YYYY HH24:MI:SS') );
2201: gme_debug.put_line ( 'User passed Cmplt date is '
2202: || TO_CHAR (p_batch_header_rec.plan_cmplt_date
2203: ,'DD-MON-YYYY HH24:MI:SS') );
2204: END IF;
2205:

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

2218: l_to_uom := l_prim_prod_um;
2219: RAISE conversion_failure;
2220: END IF;
2221:
2222: IF (g_debug = gme_debug.g_log_statement) THEN
2223: gme_debug.put_line ('requested qty in dtl uom=' || l_temp_qty);
2224: gme_debug.put_line ('requested qty in dtl uom rounded=' || round(l_temp_qty));
2225: END IF;
2226:

Line 2223: gme_debug.put_line ('requested qty in dtl uom=' || l_temp_qty);

2219: RAISE conversion_failure;
2220: END IF;
2221:
2222: IF (g_debug = gme_debug.g_log_statement) THEN
2223: gme_debug.put_line ('requested qty in dtl uom=' || l_temp_qty);
2224: gme_debug.put_line ('requested qty in dtl uom rounded=' || round(l_temp_qty));
2225: END IF;
2226:
2227: --sunitha bug # 5484529 Convert the p_batch_size(user entered product plan quantity

Line 2224: gme_debug.put_line ('requested qty in dtl uom rounded=' || round(l_temp_qty));

2220: END IF;
2221:
2222: IF (g_debug = gme_debug.g_log_statement) THEN
2223: gme_debug.put_line ('requested qty in dtl uom=' || l_temp_qty);
2224: gme_debug.put_line ('requested qty in dtl uom rounded=' || round(l_temp_qty));
2225: END IF;
2226:
2227: --sunitha bug # 5484529 Convert the p_batch_size(user entered product plan quantity
2228: --to the Routing uom and then Compare it with the l_temp_qty.

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

2236: ,l_recipe_validity_rule.detail_uom
2237: ,NULL
2238: ,NULL), 5) <> ROUND (l_temp_qty, 5) ) THEN */
2239:
2240: IF (g_debug = gme_debug.g_log_statement) THEN
2241: gme_debug.put_line
2242: ('Batch failed to be created for qty requested with creation by product qty');
2243: END IF;
2244:

Line 2241: gme_debug.put_line

2237: ,NULL
2238: ,NULL), 5) <> ROUND (l_temp_qty, 5) ) THEN */
2239:
2240: IF (g_debug = gme_debug.g_log_statement) THEN
2241: gme_debug.put_line
2242: ('Batch failed to be created for qty requested with creation by product qty');
2243: END IF;
2244:
2245: RAISE create_by_product_failure;

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

2244:
2245: RAISE create_by_product_failure;
2246: END IF;
2247: ELSIF NOT l_prim_prod_found THEN
2248: IF (g_debug = gme_debug.g_log_statement) THEN
2249: gme_debug.put_line ('I could not find the prim product');
2250: END IF;
2251: END IF;
2252:

Line 2249: gme_debug.put_line ('I could not find the prim product');

2245: RAISE create_by_product_failure;
2246: END IF;
2247: ELSIF NOT l_prim_prod_found THEN
2248: IF (g_debug = gme_debug.g_log_statement) THEN
2249: gme_debug.put_line ('I could not find the prim product');
2250: END IF;
2251: END IF;
2252:
2253: IF (g_debug = gme_debug.g_log_statement) THEN

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

2249: gme_debug.put_line ('I could not find the prim product');
2250: END IF;
2251: END IF;
2252:
2253: IF (g_debug = gme_debug.g_log_statement) THEN
2254: gme_debug.put_line ('Checking dates against validity rule');
2255: END IF;
2256:
2257: IF p_creation_mode <> 'LCF' THEN

Line 2254: gme_debug.put_line ('Checking dates against validity rule');

2250: END IF;
2251: END IF;
2252:
2253: IF (g_debug = gme_debug.g_log_statement) THEN
2254: gme_debug.put_line ('Checking dates against validity rule');
2255: END IF;
2256:
2257: IF p_creation_mode <> 'LCF' THEN
2258: IF (NOT gme_common_pvt.check_validity_rule_dates

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

2263: RAISE date_exceed_validity_rule;
2264: END IF;
2265: END IF; /* IF p_creation_mode <> 'LCF' THEN */
2266:
2267: IF (g_debug = gme_debug.g_log_statement) THEN
2268: gme_debug.put_line ( 'BATCH CREATED, ID = '
2269: || TO_CHAR (x_batch_header_rec.batch_id) );
2270: END IF;
2271:

Line 2268: gme_debug.put_line ( 'BATCH CREATED, ID = '

2264: END IF;
2265: END IF; /* IF p_creation_mode <> 'LCF' THEN */
2266:
2267: IF (g_debug = gme_debug.g_log_statement) THEN
2268: gme_debug.put_line ( 'BATCH CREATED, ID = '
2269: || TO_CHAR (x_batch_header_rec.batch_id) );
2270: END IF;
2271:
2272: /* Update WIP entity table to put the primary product id */

Line 2280: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN

2276:
2277: -- Rajesh Patangya Bug # 6752637
2278: /* Now its time to calculate the MTQ for steps based on the product */
2279: IF gme_common_pvt.routings.COUNT <> 0 THEN
2280: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
2281: gme_debug.put_line ( g_pkg_name
2282: || '.'
2283: || l_api_name
2284: || 'Calling Update_step_mtq');

Line 2281: gme_debug.put_line ( g_pkg_name

2277: -- Rajesh Patangya Bug # 6752637
2278: /* Now its time to calculate the MTQ for steps based on the product */
2279: IF gme_common_pvt.routings.COUNT <> 0 THEN
2280: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
2281: gme_debug.put_line ( g_pkg_name
2282: || '.'
2283: || l_api_name
2284: || 'Calling Update_step_mtq');
2285: END IF;

Line 2292: IF g_debug <= gme_debug.g_log_statement THEN

2288: RAISE update_step_mtq_failure;
2289: END IF;
2290: END IF;
2291:
2292: IF g_debug <= gme_debug.g_log_statement THEN
2293: gme_debug.put_line ( g_pkg_name
2294: || '.'
2295: || l_api_name
2296: || 'Start phantom processing');

Line 2293: gme_debug.put_line ( g_pkg_name

2289: END IF;
2290: END IF;
2291:
2292: IF g_debug <= gme_debug.g_log_statement THEN
2293: gme_debug.put_line ( g_pkg_name
2294: || '.'
2295: || l_api_name
2296: || 'Start phantom processing');
2297: END IF;

Line 2355: IF g_debug <= gme_debug.g_log_statement THEN

2351: -- Now invisible move orders and high level reservations will get created for phantom batches.
2352: IF x_batch_header_rec.batch_type = 0 AND NVL (x_batch_header_rec.update_inventory_ind, 'Y') = 'Y' THEN
2353: /* Check inventory shortages */
2354: IF (gme_common_pvt.g_check_shortages_ind = 1 AND g_no_phant_short_check = 0) THEN
2355: IF g_debug <= gme_debug.g_log_statement THEN
2356: gme_debug.put_line ( g_pkg_name || '.'|| l_api_name|| ' Calling shortages ');
2357: END IF;
2358: gme_common_pvt.get_batch_shortages
2359: (p_organization_id => x_batch_header_rec.organization_id

Line 2356: gme_debug.put_line ( g_pkg_name || '.'|| l_api_name|| ' Calling shortages ');

2352: IF x_batch_header_rec.batch_type = 0 AND NVL (x_batch_header_rec.update_inventory_ind, 'Y') = 'Y' THEN
2353: /* Check inventory shortages */
2354: IF (gme_common_pvt.g_check_shortages_ind = 1 AND g_no_phant_short_check = 0) THEN
2355: IF g_debug <= gme_debug.g_log_statement THEN
2356: gme_debug.put_line ( g_pkg_name || '.'|| l_api_name|| ' Calling shortages ');
2357: END IF;
2358: gme_common_pvt.get_batch_shortages
2359: (p_organization_id => x_batch_header_rec.organization_id
2360: ,p_batch_id => x_batch_header_rec.batch_id

Line 2384: IF g_debug <= gme_debug.g_log_statement THEN

2380: END IF;
2381: END IF;
2382:
2383: /* Create invisible move order */
2384: IF g_debug <= gme_debug.g_log_statement THEN
2385: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ' Creating Invisible Move Order ');
2386: END IF;
2387:
2388: gme_move_orders_pvt.create_move_order_hdr

Line 2385: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ' Creating Invisible Move Order ');

2381: END IF;
2382:
2383: /* Create invisible move order */
2384: IF g_debug <= gme_debug.g_log_statement THEN
2385: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ' Creating Invisible Move Order ');
2386: END IF;
2387:
2388: gme_move_orders_pvt.create_move_order_hdr
2389: (p_organization_id => x_batch_header_rec.organization_id

Line 2394: IF g_debug <= gme_debug.g_log_statement THEN

2390: ,p_move_order_type => gme_common_pvt.g_invis_move_order_type
2391: ,x_move_order_header_id => x_batch_header_rec.move_order_header_id
2392: ,x_return_status => l_return_status);
2393:
2394: IF g_debug <= gme_debug.g_log_statement THEN
2395: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| 'Invisible Move Order is Created');
2396: END IF;
2397:
2398: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 2395: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| 'Invisible Move Order is Created');

2391: ,x_move_order_header_id => x_batch_header_rec.move_order_header_id
2392: ,x_return_status => l_return_status);
2393:
2394: IF g_debug <= gme_debug.g_log_statement THEN
2395: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| 'Invisible Move Order is Created');
2396: END IF;
2397:
2398: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2399: RAISE create_mo_hdr_err;

Line 2401: IF g_debug <= gme_debug.g_log_statement THEN

2397:
2398: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2399: RAISE create_mo_hdr_err;
2400: ELSE
2401: IF g_debug <= gme_debug.g_log_statement THEN
2402: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ' Creating Invisible Move Order Lines');
2403: END IF;
2404:
2405: l_in_material_details := l_material_details;

Line 2402: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ' Creating Invisible Move Order Lines');

2398: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2399: RAISE create_mo_hdr_err;
2400: ELSE
2401: IF g_debug <= gme_debug.g_log_statement THEN
2402: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ' Creating Invisible Move Order Lines');
2403: END IF;
2404:
2405: l_in_material_details := l_material_details;
2406: gme_move_orders_pvt.create_move_order_lines

Line 2418: IF g_debug <= gme_debug.g_log_statement THEN

2414: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2415: RAISE create_mo_line_err;
2416: END IF;
2417:
2418: IF g_debug <= gme_debug.g_log_statement THEN
2419: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| 'Invisible Move Order Lines is Created');
2420: END IF;
2421: END IF;
2422:

Line 2419: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| 'Invisible Move Order Lines is Created');

2415: RAISE create_mo_line_err;
2416: END IF;
2417:
2418: IF g_debug <= gme_debug.g_log_statement THEN
2419: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| 'Invisible Move Order Lines is Created');
2420: END IF;
2421: END IF;
2422:
2423: /* Update batch header with move_order_header_id */

Line 2436: IF g_debug <= gme_debug.g_log_statement THEN

2432: END LOOP;
2433:
2434: /* Create High Level Reservations */
2435: IF (gme_common_pvt.g_create_high_level_resv_ind = 1) THEN
2436: IF g_debug <= gme_debug.g_log_statement THEN
2437: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ' Creating reservations for batch id '|| x_batch_header_rec.batch_id);
2438: END IF;
2439:
2440: gme_reservations_pvt.create_batch_reservations

Line 2437: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ' Creating reservations for batch id '|| x_batch_header_rec.batch_id);

2433:
2434: /* Create High Level Reservations */
2435: IF (gme_common_pvt.g_create_high_level_resv_ind = 1) THEN
2436: IF g_debug <= gme_debug.g_log_statement THEN
2437: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ' Creating reservations for batch id '|| x_batch_header_rec.batch_id);
2438: END IF;
2439:
2440: gme_reservations_pvt.create_batch_reservations
2441: (p_batch_id => x_batch_header_rec.batch_id

Line 2445: IF g_debug <= gme_debug.g_log_statement THEN

2441: (p_batch_id => x_batch_header_rec.batch_id
2442: ,p_timefence => gme_common_pvt.g_reservation_timefence
2443: ,x_return_status => l_return_status);
2444:
2445: IF g_debug <= gme_debug.g_log_statement THEN
2446: gme_debug.put_line ( g_pkg_name
2447: || '.'
2448: || l_api_name
2449: || ' Reservations are created'

Line 2446: gme_debug.put_line ( g_pkg_name

2442: ,p_timefence => gme_common_pvt.g_reservation_timefence
2443: ,x_return_status => l_return_status);
2444:
2445: IF g_debug <= gme_debug.g_log_statement THEN
2446: gme_debug.put_line ( g_pkg_name
2447: || '.'
2448: || l_api_name
2449: || ' Reservations are created'
2450: || l_return_status);

Line 2456: IF g_debug <= gme_debug.g_log_statement THEN

2452: END IF;
2453:
2454: /* Create Move Order */
2455: IF (gme_common_pvt.g_create_move_orders_ind = 1) THEN
2456: IF g_debug <= gme_debug.g_log_statement THEN
2457: gme_debug.put_line ( g_pkg_name
2458: || '.'
2459: || l_api_name
2460: || ' Creating Explicit Move Order ');

Line 2457: gme_debug.put_line ( g_pkg_name

2453:
2454: /* Create Move Order */
2455: IF (gme_common_pvt.g_create_move_orders_ind = 1) THEN
2456: IF g_debug <= gme_debug.g_log_statement THEN
2457: gme_debug.put_line ( g_pkg_name
2458: || '.'
2459: || l_api_name
2460: || ' Creating Explicit Move Order ');
2461: END IF;

Line 2468: IF g_debug <= gme_debug.g_log_statement THEN

2464: (p_batch_header_rec => x_batch_header_rec
2465: ,p_material_details_tbl => l_material_details
2466: ,x_return_status => l_return_status);
2467:
2468: IF g_debug <= gme_debug.g_log_statement THEN
2469: gme_debug.put_line ( g_pkg_name
2470: || '.'
2471: || l_api_name
2472: || ' Explicit Move Order are created '

Line 2469: gme_debug.put_line ( g_pkg_name

2465: ,p_material_details_tbl => l_material_details
2466: ,x_return_status => l_return_status);
2467:
2468: IF g_debug <= gme_debug.g_log_statement THEN
2469: gme_debug.put_line ( g_pkg_name
2470: || '.'
2471: || l_api_name
2472: || ' Explicit Move Order are created '
2473: || l_return_status);

Line 2489: IF g_debug <= gme_debug.g_log_statement THEN

2485: X_MSG_COUNT => l_message_count,
2486: X_MSG_DATA => l_msg_data,
2487: P_ENTITY_NAME => 'BATCH',
2488: P_ENTITY_KEY => x_batch_header_rec.batch_id) ;
2489: IF g_debug <= gme_debug.g_log_statement THEN
2490: gme_debug.put_line ( g_pkg_name
2491: || '.'
2492: || l_api_name
2493: || ' Calling instantiate_advanced_pi ');

Line 2490: gme_debug.put_line ( g_pkg_name

2486: X_MSG_DATA => l_msg_data,
2487: P_ENTITY_NAME => 'BATCH',
2488: P_ENTITY_KEY => x_batch_header_rec.batch_id) ;
2489: IF g_debug <= gme_debug.g_log_statement THEN
2490: gme_debug.put_line ( g_pkg_name
2491: || '.'
2492: || l_api_name
2493: || ' Calling instantiate_advanced_pi ');
2494: END IF;

Line 2503: IF g_debug <= gme_debug.g_log_procedure THEN

2499: /*Bug#7493614 moved the workflow event call to the end of the batch
2500: create procedure */
2501: wf_event.RAISE (p_event_name => gme_common_pvt.G_BATCH_CREATED
2502: ,p_event_key => x_batch_header_rec.batch_id);
2503: IF g_debug <= gme_debug.g_log_procedure THEN
2504: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2505: END IF;
2506: EXCEPTION
2507: WHEN doc_num_is_not_passed THEN

Line 2504: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

2500: create procedure */
2501: wf_event.RAISE (p_event_name => gme_common_pvt.G_BATCH_CREATED
2502: ,p_event_key => x_batch_header_rec.batch_id);
2503: IF g_debug <= gme_debug.g_log_procedure THEN
2504: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2505: END IF;
2506: EXCEPTION
2507: WHEN doc_num_is_not_passed THEN
2508: x_return_status := fnd_api.g_ret_sts_error;

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

2522: --FPBug#4351032
2523: WHEN validation_failure OR expected_error OR scaling_failure OR date_exceed_validity_rule OR batch_header_fetch_failure OR error_count_exceeded OR expected_error OR unexpected_error OR invalid_item_substitute OR material_dtl_fetch_failure THEN
2524: x_return_status := fnd_api.g_ret_sts_error;
2525: WHEN error_cont_period THEN
2526: IF (g_debug = gme_debug.g_log_statement) THEN
2527: gme_debug.put_line ('Contiguity period ... _failed');
2528: END IF;
2529:
2530: x_return_status := l_return_status;

Line 2527: gme_debug.put_line ('Contiguity period ... _failed');

2523: WHEN validation_failure OR expected_error OR scaling_failure OR date_exceed_validity_rule OR batch_header_fetch_failure OR error_count_exceeded OR expected_error OR unexpected_error OR invalid_item_substitute OR material_dtl_fetch_failure THEN
2524: x_return_status := fnd_api.g_ret_sts_error;
2525: WHEN error_cont_period THEN
2526: IF (g_debug = gme_debug.g_log_statement) THEN
2527: gme_debug.put_line ('Contiguity period ... _failed');
2528: END IF;
2529:
2530: x_return_status := l_return_status;
2531: WHEN error_non_contiguious THEN

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

2528: END IF;
2529:
2530: x_return_status := l_return_status;
2531: WHEN error_non_contiguious THEN
2532: IF (g_debug = gme_debug.g_log_statement) THEN
2533: gme_debug.put_line ('Contiguity period ... not found');
2534: END IF;
2535:
2536: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');

Line 2533: gme_debug.put_line ('Contiguity period ... not found');

2529:
2530: x_return_status := l_return_status;
2531: WHEN error_non_contiguious THEN
2532: IF (g_debug = gme_debug.g_log_statement) THEN
2533: gme_debug.put_line ('Contiguity period ... not found');
2534: END IF;
2535:
2536: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');
2537: x_return_status := 'C';

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

2551: fnd_message.set_token ('FROM_UOM', l_from_uom);
2552: fnd_message.set_token ('TO_UOM', l_to_uom);
2553: fnd_msg_pub.ADD;
2554: WHEN Fixed_process_loss_failure THEN
2555: IF (g_debug = gme_debug.g_log_statement) THEN
2556: gme_debug.put_line ('Failed to apply FPL');
2557: END IF;
2558: WHEN create_by_product_failure THEN
2559: gme_common_pvt.log_message ('GME_API_CREATE_BY_PROD_FAIL');

Line 2556: gme_debug.put_line ('Failed to apply FPL');

2552: fnd_message.set_token ('TO_UOM', l_to_uom);
2553: fnd_msg_pub.ADD;
2554: WHEN Fixed_process_loss_failure THEN
2555: IF (g_debug = gme_debug.g_log_statement) THEN
2556: gme_debug.put_line ('Failed to apply FPL');
2557: END IF;
2558: WHEN create_by_product_failure THEN
2559: gme_common_pvt.log_message ('GME_API_CREATE_BY_PROD_FAIL');
2560: x_return_status := fnd_api.g_ret_sts_error;

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

2558: WHEN create_by_product_failure THEN
2559: gme_common_pvt.log_message ('GME_API_CREATE_BY_PROD_FAIL');
2560: x_return_status := fnd_api.g_ret_sts_error;
2561:
2562: IF (g_debug = gme_debug.g_log_statement) THEN
2563: gme_debug.put_line ('GME_API_CREATE_BY_PROD_FAIL');
2564: END IF;
2565: WHEN inventory_shortage OR create_mo_hdr_err OR create_mo_line_err OR
2566: calc_mtl_req_date_err OR gmo_instantiate_err OR wip_entity_err THEN

Line 2563: gme_debug.put_line ('GME_API_CREATE_BY_PROD_FAIL');

2559: gme_common_pvt.log_message ('GME_API_CREATE_BY_PROD_FAIL');
2560: x_return_status := fnd_api.g_ret_sts_error;
2561:
2562: IF (g_debug = gme_debug.g_log_statement) THEN
2563: gme_debug.put_line ('GME_API_CREATE_BY_PROD_FAIL');
2564: END IF;
2565: WHEN inventory_shortage OR create_mo_hdr_err OR create_mo_line_err OR
2566: calc_mtl_req_date_err OR gmo_instantiate_err OR wip_entity_err THEN
2567: x_return_status := l_return_status;

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

2565: WHEN inventory_shortage OR create_mo_hdr_err OR create_mo_line_err OR
2566: calc_mtl_req_date_err OR gmo_instantiate_err OR wip_entity_err THEN
2567: x_return_status := l_return_status;
2568: WHEN error_truncate_date THEN
2569: IF (g_debug = gme_debug.g_log_statement) THEN
2570: gme_debug.put_line ('truncate date procedure error');
2571: END IF;
2572:
2573: x_return_status := fnd_api.g_ret_sts_error;

Line 2570: gme_debug.put_line ('truncate date procedure error');

2566: calc_mtl_req_date_err OR gmo_instantiate_err OR wip_entity_err THEN
2567: x_return_status := l_return_status;
2568: WHEN error_truncate_date THEN
2569: IF (g_debug = gme_debug.g_log_statement) THEN
2570: gme_debug.put_line ('truncate date procedure error');
2571: END IF;
2572:
2573: x_return_status := fnd_api.g_ret_sts_error;
2574: --FPBug#4395561

Line 2577: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN

2573: x_return_status := fnd_api.g_ret_sts_error;
2574: --FPBug#4395561
2575: WHEN create_flex_failure THEN
2576: x_return_status := l_return_status;
2577: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
2578: gme_debug.put_line ('Creating the default values of the DFF failure');
2579: END IF;
2580: -- Rajesh Patangya Bug # 6752637
2581: WHEN update_step_mtq_failure THEN

Line 2578: gme_debug.put_line ('Creating the default values of the DFF failure');

2574: --FPBug#4395561
2575: WHEN create_flex_failure THEN
2576: x_return_status := l_return_status;
2577: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
2578: gme_debug.put_line ('Creating the default values of the DFF failure');
2579: END IF;
2580: -- Rajesh Patangya Bug # 6752637
2581: WHEN update_step_mtq_failure THEN
2582: x_return_status := fnd_api.g_ret_sts_error;

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

2579: END IF;
2580: -- Rajesh Patangya Bug # 6752637
2581: WHEN update_step_mtq_failure THEN
2582: x_return_status := fnd_api.g_ret_sts_error;
2583: IF (g_debug = gme_debug.g_log_statement) THEN
2584: gme_debug.put_line ('MTQ Calculation failure');
2585: END IF;
2586: WHEN OTHERS THEN
2587: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 2584: gme_debug.put_line ('MTQ Calculation failure');

2580: -- Rajesh Patangya Bug # 6752637
2581: WHEN update_step_mtq_failure THEN
2582: x_return_status := fnd_api.g_ret_sts_error;
2583: IF (g_debug = gme_debug.g_log_statement) THEN
2584: gme_debug.put_line ('MTQ Calculation failure');
2585: END IF;
2586: WHEN OTHERS THEN
2587: IF g_debug <= gme_debug.g_log_unexpected THEN
2588: gme_debug.put_line ( 'When others exception in '

Line 2587: IF g_debug <= gme_debug.g_log_unexpected THEN

2583: IF (g_debug = gme_debug.g_log_statement) THEN
2584: gme_debug.put_line ('MTQ Calculation failure');
2585: END IF;
2586: WHEN OTHERS THEN
2587: IF g_debug <= gme_debug.g_log_unexpected THEN
2588: gme_debug.put_line ( 'When others exception in '
2589: || g_pkg_name
2590: || '.'
2591: || l_api_name

Line 2588: gme_debug.put_line ( 'When others exception in '

2584: gme_debug.put_line ('MTQ Calculation failure');
2585: END IF;
2586: WHEN OTHERS THEN
2587: IF g_debug <= gme_debug.g_log_unexpected THEN
2588: gme_debug.put_line ( 'When others exception in '
2589: || g_pkg_name
2590: || '.'
2591: || l_api_name
2592: || ' Error is '

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

2594: END IF;
2595:
2596: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2597:
2598: IF (g_debug = gme_debug.g_log_statement) THEN
2599: gme_debug.put_line (SQLERRM);
2600: END IF;
2601: x_return_status := fnd_api.g_ret_sts_unexp_error;
2602: END create_batch;

Line 2599: gme_debug.put_line (SQLERRM);

2595:
2596: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2597:
2598: IF (g_debug = gme_debug.g_log_statement) THEN
2599: gme_debug.put_line (SQLERRM);
2600: END IF;
2601: x_return_status := fnd_api.g_ret_sts_unexp_error;
2602: END create_batch;
2603:

Line 2664: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN

2660: LOOP
2661: FETCH step_mtq_cursor INTO l_batch_steps ;
2662: EXIT WHEN step_mtq_cursor%NOTFOUND;
2663:
2664: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
2665: gme_debug.put_line (' MTQ = ' || NVL(l_batch_steps.minimum_transfer_qty,0)
2666: || ' Step_qty = ' || NVL(l_batch_steps.plan_step_qty,0)
2667: || ' Routingstep_id = ' || l_batch_steps.routingstep_id );
2668: END IF;

Line 2665: gme_debug.put_line (' MTQ = ' || NVL(l_batch_steps.minimum_transfer_qty,0)

2661: FETCH step_mtq_cursor INTO l_batch_steps ;
2662: EXIT WHEN step_mtq_cursor%NOTFOUND;
2663:
2664: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
2665: gme_debug.put_line (' MTQ = ' || NVL(l_batch_steps.minimum_transfer_qty,0)
2666: || ' Step_qty = ' || NVL(l_batch_steps.plan_step_qty,0)
2667: || ' Routingstep_id = ' || l_batch_steps.routingstep_id );
2668: END IF;
2669:

Line 2683: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN

2679: WHERE batch_id = l_batch_steps.batch_id
2680: AND routingstep_id = l_batch_steps.routingstep_id
2681: AND batchstep_id = l_batch_steps.batchstep_id ;
2682:
2683: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
2684: gme_debug.put_line (' Update Calculated MTQ = ' || l_calculated_mtq );
2685: END IF;
2686:
2687: END IF;

Line 2684: gme_debug.put_line (' Update Calculated MTQ = ' || l_calculated_mtq );

2680: AND routingstep_id = l_batch_steps.routingstep_id
2681: AND batchstep_id = l_batch_steps.batchstep_id ;
2682:
2683: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
2684: gme_debug.put_line (' Update Calculated MTQ = ' || l_calculated_mtq );
2685: END IF;
2686:
2687: END IF;
2688: END LOOP ;

Line 2698: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN

2694: WHEN no_data_found THEN
2695: RETURN TRUE ;
2696: WHEN OTHERS THEN
2697: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2698: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
2699: gme_debug.put_line (SQLERRM);
2700: END IF;
2701: RETURN FALSE ;
2702: END update_step_mtq ;

Line 2699: gme_debug.put_line (SQLERRM);

2695: RETURN TRUE ;
2696: WHEN OTHERS THEN
2697: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2698: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
2699: gme_debug.put_line (SQLERRM);
2700: END IF;
2701: RETURN FALSE ;
2702: END update_step_mtq ;
2703: