DBA Data[Home] [Help]

APPS.PA_COMP_PROFILE_PUB dependencies on PA_COMP_PROFILE_PVT

Line 71: PA_COMP_PROFILE_PVT.g_noof_errors := 0;

67:
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: -- Initialize the PL/SQL message stack
71: PA_COMP_PROFILE_PVT.g_noof_errors := 0;
72:
73: IF p_init_msg_list = FND_API.G_TRUE THEN
74: fnd_msg_pub.initialize;
75: END IF;

Line 99: IF PA_COMP_PROFILE_PVT.g_noof_errors = 1 THEN

95: -- values are invalid
96:
97: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: x_return_status:= FND_API.G_RET_STS_ERROR;
99: IF PA_COMP_PROFILE_PVT.g_noof_errors = 1 THEN
100: pa_interface_utils_pub.get_messages
101: (p_encoded => FND_API.G_TRUE,
102: p_msg_index => 1,
103: p_msg_count => x_msg_count ,

Line 108: x_msg_count := PA_COMP_PROFILE_PVT.g_noof_errors;

104: p_msg_data => l_msg_data ,
105: p_data => l_data,
106: p_msg_index_out => l_msg_index_out );
107: x_msg_data := l_data;
108: x_msg_count := PA_COMP_PROFILE_PVT.g_noof_errors;
109: ELSE
110: x_msg_count := PA_COMP_PROFILE_PVT.g_noof_errors;
111: END IF;
112:

Line 110: x_msg_count := PA_COMP_PROFILE_PVT.g_noof_errors;

106: p_msg_index_out => l_msg_index_out );
107: x_msg_data := l_data;
108: x_msg_count := PA_COMP_PROFILE_PVT.g_noof_errors;
109: ELSE
110: x_msg_count := PA_COMP_PROFILE_PVT.g_noof_errors;
111: END IF;
112:
113: IF l_enable_log = 'Y' THEN
114: pa_debug.reset_err_stack;

Line 120: PA_COMP_PROFILE_PVT.Add_competence_element

116:
117: RETURN;
118: END IF;
119:
120: PA_COMP_PROFILE_PVT.Add_competence_element
121: ( p_person_id => p_person_id,
122: p_competence_id => l_competence_id,
123: p_rating_level_id => l_rating_level_id,
124: p_effective_date_from => l_effective_date_from,

Line 130: x_msg_count := pa_comp_profile_pvt.g_noof_errors;

126: p_validate_only => p_validate_only,
127: x_return_status => l_return_status );
128:
129:
130: x_msg_count := pa_comp_profile_pvt.g_noof_errors;
131:
132: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
133: x_return_status:= FND_API.G_RET_STS_ERROR;
134: IF pa_comp_profile_pvt.g_noof_errors = 1 THEN

Line 134: IF pa_comp_profile_pvt.g_noof_errors = 1 THEN

130: x_msg_count := pa_comp_profile_pvt.g_noof_errors;
131:
132: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
133: x_return_status:= FND_API.G_RET_STS_ERROR;
134: IF pa_comp_profile_pvt.g_noof_errors = 1 THEN
135: pa_interface_utils_pub.get_messages
136: (p_encoded => FND_API.G_TRUE,
137: p_msg_index => 1,
138: p_msg_count => x_msg_count ,

Line 143: x_msg_count := pa_comp_profile_pvt.g_noof_errors;

139: p_msg_data => l_msg_data ,
140: p_data => l_data,
141: p_msg_index_out => l_msg_index_out );
142: x_msg_data := l_data;
143: x_msg_count := pa_comp_profile_pvt.g_noof_errors;
144: ELSE
145: x_msg_count := pa_comp_profile_pvt.g_noof_errors;
146: END IF;
147:

Line 145: x_msg_count := pa_comp_profile_pvt.g_noof_errors;

141: p_msg_index_out => l_msg_index_out );
142: x_msg_data := l_data;
143: x_msg_count := pa_comp_profile_pvt.g_noof_errors;
144: ELSE
145: x_msg_count := pa_comp_profile_pvt.g_noof_errors;
146: END IF;
147:
148: IF l_enable_log = 'Y' THEN
149: pa_debug.reset_err_stack;

Line 243: PA_COMP_PROFILE_PVT.g_noof_errors := 0;

239: x_return_status := FND_API.G_RET_STS_SUCCESS;
240:
241: -- Initialize the PL/SQL message stack
242:
243: PA_COMP_PROFILE_PVT.g_noof_errors := 0;
244:
245: IF p_init_msg_list = FND_API.G_TRUE THEN
246: fnd_msg_pub.initialize;
247: END IF;

Line 274: IF PA_COMP_PROFILE_PVT.g_noof_errors = 1 THEN

270: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
271:
272: -- dbms_output.put_line('Error in Validate Attributes');
273: x_return_status:= FND_API.G_RET_STS_ERROR;
274: IF PA_COMP_PROFILE_PVT.g_noof_errors = 1 THEN
275: pa_interface_utils_pub.get_messages
276: (p_encoded => FND_API.G_TRUE,
277: p_msg_index => 1,
278: p_msg_count => x_msg_count ,

Line 283: x_msg_count := PA_COMP_PROFILE_PVT.g_noof_errors;

279: p_msg_data => l_msg_data ,
280: p_data => l_data,
281: p_msg_index_out => l_msg_index_out );
282: x_msg_data := l_data;
283: x_msg_count := PA_COMP_PROFILE_PVT.g_noof_errors;
284: ELSE
285: x_msg_count := PA_COMP_PROFILE_PVT.g_noof_errors;
286: END IF;
287: IF l_enable_log = 'Y' THEN

Line 285: x_msg_count := PA_COMP_PROFILE_PVT.g_noof_errors;

281: p_msg_index_out => l_msg_index_out );
282: x_msg_data := l_data;
283: x_msg_count := PA_COMP_PROFILE_PVT.g_noof_errors;
284: ELSE
285: x_msg_count := PA_COMP_PROFILE_PVT.g_noof_errors;
286: END IF;
287: IF l_enable_log = 'Y' THEN
288: pa_debug.reset_err_stack;
289: END IF;

Line 293: PA_COMP_PROFILE_PVT.update_competence_element

289: END IF;
290: RETURN;
291: END IF;
292:
293: PA_COMP_PROFILE_PVT.update_competence_element
294: ( p_person_id => p_person_id
295: ,p_competence_id => l_competence_id
296: ,p_element_id => p_element_id
297: ,p_rating_level_id => l_rating_level_id

Line 309: IF pa_comp_profile_pvt.g_noof_errors = 1 THEN

305: x_return_status := l_return_status;
306:
307: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
308: x_return_status:= FND_API.G_RET_STS_ERROR;
309: IF pa_comp_profile_pvt.g_noof_errors = 1 THEN
310: pa_interface_utils_pub.get_messages
311: (p_encoded => FND_API.G_TRUE,
312: p_msg_index => 1,
313: p_msg_count => x_msg_count ,

Line 318: x_msg_count := pa_comp_profile_pvt.g_noof_errors;

314: p_msg_data => l_msg_data ,
315: p_data => l_data,
316: p_msg_index_out => l_msg_index_out );
317: x_msg_data := l_data;
318: x_msg_count := pa_comp_profile_pvt.g_noof_errors;
319: ELSE
320: x_msg_count := pa_comp_profile_pvt.g_noof_errors;
321: END IF;
322:

Line 320: x_msg_count := pa_comp_profile_pvt.g_noof_errors;

316: p_msg_index_out => l_msg_index_out );
317: x_msg_data := l_data;
318: x_msg_count := pa_comp_profile_pvt.g_noof_errors;
319: ELSE
320: x_msg_count := pa_comp_profile_pvt.g_noof_errors;
321: END IF;
322:
323: IF l_enable_log = 'Y' THEN
324: pa_debug.reset_err_stack;

Line 390: PA_COMP_PROFILE_PVT.delete_competence_element

386: l_msg_count NUMBER;
387: l_msg_index_out NUMBER := 0;
388: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
389: BEGIN
390: PA_COMP_PROFILE_PVT.delete_competence_element
391: ( p_person_id => p_person_id,
392: p_competence_id => p_competence_id,
393: p_element_id => p_element_id,
394: p_object_version_number => p_object_version_number,

Line 529: PA_COMP_PROFILE_PVT.Check_Error

525: AND competence_alias = l_in_competence_alias;
526: EXCEPTION
527: WHEN NO_DATA_FOUND THEN
528: l_return_status := FND_API.G_RET_STS_ERROR;
529: PA_COMP_PROFILE_PVT.Check_Error
530: (p_return_status => l_return_status,
531: p_error_message_code => 'PA_PRM_INVALID_ALIAS');
532:
533: END;

Line 555: PA_COMP_PROFILE_PVT.Check_Error

551: (nvl(l_in_competence_alias,l_old_comp_alias) <> l_old_comp_alias) OR
552: (nvl(l_in_competence_id,l_old_competence_id) <> l_old_competence_id)
553: THEN
554: l_return_status := FND_API.G_RET_STS_ERROR;
555: PA_COMP_PROFILE_PVT.Check_Error
556: (p_return_status => l_return_status,
557: p_error_message_code => 'PA_PRM_CANNOT_UPD_COMP');
558: END IF;
559: END IF;

Line 583: PA_COMP_PROFILE_PVT.Check_Error

579: ,x_error_msg_code => l_error_message_code);
580:
581:
582: -- dbms_output.put_line('After Calling Check_CompName_Or_Id: ' || l_return_status);
583: PA_COMP_PROFILE_PVT.Check_Error
584: (p_return_status => l_return_status,
585: p_error_message_code => l_error_message_code );
586:
587: --If the return status is invalid, we cannot proceed further

Line 610: PA_COMP_PROFILE_PVT.Check_Error

606: FROM per_competence_elements
607: WHERE competence_element_id = p_element_id;
608:
609: IF l_old_competence_id <> l_competence_id THEN
610: PA_COMP_PROFILE_PVT.Check_Error
611: (p_return_status => FND_API.G_RET_STS_ERROR,
612: p_error_message_code => 'PA_PRM_CANNOT_UPD_COMP');
613: END IF;
614: EXCEPTION

Line 644: PA_COMP_PROFILE_PVT.Check_Error

640: AND competence_id=x_competence_id;
641: EXCEPTION
642: WHEN NO_DATA_FOUND THEN
643: l_return_status := FND_API.G_RET_STS_ERROR;
644: PA_COMP_PROFILE_PVT.Check_Error
645: (p_return_status => l_return_status,
646: p_error_message_code => 'PA_PRM_INVALID_DATE');
647: END;
648:

Line 684: PA_COMP_PROFILE_PVT.Check_Error

680: ,x_error_msg_code => l_error_message_code) ;
681:
682: -- dbms_output.put_line('After Calling Check_Rating_Level_Or_Id: ' || l_return_status);
683:
684: PA_COMP_PROFILE_PVT.Check_Error
685: (p_return_status => l_return_status,
686: p_error_message_code => l_error_message_code );
687:
688: IF PA_COMP_PROFILE_PVT.g_noof_errors > 0 THEN

Line 688: IF PA_COMP_PROFILE_PVT.g_noof_errors > 0 THEN

684: PA_COMP_PROFILE_PVT.Check_Error
685: (p_return_status => l_return_status,
686: p_error_message_code => l_error_message_code );
687:
688: IF PA_COMP_PROFILE_PVT.g_noof_errors > 0 THEN
689: x_return_status:= FND_API.G_RET_STS_ERROR;
690: ELSE
691: x_return_status:= FND_API.G_RET_STS_SUCCESS;
692: END IF;

Line 717: PA_COMP_PROFILE_PVT.Start_Approval_Process

713: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
714: IS
715: BEGIN
716: /* --this API has been stubbed out for Bug:4665696
717: PA_COMP_PROFILE_PVT.Start_Approval_Process
718: (x_return_status => x_return_status,
719: x_msg_count => x_msg_count,
720: x_msg_data => x_msg_data);
721: --this API has been stubbed out for Bug:4665696

Line 744: PA_COMP_PROFILE_PVT.Update_HR

740: --
741:
742: IF (funcmode = 'RUN') THEN
743:
744: PA_COMP_PROFILE_PVT.Update_HR
745: (p_profile_id => to_number(itemkey),
746: x_return_status => l_return_status,
747: x_msg_count => l_msg_count,
748: x_msg_data => l_msg_data);

Line 750: -- dbms_output.put_line('After PA_COMP_PROFILE_PVT.Update_H');

746: x_return_status => l_return_status,
747: x_msg_count => l_msg_count,
748: x_msg_data => l_msg_data);
749:
750: -- dbms_output.put_line('After PA_COMP_PROFILE_PVT.Update_H');
751: resultout := 'COMPLETE';
752: return;
753:
754: END IF;

Line 788: PA_COMP_PROFILE_PVT.Clear_Temp_Table

784:
785:
786: IF (funcmode = 'RUN') THEN
787:
788: PA_COMP_PROFILE_PVT.Clear_Temp_Table
789: (p_profile_id => to_number(itemkey),
790: x_return_status => l_return_status,
791: x_msg_count => l_msg_count,
792: x_msg_data => l_msg_data);

Line 794: -- dbms_output.put_line('After PA_COMP_PROFILE_PVT.Update_H');

790: x_return_status => l_return_status,
791: x_msg_count => l_msg_count,
792: x_msg_data => l_msg_data);
793:
794: -- dbms_output.put_line('After PA_COMP_PROFILE_PVT.Update_H');
795: resultout := 'COMPLETE';
796: return;
797:
798: END IF;

Line 820: PA_COMP_PROFILE_PVT.approval_message_body

816: document in out NOCOPY varchar2, --File.Sql.39 bug 4440895
817: document_type in out NOCOPY varchar2) --File.Sql.39 bug 4440895
818: IS
819: BEGIN
820: PA_COMP_PROFILE_PVT.approval_message_body
821: (document_id => document_id,
822: display_type => display_type,
823: document => document,
824: document_type => document_type);