APPS.PA_PROJECTS_MAINT_PVT dependencies on PA_UTILS

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

308: l_priority_code := p_priority_code;
309: end if;
310:
311: If (p_project_value is not null and p_project_value < 0) then
312: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
313: p_msg_name =>'PA_BU_NEED_POS_NUM');
314: RAISE FND_API.G_EXC_ERROR;
315: end if;
316:

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

369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
370: THEN
371: /* IF NOT pa_project_pvt.check_valid_message(l_err_stage)
372: THEN
373: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
374: p_msg_name => 'PA_PROJ_COPY_PROJECT_FAILED');
375:
376: x_msg_data := 'PA_PROJ_COPY_PROJECT_FAILED';
377: ELSE*/

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

377: ELSE*/
378: /* Bug2450468 Begin - Commenting the following code and adding the code*/
379: /* IF l_err_stage IS NOT NULL
380: THEN
381: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
382: p_msg_name => l_err_stage);
383: END IF;
384: */
385:

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

387: OPEN l_get_prj_class_code;
388: FETCH l_get_prj_class_code INTO l_project_type_class_code;
389: CLOSE l_get_prj_class_code;
390:
391: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
392: p_msg_name => 'PA_INVALID_PT_CLASS_ORG',
393: p_token1 => 'PT_CLASS',
394: p_value1 => l_project_type_class_code);
395: ELSE

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

393: p_token1 => 'PT_CLASS',
394: p_value1 => l_project_type_class_code);
395: ELSE
396: IF l_err_stage IS NOT NULL THEN
397: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
398: p_msg_name => l_err_stage);
399: END IF;
400:
401: END IF; -- l_err_stage = 'PA_INVALID_PT_CLASS_ORG'

Line 415: PA_UTILS.ADD_MESSAGE

411: ELSIF l_err_code < 0
412: THEN
413: /* IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
414: THEN
415: PA_UTILS.ADD_MESSAGE
416: (p_app_short_name => 'PA',
417: p_msg_name => 'PA_PROJ_COPY_PROJECT_FAILED');
418: x_msg_data := 'PA_PROJ_COPY_PROJECT_FAILED';
419: END IF;*/

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

418: x_msg_data := 'PA_PROJ_COPY_PROJECT_FAILED';
419: END IF;*/
420: IF l_err_stage IS NOT NULL
421: THEN
422: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
423: p_msg_name => l_err_stage);
424: END IF;
425: x_msg_data := l_err_stage;
426: x_return_status := 'E';

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

765: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
766: THEN
767: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
768: THEN
769: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
770: p_msg_name =>
771: 'PA_GET_CUSTOMER_INFO_FAILED');
772: x_msg_data := 'PA_GET_CUSTOMER_INFO_FAILED';
773: ELSE

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

770: p_msg_name =>
771: 'PA_GET_CUSTOMER_INFO_FAILED');
772: x_msg_data := 'PA_GET_CUSTOMER_INFO_FAILED';
773: ELSE
774: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
775: p_msg_name => l_err_stage);
776: x_msg_data := l_err_stage;
777: END IF;
778: END IF;

Line 786: PA_UTILS.ADD_MESSAGE

782: ELSIF l_err_code < 0
783: THEN
784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
785: THEN
786: PA_UTILS.ADD_MESSAGE
787: (p_app_short_name => 'PA',
788: p_msg_name => 'PA_PROJ_GET_CUST_INFO_FAILED');
789: x_msg_data := 'PA_PROJ_GET_CUST_INFO_FAILED';
790: END IF;

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

883: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
884: THEN
885: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
886: THEN
887: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
888: p_msg_name => 'PA_PROJ_CR_CONTACTS_FAILED');
889: x_msg_data := 'PA_PROJ_CR_CONTACTS_FAILED';
890: ELSE
891: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

887: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
888: p_msg_name => 'PA_PROJ_CR_CONTACTS_FAILED');
889: x_msg_data := 'PA_PROJ_CR_CONTACTS_FAILED';
890: ELSE
891: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
892: p_msg_name => l_err_stage);
893: x_msg_data := l_err_stage ;
894: END IF;
895:

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

898: x_return_status := FND_API.G_RET_STS_ERROR;
899:
900: ELSIF l_err_code < 0
901: THEN
902: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
903: p_msg_name => 'PA_PROJ_CR_CONTACTS_FAILED');
904: x_msg_data := 'PA_PROJ_CR_CONTACTS_FAILED';
905: x_return_status := 'E';
906: END IF;

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

1239: WHERE project_id = p_project_id
1240: AND record_version_number = p_record_version_number
1241: FOR UPDATE OF record_version_number NOWAIT;
1242: EXCEPTION WHEN TIMEOUT_ON_RESOURCE THEN
1243: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1244: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1245: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1246: x_return_status := 'E' ;
1247: WHEN NO_DATA_FOUND THEN

Line 1249: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

1245: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1246: x_return_status := 'E' ;
1247: WHEN NO_DATA_FOUND THEN
1248: if p_calling_module = 'FORM' then
1249: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1250: p_msg_name => 'FORM_RECORD_CHANGED');
1251: x_msg_data := 'FORM_RECORD_CHANGED';
1252: else
1253: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

1249: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1250: p_msg_name => 'FORM_RECORD_CHANGED');
1251: x_msg_data := 'FORM_RECORD_CHANGED';
1252: else
1253: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1254: p_msg_name => 'PA_XC_RECORD_CHANGED');
1255: x_msg_data := 'PA_XC_RECORD_CHANGED';
1256: end if;
1257: x_return_status := 'E' ;

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

1256: end if;
1257: x_return_status := 'E' ;
1258: WHEN OTHERS THEN
1259: IF SQLCODE = -54 THEN
1260: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1261: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1262: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1263: x_return_status := 'E' ;
1264: ELSE

Line 1276: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

1272: WHERE project_id = p_project_id
1273: AND record_version_number = p_record_version_number;
1274: EXCEPTION WHEN NO_DATA_FOUND THEN
1275: if p_calling_module = 'FORM' then
1276: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1277: p_msg_name => 'FORM_RECORD_CHANGED');
1278: x_msg_data := 'FORM_RECORD_CHANGED';
1279: else
1280: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

1276: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1277: p_msg_name => 'FORM_RECORD_CHANGED');
1278: x_msg_data := 'FORM_RECORD_CHANGED';
1279: else
1280: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1281: p_msg_name => 'PA_XC_RECORD_CHANGED');
1282: x_msg_data := 'PA_XC_RECORD_CHANGED';
1283: end if;
1284: x_return_status := 'E' ;

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

1283: end if;
1284: x_return_status := 'E' ;
1285: WHEN OTHERS THEN
1286: IF SQLCODE = -54 THEN
1287: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1288: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1289: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1290: x_return_status := 'E' ;
1291: END IF;

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

1950: WHERE project_id = p_project_id
1951: AND record_version_number = p_record_version_number
1952: FOR UPDATE OF record_version_number NOWAIT;
1953: EXCEPTION WHEN TIMEOUT_ON_RESOURCE THEN
1954: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1955: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1956: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1957: x_return_status := 'E' ;
1958: WHEN NO_DATA_FOUND THEN

Line 1960: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

1956: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1957: x_return_status := 'E' ;
1958: WHEN NO_DATA_FOUND THEN
1959: if p_calling_module = 'FORM' then
1960: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1961: p_msg_name => 'FORM_RECORD_CHANGED');
1962: x_msg_data := 'FORM_RECORD_CHANGED';
1963: else
1964: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

1960: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1961: p_msg_name => 'FORM_RECORD_CHANGED');
1962: x_msg_data := 'FORM_RECORD_CHANGED';
1963: else
1964: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1965: p_msg_name => 'PA_XC_RECORD_CHANGED');
1966: x_msg_data := 'PA_XC_RECORD_CHANGED';
1967: end if;
1968: x_return_status := 'E' ;

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

1967: end if;
1968: x_return_status := 'E' ;
1969: WHEN OTHERS THEN
1970: IF SQLCODE = -54 THEN
1971: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1972: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1973: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1974: x_return_status := 'E' ;
1975: ELSE

Line 1989: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

1985: AND record_version_number = p_record_version_number;
1986: EXCEPTION
1987: WHEN NO_DATA_FOUND THEN
1988: if p_calling_module = 'FORM' then
1989: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1990: p_msg_name => 'FORM_RECORD_CHANGED');
1991: x_msg_data := 'FORM_RECORD_CHANGED';
1992: else
1993: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

1989: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1990: p_msg_name => 'FORM_RECORD_CHANGED');
1991: x_msg_data := 'FORM_RECORD_CHANGED';
1992: else
1993: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1994: p_msg_name => 'PA_XC_RECORD_CHANGED');
1995: x_msg_data := 'PA_XC_RECORD_CHANGED';
1996: end if;
1997: x_return_status := 'E' ;

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

1996: end if;
1997: x_return_status := 'E' ;
1998: WHEN OTHERS THEN
1999: IF SQLCODE = -54 THEN
2000: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2001: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2002: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2003: x_return_status := 'E' ;
2004: Else

Line 2255: Pa_Utils.ADD_MESSAGE

2251: IF (l_proj_sys_program_flag='Y' and nvl(l_sys_program_flag,'N')='N' ) then
2252: l_flag := PA_RELATIONSHIP_UTILS.DISABLE_SYS_PROG_OK(p_project_id);
2253:
2254: If l_flag='N' Then
2255: Pa_Utils.ADD_MESSAGE
2256: ( p_app_short_name => 'PA',
2257: p_msg_name =>'PA_PS_DIS_SYS_PROG_ERR');
2258: RAISE FND_API.G_EXC_ERROR;
2259: END IF;

Line 2266: Pa_Utils.ADD_MESSAGE

2262: IF (l_proj_allow_program_rollup='Y' and nvl(l_allow_multi_program_rollup,'N')='N' ) then
2263: l_flag := PA_RELATIONSHIP_UTILS.DISABLE_MULTI_PROG_OK(p_project_id);
2264:
2265: IF l_flag ='N' Then
2266: Pa_Utils.ADD_MESSAGE
2267: ( p_app_short_name => 'PA',
2268: p_msg_name =>'PA_PS_DIS_MULTI_PROG_ERR');
2269: RAISE FND_API.G_EXC_ERROR;
2270: END IF;

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

2404: WHERE project_id = p_project_id
2405: AND record_version_number = p_record_version_number
2406: FOR UPDATE OF record_version_number NOWAIT;
2407: EXCEPTION WHEN TIMEOUT_ON_RESOURCE THEN
2408: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2409: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2410: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2411: x_return_status := 'E' ;
2412: WHEN NO_DATA_FOUND THEN

Line 2414: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

2410: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2411: x_return_status := 'E' ;
2412: WHEN NO_DATA_FOUND THEN
2413: if p_calling_module = 'FORM' then
2414: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
2415: p_msg_name => 'FORM_RECORD_CHANGED');
2416: x_msg_data := 'FORM_RECORD_CHANGED';
2417: else
2418: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

2414: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
2415: p_msg_name => 'FORM_RECORD_CHANGED');
2416: x_msg_data := 'FORM_RECORD_CHANGED';
2417: else
2418: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2419: p_msg_name => 'PA_XC_RECORD_CHANGED');
2420: x_msg_data := 'PA_XC_RECORD_CHANGED';
2421: end if;
2422: x_return_status := 'E' ;

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

2421: end if;
2422: x_return_status := 'E' ;
2423: WHEN OTHERS THEN
2424: IF SQLCODE = -54 THEN
2425: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2426: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2427: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2428: x_return_status := 'E' ;
2429: ELSE

Line 2442: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

2438: AND record_version_number = p_record_version_number;
2439: EXCEPTION
2440: WHEN NO_DATA_FOUND THEN
2441: if p_calling_module = 'FORM' then
2442: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
2443: p_msg_name => 'FORM_RECORD_CHANGED');
2444: x_msg_data := 'FORM_RECORD_CHANGED';
2445: else
2446: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

2442: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
2443: p_msg_name => 'FORM_RECORD_CHANGED');
2444: x_msg_data := 'FORM_RECORD_CHANGED';
2445: else
2446: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2447: p_msg_name => 'PA_XC_RECORD_CHANGED');
2448: x_msg_data := 'PA_XC_RECORD_CHANGED';
2449: end if;
2450: x_return_status := 'E' ;

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

2449: end if;
2450: x_return_status := 'E' ;
2451: WHEN OTHERS THEN
2452: IF SQLCODE = -54 THEN
2453: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2454: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
2455: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
2456: x_return_status := 'E' ;
2457: ELSE

Line 2839: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

2835:
2836: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2837:
2838: /*
2839: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
2840: p_msg_name => 'FLEX-MISSING SEGMENT VALUE',
2841: p_token1 => l_segment_name,
2842: p_token2 => p_flexfield_name); */
2843:

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

3054: AND record_version_number = p_record_version_number
3055: FOR UPDATE OF record_version_number NOWAIT;
3056: EXCEPTION
3057: when TIMEOUT_ON_RESOURCE then
3058: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3059: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
3060: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
3061: when NO_DATA_FOUND then
3062: if p_calling_module = 'FORM' then

Line 3063: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

3059: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
3060: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
3061: when NO_DATA_FOUND then
3062: if p_calling_module = 'FORM' then
3063: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
3064: p_msg_name => 'FORM_RECORD_CHANGED');
3065: l_msg_data := 'FORM_RECORD_CHANGED';
3066: else
3067: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

3063: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
3064: p_msg_name => 'FORM_RECORD_CHANGED');
3065: l_msg_data := 'FORM_RECORD_CHANGED';
3066: else
3067: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3068: p_msg_name => 'PA_XC_RECORD_CHANGED');
3069: l_msg_data := 'PA_XC_RECORD_CHANGED';
3070: end if;
3071: when OTHERS then

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

3069: l_msg_data := 'PA_XC_RECORD_CHANGED';
3070: end if;
3071: when OTHERS then
3072: if SQLCODE = -54 then
3073: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3074: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
3075: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
3076: else
3077: raise;

Line 3089: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

3085: AND record_version_number = p_record_version_number;
3086: EXCEPTION
3087: when NO_DATA_FOUND then
3088: if p_calling_module = 'FORM' then
3089: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
3090: p_msg_name => 'FORM_RECORD_CHANGED');
3091: l_msg_data := 'FORM_RECORD_CHANGED';
3092: else
3093: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

3089: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
3090: p_msg_name => 'FORM_RECORD_CHANGED');
3091: l_msg_data := 'FORM_RECORD_CHANGED';
3092: else
3093: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3094: p_msg_name => 'PA_XC_RECORD_CHANGED');
3095: l_msg_data := 'PA_XC_RECORD_CHANGED';
3096: end if;
3097: when OTHERS then

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

3422: l_error_msg_code);
3423:
3424: IF l_return_status = 'E'
3425: THEN
3426: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3427: p_msg_name =>l_error_msg_code);
3428: END IF;
3429: END IF;
3430:

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

3462: l_error_msg_code);
3463:
3464: IF l_return_status = 'E'
3465: THEN
3466: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3467: p_msg_name =>l_error_msg_code);
3468: END IF;
3469:
3470: */

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

3474: l_return_status,
3475: l_error_msg_code);
3476: if (p_code_percentage is not NULL) AND (p_code_percentage <> FND_API.G_MISS_NUM) then
3477: if l_return_status = 'E' then
3478: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3479: p_msg_name =>l_error_msg_code);
3480: else
3481: if (p_code_percentage < 0) OR (p_code_percentage > 100) then
3482: l_return_status := 'E';

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

3479: p_msg_name =>l_error_msg_code);
3480: else
3481: if (p_code_percentage < 0) OR (p_code_percentage > 100) then
3482: l_return_status := 'E';
3483: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3484: p_msg_name => 'PA_CODE_PERCENT_INVALID');
3485: /* Commented for bug 3161704
3486: else
3487: if p_calling_module = 'FORMS' then

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

3494: l_return_status,
3495: l_error_msg_code);
3496:
3497: if l_return_status = 'E' then
3498: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3499: p_msg_name =>l_error_msg_code);
3500: end if;
3501: end if;
3502: */

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

3522: l_error_msg_code);
3523:
3524: IF l_return_status = 'E'
3525: THEN
3526: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3527: p_msg_name =>l_error_msg_code);
3528: END IF;
3529:
3530: --dbms_output.put_line('CHECK_DUPLICATE_CLASS_CATG '||l_error_msg_code||'Status :'||l_return_status);

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

3540: l_return_status,
3541: l_error_msg_code);
3542: IF l_return_status = 'E'
3543: THEN
3544: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3545: p_msg_name =>l_error_msg_code);
3546: END IF;
3547: --dbms_output.put_line('CHECK_DUPLICATE_CLASS_CATG '||l_error_msg_code||'Status :'||l_return_status);
3548:

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

3573: l_error_msg_code);
3574:
3575: IF l_return_status = 'E'
3576: THEN
3577: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3578: p_msg_name =>l_error_msg_code);
3579: END IF;
3580:
3581: PA_PROJECTS_MAINT_UTILS.CHECK_PERCENTAGE_ALLOWED(

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

3583: l_return_status,
3584: l_error_msg_code);
3585: if (p_code_percentage is not NULL) AND (p_code_percentage <> FND_API.G_MISS_NUM) then
3586: if l_return_status = 'E' then
3587: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3588: p_msg_name =>l_error_msg_code);
3589: else
3590: if (p_code_percentage < 0) OR (p_code_percentage > 100) then
3591: l_return_status := 'E';

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

3588: p_msg_name =>l_error_msg_code);
3589: else
3590: if (p_code_percentage < 0) OR (p_code_percentage > 100) then
3591: l_return_status := 'E';
3592: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3593: p_msg_name => 'PA_CODE_PERCENT_INVALID');
3594: /* Commented for bug 3161704
3595: else
3596: if p_calling_module = 'FORMS' then

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

3603: l_return_status,
3604: l_error_msg_code);
3605:
3606: if l_return_status = 'E' then
3607: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3608: p_msg_name =>l_error_msg_code);
3609: end if;
3610: end if;
3611: */

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

3648: l_error_msg_code);
3649:
3650: IF l_return_status = 'E'
3651: THEN
3652: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3653: p_msg_name =>l_error_msg_code);
3654: END IF;
3655: END IF;
3656:

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

3667: l_return_status,
3668: l_error_msg_code);
3669: IF l_return_status = 'E'
3670: THEN
3671: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3672: p_msg_name =>l_error_msg_code);
3673: END IF;
3674: --dbms_output.put_line('CHECK_DUPLICATE_CLASS_CATG '||l_error_msg_code||'Status :'||l_return_status);
3675:

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

3686: l_return_status,
3687: l_error_msg_code);
3688: IF l_return_status = 'E'
3689: THEN
3690: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3691: p_msg_name => l_error_msg_code);
3692: END IF;
3693:
3694: END IF;

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

3802: and class_code = p_class_code
3803: and record_version_number = p_record_version_number
3804: FOR UPDATE OF class_code NOWAIT;
3805: EXCEPTION WHEN TIMEOUT_ON_RESOURCE THEN
3806: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3807: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
3808: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
3809: x_return_status := 'E' ;
3810: WHEN NO_DATA_FOUND THEN

Line 3812: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

3808: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
3809: x_return_status := 'E' ;
3810: WHEN NO_DATA_FOUND THEN
3811: if p_calling_module = 'FORM' then
3812: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
3813: p_msg_name => 'FORM_RECORD_CHANGED');
3814: x_msg_data := 'FORM_RECORD_CHANGED';
3815: else
3816: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

3812: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
3813: p_msg_name => 'FORM_RECORD_CHANGED');
3814: x_msg_data := 'FORM_RECORD_CHANGED';
3815: else
3816: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3817: p_msg_name => 'PA_XC_RECORD_CHANGED');
3818: x_msg_data := 'PA_XC_RECORD_CHANGED';
3819: end if;
3820: x_return_status := 'E' ;

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

3819: end if;
3820: x_return_status := 'E' ;
3821: WHEN OTHERS THEN
3822: IF SQLCODE = -54 THEN
3823: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3824: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
3825: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
3826: x_return_status := 'E' ;
3827: ELSE

Line 3843: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

3839: and record_version_number = p_record_version_number;
3840: EXCEPTION
3841: WHEN NO_DATA_FOUND THEN
3842: if p_calling_module = 'FORM' then
3843: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
3844: p_msg_name => 'FORM_RECORD_CHANGED');
3845: x_msg_data := 'FORM_RECORD_CHANGED';
3846: else
3847: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

3843: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
3844: p_msg_name => 'FORM_RECORD_CHANGED');
3845: x_msg_data := 'FORM_RECORD_CHANGED';
3846: else
3847: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3848: p_msg_name => 'PA_XC_RECORD_CHANGED');
3849: x_msg_data := 'PA_XC_RECORD_CHANGED';
3850: end if;
3851: x_return_status := 'E' ;

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

3850: end if;
3851: x_return_status := 'E' ;
3852: WHEN OTHERS THEN
3853: IF SQLCODE = -54 THEN
3854: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3855: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
3856: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
3857: x_return_status := 'E' ;
3858: ELSE

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

4324: ,p_error_stack => l_err_stack
4325: ,p_error_stage => l_err_stage );
4326:
4327: IF l_err_code <> 0 THEN
4328: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4329: p_msg_name => l_err_stage);
4330: END IF;
4331: end if;
4332: -- anlee end of changes

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

4352: THEN
4353:
4354: -- anlee project actions changes
4355: IF l_update_proj_num_allowed = 'N' THEN
4356: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4357: p_msg_name => 'PA_PM_PROJ_NUM_ERR');
4358: ELSE
4359:
4360: pa_project_utils.change_proj_num_ok

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

4366: IF l_err_code <> 0
4367: THEN
4368: IF NOT pa_project_pvt.check_valid_message (l_err_stage)
4369: THEN
4370: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4371: p_msg_name => 'PA_CANT_CHANGE_PROJ_NUM');
4372: ELSE
4373: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4374: p_msg_name => l_err_stage);

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

4369: THEN
4370: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4371: p_msg_name => 'PA_CANT_CHANGE_PROJ_NUM');
4372: ELSE
4373: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4374: p_msg_name => l_err_stage);
4375: END IF; -- pa_project_pvt.check_valid_message
4376:
4377: -- Check for project number being numeric if project number type is

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

4385: EXCEPTION
4386: WHEN VALUE_ERROR THEN
4387: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4388: THEN
4389: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4390: p_msg_name => 'PA_PR_NUMERIC_NUM_REQ');
4391: END IF; -- FND_MSG_PUB.check_msg_level
4392: END ;
4393:

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

4398: CLOSE l_project_number_unique_csr; -- Added for Bug#3876261
4399:
4400: if (pa_project_utils.check_unique_project_number (p_project_number, NULL) = 0)
4401: then
4402: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4403: p_msg_name => 'PA_PR_EPR_PROJ_NUM_NOT_UNIQUE');
4404: END IF;
4405:
4406: END IF; -- l_update_proj_num_allowed

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

4410:
4411: ELSIF PA_PROJECT_UTILS.GetProjNumMode = 'AUTOMATIC' THEN
4412: -- Cannot modify project number if numbering mode is AUTOMATIC
4413: IF p_project_number <> l_project_old_rec.segment1 THEN
4414: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4415: p_msg_name => 'PA_CANT_CHANGE_PROJ_NUM');
4416: END IF;
4417:
4418: END IF; -- PA_PROJECT_UTILS.GetProjNumMode

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

4432: THEN
4433:
4434: -- anlee project actions changes
4435: IF l_update_proj_name_allowed = 'N' THEN
4436: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4437: p_msg_name => 'PA_PM_PROJ_NAME_ERR');
4438: ELSE
4439:
4440: if (pa_project_utils.check_unique_project_name (p_project_name, NULL) = 0)

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

4438: ELSE
4439:
4440: if (pa_project_utils.check_unique_project_name (p_project_name, NULL) = 0)
4441: then
4442: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4443: p_msg_name => 'PA_PR_EPR_PROJ_NAME_NOT_UNIQUE');
4444: END IF; -- l_project_name_unique_csr
4445: END IF; -- l_update_proj_name_allowed
4446:

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

4462: THEN
4463:
4464: if (pa_project_utils.check_unique_long_name (p_long_name, NULL) = 0)
4465: then
4466: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4467: p_msg_name => 'PA_PR_EPR_LONG_NAME_NOT_UNIQUE');
4468: END IF;
4469:
4470: END IF;

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

4477: -- anlee project actions changes
4478: IF p_description <> l_project_old_rec.description
4479: THEN
4480: if l_update_proj_desc_allowed = 'N' then
4481: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4482: p_msg_name => 'PA_PM_PROJ_DESC_ERR');
4483: end if;
4484: ELSIF (p_description is null and l_project_old_rec.description is not null) OR
4485: (p_description is not null and l_project_old_rec.description is null) THEN

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

4483: end if;
4484: ELSIF (p_description is null and l_project_old_rec.description is not null) OR
4485: (p_description is not null and l_project_old_rec.description is null) THEN
4486: if l_update_proj_desc_allowed = 'N' then
4487: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4488: p_msg_name => 'PA_PM_PROJ_DESC_ERR');
4489: end if;
4490: END IF;
4491: -- anlee end of changes

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

4514: l_err_code,
4515: l_err_stage,
4516: l_err_stack);
4517: if l_err_code <> 0 Then
4518: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4519: p_msg_name => 'PA_PR_CANT_CHG_PROJ_TYPE');
4520: else
4521: -- Check whether funding exists (if it exists cannot change from contract
4522: -- to non-contract project)

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

4532: if (l_project_type_class_code <> 'CONTRACT')
4533: AND (nvl(l_old_project_type_class_code, l_project_type_class_code) <> l_project_type_class_code) then
4534:
4535: if (pa_project_utils.check_proj_funding (p_project_id)) <> 0 Then
4536: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4537: p_msg_name => 'PA_PR_CANT_CHG_DIR_TO_INDIR');
4538: l_project_type_error := TRUE;
4539: end if;
4540: end if;

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

4548: IF l_project_type_rec.cc_prvdr_flag = 'Y'
4549: THEN
4550: l_status_code := pa_project_utils.check_ic_proj_type_allowed(p_project_id,'Y');
4551: IF nvl(l_status_code ,0) <> 0 THEN
4552: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4553: p_msg_name => 'PA_IC_PT_NOT_ALLOWED');
4554: l_project_type_error := TRUE;
4555: ELSE
4556: IF l_project_old_rec.multi_currency_billing_flag = 'Y' THEN

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

4553: p_msg_name => 'PA_IC_PT_NOT_ALLOWED');
4554: l_project_type_error := TRUE;
4555: ELSE
4556: IF l_project_old_rec.multi_currency_billing_flag = 'Y' THEN
4557: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4558: p_msg_name => 'PA_PR_CANT_CHG_IC_BIL_PT');
4559: l_project_type_error := TRUE;
4560:
4561: END IF ;

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

4569: p_project_type <> l_project_old_rec.project_type AND
4570: l_project_type_rec.cc_prvdr_flag = 'Y' AND
4571: l_project_old_rec.multi_currency_billing_flag = 'Y'
4572: THEN
4573: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4574: p_msg_name => 'PA_PR_CANT_CHG_IC_BIL_PT');
4575: l_project_type_error := TRUE;
4576:
4577: END IF;

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

4897: THEN
4898:
4899: -- anlee project actions changes
4900: IF l_update_proj_org_allowed = 'N' THEN
4901: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4902: p_msg_name => 'PA_PM_PROJ_ORG_ERR');
4903: ELSE
4904:
4905: IF pa_project_pvt.check_valid_org

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

4903: ELSE
4904:
4905: IF pa_project_pvt.check_valid_org
4906: (p_carrying_out_organization_id) = 'N' THEN
4907: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4908: p_msg_name => 'PA_INVALID_ORG');
4909: END IF;
4910:
4911: -- Getting X_functional_security_flag through fnd_function_test function

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

4968: and lps.lookup_type(+) = 'PROJECT TYPE CLASS'
4969: and lps.lookup_code(+) = pt.project_type_class_code
4970: and pt.org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added the and condition for Bug#3807805
4971:
4972: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4973: p_msg_name => 'PA_INVALID_PT_CLASS_ORG',
4974: p_token1 => 'PT_CLASS',
4975: p_value1 => t_project_type_class_code);
4976: else

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

4973: p_msg_name => 'PA_INVALID_PT_CLASS_ORG',
4974: p_token1 => 'PT_CLASS',
4975: p_value1 => t_project_type_class_code);
4976: else
4977: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4978: p_msg_name => l_err_stage);
4979:
4980: end if; -- l_err_stage = 'PA_INVALID_PT_CLASS_ORG'
4981:

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

4979:
4980: end if; -- l_err_stage = 'PA_INVALID_PT_CLASS_ORG'
4981:
4982: ELSE
4983: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4984: p_msg_name => l_err_stage);
4985: end if; -- NOT pa_project_pvt.check_valid_message
4986:
4987: END IF; -- (l_err_code <> 0) AND (l_err_code <> 15)

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

4999: x_return_status => l_return_status,
5000: x_error_message_code => l_error_msg_code);
5001:
5002: if l_return_status <> 'S' Then
5003: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5004: p_msg_name => l_error_msg_code);
5005: End If;
5006:
5007: -- Added for bug 2680595

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

5013: x_location_id => x_location_id,
5014: x_error_message_code => l_error_msg_code);
5015:
5016: if l_return_status <> 'S' Then
5017: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5018: p_msg_name => l_error_msg_code);
5019: End If;
5020:
5021: /*

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

5052: x_msg_count => l_msg_count,
5053: x_msg_data => l_error_msg_code);
5054:
5055: if l_return_status <> 'S' Then
5056: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5057: p_msg_name => l_error_msg_code);
5058: End If; --l_return_status <> 'S'
5059: -- anlee end of changes
5060:

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

5069: -- target start date and target finish date validations
5070: IF(p_target_start_date IS NOT NULL AND p_target_finish_date IS NOT NULL) AND
5071: (p_target_start_date > p_target_finish_date) THEN
5072:
5073: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5074: p_msg_name => 'PA_ENTERED_DATES_INVLD');
5075: END IF;
5076: -- End of changes
5077:

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

5104: ,p_update_end_date_flag => l_update_end_date_flag
5105: ,p_return_status => l_return_status );
5106:
5107: IF l_return_status <> 'S' THEN
5108: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5109: p_msg_name => 'PA_SU_INVALID_DATES');
5110: else
5111: -- Do validation if start date has changed
5112: if (nvl(l_project_old_rec.start_date,FND_API.G_MISS_DATE) <>

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

5113: nvl(l_project_start_date,FND_API.G_MISS_DATE)) then --Bug 6408115
5114:
5115: -- anlee project actions changes
5116: IF l_update_proj_dates_allowed = 'N' THEN
5117: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5118: p_msg_name => 'PA_PM_PROJ_DATES_ERR');
5119: ELSE
5120: -- Check that project start date is less than min (task start dates)
5121: OPEN get_min_task_start_date;

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

5121: OPEN get_min_task_start_date;
5122: FETCH get_min_task_start_date INTO l_min_task_start_date;
5123: if (get_min_task_start_date%FOUND) AND (l_project_start_date is not null) then
5124: if l_min_task_start_date < l_project_start_date then
5125: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5126: p_msg_name => 'PA_PR_INVALID_START_DATE');
5127: l_start_date_error := TRUE;
5128: end if;
5129: end if;

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

5131: -- Do not allow start date modification if there exists project level budget at completion
5132: if p_calling_module <> 'SETUP_PAGE' then -- bug 7204572 added an IF condition
5133: if l_start_date_error = FALSE then
5134: if pa_budget_utils2.check_budget_at_compl_exists(p_project_id,null) = 'Y' then
5135: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5136: p_msg_name => 'PA_PRJ_LVL_BUD_ERR');
5137: l_start_date_error := TRUE;
5138: end if;
5139: end if;

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

5145: if (nvl(l_project_old_rec.completion_date,FND_API.G_MISS_DATE) <>
5146: nvl(l_project_completion_date,FND_API.G_MISS_DATE)) then --Bug 6408115
5147: -- anlee project actions changes
5148: IF l_update_proj_dates_allowed = 'N' THEN
5149: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5150: p_msg_name => 'PA_PM_PROJ_DATES_ERR');
5151: ELSE
5152:
5153: -- Check that project completion date is greater than max (task completion dates)

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

5154: OPEN get_max_task_completion_date;
5155: FETCH get_max_task_completion_date INTO l_max_task_completion_date;
5156: if (get_max_task_completion_date%FOUND) AND (l_project_completion_date is not null) then
5157: if l_max_task_completion_date > l_project_completion_date then
5158: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5159: p_msg_name => 'PA_PR_INVALID_COMPLETION_DATE');
5160: l_completion_date_error := TRUE;
5161: end if;
5162: end if;

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

5165: -- Do not allow completion date modification if there exists project level budget at completion
5166: if p_calling_module <> 'SETUP_PAGE' then -- bug 7204572 added an IF condition
5167: if l_completion_date_error = FALSE then
5168: if pa_budget_utils2.check_budget_at_compl_exists(p_project_id,null) = 'Y' then
5169: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5170: p_msg_name => 'PA_PRJ_LVL_BUD_ERR');
5171:
5172: end if;
5173: end if;

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

5190: IF p_public_sector_flag <> l_project_old_rec.public_sector_flag
5191: THEN
5192: IF p_public_sector_flag NOT IN ('Y','N')
5193: THEN
5194: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5195: p_msg_name => 'PA_PUBLIC_SECTOR_INVALID');
5196: END IF;
5197: END IF;
5198: END IF;

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

5210: l_project_old_rec.project_status_code THEN
5211:
5212: -- anlee project actions changes
5213: IF l_update_proj_status_allowed = 'N' THEN
5214: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5215: p_msg_name => 'PA_PM_PROJ_STATUS_ERR');
5216: ELSE
5217: IF pa_project_pvt.check_valid_project_status
5218: (p_project_status => p_project_status_code ) = 'N'

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

5216: ELSE
5217: IF pa_project_pvt.check_valid_project_status
5218: (p_project_status => p_project_status_code ) = 'N'
5219: THEN
5220: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5221: p_msg_name => 'PA_PROJECT_STATUS_INVALID');
5222: END IF;
5223: -- special case for update to and from 'CLOSED'
5224: IF Pa_project_stus_utils.is_project_status_closed

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

5256: p_project_status_code);
5257:
5258: IF (x_status_changeable = 'N')
5259: THEN
5260: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5261: p_msg_name => 'PA_STATUS_CANT_CHANGE');
5262: END IF;
5263: END IF;
5264: END IF;

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

5319: , l_err_stage
5320: , l_err_code );
5321:
5322: If l_err_code <> 0 Then
5323: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5324: p_msg_name => l_err_stage);
5325: end if;
5326: end if;
5327: else

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

5324: p_msg_name => l_err_stage);
5325: end if;
5326: end if;
5327: else
5328: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5329: p_msg_name => 'PA_STATUS_CANT_CHANGE');
5330: end if;
5331:
5332: END IF;

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

5438: --dbms_output.put_line('AFTER PA_PROJECTS_MAINT_UTILS.CHECK_BILL_JOB_GRP_REQ ');
5439:
5440: IF l_return_status = 'E'
5441: THEN
5442: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5443: p_msg_name =>l_error_msg_code);
5444: END IF;
5445:
5446: END IF;

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

5458: pa_debug.debug('Validate_project_info PVT: probability member id validation');
5459: END IF;
5460:
5461: If (p_project_value is not null and p_project_value < 0) then
5462: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5463: p_msg_name =>'PA_BU_NEED_POS_NUM');
5464: end if;
5465:
5466: IF nvl(p_probability_member_id, -999) <>

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

5472: l_return_status,
5473: l_error_msg_code);
5474: IF l_return_status = 'E'
5475: THEN
5476: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5477: p_msg_name =>l_error_msg_code);
5478: END IF;
5479: END IF;
5480: open prob_per (p_probability_member_id);

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

5480: open prob_per (p_probability_member_id);
5481: fetch prob_per into l_probability_member_id;
5482: close prob_per;
5483: IF l_probability_member_id is not null and p_expected_approval_date is null Then
5484: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5485: p_msg_name =>'PA_EXP_APP_DATE_REQUIRED');
5486: End if;
5487:
5488: IF l_probability_member_id is null and p_expected_approval_date is not null Then

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

5485: p_msg_name =>'PA_EXP_APP_DATE_REQUIRED');
5486: End if;
5487:
5488: IF l_probability_member_id is null and p_expected_approval_date is not null Then
5489: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5490: p_msg_name =>'PA_PROBA_PERCENT_REQUIRED');
5491: End if;
5492:
5493: end if; -- p_calling_module like ('PIPELINE')

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

5598: WHERE project_id = p_project_id
5599: AND record_version_number = p_record_version_number
5600: FOR UPDATE OF record_version_number NOWAIT;
5601: EXCEPTION WHEN TIMEOUT_ON_RESOURCE THEN
5602: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5603: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
5604: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
5605: x_return_status := FND_API.G_RET_STS_ERROR ;
5606: WHEN NO_DATA_FOUND THEN

Line 5608: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

5604: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
5605: x_return_status := FND_API.G_RET_STS_ERROR ;
5606: WHEN NO_DATA_FOUND THEN
5607: if p_calling_module = 'FORM' then
5608: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
5609: p_msg_name => 'FORM_RECORD_CHANGED');
5610: x_msg_data := 'FORM_RECORD_CHANGED';
5611: else
5612: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

5608: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
5609: p_msg_name => 'FORM_RECORD_CHANGED');
5610: x_msg_data := 'FORM_RECORD_CHANGED';
5611: else
5612: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5613: p_msg_name => 'PA_XC_RECORD_CHANGED');
5614: x_msg_data := 'PA_XC_RECORD_CHANGED';
5615: end if;
5616: x_return_status := FND_API.G_RET_STS_ERROR ;

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

5615: end if;
5616: x_return_status := FND_API.G_RET_STS_ERROR ;
5617: WHEN OTHERS THEN
5618: IF SQLCODE = -54 THEN
5619: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5620: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
5621: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
5622: x_return_status := FND_API.G_RET_STS_ERROR ;
5623: ELSE

Line 5636: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',

5632: AND record_version_number = p_record_version_number;
5633: EXCEPTION
5634: WHEN NO_DATA_FOUND THEN
5635: if p_calling_module = 'FORM' then
5636: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
5637: p_msg_name => 'FORM_RECORD_CHANGED');
5638: x_msg_data := 'FORM_RECORD_CHANGED';
5639: else
5640: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

5636: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
5637: p_msg_name => 'FORM_RECORD_CHANGED');
5638: x_msg_data := 'FORM_RECORD_CHANGED';
5639: else
5640: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5641: p_msg_name => 'PA_XC_RECORD_CHANGED');
5642: x_msg_data := 'PA_XC_RECORD_CHANGED';
5643: end if;
5644: x_return_status := FND_API.G_RET_STS_ERROR ;

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

5643: end if;
5644: x_return_status := FND_API.G_RET_STS_ERROR ;
5645: WHEN OTHERS THEN
5646: IF SQLCODE = -54 THEN
5647: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5648: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
5649: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
5650: x_return_status := FND_API.G_RET_STS_ERROR ;
5651: ELSE