169:
170: -- if the assignment number is not valid then
171: -- add a message to the error stack.
172: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
173: PA_UTILS.Add_Message ('PA', l_error_message_code);
174: END IF;
175:
176: END IF;
177:
230: x_return_status => l_return_status,
231: x_error_msg_code => l_error_msg_data);
232:
233: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
234: PA_UTILS.Add_Message ('PA', l_error_msg_data);
235: ELSE
236:
237: -- check if the org hierarchy is of the correct type
238: -- i.e. EXPENDITURES for resource search
244: x_return_status => l_return_status,
245: x_error_message_code => l_error_msg_data);
246:
247: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
248: PA_UTILS.Add_Message ('PA', l_error_msg_data);
249: END IF;
250: END IF;
251:
252: END IF;
266: x_return_status => l_return_status,
267: x_error_msg_code => l_error_msg_data);
268:
269: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
270: PA_UTILS.Add_Message ('PA', l_error_msg_data);
271: ELSE
272: -- check if the starting org is of the correct type
273: -- i.e. EXPENDITURES for resource search
274: -- PROJECTS for requirement search
279: x_return_status => l_return_status,
280: x_error_message_code => l_error_msg_data);
281:
282: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
283: PA_UTILS.Add_Message ('PA', l_error_msg_data);
284: END IF;
285: END IF;
286:
287: END IF;
306: x_return_status => l_return_status,
307: x_error_message_code => l_error_msg_data);
308:
309: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
310: PA_UTILS.Add_Message ('PA', l_error_msg_data);
311: END IF;
312: END IF;
313: END IF;
314:
327: x_return_status => l_return_status,
328: x_error_message_code => l_error_msg_data);
329:
330: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
331: PA_UTILS.Add_Message ('PA', l_error_msg_data);
332: END IF;
333: END IF;
334:
335: -- validate the staffing owner and assign it to global record
349: ,x_return_status => l_return_status
350: ,x_error_message_code => l_error_message_code);
351:
352: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_resource_type_id <> 101 THEN
353: PA_UTILS.Add_Message ('PA', 'PA_INV_STAFF_OWNER');
354: END IF;
355:
356: END IF;
357:
371: x_return_status => l_return_status,
372: x_error_message_code => l_error_msg_data);
373:
374: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
375: PA_UTILS.Add_Message ('PA', l_error_msg_data);
376: END IF;
377: END IF;
378:
379: -- Add region and city values to global search criteria.
405: p_avail_match_weighting < 0 OR p_avail_match_weighting > 100 OR
406: p_job_level_match_weighting < 0 OR p_job_level_match_weighting > 100
407: THEN
408:
409: PA_UTILS.Add_Message(
410: p_app_short_name => 'PA'
411: ,p_msg_name => 'PA_INVALID_MATCH_WEIGHTING');
412: ELSE
413: -- assign match weightings to global record.
441: ,x_return_status => l_return_status
442: ,x_error_message_code => l_error_message_code);
443:
444: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
445: PA_UTILS.Add_Message ('PA', l_error_message_code);
446: END IF;
447:
448: END IF;
449:
462: ,x_return_status => l_return_status
463: ,x_error_message_code => l_error_message_code );
464:
465: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
466: PA_UTILS.Add_Message ('PA', l_error_message_code);
467: END IF;
468:
469: END IF;
470:
476: (p_max_job_level <> FND_API.G_MISS_NUM AND
477: p_max_job_level IS NOT NULL)
478: THEN
479: IF p_min_job_level > p_max_job_level THEN
480: PA_UTILS.Add_Message(
481: p_app_short_name => 'PA'
482: ,p_msg_name => 'PA_MIN_JL_GREATER_THAN_MAX');
483: ELSE
484:
492: IF p_minimum_availability <> FND_API.G_MISS_NUM AND
493: p_minimum_availability IS NOT NULL
494: THEN
495: IF p_minimum_availability < 0 OR p_minimum_availability > 100 THEN
496: PA_UTILS.Add_Message( p_app_short_name => 'PA'
497: ,p_msg_name => 'PA_MIN_AVAIL_INVALID');
498: END IF;
499:
500: -- assign the min availability to the global record.
522: (p_end_date <> FND_API.G_MISS_DATE AND p_end_date IS NOT NULL)
523: THEN
524:
525: IF p_start_date > p_end_date THEN
526: PA_UTILS.Add_Message( p_app_short_name => 'PA'
527: ,p_msg_name => 'PA_INVALID_START_DATE');
528:
529: ELSE
530:
537:
538: IF (p_search_mode = 'RESOURCE') AND
539: Trunc(p_start_date) < Trunc(SYSDATE) AND
540: Trunc(p_end_date) < Trunc(SYSDATE) THEN
541: PA_UTILS.Add_Message(p_app_short_name => 'PA'
542: ,p_msg_name => 'PA_REQ_DATES_IN_PAST');
543: END IF;
544:
545: ELSIF (p_start_date <> FND_API.G_MISS_DATE AND
590: END IF;
591: -- added for Bug fix: 4537865
592:
593: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
594: PA_UTILS.Add_Message ('PA', l_error_msg_data);
595: ELSE
596:
597: -- insert the competence into the global table at l_index.
598: PA_SEARCH_GLOB.g_competence_criteria(l_index).competence_id :=
654:
655: IF Trunc(PA_SEARCH_GLOB.g_search_criteria.start_date) < Trunc(SYSDATE) AND
656: Trunc(PA_SEARCH_GLOB.g_search_criteria.end_date) < Trunc(SYSDATE)
657: THEN
658: PA_UTILS.Add_Message(p_app_short_name => 'PA'
659: ,p_msg_name => 'PA_REQ_DATES_IN_PAST');
660: END IF;
661:
662: IF get_search_criteria%NOTFOUND THEN
676: x_error_message_code => l_error_msg_data,
677: x_return_status => l_return_status);
678:
679: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
680: PA_UTILS.Add_Message ('PA', l_error_msg_data);
681:
682: ELSIF l_competency_tbl.COUNT > 0 THEN
683:
684: -- store the competences in the global comp table.