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_PHANTOM_PVT dependencies on FND_API

Line 54: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false

50: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
51: ,p_validity_rule_id IN NUMBER
52: ,p_use_workday_cal IN VARCHAR2
53: ,p_contiguity_override IN VARCHAR2
54: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
55: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
56: ,x_return_status OUT NOCOPY VARCHAR2)
57: IS
58: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PHANTOM';

Line 111: x_return_status := fnd_api.g_ret_sts_success;

107: || l_api_name);
108: END IF;
109:
110: /* Set the return status to success initially */
111: x_return_status := fnd_api.g_ret_sts_success;
112:
113: IF NOT (gme_material_details_dbl.fetch_row (p_material_detail_rec
114: ,x_material_detail_rec) ) THEN
115: RAISE material_detail_fetch_error;

Line 174: IF x_return_status <> fnd_api.g_ret_sts_success THEN

170: ,x_msg_data => l_msg_list
171: ,x_return_code => l_return_code
172: ,x_recipe_validity_out => l_validity_tbl);
173:
174: IF x_return_status <> fnd_api.g_ret_sts_success THEN
175: RAISE validity_fetch_error;
176: ELSIF l_validity_tbl.COUNT = 0 THEN
177: RAISE no_validity_found;
178: END IF;

Line 249: IF x_return_status <> fnd_api.g_ret_sts_success

245: || 'Create_batch returned '
246: || x_return_status);
247: END IF;
248:
249: IF x_return_status <> fnd_api.g_ret_sts_success
250: AND x_return_status <> gme_common_pvt.g_inv_short_err THEN
251: ROLLBACK TO SAVEPOINT create_auto_phantom;
252: RAISE batch_creation_failed;
253: END IF;

Line 291: x_return_status := fnd_api.g_ret_sts_success;

287: ,last_updated_by = gme_common_pvt.g_user_ident
288: ,last_update_login = gme_common_pvt.g_login_id
289: WHERE material_detail_id = p_material_detail_rec.material_detail_id;
290:
291: x_return_status := fnd_api.g_ret_sts_success;
292:
293: IF g_debug <= gme_debug.g_log_procedure THEN
294: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
295: END IF;

Line 298: x_return_status := fnd_api.g_ret_sts_error;

294: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
295: END IF;
296: EXCEPTION
297: WHEN batch_creation_failed OR material_detail_fetch_error OR not_a_phantom OR phantom_exists OR batch_header_fetch_error OR validity_fetch_error OR batch_creation_failed OR batch_upd_error THEN
298: x_return_status := fnd_api.g_ret_sts_error;
299: WHEN no_validity_found THEN
300: x_return_status := 'W';
301: WHEN OTHERS THEN
302: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 311: x_return_status := fnd_api.g_ret_sts_unexp_error;

307: || ' Error is '
308: || SQLERRM);
309: END IF;
310:
311: x_return_status := fnd_api.g_ret_sts_unexp_error;
312: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
313: END create_phantom;
314:
315: /*===========================================================================================

Line 341: x_return_status := fnd_api.g_ret_sts_success;

337: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
338: || l_api_name);
339: END IF;
340:
341: x_return_status := fnd_api.g_ret_sts_success;
342:
343: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => p_batch_header
344: ,x_batch_header => l_batch_header) THEN
345: RAISE error_fetch_header;

Line 355: x_return_status := fnd_api.g_ret_sts_error;

351: RETURN FALSE;
352: END IF;
353: EXCEPTION
354: WHEN error_fetch_header THEN
355: x_return_status := fnd_api.g_ret_sts_error;
356: RETURN FALSE;
357: WHEN OTHERS THEN
358: IF g_debug <= gme_debug.g_log_unexpected THEN
359: gme_debug.put_line ( 'When others exception in '

Line 421: x_return_status := fnd_api.g_ret_sts_success;

417: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
418: || l_api_name);
419: END IF;
420:
421: x_return_status := fnd_api.g_ret_sts_success;
422:
423: IF (p_batch_id IS NULL) OR (p_batchstep_id IS NULL) THEN
424: RAISE no_keys;
425: END IF;

Line 439: x_return_status := fnd_api.g_ret_sts_error;

435: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
436: END IF;
437: EXCEPTION
438: WHEN no_keys THEN
439: x_return_status := fnd_api.g_ret_sts_error;
440: gme_common_pvt.log_message ('GME_NO_KEYS'
441: ,'TABLE_NAME'
442: ,'FETCH_STEP_PHANTOMS');
443: WHEN OTHERS THEN

Line 453: x_return_status := fnd_api.g_ret_sts_unexp_error;

449: || ' Error is '
450: || SQLERRM);
451: END IF;
452:
453: x_return_status := fnd_api.g_ret_sts_unexp_error;
454: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
455: END fetch_step_phantoms;
456:
457: /*===========================================================================================

Line 495: x_return_status := fnd_api.g_ret_sts_success;

491: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
492: || l_api_name);
493: END IF;
494:
495: x_return_status := fnd_api.g_ret_sts_success;
496:
497: IF (p_batch_id IS NULL) THEN
498: RAISE no_keys;
499: END IF;

Line 519: x_return_status := fnd_api.g_ret_sts_error;

515: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
516: END IF;
517: EXCEPTION
518: WHEN no_keys THEN
519: x_return_status := fnd_api.g_ret_sts_error;
520: gme_common_pvt.log_message ('GME_NO_KEYS'
521: ,'TABLE_NAME'
522: ,'FETCH_LINE_PHANTOMS');
523: WHEN OTHERS THEN

Line 533: x_return_status := fnd_api.g_ret_sts_unexp_error;

529: || ' Error is '
530: || SQLERRM);
531: END IF;
532:
533: x_return_status := fnd_api.g_ret_sts_unexp_error;
534: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
535: END fetch_line_phantoms;
536: END gme_phantom_pvt;