APPS.GMI_SUMM_INV_PVT dependencies on IC_SUMM_INV

Line 13: | Logic For IC_SUMM_INV |

9: | GMIVBUSB.pls |
10: | |
11: | DESCRIPTION |
12: | This package contains private definitions For Business Layer |
13: | Logic For IC_SUMM_INV |
14: | |
15: | HISTORY |
16: | 12-JAN-2000 H.Verdding |
17: +=========================================================================+

Line 21: IC_SUMM_INV transactions

17: +=========================================================================+
18: API Name : GMI_SUMM_INV_PVT
19: Type : Public
20: Function : This package contains private procedures used to create
21: IC_SUMM_INV transactions
22: Pre-reqs : N/A
23: Parameters: Per function
24:
25: Current Vers : 1.0

Line 47: l_summ_inv IC_SUMM_INV%ROWTYPE;

43: )
44: IS
45: err_num NUMBER;
46: err_msg VARCHAR2(200);
47: l_summ_inv IC_SUMM_INV%ROWTYPE;
48:
49: BEGIN
50:
51: /* Initialize return status to sucess */

Line 134: IF NOT GMI_SUMM_INV_DB_PVT.UPDATE_IC_SUMM_INV( p_summ_inv => l_summ_inv)

130: END IF;
131:
132: /* Update Inventory Summary Table -- */
133:
134: IF NOT GMI_SUMM_INV_DB_PVT.UPDATE_IC_SUMM_INV( p_summ_inv => l_summ_inv)
135: THEN
136: IF NOT GMI_SUMM_INV_DB_PVT.INSERT_IC_SUMM_INV( p_summ_inv => l_summ_inv)
137: THEN
138: FND_MESSAGE.SET_NAME('GMI','GMI_IC_SUMM_INV_INSERT');

Line 136: IF NOT GMI_SUMM_INV_DB_PVT.INSERT_IC_SUMM_INV( p_summ_inv => l_summ_inv)

132: /* Update Inventory Summary Table -- */
133:
134: IF NOT GMI_SUMM_INV_DB_PVT.UPDATE_IC_SUMM_INV( p_summ_inv => l_summ_inv)
135: THEN
136: IF NOT GMI_SUMM_INV_DB_PVT.INSERT_IC_SUMM_INV( p_summ_inv => l_summ_inv)
137: THEN
138: FND_MESSAGE.SET_NAME('GMI','GMI_IC_SUMM_INV_INSERT');
139: FND_MSG_PUB.ADD;
140: RAISE FND_API.G_EXC_ERROR;

Line 138: FND_MESSAGE.SET_NAME('GMI','GMI_IC_SUMM_INV_INSERT');

134: IF NOT GMI_SUMM_INV_DB_PVT.UPDATE_IC_SUMM_INV( p_summ_inv => l_summ_inv)
135: THEN
136: IF NOT GMI_SUMM_INV_DB_PVT.INSERT_IC_SUMM_INV( p_summ_inv => l_summ_inv)
137: THEN
138: FND_MESSAGE.SET_NAME('GMI','GMI_IC_SUMM_INV_INSERT');
139: FND_MSG_PUB.ADD;
140: RAISE FND_API.G_EXC_ERROR;
141: END IF;
142: END IF;

Line 171: l_summ_inv IC_SUMM_INV%ROWTYPE;

167: IS
168: err_num NUMBER;
169: err_msg VARCHAR2(200);
170:
171: l_summ_inv IC_SUMM_INV%ROWTYPE;
172: l_lots_sts IC_LOTS_STS%ROWTYPE;
173: BEGIN
174:
175: /* Initialize return status to sucess */

Line 265: IF NOT GMI_SUMM_INV_DB_PVT.UPDATE_IC_SUMM_INV( p_summ_inv => l_summ_inv)

261: END IF;
262:
263: /* Update Inventory Summary Table -- */
264:
265: IF NOT GMI_SUMM_INV_DB_PVT.UPDATE_IC_SUMM_INV( p_summ_inv => l_summ_inv)
266: THEN
267:
268: IF NOT GMI_SUMM_INV_DB_PVT.INSERT_IC_SUMM_INV( p_summ_inv => l_summ_inv)
269: THEN

Line 268: IF NOT GMI_SUMM_INV_DB_PVT.INSERT_IC_SUMM_INV( p_summ_inv => l_summ_inv)

264:
265: IF NOT GMI_SUMM_INV_DB_PVT.UPDATE_IC_SUMM_INV( p_summ_inv => l_summ_inv)
266: THEN
267:
268: IF NOT GMI_SUMM_INV_DB_PVT.INSERT_IC_SUMM_INV( p_summ_inv => l_summ_inv)
269: THEN
270: FND_MESSAGE.SET_NAME('GMI','GMI_IC_SUMM_INV_INSERT');
271: FND_MSG_PUB.ADD;
272: RAISE FND_API.G_EXC_ERROR;

Line 270: FND_MESSAGE.SET_NAME('GMI','GMI_IC_SUMM_INV_INSERT');

266: THEN
267:
268: IF NOT GMI_SUMM_INV_DB_PVT.INSERT_IC_SUMM_INV( p_summ_inv => l_summ_inv)
269: THEN
270: FND_MESSAGE.SET_NAME('GMI','GMI_IC_SUMM_INV_INSERT');
271: FND_MSG_PUB.ADD;
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274: END IF;