DBA Data[Home] [Help]

APPS.PA_CUSTOMERS_CONTACTS_PVT dependencies on PA_UTILS

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

429: AND record_version_number = p_record_version_number
430: FOR UPDATE OF record_version_number NOWAIT;
431: EXCEPTION
432: when TIMEOUT_ON_RESOURCE then
433: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
434: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
435: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
436: when NO_DATA_FOUND then
437: if p_calling_module = 'FORM' then

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

434: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
435: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
436: when NO_DATA_FOUND then
437: if p_calling_module = 'FORM' then
438: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
439: p_msg_name => 'FORM_RECORD_CHANGED');
440: l_msg_data := 'FORM_RECORD_CHANGED';
441: else
442: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

438: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
439: p_msg_name => 'FORM_RECORD_CHANGED');
440: l_msg_data := 'FORM_RECORD_CHANGED';
441: else
442: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
443: p_msg_name => 'PA_XC_RECORD_CHANGED');
444: l_msg_data := 'PA_XC_RECORD_CHANGED';
445: end if;
446: when OTHERS then

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

444: l_msg_data := 'PA_XC_RECORD_CHANGED';
445: end if;
446: when OTHERS then
447: if SQLCODE = -54 then
448: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
449: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
450: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
451: else
452: raise;

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

468: EXCEPTION
469: when NO_DATA_FOUND then
470: --dbms_output.put_line('comes here');
471: if p_calling_module = 'FORM' then
472: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
473: p_msg_name => 'FORM_RECORD_CHANGED');
474: l_msg_data := 'FORM_RECORD_CHANGED';
475: else
476: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

472: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
473: p_msg_name => 'FORM_RECORD_CHANGED');
474: l_msg_data := 'FORM_RECORD_CHANGED';
475: else
476: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
477: p_msg_name => 'PA_XC_RECORD_CHANGED');
478: l_msg_data := 'PA_XC_RECORD_CHANGED';
479: end if;
480: when OTHERS then

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

778: AND record_version_number = p_record_version_number
779: FOR UPDATE OF record_version_number NOWAIT;
780: EXCEPTION
781: when TIMEOUT_ON_RESOURCE then
782: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
783: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
784: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
785: when NO_DATA_FOUND then
786: if p_calling_module = 'FORM' then

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

783: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
784: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
785: when NO_DATA_FOUND then
786: if p_calling_module = 'FORM' then
787: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
788: p_msg_name => 'FORM_RECORD_CHANGED');
789: l_msg_data := 'FORM_RECORD_CHANGED';
790: else
791: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

787: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
788: p_msg_name => 'FORM_RECORD_CHANGED');
789: l_msg_data := 'FORM_RECORD_CHANGED';
790: else
791: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
792: p_msg_name => 'PA_XC_RECORD_CHANGED');
793: l_msg_data := 'PA_XC_RECORD_CHANGED';
794: end if;
795: when OTHERS then

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

793: l_msg_data := 'PA_XC_RECORD_CHANGED';
794: end if;
795: when OTHERS then
796: if SQLCODE = -54 then
797: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
798: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
799: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
800: else
801: raise;

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

810: AND record_version_number = p_record_version_number;
811: EXCEPTION
812: when NO_DATA_FOUND then
813: if p_calling_module = 'FORM' then
814: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
815: p_msg_name => 'FORM_RECORD_CHANGED');
816: l_msg_data := 'FORM_RECORD_CHANGED';
817: else
818: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

814: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
815: p_msg_name => 'FORM_RECORD_CHANGED');
816: l_msg_data := 'FORM_RECORD_CHANGED';
817: else
818: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
819: p_msg_name => 'PA_XC_RECORD_CHANGED');
820: l_msg_data := 'PA_XC_RECORD_CHANGED';
821: end if;
822: when OTHERS then

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

1168: AND record_version_number = p_record_version_number
1169: FOR UPDATE OF record_version_number NOWAIT;
1170: EXCEPTION
1171: when TIMEOUT_ON_RESOURCE then
1172: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1173: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1174: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1175: when NO_DATA_FOUND then
1176: if p_calling_module = 'FORM' then

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

1173: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1174: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1175: when NO_DATA_FOUND then
1176: if p_calling_module = 'FORM' then
1177: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1178: p_msg_name => 'FORM_RECORD_CHANGED');
1179: l_msg_data := 'FORM_RECORD_CHANGED';
1180: else
1181: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

1177: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1178: p_msg_name => 'FORM_RECORD_CHANGED');
1179: l_msg_data := 'FORM_RECORD_CHANGED';
1180: else
1181: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1182: p_msg_name => 'PA_XC_RECORD_CHANGED');
1183: l_msg_data := 'PA_XC_RECORD_CHANGED';
1184: end if;
1185: when OTHERS then

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

1183: l_msg_data := 'PA_XC_RECORD_CHANGED';
1184: end if;
1185: when OTHERS then
1186: if SQLCODE = -54 then
1187: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1188: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1189: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1190: else
1191: raise;

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

1199: AND record_version_number = p_record_version_number;
1200: EXCEPTION
1201: when NO_DATA_FOUND then
1202: if p_calling_module = 'FORM' then
1203: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1204: p_msg_name => 'FORM_RECORD_CHANGED');
1205: l_msg_data := 'FORM_RECORD_CHANGED';
1206: else
1207: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

1203: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1204: p_msg_name => 'FORM_RECORD_CHANGED');
1205: l_msg_data := 'FORM_RECORD_CHANGED';
1206: else
1207: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1208: p_msg_name => 'PA_XC_RECORD_CHANGED');
1209: l_msg_data := 'PA_XC_RECORD_CHANGED';
1210: end if;
1211: when OTHERS then

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

1367: AND record_version_number = p_record_version_number
1368: FOR UPDATE OF record_version_number NOWAIT;
1369: EXCEPTION
1370: when TIMEOUT_ON_RESOURCE then
1371: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1372: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1373: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1374: when NO_DATA_FOUND then
1375: if p_calling_module = 'FORM' then

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

1372: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1373: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1374: when NO_DATA_FOUND then
1375: if p_calling_module = 'FORM' then
1376: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1377: p_msg_name => 'FORM_RECORD_CHANGED');
1378: l_msg_data := 'FORM_RECORD_CHANGED';
1379: else
1380: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

1376: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1377: p_msg_name => 'FORM_RECORD_CHANGED');
1378: l_msg_data := 'FORM_RECORD_CHANGED';
1379: else
1380: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1381: p_msg_name => 'PA_XC_RECORD_CHANGED');
1382: l_msg_data := 'PA_XC_RECORD_CHANGED';
1383: end if;
1384: when OTHERS then

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

1382: l_msg_data := 'PA_XC_RECORD_CHANGED';
1383: end if;
1384: when OTHERS then
1385: if SQLCODE = -54 then
1386: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1387: p_msg_name => 'PA_XC_ROW_ALREADY_LOCKED');
1388: l_msg_data := 'PA_XC_ROW_ALREADY_LOCKED';
1389: else
1390: raise;

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

1401: AND record_version_number = p_record_version_number;
1402: EXCEPTION
1403: when NO_DATA_FOUND then
1404: if p_calling_module = 'FORM' then
1405: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1406: p_msg_name => 'FORM_RECORD_CHANGED');
1407: l_msg_data := 'FORM_RECORD_CHANGED';
1408: else
1409: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

1405: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'FND',
1406: p_msg_name => 'FORM_RECORD_CHANGED');
1407: l_msg_data := 'FORM_RECORD_CHANGED';
1408: else
1409: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1410: p_msg_name => 'PA_XC_RECORD_CHANGED');
1411: l_msg_data := 'PA_XC_RECORD_CHANGED';
1412: end if;
1413: when OTHERS then

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

1622: ,x_return_status => l_return_status
1623: ,x_error_msg_code => l_error_msg_code);
1624: --dbms_output.put_line('Value of l_return_status 1'||l_return_status);
1625: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1626: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1627: p_msg_name => l_error_msg_code);
1628: end if;
1629: end if;
1630:

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

1638: ,x_error_msg_code => l_error_msg_code);
1639: --dbms_output.put_line('Value of l_return_status 2'||l_return_status||'det'||l_error_msg_code);
1640:
1641: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1642: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1643: p_msg_name => l_error_msg_code);
1644: end if;
1645:
1646: IF (p_calling_module <> 'FORM') AND (p_calling_module <> 'AMG') -- Added by aditi for tracking Bug --bug 2838822

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

1653: ,x_error_msg_code => l_error_msg_code);
1654: --dbms_output.put_line('Value of l_return_status 3'||l_return_status);
1655:
1656: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1657: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1658: p_msg_name => l_error_msg_code);
1659: end if;
1660: END IF;
1661: --dbms_output.put_line('value of p_bill_to_address_id'||p_bill_to_address_id);

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

1669: ,x_error_msg_code => l_error_msg_code);
1670: --dbms_output.put_line('Value of l_return_status 4'||l_return_status);
1671:
1672: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1673: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1674: p_msg_name => l_error_msg_code);
1675: end if;
1676:
1677: PA_CUSTOMERS_CONTACTS_UTILS.CHECK_CC_PRVDR_FLAG_CONTRIB

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

1683: ,x_error_msg_code => l_error_msg_code);
1684: --dbms_output.put_line('Value of l_return_status 5'||l_return_status);
1685:
1686: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1687: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1688: p_msg_name => l_error_msg_code);
1689: end if;
1690: --dbms_output.put_line('Value of l_bill_another_project_flag outside loop'||l_bill_another_project_flag);
1691: IF p_calling_module <> 'AMG' THEN -- Added by aditi for tracking Bug 4153629

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

1702: END IF; -- Tracking Bug 4153629
1703: --dbms_output.put_line('Value of l_bill_another_project_flag outside loop'||l_bill_another_project_flag);
1704:
1705: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1706: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1707: p_msg_name => l_error_msg_code);
1708: end if;
1709: x_bill_another_project_flag := l_bill_another_project_flag;
1710:

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

1719: ,x_error_msg_code => l_error_msg_code);
1720: --dbms_output.put_line('Value of l_return_status 7'||l_return_status);
1721:
1722: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1723: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1724: p_msg_name => l_error_msg_code);
1725: end if;
1726: end if;
1727:

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

1734: ,x_error_msg_code => l_error_msg_code);
1735: --dbms_output.put_line('Value of l_return_status 8'||l_return_status);
1736:
1737: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1738: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1739: p_msg_name => l_error_msg_code);
1740: end if;
1741: end if;
1742:

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

1748: ,x_error_msg_code => l_error_msg_code);
1749: --dbms_output.put_line('Value of l_return_status 9'||l_return_status);
1750:
1751: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1752: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1753: p_msg_name => l_error_msg_code);
1754: end if;
1755: end if;
1756:

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

1834: ,p_project_contact_type_code => p_project_contact_type_code
1835: ,x_return_status => l_return_status
1836: ,x_error_msg_code => l_error_msg_code);
1837: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1838: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1839: p_msg_name => l_error_msg_code);
1840: end if;
1841: end if;
1842: