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_VALIDATION_PROCESS_PVT dependencies on FPA_VALIDATION_PROCESS_PVT

Line 1: package body FPA_VALIDATION_PROCESS_PVT as

1: package body FPA_VALIDATION_PROCESS_PVT as
2: /* $Header: FPAVVLPB.pls 120.16 2011/08/09 01:17:31 skkoppul noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'FPA_VALIDATION_PROCESS_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := FPA_UTILITIES_PVT.G_APP_NAME;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'FPA_VALIDATION_PROCESS_PVT';

1: package body FPA_VALIDATION_PROCESS_PVT as
2: /* $Header: FPAVVLPB.pls 120.16 2011/08/09 01:17:31 skkoppul noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'FPA_VALIDATION_PROCESS_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := FPA_UTILITIES_PVT.G_APP_NAME;
6: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
7: L_API_NAME CONSTANT VARCHAR2(35) := 'VALIDATION_PROCESS';
8:

Line 508: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 1.begin',

504: BEGIN
505:
506: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
507: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
508: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 1.begin',
509: 'Entering FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 1.');
510: END IF;
511:
512: dbms_aw.execute('ALLSTAT');

Line 509: 'Entering FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 1.');

505:
506: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
507: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
508: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 1.begin',
509: 'Entering FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 1.');
510: END IF;
511:
512: dbms_aw.execute('ALLSTAT');
513: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

Line 670: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',

666: BEGIN
667:
668: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
669: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
670: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
671: 'Entering FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.begin');
672: END IF;
673:
674: l_type := p_type;

Line 671: 'Entering FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.begin');

667:
668: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
669: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
670: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
671: 'Entering FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.begin');
672: END IF;
673:
674: l_type := p_type;
675:

Line 689: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',

685: END IF;
686:
687: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
688: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
689: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
690: 'Querying FPA_VALIDATION_LINES to obtain current validation ID. Values are, scenario id: ' || l_scenario_id || ', Validation Type: ' || p_validation_set);
691: END IF;
692:
693: -- Bug Reference : 6006705

Line 727: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',

723: */
724:
725: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
726: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
727: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
728: 'Constructing dynamic SQL to query Budget Version information.');
729: END IF;
730:
731: l_sql_str := 'SELECT '

Line 744: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',

740: || 'AND P.PROJECT_ID = :1';
741:
742: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
743: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
744: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
745: 'Entering loop for insert or updates into FPA_VALIDATION_LINES. Operation to be performed is: ' || l_type);
746: END IF;
747:
748:

Line 759: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',

755: IF(l_type = 'CREATE') THEN
756:
757: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
758: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
759: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
760: 'Calling procedure Create_Proj_Budget_Versions.');
761: END IF;
762:
763: Create_Proj_Budget_Versions(

Line 779: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',

775: ELSIF(l_type = 'UPDATE') THEN
776:
777: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
778: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
779: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
780: 'Calling procedure Update_Proj_Budget_Versions.');
781: END IF;
782:
783: Update_Proj_Budget_Versions(

Line 799: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',

795: END IF;
796:
797: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
798: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
799: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
800: 'Checking return status inside loop for inserting creating FPA_VALIDATION_LINES.');
801: END IF;
802:
803: if (l_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then

Line 815: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',

811: END LOOP;
812:
813: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
814: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
815: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
816: 'Finished loop for inserting updating FPA_VALIDATION_LINES.');
817: END IF;
818:
819: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 821: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',

817: END IF;
818:
819: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
820: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
821: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
822: 'Calling FPA_UTILITIES_PVT.G_RET_STS_SUCCESS.');
823: END IF;
824:
825: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

Line 829: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',

825: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
826:
827: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
828: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
829: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.',
830: 'Calling FPA_UTILITIES_PVT.END_ACTIVITY.');
831: END IF;
832:
833: FPA_UTILITIES_PVT.END_ACTIVITY(

Line 842: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.end.',

838: x_msg_data => x_msg_data);
839:
840: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
841: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
842: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.end.',
843: 'Finishing FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.');
844: END IF;
845:
846:

Line 843: 'Finishing FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.');

839:
840: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
841: fnd_log.string ( FND_LOG.LEVEL_PROCEDURE,
842: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.end.',
843: 'Finishing FPA_VALIDATION_PROCESS_PVT.Budget_Version_Validations 2.');
844: END IF;
845:
846:
847: EXCEPTION

Line 1159: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Validate_Project_Refresh',

1155: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1156: FND_LOG.STRING
1157: (
1158: FND_LOG.LEVEL_PROCEDURE,
1159: 'fpa.sql.FPA_VALIDATION_PROCESS_PVT.Validate_Project_Refresh',
1160: 'processing project = '||p_projects_tbl(i)
1161: );
1162: END IF;
1163:

Line 1245: p_msg_log => 'Entering Fpa_Validation_Process_Pvt.Validate',

1241: p_init_msg_list => p_init_msg_list,
1242: l_api_version => l_api_version,
1243: p_api_version => p_api_version,
1244: p_api_type => G_API_TYPE,
1245: p_msg_log => 'Entering Fpa_Validation_Process_Pvt.Validate',
1246: x_return_status => x_return_status);
1247:
1248: if (x_return_status = FPA_UTILITIES_PVT.G_RET_STS_UNEXP_ERROR) then
1249: l_msg_log := 'start_activity';

Line 1365: END FPA_VALIDATION_PROCESS_PVT;

1361: END Object_Name;
1362:
1363:
1364:
1365: END FPA_VALIDATION_PROCESS_PVT;