DBA Data[Home] [Help]

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_CANDIDATE_PUB

Line 12885: pa_debug.write(l_module, 'Calling core API PA_CANDIDATE_PUB.ADD_CANDIDATE', l_log_level);

12881:
12882: IF l_error_flag_local <> 'Y' THEN
12883: -- Core API call
12884: IF l_debug_mode = 'Y' THEN
12885: pa_debug.write(l_module, 'Calling core API PA_CANDIDATE_PUB.ADD_CANDIDATE', l_log_level);
12886: END IF;
12887:
12888: PA_CANDIDATE_PUB.ADD_CANDIDATE(
12889: p_assignment_id => l_candidate_in_rec.requirement_id,

Line 12888: PA_CANDIDATE_PUB.ADD_CANDIDATE(

12884: IF l_debug_mode = 'Y' THEN
12885: pa_debug.write(l_module, 'Calling core API PA_CANDIDATE_PUB.ADD_CANDIDATE', l_log_level);
12886: END IF;
12887:
12888: PA_CANDIDATE_PUB.ADD_CANDIDATE(
12889: p_assignment_id => l_candidate_in_rec.requirement_id,
12890: p_resource_name => null,
12891: -- p_resource_id => l_candidate_in_rec.resource_id,
12892: -- for bug#8280206. resource id should be passed as null from create AMG API

Line 12921: pa_debug.write(l_module, 'After call PA_CANDIDATE_PUB.ADD_CANDIDATE l_return_status='||l_return_status, l_log_level);

12917: x_return_status => l_return_status,
12918: x_msg_count => l_msg_count,
12919: x_msg_data => l_msg_data);
12920: IF l_debug_mode = 'Y' THEN
12921: pa_debug.write(l_module, 'After call PA_CANDIDATE_PUB.ADD_CANDIDATE l_return_status='||l_return_status, l_log_level);
12922: END IF;
12923: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
12924: x_candidate_id_tbl.extend(1);
12925: OPEN c_get_candidate_id(l_candidate_in_rec.requirement_id, l_candidate_in_rec.resource_id);

Line 13422: pa_debug.write(l_module, 'Calling PA_CANDIDATE_PUB.UPDATE_CANDIDATE for Record#'||i, l_log_level);

13418: IF l_error_flag_local <> 'Y' THEN
13419: l_return_status := FND_API.G_RET_STS_SUCCESS;
13420:
13421: IF l_debug_mode = 'Y' THEN
13422: pa_debug.write(l_module, 'Calling PA_CANDIDATE_PUB.UPDATE_CANDIDATE for Record#'||i, l_log_level);
13423: END IF;
13424:
13425: PA_CANDIDATE_PUB.UPDATE_CANDIDATE
13426: (

Line 13425: PA_CANDIDATE_PUB.UPDATE_CANDIDATE

13421: IF l_debug_mode = 'Y' THEN
13422: pa_debug.write(l_module, 'Calling PA_CANDIDATE_PUB.UPDATE_CANDIDATE for Record#'||i, l_log_level);
13423: END IF;
13424:
13425: PA_CANDIDATE_PUB.UPDATE_CANDIDATE
13426: (
13427: p_candidate_id => l_candidate_in_rec.candidate_id
13428: , p_status_code => l_candidate_in_rec.status_code
13429: , p_ranking => l_candidate_in_rec.ranking

Line 13458: pa_debug.write(l_module, 'After call PA_CANDIDATE_PUB.UPDATE_CANDIDATE l_return_status='||l_return_status, l_log_level);

13454: , x_return_status => l_return_status
13455: );
13456:
13457: IF l_debug_mode = 'Y' THEN
13458: pa_debug.write(l_module, 'After call PA_CANDIDATE_PUB.UPDATE_CANDIDATE l_return_status='||l_return_status, l_log_level);
13459: END IF;
13460:
13461: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13462: l_error_flag_local := 'Y';

Line 13464: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.UPDATE_CANDIDATE unsuccessful', l_log_level);

13460:
13461: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13462: l_error_flag_local := 'Y';
13463: IF l_debug_mode = 'Y' THEN
13464: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.UPDATE_CANDIDATE unsuccessful', l_log_level);
13465: END IF;
13466: ELSE
13467: IF l_debug_mode = 'Y' THEN
13468: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.UPDATE_CANDIDATE successful', l_log_level);

Line 13468: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.UPDATE_CANDIDATE successful', l_log_level);

13464: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.UPDATE_CANDIDATE unsuccessful', l_log_level);
13465: END IF;
13466: ELSE
13467: IF l_debug_mode = 'Y' THEN
13468: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.UPDATE_CANDIDATE successful', l_log_level);
13469: pa_debug.write(l_module, 'Updated record_version_number = '||l_record_version_number, l_log_level);
13470: END IF;
13471: END IF;
13472: END IF;

Line 13866: pa_debug.write(l_module, 'Calling PA_CANDIDATE_PUB.DELETE_CANDIDATES for Record#'||i, l_log_level);

13862: IF l_error_flag_local <> 'Y' THEN
13863: l_return_status := FND_API.G_RET_STS_SUCCESS;
13864:
13865: IF l_debug_mode = 'Y' THEN
13866: pa_debug.write(l_module, 'Calling PA_CANDIDATE_PUB.DELETE_CANDIDATES for Record#'||i, l_log_level);
13867: END IF;
13868:
13869: PA_CANDIDATE_PUB.DELETE_CANDIDATES
13870: (

Line 13869: PA_CANDIDATE_PUB.DELETE_CANDIDATES

13865: IF l_debug_mode = 'Y' THEN
13866: pa_debug.write(l_module, 'Calling PA_CANDIDATE_PUB.DELETE_CANDIDATES for Record#'||i, l_log_level);
13867: END IF;
13868:
13869: PA_CANDIDATE_PUB.DELETE_CANDIDATES
13870: (
13871: p_assignment_id => l_candidate_in_rec.requirement_id
13872: , p_status_code => null
13873: , x_return_status => l_return_status

Line 13879: pa_debug.write(l_module, 'After call PA_CANDIDATE_PUB.DELETE_CANDIDATES l_return_status='||l_return_status, l_log_level);

13875: , x_msg_data => l_msg_data
13876: );
13877:
13878: IF l_debug_mode = 'Y' THEN
13879: pa_debug.write(l_module, 'After call PA_CANDIDATE_PUB.DELETE_CANDIDATES l_return_status='||l_return_status, l_log_level);
13880: END IF;
13881:
13882: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13883: l_error_flag_local := 'Y';

Line 13885: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.DELETE_CANDIDATES unsuccessful', l_log_level);

13881:
13882: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13883: l_error_flag_local := 'Y';
13884: IF l_debug_mode = 'Y' THEN
13885: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.DELETE_CANDIDATES unsuccessful', l_log_level);
13886: END IF;
13887: ELSE
13888: IF l_debug_mode = 'Y' THEN
13889: pa_debug.write(l_module, 'Calling PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW for Record#'||i, l_log_level);

Line 13909: pa_debug.write(l_module, 'PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW and PA_CANDIDATE_PUB.DELETE_CANDIDATES successful', l_log_level);

13905: pa_debug.write(l_module, 'PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW unsuccessful', l_log_level);
13906: END IF;
13907: ELSE
13908: IF l_debug_mode = 'Y' THEN
13909: pa_debug.write(l_module, 'PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW and PA_CANDIDATE_PUB.DELETE_CANDIDATES successful', l_log_level);
13910: END IF;
13911: END IF;
13912: END IF;
13913: END IF;

Line 14338: pa_debug.write(l_module, 'Calling PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG for Record#'||i, l_log_level);

14334: IF l_error_flag_local <> 'Y' THEN
14335: l_return_status := FND_API.G_RET_STS_SUCCESS;
14336:
14337: IF l_debug_mode = 'Y' THEN
14338: pa_debug.write(l_module, 'Calling PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG for Record#'||i, l_log_level);
14339: END IF;
14340:
14341: PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG
14342: (

Line 14341: PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG

14337: IF l_debug_mode = 'Y' THEN
14338: pa_debug.write(l_module, 'Calling PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG for Record#'||i, l_log_level);
14339: END IF;
14340:
14341: PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG
14342: (
14343: p_candidate_id => l_candidate_log_tbl.candidate_id
14344: , p_status_code => l_candidate_log_tbl.status_code
14345: , p_change_reason_code => l_candidate_log_tbl.change_reason_code

Line 14373: pa_debug.write(l_module, 'After call PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG l_return_status='||l_return_status, l_log_level);

14369: , x_msg_data => l_msg_data
14370: );
14371:
14372: IF l_debug_mode = 'Y' THEN
14373: pa_debug.write(l_module, 'After call PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG l_return_status='||l_return_status, l_log_level);
14374: END IF;
14375:
14376: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
14377: x_candidate_review_id_tbl.extend(1);

Line 14380: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG successful', l_log_level);

14376: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
14377: x_candidate_review_id_tbl.extend(1);
14378: x_candidate_review_id_tbl(x_candidate_review_id_tbl.COUNT) := l_cand_record_version_number;
14379: IF l_debug_mode = 'Y' THEN
14380: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG successful', l_log_level);
14381: END IF;
14382: ELSE
14383: l_error_flag_local := 'Y';
14384: x_candidate_review_id_tbl.extend(1);

Line 14387: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG unsuccessful', l_log_level);

14383: l_error_flag_local := 'Y';
14384: x_candidate_review_id_tbl.extend(1);
14385: x_candidate_review_id_tbl(x_candidate_review_id_tbl.COUNT) := -1;
14386: IF l_debug_mode = 'Y' THEN
14387: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG unsuccessful', l_log_level);
14388: END IF;
14389: END IF;
14390: ELSE
14391: x_candidate_review_id_tbl.extend(1);