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.BIL_TX_UTIL_RPT_PKG dependencies on FND_LOG

Line 103: IF chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

99: l_parameter_valid := True;
100: l_proc := 'GET_PAGE_PARAMS ';
101: l_is_number := TRUE;
102:
103: IF chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
104: writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
105: p_module => g_pkg || l_proc || 'begin',
106: p_msg => 'Start of Procedure '||l_proc);
107: END IF;

Line 104: writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

100: l_proc := 'GET_PAGE_PARAMS ';
101: l_is_number := TRUE;
102:
103: IF chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
104: writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
105: p_module => g_pkg || l_proc || 'begin',
106: p_msg => 'Start of Procedure '||l_proc);
107: END IF;
108:

Line 446: IF chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

442:
443:
444: -- Update error message and error description in the caes of null parameters
445: IF x_parameter_valid = TRUE THEN
446: IF chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
447: l_log_str := 'View by : '||x_viewby||
448: 'l_page_period_type : '||l_page_period_type||
449: 'l_currency : '||l_currency||
450: 'x_sg_id : '||x_sg_id||

Line 456: writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

452: 'x_win_probability : '||x_win_probability||
453: 'x_prodcat_id : '||x_prodcat_id;
454:
455: -- Need to modify above to capture all IDs
456: writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
457: p_module => g_pkg || l_proc || 'Params',
458: p_msg => l_log_str);
459: END IF;
460: ELSE

Line 461: IF chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

457: p_module => g_pkg || l_proc || 'Params',
458: p_msg => l_log_str);
459: END IF;
460: ELSE
461: IF chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
462: writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
463: p_module => g_pkg || l_proc || l_err_msg,
464: p_msg => l_err_desc );
465: END IF;

Line 462: writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

458: p_msg => l_log_str);
459: END IF;
460: ELSE
461: IF chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
462: writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
463: p_module => g_pkg || l_proc || l_err_msg,
464: p_msg => l_err_desc );
465: END IF;
466: END IF;

Line 498: IF chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN

494: l_err_desc := 'Please run with a valid ';
495: l_parameter_valid := True;
496: l_proc := 'GET_DETAIL_PAGE_PARAMS';
497:
498: IF chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
499: writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
500: p_module => g_pkg || l_proc || 'begin',
501: p_msg => 'Start of Procedure '||l_proc);
502: END IF;

Line 499: writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

495: l_parameter_valid := True;
496: l_proc := 'GET_DETAIL_PAGE_PARAMS';
497:
498: IF chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
499: writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
500: p_module => g_pkg || l_proc || 'begin',
501: p_msg => 'Start of Procedure '||l_proc);
502: END IF;
503:

Line 542: IF chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

538: END IF;
539: END IF;
540: -- Update error message and error description in the caes of null parameters
541: IF x_parameter_valid = TRUE THEN
542: IF chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
543: l_log_str := 'View by : '||x_viewby;
544:
545: -- Need to modify above to capture all IDs
546: writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

Line 546: writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

542: IF chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
543: l_log_str := 'View by : '||x_viewby;
544:
545: -- Need to modify above to capture all IDs
546: writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
547: p_module => g_pkg || l_proc || 'Params',
548: p_msg => l_log_str);
549: END IF;
550: ELSE

Line 551: IF chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN

547: p_module => g_pkg || l_proc || 'Params',
548: p_msg => l_log_str);
549: END IF;
550: ELSE
551: IF chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
552: writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
553: p_module => g_pkg || l_proc || l_err_msg,
554: p_msg => l_err_desc );
555: END IF;

Line 552: writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,

548: p_msg => l_log_str);
549: END IF;
550: ELSE
551: IF chkLogLevel(fnd_log.LEVEL_STATEMENT) THEN
552: writeLog(p_log_level => fnd_log.LEVEL_STATEMENT,
553: p_module => g_pkg || l_proc || l_err_msg,
554: p_msg => l_err_desc );
555: END IF;
556: END IF;

Line 585: p_log_level => fnd_log.LEVEL_UNEXPECTED,

581: WHERE user_id = fnd_global.user_id ;
582:
583: IF SQL%NOTFOUND THEN
584: BIL_TX_UTIL_RPT_PKG.writeLog(
585: p_log_level => fnd_log.LEVEL_UNEXPECTED,
586: p_module => g_pkg || '.get_sales_group_id',
587: p_msg => 'Sales Group ID NOT FUND' );
588:
589: END IF;

Line 605: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

601:
602:
603: EXCEPTION
604: WHEN OTHERS THEN
605: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
606: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
607: fnd_message.set_token('Error is : ' ,SQLCODE);
608: fnd_message.set_token('Reason is : ', SQLERRM);
609: BIL_TX_UTIL_RPT_PKG.writeLog(

Line 610: p_log_level => fnd_log.LEVEL_UNEXPECTED,

606: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
607: fnd_message.set_token('Error is : ' ,SQLCODE);
608: fnd_message.set_token('Reason is : ', SQLERRM);
609: BIL_TX_UTIL_RPT_PKG.writeLog(
610: p_log_level => fnd_log.LEVEL_UNEXPECTED,
611: p_module => g_pkg || '.get_sales_group_id',
612: p_msg => fnd_message.get );
613: END IF;
614: l_sg_id := -1;

Line 647: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

643:
644:
645: EXCEPTION
646: WHEN OTHERS THEN
647: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
648: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
649: fnd_message.set_token('Error is : ' ,SQLCODE);
650: fnd_message.set_token('Reason is : ', SQLERRM);
651: BIL_TX_UTIL_RPT_PKG.writeLog(

Line 652: p_log_level => fnd_log.LEVEL_UNEXPECTED,

648: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
649: fnd_message.set_token('Error is : ' ,SQLCODE);
650: fnd_message.set_token('Reason is : ', SQLERRM);
651: BIL_TX_UTIL_RPT_PKG.writeLog(
652: p_log_level => fnd_log.LEVEL_UNEXPECTED,
653: p_module => g_pkg || '.get_sales_group_id',
654: p_msg => fnd_message.get );
655: END IF;
656: l_prod_cat_id := -1;

Line 719: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)

715: -- This function is a wrapper on FND APIs for OA Common Error
716: -- logging framework
717: --
718: -- p_log_level = Severity; valid values are -
719: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
720: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
721: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
722: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
723: -- 5. Error Level (FND_LOG.LEVEL_ERROR)

Line 720: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)

716: -- logging framework
717: --
718: -- p_log_level = Severity; valid values are -
719: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
720: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
721: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
722: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
723: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
724: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)

Line 721: -- 3. Event Level (FND_LOG.LEVEL_EVENT)

717: --
718: -- p_log_level = Severity; valid values are -
719: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
720: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
721: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
722: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
723: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
724: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
725: --

Line 722: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)

718: -- p_log_level = Severity; valid values are -
719: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
720: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
721: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
722: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
723: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
724: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
725: --
726: -- Output values:-

Line 723: -- 5. Error Level (FND_LOG.LEVEL_ERROR)

719: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
720: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
721: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
722: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
723: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
724: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
725: --
726: -- Output values:-
727: -- = TRUE if FND Log is Enabled

Line 724: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)

720: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
721: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
722: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
723: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
724: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
725: --
726: -- Output values:-
727: -- = TRUE if FND Log is Enabled
728: -- = FALSE if FND Log is DISABLED

Line 727: -- = TRUE if FND Log is Enabled

723: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
724: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
725: --
726: -- Output values:-
727: -- = TRUE if FND Log is Enabled
728: -- = FALSE if FND Log is DISABLED
729: --
730: -- **********************************************************************
731:

Line 728: -- = FALSE if FND Log is DISABLED

724: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
725: --
726: -- Output values:-
727: -- = TRUE if FND Log is Enabled
728: -- = FALSE if FND Log is DISABLED
729: --
730: -- **********************************************************************
731:
732: FUNCTION chkLogLevel (p_log_level IN NUMBER) RETURN BOOLEAN IS

Line 734: IF (p_log_level >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN

730: -- **********************************************************************
731:
732: FUNCTION chkLogLevel (p_log_level IN NUMBER) RETURN BOOLEAN IS
733: BEGIN
734: IF (p_log_level >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
735: RETURN TRUE; -- FND log is enabled
736: END IF;
737: RETURN FALSE;
738: EXCEPTION

Line 735: RETURN TRUE; -- FND log is enabled

731:
732: FUNCTION chkLogLevel (p_log_level IN NUMBER) RETURN BOOLEAN IS
733: BEGIN
734: IF (p_log_level >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
735: RETURN TRUE; -- FND log is enabled
736: END IF;
737: RETURN FALSE;
738: EXCEPTION
739: WHEN OTHERS THEN

Line 755: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)

751: -- , Event(3), Expected (4) and Error (5)
752: --
753: -- Input Variables :-
754: -- p_log_level = Severity; valid values are -
755: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
756: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
757: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
758: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
759: -- 5. Error Level (FND_LOG.LEVEL_ERROR)

Line 756: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)

752: --
753: -- Input Variables :-
754: -- p_log_level = Severity; valid values are -
755: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
756: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
757: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
758: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
759: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
760: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)

Line 757: -- 3. Event Level (FND_LOG.LEVEL_EVENT)

753: -- Input Variables :-
754: -- p_log_level = Severity; valid values are -
755: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
756: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
757: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
758: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
759: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
760: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
761: -- p_module = Module Source Details

Line 758: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)

754: -- p_log_level = Severity; valid values are -
755: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
756: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
757: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
758: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
759: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
760: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
761: -- p_module = Module Source Details
762: -- p_msg = Message String

Line 759: -- 5. Error Level (FND_LOG.LEVEL_ERROR)

755: -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
756: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
757: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
758: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
759: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
760: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
761: -- p_module = Module Source Details
762: -- p_msg = Message String
763: --

Line 760: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)

756: -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
757: -- 3. Event Level (FND_LOG.LEVEL_EVENT)
758: -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
759: -- 5. Error Level (FND_LOG.LEVEL_ERROR)
760: -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
761: -- p_module = Module Source Details
762: -- p_msg = Message String
763: --
764: -- **********************************************************************

Line 770: IF ( p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

766: p_module IN VARCHAR2,
767: p_msg IN VARCHAR2)
768: IS
769: BEGIN
770: IF ( p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
771: fnd_log.string(p_log_level, p_module, p_msg);
772: END IF;
773: EXCEPTION
774: WHEN OTHERS THEN

Line 771: fnd_log.string(p_log_level, p_module, p_msg);

767: p_msg IN VARCHAR2)
768: IS
769: BEGIN
770: IF ( p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
771: fnd_log.string(p_log_level, p_module, p_msg);
772: END IF;
773: EXCEPTION
774: WHEN OTHERS THEN
775: NULL;

Line 789: p_log_level => fnd_log.LEVEL_STATEMENT,

785: BEGIN
786: ind :=1;
787: WHILE ind <= length(p_query) LOOP
788: writeLog(
789: p_log_level => fnd_log.LEVEL_STATEMENT,
790: p_module => p_pkg || p_proc || ' statement ',
791: p_msg => substr(p_query, ind, 4000));
792: ind := ind + 4000;
793: END LOOP;

Line 808: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

804: BEGIN
805:
806: l_period_type := NVL(FND_PROFILE.VALUE('ASN_FRCST_DEFAULT_PERIOD_TYPE'), 'Month');
807:
808: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
809: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
810: fnd_message.set_token('Error is : ' ,SQLCODE);
811: fnd_message.set_token('Reason is : ', SQLERRM);
812: BIL_TX_UTIL_RPT_PKG.writeLog(

Line 813: p_log_level => fnd_log.LEVEL_UNEXPECTED,

809: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
810: fnd_message.set_token('Error is : ' ,SQLCODE);
811: fnd_message.set_token('Reason is : ', SQLERRM);
812: BIL_TX_UTIL_RPT_PKG.writeLog(
813: p_log_level => fnd_log.LEVEL_UNEXPECTED,
814: p_module => g_pkg || '.GET_DEF_PRD_TYPE',
815: p_msg => fnd_message.get );
816: END IF;
817:

Line 841: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

837:
838: EXCEPTION
839: WHEN OTHERS THEN
840:
841: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
842: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
843: fnd_message.set_token('Error is : ' ,SQLCODE);
844: fnd_message.set_token('Reason is : ', SQLERRM);
845: BIL_TX_UTIL_RPT_PKG.writeLog(

Line 846: p_log_level => fnd_log.LEVEL_UNEXPECTED,

842: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
843: fnd_message.set_token('Error is : ' ,SQLCODE);
844: fnd_message.set_token('Reason is : ', SQLERRM);
845: BIL_TX_UTIL_RPT_PKG.writeLog(
846: p_log_level => fnd_log.LEVEL_UNEXPECTED,
847: p_module => g_pkg || '.GET_DEFAULT_PERIOD',
848: p_msg => fnd_message.get );
849: END IF;
850:

Line 865: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

861: l_currency_code := NVL(fnd_profile.value('ICX_PREFERRED_CURRENCY'),'USD');
862:
863: RETURN l_currency_code;
864:
865: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
866: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
867: fnd_message.set_token('Error is : ' ,SQLCODE);
868: fnd_message.set_token('Reason is : ', SQLERRM);
869: BIL_TX_UTIL_RPT_PKG.writeLog(

Line 870: p_log_level => fnd_log.LEVEL_UNEXPECTED,

866: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
867: fnd_message.set_token('Error is : ' ,SQLCODE);
868: fnd_message.set_token('Reason is : ', SQLERRM);
869: BIL_TX_UTIL_RPT_PKG.writeLog(
870: p_log_level => fnd_log.LEVEL_UNEXPECTED,
871: p_module => g_pkg || '.GET_DEFAULT_CURRENCY',
872: p_msg => fnd_message.get );
873: END IF;
874:

Line 909: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

905:
906: EXCEPTION
907: WHEN OTHERS THEN
908:
909: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
910: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
911: fnd_message.set_token('Error is : ' ,SQLCODE);
912: fnd_message.set_token('Reason is : ', SQLERRM);
913: BIL_TX_UTIL_RPT_PKG.writeLog(

Line 914: p_log_level => fnd_log.LEVEL_UNEXPECTED,

910: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
911: fnd_message.set_token('Error is : ' ,SQLCODE);
912: fnd_message.set_token('Reason is : ', SQLERRM);
913: BIL_TX_UTIL_RPT_PKG.writeLog(
914: p_log_level => fnd_log.LEVEL_UNEXPECTED,
915: p_module => g_pkg || '.PARSE_PRODCAT_ITEM_ID',
916: p_msg => fnd_message.get
917: );
918: END IF;

Line 930: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

926:
927: EXCEPTION
928: WHEN OTHERS THEN
929:
930: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
931: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
932: fnd_message.set_token('Error is : ' ,SQLCODE);
933: fnd_message.set_token('Reason is : ', SQLERRM);
934: BIL_TX_UTIL_RPT_PKG.writeLog(

Line 935: p_log_level => fnd_log.LEVEL_UNEXPECTED,

931: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
932: fnd_message.set_token('Error is : ' ,SQLCODE);
933: fnd_message.set_token('Reason is : ', SQLERRM);
934: BIL_TX_UTIL_RPT_PKG.writeLog(
935: p_log_level => fnd_log.LEVEL_UNEXPECTED,
936: p_module => g_pkg || '.GET_DEFAULT_RPT_BY',
937: p_msg => fnd_message.get );
938: END IF;
939:

Line 977: IF bil_tx_util_rpt_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

973: EXCEPTION
974:
975: WHEN OTHERS THEN
976:
977: IF bil_tx_util_rpt_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
978: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
979: fnd_message.set_token('Error is : ' ,SQLCODE);
980: fnd_message.set_token('Reason is : ', SQLERRM);
981: bil_tx_util_rpt_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 981: bil_tx_util_rpt_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

977: IF bil_tx_util_rpt_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
978: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
979: fnd_message.set_token('Error is : ' ,SQLCODE);
980: fnd_message.set_token('Reason is : ', SQLERRM);
981: bil_tx_util_rpt_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
982: p_module => '.GET_FROM_DATE',
983: p_msg => fnd_message.get );
984: l_from_date := sysdate;
985:

Line 1024: IF bil_tx_util_rpt_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

1020: EXCEPTION
1021:
1022: WHEN OTHERS THEN
1023:
1024: IF bil_tx_util_rpt_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
1025: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1026: fnd_message.set_token('Error is : ' ,SQLCODE);
1027: fnd_message.set_token('Reason is : ', SQLERRM);
1028: bil_tx_util_rpt_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 1028: bil_tx_util_rpt_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,

1024: IF bil_tx_util_rpt_pkg.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
1025: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1026: fnd_message.set_token('Error is : ' ,SQLCODE);
1027: fnd_message.set_token('Reason is : ', SQLERRM);
1028: bil_tx_util_rpt_pkg.writeLog(p_log_level => fnd_log.LEVEL_UNEXPECTED,
1029: p_module => '.GET_TO_DATE',
1030: p_msg => fnd_message.get );
1031:
1032: l_to_date := sysdate;

Line 1210: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

1206: RETURN l_default_start_period_id;
1207:
1208: EXCEPTION
1209: WHEN NO_DATA_FOUND THEN
1210: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
1211: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1212: fnd_message.set_token('Error is : ' ,SQLCODE);
1213: fnd_message.set_token('Reason is : ', SQLERRM);
1214: BIL_TX_UTIL_RPT_PKG.writeLog(

Line 1215: p_log_level => fnd_log.LEVEL_UNEXPECTED,

1211: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1212: fnd_message.set_token('Error is : ' ,SQLCODE);
1213: fnd_message.set_token('Reason is : ', SQLERRM);
1214: BIL_TX_UTIL_RPT_PKG.writeLog(
1215: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1216: p_module => g_pkg || '.DEF_STRT_PRD',
1217: p_msg => fnd_message.get );
1218: END IF;
1219: l_default_start_period_id := -1;

Line 1222: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

1218: END IF;
1219: l_default_start_period_id := -1;
1220: RETURN l_default_start_period_id;
1221: WHEN OTHERS THEN
1222: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
1223: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1224: fnd_message.set_token('Error is : ' ,SQLCODE);
1225: fnd_message.set_token('Reason is : ', SQLERRM);
1226: BIL_TX_UTIL_RPT_PKG.writeLog(

Line 1227: p_log_level => fnd_log.LEVEL_UNEXPECTED,

1223: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1224: fnd_message.set_token('Error is : ' ,SQLCODE);
1225: fnd_message.set_token('Reason is : ', SQLERRM);
1226: BIL_TX_UTIL_RPT_PKG.writeLog(
1227: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1228: p_module => g_pkg || '.DEF_STRT_PRD',
1229: p_msg => fnd_message.get );
1230: END IF;
1231: l_default_start_period_id := -1;

Line 1288: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

1284: RETURN l_default_end_period_id;
1285:
1286: EXCEPTION
1287: WHEN NO_DATA_FOUND THEN
1288: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
1289: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1290: fnd_message.set_token('Error is : ' ,SQLCODE);
1291: fnd_message.set_token('Reason is : ', SQLERRM);
1292: BIL_TX_UTIL_RPT_PKG.writeLog(

Line 1293: p_log_level => fnd_log.LEVEL_UNEXPECTED,

1289: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1290: fnd_message.set_token('Error is : ' ,SQLCODE);
1291: fnd_message.set_token('Reason is : ', SQLERRM);
1292: BIL_TX_UTIL_RPT_PKG.writeLog(
1293: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1294: p_module => g_pkg || '.DEF_END_PRD',
1295: p_msg => fnd_message.get );
1296: END IF;
1297: l_default_end_period_id := -1;

Line 1300: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

1296: END IF;
1297: l_default_end_period_id := -1;
1298: RETURN l_default_end_period_id;
1299: WHEN OTHERS THEN
1300: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
1301: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1302: fnd_message.set_token('Error is : ' ,SQLCODE);
1303: fnd_message.set_token('Reason is : ', SQLERRM);
1304: BIL_TX_UTIL_RPT_PKG.writeLog(

Line 1305: p_log_level => fnd_log.LEVEL_UNEXPECTED,

1301: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1302: fnd_message.set_token('Error is : ' ,SQLCODE);
1303: fnd_message.set_token('Reason is : ', SQLERRM);
1304: BIL_TX_UTIL_RPT_PKG.writeLog(
1305: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1306: p_module => g_pkg || '.DEF_END_PRD',
1307: p_msg => fnd_message.get );
1308: END IF;
1309: l_default_end_period_id := -1;

Line 1336: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

1332: RETURN l_credit_type_id; --Default to Close Date in the dropdown
1333:
1334: EXCEPTION
1335: WHEN OTHERS THEN
1336: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
1337: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1338: fnd_message.set_token('Error is : ' ,SQLCODE);
1339: fnd_message.set_token('Reason is : ', SQLERRM);
1340: BIL_TX_UTIL_RPT_PKG.writeLog(

Line 1341: p_log_level => fnd_log.LEVEL_UNEXPECTED,

1337: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1338: fnd_message.set_token('Error is : ' ,SQLCODE);
1339: fnd_message.set_token('Reason is : ', SQLERRM);
1340: BIL_TX_UTIL_RPT_PKG.writeLog(
1341: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1342: p_module => g_pkg || '.GET_DEF_FORCST_TYPE',
1343: p_msg => fnd_message.get );
1344:
1345: l_credit_type_id := 1;

Line 1380: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

1376:
1377: EXCEPTION
1378: WHEN OTHERS THEN
1379:
1380: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
1381: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1382: fnd_message.set_token('Error is : ' ,SQLCODE);
1383: fnd_message.set_token('Reason is : ', SQLERRM);
1384: BIL_TX_UTIL_RPT_PKG.writeLog(

Line 1385: p_log_level => fnd_log.LEVEL_UNEXPECTED,

1381: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1382: fnd_message.set_token('Error is : ' ,SQLCODE);
1383: fnd_message.set_token('Reason is : ', SQLERRM);
1384: BIL_TX_UTIL_RPT_PKG.writeLog(
1385: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1386: p_module => g_pkg || '.GET_STATS_CODS_OPTY_FLGS',
1387: p_msg => fnd_message.get );
1388: END IF;
1389: END GET_STATS_CODS_OPTY_FLGS;