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_DETAIL_PUB dependencies on GMDFMVAL_PUB

Line 5: pRecord_in GMDFMVAL_PUB.formula_info_in;

1: PACKAGE BODY GMD_FORMULA_DETAIL_PUB AS
2: /* $Header: GMDPFMDB.pls 120.12.12020000.3 2012/11/13 06:47:26 mtou ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_FORMULA_DETAIL_PUB' ;
5: pRecord_in GMDFMVAL_PUB.formula_info_in;
6: pTable_out GMDFMVAL_PUB.formula_table_out;
7: lreturn VARCHAR2(1);
8:
9: --Bug 3222090, NSRIVAST 20-FEB-2004, BEGIN

Line 6: pTable_out GMDFMVAL_PUB.formula_table_out;

2: /* $Header: GMDPFMDB.pls 120.12.12020000.3 2012/11/13 06:47:26 mtou ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_FORMULA_DETAIL_PUB' ;
5: pRecord_in GMDFMVAL_PUB.formula_info_in;
6: pTable_out GMDFMVAL_PUB.formula_table_out;
7: lreturn VARCHAR2(1);
8:
9: --Bug 3222090, NSRIVAST 20-FEB-2004, BEGIN
10: --Forward declaration.

Line 56: /* of GMDFMVAL_PUB.p_called_from_forms package */

52: /* HISTORY: */
53: /* 10-Apr-2003 P.Raghu Bug#2893682 Modified the code such that */
54: /* p_formula_detail_rec.item_no is correctly set to */
55: /* ITEM_NO TOKEN. Uncommented the assigment statement*/
56: /* of GMDFMVAL_PUB.p_called_from_forms package */
57: /* variable in Insert_FormulaDetail procedure. */
58: /* 18-Apr-2003 J. Baird Bug #2908311 Uncommented initialization of */
59: /* x_return_status */
60: /* 18-Apr-2003 J. Baird Bug #2906124 Was not setting the TO_UOM token. */

Line 126: --Set the formula validation pkg variable GMDFMVAL_PUB

122: IF FND_API.to_Boolean( p_init_msg_list ) THEN
123: FND_MSG_PUB.initialize;
124: END IF;
125:
126: --Set the formula validation pkg variable GMDFMVAL_PUB
127: --variable p_called_from_form same as that passed in.
128: --When API is called from forms the parameter p_called_from_forms is set
129: --to 'YES' and the same parameter is set to 'YES' within the validation pkg.
130: --When API is not called from forms the parameter is 'NO'.

Line 134: --is passed to the GMDFMVAL_PUB API.

130: --When API is not called from forms the parameter is 'NO'.
131:
132: --BEGIN BUG#2893682 P.Raghu
133: --Uncommenting the following statement such that the actual value
134: --is passed to the GMDFMVAL_PUB API.
135: GMDFMVAL_PUB.p_called_from_forms := p_called_from_forms;
136: --END BUG#2893682
137:
138: /* API body */

Line 135: GMDFMVAL_PUB.p_called_from_forms := p_called_from_forms;

131:
132: --BEGIN BUG#2893682 P.Raghu
133: --Uncommenting the following statement such that the actual value
134: --is passed to the GMDFMVAL_PUB API.
135: GMDFMVAL_PUB.p_called_from_forms := p_called_from_forms;
136: --END BUG#2893682
137:
138: /* API body */
139: /* 1. Does validation when not called from forms because from forms all

Line 182: GMDFMVAL_PUB.get_element(pElement_name => 'FORMULA',

178: ||x_return_status);
179: END IF;
180:
181: IF (p_formula_detail_rec.formula_id is NULL) THEN
182: GMDFMVAL_PUB.get_element(pElement_name => 'FORMULA',
183: pRecord_in => pRecord_in,
184: xTable_out => pTable_out,
185: xReturn => x_return_status);
186: IF (x_return_status <> 'S') THEN

Line 216: GMDFMVAL_PUB.get_item_id(pitem_no => p_formula_detail_rec.item_no,

212: IF (p_formula_detail_rec.inventory_item_id is NULL AND p_formula_detail_rec.item_no IS NULL) THEN
213: FND_MESSAGE.SET_NAME('GMI', 'GMI_API_ITEM_NOT_FOUND');
214: FND_MSG_PUB.Add;
215: ELSE
216: GMDFMVAL_PUB.get_item_id(pitem_no => p_formula_detail_rec.item_no,
217: pinventory_item_id => p_formula_detail_rec.inventory_item_id,
218: porganization_id => l_org_id,
219: xitem_id => l_item_id,
220: xitem_um => l_inv_uom,

Line 291: l_return_val := GMDFMVAL_PUB.detail_line_val

287: END IF;
288:
289: /* Bug No.7328802 - End */
290:
291: l_return_val := GMDFMVAL_PUB.detail_line_val
292: (l_formula_id,
293: p_formula_detail_rec.line_no,
294: p_formula_detail_rec.line_type);
295: IF (l_return_val <> 0) THEN

Line 337: GMDFMVAL_PUB.validate_insert_record (P_formula_dtl => P_formula_detail_rec,

333: done, so we can skip the validations below. */
334:
335:
336: IF (NVL(p_called_from_forms,'NO') = 'NO') THEN
337: GMDFMVAL_PUB.validate_insert_record (P_formula_dtl => P_formula_detail_rec,
338: X_formula_dtl => X_formula_detail_rec,
339: xReturn => X_return_status);
340: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
341: RAISE FND_API.G_EXC_ERROR;

Line 688: /* Set the formula validation pkg variable GMDFMVAL_PUB */

684: THEN
685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
686: END IF;
687:
688: /* Set the formula validation pkg variable GMDFMVAL_PUB */
689: /* variable p_called_from_form same as that passed in. */
690: /* When API is called from forms the parameter p_called_from_forms is set
691: to 'YES' and the same parameter is set to 'YES' within the validation pkg.
692: When API is not called from forms the parameter is 'NO'.

Line 695: GMDFMVAL_PUB.p_called_from_forms := p_called_from_forms;

691: to 'YES' and the same parameter is set to 'YES' within the validation pkg.
692: When API is not called from forms the parameter is 'NO'.
693: */
694:
695: GMDFMVAL_PUB.p_called_from_forms := p_called_from_forms;
696:
697: /* Initialize message list if p_init_msg_list is set to TRUE */
698: IF FND_API.to_Boolean( p_init_msg_list ) THEN
699: FND_MSG_PUB.initialize;

Line 738: GMDFMVAL_PUB.get_formula_id(p_formula_detail_rec.formula_no,

734: gmd_debug.put_line(' In Formula Detail Pub - '
735: ||' Before formula validation - '||x_return_status);
736: END IF;
737: IF (p_formula_detail_rec.formula_id is NULL) THEN
738: GMDFMVAL_PUB.get_formula_id(p_formula_detail_rec.formula_no,
739: p_formula_detail_rec.formula_vers,
740: l_formula_id, l_return_val);
741: IF (l_return_val <> 0) THEN
742: IF (p_formula_detail_rec.formula_no IS NULL) THEN

Line 800: GMDFMVAL_PUB.get_formulaline_id(p_formula_detail_rec.formulaline_id,l_return_val);

796: gmd_debug.put_line(' In Formula Detail Pub - '
797: ||' Before formulaline validation - '||x_return_status);
798: END IF;
799: IF (p_formula_detail_rec.formulaline_id IS NOT NULL) THEN /* if invalid formula no */
800: GMDFMVAL_PUB.get_formulaline_id(p_formula_detail_rec.formulaline_id,l_return_val);
801: IF (l_return_val <> 0) THEN
802: FND_MESSAGE.SET_NAME('GMD','FM_INVALID_FMLINE_ID');
803: FND_MSG_PUB.Add;
804: RAISE FND_API.G_EXC_ERROR;

Line 965: GMDFMVAL_PUB.validate_update_record (P_formula_dtl => P_formula_detail_rec,

961:
962: /* Procedure validate_formula_record for all the elements*/
963:
964: IF (NVL(p_called_from_forms,'NO') = 'NO') THEN
965: GMDFMVAL_PUB.validate_update_record (P_formula_dtl => P_formula_detail_rec,
966: X_formula_dtl => X_formula_detail_rec,
967: xReturn => X_return_status);
968: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
969: RAISE FND_API.G_EXC_ERROR;

Line 1691: GMDFMVAL_PUB.get_formulaline_id(p_formula_detail_rec.formulaline_id,l_return_val);

1687: /* Must be passed and should exist */
1688: /* ============================ */
1689: IF (p_formula_detail_rec.formulaline_id IS NOT NULL) THEN /* if invalid formulaline no */
1690:
1691: GMDFMVAL_PUB.get_formulaline_id(p_formula_detail_rec.formulaline_id,l_return_val);
1692: IF (l_return_val <> 0) THEN
1693: FND_MESSAGE.SET_NAME('GMD','FM_MISSING_FMLINE_ID');
1694: FND_MSG_PUB.Add;
1695: RAISE FND_API.G_EXC_ERROR;