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

Line 79: x_return_status := FND_API.g_ret_sts_success;

75: fnd_msg_pub.initialize;
76: END IF;
77:
78: /* Initially let us assign the return status to success */
79: x_return_status := FND_API.g_ret_sts_success;
80:
81: IF NOT gmd_api_grp.setup_done THEN
82: gmd_api_grp.setup_done := gmd_api_grp.setup;
83: END IF;

Line 89: IF NOT FND_API.compatible_api_call(l_api_version

85: RAISE setup_failure;
86: END IF;
87:
88: /* Make sure we are call compatible */
89: IF NOT FND_API.compatible_api_call(l_api_version
90: ,p_api_version
91: ,'insert_activity'
92: ,'gmd_activities_pub') THEN
93: RAISE invalid_version;

Line 111: x_return_status := FND_API.g_ret_sts_error;

107: END IF;
108: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
109: FND_MESSAGE.SET_TOKEN ('MISSING', 'ACTIVITY');
110: FND_MSG_PUB.ADD;
111: x_return_status := FND_API.g_ret_sts_error;
112: END IF;
113:
114: /* Cost Analysis Code Validations - Must be passed, otherwise give error */
115: /* Also, cost analysis code must be defined in cm_alys_mst, else give error */

Line 124: x_return_status := FND_API.g_ret_sts_error;

120:
121: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
122: FND_MESSAGE.SET_TOKEN ('MISSING', 'COST_ANALYSIS_CODE');
123: FND_MSG_PUB.ADD;
124: x_return_status := FND_API.g_ret_sts_error;
125: ELSE
126: IF GMDOPVAL_PUB.check_cost_analysis (pcost_analysis_code => p_activity_tbl(i).cost_analysis_code) <> 0 THEN
127: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_ANLYS_CODE');
128: FND_MSG_PUB.ADD;

Line 129: x_return_status := FND_API.g_ret_sts_error;

125: ELSE
126: IF GMDOPVAL_PUB.check_cost_analysis (pcost_analysis_code => p_activity_tbl(i).cost_analysis_code) <> 0 THEN
127: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_ANLYS_CODE');
128: FND_MSG_PUB.ADD;
129: x_return_status := FND_API.g_ret_sts_error;
130: END IF;
131: END IF;
132:
133: /* Description must be passed, otherwise give error */

Line 141: x_return_status := FND_API.g_ret_sts_error;

137: END IF;
138: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
139: FND_MESSAGE.SET_TOKEN ('MISSING', 'ACTIVITY_DESC');
140: FND_MSG_PUB.ADD;
141: x_return_status := FND_API.g_ret_sts_error;
142: END IF;
143:
144: END LOOP;
145:

Line 151: IF l_retn_status <> FND_API.g_ret_sts_success THEN

147: GMD_ACTIVITIES_PVT.insert_activity(p_activity_tbl => p_activity_tbl,
148: x_message_count => x_message_count,
149: x_message_list => x_message_list,
150: x_return_status => l_retn_status);
151: IF l_retn_status <> FND_API.g_ret_sts_success THEN
152: RAISE ins_activity_err;
153: END IF;
154:
155: IF p_commit THEN

Line 168: x_return_status := FND_API.G_RET_STS_ERROR;

164: ,p_data => x_message_list);
165:
166: EXCEPTION
167: WHEN setup_failure OR invalid_version THEN
168: x_return_status := FND_API.G_RET_STS_ERROR;
169: ROLLBACK TO SAVEPOINT insert_activity;
170: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
171: P_data => x_message_list);
172: WHEN ins_activity_err THEN

Line 179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

175: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
176: P_data => x_message_list);
177: WHEN OTHERS THEN
178: ROLLBACK TO SAVEPOINT insert_activity;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
181: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
182: FND_MSG_PUB.ADD;
183: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

Line 239: IF NOT FND_API.compatible_api_call(l_api_version

235: RAISE setup_failure;
236: END IF;
237:
238: /* Make sure we are call compatible */
239: IF NOT FND_API.compatible_api_call(l_api_version
240: ,p_api_version
241: ,'update_activity'
242: ,'gmd_activities_pub') THEN
243: RAISE invalid_version;

Line 247: x_return_status := FND_API.g_ret_sts_success;

243: RAISE invalid_version;
244: END IF;
245:
246: /* Initially let us assign the return status to success */
247: x_return_status := FND_API.g_ret_sts_success;
248:
249: IF (l_debug = 'Y') THEN
250: gmd_debug.put_line('Start of update_activity PUB');
251: END IF;

Line 261: x_return_status := FND_API.g_ret_sts_error;

257: END IF;
258: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
259: FND_MESSAGE.SET_TOKEN ('MISSING', 'ACTIVITY');
260: FND_MSG_PUB.ADD;
261: x_return_status := FND_API.g_ret_sts_error;
262: ELSE
263: /* Check for the existense of activity */
264: OPEN Cur_check_activity(p_activity);
265: FETCH Cur_check_activity INTO l_exist;

Line 268: x_return_status := FND_API.g_ret_sts_error;

264: OPEN Cur_check_activity(p_activity);
265: FETCH Cur_check_activity INTO l_exist;
266: IF (Cur_check_activity%NOTFOUND) THEN
267: gmd_api_grp.log_message ('FM_INVACTIVITY');
268: x_return_status := FND_API.g_ret_sts_error;
269: END IF;
270: CLOSE Cur_check_activity;
271: END IF;
272:

Line 280: x_return_status := FND_API.g_ret_sts_error;

276: IF p_update_table(i).p_col_to_update IS NULL THEN
277: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
278: FND_MESSAGE.SET_TOKEN ('MISSING', 'COL_TO_UPDATE');
279: FND_MSG_PUB.ADD;
280: x_return_status := FND_API.g_ret_sts_error;
281: ELSIF p_update_table(i).p_value IS NULL THEN
282: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
283: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_VALUE');
284: FND_MSG_PUB.ADD;

Line 285: x_return_status := FND_API.g_ret_sts_error;

281: ELSIF p_update_table(i).p_value IS NULL THEN
282: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
283: FND_MESSAGE.SET_TOKEN ('MISSING', 'P_VALUE');
284: FND_MSG_PUB.ADD;
285: x_return_status := FND_API.g_ret_sts_error;
286: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'DELETE_MARK' THEN
287: GMDRTVAL_PUB.check_delete_mark ( Pdelete_mark => p_update_table(i).p_value,
288: x_return_status => l_retn_status);
289: IF l_retn_status <> 'S' THEN /* it indicates that invalid value has been passed */

Line 292: x_return_status := FND_API.G_RET_STS_ERROR;

288: x_return_status => l_retn_status);
289: IF l_retn_status <> 'S' THEN /* it indicates that invalid value has been passed */
290: FND_MESSAGE.SET_NAME('GMA', 'SY_BADDELETEMARK');
291: FND_MSG_PUB.ADD;
292: x_return_status := FND_API.G_RET_STS_ERROR;
293: END IF;
294: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'ACTIVITY_DESC' THEN
295: IF p_update_table(i).p_value IS NULL THEN
296: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

Line 299: x_return_status := FND_API.g_ret_sts_error;

295: IF p_update_table(i).p_value IS NULL THEN
296: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
297: FND_MESSAGE.SET_TOKEN ('MISSING', 'ACTIVITY_DESC');
298: FND_MSG_PUB.ADD;
299: x_return_status := FND_API.g_ret_sts_error;
300: END IF;
301: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'COST_ANALYSIS_CODE' THEN
302: IF p_update_table(i).p_value IS NULL THEN
303: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

Line 306: x_return_status := FND_API.g_ret_sts_error;

302: IF p_update_table(i).p_value IS NULL THEN
303: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
304: FND_MESSAGE.SET_TOKEN ('MISSING', 'COST_ANALYSIS_CODE');
305: FND_MSG_PUB.ADD;
306: x_return_status := FND_API.g_ret_sts_error;
307: ELSE
308: IF GMDOPVAL_PUB.check_cost_analysis (pcost_analysis_code => p_update_table(i).p_value) <> 0 THEN
309: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_ANLYS_CODE');
310: FND_MSG_PUB.ADD;

Line 311: x_return_status := FND_API.g_ret_sts_error;

307: ELSE
308: IF GMDOPVAL_PUB.check_cost_analysis (pcost_analysis_code => p_update_table(i).p_value) <> 0 THEN
309: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_COST_ANLYS_CODE');
310: FND_MSG_PUB.ADD;
311: x_return_status := FND_API.g_ret_sts_error;
312: END IF;
313: END IF;
314: END IF;
315: END LOOP;

Line 323: IF l_retn_status <> FND_API.g_ret_sts_success THEN

319: , p_update_table => p_update_table
320: , x_message_count => x_message_count
321: , x_message_list => x_message_list
322: , x_return_status => l_retn_status);
323: IF l_retn_status <> FND_API.g_ret_sts_success THEN
324: RAISE upd_activity_err;
325: END IF;
326:
327: IF p_commit THEN

Line 340: x_return_status := FND_API.G_RET_STS_ERROR;

336: ,p_data => x_message_list);
337:
338: EXCEPTION
339: WHEN setup_failure OR invalid_version THEN
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: ROLLBACK to SAVEPOINT update_activity;
342: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
343: P_data => x_message_list);
344: WHEN upd_activity_err THEN

Line 351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

347: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
348: P_data => x_message_list);
349: WHEN OTHERS THEN
350: ROLLBACK to SAVEPOINT update_activity;
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
353: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
354: FND_MSG_PUB.ADD;
355: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

Line 387: x_return_status := FND_API.g_ret_sts_success;

383: gmd_debug.log_initialize('DelActv');
384: END IF;
385:
386: /* Initially let us assign the return status to success */
387: x_return_status := FND_API.g_ret_sts_success;
388:
389: v_update_table(1).p_col_to_update := 'DELETE_MARK';
390: v_update_table(1).p_value := '1';
391:

Line 399: IF l_retn_status <> FND_API.g_ret_sts_success THEN

395: ,p_update_table => v_update_table
396: , x_message_count => x_message_count
397: , x_message_list => x_message_list
398: , x_return_status => l_retn_status);
399: IF l_retn_status <> FND_API.g_ret_sts_success THEN
400: RAISE del_activity_err;
401: END IF;
402:
403: IF p_commit THEN

Line 418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

414: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
415: P_data => x_message_list);
416: WHEN OTHERS THEN
417: ROLLBACK to SAVEPOINT delete_activity;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
420: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
421: FND_MSG_PUB.ADD;
422: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,