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

Line 57: p_init_msg_list => FND_API.G_FALSE,

53: l_list_rec.user_status_id := P_STATUS ;
54:
55: AMS_LISTHEADER_PVT.Update_ListHeader
56: ( p_api_version => l_api_version,
57: p_init_msg_list => FND_API.G_FALSE,
58: p_commit => FND_API.G_FALSE,
59: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
60: x_return_status => X_RETURN_CODE,
61: x_msg_count => l_msg_count,

Line 58: p_commit => FND_API.G_FALSE,

54:
55: AMS_LISTHEADER_PVT.Update_ListHeader
56: ( p_api_version => l_api_version,
57: p_init_msg_list => FND_API.G_FALSE,
58: p_commit => FND_API.G_FALSE,
59: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
60: x_return_status => X_RETURN_CODE,
61: x_msg_count => l_msg_count,
62: x_msg_data => l_msg_data ,

Line 59: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

55: AMS_LISTHEADER_PVT.Update_ListHeader
56: ( p_api_version => l_api_version,
57: p_init_msg_list => FND_API.G_FALSE,
58: p_commit => FND_API.G_FALSE,
59: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
60: x_return_status => X_RETURN_CODE,
61: x_msg_count => l_msg_count,
62: x_msg_data => l_msg_data ,
63: p_listheader_rec => l_list_rec

Line 67: IF X_RETURN_CODE <> FND_API.G_RET_STS_SUCCESS THEN

63: p_listheader_rec => l_list_rec
64: );
65:
66: -- If any errors happen abort API.
67: IF X_RETURN_CODE <> FND_API.G_RET_STS_SUCCESS THEN
68: l_msg_count := FND_MSG_PUB.count_msg;
69: IEC_SQL_LOGGER_PVT.log( P_SOURCE_ID
70: , IEC_SQL_LOGGER_PVT.G_TL_INFO
71: , SYSDATE

Line 80: l_msg_data := FND_MSG_PUB.GET(i, FND_API.G_FALSE);

76: , 'IEC'
77: , ''
78: , l_record_id);
79: FOR i IN 1..FND_MSG_PUB.count_msg LOOP
80: l_msg_data := FND_MSG_PUB.GET(i, FND_API.G_FALSE);
81: l_desc_arr(1) := 'IEC_COMM_TRACE_DESC';
82: l_desc_app(1) := 'IEC';
83: IEC_SQL_LOGGER_PVT.LOG_DESCRIPTION( l_record_id, l_desc_arr, l_desc_app);
84: l_desc_pos_arr(1) := 1;

Line 98: IF X_RETURN_CODE = FND_API.G_RET_STS_ERROR THEN

94: , l_parm_value_type_arr);
95: END LOOP;
96: END IF;
97:
98: IF X_RETURN_CODE = FND_API.G_RET_STS_ERROR THEN
99: RAISE FND_API.G_EXC_ERROR;
100: ELSIF X_RETURN_CODE = FND_API.G_RET_STS_UNEXP_ERROR THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;

Line 99: RAISE FND_API.G_EXC_ERROR;

95: END LOOP;
96: END IF;
97:
98: IF X_RETURN_CODE = FND_API.G_RET_STS_ERROR THEN
99: RAISE FND_API.G_EXC_ERROR;
100: ELSIF X_RETURN_CODE = FND_API.G_RET_STS_UNEXP_ERROR THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103: COMMIT;

Line 100: ELSIF X_RETURN_CODE = FND_API.G_RET_STS_UNEXP_ERROR THEN

96: END IF;
97:
98: IF X_RETURN_CODE = FND_API.G_RET_STS_ERROR THEN
99: RAISE FND_API.G_EXC_ERROR;
100: ELSIF X_RETURN_CODE = FND_API.G_RET_STS_UNEXP_ERROR THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103: COMMIT;
104:

Line 101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

97:
98: IF X_RETURN_CODE = FND_API.G_RET_STS_ERROR THEN
99: RAISE FND_API.G_EXC_ERROR;
100: ELSIF X_RETURN_CODE = FND_API.G_RET_STS_UNEXP_ERROR THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103: COMMIT;
104:
105: EXCEPTION

Line 106: WHEN FND_API.G_EXC_ERROR THEN

102: END IF;
103: COMMIT;
104:
105: EXCEPTION
106: WHEN FND_API.G_EXC_ERROR THEN
107: ROLLBACK;
108: X_RETURN_CODE := 'E';
109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
110: ROLLBACK;

Line 109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

105: EXCEPTION
106: WHEN FND_API.G_EXC_ERROR THEN
107: ROLLBACK;
108: X_RETURN_CODE := 'E';
109: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
110: ROLLBACK;
111: X_RETURN_CODE := 'E';
112: WHEN OTHERS THEN
113: ROLLBACK;

Line 297: l_init_msg_list VARCHAR2(1) :=FND_API.G_TRUE;

293: )
294: IS
295: PRAGMA AUTONOMOUS_TRANSACTION;
296: l_api_version CONSTANT NUMBER := 1.0;
297: l_init_msg_list VARCHAR2(1) :=FND_API.G_TRUE;
298: l_commit VARCHAR2(1) :=FND_API.G_TRUE;
299: l_user_id NUMBER := 0;
300: l_media_id NUMBER;
301: l_return_status VARCHAR2(1);

Line 298: l_commit VARCHAR2(1) :=FND_API.G_TRUE;

294: IS
295: PRAGMA AUTONOMOUS_TRANSACTION;
296: l_api_version CONSTANT NUMBER := 1.0;
297: l_init_msg_list VARCHAR2(1) :=FND_API.G_TRUE;
298: l_commit VARCHAR2(1) :=FND_API.G_TRUE;
299: l_user_id NUMBER := 0;
300: l_media_id NUMBER;
301: l_return_status VARCHAR2(1);
302: l_msg_count NUMBER;

Line 424: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

420:
421: -- DBMS_OUTPUT.PUT_LINE('----end create interaction----- with x_return_status '||l_return_status);
422: -- DBMS_OUTPUT.PUT_LINE('----end create interaction----- with x_msg_data '||l_msg_data);
423:
424: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
425: RAISE FND_API.G_EXC_ERROR;
426: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: ELSE

Line 425: RAISE FND_API.G_EXC_ERROR;

421: -- DBMS_OUTPUT.PUT_LINE('----end create interaction----- with x_return_status '||l_return_status);
422: -- DBMS_OUTPUT.PUT_LINE('----end create interaction----- with x_msg_data '||l_msg_data);
423:
424: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
425: RAISE FND_API.G_EXC_ERROR;
426: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: ELSE
429: x_return_status := l_return_status;

Line 426: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

422: -- DBMS_OUTPUT.PUT_LINE('----end create interaction----- with x_msg_data '||l_msg_data);
423:
424: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
425: RAISE FND_API.G_EXC_ERROR;
426: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: ELSE
429: x_return_status := l_return_status;
430: END IF;

Line 427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

423:
424: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
425: RAISE FND_API.G_EXC_ERROR;
426: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: ELSE
429: x_return_status := l_return_status;
430: END IF;
431: -- DBMS_OUTPUT.PUT_LINE('----begin create MediaItem-----');

Line 450: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

446: x_media_id=>l_media_id);
447: x_return_status := l_return_status;
448: -- DBMS_OUTPUT.PUT_LINE('----end create MediaItem----- with x_return_status '||l_return_status);
449:
450: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
451: RAISE FND_API.G_EXC_ERROR;
452: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: ELSE

Line 451: RAISE FND_API.G_EXC_ERROR;

447: x_return_status := l_return_status;
448: -- DBMS_OUTPUT.PUT_LINE('----end create MediaItem----- with x_return_status '||l_return_status);
449:
450: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
451: RAISE FND_API.G_EXC_ERROR;
452: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: ELSE
455: x_return_status := l_return_status;

Line 452: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

448: -- DBMS_OUTPUT.PUT_LINE('----end create MediaItem----- with x_return_status '||l_return_status);
449:
450: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
451: RAISE FND_API.G_EXC_ERROR;
452: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: ELSE
455: x_return_status := l_return_status;
456: END IF;

Line 453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

449:
450: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
451: RAISE FND_API.G_EXC_ERROR;
452: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: ELSE
455: x_return_status := l_return_status;
456: END IF;
457: -- DBMS_OUTPUT.PUT_LINE('----begin Create_MediaLifecycle-----');

Line 475: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

471: p_media_lc_rec=>l_media_lc_rec);
472: x_return_status := l_return_status;
473: -- DBMS_OUTPUT.PUT_LINE('----end Create_MediaLifecycle----- with x_return_status '||l_return_status);
474:
475: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
476: RAISE FND_API.G_EXC_ERROR;
477: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
479: ELSE

Line 476: RAISE FND_API.G_EXC_ERROR;

472: x_return_status := l_return_status;
473: -- DBMS_OUTPUT.PUT_LINE('----end Create_MediaLifecycle----- with x_return_status '||l_return_status);
474:
475: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
476: RAISE FND_API.G_EXC_ERROR;
477: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
479: ELSE
480: x_return_status := l_return_status;

Line 477: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

473: -- DBMS_OUTPUT.PUT_LINE('----end Create_MediaLifecycle----- with x_return_status '||l_return_status);
474:
475: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
476: RAISE FND_API.G_EXC_ERROR;
477: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
479: ELSE
480: x_return_status := l_return_status;
481: END IF;

Line 478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

474:
475: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
476: RAISE FND_API.G_EXC_ERROR;
477: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
479: ELSE
480: x_return_status := l_return_status;
481: END IF;
482: EXCEPTION

Line 483: WHEN FND_API.G_EXC_ERROR THEN

479: ELSE
480: x_return_status := l_return_status;
481: END IF;
482: EXCEPTION
483: WHEN FND_API.G_EXC_ERROR THEN
484: ROLLBACK;
485: X_RETURN_STATUS := 'E';
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487: ROLLBACK;

Line 486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

482: EXCEPTION
483: WHEN FND_API.G_EXC_ERROR THEN
484: ROLLBACK;
485: X_RETURN_STATUS := 'E';
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487: ROLLBACK;
488: X_RETURN_STATUS := 'U';
489: WHEN OTHERS THEN
490: ROLLBACK;

Line 738: , FND_API.G_MISS_CHAR

734: , -1
735: , -1
736: , -1
737: , -1
738: , FND_API.G_MISS_CHAR
739: , 0
740: , 'N'
741: , P_DIALING_METHOD
742: , P_SCHED_ID