DBA Data[Home] [Help]

APPS.GMD_API_GRP dependencies on GMD_STATUS_CODE

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

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

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

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

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

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

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

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