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

Line 6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

2: /* $Header: PACITYVB.pls 120.2 2005/09/08 01:51:15 raluthra noship $ */
3:
4: PROCEDURE create_ci_type (
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_name IN VARCHAR2,

Line 7: p_commit IN VARCHAR2 := FND_API.g_false,

3:
4: PROCEDURE create_ci_type (
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_name IN VARCHAR2,
11: p_short_name IN VARCHAR2,

Line 8: p_validate_only IN VARCHAR2 := FND_API.g_true,

4: PROCEDURE create_ci_type (
5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_name IN VARCHAR2,
11: p_short_name IN VARCHAR2,
12: p_description IN VARCHAR2,

Line 9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

5: p_api_version IN NUMBER := 1.0,
6: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validate_only IN VARCHAR2 := FND_API.g_true,
9: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10: p_name IN VARCHAR2,
11: p_short_name IN VARCHAR2,
12: p_description IN VARCHAR2,
13: p_ci_type_class_code IN VARCHAR2,

Line 58: IF p_commit = FND_API.G_TRUE THEN

54: l_dist_list_id NUMBER; -- Bug 4565156.
55: BEGIN
56: pa_debug.set_err_stack ('PA_CI_TYPES_PVT.CREATE_CI_TYPE');
57:
58: IF p_commit = FND_API.G_TRUE THEN
59: SAVEPOINT create_ci_type;
60: END IF;
61:
62: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 62: IF p_init_msg_list = FND_API.G_TRUE THEN

58: IF p_commit = FND_API.G_TRUE THEN
59: SAVEPOINT create_ci_type;
60: END IF;
61:
62: IF p_init_msg_list = FND_API.G_TRUE THEN
63: fnd_msg_pub.initialize;
64: END IF;
65:
66: x_return_status := 'S';

Line 92: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

88: fnd_message.set_name('PA', 'PA_CI_TYPE_INVALID_DATES');
89: fnd_msg_pub.add();
90: END IF;
91:
92: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
93: SELECT pa_ci_types_b_s.NEXTVAL
94: INTO x_ci_type_id
95: FROM sys.dual;
96:

Line 181: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

177: );
178: END IF;
179:
180: --Associating the dist list to the CI type
181: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
182: pa_object_dist_lists_pvt.create_object_dist_list (
183: p_validate_only => p_validate_only,
184: p_list_id => x_dist_list_id,
185: p_object_type => 'PA_CI_TYPES',

Line 197: IF p_commit = fnd_api.g_true THEN

193: x_msg_count => x_msg_count,
194: x_msg_data => x_msg_data);
195: END IF;
196:
197: IF p_commit = fnd_api.g_true THEN
198: IF x_return_status = 'S' THEN
199: COMMIT;
200: ELSE
201: ROLLBACK TO create_ci_type;

Line 212: IF p_commit = fnd_api.g_true THEN

208: pa_debug.reset_err_stack;
209:
210: EXCEPTION
211: WHEN OTHERS THEN
212: IF p_commit = fnd_api.g_true THEN
213: ROLLBACK TO create_ci_type;
214: END IF;
215:
216: x_return_status := 'U';

Line 228: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

224:
225:
226: PROCEDURE update_ci_type (
227: p_api_version IN NUMBER := 1.0,
228: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
229: p_commit IN VARCHAR2 := FND_API.g_false,
230: p_validate_only IN VARCHAR2 := FND_API.g_true,
231: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
232: p_ci_type_id IN NUMBER,

Line 229: p_commit IN VARCHAR2 := FND_API.g_false,

225:
226: PROCEDURE update_ci_type (
227: p_api_version IN NUMBER := 1.0,
228: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
229: p_commit IN VARCHAR2 := FND_API.g_false,
230: p_validate_only IN VARCHAR2 := FND_API.g_true,
231: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
232: p_ci_type_id IN NUMBER,
233: p_name IN VARCHAR2,

Line 230: p_validate_only IN VARCHAR2 := FND_API.g_true,

226: PROCEDURE update_ci_type (
227: p_api_version IN NUMBER := 1.0,
228: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
229: p_commit IN VARCHAR2 := FND_API.g_false,
230: p_validate_only IN VARCHAR2 := FND_API.g_true,
231: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
232: p_ci_type_id IN NUMBER,
233: p_name IN VARCHAR2,
234: p_short_name IN VARCHAR2,

Line 231: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

227: p_api_version IN NUMBER := 1.0,
228: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
229: p_commit IN VARCHAR2 := FND_API.g_false,
230: p_validate_only IN VARCHAR2 := FND_API.g_true,
231: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
232: p_ci_type_id IN NUMBER,
233: p_name IN VARCHAR2,
234: p_short_name IN VARCHAR2,
235: p_description IN VARCHAR2,

Line 282: IF p_commit = FND_API.G_TRUE THEN

278:
279: BEGIN
280: pa_debug.set_err_stack ('PA_CI_TYPES_PVT.UPDATE_CI_TYPE');
281:
282: IF p_commit = FND_API.G_TRUE THEN
283: SAVEPOINT update_ci_type;
284: END IF;
285:
286: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 286: IF p_init_msg_list = FND_API.G_TRUE THEN

282: IF p_commit = FND_API.G_TRUE THEN
283: SAVEPOINT update_ci_type;
284: END IF;
285:
286: IF p_init_msg_list = FND_API.G_TRUE THEN
287: fnd_msg_pub.initialize;
288: END IF;
289:
290: x_return_status := 'S';

Line 413: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

409: fnd_message.set_name('PA', 'PA_CI_TYPE_INVALID_DATES');
410: fnd_msg_pub.add();
411: END IF;
412:
413: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
414: pa_ci_types_pkg.update_row(
415: x_ci_type_id => p_ci_type_id,
416: x_ci_type_class_code => p_ci_type_class_code,
417: x_auto_number_flag => p_auto_number_flag,

Line 463: IF p_commit = fnd_api.g_true THEN

459: X_LAST_UPDATE_LOGIN => p_last_update_login
460: );
461: END IF;
462:
463: IF p_commit = fnd_api.g_true THEN
464: IF x_return_status = 'S' THEN
465: COMMIT;
466: ELSE
467: ROLLBACK TO update_ci_type;

Line 478: IF p_commit = fnd_api.g_true THEN

474: pa_debug.reset_err_stack;
475:
476: EXCEPTION
477: WHEN OTHERS THEN
478: IF p_commit = fnd_api.g_true THEN
479: ROLLBACK TO update_ci_type;
480: END IF;
481:
482: x_return_status := 'U';

Line 494: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

490:
491:
492: PROCEDURE delete_ci_type (
493: p_api_version IN NUMBER := 1.0,
494: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
495: p_commit IN VARCHAR2 := FND_API.g_false,
496: p_validate_only IN VARCHAR2 := FND_API.g_true,
497: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
498: p_ci_type_id IN NUMBER,

Line 495: p_commit IN VARCHAR2 := FND_API.g_false,

491:
492: PROCEDURE delete_ci_type (
493: p_api_version IN NUMBER := 1.0,
494: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
495: p_commit IN VARCHAR2 := FND_API.g_false,
496: p_validate_only IN VARCHAR2 := FND_API.g_true,
497: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
498: p_ci_type_id IN NUMBER,
499: p_record_version_number IN NUMBER,

Line 496: p_validate_only IN VARCHAR2 := FND_API.g_true,

492: PROCEDURE delete_ci_type (
493: p_api_version IN NUMBER := 1.0,
494: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
495: p_commit IN VARCHAR2 := FND_API.g_false,
496: p_validate_only IN VARCHAR2 := FND_API.g_true,
497: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
498: p_ci_type_id IN NUMBER,
499: p_record_version_number IN NUMBER,
500: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 497: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

493: p_api_version IN NUMBER := 1.0,
494: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
495: p_commit IN VARCHAR2 := FND_API.g_false,
496: p_validate_only IN VARCHAR2 := FND_API.g_true,
497: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
498: p_ci_type_id IN NUMBER,
499: p_record_version_number IN NUMBER,
500: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
501: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 525: IF p_commit = FND_API.G_TRUE THEN

521: l_temp VARCHAR2(1);
522: BEGIN
523: pa_debug.set_err_stack ('PA_CI_TYPES_PVT.DELETE_CI_TYPE');
524:
525: IF p_commit = FND_API.G_TRUE THEN
526: SAVEPOINT delete_ci_type;
527: END IF;
528:
529: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 529: IF p_init_msg_list = FND_API.G_TRUE THEN

525: IF p_commit = FND_API.G_TRUE THEN
526: SAVEPOINT delete_ci_type;
527: END IF;
528:
529: IF p_init_msg_list = FND_API.G_TRUE THEN
530: fnd_msg_pub.initialize;
531: END IF;
532:
533: x_return_status := 'S';

Line 576: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

572: end if;
573: /* Changes for the bug# 3941304 ends here */
574:
575: --Deleting the associated distribution list
576: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
577: pa_object_dist_lists_pvt.delete_assoc_dist_lists (
578: p_validate_only => p_validate_only,
579: p_object_type => 'PA_CI_TYPES',
580: p_object_id => p_ci_type_id,

Line 587: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

583: x_msg_data => x_msg_data);
584: END IF;
585:
586: --Deleting the CI type usage
587: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
588: FOR rec IN c_ci_type_usage LOOP
589: pa_ci_type_usage_pvt.delete_ci_type_usage (
590: p_validate_only => p_validate_only,
591: p_ci_type_usage_id => rec.ci_type_usage_id,

Line 603: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

599: END LOOP;
600: END IF;
601:
602: --Deleting the impact type usage
603: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
604: FOR rec IN c_impact_type_usage LOOP
605: pa_ci_impact_type_usage_pvt.delete_ci_impact_type_usage (
606: p_validate_only => p_validate_only,
607: p_ci_impact_type_usage_id => rec.ci_impact_type_usage_id,

Line 620: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

616: END LOOP;
617: END IF;
618:
619: --Deleting the CI type itself
620: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
621: pa_ci_types_pkg.delete_row(
622: x_ci_type_id => p_ci_type_id);
623:
624: --Deleting the association from pa_obj_status_lists

Line 629: IF p_commit = fnd_api.g_true THEN

625: pa_obj_status_lists_pkg.delete_row(
626: x_obj_status_list_id => p_obj_status_list_id);
627: END IF;
628:
629: IF p_commit = fnd_api.g_true THEN
630: IF x_return_status = 'S' THEN
631: COMMIT;
632: ELSE
633: ROLLBACK TO delete_ci_type;

Line 644: IF p_commit = fnd_api.g_true THEN

640: pa_debug.reset_err_stack;
641:
642: EXCEPTION
643: WHEN OTHERS THEN
644: IF p_commit = fnd_api.g_true THEN
645: ROLLBACK TO delete_ci_type;
646: END IF;
647:
648: x_return_status := 'U';