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

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

168: l_source_step_id_tbl step_tab;
169: l_calendar_code VARCHAR2 (10);
170: BEGIN
171: IF (NVL (g_debug, 0) IN
172: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
173: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
174: || 'Entering');
175: END IF;
176:

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

169: l_calendar_code VARCHAR2 (10);
170: BEGIN
171: IF (NVL (g_debug, 0) IN
172: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
173: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
174: || 'Entering');
175: END IF;
176:
177: /* Set the return status to success initially */

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

198: ,l_batch_header_rec) ) THEN
199: RAISE batch_header_fetch_error;
200: END IF;
201:
202: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
203: gme_debug.put_line ( 'trying to reschedule steps to '
204: || TO_CHAR (p_batch_step_rec.plan_start_date
205: ,'DD-MON-YYYY HH24:MI:SS') );
206: gme_debug.put_line ( 'trying to reschedule steps cmp to '

Line 203: gme_debug.put_line ( 'trying to reschedule steps to '

199: RAISE batch_header_fetch_error;
200: END IF;
201:
202: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
203: gme_debug.put_line ( 'trying to reschedule steps to '
204: || TO_CHAR (p_batch_step_rec.plan_start_date
205: ,'DD-MON-YYYY HH24:MI:SS') );
206: gme_debug.put_line ( 'trying to reschedule steps cmp to '
207: || TO_CHAR (p_batch_step_rec.plan_cmplt_date

Line 206: gme_debug.put_line ( 'trying to reschedule steps cmp to '

202: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
203: gme_debug.put_line ( 'trying to reschedule steps to '
204: || TO_CHAR (p_batch_step_rec.plan_start_date
205: ,'DD-MON-YYYY HH24:MI:SS') );
206: gme_debug.put_line ( 'trying to reschedule steps cmp to '
207: || TO_CHAR (p_batch_step_rec.plan_cmplt_date
208: ,'DD-MON-YYYY HH24:MI:SS') );
209: gme_debug.put_line ( 'Going to check previous step of '
210: || TO_CHAR (x_batch_step_rec.batchstep_no) );

Line 209: gme_debug.put_line ( 'Going to check previous step of '

205: ,'DD-MON-YYYY HH24:MI:SS') );
206: gme_debug.put_line ( 'trying to reschedule steps cmp to '
207: || TO_CHAR (p_batch_step_rec.plan_cmplt_date
208: ,'DD-MON-YYYY HH24:MI:SS') );
209: gme_debug.put_line ( 'Going to check previous step of '
210: || TO_CHAR (x_batch_step_rec.batchstep_no) );
211: gme_debug.put_line ( 'p_source_step_id_tbl '
212: || TO_CHAR (p_source_step_id_tbl.COUNT) );
213: END IF;

Line 211: gme_debug.put_line ( 'p_source_step_id_tbl '

207: || TO_CHAR (p_batch_step_rec.plan_cmplt_date
208: ,'DD-MON-YYYY HH24:MI:SS') );
209: gme_debug.put_line ( 'Going to check previous step of '
210: || TO_CHAR (x_batch_step_rec.batchstep_no) );
211: gme_debug.put_line ( 'p_source_step_id_tbl '
212: || TO_CHAR (p_source_step_id_tbl.COUNT) );
213: END IF;
214:
215: IF (l_batch_header_rec.batch_type = 0) THEN

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

218: l_doc_type := 'FPO';
219: END IF;
220:
221: IF l_batch_header_rec.update_inventory_ind = 'Y' THEN
222: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
223: gme_debug.put_line ( 'deleting transactions for '
224: || x_batch_step_rec.batchstep_id);
225: END IF;
226:

Line 223: gme_debug.put_line ( 'deleting transactions for '

219: END IF;
220:
221: IF l_batch_header_rec.update_inventory_ind = 'Y' THEN
222: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
223: gme_debug.put_line ( 'deleting transactions for '
224: || x_batch_step_rec.batchstep_id);
225: END IF;
226:
227: DELETE FROM gme_resource_txns

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

252: ,p_step_id => p_batch_step_rec.batchstep_id
253: ,p_plan_start_date => p_batch_step_rec.plan_start_date
254: ,p_plan_cmplt_date => p_batch_step_rec.plan_cmplt_date);
255:
256: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
257: gme_debug.put_line ( 'Return status from calc_dates '
258: || l_return_status);
259: END IF;
260:

Line 257: gme_debug.put_line ( 'Return status from calc_dates '

253: ,p_plan_start_date => p_batch_step_rec.plan_start_date
254: ,p_plan_cmplt_date => p_batch_step_rec.plan_cmplt_date);
255:
256: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
257: gme_debug.put_line ( 'Return status from calc_dates '
258: || l_return_status);
259: END IF;
260:
261: IF l_return_status <> x_return_status THEN

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

305: WHERE batch_id = p_batch_step_rec.batch_id
306: AND batchstep_id = p_batch_step_rec.batchstep_id;
307: --Bug#4543875
308:
309: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
310: gme_debug.put_line ( g_pkg_name
311: || '.'
312: || l_api_name
313: || ':'

Line 310: gme_debug.put_line ( g_pkg_name

306: AND batchstep_id = p_batch_step_rec.batchstep_id;
307: --Bug#4543875
308:
309: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
310: gme_debug.put_line ( g_pkg_name
311: || '.'
312: || l_api_name
313: || ':'
314: || 'Calling Save_all_data');

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

321: ,x_batch_step_rec.plan_start_date
322: ,x_batch_step_rec.plan_cmplt_date
323: ,l_return_status);
324:
325: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
326: gme_debug.put_line ( 'Came back from save all data with status '
327: || l_return_status);
328: END IF;
329:

Line 326: gme_debug.put_line ( 'Came back from save all data with status '

322: ,x_batch_step_rec.plan_cmplt_date
323: ,l_return_status);
324:
325: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
326: gme_debug.put_line ( 'Came back from save all data with status '
327: || l_return_status);
328: END IF;
329:
330: IF l_return_status <> x_return_status THEN

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

398: ,p_batchstep_id => l_batch_step_rec.batchstep_id
399: ,p_batch_id => l_batch_step_m_rec.batch_id
400: ,p_batch_start_date => l_batch_step_m_rec.plan_start_date);
401:
402: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
403: gme_debug.put_line
404: ( 'MAX date '
405: || TO_CHAR (l_max_date
406: ,'DD-MON-YYYY HH24:MI:SS')

Line 403: gme_debug.put_line

399: ,p_batch_id => l_batch_step_m_rec.batch_id
400: ,p_batch_start_date => l_batch_step_m_rec.plan_start_date);
401:
402: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
403: gme_debug.put_line
404: ( 'MAX date '
405: || TO_CHAR (l_max_date
406: ,'DD-MON-YYYY HH24:MI:SS')
407: || ' plan start '

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

414: l_batch_step_rec.plan_cmplt_date := NULL;
415: l_source_step_id_tbl (l_source_step_id_tbl.COUNT + 1) :=
416: p_batch_step_rec.batchstep_id;
417:
418: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
419: gme_debug.put_line
420: ( g_pkg_name
421: || '.'
422: || l_api_name

Line 419: gme_debug.put_line

415: l_source_step_id_tbl (l_source_step_id_tbl.COUNT + 1) :=
416: p_batch_step_rec.batchstep_id;
417:
418: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
419: gme_debug.put_line
420: ( g_pkg_name
421: || '.'
422: || l_api_name
423: || ':'

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

434: ,p_use_workday_cal => p_use_workday_cal
435: ,x_batch_step_rec => x_batch_step_rec
436: ,x_return_status => l_return_status);
437:
438: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
439: gme_debug.put_line
440: ( 'Back from reschedule_succeeding_steps with status '
441: || l_return_status
442: || ' for step ID '

Line 439: gme_debug.put_line

435: ,x_batch_step_rec => x_batch_step_rec
436: ,x_return_status => l_return_status);
437:
438: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
439: gme_debug.put_line
440: ( 'Back from reschedule_succeeding_steps with status '
441: || l_return_status
442: || ' for step ID '
443: || p_batch_step_rec.batchstep_id);

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

534: l_cal_count := l_contig_period_tbl.COUNT;
535: l_date := l_contig_period_tbl (l_cal_count).end_date;
536: END IF; /* l_dep_step_rec.standard_delay >= 0 */
537:
538: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
539: gme_debug.put_line
540: ( 'Called to get the cmplt date for step prior to '
541: || l_batch_step_m_rec.batchstep_id
542: || ' '

Line 539: gme_debug.put_line

535: l_date := l_contig_period_tbl (l_cal_count).end_date;
536: END IF; /* l_dep_step_rec.standard_delay >= 0 */
537:
538: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
539: gme_debug.put_line
540: ( 'Called to get the cmplt date for step prior to '
541: || l_batch_step_m_rec.batchstep_id
542: || ' '
543: || TO_CHAR (l_batch_step_m_rec.plan_start_date

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

564:
565: l_source_step_id_tbl (l_source_step_id_tbl.COUNT + 1) :=
566: p_batch_step_rec.batchstep_id;
567:
568: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
569: gme_debug.put_line
570: ( 'Calling reschedule for batchstep_id '
571: || l_batch_step_rec.batchstep_id);
572: END IF;

Line 569: gme_debug.put_line

565: l_source_step_id_tbl (l_source_step_id_tbl.COUNT + 1) :=
566: p_batch_step_rec.batchstep_id;
567:
568: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
569: gme_debug.put_line
570: ( 'Calling reschedule for batchstep_id '
571: || l_batch_step_rec.batchstep_id);
572: END IF;
573:

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

570: ( 'Calling reschedule for batchstep_id '
571: || l_batch_step_rec.batchstep_id);
572: END IF;
573:
574: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
575: gme_debug.put_line
576: ( g_pkg_name
577: || '.'
578: || l_api_name

Line 575: gme_debug.put_line

571: || l_batch_step_rec.batchstep_id);
572: END IF;
573:
574: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
575: gme_debug.put_line
576: ( g_pkg_name
577: || '.'
578: || l_api_name
579: || ':'

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

590: ,p_use_workday_cal => p_use_workday_cal
591: ,x_batch_step_rec => x_batch_step_rec
592: ,x_return_status => l_return_status);
593:
594: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
595: gme_debug.put_line
596: ( 'Back from reschedule source steps with status '
597: || l_return_status
598: || ' Steps IDs COUNT '

Line 595: gme_debug.put_line

591: ,x_batch_step_rec => x_batch_step_rec
592: ,x_return_status => l_return_status);
593:
594: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
595: gme_debug.put_line
596: ( 'Back from reschedule source steps with status '
597: || l_return_status
598: || ' Steps IDs COUNT '
599: || l_source_step_id_tbl.COUNT

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

615: CLOSE cur_get_prec_steps;
616: END IF; /* p_reschedule_preceding = FND_API.G_TRUE */
617: -- END IF; /* l_batch_header_rec.enforce_step_dependency = 1 OR */
618:
619: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
620: gme_debug.put_line ( 'Done with succ as well as prec for '
621: || p_batch_step_rec.batchstep_id);
622: END IF;
623:

Line 620: gme_debug.put_line ( 'Done with succ as well as prec for '

616: END IF; /* p_reschedule_preceding = FND_API.G_TRUE */
617: -- END IF; /* l_batch_header_rec.enforce_step_dependency = 1 OR */
618:
619: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
620: gme_debug.put_line ( 'Done with succ as well as prec for '
621: || p_batch_step_rec.batchstep_id);
622: END IF;
623:
624: IF p_source_step_id_tbl.COUNT = 0 THEN

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

669: /* l_min_start_date < l_batch_header_rec.plan_start_date */
670: END IF; /* l_batch_header_rec.enforce_step_dependency = 1 */
671: END IF; /* l_batch_header_rec.batch_status = 2 */
672:
673: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
674: gme_debug.put_line
675: ( 'New min/max Dates are '
676: || TO_CHAR (l_min_start_date
677: ,'DD-MON-YYYY HH24:MI:SS')

Line 674: gme_debug.put_line

670: END IF; /* l_batch_header_rec.enforce_step_dependency = 1 */
671: END IF; /* l_batch_header_rec.batch_status = 2 */
672:
673: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
674: gme_debug.put_line
675: ( 'New min/max Dates are '
676: || TO_CHAR (l_min_start_date
677: ,'DD-MON-YYYY HH24:MI:SS')
678: || ' and '

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

744: x_return_status := fnd_api.g_ret_sts_error;
745: RAISE date_exceed_validity_rule;
746: END IF;
747: ELSE
748: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
749: gme_debug.put_line ( g_pkg_name
750: || '.'
751: || l_api_name
752: || ':'

Line 749: gme_debug.put_line ( g_pkg_name

745: RAISE date_exceed_validity_rule;
746: END IF;
747: ELSE
748: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
749: gme_debug.put_line ( g_pkg_name
750: || '.'
751: || l_api_name
752: || ':'
753: || 'Do not Check Validity Rule Dates as this is LCF batch');

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

819: --Bug#5606089
820: l_material_date := x_batch_step2_rec.plan_cmplt_date;
821: --l_material_date := x_batch_step_rec.plan_cmplt_date;
822: END IF;
823: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
824: gme_debug.put_line
825: ( 'Calling Material Date Change for batchstep_id : '
826: || x_batch_step2_rec.batchstep_id
827: || ' Material_detail_id : '

Line 824: gme_debug.put_line

820: l_material_date := x_batch_step2_rec.plan_cmplt_date;
821: --l_material_date := x_batch_step_rec.plan_cmplt_date;
822: END IF;
823: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
824: gme_debug.put_line
825: ( 'Calling Material Date Change for batchstep_id : '
826: || x_batch_step2_rec.batchstep_id
827: || ' Material_detail_id : '
828: || l_material_detail_id_tbl (i)

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

833: (i)
834: ,p_material_date => l_material_date
835: ,x_return_status => l_return_status);
836:
837: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
838: gme_debug.put_line
839: ( 'Came back from material_date_change with status for step '
840: || l_return_status);
841: END IF;

Line 838: gme_debug.put_line

834: ,p_material_date => l_material_date
835: ,x_return_status => l_return_status);
836:
837: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
838: gme_debug.put_line
839: ( 'Came back from material_date_change with status for step '
840: || l_return_status);
841: END IF;
842:

Line 855: gme_debug.put_line('3');

851: RAISE fnd_api.g_exc_unexpected_error;
852: END IF;
853:
854: ELSE
855: gme_debug.put_line('3');
856: -- Navin Added as part of Reschedule Batch/Step Build.
857: IF l_line_type_tbl (i) = gme_common_pvt.g_line_type_ing THEN
858: -- Update the material_required_date with the associated plan_start_Date;
859: l_material_date := l_batch_header_rec.plan_start_date;

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

861: -- Update the material required date with the associated plan cmplt Date;
862: l_material_date := l_batch_header_rec.plan_cmplt_date;
863: END IF;
864:
865: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
866: gme_debug.put_line
867: ( 'Calling Material Date Change for batch_id : '
868: || l_batch_header_rec.batch_id
869: || ' Material_detail_id : '

Line 866: gme_debug.put_line

862: l_material_date := l_batch_header_rec.plan_cmplt_date;
863: END IF;
864:
865: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
866: gme_debug.put_line
867: ( 'Calling Material Date Change for batch_id : '
868: || l_batch_header_rec.batch_id
869: || ' Material_detail_id : '
870: || l_material_detail_id_tbl (i)

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

876: (i)
877: ,p_material_date => l_material_date
878: ,x_return_status => l_return_status);
879:
880: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
881: gme_debug.put_line
882: ( 'Came back from material_date_change with status '
883: || l_return_status);
884: END IF;

Line 881: gme_debug.put_line

877: ,p_material_date => l_material_date
878: ,x_return_status => l_return_status);
879:
880: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
881: gme_debug.put_line
882: ( 'Came back from material_date_change with status '
883: || l_return_status);
884: END IF;
885: --FPBug#4585491 Begin

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

932:
933: IF cur_is_charge_associated%FOUND THEN
934: CLOSE cur_is_charge_associated;
935:
936: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
937: gme_debug.put_line ( g_pkg_name
938: || '.'
939: || l_api_name
940: || ':'

Line 937: gme_debug.put_line ( g_pkg_name

933: IF cur_is_charge_associated%FOUND THEN
934: CLOSE cur_is_charge_associated;
935:
936: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
937: gme_debug.put_line ( g_pkg_name
938: || '.'
939: || l_api_name
940: || ':'
941: || 'Calling Clear charge dates for Batch_id:'

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

948: (p_batch_id => l_batch_header_rec.batch_id
949: ,p_batchstep_id => p_batch_step_rec.batchstep_id
950: ,x_return_status => l_return_status);
951:
952: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
953: gme_debug.put_line
954: ( 'Came back from Clear charge dates with status '
955: || l_return_status);
956: END IF;

Line 953: gme_debug.put_line

949: ,p_batchstep_id => p_batch_step_rec.batchstep_id
950: ,x_return_status => l_return_status);
951:
952: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
953: gme_debug.put_line
954: ( 'Came back from Clear charge dates with status '
955: || l_return_status);
956: END IF;
957:

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

972: , p_gme_matl_dtl => NULL
973: );
974: */
975: IF (NVL (g_debug, 0) IN
976: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
977: gme_debug.put_line ( g_pkg_name
978: || '.'
979: || l_api_name
980: || ':'

Line 977: gme_debug.put_line ( g_pkg_name

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

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

1008: WHEN step_start_date_low THEN
1009: x_return_status := fnd_api.g_ret_sts_error;
1010: gme_common_pvt.log_message ('GME_ESD_PLAN_DATE');
1011: WHEN error_cont_period THEN
1012: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1013: gme_debug.put_line ('Contiguity period ... _failed');
1014: END IF;
1015:
1016: x_return_status := l_return_status;

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

1009: x_return_status := fnd_api.g_ret_sts_error;
1010: gme_common_pvt.log_message ('GME_ESD_PLAN_DATE');
1011: WHEN error_cont_period THEN
1012: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1013: gme_debug.put_line ('Contiguity period ... _failed');
1014: END IF;
1015:
1016: x_return_status := l_return_status;
1017: WHEN error_non_contiguious THEN

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

1014: END IF;
1015:
1016: x_return_status := l_return_status;
1017: WHEN error_non_contiguious THEN
1018: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1019: gme_debug.put_line ('Contiguity period ... not found');
1020: END IF;
1021:
1022: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');

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

1015:
1016: x_return_status := l_return_status;
1017: WHEN error_non_contiguious THEN
1018: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1019: gme_debug.put_line ('Contiguity period ... not found');
1020: END IF;
1021:
1022: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');
1023: x_return_status := 'C';

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

1033: x_return_status := l_return_status;
1034: WHEN clear_chg_dates_error THEN
1035: x_return_status := fnd_api.g_ret_sts_error;
1036: WHEN OTHERS THEN
1037: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1038: gme_debug.put_line (l_api_name || ':OTHERS ' || SQLERRM);
1039: END IF;
1040:
1041: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1038: gme_debug.put_line (l_api_name || ':OTHERS ' || SQLERRM);

1034: WHEN clear_chg_dates_error THEN
1035: x_return_status := fnd_api.g_ret_sts_error;
1036: WHEN OTHERS THEN
1037: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1038: gme_debug.put_line (l_api_name || ':OTHERS ' || SQLERRM);
1039: END IF;
1040:
1041: x_return_status := fnd_api.g_ret_sts_unexp_error;
1042: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

1106: AND batchstep_id = v_batchstep_id
1107: AND material_detail_id = det.material_detail_id);
1108: BEGIN
1109: IF (NVL (g_debug, 0) IN
1110: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
1111: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1112: || 'Entering');
1113: END IF;
1114:

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

1107: AND material_detail_id = det.material_detail_id);
1108: BEGIN
1109: IF (NVL (g_debug, 0) IN
1110: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
1111: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1112: || 'Entering');
1113: END IF;
1114:
1115: /* Initialize return status to success */

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

1140: -- Update the material required date with the associated plan cmplt Date;
1141: l_material_date := p_end_date;
1142: END IF;
1143:
1144: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
1145: gme_debug.put_line
1146: ( 'Calling Material Date Change for batch_id : '
1147: || l_batch_header_rec.batch_id
1148: || ' Material_detail_id : '

Line 1145: gme_debug.put_line

1141: l_material_date := p_end_date;
1142: END IF;
1143:
1144: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
1145: gme_debug.put_line
1146: ( 'Calling Material Date Change for batch_id : '
1147: || l_batch_header_rec.batch_id
1148: || ' Material_detail_id : '
1149: || l_material_detail_id_tbl (i) );

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

1154: (i)
1155: ,p_material_date => l_material_date
1156: ,x_return_status => l_return_status);
1157:
1158: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1159: gme_debug.put_line
1160: ( 'Came back from Material Date Change with status '
1161: || l_return_status);
1162: END IF;

Line 1159: gme_debug.put_line

1155: ,p_material_date => l_material_date
1156: ,x_return_status => l_return_status);
1157:
1158: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1159: gme_debug.put_line
1160: ( 'Came back from Material Date Change with status '
1161: || l_return_status);
1162: END IF;
1163: --FPBug#4585491 Begin

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

1204:
1205: /* Now we have to reschedule the batch associated with the step */
1206: /* lines of release type step release */
1207: /* All means manual, incremental and auto by step... NOT AUTO */
1208: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1209: gme_debug.put_line ('Calling Fetch Step Phantoms.');
1210: END IF;
1211:
1212: gme_phantom_pvt.fetch_step_phantoms

Line 1209: gme_debug.put_line ('Calling Fetch Step Phantoms.');

1205: /* Now we have to reschedule the batch associated with the step */
1206: /* lines of release type step release */
1207: /* All means manual, incremental and auto by step... NOT AUTO */
1208: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1209: gme_debug.put_line ('Calling Fetch Step Phantoms.');
1210: END IF;
1211:
1212: gme_phantom_pvt.fetch_step_phantoms
1213: (p_batch_id => p_batch_step_rec.batch_id

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

1215: ,p_all_release_type_assoc => 1
1216: ,x_phantom_ids => l_phantom_ids
1217: ,x_return_status => l_return_status);
1218:
1219: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1220: gme_debug.put_line
1221: ( 'Came back from Fetch Step Phantoms with status '
1222: || l_return_status);
1223: END IF;

Line 1220: gme_debug.put_line

1216: ,x_phantom_ids => l_phantom_ids
1217: ,x_return_status => l_return_status);
1218:
1219: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1220: gme_debug.put_line
1221: ( 'Came back from Fetch Step Phantoms with status '
1222: || l_return_status);
1223: END IF;
1224:

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

1244: END IF;
1245: END LOOP; /* i IN 1 .. l_phantom_ids.COUNT */
1246:
1247: IF (NVL (g_debug, 0) IN
1248: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
1249: gme_debug.put_line ( g_pkg_name
1250: || '.'
1251: || l_api_name
1252: || ':'

Line 1249: gme_debug.put_line ( g_pkg_name

1245: END LOOP; /* i IN 1 .. l_phantom_ids.COUNT */
1246:
1247: IF (NVL (g_debug, 0) IN
1248: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
1249: gme_debug.put_line ( g_pkg_name
1250: || '.'
1251: || l_api_name
1252: || ':'
1253: || 'Exiting with '

Line 1266: gme_debug.put_line ( g_pkg_name

1262: x_return_status := fnd_api.g_ret_sts_unexp_error;
1263: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1264:
1265: IF (NVL (g_debug, 0) > 0) THEN
1266: gme_debug.put_line ( g_pkg_name
1267: || '.'
1268: || l_api_name
1269: || ':'
1270: || ' OTHERS:'