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_UTILITIES_PVT dependencies on BIS_UTILITIES_PUB

Line 266: if (p_varchar <> BIS_UTILITIES_PUB.G_NULL_CHAR) then

262: )
263: is
264: begin
265: --
266: if (p_varchar <> BIS_UTILITIES_PUB.G_NULL_CHAR) then
267: if (p_value is null) then
268: htp.formSelectOption(p_varchar);
269: else
270: htp.formSelectOption(p_varchar, p_selected, 'VALUE="'||p_value||'"');

Line 371: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR

367: PROCEDURE Add_Error_Message
368: ( p_error_msg_name IN VARCHAR2
369: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
370: , p_error_proc_name IN VARCHAR2 := NULL
371: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
372: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type
373: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
374: )
375: IS

Line 372: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type

368: ( p_error_msg_name IN VARCHAR2
369: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
370: , p_error_proc_name IN VARCHAR2 := NULL
371: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
372: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type
373: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
374: )
375: IS
376: --

Line 373: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

369: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
370: , p_error_proc_name IN VARCHAR2 := NULL
371: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
372: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type
373: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
374: )
375: IS
376: --
377: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;

Line 377: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;

373: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
374: )
375: IS
376: --
377: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;
378: --
379: BEGIN
380: IF (fnd_msg_pub.check_msg_level(p_error_msg_level) = TRUE) THEN
381: fnd_message.set_name(BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME, p_error_msg_name);

Line 399: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR

395: PROCEDURE Add_Error_Message
396: ( p_error_msg_name IN VARCHAR2
397: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
398: , p_error_proc_name IN VARCHAR2 := NULL
399: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
400: , p_token1 IN VARCHAR2
401: , p_value1 IN VARCHAR2
402: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type
403: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 402: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type

398: , p_error_proc_name IN VARCHAR2 := NULL
399: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
400: , p_token1 IN VARCHAR2
401: , p_value1 IN VARCHAR2
402: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type
403: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
404: )
405: IS
406: --

Line 403: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

399: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
400: , p_token1 IN VARCHAR2
401: , p_value1 IN VARCHAR2
402: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type
403: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
404: )
405: IS
406: --
407: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;

Line 407: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;

403: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
404: )
405: IS
406: --
407: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;
408: --
409: BEGIN
410:
411: IF (fnd_msg_pub.check_msg_level(p_error_msg_level) = TRUE) THEN

Line 436: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR

432: PROCEDURE Add_Error_Message
433: ( p_error_msg_name IN VARCHAR2
434: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
435: , p_error_proc_name IN VARCHAR2 := NULL
436: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
437: , p_token1 IN VARCHAR2
438: , p_value1 IN VARCHAR2
439: , p_token2 IN VARCHAR2
440: , p_value2 IN VARCHAR2

Line 441: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type

437: , p_token1 IN VARCHAR2
438: , p_value1 IN VARCHAR2
439: , p_token2 IN VARCHAR2
440: , p_value2 IN VARCHAR2
441: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type
442: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
443: )
444: IS
445: --

Line 442: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

438: , p_value1 IN VARCHAR2
439: , p_token2 IN VARCHAR2
440: , p_value2 IN VARCHAR2
441: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type
442: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
443: )
444: IS
445: --
446: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;

Line 446: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;

442: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
443: )
444: IS
445: --
446: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;
447: --
448: BEGIN
449:
450: IF (fnd_msg_pub.check_msg_level(p_error_msg_level) = TRUE) THEN

Line 477: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR

473: PROCEDURE Add_Error_Message
474: ( p_error_msg_name IN VARCHAR2
475: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
476: , p_error_proc_name IN VARCHAR2 := NULL
477: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
478: , p_token1 IN VARCHAR2
479: , p_value1 IN VARCHAR2
480: , p_token2 IN VARCHAR2
481: , p_value2 IN VARCHAR2

Line 484: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type

480: , p_token2 IN VARCHAR2
481: , p_value2 IN VARCHAR2
482: , p_token3 IN VARCHAR2
483: , p_value3 IN VARCHAR2
484: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type
485: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
486: )
487: IS
488: --

Line 485: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

481: , p_value2 IN VARCHAR2
482: , p_token3 IN VARCHAR2
483: , p_value3 IN VARCHAR2
484: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type
485: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
486: )
487: IS
488: --
489: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;

Line 489: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;

485: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
486: )
487: IS
488: --
489: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;
490: --
491: BEGIN
492:
493: IF (fnd_msg_pub.check_msg_level(p_error_msg_level) = TRUE) THEN

Line 523: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR

519: PROCEDURE Add_Error_Message
520: ( p_error_msg_id IN NUMBER := NULL
521: , p_error_description IN VARCHAR2 := NULL
522: , p_error_proc_name IN VARCHAR2 := NULL
523: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
524: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type
525: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
526: )
527: IS

Line 524: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type

520: ( p_error_msg_id IN NUMBER := NULL
521: , p_error_description IN VARCHAR2 := NULL
522: , p_error_proc_name IN VARCHAR2 := NULL
523: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
524: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type
525: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
526: )
527: IS
528: --

Line 525: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

521: , p_error_description IN VARCHAR2 := NULL
522: , p_error_proc_name IN VARCHAR2 := NULL
523: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
524: , p_error_table IN BIS_UTILITIES_PUB.Error_Tbl_Type
525: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
526: )
527: IS
528: --
529: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;

Line 529: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;

525: , x_error_table OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
526: )
527: IS
528: --
529: l_error_rec BIS_UTILITIES_PUB.Error_Rec_Type;
530: --
531: BEGIN
532:
533: l_error_rec.Error_Msg_ID := p_error_msg_id;

Line 547: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR

543: PROCEDURE Add_Error_Message
544: ( p_error_msg_name IN VARCHAR2
545: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
546: , p_error_proc_name IN VARCHAR2 := NULL
547: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
548: )
549: IS
550: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
551: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 550: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

546: , p_error_proc_name IN VARCHAR2 := NULL
547: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
548: )
549: IS
550: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
551: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
552: l_return_status VARCHAR2(32000);
553: BEGIN
554: BIS_UTILITIES_PVT.Add_Error_Message

Line 551: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

547: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
548: )
549: IS
550: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
551: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
552: l_return_status VARCHAR2(32000);
553: BEGIN
554: BIS_UTILITIES_PVT.Add_Error_Message
555: ( p_error_msg_name

Line 572: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR

568: PROCEDURE Add_Error_Message
569: ( p_error_msg_name IN VARCHAR2
570: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
571: , p_error_proc_name IN VARCHAR2 := NULL
572: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
573: , p_token1 IN VARCHAR2
574: , p_value1 IN VARCHAR2
575: )
576: IS

Line 577: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

573: , p_token1 IN VARCHAR2
574: , p_value1 IN VARCHAR2
575: )
576: IS
577: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
578: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
579: l_return_status VARCHAR2(32000);
580: BEGIN
581: BIS_UTILITIES_PVT.Add_Error_Message

Line 578: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

574: , p_value1 IN VARCHAR2
575: )
576: IS
577: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
578: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
579: l_return_status VARCHAR2(32000);
580: BEGIN
581: BIS_UTILITIES_PVT.Add_Error_Message
582: ( p_error_msg_name

Line 601: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR

597: PROCEDURE Add_Error_Message
598: ( p_error_msg_name IN VARCHAR2
599: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
600: , p_error_proc_name IN VARCHAR2 := NULL
601: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
602: , p_token1 IN VARCHAR2
603: , p_value1 IN VARCHAR2
604: , p_token2 IN VARCHAR2
605: , p_value2 IN VARCHAR2

Line 608: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

604: , p_token2 IN VARCHAR2
605: , p_value2 IN VARCHAR2
606: )
607: IS
608: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
609: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
610: l_return_status VARCHAR2(32000);
611: BEGIN
612: BIS_UTILITIES_PVT.Add_Error_Message

Line 609: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

605: , p_value2 IN VARCHAR2
606: )
607: IS
608: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
609: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
610: l_return_status VARCHAR2(32000);
611: BEGIN
612: BIS_UTILITIES_PVT.Add_Error_Message
613: ( p_error_msg_name

Line 634: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR

630: PROCEDURE Add_Error_Message
631: ( p_error_msg_name IN VARCHAR2
632: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
633: , p_error_proc_name IN VARCHAR2 := NULL
634: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
635: , p_token1 IN VARCHAR2
636: , p_value1 IN VARCHAR2
637: , p_token2 IN VARCHAR2
638: , p_value2 IN VARCHAR2

Line 643: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

639: , p_token3 IN VARCHAR2
640: , p_value3 IN VARCHAR2
641: )
642: IS
643: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
644: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
645: l_return_status VARCHAR2(32000);
646: BEGIN
647: BIS_UTILITIES_PVT.Add_Error_Message

Line 644: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

640: , p_value3 IN VARCHAR2
641: )
642: IS
643: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
644: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
645: l_return_status VARCHAR2(32000);
646: BEGIN
647: BIS_UTILITIES_PVT.Add_Error_Message
648: ( p_error_msg_name

Line 672: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR

668: PROCEDURE Add_Error_Message
669: ( p_error_msg_id IN NUMBER := NULL
670: , p_error_description IN VARCHAR2 := NULL
671: , p_error_proc_name IN VARCHAR2 := NULL
672: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
673: )
674: IS
675: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
676: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 675: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

671: , p_error_proc_name IN VARCHAR2 := NULL
672: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
673: )
674: IS
675: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
676: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
677: l_return_status VARCHAR2(32000);
678: BEGIN
679: BIS_UTILITIES_PVT.Add_Error_Message

Line 676: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

672: , p_error_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_ERROR
673: )
674: IS
675: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
676: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
677: l_return_status VARCHAR2(32000);
678: BEGIN
679: BIS_UTILITIES_PVT.Add_Error_Message
680: ( p_error_msg_id

Line 1274: , p_data_tbl IN BIS_UTILITIES_PUB.BIS_VARCHAR_TBL

1270:
1271: PROCEDURE getGroupBoxString
1272: ( p_title_string IN varchar2
1273: , p_title_bold IN varchar2 := FND_API.G_FALSE
1274: , p_data_tbl IN BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1275: , x_data_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1276: )
1277: IS
1278: l_str VARCHAR2(32000);

Line 1275: , x_data_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL

1271: PROCEDURE getGroupBoxString
1272: ( p_title_string IN varchar2
1273: , p_title_bold IN varchar2 := FND_API.G_FALSE
1274: , p_data_tbl IN BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1275: , x_data_tbl OUT NOCOPY BIS_UTILITIES_PUB.BIS_VARCHAR_TBL
1276: )
1277: IS
1278: l_str VARCHAR2(32000);
1279: BEGIN

Line 1930: ( p_error_Tbl1 IN BIS_UTILITIES_PUB.Error_Tbl_Type

1926: end getTableString;
1927: --
1928: -- concatenate the two error tables into one
1929: PROCEDURE concatenateErrorTables
1930: ( p_error_Tbl1 IN BIS_UTILITIES_PUB.Error_Tbl_Type
1931: , p_error_Tbl2 IN BIS_UTILITIES_PUB.Error_Tbl_Type
1932: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1933: )
1934: IS

Line 1931: , p_error_Tbl2 IN BIS_UTILITIES_PUB.Error_Tbl_Type

1927: --
1928: -- concatenate the two error tables into one
1929: PROCEDURE concatenateErrorTables
1930: ( p_error_Tbl1 IN BIS_UTILITIES_PUB.Error_Tbl_Type
1931: , p_error_Tbl2 IN BIS_UTILITIES_PUB.Error_Tbl_Type
1932: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1933: )
1934: IS
1935: --

Line 1932: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1928: -- concatenate the two error tables into one
1929: PROCEDURE concatenateErrorTables
1930: ( p_error_Tbl1 IN BIS_UTILITIES_PUB.Error_Tbl_Type
1931: , p_error_Tbl2 IN BIS_UTILITIES_PUB.Error_Tbl_Type
1932: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1933: )
1934: IS
1935: --
1936: l_ind NUMBER;

Line 1982: IF(p_date = BIS_UTILITIES_PUB.G_NULL_DATE) THEN

1978: )
1979: RETURN DATE
1980: IS
1981: BEGIN
1982: IF(p_date = BIS_UTILITIES_PUB.G_NULL_DATE) THEN
1983: RETURN NULL;
1984: ELSE
1985: RETURN p_date;
1986: END IF;

Line 2272: if (BIS_UTILITIES_PUB.Value_Missing(p_id) = FND_API.G_TRUE

2268: return VARCHAR2
2269: is
2270: BEGIN
2271:
2272: if (BIS_UTILITIES_PUB.Value_Missing(p_id) = FND_API.G_TRUE
2273: OR BIS_UTILITIES_PUB.Value_NULL(p_id) = FND_API.G_TRUE) then
2274: -- id is not there
2275:
2276: if ((BIS_UTILITIES_PUB.Value_Missing(p_short_name) = FND_API.G_TRUE

Line 2273: OR BIS_UTILITIES_PUB.Value_NULL(p_id) = FND_API.G_TRUE) then

2269: is
2270: BEGIN
2271:
2272: if (BIS_UTILITIES_PUB.Value_Missing(p_id) = FND_API.G_TRUE
2273: OR BIS_UTILITIES_PUB.Value_NULL(p_id) = FND_API.G_TRUE) then
2274: -- id is not there
2275:
2276: if ((BIS_UTILITIES_PUB.Value_Missing(p_short_name) = FND_API.G_TRUE
2277: OR BIS_UTILITIES_PUB.Value_NULL(p_short_name)= FND_API.G_TRUE)

Line 2276: if ((BIS_UTILITIES_PUB.Value_Missing(p_short_name) = FND_API.G_TRUE

2272: if (BIS_UTILITIES_PUB.Value_Missing(p_id) = FND_API.G_TRUE
2273: OR BIS_UTILITIES_PUB.Value_NULL(p_id) = FND_API.G_TRUE) then
2274: -- id is not there
2275:
2276: if ((BIS_UTILITIES_PUB.Value_Missing(p_short_name) = FND_API.G_TRUE
2277: OR BIS_UTILITIES_PUB.Value_NULL(p_short_name)= FND_API.G_TRUE)
2278: AND (BIS_UTILITIES_PUB.Value_Missing(p_name) = FND_API.G_TRUE
2279: OR BIS_UTILITIES_PUB.Value_NULL(p_name) = FND_API.G_TRUE))
2280: then

Line 2277: OR BIS_UTILITIES_PUB.Value_NULL(p_short_name)= FND_API.G_TRUE)

2273: OR BIS_UTILITIES_PUB.Value_NULL(p_id) = FND_API.G_TRUE) then
2274: -- id is not there
2275:
2276: if ((BIS_UTILITIES_PUB.Value_Missing(p_short_name) = FND_API.G_TRUE
2277: OR BIS_UTILITIES_PUB.Value_NULL(p_short_name)= FND_API.G_TRUE)
2278: AND (BIS_UTILITIES_PUB.Value_Missing(p_name) = FND_API.G_TRUE
2279: OR BIS_UTILITIES_PUB.Value_NULL(p_name) = FND_API.G_TRUE))
2280: then
2281: return FND_API.G_FALSE;

Line 2278: AND (BIS_UTILITIES_PUB.Value_Missing(p_name) = FND_API.G_TRUE

2274: -- id is not there
2275:
2276: if ((BIS_UTILITIES_PUB.Value_Missing(p_short_name) = FND_API.G_TRUE
2277: OR BIS_UTILITIES_PUB.Value_NULL(p_short_name)= FND_API.G_TRUE)
2278: AND (BIS_UTILITIES_PUB.Value_Missing(p_name) = FND_API.G_TRUE
2279: OR BIS_UTILITIES_PUB.Value_NULL(p_name) = FND_API.G_TRUE))
2280: then
2281: return FND_API.G_FALSE;
2282: else

Line 2279: OR BIS_UTILITIES_PUB.Value_NULL(p_name) = FND_API.G_TRUE))

2275:
2276: if ((BIS_UTILITIES_PUB.Value_Missing(p_short_name) = FND_API.G_TRUE
2277: OR BIS_UTILITIES_PUB.Value_NULL(p_short_name)= FND_API.G_TRUE)
2278: AND (BIS_UTILITIES_PUB.Value_Missing(p_name) = FND_API.G_TRUE
2279: OR BIS_UTILITIES_PUB.Value_NULL(p_name) = FND_API.G_TRUE))
2280: then
2281: return FND_API.G_FALSE;
2282: else
2283: return FND_API.G_TRUE;

Line 2318: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2314:
2315: l_temp_Target_Level_tbl BIS_Target_LEVEL_PUB.Target_Level_Tbl_Type;
2316: l_Target_Level_Tbl Target_level_Tbl_Type;
2317: l_return_status VARCHAR2(1000);
2318: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2319:
2320: BEGIN
2321:
2322: BIS_Target_LEVEL_PUB.Retrieve_User_Target_Levels

Line 2361: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2357: IS
2358:
2359: l_Target_Level_tbl BIS_Target_LEVEL_PUB.Target_Level_Tbl_Type;
2360: l_return_status VARCHAR2(1000);
2361: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2362: l_perf_measure_tbl perf_measure_tbl_Type;
2363:
2364: BEGIN
2365:

Line 2571: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE

2567: PROCEDURE resequence_dim_level_values
2568: (p_dim_values_rec IN BIS_TARGET_PUB.TARGET_REC_TYPE
2569: ,p_sequence_dir IN VARCHAR2
2570: ,x_dim_values_rec IN OUT NOCOPY BIS_TARGET_PUB.TARGET_REC_TYPE
2571: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE
2572: )
2573: IS
2574: CURSOR c_seq(p_targetlevel_id in NUMBER, p_dim IN VARCHAR2) IS
2575: SELECT x.sequence_no

Line 2784: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE

2780: PROCEDURE resequence_dim_levels
2781: (p_dim_level_rec IN BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE
2782: ,p_sequence_dir IN VARCHAR2
2783: ,x_dim_level_rec IN OUT NOCOPY BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE
2784: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE
2785: )
2786: IS
2787: CURSOR c_seq(p_targetlevel_id in NUMBER, p_dim IN VARCHAR2) IS
2788: SELECT x.sequence_no

Line 2978: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE

2974: PROCEDURE reseq_actual_dim_level_values
2975: (p_dim_values_Rec IN BIS_ACTUAL_PUB.Actual_rec_type
2976: ,p_Sequence_dir IN VARCHAR2
2977: ,x_dim_values_rec IN OUT NOCOPY BIS_ACTUAL_PUB.Actual_rec_type
2978: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE
2979: )
2980: IS
2981: CURSOR c_seq(p_targetlevel_id in NUMBER, p_dim IN VARCHAR2) IS
2982: SELECT x.sequence_no

Line 3078: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE

3074: PROCEDURE reseq_ind_dim_level_values
3075: (p_dim_values_Rec IN BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type
3076: ,p_Sequence_dir IN VARCHAR2
3077: ,x_dim_values_rec IN OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type
3078: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.ERROR_TBL_TYPE
3079: )
3080: IS
3081: CURSOR c_seq(p_targetlevel_id in NUMBER, p_dim IN VARCHAR2) IS
3082: SELECT x.sequence_no

Line 3270: BIS_UTILITIES_PUB.put_line(p_text => ' GET_SOURCE_FROM_DIM_LEVEL Error 0100 ' || sqlerrm ) ;

3266: RETURN l_source;
3267:
3268: EXCEPTION
3269: when others then
3270: BIS_UTILITIES_PUB.put_line(p_text => ' GET_SOURCE_FROM_DIM_LEVEL Error 0100 ' || sqlerrm ) ;
3271: END GET_SOURCE_FROM_DIM_LEVEL;
3272:
3273: --
3274:

Line 3466: -- BIS_UTILITIES_PUB.put_line(p_text => ' l_dim_short_name = ' || l_dim_short_name ) ;

3462: x_dimension_short_name => l_dim_short_name,
3463: x_return_status => l_return_status,
3464: x_return_msg => l_return_msg);
3465:
3466: -- BIS_UTILITIES_PUB.put_line(p_text => ' l_dim_short_name = ' || l_dim_short_name ) ;
3467: RETURN l_dim_short_name ; -- 'EDW_ORGANIZATION_M';
3468:
3469: END IF;
3470: IF (l_Source = 'OLTP')

Line 3543: BIS_UTILITIES_PUB.put_line(p_text =>' Error in bisvutlb.get_org_dimension_name_tl_edw ' || l_err_track || sqlerrm);

3539: l_err_track := 200;
3540:
3541: EXCEPTION
3542: WHEN OTHERS THEN
3543: BIS_UTILITIES_PUB.put_line(p_text =>' Error in bisvutlb.get_org_dimension_name_tl_edw ' || l_err_track || sqlerrm);
3544: x_return_status := FND_API.G_RET_STS_ERROR;
3545: END get_org_dim_name_tl_edw;
3546:
3547: --

Line 3631: -- BIS_UTILITIES_PUB.put_line(p_text =>'Dimensional Cut : ' || l_dimlevel_cut );

3627: IF (l_source = 'EDW') THEN
3628:
3629: l_dimlevel_cut := substr(p_dim_level_short_name,(l_length-1),2 );
3630: --bug#2252888
3631: -- BIS_UTILITIES_PUB.put_line(p_text =>'Dimensional Cut : ' || l_dimlevel_cut );
3632:
3633: if l_dimlevel_cut = '_A' then
3634:
3635: l_is_total := TRUE;

Line 3856: -- BIS_UTILITIES_PUB.put_line(p_text => ' Inside get_time_from ' );

3852:
3853:
3854: BEGIN
3855:
3856: -- BIS_UTILITIES_PUB.put_line(p_text => ' Inside get_time_from ' );
3857:
3858: l_source := bis_utilities_pvt.GET_SOURCE_FROM_DIM_LEVEL
3859: (
3860: p_DimLevelId => p_time_level_id

Line 3864: BIS_UTILITIES_PUB.put_line(p_text =>' Source is '|| l_source );

3860: p_DimLevelId => p_time_level_id
3861: , p_DimLevelShortName => p_time_level_sh_name -- l_level_name
3862: );
3863:
3864: BIS_UTILITIES_PUB.put_line(p_text =>' Source is '|| l_source );
3865:
3866:
3867: if ( l_source = 'OLTP' ) then
3868: bis_utilities_pvt.Get_Org_Info_Based_On_Source

Line 3879: BIS_UTILITIES_PUB.put_line(p_text => ' ERROR: GET_TIME_FROM : source can be only either OLTP or EDW ' );

3875: elsif ( l_source = 'EDW') then
3876: l_org_level_id := p_org_level_id;
3877: l_org_level_short_name := p_org_level_short_name;
3878: elsif ( l_source <> 'EDW') then
3879: BIS_UTILITIES_PUB.put_line(p_text => ' ERROR: GET_TIME_FROM : source can be only either OLTP or EDW ' );
3880: end if;
3881:
3882:
3883: -- bis_utilities_pvt.

Line 3944: BIS_UTILITIES_PUB.put_line(p_text => ' Time from = ' || l_time_value );

3940: end if;
3941:
3942:
3943: -- v_from := l_time_value;
3944: BIS_UTILITIES_PUB.put_line(p_text => ' Time from = ' || l_time_value );
3945:
3946: return l_time_value;
3947:
3948:

Line 3951: BIS_UTILITIES_PUB.put_line(p_text =>'GET_TIME_FROM : SQL Statement is '|| l_selectStmt);

3947:
3948:
3949: Exception
3950: when others then
3951: BIS_UTILITIES_PUB.put_line(p_text =>'GET_TIME_FROM : SQL Statement is '|| l_selectStmt);
3952: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Procedure BIS_UTILITIES_PVT.GET_TIME_FROM 1000 : '||sqlerrm);
3953:
3954: END GET_TIME_FROM;
3955:

Line 3952: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Procedure BIS_UTILITIES_PVT.GET_TIME_FROM 1000 : '||sqlerrm);

3948:
3949: Exception
3950: when others then
3951: BIS_UTILITIES_PUB.put_line(p_text =>'GET_TIME_FROM : SQL Statement is '|| l_selectStmt);
3952: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Procedure BIS_UTILITIES_PVT.GET_TIME_FROM 1000 : '||sqlerrm);
3953:
3954: END GET_TIME_FROM;
3955:
3956:

Line 3999: -- BIS_UTILITIES_PUB.put_line(p_text => ' Inside get_time_to ' );

3995: l_max_end_date DATE;
3996:
3997: BEGIN
3998:
3999: -- BIS_UTILITIES_PUB.put_line(p_text => ' Inside get_time_to ' );
4000:
4001: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_id ' || p_id ) ;
4002: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_id_col_name ' || p_id_col_name ) ;
4003: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_value_col_name ' || p_value_col_name ) ;

Line 4001: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_id ' || p_id ) ;

3997: BEGIN
3998:
3999: -- BIS_UTILITIES_PUB.put_line(p_text => ' Inside get_time_to ' );
4000:
4001: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_id ' || p_id ) ;
4002: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_id_col_name ' || p_id_col_name ) ;
4003: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_value_col_name ' || p_value_col_name ) ;
4004:
4005:

Line 4002: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_id_col_name ' || p_id_col_name ) ;

3998:
3999: -- BIS_UTILITIES_PUB.put_line(p_text => ' Inside get_time_to ' );
4000:
4001: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_id ' || p_id ) ;
4002: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_id_col_name ' || p_id_col_name ) ;
4003: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_value_col_name ' || p_value_col_name ) ;
4004:
4005:
4006: l_source := bis_utilities_pvt.GET_SOURCE_FROM_DIM_LEVEL

Line 4003: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_value_col_name ' || p_value_col_name ) ;

3999: -- BIS_UTILITIES_PUB.put_line(p_text => ' Inside get_time_to ' );
4000:
4001: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_id ' || p_id ) ;
4002: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_id_col_name ' || p_id_col_name ) ;
4003: -- BIS_UTILITIES_PUB.put_line(p_text => ' p_value_col_name ' || p_value_col_name ) ;
4004:
4005:
4006: l_source := bis_utilities_pvt.GET_SOURCE_FROM_DIM_LEVEL
4007: (

Line 4025: BIS_UTILITIES_PUB.put_line(p_text => ' ERROR: GET_TIME_TO : source can be only either OLTP or EDW ' );

4021: elsif ( l_source = 'EDW') then
4022: l_org_level_id := p_org_level_id;
4023: l_org_level_short_name := p_org_level_short_name;
4024: elsif ( l_source <> 'EDW') then
4025: BIS_UTILITIES_PUB.put_line(p_text => ' ERROR: GET_TIME_TO : source can be only either OLTP or EDW ' );
4026: end if;
4027:
4028: BIS_UTILITIES_PUB.put_line(p_text =>' Source is '|| l_source );
4029:

Line 4028: BIS_UTILITIES_PUB.put_line(p_text =>' Source is '|| l_source );

4024: elsif ( l_source <> 'EDW') then
4025: BIS_UTILITIES_PUB.put_line(p_text => ' ERROR: GET_TIME_TO : source can be only either OLTP or EDW ' );
4026: end if;
4027:
4028: BIS_UTILITIES_PUB.put_line(p_text =>' Source is '|| l_source );
4029:
4030:
4031:
4032: bis_utilities_pvt.Get_Start_End_Dates

Line 4090: BIS_UTILITIES_PUB.put_line(p_text => ' Time to = ' || l_time_value );

4086: end if;
4087:
4088:
4089: -- v_from := l_time_value;
4090: BIS_UTILITIES_PUB.put_line(p_text => ' Time to = ' || l_time_value );
4091:
4092: return l_time_value;
4093:
4094:

Line 4097: BIS_UTILITIES_PUB.put_line(p_text => ' l_selectStmt is : ' || l_selectStmt);

4093:
4094:
4095: Exception
4096: when others then
4097: BIS_UTILITIES_PUB.put_line(p_text => ' l_selectStmt is : ' || l_selectStmt);
4098: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Procedure BIS_UTILITIES_PVT.GET_TIME_TO : '||sqlerrm);
4099:
4100: END GET_TIME_TO;
4101:

Line 4098: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Procedure BIS_UTILITIES_PVT.GET_TIME_TO : '||sqlerrm);

4094:
4095: Exception
4096: when others then
4097: BIS_UTILITIES_PUB.put_line(p_text => ' l_selectStmt is : ' || l_selectStmt);
4098: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Procedure BIS_UTILITIES_PVT.GET_TIME_TO : '||sqlerrm);
4099:
4100: END GET_TIME_TO;
4101:
4102:

Line 4123: if ( bis_utilities_pub.value_not_missing ( p_org_level_id ) = FND_API.G_TRUE ) then

4119: BEGIN
4120:
4121: if ( p_source = 'OLTP' ) then
4122:
4123: if ( bis_utilities_pub.value_not_missing ( p_org_level_id ) = FND_API.G_TRUE ) then
4124: l_Org_Level_Id := p_Org_Level_Id;
4125: else
4126: -- BIS_UTILITIES_PUB.put_line(p_text =>' org level id is missing ');
4127: l_Org_Level_Id := null;

Line 4126: -- BIS_UTILITIES_PUB.put_line(p_text =>' org level id is missing ');

4122:
4123: if ( bis_utilities_pub.value_not_missing ( p_org_level_id ) = FND_API.G_TRUE ) then
4124: l_Org_Level_Id := p_Org_Level_Id;
4125: else
4126: -- BIS_UTILITIES_PUB.put_line(p_text =>' org level id is missing ');
4127: l_Org_Level_Id := null;
4128: end if;
4129:
4130: if ( bis_utilities_pub.value_not_missing ( p_org_level_short_name ) = FND_API.G_TRUE ) then

Line 4130: if ( bis_utilities_pub.value_not_missing ( p_org_level_short_name ) = FND_API.G_TRUE ) then

4126: -- BIS_UTILITIES_PUB.put_line(p_text =>' org level id is missing ');
4127: l_Org_Level_Id := null;
4128: end if;
4129:
4130: if ( bis_utilities_pub.value_not_missing ( p_org_level_short_name ) = FND_API.G_TRUE ) then
4131: l_org_level_short_name := p_org_level_short_name;
4132: else
4133: -- BIS_UTILITIES_PUB.put_line(p_text =>' org level short name is missing ');
4134: l_org_level_short_name := null;

Line 4133: -- BIS_UTILITIES_PUB.put_line(p_text =>' org level short name is missing ');

4129:
4130: if ( bis_utilities_pub.value_not_missing ( p_org_level_short_name ) = FND_API.G_TRUE ) then
4131: l_org_level_short_name := p_org_level_short_name;
4132: else
4133: -- BIS_UTILITIES_PUB.put_line(p_text =>' org level short name is missing ');
4134: l_org_level_short_name := null;
4135: end if;
4136:
4137: x_org_level_id := l_org_level_id;

Line 4145: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Org_Info_Based_On_Source 0100: '||sqlerrm);

4141:
4142: Exception
4143:
4144: when others then
4145: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Org_Info_Based_On_Source 0100: '||sqlerrm);
4146:
4147: END Get_Org_Info_Based_On_Source;
4148:
4149:

Line 4186: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value_ID_Minus 0100: '||sqlerrm);

4182:
4183: Exception
4184:
4185: when others then
4186: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value_ID_Minus 0100: '||sqlerrm);
4187:
4188: END Get_Time_Level_Value_ID_Minus;
4189:
4190: Procedure Get_Time_Level_Value_ID_Date -- where target_date is between start and end dates..

Line 4225: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ;

4221: OPEN c_dim_lvl_sn(cp_lvl_values_view => p_view_name ) ;
4222: FETCH c_dim_lvl_sn INTO l_short_name;
4223: CLOSE c_dim_lvl_sn;
4224:
4225: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ;
4226: IF (l_short_name IS NOT NULL AND l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN
4227: l_is_dep_on_org := TRUE;
4228: END IF;
4229:

Line 4226: IF (l_short_name IS NOT NULL AND l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN

4222: FETCH c_dim_lvl_sn INTO l_short_name;
4223: CLOSE c_dim_lvl_sn;
4224:
4225: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ;
4226: IF (l_short_name IS NOT NULL AND l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN
4227: l_is_dep_on_org := TRUE;
4228: END IF;
4229:
4230:

Line 4269: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );

4265: WHEN OTHERS THEN
4266: if l1_cursor%isopen then
4267: close l1_cursor;
4268: end if;
4269: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );
4270: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value_ID_Date 0100: '||sqlerrm);
4271: END;
4272: elsif p_source = 'OLTP' then
4273:

Line 4270: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value_ID_Date 0100: '||sqlerrm);

4266: if l1_cursor%isopen then
4267: close l1_cursor;
4268: end if;
4269: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );
4270: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value_ID_Date 0100: '||sqlerrm);
4271: END;
4272: elsif p_source = 'OLTP' then
4273:
4274: IF (l_is_dep_on_org) THEN --2684911

Line 4298: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );

4294: EXECUTE IMMEDIATE l_sql INTO l_time_id using p_target_date;
4295: END IF;
4296: EXCEPTION
4297: WHEN OTHERS THEN
4298: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );
4299: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value_ID_Date 0200: '||sqlerrm);
4300: END;
4301: end if;
4302: x_time_id := l_time_id;

Line 4299: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value_ID_Date 0200: '||sqlerrm);

4295: END IF;
4296: EXCEPTION
4297: WHEN OTHERS THEN
4298: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );
4299: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value_ID_Date 0200: '||sqlerrm);
4300: END;
4301: end if;
4302: x_time_id := l_time_id;
4303: Exception

Line 4305: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );

4301: end if;
4302: x_time_id := l_time_id;
4303: Exception
4304: when others then
4305: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );
4306: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value_ID_Date 0300: '||sqlerrm);
4307: IF (c_dim_lvl_sn%ISOPEN) THEN
4308: CLOSE c_dim_lvl_sn;
4309: END IF;

Line 4306: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value_ID_Date 0300: '||sqlerrm);

4302: x_time_id := l_time_id;
4303: Exception
4304: when others then
4305: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );
4306: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value_ID_Date 0300: '||sqlerrm);
4307: IF (c_dim_lvl_sn%ISOPEN) THEN
4308: CLOSE c_dim_lvl_sn;
4309: END IF;
4310: END Get_Time_Level_Value_ID_Date;

Line 4354: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ;

4350: OPEN c_dim_lvl_sn(cp_lvl_values_view => p_table_name ) ;
4351: FETCH c_dim_lvl_sn INTO l_short_name;
4352: CLOSE c_dim_lvl_sn;
4353:
4354: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ;
4355: IF (l_short_name IS NOT NULL AND l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN
4356: l_is_dep_on_org := TRUE;
4357: END IF;
4358:

Line 4355: IF (l_short_name IS NOT NULL AND l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN

4351: FETCH c_dim_lvl_sn INTO l_short_name;
4352: CLOSE c_dim_lvl_sn;
4353:
4354: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ;
4355: IF (l_short_name IS NOT NULL AND l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN
4356: l_is_dep_on_org := TRUE;
4357: END IF;
4358:
4359: if p_source = 'EDW' then

Line 4372: BIS_UTILITIES_PUB.put_line(p_text =>' Error Get_Time_Level_Value 0100: p_flag can be either START, END or BOTH, flag is ' || p_flag );

4368: l_selectStmt := l_selectStmt || ' WHERE START_DATE = :l_date ';
4369: elsif (p_flag = 'END') then
4370: l_selectStmt := l_selectStmt || ' WHERE END_DATE = :l_date ';
4371: else
4372: BIS_UTILITIES_PUB.put_line(p_text =>' Error Get_Time_Level_Value 0100: p_flag can be either START, END or BOTH, flag is ' || p_flag );
4373: end if;
4374:
4375: IF (l_is_dep_on_org) THEN --2684911
4376: l_selectStmt := l_selectStmt ||

Line 4410: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );

4406: CLOSE l1_cursor;
4407:
4408:
4409: if v_value2 is null then
4410: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );
4411: BIS_UTILITIES_PUB.put_line(p_text =>' Date is ' || p_date );
4412: end if;
4413:
4414:

Line 4411: BIS_UTILITIES_PUB.put_line(p_text =>' Date is ' || p_date );

4407:
4408:
4409: if v_value2 is null then
4410: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );
4411: BIS_UTILITIES_PUB.put_line(p_text =>' Date is ' || p_date );
4412: end if;
4413:
4414:
4415: EXCEPTION

Line 4424: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );

4420: end if;
4421:
4422: v_value2 := null;
4423:
4424: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );
4425: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value 0200: '||sqlerrm);
4426:
4427: END;
4428:

Line 4425: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value 0200: '||sqlerrm);

4421:
4422: v_value2 := null;
4423:
4424: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );
4425: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value 0200: '||sqlerrm);
4426:
4427: END;
4428:
4429:

Line 4443: BIS_UTILITIES_PUB.put_line(p_text =>' Error Get_Time_Level_Value: p_flag can be either START, END or BOTH, flag is ' || p_flag );

4439: l_selectStmt := l_selectStmt || ' WHERE START_DATE = :l_date ';
4440: elsif (p_flag = 'END') then
4441: l_selectStmt := l_selectStmt || ' WHERE END_DATE = :l_date ';
4442: else
4443: BIS_UTILITIES_PUB.put_line(p_text =>' Error Get_Time_Level_Value: p_flag can be either START, END or BOTH, flag is ' || p_flag );
4444: end if;
4445:
4446: IF (l_is_dep_on_org) THEN --2684911
4447: l_selectStmt := l_selectStmt ||

Line 4478: -- BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );

4474: Exception
4475: when others then
4476: v_value2 := null;
4477:
4478: -- BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );
4479: -- BIS_UTILITIES_PUB.put_line(p_text => ' l_date = ' || p_date );
4480: -- BIS_UTILITIES_PUB.put_line(p_text => ' flag = ' || p_flag );
4481: -- BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value 0300: '||sqlerrm);
4482:

Line 4479: -- BIS_UTILITIES_PUB.put_line(p_text => ' l_date = ' || p_date );

4475: when others then
4476: v_value2 := null;
4477:
4478: -- BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );
4479: -- BIS_UTILITIES_PUB.put_line(p_text => ' l_date = ' || p_date );
4480: -- BIS_UTILITIES_PUB.put_line(p_text => ' flag = ' || p_flag );
4481: -- BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value 0300: '||sqlerrm);
4482:
4483: End;

Line 4480: -- BIS_UTILITIES_PUB.put_line(p_text => ' flag = ' || p_flag );

4476: v_value2 := null;
4477:
4478: -- BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );
4479: -- BIS_UTILITIES_PUB.put_line(p_text => ' l_date = ' || p_date );
4480: -- BIS_UTILITIES_PUB.put_line(p_text => ' flag = ' || p_flag );
4481: -- BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value 0300: '||sqlerrm);
4482:
4483: End;
4484:

Line 4481: -- BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value 0300: '||sqlerrm);

4477:
4478: -- BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );
4479: -- BIS_UTILITIES_PUB.put_line(p_text => ' l_date = ' || p_date );
4480: -- BIS_UTILITIES_PUB.put_line(p_text => ' flag = ' || p_flag );
4481: -- BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value 0300: '||sqlerrm);
4482:
4483: End;
4484:
4485: end if;

Line 4493: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );

4489:
4490: Exception
4491:
4492: when others then
4493: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );
4494: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value 0400: '||sqlerrm);
4495: IF (c_dim_lvl_sn%ISOPEN) THEN
4496: CLOSE c_dim_lvl_sn;
4497: END IF;

Line 4494: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value 0400: '||sqlerrm);

4490: Exception
4491:
4492: when others then
4493: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );
4494: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Time_Level_Value 0400: '||sqlerrm);
4495: IF (c_dim_lvl_sn%ISOPEN) THEN
4496: CLOSE c_dim_lvl_sn;
4497: END IF;
4498:

Line 4546: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ;

4542: OPEN c_dim_lvl_sn(cp_lvl_values_view => p_view_name ) ;
4543: FETCH c_dim_lvl_sn INTO l_short_name;
4544: CLOSE c_dim_lvl_sn;
4545:
4546: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ;
4547: IF (l_short_name IS NOT NULL AND l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN
4548: l_is_dep_on_org := TRUE;
4549: END IF;
4550:

Line 4547: IF (l_short_name IS NOT NULL AND l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN

4543: FETCH c_dim_lvl_sn INTO l_short_name;
4544: CLOSE c_dim_lvl_sn;
4545:
4546: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ;
4547: IF (l_short_name IS NOT NULL AND l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN
4548: l_is_dep_on_org := TRUE;
4549: END IF;
4550:
4551: if p_source = 'EDW' then

Line 4583: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );

4579: FETCH l1_cursor INTO l_start_date, l_end_date;
4580: CLOSE l1_cursor;
4581:
4582: if l_start_date is null then
4583: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );
4584: BIS_UTILITIES_PUB.put_line(p_text =>' Date is ' || p_id_value_name );
4585: end if;
4586:
4587: EXCEPTION

Line 4584: BIS_UTILITIES_PUB.put_line(p_text =>' Date is ' || p_id_value_name );

4580: CLOSE l1_cursor;
4581:
4582: if l_start_date is null then
4583: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );
4584: BIS_UTILITIES_PUB.put_line(p_text =>' Date is ' || p_id_value_name );
4585: end if;
4586:
4587: EXCEPTION
4588:

Line 4594: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );

4590: if l1_cursor%isopen then
4591: close l1_cursor;
4592: end if;
4593:
4594: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );
4595: BIS_UTILITIES_PUB.put_line(p_text => ' ID is ' || p_id_value_name );
4596: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Start_End_Dates 0100: '||sqlerrm);
4597:
4598: END;

Line 4595: BIS_UTILITIES_PUB.put_line(p_text => ' ID is ' || p_id_value_name );

4591: close l1_cursor;
4592: end if;
4593:
4594: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );
4595: BIS_UTILITIES_PUB.put_line(p_text => ' ID is ' || p_id_value_name );
4596: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Start_End_Dates 0100: '||sqlerrm);
4597:
4598: END;
4599:

Line 4596: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Start_End_Dates 0100: '||sqlerrm);

4592: end if;
4593:
4594: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );
4595: BIS_UTILITIES_PUB.put_line(p_text => ' ID is ' || p_id_value_name );
4596: BIS_UTILITIES_PUB.put_line(p_text =>'Exception executing sql in Get_Start_End_Dates 0100: '||sqlerrm);
4597:
4598: END;
4599:
4600: elsif p_source = 'OLTP' then -- and substr(l_short_name, 1, 2) <> 'HR' then

Line 4626: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );

4622: END IF;
4623:
4624: Exception
4625: when others then
4626: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );
4627: BIS_UTILITIES_PUB.put_line(p_text => ' ID is ' || p_id_value_name );
4628: BIS_UTILITIES_PUB.put_line(p_text =>' Get_Start_End_Dates 0200: Error finding Start date, End date '||sqlerrm);
4629:
4630: end;

Line 4627: BIS_UTILITIES_PUB.put_line(p_text => ' ID is ' || p_id_value_name );

4623:
4624: Exception
4625: when others then
4626: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );
4627: BIS_UTILITIES_PUB.put_line(p_text => ' ID is ' || p_id_value_name );
4628: BIS_UTILITIES_PUB.put_line(p_text =>' Get_Start_End_Dates 0200: Error finding Start date, End date '||sqlerrm);
4629:
4630: end;
4631:

Line 4628: BIS_UTILITIES_PUB.put_line(p_text =>' Get_Start_End_Dates 0200: Error finding Start date, End date '||sqlerrm);

4624: Exception
4625: when others then
4626: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_sql );
4627: BIS_UTILITIES_PUB.put_line(p_text => ' ID is ' || p_id_value_name );
4628: BIS_UTILITIES_PUB.put_line(p_text =>' Get_Start_End_Dates 0200: Error finding Start date, End date '||sqlerrm);
4629:
4630: end;
4631:
4632: end if;

Line 4640: BIS_UTILITIES_PUB.put_line(p_text => ' SQL is ' || l_sql );

4636:
4637: Exception
4638:
4639: when others then
4640: BIS_UTILITIES_PUB.put_line(p_text => ' SQL is ' || l_sql );
4641: -- BIS_UTILITIES_PUB.put_line(p_text => ' l_date = ' || p_date );
4642: BIS_UTILITIES_PUB.put_line(p_text => ' Exception executing sql in Get_Start_End_Dates 0300: '||sqlerrm);
4643: IF (c_dim_lvl_sn%ISOPEN) THEN
4644: CLOSE c_dim_lvl_sn;

Line 4641: -- BIS_UTILITIES_PUB.put_line(p_text => ' l_date = ' || p_date );

4637: Exception
4638:
4639: when others then
4640: BIS_UTILITIES_PUB.put_line(p_text => ' SQL is ' || l_sql );
4641: -- BIS_UTILITIES_PUB.put_line(p_text => ' l_date = ' || p_date );
4642: BIS_UTILITIES_PUB.put_line(p_text => ' Exception executing sql in Get_Start_End_Dates 0300: '||sqlerrm);
4643: IF (c_dim_lvl_sn%ISOPEN) THEN
4644: CLOSE c_dim_lvl_sn;
4645: END IF;

Line 4642: BIS_UTILITIES_PUB.put_line(p_text => ' Exception executing sql in Get_Start_End_Dates 0300: '||sqlerrm);

4638:
4639: when others then
4640: BIS_UTILITIES_PUB.put_line(p_text => ' SQL is ' || l_sql );
4641: -- BIS_UTILITIES_PUB.put_line(p_text => ' l_date = ' || p_date );
4642: BIS_UTILITIES_PUB.put_line(p_text => ' Exception executing sql in Get_Start_End_Dates 0300: '||sqlerrm);
4643: IF (c_dim_lvl_sn%ISOPEN) THEN
4644: CLOSE c_dim_lvl_sn;
4645: END IF;
4646:

Line 4688: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ;

4684: OPEN c_dim_lvl_sn(cp_lvl_values_view => p_view_name ) ;
4685: FETCH c_dim_lvl_sn INTO l_short_name;
4686: CLOSE c_dim_lvl_sn;
4687:
4688: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ;
4689: IF (l_short_name IS NOT NULL AND l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN
4690: l_is_dep_on_org := TRUE;
4691: END IF;
4692:

Line 4689: IF (l_short_name IS NOT NULL AND l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN

4685: FETCH c_dim_lvl_sn INTO l_short_name;
4686: CLOSE c_dim_lvl_sn;
4687:
4688: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ;
4689: IF (l_short_name IS NOT NULL AND l_time_lvl_dep_on_org = BIS_UTILITIES_PUB.G_TIME_IS_DEPEN_ON_ORG) THEN
4690: l_is_dep_on_org := TRUE;
4691: END IF;
4692:
4693: if p_source = 'EDW' then

Line 4714: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );

4710: FETCH l_cursor INTO l_min_start_date, l_max_end_date;
4711: CLOSE l_cursor;
4712:
4713: if l_min_start_date is null then
4714: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );
4715: BIS_UTILITIES_PUB.put_line(p_text =>' min start date is ' || l_min_start_date );
4716: end if;
4717:
4718: exception

Line 4715: BIS_UTILITIES_PUB.put_line(p_text =>' min start date is ' || l_min_start_date );

4711: CLOSE l_cursor;
4712:
4713: if l_min_start_date is null then
4714: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );
4715: BIS_UTILITIES_PUB.put_line(p_text =>' min start date is ' || l_min_start_date );
4716: end if;
4717:
4718: exception
4719: when others then

Line 4725: BIS_UTILITIES_PUB.put_line(p_text => ' l_selectStmt is : ' || l_selectStmt);

4721: if l_cursor%isopen then
4722: close l_cursor;
4723: end if;
4724:
4725: BIS_UTILITIES_PUB.put_line(p_text => ' l_selectStmt is : ' || l_selectStmt);
4726: BIS_UTILITIES_PUB.put_line(p_text => ' Error Get_Min_Max_Start_End_Dates 100 : ' || sqlerrm );
4727: end;
4728:
4729: elsif p_source = 'OLTP' then

Line 4726: BIS_UTILITIES_PUB.put_line(p_text => ' Error Get_Min_Max_Start_End_Dates 100 : ' || sqlerrm );

4722: close l_cursor;
4723: end if;
4724:
4725: BIS_UTILITIES_PUB.put_line(p_text => ' l_selectStmt is : ' || l_selectStmt);
4726: BIS_UTILITIES_PUB.put_line(p_text => ' Error Get_Min_Max_Start_End_Dates 100 : ' || sqlerrm );
4727: end;
4728:
4729: elsif p_source = 'OLTP' then
4730:

Line 4750: -- BIS_UTILITIES_PUB.put_line(p_text => ' V end date ' || v_end_date ) ;

4746: USING l_star, p_Org_Level_ID, l_star, l_star, p_Org_Level_Short_name, l_star;
4747: ELSE
4748: EXECUTE IMMEDIATE l_selectStmt INTO l_min_start_date, l_max_end_date;
4749: END IF;
4750: -- BIS_UTILITIES_PUB.put_line(p_text => ' V end date ' || v_end_date ) ;
4751:
4752: exception
4753: when others then
4754: BIS_UTILITIES_PUB.put_line(p_text => ' l_selectStmt is : ' || l_selectStmt);

Line 4754: BIS_UTILITIES_PUB.put_line(p_text => ' l_selectStmt is : ' || l_selectStmt);

4750: -- BIS_UTILITIES_PUB.put_line(p_text => ' V end date ' || v_end_date ) ;
4751:
4752: exception
4753: when others then
4754: BIS_UTILITIES_PUB.put_line(p_text => ' l_selectStmt is : ' || l_selectStmt);
4755: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Get_Min_Max_Start_End_Dates 200 '||sqlerrm);
4756: end;
4757:
4758: end if;

Line 4755: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Get_Min_Max_Start_End_Dates 200 '||sqlerrm);

4751:
4752: exception
4753: when others then
4754: BIS_UTILITIES_PUB.put_line(p_text => ' l_selectStmt is : ' || l_selectStmt);
4755: BIS_UTILITIES_PUB.put_line(p_text =>'Error in Get_Min_Max_Start_End_Dates 200 '||sqlerrm);
4756: end;
4757:
4758: end if;
4759:

Line 4767: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );

4763:
4764: Exception
4765:
4766: when others then
4767: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );
4768: BIS_UTILITIES_PUB.put_line(p_text =>' Exception executing sql in Get_Min_Max_Start_End_Dates 0300: '||sqlerrm);
4769: IF (c_dim_lvl_sn%ISOPEN) THEN
4770: CLOSE c_dim_lvl_sn;
4771: END IF;

Line 4768: BIS_UTILITIES_PUB.put_line(p_text =>' Exception executing sql in Get_Min_Max_Start_End_Dates 0300: '||sqlerrm);

4764: Exception
4765:
4766: when others then
4767: BIS_UTILITIES_PUB.put_line(p_text =>' SQL is ' || l_selectStmt );
4768: BIS_UTILITIES_PUB.put_line(p_text =>' Exception executing sql in Get_Min_Max_Start_End_Dates 0300: '||sqlerrm);
4769: IF (c_dim_lvl_sn%ISOPEN) THEN
4770: CLOSE c_dim_lvl_sn;
4771: END IF;
4772: END Get_Min_Max_Start_End_Dates;

Line 4791: x_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

4787:
4788: l_target_level_Tbl target_level_Tbl_Type;
4789: l_where_clause VARCHAR2(32000) := 'target_level_id in (';
4790: l_return_status VARCHAR2(200);
4791: x_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4792: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4793: begin
4794:
4795: FND_MSG_PUB.initialize;

Line 4792: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

4788: l_target_level_Tbl target_level_Tbl_Type;
4789: l_where_clause VARCHAR2(32000) := 'target_level_id in (';
4790: l_return_status VARCHAR2(200);
4791: x_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4792: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4793: begin
4794:
4795: FND_MSG_PUB.initialize;
4796:

Line 4883: x_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

4879:
4880: l_Perf_measure_Tbl Perf_Measure_Tbl_Type;
4881: l_where_clause VARCHAR2(32000) := 'measure_id in (';
4882: l_return_status VARCHAR2(200);
4883: x_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4884: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4885:
4886: begin
4887:

Line 4884: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

4880: l_Perf_measure_Tbl Perf_Measure_Tbl_Type;
4881: l_where_clause VARCHAR2(32000) := 'measure_id in (';
4882: l_return_status VARCHAR2(200);
4883: x_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4884: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4885:
4886: begin
4887:
4888: FND_MSG_PUB.initialize;

Line 5022: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in get_Roll_Period_Start_Date. ' ) ;

5018: RETURN l_start_date;
5019:
5020: EXCEPTION
5021: WHEN OTHERS THEN
5022: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in get_Roll_Period_Start_Date. ' ) ;
5023: RETURN NULL;
5024:
5025: END get_Roll_Period_Start_Date;
5026:

Line 5135: -- of debug flag (BIS_UTILITIES_PUB.G_IS_DEBUG) using set_debug_log_flag

5131:
5132:
5133: --
5134: -- Init debug log file calls get_debug_mode_profile, sets the value
5135: -- of debug flag (BIS_UTILITIES_PUB.G_IS_DEBUG) using set_debug_log_flag
5136: -- and then opens the log file using open_debug_log.
5137: --
5138: PROCEDURE init_debug_log -- 2694978
5139: ( p_file_name IN VARCHAR2

Line 5180: x_return_msg := 'Error in BIS_UTILITIES_PUB.init_debug_log : '|| SQLERRM;

5176:
5177: EXCEPTION
5178: WHEN OTHERS THEN
5179: x_return_status := FND_API.G_RET_STS_ERROR;
5180: x_return_msg := 'Error in BIS_UTILITIES_PUB.init_debug_log : '|| SQLERRM;
5181:
5182: END init_debug_log;
5183:
5184:

Line 5216: x_return_msg := 'Error in BIS_UTILITIES_PUB.init_debug_log : '|| SQLERRM;

5212:
5213: EXCEPTION
5214: WHEN OTHERS THEN
5215: x_return_status := FND_API.G_RET_STS_ERROR;
5216: x_return_msg := 'Error in BIS_UTILITIES_PUB.init_debug_log : '|| SQLERRM;
5217:
5218: END init_debug_flag;
5219:
5220:

Line 5234: l_debug_mode := NVL ( FND_PROFILE.value(BIS_UTILITIES_PUB.G_DEBUG_LOG_PROFILE) , 'N' ) ;

5230: x_return_status := FND_API.G_RET_STS_SUCCESS;
5231: x_return_msg := NULL;
5232: x_is_debug_mode := FALSE;
5233:
5234: l_debug_mode := NVL ( FND_PROFILE.value(BIS_UTILITIES_PUB.G_DEBUG_LOG_PROFILE) , 'N' ) ;
5235:
5236: IF ( l_debug_mode = 'Y') THEN
5237: x_is_debug_mode := TRUE;
5238: END IF;

Line 5265: BIS_UTILITIES_PUB.G_IS_DEBUG_ON := NVL(p_is_true, FALSE);

5261:
5262: x_return_status := FND_API.G_RET_STS_SUCCESS;
5263: x_return_msg := NULL;
5264:
5265: BIS_UTILITIES_PUB.G_IS_DEBUG_ON := NVL(p_is_true, FALSE);
5266:
5267: EXCEPTION
5268: WHEN OTHERS THEN
5269: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5280: RETURN BIS_UTILITIES_PUB.G_IS_DEBUG_ON;

5276: RETURN BOOLEAN
5277: IS
5278: BEGIN
5279:
5280: RETURN BIS_UTILITIES_PUB.G_IS_DEBUG_ON;
5281:
5282: EXCEPTION
5283: WHEN OTHERS THEN
5284: RETURN FALSE;

Line 5297: WHERE vp.name = BIS_UTILITIES_PUB.G_UTL_FILE_DIR; -- 'utl_file_dir';

5293:
5294: SELECT vp.value
5295: INTO l_default_dir_name
5296: FROM v$parameter vp
5297: WHERE vp.name = BIS_UTILITIES_PUB.G_UTL_FILE_DIR; -- 'utl_file_dir';
5298:
5299: IF (LENGTH(l_default_dir_name) > 0) THEN
5300: IF (INSTR(l_default_dir_name,',', 1, 1) > 0) THEN
5301:

Line 5421: ( BIS_UTILITIES_PUB.Value_Not_Missing(p_text) = FND_API.G_TRUE )

5417: l_is_debug_on := BIS_UTILITIES_PVT.is_debug_on;
5418:
5419: IF (l_is_debug_on) THEN
5420: IF (
5421: ( BIS_UTILITIES_PUB.Value_Not_Missing(p_text) = FND_API.G_TRUE )
5422: AND ( BIS_UTILITIES_PUB.Value_Not_Null(p_text) = FND_API.G_TRUE)
5423: ) THEN
5424: BIS_DEBUG_LOG.put(p_text => p_text);
5425: END IF;

Line 5422: AND ( BIS_UTILITIES_PUB.Value_Not_Null(p_text) = FND_API.G_TRUE)

5418:
5419: IF (l_is_debug_on) THEN
5420: IF (
5421: ( BIS_UTILITIES_PUB.Value_Not_Missing(p_text) = FND_API.G_TRUE )
5422: AND ( BIS_UTILITIES_PUB.Value_Not_Null(p_text) = FND_API.G_TRUE)
5423: ) THEN
5424: BIS_DEBUG_LOG.put(p_text => p_text);
5425: END IF;
5426: END IF;

Line 5443: ( BIS_UTILITIES_PUB.Value_Not_Missing(p_text) = FND_API.G_TRUE )

5439: l_is_debug_on := BIS_UTILITIES_PVT.is_debug_on;
5440:
5441: IF (l_is_debug_on) THEN
5442: IF (
5443: ( BIS_UTILITIES_PUB.Value_Not_Missing(p_text) = FND_API.G_TRUE )
5444: AND ( BIS_UTILITIES_PUB.Value_Not_Null(p_text) = FND_API.G_TRUE)
5445: ) THEN
5446: BIS_DEBUG_LOG.put_line(p_text => p_text);
5447: END IF;

Line 5444: AND ( BIS_UTILITIES_PUB.Value_Not_Null(p_text) = FND_API.G_TRUE)

5440:
5441: IF (l_is_debug_on) THEN
5442: IF (
5443: ( BIS_UTILITIES_PUB.Value_Not_Missing(p_text) = FND_API.G_TRUE )
5444: AND ( BIS_UTILITIES_PUB.Value_Not_Null(p_text) = FND_API.G_TRUE)
5445: ) THEN
5446: BIS_DEBUG_LOG.put_line(p_text => p_text);
5447: END IF;
5448: END IF;