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 4899: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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