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_MSG_PUB

Line 129: FND_MSG_PUB.Initialize;

125: END Get_Inv_Crit_Setup_Defaults;
126:
127: BEGIN
128: -- clear all previous messages.
129: FND_MSG_PUB.Initialize;
130:
131: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
132: FND_LOG.String
133: (

Line 168: -- Specify the msg, add it in FND_MSG_PUB and raise exp error

164: SELECT p.name INTO l_portfolio_name
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;

Line 172: FND_MSG_PUB.ADD;

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;
176:

Line 694: FND_MSG_PUB.Count_And_Get

690: WHEN FND_API.G_EXC_ERROR THEN
691: ROLLBACK;
692:
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: FND_MSG_PUB.Count_And_Get
695: (
696: p_count => x_msg_count,
697: p_data => x_msg_data
698: );

Line 706: FND_MSG_PUB.ADD;

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: (
710: p_api_version => 1.0,

Line 728: FND_MSG_PUB.count_and_get

724: SQLERRM
725: );
726: END IF;
727:
728: FND_MSG_PUB.count_and_get
729: (
730: p_count => x_msg_count,
731: p_data => x_msg_data
732: );

Line 757: FND_MSG_PUB.Initialize;

753: IS
754: l_pc_info fpa_pc_info_obj;
755: BEGIN
756: -- clear all previous messages.
757: FND_MSG_PUB.Initialize;
758:
759: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
760: FND_LOG.String
761: (

Line 1046: FND_MSG_PUB.ADD;

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
1050: (

Line 1068: FND_MSG_PUB.count_and_get

1064: SQLERRM
1065: );
1066: END IF;
1067:
1068: FND_MSG_PUB.count_and_get
1069: (
1070: p_count => x_msg_count,
1071: p_data => x_msg_data
1072: );

Line 1295: FND_MSG_PUB.ADD;

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
1299: (

Line 1317: FND_MSG_PUB.count_and_get

1313: SQLERRM
1314: );
1315: END IF;
1316:
1317: FND_MSG_PUB.count_and_get
1318: (
1319: p_count => x_msg_count,
1320: p_data => x_msg_data
1321: );

Line 1375: FND_MSG_PUB.ADD;

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;
1379:

Line 1389: FND_MSG_PUB.count_and_get

1385: SQLERRM
1386: );
1387: END IF;
1388:
1389: FND_MSG_PUB.count_and_get
1390: (
1391: p_count => x_msg_count,
1392: p_data => x_msg_data
1393: );

Line 1419: FND_MSG_PUB.Initialize;

1415: l_msg_log VARCHAR2(2000) := null;
1416: BEGIN
1417:
1418: -- clear all previous messages.
1419: FND_MSG_PUB.Initialize;
1420:
1421: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1422: fnd_log.string
1423: (

Line 1444: FND_MSG_PUB.ADD;

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
1447: (
1448: FND_LOG.LEVEL_PROCEDURE,

Line 1586: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1582: SQLERRM
1583: );
1584: END IF;
1585:
1586: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1587: ,p_data => x_msg_data);
1588:
1589: WHEN FND_API.G_EXC_ERROR THEN
1590:

Line 1603: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1599: SQLERRM
1600: );
1601: END IF;
1602:
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');

Line 1611: FND_MSG_PUB.ADD;

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: (
1615: p_api_version => 1.0,

Line 1633: FND_MSG_PUB.count_and_get

1629: SQLERRM
1630: );
1631: END IF;
1632:
1633: FND_MSG_PUB.count_and_get
1634: (
1635: p_count => x_msg_count,
1636: p_data => x_msg_data
1637: );

Line 1736: FND_MSG_PUB.ADD;

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: (
1740: p_api_version => 1.0,

Line 1758: FND_MSG_PUB.count_and_get

1754: SQLERRM
1755: );
1756: END IF;
1757:
1758: FND_MSG_PUB.count_and_get
1759: (
1760: p_count => x_msg_count,
1761: p_data => x_msg_data
1762: );

Line 1788: FND_MSG_PUB.Initialize;

1784:
1785: IS
1786: BEGIN
1787: -- clear all previous messages.
1788: FND_MSG_PUB.Initialize;
1789:
1790: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1791: fnd_log.string
1792: (

Line 1812: FND_MSG_PUB.ADD;

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
1816: (

Line 1950: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1946: SQLERRM
1947: );
1948: END IF;
1949:
1950: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1951: ,p_data => x_msg_data);
1952:
1953: RAISE;
1954:

Line 1961: FND_MSG_PUB.ADD;

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: (
1965: p_api_version => 1.0,

Line 1983: FND_MSG_PUB.count_and_get

1979: SQLERRM
1980: );
1981: END IF;
1982:
1983: FND_MSG_PUB.count_and_get
1984: (
1985: p_count => x_msg_count,
1986: p_data => x_msg_data
1987: );

Line 2041: FND_MSG_PUB.count_and_get

2037: END IF;
2038: IF x_return_status <> 'S' THEN
2039: BEGIN
2040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2041: FND_MSG_PUB.count_and_get
2042: (
2043: p_count => x_msg_count,
2044: p_data => x_msg_data
2045: );

Line 2056: FND_MSG_PUB.ADD;

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: (
2060: p_api_version => 1.0,

Line 2077: FND_MSG_PUB.count_and_get

2073: SQLERRM
2074: );
2075: END IF;
2076:
2077: FND_MSG_PUB.count_and_get
2078: (
2079: p_count => x_msg_count,
2080: p_data => x_msg_data
2081: );

Line 2212: FND_MSG_PUB.count_and_get

2208: -- CHECK IF THE SECUCITY CALL IS SUCCESSFUL
2209: IF x_return_status <> 'S' THEN
2210: BEGIN
2211: x_return_status := 'U';
2212: FND_MSG_PUB.count_and_get
2213: (
2214: p_count => x_msg_count,
2215: p_data => x_msg_data
2216: );

Line 2300: FND_MSG_PUB.Initialize;

2296: l_due_date DATE;
2297:
2298: BEGIN
2299:
2300: FND_MSG_PUB.Initialize;
2301:
2302: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2303: FND_LOG.STRING
2304: (

Line 2484: FND_MSG_PUB.count_and_get

2480: SQLERRM
2481: );
2482: END IF;
2483:
2484: FND_MSG_PUB.count_and_get
2485: (
2486: p_count => x_msg_count,
2487: p_data => x_msg_data
2488: );

Line 2545: FND_MSG_PUB.Initialize;

2541: BEGIN
2542:
2543:
2544:
2545: FND_MSG_PUB.Initialize;
2546:
2547: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2548: FND_LOG.STRING
2549: (

Line 3058: FND_MSG_PUB.count_and_get

3054: SQLERRM
3055: );
3056: END IF;
3057:
3058: FND_MSG_PUB.count_and_get
3059: (
3060: p_count => x_msg_count,
3061: p_data => x_msg_data
3062: );

Line 3091: FND_MSG_PUB.Initialize;

3087: projectIdTbl FPA_VALIDATION_PVT.PROJECT_ID_TBL_TYPE;
3088:
3089: BEGIN
3090:
3091: FND_MSG_PUB.Initialize;
3092:
3093: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3094: FND_LOG.STRING
3095: (

Line 3357: FND_MSG_PUB.count_and_get

3353: SQLERRM
3354: );
3355: END IF;
3356:
3357: FND_MSG_PUB.count_and_get
3358: (
3359: p_count => x_msg_count,
3360: p_data => x_msg_data
3361: );

Line 3390: FND_MSG_PUB.Initialize;

3386: l_class_code_id NUMBER;
3387:
3388: BEGIN
3389:
3390: FND_MSG_PUB.Initialize;
3391:
3392: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3393: FND_LOG.STRING
3394: (

Line 3568: FND_MSG_PUB.count_and_get

3564: SQLERRM
3565: );
3566: END IF;
3567:
3568: FND_MSG_PUB.count_and_get
3569: (
3570: p_count => x_msg_count,
3571: p_data => x_msg_data
3572: );

Line 3596: FND_MSG_PUB.Initialize;

3592:
3593: BEGIN
3594:
3595: -- clear all previous messages.
3596: FND_MSG_PUB.Initialize;
3597:
3598: -- Attach the AW space read write.
3599: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3600: fnd_log.string

Line 3676: FND_MSG_PUB.count_and_get

3672: SQLERRM
3673: );
3674: END IF;
3675:
3676: FND_MSG_PUB.count_and_get
3677: (
3678: p_count => x_msg_count,
3679: p_data => x_msg_data
3680: );

Line 3704: FND_MSG_PUB.Initialize;

3700: l_api_version CONSTANT NUMBER := 1.0;
3701:
3702: BEGIN
3703:
3704: FND_MSG_PUB.Initialize;
3705:
3706: l_investment_rec.strategic_obj_shortname := p_strategic_obj_id;
3707: l_investment_rec.strategic_obj_name := p_strategic_obj_name;
3708: l_investment_rec.strategic_obj_desc := p_strategic_obj_desc;

Line 3746: FND_MSG_PUB.Count_And_Get

3742: EXCEPTION
3743: WHEN OTHERS THEN
3744: ROLLBACK;
3745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3746: FND_MSG_PUB.Count_And_Get
3747: (
3748: p_count => x_msg_count,
3749: p_data => x_msg_data
3750: );

Line 3775: FND_MSG_PUB.Initialize;

3771:
3772: BEGIN
3773:
3774: -- clear all previous messages.
3775: FND_MSG_PUB.Initialize;
3776:
3777:
3778: -- investment_rec.strategic_obj_shortname := 'STROBJ' || l_seq_nextval;
3779: l_investment_rec.strategic_obj_name := p_strategic_obj_name;

Line 3862: FND_MSG_PUB.Count_And_Get

3858: x_msg_data => x_msg_data
3859: );
3860: ROLLBACK;
3861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3862: FND_MSG_PUB.Count_And_Get
3863: (
3864: p_count => x_msg_count,
3865: p_data => x_msg_data
3866: );

Line 3884: FND_MSG_PUB.Initialize;

3880: l_investment_rec fpa_investment_criteria_pvt.investment_rec_type;
3881: l_api_version CONSTANT NUMBER := 1.0;
3882:
3883: BEGIN
3884: FND_MSG_PUB.Initialize;
3885:
3886: l_investment_rec.strategic_obj_shortname := p_strategic_obj_shortname;
3887:
3888: -- Attach the AW space read write.

Line 3945: FND_MSG_PUB.count_and_get

3941: SQLERRM
3942: );
3943: END IF;
3944:
3945: FND_MSG_PUB.count_and_get
3946: (
3947: p_count => x_msg_count,
3948: p_data => x_msg_data
3949: );

Line 3992: FND_MSG_PUB.Initialize;

3988:
3989: begin
3990:
3991: -- clear all previous messages.
3992: FND_MSG_PUB.Initialize;
3993:
3994:
3995: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3996: FND_LOG.String

Line 4027: FND_MSG_PUB.ADD;

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:
4031: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 4295: FND_MSG_PUB.Count_And_Get

4291: EXCEPTION
4292: WHEN FND_API.G_EXC_ERROR THEN
4293: ROLLBACK;
4294: x_return_status := FND_API.G_RET_STS_ERROR;
4295: FND_MSG_PUB.Count_And_Get
4296: (
4297: p_count => x_msg_count,
4298: p_data => x_msg_data
4299: );

Line 4319: FND_MSG_PUB.count_and_get

4315: 'fpa.sql.FPA_Process_Pvt.create_scenario',
4316: SQLERRM
4317: );
4318: END IF;
4319: FND_MSG_PUB.count_and_get
4320: (
4321: p_count => x_msg_count,
4322: p_data => x_msg_data
4323: );

Line 4348: FND_MSG_PUB.Initialize;

4344: l_approved_flag VARCHAR2(3);
4345: begin
4346:
4347: -- clear all previous messages.
4348: FND_MSG_PUB.Initialize;
4349:
4350: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4351: FND_LOG.String
4352: (

Line 4499: FND_MSG_PUB.Count_And_Get

4495: EXCEPTION
4496: WHEN FND_API.G_EXC_ERROR THEN
4497: ROLLBACK;
4498: x_return_status := FND_API.G_RET_STS_ERROR;
4499: FND_MSG_PUB.Count_And_Get
4500: (
4501: p_count => x_msg_count,
4502: p_data => x_msg_data
4503: );

Line 4523: FND_MSG_PUB.count_and_get

4519: 'fpa.sql.FPA_Process_Pvt.set_scenario_action_flag',
4520: SQLERRM
4521: );
4522: END IF;
4523: FND_MSG_PUB.count_and_get
4524: (
4525: p_count => x_msg_count,
4526: p_data => x_msg_data
4527: );

Line 4548: FND_MSG_PUB.Initialize;

4544:
4545: begin
4546:
4547: -- clear all previous messages.
4548: FND_MSG_PUB.Initialize;
4549:
4550:
4551: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4552: FND_LOG.String

Line 4678: FND_MSG_PUB.Count_And_Get

4674: EXCEPTION
4675: WHEN FND_API.G_EXC_ERROR THEN
4676: ROLLBACK;
4677: x_return_status := FND_API.G_RET_STS_ERROR;
4678: FND_MSG_PUB.Count_And_Get
4679: (
4680: p_count => x_msg_count,
4681: p_data => x_msg_data
4682: );

Line 4702: FND_MSG_PUB.count_and_get

4698: 'fpa.sql.FPA_Process_Pvt.update_scenario_reccom_status',
4699: SQLERRM
4700: );
4701: END IF;
4702: FND_MSG_PUB.count_and_get
4703: (
4704: p_count => x_msg_count,
4705: p_data => x_msg_data
4706: );

Line 5006: FND_MSG_PUB.Initialize;

5002:
5003: begin
5004:
5005: -- clear all previous messages.
5006: FND_MSG_PUB.Initialize;
5007:
5008: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5009: fnd_log.string
5010: (

Line 5092: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

5088: (FND_LOG.LEVEL_ERROR,
5089: 'fpa_process_pvt.create_portfolio',
5090: SQLERRM);
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');

Line 5099: FND_MSG_PUB.ADD;

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,
5103: x_return_status => x_return_status,

Line 5115: FND_MSG_PUB.count_and_get

5111: ( FND_LOG.LEVEL_ERROR,
5112: 'fpa_process_pvt.Close_Pc',
5113: SQLERRM);
5114: END IF;
5115: FND_MSG_PUB.count_and_get
5116: ( p_count => x_msg_count,
5117: p_data => x_msg_data);
5118:
5119: end Close_Pc;

Line 5137: FND_MSG_PUB.Initialize;

5133: IS
5134: BEGIN
5135:
5136: -- clear all previous messages.
5137: FND_MSG_PUB.Initialize;
5138:
5139: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5140: FND_LOG.String
5141: (

Line 5197: FND_MSG_PUB.ADD;

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
5201: (

Line 5219: FND_MSG_PUB.count_and_get

5215: SQLERRM
5216: );
5217: END IF;
5218:
5219: FND_MSG_PUB.count_and_get
5220: (
5221: p_count => x_msg_count,
5222: p_data => x_msg_data
5223: );

Line 5292: fnd_msg_pub.add_exc_msg(p_pkg_name => 'FPA_PROCESS_PVT',

5288:
5289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5290:
5291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5292: fnd_msg_pub.add_exc_msg(p_pkg_name => 'FPA_PROCESS_PVT',
5293: p_procedure_name => 'UPDATE_PJT_PROJ_FUNDING_STATUS',
5294: p_error_text => SUBSTRB(SQLERRM,1,240));
5295:
5296:

Line 5308: fnd_msg_pub.add_exc_msg(p_pkg_name => 'FPA_PROCESS_PVT',

5304: IF p_commit = FND_API.G_TRUE THEN
5305: ROLLBACK;
5306: END IF;
5307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5308: fnd_msg_pub.add_exc_msg(p_pkg_name => 'FPA_PROCESS_PVT',
5309: p_procedure_name => 'UPDATE_PJT_PROJ_FUNDING_STATUS',
5310: p_error_text => SUBSTRB(SQLERRM,1,240));
5311:
5312: RAISE;