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_PVT dependencies on PA_DEBUG

Line 52: pa_debug.set_err_stack ('pa_competence_pvt.add_competence_element');

48: FROM per_competence_elements
49: WHERE competence_element_id = l_element_id;
50:
51: BEGIN
52: pa_debug.set_err_stack ('pa_competence_pvt.add_competence_element');
53: SAVEPOINT COMPETENCE_PVT_ADD_COMP_ELE;
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: -- Initialize the message stack if necessary

Line 131: pa_debug.reset_err_stack;

127:
128: -- If there are errors, do not proceed to insert the data
129: IF g_noof_errors > 0 THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: pa_debug.reset_err_stack;
132: RETURN;
133: END IF;
134:
135: -- If validate only = 'Y' then return at this point.

Line 138: pa_debug.reset_err_stack;

134:
135: -- If validate only = 'Y' then return at this point.
136: IF p_validate_only = 'Y' THEN
137: x_return_status := FND_API.G_RET_STS_SUCCESS;
138: pa_debug.reset_err_stack;
139: RETURN;
140: END IF;
141:
142: -- Decode default values to null

Line 236: pa_debug.reset_err_stack;

232: CLOSE l_rowid_csr;
233: END IF;
234: x_element_id := l_element_id; /* added for bug 2084645 */
235: x_return_status := FND_API.G_RET_STS_SUCCESS;
236: pa_debug.reset_err_stack;
237:
238: EXCEPTION
239: WHEN OTHERS THEN
240: IF p_commit = FND_API.G_TRUE THEN

Line 270: pa_debug.set_err_stack ('pa_competence_pvt.update_competence_element');

266: l_error_message_code VARCHAR2(30);
267: l_mandatory_flag VARCHAR2(1);
268:
269: BEGIN
270: pa_debug.set_err_stack ('pa_competence_pvt.update_competence_element');
271: SAVEPOINT COMPETENCE_PVT_UPD_COMP_ELE;
272: -- Initialize the message stack if necessary
273: IF p_init_msg_list = FND_API.G_TRUE THEN
274: fnd_msg_pub.initialize;

Line 315: pa_debug.reset_err_stack;

311: END IF;
312:
313: IF g_noof_errors > 0 THEN
314: x_return_status := FND_API.G_RET_STS_ERROR;
315: pa_debug.reset_err_stack;
316: RETURN;
317: END IF;
318: -- If validate only = 'Y' then return at this point.
319: IF p_validate_only = 'Y' THEN

Line 321: pa_debug.reset_err_stack;

317: END IF;
318: -- If validate only = 'Y' then return at this point.
319: IF p_validate_only = 'Y' THEN
320: x_return_status := FND_API.G_RET_STS_SUCCESS;
321: pa_debug.reset_err_stack;
322: RETURN;
323: END IF;
324: -- Decode default values to null
325: l_mandatory_flag := p_mandatory_flag;

Line 349: pa_debug.reset_err_stack;

345: p_effective_date => l_effective_date_from );
346:
347: x_object_version_number := l_object_version_number;
348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349: pa_debug.reset_err_stack;
350: EXCEPTION
351: WHEN OTHERS THEN
352: IF p_commit = FND_API.G_TRUE THEN
353: ROLLBACK TO COMPETENCE_PVT_UPD_COMP_ELE;

Line 377: pa_debug.set_err_stack ('pa_competence_pvt.delete_competence_element');

373: l_object_version_number NUMBER ;
374: l_error_message_code VARCHAR2(30);
375:
376: BEGIN
377: pa_debug.set_err_stack ('pa_competence_pvt.delete_competence_element');
378: SAVEPOINT COMPETENCE_PVT_DEL_COMP_ELE;
379: -- Initialize the message stack if necessary
380: IF p_init_msg_list = FND_API.G_TRUE THEN
381: fnd_msg_pub.initialize;

Line 422: pa_debug.reset_err_stack;

418:
419: -- If there are errors, do not proceed to delete the data
420: IF g_noof_errors > 0 THEN
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: pa_debug.reset_err_stack;
423: RETURN;
424: END IF;
425: -- If validate only = 'Y' then return at this point.
426: IF p_validate_only = 'Y' THEN

Line 428: pa_debug.reset_err_stack;

424: END IF;
425: -- If validate only = 'Y' then return at this point.
426: IF p_validate_only = 'Y' THEN
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
428: pa_debug.reset_err_stack;
429: RETURN;
430: END IF;
431: hr_competence_element_api.delete_competence_element
432: (p_competence_element_id => p_element_id,

Line 436: pa_debug.reset_err_stack;

432: (p_competence_element_id => p_element_id,
433: p_object_version_number => p_object_version_number );
434:
435: x_return_status := FND_API.G_RET_STS_SUCCESS;
436: pa_debug.reset_err_stack;
437:
438: EXCEPTION
439: WHEN OTHERS THEN
440: IF p_commit = FND_API.G_TRUE THEN

Line 465: pa_debug.set_err_stack ('pa_competence_pvt.check_element_id');

461: FROM per_competence_elements
462: WHERE competence_element_id = p_element_id;
463: l_check_element_rec l_check_element_csr%ROWTYPE;
464: BEGIN
465: pa_debug.set_err_stack ('pa_competence_pvt.check_element_id');
466: x_return_status := FND_API.G_RET_STS_SUCCESS;
467: OPEN l_check_element_csr;
468: FETCH l_check_element_csr INTO l_check_element_rec;
469: IF l_check_element_csr%NOTFOUND

Line 481: pa_debug.reset_err_stack;

477: x_effective_date_from := NULL;
478: END IF;
479: x_effective_date_from := l_check_element_rec.effective_date_from;
480: CLOSE l_check_element_csr;
481: pa_debug.reset_err_stack;
482:
483: EXCEPTION
484: WHEN OTHERS THEN
485: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 492: pa_debug.set_err_stack ('pa_competence_pvt.check_error');

488:
489: PROCEDURE Check_Error (p_return_status IN VARCHAR2,
490: p_error_message_code IN VARCHAR2) IS
491: BEGIN
492: pa_debug.set_err_stack ('pa_competence_pvt.check_error');
493: IF p_return_status = FND_API.G_RET_STS_ERROR THEN
494: g_noof_errors := g_noof_errors + 1;
495: pa_utils.add_message (p_app_short_name => 'PA',
496: p_msg_name => p_error_message_code);

Line 498: pa_debug.reset_err_stack;

494: g_noof_errors := g_noof_errors + 1;
495: pa_utils.add_message (p_app_short_name => 'PA',
496: p_msg_name => p_error_message_code);
497: END IF;
498: pa_debug.reset_err_stack;
499: EXCEPTION
500: WHEN OTHERS THEN
501: RAISE;
502: END check_error;

Line 517: pa_debug.set_err_stack ('pa_competence_pvt.check_object_version_number');

513: WHERE competence_element_id = p_element_id;
514: l_obj_version_number NUMBER := 0;
515:
516: BEGIN
517: pa_debug.set_err_stack ('pa_competence_pvt.check_object_version_number');
518: OPEN l_get_obj_vers_csr;
519: FETCH l_get_obj_vers_csr INTO l_obj_version_number;
520: IF l_obj_version_number <> p_object_version_number THEN
521: x_return_status := FND_API.G_RET_STS_ERROR;

Line 525: pa_debug.reset_err_stack;

521: x_return_status := FND_API.G_RET_STS_ERROR;
522: x_error_message_code := 'PA_COMP_OBJ_VERSION_INVALID';
523: END IF;
524: CLOSE l_get_obj_vers_csr;
525: pa_debug.reset_err_stack;
526:
527: EXCEPTION
528: WHEN OTHERS THEN
529: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;