APPS.GMD_ERES_UTILS dependencies on GMD_API_GRP

Line 488: GMD_API_GRP.update_end_date (p_substitution_id);

484: WHERE substitution_id = p_substitution_id;
485: UPDATE GMD_FORMULA_SUBSTITUTION SET Associated_flag ='Y'
486: WHERE substitution_id = P_substitution_id;
487:
488: GMD_API_GRP.update_end_date (p_substitution_id);
489:
490: ELSIF p_signature_status = 'PENDING' THEN
491: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status
492: ,p_to_status => p_to_status);

Line 1006: l_access_type_ind := GMD_API_GRP.GET_FORMULA_ACCESS_TYPE(p_formula_id => p_formula_id,

1002: OPEN get_orgn_code(p_formula_id);
1003: FETCH get_orgn_code INTO l_owner_organization_id;
1004: CLOSE get_orgn_code;
1005: --Get the access type of the formula
1006: l_access_type_ind := GMD_API_GRP.GET_FORMULA_ACCESS_TYPE(p_formula_id => p_formula_id,
1007: p_owner_organization_id => l_owner_organization_id);
1008: IF (l_access_type_ind ='V') THEN
1009: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORM_UPD_NO_ACCESS');
1010: FND_MSG_PUB.ADD;

Line 1111: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

1107: X_return_status := FND_API.g_ret_sts_error;
1108: IF (l_debug = 'Y') THEN
1109: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1110: END IF;
1111: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1112: 'TABLE_NAME',
1113: 'FM_FORM_MST_B',
1114: 'RECORD',
1115: 'FORMULA_NO : FORMULA_VERS = ',

Line 1313: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

1309: X_return_status := FND_API.g_ret_sts_error;
1310: IF (l_debug = 'Y') THEN
1311: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1312: END IF;
1313: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1314: 'TABLE_NAME',
1315: 'GMD_OPERATIONS_B',
1316: 'RECORD',
1317: 'OPRN_NO : OPRN_VERS = ',

Line 1499: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

1495: X_return_status := FND_API.g_ret_sts_error;
1496: IF (l_debug = 'Y') THEN
1497: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1498: END IF;
1499: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1500: 'TABLE_NAME',
1501: 'GMD_ROUTINGS_B',
1502: 'RECORD',
1503: 'ROUTING_NO : ROUTING_VERS = ',

Line 1801: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

1797: X_return_status := FND_API.g_ret_sts_error;
1798: IF (l_debug = 'Y') THEN
1799: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1800: END IF;
1801: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1802: 'TABLE_NAME',
1803: 'GMD_RECIPES_B',
1804: 'RECORD',
1805: 'RECIPE_NO : RECIPE_VERSION = ',

Line 2015: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

2011: X_return_status := FND_API.g_ret_sts_error;
2012: IF (l_debug = 'Y') THEN
2013: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
2014: END IF;
2015: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
2016: 'TABLE_NAME',
2017: 'GMD_RECIPE_VALIDITY_RULES',
2018: 'RECORD',
2019: 'RECIPE_VALIDITY_RULE_ID = ',

Line 2176: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

2172: X_return_status := FND_API.g_ret_sts_error;
2173: IF (l_debug = 'Y') THEN
2174: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
2175: END IF;
2176: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
2177: 'TABLE_NAME',
2178: 'GMD_ITEM_SUBSTITUTION_HDR_B',
2179: 'RECORD',
2180: 'SUBSTITUTION_ID = ',

Line 2215: gmd_api_grp.retrieve_recipe (

2211: l_return_status VARCHAR2(1);
2212: BEGIN
2213: l_return_status := FND_API.G_RET_STS_SUCCESS;
2214:
2215: gmd_api_grp.retrieve_recipe (
2216: p_formula_id => p_formula_id,
2217: l_recipe_tbl => X_recipe_tbl,
2218: l_recipe_flex => X_recipe_flex,
2219: x_return_status => l_return_status);

Line 2275: gmd_api_grp.retrieve_vr (

2271:
2272: BEGIN
2273: l_return_status := FND_API.G_RET_STS_SUCCESS;
2274:
2275: gmd_api_grp.retrieve_vr (
2276: p_formula_id => p_formula_id,
2277: l_recipe_vr_tbl => X_recipe_vr,
2278: l_vr_flex => X_vr_flex,
2279: x_return_status => l_return_status );