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

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

45:
46: PROCEDURE Add_Competence_Element
47: ( p_person_id IN per_competence_elements.person_id%TYPE,
48: p_competence_id IN per_competences.competence_id%TYPE,
49: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
50: p_effective_date_from IN DATE,
51: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

47: ( p_person_id IN per_competence_elements.person_id%TYPE,
48: p_competence_id IN per_competences.competence_id%TYPE,
49: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
50: p_effective_date_from IN DATE,
51: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: x_return_status OUT NOCOPY VARCHAR2 ) IS -- 4537865 Added the nocopy hint
55:

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

48: p_competence_id IN per_competences.competence_id%TYPE,
49: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
50: p_effective_date_from IN DATE,
51: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: x_return_status OUT NOCOPY VARCHAR2 ) IS -- 4537865 Added the nocopy hint
55:
56: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

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

49: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
50: p_effective_date_from IN DATE,
51: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: x_return_status OUT NOCOPY VARCHAR2 ) IS -- 4537865 Added the nocopy hint
55:
56: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
57: l_data VARCHAR2(500);

Line 79: x_return_status := FND_API.G_RET_STS_SUCCESS;

75: END IF;
76:
77: SAVEPOINT COMPETENCE_PVT_ADD_COMP_ELE;
78:
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80:
81: -- Initialize the message stack if necessary
82: IF p_init_msg_list = FND_API.G_TRUE THEN
83: fnd_msg_pub.initialize;

Line 82: IF p_init_msg_list = FND_API.G_TRUE THEN

78:
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80:
81: -- Initialize the message stack if necessary
82: IF p_init_msg_list = FND_API.G_TRUE THEN
83: fnd_msg_pub.initialize;
84: END IF;
85:
86: -- Check where the competency can be asssigned to the person

Line 98: Check_Error ( p_return_status => FND_API.G_RET_STS_ERROR

94: p_error_message_code => l_error_message_code );
95:
96: -- Check whether the competency already exists for the person
97: IF check_competence_exists(p_person_id,p_competence_id) = 'Y' THEN
98: Check_Error ( p_return_status => FND_API.G_RET_STS_ERROR
99: ,p_error_message_code => 'PA_PRM_COMP_PROFILE_EXISTS');
100: END IF;
101:
102: -- Check whether the competency already exists but is waiting for approval

Line 104: Check_Error ( p_return_status => FND_API.G_RET_STS_ERROR

100: END IF;
101:
102: -- Check whether the competency already exists but is waiting for approval
103: IF Awaiting_Approval(p_person_id,p_competence_id) = 'Y' THEN
104: Check_Error ( p_return_status => FND_API.G_RET_STS_ERROR
105: ,p_error_message_code => 'PA_PRM_COMP_AWAITING_APPROVAL');
106: END IF;
107:
108: -- If there are errors, do not proceed to insert the data

Line 110: x_return_status := FND_API.G_RET_STS_ERROR;

106: END IF;
107:
108: -- If there are errors, do not proceed to insert the data
109: IF g_noof_errors > 0 THEN
110: x_return_status := FND_API.G_RET_STS_ERROR;
111: IF l_enable_log = 'Y' THEN
112: pa_debug.reset_err_stack;
113: END IF;
114: RETURN;

Line 119: x_return_status := FND_API.G_RET_STS_SUCCESS;

115: END IF;
116:
117: -- If validate only = 'Y' then return at this point.
118: IF p_validate_only = 'Y' THEN
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120: IF l_enable_log = 'Y' THEN
121: pa_debug.reset_err_stack;
122: END IF;
123: RETURN;

Line 159: x_return_status := FND_API.G_RET_STS_SUCCESS;

155: p_proficiency_level_id => p_rating_level_id,
156: p_effective_date_from => p_effective_date_from
157: ) ;
158:
159: x_return_status := FND_API.G_RET_STS_SUCCESS;
160: IF l_enable_log = 'Y' THEN
161: pa_debug.reset_err_stack;
162: END IF;
163: EXCEPTION

Line 165: IF p_commit = FND_API.G_TRUE THEN

161: pa_debug.reset_err_stack;
162: END IF;
163: EXCEPTION
164: WHEN OTHERS THEN
165: IF p_commit = FND_API.G_TRUE THEN
166: ROLLBACK TO COMPETENCE_PVT_ADD_COMP_ELE;
167: END IF;
168: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
169: RAISE;

Line 168: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

164: WHEN OTHERS THEN
165: IF p_commit = FND_API.G_TRUE THEN
166: ROLLBACK TO COMPETENCE_PVT_ADD_COMP_ELE;
167: END IF;
168: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
169: RAISE;
170: END Add_Competence_Element ;
171:
172: PROCEDURE Update_competence_element

Line 173: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,

169: RAISE;
170: END Add_Competence_Element ;
171:
172: PROCEDURE Update_competence_element
173: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
174: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
175: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
176: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
177: p_effective_date_from IN DATE,

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

170: END Add_Competence_Element ;
171:
172: PROCEDURE Update_competence_element
173: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
174: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
175: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
176: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
177: p_effective_date_from IN DATE,
178: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

171:
172: PROCEDURE Update_competence_element
173: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
174: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
175: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
176: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
177: p_effective_date_from IN DATE,
178: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

172: PROCEDURE Update_competence_element
173: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
174: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
175: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
176: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
177: p_effective_date_from IN DATE,
178: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

174: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
175: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
176: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
177: p_effective_date_from IN DATE,
178: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
181: p_object_version_number IN NUMBER,
182: x_object_version_number OUT NOCOPY NUMBER , -- 4537865 Added the nocopy hint

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

175: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
176: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
177: p_effective_date_from IN DATE,
178: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
181: p_object_version_number IN NUMBER,
182: x_object_version_number OUT NOCOPY NUMBER , -- 4537865 Added the nocopy hint
183: x_return_status OUT NOCOPY VARCHAR2 ) IS -- 4537865 Added the nocopy hint

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

176: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
177: p_effective_date_from IN DATE,
178: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
181: p_object_version_number IN NUMBER,
182: x_object_version_number OUT NOCOPY NUMBER , -- 4537865 Added the nocopy hint
183: x_return_status OUT NOCOPY VARCHAR2 ) IS -- 4537865 Added the nocopy hint
184:

Line 201: IF p_init_msg_list = FND_API.G_TRUE THEN

197: END IF;
198: SAVEPOINT COMPETENCE_PVT_UPD_COMP_ELE;
199:
200: -- Initialize the message stack if necessary
201: IF p_init_msg_list = FND_API.G_TRUE THEN
202: fnd_msg_pub.initialize;
203: END IF;
204:
205: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 205: x_return_status := FND_API.G_RET_STS_SUCCESS;

201: IF p_init_msg_list = FND_API.G_TRUE THEN
202: fnd_msg_pub.initialize;
203: END IF;
204:
205: x_return_status := FND_API.G_RET_STS_SUCCESS;
206:
207: -- If there are errors, do not proceed to update the data
208: -- Check whether the object version number is correct
209:

Line 216: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

212: p_object_version_number => p_object_version_number,
213: x_return_status => l_return_status,
214: x_error_message_code => l_error_message_code );
215:
216: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
217: Check_Error (p_return_status => l_return_status
218: ,p_error_message_code => l_error_message_code );
219: END IF;
220:

Line 225: Check_Error ( p_return_status => FND_API.G_RET_STS_ERROR

221: -- Check to see if the user is trying to update something which
222: -- is yet not approved.
223: IF p_element_id is not null THEN
224: IF Awaiting_Approval(p_element_id) = 'Y' THEN
225: Check_Error ( p_return_status => FND_API.G_RET_STS_ERROR
226: ,p_error_message_code => 'PA_PRM_CANNOT_UPDATE');
227: END IF;
228: ELSE
229: IF Awaiting_Approval(p_person_id,p_competence_id) = 'Y' THEN

Line 230: Check_Error ( p_return_status => FND_API.G_RET_STS_ERROR

226: ,p_error_message_code => 'PA_PRM_CANNOT_UPDATE');
227: END IF;
228: ELSE
229: IF Awaiting_Approval(p_person_id,p_competence_id) = 'Y' THEN
230: Check_Error ( p_return_status => FND_API.G_RET_STS_ERROR
231: ,p_error_message_code => 'PA_PRM_CANNOT_UPDATE');
232: END IF;
233: END IF;
234:

Line 236: x_return_status := FND_API.G_RET_STS_ERROR;

232: END IF;
233: END IF;
234:
235: IF g_noof_errors > 0 THEN
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: IF l_enable_log = 'Y' THEN
238: pa_debug.reset_err_stack;
239: END IF;
240: RETURN;

Line 245: x_return_status := FND_API.G_RET_STS_SUCCESS;

241: END IF;
242:
243: -- If validate only = 'Y' then return at this point.
244: IF p_validate_only = 'Y' THEN
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246: IF l_enable_log = 'Y' THEN
247: pa_debug.reset_err_stack;
248: END IF;
249: RETURN;

Line 272: x_return_status := FND_API.G_RET_STS_SUCCESS;

268: p_object_version_number => p_object_version_number,
269: p_rating_level_id => p_rating_level_id,
270: p_effective_date_from => p_effective_date_from);
271:
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273: IF l_enable_log = 'Y' THEN
274: pa_debug.reset_err_stack;
275: END IF;
276: EXCEPTION

Line 278: IF p_commit = FND_API.G_TRUE THEN

274: pa_debug.reset_err_stack;
275: END IF;
276: EXCEPTION
277: WHEN OTHERS THEN
278: IF p_commit = FND_API.G_TRUE THEN
279: ROLLBACK TO COMPETENCE_PVT_UPD_COMP_ELE;
280: END IF;
281:
282: -- 4537865

Line 284: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

280: END IF;
281:
282: -- 4537865
283: x_object_version_number := NULL ;
284: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
285: RAISE;
286: END Update_Competence_element;
287:
288: Procedure delete_competence_element

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

289: ( p_person_id IN NUMBER,
290: p_competence_id IN NUMBER,
291: p_element_id IN NUMBER,
292: p_object_version_number IN NUMBER,
293: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: x_return_status OUT NOCOPY VARCHAR2) -- 4537865 Added the nocopy hint
295: IS
296: l_competence_alias VARCHAR2(30);
297: l_competence_name VARCHAR2(240);

Line 305: Check_Error ( p_return_status => FND_API.G_RET_STS_ERROR

301: -- Check to see if the user is trying to update something which
302: -- is yet not approved.
303: IF p_element_id is not null THEN
304: IF Awaiting_Approval(p_element_id) = 'Y' THEN
305: Check_Error ( p_return_status => FND_API.G_RET_STS_ERROR
306: ,p_error_message_code => 'PA_PRM_CANNOT_DELETE');
307: END IF;
308: ELSE
309: IF Awaiting_Approval(p_person_id,p_competence_id) = 'Y' THEN

Line 310: Check_Error ( p_return_status => FND_API.G_RET_STS_ERROR

306: ,p_error_message_code => 'PA_PRM_CANNOT_DELETE');
307: END IF;
308: ELSE
309: IF Awaiting_Approval(p_person_id,p_competence_id) = 'Y' THEN
310: Check_Error ( p_return_status => FND_API.G_RET_STS_ERROR
311: ,p_error_message_code => 'PA_PRM_CANNOT_DELETE');
312: END IF;
313: END IF;
314:

Line 321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

317: p_object_version_number => p_object_version_number);
318: -- 4537865
319: EXCEPTION
320: WHEN OTHERS THEN
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: fnd_msg_pub.add_exc_msg
323: (p_pkg_name => 'PA_COMP_PROFILE_PVT',
324: p_procedure_name => 'delete_competence_element');
325: -- RAISE is not included as the caller of this API doesnt RAISE

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

326:
327: END delete_competence_element;
328:
329: PROCEDURE Check_Element_id
330: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
331: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
332: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
333: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
334: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , -- 4537865 Added the nocopy hint

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

327: END delete_competence_element;
328:
329: PROCEDURE Check_Element_id
330: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
331: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
332: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
333: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
334: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , -- 4537865 Added the nocopy hint
335: x_return_status OUT NOCOPY VARCHAR2, -- 4537865 Added the nocopy hint

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

328:
329: PROCEDURE Check_Element_id
330: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
331: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
332: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
333: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
334: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , -- 4537865 Added the nocopy hint
335: x_return_status OUT NOCOPY VARCHAR2, -- 4537865 Added the nocopy hint
336: x_error_message_code OUT NOCOPY VARCHAR2) IS -- 4537865 Added the nocopy hint

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

329: PROCEDURE Check_Element_id
330: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
331: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
332: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
333: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
334: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , -- 4537865 Added the nocopy hint
335: x_return_status OUT NOCOPY VARCHAR2, -- 4537865 Added the nocopy hint
336: x_error_message_code OUT NOCOPY VARCHAR2) IS -- 4537865 Added the nocopy hint
337:

Line 352: x_return_status := FND_API.G_RET_STS_SUCCESS;

348: BEGIN
349: IF l_enable_log = 'Y' THEN
350: pa_debug.set_err_stack ('PA_COMP_PROFILE_PVT.check_element_id');
351: END IF;
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353: OPEN l_check_element_csr;
354: FETCH l_check_element_csr INTO l_check_element_rec;
355: IF l_check_element_csr%NOTFOUND
356: OR (l_check_element_rec.competence_id <> p_competence_id

Line 361: x_return_status := FND_API.G_RET_STS_ERROR;

357: OR
358: l_check_element_rec.object_id <> p_object_id
359: OR
360: l_check_element_rec.object_name <> p_object_name) THEN
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: x_error_message_code := 'PA_INVALID_ELEMENT_ID';
363: x_effective_date_from := NULL;
364: END IF;
365: CLOSE l_check_element_csr;

Line 373: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

369: END IF;
370:
371: EXCEPTION
372: WHEN OTHERS THEN
373: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
374:
375: -- Start : 4537865
376: x_effective_date_from := NULL ;
377: x_error_message_code := SQLERRM;

Line 390: IF p_return_status = FND_API.G_RET_STS_ERROR THEN

386: BEGIN
387: IF l_enable_log = 'Y' THEN
388: pa_debug.set_err_stack ('PA_COMP_PROFILE_PVT.check_error');
389: END IF;
390: IF p_return_status = FND_API.G_RET_STS_ERROR THEN
391: g_noof_errors := g_noof_errors + 1;
392: pa_utils.add_message (p_app_short_name => 'PA',
393: p_msg_name => p_error_message_code);
394: END IF;

Line 426: x_return_status := FND_API.G_RET_STS_ERROR;

422: FETCH l_get_obj_vers_csr INTO l_obj_version_number;
423: -- dbms_output.put_line (' l obj is '||l_obj_version_number ||
424: -- ' p obj is '||p_object_version_number );
425: IF l_obj_version_number <> p_object_version_number THEN
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: x_error_message_code := 'PA_COMP_OBJ_VERSION_INVALID';
428: END IF;
429: CLOSE l_get_obj_vers_csr;
430: IF l_enable_log = 'Y' THEN

Line 436: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

432: END IF;
433:
434: EXCEPTION
435: WHEN OTHERS THEN
436: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
437:
438: -- 4537865 : Start
439: x_error_message_code := SQLERRM;
440: -- 4537865 : End

Line 525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

521:
522:
523: EXCEPTION
524: WHEN OTHERS THEN
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: end create_competence_element;
527:
528: Procedure Update_competence_element
529: (p_profile_id IN NUMBER,

Line 677: x_return_status := FND_API.G_RET_STS_SUCCESS;

673:
674: --The API Start_Approval_Process has been stubbed out for Bug:4665696 as the workflow "PA Competence Profile Approval Workflow" is to be absoleted.
675:
676: /*
677: x_return_status := FND_API.G_RET_STS_SUCCESS;
678: x_msg_count := g_profile_id;
679: x_msg_data := null;
680:
681: -- dbms_output.put_line('g_profile_id: ' || g_profile_id);

Line 714: RAISE FND_API.G_EXC_ERROR;

710:
711: pa_utils.add_message (p_app_short_name => 'PA',
712: p_msg_name => 'PA_PRM_NO_MANAGER');
713:
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716:
717: WF_ENGINE.CreateProcess('PACOPR',
718: to_char(g_profile_id),

Line 774: WHEN FND_API.G_EXC_ERROR THEN

770:
771: commit;
772:
773: EXCEPTION
774: WHEN FND_API.G_EXC_ERROR THEN
775: x_return_status := FND_API.G_RET_STS_ERROR;
776:
777: pa_interface_utils_pub.get_messages
778: (p_encoded => FND_API.G_TRUE,

Line 775: x_return_status := FND_API.G_RET_STS_ERROR;

771: commit;
772:
773: EXCEPTION
774: WHEN FND_API.G_EXC_ERROR THEN
775: x_return_status := FND_API.G_RET_STS_ERROR;
776:
777: pa_interface_utils_pub.get_messages
778: (p_encoded => FND_API.G_TRUE,
779: p_msg_index => 1,

Line 778: (p_encoded => FND_API.G_TRUE,

774: WHEN FND_API.G_EXC_ERROR THEN
775: x_return_status := FND_API.G_RET_STS_ERROR;
776:
777: pa_interface_utils_pub.get_messages
778: (p_encoded => FND_API.G_TRUE,
779: p_msg_index => 1,
780: p_msg_count => x_msg_count ,
781: p_msg_data => l_msg_data ,
782: p_data => l_data,

Line 800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

796: g_profile_id := 0;
797: g_person_id := 0;
798:
799: WHEN OTHERS THEN
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801:
802: -- 4537865 : Start
803: x_msg_count := 1 ;
804: -- 4537865 : End

Line 1017: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1013: EXCEPTION
1014: WHEN OTHERS THEN
1015:
1016: -- 4537865
1017: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1018: x_msg_count := 1;
1019: x_msg_data := SQLERRM;
1020:
1021: Fnd_Msg_Pub.add_exc_msg

Line 1045: x_return_status := FND_API.G_RET_STS_ERROR;

1041: FROM per_competences
1042: WHERE competence_id = p_competence_id;
1043: EXCEPTION
1044: WHEN NO_DATA_FOUND THEN
1045: x_return_status := FND_API.G_RET_STS_ERROR;
1046: x_error_message_code := 'PA_COMPETENCY_INVALID_AMBIGOUS';
1047: END;
1048:
1049: IF (l_comp_bg_id IS NOT NULL

Line 1052: x_return_status := FND_API.G_RET_STS_ERROR;

1048:
1049: IF (l_comp_bg_id IS NOT NULL
1050: AND l_comp_bg_id <> pa_utils.business_group_id)
1051: THEN
1052: x_return_status := FND_API.G_RET_STS_ERROR;
1053: x_error_message_code := 'PA_PRM_BG_COMP_INVALID';
1054: IF l_enable_log = 'Y' THEN
1055: pa_debug.reset_err_stack;
1056: END IF;

Line 1060: x_return_status := FND_API.G_RET_STS_SUCCESS;

1056: END IF;
1057: RETURN;
1058: END IF;
1059:
1060: x_return_status := FND_API.G_RET_STS_SUCCESS;
1061: --4537865
1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 1064: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1060: x_return_status := FND_API.G_RET_STS_SUCCESS;
1061: --4537865
1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1065: x_error_message_code := SQLERRM;
1066:
1067: fnd_msg_pub.add_exc_msg
1068: (p_pkg_name => 'PA_COMP_PROFILE_PVT',

Line 1308: x_return_status := FND_API.G_RET_STS_SUCCESS;

1304: BEGIN
1305: DELETE FROM pa_competence_profiles
1306: WHERE profile_id=p_profile_id;
1307:
1308: x_return_status := FND_API.G_RET_STS_SUCCESS;
1309: x_msg_count := 0;
1310: x_msg_data := null;
1311:
1312: EXCEPTION