DBA Data[Home] [Help]

APPS.OKS_ARFEEDER_PUB dependencies on OKS_BILL_REC_PUB

Line 1875: oks_bill_rec_pub.get_message

1871: p_called_from
1872: );
1873:
1874: If l_return_status <> 'S' THEN
1875: oks_bill_rec_pub.get_message
1876: (l_msg_cnt => l_msg_cnt,
1877: l_msg_data => l_msg_data);
1878: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Sales_credit => Insert into RA_Interface_SalesCredit Failed For header id '||p_hdr_id);
1879:

Line 1905: oks_bill_rec_pub.get_message

1901:
1902:
1903:
1904: IF (l_return_status <> 'S') THEN
1905: oks_bill_rec_pub.get_message
1906: (L_MSG_CNT => l_msg_cnt,
1907: L_MSG_DATA => l_msg_data);
1908: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Sales_credit => Insert into RA_Interface_SalesCredit Failed For'||p_id);
1909:

Line 2204: P_BILLREP_TBL IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,

2200: P_CALLED_FROM IN NUMBER,
2201: P_DATE IN DATE,
2202: P_CLE_ID IN NUMBER,
2203: P_PRV IN NUMBER,
2204: P_BILLREP_TBL IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
2205: P_BILLREP_TBL_IDX IN NUMBER,
2206: P_BILLREP_ERR_TBL IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
2207: P_BILLREP_ERR_TBL_IDX IN OUT NOCOPY NUMBER
2208: ) Is

Line 2206: P_BILLREP_ERR_TBL IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,

2202: P_CLE_ID IN NUMBER,
2203: P_PRV IN NUMBER,
2204: P_BILLREP_TBL IN OUT NOCOPY OKS_BILL_REC_PUB.bill_report_tbl_type,
2205: P_BILLREP_TBL_IDX IN NUMBER,
2206: P_BILLREP_ERR_TBL IN OUT NOCOPY OKS_BILL_REC_PUB.billrep_error_tbl_type,
2207: P_BILLREP_ERR_TBL_IDX IN OUT NOCOPY NUMBER
2208: ) Is
2209:
2210: Cursor Cur_address_billto(p_id In Varchar2,Code Varchar2) IS

Line 3097: l_btn_pr_tbl_in(1).ID :=oks_bill_rec_pub.get_Seq_id;

3093: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After calling OKS_BILLTRAN_PUB.insert_Bill_Tran_Pub l_ret_status'||l_ret_stat);
3094: End If;
3095:
3096: ELSIF (p_prv = 2) THEN
3097: l_btn_pr_tbl_in(1).ID :=oks_bill_rec_pub.get_Seq_id;
3098: l_btn_pr_tbl_in(1).CURRENCY_CODE :=nvl(bcl_rec.CURRENCY_CODE,header_rec.CURRENCY_CODE);
3099: l_btn_pr_tbl_in(1).TRX_NUMBER := '-99';
3100: l_btn_pr_tbl_in(1).TRX_AMOUNT := NULL;
3101: l_btn_pr_tbl_in(1).TRX_CLASS := NULL;

Line 3154: oks_bill_rec_pub.get_message(

3150: If G_LOG_YES_NO = 'YES' then
3151: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into Bill_Transactions Failed For Line : '||Bcl_rec.cle_id);
3152: End If;
3153:
3154: oks_bill_rec_pub.get_message(
3155: l_msg_cnt => l_msg_cnt,
3156: l_msg_data => l_msg_data);
3157: IF (P_PRV <> 3) THEN
3158: x_msg_count := l_msg_cnt;

Line 3977: l_btl_pr_tbl_in(1).ID := oks_bill_rec_pub.get_seq_id;

3973: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After calling OKS_BILLTRAN_LINE_PUB.insert_Bill_Tran_Line_Pub l_return_status'||l_ret_stat);
3974: End If;
3975:
3976: ELSIF (p_prv = 2) THEN
3977: l_btl_pr_tbl_in(1).ID := oks_bill_rec_pub.get_seq_id;
3978: l_btl_pr_tbl_in(1).TRX_LINE_AMOUNT := Bcl_rec.amount;
3979: l_btl_pr_tbl_in(1).BSL_ID := NULL;
3980: l_btl_pr_tbl_in(1).OBJECT_VERSION_NUMBER := 1.0;
3981: l_btl_pr_tbl_in(1).CREATED_BY := FND_GLOBAL.user_id;

Line 4020: oks_bill_rec_pub.get_message

4016: END IF;
4017:
4018: IF (l_ret_stat <> 'S') THEN
4019: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER Insert into Bill_Tran_lines Failed For'||Bcl_rec.cle_id);
4020: oks_bill_rec_pub.get_message
4021: (l_msg_cnt => l_msg_cnt,
4022: l_msg_data => l_msg_data);
4023:
4024: IF (P_PRV <> 3) THEN

Line 4089: oks_bill_rec_pub.get_message

4085: );
4086:
4087: IF (l_ret_stat <> 'S') THEN
4088: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into RA_Interface_Lines Failed For'||Bcl_rec.cle_id);
4089: oks_bill_rec_pub.get_message
4090: (l_msg_cnt => l_msg_cnt,
4091: l_msg_data => l_msg_data);
4092:
4093:

Line 4316: l_btl_pr_tbl_in(1).ID := oks_bill_rec_pub.get_seq_id;

4312: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After call to insert bill_txn_lines l_return_status '||l_ret_stat);
4313: End If;
4314:
4315: ELSIF (p_prv =2 ) THEN
4316: l_btl_pr_tbl_in(1).ID := oks_bill_rec_pub.get_seq_id;
4317: l_btl_pr_tbl_in(1).TRX_LINE_AMOUNT := Bsl_rec.amount;
4318: l_btl_pr_tbl_in(1).BSL_ID := bsl_rec.id;
4319: l_btl_pr_tbl_in(1).OBJECT_VERSION_NUMBER := 1.0;
4320: l_btl_pr_tbl_in(1).CREATED_BY := FND_GLOBAL.user_id;

Line 4362: oks_bill_rec_pub.get_message

4358: END IF;
4359:
4360: IF (l_ret_stat <> 'S') THEN
4361: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into Bill_Tran_lines Failed For'||bsl_rec.cle_id);
4362: oks_bill_rec_pub.get_message
4363: (l_msg_cnt => l_msg_cnt,
4364: l_msg_data => l_msg_data);
4365:
4366: x_msg_count := l_msg_cnt;

Line 4523: oks_bill_rec_pub.get_message

4519:
4520: IF (l_ret_stat <> 'S') THEN
4521:
4522: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into RA_Interface_Lines Failed For'||bsl_rec.cle_id);
4523: oks_bill_rec_pub.get_message
4524: (l_msg_cnt => l_msg_cnt,
4525: l_msg_data => l_msg_data);
4526:
4527: x_msg_count := l_msg_cnt;

Line 4608: oks_bill_rec_pub.get_message

4604:
4605: IF (l_ret_stat <> 'S') THEN
4606:
4607: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into RA_Interface_Lines Failed For'||bsl_rec.cle_id);
4608: oks_bill_rec_pub.get_message
4609: (l_msg_cnt => l_msg_cnt,
4610: l_msg_data => l_msg_data);
4611:
4612: x_msg_count := l_msg_cnt;

Line 4629: oks_bill_rec_pub.get_message

4625: );
4626:
4627: IF (l_ret_stat <> 'S') THEN
4628: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into RA_Interface_Lines Failed For'||bsl_rec.cle_id);
4629: oks_bill_rec_pub.get_message
4630: (l_msg_cnt => l_msg_cnt,
4631: l_msg_data => l_msg_data);
4632:
4633: x_msg_count := l_msg_cnt;