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 FND_FILE

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 154: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error Get_target_qty returns Zero');

150: p_round_dec => 0
151: );
152:
153: IF Nvl(l_temp,0) = 0 THEN
154: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error Get_target_qty returns Zero');
155: Raise G_EXCEPTION_HALT_VALIDATION;
156: END IF;
157: l_minimum := Round((trunc(l_to_date) - trunc(l_from_date) + 1)
158: * (l_minimum /l_temp) ,0) ;

Line 229: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in Level Procedure --G_exception_halt_validation raised' || sqlerrm);

225: END LOOP;
226:
227: EXCEPTION
228: WHEN G_EXCEPTION_HALT_VALIDATION THEN
229: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in Level Procedure --G_exception_halt_validation raised' || sqlerrm);
230: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
231: WHEN OTHERS THEN
232: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in Level Procedure --OTHERS Exception raised' || sqlerrm);
233: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 232: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in Level Procedure --OTHERS Exception raised' || sqlerrm);

228: WHEN G_EXCEPTION_HALT_VALIDATION THEN
229: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in Level Procedure --G_exception_halt_validation raised' || sqlerrm);
230: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
231: WHEN OTHERS THEN
232: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in Level Procedure --OTHERS Exception raised' || sqlerrm);
233: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
234: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
235:
236: END level;

Line 296: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- G_Exception_halt_validation raised' );

292:
293:
294: EXCEPTION
295: WHEN G_EXCEPTION_HALT_VALIDATION THEN
296: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- G_Exception_halt_validation raised' );
297: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
298: WHEN OTHERS THEN
299: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- Others Exception raised' );
300: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,

Line 299: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- Others Exception raised' );

295: WHEN G_EXCEPTION_HALT_VALIDATION THEN
296: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- G_Exception_halt_validation raised' );
297: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
298: WHEN OTHERS THEN
299: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in OKS_REG_GET_AMCV -- Others Exception raised' );
300: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
301: G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
302: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
303:

Line 677: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Usage Item ');

673: usage_exception EXCEPTION;
674:
675: BEGIN
676: If l_write_log then
677: FND_FILE.PUT_LINE(FND_FILE.LOG,'***Processing Usage Item ***');
678: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Id: ' || p_top_line_id);
679: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Start Date: ' || p_top_line_start_date);
680: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));
681: End If;

Line 678: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Id: ' || p_top_line_id);

674:
675: BEGIN
676: If l_write_log then
677: FND_FILE.PUT_LINE(FND_FILE.LOG,'***Processing Usage Item ***');
678: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Id: ' || p_top_line_id);
679: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Start Date: ' || p_top_line_start_date);
680: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));
681: End If;
682:

Line 679: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Start Date: ' || p_top_line_start_date);

675: BEGIN
676: If l_write_log then
677: FND_FILE.PUT_LINE(FND_FILE.LOG,'***Processing Usage Item ***');
678: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Id: ' || p_top_line_id);
679: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Start Date: ' || p_top_line_start_date);
680: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));
681: End If;
682:
683:

Line 680: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));

676: If l_write_log then
677: FND_FILE.PUT_LINE(FND_FILE.LOG,'***Processing Usage Item ***');
678: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Id: ' || p_top_line_id);
679: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Start Date: ' || p_top_line_start_date);
680: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));
681: End If;
682:
683:
684: p_return_status := 'S';

Line 727: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in getting next level ');

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 ;
726:
727: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in getting next level ');
728:
729: /*Needs to determine or revisited */
730: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
731: Raise USAGE_EXCEPTION;

Line 776: FND_FILE.PUT_LINE( FND_FILE.LOG,'Line Interface Date :' ||l_inv_date );

772: l_bill_end_date := p_top_line_term_date - 1 ;
773: END IF;
774:
775: If l_write_log then
776: FND_FILE.PUT_LINE( FND_FILE.LOG,'Line Interface Date :' ||l_inv_date );
777: FND_FILE.PUT_LINE( FND_FILE.LOG,'Billing Period Start_date: ' || l_bill_start_date||' To '||l_bill_end_date);
778: End If;
779:
780: l_ptr := 0;

Line 777: FND_FILE.PUT_LINE( FND_FILE.LOG,'Billing Period Start_date: ' || l_bill_start_date||' To '||l_bill_end_date);

773: END IF;
774:
775: If l_write_log then
776: FND_FILE.PUT_LINE( FND_FILE.LOG,'Line Interface Date :' ||l_inv_date );
777: FND_FILE.PUT_LINE( FND_FILE.LOG,'Billing Period Start_date: ' || l_bill_start_date||' To '||l_bill_end_date);
778: End If;
779:
780: l_ptr := 0;
781: l_total := 0;

Line 808: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in creating account');

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 ;
807:
808: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in creating account');
809:
810:
811:
812: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION') ;

Line 853: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in insert bcl');

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 ;
853: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in insert bcl');
854:
855: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
856: Raise USAGE_EXCEPTION;
857: END IF;

Line 888: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in get next level of coverage ');

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 ;
886: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
887: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
888: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in get next level of coverage ');
889: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
890: Raise USAGE_EXCEPTION;
891: END IF;
892:

Line 905: FND_FILE.PUT_LINE( FND_FILE.LOG,' Coverage amount : '||l_amount);

901: l_calc_rec.l_calc_sdate := level_coverage(1).bill_from_date;
902: l_calc_rec.l_calc_edate := level_coverage(1).bill_to_date;
903:
904: IF (l_write_log) THEN
905: FND_FILE.PUT_LINE( FND_FILE.LOG,' Coverage amount : '||l_amount);
906: FND_FILE.PUT_LINE( FND_FILE.LOG,' Coverage start_date: '||l_calc_rec.l_calc_sdate);
907: FND_FILE.PUT_LINE( FND_FILE.LOG,' Coverage end_date : '||l_calc_rec.l_calc_edate);
908: END IF;
909:

Line 906: FND_FILE.PUT_LINE( FND_FILE.LOG,' Coverage start_date: '||l_calc_rec.l_calc_sdate);

902: l_calc_rec.l_calc_edate := level_coverage(1).bill_to_date;
903:
904: IF (l_write_log) THEN
905: FND_FILE.PUT_LINE( FND_FILE.LOG,' Coverage amount : '||l_amount);
906: FND_FILE.PUT_LINE( FND_FILE.LOG,' Coverage start_date: '||l_calc_rec.l_calc_sdate);
907: FND_FILE.PUT_LINE( FND_FILE.LOG,' Coverage end_date : '||l_calc_rec.l_calc_edate);
908: END IF;
909:
910: IF ( l_covlvl_rec.date_terminated is not null) AND

Line 907: FND_FILE.PUT_LINE( FND_FILE.LOG,' Coverage end_date : '||l_calc_rec.l_calc_edate);

903:
904: IF (l_write_log) THEN
905: FND_FILE.PUT_LINE( FND_FILE.LOG,' Coverage amount : '||l_amount);
906: FND_FILE.PUT_LINE( FND_FILE.LOG,' Coverage start_date: '||l_calc_rec.l_calc_sdate);
907: FND_FILE.PUT_LINE( FND_FILE.LOG,' Coverage end_date : '||l_calc_rec.l_calc_edate);
908: END IF;
909:
910: IF ( l_covlvl_rec.date_terminated is not null) AND
911: ( trunc(l_calc_rec.l_calc_edate) >=

Line 960: FND_FILE.PUT_LINE( FND_FILE.LOG, 'USAGE_TYPE of subline = NPR' );

956: l_cov_tbl(l_ptr).date_to_interface := sysdate;
957:
958: IF (l_usage_type = 'NPR') THEN
959: IF (l_write_log) THEN
960: FND_FILE.PUT_LINE( FND_FILE.LOG, 'USAGE_TYPE of subline = NPR' );
961: END IF;
962:
963: OPEN qty_uom_csr_sub(l_covlvl_rec.id);
964: FETCH qty_uom_csr_sub into l_qty_uom_sub_rec;

Line 977: FND_FILE.PUT_LINE( FND_FILE.LOG, 'USAGE_TYPE of subline = FRT');

973:
974:
975: ELSIF (l_usage_type = 'FRT') THEN
976: IF (l_write_log) THEN
977: FND_FILE.PUT_LINE( FND_FILE.LOG, 'USAGE_TYPE of subline = FRT');
978: END IF;
979:
980: l_qty := l_covlvl_rec.fixed_qty;
981:

Line 1007: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error Get_Prorated_Usage_Qty returns l_qty as '||l_qty);

1003: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
1004: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||' Target Quantity is zero ';
1005: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
1006: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||' Target Quantity is zero';
1007: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error Get_Prorated_Usage_Qty returns l_qty as '||l_qty);
1008:
1009: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1010: Raise USAGE_EXCEPTION;
1011: END IF;

Line 1028: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error Get_target_qty returns Zero');

1024: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
1025: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||' Target Quantity is zero ';
1026: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
1027: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||' Target Quantity is zero';
1028: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error Get_target_qty returns Zero');
1029:
1030: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1031: Raise USAGE_EXCEPTION;
1032: END IF;

Line 1102: FND_FILE.PUT_LINE( FND_FILE.LOG, 'After counter values X_value'||' '||l_qty);

1098: END IF;
1099:
1100:
1101: IF (l_write_log) THEN
1102: FND_FILE.PUT_LINE( FND_FILE.LOG, 'After counter values X_value'||' '||l_qty);
1103: END IF;
1104:
1105: l_cov_tbl(l_ptr).result :=nvl(l_qty, 0);
1106: l_cov_tbl(l_ptr).actual :=l_actual_qty ;

Line 1128: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Cll IB Lock '||l_lock_date||', Counter id '||l_counter_id);

1124: fetch get_counter_qty into l_lock_date, l_counter_id;
1125: close get_counter_qty;
1126:
1127: IF (l_write_log) THEN
1128: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Cll IB Lock '||l_lock_date||', Counter id '||l_counter_id);
1129: END IF;
1130:
1131: l_counter_reading_lock_rec.reading_lock_date := l_lock_date;
1132: l_counter_reading_lock_rec.counter_id := l_counter_id;

Line 1193: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Level '||' '||l_return_status);

1189: X_RETURN_STATUS => l_return_status
1190: );
1191:
1192: IF (l_write_log) THEN
1193: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Level '||' '||l_return_status);
1194: END IF;
1195:
1196: IF (l_return_status <> 'S') THEN
1197: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;

Line 1200: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in LEVEL ') ;

1196: IF (l_return_status <> 'S') THEN
1197: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
1198: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message:= 'Error: '|| sqlerrm||'. Error Message:' ;
1199:
1200: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in LEVEL ') ;
1201: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1202: Raise USAGE_EXCEPTION;
1203: END IF;
1204: END IF; -- l_usage_type in 'VRT','QTY'

Line 1278: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Price Calculated: '||l_price_rec.PROD_EXT_AMOUNT);

1274: );
1275:
1276:
1277: IF (l_write_log) THEN
1278: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Price Calculated: '||l_price_rec.PROD_EXT_AMOUNT);
1279: END IF;
1280:
1281: /*FOR BILLING REPORT*/
1282: l_exception_amount := l_price_rec.PROD_EXT_AMOUNT;

Line 1289: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Calculate Price Error'||' '||l_return_status);

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);
1290:
1291: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1292: Raise USAGE_EXCEPTION;
1293: END IF;

Line 1313: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error update bsl'||' '||l_return_status);

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);
1314: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1315: Raise USAGE_EXCEPTION;
1316: END IF;
1317:

Line 1542: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Service/Ext Warranty Item Starts');

1538: service_exception EXCEPTION;
1539: sub_service_exception EXCEPTION;
1540: BEGIN
1541: IF (l_write_log) THEN
1542: FND_FILE.PUT_LINE(FND_FILE.LOG,'***Processing Service/Ext Warranty Item Starts***');
1543: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Top Line Id: ' || p_top_line_id);
1544: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Top Line Start Date: ' || p_top_line_start_date);
1545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));
1546: END IF;

Line 1543: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Top Line Id: ' || p_top_line_id);

1539: sub_service_exception EXCEPTION;
1540: BEGIN
1541: IF (l_write_log) THEN
1542: FND_FILE.PUT_LINE(FND_FILE.LOG,'***Processing Service/Ext Warranty Item Starts***');
1543: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Top Line Id: ' || p_top_line_id);
1544: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Top Line Start Date: ' || p_top_line_start_date);
1545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));
1546: END IF;
1547:

Line 1544: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Top Line Start Date: ' || p_top_line_start_date);

1540: BEGIN
1541: IF (l_write_log) THEN
1542: FND_FILE.PUT_LINE(FND_FILE.LOG,'***Processing Service/Ext Warranty Item Starts***');
1543: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Top Line Id: ' || p_top_line_id);
1544: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Top Line Start Date: ' || p_top_line_start_date);
1545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));
1546: END IF;
1547:
1548: p_return_status := 'S';

Line 1545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));

1541: IF (l_write_log) THEN
1542: FND_FILE.PUT_LINE(FND_FILE.LOG,'***Processing Service/Ext Warranty Item Starts***');
1543: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Top Line Id: ' || p_top_line_id);
1544: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Top Line Start Date: ' || p_top_line_start_date);
1545: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));
1546: END IF;
1547:
1548: p_return_status := 'S';
1549: l_level_elements_count := 0;

Line 1570: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Going to process all sublines for top line '||p_top_line_id);

1566: END IF;
1567:
1568: --End mchoudha Bug#3537100
1569: IF (l_write_log) THEN
1570: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Going to process all sublines for top line '||p_top_line_id);
1571: END IF;
1572:
1573: FOR l_covlvl_rec in l_subline_csr(p_top_line_id )
1574: LOOP

Line 1580: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => inside FOR l_covlvl_rec Processing Coverage Id: '||l_covlvl_rec.id);

1576:
1577: /*FOR BILLING REPORT*/
1578: l_subline_id := l_covlvl_rec.id;
1579: IF (l_write_log) THEN
1580: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => inside FOR l_covlvl_rec Processing Coverage Id: '||l_covlvl_rec.id);
1581: END IF;
1582:
1583: level_elements_tab.delete;
1584:

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

1593: X_MSG_DATA => l_msg_data,
1594: X_NEXT_LEVEL_ELEMENT => level_elements_tab );
1595:
1596: IF (l_write_log) THEN
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

Line 1610: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed in Creation of get_next_level_element For coverage Id: '||l_covlvl_rec.id );

1606: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
1607: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
1608: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
1609:
1610: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed in Creation of get_next_level_element For coverage Id: '||l_covlvl_rec.id );
1611: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );
1612:
1613: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1614:

Line 1611: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );

1607: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
1608: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
1609:
1610: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed in Creation of get_next_level_element For coverage Id: '||l_covlvl_rec.id );
1611: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );
1612:
1613: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1614:
1615: RAISE sub_service_exception;

Line 1630: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of Period for coverage: ' || no_of_cycles);

1626:
1627: l_level_elements_count := l_level_elements_count + level_elements_tab.count;
1628:
1629: IF (l_write_log) THEN
1630: FND_FILE.PUT_LINE(FND_FILE.LOG,'No of Period for coverage: ' || no_of_cycles);
1631: END IF;
1632:
1633: OPEN qty_uom_csr(l_covlvl_rec.id);
1634: FETCH qty_uom_csr into qty_uom_rec;

Line 1638: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Going inside WHILE (e_ptr <= no_of_cycles) ');

1634: FETCH qty_uom_csr into qty_uom_rec;
1635: CLOSE qty_uom_csr;
1636:
1637: IF (l_write_log) THEN
1638: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Going inside WHILE (e_ptr <= no_of_cycles) ');
1639: END IF;
1640:
1641: WHILE (e_ptr <= no_of_cycles)
1642: LOOP

Line 1662: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage Interface Date: '||l_inv_date);

1658: l_calc_rec.l_calc_edate := l_covlvl_rec.date_terminated - 1;
1659: END IF;
1660:
1661: IF (l_write_log) THEN
1662: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage Interface Date: '||l_inv_date);
1663: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage Amount : ' || l_amount);
1664: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage Start Date : '||l_calc_rec.l_calc_sdate);
1665: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage End Date : '||l_calc_rec.l_calc_edate);
1666: END IF;

Line 1663: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage Amount : ' || l_amount);

1659: END IF;
1660:
1661: IF (l_write_log) THEN
1662: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage Interface Date: '||l_inv_date);
1663: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage Amount : ' || l_amount);
1664: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage Start Date : '||l_calc_rec.l_calc_sdate);
1665: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage End Date : '||l_calc_rec.l_calc_edate);
1666: END IF;
1667:

Line 1664: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage Start Date : '||l_calc_rec.l_calc_sdate);

1660:
1661: IF (l_write_log) THEN
1662: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage Interface Date: '||l_inv_date);
1663: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage Amount : ' || l_amount);
1664: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage Start Date : '||l_calc_rec.l_calc_sdate);
1665: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage End Date : '||l_calc_rec.l_calc_edate);
1666: END IF;
1667:
1668: IF (trunc(l_inv_date) <= trunc(p_date)) THEN

Line 1665: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage End Date : '||l_calc_rec.l_calc_edate);

1661: IF (l_write_log) THEN
1662: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage Interface Date: '||l_inv_date);
1663: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage Amount : ' || l_amount);
1664: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage Start Date : '||l_calc_rec.l_calc_sdate);
1665: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => Coverage End Date : '||l_calc_rec.l_calc_edate);
1666: END IF;
1667:
1668: IF (trunc(l_inv_date) <= trunc(p_date)) THEN
1669:

Line 1676: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => l_ar_inv_date '||l_ar_inv_date);

1672: l_ar_inv_date := sysdate;
1673: END IF;
1674:
1675: IF (l_write_log) THEN
1676: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => l_ar_inv_date '||l_ar_inv_date);
1677: END IF;
1678:
1679: l_ptr := 1;
1680:

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 1708: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed in Creation of bank account For coverage Id: '||l_covlvl_rec.id );

1704: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
1705: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
1706: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
1707:
1708: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed in Creation of bank account For coverage Id: '||l_covlvl_rec.id );
1709: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );
1710:
1711: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1712:

Line 1709: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );

1705: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
1706: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
1707:
1708: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed in Creation of bank account For coverage Id: '||l_covlvl_rec.id );
1709: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );
1710:
1711: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1712:
1713: RAISE sub_service_exception;

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 1746: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed in Insert BCL For coverage Id: ' ||l_covlvl_rec.id );

1742: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
1743: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
1744: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
1745:
1746: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed in Insert BCL For coverage Id: ' ||l_covlvl_rec.id );
1747: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );
1748:
1749: RAISE sub_service_exception;
1750: END IF;

Line 1747: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );

1743: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
1744: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
1745:
1746: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed in Insert BCL For coverage Id: ' ||l_covlvl_rec.id );
1747: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );
1748:
1749: RAISE sub_service_exception;
1750: END IF;
1751:

Line 1780: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => l_cov_tbl.count '||l_cov_tbl.count);

1776:
1777: END IF; -- (trunc(l_inv_date) <= trunc(p_date))
1778:
1779: IF ( l_write_log) THEN
1780: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => l_cov_tbl.count '||l_cov_tbl.count);
1781: END IF;
1782:
1783: IF (l_cov_tbl.count > 0) THEN
1784: p_ar_feeder_ctr := 1;

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 1812: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Bill_Service_Item => Insert into sublines table failed Contract line id :'||p_top_line_id);

1808: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
1809: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
1810: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
1811:
1812: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Bill_Service_Item => Insert into sublines table failed Contract line id :'||p_top_line_id);
1813: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );
1814: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1815: RAISE sub_service_exception;
1816: END IF;

Line 1813: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );

1809: l_processed_sub_lines_tbl(l_prs_tbl_idx).Billed_YN := 'N' ;
1810: l_processed_sub_lines_tbl(l_prs_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
1811:
1812: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Bill_Service_Item => Insert into sublines table failed Contract line id :'||p_top_line_id);
1813: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Rolling Back the Whole Service With Top Line ID: '||p_top_line_id );
1814: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1815: RAISE sub_service_exception;
1816: END IF;
1817:

Line 1829: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After updating oks_level_elements ');

1825: AND date_start <= l_calc_rec.l_calc_sdate;
1826: END IF;
1827:
1828: IF (l_write_log) THEN
1829: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After updating oks_level_elements ');
1830: END IF;
1831:
1832: e_ptr := e_ptr + 1;
1833:

Line 1876: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed- sub_service_exception exception raised for coverage: '||l_covlvl_rec.id||' With Error: '||sqlerrm );

1872: p_billrep_err_tbl(p_billrep_err_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
1873:
1874: END IF;
1875:
1876: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed- sub_service_exception exception raised for coverage: '||l_covlvl_rec.id||' With Error: '||sqlerrm );
1877: EXIT;
1878: WHEN OTHERS THEN
1879: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
1880: /* FOR BILLING REPORT */

Line 1906: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed- when others exception raised for coverage '||l_covlvl_rec.id||' With Error: '||sqlerrm );

1902: p_billrep_err_tbl(p_billrep_err_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
1903:
1904: END IF;
1905: p_return_status := 'E';
1906: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed- when others exception raised for coverage '||l_covlvl_rec.id||' With Error: '||sqlerrm );
1907: EXIT;
1908: END;
1909: END LOOP; -- FOR loop for covered level
1910:

Line 1933: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Service/Ext Warranty Item Ends ');

1929: l_processed_lines_tbl.DELETE(l_pr_tbl_idx) ;
1930: END IF;
1931:
1932: IF (l_write_log) THEN
1933: FND_FILE.PUT_LINE(FND_FILE.LOG,'***Processing Service/Ext Warranty Item Ends ***');
1934: END IF;
1935:
1936:
1937: EXCEPTION

Line 1945: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed- when SERVICE_EXCEPTION exception raised '||sqlerrm );

1941: IF (l_summary_yn = 'Y') THEN
1942: p_billrep_tbl(p_billrep_tbl_idx).Rejected_Lines := p_billrep_tbl(p_billrep_tbl_idx).Rejected_Lines + 1;
1943: p_billrep_tbl(p_billrep_tbl_idx).Rejected_Lines_Value := p_billrep_tbl(p_billrep_tbl_idx).Rejected_Lines_Value + nvl(l_line_total,0);
1944: END IF;
1945: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed- when SERVICE_EXCEPTION exception raised '||sqlerrm );
1946: WHEN OTHERS THEN
1947: p_return_status := 'E';
1948: /* FOR BILLING REPORT */
1949: IF (l_summary_yn = 'Y') THEN

Line 1953: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed-outside when OTHERS exception raised '||sqlerrm );

1949: IF (l_summary_yn = 'Y') THEN
1950: p_billrep_tbl(p_billrep_tbl_idx).Rejected_Lines := p_billrep_tbl(p_billrep_tbl_idx).Rejected_Lines + 1;
1951: p_billrep_tbl(p_billrep_tbl_idx).Rejected_Lines_Value := p_billrep_tbl(p_billrep_tbl_idx).Rejected_Lines_Value + nvl(l_line_total,0);
1952: END IF;
1953: FND_FILE.PUT_LINE( FND_FILE.LOG,'Bill_Service_Item => Failed-outside when OTHERS exception raised '||sqlerrm );
1954: END Bill_Service_Item;
1955:
1956:
1957: Procedure Bill_Subscription_item(

Line 2004: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Subscription Item ');

2000: p_return_status := 'S';
2001: level_elements_tab.delete;
2002:
2003: IF (l_write_log) THEN
2004: FND_FILE.PUT_LINE(FND_FILE.LOG,'***Processing Subscription Item ***');
2005: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Id: ' || p_top_line_id);
2006: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Start Date: ' || p_top_line_start_date);
2007: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));
2008: END IF;

Line 2005: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Id: ' || p_top_line_id);

2001: level_elements_tab.delete;
2002:
2003: IF (l_write_log) THEN
2004: FND_FILE.PUT_LINE(FND_FILE.LOG,'***Processing Subscription Item ***');
2005: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Id: ' || p_top_line_id);
2006: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Start Date: ' || p_top_line_start_date);
2007: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));
2008: END IF;
2009:

Line 2006: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Start Date: ' || p_top_line_start_date);

2002:
2003: IF (l_write_log) THEN
2004: FND_FILE.PUT_LINE(FND_FILE.LOG,'***Processing Subscription Item ***');
2005: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Id: ' || p_top_line_id);
2006: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Start Date: ' || p_top_line_start_date);
2007: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));
2008: END IF;
2009:
2010: oks_bill_util_pub.get_next_level_element(

Line 2007: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));

2003: IF (l_write_log) THEN
2004: FND_FILE.PUT_LINE(FND_FILE.LOG,'***Processing Subscription Item ***');
2005: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Id: ' || p_top_line_id);
2006: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Start Date: ' || p_top_line_start_date);
2007: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));
2008: END IF;
2009:
2010: oks_bill_util_pub.get_next_level_element(
2011: p_api_version => l_api_version,

Line 2029: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in getting next level ');

2025: l_processed_lines_tbl(l_pr_tbl_idx).Billed_YN := 'N' ;
2026: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '||
2027: sqlerrm||'. Error Message: '||l_msg_data ;
2028:
2029: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in getting next level ');
2030:
2031: Raise SUBSRIPTION_EXCEPTION;
2032: END IF;
2033:

Line 2078: FND_FILE.PUT_LINE( FND_FILE.LOG,' Failed in Creation of bank account');

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 ;
2076:
2077: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2078: FND_FILE.PUT_LINE( FND_FILE.LOG,' Failed in Creation of bank account');
2079: FND_FILE.PUT_LINE( FND_FILE.LOG,' Rolling Back the Whole Service '||p_top_line_id );
2080:
2081: RAISE SUBSRIPTION_EXCEPTION;
2082: END IF;

Line 2079: FND_FILE.PUT_LINE( FND_FILE.LOG,' Rolling Back the Whole Service '||p_top_line_id );

2075: l_processed_lines_tbl(l_pr_tbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
2076:
2077: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2078: FND_FILE.PUT_LINE( FND_FILE.LOG,' Failed in Creation of bank account');
2079: FND_FILE.PUT_LINE( FND_FILE.LOG,' Rolling Back the Whole Service '||p_top_line_id );
2080:
2081: RAISE SUBSRIPTION_EXCEPTION;
2082: END IF;
2083: ***/

Line 2112: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in insert bcl ');

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 ;
2111:
2112: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Failed in insert bcl ');
2113: Raise SUBSRIPTION_EXCEPTION;
2114: END IF;
2115:
2116: IF (p_prv <> 2) THEN

Line 2159: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Status after insert into sublines '||l_return_status );

2155: P_MSG_DATA => l_msg_data
2156: );
2157:
2158: IF (l_write_log) THEN
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(

Line 2168: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Insert into sublines table failed Contract line id : '||p_top_line_id);

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 ;
2168: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Insert into sublines table failed Contract line id : '||p_top_line_id);
2169: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION ');
2170: Raise SUBSRIPTION_EXCEPTION;
2171: END IF;
2172:

Line 2248: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => After calling OKC_CVM_PVT.update_contract_version l_return_status '||l_return_status);

2244: P_CVMV_REC => l_cvmv_rec,
2245: X_CVMV_REC => l_cvmv_out_rec);
2246:
2247: IF l_write_log THEN
2248: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => After calling OKC_CVM_PVT.update_contract_version l_return_status '||l_return_status);
2249: END IF;
2250:
2251: l_chrv_rec.id := p_dnz_chr_id;
2252: l_chrv_rec.last_update_date := sysdate;

Line 2265: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => After calling OKC_CONTRACT_PUB.update_contract_header l_return_status '||l_return_status);

2261: P_CHRV_REC => l_chrv_rec,
2262: X_CHRV_REC => l_chrv_out_rec);
2263:
2264: IF l_write_log THEN
2265: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => After calling OKC_CONTRACT_PUB.update_contract_header l_return_status '||l_return_status);
2266: END IF;
2267:
2268: COMMIT;
2269:

Line 2274: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Failed- updating version'||sqlerrm );

2270: END IF;
2271:
2272: EXCEPTION
2273: WHEN OTHERS THEN
2274: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Failed- updating version'||sqlerrm );
2275:
2276: End update_version;
2277:
2278:

Line 2470: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => OKS: Billing Report And Log is set to '||l_yes_no);

2466:
2467: --mchoudha Fix for bug#4198616
2468: --initializing the variables in case of parallel workers
2469: l_yes_no := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');
2470: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => OKS: Billing Report And Log is set to '||l_yes_no);
2471:
2472: If l_write_log then
2473: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill processing starts ');
2474: End If;

Line 2473: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill processing starts ');

2469: l_yes_no := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');
2470: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => OKS: Billing Report And Log is set to '||l_yes_no);
2471:
2472: If l_write_log then
2473: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill processing starts ');
2474: End If;
2475:
2476: If l_yes_no = 'YES' then
2477: l_write_log := TRUE;

Line 2490: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Time Units Of measure not set for DAY');

2486: FETCH l_uom_csr into l_uom_code;
2487: CLOSE l_uom_csr;
2488:
2489: IF l_uom_code Is Null Then
2490: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Time Units Of measure not set for DAY');
2491: Raise G_EXCEPTION_HALT_VALIDATION;
2492: END IF;
2493:
2494: --/*Set The p_date which is used to control the program*/

Line 2509: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => Opening billing_process cursor from '||p_process_from||' to '||p_process_to);

2505: l_billrep_errtbl_idx := -1 ;
2506: --End mchoudha Bug#3537100
2507:
2508: If l_write_log then
2509: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => Opening billing_process cursor from '||p_process_from||' to '||p_process_to);
2510: End If;
2511:
2512:
2513:

Line 2521: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => After Fetch billing_process cursor count of line ids fetched '||cle_id.count);

2517: FETCH billing_process bulk collect
2518: INTO chr_id, cle_id,l_line_no LIMIT 10000;
2519:
2520: If l_write_log then
2521: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => After Fetch billing_process cursor count of line ids fetched '||cle_id.count);
2522: End If;
2523:
2524: IF cle_id.COUNT > 0 THEN --chk for count
2525:

Line 2535: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 opening cursor l_bill_line_csr line id '||cle_id(i)||' header ID '||chr_id(i)||' line number '||l_line_no(i));

2531:
2532: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
2533:
2534: IF l_write_log THEN
2535: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 opening cursor l_bill_line_csr line id '||cle_id(i)||' header ID '||chr_id(i)||' line number '||l_line_no(i));
2536: END IF;
2537:
2538: /*****
2539: The policy context is set to multiple for Bug# 6158988

Line 2549: FND_FILE.PUT_LINE(FND_FILE.LOG,'not found l_bill_line_csr for line id '||cle_id(i)||' for contract id '||chr_id(i));

2545:
2546: OPEN l_bill_line_csr (chr_id(i),cle_id(i));
2547: FETCH l_bill_line_csr into l_bill_rec ;
2548: IF (l_bill_line_csr%notfound) THEN
2549: FND_FILE.PUT_LINE(FND_FILE.LOG,'not found l_bill_line_csr for line id '||cle_id(i)||' for contract id '||chr_id(i));
2550: CLOSE l_bill_line_csr;
2551: RAISE MAIN_LINE_EXCEPTION;
2552: END IF;
2553: CLOSE l_bill_line_csr;

Line 2560: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Contract# : '||l_bill_rec.Contract_number);

2556: l_select_counter := l_select_counter + 1;
2557: l_ar_Feeder_ctr := 0;
2558:
2559: IF l_write_log THEN
2560: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Contract# : '||l_bill_rec.Contract_number);
2561: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Modifier: '||l_bill_rec.Contract_number_modifier);
2562: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Parameter Default Date ' || P_date);
2563: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Period Start# : '||l_bill_rec.period_start);
2564: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Period Type: '||l_bill_rec.period_type);

Line 2561: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Modifier: '||l_bill_rec.Contract_number_modifier);

2557: l_ar_Feeder_ctr := 0;
2558:
2559: IF l_write_log THEN
2560: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Contract# : '||l_bill_rec.Contract_number);
2561: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Modifier: '||l_bill_rec.Contract_number_modifier);
2562: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Parameter Default Date ' || P_date);
2563: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Period Start# : '||l_bill_rec.period_start);
2564: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Period Type: '||l_bill_rec.period_type);
2565: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Price_uom ' ||l_bill_rec.price_uom);

Line 2562: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Parameter Default Date ' || P_date);

2558:
2559: IF l_write_log THEN
2560: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Contract# : '||l_bill_rec.Contract_number);
2561: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Modifier: '||l_bill_rec.Contract_number_modifier);
2562: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Parameter Default Date ' || P_date);
2563: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Period Start# : '||l_bill_rec.period_start);
2564: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Period Type: '||l_bill_rec.period_type);
2565: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Price_uom ' ||l_bill_rec.price_uom);
2566: END IF;

Line 2563: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Period Start# : '||l_bill_rec.period_start);

2559: IF l_write_log THEN
2560: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Contract# : '||l_bill_rec.Contract_number);
2561: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Modifier: '||l_bill_rec.Contract_number_modifier);
2562: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Parameter Default Date ' || P_date);
2563: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Period Start# : '||l_bill_rec.period_start);
2564: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Period Type: '||l_bill_rec.period_type);
2565: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Price_uom ' ||l_bill_rec.price_uom);
2566: END IF;
2567:

Line 2564: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Period Type: '||l_bill_rec.period_type);

2560: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Contract# : '||l_bill_rec.Contract_number);
2561: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Modifier: '||l_bill_rec.Contract_number_modifier);
2562: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Parameter Default Date ' || P_date);
2563: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Period Start# : '||l_bill_rec.period_start);
2564: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Period Type: '||l_bill_rec.period_type);
2565: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Price_uom ' ||l_bill_rec.price_uom);
2566: END IF;
2567:
2568: -- Commented as part of R12. Authoring org id changed to org_id (MOAC)

Line 2565: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Price_uom ' ||l_bill_rec.price_uom);

2561: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Modifier: '||l_bill_rec.Contract_number_modifier);
2562: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Parameter Default Date ' || P_date);
2563: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Period Start# : '||l_bill_rec.period_start);
2564: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Period Type: '||l_bill_rec.period_type);
2565: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Price_uom ' ||l_bill_rec.price_uom);
2566: END IF;
2567:
2568: -- Commented as part of R12. Authoring org id changed to org_id (MOAC)
2569: -- okc_context.set_okc_org_context(l_bill_Rec.authoring_org_id, Null);

Line 2573: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => After setting okc_context.set_okc_org_context for org '||l_bill_Rec.org_id);

2569: -- okc_context.set_okc_org_context(l_bill_Rec.authoring_org_id, Null);
2570: okc_context.set_okc_org_context(l_bill_Rec.org_id, Null);
2571:
2572: IF l_write_log THEN
2573: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => After setting okc_context.set_okc_org_context for org '||l_bill_Rec.org_id);
2574: END IF;
2575:
2576:
2577: l_okl_flag := 0; --- check for OKL contract

Line 2584: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 opening cursor l_bill_line_csr l_okl_flag '||l_okl_flag);

2580: FETCH l_okl_contract_csr into l_okl_flag;
2581: CLOSE l_okl_contract_csr;
2582:
2583: If l_write_log then
2584: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 opening cursor l_bill_line_csr l_okl_flag '||l_okl_flag);
2585: End If;
2586:
2587: /*Invoices are to be generated only for contracts whose
2588: AR_interface_flag = 'Y'

Line 2591: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => l_bill_rec.ar_interface_yn '||Nvl(l_bill_rec.ar_interface_yn,'Y'));

2587: /*Invoices are to be generated only for contracts whose
2588: AR_interface_flag = 'Y'
2589: */
2590: If l_write_log then
2591: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => l_bill_rec.ar_interface_yn '||Nvl(l_bill_rec.ar_interface_yn,'Y'));
2592: End If;
2593:
2594: IF Nvl(l_bill_rec.ar_interface_yn,'Y') = 'Y' THEN -- {
2595:

Line 2605: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 initializing Billing Report ');

2601:
2602:
2603:
2604: If l_write_log then
2605: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 initializing Billing Report ');
2606: End If;
2607:
2608: l_billrep_found := FALSE;
2609:

Line 2638: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => After initializing Billing Report ');

2634: l_billrep_tbl(l_billrep_tbl_idx).Rejected_SubLines_Value := 0;
2635: END IF;
2636:
2637: If l_write_log then
2638: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => After initializing Billing Report ');
2639: End If;
2640:
2641: --End mchoudha Bug#3537100
2642:

Line 2648: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => After opening qty_uom_csr uom_code '||qty_uom_rec.uom_code);

2644: FETCH qty_uom_csr into qty_uom_rec;
2645: CLOSE qty_uom_csr;
2646:
2647: If l_write_log then
2648: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => After opening qty_uom_csr uom_code '||qty_uom_rec.uom_code);
2649: End If;
2650:
2651:
2652: IF (l_bill_rec.lse_id = 46) THEN

Line 2655: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 calling Bill_Subscription_item for '||l_bill_rec.id);

2651:
2652: IF (l_bill_rec.lse_id = 46) THEN
2653: -----------------------------------------------------------------
2654: If l_write_log then
2655: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 calling Bill_Subscription_item for '||l_bill_rec.id);
2656: End If;
2657:
2658: Bill_Subscription_item(
2659: l_bill_rec.dnz_chr_id,

Line 2687: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 calling Bill_Service_item for '||l_bill_rec.id);

2683: ELSIF (l_bill_rec.lse_id in (1,19)) Then
2684: --Process_service_items
2685: -----------------------------------------------------------------
2686: If l_write_log then
2687: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 calling Bill_Service_item for '||l_bill_rec.id);
2688: End If;
2689:
2690: Bill_Service_item(
2691: l_bill_rec.dnz_chr_id,

Line 2727: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 calling Bill_Usage_Item for '||l_bill_rec.id);

2723:
2724: ELSIF (l_bill_rec.lse_id = 12) THEN
2725: -- Process_usage_items
2726: If l_write_log then
2727: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 calling Bill_Usage_Item for '||l_bill_rec.id);
2728: End If;
2729: -------------------------------------------------------------------------
2730: -- Begin partial period computation logic
2731: -- Developer Mani Choudhary

Line 2777: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 calling OKS_ARFEEDER_PUB.Get_REC_FEEDER for '||l_bill_rec.id);

2773:
2774:
2775: IF (l_ar_feeder_ctr = 1 ) THEN
2776: If l_write_log then
2777: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => B4 calling OKS_ARFEEDER_PUB.Get_REC_FEEDER for '||l_bill_rec.id);
2778: End If;
2779:
2780: OKS_ARFEEDER_PUB.Get_REC_FEEDER
2781: (

Line 2809: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => Failed in AR FEEDER :'||' '||l_bill_rec.id);

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) ;
2808:
2809: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => Failed in AR FEEDER :'||' '||l_bill_rec.id);
2810:
2811: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2812: Raise Main_Line_Exception;
2813: END IF;

Line 2836: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => MAIN LINE EXCEPTION RAISE'||' '||sqlerrm);

2832: --Added by pmallara begin exception block to fix bug#3961046
2833: BEGIN
2834: l_reject_counter := l_reject_counter + 1;
2835: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2836: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => MAIN LINE EXCEPTION RAISE'||' '||sqlerrm);
2837: RETCODE := 1;
2838: EXCEPTION
2839: WHEN OTHERS THEN
2840: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Failed- when trying to rollback inside MAIN_LINE_EXCEPTION '||sqlerrm );

Line 2840: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Failed- when trying to rollback inside MAIN_LINE_EXCEPTION '||sqlerrm );

2836: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => MAIN LINE EXCEPTION RAISE'||' '||sqlerrm);
2837: RETCODE := 1;
2838: EXCEPTION
2839: WHEN OTHERS THEN
2840: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Failed- when trying to rollback inside MAIN_LINE_EXCEPTION '||sqlerrm );
2841: exit;
2842: END;
2843:
2844: WHEN OTHERS THEN

Line 2859: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Failed- when others exception raised in Mainline loop '||sqlerrm );

2855: l_billrep_err_tbl(l_billrep_errtbl_idx).Error_Message := 'Error: '|| sqlerrm||'. Error Message: '||l_msg_data ;
2856:
2857: l_reject_counter := l_reject_counter + 1;
2858: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2859: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Failed- when others exception raised in Mainline loop '||sqlerrm );
2860: RETCODE := 1;
2861:
2862: --Bug#5378184
2863: l_err_code := substr(sqlerrm,instr(sqlerrm,'-')+1,5);

Line 2871: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Failed- when trying to rollback inside WHEN OTHERS exception'||sqlerrm );

2867: --End Bug#5378184
2868:
2869: EXCEPTION
2870: WHEN OTHERS THEN
2871: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => Failed- when trying to rollback inside WHEN OTHERS exception'||sqlerrm );
2872: exit;
2873: END;
2874: END;
2875: END LOOP; --end of loop for cle_id tbl

Line 2897: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => * Failed to create Billing Report *' );

2893: ,p_line_to => P_process_to
2894: ,x_return_status => l_return_status);
2895:
2896: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2897: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_BILLING_PUB.Calculate_bill => *** Failed to create Billing Report ***' );
2898: END IF;
2899: End If;
2900:
2901: If l_write_log then

Line 2902: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill processing Ends ');

2898: END IF;
2899: End If;
2900:
2901: If l_write_log then
2902: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill processing Ends ');
2903: End If;
2904:
2905: ---- Added if clause to issue warning for any data related issue
2906: IF (RETCODE <> 1) THEN

Line 2915: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);

2911:
2912: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2913: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2914: RETCODE := 2;
2915: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);
2916: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2917: WHEN G_EXCEPTION_ROLLBACK THEN
2918: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);
2919: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

Line 2918: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);

2914: RETCODE := 2;
2915: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);
2916: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2917: WHEN G_EXCEPTION_ROLLBACK THEN
2918: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when g_exception_rollback raised'||sqlerrm);
2919: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2920:
2921: WHEN OTHERS THEN
2922: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2924: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when others raised'||sqlerrm);

2920:
2921: WHEN OTHERS THEN
2922: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2923: RETCODE := 2;
2924: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => when others raised'||sqlerrm);
2925: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
2926: G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
2927: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
2928:

Line 2983: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main Starts');

2979: l_billrep_errtbl_idx NUMBER;
2980:
2981: BEGIN
2982:
2983: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main Starts');
2984:
2985: l_yes_no := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');
2986:
2987: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main => OKS: Billing Report And Log is set to '||l_yes_no);

Line 2987: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main => OKS: Billing Report And Log is set to '||l_yes_no);

2983: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main Starts');
2984:
2985: l_yes_no := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');
2986:
2987: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main => OKS: Billing Report And Log is set to '||l_yes_no);
2988:
2989: If l_yes_no = 'YES' then
2990: l_write_log := TRUE;
2991: l_write_report := TRUE;

Line 3003: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => parameter Org ID is '||l_org_id);

2999: --mchoudha fixed bug#4729936
3000: --IF (nvl(fnd_profile.value('OKC_VIEW_K_BY_ORG'),'N') = 'Y' ) THEN
3001: -- l_org_id := fnd_profile.value('ORG_ID');
3002: If l_write_log then
3003: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => parameter Org ID is '||l_org_id);
3004: End If;
3005: -- END IF;
3006:
3007: If l_write_log then

Line 3008: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Preview Y/N ='||P_process);

3004: End If;
3005: -- END IF;
3006:
3007: If l_write_log then
3008: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Preview Y/N ='||P_process);
3009: End If;
3010:
3011: /* Set p_prv flag, which is used to in calls to AR Feeder.
3012: p_prv = 2 -- preview billing

Line 3022: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => User_Id ='||to_char(user_id));

3018: END IF;
3019:
3020: user_id := FND_GLOBAL.USER_ID;
3021: If l_write_log then
3022: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => User_Id ='||to_char(user_id));
3023: End If;
3024:
3025: --nechatur 29-Nov-2005 for bug#4459229
3026: --p_date := nvl(trunc(p_default_date),trunc(sysdate));

Line 3038: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Truncating oks_process_billing');

3034: --truncated during the restart of the parent
3035: If(FND_CONC_GLOBAL.request_data is null) THEN
3036:
3037: If l_write_log then
3038: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Truncating oks_process_billing');
3039: End If;
3040:
3041: v_cursor := DBMS_SQL.OPEN_CURSOR;
3042: /*Following line is required to avoid GSCC errors at ARU creation.

Line 3062: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Call to OKS_ARFEEDER_PUB.Get_REC_FEEDER to interface termination records');

3058: */
3059: IF (FND_CONC_GLOBAL.request_data is null) THEN -- not a restart of parent
3060:
3061: If l_write_log then
3062: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Call to OKS_ARFEEDER_PUB.Get_REC_FEEDER to interface termination records');
3063: End If;
3064:
3065: OKS_ARFEEDER_PUB.Get_REC_FEEDER
3066: (

Line 3082: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => After Call to OKS_ARFEEDER_PUB.Get_REC_FEEDER to interface termination records l_return_status '||l_return_status);

3078: p_billrep_err_tbl_idx => l_billrep_errtbl_idx
3079: ) ;
3080:
3081: If l_write_log then
3082: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => After Call to OKS_ARFEEDER_PUB.Get_REC_FEEDER to interface termination records l_return_status '||l_return_status);
3083: End If;
3084:
3085:
3086: -- We need to see if we should spawn sub-requests;

Line 3098: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameters Passed => Contract Id '||p_contract_hdr_id);

3094: IF (p_grp_id is not null) or (p_customer_id is not null) or
3095: (p_category is not null) or (l_org_id is not null) or
3096: (p_contract_hdr_id is not null) Then
3097: If l_write_log then
3098: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameters Passed => Contract Id '||p_contract_hdr_id);
3099: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer '||P_customer_id|| ' Category '||p_category);
3100: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Org '||l_org_id|| ' Group '||p_grp_id);
3101: End If;
3102:

Line 3099: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer '||P_customer_id|| ' Category '||p_category);

3095: (p_category is not null) or (l_org_id is not null) or
3096: (p_contract_hdr_id is not null) Then
3097: If l_write_log then
3098: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameters Passed => Contract Id '||p_contract_hdr_id);
3099: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer '||P_customer_id|| ' Category '||p_category);
3100: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Org '||l_org_id|| ' Group '||p_grp_id);
3101: End If;
3102:
3103: End If;

Line 3100: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Org '||l_org_id|| ' Group '||p_grp_id);

3096: (p_contract_hdr_id is not null) Then
3097: If l_write_log then
3098: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameters Passed => Contract Id '||p_contract_hdr_id);
3099: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Customer '||P_customer_id|| ' Category '||p_category);
3100: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Org '||l_org_id|| ' Group '||p_grp_id);
3101: End If;
3102:
3103: End If;
3104:

Line 3110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Blind Query ' || ': with date '||p_date);

3106: IF (p_grp_id is null) and (p_customer_id is null) and
3107: (p_category is null) and (l_org_id is null) and
3108: (p_contract_hdr_id is null) Then
3109:
3110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Blind Query ' || ': with date '||p_date);
3111:
3112: INSERT /*+ append */ into oks_process_billing (chr_id,cle_id,line_no,currency_code)
3113: SELECT /*+ leading(lvl) ORDERED USE_HASH(line hdr sts as1)
3114: swap_join_inputs(hdr) swap_join_inputs(sts) */

Line 3153: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query for Org id');

3149: (p_grp_id is null) and (p_customer_id is null) and
3150: (p_category is null) and (l_org_id is not null) and
3151: (p_contract_hdr_id is null) Then
3152:
3153: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query for Org id');
3154:
3155: INSERT /*+ append */ into oks_process_billing (chr_id,cle_id,line_no,currency_code)
3156: SELECT /*+ leading(lvl) ORDERED USE_HASH(line hdr sts as1)
3157: swap_join_inputs(hdr) swap_join_inputs(sts) */

Line 3194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query for Contract id');

3190: );
3191: Elsif
3192: (p_contract_hdr_id is not null) Then
3193:
3194: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query for Contract id');
3195:
3196: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
3197:
3198: SELECT hdr.id hdr_id,line.id line_id,rownum,hdr.currency_code

Line 3226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query for contract group and org id');

3222: (p_grp_id is not null) and (p_customer_id is null) and
3223: (p_category is null) and (l_org_id is not null) and
3224: (p_contract_hdr_id is null) Then
3225:
3226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query for contract group and org id');
3227:
3228: INSERT /*+ append */ into oks_process_billing (chr_id,cle_id,line_no,currency_code)
3229: SELECT /*+ leading(lvl) ORDERED USE_HASH(line hdr sts as1 cgp)
3230: swap_join_inputs(hdr) swap_join_inputs(sts) swap_join_inputs(cgp) */

Line 3273: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query for rest of the parameters');

3269: );
3270:
3271: Else
3272:
3273: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Query for rest of the parameters');
3274:
3275: INSERT into oks_process_billing (chr_id,cle_id,line_no,currency_code)
3276:
3277: SELECT hdr.id hdr_id,line.id line_id,rownum,hdr.currency_code

Line 3317: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Number of records in oks_process_billing is '||l_line_no);

3313: commit;
3314: select count(*) into l_line_no from oks_process_billing;
3315:
3316: If l_write_log then
3317: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Number of records in oks_process_billing is '||l_line_no);
3318: End If;
3319:
3320:
3321: END IF;

Line 3330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Profile option OKS: Parallel Worker is set to YES');

3326: (nvl(FND_PROFILE.VALUE('OKS_PARALLEL_WORKER'),'NO') = 'YES') THEN
3327:
3328: -- l_line_no represent total records to be processed here
3329: If l_write_log then
3330: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Profile option OKS: Parallel Worker is set to YES');
3331: End If;
3332:
3333: IF (l_line_no > MAX_SINGLE_REQUEST ) THEN
3334: -- populate lo,hi varrays

Line 3359: FND_FILE.PUT_LINE (FND_FILE.LOG,'Sub-request failed to submit: '

3355:
3356: IF (l_ret = 0) THEN
3357: errbuf := fnd_message.get;
3358: retcode := 2;
3359: FND_FILE.PUT_LINE (FND_FILE.LOG,'Sub-request failed to submit: '
3360: || errbuf);
3361: return;
3362: ELSE
3363: FND_FILE.PUT_LINE (FND_FILE.LOG,'Sub-request '||to_char(l_ret)||

Line 3363: FND_FILE.PUT_LINE (FND_FILE.LOG,'Sub-request '||to_char(l_ret)||

3359: FND_FILE.PUT_LINE (FND_FILE.LOG,'Sub-request failed to submit: '
3360: || errbuf);
3361: return;
3362: ELSE
3363: FND_FILE.PUT_LINE (FND_FILE.LOG,'Sub-request '||to_char(l_ret)||
3364: ' submitted for line numbers '||l_min_boundary||' to '||l_max_boundary);
3365: END IF;
3366:
3367: IF (l_max_boundary >= l_line_no) THEN

Line 3387: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Commiting here');

3383:
3384: ELSIF ((FND_CONC_GLOBAL.request_data is not null ) AND
3385: (nvl(FND_PROFILE.VALUE('OKS_PARALLEL_WORKER'),'NO') = 'YES')) THEN
3386: -- restart detected (sub-requests finished)...cleanup and exit.
3387: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Commiting here');
3388: COMMIT;
3389:
3390: v_cursor := DBMS_SQL.OPEN_CURSOR;
3391: /* Following line is required to avoid GSCC errors at ARU creation.

Line 3405: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => B4 Calling OKS_BILLING_PUB.CALCULATE_BILL for sequential run');

3401: return;
3402: END IF; -- parent test
3403:
3404: If l_write_log then
3405: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => B4 Calling OKS_BILLING_PUB.CALCULATE_BILL for sequential run');
3406: End If;
3407:
3408: OKS_BILLING_PUB.CALCULATE_BILL
3409: (l_errbuf, l_retcode, 1, l_flag,

Line 3414: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => After Calling OKS_BILLING_PUB.CALCULATE_BILL for sequential run');

3410: p_date,1 ,l_line_no,
3411: p_prv);
3412:
3413: If l_write_log then
3414: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => After Calling OKS_BILLING_PUB.CALCULATE_BILL for sequential run');
3415: End If;
3416:
3417: IF (l_retcode = 0) THEN
3418: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Billing Main is successfully completed');

Line 3418: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Billing Main is successfully completed');

3414: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => After Calling OKS_BILLING_PUB.CALCULATE_BILL for sequential run');
3415: End If;
3416:
3417: IF (l_retcode = 0) THEN
3418: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Billing Main is successfully completed');
3419: conc_ret_code := SUCCESS;
3420: RETCODE := 0;
3421: ELSIF (l_retcode = 1) THEN
3422: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Billing Main is successfully completed with warnings');

Line 3422: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Billing Main is successfully completed with warnings');

3418: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Billing Main is successfully completed');
3419: conc_ret_code := SUCCESS;
3420: RETCODE := 0;
3421: ELSIF (l_retcode = 1) THEN
3422: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Billing Main is successfully completed with warnings');
3423: conc_ret_code := WARNING;
3424: RETCODE := 1;
3425: ELSE
3426: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Billing Main completed with errors');

Line 3426: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Billing Main completed with errors');

3422: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Billing Main is successfully completed with warnings');
3423: conc_ret_code := WARNING;
3424: RETCODE := 1;
3425: ELSE
3426: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Billing Main completed with errors');
3427: conc_ret_code := ERROR;
3428: RETCODE := 2;
3429: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MAIN_BILLING');
3430: END IF;

Line 3444: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main Ends');

3440: v_truncstring := 'Truncate Table OKS'||'.oks_process_billing';
3441: DBMS_SQL.PARSE(v_cursor,v_truncstring,DBMS_SQL.V7);
3442: DBMS_SQL.CLOSE_CURSOR(v_cursor);
3443:
3444: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main Ends');
3445:
3446: EXCEPTION
3447: WHEN UTL_FILE.INVALID_PATH THEN
3448: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE LOCATION OR NAME WAS INVALID');

Line 3448: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE LOCATION OR NAME WAS INVALID');

3444: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main Ends');
3445:
3446: EXCEPTION
3447: WHEN UTL_FILE.INVALID_PATH THEN
3448: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE LOCATION OR NAME WAS INVALID');
3449: WHEN UTL_FILE.INVALID_MODE THEN
3450: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE OPEN MODE STRING WAS INVALID');
3451: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
3452: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE HANDLE WAS INVALID');

Line 3450: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE OPEN MODE STRING WAS INVALID');

3446: EXCEPTION
3447: WHEN UTL_FILE.INVALID_PATH THEN
3448: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE LOCATION OR NAME WAS INVALID');
3449: WHEN UTL_FILE.INVALID_MODE THEN
3450: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE OPEN MODE STRING WAS INVALID');
3451: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
3452: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE HANDLE WAS INVALID');
3453: WHEN UTL_FILE.INVALID_OPERATION THEN
3454: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE IS NOT OPEN FOR WRITTING');

Line 3452: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE HANDLE WAS INVALID');

3448: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE LOCATION OR NAME WAS INVALID');
3449: WHEN UTL_FILE.INVALID_MODE THEN
3450: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE OPEN MODE STRING WAS INVALID');
3451: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
3452: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE HANDLE WAS INVALID');
3453: WHEN UTL_FILE.INVALID_OPERATION THEN
3454: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE IS NOT OPEN FOR WRITTING');
3455: WHEN UTL_FILE.WRITE_ERROR THEN
3456: FND_FILE.PUT_LINE (FND_FILE.LOG,'OS ERROR OCCURRED DURING WRITE OPERATION');

Line 3454: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE IS NOT OPEN FOR WRITTING');

3450: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE OPEN MODE STRING WAS INVALID');
3451: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
3452: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE HANDLE WAS INVALID');
3453: WHEN UTL_FILE.INVALID_OPERATION THEN
3454: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE IS NOT OPEN FOR WRITTING');
3455: WHEN UTL_FILE.WRITE_ERROR THEN
3456: FND_FILE.PUT_LINE (FND_FILE.LOG,'OS ERROR OCCURRED DURING WRITE OPERATION');
3457:
3458: END Billing_Main;

Line 3456: FND_FILE.PUT_LINE (FND_FILE.LOG,'OS ERROR OCCURRED DURING WRITE OPERATION');

3452: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE HANDLE WAS INVALID');
3453: WHEN UTL_FILE.INVALID_OPERATION THEN
3454: FND_FILE.PUT_LINE (FND_FILE.LOG, 'FILE IS NOT OPEN FOR WRITTING');
3455: WHEN UTL_FILE.WRITE_ERROR THEN
3456: FND_FILE.PUT_LINE (FND_FILE.LOG,'OS ERROR OCCURRED DURING WRITE OPERATION');
3457:
3458: END Billing_Main;
3459:
3460:

Line 3723: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: Failed in AR FEEDER');

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');
3725: l_retcode := 1;
3726: END IF;
3727:

Line 3729: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Supress credit is successfully completed');

3725: l_retcode := 1;
3726: END IF;
3727:
3728: IF (l_retcode = 0) THEN
3729: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Supress credit is successfully completed');
3730: conc_ret_code := SUCCESS;
3731: RETCODE := 0;
3732: END IF;
3733:

Line 3738: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Supress credit completed with Errors');

3734: COMMIT;
3735:
3736: EXCEPTION
3737: WHEN OTHERS THEN
3738: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Supress credit completed with Errors');
3739: conc_ret_code := ERROR;
3740: RETCODE := 2;
3741: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,
3742: G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);