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

Line 153: p_init_msg_list => FND_API.G_TRUE,

149: -- us.
150: ----------------------------------------------------------------
151: AMS_CAMP_SCHEDULE_PUB.Update_Camp_Schedule
152: ( p_api_version_number => l_api_version,
153: p_init_msg_list => FND_API.G_TRUE,
154: p_commit => FND_API.G_FALSE,
155: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
156: x_return_status => l_return_code,
157: x_msg_count => l_msg_count,

Line 154: p_commit => FND_API.G_FALSE,

150: ----------------------------------------------------------------
151: AMS_CAMP_SCHEDULE_PUB.Update_Camp_Schedule
152: ( p_api_version_number => l_api_version,
153: p_init_msg_list => FND_API.G_TRUE,
154: p_commit => FND_API.G_FALSE,
155: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
156: x_return_status => l_return_code,
157: x_msg_count => l_msg_count,
158: x_msg_data => l_msg_data ,

Line 155: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

151: AMS_CAMP_SCHEDULE_PUB.Update_Camp_Schedule
152: ( p_api_version_number => l_api_version,
153: p_init_msg_list => FND_API.G_TRUE,
154: p_commit => FND_API.G_FALSE,
155: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
156: x_return_status => l_return_code,
157: x_msg_count => l_msg_count,
158: x_msg_data => l_msg_data ,
159: p_schedule_rec => l_schedule_rec,

Line 166: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN

162: ----------------------------------------------------------------
163: -- If the call to the ams api did not complete successfully then write
164: -- a log and stop the update list procedure.
165: ----------------------------------------------------------------
166: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
167:
168: Log_AmsStatusError('UPDATE_SCHEDULE_STATUS', 'UPDATE_SCHEDULE', p_schedule_id, p_status);
169:
170: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

Line 170: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

166: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
167:
168: Log_AmsStatusError('UPDATE_SCHEDULE_STATUS', 'UPDATE_SCHEDULE', p_schedule_id, p_status);
169:
170: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
171: RAISE FND_API.G_EXC_ERROR;
172: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: END IF;

Line 171: RAISE FND_API.G_EXC_ERROR;

167:
168: Log_AmsStatusError('UPDATE_SCHEDULE_STATUS', 'UPDATE_SCHEDULE', p_schedule_id, p_status);
169:
170: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
171: RAISE FND_API.G_EXC_ERROR;
172: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: END IF;
175:

Line 172: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

168: Log_AmsStatusError('UPDATE_SCHEDULE_STATUS', 'UPDATE_SCHEDULE', p_schedule_id, p_status);
169:
170: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
171: RAISE FND_API.G_EXC_ERROR;
172: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: END IF;
175:
176: END IF;

Line 173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

169:
170: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
171: RAISE FND_API.G_EXC_ERROR;
172: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: END IF;
175:
176: END IF;
177:

Line 182: -- If either of the two FND_API exceptions have been thrown then

178: COMMIT;
179:
180: EXCEPTION
181: ----------------------------------------------------------------
182: -- If either of the two FND_API exceptions have been thrown then
183: -- the procedure has already logged the error and we now just
184: -- set the return status flag and return to the calling
185: -- procedure.
186: ----------------------------------------------------------------

Line 187: WHEN FND_API.G_EXC_ERROR THEN

183: -- the procedure has already logged the error and we now just
184: -- set the return status flag and return to the calling
185: -- procedure.
186: ----------------------------------------------------------------
187: WHEN FND_API.G_EXC_ERROR THEN
188: ROLLBACK;
189: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: ROLLBACK;

Line 190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

186: ----------------------------------------------------------------
187: WHEN FND_API.G_EXC_ERROR THEN
188: ROLLBACK;
189: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: ROLLBACK;
192: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
193: ----------------------------------------------------------------
194: -- If an anonymous exception has been thrown then

Line 277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

273: WHEN OTHERS THEN
274: Log ( l_api_name
275: , 'PRE_PROCESSING.UPDATE_EXECUTION_START_TIME'
276: , SQLERRM );
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: END;
279:
280: ELSIF (p_status = 'PENDING_VALIDATION') THEN
281:

Line 326: WHEN FND_API.G_EXC_ERROR THEN

322: EXCEPTION
323: ----------------------------------------------------------------
324: -- This has already been logged so just re-raise the exception.
325: ----------------------------------------------------------------
326: WHEN FND_API.G_EXC_ERROR THEN
327: RAISE;
328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
329: RAISE;
330: ----------------------------------------------------------------

Line 328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

324: -- This has already been logged so just re-raise the exception.
325: ----------------------------------------------------------------
326: WHEN FND_API.G_EXC_ERROR THEN
327: RAISE;
328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
329: RAISE;
330: ----------------------------------------------------------------
331: -- If the preprocessing throws an unexpected exception then write
332: -- a log and stop the update list procedure.

Line 336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

332: -- a log and stop the update list procedure.
333: ----------------------------------------------------------------
334: WHEN OTHERS THEN
335: Log_IecStatusError(l_api_name, 'PRE_PROCESSING', p_list_id, p_status);
336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: END;
338:
339: -- We only want to use the flag to indicate when an api
340: -- initiated the call to change the status (or perform an

Line 362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

358: WHEN OTHERS THEN
359: Log ( l_api_name
360: , 'UPDATE_AO_STATUS'
361: , SQLERRM );
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
363: END;
364:
365: -- Get current Marketing list status
366: BEGIN

Line 376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

372: WHEN OTHERS THEN
373: Log ( l_api_name
374: , 'GET_AMS_STATUS'
375: , SQLERRM );
376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
377: END;
378:
379: -- Update Marketing list status has changed
380: IF l_curr_mkt_status <> l_mkt_status THEN

Line 401: p_init_msg_list => FND_API.G_TRUE,

397: -- future.
398: ----------------------------------------------------------------
399: AMS_LISTHEADER_PVT.Update_ListHeader
400: ( p_api_version => l_api_version,
401: p_init_msg_list => FND_API.G_TRUE,
402: p_commit => FND_API.G_FALSE,
403: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
404: x_return_status => l_return_code,
405: x_msg_count => l_msg_count,

Line 402: p_commit => FND_API.G_FALSE,

398: ----------------------------------------------------------------
399: AMS_LISTHEADER_PVT.Update_ListHeader
400: ( p_api_version => l_api_version,
401: p_init_msg_list => FND_API.G_TRUE,
402: p_commit => FND_API.G_FALSE,
403: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
404: x_return_status => l_return_code,
405: x_msg_count => l_msg_count,
406: x_msg_data => l_msg_data ,

Line 403: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

399: AMS_LISTHEADER_PVT.Update_ListHeader
400: ( p_api_version => l_api_version,
401: p_init_msg_list => FND_API.G_TRUE,
402: p_commit => FND_API.G_FALSE,
403: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
404: x_return_status => l_return_code,
405: x_msg_count => l_msg_count,
406: x_msg_data => l_msg_data ,
407: p_listheader_rec => l_list_rec

Line 414: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN

410: ----------------------------------------------------------------
411: -- If the call to the ams api did not complete successfully then write
412: -- a log and stop the update list procedure.
413: ----------------------------------------------------------------
414: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
415:
416: Log ( l_api_name
417: , 'UPDATE_AMS_LIST_STATUS'
418: , l_msg_data );

Line 420: IF l_return_code = FND_API.G_RET_STS_ERROR THEN

416: Log ( l_api_name
417: , 'UPDATE_AMS_LIST_STATUS'
418: , l_msg_data );
419:
420: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
421: RAISE FND_API.G_EXC_ERROR;
422: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: END IF;

Line 421: RAISE FND_API.G_EXC_ERROR;

417: , 'UPDATE_AMS_LIST_STATUS'
418: , l_msg_data );
419:
420: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
421: RAISE FND_API.G_EXC_ERROR;
422: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: END IF;
425:

Line 422: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN

418: , l_msg_data );
419:
420: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
421: RAISE FND_API.G_EXC_ERROR;
422: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: END IF;
425:
426: END IF;

Line 423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

419:
420: IF l_return_code = FND_API.G_RET_STS_ERROR THEN
421: RAISE FND_API.G_EXC_ERROR;
422: ELSIF l_return_code = FND_API.G_RET_STS_UNEXP_ERROR THEN
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: END IF;
425:
426: END IF;
427: END IF;

Line 434: -- If either of the two FND_API exceptions have been thrown then

430:
431: EXCEPTION
432:
433: ----------------------------------------------------------------
434: -- If either of the two FND_API exceptions have been thrown then
435: -- the procedure has already logged the error and we now just
436: -- set the return status flag and return to the calling
437: -- procedure.
438: ----------------------------------------------------------------

Line 439: WHEN FND_API.G_EXC_ERROR THEN

435: -- the procedure has already logged the error and we now just
436: -- set the return status flag and return to the calling
437: -- procedure.
438: ----------------------------------------------------------------
439: WHEN FND_API.G_EXC_ERROR THEN
440: ROLLBACK;
441: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443: ROLLBACK;

Line 442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

438: ----------------------------------------------------------------
439: WHEN FND_API.G_EXC_ERROR THEN
440: ROLLBACK;
441: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443: ROLLBACK;
444: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
445:
446: ----------------------------------------------------------------

Line 533: RAISE FND_API.G_EXC_ERROR;

529: END LOOP;
530:
531: IF l_error_stack IS NOT NULL THEN
532: g_error_msg := l_error_stack;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535:
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN

Line 537: WHEN FND_API.G_EXC_ERROR THEN

533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535:
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN
538: RAISE;
539: WHEN OTHERS THEN
540: LOG ( l_method_name
541: , 'MAIN'

Line 544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

540: LOG ( l_method_name
541: , 'MAIN'
542: , SQLERRM );
543: ROLLBACK TO STOP_LISTS_START;
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: END Stop_Lists;
546:
547: -----------------------------++++++-------------------------------
548: --

Line 850: x_return_status := FND_API.G_RET_STS_SUCCESS;

846: BEGIN
847:
848: SAVEPOINT stop_list;
849:
850: x_return_status := FND_API.G_RET_STS_SUCCESS;
851:
852: IEC_COMMON_UTIL_PVT.Get_ListId(p_schedule_id, l_list_id);
853:
854: -- Check ao status to make sure that list is Active

Line 920: RAISE fnd_api.g_exc_error;

916: , NULL);
917:
918: IEC_COMMON_UTIL_PVT.Get_ScheduleName(p_schedule_id, l_schedule_name);
919: Log_CannotStopSchedule(l_method_name, 'CANNOT_STOP_LIST', l_schedule_name);
920: RAISE fnd_api.g_exc_error;
921: END IF;
922:
923: IF p_commit THEN
924: COMMIT;

Line 928: WHEN fnd_api.g_exc_error THEN

924: COMMIT;
925: END IF;
926:
927: EXCEPTION
928: WHEN fnd_api.g_exc_error THEN
929: ROLLBACK TO stop_list;
930: FND_MSG_PUB.ADD;
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: WHEN OTHERS THEN

Line 931: x_return_status := FND_API.G_RET_STS_ERROR;

927: EXCEPTION
928: WHEN fnd_api.g_exc_error THEN
929: ROLLBACK TO stop_list;
930: FND_MSG_PUB.ADD;
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: WHEN OTHERS THEN
933: ROLLBACK TO stop_list;
934: LOG ( l_method_name
935: , 'MAIN.SCHEDULE_' || p_schedule_id

Line 938: x_return_status := FND_API.G_RET_STS_ERROR;

934: LOG ( l_method_name
935: , 'MAIN.SCHEDULE_' || p_schedule_id
936: , SQLERRM );
937: FND_MSG_PUB.ADD;
938: x_return_status := FND_API.G_RET_STS_ERROR;
939: END Stop_ScheduleExecution_Pub;
940:
941: -----------------------------++++++-------------------------------
942: --

Line 1034: -- If either of the two FND_API exceptions have been thrown then

1030: COMMIT;
1031:
1032: EXCEPTION
1033: ----------------------------------------------------------------
1034: -- If either of the two FND_API exceptions have been thrown then
1035: -- the procedure has already logged the error and we now just
1036: -- set the return status flag and return to the calling
1037: -- procedure.
1038: ----------------------------------------------------------------

Line 1039: WHEN FND_API.G_EXC_ERROR THEN

1035: -- the procedure has already logged the error and we now just
1036: -- set the return status flag and return to the calling
1037: -- procedure.
1038: ----------------------------------------------------------------
1039: WHEN FND_API.G_EXC_ERROR THEN
1040: ROLLBACK TO STATUS_START;
1041: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
1042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1043: ROLLBACK TO STATUS_START;

Line 1042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1038: ----------------------------------------------------------------
1039: WHEN FND_API.G_EXC_ERROR THEN
1040: ROLLBACK TO STATUS_START;
1041: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
1042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1043: ROLLBACK TO STATUS_START;
1044: RAISE_APPLICATION_ERROR(-20999, g_error_msg);
1045: ----------------------------------------------------------------
1046: -- If an anonymous exception has been thrown then