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_COMMON_PVT

Line 195: IF (p_gme_batch_header_rec.batch_type = gme_common_pvt.g_doc_type_batch) THEN

191:
192: x_return_status := fnd_api.g_ret_sts_success;
193: l_batch_id := p_gme_batch_header_rec.batch_id;
194:
195: IF (p_gme_batch_header_rec.batch_type = gme_common_pvt.g_doc_type_batch) THEN
196: l_doc_type := 'PROD';
197: ELSE
198: l_doc_type := 'FPO';
199: END IF;

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 235: l_gme_batch_steps (j).step_status := gme_common_pvt.g_step_pending;

231: p_recipe_rout_step_tbl (i).routingstep_id;
232: l_gme_batch_steps (j).batchstep_no :=
233: p_recipe_rout_step_tbl (i).routingstep_no;
234: l_gme_batch_steps (j).oprn_id := p_recipe_rout_step_tbl (i).oprn_id;
235: l_gme_batch_steps (j).step_status := gme_common_pvt.g_step_pending;
236: l_gme_batch_steps (j).quality_status := 1;
237: l_gme_batch_steps (j).delete_mark := 0;
238: l_gme_batch_steps (j).step_qty_um :=
239: p_recipe_rout_step_tbl (i).process_qty_uom;

Line 256: l_gme_batch_steps (j).plan_start_date := gme_common_pvt.g_timestamp;

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;
258: l_gme_batch_steps (j).plan_charges := 0;
259:
260: IF p_gme_batch_header_rec.enforce_step_dependency = 1 THEN

Line 257: l_gme_batch_steps (j).plan_cmplt_date := gme_common_pvt.g_timestamp;

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;
258: l_gme_batch_steps (j).plan_charges := 0;
259:
260: IF p_gme_batch_header_rec.enforce_step_dependency = 1 THEN
261: l_gme_batch_steps (j).steprelease_type := 1;

Line 287: AND (gme_common_pvt.g_copy_routing_text_ind = 1) THEN

283: -- Insert text if copy text is on and there is text on the step passed in...
284: -- Note... this should also work for insert step because an operation can have text
285: -- and so as long as gmd passes it back in the fetch... this will work (and copy_routing_text = '1')
286: IF (p_recipe_rout_step_tbl (i).text_code IS NOT NULL)
287: AND (gme_common_pvt.g_copy_routing_text_ind = 1) THEN
288: l_gmd_text_code := p_recipe_rout_step_tbl (i).text_code;
289: l_text_string :=
290: 'gme_batch_steps' || '|' || TO_CHAR (l_batch_id)
291: || '|';

Line 424: AND (gme_common_pvt.g_copy_routing_text_ind = 1) THEN

420: -- Insert text if copy text is on and there is text on the activity passed in...
421: -- Note... this should also work for insert step because an operation can have text
422: -- and so as long as gmd passes it back in the fetch... this will work (and copy_routing_text = '1')
423: IF (p_recipe_rout_act_tbl (i).text_code IS NOT NULL)
424: AND (gme_common_pvt.g_copy_routing_text_ind = 1) THEN
425: l_gmd_text_code := p_recipe_rout_act_tbl (i).text_code;
426: l_text_string :=
427: 'gme_batch_step_activities' || '|' || TO_CHAR (l_batch_id)
428: || '|';

Line 554: gme_common_pvt.log_message

550:
551: IF l_gme_batch_step_resources (j).scale_type <> 0 THEN
552: IF l_gme_batch_step_resources (j).plan_rsrc_qty = 0
553: AND l_gme_batch_step_resources (j).plan_rsrc_usage <> 0 THEN
554: gme_common_pvt.log_message
555: ('gme_rsrc_qty_usage_oprn'
556: ,'RESOURCE'
557: ,p_recipe_rout_resc_tbl (i).resources
558: ,'ACTIVITY'

Line 611: AND (gme_common_pvt.g_copy_routing_text_ind = '1') THEN

607: -- Insert text if copy text is on and there is text on the resource passed in...
608: -- Note... this should also work for insert step because an operation can have text
609: -- and so as long as gmd passes it back in the fetch... this will work (and copy_routing_text = '1')
610: IF (p_recipe_rout_resc_tbl (i).text_code IS NOT NULL)
611: AND (gme_common_pvt.g_copy_routing_text_ind = '1') THEN
612: l_gmd_text_code := p_recipe_rout_resc_tbl (i).text_code;
613: l_text_string :=
614: 'gme_batch_step_resources' || '|' || TO_CHAR (l_batch_id)
615: || '|';

Line 851: AND (gme_common_pvt.g_copy_routing_text_ind = '1') THEN

847:
848:
849: -- Bug: 7715293 vpedarla
850: IF (p_recipe_rout_matl_tbl (i).text_code IS NOT NULL)
851: AND (gme_common_pvt.g_copy_routing_text_ind = '1') THEN
852:
853: l_gmd_text_code := p_recipe_rout_matl_tbl (i).text_code;
854: l_text_string :=
855: 'gme_batch_step_items' || '|' || TO_CHAR (l_batch_id)

Line 1045: --Bug#5231180 used gme_common_pvt variables rather GMD spec variables

1041:
1042: l_mass_qty := NULL;
1043: l_volume_qty := NULL;
1044:
1045: --Bug#5231180 used gme_common_pvt variables rather GMD spec variables
1046: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN
1047: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
1048: --multiply the step qty with standard factor to get mass qty
1049: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;

Line 1046: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN

1042: l_mass_qty := NULL;
1043: l_volume_qty := NULL;
1044:
1045: --Bug#5231180 used gme_common_pvt variables rather GMD spec variables
1046: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN
1047: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
1048: --multiply the step qty with standard factor to get mass qty
1049: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
1050: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN

Line 1047: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN

1043: l_volume_qty := NULL;
1044:
1045: --Bug#5231180 used gme_common_pvt variables rather GMD spec variables
1046: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN
1047: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
1048: --multiply the step qty with standard factor to get mass qty
1049: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
1050: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN
1051: ELSIF l_uom_class = gme_common_pvt.g_volume_um_type THEN

Line 1050: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN

1046: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN
1047: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
1048: --multiply the step qty with standard factor to get mass qty
1049: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
1050: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN
1051: ELSIF l_uom_class = gme_common_pvt.g_volume_um_type 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;

Line 1051: ELSIF l_uom_class = gme_common_pvt.g_volume_um_type THEN

1047: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
1048: --multiply the step qty with standard factor to get mass qty
1049: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
1050: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN
1051: ELSIF l_uom_class = gme_common_pvt.g_volume_um_type 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:

Line 1297: IF gme_common_pvt.resource_qty_below_capacity

1293: END IF;
1294:
1295: /* Lets check if any of the resource quantities are falling below the min capacity */
1296: IF (p_ignore_qty_below_cap = fnd_api.g_false) THEN
1297: IF gme_common_pvt.resource_qty_below_capacity
1298: (p_batch_id => l_batch_id) THEN
1299: RAISE process_qty_below_cap;
1300: END IF;
1301: END IF; /* IF NOT (p_ignore_qty_below_cap) */

Line 1387: ,last_updated_by = gme_common_pvt.g_user_ident

1383:
1384: IF (p_step_cmplt_date > l_step_plan_cmplt_date) THEN
1385: UPDATE gme_batch_steps
1386: SET plan_cmplt_date = p_step_cmplt_date
1387: ,last_updated_by = gme_common_pvt.g_user_ident
1388: ,last_update_date = gme_common_pvt.g_timestamp
1389: ,last_update_login = gme_common_pvt.g_login_id
1390: WHERE batch_id = p_gme_batch_header_rec.batch_id
1391: AND batchstep_id = l_last_batchstep_id;

Line 1388: ,last_update_date = gme_common_pvt.g_timestamp

1384: IF (p_step_cmplt_date > l_step_plan_cmplt_date) THEN
1385: UPDATE gme_batch_steps
1386: SET plan_cmplt_date = p_step_cmplt_date
1387: ,last_updated_by = gme_common_pvt.g_user_ident
1388: ,last_update_date = gme_common_pvt.g_timestamp
1389: ,last_update_login = gme_common_pvt.g_login_id
1390: WHERE batch_id = p_gme_batch_header_rec.batch_id
1391: AND batchstep_id = l_last_batchstep_id;
1392: ELSIF (p_step_cmplt_date < l_step_plan_cmplt_date) THEN

Line 1389: ,last_update_login = gme_common_pvt.g_login_id

1385: UPDATE gme_batch_steps
1386: SET plan_cmplt_date = p_step_cmplt_date
1387: ,last_updated_by = gme_common_pvt.g_user_ident
1388: ,last_update_date = gme_common_pvt.g_timestamp
1389: ,last_update_login = gme_common_pvt.g_login_id
1390: WHERE batch_id = p_gme_batch_header_rec.batch_id
1391: AND batchstep_id = l_last_batchstep_id;
1392: ELSIF (p_step_cmplt_date < l_step_plan_cmplt_date) THEN
1393: l_gme_batch_header.batch_id := p_gme_batch_header_rec.batch_id;

Line 1511: wf_event.RAISE (p_event_name => gme_common_pvt.G_BATCHSTEP_CREATED

1507: END LOOP;
1508:
1509: IF ( p_recipe_rout_step_tbl.COUNT = 1
1510: AND p_recipe_rout_step_tbl (1).routingstep_id IS NULL) 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

Line 2174: l_calendar_code := gme_common_pvt.g_calendar_code;

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:
2176: IF l_calendar_code IS NULL THEN
2177: l_use_workday_cal := fnd_api.g_false;
2178: ELSE

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 2432: TO_CHAR(gme_common_pvt.g_timestamp,'DD-MON-YYYY HH24:MI:SS')); -- 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;
2436:

Line 2440: ,p_start_date => gme_common_pvt.g_timestamp

2436:
2437: gmp_calendar_api.get_contiguous_periods
2438: (p_api_version => 1
2439: ,p_init_msg_list => TRUE
2440: ,p_start_date => gme_common_pvt.g_timestamp
2441: ,p_end_date => NULL
2442: ,p_calendar_code => l_calendar_code
2443: ,p_duration => x_batch_duration
2444: ,p_output_tbl => l_contig_period_tbl

Line 2464: x_batch_start_date := gme_common_pvt.g_timestamp;

2460: END IF;
2461: END IF;
2462: END IF;
2463:
2464: x_batch_start_date := gme_common_pvt.g_timestamp;
2465: END IF;
2466: END IF;
2467:
2468: /* Calculate the dates for all the rows in X_step_tbl */

Line 2764: ,last_updated_by = gme_common_pvt.g_user_ident

2760: -- Pawan Kumar made following changes for bug 5015873
2761: -- min_start_date := p_gme_batch_header_rec.plan_start_date;
2762: UPDATE gme_batch_header
2763: SET plan_cmplt_date = max_cmplt_date
2764: ,last_updated_by = gme_common_pvt.g_user_ident
2765: ,last_update_date = gme_common_pvt.g_timestamp
2766: ,last_update_login = gme_common_pvt.g_login_id
2767: WHERE batch_id = l_batch_id;
2768: ELSE

Line 2765: ,last_update_date = gme_common_pvt.g_timestamp

2761: -- min_start_date := p_gme_batch_header_rec.plan_start_date;
2762: UPDATE gme_batch_header
2763: SET plan_cmplt_date = max_cmplt_date
2764: ,last_updated_by = gme_common_pvt.g_user_ident
2765: ,last_update_date = gme_common_pvt.g_timestamp
2766: ,last_update_login = gme_common_pvt.g_login_id
2767: WHERE batch_id = l_batch_id;
2768: ELSE
2769: UPDATE gme_batch_header

Line 2766: ,last_update_login = gme_common_pvt.g_login_id

2762: UPDATE gme_batch_header
2763: SET plan_cmplt_date = max_cmplt_date
2764: ,last_updated_by = gme_common_pvt.g_user_ident
2765: ,last_update_date = gme_common_pvt.g_timestamp
2766: ,last_update_login = gme_common_pvt.g_login_id
2767: WHERE batch_id = l_batch_id;
2768: ELSE
2769: UPDATE gme_batch_header
2770: SET plan_start_date = min_start_date

Line 2772: ,last_updated_by = gme_common_pvt.g_user_ident

2768: ELSE
2769: UPDATE gme_batch_header
2770: SET plan_start_date = min_start_date
2771: ,plan_cmplt_date = max_cmplt_date
2772: ,last_updated_by = gme_common_pvt.g_user_ident
2773: ,last_update_date = gme_common_pvt.g_timestamp
2774: ,last_update_login = gme_common_pvt.g_login_id
2775: WHERE batch_id = l_batch_id;
2776: END IF;

Line 2773: ,last_update_date = gme_common_pvt.g_timestamp

2769: UPDATE gme_batch_header
2770: SET plan_start_date = min_start_date
2771: ,plan_cmplt_date = max_cmplt_date
2772: ,last_updated_by = gme_common_pvt.g_user_ident
2773: ,last_update_date = gme_common_pvt.g_timestamp
2774: ,last_update_login = gme_common_pvt.g_login_id
2775: WHERE batch_id = l_batch_id;
2776: END IF;
2777:

Line 2774: ,last_update_login = gme_common_pvt.g_login_id

2770: SET plan_start_date = min_start_date
2771: ,plan_cmplt_date = max_cmplt_date
2772: ,last_updated_by = gme_common_pvt.g_user_ident
2773: ,last_update_date = gme_common_pvt.g_timestamp
2774: ,last_update_login = gme_common_pvt.g_login_id
2775: WHERE batch_id = l_batch_id;
2776: END IF;
2777:
2778: /* UPDATE gme_batch_header

Line 2781: ,last_updated_by = gme_common_pvt.g_user_ident

2777:
2778: /* UPDATE gme_batch_header
2779: SET plan_start_date = min_start_date
2780: ,plan_cmplt_date = max_cmplt_date
2781: ,last_updated_by = gme_common_pvt.g_user_ident
2782: ,last_update_date = gme_common_pvt.g_timestamp
2783: ,last_update_login = gme_common_pvt.g_login_id
2784: WHERE batch_id = l_batch_id;*/
2785:

Line 2782: ,last_update_date = gme_common_pvt.g_timestamp

2778: /* UPDATE gme_batch_header
2779: SET plan_start_date = min_start_date
2780: ,plan_cmplt_date = max_cmplt_date
2781: ,last_updated_by = gme_common_pvt.g_user_ident
2782: ,last_update_date = gme_common_pvt.g_timestamp
2783: ,last_update_login = gme_common_pvt.g_login_id
2784: WHERE batch_id = l_batch_id;*/
2785:
2786: UPDATE gme_batch_header

Line 2783: ,last_update_login = gme_common_pvt.g_login_id

2779: SET plan_start_date = min_start_date
2780: ,plan_cmplt_date = max_cmplt_date
2781: ,last_updated_by = gme_common_pvt.g_user_ident
2782: ,last_update_date = gme_common_pvt.g_timestamp
2783: ,last_update_login = gme_common_pvt.g_login_id
2784: WHERE batch_id = l_batch_id;*/
2785:
2786: UPDATE gme_batch_header
2787: SET due_date = max_cmplt_date

Line 2788: ,last_updated_by = gme_common_pvt.g_user_ident

2784: WHERE batch_id = l_batch_id;*/
2785:
2786: UPDATE gme_batch_header
2787: SET due_date = max_cmplt_date
2788: ,last_updated_by = gme_common_pvt.g_user_ident
2789: ,last_update_date = gme_common_pvt.g_timestamp
2790: ,last_update_login = gme_common_pvt.g_login_id
2791: WHERE batch_id = l_batch_id
2792: AND due_date = gme_common_pvt.g_timestamp;

Line 2789: ,last_update_date = gme_common_pvt.g_timestamp

2785:
2786: UPDATE gme_batch_header
2787: SET due_date = max_cmplt_date
2788: ,last_updated_by = gme_common_pvt.g_user_ident
2789: ,last_update_date = gme_common_pvt.g_timestamp
2790: ,last_update_login = gme_common_pvt.g_login_id
2791: WHERE batch_id = l_batch_id
2792: AND due_date = gme_common_pvt.g_timestamp;
2793: END IF;

Line 2790: ,last_update_login = gme_common_pvt.g_login_id

2786: UPDATE gme_batch_header
2787: SET due_date = max_cmplt_date
2788: ,last_updated_by = gme_common_pvt.g_user_ident
2789: ,last_update_date = gme_common_pvt.g_timestamp
2790: ,last_update_login = gme_common_pvt.g_login_id
2791: WHERE batch_id = l_batch_id
2792: AND due_date = gme_common_pvt.g_timestamp;
2793: END IF;
2794:

Line 2792: AND due_date = gme_common_pvt.g_timestamp;

2788: ,last_updated_by = gme_common_pvt.g_user_ident
2789: ,last_update_date = gme_common_pvt.g_timestamp
2790: ,last_update_login = gme_common_pvt.g_login_id
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);

Line 2816: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');

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';
2818: WHEN no_activities THEN
2819: p_return_status := fnd_api.g_ret_sts_error;
2820:

Line 2828: gme_common_pvt.log_message ('GME_NO_ACTIVITIES', 'STEPNO'

2824: INTO x_step_no;
2825:
2826: CLOSE cur_get_step;
2827:
2828: gme_common_pvt.log_message ('GME_NO_ACTIVITIES', 'STEPNO'
2829: ,x_step_no);
2830: WHEN no_resources THEN
2831: p_return_status := fnd_api.g_ret_sts_error;
2832:

Line 2840: gme_common_pvt.log_message ('GME_NO_RESOURCES'

2836: INTO l_activity;
2837:
2838: CLOSE cur_get_activity;
2839:
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

Line 3391: IF (gme_common_pvt.g_mass_um_type IS NOT NULL) THEN

3387: IF x_return_status <> p_return_status THEN
3388: RAISE load_steps_failed;
3389: END IF;
3390:
3391: IF (gme_common_pvt.g_mass_um_type IS NOT NULL) THEN
3392: OPEN cur_get_std_um (gme_common_pvt.g_mass_um_type);
3393:
3394: FETCH cur_get_std_um
3395: INTO gmd_auto_step_calc.g_mass_std_um;

Line 3392: OPEN cur_get_std_um (gme_common_pvt.g_mass_um_type);

3388: RAISE load_steps_failed;
3389: END IF;
3390:
3391: IF (gme_common_pvt.g_mass_um_type IS NOT NULL) THEN
3392: OPEN cur_get_std_um (gme_common_pvt.g_mass_um_type);
3393:
3394: FETCH cur_get_std_um
3395: INTO gmd_auto_step_calc.g_mass_std_um;
3396:

Line 3400: IF (gme_common_pvt.g_volume_um_type IS NOT NULL) THEN

3396:
3397: CLOSE cur_get_std_um;
3398: END IF;
3399:
3400: IF (gme_common_pvt.g_volume_um_type IS NOT NULL) THEN
3401: OPEN cur_get_std_um (gme_common_pvt.g_volume_um_type);
3402:
3403: FETCH cur_get_std_um
3404: INTO gmd_auto_step_calc.g_vol_std_um;

Line 3401: OPEN cur_get_std_um (gme_common_pvt.g_volume_um_type);

3397: CLOSE cur_get_std_um;
3398: END IF;
3399:
3400: IF (gme_common_pvt.g_volume_um_type IS NOT NULL) THEN
3401: OPEN cur_get_std_um (gme_common_pvt.g_volume_um_type);
3402:
3403: FETCH cur_get_std_um
3404: INTO gmd_auto_step_calc.g_vol_std_um;
3405:

Line 3409: x_scale_factor := gme_common_pvt.g_routing_scale_factor;

3405:
3406: CLOSE cur_get_std_um;
3407: END IF;
3408:
3409: x_scale_factor := gme_common_pvt.g_routing_scale_factor;
3410: x_step_rows := p_step_tbl.COUNT;
3411:
3412: /* Calculate the step quantities for all the rows in X_step_tbl */
3413: FOR i IN 1 .. x_step_rows LOOP

Line 3431: IF x_uom_class = gme_common_pvt.g_mass_um_type THEN

3427: INTO x_new_factor, x_uom_class;
3428:
3429: CLOSE cur_get_std_factor;
3430:
3431: IF x_uom_class = gme_common_pvt.g_mass_um_type THEN
3432: p_step_tbl (i).step_mass_qty := x_step_qty * x_new_factor;
3433: p_step_tbl (i).step_mass_uom := gmd_auto_step_calc.g_mass_std_um;
3434: ELSIF x_uom_class = gme_common_pvt.g_volume_um_type THEN
3435: p_step_tbl (i).step_vol_qty := x_step_qty * x_new_factor;

Line 3434: ELSIF x_uom_class = gme_common_pvt.g_volume_um_type THEN

3430:
3431: IF x_uom_class = gme_common_pvt.g_mass_um_type THEN
3432: p_step_tbl (i).step_mass_qty := x_step_qty * x_new_factor;
3433: p_step_tbl (i).step_mass_uom := gmd_auto_step_calc.g_mass_std_um;
3434: ELSIF x_uom_class = gme_common_pvt.g_volume_um_type THEN
3435: p_step_tbl (i).step_vol_qty := x_step_qty * x_new_factor;
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*/

Line 3480: l_text_table gme_common_pvt.text_tab;

3476: IS
3477: l_number_of_text_lines NUMBER;
3478: l_return BOOLEAN;
3479: l_text_header gme_text_header%ROWTYPE;
3480: l_text_table gme_common_pvt.text_tab;
3481: l_api_name CONSTANT VARCHAR2 (30) := 'copy and create text';
3482: unexpected_error EXCEPTION;
3483:
3484: CURSOR fm_text_tbl_cursor (p_text_code fm_text_tbl.text_code%TYPE)

Line 3621: IF NOT gme_common_pvt.g_setup_done THEN

3617:
3618: x_return_status := fnd_api.g_ret_sts_success;
3619:
3620: -- Bug 14769220 - Initialize uom global for this code to work correctly.
3621: IF NOT gme_common_pvt.g_setup_done THEN
3622: gme_common_pvt.g_hour_uom_code := fnd_profile.VALUE ('BOM:HOUR_UOM_CODE');
3623: END IF;
3624:
3625: x_usage_hrs := 0;

Line 3622: gme_common_pvt.g_hour_uom_code := fnd_profile.VALUE ('BOM:HOUR_UOM_CODE');

3618: x_return_status := fnd_api.g_ret_sts_success;
3619:
3620: -- Bug 14769220 - Initialize uom global for this code to work correctly.
3621: IF NOT gme_common_pvt.g_setup_done THEN
3622: gme_common_pvt.g_hour_uom_code := fnd_profile.VALUE ('BOM:HOUR_UOM_CODE');
3623: END IF;
3624:
3625: x_usage_hrs := 0;
3626: l_hour_um := gme_common_pvt.g_hour_uom_code;

Line 3626: l_hour_um := gme_common_pvt.g_hour_uom_code;

3622: gme_common_pvt.g_hour_uom_code := fnd_profile.VALUE ('BOM:HOUR_UOM_CODE');
3623: END IF;
3624:
3625: x_usage_hrs := 0;
3626: l_hour_um := gme_common_pvt.g_hour_uom_code;
3627:
3628: IF l_hour_um = p_usage_um THEN
3629: x_usage_hrs := p_plan_rsrc_usage;
3630: ELSE /* we have to calculate the usage in hours... */

Line 3723: l_hour_um := gme_common_pvt.g_hour_uom_code;

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;
3724:
3725: FOR step_activity IN cur_get_activity (v_step_id, v_batch_id) LOOP
3726: l_max_rsrc_duration := 0;
3727:

Line 3822: l_hour_um := gme_common_pvt.g_hour_uom_code;

3818: l_usage_time :=
3819: ( p_batch_step_resources_rec.plan_cmplt_date
3820: - p_batch_step_resources_rec.plan_start_date)
3821: * 24;
3822: l_hour_um := gme_common_pvt.g_hour_uom_code;
3823: l_txn_usage :=
3824: inv_convert.inv_um_convert
3825: (item_id => 0
3826: ,PRECISION => 5