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 899: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

895: ,p_msg_data => p_msg_data
896: ,p_return_status => l_return_status);
897: --dbms_output.put_line('set global info: '||l_return_status);
898:
899: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
902: RAISE FND_API.G_EXC_ERROR;
903: END IF;

Line 900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

896: ,p_return_status => l_return_status);
897: --dbms_output.put_line('set global info: '||l_return_status);
898:
899: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
902: RAISE FND_API.G_EXC_ERROR;
903: END IF;
904:

Line 901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

897: --dbms_output.put_line('set global info: '||l_return_status);
898:
899: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
902: RAISE FND_API.G_EXC_ERROR;
903: END IF;
904:
905: -- 4363092 MOAC Changes, commented below code to call set_client_info procedure

Line 902: RAISE FND_API.G_EXC_ERROR;

898:
899: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
901: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
902: RAISE FND_API.G_EXC_ERROR;
903: END IF;
904:
905: -- 4363092 MOAC Changes, commented below code to call set_client_info procedure
906: /*

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

1006: ,p_pa_project_id => p_project_id
1007: ,p_start_date => l_project_mpx_start_date
1008: ,p_completion_date => l_project_mpx_end_date);
1009:
1010: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1012: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1013: RAISE FND_API.G_EXC_ERROR;
1014: END IF; -- IF l_return_status

Line 1011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1007: ,p_start_date => l_project_mpx_start_date
1008: ,p_completion_date => l_project_mpx_end_date);
1009:
1010: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1012: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1013: RAISE FND_API.G_EXC_ERROR;
1014: END IF; -- IF l_return_status
1015:

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

1008: ,p_completion_date => l_project_mpx_end_date);
1009:
1010: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1012: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1013: RAISE FND_API.G_EXC_ERROR;
1014: END IF; -- IF l_return_status
1015:
1016: ------------------------

Line 1013: RAISE FND_API.G_EXC_ERROR;

1009:
1010: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1012: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1013: RAISE FND_API.G_EXC_ERROR;
1014: END IF; -- IF l_return_status
1015:
1016: ------------------------
1017: --DELETE_TASK (loop for multiple tasks)

Line 1097: ,p_commit => FND_API.G_FALSE

1093: END IF;
1094:
1095: pa_project_pub.execute_update_project
1096: ( P_API_VERSION_NUMBER => G_API_VERSION_NUMBER
1097: ,p_commit => FND_API.G_FALSE
1098: ,p_init_msg_list => FND_API.G_FALSE
1099: ,p_msg_count => p_msg_count
1100: ,p_msg_data => p_msg_data
1101: ,p_return_status => l_return_status

Line 1098: ,p_init_msg_list => FND_API.G_FALSE

1094:
1095: pa_project_pub.execute_update_project
1096: ( P_API_VERSION_NUMBER => G_API_VERSION_NUMBER
1097: ,p_commit => FND_API.G_FALSE
1098: ,p_init_msg_list => FND_API.G_FALSE
1099: ,p_msg_count => p_msg_count
1100: ,p_msg_data => p_msg_data
1101: ,p_return_status => l_return_status
1102: ,p_workflow_started => l_workflow_started

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

1106: --dbms_output.put_line('AFTER Calling Execute Update Project here ');
1107: --dbms_output.put_line(l_return_status);
1108: --dbms_output.put_line(p_msg_data);
1109:
1110: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1112: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF; -- IF l_return_status

Line 1111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1107: --dbms_output.put_line(l_return_status);
1108: --dbms_output.put_line(p_msg_data);
1109:
1110: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1112: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF; -- IF l_return_status
1115:

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

1108: --dbms_output.put_line(p_msg_data);
1109:
1110: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1112: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF; -- IF l_return_status
1115:
1116: --hsiu added for publishing bug

Line 1113: RAISE FND_API.G_EXC_ERROR;

1109:
1110: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1112: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF; -- IF l_return_status
1115:
1116: --hsiu added for publishing bug
1117: update PA_TASKS pt

Line 1179: WHEN FND_API.G_EXC_ERROR THEN

1175: end if;
1176:
1177:
1178: EXCEPTION
1179: WHEN FND_API.G_EXC_ERROR THEN
1180: p_msg_count := fnd_msg_pub.count_msg;
1181: for i in 1..p_msg_count loop
1182: --dbms_output.put_line('INSIDE THE ERROR HANDLING PORTION ');
1183:

Line 1203: x_return_status := FND_API.G_RET_STS_ERROR ;

1199: x_msg_data(x_msg_count) := l_data;
1200:
1201: end loop;
1202:
1203: x_return_status := FND_API.G_RET_STS_ERROR ;
1204:
1205: --hsiu added
1206: IF (p_calling_mode <> 'PUBLISH') THEN
1207: pa_project_pub.clear_project;

Line 1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1207: pa_project_pub.clear_project;
1208: --hsiu added
1209: END IF;
1210:
1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1212: --dbms_output.put_line('UNHANDLED Exception Error Handling ');
1213:
1214: if (p_debug_mode = 'Y') then
1215: pa_debug.debug('Import-Project : Unhandled Expection ...');

Line 1238: x_return_status := FND_API.G_RET_STS_ERROR;

1234: x_msg_data(x_msg_count) := l_data;
1235:
1236: end loop;
1237:
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239: --hsiu added
1240: IF (p_calling_mode <> 'PUBLISH') THEN
1241: pa_project_pub.clear_project;
1242: --hsiu added

Line 1266: x_return_status := FND_API.G_RET_STS_ERROR;

1262: x_msg_data(x_msg_count) := fnd_message.get;
1263: x_return_status := 'E';
1264:
1265: WHEN ROW_ALREADY_LOCKED THEN
1266: x_return_status := FND_API.G_RET_STS_ERROR;
1267:
1268: if (p_debug_mode = 'Y') then
1269: pa_debug.debug('Import-Project : Inside Row Already Locked Exception ...');
1270: end if;