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 51: ( p_Select_Clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR ) and

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

Line 53: ( p_from_Clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR )

49:
50: IF (p_Select_Clause IS NULL ) and
51: ( p_Select_Clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR ) and
52: ( p_from_Clause IS NULL ) and
53: ( p_from_Clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR )
54: THEN
55: -- invalid arguments exception
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg( p_api_name => p_api_name,

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

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

Line 63: CSC_CORE_UTILS_PVT.Build_Sql_Stmnt

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

Line 73: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

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

409: -- ----------------------------------------------------------------------------
410:
411: PROCEDURE Create_Profile_Variable(
412: p_api_version_number IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
414: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
415: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
416: x_return_status OUT NOCOPY VARCHAR2,
417: x_msg_count OUT NOCOPY NUMBER,

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

410:
411: PROCEDURE Create_Profile_Variable(
412: p_api_version_number IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
414: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
415: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
416: x_return_status OUT NOCOPY VARCHAR2,
417: x_msg_count OUT NOCOPY NUMBER,
418: x_msg_data OUT NOCOPY VARCHAR2,

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

411: PROCEDURE Create_Profile_Variable(
412: p_api_version_number IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
414: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
415: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
416: x_return_status OUT NOCOPY VARCHAR2,
417: x_msg_count OUT NOCOPY NUMBER,
418: x_msg_data OUT NOCOPY VARCHAR2,
419: p_block_name IN VARCHAR2,

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

488: END;
489: --> with record type
490: PROCEDURE Create_Profile_Variable(
491: p_api_version_number IN NUMBER,
492: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
493: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
494: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
495: p_prof_var_rec IN ProfVar_Rec_Type := G_MISS_PROF_REC,
496: x_msg_data OUT NOCOPY VARCHAR2,

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

489: --> with record type
490: PROCEDURE Create_Profile_Variable(
491: p_api_version_number IN NUMBER,
492: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
493: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
494: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
495: p_prof_var_rec IN ProfVar_Rec_Type := G_MISS_PROF_REC,
496: x_msg_data OUT NOCOPY VARCHAR2,
497: x_msg_count OUT NOCOPY NUMBER,

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

490: PROCEDURE Create_Profile_Variable(
491: p_api_version_number IN NUMBER,
492: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
493: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
494: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
495: p_prof_var_rec IN ProfVar_Rec_Type := G_MISS_PROF_REC,
496: x_msg_data OUT NOCOPY VARCHAR2,
497: x_msg_count OUT NOCOPY NUMBER,
498: x_return_status OUT NOCOPY VARCHAR2,

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

539: -- we have to build the sql statement in advance before
540: -- going into the validation part to validate the whole
541: -- sql statement
542: /* jamose duplicate validation; validated under build_sql_stmnt
543: IF p_prof_var_rec.select_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
544: l_prof_var_rec.select_clause := NULL;
545: END IF;
546: IF p_prof_var_rec.from_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
547: l_prof_var_rec.from_clause := NULL;

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

542: /* jamose duplicate validation; validated under build_sql_stmnt
543: IF p_prof_var_rec.select_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
544: l_prof_var_rec.select_clause := NULL;
545: END IF;
546: IF p_prof_var_rec.from_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
547: l_prof_var_rec.from_clause := NULL;
548: END IF;
549: -- jamose */
550: IF p_prof_var_rec.where_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN

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

546: IF p_prof_var_rec.from_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
547: l_prof_var_rec.from_clause := NULL;
548: END IF;
549: -- jamose */
550: IF p_prof_var_rec.where_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
551: l_prof_var_rec.where_clause := NULL;
552: END IF;
553: IF p_prof_var_rec.other_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
554: l_prof_var_rec.other_clause := NULL;

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

549: -- jamose */
550: IF p_prof_var_rec.where_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
551: l_prof_var_rec.where_clause := NULL;
552: END IF;
553: IF p_prof_var_rec.other_clause = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
554: l_prof_var_rec.other_clause := NULL;
555: END IF;
556: Build_Sql_Stmnt( p_api_name => l_api_name,
557: p_select_clause => l_prof_var_rec.select_clause,

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

570: -- ----------------------------------------------------------------------
571: -- Apply business-rule validation to all required and passed parameters
572: -- if validation level is set.
573: -- ----------------------------------------------------------------------
574: IF (p_validation_level > CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN
575: -- Check for all the required attributes that are being passed should be there
576: -- and should not be passed as null. If passed as null then we will raise error
577: -- Also Check if Seeded_Flag = 'Y' and then allow / disallow updates
578: -- of certain fields

Line 582: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,

578: -- of certain fields
579:
580: Validate_Profile_Variables(
581: p_api_name => l_api_name_full,
582: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
583: P_validate_rec => l_prof_var_rec,
584: x_return_status => x_return_status,
585: x_msg_count =>x_msg_count,
586: x_msg_data =>x_msg_data );

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

686: END Create_Profile_Variable ;
687:
688: PROCEDURE Create_table_column(
689: P_Api_Version_Number IN NUMBER,
690: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
691: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
692: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
693: p_Table_Column_Tbl IN Table_Column_Tbl_Type := G_MISS_Table_Column_TBL,
694: X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,

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

687:
688: PROCEDURE Create_table_column(
689: P_Api_Version_Number IN NUMBER,
690: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
691: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
692: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
693: p_Table_Column_Tbl IN Table_Column_Tbl_Type := G_MISS_Table_Column_TBL,
694: X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,
695: X_object_version_number OUT NOCOPY NUMBER,

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

688: PROCEDURE Create_table_column(
689: P_Api_Version_Number IN NUMBER,
690: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
691: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
692: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
693: p_Table_Column_Tbl IN Table_Column_Tbl_Type := G_MISS_Table_Column_TBL,
694: X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,
695: X_object_version_number OUT NOCOPY NUMBER,
696: X_Return_Status OUT NOCOPY VARCHAR2,

Line 738: p_validation_level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE,

734: where block_id = p_table_column_rec.block_id;
735:
736: Update_Profile_Variable(
737: p_api_version_number => 1.0,
738: p_validation_level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE,
739: x_return_status => x_return_status,
740: x_msg_count => x_msg_count,
741: x_msg_data => x_msg_data,
742: px_object_version_number => l_object_version_number,

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

749: END;
750:
751: PROCEDURE Create_table_column(
752: P_Api_Version_Number IN NUMBER,
753: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
754: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
755: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
756: p_Table_Column_REC IN Table_Column_Rec_Type := G_MISS_Table_Column_REC,
757: X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,

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

750:
751: PROCEDURE Create_table_column(
752: P_Api_Version_Number IN NUMBER,
753: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
754: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
755: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
756: p_Table_Column_REC IN Table_Column_Rec_Type := G_MISS_Table_Column_REC,
757: X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,
758: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,

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

751: PROCEDURE Create_table_column(
752: P_Api_Version_Number IN NUMBER,
753: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
754: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
755: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
756: p_Table_Column_REC IN Table_Column_Rec_Type := G_MISS_Table_Column_REC,
757: X_TABLE_COLUMN_ID OUT NOCOPY NUMBER,
758: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
759: X_Return_Status OUT NOCOPY VARCHAR2,

Line 805: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,

801:
802: Validate_table_column(
803: p_api_name => l_api_name,
804: p_Init_Msg_List => p_Init_Msg_List,
805: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
806: p_Validate_Rec => l_Table_Column_Rec,
807: x_return_status => x_return_status);
808: END IF;
809:

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

897: -- ----------------------------------------------------------------------------
898:
899: PROCEDURE Update_Profile_Variable(
900: p_api_version_number IN NUMBER,
901: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
902: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
903: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
904: x_return_status OUT NOCOPY VARCHAR2,
905: x_msg_count OUT NOCOPY NUMBER,

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

898:
899: PROCEDURE Update_Profile_Variable(
900: p_api_version_number IN NUMBER,
901: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
902: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
903: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
904: x_return_status OUT NOCOPY VARCHAR2,
905: x_msg_count OUT NOCOPY NUMBER,
906: x_msg_data OUT NOCOPY VARCHAR2,

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

899: PROCEDURE Update_Profile_Variable(
900: p_api_version_number IN NUMBER,
901: p_init_msg_list IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
902: p_commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
903: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
904: x_return_status OUT NOCOPY VARCHAR2,
905: x_msg_count OUT NOCOPY NUMBER,
906: x_msg_data OUT NOCOPY VARCHAR2,
907: p_block_id IN NUMBER ,

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

991: -- ----------------------------------------------------------------------------
992:
993: PROCEDURE Update_Profile_Variable(
994: p_api_version_number IN NUMBER,
995: p_init_msg_list IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,
996: p_commit IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,
997: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
998: p_prof_var_rec IN ProfVar_Rec_Type := G_MISS_PROF_REC,
999: px_Object_Version_Number IN OUT NOCOPY NUMBER,

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

992:
993: PROCEDURE Update_Profile_Variable(
994: p_api_version_number IN NUMBER,
995: p_init_msg_list IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,
996: p_commit IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,
997: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
998: p_prof_var_rec IN ProfVar_Rec_Type := G_MISS_PROF_REC,
999: px_Object_Version_Number IN OUT NOCOPY NUMBER,
1000: x_msg_data OUT NOCOPY VARCHAR2,

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

993: PROCEDURE Update_Profile_Variable(
994: p_api_version_number IN NUMBER,
995: p_init_msg_list IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,
996: p_commit IN VARCHAR2:= CSC_CORE_UTILS_PVT.G_FALSE,
997: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
998: p_prof_var_rec IN ProfVar_Rec_Type := G_MISS_PROF_REC,
999: px_Object_Version_Number IN OUT NOCOPY NUMBER,
1000: x_msg_data OUT NOCOPY VARCHAR2,
1001: x_msg_count OUT NOCOPY VARCHAR2,

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

1055: -- we have to build the sql statement in advance before
1056: -- going into the validation part. Bcauz if any of the
1057: -- select, from, where or other columns change the whole
1058: -- sql statement gets effected.
1059: 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);
1060: 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);
1061: 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);
1062: 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);
1063: 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 1060: 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);

1056: -- going into the validation part. Bcauz if any of the
1057: -- select, from, where or other columns change the whole
1058: -- sql statement gets effected.
1059: 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);
1060: 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);
1061: 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);
1062: 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);
1063: 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);
1064: 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 1061: 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);

1057: -- select, from, where or other columns change the whole
1058: -- sql statement gets effected.
1059: 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);
1060: 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);
1061: 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);
1062: 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);
1063: 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);
1064: 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);
1065: 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 1062: 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);

1058: -- sql statement gets effected.
1059: 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);
1060: 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);
1061: 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);
1062: 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);
1063: 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);
1064: 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);
1065: 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);
1066: 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 1063: 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);

1059: 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);
1060: 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);
1061: 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);
1062: 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);
1063: 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);
1064: 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);
1065: 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);
1066: 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);
1067:

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

1060: 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);
1061: 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);
1062: 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);
1063: 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);
1064: 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);
1065: 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);
1066: 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);
1067:
1068:

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

1061: 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);
1062: 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);
1063: 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);
1064: 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);
1065: 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);
1066: 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);
1067:
1068:
1069: -- build the sql statement if any of the columns have changed

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

1062: 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);
1063: 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);
1064: 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);
1065: 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);
1066: 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);
1067:
1068:
1069: -- build the sql statement if any of the columns have changed
1070:

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

1094: -- Apply business-rule validation to all required and passed parameters
1095: -- if validation level is set.
1096: -- ----------------------------------------------------------------------
1097:
1098: IF (p_validation_level > CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN
1099:
1100: --
1101: -- Validate the user and login id
1102: --

Line 1110: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,

1106: -- of certain fields
1107:
1108: Validate_Profile_Variables (
1109: p_api_name => l_api_name_full,
1110: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
1111: p_validate_rec => l_prof_var_rec,
1112: x_return_status => x_return_status,
1113: x_msg_count =>x_msg_count,
1114: x_msg_data =>x_msg_data );

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

1143: p_BLOCK_ID => l_prof_var_rec.block_id,
1144: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1145: p_LAST_UPDATE_DATE =>sysdate,
1146: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1147: p_BLOCK_NAME => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name) ,
1148: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.description,l_old_prof_var_rec.description),
1149: 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),
1150: 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),
1151: 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 1148: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.description,l_old_prof_var_rec.description),

1144: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1145: p_LAST_UPDATE_DATE =>sysdate,
1146: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1147: p_BLOCK_NAME => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name) ,
1148: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.description,l_old_prof_var_rec.description),
1149: 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),
1150: 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),
1151: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1152: 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 1149: 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),

1145: p_LAST_UPDATE_DATE =>sysdate,
1146: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1147: p_BLOCK_NAME => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name) ,
1148: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.description,l_old_prof_var_rec.description),
1149: 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),
1150: 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),
1151: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1152: 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),
1153: 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 1150: 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),

1146: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1147: p_BLOCK_NAME => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name) ,
1148: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.description,l_old_prof_var_rec.description),
1149: 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),
1150: 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),
1151: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1152: 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),
1153: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),
1154: 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 1151: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),

1147: p_BLOCK_NAME => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_name,l_old_prof_var_rec.block_name) ,
1148: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.description,l_old_prof_var_rec.description),
1149: 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),
1150: 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),
1151: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1152: 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),
1153: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),
1154: 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),
1155: 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 1152: 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),

1148: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.description,l_old_prof_var_rec.description),
1149: 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),
1150: 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),
1151: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1152: 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),
1153: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),
1154: 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),
1155: p_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt,l_old_prof_var_rec.sql_stmnt),
1156: 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 1153: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),

1149: 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),
1150: 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),
1151: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1152: 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),
1153: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),
1154: 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),
1155: p_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt,l_old_prof_var_rec.sql_stmnt),
1156: 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),
1157: p_SELECT_CLAUSE => l_prof_var_rec.select_clause,

Line 1154: 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),

1150: 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),
1151: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1152: 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),
1153: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),
1154: 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),
1155: p_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt,l_old_prof_var_rec.sql_stmnt),
1156: 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),
1157: p_SELECT_CLAUSE => l_prof_var_rec.select_clause,
1158: 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 1155: p_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt,l_old_prof_var_rec.sql_stmnt),

1151: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.seeded_flag,l_old_prof_var_rec.seeded_flag),
1152: 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),
1153: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),
1154: 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),
1155: p_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt,l_old_prof_var_rec.sql_stmnt),
1156: 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),
1157: p_SELECT_CLAUSE => l_prof_var_rec.select_clause,
1158: p_CURRENCY_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.currency_code,l_old_prof_var_rec.currency_code),
1159: p_FROM_CLAUSE => l_prof_var_rec.from_clause,

Line 1156: 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),

1152: 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),
1153: p_OBJECT_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.object_code,l_old_prof_var_rec.object_code),
1154: 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),
1155: p_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt,l_old_prof_var_rec.sql_stmnt),
1156: 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),
1157: p_SELECT_CLAUSE => l_prof_var_rec.select_clause,
1158: p_CURRENCY_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.currency_code,l_old_prof_var_rec.currency_code),
1159: p_FROM_CLAUSE => l_prof_var_rec.from_clause,
1160: p_WHERE_CLAUSE => l_prof_var_rec.where_clause,

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

1154: 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),
1155: p_SQL_STMNT => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.sql_stmnt,l_old_prof_var_rec.sql_stmnt),
1156: 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),
1157: p_SELECT_CLAUSE => l_prof_var_rec.select_clause,
1158: p_CURRENCY_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.currency_code,l_old_prof_var_rec.currency_code),
1159: p_FROM_CLAUSE => l_prof_var_rec.from_clause,
1160: p_WHERE_CLAUSE => l_prof_var_rec.where_clause,
1161: p_OTHER_CLAUSE => l_prof_var_rec.other_clause,
1162: 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 1162: p_BLOCK_LEVEL => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_level,l_old_prof_var_rec.block_level),

1158: p_CURRENCY_CODE => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.currency_code,l_old_prof_var_rec.currency_code),
1159: p_FROM_CLAUSE => l_prof_var_rec.from_clause,
1160: p_WHERE_CLAUSE => l_prof_var_rec.where_clause,
1161: p_OTHER_CLAUSE => l_prof_var_rec.other_clause,
1162: p_BLOCK_LEVEL => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_level,l_old_prof_var_rec.block_level),
1163: px_OBJECT_VERSION_NUMBER => px_Object_Version_Number,
1164: p_APPLICATION_ID => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.APPLICATION_ID,l_old_prof_var_rec.application_id));
1165:
1166:

Line 1164: p_APPLICATION_ID => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.APPLICATION_ID,l_old_prof_var_rec.application_id));

1160: p_WHERE_CLAUSE => l_prof_var_rec.where_clause,
1161: p_OTHER_CLAUSE => l_prof_var_rec.other_clause,
1162: p_BLOCK_LEVEL => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.block_level,l_old_prof_var_rec.block_level),
1163: px_OBJECT_VERSION_NUMBER => px_Object_Version_Number,
1164: p_APPLICATION_ID => csc_core_utils_pvt.get_g_miss_char(l_prof_var_rec.APPLICATION_ID,l_old_prof_var_rec.application_id));
1165:
1166:
1167: -- Standard check of p_commit
1168: IF FND_API.To_Boolean(p_commit) THEN

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

1201: END Update_Profile_Variable;
1202:
1203: PROCEDURE Update_table_column(
1204: P_Api_Version_Number IN NUMBER,
1205: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1206: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1207: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1208: p_Table_Column_REC IN Table_Column_Rec_Type := G_MISS_TABLE_COLUMN_REC,
1209: px_Object_Version_Number IN OUT NOCOPY NUMBER,

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

1202:
1203: PROCEDURE Update_table_column(
1204: P_Api_Version_Number IN NUMBER,
1205: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1206: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1207: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1208: p_Table_Column_REC IN Table_Column_Rec_Type := G_MISS_TABLE_COLUMN_REC,
1209: px_Object_Version_Number IN OUT NOCOPY NUMBER,
1210: X_Return_Status OUT NOCOPY VARCHAR2,

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

1203: PROCEDURE Update_table_column(
1204: P_Api_Version_Number IN NUMBER,
1205: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1206: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1207: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1208: p_Table_Column_REC IN Table_Column_Rec_Type := G_MISS_TABLE_COLUMN_REC,
1209: px_Object_Version_Number IN OUT NOCOPY NUMBER,
1210: X_Return_Status OUT NOCOPY VARCHAR2,
1211: X_Msg_Count OUT NOCOPY NUMBER,

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

1259: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1260: RAISE FND_API.G_EXC_ERROR;
1261: END IF;
1262:
1263: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
1264: THEN
1265: -- Invoke validation procedures
1266: Validate_table_column(
1267: p_api_name => l_api_name,

Line 1269: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,

1265: -- Invoke validation procedures
1266: Validate_table_column(
1267: p_api_name => l_api_name,
1268: p_init_msg_list => p_init_msg_list,
1269: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
1270: P_Validate_Rec => l_Table_Column_Rec,
1271: x_return_status => x_return_status);
1272: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1273: RAISE FND_API.G_EXC_ERROR;

Line 1485: p_validation_level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE,

1481: END LOOP;
1482:
1483: Update_Profile_Variable(
1484: p_api_version_number => 1.0,
1485: p_validation_level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE,
1486: p_block_id => p_block_id,
1487: p_sql_stmnt_for_drilldown => NULL,
1488: px_object_version_number => PX_OBJECT_VERSION_NUMBER,
1489: x_return_status => x_return_status,

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

1551: -- Description: Validates the block_name using the table
1552: -- cs_prof_blocks. Block_name should not be duplicated in the table.
1553: -- Input Parameters
1554: -- p_api_name, standard parameter for writting messages
1555: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1556: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1557: -- p_block_name, block_name to be validated
1558: -- Out Parameters
1559: -- x_return_status, standard parameter for the return status

Line 1556: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

1552: -- cs_prof_blocks. Block_name should not be duplicated in the table.
1553: -- Input Parameters
1554: -- p_api_name, standard parameter for writting messages
1555: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1556: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1557: -- p_block_name, block_name to be validated
1558: -- Out Parameters
1559: -- x_return_status, standard parameter for the return status
1560: --------------------------------------------------------------------------

Line 1582: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN

1578: x_return_status := FND_API.G_RET_STS_SUCCESS;
1579:
1580: -- Check if the validation is called for a create or an
1581: -- update
1582: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN
1583: -- check if the block name is passed in and is NOT NULL
1584: -- if so validate else its an mandatory argument error as its
1585: -- in Create Mode.
1586: IF (( p_block_name <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND

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

1582: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN
1583: -- check if the block name is passed in and is NOT NULL
1584: -- if so validate else its an mandatory argument error as its
1585: -- in Create Mode.
1586: IF (( p_block_name <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
1587: ( p_block_name IS NOT NULL )) THEN
1588: Open get_block_name;
1589: Fetch get_block_name into l_dummy;
1590: if get_block_name%FOUND then

Line 1592: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg

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

Line 1603: CSC_CORE_UTILS_PVT.mandatory_arg_error(

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

Line 1610: ELSIF p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE THEN

1606: p_argument_value => p_block_name);
1607:
1608: END IF;
1609: -- If the validation is called for an Update
1610: ELSIF p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE THEN
1611: -- if the block name is passed in and as NULL then
1612: -- its a mandatory argument error.
1613: if ( p_block_name IS NULL ) then
1614: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1615: CSC_CORE_UTILS_PVT.mandatory_arg_error(

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

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

1616: p_api_name => p_api_name,
1617: p_argument => 'p_block_name',
1618: p_argument_value => p_block_name);
1619:
1620: elsif ( p_block_name <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) then
1621: -- Valdiate the block name
1622: Open get_block_name;
1623: Loop
1624: Fetch get_block_name into l_dummy;

Line 1631: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg

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

Line 1649: -- using CSC_CORE_UTILS_PVT.lookup_code_not_exists function.

1645:
1646: --------------------------------------------------------------------------
1647: -- Procedure Validate_Seeded_Flag
1648: -- Description: Validates the seeded_flag from the fnd_lookups table
1649: -- using CSC_CORE_UTILS_PVT.lookup_code_not_exists function.
1650: -- Input Parameters
1651: -- p_api_name, standard parameter for writting messages
1652: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1653: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

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

1648: -- Description: Validates the seeded_flag from the fnd_lookups table
1649: -- using CSC_CORE_UTILS_PVT.lookup_code_not_exists function.
1650: -- Input Parameters
1651: -- p_api_name, standard parameter for writting messages
1652: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1653: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1654: -- p_seeded_flag, seeded_flag to be validated should be an YES or a NO
1655: -- Out Parameters
1656: -- x_return_status, standard parameter for the return status

Line 1653: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

1649: -- using CSC_CORE_UTILS_PVT.lookup_code_not_exists function.
1650: -- Input Parameters
1651: -- p_api_name, standard parameter for writting messages
1652: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1653: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1654: -- p_seeded_flag, seeded_flag to be validated should be an YES or a NO
1655: -- Out Parameters
1656: -- x_return_status, standard parameter for the return status
1657: --------------------------------------------------------------------------

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

1670: -- check if the seeded flag is passed in and is not
1671: -- null, if passed in check if the lookup code
1672: -- exists in fnd lookups for this date, if not
1673: -- its an invalid argument.
1674: IF (( p_seeded_flag <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
1675: ( p_seeded_flag IS NOT NULL )) THEN
1676: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
1677: p_effective_date => trunc(sysdate),
1678: p_lookup_type => 'YES_NO',

Line 1676: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(

1672: -- exists in fnd lookups for this date, if not
1673: -- its an invalid argument.
1674: IF (( p_seeded_flag <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
1675: ( p_seeded_flag IS NOT NULL )) THEN
1676: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
1677: p_effective_date => trunc(sysdate),
1678: p_lookup_type => 'YES_NO',
1679: p_lookup_code => p_seeded_flag ) <> FND_API.G_RET_STS_SUCCESS
1680: THEN

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

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

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

1699:
1700: -- check if the block_level is passed in and is not
1701: -- null
1702:
1703: IF (( p_block_level <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
1704: ( p_block_level IS NOT NULL )) THEN
1705: IF (p_block_level <> 'PARTY' AND p_block_level <> 'ACCOUNT' AND p_block_level <> 'CONTACT' AND p_block_level <> 'EMPLOYEE')
1706: THEN
1707: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 1719: -- using CSC_CORE_UTILS_PVT.currency_code_not_exists function.

1715:
1716: --------------------------------------------------------------------------
1717: -- Procedure Validate_Currecny_Code
1718: -- Description: Validates the currency_Code from the fnd_currencies table
1719: -- using CSC_CORE_UTILS_PVT.currency_code_not_exists function.
1720: -- Input Parameters
1721: -- p_api_name, standard parameter for writting messages
1722: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1723: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

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

1718: -- Description: Validates the currency_Code from the fnd_currencies table
1719: -- using CSC_CORE_UTILS_PVT.currency_code_not_exists function.
1720: -- Input Parameters
1721: -- p_api_name, standard parameter for writting messages
1722: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1723: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1724: -- p_currrency_code, currency_code to be validated
1725: -- Out Parameters
1726: -- x_return_status, standard parameter for the return status

Line 1723: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

1719: -- using CSC_CORE_UTILS_PVT.currency_code_not_exists function.
1720: -- Input Parameters
1721: -- p_api_name, standard parameter for writting messages
1722: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1723: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1724: -- p_currrency_code, currency_code to be validated
1725: -- Out Parameters
1726: -- x_return_status, standard parameter for the return status
1727: --------------------------------------------------------------------------

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

1738: x_return_status := FND_API.G_RET_STS_SUCCESS;
1739:
1740: -- if the currency code is passed in and is not null,
1741: -- validate the currency code.
1742: IF (( p_currency_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
1743: ( p_currency_code IS NOT NULL )) then
1744:
1745: IF CSC_CORE_UTILS_PVT.Currency_code_not_exists(
1746: p_effective_date => sysdate,

Line 1745: IF CSC_CORE_UTILS_PVT.Currency_code_not_exists(

1741: -- validate the currency code.
1742: IF (( p_currency_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
1743: ( p_currency_code IS NOT NULL )) then
1744:
1745: IF CSC_CORE_UTILS_PVT.Currency_code_not_exists(
1746: p_effective_date => sysdate,
1747: p_currency_code => p_currency_code ) <> FND_API.G_RET_STS_SUCCESS THEN
1748:
1749: -- if the currency code is not valid its an invalid argument

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

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

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

1761: -- Procedure Validate_Sql_Stmnt
1762: -- Description: Validates the sql_statement using the dynamic sql
1763: -- Input Parameters
1764: -- p_api_name, standard parameter for writting messages
1765: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1766: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1767: -- p_sql_statement, concatented field using select_Clause, from_clause
1768: -- where_clause and Other_Clause columns using the Build_Sql_Stmnt
1769: -- procedure

Line 1766: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

1762: -- Description: Validates the sql_statement using the dynamic sql
1763: -- Input Parameters
1764: -- p_api_name, standard parameter for writting messages
1765: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
1766: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
1767: -- p_sql_statement, concatented field using select_Clause, from_clause
1768: -- where_clause and Other_Clause columns using the Build_Sql_Stmnt
1769: -- procedure
1770: -- Out Parameters

Line 1789: CSC_CORE_UTILS_PVT.Validate_Sql_Stmnt(

1785: -- if the sql_statement is passed in and if its NOT NULL then
1786: -- validate the sql_statement by parsing it using the dbms_sql
1787: -- package.
1788:
1789: CSC_CORE_UTILS_PVT.Validate_Sql_Stmnt(
1790: p_sql_stmnt => p_sql_Stmnt,
1791: x_return_status => X_return_status);
1792:
1793: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1796: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

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

1820: -- initialize the return status to SUCCESS
1821: x_return_status := FND_API.G_RET_STS_SUCCESS;
1822:
1823: IF ((p_Object_Code IS NOT NULL) AND
1824: (p_Object_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR )) THEN
1825: Open get_object_csr;
1826: Fetch get_object_csr into l_dummy;
1827: IF get_object_csr%NOTFOUND THEN
1828: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1829: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

Line 1862: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN

1858: x_return_status := FND_API.G_RET_STS_SUCCESS;
1859:
1860: -- Check if the validation is called for a Create or
1861: -- an update
1862: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN
1863: -- if the block_name_code is passed in and is not null
1864: -- validate the block_name_code
1865: if (( p_block_name_code IS NOT NULL ) and
1866: ( p_block_name_code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR )) then

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

1862: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN
1863: -- if the block_name_code is passed in and is not null
1864: -- validate the block_name_code
1865: if (( p_block_name_code IS NOT NULL ) and
1866: ( p_block_name_code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR )) then
1867: open get_block_code;
1868: fetch get_block_code into l_dummy;
1869: if get_block_code%FOUND then
1870: -- if not valid an invalid argument message

Line 1872: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

Line 1882: CSC_CORE_UTILS_PVT.mandatory_arg_error(

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

Line 1888: ELSIF p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE THEN

1884: p_argument => 'p_block_name_code',
1885: p_argument_value => p_block_name_code);
1886: end if;
1887: -- if its an update mode
1888: ELSIF p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE THEN
1889: -- if the block_name_code is passed in as NULL
1890: -- its an error else validate.
1891: if p_block_name_code IS NULL THEN
1892: -- write a mandatory attributes missing message

Line 1894: CSC_CORE_UTILS_PVT.mandatory_arg_error(

1890: -- its an error else validate.
1891: if p_block_name_code IS NULL THEN
1892: -- write a mandatory attributes missing message
1893: x_return_status := FND_API.G_RET_STS_ERROR;
1894: CSC_CORE_UTILS_PVT.mandatory_arg_error(
1895: p_api_name => p_api_name,
1896: p_argument => 'p_block_name_code',
1897: p_argument_value => p_block_name_code);
1898: elsif p_block_name_code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR then

Line 1898: elsif p_block_name_code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR then

1894: CSC_CORE_UTILS_PVT.mandatory_arg_error(
1895: p_api_name => p_api_name,
1896: p_argument => 'p_block_name_code',
1897: p_argument_value => p_block_name_code);
1898: elsif p_block_name_code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR then
1899: open get_block_code;
1900: loop
1901: fetch get_block_code into l_dummy;
1902: -- if the block_name_code passed in is the same as

Line 1907: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg

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

Line 1948: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(

1944: RAISE FND_API.G_EXC_ERROR;
1945: END IF;
1946:
1947: -- validate start and end date
1948: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(
1949: p_api_name => p_Api_name,
1950: p_start_date => p_validate_rec.start_date_active,
1951: p_end_date => p_validate_rec.end_date_active,
1952: x_return_status => x_return_status );

Line 2038: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (

2034: RAISE FND_API.G_EXC_ERROR;
2035: END IF;
2036:
2037: /* This Call added for Enhancement 1781726 for Validating Application_id*/
2038: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (
2039: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
2040: P_Application_ID =>p_validate_rec.application_id,
2041: X_Return_Status => x_return_status,
2042: X_Msg_Count => x_msg_count,

Line 2039: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,

2035: END IF;
2036:
2037: /* This Call added for Enhancement 1781726 for Validating Application_id*/
2038: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (
2039: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
2040: P_Application_ID =>p_validate_rec.application_id,
2041: X_Return_Status => x_return_status,
2042: X_Msg_Count => x_msg_count,
2043: X_Msg_Data => x_msg_data,

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

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

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

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

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

2165: -- Description: Validates the block_id using the table
2166: -- cs_prof_blocks.
2167: -- Input Parameters
2168: -- p_api_name, standard parameter for writting messages
2169: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
2170: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
2171: -- p_block_id, block_id to be validated while updating
2172: -- Out Parameters
2173: -- x_return_status, standard parameter for the return status

Line 2170: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable

2166: -- cs_prof_blocks.
2167: -- Input Parameters
2168: -- p_api_name, standard parameter for writting messages
2169: -- p_validation_mode, whether an update or an insert uses CSC_CORE_UTILS_PVT.G_UPDATE
2170: -- or CSC_CORE_UTILS_PVT.G_CREATE global variable
2171: -- p_block_id, block_id to be validated while updating
2172: -- Out Parameters
2173: -- x_return_status, standard parameter for the return status
2174: --------------------------------------------------------------------------

Line 2200: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

Line 2218: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN

2214: x_return_status := FND_API.G_RET_STS_SUCCESS;
2215:
2216:
2217: --
2218: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN
2219:
2220: IF ( p_block_id <> CSC_CORE_UTILS_PVT.G_MISS_NUM ) AND
2221: ( p_block_id IS NOT NULL )
2222: THEN

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

2216:
2217: --
2218: IF p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE THEN
2219:
2220: IF ( p_block_id <> CSC_CORE_UTILS_PVT.G_MISS_NUM ) AND
2221: ( p_block_id IS NOT NULL )
2222: THEN
2223: x_return_status := chk_block_id( p_block_id );
2224: ELSE

Line 2226: CSC_CORE_UTILS_PVT.mandatory_arg_error(

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

Line 2232: ELSIF p_Validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE THEN

2228: p_argument => 'p_block_id',
2229: p_argument_value => p_block_id);
2230: END IF;
2231:
2232: ELSIF p_Validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE THEN
2233:
2234: IF ( p_block_id <> CSC_CORE_UTILS_PVT.G_MISS_NUM )
2235: THEN
2236: IF (p_block_id IS NOT NULL ) THEN

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

2230: END IF;
2231:
2232: ELSIF p_Validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE THEN
2233:
2234: IF ( p_block_id <> CSC_CORE_UTILS_PVT.G_MISS_NUM )
2235: THEN
2236: IF (p_block_id IS NOT NULL ) THEN
2237: x_return_status := chk_block_id( p_block_id );
2238: ELSE

Line 2240: CSC_CORE_UTILS_PVT.mandatory_arg_error(

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

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

2271:
2272: -- Initialize API return status to SUCCESS
2273: x_return_status := FND_API.G_RET_STS_SUCCESS;
2274:
2275: IF p_TABLE_NAME is not NULL and p_TABLE_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
2276: THEN
2277: Open get_tname_csr;
2278: Fetch get_tname_csr into l_dummy;
2279: IF get_tname_csr%NOTFOUND THEN

Line 2284: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

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

2316: -- Initialize API return status to SUCCESS
2317: x_return_status := FND_API.G_RET_STS_SUCCESS;
2318:
2319:
2320: IF p_COLUMN_NAME is not NULL and p_COLUMN_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
2321: THEN
2322: Open get_cname_csr;
2323: Fetch get_cname_csr into l_dummy;
2324: IF get_cname_csr%NOTFOUND THEN

Line 2329: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

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

2339: END Validate_COLUMN_NAME;
2340:
2341: PROCEDURE Validate_Table_Column(
2342: P_Api_Name IN VARCHAR2,
2343: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
2344: P_Validation_mode IN VARCHAR2,
2345: p_validate_rec IN Table_Column_Rec_Type,
2346: X_Return_Status OUT NOCOPY VARCHAR2
2347: )

Line 2386: CSC_CORE_UTILS_PVT.mandatory_arg_error(

2382: END IF;
2383:
2384:
2385: IF p_validate_rec.COLUMN_SEQUENCE is NULL THEN
2386: CSC_CORE_UTILS_PVT.mandatory_arg_error(
2387: p_api_name => p_api_name,
2388: p_argument => 'p_Column_Sequence',
2389: p_argument_value => p_validate_rec.Column_Sequence);
2390: END IF;