DBA Data[Home] [Help]

APPS.PA_CANDIDATE_PUB dependencies on FND_MSG_PUB

Line 262: FND_MSG_PUB.initialize;

258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259:
260: -- Clear the global PL/SQL message table. Added check of p_init_msg_list Bug 5130421: PJR Enhancements for Public APIs
261: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
262: FND_MSG_PUB.initialize;
263: END IF;
264:
265:
266: -- Check if assignment Id is valid

Line 535: x_msg_count := FND_MSG_PUB.Count_Msg;

531:
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: x_msg_count := FND_MSG_PUB.Count_Msg;
536:
537: IF x_msg_count = 1 THEN
538: pa_interface_utils_pub.get_messages
539: (p_encoded => FND_API.G_TRUE,

Line 550: fnd_msg_pub.add_exc_msg

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

Line 554: x_msg_count := FND_MSG_PUB.Count_Msg;

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:
556: IF x_msg_count = 1 THEN
557: pa_interface_utils_pub.get_messages
558: (p_encoded => FND_API.G_TRUE,

Line 645: FND_MSG_PUB.add_exc_msg(

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

Line 730: FND_MSG_PUB.initialize;

726: x_return_status := FND_API.G_RET_STS_SUCCESS;
727:
728: -- Clear the global PL/SQL message table
729: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
730: FND_MSG_PUB.initialize;
731: END IF;
732:
733: -- Check if p_status_code is DECLINED only if the passed status_code, which is for the remaining
734: -- candidates, is not null

Line 938: x_msg_count := FND_MSG_PUB.Count_Msg;

934:
935: EXCEPTION
936: WHEN FND_API.G_EXC_ERROR THEN
937: x_return_status := FND_API.G_RET_STS_ERROR;
938: x_msg_count := FND_MSG_PUB.Count_Msg;
939:
940: IF x_msg_count = 1 THEN
941: pa_interface_utils_pub.get_messages(
942: p_encoded => FND_API.G_TRUE,

Line 958: fnd_msg_pub.add_exc_msg(

954:
955: WHEN OTHERS THEN
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957:
958: fnd_msg_pub.add_exc_msg(
959: p_pkg_name => 'PA_COMPETENCE_PUB',
960: p_procedure_name => 'Update_Remaining_Candidates' );
961: x_msg_count := FND_MSG_PUB.Count_Msg;
962:

Line 961: x_msg_count := FND_MSG_PUB.Count_Msg;

957:
958: fnd_msg_pub.add_exc_msg(
959: p_pkg_name => 'PA_COMPETENCE_PUB',
960: p_procedure_name => 'Update_Remaining_Candidates' );
961: x_msg_count := FND_MSG_PUB.Count_Msg;
962:
963: IF x_msg_count = 1 THEN
964:
965: pa_interface_utils_pub.get_messages(

Line 1064: FND_MSG_PUB.initialize;

1060: x_return_status := FND_API.G_RET_STS_SUCCESS;
1061:
1062: -- Clear the global PL/SQL message table. Added check of p_init_msg_list Bug 5130421: PJR Enhancements for Public APIs
1063: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN
1064: FND_MSG_PUB.initialize;
1065: END IF;
1066:
1067: SELECT record_version_number
1068: INTO l_old_record_version_number

Line 1338: x_msg_count := FND_MSG_PUB.Count_Msg;

1334:
1335: EXCEPTION
1336: WHEN FND_API.G_EXC_ERROR THEN
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: x_msg_count := FND_MSG_PUB.Count_Msg;
1339:
1340: -- 4537865 : RESET OUT PARAM
1341: x_cand_record_version_number := NULL ;
1342:

Line 1358: fnd_msg_pub.add_exc_msg

1354:
1355: -- 4537865 : RESET OUT PARAM
1356: x_cand_record_version_number := NULL ;
1357:
1358: fnd_msg_pub.add_exc_msg
1359: (p_pkg_name => 'PA_COMPETENCE_PUB'
1360: ,p_procedure_name => 'Add_Candidate_Log' );
1361:
1362: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 1362: x_msg_count := FND_MSG_PUB.Count_Msg;

1358: fnd_msg_pub.add_exc_msg
1359: (p_pkg_name => 'PA_COMPETENCE_PUB'
1360: ,p_procedure_name => 'Add_Candidate_Log' );
1361:
1362: x_msg_count := FND_MSG_PUB.Count_Msg;
1363:
1364: IF x_msg_count = 1 THEN
1365: pa_interface_utils_pub.get_messages
1366: (p_encoded => FND_API.G_TRUE

Line 1459: FND_MSG_PUB.initialize;

1455: x_return_status := FND_API.G_RET_STS_SUCCESS;
1456:
1457: -- Clear the global PL/SQL message table
1458: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1459: FND_MSG_PUB.initialize;
1460: END IF;
1461:
1462: l_status_code := p_status_code;
1463: l_change_reason_code := p_change_reason_code;

Line 1717: x_msg_count := FND_MSG_PUB.Count_Msg;

1713:
1714: EXCEPTION
1715: WHEN FND_API.G_EXC_ERROR THEN
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717: x_msg_count := FND_MSG_PUB.Count_Msg;
1718:
1719: -- 4537865 : RESET OUT PARAM
1720: x_record_version_number := NULL ;
1721:

Line 1738: fnd_msg_pub.add_exc_msg

1734:
1735: -- 4537865 : RESET OUT PARAM
1736: x_record_version_number := NULL ;
1737:
1738: fnd_msg_pub.add_exc_msg
1739: (p_pkg_name => 'PA_COMPETENCE_PUB',
1740: p_procedure_name => 'Update_Candidate' );
1741:
1742: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 1742: x_msg_count := FND_MSG_PUB.Count_Msg;

1738: fnd_msg_pub.add_exc_msg
1739: (p_pkg_name => 'PA_COMPETENCE_PUB',
1740: p_procedure_name => 'Update_Candidate' );
1741:
1742: x_msg_count := FND_MSG_PUB.Count_Msg;
1743:
1744:
1745: IF x_msg_count = 1 THEN
1746: pa_interface_utils_pub.get_messages

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

1968: x_msg_count := 1;
1969: x_resource_list := NULL ;
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:

Line 1973: Fnd_Msg_Pub.Add_Exc_Msg

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

Line 2623: fnd_msg_pub.add_exc_msg

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

Line 2628: x_msg_count := FND_MSG_PUB.Count_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;
2629:
2630: IF x_msg_count = 1 THEN
2631: pa_interface_utils_pub.get_messages
2632: (p_encoded => FND_API.G_TRUE

Line 2759: fnd_msg_pub.add_exc_msg

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

Line 2765: x_msg_count := FND_MSG_PUB.Count_Msg;

2761: p_procedure_name => 'Delete_Candidates',
2762: p_error_text => x_msg_data);
2763:
2764: -- 4537865 : RESET OUT PARAMS
2765: x_msg_count := FND_MSG_PUB.Count_Msg;
2766:
2767: IF x_msg_count = 1 THEN
2768: pa_interface_utils_pub.get_messages
2769: (p_encoded => FND_API.G_TRUE

Line 2844: fnd_msg_pub.add_exc_msg

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

Line 2850: x_msg_count := FND_MSG_PUB.Count_Msg;

2846: p_procedure_name => 'Withdraw_Candidate',
2847: p_error_text => x_msg_data);
2848:
2849: -- 4537865 : RESET OUT PARAMS
2850: x_msg_count := FND_MSG_PUB.Count_Msg;
2851:
2852: IF x_msg_count = 1 THEN
2853: pa_interface_utils_pub.get_messages
2854: (p_encoded => FND_API.G_TRUE

Line 3030: fnd_msg_pub.add_exc_msg

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

Line 3034: x_msg_count := FND_MSG_PUB.Count_Msg;

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:
3036: IF x_msg_count = 1 THEN
3037: pa_interface_utils_pub.get_messages
3038: (p_encoded => FND_API.G_TRUE

Line 3229: fnd_msg_pub.add_exc_msg

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

Line 3233: x_msg_count := FND_MSG_PUB.Count_Msg;

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:
3235: IF x_msg_count = 1 THEN
3236: pa_interface_utils_pub.get_messages
3237: (p_encoded => FND_API.G_TRUE