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 PA_COMPETENCE_PVT

Line 50: pa_competence_pvt.g_noof_errors := 0;

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
52: fnd_msg_pub.initialize;
53: END IF;
54:

Line 74: IF pa_competence_pvt.g_noof_errors = 1 THEN

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,
78: p_msg_count => x_msg_count ,

Line 83: x_msg_count := pa_competence_pvt.g_noof_errors;

79: p_msg_data => l_msg_data ,
80: p_data => l_data,
81: p_msg_index_out => l_msg_index_out );
82: x_msg_data := l_data;
83: x_msg_count := pa_competence_pvt.g_noof_errors;
84: ELSE
85: x_msg_count := pa_competence_pvt.g_noof_errors;
86: END IF;
87: pa_debug.reset_err_stack;

Line 85: x_msg_count := pa_competence_pvt.g_noof_errors;

81: p_msg_index_out => l_msg_index_out );
82: x_msg_data := l_data;
83: x_msg_count := pa_competence_pvt.g_noof_errors;
84: ELSE
85: x_msg_count := pa_competence_pvt.g_noof_errors;
86: END IF;
87: pa_debug.reset_err_stack;
88: RETURN;
89: END IF;

Line 101: pa_competence_pvt.Check_Error

97: ,x_role_id => l_role_id
98: ,x_return_status => l_return_status
99: ,x_error_message_code => l_error_message_code );
100:
101: pa_competence_pvt.Check_Error
102: (p_return_status => l_return_status,
103: p_error_message_code => l_error_message_code );
104: END IF;
105:

Line 108: pa_competence_pvt.Add_competence_element

104: END IF;
105:
106: l_object_id(1).assignment_id := p_object_id;
107:
108: pa_competence_pvt.Add_competence_element
109: ( p_object_name => p_object_name,
110: p_object_id => l_object_id,
111: p_competence_id => l_competence_id,
112: p_rating_level_id => l_rating_level_id,

Line 123: IF pa_competence_pvt.g_noof_errors = 1 THEN

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,
126: p_msg_index => 1,
127: p_msg_count => x_msg_count ,

Line 132: x_msg_count := pa_competence_pvt.g_noof_errors;

128: p_msg_data => l_msg_data ,
129: p_data => l_data,
130: p_msg_index_out => l_msg_index_out );
131: x_msg_data := l_data;
132: x_msg_count := pa_competence_pvt.g_noof_errors;
133: ELSE
134: x_msg_count := pa_competence_pvt.g_noof_errors;
135: END IF;
136:

Line 134: x_msg_count := pa_competence_pvt.g_noof_errors;

130: p_msg_index_out => l_msg_index_out );
131: x_msg_data := l_data;
132: x_msg_count := pa_competence_pvt.g_noof_errors;
133: ELSE
134: x_msg_count := pa_competence_pvt.g_noof_errors;
135: END IF;
136:
137: pa_debug.reset_err_stack;
138: RETURN;

Line 217: pa_competence_pvt.g_noof_errors := 0;

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;
220: END IF;
221:

Line 245: IF pa_competence_pvt.g_noof_errors = 1 THEN

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,
249: p_msg_count => x_msg_count ,

Line 254: x_msg_count := pa_competence_pvt.g_noof_errors;

250: p_msg_data => l_msg_data ,
251: p_data => l_data,
252: p_msg_index_out => l_msg_index_out );
253: x_msg_data := l_data;
254: x_msg_count := pa_competence_pvt.g_noof_errors;
255: ELSE
256: x_msg_count := pa_competence_pvt.g_noof_errors;
257: END IF;
258: pa_debug.reset_err_stack;

Line 256: x_msg_count := pa_competence_pvt.g_noof_errors;

252: p_msg_index_out => l_msg_index_out );
253: x_msg_data := l_data;
254: x_msg_count := pa_competence_pvt.g_noof_errors;
255: ELSE
256: x_msg_count := pa_competence_pvt.g_noof_errors;
257: END IF;
258: pa_debug.reset_err_stack;
259: RETURN;
260: END IF;

Line 262: pa_competence_pvt.update_competence_element

258: pa_debug.reset_err_stack;
259: RETURN;
260: END IF;
261:
262: pa_competence_pvt.update_competence_element
263: ( p_object_name => p_object_name
264: ,p_object_id => p_object_id
265: ,p_competence_id => l_competence_id
266: ,p_element_rowid => p_element_rowid

Line 280: IF pa_competence_pvt.g_noof_errors = 1 THEN

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,
284: p_msg_count => x_msg_count ,

Line 290: x_msg_count := pa_competence_pvt.g_noof_errors;

286: p_data => l_data,
287: p_msg_index_out => l_msg_index_out );
288:
289: x_msg_data := l_data;
290: x_msg_count := pa_competence_pvt.g_noof_errors;
291: ELSE
292: x_msg_count := pa_competence_pvt.g_noof_errors;
293: END IF;
294: pa_debug.reset_err_stack;

Line 292: x_msg_count := pa_competence_pvt.g_noof_errors;

288:
289: x_msg_data := l_data;
290: x_msg_count := pa_competence_pvt.g_noof_errors;
291: ELSE
292: x_msg_count := pa_competence_pvt.g_noof_errors;
293: END IF;
294: pa_debug.reset_err_stack;
295: RETURN;
296: ELSE

Line 367: pa_competence_pvt.g_noof_errors := 0;

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;
370: END IF;
371:

Line 386: IF pa_competence_pvt.g_noof_errors = 1 THEN

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,
390: p_msg_count => x_msg_count ,

Line 395: x_msg_count := pa_competence_pvt.g_noof_errors;

391: p_msg_data => l_msg_data ,
392: p_data => l_data,
393: p_msg_index_out => l_msg_index_out );
394: x_msg_data := l_data;
395: x_msg_count := pa_competence_pvt.g_noof_errors;
396: ELSE
397: x_msg_count := pa_competence_pvt.g_noof_errors;
398: END IF;
399: pa_debug.reset_err_stack;

Line 397: x_msg_count := pa_competence_pvt.g_noof_errors;

393: p_msg_index_out => l_msg_index_out );
394: x_msg_data := l_data;
395: x_msg_count := pa_competence_pvt.g_noof_errors;
396: ELSE
397: x_msg_count := pa_competence_pvt.g_noof_errors;
398: END IF;
399: pa_debug.reset_err_stack;
400: RETURN;
401: END IF;

Line 403: pa_competence_pvt.delete_competence_element

399: pa_debug.reset_err_stack;
400: RETURN;
401: END IF;
402: -- Call the pvt delete competence element api now
403: pa_competence_pvt.delete_competence_element
404: (p_object_name => p_object_name,
405: p_object_id => p_object_id,
406: p_competence_id => l_competence_id,
407: p_element_rowid => p_element_rowid,

Line 417: IF pa_competence_pvt.g_noof_errors = 1 THEN

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,
421: p_msg_count => x_msg_count ,

Line 427: x_msg_count := pa_competence_pvt.g_noof_errors;

423: p_data => l_data,
424: p_msg_index_out => l_msg_index_out );
425:
426: x_msg_data := l_data;
427: x_msg_count := pa_competence_pvt.g_noof_errors;
428: ELSE
429: x_msg_count := pa_competence_pvt.g_noof_errors;
430: END IF;
431: pa_debug.reset_err_stack;

Line 429: x_msg_count := pa_competence_pvt.g_noof_errors;

425:
426: x_msg_data := l_data;
427: x_msg_count := pa_competence_pvt.g_noof_errors;
428: ELSE
429: x_msg_count := pa_competence_pvt.g_noof_errors;
430: END IF;
431: pa_debug.reset_err_stack;
432: RETURN;
433: ELSE

Line 506: pa_competence_pvt.Check_Error

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,
508: p_error_message_code => 'PA_INVALID_COMP_OBJECT_NAME');
509: END IF;
510:

Line 550: pa_competence_pvt.Check_Error

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:
554: END;

Line 576: pa_competence_pvt.Check_Error

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;
580: END IF;

Line 598: pa_competence_pvt.Check_Error

594: ,x_competence_id => l_competence_id
595: ,x_return_status => l_return_status
596: ,x_error_msg_code => l_error_message_code);
597:
598: pa_competence_pvt.Check_Error
599: (p_return_status => l_return_status,
600: p_error_message_code => l_error_message_code );
601:
602: --If the return status is invalid, we cannot proceed further

Line 632: pa_competence_pvt.Check_Error

628: ,p_check_id_flag => pa_startup.g_check_id_flag
629: ,x_rating_level_id => l_rating_level_id
630: ,x_return_status => l_return_status
631: ,x_error_msg_code => l_error_message_code) ;
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;

Line 635: IF pa_competence_pvt.g_noof_errors > 0 THEN

631: ,x_error_msg_code => l_error_message_code) ;
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;

Line 703: pa_competence_pvt.g_noof_errors := 0;

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:
705: IF p_init_msg_list = FND_API.G_TRUE THEN
706: fnd_msg_pub.initialize;
707: END IF;