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;
76:
77: -- Do the standard public api checks
78: validate_attributes
166: IF p_commit = FND_API.G_TRUE THEN
167: ROLLBACK TO COMPETENCE_PUB_ADD_COMP_ELE;
168: END IF;
169:
170: fnd_msg_pub.add_exc_msg
171: (p_pkg_name => 'PA_COMP_PROFILE_PUB',
172: p_procedure_name => pa_debug.g_err_stack );
173:
174: x_msg_count := 1;
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;
248:
249: -- Validate the atttributes
250:
344: IF p_commit = FND_API.G_TRUE THEN
345: ROLLBACK TO COMPETENCE_PUB_UPD_COMP_ELE;
346: END IF;
347:
348: fnd_msg_pub.add_exc_msg
349: (p_pkg_name => 'PA_COMP_PROFILE_PUB',
350: p_procedure_name => pa_debug.g_err_stack );
351:
352: x_msg_count := 1;
399: WHEN OTHERS THEN
400:
401: l_err := SQLERRM;
402:
403: fnd_msg_pub.add_exc_msg
404: (p_pkg_name => 'PA_COMP_PROFILE_PUB',
405: p_procedure_name => 'delete_competence_element');
406:
407: x_msg_count := 1;