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 66: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false

62: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
63: ,p_validity_rule_id IN NUMBER
64: ,p_use_workday_cal IN VARCHAR2
65: ,p_contiguity_override IN VARCHAR2
66: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
67: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
68: ,x_return_status OUT NOCOPY VARCHAR2)
69: IS
70: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PHANTOM';

Line 123: x_return_status := fnd_api.g_ret_sts_success;

119: || l_api_name);
120: END IF;
121:
122: /* Set the return status to success initially */
123: x_return_status := fnd_api.g_ret_sts_success;
124:
125: IF NOT (gme_material_details_dbl.fetch_row (p_material_detail_rec
126: ,x_material_detail_rec) ) THEN
127: RAISE material_detail_fetch_error;

Line 186: IF x_return_status <> fnd_api.g_ret_sts_success THEN

182: ,x_msg_data => l_msg_list
183: ,x_return_code => l_return_code
184: ,x_recipe_validity_out => l_validity_tbl);
185:
186: IF x_return_status <> fnd_api.g_ret_sts_success THEN
187: RAISE validity_fetch_error;
188: ELSIF l_validity_tbl.COUNT = 0 THEN
189: RAISE no_validity_found;
190: END IF;

Line 261: IF x_return_status <> fnd_api.g_ret_sts_success

257: || ' Create_batch returned '
258: || x_return_status);
259: END IF;
260:
261: IF x_return_status <> fnd_api.g_ret_sts_success
262: AND x_return_status <> gme_common_pvt.g_inv_short_err THEN
263: ROLLBACK TO SAVEPOINT create_auto_phantom;
264: RAISE batch_creation_failed;
265: END IF;

Line 326: x_return_status := fnd_api.g_ret_sts_success;

322: ,last_updated_by = gme_common_pvt.g_user_ident
323: ,last_update_login = gme_common_pvt.g_login_id
324: WHERE material_detail_id = p_material_detail_rec.material_detail_id;
325:
326: x_return_status := fnd_api.g_ret_sts_success;
327:
328: IF g_debug <= gme_debug.g_log_procedure THEN
329: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
330: END IF;

Line 333: x_return_status := fnd_api.g_ret_sts_error;

329: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
330: END IF;
331: EXCEPTION
332: 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
333: x_return_status := fnd_api.g_ret_sts_error;
334: WHEN no_validity_found THEN
335: x_return_status := 'W';
336: WHEN OTHERS THEN
337: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 346: x_return_status := fnd_api.g_ret_sts_unexp_error;

342: || ' Error is '
343: || SQLERRM);
344: END IF;
345:
346: x_return_status := fnd_api.g_ret_sts_unexp_error;
347: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
348: END create_phantom;
349:
350: /*===========================================================================================

Line 376: x_return_status := fnd_api.g_ret_sts_success;

372: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
373: || l_api_name);
374: END IF;
375:
376: x_return_status := fnd_api.g_ret_sts_success;
377:
378: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => p_batch_header
379: ,x_batch_header => l_batch_header) THEN
380: RAISE error_fetch_header;

Line 390: x_return_status := fnd_api.g_ret_sts_error;

386: RETURN FALSE;
387: END IF;
388: EXCEPTION
389: WHEN error_fetch_header THEN
390: x_return_status := fnd_api.g_ret_sts_error;
391: RETURN FALSE;
392: WHEN OTHERS THEN
393: IF g_debug <= gme_debug.g_log_unexpected THEN
394: gme_debug.put_line ( 'When others exception in '

Line 456: x_return_status := fnd_api.g_ret_sts_success;

452: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
453: || l_api_name);
454: END IF;
455:
456: x_return_status := fnd_api.g_ret_sts_success;
457:
458: IF (p_batch_id IS NULL) OR (p_batchstep_id IS NULL) THEN
459: RAISE no_keys;
460: END IF;

Line 474: x_return_status := fnd_api.g_ret_sts_error;

470: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
471: END IF;
472: EXCEPTION
473: WHEN no_keys THEN
474: x_return_status := fnd_api.g_ret_sts_error;
475: gme_common_pvt.log_message ('GME_NO_KEYS'
476: ,'TABLE_NAME'
477: ,'FETCH_STEP_PHANTOMS');
478: WHEN OTHERS THEN

Line 488: x_return_status := fnd_api.g_ret_sts_unexp_error;

484: || ' Error is '
485: || SQLERRM);
486: END IF;
487:
488: x_return_status := fnd_api.g_ret_sts_unexp_error;
489: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
490: END fetch_step_phantoms;
491:
492: /*===========================================================================================

Line 530: x_return_status := fnd_api.g_ret_sts_success;

526: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
527: || l_api_name);
528: END IF;
529:
530: x_return_status := fnd_api.g_ret_sts_success;
531:
532: IF (p_batch_id IS NULL) THEN
533: RAISE no_keys;
534: END IF;

Line 554: x_return_status := fnd_api.g_ret_sts_error;

550: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
551: END IF;
552: EXCEPTION
553: WHEN no_keys THEN
554: x_return_status := fnd_api.g_ret_sts_error;
555: gme_common_pvt.log_message ('GME_NO_KEYS'
556: ,'TABLE_NAME'
557: ,'FETCH_LINE_PHANTOMS');
558: WHEN OTHERS THEN

Line 568: x_return_status := fnd_api.g_ret_sts_unexp_error;

564: || ' Error is '
565: || SQLERRM);
566: END IF;
567:
568: x_return_status := fnd_api.g_ret_sts_unexp_error;
569: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
570: END fetch_line_phantoms;
571: END gme_phantom_pvt;