DBA Data[Home] [Help]

APPS.PA_CANDIDATE_PUB dependencies on FND_MSG_PUB

Line 241: FND_MSG_PUB.initialize;

237: x_return_status := FND_API.G_RET_STS_SUCCESS;
238:
239: -- Clear the global PL/SQL message table. Added check of p_init_msg_list Bug 5130421: PJR Enhancements for Public APIs
240: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
241: FND_MSG_PUB.initialize;
242: END IF;
243:
244:
245: -- Check if assignment Id is valid

Line 480: x_msg_count := FND_MSG_PUB.Count_Msg;

476:
477: EXCEPTION
478: WHEN FND_API.G_EXC_ERROR THEN
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: x_msg_count := FND_MSG_PUB.Count_Msg;
481:
482: IF x_msg_count = 1 THEN
483: pa_interface_utils_pub.get_messages
484: (p_encoded => FND_API.G_TRUE,

Line 495: fnd_msg_pub.add_exc_msg

491:
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;

Line 499: x_msg_count := FND_MSG_PUB.Count_Msg;

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:
501: IF x_msg_count = 1 THEN
502: pa_interface_utils_pub.get_messages
503: (p_encoded => FND_API.G_TRUE,

Line 590: FND_MSG_PUB.add_exc_msg(

586: EXCEPTION
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 ;

Line 656: FND_MSG_PUB.initialize;

652: x_return_status := FND_API.G_RET_STS_SUCCESS;
653:
654: -- Clear the global PL/SQL message table
655: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
656: FND_MSG_PUB.initialize;
657: END IF;
658:
659: -- Check if p_status_code is DECLINED only if the passed status_code, which is for the remaining
660: -- candidates, is not null

Line 830: x_msg_count := FND_MSG_PUB.Count_Msg;

826:
827: EXCEPTION
828: WHEN FND_API.G_EXC_ERROR THEN
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: x_msg_count := FND_MSG_PUB.Count_Msg;
831:
832: IF x_msg_count = 1 THEN
833: pa_interface_utils_pub.get_messages(
834: p_encoded => FND_API.G_TRUE,

Line 850: fnd_msg_pub.add_exc_msg(

846:
847: WHEN OTHERS THEN
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849:
850: fnd_msg_pub.add_exc_msg(
851: p_pkg_name => 'PA_COMPETENCE_PUB',
852: p_procedure_name => 'Update_Remaining_Candidates' );
853: x_msg_count := FND_MSG_PUB.Count_Msg;
854:

Line 853: x_msg_count := FND_MSG_PUB.Count_Msg;

849:
850: fnd_msg_pub.add_exc_msg(
851: p_pkg_name => 'PA_COMPETENCE_PUB',
852: p_procedure_name => 'Update_Remaining_Candidates' );
853: x_msg_count := FND_MSG_PUB.Count_Msg;
854:
855: IF x_msg_count = 1 THEN
856:
857: pa_interface_utils_pub.get_messages(

Line 937: FND_MSG_PUB.initialize;

933: x_return_status := FND_API.G_RET_STS_SUCCESS;
934:
935: -- Clear the global PL/SQL message table. Added check of p_init_msg_list Bug 5130421: PJR Enhancements for Public APIs
936: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
937: FND_MSG_PUB.initialize;
938: END IF;
939:
940: SELECT record_version_number
941: INTO l_old_record_version_number

Line 1156: x_msg_count := FND_MSG_PUB.Count_Msg;

1152:
1153: EXCEPTION
1154: WHEN FND_API.G_EXC_ERROR THEN
1155: x_return_status := FND_API.G_RET_STS_ERROR;
1156: x_msg_count := FND_MSG_PUB.Count_Msg;
1157:
1158: -- 4537865 : RESET OUT PARAM
1159: x_cand_record_version_number := NULL ;
1160:

Line 1176: fnd_msg_pub.add_exc_msg

1172:
1173: -- 4537865 : RESET OUT PARAM
1174: x_cand_record_version_number := NULL ;
1175:
1176: fnd_msg_pub.add_exc_msg
1177: (p_pkg_name => 'PA_COMPETENCE_PUB'
1178: ,p_procedure_name => 'Add_Candidate_Log' );
1179:
1180: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 1180: x_msg_count := FND_MSG_PUB.Count_Msg;

1176: fnd_msg_pub.add_exc_msg
1177: (p_pkg_name => 'PA_COMPETENCE_PUB'
1178: ,p_procedure_name => 'Add_Candidate_Log' );
1179:
1180: x_msg_count := FND_MSG_PUB.Count_Msg;
1181:
1182: IF x_msg_count = 1 THEN
1183: pa_interface_utils_pub.get_messages
1184: (p_encoded => FND_API.G_TRUE

Line 1258: FND_MSG_PUB.initialize;

1254: x_return_status := FND_API.G_RET_STS_SUCCESS;
1255:
1256: -- Clear the global PL/SQL message table
1257: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1258: FND_MSG_PUB.initialize;
1259: END IF;
1260:
1261: l_status_code := p_status_code;
1262: l_change_reason_code := p_change_reason_code;

Line 1463: x_msg_count := FND_MSG_PUB.Count_Msg;

1459:
1460: EXCEPTION
1461: WHEN FND_API.G_EXC_ERROR THEN
1462: x_return_status := FND_API.G_RET_STS_ERROR;
1463: x_msg_count := FND_MSG_PUB.Count_Msg;
1464:
1465: -- 4537865 : RESET OUT PARAM
1466: x_record_version_number := NULL ;
1467:

Line 1484: fnd_msg_pub.add_exc_msg

1480:
1481: -- 4537865 : RESET OUT PARAM
1482: x_record_version_number := NULL ;
1483:
1484: fnd_msg_pub.add_exc_msg
1485: (p_pkg_name => 'PA_COMPETENCE_PUB',
1486: p_procedure_name => 'Update_Candidate' );
1487:
1488: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 1488: x_msg_count := FND_MSG_PUB.Count_Msg;

1484: fnd_msg_pub.add_exc_msg
1485: (p_pkg_name => 'PA_COMPETENCE_PUB',
1486: p_procedure_name => 'Update_Candidate' );
1487:
1488: x_msg_count := FND_MSG_PUB.Count_Msg;
1489:
1490:
1491: IF x_msg_count = 1 THEN
1492: pa_interface_utils_pub.get_messages

Line 1718: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then

1714: x_msg_count := 1;
1715: x_resource_list := NULL ;
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:

Line 1719: Fnd_Msg_Pub.Add_Exc_Msg

1715: x_resource_list := NULL ;
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;

Line 2360: fnd_msg_pub.add_exc_msg

2356: WHEN OTHERS THEN
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

Line 2365: x_msg_count := FND_MSG_PUB.Count_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;
2366:
2367: IF x_msg_count = 1 THEN
2368: pa_interface_utils_pub.get_messages
2369: (p_encoded => FND_API.G_TRUE

Line 2496: fnd_msg_pub.add_exc_msg

2492: WHEN OTHERS THEN
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:

Line 2502: x_msg_count := FND_MSG_PUB.Count_Msg;

2498: p_procedure_name => 'Delete_Candidates',
2499: p_error_text => x_msg_data);
2500:
2501: -- 4537865 : RESET OUT PARAMS
2502: x_msg_count := FND_MSG_PUB.Count_Msg;
2503:
2504: IF x_msg_count = 1 THEN
2505: pa_interface_utils_pub.get_messages
2506: (p_encoded => FND_API.G_TRUE

Line 2581: fnd_msg_pub.add_exc_msg

2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:

Line 2587: x_msg_count := FND_MSG_PUB.Count_Msg;

2583: p_procedure_name => 'Withdraw_Candidate',
2584: p_error_text => x_msg_data);
2585:
2586: -- 4537865 : RESET OUT PARAMS
2587: x_msg_count := FND_MSG_PUB.Count_Msg;
2588:
2589: IF x_msg_count = 1 THEN
2590: pa_interface_utils_pub.get_messages
2591: (p_encoded => FND_API.G_TRUE

Line 2767: fnd_msg_pub.add_exc_msg

2763: -- 4537865 : RESET OUT PARAMS
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;

Line 2771: x_msg_count := FND_MSG_PUB.Count_Msg;

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:
2773: IF x_msg_count = 1 THEN
2774: pa_interface_utils_pub.get_messages
2775: (p_encoded => FND_API.G_TRUE

Line 2966: fnd_msg_pub.add_exc_msg

2962:
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;

Line 2970: x_msg_count := FND_MSG_PUB.Count_Msg;

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:
2972: IF x_msg_count = 1 THEN
2973: pa_interface_utils_pub.get_messages
2974: (p_encoded => FND_API.G_TRUE