eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FPA_PROCESS_PVT dependencies on FND_MESSAGE

Line 169: FND_MESSAGE.SET_NAME('FPA','FPA_DUPLICATE_PCNAME');

165: FROM fpa_portfs_vl p
166: WHERE portfolio = p_pc_all_obj.pc_info.portfolio;
167:
168: -- Specify the msg, add it in FND_MSG_PUB and raise exp error
169: FND_MESSAGE.SET_NAME('FPA','FPA_DUPLICATE_PCNAME');
170: FND_MESSAGE.SET_TOKEN('PORTFOLIO_NAME', l_portfolio_name);
171: FND_MESSAGE.SET_TOKEN('PC_NAME', p_pc_all_obj.pc_desc_fields.name);
172: FND_MSG_PUB.ADD;
173: RAISE FND_API.G_EXC_ERROR;

Line 170: FND_MESSAGE.SET_TOKEN('PORTFOLIO_NAME', l_portfolio_name);

166: WHERE portfolio = p_pc_all_obj.pc_info.portfolio;
167:
168: -- Specify the msg, add it in FND_MSG_PUB and raise exp error
169: FND_MESSAGE.SET_NAME('FPA','FPA_DUPLICATE_PCNAME');
170: FND_MESSAGE.SET_TOKEN('PORTFOLIO_NAME', l_portfolio_name);
171: FND_MESSAGE.SET_TOKEN('PC_NAME', p_pc_all_obj.pc_desc_fields.name);
172: FND_MSG_PUB.ADD;
173: RAISE FND_API.G_EXC_ERROR;
174:

Line 171: FND_MESSAGE.SET_TOKEN('PC_NAME', p_pc_all_obj.pc_desc_fields.name);

167:
168: -- Specify the msg, add it in FND_MSG_PUB and raise exp error
169: FND_MESSAGE.SET_NAME('FPA','FPA_DUPLICATE_PCNAME');
170: FND_MESSAGE.SET_TOKEN('PORTFOLIO_NAME', l_portfolio_name);
171: FND_MESSAGE.SET_TOKEN('PC_NAME', p_pc_all_obj.pc_desc_fields.name);
172: FND_MSG_PUB.ADD;
173: RAISE FND_API.G_EXC_ERROR;
174:
175: END IF;

Line 702: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');

698: );
699: RAISE;
700:
701: WHEN OTHERS THEN
702: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
703: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Create_Pc');
704: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
705: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
706: FND_MSG_PUB.ADD;

Line 703: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Create_Pc');

699: RAISE;
700:
701: WHEN OTHERS THEN
702: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
703: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Create_Pc');
704: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
705: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
706: FND_MSG_PUB.ADD;
707: -- Detach AW Workspace

Line 704: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);

700:
701: WHEN OTHERS THEN
702: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
703: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Create_Pc');
704: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
705: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
706: FND_MSG_PUB.ADD;
707: -- Detach AW Workspace
708: Fpa_Utilities_Pvt.detach_AW

Line 705: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);

701: WHEN OTHERS THEN
702: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
703: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Create_Pc');
704: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
705: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
706: FND_MSG_PUB.ADD;
707: -- Detach AW Workspace
708: Fpa_Utilities_Pvt.detach_AW
709: (

Line 1042: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');

1038:
1039:
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1043: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Update_Pc');
1044: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1045: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1046: FND_MSG_PUB.ADD;

Line 1043: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Update_Pc');

1039:
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1043: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Update_Pc');
1044: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1045: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1046: FND_MSG_PUB.ADD;
1047: ROLLBACK;

Line 1044: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);

1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1043: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Update_Pc');
1044: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1045: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1046: FND_MSG_PUB.ADD;
1047: ROLLBACK;
1048: -- Detach AW Workspace

Line 1045: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);

1041: WHEN OTHERS THEN
1042: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1043: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Update_Pc');
1044: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1045: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1046: FND_MSG_PUB.ADD;
1047: ROLLBACK;
1048: -- Detach AW Workspace
1049: Fpa_Utilities_Pvt.detach_AW

Line 1291: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');

1287:
1288:
1289: EXCEPTION
1290: WHEN OTHERS THEN
1291: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1292: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Set_Pc_Initiate');
1293: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1294: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1295: FND_MSG_PUB.ADD;

Line 1292: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Set_Pc_Initiate');

1288:
1289: EXCEPTION
1290: WHEN OTHERS THEN
1291: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1292: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Set_Pc_Initiate');
1293: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1294: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1295: FND_MSG_PUB.ADD;
1296: ROLLBACK;

Line 1293: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);

1289: EXCEPTION
1290: WHEN OTHERS THEN
1291: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1292: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Set_Pc_Initiate');
1293: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1294: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1295: FND_MSG_PUB.ADD;
1296: ROLLBACK;
1297: -- Detach AW Workspace

Line 1294: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);

1290: WHEN OTHERS THEN
1291: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1292: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Set_Pc_Initiate');
1293: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1294: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1295: FND_MSG_PUB.ADD;
1296: ROLLBACK;
1297: -- Detach AW Workspace
1298: Fpa_Utilities_Pvt.detach_AW

Line 1371: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');

1367:
1368:
1369: EXCEPTION
1370: WHEN OTHERS THEN
1371: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1372: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row');
1373: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1374: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1375: FND_MSG_PUB.ADD;

Line 1372: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row');

1368:
1369: EXCEPTION
1370: WHEN OTHERS THEN
1371: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1372: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row');
1373: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1374: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1375: FND_MSG_PUB.ADD;
1376: ROLLBACK;

Line 1373: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);

1369: EXCEPTION
1370: WHEN OTHERS THEN
1371: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1372: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row');
1373: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1374: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1375: FND_MSG_PUB.ADD;
1376: ROLLBACK;
1377:

Line 1374: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);

1370: WHEN OTHERS THEN
1371: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1372: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Pa_Dist_List_Items_Update_Row');
1373: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1374: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1375: FND_MSG_PUB.ADD;
1376: ROLLBACK;
1377:
1378: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1441: FND_MESSAGE.SET_NAME('FPA','FPA_DUP_PORTF_NAME');

1437: x_return_status,
1438: x_msg_data,
1439: x_msg_count) > 0 THEN
1440:
1441: FND_MESSAGE.SET_NAME('FPA','FPA_DUP_PORTF_NAME');
1442: FND_MESSAGE.SET_TOKEN('PORTF_NAME',portfolio_rec.portfolio_name);
1443:
1444: FND_MSG_PUB.ADD;
1445: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1442: FND_MESSAGE.SET_TOKEN('PORTF_NAME',portfolio_rec.portfolio_name);

1438: x_msg_data,
1439: x_msg_count) > 0 THEN
1440:
1441: FND_MESSAGE.SET_NAME('FPA','FPA_DUP_PORTF_NAME');
1442: FND_MESSAGE.SET_TOKEN('PORTF_NAME',portfolio_rec.portfolio_name);
1443:
1444: FND_MSG_PUB.ADD;
1445: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1446: fnd_log.string

Line 1607: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');

1603: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1604: ,p_data => x_msg_data);
1605:
1606: WHEN OTHERS THEN
1607: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1608: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.create_portfolio');
1609: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1610: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1611: FND_MSG_PUB.ADD;

Line 1608: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.create_portfolio');

1604: ,p_data => x_msg_data);
1605:
1606: WHEN OTHERS THEN
1607: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1608: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.create_portfolio');
1609: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1610: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1611: FND_MSG_PUB.ADD;
1612: -- Detach AW Workspace

Line 1609: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);

1605:
1606: WHEN OTHERS THEN
1607: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1608: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.create_portfolio');
1609: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1610: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1611: FND_MSG_PUB.ADD;
1612: -- Detach AW Workspace
1613: Fpa_Utilities_Pvt.detach_AW

Line 1610: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);

1606: WHEN OTHERS THEN
1607: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1608: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.create_portfolio');
1609: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1610: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1611: FND_MSG_PUB.ADD;
1612: -- Detach AW Workspace
1613: Fpa_Utilities_Pvt.detach_AW
1614: (

Line 1732: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');

1728: EXCEPTION
1729:
1730: WHEN OTHERS THEN
1731: -- Detach AW Workspace
1732: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1733: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.Delete_Portfolio');
1734: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1735: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1736: FND_MSG_PUB.ADD;

Line 1733: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.Delete_Portfolio');

1729:
1730: WHEN OTHERS THEN
1731: -- Detach AW Workspace
1732: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1733: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.Delete_Portfolio');
1734: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1735: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1736: FND_MSG_PUB.ADD;
1737: -- Detach AW Workspace

Line 1734: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);

1730: WHEN OTHERS THEN
1731: -- Detach AW Workspace
1732: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1733: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.Delete_Portfolio');
1734: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1735: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1736: FND_MSG_PUB.ADD;
1737: -- Detach AW Workspace
1738: Fpa_Utilities_Pvt.detach_AW

Line 1735: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);

1731: -- Detach AW Workspace
1732: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1733: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.Delete_Portfolio');
1734: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1735: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1736: FND_MSG_PUB.ADD;
1737: -- Detach AW Workspace
1738: Fpa_Utilities_Pvt.detach_AW
1739: (

Line 1810: FND_MESSAGE.SET_NAME('FPA','FPA_DUP_PORTF_NAME');

1806: x_return_status,
1807: x_msg_data,
1808: x_msg_count) > 0 THEN
1809:
1810: FND_MESSAGE.SET_NAME('FPA','FPA_DUP_PORTF_NAME');
1811: FND_MESSAGE.SET_TOKEN('PORTF_NAME',portfolio_rec.portfolio_name);
1812: FND_MSG_PUB.ADD;
1813:
1814: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1811: FND_MESSAGE.SET_TOKEN('PORTF_NAME',portfolio_rec.portfolio_name);

1807: x_msg_data,
1808: x_msg_count) > 0 THEN
1809:
1810: FND_MESSAGE.SET_NAME('FPA','FPA_DUP_PORTF_NAME');
1811: FND_MESSAGE.SET_TOKEN('PORTF_NAME',portfolio_rec.portfolio_name);
1812: FND_MSG_PUB.ADD;
1813:
1814: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1815: fnd_log.string

Line 1957: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');

1953: RAISE;
1954:
1955: WHEN OTHERS THEN
1956: -- Detach AW Workspace
1957: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1958: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.update_portfolio');
1959: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1960: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1961: FND_MSG_PUB.ADD;

Line 1958: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.update_portfolio');

1954:
1955: WHEN OTHERS THEN
1956: -- Detach AW Workspace
1957: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1958: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.update_portfolio');
1959: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1960: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1961: FND_MSG_PUB.ADD;
1962: -- Detach AW Workspace

Line 1959: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);

1955: WHEN OTHERS THEN
1956: -- Detach AW Workspace
1957: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1958: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.update_portfolio');
1959: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1960: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1961: FND_MSG_PUB.ADD;
1962: -- Detach AW Workspace
1963: Fpa_Utilities_Pvt.detach_AW

Line 1960: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);

1956: -- Detach AW Workspace
1957: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
1958: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.update_portfolio');
1959: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
1960: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
1961: FND_MSG_PUB.ADD;
1962: -- Detach AW Workspace
1963: Fpa_Utilities_Pvt.detach_AW
1964: (

Line 2052: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');

2048: END IF;
2049:
2050: EXCEPTION
2051: WHEN OTHERS THEN
2052: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
2053: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.delete_Portfolio_user');
2054: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
2055: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
2056: FND_MSG_PUB.ADD;

Line 2053: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.delete_Portfolio_user');

2049:
2050: EXCEPTION
2051: WHEN OTHERS THEN
2052: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
2053: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.delete_Portfolio_user');
2054: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
2055: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
2056: FND_MSG_PUB.ADD;
2057: -- Detach AW Workspace

Line 2054: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);

2050: EXCEPTION
2051: WHEN OTHERS THEN
2052: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
2053: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.delete_Portfolio_user');
2054: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
2055: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
2056: FND_MSG_PUB.ADD;
2057: -- Detach AW Workspace
2058: Fpa_Utilities_Pvt.detach_AW

Line 2055: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);

2051: WHEN OTHERS THEN
2052: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
2053: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.delete_Portfolio_user');
2054: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
2055: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
2056: FND_MSG_PUB.ADD;
2057: -- Detach AW Workspace
2058: Fpa_Utilities_Pvt.detach_AW
2059: (

Line 4025: FND_MESSAGE.SET_NAME('FPA','FPA_DUPLICATE_SCE_NAME');

4021: );
4022:
4023: -- If Duplicate Scenario Name exists, then raise error and halt all execution
4024: IF l_sce_name_count > 0 THEN
4025: FND_MESSAGE.SET_NAME('FPA','FPA_DUPLICATE_SCE_NAME');
4026: FND_MESSAGE.SET_TOKEN('SCE_NAME', p_scenario_name);
4027: FND_MSG_PUB.ADD;
4028: RAISE FND_API.G_EXC_ERROR;
4029: END IF;

Line 4026: FND_MESSAGE.SET_TOKEN('SCE_NAME', p_scenario_name);

4022:
4023: -- If Duplicate Scenario Name exists, then raise error and halt all execution
4024: IF l_sce_name_count > 0 THEN
4025: FND_MESSAGE.SET_NAME('FPA','FPA_DUPLICATE_SCE_NAME');
4026: FND_MESSAGE.SET_TOKEN('SCE_NAME', p_scenario_name);
4027: FND_MSG_PUB.ADD;
4028: RAISE FND_API.G_EXC_ERROR;
4029: END IF;
4030:

Line 5095: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');

5091: END IF;
5092: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
5093: ,p_data => x_msg_data);
5094: WHEN OTHERS THEN
5095: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
5096: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.Close_Pc');
5097: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
5098: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
5099: FND_MSG_PUB.ADD;

Line 5096: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.Close_Pc');

5092: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
5093: ,p_data => x_msg_data);
5094: WHEN OTHERS THEN
5095: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
5096: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.Close_Pc');
5097: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
5098: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
5099: FND_MSG_PUB.ADD;
5100: -- Detach AW Workspace

Line 5097: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);

5093: ,p_data => x_msg_data);
5094: WHEN OTHERS THEN
5095: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
5096: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.Close_Pc');
5097: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
5098: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
5099: FND_MSG_PUB.ADD;
5100: -- Detach AW Workspace
5101: Fpa_Utilities_Pvt.detach_AW

Line 5098: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);

5094: WHEN OTHERS THEN
5095: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
5096: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa_process_pvt.Close_Pc');
5097: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
5098: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
5099: FND_MSG_PUB.ADD;
5100: -- Detach AW Workspace
5101: Fpa_Utilities_Pvt.detach_AW
5102: ( p_api_version => 1.0,

Line 5193: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');

5189:
5190:
5191: EXCEPTION
5192: WHEN OTHERS THEN
5193: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
5194: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Update_Scen_Proj_User_Ranks');
5195: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
5196: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
5197: FND_MSG_PUB.ADD;

Line 5194: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Update_Scen_Proj_User_Ranks');

5190:
5191: EXCEPTION
5192: WHEN OTHERS THEN
5193: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
5194: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Update_Scen_Proj_User_Ranks');
5195: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
5196: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
5197: FND_MSG_PUB.ADD;
5198: ROLLBACK;

Line 5195: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);

5191: EXCEPTION
5192: WHEN OTHERS THEN
5193: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
5194: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Update_Scen_Proj_User_Ranks');
5195: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
5196: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
5197: FND_MSG_PUB.ADD;
5198: ROLLBACK;
5199: -- Detach AW Workspace

Line 5196: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);

5192: WHEN OTHERS THEN
5193: FND_MESSAGE.SET_NAME('FPA','FPA_UNEXP_GENERAL_ERROR');
5194: FND_MESSAGE.SET_TOKEN('SOURCE', 'fpa.sql.FPA_Process_Pvt.Update_Scen_Proj_User_Ranks');
5195: FND_MESSAGE.SET_TOKEN('SQL_ERR_CODE', SQLCODE);
5196: FND_MESSAGE.SET_TOKEN('SQL_ERR_MSG', SQLERRM);
5197: FND_MSG_PUB.ADD;
5198: ROLLBACK;
5199: -- Detach AW Workspace
5200: Fpa_Utilities_Pvt.detach_AW