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

Line 888: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

884: ,p_msg_data => p_msg_data
885: ,p_return_status => l_return_status);
886: --dbms_output.put_line('set global info: '||l_return_status);
887:
888: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
891: RAISE FND_API.G_EXC_ERROR;
892: END IF;

Line 889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

885: ,p_return_status => l_return_status);
886: --dbms_output.put_line('set global info: '||l_return_status);
887:
888: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
891: RAISE FND_API.G_EXC_ERROR;
892: END IF;
893:

Line 890: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

886: --dbms_output.put_line('set global info: '||l_return_status);
887:
888: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
891: RAISE FND_API.G_EXC_ERROR;
892: END IF;
893:
894: -- 4363092 MOAC Changes, commented below code to call set_client_info procedure

Line 891: RAISE FND_API.G_EXC_ERROR;

887:
888: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
891: RAISE FND_API.G_EXC_ERROR;
892: END IF;
893:
894: -- 4363092 MOAC Changes, commented below code to call set_client_info procedure
895: /*

Line 999: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

995: ,p_pa_project_id => p_project_id
996: ,p_start_date => l_project_mpx_start_date
997: ,p_completion_date => l_project_mpx_end_date);
998:
999: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1002: RAISE FND_API.G_EXC_ERROR;
1003: END IF; -- IF l_return_status

Line 1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

996: ,p_start_date => l_project_mpx_start_date
997: ,p_completion_date => l_project_mpx_end_date);
998:
999: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1002: RAISE FND_API.G_EXC_ERROR;
1003: END IF; -- IF l_return_status
1004:

Line 1001: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

997: ,p_completion_date => l_project_mpx_end_date);
998:
999: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1002: RAISE FND_API.G_EXC_ERROR;
1003: END IF; -- IF l_return_status
1004:
1005: ------------------------

Line 1002: RAISE FND_API.G_EXC_ERROR;

998:
999: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1002: RAISE FND_API.G_EXC_ERROR;
1003: END IF; -- IF l_return_status
1004:
1005: ------------------------
1006: --DELETE_TASK (loop for multiple tasks)

Line 1086: ,p_commit => FND_API.G_FALSE

1082: END IF;
1083:
1084: pa_project_pub.execute_update_project
1085: ( P_API_VERSION_NUMBER => G_API_VERSION_NUMBER
1086: ,p_commit => FND_API.G_FALSE
1087: ,p_init_msg_list => FND_API.G_FALSE
1088: ,p_msg_count => p_msg_count
1089: ,p_msg_data => p_msg_data
1090: ,p_return_status => l_return_status

Line 1087: ,p_init_msg_list => FND_API.G_FALSE

1083:
1084: pa_project_pub.execute_update_project
1085: ( P_API_VERSION_NUMBER => G_API_VERSION_NUMBER
1086: ,p_commit => FND_API.G_FALSE
1087: ,p_init_msg_list => FND_API.G_FALSE
1088: ,p_msg_count => p_msg_count
1089: ,p_msg_data => p_msg_data
1090: ,p_return_status => l_return_status
1091: ,p_workflow_started => l_workflow_started

Line 1099: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1095: --dbms_output.put_line('AFTER Calling Execute Update Project here ');
1096: --dbms_output.put_line(l_return_status);
1097: --dbms_output.put_line(p_msg_data);
1098:
1099: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF; -- IF l_return_status

Line 1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1096: --dbms_output.put_line(l_return_status);
1097: --dbms_output.put_line(p_msg_data);
1098:
1099: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF; -- IF l_return_status
1104:

Line 1101: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1097: --dbms_output.put_line(p_msg_data);
1098:
1099: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF; -- IF l_return_status
1104:
1105: --hsiu added for publishing bug

Line 1102: RAISE FND_API.G_EXC_ERROR;

1098:
1099: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF; -- IF l_return_status
1104:
1105: --hsiu added for publishing bug
1106: update PA_TASKS pt

Line 1168: WHEN FND_API.G_EXC_ERROR THEN

1164: end if;
1165:
1166:
1167: EXCEPTION
1168: WHEN FND_API.G_EXC_ERROR THEN
1169: p_msg_count := fnd_msg_pub.count_msg;
1170: for i in 1..p_msg_count loop
1171: --dbms_output.put_line('INSIDE THE ERROR HANDLING PORTION ');
1172:

Line 1192: x_return_status := FND_API.G_RET_STS_ERROR ;

1188: x_msg_data(x_msg_count) := l_data;
1189:
1190: end loop;
1191:
1192: x_return_status := FND_API.G_RET_STS_ERROR ;
1193:
1194: --hsiu added
1195: IF (p_calling_mode <> 'PUBLISH') THEN
1196: pa_project_pub.clear_project;

Line 1200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1196: pa_project_pub.clear_project;
1197: --hsiu added
1198: END IF;
1199:
1200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1201: --dbms_output.put_line('UNHANDLED Exception Error Handling ');
1202:
1203: if (p_debug_mode = 'Y') then
1204: pa_debug.debug('Import-Project : Unhandled Expection ...');

Line 1227: x_return_status := FND_API.G_RET_STS_ERROR;

1223: x_msg_data(x_msg_count) := l_data;
1224:
1225: end loop;
1226:
1227: x_return_status := FND_API.G_RET_STS_ERROR;
1228: --hsiu added
1229: IF (p_calling_mode <> 'PUBLISH') THEN
1230: pa_project_pub.clear_project;
1231: --hsiu added

Line 1255: x_return_status := FND_API.G_RET_STS_ERROR;

1251: x_msg_data(x_msg_count) := fnd_message.get;
1252: x_return_status := 'E';
1253:
1254: WHEN ROW_ALREADY_LOCKED THEN
1255: x_return_status := FND_API.G_RET_STS_ERROR;
1256:
1257: if (p_debug_mode = 'Y') then
1258: pa_debug.debug('Import-Project : Inside Row Already Locked Exception ...');
1259: end if;