DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_PUB dependencies on PA_UTILS

Line 230: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

Line 263: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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;

Line 299: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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;

Line 329: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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;

Line 357: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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;

Line 384: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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;

Line 410: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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;

Line 434: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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;

Line 458: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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;

Line 482: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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;

Line 507: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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;

Line 798: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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;

Line 804: -- PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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:

Line 1059: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

Line 1089: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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;

Line 1391: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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;

Line 1700: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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;

Line 1984: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

Line 2010: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

Line 2300: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

Line 2326: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

Line 2737: PA_UTILS.Add_Message( p_app_short_name => 'PA'

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:

Line 2754: PA_UTILS.Add_Message( p_app_short_name => 'PA'

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;

Line 2771: PA_UTILS.Add_Message( p_app_short_name => 'PA'

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;

Line 2810: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

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

Line 2828: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

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:

Line 2854: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

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:

Line 2872: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

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;

Line 2898: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

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:

Line 2921: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

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;

Line 3521: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

Line 3533: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

Line 3723: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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;

Line 3730: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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: