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 FND_API

Line 260: x_return_code := FND_API.G_RET_STS_SUCCESS;

256:
257: BEGIN
258:
259: x_error_msg := '';
260: x_return_code := FND_API.G_RET_STS_SUCCESS;
261:
262:
263: OPEN Cur_get_formula;
264: FETCH Cur_get_formula INTO l_rec;

Line 343: , p_init_msg_list => FND_API.G_TRUE

339: l_update_table(1).auto_product_calc := p_auto_product_calc;
340:
341: GMD_FORMULA_PUB.Update_FormulaHeader
342: ( p_api_version => 2
343: , p_init_msg_list => FND_API.G_TRUE
344: , p_commit => FND_API.G_FALSE
345: , p_called_from_forms => 'YES'
346: , x_return_status => l_return_status
347: , x_msg_count => l_message_count

Line 344: , p_commit => FND_API.G_FALSE

340:
341: GMD_FORMULA_PUB.Update_FormulaHeader
342: ( p_api_version => 2
343: , p_init_msg_list => FND_API.G_TRUE
344: , p_commit => FND_API.G_FALSE
345: , p_called_from_forms => 'YES'
346: , x_return_status => l_return_status
347: , x_msg_count => l_message_count
348: , x_msg_data => l_msg_data

Line 351: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

347: , x_msg_count => l_message_count
348: , x_msg_data => l_msg_data
349: , p_formula_header_tbl => l_update_table);
350:
351: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
352: RAISE UPDATE_FORMULA_EXCEPTION;
353: END IF;
354:
355: --- If formula number and/or version have changed, we need to update them. This

Line 501: x_return_code := FND_API.G_RET_STS_SUCCESS;

497:
498: SAVEPOINT Add_Item;
499:
500: x_error_msg := '';
501: x_return_code := FND_API.G_RET_STS_SUCCESS;
502:
503: IF p_text_code <= 0 THEN
504: l_text_code := NULL;
505: ELSE

Line 597: , p_init_msg_list => FND_API.G_TRUE

593: END IF;
594:
595: GMD_FORMULA_DETAIL_PUB.Insert_FormulaDetail
596: ( p_api_version => 1.0
597: , p_init_msg_list => FND_API.G_TRUE
598: , p_commit => FND_API.G_FALSE
599: , p_called_from_forms => 'NO'
600: , x_return_status => l_return_status
601: , x_msg_count => l_message_count

Line 598: , p_commit => FND_API.G_FALSE

594:
595: GMD_FORMULA_DETAIL_PUB.Insert_FormulaDetail
596: ( p_api_version => 1.0
597: , p_init_msg_list => FND_API.G_TRUE
598: , p_commit => FND_API.G_FALSE
599: , p_called_from_forms => 'NO'
600: , x_return_status => l_return_status
601: , x_msg_count => l_message_count
602: , x_msg_data => l_message_list

Line 606: IF (l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, 'Q')) THEN

602: , x_msg_data => l_message_list
603: , p_formula_detail_tbl => l_formula_dtl_rec);
604:
605: /*B4771255 Changed the return status checking to include the toq warning */
606: IF (l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, 'Q')) THEN
607: RAISE INSERT_DTL_EXCEPTION;
608: END IF;
609:
610: EXCEPTION

Line 779: x_return_code := FND_API.G_RET_STS_SUCCESS;

775:
776: BEGIN
777:
778: x_error_msg := '';
779: x_return_code := FND_API.G_RET_STS_SUCCESS;
780:
781: IF p_last_update_date_orig IS NOT NULL THEN
782:
783: OPEN Cur_get_line;

Line 913: , p_init_msg_list => FND_API.G_TRUE

909: --- perform validation on line number. This validation fails when
910: --- resequencing item line numbers.
911: GMD_FORMULA_DETAIL_PUB.Update_FormulaDetail
912: ( p_api_version => 2
913: , p_init_msg_list => FND_API.G_TRUE
914: , p_commit => FND_API.G_FALSE
915: , p_called_from_forms => 'YES'
916: , x_return_status => l_return_status
917: , x_msg_count => l_message_count

Line 914: , p_commit => FND_API.G_FALSE

910: --- resequencing item line numbers.
911: GMD_FORMULA_DETAIL_PUB.Update_FormulaDetail
912: ( p_api_version => 2
913: , p_init_msg_list => FND_API.G_TRUE
914: , p_commit => FND_API.G_FALSE
915: , p_called_from_forms => 'YES'
916: , x_return_status => l_return_status
917: , x_msg_count => l_message_count
918: , x_msg_data => l_message_list

Line 922: IF (l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, 'Q')) THEN

918: , x_msg_data => l_message_list
919: , p_formula_detail_tbl => l_formula_dtl_rec);
920:
921: /*B4771255 Changed the return status checking to include the toq warning */
922: IF (l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, 'Q')) THEN
923: RAISE UPDATE_DTL_EXCEPTION;
924: END IF;
925:
926:

Line 1004: x_return_code := FND_API.G_RET_STS_SUCCESS;

1000: l_dummy NUMBER;
1001:
1002: BEGIN
1003:
1004: x_return_code := FND_API.G_RET_STS_SUCCESS;
1005: x_error_msg := '';
1006:
1007: x_formula_id := GMDSURG.get_surrogate('formula_id');
1008: IF (x_formula_id < 1) THEN

Line 1094: , p_init_msg_list => FND_API.G_TRUE

1090:
1091:
1092: GMD_FORMULA_HEADER_PVT.Insert_FormulaHeader
1093: ( p_api_version => 1.0
1094: , p_init_msg_list => FND_API.G_TRUE
1095: , p_commit => FND_API.G_FALSE
1096: , x_return_status => l_return_status
1097: , x_msg_count => l_message_count
1098: , x_msg_data => l_msg_data

Line 1095: , p_commit => FND_API.G_FALSE

1091:
1092: GMD_FORMULA_HEADER_PVT.Insert_FormulaHeader
1093: ( p_api_version => 1.0
1094: , p_init_msg_list => FND_API.G_TRUE
1095: , p_commit => FND_API.G_FALSE
1096: , x_return_status => l_return_status
1097: , x_msg_count => l_message_count
1098: , x_msg_data => l_msg_data
1099: , p_formula_header_rec => l_fm_form_mst_rec

Line 1102: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1098: , x_msg_data => l_msg_data
1099: , p_formula_header_rec => l_fm_form_mst_rec
1100: );
1101:
1102: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1103: RAISE INSERT_FORMULA_EXCEPTION;
1104: END IF;
1105:
1106: EXCEPTION

Line 1200: , p_init_msg_list => FND_API.G_TRUE

1196: l_formula_dtl_rec(1).user_id := G_CREATED_BY;
1197:
1198: GMD_FORMULA_DETAIL_PUB.Delete_FormulaDetail
1199: ( p_api_version => 1.1
1200: , p_init_msg_list => FND_API.G_TRUE
1201: , p_commit => FND_API.G_FALSE
1202: , p_called_from_forms => 'NO'
1203: , x_return_status => l_return_status
1204: , x_msg_count => l_message_count

Line 1201: , p_commit => FND_API.G_FALSE

1197:
1198: GMD_FORMULA_DETAIL_PUB.Delete_FormulaDetail
1199: ( p_api_version => 1.1
1200: , p_init_msg_list => FND_API.G_TRUE
1201: , p_commit => FND_API.G_FALSE
1202: , p_called_from_forms => 'NO'
1203: , x_return_status => l_return_status
1204: , x_msg_count => l_message_count
1205: , x_msg_data => l_message_list

Line 1208: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1204: , x_msg_count => l_message_count
1205: , x_msg_data => l_message_list
1206: , p_formula_detail_tbl => l_formula_dtl_rec);
1207:
1208: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1209: RAISE DELETE_LINE_EXCEPTION;
1210: END IF;
1211:
1212: EXCEPTION

Line 1542: x_return_code := FND_API.G_RET_STS_SUCCESS;

1538: BEGIN
1539:
1540: x_error_msg := '';
1541: x_warning_message := '';
1542: x_return_code := FND_API.G_RET_STS_SUCCESS;
1543:
1544: l_calculatable_rec.formulaline_id := p_formulaline_id;
1545:
1546: -- Count recipes where this formulaline exists in step/mat association,

Line 1557: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1553: p_msg_count => l_message_count,
1554: p_msg_stack => l_msg_data,
1555: p_return_status => l_return_status);
1556:
1557: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1558: RAISE CHECK_ITEM_EXCEPTION;
1559: END IF;
1560:
1561: --- Store these variables for Cascade_Update_Recipes

Line 1644: x_return_code := FND_API.G_RET_STS_SUCCESS;

1640:
1641: BEGIN
1642:
1643: x_error_msg := '';
1644: x_return_code := FND_API.G_RET_STS_SUCCESS;
1645:
1646: l_date := SYSDATE;
1647: g_calculatable_rec.created_by := g_created_by;
1648: g_calculatable_rec.last_updated_by := g_created_by;

Line 1661: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1657: p_msg_stack => l_msg_data,
1658: p_return_status => l_return_status,
1659: P_organization_id => null);
1660:
1661: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1662: RAISE UPDATE_RECIPE_EXCEPTION;
1663: END IF;
1664:
1665: EXCEPTION

Line 1766: x_return_code := FND_API.G_RET_STS_SUCCESS;

1762:
1763: BEGIN
1764:
1765: x_error_msg := '';
1766: x_return_code := FND_API.G_RET_STS_SUCCESS;
1767:
1768: OPEN Get_Materials;
1769:
1770: FETCH Get_Materials

Line 1811: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1807: ,p_scale_factor => p_scale_factor
1808: ,x_scale_tab => G_SCALE_REC
1809: ,x_return_status => l_return_status);
1810:
1811: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1812: RAISE THEORETICAL_YIELD_EXCEPTION;
1813: END IF;
1814:
1815: END IF;

Line 1920: x_return_code := FND_API.G_RET_STS_SUCCESS;

1916:
1917: BEGIN
1918:
1919: x_error_msg := '';
1920: x_return_code := FND_API.G_RET_STS_SUCCESS;
1921:
1922: OPEN Get_Materials;
1923:
1924: FETCH Get_Materials

Line 1977: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1973: ,x_scale_tab => G_SCALE_REC
1974: ,x_return_status => l_return_status);
1975:
1976:
1977: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1978: RAISE SCALE_EXCEPTION;
1979: END IF;
1980: END IF;
1981:

Line 2103: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

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
2104: x_return_code := 'F';
2105: END IF;
2106: END IF;
2107:

Line 2426: IF x_return_status <> FND_API.g_ret_sts_success THEN

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,
2428: p_data => X_error_msg,
2429: p_encoded => FND_API.G_FALSE,
2430: p_msg_index_out => l_msg_index);

Line 2429: p_encoded => FND_API.G_FALSE,

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,
2428: p_data => X_error_msg,
2429: p_encoded => FND_API.G_FALSE,
2430: p_msg_index_out => l_msg_index);
2431: END IF;
2432: END Check_Item_Exists;
2433:

Line 2469: IF x_return_status <> FND_API.g_ret_sts_success THEN

2465: GMD_COMMON_VAL.CHECK_FORMULA_ITEM_ACCESS (pFormula_Id => pFormula_Id
2466: ,pInventory_Item_ID => pInventory_Item_ID
2467: ,x_return_status => x_return_status
2468: ,pRevision => pRevision );
2469: IF x_return_status <> FND_API.g_ret_sts_success THEN
2470: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.count_msg,
2471: p_data => X_error_msg,
2472: p_encoded => FND_API.G_FALSE,
2473: p_msg_index_out => l_msg_index);

Line 2472: p_encoded => FND_API.G_FALSE,

2468: ,pRevision => pRevision );
2469: IF x_return_status <> FND_API.g_ret_sts_success THEN
2470: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.count_msg,
2471: p_data => X_error_msg,
2472: p_encoded => FND_API.G_FALSE,
2473: p_msg_index_out => l_msg_index);
2474: END IF;
2475:
2476: END CHECK_FORMULA_ITEM_ACCESS;