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.4 2008/09/22 05:06:19 rthumma ship $
3:
4: FUNCTION Get_Person_Id
5: RETURN NUMBER;

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

230:
231:
232: BEGIN
233: -- Initialize the Error Stack
234: PA_DEBUG.init_err_stack('PA_CANDIDATE_PUB.Add_Candidate');
235:
236: -- initialize return_status to success
237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:

Line 496: (p_pkg_name => 'PA_CANDIDATE_PUB',

492: WHEN OTHERS THEN
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494:
495: fnd_msg_pub.add_exc_msg
496: (p_pkg_name => 'PA_CANDIDATE_PUB',
497: p_procedure_name => 'Add_Candidate' );
498:
499: x_msg_count := FND_MSG_PUB.Count_Msg;
500:

Line 591: p_pkg_name => 'PA_CANDIDATE_PUB',

587: -- catch the exceptins here
588: WHEN OTHERS THEN
589: -- Set the exception Message and the stack
590: FND_MSG_PUB.add_exc_msg(
591: p_pkg_name => 'PA_CANDIDATE_PUB',
592: p_procedure_name => 'Update_No_Of_Active_Candidates');
593:
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
595: RAISE;

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

645: l_old_system_status_code VARCHAR2(30);
646:
647: BEGIN
648: -- Initialize the Error Stack
649: PA_DEBUG.init_err_stack('PA_CANDIDATE_PUB.Update_Remaining_Candidates');
650:
651: -- initialize return_status to success
652: x_return_status := FND_API.G_RET_STS_SUCCESS;
653:

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

926: l_wf_process VARCHAR2(30);
927:
928: BEGIN
929: -- Initialize the Error Stack
930: PA_DEBUG.init_err_stack('PA_CANDIDATE_PUB.Add_Candidate_Log');
931:
932: -- initialize return_status to success
933: x_return_status := FND_API.G_RET_STS_SUCCESS;
934:

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

1247: l_wf_process VARCHAR2(30);
1248:
1249: BEGIN
1250: -- Initialize the Error Stack
1251: PA_DEBUG.init_err_stack('PA_CANDIDATE_PUB.Add_Candidate_Log');
1252:
1253: -- initialize return_status to success
1254: x_return_status := FND_API.G_RET_STS_SUCCESS;
1255:

Line 1720: ( P_Pkg_Name => 'PA_CANDIDATE_PUB',

1716: x_invalid_candidates := NULL ;
1717:
1718: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
1719: Fnd_Msg_Pub.Add_Exc_Msg
1720: ( P_Pkg_Name => 'PA_CANDIDATE_PUB',
1721: P_Procedure_Name => 'Check_Candidacy');
1722:
1723: End If;
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2361: (p_pkg_name => 'PA_CANDIDATE_PUB',

2357: -- 4537865 : RESET OUT PARAMS
2358: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
2359:
2360: fnd_msg_pub.add_exc_msg
2361: (p_pkg_name => 'PA_CANDIDATE_PUB',
2362: p_procedure_name => 'Start_Workflow');
2363:
2364: -- 4537865 : RESET OUT PARAMS
2365: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 2497: (p_pkg_name => 'PA_CANDIDATE_PUB',

2493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2494: x_msg_data := SUBSTRB(SQLERRM,1,240) ;
2495:
2496: fnd_msg_pub.add_exc_msg
2497: (p_pkg_name => 'PA_CANDIDATE_PUB',
2498: p_procedure_name => 'Delete_Candidates',
2499: p_error_text => x_msg_data);
2500:
2501: -- 4537865 : RESET OUT PARAMS

Line 2582: (p_pkg_name => 'PA_CANDIDATE_PUB',

2578: -- 4537865 : RESET OUT PARAMS
2579: x_msg_data := SUBSTRB(SQLERRM,1,240) ;
2580:
2581: fnd_msg_pub.add_exc_msg
2582: (p_pkg_name => 'PA_CANDIDATE_PUB',
2583: p_procedure_name => 'Withdraw_Candidate',
2584: p_error_text => x_msg_data);
2585:
2586: -- 4537865 : RESET OUT PARAMS

Line 2768: (p_pkg_name => 'PA_CANDIDATE_PUB',

2764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2765: x_msg_data := SUBSTRB(SQLERRM,1,240) ;
2766:
2767: fnd_msg_pub.add_exc_msg
2768: (p_pkg_name => 'PA_CANDIDATE_PUB',
2769: p_procedure_name => 'Copy_Candidates');
2770:
2771: x_msg_count := FND_MSG_PUB.Count_Msg;
2772:

Line 2967: (p_pkg_name => 'PA_CANDIDATE_PUB',

2963: --4537865
2964: x_msg_data := SUBSTRB(SQLERRM,1,240) ;
2965:
2966: fnd_msg_pub.add_exc_msg
2967: (p_pkg_name => 'PA_CANDIDATE_PUB',
2968: p_procedure_name => 'Decline_Candidates');
2969:
2970: x_msg_count := FND_MSG_PUB.Count_Msg;
2971:

Line 3136: END PA_CANDIDATE_PUB;

3132: WHEN OTHERS THEN
3133: RETURN NULL;
3134: END Get_Review_Change_Reason;
3135:
3136: END PA_CANDIDATE_PUB;