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_MESSAGE

Line 27: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECORD_CHANGED');

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
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;

Line 28: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_FORM_MST');

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

Line 37: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECORD_LOCK');

33: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
34: IF Cur_lock_header%ISOPEN THEN
35: CLOSE Cur_lock_header;
36: END IF;
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;

Line 38: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_FORM_MST');

34: IF Cur_lock_header%ISOPEN THEN
35: CLOSE Cur_lock_header;
36: END IF;
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;

Line 39: FND_MESSAGE.SET_TOKEN('RECORD', 'FORMULA_ID');

35: CLOSE Cur_lock_header;
36: END IF;
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

Line 40: FND_MESSAGE.SET_TOKEN('KEY', P_formula_id);

36: END IF;
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');

Line 71: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECORD_CHANGED');

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
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;

Line 72: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_MATL_DTL');

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

Line 81: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECORD_LOCK');

77: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
78: IF Cur_lock_details%ISOPEN THEN
79: CLOSE Cur_lock_details;
80: END IF;
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;

Line 82: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'FM_MATL_DTL');

78: IF Cur_lock_details%ISOPEN THEN
79: CLOSE Cur_lock_details;
80: END IF;
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;

Line 83: FND_MESSAGE.SET_TOKEN('RECORD', 'FORMULALINE_ID');

79: CLOSE Cur_lock_details;
80: END IF;
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

Line 84: FND_MESSAGE.SET_TOKEN('KEY', P_formulaline_id);

80: END IF;
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');

Line 169: FND_MESSAGE.SET_NAME('GME', 'GME_RECORD_CHANGED');

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
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;

Line 170: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_BATCH_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
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

Line 179: FND_MESSAGE.SET_NAME('GME', 'GME_RECORD_LOCKED');

175: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
176: IF Cur_lock_header%ISOPEN THEN
177: CLOSE Cur_lock_header;
178: END IF;
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;

Line 180: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_BATCH_HEADER');

176: IF Cur_lock_header%ISOPEN THEN
177: CLOSE Cur_lock_header;
178: END IF;
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;

Line 181: FND_MESSAGE.SET_TOKEN('RECORD', 'BATCH_ID');

177: CLOSE Cur_lock_header;
178: END IF;
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

Line 182: FND_MESSAGE.SET_TOKEN('KEY', P_batch_id);

178: END IF;
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');

Line 214: FND_MESSAGE.SET_NAME('GME', 'GME_RECORD_CHANGED');

210: FETCH Cur_lock_details INTO X_last_update_date;
211: CLOSE Cur_lock_details;
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;

Line 215: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_MATERIAL_DETAILS');

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

Line 224: FND_MESSAGE.SET_NAME('GME', 'GME_RECORD_LOCKED');

220: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
221: IF Cur_lock_details%ISOPEN THEN
222: CLOSE Cur_lock_details;
223: END IF;
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;

Line 225: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'GME_MATERIAL_DETAILS');

221: IF Cur_lock_details%ISOPEN THEN
222: CLOSE Cur_lock_details;
223: END IF;
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;

Line 226: FND_MESSAGE.SET_TOKEN('RECORD', 'MATERIAL_DETAIL_ID');

222: CLOSE Cur_lock_details;
223: END IF;
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

Line 227: FND_MESSAGE.SET_TOKEN('KEY', P_material_detail_id);

223: END IF;
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');