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.BIS_DIMENSION_LEVEL_PVT dependencies on BIS_UTILITIES_PVT

Line 137: := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Dimension_ID);

133: IS
134: BEGIN
135:
136: x_dimension_level_rec.Dimension_ID
137: := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Dimension_ID);
138: x_dimension_level_rec.Dimension_Short_Name
139: := BIS_UTILITIES_PVT.CheckMissChar(
140: p_dimension_level_rec.Dimension_Short_Name);
141: x_dimension_level_rec.Dimension_Name

Line 139: := BIS_UTILITIES_PVT.CheckMissChar(

135:
136: x_dimension_level_rec.Dimension_ID
137: := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Dimension_ID);
138: x_dimension_level_rec.Dimension_Short_Name
139: := BIS_UTILITIES_PVT.CheckMissChar(
140: p_dimension_level_rec.Dimension_Short_Name);
141: x_dimension_level_rec.Dimension_Name
142: := BIS_UTILITIES_PVT.CheckMissChar(
143: p_dimension_level_rec.Dimension_Name);

Line 142: := BIS_UTILITIES_PVT.CheckMissChar(

138: x_dimension_level_rec.Dimension_Short_Name
139: := BIS_UTILITIES_PVT.CheckMissChar(
140: p_dimension_level_rec.Dimension_Short_Name);
141: x_dimension_level_rec.Dimension_Name
142: := BIS_UTILITIES_PVT.CheckMissChar(
143: p_dimension_level_rec.Dimension_Name);
144:
145: x_dimension_level_rec.Dimension_Level_ID
146: := BIS_UTILITIES_PVT.CheckMissNum(

Line 146: := BIS_UTILITIES_PVT.CheckMissNum(

142: := BIS_UTILITIES_PVT.CheckMissChar(
143: p_dimension_level_rec.Dimension_Name);
144:
145: x_dimension_level_rec.Dimension_Level_ID
146: := BIS_UTILITIES_PVT.CheckMissNum(
147: p_dimension_level_rec.Dimension_Level_ID);
148: x_dimension_level_rec.Dimension_Level_Short_Name
149: := BIS_UTILITIES_PVT.CheckMissChar(
150: p_dimension_level_rec.Dimension_Level_Short_Name);

Line 149: := BIS_UTILITIES_PVT.CheckMissChar(

145: x_dimension_level_rec.Dimension_Level_ID
146: := BIS_UTILITIES_PVT.CheckMissNum(
147: p_dimension_level_rec.Dimension_Level_ID);
148: x_dimension_level_rec.Dimension_Level_Short_Name
149: := BIS_UTILITIES_PVT.CheckMissChar(
150: p_dimension_level_rec.Dimension_Level_Short_Name);
151: x_dimension_level_rec.Dimension_Level_Name
152: := BIS_UTILITIES_PVT.CheckMissChar(
153: p_dimension_level_rec.Dimension_Level_Name);

Line 152: := BIS_UTILITIES_PVT.CheckMissChar(

148: x_dimension_level_rec.Dimension_Level_Short_Name
149: := BIS_UTILITIES_PVT.CheckMissChar(
150: p_dimension_level_rec.Dimension_Level_Short_Name);
151: x_dimension_level_rec.Dimension_Level_Name
152: := BIS_UTILITIES_PVT.CheckMissChar(
153: p_dimension_level_rec.Dimension_Level_Name);
154: x_dimension_level_rec.Description
155: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Description);
156: x_dimension_level_rec.Level_Values_View_Name

Line 155: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Description);

151: x_dimension_level_rec.Dimension_Level_Name
152: := BIS_UTILITIES_PVT.CheckMissChar(
153: p_dimension_level_rec.Dimension_Level_Name);
154: x_dimension_level_rec.Description
155: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Description);
156: x_dimension_level_rec.Level_Values_View_Name
157: := BIS_UTILITIES_PVT.CheckMissChar(
158: p_dimension_level_rec.Level_Values_View_Name);
159: x_dimension_level_rec.where_Clause

Line 157: := BIS_UTILITIES_PVT.CheckMissChar(

153: p_dimension_level_rec.Dimension_Level_Name);
154: x_dimension_level_rec.Description
155: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Description);
156: x_dimension_level_rec.Level_Values_View_Name
157: := BIS_UTILITIES_PVT.CheckMissChar(
158: p_dimension_level_rec.Level_Values_View_Name);
159: x_dimension_level_rec.where_Clause
160: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.where_Clause);
161: x_dimension_level_rec.source

Line 160: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.where_Clause);

156: x_dimension_level_rec.Level_Values_View_Name
157: := BIS_UTILITIES_PVT.CheckMissChar(
158: p_dimension_level_rec.Level_Values_View_Name);
159: x_dimension_level_rec.where_Clause
160: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.where_Clause);
161: x_dimension_level_rec.source
162: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.source);
163: --jxyu added for #2435226
164: x_dimension_level_rec.Comparison_Label_Code

Line 162: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.source);

158: p_dimension_level_rec.Level_Values_View_Name);
159: x_dimension_level_rec.where_Clause
160: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.where_Clause);
161: x_dimension_level_rec.source
162: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.source);
163: --jxyu added for #2435226
164: x_dimension_level_rec.Comparison_Label_Code
165: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Comparison_Label_Code);
166: x_dimension_level_rec.Attribute_Code

Line 165: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Comparison_Label_Code);

161: x_dimension_level_rec.source
162: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.source);
163: --jxyu added for #2435226
164: x_dimension_level_rec.Comparison_Label_Code
165: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Comparison_Label_Code);
166: x_dimension_level_rec.Attribute_Code
167: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Attribute_Code);
168: x_dimension_level_rec.Application_ID
169: := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Application_ID);

Line 167: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Attribute_Code);

163: --jxyu added for #2435226
164: x_dimension_level_rec.Comparison_Label_Code
165: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Comparison_Label_Code);
166: x_dimension_level_rec.Attribute_Code
167: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Attribute_Code);
168: x_dimension_level_rec.Application_ID
169: := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Application_ID);
170: x_dimension_level_rec.default_search
171: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.default_search);

Line 169: := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Application_ID);

165: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Comparison_Label_Code);
166: x_dimension_level_rec.Attribute_Code
167: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Attribute_Code);
168: x_dimension_level_rec.Application_ID
169: := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Application_ID);
170: x_dimension_level_rec.default_search
171: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.default_search);
172: x_dimension_level_rec.Long_Lov
173: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Long_Lov);

Line 171: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.default_search);

167: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Attribute_Code);
168: x_dimension_level_rec.Application_ID
169: := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Application_ID);
170: x_dimension_level_rec.default_search
171: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.default_search);
172: x_dimension_level_rec.Long_Lov
173: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Long_Lov);
174: x_dimension_level_rec.Master_Level
175: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Master_Level);

Line 173: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Long_Lov);

169: := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Application_ID);
170: x_dimension_level_rec.default_search
171: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.default_search);
172: x_dimension_level_rec.Long_Lov
173: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Long_Lov);
174: x_dimension_level_rec.Master_Level
175: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Master_Level);
176: x_dimension_level_rec.View_Object_Name
177: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.View_Object_Name);

Line 175: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Master_Level);

171: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.default_search);
172: x_dimension_level_rec.Long_Lov
173: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Long_Lov);
174: x_dimension_level_rec.Master_Level
175: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Master_Level);
176: x_dimension_level_rec.View_Object_Name
177: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.View_Object_Name);
178: x_dimension_level_rec.Default_Values_Api
179: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Default_Values_Api);

Line 177: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.View_Object_Name);

173: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Long_Lov);
174: x_dimension_level_rec.Master_Level
175: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Master_Level);
176: x_dimension_level_rec.View_Object_Name
177: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.View_Object_Name);
178: x_dimension_level_rec.Default_Values_Api
179: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Default_Values_Api);
180: x_dimension_level_rec.Enabled
181: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Enabled);

Line 179: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Default_Values_Api);

175: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Master_Level);
176: x_dimension_level_rec.View_Object_Name
177: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.View_Object_Name);
178: x_dimension_level_rec.Default_Values_Api
179: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Default_Values_Api);
180: x_dimension_level_rec.Enabled
181: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Enabled);
182: x_dimension_level_rec.Drill_To_Form_Function
183: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Drill_To_Form_Function);

Line 181: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Enabled);

177: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.View_Object_Name);
178: x_dimension_level_rec.Default_Values_Api
179: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Default_Values_Api);
180: x_dimension_level_rec.Enabled
181: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Enabled);
182: x_dimension_level_rec.Drill_To_Form_Function
183: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Drill_To_Form_Function);
184: x_dimension_level_rec.Hide
185: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Hide);

Line 183: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Drill_To_Form_Function);

179: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Default_Values_Api);
180: x_dimension_level_rec.Enabled
181: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Enabled);
182: x_dimension_level_rec.Drill_To_Form_Function
183: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Drill_To_Form_Function);
184: x_dimension_level_rec.Hide
185: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Hide);
186: x_dimension_level_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Created_By);
187: x_dimension_level_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_dimension_level_rec.Creation_Date);

Line 185: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Hide);

181: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Enabled);
182: x_dimension_level_rec.Drill_To_Form_Function
183: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Drill_To_Form_Function);
184: x_dimension_level_rec.Hide
185: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Hide);
186: x_dimension_level_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Created_By);
187: x_dimension_level_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_dimension_level_rec.Creation_Date);
188: x_dimension_level_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Last_Updated_By);
189: x_dimension_level_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_dimension_level_rec.Last_Update_Date);

Line 186: x_dimension_level_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Created_By);

182: x_dimension_level_rec.Drill_To_Form_Function
183: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Drill_To_Form_Function);
184: x_dimension_level_rec.Hide
185: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Hide);
186: x_dimension_level_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Created_By);
187: x_dimension_level_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_dimension_level_rec.Creation_Date);
188: x_dimension_level_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Last_Updated_By);
189: x_dimension_level_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_dimension_level_rec.Last_Update_Date);
190: x_dimension_level_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Last_Update_Login);

Line 187: x_dimension_level_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_dimension_level_rec.Creation_Date);

183: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Drill_To_Form_Function);
184: x_dimension_level_rec.Hide
185: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Hide);
186: x_dimension_level_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Created_By);
187: x_dimension_level_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_dimension_level_rec.Creation_Date);
188: x_dimension_level_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Last_Updated_By);
189: x_dimension_level_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_dimension_level_rec.Last_Update_Date);
190: x_dimension_level_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Last_Update_Login);
191:

Line 188: x_dimension_level_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Last_Updated_By);

184: x_dimension_level_rec.Hide
185: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Hide);
186: x_dimension_level_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Created_By);
187: x_dimension_level_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_dimension_level_rec.Creation_Date);
188: x_dimension_level_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Last_Updated_By);
189: x_dimension_level_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_dimension_level_rec.Last_Update_Date);
190: x_dimension_level_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Last_Update_Login);
191:
192: EXCEPTION

Line 189: x_dimension_level_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_dimension_level_rec.Last_Update_Date);

185: := BIS_UTILITIES_PVT.CheckMissChar(p_dimension_level_rec.Hide);
186: x_dimension_level_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Created_By);
187: x_dimension_level_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_dimension_level_rec.Creation_Date);
188: x_dimension_level_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Last_Updated_By);
189: x_dimension_level_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_dimension_level_rec.Last_Update_Date);
190: x_dimension_level_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Last_Update_Login);
191:
192: EXCEPTION
193: WHEN FND_API.G_EXC_ERROR THEN

Line 190: x_dimension_level_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Last_Update_Login);

186: x_dimension_level_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Created_By);
187: x_dimension_level_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_dimension_level_rec.Creation_Date);
188: x_dimension_level_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Last_Updated_By);
189: x_dimension_level_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_dimension_level_rec.Last_Update_Date);
190: x_dimension_level_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_dimension_level_rec.Last_Update_Login);
191:
192: EXCEPTION
193: WHEN FND_API.G_EXC_ERROR THEN
194: RAISE

Line 363: BIS_UTILITIES_PVT.Add_Error_Message

359: --RAISE;
360: WHEN OTHERS THEN
361: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
362: l_error_tbl := x_error_tbl;
363: BIS_UTILITIES_PVT.Add_Error_Message
364: ( p_error_table => l_error_Tbl
365: , p_error_msg_id => SQLCODE
366: , p_error_description => SQLERRM
367: , x_error_table => x_error_Tbl

Line 571: BIS_UTILITIES_PVT.Add_Error_Message

567:
568: ELSE
569: --added Add Error Message
570: l_error_tbl := x_error_tbl;
571: BIS_UTILITIES_PVT.Add_Error_Message
572: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
573: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
574: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension_Levels'
575: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 586: BIS_UTILITIES_PVT.Add_Error_Message

582:
583: --added this check
584: IF l_flag = 0 then
585: l_error_tbl := x_error_tbl;
586: BIS_UTILITIES_PVT.Add_Error_Message
587: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
588: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
589: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension_Levels'
590: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 613: BIS_UTILITIES_PVT.Add_Error_Message

609: when others then
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
611: l_error_tbl := x_error_tbl;
612: --added last two parameters
613: BIS_UTILITIES_PVT.Add_Error_Message
614: ( p_error_msg_id => SQLCODE
615: , p_error_description => SQLERRM
616: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension_Levels'
617: , p_error_table => l_error_tbl

Line 819: BIS_UTILITIES_PVT.Add_Error_Message

815: CLOSE cr_lev_name;
816: ELSE
817: l_error_tbl := x_error_tbl;
818: --added Error Msg
819: BIS_UTILITIES_PVT.Add_Error_Message
820: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_VALUE'
821: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
822: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension_Level'
823: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 833: BIS_UTILITIES_PVT.Add_Error_Message

829:
830: --added this check
831: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
832: l_error_tbl := x_error_tbl;
833: BIS_UTILITIES_PVT.Add_Error_Message
834: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_VALUE'
835: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
836: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension_Level'
837: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 859: BIS_UTILITIES_PVT.Add_Error_Message

855: when others then
856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
857: l_error_tbl := x_error_tbl;
858: --added last two parameters
859: BIS_UTILITIES_PVT.Add_Error_Message
860: ( p_error_msg_id => SQLCODE
861: , p_error_description => SQLERRM
862: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension_Level'
863: , p_error_table => l_error_tbl

Line 966: BIS_UTILITIES_PVT.Add_Error_Message(

962: END IF;
963:
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
965: l_error_tbl := x_error_tbl;
966: BIS_UTILITIES_PVT.Add_Error_Message(
967: p_error_msg_id => SQLCODE
968: , p_error_description => SQLERRM
969: , p_error_proc_name => G_PKG_NAME||'.retrieve_multiple_dim_levels'
970: , p_error_table => l_error_tbl

Line 1098: BIS_UTILITIES_PVT.Add_Error_Message

1094: when others then
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1096: l_error_tbl := x_error_tbl;
1097: --added last two parameters
1098: BIS_UTILITIES_PVT.Add_Error_Message
1099: ( p_error_msg_id => SQLCODE
1100: , p_error_description => SQLERRM
1101: , p_error_proc_name => G_PKG_NAME||'.Create_Dimension_Level'
1102: , p_error_table => l_error_tbl

Line 1166: BIS_UTILITIES_PVT.Add_Error_Message

1162:
1163:
1164: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1165: l_error_tbl := x_error_tbl;
1166: BIS_UTILITIES_PVT.Add_Error_Message
1167: ( p_error_msg_name => 'BIS_NAME_SHORT_NAME_MISSING'
1168: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1169: , p_error_proc_name => G_PKG_NAME||'.Create_Dimension_Level'
1170: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1268: BIS_UTILITIES_PVT.Add_Error_Message

1264:
1265: WHEN DUPLICATE_DIMENSION_VALUE THEN
1266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1267: l_error_tbl := x_error_tbl;
1268: BIS_UTILITIES_PVT.Add_Error_Message
1269: ( p_error_msg_name => 'BIS_DIM_LEVEL_UNIQUENESS_ERROR'
1270: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1271: , p_error_proc_name => G_PKG_NAME||'.Create_Dimension_Level'
1272: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1289: BIS_UTILITIES_PVT.Add_Error_Message

1285:
1286: when others then
1287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1288: l_error_tbl := x_error_tbl;
1289: BIS_UTILITIES_PVT.Add_Error_Message
1290: ( p_error_msg_id => SQLCODE
1291: , p_error_description => SQLERRM
1292: , p_error_proc_name => G_PKG_NAME||'.Create_Dimension_Level'
1293: , p_error_table => l_error_tbl

Line 1517: BIS_UTILITIES_PVT.Add_Error_Message

1513: when others then
1514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1515: l_error_tbl := x_error_tbl;
1516: --added last two paramaters
1517: BIS_UTILITIES_PVT.Add_Error_Message
1518: ( p_error_msg_id => SQLCODE
1519: , p_error_description => SQLERRM
1520: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension_Level'
1521: , p_error_table => l_error_tbl

Line 1571: BIS_UTILITIES_PVT.Add_Error_Message

1567:
1568: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1569: l_error_tbl := x_error_tbl;
1570: --added Error Msg--------
1571: BIS_UTILITIES_PVT.Add_Error_Message
1572: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
1573: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1574: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension_Level'
1575: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1652: BIS_UTILITIES_PVT.Add_Error_Message

1648: --new exception
1649: WHEN DUPLICATE_DIMENSION_VALUE THEN
1650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1651: l_error_tbl := x_error_tbl;
1652: BIS_UTILITIES_PVT.Add_Error_Message
1653: ( p_error_msg_name => 'BIS_DIM_LEVEL_UNIQUENESS_ERROR'
1654: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1655: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension_Level'
1656: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1673: BIS_UTILITIES_PVT.Add_Error_Message

1669: when others then
1670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1671: l_error_tbl := x_error_tbl;
1672: --added last two parameters
1673: BIS_UTILITIES_PVT.Add_Error_Message
1674: ( p_error_msg_id => SQLCODE
1675: , p_error_description => SQLERRM
1676: , p_error_proc_name => G_PKG_NAME||'.Create_Dimension_Level'
1677: , p_error_table => l_error_tbl

Line 1718: BIS_UTILITIES_PVT.Add_Error_Message

1714: when others then
1715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1716: l_error_tbl := x_error_tbl;
1717: --added last two paramaters
1718: BIS_UTILITIES_PVT.Add_Error_Message
1719: ( p_error_msg_id => SQLCODE
1720: , p_error_description => SQLERRM
1721: , p_error_proc_name => G_PKG_NAME||'.Translate_Dimension_Level'
1722: , p_error_table => l_error_tbl

Line 1802: BIS_UTILITIES_PVT.Add_Error_Message

1798: when others then
1799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1800: l_error_tbl := x_error_tbl;
1801: --added last two parameters
1802: BIS_UTILITIES_PVT.Add_Error_Message
1803: ( p_error_msg_id => SQLCODE
1804: , p_error_description => SQLERRM
1805: , p_error_proc_name => G_PKG_NAME||'.Translate_Dimension_Level'
1806: , p_error_table => l_error_tbl

Line 1878: BIS_UTILITIES_PVT.Add_Error_Message

1874: when others then
1875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1876: l_error_tbl := x_error_tbl;
1877: --added last two parameters
1878: BIS_UTILITIES_PVT.Add_Error_Message
1879: ( p_error_msg_id => SQLCODE
1880: , p_error_description => SQLERRM
1881: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
1882: , p_error_table => l_error_tbl

Line 1918: BIS_UTILITIES_PVT.Add_Error_Message

1914: else
1915:
1916: -- POPULATE THE ERROR TABLE: added last two parameters
1917: l_error_tbl := x_error_tbl;
1918: BIS_UTILITIES_PVT.Add_Error_Message
1919: ( p_error_msg_name => 'BIS_NAME_SHORT_NAME_MISSING'
1920: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1921: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
1922: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1940: BIS_UTILITIES_PVT.Add_Error_Message

1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1937: when others then
1938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1939: l_error_tbl := x_error_tbl;
1940: BIS_UTILITIES_PVT.Add_Error_Message
1941: ( p_error_msg_id => SQLCODE
1942: , p_error_description => SQLERRM
1943: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
1944: , p_error_table => l_error_tbl

Line 1976: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_tbl_p

1972: EXCEPTION
1973: when FND_API.G_EXC_ERROR then
1974: l_error := FND_API.G_TRUE;
1975: l_error_tbl_p := x_error_tbl;
1976: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_tbl_p
1977: , l_error_Tbl
1978: , x_error_tbl
1979: );
1980: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2002: BIS_UTILITIES_PVT.Add_Error_Message

1998: when others then
1999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2000: l_error_tbl_p := x_error_tbl;
2001: --added last two parameters
2002: BIS_UTILITIES_PVT.Add_Error_Message
2003: ( p_error_msg_id => SQLCODE
2004: , p_error_description => SQLERRM
2005: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension_Level'
2006: , p_error_table => l_error_tbl_p

Line 2043: BIS_UTILITIES_PVT.Add_Error_Message

2039: FETCH cr_dim_short_name
2040: INTO l_dim_level_id;
2041: ELSE
2042: l_error_tbl := x_error_tbl;
2043: BIS_UTILITIES_PVT.Add_Error_Message
2044: ( p_error_msg_name => 'BIS_NAME_SHORT_NAME_MISSING'
2045: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2046: , p_error_proc_name => G_PKG_NAME||'.Delete_Dimension_Level'
2047: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2074: BIS_UTILITIES_PVT.Add_Error_Message

2070: END IF;
2071: ROLLBACK TO DeleteFromBISDimLevs;
2072: WHEN OTHERS THEN
2073: l_error_tbl := x_error_tbl;
2074: BIS_UTILITIES_PVT.Add_Error_Message
2075: ( p_error_msg_id => SQLCODE
2076: , p_error_description => SQLERRM
2077: , p_error_proc_name => G_PKG_NAME||'.Delete_Dimension_Level'
2078: , p_error_table => l_error_tbl

Line 2145: BIS_UTILITIES_PVT.Add_Error_Message

2141: ROLLBACK TO TransDimObjByLangPvt;
2142: WHEN OTHERS THEN
2143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2144: l_error_tbl := x_error_tbl;
2145: BIS_UTILITIES_PVT.Add_Error_Message
2146: ( p_error_msg_id => SQLCODE
2147: , p_error_description => SQLERRM
2148: , p_error_proc_name => G_PKG_NAME||'.Trans_DimObj_By_Given_Lang'
2149: , p_error_table => l_error_tbl

Line 2439: BIS_UTILITIES_PVT.Add_Error_Message

2435: IF ( isPMFDimensionLevel( p_dim_level_id => p_dim_level_id )) THEN
2436:
2437: -- check if this dimension level is used to set target
2438: IF ( IS_TARGET_DEFINED(p_dim_level_id => p_dim_level_id) ) THEN
2439: BIS_UTILITIES_PVT.Add_Error_Message
2440: ( p_error_msg_name => 'BIS_PMF_DIM_LVL_USED_IN_TARGET'
2441: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2442: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension_Level'
2443: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2452: BIS_UTILITIES_PVT.Add_Error_Message

2448: END IF;
2449:
2450: -- check if this dimension level is assigned to a KPI
2451: IF ( IS_ASSIGNED_TO_KPI(p_dim_level_id => p_dim_level_id) ) THEN
2452: BIS_UTILITIES_PVT.Add_Error_Message
2453: ( p_error_msg_name => 'BIS_BSC_DIM_LVL_KPI_ASSIGNED'
2454: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2455: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension_Level'
2456: , p_error_type => BIS_UTILITIES_PUB.G_ERROR