DBA Data[Home] [Help]

APPS.GMD_SPREADSHEET_UPDATE dependencies on GMD_SPREADSHEET_UPDATE

Line 1: PACKAGE BODY GMD_SPREADSHEET_UPDATE AS

1: PACKAGE BODY GMD_SPREADSHEET_UPDATE AS
2: /* $Header: GMDSPUPB.pls 120.11 2006/09/19 15:10:12 kmotupal noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_SPREADSHEET_UPDATE';
4:
5: /*##############################################################

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_SPREADSHEET_UPDATE';

1: PACKAGE BODY GMD_SPREADSHEET_UPDATE AS
2: /* $Header: GMDSPUPB.pls 120.11 2006/09/19 15:10:12 kmotupal noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_SPREADSHEET_UPDATE';
4:
5: /*##############################################################
6: # NAME
7: # lock_formula_hdr

Line 44: fnd_msg_pub.add_exc_msg ('GMD_SPREADSHEET_UPDATE', 'Lock_Formula_Hdr');

40: FND_MESSAGE.SET_TOKEN('KEY', P_formula_id);
41: FND_MSG_PUB.ADD;
42: X_return_status := FND_API.g_ret_sts_error;
43: WHEN OTHERS THEN
44: fnd_msg_pub.add_exc_msg ('GMD_SPREADSHEET_UPDATE', 'Lock_Formula_Hdr');
45: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
46: END lock_formula_hdr;
47:
48: /*##############################################################

Line 88: fnd_msg_pub.add_exc_msg ('GMD_SPREADSHEET_UPDATE', 'Lock_Formula_Dtl');

84: FND_MESSAGE.SET_TOKEN('KEY', P_formulaline_id);
85: FND_MSG_PUB.ADD;
86: X_return_status := FND_API.g_ret_sts_error;
87: WHEN OTHERS THEN
88: fnd_msg_pub.add_exc_msg ('GMD_SPREADSHEET_UPDATE', 'Lock_Formula_Dtl');
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
90: END lock_formula_dtl;
91:
92: /*##############################################################

Line 142: fnd_msg_pub.add_exc_msg ('GMD_SPREADSHEET_UPDATE', 'Lock_formula_Record');

138: WHEN error_lock THEN
139: X_return_status := l_return_status;
140: ROLLBACK TO SAVEPOINT lock_formula_record;
141: WHEN OTHERS THEN
142: fnd_msg_pub.add_exc_msg ('GMD_SPREADSHEET_UPDATE', 'Lock_formula_Record');
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: ROLLBACK TO SAVEPOINT lock_formula_record;
145: END lock_formula_record;
146:

Line 186: fnd_msg_pub.add_exc_msg ('GMD_SPREADSHEET_UPDATE', 'Lock_Batch_Hdr');

182: FND_MESSAGE.SET_TOKEN('KEY', P_batch_id);
183: FND_MSG_PUB.ADD;
184: X_return_status := FND_API.g_ret_sts_error;
185: WHEN OTHERS THEN
186: fnd_msg_pub.add_exc_msg ('GMD_SPREADSHEET_UPDATE', 'Lock_Batch_Hdr');
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: END lock_batch_hdr;
189:
190: /*##############################################################

Line 231: fnd_msg_pub.add_exc_msg ('GMD_SPREADSHEET_UPDATE', 'Lock_Batch_Dtl');

227: FND_MESSAGE.SET_TOKEN('KEY', P_material_detail_id);
228: FND_MSG_PUB.ADD;
229: X_return_status := FND_API.g_ret_sts_error;
230: WHEN OTHERS THEN
231: fnd_msg_pub.add_exc_msg ('GMD_SPREADSHEET_UPDATE', 'Lock_Batch_Dtl');
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: END lock_batch_dtl;
234:
235: /*##############################################################

Line 286: fnd_msg_pub.add_exc_msg ('GMD_SPREADSHEET_UPDATE', 'Lock_Batch_Record');

282: WHEN error_lock THEN
283: X_return_status := l_return_status;
284: ROLLBACK TO SAVEPOINT lock_batch_record;
285: WHEN OTHERS THEN
286: fnd_msg_pub.add_exc_msg ('GMD_SPREADSHEET_UPDATE', 'Lock_Batch_Record');
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: ROLLBACK TO SAVEPOINT lock_batch_record;
289: END lock_batch_record;
290:

Line 652: fnd_msg_pub.add_exc_msg (gmd_spreadsheet_update.g_pkg_name, 'Update_Batch');

648: ROLLBACK TO SAVEPOINT update_batch;
649: X_return_status := l_return_status;
650: WHEN OTHERS THEN
651: ROLLBACK TO SAVEPOINT update_batch;
652: fnd_msg_pub.add_exc_msg (gmd_spreadsheet_update.g_pkg_name, 'Update_Batch');
653: x_return_status := FND_API.g_ret_sts_unexp_error;
654: END update_batch;
655:
656: /*##############################################################

Line 858: fnd_msg_pub.add_exc_msg (gmd_spreadsheet_update.g_pkg_name, 'Update_Allocation');

854: WHEN trans_update THEN
855: gmd_api_grp.log_message('GMD_QTY_NO_UPDATE');
856: X_return_status := FND_API.g_ret_sts_error;
857: WHEN OTHERS THEN
858: fnd_msg_pub.add_exc_msg (gmd_spreadsheet_update.g_pkg_name, 'Update_Allocation');
859: x_return_status := FND_API.g_ret_sts_unexp_error;
860: END update_allocation;
861:
862: END GMD_SPREADSHEET_UPDATE;

Line 862: END GMD_SPREADSHEET_UPDATE;

858: fnd_msg_pub.add_exc_msg (gmd_spreadsheet_update.g_pkg_name, 'Update_Allocation');
859: x_return_status := FND_API.g_ret_sts_unexp_error;
860: END update_allocation;
861:
862: END GMD_SPREADSHEET_UPDATE;