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.MSC_UNDO dependencies on FND_API

Line 58: x_return_status := fnd_api.g_ret_sts_success;

54: -- initialize message list
55: FND_MSG_PUB.initialize;
56: set_Vars;
57: IF undoid.count = 0 THEN
58: x_return_status := fnd_api.g_ret_sts_success;
59: return;
60: END IF;
61: i := undoid.first;
62: LOOP

Line 113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

109: and undo_id = l_undo_id;
110: end if;
111: Exception
112: When others then
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: FND_MSG_PUB.add_exc_msg('MSC_UNDO', 'UNDO');
115: FND_MSG_PUB.count_and_get(p_count=>x_msg_count,
116: p_data=>x_msg_data);
117: End ;

Line 189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

185: -- end delete undo_details
186:
187: Exception
188: When others then
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: FND_MSG_PUB.add_exc_msg('MSC_UNDO', 'UNDO');
191: FND_MSG_PUB.count_and_get(p_count=>x_msg_count,
192: p_data=>x_msg_data);
193: End ;

Line 202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

198: where plan_id = l_plan_id
199: and undo_id = l_undo_id;
200: Exception
201: When others then
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: FND_MSG_PUB.add_exc_msg('MSC_UNDO', 'UNDO');
204: FND_MSG_PUB.count_and_get(p_count=>x_msg_count,
205: p_data=>x_msg_data);
206: End ;

Line 214: x_return_status := fnd_api.g_ret_sts_success;

210: EXIT WHEN i = undoid.last ;
211: i := undoid.next(i);
212:
213: END LOOP;
214: x_return_status := fnd_api.g_ret_sts_success;
215: fnd_msg_pub.count_and_get(p_count => x_msg_count,
216: p_data=>x_msg_data);
217: EXCEPTION
218: WHEN OTHERS THEN

Line 219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

215: fnd_msg_pub.count_and_get(p_count => x_msg_count,
216: p_data=>x_msg_data);
217: EXCEPTION
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: FND_MSG_PUB.add_exc_msg('MSC_UNDO', 'UNDO');
221: FND_MSG_PUB.count_and_get(p_count=>x_msg_count,
222: p_data=>x_msg_data);
223: end UNDO;

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

255: return;
256: end if;
257:
258: if ( action not in (inserted, updated) ) then
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: FND_MSG_PUB.add_exc_msg('MSC_UNDO',
261: 'DEVELOPER ERROR : Invalid action passed to STORE_UNDO');
262: FND_MSG_PUB.count_and_get(p_count=>x_msg_count,
263: p_data=>x_msg_data);

Line 269: x_return_status := fnd_api.g_ret_sts_success;

265: end if;
266:
267: if ( (action = inserted) or (action = updated) ) then
268: if ( action = updated) and (changed_values.count = 0) then
269: x_return_status := fnd_api.g_ret_sts_success;
270: return;
271: end if;
272: BEGIN
273: if ( table_changed in (1,2,5,6,7) ) then

Line 366: x_return_status := FND_API.G_RET_STS_SUCCESS;

362: END ;
363: END LOOP;
364: end if;
365:
366: x_return_status := FND_API.G_RET_STS_SUCCESS;
367:
368: end STORE_UNDO;
369:
370: procedure ADD_BOOKMARK(bookmark_name VARCHAR2,

Line 389: x_return_status := FND_API.G_RET_STS_ERROR;

385: end if;
386:
387: IF ( action not in
388: (bookmark, start_online, replan_start, replan_stop, stop_online) ) THEN
389: x_return_status := FND_API.G_RET_STS_ERROR;
390: x_msg_count := 1;
391: x_msg_data := 'DEVELOPER ERROR : '
392: ||' Invalid Action passed to MSC_UNDO.add_bookmark';
393: FND_MSG_PUB.count_and_get(p_count =>x_msg_count,

Line 400: x_return_status := FND_API.G_RET_STS_SUCCESS;

396: SELECT MSC_UNDO_SUMMARY_S.nextval
397: INTO v_undo_id
398: from dual;
399:
400: x_return_status := FND_API.G_RET_STS_SUCCESS;
401:
402: --Insert a record into MSC_UNDO_SUMMARY
403: INSERT INTO MSC_UNDO_SUMMARY (
404: undo_id,

Line 431: x_return_status := FND_API.G_RET_STS_SUCCESS;

427: 0,
428: bookmark_name );
429: END IF;
430:
431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432:
433: EXCEPTION
434: WHEN OTHERS THEN
435: ROLLBACK;

Line 436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

432:
433: EXCEPTION
434: WHEN OTHERS THEN
435: ROLLBACK;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437: FND_MSG_PUB.add_exc_msg('MSC_UNDO', 'Add_Bookmark');
438: FND_MSG_PUB.count_and_get(p_count=>x_msg_count,
439: p_data => x_msg_data);
440:

Line 633: x_return_status := fnd_api.g_ret_sts_success;

629: and sr_instance_id = l_sr_instance_id
630: and shipment_id = l_transaction_id;
631: end if;
632:
633: x_return_status := fnd_api.g_ret_sts_success;
634:
635: EXCEPTION
636: WHEN OTHERS THEN
637: ROLLBACK;

Line 638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

634:
635: EXCEPTION
636: WHEN OTHERS THEN
637: ROLLBACK;
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: FND_MSG_PUB.add_exc_msg('MSC_UNDO', 'INSERT_TABLE');
640: FND_MSG_PUB.count_and_get(p_count=>x_msg_count,
641: p_data => x_msg_data);
642: END insert_table ;

Line 849: x_return_status := FND_API.G_RET_STS_SUCCESS;

845: p_transaction_id, p_sr_instance_id ;
846:
847: end if;
848:
849: x_return_status := FND_API.G_RET_STS_SUCCESS;
850:
851: EXCEPTION
852: WHEN OTHERS THEN
853: --ROLLBACK;

Line 854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

850:
851: EXCEPTION
852: WHEN OTHERS THEN
853: --ROLLBACK;
854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
855: FND_MSG_PUB.add_exc_msg('MSC_UNDO', 'UPDATE_TABLE'
856: ||' '||sql_string);
857: FND_MSG_PUB.count_and_get(p_count=>x_msg_count,
858: p_data => x_msg_data);

Line 983: x_return_status := FND_API.G_RET_STS_ERROR;

979:
980: l_token := l_identifier1_name||' '||l_identifier2_name||' '||
981: l_identifier3_name;
982: if (fnd_global.user_id <> l_last_updated_by ) then
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: FND_MESSAGE.SET_NAME('MSC', 'MSC_UNDO_OTHER_USERS');
985: FND_MESSAGE.SET_TOKEN('RECORD',l_token);
986: FND_MSG_PUB.ADD;
987: FND_MSG_PUB.count_and_get(p_count=>x_msg_count,

Line 1000: x_return_status := FND_API.G_RET_STS_ERROR;

996: fetch c_noundo_diff1 into l_count;
997: close c_noundo_diff1 ;
998:
999: if (l_count <> 0 ) then
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: FND_MESSAGE.set_name('MSC', 'MSC_UNDO_REC_CHG_DIFF_USER');
1002: FND_MESSAGE.SET_TOKEN('RECORD',l_token);
1003: FND_MSG_PUB.ADD;
1004: FND_MSG_PUB.count_and_get(p_count=>x_msg_count,

Line 1016: x_return_status := FND_API.G_RET_STS_ERROR;

1012: fetch c_noundo_diff2 into l_count;
1013: close c_noundo_diff2 ;
1014:
1015: if (l_count <> 0 ) then
1016: x_return_status := FND_API.G_RET_STS_ERROR;
1017: FND_MESSAGE.set_name('MSC', 'MSC_UNDO_REC_CHG_DIFF_USER');
1018: FND_MESSAGE.SET_TOKEN('RECORD',l_token);
1019: FND_MSG_PUB.ADD;
1020: FND_MSG_PUB.count_and_get(p_count=>x_msg_count,

Line 1034: x_return_status := FND_API.G_RET_STS_ERROR;

1030: fetch c_noundo_same1 into l_count;
1031: close c_noundo_same1 ;
1032:
1033: if (l_count <> 0 ) then
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: FND_MESSAGE.set_name('MSC', 'MSC_UNDO_REC_CHG_SAME_USER');
1036: FND_MESSAGE.SET_TOKEN('RECORD',l_token);
1037: FND_MSG_PUB.ADD;
1038: FND_MSG_PUB.count_and_get(p_count=>x_msg_count,

Line 1050: x_return_status := FND_API.G_RET_STS_ERROR;

1046: fetch c_noundo_same2 into l_count;
1047: close c_noundo_same2 ;
1048:
1049: if (l_count <> 0 ) then
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: FND_MESSAGE.set_name('MSC', 'MSC_UNDO_REC_CHG_SAME_USER');
1052: FND_MESSAGE.SET_TOKEN('RECORD',l_token);
1053: FND_MSG_PUB.ADD;
1054: FND_MSG_PUB.count_and_get(p_count=>x_msg_count,

Line 1068: x_return_status := FND_API.G_RET_STS_ERROR;

1064: open c_nofirm(l_plan_id, l_sr_instance_id, l_transaction_id);
1065: fetch c_nofirm into l_count;
1066: if (l_olprun_undo_id > v_undo_id ) then
1067: if (l_count <> 1) then
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: FND_MESSAGE.set_name('MSC', 'MSC_UNDO_UNFIRM');
1070: FND_MESSAGE.SET_TOKEN('RECORD',l_token);
1071: FND_MSG_PUB.ADD;
1072: FND_MSG_PUB.count_and_get(p_count=>x_msg_count,