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_MESSAGE

Line 606: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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(
610: p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 607: fnd_message.set_token('Error is : ' ,SQLCODE);

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(
610: p_log_level => fnd_log.LEVEL_UNEXPECTED,
611: p_module => g_pkg || '.get_sales_group_id',

Line 608: fnd_message.set_token('Reason is : ', SQLERRM);

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(
610: p_log_level => fnd_log.LEVEL_UNEXPECTED,
611: p_module => g_pkg || '.get_sales_group_id',
612: p_msg => fnd_message.get );

Line 612: p_msg => fnd_message.get );

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;
615: END;
616:

Line 648: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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(
652: p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 649: fnd_message.set_token('Error is : ' ,SQLCODE);

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(
652: p_log_level => fnd_log.LEVEL_UNEXPECTED,
653: p_module => g_pkg || '.get_sales_group_id',

Line 650: fnd_message.set_token('Reason is : ', SQLERRM);

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(
652: p_log_level => fnd_log.LEVEL_UNEXPECTED,
653: p_module => g_pkg || '.get_sales_group_id',
654: p_msg => fnd_message.get );

Line 654: p_msg => fnd_message.get );

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;
657: END;
658:

Line 809: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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(
813: p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 810: fnd_message.set_token('Error is : ' ,SQLCODE);

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(
813: p_log_level => fnd_log.LEVEL_UNEXPECTED,
814: p_module => g_pkg || '.GET_DEF_PRD_TYPE',

Line 811: fnd_message.set_token('Reason is : ', SQLERRM);

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(
813: p_log_level => fnd_log.LEVEL_UNEXPECTED,
814: p_module => g_pkg || '.GET_DEF_PRD_TYPE',
815: p_msg => fnd_message.get );

Line 815: p_msg => fnd_message.get );

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:
818: RETURN l_period_type;
819:

Line 842: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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(
846: p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 843: fnd_message.set_token('Error is : ' ,SQLCODE);

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(
846: p_log_level => fnd_log.LEVEL_UNEXPECTED,
847: p_module => g_pkg || '.GET_DEFAULT_PERIOD',

Line 844: fnd_message.set_token('Reason is : ', SQLERRM);

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(
846: p_log_level => fnd_log.LEVEL_UNEXPECTED,
847: p_module => g_pkg || '.GET_DEFAULT_PERIOD',
848: p_msg => fnd_message.get );

Line 848: p_msg => fnd_message.get );

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:
851: END GET_DEFAULT_PERIOD;
852:

Line 866: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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(
870: p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 867: fnd_message.set_token('Error is : ' ,SQLCODE);

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(
870: p_log_level => fnd_log.LEVEL_UNEXPECTED,
871: p_module => g_pkg || '.GET_DEFAULT_CURRENCY',

Line 868: fnd_message.set_token('Reason is : ', SQLERRM);

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(
870: p_log_level => fnd_log.LEVEL_UNEXPECTED,
871: p_module => g_pkg || '.GET_DEFAULT_CURRENCY',
872: p_msg => fnd_message.get );

Line 872: p_msg => fnd_message.get );

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:
875:
876: END GET_DEFAULT_CURRENCY;

Line 910: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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(
914: p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 911: fnd_message.set_token('Error is : ' ,SQLCODE);

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(
914: p_log_level => fnd_log.LEVEL_UNEXPECTED,
915: p_module => g_pkg || '.PARSE_PRODCAT_ITEM_ID',

Line 912: fnd_message.set_token('Reason is : ', SQLERRM);

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(
914: p_log_level => fnd_log.LEVEL_UNEXPECTED,
915: p_module => g_pkg || '.PARSE_PRODCAT_ITEM_ID',
916: p_msg => fnd_message.get

Line 916: p_msg => fnd_message.get

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;
919:
920: END PARSE_PRODCAT_ITEM_ID;

Line 931: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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(
935: p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 932: fnd_message.set_token('Error is : ' ,SQLCODE);

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(
935: p_log_level => fnd_log.LEVEL_UNEXPECTED,
936: p_module => g_pkg || '.GET_DEFAULT_RPT_BY',

Line 933: fnd_message.set_token('Reason is : ', SQLERRM);

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(
935: p_log_level => fnd_log.LEVEL_UNEXPECTED,
936: p_module => g_pkg || '.GET_DEFAULT_RPT_BY',
937: p_msg => fnd_message.get );

Line 937: p_msg => fnd_message.get );

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:
940: END GET_DEFAULT_RPT_BY;
941:

Line 978: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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,
982: p_module => '.GET_FROM_DATE',

Line 979: fnd_message.set_token('Error is : ' ,SQLCODE);

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,
982: p_module => '.GET_FROM_DATE',
983: p_msg => fnd_message.get );

Line 980: fnd_message.set_token('Reason is : ', SQLERRM);

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,
982: p_module => '.GET_FROM_DATE',
983: p_msg => fnd_message.get );
984: l_from_date := sysdate;

Line 983: p_msg => fnd_message.get );

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:
986: END IF;
987:

Line 1025: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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,
1029: p_module => '.GET_TO_DATE',

Line 1026: fnd_message.set_token('Error is : ' ,SQLCODE);

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,
1029: p_module => '.GET_TO_DATE',
1030: p_msg => fnd_message.get );

Line 1027: fnd_message.set_token('Reason is : ', SQLERRM);

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,
1029: p_module => '.GET_TO_DATE',
1030: p_msg => fnd_message.get );
1031:

Line 1030: p_msg => fnd_message.get );

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;
1033: END IF;
1034:

Line 1211: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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(
1215: p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 1212: fnd_message.set_token('Error is : ' ,SQLCODE);

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(
1215: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1216: p_module => g_pkg || '.DEF_STRT_PRD',

Line 1213: fnd_message.set_token('Reason is : ', SQLERRM);

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(
1215: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1216: p_module => g_pkg || '.DEF_STRT_PRD',
1217: p_msg => fnd_message.get );

Line 1217: p_msg => fnd_message.get );

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;
1220: RETURN l_default_start_period_id;
1221: WHEN OTHERS THEN

Line 1223: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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(
1227: p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 1224: fnd_message.set_token('Error is : ' ,SQLCODE);

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(
1227: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1228: p_module => g_pkg || '.DEF_STRT_PRD',

Line 1225: fnd_message.set_token('Reason is : ', SQLERRM);

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(
1227: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1228: p_module => g_pkg || '.DEF_STRT_PRD',
1229: p_msg => fnd_message.get );

Line 1229: p_msg => fnd_message.get );

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;
1232: RETURN l_default_start_period_id;
1233: END;

Line 1289: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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(
1293: p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 1290: fnd_message.set_token('Error is : ' ,SQLCODE);

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(
1293: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1294: p_module => g_pkg || '.DEF_END_PRD',

Line 1291: fnd_message.set_token('Reason is : ', SQLERRM);

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(
1293: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1294: p_module => g_pkg || '.DEF_END_PRD',
1295: p_msg => fnd_message.get );

Line 1295: p_msg => fnd_message.get );

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;
1298: RETURN l_default_end_period_id;
1299: WHEN OTHERS THEN

Line 1301: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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(
1305: p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 1302: fnd_message.set_token('Error is : ' ,SQLCODE);

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(
1305: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1306: p_module => g_pkg || '.DEF_END_PRD',

Line 1303: fnd_message.set_token('Reason is : ', SQLERRM);

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(
1305: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1306: p_module => g_pkg || '.DEF_END_PRD',
1307: p_msg => fnd_message.get );

Line 1307: p_msg => fnd_message.get );

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;
1310: RETURN l_default_end_period_id;
1311: END;

Line 1337: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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(
1341: p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 1338: fnd_message.set_token('Error is : ' ,SQLCODE);

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(
1341: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1342: p_module => g_pkg || '.GET_DEF_FORCST_TYPE',

Line 1339: fnd_message.set_token('Reason is : ', SQLERRM);

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(
1341: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1342: p_module => g_pkg || '.GET_DEF_FORCST_TYPE',
1343: p_msg => fnd_message.get );

Line 1343: p_msg => fnd_message.get );

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;
1346: END IF;
1347:

Line 1381: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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(
1385: p_log_level => fnd_log.LEVEL_UNEXPECTED,

Line 1382: fnd_message.set_token('Error is : ' ,SQLCODE);

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(
1385: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1386: p_module => g_pkg || '.GET_STATS_CODS_OPTY_FLGS',

Line 1383: fnd_message.set_token('Reason is : ', SQLERRM);

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(
1385: p_log_level => fnd_log.LEVEL_UNEXPECTED,
1386: p_module => g_pkg || '.GET_STATS_CODS_OPTY_FLGS',
1387: p_msg => fnd_message.get );

Line 1387: p_msg => fnd_message.get );

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;
1390:
1391: FUNCTION GET_WIN_PROB RETURN VARCHAR2

Line 1481: l_tip_inf := FND_MESSAGE.GET_STRING('BIL','BIL_TX_OPTY_SMRY_INF_TIP');

1477: FUNCTION GET_OPTY_SMRY_INF_TIP RETURN VARCHAR2
1478: IS
1479: l_tip_inf varchar2(1000);
1480: BEGIN
1481: l_tip_inf := FND_MESSAGE.GET_STRING('BIL','BIL_TX_OPTY_SMRY_INF_TIP');
1482:
1483: RETURN l_tip_inf;
1484:
1485: EXCEPTION