DBA Data[Home] [Help]

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_COMPETENCE_PUB

Line 11202: --- Calling pa_competence_pub.Add_competence_elemets

11198:
11199: END IF;
11200:
11201:
11202: --- Calling pa_competence_pub.Add_competence_elemets
11203: IF l_local_error_flag <> 'Y' THEN
11204: -- No error occured.ie local error Flag is N
11205: IF l_debug_mode = 'Y' THEN
11206: pa_debug.write(l_module, 'Calling PA_COMPETENCE_PUB.ADD_COMPETENCE_ELEMENT ', l_debug_level);

Line 11206: pa_debug.write(l_module, 'Calling PA_COMPETENCE_PUB.ADD_COMPETENCE_ELEMENT ', l_debug_level);

11202: --- Calling pa_competence_pub.Add_competence_elemets
11203: IF l_local_error_flag <> 'Y' THEN
11204: -- No error occured.ie local error Flag is N
11205: IF l_debug_mode = 'Y' THEN
11206: pa_debug.write(l_module, 'Calling PA_COMPETENCE_PUB.ADD_COMPETENCE_ELEMENT ', l_debug_level);
11207: END IF ;
11208: l_return_status := FND_API.G_RET_STS_SUCCESS;
11209: -- Calling Internal API to Add competence
11210: PA_COMPETENCE_PUB.ADD_COMPETENCE_ELEMENT(

Line 11210: PA_COMPETENCE_PUB.ADD_COMPETENCE_ELEMENT(

11206: pa_debug.write(l_module, 'Calling PA_COMPETENCE_PUB.ADD_COMPETENCE_ELEMENT ', l_debug_level);
11207: END IF ;
11208: l_return_status := FND_API.G_RET_STS_SUCCESS;
11209: -- Calling Internal API to Add competence
11210: PA_COMPETENCE_PUB.ADD_COMPETENCE_ELEMENT(
11211: p_object_name => 'OPEN_ASSIGNMENT'
11212: , p_object_id => l_competence_in_rec.requirement_id
11213: , p_competence_id => l_competence_in_rec.competence_id
11214: , p_competence_alias => l_competence_in_rec.competence_alias

Line 11229: pa_debug.write(l_module, 'After Calling PA_COMPETENCE_PUB.ADD_COMPETENCE_ELEMENT ', l_debug_level);

11225: , x_msg_count => l_msg_count
11226: , x_msg_data => l_msg_data);
11227:
11228: IF l_debug_mode = 'Y' THEN
11229: pa_debug.write(l_module, 'After Calling PA_COMPETENCE_PUB.ADD_COMPETENCE_ELEMENT ', l_debug_level);
11230: pa_debug.write(l_module, 'l_return_status '|| l_return_status || 'for record '|| i , l_debug_level);
11231: END IF ;
11232:
11233: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 11258: pa_debug.write(l_module, 'After Calling PA_COMPETENCE_PUB.ADD_COMPETENCE_ELEMENT ', l_debug_level);

11254: IF l_local_error_flag = 'Y' OR l_loop_msg_count > 0 THEN
11255: l_error_flag := 'Y';
11256:
11257: IF l_debug_mode = 'Y' THEN
11258: pa_debug.write(l_module, 'After Calling PA_COMPETENCE_PUB.ADD_COMPETENCE_ELEMENT ', l_debug_level);
11259: END IF ;
11260:
11261: FOR j in l_start_msg_count+1..l_end_msg_count LOOP
11262: FND_MSG_PUB.get (

Line 11280: pa_debug.write(l_module, 'Out Of PA_COMPETENCE_PUB.ADD_COMPETENCE_ELEMENT API calling Loop', l_debug_level);

11276: i := P_COMPETENCE_IN_TBL.next(i);
11277: END LOOP;
11278: -- End of Loop(Record Loop)
11279: IF l_debug_mode = 'Y' THEN
11280: pa_debug.write(l_module, 'Out Of PA_COMPETENCE_PUB.ADD_COMPETENCE_ELEMENT API calling Loop', l_debug_level);
11281: END IF ;
11282:
11283: IF l_error_flag = 'Y' OR FND_MSG_PUB.count_msg > 0 THEN
11284: RAISE FND_API.G_EXC_ERROR;

Line 11797: pa_debug.write(l_module, 'Calling PA_COMPETENCE_PUB.UPDATE_COMPETENCE_ELEMENT ', l_debug_level);

11793:
11794: IF l_local_error_flag <> 'Y' THEN
11795: -- No error occured.ie local error Flag is N
11796: IF l_debug_mode = 'Y' THEN
11797: pa_debug.write(l_module, 'Calling PA_COMPETENCE_PUB.UPDATE_COMPETENCE_ELEMENT ', l_debug_level);
11798: END IF ;
11799:
11800: l_return_status := FND_API.G_RET_STS_SUCCESS;
11801:

Line 11802: PA_COMPETENCE_PUB.UPDATE_COMPETENCE_ELEMENT(

11798: END IF ;
11799:
11800: l_return_status := FND_API.G_RET_STS_SUCCESS;
11801:
11802: PA_COMPETENCE_PUB.UPDATE_COMPETENCE_ELEMENT(
11803: p_object_name =>'OPEN_ASSIGNMENT'
11804: , p_object_id => l_competence_in_rec.requirement_id
11805: , p_competence_id => l_competence_in_rec.competence_id
11806: , p_competence_alias => l_competence_in_rec.competence_alias

Line 11823: pa_debug.write(l_module, 'After Calling PA_COMPETENCE_PUB.UPDATE_COMPETENCE_ELEMENT ', l_debug_level);

11819: , x_msg_data => l_msg_data
11820: , x_return_status => l_return_status);
11821:
11822: IF l_debug_mode = 'Y' THEN
11823: pa_debug.write(l_module, 'After Calling PA_COMPETENCE_PUB.UPDATE_COMPETENCE_ELEMENT ', l_debug_level);
11824: pa_debug.write(l_module, 'l_return_status '|| l_return_status || 'for record '|| i , l_debug_level);
11825: END IF ;
11826: END IF;-- end of API call..
11827:

Line 11838: pa_debug.write(l_module, 'After Calling PA_COMPETENCE_PUB.UPDATE_COMPETENCE_ELEMENT ', l_debug_level);

11834:
11835: IF l_local_error_flag = 'Y' OR l_loop_msg_count > 0 THEN
11836: l_error_flag := 'Y';
11837: IF l_debug_mode = 'Y' THEN
11838: pa_debug.write(l_module, 'After Calling PA_COMPETENCE_PUB.UPDATE_COMPETENCE_ELEMENT ', l_debug_level);
11839: END IF ;
11840: FOR j in l_start_msg_count+1..l_end_msg_count LOOP
11841: FND_MSG_PUB.get (
11842: p_msg_index => l_start_msg_count+1

Line 11859: pa_debug.write(l_module,'Out Of PA_COMPETENCE_PUB.UPDATE_COMPETENCE_ELEMENT API calling Loop', l_debug_level);

11855: i := p_competence_in_tbl.next(i);
11856: END LOOP; -- end if Internal API call Loop
11857:
11858: IF l_debug_mode = 'Y' THEN
11859: pa_debug.write(l_module,'Out Of PA_COMPETENCE_PUB.UPDATE_COMPETENCE_ELEMENT API calling Loop', l_debug_level);
11860: END IF ;
11861:
11862: IF l_error_flag = 'Y' OR FND_MSG_PUB.count_msg > 0 THEN
11863: RAISE FND_API.G_EXC_ERROR;

Line 12305: pa_debug.write(l_module, 'Calling PA_COMPETENCE_PUB.DELETE_COMPETENCE_ELEMENT', l_debug_level);

12301:
12302: IF l_local_error_flag <> 'Y' THEN
12303: -- No error occured.ie local error Flag is N
12304: IF l_debug_mode = 'Y' THEN
12305: pa_debug.write(l_module, 'Calling PA_COMPETENCE_PUB.DELETE_COMPETENCE_ELEMENT', l_debug_level);
12306: END IF ;
12307:
12308: l_return_status := FND_API.G_RET_STS_SUCCESS;
12309:

Line 12310: PA_COMPETENCE_PUB.DELETE_COMPETENCE_ELEMENT(

12306: END IF ;
12307:
12308: l_return_status := FND_API.G_RET_STS_SUCCESS;
12309:
12310: PA_COMPETENCE_PUB.DELETE_COMPETENCE_ELEMENT(
12311: p_object_name => 'OPEN_ASSIGNMENT'
12312: , p_object_id => l_competence_in_rec.requirement_id
12313: , p_competence_id => l_competence_in_rec.competence_id
12314: , p_competence_alias => l_competence_in_rec.competence_alias

Line 12327: pa_debug.write(l_module,'After Calling PA_COMPETENCE_PUB.DELETE_COMPETENCE_ELEMENT ', l_debug_level);

12323: , x_msg_count => l_msg_count
12324: , x_msg_data => l_msg_data);
12325:
12326: IF l_debug_mode = 'Y' THEN
12327: pa_debug.write(l_module,'After Calling PA_COMPETENCE_PUB.DELETE_COMPETENCE_ELEMENT ', l_debug_level);
12328: pa_debug.write(l_module,'l_return_status '|| l_return_status || 'for record '|| i , l_debug_level);
12329: END IF ;
12330:
12331: END IF;-- end of API call..

Line 12343: pa_debug.write(l_module,'After Calling PA_COMPETENCE_PUB.DELETE_COMPETENCE_ELEMENT ', l_debug_level);

12339:
12340: IF l_local_error_flag = 'Y' OR l_loop_msg_count > 0 THEN
12341: l_error_flag := 'Y';
12342: IF l_debug_mode = 'Y' THEN
12343: pa_debug.write(l_module,'After Calling PA_COMPETENCE_PUB.DELETE_COMPETENCE_ELEMENT ', l_debug_level);
12344: END IF ;
12345: FOR j in l_start_msg_count+1..l_end_msg_count LOOP
12346: FND_MSG_PUB.GET (
12347: p_msg_index => l_start_msg_count+1

Line 12363: pa_debug.write(l_module,'Out Of PA_COMPETENCE_PUB.DELETE_COMPETENCE_ELEMENT API calling Loop', l_debug_level);

12359: i := p_competence_in_tbl.next(i);
12360: END LOOP; -- end if Internal API call Loop
12361:
12362: IF l_debug_mode = 'Y' THEN
12363: pa_debug.write(l_module,'Out Of PA_COMPETENCE_PUB.DELETE_COMPETENCE_ELEMENT API calling Loop', l_debug_level);
12364: END IF ;
12365:
12366: IF l_error_flag = 'Y' OR FND_MSG_PUB.count_msg > 0 THEN
12367: RAISE FND_API.G_EXC_ERROR;