DBA Data[Home] [Help]

APPS.PA_CANDIDATE_PUB dependencies on PA_CANDIDATE_PUB

Line 1: PACKAGE BODY PA_CANDIDATE_PUB AS

1: PACKAGE BODY PA_CANDIDATE_PUB AS
2: -- $Header: PARCANPB.pls 120.8.12010000.11 2010/03/31 10:15:40 nisinha ship $
3:
4: FUNCTION Get_Person_Id
5: RETURN NUMBER;

Line 255: PA_DEBUG.init_err_stack('PA_CANDIDATE_PUB.Add_Candidate');

251:
252:
253: BEGIN
254: -- Initialize the Error Stack
255: PA_DEBUG.init_err_stack('PA_CANDIDATE_PUB.Add_Candidate');
256:
257: -- initialize return_status to success
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259:

Line 551: (p_pkg_name => 'PA_CANDIDATE_PUB',

547: WHEN OTHERS THEN
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549:
550: fnd_msg_pub.add_exc_msg
551: (p_pkg_name => 'PA_CANDIDATE_PUB',
552: p_procedure_name => 'Add_Candidate' );
553:
554: x_msg_count := FND_MSG_PUB.Count_Msg;
555:

Line 646: p_pkg_name => 'PA_CANDIDATE_PUB',

642: -- catch the exceptins here
643: WHEN OTHERS THEN
644: -- Set the exception Message and the stack
645: FND_MSG_PUB.add_exc_msg(
646: p_pkg_name => 'PA_CANDIDATE_PUB',
647: p_procedure_name => 'Update_No_Of_Active_Candidates');
648:
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
650: RAISE;

Line 723: PA_DEBUG.init_err_stack('PA_CANDIDATE_PUB.Update_Remaining_Candidates');

719: l_old_system_status_code VARCHAR2(30);
720:
721: BEGIN
722: -- Initialize the Error Stack
723: PA_DEBUG.init_err_stack('PA_CANDIDATE_PUB.Update_Remaining_Candidates');
724:
725: -- initialize return_status to success
726: x_return_status := FND_API.G_RET_STS_SUCCESS;
727:

Line 1057: PA_DEBUG.init_err_stack('PA_CANDIDATE_PUB.Add_Candidate_Log');

1053: l_wf_process VARCHAR2(30);
1054:
1055: BEGIN
1056: -- Initialize the Error Stack
1057: PA_DEBUG.init_err_stack('PA_CANDIDATE_PUB.Add_Candidate_Log');
1058:
1059: -- initialize return_status to success
1060: x_return_status := FND_API.G_RET_STS_SUCCESS;
1061:

Line 1452: PA_DEBUG.init_err_stack('PA_CANDIDATE_PUB.Add_Candidate_Log');

1448: l_wf_process VARCHAR2(30);
1449:
1450: BEGIN
1451: -- Initialize the Error Stack
1452: PA_DEBUG.init_err_stack('PA_CANDIDATE_PUB.Add_Candidate_Log');
1453:
1454: -- initialize return_status to success
1455: x_return_status := FND_API.G_RET_STS_SUCCESS;
1456:

Line 1974: ( P_Pkg_Name => 'PA_CANDIDATE_PUB',

1970: x_invalid_candidates := NULL ;
1971:
1972: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
1973: Fnd_Msg_Pub.Add_Exc_Msg
1974: ( P_Pkg_Name => 'PA_CANDIDATE_PUB',
1975: P_Procedure_Name => 'Check_Candidacy');
1976:
1977: End If;
1978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2624: (p_pkg_name => 'PA_CANDIDATE_PUB',

2620: -- 4537865 : RESET OUT PARAMS
2621: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
2622:
2623: fnd_msg_pub.add_exc_msg
2624: (p_pkg_name => 'PA_CANDIDATE_PUB',
2625: p_procedure_name => 'Start_Workflow');
2626:
2627: -- 4537865 : RESET OUT PARAMS
2628: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 2760: (p_pkg_name => 'PA_CANDIDATE_PUB',

2756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2757: x_msg_data := SUBSTRB(SQLERRM,1,240) ;
2758:
2759: fnd_msg_pub.add_exc_msg
2760: (p_pkg_name => 'PA_CANDIDATE_PUB',
2761: p_procedure_name => 'Delete_Candidates',
2762: p_error_text => x_msg_data);
2763:
2764: -- 4537865 : RESET OUT PARAMS

Line 2845: (p_pkg_name => 'PA_CANDIDATE_PUB',

2841: -- 4537865 : RESET OUT PARAMS
2842: x_msg_data := SUBSTRB(SQLERRM,1,240) ;
2843:
2844: fnd_msg_pub.add_exc_msg
2845: (p_pkg_name => 'PA_CANDIDATE_PUB',
2846: p_procedure_name => 'Withdraw_Candidate',
2847: p_error_text => x_msg_data);
2848:
2849: -- 4537865 : RESET OUT PARAMS

Line 3031: (p_pkg_name => 'PA_CANDIDATE_PUB',

3027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3028: x_msg_data := SUBSTRB(SQLERRM,1,240) ;
3029:
3030: fnd_msg_pub.add_exc_msg
3031: (p_pkg_name => 'PA_CANDIDATE_PUB',
3032: p_procedure_name => 'Copy_Candidates');
3033:
3034: x_msg_count := FND_MSG_PUB.Count_Msg;
3035:

Line 3230: (p_pkg_name => 'PA_CANDIDATE_PUB',

3226: --4537865
3227: x_msg_data := SUBSTRB(SQLERRM,1,240) ;
3228:
3229: fnd_msg_pub.add_exc_msg
3230: (p_pkg_name => 'PA_CANDIDATE_PUB',
3231: p_procedure_name => 'Decline_Candidates');
3232:
3233: x_msg_count := FND_MSG_PUB.Count_Msg;
3234:

Line 3399: END PA_CANDIDATE_PUB;

3395: WHEN OTHERS THEN
3396: RETURN NULL;
3397: END Get_Review_Change_Reason;
3398:
3399: END PA_CANDIDATE_PUB;