eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CANDIDATE_PUB dependencies on FND_API

Line 206: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs

202: p_nomination_comments IN VARCHAR2,
203: p_person_id IN NUMBER DEFAULT NULL,
204: p_privilege_name IN VARCHAR2 DEFAULT NULL,
205: p_project_super_user IN VARCHAR2 DEFAULT 'N',
206: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs
207: -- Added for bug 9187892
208: p_attribute_category IN pa_candidates.attribute_category%TYPE,
209: p_attribute1 IN pa_candidates.attribute1%TYPE,
210: p_attribute2 IN pa_candidates.attribute2%TYPE,

Line 258: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 261: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN

257: -- initialize return_status to success
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:

Line 277: RAISE FND_API.G_EXC_ERROR;

273: WHEN NO_DATA_FOUND THEN
274: pa_utils.add_message
275: (p_app_short_name => 'PA',
276: p_msg_name => 'PA_XC_RECORD_CHANGED');
277: RAISE FND_API.G_EXC_ERROR;
278: WHEN OTHERS THEN
279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
280: END;
281:

Line 279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

275: (p_app_short_name => 'PA',
276: p_msg_name => 'PA_XC_RECORD_CHANGED');
277: RAISE FND_API.G_EXC_ERROR;
278: WHEN OTHERS THEN
279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
280: END;
281:
282: IF p_resource_id IS NULL THEN
283: -- Check whether the pass-in person_id and person_name match

Line 308: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

304: x_error_message_code => l_msg_data);
305:
306: PA_STARTUP.G_Check_ID_Flag := l_check_id_flag;
307:
308: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
309: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
310: ,p_msg_name => l_msg_data );
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;

Line 311: RAISE FND_API.G_EXC_ERROR;

307:
308: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
309: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
310: ,p_msg_name => l_msg_data );
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313:
314: PA_R_PROJECT_RESOURCES_PUB.create_resource
315: (p_api_version => 1.0,

Line 316: p_init_msg_list => fnd_api.g_false,

312: END IF;
313:
314: PA_R_PROJECT_RESOURCES_PUB.create_resource
315: (p_api_version => 1.0,
316: p_init_msg_list => fnd_api.g_false,
317: --p_commit => p_commit,
318: --p_validate_only => p_validate_only,
319: p_person_id => l_person_id,
320: p_individual => 'Y',

Line 328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

324: x_msg_count => x_msg_count,
325: x_msg_data => x_msg_data,
326: x_resource_id => l_resource_id);
327:
328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;

Line 329: RAISE FND_API.G_EXC_ERROR;

325: x_msg_data => x_msg_data,
326: x_resource_id => l_resource_id);
327:
328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333:

Line 330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

326: x_resource_id => l_resource_id);
327:
328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333:
334: PA_RESOURCE_UTILS.Validate_Person

Line 331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

327:
328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333:
334: PA_RESOURCE_UTILS.Validate_Person
335: (p_person_id => l_person_id

Line 339: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

335: (p_person_id => l_person_id
336: ,p_start_date => l_asmt_start_date
337: ,x_return_status => l_return_status);
338:
339: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
340: RAISE FND_API.G_EXC_ERROR;
341: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: END IF;

Line 340: RAISE FND_API.G_EXC_ERROR;

336: ,p_start_date => l_asmt_start_date
337: ,x_return_status => l_return_status);
338:
339: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
340: RAISE FND_API.G_EXC_ERROR;
341: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: END IF;
344:

Line 341: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

337: ,x_return_status => l_return_status);
338:
339: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
340: RAISE FND_API.G_EXC_ERROR;
341: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: END IF;
344:
345: -- If calling page is nominate candidate, we need to check whether the user has

Line 342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

338:
339: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
340: RAISE FND_API.G_EXC_ERROR;
341: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: END IF;
344:
345: -- If calling page is nominate candidate, we need to check whether the user has
346: -- resource authority over nominee

Line 361: IF l_ret_code = FND_API.G_FALSE THEN

357: x_return_status => x_return_status,
358: x_msg_count => x_msg_count,
359: x_msg_data => x_msg_data);
360:
361: IF l_ret_code = FND_API.G_FALSE THEN
362: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
363: ,p_msg_name => 'PA_NO_RESOURCE_AUTHORITY' );
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;

Line 364: RAISE FND_API.G_EXC_ERROR;

360:
361: IF l_ret_code = FND_API.G_FALSE THEN
362: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
363: ,p_msg_name => 'PA_NO_RESOURCE_AUTHORITY' );
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366: END IF;
367:
368: l_nominated_by_person_id := Get_Person_Id;

Line 393: x_return_status := FND_API.G_RET_STS_SUCCESS;

389: l_is_cand_on_asmt := IS_CAND_ON_ASSIGNMENT(l_resource_id,p_assignment_id, l_status_code);
390:
391: IF l_is_cand_on_asmt = 'Y' THEN
392: x_msg_count := x_msg_count + 1;
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394: x_msg_data := p_resource_name;
395: RETURN;
396: END IF;
397:

Line 402: RAISE FND_API.G_EXC_ERROR;

398: IF l_status_code is null THEN
399: pa_utils.add_message
400: (p_app_short_name => 'PA',
401: p_msg_name => 'PA_CAND_STATUS_REQD');
402: RAISE FND_API.G_EXC_ERROR;
403: ELSE
404: SELECT project_system_status_code
405: INTO l_system_status_code
406: FROM pa_project_statuses

Line 511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

507: x_return_status => l_return_status,
508: x_msg_count => l_msg_count,
509: x_msg_data => l_msg_data);
510:
511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;

Line 512: RAISE FND_API.G_EXC_ERROR;

508: x_msg_count => l_msg_count,
509: x_msg_data => l_msg_data);
510:
511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516: END IF;

Line 513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

509: x_msg_data => l_msg_data);
510:
511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516: END IF;
517:

Line 514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

510:
511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516: END IF;
517:
518:

Line 526: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

522: p_old_system_status_code => NULL,
523: p_new_system_status_code => l_system_status_code,
524: x_return_status => l_return_status);
525:
526: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
527: RAISE FND_API.G_EXC_ERROR;
528: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: END IF;

Line 527: RAISE FND_API.G_EXC_ERROR;

523: p_new_system_status_code => l_system_status_code,
524: x_return_status => l_return_status);
525:
526: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
527: RAISE FND_API.G_EXC_ERROR;
528: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: END IF;
531:

Line 528: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

524: x_return_status => l_return_status);
525:
526: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
527: RAISE FND_API.G_EXC_ERROR;
528: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: END IF;
531:
532: EXCEPTION

Line 529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

525:
526: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
527: RAISE FND_API.G_EXC_ERROR;
528: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: END IF;
531:
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN

Line 533: WHEN FND_API.G_EXC_ERROR THEN

529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: END IF;
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

Line 534: x_return_status := FND_API.G_RET_STS_ERROR;

530: END IF;
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

Line 539: (p_encoded => FND_API.G_TRUE,

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,
540: p_msg_index => 1,
541: p_msg_count => 1 ,
542: p_msg_data => l_msg_data ,
543: p_data => x_msg_data,

Line 548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

544: p_msg_index_out => l_msg_index_out );
545: END IF;
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' );

Line 558: (p_encoded => FND_API.G_TRUE,

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,
559: p_msg_index => 1,
560: p_msg_count => 1,
561: p_msg_data => l_msg_data ,
562: p_data => x_msg_data,

Line 589: x_return_status := FND_API.G_RET_STS_SUCCESS;

585: l_record_version_number NUMBER;
586: l_return_status VARCHAR2(1);
587: BEGIN
588: -- initialize return status
589: x_return_status := FND_API.G_RET_STS_SUCCESS;
590:
591: -- get original no_of_active_candidates and record_version_number for the passed assignment_id
592: SELECT no_of_active_candidates, record_version_number
593: INTO l_no_of_active_candidates, l_record_version_number

Line 649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
651: END Update_No_Of_Active_Candidates;
652:
653:

Line 669: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

665: (p_assignment_id IN NUMBER,
666: p_resource_id IN NUMBER,
667: p_status_code IN VARCHAR2,
668: p_change_reason_code IN VARCHAR2,
669: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
670: -- Added for bug 9187892
671: -- start for bug#9468526 , Added default null values
672: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
673: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,

Line 726: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
728: -- Clear the global PL/SQL message table
729: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
730: FND_MSG_PUB.initialize;

Line 729: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

725: -- initialize return_status to success
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

Line 750: RAISE FND_API.G_EXC_ERROR;

746: pa_utils.add_message
747: (p_app_short_name => 'PA',
748: p_msg_name => 'PA_STS_NOT_VALID');
749:
750: RAISE FND_API.G_EXC_ERROR;
751: END;
752: END IF;
753:
754: BEGIN

Line 809: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN

805: x_msg_count => l_msg_count,
806: x_msg_data => l_msg_data,
807: x_return_status => l_return_status);
808:
809: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;

Line 810: RAISE FND_API.G_EXC_ERROR;

806: x_msg_data => l_msg_data,
807: x_return_status => l_return_status);
808:
809: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814:

Line 811: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

807: x_return_status => l_return_status);
808:
809: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814:
815: EXCEPTION

Line 812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

808:
809: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814:
815: EXCEPTION
816: -- if there is no project_status_code for ASSIGN

Line 822: RAISE FND_API.G_EXC_ERROR;

818: pa_utils.add_message
819: (p_app_short_name => 'PA',
820: p_msg_name => 'PA_NO_ASSIGN_STATUS');
821:
822: RAISE FND_API.G_EXC_ERROR;
823: END;
824:
825: EXCEPTION
826: -- if the assigned person is not one of the candidates,

Line 879: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN

875: x_msg_count => l_msg_count,
876: x_msg_data => l_msg_data,
877: x_return_status => l_return_status);
878:
879: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
880: RAISE FND_API.G_EXC_ERROR;
881: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883: END IF;

Line 880: RAISE FND_API.G_EXC_ERROR;

876: x_msg_data => l_msg_data,
877: x_return_status => l_return_status);
878:
879: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
880: RAISE FND_API.G_EXC_ERROR;
881: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883: END IF;
884: END IF;

Line 881: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

877: x_return_status => l_return_status);
878:
879: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
880: RAISE FND_API.G_EXC_ERROR;
881: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883: END IF;
884: END IF;
885:

Line 882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

878:
879: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
880: RAISE FND_API.G_EXC_ERROR;
881: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883: END IF;
884: END IF;
885:
886: END LOOP;

Line 905: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

901: p_no_of_active_candidates => 0,
902: p_record_version_number => l_record_version_number,
903: x_return_status => l_return_status );
904:
905: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
906: RAISE FND_API.G_EXC_ERROR;
907: END IF;
908:
909: ELSIF p_status_code IS NULL THEN

Line 906: RAISE FND_API.G_EXC_ERROR;

902: p_record_version_number => l_record_version_number,
903: x_return_status => l_return_status );
904:
905: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
906: RAISE FND_API.G_EXC_ERROR;
907: END IF;
908:
909: ELSIF p_status_code IS NULL THEN
910:

Line 926: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

922: p_old_system_status_code => l_old_system_status_code,
923: p_new_system_status_code => 'CANDIDATE_ASSIGNED',
924: x_return_status => l_return_status);
925:
926: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
927: RAISE FND_API.G_EXC_ERROR;
928: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;

Line 927: RAISE FND_API.G_EXC_ERROR;

923: p_new_system_status_code => 'CANDIDATE_ASSIGNED',
924: x_return_status => l_return_status);
925:
926: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
927: RAISE FND_API.G_EXC_ERROR;
928: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;
931:

Line 928: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

924: x_return_status => l_return_status);
925:
926: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
927: RAISE FND_API.G_EXC_ERROR;
928: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;
931:
932: END IF;

Line 929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

925:
926: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
927: RAISE FND_API.G_EXC_ERROR;
928: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
930: END IF;
931:
932: END IF;
933:

Line 936: WHEN FND_API.G_EXC_ERROR THEN

932: END IF;
933:
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

Line 937: x_return_status := FND_API.G_RET_STS_ERROR;

933:
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(

Line 942: p_encoded => FND_API.G_TRUE,

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,
943: p_msg_index => 1,
944: p_msg_count => 1 ,
945: p_msg_data => l_msg_data ,
946: p_data => x_msg_data,

Line 951: x_return_status := FND_API.G_RET_STS_SUCCESS;

947: p_msg_index_out => l_msg_index_out );
948: END IF;
949:
950: WHEN NO_DATA_FOUND THEN
951: x_return_status := FND_API.G_RET_STS_SUCCESS;
952: x_msg_count := 0; -- 4537865
953: x_msg_data := NULL ; -- 4537865
954:
955: WHEN OTHERS THEN

Line 956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

952: x_msg_count := 0; -- 4537865
953: x_msg_data := NULL ; -- 4537865
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' );

Line 966: p_encoded => FND_API.G_TRUE,

962:
963: IF x_msg_count = 1 THEN
964:
965: pa_interface_utils_pub.get_messages(
966: p_encoded => FND_API.G_TRUE,
967: p_msg_index => 1,
968: p_msg_count => 1,
969: p_msg_data => l_msg_data,
970: p_data => x_msg_data,

Line 1010: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs

1006: p_status_code IN VARCHAR2,
1007: p_change_reason_code IN VARCHAR2,
1008: p_review_comments IN VARCHAR2,
1009: p_cand_record_version_number IN NUMBER,
1010: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs
1011: x_cand_record_version_number OUT NOCOPY NUMBER, -- 4537865
1012: -- Added for bug 9187892
1013: -- start for bug#9468526 , Added default null values
1014: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,

Line 1060: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1063: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_TRUE)) THEN

1059: -- initialize return_status to success
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

Line 1076: RAISE FND_API.G_EXC_ERROR;

1072: IF l_old_record_version_number <> p_cand_record_version_number THEN
1073: pa_utils.add_message
1074: (p_app_short_name => 'PA',
1075: p_msg_name => 'PA_XC_RECORD_CHANGED');
1076: RAISE FND_API.G_EXC_ERROR;
1077: END IF;
1078:
1079: SELECT status_code
1080: INTO l_old_status_code

Line 1110: RAISE FND_API.G_EXC_ERROR;

1106: pa_utils.add_message
1107: (p_app_short_name => 'PA',
1108: p_msg_name => 'PA_CAND_NO_STATUS_CHANGE');
1109:
1110: RAISE FND_API.G_EXC_ERROR;
1111: END IF;
1112:
1113: -- check if a comment is passed. If no
1114: -- comment is passed, then return without making an entry in

Line 1116: IF p_review_comments = FND_API.G_MISS_CHAR or

1112:
1113: -- check if a comment is passed. If no
1114: -- comment is passed, then return without making an entry in
1115: -- the log file.
1116: IF p_review_comments = FND_API.G_MISS_CHAR or
1117: p_review_comments is null THEN
1118: RETURN;
1119: END IF;
1120:

Line 1152: RAISE FND_API.G_EXC_ERROR;

1148: pa_utils.add_message
1149: (p_app_short_name => 'PA',
1150: p_msg_name => 'PA_STATUS_CANT_CHANGE');
1151:
1152: RAISE FND_API.G_EXC_ERROR;
1153: END IF;
1154:
1155: -- Check if the change of status requires change reason
1156: -- to be specified.

Line 1162: RAISE FND_API.G_EXC_ERROR;

1158: AND p_change_reason_code is null THEN
1159: pa_utils.add_message
1160: (p_app_short_name => 'PA',
1161: p_msg_name => 'PA_CAND_CHG_REASON_REQD');
1162: RAISE FND_API.G_EXC_ERROR;
1163: END IF;
1164:
1165: -- Update pa_candidates with the new status code
1166: -- Added WHO Column update. Bug 7168412.

Line 1229: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1225: p_new_system_status_code => l_system_status_code,
1226: x_return_status => x_return_status);
1227:
1228: -- 4537865 Earlier wrong check was made against l_return_status
1229: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1230: RAISE FND_API.G_EXC_ERROR;
1231: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1233: END IF;

Line 1230: RAISE FND_API.G_EXC_ERROR;

1226: x_return_status => x_return_status);
1227:
1228: -- 4537865 Earlier wrong check was made against l_return_status
1229: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1230: RAISE FND_API.G_EXC_ERROR;
1231: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1233: END IF;
1234: END IF;

Line 1231: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1227:
1228: -- 4537865 Earlier wrong check was made against l_return_status
1229: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1230: RAISE FND_API.G_EXC_ERROR;
1231: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1233: END IF;
1234: END IF;
1235:

Line 1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1228: -- 4537865 Earlier wrong check was made against l_return_status
1229: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1230: RAISE FND_API.G_EXC_ERROR;
1231: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1233: END IF;
1234: END IF;
1235:
1236: -- set the updated record_version_number to the out parameter.

Line 1328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1324: x_msg_data => l_msg_data);
1325:
1326: END IF;
1327:
1328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1329: RAISE FND_API.G_EXC_ERROR;
1330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;

Line 1329: RAISE FND_API.G_EXC_ERROR;

1325:
1326: END IF;
1327:
1328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1329: RAISE FND_API.G_EXC_ERROR;
1330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;
1333: END IF;

Line 1330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1326: END IF;
1327:
1328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1329: RAISE FND_API.G_EXC_ERROR;
1330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;
1333: END IF;
1334:

Line 1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1327:
1328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1329: RAISE FND_API.G_EXC_ERROR;
1330: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;
1333: END IF;
1334:
1335: EXCEPTION

Line 1336: WHEN FND_API.G_EXC_ERROR THEN

1332: END IF;
1333: END IF;
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

Line 1337: x_return_status := FND_API.G_RET_STS_ERROR;

1333: END IF;
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 ;

Line 1345: (p_encoded => FND_API.G_TRUE

1341: x_cand_record_version_number := NULL ;
1342:
1343: IF x_msg_count = 1 THEN
1344: pa_interface_utils_pub.get_messages
1345: (p_encoded => FND_API.G_TRUE
1346: ,p_msg_index => 1
1347: ,p_msg_count => 1
1348: ,p_msg_data => l_msg_data
1349: ,p_data => x_msg_data

Line 1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1349: ,p_data => x_msg_data
1350: ,p_msg_index_out => l_msg_index_out );
1351: END IF;
1352: WHEN OTHERS THEN
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1354:
1355: -- 4537865 : RESET OUT PARAM
1356: x_cand_record_version_number := NULL ;
1357:

Line 1366: (p_encoded => FND_API.G_TRUE

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
1367: ,p_msg_index => 1
1368: ,p_msg_count => 1
1369: ,p_msg_data => l_msg_data
1370: ,p_data => x_msg_data

Line 1404: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1400: p_status_code IN VARCHAR2,
1401: p_ranking IN NUMBER,
1402: p_change_reason_code IN VARCHAR2,
1403: p_record_version_number IN NUMBER,
1404: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1405: p_validate_status IN VARCHAR2 := FND_API.G_TRUE,
1406: -- Added for bug 9187892
1407: -- start for bug#9468526 , Added default null values
1408: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,

Line 1405: p_validate_status IN VARCHAR2 := FND_API.G_TRUE,

1401: p_ranking IN NUMBER,
1402: p_change_reason_code IN VARCHAR2,
1403: p_record_version_number IN NUMBER,
1404: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1405: p_validate_status IN VARCHAR2 := FND_API.G_TRUE,
1406: -- Added for bug 9187892
1407: -- start for bug#9468526 , Added default null values
1408: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
1409: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,

Line 1455: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1457: -- Clear the global PL/SQL message table
1458: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
1459: FND_MSG_PUB.initialize;

Line 1458: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

1454: -- initialize return_status to success
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;

Line 1485: RAISE FND_API.G_EXC_ERROR;

1481: WHEN NO_DATA_FOUND THEN
1482: pa_utils.add_message
1483: (p_app_short_name => 'PA',
1484: p_msg_name => 'PA_CAND_NOT_FOUND');
1485: RAISE FND_API.G_EXC_ERROR;
1486: WHEN OTHERS THEN
1487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1488: END;
1489:

Line 1487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1483: (p_app_short_name => 'PA',
1484: p_msg_name => 'PA_CAND_NOT_FOUND');
1485: RAISE FND_API.G_EXC_ERROR;
1486: WHEN OTHERS THEN
1487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1488: END;
1489:
1490: IF l_old_record_version_number <> p_record_version_number THEN
1491: pa_utils.add_message

Line 1494: RAISE FND_API.G_EXC_ERROR;

1490: IF l_old_record_version_number <> p_record_version_number THEN
1491: pa_utils.add_message
1492: (p_app_short_name => 'PA',
1493: p_msg_name => 'PA_XC_RECORD_CHANGED');
1494: RAISE FND_API.G_EXC_ERROR;
1495: END IF;
1496:
1497: IF l_status_code is null THEN
1498: l_system_status_code := null;

Line 1522: RAISE FND_API.G_EXC_ERROR;

1518: AND l_old_system_status_code <> 'CANDIDATE_SYSTEM_NOMINATED' THEN
1519: pa_utils.add_message
1520: (p_app_short_name => 'PA',
1521: p_msg_name => 'PA_CAND_STATUS_NOT_ALLOWED');
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;
1524:
1525: IF FND_API.TO_BOOLEAN(p_validate_status) THEN
1526: -- Status has not changed. Check to see if change reason is passed.

Line 1525: IF FND_API.TO_BOOLEAN(p_validate_status) THEN

1521: p_msg_name => 'PA_CAND_STATUS_NOT_ALLOWED');
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;
1524:
1525: IF FND_API.TO_BOOLEAN(p_validate_status) THEN
1526: -- Status has not changed. Check to see if change reason is passed.
1527: -- The user should not update Change Reason if status is not
1528: -- updated.
1529: IF nvl(l_old_status_code,'-1') = nvl(l_status_code,'-1') THEN

Line 1535: RAISE FND_API.G_EXC_ERROR;

1531: IF p_change_reason_code is not null THEN
1532: pa_utils.add_message
1533: (p_app_short_name => 'PA',
1534: p_msg_name => 'PA_CAND_NO_STATUS_CHANGE');
1535: RAISE FND_API.G_EXC_ERROR;
1536:
1537: -- If nothing has been updated, just return without updating anything.
1538: ELSIF p_change_reason_code is null
1539: AND nvl(l_old_candidate_ranking,'-1') = nvl(p_ranking,'-1') THEN

Line 1554: RAISE FND_API.G_EXC_ERROR;

1550: pa_utils.add_message
1551: (p_app_short_name => 'PA',
1552: p_msg_name => 'PA_STATUS_CANT_CHANGE');
1553:
1554: RAISE FND_API.G_EXC_ERROR;
1555: END IF;
1556:
1557: -- Check if reason is required for the status change
1558: IF (pa_project_utils.Check_prj_stus_action_allowed

Line 1565: RAISE FND_API.G_EXC_ERROR;

1561: pa_utils.add_message
1562: (p_app_short_name => 'PA',
1563: p_msg_name => 'PA_CAND_CHG_REASON_REQD');
1564:
1565: RAISE FND_API.G_EXC_ERROR;
1566: END IF;
1567: END IF;
1568: END IF;
1569:

Line 1679: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1675: p_old_system_status_code => l_old_system_status_code,
1676: p_new_system_status_code => l_system_status_code,
1677: x_return_status => l_return_status);
1678:
1679: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1680: RAISE FND_API.G_EXC_ERROR;
1681: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1683: END IF;

Line 1680: RAISE FND_API.G_EXC_ERROR;

1676: p_new_system_status_code => l_system_status_code,
1677: x_return_status => l_return_status);
1678:
1679: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1680: RAISE FND_API.G_EXC_ERROR;
1681: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1683: END IF;
1684:

Line 1681: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1677: x_return_status => l_return_status);
1678:
1679: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1680: RAISE FND_API.G_EXC_ERROR;
1681: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1683: END IF;
1684:
1685: SELECT ENABLE_WF_FLAG, WORKFLOW_ITEM_TYPE, WORKFLOW_PROCESS, PROJECT_STATUS_NAME

Line 1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1678:
1679: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1680: RAISE FND_API.G_EXC_ERROR;
1681: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1683: END IF;
1684:
1685: SELECT ENABLE_WF_FLAG, WORKFLOW_ITEM_TYPE, WORKFLOW_PROCESS, PROJECT_STATUS_NAME
1686: INTO l_enable_wf_flag, l_wf_item_type, l_wf_process, l_status_name

Line 1707: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1703: x_msg_count => l_msg_count,
1704: x_msg_data => l_msg_data);
1705: END IF;
1706:
1707: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1708: RAISE FND_API.G_EXC_ERROR;
1709: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1711: END IF;

Line 1708: RAISE FND_API.G_EXC_ERROR;

1704: x_msg_data => l_msg_data);
1705: END IF;
1706:
1707: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1708: RAISE FND_API.G_EXC_ERROR;
1709: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1711: END IF;
1712: END IF;

Line 1709: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1705: END IF;
1706:
1707: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1708: RAISE FND_API.G_EXC_ERROR;
1709: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1711: END IF;
1712: END IF;
1713:

Line 1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1706:
1707: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1708: RAISE FND_API.G_EXC_ERROR;
1709: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1711: END IF;
1712: END IF;
1713:
1714: EXCEPTION

Line 1715: WHEN FND_API.G_EXC_ERROR THEN

1711: END IF;
1712: END IF;
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

Line 1716: x_return_status := FND_API.G_RET_STS_ERROR;

1712: END IF;
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 ;

Line 1724: (p_encoded => FND_API.G_TRUE,

1720: x_record_version_number := NULL ;
1721:
1722: IF x_msg_count = 1 THEN
1723: pa_interface_utils_pub.get_messages
1724: (p_encoded => FND_API.G_TRUE,
1725: p_msg_index => 1,
1726: p_msg_count => 1 ,
1727: p_msg_data => l_msg_data ,
1728: p_data => x_msg_data,

Line 1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1729: p_msg_index_out => l_msg_index_out );
1730: END IF;
1731:
1732: WHEN OTHERS THEN
1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1734:
1735: -- 4537865 : RESET OUT PARAM
1736: x_record_version_number := NULL ;
1737:

Line 1747: (p_encoded => FND_API.G_TRUE

1743:
1744:
1745: IF x_msg_count = 1 THEN
1746: pa_interface_utils_pub.get_messages
1747: (p_encoded => FND_API.G_TRUE
1748: ,p_msg_index => 1
1749: ,p_msg_count => 1
1750: ,p_msg_data => l_msg_data
1751: ,p_data => x_msg_data

Line 1908: x_return_status := FND_API.G_RET_STS_SUCCESS;

1904: l_msg_count NUMBER := 0;
1905: l_data VARCHAR2(500);
1906: l_msg_index_out NUMBER ;
1907: BEGIN
1908: x_return_status := FND_API.G_RET_STS_SUCCESS;
1909:
1910: l_in_resource_list := p_resource_list || ',';
1911: j:= 1;
1912: initial := 1;

Line 1961: x_return_status := FND_API.G_RET_STS_SUCCESS;

1957: x_invalid_candidates := l_candidate_list;
1958: x_msg_count := 1;
1959: END IF;
1960:
1961: x_return_status := FND_API.G_RET_STS_SUCCESS;
1962: x_resource_list := l_resource_list;
1963:
1964: EXCEPTION
1965: WHEN OTHERS THEN

Line 1967: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

1963:
1964: EXCEPTION
1965: WHEN OTHERS THEN
1966: -- 4537865 RESET OUT PARAMS
1967: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
1968: x_msg_count := 1;
1969: x_resource_list := NULL ;
1970: x_invalid_candidates := NULL ;
1971:

Line 1978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
1979:
1980: END;
1981:
1982:

Line 2127: x_return_status := FND_API.G_RET_STS_SUCCESS;

2123: l_count_recipients NUMBER := 0; -- Added for Bug 6144224
2124:
2125: BEGIN
2126: -- initialize return_status to success
2127: x_return_status := FND_API.G_RET_STS_SUCCESS;
2128: --dbms_output.put_line('begin-- p_wf_item_type ' || p_wf_item_type);
2129: --dbms_output.put_line('begin-- p_wf_process ' || p_wf_process);
2130: --dbms_output.put_line('begin-- p_status_name ' || p_status_name);
2131:

Line 2141: x_return_status := FND_API.G_RET_STS_ERROR;

2137: -- Now start fetching the details
2138: OPEN l_assignments_csr;
2139: FETCH l_assignments_csr INTO l_assignments_rec;
2140: IF l_assignments_csr%NOTFOUND THEN
2141: x_return_status := FND_API.G_RET_STS_ERROR;
2142: pa_utils.add_message (p_app_short_name => 'PA',
2143: p_msg_name => 'PA_INVALID_ASMGT_ID');
2144: CLOSE l_assignments_csr;
2145: ELSE

Line 2152: x_return_status := FND_API.G_RET_STS_ERROR;

2148:
2149: OPEN l_projects_csr(l_assignments_rec.project_id);
2150: FETCH l_projects_csr INTO l_projects_rec;
2151: IF l_projects_csr%NOTFOUND THEN
2152: x_return_status := FND_API.G_RET_STS_ERROR;
2153: pa_utils.add_message (p_app_short_name => 'PA',
2154: p_msg_name => 'PA_INVALID_PROJECT_ID');
2155: CLOSE l_projects_csr;
2156: ELSE

Line 2621: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;

2617:
2618: EXCEPTION
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');

Line 2632: (p_encoded => FND_API.G_TRUE

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
2633: ,p_msg_index => 1
2634: ,p_msg_count => 1
2635: ,p_msg_data => l_msg_data
2636: ,p_data => x_msg_data

Line 2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2636: ,p_data => x_msg_data
2637: ,p_msg_index_out => l_msg_index_out );
2638: END IF;
2639:
2640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2641:
2642: END Start_Workflow;
2643:
2644:

Line 2676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2672: RETURN l_employee_id;
2673:
2674: EXCEPTION
2675: WHEN OTHERS THEN
2676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2677:
2678: END Get_Person_Id;
2679:
2680:

Line 2724: x_return_status := FND_API.G_RET_STS_SUCCESS;

2720: l_candidates_tbl number_tbl;
2721: BEGIN
2722: -- x_msg_count and x_msg_data are dummy variables, they are
2723: -- reserved for further expansion of this procedure
2724: x_return_status := FND_API.G_RET_STS_SUCCESS;
2725: x_msg_count := 0;
2726: x_msg_data := null;
2727:
2728: IF p_status_code IS NULL THEN

Line 2756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2752: END IF;
2753:
2754: EXCEPTION
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',

Line 2769: (p_encoded => FND_API.G_TRUE

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
2770: ,p_msg_index => 1
2771: ,p_msg_count => 1
2772: ,p_msg_data => l_msg_data
2773: ,p_data => x_msg_data

Line 2803: x_return_status := FND_API.G_RET_STS_SUCCESS;

2799: BEGIN
2800: -- x_msg_count and x_msg_data are dummy variables, they are
2801: -- reserved for further expansion of this procedure
2802:
2803: x_return_status := FND_API.G_RET_STS_SUCCESS;
2804: x_msg_count := 0;
2805: x_msg_data := null;
2806:
2807: SELECT asmt.no_of_active_candidates,

Line 2840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2836:
2837: EXCEPTION
2838:
2839: WHEN OTHERS THEN
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

Line 2854: (p_encoded => FND_API.G_TRUE

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
2855: ,p_msg_index => 1
2856: ,p_msg_count => 1
2857: ,p_msg_data => l_msg_data
2858: ,p_data => x_msg_data

Line 2923: l_return_status := FND_API.G_RET_STS_SUCCESS; -- At the end we will assign l_return_status to x_return_status

2919: BEGIN
2920:
2921: -- 4537865 : INITIALIZE OUT PARAMS
2922:
2923: l_return_status := FND_API.G_RET_STS_SUCCESS; -- At the end we will assign l_return_status to x_return_status
2924: x_msg_count := 0;
2925: x_msg_data := null;
2926:
2927: FOR c2 in c1 LOOP

Line 3027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3023:
3024: EXCEPTION
3025: WHEN OTHERS THEN
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',

Line 3038: (p_encoded => FND_API.G_TRUE

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
3039: ,p_msg_index => 1
3040: ,p_msg_count => 1
3041: ,p_msg_data => l_msg_data
3042: ,p_data => x_msg_data

Line 3046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3042: ,p_data => x_msg_data
3043: ,p_msg_index_out => l_msg_index_out );
3044: END IF;
3045:
3046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3047:
3048: END Copy_Candidates;
3049:
3050: /*-------------------------------------------------------------------------

Line 3084: x_return_status := FND_API.G_RET_STS_SUCCESS;

3080:
3081: -- 4537865
3082: l_msg_index_out NUMBER ;
3083: BEGIN
3084: x_return_status := FND_API.G_RET_STS_SUCCESS;
3085: x_msg_count := 0;
3086: x_msg_data := null;
3087:
3088: -- Gather the candidate_ids that needs to be declined

Line 3201: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3197: x_msg_count => l_msg_count,
3198: x_msg_data => l_msg_data);
3199: END IF;
3200:
3201: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3202: RAISE FND_API.G_EXC_ERROR;
3203: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3205: END IF;

Line 3202: RAISE FND_API.G_EXC_ERROR;

3198: x_msg_data => l_msg_data);
3199: END IF;
3200:
3201: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3202: RAISE FND_API.G_EXC_ERROR;
3203: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3205: END IF;
3206: END LOOP;

Line 3203: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3199: END IF;
3200:
3201: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3202: RAISE FND_API.G_EXC_ERROR;
3203: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3205: END IF;
3206: END LOOP;
3207:

Line 3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3200:
3201: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3202: RAISE FND_API.G_EXC_ERROR;
3203: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3205: END IF;
3206: END LOOP;
3207:
3208: SELECT record_version_number

Line 3224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3220: END IF;
3221:
3222: EXCEPTION
3223: WHEN OTHERS THEN
3224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3225:
3226: --4537865
3227: x_msg_data := SUBSTRB(SQLERRM,1,240) ;
3228:

Line 3237: (p_encoded => FND_API.G_TRUE

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
3238: ,p_msg_index => 1
3239: ,p_msg_count => 1
3240: ,p_msg_data => l_msg_data
3241: ,p_data => x_msg_data