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 202: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs

198: p_nomination_comments IN VARCHAR2,
199: p_person_id IN NUMBER DEFAULT NULL,
200: p_privilege_name IN VARCHAR2 DEFAULT NULL,
201: p_project_super_user IN VARCHAR2 DEFAULT 'N',
202: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs
203: x_return_status OUT NOCOPY VARCHAR2, -- 4537865
204: x_msg_count OUT NOCOPY NUMBER, -- 4537865
205: x_msg_data OUT NOCOPY VARCHAR2) -- 4537865
206: IS

Line 237: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 256: RAISE FND_API.G_EXC_ERROR;

252: WHEN NO_DATA_FOUND THEN
253: pa_utils.add_message
254: (p_app_short_name => 'PA',
255: p_msg_name => 'PA_XC_RECORD_CHANGED');
256: RAISE FND_API.G_EXC_ERROR;
257: WHEN OTHERS THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259: END;
260:

Line 258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

254: (p_app_short_name => 'PA',
255: p_msg_name => 'PA_XC_RECORD_CHANGED');
256: RAISE FND_API.G_EXC_ERROR;
257: WHEN OTHERS THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259: END;
260:
261: IF p_resource_id IS NULL THEN
262: -- Check whether the pass-in person_id and person_name match

Line 287: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

283: x_error_message_code => l_msg_data);
284:
285: PA_STARTUP.G_Check_ID_Flag := l_check_id_flag;
286:
287: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
288: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
289: ,p_msg_name => l_msg_data );
290: RAISE FND_API.G_EXC_ERROR;
291: END IF;

Line 290: RAISE FND_API.G_EXC_ERROR;

286:
287: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
288: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
289: ,p_msg_name => l_msg_data );
290: RAISE FND_API.G_EXC_ERROR;
291: END IF;
292:
293: PA_R_PROJECT_RESOURCES_PUB.create_resource
294: (p_api_version => 1.0,

Line 295: p_init_msg_list => fnd_api.g_false,

291: END IF;
292:
293: PA_R_PROJECT_RESOURCES_PUB.create_resource
294: (p_api_version => 1.0,
295: p_init_msg_list => fnd_api.g_false,
296: --p_commit => p_commit,
297: --p_validate_only => p_validate_only,
298: p_person_id => l_person_id,
299: p_individual => 'Y',

Line 307: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

303: x_msg_count => x_msg_count,
304: x_msg_data => x_msg_data,
305: x_resource_id => l_resource_id);
306:
307: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
309: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;

Line 308: RAISE FND_API.G_EXC_ERROR;

304: x_msg_data => x_msg_data,
305: x_resource_id => l_resource_id);
306:
307: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
309: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;
312:

Line 309: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

305: x_resource_id => l_resource_id);
306:
307: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
309: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;
312:
313: PA_RESOURCE_UTILS.Validate_Person

Line 310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

306:
307: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
309: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;
312:
313: PA_RESOURCE_UTILS.Validate_Person
314: (p_person_id => l_person_id

Line 318: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

314: (p_person_id => l_person_id
315: ,p_start_date => l_asmt_start_date
316: ,x_return_status => l_return_status);
317:
318: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
319: RAISE FND_API.G_EXC_ERROR;
320: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;

Line 319: RAISE FND_API.G_EXC_ERROR;

315: ,p_start_date => l_asmt_start_date
316: ,x_return_status => l_return_status);
317:
318: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
319: RAISE FND_API.G_EXC_ERROR;
320: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:

Line 320: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

316: ,x_return_status => l_return_status);
317:
318: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
319: RAISE FND_API.G_EXC_ERROR;
320: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:
324: -- If calling page is nominate candidate, we need to check whether the user has

Line 321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

317:
318: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
319: RAISE FND_API.G_EXC_ERROR;
320: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:
324: -- If calling page is nominate candidate, we need to check whether the user has
325: -- resource authority over nominee

Line 340: IF l_ret_code = FND_API.G_FALSE THEN

336: x_return_status => x_return_status,
337: x_msg_count => x_msg_count,
338: x_msg_data => x_msg_data);
339:
340: IF l_ret_code = FND_API.G_FALSE THEN
341: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
342: ,p_msg_name => 'PA_NO_RESOURCE_AUTHORITY' );
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;

Line 343: RAISE FND_API.G_EXC_ERROR;

339:
340: IF l_ret_code = FND_API.G_FALSE THEN
341: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
342: ,p_msg_name => 'PA_NO_RESOURCE_AUTHORITY' );
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;
345: END IF;
346:
347: l_nominated_by_person_id := Get_Person_Id;

Line 372: x_return_status := FND_API.G_RET_STS_SUCCESS;

368: l_is_cand_on_asmt := IS_CAND_ON_ASSIGNMENT(l_resource_id,p_assignment_id, l_status_code);
369:
370: IF l_is_cand_on_asmt = 'Y' THEN
371: x_msg_count := x_msg_count + 1;
372: x_return_status := FND_API.G_RET_STS_SUCCESS;
373: x_msg_data := p_resource_name;
374: RETURN;
375: END IF;
376:

Line 381: RAISE FND_API.G_EXC_ERROR;

377: IF l_status_code is null THEN
378: pa_utils.add_message
379: (p_app_short_name => 'PA',
380: p_msg_name => 'PA_CAND_STATUS_REQD');
381: RAISE FND_API.G_EXC_ERROR;
382: ELSE
383: SELECT project_system_status_code
384: INTO l_system_status_code
385: FROM pa_project_statuses

Line 456: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

452: x_return_status => l_return_status,
453: x_msg_count => l_msg_count,
454: x_msg_data => l_msg_data);
455:
456: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
457: RAISE FND_API.G_EXC_ERROR;
458: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;

Line 457: RAISE FND_API.G_EXC_ERROR;

453: x_msg_count => l_msg_count,
454: x_msg_data => l_msg_data);
455:
456: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
457: RAISE FND_API.G_EXC_ERROR;
458: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461: END IF;

Line 458: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

454: x_msg_data => l_msg_data);
455:
456: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
457: RAISE FND_API.G_EXC_ERROR;
458: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461: END IF;
462:

Line 459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

455:
456: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
457: RAISE FND_API.G_EXC_ERROR;
458: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461: END IF;
462:
463:

Line 471: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

467: p_old_system_status_code => NULL,
468: p_new_system_status_code => l_system_status_code,
469: x_return_status => l_return_status);
470:
471: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
472: RAISE FND_API.G_EXC_ERROR;
473: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;

Line 472: RAISE FND_API.G_EXC_ERROR;

468: p_new_system_status_code => l_system_status_code,
469: x_return_status => l_return_status);
470:
471: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
472: RAISE FND_API.G_EXC_ERROR;
473: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476:

Line 473: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

469: x_return_status => l_return_status);
470:
471: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
472: RAISE FND_API.G_EXC_ERROR;
473: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476:
477: EXCEPTION

Line 474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

470:
471: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
472: RAISE FND_API.G_EXC_ERROR;
473: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476:
477: EXCEPTION
478: WHEN FND_API.G_EXC_ERROR THEN

Line 478: WHEN FND_API.G_EXC_ERROR THEN

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

Line 479: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 484: (p_encoded => FND_API.G_TRUE,

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,
485: p_msg_index => 1,
486: p_msg_count => 1 ,
487: p_msg_data => l_msg_data ,
488: p_data => x_msg_data,

Line 493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 503: (p_encoded => FND_API.G_TRUE,

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,
504: p_msg_index => 1,
505: p_msg_count => 1,
506: p_msg_data => l_msg_data ,
507: p_data => x_msg_data,

Line 534: x_return_status := FND_API.G_RET_STS_SUCCESS;

530: l_record_version_number NUMBER;
531: l_return_status VARCHAR2(1);
532: BEGIN
533: -- initialize return status
534: x_return_status := FND_API.G_RET_STS_SUCCESS;
535:
536: -- get original no_of_active_candidates and record_version_number for the passed assignment_id
537: SELECT no_of_active_candidates, record_version_number
538: INTO l_no_of_active_candidates, l_record_version_number

Line 594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
596: END Update_No_Of_Active_Candidates;
597:
598:

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

610: (p_assignment_id IN NUMBER,
611: p_resource_id IN NUMBER,
612: p_status_code IN VARCHAR2,
613: p_change_reason_code IN VARCHAR2,
614: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
615: x_return_status OUT NOCOPY VARCHAR2, -- 4537865 : Added nocopy hint
616: x_msg_data OUT NOCOPY VARCHAR2, -- 4537865 : Added nocopy hint
617: x_msg_count OUT NOCOPY NUMBER) -- 4537865 : Added nocopy hint
618: IS

Line 652: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 655: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

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

Line 676: RAISE FND_API.G_EXC_ERROR;

672: pa_utils.add_message
673: (p_app_short_name => 'PA',
674: p_msg_name => 'PA_STS_NOT_VALID');
675:
676: RAISE FND_API.G_EXC_ERROR;
677: END;
678: END IF;
679:
680: BEGIN

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

714: x_msg_count => l_msg_count,
715: x_msg_data => l_msg_data,
716: x_return_status => l_return_status);
717:
718: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
719: RAISE FND_API.G_EXC_ERROR;
720: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;

Line 719: RAISE FND_API.G_EXC_ERROR;

715: x_msg_data => l_msg_data,
716: x_return_status => l_return_status);
717:
718: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
719: RAISE FND_API.G_EXC_ERROR;
720: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723:

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

716: x_return_status => l_return_status);
717:
718: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
719: RAISE FND_API.G_EXC_ERROR;
720: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723:
724: EXCEPTION

Line 721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

717:
718: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
719: RAISE FND_API.G_EXC_ERROR;
720: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723:
724: EXCEPTION
725: -- if there is no project_status_code for ASSIGN

Line 731: RAISE FND_API.G_EXC_ERROR;

727: pa_utils.add_message
728: (p_app_short_name => 'PA',
729: p_msg_name => 'PA_NO_ASSIGN_STATUS');
730:
731: RAISE FND_API.G_EXC_ERROR;
732: END;
733:
734: EXCEPTION
735: -- if the assigned person is not one of the candidates,

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

767: x_msg_count => l_msg_count,
768: x_msg_data => l_msg_data,
769: x_return_status => l_return_status);
770:
771: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
772: RAISE FND_API.G_EXC_ERROR;
773: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;

Line 772: RAISE FND_API.G_EXC_ERROR;

768: x_msg_data => l_msg_data,
769: x_return_status => l_return_status);
770:
771: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
772: RAISE FND_API.G_EXC_ERROR;
773: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;
776: END IF;

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

769: x_return_status => l_return_status);
770:
771: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
772: RAISE FND_API.G_EXC_ERROR;
773: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;
776: END IF;
777:

Line 774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

770:
771: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
772: RAISE FND_API.G_EXC_ERROR;
773: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;
776: END IF;
777:
778: END LOOP;

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

793: p_no_of_active_candidates => 0,
794: p_record_version_number => l_record_version_number,
795: x_return_status => l_return_status );
796:
797: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
798: RAISE FND_API.G_EXC_ERROR;
799: END IF;
800:
801: ELSIF p_status_code IS NULL THEN

Line 798: RAISE FND_API.G_EXC_ERROR;

794: p_record_version_number => l_record_version_number,
795: x_return_status => l_return_status );
796:
797: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
798: RAISE FND_API.G_EXC_ERROR;
799: END IF;
800:
801: ELSIF p_status_code IS NULL THEN
802:

Line 818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

814: p_old_system_status_code => l_old_system_status_code,
815: p_new_system_status_code => 'CANDIDATE_ASSIGNED',
816: x_return_status => l_return_status);
817:
818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
819: RAISE FND_API.G_EXC_ERROR;
820: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END IF;

Line 819: RAISE FND_API.G_EXC_ERROR;

815: p_new_system_status_code => 'CANDIDATE_ASSIGNED',
816: x_return_status => l_return_status);
817:
818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
819: RAISE FND_API.G_EXC_ERROR;
820: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END IF;
823:

Line 820: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

816: x_return_status => l_return_status);
817:
818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
819: RAISE FND_API.G_EXC_ERROR;
820: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END IF;
823:
824: END IF;

Line 821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

817:
818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
819: RAISE FND_API.G_EXC_ERROR;
820: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END IF;
823:
824: END IF;
825:

Line 828: WHEN FND_API.G_EXC_ERROR THEN

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

Line 829: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 834: p_encoded => FND_API.G_TRUE,

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,
835: p_msg_index => 1,
836: p_msg_count => 1 ,
837: p_msg_data => l_msg_data ,
838: p_data => x_msg_data,

Line 843: x_return_status := FND_API.G_RET_STS_SUCCESS;

839: p_msg_index_out => l_msg_index_out );
840: END IF;
841:
842: WHEN NO_DATA_FOUND THEN
843: x_return_status := FND_API.G_RET_STS_SUCCESS;
844: x_msg_count := 0; -- 4537865
845: x_msg_data := NULL ; -- 4537865
846:
847: WHEN OTHERS THEN

Line 848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 858: p_encoded => FND_API.G_TRUE,

854:
855: IF x_msg_count = 1 THEN
856:
857: pa_interface_utils_pub.get_messages(
858: p_encoded => FND_API.G_TRUE,
859: p_msg_index => 1,
860: p_msg_count => 1,
861: p_msg_data => l_msg_data,
862: p_data => x_msg_data,

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

898: p_status_code IN VARCHAR2,
899: p_change_reason_code IN VARCHAR2,
900: p_review_comments IN VARCHAR2,
901: p_cand_record_version_number IN NUMBER,
902: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs
903: x_cand_record_version_number OUT NOCOPY NUMBER, -- 4537865
904: x_return_status OUT NOCOPY VARCHAR2, -- 4537865
905: x_msg_count OUT NOCOPY NUMBER, -- 4537865
906: x_msg_data OUT NOCOPY VARCHAR2) -- 4537865

Line 933: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 949: RAISE FND_API.G_EXC_ERROR;

945: IF l_old_record_version_number <> p_cand_record_version_number THEN
946: pa_utils.add_message
947: (p_app_short_name => 'PA',
948: p_msg_name => 'PA_XC_RECORD_CHANGED');
949: RAISE FND_API.G_EXC_ERROR;
950: END IF;
951:
952: SELECT status_code
953: INTO l_old_status_code

Line 983: RAISE FND_API.G_EXC_ERROR;

979: pa_utils.add_message
980: (p_app_short_name => 'PA',
981: p_msg_name => 'PA_CAND_NO_STATUS_CHANGE');
982:
983: RAISE FND_API.G_EXC_ERROR;
984: END IF;
985:
986: -- check if a comment is passed. If no
987: -- comment is passed, then return without making an entry in

Line 989: IF p_review_comments = FND_API.G_MISS_CHAR or

985:
986: -- check if a comment is passed. If no
987: -- comment is passed, then return without making an entry in
988: -- the log file.
989: IF p_review_comments = FND_API.G_MISS_CHAR or
990: p_review_comments is null THEN
991: RETURN;
992: END IF;
993:

Line 1025: RAISE FND_API.G_EXC_ERROR;

1021: pa_utils.add_message
1022: (p_app_short_name => 'PA',
1023: p_msg_name => 'PA_STATUS_CANT_CHANGE');
1024:
1025: RAISE FND_API.G_EXC_ERROR;
1026: END IF;
1027:
1028: -- Check if the change of status requires change reason
1029: -- to be specified.

Line 1035: RAISE FND_API.G_EXC_ERROR;

1031: AND p_change_reason_code is null THEN
1032: pa_utils.add_message
1033: (p_app_short_name => 'PA',
1034: p_msg_name => 'PA_CAND_CHG_REASON_REQD');
1035: RAISE FND_API.G_EXC_ERROR;
1036: END IF;
1037:
1038: -- Update pa_candidates with the new status code
1039: -- Added WHO Column update. Bug 7168412.

Line 1081: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1077: p_new_system_status_code => l_system_status_code,
1078: x_return_status => x_return_status);
1079:
1080: -- 4537865 Earlier wrong check was made against l_return_status
1081: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1082: RAISE FND_API.G_EXC_ERROR;
1083: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;

Line 1082: RAISE FND_API.G_EXC_ERROR;

1078: x_return_status => x_return_status);
1079:
1080: -- 4537865 Earlier wrong check was made against l_return_status
1081: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1082: RAISE FND_API.G_EXC_ERROR;
1083: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;
1086: END IF;

Line 1083: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1079:
1080: -- 4537865 Earlier wrong check was made against l_return_status
1081: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1082: RAISE FND_API.G_EXC_ERROR;
1083: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;
1086: END IF;
1087:

Line 1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1080: -- 4537865 Earlier wrong check was made against l_return_status
1081: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1082: RAISE FND_API.G_EXC_ERROR;
1083: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;
1086: END IF;
1087:
1088: -- set the updated record_version_number to the out parameter.

Line 1146: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1142: x_msg_data => l_msg_data);
1143:
1144: END IF;
1145:
1146: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1147: RAISE FND_API.G_EXC_ERROR;
1148: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END IF;

Line 1147: RAISE FND_API.G_EXC_ERROR;

1143:
1144: END IF;
1145:
1146: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1147: RAISE FND_API.G_EXC_ERROR;
1148: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END IF;
1151: END IF;

Line 1148: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1144: END IF;
1145:
1146: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1147: RAISE FND_API.G_EXC_ERROR;
1148: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END IF;
1151: END IF;
1152:

Line 1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1145:
1146: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1147: RAISE FND_API.G_EXC_ERROR;
1148: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END IF;
1151: END IF;
1152:
1153: EXCEPTION

Line 1154: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1155: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1163: (p_encoded => FND_API.G_TRUE

1159: x_cand_record_version_number := NULL ;
1160:
1161: IF x_msg_count = 1 THEN
1162: pa_interface_utils_pub.get_messages
1163: (p_encoded => FND_API.G_TRUE
1164: ,p_msg_index => 1
1165: ,p_msg_count => 1
1166: ,p_msg_data => l_msg_data
1167: ,p_data => x_msg_data

Line 1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1167: ,p_data => x_msg_data
1168: ,p_msg_index_out => l_msg_index_out );
1169: END IF;
1170: WHEN OTHERS THEN
1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1172:
1173: -- 4537865 : RESET OUT PARAM
1174: x_cand_record_version_number := NULL ;
1175:

Line 1184: (p_encoded => FND_API.G_TRUE

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
1185: ,p_msg_index => 1
1186: ,p_msg_count => 1
1187: ,p_msg_data => l_msg_data
1188: ,p_data => x_msg_data

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

1218: p_status_code IN VARCHAR2,
1219: p_ranking IN NUMBER,
1220: p_change_reason_code IN VARCHAR2,
1221: p_record_version_number IN NUMBER,
1222: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1223: p_validate_status IN VARCHAR2 := FND_API.G_TRUE,
1224: x_record_version_number OUT NOCOPY NUMBER, -- 4537865 Added nocopy hint
1225: x_msg_count OUT NOCOPY NUMBER, -- 4537865 Added nocopy hint
1226: x_msg_data OUT NOCOPY VARCHAR2, -- 4537865 Added nocopy hint

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

1219: p_ranking IN NUMBER,
1220: p_change_reason_code IN VARCHAR2,
1221: p_record_version_number IN NUMBER,
1222: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1223: p_validate_status IN VARCHAR2 := FND_API.G_TRUE,
1224: x_record_version_number OUT NOCOPY NUMBER, -- 4537865 Added nocopy hint
1225: x_msg_count OUT NOCOPY NUMBER, -- 4537865 Added nocopy hint
1226: x_msg_data OUT NOCOPY VARCHAR2, -- 4537865 Added nocopy hint
1227: x_return_status OUT NOCOPY VARCHAR2) -- 4537865 Added nocopy hint

Line 1254: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1257: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

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

Line 1284: RAISE FND_API.G_EXC_ERROR;

1280: WHEN NO_DATA_FOUND THEN
1281: pa_utils.add_message
1282: (p_app_short_name => 'PA',
1283: p_msg_name => 'PA_CAND_NOT_FOUND');
1284: RAISE FND_API.G_EXC_ERROR;
1285: WHEN OTHERS THEN
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END;
1288:

Line 1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1282: (p_app_short_name => 'PA',
1283: p_msg_name => 'PA_CAND_NOT_FOUND');
1284: RAISE FND_API.G_EXC_ERROR;
1285: WHEN OTHERS THEN
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END;
1288:
1289: IF l_old_record_version_number <> p_record_version_number THEN
1290: pa_utils.add_message

Line 1293: RAISE FND_API.G_EXC_ERROR;

1289: IF l_old_record_version_number <> p_record_version_number THEN
1290: pa_utils.add_message
1291: (p_app_short_name => 'PA',
1292: p_msg_name => 'PA_XC_RECORD_CHANGED');
1293: RAISE FND_API.G_EXC_ERROR;
1294: END IF;
1295:
1296: IF l_status_code is null THEN
1297: l_system_status_code := null;

Line 1321: RAISE FND_API.G_EXC_ERROR;

1317: AND l_old_system_status_code <> 'CANDIDATE_SYSTEM_NOMINATED' THEN
1318: pa_utils.add_message
1319: (p_app_short_name => 'PA',
1320: p_msg_name => 'PA_CAND_STATUS_NOT_ALLOWED');
1321: RAISE FND_API.G_EXC_ERROR;
1322: END IF;
1323:
1324: IF FND_API.TO_BOOLEAN(p_validate_status) THEN
1325: -- Status has not changed. Check to see if change reason is passed.

Line 1324: IF FND_API.TO_BOOLEAN(p_validate_status) THEN

1320: p_msg_name => 'PA_CAND_STATUS_NOT_ALLOWED');
1321: RAISE FND_API.G_EXC_ERROR;
1322: END IF;
1323:
1324: IF FND_API.TO_BOOLEAN(p_validate_status) THEN
1325: -- Status has not changed. Check to see if change reason is passed.
1326: -- The user should not update Change Reason if status is not
1327: -- updated.
1328: IF nvl(l_old_status_code,'-1') = nvl(l_status_code,'-1') THEN

Line 1334: RAISE FND_API.G_EXC_ERROR;

1330: IF p_change_reason_code is not null THEN
1331: pa_utils.add_message
1332: (p_app_short_name => 'PA',
1333: p_msg_name => 'PA_CAND_NO_STATUS_CHANGE');
1334: RAISE FND_API.G_EXC_ERROR;
1335:
1336: -- If nothing has been updated, just return without updating anything.
1337: ELSIF p_change_reason_code is null
1338: AND nvl(l_old_candidate_ranking,'-1') = nvl(p_ranking,'-1') THEN

Line 1353: RAISE FND_API.G_EXC_ERROR;

1349: pa_utils.add_message
1350: (p_app_short_name => 'PA',
1351: p_msg_name => 'PA_STATUS_CANT_CHANGE');
1352:
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;
1355:
1356: -- Check if reason is required for the status change
1357: IF (pa_project_utils.Check_prj_stus_action_allowed

Line 1364: RAISE FND_API.G_EXC_ERROR;

1360: pa_utils.add_message
1361: (p_app_short_name => 'PA',
1362: p_msg_name => 'PA_CAND_CHG_REASON_REQD');
1363:
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;
1366: END IF;
1367: END IF;
1368:

Line 1425: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1421: p_old_system_status_code => l_old_system_status_code,
1422: p_new_system_status_code => l_system_status_code,
1423: x_return_status => l_return_status);
1424:
1425: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1426: RAISE FND_API.G_EXC_ERROR;
1427: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1429: END IF;

Line 1426: RAISE FND_API.G_EXC_ERROR;

1422: p_new_system_status_code => l_system_status_code,
1423: x_return_status => l_return_status);
1424:
1425: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1426: RAISE FND_API.G_EXC_ERROR;
1427: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1429: END IF;
1430:

Line 1427: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1423: x_return_status => l_return_status);
1424:
1425: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1426: RAISE FND_API.G_EXC_ERROR;
1427: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1429: END IF;
1430:
1431: SELECT ENABLE_WF_FLAG, WORKFLOW_ITEM_TYPE, WORKFLOW_PROCESS, PROJECT_STATUS_NAME

Line 1428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1424:
1425: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1426: RAISE FND_API.G_EXC_ERROR;
1427: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1429: END IF;
1430:
1431: SELECT ENABLE_WF_FLAG, WORKFLOW_ITEM_TYPE, WORKFLOW_PROCESS, PROJECT_STATUS_NAME
1432: INTO l_enable_wf_flag, l_wf_item_type, l_wf_process, l_status_name

Line 1453: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1449: x_msg_count => l_msg_count,
1450: x_msg_data => l_msg_data);
1451: END IF;
1452:
1453: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1454: RAISE FND_API.G_EXC_ERROR;
1455: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END IF;

Line 1454: RAISE FND_API.G_EXC_ERROR;

1450: x_msg_data => l_msg_data);
1451: END IF;
1452:
1453: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1454: RAISE FND_API.G_EXC_ERROR;
1455: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END IF;
1458: END IF;

Line 1455: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1451: END IF;
1452:
1453: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1454: RAISE FND_API.G_EXC_ERROR;
1455: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END IF;
1458: END IF;
1459:

Line 1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1452:
1453: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1454: RAISE FND_API.G_EXC_ERROR;
1455: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END IF;
1458: END IF;
1459:
1460: EXCEPTION

Line 1461: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1462: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1470: (p_encoded => FND_API.G_TRUE,

1466: x_record_version_number := NULL ;
1467:
1468: IF x_msg_count = 1 THEN
1469: pa_interface_utils_pub.get_messages
1470: (p_encoded => FND_API.G_TRUE,
1471: p_msg_index => 1,
1472: p_msg_count => 1 ,
1473: p_msg_data => l_msg_data ,
1474: p_data => x_msg_data,

Line 1479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1475: p_msg_index_out => l_msg_index_out );
1476: END IF;
1477:
1478: WHEN OTHERS THEN
1479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1480:
1481: -- 4537865 : RESET OUT PARAM
1482: x_record_version_number := NULL ;
1483:

Line 1493: (p_encoded => FND_API.G_TRUE

1489:
1490:
1491: IF x_msg_count = 1 THEN
1492: pa_interface_utils_pub.get_messages
1493: (p_encoded => FND_API.G_TRUE
1494: ,p_msg_index => 1
1495: ,p_msg_count => 1
1496: ,p_msg_data => l_msg_data
1497: ,p_data => x_msg_data

Line 1654: x_return_status := FND_API.G_RET_STS_SUCCESS;

1650: l_msg_count NUMBER := 0;
1651: l_data VARCHAR2(500);
1652: l_msg_index_out NUMBER ;
1653: BEGIN
1654: x_return_status := FND_API.G_RET_STS_SUCCESS;
1655:
1656: l_in_resource_list := p_resource_list || ',';
1657: j:= 1;
1658: initial := 1;

Line 1707: x_return_status := FND_API.G_RET_STS_SUCCESS;

1703: x_invalid_candidates := l_candidate_list;
1704: x_msg_count := 1;
1705: END IF;
1706:
1707: x_return_status := FND_API.G_RET_STS_SUCCESS;
1708: x_resource_list := l_resource_list;
1709:
1710: EXCEPTION
1711: WHEN OTHERS THEN

Line 1713: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

1709:
1710: EXCEPTION
1711: WHEN OTHERS THEN
1712: -- 4537865 RESET OUT PARAMS
1713: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
1714: x_msg_count := 1;
1715: x_resource_list := NULL ;
1716: x_invalid_candidates := NULL ;
1717:

Line 1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
1725:
1726: END;
1727:
1728:

Line 1873: x_return_status := FND_API.G_RET_STS_SUCCESS;

1869: l_count_recipients NUMBER := 0; -- Added for Bug 6144224
1870:
1871: BEGIN
1872: -- initialize return_status to success
1873: x_return_status := FND_API.G_RET_STS_SUCCESS;
1874: --dbms_output.put_line('begin-- p_wf_item_type ' || p_wf_item_type);
1875: --dbms_output.put_line('begin-- p_wf_process ' || p_wf_process);
1876: --dbms_output.put_line('begin-- p_status_name ' || p_status_name);
1877:

Line 1887: x_return_status := FND_API.G_RET_STS_ERROR;

1883: -- Now start fetching the details
1884: OPEN l_assignments_csr;
1885: FETCH l_assignments_csr INTO l_assignments_rec;
1886: IF l_assignments_csr%NOTFOUND THEN
1887: x_return_status := FND_API.G_RET_STS_ERROR;
1888: pa_utils.add_message (p_app_short_name => 'PA',
1889: p_msg_name => 'PA_INVALID_ASMGT_ID');
1890: CLOSE l_assignments_csr;
1891: ELSE

Line 1898: x_return_status := FND_API.G_RET_STS_ERROR;

1894:
1895: OPEN l_projects_csr(l_assignments_rec.project_id);
1896: FETCH l_projects_csr INTO l_projects_rec;
1897: IF l_projects_csr%NOTFOUND THEN
1898: x_return_status := FND_API.G_RET_STS_ERROR;
1899: pa_utils.add_message (p_app_short_name => 'PA',
1900: p_msg_name => 'PA_INVALID_PROJECT_ID');
1901: CLOSE l_projects_csr;
1902: ELSE

Line 2358: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;

2354:
2355: EXCEPTION
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');

Line 2369: (p_encoded => FND_API.G_TRUE

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
2370: ,p_msg_index => 1
2371: ,p_msg_count => 1
2372: ,p_msg_data => l_msg_data
2373: ,p_data => x_msg_data

Line 2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2373: ,p_data => x_msg_data
2374: ,p_msg_index_out => l_msg_index_out );
2375: END IF;
2376:
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378:
2379: END Start_Workflow;
2380:
2381:

Line 2413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2409: RETURN l_employee_id;
2410:
2411: EXCEPTION
2412: WHEN OTHERS THEN
2413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414:
2415: END Get_Person_Id;
2416:
2417:

Line 2461: x_return_status := FND_API.G_RET_STS_SUCCESS;

2457: l_candidates_tbl number_tbl;
2458: BEGIN
2459: -- x_msg_count and x_msg_data are dummy variables, they are
2460: -- reserved for further expansion of this procedure
2461: x_return_status := FND_API.G_RET_STS_SUCCESS;
2462: x_msg_count := 0;
2463: x_msg_data := null;
2464:
2465: IF p_status_code IS NULL THEN

Line 2493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2489: END IF;
2490:
2491: EXCEPTION
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',

Line 2506: (p_encoded => FND_API.G_TRUE

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
2507: ,p_msg_index => 1
2508: ,p_msg_count => 1
2509: ,p_msg_data => l_msg_data
2510: ,p_data => x_msg_data

Line 2540: x_return_status := FND_API.G_RET_STS_SUCCESS;

2536: BEGIN
2537: -- x_msg_count and x_msg_data are dummy variables, they are
2538: -- reserved for further expansion of this procedure
2539:
2540: x_return_status := FND_API.G_RET_STS_SUCCESS;
2541: x_msg_count := 0;
2542: x_msg_data := null;
2543:
2544: SELECT asmt.no_of_active_candidates,

Line 2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2573:
2574: EXCEPTION
2575:
2576: WHEN OTHERS THEN
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

Line 2591: (p_encoded => FND_API.G_TRUE

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
2592: ,p_msg_index => 1
2593: ,p_msg_count => 1
2594: ,p_msg_data => l_msg_data
2595: ,p_data => x_msg_data

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

2656: BEGIN
2657:
2658: -- 4537865 : INITIALIZE OUT PARAMS
2659:
2660: l_return_status := FND_API.G_RET_STS_SUCCESS; -- At the end we will assign l_return_status to x_return_status
2661: x_msg_count := 0;
2662: x_msg_data := null;
2663:
2664: FOR c2 in c1 LOOP

Line 2764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2760:
2761: EXCEPTION
2762: WHEN OTHERS THEN
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',

Line 2775: (p_encoded => FND_API.G_TRUE

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
2776: ,p_msg_index => 1
2777: ,p_msg_count => 1
2778: ,p_msg_data => l_msg_data
2779: ,p_data => x_msg_data

Line 2783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2779: ,p_data => x_msg_data
2780: ,p_msg_index_out => l_msg_index_out );
2781: END IF;
2782:
2783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2784:
2785: END Copy_Candidates;
2786:
2787: /*-------------------------------------------------------------------------

Line 2821: x_return_status := FND_API.G_RET_STS_SUCCESS;

2817:
2818: -- 4537865
2819: l_msg_index_out NUMBER ;
2820: BEGIN
2821: x_return_status := FND_API.G_RET_STS_SUCCESS;
2822: x_msg_count := 0;
2823: x_msg_data := null;
2824:
2825: -- Gather the candidate_ids that needs to be declined

Line 2938: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2934: x_msg_count => l_msg_count,
2935: x_msg_data => l_msg_data);
2936: END IF;
2937:
2938: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2939: RAISE FND_API.G_EXC_ERROR;
2940: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2942: END IF;

Line 2939: RAISE FND_API.G_EXC_ERROR;

2935: x_msg_data => l_msg_data);
2936: END IF;
2937:
2938: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2939: RAISE FND_API.G_EXC_ERROR;
2940: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2942: END IF;
2943: END LOOP;

Line 2940: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2936: END IF;
2937:
2938: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2939: RAISE FND_API.G_EXC_ERROR;
2940: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2942: END IF;
2943: END LOOP;
2944:

Line 2941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2937:
2938: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2939: RAISE FND_API.G_EXC_ERROR;
2940: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2942: END IF;
2943: END LOOP;
2944:
2945: SELECT record_version_number

Line 2961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2957: END IF;
2958:
2959: EXCEPTION
2960: WHEN OTHERS THEN
2961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2962:
2963: --4537865
2964: x_msg_data := SUBSTRB(SQLERRM,1,240) ;
2965:

Line 2974: (p_encoded => FND_API.G_TRUE

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
2975: ,p_msg_index => 1
2976: ,p_msg_count => 1
2977: ,p_msg_data => l_msg_data
2978: ,p_data => x_msg_data