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

Line 13: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE

9: -- Type : Public
10: -- Pre-reqs : None.
11: -- Parameters :
12: -- p_api_version IN NUMBER Required Default = 1.0
13: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
14: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
15: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
16: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

Line 14: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

10: -- Pre-reqs : None.
11: -- Parameters :
12: -- p_api_version IN NUMBER Required Default = 1.0
13: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
14: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
15: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
16: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
18: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 15: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

11: -- Parameters :
12: -- p_api_version IN NUMBER Required Default = 1.0
13: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
14: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
15: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
16: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
18: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
19: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 16: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

12: -- p_api_version IN NUMBER Required Default = 1.0
13: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
14: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
15: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
16: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
18: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
19: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
20: -- p_project_id IN NUMBER Required

Line 19: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

15: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
16: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
17: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
18: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
19: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
20: -- p_project_id IN NUMBER Required
21: -- p_proj_element_id IN NUMBER Required
22: -- p_approval_reqd_flag IN VARCHAR2 Required
23: -- p_auto_publish_flag IN VARCHAR2 Required

Line 24: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

20: -- p_project_id IN NUMBER Required
21: -- p_proj_element_id IN NUMBER Required
22: -- p_approval_reqd_flag IN VARCHAR2 Required
23: -- p_auto_publish_flag IN VARCHAR2 Required
24: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
25: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
27: -- p_default_display_lvl IN NUMBER Required
28: -- p_enable_wp_version_flag IN VARCHAR2 Required

Line 25: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM

21: -- p_proj_element_id IN NUMBER Required
22: -- p_approval_reqd_flag IN VARCHAR2 Required
23: -- p_auto_publish_flag IN VARCHAR2 Required
24: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
25: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
27: -- p_default_display_lvl IN NUMBER Required
28: -- p_enable_wp_version_flag IN VARCHAR2 Required
29: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 26: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

22: -- p_approval_reqd_flag IN VARCHAR2 Required
23: -- p_auto_publish_flag IN VARCHAR2 Required
24: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
25: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
27: -- p_default_display_lvl IN NUMBER Required
28: -- p_enable_wp_version_flag IN VARCHAR2 Required
29: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
30: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 29: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

25: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
26: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
27: -- p_default_display_lvl IN NUMBER Required
28: -- p_enable_wp_version_flag IN VARCHAR2 Required
29: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
30: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
32: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
33: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required

Line 30: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

26: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
27: -- p_default_display_lvl IN NUMBER Required
28: -- p_enable_wp_version_flag IN VARCHAR2 Required
29: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
30: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
32: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
33: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
34: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required

Line 31: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

27: -- p_default_display_lvl IN NUMBER Required
28: -- p_enable_wp_version_flag IN VARCHAR2 Required
29: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
30: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
32: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
33: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
34: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required
35: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 32: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

28: -- p_enable_wp_version_flag IN VARCHAR2 Required
29: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
30: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
31: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
32: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
33: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
34: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required
35: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
36: -- x_return_status OUT VARCHAR2 Required

Line 35: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM

31: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
32: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
33: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
34: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required
35: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
36: -- x_return_status OUT VARCHAR2 Required
37: -- x_msg_count OUT NUMBER Required
38: -- x_msg_data OUT VARCHAR2 Optional
39:

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

38: -- x_msg_data OUT VARCHAR2 Optional
39:
40: PROCEDURE CREATE_PROJ_WORKPLAN_ATTRS
41: ( p_api_version IN NUMBER := 1.0
42: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
43: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
44: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
45: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
46: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 43: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

39:
40: PROCEDURE CREATE_PROJ_WORKPLAN_ATTRS
41: ( p_api_version IN NUMBER := 1.0
42: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
43: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
44: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
45: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
46: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
47: ,p_debug_mode IN VARCHAR2 := 'N'

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

40: PROCEDURE CREATE_PROJ_WORKPLAN_ATTRS
41: ( p_api_version IN NUMBER := 1.0
42: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
43: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
44: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
45: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
46: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
47: ,p_debug_mode IN VARCHAR2 := 'N'
48: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

41: ( p_api_version IN NUMBER := 1.0
42: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
43: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
44: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
45: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
46: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
47: ,p_debug_mode IN VARCHAR2 := 'N'
48: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
49: ,p_project_id IN NUMBER

Line 48: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

44: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
45: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
46: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
47: ,p_debug_mode IN VARCHAR2 := 'N'
48: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
49: ,p_project_id IN NUMBER
50: ,p_proj_element_id IN NUMBER
51: ,p_approval_reqd_flag IN VARCHAR2
52: ,p_auto_publish_flag IN VARCHAR2

Line 53: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM

49: ,p_project_id IN NUMBER
50: ,p_proj_element_id IN NUMBER
51: ,p_approval_reqd_flag IN VARCHAR2
52: ,p_auto_publish_flag IN VARCHAR2
53: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
54: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
55: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
56: ,p_default_display_lvl IN NUMBER
57: ,p_enable_wp_version_flag IN VARCHAR2

Line 54: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM

50: ,p_proj_element_id IN NUMBER
51: ,p_approval_reqd_flag IN VARCHAR2
52: ,p_auto_publish_flag IN VARCHAR2
53: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
54: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
55: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
56: ,p_default_display_lvl IN NUMBER
57: ,p_enable_wp_version_flag IN VARCHAR2
58: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM

Line 55: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR

51: ,p_approval_reqd_flag IN VARCHAR2
52: ,p_auto_publish_flag IN VARCHAR2
53: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
54: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
55: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
56: ,p_default_display_lvl IN NUMBER
57: ,p_enable_wp_version_flag IN VARCHAR2
58: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
59: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 58: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM

54: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
55: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
56: ,p_default_display_lvl IN NUMBER
57: ,p_enable_wp_version_flag IN VARCHAR2
58: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
59: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
60: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
61: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
62: ,p_auto_pub_upon_creation_flag IN VARCHAR2

Line 59: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR

55: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
56: ,p_default_display_lvl IN NUMBER
57: ,p_enable_wp_version_flag IN VARCHAR2
58: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
59: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
60: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
61: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
62: ,p_auto_pub_upon_creation_flag IN VARCHAR2
63: ,p_auto_sync_txn_date_flag IN VARCHAR2

Line 60: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM

56: ,p_default_display_lvl IN NUMBER
57: ,p_enable_wp_version_flag IN VARCHAR2
58: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
59: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
60: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
61: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
62: ,p_auto_pub_upon_creation_flag IN VARCHAR2
63: ,p_auto_sync_txn_date_flag IN VARCHAR2
64: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM

Line 61: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR

57: ,p_enable_wp_version_flag IN VARCHAR2
58: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
59: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
60: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
61: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
62: ,p_auto_pub_upon_creation_flag IN VARCHAR2
63: ,p_auto_sync_txn_date_flag IN VARCHAR2
64: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
65: --bug 3325803: FP M

Line 64: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM

60: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
61: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
62: ,p_auto_pub_upon_creation_flag IN VARCHAR2
63: ,p_auto_sync_txn_date_flag IN VARCHAR2
64: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
65: --bug 3325803: FP M
66: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
67: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
68: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 66: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

62: ,p_auto_pub_upon_creation_flag IN VARCHAR2
63: ,p_auto_sync_txn_date_flag IN VARCHAR2
64: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
65: --bug 3325803: FP M
66: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
67: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
68: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
69: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
70: --bug 3325803: FP M

Line 67: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

63: ,p_auto_sync_txn_date_flag IN VARCHAR2
64: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
65: --bug 3325803: FP M
66: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
67: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
68: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
69: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
70: --bug 3325803: FP M
71: --FP M: Workflow attributes

Line 68: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

64: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
65: --bug 3325803: FP M
66: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
67: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
68: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
69: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
70: --bug 3325803: FP M
71: --FP M: Workflow attributes
72: -- gboomina Bug 8586393 - start

Line 69: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

65: --bug 3325803: FP M
66: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
67: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
68: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
69: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
70: --bug 3325803: FP M
71: --FP M: Workflow attributes
72: -- gboomina Bug 8586393 - start
73: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 73: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

69: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
70: --bug 3325803: FP M
71: --FP M: Workflow attributes
72: -- gboomina Bug 8586393 - start
73: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
74: -- gboomina Bug 8586393 - end
75: ,p_enable_wf_flag IN VARCHAR2 := 'N'
76: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
77: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 102: if p_commit = FND_API.G_TRUE then

98: if (p_debug_mode = 'Y') then
99: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Create_Proj_Workplan_Attrs BEGIN');
100: end if;
101:
102: if p_commit = FND_API.G_TRUE then
103: savepoint create_proj_workplan_attrs;
104: end if;
105:
106: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 106: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

102: if p_commit = FND_API.G_TRUE then
103: savepoint create_proj_workplan_attrs;
104: end if;
105:
106: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
107: raise FND_API.G_EXC_UNEXPECTED_ERROR;
108: end if;
109:
110: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then

Line 107: raise FND_API.G_EXC_UNEXPECTED_ERROR;

103: savepoint create_proj_workplan_attrs;
104: end if;
105:
106: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
107: raise FND_API.G_EXC_UNEXPECTED_ERROR;
108: end if;
109:
110: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
111: FND_MSG_PUB.initialize;

Line 110: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then

106: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
107: raise FND_API.G_EXC_UNEXPECTED_ERROR;
108: end if;
109:
110: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
111: FND_MSG_PUB.initialize;
112: end if;
113:
114: if (p_debug_mode = 'Y') then

Line 118: if ((p_approver_name <> FND_API.G_MISS_CHAR) AND (p_approver_name is not NULL)) OR

114: if (p_debug_mode = 'Y') then
115: pa_debug.debug('Performing ID validations and conversions...');
116: end if;
117:
118: if ((p_approver_name <> FND_API.G_MISS_CHAR) AND (p_approver_name is not NULL)) OR
119: ((p_approver_source_id <> FND_API.G_MISS_NUM) AND (p_approver_source_id is not NULL)) then
120: PA_WORKPLAN_ATTR_UTILS.CHECK_APPROVER_NAME_OR_ID
121: ( p_approver_source_id => p_approver_source_id
122: ,p_approver_source_type => p_approver_source_type

Line 119: ((p_approver_source_id <> FND_API.G_MISS_NUM) AND (p_approver_source_id is not NULL)) then

115: pa_debug.debug('Performing ID validations and conversions...');
116: end if;
117:
118: if ((p_approver_name <> FND_API.G_MISS_CHAR) AND (p_approver_name is not NULL)) OR
119: ((p_approver_source_id <> FND_API.G_MISS_NUM) AND (p_approver_source_id is not NULL)) then
120: PA_WORKPLAN_ATTR_UTILS.CHECK_APPROVER_NAME_OR_ID
121: ( p_approver_source_id => p_approver_source_id
122: ,p_approver_source_type => p_approver_source_type
123: ,p_approver_name => p_approver_name

Line 130: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

126: ,x_approver_source_type => l_approver_source_type
127: ,x_return_status => l_return_status
128: ,x_error_msg_code => l_error_msg_code);
129:
130: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
131: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
132: end if;
133: end if;
134:

Line 140: if ((p_lifecycle_name <> FND_API.G_MISS_CHAR) AND (p_lifecycle_name is not NULL)) OR

136: PA_UTILS.Add_Message( p_app_short_name => 'PA'
137: ,p_msg_name => 'PA_PS_APPROVER_ERR');
138: End If;
139:
140: if ((p_lifecycle_name <> FND_API.G_MISS_CHAR) AND (p_lifecycle_name is not NULL)) OR
141: ((p_lifecycle_id <> FND_API.G_MISS_NUM) AND (p_lifecycle_id is not NULL)) then
142: PA_WORKPLAN_ATTR_UTILS.CHECK_LIFECYCLE_NAME_OR_ID
143: ( p_lifecycle_id => p_lifecycle_id
144: ,p_lifecycle_name => p_lifecycle_name

Line 141: ((p_lifecycle_id <> FND_API.G_MISS_NUM) AND (p_lifecycle_id is not NULL)) then

137: ,p_msg_name => 'PA_PS_APPROVER_ERR');
138: End If;
139:
140: if ((p_lifecycle_name <> FND_API.G_MISS_CHAR) AND (p_lifecycle_name is not NULL)) OR
141: ((p_lifecycle_id <> FND_API.G_MISS_NUM) AND (p_lifecycle_id is not NULL)) then
142: PA_WORKPLAN_ATTR_UTILS.CHECK_LIFECYCLE_NAME_OR_ID
143: ( p_lifecycle_id => p_lifecycle_id
144: ,p_lifecycle_name => p_lifecycle_name
145: ,p_check_id_flag => 'Y'

Line 150: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

146: ,x_lifecycle_id => l_lifecycle_id
147: ,x_return_status => l_return_status
148: ,x_error_msg_code => l_error_msg_code);
149:
150: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
151: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
152: end if;
153: end if;
154:

Line 155: if ((p_current_lifecycle_phase_id <> FND_API.G_MISS_NUM) AND (p_current_lifecycle_phase_id is not NULL)) OR

151: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
152: end if;
153: end if;
154:
155: if ((p_current_lifecycle_phase_id <> FND_API.G_MISS_NUM) AND (p_current_lifecycle_phase_id is not NULL)) OR
156: ((p_current_lifecycle_phase <> FND_API.G_MISS_NUM) AND (p_current_lifecycle_phase is not NULL)) then
157: PA_WORKPLAN_ATTR_UTILS.CHECK_LIFECYCLE_PHASE_NAME_ID
158: ( p_lifecycle_id => l_lifecycle_id
159: ,p_current_lifecycle_phase_id => p_current_lifecycle_phase_id

Line 156: ((p_current_lifecycle_phase <> FND_API.G_MISS_NUM) AND (p_current_lifecycle_phase is not NULL)) then

152: end if;
153: end if;
154:
155: if ((p_current_lifecycle_phase_id <> FND_API.G_MISS_NUM) AND (p_current_lifecycle_phase_id is not NULL)) OR
156: ((p_current_lifecycle_phase <> FND_API.G_MISS_NUM) AND (p_current_lifecycle_phase is not NULL)) then
157: PA_WORKPLAN_ATTR_UTILS.CHECK_LIFECYCLE_PHASE_NAME_ID
158: ( p_lifecycle_id => l_lifecycle_id
159: ,p_current_lifecycle_phase_id => p_current_lifecycle_phase_id
160: ,p_current_lifecycle_phase => p_current_lifecycle_phase

Line 166: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

162: ,x_current_lifecycle_phase_id => l_current_lifecycle_phase_id
163: ,x_return_status => l_return_status
164: ,x_error_msg_code => l_error_msg_code);
165:
166: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
167: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
168: end if;
169: end if;
170:

Line 176: (p_encoded => FND_API.G_TRUE,

172: if l_msg_count > 0 then
173: x_msg_count := l_msg_count;
174: if x_msg_count = 1 then
175: pa_interface_utils_pub.get_messages
176: (p_encoded => FND_API.G_TRUE,
177: p_msg_index => 1,
178: p_msg_count => l_msg_count,
179: p_msg_data => l_msg_data,
180: p_data => l_data,

Line 184: raise FND_API.G_EXC_ERROR;

180: p_data => l_data,
181: p_msg_index_out => l_msg_index_out);
182: x_msg_data := l_data;
183: end if;
184: raise FND_API.G_EXC_ERROR;
185: end if;
186:
187:
188: PA_WORKPLAN_ATTR_PVT.CREATE_PROJ_WORKPLAN_ATTRS

Line 189: ( p_commit => FND_API.G_FALSE

185: end if;
186:
187:
188: PA_WORKPLAN_ATTR_PVT.CREATE_PROJ_WORKPLAN_ATTRS
189: ( p_commit => FND_API.G_FALSE
190: ,p_validate_only => p_validate_only
191: ,p_validation_level => p_validation_level
192: ,p_calling_module => p_calling_module
193: ,p_debug_mode => p_debug_mode

Line 221: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

217: ,x_return_status => l_return_status
218: ,x_msg_count => l_msg_count
219: ,x_msg_data => l_msg_data );
220:
221: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
222: x_msg_count := FND_MSG_PUB.count_msg;
223: if x_msg_count = 1 then
224: pa_interface_utils_pub.get_messages
225: (p_encoded => FND_API.G_TRUE,

Line 225: (p_encoded => FND_API.G_TRUE,

221: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
222: x_msg_count := FND_MSG_PUB.count_msg;
223: if x_msg_count = 1 then
224: pa_interface_utils_pub.get_messages
225: (p_encoded => FND_API.G_TRUE,
226: p_msg_index => 1,
227: p_msg_count => l_msg_count,
228: p_msg_data => l_msg_data,
229: p_data => l_data,

Line 233: raise FND_API.G_EXC_ERROR;

229: p_data => l_data,
230: p_msg_index_out => l_msg_index_out);
231: x_msg_data := l_data;
232: end if;
233: raise FND_API.G_EXC_ERROR;
234: end if;
235:
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237:

Line 236: x_return_status := FND_API.G_RET_STS_SUCCESS;

232: end if;
233: raise FND_API.G_EXC_ERROR;
234: end if;
235:
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237:
238: if p_commit = FND_API.G_TRUE then
239: commit work;
240: end if;

Line 238: if p_commit = FND_API.G_TRUE then

234: end if;
235:
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237:
238: if p_commit = FND_API.G_TRUE then
239: commit work;
240: end if;
241:
242: if (p_debug_mode = 'Y') then

Line 247: when FND_API.G_EXC_ERROR then

243: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Create_Proj_Workplan_Attrs END');
244: end if;
245:
246: EXCEPTION
247: when FND_API.G_EXC_ERROR then
248: if p_commit = FND_API.G_TRUE then
249: rollback to create_proj_workplan_attrs;
250: end if;
251: x_return_status := FND_API.G_RET_STS_ERROR;

Line 248: if p_commit = FND_API.G_TRUE then

244: end if;
245:
246: EXCEPTION
247: when FND_API.G_EXC_ERROR then
248: if p_commit = FND_API.G_TRUE then
249: rollback to create_proj_workplan_attrs;
250: end if;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 251: x_return_status := FND_API.G_RET_STS_ERROR;

247: when FND_API.G_EXC_ERROR then
248: if p_commit = FND_API.G_TRUE then
249: rollback to create_proj_workplan_attrs;
250: end if;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: when FND_API.G_EXC_UNEXPECTED_ERROR then
253: if p_commit = FND_API.G_TRUE then
254: rollback to create_proj_workplan_attrs;
255: end if;

Line 252: when FND_API.G_EXC_UNEXPECTED_ERROR then

248: if p_commit = FND_API.G_TRUE then
249: rollback to create_proj_workplan_attrs;
250: end if;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: when FND_API.G_EXC_UNEXPECTED_ERROR then
253: if p_commit = FND_API.G_TRUE then
254: rollback to create_proj_workplan_attrs;
255: end if;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 253: if p_commit = FND_API.G_TRUE then

249: rollback to create_proj_workplan_attrs;
250: end if;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: when FND_API.G_EXC_UNEXPECTED_ERROR then
253: if p_commit = FND_API.G_TRUE then
254: rollback to create_proj_workplan_attrs;
255: end if;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

Line 256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

252: when FND_API.G_EXC_UNEXPECTED_ERROR then
253: if p_commit = FND_API.G_TRUE then
254: rollback to create_proj_workplan_attrs;
255: end if;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
258: p_procedure_name => 'Create_Proj_Workplan_Attrs',
259: p_error_text => SUBSTRB(SQLERRM,1,240));
260: when OTHERS then

Line 261: if p_commit = FND_API.G_TRUE then

257: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
258: p_procedure_name => 'Create_Proj_Workplan_Attrs',
259: p_error_text => SUBSTRB(SQLERRM,1,240));
260: when OTHERS then
261: if p_commit = FND_API.G_TRUE then
262: rollback to create_proj_workplan_attrs;
263: end if;
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
265: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

Line 264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

260: when OTHERS then
261: if p_commit = FND_API.G_TRUE then
262: rollback to create_proj_workplan_attrs;
263: end if;
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
265: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
266: p_procedure_name => 'Create_Proj_Workplan_Attrs',
267: p_error_text => SUBSTRB(SQLERRM,1,240));
268: raise;

Line 277: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE

273: -- Type : Public
274: -- Pre-reqs : None.
275: -- Parameters :
276: -- p_api_version IN NUMBER Required Default = 1.0
277: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
278: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
279: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
280: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
281: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

Line 278: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

274: -- Pre-reqs : None.
275: -- Parameters :
276: -- p_api_version IN NUMBER Required Default = 1.0
277: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
278: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
279: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
280: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
281: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
282: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 279: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

275: -- Parameters :
276: -- p_api_version IN NUMBER Required Default = 1.0
277: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
278: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
279: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
280: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
281: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
282: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
283: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 280: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

276: -- p_api_version IN NUMBER Required Default = 1.0
277: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
278: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
279: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
280: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
281: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
282: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
283: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
284: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM

Line 283: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

279: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
280: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
281: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
282: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
283: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
284: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 284: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM

280: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
281: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
282: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
283: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
284: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM

281: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
282: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
283: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
284: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

282: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
283: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
284: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
290: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM

Line 287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

283: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
284: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
290: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
291: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

Line 288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM

284: -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
290: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
291: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 289: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

285: -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
290: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
291: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
293: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 290: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM

286: -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
290: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
291: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
293: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
294: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 291: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

287: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
290: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
291: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
293: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
294: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
295: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

Line 292: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

288: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
289: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
290: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
291: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
293: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
294: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
295: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
296: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

Line 293: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

289: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
290: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
291: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
293: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
294: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
295: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
296: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
297: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

Line 294: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

290: -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
291: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
293: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
294: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
295: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
296: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
297: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
298: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 295: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

291: -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
292: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
293: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
294: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
295: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
296: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
297: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
298: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
299: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 296: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

292: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
293: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
294: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
295: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
296: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
297: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
298: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
299: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
300: --bug 3325803: FP M

Line 297: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR

293: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
294: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
295: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
296: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
297: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
298: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
299: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
300: --bug 3325803: FP M
301: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 298: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM

294: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
295: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
296: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
297: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
298: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
299: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
300: --bug 3325803: FP M
301: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
302: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 299: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM

295: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
296: -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
297: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
298: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
299: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
300: --bug 3325803: FP M
301: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
302: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
303: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 301: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

297: -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
298: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
299: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
300: --bug 3325803: FP M
301: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
302: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
303: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
304: ---p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
305: --bug 3325803: FP M

Line 302: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

298: -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
299: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
300: --bug 3325803: FP M
301: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
302: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
303: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
304: ---p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
305: --bug 3325803: FP M
306: -- x_return_status OUT VARCHAR2 Required

Line 303: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

299: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
300: --bug 3325803: FP M
301: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
302: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
303: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
304: ---p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
305: --bug 3325803: FP M
306: -- x_return_status OUT VARCHAR2 Required
307: -- x_msg_count OUT NUMBER Required

Line 304: ---p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

300: --bug 3325803: FP M
301: -- p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
302: -- p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
303: -- p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
304: ---p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
305: --bug 3325803: FP M
306: -- x_return_status OUT VARCHAR2 Required
307: -- x_msg_count OUT NUMBER Required
308: -- x_msg_data OUT VARCHAR2 Optional

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

310:
311: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
312: (
313: p_api_version IN NUMBER := 1.0
314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
316: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
317: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
318: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 315: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

311: PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
312: (
313: p_api_version IN NUMBER := 1.0
314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
316: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
317: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
318: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
319: ,p_debug_mode IN VARCHAR2 := 'N'

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

312: (
313: p_api_version IN NUMBER := 1.0
314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
316: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
317: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
318: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
319: ,p_debug_mode IN VARCHAR2 := 'N'
320: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

313: p_api_version IN NUMBER := 1.0
314: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
315: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
316: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
317: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
318: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
319: ,p_debug_mode IN VARCHAR2 := 'N'
320: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
321: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

Line 320: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

316: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
317: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
318: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
319: ,p_debug_mode IN VARCHAR2 := 'N'
320: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
321: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
322: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
323: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
324: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

Line 321: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

317: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
318: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
319: ,p_debug_mode IN VARCHAR2 := 'N'
320: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
321: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
322: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
323: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
324: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
325: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM

Line 322: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

318: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
319: ,p_debug_mode IN VARCHAR2 := 'N'
320: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
321: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
322: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
323: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
324: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
325: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
326: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM

Line 323: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

319: ,p_debug_mode IN VARCHAR2 := 'N'
320: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
321: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
322: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
323: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
324: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
325: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
326: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
327: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 324: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

320: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
321: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
322: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
323: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
324: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
325: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
326: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
327: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
328: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

Line 325: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM

321: ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
322: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
323: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
324: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
325: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
326: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
327: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
328: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
329: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

Line 326: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM

322: ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
323: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
324: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
325: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
326: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
327: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
328: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
329: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
330: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM

Line 327: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR

323: ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
324: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
325: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
326: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
327: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
328: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
329: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
330: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
331: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 328: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */

324: ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
325: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
326: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
327: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
328: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
329: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
330: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
331: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
332: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM

Line 329: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

325: ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
326: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
327: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
328: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
329: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
330: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
331: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
332: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
333: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 330: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM

326: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
327: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
328: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
329: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
330: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
331: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
332: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
333: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
334: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

Line 331: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR

327: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
328: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
329: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
330: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
331: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
332: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
333: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
334: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
335: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

Line 332: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM

328: ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
329: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
330: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
331: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
332: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
333: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
334: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
335: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
336: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM

Line 333: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR

329: ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
330: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
331: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
332: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
333: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
334: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
335: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
336: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
337: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM

Line 334: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

330: ,p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
331: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
332: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
333: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
334: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
335: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
336: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
337: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
338: --bug 3325803: FP M

Line 335: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */

331: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
332: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
333: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
334: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
335: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
336: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
337: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
338: --bug 3325803: FP M
339: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 336: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM

332: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
333: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
334: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
335: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
336: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
337: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
338: --bug 3325803: FP M
339: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
340: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

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

333: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
334: ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
335: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
336: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
337: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
338: --bug 3325803: FP M
339: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
340: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
341: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 339: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

335: ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
336: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
337: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
338: --bug 3325803: FP M
339: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
340: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
341: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
342: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
343: --bug 3325803: FP M

Line 340: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

336: ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
337: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
338: --bug 3325803: FP M
339: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
340: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
341: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
342: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
343: --bug 3325803: FP M
344: --FP M: Workflow attributes

Line 341: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR

337: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
338: --bug 3325803: FP M
339: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
340: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
341: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
342: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
343: --bug 3325803: FP M
344: --FP M: Workflow attributes
345: -- gboomina Bug 8586393 - start

Line 342: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

338: --bug 3325803: FP M
339: ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
340: ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
341: ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
342: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
343: --bug 3325803: FP M
344: --FP M: Workflow attributes
345: -- gboomina Bug 8586393 - start
346: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 346: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

342: ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
343: --bug 3325803: FP M
344: --FP M: Workflow attributes
345: -- gboomina Bug 8586393 - start
346: ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
347: -- gboomina Bug 8586393 - end
348: ,p_enable_wf_flag IN VARCHAR2 := 'N'
349: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
350: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 386: if p_commit = FND_API.G_TRUE then

382: if (p_debug_mode = 'Y') then
383: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Proj_Workplan_Attrs BEGIN');
384: end if;
385:
386: if p_commit = FND_API.G_TRUE then
387: savepoint update_proj_workplan_attrs;
388: end if;
389:
390: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 390: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

386: if p_commit = FND_API.G_TRUE then
387: savepoint update_proj_workplan_attrs;
388: end if;
389:
390: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
391: raise FND_API.G_EXC_UNEXPECTED_ERROR;
392: end if;
393:
394: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then

Line 391: raise FND_API.G_EXC_UNEXPECTED_ERROR;

387: savepoint update_proj_workplan_attrs;
388: end if;
389:
390: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
391: raise FND_API.G_EXC_UNEXPECTED_ERROR;
392: end if;
393:
394: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
395: FND_MSG_PUB.initialize;

Line 394: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then

390: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
391: raise FND_API.G_EXC_UNEXPECTED_ERROR;
392: end if;
393:
394: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
395: FND_MSG_PUB.initialize;
396: end if;
397:
398: if (p_debug_mode = 'Y') then

Line 402: if ((p_approver_name <> FND_API.G_MISS_CHAR) AND (p_approver_name is not NULL)) OR

398: if (p_debug_mode = 'Y') then
399: pa_debug.debug('Performing ID validations and conversions...');
400: end if;
401:
402: if ((p_approver_name <> FND_API.G_MISS_CHAR) AND (p_approver_name is not NULL)) OR
403: ((p_approver_source_id <> FND_API.G_MISS_NUM) AND (p_approver_source_id is not NULL)) then
404: PA_WORKPLAN_ATTR_UTILS.CHECK_APPROVER_NAME_OR_ID
405: ( p_approver_source_id => p_approver_source_id
406: ,p_approver_source_type => p_approver_source_type

Line 403: ((p_approver_source_id <> FND_API.G_MISS_NUM) AND (p_approver_source_id is not NULL)) then

399: pa_debug.debug('Performing ID validations and conversions...');
400: end if;
401:
402: if ((p_approver_name <> FND_API.G_MISS_CHAR) AND (p_approver_name is not NULL)) OR
403: ((p_approver_source_id <> FND_API.G_MISS_NUM) AND (p_approver_source_id is not NULL)) then
404: PA_WORKPLAN_ATTR_UTILS.CHECK_APPROVER_NAME_OR_ID
405: ( p_approver_source_id => p_approver_source_id
406: ,p_approver_source_type => p_approver_source_type
407: ,p_approver_name => p_approver_name

Line 414: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

410: ,x_approver_source_type => l_approver_source_type
411: ,x_return_status => l_return_status
412: ,x_error_msg_code => l_error_msg_code);
413:
414: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
415: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
416: end if;
417: end if;
418:

Line 462: if ((p_lifecycle_name <> FND_API.G_MISS_CHAR) AND (p_lifecycle_name is not NULL)) OR

458: ,p_msg_name => 'PA_PS_AUTO_PUB_INVALID');
459: End If;
460: -- End of bug fix
461:
462: if ((p_lifecycle_name <> FND_API.G_MISS_CHAR) AND (p_lifecycle_name is not NULL)) OR
463: ((p_lifecycle_id <> FND_API.G_MISS_NUM) AND (p_lifecycle_id is not NULL)) then
464:
465: PA_WORKPLAN_ATTR_UTILS.CHECK_LIFECYCLE_NAME_OR_ID
466: ( p_lifecycle_id => p_lifecycle_id

Line 463: ((p_lifecycle_id <> FND_API.G_MISS_NUM) AND (p_lifecycle_id is not NULL)) then

459: End If;
460: -- End of bug fix
461:
462: if ((p_lifecycle_name <> FND_API.G_MISS_CHAR) AND (p_lifecycle_name is not NULL)) OR
463: ((p_lifecycle_id <> FND_API.G_MISS_NUM) AND (p_lifecycle_id is not NULL)) then
464:
465: PA_WORKPLAN_ATTR_UTILS.CHECK_LIFECYCLE_NAME_OR_ID
466: ( p_lifecycle_id => p_lifecycle_id
467: ,p_lifecycle_name => p_lifecycle_name

Line 473: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

469: ,x_lifecycle_id => l_lifecycle_id
470: ,x_return_status => l_return_status
471: ,x_error_msg_code => l_error_msg_code);
472:
473: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
474: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
475: end if;
476: end if;
477:

Line 478: if ((p_current_lifecycle_phase_id <> FND_API.G_MISS_NUM) AND (p_current_lifecycle_phase_id is not NULL)) OR

474: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
475: end if;
476: end if;
477:
478: if ((p_current_lifecycle_phase_id <> FND_API.G_MISS_NUM) AND (p_current_lifecycle_phase_id is not NULL)) OR
479: ((p_current_lifecycle_phase <> FND_API.G_MISS_CHAR) AND (p_current_lifecycle_phase is not NULL)) then
480:
481: PA_WORKPLAN_ATTR_UTILS.CHECK_LIFECYCLE_PHASE_NAME_ID
482: ( p_lifecycle_id => l_lifecycle_id

Line 479: ((p_current_lifecycle_phase <> FND_API.G_MISS_CHAR) AND (p_current_lifecycle_phase is not NULL)) then

475: end if;
476: end if;
477:
478: if ((p_current_lifecycle_phase_id <> FND_API.G_MISS_NUM) AND (p_current_lifecycle_phase_id is not NULL)) OR
479: ((p_current_lifecycle_phase <> FND_API.G_MISS_CHAR) AND (p_current_lifecycle_phase is not NULL)) then
480:
481: PA_WORKPLAN_ATTR_UTILS.CHECK_LIFECYCLE_PHASE_NAME_ID
482: ( p_lifecycle_id => l_lifecycle_id
483: ,p_current_lifecycle_phase_id => p_current_lifecycle_phase_id

Line 490: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

486: ,x_current_lifecycle_phase_id => l_current_lifecycle_phase_id
487: ,x_return_status => l_return_status
488: ,x_error_msg_code => l_error_msg_code);
489:
490: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
491: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA', p_msg_name => l_error_msg_code);
492: end if;
493: end if;
494:

Line 500: (p_encoded => FND_API.G_TRUE,

496: if l_msg_count > 0 then
497: x_msg_count := l_msg_count;
498: if x_msg_count = 1 then
499: pa_interface_utils_pub.get_messages
500: (p_encoded => FND_API.G_TRUE,
501: p_msg_index => 1,
502: p_msg_count => l_msg_count,
503: p_msg_data => l_msg_data,
504: p_data => l_data,

Line 508: raise FND_API.G_EXC_ERROR;

504: p_data => l_data,
505: p_msg_index_out => l_msg_index_out);
506: x_msg_data := l_data;
507: end if;
508: raise FND_API.G_EXC_ERROR;
509: end if;
510:
511: PA_WORKPLAN_ATTR_PVT.UPDATE_PROJ_WORKPLAN_ATTRS
512: ( p_commit => FND_API.G_FALSE

Line 512: ( p_commit => FND_API.G_FALSE

508: raise FND_API.G_EXC_ERROR;
509: end if;
510:
511: PA_WORKPLAN_ATTR_PVT.UPDATE_PROJ_WORKPLAN_ATTRS
512: ( p_commit => FND_API.G_FALSE
513: ,p_validate_only => p_validate_only
514: ,p_validation_level => p_validation_level
515: ,p_calling_module => p_calling_module
516: ,p_debug_mode => p_debug_mode

Line 551: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

547: set enable_wf_flag = p_enable_wf_flag
548: where proj_element_id = p_proj_element_id ;
549: --FP M:3491609:Project Execution Workflow
550:
551: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
552: x_msg_count := FND_MSG_PUB.count_msg;
553: if x_msg_count = 1 then
554: pa_interface_utils_pub.get_messages
555: (p_encoded => FND_API.G_TRUE,

Line 555: (p_encoded => FND_API.G_TRUE,

551: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
552: x_msg_count := FND_MSG_PUB.count_msg;
553: if x_msg_count = 1 then
554: pa_interface_utils_pub.get_messages
555: (p_encoded => FND_API.G_TRUE,
556: p_msg_index => 1,
557: p_msg_count => l_msg_count,
558: p_msg_data => l_msg_data,
559: p_data => l_data,

Line 563: raise FND_API.G_EXC_ERROR;

559: p_data => l_data,
560: p_msg_index_out => l_msg_index_out);
561: x_msg_data := l_data;
562: end if;
563: raise FND_API.G_EXC_ERROR;
564: end if;
565:
566: x_return_status := FND_API.G_RET_STS_SUCCESS;
567:

Line 566: x_return_status := FND_API.G_RET_STS_SUCCESS;

562: end if;
563: raise FND_API.G_EXC_ERROR;
564: end if;
565:
566: x_return_status := FND_API.G_RET_STS_SUCCESS;
567:
568: if p_commit = FND_API.G_TRUE then
569: commit work;
570: end if;

Line 568: if p_commit = FND_API.G_TRUE then

564: end if;
565:
566: x_return_status := FND_API.G_RET_STS_SUCCESS;
567:
568: if p_commit = FND_API.G_TRUE then
569: commit work;
570: end if;
571:
572: if (p_debug_mode = 'Y') then

Line 577: when FND_API.G_EXC_ERROR then

573: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Proj_Workplan_Attrs END');
574: end if;
575:
576: EXCEPTION
577: when FND_API.G_EXC_ERROR then
578: if p_commit = FND_API.G_TRUE then
579: rollback to update_proj_workplan_attrs;
580: end if;
581: x_return_status := FND_API.G_RET_STS_ERROR;

Line 578: if p_commit = FND_API.G_TRUE then

574: end if;
575:
576: EXCEPTION
577: when FND_API.G_EXC_ERROR then
578: if p_commit = FND_API.G_TRUE then
579: rollback to update_proj_workplan_attrs;
580: end if;
581: x_return_status := FND_API.G_RET_STS_ERROR;
582: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 581: x_return_status := FND_API.G_RET_STS_ERROR;

577: when FND_API.G_EXC_ERROR then
578: if p_commit = FND_API.G_TRUE then
579: rollback to update_proj_workplan_attrs;
580: end if;
581: x_return_status := FND_API.G_RET_STS_ERROR;
582: when FND_API.G_EXC_UNEXPECTED_ERROR then
583: if p_commit = FND_API.G_TRUE then
584: rollback to update_proj_workplan_attrs;
585: end if;

Line 582: when FND_API.G_EXC_UNEXPECTED_ERROR then

578: if p_commit = FND_API.G_TRUE then
579: rollback to update_proj_workplan_attrs;
580: end if;
581: x_return_status := FND_API.G_RET_STS_ERROR;
582: when FND_API.G_EXC_UNEXPECTED_ERROR then
583: if p_commit = FND_API.G_TRUE then
584: rollback to update_proj_workplan_attrs;
585: end if;
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 583: if p_commit = FND_API.G_TRUE then

579: rollback to update_proj_workplan_attrs;
580: end if;
581: x_return_status := FND_API.G_RET_STS_ERROR;
582: when FND_API.G_EXC_UNEXPECTED_ERROR then
583: if p_commit = FND_API.G_TRUE then
584: rollback to update_proj_workplan_attrs;
585: end if;
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
587: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

Line 586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

582: when FND_API.G_EXC_UNEXPECTED_ERROR then
583: if p_commit = FND_API.G_TRUE then
584: rollback to update_proj_workplan_attrs;
585: end if;
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
587: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
588: p_procedure_name => 'Update_Proj_Workplan_Attrs',
589: p_error_text => SUBSTRB(SQLERRM,1,240));
590: when OTHERS then

Line 591: if p_commit = FND_API.G_TRUE then

587: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
588: p_procedure_name => 'Update_Proj_Workplan_Attrs',
589: p_error_text => SUBSTRB(SQLERRM,1,240));
590: when OTHERS then
591: if p_commit = FND_API.G_TRUE then
592: rollback to update_proj_workplan_attrs;
593: end if;
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

Line 594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

590: when OTHERS then
591: if p_commit = FND_API.G_TRUE then
592: rollback to update_proj_workplan_attrs;
593: end if;
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
596: p_procedure_name => 'Update_Proj_Workplan_Attrs',
597: p_error_text => SUBSTRB(SQLERRM,1,240));
598: raise;

Line 606: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE

602: -- Type : Public
603: -- Pre-reqs : None.
604: -- Parameters :
605: -- p_api_version IN NUMBER Required Default = 1.0
606: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
607: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
608: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
609: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
610: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

Line 607: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

603: -- Pre-reqs : None.
604: -- Parameters :
605: -- p_api_version IN NUMBER Required Default = 1.0
606: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
607: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
608: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
609: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
610: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
611: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 608: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

604: -- Parameters :
605: -- p_api_version IN NUMBER Required Default = 1.0
606: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
607: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
608: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
609: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
610: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
611: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
612: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 609: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

605: -- p_api_version IN NUMBER Required Default = 1.0
606: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
607: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
608: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
609: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
610: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
611: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
612: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
613: -- p_proj_element_id IN NUMBER Required

Line 612: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

608: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
609: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
610: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
611: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
612: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
613: -- p_proj_element_id IN NUMBER Required
614: -- p_structure_name IN VARCHAR2 Required
615: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
616: -- x_return_status OUT VARCHAR2 Required

Line 615: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM

611: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
612: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
613: -- p_proj_element_id IN NUMBER Required
614: -- p_structure_name IN VARCHAR2 Required
615: -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
616: -- x_return_status OUT VARCHAR2 Required
617: -- x_msg_count OUT NUMBER Required
618: -- x_msg_data OUT VARCHAR2 Optional
619:

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

618: -- x_msg_data OUT VARCHAR2 Optional
619:
620: PROCEDURE UPDATE_STRUCTURE_NAME
621: ( p_api_version IN NUMBER := 1.0
622: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
623: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
624: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
625: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
626: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 623: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

619:
620: PROCEDURE UPDATE_STRUCTURE_NAME
621: ( p_api_version IN NUMBER := 1.0
622: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
623: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
624: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
625: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
626: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
627: ,p_debug_mode IN VARCHAR2 := 'N'

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

620: PROCEDURE UPDATE_STRUCTURE_NAME
621: ( p_api_version IN NUMBER := 1.0
622: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
623: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
624: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
625: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
626: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
627: ,p_debug_mode IN VARCHAR2 := 'N'
628: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

621: ( p_api_version IN NUMBER := 1.0
622: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
623: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
624: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
625: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
626: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
627: ,p_debug_mode IN VARCHAR2 := 'N'
628: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
629: ,p_proj_element_id IN NUMBER

Line 628: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

624: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
625: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
626: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
627: ,p_debug_mode IN VARCHAR2 := 'N'
628: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
629: ,p_proj_element_id IN NUMBER
630: ,p_structure_name IN VARCHAR2
631: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
632: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

627: ,p_debug_mode IN VARCHAR2 := 'N'
628: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
629: ,p_proj_element_id IN NUMBER
630: ,p_structure_name IN VARCHAR2
631: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
632: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
633: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
634: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
635: )

Line 653: if p_commit = FND_API.G_TRUE then

649: if (p_debug_mode = 'Y') then
650: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Structure_Name BEGIN');
651: end if;
652:
653: if p_commit = FND_API.G_TRUE then
654: savepoint update_structure_name;
655: end if;
656:
657: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 657: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

653: if p_commit = FND_API.G_TRUE then
654: savepoint update_structure_name;
655: end if;
656:
657: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
658: raise FND_API.G_EXC_UNEXPECTED_ERROR;
659: end if;
660:
661: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then

Line 658: raise FND_API.G_EXC_UNEXPECTED_ERROR;

654: savepoint update_structure_name;
655: end if;
656:
657: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
658: raise FND_API.G_EXC_UNEXPECTED_ERROR;
659: end if;
660:
661: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
662: FND_MSG_PUB.initialize;

Line 661: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then

657: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
658: raise FND_API.G_EXC_UNEXPECTED_ERROR;
659: end if;
660:
661: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
662: FND_MSG_PUB.initialize;
663: end if;
664:
665: if (p_debug_mode = 'Y') then

Line 679: (p_encoded => FND_API.G_TRUE,

675: if l_msg_count > 0 then
676: x_msg_count := l_msg_count;
677: if x_msg_count = 1 then
678: pa_interface_utils_pub.get_messages
679: (p_encoded => FND_API.G_TRUE,
680: p_msg_index => 1,
681: p_msg_count => l_msg_count,
682: p_msg_data => l_msg_data,
683: p_data => l_data,

Line 687: raise FND_API.G_EXC_ERROR;

683: p_data => l_data,
684: p_msg_index_out => l_msg_index_out);
685: x_msg_data := l_data;
686: end if;
687: raise FND_API.G_EXC_ERROR;
688: end if;
689:
690: PA_WORKPLAN_ATTR_PVT.UPDATE_STRUCTURE_NAME
691: ( p_commit => FND_API.G_FALSE

Line 691: ( p_commit => FND_API.G_FALSE

687: raise FND_API.G_EXC_ERROR;
688: end if;
689:
690: PA_WORKPLAN_ATTR_PVT.UPDATE_STRUCTURE_NAME
691: ( p_commit => FND_API.G_FALSE
692: ,p_validate_only => p_validate_only
693: ,p_validation_level => p_validation_level
694: ,p_calling_module => p_calling_module
695: ,p_debug_mode => p_debug_mode

Line 704: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

700: ,x_return_status => l_return_status
701: ,x_msg_count => l_msg_count
702: ,x_msg_data => l_msg_data );
703:
704: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
705: x_msg_count := FND_MSG_PUB.count_msg;
706: if x_msg_count = 1 then
707: pa_interface_utils_pub.get_messages
708: (p_encoded => FND_API.G_TRUE,

Line 708: (p_encoded => FND_API.G_TRUE,

704: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
705: x_msg_count := FND_MSG_PUB.count_msg;
706: if x_msg_count = 1 then
707: pa_interface_utils_pub.get_messages
708: (p_encoded => FND_API.G_TRUE,
709: p_msg_index => 1,
710: p_msg_count => l_msg_count,
711: p_msg_data => l_msg_data,
712: p_data => l_data,

Line 716: raise FND_API.G_EXC_ERROR;

712: p_data => l_data,
713: p_msg_index_out => l_msg_index_out);
714: x_msg_data := l_data;
715: end if;
716: raise FND_API.G_EXC_ERROR;
717: end if;
718:
719: x_return_status := FND_API.G_RET_STS_SUCCESS;
720:

Line 719: x_return_status := FND_API.G_RET_STS_SUCCESS;

715: end if;
716: raise FND_API.G_EXC_ERROR;
717: end if;
718:
719: x_return_status := FND_API.G_RET_STS_SUCCESS;
720:
721: if p_commit = FND_API.G_TRUE then
722: commit work;
723: end if;

Line 721: if p_commit = FND_API.G_TRUE then

717: end if;
718:
719: x_return_status := FND_API.G_RET_STS_SUCCESS;
720:
721: if p_commit = FND_API.G_TRUE then
722: commit work;
723: end if;
724:
725: if (p_debug_mode = 'Y') then

Line 730: when FND_API.G_EXC_ERROR then

726: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Update_Structure_Name END');
727: end if;
728:
729: EXCEPTION
730: when FND_API.G_EXC_ERROR then
731: if p_commit = FND_API.G_TRUE then
732: rollback to update_structure_name;
733: end if;
734: x_return_status := FND_API.G_RET_STS_ERROR;

Line 731: if p_commit = FND_API.G_TRUE then

727: end if;
728:
729: EXCEPTION
730: when FND_API.G_EXC_ERROR then
731: if p_commit = FND_API.G_TRUE then
732: rollback to update_structure_name;
733: end if;
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 734: x_return_status := FND_API.G_RET_STS_ERROR;

730: when FND_API.G_EXC_ERROR then
731: if p_commit = FND_API.G_TRUE then
732: rollback to update_structure_name;
733: end if;
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: when FND_API.G_EXC_UNEXPECTED_ERROR then
736: if p_commit = FND_API.G_TRUE then
737: rollback to update_structure_name;
738: end if;

Line 735: when FND_API.G_EXC_UNEXPECTED_ERROR then

731: if p_commit = FND_API.G_TRUE then
732: rollback to update_structure_name;
733: end if;
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: when FND_API.G_EXC_UNEXPECTED_ERROR then
736: if p_commit = FND_API.G_TRUE then
737: rollback to update_structure_name;
738: end if;
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 736: if p_commit = FND_API.G_TRUE then

732: rollback to update_structure_name;
733: end if;
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: when FND_API.G_EXC_UNEXPECTED_ERROR then
736: if p_commit = FND_API.G_TRUE then
737: rollback to update_structure_name;
738: end if;
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

Line 739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

735: when FND_API.G_EXC_UNEXPECTED_ERROR then
736: if p_commit = FND_API.G_TRUE then
737: rollback to update_structure_name;
738: end if;
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
741: p_procedure_name => 'Update_Structure_Name',
742: p_error_text => SUBSTRB(SQLERRM,1,240));
743: when OTHERS then

Line 744: if p_commit = FND_API.G_TRUE then

740: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
741: p_procedure_name => 'Update_Structure_Name',
742: p_error_text => SUBSTRB(SQLERRM,1,240));
743: when OTHERS then
744: if p_commit = FND_API.G_TRUE then
745: rollback to update_structure_name;
746: end if;
747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
748: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

Line 747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

743: when OTHERS then
744: if p_commit = FND_API.G_TRUE then
745: rollback to update_structure_name;
746: end if;
747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
748: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
749: p_procedure_name => 'Update_Structure_Name',
750: p_error_text => SUBSTRB(SQLERRM,1,240));
751: raise;

Line 760: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE

756: -- Type : Public
757: -- Pre-reqs : None.
758: -- Parameters :
759: -- p_api_version IN NUMBER Required Default = 1.0
760: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
761: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
762: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
763: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
764: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'

Line 761: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE

757: -- Pre-reqs : None.
758: -- Parameters :
759: -- p_api_version IN NUMBER Required Default = 1.0
760: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
761: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
762: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
763: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
764: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
765: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'

Line 762: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE

758: -- Parameters :
759: -- p_api_version IN NUMBER Required Default = 1.0
760: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
761: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
762: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
763: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
764: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
765: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
766: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

Line 763: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

759: -- p_api_version IN NUMBER Required Default = 1.0
760: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_TRUE
761: -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
762: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
763: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
764: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
765: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
766: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
767: -- p_project_id IN NUMBER Required

Line 766: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM

762: -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
763: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
764: -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
765: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
766: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
767: -- p_project_id IN NUMBER Required
768: -- p_proj_element_id IN NUMBER Required
769: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
770: -- x_return_status OUT VARCHAR2 Required

Line 769: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM

765: -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
766: -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
767: -- p_project_id IN NUMBER Required
768: -- p_proj_element_id IN NUMBER Required
769: -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
770: -- x_return_status OUT VARCHAR2 Required
771: -- x_msg_count OUT NUMBER Required
772: -- x_msg_data OUT VARCHAR2 Optional
773:

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

772: -- x_msg_data OUT VARCHAR2 Optional
773:
774: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
775: ( p_api_version IN NUMBER := 1.0
776: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
777: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
778: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
779: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
780: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 777: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

773:
774: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
775: ( p_api_version IN NUMBER := 1.0
776: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
777: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
778: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
779: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
780: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
781: ,p_debug_mode IN VARCHAR2 := 'N'

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

774: PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
775: ( p_api_version IN NUMBER := 1.0
776: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
777: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
778: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
779: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
780: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
781: ,p_debug_mode IN VARCHAR2 := 'N'
782: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

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

775: ( p_api_version IN NUMBER := 1.0
776: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
777: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
778: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
779: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
780: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
781: ,p_debug_mode IN VARCHAR2 := 'N'
782: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
783: ,p_project_id IN NUMBER

Line 782: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM

778: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
779: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
780: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
781: ,p_debug_mode IN VARCHAR2 := 'N'
782: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
783: ,p_project_id IN NUMBER
784: ,p_proj_element_id IN NUMBER
785: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
786: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

781: ,p_debug_mode IN VARCHAR2 := 'N'
782: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
783: ,p_project_id IN NUMBER
784: ,p_proj_element_id IN NUMBER
785: ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
786: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
787: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
788: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
789: )

Line 806: if p_commit = FND_API.G_TRUE then

802: if (p_debug_mode = 'Y') then
803: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Delete_Proj_Workplan_Attrs BEGIN');
804: end if;
805:
806: if p_commit = FND_API.G_TRUE then
807: savepoint delete_proj_workplan_attrs;
808: end if;
809:
810: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

Line 810: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then

806: if p_commit = FND_API.G_TRUE then
807: savepoint delete_proj_workplan_attrs;
808: end if;
809:
810: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
811: raise FND_API.G_EXC_UNEXPECTED_ERROR;
812: end if;
813:
814: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then

Line 811: raise FND_API.G_EXC_UNEXPECTED_ERROR;

807: savepoint delete_proj_workplan_attrs;
808: end if;
809:
810: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
811: raise FND_API.G_EXC_UNEXPECTED_ERROR;
812: end if;
813:
814: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
815: FND_MSG_PUB.initialize;

Line 814: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then

810: if not FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version, l_api_name, g_pkg_name) then
811: raise FND_API.G_EXC_UNEXPECTED_ERROR;
812: end if;
813:
814: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
815: FND_MSG_PUB.initialize;
816: end if;
817:
818: PA_WORKPLAN_ATTR_PVT.DELETE_PROJ_WORKPLAN_ATTRS

Line 819: ( p_commit => FND_API.G_FALSE

815: FND_MSG_PUB.initialize;
816: end if;
817:
818: PA_WORKPLAN_ATTR_PVT.DELETE_PROJ_WORKPLAN_ATTRS
819: ( p_commit => FND_API.G_FALSE
820: ,p_validate_only => p_validate_only
821: ,p_validation_level => p_validation_level
822: ,p_calling_module => p_calling_module
823: ,p_debug_mode => p_debug_mode

Line 832: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

828: ,x_return_status => l_return_status
829: ,x_msg_count => l_msg_count
830: ,x_msg_data => l_msg_data);
831:
832: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
833: x_msg_count := FND_MSG_PUB.count_msg;
834: if x_msg_count = 1 then
835: pa_interface_utils_pub.get_messages
836: (p_encoded => FND_API.G_TRUE,

Line 836: (p_encoded => FND_API.G_TRUE,

832: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
833: x_msg_count := FND_MSG_PUB.count_msg;
834: if x_msg_count = 1 then
835: pa_interface_utils_pub.get_messages
836: (p_encoded => FND_API.G_TRUE,
837: p_msg_index => 1,
838: p_msg_count => l_msg_count,
839: p_msg_data => l_msg_data,
840: p_data => l_data,

Line 844: raise FND_API.G_EXC_ERROR;

840: p_data => l_data,
841: p_msg_index_out => l_msg_index_out);
842: x_msg_data := l_data;
843: end if;
844: raise FND_API.G_EXC_ERROR;
845: end if;
846:
847: x_return_status := FND_API.G_RET_STS_SUCCESS;
848:

Line 847: x_return_status := FND_API.G_RET_STS_SUCCESS;

843: end if;
844: raise FND_API.G_EXC_ERROR;
845: end if;
846:
847: x_return_status := FND_API.G_RET_STS_SUCCESS;
848:
849: if p_commit = FND_API.G_TRUE then
850: commit work;
851: end if;

Line 849: if p_commit = FND_API.G_TRUE then

845: end if;
846:
847: x_return_status := FND_API.G_RET_STS_SUCCESS;
848:
849: if p_commit = FND_API.G_TRUE then
850: commit work;
851: end if;
852:
853: if (p_debug_mode = 'Y') then

Line 858: when FND_API.G_EXC_ERROR then

854: pa_debug.debug('PA_WORKPLAN_ATTR_PUB.Delete_Proj_Workplan_Attrs END');
855: end if;
856:
857: EXCEPTION
858: when FND_API.G_EXC_ERROR then
859: if p_commit = FND_API.G_TRUE then
860: rollback to delete_proj_workplan_attrs;
861: end if;
862: x_return_status := FND_API.G_RET_STS_ERROR;

Line 859: if p_commit = FND_API.G_TRUE then

855: end if;
856:
857: EXCEPTION
858: when FND_API.G_EXC_ERROR then
859: if p_commit = FND_API.G_TRUE then
860: rollback to delete_proj_workplan_attrs;
861: end if;
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 862: x_return_status := FND_API.G_RET_STS_ERROR;

858: when FND_API.G_EXC_ERROR then
859: if p_commit = FND_API.G_TRUE then
860: rollback to delete_proj_workplan_attrs;
861: end if;
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: when FND_API.G_EXC_UNEXPECTED_ERROR then
864: if p_commit = FND_API.G_TRUE then
865: rollback to delete_proj_workplan_attrs;
866: end if;

Line 863: when FND_API.G_EXC_UNEXPECTED_ERROR then

859: if p_commit = FND_API.G_TRUE then
860: rollback to delete_proj_workplan_attrs;
861: end if;
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: when FND_API.G_EXC_UNEXPECTED_ERROR then
864: if p_commit = FND_API.G_TRUE then
865: rollback to delete_proj_workplan_attrs;
866: end if;
867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 864: if p_commit = FND_API.G_TRUE then

860: rollback to delete_proj_workplan_attrs;
861: end if;
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: when FND_API.G_EXC_UNEXPECTED_ERROR then
864: if p_commit = FND_API.G_TRUE then
865: rollback to delete_proj_workplan_attrs;
866: end if;
867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
868: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

Line 867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

863: when FND_API.G_EXC_UNEXPECTED_ERROR then
864: if p_commit = FND_API.G_TRUE then
865: rollback to delete_proj_workplan_attrs;
866: end if;
867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
868: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
869: p_procedure_name => 'Delete_Proj_Workplan_Attrs',
870: p_error_text => SUBSTRB(SQLERRM,1,240));
871: when OTHERS then

Line 872: if p_commit = FND_API.G_TRUE then

868: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
869: p_procedure_name => 'Delete_Proj_Workplan_Attrs',
870: p_error_text => SUBSTRB(SQLERRM,1,240));
871: when OTHERS then
872: if p_commit = FND_API.G_TRUE then
873: rollback to delete_proj_workplan_attrs;
874: end if;
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',

Line 875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

871: when OTHERS then
872: if p_commit = FND_API.G_TRUE then
873: rollback to delete_proj_workplan_attrs;
874: end if;
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_WORKPLAN_ATTR_PUB',
877: p_procedure_name => 'Delete_Proj_Workplan_Attrs',
878: p_error_text => SUBSTRB(SQLERRM,1,240));
879: raise;