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 CSC_CORE_UTILS_PVT

Line 23: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE

19: -- and Other_clause to build an sql statement which will be stored in
20: -- the sql_statement column in cs_prof_blocks table.
21: -- Input Parameters
22: -- p_api_name, standard parameter for writting messages
23: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
24: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
25: -- p_sql_statement, concatented field using select_Clause, from_clause
26: -- where_clause and Other_Clause columns using the Build_Sql_Stmnt
27: -- procedure

Line 24: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

20: -- the sql_statement column in cs_prof_blocks table.
21: -- Input Parameters
22: -- p_api_name, standard parameter for writting messages
23: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
24: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
25: -- p_sql_statement, concatented field using select_Clause, from_clause
26: -- where_clause and Other_Clause columns using the Build_Sql_Stmnt
27: -- procedure
28: -- Out Parameters

Line 50: ( p_Select_Clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR ) and

46: -- is NULL or missing, if so we cannot form an
47: -- sql_statement.
48:
49: IF (p_Select_Clause IS NULL ) and
50: ( p_Select_Clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR ) and
51: ( p_from_Clause IS NULL ) and
52: ( p_from_Clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR )
53: THEN
54: -- invalid arguments exception

Line 52: ( p_from_Clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR )

48:
49: IF (p_Select_Clause IS NULL ) and
50: ( p_Select_Clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR ) and
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,

Line 56: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg( p_api_name => p_api_name,

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: );
60: END IF;

Line 61: CSC_CORE_UTILS_PVT.Build_Sql_Stmnt

57: p_argument_value => p_select_clause||' '||p_from_clause,
58: p_argument => 'p_Sql_Stmnt'
59: );
60: END IF;
61: CSC_CORE_UTILS_PVT.Build_Sql_Stmnt
62: ( p_select_clause => p_SELECT_CLAUSE,
63: p_from_clause => p_FROM_CLAUSE,
64: p_where_clause => p_WHERE_CLAUSE,
65: p_other_clause => p_OTHER_CLAUSE,

Line 71: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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'
75: );

Line 610: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

606: -- ----------------------------------------------------------------------------
607:
608: PROCEDURE Create_Profile_Variable(
609: p_api_version_number IN NUMBER,
610: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
611: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
612: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
613: x_return_status OUT NOCOPY VARCHAR2,
614: x_msg_count OUT NOCOPY NUMBER,

Line 611: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

607:
608: PROCEDURE Create_Profile_Variable(
609: p_api_version_number IN NUMBER,
610: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
611: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
612: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
613: x_return_status OUT NOCOPY VARCHAR2,
614: x_msg_count OUT NOCOPY NUMBER,
615: x_msg_data OUT NOCOPY VARCHAR2,

Line 612: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

608: PROCEDURE Create_Profile_Variable(
609: p_api_version_number IN NUMBER,
610: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
611: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
612: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
613: x_return_status OUT NOCOPY VARCHAR2,
614: x_msg_count OUT NOCOPY NUMBER,
615: x_msg_data OUT NOCOPY VARCHAR2,
616: p_block_name IN VARCHAR2,

Line 688: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

684: END;
685: --> with record type
686: PROCEDURE Create_Profile_Variable(
687: p_api_version_number IN NUMBER,
688: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
689: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
690: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
691: p_prof_var_rec IN ProfVar_Rec_Type := G_MISS_PROF_REC,
692: x_msg_data OUT NOCOPY VARCHAR2,

Line 689: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

685: --> with record type
686: PROCEDURE Create_Profile_Variable(
687: p_api_version_number IN NUMBER,
688: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
689: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
690: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
691: p_prof_var_rec IN ProfVar_Rec_Type := G_MISS_PROF_REC,
692: x_msg_data OUT NOCOPY VARCHAR2,
693: x_msg_count OUT NOCOPY NUMBER,

Line 690: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

686: PROCEDURE Create_Profile_Variable(
687: p_api_version_number IN NUMBER,
688: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
689: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
690: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
691: p_prof_var_rec IN ProfVar_Rec_Type := G_MISS_PROF_REC,
692: x_msg_data OUT NOCOPY VARCHAR2,
693: x_msg_count OUT NOCOPY NUMBER,
694: x_return_status OUT NOCOPY VARCHAR2,

Line 731: IF p_prof_var_rec.select_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN

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
731: IF p_prof_var_rec.select_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
732: l_prof_var_rec.select_clause := NULL;
733: END IF;
734: IF p_prof_var_rec.from_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
735: l_prof_var_rec.from_clause := NULL;

Line 734: IF p_prof_var_rec.from_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN

730: /* jamose duplicate validation; validated under build_sql_stmnt
731: IF p_prof_var_rec.select_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
732: l_prof_var_rec.select_clause := NULL;
733: END IF;
734: IF p_prof_var_rec.from_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
735: l_prof_var_rec.from_clause := NULL;
736: END IF;
737: -- jamose */
738: IF p_prof_var_rec.where_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN

Line 738: IF p_prof_var_rec.where_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN

734: IF p_prof_var_rec.from_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
735: l_prof_var_rec.from_clause := NULL;
736: END IF;
737: -- jamose */
738: IF p_prof_var_rec.where_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
739: l_prof_var_rec.where_clause := NULL;
740: END IF;
741: IF p_prof_var_rec.other_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
742: l_prof_var_rec.other_clause := NULL;

Line 741: IF p_prof_var_rec.other_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN

737: -- jamose */
738: IF p_prof_var_rec.where_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
739: l_prof_var_rec.where_clause := NULL;
740: END IF;
741: IF p_prof_var_rec.other_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
742: l_prof_var_rec.other_clause := NULL;
743: END IF;
744: Build_Sql_Stmnt( p_api_name => l_api_name,
745: p_select_clause => l_prof_var_rec.select_clause,

Line 760: IF (p_validation_level > CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN

756: -- ----------------------------------------------------------------------
757: -- Apply business-rule validation to all required and passed parameters
758: -- if validation level is set.
759: -- ----------------------------------------------------------------------
760: IF (p_validation_level > CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN
761: -- Check for all the required attributes that are being passed should be there
762: -- and should not be passed as null. If passed as null then we will raise error
763: -- Also Check if Seeded_Flag = 'Y' and then allow / disallow updates
764: -- of certain fields

Line 768: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,

764: -- of certain fields
765:
766: Validate_Profile_Variables(
767: p_api_name => l_api_name_full,
768: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
769: P_validate_rec => l_prof_var_rec,
770: x_return_status => x_return_status,
771: x_msg_count =>x_msg_count,
772: x_msg_data =>x_msg_data );

Line 879: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

875: END Create_Profile_Variable ;
876:
877: PROCEDURE Create_table_column(
878: P_Api_Version_Number IN NUMBER,
879: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
880: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
881: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
882: p_Table_Column_Tbl IN Table_Column_Tbl_Type := G_MISS_Table_Column_TBL,
883: X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,

Line 880: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

876:
877: PROCEDURE Create_table_column(
878: P_Api_Version_Number IN NUMBER,
879: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
880: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
881: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
882: p_Table_Column_Tbl IN Table_Column_Tbl_Type := G_MISS_Table_Column_TBL,
883: X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,
884: X_object_version_number OUT NOCOPY NUMBER,

Line 881: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

877: PROCEDURE Create_table_column(
878: P_Api_Version_Number IN NUMBER,
879: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
880: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
881: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
882: p_Table_Column_Tbl IN Table_Column_Tbl_Type := G_MISS_Table_Column_TBL,
883: X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,
884: X_object_version_number OUT NOCOPY NUMBER,
885: X_Return_Status OUT NOCOPY VARCHAR2,

Line 927: p_validation_level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE,

923: where block_id = p_table_column_rec.block_id;
924:
925: Update_Profile_Variable(
926: p_api_version_number => 1.0,
927: p_validation_level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE,
928: x_return_status => x_return_status,
929: x_msg_count => x_msg_count,
930: x_msg_data => x_msg_data,
931: px_object_version_number => l_object_version_number,

Line 942: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

938: END;
939:
940: PROCEDURE Create_table_column(
941: P_Api_Version_Number IN NUMBER,
942: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
943: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
944: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
945: p_Table_Column_REC IN Table_Column_Rec_Type := G_MISS_Table_Column_REC,
946: X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,

Line 943: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

939:
940: PROCEDURE Create_table_column(
941: P_Api_Version_Number IN NUMBER,
942: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
943: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
944: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
945: p_Table_Column_REC IN Table_Column_Rec_Type := G_MISS_Table_Column_REC,
946: X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,
947: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,

Line 944: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

940: PROCEDURE Create_table_column(
941: P_Api_Version_Number IN NUMBER,
942: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
943: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
944: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
945: p_Table_Column_REC IN Table_Column_Rec_Type := G_MISS_Table_Column_REC,
946: X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,
947: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
948: X_Return_Status OUT NOCOPY VARCHAR2,

Line 994: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,

990:
991: Validate_table_column(
992: p_api_name => l_api_name,
993: p_Init_Msg_List => p_Init_Msg_List,
994: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
995: p_Validate_Rec => l_Table_Column_Rec,
996: x_return_status => x_return_status);
997: END IF;
998:

Line 1090: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

1086: -- ----------------------------------------------------------------------------
1087:
1088: PROCEDURE Update_Profile_Variable(
1089: p_api_version_number IN NUMBER,
1090: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1091: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1092: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1093: x_return_status OUT NOCOPY VARCHAR2,
1094: x_msg_count OUT NOCOPY NUMBER,

Line 1091: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

1087:
1088: PROCEDURE Update_Profile_Variable(
1089: p_api_version_number IN NUMBER,
1090: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1091: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1092: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1093: x_return_status OUT NOCOPY VARCHAR2,
1094: x_msg_count OUT NOCOPY NUMBER,
1095: x_msg_data OUT NOCOPY VARCHAR2,

Line 1092: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

1088: PROCEDURE Update_Profile_Variable(
1089: p_api_version_number IN NUMBER,
1090: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1091: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1092: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1093: x_return_status OUT NOCOPY VARCHAR2,
1094: x_msg_count OUT NOCOPY NUMBER,
1095: x_msg_data OUT NOCOPY VARCHAR2,
1096: p_block_id IN NUMBER ,

Line 1184: p_init_msg_list IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,

1180: -- ----------------------------------------------------------------------------
1181:
1182: PROCEDURE Update_Profile_Variable(
1183: p_api_version_number IN NUMBER,
1184: p_init_msg_list IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,
1185: p_commit IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,
1186: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1187: p_prof_var_rec IN ProfVar_Rec_Type := G_MISS_PROF_REC,
1188: px_Object_Version_Number IN OUT NOCOPY NUMBER,

Line 1185: p_commit IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,

1181:
1182: PROCEDURE Update_Profile_Variable(
1183: p_api_version_number IN NUMBER,
1184: p_init_msg_list IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,
1185: p_commit IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,
1186: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1187: p_prof_var_rec IN ProfVar_Rec_Type := G_MISS_PROF_REC,
1188: px_Object_Version_Number IN OUT NOCOPY NUMBER,
1189: x_msg_data OUT NOCOPY VARCHAR2,

Line 1186: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

1182: PROCEDURE Update_Profile_Variable(
1183: p_api_version_number IN NUMBER,
1184: p_init_msg_list IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,
1185: p_commit IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,
1186: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1187: p_prof_var_rec IN ProfVar_Rec_Type := G_MISS_PROF_REC,
1188: px_Object_Version_Number IN OUT NOCOPY NUMBER,
1189: x_msg_data OUT NOCOPY VARCHAR2,
1190: x_msg_count OUT NOCOPY VARCHAR2,

Line 1248: l_prof_var_rec.select_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.select_clause,l_old_prof_var_rec.select_clause);

1244: -- we have to build the sql statement in advance before
1245: -- going into the validation part. Bcauz if any of the
1246: -- select, from, where or other columns change the whole
1247: -- sql statement gets effected.
1248: l_prof_var_rec.select_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.select_clause,l_old_prof_var_rec.select_clause);
1249: l_prof_var_rec.from_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.from_clause,l_old_prof_var_rec.from_clause);
1250: l_prof_var_rec.where_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.where_clause,l_old_prof_var_rec.where_clause);
1251: l_prof_var_rec.other_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.other_clause,l_old_prof_var_rec.other_clause);
1252: l_prof_var_rec.object_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code);

Line 1249: l_prof_var_rec.from_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.from_clause,l_old_prof_var_rec.from_clause);

1245: -- going into the validation part. Bcauz if any of the
1246: -- select, from, where or other columns change the whole
1247: -- sql statement gets effected.
1248: l_prof_var_rec.select_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.select_clause,l_old_prof_var_rec.select_clause);
1249: l_prof_var_rec.from_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.from_clause,l_old_prof_var_rec.from_clause);
1250: l_prof_var_rec.where_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.where_clause,l_old_prof_var_rec.where_clause);
1251: l_prof_var_rec.other_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.other_clause,l_old_prof_var_rec.other_clause);
1252: l_prof_var_rec.object_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code);
1253: l_prof_var_rec.sql_stmnt_for_drilldown := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown);

Line 1250: l_prof_var_rec.where_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.where_clause,l_old_prof_var_rec.where_clause);

1246: -- select, from, where or other columns change the whole
1247: -- sql statement gets effected.
1248: l_prof_var_rec.select_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.select_clause,l_old_prof_var_rec.select_clause);
1249: l_prof_var_rec.from_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.from_clause,l_old_prof_var_rec.from_clause);
1250: l_prof_var_rec.where_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.where_clause,l_old_prof_var_rec.where_clause);
1251: l_prof_var_rec.other_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.other_clause,l_old_prof_var_rec.other_clause);
1252: l_prof_var_rec.object_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code);
1253: l_prof_var_rec.sql_stmnt_for_drilldown := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown);
1254: l_prof_var_rec.block_name := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name);

Line 1251: l_prof_var_rec.other_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.other_clause,l_old_prof_var_rec.other_clause);

1247: -- sql statement gets effected.
1248: l_prof_var_rec.select_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.select_clause,l_old_prof_var_rec.select_clause);
1249: l_prof_var_rec.from_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.from_clause,l_old_prof_var_rec.from_clause);
1250: l_prof_var_rec.where_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.where_clause,l_old_prof_var_rec.where_clause);
1251: l_prof_var_rec.other_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.other_clause,l_old_prof_var_rec.other_clause);
1252: l_prof_var_rec.object_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code);
1253: l_prof_var_rec.sql_stmnt_for_drilldown := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown);
1254: l_prof_var_rec.block_name := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name);
1255: l_prof_var_rec.block_name_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code);

Line 1252: l_prof_var_rec.object_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code);

1248: l_prof_var_rec.select_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.select_clause,l_old_prof_var_rec.select_clause);
1249: l_prof_var_rec.from_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.from_clause,l_old_prof_var_rec.from_clause);
1250: l_prof_var_rec.where_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.where_clause,l_old_prof_var_rec.where_clause);
1251: l_prof_var_rec.other_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.other_clause,l_old_prof_var_rec.other_clause);
1252: l_prof_var_rec.object_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code);
1253: l_prof_var_rec.sql_stmnt_for_drilldown := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown);
1254: l_prof_var_rec.block_name := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name);
1255: l_prof_var_rec.block_name_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code);
1256:

Line 1253: l_prof_var_rec.sql_stmnt_for_drilldown := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown);

1249: l_prof_var_rec.from_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.from_clause,l_old_prof_var_rec.from_clause);
1250: l_prof_var_rec.where_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.where_clause,l_old_prof_var_rec.where_clause);
1251: l_prof_var_rec.other_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.other_clause,l_old_prof_var_rec.other_clause);
1252: l_prof_var_rec.object_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code);
1253: l_prof_var_rec.sql_stmnt_for_drilldown := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown);
1254: l_prof_var_rec.block_name := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name);
1255: l_prof_var_rec.block_name_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code);
1256:
1257:

Line 1254: l_prof_var_rec.block_name := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name);

1250: l_prof_var_rec.where_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.where_clause,l_old_prof_var_rec.where_clause);
1251: l_prof_var_rec.other_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.other_clause,l_old_prof_var_rec.other_clause);
1252: l_prof_var_rec.object_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code);
1253: l_prof_var_rec.sql_stmnt_for_drilldown := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown);
1254: l_prof_var_rec.block_name := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name);
1255: l_prof_var_rec.block_name_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code);
1256:
1257:
1258: -- build the sql statement if any of the columns have changed

Line 1255: l_prof_var_rec.block_name_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code);

1251: l_prof_var_rec.other_clause := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.other_clause,l_old_prof_var_rec.other_clause);
1252: l_prof_var_rec.object_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code);
1253: l_prof_var_rec.sql_stmnt_for_drilldown := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown);
1254: l_prof_var_rec.block_name := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name);
1255: l_prof_var_rec.block_name_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code);
1256:
1257:
1258: -- build the sql statement if any of the columns have changed
1259:

Line 1287: IF (p_validation_level > CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN

1283: -- Apply business-rule validation to all required and passed parameters
1284: -- if validation level is set.
1285: -- ----------------------------------------------------------------------
1286:
1287: IF (p_validation_level > CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN
1288:
1289: --
1290: -- Validate the user and login id
1291: --

Line 1299: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,

1295: -- of certain fields
1296:
1297: Validate_Profile_Variables (
1298: p_api_name => l_api_name_full,
1299: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
1300: p_validate_rec => l_prof_var_rec,
1301: x_return_status => x_return_status,
1302: x_msg_count =>x_msg_count,
1303: x_msg_data =>x_msg_data );

Line 1340: p_BLOCK_NAME => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name) ,

1336: p_BLOCK_ID => l_prof_var_rec.block_id,
1337: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1338: p_LAST_UPDATE_DATE =>sysdate,
1339: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1340: p_BLOCK_NAME => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name) ,
1341: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.description,l_old_prof_var_rec.description),
1342: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.start_date_active,l_old_prof_var_rec.start_date_active),
1343: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.end_date_active,l_old_prof_var_rec.end_date_active),
1344: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),

Line 1341: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.description,l_old_prof_var_rec.description),

1337: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1338: p_LAST_UPDATE_DATE =>sysdate,
1339: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1340: p_BLOCK_NAME => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name) ,
1341: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.description,l_old_prof_var_rec.description),
1342: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.start_date_active,l_old_prof_var_rec.start_date_active),
1343: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.end_date_active,l_old_prof_var_rec.end_date_active),
1344: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1345: p_BLOCK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code),

Line 1342: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.start_date_active,l_old_prof_var_rec.start_date_active),

1338: p_LAST_UPDATE_DATE =>sysdate,
1339: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1340: p_BLOCK_NAME => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name) ,
1341: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.description,l_old_prof_var_rec.description),
1342: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.start_date_active,l_old_prof_var_rec.start_date_active),
1343: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.end_date_active,l_old_prof_var_rec.end_date_active),
1344: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1345: p_BLOCK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code),
1346: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),

Line 1343: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.end_date_active,l_old_prof_var_rec.end_date_active),

1339: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1340: p_BLOCK_NAME => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name) ,
1341: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.description,l_old_prof_var_rec.description),
1342: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.start_date_active,l_old_prof_var_rec.start_date_active),
1343: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.end_date_active,l_old_prof_var_rec.end_date_active),
1344: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1345: p_BLOCK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code),
1346: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),
1347: p_SQL_STMNT_FOR_DRILLDOWN => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown),

Line 1344: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),

1340: p_BLOCK_NAME => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name) ,
1341: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.description,l_old_prof_var_rec.description),
1342: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.start_date_active,l_old_prof_var_rec.start_date_active),
1343: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.end_date_active,l_old_prof_var_rec.end_date_active),
1344: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1345: p_BLOCK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code),
1346: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),
1347: p_SQL_STMNT_FOR_DRILLDOWN => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown),
1348: p_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt,l_old_prof_var_rec.sql_stmnt),

Line 1345: p_BLOCK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code),

1341: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.description,l_old_prof_var_rec.description),
1342: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.start_date_active,l_old_prof_var_rec.start_date_active),
1343: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.end_date_active,l_old_prof_var_rec.end_date_active),
1344: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1345: p_BLOCK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code),
1346: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),
1347: p_SQL_STMNT_FOR_DRILLDOWN => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown),
1348: p_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt,l_old_prof_var_rec.sql_stmnt),
1349: p_BATCH_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.batch_sql_stmnt,l_old_prof_var_rec.batch_sql_stmnt),

Line 1346: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),

1342: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.start_date_active,l_old_prof_var_rec.start_date_active),
1343: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.end_date_active,l_old_prof_var_rec.end_date_active),
1344: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1345: p_BLOCK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code),
1346: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),
1347: p_SQL_STMNT_FOR_DRILLDOWN => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown),
1348: p_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt,l_old_prof_var_rec.sql_stmnt),
1349: p_BATCH_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.batch_sql_stmnt,l_old_prof_var_rec.batch_sql_stmnt),
1350: p_SELECT_CLAUSE => l_prof_var_rec.select_clause,

Line 1347: p_SQL_STMNT_FOR_DRILLDOWN => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown),

1343: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(l_prof_var_rec.end_date_active,l_old_prof_var_rec.end_date_active),
1344: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1345: p_BLOCK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code),
1346: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),
1347: p_SQL_STMNT_FOR_DRILLDOWN => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown),
1348: p_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt,l_old_prof_var_rec.sql_stmnt),
1349: p_BATCH_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.batch_sql_stmnt,l_old_prof_var_rec.batch_sql_stmnt),
1350: p_SELECT_CLAUSE => l_prof_var_rec.select_clause,
1351: p_CURRENCY_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.currency_code,l_old_prof_var_rec.currency_code),

Line 1348: p_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt,l_old_prof_var_rec.sql_stmnt),

1344: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1345: p_BLOCK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code),
1346: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),
1347: p_SQL_STMNT_FOR_DRILLDOWN => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown),
1348: p_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt,l_old_prof_var_rec.sql_stmnt),
1349: p_BATCH_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.batch_sql_stmnt,l_old_prof_var_rec.batch_sql_stmnt),
1350: p_SELECT_CLAUSE => l_prof_var_rec.select_clause,
1351: p_CURRENCY_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.currency_code,l_old_prof_var_rec.currency_code),
1352: p_FROM_CLAUSE => l_prof_var_rec.from_clause,

Line 1349: p_BATCH_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.batch_sql_stmnt,l_old_prof_var_rec.batch_sql_stmnt),

1345: p_BLOCK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name_code,l_old_prof_var_rec.block_name_code),
1346: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),
1347: p_SQL_STMNT_FOR_DRILLDOWN => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown),
1348: p_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt,l_old_prof_var_rec.sql_stmnt),
1349: p_BATCH_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.batch_sql_stmnt,l_old_prof_var_rec.batch_sql_stmnt),
1350: p_SELECT_CLAUSE => l_prof_var_rec.select_clause,
1351: p_CURRENCY_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.currency_code,l_old_prof_var_rec.currency_code),
1352: p_FROM_CLAUSE => l_prof_var_rec.from_clause,
1353: p_WHERE_CLAUSE => l_prof_var_rec.where_clause,

Line 1351: p_CURRENCY_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.currency_code,l_old_prof_var_rec.currency_code),

1347: p_SQL_STMNT_FOR_DRILLDOWN => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt_for_drilldown,l_old_prof_var_rec.sql_stmnt_for_drilldown),
1348: p_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt,l_old_prof_var_rec.sql_stmnt),
1349: p_BATCH_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.batch_sql_stmnt,l_old_prof_var_rec.batch_sql_stmnt),
1350: p_SELECT_CLAUSE => l_prof_var_rec.select_clause,
1351: p_CURRENCY_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.currency_code,l_old_prof_var_rec.currency_code),
1352: p_FROM_CLAUSE => l_prof_var_rec.from_clause,
1353: p_WHERE_CLAUSE => l_prof_var_rec.where_clause,
1354: p_OTHER_CLAUSE => l_prof_var_rec.other_clause,
1355: p_BLOCK_LEVEL => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_level,l_old_prof_var_rec.block_level),

Line 1355: p_BLOCK_LEVEL => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_level,l_old_prof_var_rec.block_level),

1351: p_CURRENCY_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.currency_code,l_old_prof_var_rec.currency_code),
1352: p_FROM_CLAUSE => l_prof_var_rec.from_clause,
1353: p_WHERE_CLAUSE => l_prof_var_rec.where_clause,
1354: p_OTHER_CLAUSE => l_prof_var_rec.other_clause,
1355: p_BLOCK_LEVEL => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_level,l_old_prof_var_rec.block_level),
1356: px_OBJECT_VERSION_NUMBER => px_Object_Version_Number,
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:

Line 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));

1353: p_WHERE_CLAUSE => l_prof_var_rec.where_clause,
1354: p_OTHER_CLAUSE => l_prof_var_rec.other_clause,
1355: p_BLOCK_LEVEL => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_level,l_old_prof_var_rec.block_level),
1356: px_OBJECT_VERSION_NUMBER => px_Object_Version_Number,
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

Line 1398: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

1394: END Update_Profile_Variable;
1395:
1396: PROCEDURE Update_table_column(
1397: P_Api_Version_Number IN NUMBER,
1398: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1399: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1400: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1401: p_Table_Column_REC IN Table_Column_Rec_Type := G_MISS_TABLE_COLUMN_REC,
1402: px_Object_Version_Number IN OUT NOCOPY NUMBER,

Line 1399: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

1395:
1396: PROCEDURE Update_table_column(
1397: P_Api_Version_Number IN NUMBER,
1398: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1399: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1400: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1401: p_Table_Column_REC IN Table_Column_Rec_Type := G_MISS_TABLE_COLUMN_REC,
1402: px_Object_Version_Number IN OUT NOCOPY NUMBER,
1403: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1400: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

1396: PROCEDURE Update_table_column(
1397: P_Api_Version_Number IN NUMBER,
1398: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1399: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1400: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1401: p_Table_Column_REC IN Table_Column_Rec_Type := G_MISS_TABLE_COLUMN_REC,
1402: px_Object_Version_Number IN OUT NOCOPY NUMBER,
1403: X_Return_Status OUT NOCOPY VARCHAR2,
1404: X_Msg_Count OUT NOCOPY NUMBER,

Line 1456: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)

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
1458: -- Invoke validation procedures
1459: Validate_table_column(
1460: p_api_name => l_api_name,

Line 1462: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,

1458: -- Invoke validation procedures
1459: Validate_table_column(
1460: p_api_name => l_api_name,
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;

Line 1678: p_validation_level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE,

1674: END LOOP;
1675:
1676: Update_Profile_Variable(
1677: p_api_version_number => 1.0,
1678: p_validation_level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE,
1679: p_block_id => p_block_id,
1680: p_sql_stmnt_for_drilldown => NULL,
1681: px_object_version_number => PX_OBJECT_VERSION_NUMBER,
1682: x_return_status => x_return_status,

Line 1748: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE

1744: -- Description: Validates the block_name using the table
1745: -- cs_prof_blocks. Block_name should not be duplicated in the table.
1746: -- Input Parameters
1747: -- p_api_name, standard parameter for writting messages
1748: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1749: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1750: -- p_block_name, block_name to be validated
1751: -- Out Parameters
1752: -- x_return_status, standard parameter for the return status

Line 1749: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

1745: -- cs_prof_blocks. Block_name should not be duplicated in the table.
1746: -- Input Parameters
1747: -- p_api_name, standard parameter for writting messages
1748: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1749: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1750: -- p_block_name, block_name to be validated
1751: -- Out Parameters
1752: -- x_return_status, standard parameter for the return status
1753: --------------------------------------------------------------------------

Line 1773: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN

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
1775: -- if so validate else its an mandatory argument error as its
1776: -- in Create Mode.
1777: IF (( p_block_name <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND

Line 1777: IF (( p_block_name <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND

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
1775: -- if so validate else its an mandatory argument error as its
1776: -- in Create Mode.
1777: IF (( p_block_name <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
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

Line 1783: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg

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);
1787: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1794: CSC_CORE_UTILS_PVT.mandatory_arg_error(

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

Line 1801: ELSIF p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE THEN

1797: p_argument_value => p_block_name);
1798:
1799: END IF;
1800: -- If the validation is called for an Update
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;

Line 1806: CSC_CORE_UTILS_PVT.mandatory_arg_error(

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

Line 1811: elsif ( p_block_name <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) then

1807: p_api_name => p_api_name,
1808: p_argument => 'p_block_name',
1809: p_argument_value => p_block_name);
1810:
1811: elsif ( p_block_name <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) then
1812: -- Valdiate the block name
1813: Open get_block_name;
1814: Loop
1815: Fetch get_block_name into l_dummy;

Line 1822: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg

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);
1826: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1840: -- using CSC_CORE_UTILS_PVT.lookup_code_not_exists function.

1836:
1837: --------------------------------------------------------------------------
1838: -- Procedure Validate_Seeded_Flag
1839: -- Description: Validates the seeded_flag from the fnd_lookups table
1840: -- using CSC_CORE_UTILS_PVT.lookup_code_not_exists function.
1841: -- Input Parameters
1842: -- p_api_name, standard parameter for writting messages
1843: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1844: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

Line 1843: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE

1839: -- Description: Validates the seeded_flag from the fnd_lookups table
1840: -- using CSC_CORE_UTILS_PVT.lookup_code_not_exists function.
1841: -- Input Parameters
1842: -- p_api_name, standard parameter for writting messages
1843: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1844: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1845: -- p_seeded_flag, seeded_flag to be validated should be an YES or a NO
1846: -- Out Parameters
1847: -- x_return_status, standard parameter for the return status

Line 1844: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

1840: -- using CSC_CORE_UTILS_PVT.lookup_code_not_exists function.
1841: -- Input Parameters
1842: -- p_api_name, standard parameter for writting messages
1843: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1844: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1845: -- p_seeded_flag, seeded_flag to be validated should be an YES or a NO
1846: -- Out Parameters
1847: -- x_return_status, standard parameter for the return status
1848: --------------------------------------------------------------------------

Line 1865: IF (( p_seeded_flag <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND

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
1864: -- its an invalid argument.
1865: IF (( p_seeded_flag <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
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',

Line 1867: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(

1863: -- exists in fnd lookups for this date, if not
1864: -- its an invalid argument.
1865: IF (( p_seeded_flag <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
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

Line 1873: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,

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;
1877: END IF;

Line 1894: IF (( p_block_level <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND

1890:
1891: -- check if the block_level is passed in and is not
1892: -- null
1893:
1894: IF (( p_block_level <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
1895: ( p_block_level IS NOT NULL )) THEN
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')

Line 1901: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,

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;
1905: END IF;

Line 1912: -- using CSC_CORE_UTILS_PVT.currency_code_not_exists function.

1908:
1909: --------------------------------------------------------------------------
1910: -- Procedure Validate_Currecny_Code
1911: -- Description: Validates the currency_Code from the fnd_currencies table
1912: -- using CSC_CORE_UTILS_PVT.currency_code_not_exists function.
1913: -- Input Parameters
1914: -- p_api_name, standard parameter for writting messages
1915: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1916: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

Line 1915: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE

1911: -- Description: Validates the currency_Code from the fnd_currencies table
1912: -- using CSC_CORE_UTILS_PVT.currency_code_not_exists function.
1913: -- Input Parameters
1914: -- p_api_name, standard parameter for writting messages
1915: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1916: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1917: -- p_currrency_code, currency_code to be validated
1918: -- Out Parameters
1919: -- x_return_status, standard parameter for the return status

Line 1916: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

1912: -- using CSC_CORE_UTILS_PVT.currency_code_not_exists function.
1913: -- Input Parameters
1914: -- p_api_name, standard parameter for writting messages
1915: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1916: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1917: -- p_currrency_code, currency_code to be validated
1918: -- Out Parameters
1919: -- x_return_status, standard parameter for the return status
1920: --------------------------------------------------------------------------

Line 1935: IF (( p_currency_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND

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
1936: ( p_currency_code IS NOT NULL )) then
1937:
1938: IF CSC_CORE_UTILS_PVT.Currency_code_not_exists(
1939: p_effective_date => sysdate,

Line 1938: IF CSC_CORE_UTILS_PVT.Currency_code_not_exists(

1934: -- validate the currency code.
1935: IF (( p_currency_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
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

Line 1944: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,

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:
1948: END IF;

Line 1958: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE

1954: -- Procedure Validate_Sql_Stmnt
1955: -- Description: Validates the sql_statement using the dynamic sql
1956: -- Input Parameters
1957: -- p_api_name, standard parameter for writting messages
1958: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1959: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1960: -- p_sql_statement, concatented field using select_Clause, from_clause
1961: -- where_clause and Other_Clause columns using the Build_Sql_Stmnt
1962: -- procedure

Line 1959: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

1955: -- Description: Validates the sql_statement using the dynamic sql
1956: -- Input Parameters
1957: -- p_api_name, standard parameter for writting messages
1958: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1959: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1960: -- p_sql_statement, concatented field using select_Clause, from_clause
1961: -- where_clause and Other_Clause columns using the Build_Sql_Stmnt
1962: -- procedure
1963: -- Out Parameters

Line 1982: CSC_CORE_UTILS_PVT.Validate_Sql_Stmnt(

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.
1981:
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

Line 1989: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

Line 2017: (p_Object_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR )) THEN

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

Line 2022: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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);
2026: END IF;

Line 2055: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN

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
2056: -- if the block_name_code is passed in and is not null
2057: -- validate the block_name_code
2058: if (( p_block_name_code IS NOT NULL ) and
2059: ( p_block_name_code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR )) then

Line 2059: ( p_block_name_code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR )) then

2055: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN
2056: -- if the block_name_code is passed in and is not null
2057: -- validate the block_name_code
2058: if (( p_block_name_code IS NOT NULL ) and
2059: ( p_block_name_code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR )) then
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

Line 2065: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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 );
2069: end if;

Line 2075: CSC_CORE_UTILS_PVT.mandatory_arg_error(

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);
2079: end if;

Line 2081: ELSIF p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE THEN

2077: p_argument => 'p_block_name_code',
2078: p_argument_value => p_block_name_code);
2079: end if;
2080: -- if its an update mode
2081: ELSIF p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE THEN
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

Line 2087: CSC_CORE_UTILS_PVT.mandatory_arg_error(

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);
2091: elsif p_block_name_code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR then

Line 2091: elsif p_block_name_code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR then

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);
2091: elsif p_block_name_code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR then
2092: open get_block_code;
2093: loop
2094: fetch get_block_code into l_dummy;
2095: -- if the block_name_code passed in is the same as

Line 2100: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg

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);
2104: exit;

Line 2138: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(

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(
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 );

Line 2220: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (

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 (
2221: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
2222: P_Application_ID =>p_validate_rec.application_id,
2223: X_Return_Status => x_return_status,
2224: X_Msg_Count => x_msg_count,

Line 2221: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,

2217: END IF;
2218:
2219: /* This Call added for Enhancement 1781726 for Validating Application_id*/
2220: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (
2221: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
2222: P_Application_ID =>p_validate_rec.application_id,
2223: X_Return_Status => x_return_status,
2224: X_Msg_Count => x_msg_count,
2225: X_Msg_Data => x_msg_data,

Line 2275: CSC_CORE_UTILS_PVT.Record_IS_LOCKED_MSG(p_API_NAME=> 'CSC_PROF_BLOCKS');

2271: IF C_get_prof_rec%NOTFOUND THEN
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;

Line 2333: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_API_NAME=>'CSC_PROF_TABLE_COLUMNS');

2329: IF C_get_table_column_rec%NOTFOUND THEN
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;

Line 2351: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE

2347: -- Description: Validates the block_id using the table
2348: -- cs_prof_blocks.
2349: -- Input Parameters
2350: -- p_api_name, standard parameter for writting messages
2351: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
2352: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
2353: -- p_block_id, block_id to be validated while updating
2354: -- Out Parameters
2355: -- x_return_status, standard parameter for the return status

Line 2352: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

2348: -- cs_prof_blocks.
2349: -- Input Parameters
2350: -- p_api_name, standard parameter for writting messages
2351: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
2352: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
2353: -- p_block_id, block_id to be validated while updating
2354: -- Out Parameters
2355: -- x_return_status, standard parameter for the return status
2356: --------------------------------------------------------------------------

Line 2382: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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' );
2386: END IF;

Line 2400: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN

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
2401:
2402: IF ( p_block_id <> CSC_CORE_UTILS_PVT.G_MISS_NUM ) AND
2403: ( p_block_id IS NOT NULL )
2404: THEN

Line 2402: IF ( p_block_id <> CSC_CORE_UTILS_PVT.G_MISS_NUM ) AND

2398:
2399: --
2400: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN
2401:
2402: IF ( p_block_id <> CSC_CORE_UTILS_PVT.G_MISS_NUM ) AND
2403: ( p_block_id IS NOT NULL )
2404: THEN
2405: x_return_status := chk_block_id( p_block_id );
2406: ELSE

Line 2408: CSC_CORE_UTILS_PVT.mandatory_arg_error(

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);
2412: END IF;

Line 2414: ELSIF p_Validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE THEN

2410: p_argument => 'p_block_id',
2411: p_argument_value => p_block_id);
2412: END IF;
2413:
2414: ELSIF p_Validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE THEN
2415:
2416: IF ( p_block_id <> CSC_CORE_UTILS_PVT.G_MISS_NUM )
2417: THEN
2418: IF (p_block_id IS NOT NULL ) THEN

Line 2416: IF ( p_block_id <> CSC_CORE_UTILS_PVT.G_MISS_NUM )

2412: END IF;
2413:
2414: ELSIF p_Validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE THEN
2415:
2416: IF ( p_block_id <> CSC_CORE_UTILS_PVT.G_MISS_NUM )
2417: THEN
2418: IF (p_block_id IS NOT NULL ) THEN
2419: x_return_status := chk_block_id( p_block_id );
2420: ELSE

Line 2422: CSC_CORE_UTILS_PVT.mandatory_arg_error(

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

Line 2457: IF p_TABLE_NAME is not NULL and p_TABLE_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

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;
2460: Fetch get_tname_csr into l_dummy;
2461: IF get_tname_csr%NOTFOUND THEN

Line 2466: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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' );
2470: END IF;

Line 2502: IF p_COLUMN_NAME is not NULL and p_COLUMN_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

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
2504: Open get_cname_csr;
2505: Fetch get_cname_csr into l_dummy;
2506: IF get_cname_csr%NOTFOUND THEN

Line 2511: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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' );
2515: END IF;

Line 2525: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

2521: END Validate_COLUMN_NAME;
2522:
2523: PROCEDURE Validate_Table_Column(
2524: P_Api_Name IN VARCHAR2,
2525: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
2526: P_Validation_mode IN VARCHAR2,
2527: p_validate_rec IN Table_Column_Rec_Type,
2528: X_Return_Status OUT NOCOPY VARCHAR2
2529: )

Line 2568: CSC_CORE_UTILS_PVT.mandatory_arg_error(

2564: END IF;
2565:
2566:
2567: IF p_validate_rec.COLUMN_SEQUENCE is NULL THEN
2568: CSC_CORE_UTILS_PVT.mandatory_arg_error(
2569: p_api_name => p_api_name,
2570: p_argument => 'p_Column_Sequence',
2571: p_argument_value => p_validate_rec.Column_Sequence);
2572: END IF;