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.11.12020000.4 2013/01/24 11:33:27 guobxu 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.11.12020000.4 2013/01/24 11:33:27 guobxu 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 802: gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id := NULL;

798: p_recipe_vr_rec.max_qty := p_recipe_vr_rec.std_qty;
799: END IF;
800:
801: /* Insert into the recipe validity rules table */
802: gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id := NULL;
803: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
804: GMD_RECIPE_DETAIL_PVT.create_recipe_vr (p_recipe_vr_rec => p_recipe_vr_rec
805: ,p_recipe_vr_flex_rec => p_recipe_vr_flex_rec
806: ,x_return_status => x_return_status);

Line 804: GMD_RECIPE_DETAIL_PVT.create_recipe_vr (p_recipe_vr_rec => p_recipe_vr_rec

800:
801: /* Insert into the recipe validity rules table */
802: gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id := NULL;
803: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
804: GMD_RECIPE_DETAIL_PVT.create_recipe_vr (p_recipe_vr_rec => p_recipe_vr_rec
805: ,p_recipe_vr_flex_rec => p_recipe_vr_flex_rec
806: ,x_return_status => x_return_status);
807: IF x_return_status <> FND_API.g_ret_sts_success THEN
808: RAISE Recipe_VR_insert_failure;

Line 826: , p_entity_id => gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id

822: IF (l_entity_status.entity_status <> 100) THEN
823: Gmd_status_pub.modify_status ( p_api_version => 1
824: , p_init_msg_list => TRUE
825: , p_entity_name => 'VALIDITY'
826: , p_entity_id => gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id
827: , p_entity_no => NULL
828: , p_entity_version => NULL
829: , p_to_status => l_entity_status.entity_status
830: , p_ignore_flag => FALSE

Line 834: gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id := NULL;

830: , p_ignore_flag => FALSE
831: , x_message_count => x_msg_count
832: , x_message_list => x_msg_data
833: , x_return_status => X_return_status);
834: gmd_recipe_detail_pvt.pkg_recipe_validity_rule_id := NULL;
835: IF x_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
836: RAISE default_status_err;
837: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')
838: END IF;--l_entity_status.entity_status

Line 1115: GMD_RECIPE_DETAIL_PVT.create_recipe_mtl (p_recipe_mtl_rec => p_recipe_mtl_rec

1111: /* ======================================= */
1112:
1113: /* Insert into the recipe materials table */
1114: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1115: GMD_RECIPE_DETAIL_PVT.create_recipe_mtl (p_recipe_mtl_rec => p_recipe_mtl_rec
1116: ,p_recipe_mtl_flex_rec => p_recipe_mtl_flex_rec
1117: ,x_return_status => x_return_status);
1118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1119: RAISE insert_rcp_mat_failure;

Line 1351: GMD_RECIPE_DETAIL_PVT.update_recipe_process_loss (p_recipe_detail_rec => p_recipe_detail_rec

1347: END IF;
1348:
1349: /* Update into the recipe process loss table */
1350: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1351: GMD_RECIPE_DETAIL_PVT.update_recipe_process_loss (p_recipe_detail_rec => p_recipe_detail_rec
1352: ,x_return_status => x_return_status);
1353: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1354: RAISE update_pr_loss_failure;
1355: END IF;

Line 1572: GMD_RECIPE_DETAIL_PVT.update_recipe_customers (p_recipe_detail_rec => p_recipe_detail_rec

1568:
1569: /* Update the recipe customer table */
1570: /* only who columns needs to be updated */
1571: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1572: GMD_RECIPE_DETAIL_PVT.update_recipe_customers (p_recipe_detail_rec => p_recipe_detail_rec
1573: ,x_return_status => x_return_status);
1574: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1575: RAISE update_rcp_cust_failure;
1576: END IF;

Line 2038: GMD_RECIPE_DETAIL_PVT.UPDATE_RECIPE_VR(p_recipe_vr_rec => p_recipe_vr_rec

2034: p_flex_update_rec.attribute_category := l_flex_update_rec.attribute_category;
2035: END IF;
2036:
2037: /* Update recipe validity rules table */
2038: GMD_RECIPE_DETAIL_PVT.UPDATE_RECIPE_VR(p_recipe_vr_rec => p_recipe_vr_rec
2039: ,p_flex_update_rec => p_flex_update_rec
2040: ,x_return_status => x_return_status);
2041: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2042: RAISE Update_VR_Failure;

Line 2520: GMD_RECIPE_DETAIL_PVT.RECIPE_ROUTING_STEPS (p_recipe_detail_rec => p_recipe_detail_rec

2516: END IF;
2517: CLOSE Flex_cur;
2518:
2519: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2520: GMD_RECIPE_DETAIL_PVT.RECIPE_ROUTING_STEPS (p_recipe_detail_rec => p_recipe_detail_rec
2521: ,p_flex_insert_rec => p_flex_insert_rec
2522: ,p_flex_update_rec => p_flex_update_rec
2523: ,x_return_status => x_return_status);
2524: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2965: GMD_RECIPE_DETAIL_PVT.RECIPE_ORGN_OPERATIONS (p_recipe_detail_rec => p_recipe_detail_rec

2961: END IF; /* end of flex_cur%FOUND */
2962: CLOSE Flex_cur; -- Bug 6972110
2963:
2964: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2965: GMD_RECIPE_DETAIL_PVT.RECIPE_ORGN_OPERATIONS (p_recipe_detail_rec => p_recipe_detail_rec
2966: ,p_flex_insert_rec => p_flex_insert_rec
2967: ,p_flex_update_rec => p_flex_update_rec
2968: ,x_return_status => x_return_status);
2969: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3509: GMD_RECIPE_DETAIL_PVT.recipe_orgn_resources (p_recipe_detail_rec => p_recipe_detail_rec

3505: END IF; /* end of flex_cur%FOUND */
3506: CLOSE Flex_cur; -- Bug 6972110
3507:
3508: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3509: GMD_RECIPE_DETAIL_PVT.recipe_orgn_resources (p_recipe_detail_rec => p_recipe_detail_rec
3510: ,p_flex_insert_rec => p_flex_insert_rec
3511: ,p_flex_update_rec => p_flex_update_rec
3512: ,x_return_status => x_return_status);
3513: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

3550: p_data => x_msg_data );
3551:
3552: END RECIPE_ORGN_RESOURCES;
3553:
3554: END GMD_RECIPE_DETAIL; /* Package end */