APPS.PA_COMPETENCE_PUB dependencies on STANDARD

Line 55: -- Do the standard public api checks

51: IF p_init_msg_list = FND_API.G_TRUE THEN
52: fnd_msg_pub.initialize;
53: END IF;
54:
55: -- Do the standard public api checks
56: standard_pub_checks
57: (p_object_name => p_object_name,
58: p_object_id => p_object_id,
59: p_competence_id => p_competence_id,

Line 56: standard_pub_checks

52: fnd_msg_pub.initialize;
53: END IF;
54:
55: -- Do the standard public api checks
56: standard_pub_checks
57: (p_object_name => p_object_name,
58: p_object_id => p_object_id,
59: p_competence_id => p_competence_id,
60: p_competence_alias => p_competence_alias,

Line 228: -- Do the standard public api checks

224: ELSE
225: l_element_id := p_element_id;
226: END IF;
227:
228: -- Do the standard public api checks
229: standard_pub_checks
230: (p_element_id => l_element_id,
231: p_object_name => p_object_name,
232: p_object_id => p_object_id,

Line 229: standard_pub_checks

225: l_element_id := p_element_id;
226: END IF;
227:
228: -- Do the standard public api checks
229: standard_pub_checks
230: (p_element_id => l_element_id,
231: p_object_name => p_object_name,
232: p_object_id => p_object_id,
233: p_competence_id => p_competence_id,

Line 372: -- Do the standard public api checks

368: IF p_init_msg_list = FND_API.G_TRUE THEN
369: fnd_msg_pub.initialize;
370: END IF;
371:
372: -- Do the standard public api checks
373: standard_pub_checks
374: (p_object_name => p_object_name,
375: p_object_id => p_object_id,
376: p_competence_id => p_competence_id,

Line 373: standard_pub_checks

369: fnd_msg_pub.initialize;
370: END IF;
371:
372: -- Do the standard public api checks
373: standard_pub_checks
374: (p_object_name => p_object_name,
375: p_object_id => p_object_id,
376: p_competence_id => p_competence_id,
377: p_competence_alias => p_competence_alias,

Line 470: PROCEDURE standard_pub_checks

466:
467: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
468: END delete_competence_element;
469:
470: PROCEDURE standard_pub_checks
471: (
472: p_element_id IN NUMBER := null,
473: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
474: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,

Line 500: pa_debug.init_err_stack ('pa_competence_pub.standard_pub_checks');

496: l_old_comp_name VARCHAR2(240);
497: l_old_comp_alias VARCHAR2(30);
498: l_exists VARCHAR2(1);
499: BEGIN
500: pa_debug.init_err_stack ('pa_competence_pub.standard_pub_checks');
501: x_return_status:= FND_API.G_RET_STS_SUCCESS;
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

Line 651: p_procedure_name => 'standard_pub_checks',

647: x_competence_id := NULL ;
648: x_rating_level_id := NULL ;
649:
650: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_COMPETENCE_PUB',
651: p_procedure_name => 'standard_pub_checks',
652: P_ERROR_TEXT => SUBSTRB(SQLERRM,1,240));
653: -- 4537865 : End
654: RAISE;
655: END standard_pub_checks;

Line 655: END standard_pub_checks;

651: p_procedure_name => 'standard_pub_checks',
652: P_ERROR_TEXT => SUBSTRB(SQLERRM,1,240));
653: -- 4537865 : End
654: RAISE;
655: END standard_pub_checks;
656:
657: /* --------------------------------------------------------------------
658: PROCEDURE: Mass_Exec_Process_Competences
659: PURPOSE : This API is called from the client side when competences

Line 698: --This API is only called to do standard validations

694: l_competence_id_tbl SYSTEM.pa_num_tbl_type := p_competence_id_tbl;
695:
696: BEGIN
697:
698: --This API is only called to do standard validations
699:
700: x_return_status := FND_API.G_RET_STS_SUCCESS;
701:
702: -- Initialize the PL/SQL message stack

Line 726: standard_pub_checks

722:
723: IF p_competence_id_tbl.count > 0 THEN
724: FOR j in 1..p_assignment_id_tbl.count LOOP
725: FOR i in 1..p_competence_id_tbl.count LOOP
726: standard_pub_checks
727: (p_element_id => l_element_id,
728: p_object_name => 'OPEN_ASSIGNMENT',
729: p_object_id => p_assignment_id_tbl(J),
730: p_competence_id => l_competence_id_tbl(I),