DBA Data[Home] [Help]

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_CANDIDATE_PUB

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

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

Line 12886: PA_CANDIDATE_PUB.ADD_CANDIDATE(

12882: IF l_debug_mode = 'Y' THEN
12883: pa_debug.write(l_module, 'Calling core API PA_CANDIDATE_PUB.ADD_CANDIDATE', l_log_level);
12884: END IF;
12885:
12886: PA_CANDIDATE_PUB.ADD_CANDIDATE(
12887: p_assignment_id => l_candidate_in_rec.requirement_id,
12888: p_resource_name => null,
12889: p_resource_id => l_candidate_in_rec.resource_id,
12890: p_status_code => l_candidate_in_rec.status_code,

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

12896: x_return_status => l_return_status,
12897: x_msg_count => l_msg_count,
12898: x_msg_data => l_msg_data);
12899: IF l_debug_mode = 'Y' THEN
12900: pa_debug.write(l_module, 'After call PA_CANDIDATE_PUB.ADD_CANDIDATE l_return_status='||l_return_status, l_log_level);
12901: END IF;
12902: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
12903: x_candidate_id_tbl.extend(1);
12904: OPEN c_get_candidate_id(l_candidate_in_rec.requirement_id, l_candidate_in_rec.resource_id);

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

13397: IF l_error_flag_local <> 'Y' THEN
13398: l_return_status := FND_API.G_RET_STS_SUCCESS;
13399:
13400: IF l_debug_mode = 'Y' THEN
13401: pa_debug.write(l_module, 'Calling PA_CANDIDATE_PUB.UPDATE_CANDIDATE for Record#'||i, l_log_level);
13402: END IF;
13403:
13404: PA_CANDIDATE_PUB.UPDATE_CANDIDATE
13405: (

Line 13404: PA_CANDIDATE_PUB.UPDATE_CANDIDATE

13400: IF l_debug_mode = 'Y' THEN
13401: pa_debug.write(l_module, 'Calling PA_CANDIDATE_PUB.UPDATE_CANDIDATE for Record#'||i, l_log_level);
13402: END IF;
13403:
13404: PA_CANDIDATE_PUB.UPDATE_CANDIDATE
13405: (
13406: p_candidate_id => l_candidate_in_rec.candidate_id
13407: , p_status_code => l_candidate_in_rec.status_code
13408: , p_ranking => l_candidate_in_rec.ranking

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

13416: , x_return_status => l_return_status
13417: );
13418:
13419: IF l_debug_mode = 'Y' THEN
13420: pa_debug.write(l_module, 'After call PA_CANDIDATE_PUB.UPDATE_CANDIDATE l_return_status='||l_return_status, l_log_level);
13421: END IF;
13422:
13423: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13424: l_error_flag_local := 'Y';

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

13422:
13423: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13424: l_error_flag_local := 'Y';
13425: IF l_debug_mode = 'Y' THEN
13426: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.UPDATE_CANDIDATE unsuccessful', l_log_level);
13427: END IF;
13428: ELSE
13429: IF l_debug_mode = 'Y' THEN
13430: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.UPDATE_CANDIDATE successful', l_log_level);

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

13426: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.UPDATE_CANDIDATE unsuccessful', l_log_level);
13427: END IF;
13428: ELSE
13429: IF l_debug_mode = 'Y' THEN
13430: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.UPDATE_CANDIDATE successful', l_log_level);
13431: pa_debug.write(l_module, 'Updated record_version_number = '||l_record_version_number, l_log_level);
13432: END IF;
13433: END IF;
13434: END IF;

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

13824: IF l_error_flag_local <> 'Y' THEN
13825: l_return_status := FND_API.G_RET_STS_SUCCESS;
13826:
13827: IF l_debug_mode = 'Y' THEN
13828: pa_debug.write(l_module, 'Calling PA_CANDIDATE_PUB.DELETE_CANDIDATES for Record#'||i, l_log_level);
13829: END IF;
13830:
13831: PA_CANDIDATE_PUB.DELETE_CANDIDATES
13832: (

Line 13831: PA_CANDIDATE_PUB.DELETE_CANDIDATES

13827: IF l_debug_mode = 'Y' THEN
13828: pa_debug.write(l_module, 'Calling PA_CANDIDATE_PUB.DELETE_CANDIDATES for Record#'||i, l_log_level);
13829: END IF;
13830:
13831: PA_CANDIDATE_PUB.DELETE_CANDIDATES
13832: (
13833: p_assignment_id => l_candidate_in_rec.requirement_id
13834: , p_status_code => null
13835: , x_return_status => l_return_status

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

13837: , x_msg_data => l_msg_data
13838: );
13839:
13840: IF l_debug_mode = 'Y' THEN
13841: pa_debug.write(l_module, 'After call PA_CANDIDATE_PUB.DELETE_CANDIDATES l_return_status='||l_return_status, l_log_level);
13842: END IF;
13843:
13844: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13845: l_error_flag_local := 'Y';

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

13843:
13844: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13845: l_error_flag_local := 'Y';
13846: IF l_debug_mode = 'Y' THEN
13847: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.DELETE_CANDIDATES unsuccessful', l_log_level);
13848: END IF;
13849: ELSE
13850: IF l_debug_mode = 'Y' THEN
13851: pa_debug.write(l_module, 'Calling PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW for Record#'||i, l_log_level);

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

13867: pa_debug.write(l_module, 'PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW unsuccessful', l_log_level);
13868: END IF;
13869: ELSE
13870: IF l_debug_mode = 'Y' THEN
13871: pa_debug.write(l_module, 'PA_PROJECT_ASSIGNMENTS_PKG.UPDATE_ROW and PA_CANDIDATE_PUB.DELETE_CANDIDATES successful', l_log_level);
13872: END IF;
13873: END IF;
13874: END IF;
13875: END IF;

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

14296: IF l_error_flag_local <> 'Y' THEN
14297: l_return_status := FND_API.G_RET_STS_SUCCESS;
14298:
14299: IF l_debug_mode = 'Y' THEN
14300: pa_debug.write(l_module, 'Calling PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG for Record#'||i, l_log_level);
14301: END IF;
14302:
14303: PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG
14304: (

Line 14303: PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG

14299: IF l_debug_mode = 'Y' THEN
14300: pa_debug.write(l_module, 'Calling PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG for Record#'||i, l_log_level);
14301: END IF;
14302:
14303: PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG
14304: (
14305: p_candidate_id => l_candidate_log_tbl.candidate_id
14306: , p_status_code => l_candidate_log_tbl.status_code
14307: , p_change_reason_code => l_candidate_log_tbl.change_reason_code

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

14314: , x_msg_data => l_msg_data
14315: );
14316:
14317: IF l_debug_mode = 'Y' THEN
14318: pa_debug.write(l_module, 'After call PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG l_return_status='||l_return_status, l_log_level);
14319: END IF;
14320:
14321: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
14322: x_candidate_review_id_tbl.extend(1);

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

14321: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
14322: x_candidate_review_id_tbl.extend(1);
14323: x_candidate_review_id_tbl(x_candidate_review_id_tbl.COUNT) := l_cand_record_version_number;
14324: IF l_debug_mode = 'Y' THEN
14325: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG successful', l_log_level);
14326: END IF;
14327: ELSE
14328: l_error_flag_local := 'Y';
14329: x_candidate_review_id_tbl.extend(1);

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

14328: l_error_flag_local := 'Y';
14329: x_candidate_review_id_tbl.extend(1);
14330: x_candidate_review_id_tbl(x_candidate_review_id_tbl.COUNT) := -1;
14331: IF l_debug_mode = 'Y' THEN
14332: pa_debug.write(l_module, 'PA_CANDIDATE_PUB.ADD_CANDIDATE_LOG unsuccessful', l_log_level);
14333: END IF;
14334: END IF;
14335: ELSE
14336: x_candidate_review_id_tbl.extend(1);