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

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

3:
4: PROCEDURE Create_Subteam
5: (
6: p_api_version IN NUMBER := 1.0,
7: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
8: p_commit IN VARCHAR2 := FND_API.g_false,
9: p_validate_only IN VARCHAR2 := FND_API.g_true,
10: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
11: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',

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

4: PROCEDURE Create_Subteam
5: (
6: p_api_version IN NUMBER := 1.0,
7: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
8: p_commit IN VARCHAR2 := FND_API.g_false,
9: p_validate_only IN VARCHAR2 := FND_API.g_true,
10: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
11: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
12: p_debug_mode IN VARCHAR2 := 'N',

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

5: (
6: p_api_version IN NUMBER := 1.0,
7: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
8: p_commit IN VARCHAR2 := FND_API.g_false,
9: p_validate_only IN VARCHAR2 := FND_API.g_true,
10: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
11: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
12: p_debug_mode IN VARCHAR2 := 'N',
13: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

Line 10: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

6: p_api_version IN NUMBER := 1.0,
7: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
8: p_commit IN VARCHAR2 := FND_API.g_false,
9: p_validate_only IN VARCHAR2 := FND_API.g_true,
10: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
11: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
12: p_debug_mode IN VARCHAR2 := 'N',
13: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
14: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,

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

9: p_validate_only IN VARCHAR2 := FND_API.g_true,
10: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
11: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
12: p_debug_mode IN VARCHAR2 := 'N',
13: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
14: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
15: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
16: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
17: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,

Line 14: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,

10: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
11: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
12: p_debug_mode IN VARCHAR2 := 'N',
13: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
14: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
15: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
16: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
17: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
18: p_object_name IN VARCHAR2 := FND_API.g_miss_char,

Line 15: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,

11: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
12: p_debug_mode IN VARCHAR2 := 'N',
13: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
14: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
15: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
16: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
17: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
18: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
19: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,

Line 16: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,

12: p_debug_mode IN VARCHAR2 := 'N',
13: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
14: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
15: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
16: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
17: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
18: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
19: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
20: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,

Line 17: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,

13: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
14: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
15: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
16: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
17: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
18: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
19: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
20: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
21: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,

Line 18: p_object_name IN VARCHAR2 := FND_API.g_miss_char,

14: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
15: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
16: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
17: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
18: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
19: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
20: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
21: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
22: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,

Line 19: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,

15: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
16: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
17: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
18: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
19: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
20: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
21: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
22: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
23: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,

Line 20: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,

16: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
17: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
18: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
19: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
20: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
21: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
22: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
23: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
24: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,

Line 21: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,

17: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
18: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
19: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
20: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
21: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
22: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
23: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
24: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,

Line 22: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,

18: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
19: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
20: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
21: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
22: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
23: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
24: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,

Line 23: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,

19: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
20: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
21: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
22: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
23: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
24: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,

Line 24: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,

20: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
21: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
22: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
23: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
24: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,

Line 25: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,

21: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
22: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
23: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
24: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,

Line 26: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,

22: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
23: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
24: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,

Line 27: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,

23: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
24: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,

Line 28: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,

24: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,

Line 29: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,

25: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,

Line 30: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,

26: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
34: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,

Line 31: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,

27: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
34: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
35: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,

Line 32: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,

28: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
34: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
35: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
36: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,

Line 33: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,

29: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
34: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
35: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
36: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
37: --Bug: 4537865

Line 34: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,

30: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
34: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
35: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
36: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
37: --Bug: 4537865
38: x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE,

Line 35: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,

31: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
34: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
35: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
36: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
37: --Bug: 4537865
38: x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE,
39: x_subteam_row_id OUT NOCOPY ROWID,

Line 36: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,

32: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
34: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
35: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
36: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
37: --Bug: 4537865
38: x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE,
39: x_subteam_row_id OUT NOCOPY ROWID,
40: x_return_status OUT NOCOPY VARCHAR2,

Line 47: l_object_id number := FND_API.g_miss_num;

43: --Bug: 4537865
44: )
45: IS
46:
47: l_object_id number := FND_API.g_miss_num;
48: l_msg_index_out NUMBER;
49: l_error_message_code varchar2(30);
50: BEGIN
51:

Line 56: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_FALSE;

52: -- Initialize the Error Stack
53: PA_DEBUG.init_err_stack('PA_PROJECT_SUBTEAMS_PUB.Create_Subteam');
54:
55: -- Initialize the error flag
56: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_FALSE;
57:
58: -- Initialize the return status to success
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60:

Line 59: x_return_status := FND_API.G_RET_STS_SUCCESS;

55: -- Initialize the error flag
56: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_FALSE;
57:
58: -- Initialize the return status to success
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60:
61: --Clear the global PL/SQL message table
62: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
63: FND_MSG_PUB.initialize;

Line 62: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

58: -- Initialize the return status to success
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60:
61: --Clear the global PL/SQL message table
62: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: -- Issue API savepoint if the transaction is to be committed

Line 67: IF p_commit = FND_API.G_TRUE THEN

63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: -- Issue API savepoint if the transaction is to be committed
67: IF p_commit = FND_API.G_TRUE THEN
68: --DBMS_OUTPUT.Put_Line('Commit is set to '||FND_API.G_TRUE);
69: SAVEPOINT SBT_PUB_CREATE_SUBTEAM;
70: END IF;
71:

Line 68: --DBMS_OUTPUT.Put_Line('Commit is set to '||FND_API.G_TRUE);

64: END IF;
65:
66: -- Issue API savepoint if the transaction is to be committed
67: IF p_commit = FND_API.G_TRUE THEN
68: --DBMS_OUTPUT.Put_Line('Commit is set to '||FND_API.G_TRUE);
69: SAVEPOINT SBT_PUB_CREATE_SUBTEAM;
70: END IF;
71:
72: -- Do all Value to ID conversions and validations

Line 73: IF ((p_object_id IS NULL OR p_object_id = FND_API.G_MISS_NUM)

69: SAVEPOINT SBT_PUB_CREATE_SUBTEAM;
70: END IF;
71:
72: -- Do all Value to ID conversions and validations
73: IF ((p_object_id IS NULL OR p_object_id = FND_API.G_MISS_NUM)
74: AND (p_object_name IS NOT NULL AND p_object_name <> FND_API.G_MISS_CHAR)) THEN
75: pa_project_subteam_utils.get_object_id(p_object_type => p_object_type
76: ,p_object_id => l_object_id
77: ,p_object_name => p_object_name

Line 74: AND (p_object_name IS NOT NULL AND p_object_name <> FND_API.G_MISS_CHAR)) THEN

70: END IF;
71:
72: -- Do all Value to ID conversions and validations
73: IF ((p_object_id IS NULL OR p_object_id = FND_API.G_MISS_NUM)
74: AND (p_object_name IS NOT NULL AND p_object_name <> FND_API.G_MISS_CHAR)) THEN
75: pa_project_subteam_utils.get_object_id(p_object_type => p_object_type
76: ,p_object_id => l_object_id
77: ,p_object_name => p_object_name
78: ,x_return_status => x_return_status

Line 80: if(x_return_status = FND_API.G_RET_STS_ERROR) then

76: ,p_object_id => l_object_id
77: ,p_object_name => p_object_name
78: ,x_return_status => x_return_status
79: ,x_error_message_code => l_error_message_code);
80: if(x_return_status = FND_API.G_RET_STS_ERROR) then
81: PA_UTILS.Add_Message( p_app_short_name => 'PA'
82: ,p_msg_name => l_error_message_code);
83: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;
84: return;

Line 83: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;

79: ,x_error_message_code => l_error_message_code);
80: if(x_return_status = FND_API.G_RET_STS_ERROR) then
81: PA_UTILS.Add_Message( p_app_short_name => 'PA'
82: ,p_msg_name => l_error_message_code);
83: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;
84: return;
85: end if;
86: /****
87: l_project_id := PA_UTILS.GetProjId (x_project_num => p_project_number);

Line 88: ELSIF (p_project_id IS NULL OR p_project_id = FND_API.G_MISS_NUM)

84: return;
85: end if;
86: /****
87: l_project_id := PA_UTILS.GetProjId (x_project_num => p_project_number);
88: ELSIF (p_project_id IS NULL OR p_project_id = FND_API.G_MISS_NUM)
89: AND p_project_name IS NOT NULL THEN
90:
91: SELECT project_id
92: INTO l_project_id

Line 147: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

143: --
144:
145: x_msg_count := FND_MSG_PUB.Count_Msg;
146: IF x_msg_count = 1 THEN
147: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
148: ,p_msg_index => 1
149: ,p_data => x_msg_data
150: ,p_msg_index_out => l_msg_index_out
151: );

Line 159: IF PA_PROJECT_SUBTEAMS_PUB.g_error_exists = FND_API.G_TRUE THEN

155: PA_DEBUG.Reset_Err_Stack;
156:
157: -- If g_error_exists is TRUE then set the x_return_status to 'E'
158:
159: IF PA_PROJECT_SUBTEAMS_PUB.g_error_exists = FND_API.G_TRUE THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: END IF;
162:
163:

Line 160: x_return_status := FND_API.G_RET_STS_ERROR;

156:
157: -- If g_error_exists is TRUE then set the x_return_status to 'E'
158:
159: IF PA_PROJECT_SUBTEAMS_PUB.g_error_exists = FND_API.G_TRUE THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: END IF;
162:
163:
164: -- Put any message text from message stack into the Message ARRAY

Line 167: IF p_commit = FND_API.G_TRUE THEN

163:
164: -- Put any message text from message stack into the Message ARRAY
165: EXCEPTION
166: WHEN OTHERS THEN
167: IF p_commit = FND_API.G_TRUE THEN
168: ROLLBACK TO SBT_PUB_CREATE_SUBTEAM;
169: END IF;
170:
171: -- Set the excetption Message and the stack

Line 175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

171: -- Set the excetption Message and the stack
172: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SUBTEAMS_PUB.Create_Subteam'
173: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
174: --
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
176: RAISE; -- This is optional depending on the needs
177:
178: END Create_Subteam;
179:

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

180:
181: PROCEDURE Update_Subteam
182: (
183: p_api_version IN NUMBER := 1.0,
184: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
185: p_commit IN VARCHAR2 := FND_API.g_false,
186: p_validate_only IN VARCHAR2 := FND_API.g_true,
187: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
188: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',

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

181: PROCEDURE Update_Subteam
182: (
183: p_api_version IN NUMBER := 1.0,
184: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
185: p_commit IN VARCHAR2 := FND_API.g_false,
186: p_validate_only IN VARCHAR2 := FND_API.g_true,
187: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
188: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
189: p_debug_mode IN VARCHAR2 := 'N',

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

182: (
183: p_api_version IN NUMBER := 1.0,
184: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
185: p_commit IN VARCHAR2 := FND_API.g_false,
186: p_validate_only IN VARCHAR2 := FND_API.g_true,
187: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
188: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
189: p_debug_mode IN VARCHAR2 := 'N',
190: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

Line 187: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

183: p_api_version IN NUMBER := 1.0,
184: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
185: p_commit IN VARCHAR2 := FND_API.g_false,
186: p_validate_only IN VARCHAR2 := FND_API.g_true,
187: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
188: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
189: p_debug_mode IN VARCHAR2 := 'N',
190: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
191: p_subteam_row_id IN ROWID := NULL,

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

186: p_validate_only IN VARCHAR2 := FND_API.g_true,
187: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
188: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
189: p_debug_mode IN VARCHAR2 := 'N',
190: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
191: p_subteam_row_id IN ROWID := NULL,
192: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,
193: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
194: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,

Line 192: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,

188: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
189: p_debug_mode IN VARCHAR2 := 'N',
190: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
191: p_subteam_row_id IN ROWID := NULL,
192: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,
193: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
194: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
195: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
196: p_object_name IN VARCHAR2 := FND_API.g_miss_char,

Line 193: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,

189: p_debug_mode IN VARCHAR2 := 'N',
190: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
191: p_subteam_row_id IN ROWID := NULL,
192: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,
193: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
194: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
195: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
196: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
197: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,

Line 194: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,

190: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
191: p_subteam_row_id IN ROWID := NULL,
192: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,
193: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
194: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
195: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
196: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
197: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
198: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,

Line 195: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,

191: p_subteam_row_id IN ROWID := NULL,
192: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,
193: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
194: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
195: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
196: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
197: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
198: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
199: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,

Line 196: p_object_name IN VARCHAR2 := FND_API.g_miss_char,

192: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,
193: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
194: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
195: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
196: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
197: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
198: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
199: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
200: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,

Line 197: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,

193: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
194: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
195: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
196: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
197: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
198: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
199: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
200: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
201: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,

Line 198: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,

194: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
195: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
196: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
197: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
198: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
199: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
200: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
201: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
202: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,

Line 199: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,

195: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
196: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
197: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
198: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
199: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
200: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
201: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
202: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
203: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,

Line 200: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,

196: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
197: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
198: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
199: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
200: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
201: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
202: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
203: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
204: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,

Line 201: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,

197: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
198: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
199: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
200: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
201: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
202: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
203: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
204: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
205: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,

Line 202: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,

198: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
199: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
200: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
201: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
202: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
203: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
204: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
205: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
206: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,

Line 203: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,

199: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
200: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
201: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
202: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
203: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
204: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
205: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
206: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
207: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,

Line 204: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,

200: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
201: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
202: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
203: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
204: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
205: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
206: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
207: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
208: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,

Line 205: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,

201: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
202: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
203: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
204: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
205: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
206: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
207: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
208: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
209: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,

Line 206: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,

202: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
203: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
204: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
205: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
206: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
207: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
208: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
209: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
210: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,

Line 207: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,

203: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
204: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
205: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
206: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
207: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
208: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
209: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
210: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
211: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,

Line 208: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,

204: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
205: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
206: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
207: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
208: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
209: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
210: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
211: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
212: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,

Line 209: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,

205: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
206: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
207: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
208: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
209: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
210: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
211: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
212: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
213: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,

Line 210: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,

206: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
207: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
208: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
209: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
210: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
211: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
212: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
213: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
214: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,

Line 211: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,

207: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
208: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
209: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
210: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
211: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
212: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
213: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
214: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
215: --Bug: 4537865

Line 212: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,

208: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
209: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
210: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
211: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
212: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
213: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
214: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
215: --Bug: 4537865
216: x_return_status OUT NOCOPY VARCHAR2,

Line 213: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,

209: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
210: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
211: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
212: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
213: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
214: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
215: --Bug: 4537865
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,

Line 214: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,

210: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
211: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
212: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
213: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
214: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
215: --Bug: 4537865
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: --x_record_version_number OUT NOCOPY NUMBER,

Line 232: l_object_id number := FND_API.g_miss_num;

228: OR ROWID = p_subteam_row_id)
229: AND record_version_number = p_record_version_number;
230:
231: l_subteam_row_id ROWID := NULL;
232: l_object_id number := FND_API.g_miss_num;
233: l_msg_index_out number;
234: l_error_message_code varchar2(30);
235: BEGIN
236:

Line 241: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_FALSE;

237: -- Initialize the Error Stack
238: PA_DEBUG.init_err_stack('PA_PROJECT_SUBTEAMS_PUB.Update_Subteam');
239:
240: -- Initialize the error flag
241: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_FALSE;
242:
243: -- Issue API savepoint if the transaction is to be committed
244: IF p_commit = FND_API.G_TRUE THEN
245: SAVEPOINT SBT_PUB_UPDATE_SUBTEAM;

Line 244: IF p_commit = FND_API.G_TRUE THEN

240: -- Initialize the error flag
241: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_FALSE;
242:
243: -- Issue API savepoint if the transaction is to be committed
244: IF p_commit = FND_API.G_TRUE THEN
245: SAVEPOINT SBT_PUB_UPDATE_SUBTEAM;
246: END IF;
247:
248: --Clear the global PL/SQL message table

Line 249: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

245: SAVEPOINT SBT_PUB_UPDATE_SUBTEAM;
246: END IF;
247:
248: --Clear the global PL/SQL message table
249: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
250: FND_MSG_PUB.initialize;
251: END IF;
252:
253: OPEN check_record_version;

Line 260: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;

256:
257: IF check_record_version%NOTFOUND THEN
258: PA_UTILS.Add_Message( p_app_short_name => 'PA'
259: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
260: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;
261: ELSE
262: -- Do all Value to ID conversions and validations
263: IF (p_object_id IS NULL OR p_object_id = FND_API.G_MISS_NUM)
264: AND (p_object_name IS NOT NULL AND p_object_name <> FND_API.G_MISS_CHAR) THEN

Line 263: IF (p_object_id IS NULL OR p_object_id = FND_API.G_MISS_NUM)

259: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
260: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;
261: ELSE
262: -- Do all Value to ID conversions and validations
263: IF (p_object_id IS NULL OR p_object_id = FND_API.G_MISS_NUM)
264: AND (p_object_name IS NOT NULL AND p_object_name <> FND_API.G_MISS_CHAR) THEN
265: pa_project_subteam_utils.get_object_id(p_object_type => p_object_type
266: ,p_object_id => l_object_id
267: ,p_object_name => p_object_name

Line 264: AND (p_object_name IS NOT NULL AND p_object_name <> FND_API.G_MISS_CHAR) THEN

260: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;
261: ELSE
262: -- Do all Value to ID conversions and validations
263: IF (p_object_id IS NULL OR p_object_id = FND_API.G_MISS_NUM)
264: AND (p_object_name IS NOT NULL AND p_object_name <> FND_API.G_MISS_CHAR) THEN
265: pa_project_subteam_utils.get_object_id(p_object_type => p_object_type
266: ,p_object_id => l_object_id
267: ,p_object_name => p_object_name
268: ,x_return_status => x_return_status

Line 270: if(x_return_status = FND_API.G_RET_STS_ERROR) then

266: ,p_object_id => l_object_id
267: ,p_object_name => p_object_name
268: ,x_return_status => x_return_status
269: ,x_error_message_code => l_error_message_code);
270: if(x_return_status = FND_API.G_RET_STS_ERROR) then
271: PA_UTILS.Add_Message( p_app_short_name => 'PA'
272: ,p_msg_name =>l_error_message_code );
273: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;
274: return;

Line 273: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;

269: ,x_error_message_code => l_error_message_code);
270: if(x_return_status = FND_API.G_RET_STS_ERROR) then
271: PA_UTILS.Add_Message( p_app_short_name => 'PA'
272: ,p_msg_name =>l_error_message_code );
273: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;
274: return;
275: end if;
276: --l_project_id := PA_UTILS.GetProjId (x_project_num => p_project_number);
277: ELSE

Line 332: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

328: -- stack and return its text
329: --
330: x_msg_count := FND_MSG_PUB.Count_Msg;
331: IF x_msg_count = 1 THEN
332: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
333: ,p_msg_index => 1
334: ,p_data => x_msg_data
335: ,p_msg_index_out => l_msg_index_out
336: );

Line 345: IF PA_PROJECT_SUBTEAMS_PUB.g_error_exists = FND_API.G_TRUE THEN

341: PA_DEBUG.Reset_Err_Stack;
342:
343: -- If g_error_exists is TRUE then set the x_return_status to 'E'
344:
345: IF PA_PROJECT_SUBTEAMS_PUB.g_error_exists = FND_API.G_TRUE THEN
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: /***
348: SELECT record_version_number
349: into x_record_version_number

Line 346: x_return_status := FND_API.G_RET_STS_ERROR;

342:
343: -- If g_error_exists is TRUE then set the x_return_status to 'E'
344:
345: IF PA_PROJECT_SUBTEAMS_PUB.g_error_exists = FND_API.G_TRUE THEN
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: /***
348: SELECT record_version_number
349: into x_record_version_number
350: FROM pa_project_subteams

Line 361: IF p_commit = FND_API.G_TRUE THEN

357:
358: -- Put any message text from message stack into the Message ARRAY
359: EXCEPTION
360: WHEN OTHERS THEN
361: IF p_commit = FND_API.G_TRUE THEN
362: ROLLBACK TO SBT_PUB_UPDATE_SUBTEAM;
363: END IF;
364:
365: -- Set the exception Message and the stack

Line 369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

365: -- Set the exception Message and the stack
366: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SUBTEAMS_PUB.Update_Subteam'
367: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
368: --
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
370: RAISE; -- This is optional depending on the needs
371: --
372: END Update_Subteam;
373:

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

375:
376: PROCEDURE Delete_Subteam
377: (
378: p_api_version IN NUMBER := 1.0,
379: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
380: p_commit IN VARCHAR2 := FND_API.g_false,
381:
382: p_validate_only IN VARCHAR2 := FND_API.g_true,
383:

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

376: PROCEDURE Delete_Subteam
377: (
378: p_api_version IN NUMBER := 1.0,
379: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
380: p_commit IN VARCHAR2 := FND_API.g_false,
381:
382: p_validate_only IN VARCHAR2 := FND_API.g_true,
383:
384: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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

378: p_api_version IN NUMBER := 1.0,
379: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
380: p_commit IN VARCHAR2 := FND_API.g_false,
381:
382: p_validate_only IN VARCHAR2 := FND_API.g_true,
383:
384: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
385:
386: p_calling_module IN VARCHAR2

Line 384: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

380: p_commit IN VARCHAR2 := FND_API.g_false,
381:
382: p_validate_only IN VARCHAR2 := FND_API.g_true,
383:
384: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
385:
386: p_calling_module IN VARCHAR2
387: := 'SELF_SERVICE',
388:

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

387: := 'SELF_SERVICE',
388:
389: p_debug_mode IN VARCHAR2 := 'N',
390:
391: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
392:
393: p_subteam_row_id IN ROWID := NULL,
394:
395: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM,

Line 395: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM,

391: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
392:
393: p_subteam_row_id IN ROWID := NULL,
394:
395: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM,
396:
397: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
398: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
399:

Line 397: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,

393: p_subteam_row_id IN ROWID := NULL,
394:
395: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM,
396:
397: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
398: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
399:
400: p_subteam_name IN pa_project_subteams.name%TYPE := fnd_api.g_miss_char,
401:

Line 398: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,

394:
395: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM,
396:
397: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
398: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
399:
400: p_subteam_name IN pa_project_subteams.name%TYPE := fnd_api.g_miss_char,
401:
402: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM ,

Line 400: p_subteam_name IN pa_project_subteams.name%TYPE := fnd_api.g_miss_char,

396:
397: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
398: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
399:
400: p_subteam_name IN pa_project_subteams.name%TYPE := fnd_api.g_miss_char,
401:
402: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM ,
403:
404: --Bug: 4537865

Line 402: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM ,

398: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
399:
400: p_subteam_name IN pa_project_subteams.name%TYPE := fnd_api.g_miss_char,
401:
402: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM ,
403:
404: --Bug: 4537865
405: x_return_status OUT NOCOPY VARCHAR2,
406:

Line 434: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_FALSE;

430: -- Initialize the Error Stack
431: PA_DEBUG.init_err_stack('PA_PROJECT_SUBTEAMS_PUB.Delete_Subteam');
432:
433: -- Initialize the error flag
434: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_FALSE;
435:
436: -- Issue API savepoint if the transaction is to be committed
437: IF p_commit = FND_API.G_TRUE THEN
438: SAVEPOINT SBT_PUB_DELETE_SUBTEAM;

Line 437: IF p_commit = FND_API.G_TRUE THEN

433: -- Initialize the error flag
434: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_FALSE;
435:
436: -- Issue API savepoint if the transaction is to be committed
437: IF p_commit = FND_API.G_TRUE THEN
438: SAVEPOINT SBT_PUB_DELETE_SUBTEAM;
439: END IF;
440:
441: --Clear the global PL/SQL message table

Line 442: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

438: SAVEPOINT SBT_PUB_DELETE_SUBTEAM;
439: END IF;
440:
441: --Clear the global PL/SQL message table
442: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
443: FND_MSG_PUB.initialize;
444: END IF;
445:
446: OPEN check_subteam;

Line 454: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;

450: IF check_subteam%NOTFOUND THEN
451:
452: PA_UTILS.Add_Message( p_app_short_name => 'PA'
453: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
454: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;
455:
456: ELSE
457:
458: -- Call the private API

Line 486: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

482: -- IF the number of messages is 1 then fetch the message code from the stack and return its text
483: --
484: x_msg_count := FND_MSG_PUB.Count_Msg;
485: IF x_msg_count = 1 THEN
486: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
487: ,p_msg_index => 1
488: ,p_data => x_msg_data
489: ,p_msg_index_out => l_msg_index_out
490: );

Line 498: IF PA_PROJECT_SUBTEAMS_PUB.g_error_exists = FND_API.G_TRUE THEN

494: PA_DEBUG.Reset_Err_Stack;
495:
496: -- If g_error_exists is TRUE then set the x_return_status to 'E'
497:
498: IF PA_PROJECT_SUBTEAMS_PUB.g_error_exists = FND_API.G_TRUE THEN
499:
500: x_return_status := FND_API.G_RET_STS_ERROR;
501:
502: END IF;

Line 500: x_return_status := FND_API.G_RET_STS_ERROR;

496: -- If g_error_exists is TRUE then set the x_return_status to 'E'
497:
498: IF PA_PROJECT_SUBTEAMS_PUB.g_error_exists = FND_API.G_TRUE THEN
499:
500: x_return_status := FND_API.G_RET_STS_ERROR;
501:
502: END IF;
503:
504:

Line 509: IF p_commit = FND_API.G_TRUE THEN

505: -- Put any message text from message stack into the Message ARRAY
506: --
507: EXCEPTION
508: WHEN OTHERS THEN
509: IF p_commit = FND_API.G_TRUE THEN
510: ROLLBACK TO SBT_PUB_DELETE_SUBTEAM;
511: END IF;
512: -- Set the excetption Message and the stack
513: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_SUBTEAMS_PUB.Delete_Subteam'

Line 516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

512: -- Set the excetption Message and the stack
513: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_SUBTEAMS_PUB.Delete_Subteam'
514: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
515: --
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
517: RAISE; -- This is optional depending on the needs
518: --
519: END Delete_Subteam;
520:

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

520:
521: PROCEDURE Delete_Subteam_By_Obj
522: (
523: p_api_version IN NUMBER := 1.0,
524: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
525: p_commit IN VARCHAR2 := FND_API.g_false,
526:
527: p_validate_only IN VARCHAR2 := FND_API.g_true,
528:

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

521: PROCEDURE Delete_Subteam_By_Obj
522: (
523: p_api_version IN NUMBER := 1.0,
524: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
525: p_commit IN VARCHAR2 := FND_API.g_false,
526:
527: p_validate_only IN VARCHAR2 := FND_API.g_true,
528:
529: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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

523: p_api_version IN NUMBER := 1.0,
524: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
525: p_commit IN VARCHAR2 := FND_API.g_false,
526:
527: p_validate_only IN VARCHAR2 := FND_API.g_true,
528:
529: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
530:
531: p_calling_module IN VARCHAR2

Line 529: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

525: p_commit IN VARCHAR2 := FND_API.g_false,
526:
527: p_validate_only IN VARCHAR2 := FND_API.g_true,
528:
529: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
530:
531: p_calling_module IN VARCHAR2
532: := 'SELF_SERVICE',
533:

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

532: := 'SELF_SERVICE',
533:
534: p_debug_mode IN VARCHAR2 := 'N',
535:
536: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
537:
538: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
539: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
540:

Line 538: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,

534: p_debug_mode IN VARCHAR2 := 'N',
535:
536: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
537:
538: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
539: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
540:
541: --Bug: 4537865
542: x_return_status OUT NOCOPY VARCHAR2,

Line 539: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,

535:
536: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
537:
538: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
539: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
540:
541: --Bug: 4537865
542: x_return_status OUT NOCOPY VARCHAR2,
543:

Line 567: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_FALSE;

563: -- Initialize the Error Stack
564: PA_DEBUG.init_err_stack('PA_PROJECT_SUBTEAMS_PUB.Delete_Subteam_By_Obj');
565:
566: -- Initialize the error flag
567: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_FALSE;
568:
569: -- Issue API savepoint if the transaction is to be committed
570: IF p_commit = FND_API.G_TRUE THEN
571: SAVEPOINT SBT_PUB_DELETE_SUBTEAM_BY_OBJ;

Line 570: IF p_commit = FND_API.G_TRUE THEN

566: -- Initialize the error flag
567: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_FALSE;
568:
569: -- Issue API savepoint if the transaction is to be committed
570: IF p_commit = FND_API.G_TRUE THEN
571: SAVEPOINT SBT_PUB_DELETE_SUBTEAM_BY_OBJ;
572: END IF;
573:
574: --Clear the global PL/SQL message table

Line 575: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

571: SAVEPOINT SBT_PUB_DELETE_SUBTEAM_BY_OBJ;
572: END IF;
573:
574: --Clear the global PL/SQL message table
575: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
576: FND_MSG_PUB.initialize;
577: END IF;
578:
579: OPEN check_subteam;

Line 589: --PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;

585: --IF check_subteam%NOTFOUND THEN
586:
587: --PA_UTILS.Add_Message( p_app_short_name => 'PA'
588: -- ,p_msg_name => 'PA_XC_RECORD_CHANGED');
589: --PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;
590:
591: --ELSE
592:
593: -- Call the private API

Line 620: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

616: -- IF the number of messages is 1 then fetch the message code from the stack and return its text
617: --
618: x_msg_count := FND_MSG_PUB.Count_Msg;
619: IF x_msg_count = 1 THEN
620: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
621: ,p_msg_index => 1
622: ,p_data => x_msg_data
623: ,p_msg_index_out => l_msg_index_out
624: );

Line 632: IF PA_PROJECT_SUBTEAMS_PUB.g_error_exists = FND_API.G_TRUE THEN

628: PA_DEBUG.Reset_Err_Stack;
629:
630: -- If g_error_exists is TRUE then set the x_return_status to 'E'
631:
632: IF PA_PROJECT_SUBTEAMS_PUB.g_error_exists = FND_API.G_TRUE THEN
633:
634: x_return_status := FND_API.G_RET_STS_ERROR;
635:
636: END IF;

Line 634: x_return_status := FND_API.G_RET_STS_ERROR;

630: -- If g_error_exists is TRUE then set the x_return_status to 'E'
631:
632: IF PA_PROJECT_SUBTEAMS_PUB.g_error_exists = FND_API.G_TRUE THEN
633:
634: x_return_status := FND_API.G_RET_STS_ERROR;
635:
636: END IF;
637:
638:

Line 643: IF p_commit = FND_API.G_TRUE THEN

639: -- Put any message text from message stack into the Message ARRAY
640: --
641: EXCEPTION
642: WHEN OTHERS THEN
643: IF p_commit = FND_API.G_TRUE THEN
644: ROLLBACK TO SBT_PUB_DELETE_SUBTEAM_BY_OBJ;
645: END IF;
646: -- Set the excetption Message and the stack
647: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_SUBTEAMS_PUB.Delete_Subteam_By_Obj'

Line 650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

646: -- Set the excetption Message and the stack
647: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJECT_SUBTEAMS_PUB.Delete_Subteam_By_Obj'
648: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
649: --
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
651: RAISE; -- This is optional depending on the needs
652: --
653: END Delete_Subteam_By_Obj;
654: