226: --dbms_output.put_line('AFTER check org ... '||l_return_status);
227:
228: IF l_return_status = FND_API.G_RET_STS_ERROR
229: THEN
230: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
231: p_msg_name => l_error_msg_code);
232:
233: x_msg_data := l_error_msg_code;
234: x_return_status := 'E';
259: ,x_error_msg_code => l_error_msg_code);
260: --dbms_output.put_line('AFTER check project status ... '||l_return_status);
261: IF l_return_status = FND_API.G_RET_STS_ERROR
262: THEN
263: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
264: p_msg_name => l_error_msg_code);
265: x_msg_data := l_error_msg_code;
266: x_return_status := 'E';
267: END IF;
295: --dbms_output.put_line('AFTER check probablity ... '||l_return_status);
296:
297: IF l_return_status = FND_API.G_RET_STS_ERROR
298: THEN
299: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
300: p_msg_name => l_error_msg_code);
301: x_msg_data := l_error_msg_code;
302: x_return_status := 'E';
303: END IF;
325:
326: --dbms_output.put_line('AFTER check customer or customer call ... '||l_return_status);
327: IF l_return_status <> 'S'
328: THEN
329: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
330: p_msg_name => l_error_msg_code);
331: x_msg_data := l_error_msg_code;
332: x_return_status := 'E';
333: END IF;
353: ,x_error_msg_code => l_error_msg_code);
354:
355: IF l_return_status <> 'S'
356: THEN
357: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
358: p_msg_name => l_error_msg_code||'_BILL');
359: x_msg_data := l_error_msg_code;
360: x_return_status := 'E';
361: END IF;
380: ,x_error_msg_code => l_error_msg_code);
381:
382: IF l_return_status <> 'S'
383: THEN
384: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
385: p_msg_name => l_error_msg_code||'_SHIP');
386: x_msg_data := l_error_msg_code;
387: x_return_status := 'E';
388: END IF;
406: ,x_return_status => l_return_status
407: ,x_error_message_code => l_error_msg_code);
408:
409: if l_return_status <> 'S' then
410: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
411: p_msg_name => l_error_msg_code);
412: x_msg_data := l_error_msg_code;
413: x_return_status := 'E';
414: end if;
430: ,x_return_status => l_return_status
431: ,x_error_message_code => l_error_msg_code);
432:
433: if l_return_status <> 'S' then
434: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
435: p_msg_name => l_error_msg_code);
436: x_msg_data := l_error_msg_code;
437: x_return_status := 'E';
438: end if;
454: ,x_return_status => l_return_status
455: ,x_error_msg_code => l_error_msg_code);
456:
457: if l_return_status <> 'S' then
458: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
459: p_msg_name => l_error_msg_code);
460: x_msg_data := l_error_msg_code;
461: x_return_status := 'E';
462: end if;
478: ,x_return_status => l_return_status
479: ,x_error_msg_code => l_error_msg_code);
480:
481: if l_return_status <> 'S' then
482: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
483: p_msg_name => l_error_msg_code);
484: x_msg_data := l_error_msg_code;
485: x_return_status := 'E';
486: end if;
503: ,x_return_status => l_return_status
504: ,x_error_msg_code => l_error_msg_code);
505:
506: if l_return_status <> 'S' then
507: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
508: p_msg_name => l_error_msg_code);
509: x_msg_data := l_error_msg_code;
510: x_return_status := 'E';
511: end if;
794: ,x_error_msg_code => l_error_msg_code);
795:
796: IF l_return_status <> 'S'
797: THEN
798: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
799: p_msg_name => l_error_msg_code);
800: x_msg_data := l_error_msg_code;
801: x_return_status := 'E';
802: END IF;
800: x_msg_data := l_error_msg_code;
801: x_return_status := 'E';
802: END IF;
803: -- ELSE
804: -- PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
805: -- p_msg_name => 'PA_PROJ_CUST_ID_NOT_PASSED');
806: -- x_msg_data := 'PA_PROJ_CUST_ID_NOT_PASSED';
807: END IF;
808:
1055:
1056: --dbms_output.put_line('Check original project id ... ');
1057:
1058: if (p_project_id is null) then
1059: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1060: p_msg_name => 'PA_NO_PROJECT_ID');
1061: x_msg_data := 'PA_NO_PROJECT_ID';
1062: x_return_status := 'E';
1063: --dbms_output.put_line('p_project_id is null RETURN STATUS : '||x_return_status);
1085: ,x_return_status => l_return_status
1086: ,x_error_msg_code => l_error_msg_code);
1087: IF l_return_status = FND_API.G_RET_STS_ERROR
1088: THEN
1089: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1090: p_msg_name => l_error_msg_code);
1091: x_msg_data := l_error_msg_code;
1092: x_return_status := 'E';
1093: END IF;
1387: --dbms_output.put_line('AFTER check org ... '||l_return_status);
1388:
1389: IF l_return_status = FND_API.G_RET_STS_ERROR
1390: THEN
1391: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1392: p_msg_name => l_error_msg_code);
1393: x_msg_data := l_error_msg_code;
1394: x_return_status := 'E';
1395: END IF;
1696: -- End: Bug 4469624 - check for p_debug_mode before call to PA_DEBUG.WRITE
1697:
1698: IF l_return_status = FND_API.G_RET_STS_ERROR
1699: THEN
1700: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1701: p_msg_name => l_error_msg_code);
1702: x_msg_data := l_error_msg_code;
1703: x_return_status := 'E';
1704: END IF;
1980: FROM pa_class_categories
1981: WHERE CLASS_CATEGORY = p_class_category;
1982:
1983: EXCEPTION WHEN NO_DATA_FOUND THEN
1984: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1985: p_msg_name => 'PA_AL_INVALID_CLASS_CATG_PROJE');
1986: x_msg_data := 'PA_AL_INVALID_CLASS_CATG_PROJE';
1987: x_return_status := 'E' ;
1988: WHEN OTHERS THEN
2006: CLASS_CATEGORY = p_class_category and
2007: trunc(sysdate) between trunc(start_date_active) and nvl(trunc(end_date_active), trunc(sysdate));
2008:
2009: EXCEPTION WHEN NO_DATA_FOUND THEN
2010: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2011: p_msg_name => 'PA_CLASS_CATG_CODE_INVALID');
2012: x_msg_data := 'PA_CLASS_CATG_CODE_INVALID';
2013: x_return_status := 'E' ;
2014: WHEN OTHERS THEN
2296: FROM pa_class_categories
2297: WHERE CLASS_CATEGORY = p_class_category;
2298:
2299: EXCEPTION WHEN NO_DATA_FOUND THEN
2300: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2301: p_msg_name => 'PA_AL_INVALID_CLASS_CATG_PROJE');
2302: x_msg_data := 'PA_AL_INVALID_CLASS_CATG_PROJE';
2303: x_return_status := 'E' ;
2304: WHEN OTHERS THEN
2322: CLASS_CATEGORY = p_class_category and
2323: trunc(sysdate) between trunc(start_date_active) and nvl(trunc(end_date_active), trunc(sysdate));
2324:
2325: EXCEPTION WHEN NO_DATA_FOUND THEN
2326: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2327: p_msg_name => 'PA_CLASS_CATG_CODE_INVALID');
2328: x_msg_data := 'PA_CLASS_CATG_CODE_INVALID';
2329: x_return_status := 'E' ;
2330: WHEN OTHERS THEN
2733: p_avail_match_weighting > 100 OR
2734: p_job_level_match_weighting < 0 OR
2735: p_job_level_match_weighting > 100 THEN
2736:
2737: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2738: ,p_msg_name => 'PA_INVALID_MATCH_WEIGHTING');
2739: x_msg_data := 'PA_INVALID_MATCH_WEIGHTING';
2740: x_return_status := FND_API.G_RET_STS_ERROR;
2741:
2750:
2751: IF p_search_min_availability < 0 OR
2752: p_search_min_availability > 100 THEN
2753:
2754: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2755: ,p_msg_name => 'PA_MIN_AVAIL_INVALID');
2756: x_msg_data := 'PA_MIN_AVAIL_INVALID';
2757: x_return_status := FND_API.G_RET_STS_ERROR;
2758: END IF;
2767:
2768: IF p_search_min_candidate_score < 0 OR
2769: p_search_min_candidate_score > 100 THEN
2770:
2771: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2772: ,p_msg_name => 'PA_MIN_CAN_SCORE_INVALID');
2773: x_msg_data := 'PA_MIN_CAN_SCORE_INVALID';
2774: x_return_status := FND_API.G_RET_STS_ERROR;
2775: END IF;
2806: x_error_msg_code => l_error_message_code);
2807:
2808:
2809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2810: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
2811: ,p_msg_name => l_error_message_code );
2812: x_msg_data := l_error_message_code;
2813: x_return_status := FND_API.G_RET_STS_ERROR;
2814: ELSE
2824: x_error_message_code => l_error_message_code);
2825:
2826:
2827: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2828: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
2829: ,p_msg_name => l_error_message_code );
2830:
2831: END IF;
2832:
2850: x_error_msg_code => l_error_message_code);
2851:
2852:
2853: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2854: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
2855: ,p_msg_name => l_error_message_code );
2856: x_msg_data := l_error_message_code;
2857: x_return_status := FND_API.G_RET_STS_ERROR;
2858:
2868: x_return_status => l_return_status,
2869: x_error_message_code => l_error_message_code);
2870:
2871: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2872: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
2873: ,p_msg_name => l_error_message_code );
2874: x_msg_data := l_error_message_code;
2875: x_return_status := FND_API.G_RET_STS_ERROR;
2876: END IF;
2894: x_return_status => l_return_status,
2895: x_error_message_code => l_error_message_code);
2896:
2897: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2898: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
2899: ,p_msg_name => l_error_message_code );
2900: x_msg_data := l_error_message_code;
2901: x_return_status := FND_API.G_RET_STS_ERROR;
2902:
2917: x_return_status => l_return_status,
2918: x_error_message_code => l_error_message_code);
2919:
2920: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2921: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
2922: ,p_msg_name => l_error_message_code );
2923: x_msg_data := l_error_message_code;
2924: x_return_status := FND_API.G_RET_STS_ERROR;
2925: END IF;
3517: NULL;
3518: END;
3519:
3520: IF l_cant_update_status = 'Y' THEN
3521: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3522: p_msg_name => 'PA_PR_PM_FIELD_CANNOT_CHANGE');
3523: RAISE FND_API.G_EXC_ERROR;
3524: END IF;
3525: -- Bug 12809532 : End of changes
3529: Pa_Debug.WRITE(G_PKG_NAME,'Calling ALLOW_STATUS_CHANGE', l_debug_level3);
3530: END IF;
3531:
3532: IF (PA_PROJECT_STUS_UTILS.ALLOW_STATUS_CHANGE(l_old_project_status,p_new_status_code) = 'N') THEN
3533: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3534: p_msg_name => 'PA_STATUS_CANT_CHANGE');
3535: RAISE FND_API.G_EXC_ERROR;
3536: END IF;
3537: -- Bug 4565023: End
3719: , l_err_stage
3720: , l_err_code );
3721:
3722: IF l_err_code <> 0 THEN
3723: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3724: p_msg_name => l_err_stage);
3725: x_msg_data := l_err_stack||'-> '||l_err_stage;
3726: RAISE FND_API.G_EXC_ERROR;
3727: END IF;
3726: RAISE FND_API.G_EXC_ERROR;
3727: END IF;
3728: END IF;
3729: ELSE
3730: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3731: p_msg_name => 'PA_STATUS_CANT_CHANGE');
3732: RAISE FND_API.G_EXC_ERROR;
3733: END IF;
3734: