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

Line 15: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,

11: -- 11-JUL-2000 R. Krishnamurthy Created
12: --
13:
14: PROCEDURE Add_competence_element
15: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
16: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
19: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

Line 16: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,

12: --
13:
14: PROCEDURE Add_competence_element
15: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
16: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
19: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
20: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

Line 17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,

13:
14: PROCEDURE Add_competence_element
15: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
16: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
19: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
20: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

Line 18: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,

14: PROCEDURE Add_competence_element
15: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
16: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
19: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
20: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,

Line 19: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

15: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
16: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
19: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
20: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 20: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

16: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
19: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
20: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 21: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
19: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
20: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,

18: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
19: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
20: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: x_element_rowid OUT NOCOPY ROWID, --File.Sql.39 bug 4440895

Line 23: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

19: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
20: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: x_element_rowid OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
27: x_element_id OUT NOCOPY per_competence_elements.competence_element_id%TYPE, --File.Sql.39 bug 4440895

Line 24: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

20: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
21: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: x_element_rowid OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
27: x_element_id OUT NOCOPY per_competence_elements.competence_element_id%TYPE, --File.Sql.39 bug 4440895
28: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 25: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

21: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
22: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: x_element_rowid OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
27: x_element_id OUT NOCOPY per_competence_elements.competence_element_id%TYPE, --File.Sql.39 bug 4440895
28: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
29: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 47: x_return_status := FND_API.G_RET_STS_SUCCESS;

43:
44: BEGIN
45: pa_debug.init_err_stack ('pa_competence_pub.add_competence_element');
46: SAVEPOINT COMPETENCE_PUB_ADD_COMP_ELE;
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48:
49: -- Initialize the PL/SQL message stack
50: pa_competence_pvt.g_noof_errors := 0;
51: IF p_init_msg_list = FND_API.G_TRUE THEN

Line 51: IF p_init_msg_list = FND_API.G_TRUE THEN

47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48:
49: -- Initialize the PL/SQL message stack
50: pa_competence_pvt.g_noof_errors := 0;
51: IF p_init_msg_list = FND_API.G_TRUE THEN
52: fnd_msg_pub.initialize;
53: END IF;
54:
55: -- Do the standard public api checks

Line 72: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

68: -- If there are errors at this stage, there is no point
69: -- in proceeding further since the competence id or rating level
70: -- values are invalid
71:
72: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
73: x_return_status:= FND_API.G_RET_STS_ERROR;
74: IF pa_competence_pvt.g_noof_errors = 1 THEN
75: pa_interface_utils_pub.get_messages
76: (p_encoded => FND_API.G_TRUE,

Line 73: x_return_status:= FND_API.G_RET_STS_ERROR;

69: -- in proceeding further since the competence id or rating level
70: -- values are invalid
71:
72: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
73: x_return_status:= FND_API.G_RET_STS_ERROR;
74: IF pa_competence_pvt.g_noof_errors = 1 THEN
75: pa_interface_utils_pub.get_messages
76: (p_encoded => FND_API.G_TRUE,
77: p_msg_index => 1,

Line 76: (p_encoded => FND_API.G_TRUE,

72: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
73: x_return_status:= FND_API.G_RET_STS_ERROR;
74: IF pa_competence_pvt.g_noof_errors = 1 THEN
75: pa_interface_utils_pub.get_messages
76: (p_encoded => FND_API.G_TRUE,
77: p_msg_index => 1,
78: p_msg_count => x_msg_count ,
79: p_msg_data => l_msg_data ,
80: p_data => l_data,

Line 120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

116: x_element_rowid => x_element_rowid,
117: x_element_id => x_element_id,
118: x_return_status => l_return_status );
119:
120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
121: x_return_status:= FND_API.G_RET_STS_ERROR;
122:
123: IF pa_competence_pvt.g_noof_errors = 1 THEN
124: pa_interface_utils_pub.get_messages

Line 121: x_return_status:= FND_API.G_RET_STS_ERROR;

117: x_element_id => x_element_id,
118: x_return_status => l_return_status );
119:
120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
121: x_return_status:= FND_API.G_RET_STS_ERROR;
122:
123: IF pa_competence_pvt.g_noof_errors = 1 THEN
124: pa_interface_utils_pub.get_messages
125: (p_encoded => FND_API.G_TRUE,

Line 125: (p_encoded => FND_API.G_TRUE,

121: x_return_status:= FND_API.G_RET_STS_ERROR;
122:
123: IF pa_competence_pvt.g_noof_errors = 1 THEN
124: pa_interface_utils_pub.get_messages
125: (p_encoded => FND_API.G_TRUE,
126: p_msg_index => 1,
127: p_msg_count => x_msg_count ,
128: p_msg_data => l_msg_data ,
129: p_data => l_data,

Line 140: x_return_status:= FND_API.G_RET_STS_SUCCESS;

136:
137: pa_debug.reset_err_stack;
138: RETURN;
139: ELSE
140: x_return_status:= FND_API.G_RET_STS_SUCCESS;
141: END IF;
142:
143: IF p_commit = FND_API.G_TRUE THEN
144: COMMIT;

Line 143: IF p_commit = FND_API.G_TRUE THEN

139: ELSE
140: x_return_status:= FND_API.G_RET_STS_SUCCESS;
141: END IF;
142:
143: IF p_commit = FND_API.G_TRUE THEN
144: COMMIT;
145: END IF;
146:
147: EXCEPTION

Line 150: IF p_commit = FND_API.G_TRUE THEN

146:
147: EXCEPTION
148: WHEN OTHERS THEN
149:
150: IF p_commit = FND_API.G_TRUE THEN
151: ROLLBACK TO COMPETENCE_PUB_ADD_COMP_ELE;
152: END IF;
153:
154: fnd_msg_pub.add_exc_msg

Line 162: (p_encoded => FND_API.G_TRUE,

158: x_msg_count := 1;
159:
160: IF x_msg_count = 1 THEN
161: pa_interface_utils_pub.get_messages
162: (p_encoded => FND_API.G_TRUE,
163: p_msg_index => 1,
164: p_msg_count => x_msg_count ,
165: p_msg_data => l_msg_data ,
166: p_data => l_data,

Line 172: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

168:
169: x_msg_data := l_data;
170: END IF;
171:
172: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
173:
174: -- RESET the other OUT PARAMS also : 4537865
175:
176: x_element_rowid := NULL ;

Line 183: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,

179: END Add_Competence_Element;
180:
181:
182: PROCEDURE Update_competence_element
183: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
184: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
185: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
186: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
187: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

Line 184: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,

180:
181:
182: PROCEDURE Update_competence_element
183: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
184: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
185: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
186: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
187: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
188: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,

Line 185: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,

181:
182: PROCEDURE Update_competence_element
183: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
184: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
185: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
186: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
187: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
188: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
189: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

Line 186: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,

182: PROCEDURE Update_competence_element
183: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
184: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
185: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
186: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
187: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
188: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
189: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
190: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

Line 187: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

183: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
184: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
185: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
186: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
187: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
188: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
189: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
190: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
191: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

Line 188: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,

184: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
185: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
186: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
187: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
188: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
189: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
190: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
191: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
192: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,

Line 189: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

185: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
186: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
187: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
188: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
189: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
190: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
191: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
192: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 190: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

186: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
187: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
188: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
189: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
190: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
191: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
192: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 191: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

187: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
188: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
189: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
190: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
191: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
192: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 192: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,

188: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
189: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
190: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
191: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
192: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_object_version_number IN NUMBER,

Line 193: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

189: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
190: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
191: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
192: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_object_version_number IN NUMBER,
197: x_object_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 194: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

190: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
191: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
192: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_object_version_number IN NUMBER,
197: x_object_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
198: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 195: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

191: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
192: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_object_version_number IN NUMBER,
197: x_object_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
198: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
199: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 215: x_return_status := FND_API.G_RET_STS_SUCCESS;

211: l_element_id NUMBER := null;
212: BEGIN
213: pa_debug.init_err_stack ('pa_competence_pub.update_competence_element');
214: SAVEPOINT COMPETENCE_PUB_UPD_COMP_ELE;
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216: -- Initialize the PL/SQL message stack
217: pa_competence_pvt.g_noof_errors := 0;
218: IF p_init_msg_list = FND_API.G_TRUE THEN
219: fnd_msg_pub.initialize;

Line 218: IF p_init_msg_list = FND_API.G_TRUE THEN

214: SAVEPOINT COMPETENCE_PUB_UPD_COMP_ELE;
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216: -- Initialize the PL/SQL message stack
217: pa_competence_pvt.g_noof_errors := 0;
218: IF p_init_msg_list = FND_API.G_TRUE THEN
219: fnd_msg_pub.initialize;
220: END IF;
221:
222: IF p_element_id = FND_API.G_MISS_NUM THEN

Line 222: IF p_element_id = FND_API.G_MISS_NUM THEN

218: IF p_init_msg_list = FND_API.G_TRUE THEN
219: fnd_msg_pub.initialize;
220: END IF;
221:
222: IF p_element_id = FND_API.G_MISS_NUM THEN
223: l_element_id := null;
224: ELSE
225: l_element_id := p_element_id;
226: END IF;

Line 243: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

239: x_return_status => l_return_status,
240: x_competence_id => l_competence_id,
241: x_rating_level_id => l_rating_level_id );
242:
243: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
244: x_return_status:= FND_API.G_RET_STS_ERROR;
245: IF pa_competence_pvt.g_noof_errors = 1 THEN
246: pa_interface_utils_pub.get_messages
247: (p_encoded => FND_API.G_TRUE,

Line 244: x_return_status:= FND_API.G_RET_STS_ERROR;

240: x_competence_id => l_competence_id,
241: x_rating_level_id => l_rating_level_id );
242:
243: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
244: x_return_status:= FND_API.G_RET_STS_ERROR;
245: IF pa_competence_pvt.g_noof_errors = 1 THEN
246: pa_interface_utils_pub.get_messages
247: (p_encoded => FND_API.G_TRUE,
248: p_msg_index => 1,

Line 247: (p_encoded => FND_API.G_TRUE,

243: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
244: x_return_status:= FND_API.G_RET_STS_ERROR;
245: IF pa_competence_pvt.g_noof_errors = 1 THEN
246: pa_interface_utils_pub.get_messages
247: (p_encoded => FND_API.G_TRUE,
248: p_msg_index => 1,
249: p_msg_count => x_msg_count ,
250: p_msg_data => l_msg_data ,
251: p_data => l_data,

Line 278: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

274: ,x_return_status => l_return_status );
275:
276: x_return_status := l_return_status;
277:
278: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
279: x_return_status:= FND_API.G_RET_STS_ERROR;
280: IF pa_competence_pvt.g_noof_errors = 1 THEN
281: pa_interface_utils_pub.get_messages
282: (p_encoded => FND_API.G_TRUE,

Line 279: x_return_status:= FND_API.G_RET_STS_ERROR;

275:
276: x_return_status := l_return_status;
277:
278: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
279: x_return_status:= FND_API.G_RET_STS_ERROR;
280: IF pa_competence_pvt.g_noof_errors = 1 THEN
281: pa_interface_utils_pub.get_messages
282: (p_encoded => FND_API.G_TRUE,
283: p_msg_index => 1,

Line 282: (p_encoded => FND_API.G_TRUE,

278: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
279: x_return_status:= FND_API.G_RET_STS_ERROR;
280: IF pa_competence_pvt.g_noof_errors = 1 THEN
281: pa_interface_utils_pub.get_messages
282: (p_encoded => FND_API.G_TRUE,
283: p_msg_index => 1,
284: p_msg_count => x_msg_count ,
285: p_msg_data => l_msg_data ,
286: p_data => l_data,

Line 297: x_return_status:= FND_API.G_RET_STS_SUCCESS;

293: END IF;
294: pa_debug.reset_err_stack;
295: RETURN;
296: ELSE
297: x_return_status:= FND_API.G_RET_STS_SUCCESS;
298: END IF;
299:
300: IF p_commit = FND_API.G_TRUE THEN
301: COMMIT;

Line 300: IF p_commit = FND_API.G_TRUE THEN

296: ELSE
297: x_return_status:= FND_API.G_RET_STS_SUCCESS;
298: END IF;
299:
300: IF p_commit = FND_API.G_TRUE THEN
301: COMMIT;
302: END IF;
303: pa_debug.reset_err_stack;
304:

Line 310: IF p_commit = FND_API.G_TRUE THEN

306: WHEN OTHERS THEN
307:
308: l_err := SQLERRM;
309:
310: IF p_commit = FND_API.G_TRUE THEN
311: ROLLBACK TO COMPETENCE_PUB_UPD_COMP_ELE;
312: END IF;
313:
314: fnd_msg_pub.add_exc_msg

Line 322: (p_encoded => FND_API.G_TRUE,

318: x_msg_count := 1;
319:
320: IF x_msg_count = 1 THEN
321: pa_interface_utils_pub.get_messages
322: (p_encoded => FND_API.G_TRUE,
323: p_msg_index => 1,
324: p_msg_count => x_msg_count ,
325: p_msg_data => l_msg_data ,
326: p_data => l_data,

Line 332: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

328:
329: x_msg_data := l_data;
330: END IF;
331:
332: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
333:
334: -- RESET the other OUT PARAMS also : 4537865
335: x_object_version_number := NULL ;
336:

Line 340: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,

336:
337: END update_competence_element ;
338:
339: PROCEDURE delete_competence_element
340: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
341: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
342: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
343: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
344: p_competence_name IN per_competences.name%TYPE := chr(0),

Line 341: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,

337: END update_competence_element ;
338:
339: PROCEDURE delete_competence_element
340: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
341: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
342: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
343: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
344: p_competence_name IN per_competences.name%TYPE := chr(0),
345: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,

Line 342: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,

338:
339: PROCEDURE delete_competence_element
340: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
341: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
342: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
343: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
344: p_competence_name IN per_competences.name%TYPE := chr(0),
345: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
346: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

Line 343: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,

339: PROCEDURE delete_competence_element
340: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
341: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
342: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
343: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
344: p_competence_name IN per_competences.name%TYPE := chr(0),
345: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
346: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 345: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,

341: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
342: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
343: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
344: p_competence_name IN per_competences.name%TYPE := chr(0),
345: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
346: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 346: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

342: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
343: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
344: p_competence_name IN per_competences.name%TYPE := chr(0),
345: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
346: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_object_version_number IN NUMBER,

Line 347: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

343: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
344: p_competence_name IN per_competences.name%TYPE := chr(0),
345: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
346: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_object_version_number IN NUMBER,
351: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 348: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

344: p_competence_name IN per_competences.name%TYPE := chr(0),
345: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
346: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_object_version_number IN NUMBER,
351: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
352: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 349: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

345: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
346: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_object_version_number IN NUMBER,
351: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
352: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
353: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 365: x_return_status := FND_API.G_RET_STS_SUCCESS;

361: l_rating_level_id NUMBER := 0;
362: BEGIN
363: pa_debug.init_err_stack ('pa_competence_pub.delete_competence_element');
364: SAVEPOINT COMPETENCE_PUB_DEL_COMP_ELE;
365: x_return_status := FND_API.G_RET_STS_SUCCESS;
366: -- Initialize the PL/SQL message stack
367: pa_competence_pvt.g_noof_errors := 0;
368: IF p_init_msg_list = FND_API.G_TRUE THEN
369: fnd_msg_pub.initialize;

Line 368: IF p_init_msg_list = FND_API.G_TRUE THEN

364: SAVEPOINT COMPETENCE_PUB_DEL_COMP_ELE;
365: x_return_status := FND_API.G_RET_STS_SUCCESS;
366: -- Initialize the PL/SQL message stack
367: pa_competence_pvt.g_noof_errors := 0;
368: IF p_init_msg_list = FND_API.G_TRUE THEN
369: fnd_msg_pub.initialize;
370: END IF;
371:
372: -- Do the standard public api checks

Line 384: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

380: x_return_status => l_return_status,
381: x_competence_id => l_competence_id,
382: x_rating_level_id => l_rating_level_id );
383:
384: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
385: x_return_status:= FND_API.G_RET_STS_ERROR;
386: IF pa_competence_pvt.g_noof_errors = 1 THEN
387: pa_interface_utils_pub.get_messages
388: (p_encoded => FND_API.G_TRUE,

Line 385: x_return_status:= FND_API.G_RET_STS_ERROR;

381: x_competence_id => l_competence_id,
382: x_rating_level_id => l_rating_level_id );
383:
384: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
385: x_return_status:= FND_API.G_RET_STS_ERROR;
386: IF pa_competence_pvt.g_noof_errors = 1 THEN
387: pa_interface_utils_pub.get_messages
388: (p_encoded => FND_API.G_TRUE,
389: p_msg_index => 1,

Line 388: (p_encoded => FND_API.G_TRUE,

384: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
385: x_return_status:= FND_API.G_RET_STS_ERROR;
386: IF pa_competence_pvt.g_noof_errors = 1 THEN
387: pa_interface_utils_pub.get_messages
388: (p_encoded => FND_API.G_TRUE,
389: p_msg_index => 1,
390: p_msg_count => x_msg_count ,
391: p_msg_data => l_msg_data ,
392: p_data => l_data,

Line 415: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

411: p_object_version_number => p_object_version_number,
412: x_return_status => l_return_status );
413: x_return_status := l_return_status;
414:
415: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: IF pa_competence_pvt.g_noof_errors = 1 THEN
418: pa_interface_utils_pub.get_messages
419: (p_encoded => FND_API.G_TRUE,

Line 416: x_return_status := FND_API.G_RET_STS_ERROR;

412: x_return_status => l_return_status );
413: x_return_status := l_return_status;
414:
415: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: IF pa_competence_pvt.g_noof_errors = 1 THEN
418: pa_interface_utils_pub.get_messages
419: (p_encoded => FND_API.G_TRUE,
420: p_msg_index => 1,

Line 419: (p_encoded => FND_API.G_TRUE,

415: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: IF pa_competence_pvt.g_noof_errors = 1 THEN
418: pa_interface_utils_pub.get_messages
419: (p_encoded => FND_API.G_TRUE,
420: p_msg_index => 1,
421: p_msg_count => x_msg_count ,
422: p_msg_data => l_msg_data ,
423: p_data => l_data,

Line 434: x_return_status:= FND_API.G_RET_STS_SUCCESS;

430: END IF;
431: pa_debug.reset_err_stack;
432: RETURN;
433: ELSE
434: x_return_status:= FND_API.G_RET_STS_SUCCESS;
435: END IF;
436:
437: IF p_commit = FND_API.G_TRUE THEN
438: COMMIT;

Line 437: IF p_commit = FND_API.G_TRUE THEN

433: ELSE
434: x_return_status:= FND_API.G_RET_STS_SUCCESS;
435: END IF;
436:
437: IF p_commit = FND_API.G_TRUE THEN
438: COMMIT;
439: END IF;
440: pa_debug.reset_err_stack;
441:

Line 445: IF p_commit = FND_API.G_TRUE THEN

441:
442: EXCEPTION
443: WHEN OTHERS THEN
444:
445: IF p_commit = FND_API.G_TRUE THEN
446: ROLLBACK TO COMPETENCE_PUB_DEL_COMP_ELE;
447: END IF;
448:
449: fnd_msg_pub.add_exc_msg

Line 457: (p_encoded => FND_API.G_TRUE,

453: x_msg_count := 1;
454:
455: IF x_msg_count = 1 THEN
456: pa_interface_utils_pub.get_messages
457: (p_encoded => FND_API.G_TRUE,
458: p_msg_index => 1,
459: p_msg_count => x_msg_count ,
460: p_msg_data => l_msg_data ,
461: p_data => l_data,

Line 467: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

463:
464: x_msg_data := l_data;
465: END IF;
466:
467: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
468: END delete_competence_element;
469:
470: PROCEDURE standard_pub_checks
471: (

Line 473: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,

469:
470: PROCEDURE standard_pub_checks
471: (
472: p_element_id IN NUMBER := null,
473: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
474: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
475: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
476: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
477: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

Line 474: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,

470: PROCEDURE standard_pub_checks
471: (
472: p_element_id IN NUMBER := null,
473: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
474: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
475: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
476: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
477: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
478: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

Line 475: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,

471: (
472: p_element_id IN NUMBER := null,
473: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
474: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
475: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
476: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
477: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
478: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
479: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

Line 476: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,

472: p_element_id IN NUMBER := null,
473: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
474: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
475: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
476: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
477: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
478: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
479: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
480: p_operation IN VARCHAR2,

Line 477: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

473: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
474: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
475: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
476: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
477: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
478: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
479: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
480: p_operation IN VARCHAR2,
481: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 478: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

474: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
475: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
476: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
477: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
478: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
479: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
480: p_operation IN VARCHAR2,
481: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
482: x_competence_id OUT NOCOPY per_competences.competence_id%TYPE, --File.Sql.39 bug 4440895

Line 479: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

475: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
476: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
477: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
478: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
479: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
480: p_operation IN VARCHAR2,
481: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
482: x_competence_id OUT NOCOPY per_competences.competence_id%TYPE, --File.Sql.39 bug 4440895
483: x_rating_level_id OUT NOCOPY per_competence_elements.rating_level_id%TYPE ) IS --File.Sql.39 bug 4440895

Line 501: x_return_status:= FND_API.G_RET_STS_SUCCESS;

497: l_old_comp_alias VARCHAR2(30);
498: l_exists VARCHAR2(1);
499: BEGIN
500: pa_debug.init_err_stack ('pa_competence_pub.standard_pub_checks');
501: x_return_status:= FND_API.G_RET_STS_SUCCESS;
502: -- Check whether the object name is one of the supported names
503: IF (p_object_name = FND_API.G_MISS_CHAR) OR
504: (p_object_name IS NULL) OR
505: (p_object_name NOT IN ('PROJECT_ROLE','OPEN_ASSIGNMENT')) THEN

Line 503: IF (p_object_name = FND_API.G_MISS_CHAR) OR

499: BEGIN
500: pa_debug.init_err_stack ('pa_competence_pub.standard_pub_checks');
501: x_return_status:= FND_API.G_RET_STS_SUCCESS;
502: -- Check whether the object name is one of the supported names
503: IF (p_object_name = FND_API.G_MISS_CHAR) OR
504: (p_object_name IS NULL) OR
505: (p_object_name NOT IN ('PROJECT_ROLE','OPEN_ASSIGNMENT')) THEN
506: pa_competence_pvt.Check_Error
507: (p_return_status => FND_API.G_RET_STS_ERROR,

Line 507: (p_return_status => FND_API.G_RET_STS_ERROR,

503: IF (p_object_name = FND_API.G_MISS_CHAR) OR
504: (p_object_name IS NULL) OR
505: (p_object_name NOT IN ('PROJECT_ROLE','OPEN_ASSIGNMENT')) THEN
506: pa_competence_pvt.Check_Error
507: (p_return_status => FND_API.G_RET_STS_ERROR,
508: p_error_message_code => 'PA_INVALID_COMP_OBJECT_NAME');
509: END IF;
510:
511: -- Check whether competence alias or id is passed and call competence utils

Line 514: IF l_in_competence_id = FND_API.G_MISS_NUM THEN

510:
511: -- Check whether competence alias or id is passed and call competence utils
512: -- to validate
513: l_in_competence_id := p_competence_id;
514: IF l_in_competence_id = FND_API.G_MISS_NUM THEN
515: l_in_competence_id := NULL;
516: END IF;
517:
518: -- angie had commented out following three lines to fix bug 1569499 which was not

Line 521: IF l_in_rating_level_id = FND_API.G_MISS_NUM THEN

517:
518: -- angie had commented out following three lines to fix bug 1569499 which was not
519: -- correct. So uncommented out again.
520: l_in_rating_level_id := p_rating_level_id;
521: IF l_in_rating_level_id = FND_API.G_MISS_NUM THEN
522: l_in_rating_level_id := NULL;
523: END IF;
524:
525: l_in_competence_alias := p_competence_alias;

Line 526: IF l_in_competence_alias = FND_API.G_MISS_CHAR THEN

522: l_in_rating_level_id := NULL;
523: END IF;
524:
525: l_in_competence_alias := p_competence_alias;
526: IF l_in_competence_alias = FND_API.G_MISS_CHAR THEN
527: l_in_competence_alias := NULL;
528: END IF;
529: l_in_competence_name := p_competence_name;
530: IF l_in_competence_name = FND_API.G_MISS_CHAR THEN

Line 530: IF l_in_competence_name = FND_API.G_MISS_CHAR THEN

526: IF l_in_competence_alias = FND_API.G_MISS_CHAR THEN
527: l_in_competence_alias := NULL;
528: END IF;
529: l_in_competence_name := p_competence_name;
530: IF l_in_competence_name = FND_API.G_MISS_CHAR THEN
531: l_in_competence_name := NULL;
532: END IF;
533: l_in_rating_level_value := p_rating_level_value;
534: IF l_in_rating_level_value = FND_API.G_MISS_NUM THEN

Line 534: IF l_in_rating_level_value = FND_API.G_MISS_NUM THEN

530: IF l_in_competence_name = FND_API.G_MISS_CHAR THEN
531: l_in_competence_name := NULL;
532: END IF;
533: l_in_rating_level_value := p_rating_level_value;
534: IF l_in_rating_level_value = FND_API.G_MISS_NUM THEN
535: l_in_rating_level_value := NULL;
536: END IF;
537:
538: IF p_operation = 'INSERT' THEN

Line 549: l_return_status := FND_API.G_RET_STS_ERROR;

545: WHERE name = l_in_competence_name
546: AND competence_alias = l_in_competence_alias;
547: EXCEPTION
548: WHEN NO_DATA_FOUND THEN
549: l_return_status := FND_API.G_RET_STS_ERROR;
550: pa_competence_pvt.Check_Error
551: (p_return_status => l_return_status,
552: p_error_message_code => 'PA_PRM_INVALID_ALIAS');
553:

Line 575: l_return_status := FND_API.G_RET_STS_ERROR;

571: IF (nvl(l_in_competence_name,l_old_comp_name) <> l_old_comp_name) OR
572: (nvl(l_in_competence_alias,l_old_comp_alias) <> l_old_comp_alias) OR
573: (nvl(l_in_competence_id,l_old_competence_id) <> l_old_competence_id)
574: THEN
575: l_return_status := FND_API.G_RET_STS_ERROR;
576: pa_competence_pvt.Check_Error
577: (p_return_status => l_return_status,
578: p_error_message_code => 'PA_PRM_CANNOT_UPD_COMP');
579: END IF;

Line 583: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

579: END IF;
580: END IF;
581: END IF;
582:
583: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
584: x_return_status:= FND_API.G_RET_STS_ERROR;
585: pa_debug.reset_err_stack;
586: RETURN;
587: END IF;

Line 584: x_return_status:= FND_API.G_RET_STS_ERROR;

580: END IF;
581: END IF;
582:
583: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
584: x_return_status:= FND_API.G_RET_STS_ERROR;
585: pa_debug.reset_err_stack;
586: RETURN;
587: END IF;
588:

Line 605: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

601:
602: --If the return status is invalid, we cannot proceed further
603: -- All further validations require a competency id to be present
604:
605: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
606: x_return_status:= FND_API.G_RET_STS_ERROR;
607: pa_debug.reset_err_stack;
608: RETURN;
609: END IF;

Line 606: x_return_status:= FND_API.G_RET_STS_ERROR;

602: --If the return status is invalid, we cannot proceed further
603: -- All further validations require a competency id to be present
604:
605: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
606: x_return_status:= FND_API.G_RET_STS_ERROR;
607: pa_debug.reset_err_stack;
608: RETURN;
609: END IF;
610:

Line 636: x_return_status:= FND_API.G_RET_STS_ERROR;

632: pa_competence_pvt.Check_Error
633: (p_return_status => l_return_status,
634: p_error_message_code => l_error_message_code );
635: IF pa_competence_pvt.g_noof_errors > 0 THEN
636: x_return_status:= FND_API.G_RET_STS_ERROR;
637: ELSE
638: x_return_status:= FND_API.G_RET_STS_SUCCESS;
639: END IF;
640: pa_debug.reset_err_stack;

Line 638: x_return_status:= FND_API.G_RET_STS_SUCCESS;

634: p_error_message_code => l_error_message_code );
635: IF pa_competence_pvt.g_noof_errors > 0 THEN
636: x_return_status:= FND_API.G_RET_STS_ERROR;
637: ELSE
638: x_return_status:= FND_API.G_RET_STS_SUCCESS;
639: END IF;
640: pa_debug.reset_err_stack;
641: x_rating_level_id := l_rating_level_id;
642: EXCEPTION

Line 644: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

640: pa_debug.reset_err_stack;
641: x_rating_level_id := l_rating_level_id;
642: EXCEPTION
643: WHEN OTHERS THEN
644: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
645:
646: -- RESET the other OUT PARAMS also : 4537865
647: x_competence_id := NULL ;
648: x_rating_level_id := NULL ;

Line 665: ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR

661: the competences and calles the Mass Transaction API to start
662: the Mass Transaction Workflow.
663: -------------------------------------------------------------------- */
664: PROCEDURE Mass_Exec_Process_Competences
665: ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
666: ,p_project_id IN pa_project_assignments.project_id%TYPE
667: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
668: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type
669: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type

Line 674: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

670: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type
671: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type
672: ,p_rating_level_value_tbl IN SYSTEM.pa_num_tbl_type
673: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
674: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
675: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
676: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
677: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
678: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

671: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type
672: ,p_rating_level_value_tbl IN SYSTEM.pa_num_tbl_type
673: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
674: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
675: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
676: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
677: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
678: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
679: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

672: ,p_rating_level_value_tbl IN SYSTEM.pa_num_tbl_type
673: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
674: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
675: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
676: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
677: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
678: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
679: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
680: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

673: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
674: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
675: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
676: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
677: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
678: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
679: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
680: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
681: )

Line 686: l_validate_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

682:
683: IS
684:
685: l_wf_mode VARCHAR2(200);
686: l_validate_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
687: l_element_id NUMBER;
688: l_competence_id NUMBER;
689: l_rating_level_id NUMBER;
690: l_msg_index_out NUMBER;

Line 691: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

687: l_element_id NUMBER;
688: l_competence_id NUMBER;
689: l_rating_level_id NUMBER;
690: l_msg_index_out NUMBER;
691: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
692: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := p_rating_level_id_tbl;
693: l_rating_level_value_tbl SYSTEM.pa_num_tbl_type := p_rating_level_value_tbl;
694: l_competence_id_tbl SYSTEM.pa_num_tbl_type := p_competence_id_tbl;
695:

Line 700: x_return_status := FND_API.G_RET_STS_SUCCESS;

696: BEGIN
697:
698: --This API is only called to do standard validations
699:
700: x_return_status := FND_API.G_RET_STS_SUCCESS;
701:
702: -- Initialize the PL/SQL message stack
703: pa_competence_pvt.g_noof_errors := 0;
704:

Line 705: IF p_init_msg_list = FND_API.G_TRUE THEN

701:
702: -- Initialize the PL/SQL message stack
703: pa_competence_pvt.g_noof_errors := 0;
704:
705: IF p_init_msg_list = FND_API.G_TRUE THEN
706: fnd_msg_pub.initialize;
707: END IF;
708:
709: IF l_rating_level_id_tbl.count > 0 THEN

Line 743: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

739: END LOOP;
740: END LOOP;
741: END IF;
742:
743: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746:
747: -- if p_validate_only=false and there are no errors then start the

Line 744: RAISE FND_API.G_EXC_ERROR;

740: END LOOP;
741: END IF;
742:
743: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
744: RAISE FND_API.G_EXC_ERROR;
745: END IF;
746:
747: -- if p_validate_only=false and there are no errors then start the
748: -- workflow process.

Line 750: IF p_validate_only = FND_API.G_FALSE AND

746:
747: -- if p_validate_only=false and there are no errors then start the
748: -- workflow process.
749:
750: IF p_validate_only = FND_API.G_FALSE AND
751: l_validate_status = FND_API.G_RET_STS_SUCCESS
752: THEN
753:
754: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES;

Line 751: l_validate_status = FND_API.G_RET_STS_SUCCESS

747: -- if p_validate_only=false and there are no errors then start the
748: -- workflow process.
749:
750: IF p_validate_only = FND_API.G_FALSE AND
751: l_validate_status = FND_API.G_RET_STS_SUCCESS
752: THEN
753:
754: l_wf_mode := PA_MASS_ASGMT_TRX.G_MASS_UPDATE_COMPETENCIES;
755:

Line 774: WHEN FND_API.G_EXC_ERROR THEN

770:
771: END IF;
772:
773: EXCEPTION
774: WHEN FND_API.G_EXC_ERROR THEN
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: x_msg_count := FND_MSG_PUB.Count_Msg;
777:
778: IF x_msg_count = 1 THEN

Line 775: x_return_status := FND_API.G_RET_STS_ERROR;

771: END IF;
772:
773: EXCEPTION
774: WHEN FND_API.G_EXC_ERROR THEN
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: x_msg_count := FND_MSG_PUB.Count_Msg;
777:
778: IF x_msg_count = 1 THEN
779: pa_interface_utils_pub.get_messages

Line 780: (p_encoded => FND_API.G_TRUE,

776: x_msg_count := FND_MSG_PUB.Count_Msg;
777:
778: IF x_msg_count = 1 THEN
779: pa_interface_utils_pub.get_messages
780: (p_encoded => FND_API.G_TRUE,
781: p_msg_index => 1,
782: p_data => x_msg_data,
783: p_msg_index_out => l_msg_index_out );
784: END IF;

Line 787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

783: p_msg_index_out => l_msg_index_out );
784: END IF;
785: -- 4537865 : WHEN OTHERS Block Included.
786: WHEN OTHERS THEN
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
788: x_msg_count := 1;
789: x_msg_data := SUBSTRB(SQLERRM,1,240);
790:
791: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'PA_COMPETENCE_PUB',

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

817: p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type,
818: p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type,
819: p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type,
820: p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type,
821: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
822: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
823: p_commit IN VARCHAR2 := FND_API.G_FALSE,
824: x_success_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, /* Added NOCOPY for bug#2674619 */
825: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

818: p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type,
819: p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type,
820: p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type,
821: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
822: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
823: p_commit IN VARCHAR2 := FND_API.G_FALSE,
824: x_success_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, /* Added NOCOPY for bug#2674619 */
825: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
826: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

819: p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type,
820: p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type,
821: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
822: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
823: p_commit IN VARCHAR2 := FND_API.G_FALSE,
824: x_success_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, /* Added NOCOPY for bug#2674619 */
825: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
826: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
827: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 832: l_assignment_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;

828: IS
829: l_element_rowid ROWID;
830: l_element_id NUMBER;
831: l_assignment_id NUMBER := -1;
832: l_assignment_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
833: l_msg_data VARCHAR2(500);
834: l_msg_count NUMBER := 0;
835: l_return_status VARCHAR2(30);
836: l_object_version_number NUMBER;

Line 845: x_return_status := FND_API.G_RET_STS_SUCCESS;

841: l_mode VARCHAR2(30);
842: BEGIN
843:
844: x_success_assignment_id_tbl := p_assignment_tbl;
845: x_return_status := FND_API.G_RET_STS_SUCCESS;
846:
847: IF p_assignment_tbl.count > 0 THEN
848: FOR I in 1..p_assignment_tbl.count LOOP
849:

Line 854: IF l_assignment_return_status <> FND_API.G_RET_STS_SUCCESS

850: IF p_assignment_tbl(I) <> l_assignment_id THEN
851: -- Assignment Id has changed.
852: -- Create a new savepoint. Save the new assigment_id
853:
854: IF l_assignment_return_status <> FND_API.G_RET_STS_SUCCESS
855: THEN
856: ROLLBACK TO PROCESS_COMPETENCE_ELEMENTS;
857: PA_MESSAGE_UTILS.save_messages
858: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,

Line 866: p_commit => FND_API.G_TRUE,

862: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
863: p_context1 => p_project_id,
864: p_context2 => p_assignment_tbl(I-1),
865: p_context3 => NULL,
866: p_commit => FND_API.G_TRUE,
867: x_return_status => l_return_status);
868: l_assignment_return_status := FND_API.G_RET_STS_SUCCESS;
869: x_success_assignment_id_tbl(I-1) := null;
870:

Line 868: l_assignment_return_status := FND_API.G_RET_STS_SUCCESS;

864: p_context2 => p_assignment_tbl(I-1),
865: p_context3 => NULL,
866: p_commit => FND_API.G_TRUE,
867: x_return_status => l_return_status);
868: l_assignment_return_status := FND_API.G_RET_STS_SUCCESS;
869: x_success_assignment_id_tbl(I-1) := null;
870:
871: ELSE
872: -- Assignment Status is success. Commit the assignment

Line 875: IF p_commit = FND_API.G_TRUE THEN

871: ELSE
872: -- Assignment Status is success. Commit the assignment
873: -- changes.
874:
875: IF p_commit = FND_API.G_TRUE THEN
876: COMMIT;
877: END IF;
878: END IF;
879:

Line 920: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

916: x_msg_count => l_msg_count,
917: x_msg_data => l_msg_data);
918:
919: --added for bug: 4537865
920: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
921: l_object_version_number := l_new_object_version_number;
922: END IF;
923: --added for bug: 4537865
924:

Line 933: p_init_msg_list => FND_API.G_FALSE,

929: p_competence_id => p_competence_id_tbl(J),
930: p_competence_alias => p_competence_alias_tbl(J),
931: p_rating_level_id => p_rating_level_id_tbl(J),
932: p_mandatory_flag => p_mandatory_flag_tbl(J),
933: p_init_msg_list => FND_API.G_FALSE,
934: p_commit => FND_API.G_FALSE,
935: p_validate_only => 'N',
936: x_element_rowid => l_element_rowid,
937: x_element_id => l_element_id,

Line 934: p_commit => FND_API.G_FALSE,

930: p_competence_alias => p_competence_alias_tbl(J),
931: p_rating_level_id => p_rating_level_id_tbl(J),
932: p_mandatory_flag => p_mandatory_flag_tbl(J),
933: p_init_msg_list => FND_API.G_FALSE,
934: p_commit => FND_API.G_FALSE,
935: p_validate_only => 'N',
936: x_element_rowid => l_element_rowid,
937: x_element_id => l_element_id,
938: x_return_status => l_return_status,

Line 943: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

939: x_msg_count => l_msg_count,
940: x_msg_data => l_msg_data);
941: END IF;
942:
943: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
944: l_assignment_return_status := l_return_status;
945: END IF;
946:
947: END LOOP;

Line 953: IF l_assignment_return_status <> FND_API.G_RET_STS_SUCCESS THEN

949:
950: END LOOP;
951:
952: -- Check if the last assignment got updated
953: IF l_assignment_return_status <> FND_API.G_RET_STS_SUCCESS THEN
954: ROLLBACK TO PROCESS_COMPETENCE_ELEMENTS;
955: PA_MESSAGE_UTILS.save_messages
956: (p_user_id => PA_MASS_ASGMT_TRX.G_SUBMITTER_USER_ID,
957: p_source_type1 => PA_MASS_ASGMT_TRX.G_SOURCE_TYPE1,

Line 964: p_commit => FND_API.G_TRUE,

960: p_source_identifier2 => PA_MASS_ASGMT_TRX.G_WORKFLOW_ITEM_KEY,
961: p_context1 => p_project_id,
962: p_context2 => p_assignment_tbl(p_assignment_tbl.count),
963: p_context3 => NULL,
964: p_commit => FND_API.G_TRUE,
965: x_return_status => l_return_status);
966: x_success_assignment_id_tbl(p_assignment_tbl.count) := null;
967:
968: ELSE

Line 971: IF p_commit = FND_API.G_TRUE THEN

967:
968: ELSE
969: -- Assignment Status is success. Commit the assignment
970: -- changes.
971: IF p_commit = FND_API.G_TRUE THEN
972: COMMIT;
973: END IF;
974: END IF;
975:

Line 981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

977: EXCEPTION
978: WHEN OTHERS THEN
979: -- 4537865 : RESET OUT PARAMS
980: x_success_assignment_id_tbl := NULL ;
981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
982: x_msg_data := SUBSTRB(SQLERRM ,1,240);
983: x_msg_count := 1;
984:
985: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'PA_COMPETENCE_PUB',