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: -- check if the select_clause and the from_Clause
46: -- is NULL or missing, if so we cannot form an
47: -- sql_statement.
48:

Line 55: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 69: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 70: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 713: IF NOT FND_API.Compatible_API_Call(l_api_version,

709: BEGIN
710: -- Standard start of API savepoint
711: SAVEPOINT Create_Profile_Variable_PVT;
712: -- Standard call to check for call compatibility
713: IF NOT FND_API.Compatible_API_Call(l_api_version,
714: p_api_version_number,
715: l_api_name,
716: G_PKG_NAME )
717: THEN

Line 718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

714: p_api_version_number,
715: l_api_name,
716: G_PKG_NAME )
717: THEN
718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
719: END IF;
720: -- Initialize message list if p_init_msg_list is set to TRUE
721: IF FND_API.To_Boolean(p_init_msg_list)
722: THEN

Line 721: IF FND_API.To_Boolean(p_init_msg_list)

717: THEN
718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
719: END IF;
720: -- Initialize message list if p_init_msg_list is set to TRUE
721: IF FND_API.To_Boolean(p_init_msg_list)
722: THEN
723: FND_MSG_PUB.Initialize;
724: END IF;
725: -- Initialize API return status to success

Line 726: x_return_status := FND_API.G_RET_STS_SUCCESS;

722: THEN
723: FND_MSG_PUB.Initialize;
724: END IF;
725: -- Initialize API return status to success
726: x_return_status := FND_API.G_RET_STS_SUCCESS;
727: -- we have to build the sql statement in advance before
728: -- going into the validation part to validate the whole
729: -- sql statement
730: /* jamose duplicate validation; validated under build_sql_stmnt

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

747: p_where_clause => l_prof_var_rec.where_clause,
748: p_other_clause => l_prof_var_rec.other_clause,
749: x_sql_stmnt => l_prof_var_rec.sql_stmnt,
750: x_return_status => x_return_status );
751: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
752: RAISE FND_API.G_EXC_ERROR;
753: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
755: END IF;

Line 752: RAISE FND_API.G_EXC_ERROR;

748: p_other_clause => l_prof_var_rec.other_clause,
749: x_sql_stmnt => l_prof_var_rec.sql_stmnt,
750: x_return_status => x_return_status );
751: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
752: RAISE FND_API.G_EXC_ERROR;
753: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
755: END IF;
756: -- ----------------------------------------------------------------------

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

749: x_sql_stmnt => l_prof_var_rec.sql_stmnt,
750: x_return_status => x_return_status );
751: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
752: RAISE FND_API.G_EXC_ERROR;
753: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
755: END IF;
756: -- ----------------------------------------------------------------------
757: -- Apply business-rule validation to all required and passed parameters

Line 754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

750: x_return_status => x_return_status );
751: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
752: RAISE FND_API.G_EXC_ERROR;
753: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
755: END IF;
756: -- ----------------------------------------------------------------------
757: -- Apply business-rule validation to all required and passed parameters
758: -- if validation level is set.

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

770: x_return_status => x_return_status,
771: x_msg_count =>x_msg_count,
772: x_msg_data =>x_msg_data );
773:
774: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
775: RAISE FND_API.G_EXC_ERROR;
776: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
778: END IF;

Line 775: RAISE FND_API.G_EXC_ERROR;

771: x_msg_count =>x_msg_count,
772: x_msg_data =>x_msg_data );
773:
774: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
775: RAISE FND_API.G_EXC_ERROR;
776: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
778: END IF;
779:

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

772: x_msg_data =>x_msg_data );
773:
774: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
775: RAISE FND_API.G_EXC_ERROR;
776: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
778: END IF;
779:
780: END IF ; /*** p_validation_level ****/

Line 777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

773:
774: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
775: RAISE FND_API.G_EXC_ERROR;
776: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
778: END IF;
779:
780: END IF ; /*** p_validation_level ****/
781:

Line 831: IF FND_API.To_Boolean(p_commit) THEN

827: );
828:
829: --
830: -- Standard check of p_commit
831: IF FND_API.To_Boolean(p_commit) THEN
832: COMMIT WORK;
833: END IF;
834:
835: -- Standard call to get message count and if count is 1, get message info

Line 838: p_encoded => FND_API.G_FALSE,

834:
835: -- Standard call to get message count and if count is 1, get message info
836:
837: FND_MSG_PUB.Count_And_Get(
838: p_encoded => FND_API.G_FALSE,
839: p_count => x_msg_count,
840: p_data => x_msg_data );
841:
842:

Line 844: WHEN FND_API.G_EXC_ERROR THEN

840: p_data => x_msg_data );
841:
842:
843: EXCEPTION
844: WHEN FND_API.G_EXC_ERROR THEN
845: ROLLBACK TO Create_Profile_Variable_PVT;
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: /* FND_MSG_PUB.Count_And_Get
848: ( p_encoded => FND_API.G_FALSE,

Line 846: x_return_status := FND_API.G_RET_STS_ERROR;

842:
843: EXCEPTION
844: WHEN FND_API.G_EXC_ERROR THEN
845: ROLLBACK TO Create_Profile_Variable_PVT;
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: /* FND_MSG_PUB.Count_And_Get
848: ( p_encoded => FND_API.G_FALSE,
849: p_count => x_msg_count,
850: p_data => x_msg_data

Line 848: ( p_encoded => FND_API.G_FALSE,

844: WHEN FND_API.G_EXC_ERROR THEN
845: ROLLBACK TO Create_Profile_Variable_PVT;
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: /* FND_MSG_PUB.Count_And_Get
848: ( p_encoded => FND_API.G_FALSE,
849: p_count => x_msg_count,
850: p_data => x_msg_data
851: ); */
852: APP_EXCEPTION.RAISE_EXCEPTION;

Line 853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

849: p_count => x_msg_count,
850: p_data => x_msg_data
851: ); */
852: APP_EXCEPTION.RAISE_EXCEPTION;
853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
854: ROLLBACK TO Create_Profile_Variable_PVT;
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
856: /* FND_MSG_PUB.Count_And_Get
857: ( p_encoded => FND_API.G_FALSE,

Line 855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

851: ); */
852: APP_EXCEPTION.RAISE_EXCEPTION;
853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
854: ROLLBACK TO Create_Profile_Variable_PVT;
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
856: /* FND_MSG_PUB.Count_And_Get
857: ( p_encoded => FND_API.G_FALSE,
858: p_count => x_msg_count,
859: p_data => x_msg_data

Line 857: ( p_encoded => FND_API.G_FALSE,

853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
854: ROLLBACK TO Create_Profile_Variable_PVT;
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
856: /* FND_MSG_PUB.Count_And_Get
857: ( p_encoded => FND_API.G_FALSE,
858: p_count => x_msg_count,
859: p_data => x_msg_data
860: ); */
861: APP_EXCEPTION.RAISE_EXCEPTION;

Line 864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

860: ); */
861: APP_EXCEPTION.RAISE_EXCEPTION;
862: WHEN OTHERS THEN
863: ROLLBACK TO Create_Profile_Variable_PVT;
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
866: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
867: -- END IF;
868: FND_MSG_PUB.Build_Exc_Msg;

Line 870: ( p_encoded => FND_API.G_FALSE,

866: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
867: -- END IF;
868: FND_MSG_PUB.Build_Exc_Msg;
869: /* FND_MSG_PUB.Count_And_Get
870: ( p_encoded => FND_API.G_FALSE,
871: p_count => x_msg_count,
872: p_data => x_msg_data
873: ); */
874: APP_EXCEPTION.RAISE_EXCEPTION;

Line 935: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

931: px_object_version_number => l_object_version_number,
932: p_block_id => l_table_column_rec.block_id,
933: p_sql_stmnt_for_drilldown => ltrim(rtrim(l_sql_stmnt_for_drilldown)));
934:
935: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
936: RAISE FND_API.G_EXC_ERROR;
937: END IF; */
938: END;
939:

Line 936: RAISE FND_API.G_EXC_ERROR;

932: p_block_id => l_table_column_rec.block_id,
933: p_sql_stmnt_for_drilldown => ltrim(rtrim(l_sql_stmnt_for_drilldown)));
934:
935: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
936: RAISE FND_API.G_EXC_ERROR;
937: END IF; */
938: END;
939:
940: PROCEDURE Create_table_column(

Line 964: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

960:
961:
962:
963: -- Standard call to check for call compatibility.
964: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
965: p_api_version_number,
966: l_api_name,
967: G_PKG_NAME)
968: THEN

Line 969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

965: p_api_version_number,
966: l_api_name,
967: G_PKG_NAME)
968: THEN
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END IF;
971:
972: -- Initialize message list if p_init_msg_list is set to TRUE.
973: IF FND_API.to_Boolean( p_init_msg_list )

Line 973: IF FND_API.to_Boolean( p_init_msg_list )

969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END IF;
971:
972: -- Initialize message list if p_init_msg_list is set to TRUE.
973: IF FND_API.to_Boolean( p_init_msg_list )
974: THEN
975: FND_MSG_PUB.initialize;
976: END IF;
977:

Line 979: x_return_status := FND_API.G_RET_STS_SUCCESS;

975: FND_MSG_PUB.initialize;
976: END IF;
977:
978: -- Initialize API return status to SUCCESS
979: x_return_status := FND_API.G_RET_STS_SUCCESS;
980:
981: --
982: -- API body
983: --

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

981: --
982: -- API body
983: --
984:
985: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
986: THEN
987:
988: -- Check for all the required attributes that are being passed should be there
989: -- and should not be passed as null. If passed as null then raise error

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

995: p_Validate_Rec => l_Table_Column_Rec,
996: x_return_status => x_return_status);
997: END IF;
998:
999: IF (x_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
1000: RAISE FND_API.G_EXC_ERROR;
1001: END IF;
1002:
1003: -- Build an insert record, check if any of the parameters

Line 1000: RAISE FND_API.G_EXC_ERROR;

996: x_return_status => x_return_status);
997: END IF;
998:
999: IF (x_return_status<>FND_API.G_RET_STS_SUCCESS) THEN
1000: RAISE FND_API.G_EXC_ERROR;
1001: END IF;
1002:
1003: -- Build an insert record, check if any of the parameters
1004: -- have been not been passed, if not assign a NULL.

Line 1027: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1023: p_SEEDED_FLAG => l_Table_Column_rec.seeded_flag,
1024: x_OBJECT_VERSION_NUMBER => x_object_version_number );
1025:
1026:
1027: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030:
1031:

Line 1028: RAISE FND_API.G_EXC_ERROR;

1024: x_OBJECT_VERSION_NUMBER => x_object_version_number );
1025:
1026:
1027: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030:
1031:
1032: --

Line 1038: IF FND_API.to_Boolean( p_commit )

1034: --
1035:
1036:
1037: -- Standard check for p_commit
1038: IF FND_API.to_Boolean( p_commit )
1039: THEN
1040: COMMIT WORK;
1041: END IF;
1042:

Line 1050: WHEN FND_API.G_EXC_ERROR THEN

1046: p_count => x_msg_count,
1047: p_data => x_msg_data);
1048:
1049: EXCEPTION
1050: WHEN FND_API.G_EXC_ERROR THEN
1051: ROLLBACK TO CREATE_Table_Column_PVT;
1052: x_return_status := FND_API.G_RET_STS_ERROR ;
1053: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1054: p_data => x_msg_data) ;

Line 1052: x_return_status := FND_API.G_RET_STS_ERROR ;

1048:
1049: EXCEPTION
1050: WHEN FND_API.G_EXC_ERROR THEN
1051: ROLLBACK TO CREATE_Table_Column_PVT;
1052: x_return_status := FND_API.G_RET_STS_ERROR ;
1053: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1054: p_data => x_msg_data) ;
1055: APP_EXCEPTION.RAISE_EXCEPTION;
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1052: x_return_status := FND_API.G_RET_STS_ERROR ;
1053: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1054: p_data => x_msg_data) ;
1055: APP_EXCEPTION.RAISE_EXCEPTION;
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: ROLLBACK TO CREATE_Table_Column_PVT;
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1059: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1060: p_data => x_msg_data) ;

Line 1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1054: p_data => x_msg_data) ;
1055: APP_EXCEPTION.RAISE_EXCEPTION;
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: ROLLBACK TO CREATE_Table_Column_PVT;
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1059: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1060: p_data => x_msg_data) ;
1061: APP_EXCEPTION.RAISE_EXCEPTION;
1062: WHEN OTHERS THEN

Line 1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1060: p_data => x_msg_data) ;
1061: APP_EXCEPTION.RAISE_EXCEPTION;
1062: WHEN OTHERS THEN
1063: ROLLBACK TO CREATE_Table_Column_PVT;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1065: --IF FND_MSG_PUB.Check_Msg_Level
1066: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1067: --THEN
1068: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 1208: IF NOT FND_API.Compatible_API_Call( l_api_version,

1204: -- standard start of API savepoint
1205: SAVEPOINT Update_Profile_Variable_Pvt ;
1206:
1207: -- Standard Call to check API compatibility
1208: IF NOT FND_API.Compatible_API_Call( l_api_version,
1209: p_api_version_number,
1210: l_api_name,
1211: G_PKG_NAME )
1212: THEN

Line 1213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1209: p_api_version_number,
1210: l_api_name,
1211: G_PKG_NAME )
1212: THEN
1213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1214: END IF ;
1215:
1216:
1217: -- Initialize the message list if p_msg_list is set to TRUE

Line 1218: IF FND_API.To_Boolean(p_init_msg_list) THEN

1214: END IF ;
1215:
1216:
1217: -- Initialize the message list if p_msg_list is set to TRUE
1218: IF FND_API.To_Boolean(p_init_msg_list) THEN
1219: FND_MSG_PUB.initialize ;
1220: END IF ;
1221:
1222:

Line 1224: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1220: END IF ;
1221:
1222:
1223: -- Initialize the API Return Success to True
1224: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1225:
1226: -- Fetch the existing Customer Profile Variable Record and lock the record
1227: -- for update.
1228: -- If lock fails we have to abort

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

1233: p_object_version_number => px_object_version_number,
1234: X_PROF_BLOCKS_REC => l_OLD_PROF_VAR_REC,
1235: x_return_status => x_return_status );
1236: -- If any error abort the API
1237: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1238: RAISE FND_API.G_EXC_ERROR;
1239: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1241: END IF;

Line 1238: RAISE FND_API.G_EXC_ERROR;

1234: X_PROF_BLOCKS_REC => l_OLD_PROF_VAR_REC,
1235: x_return_status => x_return_status );
1236: -- If any error abort the API
1237: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1238: RAISE FND_API.G_EXC_ERROR;
1239: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1241: END IF;
1242:

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

1235: x_return_status => x_return_status );
1236: -- If any error abort the API
1237: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1238: RAISE FND_API.G_EXC_ERROR;
1239: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1241: END IF;
1242:
1243:

Line 1240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1236: -- If any error abort the API
1237: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1238: RAISE FND_API.G_EXC_ERROR;
1239: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1241: END IF;
1242:
1243:
1244: -- we have to build the sql statement in advance before

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

1270: p_OTHER_CLAUSE => l_prof_var_rec.OTHER_CLAUSE,
1271: X_SQL_STMNT => l_prof_var_rec.SQL_STMNT,
1272: X_return_status => x_return_status );
1273:
1274: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1275: RAISE FND_API.G_EXC_ERROR;
1276: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1278: END IF;

Line 1275: RAISE FND_API.G_EXC_ERROR;

1271: X_SQL_STMNT => l_prof_var_rec.SQL_STMNT,
1272: X_return_status => x_return_status );
1273:
1274: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1275: RAISE FND_API.G_EXC_ERROR;
1276: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1278: END IF;
1279: ELSE

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

1272: X_return_status => x_return_status );
1273:
1274: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1275: RAISE FND_API.G_EXC_ERROR;
1276: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1278: END IF;
1279: ELSE
1280: l_prof_var_rec.sql_stmnt := l_old_prof_var_rec.sql_stmnt;

Line 1277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1273:
1274: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1275: RAISE FND_API.G_EXC_ERROR;
1276: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1278: END IF;
1279: ELSE
1280: l_prof_var_rec.sql_stmnt := l_old_prof_var_rec.sql_stmnt;
1281: END IF;

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

1301: x_return_status => x_return_status,
1302: x_msg_count =>x_msg_count,
1303: x_msg_data =>x_msg_data );
1304:
1305: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1306: RAISE FND_API.G_EXC_ERROR;
1307: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1309: END IF;

Line 1306: RAISE FND_API.G_EXC_ERROR;

1302: x_msg_count =>x_msg_count,
1303: x_msg_data =>x_msg_data );
1304:
1305: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1306: RAISE FND_API.G_EXC_ERROR;
1307: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1309: END IF;
1310: END IF;

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

1303: x_msg_data =>x_msg_data );
1304:
1305: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1306: RAISE FND_API.G_EXC_ERROR;
1307: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1309: END IF;
1310: END IF;
1311:

Line 1308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1304:
1305: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1306: RAISE FND_API.G_EXC_ERROR;
1307: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1309: END IF;
1310: END IF;
1311:
1312: -- Replace :party_id, cust_acct_id,cust_acct_org_id with

Line 1361: IF FND_API.To_Boolean(p_commit) THEN

1357: p_APPLICATION_ID => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.APPLICATION_ID,l_old_prof_var_rec.application_id));
1358:
1359:
1360: -- Standard check of p_commit
1361: IF FND_API.To_Boolean(p_commit) THEN
1362: COMMIT WORK;
1363: END IF;
1364:
1365: -- Standard call to get message count and if count is 1, get message info

Line 1370: WHEN FND_API.G_EXC_ERROR THEN

1366: FND_MSG_PUB.Count_And_Get(
1367: p_count => x_msg_count,
1368: p_data => x_msg_data );
1369: EXCEPTION
1370: WHEN FND_API.G_EXC_ERROR THEN
1371: ROLLBACK TO Update_Profile_Variable_Pvt;
1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373: --FND_MSG_PUB.Count_And_Get
1374: -- ( p_count => x_msg_count,

Line 1372: x_return_status := FND_API.G_RET_STS_ERROR;

1368: p_data => x_msg_data );
1369: EXCEPTION
1370: WHEN FND_API.G_EXC_ERROR THEN
1371: ROLLBACK TO Update_Profile_Variable_Pvt;
1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373: --FND_MSG_PUB.Count_And_Get
1374: -- ( p_count => x_msg_count,
1375: -- p_data => x_msg_data );
1376: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1373: --FND_MSG_PUB.Count_And_Get
1374: -- ( p_count => x_msg_count,
1375: -- p_data => x_msg_data );
1376: APP_EXCEPTION.RAISE_EXCEPTION;
1377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1378: ROLLBACK TO Update_Profile_Variable_Pvt;
1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1380: --FND_MSG_PUB.Count_And_Get
1381: -- ( p_count => x_msg_count,

Line 1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1375: -- p_data => x_msg_data );
1376: APP_EXCEPTION.RAISE_EXCEPTION;
1377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1378: ROLLBACK TO Update_Profile_Variable_Pvt;
1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1380: --FND_MSG_PUB.Count_And_Get
1381: -- ( p_count => x_msg_count,
1382: -- p_data => x_msg_data );
1383: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1382: -- p_data => x_msg_data );
1383: APP_EXCEPTION.RAISE_EXCEPTION;
1384: WHEN OTHERS THEN
1385: ROLLBACK TO Update_Profile_Variable_Pvt;
1386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1387: -- FND_MSG_PUB.Count_And_Get
1388: -- ( p_count => x_msg_count,
1389: -- p_data => x_msg_data );
1390: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1422: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1418: -- Standard Start of API savepoint
1419: SAVEPOINT UPDATE_Table_Column_PVT;
1420:
1421: -- Standard call to check for call compatibility.
1422: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1423: p_api_version_number,
1424: l_api_name,
1425: G_PKG_NAME)
1426: THEN

Line 1427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1423: p_api_version_number,
1424: l_api_name,
1425: G_PKG_NAME)
1426: THEN
1427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1428: END IF;
1429:
1430:
1431: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1432: IF FND_API.to_Boolean( p_init_msg_list )

1428: END IF;
1429:
1430:
1431: -- Initialize message list if p_init_msg_list is set to TRUE.
1432: IF FND_API.to_Boolean( p_init_msg_list )
1433: THEN
1434: FND_MSG_PUB.initialize;
1435: END IF;
1436:

Line 1439: x_return_status := FND_API.G_RET_STS_SUCCESS;

1435: END IF;
1436:
1437:
1438: -- Initialize API return status to SUCCESS
1439: x_return_status := FND_API.G_RET_STS_SUCCESS;
1440:
1441: --
1442: -- Api body
1443: --

Line 1452: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1448: p_Table_Column_Id => l_table_column_rec.table_column_id,
1449: p_object_version_number => px_object_version_number,
1450: X_Table_Column_Rec => l_old_table_column_rec,
1451: x_return_status => x_return_status);
1452: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1453: RAISE FND_API.G_EXC_ERROR;
1454: END IF;
1455:
1456: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)

Line 1453: RAISE FND_API.G_EXC_ERROR;

1449: p_object_version_number => px_object_version_number,
1450: X_Table_Column_Rec => l_old_table_column_rec,
1451: x_return_status => x_return_status);
1452: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1453: RAISE FND_API.G_EXC_ERROR;
1454: END IF;
1455:
1456: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
1457: THEN

Line 1465: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

1461: p_init_msg_list => p_init_msg_list,
1462: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
1463: P_Validate_Rec => l_Table_Column_Rec,
1464: x_return_status => x_return_status);
1465: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1466: RAISE FND_API.G_EXC_ERROR;
1467: END IF;
1468:
1469: END IF;

Line 1466: RAISE FND_API.G_EXC_ERROR;

1462: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
1463: P_Validate_Rec => l_Table_Column_Rec,
1464: x_return_status => x_return_status);
1465: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1466: RAISE FND_API.G_EXC_ERROR;
1467: END IF;
1468:
1469: END IF;
1470:

Line 1491: IF FND_API.to_Boolean( p_commit )

1487: -- End of API body.
1488: --
1489:
1490: -- Standard check for p_commit
1491: IF FND_API.to_Boolean( p_commit )
1492: THEN
1493: COMMIT WORK;
1494: END IF;
1495:

Line 1505: WHEN FND_API.G_EXC_ERROR THEN

1501: );
1502:
1503: EXCEPTION
1504:
1505: WHEN FND_API.G_EXC_ERROR THEN
1506: ROLLBACK TO UPDATE_Table_Column_PVT;
1507: x_return_status := FND_API.G_RET_STS_ERROR ;
1508: FND_MSG_PUB.Count_And_Get(
1509: p_count =>x_msg_count,

Line 1507: x_return_status := FND_API.G_RET_STS_ERROR ;

1503: EXCEPTION
1504:
1505: WHEN FND_API.G_EXC_ERROR THEN
1506: ROLLBACK TO UPDATE_Table_Column_PVT;
1507: x_return_status := FND_API.G_RET_STS_ERROR ;
1508: FND_MSG_PUB.Count_And_Get(
1509: p_count =>x_msg_count,
1510: p_data => x_msg_data
1511: );

Line 1513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1509: p_count =>x_msg_count,
1510: p_data => x_msg_data
1511: );
1512: APP_EXCEPTION.RAISE_EXCEPTION;
1513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1514: ROLLBACK TO UPDATE_Table_Column_PVT ;
1515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1516: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1517: p_data => x_msg_data) ;

Line 1515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1511: );
1512: APP_EXCEPTION.RAISE_EXCEPTION;
1513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1514: ROLLBACK TO UPDATE_Table_Column_PVT ;
1515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1516: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1517: p_data => x_msg_data) ;
1518: APP_EXCEPTION.RAISE_EXCEPTION;
1519: WHEN OTHERS THEN

Line 1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1517: p_data => x_msg_data) ;
1518: APP_EXCEPTION.RAISE_EXCEPTION;
1519: WHEN OTHERS THEN
1520: ROLLBACK TO UPDATE_Table_Column_PVT ;
1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1522: IF FND_MSG_PUB.Check_Msg_Level
1523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1524: THEN
1525: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);

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

1530: End Update_table_column;
1531:
1532: PROCEDURE Delete_profile_variables(
1533: P_Api_Version_Number IN NUMBER,
1534: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1535: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1536: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1537: p_BLOCK_ID IN NUMBER,
1538: p_OBJECT_VERSION_NUMBER IN NUMBER,

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

1531:
1532: PROCEDURE Delete_profile_variables(
1533: P_Api_Version_Number IN NUMBER,
1534: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1535: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1536: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1537: p_BLOCK_ID IN NUMBER,
1538: p_OBJECT_VERSION_NUMBER IN NUMBER,
1539: X_Return_Status OUT NOCOPY VARCHAR2,

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

1532: PROCEDURE Delete_profile_variables(
1533: P_Api_Version_Number IN NUMBER,
1534: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1535: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1536: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1537: p_BLOCK_ID IN NUMBER,
1538: p_OBJECT_VERSION_NUMBER IN NUMBER,
1539: X_Return_Status OUT NOCOPY VARCHAR2,
1540: X_Msg_Count OUT NOCOPY NUMBER,

Line 1552: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1548: -- Standard Start of API savepoint
1549: SAVEPOINT DELETE_Profile_Variables_PVT;
1550:
1551: -- Standard call to check for call compatibility.
1552: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1553: p_api_version_number,
1554: l_api_name,
1555: G_PKG_NAME)
1556: THEN

Line 1557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1553: p_api_version_number,
1554: l_api_name,
1555: G_PKG_NAME)
1556: THEN
1557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1558: END IF;
1559:
1560:
1561: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1562: IF FND_API.to_Boolean( p_init_msg_list )

1558: END IF;
1559:
1560:
1561: -- Initialize message list if p_init_msg_list is set to TRUE.
1562: IF FND_API.to_Boolean( p_init_msg_list )
1563: THEN
1564: FND_MSG_PUB.initialize;
1565: END IF;
1566:

Line 1569: x_return_status := FND_API.G_RET_STS_SUCCESS;

1565: END IF;
1566:
1567:
1568: -- Initialize API return status to SUCCESS
1569: x_return_status := FND_API.G_RET_STS_SUCCESS;
1570:
1571: --
1572: -- Api body
1573: --

Line 1584: IF FND_API.to_Boolean( p_commit )

1580: -- End of API body
1581: --
1582:
1583: -- Standard check for p_commit
1584: IF FND_API.to_Boolean( p_commit )
1585: THEN
1586: COMMIT WORK;
1587: END IF;
1588:

Line 1597: WHEN FND_API.G_EXC_ERROR THEN

1593: p_data => x_msg_data
1594: );
1595:
1596: EXCEPTION
1597: WHEN FND_API.G_EXC_ERROR THEN
1598: ROLLBACK TO DELETE_Table_Column_PVT;
1599: x_return_status := FND_API.G_RET_STS_ERROR ;
1600: FND_MSG_PUB.Count_And_Get(
1601: p_count =>x_msg_count,

Line 1599: x_return_status := FND_API.G_RET_STS_ERROR ;

1595:
1596: EXCEPTION
1597: WHEN FND_API.G_EXC_ERROR THEN
1598: ROLLBACK TO DELETE_Table_Column_PVT;
1599: x_return_status := FND_API.G_RET_STS_ERROR ;
1600: FND_MSG_PUB.Count_And_Get(
1601: p_count =>x_msg_count,
1602: p_data => x_msg_data
1603: );

Line 1605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1601: p_count =>x_msg_count,
1602: p_data => x_msg_data
1603: );
1604: APP_EXCEPTION.RAISE_EXCEPTION;
1605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1606: ROLLBACK TO DELETE_Table_Column_PVT ;
1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1608: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1609: p_data => x_msg_data) ;

Line 1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1603: );
1604: APP_EXCEPTION.RAISE_EXCEPTION;
1605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1606: ROLLBACK TO DELETE_Table_Column_PVT ;
1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1608: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1609: p_data => x_msg_data) ;
1610: APP_EXCEPTION.RAISE_EXCEPTION;
1611: WHEN OTHERS THEN

Line 1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1609: p_data => x_msg_data) ;
1610: APP_EXCEPTION.RAISE_EXCEPTION;
1611: WHEN OTHERS THEN
1612: ROLLBACK TO DELETE_Table_Column_PVT ;
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1615: THEN
1616: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1617: END IF ;

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

1621: End Delete_profile_variables;
1622:
1623: PROCEDURE Delete_Table_Columns(
1624: P_Api_Version_Number IN NUMBER,
1625: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1626: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1627: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1628: p_BLOCK_ID IN NUMBER,
1629: px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,

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

1622:
1623: PROCEDURE Delete_Table_Columns(
1624: P_Api_Version_Number IN NUMBER,
1625: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1626: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1627: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1628: p_BLOCK_ID IN NUMBER,
1629: px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
1630: X_Return_Status OUT NOCOPY VARCHAR2,

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

1623: PROCEDURE Delete_Table_Columns(
1624: P_Api_Version_Number IN NUMBER,
1625: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1626: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1627: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1628: p_BLOCK_ID IN NUMBER,
1629: px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
1630: X_Return_Status OUT NOCOPY VARCHAR2,
1631: X_Msg_Count OUT NOCOPY NUMBER,

Line 1647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1643: -- Standard Start of API savepoint
1644: SAVEPOINT DELETE_Table_Columns_PVT;
1645:
1646: -- Standard call to check for call compatibility.
1647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1648: p_api_version_number,
1649: l_api_name,
1650: G_PKG_NAME)
1651: THEN

Line 1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1648: p_api_version_number,
1649: l_api_name,
1650: G_PKG_NAME)
1651: THEN
1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1653: END IF;
1654:
1655:
1656: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1657: IF FND_API.to_Boolean( p_init_msg_list )

1653: END IF;
1654:
1655:
1656: -- Initialize message list if p_init_msg_list is set to TRUE.
1657: IF FND_API.to_Boolean( p_init_msg_list )
1658: THEN
1659: FND_MSG_PUB.initialize;
1660: END IF;
1661:

Line 1664: x_return_status := FND_API.G_RET_STS_SUCCESS;

1660: END IF;
1661:
1662:
1663: -- Initialize API return status to SUCCESS
1664: x_return_status := FND_API.G_RET_STS_SUCCESS;
1665:
1666: --
1667: -- Api body
1668: --

Line 1692: IF FND_API.to_Boolean( p_commit )

1688: -- End of API body
1689: --
1690:
1691: -- Standard check for p_commit
1692: IF FND_API.to_Boolean( p_commit )
1693: THEN
1694: COMMIT WORK;
1695: END IF;
1696:

Line 1704: WHEN FND_API.G_EXC_ERROR THEN

1700: p_data => x_msg_data
1701: );
1702:
1703: EXCEPTION
1704: WHEN FND_API.G_EXC_ERROR THEN
1705: ROLLBACK TO DELETE_Table_Columns_PVT;
1706: x_return_status := FND_API.G_RET_STS_ERROR ;
1707: FND_MSG_PUB.Count_And_Get(
1708: p_count =>x_msg_count,

Line 1706: x_return_status := FND_API.G_RET_STS_ERROR ;

1702:
1703: EXCEPTION
1704: WHEN FND_API.G_EXC_ERROR THEN
1705: ROLLBACK TO DELETE_Table_Columns_PVT;
1706: x_return_status := FND_API.G_RET_STS_ERROR ;
1707: FND_MSG_PUB.Count_And_Get(
1708: p_count =>x_msg_count,
1709: p_data => x_msg_data
1710: );

Line 1712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1708: p_count =>x_msg_count,
1709: p_data => x_msg_data
1710: );
1711: APP_EXCEPTION.RAISE_EXCEPTION;
1712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1713: ROLLBACK TO DELETE_Table_Columns_PVT ;
1714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1715: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1716: p_data => x_msg_data) ;

Line 1714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1710: );
1711: APP_EXCEPTION.RAISE_EXCEPTION;
1712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1713: ROLLBACK TO DELETE_Table_Columns_PVT ;
1714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1715: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1716: p_data => x_msg_data) ;
1717: APP_EXCEPTION.RAISE_EXCEPTION;
1718: WHEN OTHERS THEN

Line 1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1716: p_data => x_msg_data) ;
1717: APP_EXCEPTION.RAISE_EXCEPTION;
1718: WHEN OTHERS THEN
1719: ROLLBACK TO DELETE_Table_Columns_PVT ;
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1721: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1722: THEN
1723: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1724: END IF ;

Line 1770: x_return_status := FND_API.G_RET_STS_SUCCESS;

1766: where block_name = p_block_name;
1767: l_dummy number;
1768: BEGIN
1769: -- initialize the return status
1770: x_return_status := FND_API.G_RET_STS_SUCCESS;
1771: -- Check if the validation is called for a create or an
1772: -- update
1773: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN
1774: -- check if the block name is passed in and is NOT NULL

Line 1782: x_return_status := FND_API.G_RET_STS_ERROR;

1778: ( p_block_name IS NOT NULL )) THEN
1779: Open get_block_name;
1780: Fetch get_block_name into l_dummy;
1781: if get_block_name%FOUND then
1782: x_return_status := FND_API.G_RET_STS_ERROR;
1783: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg
1784: ( p_api_name => p_api_name,
1785: p_argument => 'p_block_name' ,
1786: p_argument_value => p_block_name);

Line 1787: x_return_status := FND_API.G_RET_STS_ERROR;

1783: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg
1784: ( p_api_name => p_api_name,
1785: p_argument => 'p_block_name' ,
1786: p_argument_value => p_block_name);
1787: x_return_status := FND_API.G_RET_STS_ERROR;
1788: end if;
1789: Close get_block_name;
1790: ELSE
1791: -- If the block name is not passed or if passed in as NULL write a

Line 1793: x_return_status := FND_API.G_RET_STS_ERROR;

1789: Close get_block_name;
1790: ELSE
1791: -- If the block name is not passed or if passed in as NULL write a
1792: -- mandatory attribute missing message
1793: x_return_status := FND_API.G_RET_STS_ERROR;
1794: CSC_CORE_UTILS_PVT.mandatory_arg_error(
1795: p_api_name => p_api_name,
1796: p_argument => 'p_block_name',
1797: p_argument_value => p_block_name);

Line 1805: x_return_status := FND_API.G_RET_STS_ERROR;

1801: ELSIF p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE THEN
1802: -- if the block name is passed in and as NULL then
1803: -- its a mandatory argument error.
1804: if ( p_block_name IS NULL ) then
1805: x_return_status := FND_API.G_RET_STS_ERROR;
1806: CSC_CORE_UTILS_PVT.mandatory_arg_error(
1807: p_api_name => p_api_name,
1808: p_argument => 'p_block_name',
1809: p_argument_value => p_block_name);

Line 1821: x_return_status := FND_API.G_RET_STS_ERROR;

1817: -- the present one then ignore else raise an
1818: -- duplicate value error as block name should
1819: -- be unique
1820: if l_dummy <> p_block_id then
1821: x_return_status := FND_API.G_RET_STS_ERROR;
1822: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg
1823: ( p_api_name => p_api_name,
1824: p_argument => 'p_block_name' ,
1825: p_argument_value => p_block_name);

Line 1826: x_return_status := FND_API.G_RET_STS_ERROR;

1822: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg
1823: ( p_api_name => p_api_name,
1824: p_argument => 'p_block_name' ,
1825: p_argument_value => p_block_name);
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827: exit;
1828: else
1829: exit;
1830: end if;

Line 1859: x_return_status := FND_API.G_RET_STS_SUCCESS;

1855: ) IS
1856: --
1857: BEGIN
1858: --
1859: x_return_status := FND_API.G_RET_STS_SUCCESS;
1860:
1861: -- check if the seeded flag is passed in and is not
1862: -- null, if passed in check if the lookup code
1863: -- exists in fnd lookups for this date, if not

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

1866: ( p_seeded_flag IS NOT NULL )) THEN
1867: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
1868: p_effective_date => trunc(sysdate),
1869: p_lookup_type => 'YES_NO',
1870: p_lookup_code => p_seeded_flag ) <> FND_API.G_RET_STS_SUCCESS
1871: THEN
1872: x_return_status := FND_API.G_RET_STS_ERROR;
1873: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,
1874: p_argument_value => p_seeded_flag,

Line 1872: x_return_status := FND_API.G_RET_STS_ERROR;

1868: p_effective_date => trunc(sysdate),
1869: p_lookup_type => 'YES_NO',
1870: p_lookup_code => p_seeded_flag ) <> FND_API.G_RET_STS_SUCCESS
1871: THEN
1872: x_return_status := FND_API.G_RET_STS_ERROR;
1873: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,
1874: p_argument_value => p_seeded_flag,
1875: p_argument => p_parameter_name);
1876: END IF;

Line 1889: x_return_status := FND_API.G_RET_STS_SUCCESS;

1885: ) IS
1886: --
1887: BEGIN
1888: --
1889: x_return_status := FND_API.G_RET_STS_SUCCESS;
1890:
1891: -- check if the block_level is passed in and is not
1892: -- null
1893:

Line 1900: x_return_status := FND_API.G_RET_STS_ERROR;

1896: -- Commented the following code by spamujul for NCR ER# 8473903
1897: -- IF (p_block_level <> 'PARTY' AND p_block_level <> 'ACCOUNT' AND p_block_level <> 'CONTACT' AND p_block_level <> 'EMPLOYEE')
1898: IF (p_block_level <> 'PARTY' AND p_block_level <> 'ACCOUNT' AND p_block_level <> 'CONTACT' AND p_block_level <> 'EMPLOYEE' AND p_block_level <> 'SITE')
1899: THEN
1900: x_return_status := FND_API.G_RET_STS_ERROR;
1901: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,
1902: p_argument_value => p_block_level,
1903: p_argument => p_parameter_name);
1904: END IF;

Line 1931: x_return_status := FND_API.G_RET_STS_SUCCESS;

1927: IS
1928: --
1929: BEGIN
1930: --
1931: x_return_status := FND_API.G_RET_STS_SUCCESS;
1932:
1933: -- if the currency code is passed in and is not null,
1934: -- validate the currency code.
1935: IF (( p_currency_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND

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

1936: ( p_currency_code IS NOT NULL )) then
1937:
1938: IF CSC_CORE_UTILS_PVT.Currency_code_not_exists(
1939: p_effective_date => sysdate,
1940: p_currency_code => p_currency_code ) <> FND_API.G_RET_STS_SUCCESS THEN
1941:
1942: -- if the currency code is not valid its an invalid argument
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,

Line 1943: x_return_status := FND_API.G_RET_STS_ERROR;

1939: p_effective_date => sysdate,
1940: p_currency_code => p_currency_code ) <> FND_API.G_RET_STS_SUCCESS THEN
1941:
1942: -- if the currency code is not valid its an invalid argument
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,
1945: p_argument_value => p_currency_code,
1946: p_argument => p_parameter_name);
1947:

Line 1976: x_return_status := FND_API.G_RET_STS_SUCCESS;

1972: l_sql_cur_hdl INT;
1973: BEGIN
1974:
1975: -- initialize the return status to SUCCESS
1976: x_return_status := FND_API.G_RET_STS_SUCCESS;
1977:
1978: -- if the sql_statement is passed in and if its NOT NULL then
1979: -- validate the sql_statement by parsing it using the dbms_sql
1980: -- package.

Line 1986: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1982: CSC_CORE_UTILS_PVT.Validate_Sql_Stmnt(
1983: p_sql_stmnt => p_sql_Stmnt,
1984: x_return_status => X_return_status);
1985:
1986: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1987:
1988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1989: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1990: p_api_name => p_api_name,

Line 1988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1984: x_return_status => X_return_status);
1985:
1986: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1987:
1988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1989: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1990: p_api_name => p_api_name,
1991: p_argument_value => p_sql_stmnt,
1992: p_argument => p_parameter_name);

Line 2014: x_return_status := FND_API.G_RET_STS_SUCCESS;

2010: where object_code = p_object_code;
2011: BEGIN
2012:
2013: -- initialize the return status to SUCCESS
2014: x_return_status := FND_API.G_RET_STS_SUCCESS;
2015:
2016: IF ((p_Object_Code IS NOT NULL) AND
2017: (p_Object_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR )) THEN
2018: Open get_object_csr;

Line 2021: x_return_status := FND_API.G_RET_STS_ERROR;

2017: (p_Object_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR )) THEN
2018: Open get_object_csr;
2019: Fetch get_object_csr into l_dummy;
2020: IF get_object_csr%NOTFOUND THEN
2021: x_return_status := FND_API.G_RET_STS_ERROR;
2022: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
2023: p_api_name => p_api_name,
2024: p_argument_value => p_object_code,
2025: p_argument => p_parameter_name);

Line 2051: x_return_status := FND_API.G_RET_STS_SUCCESS;

2047: from csc_prof_blocks_b
2048: where block_name_code = p_block_name_code;
2049:
2050: BEGIN
2051: x_return_status := FND_API.G_RET_STS_SUCCESS;
2052:
2053: -- Check if the validation is called for a Create or
2054: -- an update
2055: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN

Line 2064: x_return_status := FND_API.G_RET_STS_ERROR;

2060: open get_block_code;
2061: fetch get_block_code into l_dummy;
2062: if get_block_code%FOUND then
2063: -- if not valid an invalid argument message
2064: x_return_status := FND_API.G_RET_STS_ERROR;
2065: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
2066: p_api_name => p_api_name,
2067: p_argument_value => p_block_name_code,
2068: p_argument => p_parameter_name );

Line 2074: x_return_status := FND_API.G_RET_STS_ERROR;

2070: close get_block_code;
2071: else
2072: -- if block_name_code is not passed in or if passed
2073: -- in as null raise a mandatory argument error.
2074: x_return_status := FND_API.G_RET_STS_ERROR;
2075: CSC_CORE_UTILS_PVT.mandatory_arg_error(
2076: p_api_name => p_api_name,
2077: p_argument => 'p_block_name_code',
2078: p_argument_value => p_block_name_code);

Line 2086: x_return_status := FND_API.G_RET_STS_ERROR;

2082: -- if the block_name_code is passed in as NULL
2083: -- its an error else validate.
2084: if p_block_name_code IS NULL THEN
2085: -- write a mandatory attributes missing message
2086: x_return_status := FND_API.G_RET_STS_ERROR;
2087: CSC_CORE_UTILS_PVT.mandatory_arg_error(
2088: p_api_name => p_api_name,
2089: p_argument => 'p_block_name_code',
2090: p_argument_value => p_block_name_code);

Line 2099: x_return_status := FND_API.G_RET_STS_ERROR;

2095: -- if the block_name_code passed in is the same as
2096: -- the present one then ignore else raise an duplicate
2097: -- value error as block_name_code should be unique
2098: if l_dummy <> p_block_id then
2099: x_return_status := FND_API.G_RET_STS_ERROR;
2100: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg
2101: ( p_api_name => p_api_name,
2102: p_argument => 'p_block_name_code' ,
2103: p_argument_value => p_block_name_code);

Line 2124: x_return_status := FND_API.G_RET_STS_SUCCESS;

2120: x_msg_data OUT NOCOPY VARCHAR2 )
2121: IS
2122: BEGIN
2123: -- Initialize return status to success
2124: x_return_status := FND_API.G_RET_STS_SUCCESS;
2125: -- Validate Block_Name
2126: Validate_Block_Name(
2127: p_api_name => p_api_name,
2128: p_validation_mode => p_validation_mode,

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

2129: p_block_name => p_validate_rec.block_name,
2130: p_block_id => p_Validate_rec.block_id,
2131: x_return_status => x_return_status
2132: );
2133: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2134: RAISE FND_API.G_EXC_ERROR;
2135: END IF;
2136:
2137: -- validate start and end date

Line 2134: RAISE FND_API.G_EXC_ERROR;

2130: p_block_id => p_Validate_rec.block_id,
2131: x_return_status => x_return_status
2132: );
2133: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2134: RAISE FND_API.G_EXC_ERROR;
2135: END IF;
2136:
2137: -- validate start and end date
2138: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(

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

2139: p_api_name => p_Api_name,
2140: p_start_date => p_validate_rec.start_date_active,
2141: p_end_date => p_validate_rec.end_date_active,
2142: x_return_status => x_return_status );
2143: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2144: RAISE FND_API.G_EXC_ERROR;
2145: END IF;
2146:
2147: --Validate seeded flag

Line 2144: RAISE FND_API.G_EXC_ERROR;

2140: p_start_date => p_validate_rec.start_date_active,
2141: p_end_date => p_validate_rec.end_date_active,
2142: x_return_status => x_return_status );
2143: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2144: RAISE FND_API.G_EXC_ERROR;
2145: END IF;
2146:
2147: --Validate seeded flag
2148: Validate_Seeded_Flag(

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

2149: p_api_name => p_api_name,
2150: p_parameter_name => 'p_Seeded_Flag',
2151: p_seeded_flag => p_validate_rec.seeded_flag,
2152: x_return_status => x_return_status );
2153: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2154: RAISE FND_API.G_EXC_ERROR;
2155: END IF;
2156:
2157: --Validate Block_level

Line 2154: RAISE FND_API.G_EXC_ERROR;

2150: p_parameter_name => 'p_Seeded_Flag',
2151: p_seeded_flag => p_validate_rec.seeded_flag,
2152: x_return_status => x_return_status );
2153: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2154: RAISE FND_API.G_EXC_ERROR;
2155: END IF;
2156:
2157: --Validate Block_level
2158: Validate_Block_Level(

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

2159: p_api_name => p_api_name,
2160: p_parameter_name => 'p_Block_Level',
2161: p_block_level => p_validate_rec.block_level,
2162: x_return_status => x_return_status );
2163: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2164: RAISE FND_API.G_EXC_ERROR;
2165: END IF;
2166:
2167: -- Validate Sql Statement

Line 2164: RAISE FND_API.G_EXC_ERROR;

2160: p_parameter_name => 'p_Block_Level',
2161: p_block_level => p_validate_rec.block_level,
2162: x_return_status => x_return_status );
2163: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2164: RAISE FND_API.G_EXC_ERROR;
2165: END IF;
2166:
2167: -- Validate Sql Statement
2168: Validate_Sql_stmnt(

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

2169: p_api_name => p_api_name,
2170: p_parameter_name => 'p_sql_stmnt',
2171: p_sql_Stmnt => p_validate_rec.sql_stmnt,
2172: x_return_status => x_return_status );
2173: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2174: RAISE FND_API.G_EXC_ERROR;
2175: END IF;
2176: -- Validate Batch Sql Statement
2177: Validate_Sql_stmnt(

Line 2174: RAISE FND_API.G_EXC_ERROR;

2170: p_parameter_name => 'p_sql_stmnt',
2171: p_sql_Stmnt => p_validate_rec.sql_stmnt,
2172: x_return_status => x_return_status );
2173: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2174: RAISE FND_API.G_EXC_ERROR;
2175: END IF;
2176: -- Validate Batch Sql Statement
2177: Validate_Sql_stmnt(
2178: p_api_name => p_api_name,

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

2178: p_api_name => p_api_name,
2179: p_parameter_name => 'p_batch_sql_stmnt',
2180: p_sql_Stmnt => p_validate_rec.batch_sql_stmnt,
2181: x_return_status => x_return_status );
2182: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2183: RAISE FND_API.G_EXC_ERROR;
2184: END IF;
2185: -- Validate Currency code
2186: Validate_Currency_Code(

Line 2183: RAISE FND_API.G_EXC_ERROR;

2179: p_parameter_name => 'p_batch_sql_stmnt',
2180: p_sql_Stmnt => p_validate_rec.batch_sql_stmnt,
2181: x_return_status => x_return_status );
2182: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2183: RAISE FND_API.G_EXC_ERROR;
2184: END IF;
2185: -- Validate Currency code
2186: Validate_Currency_Code(
2187: p_Api_name => p_api_name,

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

2188: p_parameter_name => 'p_currency_code',
2189: p_currency_code => p_validate_rec.currency_code,
2190: x_return_status => x_return_status );
2191:
2192: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2193: RAISE FND_API.G_EXC_ERROR;
2194: END IF;
2195:
2196: -- validate block name code

Line 2193: RAISE FND_API.G_EXC_ERROR;

2189: p_currency_code => p_validate_rec.currency_code,
2190: x_return_status => x_return_status );
2191:
2192: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2193: RAISE FND_API.G_EXC_ERROR;
2194: END IF;
2195:
2196: -- validate block name code
2197: Validate_block_name_Code(

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

2200: p_block_name_code => p_validate_rec.block_name_code,
2201: p_block_id => p_validate_rec.block_id,
2202: p_validation_mode => p_Validation_mode,
2203: x_return_status => x_return_status );
2204: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2205: RAISE FND_API.G_EXC_ERROR;
2206: END IF;
2207:
2208: -- Validate object code

Line 2205: RAISE FND_API.G_EXC_ERROR;

2201: p_block_id => p_validate_rec.block_id,
2202: p_validation_mode => p_Validation_mode,
2203: x_return_status => x_return_status );
2204: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2205: RAISE FND_API.G_EXC_ERROR;
2206: END IF;
2207:
2208: -- Validate object code
2209: Validate_Object_Id(

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

2211: p_parameter_Name => 'P_OBJECT_CODE',
2212: p_object_code => p_validate_rec.object_code,
2213: x_return_status => x_return_status );
2214:
2215: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2216: RAISE FND_API.G_EXC_ERROR;
2217: END IF;
2218:
2219: /* This Call added for Enhancement 1781726 for Validating Application_id*/

Line 2216: RAISE FND_API.G_EXC_ERROR;

2212: p_object_code => p_validate_rec.object_code,
2213: x_return_status => x_return_status );
2214:
2215: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2216: RAISE FND_API.G_EXC_ERROR;
2217: END IF;
2218:
2219: /* This Call added for Enhancement 1781726 for Validating Application_id*/
2220: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (

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

2224: X_Msg_Count => x_msg_count,
2225: X_Msg_Data => x_msg_data,
2226: p_effective_date => SYSDATE );
2227:
2228: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2229: RAISE FND_API.G_EXC_ERROR;
2230: END IF;
2231:
2232: END Validate_Profile_Variables;

Line 2229: RAISE FND_API.G_EXC_ERROR;

2225: X_Msg_Data => x_msg_data,
2226: p_effective_date => SYSDATE );
2227:
2228: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2229: RAISE FND_API.G_EXC_ERROR;
2230: END IF;
2231:
2232: END Validate_Profile_Variables;
2233:

Line 2266: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2262:
2263: Begin
2264:
2265: -- Initialize the p_return_status to TRUE
2266: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2267:
2268:
2269: OPEN C_get_prof_rec;
2270: FETCH C_get_prof_rec INTO X_PROF_BLOCKS_REC;

Line 2276: x_return_status := FND_API.G_RET_STS_ERROR;

2272: CLOSE C_Get_prof_Rec;
2273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2274: THEN
2275: CSC_CORE_UTILS_PVT.Record_IS_LOCKED_MSG(p_API_NAME=> 'CSC_PROF_BLOCKS');
2276: x_return_status := FND_API.G_RET_STS_ERROR;
2277: END IF;
2278: raise FND_API.G_EXC_ERROR;
2279: END IF;
2280: IF C_GET_prof_Rec%ISOPEN THEN

Line 2278: raise FND_API.G_EXC_ERROR;

2274: THEN
2275: CSC_CORE_UTILS_PVT.Record_IS_LOCKED_MSG(p_API_NAME=> 'CSC_PROF_BLOCKS');
2276: x_return_status := FND_API.G_RET_STS_ERROR;
2277: END IF;
2278: raise FND_API.G_EXC_ERROR;
2279: END IF;
2280: IF C_GET_prof_Rec%ISOPEN THEN
2281: CLOSE C_Get_Prof_Rec;
2282: END IF;

Line 2325: x_return_status := FND_API.G_RET_STS_SUCCESS;

2321: And object_version_number = p_object_version_number
2322: For Update NOWAIT;
2323: BEGIN
2324: -- initialze the return status
2325: x_return_status := FND_API.G_RET_STS_SUCCESS;
2326:
2327: OPEN C_get_table_column_rec;
2328: FETCH C_get_table_column_rec INTO X_TABLE_COLUMN_REC;
2329: IF C_get_table_column_rec%NOTFOUND THEN

Line 2334: x_return_status := FND_API.G_RET_STS_ERROR;

2330: CLOSE C_Get_Table_Column_rec;
2331: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2332: THEN
2333: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_API_NAME=>'CSC_PROF_TABLE_COLUMNS');
2334: x_return_status := FND_API.G_RET_STS_ERROR;
2335: END IF;
2336: raise FND_API.G_EXC_ERROR;
2337: END IF;
2338: IF C_Get_table_Column_rec%ISOPEN THEN

Line 2336: raise FND_API.G_EXC_ERROR;

2332: THEN
2333: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_API_NAME=>'CSC_PROF_TABLE_COLUMNS');
2334: x_return_status := FND_API.G_RET_STS_ERROR;
2335: END IF;
2336: raise FND_API.G_EXC_ERROR;
2337: END IF;
2338: IF C_Get_table_Column_rec%ISOPEN THEN
2339: CLOSE C_get_table_Column_rec;
2340: END IF;

Line 2376: l_return_status := FND_API.G_RET_STS_SUCCESS;

2372: l_return_status VARCHAR2(30);
2373: BEGIN
2374:
2375: -- Initlaize the return status to SUCCESS
2376: l_return_status := FND_API.G_RET_STS_SUCCESS;
2377:
2378: Open get_block_id;
2379: Fetch get_block_id into l_dummy;
2380: IF get_block_id%NOTFOUND THEN

Line 2381: l_return_status := FND_API.G_RET_STS_ERROR;

2377:
2378: Open get_block_id;
2379: Fetch get_block_id into l_dummy;
2380: IF get_block_id%NOTFOUND THEN
2381: l_return_status := FND_API.G_RET_STS_ERROR;
2382: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
2383: p_api_name => p_api_name,
2384: p_argument_value => to_char(p_block_id),
2385: p_argument => 'p_block_id' );

Line 2396: x_return_status := FND_API.G_RET_STS_SUCCESS;

2392:
2393:
2394:
2395: -- Initlaize the return status to SUCCESS
2396: x_return_status := FND_API.G_RET_STS_SUCCESS;
2397:
2398:
2399: --
2400: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN

Line 2407: x_return_status := FND_API.G_RET_STS_ERROR;

2403: ( p_block_id IS NOT NULL )
2404: THEN
2405: x_return_status := chk_block_id( p_block_id );
2406: ELSE
2407: x_return_status := FND_API.G_RET_STS_ERROR;
2408: CSC_CORE_UTILS_PVT.mandatory_arg_error(
2409: p_api_name => p_api_name,
2410: p_argument => 'p_block_id',
2411: p_argument_value => p_block_id);

Line 2421: x_return_status := FND_API.G_RET_STS_ERROR;

2417: THEN
2418: IF (p_block_id IS NOT NULL ) THEN
2419: x_return_status := chk_block_id( p_block_id );
2420: ELSE
2421: x_return_status := FND_API.G_RET_STS_ERROR;
2422: CSC_CORE_UTILS_PVT.mandatory_arg_error(
2423: p_api_name => p_api_name,
2424: p_argument => 'p_block_id',
2425: p_argument_value => p_block_id);

Line 2455: x_return_status := FND_API.G_RET_STS_SUCCESS;

2451: where view_name = p_table_name;
2452: BEGIN
2453:
2454: -- Initialize API return status to SUCCESS
2455: x_return_status := FND_API.G_RET_STS_SUCCESS;
2456:
2457: IF p_TABLE_NAME is not NULL and p_TABLE_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
2458: THEN
2459: Open get_tname_csr;

Line 2465: x_return_status := FND_API.G_RET_STS_ERROR;

2461: IF get_tname_csr%NOTFOUND THEN
2462: Open get_vname_csr;
2463: Fetch get_vname_csr into l_dummy;
2464: IF get_vname_csr%NOTFOUND THEN
2465: x_return_status := FND_API.G_RET_STS_ERROR;
2466: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
2467: p_api_name => p_api_name,
2468: p_argument_value => p_table_name,
2469: p_argument => 'p_Table_Name' );

Line 2499: x_return_status := FND_API.G_RET_STS_SUCCESS;

2495: l_dummy VARCHAR2(10);
2496: BEGIN
2497:
2498: -- Initialize API return status to SUCCESS
2499: x_return_status := FND_API.G_RET_STS_SUCCESS;
2500:
2501:
2502: IF p_COLUMN_NAME is not NULL and p_COLUMN_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
2503: THEN

Line 2510: x_return_status := FND_API.G_RET_STS_ERROR;

2506: IF get_cname_csr%NOTFOUND THEN
2507: Open get_vcname_csr;
2508: Fetch get_vcname_csr into l_dummy;
2509: IF get_vcname_csr%NOTFOUND THEN
2510: x_return_status := FND_API.G_RET_STS_ERROR;
2511: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
2512: p_api_name => p_api_name,
2513: p_argument_value => p_column_name,
2514: p_argument => 'p_Column_Name' );

Line 2534: x_return_status := FND_API.G_RET_STS_SUCCESS;

2530: IS
2531: BEGIN
2532:
2533: -- Initialize API return status to SUCCESS
2534: x_return_status := FND_API.G_RET_STS_SUCCESS;
2535:
2536: Validate_COLUMN_NAME (
2537: p_api_name => p_api_name,
2538: P_Validation_mode => p_validation_mode,

Line 2542: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2538: P_Validation_mode => p_validation_mode,
2539: P_COLUMN_NAME => p_Validate_rec.column_name,
2540: X_Return_Status => x_return_status
2541: );
2542: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2543: raise FND_API.G_EXC_ERROR;
2544: END IF;
2545:
2546: Validate_TABLE_NAME (

Line 2543: raise FND_API.G_EXC_ERROR;

2539: P_COLUMN_NAME => p_Validate_rec.column_name,
2540: X_Return_Status => x_return_status
2541: );
2542: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2543: raise FND_API.G_EXC_ERROR;
2544: END IF;
2545:
2546: Validate_TABLE_NAME (
2547: p_api_name => p_api_name,

Line 2552: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2548: P_Validation_mode => p_validation_mode,
2549: P_TABLE_NAME => p_Validate_rec.table_name,
2550: X_Return_Status => x_return_status
2551: );
2552: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2553: raise FND_API.G_EXC_ERROR;
2554: END IF;
2555:
2556: Validate_Block_Id (

Line 2553: raise FND_API.G_EXC_ERROR;

2549: P_TABLE_NAME => p_Validate_rec.table_name,
2550: X_Return_Status => x_return_status
2551: );
2552: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2553: raise FND_API.G_EXC_ERROR;
2554: END IF;
2555:
2556: Validate_Block_Id (
2557: p_api_name => p_api_name,

Line 2562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2558: p_validation_mode => p_validation_mode,
2559: p_block_id => p_Validate_rec.block_id,
2560: x_return_status => x_return_status
2561: );
2562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2563: raise FND_API.G_EXC_ERROR;
2564: END IF;
2565:
2566:

Line 2563: raise FND_API.G_EXC_ERROR;

2559: p_block_id => p_Validate_rec.block_id,
2560: x_return_status => x_return_status
2561: );
2562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2563: raise FND_API.G_EXC_ERROR;
2564: END IF;
2565:
2566:
2567: IF p_validate_rec.COLUMN_SEQUENCE is NULL THEN