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

Line 10: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

6: -- Type : Public
7: -- Pre-reqs : None.
8:
9: PROCEDURE DELETE_USER_ATTRS_DATA
10: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
12: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
13: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
14: ,p_debug_mode IN VARCHAR2 := 'N'

Line 11: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

7: -- Pre-reqs : None.
8:
9: PROCEDURE DELETE_USER_ATTRS_DATA
10: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
12: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
13: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
14: ,p_debug_mode IN VARCHAR2 := 'N'
15: ,p_project_id IN NUMBER

Line 12: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

8:
9: PROCEDURE DELETE_USER_ATTRS_DATA
10: ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
11: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
12: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
13: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
14: ,p_debug_mode IN VARCHAR2 := 'N'
15: ,p_project_id IN NUMBER
16: ,p_proj_element_id IN NUMBER DEFAULT NULL

Line 168: if p_commit = FND_API.G_TRUE then

164: if (p_debug_mode = 'Y') then
165: pa_debug.debug('PA_USER_ATTR_PVT.Delete_User_Attrs_Data BEGIN');
166: end if;
167:
168: if p_commit = FND_API.G_TRUE then
169: savepoint delete_user_attrs_data_pvt;
170: end if;
171:
172: if p_classification_type IN ('PROJECT_TYPE', 'CLASS_CATEGORY', 'CLASS_CODE') then

Line 186: if p_validate_only <> FND_API.G_TRUE then

182: FETCH exists_in_other_drivers INTO l_dummy;
183:
184: if exists_in_other_drivers%NOTFOUND then
185: l_dummy := 'N';
186: if p_validate_only <> FND_API.G_TRUE then
187: DELETE FROM PA_PROJECTS_ERP_EXT_B
188: WHERE PROJECT_ID = p_project_id
189: AND PROJ_ELEMENT_ID is NULL
190: AND ATTR_GROUP_ID = l_attr_group_id;

Line 212: if p_validate_only <> FND_API.G_TRUE then

208: OPEN exists_in_other_task_drivers(l_attr_group_id, l_proj_element_id);
209: FETCH exists_in_other_task_drivers INTO l_dummy2;
210:
211: if exists_in_other_task_drivers%NOTFOUND then
212: if p_validate_only <> FND_API.G_TRUE then
213: DELETE FROM PA_PROJECTS_ERP_EXT_B
214: WHERE PROJECT_ID = p_project_id
215: AND PROJ_ELEMENT_ID = l_proj_element_id
216: AND ATTR_GROUP_ID = l_attr_group_id;

Line 244: if p_validate_only <> FND_API.G_TRUE then

240: FETCH exists_in_other_drivers INTO l_dummy;
241:
242: if exists_in_other_drivers%NOTFOUND then
243: l_dummy := 'N';
244: if p_validate_only <> FND_API.G_TRUE then
245: DELETE FROM PA_PROJECTS_ERP_EXT_B
246: WHERE PROJECT_ID = p_project_id
247: AND PROJ_ELEMENT_ID is NULL
248: AND ATTR_GROUP_ID = l_attr_group_id;

Line 270: if p_validate_only <> FND_API.G_TRUE then

266: OPEN exists_in_other_task_drivers(l_attr_group_id, l_proj_element_id);
267: FETCH exists_in_other_task_drivers INTO l_dummy2;
268:
269: if exists_in_other_task_drivers%NOTFOUND then
270: if p_validate_only <> FND_API.G_TRUE then
271: DELETE FROM PA_PROJECTS_ERP_EXT_B
272: WHERE PROJECT_ID = p_project_id
273: AND PROJ_ELEMENT_ID = l_proj_element_id
274: AND ATTR_GROUP_ID = l_attr_group_id;

Line 302: if p_validate_only <> FND_API.G_TRUE then

298: OPEN exists_in_other_task_drivers(l_attr_group_id, p_proj_element_id);
299: FETCH exists_in_other_task_drivers INTO l_dummy;
300:
301: if exists_in_other_task_drivers%NOTFOUND then
302: if p_validate_only <> FND_API.G_TRUE then
303: DELETE FROM PA_PROJECTS_ERP_EXT_B
304: WHERE PROJECT_ID = p_project_id
305: AND PROJ_ELEMENT_ID = p_proj_element_id
306: AND ATTR_GROUP_ID = l_attr_group_id;

Line 321: x_return_status := FND_API.G_RET_STS_SUCCESS;

317:
318: CLOSE get_deleted_attr_grps1;
319: end if;
320:
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322:
323: if p_commit = FND_API.G_TRUE then
324: commit work;
325: end if;

Line 323: if p_commit = FND_API.G_TRUE then

319: end if;
320:
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322:
323: if p_commit = FND_API.G_TRUE then
324: commit work;
325: end if;
326:
327: if (p_debug_mode = 'Y') then

Line 332: when FND_API.G_EXC_ERROR then

328: pa_debug.debug('PA_USER_ATTR_PVT.Delete_User_Attrs_Data END');
329: end if;
330:
331: EXCEPTION
332: when FND_API.G_EXC_ERROR then
333: if p_commit = FND_API.G_TRUE then
334: rollback to delete_user_attrs_data_pvt;
335: end if;
336: x_return_status := FND_API.G_RET_STS_ERROR;

Line 333: if p_commit = FND_API.G_TRUE then

329: end if;
330:
331: EXCEPTION
332: when FND_API.G_EXC_ERROR then
333: if p_commit = FND_API.G_TRUE then
334: rollback to delete_user_attrs_data_pvt;
335: end if;
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 336: x_return_status := FND_API.G_RET_STS_ERROR;

332: when FND_API.G_EXC_ERROR then
333: if p_commit = FND_API.G_TRUE then
334: rollback to delete_user_attrs_data_pvt;
335: end if;
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: when FND_API.G_EXC_UNEXPECTED_ERROR then
338: if p_commit = FND_API.G_TRUE then
339: rollback to delete_user_attrs_data_pvt;
340: end if;

Line 337: when FND_API.G_EXC_UNEXPECTED_ERROR then

333: if p_commit = FND_API.G_TRUE then
334: rollback to delete_user_attrs_data_pvt;
335: end if;
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: when FND_API.G_EXC_UNEXPECTED_ERROR then
338: if p_commit = FND_API.G_TRUE then
339: rollback to delete_user_attrs_data_pvt;
340: end if;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 338: if p_commit = FND_API.G_TRUE then

334: rollback to delete_user_attrs_data_pvt;
335: end if;
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: when FND_API.G_EXC_UNEXPECTED_ERROR then
338: if p_commit = FND_API.G_TRUE then
339: rollback to delete_user_attrs_data_pvt;
340: end if;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PVT',

Line 341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

337: when FND_API.G_EXC_UNEXPECTED_ERROR then
338: if p_commit = FND_API.G_TRUE then
339: rollback to delete_user_attrs_data_pvt;
340: end if;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PVT',
343: p_procedure_name => 'Delete_User_Attrs_Data',
344: p_error_text => SUBSTRB(SQLERRM,1,240));
345: when OTHERS then

Line 346: if p_commit = FND_API.G_TRUE then

342: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PVT',
343: p_procedure_name => 'Delete_User_Attrs_Data',
344: p_error_text => SUBSTRB(SQLERRM,1,240));
345: when OTHERS then
346: if p_commit = FND_API.G_TRUE then
347: rollback to delete_user_attrs_data_pvt;
348: end if;
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PVT',

Line 349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

345: when OTHERS then
346: if p_commit = FND_API.G_TRUE then
347: rollback to delete_user_attrs_data_pvt;
348: end if;
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PVT',
351: p_procedure_name => 'Delete_User_Attrs_Data',
352: p_error_text => SUBSTRB(SQLERRM,1,240));
353: raise;

Line 359: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

355:
356:
357: PROCEDURE DELETE_ALL_USER_ATTRS_DATA
358: ( p_api_version IN NUMBER := 1.0
359: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
360: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
361: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
362: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
363: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 360: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

356:
357: PROCEDURE DELETE_ALL_USER_ATTRS_DATA
358: ( p_api_version IN NUMBER := 1.0
359: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
360: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
361: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
362: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
363: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
364: ,p_debug_mode IN VARCHAR2 := 'N'

Line 361: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

357: PROCEDURE DELETE_ALL_USER_ATTRS_DATA
358: ( p_api_version IN NUMBER := 1.0
359: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
360: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
361: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
362: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
363: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
364: ,p_debug_mode IN VARCHAR2 := 'N'
365: ,p_project_id IN NUMBER

Line 362: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

358: ( p_api_version IN NUMBER := 1.0
359: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
360: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
361: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
362: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
363: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
364: ,p_debug_mode IN VARCHAR2 := 'N'
365: ,p_project_id IN NUMBER
366: ,p_proj_element_id IN NUMBER DEFAULT NULL

Line 384: if p_commit = FND_API.G_TRUE then

380: if (p_debug_mode = 'Y') then
381: pa_debug.debug('PA_USER_ATTR_PVT.Delete_All_User_Attrs_Data BEGIN');
382: end if;
383:
384: if p_commit = FND_API.G_TRUE then
385: savepoint delete_all_user_attrs_data_pvt;
386: end if;
387:
388: if p_validate_only <> FND_API.G_TRUE then

Line 388: if p_validate_only <> FND_API.G_TRUE then

384: if p_commit = FND_API.G_TRUE then
385: savepoint delete_all_user_attrs_data_pvt;
386: end if;
387:
388: if p_validate_only <> FND_API.G_TRUE then
389: if p_proj_element_id is NULL then
390: DELETE FROM PA_PROJECTS_ERP_EXT_B
391: WHERE PROJECT_ID = p_project_id;
392:

Line 406: x_return_status := FND_API.G_RET_STS_SUCCESS;

402: AND PROJ_ELEMENT_ID = p_proj_element_id;
403: end if;
404: end if;
405:
406: x_return_status := FND_API.G_RET_STS_SUCCESS;
407:
408: if p_commit = FND_API.G_TRUE then
409: commit work;
410: end if;

Line 408: if p_commit = FND_API.G_TRUE then

404: end if;
405:
406: x_return_status := FND_API.G_RET_STS_SUCCESS;
407:
408: if p_commit = FND_API.G_TRUE then
409: commit work;
410: end if;
411:
412: if (p_debug_mode = 'Y') then

Line 417: when FND_API.G_EXC_ERROR then

413: pa_debug.debug('PA_USER_ATTR_PVT.Delete_All_User_Attrs_Data END');
414: end if;
415:
416: EXCEPTION
417: when FND_API.G_EXC_ERROR then
418: if p_commit = FND_API.G_TRUE then
419: rollback to delete_all_user_attrs_data_pvt;
420: end if;
421: x_return_status := FND_API.G_RET_STS_ERROR;

Line 418: if p_commit = FND_API.G_TRUE then

414: end if;
415:
416: EXCEPTION
417: when FND_API.G_EXC_ERROR then
418: if p_commit = FND_API.G_TRUE then
419: rollback to delete_all_user_attrs_data_pvt;
420: end if;
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 421: x_return_status := FND_API.G_RET_STS_ERROR;

417: when FND_API.G_EXC_ERROR then
418: if p_commit = FND_API.G_TRUE then
419: rollback to delete_all_user_attrs_data_pvt;
420: end if;
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: when FND_API.G_EXC_UNEXPECTED_ERROR then
423: if p_commit = FND_API.G_TRUE then
424: rollback to delete_all_user_attrs_data_pvt;
425: end if;

Line 422: when FND_API.G_EXC_UNEXPECTED_ERROR then

418: if p_commit = FND_API.G_TRUE then
419: rollback to delete_all_user_attrs_data_pvt;
420: end if;
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: when FND_API.G_EXC_UNEXPECTED_ERROR then
423: if p_commit = FND_API.G_TRUE then
424: rollback to delete_all_user_attrs_data_pvt;
425: end if;
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 423: if p_commit = FND_API.G_TRUE then

419: rollback to delete_all_user_attrs_data_pvt;
420: end if;
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: when FND_API.G_EXC_UNEXPECTED_ERROR then
423: if p_commit = FND_API.G_TRUE then
424: rollback to delete_all_user_attrs_data_pvt;
425: end if;
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PVT',

Line 426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

422: when FND_API.G_EXC_UNEXPECTED_ERROR then
423: if p_commit = FND_API.G_TRUE then
424: rollback to delete_all_user_attrs_data_pvt;
425: end if;
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PVT',
428: p_procedure_name => 'Delete_All_User_Attrs_Data',
429: p_error_text => SUBSTRB(SQLERRM,1,240));
430: when OTHERS then

Line 431: if p_commit = FND_API.G_TRUE then

427: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PVT',
428: p_procedure_name => 'Delete_All_User_Attrs_Data',
429: p_error_text => SUBSTRB(SQLERRM,1,240));
430: when OTHERS then
431: if p_commit = FND_API.G_TRUE then
432: rollback to delete_all_user_attrs_data_pvt;
433: end if;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PVT',

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

430: when OTHERS then
431: if p_commit = FND_API.G_TRUE then
432: rollback to delete_all_user_attrs_data_pvt;
433: end if;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_USER_ATTR_PVT',
436: p_procedure_name => 'Delete_All_User_Attrs_Data',
437: p_error_text => SUBSTRB(SQLERRM,1,240));
438: raise;