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.OKS_BILLING_PUB dependencies on OKS_BILL_REC_PUB

Line 40: l_processed_lines_tbl OKS_BILL_REC_PUB.line_report_tbl_type;

36: range_arr rangeArray;
37:
38: /* *** PL/sql tables and variables for report **** */
39:
40: l_processed_lines_tbl OKS_BILL_REC_PUB.line_report_tbl_type;
41: l_processed_sub_lines_tbl OKS_BILL_REC_PUB.line_report_tbl_type;
42:
43: l_pr_tbl_idx Number := 0; /* Lines table */
44: l_prs_tbl_idx Number := 0; /* Sub Lines table */

Line 41: l_processed_sub_lines_tbl OKS_BILL_REC_PUB.line_report_tbl_type;

37:
38: /* *** PL/sql tables and variables for report **** */
39:
40: l_processed_lines_tbl OKS_BILL_REC_PUB.line_report_tbl_type;
41: l_processed_sub_lines_tbl OKS_BILL_REC_PUB.line_report_tbl_type;
42:
43: l_pr_tbl_idx Number := 0; /* Lines table */
44: l_prs_tbl_idx Number := 0; /* Sub Lines table */
45:

Line 71: P_cov_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.COVERED_TBL,

67: -------------------------------------------------------------------------
68: Procedure level
69: (
70: P_level_qty IN NUMBER,
71: P_cov_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.COVERED_TBL,
72: P_qty IN NUMBER,
73: --P_line_tbl IN OUT NOCOPY OKS_QP_INT_PVT.G_SLINE_TBL_TYPE ,
74: p_usage_period IN VARCHAR2,
75: p_time_uom_code IN VARCHAR2,

Line 123: -- call oks_bill_rec_pub.Get_prorated_Usage_Qty to get the prorated usage

119: -------------------------------------------------------------------------
120: -- Begin partial period computation logic
121: -- Developer Mani Choudhary
122: -- Date 11-JUN-2005
123: -- call oks_bill_rec_pub.Get_prorated_Usage_Qty to get the prorated usage
124: -------------------------------------------------------------------------
125: IF p_period_type IS NOT NULL AND
126: p_period_start IS NOT NULL
127: THEN

Line 128: l_minimum := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty

124: -------------------------------------------------------------------------
125: IF p_period_type IS NOT NULL AND
126: p_period_start IS NOT NULL
127: THEN
128: l_minimum := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty
129: (
130: p_start_date => l_from_date,
131: p_end_date => l_to_date,
132: p_qty => l_minimum,

Line 138: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty returns l_minimum as '||l_minimum);

134: p_billing_uom => p_uom_code,
135: p_period_type => p_period_type
136: );
137: IF Nvl(l_minimum,0) = 0 THEN
138: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty returns l_minimum as '||l_minimum);
139: Raise G_EXCEPTION_HALT_VALIDATION;
140: END IF;
141: l_minimum := Round(l_minimum,0);
142: ELSE

Line 449: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,

445: p_time_uom_code IN VARCHAR2,
446: p_okl_flag IN NUMBER,
447: p_prv IN NUMBER,
448: p_date IN DATE,
449: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
450: p_billrep_tbl_idx IN NUMBER,
451: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
452: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
453: p_ar_feeder_ctr IN OUT NOCOPY NUMBER,

Line 451: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,

447: p_prv IN NUMBER,
448: p_date IN DATE,
449: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
450: p_billrep_tbl_idx IN NUMBER,
451: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
452: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
453: p_ar_feeder_ctr IN OUT NOCOPY NUMBER,
454: p_period_type IN VARCHAR2,
455: p_period_start IN VARCHAR2,

Line 721: oks_bill_rec_pub.get_message(

717: X_MSG_DATA => l_msg_data,
718: X_NEXT_LEVEL_ELEMENT => level_elements_tab );
719:
720: IF (l_return_status <> 'S') THEN
721: oks_bill_rec_pub.get_message(
722: l_msg_cnt => l_msg_count,
723: l_msg_data => l_msg_data);
724: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
725: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 792: OKS_BILL_REC_PUB.create_bank_Account(

788: /*******
789: create bank account is no longer needed as part of R12 Bank account
790: consolidation project
791:
792: OKS_BILL_REC_PUB.create_bank_Account(
793: p_dnz_chr_id => p_dnz_chr_id,
794: p_bill_start_date => p_top_line_start_date,
795: p_currency_code => p_currency_code,
796: x_status => l_return_status,

Line 802: OKS_BILL_REC_PUB.get_message

798: l_msg_data => l_msg_data
799: );
800:
801: IF (l_return_status <> 'S') THEN
802: OKS_BILL_REC_PUB.get_message
803: (l_msg_cnt => l_msg_count,
804: l_msg_data => l_msg_data);
805: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N';
806: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 833: OKS_BILL_REC_PUB.Insert_bcl

829:
830: /*FOR BILLING REPORT*/
831: l_subline_id := l_covlvl_rec.id;
832:
833: OKS_BILL_REC_PUB.Insert_bcl
834: (P_CALLEDFROM => l_called_from,
835: X_RETURN_STAT => l_return_status,
836: P_CLE_ID => p_top_line_id,
837: P_DATE_BILLED_FROM => l_bill_start_date,

Line 848: oks_bill_rec_pub.get_message

844: P_MSG_DATA => l_msg_data,
845: X_BCL_ID => l_bcl_id);
846:
847: IF (l_return_status <> 'S') THEN
848: oks_bill_rec_pub.get_message
849: (l_msg_cnt => l_msg_count,
850: l_msg_data => l_msg_data);
851: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
852: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 881: OKS_BILL_REC_PUB.get_message

877: X_NEXT_LEVEL_ELEMENT => level_coverage );
878:
879: IF ((l_return_status <> 'S')
880: OR (level_coverage.count = 0)) THEN
881: OKS_BILL_REC_PUB.get_message
882: (l_msg_cnt => l_msg_count,
883: l_msg_data => l_msg_data);
884: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
885: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 987: -- call oks_bill_rec_pub.Get_prorated_Usage_Qty to get the prorated usage

983: -------------------------------------------------------------------------
984: -- Begin partial period computation logic
985: -- Developer Mani Choudhary
986: -- Date 11-JUN-2005
987: -- call oks_bill_rec_pub.Get_prorated_Usage_Qty to get the prorated usage
988: -------------------------------------------------------------------------
989: IF p_period_type IS NOT NULL AND
990: p_period_start IS NOT NULL
991: THEN

Line 993: l_qty := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty

989: IF p_period_type IS NOT NULL AND
990: p_period_start IS NOT NULL
991: THEN
992:
993: l_qty := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty
994: (
995: p_start_date => l_calc_rec.l_calc_sdate,
996: p_end_date => l_calc_rec.l_calc_edate,
997: p_qty => l_qty,

Line 1055: OKS_BILL_REC_PUB.Usage_qty_to_bill

1051: -- Developer Mani Choudhary
1052: -- Date 11-JUN-2005
1053: -- Added additional period_type, period start parameters
1054: -------------------------------------------------------------------------
1055: OKS_BILL_REC_PUB.Usage_qty_to_bill
1056: (
1057: P_calledfrom => p_prv, --1 for normal ,2 for preview,
1058: P_cle_id => l_covlvl_rec.id,
1059: P_Usage_type => l_usage_type,

Line 1089: oks_bill_rec_pub.get_message

1085: );
1086:
1087:
1088: IF (l_return_status <> 'S') THEN
1089: oks_bill_rec_pub.get_message
1090: (l_msg_cnt => l_msg_count,
1091: l_msg_data => l_msg_data);
1092: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
1093: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message:= 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 1209: OKS_BILL_REC_PUB.Insert_all_subline

1205:
1206: p_ar_feeder_ctr := 1;
1207: l_sign := l_cov_tbl(l_ptr).sign;
1208:
1209: OKS_BILL_REC_PUB.Insert_all_subline
1210: (
1211: P_CALLEDFROM => l_called_from,
1212: X_RETURN_STAT => l_return_status,
1213: P_COVERED_TBL => l_cov_tbl,

Line 1285: oks_bill_rec_pub.get_message

1281: /*FOR BILLING REPORT*/
1282: l_exception_amount := l_price_rec.PROD_EXT_AMOUNT;
1283:
1284: IF (l_return_status <> 'S') THEN
1285: oks_bill_rec_pub.get_message
1286: (l_msg_cnt => l_msg_count,
1287: l_msg_data => l_msg_data);
1288:
1289: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Calculate Price Error'||' '||l_return_status);

Line 1297: OKS_BILL_REC_PUB.update_bsl

1293: END IF;
1294:
1295: l_price_rec.PROD_EXT_AMOUNT:=l_price_rec.PROD_EXT_AMOUNT*l_sign;
1296:
1297: OKS_BILL_REC_PUB.update_bsl
1298: (
1299: X_RET_STAT => l_return_status,
1300: P_DNZ_CHR_ID => p_dnz_chr_id,
1301: P_BSL_ID => bsl_price_rec.bsl_id,

Line 1309: oks_bill_rec_pub.get_message

1305: P_PRV => p_prv
1306: );
1307:
1308: IF (l_return_status <> 'S') THEN
1309: oks_bill_rec_pub.get_message
1310: (l_msg_cnt => l_msg_count,
1311: l_msg_data => l_msg_data);
1312:
1313: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error update bsl'||' '||l_return_status);

Line 1378: OKS_BILL_REC_PUB.prorate_price_breaks (

1374: END IF; -- l_price_break_details.COUNT > 0
1375:
1376:
1377: IF ( l_break_amount <> abs(l_price_rec.PROD_EXT_AMOUNT)) THEN
1378: OKS_BILL_REC_PUB.prorate_price_breaks (
1379: P_BSL_ID => bsl_price_rec.bsl_id,
1380: P_BREAK_AMOUNT => l_break_amount,
1381: P_TOT_AMOUNT => l_price_rec.PROD_EXT_AMOUNT ,
1382: X_RETURN_STATUS => l_return_status) ;

Line 1451: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,

1447: p_prv IN NUMBER,
1448: p_date IN DATE,
1449: p_summary_yn IN VARCHAR2,
1450: p_ar_feeder_ctr IN OUT NOCOPY NUMBER,
1451: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
1452: p_billrep_tbl_idx IN NUMBER,
1453: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
1454: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
1455: p_return_status IN OUT NOCOPY VARCHAR2

Line 1453: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,

1449: p_summary_yn IN VARCHAR2,
1450: p_ar_feeder_ctr IN OUT NOCOPY NUMBER,
1451: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
1452: p_billrep_tbl_idx IN NUMBER,
1453: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
1454: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
1455: p_return_status IN OUT NOCOPY VARCHAR2
1456: )
1457: IS

Line 1601: oks_bill_rec_pub.get_message

1597: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After calling OKS_BILL_UTIL_PUB.get_next_level_element l_return_status '||l_return_status);
1598: END IF;
1599:
1600: IF (l_return_status <> 'S') THEN
1601: oks_bill_rec_pub.get_message
1602: (l_msg_cnt => l_msg_count,
1603: l_msg_data => l_msg_data);
1604:
1605: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;

Line 1685: OKS_BILL_REC_PUB.create_bank_Account(

1681: /*******
1682: create bank account is no longer needed as part of R12 Bank account
1683: consolidation project
1684:
1685: OKS_BILL_REC_PUB.create_bank_Account(
1686: P_DNZ_CHR_ID => p_dnz_chr_id,
1687: P_BILL_START_DATE => p_top_line_start_date,
1688: P_CURRENCY_CODE => p_currency_code,
1689: X_STATUS => l_return_status,

Line 1695: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After calling OKS_BILL_REC_PUB.create_bank_Account l_return_status '||l_return_status);

1691: L_MSG_DATA => l_msg_data
1692: );
1693:
1694: IF (l_write_log) THEN
1695: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After calling OKS_BILL_REC_PUB.create_bank_Account l_return_status '||l_return_status);
1696: END IF;
1697:
1698: IF (l_return_status <> 'S') THEN
1699: oks_bill_rec_pub.get_message

Line 1699: oks_bill_rec_pub.get_message

1695: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After calling OKS_BILL_REC_PUB.create_bank_Account l_return_status '||l_return_status);
1696: END IF;
1697:
1698: IF (l_return_status <> 'S') THEN
1699: oks_bill_rec_pub.get_message
1700: (l_msg_cnt => l_msg_count,
1701: l_msg_data => l_msg_data);
1702:
1703: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;

Line 1717: OKS_BILL_REC_PUB.Insert_bcl

1713: RAISE sub_service_exception;
1714: END IF;
1715: *****/
1716:
1717: OKS_BILL_REC_PUB.Insert_bcl
1718: (
1719: P_CALLEDFROM => l_called_from,
1720: X_RETURN_STAT => l_return_status,
1721: P_CLE_ID => p_top_line_id,

Line 1734: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After calling OKS_BILL_REC_PUB.Insert_bcl l_return_status '||l_return_status);

1730: X_BCL_ID => l_bcl_id
1731: );
1732:
1733: IF (l_write_log) THEN
1734: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After calling OKS_BILL_REC_PUB.Insert_bcl l_return_status '||l_return_status);
1735: END IF;
1736:
1737: IF (l_return_status <> 'S') THEN
1738: oks_bill_rec_pub.get_message(

Line 1738: oks_bill_rec_pub.get_message(

1734: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After calling OKS_BILL_REC_PUB.Insert_bcl l_return_status '||l_return_status);
1735: END IF;
1736:
1737: IF (l_return_status <> 'S') THEN
1738: oks_bill_rec_pub.get_message(
1739: l_msg_cnt => l_msg_count,
1740: l_msg_data => l_msg_data);
1741: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
1742: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 1785: OKS_BILL_REC_PUB.Insert_all_subline

1781: END IF;
1782:
1783: IF (l_cov_tbl.count > 0) THEN
1784: p_ar_feeder_ctr := 1;
1785: OKS_BILL_REC_PUB.Insert_all_subline
1786: (
1787: P_CALLEDFROM => l_called_from,
1788: X_RETURN_STAT => l_return_status,
1789: P_COVERED_TBL => l_cov_tbl,

Line 1800: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After calling OKS_BILL_REC_PUB.Insert_all_subline l_return_status '||l_return_status);

1796:
1797: END IF;
1798:
1799: IF (l_write_log) THEN
1800: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After calling OKS_BILL_REC_PUB.Insert_all_subline l_return_status '||l_return_status);
1801: END IF;
1802:
1803: IF (l_return_status <> 'S') THEN
1804: oks_bill_rec_pub.get_message(

Line 1804: oks_bill_rec_pub.get_message(

1800: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After calling OKS_BILL_REC_PUB.Insert_all_subline l_return_status '||l_return_status);
1801: END IF;
1802:
1803: IF (l_return_status <> 'S') THEN
1804: oks_bill_rec_pub.get_message(
1805: l_msg_cnt => l_msg_count,
1806: l_msg_data => l_msg_data);
1807: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
1808: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 1969: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,

1965: p_nos_of_items IN NUMBER,
1966: p_uom_code IN VARCHAR2,
1967: p_prv IN NUMBER,
1968: p_date IN DATE,
1969: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
1970: p_billrep_tbl_idx IN NUMBER,
1971: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
1972: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
1973: p_ar_feeder_ctr IN OUT NOCOPY NUMBER,

Line 1971: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,

1967: p_prv IN NUMBER,
1968: p_date IN DATE,
1969: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
1970: p_billrep_tbl_idx IN NUMBER,
1971: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
1972: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
1973: p_ar_feeder_ctr IN OUT NOCOPY NUMBER,
1974: p_return_status IN OUT NOCOPY VARCHAR2)
1975: IS

Line 2022: oks_bill_rec_pub.get_message(

2018: x_msg_data => l_msg_data,
2019: x_next_level_element => level_elements_tab );
2020:
2021: IF (l_return_status <> 'S') Then
2022: oks_bill_rec_pub.get_message(
2023: l_msg_cnt => l_msg_count,
2024: l_msg_data => l_msg_data);
2025: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
2026: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '||

Line 2061: OKS_BILL_REC_PUB.create_bank_Account(

2057: /*******
2058: create bank account is no longer needed as part of R12 Bank account
2059: consolidation project
2060:
2061: OKS_BILL_REC_PUB.create_bank_Account(
2062: P_DNZ_CHR_ID => p_dnz_chr_id,
2063: P_BILL_START_DATE => p_top_line_start_date,
2064: P_CURRENCY_CODE => p_currency_code,
2065: X_STATUS => l_return_status,

Line 2071: oks_bill_rec_pub.get_message(

2067: L_MSG_DATA => l_msg_data
2068: );
2069:
2070: IF (l_return_status <> 'S') THEN
2071: oks_bill_rec_pub.get_message(
2072: l_msg_cnt => l_msg_count,
2073: l_msg_data => l_msg_data);
2074: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
2075: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 2089: OKS_BILL_REC_PUB.Insert_bcl

2085: /*This procedure insert the into bill_con_lines,
2086: if the record is not already present for the same period.
2087: Since the out table returns the row_id of the inserted row, get_bcl_id
2088: which was present in earliar version is now removed*/
2089: OKS_BILL_REC_PUB.Insert_bcl
2090: (
2091: P_CALLEDFROM => l_called_from,
2092: X_RETURN_STAT => l_return_status,
2093: P_CLE_ID => p_top_line_id,

Line 2106: oks_bill_rec_pub.get_message(

2102: X_BCL_ID => l_bcl_id
2103: );
2104:
2105: IF (l_return_status <> 'S') THEN
2106: oks_bill_rec_pub.get_message(
2107: l_msg_cnt => l_msg_count,
2108: l_msg_data => l_msg_data);
2109: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
2110: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 2146: OKS_BILL_REC_PUB.Insert_all_subline

2142:
2143: IF (l_cov_tbl.count > 0) THEN
2144: /* check if this is to be passed back to main api */
2145: p_ar_feeder_ctr := 1;
2146: OKS_BILL_REC_PUB.Insert_all_subline
2147: (
2148: P_CALLEDFROM => l_called_from,
2149: X_RETURN_STAT => l_return_status,
2150: P_COVERED_TBL => l_cov_tbl,

Line 2163: oks_bill_rec_pub.get_message(

2159: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Status after insert into sublines '||l_return_status );
2160: END IF;
2161:
2162: IF (l_return_status <> 'S') THEN
2163: oks_bill_rec_pub.get_message(
2164: l_msg_cnt => l_msg_count,
2165: l_msg_data => l_msg_data);
2166: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N ' ;
2167: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 2450: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;

2446:
2447: --Start mchoudha Bug#3537100 17-APR-04
2448: --For Billing Report
2449:
2450: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;
2451: l_billrep_tbl_idx NUMBER;
2452: l_billrep_found BOOLEAN;
2453: j NUMBER;
2454: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;

Line 2454: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;

2450: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;
2451: l_billrep_tbl_idx NUMBER;
2452: l_billrep_found BOOLEAN;
2453: j NUMBER;
2454: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;
2455: l_billrep_errtbl_idx NUMBER;
2456:
2457: --End mchoudha Bug#3537100
2458:

Line 2797: oks_bill_rec_pub.get_message (

2793: P_BILLREP_ERR_TBL_IDX => l_billrep_errtbl_idx
2794: );
2795:
2796: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
2797: oks_bill_rec_pub.get_message (
2798: l_msg_cnt => l_msg_count,
2799: l_msg_data => l_msg_data);
2800: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
2801: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 2803: oks_bill_Rec_pub.Set_sub_line(

2799: l_msg_data => l_msg_data);
2800: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
2801: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
2802:
2803: oks_bill_Rec_pub.Set_sub_line(
2804: P_PROCESSED_LINES_TBL => l_processed_lines_tbl,
2805: P_PROCESSED_SUB_LINES_TBL => l_processed_sub_lines_tbl,
2806: P_ERROR_MESSAGE => l_processed_lines_tbl(l_pr_tbl_idx).Error_Message,
2807: P_TOP_LINE => l_bill_rec.id) ;

Line 2976: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;

2972: l_org_id NUMBER;
2973: l_flag NUMBER := 0;
2974: v_cursor NUMBER;
2975:
2976: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;
2977: l_billrep_tbl_idx NUMBER;
2978: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;
2979: l_billrep_errtbl_idx NUMBER;
2980:

Line 2978: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;

2974: v_cursor NUMBER;
2975:
2976: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;
2977: l_billrep_tbl_idx NUMBER;
2978: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;
2979: l_billrep_errtbl_idx NUMBER;
2980:
2981: BEGIN
2982:

Line 3561: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;

3557: AND bcl.btn_id = -44;
3558:
3559:
3560:
3561: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;
3562: l_billrep_tbl_idx NUMBER;
3563: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;
3564: l_billrep_errtbl_idx NUMBER;
3565:

Line 3563: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;

3559:
3560:
3561: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;
3562: l_billrep_tbl_idx NUMBER;
3563: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;
3564: l_billrep_errtbl_idx NUMBER;
3565:
3566:
3567: BEGIN

Line 3720: OKS_BILL_REC_PUB.GET_MESSAGE(

3716: p_billrep_err_tbl_idx => l_billrep_errtbl_idx
3717: ) ;
3718:
3719: IF (l_return_status <> 'S') THEN
3720: OKS_BILL_REC_PUB.GET_MESSAGE(
3721: l_msg_cnt => l_msg_cnt,
3722: l_msg_data => l_msg_data);
3723: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: Failed in AR FEEDER');
3724: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');