DBA Data[Home] [Help]

APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_API_GRP

Line 662: := GMD_API_GRP.get_object_name_version

658:
659: BEGIN
660: IF (get_object_rec.object_vers IS NULL) THEN
661: get_object_rec.object_name
662: := GMD_API_GRP.get_object_name_version
663: (get_object_rec.object_type
664: ,get_object_rec.object_id
665: ,'NAME');
666: get_object_rec.object_vers

Line 667: := GMD_API_GRP.get_object_name_version

663: (get_object_rec.object_type
664: ,get_object_rec.object_id
665: ,'NAME');
666: get_object_rec.object_vers
667: := GMD_API_GRP.get_object_name_version
668: (get_object_rec.object_type
669: ,get_object_rec.object_id
670: ,'VERSION');
671: l_object_name_vers := get_object_rec.object_name||' - '||

Line 689: IF NOT gmd_api_grp.Check_orgn_access( Entity => get_object_rec.object_type,

685: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
686:
687: -- NPD Conv.
688: -- Check if the Entity Owning organization is available for the responsibility
689: IF NOT gmd_api_grp.Check_orgn_access( Entity => get_object_rec.object_type,
690: Entity_id => get_object_rec.object_id) THEN
691: RAISE NO_UPDATE_EXCEPTION;
692: END IF;
693:

Line 733: l_status_type := GMD_API_GRP.get_object_status_type

729: RAISE No_Update_Exception;
730: END IF;
731: ELSE -- for all other object-replace types.
732: -- Get the status type for this object
733: l_status_type := GMD_API_GRP.get_object_status_type
734: ( get_object_rec.object_type
735: , get_object_rec.object_id);
736:
737: OPEN Check_version_enabled(l_status_type);

Line 749: GMD_API_GRP.Validate_with_dep_entities

745: ' and the version flag API passes = '||get_object_rec.version_flag||
746: ' and version enabled check = '||l_version_enabled);
747:
748: IF (get_object_rec.object_type <> 'VALIDITY') THEN
749: GMD_API_GRP.Validate_with_dep_entities
750: (get_object_rec.object_type,
751: get_object_rec.object_id,
752: l_dependent_val);
753: IF l_dependent_val THEN

Line 769: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,

765: FROM fm_form_mst_b fm
766: WHERE fm.formula_id = get_object_rec.object_id;
767:
768: -- Get the Formula version control for the entity orgn.
769: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,
770: P_parm_name => 'GMD_FORMULA_VERSION_CONTROL',
771: P_parm_value => l_vers_cntrl,
772: x_return_status => l_return_stat);
773:

Line 1007: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,

1003: FROM gmd_recipes_b rcp
1004: WHERE rcp.recipe_id = get_object_rec.object_id;
1005:
1006: -- Get the Recipe version control for the entity orgn.
1007: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,
1008: P_parm_name => 'GMD_RECIPE_VERSION_CONTROL',
1009: P_parm_value => l_vers_cntrl,
1010: x_return_status => l_return_stat);
1011:

Line 1045: IF NOT GMD_API_GRP.Check_orgn_access

1041: ||' : About check if Recipe update is allowed, Recipe Id = '
1042: ||get_object_rec.object_id);
1043: END IF;
1044:
1045: IF NOT GMD_API_GRP.Check_orgn_access
1046: (Entity => 'RECIPE'
1047: ,Entity_id => get_object_rec.object_id) THEN
1048: RAISE NO_UPDATE_EXCEPTION;
1049: ELSE

Line 1067: END IF; -- check for GMD_API_GRP.Check_orgn_access

1063: l_action_flag := 'N';
1064: END IF;
1065: END IF; -- check for recipe columns end here
1066: END IF; -- check for status type ends here
1067: END IF; -- check for GMD_API_GRP.Check_orgn_access
1068: END IF; -- check for version control on / off
1069:
1070: IF (l_debug = 'Y') THEN
1071: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : For Recipe Action flag = '

Line 1111: GMD_API_GRP.check_item_exists

1107: FETCH get_formula_id INTO l_form_id;
1108: CLOSE get_formula_id;
1109:
1110: -- Check if formula items belong to the new recipe organization
1111: GMD_API_GRP.check_item_exists
1112: (p_formula_id => l_form_id
1113: ,p_organization_id => l_organization_id
1114: ,x_return_status => l_status );
1115:

Line 1118: -- is already added by GMD_API_GRP.check_item_exists

1114: ,x_return_status => l_status );
1115:
1116: IF l_status <> FND_API.g_ret_sts_success THEN
1117: -- Bug 5531791 Removed FND_MSG_PUB.GET and FND_MSG_PUB.ADD as the message
1118: -- is already added by GMD_API_GRP.check_item_exists
1119: RAISE NO_UPDATE_EXCEPTION;
1120: END IF;
1121:
1122: END IF;

Line 1133: GMD_API_GRP.check_item_exists

1129: FETCH Cur_get_recipe_org INTO l_org_id;
1130: CLOSE Cur_get_recipe_org;
1131:
1132: -- Check if new formula's items belong to the recipe organization
1133: GMD_API_GRP.check_item_exists
1134: (p_formula_id => l_formula_id
1135: ,p_organization_id => l_org_id
1136: ,x_return_status => l_status );
1137:

Line 1140: -- is already added by GMD_API_GRP.check_item_exists

1136: ,x_return_status => l_status );
1137:
1138: IF l_status <> FND_API.g_ret_sts_success THEN
1139: -- Bug 5531791 Removed FND_MSG_PUB.GET and FND_MSG_PUB.ADD as the message
1140: -- is already added by GMD_API_GRP.check_item_exists
1141: RAISE NO_UPDATE_EXCEPTION;
1142: END IF;
1143: -- Bug 5531717 add code to check for ovverride orgn
1144: FOR l_recipe_override_orgn IN Cur_get_recipe_override_org(get_object_rec.object_id)

Line 1147: GMD_API_GRP.check_item_exists

1143: -- Bug 5531717 add code to check for ovverride orgn
1144: FOR l_recipe_override_orgn IN Cur_get_recipe_override_org(get_object_rec.object_id)
1145: LOOP
1146: -- Check if new formula's items belong to the recipe organization
1147: GMD_API_GRP.check_item_exists
1148: (p_formula_id => l_formula_id
1149: ,p_organization_id => l_recipe_override_orgn.organization_id
1150: ,x_return_status => l_status );
1151:

Line 1188: GMD_API_GRP.get_object_name_version

1184:
1185: IF (get_object_rec.replace_type = 'FORMULA_ID' ) THEN
1186: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1187: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1188: GMD_API_GRP.get_object_name_version
1189: ('FORMULA'
1190: ,get_object_rec.new_name)
1191: );
1192: ELSIF (get_object_rec.replace_type = 'ROUTING_ID' ) THEN

Line 1195: GMD_API_GRP.get_object_name_version

1191: );
1192: ELSIF (get_object_rec.replace_type = 'ROUTING_ID' ) THEN
1193: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1194: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1195: GMD_API_GRP.get_object_name_version
1196: ('ROUTING'
1197: ,get_object_rec.new_name)
1198: );
1199: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN

Line 1279: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,

1275: FROM gmd_routings_b rot
1276: WHERE rot.routing_id = get_object_rec.object_id;
1277:
1278: -- Get the Routing version control for the entity orgn.
1279: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,
1280: P_parm_name => 'GMD_ROUTING_VERSION_CONTROL',
1281: P_parm_value => l_vers_cntrl,
1282: x_return_status => l_return_stat);
1283:

Line 1376: GMD_API_GRP.get_object_name_version

1372:
1373: IF (get_object_rec.replace_type = 'OPRN_ID') THEN
1374: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1375: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1376: GMD_API_GRP.get_object_name_version
1377: ('OPERATION'
1378: ,get_object_rec.new_name)
1379: );
1380: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN

Line 1487: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,

1483: FROM gmd_operations_b opr
1484: WHERE opr.oprn_id = get_object_rec.object_id;
1485:
1486: -- Get the Operation version control for the entity orgn.
1487: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,
1488: P_parm_name => 'GMD_OPERATION_VERSION_CONTROL',
1489: P_parm_value => l_vers_cntrl,
1490: x_return_status => l_return_stat);
1491:

Line 1722: IF NOT GMD_API_GRP.Check_orgn_access

1718: IF (l_action_flag = 'U') THEN
1719: OPEN Cur_get_validity(get_object_rec.object_id);
1720: FETCH Cur_get_validity INTO l_obj_id;
1721: CLOSE Cur_get_validity;
1722: IF NOT GMD_API_GRP.Check_orgn_access
1723: (Entity => 'RECIPE'
1724: ,Entity_id => l_obj_id) THEN
1725: RAISE NO_UPDATE_EXCEPTION;
1726: END IF;

Line 1748: GMD_API_GRP.check_item_exists

1744: FETCH get_recp_formula_id INTO l_form_id;
1745: CLOSE get_recp_formula_id;
1746:
1747: -- Check if formula items belong to the new organization
1748: GMD_API_GRP.check_item_exists
1749: (p_formula_id => l_form_id
1750: ,p_organization_id => get_object_rec.new_name
1751: ,x_return_status => l_status );
1752: IF l_status <> FND_API.g_ret_sts_success THEN

Line 1754: -- is already added by GMD_API_GRP.check_item_exists

1750: ,p_organization_id => get_object_rec.new_name
1751: ,x_return_status => l_status );
1752: IF l_status <> FND_API.g_ret_sts_success THEN
1753: -- Bug 5531791 Removed FND_MSG_PUB.GET and FND_MSG_PUB.ADD as the message
1754: -- is already added by GMD_API_GRP.check_item_exists
1755: RAISE NO_UPDATE_EXCEPTION;
1756: END IF;
1757: ELSE
1758: p_validity_rules_table(1).p_col_to_update := get_object_rec.replace_type;

Line 1804: GMD_API_GRP.get_object_status_type

1800: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1801: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1802: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1803: get_status_meaning(
1804: GMD_API_GRP.get_object_status_type
1805: (get_object_rec.object_type
1806: , get_object_rec.object_id)
1807: ) );
1808: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN

Line 1811: GMD_API_GRP.get_object_name_version

1807: ) );
1808: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1809: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1810: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1811: GMD_API_GRP.get_object_name_version
1812: ('ROUTING',get_object_rec.new_name)
1813: );
1814: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN
1815: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);

Line 1817: GMD_API_GRP.get_object_name_version

1813: );
1814: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN
1815: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1816: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1817: GMD_API_GRP.get_object_name_version
1818: ('OPERATION',get_object_rec.new_name)
1819: );
1820: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN
1821: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);

Line 1823: GMD_API_GRP.get_object_name_version

1819: );
1820: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN
1821: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1822: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1823: GMD_API_GRP.get_object_name_version
1824: ('FORMULA',get_object_rec.new_name)
1825: );
1826: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
1827: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);

Line 1906: GMD_API_GRP.get_object_name_version

1902: get_status_meaning(get_object_rec.new_name) );
1903: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1904: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1905: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1906: GMD_API_GRP.get_object_name_version
1907: ('ROUTING'
1908: ,get_object_rec.new_name)
1909: );
1910: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN

Line 1913: GMD_API_GRP.get_object_name_version

1909: );
1910: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN
1911: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1912: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1913: GMD_API_GRP.get_object_name_version
1914: ('OPERATION'
1915: ,get_object_rec.new_name)
1916: );
1917: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN

Line 1920: GMD_API_GRP.get_object_name_version

1916: );
1917: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN
1918: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1919: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1920: GMD_API_GRP.get_object_name_version
1921: ('FORMULA'
1922: ,get_object_rec.new_name)
1923: );
1924: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN

Line 1977: GMD_API_GRP.get_object_name_version

1973: get_status_meaning(get_object_rec.new_name) );
1974: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1975: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1976: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1977: GMD_API_GRP.get_object_name_version
1978: ('ROUTING'
1979: ,get_object_rec.new_name)
1980: );
1981: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN

Line 1984: GMD_API_GRP.get_object_name_version

1980: );
1981: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN
1982: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1983: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1984: GMD_API_GRP.get_object_name_version
1985: ('OPERATION'
1986: ,get_object_rec.new_name)
1987: );
1988: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN

Line 1991: GMD_API_GRP.get_object_name_version

1987: );
1988: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN
1989: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1990: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1991: GMD_API_GRP.get_object_name_version
1992: ('FORMULA'
1993: ,get_object_rec.new_name)
1994: );
1995: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN