DBA Data[Home] [Help]

APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_API_GRP

Line 509: := GMD_API_GRP.get_object_name_version

505:
506: BEGIN
507: IF (get_object_rec.object_vers IS NULL) THEN
508: get_object_rec.object_name
509: := GMD_API_GRP.get_object_name_version
510: (get_object_rec.object_type
511: ,get_object_rec.object_id
512: ,'NAME');
513: get_object_rec.object_vers

Line 514: := GMD_API_GRP.get_object_name_version

510: (get_object_rec.object_type
511: ,get_object_rec.object_id
512: ,'NAME');
513: get_object_rec.object_vers
514: := GMD_API_GRP.get_object_name_version
515: (get_object_rec.object_type
516: ,get_object_rec.object_id
517: ,'VERSION');
518: l_object_name_vers := get_object_rec.object_name||' - '||

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

532: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
533:
534: -- NPD Conv.
535: -- Check if the Entity Owning organization is available for the responsibility
536: IF NOT gmd_api_grp.Check_orgn_access( Entity => get_object_rec.object_type,
537: Entity_id => get_object_rec.object_id) THEN
538: RAISE NO_UPDATE_EXCEPTION;
539: END IF;
540:

Line 580: l_status_type := GMD_API_GRP.get_object_status_type

576: RAISE No_Update_Exception;
577: END IF;
578: ELSE -- for all other object-replace types.
579: -- Get the status type for this object
580: l_status_type := GMD_API_GRP.get_object_status_type
581: ( get_object_rec.object_type
582: , get_object_rec.object_id);
583:
584: OPEN Check_version_enabled(l_status_type);

Line 596: GMD_API_GRP.Validate_with_dep_entities

592: ' and the version flag API passes = '||get_object_rec.version_flag||
593: ' and version enabled check = '||l_version_enabled);
594:
595: IF (get_object_rec.object_type <> 'VALIDITY') THEN
596: GMD_API_GRP.Validate_with_dep_entities
597: (get_object_rec.object_type,
598: get_object_rec.object_id,
599: l_dependent_val);
600: IF l_dependent_val THEN

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

612: FROM fm_form_mst_b fm
613: WHERE fm.formula_id = get_object_rec.object_id;
614:
615: -- Get the Formula version control for the entity orgn.
616: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,
617: P_parm_name => 'GMD_FORMULA_VERSION_CONTROL',
618: P_parm_value => l_vers_cntrl,
619: x_return_status => l_return_stat);
620:

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

850: FROM gmd_recipes_b rcp
851: WHERE rcp.recipe_id = get_object_rec.object_id;
852:
853: -- Get the Recipe version control for the entity orgn.
854: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,
855: P_parm_name => 'GMD_RECIPE_VERSION_CONTROL',
856: P_parm_value => l_vers_cntrl,
857: x_return_status => l_return_stat);
858:

Line 892: IF NOT GMD_API_GRP.Check_orgn_access

888: ||' : About check if Recipe update is allowed, Recipe Id = '
889: ||get_object_rec.object_id);
890: END IF;
891:
892: IF NOT GMD_API_GRP.Check_orgn_access
893: (Entity => 'RECIPE'
894: ,Entity_id => get_object_rec.object_id) THEN
895: RAISE NO_UPDATE_EXCEPTION;
896: ELSE

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

910: l_action_flag := 'N';
911: END IF;
912: END IF; -- check for recipe columns end here
913: END IF; -- check for status type ends here
914: END IF; -- check for GMD_API_GRP.Check_orgn_access
915: END IF; -- check for version control on / off
916:
917: IF (l_debug = 'Y') THEN
918: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : For Recipe Action flag = '

Line 958: GMD_API_GRP.check_item_exists

954: FETCH get_formula_id INTO l_form_id;
955: CLOSE get_formula_id;
956:
957: -- Check if formula items belong to the new recipe organization
958: GMD_API_GRP.check_item_exists
959: (p_formula_id => l_form_id
960: ,p_organization_id => l_organization_id
961: ,x_return_status => l_status );
962:

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

961: ,x_return_status => l_status );
962:
963: IF l_status <> FND_API.g_ret_sts_success THEN
964: -- Bug 5531791 Removed FND_MSG_PUB.GET and FND_MSG_PUB.ADD as the message
965: -- is already added by GMD_API_GRP.check_item_exists
966: RAISE NO_UPDATE_EXCEPTION;
967: END IF;
968:
969: END IF;

Line 980: GMD_API_GRP.check_item_exists

976: FETCH Cur_get_recipe_org INTO l_org_id;
977: CLOSE Cur_get_recipe_org;
978:
979: -- Check if new formula's items belong to the recipe organization
980: GMD_API_GRP.check_item_exists
981: (p_formula_id => l_formula_id
982: ,p_organization_id => l_org_id
983: ,x_return_status => l_status );
984:

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

983: ,x_return_status => l_status );
984:
985: IF l_status <> FND_API.g_ret_sts_success THEN
986: -- Bug 5531791 Removed FND_MSG_PUB.GET and FND_MSG_PUB.ADD as the message
987: -- is already added by GMD_API_GRP.check_item_exists
988: RAISE NO_UPDATE_EXCEPTION;
989: END IF;
990: -- Bug 5531717 add code to check for ovverride orgn
991: FOR l_recipe_override_orgn IN Cur_get_recipe_override_org(get_object_rec.object_id)

Line 994: GMD_API_GRP.check_item_exists

990: -- Bug 5531717 add code to check for ovverride orgn
991: FOR l_recipe_override_orgn IN Cur_get_recipe_override_org(get_object_rec.object_id)
992: LOOP
993: -- Check if new formula's items belong to the recipe organization
994: GMD_API_GRP.check_item_exists
995: (p_formula_id => l_formula_id
996: ,p_organization_id => l_recipe_override_orgn.organization_id
997: ,x_return_status => l_status );
998:

Line 1035: GMD_API_GRP.get_object_name_version

1031:
1032: IF (get_object_rec.replace_type = 'FORMULA_ID' ) THEN
1033: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1034: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1035: GMD_API_GRP.get_object_name_version
1036: ('FORMULA'
1037: ,get_object_rec.new_name)
1038: );
1039: ELSIF (get_object_rec.replace_type = 'ROUTING_ID' ) THEN

Line 1042: GMD_API_GRP.get_object_name_version

1038: );
1039: ELSIF (get_object_rec.replace_type = 'ROUTING_ID' ) THEN
1040: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1041: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1042: GMD_API_GRP.get_object_name_version
1043: ('ROUTING'
1044: ,get_object_rec.new_name)
1045: );
1046: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN

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

1122: FROM gmd_routings_b rot
1123: WHERE rot.routing_id = get_object_rec.object_id;
1124:
1125: -- Get the Routing version control for the entity orgn.
1126: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,
1127: P_parm_name => 'GMD_ROUTING_VERSION_CONTROL',
1128: P_parm_value => l_vers_cntrl,
1129: x_return_status => l_return_stat);
1130:

Line 1223: GMD_API_GRP.get_object_name_version

1219:
1220: IF (get_object_rec.replace_type = 'OPRN_ID') THEN
1221: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1222: FND_MESSAGE.SET_TOKEN('NEW_ITEM',
1223: GMD_API_GRP.get_object_name_version
1224: ('OPERATION'
1225: ,get_object_rec.new_name)
1226: );
1227: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN

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

1314: FROM gmd_operations_b opr
1315: WHERE opr.oprn_id = get_object_rec.object_id;
1316:
1317: -- Get the Operation version control for the entity orgn.
1318: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,
1319: P_parm_name => 'GMD_OPERATION_VERSION_CONTROL',
1320: P_parm_value => l_vers_cntrl,
1321: x_return_status => l_return_stat);
1322:

Line 1536: IF NOT GMD_API_GRP.Check_orgn_access

1532: IF (l_action_flag = 'U') THEN
1533: OPEN Cur_get_validity(get_object_rec.object_id);
1534: FETCH Cur_get_validity INTO l_obj_id;
1535: CLOSE Cur_get_validity;
1536: IF NOT GMD_API_GRP.Check_orgn_access
1537: (Entity => 'RECIPE'
1538: ,Entity_id => l_obj_id) THEN
1539: RAISE NO_UPDATE_EXCEPTION;
1540: END IF;

Line 1562: GMD_API_GRP.check_item_exists

1558: FETCH get_recp_formula_id INTO l_form_id;
1559: CLOSE get_recp_formula_id;
1560:
1561: -- Check if formula items belong to the new organization
1562: GMD_API_GRP.check_item_exists
1563: (p_formula_id => l_form_id
1564: ,p_organization_id => get_object_rec.new_name
1565: ,x_return_status => l_status );
1566: IF l_status <> FND_API.g_ret_sts_success THEN

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

1564: ,p_organization_id => get_object_rec.new_name
1565: ,x_return_status => l_status );
1566: IF l_status <> FND_API.g_ret_sts_success THEN
1567: -- Bug 5531791 Removed FND_MSG_PUB.GET and FND_MSG_PUB.ADD as the message
1568: -- is already added by GMD_API_GRP.check_item_exists
1569: RAISE NO_UPDATE_EXCEPTION;
1570: END IF;
1571: ELSE
1572: p_validity_rules_table(1).p_col_to_update := get_object_rec.replace_type;

Line 1618: GMD_API_GRP.get_object_status_type

1614: ELSIF (get_object_rec.replace_type = 'STATUS') THEN
1615: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_STATUS',true);
1616: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1617: get_status_meaning(
1618: GMD_API_GRP.get_object_status_type
1619: (get_object_rec.object_type
1620: , get_object_rec.object_id)
1621: ) );
1622: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN

Line 1625: GMD_API_GRP.get_object_name_version

1621: ) );
1622: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1623: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1624: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1625: GMD_API_GRP.get_object_name_version
1626: ('ROUTING',get_object_rec.new_name)
1627: );
1628: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN
1629: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);

Line 1631: GMD_API_GRP.get_object_name_version

1627: );
1628: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN
1629: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1630: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1631: GMD_API_GRP.get_object_name_version
1632: ('OPERATION',get_object_rec.new_name)
1633: );
1634: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN
1635: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);

Line 1637: GMD_API_GRP.get_object_name_version

1633: );
1634: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN
1635: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1636: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1637: GMD_API_GRP.get_object_name_version
1638: ('FORMULA',get_object_rec.new_name)
1639: );
1640: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN
1641: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OWNER',true);

Line 1720: GMD_API_GRP.get_object_name_version

1716: get_status_meaning(get_object_rec.new_name) );
1717: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1718: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1719: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1720: GMD_API_GRP.get_object_name_version
1721: ('ROUTING'
1722: ,get_object_rec.new_name)
1723: );
1724: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN

Line 1727: GMD_API_GRP.get_object_name_version

1723: );
1724: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN
1725: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1726: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1727: GMD_API_GRP.get_object_name_version
1728: ('OPERATION'
1729: ,get_object_rec.new_name)
1730: );
1731: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN

Line 1734: GMD_API_GRP.get_object_name_version

1730: );
1731: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN
1732: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1733: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1734: GMD_API_GRP.get_object_name_version
1735: ('FORMULA'
1736: ,get_object_rec.new_name)
1737: );
1738: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN

Line 1791: GMD_API_GRP.get_object_name_version

1787: get_status_meaning(get_object_rec.new_name) );
1788: ELSIF (get_object_rec.replace_type = 'ROUTING_ID') THEN
1789: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_ROUTING',true);
1790: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1791: GMD_API_GRP.get_object_name_version
1792: ('ROUTING'
1793: ,get_object_rec.new_name)
1794: );
1795: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN

Line 1798: GMD_API_GRP.get_object_name_version

1794: );
1795: ELSIF (get_object_rec.replace_type = 'OPRN_ID') THEN
1796: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_OPERATION',true);
1797: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1798: GMD_API_GRP.get_object_name_version
1799: ('OPERATION'
1800: ,get_object_rec.new_name)
1801: );
1802: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN

Line 1805: GMD_API_GRP.get_object_name_version

1801: );
1802: ELSIF (get_object_rec.replace_type = 'FORMULA_ID') THEN
1803: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE','GMD_FORMULA',true);
1804: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',
1805: GMD_API_GRP.get_object_name_version
1806: ('FORMULA'
1807: ,get_object_rec.new_name)
1808: );
1809: ELSIF (get_object_rec.replace_type = 'OWNER_ID') THEN