APPS.GMD_ERES_UTILS dependencies on GMD_API_GRP

Line 486: GMD_API_GRP.update_end_date (p_substitution_id);

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

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

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

Line 1109: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

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

Line 1311: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

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

Line 1497: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

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

Line 1799: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

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

Line 2013: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

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

Line 2174: gmd_api_grp.log_message('GMD_RECORD_LOCKED',

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

Line 2213: gmd_api_grp.retrieve_recipe (

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

Line 2273: gmd_api_grp.retrieve_vr (

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