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_DETAIL dependencies on GMD_RECIPE_DETAIL

Line 1: PACKAGE BODY GMD_RECIPE_DETAIL AS

1: PACKAGE BODY GMD_RECIPE_DETAIL AS
2: /* $Header: GMDPRCDB.pls 120.6.12010000.2 2008/11/12 18:25:50 rnalla ship $ */
3:
4: /* Define any variable specific to this package */
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_RECIPE_DETAIL' ;

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_RECIPE_DETAIL' ;

1: PACKAGE BODY GMD_RECIPE_DETAIL AS
2: /* $Header: GMDPRCDB.pls 120.6.12010000.2 2008/11/12 18:25:50 rnalla ship $ */
3:
4: /* Define any variable specific to this package */
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_RECIPE_DETAIL' ;
6:
7: /* ============================================= */
8: /* Procedure: */
9: /* Create_Recipe_Process_loss */

Line 178: GMD_RECIPE_DETAIL_PVT.create_recipe_process_loss (p_recipe_detail_rec => p_recipe_detail_rec

174: p_recipe_detail_rec.contiguous_ind := 0;
175: END IF;
176:
177: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
178: GMD_RECIPE_DETAIL_PVT.create_recipe_process_loss (p_recipe_detail_rec => p_recipe_detail_rec
179: ,x_return_status => x_return_status);
180: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
181: RAISE FND_API.G_EXC_ERROR;
182: END IF;

Line 441: GMD_RECIPE_DETAIL_PVT.create_recipe_customers (p_recipe_detail_rec => p_recipe_detail_rec

437: END IF;
438: END IF;
439:
440: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
441: GMD_RECIPE_DETAIL_PVT.create_recipe_customers (p_recipe_detail_rec => p_recipe_detail_rec
442: ,x_return_status => x_return_status);
443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
444: RAISE Recipe_Cust_ins_failure;
445: END IF;

Line 780: gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id := NULL;

776: p_recipe_vr_rec.max_qty := p_recipe_vr_rec.std_qty;
777: END IF;
778:
779: /* Insert into the recipe validity rules table */
780: gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id := NULL;
781: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
782: GMD_RECIPE_DETAIL_PVT.create_recipe_vr (p_recipe_vr_rec => p_recipe_vr_rec
783: ,p_recipe_vr_flex_rec => p_recipe_vr_flex_rec
784: ,x_return_status => x_return_status);

Line 782: GMD_RECIPE_DETAIL_PVT.create_recipe_vr (p_recipe_vr_rec => p_recipe_vr_rec

778:
779: /* Insert into the recipe validity rules table */
780: gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id := NULL;
781: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
782: GMD_RECIPE_DETAIL_PVT.create_recipe_vr (p_recipe_vr_rec => p_recipe_vr_rec
783: ,p_recipe_vr_flex_rec => p_recipe_vr_flex_rec
784: ,x_return_status => x_return_status);
785: IF x_return_status <> FND_API.g_ret_sts_success THEN
786: RAISE Recipe_VR_insert_failure;

Line 804: , p_entity_id => gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id

800: IF (l_entity_status.entity_status <> 100) THEN
801: Gmd_status_pub.modify_status ( p_api_version => 1
802: , p_init_msg_list => TRUE
803: , p_entity_name => 'VALIDITY'
804: , p_entity_id => gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id
805: , p_entity_no => NULL
806: , p_entity_version => NULL
807: , p_to_status => l_entity_status.entity_status
808: , p_ignore_flag => FALSE

Line 812: gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id := NULL;

808: , p_ignore_flag => FALSE
809: , x_message_count => x_msg_count
810: , x_message_list => x_msg_data
811: , x_return_status => X_return_status);
812: gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id := NULL;
813: IF x_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
814: RAISE default_status_err;
815: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')
816: END IF;--l_entity_status.entity_status

Line 1030: GMD_RECIPE_DETAIL_PVT.create_recipe_mtl (p_recipe_mtl_rec => p_recipe_mtl_rec

1026: END IF;
1027:
1028: /* Insert into the recipe materials table */
1029: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1030: GMD_RECIPE_DETAIL_PVT.create_recipe_mtl (p_recipe_mtl_rec => p_recipe_mtl_rec
1031: ,p_recipe_mtl_flex_rec => p_recipe_mtl_flex_rec
1032: ,x_return_status => x_return_status);
1033: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1034: RAISE insert_rcp_mat_failure;

Line 1252: GMD_RECIPE_DETAIL_PVT.update_recipe_process_loss (p_recipe_detail_rec => p_recipe_detail_rec

1248: END IF;
1249:
1250: /* Update into the recipe process loss table */
1251: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1252: GMD_RECIPE_DETAIL_PVT.update_recipe_process_loss (p_recipe_detail_rec => p_recipe_detail_rec
1253: ,x_return_status => x_return_status);
1254: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1255: RAISE update_pr_loss_failure;
1256: END IF;

Line 1473: GMD_RECIPE_DETAIL_PVT.update_recipe_customers (p_recipe_detail_rec => p_recipe_detail_rec

1469:
1470: /* Update the recipe customer table */
1471: /* only who columns needs to be updated */
1472: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1473: GMD_RECIPE_DETAIL_PVT.update_recipe_customers (p_recipe_detail_rec => p_recipe_detail_rec
1474: ,x_return_status => x_return_status);
1475: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1476: RAISE update_rcp_cust_failure;
1477: END IF;

Line 1917: GMD_RECIPE_DETAIL_PVT.UPDATE_RECIPE_VR(p_recipe_vr_rec => p_recipe_vr_rec

1913: p_flex_update_rec.attribute_category := l_flex_update_rec.attribute_category;
1914: END IF;
1915:
1916: /* Update recipe validity rules table */
1917: GMD_RECIPE_DETAIL_PVT.UPDATE_RECIPE_VR(p_recipe_vr_rec => p_recipe_vr_rec
1918: ,p_flex_update_rec => p_flex_update_rec
1919: ,x_return_status => x_return_status);
1920: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1921: RAISE Update_VR_Failure;

Line 2393: GMD_RECIPE_DETAIL_PVT.RECIPE_ROUTING_STEPS (p_recipe_detail_rec => p_recipe_detail_rec

2389: END IF;
2390: CLOSE Flex_cur;
2391:
2392: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2393: GMD_RECIPE_DETAIL_PVT.RECIPE_ROUTING_STEPS (p_recipe_detail_rec => p_recipe_detail_rec
2394: ,p_flex_insert_rec => p_flex_insert_rec
2395: ,p_flex_update_rec => p_flex_update_rec
2396: ,x_return_status => x_return_status);
2397: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2838: GMD_RECIPE_DETAIL_PVT.RECIPE_ORGN_OPERATIONS (p_recipe_detail_rec => p_recipe_detail_rec

2834: END IF; /* end of flex_cur%FOUND */
2835: CLOSE Flex_cur; -- Bug 6972110
2836:
2837: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2838: GMD_RECIPE_DETAIL_PVT.RECIPE_ORGN_OPERATIONS (p_recipe_detail_rec => p_recipe_detail_rec
2839: ,p_flex_insert_rec => p_flex_insert_rec
2840: ,p_flex_update_rec => p_flex_update_rec
2841: ,x_return_status => x_return_status);
2842: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3346: GMD_RECIPE_DETAIL_PVT.recipe_orgn_resources (p_recipe_detail_rec => p_recipe_detail_rec

3342: END IF; /* end of flex_cur%FOUND */
3343: CLOSE Flex_cur; -- Bug 6972110
3344:
3345: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3346: GMD_RECIPE_DETAIL_PVT.recipe_orgn_resources (p_recipe_detail_rec => p_recipe_detail_rec
3347: ,p_flex_insert_rec => p_flex_insert_rec
3348: ,p_flex_update_rec => p_flex_update_rec
3349: ,x_return_status => x_return_status);
3350: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3391: END GMD_RECIPE_DETAIL; /* Package end */

3387: p_data => x_msg_data );
3388:
3389: END RECIPE_ORGN_RESOURCES;
3390:
3391: END GMD_RECIPE_DETAIL; /* Package end */