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_RESCHEDULE_BATCH_PVT dependencies on GME_DEBUG

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

186: l_M_count NUMBER := 0;
187: l_B_count NUMBER := 0;
188: BEGIN
189: IF (NVL (g_debug, 0) IN
190: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
191: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
192: || 'Entering');
193: END IF;
194:

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

187: l_B_count NUMBER := 0;
188: BEGIN
189: IF (NVL (g_debug, 0) IN
190: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
191: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
192: || 'Entering');
193: END IF;
194:
195: /* Set the return status tosuccess initially */

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

194:
195: /* Set the return status tosuccess initially */
196: x_return_status := fnd_api.g_ret_sts_success;
197:
198: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
199: gme_debug.put_line ( 'Trying to reschedule to '
200: || TO_CHAR (p_batch_header_rec.plan_start_date
201: ,'MM/DD/YYYY HH24:MI:SS')
202: || ' and '

Line 199: gme_debug.put_line ( 'Trying to reschedule to '

195: /* Set the return status tosuccess initially */
196: x_return_status := fnd_api.g_ret_sts_success;
197:
198: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
199: gme_debug.put_line ( 'Trying to reschedule to '
200: || TO_CHAR (p_batch_header_rec.plan_start_date
201: ,'MM/DD/YYYY HH24:MI:SS')
202: || ' and '
203: || TO_CHAR (p_batch_header_rec.plan_cmplt_date

Line 256: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

252: /* Check validity rule if not LCF batch */
253: IF x_batch_header_rec.recipe_validity_rule_id IS NOT NULL THEN
254:
255:
256: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
257: gme_debug.put_line ( g_pkg_name
258: || '.'
259: || l_api_name
260: || ':'

Line 257: gme_debug.put_line ( g_pkg_name

253: IF x_batch_header_rec.recipe_validity_rule_id IS NOT NULL THEN
254:
255:
256: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
257: gme_debug.put_line ( g_pkg_name
258: || '.'
259: || l_api_name
260: || ':'
261: || 'Calling Check Validity Rule Dates');

Line 274: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

270: x_return_status := fnd_api.g_ret_sts_error;
271: RAISE date_exceed_validity_rule;
272: END IF;
273:
274: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
275: gme_debug.put_line
276: ( 'Came back from Check Validity Rule Dates. Trying to reschedule From '
277: || TO_CHAR (x_batch_header_rec.plan_start_date
278: ,'MM/DD/YYYY HH24:MI:SS')

Line 275: gme_debug.put_line

271: RAISE date_exceed_validity_rule;
272: END IF;
273:
274: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
275: gme_debug.put_line
276: ( 'Came back from Check Validity Rule Dates. Trying to reschedule From '
277: || TO_CHAR (x_batch_header_rec.plan_start_date
278: ,'MM/DD/YYYY HH24:MI:SS')
279: || ' and '

Line 284: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

280: || TO_CHAR (x_batch_header_rec.plan_cmplt_date
281: ,'MM/DD/YYYY HH24:MI:SS') );
282: END IF;
283: ELSE /* x_batch_header_rec.recipe_validity_rule_id IS NULL */
284: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
285: gme_debug.put_line ( g_pkg_name
286: || '.'
287: || l_api_name
288: || ':'

Line 285: gme_debug.put_line ( g_pkg_name

281: ,'MM/DD/YYYY HH24:MI:SS') );
282: END IF;
283: ELSE /* x_batch_header_rec.recipe_validity_rule_id IS NULL */
284: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
285: gme_debug.put_line ( g_pkg_name
286: || '.'
287: || l_api_name
288: || ':'
289: || 'Do not Check Validity Rule Dates as this is LCF batch');

Line 299: IF (NVL (g_debug, 0) <= gme_debug.g_log_procedure) THEN

295: ELSE
296: l_doc_type := 'FPO';
297: END IF;
298:
299: IF (NVL (g_debug, 0) <= gme_debug.g_log_procedure) THEN
300: gme_debug.put_line ('Delete all the pending resource transactions');
301: END IF;
302:
303: -- delete all the pending resource transactions

Line 300: gme_debug.put_line ('Delete all the pending resource transactions');

296: l_doc_type := 'FPO';
297: END IF;
298:
299: IF (NVL (g_debug, 0) <= gme_debug.g_log_procedure) THEN
300: gme_debug.put_line ('Delete all the pending resource transactions');
301: END IF;
302:
303: -- delete all the pending resource transactions
304: IF x_batch_header_rec.update_inventory_ind = 'Y' THEN

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

395: ,x_batch_header_rec) ) THEN
396: RAISE batch_header_fetch_error;
397: END IF;
398: ELSE /* no routing */
399: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
400: gme_debug.put_line ('No Routing');
401: END IF;
402: /* GO to validity rule is not an LCF batch */
403: IF l_batch_header_rec.recipe_validity_rule_id IS NOT NULL THEN

Line 400: gme_debug.put_line ('No Routing');

396: RAISE batch_header_fetch_error;
397: END IF;
398: ELSE /* no routing */
399: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
400: gme_debug.put_line ('No Routing');
401: END IF;
402: /* GO to validity rule is not an LCF batch */
403: IF l_batch_header_rec.recipe_validity_rule_id IS NOT NULL THEN
404: OPEN recipe_validity_rule_cursor

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

490: l_no_prod_rule_found := TRUE;
491: END IF; /* l_prim_prod_found */
492:
493: IF l_no_prod_rule_found THEN
494: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
495: gme_debug.put_line ('No Rules');
496: END IF;
497:
498: IF p_batch_header_rec.plan_start_date IS NOT NULL

Line 495: gme_debug.put_line ('No Rules');

491: END IF; /* l_prim_prod_found */
492:
493: IF l_no_prod_rule_found THEN
494: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
495: gme_debug.put_line ('No Rules');
496: END IF;
497:
498: IF p_batch_header_rec.plan_start_date IS NOT NULL
499: AND p_batch_header_rec.plan_cmplt_date IS NULL THEN

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

520: x_batch_header_rec.plan_cmplt_date :=
521: p_batch_header_rec.plan_cmplt_date;
522: END IF; /*plan_start_date NOT NULL*/
523:
524: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
525: gme_debug.put_line
526: ( 'Production rule start_date '
527: || TO_CHAR (x_batch_header_rec.plan_start_date
528: ,'yyyy/mon/dd hh24:mi:ss')

Line 525: gme_debug.put_line

521: p_batch_header_rec.plan_cmplt_date;
522: END IF; /*plan_start_date NOT NULL*/
523:
524: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
525: gme_debug.put_line
526: ( 'Production rule start_date '
527: || TO_CHAR (x_batch_header_rec.plan_start_date
528: ,'yyyy/mon/dd hh24:mi:ss')
529: || ' Production rule end_date '

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

538: ,p_recipe_validity_rule_id => l_batch_header_rec.recipe_validity_rule_id
539: ,x_contiguous_ind => l_contiguous_ind
540: ,x_return_status => l_return_status);
541:
542: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
543: gme_debug.put_line ( 'l_contiguous_ind found '
544: || l_contiguous_ind);
545: END IF;
546:

Line 543: gme_debug.put_line ( 'l_contiguous_ind found '

539: ,x_contiguous_ind => l_contiguous_ind
540: ,x_return_status => l_return_status);
541:
542: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
543: gme_debug.put_line ( 'l_contiguous_ind found '
544: || l_contiguous_ind);
545: END IF;
546:
547: l_duration :=

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

548: ( x_batch_header_rec.plan_cmplt_date
549: - x_batch_header_rec.plan_start_date)
550: * 24;
551:
552: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
553: gme_debug.put_line ('l duration ' || l_duration);
554: END IF;
555:
556: IF p_batch_header_rec.plan_start_date IS NOT NULL

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

549: - x_batch_header_rec.plan_start_date)
550: * 24;
551:
552: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
553: gme_debug.put_line ('l duration ' || l_duration);
554: END IF;
555:
556: IF p_batch_header_rec.plan_start_date IS NOT NULL
557: OR ( p_batch_header_rec.plan_start_date IS NULL

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

567: ,p_duration => l_duration
568: ,p_output_tbl => l_contig_period_tbl
569: ,x_return_status => l_return_status);
570:
571: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
572: gme_debug.put_line
573: ( 'Came back from Get Contiguous Periods with status '
574: || l_return_status);
575: END IF;

Line 572: gme_debug.put_line

568: ,p_output_tbl => l_contig_period_tbl
569: ,x_return_status => l_return_status);
570:
571: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
572: gme_debug.put_line
573: ( 'Came back from Get Contiguous Periods with status '
574: || l_return_status);
575: END IF;
576:

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

579: END IF;
580:
581: l_cal_count := l_contig_period_tbl.COUNT;
582:
583: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
584: gme_debug.put_line ('l cal_count ' || l_cal_count);
585: gme_debug.put_line ( 'p_contiguity_override '
586: || p_contiguity_override);
587: END IF;

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

580:
581: l_cal_count := l_contig_period_tbl.COUNT;
582:
583: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
584: gme_debug.put_line ('l cal_count ' || l_cal_count);
585: gme_debug.put_line ( 'p_contiguity_override '
586: || p_contiguity_override);
587: END IF;
588:

Line 585: gme_debug.put_line ( 'p_contiguity_override '

581: l_cal_count := l_contig_period_tbl.COUNT;
582:
583: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
584: gme_debug.put_line ('l cal_count ' || l_cal_count);
585: gme_debug.put_line ( 'p_contiguity_override '
586: || p_contiguity_override);
587: END IF;
588:
589: IF l_contiguous_ind = 1

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

597: ,x_batch_header_rec.plan_start_date);
598: x_batch_header_rec.plan_cmplt_date :=
599: l_contig_period_tbl (l_cal_count).end_date;
600:
601: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
602: gme_debug.put_line
603: ( 'x_batch_header_rec.plan_cmplt_date '
604: || TO_CHAR
605: (x_batch_header_rec.plan_cmplt_date

Line 602: gme_debug.put_line

598: x_batch_header_rec.plan_cmplt_date :=
599: l_contig_period_tbl (l_cal_count).end_date;
600:
601: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
602: gme_debug.put_line
603: ( 'x_batch_header_rec.plan_cmplt_date '
604: || TO_CHAR
605: (x_batch_header_rec.plan_cmplt_date
606: ,'yyyy/mon/dd hh24:mi:ss') );

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

616: ,p_duration => l_duration
617: ,p_output_tbl => l_contig_period_tbl
618: ,x_return_status => l_return_status);
619:
620: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
621: gme_debug.put_line
622: ( 'Plan start date is null. Came back from Get Contiguous Periods with status '
623: || l_return_status);
624: END IF;

Line 621: gme_debug.put_line

617: ,p_output_tbl => l_contig_period_tbl
618: ,x_return_status => l_return_status);
619:
620: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
621: gme_debug.put_line
622: ( 'Plan start date is null. Came back from Get Contiguous Periods with status '
623: || l_return_status);
624: END IF;
625:

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

628: END IF;
629:
630: l_cal_count := l_contig_period_tbl.COUNT;
631:
632: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
633: gme_debug.put_line ('l cal_count ' || l_cal_count);
634: gme_debug.put_line ( 'p_contiguity_override '
635: || p_contiguity_override);
636: END IF;

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

629:
630: l_cal_count := l_contig_period_tbl.COUNT;
631:
632: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
633: gme_debug.put_line ('l cal_count ' || l_cal_count);
634: gme_debug.put_line ( 'p_contiguity_override '
635: || p_contiguity_override);
636: END IF;
637:

Line 634: gme_debug.put_line ( 'p_contiguity_override '

630: l_cal_count := l_contig_period_tbl.COUNT;
631:
632: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
633: gme_debug.put_line ('l cal_count ' || l_cal_count);
634: gme_debug.put_line ( 'p_contiguity_override '
635: || p_contiguity_override);
636: END IF;
637:
638: IF l_contiguous_ind = 1

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

645: p_batch_header_rec.plan_cmplt_date;
646: x_batch_header_rec.plan_start_date :=
647: l_contig_period_tbl (l_cal_count).start_date;
648:
649: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
650: gme_debug.put_line
651: ( 'x_batch_header_rec.plan_start_date '
652: || TO_CHAR
653: (x_batch_header_rec.plan_start_date

Line 650: gme_debug.put_line

646: x_batch_header_rec.plan_start_date :=
647: l_contig_period_tbl (l_cal_count).start_date;
648:
649: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
650: gme_debug.put_line
651: ( 'x_batch_header_rec.plan_start_date '
652: || TO_CHAR
653: (x_batch_header_rec.plan_start_date
654: ,'yyyy/mon/dd hh24:mi:ss') );

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

664: END IF; /* p_use_workday_cal = FND_API.G_TRUE */
665: END IF; /* l_no_prod_found*/
666:
667: IF (NVL (g_debug, 0) IN
668: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
669: gme_debug.put_line ('Update gme_batch_header.');
670: END IF;
671:
672: UPDATE gme_batch_header

Line 669: gme_debug.put_line ('Update gme_batch_header.');

665: END IF; /* l_no_prod_found*/
666:
667: IF (NVL (g_debug, 0) IN
668: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
669: gme_debug.put_line ('Update gme_batch_header.');
670: END IF;
671:
672: UPDATE gme_batch_header
673: SET plan_start_date = x_batch_header_rec.plan_start_date

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

680: ,last_update_login = gme_common_pvt.g_login_id
681: WHERE batch_id = x_batch_header_rec.batch_id;
682: END IF;
683:
684: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
685: gme_debug.put_line
686: ( ' After update gme_batch_header. Final plan_start_date '
687: || TO_CHAR (x_batch_header_rec.plan_start_date
688: ,'yyyy/mon/dd hh24:mi:ss')

Line 685: gme_debug.put_line

681: WHERE batch_id = x_batch_header_rec.batch_id;
682: END IF;
683:
684: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
685: gme_debug.put_line
686: ( ' After update gme_batch_header. Final plan_start_date '
687: || TO_CHAR (x_batch_header_rec.plan_start_date
688: ,'yyyy/mon/dd hh24:mi:ss')
689: || ' Final plan_cmplt_date '

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

731: END IF;
732:
733: IF ( (x_batch_header_rec.plan_start_date IS NOT NULL)
734: AND (x_batch_header_rec.plan_cmplt_date IS NOT NULL) ) THEN
735: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
736: gme_debug.put_line ( 'max_date '
737: || TO_CHAR (max_cmplt_date
738: ,'yyyy/mon/dd hh24:mi:ss') );
739: gme_debug.put_line ( 'required batch end_date '

Line 736: gme_debug.put_line ( 'max_date '

732:
733: IF ( (x_batch_header_rec.plan_start_date IS NOT NULL)
734: AND (x_batch_header_rec.plan_cmplt_date IS NOT NULL) ) THEN
735: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
736: gme_debug.put_line ( 'max_date '
737: || TO_CHAR (max_cmplt_date
738: ,'yyyy/mon/dd hh24:mi:ss') );
739: gme_debug.put_line ( 'required batch end_date '
740: || TO_CHAR

Line 739: gme_debug.put_line ( 'required batch end_date '

735: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
736: gme_debug.put_line ( 'max_date '
737: || TO_CHAR (max_cmplt_date
738: ,'yyyy/mon/dd hh24:mi:ss') );
739: gme_debug.put_line ( 'required batch end_date '
740: || TO_CHAR
741: (p_batch_header_rec.plan_cmplt_date
742: ,'yyyy/mon/dd hh24:mi:ss') );
743: END IF;

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

741: (p_batch_header_rec.plan_cmplt_date
742: ,'yyyy/mon/dd hh24:mi:ss') );
743: END IF;
744:
745: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
746: gme_debug.put_line ( 'p_plan_cmplt_date '
747: || TO_CHAR
748: (p_batch_header_rec.plan_cmplt_date
749: ,'yyyy/mon/dd hh24:mi:ss') );

Line 746: gme_debug.put_line ( 'p_plan_cmplt_date '

742: ,'yyyy/mon/dd hh24:mi:ss') );
743: END IF;
744:
745: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
746: gme_debug.put_line ( 'p_plan_cmplt_date '
747: || TO_CHAR
748: (p_batch_header_rec.plan_cmplt_date
749: ,'yyyy/mon/dd hh24:mi:ss') );
750: gme_debug.put_line ( 'x_plan_cmplt_date '

Line 750: gme_debug.put_line ( 'x_plan_cmplt_date '

746: gme_debug.put_line ( 'p_plan_cmplt_date '
747: || TO_CHAR
748: (p_batch_header_rec.plan_cmplt_date
749: ,'yyyy/mon/dd hh24:mi:ss') );
750: gme_debug.put_line ( 'x_plan_cmplt_date '
751: || TO_CHAR
752: (x_batch_header_rec.plan_cmplt_date
753: ,'yyyy/mon/dd hh24:mi:ss') );
754: END IF;

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

765: END IF;
766: ELSIF p_batch_header_rec.plan_cmplt_date >
767: x_batch_header_rec.plan_cmplt_date THEN
768: IF (NVL (g_debug, 0) IN
769: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
770: gme_debug.put_line
771: ('User supplied plan completion date is greater than what system calculated User wants to leave gaps.');
772: END IF;
773:

Line 770: gme_debug.put_line

766: ELSIF p_batch_header_rec.plan_cmplt_date >
767: x_batch_header_rec.plan_cmplt_date THEN
768: IF (NVL (g_debug, 0) IN
769: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
770: gme_debug.put_line
771: ('User supplied plan completion date is greater than what system calculated User wants to leave gaps.');
772: END IF;
773:
774: UPDATE gme_batch_header

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

783: END IF;
784:
785: -- Checking of batch dates with validity rules dates after the reschedule
786: -- Pawan Kumar added code for bug 3088739
787: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
788: gme_debug.put_line ( 'affinal plan_start_date '
789: || TO_CHAR (x_batch_header_rec.plan_start_date
790: ,'yyyy/mon/dd hh24:mi:ss') );
791: gme_debug.put_line ( 'affinal plan_cmplt_date '

Line 788: gme_debug.put_line ( 'affinal plan_start_date '

784:
785: -- Checking of batch dates with validity rules dates after the reschedule
786: -- Pawan Kumar added code for bug 3088739
787: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
788: gme_debug.put_line ( 'affinal plan_start_date '
789: || TO_CHAR (x_batch_header_rec.plan_start_date
790: ,'yyyy/mon/dd hh24:mi:ss') );
791: gme_debug.put_line ( 'affinal plan_cmplt_date '
792: || TO_CHAR (x_batch_header_rec.plan_cmplt_date

Line 791: gme_debug.put_line ( 'affinal plan_cmplt_date '

787: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
788: gme_debug.put_line ( 'affinal plan_start_date '
789: || TO_CHAR (x_batch_header_rec.plan_start_date
790: ,'yyyy/mon/dd hh24:mi:ss') );
791: gme_debug.put_line ( 'affinal plan_cmplt_date '
792: || TO_CHAR (x_batch_header_rec.plan_cmplt_date
793: ,'yyyy/mon/dd hh24:mi:ss') );
794: END IF;
795:

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

808: /* Load all the transactions and resources to the temporary table */
809: /* for the current batch if the update inventory ind is set for the batch */
810: IF x_batch_header_rec.update_inventory_ind = 'Y' THEN
811: IF (NVL (g_debug, 0) IN
812: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
813: gme_debug.put_line
814: ('Load all the transactions and resources to the temporary table.');
815: END IF;
816:

Line 813: gme_debug.put_line

809: /* for the current batch if the update inventory ind is set for the batch */
810: IF x_batch_header_rec.update_inventory_ind = 'Y' THEN
811: IF (NVL (g_debug, 0) IN
812: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
813: gme_debug.put_line
814: ('Load all the transactions and resources to the temporary table.');
815: END IF;
816:
817: gme_trans_engine_util.load_rsrc_trans

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

818: (p_batch_row => x_batch_header_rec
819: ,x_rsc_row_count => l_rsrc_trans_count
820: ,x_return_status => l_return_status);
821:
822: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
823: gme_debug.put_line
824: ( 'Came back after loading all the transactions and resources to the temporary table with status '
825: || l_return_status);
826: END IF;

Line 823: gme_debug.put_line

819: ,x_rsc_row_count => l_rsrc_trans_count
820: ,x_return_status => l_return_status);
821:
822: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
823: gme_debug.put_line
824: ( 'Came back after loading all the transactions and resources to the temporary table with status '
825: || l_return_status);
826: END IF;
827:

Line 851: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

847: l_in_batch_header_rec.plan_cmplt_date :=
848: x_batch_header_rec.plan_start_date;
849: END IF;
850:
851: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
852: gme_debug.put_line
853: ( g_pkg_name
854: || '.'
855: || l_api_name

Line 852: gme_debug.put_line

848: x_batch_header_rec.plan_start_date;
849: END IF;
850:
851: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
852: gme_debug.put_line
853: ( g_pkg_name
854: || '.'
855: || l_api_name
856: || ':'

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

864: ,p_contiguity_override => p_contiguity_override
865: ,x_batch_header_rec => l_batch_header_rec
866: ,x_return_status => l_return_status);
867:
868: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
869: gme_debug.put_line
870: ( 'Came back from Reschedule Batch with status '
871: || l_return_status);
872: END IF;

Line 869: gme_debug.put_line

865: ,x_batch_header_rec => l_batch_header_rec
866: ,x_return_status => l_return_status);
867:
868: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
869: gme_debug.put_line
870: ( 'Came back from Reschedule Batch with status '
871: || l_return_status);
872: END IF;
873:

Line 927: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

923: -- Update the material required date with the associated plan cmplt Date;
924: l_material_date := l_cmplt_date;
925: END IF;
926:
927: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
928: gme_debug.put_line
929: ( 'Calling Material Date Change for batch_id : '
930: || x_batch_header_rec.batch_id
931: || ' Material_detail_id : '

Line 928: gme_debug.put_line

924: l_material_date := l_cmplt_date;
925: END IF;
926:
927: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
928: gme_debug.put_line
929: ( 'Calling Material Date Change for batch_id : '
930: || x_batch_header_rec.batch_id
931: || ' Material_detail_id : '
932: || l_material_detail_ids (i)

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

940: (i)
941: ,p_material_date => l_material_date
942: ,x_return_status => l_return_status);
943:
944: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
945: gme_debug.put_line
946: ( 'Came back from material_date_change with status '
947: || l_return_status);
948: END IF;

Line 945: gme_debug.put_line

941: ,p_material_date => l_material_date
942: ,x_return_status => l_return_status);
943:
944: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
945: gme_debug.put_line
946: ( 'Came back from material_date_change with status '
947: || l_return_status);
948: END IF;
949: --FPBug#4585491 Begin

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

1022: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
1023: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
1024:
1025: IF (NVL (g_debug, 0) IN
1026: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
1027: gme_debug.put_line ( g_pkg_name
1028: || '.'
1029: || l_api_name
1030: || ':'

Line 1027: gme_debug.put_line ( g_pkg_name

1023: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
1024:
1025: IF (NVL (g_debug, 0) IN
1026: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
1027: gme_debug.put_line ( g_pkg_name
1028: || '.'
1029: || l_api_name
1030: || ':'
1031: || 'Exiting with '

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

1048: x_return_status := l_return_status;
1049: WHEN cmplt_less_start OR cannot_reschedule_start OR date_is_less_than_actual THEN
1050: x_return_status := fnd_api.g_ret_sts_error;
1051: WHEN error_cont_period THEN
1052: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1053: gme_debug.put_line ('Contiguity period ... _failed');
1054: END IF;
1055:
1056: x_return_status := l_return_status;

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

1049: WHEN cmplt_less_start OR cannot_reschedule_start OR date_is_less_than_actual THEN
1050: x_return_status := fnd_api.g_ret_sts_error;
1051: WHEN error_cont_period THEN
1052: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1053: gme_debug.put_line ('Contiguity period ... _failed');
1054: END IF;
1055:
1056: x_return_status := l_return_status;
1057: WHEN clear_chg_dates_error THEN

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

1056: x_return_status := l_return_status;
1057: WHEN clear_chg_dates_error THEN
1058: x_return_status := fnd_api.g_ret_sts_error;
1059: WHEN error_non_contiguious THEN
1060: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1061: gme_debug.put_line ('Contiguity period ... not found');
1062: END IF;
1063:
1064: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');

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

1057: WHEN clear_chg_dates_error THEN
1058: x_return_status := fnd_api.g_ret_sts_error;
1059: WHEN error_non_contiguious THEN
1060: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1061: gme_debug.put_line ('Contiguity period ... not found');
1062: END IF;
1063:
1064: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');
1065: x_return_status := 'C';

Line 1087: gme_debug.put_line ( g_pkg_name

1083: x_return_status := fnd_api.g_ret_sts_unexp_error;
1084: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1085:
1086: IF (NVL (g_debug, 0) > 0) THEN
1087: gme_debug.put_line ( g_pkg_name
1088: || '.'
1089: || l_api_name
1090: || ':'
1091: || ' OTHERS:'

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

1125: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_TRANSACTION';
1126: l_batch_id NUMBER := 0;
1127: l_doc_type VARCHAR2 (4);
1128: BEGIN
1129: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1130: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1131: || 'Entering');
1132: END IF;
1133:

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

1126: l_batch_id NUMBER := 0;
1127: l_doc_type VARCHAR2 (4);
1128: BEGIN
1129: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1130: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1131: || 'Entering');
1132: END IF;
1133:
1134: /* Set the return status to success initially */

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

1140: ELSE
1141: l_doc_type := 'FPO';
1142: END IF;
1143:
1144: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1145: gme_debug.put_line ('batch_id=' || l_batch_id);
1146: END IF;
1147:
1148: IF p_date = 0 THEN

Line 1145: gme_debug.put_line ('batch_id=' || l_batch_id);

1141: l_doc_type := 'FPO';
1142: END IF;
1143:
1144: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1145: gme_debug.put_line ('batch_id=' || l_batch_id);
1146: END IF;
1147:
1148: IF p_date = 0 THEN
1149: --update batch start date

Line 1414: gme_debug.put_line ( g_pkg_name

1410: x_return_status := fnd_api.g_ret_sts_unexp_error;
1411: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1412:
1413: IF (NVL (g_debug, 0) > 0) THEN
1414: gme_debug.put_line ( g_pkg_name
1415: || '.'
1416: || l_api_name
1417: || ':'
1418: || ' OTHERS:'