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

Line 33: x_return_status := FND_API.G_RET_STS_SUCCESS;

29: x_project_start_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
30: x_project_end_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
31: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
32: BEGIN
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34:
35: /* Bug 2636791 - changes begin */
36: /* Commenting this query and selecting start date from PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE */
37: /* select start_date, completion_date

Line 54: x_return_status := FND_API.G_RET_STS_ERROR;

50: fnd_message.set_name('PA','PA_NO_PROJECT_ID');
51: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
52: fnd_message.set_token('PROCEDURE_NAME','GET_PROJECT_DATES');
53: fnd_msg_pub.ADD;
54: x_return_status := FND_API.G_RET_STS_ERROR;
55: END;
56:
57:
58: PROCEDURE VALIDATE_PROJECT_PARTY( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

Line 58: PROCEDURE VALIDATE_PROJECT_PARTY( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

54: x_return_status := FND_API.G_RET_STS_ERROR;
55: END;
56:
57:
58: PROCEDURE VALIDATE_PROJECT_PARTY( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: p_debug_mode IN VARCHAR2 DEFAULT 'N',
60: p_object_id IN NUMBER,
61: p_OBJECT_TYPE IN VARCHAR2,
62: p_project_role_id IN NUMBER,

Line 101: x_return_status := FND_API.G_RET_STS_SUCCESS;

97:
98: l_dummy VARCHAR2(1);
99:
100: BEGIN
101: x_return_status := FND_API.G_RET_STS_SUCCESS;
102: pa_debug.set_err_stack('Validate_project_party');
103:
104: l_end_date_active := p_end_date_active; --Bug 4565156 NOCOPY changes
105:

Line 108: x_return_status := FND_API.G_RET_STS_ERROR;

104: l_end_date_active := p_end_date_active; --Bug 4565156 NOCOPY changes
105:
106: --MT OrgRole changes: ext people are not schedulable
107: IF p_resource_type_id = 112 AND p_scheduled_flag = 'Y' THEN
108: x_return_status := FND_API.G_RET_STS_ERROR;
109: fnd_message.set_name('PA','PA_NO_SCHEDULE_HZ_PARTY');
110: fnd_msg_pub.ADD;
111: RETURN;
112: END IF;

Line 118: x_return_status := FND_API.G_RET_STS_ERROR;

114:
115: /*Code Addition for bug 2983546 -- Ext people are not allowed as project Managers */
116:
117: IF p_resource_type_id = 112 AND p_project_role_id=1 THEN
118: x_return_status := FND_API.G_RET_STS_ERROR;
119: fnd_message.set_name('PA','PA_NO_EXT_MANAGER');
120: fnd_msg_pub.ADD;
121: RETURN;
122: END IF;

Line 140: x_return_status := FND_API.G_RET_STS_ERROR;

136: p_project_end_date => p_project_end_date,
137: p_scheduled_flag => p_scheduled_flag,
138: x_error_occured => l_error_occured);
139: IF (l_error_occured = 'Y') THEN
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: END IF;
142:
143: --dbms_output.put_line('After checking the mandatory errors'||x_return_status);
144:

Line 157: x_return_status := FND_API.G_RET_STS_ERROR;

153: p_resource_source_id => p_resource_source_id,
154: x_error_occured => l_error_occured);
155:
156: IF (l_error_occured = 'Y') THEN
157: x_return_status := FND_API.G_RET_STS_ERROR;
158: END IF;
159: -- bug2671210 ended.
160:
161: --- call to validate the start and end dates for the person

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

166: p_end_date_active => p_end_date_active,
167: x_error_occured => l_error_occured);
168:
169: IF (l_error_occured = 'Y') THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: END IF;
172:
173: /* Start of Bug 3096700 */
174: /* Adding a validation for checking if the project role start date lies between specified start active and end active date */

Line 186: x_return_status := FND_API.G_RET_STS_ERROR;

182: AND (p_end_date_active IS NULL
183: OR p_end_date_active BETWEEN start_date_active AND NVL(end_date_active,p_end_date_active));
184: EXCEPTION
185: WHEN NO_DATA_FOUND THEN
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: fnd_message.set_name('PA','PA_ROLE_INACTIVE');
188: fnd_msg_pub.ADD;
189: END;
190: /* End of 3096700 */

Line 206: x_return_status := FND_API.G_RET_STS_ERROR;

202:
203: OPEN c_duplicate_customer_org;
204: FETCH c_duplicate_customer_org INTO l_dummy;
205: IF c_duplicate_customer_org%FOUND THEN
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: fnd_message.set_name('PA','PA_DUPLICATE_CUSTOMER_ORG');
208: fnd_msg_pub.ADD;
209: CLOSE c_duplicate_customer_org;
210: RETURN;

Line 226: x_return_status := FND_API.G_RET_STS_ERROR;

222: --dbms_output.put_line('schedule is allowed for this role');
223: x_assignment_action := 'CREATE';
224: ELSE
225: --dbms_output.put_line('schedule is not allowed for this role');
226: x_return_status := FND_API.G_RET_STS_ERROR;
227: fnd_message.set_name('PA','PA_NO_SCHEDULE_ALLOWED');
228: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
229: --fnd_message.set_token('PROCEDURE_NAME','VALIDATE_PROJECT_PARTY');
230: fnd_msg_pub.ADD;

Line 274: x_return_status := FND_API.G_RET_STS_ERROR;

270: p_project_party_id := l_project_party_id;
271: p_record_version_number := l_record_version_number;
272: ELSE
273: --dbms_output.put_line('cannot create duplicate record');
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: fnd_message.set_name('PA','PA_XC_TOO_MANY_OMGRS');
276: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
277: --fnd_message.set_token('PROCEDURE_NAME','VALIDATE_PROJECT_PARTY');
278: fnd_msg_pub.ADD;

Line 299: x_return_status := FND_API.G_RET_STS_ERROR;

295: p_start_date_active => p_start_date_active,
296: p_end_date_active => p_end_date_active,
297: x_error_occured => l_error_occured);
298: IF (l_error_occured = 'Y') THEN
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: END IF;
301: --dbms_output.put_line('validating manager');
302: ELSE
303: IF (p_debug_mode = 'Y') THEN

Line 316: x_return_status := FND_API.G_RET_STS_ERROR;

312: p_start_date_active => p_start_date_active,
313: p_end_date_active => p_end_date_active,
314: x_error_occured => l_error_occured);
315: IF (l_error_occured = 'Y') THEN
316: x_return_status := FND_API.G_RET_STS_ERROR;
317: END IF;
318: --dbms_output.put_line('validating overlap');
319: END IF;
320: END IF;

Line 324: x_return_status := fnd_api.g_ret_sts_unexp_error;

320: END IF;
321:
322: EXCEPTION WHEN OTHERS THEN
323: p_end_date_active := l_end_date_active; --Bug 4565156 NOCOPY changes
324: x_return_status := fnd_api.g_ret_sts_unexp_error;
325: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',
326: p_procedure_name => 'VALIDATE_PROJECT_PARTY',
327: p_error_text => SUBSTRB(SQLERRM,1,240));
328: RAISE;

Line 690: x_return_status := FND_API.G_RET_STS_SUCCESS;

686: x_project_role_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
687: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
688: x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
689: BEGIN
690: x_return_status := FND_API.G_RET_STS_SUCCESS;
691:
692: pa_debug.set_err_stack('get_current_project_manager_details');
693:
694: BEGIN

Line 751: x_return_status := FND_API.G_RET_STS_ERROR;

747:
748: pa_debug.reset_err_stack;
749: EXCEPTION
750: WHEN NO_DATA_FOUND THEN
751: x_return_status := FND_API.G_RET_STS_ERROR;
752: x_error_message_code := 'PA_NO_PROJ_MGR_EXISTS';
753: WHEN OTHERS THEN
754: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',
755: p_procedure_name => pa_debug.g_err_stack,

Line 1214: x_return_status := FND_API.G_RET_STS_SUCCESS;

1210: BEGIN
1211:
1212: pa_debug.set_err_stack('VALIDATE_ONE_MANAGER_EXISTS');
1213: x_msg_count := 0;
1214: x_return_status := FND_API.G_RET_STS_SUCCESS;
1215:
1216: /* Do the checking for the Manager date only for an Approved Contract Type project. */
1217: IF p_project_id IS NOT NULL THEN
1218: OPEN c_prj;

Line 1238: x_return_status := FND_API.G_RET_STS_ERROR;

1234: pa_utils.add_message
1235: ( p_app_short_name => 'PA'
1236: ,p_msg_name => 'PA_PR_INSUF_PROJ_MGR'
1237: );
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239: x_msg_count := 1;
1240: x_msg_data := 'PA_PR_INSUF_PROJ_MGR';
1241: END IF;
1242: END IF;

Line 1249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1245:
1246: EXCEPTION
1247:
1248: WHEN OTHERS THEN
1249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1250: x_msg_count := 1;
1251: x_msg_data := SQLERRM;
1252: FND_MSG_PUB.add_exc_msg
1253: ( p_pkg_name => 'PA_PROJECT_PARTIES_UTILS.VALIDATE_ONE_MANAGER_EXISTS'

Line 1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1256: pa_debug.write('VALIDATE_ONE_MANAGER_EXISTS: ', SQLERRM, 3);
1257: pa_debug.write('VALIDATE_ONE_MANAGER_EXISTS: ', pa_debug.G_Err_Stack, 3);
1258: END IF;
1259: pa_debug.reset_err_stack;
1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1261:
1262: END VALIDATE_ONE_MANAGER_EXISTS;
1263:
1264: -- API name : get_current_project_manager