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_API

Line 33: p_commit IN VARCHAR2 := FND_API.G_FALSE,

29: */
30:
31: PROCEDURE Create_Pc
32: ( p_api_version IN NUMBER,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_pc_all_obj IN fpa_pc_all_obj,
35: x_planning_cycle_id OUT NOCOPY NUMBER,
36: x_return_status OUT NOCOPY VARCHAR2,
37: x_msg_data OUT NOCOPY VARCHAR2,

Line 173: RAISE FND_API.G_EXC_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:
177: -- Initialize local pcInfo and other objects from the input pc_all object

Line 650: IF (p_commit = FND_API.G_TRUE) THEN

646: );
647: END IF;
648:
649: -- Update and commit our changes
650: IF (p_commit = FND_API.G_TRUE) THEN
651: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
652: FND_LOG.String
653: ( FND_LOG.LEVEL_PROCEDURE,
654: 'fpa.sql.FPA_Process_Pvt.Create_Pc',

Line 690: WHEN FND_API.G_EXC_ERROR THEN

686: );
687: END IF;
688:
689: EXCEPTION
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

Line 693: x_return_status := FND_API.G_RET_STS_ERROR;

689: EXCEPTION
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

Line 717: x_return_status := FND_API.G_RET_STS_ERROR;

713: x_msg_data => x_msg_data
714: );
715:
716: ROLLBACK;
717: x_return_status := FND_API.G_RET_STS_ERROR;
718:
719: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
720: FND_LOG.String
721: (

Line 748: p_commit IN VARCHAR2 := FND_API.G_FALSE,

744:
745:
746: PROCEDURE Update_Pc
747: ( p_api_version IN NUMBER,
748: p_commit IN VARCHAR2 := FND_API.G_FALSE,
749: p_pc_all_obj IN fpa_pc_all_obj,
750: x_return_status OUT NOCOPY VARCHAR2,
751: x_msg_data OUT NOCOPY VARCHAR2,
752: x_msg_count OUT NOCOPY NUMBER )

Line 999: IF (p_commit = FND_API.G_TRUE) THEN

995: END IF;
996:
997:
998: -- Update and commit our changes
999: IF (p_commit = FND_API.G_TRUE) THEN
1000: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1001: FND_LOG.String
1002: (
1003: FND_LOG.LEVEL_PROCEDURE,

Line 1057: x_return_status := FND_API.G_RET_STS_ERROR;

1053: x_msg_count => x_msg_count,
1054: x_msg_data => x_msg_data
1055: );
1056:
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058:
1059: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1060: FND_LOG.String
1061: (

Line 1082: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1078: */
1079:
1080: PROCEDURE Set_Pc_Initiate
1081: ( p_api_version IN NUMBER,
1082: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1083: p_pc_id IN NUMBER,
1084: p_pc_name IN VARCHAR2,
1085: p_pc_desc IN VARCHAR2,
1086: p_sub_due_date IN DATE,

Line 1162: p_commit => FND_API.G_TRUE,

1158: END IF;
1159: fpa_utils_pvt.load_gl_calendar
1160: (
1161: p_api_version => 1.0,
1162: p_commit => FND_API.G_TRUE,
1163: p_calendar_name => l_cal_name,
1164: p_period_type => l_period_type,
1165: p_cal_period_type => l_cal_period_type,
1166: x_return_status => x_return_status,

Line 1249: IF (p_commit = FND_API.G_TRUE) THEN

1245: x_msg_count => x_msg_count
1246: );
1247:
1248: -- Update and commit our changes
1249: IF (p_commit = FND_API.G_TRUE) THEN
1250: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1251: FND_LOG.String
1252: (
1253: FND_LOG.LEVEL_PROCEDURE,

Line 1306: x_return_status := FND_API.G_RET_STS_ERROR;

1302: x_msg_count => x_msg_count,
1303: x_msg_data => x_msg_data
1304: );
1305:
1306: x_return_status := FND_API.G_RET_STS_ERROR;
1307:
1308: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1309: FND_LOG.String
1310: (

Line 1331: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1327: */
1328:
1329: PROCEDURE Pa_Dist_List_Items_Delete_Row (
1330: p_api_version IN NUMBER,
1331: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1332: P_LIST_ITEM_ID IN NUMBER,
1333: x_return_status OUT NOCOPY VARCHAR2,
1334: x_msg_data OUT NOCOPY VARCHAR2,
1335: x_msg_count OUT NOCOPY NUMBER )

Line 1354: IF (p_commit = FND_API.G_TRUE) THEN

1350: P_LIST_ITEM_ID => P_LIST_ITEM_ID
1351: );
1352:
1353: -- Update and commit our changes
1354: IF (p_commit = FND_API.G_TRUE) THEN
1355: COMMIT;
1356: END IF;
1357:
1358:

Line 1378: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1380: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1381: FND_LOG.String
1382: (

Line 1406: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1402:
1403: PROCEDURE Create_Portfolio
1404: (
1405: p_api_version IN NUMBER,
1406: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1407: p_portfolio_obj IN FPA_PORTFO_ALL_OBJ,
1408: x_portfolio_id OUT NOCOPY VARCHAR2,
1409: x_return_status OUT NOCOPY VARCHAR2,
1410: x_msg_data OUT NOCOPY VARCHAR2,

Line 1454: RAISE FND_API.G_EXC_ERROR;

1450: 'Duplicate Portfolio Name'
1451: );
1452: END IF;
1453: --RAISE known exception
1454: RAISE FND_API.G_EXC_ERROR;
1455: END IF;
1456:
1457:
1458: -- Attach the AW space read write.

Line 1538: IF (p_commit = FND_API.G_TRUE) THEN

1534:
1535: END IF;
1536:
1537: --Update and commit our changes
1538: IF (p_commit = FND_API.G_TRUE) THEN
1539: dbms_aw.execute('UPDATE');
1540: COMMIT;
1541: END IF;
1542:

Line 1576: x_return_status := FND_API.G_RET_STS_ERROR;

1572: WHEN FPA_UTILITIES_PVT.G_EXCEPTION_ERROR THEN
1573:
1574: ROLLBACK;
1575:
1576: x_return_status := FND_API.G_RET_STS_ERROR;
1577: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1578: fnd_log.string
1579: (
1580: FND_LOG.LEVEL_ERROR,

Line 1589: WHEN FND_API.G_EXC_ERROR THEN

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:
1591: ROLLBACK;
1592:
1593: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1593: x_return_status := FND_API.G_RET_STS_ERROR;

1589: WHEN FND_API.G_EXC_ERROR THEN
1590:
1591: ROLLBACK;
1592:
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1595: fnd_log.string
1596: (
1597: FND_LOG.LEVEL_ERROR,

Line 1622: x_return_status := FND_API.G_RET_STS_ERROR;

1618: x_msg_data => x_msg_data
1619: );
1620:
1621: ROLLBACK;
1622: x_return_status := FND_API.G_RET_STS_ERROR;
1623:
1624: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1625: fnd_log.string
1626: (

Line 1648: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1644:
1645: PROCEDURE Delete_Portfolio
1646: (
1647: p_api_version IN NUMBER,
1648: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1649: p_portfolio_id IN NUMBER,
1650: x_return_status OUT NOCOPY VARCHAR2,
1651: x_msg_data OUT NOCOPY VARCHAR2,
1652: x_msg_count OUT NOCOPY NUMBER

Line 1696: IF (p_commit = FND_API.G_TRUE) THEN

1692: );
1693:
1694:
1695: --Update and commit our changes
1696: IF (p_commit = FND_API.G_TRUE) THEN
1697: dbms_aw.execute('UPDATE');
1698: COMMIT;
1699: END IF;
1700:

Line 1747: x_return_status := FND_API.G_RET_STS_ERROR;

1743: x_msg_data => x_msg_data
1744: );
1745:
1746: ROLLBACK;
1747: x_return_status := FND_API.G_RET_STS_ERROR;
1748:
1749: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1750: fnd_log.string
1751: (

Line 1778: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1774:
1775: PROCEDURE Update_Portfolio
1776: (
1777: p_api_version IN NUMBER,
1778: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1779: p_portfolio_obj IN FPA_PORTFO_ALL_OBJ,
1780: x_return_status OUT NOCOPY VARCHAR2,
1781: x_msg_data OUT NOCOPY VARCHAR2,
1782: x_msg_count OUT NOCOPY NUMBER

Line 1823: RAISE FND_API.G_EXC_ERROR;

1819: 'Duplicate Portfolio Name'
1820: );
1821: END IF;
1822: --raise the known duplicate exception
1823: RAISE FND_API.G_EXC_ERROR;
1824: END IF;
1825:
1826:
1827: -- Attach the AW space read write.

Line 1903: IF (p_commit = FND_API.G_TRUE) THEN

1899: );
1900: END IF ;
1901:
1902: --Update and commit our changes
1903: IF (p_commit = FND_API.G_TRUE) THEN
1904: dbms_aw.execute('UPDATE');
1905: COMMIT;
1906: END IF;
1907:

Line 1936: WHEN FND_API.G_EXC_ERROR THEN

1932: );
1933: END IF;
1934:
1935: EXCEPTION
1936: WHEN FND_API.G_EXC_ERROR THEN
1937: ROLLBACK;
1938:
1939:
1940: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1940: x_return_status := FND_API.G_RET_STS_ERROR;

1936: WHEN FND_API.G_EXC_ERROR THEN
1937: ROLLBACK;
1938:
1939:
1940: x_return_status := FND_API.G_RET_STS_ERROR;
1941: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1942: fnd_log.string
1943: (
1944: FND_LOG.LEVEL_ERROR,

Line 1972: x_return_status := FND_API.G_RET_STS_ERROR;

1968: x_msg_data => x_msg_data
1969: );
1970:
1971: ROLLBACK;
1972: x_return_status := FND_API.G_RET_STS_ERROR;
1973:
1974: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1975: fnd_log.string
1976: (

Line 2001: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1997:
1998: PROCEDURE delete_Portfolio_user
1999: (
2000: p_api_version IN NUMBER,
2001: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2002: p_project_party_id IN NUMBER,
2003: x_return_status OUT NOCOPY VARCHAR2,
2004: x_msg_data OUT NOCOPY VARCHAR2,
2005: x_msg_count OUT NOCOPY NUMBER

Line 2040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2036: );
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

Line 2046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2042: (
2043: p_count => x_msg_count,
2044: p_data => x_msg_data
2045: );
2046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2047: END;
2048: END IF;
2049:
2050: EXCEPTION

Line 2067: x_return_status := FND_API.G_RET_STS_ERROR;

2063: x_msg_data => x_msg_data
2064: );
2065:
2066: ROLLBACK;
2067: x_return_status := FND_API.G_RET_STS_ERROR;
2068: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2069: fnd_log.string
2070: (
2071: FND_LOG.LEVEL_ERROR,

Line 2217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2213: (
2214: p_count => x_msg_count,
2215: p_data => x_msg_data
2216: );
2217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2218: END;
2219: END IF;
2220: */
2221: END;

Line 2282: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2278:
2279:
2280: PROCEDURE Collect_Projects
2281: ( p_api_version IN NUMBER,
2282: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2283: p_pc_id IN NUMBER,
2284: x_return_status OUT NOCOPY VARCHAR2,
2285: x_msg_data OUT NOCOPY VARCHAR2,
2286: x_msg_count OUT NOCOPY NUMBER

Line 2419: IF (p_commit = FND_API.G_TRUE) THEN

2415: -- The Procedure call to move workflow to the next node
2416:
2417:
2418: -- Update and commit our changes
2419: IF (p_commit = FND_API.G_TRUE) THEN
2420: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2421: FND_LOG.STRING
2422: (
2423: FND_LOG.LEVEL_PROCEDURE,

Line 2473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2469: x_msg_count => x_msg_count,
2470: x_msg_data => x_msg_data
2471: );
2472:
2473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2474:
2475: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2476: FND_LOG.STRING
2477: (

Line 2624: p_commit => FND_API.G_TRUE,

2620: FPA_PROCESS_PVT.load_project_details_aw
2621: (
2622: p_api_version => 1.0,
2623: p_init_msg_list => 'F',
2624: p_commit => FND_API.G_TRUE,
2625: p_type => 'ADD',
2626: p_scenario_id => l_init_scenario_id,
2627: p_projects => p_proj_id_str,
2628: x_return_status => x_return_status,

Line 2800: p_init_msg_list => FND_API.G_FALSE,

2796:
2797: /* fpa_scorecards_pvt.Calc_Scenario_Wscores_Aw
2798: (
2799: p_api_version => 1.0,
2800: p_init_msg_list => FND_API.G_FALSE,
2801: p_scenario_id => l_init_scenario_id,
2802: x_return_status => x_return_status,
2803: x_msg_count => x_msg_count,
2804: x_msg_data => x_msg_data

Line 2858: p_commit => FND_API.G_FALSE,

2854:
2855: FPA_SCENARIO_PVT.copy_sce_project_Data
2856: (
2857: p_api_version => l_api_version,
2858: p_commit => FND_API.G_FALSE,
2859: p_target_scen_id => p_scenario_id,
2860: p_project_id_str => p_proj_id_str,
2861: x_return_status => x_return_status,
2862: x_msg_data => x_msg_data,

Line 2966: p_init_msg_list => FND_API.G_TRUE,

2962: END IF;
2963:
2964: FPA_SCORECARDS_PVT.Handle_Comments(
2965: p_api_version => p_api_version,
2966: p_init_msg_list => FND_API.G_TRUE,
2967: p_scenario_id => p_scenario_id,
2968: p_type => 'PJP',
2969: p_source_scenario_id => null,
2970: p_delete_project_id => null,

Line 3011: IF (p_commit = FND_API.G_TRUE) THEN

3007:
3008:
3009: -- Update and commit our changes
3010:
3011: IF (p_commit = FND_API.G_TRUE) THEN
3012: dbms_aw.execute('UPDATE');
3013: COMMIT;
3014: END IF;
3015:

Line 3047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3043: x_msg_count => x_msg_count,
3044: x_msg_data => x_msg_data
3045: );
3046:
3047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3048:
3049: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3050: FND_LOG.STRING
3051: (

Line 3143: p_commit => FND_API.G_TRUE,

3139: FPA_PROCESS_PVT.load_project_details_aw
3140: (
3141: p_api_version => 1.0,
3142: p_init_msg_list => 'F',
3143: p_commit => FND_API.G_TRUE,
3144: p_type => 'REFRESH',
3145: p_scenario_id => p_scenario_id,
3146: p_projects => p_proj_id_str,
3147: x_return_status => x_return_status,

Line 3288: IF (p_commit = FND_API.G_TRUE) THEN

3284:
3285:
3286: -- Update and commit our changes
3287:
3288: IF (p_commit = FND_API.G_TRUE) THEN
3289: dbms_aw.execute('UPDATE');
3290: COMMIT;
3291: END IF;
3292:

Line 3346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3342: x_msg_count => x_msg_count,
3343: x_msg_data => x_msg_data
3344: );
3345:
3346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3347:
3348: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3349: FND_LOG.STRING
3350: (

Line 3431: p_commit => FND_API.G_FALSE,

3427: -- API to set scenario_project_m all other project measures to na
3428: FPA_SCENARIO_PVT.remove_project_from_scenario
3429: (
3430: p_api_version => l_api_version,
3431: p_commit => FND_API.G_FALSE,
3432: p_scenario_id => p_scenario_id,
3433: p_project_id => p_proj_id,
3434: x_return_status => x_return_status,
3435: x_msg_data => x_msg_data,

Line 3452: p_init_msg_list => FND_API.G_TRUE,

3448:
3449:
3450: FPA_SCORECARDS_PVT.Handle_Comments(
3451: p_api_version => p_api_version,
3452: p_init_msg_list => FND_API.G_TRUE,
3453: p_scenario_id => p_scenario_id,
3454: p_type => null,
3455: p_source_scenario_id => null,
3456: p_delete_project_id => p_proj_id,

Line 3521: IF (p_commit = FND_API.G_TRUE) THEN

3517: );
3518: END IF;
3519:
3520: -- Update and commit our changes
3521: IF (p_commit = FND_API.G_TRUE) THEN
3522: dbms_aw.execute('UPDATE');
3523: COMMIT;
3524: END IF;
3525:

Line 3557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3553: x_msg_count => x_msg_count,
3554: x_msg_data => x_msg_data
3555: );
3556:
3557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3558:
3559: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3560: FND_LOG.STRING
3561: (

Line 3582: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

3578: /************************************************************************************/
3579:
3580: PROCEDURE update_strategicobj_weight
3581: ( p_api_version IN NUMBER
3582: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3583: ,p_strategic_weights_string IN varchar2
3584: ,x_return_status OUT NOCOPY varchar2
3585: ,x_msg_count OUT NOCOPY number
3586: ,x_msg_data OUT NOCOPY varchar2

Line 3639: IF (p_commit = FND_API.G_TRUE) THEN

3635: );
3636: END IF;
3637:
3638: -- Update and commit our changes
3639: IF (p_commit = FND_API.G_TRUE) THEN
3640: dbms_aw.execute('UPDATE');
3641: COMMIT;
3642: END IF;
3643:

Line 3665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3661: x_msg_count => x_msg_count,
3662: x_msg_data => x_msg_data
3663: );
3664:
3665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3666:
3667: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3668: FND_LOG.String
3669: (

Line 3689: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3685: /************************************************************************************/
3686:
3687: PROCEDURE update_strategicobj
3688: ( p_api_version IN NUMBER,
3689: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3690: p_strategic_obj_id IN NUMBER,
3691: p_strategic_obj_name IN VARCHAR2,
3692: p_strategic_obj_desc IN VARCHAR2,
3693: x_return_status OUT NOCOPY VARCHAR2,

Line 3731: IF (p_commit = FND_API.G_TRUE) THEN

3727: ,x_msg_count => x_msg_count
3728: ,x_msg_data => x_msg_data);
3729:
3730: -- Update and commit our changes
3731: IF (p_commit = FND_API.G_TRUE) THEN
3732: dbms_aw.execute('UPDATE');
3733: COMMIT;
3734: END IF;
3735:

Line 3745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3741:
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

Line 3757: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3753: END update_strategicobj;
3754:
3755: PROCEDURE create_strategicobj
3756: ( p_api_version IN NUMBER,
3757: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3758: p_strategic_obj_name IN VARCHAR2,
3759: p_strategic_obj_desc IN VARCHAR2,
3760: p_strategic_obj_parent IN VARCHAR2,
3761: p_strategic_obj_level IN varchar2,

Line 3807: p_commit => FND_API.G_TRUE,

3803:
3804: -- Call procedure to call Investment Criteria in AW
3805: fpa_investment_criteria_pvt.create_strategicobj_aw
3806: (
3807: p_commit => FND_API.G_TRUE,
3808: p_investment_rec_type => l_investment_rec,
3809: p_seeding => 'N',
3810: x_strategic_obj_id => l_stategic_obj_id,
3811: x_return_status => x_return_status,

Line 3822: p_commit => FND_API.G_TRUE,

3818: -- may be deleted by the user.
3819: l_investment_rec.strategic_obj_status := 'DODELETE';
3820: l_investment_rec.strategic_obj_shortname := l_stategic_obj_id;
3821: FPA_Investment_Criteria_PVT.Update_StrategicObj_Status_AW(
3822: p_commit => FND_API.G_TRUE,
3823: p_investment_rec_type => l_investment_rec,
3824: x_return_status => x_return_status,
3825: x_msg_count => x_msg_count,
3826: x_msg_data => x_msg_data

Line 3836: IF (p_commit = FND_API.G_TRUE) THEN

3832: ,x_msg_count
3833: ,x_msg_data);
3834:
3835: -- Update and commit our changes
3836: IF (p_commit = FND_API.G_TRUE) THEN
3837: dbms_aw.execute('UPDATE');
3838: COMMIT;
3839: END IF;
3840:

Line 3861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3857: x_msg_count => x_msg_count,
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

Line 3873: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3869: END create_strategicobj;
3870:
3871: PROCEDURE delete_strategicobj
3872: ( p_api_version IN NUMBER,
3873: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3874: p_strategic_obj_shortname IN VARCHAR2,
3875: x_return_status OUT NOCOPY VARCHAR2,
3876: x_msg_count OUT NOCOPY NUMBER,
3877: x_msg_data OUT NOCOPY VARCHAR2

Line 3911: IF (p_commit = FND_API.G_TRUE) THEN

3907: x_msg_data => x_msg_data
3908: );
3909:
3910: -- Update and commit our changes
3911: IF (p_commit = FND_API.G_TRUE) THEN
3912: dbms_aw.execute('UPDATE');
3913: COMMIT;
3914: END IF;
3915:

Line 3934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3930: x_msg_count => x_msg_count,
3931: x_msg_data => x_msg_data
3932: );
3933:
3934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3935:
3936: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3937: FND_LOG.String
3938: (

Line 3965: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3961: -- If the scenario source id is null then we are creating the initial scenario.
3962:
3963: PROCEDURE create_scenario
3964: (
3965: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3966: p_api_version IN NUMBER,
3967: p_scenario_id_source IN NUMBER,
3968: p_pc_id IN NUMBER,
3969: p_scenario_name IN VARCHAR2,

Line 4028: RAISE FND_API.G_EXC_ERROR;

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
4032: FND_LOG.String

Line 4211: p_init_msg_list => FND_API.G_TRUE,

4207:
4208:
4209: FPA_SCORECARDS_PVT.Handle_Comments(
4210: p_api_version => 1.0,
4211: p_init_msg_list => FND_API.G_TRUE,
4212: p_scenario_id => x_scenario_id,
4213: p_type => 'PJP',
4214: p_source_scenario_id => p_scenario_id_source,
4215: p_delete_project_id => null,

Line 4268: IF (p_commit = FND_API.G_TRUE) THEN

4264: );
4265: end if;
4266:
4267: -- Update and commit our changes
4268: IF (p_commit = FND_API.G_TRUE) THEN
4269: dbms_aw.execute('UPDATE');
4270: COMMIT;
4271: END IF;
4272:

Line 4292: WHEN FND_API.G_EXC_ERROR THEN

4288: x_msg_data => x_msg_data
4289: );
4290:
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: (

Line 4294: x_return_status := FND_API.G_RET_STS_ERROR;

4290:
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

Line 4310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4306: x_msg_count => x_msg_count,
4307: x_msg_data => x_msg_data
4308: );
4309: ROLLBACK;
4310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4311: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4312: FND_LOG.String
4313: (
4314: FND_LOG.LEVEL_ERROR,

Line 4333: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4329: -- This procedure sets the flag for the Initial Scenario, for the Working Scenario,
4330: -- For Recommending a scenario, and for Unrecommending a scenario..
4331: procedure set_scenario_action_flag
4332: (
4333: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4334: p_api_version IN NUMBER,
4335: p_scenario_id IN NUMBER,
4336: p_scenario_action IN VARCHAR2,
4337: x_return_status OUT NOCOPY VARCHAR2,

Line 4472: IF (p_commit = FND_API.G_TRUE) THEN

4468: );
4469: END IF;
4470:
4471: -- Update and commit our changes
4472: IF (p_commit = FND_API.G_TRUE) THEN
4473: dbms_aw.execute('UPDATE');
4474: COMMIT;
4475: END IF;
4476:

Line 4496: WHEN FND_API.G_EXC_ERROR THEN

4492: x_msg_data => x_msg_data
4493: );
4494:
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: (

Line 4498: x_return_status := FND_API.G_RET_STS_ERROR;

4494:
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

Line 4514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4510: x_msg_count => x_msg_count,
4511: x_msg_data => x_msg_data
4512: );
4513: ROLLBACK;
4514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4515: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4516: FND_LOG.String
4517: (
4518: FND_LOG.LEVEL_ERROR,

Line 4533: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4529: end set_scenario_action_flag;
4530:
4531: procedure update_scenario_reccom_status
4532: (
4533: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4534: p_api_version IN NUMBER,
4535: p_scenario_id IN NUMBER,
4536: p_project_id IN VARCHAR2,
4537: p_scenario_reccom_value IN VARCHAR2,

Line 4651: IF (p_commit = FND_API.G_TRUE) THEN

4647: );
4648: END IF;
4649:
4650: -- Update and commit our changes
4651: IF (p_commit = FND_API.G_TRUE) THEN
4652: dbms_aw.execute('UPDATE');
4653: COMMIT;
4654: END IF;
4655:

Line 4675: WHEN FND_API.G_EXC_ERROR THEN

4671: x_msg_data => x_msg_data
4672: );
4673:
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: (

Line 4677: x_return_status := FND_API.G_RET_STS_ERROR;

4673:
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

Line 4693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4689: x_msg_count => x_msg_count,
4690: x_msg_data => x_msg_data
4691: );
4692: ROLLBACK;
4693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4694: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4695: FND_LOG.String
4696: (
4697: FND_LOG.LEVEL_ERROR,

Line 4853: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4849:
4850: PROCEDURE Load_Project_Details_Aw
4851: (
4852: p_api_version IN NUMBER,
4853: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4854: p_commit IN VARCHAR2,
4855: p_type IN VARCHAR2,
4856: p_scenario_id IN NUMBER,
4857: p_projects IN VARCHAR2,

Line 4915: if (p_commit = FND_API.G_TRUE) then

4911: x_msg_count => x_msg_count,
4912: x_msg_data => x_msg_data);
4913:
4914:
4915: if (p_commit = FND_API.G_TRUE) then
4916: dbms_aw.execute('UPDATE');
4917: COMMIT;
4918: end if;
4919:

Line 4996: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4992:
4993: PROCEDURE Close_Pc
4994: (
4995: p_api_version IN NUMBER,
4996: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4997: p_pc_id IN NUMBER,
4998: x_return_status OUT NOCOPY VARCHAR2,
4999: x_msg_count OUT NOCOPY NUMBER,
5000: x_msg_data OUT NOCOPY VARCHAR2

Line 5044: IF (p_commit = FND_API.G_TRUE) THEN

5040: x_msg_data => x_msg_data
5041: );
5042:
5043: -- Update and commit our changes
5044: IF (p_commit = FND_API.G_TRUE) THEN
5045: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5046: FND_LOG.String
5047: ( FND_LOG.LEVEL_PROCEDURE,
5048: 'fpa.sql.FPA_Process_Pvt.Close_Pc',

Line 5083: WHEN FND_API.G_EXC_ERROR THEN

5079: );
5080: END IF;
5081:
5082: EXCEPTION
5083: WHEN FND_API.G_EXC_ERROR THEN
5084: ROLLBACK;
5085: x_return_status := FND_API.G_RET_STS_ERROR;
5086: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5087: fnd_log.string

Line 5085: x_return_status := FND_API.G_RET_STS_ERROR;

5081:
5082: EXCEPTION
5083: WHEN FND_API.G_EXC_ERROR THEN
5084: ROLLBACK;
5085: x_return_status := FND_API.G_RET_STS_ERROR;
5086: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5087: fnd_log.string
5088: (FND_LOG.LEVEL_ERROR,
5089: 'fpa_process_pvt.create_portfolio',

Line 5108: x_return_status := FND_API.G_RET_STS_ERROR;

5104: x_msg_count => x_msg_count,
5105: x_msg_data => x_msg_data
5106: );
5107: ROLLBACK;
5108: x_return_status := FND_API.G_RET_STS_ERROR;
5109: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5110: fnd_log.string
5111: ( FND_LOG.LEVEL_ERROR,
5112: 'fpa_process_pvt.Close_Pc',

Line 5128: p_commit IN VARCHAR2 := FND_API.G_FALSE,

5124: */
5125:
5126: PROCEDURE Update_Scen_Proj_User_Ranks
5127: ( p_api_version IN NUMBER,
5128: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5129: p_projs IN fpa_scen_proj_userrank_all_obj,
5130: x_return_status OUT NOCOPY VARCHAR2,
5131: x_msg_data OUT NOCOPY VARCHAR2,
5132: x_msg_count OUT NOCOPY NUMBER )

Line 5168: IF (p_commit = FND_API.G_TRUE) THEN

5164: x_msg_count => x_msg_count
5165: );
5166:
5167: -- Update and commit our changes
5168: IF (p_commit = FND_API.G_TRUE) THEN
5169: dbms_aw.execute('UPDATE');
5170: COMMIT;
5171: END IF;
5172:

Line 5208: x_return_status := FND_API.G_RET_STS_ERROR;

5204: x_msg_count => x_msg_count,
5205: x_msg_data => x_msg_data
5206: );
5207:
5208: x_return_status := FND_API.G_RET_STS_ERROR;
5209:
5210: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5211: FND_LOG.String
5212: (

Line 5249: x_return_status := FND_API.G_RET_STS_SUCCESS;

5245: 'Exiting FPA_Process_Pvt.update_pjt_proj_funding_status'
5246: );
5247: END IF;
5248:
5249: x_return_status := FND_API.G_RET_STS_SUCCESS;
5250:
5251: fpa_project_pvt.update_proj_funding_status
5252: (
5253: p_api_version => 1.0,

Line 5255: p_commit => FND_API.G_FALSE,

5251: fpa_project_pvt.update_proj_funding_status
5252: (
5253: p_api_version => 1.0,
5254: p_init_msg_list => p_init_msg_list,
5255: p_commit => FND_API.G_FALSE,
5256: p_appr_scenario_id => p_scenario_id,
5257: x_return_status => x_return_status,
5258: x_msg_count => x_msg_count,
5259: x_msg_data => x_msg_data

Line 5262: if x_return_status = FND_API.G_RET_STS_ERROR then

5258: x_msg_count => x_msg_count,
5259: x_msg_data => x_msg_data
5260: );
5261:
5262: if x_return_status = FND_API.G_RET_STS_ERROR then
5263: RAISE FND_API.G_EXC_ERROR;
5264: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: end if;

Line 5263: RAISE FND_API.G_EXC_ERROR;

5259: x_msg_data => x_msg_data
5260: );
5261:
5262: if x_return_status = FND_API.G_RET_STS_ERROR then
5263: RAISE FND_API.G_EXC_ERROR;
5264: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: end if;
5267:

Line 5264: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

5260: );
5261:
5262: if x_return_status = FND_API.G_RET_STS_ERROR then
5263: RAISE FND_API.G_EXC_ERROR;
5264: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: end if;
5267:
5268: IF p_commit = FND_API.G_TRUE THEN

Line 5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5261:
5262: if x_return_status = FND_API.G_RET_STS_ERROR then
5263: RAISE FND_API.G_EXC_ERROR;
5264: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: end if;
5267:
5268: IF p_commit = FND_API.G_TRUE THEN
5269: COMMIT;

Line 5268: IF p_commit = FND_API.G_TRUE THEN

5264: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
5265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5266: end if;
5267:
5268: IF p_commit = FND_API.G_TRUE THEN
5269: COMMIT;
5270: END IF;
5271:
5272: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 5283: when FND_API.G_EXC_ERROR then

5279: END IF;
5280:
5281:
5282: EXCEPTION
5283: when FND_API.G_EXC_ERROR then
5284: IF p_commit = FND_API.G_TRUE THEN
5285: ROLLBACK;
5286: END IF;
5287: x_return_status := 'E';

Line 5284: IF p_commit = FND_API.G_TRUE THEN

5280:
5281:
5282: EXCEPTION
5283: when FND_API.G_EXC_ERROR then
5284: IF p_commit = FND_API.G_TRUE THEN
5285: ROLLBACK;
5286: END IF;
5287: x_return_status := 'E';
5288:

Line 5289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5285: ROLLBACK;
5286: END IF;
5287: x_return_status := 'E';
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',

Line 5291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5287: x_return_status := 'E';
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:

Line 5297: IF p_commit = FND_API.G_TRUE THEN

5293: p_procedure_name => 'UPDATE_PJT_PROJ_FUNDING_STATUS',
5294: p_error_text => SUBSTRB(SQLERRM,1,240));
5295:
5296:
5297: IF p_commit = FND_API.G_TRUE THEN
5298: ROLLBACK;
5299: END IF;
5300:
5301: RAISE;

Line 5304: IF p_commit = FND_API.G_TRUE THEN

5300:
5301: RAISE;
5302:
5303: WHEN OTHERS THEN
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',

Line 5307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5303: WHEN OTHERS THEN
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:

Line 5375: if (l_active_pc_count > 0) and (FPA_PROJECT_PVT.valid_project(p_project_id) = FND_API.G_TRUE) then

5371: -- If an active planning cycle exists, set enabled flag to 'T'
5372: -- Score card link should be ebabled.
5373: open c_pc_active;
5374: fetch c_pc_active into l_active_pc_count;
5375: if (l_active_pc_count > 0) and (FPA_PROJECT_PVT.valid_project(p_project_id) = FND_API.G_TRUE) then
5376: -- active pl cycle exists for this project.
5377: -- Project classfications match the correct portfolio and planning cycle.
5378: l_enabled_flag := 'T';
5379: