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_SPREADSHEET_UPDATE dependencies on FND_API

Line 22: X_return_status := FND_API.g_ret_sts_success;

18: WHERE formula_id = P_formula_id
19: FOR UPDATE OF LAST_UPDATE_DATE NOWAIT;
20: X_last_update_date DATE;
21: BEGIN
22: X_return_status := FND_API.g_ret_sts_success;
23: OPEN Cur_lock_header;
24: FETCH Cur_lock_header INTO X_last_update_date;
25: CLOSE Cur_lock_header;
26: IF X_last_update_date <> P_last_update_date THEN

Line 30: X_return_status := FND_API.g_ret_sts_error;

26: IF X_last_update_date <> P_last_update_date THEN
27: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECORD_CHANGED');
28: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_FORM_MST');
29: FND_MSG_PUB.ADD;
30: X_return_status := FND_API.g_ret_sts_error;
31: END IF;
32: EXCEPTION
33: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
34: IF Cur_lock_header%ISOPEN THEN

Line 42: X_return_status := FND_API.g_ret_sts_error;

38: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_FORM_MST');
39: FND_MESSAGE.SET_TOKEN('RECORD', 'FORMULA_ID');
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;

Line 45: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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: /*##############################################################
49: # NAME

Line 66: X_return_status := FND_API.g_ret_sts_success;

62: WHERE formulaline_id = P_formulaline_id
63: FOR UPDATE OF LAST_UPDATE_DATE NOWAIT;
64: X_last_update_date DATE;
65: BEGIN
66: X_return_status := FND_API.g_ret_sts_success;
67: OPEN Cur_lock_details;
68: FETCH Cur_lock_details INTO X_last_update_date;
69: CLOSE Cur_lock_details;
70: IF X_last_update_date <> P_last_update_date THEN

Line 74: X_return_status := FND_API.g_ret_sts_error;

70: IF X_last_update_date <> P_last_update_date THEN
71: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECORD_CHANGED');
72: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_MATL_DTL');
73: FND_MSG_PUB.ADD;
74: X_return_status := FND_API.g_ret_sts_error;
75: END IF;
76: EXCEPTION
77: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
78: IF Cur_lock_details%ISOPEN THEN

Line 86: X_return_status := FND_API.g_ret_sts_error;

82: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_MATL_DTL');
83: FND_MESSAGE.SET_TOKEN('RECORD', 'FORMULALINE_ID');
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;

Line 89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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: /*##############################################################
93: # NAME

Line 116: X_return_status := FND_API.g_ret_sts_success;

112: l_last_update_date DATE;
113: l_return_status VARCHAR2(10);
114: error_lock EXCEPTION;
115: BEGIN
116: X_return_status := FND_API.g_ret_sts_success;
117: SAVEPOINT lock_formula_record;
118: OPEN Cur_get_hdr;
119: FETCH Cur_get_hdr INTO l_last_update_date;
120: CLOSE Cur_get_hdr;

Line 143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
147: /*##############################################################

Line 164: X_return_status := FND_API.g_ret_sts_success;

160: WHERE batch_id = P_batch_id
161: FOR UPDATE OF LAST_UPDATE_DATE NOWAIT;
162: X_last_update_date DATE;
163: BEGIN
164: X_return_status := FND_API.g_ret_sts_success;
165: OPEN Cur_lock_header;
166: FETCH Cur_lock_header INTO X_last_update_date;
167: CLOSE Cur_lock_header;
168: IF X_last_update_date <> P_last_update_date THEN

Line 172: X_return_status := FND_API.g_ret_sts_error;

168: IF X_last_update_date <> P_last_update_date THEN
169: FND_MESSAGE.SET_NAME('GME', 'GME_RECORD_CHANGED');
170: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_BATCH_HEADER');
171: FND_MSG_PUB.ADD;
172: X_return_status := FND_API.g_ret_sts_error;
173: END IF;
174: EXCEPTION
175: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
176: IF Cur_lock_header%ISOPEN THEN

Line 184: X_return_status := FND_API.g_ret_sts_error;

180: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_BATCH_HEADER');
181: FND_MESSAGE.SET_TOKEN('RECORD', 'BATCH_ID');
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;

Line 187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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: /*##############################################################
191: # NAME

Line 208: X_return_status := FND_API.g_ret_sts_success;

204: WHERE material_detail_id = P_material_detail_id
205: FOR UPDATE OF LAST_UPDATE_DATE NOWAIT;
206: X_last_update_date DATE;
207: BEGIN
208: X_return_status := FND_API.g_ret_sts_success;
209: OPEN Cur_lock_details;
210: FETCH Cur_lock_details INTO X_last_update_date;
211: CLOSE Cur_lock_details;
212:

Line 217: X_return_status := FND_API.g_ret_sts_error;

213: IF X_last_update_date <> P_last_update_date THEN
214: FND_MESSAGE.SET_NAME('GME', 'GME_RECORD_CHANGED');
215: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_MATERIAL_DETAILS');
216: FND_MSG_PUB.ADD;
217: X_return_status := FND_API.g_ret_sts_error;
218: END IF;
219: EXCEPTION
220: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
221: IF Cur_lock_details%ISOPEN THEN

Line 229: X_return_status := FND_API.g_ret_sts_error;

225: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_MATERIAL_DETAILS');
226: FND_MESSAGE.SET_TOKEN('RECORD', 'MATERIAL_DETAIL_ID');
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;

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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: /*##############################################################
236: # NAME

Line 260: X_return_status := FND_API.g_ret_sts_success;

256: l_last_update_date DATE;
257: l_return_status VARCHAR2(10);
258: error_lock EXCEPTION;
259: BEGIN
260: X_return_status := FND_API.g_ret_sts_success;
261: SAVEPOINT lock_batch_record;
262: OPEN Cur_get_hdr;
263: FETCH Cur_get_hdr INTO l_last_update_date;
264: CLOSE Cur_get_hdr;

Line 287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
291:

Line 412: X_return_status := FND_API.g_ret_sts_success;

408: update_line_err EXCEPTION;
409: delete_line_err EXCEPTION;
410: BEGIN
411: /* Initialize return status */
412: X_return_status := FND_API.g_ret_sts_success;
413: /* Establish the savepoint */
414: SAVEPOINT update_batch;
415:
416: /*Let us first check if their are any changes in the batch */

Line 513: ,p_scale_phantom => fnd_api.g_false

509: gme_material_detail_pvt.update_material_line (p_batch_header_rec => l_batch_row
510: ,p_material_detail_rec => X_material
511: ,p_stored_material_detail_rec => NULL
512: ,p_batch_step_rec => l_batch_step
513: ,p_scale_phantom => fnd_api.g_false
514: ,p_trans_id => NULL
515: ,x_transacted => l_transacted
516: ,x_return_status => l_return_status
517: ,x_material_detail_rec => l_material_out);

Line 645: X_return_status := FND_API.g_ret_sts_error;

641: WHERE material_detail_id = a.material_detail_id);
642: EXCEPTION
643: WHEN error_setup THEN
644: ROLLBACK TO SAVEPOINT update_batch;
645: X_return_status := FND_API.g_ret_sts_error;
646: WHEN error_load_batch OR update_alloc_err OR insert_line_err OR update_line_err
647: OR delete_line_err OR lock_batch_err THEN
648: ROLLBACK TO SAVEPOINT update_batch;
649: X_return_status := l_return_status;

Line 653: x_return_status := FND_API.g_ret_sts_unexp_error;

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: /*##############################################################
657: # NAME

Line 748: X_return_status := FND_API.g_ret_sts_success;

744: trans_update EXCEPTION;
745:
746: BEGIN
747: /* Initialize return status */
748: X_return_status := FND_API.g_ret_sts_success;
749:
750: /* Lets check wheter transaction qty is changed for any of the material lines */
751: /* if yes raise an error message */
752: FOR l_qty IN Cur_get_new_qty LOOP

Line 856: X_return_status := FND_API.g_ret_sts_error;

852: WHEN update_alloc_err OR insert_alloc_err OR delete_alloc_err THEN
853: X_return_status := l_return_status;
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;

Line 859: x_return_status := FND_API.g_ret_sts_unexp_error;

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;