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.GMD_RECIPE_MIGRATION dependencies on FND_API

Line 5: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1: PACKAGE BODY gmd_recipe_migration AS
2: /* $Header: GMDRMIGB.pls 120.4 2006/09/19 14:37:13 txdaniel noship $ */
3: PROCEDURE migrate_recipe (
4: p_api_version IN NUMBER,
5: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6: p_commit IN VARCHAR2 := fnd_api.g_false,
7: x_return_status OUT NOCOPY VARCHAR2,
8: x_msg_count OUT NOCOPY NUMBER,
9: x_msg_data OUT NOCOPY VARCHAR2,

Line 6: p_commit IN VARCHAR2 := fnd_api.g_false,

2: /* $Header: GMDRMIGB.pls 120.4 2006/09/19 14:37:13 txdaniel noship $ */
3: PROCEDURE migrate_recipe (
4: p_api_version IN NUMBER,
5: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6: p_commit IN VARCHAR2 := fnd_api.g_false,
7: x_return_status OUT NOCOPY VARCHAR2,
8: x_msg_count OUT NOCOPY NUMBER,
9: x_msg_data OUT NOCOPY VARCHAR2,
10: p_recipe_no_choice IN VARCHAR2 )

Line 250: p_init_msg_list => fnd_api.g_false,

246: /* already exists in the database */
247: /* ================================= */
248: gmd_recipe_val.recipe_name (
249: p_api_version => 1.0,
250: p_init_msg_list => fnd_api.g_false,
251: p_commit => fnd_api.g_false,
252: p_recipe_no => l_recipe_no,
253: p_recipe_version => l_recipe_version,
254: x_return_status => l_return_status,

Line 251: p_commit => fnd_api.g_false,

247: /* ================================= */
248: gmd_recipe_val.recipe_name (
249: p_api_version => 1.0,
250: p_init_msg_list => fnd_api.g_false,
251: p_commit => fnd_api.g_false,
252: p_recipe_no => l_recipe_no,
253: p_recipe_version => l_recipe_version,
254: x_return_status => l_return_status,
255: x_msg_count => l_msg_count,

Line 262: x_return_status := fnd_api.g_ret_sts_error;

258: x_recipe_id => l_recipe_id );
259:
260: IF ( l_recipe_id IS NOT NULL )
261: THEN
262: x_return_status := fnd_api.g_ret_sts_error;
263: /* Thomas - Bug 2562007, Added the following loggin of message */
264: insert_message (p_source_table => 'FM_FORM_MST'
265: ,p_target_table => 'GMD_RECIPES'
266: ,p_source_id => l_recipe_no

Line 392: p_init_msg_list => fnd_api.g_false,

388: /* already exists in the database */
389: /* ================================= */
390: gmd_recipe_val.recipe_name (
391: p_api_version => 1.0,
392: p_init_msg_list => fnd_api.g_false,
393: p_commit => fnd_api.g_false,
394: p_recipe_no => l_recipe_no,
395: p_recipe_version => l_recipe_version,
396: x_return_status => l_return_status,

Line 393: p_commit => fnd_api.g_false,

389: /* ================================= */
390: gmd_recipe_val.recipe_name (
391: p_api_version => 1.0,
392: p_init_msg_list => fnd_api.g_false,
393: p_commit => fnd_api.g_false,
394: p_recipe_no => l_recipe_no,
395: p_recipe_version => l_recipe_version,
396: x_return_status => l_return_status,
397: x_msg_count => l_msg_count,

Line 404: x_return_status := fnd_api.g_ret_sts_error;

400: x_recipe_id => l_recipe_id );
401:
402: IF ( l_recipe_id IS NOT NULL )
403: THEN
404: x_return_status := fnd_api.g_ret_sts_error;
405: END IF;
406:
407: /* Get the recipe id from sequence */
408:

Line 776: WHERE NVL(orgn_code,fnd_api.g_miss_char) =

772: /* changed fm_form_eff to _bak as it was deleting new recipes */
773: FOR update_eff_rec IN
774: (SELECT fmeff_id
775: FROM fm_form_eff_bak
776: WHERE NVL(orgn_code,fnd_api.g_miss_char) =
777: NVL(get_dup_eff_rec.orgn_code,
778: fnd_api.g_miss_char )
779: AND item_id = get_dup_eff_rec.item_id
780: AND formula_use = get_dup_eff_rec.formula_use

Line 778: fnd_api.g_miss_char )

774: (SELECT fmeff_id
775: FROM fm_form_eff_bak
776: WHERE NVL(orgn_code,fnd_api.g_miss_char) =
777: NVL(get_dup_eff_rec.orgn_code,
778: fnd_api.g_miss_char )
779: AND item_id = get_dup_eff_rec.item_id
780: AND formula_use = get_dup_eff_rec.formula_use
781: /* Thomas - Bug 2562007, Added NVL condition as end date could be null */
782: AND NVL(end_date, fnd_api.g_miss_date) = NVL(get_dup_eff_rec.end_date, fnd_api.g_miss_date)

Line 782: AND NVL(end_date, fnd_api.g_miss_date) = NVL(get_dup_eff_rec.end_date, fnd_api.g_miss_date)

778: fnd_api.g_miss_char )
779: AND item_id = get_dup_eff_rec.item_id
780: AND formula_use = get_dup_eff_rec.formula_use
781: /* Thomas - Bug 2562007, Added NVL condition as end date could be null */
782: AND NVL(end_date, fnd_api.g_miss_date) = NVL(get_dup_eff_rec.end_date, fnd_api.g_miss_date)
783: AND start_date = get_dup_eff_rec.start_date
784: AND min_qty = get_dup_eff_rec.min_qty
785: AND max_qty = get_dup_eff_rec.max_qty
786: AND std_qty = get_dup_eff_rec.std_qty

Line 789: AND NVL ( routing_id, fnd_api.g_miss_num ) =

785: AND max_qty = get_dup_eff_rec.max_qty
786: AND std_qty = get_dup_eff_rec.std_qty
787: AND item_um = get_dup_eff_rec.item_um
788: AND preference = get_dup_eff_rec.preference
789: AND NVL ( routing_id, fnd_api.g_miss_num ) =
790: NVL (get_dup_eff_rec.routing_id,
791: fnd_api.g_miss_num )
792: AND formula_id = get_dup_eff_rec.formula_id
793: /* Thomas - Bug 2562007, Commented out the following checking */

Line 791: fnd_api.g_miss_num )

787: AND item_um = get_dup_eff_rec.item_um
788: AND preference = get_dup_eff_rec.preference
789: AND NVL ( routing_id, fnd_api.g_miss_num ) =
790: NVL (get_dup_eff_rec.routing_id,
791: fnd_api.g_miss_num )
792: AND formula_id = get_dup_eff_rec.formula_id
793: /* Thomas - Bug 2562007, Commented out the following checking */
794: /* and added the order by clause */
795: -- AND delete_mark = get_dup_eff_rec.delete_mark

Line 893: x_return_status := fnd_api.g_ret_sts_error;

889: ,p_source_id => 'Unknown'
890: ,p_target_id => 'Unknown'
891: ,p_message => error_msg
892: ,p_error_type => 'U');
893: x_return_status := fnd_api.g_ret_sts_error;
894: fnd_msg_pub.count_and_get (
895: p_count => x_msg_count,
896: p_data => x_msg_data );
897: END migrate_recipe;