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 532: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,

528: p_time_uom_code IN VARCHAR2,
529: p_okl_flag IN NUMBER,
530: p_prv IN NUMBER,
531: p_date IN DATE,
532: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
533: p_billrep_tbl_idx IN NUMBER,
534: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
535: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
536: p_ar_feeder_ctr IN OUT NOCOPY NUMBER,

Line 534: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,

530: p_prv IN NUMBER,
531: p_date IN DATE,
532: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
533: p_billrep_tbl_idx IN NUMBER,
534: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
535: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
536: p_ar_feeder_ctr IN OUT NOCOPY NUMBER,
537: p_period_type IN VARCHAR2,
538: p_period_start IN VARCHAR2,

Line 805: oks_bill_rec_pub.get_message(

801: X_MSG_DATA => l_msg_data,
802: X_NEXT_LEVEL_ELEMENT => level_elements_tab );
803:
804: IF (l_return_status <> 'S') THEN
805: oks_bill_rec_pub.get_message(
806: l_msg_cnt => l_msg_count,
807: l_msg_data => l_msg_data);
808: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
809: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 876: OKS_BILL_REC_PUB.create_bank_Account(

872: /*******
873: create bank account is no longer needed as part of R12 Bank account
874: consolidation project
875:
876: OKS_BILL_REC_PUB.create_bank_Account(
877: p_dnz_chr_id => p_dnz_chr_id,
878: p_bill_start_date => p_top_line_start_date,
879: p_currency_code => p_currency_code,
880: x_status => l_return_status,

Line 886: OKS_BILL_REC_PUB.get_message

882: l_msg_data => l_msg_data
883: );
884:
885: IF (l_return_status <> 'S') THEN
886: OKS_BILL_REC_PUB.get_message
887: (l_msg_cnt => l_msg_count,
888: l_msg_data => l_msg_data);
889: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N';
890: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 917: OKS_BILL_REC_PUB.Insert_bcl

913:
914: /*FOR BILLING REPORT*/
915: l_subline_id := l_covlvl_rec.id;
916:
917: OKS_BILL_REC_PUB.Insert_bcl
918: (P_CALLEDFROM => l_called_from,
919: X_RETURN_STAT => l_return_status,
920: P_CLE_ID => p_top_line_id,
921: P_DATE_BILLED_FROM => l_bill_start_date,

Line 932: oks_bill_rec_pub.get_message

928: P_MSG_DATA => l_msg_data,
929: X_BCL_ID => l_bcl_id);
930:
931: IF (l_return_status <> 'S') THEN
932: oks_bill_rec_pub.get_message
933: (l_msg_cnt => l_msg_count,
934: l_msg_data => l_msg_data);
935: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
936: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 965: OKS_BILL_REC_PUB.get_message

961: X_NEXT_LEVEL_ELEMENT => level_coverage );
962:
963: IF ((l_return_status <> 'S')
964: OR (level_coverage.count = 0)) THEN
965: OKS_BILL_REC_PUB.get_message
966: (l_msg_cnt => l_msg_count,
967: l_msg_data => l_msg_data);
968: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
969: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

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

1067: -------------------------------------------------------------------------
1068: -- Begin partial period computation logic
1069: -- Developer Mani Choudhary
1070: -- Date 11-JUN-2005
1071: -- call oks_bill_rec_pub.Get_prorated_Usage_Qty to get the prorated usage
1072: -------------------------------------------------------------------------
1073: IF p_period_type IS NOT NULL AND
1074: p_period_start IS NOT NULL
1075: THEN

Line 1077: l_qty := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty

1073: IF p_period_type IS NOT NULL AND
1074: p_period_start IS NOT NULL
1075: THEN
1076:
1077: l_qty := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty
1078: (
1079: p_start_date => l_calc_rec.l_calc_sdate,
1080: p_end_date => l_calc_rec.l_calc_edate,
1081: p_qty => l_qty,

Line 1139: OKS_BILL_REC_PUB.Usage_qty_to_bill

1135: -- Developer Mani Choudhary
1136: -- Date 11-JUN-2005
1137: -- Added additional period_type, period start parameters
1138: -------------------------------------------------------------------------
1139: OKS_BILL_REC_PUB.Usage_qty_to_bill
1140: (
1141: P_calledfrom => p_prv, --1 for normal ,2 for preview,
1142: P_cle_id => l_covlvl_rec.id,
1143: P_Usage_type => l_usage_type,

Line 1173: oks_bill_rec_pub.get_message

1169: );
1170:
1171:
1172: IF (l_return_status <> 'S') THEN
1173: oks_bill_rec_pub.get_message
1174: (l_msg_cnt => l_msg_count,
1175: l_msg_data => l_msg_data);
1176: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
1177: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message:= 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 1293: OKS_BILL_REC_PUB.Insert_all_subline

1289:
1290: p_ar_feeder_ctr := 1;
1291: l_sign := l_cov_tbl(l_ptr).sign;
1292:
1293: OKS_BILL_REC_PUB.Insert_all_subline
1294: (
1295: P_CALLEDFROM => l_called_from,
1296: X_RETURN_STAT => l_return_status,
1297: P_COVERED_TBL => l_cov_tbl,

Line 1391: OKS_BILL_REC_PUB.update_bsl

1387: l_exception_amount := 0;
1388: l_price_rec.PROD_EXT_AMOUNT :=0;
1389: l_price_rec.PROD_EXT_AMOUNT:=l_price_rec.PROD_EXT_AMOUNT*l_sign;
1390:
1391: OKS_BILL_REC_PUB.update_bsl
1392: (
1393: X_RET_STAT => l_return_status,
1394: P_DNZ_CHR_ID => p_dnz_chr_id,
1395: P_BSL_ID => bsl_price_rec.bsl_id,

Line 1403: oks_bill_rec_pub.get_message

1399: P_PRV => p_prv
1400: );
1401:
1402: IF (l_return_status <> 'S') THEN
1403: oks_bill_rec_pub.get_message
1404: (l_msg_cnt => l_msg_count,
1405: l_msg_data => l_msg_data);
1406:
1407: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error update bsl'||' '||l_return_status);

Line 1714: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,

1710:
1711: Procedure Usg_billing_bulk_qp_call_prc (
1712: p_process_counter IN OUT NOCOPY NUMBER,
1713: p_reject_counter IN OUT NOCOPY NUMBER,
1714: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
1715: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
1716: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
1717: P_calledfrom IN NUMBER,
1718: P_flag IN NUMBER ,

Line 1715: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,

1711: Procedure Usg_billing_bulk_qp_call_prc (
1712: p_process_counter IN OUT NOCOPY NUMBER,
1713: p_reject_counter IN OUT NOCOPY NUMBER,
1714: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
1715: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
1716: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
1717: P_calledfrom IN NUMBER,
1718: P_flag IN NUMBER ,
1719: P_date IN DATE ,

Line 3328: OKS_BILL_REC_PUB.update_bsl

3324:
3325: l_price_rec.PROD_EXT_AMOUNT:=l_PROD_EXT_AMOUNT*bsl_rec.bill_sign;
3326:
3327:
3328: OKS_BILL_REC_PUB.update_bsl
3329: (
3330: X_RET_STAT => l_return_status,
3331: P_DNZ_CHR_ID => bsl_rec.dnz_chr_id,
3332: P_BSL_ID => bsl_rec.bsl_id,

Line 3340: oks_bill_rec_pub.get_message

3336: P_PRV => bsl_rec.prv
3337: );
3338:
3339: IF (l_return_status <> 'S') THEN
3340: oks_bill_rec_pub.get_message
3341: (l_msg_cnt => l_msg_count,
3342: l_msg_data => l_msg_data);
3343:
3344: Raise bulk_USAGE_EXCEPTION;

Line 3405: OKS_BILL_REC_PUB.prorate_price_breaks (

3401: END IF; -- l_price_break_details.COUNT > 0
3402:
3403: --Modified for bug:9900133
3404: IF ((l_break_amount <> 0 ) and ( l_break_amount <> abs(l_price_rec.PROD_EXT_AMOUNT))) THEN
3405: OKS_BILL_REC_PUB.prorate_price_breaks (
3406: P_BSL_ID => bsl_rec.bsl_id,
3407: P_BREAK_AMOUNT => l_break_amount,
3408: P_TOT_AMOUNT => l_price_rec.PROD_EXT_AMOUNT ,
3409: X_RETURN_STATUS => l_return_status) ;

Line 3434: oks_bill_rec_pub.get_message (

3430: P_BILLREP_ERR_TBL_IDX => p_billrep_err_tbl_idx
3431: );
3432:
3433: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
3434: oks_bill_rec_pub.get_message (
3435: l_msg_cnt => l_msg_count,
3436: l_msg_data => l_msg_data);
3437: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => Failed in AR FEEDER :'||' '||usage_line_rec.line_id);
3438:

Line 3553: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,

3549: p_time_uom_code IN VARCHAR2,
3550: p_okl_flag IN NUMBER,
3551: p_prv IN NUMBER,
3552: p_date IN DATE,
3553: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
3554: p_billrep_tbl_idx IN NUMBER,
3555: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
3556: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
3557: p_ar_feeder_ctr IN OUT NOCOPY NUMBER,

Line 3555: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,

3551: p_prv IN NUMBER,
3552: p_date IN DATE,
3553: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
3554: p_billrep_tbl_idx IN NUMBER,
3555: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
3556: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
3557: p_ar_feeder_ctr IN OUT NOCOPY NUMBER,
3558: p_period_type IN VARCHAR2,
3559: p_period_start IN VARCHAR2,

Line 3826: oks_bill_rec_pub.get_message(

3822: X_MSG_DATA => l_msg_data,
3823: X_NEXT_LEVEL_ELEMENT => level_elements_tab );
3824:
3825: IF (l_return_status <> 'S') THEN
3826: oks_bill_rec_pub.get_message(
3827: l_msg_cnt => l_msg_count,
3828: l_msg_data => l_msg_data);
3829: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
3830: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 3897: OKS_BILL_REC_PUB.create_bank_Account(

3893: /*******
3894: create bank account is no longer needed as part of R12 Bank account
3895: consolidation project
3896:
3897: OKS_BILL_REC_PUB.create_bank_Account(
3898: p_dnz_chr_id => p_dnz_chr_id,
3899: p_bill_start_date => p_top_line_start_date,
3900: p_currency_code => p_currency_code,
3901: x_status => l_return_status,

Line 3907: OKS_BILL_REC_PUB.get_message

3903: l_msg_data => l_msg_data
3904: );
3905:
3906: IF (l_return_status <> 'S') THEN
3907: OKS_BILL_REC_PUB.get_message
3908: (l_msg_cnt => l_msg_count,
3909: l_msg_data => l_msg_data);
3910: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N';
3911: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 3938: OKS_BILL_REC_PUB.Insert_bcl

3934:
3935: /*FOR BILLING REPORT*/
3936: l_subline_id := l_covlvl_rec.id;
3937:
3938: OKS_BILL_REC_PUB.Insert_bcl
3939: (P_CALLEDFROM => l_called_from,
3940: X_RETURN_STAT => l_return_status,
3941: P_CLE_ID => p_top_line_id,
3942: P_DATE_BILLED_FROM => l_bill_start_date,

Line 3953: oks_bill_rec_pub.get_message

3949: P_MSG_DATA => l_msg_data,
3950: X_BCL_ID => l_bcl_id);
3951:
3952: IF (l_return_status <> 'S') THEN
3953: oks_bill_rec_pub.get_message
3954: (l_msg_cnt => l_msg_count,
3955: l_msg_data => l_msg_data);
3956: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
3957: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 3986: OKS_BILL_REC_PUB.get_message

3982: X_NEXT_LEVEL_ELEMENT => level_coverage );
3983:
3984: IF ((l_return_status <> 'S')
3985: OR (level_coverage.count = 0)) THEN
3986: OKS_BILL_REC_PUB.get_message
3987: (l_msg_cnt => l_msg_count,
3988: l_msg_data => l_msg_data);
3989: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
3990: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

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

4088: -------------------------------------------------------------------------
4089: -- Begin partial period computation logic
4090: -- Developer Mani Choudhary
4091: -- Date 11-JUN-2005
4092: -- call oks_bill_rec_pub.Get_prorated_Usage_Qty to get the prorated usage
4093: -------------------------------------------------------------------------
4094: IF p_period_type IS NOT NULL AND
4095: p_period_start IS NOT NULL
4096: THEN

Line 4098: l_qty := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty

4094: IF p_period_type IS NOT NULL AND
4095: p_period_start IS NOT NULL
4096: THEN
4097:
4098: l_qty := OKS_BILL_REC_PUB.Get_Prorated_Usage_Qty
4099: (
4100: p_start_date => l_calc_rec.l_calc_sdate,
4101: p_end_date => l_calc_rec.l_calc_edate,
4102: p_qty => l_qty,

Line 4161: OKS_BILL_REC_PUB.Usage_qty_to_bill

4157: -- Developer Mani Choudhary
4158: -- Date 11-JUN-2005
4159: -- Added additional period_type, period start parameters
4160: -------------------------------------------------------------------------
4161: OKS_BILL_REC_PUB.Usage_qty_to_bill
4162: (
4163: P_calledfrom => p_prv, --1 for normal ,2 for preview,
4164: P_cle_id => l_covlvl_rec.id,
4165: P_Usage_type => l_usage_type,

Line 4195: oks_bill_rec_pub.get_message

4191: );
4192:
4193:
4194: IF (l_return_status <> 'S') THEN
4195: oks_bill_rec_pub.get_message
4196: (l_msg_cnt => l_msg_count,
4197: l_msg_data => l_msg_data);
4198: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
4199: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message:= 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 4315: OKS_BILL_REC_PUB.Insert_all_subline

4311:
4312: p_ar_feeder_ctr := 1;
4313: l_sign := l_cov_tbl(l_ptr).sign;
4314:
4315: OKS_BILL_REC_PUB.Insert_all_subline
4316: (
4317: P_CALLEDFROM => l_called_from,
4318: X_RETURN_STAT => l_return_status,
4319: P_COVERED_TBL => l_cov_tbl,

Line 4401: oks_bill_rec_pub.get_message

4397: Raise USAGE_EXCEPTION;
4398:
4399: END IF;
4400: ELSE
4401: oks_bill_rec_pub.get_message
4402: (l_msg_cnt => l_msg_count,
4403: l_msg_data => l_msg_data);
4404:
4405: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Calculate Price Error'||' '||l_return_status);

Line 4430: OKS_BILL_REC_PUB.update_bsl

4426: end if; -- Ceredian Bug ER
4427:
4428:
4429:
4430: OKS_BILL_REC_PUB.update_bsl
4431: (
4432: X_RET_STAT => l_return_status,
4433: P_DNZ_CHR_ID => p_dnz_chr_id,
4434: P_BSL_ID => bsl_price_rec.bsl_id,

Line 4442: oks_bill_rec_pub.get_message

4438: P_PRV => p_prv
4439: );
4440:
4441: IF (l_return_status <> 'S') THEN
4442: oks_bill_rec_pub.get_message
4443: (l_msg_cnt => l_msg_count,
4444: l_msg_data => l_msg_data);
4445:
4446: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error update bsl'||' '||l_return_status);

Line 4511: OKS_BILL_REC_PUB.prorate_price_breaks (

4507: END IF; -- l_price_break_details.COUNT > 0
4508:
4509: /*Modified for bug:9900133*/
4510: IF ((l_break_amount <> 0 ) and ( l_break_amount <> abs(l_price_rec.PROD_EXT_AMOUNT))) THEN
4511: OKS_BILL_REC_PUB.prorate_price_breaks (
4512: P_BSL_ID => bsl_price_rec.bsl_id,
4513: P_BREAK_AMOUNT => l_break_amount,
4514: P_TOT_AMOUNT => l_price_rec.PROD_EXT_AMOUNT ,
4515: X_RETURN_STATUS => l_return_status) ;

Line 4584: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,

4580: p_prv IN NUMBER,
4581: p_date IN DATE,
4582: p_summary_yn IN VARCHAR2,
4583: p_ar_feeder_ctr IN OUT NOCOPY NUMBER,
4584: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
4585: p_billrep_tbl_idx IN NUMBER,
4586: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
4587: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
4588: p_return_status IN OUT NOCOPY VARCHAR2

Line 4586: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,

4582: p_summary_yn IN VARCHAR2,
4583: p_ar_feeder_ctr IN OUT NOCOPY NUMBER,
4584: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
4585: p_billrep_tbl_idx IN NUMBER,
4586: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
4587: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
4588: p_return_status IN OUT NOCOPY VARCHAR2
4589: )
4590: IS

Line 4734: oks_bill_rec_pub.get_message

4730: 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);
4731: END IF;
4732:
4733: IF (l_return_status <> 'S') THEN
4734: oks_bill_rec_pub.get_message
4735: (l_msg_cnt => l_msg_count,
4736: l_msg_data => l_msg_data);
4737:
4738: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;

Line 4818: OKS_BILL_REC_PUB.create_bank_Account(

4814: /*******
4815: create bank account is no longer needed as part of R12 Bank account
4816: consolidation project
4817:
4818: OKS_BILL_REC_PUB.create_bank_Account(
4819: P_DNZ_CHR_ID => p_dnz_chr_id,
4820: P_BILL_START_DATE => p_top_line_start_date,
4821: P_CURRENCY_CODE => p_currency_code,
4822: X_STATUS => l_return_status,

Line 4828: 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);

4824: L_MSG_DATA => l_msg_data
4825: );
4826:
4827: IF (l_write_log) THEN
4828: 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);
4829: END IF;
4830:
4831: IF (l_return_status <> 'S') THEN
4832: oks_bill_rec_pub.get_message

Line 4832: oks_bill_rec_pub.get_message

4828: 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);
4829: END IF;
4830:
4831: IF (l_return_status <> 'S') THEN
4832: oks_bill_rec_pub.get_message
4833: (l_msg_cnt => l_msg_count,
4834: l_msg_data => l_msg_data);
4835:
4836: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;

Line 4850: OKS_BILL_REC_PUB.Insert_bcl

4846: RAISE sub_service_exception;
4847: END IF;
4848: *****/
4849:
4850: OKS_BILL_REC_PUB.Insert_bcl
4851: (
4852: P_CALLEDFROM => l_called_from,
4853: X_RETURN_STAT => l_return_status,
4854: P_CLE_ID => p_top_line_id,

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

4863: X_BCL_ID => l_bcl_id
4864: );
4865:
4866: IF (l_write_log) THEN
4867: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After calling OKS_BILL_REC_PUB.Insert_bcl l_return_status '||l_return_status);
4868: END IF;
4869:
4870: IF (l_return_status <> 'S') THEN
4871: oks_bill_rec_pub.get_message(

Line 4871: oks_bill_rec_pub.get_message(

4867: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After calling OKS_BILL_REC_PUB.Insert_bcl l_return_status '||l_return_status);
4868: END IF;
4869:
4870: IF (l_return_status <> 'S') THEN
4871: oks_bill_rec_pub.get_message(
4872: l_msg_cnt => l_msg_count,
4873: l_msg_data => l_msg_data);
4874: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
4875: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 4918: OKS_BILL_REC_PUB.Insert_all_subline

4914: END IF;
4915:
4916: IF (l_cov_tbl.count > 0) THEN
4917: p_ar_feeder_ctr := 1;
4918: OKS_BILL_REC_PUB.Insert_all_subline
4919: (
4920: P_CALLEDFROM => l_called_from,
4921: X_RETURN_STAT => l_return_status,
4922: P_COVERED_TBL => l_cov_tbl,

Line 4933: 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);

4929:
4930: END IF;
4931:
4932: IF (l_write_log) THEN
4933: 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);
4934: END IF;
4935:
4936: IF (l_return_status <> 'S') THEN
4937: oks_bill_rec_pub.get_message(

Line 4937: oks_bill_rec_pub.get_message(

4933: 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);
4934: END IF;
4935:
4936: IF (l_return_status <> 'S') THEN
4937: oks_bill_rec_pub.get_message(
4938: l_msg_cnt => l_msg_count,
4939: l_msg_data => l_msg_data);
4940: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
4941: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 5102: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,

5098: p_nos_of_items IN NUMBER,
5099: p_uom_code IN VARCHAR2,
5100: p_prv IN NUMBER,
5101: p_date IN DATE,
5102: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
5103: p_billrep_tbl_idx IN NUMBER,
5104: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
5105: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
5106: p_ar_feeder_ctr IN OUT NOCOPY NUMBER,

Line 5104: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,

5100: p_prv IN NUMBER,
5101: p_date IN DATE,
5102: p_billrep_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
5103: p_billrep_tbl_idx IN NUMBER,
5104: p_billrep_err_tbl IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
5105: p_billrep_err_tbl_idx IN OUT NOCOPY NUMBER,
5106: p_ar_feeder_ctr IN OUT NOCOPY NUMBER,
5107: p_return_status IN OUT NOCOPY VARCHAR2)
5108: IS

Line 5155: oks_bill_rec_pub.get_message(

5151: x_msg_data => l_msg_data,
5152: x_next_level_element => level_elements_tab );
5153:
5154: IF (l_return_status <> 'S') Then
5155: oks_bill_rec_pub.get_message(
5156: l_msg_cnt => l_msg_count,
5157: l_msg_data => l_msg_data);
5158: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
5159: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '||

Line 5194: OKS_BILL_REC_PUB.create_bank_Account(

5190: /*******
5191: create bank account is no longer needed as part of R12 Bank account
5192: consolidation project
5193:
5194: OKS_BILL_REC_PUB.create_bank_Account(
5195: P_DNZ_CHR_ID => p_dnz_chr_id,
5196: P_BILL_START_DATE => p_top_line_start_date,
5197: P_CURRENCY_CODE => p_currency_code,
5198: X_STATUS => l_return_status,

Line 5204: oks_bill_rec_pub.get_message(

5200: L_MSG_DATA => l_msg_data
5201: );
5202:
5203: IF (l_return_status <> 'S') THEN
5204: oks_bill_rec_pub.get_message(
5205: l_msg_cnt => l_msg_count,
5206: l_msg_data => l_msg_data);
5207: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
5208: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 5222: OKS_BILL_REC_PUB.Insert_bcl

5218: /*This procedure insert the into bill_con_lines,
5219: if the record is not already present for the same period.
5220: Since the out table returns the row_id of the inserted row, get_bcl_id
5221: which was present in earliar version is now removed*/
5222: OKS_BILL_REC_PUB.Insert_bcl
5223: (
5224: P_CALLEDFROM => l_called_from,
5225: X_RETURN_STAT => l_return_status,
5226: P_CLE_ID => p_top_line_id,

Line 5239: oks_bill_rec_pub.get_message(

5235: X_BCL_ID => l_bcl_id
5236: );
5237:
5238: IF (l_return_status <> 'S') THEN
5239: oks_bill_rec_pub.get_message(
5240: l_msg_cnt => l_msg_count,
5241: l_msg_data => l_msg_data);
5242: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
5243: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 5279: OKS_BILL_REC_PUB.Insert_all_subline

5275:
5276: IF (l_cov_tbl.count > 0) THEN
5277: /* check if this is to be passed back to main api */
5278: p_ar_feeder_ctr := 1;
5279: OKS_BILL_REC_PUB.Insert_all_subline
5280: (
5281: P_CALLEDFROM => l_called_from,
5282: X_RETURN_STAT => l_return_status,
5283: P_COVERED_TBL => l_cov_tbl,

Line 5296: oks_bill_rec_pub.get_message(

5292: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Status after insert into sublines '||l_return_status );
5293: END IF;
5294:
5295: IF (l_return_status <> 'S') THEN
5296: oks_bill_rec_pub.get_message(
5297: l_msg_cnt => l_msg_count,
5298: l_msg_data => l_msg_data);
5299: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N ' ;
5300: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 5511: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;

5507:
5508: --Start mchoudha Bug#3537100 17-APR-04
5509: --For Billing Report
5510:
5511: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;
5512: l_billrep_tbl_idx NUMBER;
5513: l_billrep_found BOOLEAN;
5514: j NUMBER;
5515: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;

Line 5515: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;

5511: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;
5512: l_billrep_tbl_idx NUMBER;
5513: l_billrep_found BOOLEAN;
5514: j NUMBER;
5515: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;
5516: l_billrep_errtbl_idx NUMBER;
5517:
5518: --End mchoudha Bug#3537100
5519:

Line 5915: oks_bill_rec_pub.get_message (

5911: P_BILLREP_ERR_TBL_IDX => l_billrep_errtbl_idx
5912: );
5913:
5914: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
5915: oks_bill_rec_pub.get_message (
5916: l_msg_cnt => l_msg_count,
5917: l_msg_data => l_msg_data);
5918: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
5919: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;

Line 5921: oks_bill_Rec_pub.Set_sub_line(

5917: l_msg_data => l_msg_data);
5918: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
5919: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
5920:
5921: oks_bill_Rec_pub.Set_sub_line(
5922: P_PROCESSED_LINES_TBL => l_processed_lines_tbl,
5923: P_PROCESSED_SUB_LINES_TBL => l_processed_sub_lines_tbl,
5924: P_ERROR_MESSAGE => l_processed_lines_tbl(l_pr_tbl_idx).Error_Message,
5925: P_TOP_LINE => l_bill_rec.id) ;

Line 6117: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;

6113: l_org_id NUMBER;
6114: l_flag NUMBER := 0;
6115: v_cursor NUMBER;
6116:
6117: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;
6118: l_billrep_tbl_idx NUMBER;
6119: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;
6120: l_billrep_errtbl_idx NUMBER;
6121: /*added for bug7668259*/

Line 6119: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;

6115: v_cursor NUMBER;
6116:
6117: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;
6118: l_billrep_tbl_idx NUMBER;
6119: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;
6120: l_billrep_errtbl_idx NUMBER;
6121: /*added for bug7668259*/
6122: l_hook NUMBER;
6123: l_date_interface_start DATE;

Line 7063: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;

7059: AND bcl.btn_id = -44;
7060:
7061:
7062:
7063: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;
7064: l_billrep_tbl_idx NUMBER;
7065: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;
7066: l_billrep_errtbl_idx NUMBER;
7067:

Line 7065: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;

7061:
7062:
7063: l_billrep_tbl OKS_BILL_REC_PUB.bill_report_tbl_type;
7064: l_billrep_tbl_idx NUMBER;
7065: l_billrep_err_tbl OKS_BILL_REC_PUB.billrep_error_tbl_type;
7066: l_billrep_errtbl_idx NUMBER;
7067:
7068:
7069: BEGIN

Line 7222: OKS_BILL_REC_PUB.GET_MESSAGE(

7218: p_billrep_err_tbl_idx => l_billrep_errtbl_idx
7219: ) ;
7220:
7221: IF (l_return_status <> 'S') THEN
7222: OKS_BILL_REC_PUB.GET_MESSAGE(
7223: l_msg_cnt => l_msg_cnt,
7224: l_msg_data => l_msg_data);
7225: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: Failed in AR FEEDER');
7226: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');