DBA Data[Home] [Help]

APPS.GMD_FORMULA_PUB dependencies on GMDFMVAL_PUB

Line 6: pRecord_in GMDFMVAL_PUB.formula_info_in;

2: /* $Header: GMDPFMHB.pls 120.22.12020000.2 2012/07/17 10:03:27 mtou 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 269: GMDFMVAL_PUB.get_formula_id(p_formula_header_rec.formula_no,

265: /* BAsed on the initial design the formula input table has both */
266: /* header and detail information */
267: /* ================================================================== */
268: IF (p_formula_header_rec.formula_id is NULL) THEN
269: GMDFMVAL_PUB.get_formula_id(p_formula_header_rec.formula_no,
270: p_formula_header_rec.formula_vers,
271: l_formula_id, l_return_val);
272: IF (l_return_val <> 0) THEN
273: IF (p_formula_header_rec.formula_no IS NULL) THEN

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

602: ||' - '
603: ||x_return_status);
604: END IF;
605: IF (p_formula_header_rec.formula_class IS NOT NULL) THEN
606: l_return_val := GMDFMVAL_PUB.formula_class_val(p_formula_header_rec.formula_class);
607: IF (l_return_val <> 0) THEN
608: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
609: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);
610: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', p_formula_header_rec.formula_vers);

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

874: V_orgn_id => l_tbl_formula_id(i).owner_organization_id,
875: X_entity_status => l_entity_status);
876: -- Check for any experimental items when formula status is apfgu.
877: IF (l_entity_status.status_type = 700) THEN
878: IF (gmdfmval_pub.check_expr_items(l_tbl_formula_id(i).formula_id)) THEN
879: FND_MESSAGE.SET_NAME('GMD','GMD_EXPR_ITEMS_FOUND');
880: FND_MSG_PUB.ADD;
881: RAISE FND_API.G_EXC_ERROR;
882: END IF; -- IF (gmdfmval_pub.check_expr_items(p_formula_header_rec.formula_id) THEN

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

878: IF (gmdfmval_pub.check_expr_items(l_tbl_formula_id(i).formula_id)) THEN
879: FND_MESSAGE.SET_NAME('GMD','GMD_EXPR_ITEMS_FOUND');
880: FND_MSG_PUB.ADD;
881: RAISE FND_API.G_EXC_ERROR;
882: END IF; -- IF (gmdfmval_pub.check_expr_items(p_formula_header_rec.formula_id) THEN
883: END IF; -- IF (X_status_type = 700) THEN
884:
885: --Check any inactive items in formula before changing the status
886: IF (l_entity_status.status_type IN (400,700)) THEN

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

883: END IF; -- IF (X_status_type = 700) THEN
884:
885: --Check any inactive items in formula before changing the status
886: IF (l_entity_status.status_type IN (400,700)) THEN
887: IF (gmdfmval_pub.inactive_items(l_tbl_formula_id(i).formula_id)) THEN
888: FND_MESSAGE.SET_NAME('GMI','IC_ITEM_INACTIVE');
889: FND_MSG_PUB.ADD;
890: RAISE FND_API.G_EXC_ERROR;
891: END IF; -- IF (gmdfmval_pub.inactive_items(V_formula_id) THEN

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

887: IF (gmdfmval_pub.inactive_items(l_tbl_formula_id(i).formula_id)) THEN
888: FND_MESSAGE.SET_NAME('GMI','IC_ITEM_INACTIVE');
889: FND_MSG_PUB.ADD;
890: RAISE FND_API.G_EXC_ERROR;
891: END IF; -- IF (gmdfmval_pub.inactive_items(V_formula_id) THEN
892: END IF; --l_entity_status.status_type IN (400,700)
893: --kkillams,bug 3408799
894:
895: IF (l_entity_status.entity_status <> 100) THEN

Line 1133: GMDFMVAL_PUB.get_formula_id(p_formula_header_rec.formula_no,

1129: IF (l_debug = 'Y') THEN
1130: gmd_debug.put_line(' Before formula validation - '||x_return_status);
1131: END IF;
1132: IF (p_formula_header_rec.formula_id is NULL) THEN
1133: GMDFMVAL_PUB.get_formula_id(p_formula_header_rec.formula_no,
1134: p_formula_header_rec.formula_vers,
1135: l_formula_id, l_return_val);
1136: IF (l_return_val <> 0) THEN
1137: IF (p_formula_header_rec.formula_no IS NULL) THEN

Line 1336: l_return_val := GMDFMVAL_PUB.formula_class_val(

1332: ||' - '
1333: ||x_return_status);
1334: END IF;
1335: IF (p_formula_header_rec.formula_class IS NOT NULL) THEN
1336: l_return_val := GMDFMVAL_PUB.formula_class_val(
1337: p_formula_header_rec.formula_class);
1338: IF (l_return_val <> 0) THEN
1339: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1340: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

Line 1652: l_return_val := GMDFMVAL_PUB.formula_class_val(

1648: ||' - '
1649: ||x_return_status);
1650: END IF;
1651: IF (l_formula_class IS NOT NULL ) THEN
1652: l_return_val := GMDFMVAL_PUB.formula_class_val(
1653: l_formula_class);
1654: IF (l_return_val <> 0) THEN
1655: FND_MESSAGE.SET_NAME('GMD', 'FM_INVCLASS');
1656: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_header_rec.formula_no);

Line 1917: GMDFMVAL_PUB.get_formula_id(p_formula_header_rec.formula_no,

1913: /* We need a formula id to */
1914: /* delete a header */
1915: /* ======================= */
1916: IF (p_formula_header_rec.formula_id is NULL) THEN
1917: GMDFMVAL_PUB.get_formula_id(p_formula_header_rec.formula_no,
1918: p_formula_header_rec.formula_vers,
1919: l_formula_id, l_return_val);
1920: IF (l_return_val <> 0) THEN
1921: IF (p_formula_header_rec.formula_no IS NULL) THEN