DBA Data[Home] [Help]

APPS.GMD_API_GRP dependencies on GMD_STATUS_CODE

Line 892: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN

888: gmd_debug.put_line('In GMD_API_GRP.validate_with_dep_entities - '||
889: 'About to check for Recipe - Vr dep status = '||l_status);
890: END IF;
891: IF (Cur_get_recp_sts%FOUND) THEN
892: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN
893: IF (l_debug = 'Y') THEN
894: gmd_debug.put_line('In GMD_API_GRP.validate_with_dep_entities - '||
895: ' There is VR dependency for this Recipe = '||v_entity_Id);
896: END IF;

Line 907: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN

903: ELSIF(v_type = 'ROUTING') THEN
904: OPEN Cur_get_rout_sts(v_entity_id);
905: FETCH Cur_get_rout_sts INTO l_status;
906: IF (Cur_get_rout_sts%FOUND) THEN
907: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN
908: l_parent_check := TRUE;
909: FND_MESSAGE.SET_NAME('GMD','GMD_ROUTING_RECIPE_DEP');
910: END IF;
911: END IF;

Line 917: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN

913: ELSIF(V_type = 'FORMULA') THEN
914: OPEN Cur_get_form_sts(v_entity_id);
915: FETCH Cur_get_form_sts INTO l_status;
916: IF (Cur_get_form_sts%FOUND) THEN
917: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN
918: l_parent_check := TRUE;
919: FND_MESSAGE.SET_NAME('GMD','GMD_FORMULA_RECIPE_DEP');
920: END IF;
921: END IF;

Line 927: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN

923: ELSIF(v_type = 'OPERATION') THEN
924: OPEN Cur_get_oprn_sts(v_entity_id);
925: FETCH Cur_get_oprn_sts INTO l_status;
926: IF (Cur_get_oprn_sts%FOUND) THEN
927: IF (NOT gmd_status_code.check_parent_status(v_type,v_entity_id)) THEN
928: l_parent_check := TRUE;
929: FND_MESSAGE.SET_NAME('GMD','GMD_OPERATION_ROUT_DEP');
930: END IF;
931: END IF;