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

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

31: leadtime_err EXCEPTION;
32: batch_offset_err EXCEPTION;
33: offset_type_err EXCEPTION;
34: BEGIN
35: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
36: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
37: || l_api_name);
38: END IF;
39:

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

32: batch_offset_err EXCEPTION;
33: offset_type_err EXCEPTION;
34: BEGIN
35: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
36: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
37: || l_api_name);
38: END IF;
39:
40: IF (p_plan_start_date IS NULL AND p_plan_cmplt_date IS NULL) THEN

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

50: ELSIF (p_plan_cmplt_date IS NOT NULL AND p_plan_start_date IS NULL) THEN
51: x_pregen_fpo_row.schedule_method := 'BACKWARD';
52: END IF;
53:
54: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
55: gme_debug.put_line (g_pkg_name ||
56: '.' ||
57: l_api_name ||
58: ' schedule method is '||

Line 55: gme_debug.put_line (g_pkg_name ||

51: x_pregen_fpo_row.schedule_method := 'BACKWARD';
52: END IF;
53:
54: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
55: gme_debug.put_line (g_pkg_name ||
56: '.' ||
57: l_api_name ||
58: ' schedule method is '||
59: x_pregen_fpo_row.schedule_method);

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

95: RAISE offset_type_err;
96: END IF;
97:
98: --load parameters into structure.
99: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
100: gme_debug.put_line ('assigning all values to x_pregen_fpo_row');
101: END IF;
102:
103: x_return_status := fnd_api.g_ret_sts_success;

Line 100: gme_debug.put_line ('assigning all values to x_pregen_fpo_row');

96: END IF;
97:
98: --load parameters into structure.
99: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
100: gme_debug.put_line ('assigning all values to x_pregen_fpo_row');
101: END IF;
102:
103: x_return_status := fnd_api.g_ret_sts_success;
104: x_pregen_fpo_row.qty_per_batch := p_batch_size;

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

126: x_pregen_fpo_row.sum_eff_qty :=
127: x_pregen_fpo_row.num_batches * x_pregen_fpo_row.qty_per_batch;
128: END IF;
129:
130: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
131: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
132: END IF;
133: EXCEPTION
134: WHEN no_null_dates THEN

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

127: x_pregen_fpo_row.num_batches * x_pregen_fpo_row.qty_per_batch;
128: END IF;
129:
130: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
131: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
132: END IF;
133: EXCEPTION
134: WHEN no_null_dates THEN
135: gme_common_pvt.log_message ('GME_NO_NULL_DATES');

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

245: /* Exception definitions */
246: no_fetch_material_details EXCEPTION;
247: batch_fetch_error EXCEPTION;
248: BEGIN
249: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
250: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
251: || l_api_name);
252: END IF;
253: x_return_status := fnd_api.g_ret_sts_success;

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

246: no_fetch_material_details EXCEPTION;
247: batch_fetch_error EXCEPTION;
248: BEGIN
249: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
250: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
251: || l_api_name);
252: END IF;
253: x_return_status := fnd_api.g_ret_sts_success;
254: l_pregen_fpo_row := p_pregen_fpo_row;

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

259: -- exception added
260: IF NOT l_return THEN
261: RAISE batch_fetch_error;
262: END IF;
263: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
264: gme_debug.put_line (g_pkg_name ||
265: '.' ||
266: l_api_name ||
267: ' batch header fetch_row returns success ');

Line 264: gme_debug.put_line (g_pkg_name ||

260: IF NOT l_return THEN
261: RAISE batch_fetch_error;
262: END IF;
263: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
264: gme_debug.put_line (g_pkg_name ||
265: '.' ||
266: l_api_name ||
267: ' batch header fetch_row returns success ');
268: END IF;

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

267: ' batch header fetch_row returns success ');
268: END IF;
269:
270: --Retrieve fpo_material_details into local fpo_material_details structure.
271: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
272: gme_debug.put_line (g_pkg_name ||
273: '.' ||
274: l_api_name ||
275: ' Retrieve material details for batch_id '||

Line 272: gme_debug.put_line (g_pkg_name ||

268: END IF;
269:
270: --Retrieve fpo_material_details into local fpo_material_details structure.
271: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
272: gme_debug.put_line (g_pkg_name ||
273: '.' ||
274: l_api_name ||
275: ' Retrieve material details for batch_id '||
276: x_fpo_header_row.batch_id);

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

378:
379: CLOSE get_production_rules;
380:
381: x_pregen_fpo_row := l_pregen_fpo_row;
382: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
383: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
384: END IF;
385: EXCEPTION
386: WHEN no_fetch_material_details THEN

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

379: CLOSE get_production_rules;
380:
381: x_pregen_fpo_row := l_pregen_fpo_row;
382: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
383: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
384: END IF;
385: EXCEPTION
386: WHEN no_fetch_material_details THEN
387: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

383: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
384: END IF;
385: EXCEPTION
386: WHEN no_fetch_material_details THEN
387: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
388: gme_debug.put_line ('no fetch material_details');
389: END IF;
390:
391: gme_common_pvt.log_message ('PM_NO_MATL_DTL');

Line 388: gme_debug.put_line ('no fetch material_details');

384: END IF;
385: EXCEPTION
386: WHEN no_fetch_material_details THEN
387: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
388: gme_debug.put_line ('no fetch material_details');
389: END IF;
390:
391: gme_common_pvt.log_message ('PM_NO_MATL_DTL');
392: x_return_status := fnd_api.g_ret_sts_error;

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

406: ,x_return_status OUT NOCOPY VARCHAR2)
407: IS
408: l_api_name CONSTANT VARCHAR2 (30) := 'CALCULATE_LEADTIME';
409: BEGIN
410: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
411: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
412: || l_api_name);
413: END IF;
414:

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

407: IS
408: l_api_name CONSTANT VARCHAR2 (30) := 'CALCULATE_LEADTIME';
409: BEGIN
410: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
411: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
412: || l_api_name);
413: END IF;
414:
415: x_pregen_fpo_row := p_pregen_fpo_row;

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

425: * p_pregen_fpo_row.qty_per_batch
426: / p_pregen_fpo_row.std_qty);
427: END IF;
428: --Bug2804440
429: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
430: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
431: END IF;
432: EXCEPTION
433: WHEN OTHERS THEN

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

426: / p_pregen_fpo_row.std_qty);
427: END IF;
428: --Bug2804440
429: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
430: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
431: END IF;
432: EXCEPTION
433: WHEN OTHERS THEN
434: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

458: l_generated_pre_batch_tab generated_pre_batch_tab;
459: /* Exception definitions */
460: generate_pre_batch_err EXCEPTION;
461: BEGIN
462: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
463: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
464: || l_api_name);
465: END IF;
466:

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

459: /* Exception definitions */
460: generate_pre_batch_err EXCEPTION;
461: BEGIN
462: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
463: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
464: || l_api_name);
465: END IF;
466:
467: l_fpo_header_row := p_fpo_header_row;

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

468: l_prim_prod_row := p_prim_prod_row;
469: l_pregen_fpo_row := p_pregen_fpo_row;
470:
471: --Convert variables expressed in hours to days.
472: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
473: gme_debug.put_line ( 'l_pregen_fpo_row.leadtime = '
474: || TO_CHAR (l_pregen_fpo_row.leadtime) );
475: END IF;
476:

Line 473: gme_debug.put_line ( 'l_pregen_fpo_row.leadtime = '

469: l_pregen_fpo_row := p_pregen_fpo_row;
470:
471: --Convert variables expressed in hours to days.
472: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
473: gme_debug.put_line ( 'l_pregen_fpo_row.leadtime = '
474: || TO_CHAR (l_pregen_fpo_row.leadtime) );
475: END IF;
476:
477: x_batch_leadtime_days := l_pregen_fpo_row.leadtime / 24;

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

475: END IF;
476:
477: x_batch_leadtime_days := l_pregen_fpo_row.leadtime / 24;
478:
479: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
480: gme_debug.put_line ( 'x_batch_leadtime_days = '
481: || TO_CHAR (x_batch_leadtime_days) );
482: gme_debug.put_line ( 'l_pregen_fpo_row.batch_offset = '
483: || TO_CHAR (l_pregen_fpo_row.batch_offset) );

Line 480: gme_debug.put_line ( 'x_batch_leadtime_days = '

476:
477: x_batch_leadtime_days := l_pregen_fpo_row.leadtime / 24;
478:
479: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
480: gme_debug.put_line ( 'x_batch_leadtime_days = '
481: || TO_CHAR (x_batch_leadtime_days) );
482: gme_debug.put_line ( 'l_pregen_fpo_row.batch_offset = '
483: || TO_CHAR (l_pregen_fpo_row.batch_offset) );
484: END IF;

Line 482: gme_debug.put_line ( 'l_pregen_fpo_row.batch_offset = '

478:
479: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
480: gme_debug.put_line ( 'x_batch_leadtime_days = '
481: || TO_CHAR (x_batch_leadtime_days) );
482: gme_debug.put_line ( 'l_pregen_fpo_row.batch_offset = '
483: || TO_CHAR (l_pregen_fpo_row.batch_offset) );
484: END IF;
485:
486: x_batch_offset_days := l_pregen_fpo_row.batch_offset / 24;

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

484: END IF;
485:
486: x_batch_offset_days := l_pregen_fpo_row.batch_offset / 24;
487:
488: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
489: gme_debug.put_line ( 'x_batch_offset_days = '
490: || TO_CHAR (x_batch_offset_days) );
491: END IF;
492:

Line 489: gme_debug.put_line ( 'x_batch_offset_days = '

485:
486: x_batch_offset_days := l_pregen_fpo_row.batch_offset / 24;
487:
488: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
489: gme_debug.put_line ( 'x_batch_offset_days = '
490: || TO_CHAR (x_batch_offset_days) );
491: END IF;
492:
493: --Negative values of above.

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

492:
493: --Negative values of above.
494: x_neg_batch_leadtime_days := x_batch_leadtime_days * -1;
495:
496: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
497: gme_debug.put_line ( 'x_neg_batch_leadtime_days = '
498: || TO_CHAR (x_neg_batch_leadtime_days) );
499: END IF;
500:

Line 497: gme_debug.put_line ( 'x_neg_batch_leadtime_days = '

493: --Negative values of above.
494: x_neg_batch_leadtime_days := x_batch_leadtime_days * -1;
495:
496: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
497: gme_debug.put_line ( 'x_neg_batch_leadtime_days = '
498: || TO_CHAR (x_neg_batch_leadtime_days) );
499: END IF;
500:
501: x_neg_batch_offset_days := x_batch_offset_days * -1;

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

499: END IF;
500:
501: x_neg_batch_offset_days := x_batch_offset_days * -1;
502:
503: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
504: gme_debug.put_line ( 'x_neg_batch_offset_days = '
505: || TO_CHAR (x_neg_batch_offset_days) );
506: gme_debug.put_line ( 'l_pregen_fpo_row.schedule_method = '
507: || (l_pregen_fpo_row.schedule_method) );

Line 504: gme_debug.put_line ( 'x_neg_batch_offset_days = '

500:
501: x_neg_batch_offset_days := x_batch_offset_days * -1;
502:
503: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
504: gme_debug.put_line ( 'x_neg_batch_offset_days = '
505: || TO_CHAR (x_neg_batch_offset_days) );
506: gme_debug.put_line ( 'l_pregen_fpo_row.schedule_method = '
507: || (l_pregen_fpo_row.schedule_method) );
508: END IF;

Line 506: gme_debug.put_line ( 'l_pregen_fpo_row.schedule_method = '

502:
503: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
504: gme_debug.put_line ( 'x_neg_batch_offset_days = '
505: || TO_CHAR (x_neg_batch_offset_days) );
506: gme_debug.put_line ( 'l_pregen_fpo_row.schedule_method = '
507: || (l_pregen_fpo_row.schedule_method) );
508: END IF;
509: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
510: gme_debug.put_line (g_pkg_name ||

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

505: || TO_CHAR (x_neg_batch_offset_days) );
506: gme_debug.put_line ( 'l_pregen_fpo_row.schedule_method = '
507: || (l_pregen_fpo_row.schedule_method) );
508: END IF;
509: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
510: gme_debug.put_line (g_pkg_name ||
511: '.' ||
512: l_api_name ||
513: ' Begin looping here for count of '||

Line 510: gme_debug.put_line (g_pkg_name ||

506: gme_debug.put_line ( 'l_pregen_fpo_row.schedule_method = '
507: || (l_pregen_fpo_row.schedule_method) );
508: END IF;
509: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
510: gme_debug.put_line (g_pkg_name ||
511: '.' ||
512: l_api_name ||
513: ' Begin looping here for count of '||
514: l_pregen_fpo_row.num_batches);

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

544: l_pregen_fpo_row.plan_cmplt_date
545: + x_neg_batch_leadtime_days;
546: END IF;
547:
548: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
549: gme_debug.put_line
550: ( 'l_generated_pre_batch_tab(i).plan_start_date = '
551: || TO_CHAR
552: (l_generated_pre_batch_tab (i).plan_start_date

Line 549: gme_debug.put_line

545: + x_neg_batch_leadtime_days;
546: END IF;
547:
548: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
549: gme_debug.put_line
550: ( 'l_generated_pre_batch_tab(i).plan_start_date = '
551: || TO_CHAR
552: (l_generated_pre_batch_tab (i).plan_start_date
553: ,'MM/DD/YYYY hh24:mi:ss') );

Line 554: gme_debug.put_line

550: ( 'l_generated_pre_batch_tab(i).plan_start_date = '
551: || TO_CHAR
552: (l_generated_pre_batch_tab (i).plan_start_date
553: ,'MM/DD/YYYY hh24:mi:ss') );
554: gme_debug.put_line
555: ( 'l_generated_pre_batch_tab(i).plan_cmplt_date = '
556: || TO_CHAR
557: (l_generated_pre_batch_tab (i).plan_cmplt_date
558: ,'MM/DD/YYYY hh24:mi:ss') );

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

564: --Start-to-Start
565: x_prev_plan_start_date :=
566: l_generated_pre_batch_tab (i - 1).plan_start_date;
567:
568: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
569: gme_debug.put_line ( 'x_prev_plan_start_date = '
570: || TO_CHAR (x_prev_plan_start_date
571: ,'MM/DD/YYYY hh24:mi:ss') );
572: END IF;

Line 569: gme_debug.put_line ( 'x_prev_plan_start_date = '

565: x_prev_plan_start_date :=
566: l_generated_pre_batch_tab (i - 1).plan_start_date;
567:
568: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
569: gme_debug.put_line ( 'x_prev_plan_start_date = '
570: || TO_CHAR (x_prev_plan_start_date
571: ,'MM/DD/YYYY hh24:mi:ss') );
572: END IF;
573:

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

573:
574: l_generated_pre_batch_tab (i).plan_start_date :=
575: x_prev_plan_start_date;
576:
577: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
578: gme_debug.put_line
579: ( 'l_generated_pre_batch_tab(i).plan_start_date = '
580: || TO_CHAR
581: (l_generated_pre_batch_tab (i).plan_start_date

Line 578: gme_debug.put_line

574: l_generated_pre_batch_tab (i).plan_start_date :=
575: x_prev_plan_start_date;
576:
577: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
578: gme_debug.put_line
579: ( 'l_generated_pre_batch_tab(i).plan_start_date = '
580: || TO_CHAR
581: (l_generated_pre_batch_tab (i).plan_start_date
582: ,'MM/DD/YYYY hh24:mi:ss') );

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

592: l_generated_pre_batch_tab (i).plan_start_date :=
593: l_generated_pre_batch_tab (i).plan_start_date
594: + x_batch_offset_days;
595:
596: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
597: gme_debug.put_line
598: ( 'W/OFFSET l_generated_pre_batch_tab(i).plan_start_date = '
599: || TO_CHAR
600: (l_generated_pre_batch_tab (i).plan_start_date

Line 597: gme_debug.put_line

593: l_generated_pre_batch_tab (i).plan_start_date
594: + x_batch_offset_days;
595:
596: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
597: gme_debug.put_line
598: ( 'W/OFFSET l_generated_pre_batch_tab(i).plan_start_date = '
599: || TO_CHAR
600: (l_generated_pre_batch_tab (i).plan_start_date
601: ,'MM/DD/YYYY hh24:mi:ss ') );

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

604: l_generated_pre_batch_tab (i).plan_cmplt_date :=
605: l_generated_pre_batch_tab (i).plan_start_date
606: + x_batch_leadtime_days;
607:
608: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
609: gme_debug.put_line
610: ( 'W/LEADTIME l_generated_pre_batch_tab(i).plan_cmplt_date = '
611: || TO_CHAR
612: (l_generated_pre_batch_tab (i).plan_cmplt_date

Line 609: gme_debug.put_line

605: l_generated_pre_batch_tab (i).plan_start_date
606: + x_batch_leadtime_days;
607:
608: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
609: gme_debug.put_line
610: ( 'W/LEADTIME l_generated_pre_batch_tab(i).plan_cmplt_date = '
611: || TO_CHAR
612: (l_generated_pre_batch_tab (i).plan_cmplt_date
613: ,'MM/DD/YYYY hh24:mi:ss') );

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

615: ELSIF (l_pregen_fpo_row.schedule_method = 'BACKWARD') THEN
616: --Not First Batch; Scheduling BACKWARD
617: IF (l_pregen_fpo_row.offset_type = 0) THEN
618: --Start-to-Start
619: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
620: gme_debug.put_line ('BACKWARD scheduling start-to-start');
621: END IF;
622:
623: x_prev_plan_start_date :=

Line 620: gme_debug.put_line ('BACKWARD scheduling start-to-start');

616: --Not First Batch; Scheduling BACKWARD
617: IF (l_pregen_fpo_row.offset_type = 0) THEN
618: --Start-to-Start
619: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
620: gme_debug.put_line ('BACKWARD scheduling start-to-start');
621: END IF;
622:
623: x_prev_plan_start_date :=
624: l_generated_pre_batch_tab (i - 1).plan_start_date;

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

622:
623: x_prev_plan_start_date :=
624: l_generated_pre_batch_tab (i - 1).plan_start_date;
625:
626: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
627: gme_debug.put_line ( 'x_prev_plan_start_date = '
628: || TO_CHAR (x_prev_plan_start_date
629: ,'MM/DD/YYYY hh24:mi:ss') );
630: END IF;

Line 627: gme_debug.put_line ( 'x_prev_plan_start_date = '

623: x_prev_plan_start_date :=
624: l_generated_pre_batch_tab (i - 1).plan_start_date;
625:
626: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
627: gme_debug.put_line ( 'x_prev_plan_start_date = '
628: || TO_CHAR (x_prev_plan_start_date
629: ,'MM/DD/YYYY hh24:mi:ss') );
630: END IF;
631:

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

631:
632: l_generated_pre_batch_tab (i).plan_start_date :=
633: x_prev_plan_start_date + x_neg_batch_offset_days;
634:
635: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
636: gme_debug.put_line
637: ( 'W/NEG OFFSET l_generated_pre_batch_tab(i).plan_start_date = '
638: || TO_CHAR
639: (l_generated_pre_batch_tab (i).plan_start_date

Line 636: gme_debug.put_line

632: l_generated_pre_batch_tab (i).plan_start_date :=
633: x_prev_plan_start_date + x_neg_batch_offset_days;
634:
635: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
636: gme_debug.put_line
637: ( 'W/NEG OFFSET l_generated_pre_batch_tab(i).plan_start_date = '
638: || TO_CHAR
639: (l_generated_pre_batch_tab (i).plan_start_date
640: ,'MM/DD/YYYY hh24:mi:ss') );

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

643: l_generated_pre_batch_tab (i).plan_cmplt_date :=
644: l_generated_pre_batch_tab (i).plan_start_date
645: + x_batch_leadtime_days;
646:
647: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
648: gme_debug.put_line
649: ( 'W/LEADTIME l_generated_pre_batch_tab(i).plan_cmplt_date = '
650: || TO_CHAR
651: (l_generated_pre_batch_tab (i).plan_cmplt_date

Line 648: gme_debug.put_line

644: l_generated_pre_batch_tab (i).plan_start_date
645: + x_batch_leadtime_days;
646:
647: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
648: gme_debug.put_line
649: ( 'W/LEADTIME l_generated_pre_batch_tab(i).plan_cmplt_date = '
650: || TO_CHAR
651: (l_generated_pre_batch_tab (i).plan_cmplt_date
652: ,'MM/DD/YYYY hh24:mi:ss') );

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

652: ,'MM/DD/YYYY hh24:mi:ss') );
653: END IF;
654: ELSE
655: --End-to-Start
656: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
657: gme_debug.put_line ('BACKWARD scheduling end-to-start');
658: END IF;
659:
660: x_prev_plan_start_date :=

Line 657: gme_debug.put_line ('BACKWARD scheduling end-to-start');

653: END IF;
654: ELSE
655: --End-to-Start
656: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
657: gme_debug.put_line ('BACKWARD scheduling end-to-start');
658: END IF;
659:
660: x_prev_plan_start_date :=
661: l_generated_pre_batch_tab (i - 1).plan_start_date;

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

659:
660: x_prev_plan_start_date :=
661: l_generated_pre_batch_tab (i - 1).plan_start_date;
662:
663: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
664: gme_debug.put_line ( 'x_prev_plan_start_date = '
665: || TO_CHAR (x_prev_plan_start_date
666: ,'MM/DD/YYYY hh24:mi:ss') );
667: END IF;

Line 664: gme_debug.put_line ( 'x_prev_plan_start_date = '

660: x_prev_plan_start_date :=
661: l_generated_pre_batch_tab (i - 1).plan_start_date;
662:
663: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
664: gme_debug.put_line ( 'x_prev_plan_start_date = '
665: || TO_CHAR (x_prev_plan_start_date
666: ,'MM/DD/YYYY hh24:mi:ss') );
667: END IF;
668:

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

668:
669: l_generated_pre_batch_tab (i).plan_cmplt_date :=
670: x_prev_plan_start_date + x_neg_batch_offset_days;
671:
672: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
673: gme_debug.put_line
674: ( 'W/NEG OFFSET l_generated_pre_batch_tab(i).plan_cmplt_date = '
675: || TO_CHAR
676: (l_generated_pre_batch_tab (i).plan_cmplt_date

Line 673: gme_debug.put_line

669: l_generated_pre_batch_tab (i).plan_cmplt_date :=
670: x_prev_plan_start_date + x_neg_batch_offset_days;
671:
672: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
673: gme_debug.put_line
674: ( 'W/NEG OFFSET l_generated_pre_batch_tab(i).plan_cmplt_date = '
675: || TO_CHAR
676: (l_generated_pre_batch_tab (i).plan_cmplt_date
677: ,'MM/DD/YYYY hh24:mi:ss') );

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

680: l_generated_pre_batch_tab (i).plan_start_date :=
681: l_generated_pre_batch_tab (i).plan_cmplt_date
682: + x_neg_batch_leadtime_days;
683:
684: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
685: gme_debug.put_line
686: ( 'W/NEG LEADTIME l_generated_pre_batch_tab(i).plan_start_date = '
687: || TO_CHAR
688: (l_generated_pre_batch_tab (i).plan_start_date

Line 685: gme_debug.put_line

681: l_generated_pre_batch_tab (i).plan_cmplt_date
682: + x_neg_batch_leadtime_days;
683:
684: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
685: gme_debug.put_line
686: ( 'W/NEG LEADTIME l_generated_pre_batch_tab(i).plan_start_date = '
687: || TO_CHAR
688: (l_generated_pre_batch_tab (i).plan_start_date
689: ,'MM/DD/YYYY hh24:mi:ss') );

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

694:
695: l_generated_pre_batch_tab (i).due_date :=
696: l_generated_pre_batch_tab (i).plan_cmplt_date;
697:
698: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
699: gme_debug.put_line
700: ( 'l_generated_pre_batch_tab(i).due_date= '
701: || TO_CHAR
702: (l_generated_pre_batch_tab (i).due_date

Line 699: gme_debug.put_line

695: l_generated_pre_batch_tab (i).due_date :=
696: l_generated_pre_batch_tab (i).plan_cmplt_date;
697:
698: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
699: gme_debug.put_line
700: ( 'l_generated_pre_batch_tab(i).due_date= '
701: || TO_CHAR
702: (l_generated_pre_batch_tab (i).due_date
703: ,'MM/DD/YYYY hh24:mi:ss') );

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

710: IF x_return_status <> fnd_api.g_ret_sts_success THEN
711: RAISE generate_pre_batch_err;
712: END IF;
713:
714: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
715: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
716: END IF;
717: EXCEPTION
718: WHEN generate_pre_batch_err THEN

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

711: RAISE generate_pre_batch_err;
712: END IF;
713:
714: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
715: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
716: END IF;
717: EXCEPTION
718: WHEN generate_pre_batch_err THEN
719: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

715: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
716: END IF;
717: EXCEPTION
718: WHEN generate_pre_batch_err THEN
719: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
720: gme_debug.put_line
721: ('problem generateing the pre_batch-header recs');
722: END IF;
723:

Line 720: gme_debug.put_line

716: END IF;
717: EXCEPTION
718: WHEN generate_pre_batch_err THEN
719: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
720: gme_debug.put_line
721: ('problem generateing the pre_batch-header recs');
722: END IF;
723:
724: gme_common_pvt.log_message ('GEN_PRE_BATCH_HEADER_ERR');

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

783: WHERE recipe_validity_rule_id = v_validity_rule_id
784: AND i.organization_id = v_organization_id
785: AND v.inventory_item_id = i.inventory_item_id;
786: BEGIN
787: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
788: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
789: || l_api_name);
790: END IF;
791: x_return_status := fnd_api.g_ret_sts_success;

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

784: AND i.organization_id = v_organization_id
785: AND v.inventory_item_id = i.inventory_item_id;
786: BEGIN
787: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
788: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
789: || l_api_name);
790: END IF;
791: x_return_status := fnd_api.g_ret_sts_success;
792: dummy := 0;

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

802: l_prev_start_date := NULL;
803: l_prev_cmplt_date := NULL;
804: l_creation_mode := 'PRODUCT';
805:
806: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
807: gme_debug.put_line (g_pkg_name ||
808: '.' ||
809: l_api_name ||
810: 'Batch UOM is '||

Line 807: gme_debug.put_line (g_pkg_name ||

803: l_prev_cmplt_date := NULL;
804: l_creation_mode := 'PRODUCT';
805:
806: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
807: gme_debug.put_line (g_pkg_name ||
808: '.' ||
809: l_api_name ||
810: 'Batch UOM is '||
811: l_batch_uom);

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

812: END IF;
813:
814: --Populate generated_pre_batch_tab with validity_rule.
815: IF (p_process_row = 0) THEN
816: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
817: gme_debug.put_line (g_pkg_name ||
818: '.' ||
819: l_api_name ||
820: ' p_process_row is set to 0 ');

Line 817: gme_debug.put_line (g_pkg_name ||

813:
814: --Populate generated_pre_batch_tab with validity_rule.
815: IF (p_process_row = 0) THEN
816: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
817: gme_debug.put_line (g_pkg_name ||
818: '.' ||
819: l_api_name ||
820: ' p_process_row is set to 0 ');
821: END IF;

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

832: l_in_pre_batch_row := l_pre_batch_row;
833: --BEGIN BUG#3185748 Sastry
834: SAVEPOINT create_batch;
835:
836: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
837: gme_debug.put_line (g_pkg_name ||
838: '.' ||
839: l_api_name ||
840: ' Retrieve validity_rule for id '||

Line 837: gme_debug.put_line (g_pkg_name ||

833: --BEGIN BUG#3185748 Sastry
834: SAVEPOINT create_batch;
835:
836: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
837: gme_debug.put_line (g_pkg_name ||
838: '.' ||
839: l_api_name ||
840: ' Retrieve validity_rule for id '||
841: p_fpo_validity_rule_id||

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

856: END IF;
857:
858: CLOSE get_validity_rule;
859:
860: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
861: gme_debug.put_line (g_pkg_name ||
862: '.' ||
863: l_api_name ||
864: ' Invoke validate validity rule ');

Line 861: gme_debug.put_line (g_pkg_name ||

857:
858: CLOSE get_validity_rule;
859:
860: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
861: gme_debug.put_line (g_pkg_name ||
862: '.' ||
863: l_api_name ||
864: ' Invoke validate validity rule ');
865: END IF;

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

904: END IF;
905: END IF;
906:
907: --Swapna Kommineni bug#3565971 13/08/2004 End
908: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
909: gme_debug.put_line (g_pkg_name ||
910: '.' ||
911: l_api_name ||
912: ' about to invoke create_batch ');

Line 909: gme_debug.put_line (g_pkg_name ||

905: END IF;
906:
907: --Swapna Kommineni bug#3565971 13/08/2004 End
908: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
909: gme_debug.put_line (g_pkg_name ||
910: '.' ||
911: l_api_name ||
912: ' about to invoke create_batch ');
913: END IF;

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

923: ,p_use_workday_cal => p_use_shop_cal
924: ,p_contiguity_override => p_contiguity_override
925: ,x_exception_material_tbl => l_exception_material_tbl);
926:
927: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
928: gme_debug.put_line (g_pkg_name ||
929: '.' ||
930: l_api_name ||
931: ' create_batch returns status of '||

Line 928: gme_debug.put_line (g_pkg_name ||

924: ,p_contiguity_override => p_contiguity_override
925: ,x_exception_material_tbl => l_exception_material_tbl);
926:
927: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
928: gme_debug.put_line (g_pkg_name ||
929: '.' ||
930: l_api_name ||
931: ' create_batch returns status of '||
932: l_return_status );

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

973: WHEN batch_creation_failure OR validation_failure THEN
974: x_return_status := fnd_api.g_ret_sts_error;
975: ROLLBACK TO SAVEPOINT create_batch;
976:
977: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
978: gme_debug.put_line ('batch creation_fail');
979: END IF;
980: END;
981: --END BUG#3185748

Line 978: gme_debug.put_line ('batch creation_fail');

974: x_return_status := fnd_api.g_ret_sts_error;
975: ROLLBACK TO SAVEPOINT create_batch;
976:
977: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
978: gme_debug.put_line ('batch creation_fail');
979: END IF;
980: END;
981: --END BUG#3185748
982: END LOOP;

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

1000: ,p_use_workday_cal => p_use_shop_cal
1001: ,p_contiguity_override => p_contiguity_override
1002: ,x_exception_material_tbl => l_exception_material_tbl);
1003:
1004: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1005: gme_debug.put_line (g_pkg_name ||
1006: '.' ||
1007: l_api_name ||
1008: ' call to create_batch returns status of '||

Line 1005: gme_debug.put_line (g_pkg_name ||

1001: ,p_contiguity_override => p_contiguity_override
1002: ,x_exception_material_tbl => l_exception_material_tbl);
1003:
1004: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1005: gme_debug.put_line (g_pkg_name ||
1006: '.' ||
1007: l_api_name ||
1008: ' call to create_batch returns status of '||
1009: l_return_status||

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

1037: , X_msg_data => l_msg_data
1038: );
1039:
1040: END IF; /* IF (p_process_row = 0) */
1041: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1042: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name ||' with status '||x_return_status);
1043: END IF;
1044: EXCEPTION
1045: WHEN batch_creation_failure THEN

Line 1042: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name ||' with status '||x_return_status);

1038: );
1039:
1040: END IF; /* IF (p_process_row = 0) */
1041: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1042: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name ||' with status '||x_return_status);
1043: END IF;
1044: EXCEPTION
1045: WHEN batch_creation_failure THEN
1046: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

1042: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name ||' with status '||x_return_status);
1043: END IF;
1044: EXCEPTION
1045: WHEN batch_creation_failure THEN
1046: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1047: gme_debug.put_line ('batch creation_fail');
1048: END IF;
1049:
1050: x_return_status := fnd_api.g_ret_sts_error;

Line 1047: gme_debug.put_line ('batch creation_fail');

1043: END IF;
1044: EXCEPTION
1045: WHEN batch_creation_failure THEN
1046: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1047: gme_debug.put_line ('batch creation_fail');
1048: END IF;
1049:
1050: x_return_status := fnd_api.g_ret_sts_error;
1051:

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

1048: END IF;
1049:
1050: x_return_status := fnd_api.g_ret_sts_error;
1051:
1052: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1053: gme_debug.put_line ('x_return_status = ' || x_return_status);
1054: END IF;
1055: WHEN OTHERS THEN
1056: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1053: gme_debug.put_line ('x_return_status = ' || x_return_status);

1049:
1050: x_return_status := fnd_api.g_ret_sts_error;
1051:
1052: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1053: gme_debug.put_line ('x_return_status = ' || x_return_status);
1054: END IF;
1055: WHEN OTHERS THEN
1056: x_return_status := fnd_api.g_ret_sts_unexp_error;
1057: fnd_msg_pub.add_exc_msg ('GME_API_CONVERT_FPO'

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

1105: update_pending_trans EXCEPTION;
1106: cancel_batch_err EXCEPTION;
1107: fetch_batch_err EXCEPTION;
1108: BEGIN
1109: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1110: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1111: || l_api_name);
1112: END IF;
1113: x_return_status := fnd_api.g_ret_sts_success;

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

1106: cancel_batch_err EXCEPTION;
1107: fetch_batch_err EXCEPTION;
1108: BEGIN
1109: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1110: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1111: || l_api_name);
1112: END IF;
1113: x_return_status := fnd_api.g_ret_sts_success;
1114:

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

1153: -- scale the original FPO and all pending transactions to the
1154: -- difference.
1155: -- If greater than or equal to the original FPO qty, set FPO status
1156: -- to converted and delete pending transactions.
1157: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1158: gme_debug.put_line ( 'l_prim_prod_row.plan_qty = '
1159: || TO_CHAR (l_prim_prod_row.plan_qty) );
1160: gme_debug.put_line ( 'l_pregen_fpo_row.sum_eff_qty = '
1161: || TO_CHAR (l_pregen_fpo_row.sum_eff_qty) );

Line 1158: gme_debug.put_line ( 'l_prim_prod_row.plan_qty = '

1154: -- difference.
1155: -- If greater than or equal to the original FPO qty, set FPO status
1156: -- to converted and delete pending transactions.
1157: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1158: gme_debug.put_line ( 'l_prim_prod_row.plan_qty = '
1159: || TO_CHAR (l_prim_prod_row.plan_qty) );
1160: gme_debug.put_line ( 'l_pregen_fpo_row.sum_eff_qty = '
1161: || TO_CHAR (l_pregen_fpo_row.sum_eff_qty) );
1162: END IF;

Line 1160: gme_debug.put_line ( 'l_pregen_fpo_row.sum_eff_qty = '

1156: -- to converted and delete pending transactions.
1157: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1158: gme_debug.put_line ( 'l_prim_prod_row.plan_qty = '
1159: || TO_CHAR (l_prim_prod_row.plan_qty) );
1160: gme_debug.put_line ( 'l_pregen_fpo_row.sum_eff_qty = '
1161: || TO_CHAR (l_pregen_fpo_row.sum_eff_qty) );
1162: END IF;
1163:
1164: IF (l_prim_prod_row.plan_qty <= l_pregen_fpo_row.sum_eff_qty) THEN

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

1161: || TO_CHAR (l_pregen_fpo_row.sum_eff_qty) );
1162: END IF;
1163:
1164: IF (l_prim_prod_row.plan_qty <= l_pregen_fpo_row.sum_eff_qty) THEN
1165: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1166: gme_debug.put_line
1167: ('in IF.gonna update header and delete pending trans');
1168: END IF;
1169:

Line 1166: gme_debug.put_line

1162: END IF;
1163:
1164: IF (l_prim_prod_row.plan_qty <= l_pregen_fpo_row.sum_eff_qty) THEN
1165: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1166: gme_debug.put_line
1167: ('in IF.gonna update header and delete pending trans');
1168: END IF;
1169:
1170: --Update FPO status to CONVERTED

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

1171: l_fpo_header_row.batch_status := -3;
1172: l_return := gme_batch_header_dbl.update_row (l_fpo_header_row);
1173:
1174: IF NOT l_return THEN
1175: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1176: gme_debug.put_line ('l_return from update_row = FALSE');
1177: END IF;
1178:
1179: RAISE update_row_err;

Line 1176: gme_debug.put_line ('l_return from update_row = FALSE');

1172: l_return := gme_batch_header_dbl.update_row (l_fpo_header_row);
1173:
1174: IF NOT l_return THEN
1175: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1176: gme_debug.put_line ('l_return from update_row = FALSE');
1177: END IF;
1178:
1179: RAISE update_row_err;
1180: ELSE

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

1177: END IF;
1178:
1179: RAISE update_row_err;
1180: ELSE
1181: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1182: gme_debug.put_line ('l_return from update_row = TRUE');
1183: END IF;
1184: END IF;
1185:

Line 1182: gme_debug.put_line ('l_return from update_row = TRUE');

1178:
1179: RAISE update_row_err;
1180: ELSE
1181: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1182: gme_debug.put_line ('l_return from update_row = TRUE');
1183: END IF;
1184: END IF;
1185:
1186: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

1182: gme_debug.put_line ('l_return from update_row = TRUE');
1183: END IF;
1184: END IF;
1185:
1186: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1187: gme_debug.put_line ( 'l_fpo_header_row.batch_status = '
1188: || TO_CHAR (l_fpo_header_row.batch_status) );
1189: gme_debug.put_line ( 'l_fpo_header_row.batch_id = '
1190: || TO_CHAR (l_fpo_header_row.batch_id) );

Line 1187: gme_debug.put_line ( 'l_fpo_header_row.batch_status = '

1183: END IF;
1184: END IF;
1185:
1186: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1187: gme_debug.put_line ( 'l_fpo_header_row.batch_status = '
1188: || TO_CHAR (l_fpo_header_row.batch_status) );
1189: gme_debug.put_line ( 'l_fpo_header_row.batch_id = '
1190: || TO_CHAR (l_fpo_header_row.batch_id) );
1191: gme_debug.put_line ( 'l_fpo_header_row.batch_type = '

Line 1189: gme_debug.put_line ( 'l_fpo_header_row.batch_id = '

1185:
1186: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1187: gme_debug.put_line ( 'l_fpo_header_row.batch_status = '
1188: || TO_CHAR (l_fpo_header_row.batch_status) );
1189: gme_debug.put_line ( 'l_fpo_header_row.batch_id = '
1190: || TO_CHAR (l_fpo_header_row.batch_id) );
1191: gme_debug.put_line ( 'l_fpo_header_row.batch_type = '
1192: || TO_CHAR (l_fpo_header_row.batch_type) );
1193: END IF;

Line 1191: gme_debug.put_line ( 'l_fpo_header_row.batch_type = '

1187: gme_debug.put_line ( 'l_fpo_header_row.batch_status = '
1188: || TO_CHAR (l_fpo_header_row.batch_status) );
1189: gme_debug.put_line ( 'l_fpo_header_row.batch_id = '
1190: || TO_CHAR (l_fpo_header_row.batch_id) );
1191: gme_debug.put_line ( 'l_fpo_header_row.batch_type = '
1192: || TO_CHAR (l_fpo_header_row.batch_type) );
1193: END IF;
1194:
1195: --FPBug#4941012 set plan qty to zero for parent FPO

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

1251: -- pk_fpo('in fpo-before cancel'||l_fpo_header_row.batch_id);
1252: FOR l_rec IN get_phantom_fpo (l_fpo_header_row.batch_id) LOOP
1253: l_batch_header.batch_id := l_rec.phantom_id;
1254:
1255: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1256: gme_debug.put_line ( 'phantom to cancel = '
1257: || TO_CHAR (l_batch_header.batch_id) );
1258: END IF;
1259:

Line 1256: gme_debug.put_line ( 'phantom to cancel = '

1252: FOR l_rec IN get_phantom_fpo (l_fpo_header_row.batch_id) LOOP
1253: l_batch_header.batch_id := l_rec.phantom_id;
1254:
1255: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1256: gme_debug.put_line ( 'phantom to cancel = '
1257: || TO_CHAR (l_batch_header.batch_id) );
1258: END IF;
1259:
1260: --FPBug#4941012

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

1273: END IF;
1274: END LOOP;
1275: ELSE
1276: --Scale FPO material details line
1277: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1278: gme_debug.put_line ('gonna do some scaling');
1279: END IF;
1280:
1281: l_scale_factor :=

Line 1278: gme_debug.put_line ('gonna do some scaling');

1274: END LOOP;
1275: ELSE
1276: --Scale FPO material details line
1277: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1278: gme_debug.put_line ('gonna do some scaling');
1279: END IF;
1280:
1281: l_scale_factor :=
1282: (l_prim_prod_row.plan_qty - l_pregen_fpo_row.sum_eff_qty)

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

1281: l_scale_factor :=
1282: (l_prim_prod_row.plan_qty - l_pregen_fpo_row.sum_eff_qty)
1283: / l_prim_prod_row.plan_qty;
1284:
1285: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1286: gme_debug.put_line ('l_scale_factor = ' || l_scale_factor);
1287: END IF;
1288:
1289: --p_qty_type is default 1 for the plan qty only

Line 1286: gme_debug.put_line ('l_scale_factor = ' || l_scale_factor);

1282: (l_prim_prod_row.plan_qty - l_pregen_fpo_row.sum_eff_qty)
1283: / l_prim_prod_row.plan_qty;
1284:
1285: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1286: gme_debug.put_line ('l_scale_factor = ' || l_scale_factor);
1287: END IF;
1288:
1289: --p_qty_type is default 1 for the plan qty only
1290: /* l_over_allocations parameter is used to handle default lot going */

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

1309: END IF;
1310: END IF;
1311:
1312: x_fpo_header_row := l_fpo_header_row;
1313: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1314: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1315: END IF;
1316: EXCEPTION
1317: WHEN load_rsrc_trans_err THEN

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

1310: END IF;
1311:
1312: x_fpo_header_row := l_fpo_header_row;
1313: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1314: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1315: END IF;
1316: EXCEPTION
1317: WHEN load_rsrc_trans_err THEN
1318: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

1314: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1315: END IF;
1316: EXCEPTION
1317: WHEN load_rsrc_trans_err THEN
1318: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1319: gme_debug.put_line ('load_rsrc_trans_err_fail');
1320: END IF;
1321:
1322: x_return_status := fnd_api.g_ret_sts_error;

Line 1319: gme_debug.put_line ('load_rsrc_trans_err_fail');

1315: END IF;
1316: EXCEPTION
1317: WHEN load_rsrc_trans_err THEN
1318: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1319: gme_debug.put_line ('load_rsrc_trans_err_fail');
1320: END IF;
1321:
1322: x_return_status := fnd_api.g_ret_sts_error;
1323: WHEN cancel_batch_err THEN

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

1320: END IF;
1321:
1322: x_return_status := fnd_api.g_ret_sts_error;
1323: WHEN cancel_batch_err THEN
1324: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1325: gme_debug.put_line ('Cancel_FPO_PHANTOM_fail');
1326: END IF;
1327:
1328: x_return_status := fnd_api.g_ret_sts_error;

Line 1325: gme_debug.put_line ('Cancel_FPO_PHANTOM_fail');

1321:
1322: x_return_status := fnd_api.g_ret_sts_error;
1323: WHEN cancel_batch_err THEN
1324: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1325: gme_debug.put_line ('Cancel_FPO_PHANTOM_fail');
1326: END IF;
1327:
1328: x_return_status := fnd_api.g_ret_sts_error;
1329: WHEN gme_fetch_all_trans_err THEN

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

1326: END IF;
1327:
1328: x_return_status := fnd_api.g_ret_sts_error;
1329: WHEN gme_fetch_all_trans_err THEN
1330: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1331: gme_debug.put_line ('fetch_alltrans_err_fail');
1332: END IF;
1333:
1334: x_return_status := fnd_api.g_ret_sts_error;

Line 1331: gme_debug.put_line ('fetch_alltrans_err_fail');

1327:
1328: x_return_status := fnd_api.g_ret_sts_error;
1329: WHEN gme_fetch_all_trans_err THEN
1330: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1331: gme_debug.put_line ('fetch_alltrans_err_fail');
1332: END IF;
1333:
1334: x_return_status := fnd_api.g_ret_sts_error;
1335: --FPBug#4941012

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

1333:
1334: x_return_status := fnd_api.g_ret_sts_error;
1335: --FPBug#4941012
1336: WHEN fetch_batch_err THEN
1337: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1338: gme_debug.put_line ('fetch batch header fail');
1339: END IF;
1340:
1341: x_return_status := fnd_api.g_ret_sts_error;

Line 1338: gme_debug.put_line ('fetch batch header fail');

1334: x_return_status := fnd_api.g_ret_sts_error;
1335: --FPBug#4941012
1336: WHEN fetch_batch_err THEN
1337: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1338: gme_debug.put_line ('fetch batch header fail');
1339: END IF;
1340:
1341: x_return_status := fnd_api.g_ret_sts_error;
1342: WHEN update_row_err THEN

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

1339: END IF;
1340:
1341: x_return_status := fnd_api.g_ret_sts_error;
1342: WHEN update_row_err THEN
1343: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1344: gme_debug.put_line ('update_row _fail');
1345: END IF;
1346:
1347: x_return_status := fnd_api.g_ret_sts_error;

Line 1344: gme_debug.put_line ('update_row _fail');

1340:
1341: x_return_status := fnd_api.g_ret_sts_error;
1342: WHEN update_row_err THEN
1343: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1344: gme_debug.put_line ('update_row _fail');
1345: END IF;
1346:
1347: x_return_status := fnd_api.g_ret_sts_error;
1348: WHEN delete_pending_trans_err THEN

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

1345: END IF;
1346:
1347: x_return_status := fnd_api.g_ret_sts_error;
1348: WHEN delete_pending_trans_err THEN
1349: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1350: gme_debug.put_line ('delete_pending_trans _fail');
1351: END IF;
1352:
1353: x_return_status := fnd_api.g_ret_sts_error;

Line 1350: gme_debug.put_line ('delete_pending_trans _fail');

1346:
1347: x_return_status := fnd_api.g_ret_sts_error;
1348: WHEN delete_pending_trans_err THEN
1349: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1350: gme_debug.put_line ('delete_pending_trans _fail');
1351: END IF;
1352:
1353: x_return_status := fnd_api.g_ret_sts_error;
1354: WHEN scale_batch_err THEN

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

1351: END IF;
1352:
1353: x_return_status := fnd_api.g_ret_sts_error;
1354: WHEN scale_batch_err THEN
1355: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1356: gme_debug.put_line ('scale_batch _fail');
1357: END IF;
1358:
1359: x_return_status := fnd_api.g_ret_sts_error;

Line 1356: gme_debug.put_line ('scale_batch _fail');

1352:
1353: x_return_status := fnd_api.g_ret_sts_error;
1354: WHEN scale_batch_err THEN
1355: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1356: gme_debug.put_line ('scale_batch _fail');
1357: END IF;
1358:
1359: x_return_status := fnd_api.g_ret_sts_error;
1360: WHEN update_pending_trans THEN

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

1357: END IF;
1358:
1359: x_return_status := fnd_api.g_ret_sts_error;
1360: WHEN update_pending_trans THEN
1361: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1362: gme_debug.put_line ('update_pending_trans _fail');
1363: END IF;
1364:
1365: x_return_status := fnd_api.g_ret_sts_error;

Line 1362: gme_debug.put_line ('update_pending_trans _fail');

1358:
1359: x_return_status := fnd_api.g_ret_sts_error;
1360: WHEN update_pending_trans THEN
1361: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1362: gme_debug.put_line ('update_pending_trans _fail');
1363: END IF;
1364:
1365: x_return_status := fnd_api.g_ret_sts_error;
1366: WHEN OTHERS THEN

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

1427: create_batch_failure EXCEPTION;
1428: update_original_fpo_failure EXCEPTION;
1429: batch_header_fetch_error EXCEPTION;
1430: BEGIN
1431: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1432: gme_debug.log_initialize ('ConvertFPO');
1433: END IF;
1434:
1435: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 1432: gme_debug.log_initialize ('ConvertFPO');

1428: update_original_fpo_failure EXCEPTION;
1429: batch_header_fetch_error EXCEPTION;
1430: BEGIN
1431: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1432: gme_debug.log_initialize ('ConvertFPO');
1433: END IF;
1434:
1435: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1436: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

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

1431: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1432: gme_debug.log_initialize ('ConvertFPO');
1433: END IF;
1434:
1435: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1436: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1437: || l_api_name);
1438: END IF;
1439:

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

1432: gme_debug.log_initialize ('ConvertFPO');
1433: END IF;
1434:
1435: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1436: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1437: || l_api_name);
1438: END IF;
1439:
1440: x_return_status := fnd_api.g_ret_sts_success;

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

1446: l_batch_header.organization_id := p_batch_header.organization_id; -- KYH GME CONV
1447: l_batch_header.batch_id := p_batch_header.batch_id; -- KYH GME CONV
1448: l_batch_header.batch_type := 10;
1449:
1450: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1451: gme_debug.put_line (g_pkg_name ||
1452: '.' ||
1453: l_api_name ||
1454: ' Retrieve batch header for batch_id '||

Line 1451: gme_debug.put_line (g_pkg_name ||

1447: l_batch_header.batch_id := p_batch_header.batch_id; -- KYH GME CONV
1448: l_batch_header.batch_type := 10;
1449:
1450: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1451: gme_debug.put_line (g_pkg_name ||
1452: '.' ||
1453: l_api_name ||
1454: ' Retrieve batch header for batch_id '||
1455: l_batch_header.batch_id);

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

1458: RAISE batch_header_fetch_error;
1459: END IF;
1460:
1461: /* Get the validity rule for the existing FPO */
1462: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1463: gme_debug.put_line (g_pkg_name ||
1464: '.' ||
1465: l_api_name ||
1466: ' Retrieve validity rule for rule_id '||

Line 1463: gme_debug.put_line (g_pkg_name ||

1459: END IF;
1460:
1461: /* Get the validity rule for the existing FPO */
1462: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1463: gme_debug.put_line (g_pkg_name ||
1464: '.' ||
1465: l_api_name ||
1466: ' Retrieve validity rule for rule_id '||
1467: l_batch_header.recipe_validity_rule_id);

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

1480: END IF;
1481:
1482: CLOSE get_validity_rule;
1483:
1484: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1485: gme_debug.put_line (g_pkg_name ||
1486: '.' ||
1487: l_api_name ||
1488: ' Invoke Validation ');

Line 1485: gme_debug.put_line (g_pkg_name ||

1481:
1482: CLOSE get_validity_rule;
1483:
1484: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1485: gme_debug.put_line (g_pkg_name ||
1486: '.' ||
1487: l_api_name ||
1488: ' Invoke Validation ');
1489: END IF;

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

1504: ,p_plan_cmplt_date => p_plan_cmplt_date
1505: ,x_pregen_fpo_row => x_pregen_fpo_row
1506: ,x_return_status => x_return_status);
1507:
1508: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1509: gme_debug.put_line (g_pkg_name ||
1510: '.' ||
1511: l_api_name ||
1512: ' VALIDATION procedure returns '||

Line 1509: gme_debug.put_line (g_pkg_name ||

1505: ,x_pregen_fpo_row => x_pregen_fpo_row
1506: ,x_return_status => x_return_status);
1507:
1508: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1509: gme_debug.put_line (g_pkg_name ||
1510: '.' ||
1511: l_api_name ||
1512: ' VALIDATION procedure returns '||
1513: x_return_status);

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

1521: END IF;
1522:
1523: l_in_fpo_header_row := l_fpo_header_row;
1524: l_in_pregen_fpo_row := l_pregen_fpo_row;
1525: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1526: gme_debug.put_line (g_pkg_name ||
1527: '.' ||
1528: l_api_name ||
1529: ' About to INVOKE retrieve_fpo_data ');

Line 1526: gme_debug.put_line (g_pkg_name ||

1522:
1523: l_in_fpo_header_row := l_fpo_header_row;
1524: l_in_pregen_fpo_row := l_pregen_fpo_row;
1525: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1526: gme_debug.put_line (g_pkg_name ||
1527: '.' ||
1528: l_api_name ||
1529: ' About to INVOKE retrieve_fpo_data ');
1530: END IF;

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

1537: ,x_validity_rule_row => l_validity_rule_row
1538: ,x_fpo_material_details_tab => l_fpo_material_details_tab
1539: ,x_return_status => x_return_status);
1540:
1541: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1542: gme_debug.put_line (g_pkg_name ||
1543: '.' ||
1544: l_api_name ||
1545: ' retrieve_fpo_data returns status of '||

Line 1542: gme_debug.put_line (g_pkg_name ||

1538: ,x_fpo_material_details_tab => l_fpo_material_details_tab
1539: ,x_return_status => x_return_status);
1540:
1541: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1542: gme_debug.put_line (g_pkg_name ||
1543: '.' ||
1544: l_api_name ||
1545: ' retrieve_fpo_data returns status of '||
1546: x_return_status);

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

1552:
1553: l_item_um := l_prim_prod_row.dtl_um;
1554:
1555: IF p_use_for_all = fnd_api.g_true THEN
1556: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1557: gme_debug.put_line (g_pkg_name ||
1558: '.' ||
1559: l_api_name ||
1560: ' p_use_for_all is TRUE ');

Line 1557: gme_debug.put_line (g_pkg_name ||

1553: l_item_um := l_prim_prod_row.dtl_um;
1554:
1555: IF p_use_for_all = fnd_api.g_true THEN
1556: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1557: gme_debug.put_line (g_pkg_name ||
1558: '.' ||
1559: l_api_name ||
1560: ' p_use_for_all is TRUE ');
1561: END IF;

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

1599: x_pregen_fpo_row => l_pregen_fpo_row,
1600: x_return_status => l_return_status
1601: );
1602: END IF; */
1603: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1604: gme_debug.put_line (g_pkg_name ||
1605: '.' ||
1606: l_api_name ||
1607: ' Retrieve batch header for batch_id '||

Line 1604: gme_debug.put_line (g_pkg_name ||

1600: x_return_status => l_return_status
1601: );
1602: END IF; */
1603: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1604: gme_debug.put_line (g_pkg_name ||
1605: '.' ||
1606: l_api_name ||
1607: ' Retrieve batch header for batch_id '||
1608: l_batch_header.batch_id);

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

1606: l_api_name ||
1607: ' Retrieve batch header for batch_id '||
1608: l_batch_header.batch_id);
1609: END IF;
1610: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1611: gme_debug.put_line (g_pkg_name ||
1612: '.' ||
1613: l_api_name ||
1614: ' Invoke generate_pre_batch_header_recs');

Line 1611: gme_debug.put_line (g_pkg_name ||

1607: ' Retrieve batch header for batch_id '||
1608: l_batch_header.batch_id);
1609: END IF;
1610: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1611: gme_debug.put_line (g_pkg_name ||
1612: '.' ||
1613: l_api_name ||
1614: ' Invoke generate_pre_batch_header_recs');
1615: END IF;

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

1619: ,p_pregen_fpo_row => l_pregen_fpo_row
1620: ,x_generated_pre_batch_tab => l_generated_pre_batch_tab
1621: ,x_return_status => x_return_status);
1622:
1623: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1624: gme_debug.put_line (g_pkg_name ||
1625: '.' ||
1626: l_api_name ||
1627: ' generate_pre_batch_header_recs returns '||

Line 1624: gme_debug.put_line (g_pkg_name ||

1620: ,x_generated_pre_batch_tab => l_generated_pre_batch_tab
1621: ,x_return_status => x_return_status);
1622:
1623: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1624: gme_debug.put_line (g_pkg_name ||
1625: '.' ||
1626: l_api_name ||
1627: ' generate_pre_batch_header_recs returns '||
1628: x_return_status );

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

1660: END LOOP;
1661:
1662: --Swapna Kommineni bug#3565971 13/08/2004 End
1663: l_in_generated_pre_batch_tab := l_generated_pre_batch_tab;
1664: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1665: gme_debug.put_line (g_pkg_name ||
1666: '.' ||
1667: l_api_name ||
1668: ' Invoke convert_fpo_to_batch ');

Line 1665: gme_debug.put_line (g_pkg_name ||

1661:
1662: --Swapna Kommineni bug#3565971 13/08/2004 End
1663: l_in_generated_pre_batch_tab := l_generated_pre_batch_tab;
1664: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1665: gme_debug.put_line (g_pkg_name ||
1666: '.' ||
1667: l_api_name ||
1668: ' Invoke convert_fpo_to_batch ');
1669: END IF;

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

1679: ,x_exception_material_tbl => l_exception_material_tbl
1680: ,p_fpo_validity_rule_id => l_batch_header.recipe_validity_rule_id
1681: -- Bug 3185748
1682: );
1683: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1684: gme_debug.put_line (g_pkg_name ||
1685: '.' ||
1686: l_api_name ||
1687: ' convert_fpo_to_batch returns '||

Line 1684: gme_debug.put_line (g_pkg_name ||

1680: ,p_fpo_validity_rule_id => l_batch_header.recipe_validity_rule_id
1681: -- Bug 3185748
1682: );
1683: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1684: gme_debug.put_line (g_pkg_name ||
1685: '.' ||
1686: l_api_name ||
1687: ' convert_fpo_to_batch returns '||
1688: x_return_status);

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

1706: ,p_enforce_vldt_check => p_enforce_vldt_check
1707: ,x_fpo_header_row => x_batch_header
1708: ,x_return_status => x_return_status);
1709:
1710: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1711: gme_debug.put_line ( 'in private convert_fpo-after update'
1712: || x_return_status);
1713: END IF;
1714:

Line 1711: gme_debug.put_line ( 'in private convert_fpo-after update'

1707: ,x_fpo_header_row => x_batch_header
1708: ,x_return_status => x_return_status);
1709:
1710: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1711: gme_debug.put_line ( 'in private convert_fpo-after update'
1712: || x_return_status);
1713: END IF;
1714:
1715: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

1739: ,l_batch_range);
1740: END IF;
1741: END IF;
1742: --END BUG#3185748 Sastry
1743: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1744: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1745: END IF;
1746: EXCEPTION
1747: WHEN validation_failure THEN

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

1740: END IF;
1741: END IF;
1742: --END BUG#3185748 Sastry
1743: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1744: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1745: END IF;
1746: EXCEPTION
1747: WHEN validation_failure THEN
1748: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

1744: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1745: END IF;
1746: EXCEPTION
1747: WHEN validation_failure THEN
1748: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1749: gme_debug.put_line ('in validiation fail exception');
1750: END IF;
1751:
1752: x_return_status := fnd_api.g_ret_sts_error;

Line 1749: gme_debug.put_line ('in validiation fail exception');

1745: END IF;
1746: EXCEPTION
1747: WHEN validation_failure THEN
1748: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1749: gme_debug.put_line ('in validiation fail exception');
1750: END IF;
1751:
1752: x_return_status := fnd_api.g_ret_sts_error;
1753: WHEN fpo_retrieval_failure THEN

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

1750: END IF;
1751:
1752: x_return_status := fnd_api.g_ret_sts_error;
1753: WHEN fpo_retrieval_failure THEN
1754: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1755: gme_debug.put_line ('in retrieval fail exception');
1756: END IF;
1757:
1758: x_return_status := fnd_api.g_ret_sts_error;

Line 1755: gme_debug.put_line ('in retrieval fail exception');

1751:
1752: x_return_status := fnd_api.g_ret_sts_error;
1753: WHEN fpo_retrieval_failure THEN
1754: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1755: gme_debug.put_line ('in retrieval fail exception');
1756: END IF;
1757:
1758: x_return_status := fnd_api.g_ret_sts_error;
1759: WHEN batch_generation_failure THEN

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

1756: END IF;
1757:
1758: x_return_status := fnd_api.g_ret_sts_error;
1759: WHEN batch_generation_failure THEN
1760: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1761: gme_debug.put_line ('in batch_generation fail exception');
1762: END IF;
1763:
1764: x_return_status := fnd_api.g_ret_sts_error;

Line 1761: gme_debug.put_line ('in batch_generation fail exception');

1757:
1758: x_return_status := fnd_api.g_ret_sts_error;
1759: WHEN batch_generation_failure THEN
1760: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1761: gme_debug.put_line ('in batch_generation fail exception');
1762: END IF;
1763:
1764: x_return_status := fnd_api.g_ret_sts_error;
1765: WHEN insufficient_validity_rules THEN