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.CSC_PROFILE_VARIABLE_PVT dependencies on FND_API

Line 44: x_return_status := FND_API.G_RET_STS_SUCCESS;

40: IS
41: l_sql_stmnt VARCHAR2(2000);
42: BEGIN
43: -- initialize the return status
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45:
46: -- check if the select_clause and the from_Clause
47: -- is NULL or missing, if so we cannot form an
48: -- sql_statement.

Line 56: x_return_status := FND_API.G_RET_STS_ERROR;

52: ( p_from_Clause IS NULL ) and
53: ( p_from_Clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR )
54: THEN
55: -- invalid arguments exception
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg( p_api_name => p_api_name,
58: p_argument_value => p_select_clause||' '||p_from_clause,
59: p_argument => 'p_Sql_Stmnt'
60: );

Line 71: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

67: p_other_clause => p_OTHER_CLAUSE,
68: X_sql_Stmnt => X_SQL_STMNT,
69: X_return_status => x_return_status );
70:
71: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
74: p_api_name => p_api_name,
75: p_argument_value => p_select_clause||' '||p_from_clause,

Line 72: x_return_status := FND_API.G_RET_STS_ERROR;

68: X_sql_Stmnt => X_SQL_STMNT,
69: X_return_status => x_return_status );
70:
71: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
74: p_api_name => p_api_name,
75: p_argument_value => p_select_clause||' '||p_from_clause,
76: p_argument => 'P_SQL_STMNT'

Line 519: IF NOT FND_API.Compatible_API_Call(l_api_version,

515: -- Standard start of API savepoint
516: SAVEPOINT Create_Profile_Variable_PVT;
517:
518: -- Standard call to check for call compatibility
519: IF NOT FND_API.Compatible_API_Call(l_api_version,
520: p_api_version_number,
521: l_api_name,
522: G_PKG_NAME )
523: THEN

Line 524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

520: p_api_version_number,
521: l_api_name,
522: G_PKG_NAME )
523: THEN
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526:
527:
528: -- Initialize message list if p_init_msg_list is set to TRUE

Line 529: IF FND_API.To_Boolean(p_init_msg_list)

525: END IF;
526:
527:
528: -- Initialize message list if p_init_msg_list is set to TRUE
529: IF FND_API.To_Boolean(p_init_msg_list)
530: THEN
531: FND_MSG_PUB.Initialize;
532: END IF;
533:

Line 536: x_return_status := FND_API.G_RET_STS_SUCCESS;

532: END IF;
533:
534:
535: -- Initialize API return status to success
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538:
539: -- we have to build the sql statement in advance before
540: -- going into the validation part to validate the whole

Line 563: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

559: p_where_clause => l_prof_var_rec.where_clause,
560: p_other_clause => l_prof_var_rec.other_clause,
561: x_sql_stmnt => l_prof_var_rec.sql_stmnt,
562: x_return_status => x_return_status );
563: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
564: RAISE FND_API.G_EXC_ERROR;
565: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
567: END IF;

Line 564: RAISE FND_API.G_EXC_ERROR;

560: p_other_clause => l_prof_var_rec.other_clause,
561: x_sql_stmnt => l_prof_var_rec.sql_stmnt,
562: x_return_status => x_return_status );
563: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
564: RAISE FND_API.G_EXC_ERROR;
565: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
567: END IF;
568:

Line 565: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

561: x_sql_stmnt => l_prof_var_rec.sql_stmnt,
562: x_return_status => x_return_status );
563: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
564: RAISE FND_API.G_EXC_ERROR;
565: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
567: END IF;
568:
569:

Line 566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

562: x_return_status => x_return_status );
563: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
564: RAISE FND_API.G_EXC_ERROR;
565: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
567: END IF;
568:
569:
570: -- ----------------------------------------------------------------------

Line 588: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

584: x_return_status => x_return_status,
585: x_msg_count =>x_msg_count,
586: x_msg_data =>x_msg_data );
587:
588: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
589: RAISE FND_API.G_EXC_ERROR;
590: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
592: END IF;

Line 589: RAISE FND_API.G_EXC_ERROR;

585: x_msg_count =>x_msg_count,
586: x_msg_data =>x_msg_data );
587:
588: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
589: RAISE FND_API.G_EXC_ERROR;
590: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
592: END IF;
593:

Line 590: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

586: x_msg_data =>x_msg_data );
587:
588: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
589: RAISE FND_API.G_EXC_ERROR;
590: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
592: END IF;
593:
594: END IF ; /*** p_validation_level ****/

Line 591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

587:
588: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
589: RAISE FND_API.G_EXC_ERROR;
590: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
592: END IF;
593:
594: END IF ; /*** p_validation_level ****/
595:

Line 642: IF FND_API.To_Boolean(p_commit) THEN

638: );
639:
640: --
641: -- Standard check of p_commit
642: IF FND_API.To_Boolean(p_commit) THEN
643: COMMIT WORK;
644: END IF;
645:
646: -- Standard call to get message count and if count is 1, get message info

Line 649: p_encoded => FND_API.G_FALSE,

645:
646: -- Standard call to get message count and if count is 1, get message info
647:
648: FND_MSG_PUB.Count_And_Get(
649: p_encoded => FND_API.G_FALSE,
650: p_count => x_msg_count,
651: p_data => x_msg_data );
652:
653:

Line 655: WHEN FND_API.G_EXC_ERROR THEN

651: p_data => x_msg_data );
652:
653:
654: EXCEPTION
655: WHEN FND_API.G_EXC_ERROR THEN
656: ROLLBACK TO Create_Profile_Variable_PVT;
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: /* FND_MSG_PUB.Count_And_Get
659: ( p_encoded => FND_API.G_FALSE,

Line 657: x_return_status := FND_API.G_RET_STS_ERROR;

653:
654: EXCEPTION
655: WHEN FND_API.G_EXC_ERROR THEN
656: ROLLBACK TO Create_Profile_Variable_PVT;
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: /* FND_MSG_PUB.Count_And_Get
659: ( p_encoded => FND_API.G_FALSE,
660: p_count => x_msg_count,
661: p_data => x_msg_data

Line 659: ( p_encoded => FND_API.G_FALSE,

655: WHEN FND_API.G_EXC_ERROR THEN
656: ROLLBACK TO Create_Profile_Variable_PVT;
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: /* FND_MSG_PUB.Count_And_Get
659: ( p_encoded => FND_API.G_FALSE,
660: p_count => x_msg_count,
661: p_data => x_msg_data
662: ); */
663: APP_EXCEPTION.RAISE_EXCEPTION;

Line 664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

660: p_count => x_msg_count,
661: p_data => x_msg_data
662: ); */
663: APP_EXCEPTION.RAISE_EXCEPTION;
664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
665: ROLLBACK TO Create_Profile_Variable_PVT;
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: /* FND_MSG_PUB.Count_And_Get
668: ( p_encoded => FND_API.G_FALSE,

Line 666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

662: ); */
663: APP_EXCEPTION.RAISE_EXCEPTION;
664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
665: ROLLBACK TO Create_Profile_Variable_PVT;
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: /* FND_MSG_PUB.Count_And_Get
668: ( p_encoded => FND_API.G_FALSE,
669: p_count => x_msg_count,
670: p_data => x_msg_data

Line 668: ( p_encoded => FND_API.G_FALSE,

664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
665: ROLLBACK TO Create_Profile_Variable_PVT;
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: /* FND_MSG_PUB.Count_And_Get
668: ( p_encoded => FND_API.G_FALSE,
669: p_count => x_msg_count,
670: p_data => x_msg_data
671: ); */
672: APP_EXCEPTION.RAISE_EXCEPTION;

Line 675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

671: ); */
672: APP_EXCEPTION.RAISE_EXCEPTION;
673: WHEN OTHERS THEN
674: ROLLBACK TO Create_Profile_Variable_PVT;
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
677: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
678: -- END IF;
679: FND_MSG_PUB.Build_Exc_Msg;

Line 681: ( p_encoded => FND_API.G_FALSE,

677: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
678: -- END IF;
679: FND_MSG_PUB.Build_Exc_Msg;
680: /* FND_MSG_PUB.Count_And_Get
681: ( p_encoded => FND_API.G_FALSE,
682: p_count => x_msg_count,
683: p_data => x_msg_data
684: ); */
685: APP_EXCEPTION.RAISE_EXCEPTION;

Line 746: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

742: px_object_version_number => l_object_version_number,
743: p_block_id => l_table_column_rec.block_id,
744: p_sql_stmnt_for_drilldown => ltrim(rtrim(l_sql_stmnt_for_drilldown)));
745:
746: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
747: RAISE FND_API.G_EXC_ERROR;
748: END IF; */
749: END;
750:

Line 747: RAISE FND_API.G_EXC_ERROR;

743: p_block_id => l_table_column_rec.block_id,
744: p_sql_stmnt_for_drilldown => ltrim(rtrim(l_sql_stmnt_for_drilldown)));
745:
746: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
747: RAISE FND_API.G_EXC_ERROR;
748: END IF; */
749: END;
750:
751: PROCEDURE Create_table_column(

Line 775: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

771:
772:
773:
774: -- Standard call to check for call compatibility.
775: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
776: p_api_version_number,
777: l_api_name,
778: G_PKG_NAME)
779: THEN

Line 780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

776: p_api_version_number,
777: l_api_name,
778: G_PKG_NAME)
779: THEN
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: END IF;
782:
783: -- Initialize message list if p_init_msg_list is set to TRUE.
784: IF FND_API.to_Boolean( p_init_msg_list )

Line 784: IF FND_API.to_Boolean( p_init_msg_list )

780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: END IF;
782:
783: -- Initialize message list if p_init_msg_list is set to TRUE.
784: IF FND_API.to_Boolean( p_init_msg_list )
785: THEN
786: FND_MSG_PUB.initialize;
787: END IF;
788:

Line 790: x_return_status := FND_API.G_RET_STS_SUCCESS;

786: FND_MSG_PUB.initialize;
787: END IF;
788:
789: -- Initialize API return status to SUCCESS
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792: --
793: -- API body
794: --

Line 796: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

792: --
793: -- API body
794: --
795:
796: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
797: THEN
798:
799: -- Check for all the required attributes that are being passed should be there
800: -- and should not be passed as null. If passed as null then raise error

Line 810: IF (x_return_status<>FND_API.G_RET_STS_SUCCESS) THEN

806: p_Validate_Rec => l_Table_Column_Rec,
807: x_return_status => x_return_status);
808: END IF;
809:
810: IF (x_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
811: RAISE FND_API.G_EXC_ERROR;
812: END IF;
813:
814: -- Build an insert record, check if any of the parameters

Line 811: RAISE FND_API.G_EXC_ERROR;

807: x_return_status => x_return_status);
808: END IF;
809:
810: IF (x_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
811: RAISE FND_API.G_EXC_ERROR;
812: END IF;
813:
814: -- Build an insert record, check if any of the parameters
815: -- have been not been passed, if not assign a NULL.

Line 838: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

834: p_SEEDED_FLAG => l_Table_Column_rec.seeded_flag,
835: x_OBJECT_VERSION_NUMBER => x_object_version_number );
836:
837:
838: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
839: RAISE FND_API.G_EXC_ERROR;
840: END IF;
841:
842:

Line 839: RAISE FND_API.G_EXC_ERROR;

835: x_OBJECT_VERSION_NUMBER => x_object_version_number );
836:
837:
838: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
839: RAISE FND_API.G_EXC_ERROR;
840: END IF;
841:
842:
843: --

Line 849: IF FND_API.to_Boolean( p_commit )

845: --
846:
847:
848: -- Standard check for p_commit
849: IF FND_API.to_Boolean( p_commit )
850: THEN
851: COMMIT WORK;
852: END IF;
853:

Line 861: WHEN FND_API.G_EXC_ERROR THEN

857: p_count => x_msg_count,
858: p_data => x_msg_data);
859:
860: EXCEPTION
861: WHEN FND_API.G_EXC_ERROR THEN
862: ROLLBACK TO CREATE_Table_Column_PVT;
863: x_return_status := FND_API.G_RET_STS_ERROR ;
864: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
865: p_data => x_msg_data) ;

Line 863: x_return_status := FND_API.G_RET_STS_ERROR ;

859:
860: EXCEPTION
861: WHEN FND_API.G_EXC_ERROR THEN
862: ROLLBACK TO CREATE_Table_Column_PVT;
863: x_return_status := FND_API.G_RET_STS_ERROR ;
864: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
865: p_data => x_msg_data) ;
866: APP_EXCEPTION.RAISE_EXCEPTION;
867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

863: x_return_status := FND_API.G_RET_STS_ERROR ;
864: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
865: p_data => x_msg_data) ;
866: APP_EXCEPTION.RAISE_EXCEPTION;
867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
868: ROLLBACK TO CREATE_Table_Column_PVT;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
870: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
871: p_data => x_msg_data) ;

Line 869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

865: p_data => x_msg_data) ;
866: APP_EXCEPTION.RAISE_EXCEPTION;
867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
868: ROLLBACK TO CREATE_Table_Column_PVT;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
870: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
871: p_data => x_msg_data) ;
872: APP_EXCEPTION.RAISE_EXCEPTION;
873: WHEN OTHERS THEN

Line 875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

871: p_data => x_msg_data) ;
872: APP_EXCEPTION.RAISE_EXCEPTION;
873: WHEN OTHERS THEN
874: ROLLBACK TO CREATE_Table_Column_PVT;
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
876: --IF FND_MSG_PUB.Check_Msg_Level
877: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
878: --THEN
879: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 1019: IF NOT FND_API.Compatible_API_Call( l_api_version,

1015: -- standard start of API savepoint
1016: SAVEPOINT Update_Profile_Variable_Pvt ;
1017:
1018: -- Standard Call to check API compatibility
1019: IF NOT FND_API.Compatible_API_Call( l_api_version,
1020: p_api_version_number,
1021: l_api_name,
1022: G_PKG_NAME )
1023: THEN

Line 1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1020: p_api_version_number,
1021: l_api_name,
1022: G_PKG_NAME )
1023: THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1025: END IF ;
1026:
1027:
1028: -- Initialize the message list if p_msg_list is set to TRUE

Line 1029: IF FND_API.To_Boolean(p_init_msg_list) THEN

1025: END IF ;
1026:
1027:
1028: -- Initialize the message list if p_msg_list is set to TRUE
1029: IF FND_API.To_Boolean(p_init_msg_list) THEN
1030: FND_MSG_PUB.initialize ;
1031: END IF ;
1032:
1033:

Line 1035: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1031: END IF ;
1032:
1033:
1034: -- Initialize the API Return Success to True
1035: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1036:
1037: -- Fetch the existing Customer Profile Variable Record and lock the record
1038: -- for update.
1039: -- If lock fails we have to abort

Line 1048: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1044: p_object_version_number => px_object_version_number,
1045: X_PROF_BLOCKS_REC => l_OLD_PROF_VAR_REC,
1046: x_return_status => x_return_status );
1047: -- If any error abort the API
1048: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1049: RAISE FND_API.G_EXC_ERROR;
1050: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1052: END IF;

Line 1049: RAISE FND_API.G_EXC_ERROR;

1045: X_PROF_BLOCKS_REC => l_OLD_PROF_VAR_REC,
1046: x_return_status => x_return_status );
1047: -- If any error abort the API
1048: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1049: RAISE FND_API.G_EXC_ERROR;
1050: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1052: END IF;
1053:

Line 1050: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1046: x_return_status => x_return_status );
1047: -- If any error abort the API
1048: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1049: RAISE FND_API.G_EXC_ERROR;
1050: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1052: END IF;
1053:
1054:

Line 1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1047: -- If any error abort the API
1048: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1049: RAISE FND_API.G_EXC_ERROR;
1050: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1052: END IF;
1053:
1054:
1055: -- we have to build the sql statement in advance before

Line 1085: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1081: p_OTHER_CLAUSE => l_prof_var_rec.OTHER_CLAUSE,
1082: X_SQL_STMNT => l_prof_var_rec.SQL_STMNT,
1083: X_return_status => x_return_status );
1084:
1085: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1086: RAISE FND_API.G_EXC_ERROR;
1087: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;

Line 1086: RAISE FND_API.G_EXC_ERROR;

1082: X_SQL_STMNT => l_prof_var_rec.SQL_STMNT,
1083: X_return_status => x_return_status );
1084:
1085: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1086: RAISE FND_API.G_EXC_ERROR;
1087: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090: ELSE

Line 1087: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1083: X_return_status => x_return_status );
1084:
1085: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1086: RAISE FND_API.G_EXC_ERROR;
1087: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090: ELSE
1091: l_prof_var_rec.sql_stmnt := l_old_prof_var_rec.sql_stmnt;

Line 1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1084:
1085: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1086: RAISE FND_API.G_EXC_ERROR;
1087: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1089: END IF;
1090: ELSE
1091: l_prof_var_rec.sql_stmnt := l_old_prof_var_rec.sql_stmnt;
1092: END IF;

Line 1116: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1112: x_return_status => x_return_status,
1113: x_msg_count =>x_msg_count,
1114: x_msg_data =>x_msg_data );
1115:
1116: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1117: RAISE FND_API.G_EXC_ERROR;
1118: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END IF;

Line 1117: RAISE FND_API.G_EXC_ERROR;

1113: x_msg_count =>x_msg_count,
1114: x_msg_data =>x_msg_data );
1115:
1116: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1117: RAISE FND_API.G_EXC_ERROR;
1118: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END IF;
1121: END IF;

Line 1118: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1114: x_msg_data =>x_msg_data );
1115:
1116: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1117: RAISE FND_API.G_EXC_ERROR;
1118: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END IF;
1121: END IF;
1122:

Line 1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1115:
1116: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1117: RAISE FND_API.G_EXC_ERROR;
1118: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: END IF;
1121: END IF;
1122:
1123: -- Replace :party_id, cust_acct_id,cust_acct_org_id with

Line 1168: IF FND_API.To_Boolean(p_commit) THEN

1164: p_APPLICATION_ID => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.APPLICATION_ID,l_old_prof_var_rec.application_id));
1165:
1166:
1167: -- Standard check of p_commit
1168: IF FND_API.To_Boolean(p_commit) THEN
1169: COMMIT WORK;
1170: END IF;
1171:
1172: -- Standard call to get message count and if count is 1, get message info

Line 1177: WHEN FND_API.G_EXC_ERROR THEN

1173: FND_MSG_PUB.Count_And_Get(
1174: p_count => x_msg_count,
1175: p_data => x_msg_data );
1176: EXCEPTION
1177: WHEN FND_API.G_EXC_ERROR THEN
1178: ROLLBACK TO Update_Profile_Variable_Pvt;
1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180: --FND_MSG_PUB.Count_And_Get
1181: -- ( p_count => x_msg_count,

Line 1179: x_return_status := FND_API.G_RET_STS_ERROR;

1175: p_data => x_msg_data );
1176: EXCEPTION
1177: WHEN FND_API.G_EXC_ERROR THEN
1178: ROLLBACK TO Update_Profile_Variable_Pvt;
1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180: --FND_MSG_PUB.Count_And_Get
1181: -- ( p_count => x_msg_count,
1182: -- p_data => x_msg_data );
1183: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1180: --FND_MSG_PUB.Count_And_Get
1181: -- ( p_count => x_msg_count,
1182: -- p_data => x_msg_data );
1183: APP_EXCEPTION.RAISE_EXCEPTION;
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1185: ROLLBACK TO Update_Profile_Variable_Pvt;
1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1187: --FND_MSG_PUB.Count_And_Get
1188: -- ( p_count => x_msg_count,

Line 1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1182: -- p_data => x_msg_data );
1183: APP_EXCEPTION.RAISE_EXCEPTION;
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1185: ROLLBACK TO Update_Profile_Variable_Pvt;
1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1187: --FND_MSG_PUB.Count_And_Get
1188: -- ( p_count => x_msg_count,
1189: -- p_data => x_msg_data );
1190: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1189: -- p_data => x_msg_data );
1190: APP_EXCEPTION.RAISE_EXCEPTION;
1191: WHEN OTHERS THEN
1192: ROLLBACK TO Update_Profile_Variable_Pvt;
1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1194: -- FND_MSG_PUB.Count_And_Get
1195: -- ( p_count => x_msg_count,
1196: -- p_data => x_msg_data );
1197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1229: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1225: -- Standard Start of API savepoint
1226: SAVEPOINT UPDATE_Table_Column_PVT;
1227:
1228: -- Standard call to check for call compatibility.
1229: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1230: p_api_version_number,
1231: l_api_name,
1232: G_PKG_NAME)
1233: THEN

Line 1234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1230: p_api_version_number,
1231: l_api_name,
1232: G_PKG_NAME)
1233: THEN
1234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1235: END IF;
1236:
1237:
1238: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1239: IF FND_API.to_Boolean( p_init_msg_list )

1235: END IF;
1236:
1237:
1238: -- Initialize message list if p_init_msg_list is set to TRUE.
1239: IF FND_API.to_Boolean( p_init_msg_list )
1240: THEN
1241: FND_MSG_PUB.initialize;
1242: END IF;
1243:

Line 1246: x_return_status := FND_API.G_RET_STS_SUCCESS;

1242: END IF;
1243:
1244:
1245: -- Initialize API return status to SUCCESS
1246: x_return_status := FND_API.G_RET_STS_SUCCESS;
1247:
1248: --
1249: -- Api body
1250: --

Line 1259: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1255: p_Table_Column_Id => l_table_column_rec.table_column_id,
1256: p_object_version_number => px_object_version_number,
1257: X_Table_Column_Rec => l_old_table_column_rec,
1258: x_return_status => x_return_status);
1259: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1260: RAISE FND_API.G_EXC_ERROR;
1261: END IF;
1262:
1263: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)

Line 1260: RAISE FND_API.G_EXC_ERROR;

1256: p_object_version_number => px_object_version_number,
1257: X_Table_Column_Rec => l_old_table_column_rec,
1258: x_return_status => x_return_status);
1259: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1260: RAISE FND_API.G_EXC_ERROR;
1261: END IF;
1262:
1263: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
1264: THEN

Line 1272: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

1268: p_init_msg_list => p_init_msg_list,
1269: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
1270: P_Validate_Rec => l_Table_Column_Rec,
1271: x_return_status => x_return_status);
1272: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275:
1276: END IF;

Line 1273: RAISE FND_API.G_EXC_ERROR;

1269: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
1270: P_Validate_Rec => l_Table_Column_Rec,
1271: x_return_status => x_return_status);
1272: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275:
1276: END IF;
1277:

Line 1298: IF FND_API.to_Boolean( p_commit )

1294: -- End of API body.
1295: --
1296:
1297: -- Standard check for p_commit
1298: IF FND_API.to_Boolean( p_commit )
1299: THEN
1300: COMMIT WORK;
1301: END IF;
1302:

Line 1312: WHEN FND_API.G_EXC_ERROR THEN

1308: );
1309:
1310: EXCEPTION
1311:
1312: WHEN FND_API.G_EXC_ERROR THEN
1313: ROLLBACK TO UPDATE_Table_Column_PVT;
1314: x_return_status := FND_API.G_RET_STS_ERROR ;
1315: FND_MSG_PUB.Count_And_Get(
1316: p_count =>x_msg_count,

Line 1314: x_return_status := FND_API.G_RET_STS_ERROR ;

1310: EXCEPTION
1311:
1312: WHEN FND_API.G_EXC_ERROR THEN
1313: ROLLBACK TO UPDATE_Table_Column_PVT;
1314: x_return_status := FND_API.G_RET_STS_ERROR ;
1315: FND_MSG_PUB.Count_And_Get(
1316: p_count =>x_msg_count,
1317: p_data => x_msg_data
1318: );

Line 1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1316: p_count =>x_msg_count,
1317: p_data => x_msg_data
1318: );
1319: APP_EXCEPTION.RAISE_EXCEPTION;
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1321: ROLLBACK TO UPDATE_Table_Column_PVT ;
1322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1323: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1324: p_data => x_msg_data) ;

Line 1322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1318: );
1319: APP_EXCEPTION.RAISE_EXCEPTION;
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1321: ROLLBACK TO UPDATE_Table_Column_PVT ;
1322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1323: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1324: p_data => x_msg_data) ;
1325: APP_EXCEPTION.RAISE_EXCEPTION;
1326: WHEN OTHERS THEN

Line 1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1324: p_data => x_msg_data) ;
1325: APP_EXCEPTION.RAISE_EXCEPTION;
1326: WHEN OTHERS THEN
1327: ROLLBACK TO UPDATE_Table_Column_PVT ;
1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1329: IF FND_MSG_PUB.Check_Msg_Level
1330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1331: THEN
1332: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);

Line 1341: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1337: End Update_table_column;
1338:
1339: PROCEDURE Delete_profile_variables(
1340: P_Api_Version_Number IN NUMBER,
1341: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1342: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1343: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1344: p_BLOCK_ID IN NUMBER,
1345: p_OBJECT_VERSION_NUMBER IN NUMBER,

Line 1342: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

1338:
1339: PROCEDURE Delete_profile_variables(
1340: P_Api_Version_Number IN NUMBER,
1341: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1342: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1343: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1344: p_BLOCK_ID IN NUMBER,
1345: p_OBJECT_VERSION_NUMBER IN NUMBER,
1346: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1343: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1339: PROCEDURE Delete_profile_variables(
1340: P_Api_Version_Number IN NUMBER,
1341: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1342: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1343: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1344: p_BLOCK_ID IN NUMBER,
1345: p_OBJECT_VERSION_NUMBER IN NUMBER,
1346: X_Return_Status OUT NOCOPY VARCHAR2,
1347: X_Msg_Count OUT NOCOPY NUMBER,

Line 1359: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1355: -- Standard Start of API savepoint
1356: SAVEPOINT DELETE_Profile_Variables_PVT;
1357:
1358: -- Standard call to check for call compatibility.
1359: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1360: p_api_version_number,
1361: l_api_name,
1362: G_PKG_NAME)
1363: THEN

Line 1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1360: p_api_version_number,
1361: l_api_name,
1362: G_PKG_NAME)
1363: THEN
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: END IF;
1366:
1367:
1368: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1369: IF FND_API.to_Boolean( p_init_msg_list )

1365: END IF;
1366:
1367:
1368: -- Initialize message list if p_init_msg_list is set to TRUE.
1369: IF FND_API.to_Boolean( p_init_msg_list )
1370: THEN
1371: FND_MSG_PUB.initialize;
1372: END IF;
1373:

Line 1376: x_return_status := FND_API.G_RET_STS_SUCCESS;

1372: END IF;
1373:
1374:
1375: -- Initialize API return status to SUCCESS
1376: x_return_status := FND_API.G_RET_STS_SUCCESS;
1377:
1378: --
1379: -- Api body
1380: --

Line 1391: IF FND_API.to_Boolean( p_commit )

1387: -- End of API body
1388: --
1389:
1390: -- Standard check for p_commit
1391: IF FND_API.to_Boolean( p_commit )
1392: THEN
1393: COMMIT WORK;
1394: END IF;
1395:

Line 1404: WHEN FND_API.G_EXC_ERROR THEN

1400: p_data => x_msg_data
1401: );
1402:
1403: EXCEPTION
1404: WHEN FND_API.G_EXC_ERROR THEN
1405: ROLLBACK TO DELETE_Table_Column_PVT;
1406: x_return_status := FND_API.G_RET_STS_ERROR ;
1407: FND_MSG_PUB.Count_And_Get(
1408: p_count =>x_msg_count,

Line 1406: x_return_status := FND_API.G_RET_STS_ERROR ;

1402:
1403: EXCEPTION
1404: WHEN FND_API.G_EXC_ERROR THEN
1405: ROLLBACK TO DELETE_Table_Column_PVT;
1406: x_return_status := FND_API.G_RET_STS_ERROR ;
1407: FND_MSG_PUB.Count_And_Get(
1408: p_count =>x_msg_count,
1409: p_data => x_msg_data
1410: );

Line 1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1408: p_count =>x_msg_count,
1409: p_data => x_msg_data
1410: );
1411: APP_EXCEPTION.RAISE_EXCEPTION;
1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1413: ROLLBACK TO DELETE_Table_Column_PVT ;
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1415: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1416: p_data => x_msg_data) ;

Line 1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1410: );
1411: APP_EXCEPTION.RAISE_EXCEPTION;
1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1413: ROLLBACK TO DELETE_Table_Column_PVT ;
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1415: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1416: p_data => x_msg_data) ;
1417: APP_EXCEPTION.RAISE_EXCEPTION;
1418: WHEN OTHERS THEN

Line 1420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1416: p_data => x_msg_data) ;
1417: APP_EXCEPTION.RAISE_EXCEPTION;
1418: WHEN OTHERS THEN
1419: ROLLBACK TO DELETE_Table_Column_PVT ;
1420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1421: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1422: THEN
1423: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1424: END IF ;

Line 1432: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1428: End Delete_profile_variables;
1429:
1430: PROCEDURE Delete_Table_Columns(
1431: P_Api_Version_Number IN NUMBER,
1432: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1433: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1434: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1435: p_BLOCK_ID IN NUMBER,
1436: px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,

Line 1433: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

1429:
1430: PROCEDURE Delete_Table_Columns(
1431: P_Api_Version_Number IN NUMBER,
1432: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1433: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1434: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1435: p_BLOCK_ID IN NUMBER,
1436: px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
1437: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1434: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1430: PROCEDURE Delete_Table_Columns(
1431: P_Api_Version_Number IN NUMBER,
1432: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1433: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1434: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1435: p_BLOCK_ID IN NUMBER,
1436: px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
1437: X_Return_Status OUT NOCOPY VARCHAR2,
1438: X_Msg_Count OUT NOCOPY NUMBER,

Line 1454: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1450: -- Standard Start of API savepoint
1451: SAVEPOINT DELETE_Table_Columns_PVT;
1452:
1453: -- Standard call to check for call compatibility.
1454: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1455: p_api_version_number,
1456: l_api_name,
1457: G_PKG_NAME)
1458: THEN

Line 1459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1455: p_api_version_number,
1456: l_api_name,
1457: G_PKG_NAME)
1458: THEN
1459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1460: END IF;
1461:
1462:
1463: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1464: IF FND_API.to_Boolean( p_init_msg_list )

1460: END IF;
1461:
1462:
1463: -- Initialize message list if p_init_msg_list is set to TRUE.
1464: IF FND_API.to_Boolean( p_init_msg_list )
1465: THEN
1466: FND_MSG_PUB.initialize;
1467: END IF;
1468:

Line 1471: x_return_status := FND_API.G_RET_STS_SUCCESS;

1467: END IF;
1468:
1469:
1470: -- Initialize API return status to SUCCESS
1471: x_return_status := FND_API.G_RET_STS_SUCCESS;
1472:
1473: --
1474: -- Api body
1475: --

Line 1499: IF FND_API.to_Boolean( p_commit )

1495: -- End of API body
1496: --
1497:
1498: -- Standard check for p_commit
1499: IF FND_API.to_Boolean( p_commit )
1500: THEN
1501: COMMIT WORK;
1502: END IF;
1503:

Line 1511: WHEN FND_API.G_EXC_ERROR THEN

1507: p_data => x_msg_data
1508: );
1509:
1510: EXCEPTION
1511: WHEN FND_API.G_EXC_ERROR THEN
1512: ROLLBACK TO DELETE_Table_Columns_PVT;
1513: x_return_status := FND_API.G_RET_STS_ERROR ;
1514: FND_MSG_PUB.Count_And_Get(
1515: p_count =>x_msg_count,

Line 1513: x_return_status := FND_API.G_RET_STS_ERROR ;

1509:
1510: EXCEPTION
1511: WHEN FND_API.G_EXC_ERROR THEN
1512: ROLLBACK TO DELETE_Table_Columns_PVT;
1513: x_return_status := FND_API.G_RET_STS_ERROR ;
1514: FND_MSG_PUB.Count_And_Get(
1515: p_count =>x_msg_count,
1516: p_data => x_msg_data
1517: );

Line 1519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1515: p_count =>x_msg_count,
1516: p_data => x_msg_data
1517: );
1518: APP_EXCEPTION.RAISE_EXCEPTION;
1519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1520: ROLLBACK TO DELETE_Table_Columns_PVT ;
1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1522: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1523: p_data => x_msg_data) ;

Line 1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1517: );
1518: APP_EXCEPTION.RAISE_EXCEPTION;
1519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1520: ROLLBACK TO DELETE_Table_Columns_PVT ;
1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1522: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1523: p_data => x_msg_data) ;
1524: APP_EXCEPTION.RAISE_EXCEPTION;
1525: WHEN OTHERS THEN

Line 1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1523: p_data => x_msg_data) ;
1524: APP_EXCEPTION.RAISE_EXCEPTION;
1525: WHEN OTHERS THEN
1526: ROLLBACK TO DELETE_Table_Columns_PVT ;
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1528: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1529: THEN
1530: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1531: END IF ;

Line 1578: x_return_status := FND_API.G_RET_STS_SUCCESS;

1574: l_dummy number;
1575: BEGIN
1576:
1577: -- initialize the return status
1578: x_return_status := FND_API.G_RET_STS_SUCCESS;
1579:
1580: -- Check if the validation is called for a create or an
1581: -- update
1582: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN

Line 1591: x_return_status := FND_API.G_RET_STS_ERROR;

1587: ( p_block_name IS NOT NULL )) THEN
1588: Open get_block_name;
1589: Fetch get_block_name into l_dummy;
1590: if get_block_name%FOUND then
1591: x_return_status := FND_API.G_RET_STS_ERROR;
1592: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg
1593: ( p_api_name => p_api_name,
1594: p_argument => 'p_block_name' ,
1595: p_argument_value => p_block_name);

Line 1596: x_return_status := FND_API.G_RET_STS_ERROR;

1592: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg
1593: ( p_api_name => p_api_name,
1594: p_argument => 'p_block_name' ,
1595: p_argument_value => p_block_name);
1596: x_return_status := FND_API.G_RET_STS_ERROR;
1597: end if;
1598: Close get_block_name;
1599: ELSE
1600: -- If the block name is not passed or if passed in as NULL write a

Line 1602: x_return_status := FND_API.G_RET_STS_ERROR;

1598: Close get_block_name;
1599: ELSE
1600: -- If the block name is not passed or if passed in as NULL write a
1601: -- mandatory attribute missing message
1602: x_return_status := FND_API.G_RET_STS_ERROR;
1603: CSC_CORE_UTILS_PVT.mandatory_arg_error(
1604: p_api_name => p_api_name,
1605: p_argument => 'p_block_name',
1606: p_argument_value => p_block_name);

Line 1614: x_return_status := FND_API.G_RET_STS_ERROR;

1610: ELSIF p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE THEN
1611: -- if the block name is passed in and as NULL then
1612: -- its a mandatory argument error.
1613: if ( p_block_name IS NULL ) then
1614: x_return_status := FND_API.G_RET_STS_ERROR;
1615: CSC_CORE_UTILS_PVT.mandatory_arg_error(
1616: p_api_name => p_api_name,
1617: p_argument => 'p_block_name',
1618: p_argument_value => p_block_name);

Line 1630: x_return_status := FND_API.G_RET_STS_ERROR;

1626: -- the present one then ignore else raise an
1627: -- duplicate value error as block name should
1628: -- be unique
1629: if l_dummy <> p_block_id then
1630: x_return_status := FND_API.G_RET_STS_ERROR;
1631: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg
1632: ( p_api_name => p_api_name,
1633: p_argument => 'p_block_name' ,
1634: p_argument_value => p_block_name);

Line 1635: x_return_status := FND_API.G_RET_STS_ERROR;

1631: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg
1632: ( p_api_name => p_api_name,
1633: p_argument => 'p_block_name' ,
1634: p_argument_value => p_block_name);
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636: exit;
1637: else
1638: exit;
1639: end if;

Line 1668: x_return_status := FND_API.G_RET_STS_SUCCESS;

1664: ) IS
1665: --
1666: BEGIN
1667: --
1668: x_return_status := FND_API.G_RET_STS_SUCCESS;
1669:
1670: -- check if the seeded flag is passed in and is not
1671: -- null, if passed in check if the lookup code
1672: -- exists in fnd lookups for this date, if not

Line 1679: p_lookup_code => p_seeded_flag ) <> FND_API.G_RET_STS_SUCCESS

1675: ( p_seeded_flag IS NOT NULL )) THEN
1676: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
1677: p_effective_date => trunc(sysdate),
1678: p_lookup_type => 'YES_NO',
1679: p_lookup_code => p_seeded_flag ) <> FND_API.G_RET_STS_SUCCESS
1680: THEN
1681: x_return_status := FND_API.G_RET_STS_ERROR;
1682: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,
1683: p_argument_value => p_seeded_flag,

Line 1681: x_return_status := FND_API.G_RET_STS_ERROR;

1677: p_effective_date => trunc(sysdate),
1678: p_lookup_type => 'YES_NO',
1679: p_lookup_code => p_seeded_flag ) <> FND_API.G_RET_STS_SUCCESS
1680: THEN
1681: x_return_status := FND_API.G_RET_STS_ERROR;
1682: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,
1683: p_argument_value => p_seeded_flag,
1684: p_argument => p_parameter_name);
1685: END IF;

Line 1698: x_return_status := FND_API.G_RET_STS_SUCCESS;

1694: ) IS
1695: --
1696: BEGIN
1697: --
1698: x_return_status := FND_API.G_RET_STS_SUCCESS;
1699:
1700: -- check if the block_level is passed in and is not
1701: -- null
1702:

Line 1707: x_return_status := FND_API.G_RET_STS_ERROR;

1703: IF (( p_block_level <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
1704: ( p_block_level IS NOT NULL )) THEN
1705: IF (p_block_level <> 'PARTY' AND p_block_level <> 'ACCOUNT' AND p_block_level <> 'CONTACT' AND p_block_level <> 'EMPLOYEE')
1706: THEN
1707: x_return_status := FND_API.G_RET_STS_ERROR;
1708: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,
1709: p_argument_value => p_block_level,
1710: p_argument => p_parameter_name);
1711: END IF;

Line 1738: x_return_status := FND_API.G_RET_STS_SUCCESS;

1734: IS
1735: --
1736: BEGIN
1737: --
1738: x_return_status := FND_API.G_RET_STS_SUCCESS;
1739:
1740: -- if the currency code is passed in and is not null,
1741: -- validate the currency code.
1742: IF (( p_currency_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND

Line 1747: p_currency_code => p_currency_code ) <> FND_API.G_RET_STS_SUCCESS THEN

1743: ( p_currency_code IS NOT NULL )) then
1744:
1745: IF CSC_CORE_UTILS_PVT.Currency_code_not_exists(
1746: p_effective_date => sysdate,
1747: p_currency_code => p_currency_code ) <> FND_API.G_RET_STS_SUCCESS THEN
1748:
1749: -- if the currency code is not valid its an invalid argument
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,

Line 1750: x_return_status := FND_API.G_RET_STS_ERROR;

1746: p_effective_date => sysdate,
1747: p_currency_code => p_currency_code ) <> FND_API.G_RET_STS_SUCCESS THEN
1748:
1749: -- if the currency code is not valid its an invalid argument
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,
1752: p_argument_value => p_currency_code,
1753: p_argument => p_parameter_name);
1754:

Line 1783: x_return_status := FND_API.G_RET_STS_SUCCESS;

1779: l_sql_cur_hdl INT;
1780: BEGIN
1781:
1782: -- initialize the return status to SUCCESS
1783: x_return_status := FND_API.G_RET_STS_SUCCESS;
1784:
1785: -- if the sql_statement is passed in and if its NOT NULL then
1786: -- validate the sql_statement by parsing it using the dbms_sql
1787: -- package.

Line 1793: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1789: CSC_CORE_UTILS_PVT.Validate_Sql_Stmnt(
1790: p_sql_stmnt => p_sql_Stmnt,
1791: x_return_status => X_return_status);
1792:
1793: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1794:
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1796: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1797: p_api_name => p_api_name,

Line 1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1791: x_return_status => X_return_status);
1792:
1793: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1794:
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1796: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1797: p_api_name => p_api_name,
1798: p_argument_value => p_sql_stmnt,
1799: p_argument => p_parameter_name);

Line 1821: x_return_status := FND_API.G_RET_STS_SUCCESS;

1817: where object_code = p_object_code;
1818: BEGIN
1819:
1820: -- initialize the return status to SUCCESS
1821: x_return_status := FND_API.G_RET_STS_SUCCESS;
1822:
1823: IF ((p_Object_Code IS NOT NULL) AND
1824: (p_Object_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR )) THEN
1825: Open get_object_csr;

Line 1828: x_return_status := FND_API.G_RET_STS_ERROR;

1824: (p_Object_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR )) THEN
1825: Open get_object_csr;
1826: Fetch get_object_csr into l_dummy;
1827: IF get_object_csr%NOTFOUND THEN
1828: x_return_status := FND_API.G_RET_STS_ERROR;
1829: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1830: p_api_name => p_api_name,
1831: p_argument_value => p_object_code,
1832: p_argument => p_parameter_name);

Line 1858: x_return_status := FND_API.G_RET_STS_SUCCESS;

1854: from csc_prof_blocks_b
1855: where block_name_code = p_block_name_code;
1856:
1857: BEGIN
1858: x_return_status := FND_API.G_RET_STS_SUCCESS;
1859:
1860: -- Check if the validation is called for a Create or
1861: -- an update
1862: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN

Line 1871: x_return_status := FND_API.G_RET_STS_ERROR;

1867: open get_block_code;
1868: fetch get_block_code into l_dummy;
1869: if get_block_code%FOUND then
1870: -- if not valid an invalid argument message
1871: x_return_status := FND_API.G_RET_STS_ERROR;
1872: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1873: p_api_name => p_api_name,
1874: p_argument_value => p_block_name_code,
1875: p_argument => p_parameter_name );

Line 1881: x_return_status := FND_API.G_RET_STS_ERROR;

1877: close get_block_code;
1878: else
1879: -- if block_name_code is not passed in or if passed
1880: -- in as null raise a mandatory argument error.
1881: x_return_status := FND_API.G_RET_STS_ERROR;
1882: CSC_CORE_UTILS_PVT.mandatory_arg_error(
1883: p_api_name => p_api_name,
1884: p_argument => 'p_block_name_code',
1885: p_argument_value => p_block_name_code);

Line 1893: x_return_status := FND_API.G_RET_STS_ERROR;

1889: -- if the block_name_code is passed in as NULL
1890: -- its an error else validate.
1891: if p_block_name_code IS NULL THEN
1892: -- write a mandatory attributes missing message
1893: x_return_status := FND_API.G_RET_STS_ERROR;
1894: CSC_CORE_UTILS_PVT.mandatory_arg_error(
1895: p_api_name => p_api_name,
1896: p_argument => 'p_block_name_code',
1897: p_argument_value => p_block_name_code);

Line 1906: x_return_status := FND_API.G_RET_STS_ERROR;

1902: -- if the block_name_code passed in is the same as
1903: -- the present one then ignore else raise an duplicate
1904: -- value error as block_name_code should be unique
1905: if l_dummy <> p_block_id then
1906: x_return_status := FND_API.G_RET_STS_ERROR;
1907: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg
1908: ( p_api_name => p_api_name,
1909: p_argument => 'p_block_name_code' ,
1910: p_argument_value => p_block_name_code);

Line 1932: x_return_status := FND_API.G_RET_STS_SUCCESS;

1928: IS
1929: BEGIN
1930:
1931: -- Initialize return status to success
1932: x_return_status := FND_API.G_RET_STS_SUCCESS;
1933:
1934:
1935: -- Validate Block_Name
1936: Validate_Block_Name(

Line 1943: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1939: p_block_name => p_validate_rec.block_name,
1940: p_block_id => p_Validate_rec.block_id,
1941: x_return_status => x_return_status );
1942:
1943: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1944: RAISE FND_API.G_EXC_ERROR;
1945: END IF;
1946:
1947: -- validate start and end date

Line 1944: RAISE FND_API.G_EXC_ERROR;

1940: p_block_id => p_Validate_rec.block_id,
1941: x_return_status => x_return_status );
1942:
1943: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1944: RAISE FND_API.G_EXC_ERROR;
1945: END IF;
1946:
1947: -- validate start and end date
1948: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(

Line 1954: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1950: p_start_date => p_validate_rec.start_date_active,
1951: p_end_date => p_validate_rec.end_date_active,
1952: x_return_status => x_return_status );
1953:
1954: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1955: RAISE FND_API.G_EXC_ERROR;
1956: END IF;
1957:
1958: --Validate seeded flag

Line 1955: RAISE FND_API.G_EXC_ERROR;

1951: p_end_date => p_validate_rec.end_date_active,
1952: x_return_status => x_return_status );
1953:
1954: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1955: RAISE FND_API.G_EXC_ERROR;
1956: END IF;
1957:
1958: --Validate seeded flag
1959: Validate_Seeded_Flag(

Line 1965: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1961: p_parameter_name => 'p_Seeded_Flag',
1962: p_seeded_flag => p_validate_rec.seeded_flag,
1963: x_return_status => x_return_status );
1964:
1965: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1966: RAISE FND_API.G_EXC_ERROR;
1967: END IF;
1968:
1969: --Validate Block_level

Line 1966: RAISE FND_API.G_EXC_ERROR;

1962: p_seeded_flag => p_validate_rec.seeded_flag,
1963: x_return_status => x_return_status );
1964:
1965: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1966: RAISE FND_API.G_EXC_ERROR;
1967: END IF;
1968:
1969: --Validate Block_level
1970: Validate_Block_Level(

Line 1976: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1972: p_parameter_name => 'p_Block_Level',
1973: p_block_level => p_validate_rec.block_level,
1974: x_return_status => x_return_status );
1975:
1976: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1977: RAISE FND_API.G_EXC_ERROR;
1978: END IF;
1979:
1980:

Line 1977: RAISE FND_API.G_EXC_ERROR;

1973: p_block_level => p_validate_rec.block_level,
1974: x_return_status => x_return_status );
1975:
1976: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1977: RAISE FND_API.G_EXC_ERROR;
1978: END IF;
1979:
1980:
1981: -- Validate Sql Statement

Line 1988: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1984: p_parameter_name => 'p_sql_stmnt',
1985: p_sql_Stmnt => p_validate_rec.sql_stmnt,
1986: x_return_status => x_return_status );
1987:
1988: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1989: RAISE FND_API.G_EXC_ERROR;
1990: END IF;
1991:
1992: -- Validate Batch Sql Statement

Line 1989: RAISE FND_API.G_EXC_ERROR;

1985: p_sql_Stmnt => p_validate_rec.sql_stmnt,
1986: x_return_status => x_return_status );
1987:
1988: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1989: RAISE FND_API.G_EXC_ERROR;
1990: END IF;
1991:
1992: -- Validate Batch Sql Statement
1993: Validate_Sql_stmnt(

Line 1999: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1995: p_parameter_name => 'p_batch_sql_stmnt',
1996: p_sql_Stmnt => p_validate_rec.batch_sql_stmnt,
1997: x_return_status => x_return_status );
1998:
1999: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2000: RAISE FND_API.G_EXC_ERROR;
2001: END IF;
2002:
2003: -- Validate Currency code

Line 2000: RAISE FND_API.G_EXC_ERROR;

1996: p_sql_Stmnt => p_validate_rec.batch_sql_stmnt,
1997: x_return_status => x_return_status );
1998:
1999: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2000: RAISE FND_API.G_EXC_ERROR;
2001: END IF;
2002:
2003: -- Validate Currency code
2004: Validate_Currency_Code(

Line 2010: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2006: p_parameter_name => 'p_currency_code',
2007: p_currency_code => p_validate_rec.currency_code,
2008: x_return_status => x_return_status );
2009:
2010: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2011: RAISE FND_API.G_EXC_ERROR;
2012: END IF;
2013:
2014: -- validate block name code

Line 2011: RAISE FND_API.G_EXC_ERROR;

2007: p_currency_code => p_validate_rec.currency_code,
2008: x_return_status => x_return_status );
2009:
2010: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2011: RAISE FND_API.G_EXC_ERROR;
2012: END IF;
2013:
2014: -- validate block name code
2015: Validate_block_name_Code(

Line 2022: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2018: p_block_name_code => p_validate_rec.block_name_code,
2019: p_block_id => p_validate_rec.block_id,
2020: p_validation_mode => p_Validation_mode,
2021: x_return_status => x_return_status );
2022: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2023: RAISE FND_API.G_EXC_ERROR;
2024: END IF;
2025:
2026: -- Validate object code

Line 2023: RAISE FND_API.G_EXC_ERROR;

2019: p_block_id => p_validate_rec.block_id,
2020: p_validation_mode => p_Validation_mode,
2021: x_return_status => x_return_status );
2022: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2023: RAISE FND_API.G_EXC_ERROR;
2024: END IF;
2025:
2026: -- Validate object code
2027: Validate_Object_Id(

Line 2033: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2029: p_parameter_Name => 'P_OBJECT_CODE',
2030: p_object_code => p_validate_rec.object_code,
2031: x_return_status => x_return_status );
2032:
2033: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2034: RAISE FND_API.G_EXC_ERROR;
2035: END IF;
2036:
2037: /* This Call added for Enhancement 1781726 for Validating Application_id*/

Line 2034: RAISE FND_API.G_EXC_ERROR;

2030: p_object_code => p_validate_rec.object_code,
2031: x_return_status => x_return_status );
2032:
2033: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2034: RAISE FND_API.G_EXC_ERROR;
2035: END IF;
2036:
2037: /* This Call added for Enhancement 1781726 for Validating Application_id*/
2038: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (

Line 2046: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2042: X_Msg_Count => x_msg_count,
2043: X_Msg_Data => x_msg_data,
2044: p_effective_date => SYSDATE );
2045:
2046: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2047: RAISE FND_API.G_EXC_ERROR;
2048: END IF;
2049:
2050: END Validate_Profile_Variables;

Line 2047: RAISE FND_API.G_EXC_ERROR;

2043: X_Msg_Data => x_msg_data,
2044: p_effective_date => SYSDATE );
2045:
2046: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2047: RAISE FND_API.G_EXC_ERROR;
2048: END IF;
2049:
2050: END Validate_Profile_Variables;
2051:

Line 2084: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2080:
2081: Begin
2082:
2083: -- Initialize the p_return_status to TRUE
2084: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2085:
2086:
2087: OPEN C_get_prof_rec;
2088: FETCH C_get_prof_rec INTO X_PROF_BLOCKS_REC;

Line 2094: x_return_status := FND_API.G_RET_STS_ERROR;

2090: CLOSE C_Get_prof_Rec;
2091: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2092: THEN
2093: CSC_CORE_UTILS_PVT.Record_IS_LOCKED_MSG(p_API_NAME=> 'CSC_PROF_BLOCKS');
2094: x_return_status := FND_API.G_RET_STS_ERROR;
2095: END IF;
2096: raise FND_API.G_EXC_ERROR;
2097: END IF;
2098: IF C_GET_prof_Rec%ISOPEN THEN

Line 2096: raise FND_API.G_EXC_ERROR;

2092: THEN
2093: CSC_CORE_UTILS_PVT.Record_IS_LOCKED_MSG(p_API_NAME=> 'CSC_PROF_BLOCKS');
2094: x_return_status := FND_API.G_RET_STS_ERROR;
2095: END IF;
2096: raise FND_API.G_EXC_ERROR;
2097: END IF;
2098: IF C_GET_prof_Rec%ISOPEN THEN
2099: CLOSE C_Get_Prof_Rec;
2100: END IF;

Line 2143: x_return_status := FND_API.G_RET_STS_SUCCESS;

2139: And object_version_number = p_object_version_number
2140: For Update NOWAIT;
2141: BEGIN
2142: -- initialze the return status
2143: x_return_status := FND_API.G_RET_STS_SUCCESS;
2144:
2145: OPEN C_get_table_column_rec;
2146: FETCH C_get_table_column_rec INTO X_TABLE_COLUMN_REC;
2147: IF C_get_table_column_rec%NOTFOUND THEN

Line 2152: x_return_status := FND_API.G_RET_STS_ERROR;

2148: CLOSE C_Get_Table_Column_rec;
2149: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2150: THEN
2151: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_API_NAME=>'CSC_PROF_TABLE_COLUMNS');
2152: x_return_status := FND_API.G_RET_STS_ERROR;
2153: END IF;
2154: raise FND_API.G_EXC_ERROR;
2155: END IF;
2156: IF C_Get_table_Column_rec%ISOPEN THEN

Line 2154: raise FND_API.G_EXC_ERROR;

2150: THEN
2151: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_API_NAME=>'CSC_PROF_TABLE_COLUMNS');
2152: x_return_status := FND_API.G_RET_STS_ERROR;
2153: END IF;
2154: raise FND_API.G_EXC_ERROR;
2155: END IF;
2156: IF C_Get_table_Column_rec%ISOPEN THEN
2157: CLOSE C_get_table_Column_rec;
2158: END IF;

Line 2194: l_return_status := FND_API.G_RET_STS_SUCCESS;

2190: l_return_status VARCHAR2(30);
2191: BEGIN
2192:
2193: -- Initlaize the return status to SUCCESS
2194: l_return_status := FND_API.G_RET_STS_SUCCESS;
2195:
2196: Open get_block_id;
2197: Fetch get_block_id into l_dummy;
2198: IF get_block_id%NOTFOUND THEN

Line 2199: l_return_status := FND_API.G_RET_STS_ERROR;

2195:
2196: Open get_block_id;
2197: Fetch get_block_id into l_dummy;
2198: IF get_block_id%NOTFOUND THEN
2199: l_return_status := FND_API.G_RET_STS_ERROR;
2200: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
2201: p_api_name => p_api_name,
2202: p_argument_value => to_char(p_block_id),
2203: p_argument => 'p_block_id' );

Line 2214: x_return_status := FND_API.G_RET_STS_SUCCESS;

2210:
2211:
2212:
2213: -- Initlaize the return status to SUCCESS
2214: x_return_status := FND_API.G_RET_STS_SUCCESS;
2215:
2216:
2217: --
2218: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN

Line 2225: x_return_status := FND_API.G_RET_STS_ERROR;

2221: ( p_block_id IS NOT NULL )
2222: THEN
2223: x_return_status := chk_block_id( p_block_id );
2224: ELSE
2225: x_return_status := FND_API.G_RET_STS_ERROR;
2226: CSC_CORE_UTILS_PVT.mandatory_arg_error(
2227: p_api_name => p_api_name,
2228: p_argument => 'p_block_id',
2229: p_argument_value => p_block_id);

Line 2239: x_return_status := FND_API.G_RET_STS_ERROR;

2235: THEN
2236: IF (p_block_id IS NOT NULL ) THEN
2237: x_return_status := chk_block_id( p_block_id );
2238: ELSE
2239: x_return_status := FND_API.G_RET_STS_ERROR;
2240: CSC_CORE_UTILS_PVT.mandatory_arg_error(
2241: p_api_name => p_api_name,
2242: p_argument => 'p_block_id',
2243: p_argument_value => p_block_id);

Line 2273: x_return_status := FND_API.G_RET_STS_SUCCESS;

2269: where view_name = p_table_name;
2270: BEGIN
2271:
2272: -- Initialize API return status to SUCCESS
2273: x_return_status := FND_API.G_RET_STS_SUCCESS;
2274:
2275: IF p_TABLE_NAME is not NULL and p_TABLE_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
2276: THEN
2277: Open get_tname_csr;

Line 2283: x_return_status := FND_API.G_RET_STS_ERROR;

2279: IF get_tname_csr%NOTFOUND THEN
2280: Open get_vname_csr;
2281: Fetch get_vname_csr into l_dummy;
2282: IF get_vname_csr%NOTFOUND THEN
2283: x_return_status := FND_API.G_RET_STS_ERROR;
2284: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
2285: p_api_name => p_api_name,
2286: p_argument_value => p_table_name,
2287: p_argument => 'p_Table_Name' );

Line 2317: x_return_status := FND_API.G_RET_STS_SUCCESS;

2313: l_dummy VARCHAR2(10);
2314: BEGIN
2315:
2316: -- Initialize API return status to SUCCESS
2317: x_return_status := FND_API.G_RET_STS_SUCCESS;
2318:
2319:
2320: IF p_COLUMN_NAME is not NULL and p_COLUMN_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
2321: THEN

Line 2328: x_return_status := FND_API.G_RET_STS_ERROR;

2324: IF get_cname_csr%NOTFOUND THEN
2325: Open get_vcname_csr;
2326: Fetch get_vcname_csr into l_dummy;
2327: IF get_vcname_csr%NOTFOUND THEN
2328: x_return_status := FND_API.G_RET_STS_ERROR;
2329: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
2330: p_api_name => p_api_name,
2331: p_argument_value => p_column_name,
2332: p_argument => 'p_Column_Name' );

Line 2352: x_return_status := FND_API.G_RET_STS_SUCCESS;

2348: IS
2349: BEGIN
2350:
2351: -- Initialize API return status to SUCCESS
2352: x_return_status := FND_API.G_RET_STS_SUCCESS;
2353:
2354: Validate_COLUMN_NAME (
2355: p_api_name => p_api_name,
2356: P_Validation_mode => p_validation_mode,

Line 2360: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2356: P_Validation_mode => p_validation_mode,
2357: P_COLUMN_NAME => p_Validate_rec.column_name,
2358: X_Return_Status => x_return_status
2359: );
2360: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2361: raise FND_API.G_EXC_ERROR;
2362: END IF;
2363:
2364: Validate_TABLE_NAME (

Line 2361: raise FND_API.G_EXC_ERROR;

2357: P_COLUMN_NAME => p_Validate_rec.column_name,
2358: X_Return_Status => x_return_status
2359: );
2360: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2361: raise FND_API.G_EXC_ERROR;
2362: END IF;
2363:
2364: Validate_TABLE_NAME (
2365: p_api_name => p_api_name,

Line 2370: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2366: P_Validation_mode => p_validation_mode,
2367: P_TABLE_NAME => p_Validate_rec.table_name,
2368: X_Return_Status => x_return_status
2369: );
2370: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2371: raise FND_API.G_EXC_ERROR;
2372: END IF;
2373:
2374: Validate_Block_Id (

Line 2371: raise FND_API.G_EXC_ERROR;

2367: P_TABLE_NAME => p_Validate_rec.table_name,
2368: X_Return_Status => x_return_status
2369: );
2370: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2371: raise FND_API.G_EXC_ERROR;
2372: END IF;
2373:
2374: Validate_Block_Id (
2375: p_api_name => p_api_name,

Line 2380: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2376: p_validation_mode => p_validation_mode,
2377: p_block_id => p_Validate_rec.block_id,
2378: x_return_status => x_return_status
2379: );
2380: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2381: raise FND_API.G_EXC_ERROR;
2382: END IF;
2383:
2384:

Line 2381: raise FND_API.G_EXC_ERROR;

2377: p_block_id => p_Validate_rec.block_id,
2378: x_return_status => x_return_status
2379: );
2380: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2381: raise FND_API.G_EXC_ERROR;
2382: END IF;
2383:
2384:
2385: IF p_validate_rec.COLUMN_SEQUENCE is NULL THEN