APPS.GMD_FORMULA_PUB dependencies on GMDFMVAL_PUB

Line 6: pRecord_in GMDFMVAL_PUB.formula_info_in;

2: /* $Header: GMDPFMHB.pls 120.9 2008/02/15 06:32:17 kannavar ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_FORMULA_PUB' ;
6: pRecord_in GMDFMVAL_PUB.formula_info_in;
7: pTable_out GMDFMVAL_PUB.formula_table_out;
8: lreturn varchar2(1);
9:
10: --Bug 3222090, NSRIVAST 20-FEB-2004, BEGIN

Line 7: pTable_out GMDFMVAL_PUB.formula_table_out;

3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_FORMULA_PUB' ;
6: pRecord_in GMDFMVAL_PUB.formula_info_in;
7: pTable_out GMDFMVAL_PUB.formula_table_out;
8: lreturn varchar2(1);
9:
10: --Bug 3222090, NSRIVAST 20-FEB-2004, BEGIN
11: --Forward declaration.

Line 261: GMDFMVAL_PUB.get_formula_id(p_formula_header_rec.formula_no,

257: /* BAsed on the initial design the formula input table has both */
258: /* header and detail information */
259: /* ================================================================== */
260: IF (p_formula_header_rec.formula_id is NULL) THEN
261: GMDFMVAL_PUB.get_formula_id(p_formula_header_rec.formula_no,
262: p_formula_header_rec.formula_vers,
263: l_formula_id, l_return_val);
264: IF (l_return_val <> 0) THEN
265: IF (p_formula_header_rec.formula_no IS NULL) THEN

Line 572: l_return_val := GMDFMVAL_PUB.formula_class_val(p_formula_header_rec.formula_class);

568: ||' - '
569: ||x_return_status);
570: END IF;
571: IF (p_formula_header_rec.formula_class IS NOT NULL) THEN
572: l_return_val := GMDFMVAL_PUB.formula_class_val(p_formula_header_rec.formula_class);
573: IF (l_return_val <> 0) THEN
574: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
575: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
576: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);

Line 812: IF (gmdfmval_pub.check_expr_items(l_tbl_formula_id(i).formula_id)) THEN

808: V_orgn_id => l_tbl_formula_id(i).owner_organization_id,
809: X_entity_status => l_entity_status);
810: -- Check for any experimental items when formula status is apfgu.
811: IF (l_entity_status.status_type = 700) THEN
812: IF (gmdfmval_pub.check_expr_items(l_tbl_formula_id(i).formula_id)) THEN
813: FND_MESSAGE.SET_NAME('GMD','GMD_EXPR_ITEMS_FOUND');
814: FND_MSG_PUB.ADD;
815: RAISE FND_API.G_EXC_ERROR;
816: END IF; -- IF (gmdfmval_pub.check_expr_items(p_formula_header_rec.formula_id) THEN

Line 816: END IF; -- IF (gmdfmval_pub.check_expr_items(p_formula_header_rec.formula_id) THEN

812: IF (gmdfmval_pub.check_expr_items(l_tbl_formula_id(i).formula_id)) THEN
813: FND_MESSAGE.SET_NAME('GMD','GMD_EXPR_ITEMS_FOUND');
814: FND_MSG_PUB.ADD;
815: RAISE FND_API.G_EXC_ERROR;
816: END IF; -- IF (gmdfmval_pub.check_expr_items(p_formula_header_rec.formula_id) THEN
817: END IF; -- IF (X_status_type = 700) THEN
818:
819: --Check any inactive items in formula before changing the status
820: IF (l_entity_status.status_type IN (400,700)) THEN

Line 821: IF (gmdfmval_pub.inactive_items(l_tbl_formula_id(i).formula_id)) THEN

817: END IF; -- IF (X_status_type = 700) THEN
818:
819: --Check any inactive items in formula before changing the status
820: IF (l_entity_status.status_type IN (400,700)) THEN
821: IF (gmdfmval_pub.inactive_items(l_tbl_formula_id(i).formula_id)) THEN
822: FND_MESSAGE.SET_NAME('GMI','IC_ITEM_INACTIVE');
823: FND_MSG_PUB.ADD;
824: RAISE FND_API.G_EXC_ERROR;
825: END IF; -- IF (gmdfmval_pub.inactive_items(V_formula_id) THEN

Line 825: END IF; -- IF (gmdfmval_pub.inactive_items(V_formula_id) THEN

821: IF (gmdfmval_pub.inactive_items(l_tbl_formula_id(i).formula_id)) THEN
822: FND_MESSAGE.SET_NAME('GMI','IC_ITEM_INACTIVE');
823: FND_MSG_PUB.ADD;
824: RAISE FND_API.G_EXC_ERROR;
825: END IF; -- IF (gmdfmval_pub.inactive_items(V_formula_id) THEN
826: END IF; --l_entity_status.status_type IN (400,700)
827: --kkillams,bug 3408799
828:
829: IF (l_entity_status.entity_status <> 100) THEN

Line 1064: GMDFMVAL_PUB.get_formula_id(p_formula_header_rec.formula_no,

1060: IF (l_debug = 'Y') THEN
1061: gmd_debug.put_line(' Before formula validation - '||x_return_status);
1062: END IF;
1063: IF (p_formula_header_rec.formula_id is NULL) THEN
1064: GMDFMVAL_PUB.get_formula_id(p_formula_header_rec.formula_no,
1065: p_formula_header_rec.formula_vers,
1066: l_formula_id, l_return_val);
1067: IF (l_return_val <> 0) THEN
1068: IF (p_formula_header_rec.formula_no IS NULL) THEN

Line 1262: l_return_val := GMDFMVAL_PUB.formula_class_val(

1258: ||' - '
1259: ||x_return_status);
1260: END IF;
1261: IF (p_formula_header_rec.formula_class IS NOT NULL) THEN
1262: l_return_val := GMDFMVAL_PUB.formula_class_val(
1263: p_formula_header_rec.formula_class);
1264: IF (l_return_val <> 0) THEN
1265: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1266: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

Line 1578: l_return_val := GMDFMVAL_PUB.formula_class_val(

1574: ||' - '
1575: ||x_return_status);
1576: END IF;
1577: IF (l_formula_class IS NOT NULL ) THEN
1578: l_return_val := GMDFMVAL_PUB.formula_class_val(
1579: l_formula_class);
1580: IF (l_return_val <> 0) THEN
1581: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1582: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

Line 1842: GMDFMVAL_PUB.get_formula_id(p_formula_header_rec.formula_no,

1838: /* We need a formula id to */
1839: /* delete a header */
1840: /* ======================= */
1841: IF (p_formula_header_rec.formula_id is NULL) THEN
1842: GMDFMVAL_PUB.get_formula_id(p_formula_header_rec.formula_no,
1843: p_formula_header_rec.formula_vers,
1844: l_formula_id, l_return_val);
1845: IF (l_return_val <> 0) THEN
1846: IF (p_formula_header_rec.formula_no IS NULL) THEN