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_TARGET_LEVEL_PVT dependencies on BIS_UTILITIES_PVT

Line 199: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Measure_ID);

195: IS
196: BEGIN
197:
198: x_target_level_rec.Measure_ID :=
199: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Measure_ID);
200: x_target_level_rec.Measure_Short_Name :=
201: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Measure_Short_Name);
202: x_target_level_rec.Measure_Name :=
203: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Measure_Name);

Line 201: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Measure_Short_Name);

197:
198: x_target_level_rec.Measure_ID :=
199: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Measure_ID);
200: x_target_level_rec.Measure_Short_Name :=
201: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Measure_Short_Name);
202: x_target_level_rec.Measure_Name :=
203: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Measure_Name);
204: x_target_level_rec.Target_Level_ID :=
205: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Target_Level_ID);

Line 203: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Measure_Name);

199: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Measure_ID);
200: x_target_level_rec.Measure_Short_Name :=
201: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Measure_Short_Name);
202: x_target_level_rec.Measure_Name :=
203: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Measure_Name);
204: x_target_level_rec.Target_Level_ID :=
205: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Target_Level_ID);
206: x_target_level_rec.Target_Level_Short_Name :=
207: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Target_Level_Short_Name);

Line 205: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Target_Level_ID);

201: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Measure_Short_Name);
202: x_target_level_rec.Measure_Name :=
203: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Measure_Name);
204: x_target_level_rec.Target_Level_ID :=
205: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Target_Level_ID);
206: x_target_level_rec.Target_Level_Short_Name :=
207: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Target_Level_Short_Name);
208: x_target_level_rec.Target_Level_Name :=
209: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Target_Level_Name);

Line 207: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Target_Level_Short_Name);

203: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Measure_Name);
204: x_target_level_rec.Target_Level_ID :=
205: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Target_Level_ID);
206: x_target_level_rec.Target_Level_Short_Name :=
207: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Target_Level_Short_Name);
208: x_target_level_rec.Target_Level_Name :=
209: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Target_Level_Name);
210: x_target_level_rec.Description :=
211: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Description);

Line 209: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Target_Level_Name);

205: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Target_Level_ID);
206: x_target_level_rec.Target_Level_Short_Name :=
207: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Target_Level_Short_Name);
208: x_target_level_rec.Target_Level_Name :=
209: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Target_Level_Name);
210: x_target_level_rec.Description :=
211: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Description);
212: x_target_level_rec.Org_Level_ID :=
213: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Org_Level_ID);

Line 211: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Description);

207: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Target_Level_Short_Name);
208: x_target_level_rec.Target_Level_Name :=
209: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Target_Level_Name);
210: x_target_level_rec.Description :=
211: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Description);
212: x_target_level_rec.Org_Level_ID :=
213: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Org_Level_ID);
214: x_target_level_rec.Org_Level_Short_Name :=
215: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Org_Level_Short_Name);

Line 213: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Org_Level_ID);

209: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Target_Level_Name);
210: x_target_level_rec.Description :=
211: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Description);
212: x_target_level_rec.Org_Level_ID :=
213: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Org_Level_ID);
214: x_target_level_rec.Org_Level_Short_Name :=
215: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Org_Level_Short_Name);
216: x_target_level_rec.Org_Level_Name :=
217: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Org_Level_Name);

Line 215: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Org_Level_Short_Name);

211: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Description);
212: x_target_level_rec.Org_Level_ID :=
213: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Org_Level_ID);
214: x_target_level_rec.Org_Level_Short_Name :=
215: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Org_Level_Short_Name);
216: x_target_level_rec.Org_Level_Name :=
217: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Org_Level_Name);
218: x_target_level_rec.Time_Level_ID :=
219: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Time_Level_ID);

Line 217: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Org_Level_Name);

213: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Org_Level_ID);
214: x_target_level_rec.Org_Level_Short_Name :=
215: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Org_Level_Short_Name);
216: x_target_level_rec.Org_Level_Name :=
217: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Org_Level_Name);
218: x_target_level_rec.Time_Level_ID :=
219: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Time_Level_ID);
220: x_target_level_rec.Time_Level_Short_Name :=
221: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Time_Level_Short_Name);

Line 219: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Time_Level_ID);

215: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Org_Level_Short_Name);
216: x_target_level_rec.Org_Level_Name :=
217: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Org_Level_Name);
218: x_target_level_rec.Time_Level_ID :=
219: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Time_Level_ID);
220: x_target_level_rec.Time_Level_Short_Name :=
221: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Time_Level_Short_Name);
222: x_target_level_rec.Time_Level_Name :=
223: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Time_Level_Name);

Line 221: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Time_Level_Short_Name);

217: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Org_Level_Name);
218: x_target_level_rec.Time_Level_ID :=
219: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Time_Level_ID);
220: x_target_level_rec.Time_Level_Short_Name :=
221: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Time_Level_Short_Name);
222: x_target_level_rec.Time_Level_Name :=
223: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Time_Level_Name);
224: x_target_level_rec.Dimension1_Level_ID :=
225: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension1_Level_ID);

Line 223: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Time_Level_Name);

219: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Time_Level_ID);
220: x_target_level_rec.Time_Level_Short_Name :=
221: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Time_Level_Short_Name);
222: x_target_level_rec.Time_Level_Name :=
223: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Time_Level_Name);
224: x_target_level_rec.Dimension1_Level_ID :=
225: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension1_Level_ID);
226: x_target_level_rec.Dimension1_Level_Short_Name :=
227: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension1_Level_Short_Name);

Line 225: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension1_Level_ID);

221: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Time_Level_Short_Name);
222: x_target_level_rec.Time_Level_Name :=
223: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Time_Level_Name);
224: x_target_level_rec.Dimension1_Level_ID :=
225: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension1_Level_ID);
226: x_target_level_rec.Dimension1_Level_Short_Name :=
227: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension1_Level_Short_Name);
228: x_target_level_rec.Dimension1_Level_Name :=
229: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension1_Level_Name);

Line 227: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension1_Level_Short_Name);

223: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Time_Level_Name);
224: x_target_level_rec.Dimension1_Level_ID :=
225: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension1_Level_ID);
226: x_target_level_rec.Dimension1_Level_Short_Name :=
227: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension1_Level_Short_Name);
228: x_target_level_rec.Dimension1_Level_Name :=
229: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension1_Level_Name);
230: x_target_level_rec.Dimension2_Level_ID :=
231: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension2_Level_ID);

Line 229: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension1_Level_Name);

225: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension1_Level_ID);
226: x_target_level_rec.Dimension1_Level_Short_Name :=
227: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension1_Level_Short_Name);
228: x_target_level_rec.Dimension1_Level_Name :=
229: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension1_Level_Name);
230: x_target_level_rec.Dimension2_Level_ID :=
231: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension2_Level_ID);
232: x_target_level_rec.Dimension2_Level_Short_Name :=
233: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension2_Level_Short_Name);

Line 231: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension2_Level_ID);

227: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension1_Level_Short_Name);
228: x_target_level_rec.Dimension1_Level_Name :=
229: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension1_Level_Name);
230: x_target_level_rec.Dimension2_Level_ID :=
231: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension2_Level_ID);
232: x_target_level_rec.Dimension2_Level_Short_Name :=
233: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension2_Level_Short_Name);
234: x_target_level_rec.Dimension2_Level_Name :=
235: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension2_Level_Name);

Line 233: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension2_Level_Short_Name);

229: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension1_Level_Name);
230: x_target_level_rec.Dimension2_Level_ID :=
231: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension2_Level_ID);
232: x_target_level_rec.Dimension2_Level_Short_Name :=
233: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension2_Level_Short_Name);
234: x_target_level_rec.Dimension2_Level_Name :=
235: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension2_Level_Name);
236: x_target_level_rec.Dimension3_Level_ID :=
237: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension3_Level_ID);

Line 235: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension2_Level_Name);

231: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension2_Level_ID);
232: x_target_level_rec.Dimension2_Level_Short_Name :=
233: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension2_Level_Short_Name);
234: x_target_level_rec.Dimension2_Level_Name :=
235: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension2_Level_Name);
236: x_target_level_rec.Dimension3_Level_ID :=
237: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension3_Level_ID);
238: x_target_level_rec.Dimension3_Level_Short_Name :=
239: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension3_Level_Short_Name);

Line 237: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension3_Level_ID);

233: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension2_Level_Short_Name);
234: x_target_level_rec.Dimension2_Level_Name :=
235: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension2_Level_Name);
236: x_target_level_rec.Dimension3_Level_ID :=
237: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension3_Level_ID);
238: x_target_level_rec.Dimension3_Level_Short_Name :=
239: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension3_Level_Short_Name);
240: x_target_level_rec.Dimension3_Level_Name :=
241: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension3_Level_Name);

Line 239: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension3_Level_Short_Name);

235: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension2_Level_Name);
236: x_target_level_rec.Dimension3_Level_ID :=
237: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension3_Level_ID);
238: x_target_level_rec.Dimension3_Level_Short_Name :=
239: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension3_Level_Short_Name);
240: x_target_level_rec.Dimension3_Level_Name :=
241: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension3_Level_Name);
242: x_target_level_rec.Dimension4_Level_ID :=
243: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension4_Level_ID);

Line 241: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension3_Level_Name);

237: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension3_Level_ID);
238: x_target_level_rec.Dimension3_Level_Short_Name :=
239: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension3_Level_Short_Name);
240: x_target_level_rec.Dimension3_Level_Name :=
241: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension3_Level_Name);
242: x_target_level_rec.Dimension4_Level_ID :=
243: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension4_Level_ID);
244: x_target_level_rec.Dimension4_Level_Short_Name :=
245: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension4_Level_Short_Name);

Line 243: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension4_Level_ID);

239: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension3_Level_Short_Name);
240: x_target_level_rec.Dimension3_Level_Name :=
241: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension3_Level_Name);
242: x_target_level_rec.Dimension4_Level_ID :=
243: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension4_Level_ID);
244: x_target_level_rec.Dimension4_Level_Short_Name :=
245: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension4_Level_Short_Name);
246: x_target_level_rec.Dimension4_Level_Name :=
247: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension4_Level_Name);

Line 245: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension4_Level_Short_Name);

241: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension3_Level_Name);
242: x_target_level_rec.Dimension4_Level_ID :=
243: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension4_Level_ID);
244: x_target_level_rec.Dimension4_Level_Short_Name :=
245: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension4_Level_Short_Name);
246: x_target_level_rec.Dimension4_Level_Name :=
247: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension4_Level_Name);
248: x_target_level_rec.Dimension5_Level_ID :=
249: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension5_Level_ID);

Line 247: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension4_Level_Name);

243: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension4_Level_ID);
244: x_target_level_rec.Dimension4_Level_Short_Name :=
245: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension4_Level_Short_Name);
246: x_target_level_rec.Dimension4_Level_Name :=
247: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension4_Level_Name);
248: x_target_level_rec.Dimension5_Level_ID :=
249: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension5_Level_ID);
250: x_target_level_rec.Dimension5_Level_Short_Name :=
251: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension5_Level_Short_Name);

Line 249: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension5_Level_ID);

245: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension4_Level_Short_Name);
246: x_target_level_rec.Dimension4_Level_Name :=
247: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension4_Level_Name);
248: x_target_level_rec.Dimension5_Level_ID :=
249: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension5_Level_ID);
250: x_target_level_rec.Dimension5_Level_Short_Name :=
251: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension5_Level_Short_Name);
252: x_target_level_rec.Dimension5_Level_Name :=
253: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension5_Level_Name);

Line 251: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension5_Level_Short_Name);

247: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension4_Level_Name);
248: x_target_level_rec.Dimension5_Level_ID :=
249: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension5_Level_ID);
250: x_target_level_rec.Dimension5_Level_Short_Name :=
251: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension5_Level_Short_Name);
252: x_target_level_rec.Dimension5_Level_Name :=
253: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension5_Level_Name);
254: x_target_level_rec.Dimension6_Level_ID :=
255: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension6_Level_ID);

Line 253: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension5_Level_Name);

249: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension5_Level_ID);
250: x_target_level_rec.Dimension5_Level_Short_Name :=
251: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension5_Level_Short_Name);
252: x_target_level_rec.Dimension5_Level_Name :=
253: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension5_Level_Name);
254: x_target_level_rec.Dimension6_Level_ID :=
255: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension6_Level_ID);
256: x_target_level_rec.Dimension6_Level_Short_Name :=
257: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension6_Level_Short_Name);

Line 255: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension6_Level_ID);

251: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension5_Level_Short_Name);
252: x_target_level_rec.Dimension5_Level_Name :=
253: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension5_Level_Name);
254: x_target_level_rec.Dimension6_Level_ID :=
255: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension6_Level_ID);
256: x_target_level_rec.Dimension6_Level_Short_Name :=
257: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension6_Level_Short_Name);
258: x_target_level_rec.Dimension6_Level_Name :=
259: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension6_Level_Name);

Line 257: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension6_Level_Short_Name);

253: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension5_Level_Name);
254: x_target_level_rec.Dimension6_Level_ID :=
255: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension6_Level_ID);
256: x_target_level_rec.Dimension6_Level_Short_Name :=
257: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension6_Level_Short_Name);
258: x_target_level_rec.Dimension6_Level_Name :=
259: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension6_Level_Name);
260: x_target_level_rec.Dimension7_Level_ID :=
261: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension7_Level_ID);

Line 259: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension6_Level_Name);

255: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension6_Level_ID);
256: x_target_level_rec.Dimension6_Level_Short_Name :=
257: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension6_Level_Short_Name);
258: x_target_level_rec.Dimension6_Level_Name :=
259: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension6_Level_Name);
260: x_target_level_rec.Dimension7_Level_ID :=
261: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension7_Level_ID);
262: x_target_level_rec.Dimension7_Level_Short_Name :=
263: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension7_Level_Short_Name);

Line 261: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension7_Level_ID);

257: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension6_Level_Short_Name);
258: x_target_level_rec.Dimension6_Level_Name :=
259: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension6_Level_Name);
260: x_target_level_rec.Dimension7_Level_ID :=
261: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension7_Level_ID);
262: x_target_level_rec.Dimension7_Level_Short_Name :=
263: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension7_Level_Short_Name);
264: x_target_level_rec.Dimension7_Level_Name :=
265: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension7_Level_Name);

Line 263: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension7_Level_Short_Name);

259: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension6_Level_Name);
260: x_target_level_rec.Dimension7_Level_ID :=
261: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension7_Level_ID);
262: x_target_level_rec.Dimension7_Level_Short_Name :=
263: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension7_Level_Short_Name);
264: x_target_level_rec.Dimension7_Level_Name :=
265: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension7_Level_Name);
266: x_target_level_rec.Workflow_Process_Short_Name :=
267: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Process_Short_Name);

Line 265: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension7_Level_Name);

261: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Dimension7_Level_ID);
262: x_target_level_rec.Dimension7_Level_Short_Name :=
263: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension7_Level_Short_Name);
264: x_target_level_rec.Dimension7_Level_Name :=
265: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension7_Level_Name);
266: x_target_level_rec.Workflow_Process_Short_Name :=
267: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Process_Short_Name);
268: x_target_level_rec.Workflow_Process_Name :=
269: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Process_Name);

Line 267: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Process_Short_Name);

263: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension7_Level_Short_Name);
264: x_target_level_rec.Dimension7_Level_Name :=
265: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension7_Level_Name);
266: x_target_level_rec.Workflow_Process_Short_Name :=
267: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Process_Short_Name);
268: x_target_level_rec.Workflow_Process_Name :=
269: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Process_Name);
270: x_target_level_rec.Workflow_Item_Type :=
271: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Item_Type);

Line 269: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Process_Name);

265: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Dimension7_Level_Name);
266: x_target_level_rec.Workflow_Process_Short_Name :=
267: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Process_Short_Name);
268: x_target_level_rec.Workflow_Process_Name :=
269: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Process_Name);
270: x_target_level_rec.Workflow_Item_Type :=
271: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Item_Type);
272: x_target_level_rec.Default_Notify_Resp_ID :=
273: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Default_Notify_Resp_ID);

Line 271: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Item_Type);

267: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Process_Short_Name);
268: x_target_level_rec.Workflow_Process_Name :=
269: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Process_Name);
270: x_target_level_rec.Workflow_Item_Type :=
271: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Item_Type);
272: x_target_level_rec.Default_Notify_Resp_ID :=
273: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Default_Notify_Resp_ID);
274: x_target_level_rec.Default_Notify_Resp_short_name:=
275: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Default_Notify_Resp_short_name);

Line 273: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Default_Notify_Resp_ID);

269: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Process_Name);
270: x_target_level_rec.Workflow_Item_Type :=
271: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Item_Type);
272: x_target_level_rec.Default_Notify_Resp_ID :=
273: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Default_Notify_Resp_ID);
274: x_target_level_rec.Default_Notify_Resp_short_name:=
275: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Default_Notify_Resp_short_name);
276: x_target_level_rec.Default_Notify_Resp_Name :=
277: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Default_Notify_Resp_Name);

Line 275: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Default_Notify_Resp_short_name);

271: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Workflow_Item_Type);
272: x_target_level_rec.Default_Notify_Resp_ID :=
273: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Default_Notify_Resp_ID);
274: x_target_level_rec.Default_Notify_Resp_short_name:=
275: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Default_Notify_Resp_short_name);
276: x_target_level_rec.Default_Notify_Resp_Name :=
277: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Default_Notify_Resp_Name);
278: x_target_level_rec.Computing_Function_ID :=
279: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Computing_Function_ID);

Line 277: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Default_Notify_Resp_Name);

273: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Default_Notify_Resp_ID);
274: x_target_level_rec.Default_Notify_Resp_short_name:=
275: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Default_Notify_Resp_short_name);
276: x_target_level_rec.Default_Notify_Resp_Name :=
277: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Default_Notify_Resp_Name);
278: x_target_level_rec.Computing_Function_ID :=
279: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Computing_Function_ID);
280: x_target_level_rec.Computing_Function_Name :=
281: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Computing_Function_Name);

Line 279: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Computing_Function_ID);

275: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Default_Notify_Resp_short_name);
276: x_target_level_rec.Default_Notify_Resp_Name :=
277: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Default_Notify_Resp_Name);
278: x_target_level_rec.Computing_Function_ID :=
279: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Computing_Function_ID);
280: x_target_level_rec.Computing_Function_Name :=
281: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Computing_Function_Name);
282: x_target_level_rec.Computing_User_Function_Name :=
283: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Computing_User_Function_Name);

Line 281: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Computing_Function_Name);

277: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Default_Notify_Resp_Name);
278: x_target_level_rec.Computing_Function_ID :=
279: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Computing_Function_ID);
280: x_target_level_rec.Computing_Function_Name :=
281: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Computing_Function_Name);
282: x_target_level_rec.Computing_User_Function_Name :=
283: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Computing_User_Function_Name);
284: x_target_level_rec.Report_Function_ID :=
285: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Report_Function_ID);

Line 283: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Computing_User_Function_Name);

279: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Computing_Function_ID);
280: x_target_level_rec.Computing_Function_Name :=
281: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Computing_Function_Name);
282: x_target_level_rec.Computing_User_Function_Name :=
283: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Computing_User_Function_Name);
284: x_target_level_rec.Report_Function_ID :=
285: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Report_Function_ID);
286: x_target_level_rec.Report_Function_Name :=
287: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Report_Function_Name);

Line 285: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Report_Function_ID);

281: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Computing_Function_Name);
282: x_target_level_rec.Computing_User_Function_Name :=
283: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Computing_User_Function_Name);
284: x_target_level_rec.Report_Function_ID :=
285: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Report_Function_ID);
286: x_target_level_rec.Report_Function_Name :=
287: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Report_Function_Name);
288: x_target_level_rec.Report_User_Function_Name :=
289: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Report_User_Function_Name);

Line 287: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Report_Function_Name);

283: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Computing_User_Function_Name);
284: x_target_level_rec.Report_Function_ID :=
285: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Report_Function_ID);
286: x_target_level_rec.Report_Function_Name :=
287: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Report_Function_Name);
288: x_target_level_rec.Report_User_Function_Name :=
289: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Report_User_Function_Name);
290: x_target_level_rec.Unit_Of_Measure :=
291: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Unit_Of_Measure);

Line 289: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Report_User_Function_Name);

285: BIS_UTILITIES_PVT.CheckMissNum(p_target_level_rec.Report_Function_ID);
286: x_target_level_rec.Report_Function_Name :=
287: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Report_Function_Name);
288: x_target_level_rec.Report_User_Function_Name :=
289: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Report_User_Function_Name);
290: x_target_level_rec.Unit_Of_Measure :=
291: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Unit_Of_Measure);
292: x_target_level_rec.System_Flag :=
293: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.System_Flag);

Line 291: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Unit_Of_Measure);

287: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Report_Function_Name);
288: x_target_level_rec.Report_User_Function_Name :=
289: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Report_User_Function_Name);
290: x_target_level_rec.Unit_Of_Measure :=
291: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Unit_Of_Measure);
292: x_target_level_rec.System_Flag :=
293: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.System_Flag);
294: x_target_level_rec.SOURCE :=
295: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.SOURCE);

Line 293: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.System_Flag);

289: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Report_User_Function_Name);
290: x_target_level_rec.Unit_Of_Measure :=
291: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Unit_Of_Measure);
292: x_target_level_rec.System_Flag :=
293: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.System_Flag);
294: x_target_level_rec.SOURCE :=
295: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.SOURCE);
296: END;
297:

Line 295: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.SOURCE);

291: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.Unit_Of_Measure);
292: x_target_level_rec.System_Flag :=
293: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.System_Flag);
294: x_target_level_rec.SOURCE :=
295: BIS_UTILITIES_PVT.CheckMissChar(p_target_level_rec.SOURCE);
296: END;
297:
298: FUNCTION Get_Level_Id_From_Short_Name
299: ( p_tl_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type

Line 669: BIS_UTILITIES_PVT.Add_Error_Message

665: when others then
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
667: --Added last two parameters
668: l_error_tbl := x_error_tbl;
669: BIS_UTILITIES_PVT.Add_Error_Message
670: ( p_error_msg_id => SQLCODE
671: , p_error_description => SQLERRM
672: , p_error_proc_name => G_PKG_NAME||'.Create_Target_Level'
673: , p_error_table => l_error_tbl

Line 739: BIS_UTILITIES_PVT.Add_Error_Message

735: l_target_level_Id := Get_Level_Id_From_Short_Name(p_target_level_rec);
736: if (l_target_level_id is NOT NULL) then
737: --added last two params
738: l_error_tbl := x_error_tbl;
739: BIS_UTILITIES_PVT.Add_Error_Message
740: ( p_error_msg_name => 'BIS_TRG_LVL_SHORT_NAME_UNIQUE'
741: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
742: , p_error_proc_name => G_PKG_NAME||'.Create_Target_Level'
743: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 755: BIS_UTILITIES_PVT.Add_Error_Message

751:
752: if (l_target_level_id is NOT NULL) then
753: --added last two params
754: l_error_tbl := x_error_tbl;
755: BIS_UTILITIES_PVT.Add_Error_Message
756: ( p_error_msg_name => 'BIS_TRG_LVL_DIMLEVELS_UNIQUE'
757: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
758: , p_error_proc_name => G_PKG_NAME||'.Create_Target_Level'
759: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 887: BIS_UTILITIES_PVT.Add_Error_Message

883: --added this
884: WHEN DUPLICATE_DIMENSION_VALUE THEN
885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
886: l_error_tbl := x_error_tbl;
887: BIS_UTILITIES_PVT.Add_Error_Message
888: ( p_error_msg_name => 'BIS_TAR_LEVEL_UNIQUENESS_ERROR'
889: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
890: , p_error_proc_name => G_PKG_NAME||'.Create_Target_Level'
891: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 910: BIS_UTILITIES_PVT.Add_Error_Message

906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991
908:
909: l_error_tbl := x_error_tbl;
910: BIS_UTILITIES_PVT.Add_Error_Message
911: ( p_error_msg_id => SQLCODE
912: , p_error_description => SQLERRM
913: , p_error_proc_name => G_PKG_NAME||'.Create_Target_Level'
914: , p_error_table => l_error_tbl

Line 948: BIS_UTILITIES_PVT.Add_Error_Message

944: when others then
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
946: --added last two params
947: l_error_tbl := x_error_tbl;
948: BIS_UTILITIES_PVT.Add_Error_Message
949: ( p_error_msg_id => SQLCODE
950: , p_error_description => SQLERRM
951: , p_error_proc_name => G_PKG_NAME||'.Count_Target_Levels'
952: , p_error_table => l_error_tbl

Line 1173: BIS_UTILITIES_PVT.Add_Error_Message

1169:
1170: --added this check and message
1171: if ( i= 0) then
1172: l_error_tbl := x_error_tbl;
1173: BIS_UTILITIES_PVT.Add_Error_Message
1174: ( p_error_msg_name => 'BIS_INVALID_MEASURE_ID'
1175: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1176: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target_Levels'
1177: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1201: BIS_UTILITIES_PVT.Add_Error_Message

1197: IF tar_level_bv%ISOPEN THEN CLOSE tar_level_bv; END IF;
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1199: --added last two params
1200: l_error_tbl := x_error_tbl;
1201: BIS_UTILITIES_PVT.Add_Error_Message
1202: ( p_error_msg_id => SQLCODE
1203: , p_error_description => SQLERRM
1204: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target_Levels'
1205: , p_error_table => l_error_tbl

Line 1423: BIS_UTILITIES_PVT.Add_Error_Message

1419: WHEN NO_DATA_FOUND THEN
1420: --added this error message
1421:
1422: l_error_tbl := x_error_tbl;
1423: BIS_UTILITIES_PVT.Add_Error_Message
1424: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
1425: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1426: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target_Level'
1427: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1442: BIS_UTILITIES_PVT.Add_Error_Message

1438: when others then
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1440: --added last two params
1441: l_error_tbl := x_error_tbl;
1442: BIS_UTILITIES_PVT.Add_Error_Message
1443: ( p_error_msg_id => SQLCODE
1444: , p_error_description => SQLERRM
1445: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target_Level'
1446: , p_error_table => l_error_tbl

Line 1542: BIS_UTILITIES_PVT.Add_Error_Message(

1538:
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1540:
1541: l_error_tbl := x_error_tbl;
1542: BIS_UTILITIES_PVT.Add_Error_Message(
1543: p_error_msg_id => SQLCODE
1544: , p_error_description => SQLERRM
1545: , p_error_proc_name => G_PKG_NAME||'.retrieve_multiple_target_levels'
1546: , p_error_table => l_error_tbl

Line 1932: BIS_UTILITIES_PVT.Add_Error_Message

1928: when others then
1929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1930: --added last two params
1931: l_error_tbl := x_error_tbl;
1932: BIS_UTILITIES_PVT.Add_Error_Message
1933: ( p_error_msg_id => SQLCODE
1934: , p_error_description => SQLERRM
1935: , p_error_proc_name => G_PKG_NAME||'.Update_Target_Level'
1936: , p_error_table => l_error_tbl

Line 1994: BIS_UTILITIES_PVT.Add_Error_Message

1990:
1991: --added this check
1992: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1993: l_error_tbl := x_error_tbl;
1994: BIS_UTILITIES_PVT.Add_Error_Message
1995: ( p_error_msg_name => 'BIS_INVALID_TAR_LEVEL_ID'
1996: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1997: , p_error_proc_name => G_PKG_NAME||'.Update_Target_Level'
1998: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2022: BIS_UTILITIES_PVT.Add_Error_Message

2018:
2019: -- ADD error message
2020: --added last two params
2021: l_error_tbl := x_error_tbl;
2022: BIS_UTILITIES_PVT.Add_Error_Message
2023: ( p_error_msg_name => 'BIS_NO_CHANGE_SEED_TARGET_LVL'
2024: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2025: , p_error_proc_name => G_PKG_NAME||'.Update_Target_Level'
2026: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2041: BIS_UTILITIES_PVT.Add_Error_Message

2037: if (l_target_level_id <> p_target_level_Rec.Target_Level_Id) then
2038:
2039: --added last two params
2040: l_error_tbl := x_error_tbl;
2041: BIS_UTILITIES_PVT.Add_Error_Message
2042: ( p_error_msg_name => 'BIS_TRG_LVL_SHORT_NAME_UNIQUE'
2043: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2044: , p_error_proc_name => G_PKG_NAME||'.Update_Target_Level'
2045: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2067: BIS_UTILITIES_PVT.Add_Error_Message

2063: if (l_target_level_id is NOT NULL) then
2064: if (l_target_level_id <> p_target_level_Rec.Target_Level_Id) then
2065: --added last two params
2066: l_error_tbl := x_error_tbl;
2067: BIS_UTILITIES_PVT.Add_Error_Message
2068: ( p_error_msg_name => 'BIS_TRG_LVL_DIMLEVELS_UNIQUE'
2069: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2070: , p_error_proc_name => G_PKG_NAME||'.Update_Target_Level'
2071: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2149: BIS_UTILITIES_PVT.Add_Error_Message

2145: --added this
2146: WHEN DUPLICATE_DIMENSION_VALUE THEN
2147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2148: l_error_tbl := x_error_tbl;
2149: BIS_UTILITIES_PVT.Add_Error_Message
2150: ( p_error_msg_name => 'BIS_TAR_LEVEL_UNIQUENESS_ERROR'
2151: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2152: , p_error_proc_name => G_PKG_NAME||'.Update_Target_Level'
2153: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2167: BIS_UTILITIES_PVT.Add_Error_Message

2163: when others then
2164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2165: --added last two params
2166: l_error_tbl := x_error_tbl;
2167: BIS_UTILITIES_PVT.Add_Error_Message
2168: ( p_error_msg_id => SQLCODE
2169: , p_error_description => SQLERRM
2170: , p_error_proc_name => G_PKG_NAME||'.Update_Target_Level'
2171: , p_error_table => l_error_tbl

Line 2207: BIS_UTILITIES_PVT.Add_Error_Message

2203: when others then
2204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2205: --added last two params
2206: l_error_tbl := x_error_tbl;
2207: BIS_UTILITIES_PVT.Add_Error_Message
2208: ( p_error_msg_id => SQLCODE
2209: , p_error_description => SQLERRM
2210: , p_error_proc_name => G_PKG_NAME||'.Translate_Target_Level'
2211: , p_error_table => l_error_tbl

Line 2268: BIS_UTILITIES_PVT.Add_Error_Message

2264: if (l_target_level_Orig.target_level_id <>
2265: l_Target_Level_Rec.Target_Level_Id) then
2266: --added last two params
2267: l_error_tbl := x_error_tbl;
2268: BIS_UTILITIES_PVT.Add_Error_Message
2269: ( p_error_msg_name => 'BIS_TARGET_LEVEL_SHORT_NAME_UNIQUE'
2270: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2271: , p_error_proc_name => G_PKG_NAME||'.Translate_Target_Level'
2272: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2330: BIS_UTILITIES_PVT.Add_Error_Message

2326: when others then
2327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2328: --added last two params
2329: l_error_tbl := x_error_tbl;
2330: BIS_UTILITIES_PVT.Add_Error_Message
2331: ( p_error_msg_id => SQLCODE
2332: , p_error_description => SQLERRM
2333: , p_error_proc_name => G_PKG_NAME||'.Translate_Target_Level'
2334: , p_error_table => l_error_tbl

Line 2373: BIS_UTILITIES_PVT.Add_Error_Message

2369: */
2370: if (l_Target_Tbl.COUNT > 0 AND p_force_delete = 0) then
2371: --added last two params
2372: l_error_tbl := x_error_tbl;
2373: BIS_UTILITIES_PVT.Add_Error_Message
2374: ( p_error_msg_name => 'BIS_NO_DELETE_TARGET_LEVEL'
2375: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2376: , p_error_proc_name => G_PKG_NAME||'.Delete_Target_Level'
2377: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2418: BIS_UTILITIES_PVT.Add_Error_Message

2414: when others then
2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2416: --added last two params
2417: l_error_tbl := x_error_tbl;
2418: BIS_UTILITIES_PVT.Add_Error_Message
2419: ( p_error_msg_id => SQLCODE
2420: , p_error_description => SQLERRM
2421: , p_error_proc_name => G_PKG_NAME||'.Delete_Target_Level'
2422: , p_error_table => l_error_tbl

Line 2459: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

2455: --when FND_API.G_EXC_ERROR then
2456: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2457: l_error := FND_API.G_TRUE;
2458: l_error_Tbl_p := x_error_Tbl;
2459: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2460: , l_error_Tbl
2461: , x_error_tbl
2462: );
2463: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2480: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

2476: --when FND_API.G_EXC_ERROR then
2477: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2478: l_error := FND_API.G_TRUE;
2479: l_error_Tbl_p := x_error_Tbl;
2480: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2481: , l_error_Tbl
2482: , x_error_tbl
2483: );
2484: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2501: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

2497: --when FND_API.G_EXC_ERROR then
2498: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2499: l_error := FND_API.G_TRUE;
2500: l_error_Tbl_p := x_error_Tbl;
2501: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2502: , l_error_Tbl
2503: , x_error_tbl
2504: );
2505: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2522: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

2518: --when FND_API.G_EXC_ERROR then
2519: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2520: l_error := FND_API.G_TRUE;
2521: l_error_Tbl_p := x_error_Tbl;
2522: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2523: , l_error_Tbl
2524: , x_error_tbl
2525: );
2526: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2543: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

2539: --when FND_API.G_EXC_ERROR then
2540: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2541: l_error := FND_API.G_TRUE;
2542: l_error_Tbl_p := x_error_Tbl;
2543: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2544: , l_error_Tbl
2545: , x_error_tbl
2546: );
2547: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2564: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

2560: --when FND_API.G_EXC_ERROR then
2561: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2562: l_error := FND_API.G_TRUE;
2563: l_error_Tbl_p := x_error_Tbl;
2564: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2565: , l_error_Tbl
2566: , x_error_tbl
2567: );
2568: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2585: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

2581: --when FND_API.G_EXC_ERROR then
2582: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2583: l_error := FND_API.G_TRUE;
2584: l_error_Tbl_p := x_error_Tbl;
2585: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2586: , l_error_Tbl
2587: , x_error_tbl
2588: );
2589: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2606: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

2602: -- when FND_API.G_EXC_ERROR then
2603: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2604: l_error := FND_API.G_TRUE;
2605: l_error_Tbl_p := x_error_Tbl;
2606: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2607: , l_error_Tbl
2608: , x_error_tbl
2609: );
2610: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2627: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

2623: -- when FND_API.G_EXC_ERROR then
2624: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2625: l_error := FND_API.G_TRUE;
2626: l_error_Tbl_p := x_error_Tbl;
2627: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2628: , l_error_Tbl
2629: , x_error_tbl
2630: );
2631: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2654: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

2650: -- when FND_API.G_EXC_ERROR then
2651: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2652: l_error := FND_API.G_TRUE;
2653: l_error_Tbl_p := x_error_Tbl;
2654: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2655: , l_error_Tbl
2656: , x_error_tbl
2657: );
2658: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2676: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

2672: -- when FND_API.G_EXC_ERROR then
2673: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2674: l_error := FND_API.G_TRUE;
2675: l_error_Tbl_p := x_error_Tbl;
2676: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2677: , l_error_Tbl
2678: , x_error_tbl
2679: );
2680: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2703: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

2699: -- when FND_API.G_EXC_ERROR then
2700: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2701: l_error := FND_API.G_TRUE;
2702: l_error_Tbl_p := x_error_Tbl;
2703: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
2704: , l_error_Tbl
2705: , x_error_tbl
2706: );
2707: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2729: BIS_UTILITIES_PVT.Add_Error_Message

2725: when others then
2726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2727: --added last two params
2728: l_error_tbl := x_error_tbl;
2729: BIS_UTILITIES_PVT.Add_Error_Message
2730: ( p_error_msg_id => SQLCODE
2731: , p_error_description => SQLERRM
2732: , p_error_proc_name => G_PKG_NAME||'.Validate_Target_Level'
2733: , p_error_table => l_error_tbl

Line 2755: l_convert := BIS_UTILITIES_PVT.Convert_to_ID( p_dim_level_id

2751: BEGIN
2752:
2753: x_return_status := FND_API.G_RET_STS_SUCCESS;
2754:
2755: l_convert := BIS_UTILITIES_PVT.Convert_to_ID( p_dim_level_id
2756: , p_Dim_level_short_name
2757: , p_Dime_Level_NAME
2758: );
2759:

Line 2796: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

2792: BEGIN
2793: x_return_status := FND_API.G_RET_STS_SUCCESS;
2794: x_Target_Level_Rec := p_Target_Level_Rec;
2795:
2796: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
2797: ( x_Target_Level_Rec.Target_Level_id
2798: , x_Target_Level_Rec.Target_Level_Short_Name
2799: , x_Target_Level_Rec.Target_Level_Name
2800: );

Line 2818: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

2814: NULL;
2815: END;
2816: end if;
2817:
2818: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
2819: ( x_Target_Level_Rec.Measure_id
2820: , x_Target_Level_Rec.Measure_Short_Name
2821: , x_Target_Level_Rec.Measure_Name
2822: );

Line 2929: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

2925: , x_return_status => x_return_status
2926: , x_error_Tbl => x_error_Tbl
2927: );
2928:
2929: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
2930: ( x_Target_Level_Rec.Default_Notify_Resp_id
2931: , x_Target_Level_Rec.Default_Notify_Resp_Short_Name
2932: , x_Target_Level_Rec.Default_Notify_Resp_Name
2933: );

Line 2951: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

2947: NULL;
2948: END;
2949: end if;
2950:
2951: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
2952: ( x_Target_Level_Rec.Computing_Function_id
2953: , x_Target_Level_Rec.Computing_Function_Name
2954: , x_Target_Level_Rec.Computing_user_Function_Name
2955: );

Line 2996: BIS_UTILITIES_PVT.Add_Error_Message

2992: when others then
2993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2994: --added last two params
2995: l_error_tbl := x_error_tbl;
2996: BIS_UTILITIES_PVT.Add_Error_Message
2997: ( p_error_msg_id => SQLCODE
2998: , p_error_description => SQLERRM
2999: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
3000: , p_error_table => l_error_tbl

Line 3035: BIS_UTILITIES_PVT.Add_Error_Message

3031: else
3032: -- POLPULATE ERROR TABLE
3033: --added last two params
3034: l_error_tbl := x_error_tbl;
3035: BIS_UTILITIES_PVT.Add_Error_Message
3036: ( p_error_msg_name => 'BIS_NAME_SHORT_NAME_MISSING'
3037: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3038: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
3039: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 3062: BIS_UTILITIES_PVT.Add_Error_Message

3058: when others then
3059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3060: --added last two params
3061: l_error_tbl := x_error_tbl;
3062: BIS_UTILITIES_PVT.Add_Error_Message
3063: ( p_error_msg_id => SQLCODE
3064: , p_error_description => SQLERRM
3065: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
3066: , p_error_table => l_error_tbl

Line 3125: BIS_UTILITIES_PVT.Add_Error_Message

3121:
3122: --added this check
3123: if(l_flag = 0) then
3124: l_error_tbl := x_error_tbl;
3125: BIS_UTILITIES_PVT.Add_Error_Message
3126: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
3127: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3128: , p_error_proc_name => G_PKG_NAME||'.Retrieve_User_Target_Levels'
3129: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 3151: BIS_UTILITIES_PVT.Add_Error_Message

3147: if ind_res%isopen then close ind_res; end if;
3148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3149: --added last two params
3150: l_error_tbl := x_error_tbl;
3151: BIS_UTILITIES_PVT.Add_Error_Message
3152: ( p_error_msg_id => SQLCODE
3153: , p_error_description => SQLERRM
3154: , p_error_proc_name => G_PKG_NAME||'.Retrieve_User_Target_Levels'
3155: , p_error_table => l_error_tbl

Line 3193: BIS_UTILITIES_PVT.Add_Error_Message

3189: EXCEPTION
3190: WHEN NO_DATA_FOUND THEN
3191: --added this message
3192: l_error_tbl := x_error_tbl;
3193: BIS_UTILITIES_PVT.Add_Error_Message
3194: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
3195: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3196: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Last_Update_Date'
3197: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 3213: BIS_UTILITIES_PVT.Add_Error_Message

3209: WHEN OTHERS THEN
3210: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3211: --added last two params
3212: l_error_tbl := x_error_tbl;
3213: BIS_UTILITIES_PVT.Add_Error_Message
3214: ( p_error_msg_id => SQLCODE
3215: , p_error_description => SQLERRM
3216: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Last_Update_Date'
3217: , p_error_table => l_error_tbl

Line 3251: l_form_date := TO_DATE(p_timestamp, BIS_UTILITIES_PVT.G_DATE_FORMAT);

3247: , x_return_status => x_return_status
3248: , x_error_Tbl => x_error_Tbl
3249: );
3250: IF(p_timestamp IS NOT NULL) THEN
3251: l_form_date := TO_DATE(p_timestamp, BIS_UTILITIES_PVT.G_DATE_FORMAT);
3252:
3253: IF(l_form_date = l_last_update_date) THEN
3254: x_return_status := FND_API.G_TRUE;
3255: ELSE

Line 3274: BIS_UTILITIES_PVT.Add_Error_Message

3270: WHEN OTHERS THEN
3271: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3272: --added last two params
3273: l_error_tbl := x_error_tbl;
3274: BIS_UTILITIES_PVT.Add_Error_Message
3275: ( p_error_msg_id => SQLCODE
3276: , p_error_description => SQLERRM
3277: , p_error_proc_name => G_PKG_NAME||'.BIS_Target_Level_PVT'
3278: , p_error_table => l_error_tbl

Line 3330: IF (BIS_UTILITIES_PVT.Value_Not_Missing(p_Target_Level_Rec.target_level_id)

3326: where target_level_short_name = p_target_level_short_name;
3327:
3328: BEGIN
3329:
3330: IF (BIS_UTILITIES_PVT.Value_Not_Missing(p_Target_Level_Rec.target_level_id)
3331: = FND_API.G_TRUE)
3332: AND (BIS_UTILITIES_PVT.Value_Not_Null(p_Target_Level_Rec.target_level_id)
3333: = FND_API.G_TRUE)
3334: THEN

Line 3332: AND (BIS_UTILITIES_PVT.Value_Not_Null(p_Target_Level_Rec.target_level_id)

3328: BEGIN
3329:
3330: IF (BIS_UTILITIES_PVT.Value_Not_Missing(p_Target_Level_Rec.target_level_id)
3331: = FND_API.G_TRUE)
3332: AND (BIS_UTILITIES_PVT.Value_Not_Null(p_Target_Level_Rec.target_level_id)
3333: = FND_API.G_TRUE)
3334: THEN
3335: OPEN cr_tl_id_dim_level(p_Target_Level_Rec.target_level_id);
3336: FETCH cr_tl_id_dim_level INTO

Line 3349: BIS_UTILITIES_PVT.Add_Error_Message

3345: --added this
3346: if cr_tl_id_dim_level%NOTFOUND then
3347: --added this message
3348: l_error_tbl := x_error_tbl;
3349: BIS_UTILITIES_PVT.Add_Error_Message
3350: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
3351: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3352: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Time_Level_Value'
3353: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 3368: BIS_UTILITIES_PVT.Get_Time_Dimension_Name_TL(p_Target_Level_Rec.target_level_id,NULL);

3364: into l_time_dimension_id
3365: from bisbv_dimensions
3366: --'TIME'
3367: where upper(dimension_short_name) =
3368: BIS_UTILITIES_PVT.Get_Time_Dimension_Name_TL(p_Target_Level_Rec.target_level_id,NULL);
3369: --------
3370: ELSE
3371: OPEN cr_tl_sn_dim_level(p_Target_Level_Rec.target_level_short_name);
3372: FETCH cr_tl_sn_dim_level INTO

Line 3385: BIS_UTILITIES_PVT.Add_Error_Message

3381: --added this
3382: if cr_tl_sn_dim_level%NOTFOUND then
3383: --added this message
3384: l_error_tbl := x_error_tbl;
3385: BIS_UTILITIES_PVT.Add_Error_Message
3386: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
3387: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3388: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Time_Level_Value'
3389: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 3404: BIS_UTILITIES_PVT.Get_Time_Dimension_Name_TL(NULL,p_Target_Level_Rec.target_level_short_name);

3400: into l_time_dimension_id
3401: from bisbv_dimensions
3402: --'TIME'
3403: where upper(dimension_short_name) =
3404: BIS_UTILITIES_PVT.Get_Time_Dimension_Name_TL(NULL,p_Target_Level_Rec.target_level_short_name);
3405: --------
3406: END IF;
3407: --moved this in the if condition for tl id and shortname
3408: /*

Line 3414: BIS_UTILITIES_PVT.Get_Time_Dimension_Name;

3410: into l_time_dimension_id
3411: from bisbv_dimensions
3412: --'TIME'
3413: where upper(dimension_short_name) =
3414: BIS_UTILITIES_PVT.Get_Time_Dimension_Name;
3415: */
3416: FOR i IN 1..l_dimension_level_tbl.COUNT LOOP
3417: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level
3418: ( p_api_version

Line 3454: BIS_UTILITIES_PVT.Add_Error_Message

3450: IF cr_tl_sn_dim_level%ISOPEN THEN CLOSE cr_tl_sn_dim_level; END IF;
3451: IF cr_tl_id_dim_level%ISOPEN THEN CLOSE cr_tl_id_dim_level; END IF;
3452: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3453: l_error_Tbl := x_error_Tbl;
3454: BIS_UTILITIES_PVT.Add_Error_Message
3455: ( p_error_table => l_error_Tbl
3456: , p_error_msg_id => SQLCODE
3457: , p_error_description => SQLERRM
3458: , x_error_table => x_error_Tbl

Line 3556: IF (BIS_UTILITIES_PVT.Value_Not_Missing(p_Target_Level_Rec.target_level_id)

3552: -- BIS_UTILITIES_PUB.put_line(p_text =>' test inside bisvtalb tgt lvl id = ' || p_Target_Level_Rec.target_level_id );
3553:
3554: l_err_track := 100;
3555:
3556: IF (BIS_UTILITIES_PVT.Value_Not_Missing(p_Target_Level_Rec.target_level_id)
3557: = FND_API.G_TRUE)
3558: AND (BIS_UTILITIES_PVT.Value_Not_Null(p_Target_Level_Rec.target_level_id)
3559: = FND_API.G_TRUE)
3560: THEN

Line 3558: AND (BIS_UTILITIES_PVT.Value_Not_Null(p_Target_Level_Rec.target_level_id)

3554: l_err_track := 100;
3555:
3556: IF (BIS_UTILITIES_PVT.Value_Not_Missing(p_Target_Level_Rec.target_level_id)
3557: = FND_API.G_TRUE)
3558: AND (BIS_UTILITIES_PVT.Value_Not_Null(p_Target_Level_Rec.target_level_id)
3559: = FND_API.G_TRUE)
3560: THEN
3561:
3562: l_err_track := 200;

Line 3578: BIS_UTILITIES_PVT.Add_Error_Message

3574: --added this
3575: if cr_ol_id_dim_level%NOTFOUND then
3576: --added this message
3577: l_error_tbl := x_error_tbl;
3578: BIS_UTILITIES_PVT.Add_Error_Message
3579: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
3580: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3581: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Org_Level'
3582: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 3599: l_dimension_short_name := BIS_UTILITIES_PVT.Get_Org_Dimension_Name_TL(p_Target_Level_Rec.target_level_id,NULL);

3595: --------
3596:
3597: l_err_track := 400;
3598:
3599: l_dimension_short_name := BIS_UTILITIES_PVT.Get_Org_Dimension_Name_TL(p_Target_Level_Rec.target_level_id,NULL);
3600:
3601: -- BIS_UTILITIES_PUB.put_line(p_text => ' dim short name = ' || l_dimension_short_name ) ;
3602:
3603: l_err_track := 500;

Line 3633: BIS_UTILITIES_PVT.Add_Error_Message

3629:
3630: if cr_ol_sn_dim_level%NOTFOUND then
3631:
3632: l_error_tbl := x_error_tbl;
3633: BIS_UTILITIES_PVT.Add_Error_Message
3634: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
3635: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3636: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Org_Level'
3637: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 3651: l_dimension_short_name := BIS_UTILITIES_PVT.Get_Org_Dimension_Name_TL(NULL, p_Target_Level_Rec.target_level_short_name);

3647: CLOSE cr_ol_sn_dim_level;
3648:
3649: --------
3650:
3651: l_dimension_short_name := BIS_UTILITIES_PVT.Get_Org_Dimension_Name_TL(NULL, p_Target_Level_Rec.target_level_short_name);
3652:
3653: Select dimension_id
3654: into l_org_dimension_id
3655: from bisbv_dimensions --''ORG''

Line 3706: BIS_UTILITIES_PVT.Add_Error_Message

3702: IF cr_ol_sn_dim_level%ISOPEN THEN CLOSE cr_ol_sn_dim_level; END IF;
3703: IF cr_ol_id_dim_level%ISOPEN THEN CLOSE cr_ol_id_dim_level; END IF;
3704: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3705: l_error_Tbl := x_error_Tbl;
3706: BIS_UTILITIES_PVT.Add_Error_Message
3707: ( p_error_table => l_error_Tbl
3708: , p_error_msg_id => SQLCODE
3709: , p_error_description => SQLERRM
3710: , x_error_table => x_error_Tbl

Line 3853: l_dim1_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);

3849: ,x_Dimension_Level_Rec => l_dim_level_rec
3850: ,x_return_status => x_return_status
3851: ,x_error_Tbl => x_error_tbl
3852: );
3853: l_dim1_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3854: END IF;
3855:
3856: IF (x_target_level_rec.dimension2_level_id IS NOT NULL
3857: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension2_level_id)= FND_API.G_TRUE) THEN

Line 3867: l_dim2_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);

3863: ,x_Dimension_Level_Rec => l_dim_level_rec
3864: ,x_return_status => x_return_status
3865: ,x_error_Tbl => x_error_tbl
3866: );
3867: l_dim2_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3868: END IF;
3869:
3870: IF (x_target_level_rec.dimension3_level_id IS NOT NULL
3871: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension3_level_id)= FND_API.G_TRUE) THEN

Line 3881: l_dim3_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);

3877: ,x_Dimension_Level_Rec => l_dim_level_rec
3878: ,x_return_status => x_return_status
3879: ,x_error_Tbl => x_error_tbl
3880: );
3881: l_dim3_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3882: END IF;
3883:
3884: IF (x_target_level_rec.dimension4_level_id IS NOT NULL
3885: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension4_level_id)= FND_API.G_TRUE) THEN

Line 3895: l_dim4_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);

3891: ,x_Dimension_Level_Rec => l_dim_level_rec
3892: ,x_return_status => x_return_status
3893: ,x_error_Tbl => x_error_tbl
3894: );
3895: l_dim4_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3896: END IF;
3897:
3898: IF (x_target_level_rec.dimension5_level_id IS NOT NULL
3899: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension5_level_id)= FND_API.G_TRUE) THEN

Line 3909: l_dim5_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);

3905: ,x_Dimension_Level_Rec => l_dim_level_rec
3906: ,x_return_status => x_return_status
3907: ,x_error_Tbl => x_error_tbl
3908: );
3909: l_dim5_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3910: END IF;
3911:
3912: IF (x_target_level_rec.dimension6_level_id IS NOT NULL
3913: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension6_level_id)= FND_API.G_TRUE) THEN

Line 3923: l_dim6_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);

3919: ,x_Dimension_Level_Rec => l_dim_level_rec
3920: ,x_return_status => x_return_status
3921: ,x_error_Tbl => x_error_tbl
3922: );
3923: l_dim6_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3924: END IF;
3925:
3926: IF (x_target_level_rec.dimension7_level_id IS NOT NULL
3927: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension7_level_id)= FND_API.G_TRUE) THEN

Line 3937: l_dim7_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);

3933: ,x_Dimension_Level_Rec => l_dim_level_rec
3934: ,x_return_status => x_return_status
3935: ,x_error_Tbl => x_error_tbl
3936: );
3937: l_dim7_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3938: END IF;
3939:
3940:
3941: IF (l_measure_rec.dimension1_id = l_dim1_id) THEN

Line 4224: BIS_UTILITIES_PVT.Add_Error_Message

4220: when others then
4221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4222: --Added last two parameters
4223: l_error_tbl := x_error_tbl;
4224: BIS_UTILITIES_PVT.Add_Error_Message
4225: ( p_error_msg_id => SQLCODE
4226: , p_error_description => SQLERRM
4227: , p_error_proc_name => G_PKG_NAME||'.Create_Target_Level'
4228: , p_error_table => l_error_tbl

Line 4873: (BIS_UTILITIES_PVT.Value_Not_Missing(p_string) = FND_API.G_TRUE)

4869: (p_string IN VARCHAR2)
4870: RETURN BOOLEAN IS
4871: BEGIN
4872: IF (
4873: (BIS_UTILITIES_PVT.Value_Not_Missing(p_string) = FND_API.G_TRUE)
4874: AND
4875: (BIS_UTILITIES_PVT.Value_Not_Null(p_string) = FND_API.G_TRUE)
4876: ) THEN
4877: RETURN TRUE;

Line 4875: (BIS_UTILITIES_PVT.Value_Not_Null(p_string) = FND_API.G_TRUE)

4871: BEGIN
4872: IF (
4873: (BIS_UTILITIES_PVT.Value_Not_Missing(p_string) = FND_API.G_TRUE)
4874: AND
4875: (BIS_UTILITIES_PVT.Value_Not_Null(p_string) = FND_API.G_TRUE)
4876: ) THEN
4877: RETURN TRUE;
4878: ELSE
4879: RETURN FALSE;

Line 4892: (BIS_UTILITIES_PVT.Value_Not_Missing(p_number) = FND_API.G_TRUE)

4888: (p_number IN NUMBER)
4889: RETURN BOOLEAN IS
4890: BEGIN
4891: IF (
4892: (BIS_UTILITIES_PVT.Value_Not_Missing(p_number) = FND_API.G_TRUE)
4893: AND
4894: (BIS_UTILITIES_PVT.Value_Not_Null(p_number) = FND_API.G_TRUE)
4895: ) THEN
4896: RETURN TRUE;

Line 4894: (BIS_UTILITIES_PVT.Value_Not_Null(p_number) = FND_API.G_TRUE)

4890: BEGIN
4891: IF (
4892: (BIS_UTILITIES_PVT.Value_Not_Missing(p_number) = FND_API.G_TRUE)
4893: AND
4894: (BIS_UTILITIES_PVT.Value_Not_Null(p_number) = FND_API.G_TRUE)
4895: ) THEN
4896: RETURN TRUE;
4897: ELSE
4898: RETURN FALSE;