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 947: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id IPM:reference_line_id '||G_RAIL_REC.reference_line_id);

943: OPEN comm_id_cur(p_line_commitment,p_org_id);
944: FETCH comm_id_cur into G_RAIL_REC.reference_line_id;
945: CLOSE comm_id_cur;
946: If G_LOG_YES_NO = 'YES' then
947: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id IPM:reference_line_id '||G_RAIL_REC.reference_line_id);
948: End If;
949:
950: -----check if hdr bill to account matches with the line bill to cascade commitment
951: Elsif (p_hdr_commitment is not null) Then

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

958: FETCH comm_id_cur into G_RAIL_REC.reference_line_id;
959: CLOSE comm_id_cur;
960:
961: If G_LOG_YES_NO = 'YES' then
962: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id IPM:reference_line_id '||G_RAIL_REC.reference_line_id);
963: End If;
964: Else
965: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. no commitment for line ');
966: End If;

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

961: If G_LOG_YES_NO = 'YES' then
962: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_ref_line_id IPM:reference_line_id '||G_RAIL_REC.reference_line_id);
963: End If;
964: Else
965: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. no commitment for line ');
966: End If;
967:
968: END IF;
969:

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

1174:
1175:
1176: EXCEPTION
1177: WHEN OTHERS THEN
1178: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Attributes => FAILED IN G_RAIL Field ASSIGNMENT FOR '|| p_cle_id||' Error '||sqlerrm);
1179: p_return_status := 'E';
1180:
1181: END Set_Attributes;
1182:

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

1330: BEGIN
1331: x_return_status := 'S';
1332:
1333: If G_LOG_YES_NO = 'YES' then
1334: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => AMOUNT'||G_RAIL_REC.AMOUNT);
1335: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => BATCH_SOURCE_NAME'||G_RAIL_REC.BATCH_SOURCE_NAME);
1336: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => CURRENCY_CODE'||G_RAIL_REC.CURRENCY_CODE);
1337: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => SET_OF_BOOKS_ID '||G_RAIL_REC.SET_OF_BOOKS_ID);
1338: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => ORG_ID '||G_RAIL_REC.ORG_ID);

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

1331: x_return_status := 'S';
1332:
1333: If G_LOG_YES_NO = 'YES' then
1334: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => AMOUNT'||G_RAIL_REC.AMOUNT);
1335: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => BATCH_SOURCE_NAME'||G_RAIL_REC.BATCH_SOURCE_NAME);
1336: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => CURRENCY_CODE'||G_RAIL_REC.CURRENCY_CODE);
1337: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => SET_OF_BOOKS_ID '||G_RAIL_REC.SET_OF_BOOKS_ID);
1338: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => ORG_ID '||G_RAIL_REC.ORG_ID);
1339: End If;

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

1332:
1333: If G_LOG_YES_NO = 'YES' then
1334: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => AMOUNT'||G_RAIL_REC.AMOUNT);
1335: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => BATCH_SOURCE_NAME'||G_RAIL_REC.BATCH_SOURCE_NAME);
1336: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => CURRENCY_CODE'||G_RAIL_REC.CURRENCY_CODE);
1337: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => SET_OF_BOOKS_ID '||G_RAIL_REC.SET_OF_BOOKS_ID);
1338: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => ORG_ID '||G_RAIL_REC.ORG_ID);
1339: End If;
1340:

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

1333: If G_LOG_YES_NO = 'YES' then
1334: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => AMOUNT'||G_RAIL_REC.AMOUNT);
1335: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => BATCH_SOURCE_NAME'||G_RAIL_REC.BATCH_SOURCE_NAME);
1336: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => CURRENCY_CODE'||G_RAIL_REC.CURRENCY_CODE);
1337: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => SET_OF_BOOKS_ID '||G_RAIL_REC.SET_OF_BOOKS_ID);
1338: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => ORG_ID '||G_RAIL_REC.ORG_ID);
1339: End If;
1340:
1341:

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

1334: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => AMOUNT'||G_RAIL_REC.AMOUNT);
1335: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => BATCH_SOURCE_NAME'||G_RAIL_REC.BATCH_SOURCE_NAME);
1336: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => CURRENCY_CODE'||G_RAIL_REC.CURRENCY_CODE);
1337: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => SET_OF_BOOKS_ID '||G_RAIL_REC.SET_OF_BOOKS_ID);
1338: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface => ORG_ID '||G_RAIL_REC.ORG_ID);
1339: End If;
1340:
1341:
1342: IF ((G_RAIL_REC.CONVERSION_TYPE IS NULL) AND

Line 1638: FND_FILE.PUT_LINE(FND_FILE.LOG,

1634:
1635: EXCEPTION
1636: When Others Then
1637: x_return_status := 'E';
1638: FND_FILE.PUT_LINE(FND_FILE.LOG,
1639: 'OKS_ARFEEDER_PUB.insert_ra_interface => Exception in insert into RA_INTERFACE_LINES '||' SQLCOE = '||sqlcode ||' Sqlerrm = '||sqlerrm);
1640:
1641: End insert_ra_interface;
1642: ---------------------------------------------------------------------------

Line 1716: FND_FILE.PUT_LINE(FND_FILE.LOG,

1712: CLOSE rev_dist_cur;
1713: EXCEPTION
1714: When Others Then
1715: x_return_status := 'E';
1716: FND_FILE.PUT_LINE(FND_FILE.LOG,
1717: 'OKS_ARFEEDER_PUB.insert_ra_rev_dist => Exception in insert into RA_INTERFACE_DISTRIBUTIONS'||' SQLCODE ='||SQLCODE||' SQLERRM = '||SQLERRM);
1718:
1719: END;
1720:

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

1735: BEGIN
1736: x_return_status := 'S';
1737:
1738: If G_LOG_YES_NO = 'YES' then
1739: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface_sc => AMOUNT'||G_RAISC_REC.SALES_CREDIT_AMOUNT_SPLIT);
1740: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface_sc => PERCENT'||G_RAISC_REC.SALES_CREDIT_PERCENT_SPLIT);
1741: End If;
1742:
1743:

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

1736: x_return_status := 'S';
1737:
1738: If G_LOG_YES_NO = 'YES' then
1739: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface_sc => AMOUNT'||G_RAISC_REC.SALES_CREDIT_AMOUNT_SPLIT);
1740: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.insert_ra_interface_sc => PERCENT'||G_RAISC_REC.SALES_CREDIT_PERCENT_SPLIT);
1741: End If;
1742:
1743:
1744:

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

1785: -- G_RAISC_REC := G_INIT_RAISC_REC;
1786:
1787: EXCEPTION
1788: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1789: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in insert RA_INTERFACE_SALESCREDITS ' || sqlerrm);
1790:
1791: When Others Then
1792: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1793: FND_FILE.PUT_LINE(FND_FILE.LOG,

Line 1793: FND_FILE.PUT_LINE(FND_FILE.LOG,

1789: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in insert RA_INTERFACE_SALESCREDITS ' || sqlerrm);
1790:
1791: When Others Then
1792: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1793: FND_FILE.PUT_LINE(FND_FILE.LOG,
1794: 'OKS_ARFEEDER_PUB.insert_ra_interface_sc => Exception in insert into RA_INTERFACE_SALESCREDITS'||' SQLCODE = '||SQLCODE ||' SQLERRM = '||SQLERRM);
1795:
1796: End insert_ra_interface_sc;
1797:

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

1842: if(Sales_credit_cur%NOTFOUND) THEN
1843: For Sales_credit_hdr_rec in Sales_credit_hdr_cur
1844: Loop
1845: if G_LOG_YES_NO = 'YES' then
1846: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Sales_credit => Header Level RA_Interface_SalesCredit');
1847: end if;
1848: G_RAISC_REC.SALESREP_ID := Sales_credit_hdr_rec.CTC_ID;
1849: G_RAISC_REC.SALES_CREDIT_TYPE_ID := to_number(Sales_credit_hdr_rec.SALES_CREDIT_TYPE_ID1);
1850: G_RAISC_REC.SALES_CREDIT_PERCENT_SPLIT :=Sales_credit_hdr_rec.PERCENT;

Line 1864: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Sales_credit => Insert into RA_Interface_SalesCredit Failed For header id '||p_hdr_id);

1860: If l_return_status <> 'S' THEN
1861: oks_bill_rec_pub.get_message
1862: (l_msg_cnt => l_msg_cnt,
1863: l_msg_data => l_msg_data);
1864: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Sales_credit => Insert into RA_Interface_SalesCredit Failed For header id '||p_hdr_id);
1865:
1866: End If;
1867:
1868:

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

1869: End Loop;--End of sales credit header Loop
1870: else
1871: LOOP
1872: If G_LOG_YES_NO = 'YES' then
1873: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Sales_credit =>Line level RA_Interface_SalesCredit');
1874: End If;
1875: Exit WHEN Sales_credit_cur%NOTFOUND;
1876: G_RAISC_REC.SALESREP_ID := Sales_credit_rec.CTC_ID;
1877: G_RAISC_REC.SALES_CREDIT_TYPE_ID := to_number(Sales_credit_rec.SALES_CREDIT_TYPE_ID1);

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

1890: IF (l_return_status <> 'S') THEN
1891: oks_bill_rec_pub.get_message
1892: (L_MSG_CNT => l_msg_cnt,
1893: L_MSG_DATA => l_msg_data);
1894: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Sales_credit => Insert into RA_Interface_SalesCredit Failed For'||p_id);
1895:
1896: End If;
1897:
1898: Fetch Sales_credit_cur into Sales_credit_rec;

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

2010: x_msg_data
2011: );
2012:
2013: IF (x_return_status <> 'S') THEN
2014: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert into RA_Interface_Lines Failed while inserting price breaks ' );
2015: x_return_status := 'E';
2016: END IF; --IF (l_ret_stat <> 'S')
2017:
2018:

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

2019: INSERT_RA_REV_DIST( x_return_status,
2020: p_bcl_cle_id);
2021:
2022: IF (x_return_status <> 'S') THEN
2023: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert INTO RA_REVENUE_DISTRIBUTIONS failed for Price Break');
2024:
2025: x_return_status := 'E';
2026: END IF;
2027:

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

2031: p_hdr_id,
2032: x_return_status);
2033:
2034: IF ( x_return_status <> 'S') THEN
2035: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert INTO RA_SALES_CREDIT FAILED for Price Breaks');
2036: END IF;
2037:
2038: EXIT When x_return_status <> 'S';
2039: END LOOP;

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

2088: x_msg_data
2089: );
2090:
2091: IF (x_return_status <> 'S') THEN
2092: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert into RA_Interface_Lines Failed while inserting price breaks ' );
2093: x_return_status := 'E';
2094: END IF; --IF (l_ret_stat <> 'S')
2095:
2096:

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

2097: INSERT_RA_REV_DIST( x_return_status,
2098: p_bcl_cle_id);
2099:
2100: IF (x_return_status <> 'S') THEN
2101: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert INTO RA_REVENUE_DISTRIBUTIONS failed for Price Break');
2102:
2103: x_return_status := 'E';
2104: END IF;
2105:

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

2109: p_hdr_id,
2110: x_return_status);
2111:
2112: IF ( x_return_status <> 'S') THEN
2113: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert INTO RA_SALES_CREDIT FAILED for Price Breaks');
2114: END IF;
2115:
2116:
2117: EXIT when x_return_status <> 'S';

Line 2166: FND_FILE.PUT_LINE(FND_FILE.LOG,

2162:
2163: EXCEPTION
2164: WHEN OTHERS THEN
2165: x_return_status := 'E';
2166: FND_FILE.PUT_LINE(FND_FILE.LOG,
2167: 'OKS_ARFEEDER_PUB.Get_Pay_Method_Info => Exception in insert into GET_PAY_METHOD'||' SQLCODE = '||SQLCODE||' SQLERRM = '||SQLERRM);
2168:
2169:
2170: END Get_Pay_Method_Info;

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

2784: INTO l_pay_method_id
2785: FROM ra_cust_receipt_methods
2786: WHERE cust_receipt_method_id = l_cust_pay_method_id;
2787: IF G_LOG_YES_NO = 'YES' THEN
2788: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method id is '||l_pay_method_id);
2789: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Customer Payment method id is '||l_cust_pay_method_id);
2790: END IF;
2791: ELSE
2792:

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

2785: FROM ra_cust_receipt_methods
2786: WHERE cust_receipt_method_id = l_cust_pay_method_id;
2787: IF G_LOG_YES_NO = 'YES' THEN
2788: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method id is '||l_pay_method_id);
2789: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Customer Payment method id is '||l_cust_pay_method_id);
2790: END IF;
2791: ELSE
2792:
2793: l_pay_method_id := to_number(nvl(FND_PROFILE.VALUE_SPECIFIC('OKS_RECEIPT_METHOD_ID', NULL, NULL, NULL, p_org_id, NULL),'0'));

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

2793: l_pay_method_id := to_number(nvl(FND_PROFILE.VALUE_SPECIFIC('OKS_RECEIPT_METHOD_ID', NULL, NULL, NULL, p_org_id, NULL),'0'));
2794:
2795: IF l_pay_method_id = 0 THEN
2796: IF G_LOG_YES_NO = 'YES' THEN
2797: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method id is '||l_pay_method_id);
2798: 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');
2799: END IF;
2800: RAISE MAIN_CUR_EXCEPTION;
2801: END IF;

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

2794:
2795: IF l_pay_method_id = 0 THEN
2796: IF G_LOG_YES_NO = 'YES' THEN
2797: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method id is '||l_pay_method_id);
2798: 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');
2799: END IF;
2800: RAISE MAIN_CUR_EXCEPTION;
2801: END IF;
2802:

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

2805: p_customer_id => p_customer_id,
2806: p_site_use_id => p_site_use_id,
2807: p_as_of_date => TRUNC(p_as_of_date));
2808: IF G_LOG_YES_NO = 'YES' THEN
2809: 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);
2810: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Customer Payment method id is '||l_cust_pay_method_id);
2811: END IF;
2812: END IF;
2813:

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

2806: p_site_use_id => p_site_use_id,
2807: p_as_of_date => TRUNC(p_as_of_date));
2808: IF G_LOG_YES_NO = 'YES' THEN
2809: 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);
2810: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Customer Payment method id is '||l_cust_pay_method_id);
2811: END IF;
2812: END IF;
2813:
2814: RETURN l_pay_method_id;

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

2843: AND ipa.instrument_id = ic.instrid;
2844: EXCEPTION
2845: WHEN NO_DATA_FOUND THEN
2846: IF G_LOG_YES_NO = 'YES' THEN
2847: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card details not found for Payment Transaction Extension ID');
2848: END IF;
2849: RAISE MAIN_CUR_EXCEPTION;
2850: WHEN OTHERS THEN
2851: IF G_LOG_YES_NO = 'YES' THEN

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

2848: END IF;
2849: RAISE MAIN_CUR_EXCEPTION;
2850: WHEN OTHERS THEN
2851: IF G_LOG_YES_NO = 'YES' THEN
2852: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Error retrieving Credit card details for Payment Transaction Extension ID');
2853: END IF;
2854: RAISE MAIN_CUR_EXCEPTION;
2855: END;
2856:

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

2876: IF l_ret_stat = OKC_API.G_RET_STS_SUCCESS
2877: THEN
2878: IF v_cc_type=IBY_CC_VALIDATE.c_InvalidCC THEN
2879: IF G_LOG_YES_NO = 'YES' THEN
2880: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card number Format is invalid.');
2881: END IF;
2882: RAISE MAIN_CUR_EXCEPTION;
2883: ELSE
2884: IF G_LOG_YES_NO = 'YES' THEN

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

2881: END IF;
2882: RAISE MAIN_CUR_EXCEPTION;
2883: ELSE
2884: IF G_LOG_YES_NO = 'YES' THEN
2885: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card number Format is valid.');
2886: END IF;
2887: END IF;
2888:
2889: iby_cc_validate.validatecc( p_api_version => 1.0,

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

2899:
2900: ELSE
2901:
2902: IF G_LOG_YES_NO = 'YES' THEN
2903: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Error retrieving Credit card Type.');
2904: END IF;
2905:
2906: RETURN FALSE;
2907:

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

2908: END IF;
2909: ELSE
2910:
2911: IF G_LOG_YES_NO = 'YES' THEN
2912: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Error retrieving Credit card number.');
2913: END IF;
2914:
2915: RETURN FALSE;
2916:

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

2935: --in place OKS_BILLING_PUB.l_write_log to decide whether to log
2936: --messages
2937: G_LOG_YES_NO := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');
2938:
2939: 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);
2940:
2941:
2942: /*FOR BILLING REPORT*/
2943: l_subline_failed := FALSE;

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

2975: l_lse_id := bcl_rec.lse_id;
2976: Open l_usage_csr(bcl_rec.cle_id,Bcl_rec.dnz_chr_id);
2977: Fetch l_usage_csr into l_usage_type;
2978: Close l_usage_csr;
2979: FND_FILE.PUT_LINE(FND_FILE.LOG,'Usage Type '||l_usage_type);
2980: -- End for bug#4390448
2981:
2982: l_select_counter := l_select_counter + 1;
2983: l_bill_instance_number := NULL;

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

2987: CLOSE cur_hdr_rules;
2988:
2989:
2990: If G_LOG_YES_NO = 'YES' then
2991: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => p_prv '||p_prv);
2992: 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'));
2993: End If;
2994:
2995:

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

2988:
2989:
2990: If G_LOG_YES_NO = 'YES' then
2991: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => p_prv '||p_prv);
2992: 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'));
2993: End If;
2994:
2995:
2996: IF (nvl(rul_hdr_rec.hold_billing_flag,'N') = 'Y') THEN

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

3012: AND (rul_hdr_rec.ar_interface_yn ='Y')) ) THEN /* Added By sjanakir for Bug # 6821826 */
3013:
3014:
3015: If G_LOG_YES_NO = 'YES' then
3016: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Processing Line : '|| Bcl_rec.cle_id);
3017: End If;
3018:
3019: OPEN Cur_K_headers(Bcl_rec.dnz_chr_id);
3020: FETCH Cur_k_headers into header_rec;

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

3040: p_btnv_tbl => l_btnv_tbl_in,
3041: x_btnv_tbl => l_btnv_tbl_out
3042: );
3043: If G_LOG_YES_NO = 'YES' then
3044: 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);
3045: End If;
3046:
3047: ELSIF (p_prv = 2) THEN
3048: l_btn_pr_tbl_in(1).ID :=oks_bill_rec_pub.get_Seq_id;

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

3082: SET btn_id = l_btnv_tbl_out(1).id
3083: WHERE id = bcl_rec.id ;
3084:
3085: If G_LOG_YES_NO = 'YES' then
3086: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Updating btn_id of oks_bill_cont_lines');
3087: End If;
3088:
3089: l_btlv_tbl_in(1).btn_id := l_btnv_tbl_out(1).id;
3090: l_btlv_tbl_in(1).bcl_id := bcl_rec.id;

Line 3102: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into Bill_Transactions Failed For Line : '||Bcl_rec.cle_id);

3098: l_btl_pr_tbl_in(1).BCL_ID := Bcl_rec.id;
3099: END IF;
3100: ELSE -- (l_ret_stat = 'S')
3101: If G_LOG_YES_NO = 'YES' then
3102: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into Bill_Transactions Failed For Line : '||Bcl_rec.cle_id);
3103: End If;
3104:
3105: oks_bill_rec_pub.get_message(
3106: l_msg_cnt => l_msg_cnt,

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

3199: bcl_rec.bill_action,
3200: l_hdr_sbg_object1_id1,
3201: header_rec.org_id);
3202: If G_LOG_YES_NO = 'YES' then
3203: 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);
3204: End If;
3205:
3206: IF (rul_hdr_rec.acct_rule_id IS NOT NULL) THEN
3207: OPEN acct_type(rul_hdr_rec.acct_rule_id);

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

3228: RETURN_CODE => l_ret_stat,
3229: UNMAPPED_DATE => l_unmapped_date);
3230:
3231: If G_LOG_YES_NO = 'YES' then
3232: 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);
3233: End If;
3234:
3235: G_RAIL_REC.ACCOUNTING_RULE_DURATION := l_num_periods;
3236: -- This column must be a positive integer for AR

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

3285: --reset the tax_exempt_flag to 'S'
3286: G_RAIL_REC.TAX_EXEMPT_FLAG := 'S';
3287: ELSE
3288: If G_LOG_YES_NO = 'YES' then
3289: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. Exempt numer '||tax_rec.exempt_certificate_number||' Reason '||tax_rec.exempt_reason_code);
3290: End If;
3291: G_RAIL_REC.TAX_EXEMPT_NUMBER := tax_rec.exempt_certificate_number;
3292: G_RAIL_REC.TAX_EXEMPT_REASON_CODE := tax_rec.exempt_reason_code;
3293: END IF;

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

3377:
3378: ------END OF HEADER RULE READING -------------------
3379:
3380: If G_LOG_YES_NO = 'YES' then
3381: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End Of Header Rule Processing And Beginning Of Line Rule processing');
3382: End If;
3383:
3384: ------LINE RULE READ --------------------------------
3385:

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

3440: G_RAIL_REC.TAX_EXEMPT_FLAG := 'S';
3441:
3442: ELSE
3443: If G_LOG_YES_NO = 'YES' then
3444: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. Exempt numer '||tax_rec.exempt_certificate_number||' Reason '||tax_rec.exempt_reason_code);
3445: End If;
3446: G_RAIL_REC.TAX_EXEMPT_NUMBER := tax_rec.exempt_certificate_number;
3447: G_RAIL_REC.TAX_EXEMPT_REASON_CODE := tax_rec.exempt_reason_code;
3448: END IF;

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

3467: CLOSE Cur_Batch_Source_Id;
3468:
3469:
3470: If G_LOG_YES_NO = 'YES' then
3471: 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);
3472: 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);
3473: 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);
3474: end if;
3475:

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

3468:
3469:
3470: If G_LOG_YES_NO = 'YES' then
3471: 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);
3472: 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);
3473: 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);
3474: end if;
3475:
3476:

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

3469:
3470: If G_LOG_YES_NO = 'YES' then
3471: 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);
3472: 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);
3473: 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);
3474: end if;
3475:
3476:
3477: ZX_TCM_VALIDATE_EXEMPT_PKG.VALIDATE_TAX_EXEMPTIONS

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

3496:
3497:
3498: if l_valid_flag <> 'Y' Then
3499: If G_LOG_YES_NO = 'YES' then
3500: 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);
3501: End If;
3502: --reset the tax_exempt_flag to 'S'
3503: G_RAIL_REC.TAX_EXEMPT_FLAG := 'S';
3504: G_RAIL_REC.TAX_EXEMPT_NUMBER := NULL;

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

3527: IF (Rul_line_rec.tax_classification_code IS NOT NULL) THEN
3528: --new contracts
3529: G_RAIL_REC.TAX_CODE := Rul_line_rec.tax_classification_code;
3530: If G_LOG_YES_NO = 'YES' then
3531: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. classification code '||G_RAIL_REC.TAX_CODE);
3532: End If;
3533: ELSIF Rul_line_rec.tax_code IS NOT NULL THEN
3534: --old contracts
3535: OPEN cur_tax_code(Rul_line_rec.tax_code, rul_hdr_rec.org_id);

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

3535: OPEN cur_tax_code(Rul_line_rec.tax_code, rul_hdr_rec.org_id);
3536: FETCH cur_tax_code into G_RAIL_REC.TAX_CODE;
3537: CLOSE cur_tax_code;
3538: If G_LOG_YES_NO = 'YES' then
3539: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. derived from tax code '||G_RAIL_REC.TAX_CODE);
3540: End If;
3541:
3542: ELSE
3543: G_RAIL_REC.TAX_CODE := NULL;

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

3611:
3612:
3613:
3614: If G_LOG_YES_NO = 'YES' then
3615: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Done with processing line rules');
3616: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Updated all G_RAIL Field');
3617: End If;
3618:
3619:

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

3612:
3613:
3614: If G_LOG_YES_NO = 'YES' then
3615: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Done with processing line rules');
3616: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Updated all G_RAIL Field');
3617: End If;
3618:
3619:
3620:

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

3622: bcl_rec.cle_id,
3623: bcl_rec.date_billed_from,
3624: bcl_rec.bill_action);
3625: If G_LOG_YES_NO = 'YES' then
3626: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_aggrement_and_contacts');
3627: End If;
3628:
3629: Set_comments(bcl_rec.bill_action);
3630: If G_LOG_YES_NO = 'YES' then

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

3627: End If;
3628:
3629: Set_comments(bcl_rec.bill_action);
3630: If G_LOG_YES_NO = 'YES' then
3631: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_comments ');
3632: End If;
3633:
3634: Set_attributes(rul_hdr_rec.contract_number,
3635: rul_hdr_rec.contract_number_modifier,

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

3666: END IF;
3667: -- Addition Ends
3668:
3669: If G_LOG_YES_NO = 'YES' then
3670: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_attributes ');
3671: End If;
3672:
3673:
3674: G_RAIL_REC.sales_order_line := bcl_rec.top_line_number;

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

3674: G_RAIL_REC.sales_order_line := bcl_rec.top_line_number;
3675: G_RAIL_REC.contract_line_id := bcl_rec.cle_id;
3676:
3677: If G_LOG_YES_NO = 'YES' then
3678: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After setting line number ');
3679: End If;
3680:
3681: Set_gl_date ( p_cle_id => bcl_rec.cle_id,
3682: p_date_billed_from => to_date(G_RAIL_REC.INTERFACE_LINE_ATTRIBUTE7,'YYYY/MM/DD HH24:MI:SS'),

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

3682: p_date_billed_from => to_date(G_RAIL_REC.INTERFACE_LINE_ATTRIBUTE7,'YYYY/MM/DD HH24:MI:SS'),
3683: p_bill_action => bcl_rec.bill_action);
3684:
3685: If G_LOG_YES_NO = 'YES' then
3686: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_gl_date ');
3687: End If;
3688:
3689:
3690: IF (l_ret_stat <> 'S') THEN

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

3705:
3706: IF (P_PRV = 1 ) Then
3707:
3708: If G_LOG_YES_NO = 'YES' then
3709: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method is '||rul_hdr_rec.payment_type);
3710: End If;
3711:
3712: IF nvl(rul_hdr_rec.payment_type,'XX') = 'COM'
3713: and bcl_rec.trxn_extension_id is NULL then

Line 3761: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card is valid and active');

3757: l_cc_valid := check_CC_valid ( p_trxn_extension_id => G_RAIL_REC.payment_trxn_extension_id);
3758:
3759: IF l_cc_valid THEN
3760: IF G_LOG_YES_NO = 'YES' THEN
3761: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card is valid and active');
3762: END IF;
3763: ELSE
3764: IF G_LOG_YES_NO = 'YES' THEN
3765: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card is invalid or inactive');

Line 3765: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card is invalid or inactive');

3761: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card is valid and active');
3762: END IF;
3763: ELSE
3764: IF G_LOG_YES_NO = 'YES' THEN
3765: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Credit card is invalid or inactive');
3766: END IF;
3767:
3768: RAISE MAIN_CUR_EXCEPTION;
3769: END IF;

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

3776:
3777:
3778: Set_salesrep_id (bcl_rec.dnz_Chr_id);
3779: If G_LOG_YES_NO = 'YES' then
3780: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_salesrep_id ');
3781: End If;
3782:
3783: Set_qty_and_uom(bcl_rec.cle_id,
3784: bcl_rec.dnz_chr_id,

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

3787: bcl_rec.bill_action,
3788: bcl_rec.lse_id,
3789: 'Y');
3790: If G_LOG_YES_NO = 'YES' then
3791: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After Calling Set_qty_and_uom ');
3792: End If;
3793:
3794:
3795: /****

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

3857:
3858:
3859: IF (l_bill_profile = G_SUM) THEN
3860: If G_LOG_YES_NO = 'YES' then
3861: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Summary Bill Processing');
3862: End If;
3863: Set_ref_line_id( bcl_rec.bill_action,
3864: bcl_rec.lse_id,
3865: bcl_rec.cle_id,

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

3878: -- l_cust_trx_line_id
3879: );
3880:
3881: IF (l_ret_stat <> 'S') THEN
3882: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER Auto Invoice Not Run'||Bcl_rec.cle_id);
3883: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
3884: RAISE MAIN_CUR_EXCEPTION;
3885: End if;
3886:

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

3885: End if;
3886:
3887:
3888: If G_LOG_YES_NO = 'YES' then
3889: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Before call to insert bill_txn_line');
3890: End If;
3891:
3892: IF ((p_prv = 1) OR (p_prv = 3)) THEN
3893:

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

3906: p_btlv_tbl => l_btlv_tbl_in,
3907: x_btlv_tbl => l_btlv_tbl_out
3908: );
3909: If G_LOG_YES_NO = 'YES' then
3910: 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);
3911: End If;
3912:
3913: ELSIF (p_prv = 2) THEN
3914: l_btl_pr_tbl_in(1).ID := oks_bill_rec_pub.get_seq_id;

Line 3956: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER Insert into Bill_Tran_lines Failed For'||Bcl_rec.cle_id);

3952: x_btl_pr_tbl => l_btl_pr_tbl_out);
3953: END IF;
3954:
3955: IF (l_ret_stat <> 'S') THEN
3956: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER Insert into Bill_Tran_lines Failed For'||Bcl_rec.cle_id);
3957: oks_bill_rec_pub.get_message
3958: (l_msg_cnt => l_msg_cnt,
3959: l_msg_data => l_msg_data);
3960:

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

3998: );
3999:
4000:
4001: If G_LOG_YES_NO = 'YES' then
4002: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Before call to ra_interface_lines');
4003: End If;
4004:
4005: G_RAIL_REC.invoiced_line_acctg_level := 'S';
4006: G_RAIL_REC.source_data_key1 := bcl_rec.cle_id;

Line 4017: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into RA_Interface_Lines Failed For'||Bcl_rec.cle_id);

4013: l_msg_data
4014: );
4015:
4016: IF (l_ret_stat <> 'S') THEN
4017: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into RA_Interface_Lines Failed For'||Bcl_rec.cle_id);
4018: oks_bill_rec_pub.get_message
4019: (l_msg_cnt => l_msg_cnt,
4020: l_msg_data => l_msg_data);
4021:

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

4037: END IF;
4038:
4039:
4040: If G_LOG_YES_NO = 'YES' then
4041: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of Bill processing And Beginning of Revenue');
4042: End If;
4043:
4044: insert_ra_rev_dist( l_ret_stat,bcl_rec.cle_id);
4045:

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

4043:
4044: insert_ra_rev_dist( l_ret_stat,bcl_rec.cle_id);
4045:
4046: IF (l_ret_stat <> 'S') THEN
4047: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIONS'||lines_rec.id);
4048: IF (P_PRV <> 3) THEN
4049: x_msg_count := l_msg_cnt;
4050: x_msg_data := l_msg_data;
4051:

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

4055: END IF;
4056:
4057:
4058: If G_LOG_YES_NO = 'YES' then
4059: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of Revenue processing And Beginning of Sales Credit');
4060: End If;
4061: --mchoudha Fix for bug#4174921
4062: --added parameter p_hdr_id
4063: Sales_credit(Bcl_rec.cle_id ,

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

4075: RAISE MAIN_CUR_EXCEPTION;
4076: END IF;
4077:
4078: If G_LOG_YES_NO = 'YES' then
4079: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of sales credit processing ');
4080: End If;
4081:
4082: END IF; -- ((p_prv = 1) OR (p_prv = 3))
4083:

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

4083:
4084: ELSIF ( l_bill_profile = G_DET) THEN
4085:
4086: If G_LOG_YES_NO = 'YES' then
4087: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Detail Bill Processing');
4088: End If;
4089:
4090: ----This is for Usage averaging line to skip report
4091: if bcl_rec.bill_action = 'AV' Then

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

4097: FOR BSL_REC IN Cur_BSL(Bcl_rec.id)
4098: LOOP
4099:
4100: If G_LOG_YES_NO = 'YES' then
4101: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Processing Sub_Line Record'||BSL_REC_NUM||'.'||bsl_rec.cle_id);
4102: End If;
4103: BSL_REC_NUM := BSL_REC_NUM + 1;
4104: l_bill_instance_number := NULL;
4105:

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

4182: -- l_cust_trx_line_id
4183: );
4184:
4185: IF (l_ret_stat <> 'S') THEN
4186: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER Auto Invoice Not Run'||Bcl_rec.cle_id);
4187: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4188: RAISE MAIN_CUR_EXCEPTION;
4189: End if;
4190:

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

4188: RAISE MAIN_CUR_EXCEPTION;
4189: End if;
4190:
4191: If G_LOG_YES_NO = 'YES' then
4192: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After calling Set_ref_line_id ');
4193: End If;
4194:
4195: IF ((p_prv =1) OR ( p_prv = 3)) THEN
4196: l_btlv_tbl_in(1).BSL_ID := bsl_rec.id;

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

4207: p_btlv_tbl => l_btlv_tbl_in,
4208: x_btlv_tbl => l_btlv_tbl_out
4209: );
4210: If G_LOG_YES_NO = 'YES' then
4211: 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);
4212: End If;
4213:
4214: ELSIF (p_prv =2 ) THEN
4215: l_btl_pr_tbl_in(1).ID := oks_bill_rec_pub.get_seq_id;

Line 4260: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into Bill_Tran_lines Failed For'||bsl_rec.cle_id);

4256:
4257: END IF;
4258:
4259: IF (l_ret_stat <> 'S') THEN
4260: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into Bill_Tran_lines Failed For'||bsl_rec.cle_id);
4261: oks_bill_rec_pub.get_message
4262: (l_msg_cnt => l_msg_cnt,
4263: l_msg_data => l_msg_data);
4264:

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

4318: );
4319:
4320:
4321: If G_LOG_YES_NO = 'YES' then
4322: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => After calling Set_line_attribute ');
4323: End If;
4324:
4325: G_RAIL_REC.INTERFACE_LINE_ATTRIBUTE4 :=
4326: to_char(Bsl_rec.DATE_BILLED_FROM,'YYYY/MM/DD');

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

4337: END IF;
4338: -- Addition Ends
4339:
4340: If G_LOG_YES_NO = 'YES' then
4341: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Before insert into ra_interface_lines');
4342: End If;
4343:
4344: G_RAIL_REC.invoiced_line_acctg_level := 'D';
4345: G_RAIL_REC.source_data_key1 := bsl_rec.top_line_id;

Line 4400: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into RA_Interface_Lines Failed For'||bsl_rec.cle_id);

4396:
4397:
4398: IF (l_ret_stat <> 'S') THEN
4399:
4400: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into RA_Interface_Lines Failed For'||bsl_rec.cle_id);
4401: oks_bill_rec_pub.get_message
4402: (l_msg_cnt => l_msg_cnt,
4403: l_msg_data => l_msg_data);
4404:

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

4411: INSERT_RA_REV_DIST( l_ret_stat,
4412: bcl_rec.cle_id);
4413:
4414: IF (l_ret_stat <> 'S') THEN
4415: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIO NS'||lines_rec.id);
4416:
4417: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4418: RAISE MAIN_CUR_EXCEPTION;
4419: END IF;

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

4418: RAISE MAIN_CUR_EXCEPTION;
4419: END IF;
4420:
4421: If G_LOG_YES_NO = 'YES' then
4422: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of Revenue processing And Beginning of Sales Credit');
4423: End If;
4424: --mchoudha Fix for bug#4174921
4425: --added parameter p_hdr_id
4426: SALES_CREDIT(Bcl_rec.cle_id ,

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

4427: Bcl_rec.dnz_chr_id,
4428: l_ret_stat);
4429:
4430: IF ( l_ret_stat <> 'S') THEN
4431: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED'||lines_rec.id);
4432: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4433: RAISE MAIN_CUR_EXCEPTION;
4434: END IF;
4435: If G_LOG_YES_NO = 'YES' then

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

4432: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4433: RAISE MAIN_CUR_EXCEPTION;
4434: END IF;
4435: If G_LOG_YES_NO = 'YES' then
4436: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of sales credit processing ');
4437: End If;
4438: END IF; -----IF (p_prv = 1)
4439:
4440: IF p_prv = 3 AND bcl_rec.bill_action = 'TR' AND l_inv_count= 0 THEN ----billing rec not Invoiced

Line 4482: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into RA_Interface_Lines Failed For'||bsl_rec.cle_id);

4478:
4479:
4480: IF (l_ret_stat <> 'S') THEN
4481:
4482: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into RA_Interface_Lines Failed For'||bsl_rec.cle_id);
4483: oks_bill_rec_pub.get_message
4484: (l_msg_cnt => l_msg_cnt,
4485: l_msg_data => l_msg_data);
4486:

Line 4503: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into RA_Interface_Lines Failed For'||bsl_rec.cle_id);

4499: l_msg_data
4500: );
4501:
4502: IF (l_ret_stat <> 'S') THEN
4503: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert into RA_Interface_Lines Failed For'||bsl_rec.cle_id);
4504: oks_bill_rec_pub.get_message
4505: (l_msg_cnt => l_msg_cnt,
4506: l_msg_data => l_msg_data);
4507:

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

4525:
4526: INSERT_RA_REV_DIST( l_ret_stat,bcl_rec.cle_id);
4527:
4528: IF (l_ret_stat <> 'S') THEN
4529: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIONS'||lines_rec.id);
4530:
4531: ---DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4532: RAISE MAIN_CUR_EXCEPTION;
4533: END IF;

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

4532: RAISE MAIN_CUR_EXCEPTION;
4533: END IF;
4534:
4535: If G_LOG_YES_NO = 'YES' then
4536: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of Revenue processing And Beginning of Sales Credit');
4537: End If;
4538: --mchoudha Fix for bug#4174921
4539: --added parameter p_hdr_id
4540: SALES_CREDIT(Bcl_rec.cle_id ,

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

4541: Bcl_rec.dnz_chr_id,
4542: l_ret_stat);
4543:
4544: IF ( l_ret_stat <> 'S') THEN
4545: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_SALES_CREDIT FAILED'||lines_rec.id);
4546: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4547: RAISE MAIN_CUR_EXCEPTION;
4548: END IF;
4549: If G_LOG_YES_NO = 'YES' then

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

4546: ----DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4547: RAISE MAIN_CUR_EXCEPTION;
4548: END IF;
4549: If G_LOG_YES_NO = 'YES' then
4550: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => End of sales credit processing ');
4551: End If;
4552: END IF; --IF ( ((p_prv = 1) AND ( NVL(l_interface_pb,'N') = 'Y'))OR ((p_prv = 3 ) AND (l_inv_count > 1)) )
4553:
4554: END IF; --((p_prv =1) OR (p_prv = 3))

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

4620: END IF; -- l_bill_profile = G_SUM
4621: END IF; -- bcl_rec.lse_id = 46
4622: END IF; -- P_PRV <> 3
4623:
4624: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER MAIN_CUR_EXCEPTION RAISED '||sqlerrm);
4625: l_reject_counter := l_reject_counter + 1;
4626: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4627: x_return_status := OKC_API.G_RET_STS_ERROR;
4628: WHEN OTHERS THEN

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

4684: END IF; -- bcl_rec.lse_id = 46
4685: END IF; -- P_PRV <> 3
4686:
4687: x_return_status := OKC_API.G_RET_STS_ERROR;
4688: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER OTHERS EXCEPTION RAISED'||sqlerrm);
4689: l_reject_counter := l_reject_counter + 1;
4690: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4691:
4692: END;

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

4739: select count(id) into l_subline_count from oks_bill_sub_lines where bcl_id = Bcl_rec.id;
4740: elsif p_prv = 2 then
4741: select count(id) into l_subline_count from oks_bsl_pr where bcl_id = Bcl_rec.id;
4742: end if;
4743: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.debug report'||l_subline_count);
4744:
4745: p_billrep_tbl(p_billrep_tbl_idx).Successful_SubLines:= p_billrep_tbl(p_billrep_tbl_idx).Successful_SubLines +l_subline_count;
4746: END IF;
4747: END IF;

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

4750:
4751: EXCEPTION
4752: WHEN G_EXCEPTION_BILLING THEN
4753: --x_return_status := OKC_API.G_RET_STS_ERROR;
4754: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER G_BILLING_EXCEPTION RAISED '||sqlerrm);
4755: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4756: WHEN OTHERS THEN
4757: --x_return_status := OKC_API.G_RET_STS_ERROR;
4758: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER WHEN OTHERS EXCEPTION RAISED'||sqlerrm);

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

4754: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER G_BILLING_EXCEPTION RAISED '||sqlerrm);
4755: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4756: WHEN OTHERS THEN
4757: --x_return_status := OKC_API.G_RET_STS_ERROR;
4758: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert Failed IN ARFEEDER WHEN OTHERS EXCEPTION RAISED'||sqlerrm);
4759: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_AR_TRANSACTION');
4760:
4761: End Get_REC_FEEDER;
4762:

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

4932: x_msg_data
4933: );
4934:
4935: IF (x_return_status <> 'S') THEN
4936: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert into RA_Interface_Lines Failed while inserting price breaks ' );
4937: x_return_status := 'E';
4938: END IF; --IF (l_ret_stat <> 'S')
4939:
4940:

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

4941: INSERT_RA_REV_DIST( x_return_status,
4942: p_bcl_cle_id);
4943:
4944: IF (x_return_status <> 'S') THEN
4945: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert INTO RA_REVENUE_DISTRIBUTIONS failed for Price Break');
4946:
4947: x_return_status := 'E';
4948: END IF;
4949:

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

4953: p_hdr_id,
4954: x_return_status);
4955:
4956: IF ( x_return_status <> 'S') THEN
4957: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert INTO RA_SALES_CREDIT FAILED for Price Breaks');
4958: END IF;
4959:
4960:
4961: EXIT when x_return_status <> 'S';

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

4976: x_msg_data
4977: );
4978:
4979: IF (x_return_status <> 'S') THEN
4980: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert into RA_Interface_Lines Failed while inserting price breaks ' );
4981: x_return_status := 'E';
4982: END IF; --IF (l_ret_stat <> 'S')
4983:
4984:

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

4985: INSERT_RA_REV_DIST( x_return_status,
4986: p_bcl_cle_id);
4987:
4988: IF (x_return_status <> 'S') THEN
4989: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert INTO RA_REVENUE_DISTRIBUTIONS failed for Price Break');
4990:
4991: x_return_status := 'E';
4992: END IF;
4993:

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

4997: p_hdr_id,
4998: x_return_status);
4999:
5000: IF ( x_return_status <> 'S') THEN
5001: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert INTO RA_SALES_CREDIT FAILED for Price Breaks');
5002: END IF;
5003:
5004: END IF;
5005: