DBA Data[Home] [Help]

APPS.PA_PROJ_TEMPLATE_SETUP_PUB dependencies on PA_UTILS

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

119: END IF;
120: -- added for Bug fix: 4537866
121:
122: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
123: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
124: p_msg_name => l_error_msg_code);
125: END IF;
126:
127: END IF; --End Name-Id Conversion

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

341: l_organization_id := l_new_organization_id;
342: END IF;
343: -- added for Bug fix: 4537865
344: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
345: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
346: p_msg_name => l_error_msg_code);
347: END IF;
348:
349: END IF; --End Name-Id Conversion

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

373: AND record_version_number = p_record_version_number
374: FOR UPDATE OF record_version_number NOWAIT;
375: EXCEPTION
376: WHEN TIMEOUT_ON_RESOURCE THEN
377: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
378: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
379: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
380: x_return_status := 'E' ;
381: WHEN NO_DATA_FOUND THEN

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

379: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
380: x_return_status := 'E' ;
381: WHEN NO_DATA_FOUND THEN
382: if p_calling_module = 'FORM' then
383: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
384: p_msg_name => 'FORM_RECORD_CHANGED');
385: x_msg_data := 'FORM_RECORD_CHANGED';
386: else
387: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

383: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
384: p_msg_name => 'FORM_RECORD_CHANGED');
385: x_msg_data := 'FORM_RECORD_CHANGED';
386: else
387: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
388: p_msg_name => 'PA_XC_RECORD_CHANGED');
389: x_msg_data := 'PA_XC_RECORD_CHANGED';
390: end if;
391: x_return_status := 'E' ;

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

390: end if;
391: x_return_status := 'E' ;
392: WHEN OTHERS THEN
393: IF SQLCODE = -54 THEN
394: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
395: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
396: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
397: x_return_status := 'E' ;
398: ELSE

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

407: AND record_version_number = p_record_version_number;
408: EXCEPTION
409: WHEN NO_DATA_FOUND THEN
410: if p_calling_module = 'FORM' then
411: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
412: p_msg_name => 'FORM_RECORD_CHANGED');
413: x_msg_data := 'FORM_RECORD_CHANGED';
414: else
415: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

411: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
412: p_msg_name => 'FORM_RECORD_CHANGED');
413: x_msg_data := 'FORM_RECORD_CHANGED';
414: else
415: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
416: p_msg_name => 'PA_XC_RECORD_CHANGED');
417: x_msg_data := 'PA_XC_RECORD_CHANGED';
418: end if;
419: x_return_status := 'E' ;

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

418: end if;
419: x_return_status := 'E' ;
420: WHEN OTHERS THEN
421: IF SQLCODE = -54 THEN
422: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
423: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
424: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
425: x_return_status := 'E' ;
426: END IF;

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

582: AND record_version_number = p_record_version_number
583: FOR UPDATE OF record_version_number NOWAIT;
584: EXCEPTION
585: WHEN TIMEOUT_ON_RESOURCE THEN
586: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
587: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
588: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
589: x_return_status := 'E' ;
590: WHEN NO_DATA_FOUND THEN

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

588: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
589: x_return_status := 'E' ;
590: WHEN NO_DATA_FOUND THEN
591: if p_calling_module = 'FORM' then
592: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
593: p_msg_name => 'FORM_RECORD_CHANGED');
594: x_msg_data := 'FORM_RECORD_CHANGED';
595: else
596: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

592: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
593: p_msg_name => 'FORM_RECORD_CHANGED');
594: x_msg_data := 'FORM_RECORD_CHANGED';
595: else
596: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
597: p_msg_name => 'PA_XC_RECORD_CHANGED');
598: x_msg_data := 'PA_XC_RECORD_CHANGED';
599: end if;
600: x_return_status := 'E' ;

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

599: end if;
600: x_return_status := 'E' ;
601: WHEN OTHERS THEN
602: IF SQLCODE = -54 THEN
603: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
604: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
605: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
606: x_return_status := 'E' ;
607: ELSE

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

616: AND record_version_number = p_record_version_number;
617: EXCEPTION
618: WHEN NO_DATA_FOUND THEN
619: if p_calling_module = 'FORM' then
620: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
621: p_msg_name => 'FORM_RECORD_CHANGED');
622: x_msg_data := 'FORM_RECORD_CHANGED';
623: else
624: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

620: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
621: p_msg_name => 'FORM_RECORD_CHANGED');
622: x_msg_data := 'FORM_RECORD_CHANGED';
623: else
624: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
625: p_msg_name => 'PA_XC_RECORD_CHANGED');
626: x_msg_data := 'PA_XC_RECORD_CHANGED';
627: end if;
628: x_return_status := 'E' ;

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

627: end if;
628: x_return_status := 'E' ;
629: WHEN OTHERS THEN
630: IF SQLCODE = -54 THEN
631: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
632: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
633: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
634: x_return_status := 'E' ;
635: END IF;

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

1033: END IF;
1034:
1035: IF p_sort_order IS NULL
1036: THEN
1037: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1038: p_msg_name => 'PA_SETUP_ORDER_REQ' );
1039: x_msg_data := 'PA_SETUP_ORDER_REQ';
1040: x_return_status := 'E';
1041: RAISE FND_API.G_EXC_ERROR;

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

1052: ,x_return_status => l_return_status
1053: ,x_error_msg_code => l_error_msg_code
1054: );
1055: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1056: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1057: p_msg_name => l_error_msg_code);
1058: END IF;
1059: ELSE
1060: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

1056: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1057: p_msg_name => l_error_msg_code);
1058: END IF;
1059: ELSE
1060: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1061: p_msg_name => 'PA_SETUP_FIELD_NAME_REQ' );
1062: x_msg_data := 'PA_SETUP_FIELD_NAME_REQ';
1063: x_return_status := 'E';
1064: RAISE FND_API.G_EXC_ERROR;

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

1065: END IF;
1066:
1067: IF p_prompt IS NULL
1068: THEN
1069: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1070: p_msg_name => 'PA_SETUP_PROMPT_REQ' );
1071: x_msg_data := 'PA_SETUP_PROMPT_REQ';
1072: x_return_status := 'E';
1073: RAISE FND_API.G_EXC_ERROR;

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: );
1088: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1089: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1090: p_msg_name => l_error_msg_code);
1091: END IF;
1092: ELSE
1093: l_limiting_value := null;

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

1260: END IF;
1261:
1262: IF p_sort_order IS NULL
1263: THEN
1264: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1265: p_msg_name => 'PA_SETUP_ORDER_REQ' );
1266: x_msg_data := 'PA_SETUP_ORDER_REQ';
1267: x_return_status := 'E';
1268: RAISE FND_API.G_EXC_ERROR;

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

1279: ,x_return_status => l_return_status
1280: ,x_error_msg_code => l_error_msg_code
1281: );
1282: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1283: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1284: p_msg_name => l_error_msg_code);
1285: END IF;
1286: ELSE
1287: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

1283: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1284: p_msg_name => l_error_msg_code);
1285: END IF;
1286: ELSE
1287: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1288: p_msg_name => 'PA_SETUP_FIELD_NAME_REQ' );
1289: x_msg_data := 'PA_SETUP_FIELD_NAME_REQ';
1290: x_return_status := 'E';
1291: RAISE FND_API.G_EXC_ERROR;

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

1297:
1298: IF (l_field_name2 = 'SEGMENT1' OR l_field_name2 = 'NAME') AND
1299: l_field_name <> l_field_name2
1300: THEN
1301: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1302: p_msg_name => 'PA_SETUP_CANT_MODFY_OVER' );
1303: x_msg_data := 'PA_SETUP_CANT_MODFY_OVER';
1304: x_return_status := 'E';
1305: RAISE FND_API.G_EXC_ERROR;

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

1306: END IF;
1307:
1308: IF p_prompt IS NULL
1309: THEN
1310: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1311: p_msg_name => 'PA_SETUP_PROMPT_REQ' );
1312: x_msg_data := 'PA_SETUP_PROMPT_REQ';
1313: x_return_status := 'E';
1314: RAISE FND_API.G_EXC_ERROR;

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

1326: ,x_return_status => l_return_status
1327: ,x_error_msg_code => l_error_msg_code
1328: );
1329: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1330: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1331: p_msg_name => l_error_msg_code);
1332: END IF;
1333: ELSE
1334: l_limiting_value := null;

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

1359: AND rowid = p_row_id
1360: FOR UPDATE OF record_version_number NOWAIT;
1361: EXCEPTION
1362: WHEN TIMEOUT_ON_RESOURCE THEN
1363: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1364: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1365: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1366: x_return_status := 'E' ;
1367: WHEN NO_DATA_FOUND THEN

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

1365: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1366: x_return_status := 'E' ;
1367: WHEN NO_DATA_FOUND THEN
1368: if p_calling_module = 'FORM' then
1369: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1370: p_msg_name => 'FORM_RECORD_CHANGED');
1371: x_msg_data := 'FORM_RECORD_CHANGED';
1372: else
1373: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

1369: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1370: p_msg_name => 'FORM_RECORD_CHANGED');
1371: x_msg_data := 'FORM_RECORD_CHANGED';
1372: else
1373: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1374: p_msg_name => 'PA_XC_RECORD_CHANGED');
1375: x_msg_data := 'PA_XC_RECORD_CHANGED';
1376: end if;
1377: x_return_status := 'E' ;

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

1376: end if;
1377: x_return_status := 'E' ;
1378: WHEN OTHERS THEN
1379: IF SQLCODE = -54 THEN
1380: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1381: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1382: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1383: x_return_status := 'E' ;
1384: ELSE

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

1394: AND record_version_number = p_record_version_number;
1395: EXCEPTION
1396: WHEN NO_DATA_FOUND THEN
1397: if p_calling_module = 'FORM' then
1398: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1399: p_msg_name => 'FORM_RECORD_CHANGED');
1400: x_msg_data := 'FORM_RECORD_CHANGED';
1401: else
1402: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

1398: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1399: p_msg_name => 'FORM_RECORD_CHANGED');
1400: x_msg_data := 'FORM_RECORD_CHANGED';
1401: else
1402: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1403: p_msg_name => 'PA_XC_RECORD_CHANGED');
1404: x_msg_data := 'PA_XC_RECORD_CHANGED';
1405: end if;
1406: x_return_status := 'E' ;

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

1405: end if;
1406: x_return_status := 'E' ;
1407: WHEN OTHERS THEN
1408: IF SQLCODE = -54 THEN
1409: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1410: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1411: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1412: x_return_status := 'E' ;
1413: END IF;

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

1566: AND rowid = p_row_id
1567: FOR UPDATE OF record_version_number NOWAIT;
1568: EXCEPTION
1569: WHEN TIMEOUT_ON_RESOURCE THEN
1570: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1571: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1572: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1573: x_return_status := 'E' ;
1574: WHEN NO_DATA_FOUND THEN

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

1572: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1573: x_return_status := 'E' ;
1574: WHEN NO_DATA_FOUND THEN
1575: if p_calling_module = 'FORM' then
1576: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1577: p_msg_name => 'FORM_RECORD_CHANGED');
1578: x_msg_data := 'FORM_RECORD_CHANGED';
1579: else
1580: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

1576: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1577: p_msg_name => 'FORM_RECORD_CHANGED');
1578: x_msg_data := 'FORM_RECORD_CHANGED';
1579: else
1580: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1581: p_msg_name => 'PA_XC_RECORD_CHANGED');
1582: x_msg_data := 'PA_XC_RECORD_CHANGED';
1583: end if;
1584: x_return_status := 'E' ;

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

1583: end if;
1584: x_return_status := 'E' ;
1585: WHEN OTHERS THEN
1586: IF SQLCODE = -54 THEN
1587: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1588: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1589: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1590: x_return_status := 'E' ;
1591: ELSE

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

1601: AND record_version_number = p_record_version_number;
1602: EXCEPTION
1603: WHEN NO_DATA_FOUND THEN
1604: if p_calling_module = 'FORM' then
1605: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1606: p_msg_name => 'FORM_RECORD_CHANGED');
1607: x_msg_data := 'FORM_RECORD_CHANGED';
1608: else
1609: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

1605: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1606: p_msg_name => 'FORM_RECORD_CHANGED');
1607: x_msg_data := 'FORM_RECORD_CHANGED';
1608: else
1609: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1610: p_msg_name => 'PA_XC_RECORD_CHANGED');
1611: x_msg_data := 'PA_XC_RECORD_CHANGED';
1612: end if;
1613: x_return_status := 'E' ;

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

1612: end if;
1613: x_return_status := 'E' ;
1614: WHEN OTHERS THEN
1615: IF SQLCODE = -54 THEN
1616: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1617: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1618: x_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1619: x_return_status := 'E' ;
1620: END IF;