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

Line 188: BIS_UTILITIES_PVT.Add_Error_Message

184: --
185: IF(l_count <> 0) THEN
186: --added more params
187: l_error_tbl := x_error_tbl;
188: BIS_UTILITIES_PVT.Add_Error_Message
189: ( p_error_msg_name => 'BIS_RECORD_EXISTS'
190: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
191: , p_error_proc_name => 'BIS_TARGET_PVT.Create_Target'
192: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 284: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

280: --commented RAISE
281: EXCEPTION
282: WHEN FND_API.G_EXC_ERROR THEN
283: x_return_status:= FND_API.G_RET_STS_ERROR;
284: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
285: htp.p('BIS_TARGET_PVT.Create_Target:G_EXC_ERROR'); htp.para;
286: END IF;
287: --RAISE;
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 290: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

286: END IF;
287: --RAISE;
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
289: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
290: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
291: htp.p('BIS_TARGET_PVT.Create_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
292: END IF;
293: --RAISE;
294: WHEN OTHERS THEN

Line 297: BIS_UTILITIES_PVT.Add_Error_Message

293: --RAISE;
294: WHEN OTHERS THEN
295: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
296: l_error_Tbl := x_error_Tbl;
297: BIS_UTILITIES_PVT.Add_Error_Message
298: ( p_error_table => l_error_Tbl
299: , p_error_msg_id => SQLCODE
300: , p_error_description => SQLERRM
301: , x_error_table => x_error_Tbl

Line 303: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

299: , p_error_msg_id => SQLCODE
300: , p_error_description => SQLERRM
301: , x_error_table => x_error_Tbl
302: );
303: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
304: htp.p('BIS_TARGET_PVT.Create_Target:OTHERS'); htp.para;
305: END IF;
306: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
307: --

Line 321: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Target_Level_ID);

317: IS
318: BEGIN
319: x_Target_Rec := p_Target_Rec;
320: x_Target_Rec.Target_Level_ID
321: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Target_Level_ID);
322:
323: -- dbms_output.put_line( ' Inside pvt : 21 ' );
324:
325: x_Target_Rec.Plan_ID

Line 326: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Plan_ID);

322:
323: -- dbms_output.put_line( ' Inside pvt : 21 ' );
324:
325: x_Target_Rec.Plan_ID
326: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Plan_ID);
327:
328: -- dbms_output.put_line( ' Inside pvt : 22 ' );
329:
330: x_Target_Rec.Org_Level_Value_ID

Line 331: := BIS_UTILITIES_PVT.CheckMissChar

327:
328: -- dbms_output.put_line( ' Inside pvt : 22 ' );
329:
330: x_Target_Rec.Org_Level_Value_ID
331: := BIS_UTILITIES_PVT.CheckMissChar
332: (p_char => x_Target_Rec.Org_Level_Value_ID);
333: x_Target_Rec.Time_Level_Value_ID
334: := BIS_UTILITIES_PVT.CheckMissChar
335: (p_char => x_Target_Rec.Time_Level_Value_ID);

Line 334: := BIS_UTILITIES_PVT.CheckMissChar

330: x_Target_Rec.Org_Level_Value_ID
331: := BIS_UTILITIES_PVT.CheckMissChar
332: (p_char => x_Target_Rec.Org_Level_Value_ID);
333: x_Target_Rec.Time_Level_Value_ID
334: := BIS_UTILITIES_PVT.CheckMissChar
335: (p_char => x_Target_Rec.Time_Level_Value_ID);
336: x_Target_Rec.Dim1_Level_Value_ID
337: := BIS_UTILITIES_PVT.CheckMissChar
338: (p_char => x_Target_Rec.Dim1_Level_Value_ID);

Line 337: := BIS_UTILITIES_PVT.CheckMissChar

333: x_Target_Rec.Time_Level_Value_ID
334: := BIS_UTILITIES_PVT.CheckMissChar
335: (p_char => x_Target_Rec.Time_Level_Value_ID);
336: x_Target_Rec.Dim1_Level_Value_ID
337: := BIS_UTILITIES_PVT.CheckMissChar
338: (p_char => x_Target_Rec.Dim1_Level_Value_ID);
339: x_Target_Rec.Dim2_Level_Value_ID
340: := BIS_UTILITIES_PVT.CheckMissChar
341: (p_char => x_Target_Rec.Dim2_Level_Value_ID);

Line 340: := BIS_UTILITIES_PVT.CheckMissChar

336: x_Target_Rec.Dim1_Level_Value_ID
337: := BIS_UTILITIES_PVT.CheckMissChar
338: (p_char => x_Target_Rec.Dim1_Level_Value_ID);
339: x_Target_Rec.Dim2_Level_Value_ID
340: := BIS_UTILITIES_PVT.CheckMissChar
341: (p_char => x_Target_Rec.Dim2_Level_Value_ID);
342: x_Target_Rec.Dim3_Level_Value_ID
343: := BIS_UTILITIES_PVT.CheckMissChar
344: (p_char => x_Target_Rec.Dim3_Level_Value_ID);

Line 343: := BIS_UTILITIES_PVT.CheckMissChar

339: x_Target_Rec.Dim2_Level_Value_ID
340: := BIS_UTILITIES_PVT.CheckMissChar
341: (p_char => x_Target_Rec.Dim2_Level_Value_ID);
342: x_Target_Rec.Dim3_Level_Value_ID
343: := BIS_UTILITIES_PVT.CheckMissChar
344: (p_char => x_Target_Rec.Dim3_Level_Value_ID);
345:
346: -- dbms_output.put_line( ' Inside pvt : 23' );
347:

Line 349: := BIS_UTILITIES_PVT.CheckMissChar

345:
346: -- dbms_output.put_line( ' Inside pvt : 23' );
347:
348: x_Target_Rec.Dim4_Level_Value_ID
349: := BIS_UTILITIES_PVT.CheckMissChar
350: (p_char => x_Target_Rec.Dim4_Level_Value_ID);
351: x_Target_Rec.Dim5_Level_Value_ID
352: := BIS_UTILITIES_PVT.CheckMissChar
353: (p_char => x_Target_Rec.Dim5_Level_Value_ID);

Line 352: := BIS_UTILITIES_PVT.CheckMissChar

348: x_Target_Rec.Dim4_Level_Value_ID
349: := BIS_UTILITIES_PVT.CheckMissChar
350: (p_char => x_Target_Rec.Dim4_Level_Value_ID);
351: x_Target_Rec.Dim5_Level_Value_ID
352: := BIS_UTILITIES_PVT.CheckMissChar
353: (p_char => x_Target_Rec.Dim5_Level_Value_ID);
354: x_Target_Rec.Dim6_Level_Value_ID
355: := BIS_UTILITIES_PVT.CheckMissChar
356: (p_char => x_Target_Rec.Dim6_Level_Value_ID);

Line 355: := BIS_UTILITIES_PVT.CheckMissChar

351: x_Target_Rec.Dim5_Level_Value_ID
352: := BIS_UTILITIES_PVT.CheckMissChar
353: (p_char => x_Target_Rec.Dim5_Level_Value_ID);
354: x_Target_Rec.Dim6_Level_Value_ID
355: := BIS_UTILITIES_PVT.CheckMissChar
356: (p_char => x_Target_Rec.Dim6_Level_Value_ID);
357: x_Target_Rec.Dim7_Level_Value_ID
358: := BIS_UTILITIES_PVT.CheckMissChar
359: (p_char => x_Target_Rec.Dim7_Level_Value_ID);

Line 358: := BIS_UTILITIES_PVT.CheckMissChar

354: x_Target_Rec.Dim6_Level_Value_ID
355: := BIS_UTILITIES_PVT.CheckMissChar
356: (p_char => x_Target_Rec.Dim6_Level_Value_ID);
357: x_Target_Rec.Dim7_Level_Value_ID
358: := BIS_UTILITIES_PVT.CheckMissChar
359: (p_char => x_Target_Rec.Dim7_Level_Value_ID);
360: x_Target_Rec.Target
361: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Target);
362: x_Target_Rec.Range1_low

Line 361: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Target);

357: x_Target_Rec.Dim7_Level_Value_ID
358: := BIS_UTILITIES_PVT.CheckMissChar
359: (p_char => x_Target_Rec.Dim7_Level_Value_ID);
360: x_Target_Rec.Target
361: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Target);
362: x_Target_Rec.Range1_low
363: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range1_low);
364: x_Target_Rec.Range1_high
365: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range1_high);

Line 363: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range1_low);

359: (p_char => x_Target_Rec.Dim7_Level_Value_ID);
360: x_Target_Rec.Target
361: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Target);
362: x_Target_Rec.Range1_low
363: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range1_low);
364: x_Target_Rec.Range1_high
365: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range1_high);
366:
367: -- dbms_output.put_line( ' Inside pvt : 24 ' );

Line 365: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range1_high);

361: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Target);
362: x_Target_Rec.Range1_low
363: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range1_low);
364: x_Target_Rec.Range1_high
365: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range1_high);
366:
367: -- dbms_output.put_line( ' Inside pvt : 24 ' );
368:
369: x_Target_Rec.Range2_low

Line 370: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range2_low);

366:
367: -- dbms_output.put_line( ' Inside pvt : 24 ' );
368:
369: x_Target_Rec.Range2_low
370: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range2_low);
371: x_Target_Rec.Range2_high
372: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range2_high);
373: x_Target_Rec.Range3_low
374: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range3_low);

Line 372: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range2_high);

368:
369: x_Target_Rec.Range2_low
370: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range2_low);
371: x_Target_Rec.Range2_high
372: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range2_high);
373: x_Target_Rec.Range3_low
374: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range3_low);
375: x_Target_Rec.Range3_high
376: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range3_high);

Line 374: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range3_low);

370: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range2_low);
371: x_Target_Rec.Range2_high
372: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range2_high);
373: x_Target_Rec.Range3_low
374: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range3_low);
375: x_Target_Rec.Range3_high
376: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range3_high);
377: x_Target_Rec.Notify_Resp1_ID
378: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Notify_Resp1_ID);

Line 376: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range3_high);

372: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range2_high);
373: x_Target_Rec.Range3_low
374: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range3_low);
375: x_Target_Rec.Range3_high
376: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range3_high);
377: x_Target_Rec.Notify_Resp1_ID
378: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Notify_Resp1_ID);
379: x_Target_Rec.Notify_Resp1_Short_Name
380: := BIS_UTILITIES_PVT.CheckMissChar

Line 378: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Notify_Resp1_ID);

374: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range3_low);
375: x_Target_Rec.Range3_high
376: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range3_high);
377: x_Target_Rec.Notify_Resp1_ID
378: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Notify_Resp1_ID);
379: x_Target_Rec.Notify_Resp1_Short_Name
380: := BIS_UTILITIES_PVT.CheckMissChar
381: (p_char => x_Target_Rec.Notify_Resp1_Short_Name);
382: x_Target_Rec.Notify_Resp2_ID

Line 380: := BIS_UTILITIES_PVT.CheckMissChar

376: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Range3_high);
377: x_Target_Rec.Notify_Resp1_ID
378: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Notify_Resp1_ID);
379: x_Target_Rec.Notify_Resp1_Short_Name
380: := BIS_UTILITIES_PVT.CheckMissChar
381: (p_char => x_Target_Rec.Notify_Resp1_Short_Name);
382: x_Target_Rec.Notify_Resp2_ID
383: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Notify_Resp2_ID);
384: x_Target_Rec.Notify_Resp2_Short_Name

Line 383: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Notify_Resp2_ID);

379: x_Target_Rec.Notify_Resp1_Short_Name
380: := BIS_UTILITIES_PVT.CheckMissChar
381: (p_char => x_Target_Rec.Notify_Resp1_Short_Name);
382: x_Target_Rec.Notify_Resp2_ID
383: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Notify_Resp2_ID);
384: x_Target_Rec.Notify_Resp2_Short_Name
385: := BIS_UTILITIES_PVT.CheckMissChar
386: (p_char => x_Target_Rec.Notify_Resp2_Short_Name);
387: x_Target_Rec.Notify_Resp3_ID

Line 385: := BIS_UTILITIES_PVT.CheckMissChar

381: (p_char => x_Target_Rec.Notify_Resp1_Short_Name);
382: x_Target_Rec.Notify_Resp2_ID
383: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Notify_Resp2_ID);
384: x_Target_Rec.Notify_Resp2_Short_Name
385: := BIS_UTILITIES_PVT.CheckMissChar
386: (p_char => x_Target_Rec.Notify_Resp2_Short_Name);
387: x_Target_Rec.Notify_Resp3_ID
388: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Notify_Resp3_ID);
389: x_Target_Rec.Notify_Resp3_Short_Name

Line 388: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Notify_Resp3_ID);

384: x_Target_Rec.Notify_Resp2_Short_Name
385: := BIS_UTILITIES_PVT.CheckMissChar
386: (p_char => x_Target_Rec.Notify_Resp2_Short_Name);
387: x_Target_Rec.Notify_Resp3_ID
388: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Notify_Resp3_ID);
389: x_Target_Rec.Notify_Resp3_Short_Name
390: := BIS_UTILITIES_PVT.CheckMissChar
391: (p_char => x_Target_Rec.Notify_Resp3_Short_Name);
392:

Line 390: := BIS_UTILITIES_PVT.CheckMissChar

386: (p_char => x_Target_Rec.Notify_Resp2_Short_Name);
387: x_Target_Rec.Notify_Resp3_ID
388: := BIS_UTILITIES_PVT.CheckMissNum(p_num => x_Target_Rec.Notify_Resp3_ID);
389: x_Target_Rec.Notify_Resp3_Short_Name
390: := BIS_UTILITIES_PVT.CheckMissChar
391: (p_char => x_Target_Rec.Notify_Resp3_Short_Name);
392:
393: -- dbms_output.put_line( ' Inside pvt : 25 ' );
394:

Line 452: x_Target_Tbl(l_ind).Notify_Resp1_ID := NVL(cr.Notify_Resp1_ID, BIS_UTILITIES_PVT.get_role_id(cr.Notify_Resp1_Short_Name));

448: x_Target_Tbl(l_ind).Range2_low := cr.Range2_low;
449: x_Target_Tbl(l_ind).Range2_high := cr.Range2_high;
450: x_Target_Tbl(l_ind).Range3_low := cr.Range3_low;
451: x_Target_Tbl(l_ind).Range3_high := cr.Range3_high;
452: x_Target_Tbl(l_ind).Notify_Resp1_ID := NVL(cr.Notify_Resp1_ID, BIS_UTILITIES_PVT.get_role_id(cr.Notify_Resp1_Short_Name));
453: x_Target_Tbl(l_ind).Notify_Resp1_Short_Name := cr.Notify_Resp1_Short_Name;
454: x_Target_Tbl(l_ind).Notify_Resp1_Name := cr.Notify_Resp1_Name;
455: x_Target_Tbl(l_ind).Notify_Resp2_ID := NVL(cr.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(cr.Notify_Resp2_Short_Name));
456: x_Target_Tbl(l_ind).Notify_Resp2_Short_Name := cr.Notify_Resp2_Short_Name;

Line 455: x_Target_Tbl(l_ind).Notify_Resp2_ID := NVL(cr.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(cr.Notify_Resp2_Short_Name));

451: x_Target_Tbl(l_ind).Range3_high := cr.Range3_high;
452: x_Target_Tbl(l_ind).Notify_Resp1_ID := NVL(cr.Notify_Resp1_ID, BIS_UTILITIES_PVT.get_role_id(cr.Notify_Resp1_Short_Name));
453: x_Target_Tbl(l_ind).Notify_Resp1_Short_Name := cr.Notify_Resp1_Short_Name;
454: x_Target_Tbl(l_ind).Notify_Resp1_Name := cr.Notify_Resp1_Name;
455: x_Target_Tbl(l_ind).Notify_Resp2_ID := NVL(cr.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(cr.Notify_Resp2_Short_Name));
456: x_Target_Tbl(l_ind).Notify_Resp2_Short_Name := cr.Notify_Resp2_Short_Name;
457: x_Target_Tbl(l_ind).Notify_Resp2_Name := cr.Notify_Resp2_Name;
458: x_Target_Tbl(l_ind).Notify_Resp3_ID := NVL(cr.Notify_Resp3_ID, BIS_UTILITIES_PVT.get_role_id(cr.Notify_Resp3_Short_Name));
459: x_Target_Tbl(l_ind).Notify_Resp3_Short_Name := cr.Notify_Resp3_Short_Name;

Line 458: x_Target_Tbl(l_ind).Notify_Resp3_ID := NVL(cr.Notify_Resp3_ID, BIS_UTILITIES_PVT.get_role_id(cr.Notify_Resp3_Short_Name));

454: x_Target_Tbl(l_ind).Notify_Resp1_Name := cr.Notify_Resp1_Name;
455: x_Target_Tbl(l_ind).Notify_Resp2_ID := NVL(cr.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(cr.Notify_Resp2_Short_Name));
456: x_Target_Tbl(l_ind).Notify_Resp2_Short_Name := cr.Notify_Resp2_Short_Name;
457: x_Target_Tbl(l_ind).Notify_Resp2_Name := cr.Notify_Resp2_Name;
458: x_Target_Tbl(l_ind).Notify_Resp3_ID := NVL(cr.Notify_Resp3_ID, BIS_UTILITIES_PVT.get_role_id(cr.Notify_Resp3_Short_Name));
459: x_Target_Tbl(l_ind).Notify_Resp3_Short_Name := cr.Notify_Resp3_Short_Name;
460: x_Target_Tbl(l_ind).Notify_Resp3_Name := cr.Notify_Resp3_Name;
461:
462: -- BIS_UTILITIES_PUB.put_line(p_text => ' Target id = ' || cr.Target_ID ) ;

Line 510: BIS_UTILITIES_PVT.Add_Error_Message

506:
507: --added this check
508: if(l_ind = 0) then
509: l_error_tbl := x_error_tbl;
510: BIS_UTILITIES_PVT.Add_Error_Message
511: ( p_error_msg_name => 'BIS_INVALID_TAR_LEVEL_ID'
512: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
513: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Targets'
514: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 525: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

521: --commented RAISE
522: EXCEPTION
523: WHEN FND_API.G_EXC_ERROR THEN
524: x_return_status:= FND_API.G_RET_STS_ERROR;
525: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
526: htp.p('BIS_TARGET_PVT.Retrieve_Targets:G_EXC_ERROR'); htp.para;
527: END IF;
528: --RAISE;
529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 531: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

527: END IF;
528: --RAISE;
529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
530: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
531: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
532: htp.p('BIS_TARGET_PVT.Retrieve_Targets:G_EXC_UNEXPECTED_ERROR');
533: htp.para;
534: END IF;
535: --RAISE;

Line 539: BIS_UTILITIES_PVT.Add_Error_Message

535: --RAISE;
536: WHEN OTHERS THEN
537: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
538: l_error_Tbl := x_error_Tbl;
539: BIS_UTILITIES_PVT.Add_Error_Message
540: ( p_error_table => l_error_Tbl
541: , p_error_msg_id => SQLCODE
542: , p_error_description => SQLERRM
543: , x_error_table => x_error_Tbl

Line 545: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

541: , p_error_msg_id => SQLCODE
542: , p_error_description => SQLERRM
543: , x_error_table => x_error_Tbl
544: );
545: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
546: htp.p('BIS_TARGET_PVT.Retrieve_Targets:OTHERS'); htp.para;
547: END IF;
548: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
549: --

Line 617: BIS_UTILITIES_PVT.Add_Error_Message

613: ) THEN
614:
615: --added Error Msg--------
616: l_error_tbl := x_error_tbl;
617: BIS_UTILITIES_PVT.Add_Error_Message
618: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
619: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
620: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target'
621: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 635: BIS_UTILITIES_PVT.Add_Error_Message

631: ) THEN
632:
633: --added Error Msg--------
634: l_error_tbl := x_error_tbl;
635: BIS_UTILITIES_PVT.Add_Error_Message
636: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
637: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
638: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target'
639: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 654: BIS_UTILITIES_PVT.Add_Error_Message

650: OR p_Target_Rec.Dim2_Level_Value_ID IS NULL
651: ) THEN
652: --added Error Msg--------
653: l_error_tbl := x_error_tbl;
654: BIS_UTILITIES_PVT.Add_Error_Message
655: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
656: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
657: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target'
658: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 671: BIS_UTILITIES_PVT.Add_Error_Message

667: AND p_Target_Rec.Dim2_Level_Value_ID IS NOT NULL
668: ) THEN
669: --added Error Msg--------
670: l_error_tbl := x_error_tbl;
671: BIS_UTILITIES_PVT.Add_Error_Message
672: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
673: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
674: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target'
675: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 690: BIS_UTILITIES_PVT.Add_Error_Message

686: OR p_Target_Rec.Dim3_Level_Value_ID IS NULL
687: ) THEN
688: --added Error Msg--------
689: l_error_tbl := x_error_tbl;
690: BIS_UTILITIES_PVT.Add_Error_Message
691: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
692: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
693: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target'
694: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 708: BIS_UTILITIES_PVT.Add_Error_Message

704: )
705: THEN
706: --added Error Msg--------
707: l_error_tbl := x_error_tbl;
708: BIS_UTILITIES_PVT.Add_Error_Message
709: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
710: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
711: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target'
712: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 727: BIS_UTILITIES_PVT.Add_Error_Message

723: OR p_Target_Rec.Dim4_Level_Value_ID IS NULL
724: ) THEN
725: --added Error Msg--------
726: l_error_tbl := x_error_tbl;
727: BIS_UTILITIES_PVT.Add_Error_Message
728: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
729: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
730: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target'
731: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 744: BIS_UTILITIES_PVT.Add_Error_Message

740: AND p_Target_Rec.Dim4_Level_Value_ID IS NOT NULL
741: ) THEN
742: --added Error Msg--------
743: l_error_tbl := x_error_tbl;
744: BIS_UTILITIES_PVT.Add_Error_Message
745: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
746: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
747: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target'
748: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 763: BIS_UTILITIES_PVT.Add_Error_Message

759: OR p_Target_Rec.Dim5_Level_Value_ID IS NULL
760: ) THEN
761: --added Error Msg--------
762: l_error_tbl := x_error_tbl;
763: BIS_UTILITIES_PVT.Add_Error_Message
764: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
765: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
766: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target'
767: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 780: BIS_UTILITIES_PVT.Add_Error_Message

776: AND p_Target_Rec.Dim5_Level_Value_ID IS NOT NULL
777: ) THEN
778: --added Error Msg--------
779: l_error_tbl := x_error_tbl;
780: BIS_UTILITIES_PVT.Add_Error_Message
781: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
782: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
783: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target'
784: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 799: BIS_UTILITIES_PVT.Add_Error_Message

795: OR p_Target_Rec.Dim6_Level_Value_ID IS NULL
796: ) THEN
797: --added Error Msg--------
798: l_error_tbl := x_error_tbl;
799: BIS_UTILITIES_PVT.Add_Error_Message
800: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
801: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
802: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target'
803: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 816: BIS_UTILITIES_PVT.Add_Error_Message

812: AND p_Target_Rec.Dim6_Level_Value_ID IS NOT NULL
813: ) THEN
814: --added Error Msg--------
815: l_error_tbl := x_error_tbl;
816: BIS_UTILITIES_PVT.Add_Error_Message
817: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
818: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
819: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target'
820: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 836: BIS_UTILITIES_PVT.Add_Error_Message

832: OR p_Target_Rec.Dim7_Level_Value_ID IS NULL
833: ) THEN
834: --added Error Msg--------
835: l_error_tbl := x_error_tbl;
836: BIS_UTILITIES_PVT.Add_Error_Message
837: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
838: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
839: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target'
840: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 853: BIS_UTILITIES_PVT.Add_Error_Message

849: AND p_Target_Rec.Dim7_Level_Value_ID IS NOT NULL
850: ) THEN
851: --added Error Msg--------
852: l_error_tbl := x_error_tbl;
853: BIS_UTILITIES_PVT.Add_Error_Message
854: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
855: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
856: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target'
857: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 999: x_Target_Rec.Notify_Resp1_ID := NVL(l_bisfv_targets_rec.Notify_Resp1_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp1_Short_Name));

995: x_Target_Rec.Range2_low := l_bisfv_targets_rec.Range2_low;
996: x_Target_Rec.Range2_high := l_bisfv_targets_rec.Range2_high;
997: x_Target_Rec.Range3_low := l_bisfv_targets_rec.Range3_low;
998: x_Target_Rec.Range3_high := l_bisfv_targets_rec.Range3_high;
999: x_Target_Rec.Notify_Resp1_ID := NVL(l_bisfv_targets_rec.Notify_Resp1_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp1_Short_Name));
1000: x_Target_Rec.Notify_Resp1_Short_Name
1001: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;
1002: x_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;
1003: x_Target_Rec.Notify_Resp2_ID := NVL(l_bisfv_targets_rec.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp2_Short_Name));

Line 1003: x_Target_Rec.Notify_Resp2_ID := NVL(l_bisfv_targets_rec.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp2_Short_Name));

999: x_Target_Rec.Notify_Resp1_ID := NVL(l_bisfv_targets_rec.Notify_Resp1_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp1_Short_Name));
1000: x_Target_Rec.Notify_Resp1_Short_Name
1001: := l_bisfv_targets_rec.Notify_Resp1_Short_Name;
1002: x_Target_Rec.Notify_Resp1_Name := l_bisfv_targets_rec.Notify_Resp1_Name;
1003: x_Target_Rec.Notify_Resp2_ID := NVL(l_bisfv_targets_rec.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp2_Short_Name));
1004: x_Target_Rec.Notify_Resp2_Short_Name
1005: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;
1006: x_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;
1007: x_Target_Rec.Notify_Resp3_ID := NVL(l_bisfv_targets_rec.Notify_Resp3_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp3_Short_Name));

Line 1007: x_Target_Rec.Notify_Resp3_ID := NVL(l_bisfv_targets_rec.Notify_Resp3_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp3_Short_Name));

1003: x_Target_Rec.Notify_Resp2_ID := NVL(l_bisfv_targets_rec.Notify_Resp2_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp2_Short_Name));
1004: x_Target_Rec.Notify_Resp2_Short_Name
1005: := l_bisfv_targets_rec.Notify_Resp2_Short_Name;
1006: x_Target_Rec.Notify_Resp2_Name := l_bisfv_targets_rec.Notify_Resp2_Name;
1007: x_Target_Rec.Notify_Resp3_ID := NVL(l_bisfv_targets_rec.Notify_Resp3_ID, BIS_UTILITIES_PVT.get_role_id(l_bisfv_targets_rec.Notify_Resp3_Short_Name));
1008: x_Target_Rec.Notify_Resp3_Short_Name
1009: := l_bisfv_targets_rec.Notify_Resp3_Short_Name;
1010: x_Target_Rec.Notify_Resp3_Name := l_bisfv_targets_rec.Notify_Resp3_Name;
1011:

Line 1057: BIS_UTILITIES_PVT.Add_Error_Message

1053: WHEN NO_DATA_FOUND THEN
1054: --added this error message
1055:
1056: l_error_tbl := x_error_tbl;
1057: BIS_UTILITIES_PVT.Add_Error_Message
1058: ( p_error_msg_name => 'BIS_INVALID_TARGET_VALUE'
1059: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1060: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target'
1061: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1068: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1064: );
1065: x_return_status := FND_API.G_RET_STS_ERROR ;
1066: WHEN FND_API.G_EXC_ERROR THEN
1067: x_return_status:= FND_API.G_RET_STS_ERROR;
1068: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1069: htp.p('BIS_TARGET_PVT.Retrieve_Target:G_EXC_ERROR'); htp.para;
1070: END IF;
1071: -- RAISE;
1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1074: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1070: END IF;
1071: -- RAISE;
1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1073: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1074: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1075: htp.p('BIS_TARGET_PVT.Retrieve_Target:G_EXC_UNEXPECTED_ERROR');
1076: htp.para;
1077: END IF;
1078: -- RAISE;

Line 1082: BIS_UTILITIES_PVT.Add_Error_Message

1078: -- RAISE;
1079: WHEN OTHERS THEN
1080: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1081: l_error_Tbl := x_error_Tbl;
1082: BIS_UTILITIES_PVT.Add_Error_Message
1083: ( p_error_table => l_error_Tbl
1084: , p_error_msg_id => SQLCODE
1085: , p_error_description => SQLERRM
1086: , x_error_table => x_error_Tbl

Line 1088: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1084: , p_error_msg_id => SQLCODE
1085: , p_error_description => SQLERRM
1086: , x_error_table => x_error_Tbl
1087: );
1088: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1089: htp.p('BIS_TARGET_PVT.Retrieve_Target:OTHERS'); htp.para;
1090: END IF;
1091: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: --

Line 1151: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1147: --commented RAISE
1148: EXCEPTION
1149: WHEN FND_API.G_EXC_ERROR THEN
1150: x_return_status:= FND_API.G_RET_STS_ERROR;
1151: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1152: htp.p('BIS_TARGET_PVT.Retrieve_Target_owners:G_EXC_ERROR');
1153: htp.para;
1154: END IF;
1155: -- RAISE;

Line 1158: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1154: END IF;
1155: -- RAISE;
1156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1157: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1158: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1159: htp.p('BIS_TARGET_PVT.Retrieve_Target_owners:G_EXC_UNEXPECTED_ERROR');
1160: htp.para;
1161: END IF;
1162: -- RAISE;

Line 1166: BIS_UTILITIES_PVT.Add_Error_Message

1162: -- RAISE;
1163: WHEN OTHERS THEN
1164: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1165: l_error_Tbl_p := x_error_Tbl;
1166: BIS_UTILITIES_PVT.Add_Error_Message
1167: ( p_error_table => l_error_Tbl_p
1168: , p_error_msg_id => SQLCODE
1169: , p_error_description => SQLERRM
1170: , x_error_table => x_error_Tbl

Line 1172: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1168: , p_error_msg_id => SQLCODE
1169: , p_error_description => SQLERRM
1170: , x_error_table => x_error_Tbl
1171: );
1172: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1173: htp.p('BIS_TARGET_PVT.Retrieve_Target_owners:OTHERS'); htp.para;
1174: END IF;
1175: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176:

Line 1269: BIS_UTILITIES_PVT.Add_Error_Message

1265:
1266: IF(l_target_id <> l_Target_Rec.Target_ID) THEN
1267: --added more params
1268: l_error_tbl := x_error_tbl;
1269: BIS_UTILITIES_PVT.Add_Error_Message
1270: ( p_error_msg_name => 'BIS_UNIQUE_INDEX_VIOLATION'
1271: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1272: , p_error_proc_name => 'BIS_TARGET_PVT.Update_Target'
1273: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1284: BIS_UTILITIES_PVT.Add_Error_Message

1280: WHEN NO_DATA_FOUND THEN
1281:
1282: -- Added this err message
1283: l_error_tbl := x_error_tbl;
1284: BIS_UTILITIES_PVT.Add_Error_Message
1285: ( p_error_msg_name => 'BIS_INVALID_TARGET_VALUE'
1286: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1287: , p_error_proc_name => 'BIS_TARGET_PVT.Update_Target'
1288: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1342: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1338: --commented RAISE
1339: EXCEPTION
1340: WHEN FND_API.G_EXC_ERROR THEN
1341: x_return_status:= FND_API.G_RET_STS_ERROR;
1342: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1343: htp.p('BIS_TARGET_PVT.Update_Target:G_EXC_ERROR'); htp.para;
1344: END IF;
1345: --RAISE;
1346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1348: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1344: END IF;
1345: --RAISE;
1346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1347: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1349: htp.p('BIS_TARGET_PVT.Update_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
1350: END IF;
1351: --RAISE;
1352: WHEN OTHERS THEN

Line 1355: BIS_UTILITIES_PVT.Add_Error_Message

1351: --RAISE;
1352: WHEN OTHERS THEN
1353: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1354: l_error_Tbl := x_error_Tbl;
1355: BIS_UTILITIES_PVT.Add_Error_Message
1356: ( p_error_table => l_error_Tbl
1357: , p_error_msg_id => SQLCODE
1358: , p_error_description => SQLERRM
1359: , x_error_table => x_error_Tbl

Line 1361: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1357: , p_error_msg_id => SQLCODE
1358: , p_error_description => SQLERRM
1359: , x_error_table => x_error_Tbl
1360: );
1361: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1362: htp.p('BIS_TARGET_PVT.Update_Target:OTHERS'); htp.para;
1363: END IF;
1364: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: --

Line 1456: BIS_UTILITIES_PVT.Add_Error_Message

1452: WHEN NO_DATA_FOUND THEN
1453: x_return_status:= FND_API.G_RET_STS_ERROR;
1454: --added more params and changed the message
1455: l_error_tbl := x_error_tbl;
1456: BIS_UTILITIES_PVT.Add_Error_Message
1457: ( p_error_msg_name => 'BIS_INVALID_TARGET_VALUE'
1458: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1459: , p_error_proc_name => 'BIS_TARGET_PVT.GetID'
1460: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1464: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1460: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1461: , p_error_table => l_error_tbl
1462: , x_error_table => x_error_tbl
1463: );
1464: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1465: htp.p('BIS_TARGET_PVT.GetID:NO_DATA_FOUND'); htp.para;
1466: END IF;
1467: -- RAISE FND_API.G_EXC_ERROR;
1468: WHEN FND_API.G_EXC_ERROR THEN

Line 1470: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1466: END IF;
1467: -- RAISE FND_API.G_EXC_ERROR;
1468: WHEN FND_API.G_EXC_ERROR THEN
1469: x_return_status:= FND_API.G_RET_STS_ERROR;
1470: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1471: htp.p('BIS_TARGET_PVT.GetID:G_EXC_ERROR'); htp.para;
1472: END IF;
1473: -- RAISE;
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1476: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1472: END IF;
1473: -- RAISE;
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1476: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1477: htp.p('BIS_TARGET_PVT.GetID:G_EXC_UNEXPECTED_ERROR'); htp.para;
1478: END IF;
1479: -- RAISE;
1480: WHEN OTHERS THEN

Line 1483: BIS_UTILITIES_PVT.Add_Error_Message

1479: -- RAISE;
1480: WHEN OTHERS THEN
1481: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1482: l_error_Tbl_p := x_error_Tbl;
1483: BIS_UTILITIES_PVT.Add_Error_Message
1484: ( p_error_table => l_error_Tbl_p
1485: , p_error_msg_id => SQLCODE
1486: , p_error_description => SQLERRM
1487: , x_error_table => x_error_Tbl

Line 1489: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1485: , p_error_msg_id => SQLCODE
1486: , p_error_description => SQLERRM
1487: , x_error_table => x_error_Tbl
1488: );
1489: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1490: htp.p('BIS_TARGET_PVT.GetID:OTHERS'); htp.para;
1491: END IF;
1492: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1493: --

Line 1541: BIS_UTILITIES_PVT.Add_Error_Message

1537: WHEN NO_DATA_FOUND THEN
1538: x_return_status:= FND_API.G_RET_STS_ERROR;
1539: --added more params
1540: l_error_tbl := x_error_tbl;
1541: BIS_UTILITIES_PVT.Add_Error_Message
1542: ( p_error_msg_name => 'BIS_INVALID_TARGET_VALUE'
1543: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1544: , p_error_proc_name => 'BIS_TARGET_PVT.Delete_Target'
1545: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1551: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1547: , x_error_table => x_error_tbl
1548: );
1549: WHEN FND_API.G_EXC_ERROR THEN
1550: x_return_status:= FND_API.G_RET_STS_ERROR;
1551: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1552: htp.p('BIS_TARGET_PVT.Delete_Target:G_EXC_ERROR'); htp.para;
1553: END IF;
1554: -- RAISE;
1555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1557: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1553: END IF;
1554: -- RAISE;
1555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1556: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1557: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1558: htp.p('BIS_TARGET_PVT.Delete_Target:G_EXC_UNEXPECTED_ERROR'); htp.para;
1559: END IF;
1560: -- RAISE;
1561: WHEN OTHERS THEN

Line 1564: BIS_UTILITIES_PVT.Add_Error_Message

1560: -- RAISE;
1561: WHEN OTHERS THEN
1562: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1563: l_error_Tbl_p := x_error_Tbl;
1564: BIS_UTILITIES_PVT.Add_Error_Message
1565: ( p_error_table => l_error_Tbl_p
1566: , p_error_msg_id => SQLCODE
1567: , p_error_description => SQLERRM
1568: , x_error_table => x_error_Tbl

Line 1570: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1566: , p_error_msg_id => SQLCODE
1567: , p_error_description => SQLERRM
1568: , x_error_table => x_error_Tbl
1569: );
1570: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1571: htp.p('BIS_TARGET_PVT.Delete_Target:OTHERS'); htp.para;
1572: END IF;
1573: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1574: --

Line 1619: BIS_UTILITIES_PVT.concatenateErrorTables

1615: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1616: l_error := FND_API.G_TRUE;
1617: x_return_status:= FND_API.G_RET_STS_ERROR;
1618: l_error_Tbl_p := x_error_Tbl;
1619: BIS_UTILITIES_PVT.concatenateErrorTables
1620: ( p_error_Tbl1 => l_error_Tbl_p
1621: , p_error_Tbl2 => l_error_Tbl
1622: , x_error_Tbl => x_error_Tbl
1623: );

Line 1642: BIS_UTILITIES_PVT.concatenateErrorTables

1638: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1639: l_error := FND_API.G_TRUE;
1640: x_return_status:= FND_API.G_RET_STS_ERROR;
1641: l_error_Tbl_p := x_error_Tbl;
1642: BIS_UTILITIES_PVT.concatenateErrorTables
1643: ( p_error_Tbl1 => l_error_Tbl_p
1644: , p_error_Tbl2 => l_error_Tbl
1645: , x_error_Tbl => x_error_Tbl
1646: );

Line 1665: BIS_UTILITIES_PVT.concatenateErrorTables

1661: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1662: l_error := FND_API.G_TRUE;
1663: x_return_status:= FND_API.G_RET_STS_ERROR;
1664: l_error_Tbl_p := x_error_Tbl;
1665: BIS_UTILITIES_PVT.concatenateErrorTables
1666: ( p_error_Tbl1 => l_error_Tbl_p
1667: , p_error_Tbl2 => l_error_Tbl
1668: , x_error_Tbl => x_error_Tbl
1669: );

Line 1692: BIS_UTILITIES_PVT.concatenateErrorTables

1688: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1689: l_error := FND_API.G_TRUE;
1690: x_return_status:= FND_API.G_RET_STS_ERROR;
1691: l_error_Tbl_p := x_error_Tbl;
1692: BIS_UTILITIES_PVT.concatenateErrorTables
1693: ( p_error_Tbl1 => l_error_Tbl_p
1694: , p_error_Tbl2 => l_error_Tbl
1695: , x_error_Tbl => x_error_Tbl
1696: );

Line 1718: BIS_UTILITIES_PVT.concatenateErrorTables

1714: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1715: l_error := FND_API.G_TRUE;
1716: x_return_status:= FND_API.G_RET_STS_ERROR;
1717: l_error_Tbl_p := x_error_Tbl;
1718: BIS_UTILITIES_PVT.concatenateErrorTables
1719: ( p_error_Tbl1 => l_error_Tbl_p
1720: , p_error_Tbl2 => l_error_Tbl
1721: , x_error_Tbl => x_error_Tbl
1722: );

Line 1744: BIS_UTILITIES_PVT.concatenateErrorTables

1740: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1741: l_error := FND_API.G_TRUE;
1742: x_return_status:= FND_API.G_RET_STS_ERROR;
1743: l_error_Tbl_p := x_error_Tbl;
1744: BIS_UTILITIES_PVT.concatenateErrorTables
1745: ( p_error_Tbl1 => l_error_Tbl_p
1746: , p_error_Tbl2 => l_error_Tbl
1747: , x_error_Tbl => x_error_Tbl
1748: );

Line 1772: BIS_UTILITIES_PVT.concatenateErrorTables

1768: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1769: l_error := FND_API.G_TRUE;
1770: x_return_status:= FND_API.G_RET_STS_ERROR;
1771: l_error_Tbl_p := x_error_Tbl;
1772: BIS_UTILITIES_PVT.concatenateErrorTables
1773: ( p_error_Tbl1 => l_error_Tbl_p
1774: , p_error_Tbl2 => l_error_Tbl
1775: , x_error_Tbl => x_error_Tbl
1776: );

Line 1801: BIS_UTILITIES_PVT.concatenateErrorTables

1797: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1798: l_error := FND_API.G_TRUE;
1799: x_return_status:= FND_API.G_RET_STS_ERROR;
1800: l_error_Tbl_p := x_error_Tbl;
1801: BIS_UTILITIES_PVT.concatenateErrorTables
1802: ( p_error_Tbl1 => l_error_Tbl_p
1803: , p_error_Tbl2 => l_error_Tbl
1804: , x_error_Tbl => x_error_Tbl
1805: );

Line 1828: BIS_UTILITIES_PVT.concatenateErrorTables

1824: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1825: l_error := FND_API.G_TRUE;
1826: x_return_status:= FND_API.G_RET_STS_ERROR;
1827: l_error_Tbl_p := x_error_Tbl;
1828: BIS_UTILITIES_PVT.concatenateErrorTables
1829: ( p_error_Tbl1 => l_error_Tbl_p
1830: , p_error_Tbl2 => l_error_Tbl
1831: , x_error_Tbl => x_error_Tbl
1832: );

Line 1849: BIS_UTILITIES_PVT.concatenateErrorTables

1845: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1846: l_error := FND_API.G_TRUE;
1847: x_return_status:= FND_API.G_RET_STS_ERROR;
1848: l_error_Tbl_p := x_error_Tbl;
1849: BIS_UTILITIES_PVT.concatenateErrorTables
1850: ( p_error_Tbl1 => l_error_Tbl_p
1851: , p_error_Tbl2 => l_error_Tbl
1852: , x_error_Tbl => x_error_Tbl
1853: );

Line 1871: BIS_UTILITIES_PVT.concatenateErrorTables

1867: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1868: l_error := FND_API.G_TRUE;
1869: x_return_status:= FND_API.G_RET_STS_ERROR;
1870: l_error_Tbl_p := x_error_Tbl;
1871: BIS_UTILITIES_PVT.concatenateErrorTables
1872: ( p_error_Tbl1 => l_error_Tbl_p
1873: , p_error_Tbl2 => l_error_Tbl
1874: , x_error_Tbl => x_error_Tbl
1875: );

Line 1892: BIS_UTILITIES_PVT.concatenateErrorTables

1888: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1889: l_error := FND_API.G_TRUE;
1890: x_return_status:= FND_API.G_RET_STS_ERROR;
1891: l_error_Tbl_p := x_error_Tbl;
1892: BIS_UTILITIES_PVT.concatenateErrorTables
1893: ( p_error_Tbl1 => l_error_Tbl_p
1894: , p_error_Tbl2 => l_error_Tbl
1895: , x_error_Tbl => x_error_Tbl
1896: );

Line 1912: BIS_UTILITIES_PVT.concatenateErrorTables

1908: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1909: l_error := FND_API.G_TRUE;
1910: x_return_status:= FND_API.G_RET_STS_ERROR;
1911: l_error_Tbl_p := x_error_Tbl;
1912: BIS_UTILITIES_PVT.concatenateErrorTables
1913: ( p_error_Tbl1 => l_error_Tbl_p
1914: , p_error_Tbl2 => l_error_Tbl
1915: , x_error_Tbl => x_error_Tbl
1916: );

Line 1933: BIS_UTILITIES_PVT.concatenateErrorTables

1929: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1930: l_error := FND_API.G_TRUE;
1931: x_return_status:= FND_API.G_RET_STS_ERROR;
1932: l_error_Tbl_p := x_error_Tbl;
1933: BIS_UTILITIES_PVT.concatenateErrorTables
1934: ( p_error_Tbl1 => l_error_Tbl_p
1935: , p_error_Tbl2 => l_error_Tbl
1936: , x_error_Tbl => x_error_Tbl
1937: );

Line 1954: BIS_UTILITIES_PVT.concatenateErrorTables

1950: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1951: l_error := FND_API.G_TRUE;
1952: x_return_status:= FND_API.G_RET_STS_ERROR;
1953: l_error_Tbl_p := x_error_Tbl;
1954: BIS_UTILITIES_PVT.concatenateErrorTables
1955: ( p_error_Tbl1 => l_error_Tbl_p
1956: , p_error_Tbl2 => l_error_Tbl
1957: , x_error_Tbl => x_error_Tbl
1958: );

Line 1974: BIS_UTILITIES_PVT.concatenateErrorTables

1970: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1971: l_error := FND_API.G_TRUE;
1972: x_return_status:= FND_API.G_RET_STS_ERROR;
1973: l_error_Tbl_p := x_error_Tbl;
1974: BIS_UTILITIES_PVT.concatenateErrorTables
1975: ( p_error_Tbl1 => l_error_Tbl_p
1976: , p_error_Tbl2 => l_error_Tbl
1977: , x_error_Tbl => x_error_Tbl
1978: );

Line 1994: BIS_UTILITIES_PVT.concatenateErrorTables

1990: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1991: l_error := FND_API.G_TRUE;
1992: x_return_status:= FND_API.G_RET_STS_ERROR;
1993: l_error_Tbl_p := x_error_Tbl;
1994: BIS_UTILITIES_PVT.concatenateErrorTables
1995: ( p_error_Tbl1 => l_error_Tbl_p
1996: , p_error_Tbl2 => l_error_Tbl
1997: , x_error_Tbl => x_error_Tbl
1998: );

Line 2014: BIS_UTILITIES_PVT.concatenateErrorTables

2010: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
2011: l_error := FND_API.G_TRUE;
2012: x_return_status:= FND_API.G_RET_STS_ERROR;
2013: l_error_Tbl_p := x_error_Tbl;
2014: BIS_UTILITIES_PVT.concatenateErrorTables
2015: ( p_error_Tbl1 => l_error_Tbl_p
2016: , p_error_Tbl2 => l_error_Tbl
2017: , x_error_Tbl => x_error_Tbl
2018: );

Line 2035: BIS_UTILITIES_PVT.concatenateErrorTables

2031: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
2032: l_error := FND_API.G_TRUE;
2033: x_return_status:= FND_API.G_RET_STS_ERROR;
2034: l_error_Tbl_p := x_error_Tbl;
2035: BIS_UTILITIES_PVT.concatenateErrorTables
2036: ( p_error_Tbl1 => l_error_Tbl_p
2037: , p_error_Tbl2 => l_error_Tbl
2038: , x_error_Tbl => x_error_Tbl
2039: );

Line 2056: BIS_UTILITIES_PVT.concatenateErrorTables

2052: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
2053: l_error := FND_API.G_TRUE;
2054: x_return_status:= FND_API.G_RET_STS_ERROR;
2055: l_error_Tbl_p := x_error_Tbl;
2056: BIS_UTILITIES_PVT.concatenateErrorTables
2057: ( p_error_Tbl1 => l_error_Tbl_p
2058: , p_error_Tbl2 => l_error_Tbl
2059: , x_error_Tbl => x_error_Tbl
2060: );

Line 2079: BIS_UTILITIES_PVT.concatenateErrorTables

2075: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
2076: l_error := FND_API.G_TRUE;
2077: x_return_status:= FND_API.G_RET_STS_ERROR;
2078: l_error_Tbl_p := x_error_Tbl;
2079: BIS_UTILITIES_PVT.concatenateErrorTables
2080: ( p_error_Tbl1 => l_error_Tbl_p
2081: , p_error_Tbl2 => l_error_Tbl
2082: , x_error_Tbl => x_error_Tbl
2083: );

Line 2099: BIS_UTILITIES_PVT.concatenateErrorTables

2095: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) then
2096: l_error := FND_API.G_TRUE;
2097: x_return_status:= FND_API.G_RET_STS_ERROR;
2098: l_error_Tbl_p := x_error_Tbl;
2099: BIS_UTILITIES_PVT.concatenateErrorTables
2100: ( p_error_Tbl1 => l_error_Tbl_p
2101: , p_error_Tbl2 => l_error_Tbl
2102: , x_error_Tbl => x_error_Tbl
2103: );

Line 2121: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2117: --commented RAISE
2118: EXCEPTION
2119: WHEN FND_API.G_EXC_ERROR THEN
2120: x_return_status:= FND_API.G_RET_STS_ERROR;
2121: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2122: htp.p('BIS_TARGET_PVT.Validate_Target:G_EXC_ERROR'); htp.para;
2123: END IF;
2124: --RAISE;
2125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2127: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2123: END IF;
2124: --RAISE;
2125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2127: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2128: htp.p('BIS_TARGET_PVT.Validate_Target:G_EXC_UNEXPECTED_ERROR');
2129: htp.para;
2130: END IF;
2131: -- RAISE;

Line 2135: BIS_UTILITIES_PVT.Add_Error_Message

2131: -- RAISE;
2132: WHEN OTHERS THEN
2133: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2134: l_error_Tbl_p := x_error_Tbl;
2135: BIS_UTILITIES_PVT.Add_Error_Message
2136: ( p_error_table => l_error_Tbl_p
2137: , p_error_msg_id => SQLCODE
2138: , p_error_description => SQLERRM
2139: , x_error_table => x_error_Tbl

Line 2141: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2137: , p_error_msg_id => SQLCODE
2138: , p_error_description => SQLERRM
2139: , x_error_table => x_error_Tbl
2140: );
2141: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2142: htp.p('BIS_TARGET_PVT.Validate_Target:OTHERS'); htp.para;
2143: END IF;
2144: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2145: END Validate_Target;

Line 2166: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2162: --commented RAISE
2163: EXCEPTION
2164: WHEN FND_API.G_EXC_ERROR THEN
2165: x_return_status:= FND_API.G_RET_STS_ERROR;
2166: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2167: htp.p('BIS_TARGET_PVT.Value_ID_Conversion:G_EXC_ERROR'); htp.para;
2168: END IF;
2169: -- RAISE;
2170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2172: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2168: END IF;
2169: -- RAISE;
2170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2171: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2172: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2173: htp.p('BIS_TARGET_PVT.Value_ID_Conversion:G_EXC_UNEXPECTED_ERROR');
2174: htp.para;
2175: END IF;
2176: -- RAISE;

Line 2180: BIS_UTILITIES_PVT.Add_Error_Message

2176: -- RAISE;
2177: WHEN OTHERS THEN
2178: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2179: l_error_Tbl_p := x_error_Tbl;
2180: BIS_UTILITIES_PVT.Add_Error_Message
2181: ( p_error_table => l_error_Tbl_p
2182: , p_error_msg_id => SQLCODE
2183: , p_error_description => SQLERRM
2184: , x_error_table => x_error_Tbl

Line 2186: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2182: , p_error_msg_id => SQLCODE
2183: , p_error_description => SQLERRM
2184: , x_error_table => x_error_Tbl
2185: );
2186: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2187: htp.p('BIS_TARGET_PVT.Value_ID_Conversion:OTHERS'); htp.para;
2188: END IF;
2189: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2190: END Value_ID_Conversion;

Line 2306: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2302: --commented RAISE
2303: EXCEPTION
2304: WHEN FND_API.G_EXC_ERROR THEN
2305: x_return_status:= FND_API.G_RET_STS_ERROR;
2306: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2307: htp.p('BIS_TARGET_PVT.Update_db_Target:G_EXC_ERROR'); htp.para;
2308: END IF;
2309: --RAISE;
2310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2312: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2308: END IF;
2309: --RAISE;
2310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2311: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2312: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2313: htp.p('BIS_TARGET_PVT.Update_db_Target:G_EXC_UNEXPECTED_ERROR');
2314: htp.para;
2315: END IF;
2316: --RAISE;

Line 2320: BIS_UTILITIES_PVT.Add_Error_Message

2316: --RAISE;
2317: WHEN OTHERS THEN
2318: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2319: l_error_Tbl_p := x_error_Tbl;
2320: BIS_UTILITIES_PVT.Add_Error_Message
2321: ( p_error_table => l_error_Tbl_p
2322: , p_error_msg_id => SQLCODE
2323: , p_error_description => SQLERRM
2324: , x_error_table => x_error_Tbl

Line 2326: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2322: , p_error_msg_id => SQLCODE
2323: , p_error_description => SQLERRM
2324: , x_error_table => x_error_Tbl
2325: );
2326: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2327: htp.p('BIS_TARGET_PVT.Update_db_Target:OTHERS'); htp.para;
2328: END IF;
2329: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2330: --

Line 2365: BIS_UTILITIES_PVT.Add_Error_Message

2361: EXCEPTION
2362: WHEN NO_DATA_FOUND THEN
2363: --added this message
2364: l_error_tbl := x_error_tbl;
2365: BIS_UTILITIES_PVT.Add_Error_Message
2366: ( p_error_msg_name => 'BIS_INVALID_TARGET_VALUE'
2367: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2368: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Last_Update_Date'
2369: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2374: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2370: , p_error_table => l_error_tbl
2371: , x_error_table => x_error_tbl
2372: );
2373: x_return_status := FND_API.G_RET_STS_ERROR;
2374: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2375: htp.p('BIS_TARGET_PVT.Retrieve_Last_Update_Date:NO_DATA_FOUND');
2376: htp.para;
2377: END IF;
2378: --RAISE FND_API.G_EXC_ERROR;

Line 2381: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2377: END IF;
2378: --RAISE FND_API.G_EXC_ERROR;
2379: WHEN FND_API.G_EXC_ERROR THEN
2380: x_return_status:= FND_API.G_RET_STS_ERROR;
2381: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2382: htp.p('BIS_TARGET_PVT.Retrieve_Last_Update_Date:G_EXC_ERROR');
2383: htp.para;
2384: END IF;
2385: -- RAISE;

Line 2388: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2384: END IF;
2385: -- RAISE;
2386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2387: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2388: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2389: htp.p
2390: ('BIS_TARGET_PVT.Retrieve_Last_Update_Date:G_EXC_UNEXPECTED_ERROR');
2391: htp.para;
2392: END IF;

Line 2397: BIS_UTILITIES_PVT.Add_Error_Message

2393: -- RAISE;
2394: WHEN OTHERS THEN
2395: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2396: l_error_Tbl := x_error_Tbl;
2397: BIS_UTILITIES_PVT.Add_Error_Message
2398: ( p_error_table => l_error_Tbl
2399: , p_error_msg_id => SQLCODE
2400: , p_error_description => SQLERRM
2401: , x_error_table => x_error_Tbl

Line 2403: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2399: , p_error_msg_id => SQLCODE
2400: , p_error_description => SQLERRM
2401: , x_error_table => x_error_Tbl
2402: );
2403: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2404: htp.p('BIS_TARGET_PVT.Retrieve_Last_Update_Date:OTHERS'); htp.para;
2405: END IF;
2406: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2407: --

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

2434: , x_return_status => x_return_status
2435: , x_error_Tbl => x_error_Tbl
2436: );
2437: IF(p_timestamp IS NOT NULL) THEN
2438: l_form_date := TO_DATE(p_timestamp, BIS_UTILITIES_PVT.G_DATE_FORMAT);
2439: IF(l_form_date = l_last_update_date) THEN
2440: x_result := FND_API.G_TRUE;
2441: ELSE
2442: x_result := FND_API.G_FALSE;

Line 2454: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2450: EXCEPTION
2451: WHEN FND_API.G_EXC_ERROR THEN
2452: x_return_status:= FND_API.G_RET_STS_ERROR;
2453: x_result := FND_API.G_FALSE;
2454: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2455: htp.p('BIS_TARGET_PVT.Lock_Record:G_EXC_ERROR'); htp.para;
2456: END IF;
2457: -- RAISE;
2458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2461: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2457: -- RAISE;
2458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2459: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2460: x_result := FND_API.G_FALSE;
2461: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2462: htp.p('BIS_TARGET_PVT.Lock_Record:G_EXC_UNEXPECTED_ERROR');
2463: htp.para;
2464: END IF;
2465: -- RAISE;

Line 2469: BIS_UTILITIES_PVT.Add_Error_Message

2465: -- RAISE;
2466: WHEN OTHERS THEN
2467: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2468: l_error_Tbl_p := x_error_Tbl;
2469: BIS_UTILITIES_PVT.Add_Error_Message
2470: ( p_error_table => l_error_Tbl_p
2471: , p_error_msg_id => SQLCODE
2472: , p_error_description => SQLERRM
2473: , x_error_table => x_error_Tbl

Line 2476: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2472: , p_error_description => SQLERRM
2473: , x_error_table => x_error_Tbl
2474: );
2475: x_result := FND_API.G_FALSE;
2476: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2477: htp.p('BIS_TARGET_PVT.Lock_Record:OTHERS'); htp.para;
2478: END IF;
2479: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2480: --

Line 2548: BIS_UTILITIES_PVT.Add_Error_Message

2544: -- populate error table if there are no rows in the out NOCOPY table
2545: IF(x_Dim_Level_Value_Tbl.COUNT = 0) THEN
2546: --added more params
2547: l_error_tbl := x_error_tbl;
2548: BIS_UTILITIES_PVT.Add_Error_Message
2549: ( p_error_msg_name => 'BIS_NO_DIMX_ACCESS'
2550: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2551: , p_error_proc_name => 'BIS_TARGET_PVT.Retrieve_Measure_Dim_Values'
2552: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2562: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2558: --commented RAISE
2559: EXCEPTION
2560: WHEN NO_DATA_FOUND THEN
2561: x_return_status:= FND_API.G_RET_STS_ERROR;
2562: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2563: htp.p('BIS_TARGET_PVT.Retrieve_Measure_Dim_Values:NO_DATA_FOUND');
2564: htp.para;
2565: END IF;
2566: -- RAISE FND_API.G_EXC_ERROR;

Line 2569: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2565: END IF;
2566: -- RAISE FND_API.G_EXC_ERROR;
2567: WHEN FND_API.G_EXC_ERROR THEN
2568: x_return_status:= FND_API.G_RET_STS_ERROR;
2569: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2570: htp.p('BIS_TARGET_PVT.Retrieve_Measure_Dim_Values:G_EXC_ERROR');
2571: htp.para;
2572: END IF;
2573: -- RAISE;

Line 2576: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2572: END IF;
2573: -- RAISE;
2574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2575: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2576: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2577: htp.p
2578: ('BIS_TARGET_PVT.Retrieve_Measure_Dim_Values:G_EXC_UNEXPECTED_ERROR');
2579: htp.para;
2580:

Line 2586: BIS_UTILITIES_PVT.Add_Error_Message

2582: -- RAISE;
2583: WHEN OTHERS THEN
2584: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
2585: l_error_Tbl := x_error_Tbl;
2586: BIS_UTILITIES_PVT.Add_Error_Message
2587: ( p_error_table => l_error_Tbl
2588: , p_error_msg_id => SQLCODE
2589: , p_error_description => SQLERRM
2590: , x_error_table => x_error_Tbl

Line 2592: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2588: , p_error_msg_id => SQLCODE
2589: , p_error_description => SQLERRM
2590: , x_error_table => x_error_Tbl
2591: );
2592: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2593: htp.p('BIS_TARGET_PVT.Retrieve_Measure_Dim_Values:OTHERS'); htp.para;
2594: END IF;
2595: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2596: --

Line 2617: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2613: --
2614: --commented RAISE
2615: EXCEPTION
2616: WHEN OTHERS THEN
2617: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2618: htp.p('BIS_TARGET_PVT.GetQueryStatement'); htp.para;
2619: END IF;
2620: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2621: END GetQueryStatement;

Line 2740: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2736: --
2737: --commented RAISE
2738: EXCEPTION
2739: WHEN OTHERS THEN
2740: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2741: htp.p('BIS_TARGET_PVT.GetViewNames'); htp.para;
2742: END IF;
2743: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2744: END GetViewNames;

Line 2777: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2773:
2774: --commented RAISE
2775: EXCEPTION
2776: WHEN OTHERS THEN
2777: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2778: htp.p('BIS_TARGET_PVT.GetComputingUserFunctionName:OTHERS');
2779: htp.para;
2780: END IF;
2781: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2809: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

2805:
2806: --commented RAISE
2807: EXCEPTION
2808: WHEN OTHERS THEN
2809: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
2810: htp.p('BIS_TARGET_PVT.GetNotifyResponsibilityName:OTHERS');
2811: htp.para;
2812: END IF;
2813: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2869: BIS_UTILITIES_PVT.Replace_String

2865: into l_computed_target_short_name
2866: from fnd_form_functions_vl
2867: where function_id = p_computing_function_id;
2868:
2869: BIS_UTILITIES_PVT.Replace_String
2870: ( p_target_rec.target_level_short_name
2871: , l_target_level_short_name
2872: );
2873: BIS_UTILITIES_PVT.Replace_String

Line 2873: BIS_UTILITIES_PVT.Replace_String

2869: BIS_UTILITIES_PVT.Replace_String
2870: ( p_target_rec.target_level_short_name
2871: , l_target_level_short_name
2872: );
2873: BIS_UTILITIES_PVT.Replace_String
2874: ( p_target_rec.target_level_name
2875: , l_target_level_name
2876: );
2877: BIS_UTILITIES_PVT.Replace_String

Line 2877: BIS_UTILITIES_PVT.Replace_String

2873: BIS_UTILITIES_PVT.Replace_String
2874: ( p_target_rec.target_level_name
2875: , l_target_level_name
2876: );
2877: BIS_UTILITIES_PVT.Replace_String
2878: ( p_target_rec.plan_short_name
2879: , l_plan_short_name
2880: );
2881: BIS_UTILITIES_PVT.Replace_String

Line 2881: BIS_UTILITIES_PVT.Replace_String

2877: BIS_UTILITIES_PVT.Replace_String
2878: ( p_target_rec.plan_short_name
2879: , l_plan_short_name
2880: );
2881: BIS_UTILITIES_PVT.Replace_String
2882: ( p_target_rec.plan_name
2883: , l_plan_name
2884: );
2885: BIS_UTILITIES_PVT.Replace_String

Line 2885: BIS_UTILITIES_PVT.Replace_String

2881: BIS_UTILITIES_PVT.Replace_String
2882: ( p_target_rec.plan_name
2883: , l_plan_name
2884: );
2885: BIS_UTILITIES_PVT.Replace_String
2886: ( p_target_rec.Org_Level_Value_ID
2887: , l_Org_Level_Value_ID
2888: );
2889: BIS_UTILITIES_PVT.Replace_String

Line 2889: BIS_UTILITIES_PVT.Replace_String

2885: BIS_UTILITIES_PVT.Replace_String
2886: ( p_target_rec.Org_Level_Value_ID
2887: , l_Org_Level_Value_ID
2888: );
2889: BIS_UTILITIES_PVT.Replace_String
2890: ( p_target_rec.Org_Level_Value_name
2891: , l_Org_Level_Value_name
2892: );
2893: BIS_UTILITIES_PVT.Replace_String

Line 2893: BIS_UTILITIES_PVT.Replace_String

2889: BIS_UTILITIES_PVT.Replace_String
2890: ( p_target_rec.Org_Level_Value_name
2891: , l_Org_Level_Value_name
2892: );
2893: BIS_UTILITIES_PVT.Replace_String
2894: ( p_target_rec.Time_Level_Value_ID
2895: , l_Time_Level_Value_ID
2896: );
2897: BIS_UTILITIES_PVT.Replace_String

Line 2897: BIS_UTILITIES_PVT.Replace_String

2893: BIS_UTILITIES_PVT.Replace_String
2894: ( p_target_rec.Time_Level_Value_ID
2895: , l_Time_Level_Value_ID
2896: );
2897: BIS_UTILITIES_PVT.Replace_String
2898: ( p_target_rec.Time_Level_Value_name
2899: , l_Time_Level_Value_name
2900: );
2901: BIS_UTILITIES_PVT.Replace_String

Line 2901: BIS_UTILITIES_PVT.Replace_String

2897: BIS_UTILITIES_PVT.Replace_String
2898: ( p_target_rec.Time_Level_Value_name
2899: , l_Time_Level_Value_name
2900: );
2901: BIS_UTILITIES_PVT.Replace_String
2902: ( p_target_rec.Dim1_Level_Value_ID
2903: , l_Dim1_Level_Value_ID
2904: );
2905: BIS_UTILITIES_PVT.Replace_String

Line 2905: BIS_UTILITIES_PVT.Replace_String

2901: BIS_UTILITIES_PVT.Replace_String
2902: ( p_target_rec.Dim1_Level_Value_ID
2903: , l_Dim1_Level_Value_ID
2904: );
2905: BIS_UTILITIES_PVT.Replace_String
2906: ( p_target_rec.Dim1_Level_Value_name
2907: , l_Dim1_Level_Value_name
2908: );
2909: BIS_UTILITIES_PVT.Replace_String

Line 2909: BIS_UTILITIES_PVT.Replace_String

2905: BIS_UTILITIES_PVT.Replace_String
2906: ( p_target_rec.Dim1_Level_Value_name
2907: , l_Dim1_Level_Value_name
2908: );
2909: BIS_UTILITIES_PVT.Replace_String
2910: ( p_target_rec.Dim2_Level_Value_ID
2911: , l_Dim2_Level_Value_ID
2912: );
2913: BIS_UTILITIES_PVT.Replace_String

Line 2913: BIS_UTILITIES_PVT.Replace_String

2909: BIS_UTILITIES_PVT.Replace_String
2910: ( p_target_rec.Dim2_Level_Value_ID
2911: , l_Dim2_Level_Value_ID
2912: );
2913: BIS_UTILITIES_PVT.Replace_String
2914: ( p_target_rec.Dim2_Level_Value_name
2915: , l_Dim2_Level_Value_name
2916: );
2917: BIS_UTILITIES_PVT.Replace_String

Line 2917: BIS_UTILITIES_PVT.Replace_String

2913: BIS_UTILITIES_PVT.Replace_String
2914: ( p_target_rec.Dim2_Level_Value_name
2915: , l_Dim2_Level_Value_name
2916: );
2917: BIS_UTILITIES_PVT.Replace_String
2918: ( p_target_rec.Dim3_Level_Value_ID
2919: , l_Dim3_Level_Value_ID
2920: );
2921: BIS_UTILITIES_PVT.Replace_String

Line 2921: BIS_UTILITIES_PVT.Replace_String

2917: BIS_UTILITIES_PVT.Replace_String
2918: ( p_target_rec.Dim3_Level_Value_ID
2919: , l_Dim3_Level_Value_ID
2920: );
2921: BIS_UTILITIES_PVT.Replace_String
2922: ( p_target_rec.Dim3_Level_Value_name
2923: , l_Dim3_Level_Value_name
2924: );
2925: BIS_UTILITIES_PVT.Replace_String

Line 2925: BIS_UTILITIES_PVT.Replace_String

2921: BIS_UTILITIES_PVT.Replace_String
2922: ( p_target_rec.Dim3_Level_Value_name
2923: , l_Dim3_Level_Value_name
2924: );
2925: BIS_UTILITIES_PVT.Replace_String
2926: ( p_target_rec.Dim4_Level_Value_ID
2927: , l_Dim4_Level_Value_ID
2928: );
2929: BIS_UTILITIES_PVT.Replace_String

Line 2929: BIS_UTILITIES_PVT.Replace_String

2925: BIS_UTILITIES_PVT.Replace_String
2926: ( p_target_rec.Dim4_Level_Value_ID
2927: , l_Dim4_Level_Value_ID
2928: );
2929: BIS_UTILITIES_PVT.Replace_String
2930: ( p_target_rec.Dim4_Level_Value_name
2931: , l_Dim4_Level_Value_name
2932: );
2933: BIS_UTILITIES_PVT.Replace_String

Line 2933: BIS_UTILITIES_PVT.Replace_String

2929: BIS_UTILITIES_PVT.Replace_String
2930: ( p_target_rec.Dim4_Level_Value_name
2931: , l_Dim4_Level_Value_name
2932: );
2933: BIS_UTILITIES_PVT.Replace_String
2934: ( p_target_rec.Dim5_Level_Value_ID
2935: , l_Dim5_Level_Value_ID
2936: );
2937: BIS_UTILITIES_PVT.Replace_String

Line 2937: BIS_UTILITIES_PVT.Replace_String

2933: BIS_UTILITIES_PVT.Replace_String
2934: ( p_target_rec.Dim5_Level_Value_ID
2935: , l_Dim5_Level_Value_ID
2936: );
2937: BIS_UTILITIES_PVT.Replace_String
2938: ( p_target_rec.Dim5_Level_Value_name
2939: , l_Dim5_Level_Value_name
2940: );
2941: BIS_UTILITIES_PVT.Replace_String

Line 2941: BIS_UTILITIES_PVT.Replace_String

2937: BIS_UTILITIES_PVT.Replace_String
2938: ( p_target_rec.Dim5_Level_Value_name
2939: , l_Dim5_Level_Value_name
2940: );
2941: BIS_UTILITIES_PVT.Replace_String
2942: ( p_target_rec.Dim6_Level_Value_ID
2943: , l_Dim6_Level_Value_ID
2944: );
2945: BIS_UTILITIES_PVT.Replace_String

Line 2945: BIS_UTILITIES_PVT.Replace_String

2941: BIS_UTILITIES_PVT.Replace_String
2942: ( p_target_rec.Dim6_Level_Value_ID
2943: , l_Dim6_Level_Value_ID
2944: );
2945: BIS_UTILITIES_PVT.Replace_String
2946: ( p_target_rec.Dim6_Level_Value_name
2947: , l_Dim6_Level_Value_name
2948: );
2949: BIS_UTILITIES_PVT.Replace_String

Line 2949: BIS_UTILITIES_PVT.Replace_String

2945: BIS_UTILITIES_PVT.Replace_String
2946: ( p_target_rec.Dim6_Level_Value_name
2947: , l_Dim6_Level_Value_name
2948: );
2949: BIS_UTILITIES_PVT.Replace_String
2950: ( p_target_rec.Dim7_Level_Value_ID
2951: , l_Dim7_Level_Value_ID
2952: );
2953: BIS_UTILITIES_PVT.Replace_String

Line 2953: BIS_UTILITIES_PVT.Replace_String

2949: BIS_UTILITIES_PVT.Replace_String
2950: ( p_target_rec.Dim7_Level_Value_ID
2951: , l_Dim7_Level_Value_ID
2952: );
2953: BIS_UTILITIES_PVT.Replace_String
2954: ( p_target_rec.Dim7_Level_Value_name
2955: , l_Dim7_Level_Value_name
2956: );
2957:

Line 3220: IF (BIS_UTILITIES_PVT.Value_Not_Missing(p_Target_Rec.target_id)

3216:
3217: --BIS_UTILITIES_PUB.put_line(p_text =>'retrieved time level: '||l_Dimension_Level_Rec.Dimension_Level_id
3218: --||', time level number: '||l_dimension_level_number);
3219:
3220: IF (BIS_UTILITIES_PVT.Value_Not_Missing(p_Target_Rec.target_id)
3221: = FND_API.G_TRUE)
3222: AND (BIS_UTILITIES_PVT.Value_Not_Null(p_Target_Rec.target_id)
3223: = FND_API.G_TRUE)
3224: THEN

Line 3222: AND (BIS_UTILITIES_PVT.Value_Not_Null(p_Target_Rec.target_id)

3218: --||', time level number: '||l_dimension_level_number);
3219:
3220: IF (BIS_UTILITIES_PVT.Value_Not_Missing(p_Target_Rec.target_id)
3221: = FND_API.G_TRUE)
3222: AND (BIS_UTILITIES_PVT.Value_Not_Null(p_Target_Rec.target_id)
3223: = FND_API.G_TRUE)
3224: THEN
3225: OPEN cr_tar_dim_value(p_Target_Rec.target_id);
3226: FETCH cr_tar_dim_value INTO

Line 3239: BIS_UTILITIES_PVT.Add_Error_Message

3235: --added this
3236: if cr_tar_dim_value%NOTFOUND then
3237: --added this message
3238: l_error_tbl := x_error_tbl;
3239: BIS_UTILITIES_PVT.Add_Error_Message
3240: ( p_error_msg_name => 'BIS_INVALID_TARGET_VALUE'
3241: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3242: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Time_Level_Value'
3243: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 3283: BIS_UTILITIES_PVT.Add_Error_Message

3279: BIS_UTILITIES_PUB.put_line(p_text =>'Error 2 while getting time level value: '||SQLERRM);
3280: IF cr_tar_dim_value%ISOPEN THEN CLOSE cr_tar_dim_value; END IF;
3281: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3282: l_error_Tbl := x_error_Tbl;
3283: BIS_UTILITIES_PVT.Add_Error_Message
3284: ( p_error_table => l_error_Tbl
3285: , p_error_msg_id => SQLCODE
3286: , p_error_description => SQLERRM
3287: , x_error_table => x_error_Tbl

Line 3421: BIS_UTILITIES_PVT.Add_Error_Message

3417: BIS_UTILITIES_PUB.put_line(p_text =>'Error 2 while getting Org level value: '||SQLERRM);
3418: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3419:
3420: l_error_Tbl_p := x_error_Tbl;
3421: BIS_UTILITIES_PVT.Add_Error_Message
3422: ( p_error_table => l_error_Tbl_p
3423: , p_error_msg_id => SQLCODE
3424: , p_error_description => SQLERRM
3425: , x_error_table => x_error_Tbl

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

3576: ,x_Dimension_Level_Rec => l_dim_level_rec
3577: ,x_return_status => x_return_status
3578: ,x_error_Tbl => x_error_tbl
3579: );
3580: l_dim1_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3581: END IF;
3582:
3583: IF (x_target_level_rec.dimension2_level_id IS NOT NULL
3584: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension2_level_id)= FND_API.G_TRUE) THEN

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

3590: ,x_Dimension_Level_Rec => l_dim_level_rec
3591: ,x_return_status => x_return_status
3592: ,x_error_Tbl => x_error_tbl
3593: );
3594: l_dim2_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3595: END IF;
3596:
3597: IF (x_target_level_rec.dimension3_level_id IS NOT NULL
3598: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension3_level_id)= FND_API.G_TRUE) THEN

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

3604: ,x_Dimension_Level_Rec => l_dim_level_rec
3605: ,x_return_status => x_return_status
3606: ,x_error_Tbl => x_error_tbl
3607: );
3608: l_dim3_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3609: END IF;
3610:
3611: IF (x_target_level_rec.dimension4_level_id IS NOT NULL
3612: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension4_level_id)= FND_API.G_TRUE) THEN

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

3618: ,x_Dimension_Level_Rec => l_dim_level_rec
3619: ,x_return_status => x_return_status
3620: ,x_error_Tbl => x_error_tbl
3621: );
3622: l_dim4_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3623: END IF;
3624:
3625: IF (x_target_level_rec.dimension5_level_id IS NOT NULL
3626: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension5_level_id)= FND_API.G_TRUE) THEN

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

3632: ,x_Dimension_Level_Rec => l_dim_level_rec
3633: ,x_return_status => x_return_status
3634: ,x_error_Tbl => x_error_tbl
3635: );
3636: l_dim5_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3637: END IF;
3638:
3639: IF (x_target_level_rec.dimension6_level_id IS NOT NULL
3640: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension6_level_id)= FND_API.G_TRUE) THEN

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

3646: ,x_Dimension_Level_Rec => l_dim_level_rec
3647: ,x_return_status => x_return_status
3648: ,x_error_Tbl => x_error_tbl
3649: );
3650: l_dim6_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3651: END IF;
3652:
3653: IF (x_target_level_rec.dimension7_level_id IS NOT NULL
3654: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension7_level_id)= FND_API.G_TRUE) THEN

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

3660: ,x_Dimension_Level_Rec => l_dim_level_rec
3661: ,x_return_status => x_return_status
3662: ,x_error_Tbl => x_error_tbl
3663: );
3664: l_dim7_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3665: END IF;
3666:
3667: IF (l_measure_rec.dimension1_id = l_dim1_id) THEN
3668: l_dim1_level_id := x_target_level_rec.dimension1_level_id;

Line 4106: BIS_UTILITIES_PVT.Add_Error_Message

4102: when others then
4103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4104: --Added last two parameters
4105: l_error_tbl := x_error_tbl;
4106: BIS_UTILITIES_PVT.Add_Error_Message
4107: ( p_error_msg_id => SQLCODE
4108: , p_error_description => SQLERRM
4109: , p_error_proc_name => G_PKG_NAME||'.Create_Target_Level'
4110: , p_error_table => l_error_tbl