eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_CREATE_STEP_PVT dependencies on GME_DEBUG

Line 183: IF g_debug <= gme_debug.g_log_procedure THEN

179: SELECT batchstep_id
180: FROM gme_batch_steps
181: WHERE batch_id = v_batch_id;
182: BEGIN
183: IF g_debug <= gme_debug.g_log_procedure THEN
184: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
185: || l_api_name);
186: END IF;
187:

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

180: FROM gme_batch_steps
181: WHERE batch_id = v_batch_id;
182: BEGIN
183: IF g_debug <= gme_debug.g_log_procedure THEN
184: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
185: || l_api_name);
186: END IF;
187:
188: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

184: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
185: || l_api_name);
186: END IF;
187:
188: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
189: gme_debug.put_line ('BEGIN Create_step');
190: END IF;
191:
192: x_return_status := fnd_api.g_ret_sts_success;

Line 189: gme_debug.put_line ('BEGIN Create_step');

185: || l_api_name);
186: END IF;
187:
188: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
189: gme_debug.put_line ('BEGIN Create_step');
190: END IF;
191:
192: x_return_status := fnd_api.g_ret_sts_success;
193: l_batch_id := p_gme_batch_header_rec.batch_id;

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

213: j := 0;
214: l_step_charge_rsrc_tab.DELETE ();
215:
216: --Bug#5112133
217: IF (NVL(g_debug, -1) = gme_debug.g_log_statement) THEN
218: gme_debug.put_line ('copy_routing_text_ind = '||gme_common_pvt.g_copy_routing_text_ind);
219: END IF;
220: WHILE i IS NOT NULL LOOP
221: l_gme_batch_steps.EXTEND;

Line 218: gme_debug.put_line ('copy_routing_text_ind = '||gme_common_pvt.g_copy_routing_text_ind);

214: l_step_charge_rsrc_tab.DELETE ();
215:
216: --Bug#5112133
217: IF (NVL(g_debug, -1) = gme_debug.g_log_statement) THEN
218: gme_debug.put_line ('copy_routing_text_ind = '||gme_common_pvt.g_copy_routing_text_ind);
219: END IF;
220: WHILE i IS NOT NULL LOOP
221: l_gme_batch_steps.EXTEND;
222:

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

247:
248: l_gme_batch_steps (j).plan_step_qty :=
249: p_recipe_rout_step_tbl (i).step_qty;
250:
251: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
252: gme_debug.put_line ('DURING INITIAL CREATION step number is '|| l_gme_batch_steps (j).batchstep_no);
253: gme_debug.put_line ('DURING INITIAL CREATION plan step qty from gmd is '|| l_gme_batch_steps (j).plan_step_qty);
254: END IF;
255:

Line 252: gme_debug.put_line ('DURING INITIAL CREATION step number is '|| l_gme_batch_steps (j).batchstep_no);

248: l_gme_batch_steps (j).plan_step_qty :=
249: p_recipe_rout_step_tbl (i).step_qty;
250:
251: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
252: gme_debug.put_line ('DURING INITIAL CREATION step number is '|| l_gme_batch_steps (j).batchstep_no);
253: gme_debug.put_line ('DURING INITIAL CREATION plan step qty from gmd is '|| l_gme_batch_steps (j).plan_step_qty);
254: END IF;
255:
256: l_gme_batch_steps (j).plan_start_date := gme_common_pvt.g_timestamp;

Line 253: gme_debug.put_line ('DURING INITIAL CREATION plan step qty from gmd is '|| l_gme_batch_steps (j).plan_step_qty);

249: p_recipe_rout_step_tbl (i).step_qty;
250:
251: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
252: gme_debug.put_line ('DURING INITIAL CREATION step number is '|| l_gme_batch_steps (j).batchstep_no);
253: gme_debug.put_line ('DURING INITIAL CREATION plan step qty from gmd is '|| l_gme_batch_steps (j).plan_step_qty);
254: END IF;
255:
256: l_gme_batch_steps (j).plan_start_date := gme_common_pvt.g_timestamp;
257: l_gme_batch_steps (j).plan_cmplt_date := gme_common_pvt.g_timestamp;

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

270: ELSE
271: l_gme_batch_steps (j).due_date := p_step_due_date;
272: END IF;
273:
274: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
275: gme_debug.put_line ( ' minimum_transfer_qty '
276: || l_gme_batch_steps (j).minimum_transfer_qty);
277: gme_debug.put_line ( ' max step capacity '
278: || l_gme_batch_steps (j).max_step_capacity);

Line 275: gme_debug.put_line ( ' minimum_transfer_qty '

271: l_gme_batch_steps (j).due_date := p_step_due_date;
272: END IF;
273:
274: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
275: gme_debug.put_line ( ' minimum_transfer_qty '
276: || l_gme_batch_steps (j).minimum_transfer_qty);
277: gme_debug.put_line ( ' max step capacity '
278: || l_gme_batch_steps (j).max_step_capacity);
279: gme_debug.put_line ( ' max step capacity uom '

Line 277: gme_debug.put_line ( ' max step capacity '

273:
274: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
275: gme_debug.put_line ( ' minimum_transfer_qty '
276: || l_gme_batch_steps (j).minimum_transfer_qty);
277: gme_debug.put_line ( ' max step capacity '
278: || l_gme_batch_steps (j).max_step_capacity);
279: gme_debug.put_line ( ' max step capacity uom '
280: || l_gme_batch_steps (j).max_step_capacity_um);
281: END IF;

Line 279: gme_debug.put_line ( ' max step capacity uom '

275: gme_debug.put_line ( ' minimum_transfer_qty '
276: || l_gme_batch_steps (j).minimum_transfer_qty);
277: gme_debug.put_line ( ' max step capacity '
278: || l_gme_batch_steps (j).max_step_capacity);
279: gme_debug.put_line ( ' max step capacity uom '
280: || l_gme_batch_steps (j).max_step_capacity_um);
281: END IF;
282:
283: -- Insert text if copy text is on and there is text on the step passed in...

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

291: || '|';
292: l_text_string :=
293: l_text_string || l_gme_batch_steps (j).batchstep_no;
294: --Bug#5112133
295: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
296: gme_debug.put_line ('text code for step=' || l_gmd_text_code);
297: gme_debug.put_line ('key_field for step=' || l_text_string);
298: gme_debug.put_line ('calling copy_and_create_text for step line');
299: END IF;

Line 296: gme_debug.put_line ('text code for step=' || l_gmd_text_code);

292: l_text_string :=
293: l_text_string || l_gme_batch_steps (j).batchstep_no;
294: --Bug#5112133
295: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
296: gme_debug.put_line ('text code for step=' || l_gmd_text_code);
297: gme_debug.put_line ('key_field for step=' || l_text_string);
298: gme_debug.put_line ('calling copy_and_create_text for step line');
299: END IF;
300: copy_and_create_text (l_gmd_text_code

Line 297: gme_debug.put_line ('key_field for step=' || l_text_string);

293: l_text_string || l_gme_batch_steps (j).batchstep_no;
294: --Bug#5112133
295: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
296: gme_debug.put_line ('text code for step=' || l_gmd_text_code);
297: gme_debug.put_line ('key_field for step=' || l_text_string);
298: gme_debug.put_line ('calling copy_and_create_text for step line');
299: END IF;
300: copy_and_create_text (l_gmd_text_code
301: ,l_text_string

Line 298: gme_debug.put_line ('calling copy_and_create_text for step line');

294: --Bug#5112133
295: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
296: gme_debug.put_line ('text code for step=' || l_gmd_text_code);
297: gme_debug.put_line ('key_field for step=' || l_text_string);
298: gme_debug.put_line ('calling copy_and_create_text for step line');
299: END IF;
300: copy_and_create_text (l_gmd_text_code
301: ,l_text_string
302: ,l_gme_text_code

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

343: l_last_batchstep_id := l_gme_batch_steps (j).batchstep_id;
344: l_step_charge_rsrc_tab (l_last_batchstep_id).resources :=
345: p_recipe_rout_step_tbl (j).resources;
346:
347: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
348: gme_debug.put_line ( g_pkg_name
349: || '.'
350: || l_api_name
351: || 'resources name obtained from GMD is'

Line 348: gme_debug.put_line ( g_pkg_name

344: l_step_charge_rsrc_tab (l_last_batchstep_id).resources :=
345: p_recipe_rout_step_tbl (j).resources;
346:
347: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
348: gme_debug.put_line ( g_pkg_name
349: || '.'
350: || l_api_name
351: || 'resources name obtained from GMD is'
352: || p_recipe_rout_step_tbl (j).resources);

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

357:
358: i := p_recipe_rout_step_tbl.NEXT (i);
359: END LOOP; /* WHILE i IS NOT NULL; BATCH STEPS */
360:
361: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
362: gme_debug.put_line ('Completed batch steps');
363: gme_debug.put_line ('GME_BATCH_STEP_ACTIVITIES');
364: END IF;
365:

Line 362: gme_debug.put_line ('Completed batch steps');

358: i := p_recipe_rout_step_tbl.NEXT (i);
359: END LOOP; /* WHILE i IS NOT NULL; BATCH STEPS */
360:
361: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
362: gme_debug.put_line ('Completed batch steps');
363: gme_debug.put_line ('GME_BATCH_STEP_ACTIVITIES');
364: END IF;
365:
366: i := p_recipe_rout_act_tbl.FIRST;

Line 363: gme_debug.put_line ('GME_BATCH_STEP_ACTIVITIES');

359: END LOOP; /* WHILE i IS NOT NULL; BATCH STEPS */
360:
361: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
362: gme_debug.put_line ('Completed batch steps');
363: gme_debug.put_line ('GME_BATCH_STEP_ACTIVITIES');
364: END IF;
365:
366: i := p_recipe_rout_act_tbl.FIRST;
367: j := 0;

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

433: l_text_string :=
434: l_text_string || p_recipe_rout_act_tbl (i).activity;
435:
436: --Bug#5112133
437: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
438: gme_debug.put_line ('text code for activity=' || l_gmd_text_code);
439: gme_debug.put_line ('key_field for activity=' || l_text_string);
440: gme_debug.put_line ('calling copy_and_create_text for activities');
441: END IF;

Line 438: gme_debug.put_line ('text code for activity=' || l_gmd_text_code);

434: l_text_string || p_recipe_rout_act_tbl (i).activity;
435:
436: --Bug#5112133
437: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
438: gme_debug.put_line ('text code for activity=' || l_gmd_text_code);
439: gme_debug.put_line ('key_field for activity=' || l_text_string);
440: gme_debug.put_line ('calling copy_and_create_text for activities');
441: END IF;
442:

Line 439: gme_debug.put_line ('key_field for activity=' || l_text_string);

435:
436: --Bug#5112133
437: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
438: gme_debug.put_line ('text code for activity=' || l_gmd_text_code);
439: gme_debug.put_line ('key_field for activity=' || l_text_string);
440: gme_debug.put_line ('calling copy_and_create_text for activities');
441: END IF;
442:
443: copy_and_create_text (l_gmd_text_code

Line 440: gme_debug.put_line ('calling copy_and_create_text for activities');

436: --Bug#5112133
437: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
438: gme_debug.put_line ('text code for activity=' || l_gmd_text_code);
439: gme_debug.put_line ('key_field for activity=' || l_text_string);
440: gme_debug.put_line ('calling copy_and_create_text for activities');
441: END IF;
442:
443: copy_and_create_text (l_gmd_text_code
444: ,l_text_string

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

477:
478: i := p_recipe_rout_act_tbl.NEXT (i);
479: END LOOP; /* WHILE i IS NOT NULL; STEP ACTIVITIES */
480:
481: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
482: gme_debug.put_line ('Completed GME_BATCH_STEP_ACTIVITIES');
483: -- Create data for GME_BATCH_STEP_RESOURCES and GME_RESOURCE_TXNS...
484: gme_debug.put_line ('GME_BATCH_STEP_RESOURCES');
485: END IF;

Line 482: gme_debug.put_line ('Completed GME_BATCH_STEP_ACTIVITIES');

478: i := p_recipe_rout_act_tbl.NEXT (i);
479: END LOOP; /* WHILE i IS NOT NULL; STEP ACTIVITIES */
480:
481: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
482: gme_debug.put_line ('Completed GME_BATCH_STEP_ACTIVITIES');
483: -- Create data for GME_BATCH_STEP_RESOURCES and GME_RESOURCE_TXNS...
484: gme_debug.put_line ('GME_BATCH_STEP_RESOURCES');
485: END IF;
486:

Line 484: gme_debug.put_line ('GME_BATCH_STEP_RESOURCES');

480:
481: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
482: gme_debug.put_line ('Completed GME_BATCH_STEP_ACTIVITIES');
483: -- Create data for GME_BATCH_STEP_RESOURCES and GME_RESOURCE_TXNS...
484: gme_debug.put_line ('GME_BATCH_STEP_RESOURCES');
485: END IF;
486:
487: i := p_recipe_rout_resc_tbl.FIRST;
488: j := 0;

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

564: RAISE invalid_resource_qty_usage;
565: END IF;
566: END IF;
567:
568: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
569: gme_debug.put_line ( ' plan_rsrc_qty '
570: || l_gme_batch_step_resources (j).plan_rsrc_qty);
571: END IF;
572:

Line 569: gme_debug.put_line ( ' plan_rsrc_qty '

565: END IF;
566: END IF;
567:
568: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
569: gme_debug.put_line ( ' plan_rsrc_qty '
570: || l_gme_batch_step_resources (j).plan_rsrc_qty);
571: END IF;
572:
573: -- Link this resource to the batch step it belongs to...

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

620: l_text_string :=
621: l_text_string || p_recipe_rout_resc_tbl (i).resources;
622:
623: --Bug#5112133
624: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
625: gme_debug.put_line ('text code for resource=' || l_gmd_text_code);
626: gme_debug.put_line ('key_field for resource=' || l_text_string);
627: gme_debug.put_line ('calling copy_and_create_text for resources');
628: END IF;

Line 625: gme_debug.put_line ('text code for resource=' || l_gmd_text_code);

621: l_text_string || p_recipe_rout_resc_tbl (i).resources;
622:
623: --Bug#5112133
624: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
625: gme_debug.put_line ('text code for resource=' || l_gmd_text_code);
626: gme_debug.put_line ('key_field for resource=' || l_text_string);
627: gme_debug.put_line ('calling copy_and_create_text for resources');
628: END IF;
629:

Line 626: gme_debug.put_line ('key_field for resource=' || l_text_string);

622:
623: --Bug#5112133
624: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
625: gme_debug.put_line ('text code for resource=' || l_gmd_text_code);
626: gme_debug.put_line ('key_field for resource=' || l_text_string);
627: gme_debug.put_line ('calling copy_and_create_text for resources');
628: END IF;
629:
630: copy_and_create_text (l_gmd_text_code

Line 627: gme_debug.put_line ('calling copy_and_create_text for resources');

623: --Bug#5112133
624: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
625: gme_debug.put_line ('text code for resource=' || l_gmd_text_code);
626: gme_debug.put_line ('key_field for resource=' || l_text_string);
627: gme_debug.put_line ('calling copy_and_create_text for resources');
628: END IF;
629:
630: copy_and_create_text (l_gmd_text_code
631: ,l_text_string

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

668: IF l_gme_batch_step_resources.COUNT > 0 THEN
669: gme_batch_step_chg_pvt.set_sequence_dependent_id (l_batch_id);
670: END IF;
671:
672: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
673: gme_debug.put_line ('Completed GME_BATCH_STEP_RESOURCES');
674: gme_debug.put_line ('GME_step_process_parameters');
675: END IF;
676:

Line 673: gme_debug.put_line ('Completed GME_BATCH_STEP_RESOURCES');

669: gme_batch_step_chg_pvt.set_sequence_dependent_id (l_batch_id);
670: END IF;
671:
672: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
673: gme_debug.put_line ('Completed GME_BATCH_STEP_RESOURCES');
674: gme_debug.put_line ('GME_step_process_parameters');
675: END IF;
676:
677: FOR m IN 1 .. p_resc_parameters_tbl.COUNT LOOP

Line 674: gme_debug.put_line ('GME_step_process_parameters');

670: END IF;
671:
672: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
673: gme_debug.put_line ('Completed GME_BATCH_STEP_RESOURCES');
674: gme_debug.put_line ('GME_step_process_parameters');
675: END IF;
676:
677: FOR m IN 1 .. p_resc_parameters_tbl.COUNT LOOP
678: l_gme_rsrc_parameters.EXTEND;

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

745: RAISE error_insert_b_res_param;
746: END IF;
747: END LOOP;
748:
749: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
750: gme_debug.put_line ('GME_BATCH_STEP_ITEMS');
751: END IF;
752:
753: -- Create data for GME_BATCH_STEP_ITEMS --> item/step assocations...

Line 750: gme_debug.put_line ('GME_BATCH_STEP_ITEMS');

746: END IF;
747: END LOOP;
748:
749: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
750: gme_debug.put_line ('GME_BATCH_STEP_ITEMS');
751: END IF;
752:
753: -- Create data for GME_BATCH_STEP_ITEMS --> item/step assocations...
754: i := p_recipe_rout_matl_tbl.FIRST;

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

770: END IF;
771:
772: l_gme_batch_step_items (j).batch_id := l_batch_id;
773:
774: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
775: gme_debug.put_line ('batch_id is '||l_batch_id);
776: gme_debug.put_line ('formulaline_id is '||p_recipe_rout_matl_tbl (i).formulaline_id);
777: gme_debug.put_line ('routingstep_id is '||p_recipe_rout_matl_tbl (i).routingstep_id);
778: END IF;

Line 775: gme_debug.put_line ('batch_id is '||l_batch_id);

771:
772: l_gme_batch_step_items (j).batch_id := l_batch_id;
773:
774: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
775: gme_debug.put_line ('batch_id is '||l_batch_id);
776: gme_debug.put_line ('formulaline_id is '||p_recipe_rout_matl_tbl (i).formulaline_id);
777: gme_debug.put_line ('routingstep_id is '||p_recipe_rout_matl_tbl (i).routingstep_id);
778: END IF;
779:

Line 776: gme_debug.put_line ('formulaline_id is '||p_recipe_rout_matl_tbl (i).formulaline_id);

772: l_gme_batch_step_items (j).batch_id := l_batch_id;
773:
774: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
775: gme_debug.put_line ('batch_id is '||l_batch_id);
776: gme_debug.put_line ('formulaline_id is '||p_recipe_rout_matl_tbl (i).formulaline_id);
777: gme_debug.put_line ('routingstep_id is '||p_recipe_rout_matl_tbl (i).routingstep_id);
778: END IF;
779:
780: SELECT count(*)

Line 777: gme_debug.put_line ('routingstep_id is '||p_recipe_rout_matl_tbl (i).routingstep_id);

773:
774: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
775: gme_debug.put_line ('batch_id is '||l_batch_id);
776: gme_debug.put_line ('formulaline_id is '||p_recipe_rout_matl_tbl (i).formulaline_id);
777: gme_debug.put_line ('routingstep_id is '||p_recipe_rout_matl_tbl (i).routingstep_id);
778: END IF;
779:
780: SELECT count(*)
781: INTO l_count

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

865: l_text_string :=
866: l_text_string||TO_CHAR (p_recipe_rout_matl_tbl(j).ROUTINGSTEP_ID);
867:
868: -- Bug#5112133
869: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
870: gme_debug.put_line ('text code for step items=' || l_gmd_text_code);
871: gme_debug.put_line ('key_field for step items=' || l_text_string);
872: gme_debug.put_line ('calling copy_and_create_text for step items');
873: END IF;

Line 870: gme_debug.put_line ('text code for step items=' || l_gmd_text_code);

866: l_text_string||TO_CHAR (p_recipe_rout_matl_tbl(j).ROUTINGSTEP_ID);
867:
868: -- Bug#5112133
869: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
870: gme_debug.put_line ('text code for step items=' || l_gmd_text_code);
871: gme_debug.put_line ('key_field for step items=' || l_text_string);
872: gme_debug.put_line ('calling copy_and_create_text for step items');
873: END IF;
874:

Line 871: gme_debug.put_line ('key_field for step items=' || l_text_string);

867:
868: -- Bug#5112133
869: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
870: gme_debug.put_line ('text code for step items=' || l_gmd_text_code);
871: gme_debug.put_line ('key_field for step items=' || l_text_string);
872: gme_debug.put_line ('calling copy_and_create_text for step items');
873: END IF;
874:
875: copy_and_create_text (l_gmd_text_code

Line 872: gme_debug.put_line ('calling copy_and_create_text for step items');

868: -- Bug#5112133
869: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
870: gme_debug.put_line ('text code for step items=' || l_gmd_text_code);
871: gme_debug.put_line ('key_field for step items=' || l_text_string);
872: gme_debug.put_line ('calling copy_and_create_text for step items');
873: END IF;
874:
875: copy_and_create_text (l_gmd_text_code
876: ,l_text_string

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

896: END IF; -- l_count = 0
897: i := p_recipe_rout_matl_tbl.NEXT (i);
898: END LOOP; /* WHILE i IS NOT NULL ; STEP ITEM ASSOCIATIONS*/
899:
900: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
901: gme_debug.put_line ('Completed GME_BATCH_STEP_ITEMS');
902: gme_debug.put_line ('GME_BATCH_STEP_DEPENDENCIES');
903: END IF;
904:

Line 901: gme_debug.put_line ('Completed GME_BATCH_STEP_ITEMS');

897: i := p_recipe_rout_matl_tbl.NEXT (i);
898: END LOOP; /* WHILE i IS NOT NULL ; STEP ITEM ASSOCIATIONS*/
899:
900: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
901: gme_debug.put_line ('Completed GME_BATCH_STEP_ITEMS');
902: gme_debug.put_line ('GME_BATCH_STEP_DEPENDENCIES');
903: END IF;
904:
905: -- Create data for GME_BATCH_STEP_DEPENDENCIES

Line 902: gme_debug.put_line ('GME_BATCH_STEP_DEPENDENCIES');

898: END LOOP; /* WHILE i IS NOT NULL ; STEP ITEM ASSOCIATIONS*/
899:
900: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
901: gme_debug.put_line ('Completed GME_BATCH_STEP_ITEMS');
902: gme_debug.put_line ('GME_BATCH_STEP_DEPENDENCIES');
903: END IF;
904:
905: -- Create data for GME_BATCH_STEP_DEPENDENCIES
906: i := p_routing_depd_tbl.FIRST;

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

956:
957: i := p_routing_depd_tbl.NEXT (i);
958: END LOOP; /* WHILE i IS NOT NULL ; STEP DEPENDENCIES*/
959:
960: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
961: gme_debug.put_line ('Completed GME_BATCH_STEP_DEPENDENCIES');
962: END IF;
963:
964: -- Now calculate the step quantities...

Line 961: gme_debug.put_line ('Completed GME_BATCH_STEP_DEPENDENCIES');

957: i := p_routing_depd_tbl.NEXT (i);
958: END LOOP; /* WHILE i IS NOT NULL ; STEP DEPENDENCIES*/
959:
960: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
961: gme_debug.put_line ('Completed GME_BATCH_STEP_DEPENDENCIES');
962: END IF;
963:
964: -- Now calculate the step quantities...
965: IF ( p_recipe_rout_step_tbl.COUNT = 1

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

969: -- are no item_step_associations either... so do nothing...
970: NULL;
971: ELSE
972: IF (p_gme_batch_header_rec.automatic_step_calculation = 1) THEN
973: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
974: gme_debug.put_line ('auto step calc for batch id '||l_batch_id);
975: gme_debug.put_line ('CALLING gmd_auto_step_calc.calc_step_qty. Org is '||p_gme_batch_header_rec.organization_id);
976: END IF;
977:

Line 974: gme_debug.put_line ('auto step calc for batch id '||l_batch_id);

970: NULL;
971: ELSE
972: IF (p_gme_batch_header_rec.automatic_step_calculation = 1) THEN
973: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
974: gme_debug.put_line ('auto step calc for batch id '||l_batch_id);
975: gme_debug.put_line ('CALLING gmd_auto_step_calc.calc_step_qty. Org is '||p_gme_batch_header_rec.organization_id);
976: END IF;
977:
978: gmd_auto_step_calc.calc_step_qty

Line 975: gme_debug.put_line ('CALLING gmd_auto_step_calc.calc_step_qty. Org is '||p_gme_batch_header_rec.organization_id);

971: ELSE
972: IF (p_gme_batch_header_rec.automatic_step_calculation = 1) THEN
973: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
974: gme_debug.put_line ('auto step calc for batch id '||l_batch_id);
975: gme_debug.put_line ('CALLING gmd_auto_step_calc.calc_step_qty. Org is '||p_gme_batch_header_rec.organization_id);
976: END IF;
977:
978: gmd_auto_step_calc.calc_step_qty
979: (p_parent_id => l_batch_id

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

983: ,p_return_status => l_return_status
984: ,p_called_from_batch => 1
985: ,p_organization_id => p_gme_batch_header_rec.organization_id);
986: ELSE
987: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
988: gme_debug.put_line ('NO auto step calc...');
989: gme_debug.put_line ('CALLING calc_step_qty ...');
990: END IF;
991:

Line 988: gme_debug.put_line ('NO auto step calc...');

984: ,p_called_from_batch => 1
985: ,p_organization_id => p_gme_batch_header_rec.organization_id);
986: ELSE
987: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
988: gme_debug.put_line ('NO auto step calc...');
989: gme_debug.put_line ('CALLING calc_step_qty ...');
990: END IF;
991:
992: calc_step_qty (l_batch_id, l_step_tbl, l_return_status, 1);

Line 989: gme_debug.put_line ('CALLING calc_step_qty ...');

985: ,p_organization_id => p_gme_batch_header_rec.organization_id);
986: ELSE
987: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
988: gme_debug.put_line ('NO auto step calc...');
989: gme_debug.put_line ('CALLING calc_step_qty ...');
990: END IF;
991:
992: calc_step_qty (l_batch_id, l_step_tbl, l_return_status, 1);
993: END IF;

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

992: calc_step_qty (l_batch_id, l_step_tbl, l_return_status, 1);
993: END IF;
994:
995: IF l_return_status <> x_return_status THEN
996: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
997: gme_debug.put_line
998: (fnd_msg_pub.get (p_encoded => fnd_api.g_false) );
999: END IF;
1000:

Line 997: gme_debug.put_line

993: END IF;
994:
995: IF l_return_status <> x_return_status THEN
996: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
997: gme_debug.put_line
998: (fnd_msg_pub.get (p_encoded => fnd_api.g_false) );
999: END IF;
1000:
1001: RAISE error_calc_step_qty;

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

1000:
1001: RAISE error_calc_step_qty;
1002: END IF;
1003:
1004: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1005: gme_debug.put_line ('done step calc...');
1006: gme_debug.put_line ('GO INTO LOOP TO RESET PLAN STEP QTY... ');
1007: END IF;
1008:

Line 1005: gme_debug.put_line ('done step calc...');

1001: RAISE error_calc_step_qty;
1002: END IF;
1003:
1004: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1005: gme_debug.put_line ('done step calc...');
1006: gme_debug.put_line ('GO INTO LOOP TO RESET PLAN STEP QTY... ');
1007: END IF;
1008:
1009: -- Update the plan_step_qty in GME_BATCH_STEPS

Line 1006: gme_debug.put_line ('GO INTO LOOP TO RESET PLAN STEP QTY... ');

1002: END IF;
1003:
1004: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1005: gme_debug.put_line ('done step calc...');
1006: gme_debug.put_line ('GO INTO LOOP TO RESET PLAN STEP QTY... ');
1007: END IF;
1008:
1009: -- Update the plan_step_qty in GME_BATCH_STEPS
1010: FOR i IN l_step_tbl.FIRST .. l_step_tbl.LAST LOOP

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

1008:
1009: -- Update the plan_step_qty in GME_BATCH_STEPS
1010: FOR i IN l_step_tbl.FIRST .. l_step_tbl.LAST LOOP
1011:
1012: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1013: gme_debug.put_line ('step number is '|| l_step_tbl (i).step_no);
1014: gme_debug.put_line ('PLAN STEP QTY FROM GMD IS '|| l_step_tbl (i).step_qty);
1015: gme_debug.put_line ('PLAN STEP QTY RNDED FROM GMD IS '|| ROUND (l_step_tbl (i).step_qty, 32));
1016: END IF;

Line 1013: gme_debug.put_line ('step number is '|| l_step_tbl (i).step_no);

1009: -- Update the plan_step_qty in GME_BATCH_STEPS
1010: FOR i IN l_step_tbl.FIRST .. l_step_tbl.LAST LOOP
1011:
1012: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1013: gme_debug.put_line ('step number is '|| l_step_tbl (i).step_no);
1014: gme_debug.put_line ('PLAN STEP QTY FROM GMD IS '|| l_step_tbl (i).step_qty);
1015: gme_debug.put_line ('PLAN STEP QTY RNDED FROM GMD IS '|| ROUND (l_step_tbl (i).step_qty, 32));
1016: END IF;
1017:

Line 1014: gme_debug.put_line ('PLAN STEP QTY FROM GMD IS '|| l_step_tbl (i).step_qty);

1010: FOR i IN l_step_tbl.FIRST .. l_step_tbl.LAST LOOP
1011:
1012: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1013: gme_debug.put_line ('step number is '|| l_step_tbl (i).step_no);
1014: gme_debug.put_line ('PLAN STEP QTY FROM GMD IS '|| l_step_tbl (i).step_qty);
1015: gme_debug.put_line ('PLAN STEP QTY RNDED FROM GMD IS '|| ROUND (l_step_tbl (i).step_qty, 32));
1016: END IF;
1017:
1018: -- Round the step_qty, step_mass_qty, step_vol_qty to 32 decimal places.

Line 1015: gme_debug.put_line ('PLAN STEP QTY RNDED FROM GMD IS '|| ROUND (l_step_tbl (i).step_qty, 32));

1011:
1012: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1013: gme_debug.put_line ('step number is '|| l_step_tbl (i).step_no);
1014: gme_debug.put_line ('PLAN STEP QTY FROM GMD IS '|| l_step_tbl (i).step_qty);
1015: gme_debug.put_line ('PLAN STEP QTY RNDED FROM GMD IS '|| ROUND (l_step_tbl (i).step_qty, 32));
1016: END IF;
1017:
1018: -- Round the step_qty, step_mass_qty, step_vol_qty to 32 decimal places.
1019: UPDATE gme_batch_steps

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

1052: --multiply the step qty with standard factor to get vol qty
1053: l_volume_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
1054: END IF;
1055:
1056: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1057: gme_debug.put_line
1058: ( g_pkg_name
1059: || '.'
1060: || l_api_name

Line 1057: gme_debug.put_line

1053: l_volume_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
1054: END IF;
1055:
1056: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1057: gme_debug.put_line
1058: ( g_pkg_name
1059: || '.'
1060: || l_api_name
1061: || 'resources name passed in case of single step insertion is'

Line 1063: gme_debug.put_line

1059: || '.'
1060: || l_api_name
1061: || 'resources name passed in case of single step insertion is'
1062: || p_recipe_rout_step_tbl (1).resources);
1063: gme_debug.put_line
1064: ( g_pkg_name
1065: || '.'
1066: || l_api_name
1067: || ' Mass Qty, Volume Qty: '

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

1079: IF l_return_status <> x_return_status THEN
1080: RAISE error_calc_charges;
1081: END IF;
1082:
1083: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1084: gme_debug.put_line ( ' return status from calc charge '
1085: || l_return_status);
1086: gme_debug.put_line (' charges ' || TO_CHAR (l_charge) );
1087: END IF;

Line 1084: gme_debug.put_line ( ' return status from calc charge '

1080: RAISE error_calc_charges;
1081: END IF;
1082:
1083: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1084: gme_debug.put_line ( ' return status from calc charge '
1085: || l_return_status);
1086: gme_debug.put_line (' charges ' || TO_CHAR (l_charge) );
1087: END IF;
1088:

Line 1086: gme_debug.put_line (' charges ' || TO_CHAR (l_charge) );

1082:
1083: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1084: gme_debug.put_line ( ' return status from calc charge '
1085: || l_return_status);
1086: gme_debug.put_line (' charges ' || TO_CHAR (l_charge) );
1087: END IF;
1088:
1089: UPDATE gme_batch_steps
1090: SET plan_charges = l_charge

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

1142: -- if scale_type = 0, then let's leave the plan_rsrc_qty to that passed in by GMD... scale_type = 0 is fixed
1143: AND plan_rsrc_qty <> 0;
1144:
1145: -- Update the resource quantities for all resources and usage if scale by charge...
1146: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1147: gme_debug.put_line (' plan charges ' || TO_CHAR (l_plan_charges) );
1148: END IF;
1149:
1150: IF l_plan_charges IS NOT NULL THEN

Line 1147: gme_debug.put_line (' plan charges ' || TO_CHAR (l_plan_charges) );

1143: AND plan_rsrc_qty <> 0;
1144:
1145: -- Update the resource quantities for all resources and usage if scale by charge...
1146: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1147: gme_debug.put_line (' plan charges ' || TO_CHAR (l_plan_charges) );
1148: END IF;
1149:
1150: IF l_plan_charges IS NOT NULL THEN
1151: UPDATE gme_batch_step_resources

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

1164: WHERE batchstep_id = l_last_batchstep_id AND scale_type = 2;
1165: -- scale_type = 2 denotes scale by charge...
1166: END IF;
1167:
1168: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1169: gme_debug.put_line ( ' total scale by charge '
1170: || TO_CHAR (l_total_scale_by_charge) );
1171: END IF;
1172:

Line 1169: gme_debug.put_line ( ' total scale by charge '

1165: -- scale_type = 2 denotes scale by charge...
1166: END IF;
1167:
1168: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1169: gme_debug.put_line ( ' total scale by charge '
1170: || TO_CHAR (l_total_scale_by_charge) );
1171: END IF;
1172:
1173: l_total_scale_by_charge := l_count_scale_by_charge;

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

1219: AND scale_type <> 0
1220: AND plan_rsrc_qty <> 0;
1221:
1222: -- if scale_type = 0, then let's leave the plan_rsrc_qty to that passed in by GMD... scale_type = 0 is fixed
1223: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1224: gme_debug.put_line ( ' plan charges batch steps '
1225: || TO_CHAR (l_plan_charges) );
1226: END IF;
1227:

Line 1224: gme_debug.put_line ( ' plan charges batch steps '

1220: AND plan_rsrc_qty <> 0;
1221:
1222: -- if scale_type = 0, then let's leave the plan_rsrc_qty to that passed in by GMD... scale_type = 0 is fixed
1223: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1224: gme_debug.put_line ( ' plan charges batch steps '
1225: || TO_CHAR (l_plan_charges) );
1226: END IF;
1227:
1228: IF l_plan_charges IS NOT NULL THEN

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

1245:
1246: l_total_scale_by_charge :=
1247: l_total_scale_by_charge + l_count_scale_by_charge;
1248:
1249: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1250: gme_debug.put_line ( ' l_total scale by charge loop '
1251: || TO_CHAR (l_total_scale_by_charge) );
1252: END IF;
1253:

Line 1250: gme_debug.put_line ( ' l_total scale by charge loop '

1246: l_total_scale_by_charge :=
1247: l_total_scale_by_charge + l_count_scale_by_charge;
1248:
1249: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1250: gme_debug.put_line ( ' l_total scale by charge loop '
1251: || TO_CHAR (l_total_scale_by_charge) );
1252: END IF;
1253:
1254: FETCH cur_get_batch_steps

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

1299: RAISE process_qty_below_cap;
1300: END IF;
1301: END IF; /* IF NOT (p_ignore_qty_below_cap) */
1302:
1303: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1304: gme_debug.put_line ( 'l_total_scale_by_charge='
1305: || l_total_scale_by_charge);
1306: END IF;
1307:

Line 1304: gme_debug.put_line ( 'l_total_scale_by_charge='

1300: END IF;
1301: END IF; /* IF NOT (p_ignore_qty_below_cap) */
1302:
1303: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1304: gme_debug.put_line ( 'l_total_scale_by_charge='
1305: || l_total_scale_by_charge);
1306: END IF;
1307:
1308: IF l_total_scale_by_charge > 0 THEN

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

1306: END IF;
1307:
1308: IF l_total_scale_by_charge > 0 THEN
1309: -- we are not raising an error, just warn the user.
1310: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1311: gme_debug.put_line ('undefined charge warning');
1312: END IF;
1313:
1314: fnd_message.set_name ('GME', 'GME_UNDEF_CHRG_RSRC_SCALE');

Line 1311: gme_debug.put_line ('undefined charge warning');

1307:
1308: IF l_total_scale_by_charge > 0 THEN
1309: -- we are not raising an error, just warn the user.
1310: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1311: gme_debug.put_line ('undefined charge warning');
1312: END IF;
1313:
1314: fnd_message.set_name ('GME', 'GME_UNDEF_CHRG_RSRC_SCALE');
1315: fnd_msg_pub.ADD;

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

1350: INTO l_step_plan_start_date, l_step_plan_cmplt_date;
1351:
1352: CLOSE cur_step_dates;
1353:
1354: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1355: gme_debug.put_line ( l_api_name
1356: || 'start,cmplt dates for step are '
1357: || TO_CHAR (l_step_plan_start_date
1358: ,'DD-MON-YYYY HH24:MI:SS')

Line 1355: gme_debug.put_line ( l_api_name

1351:
1352: CLOSE cur_step_dates;
1353:
1354: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1355: gme_debug.put_line ( l_api_name
1356: || 'start,cmplt dates for step are '
1357: || TO_CHAR (l_step_plan_start_date
1358: ,'DD-MON-YYYY HH24:MI:SS')
1359: || ' '

Line 1362: gme_debug.put_line

1358: ,'DD-MON-YYYY HH24:MI:SS')
1359: || ' '
1360: || TO_CHAR (l_step_plan_cmplt_date
1361: ,'DD-MON-YYYY HH24:MI:SS') );
1362: gme_debug.put_line
1363: ( 'user supplied start,cmplt dates for step are'
1364: || TO_CHAR (p_step_start_date
1365: ,'DD-MON-YYYY HH24:MI:SS')
1366: || ' '

Line 1369: gme_debug.put_line

1365: ,'DD-MON-YYYY HH24:MI:SS')
1366: || ' '
1367: || TO_CHAR (p_step_cmplt_date
1368: ,'DD-MON-YYYY HH24:MI:SS') );
1369: gme_debug.put_line
1370: ( 'start,cmplt dates for batch are'
1371: || TO_CHAR (p_gme_batch_header_rec.plan_start_date
1372: ,'DD-MON-YYYY HH24:MI:SS')
1373: || TO_CHAR (p_gme_batch_header_rec.plan_cmplt_date

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

1375: END IF;
1376:
1377: IF (p_step_cmplt_date IS NOT NULL)
1378: AND (p_step_cmplt_date <> l_step_plan_cmplt_date) THEN
1379: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1380: gme_debug.put_line
1381: ('p_step_cmplt_date diff from l_step_plan_cmplt_date');
1382: END IF;
1383:

Line 1380: gme_debug.put_line

1376:
1377: IF (p_step_cmplt_date IS NOT NULL)
1378: AND (p_step_cmplt_date <> l_step_plan_cmplt_date) THEN
1379: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1380: gme_debug.put_line
1381: ('p_step_cmplt_date diff from l_step_plan_cmplt_date');
1382: END IF;
1383:
1384: IF (p_step_cmplt_date > l_step_plan_cmplt_date) THEN

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

1408: l_step_plan_cmplt_date := p_step_cmplt_date;
1409: END IF; /* p_step_cmplt_date is not null */
1410:
1411: --picking the step values again
1412: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1413: gme_debug.put_line
1414: ( 'step start,cmplt dates for step after comparision with user step dates are'
1415: || TO_CHAR (l_step_plan_start_date, 'DD-MON-YYYY HH24:MI:SS')
1416: || ' '

Line 1413: gme_debug.put_line

1409: END IF; /* p_step_cmplt_date is not null */
1410:
1411: --picking the step values again
1412: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1413: gme_debug.put_line
1414: ( 'step start,cmplt dates for step after comparision with user step dates are'
1415: || TO_CHAR (l_step_plan_start_date, 'DD-MON-YYYY HH24:MI:SS')
1416: || ' '
1417: || TO_CHAR (l_step_plan_cmplt_date, 'DD-MON-YYYY HH24:MI:SS') );

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

1418: END IF;
1419:
1420: --checking against the batch dates
1421: IF (l_step_plan_start_date < p_gme_batch_header_rec.plan_start_date) THEN
1422: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1423: gme_debug.put_line
1424: ('l_step_plan_start_date diff from batch start date');
1425: END IF;
1426:

Line 1423: gme_debug.put_line

1419:
1420: --checking against the batch dates
1421: IF (l_step_plan_start_date < p_gme_batch_header_rec.plan_start_date) THEN
1422: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1423: gme_debug.put_line
1424: ('l_step_plan_start_date diff from batch start date');
1425: END IF;
1426:
1427: gme_reschedule_batch_pvt.truncate_date

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

1436: END IF;
1437: /* (l_step_plan_start_date < p_gme_batch_header_rec.plan_start_date) */
1438:
1439: IF (l_step_plan_cmplt_date > p_gme_batch_header_rec.plan_cmplt_date) THEN
1440: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1441: gme_debug.put_line
1442: ('l_step_plan_cmplt_date diff from batch cmplt date');
1443: END IF;
1444:

Line 1441: gme_debug.put_line

1437: /* (l_step_plan_start_date < p_gme_batch_header_rec.plan_start_date) */
1438:
1439: IF (l_step_plan_cmplt_date > p_gme_batch_header_rec.plan_cmplt_date) THEN
1440: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1441: gme_debug.put_line
1442: ('l_step_plan_cmplt_date diff from batch cmplt date');
1443: END IF;
1444:
1445: gme_reschedule_batch_pvt.truncate_date

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

1462:
1463: CLOSE cur_get_batchstep_ids;
1464:
1465: FOR i IN 1 .. l_batchstep_ids_tab.COUNT LOOP
1466: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1467: gme_debug.put_line ( 'batch,step ids are'
1468: || p_gme_batch_header_rec.batch_id
1469: || l_batchstep_ids_tab (i) );
1470: END IF;

Line 1467: gme_debug.put_line ( 'batch,step ids are'

1463: CLOSE cur_get_batchstep_ids;
1464:
1465: FOR i IN 1 .. l_batchstep_ids_tab.COUNT LOOP
1466: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1467: gme_debug.put_line ( 'batch,step ids are'
1468: || p_gme_batch_header_rec.batch_id
1469: || l_batchstep_ids_tab (i) );
1470: END IF;
1471:

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

1484:
1485: FETCH cur_get_resource_dates
1486: INTO l_rsrc_start_date, l_rsrc_cmplt_date;
1487:
1488: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1489: gme_debug.put_line ( g_pkg_name
1490: || '.'
1491: || l_api_name
1492: || 'rsrc start,cmplt dates are'

Line 1489: gme_debug.put_line ( g_pkg_name

1485: FETCH cur_get_resource_dates
1486: INTO l_rsrc_start_date, l_rsrc_cmplt_date;
1487:
1488: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1489: gme_debug.put_line ( g_pkg_name
1490: || '.'
1491: || l_api_name
1492: || 'rsrc start,cmplt dates are'
1493: || l_rsrc_start_date

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

1511: wf_event.RAISE (p_event_name => gme_common_pvt.G_BATCHSTEP_CREATED
1512: ,p_event_key => l_gme_batch_steps (1).batchstep_id);
1513: END IF;
1514:
1515: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1516: gme_debug.put_line
1517: ( 'Done with Create Batch steps with return code = '
1518: || x_return_status);
1519: END IF;

Line 1516: gme_debug.put_line

1512: ,p_event_key => l_gme_batch_steps (1).batchstep_id);
1513: END IF;
1514:
1515: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1516: gme_debug.put_line
1517: ( 'Done with Create Batch steps with return code = '
1518: || x_return_status);
1519: END IF;
1520:

Line 1521: IF g_debug <= gme_debug.g_log_procedure THEN

1517: ( 'Done with Create Batch steps with return code = '
1518: || x_return_status);
1519: END IF;
1520:
1521: IF g_debug <= gme_debug.g_log_procedure THEN
1522: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1523: END IF;
1524: EXCEPTION
1525: WHEN error_insert_batch_step THEN

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

1518: || x_return_status);
1519: END IF;
1520:
1521: IF g_debug <= gme_debug.g_log_procedure THEN
1522: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1523: END IF;
1524: EXCEPTION
1525: WHEN error_insert_batch_step THEN
1526: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

1522: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1523: END IF;
1524: EXCEPTION
1525: WHEN error_insert_batch_step THEN
1526: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1527: gme_debug.put_line ('insert batch step error');
1528: END IF;
1529:
1530: x_return_status := fnd_api.g_ret_sts_error;

Line 1527: gme_debug.put_line ('insert batch step error');

1523: END IF;
1524: EXCEPTION
1525: WHEN error_insert_batch_step THEN
1526: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1527: gme_debug.put_line ('insert batch step error');
1528: END IF;
1529:
1530: x_return_status := fnd_api.g_ret_sts_error;
1531: WHEN error_insert_b_step_act THEN

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

1528: END IF;
1529:
1530: x_return_status := fnd_api.g_ret_sts_error;
1531: WHEN error_insert_b_step_act THEN
1532: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1533: gme_debug.put_line ('insert batch step activity error');
1534: END IF;
1535:
1536: x_return_status := fnd_api.g_ret_sts_error;

Line 1533: gme_debug.put_line ('insert batch step activity error');

1529:
1530: x_return_status := fnd_api.g_ret_sts_error;
1531: WHEN error_insert_b_step_act THEN
1532: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1533: gme_debug.put_line ('insert batch step activity error');
1534: END IF;
1535:
1536: x_return_status := fnd_api.g_ret_sts_error;
1537: WHEN error_insert_b_step_res THEN

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

1534: END IF;
1535:
1536: x_return_status := fnd_api.g_ret_sts_error;
1537: WHEN error_insert_b_step_res THEN
1538: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1539: gme_debug.put_line ('insert batch step resource error');
1540: END IF;
1541:
1542: x_return_status := fnd_api.g_ret_sts_error;

Line 1539: gme_debug.put_line ('insert batch step resource error');

1535:
1536: x_return_status := fnd_api.g_ret_sts_error;
1537: WHEN error_insert_b_step_res THEN
1538: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1539: gme_debug.put_line ('insert batch step resource error');
1540: END IF;
1541:
1542: x_return_status := fnd_api.g_ret_sts_error;
1543: WHEN error_insert_res_txns THEN

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

1540: END IF;
1541:
1542: x_return_status := fnd_api.g_ret_sts_error;
1543: WHEN error_insert_res_txns THEN
1544: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1545: gme_debug.put_line ('insert resource txns error');
1546: END IF;
1547:
1548: x_return_status := fnd_api.g_ret_sts_error;

Line 1545: gme_debug.put_line ('insert resource txns error');

1541:
1542: x_return_status := fnd_api.g_ret_sts_error;
1543: WHEN error_insert_res_txns THEN
1544: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1545: gme_debug.put_line ('insert resource txns error');
1546: END IF;
1547:
1548: x_return_status := fnd_api.g_ret_sts_error;
1549: WHEN error_insert_b_res_param THEN

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

1546: END IF;
1547:
1548: x_return_status := fnd_api.g_ret_sts_error;
1549: WHEN error_insert_b_res_param THEN
1550: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1551: gme_debug.put_line ('insert resource param error');
1552: END IF;
1553:
1554: x_return_status := fnd_api.g_ret_sts_error;

Line 1551: gme_debug.put_line ('insert resource param error');

1547:
1548: x_return_status := fnd_api.g_ret_sts_error;
1549: WHEN error_insert_b_res_param THEN
1550: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1551: gme_debug.put_line ('insert resource param error');
1552: END IF;
1553:
1554: x_return_status := fnd_api.g_ret_sts_error;
1555: WHEN error_insert_b_step_items THEN

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

1552: END IF;
1553:
1554: x_return_status := fnd_api.g_ret_sts_error;
1555: WHEN error_insert_b_step_items THEN
1556: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1557: gme_debug.put_line ('insert batch step items error');
1558: END IF;
1559:
1560: x_return_status := fnd_api.g_ret_sts_error;

Line 1557: gme_debug.put_line ('insert batch step items error');

1553:
1554: x_return_status := fnd_api.g_ret_sts_error;
1555: WHEN error_insert_b_step_items THEN
1556: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1557: gme_debug.put_line ('insert batch step items error');
1558: END IF;
1559:
1560: x_return_status := fnd_api.g_ret_sts_error;
1561: WHEN error_insert_b_step_depend THEN

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

1558: END IF;
1559:
1560: x_return_status := fnd_api.g_ret_sts_error;
1561: WHEN error_insert_b_step_depend THEN
1562: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1563: gme_debug.put_line ('insert batch step depend error');
1564: END IF;
1565:
1566: x_return_status := fnd_api.g_ret_sts_error;

Line 1563: gme_debug.put_line ('insert batch step depend error');

1559:
1560: x_return_status := fnd_api.g_ret_sts_error;
1561: WHEN error_insert_b_step_depend THEN
1562: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1563: gme_debug.put_line ('insert batch step depend error');
1564: END IF;
1565:
1566: x_return_status := fnd_api.g_ret_sts_error;
1567: WHEN error_calc_step_qty THEN

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

1564: END IF;
1565:
1566: x_return_status := fnd_api.g_ret_sts_error;
1567: WHEN error_calc_step_qty THEN
1568: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1569: gme_debug.put_line ('calc step qty error');
1570: END IF;
1571:
1572: x_return_status := fnd_api.g_ret_sts_error;

Line 1569: gme_debug.put_line ('calc step qty error');

1565:
1566: x_return_status := fnd_api.g_ret_sts_error;
1567: WHEN error_calc_step_qty THEN
1568: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1569: gme_debug.put_line ('calc step qty error');
1570: END IF;
1571:
1572: x_return_status := fnd_api.g_ret_sts_error;
1573: WHEN error_calc_dates THEN

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

1570: END IF;
1571:
1572: x_return_status := fnd_api.g_ret_sts_error;
1573: WHEN error_calc_dates THEN
1574: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1575: gme_debug.put_line ('calc dates error');
1576: END IF;
1577:
1578: x_return_status := l_return_status;

Line 1575: gme_debug.put_line ('calc dates error');

1571:
1572: x_return_status := fnd_api.g_ret_sts_error;
1573: WHEN error_calc_dates THEN
1574: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1575: gme_debug.put_line ('calc dates error');
1576: END IF;
1577:
1578: x_return_status := l_return_status;
1579: WHEN error_calc_charges THEN

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

1576: END IF;
1577:
1578: x_return_status := l_return_status;
1579: WHEN error_calc_charges THEN
1580: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1581: gme_debug.put_line ('calc charge error');
1582: END IF;
1583:
1584: x_return_status := fnd_api.g_ret_sts_error;

Line 1581: gme_debug.put_line ('calc charge error');

1577:
1578: x_return_status := l_return_status;
1579: WHEN error_calc_charges THEN
1580: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1581: gme_debug.put_line ('calc charge error');
1582: END IF;
1583:
1584: x_return_status := fnd_api.g_ret_sts_error;
1585: WHEN error_create_text THEN

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

1582: END IF;
1583:
1584: x_return_status := fnd_api.g_ret_sts_error;
1585: WHEN error_create_text THEN
1586: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1587: gme_debug.put_line ('create text error');
1588: END IF;
1589:
1590: x_return_status := l_return_status;

Line 1587: gme_debug.put_line ('create text error');

1583:
1584: x_return_status := fnd_api.g_ret_sts_error;
1585: WHEN error_create_text THEN
1586: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1587: gme_debug.put_line ('create text error');
1588: END IF;
1589:
1590: x_return_status := l_return_status;
1591: WHEN process_qty_below_cap THEN

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

1588: END IF;
1589:
1590: x_return_status := l_return_status;
1591: WHEN process_qty_below_cap THEN
1592: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1593: gme_debug.put_line ('process qty below capacity');
1594: END IF;
1595:
1596: x_return_status := fnd_api.g_ret_sts_error;

Line 1593: gme_debug.put_line ('process qty below capacity');

1589:
1590: x_return_status := l_return_status;
1591: WHEN process_qty_below_cap THEN
1592: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1593: gme_debug.put_line ('process qty below capacity');
1594: END IF;
1595:
1596: x_return_status := fnd_api.g_ret_sts_error;
1597: WHEN invalid_resource_qty_usage THEN

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

1594: END IF;
1595:
1596: x_return_status := fnd_api.g_ret_sts_error;
1597: WHEN invalid_resource_qty_usage THEN
1598: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1599: gme_debug.put_line
1600: ('invalild resource process quantity and usage');
1601: END IF;
1602: x_return_status := fnd_api.g_ret_sts_error;

Line 1599: gme_debug.put_line

1595:
1596: x_return_status := fnd_api.g_ret_sts_error;
1597: WHEN invalid_resource_qty_usage THEN
1598: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1599: gme_debug.put_line
1600: ('invalild resource process quantity and usage');
1601: END IF;
1602: x_return_status := fnd_api.g_ret_sts_error;
1603: WHEN error_truncate_date THEN

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

1600: ('invalild resource process quantity and usage');
1601: END IF;
1602: x_return_status := fnd_api.g_ret_sts_error;
1603: WHEN error_truncate_date THEN
1604: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1605: gme_debug.put_line ('truncate date procedure error');
1606: END IF;
1607:
1608: x_return_status := fnd_api.g_ret_sts_error;

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

1601: END IF;
1602: x_return_status := fnd_api.g_ret_sts_error;
1603: WHEN error_truncate_date THEN
1604: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1605: gme_debug.put_line ('truncate date procedure error');
1606: END IF;
1607:
1608: x_return_status := fnd_api.g_ret_sts_error;
1609: --FPBug#4395561

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

1608: x_return_status := fnd_api.g_ret_sts_error;
1609: --FPBug#4395561
1610: WHEN create_flex_failure THEN
1611: x_return_status := l_return_status;
1612: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
1613: gme_debug.put_line ('Creating the default values of the DFF failure');
1614: END IF;
1615: WHEN OTHERS THEN
1616: IF g_debug <= gme_debug.g_log_unexpected THEN

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

1609: --FPBug#4395561
1610: WHEN create_flex_failure THEN
1611: x_return_status := l_return_status;
1612: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
1613: gme_debug.put_line ('Creating the default values of the DFF failure');
1614: END IF;
1615: WHEN OTHERS THEN
1616: IF g_debug <= gme_debug.g_log_unexpected THEN
1617: gme_debug.put_line ( 'When others exception in '

Line 1616: IF g_debug <= gme_debug.g_log_unexpected THEN

1612: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
1613: gme_debug.put_line ('Creating the default values of the DFF failure');
1614: END IF;
1615: WHEN OTHERS THEN
1616: IF g_debug <= gme_debug.g_log_unexpected THEN
1617: gme_debug.put_line ( 'When others exception in '
1618: || g_pkg_name
1619: || '.'
1620: || l_api_name

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

1613: gme_debug.put_line ('Creating the default values of the DFF failure');
1614: END IF;
1615: WHEN OTHERS THEN
1616: IF g_debug <= gme_debug.g_log_unexpected THEN
1617: gme_debug.put_line ( 'When others exception in '
1618: || g_pkg_name
1619: || '.'
1620: || l_api_name
1621: || ' Error is '

Line 1651: IF g_debug <= gme_debug.g_log_procedure THEN

1647:
1648: x_cur_step_rec cur_get_steps%ROWTYPE;
1649: error_calc_charge EXCEPTION;
1650: BEGIN
1651: IF g_debug <= gme_debug.g_log_procedure THEN
1652: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1653: || l_api_name);
1654: END IF;
1655:

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

1648: x_cur_step_rec cur_get_steps%ROWTYPE;
1649: error_calc_charge EXCEPTION;
1650: BEGIN
1651: IF g_debug <= gme_debug.g_log_procedure THEN
1652: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1653: || l_api_name);
1654: END IF;
1655:
1656: x_return_status := fnd_api.g_ret_sts_success;

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

1661: FETCH cur_get_steps
1662: INTO x_cur_step_rec;
1663:
1664: WHILE cur_get_steps%FOUND LOOP
1665: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1666: gme_debug.put_line
1667: ( g_pkg_name
1668: || '.'
1669: || l_api_name

Line 1666: gme_debug.put_line

1662: INTO x_cur_step_rec;
1663:
1664: WHILE cur_get_steps%FOUND LOOP
1665: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1666: gme_debug.put_line
1667: ( g_pkg_name
1668: || '.'
1669: || l_api_name
1670: || 'p_step_charge_rsrc_tab(batchstep_id).resources is '

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

1679: ,p_vol_qty => x_cur_step_rec.plan_volume_qty
1680: ,x_charge => x_charge
1681: ,x_return_status => l_return_status);
1682:
1683: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1684: gme_debug.put_line
1685: ( ' update charges >calc charges > return charge '
1686: || TO_CHAR (x_charge) );
1687: gme_debug.put_line

Line 1684: gme_debug.put_line

1680: ,x_charge => x_charge
1681: ,x_return_status => l_return_status);
1682:
1683: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1684: gme_debug.put_line
1685: ( ' update charges >calc charges > return charge '
1686: || TO_CHAR (x_charge) );
1687: gme_debug.put_line
1688: ( ' update charges >calc charges >batchstep_id '

Line 1687: gme_debug.put_line

1683: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1684: gme_debug.put_line
1685: ( ' update charges >calc charges > return charge '
1686: || TO_CHAR (x_charge) );
1687: gme_debug.put_line
1688: ( ' update charges >calc charges >batchstep_id '
1689: || TO_CHAR (x_cur_step_rec.batchstep_id) );
1690: END IF;
1691:

Line 1710: IF g_debug <= gme_debug.g_log_procedure THEN

1706: SET plan_charges = x_charge_tab (i).charge
1707: WHERE batchstep_id = x_charge_tab (i).step_id;
1708: END LOOP;
1709:
1710: IF g_debug <= gme_debug.g_log_procedure THEN
1711: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1712: END IF;
1713: EXCEPTION
1714: WHEN error_calc_charge THEN

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

1707: WHERE batchstep_id = x_charge_tab (i).step_id;
1708: END LOOP;
1709:
1710: IF g_debug <= gme_debug.g_log_procedure THEN
1711: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1712: END IF;
1713: EXCEPTION
1714: WHEN error_calc_charge THEN
1715: x_return_status := l_return_status;

Line 1717: IF g_debug <= gme_debug.g_log_unexpected THEN

1713: EXCEPTION
1714: WHEN error_calc_charge THEN
1715: x_return_status := l_return_status;
1716: WHEN OTHERS THEN
1717: IF g_debug <= gme_debug.g_log_unexpected THEN
1718: gme_debug.put_line ( 'When others exception in '
1719: || g_pkg_name
1720: || '.'
1721: || l_api_name

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

1714: WHEN error_calc_charge THEN
1715: x_return_status := l_return_status;
1716: WHEN OTHERS THEN
1717: IF g_debug <= gme_debug.g_log_unexpected THEN
1718: gme_debug.put_line ( 'When others exception in '
1719: || g_pkg_name
1720: || '.'
1721: || l_api_name
1722: || ' Error is '

Line 1777: IF g_debug <= gme_debug.g_log_procedure THEN

1773: l_max_date DATE;
1774: l_plan_start_date DATE;
1775: l_api_name CONSTANT VARCHAR2 (30) := 'get_max_step_date';
1776: BEGIN
1777: IF g_debug <= gme_debug.g_log_procedure THEN
1778: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1779: || l_api_name);
1780: END IF;
1781:

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

1774: l_plan_start_date DATE;
1775: l_api_name CONSTANT VARCHAR2 (30) := 'get_max_step_date';
1776: BEGIN
1777: IF g_debug <= gme_debug.g_log_procedure THEN
1778: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1779: || l_api_name);
1780: END IF;
1781:
1782: l_max_date := NULL;

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

1808: FETCH cur_get_step_date
1809: INTO l_date;
1810:
1811: IF (cur_get_step_date%FOUND) AND (l_date IS NOT NULL) THEN
1812: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1813: gme_debug.put_line ( 'GET_MAX_STEP_DATE: from cursor'
1814: || TO_CHAR (l_date
1815: ,'DD-MON-YYYY HH24:MI:SS') );
1816: END IF;

Line 1813: gme_debug.put_line ( 'GET_MAX_STEP_DATE: from cursor'

1809: INTO l_date;
1810:
1811: IF (cur_get_step_date%FOUND) AND (l_date IS NOT NULL) THEN
1812: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1813: gme_debug.put_line ( 'GET_MAX_STEP_DATE: from cursor'
1814: || TO_CHAR (l_date
1815: ,'DD-MON-YYYY HH24:MI:SS') );
1816: END IF;
1817:

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

1816: END IF;
1817:
1818: l_max_date := l_date;
1819: ELSE
1820: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1821: gme_debug.put_line ('No prior step here');
1822: END IF;
1823: END IF;
1824:

Line 1821: gme_debug.put_line ('No prior step here');

1817:
1818: l_max_date := l_date;
1819: ELSE
1820: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1821: gme_debug.put_line ('No prior step here');
1822: END IF;
1823: END IF;
1824:
1825: CLOSE cur_get_step_date;

Line 1832: IF g_debug <= gme_debug.g_log_procedure THEN

1828: IF l_max_date IS NULL THEN
1829: l_max_date := p_batch_start_date;
1830: END IF;
1831:
1832: IF g_debug <= gme_debug.g_log_procedure THEN
1833: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1834: END IF;
1835:
1836: RETURN l_max_date;

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

1829: l_max_date := p_batch_start_date;
1830: END IF;
1831:
1832: IF g_debug <= gme_debug.g_log_procedure THEN
1833: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1834: END IF;
1835:
1836: RETURN l_max_date;
1837: EXCEPTION

Line 1839: IF g_debug <= gme_debug.g_log_unexpected THEN

1835:
1836: RETURN l_max_date;
1837: EXCEPTION
1838: WHEN OTHERS THEN
1839: IF g_debug <= gme_debug.g_log_unexpected THEN
1840: gme_debug.put_line ( 'When others exception in '
1841: || g_pkg_name
1842: || '.'
1843: || l_api_name

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

1836: RETURN l_max_date;
1837: EXCEPTION
1838: WHEN OTHERS THEN
1839: IF g_debug <= gme_debug.g_log_unexpected THEN
1840: gme_debug.put_line ( 'When others exception in '
1841: || g_pkg_name
1842: || '.'
1843: || l_api_name
1844: || ' Error is '

Line 1884: IF g_debug <= gme_debug.g_log_procedure THEN

1880: l_cal_count NUMBER;
1881: l_return_status VARCHAR2 (1);
1882: l_api_name CONSTANT VARCHAR2 (30) := 'get_working_time';
1883: BEGIN
1884: IF g_debug <= gme_debug.g_log_procedure THEN
1885: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1886: || l_api_name);
1887: END IF;
1888:

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

1881: l_return_status VARCHAR2 (1);
1882: l_api_name CONSTANT VARCHAR2 (30) := 'get_working_time';
1883: BEGIN
1884: IF g_debug <= gme_debug.g_log_procedure THEN
1885: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1886: || l_api_name);
1887: END IF;
1888:
1889: IF p_start_date IS NULL THEN

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

1890: RETURN NULL;
1891: END IF;
1892:
1893: IF p_offset >= 0 THEN
1894: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1895: gme_debug.put_line ('calling get_contiguous_periods from point 1 get_working_time'); -- Bug 13582990
1896: gme_debug.put_line ('start date passed in is '||TO_CHAR(p_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1897: gme_debug.put_line ('duration passed in is '||p_offset); -- Bug 13582990
1898: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990

Line 1895: gme_debug.put_line ('calling get_contiguous_periods from point 1 get_working_time'); -- Bug 13582990

1891: END IF;
1892:
1893: IF p_offset >= 0 THEN
1894: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1895: gme_debug.put_line ('calling get_contiguous_periods from point 1 get_working_time'); -- Bug 13582990
1896: gme_debug.put_line ('start date passed in is '||TO_CHAR(p_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1897: gme_debug.put_line ('duration passed in is '||p_offset); -- Bug 13582990
1898: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1899: END IF;

Line 1896: gme_debug.put_line ('start date passed in is '||TO_CHAR(p_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990

1892:
1893: IF p_offset >= 0 THEN
1894: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1895: gme_debug.put_line ('calling get_contiguous_periods from point 1 get_working_time'); -- Bug 13582990
1896: gme_debug.put_line ('start date passed in is '||TO_CHAR(p_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1897: gme_debug.put_line ('duration passed in is '||p_offset); -- Bug 13582990
1898: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1899: END IF;
1900: gmp_calendar_api.get_contiguous_periods

Line 1897: gme_debug.put_line ('duration passed in is '||p_offset); -- Bug 13582990

1893: IF p_offset >= 0 THEN
1894: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1895: gme_debug.put_line ('calling get_contiguous_periods from point 1 get_working_time'); -- Bug 13582990
1896: gme_debug.put_line ('start date passed in is '||TO_CHAR(p_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1897: gme_debug.put_line ('duration passed in is '||p_offset); -- Bug 13582990
1898: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1899: END IF;
1900: gmp_calendar_api.get_contiguous_periods
1901: (p_api_version => 1

Line 1898: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990

1894: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1895: gme_debug.put_line ('calling get_contiguous_periods from point 1 get_working_time'); -- Bug 13582990
1896: gme_debug.put_line ('start date passed in is '||TO_CHAR(p_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1897: gme_debug.put_line ('duration passed in is '||p_offset); -- Bug 13582990
1898: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1899: END IF;
1900: gmp_calendar_api.get_contiguous_periods
1901: (p_api_version => 1
1902: ,p_init_msg_list => TRUE

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

1913:
1914: l_cal_count := l_contig_period_tbl.COUNT;
1915: l_start_date := l_contig_period_tbl (l_cal_count).end_date;
1916:
1917: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1918: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
1919: END IF;
1920: ELSE /* p_offset >= 0 */
1921: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

Line 1918: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990

1914: l_cal_count := l_contig_period_tbl.COUNT;
1915: l_start_date := l_contig_period_tbl (l_cal_count).end_date;
1916:
1917: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1918: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
1919: END IF;
1920: ELSE /* p_offset >= 0 */
1921: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1922: gme_debug.put_line ('calling get_contiguous_periods from point 2 get_working_time'); -- Bug 13582990

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

1917: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1918: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
1919: END IF;
1920: ELSE /* p_offset >= 0 */
1921: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1922: gme_debug.put_line ('calling get_contiguous_periods from point 2 get_working_time'); -- Bug 13582990
1923: gme_debug.put_line ('END date passed in is '||TO_CHAR(p_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1924: gme_debug.put_line ('duration passed in is '||ABS(p_offset)); -- Bug 13582990
1925: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990

Line 1922: gme_debug.put_line ('calling get_contiguous_periods from point 2 get_working_time'); -- Bug 13582990

1918: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
1919: END IF;
1920: ELSE /* p_offset >= 0 */
1921: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1922: gme_debug.put_line ('calling get_contiguous_periods from point 2 get_working_time'); -- Bug 13582990
1923: gme_debug.put_line ('END date passed in is '||TO_CHAR(p_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1924: gme_debug.put_line ('duration passed in is '||ABS(p_offset)); -- Bug 13582990
1925: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1926: END IF;

Line 1923: gme_debug.put_line ('END date passed in is '||TO_CHAR(p_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990

1919: END IF;
1920: ELSE /* p_offset >= 0 */
1921: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1922: gme_debug.put_line ('calling get_contiguous_periods from point 2 get_working_time'); -- Bug 13582990
1923: gme_debug.put_line ('END date passed in is '||TO_CHAR(p_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1924: gme_debug.put_line ('duration passed in is '||ABS(p_offset)); -- Bug 13582990
1925: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1926: END IF;
1927: gmp_calendar_api.get_contiguous_periods

Line 1924: gme_debug.put_line ('duration passed in is '||ABS(p_offset)); -- Bug 13582990

1920: ELSE /* p_offset >= 0 */
1921: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1922: gme_debug.put_line ('calling get_contiguous_periods from point 2 get_working_time'); -- Bug 13582990
1923: gme_debug.put_line ('END date passed in is '||TO_CHAR(p_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1924: gme_debug.put_line ('duration passed in is '||ABS(p_offset)); -- Bug 13582990
1925: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1926: END IF;
1927: gmp_calendar_api.get_contiguous_periods
1928: (p_api_version => 1

Line 1925: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990

1921: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1922: gme_debug.put_line ('calling get_contiguous_periods from point 2 get_working_time'); -- Bug 13582990
1923: gme_debug.put_line ('END date passed in is '||TO_CHAR(p_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1924: gme_debug.put_line ('duration passed in is '||ABS(p_offset)); -- Bug 13582990
1925: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1926: END IF;
1927: gmp_calendar_api.get_contiguous_periods
1928: (p_api_version => 1
1929: ,p_init_msg_list => TRUE

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

1940:
1941: l_cal_count := l_contig_period_tbl.COUNT;
1942: l_start_date := l_contig_period_tbl (l_cal_count).start_date;
1943:
1944: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1945: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
1946: END IF;
1947: END IF; /* p_offset >= 0 */
1948:

Line 1945: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990

1941: l_cal_count := l_contig_period_tbl.COUNT;
1942: l_start_date := l_contig_period_tbl (l_cal_count).start_date;
1943:
1944: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1945: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
1946: END IF;
1947: END IF; /* p_offset >= 0 */
1948:
1949: IF gmp_calendar_api.is_working_daytime

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

1956: RETURN l_start_date;
1957: ELSE /* gmp_calendar_api.is_working_daytime */
1958: l_diff := 1 / 3600;
1959:
1960: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1961: gme_debug.put_line (l_api_name || ':l_diff ' || l_diff);
1962: END IF;
1963:
1964: IF p_offset > 0 THEN

Line 1961: gme_debug.put_line (l_api_name || ':l_diff ' || l_diff);

1957: ELSE /* gmp_calendar_api.is_working_daytime */
1958: l_diff := 1 / 3600;
1959:
1960: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1961: gme_debug.put_line (l_api_name || ':l_diff ' || l_diff);
1962: END IF;
1963:
1964: IF p_offset > 0 THEN
1965: /* If offset was 0 then the l_start_date is the working date time */

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

1962: END IF;
1963:
1964: IF p_offset > 0 THEN
1965: /* If offset was 0 then the l_start_date is the working date time */
1966: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1967: gme_debug.put_line ('calling get_contiguous_periods from point 3 get_working_time'); -- Bug 13582990
1968: gme_debug.put_line ('start date passed in is '||TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1969: gme_debug.put_line ('duration passed in is '||l_diff); -- Bug 13582990
1970: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990

Line 1967: gme_debug.put_line ('calling get_contiguous_periods from point 3 get_working_time'); -- Bug 13582990

1963:
1964: IF p_offset > 0 THEN
1965: /* If offset was 0 then the l_start_date is the working date time */
1966: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1967: gme_debug.put_line ('calling get_contiguous_periods from point 3 get_working_time'); -- Bug 13582990
1968: gme_debug.put_line ('start date passed in is '||TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1969: gme_debug.put_line ('duration passed in is '||l_diff); -- Bug 13582990
1970: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1971: END IF;

Line 1968: gme_debug.put_line ('start date passed in is '||TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990

1964: IF p_offset > 0 THEN
1965: /* If offset was 0 then the l_start_date is the working date time */
1966: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1967: gme_debug.put_line ('calling get_contiguous_periods from point 3 get_working_time'); -- Bug 13582990
1968: gme_debug.put_line ('start date passed in is '||TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1969: gme_debug.put_line ('duration passed in is '||l_diff); -- Bug 13582990
1970: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1971: END IF;
1972: gmp_calendar_api.get_contiguous_periods

Line 1969: gme_debug.put_line ('duration passed in is '||l_diff); -- Bug 13582990

1965: /* If offset was 0 then the l_start_date is the working date time */
1966: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1967: gme_debug.put_line ('calling get_contiguous_periods from point 3 get_working_time'); -- Bug 13582990
1968: gme_debug.put_line ('start date passed in is '||TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1969: gme_debug.put_line ('duration passed in is '||l_diff); -- Bug 13582990
1970: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1971: END IF;
1972: gmp_calendar_api.get_contiguous_periods
1973: (p_api_version => 1

Line 1970: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990

1966: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1967: gme_debug.put_line ('calling get_contiguous_periods from point 3 get_working_time'); -- Bug 13582990
1968: gme_debug.put_line ('start date passed in is '||TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1969: gme_debug.put_line ('duration passed in is '||l_diff); -- Bug 13582990
1970: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1971: END IF;
1972: gmp_calendar_api.get_contiguous_periods
1973: (p_api_version => 1
1974: ,p_init_msg_list => TRUE

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

1986: l_cal_count := l_contig_period_tbl.COUNT;
1987: l_start_date :=
1988: (l_contig_period_tbl (l_cal_count).end_date - (l_diff / 24) );
1989:
1990: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1991: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
1992: END IF;
1993: ELSE /* p_offset > 0 */
1994: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

Line 1991: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990

1987: l_start_date :=
1988: (l_contig_period_tbl (l_cal_count).end_date - (l_diff / 24) );
1989:
1990: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1991: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
1992: END IF;
1993: ELSE /* p_offset > 0 */
1994: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1995: gme_debug.put_line ('calling get_contiguous_periods from point 4 get_working_time'); -- Bug 13582990

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

1990: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1991: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
1992: END IF;
1993: ELSE /* p_offset > 0 */
1994: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1995: gme_debug.put_line ('calling get_contiguous_periods from point 4 get_working_time'); -- Bug 13582990
1996: gme_debug.put_line ('END date passed in is '||TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1997: gme_debug.put_line ('duration passed in is '||l_diff); -- Bug 13582990
1998: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990

Line 1995: gme_debug.put_line ('calling get_contiguous_periods from point 4 get_working_time'); -- Bug 13582990

1991: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
1992: END IF;
1993: ELSE /* p_offset > 0 */
1994: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1995: gme_debug.put_line ('calling get_contiguous_periods from point 4 get_working_time'); -- Bug 13582990
1996: gme_debug.put_line ('END date passed in is '||TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1997: gme_debug.put_line ('duration passed in is '||l_diff); -- Bug 13582990
1998: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1999: END IF;

Line 1996: gme_debug.put_line ('END date passed in is '||TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990

1992: END IF;
1993: ELSE /* p_offset > 0 */
1994: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1995: gme_debug.put_line ('calling get_contiguous_periods from point 4 get_working_time'); -- Bug 13582990
1996: gme_debug.put_line ('END date passed in is '||TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1997: gme_debug.put_line ('duration passed in is '||l_diff); -- Bug 13582990
1998: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1999: END IF;
2000: gmp_calendar_api.get_contiguous_periods

Line 1997: gme_debug.put_line ('duration passed in is '||l_diff); -- Bug 13582990

1993: ELSE /* p_offset > 0 */
1994: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1995: gme_debug.put_line ('calling get_contiguous_periods from point 4 get_working_time'); -- Bug 13582990
1996: gme_debug.put_line ('END date passed in is '||TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1997: gme_debug.put_line ('duration passed in is '||l_diff); -- Bug 13582990
1998: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1999: END IF;
2000: gmp_calendar_api.get_contiguous_periods
2001: (p_api_version => 1

Line 1998: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990

1994: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1995: gme_debug.put_line ('calling get_contiguous_periods from point 4 get_working_time'); -- Bug 13582990
1996: gme_debug.put_line ('END date passed in is '||TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1997: gme_debug.put_line ('duration passed in is '||l_diff); -- Bug 13582990
1998: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1999: END IF;
2000: gmp_calendar_api.get_contiguous_periods
2001: (p_api_version => 1
2002: ,p_init_msg_list => TRUE

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

2014: l_cal_count := l_contig_period_tbl.COUNT;
2015: l_start_date :=
2016: (l_contig_period_tbl (l_cal_count).start_date + (l_diff / 24) );
2017:
2018: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2019: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2020: END IF;
2021: END IF; /* p_offset > 0 */
2022: END IF; /* gmp_calendar_api.is_working_daytime */

Line 2019: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990

2015: l_start_date :=
2016: (l_contig_period_tbl (l_cal_count).start_date + (l_diff / 24) );
2017:
2018: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2019: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2020: END IF;
2021: END IF; /* p_offset > 0 */
2022: END IF; /* gmp_calendar_api.is_working_daytime */
2023:

Line 2024: IF g_debug <= gme_debug.g_log_procedure THEN

2020: END IF;
2021: END IF; /* p_offset > 0 */
2022: END IF; /* gmp_calendar_api.is_working_daytime */
2023:
2024: IF g_debug <= gme_debug.g_log_procedure THEN
2025: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2026: END IF;
2027:
2028: RETURN l_start_date;

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

2021: END IF; /* p_offset > 0 */
2022: END IF; /* gmp_calendar_api.is_working_daytime */
2023:
2024: IF g_debug <= gme_debug.g_log_procedure THEN
2025: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2026: END IF;
2027:
2028: RETURN l_start_date;
2029: EXCEPTION

Line 2031: IF g_debug <= gme_debug.g_log_unexpected THEN

2027:
2028: RETURN l_start_date;
2029: EXCEPTION
2030: WHEN OTHERS THEN
2031: IF g_debug <= gme_debug.g_log_unexpected THEN
2032: gme_debug.put_line ( 'When others exception in '
2033: || g_pkg_name
2034: || '.'
2035: || l_api_name

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

2028: RETURN l_start_date;
2029: EXCEPTION
2030: WHEN OTHERS THEN
2031: IF g_debug <= gme_debug.g_log_unexpected THEN
2032: gme_debug.put_line ( 'When others exception in '
2033: || g_pkg_name
2034: || '.'
2035: || l_api_name
2036: || ' Error is '

Line 2147: IF g_debug <= gme_debug.g_log_procedure THEN

2143: l_cont_ind NUMBER;
2144: l_item_id NUMBER;
2145: l_use_workday_cal VARCHAR2 (5);
2146: BEGIN
2147: IF g_debug <= gme_debug.g_log_procedure THEN
2148: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2149: || l_api_name);
2150: END IF;
2151:

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

2144: l_item_id NUMBER;
2145: l_use_workday_cal VARCHAR2 (5);
2146: BEGIN
2147: IF g_debug <= gme_debug.g_log_procedure THEN
2148: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2149: || l_api_name);
2150: END IF;
2151:
2152: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

2148: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2149: || l_api_name);
2150: END IF;
2151:
2152: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2153: gme_debug.put_line ('start calc_dates');
2154: gme_debug.put_line ('p_step_id is '||p_step_id); -- Bug 13582990
2155: gme_debug.put_line ('p_use_workday_cal is '||p_use_workday_cal); -- Bug 13582990
2156: gme_debug.put_line ('p_contiguity_override is '||p_contiguity_override); -- Bug 13582990

Line 2153: gme_debug.put_line ('start calc_dates');

2149: || l_api_name);
2150: END IF;
2151:
2152: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2153: gme_debug.put_line ('start calc_dates');
2154: gme_debug.put_line ('p_step_id is '||p_step_id); -- Bug 13582990
2155: gme_debug.put_line ('p_use_workday_cal is '||p_use_workday_cal); -- Bug 13582990
2156: gme_debug.put_line ('p_contiguity_override is '||p_contiguity_override); -- Bug 13582990
2157: END IF;

Line 2154: gme_debug.put_line ('p_step_id is '||p_step_id); -- Bug 13582990

2150: END IF;
2151:
2152: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2153: gme_debug.put_line ('start calc_dates');
2154: gme_debug.put_line ('p_step_id is '||p_step_id); -- Bug 13582990
2155: gme_debug.put_line ('p_use_workday_cal is '||p_use_workday_cal); -- Bug 13582990
2156: gme_debug.put_line ('p_contiguity_override is '||p_contiguity_override); -- Bug 13582990
2157: END IF;
2158:

Line 2155: gme_debug.put_line ('p_use_workday_cal is '||p_use_workday_cal); -- Bug 13582990

2151:
2152: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2153: gme_debug.put_line ('start calc_dates');
2154: gme_debug.put_line ('p_step_id is '||p_step_id); -- Bug 13582990
2155: gme_debug.put_line ('p_use_workday_cal is '||p_use_workday_cal); -- Bug 13582990
2156: gme_debug.put_line ('p_contiguity_override is '||p_contiguity_override); -- Bug 13582990
2157: END IF;
2158:
2159: p_return_status := fnd_api.g_ret_sts_success;

Line 2156: gme_debug.put_line ('p_contiguity_override is '||p_contiguity_override); -- Bug 13582990

2152: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2153: gme_debug.put_line ('start calc_dates');
2154: gme_debug.put_line ('p_step_id is '||p_step_id); -- Bug 13582990
2155: gme_debug.put_line ('p_use_workday_cal is '||p_use_workday_cal); -- Bug 13582990
2156: gme_debug.put_line ('p_contiguity_override is '||p_contiguity_override); -- Bug 13582990
2157: END IF;
2158:
2159: p_return_status := fnd_api.g_ret_sts_success;
2160: l_batch_id := p_gme_batch_header_rec.batch_id;

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

2166: END IF;
2167:
2168: l_use_workday_cal := p_use_workday_cal;
2169:
2170: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2171: gme_debug.put_line ('batch_id=' || l_batch_id);
2172: END IF;
2173:
2174: l_calendar_code := gme_common_pvt.g_calendar_code;

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

2167:
2168: l_use_workday_cal := p_use_workday_cal;
2169:
2170: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2171: gme_debug.put_line ('batch_id=' || l_batch_id);
2172: END IF;
2173:
2174: l_calendar_code := gme_common_pvt.g_calendar_code;
2175:

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

2187: l_cont_ind := 1;
2188: --Assigning hard coded value now have to use GMD api
2189: END IF;
2190:
2191: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2192: gme_debug.put_line ('cal code is '||l_calendar_code); -- Bug 13582990
2193: END IF;
2194:
2195: /* If P_step_id is NULL, this means we want to process all steps in the batch. If */

Line 2192: gme_debug.put_line ('cal code is '||l_calendar_code); -- Bug 13582990

2188: --Assigning hard coded value now have to use GMD api
2189: END IF;
2190:
2191: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2192: gme_debug.put_line ('cal code is '||l_calendar_code); -- Bug 13582990
2193: END IF;
2194:
2195: /* If P_step_id is NULL, this means we want to process all steps in the batch. If */
2196: /* it is not NULL, then we only want to calc the dates for that step, i.e. insert_step... */

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

2226: END IF;
2227:
2228: -- Calculate the duration of each step...
2229: FOR i IN x_step_tbl.FIRST .. x_step_tbl.LAST LOOP
2230: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2231: gme_debug.put_line ('step_no ' || x_gmd_step_tbl (i).step_no);
2232: gme_debug.put_line ('step_id ' || x_gmd_step_tbl (i).step_id);
2233: END IF;
2234:

Line 2231: gme_debug.put_line ('step_no ' || x_gmd_step_tbl (i).step_no);

2227:
2228: -- Calculate the duration of each step...
2229: FOR i IN x_step_tbl.FIRST .. x_step_tbl.LAST LOOP
2230: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2231: gme_debug.put_line ('step_no ' || x_gmd_step_tbl (i).step_no);
2232: gme_debug.put_line ('step_id ' || x_gmd_step_tbl (i).step_id);
2233: END IF;
2234:
2235: l_step_duration_tab (x_gmd_step_tbl (i).step_no) :=

Line 2232: gme_debug.put_line ('step_id ' || x_gmd_step_tbl (i).step_id);

2228: -- Calculate the duration of each step...
2229: FOR i IN x_step_tbl.FIRST .. x_step_tbl.LAST LOOP
2230: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2231: gme_debug.put_line ('step_no ' || x_gmd_step_tbl (i).step_no);
2232: gme_debug.put_line ('step_id ' || x_gmd_step_tbl (i).step_id);
2233: END IF;
2234:
2235: l_step_duration_tab (x_gmd_step_tbl (i).step_no) :=
2236: get_max_duration (x_step_tbl (i), l_batch_id);

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

2234:
2235: l_step_duration_tab (x_gmd_step_tbl (i).step_no) :=
2236: get_max_duration (x_step_tbl (i), l_batch_id);
2237:
2238: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2239: gme_debug.put_line
2240: ( 'stepduration '
2241: || l_step_duration_tab
2242: (x_gmd_step_tbl (i).step_no) );

Line 2239: gme_debug.put_line

2235: l_step_duration_tab (x_gmd_step_tbl (i).step_no) :=
2236: get_max_duration (x_step_tbl (i), l_batch_id);
2237:
2238: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2239: gme_debug.put_line
2240: ( 'stepduration '
2241: || l_step_duration_tab
2242: (x_gmd_step_tbl (i).step_no) );
2243: END IF;

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

2256: FROM gme_batch_steps
2257: WHERE batchstep_id = p_step_id;
2258:
2259: IF l_use_workday_cal = fnd_api.g_true THEN
2260: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2261: gme_debug.put_line ('calling get_contiguous_periods from point 1 calc_dates'); -- Bug 13582990
2262: gme_debug.put_line ('plan_cmplt date is not null used for END DATE parm is '||
2263: TO_CHAR(p_plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
2264: gme_debug.put_line ('duration passed in is '||l_step_duration_tab(x_step_no)); -- Bug 13582990

Line 2261: gme_debug.put_line ('calling get_contiguous_periods from point 1 calc_dates'); -- Bug 13582990

2257: WHERE batchstep_id = p_step_id;
2258:
2259: IF l_use_workday_cal = fnd_api.g_true THEN
2260: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2261: gme_debug.put_line ('calling get_contiguous_periods from point 1 calc_dates'); -- Bug 13582990
2262: gme_debug.put_line ('plan_cmplt date is not null used for END DATE parm is '||
2263: TO_CHAR(p_plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
2264: gme_debug.put_line ('duration passed in is '||l_step_duration_tab(x_step_no)); -- Bug 13582990
2265: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990

Line 2262: gme_debug.put_line ('plan_cmplt date is not null used for END DATE parm is '||

2258:
2259: IF l_use_workday_cal = fnd_api.g_true THEN
2260: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2261: gme_debug.put_line ('calling get_contiguous_periods from point 1 calc_dates'); -- Bug 13582990
2262: gme_debug.put_line ('plan_cmplt date is not null used for END DATE parm is '||
2263: TO_CHAR(p_plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
2264: gme_debug.put_line ('duration passed in is '||l_step_duration_tab(x_step_no)); -- Bug 13582990
2265: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2266: END IF;

Line 2264: gme_debug.put_line ('duration passed in is '||l_step_duration_tab(x_step_no)); -- Bug 13582990

2260: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2261: gme_debug.put_line ('calling get_contiguous_periods from point 1 calc_dates'); -- Bug 13582990
2262: gme_debug.put_line ('plan_cmplt date is not null used for END DATE parm is '||
2263: TO_CHAR(p_plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
2264: gme_debug.put_line ('duration passed in is '||l_step_duration_tab(x_step_no)); -- Bug 13582990
2265: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2266: END IF;
2267:
2268: gmp_calendar_api.get_contiguous_periods

Line 2265: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990

2261: gme_debug.put_line ('calling get_contiguous_periods from point 1 calc_dates'); -- Bug 13582990
2262: gme_debug.put_line ('plan_cmplt date is not null used for END DATE parm is '||
2263: TO_CHAR(p_plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
2264: gme_debug.put_line ('duration passed in is '||l_step_duration_tab(x_step_no)); -- Bug 13582990
2265: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2266: END IF;
2267:
2268: gmp_calendar_api.get_contiguous_periods
2269: (p_api_version => 1

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

2280: END IF;
2281:
2282: l_cal_count := l_contig_period_tbl.COUNT;
2283:
2284: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2285: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2286: END IF;
2287:
2288: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN

Line 2285: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990

2281:
2282: l_cal_count := l_contig_period_tbl.COUNT;
2283:
2284: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2285: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2286: END IF;
2287:
2288: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN
2289: IF l_cal_count > 1 THEN

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

2298: p_plan_cmplt_date - l_step_duration_tab (x_step_no)
2299: / 24;
2300: END IF;
2301:
2302: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2303: gme_debug.put_line ( 'calculated step start date is '
2304: || TO_CHAR (x_step_start_date
2305: ,'DD-MON-YYYY HH24:MI:SS') );
2306: END IF;

Line 2303: gme_debug.put_line ( 'calculated step start date is '

2299: / 24;
2300: END IF;
2301:
2302: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2303: gme_debug.put_line ( 'calculated step start date is '
2304: || TO_CHAR (x_step_start_date
2305: ,'DD-MON-YYYY HH24:MI:SS') );
2306: END IF;
2307: END IF;

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

2312: ,x_batch_duration
2313: ,l_return_status);
2314:
2315: IF l_use_workday_cal = fnd_api.g_true THEN
2316: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2317: gme_debug.put_line ('calling get_contiguous_periods from point 2 calc_dates'); -- Bug 13582990
2318: gme_debug.put_line ('start date is not null used for START DATE parm is '||
2319: TO_CHAR(p_gme_batch_header_rec.plan_start_date,'DD-MON-YYYY HH24:MI:SS'));
2320: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990

Line 2317: gme_debug.put_line ('calling get_contiguous_periods from point 2 calc_dates'); -- Bug 13582990

2313: ,l_return_status);
2314:
2315: IF l_use_workday_cal = fnd_api.g_true THEN
2316: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2317: gme_debug.put_line ('calling get_contiguous_periods from point 2 calc_dates'); -- Bug 13582990
2318: gme_debug.put_line ('start date is not null used for START DATE parm is '||
2319: TO_CHAR(p_gme_batch_header_rec.plan_start_date,'DD-MON-YYYY HH24:MI:SS'));
2320: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990
2321: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990

Line 2318: gme_debug.put_line ('start date is not null used for START DATE parm is '||

2314:
2315: IF l_use_workday_cal = fnd_api.g_true THEN
2316: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2317: gme_debug.put_line ('calling get_contiguous_periods from point 2 calc_dates'); -- Bug 13582990
2318: gme_debug.put_line ('start date is not null used for START DATE parm is '||
2319: TO_CHAR(p_gme_batch_header_rec.plan_start_date,'DD-MON-YYYY HH24:MI:SS'));
2320: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990
2321: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2322: END IF;

Line 2320: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990

2316: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2317: gme_debug.put_line ('calling get_contiguous_periods from point 2 calc_dates'); -- Bug 13582990
2318: gme_debug.put_line ('start date is not null used for START DATE parm is '||
2319: TO_CHAR(p_gme_batch_header_rec.plan_start_date,'DD-MON-YYYY HH24:MI:SS'));
2320: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990
2321: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2322: END IF;
2323:
2324: gmp_calendar_api.get_contiguous_periods

Line 2321: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990

2317: gme_debug.put_line ('calling get_contiguous_periods from point 2 calc_dates'); -- Bug 13582990
2318: gme_debug.put_line ('start date is not null used for START DATE parm is '||
2319: TO_CHAR(p_gme_batch_header_rec.plan_start_date,'DD-MON-YYYY HH24:MI:SS'));
2320: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990
2321: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2322: END IF;
2323:
2324: gmp_calendar_api.get_contiguous_periods
2325: (p_api_version => 1

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

2336: END IF;
2337:
2338: l_cal_count := l_contig_period_tbl.COUNT;
2339:
2340: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2341: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2342: END IF;
2343:
2344: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN

Line 2341: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990

2337:
2338: l_cal_count := l_contig_period_tbl.COUNT;
2339:
2340: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2341: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2342: END IF;
2343:
2344: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN
2345: IF l_cal_count > 1 THEN

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

2356: ,l_step_duration_tab
2357: ,x_batch_duration
2358: ,l_return_status);
2359:
2360: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2361: gme_debug.put_line ('duration of batch is ' || x_batch_duration);
2362: gme_debug.put_line
2363: ( 'batch completion date is '
2364: || TO_CHAR

Line 2361: gme_debug.put_line ('duration of batch is ' || x_batch_duration);

2357: ,x_batch_duration
2358: ,l_return_status);
2359:
2360: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2361: gme_debug.put_line ('duration of batch is ' || x_batch_duration);
2362: gme_debug.put_line
2363: ( 'batch completion date is '
2364: || TO_CHAR
2365: (p_gme_batch_header_rec.plan_cmplt_date

Line 2362: gme_debug.put_line

2358: ,l_return_status);
2359:
2360: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2361: gme_debug.put_line ('duration of batch is ' || x_batch_duration);
2362: gme_debug.put_line
2363: ( 'batch completion date is '
2364: || TO_CHAR
2365: (p_gme_batch_header_rec.plan_cmplt_date
2366: ,'DD-MON-YYYY HH24:MI:SS') );

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

2366: ,'DD-MON-YYYY HH24:MI:SS') );
2367: END IF;
2368:
2369: IF l_use_workday_cal = fnd_api.g_true THEN
2370: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2371: gme_debug.put_line ('calling get_contiguous_periods from point 3 calc_dates'); -- Bug 13582990
2372: -- gme_debug.put_line ('end date null ' || l_use_workday_cal);
2373: gme_debug.put_line ('plan_cmplt_date is not null used for END DATE parm is '||
2374: TO_CHAR(p_gme_batch_header_rec.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));

Line 2371: gme_debug.put_line ('calling get_contiguous_periods from point 3 calc_dates'); -- Bug 13582990

2367: END IF;
2368:
2369: IF l_use_workday_cal = fnd_api.g_true THEN
2370: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2371: gme_debug.put_line ('calling get_contiguous_periods from point 3 calc_dates'); -- Bug 13582990
2372: -- gme_debug.put_line ('end date null ' || l_use_workday_cal);
2373: gme_debug.put_line ('plan_cmplt_date is not null used for END DATE parm is '||
2374: TO_CHAR(p_gme_batch_header_rec.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
2375: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990

Line 2372: -- gme_debug.put_line ('end date null ' || l_use_workday_cal);

2368:
2369: IF l_use_workday_cal = fnd_api.g_true THEN
2370: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2371: gme_debug.put_line ('calling get_contiguous_periods from point 3 calc_dates'); -- Bug 13582990
2372: -- gme_debug.put_line ('end date null ' || l_use_workday_cal);
2373: gme_debug.put_line ('plan_cmplt_date is not null used for END DATE parm is '||
2374: TO_CHAR(p_gme_batch_header_rec.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
2375: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990
2376: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990

Line 2373: gme_debug.put_line ('plan_cmplt_date is not null used for END DATE parm is '||

2369: IF l_use_workday_cal = fnd_api.g_true THEN
2370: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2371: gme_debug.put_line ('calling get_contiguous_periods from point 3 calc_dates'); -- Bug 13582990
2372: -- gme_debug.put_line ('end date null ' || l_use_workday_cal);
2373: gme_debug.put_line ('plan_cmplt_date is not null used for END DATE parm is '||
2374: TO_CHAR(p_gme_batch_header_rec.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
2375: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990
2376: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2377: END IF;

Line 2375: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990

2371: gme_debug.put_line ('calling get_contiguous_periods from point 3 calc_dates'); -- Bug 13582990
2372: -- gme_debug.put_line ('end date null ' || l_use_workday_cal);
2373: gme_debug.put_line ('plan_cmplt_date is not null used for END DATE parm is '||
2374: TO_CHAR(p_gme_batch_header_rec.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
2375: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990
2376: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2377: END IF;
2378:
2379: gmp_calendar_api.get_contiguous_periods

Line 2376: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990

2372: -- gme_debug.put_line ('end date null ' || l_use_workday_cal);
2373: gme_debug.put_line ('plan_cmplt_date is not null used for END DATE parm is '||
2374: TO_CHAR(p_gme_batch_header_rec.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
2375: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990
2376: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2377: END IF;
2378:
2379: gmp_calendar_api.get_contiguous_periods
2380: (p_api_version => 1

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

2391: END IF;
2392:
2393: l_cal_count := l_contig_period_tbl.COUNT;
2394:
2395: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2396: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2397: END IF;
2398:
2399: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN

Line 2396: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990

2392:
2393: l_cal_count := l_contig_period_tbl.COUNT;
2394:
2395: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2396: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2397: END IF;
2398:
2399: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN
2400: IF l_cal_count > 1 THEN

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

2409: p_gme_batch_header_rec.plan_cmplt_date
2410: - x_batch_duration / 24;
2411: END IF;
2412:
2413: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2414: gme_debug.put_line ( 'calculated batch start date is '
2415: || TO_CHAR (x_batch_start_date
2416: ,'DD-MON-YYYY HH24:MI:SS') );
2417: END IF;

Line 2414: gme_debug.put_line ( 'calculated batch start date is '

2410: - x_batch_duration / 24;
2411: END IF;
2412:
2413: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2414: gme_debug.put_line ( 'calculated batch start date is '
2415: || TO_CHAR (x_batch_start_date
2416: ,'DD-MON-YYYY HH24:MI:SS') );
2417: END IF;
2418: ELSIF (p_gme_batch_header_rec.plan_start_date IS NULL)

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

2422: ,x_batch_duration
2423: ,l_return_status);
2424:
2425: IF l_use_workday_cal = fnd_api.g_true THEN
2426: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2427: gme_debug.put_line ('calling get_contiguous_periods from point 4 calc_dates'); -- Bug 13582990
2428: gme_debug.put_line ('Both dates null. p_contiguity_override is '|| p_contiguity_override); -- Bug 13582990
2429: gme_debug.put_line ('batch completion is '||
2430: TO_CHAR(p_gme_batch_header_rec.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990

Line 2427: gme_debug.put_line ('calling get_contiguous_periods from point 4 calc_dates'); -- Bug 13582990

2423: ,l_return_status);
2424:
2425: IF l_use_workday_cal = fnd_api.g_true THEN
2426: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2427: gme_debug.put_line ('calling get_contiguous_periods from point 4 calc_dates'); -- Bug 13582990
2428: gme_debug.put_line ('Both dates null. p_contiguity_override is '|| p_contiguity_override); -- Bug 13582990
2429: gme_debug.put_line ('batch completion is '||
2430: TO_CHAR(p_gme_batch_header_rec.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2431: gme_debug.put_line ('start date passed in gme_common_pvt.g_timestamp is '||

Line 2428: gme_debug.put_line ('Both dates null. p_contiguity_override is '|| p_contiguity_override); -- Bug 13582990

2424:
2425: IF l_use_workday_cal = fnd_api.g_true THEN
2426: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2427: gme_debug.put_line ('calling get_contiguous_periods from point 4 calc_dates'); -- Bug 13582990
2428: gme_debug.put_line ('Both dates null. p_contiguity_override is '|| p_contiguity_override); -- Bug 13582990
2429: gme_debug.put_line ('batch completion is '||
2430: TO_CHAR(p_gme_batch_header_rec.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2431: gme_debug.put_line ('start date passed in gme_common_pvt.g_timestamp is '||
2432: TO_CHAR(gme_common_pvt.g_timestamp,'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990

Line 2429: gme_debug.put_line ('batch completion is '||

2425: IF l_use_workday_cal = fnd_api.g_true THEN
2426: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2427: gme_debug.put_line ('calling get_contiguous_periods from point 4 calc_dates'); -- Bug 13582990
2428: gme_debug.put_line ('Both dates null. p_contiguity_override is '|| p_contiguity_override); -- Bug 13582990
2429: gme_debug.put_line ('batch completion is '||
2430: TO_CHAR(p_gme_batch_header_rec.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2431: gme_debug.put_line ('start date passed in gme_common_pvt.g_timestamp is '||
2432: TO_CHAR(gme_common_pvt.g_timestamp,'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2433: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990

Line 2431: gme_debug.put_line ('start date passed in gme_common_pvt.g_timestamp is '||

2427: gme_debug.put_line ('calling get_contiguous_periods from point 4 calc_dates'); -- Bug 13582990
2428: gme_debug.put_line ('Both dates null. p_contiguity_override is '|| p_contiguity_override); -- Bug 13582990
2429: gme_debug.put_line ('batch completion is '||
2430: TO_CHAR(p_gme_batch_header_rec.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2431: gme_debug.put_line ('start date passed in gme_common_pvt.g_timestamp is '||
2432: TO_CHAR(gme_common_pvt.g_timestamp,'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2433: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990
2434: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2435: END IF;

Line 2433: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990

2429: gme_debug.put_line ('batch completion is '||
2430: TO_CHAR(p_gme_batch_header_rec.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2431: gme_debug.put_line ('start date passed in gme_common_pvt.g_timestamp is '||
2432: TO_CHAR(gme_common_pvt.g_timestamp,'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2433: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990
2434: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2435: END IF;
2436:
2437: gmp_calendar_api.get_contiguous_periods

Line 2434: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990

2430: TO_CHAR(p_gme_batch_header_rec.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2431: gme_debug.put_line ('start date passed in gme_common_pvt.g_timestamp is '||
2432: TO_CHAR(gme_common_pvt.g_timestamp,'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2433: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990
2434: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2435: END IF;
2436:
2437: gmp_calendar_api.get_contiguous_periods
2438: (p_api_version => 1

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

2449: END IF;
2450:
2451: l_cal_count := l_contig_period_tbl.COUNT;
2452:
2453: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2454: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2455: END IF;
2456:
2457: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN

Line 2454: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990

2450:
2451: l_cal_count := l_contig_period_tbl.COUNT;
2452:
2453: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2454: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2455: END IF;
2456:
2457: IF l_cont_ind = 1 AND p_contiguity_override = fnd_api.g_false THEN
2458: IF l_cal_count > 1 THEN

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

2471: INTO x_step_row
2472: FROM gme_batch_steps
2473: WHERE batchstep_id = x_step_tbl(i);
2474:
2475: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2476: gme_debug.put_line ('step_no=' || x_step_row.batchstep_no); -- Bug 13582990
2477: gme_debug.put_line ('step_id=' || x_step_tbl(i) );
2478: END IF;
2479:

Line 2476: gme_debug.put_line ('step_no=' || x_step_row.batchstep_no); -- Bug 13582990

2472: FROM gme_batch_steps
2473: WHERE batchstep_id = x_step_tbl(i);
2474:
2475: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2476: gme_debug.put_line ('step_no=' || x_step_row.batchstep_no); -- Bug 13582990
2477: gme_debug.put_line ('step_id=' || x_step_tbl(i) );
2478: END IF;
2479:
2480: -- For individual steps you can pass in a plan_start date or use the setup data.

Line 2477: gme_debug.put_line ('step_id=' || x_step_tbl(i) );

2473: WHERE batchstep_id = x_step_tbl(i);
2474:
2475: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2476: gme_debug.put_line ('step_no=' || x_step_row.batchstep_no); -- Bug 13582990
2477: gme_debug.put_line ('step_id=' || x_step_tbl(i) );
2478: END IF;
2479:
2480: -- For individual steps you can pass in a plan_start date or use the setup data.
2481: IF (x_step_start_date IS NULL) THEN

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

2488: ELSE
2489: x_step_row.plan_start_date := x_step_start_date;
2490: END IF;
2491:
2492: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2493: gme_debug.put_line ( '1 '
2494: || TO_CHAR (x_step_row.plan_start_date
2495: ,'DD-MON-YYYY HH24:MI:SS') );
2496: END IF;

Line 2493: gme_debug.put_line ( '1 '

2489: x_step_row.plan_start_date := x_step_start_date;
2490: END IF;
2491:
2492: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2493: gme_debug.put_line ( '1 '
2494: || TO_CHAR (x_step_row.plan_start_date
2495: ,'DD-MON-YYYY HH24:MI:SS') );
2496: END IF;
2497:

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

2519: END IF;
2520:
2521: FOR j IN x_act_tab.FIRST .. x_act_tab.LAST LOOP
2522: IF l_use_workday_cal = fnd_api.g_true THEN
2523: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2524: gme_debug.put_line (' activity is '|| x_act_tab(j).activity);
2525: gme_debug.put_line (' step start date '
2526: || TO_CHAR (x_step_row.plan_start_date
2527: ,'DD-MON-YYYY HH24:MI:SS') );

Line 2524: gme_debug.put_line (' activity is '|| x_act_tab(j).activity);

2520:
2521: FOR j IN x_act_tab.FIRST .. x_act_tab.LAST LOOP
2522: IF l_use_workday_cal = fnd_api.g_true THEN
2523: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2524: gme_debug.put_line (' activity is '|| x_act_tab(j).activity);
2525: gme_debug.put_line (' step start date '
2526: || TO_CHAR (x_step_row.plan_start_date
2527: ,'DD-MON-YYYY HH24:MI:SS') );
2528: END IF;

Line 2525: gme_debug.put_line (' step start date '

2521: FOR j IN x_act_tab.FIRST .. x_act_tab.LAST LOOP
2522: IF l_use_workday_cal = fnd_api.g_true THEN
2523: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2524: gme_debug.put_line (' activity is '|| x_act_tab(j).activity);
2525: gme_debug.put_line (' step start date '
2526: || TO_CHAR (x_step_row.plan_start_date
2527: ,'DD-MON-YYYY HH24:MI:SS') );
2528: END IF;
2529:

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

2541: x_step_row.plan_start_date
2542: + x_act_tab (j).offset_interval / 24;
2543: END IF;
2544:
2545: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2546: gme_debug.put_line ('offset' || x_act_tab (j).offset_interval);
2547: gme_debug.put_line ( 'x_act_tab(j).plan_start_date '
2548: || TO_CHAR (x_act_tab (j).plan_start_date
2549: ,'DD-MON-YYYY HH24:MI:SS') );

Line 2546: gme_debug.put_line ('offset' || x_act_tab (j).offset_interval);

2542: + x_act_tab (j).offset_interval / 24;
2543: END IF;
2544:
2545: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2546: gme_debug.put_line ('offset' || x_act_tab (j).offset_interval);
2547: gme_debug.put_line ( 'x_act_tab(j).plan_start_date '
2548: || TO_CHAR (x_act_tab (j).plan_start_date
2549: ,'DD-MON-YYYY HH24:MI:SS') );
2550: END IF;

Line 2547: gme_debug.put_line ( 'x_act_tab(j).plan_start_date '

2543: END IF;
2544:
2545: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2546: gme_debug.put_line ('offset' || x_act_tab (j).offset_interval);
2547: gme_debug.put_line ( 'x_act_tab(j).plan_start_date '
2548: || TO_CHAR (x_act_tab (j).plan_start_date
2549: ,'DD-MON-YYYY HH24:MI:SS') );
2550: END IF;
2551:

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

2590: IF x_rsrc_tab (k).plan_start_date IS NULL THEN
2591: RAISE error_cont_period;
2592: END IF;
2593:
2594: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2595: gme_debug.put_line
2596: ( 'rsrc_start_date '
2597: || TO_CHAR
2598: (x_rsrc_tab (k).plan_start_date

Line 2595: gme_debug.put_line

2591: RAISE error_cont_period;
2592: END IF;
2593:
2594: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2595: gme_debug.put_line
2596: ( 'rsrc_start_date '
2597: || TO_CHAR
2598: (x_rsrc_tab (k).plan_start_date
2599: ,'DD-MON-YYYY HH24:MI:SS') );

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

2611: l_duration := l_usage_hrs / x_rsrc_tab (k).plan_rsrc_count;
2612:
2613: IF l_use_workday_cal = fnd_api.g_true
2614: AND l_calendar_code IS NOT NULL THEN
2615: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2616: gme_debug.put_line ('calling get_contiguous_periods from point 5 calc_dates'); -- Bug 13582990
2617: gme_debug.put_line ('start date passed in is '||
2618: TO_CHAR(x_rsrc_tab(k).plan_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2619: gme_debug.put_line ('duration passed in is '||l_duration); -- Bug 13582990

Line 2616: gme_debug.put_line ('calling get_contiguous_periods from point 5 calc_dates'); -- Bug 13582990

2612:
2613: IF l_use_workday_cal = fnd_api.g_true
2614: AND l_calendar_code IS NOT NULL THEN
2615: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2616: gme_debug.put_line ('calling get_contiguous_periods from point 5 calc_dates'); -- Bug 13582990
2617: gme_debug.put_line ('start date passed in is '||
2618: TO_CHAR(x_rsrc_tab(k).plan_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2619: gme_debug.put_line ('duration passed in is '||l_duration); -- Bug 13582990
2620: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990

Line 2617: gme_debug.put_line ('start date passed in is '||

2613: IF l_use_workday_cal = fnd_api.g_true
2614: AND l_calendar_code IS NOT NULL THEN
2615: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2616: gme_debug.put_line ('calling get_contiguous_periods from point 5 calc_dates'); -- Bug 13582990
2617: gme_debug.put_line ('start date passed in is '||
2618: TO_CHAR(x_rsrc_tab(k).plan_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2619: gme_debug.put_line ('duration passed in is '||l_duration); -- Bug 13582990
2620: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2621: END IF;

Line 2619: gme_debug.put_line ('duration passed in is '||l_duration); -- Bug 13582990

2615: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2616: gme_debug.put_line ('calling get_contiguous_periods from point 5 calc_dates'); -- Bug 13582990
2617: gme_debug.put_line ('start date passed in is '||
2618: TO_CHAR(x_rsrc_tab(k).plan_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2619: gme_debug.put_line ('duration passed in is '||l_duration); -- Bug 13582990
2620: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2621: END IF;
2622:
2623: gmp_calendar_api.get_contiguous_periods

Line 2620: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990

2616: gme_debug.put_line ('calling get_contiguous_periods from point 5 calc_dates'); -- Bug 13582990
2617: gme_debug.put_line ('start date passed in is '||
2618: TO_CHAR(x_rsrc_tab(k).plan_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2619: gme_debug.put_line ('duration passed in is '||l_duration); -- Bug 13582990
2620: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2621: END IF;
2622:
2623: gmp_calendar_api.get_contiguous_periods
2624: (p_api_version => 1

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

2641: END IF;
2642:
2643: l_cal_count := l_contig_period_tbl.COUNT;
2644:
2645: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2646: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2647: END IF;
2648:
2649: x_rsrc_tab (k).plan_cmplt_date :=

Line 2646: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990

2642:
2643: l_cal_count := l_contig_period_tbl.COUNT;
2644:
2645: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2646: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2647: END IF;
2648:
2649: x_rsrc_tab (k).plan_cmplt_date :=
2650: l_contig_period_tbl (l_cal_count).end_date;

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

2651:
2652: IF p_gme_batch_header_rec.update_inventory_ind = 'Y' THEN
2653: FOR m IN 1 .. l_cal_count LOOP
2654:
2655: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2656: gme_debug.put_line ('rsrc loop iteration is '||m); -- Bug 13582990
2657: gme_debug.put_line ('l_contig_period_tbl(m).start_date is '||
2658: TO_CHAR(l_contig_period_tbl(m).start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2659:

Line 2656: gme_debug.put_line ('rsrc loop iteration is '||m); -- Bug 13582990

2652: IF p_gme_batch_header_rec.update_inventory_ind = 'Y' THEN
2653: FOR m IN 1 .. l_cal_count LOOP
2654:
2655: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2656: gme_debug.put_line ('rsrc loop iteration is '||m); -- Bug 13582990
2657: gme_debug.put_line ('l_contig_period_tbl(m).start_date is '||
2658: TO_CHAR(l_contig_period_tbl(m).start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2659:
2660: gme_debug.put_line ('l_contig_period_tbl(m).end_date is '||

Line 2657: gme_debug.put_line ('l_contig_period_tbl(m).start_date is '||

2653: FOR m IN 1 .. l_cal_count LOOP
2654:
2655: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2656: gme_debug.put_line ('rsrc loop iteration is '||m); -- Bug 13582990
2657: gme_debug.put_line ('l_contig_period_tbl(m).start_date is '||
2658: TO_CHAR(l_contig_period_tbl(m).start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2659:
2660: gme_debug.put_line ('l_contig_period_tbl(m).end_date is '||
2661: TO_CHAR(l_contig_period_tbl(m).end_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990

Line 2660: gme_debug.put_line ('l_contig_period_tbl(m).end_date is '||

2656: gme_debug.put_line ('rsrc loop iteration is '||m); -- Bug 13582990
2657: gme_debug.put_line ('l_contig_period_tbl(m).start_date is '||
2658: TO_CHAR(l_contig_period_tbl(m).start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2659:
2660: gme_debug.put_line ('l_contig_period_tbl(m).end_date is '||
2661: TO_CHAR(l_contig_period_tbl(m).end_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
2662: END IF;
2663:
2664: x_rsrc_tab (k).plan_start_date :=

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

2696: END LOOP; /* FOR resources */
2697:
2698: x_act_tab (j).plan_cmplt_date := x_max_rsrc_date;
2699:
2700: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2701: gme_debug.put_line ( '2 '
2702: || TO_CHAR (x_act_tab (j).plan_cmplt_date
2703: ,'DD-MON-YYYY HH24:MI:SS') );
2704: END IF;

Line 2701: gme_debug.put_line ( '2 '

2697:
2698: x_act_tab (j).plan_cmplt_date := x_max_rsrc_date;
2699:
2700: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2701: gme_debug.put_line ( '2 '
2702: || TO_CHAR (x_act_tab (j).plan_cmplt_date
2703: ,'DD-MON-YYYY HH24:MI:SS') );
2704: END IF;
2705:

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

2719:
2720: x_step_row.plan_cmplt_date := x_max_act_date;
2721: x_step_row.due_date := x_step_row.plan_cmplt_date;
2722:
2723: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2724: gme_debug.put_line ( '1 '
2725: || TO_CHAR (x_step_row.plan_cmplt_date
2726: ,'DD-MON-YYYY HH24:MI:SS') );
2727: gme_debug.put_line ( 'due_date = '

Line 2724: gme_debug.put_line ( '1 '

2720: x_step_row.plan_cmplt_date := x_max_act_date;
2721: x_step_row.due_date := x_step_row.plan_cmplt_date;
2722:
2723: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2724: gme_debug.put_line ( '1 '
2725: || TO_CHAR (x_step_row.plan_cmplt_date
2726: ,'DD-MON-YYYY HH24:MI:SS') );
2727: gme_debug.put_line ( 'due_date = '
2728: || TO_CHAR (x_step_row.due_date

Line 2727: gme_debug.put_line ( 'due_date = '

2723: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2724: gme_debug.put_line ( '1 '
2725: || TO_CHAR (x_step_row.plan_cmplt_date
2726: ,'DD-MON-YYYY HH24:MI:SS') );
2727: gme_debug.put_line ( 'due_date = '
2728: || TO_CHAR (x_step_row.due_date
2729: ,'DD-MON-YYYY HH24:MI:SS') );
2730: END IF;
2731:

Line 2795: IF g_debug <= gme_debug.g_log_procedure THEN

2791: WHERE batch_id = l_batch_id
2792: AND due_date = gme_common_pvt.g_timestamp;
2793: END IF;
2794:
2795: IF g_debug <= gme_debug.g_log_procedure THEN
2796: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2797: END IF;
2798: EXCEPTION
2799: WHEN load_steps_failed THEN

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

2792: AND due_date = gme_common_pvt.g_timestamp;
2793: END IF;
2794:
2795: IF g_debug <= gme_debug.g_log_procedure THEN
2796: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2797: END IF;
2798: EXCEPTION
2799: WHEN load_steps_failed THEN
2800: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

2796: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2797: END IF;
2798: EXCEPTION
2799: WHEN load_steps_failed THEN
2800: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2801: gme_debug.put_line ('calc_dates... load_steps_failed');
2802: END IF;
2803:
2804: p_return_status := fnd_api.g_ret_sts_error;

Line 2801: gme_debug.put_line ('calc_dates... load_steps_failed');

2797: END IF;
2798: EXCEPTION
2799: WHEN load_steps_failed THEN
2800: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2801: gme_debug.put_line ('calc_dates... load_steps_failed');
2802: END IF;
2803:
2804: p_return_status := fnd_api.g_ret_sts_error;
2805: WHEN error_cont_period THEN

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

2802: END IF;
2803:
2804: p_return_status := fnd_api.g_ret_sts_error;
2805: WHEN error_cont_period THEN
2806: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2807: gme_debug.put_line ('Contiguity period ... _failed');
2808: END IF;
2809:
2810: p_return_status := l_return_status;

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

2803:
2804: p_return_status := fnd_api.g_ret_sts_error;
2805: WHEN error_cont_period THEN
2806: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2807: gme_debug.put_line ('Contiguity period ... _failed');
2808: END IF;
2809:
2810: p_return_status := l_return_status;
2811: WHEN error_non_contiguious THEN

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

2808: END IF;
2809:
2810: p_return_status := l_return_status;
2811: WHEN error_non_contiguious THEN
2812: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2813: gme_debug.put_line ('Contiguity period ... not found');
2814: END IF;
2815:
2816: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');

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

2809:
2810: p_return_status := l_return_status;
2811: WHEN error_non_contiguious THEN
2812: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2813: gme_debug.put_line ('Contiguity period ... not found');
2814: END IF;
2815:
2816: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');
2817: p_return_status := 'C';

Line 2844: IF g_debug <= gme_debug.g_log_unexpected THEN

2840: gme_common_pvt.log_message ('GME_NO_RESOURCES'
2841: ,'ACTIVITY'
2842: ,l_activity);
2843: WHEN OTHERS THEN
2844: IF g_debug <= gme_debug.g_log_unexpected THEN
2845: gme_debug.put_line ( 'When others exception in '
2846: || g_pkg_name
2847: || '.'
2848: || l_api_name

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

2841: ,'ACTIVITY'
2842: ,l_activity);
2843: WHEN OTHERS THEN
2844: IF g_debug <= gme_debug.g_log_unexpected THEN
2845: gme_debug.put_line ( 'When others exception in '
2846: || g_pkg_name
2847: || '.'
2848: || l_api_name
2849: || ' Error is '

Line 2925: IF g_debug <= gme_debug.g_log_procedure THEN

2921: l_dep_step_no NUMBER;
2922: l_dep_type NUMBER;
2923: l_standard_delay NUMBER;
2924: BEGIN
2925: IF g_debug <= gme_debug.g_log_procedure THEN
2926: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
2927: END IF;
2928: x_return_status := fnd_api.g_ret_sts_success;
2929: x_batch_duration := 0;

Line 2926: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);

2922: l_dep_type NUMBER;
2923: l_standard_delay NUMBER;
2924: BEGIN
2925: IF g_debug <= gme_debug.g_log_procedure THEN
2926: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
2927: END IF;
2928: x_return_status := fnd_api.g_ret_sts_success;
2929: x_batch_duration := 0;
2930: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

2926: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
2927: END IF;
2928: x_return_status := fnd_api.g_ret_sts_success;
2929: x_batch_duration := 0;
2930: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2931: gme_debug.put_line (g_pkg_name || '.'|| l_api_name||' calculate duration');
2932: END IF;
2933: OPEN Cur_get_leaf_nodes (l_batch_id);
2934: FETCH Cur_get_leaf_nodes BULK COLLECT INTO l_leaf_nodes_tbl;

Line 2931: gme_debug.put_line (g_pkg_name || '.'|| l_api_name||' calculate duration');

2927: END IF;
2928: x_return_status := fnd_api.g_ret_sts_success;
2929: x_batch_duration := 0;
2930: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2931: gme_debug.put_line (g_pkg_name || '.'|| l_api_name||' calculate duration');
2932: END IF;
2933: OPEN Cur_get_leaf_nodes (l_batch_id);
2934: FETCH Cur_get_leaf_nodes BULK COLLECT INTO l_leaf_nodes_tbl;
2935: CLOSE Cur_get_leaf_nodes;

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

2932: END IF;
2933: OPEN Cur_get_leaf_nodes (l_batch_id);
2934: FETCH Cur_get_leaf_nodes BULK COLLECT INTO l_leaf_nodes_tbl;
2935: CLOSE Cur_get_leaf_nodes;
2936: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2937: gme_debug.put_line (g_pkg_name || '.'|| l_api_name||' number of leaf nodes: ' || l_leaf_nodes_tbl.COUNT);
2938: END IF;
2939: FOR i IN 1..l_leaf_nodes_tbl.COUNT LOOP
2940: OPEN Cur_get_branches(l_batch_id, l_leaf_nodes_tbl(i).leaf_batchstep_id);

Line 2937: gme_debug.put_line (g_pkg_name || '.'|| l_api_name||' number of leaf nodes: ' || l_leaf_nodes_tbl.COUNT);

2933: OPEN Cur_get_leaf_nodes (l_batch_id);
2934: FETCH Cur_get_leaf_nodes BULK COLLECT INTO l_leaf_nodes_tbl;
2935: CLOSE Cur_get_leaf_nodes;
2936: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2937: gme_debug.put_line (g_pkg_name || '.'|| l_api_name||' number of leaf nodes: ' || l_leaf_nodes_tbl.COUNT);
2938: END IF;
2939: FOR i IN 1..l_leaf_nodes_tbl.COUNT LOOP
2940: OPEN Cur_get_branches(l_batch_id, l_leaf_nodes_tbl(i).leaf_batchstep_id);
2941: FETCH Cur_get_branches BULK COLLECT INTO l_branches_tbl;

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

2939: FOR i IN 1..l_leaf_nodes_tbl.COUNT LOOP
2940: OPEN Cur_get_branches(l_batch_id, l_leaf_nodes_tbl(i).leaf_batchstep_id);
2941: FETCH Cur_get_branches BULK COLLECT INTO l_branches_tbl;
2942: CLOSE Cur_get_branches;
2943: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2944: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' number of branches: ' || l_branches_tbl.COUNT);
2945: END IF;
2946: FOR j IN 1..l_branches_tbl.COUNT LOOP
2947: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 2944: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' number of branches: ' || l_branches_tbl.COUNT);

2940: OPEN Cur_get_branches(l_batch_id, l_leaf_nodes_tbl(i).leaf_batchstep_id);
2941: FETCH Cur_get_branches BULK COLLECT INTO l_branches_tbl;
2942: CLOSE Cur_get_branches;
2943: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2944: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' number of branches: ' || l_branches_tbl.COUNT);
2945: END IF;
2946: FOR j IN 1..l_branches_tbl.COUNT LOOP
2947: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2948: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' current branch: ' || l_branches_tbl(j).branch);

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

2943: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2944: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' number of branches: ' || l_branches_tbl.COUNT);
2945: END IF;
2946: FOR j IN 1..l_branches_tbl.COUNT LOOP
2947: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2948: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' current branch: ' || l_branches_tbl(j).branch);
2949: END IF;
2950: m := 1;
2951: n := 5;

Line 2948: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' current branch: ' || l_branches_tbl(j).branch);

2944: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' number of branches: ' || l_branches_tbl.COUNT);
2945: END IF;
2946: FOR j IN 1..l_branches_tbl.COUNT LOOP
2947: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2948: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' current branch: ' || l_branches_tbl(j).branch);
2949: END IF;
2950: m := 1;
2951: n := 5;
2952: /* Divide by 14 because length of step_no = 5, dep_step_no = 5, dep_type = 1, standard_delay = 3 */

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

2960: l_dep_type := SUBSTR(l_branches_tbl(j).branch, m, 1);
2961: m := n + 1;
2962: n := m + 2;
2963: l_standard_delay := SUBSTR(l_branches_tbl(j).branch, m, 3);
2964: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2965: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' Step->Depstep->Deptype->Delay = '||l_step_no||'->'||l_dep_step_no||'->'||l_dep_type||'->'||l_standard_delay);
2966: END IF;
2967: IF (k = 1) THEN
2968: l_duration := l_step_duration_tab(l_step_no);

Line 2965: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' Step->Depstep->Deptype->Delay = '||l_step_no||'->'||l_dep_step_no||'->'||l_dep_type||'->'||l_standard_delay);

2961: m := n + 1;
2962: n := m + 2;
2963: l_standard_delay := SUBSTR(l_branches_tbl(j).branch, m, 3);
2964: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2965: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' Step->Depstep->Deptype->Delay = '||l_step_no||'->'||l_dep_step_no||'->'||l_dep_type||'->'||l_standard_delay);
2966: END IF;
2967: IF (k = 1) THEN
2968: l_duration := l_step_duration_tab(l_step_no);
2969: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

2965: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' Step->Depstep->Deptype->Delay = '||l_step_no||'->'||l_dep_step_no||'->'||l_dep_type||'->'||l_standard_delay);
2966: END IF;
2967: IF (k = 1) THEN
2968: l_duration := l_step_duration_tab(l_step_no);
2969: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2970: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' step->duration: ' || l_step_no||'->'||l_duration);
2971: END IF;
2972: END IF;
2973: l_duration := l_duration + l_standard_delay;

Line 2970: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' step->duration: ' || l_step_no||'->'||l_duration);

2966: END IF;
2967: IF (k = 1) THEN
2968: l_duration := l_step_duration_tab(l_step_no);
2969: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2970: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' step->duration: ' || l_step_no||'->'||l_duration);
2971: END IF;
2972: END IF;
2973: l_duration := l_duration + l_standard_delay;
2974: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

2970: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' step->duration: ' || l_step_no||'->'||l_duration);
2971: END IF;
2972: END IF;
2973: l_duration := l_duration + l_standard_delay;
2974: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2975: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' depstep->duration: ' || l_dep_step_no||'->'||l_duration);
2976: END IF;
2977: IF (l_dep_type = 1) THEN -- Start to Start
2978: IF l_step_duration_tab(l_dep_step_no) > l_duration THEN

Line 2975: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' depstep->duration: ' || l_dep_step_no||'->'||l_duration);

2971: END IF;
2972: END IF;
2973: l_duration := l_duration + l_standard_delay;
2974: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2975: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' depstep->duration: ' || l_dep_step_no||'->'||l_duration);
2976: END IF;
2977: IF (l_dep_type = 1) THEN -- Start to Start
2978: IF l_step_duration_tab(l_dep_step_no) > l_duration THEN
2979: l_duration := l_step_duration_tab(l_dep_step_no);

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

2983: END IF;
2984: m := n + 1;
2985: n := m + 4;
2986: END LOOP; -- parsing loop
2987: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2988: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' duration of branch: ' || l_duration);
2989: END IF;
2990: IF l_duration > x_batch_duration THEN
2991: x_batch_duration := l_duration;

Line 2988: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' duration of branch: ' || l_duration);

2984: m := n + 1;
2985: n := m + 4;
2986: END LOOP; -- parsing loop
2987: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2988: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' duration of branch: ' || l_duration);
2989: END IF;
2990: IF l_duration > x_batch_duration THEN
2991: x_batch_duration := l_duration;
2992: END IF;

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

2992: END IF;
2993: l_duration := 0;
2994: END LOOP; -- branches loop
2995: END LOOP; -- leaf nodes loop
2996: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2997: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' duration of batch: ' || x_batch_duration);
2998: END IF;
2999: EXCEPTION
3000: WHEN OTHERS THEN

Line 2997: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' duration of batch: ' || x_batch_duration);

2993: l_duration := 0;
2994: END LOOP; -- branches loop
2995: END LOOP; -- leaf nodes loop
2996: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2997: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' duration of batch: ' || x_batch_duration);
2998: END IF;
2999: EXCEPTION
3000: WHEN OTHERS THEN
3001: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 3001: IF g_debug <= gme_debug.g_log_unexpected THEN

2997: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' duration of batch: ' || x_batch_duration);
2998: END IF;
2999: EXCEPTION
3000: WHEN OTHERS THEN
3001: IF g_debug <= gme_debug.g_log_unexpected THEN
3002: gme_debug.put_line('When others exception in '|| g_pkg_name|| '.'|| l_api_name|| ' Error is '|| SQLERRM);
3003: END IF;
3004: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3005: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3002: gme_debug.put_line('When others exception in '|| g_pkg_name|| '.'|| l_api_name|| ' Error is '|| SQLERRM);

2998: END IF;
2999: EXCEPTION
3000: WHEN OTHERS THEN
3001: IF g_debug <= gme_debug.g_log_unexpected THEN
3002: gme_debug.put_line('When others exception in '|| g_pkg_name|| '.'|| l_api_name|| ' Error is '|| SQLERRM);
3003: END IF;
3004: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3005: x_return_status := fnd_api.g_ret_sts_unexp_error;
3006: END calc_longest_time_orig;

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

3070: x_return_status := FND_API.G_RET_STS_SUCCESS;
3071: x_batch_duration := 0;
3072: i := 1;
3073:
3074: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3075: gme_debug.put_line ('calculate duration');
3076: END IF;
3077:
3078: OPEN cur_get_leaf_nodes (l_batch_id);

Line 3075: gme_debug.put_line ('calculate duration');

3071: x_batch_duration := 0;
3072: i := 1;
3073:
3074: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3075: gme_debug.put_line ('calculate duration');
3076: END IF;
3077:
3078: OPEN cur_get_leaf_nodes (l_batch_id);
3079: FETCH cur_get_leaf_nodes BULK COLLECT INTO l_leaf_nodes;

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

3078: OPEN cur_get_leaf_nodes (l_batch_id);
3079: FETCH cur_get_leaf_nodes BULK COLLECT INTO l_leaf_nodes;
3080: CLOSE cur_get_leaf_nodes;
3081:
3082: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3083: gme_debug.put_line ('number of leaf nodes: ' || l_leaf_nodes.COUNT);
3084: END IF;
3085:
3086: FOR i IN l_leaf_nodes.FIRST .. l_leaf_nodes.LAST

Line 3083: gme_debug.put_line ('number of leaf nodes: ' || l_leaf_nodes.COUNT);

3079: FETCH cur_get_leaf_nodes BULK COLLECT INTO l_leaf_nodes;
3080: CLOSE cur_get_leaf_nodes;
3081:
3082: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3083: gme_debug.put_line ('number of leaf nodes: ' || l_leaf_nodes.COUNT);
3084: END IF;
3085:
3086: FOR i IN l_leaf_nodes.FIRST .. l_leaf_nodes.LAST
3087: LOOP

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

3092: x_batch_duration := l_count;
3093: END IF;
3094: END LOOP; /* FOR leaf_nodes */
3095:
3096: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3097: gme_debug.put_line ('X_batch_duration = ' || x_batch_duration);
3098: END IF;
3099: EXCEPTION
3100: WHEN OTHERS THEN

Line 3097: gme_debug.put_line ('X_batch_duration = ' || x_batch_duration);

3093: END IF;
3094: END LOOP; /* FOR leaf_nodes */
3095:
3096: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3097: gme_debug.put_line ('X_batch_duration = ' || x_batch_duration);
3098: END IF;
3099: EXCEPTION
3100: WHEN OTHERS THEN
3101: -- fnd_msg_pub.add_exc_msg (l_package_name, l_api_name);

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

3099: EXCEPTION
3100: WHEN OTHERS THEN
3101: -- fnd_msg_pub.add_exc_msg (l_package_name, l_api_name);
3102:
3103: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3104: gme_debug.put_line ('ERROR - when others - sqlerrm = ' || SQLERRM);
3105: END IF;
3106:
3107: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 3104: gme_debug.put_line ('ERROR - when others - sqlerrm = ' || SQLERRM);

3100: WHEN OTHERS THEN
3101: -- fnd_msg_pub.add_exc_msg (l_package_name, l_api_name);
3102:
3103: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3104: gme_debug.put_line ('ERROR - when others - sqlerrm = ' || SQLERRM);
3105: END IF;
3106:
3107: x_return_status := FND_API.g_ret_sts_unexp_error;
3108: END calc_longest_time;

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

3184: FROM gme_batch_steps
3185: WHERE batchstep_id = v_batchstep_id;
3186: BEGIN
3187:
3188: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3189: gme_debug.put_line ('entering get_longest_in_branch with batchstep_id '||node);
3190: END IF;
3191:
3192: for curnode in (select d.dep_step_id, dep_type, standard_delay, s.batchstep_no, s.batch_id

Line 3189: gme_debug.put_line ('entering get_longest_in_branch with batchstep_id '||node);

3185: WHERE batchstep_id = v_batchstep_id;
3186: BEGIN
3187:
3188: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3189: gme_debug.put_line ('entering get_longest_in_branch with batchstep_id '||node);
3190: END IF;
3191:
3192: for curnode in (select d.dep_step_id, dep_type, standard_delay, s.batchstep_no, s.batch_id
3193: from gme_batch_step_dependencies d, gme_batch_steps s

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

3194: where s.batchstep_id = d.batchstep_id and d.batchstep_id = node)
3195: loop
3196: /* initialize step duration */
3197: subnodes_found := 1;
3198: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3199: gme_debug.put_line ('entering the loop');
3200: gme_debug.put_line ('batchstep_no is '||curnode.batchstep_no);
3201: gme_debug.put_line ('batch_id is '||curnode.batch_id);
3202: gme_debug.put_line ('duration is '||l_step_duration_tab (curnode.batchstep_no));

Line 3199: gme_debug.put_line ('entering the loop');

3195: loop
3196: /* initialize step duration */
3197: subnodes_found := 1;
3198: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3199: gme_debug.put_line ('entering the loop');
3200: gme_debug.put_line ('batchstep_no is '||curnode.batchstep_no);
3201: gme_debug.put_line ('batch_id is '||curnode.batch_id);
3202: gme_debug.put_line ('duration is '||l_step_duration_tab (curnode.batchstep_no));
3203: gme_debug.put_line ('delay is '||curnode.standard_delay);

Line 3200: gme_debug.put_line ('batchstep_no is '||curnode.batchstep_no);

3196: /* initialize step duration */
3197: subnodes_found := 1;
3198: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3199: gme_debug.put_line ('entering the loop');
3200: gme_debug.put_line ('batchstep_no is '||curnode.batchstep_no);
3201: gme_debug.put_line ('batch_id is '||curnode.batch_id);
3202: gme_debug.put_line ('duration is '||l_step_duration_tab (curnode.batchstep_no));
3203: gme_debug.put_line ('delay is '||curnode.standard_delay);
3204: gme_debug.put_line ('dep_type is '||curnode.dep_type);

Line 3201: gme_debug.put_line ('batch_id is '||curnode.batch_id);

3197: subnodes_found := 1;
3198: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3199: gme_debug.put_line ('entering the loop');
3200: gme_debug.put_line ('batchstep_no is '||curnode.batchstep_no);
3201: gme_debug.put_line ('batch_id is '||curnode.batch_id);
3202: gme_debug.put_line ('duration is '||l_step_duration_tab (curnode.batchstep_no));
3203: gme_debug.put_line ('delay is '||curnode.standard_delay);
3204: gme_debug.put_line ('dep_type is '||curnode.dep_type);
3205: END IF;

Line 3202: gme_debug.put_line ('duration is '||l_step_duration_tab (curnode.batchstep_no));

3198: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3199: gme_debug.put_line ('entering the loop');
3200: gme_debug.put_line ('batchstep_no is '||curnode.batchstep_no);
3201: gme_debug.put_line ('batch_id is '||curnode.batch_id);
3202: gme_debug.put_line ('duration is '||l_step_duration_tab (curnode.batchstep_no));
3203: gme_debug.put_line ('delay is '||curnode.standard_delay);
3204: gme_debug.put_line ('dep_type is '||curnode.dep_type);
3205: END IF;
3206:

Line 3203: gme_debug.put_line ('delay is '||curnode.standard_delay);

3199: gme_debug.put_line ('entering the loop');
3200: gme_debug.put_line ('batchstep_no is '||curnode.batchstep_no);
3201: gme_debug.put_line ('batch_id is '||curnode.batch_id);
3202: gme_debug.put_line ('duration is '||l_step_duration_tab (curnode.batchstep_no));
3203: gme_debug.put_line ('delay is '||curnode.standard_delay);
3204: gme_debug.put_line ('dep_type is '||curnode.dep_type);
3205: END IF;
3206:
3207: -- This calculation account for duration and delay of the current step.

Line 3204: gme_debug.put_line ('dep_type is '||curnode.dep_type);

3200: gme_debug.put_line ('batchstep_no is '||curnode.batchstep_no);
3201: gme_debug.put_line ('batch_id is '||curnode.batch_id);
3202: gme_debug.put_line ('duration is '||l_step_duration_tab (curnode.batchstep_no));
3203: gme_debug.put_line ('delay is '||curnode.standard_delay);
3204: gme_debug.put_line ('dep_type is '||curnode.dep_type);
3205: END IF;
3206:
3207: -- This calculation account for duration and delay of the current step.
3208: StepDuration := l_step_duration_tab (curnode.batchstep_no) + curnode.standard_delay;

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

3207: -- This calculation account for duration and delay of the current step.
3208: StepDuration := l_step_duration_tab (curnode.batchstep_no) + curnode.standard_delay;
3209:
3210: IF (curnode.dep_type = 1) THEN -- Start to Start
3211: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3212: gme_debug.put_line ('start to start...');
3213: gme_debug.put_line ('get all dependent delays in a string');
3214: END IF;
3215:

Line 3212: gme_debug.put_line ('start to start...');

3208: StepDuration := l_step_duration_tab (curnode.batchstep_no) + curnode.standard_delay;
3209:
3210: IF (curnode.dep_type = 1) THEN -- Start to Start
3211: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3212: gme_debug.put_line ('start to start...');
3213: gme_debug.put_line ('get all dependent delays in a string');
3214: END IF;
3215:
3216: -- Bug 9862326 - Must account for delay of dependent steps due to inheritance.

Line 3213: gme_debug.put_line ('get all dependent delays in a string');

3209:
3210: IF (curnode.dep_type = 1) THEN -- Start to Start
3211: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3212: gme_debug.put_line ('start to start...');
3213: gme_debug.put_line ('get all dependent delays in a string');
3214: END IF;
3215:
3216: -- Bug 9862326 - Must account for delay of dependent steps due to inheritance.
3217: OPEN cur_get_step_delay(curnode.batch_id, curnode.dep_step_id);

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

3220: -- Bug 10226452 - Restructure this code to loop thru all branches fetched.
3221: l_standard_delay_hold := 0;
3222:
3223: WHILE cur_get_step_delay%FOUND LOOP
3224: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3225: gme_debug.put_line ('delay string is '||l_standard_delay_string);
3226: END IF;
3227:
3228: -- Sum up all dependent delays for the current step by extrapolating values from string.

Line 3225: gme_debug.put_line ('delay string is '||l_standard_delay_string);

3221: l_standard_delay_hold := 0;
3222:
3223: WHILE cur_get_step_delay%FOUND LOOP
3224: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3225: gme_debug.put_line ('delay string is '||l_standard_delay_string);
3226: END IF;
3227:
3228: -- Sum up all dependent delays for the current step by extrapolating values from string.
3229: l_standard_delay := 0;

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

3255: END IF;
3256:
3257: END LOOP; /* WHILE l_start_string IS NOT NULL */
3258:
3259: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3260: gme_debug.put_line ('aggregate dependent delay is '||l_standard_delay);
3261: gme_debug.put_line ('HOLD delay is '||l_standard_delay_hold);
3262: END IF;
3263:

Line 3260: gme_debug.put_line ('aggregate dependent delay is '||l_standard_delay);

3256:
3257: END LOOP; /* WHILE l_start_string IS NOT NULL */
3258:
3259: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3260: gme_debug.put_line ('aggregate dependent delay is '||l_standard_delay);
3261: gme_debug.put_line ('HOLD delay is '||l_standard_delay_hold);
3262: END IF;
3263:
3264: IF l_standard_delay > l_standard_delay_hold THEN

Line 3261: gme_debug.put_line ('HOLD delay is '||l_standard_delay_hold);

3257: END LOOP; /* WHILE l_start_string IS NOT NULL */
3258:
3259: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3260: gme_debug.put_line ('aggregate dependent delay is '||l_standard_delay);
3261: gme_debug.put_line ('HOLD delay is '||l_standard_delay_hold);
3262: END IF;
3263:
3264: IF l_standard_delay > l_standard_delay_hold THEN
3265: l_standard_delay_hold := l_standard_delay;

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

3278: ELSE
3279: longi := StepDuration;
3280: END IF;
3281:
3282: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3283: gme_debug.put_line (
3284: 'step duration replaced with dep step duration... '
3285: || longi
3286: );

Line 3283: gme_debug.put_line (

3279: longi := StepDuration;
3280: END IF;
3281:
3282: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3283: gme_debug.put_line (
3284: 'step duration replaced with dep step duration... '
3285: || longi
3286: );
3287: END IF;

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

3285: || longi
3286: );
3287: END IF;
3288:
3289: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3290: gme_debug.put_line ('done start to start...');
3291: END IF;
3292: ELSE -- dep_type = 0... thatn's an end to start, so add this in...
3293: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN

Line 3290: gme_debug.put_line ('done start to start...');

3286: );
3287: END IF;
3288:
3289: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3290: gme_debug.put_line ('done start to start...');
3291: END IF;
3292: ELSE -- dep_type = 0... thatn's an end to start, so add this in...
3293: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3294: gme_debug.put_line ('end to start...');

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

3289: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3290: gme_debug.put_line ('done start to start...');
3291: END IF;
3292: ELSE -- dep_type = 0... thatn's an end to start, so add this in...
3293: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3294: gme_debug.put_line ('end to start...');
3295: END IF;
3296:
3297: longi := StepDuration + get_longest_in_branch(curnode.dep_step_id,l_step_duration_tab);

Line 3294: gme_debug.put_line ('end to start...');

3290: gme_debug.put_line ('done start to start...');
3291: END IF;
3292: ELSE -- dep_type = 0... thatn's an end to start, so add this in...
3293: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3294: gme_debug.put_line ('end to start...');
3295: END IF;
3296:
3297: longi := StepDuration + get_longest_in_branch(curnode.dep_step_id,l_step_duration_tab);
3298: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN

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

3294: gme_debug.put_line ('end to start...');
3295: END IF;
3296:
3297: longi := StepDuration + get_longest_in_branch(curnode.dep_step_id,l_step_duration_tab);
3298: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3299: gme_debug.put_line (
3300: 'added duration of dep step and the resulted is'||longi);
3301: END IF;
3302: END IF;

Line 3299: gme_debug.put_line (

3295: END IF;
3296:
3297: longi := StepDuration + get_longest_in_branch(curnode.dep_step_id,l_step_duration_tab);
3298: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3299: gme_debug.put_line (
3300: 'added duration of dep step and the resulted is'||longi);
3301: END IF;
3302: END IF;
3303: if ( longi > long_in_branch) then

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

3309: from gme_batch_steps
3310: where batchstep_id = node;
3311: long_in_branch := l_step_duration_tab(leaf_subnode_stepno);
3312: END IF;
3313: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3314: gme_debug.put_line ('Weight for node'||node||'-->'||long_in_branch);
3315: END IF;
3316: return long_in_branch;
3317: END get_longest_in_branch;

Line 3314: gme_debug.put_line ('Weight for node'||node||'-->'||long_in_branch);

3310: where batchstep_id = node;
3311: long_in_branch := l_step_duration_tab(leaf_subnode_stepno);
3312: END IF;
3313: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3314: gme_debug.put_line ('Weight for node'||node||'-->'||long_in_branch);
3315: END IF;
3316: return long_in_branch;
3317: END get_longest_in_branch;
3318:

Line 3373: IF g_debug <= gme_debug.g_log_procedure THEN

3369:
3370: load_steps_failed EXCEPTION;
3371: error_calculating_scale_factor EXCEPTION;
3372: BEGIN
3373: IF g_debug <= gme_debug.g_log_procedure THEN
3374: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3375: || l_api_name);
3376: END IF;
3377:

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

3370: load_steps_failed EXCEPTION;
3371: error_calculating_scale_factor EXCEPTION;
3372: BEGIN
3373: IF g_debug <= gme_debug.g_log_procedure THEN
3374: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3375: || l_api_name);
3376: END IF;
3377:
3378: p_return_status := fnd_api.g_ret_sts_success;

Line 3440: IF g_debug <= gme_debug.g_log_procedure THEN

3436: p_step_tbl (i).step_vol_uom := gmd_auto_step_calc.g_vol_std_um;
3437: END IF;
3438: END LOOP; /*FOR i IN 1..X_step_rows*/
3439:
3440: IF g_debug <= gme_debug.g_log_procedure THEN
3441: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3442: END IF;
3443: EXCEPTION
3444: WHEN load_steps_failed THEN

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

3437: END IF;
3438: END LOOP; /*FOR i IN 1..X_step_rows*/
3439:
3440: IF g_debug <= gme_debug.g_log_procedure THEN
3441: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3442: END IF;
3443: EXCEPTION
3444: WHEN load_steps_failed THEN
3445: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

3441: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3442: END IF;
3443: EXCEPTION
3444: WHEN load_steps_failed THEN
3445: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3446: gme_debug.put_line ('GME auto step calc -- load steps failed');
3447: END IF;
3448:
3449: p_return_status := fnd_api.g_ret_sts_error;

Line 3446: gme_debug.put_line ('GME auto step calc -- load steps failed');

3442: END IF;
3443: EXCEPTION
3444: WHEN load_steps_failed THEN
3445: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3446: gme_debug.put_line ('GME auto step calc -- load steps failed');
3447: END IF;
3448:
3449: p_return_status := fnd_api.g_ret_sts_error;
3450: WHEN error_calculating_scale_factor THEN

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

3447: END IF;
3448:
3449: p_return_status := fnd_api.g_ret_sts_error;
3450: WHEN error_calculating_scale_factor THEN
3451: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3452: gme_debug.put_line
3453: ('GME_auto step calc -- error calc scale factor');
3454: END IF;
3455:

Line 3452: gme_debug.put_line

3448:
3449: p_return_status := fnd_api.g_ret_sts_error;
3450: WHEN error_calculating_scale_factor THEN
3451: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3452: gme_debug.put_line
3453: ('GME_auto step calc -- error calc scale factor');
3454: END IF;
3455:
3456: p_return_status := fnd_api.g_ret_sts_error;

Line 3458: IF g_debug <= gme_debug.g_log_unexpected THEN

3454: END IF;
3455:
3456: p_return_status := fnd_api.g_ret_sts_error;
3457: WHEN OTHERS THEN
3458: IF g_debug <= gme_debug.g_log_unexpected THEN
3459: gme_debug.put_line ( 'When others exception in '
3460: || g_pkg_name
3461: || '.'
3462: || l_api_name

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

3455:
3456: p_return_status := fnd_api.g_ret_sts_error;
3457: WHEN OTHERS THEN
3458: IF g_debug <= gme_debug.g_log_unexpected THEN
3459: gme_debug.put_line ( 'When others exception in '
3460: || g_pkg_name
3461: || '.'
3462: || l_api_name
3463: || ' Error is '

Line 3491: IF g_debug <= gme_debug.g_log_procedure THEN

3487: FROM fm_text_tbl
3488: WHERE text_code = p_text_code
3489: ORDER BY line_no;
3490: BEGIN
3491: IF g_debug <= gme_debug.g_log_procedure THEN
3492: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3493: || l_api_name);
3494: END IF;
3495:

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

3488: WHERE text_code = p_text_code
3489: ORDER BY line_no;
3490: BEGIN
3491: IF g_debug <= gme_debug.g_log_procedure THEN
3492: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3493: || l_api_name);
3494: END IF;
3495:
3496: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

3492: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3493: || l_api_name);
3494: END IF;
3495:
3496: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3497: gme_debug.put_line ('BEGIN copy and create text for '
3498: || p_text_string);
3499: END IF;
3500:

Line 3497: gme_debug.put_line ('BEGIN copy and create text for '

3493: || l_api_name);
3494: END IF;
3495:
3496: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3497: gme_debug.put_line ('BEGIN copy and create text for '
3498: || p_text_string);
3499: END IF;
3500:
3501: x_return_status := fnd_api.g_ret_sts_success;

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

3526: ELSE
3527: l_text_table (l_number_of_text_lines).text :=
3528: l_fm_text_tbl_row.text;
3529:
3530: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3531: gme_debug.put_line
3532: ( 'text for line no '
3533: || l_fm_text_tbl_row.line_no
3534: || ' is '

Line 3531: gme_debug.put_line

3527: l_text_table (l_number_of_text_lines).text :=
3528: l_fm_text_tbl_row.text;
3529:
3530: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3531: gme_debug.put_line
3532: ( 'text for line no '
3533: || l_fm_text_tbl_row.line_no
3534: || ' is '
3535: || l_text_table (l_number_of_text_lines).text);

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

3548: gme_text_dbl.insert_text_row (l_text_table (l_row_count)
3549: ,l_text_table (l_row_count) );
3550:
3551: IF NOT l_return THEN
3552: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3553: gme_debug.put_line ( 'trouble inserting text for '
3554: || p_text_string);
3555: END IF;
3556:

Line 3553: gme_debug.put_line ( 'trouble inserting text for '

3549: ,l_text_table (l_row_count) );
3550:
3551: IF NOT l_return THEN
3552: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3553: gme_debug.put_line ( 'trouble inserting text for '
3554: || p_text_string);
3555: END IF;
3556:
3557: -- We could not insert the text info. Error message pushed on stack in dbl code.

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

3557: -- We could not insert the text info. Error message pushed on stack in dbl code.
3558: RAISE unexpected_error;
3559: END IF;
3560:
3561: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3562: gme_debug.put_line ('inserted text for ' || p_text_string);
3563: END IF;
3564: END LOOP; /* FOR l_row_count IN 1 .. l_text_table.COUNT */
3565:

Line 3562: gme_debug.put_line ('inserted text for ' || p_text_string);

3558: RAISE unexpected_error;
3559: END IF;
3560:
3561: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3562: gme_debug.put_line ('inserted text for ' || p_text_string);
3563: END IF;
3564: END LOOP; /* FOR l_row_count IN 1 .. l_text_table.COUNT */
3565:
3566: IF g_debug <= gme_debug.g_log_procedure THEN

Line 3566: IF g_debug <= gme_debug.g_log_procedure THEN

3562: gme_debug.put_line ('inserted text for ' || p_text_string);
3563: END IF;
3564: END LOOP; /* FOR l_row_count IN 1 .. l_text_table.COUNT */
3565:
3566: IF g_debug <= gme_debug.g_log_procedure THEN
3567: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3568: END IF;
3569: EXCEPTION
3570: WHEN unexpected_error THEN

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

3563: END IF;
3564: END LOOP; /* FOR l_row_count IN 1 .. l_text_table.COUNT */
3565:
3566: IF g_debug <= gme_debug.g_log_procedure THEN
3567: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3568: END IF;
3569: EXCEPTION
3570: WHEN unexpected_error THEN
3571: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

3567: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3568: END IF;
3569: EXCEPTION
3570: WHEN unexpected_error THEN
3571: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3572: gme_debug.put_line
3573: ('ERROR - unexpected error in copy and create text while inserting header or dtl');
3574: END IF;
3575:

Line 3572: gme_debug.put_line

3568: END IF;
3569: EXCEPTION
3570: WHEN unexpected_error THEN
3571: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3572: gme_debug.put_line
3573: ('ERROR - unexpected error in copy and create text while inserting header or dtl');
3574: END IF;
3575:
3576: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3578: IF g_debug <= gme_debug.g_log_unexpected THEN

3574: END IF;
3575:
3576: x_return_status := fnd_api.g_ret_sts_unexp_error;
3577: WHEN OTHERS THEN
3578: IF g_debug <= gme_debug.g_log_unexpected THEN
3579: gme_debug.put_line ( 'When others exception in '
3580: || g_pkg_name
3581: || '.'
3582: || l_api_name

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

3575:
3576: x_return_status := fnd_api.g_ret_sts_unexp_error;
3577: WHEN OTHERS THEN
3578: IF g_debug <= gme_debug.g_log_unexpected THEN
3579: gme_debug.put_line ( 'When others exception in '
3580: || g_pkg_name
3581: || '.'
3582: || l_api_name
3583: || ' Error is '

Line 3613: IF g_debug <= gme_debug.g_log_procedure THEN

3609: WHERE a.uom_code = b.uom_code
3610: AND a.inventory_item_id = 0
3611: AND b.uom_code = v_uom_code;
3612: BEGIN
3613: IF g_debug <= gme_debug.g_log_procedure THEN
3614: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3615: || l_api_name);
3616: END IF;
3617:

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

3610: AND a.inventory_item_id = 0
3611: AND b.uom_code = v_uom_code;
3612: BEGIN
3613: IF g_debug <= gme_debug.g_log_procedure THEN
3614: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3615: || l_api_name);
3616: END IF;
3617:
3618: x_return_status := fnd_api.g_ret_sts_success;

Line 3667: IF g_debug <= gme_debug.g_log_procedure THEN

3663: p_plan_rsrc_usage * l_usage_std_factor / l_hour_std_factor;
3664: END IF;
3665: END IF;
3666:
3667: IF g_debug <= gme_debug.g_log_procedure THEN
3668: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3669: END IF;
3670: EXCEPTION
3671: WHEN OTHERS THEN

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

3664: END IF;
3665: END IF;
3666:
3667: IF g_debug <= gme_debug.g_log_procedure THEN
3668: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3669: END IF;
3670: EXCEPTION
3671: WHEN OTHERS THEN
3672: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 3672: IF g_debug <= gme_debug.g_log_unexpected THEN

3668: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3669: END IF;
3670: EXCEPTION
3671: WHEN OTHERS THEN
3672: IF g_debug <= gme_debug.g_log_unexpected THEN
3673: gme_debug.put_line ( 'When others exception in '
3674: || g_pkg_name
3675: || '.'
3676: || l_api_name

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

3669: END IF;
3670: EXCEPTION
3671: WHEN OTHERS THEN
3672: IF g_debug <= gme_debug.g_log_unexpected THEN
3673: gme_debug.put_line ( 'When others exception in '
3674: || g_pkg_name
3675: || '.'
3676: || l_api_name
3677: || ' Error is '

Line 3718: IF g_debug <= gme_debug.g_log_procedure THEN

3714: l_return_status VARCHAR2 (1);
3715: missing_profile_option EXCEPTION;
3716: l_api_name CONSTANT VARCHAR2 (30) := 'get_max_duration';
3717: BEGIN
3718: IF g_debug <= gme_debug.g_log_procedure THEN
3719: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3720: || l_api_name);
3721: END IF;
3722:

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

3715: missing_profile_option EXCEPTION;
3716: l_api_name CONSTANT VARCHAR2 (30) := 'get_max_duration';
3717: BEGIN
3718: IF g_debug <= gme_debug.g_log_procedure THEN
3719: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3720: || l_api_name);
3721: END IF;
3722:
3723: l_hour_um := gme_common_pvt.g_hour_uom_code;

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

3759: l_max_act_duration := l_act_duration;
3760: END IF;
3761: END LOOP;
3762:
3763: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3764: gme_debug.put_line ('l_max_act_duration ' || l_max_act_duration);
3765: END IF;
3766:
3767: IF g_debug <= gme_debug.g_log_procedure THEN

Line 3764: gme_debug.put_line ('l_max_act_duration ' || l_max_act_duration);

3760: END IF;
3761: END LOOP;
3762:
3763: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3764: gme_debug.put_line ('l_max_act_duration ' || l_max_act_duration);
3765: END IF;
3766:
3767: IF g_debug <= gme_debug.g_log_procedure THEN
3768: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

Line 3767: IF g_debug <= gme_debug.g_log_procedure THEN

3763: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3764: gme_debug.put_line ('l_max_act_duration ' || l_max_act_duration);
3765: END IF;
3766:
3767: IF g_debug <= gme_debug.g_log_procedure THEN
3768: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3769: END IF;
3770:
3771: RETURN l_max_act_duration;

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

3764: gme_debug.put_line ('l_max_act_duration ' || l_max_act_duration);
3765: END IF;
3766:
3767: IF g_debug <= gme_debug.g_log_procedure THEN
3768: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3769: END IF;
3770:
3771: RETURN l_max_act_duration;
3772: EXCEPTION

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

3770:
3771: RETURN l_max_act_duration;
3772: EXCEPTION
3773: WHEN missing_profile_option THEN
3774: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3775: gme_debug.put_line (l_api_name
3776: || ' ERROR - missing_profile_option');
3777: END IF;
3778:

Line 3775: gme_debug.put_line (l_api_name

3771: RETURN l_max_act_duration;
3772: EXCEPTION
3773: WHEN missing_profile_option THEN
3774: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3775: gme_debug.put_line (l_api_name
3776: || ' ERROR - missing_profile_option');
3777: END IF;
3778:
3779: l_max_act_duration := 0;

Line 3782: IF g_debug <= gme_debug.g_log_unexpected THEN

3778:
3779: l_max_act_duration := 0;
3780: RETURN 0;
3781: WHEN OTHERS THEN
3782: IF g_debug <= gme_debug.g_log_unexpected THEN
3783: gme_debug.put_line ( 'When others exception in '
3784: || g_pkg_name
3785: || '.'
3786: || l_api_name

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

3779: l_max_act_duration := 0;
3780: RETURN 0;
3781: WHEN OTHERS THEN
3782: IF g_debug <= gme_debug.g_log_unexpected THEN
3783: gme_debug.put_line ( 'When others exception in '
3784: || g_pkg_name
3785: || '.'
3786: || l_api_name
3787: || ' Error is '

Line 3813: IF g_debug <= gme_debug.g_log_procedure THEN

3809: --FPBug#4395561
3810: create_flex_failure EXCEPTION;
3811: l_return_status VARCHAR2(1);
3812: BEGIN
3813: IF g_debug <= gme_debug.g_log_procedure THEN
3814: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3815: || l_api_name);
3816: END IF;
3817:

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

3810: create_flex_failure EXCEPTION;
3811: l_return_status VARCHAR2(1);
3812: BEGIN
3813: IF g_debug <= gme_debug.g_log_procedure THEN
3814: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3815: || l_api_name);
3816: END IF;
3817:
3818: l_usage_time :=

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

3861: p_batch_step_resources_rec.plan_cmplt_date;
3862: l_gme_resource_txns.delete_mark := 0;
3863:
3864: FOR i IN 1 .. p_batch_step_resources_rec.plan_rsrc_count LOOP
3865: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3866: gme_debug.put_line ( g_pkg_name
3867: || '.'
3868: || l_api_name
3869: || ' '

Line 3866: gme_debug.put_line ( g_pkg_name

3862: l_gme_resource_txns.delete_mark := 0;
3863:
3864: FOR i IN 1 .. p_batch_step_resources_rec.plan_rsrc_count LOOP
3865: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3866: gme_debug.put_line ( g_pkg_name
3867: || '.'
3868: || l_api_name
3869: || ' '
3870: || 'resource transaction # '

Line 3909: IF g_debug <= gme_debug.g_log_procedure THEN

3905: END IF;
3906: END LOOP;
3907: END IF;
3908:
3909: IF g_debug <= gme_debug.g_log_procedure THEN
3910: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3911: END IF;
3912: EXCEPTION
3913: WHEN error_insert_res_txns THEN

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

3906: END LOOP;
3907: END IF;
3908:
3909: IF g_debug <= gme_debug.g_log_procedure THEN
3910: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3911: END IF;
3912: EXCEPTION
3913: WHEN error_insert_res_txns THEN
3914: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

3910: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3911: END IF;
3912: EXCEPTION
3913: WHEN error_insert_res_txns THEN
3914: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3915: gme_debug.put_line ('insert resource txns error');
3916: END IF;
3917:
3918: x_return_status := fnd_api.g_ret_sts_error;

Line 3915: gme_debug.put_line ('insert resource txns error');

3911: END IF;
3912: EXCEPTION
3913: WHEN error_insert_res_txns THEN
3914: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3915: gme_debug.put_line ('insert resource txns error');
3916: END IF;
3917:
3918: x_return_status := fnd_api.g_ret_sts_error;
3919: WHEN missing_profile_option THEN

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

3922: x_return_status := fnd_api.g_ret_sts_error;
3923: --FPBug#4395561
3924: WHEN create_flex_failure THEN
3925: x_return_status := l_return_status;
3926: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3927: gme_debug.put_line ('Creating the default values of the DFF failure');
3928: END IF;
3929: WHEN OTHERS THEN
3930: IF g_debug <= gme_debug.g_log_unexpected THEN

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

3923: --FPBug#4395561
3924: WHEN create_flex_failure THEN
3925: x_return_status := l_return_status;
3926: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3927: gme_debug.put_line ('Creating the default values of the DFF failure');
3928: END IF;
3929: WHEN OTHERS THEN
3930: IF g_debug <= gme_debug.g_log_unexpected THEN
3931: gme_debug.put_line ( 'When others exception in '

Line 3930: IF g_debug <= gme_debug.g_log_unexpected THEN

3926: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3927: gme_debug.put_line ('Creating the default values of the DFF failure');
3928: END IF;
3929: WHEN OTHERS THEN
3930: IF g_debug <= gme_debug.g_log_unexpected THEN
3931: gme_debug.put_line ( 'When others exception in '
3932: || g_pkg_name
3933: || '.'
3934: || l_api_name

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

3927: gme_debug.put_line ('Creating the default values of the DFF failure');
3928: END IF;
3929: WHEN OTHERS THEN
3930: IF g_debug <= gme_debug.g_log_unexpected THEN
3931: gme_debug.put_line ( 'When others exception in '
3932: || g_pkg_name
3933: || '.'
3934: || l_api_name
3935: || ' Error is '