eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_FORMULA_DESIGNER_PKG dependencies on GMD_API_GRP

Line 21: | gmd_api_grp.Update_allowed_with_fmsec function in

Line 70: | gmd_api_grp.Update_allowed_with_fmsec function in

Line 73: | 30-03-2004kkillamsCalling GMD_API_GRP.get_formula_access_type api to get the

69: | 16-APR-2003 Eddie Oumerretane. Implemented call to
70: | gmd_api_grp.Update_allowed_with_fmsec function in
71: | order to get formula user access defined in
72: | Formula Security.
73: | 30-03-2004kkillamsCalling GMD_API_GRP.get_formula_access_type api to get the
74: | formula access type w.r.t. bug 3344335.
75: | 29-Jul-2005 Tdaniel Added organization_id for convergence changes.
76: +=============================================================================
77: Api end of comments

Line 115: l_formula_access :=GMD_API_GRP.get_formula_access_type(p_formula_id => p_formula_id,

111: END IF;
112:
113: -- to be changed
114: l_formula_access := 'U';
115: l_formula_access :=GMD_API_GRP.get_formula_access_type(p_formula_id => p_formula_id,
116: p_owner_organization_id => l_fm_orgn_id);
117:
118: IF (l_formula_access ='U') THEN
119: --- Assume that user can update current formula and create new ones

Line 387: x_error_msg := gmd_api_grp.get_message;

383:
384: WHEN RECORD_CHANGED_EXCEPTION THEN
385: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
386: x_return_code := 'F';
387: x_error_msg := gmd_api_grp.get_message;
388:
389: WHEN OTHERS THEN
390: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
391: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 393: x_error_msg := gmd_api_grp.get_message;

389: WHEN OTHERS THEN
390: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
391: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
392: x_return_code := 'F';
393: x_error_msg := gmd_api_grp.get_message;
394:
395: END Update_Formula_Header;
396:
397: /* Api start of comments

Line 625: x_error_msg := gmd_api_grp.get_message;

621: WHEN RECORD_CHANGED_EXCEPTION THEN
622: ROLLBACK TO Add_Item;
623: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
624: x_return_code := 'F';
625: x_error_msg := gmd_api_grp.get_message;
626:
627: WHEN OTHERS THEN
628: ROLLBACK TO Add_Item;
629: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 632: x_error_msg := gmd_api_grp.get_message;

628: ROLLBACK TO Add_Item;
629: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
630: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
631: x_return_code := 'F';
632: x_error_msg := gmd_api_grp.get_message;
633:
634: END Insert_Formula_Detail;
635:
636: /* Api start of comments

Line 940: x_error_msg := gmd_api_grp.get_message;

936:
937: WHEN RECORD_CHANGED_EXCEPTION THEN
938: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
939: x_return_code := 'F';
940: x_error_msg := gmd_api_grp.get_message;
941:
942: WHEN OTHERS THEN
943: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
944: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 946: x_error_msg := gmd_api_grp.get_message;

942: WHEN OTHERS THEN
943: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
944: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
945: x_return_code := 'F';
946: x_error_msg := gmd_api_grp.get_message;
947:
948: END Update_Formula_Detail;
949:
950: /* Api start of comments

Line 1119: x_error_msg := gmd_api_grp.get_message;

1115:
1116: WHEN GET_SURROGATE_EXCEPTION THEN
1117: FND_MESSAGE.SET_NAME('GMD', 'FM_INVALID_FORMULA_ID');
1118: x_return_code := 'F';
1119: x_error_msg := gmd_api_grp.get_message;
1120:
1121: WHEN OTHERS THEN
1122: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1123: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 1125: x_error_msg := gmd_api_grp.get_message;

1121: WHEN OTHERS THEN
1122: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1123: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1124: x_return_code := 'F';
1125: x_error_msg := gmd_api_grp.get_message;
1126:
1127: END Create_Formula_Header;
1128:
1129:

Line 1224: x_error_msg := gmd_api_grp.get_message;

1220: x_error_msg := l_message;
1221: WHEN RECORD_CHANGED_EXCEPTION THEN
1222: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1223: x_return_code := 'F';
1224: x_error_msg := gmd_api_grp.get_message;
1225: WHEN OTHERS THEN
1226: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1227: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1228: x_return_code := 'F';

Line 1229: x_error_msg := gmd_api_grp.get_message;

1225: WHEN OTHERS THEN
1226: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1227: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1228: x_return_code := 'F';
1229: x_error_msg := gmd_api_grp.get_message;
1230:
1231: END Delete_Formula_Detail;
1232:
1233: /* Api start of comments

Line 1304: x_error_msg := gmd_api_grp.get_message;

1300: EXCEPTION
1301: WHEN RECORD_CHANGED_EXCEPTION THEN
1302: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1303: x_return_code := 'F';
1304: x_error_msg := gmd_api_grp.get_message;
1305: WHEN OTHERS THEN
1306: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1307: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1308: x_return_code := 'F';

Line 1309: x_error_msg := gmd_api_grp.get_message;

1305: WHEN OTHERS THEN
1306: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1307: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1308: x_return_code := 'F';
1309: x_error_msg := gmd_api_grp.get_message;
1310:
1311: END Del_Formula_Detail_With_No_Val;
1312:
1313: /* Api start of comments

Line 1371: x_error_msg := gmd_api_grp.get_message;

1367: EXCEPTION
1368: WHEN COST_ALLOC_EXCEPTION THEN
1369: FND_MESSAGE.SET_NAME ('GMD','FM_SUM_ALLOC <> 1');
1370: x_return_code := 'W';
1371: x_error_msg := gmd_api_grp.get_message;
1372:
1373: WHEN OTHERS THEN
1374: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1375: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 1377: x_error_msg := gmd_api_grp.get_message;

1373: WHEN OTHERS THEN
1374: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1375: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1376: x_return_code := 'F';
1377: x_error_msg := gmd_api_grp.get_message;
1378:
1379: END Validate_Cost_Allocation;
1380:
1381: /* Api start of comments

Line 1488: x_error_msg := gmd_api_grp.get_message;

1484: EXCEPTION
1485: WHEN ITEM_UM_EXCEPTION THEN
1486: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');
1487: x_return_code := 'F';
1488: x_error_msg := gmd_api_grp.get_message;
1489: WHEN CONV_ITEM_EXCEPTION THEN
1490: x_return_code := 'F';
1491: x_error_msg := gmd_api_grp.get_message;
1492: WHEN OTHERS THEN

Line 1491: x_error_msg := gmd_api_grp.get_message;

1487: x_return_code := 'F';
1488: x_error_msg := gmd_api_grp.get_message;
1489: WHEN CONV_ITEM_EXCEPTION THEN
1490: x_return_code := 'F';
1491: x_error_msg := gmd_api_grp.get_message;
1492: WHEN OTHERS THEN
1493: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1494: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1495: x_return_code := 'F';

Line 1496: x_error_msg := gmd_api_grp.get_message;

1492: WHEN OTHERS THEN
1493: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1494: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1495: x_return_code := 'F';
1496: x_error_msg := gmd_api_grp.get_message;
1497:
1498: END Validate_Item_Uom;
1499:
1500: /* Api start of comments

Line 1572: x_warning_message := gmd_api_grp.get_message;

1568: IF l_check_step_mat.asqc_recipes > 0 THEN
1569: x_nb_recipes := l_check_step_mat.asqc_recipes;
1570: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORM_DEL_RECALC_AUTO_STEP');
1571: FND_MESSAGE.SET_TOKEN('RECIPE_NO', x_nb_recipes);
1572: x_warning_message := gmd_api_grp.get_message;
1573: ELSE
1574: -- Else Check if there are any rows in gmd_recipe_step_materials with this
1575: -- formulaline_id, regardless of ASQC flag
1576: IF l_check_step_mat.step_assoc_recipes > 0 THEN

Line 1580: x_warning_message := gmd_api_grp.get_message;

1576: IF l_check_step_mat.step_assoc_recipes > 0 THEN
1577: x_nb_recipes := l_check_step_mat.step_assoc_recipes;
1578: FND_MESSAGE.SET_NAME('GMD', 'GMD_FORM_DEL_REVIEW_STEP_QTY');
1579: FND_MESSAGE.SET_TOKEN('RECIPE_NO', x_nb_recipes);
1580: x_warning_message := gmd_api_grp.get_message;
1581: END IF;
1582: END IF;
1583:
1584: EXCEPTION

Line 1598: x_error_msg := gmd_api_grp.get_message;

1594: WHEN OTHERS THEN
1595: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1596: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1597: x_return_code := 'F';
1598: x_error_msg := gmd_api_grp.get_message;
1599:
1600: END Check_Item_Used_In_Recipe;
1601:
1602:

Line 1678: x_error_msg := gmd_api_grp.get_message;

1674: WHEN OTHERS THEN
1675: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1676: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1677: x_return_code := 'F';
1678: x_error_msg := gmd_api_grp.get_message;
1679:
1680: END Cascade_Update_Recipes;
1681:
1682: /* Api start of comments

Line 1831: x_error_msg := gmd_api_grp.get_message;

1827: WHEN OTHERS THEN
1828: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1829: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1830: x_return_code := 'F';
1831: x_error_msg := gmd_api_grp.get_message;
1832:
1833: END Calculate_Theoretical_yield;
1834:
1835: /* Api start of comments

Line 1996: x_error_msg := gmd_api_grp.get_message;

1992: WHEN OTHERS THEN
1993: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1994: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1995: x_return_code := 'F';
1996: x_error_msg := gmd_api_grp.get_message;
1997:
1998: END Scale_Formula;
1999:
2000:

Line 2099: GMD_API_GRP.Check_Item_Exists( p_formula_id => p_formula_id,

2095: OPEN get_orgn_id(p_formula_id);
2096: FETCH get_orgn_id INTO l_orgn_id;
2097: CLOSE get_orgn_id;
2098:
2099: GMD_API_GRP.Check_Item_Exists( p_formula_id => p_formula_id,
2100: x_return_status => l_return_status,
2101: p_organization_id => l_orgn_id);
2102:
2103: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 2121: x_error_msg := gmd_api_grp.get_message;

2117: X_return_code := 'W';
2118: END IF;
2119:
2120: IF x_return_code <> 'S' THEN
2121: x_error_msg := gmd_api_grp.get_message;
2122: END IF;
2123:
2124: --Bug 3336945
2125: --Function to validate the total cost of Formula

Line 2139: x_error_msg := gmd_api_grp.get_message;

2135: WHEN OTHERS THEN
2136: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2137: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2138: x_return_code := 'F';
2139: x_error_msg := gmd_api_grp.get_message;
2140:
2141: END Validate_Formula_Details;
2142:
2143: /* Api start of comments

Line 2179: x_error_msg := gmd_api_grp.get_message;

2175: WHEN OTHERS THEN
2176: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2177: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2178: x_return_code := 'F';
2179: x_error_msg := gmd_api_grp.get_message;
2180:
2181: END Set_Save_Point;
2182:
2183: /* Api start of comments

Line 2219: x_error_msg := gmd_api_grp.get_message;

2215: WHEN OTHERS THEN
2216: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2217: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2218: x_return_code := 'F';
2219: x_error_msg := gmd_api_grp.get_message;
2220:
2221: END Rollback_Save_Point;
2222:
2223: /* Api start of comments

Line 2278: x_error_msg := gmd_api_grp.get_message;

2274: WHEN OTHERS THEN
2275: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2276: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2277: x_return_code := 'N';
2278: x_error_msg := gmd_api_grp.get_message;
2279:
2280: END check_usr_has_fsec_resp;
2281:
2282: /* Api start of comments

Line 2319: IF (GMD_API_GRP.setup AND GMD_API_GRP.OrgnAccessible(l_orgn_id) ) THEN

2315: FETCH Cur_get_orgn INTO l_orgn_id;
2316: CLOSE Cur_get_orgn;
2317:
2318: IF (l_orgn_id IS NOT NULL) THEN
2319: IF (GMD_API_GRP.setup AND GMD_API_GRP.OrgnAccessible(l_orgn_id) ) THEN
2320: x_return_code := 'S';
2321: ELSE
2322: x_return_code := 'F';
2323: END IF;

Line 2385: x_error_msg := gmd_api_grp.get_message;

2381: EXCEPTION
2382: WHEN ITEM_REV_EXCEPTION THEN
2383: FND_MESSAGE.SET_NAME('INV','INV_INT_REVEXP');
2384: x_return_code := 'F';
2385: x_error_msg := gmd_api_grp.get_message;
2386: WHEN OTHERS THEN
2387: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2388: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2389: x_return_code := 'F';

Line 2390: x_error_msg := gmd_api_grp.get_message;

2386: WHEN OTHERS THEN
2387: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
2388: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2389: x_return_code := 'F';
2390: x_error_msg := gmd_api_grp.get_message;
2391: END Validate_Item_Revision;
2392:
2393:
2394: /* Api start of comments

Line 2423: GMD_API_GRP.check_item_exists (p_formula_id => p_formula_id

2419: x_error_msg OUT NOCOPY VARCHAR2) IS
2420: l_msg_txt VARCHAR2(2000);
2421: l_msg_index PLS_INTEGER;
2422: BEGIN
2423: GMD_API_GRP.check_item_exists (p_formula_id => p_formula_id
2424: ,x_return_status => x_return_status
2425: ,p_organization_id => p_organization_id);
2426: IF x_return_status <> FND_API.g_ret_sts_success THEN
2427: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.count_msg,

Line 2508: GMD_API_GRP.FETCH_PARM_VALUES ( P_orgn_id => pOrgn_id,

2504: x_error_msg OUT NOCOPY VARCHAR2) IS
2505:
2506: BEGIN
2507: IF pOrgn_id IS NOT NULL THEN
2508: GMD_API_GRP.FETCH_PARM_VALUES ( P_orgn_id => pOrgn_id,
2509: P_parm_name => 'GMD_AUTO_PROD_CALC' ,
2510: P_parm_value => pAuto_calc ,
2511: X_return_status => x_return_status );
2512: END IF ;