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_ARFEEDER_PUB dependencies on FND_FILE

Line 409: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id => Failed in populating refrence fields');

405: p_contract_modifier => nvl(p_con_modifier,'-'),
406: x_return_status => l_return_status);
407:
408: IF ( l_return_status <> 'S') THEN
409: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id => Failed in populating refrence fields');
410: END IF;
411:
412: END IF;
413:

Line 446: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id => Failed in populating refrence fields');

442: p_contract_modifier => nvl(p_con_modifier,'-'),
443: x_return_status => l_return_status);
444:
445: IF ( l_return_status <> 'S') THEN
446: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id => Failed in populating refrence fields');
447: END IF;
448: END IF; ---Reference_line_id chk
449:
450: END IF;

Line 535: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id => Failed in populating refrence fields');

531: p_contract_modifier => nvl(p_con_modifier,'-'),
532: x_return_status => l_return_status);
533:
534: IF ( l_return_status <> 'S') THEN
535: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id => Failed in populating refrence fields');
536: END IF;
537: END IF;
538:
539:

Line 571: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id => Failed in populating refrence fields');

567: p_contract_modifier => nvl(p_con_modifier,'-'),
568: x_return_status => l_return_status);
569:
570: IF ( l_return_status <> 'S') THEN
571: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id => Failed in populating refrence fields');
572: END IF;
573: END IF; ---Reference_line_id chk
574: END IF;
575:

Line 626: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id Failed in populating refrence fields');

622: p_contract_modifier => nvl(p_con_modifier,'-'),
623: x_return_status => l_return_status);
624:
625: IF ( l_return_status <> 'S') THEN
626: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id Failed in populating refrence fields');
627: END IF;
628: END IF; ---Reference_line_id chk
629:
630: /*Following if stat is for backward compatibility*/

Line 660: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id Failed in populating refrence fields');

656: p_contract_modifier => nvl(p_con_modifier,'-'),
657: x_return_status => l_return_status);
658:
659: IF ( l_return_status <> 'S') THEN
660: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id Failed in populating refrence fields');
661: END IF;
662: END IF; ---Reference_line_id chk
663:
664: END IF;

Line 692: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto Invoice not run for Order line '||l_order_line_id);

688: The records are fetched from ra Interface Lines
689: if auto Invoice has not run for OM originated contracts
690: ****/
691:
692: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto Invoice not run for Order line '||l_order_line_id);
693: p_return_status := 'E';
694: END IF;
695:
696: CLOSE l_get_ref_id;

Line 718: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id IPM:line_level '||l_comm_id);

714:
715: l_comm_id := p_line_comm_id ;
716:
717: If G_LOG_YES_NO = 'YES' then
718: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id IPM:line_level '||l_comm_id);
719: End If;
720:
721: ELSE
722:

Line 725: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id IPM:header_level '||l_comm_id);

721: ELSE
722:
723: l_comm_id := p_hdr_comm_id ;
724: If G_LOG_YES_NO = 'YES' then
725: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id IPM:header_level '||l_comm_id);
726: End If;
727:
728: END IF;
729:

Line 736: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id IPM:reference_line_id '||G_RAIL_REC.reference_line_id);

732: OPEN comm_id_cur(l_comm_id);
733: FETCH comm_id_cur into G_RAIL_REC.reference_line_id;
734: CLOSE comm_id_cur;
735: If G_LOG_YES_NO = 'YES' then
736: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id IPM:reference_line_id '||G_RAIL_REC.reference_line_id);
737: End If;
738: G_RAIL_REC.CUSTOMER_BANK_ACCOUNT_ID := NULL;
739: G_RAIL_REC.RECEIPT_METHOD_NAME := NULL;
740: G_RAIL_REC.RECEIPT_METHOD_ID := NULL;

Line 894: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. no Transaction Ext. Id for line ');

890: /* Commented by sjanakir for Bug #6855301
891: G_RAIL_REC.receipt_method_id := to_number(nvl(FND_PROFILE.VALUE_SPECIFIC('OKS_RECEIPT_METHOD_ID', NULL, NULL, NULL, p_org_id, NULL),'0')); */
892:
893: Else
894: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. no Transaction Ext. Id for line ');
895: End if;
896: End If;
897: Close hdr_party_cur;
898: End If;

Line 961: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id IPM:reference_line_id '||G_RAIL_REC.reference_line_id);

957: OPEN comm_id_cur(p_line_commitment,p_org_id);
958: FETCH comm_id_cur into G_RAIL_REC.reference_line_id;
959: CLOSE comm_id_cur;
960: If G_LOG_YES_NO = 'YES' then
961: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id IPM:reference_line_id '||G_RAIL_REC.reference_line_id);
962: End If;
963:
964: -----check if hdr bill to account matches with the line bill to cascade commitment
965: Elsif (p_hdr_commitment is not null) Then

Line 976: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id IPM:reference_line_id '||G_RAIL_REC.reference_line_id);

972: FETCH comm_id_cur into G_RAIL_REC.reference_line_id;
973: CLOSE comm_id_cur;
974:
975: If G_LOG_YES_NO = 'YES' then
976: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id IPM:reference_line_id '||G_RAIL_REC.reference_line_id);
977: End If;
978: Else
979: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. no commitment for line ');
980: End If;

Line 979: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. no commitment for line ');

975: If G_LOG_YES_NO = 'YES' then
976: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id IPM:reference_line_id '||G_RAIL_REC.reference_line_id);
977: End If;
978: Else
979: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. no commitment for line ');
980: End If;
981:
982: END IF;
983:

Line 1192: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Attributes => FAILED IN G_RAIL Field ASSIGNMENT FOR '|| p_cle_id||' Error '||sqlerrm);

1188:
1189:
1190: EXCEPTION
1191: WHEN OTHERS THEN
1192: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Attributes => FAILED IN G_RAIL Field ASSIGNMENT FOR '|| p_cle_id||' Error '||sqlerrm);
1193: p_return_status := 'E';
1194:
1195: END Set_Attributes;
1196:

Line 1348: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => AMOUNT'||G_RAIL_REC.AMOUNT);

1344: BEGIN
1345: x_return_status := 'S';
1346:
1347: If G_LOG_YES_NO = 'YES' then
1348: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => AMOUNT'||G_RAIL_REC.AMOUNT);
1349: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => BATCH_SOURCE_NAME'||G_RAIL_REC.BATCH_SOURCE_NAME);
1350: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => CURRENCY_CODE'||G_RAIL_REC.CURRENCY_CODE);
1351: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => SET_OF_BOOKS_ID '||G_RAIL_REC.SET_OF_BOOKS_ID);
1352: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => ORG_ID '||G_RAIL_REC.ORG_ID);

Line 1349: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => BATCH_SOURCE_NAME'||G_RAIL_REC.BATCH_SOURCE_NAME);

1345: x_return_status := 'S';
1346:
1347: If G_LOG_YES_NO = 'YES' then
1348: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => AMOUNT'||G_RAIL_REC.AMOUNT);
1349: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => BATCH_SOURCE_NAME'||G_RAIL_REC.BATCH_SOURCE_NAME);
1350: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => CURRENCY_CODE'||G_RAIL_REC.CURRENCY_CODE);
1351: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => SET_OF_BOOKS_ID '||G_RAIL_REC.SET_OF_BOOKS_ID);
1352: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => ORG_ID '||G_RAIL_REC.ORG_ID);
1353: End If;

Line 1350: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => CURRENCY_CODE'||G_RAIL_REC.CURRENCY_CODE);

1346:
1347: If G_LOG_YES_NO = 'YES' then
1348: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => AMOUNT'||G_RAIL_REC.AMOUNT);
1349: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => BATCH_SOURCE_NAME'||G_RAIL_REC.BATCH_SOURCE_NAME);
1350: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => CURRENCY_CODE'||G_RAIL_REC.CURRENCY_CODE);
1351: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => SET_OF_BOOKS_ID '||G_RAIL_REC.SET_OF_BOOKS_ID);
1352: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => ORG_ID '||G_RAIL_REC.ORG_ID);
1353: End If;
1354:

Line 1351: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => SET_OF_BOOKS_ID '||G_RAIL_REC.SET_OF_BOOKS_ID);

1347: If G_LOG_YES_NO = 'YES' then
1348: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => AMOUNT'||G_RAIL_REC.AMOUNT);
1349: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => BATCH_SOURCE_NAME'||G_RAIL_REC.BATCH_SOURCE_NAME);
1350: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => CURRENCY_CODE'||G_RAIL_REC.CURRENCY_CODE);
1351: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => SET_OF_BOOKS_ID '||G_RAIL_REC.SET_OF_BOOKS_ID);
1352: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => ORG_ID '||G_RAIL_REC.ORG_ID);
1353: End If;
1354:
1355:

Line 1352: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => ORG_ID '||G_RAIL_REC.ORG_ID);

1348: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => AMOUNT'||G_RAIL_REC.AMOUNT);
1349: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => BATCH_SOURCE_NAME'||G_RAIL_REC.BATCH_SOURCE_NAME);
1350: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => CURRENCY_CODE'||G_RAIL_REC.CURRENCY_CODE);
1351: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => SET_OF_BOOKS_ID '||G_RAIL_REC.SET_OF_BOOKS_ID);
1352: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => ORG_ID '||G_RAIL_REC.ORG_ID);
1353: End If;
1354:
1355:
1356: IF ((G_RAIL_REC.CONVERSION_TYPE IS NULL) AND

Line 1652: FND_FILE.PUT_LINE(FND_FILE.LOG,

1648:
1649: EXCEPTION
1650: When Others Then
1651: x_return_status := 'E';
1652: FND_FILE.PUT_LINE(FND_FILE.LOG,
1653: 'OKS_ARFEEDER_PUB.insert_ra_interface => Exception in insert into RA_INTERFACE_LINES '||' SQLCOE = '||sqlcode ||' Sqlerrm = '||sqlerrm);
1654:
1655: End insert_ra_interface;
1656: ---------------------------------------------------------------------------

Line 1730: FND_FILE.PUT_LINE(FND_FILE.LOG,

1726: CLOSE rev_dist_cur;
1727: EXCEPTION
1728: When Others Then
1729: x_return_status := 'E';
1730: FND_FILE.PUT_LINE(FND_FILE.LOG,
1731: 'OKS_ARFEEDER_PUB.insert_ra_rev_dist => Exception in insert into RA_INTERFACE_DISTRIBUTIONS'||' SQLCODE ='||SQLCODE||' SQLERRM = '||SQLERRM);
1732:
1733: END;
1734:

Line 1753: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface_sc => AMOUNT'||G_RAISC_REC.SALES_CREDIT_AMOUNT_SPLIT);

1749: BEGIN
1750: x_return_status := 'S';
1751:
1752: If G_LOG_YES_NO = 'YES' then
1753: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface_sc => AMOUNT'||G_RAISC_REC.SALES_CREDIT_AMOUNT_SPLIT);
1754: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface_sc => PERCENT'||G_RAISC_REC.SALES_CREDIT_PERCENT_SPLIT);
1755: End If;
1756:
1757:

Line 1754: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface_sc => PERCENT'||G_RAISC_REC.SALES_CREDIT_PERCENT_SPLIT);

1750: x_return_status := 'S';
1751:
1752: If G_LOG_YES_NO = 'YES' then
1753: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface_sc => AMOUNT'||G_RAISC_REC.SALES_CREDIT_AMOUNT_SPLIT);
1754: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface_sc => PERCENT'||G_RAISC_REC.SALES_CREDIT_PERCENT_SPLIT);
1755: End If;
1756:
1757:
1758:

Line 1803: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in insert RA_INTERFACE_SALESCREDITS ' || sqlerrm);

1799: -- G_RAISC_REC := G_INIT_RAISC_REC;
1800:
1801: EXCEPTION
1802: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1803: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in insert RA_INTERFACE_SALESCREDITS ' || sqlerrm);
1804:
1805: When Others Then
1806: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1807: FND_FILE.PUT_LINE(FND_FILE.LOG,

Line 1807: FND_FILE.PUT_LINE(FND_FILE.LOG,

1803: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in insert RA_INTERFACE_SALESCREDITS ' || sqlerrm);
1804:
1805: When Others Then
1806: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1807: FND_FILE.PUT_LINE(FND_FILE.LOG,
1808: 'OKS_ARFEEDER_PUB.insert_ra_interface_sc => Exception in insert into RA_INTERFACE_SALESCREDITS'||' SQLCODE = '||SQLCODE ||' SQLERRM = '||SQLERRM);
1809:
1810: End insert_ra_interface_sc;
1811:

Line 1860: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Sales_credit => Header Level RA_Interface_SalesCredit');

1856: if(Sales_credit_cur%NOTFOUND) THEN
1857: For Sales_credit_hdr_rec in Sales_credit_hdr_cur
1858: Loop
1859: if G_LOG_YES_NO = 'YES' then
1860: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Sales_credit => Header Level RA_Interface_SalesCredit');
1861: end if;
1862: G_RAISC_REC.SALESREP_ID := Sales_credit_hdr_rec.CTC_ID;
1863: G_RAISC_REC.SALES_CREDIT_TYPE_ID := to_number(Sales_credit_hdr_rec.SALES_CREDIT_TYPE_ID1);
1864: G_RAISC_REC.SALES_CREDIT_PERCENT_SPLIT :=Sales_credit_hdr_rec.PERCENT;

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

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:
1880: End If;
1881:
1882:

Line 1887: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Sales_credit =>Line level RA_Interface_SalesCredit');

1883: End Loop;--End of sales credit header Loop
1884: else
1885: LOOP
1886: If G_LOG_YES_NO = 'YES' then
1887: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Sales_credit =>Line level RA_Interface_SalesCredit');
1888: End If;
1889: Exit WHEN Sales_credit_cur%NOTFOUND;
1890: G_RAISC_REC.SALESREP_ID := Sales_credit_rec.CTC_ID;
1891: G_RAISC_REC.SALES_CREDIT_TYPE_ID := to_number(Sales_credit_rec.SALES_CREDIT_TYPE_ID1);

Line 1908: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Sales_credit => Insert into RA_Interface_SalesCredit Failed For'||p_id);

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:
1910: End If;
1911:
1912: Fetch Sales_credit_cur into Sales_credit_rec;

Line 2028: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert into RA_Interface_Lines Failed while inserting price breaks ' );

2024: x_msg_data
2025: );
2026:
2027: IF (x_return_status <> 'S') THEN
2028: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert into RA_Interface_Lines Failed while inserting price breaks ' );
2029: x_return_status := 'E';
2030: END IF; --IF (l_ret_stat <> 'S')
2031:
2032:

Line 2037: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert INTO RA_REVENUE_DISTRIBUTIONS failed for Price Break');

2033: INSERT_RA_REV_DIST( x_return_status,
2034: p_bcl_cle_id);
2035:
2036: IF (x_return_status <> 'S') THEN
2037: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert INTO RA_REVENUE_DISTRIBUTIONS failed for Price Break');
2038:
2039: x_return_status := 'E';
2040: END IF;
2041:

Line 2049: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert INTO RA_SALES_CREDIT FAILED for Price Breaks');

2045: p_hdr_id,
2046: x_return_status);
2047:
2048: IF ( x_return_status <> 'S') THEN
2049: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert INTO RA_SALES_CREDIT FAILED for Price Breaks');
2050: END IF;
2051:
2052: EXIT When x_return_status <> 'S';
2053: END LOOP;

Line 2106: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert into RA_Interface_Lines Failed while inserting price breaks ' );

2102: x_msg_data
2103: );
2104:
2105: IF (x_return_status <> 'S') THEN
2106: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert into RA_Interface_Lines Failed while inserting price breaks ' );
2107: x_return_status := 'E';
2108: END IF; --IF (l_ret_stat <> 'S')
2109:
2110: /*Added for bug 14242256 */

Line 2115: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert INTO RA_REVENUE_DISTRIBUTIONS failed for Price Break');

2111: If nvl(FND_PROFILE.VALUE('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y')='N' THEN
2112: INSERT_RA_REV_DIST( x_return_status,
2113: p_bcl_cle_id);
2114: IF (x_return_status <> 'S') THEN
2115: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert INTO RA_REVENUE_DISTRIBUTIONS failed for Price Break');
2116:
2117: x_return_status := 'E';
2118: END IF;
2119: END IF;

Line 2131: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert INTO RA_SALES_CREDIT FAILED for Price Breaks');

2127: p_hdr_id,
2128: x_return_status);
2129:
2130: IF ( x_return_status <> 'S') THEN
2131: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert INTO RA_SALES_CREDIT FAILED for Price Breaks');
2132: END IF;
2133:
2134:
2135: EXIT when x_return_status <> 'S';

Line 2184: FND_FILE.PUT_LINE(FND_FILE.LOG,

2180:
2181: EXCEPTION
2182: WHEN OTHERS THEN
2183: x_return_status := 'E';
2184: FND_FILE.PUT_LINE(FND_FILE.LOG,
2185: 'OKS_ARFEEDER_PUB.Get_Pay_Method_Info => Exception in insert into GET_PAY_METHOD'||' SQLCODE = '||SQLCODE||' SQLERRM = '||SQLERRM);
2186:
2187:
2188: END Get_Pay_Method_Info;

Line 2819: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method id is '||l_pay_method_id);

2815: INTO l_pay_method_id
2816: FROM ra_cust_receipt_methods
2817: WHERE cust_receipt_method_id = l_cust_pay_method_id;
2818: IF G_LOG_YES_NO = 'YES' THEN
2819: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method id is '||l_pay_method_id);
2820: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Customer Payment method id is '||l_cust_pay_method_id);
2821: END IF;
2822: ELSE
2823:

Line 2820: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Customer Payment method id is '||l_cust_pay_method_id);

2816: FROM ra_cust_receipt_methods
2817: WHERE cust_receipt_method_id = l_cust_pay_method_id;
2818: IF G_LOG_YES_NO = 'YES' THEN
2819: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method id is '||l_pay_method_id);
2820: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Customer Payment method id is '||l_cust_pay_method_id);
2821: END IF;
2822: ELSE
2823:
2824: l_pay_method_id := to_number(nvl(FND_PROFILE.VALUE_SPECIFIC('OKS_RECEIPT_METHOD_ID', NULL, NULL, NULL, p_org_id, NULL),'0'));

Line 2828: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method id is '||l_pay_method_id);

2824: l_pay_method_id := to_number(nvl(FND_PROFILE.VALUE_SPECIFIC('OKS_RECEIPT_METHOD_ID', NULL, NULL, NULL, p_org_id, NULL),'0'));
2825:
2826: IF l_pay_method_id = 0 THEN
2827: IF G_LOG_YES_NO = 'YES' THEN
2828: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method id is '||l_pay_method_id);
2829: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Enter a Value for the Profile, OKS: Payment Method for AR Interface');
2830: END IF;
2831: l_msg_data:= 'Enter a Value for the Profile, OKS: Payment Method for AR Interface'; --skuchima 10416595
2832: RAISE MAIN_CUR_EXCEPTION;

Line 2829: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Enter a Value for the Profile, OKS: Payment Method for AR Interface');

2825:
2826: IF l_pay_method_id = 0 THEN
2827: IF G_LOG_YES_NO = 'YES' THEN
2828: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method id is '||l_pay_method_id);
2829: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Enter a Value for the Profile, OKS: Payment Method for AR Interface');
2830: END IF;
2831: l_msg_data:= 'Enter a Value for the Profile, OKS: Payment Method for AR Interface'; --skuchima 10416595
2832: RAISE MAIN_CUR_EXCEPTION;
2833: END IF;

Line 2841: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method id from Profile OKS: Payment Method for AR Interface is '||l_pay_method_id);

2837: p_customer_id => p_customer_id,
2838: p_site_use_id => p_site_use_id,
2839: p_as_of_date => TRUNC(p_as_of_date));
2840: IF G_LOG_YES_NO = 'YES' THEN
2841: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method id from Profile OKS: Payment Method for AR Interface is '||l_pay_method_id);
2842: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Customer Payment method id is '||l_cust_pay_method_id);
2843: END IF;
2844: END IF;
2845:

Line 2842: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Customer Payment method id is '||l_cust_pay_method_id);

2838: p_site_use_id => p_site_use_id,
2839: p_as_of_date => TRUNC(p_as_of_date));
2840: IF G_LOG_YES_NO = 'YES' THEN
2841: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method id from Profile OKS: Payment Method for AR Interface is '||l_pay_method_id);
2842: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Customer Payment method id is '||l_cust_pay_method_id);
2843: END IF;
2844: END IF;
2845:
2846: RETURN l_pay_method_id;

Line 2888: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card details not found for Payment Transaction Extension ID');

2884: AND ipa.instrument_id = ic.instrid;
2885: EXCEPTION
2886: WHEN NO_DATA_FOUND THEN
2887: IF G_LOG_YES_NO = 'YES' THEN
2888: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card details not found for Payment Transaction Extension ID');
2889: END IF;
2890: RAISE MAIN_CUR_EXCEPTION;
2891: WHEN OTHERS THEN
2892: IF G_LOG_YES_NO = 'YES' THEN

Line 2893: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Error retrieving Credit card details for Payment Transaction Extension ID');

2889: END IF;
2890: RAISE MAIN_CUR_EXCEPTION;
2891: WHEN OTHERS THEN
2892: IF G_LOG_YES_NO = 'YES' THEN
2893: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Error retrieving Credit card details for Payment Transaction Extension ID');
2894: END IF;
2895: RAISE MAIN_CUR_EXCEPTION;
2896: END;
2897:

Line 2921: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card number Format is invalid.');

2917: IF l_ret_stat = OKC_API.G_RET_STS_SUCCESS
2918: THEN
2919: IF v_cc_type=IBY_CC_VALIDATE.c_InvalidCC THEN
2920: IF G_LOG_YES_NO = 'YES' THEN
2921: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card number Format is invalid.');
2922: END IF;
2923:
2924: RAISE MAIN_CUR_EXCEPTION;
2925: ELSE

Line 2927: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card number Format is valid.');

2923:
2924: RAISE MAIN_CUR_EXCEPTION;
2925: ELSE
2926: IF G_LOG_YES_NO = 'YES' THEN
2927: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card number Format is valid.');
2928: END IF;
2929: END IF;
2930:
2931: iby_cc_validate.validatecc( p_api_version => 1.0,

Line 2945: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Error retrieving Credit card Type.');

2941:
2942: ELSE
2943:
2944: IF G_LOG_YES_NO = 'YES' THEN
2945: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Error retrieving Credit card Type.');
2946: END IF;
2947:
2948: RETURN FALSE;
2949:

Line 2954: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Error retrieving Credit card number.');

2950: END IF;
2951: ELSE
2952:
2953: IF G_LOG_YES_NO = 'YES' THEN
2954: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Error retrieving Credit card number.');
2955: END IF;
2956:
2957: RETURN FALSE;
2958:

Line 2983: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => OKS: Billing Report And Log is set to '||G_LOG_YES_NO);

2979: --messages
2980: G_LOG_YES_NO := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');
2981:
2982: If G_LOG_YES_NO = 'YES' then ---- added by ansraj for 14016663
2983: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => OKS: Billing Report And Log is set to '||G_LOG_YES_NO);
2984: End If;
2985:
2986: /*FOR BILLING REPORT*/
2987: l_subline_failed := FALSE;

Line 3024: FND_FILE.PUT_LINE(FND_FILE.LOG,'Usage Type '||l_usage_type);

3020: Open l_usage_csr(bcl_rec.cle_id,Bcl_rec.dnz_chr_id);
3021: Fetch l_usage_csr into l_usage_type;
3022: Close l_usage_csr;
3023: If G_LOG_YES_NO = 'YES' then ---- added by ansraj for 14016663
3024: FND_FILE.PUT_LINE(FND_FILE.LOG,'Usage Type '||l_usage_type);
3025: End If;
3026: -- End for bug#4390448
3027:
3028: l_select_counter := l_select_counter + 1;

Line 3040: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => p_prv '||p_prv);

3036: CLOSE cur_hdr_rules;
3037:
3038:
3039: If G_LOG_YES_NO = 'YES' then
3040: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => p_prv '||p_prv);
3041: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => rul_hdr_rec.hold_billing_flag '||nvl(rul_hdr_rec.hold_billing_flag,'N'));
3042: End If;
3043:
3044:

Line 3041: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => rul_hdr_rec.hold_billing_flag '||nvl(rul_hdr_rec.hold_billing_flag,'N'));

3037:
3038:
3039: If G_LOG_YES_NO = 'YES' then
3040: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => p_prv '||p_prv);
3041: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => rul_hdr_rec.hold_billing_flag '||nvl(rul_hdr_rec.hold_billing_flag,'N'));
3042: End If;
3043:
3044:
3045: IF (nvl(rul_hdr_rec.hold_billing_flag,'N') = 'Y') THEN

Line 3065: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Processing Line : '|| Bcl_rec.cle_id);

3061: AND (rul_hdr_rec.ar_interface_yn ='Y') and l_flag = 0)) THEN /* Added By sjanakir for Bug # 6821826 */ /*modified for bug:8943481*/
3062:
3063:
3064: If G_LOG_YES_NO = 'YES' then
3065: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Processing Line : '|| Bcl_rec.cle_id);
3066: End If;
3067:
3068: OPEN Cur_K_headers(Bcl_rec.dnz_chr_id);
3069: FETCH Cur_k_headers into header_rec;

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

3089: p_btnv_tbl => l_btnv_tbl_in,
3090: x_btnv_tbl => l_btnv_tbl_out
3091: );
3092: If G_LOG_YES_NO = 'YES' then
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;

Line 3135: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Updating btn_id of oks_bill_cont_lines');

3131: SET btn_id = l_btnv_tbl_out(1).id
3132: WHERE id = bcl_rec.id ;
3133:
3134: If G_LOG_YES_NO = 'YES' then
3135: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Updating btn_id of oks_bill_cont_lines');
3136: End If;
3137:
3138: l_btlv_tbl_in(1).btn_id := l_btnv_tbl_out(1).id;
3139: l_btlv_tbl_in(1).bcl_id := bcl_rec.id;

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

3147: l_btl_pr_tbl_in(1).BCL_ID := Bcl_rec.id;
3148: END IF;
3149: ELSE -- (l_ret_stat = 'S')
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,

Line 3252: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_cust_trx_type '||G_RAIL_REC.CUST_TRX_TYPE_ID);

3248: bcl_rec.bill_action,
3249: l_hdr_sbg_object1_id1,
3250: header_rec.org_id);
3251: If G_LOG_YES_NO = 'YES' then
3252: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_cust_trx_type '||G_RAIL_REC.CUST_TRX_TYPE_ID);
3253: End If;
3254:
3255: IF (rul_hdr_rec.acct_rule_id IS NOT NULL) THEN
3256: OPEN acct_type(rul_hdr_rec.acct_rule_id);

Line 3281: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling GL_CALENDAR_PKG.get_num_periods_in_date_range l_return_status '||l_ret_stat);

3277: RETURN_CODE => l_ret_stat,
3278: UNMAPPED_DATE => l_unmapped_date);
3279:
3280: If G_LOG_YES_NO = 'YES' then
3281: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling GL_CALENDAR_PKG.get_num_periods_in_date_range l_return_status '||l_ret_stat);
3282: End If;
3283:
3284: G_RAIL_REC.ACCOUNTING_RULE_DURATION := l_num_periods;
3285: -- This column must be a positive integer for AR

Line 3338: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. Exempt numer '||tax_rec.exempt_certificate_number||' Reason '||tax_rec.exempt_reason_code);

3334: --reset the tax_exempt_flag to 'S'
3335: G_RAIL_REC.TAX_EXEMPT_FLAG := 'S';
3336: ELSE
3337: If G_LOG_YES_NO = 'YES' then
3338: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. Exempt numer '||tax_rec.exempt_certificate_number||' Reason '||tax_rec.exempt_reason_code);
3339: End If;
3340: G_RAIL_REC.TAX_EXEMPT_NUMBER := tax_rec.exempt_certificate_number;
3341: G_RAIL_REC.TAX_EXEMPT_REASON_CODE := tax_rec.exempt_reason_code;
3342: END IF;

Line 3432: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End Of Header Rule Processing And Beginning Of Line Rule processing');

3428:
3429: ------END OF HEADER RULE READING -------------------
3430:
3431: If G_LOG_YES_NO = 'YES' then
3432: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End Of Header Rule Processing And Beginning Of Line Rule processing');
3433: End If;
3434:
3435: ------LINE RULE READ --------------------------------
3436:

Line 3495: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. Exempt numer '||tax_rec.exempt_certificate_number||' Reason '||tax_rec.exempt_reason_code);

3491: G_RAIL_REC.TAX_EXEMPT_FLAG := 'S';
3492:
3493: ELSE
3494: If G_LOG_YES_NO = 'YES' then
3495: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. Exempt numer '||tax_rec.exempt_certificate_number||' Reason '||tax_rec.exempt_reason_code);
3496: End If;
3497: G_RAIL_REC.TAX_EXEMPT_NUMBER := tax_rec.exempt_certificate_number;
3498: G_RAIL_REC.TAX_EXEMPT_REASON_CODE := tax_rec.exempt_reason_code;
3499: END IF;

Line 3522: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. ZX API '||G_RAIL_REC.tax_exempt_number||' rsn '||G_RAIL_REC.tax_exempt_reason_code||' ship '||Rul_line_rec.ship_to_site_use_id);

3518: CLOSE Cur_Batch_Source_Id;
3519:
3520:
3521: If G_LOG_YES_NO = 'YES' then
3522: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. ZX API '||G_RAIL_REC.tax_exempt_number||' rsn '||G_RAIL_REC.tax_exempt_reason_code||' ship '||Rul_line_rec.ship_to_site_use_id);
3523: FND_FILE.PUT_LINE(FND_FILE.LOG,'ZX API '||Rul_line_rec.bill_to_site_use_id||' cust '||Rul_line_rec.cust_acct_id||' s site '||l_ship_to_party_site_id||' b site '||l_bill_to_party_site_id);
3524: FND_FILE.PUT_LINE(FND_FILE.LOG,'ZX API trx'||G_RAIL_REC.CUST_TRX_TYPE_ID||' Batch '||l_batch_source_id||' date '||Bcl_rec.DATE_NEXT_INVOICE);
3525: end if;
3526:

Line 3523: FND_FILE.PUT_LINE(FND_FILE.LOG,'ZX API '||Rul_line_rec.bill_to_site_use_id||' cust '||Rul_line_rec.cust_acct_id||' s site '||l_ship_to_party_site_id||' b site '||l_bill_to_party_site_id);

3519:
3520:
3521: If G_LOG_YES_NO = 'YES' then
3522: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. ZX API '||G_RAIL_REC.tax_exempt_number||' rsn '||G_RAIL_REC.tax_exempt_reason_code||' ship '||Rul_line_rec.ship_to_site_use_id);
3523: FND_FILE.PUT_LINE(FND_FILE.LOG,'ZX API '||Rul_line_rec.bill_to_site_use_id||' cust '||Rul_line_rec.cust_acct_id||' s site '||l_ship_to_party_site_id||' b site '||l_bill_to_party_site_id);
3524: FND_FILE.PUT_LINE(FND_FILE.LOG,'ZX API trx'||G_RAIL_REC.CUST_TRX_TYPE_ID||' Batch '||l_batch_source_id||' date '||Bcl_rec.DATE_NEXT_INVOICE);
3525: end if;
3526:
3527:

Line 3524: FND_FILE.PUT_LINE(FND_FILE.LOG,'ZX API trx'||G_RAIL_REC.CUST_TRX_TYPE_ID||' Batch '||l_batch_source_id||' date '||Bcl_rec.DATE_NEXT_INVOICE);

3520:
3521: If G_LOG_YES_NO = 'YES' then
3522: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. ZX API '||G_RAIL_REC.tax_exempt_number||' rsn '||G_RAIL_REC.tax_exempt_reason_code||' ship '||Rul_line_rec.ship_to_site_use_id);
3523: FND_FILE.PUT_LINE(FND_FILE.LOG,'ZX API '||Rul_line_rec.bill_to_site_use_id||' cust '||Rul_line_rec.cust_acct_id||' s site '||l_ship_to_party_site_id||' b site '||l_bill_to_party_site_id);
3524: FND_FILE.PUT_LINE(FND_FILE.LOG,'ZX API trx'||G_RAIL_REC.CUST_TRX_TYPE_ID||' Batch '||l_batch_source_id||' date '||Bcl_rec.DATE_NEXT_INVOICE);
3525: end if;
3526:
3527:
3528: ZX_TCM_VALIDATE_EXEMPT_PKG.VALIDATE_TAX_EXEMPTIONS

Line 3551: FND_FILE.PUT_LINE(FND_FILE.LOG,'After call to ZX API return status '||l_valid_flag||' '||rul_line_rec.exempt_certificate_number||' date '||Bcl_rec.DATE_NEXT_INVOICE);

3547:
3548:
3549: if l_valid_flag <> 'Y' Then
3550: If G_LOG_YES_NO = 'YES' then
3551: FND_FILE.PUT_LINE(FND_FILE.LOG,'After call to ZX API return status '||l_valid_flag||' '||rul_line_rec.exempt_certificate_number||' date '||Bcl_rec.DATE_NEXT_INVOICE);
3552: End If;
3553: --reset the tax_exempt_flag to 'S'
3554: G_RAIL_REC.TAX_EXEMPT_FLAG := 'S';
3555: G_RAIL_REC.TAX_EXEMPT_NUMBER := NULL;

Line 3582: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. classification code '||G_RAIL_REC.TAX_CODE);

3578: IF (Rul_line_rec.tax_classification_code IS NOT NULL) THEN
3579: --new contracts
3580: G_RAIL_REC.TAX_CODE := Rul_line_rec.tax_classification_code;
3581: If G_LOG_YES_NO = 'YES' then
3582: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. classification code '||G_RAIL_REC.TAX_CODE);
3583: End If;
3584: ELSIF Rul_line_rec.tax_code IS NOT NULL THEN
3585: --old contracts
3586: OPEN cur_tax_code(Rul_line_rec.tax_code, rul_hdr_rec.org_id);

Line 3590: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. derived from tax code '||G_RAIL_REC.TAX_CODE);

3586: OPEN cur_tax_code(Rul_line_rec.tax_code, rul_hdr_rec.org_id);
3587: FETCH cur_tax_code into G_RAIL_REC.TAX_CODE;
3588: CLOSE cur_tax_code;
3589: If G_LOG_YES_NO = 'YES' then
3590: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. derived from tax code '||G_RAIL_REC.TAX_CODE);
3591: End If;
3592:
3593: ELSE
3594: G_RAIL_REC.TAX_CODE := NULL;

Line 3666: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Done with processing line rules');

3662:
3663:
3664:
3665: If G_LOG_YES_NO = 'YES' then
3666: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Done with processing line rules');
3667: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Updated all G_RAIL Field');
3668: End If;
3669:
3670:

Line 3667: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Updated all G_RAIL Field');

3663:
3664:
3665: If G_LOG_YES_NO = 'YES' then
3666: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Done with processing line rules');
3667: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Updated all G_RAIL Field');
3668: End If;
3669:
3670:
3671:

Line 3677: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_aggrement_and_contacts');

3673: bcl_rec.cle_id,
3674: bcl_rec.date_billed_from,
3675: bcl_rec.bill_action);
3676: If G_LOG_YES_NO = 'YES' then
3677: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_aggrement_and_contacts');
3678: End If;
3679:
3680: Set_comments(bcl_rec.bill_action);
3681: If G_LOG_YES_NO = 'YES' then

Line 3682: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_comments ');

3678: End If;
3679:
3680: Set_comments(bcl_rec.bill_action);
3681: If G_LOG_YES_NO = 'YES' then
3682: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_comments ');
3683: End If;
3684:
3685: Set_attributes(rul_hdr_rec.contract_number,
3686: rul_hdr_rec.contract_number_modifier,

Line 3721: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_attributes ');

3717: END IF;
3718: -- Addition Ends
3719:
3720: If G_LOG_YES_NO = 'YES' then
3721: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_attributes ');
3722: End If;
3723:
3724:
3725: G_RAIL_REC.sales_order_line := bcl_rec.top_line_number;

Line 3729: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After setting line number ');

3725: G_RAIL_REC.sales_order_line := bcl_rec.top_line_number;
3726: G_RAIL_REC.contract_line_id := bcl_rec.cle_id;
3727:
3728: If G_LOG_YES_NO = 'YES' then
3729: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After setting line number ');
3730: End If;
3731:
3732: Set_gl_date ( p_cle_id => bcl_rec.cle_id,
3733: p_date_billed_from => to_date(G_RAIL_REC.INTERFACE_LINE_ATTRIBUTE7,'YYYY/MM/DD HH24:MI:SS'),

Line 3737: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_gl_date ');

3733: p_date_billed_from => to_date(G_RAIL_REC.INTERFACE_LINE_ATTRIBUTE7,'YYYY/MM/DD HH24:MI:SS'),
3734: p_bill_action => bcl_rec.bill_action);
3735:
3736: If G_LOG_YES_NO = 'YES' then
3737: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_gl_date ');
3738: End If;
3739:
3740:
3741: IF (l_ret_stat <> 'S') THEN

Line 3760: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method is '||rul_hdr_rec.payment_type);

3756:
3757: IF (P_PRV = 1 ) Then
3758:
3759: If G_LOG_YES_NO = 'YES' then
3760: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method is '||rul_hdr_rec.payment_type);
3761: End If;
3762:
3763: IF nvl(rul_hdr_rec.payment_type,'XX') = 'COM' and bcl_rec.trxn_extension_id is NULL then
3764:

Line 3820: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card is not expired');

3816: l_cc_expired := check_CC_valid ( p_trxn_extension_id => G_RAIL_REC.payment_trxn_extension_id);
3817:
3818: IF l_cc_expired ='N' THEN
3819: IF G_LOG_YES_NO = 'YES' THEN
3820: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card is not expired');
3821: END IF;
3822: ELSE
3823: IF G_LOG_YES_NO = 'YES' THEN
3824: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card has expired');

Line 3824: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card has expired');

3820: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card is not expired');
3821: END IF;
3822: ELSE
3823: IF G_LOG_YES_NO = 'YES' THEN
3824: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card has expired');
3825: END IF;
3826:
3827: l_msg_data:= 'Credit Card has expired for the date billed from '||bcl_rec.date_billed_from|| ' and the date billed to '||bcl_rec.date_billed_to; --skuchima 10416595
3828:

Line 3841: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_salesrep_id ');

3837:
3838:
3839: Set_salesrep_id (bcl_rec.dnz_Chr_id);
3840: If G_LOG_YES_NO = 'YES' then
3841: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_salesrep_id ');
3842: End If;
3843:
3844: Set_qty_and_uom(bcl_rec.cle_id,
3845: bcl_rec.dnz_chr_id,

Line 3852: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_qty_and_uom ');

3848: bcl_rec.bill_action,
3849: bcl_rec.lse_id,
3850: 'Y');
3851: If G_LOG_YES_NO = 'YES' then
3852: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_qty_and_uom ');
3853: End If;
3854:
3855:
3856: /****

Line 3922: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Summary Bill Processing');

3918:
3919:
3920: IF (l_bill_profile = G_SUM) THEN
3921: If G_LOG_YES_NO = 'YES' then
3922: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Summary Bill Processing');
3923: End If;
3924: Set_ref_line_id( bcl_rec.bill_action,
3925: bcl_rec.lse_id,
3926: bcl_rec.cle_id,

Line 3943: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER Auto Invoice Not Run'||Bcl_rec.cle_id);

3939: -- l_cust_trx_line_id
3940: );
3941:
3942: IF (l_ret_stat <> 'S') THEN
3943: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER Auto Invoice Not Run'||Bcl_rec.cle_id);
3944: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
3945: l_msg_data:='OKS_ARFEEDER_PUB.Get_REC_FEEDER Auto Invoice Not Run '||Bcl_rec.cle_id ||
3946: ' for the date billed from '||bcl_rec.date_billed_from|| ' and the date billed to '||bcl_rec.date_billed_to; --skuchima 10416595
3947: RAISE MAIN_CUR_EXCEPTION;

Line 3952: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Before call to insert bill_txn_line');

3948: End if;
3949:
3950:
3951: If G_LOG_YES_NO = 'YES' then
3952: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Before call to insert bill_txn_line');
3953: End If;
3954:
3955: IF ((p_prv = 1) OR (p_prv = 3)) THEN
3956:

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

3969: p_btlv_tbl => l_btlv_tbl_in,
3970: x_btlv_tbl => l_btlv_tbl_out
3971: );
3972: If G_LOG_YES_NO = 'YES' then
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;

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

4015: x_btl_pr_tbl => l_btl_pr_tbl_out);
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:

Line 4069: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER, RULE_START_DATE:' || G_RAIL_REC.RULE_START_DATE);

4065: G_RAIL_REC.RULE_START_DATE := NULL;
4066: ELSE
4067: G_RAIL_REC.RULE_START_DATE := bcl_rec.DATE_BILLED_FROM;
4068: END IF;
4069: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER, RULE_START_DATE:' || G_RAIL_REC.RULE_START_DATE);
4070: /* End of Modification for Bug#14809200*/
4071:
4072: If G_LOG_YES_NO = 'YES' then
4073: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Before call to ra_interface_lines');

Line 4073: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Before call to ra_interface_lines');

4069: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER, RULE_START_DATE:' || G_RAIL_REC.RULE_START_DATE);
4070: /* End of Modification for Bug#14809200*/
4071:
4072: If G_LOG_YES_NO = 'YES' then
4073: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Before call to ra_interface_lines');
4074: End If;
4075:
4076: G_RAIL_REC.invoiced_line_acctg_level := 'S';
4077: G_RAIL_REC.source_data_key1 := bcl_rec.cle_id;

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

4084: l_msg_data
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:

Line 4112: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of Bill processing And Beginning of Revenue');

4108: END IF;
4109:
4110:
4111: If G_LOG_YES_NO = 'YES' then
4112: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of Bill processing And Beginning of Revenue');
4113: End If;
4114:
4115: /*Added for bug 14242256 */
4116: IF (p_prv <> 3) THEN

Line 4120: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIONS'||lines_rec.id);

4116: IF (p_prv <> 3) THEN
4117: insert_ra_rev_dist( l_ret_stat,bcl_rec.cle_id);
4118:
4119: IF (l_ret_stat <> 'S') THEN
4120: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIONS'||lines_rec.id);
4121:
4122: x_msg_count := l_msg_cnt;
4123: x_msg_data := l_msg_data;
4124:

Line 4132: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIONS'||lines_rec.id);

4128: ELSIF (Nvl(fnd_profile.Value('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y') ='N') THEN
4129: insert_ra_rev_dist( l_ret_stat,bcl_rec.cle_id);
4130:
4131: IF (l_ret_stat <> 'S') THEN
4132: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIONS'||lines_rec.id);
4133:
4134: RAISE MAIN_CUR_EXCEPTION;
4135: END IF;
4136:

Line 4145: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of Revenue processing And Beginning of Sales Credit');

4141:
4142:
4143:
4144: If G_LOG_YES_NO = 'YES' then
4145: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of Revenue processing And Beginning of Sales Credit');
4146: End If;
4147: --mchoudha Fix for bug#4174921
4148: --added parameter p_hdr_id
4149: Sales_credit(Bcl_rec.cle_id ,

Line 4165: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of sales credit processing ');

4161: RAISE MAIN_CUR_EXCEPTION;
4162: END IF;
4163:
4164: If G_LOG_YES_NO = 'YES' then
4165: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of sales credit processing ');
4166: End If;
4167:
4168: END IF; -- ((p_prv = 1) OR (p_prv = 3))
4169:

Line 4173: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Detail Bill Processing');

4169:
4170: ELSIF ( l_bill_profile = G_DET) THEN
4171:
4172: If G_LOG_YES_NO = 'YES' then
4173: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Detail Bill Processing');
4174: End If;
4175:
4176: ----This is for Usage averaging line to skip report
4177: if bcl_rec.bill_action = 'AV' Then

Line 4187: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Processing Sub_Line Record'||BSL_REC_NUM||'.'||bsl_rec.cle_id);

4183: FOR BSL_REC IN Cur_BSL(Bcl_rec.id)
4184: LOOP
4185:
4186: If G_LOG_YES_NO = 'YES' then
4187: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Processing Sub_Line Record'||BSL_REC_NUM||'.'||bsl_rec.cle_id);
4188: End If;
4189: BSL_REC_NUM := BSL_REC_NUM + 1;
4190: l_bill_instance_number := NULL;
4191:

Line 4272: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER Auto Invoice Not Run'||Bcl_rec.cle_id);

4268: -- l_cust_trx_line_id
4269: );
4270:
4271: IF (l_ret_stat <> 'S') THEN
4272: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER Auto Invoice Not Run'||Bcl_rec.cle_id);
4273:
4274: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4275:
4276: l_msg_data:='OKS_ARFEEDER_PUB.Get_REC_FEEDER Auto Invoice Not Run '||Bcl_rec.cle_id ||

Line 4283: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After calling Set_ref_line_id ');

4279: RAISE MAIN_CUR_EXCEPTION;
4280: End if;
4281:
4282: If G_LOG_YES_NO = 'YES' then
4283: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After calling Set_ref_line_id ');
4284: End If;
4285:
4286: IF ((p_prv =1) OR ( p_prv = 3)) THEN
4287: /*Added for bug:10010880*/

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

4308: p_btlv_tbl => l_btlv_tbl_in,
4309: x_btlv_tbl => l_btlv_tbl_out
4310: );
4311: If G_LOG_YES_NO = 'YES' then
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;

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

4357:
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:

Line 4437: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After calling Set_line_attribute ');

4433: );
4434:
4435:
4436: If G_LOG_YES_NO = 'YES' then
4437: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After calling Set_line_attribute ');
4438: End If;
4439:
4440: G_RAIL_REC.INTERFACE_LINE_ATTRIBUTE4 :=
4441: to_char(Bsl_rec.DATE_BILLED_FROM,'YYYY/MM/DD');

Line 4452: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER, RULE_START_DATE:' || G_RAIL_REC.RULE_START_DATE);

4448: G_RAIL_REC.RULE_START_DATE := NULL;
4449: ELSE
4450: G_RAIL_REC.RULE_START_DATE := Bsl_rec.DATE_BILLED_FROM;
4451: END IF;
4452: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER, RULE_START_DATE:' || G_RAIL_REC.RULE_START_DATE);
4453: /* End of Modification for Bug#14809200*/
4454: -- Added by sjanakir for Bug#6524778
4455: IF l_type IN ('ACC_DUR','A') THEN
4456: G_RAIL_REC.RULE_END_DATE := NULL;

Line 4463: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Before insert into ra_interface_lines');

4459: END IF;
4460: -- Addition Ends
4461:
4462: If G_LOG_YES_NO = 'YES' then
4463: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Before insert into ra_interface_lines');
4464: End If;
4465:
4466: G_RAIL_REC.invoiced_line_acctg_level := 'D';
4467: G_RAIL_REC.source_data_key1 := bsl_rec.top_line_id;

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

4518:
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:

Line 4537: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIO NS'||lines_rec.id);

4533: INSERT_RA_REV_DIST( l_ret_stat,
4534: bcl_rec.cle_id);
4535:
4536: IF (l_ret_stat <> 'S') THEN
4537: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIO NS'||lines_rec.id);
4538:
4539: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4540: RAISE MAIN_CUR_EXCEPTION;
4541: END IF;

Line 4544: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of Revenue processing And Beginning of Sales Credit');

4540: RAISE MAIN_CUR_EXCEPTION;
4541: END IF;
4542:
4543: If G_LOG_YES_NO = 'YES' then
4544: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of Revenue processing And Beginning of Sales Credit');
4545: End If;
4546: --mchoudha Fix for bug#4174921
4547: --added parameter p_hdr_id
4548: SALES_CREDIT(Bcl_rec.cle_id ,

Line 4553: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED'||lines_rec.id);

4549: Bcl_rec.dnz_chr_id,
4550: l_ret_stat);
4551:
4552: IF ( l_ret_stat <> 'S') THEN
4553: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED'||lines_rec.id);
4554: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4555:
4556: l_msg_data:= 'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED '||lines_rec.id; --skuchima 10416595
4557:

Line 4561: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of sales credit processing ');

4557:
4558: RAISE MAIN_CUR_EXCEPTION;
4559: END IF;
4560: If G_LOG_YES_NO = 'YES' then
4561: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of sales credit processing ');
4562: End If;
4563: END IF; -----IF (p_prv = 1)
4564:
4565: IF p_prv = 3 AND bcl_rec.bill_action = 'TR' AND l_inv_count= 0 THEN ----billing rec not Invoiced

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

4603:
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:

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

4624: l_msg_data
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:

Line 4654: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIONS'||lines_rec.id);

4650: /*Added for bug 14242256 */
4651: IF (p_prv <> 3) THEN
4652: insert_ra_rev_dist( l_ret_stat,bcl_rec.cle_id);
4653: IF (l_ret_stat <> 'S') THEN
4654: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIONS'||lines_rec.id);
4655: RAISE MAIN_CUR_EXCEPTION;
4656: END IF;
4657: ELSIF (Nvl(fnd_profile.Value('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y') ='N') THEN
4658: insert_ra_rev_dist( l_ret_stat,bcl_rec.cle_id);

Line 4660: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIONS'||lines_rec.id);

4656: END IF;
4657: ELSIF (Nvl(fnd_profile.Value('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y') ='N') THEN
4658: insert_ra_rev_dist( l_ret_stat,bcl_rec.cle_id);
4659: IF (l_ret_stat <> 'S') THEN
4660: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIONS'||lines_rec.id);
4661: RAISE MAIN_CUR_EXCEPTION;
4662: END IF;
4663: END IF;
4664: /*Added for bug 14242256 */

Line 4668: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of Revenue processing And Beginning of Sales Credit');

4664: /*Added for bug 14242256 */
4665:
4666:
4667: If G_LOG_YES_NO = 'YES' then
4668: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of Revenue processing And Beginning of Sales Credit');
4669: End If;
4670: --mchoudha Fix for bug#4174921
4671: --added parameter p_hdr_id
4672: SALES_CREDIT(Bcl_rec.cle_id ,

Line 4677: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED'||lines_rec.id);

4673: Bcl_rec.dnz_chr_id,
4674: l_ret_stat);
4675:
4676: IF ( l_ret_stat <> 'S') THEN
4677: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED'||lines_rec.id);
4678: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4679: l_msg_data:= 'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED '||lines_rec.id; ---skuchima
4680: RAISE MAIN_CUR_EXCEPTION;
4681: END IF;

Line 4683: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of sales credit processing ');

4679: l_msg_data:= 'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED '||lines_rec.id; ---skuchima
4680: RAISE MAIN_CUR_EXCEPTION;
4681: END IF;
4682: If G_LOG_YES_NO = 'YES' then
4683: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of sales credit processing ');
4684: End If;
4685: END IF; --IF ( ((p_prv = 1) AND ( NVL(l_interface_pb,'N') = 'Y'))OR ((p_prv = 3 ) AND (l_inv_count > 1)) )
4686:
4687: END IF; --((p_prv =1) OR (p_prv = 3))

Line 4776: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER MAIN_CUR_EXCEPTION RAISED '||sqlerrm);

4772: END IF; -- l_bill_profile = G_SUM
4773: END IF; -- bcl_rec.lse_id = 46
4774: END IF; -- P_PRV <> 3
4775:
4776: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER MAIN_CUR_EXCEPTION RAISED '||sqlerrm);
4777: l_reject_counter := l_reject_counter + 1;
4778: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4779: x_return_status := OKC_API.G_RET_STS_ERROR;
4780: WHEN OTHERS THEN

Line 4840: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER OTHERS EXCEPTION RAISED'||sqlerrm);

4836: END IF; -- bcl_rec.lse_id = 46
4837: END IF; -- P_PRV <> 3
4838:
4839: x_return_status := OKC_API.G_RET_STS_ERROR;
4840: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER OTHERS EXCEPTION RAISED'||sqlerrm);
4841: l_reject_counter := l_reject_counter + 1;
4842: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4843:
4844: END;

Line 4895: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.debug report'||l_subline_count);

4891: select count(id) into l_subline_count from oks_bill_sub_lines where bcl_id = Bcl_rec.id;
4892: elsif p_prv = 2 then
4893: select count(id) into l_subline_count from oks_bsl_pr where bcl_id = Bcl_rec.id;
4894: end if;
4895: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.debug report'||l_subline_count);
4896:
4897: p_billrep_tbl(p_billrep_tbl_idx).Successful_SubLines:= p_billrep_tbl(p_billrep_tbl_idx).Successful_SubLines +l_subline_count;
4898: END IF;
4899: END IF;

Line 4906: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER G_BILLING_EXCEPTION RAISED '||sqlerrm);

4902:
4903: EXCEPTION
4904: WHEN G_EXCEPTION_BILLING THEN
4905: --x_return_status := OKC_API.G_RET_STS_ERROR;
4906: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER G_BILLING_EXCEPTION RAISED '||sqlerrm);
4907: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4908: WHEN OTHERS THEN
4909: --x_return_status := OKC_API.G_RET_STS_ERROR;
4910: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER WHEN OTHERS EXCEPTION RAISED'||sqlerrm);

Line 4910: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER WHEN OTHERS EXCEPTION RAISED'||sqlerrm);

4906: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER G_BILLING_EXCEPTION RAISED '||sqlerrm);
4907: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4908: WHEN OTHERS THEN
4909: --x_return_status := OKC_API.G_RET_STS_ERROR;
4910: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER WHEN OTHERS EXCEPTION RAISED'||sqlerrm);
4911: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4912:
4913: End Get_REC_FEEDER;
4914:

Line 5090: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert into RA_Interface_Lines Failed while inserting price breaks ' );

5086: x_msg_data
5087: );
5088:
5089: IF (x_return_status <> 'S') THEN
5090: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert into RA_Interface_Lines Failed while inserting price breaks ' );
5091: x_return_status := 'E';
5092: END IF; --IF (l_ret_stat <> 'S')
5093:
5094: /*Added for bug 14242256*/

Line 5099: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert INTO RA_REVENUE_DISTRIBUTIONS failed for Price Break');

5095: IF Nvl(fnd_profile.Value('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y') ='N' THEN
5096: INSERT_RA_REV_DIST( x_return_status,
5097: p_bcl_cle_id);
5098: IF (x_return_status <> 'S') THEN
5099: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert INTO RA_REVENUE_DISTRIBUTIONS failed for Price Break');
5100:
5101: x_return_status := 'E';
5102: END IF;
5103: END IF;

Line 5115: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert INTO RA_SALES_CREDIT FAILED for Price Breaks');

5111: p_hdr_id,
5112: x_return_status);
5113:
5114: IF ( x_return_status <> 'S') THEN
5115: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert INTO RA_SALES_CREDIT FAILED for Price Breaks');
5116: END IF;
5117:
5118:
5119: EXIT when x_return_status <> 'S';

Line 5138: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert into RA_Interface_Lines Failed while inserting price breaks ' );

5134: x_msg_data
5135: );
5136:
5137: IF (x_return_status <> 'S') THEN
5138: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert into RA_Interface_Lines Failed while inserting price breaks ' );
5139: x_return_status := 'E';
5140: END IF; --IF (l_ret_stat <> 'S')
5141:
5142: /*Added for bug 14242256*/

Line 5147: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert INTO RA_REVENUE_DISTRIBUTIONS failed for Price Break');

5143: IF Nvl(fnd_profile.Value('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y') ='N' THEN
5144: INSERT_RA_REV_DIST( x_return_status,
5145: p_bcl_cle_id);
5146: IF (x_return_status <> 'S') THEN
5147: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert INTO RA_REVENUE_DISTRIBUTIONS failed for Price Break');
5148:
5149: x_return_status := 'E';
5150: END IF;
5151: END IF;

Line 5162: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert INTO RA_SALES_CREDIT FAILED for Price Breaks');

5158: p_hdr_id,
5159: x_return_status);
5160:
5161: IF ( x_return_status <> 'S') THEN
5162: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert INTO RA_SALES_CREDIT FAILED for Price Breaks');
5163: END IF;
5164:
5165: END IF;
5166: