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 BIL_TX_UTIL_RPT_PKG

Line 1: PACKAGE BODY BIL_TX_UTIL_RPT_PKG AS

1: PACKAGE BODY BIL_TX_UTIL_RPT_PKG AS
2: /* $Header: biltxutb.pls 120.22 2005/12/15 14:07 syeddana noship $ */
3:
4:
5: g_pkg VARCHAR2(500);

Line 97: g_pkg := 'bil.patch.115.sql.BIL_TX_UTIL_RPT_PKG';

93: l_is_number BOOLEAN;
94:
95:
96: BEGIN
97: g_pkg := 'bil.patch.115.sql.BIL_TX_UTIL_RPT_PKG';
98: l_err_desc := 'Please run with a valid ';
99: l_parameter_valid := True;
100: l_proc := 'GET_PAGE_PARAMS ';
101: l_is_number := TRUE;

Line 267: l_is_number := BIL_TX_UTIL_RPT_PKG.WP_IS_NUMBER(l_win_probability);

263: END IF;
264:
265:
266: IF l_win_probability IS NOT NULL THEN
267: l_is_number := BIL_TX_UTIL_RPT_PKG.WP_IS_NUMBER(l_win_probability);
268: END IF;
269:
270: IF l_is_number THEN
271: x_win_probability := REPLACE(l_win_probability , '''');

Line 386: l_is_number := BIL_TX_UTIL_RPT_PKG.IS_NUMBER(l_total_opp_amount);

382: IF p_page_parameter_tbl(i).parameter_name = 'BIL_TX_TOT_OPP_AMT' THEN
383: l_total_opp_amount := p_page_parameter_tbl(i).parameter_id;
384: l_total_opp_amt_opr := p_page_parameter_tbl(i).operator;
385: IF l_total_opp_amount IS NOT NULL OR l_total_opp_amount <> 'All' THEN
386: l_is_number := BIL_TX_UTIL_RPT_PKG.IS_NUMBER(l_total_opp_amount);
387: IF l_is_number THEN
388: x_total_opp_amount := REPLACE(l_total_opp_amount , '''');
389: x_total_opp_amt_opr := REPLACE(l_total_opp_amt_opr, '''');
390: l_parameter_valid := TRUE;

Line 493: g_pkg := 'bil.patch.115.sql.BIL_TX_UTIL_RPT_PKG';

489: l_credit_type_id VARCHAR2(100);
490:
491:
492: BEGIN
493: g_pkg := 'bil.patch.115.sql.BIL_TX_UTIL_RPT_PKG';
494: l_err_desc := 'Please run with a valid ';
495: l_parameter_valid := True;
496: l_proc := 'GET_DETAIL_PAGE_PARAMS';
497:

Line 573: g_pkg := 'bil.patch.115.sql.BIL_TX_UTIL_RPT_PKG';

569:
570: l_sg_id NUMBER;
571: l_resource_id NUMBER;
572: BEGIN
573: g_pkg := 'bil.patch.115.sql.BIL_TX_UTIL_RPT_PKG';
574: BEGIN
575:
576: -- since SG and Sales Person are multi select we need to work
577: -- on it differently than summary report.

Line 584: BIL_TX_UTIL_RPT_PKG.writeLog(

580: FROM JTF_RS_RESOURCE_EXTNS
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:

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 609: BIL_TX_UTIL_RPT_PKG.writeLog(

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 );
613: END IF;

Line 632: g_pkg := 'bil.patch.115.sql.BIL_TX_UTIL_RPT_PKG';

628: FUNCTION get_prod_cat_id RETURN NUMBER IS
629:
630: l_prod_cat_id VARCHAR2(1000);
631: BEGIN
632: g_pkg := 'bil.patch.115.sql.BIL_TX_UTIL_RPT_PKG';
633: BEGIN
634:
635: -- performance Tuning
636:

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 651: BIL_TX_UTIL_RPT_PKG.writeLog(

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 );
655: END IF;

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 812: BIL_TX_UTIL_RPT_PKG.writeLog(

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 );
816: END IF;

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 845: BIL_TX_UTIL_RPT_PKG.writeLog(

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 );
849: END IF;

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 869: BIL_TX_UTIL_RPT_PKG.writeLog(

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 );
873: END IF;

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 913: BIL_TX_UTIL_RPT_PKG.writeLog(

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
917: );

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 934: BIL_TX_UTIL_RPT_PKG.writeLog(

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 );
938: END IF;

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 1214: BIL_TX_UTIL_RPT_PKG.writeLog(

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 );
1218: END IF;

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 1226: BIL_TX_UTIL_RPT_PKG.writeLog(

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 );
1230: END IF;

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 1292: BIL_TX_UTIL_RPT_PKG.writeLog(

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 );
1296: END IF;

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 1304: BIL_TX_UTIL_RPT_PKG.writeLog(

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 );
1308: END IF;

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 1340: BIL_TX_UTIL_RPT_PKG.writeLog(

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 );
1344:

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 1384: BIL_TX_UTIL_RPT_PKG.writeLog(

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 );
1388: END IF;

Line 1538: END BIL_TX_UTIL_RPT_PKG;

1534:
1535: END hide_parameter;
1536:
1537:
1538: END BIL_TX_UTIL_RPT_PKG;