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_MSG_PUB

Line 29: FND_MSG_PUB.ADD;

25: CLOSE Cur_lock_header;
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

Line 41: FND_MSG_PUB.ADD;

37: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECORD_LOCK');
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;

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 73: FND_MSG_PUB.ADD;

69: CLOSE Cur_lock_details;
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

Line 85: FND_MSG_PUB.ADD;

81: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECORD_LOCK');
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;

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 171: FND_MSG_PUB.ADD;

167: CLOSE Cur_lock_header;
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

Line 183: FND_MSG_PUB.ADD;

179: FND_MESSAGE.SET_NAME('GME', 'GME_RECORD_LOCKED');
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;

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 216: FND_MSG_PUB.ADD;

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

Line 228: FND_MSG_PUB.ADD;

224: FND_MESSAGE.SET_NAME('GME', 'GME_RECORD_LOCKED');
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;

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;