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.JAI_RETRO_PRC_PKG dependencies on FND_FILE

Line 323: -- FND_FILE.PUT_LINE(fnd_file.log,' Tax id is : '|| tax_info_rec.tax_id||'Accumulated Tax is: '||ln_tot_nr_tax_amt);

319: ln_tot_org_nr_tax_amt := ln_tot_org_nr_tax_amt +
320: Get_NonRecoverable_Amount( pn_tax_id => tax_info_rec.tax_id
321: , pn_tax_amount => tax_info_rec.original_tax_amount
322: );
323: -- FND_FILE.PUT_LINE(fnd_file.log,' Tax id is : '|| tax_info_rec.tax_id||'Accumulated Tax is: '||ln_tot_nr_tax_amt);
324: END LOOP;--tax_info_rec IN get_tax_info_cur
325:
326: ln_tot_diff_nr_tax_amt := ln_tot_modif_nr_tax_amt - ln_tot_org_nr_tax_amt;
327:

Line 963: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 1');

959: CLOSE get_mtl_parameters_cur;
960:
961: IF (ln_proc_level >= ln_dbg_level)
962: THEN
963: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 1');
964: FND_FILE.PUT_LINE(fnd_file.log,'lv_primary_cost_method '|| lv_primary_cost_method);
965: FND_FILE.PUT_LINE(fnd_file.log,'ln_expense_account '|| ln_expense_account);
966: FND_FILE.PUT_LINE(fnd_file.log,'ln_purchase_price_var_account '|| ln_purchase_price_var_account);
967: FND_FILE.PUT_LINE(fnd_file.log,'lv_organization_code '|| lv_organization_code);

Line 964: FND_FILE.PUT_LINE(fnd_file.log,'lv_primary_cost_method '|| lv_primary_cost_method);

960:
961: IF (ln_proc_level >= ln_dbg_level)
962: THEN
963: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 1');
964: FND_FILE.PUT_LINE(fnd_file.log,'lv_primary_cost_method '|| lv_primary_cost_method);
965: FND_FILE.PUT_LINE(fnd_file.log,'ln_expense_account '|| ln_expense_account);
966: FND_FILE.PUT_LINE(fnd_file.log,'ln_purchase_price_var_account '|| ln_purchase_price_var_account);
967: FND_FILE.PUT_LINE(fnd_file.log,'lv_organization_code '|| lv_organization_code);
968: END IF; --l_proc_level>=l_dbg_level

Line 965: FND_FILE.PUT_LINE(fnd_file.log,'ln_expense_account '|| ln_expense_account);

961: IF (ln_proc_level >= ln_dbg_level)
962: THEN
963: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 1');
964: FND_FILE.PUT_LINE(fnd_file.log,'lv_primary_cost_method '|| lv_primary_cost_method);
965: FND_FILE.PUT_LINE(fnd_file.log,'ln_expense_account '|| ln_expense_account);
966: FND_FILE.PUT_LINE(fnd_file.log,'ln_purchase_price_var_account '|| ln_purchase_price_var_account);
967: FND_FILE.PUT_LINE(fnd_file.log,'lv_organization_code '|| lv_organization_code);
968: END IF; --l_proc_level>=l_dbg_level
969:

Line 966: FND_FILE.PUT_LINE(fnd_file.log,'ln_purchase_price_var_account '|| ln_purchase_price_var_account);

962: THEN
963: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 1');
964: FND_FILE.PUT_LINE(fnd_file.log,'lv_primary_cost_method '|| lv_primary_cost_method);
965: FND_FILE.PUT_LINE(fnd_file.log,'ln_expense_account '|| ln_expense_account);
966: FND_FILE.PUT_LINE(fnd_file.log,'ln_purchase_price_var_account '|| ln_purchase_price_var_account);
967: FND_FILE.PUT_LINE(fnd_file.log,'lv_organization_code '|| lv_organization_code);
968: END IF; --l_proc_level>=l_dbg_level
969:
970: OPEN get_rcv_parameters_cur;

Line 967: FND_FILE.PUT_LINE(fnd_file.log,'lv_organization_code '|| lv_organization_code);

963: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 1');
964: FND_FILE.PUT_LINE(fnd_file.log,'lv_primary_cost_method '|| lv_primary_cost_method);
965: FND_FILE.PUT_LINE(fnd_file.log,'ln_expense_account '|| ln_expense_account);
966: FND_FILE.PUT_LINE(fnd_file.log,'ln_purchase_price_var_account '|| ln_purchase_price_var_account);
967: FND_FILE.PUT_LINE(fnd_file.log,'lv_organization_code '|| lv_organization_code);
968: END IF; --l_proc_level>=l_dbg_level
969:
970: OPEN get_rcv_parameters_cur;
971: FETCH get_rcv_parameters_cur

Line 979: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 2');

975: CLOSE get_rcv_parameters_cur;
976:
977: IF (ln_proc_level >= ln_dbg_level)
978: THEN
979: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 2');
980: FND_FILE.PUT_LINE(fnd_file.log,'ln_retroprice_adj_account_id '|| ln_retroprice_adj_account_id);
981: FND_FILE.PUT_LINE(fnd_file.log,'ln_receiving_account_id '|| ln_receiving_account_id);
982: END IF; --l_proc_level>=l_dbg_level
983:

Line 980: FND_FILE.PUT_LINE(fnd_file.log,'ln_retroprice_adj_account_id '|| ln_retroprice_adj_account_id);

976:
977: IF (ln_proc_level >= ln_dbg_level)
978: THEN
979: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 2');
980: FND_FILE.PUT_LINE(fnd_file.log,'ln_retroprice_adj_account_id '|| ln_retroprice_adj_account_id);
981: FND_FILE.PUT_LINE(fnd_file.log,'ln_receiving_account_id '|| ln_receiving_account_id);
982: END IF; --l_proc_level>=l_dbg_level
983:
984: OPEN rcv_transactions_cur;

Line 981: FND_FILE.PUT_LINE(fnd_file.log,'ln_receiving_account_id '|| ln_receiving_account_id);

977: IF (ln_proc_level >= ln_dbg_level)
978: THEN
979: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 2');
980: FND_FILE.PUT_LINE(fnd_file.log,'ln_retroprice_adj_account_id '|| ln_retroprice_adj_account_id);
981: FND_FILE.PUT_LINE(fnd_file.log,'ln_receiving_account_id '|| ln_receiving_account_id);
982: END IF; --l_proc_level>=l_dbg_level
983:
984: OPEN rcv_transactions_cur;
985: FETCH rcv_transactions_cur

Line 993: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 3');

989: CLOSE rcv_transactions_cur;
990:
991: IF (ln_proc_level >= ln_dbg_level)
992: THEN
993: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 3');
994: FND_FILE.PUT_LINE(fnd_file.log,'lv_destination_type_code '|| lv_destination_type_code);
995: FND_FILE.PUT_LINE(fnd_file.log,'ln_shipment_line_id '|| ln_shipment_line_id);
996: END IF; --l_proc_level>=l_dbg_level
997:

Line 994: FND_FILE.PUT_LINE(fnd_file.log,'lv_destination_type_code '|| lv_destination_type_code);

990:
991: IF (ln_proc_level >= ln_dbg_level)
992: THEN
993: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 3');
994: FND_FILE.PUT_LINE(fnd_file.log,'lv_destination_type_code '|| lv_destination_type_code);
995: FND_FILE.PUT_LINE(fnd_file.log,'ln_shipment_line_id '|| ln_shipment_line_id);
996: END IF; --l_proc_level>=l_dbg_level
997:
998: IF (lv_destination_type_code = 'EXPENSE')

Line 995: FND_FILE.PUT_LINE(fnd_file.log,'ln_shipment_line_id '|| ln_shipment_line_id);

991: IF (ln_proc_level >= ln_dbg_level)
992: THEN
993: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 3');
994: FND_FILE.PUT_LINE(fnd_file.log,'lv_destination_type_code '|| lv_destination_type_code);
995: FND_FILE.PUT_LINE(fnd_file.log,'ln_shipment_line_id '|| ln_shipment_line_id);
996: END IF; --l_proc_level>=l_dbg_level
997:
998: IF (lv_destination_type_code = 'EXPENSE')
999: THEN -- if the destination_type_code in DELIVER transaction is EXPENSE

Line 1034: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 4');

1030: END IF; -- (lv_process_status IN ('X','E'))
1031: --logging for debug
1032: IF (ln_proc_level >= ln_dbg_level)
1033: THEN
1034: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 4');
1035: END IF; --l_proc_level>=l_dbg_level
1036:
1037: -- Credit the receiving_account_id by calling the following procedure
1038:

Line 1071: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 5');

1067: END IF; -- (lv_process_status IN ('X','E'))
1068:
1069: IF (ln_proc_level >= ln_dbg_level)
1070: THEN
1071: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 5');
1072: END IF; --l_proc_level>=l_dbg_level
1073:
1074: ELSIF (lv_primary_cost_method = 1)
1075: THEN -- if its Standard Costing

Line 1079: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 6');

1075: THEN -- if its Standard Costing
1076:
1077: IF (ln_proc_level >= ln_dbg_level)
1078: THEN
1079: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 6');
1080: END IF; --l_proc_level>=l_dbg_level
1081:
1082: -- Debit the account by calling
1083: jai_rcv_accounting_pkg.process_transaction

Line 1115: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 7');

1111: END IF; -- (lv_process_status IN ('X','E'))
1112:
1113: IF (ln_proc_level >= ln_dbg_level)
1114: THEN
1115: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 7');
1116: END IF; --l_proc_level>=l_dbg_level
1117:
1118: -- Credit the receiving account by calling
1119: jai_rcv_accounting_pkg.process_transaction

Line 1151: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 8');

1147: END IF; -- (lv_process_status IN ('X','E'))
1148:
1149: IF (ln_proc_level >= ln_dbg_level)
1150: THEN
1151: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 8');
1152: END IF; --l_proc_level>=l_dbg_level
1153:
1154: ELSIF (lv_primary_cost_method = 2)
1155: THEN -- if its Average costing

Line 1159: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 9');

1155: THEN -- if its Average costing
1156:
1157: IF (ln_proc_level >= ln_dbg_level)
1158: THEN
1159: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 9');
1160: END IF; --l_proc_level>=l_dbg_level
1161:
1162: -- Get the organization details by calling the following function
1163: func_curr_det_rec := jai_plsql_cache_pkg.return_sob_curr(p_org_id => pn_organization_id);

Line 1168: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 10');

1164:
1165:
1166: IF (ln_proc_level >= ln_dbg_level)
1167: THEN
1168: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 10');
1169: END IF; --l_proc_level>=l_dbg_level
1170:
1171: -- Get the period name using the following query
1172: SELECT gd.period_name

Line 1190: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 11');

1186: AND gd.adjustment_period_flag = 'N';
1187:
1188: IF (ln_proc_level >= ln_dbg_level)
1189: THEN
1190: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 11');
1191: FND_FILE.PUT_LINE(fnd_file.log,'lv_period_name '|| lv_period_name);
1192: END IF; --l_proc_level>=l_dbg_level
1193:
1194: -- Get the receipt_num

Line 1191: FND_FILE.PUT_LINE(fnd_file.log,'lv_period_name '|| lv_period_name);

1187:
1188: IF (ln_proc_level >= ln_dbg_level)
1189: THEN
1190: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 11');
1191: FND_FILE.PUT_LINE(fnd_file.log,'lv_period_name '|| lv_period_name);
1192: END IF; --l_proc_level>=l_dbg_level
1193:
1194: -- Get the receipt_num
1195: SELECT receipt_num

Line 1202: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 12');

1198: WHERE shipment_line_id = ln_shipment_line_id;
1199:
1200: IF (ln_proc_level >= ln_dbg_level)
1201: THEN
1202: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 12');
1203: FND_FILE.PUT_LINE(fnd_file.log,'lv_receipt_num '|| lv_receipt_num);
1204: END IF; --l_proc_level>=l_dbg_level
1205:
1206: -- Debit the Retroprice account by calling

Line 1203: FND_FILE.PUT_LINE(fnd_file.log,'lv_receipt_num '|| lv_receipt_num);

1199:
1200: IF (ln_proc_level >= ln_dbg_level)
1201: THEN
1202: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 12');
1203: FND_FILE.PUT_LINE(fnd_file.log,'lv_receipt_num '|| lv_receipt_num);
1204: END IF; --l_proc_level>=l_dbg_level
1205:
1206: -- Debit the Retroprice account by calling
1207: jai_rcv_accounting_pkg.gl_entry

Line 1232: --FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 9');

1228: , p_process_status => lv_process_status
1229: , p_codepath => lv_code_path
1230: );
1231:
1232: --FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 9');
1233:
1234: IF (lv_process_status IN ('X','E'))
1235: THEN
1236: raise_application_error(-20120,'Unclaim GL Entry returned with error for Average Costing : '|| lv_process_message);

Line 1241: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 13');

1237: END IF; -- (lv_process_status IN ('X','E'))
1238:
1239: IF (ln_proc_level >= ln_dbg_level)
1240: THEN
1241: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 13');
1242: END IF; --l_proc_level>=l_dbg_level
1243:
1244: jai_rcv_journal_pkg.insert_row
1245: ( p_organization_id => pn_organization_id

Line 1278: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 14');

1274: END IF; -- (lv_process_status IN ('X','E'))
1275:
1276: IF (ln_proc_level >= ln_dbg_level)
1277: THEN
1278: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 14');
1279: END IF; --l_proc_level>=l_dbg_level
1280:
1281: -- Credit the receiving account by calling
1282:

Line 1315: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 15');

1311: END IF; -- (lv_process_status IN ('X','E'))
1312:
1313: IF (ln_proc_level >= ln_dbg_level)
1314: THEN
1315: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 15');
1316: END IF; --l_proc_level>=l_dbg_level
1317:
1318: jai_rcv_journal_pkg.insert_row
1319: ( p_organization_id => pn_organization_id

Line 1345: --FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 12');

1341: , p_reference_name => 'RETRO CENVAT CLAIMS ' || pn_version_number
1342: , p_reference_id => 2
1343: );
1344:
1345: --FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 12');
1346: IF (lv_process_status IN ('X','E'))
1347: THEN
1348: raise_application_error(-20120,'Unclaim Journal Entry returned with error for Average Costing : ' || lv_process_message);
1349: END IF; -- (lv_process_status IN ('X','E'))

Line 1353: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 16');

1349: END IF; -- (lv_process_status IN ('X','E'))
1350:
1351: IF (ln_proc_level >= ln_dbg_level)
1352: THEN
1353: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 16');
1354: END IF; --l_proc_level>=l_dbg_level
1355: END IF; -- (lv_destination_type_code = 'EXPENSE')
1356:
1357: --logging for debug

Line 1470: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 1');

1466: AND transaction_type = 'RECEIVE';
1467:
1468: IF (ln_proc_level >= ln_dbg_level)
1469: THEN
1470: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 1');
1471: FND_FILE.PUT_LINE(fnd_file.log,'ln_curr_conv_rate '|| ln_curr_conv_rate);
1472: FND_FILE.PUT_LINE(fnd_file.log,'ln_organization_id '|| ln_organization_id);
1473: END IF; --l_proc_level>=l_dbg_level
1474:

Line 1471: FND_FILE.PUT_LINE(fnd_file.log,'ln_curr_conv_rate '|| ln_curr_conv_rate);

1467:
1468: IF (ln_proc_level >= ln_dbg_level)
1469: THEN
1470: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 1');
1471: FND_FILE.PUT_LINE(fnd_file.log,'ln_curr_conv_rate '|| ln_curr_conv_rate);
1472: FND_FILE.PUT_LINE(fnd_file.log,'ln_organization_id '|| ln_organization_id);
1473: END IF; --l_proc_level>=l_dbg_level
1474:
1475: --Get the total tax difference from jai_retro_tax_changes for the shipment_line_id

Line 1472: FND_FILE.PUT_LINE(fnd_file.log,'ln_organization_id '|| ln_organization_id);

1468: IF (ln_proc_level >= ln_dbg_level)
1469: THEN
1470: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 1');
1471: FND_FILE.PUT_LINE(fnd_file.log,'ln_curr_conv_rate '|| ln_curr_conv_rate);
1472: FND_FILE.PUT_LINE(fnd_file.log,'ln_organization_id '|| ln_organization_id);
1473: END IF; --l_proc_level>=l_dbg_level
1474:
1475: --Get the total tax difference from jai_retro_tax_changes for the shipment_line_id
1476: -- Get the difference in INR. Multiply with currency_conversion_rate of rcv_transactions

Line 1488: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 2');

1484: WHERE line_change_id = pn_line_change_id ;/*rchandan. removed sub query and replaced with pn_line_change_id*/
1485:
1486: IF (ln_proc_level >= ln_dbg_level)
1487: THEN
1488: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 2');
1489: FND_FILE.PUT_LINE(fnd_file.log,'ln_tax_diff_tot '|| ln_tax_diff_tot);
1490: END IF; --l_proc_level>=l_dbg_level
1491:
1492:

Line 1489: FND_FILE.PUT_LINE(fnd_file.log,'ln_tax_diff_tot '|| ln_tax_diff_tot);

1485:
1486: IF (ln_proc_level >= ln_dbg_level)
1487: THEN
1488: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 2');
1489: FND_FILE.PUT_LINE(fnd_file.log,'ln_tax_diff_tot '|| ln_tax_diff_tot);
1490: END IF; --l_proc_level>=l_dbg_level
1491:
1492:
1493: /* eric deleted for a bug on Jan 22,2008

Line 1500: --FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 2');

1496: ln_tax_diff_tot := ln_tax_diff_tot * ln_curr_conv_rate;
1497: END IF;
1498: */
1499:
1500: --FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 2');
1501:
1502: --IF the total difference is NOT EQUAL to ZERO THEN
1503: IF ln_tax_diff_tot <> 0
1504: THEN

Line 1516: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 3');

1512: WHERE organization_id = ln_organization_id;
1513:
1514: IF (ln_proc_level >= ln_dbg_level)
1515: THEN
1516: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 3');
1517: FND_FILE.PUT_LINE(fnd_file.log,'ln_recv_acct_id '|| ln_recv_acct_id);
1518: END IF; --l_proc_level>=l_dbg_level
1519:
1520: --Debit the account by calling the following procedure

Line 1517: FND_FILE.PUT_LINE(fnd_file.log,'ln_recv_acct_id '|| ln_recv_acct_id);

1513:
1514: IF (ln_proc_level >= ln_dbg_level)
1515: THEN
1516: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 3');
1517: FND_FILE.PUT_LINE(fnd_file.log,'ln_recv_acct_id '|| ln_recv_acct_id);
1518: END IF; --l_proc_level>=l_dbg_level
1519:
1520: --Debit the account by calling the following procedure
1521: Jai_Rcv_Accounting_Pkg.Process_Transaction

Line 1545: --FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 3');

1541: , p_process_status => lv_process_status -- OUT parameter
1542: , p_reference_name => 'RETRO CENVAT CLAIMS ' ||pn_version_number
1543: , p_reference_id => 1
1544: );
1545: --FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 3');
1546:
1547: IF lv_process_status IN ('X', 'E')
1548: THEN
1549: raise_application_error(-20120,'Receive Accounting Entry retruned with error : '||lv_process_message);

Line 1554: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 4');

1550: END IF;
1551:
1552: IF (ln_proc_level >= ln_dbg_level)
1553: THEN
1554: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 4');
1555: END IF; --l_proc_level>=l_dbg_level
1556:
1557: --Get the ap_accrual_account from mtl_parameters for the current organization id
1558: SELECT

Line 1568: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 5');

1564: WHERE organization_id = ln_organization_id;
1565:
1566: IF (ln_proc_level >= ln_dbg_level)
1567: THEN
1568: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 5');
1569: FND_FILE.PUT_LINE(fnd_file.log,'ln_ap_accrual_acc '|| ln_ap_accrual_acc);
1570: END IF; --l_proc_level>=l_dbg_level
1571:
1572: --Credit the account by calling the following procedure

Line 1569: FND_FILE.PUT_LINE(fnd_file.log,'ln_ap_accrual_acc '|| ln_ap_accrual_acc);

1565:
1566: IF (ln_proc_level >= ln_dbg_level)
1567: THEN
1568: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 5');
1569: FND_FILE.PUT_LINE(fnd_file.log,'ln_ap_accrual_acc '|| ln_ap_accrual_acc);
1570: END IF; --l_proc_level>=l_dbg_level
1571:
1572: --Credit the account by calling the following procedure
1573: Jai_Rcv_Accounting_Pkg.Process_Transaction

Line 1598: -- FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 4');

1594: , p_reference_name => 'RETRO CENVAT CLAIMS ' ||pn_version_number
1595: , p_reference_id => 2
1596: );
1597:
1598: -- FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 4');
1599: IF lv_process_status IN ('X', 'E')
1600: THEN
1601: raise_application_error(-20120,'Receive Accounting Entry retruned with error : '||lv_process_message);
1602: END IF;

Line 1606: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 6');

1602: END IF;
1603:
1604: IF (ln_proc_level >= ln_dbg_level)
1605: THEN
1606: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 6');
1607: END IF; --l_proc_level>=l_dbg_level
1608:
1609: ln_non_rec_amount := pn_non_rec_amount;
1610:

Line 1624: FND_FILE.PUT_LINE(fnd_file.log,' lv_include_cenvat_in_costing : '|| lv_include_cenvat_in_costing);

1620: , p_codepath => lv_codepath
1621: );
1622:
1623: IF lv_include_cenvat_in_costing = 'Y' OR xv_cenvat_action = 'UNCLAIM' THEN
1624: FND_FILE.PUT_LINE(fnd_file.log,' lv_include_cenvat_in_costing : '|| lv_include_cenvat_in_costing);
1625: xv_cenvat_action := 'UNCLAIMED'; -- CENVAT is included in Unclaim. do_cenvat_claim is no more called
1626: ln_non_rec_amount := ln_non_rec_amount + pn_cenvat_amount; -- include recoverable cenvat in Non recoverable amount
1627: END IF;
1628:

Line 1633: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 7');

1629: END IF;
1630:
1631: IF (ln_proc_level >= ln_dbg_level)
1632: THEN
1633: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 7');
1634: END IF; --l_proc_level>=l_dbg_level
1635:
1636: IF xv_vat_action = 'UNCLAIM' AND pn_vat_amount <> 0 THEN --If VAT amount exists and VAT action is UNCLAIM
1637: xv_vat_action := 'UNCLAIMED'; -- VAT is included in Unclaim. do_vat_claim is no more called

Line 1643: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 8');

1639: END IF;
1640:
1641: IF (ln_proc_level >= ln_dbg_level)
1642: THEN
1643: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 8');
1644: END IF; --l_proc_level>=l_dbg_level
1645:
1646: IF (ln_non_rec_amount <> 0)
1647: THEN

Line 1655: FND_FILE.PUT_LINE(fnd_file.log,' Do_Unclaim() Invoked');

1651: , pn_amount => ln_non_rec_amount -- Amount to be unclaimed
1652: , pn_version_number => pn_version_number
1653: );
1654:
1655: FND_FILE.PUT_LINE(fnd_file.log,' Do_Unclaim() Invoked');
1656: ELSE
1657: FND_FILE.PUT_LINE(fnd_file.log,' Do_Unclaim() is not Invoked');
1658: END IF;--(ln_non_rec_amount <> 0)
1659:

Line 1657: FND_FILE.PUT_LINE(fnd_file.log,' Do_Unclaim() is not Invoked');

1653: );
1654:
1655: FND_FILE.PUT_LINE(fnd_file.log,' Do_Unclaim() Invoked');
1656: ELSE
1657: FND_FILE.PUT_LINE(fnd_file.log,' Do_Unclaim() is not Invoked');
1658: END IF;--(ln_non_rec_amount <> 0)
1659:
1660: IF (ln_proc_level >= ln_dbg_level)
1661: THEN

Line 1662: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 9');

1658: END IF;--(ln_non_rec_amount <> 0)
1659:
1660: IF (ln_proc_level >= ln_dbg_level)
1661: THEN
1662: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 9');
1663: END IF; --l_proc_level>=l_dbg_level
1664:
1665: IF xv_cenvat_action = 'UNCLAIMED'
1666: THEN

Line 1677: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 10');

1673: END IF;
1674:
1675: IF (ln_proc_level >= ln_dbg_level)
1676: THEN
1677: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 10');
1678: END IF; --l_proc_level>=l_dbg_level
1679:
1680: IF xv_vat_action = 'UNCLAIMED'
1681: THEN

Line 1692: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 11');

1688: END IF;
1689:
1690: IF (ln_proc_level >= ln_dbg_level)
1691: THEN
1692: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 11');
1693: END IF; --l_proc_level>=l_dbg_level
1694: END LOOP; --FOR trx_rec IN rcv_trx_cur --DELIVER transactions
1695: END IF;
1696: --logging for debug

Line 2310: FND_FILE.PUT_LINE(fnd_file.log, 'Total receipt fail to pass cenvat prossing validation,for the reason: '||lv_process_message);

2306: END IF;
2307:
2308: IF lv_process_status = 'X' THEN
2309: --Print that Claim is not valid for this and print lv_process_message
2310: FND_FILE.PUT_LINE(fnd_file.log, 'Total receipt fail to pass cenvat prossing validation,for the reason: '||lv_process_message);
2311:
2312:
2313: UPDATE
2314: jai_retro_line_changes

Line 2714: FND_FILE.PUT_LINE(fnd_file.log, 'Concurrent Input Parameter Is :');

2710: );
2711: END IF; --l_proc_level>=l_dbg_level
2712:
2713: BEGIN
2714: FND_FILE.PUT_LINE(fnd_file.log, 'Concurrent Input Parameter Is :');
2715: FND_FILE.PUT_LINE(fnd_file.log, '-------------------------------------------------------------- ');
2716: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR ID :'|| pn_vendor_id );
2717: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR SITE ID :'|| pn_vendor_site_id );
2718: FND_FILE.PUT_LINE(fnd_file.log, 'AGGREMENT ID :'|| pn_po_header_id );

Line 2715: FND_FILE.PUT_LINE(fnd_file.log, '-------------------------------------------------------------- ');

2711: END IF; --l_proc_level>=l_dbg_level
2712:
2713: BEGIN
2714: FND_FILE.PUT_LINE(fnd_file.log, 'Concurrent Input Parameter Is :');
2715: FND_FILE.PUT_LINE(fnd_file.log, '-------------------------------------------------------------- ');
2716: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR ID :'|| pn_vendor_id );
2717: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR SITE ID :'|| pn_vendor_site_id );
2718: FND_FILE.PUT_LINE(fnd_file.log, 'AGGREMENT ID :'|| pn_po_header_id );
2719: FND_FILE.PUT_LINE(fnd_file.log, 'EFFECTIVE DATE :'|| pv_from_eff_date );

Line 2716: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR ID :'|| pn_vendor_id );

2712:
2713: BEGIN
2714: FND_FILE.PUT_LINE(fnd_file.log, 'Concurrent Input Parameter Is :');
2715: FND_FILE.PUT_LINE(fnd_file.log, '-------------------------------------------------------------- ');
2716: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR ID :'|| pn_vendor_id );
2717: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR SITE ID :'|| pn_vendor_site_id );
2718: FND_FILE.PUT_LINE(fnd_file.log, 'AGGREMENT ID :'|| pn_po_header_id );
2719: FND_FILE.PUT_LINE(fnd_file.log, 'EFFECTIVE DATE :'|| pv_from_eff_date );
2720: FND_FILE.PUT_LINE(fnd_file.log, 'Execise Action :'|| pv_cenvat_action );

Line 2717: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR SITE ID :'|| pn_vendor_site_id );

2713: BEGIN
2714: FND_FILE.PUT_LINE(fnd_file.log, 'Concurrent Input Parameter Is :');
2715: FND_FILE.PUT_LINE(fnd_file.log, '-------------------------------------------------------------- ');
2716: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR ID :'|| pn_vendor_id );
2717: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR SITE ID :'|| pn_vendor_site_id );
2718: FND_FILE.PUT_LINE(fnd_file.log, 'AGGREMENT ID :'|| pn_po_header_id );
2719: FND_FILE.PUT_LINE(fnd_file.log, 'EFFECTIVE DATE :'|| pv_from_eff_date );
2720: FND_FILE.PUT_LINE(fnd_file.log, 'Execise Action :'|| pv_cenvat_action );
2721: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice No. :'|| pv_supp_exc_inv_no );

Line 2718: FND_FILE.PUT_LINE(fnd_file.log, 'AGGREMENT ID :'|| pn_po_header_id );

2714: FND_FILE.PUT_LINE(fnd_file.log, 'Concurrent Input Parameter Is :');
2715: FND_FILE.PUT_LINE(fnd_file.log, '-------------------------------------------------------------- ');
2716: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR ID :'|| pn_vendor_id );
2717: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR SITE ID :'|| pn_vendor_site_id );
2718: FND_FILE.PUT_LINE(fnd_file.log, 'AGGREMENT ID :'|| pn_po_header_id );
2719: FND_FILE.PUT_LINE(fnd_file.log, 'EFFECTIVE DATE :'|| pv_from_eff_date );
2720: FND_FILE.PUT_LINE(fnd_file.log, 'Execise Action :'|| pv_cenvat_action );
2721: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice No. :'|| pv_supp_exc_inv_no );
2722: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice Date :'|| pv_supp_exc_inv_date );

Line 2719: FND_FILE.PUT_LINE(fnd_file.log, 'EFFECTIVE DATE :'|| pv_from_eff_date );

2715: FND_FILE.PUT_LINE(fnd_file.log, '-------------------------------------------------------------- ');
2716: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR ID :'|| pn_vendor_id );
2717: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR SITE ID :'|| pn_vendor_site_id );
2718: FND_FILE.PUT_LINE(fnd_file.log, 'AGGREMENT ID :'|| pn_po_header_id );
2719: FND_FILE.PUT_LINE(fnd_file.log, 'EFFECTIVE DATE :'|| pv_from_eff_date );
2720: FND_FILE.PUT_LINE(fnd_file.log, 'Execise Action :'|| pv_cenvat_action );
2721: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice No. :'|| pv_supp_exc_inv_no );
2722: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice Date :'|| pv_supp_exc_inv_date );
2723: FND_FILE.PUT_LINE(fnd_file.log, 'Vat Action :'|| pv_vat_action );

Line 2720: FND_FILE.PUT_LINE(fnd_file.log, 'Execise Action :'|| pv_cenvat_action );

2716: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR ID :'|| pn_vendor_id );
2717: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR SITE ID :'|| pn_vendor_site_id );
2718: FND_FILE.PUT_LINE(fnd_file.log, 'AGGREMENT ID :'|| pn_po_header_id );
2719: FND_FILE.PUT_LINE(fnd_file.log, 'EFFECTIVE DATE :'|| pv_from_eff_date );
2720: FND_FILE.PUT_LINE(fnd_file.log, 'Execise Action :'|| pv_cenvat_action );
2721: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice No. :'|| pv_supp_exc_inv_no );
2722: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice Date :'|| pv_supp_exc_inv_date );
2723: FND_FILE.PUT_LINE(fnd_file.log, 'Vat Action :'|| pv_vat_action );
2724: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice No. :'|| pv_supp_vat_inv_no );

Line 2721: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice No. :'|| pv_supp_exc_inv_no );

2717: FND_FILE.PUT_LINE(fnd_file.log, 'VENDOR SITE ID :'|| pn_vendor_site_id );
2718: FND_FILE.PUT_LINE(fnd_file.log, 'AGGREMENT ID :'|| pn_po_header_id );
2719: FND_FILE.PUT_LINE(fnd_file.log, 'EFFECTIVE DATE :'|| pv_from_eff_date );
2720: FND_FILE.PUT_LINE(fnd_file.log, 'Execise Action :'|| pv_cenvat_action );
2721: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice No. :'|| pv_supp_exc_inv_no );
2722: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice Date :'|| pv_supp_exc_inv_date );
2723: FND_FILE.PUT_LINE(fnd_file.log, 'Vat Action :'|| pv_vat_action );
2724: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice No. :'|| pv_supp_vat_inv_no );
2725: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice Date :'|| pv_supp_vat_inv_date );

Line 2722: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice Date :'|| pv_supp_exc_inv_date );

2718: FND_FILE.PUT_LINE(fnd_file.log, 'AGGREMENT ID :'|| pn_po_header_id );
2719: FND_FILE.PUT_LINE(fnd_file.log, 'EFFECTIVE DATE :'|| pv_from_eff_date );
2720: FND_FILE.PUT_LINE(fnd_file.log, 'Execise Action :'|| pv_cenvat_action );
2721: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice No. :'|| pv_supp_exc_inv_no );
2722: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice Date :'|| pv_supp_exc_inv_date );
2723: FND_FILE.PUT_LINE(fnd_file.log, 'Vat Action :'|| pv_vat_action );
2724: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice No. :'|| pv_supp_vat_inv_no );
2725: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice Date :'|| pv_supp_vat_inv_date );
2726: FND_FILE.PUT_LINE(fnd_file.log, 'Down Revision Process :'|| pv_process_downward );

Line 2723: FND_FILE.PUT_LINE(fnd_file.log, 'Vat Action :'|| pv_vat_action );

2719: FND_FILE.PUT_LINE(fnd_file.log, 'EFFECTIVE DATE :'|| pv_from_eff_date );
2720: FND_FILE.PUT_LINE(fnd_file.log, 'Execise Action :'|| pv_cenvat_action );
2721: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice No. :'|| pv_supp_exc_inv_no );
2722: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice Date :'|| pv_supp_exc_inv_date );
2723: FND_FILE.PUT_LINE(fnd_file.log, 'Vat Action :'|| pv_vat_action );
2724: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice No. :'|| pv_supp_vat_inv_no );
2725: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice Date :'|| pv_supp_vat_inv_date );
2726: FND_FILE.PUT_LINE(fnd_file.log, 'Down Revision Process :'|| pv_process_downward );
2727: FND_FILE.PUT_LINE(fnd_file.log, '--------------------------------------------------------- ');

Line 2724: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice No. :'|| pv_supp_vat_inv_no );

2720: FND_FILE.PUT_LINE(fnd_file.log, 'Execise Action :'|| pv_cenvat_action );
2721: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice No. :'|| pv_supp_exc_inv_no );
2722: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice Date :'|| pv_supp_exc_inv_date );
2723: FND_FILE.PUT_LINE(fnd_file.log, 'Vat Action :'|| pv_vat_action );
2724: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice No. :'|| pv_supp_vat_inv_no );
2725: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice Date :'|| pv_supp_vat_inv_date );
2726: FND_FILE.PUT_LINE(fnd_file.log, 'Down Revision Process :'|| pv_process_downward );
2727: FND_FILE.PUT_LINE(fnd_file.log, '--------------------------------------------------------- ');
2728: END;

Line 2725: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice Date :'|| pv_supp_vat_inv_date );

2721: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice No. :'|| pv_supp_exc_inv_no );
2722: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice Date :'|| pv_supp_exc_inv_date );
2723: FND_FILE.PUT_LINE(fnd_file.log, 'Vat Action :'|| pv_vat_action );
2724: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice No. :'|| pv_supp_vat_inv_no );
2725: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice Date :'|| pv_supp_vat_inv_date );
2726: FND_FILE.PUT_LINE(fnd_file.log, 'Down Revision Process :'|| pv_process_downward );
2727: FND_FILE.PUT_LINE(fnd_file.log, '--------------------------------------------------------- ');
2728: END;
2729:

Line 2726: FND_FILE.PUT_LINE(fnd_file.log, 'Down Revision Process :'|| pv_process_downward );

2722: FND_FILE.PUT_LINE(fnd_file.log, 'Supp Execise Invoice Date :'|| pv_supp_exc_inv_date );
2723: FND_FILE.PUT_LINE(fnd_file.log, 'Vat Action :'|| pv_vat_action );
2724: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice No. :'|| pv_supp_vat_inv_no );
2725: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice Date :'|| pv_supp_vat_inv_date );
2726: FND_FILE.PUT_LINE(fnd_file.log, 'Down Revision Process :'|| pv_process_downward );
2727: FND_FILE.PUT_LINE(fnd_file.log, '--------------------------------------------------------- ');
2728: END;
2729:
2730: retcode := 0;

Line 2727: FND_FILE.PUT_LINE(fnd_file.log, '--------------------------------------------------------- ');

2723: FND_FILE.PUT_LINE(fnd_file.log, 'Vat Action :'|| pv_vat_action );
2724: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice No. :'|| pv_supp_vat_inv_no );
2725: FND_FILE.PUT_LINE(fnd_file.log, 'Supp VAT Invoice Date :'|| pv_supp_vat_inv_date );
2726: FND_FILE.PUT_LINE(fnd_file.log, 'Down Revision Process :'|| pv_process_downward );
2727: FND_FILE.PUT_LINE(fnd_file.log, '--------------------------------------------------------- ');
2728: END;
2729:
2730: retcode := 0;
2731: errbuf := NULL;

Line 2735: FND_FILE.PUT_LINE(fnd_file.log, ' Both Supplementary Excise Invoice NO and Supplementary Excise Invoice date should not be null when Excise Action is CLAIM' );

2731: errbuf := NULL;
2732:
2733: IF (pv_cenvat_action ='CLAIM' AND (pv_supp_exc_inv_no IS NULL OR pv_supp_exc_inv_date IS NULL))
2734: THEN
2735: FND_FILE.PUT_LINE(fnd_file.log, ' Both Supplementary Excise Invoice NO and Supplementary Excise Invoice date should not be null when Excise Action is CLAIM' );
2736: retcode :=2;
2737: RETURN;
2738: END IF;
2739:

Line 2743: FND_FILE.PUT_LINE(fnd_file.log, ' Both Supplementary Vat Invoice NO and Supplementary Vat Invoice date should not be null when Excise Action is CLAIM' );

2739:
2740:
2741: IF (pv_vat_action ='CLAIM' AND (pv_supp_vat_inv_no IS NULL OR pv_supp_vat_inv_date IS NULL))
2742: THEN
2743: FND_FILE.PUT_LINE(fnd_file.log, ' Both Supplementary Vat Invoice NO and Supplementary Vat Invoice date should not be null when Excise Action is CLAIM' );
2744: retcode :=2;
2745: RETURN;
2746: END IF;
2747:

Line 2753: FND_FILE.PUT_LINE(fnd_file.log, 'PO: Allow Retroactive Pricing of POs = '||lv_profile_setting );

2749: lv_profile_setting := FND_PROFILE.VALUE('PO_ALLOW_RETROPRICING_OF_PO');
2750:
2751: IF (lv_profile_setting <>'ALL_RELEASES')
2752: THEN
2753: FND_FILE.PUT_LINE(fnd_file.log, 'PO: Allow Retroactive Pricing of POs = '||lv_profile_setting );
2754: FND_FILE.PUT_LINE(fnd_file.log, 'This Concurrent Program is not executed as the profile (PO: Allow Retroactive Pricing of POs) is not set to ''ALL RELEASES''');
2755: retcode :=0;
2756: RETURN;
2757: END IF;

Line 2754: FND_FILE.PUT_LINE(fnd_file.log, 'This Concurrent Program is not executed as the profile (PO: Allow Retroactive Pricing of POs) is not set to ''ALL RELEASES''');

2750:
2751: IF (lv_profile_setting <>'ALL_RELEASES')
2752: THEN
2753: FND_FILE.PUT_LINE(fnd_file.log, 'PO: Allow Retroactive Pricing of POs = '||lv_profile_setting );
2754: FND_FILE.PUT_LINE(fnd_file.log, 'This Concurrent Program is not executed as the profile (PO: Allow Retroactive Pricing of POs) is not set to ''ALL RELEASES''');
2755: retcode :=0;
2756: RETURN;
2757: END IF;
2758:

Line 2763: FND_FILE.PUT_LINE(fnd_file.log, ' ');

2759: FOR jai_retro_line_change_rec IN get_jai_retro_line_change_cur
2760: LOOP
2761: -- Print the shipment line information
2762: BEGIN
2763: FND_FILE.PUT_LINE(fnd_file.log, ' ');
2764: FND_FILE.PUT_LINE(fnd_file.log, '++++');
2765: FND_FILE.PUT_LINE(fnd_file.log, 'Loop for the shipment line, line_change_id ='||jai_retro_line_change_rec.line_change_id );
2766: FND_FILE.PUT_LINE(fnd_file.log, 'doc_type = '||jai_retro_line_change_rec.doc_type );
2767: FND_FILE.PUT_LINE(fnd_file.log, 'doc_header_id = '||jai_retro_line_change_rec.doc_header_id );

Line 2764: FND_FILE.PUT_LINE(fnd_file.log, '++++');

2760: LOOP
2761: -- Print the shipment line information
2762: BEGIN
2763: FND_FILE.PUT_LINE(fnd_file.log, ' ');
2764: FND_FILE.PUT_LINE(fnd_file.log, '++++');
2765: FND_FILE.PUT_LINE(fnd_file.log, 'Loop for the shipment line, line_change_id ='||jai_retro_line_change_rec.line_change_id );
2766: FND_FILE.PUT_LINE(fnd_file.log, 'doc_type = '||jai_retro_line_change_rec.doc_type );
2767: FND_FILE.PUT_LINE(fnd_file.log, 'doc_header_id = '||jai_retro_line_change_rec.doc_header_id );
2768: FND_FILE.PUT_LINE(fnd_file.log, 'doc_line_id = '||jai_retro_line_change_rec.doc_line_id );

Line 2765: FND_FILE.PUT_LINE(fnd_file.log, 'Loop for the shipment line, line_change_id ='||jai_retro_line_change_rec.line_change_id );

2761: -- Print the shipment line information
2762: BEGIN
2763: FND_FILE.PUT_LINE(fnd_file.log, ' ');
2764: FND_FILE.PUT_LINE(fnd_file.log, '++++');
2765: FND_FILE.PUT_LINE(fnd_file.log, 'Loop for the shipment line, line_change_id ='||jai_retro_line_change_rec.line_change_id );
2766: FND_FILE.PUT_LINE(fnd_file.log, 'doc_type = '||jai_retro_line_change_rec.doc_type );
2767: FND_FILE.PUT_LINE(fnd_file.log, 'doc_header_id = '||jai_retro_line_change_rec.doc_header_id );
2768: FND_FILE.PUT_LINE(fnd_file.log, 'doc_line_id = '||jai_retro_line_change_rec.doc_line_id );
2769: FND_FILE.PUT_LINE(fnd_file.log, 'line_location_id = '||jai_retro_line_change_rec.line_location_id );

Line 2766: FND_FILE.PUT_LINE(fnd_file.log, 'doc_type = '||jai_retro_line_change_rec.doc_type );

2762: BEGIN
2763: FND_FILE.PUT_LINE(fnd_file.log, ' ');
2764: FND_FILE.PUT_LINE(fnd_file.log, '++++');
2765: FND_FILE.PUT_LINE(fnd_file.log, 'Loop for the shipment line, line_change_id ='||jai_retro_line_change_rec.line_change_id );
2766: FND_FILE.PUT_LINE(fnd_file.log, 'doc_type = '||jai_retro_line_change_rec.doc_type );
2767: FND_FILE.PUT_LINE(fnd_file.log, 'doc_header_id = '||jai_retro_line_change_rec.doc_header_id );
2768: FND_FILE.PUT_LINE(fnd_file.log, 'doc_line_id = '||jai_retro_line_change_rec.doc_line_id );
2769: FND_FILE.PUT_LINE(fnd_file.log, 'line_location_id = '||jai_retro_line_change_rec.line_location_id );
2770: FND_FILE.PUT_LINE(fnd_file.log, 'from_header_id = '||jai_retro_line_change_rec.from_header_id );

Line 2767: FND_FILE.PUT_LINE(fnd_file.log, 'doc_header_id = '||jai_retro_line_change_rec.doc_header_id );

2763: FND_FILE.PUT_LINE(fnd_file.log, ' ');
2764: FND_FILE.PUT_LINE(fnd_file.log, '++++');
2765: FND_FILE.PUT_LINE(fnd_file.log, 'Loop for the shipment line, line_change_id ='||jai_retro_line_change_rec.line_change_id );
2766: FND_FILE.PUT_LINE(fnd_file.log, 'doc_type = '||jai_retro_line_change_rec.doc_type );
2767: FND_FILE.PUT_LINE(fnd_file.log, 'doc_header_id = '||jai_retro_line_change_rec.doc_header_id );
2768: FND_FILE.PUT_LINE(fnd_file.log, 'doc_line_id = '||jai_retro_line_change_rec.doc_line_id );
2769: FND_FILE.PUT_LINE(fnd_file.log, 'line_location_id = '||jai_retro_line_change_rec.line_location_id );
2770: FND_FILE.PUT_LINE(fnd_file.log, 'from_header_id = '||jai_retro_line_change_rec.from_header_id );
2771: FND_FILE.PUT_LINE(fnd_file.log, 'from_line_id = '||jai_retro_line_change_rec.from_line_id );

Line 2768: FND_FILE.PUT_LINE(fnd_file.log, 'doc_line_id = '||jai_retro_line_change_rec.doc_line_id );

2764: FND_FILE.PUT_LINE(fnd_file.log, '++++');
2765: FND_FILE.PUT_LINE(fnd_file.log, 'Loop for the shipment line, line_change_id ='||jai_retro_line_change_rec.line_change_id );
2766: FND_FILE.PUT_LINE(fnd_file.log, 'doc_type = '||jai_retro_line_change_rec.doc_type );
2767: FND_FILE.PUT_LINE(fnd_file.log, 'doc_header_id = '||jai_retro_line_change_rec.doc_header_id );
2768: FND_FILE.PUT_LINE(fnd_file.log, 'doc_line_id = '||jai_retro_line_change_rec.doc_line_id );
2769: FND_FILE.PUT_LINE(fnd_file.log, 'line_location_id = '||jai_retro_line_change_rec.line_location_id );
2770: FND_FILE.PUT_LINE(fnd_file.log, 'from_header_id = '||jai_retro_line_change_rec.from_header_id );
2771: FND_FILE.PUT_LINE(fnd_file.log, 'from_line_id = '||jai_retro_line_change_rec.from_line_id );
2772: FND_FILE.PUT_LINE(fnd_file.log, 'doc_version_number = '||jai_retro_line_change_rec.doc_version_number );

Line 2769: FND_FILE.PUT_LINE(fnd_file.log, 'line_location_id = '||jai_retro_line_change_rec.line_location_id );

2765: FND_FILE.PUT_LINE(fnd_file.log, 'Loop for the shipment line, line_change_id ='||jai_retro_line_change_rec.line_change_id );
2766: FND_FILE.PUT_LINE(fnd_file.log, 'doc_type = '||jai_retro_line_change_rec.doc_type );
2767: FND_FILE.PUT_LINE(fnd_file.log, 'doc_header_id = '||jai_retro_line_change_rec.doc_header_id );
2768: FND_FILE.PUT_LINE(fnd_file.log, 'doc_line_id = '||jai_retro_line_change_rec.doc_line_id );
2769: FND_FILE.PUT_LINE(fnd_file.log, 'line_location_id = '||jai_retro_line_change_rec.line_location_id );
2770: FND_FILE.PUT_LINE(fnd_file.log, 'from_header_id = '||jai_retro_line_change_rec.from_header_id );
2771: FND_FILE.PUT_LINE(fnd_file.log, 'from_line_id = '||jai_retro_line_change_rec.from_line_id );
2772: FND_FILE.PUT_LINE(fnd_file.log, 'doc_version_number = '||jai_retro_line_change_rec.doc_version_number );
2773: FND_FILE.PUT_LINE(fnd_file.log, 'inventory_item_id = '||jai_retro_line_change_rec.inventory_item_id );

Line 2770: FND_FILE.PUT_LINE(fnd_file.log, 'from_header_id = '||jai_retro_line_change_rec.from_header_id );

2766: FND_FILE.PUT_LINE(fnd_file.log, 'doc_type = '||jai_retro_line_change_rec.doc_type );
2767: FND_FILE.PUT_LINE(fnd_file.log, 'doc_header_id = '||jai_retro_line_change_rec.doc_header_id );
2768: FND_FILE.PUT_LINE(fnd_file.log, 'doc_line_id = '||jai_retro_line_change_rec.doc_line_id );
2769: FND_FILE.PUT_LINE(fnd_file.log, 'line_location_id = '||jai_retro_line_change_rec.line_location_id );
2770: FND_FILE.PUT_LINE(fnd_file.log, 'from_header_id = '||jai_retro_line_change_rec.from_header_id );
2771: FND_FILE.PUT_LINE(fnd_file.log, 'from_line_id = '||jai_retro_line_change_rec.from_line_id );
2772: FND_FILE.PUT_LINE(fnd_file.log, 'doc_version_number = '||jai_retro_line_change_rec.doc_version_number );
2773: FND_FILE.PUT_LINE(fnd_file.log, 'inventory_item_id = '||jai_retro_line_change_rec.inventory_item_id );
2774: FND_FILE.PUT_LINE(fnd_file.log, 'organization_id = '||jai_retro_line_change_rec.organization_id );

Line 2771: FND_FILE.PUT_LINE(fnd_file.log, 'from_line_id = '||jai_retro_line_change_rec.from_line_id );

2767: FND_FILE.PUT_LINE(fnd_file.log, 'doc_header_id = '||jai_retro_line_change_rec.doc_header_id );
2768: FND_FILE.PUT_LINE(fnd_file.log, 'doc_line_id = '||jai_retro_line_change_rec.doc_line_id );
2769: FND_FILE.PUT_LINE(fnd_file.log, 'line_location_id = '||jai_retro_line_change_rec.line_location_id );
2770: FND_FILE.PUT_LINE(fnd_file.log, 'from_header_id = '||jai_retro_line_change_rec.from_header_id );
2771: FND_FILE.PUT_LINE(fnd_file.log, 'from_line_id = '||jai_retro_line_change_rec.from_line_id );
2772: FND_FILE.PUT_LINE(fnd_file.log, 'doc_version_number = '||jai_retro_line_change_rec.doc_version_number );
2773: FND_FILE.PUT_LINE(fnd_file.log, 'inventory_item_id = '||jai_retro_line_change_rec.inventory_item_id );
2774: FND_FILE.PUT_LINE(fnd_file.log, 'organization_id = '||jai_retro_line_change_rec.organization_id );
2775: FND_FILE.PUT_LINE(fnd_file.log, 'original_unit_price = '||jai_retro_line_change_rec.original_unit_price );

Line 2772: FND_FILE.PUT_LINE(fnd_file.log, 'doc_version_number = '||jai_retro_line_change_rec.doc_version_number );

2768: FND_FILE.PUT_LINE(fnd_file.log, 'doc_line_id = '||jai_retro_line_change_rec.doc_line_id );
2769: FND_FILE.PUT_LINE(fnd_file.log, 'line_location_id = '||jai_retro_line_change_rec.line_location_id );
2770: FND_FILE.PUT_LINE(fnd_file.log, 'from_header_id = '||jai_retro_line_change_rec.from_header_id );
2771: FND_FILE.PUT_LINE(fnd_file.log, 'from_line_id = '||jai_retro_line_change_rec.from_line_id );
2772: FND_FILE.PUT_LINE(fnd_file.log, 'doc_version_number = '||jai_retro_line_change_rec.doc_version_number );
2773: FND_FILE.PUT_LINE(fnd_file.log, 'inventory_item_id = '||jai_retro_line_change_rec.inventory_item_id );
2774: FND_FILE.PUT_LINE(fnd_file.log, 'organization_id = '||jai_retro_line_change_rec.organization_id );
2775: FND_FILE.PUT_LINE(fnd_file.log, 'original_unit_price = '||jai_retro_line_change_rec.original_unit_price );
2776: FND_FILE.PUT_LINE(fnd_file.log, 'modified_unit_price = '||jai_retro_line_change_rec.modified_unit_price );

Line 2773: FND_FILE.PUT_LINE(fnd_file.log, 'inventory_item_id = '||jai_retro_line_change_rec.inventory_item_id );

2769: FND_FILE.PUT_LINE(fnd_file.log, 'line_location_id = '||jai_retro_line_change_rec.line_location_id );
2770: FND_FILE.PUT_LINE(fnd_file.log, 'from_header_id = '||jai_retro_line_change_rec.from_header_id );
2771: FND_FILE.PUT_LINE(fnd_file.log, 'from_line_id = '||jai_retro_line_change_rec.from_line_id );
2772: FND_FILE.PUT_LINE(fnd_file.log, 'doc_version_number = '||jai_retro_line_change_rec.doc_version_number );
2773: FND_FILE.PUT_LINE(fnd_file.log, 'inventory_item_id = '||jai_retro_line_change_rec.inventory_item_id );
2774: FND_FILE.PUT_LINE(fnd_file.log, 'organization_id = '||jai_retro_line_change_rec.organization_id );
2775: FND_FILE.PUT_LINE(fnd_file.log, 'original_unit_price = '||jai_retro_line_change_rec.original_unit_price );
2776: FND_FILE.PUT_LINE(fnd_file.log, 'modified_unit_price = '||jai_retro_line_change_rec.modified_unit_price );
2777: FND_FILE.PUT_LINE(fnd_file.log, 'receipt_processed_flag = '||jai_retro_line_change_rec.receipt_processed_flag);

Line 2774: FND_FILE.PUT_LINE(fnd_file.log, 'organization_id = '||jai_retro_line_change_rec.organization_id );

2770: FND_FILE.PUT_LINE(fnd_file.log, 'from_header_id = '||jai_retro_line_change_rec.from_header_id );
2771: FND_FILE.PUT_LINE(fnd_file.log, 'from_line_id = '||jai_retro_line_change_rec.from_line_id );
2772: FND_FILE.PUT_LINE(fnd_file.log, 'doc_version_number = '||jai_retro_line_change_rec.doc_version_number );
2773: FND_FILE.PUT_LINE(fnd_file.log, 'inventory_item_id = '||jai_retro_line_change_rec.inventory_item_id );
2774: FND_FILE.PUT_LINE(fnd_file.log, 'organization_id = '||jai_retro_line_change_rec.organization_id );
2775: FND_FILE.PUT_LINE(fnd_file.log, 'original_unit_price = '||jai_retro_line_change_rec.original_unit_price );
2776: FND_FILE.PUT_LINE(fnd_file.log, 'modified_unit_price = '||jai_retro_line_change_rec.modified_unit_price );
2777: FND_FILE.PUT_LINE(fnd_file.log, 'receipt_processed_flag = '||jai_retro_line_change_rec.receipt_processed_flag);
2778: FND_FILE.PUT_LINE(fnd_file.log, 'excise_action = '||jai_retro_line_change_rec.excise_action );

Line 2775: FND_FILE.PUT_LINE(fnd_file.log, 'original_unit_price = '||jai_retro_line_change_rec.original_unit_price );

2771: FND_FILE.PUT_LINE(fnd_file.log, 'from_line_id = '||jai_retro_line_change_rec.from_line_id );
2772: FND_FILE.PUT_LINE(fnd_file.log, 'doc_version_number = '||jai_retro_line_change_rec.doc_version_number );
2773: FND_FILE.PUT_LINE(fnd_file.log, 'inventory_item_id = '||jai_retro_line_change_rec.inventory_item_id );
2774: FND_FILE.PUT_LINE(fnd_file.log, 'organization_id = '||jai_retro_line_change_rec.organization_id );
2775: FND_FILE.PUT_LINE(fnd_file.log, 'original_unit_price = '||jai_retro_line_change_rec.original_unit_price );
2776: FND_FILE.PUT_LINE(fnd_file.log, 'modified_unit_price = '||jai_retro_line_change_rec.modified_unit_price );
2777: FND_FILE.PUT_LINE(fnd_file.log, 'receipt_processed_flag = '||jai_retro_line_change_rec.receipt_processed_flag);
2778: FND_FILE.PUT_LINE(fnd_file.log, 'excise_action = '||jai_retro_line_change_rec.excise_action );
2779: FND_FILE.PUT_LINE(fnd_file.log, 'vat_action = '||jai_retro_line_change_rec.vat_action );

Line 2776: FND_FILE.PUT_LINE(fnd_file.log, 'modified_unit_price = '||jai_retro_line_change_rec.modified_unit_price );

2772: FND_FILE.PUT_LINE(fnd_file.log, 'doc_version_number = '||jai_retro_line_change_rec.doc_version_number );
2773: FND_FILE.PUT_LINE(fnd_file.log, 'inventory_item_id = '||jai_retro_line_change_rec.inventory_item_id );
2774: FND_FILE.PUT_LINE(fnd_file.log, 'organization_id = '||jai_retro_line_change_rec.organization_id );
2775: FND_FILE.PUT_LINE(fnd_file.log, 'original_unit_price = '||jai_retro_line_change_rec.original_unit_price );
2776: FND_FILE.PUT_LINE(fnd_file.log, 'modified_unit_price = '||jai_retro_line_change_rec.modified_unit_price );
2777: FND_FILE.PUT_LINE(fnd_file.log, 'receipt_processed_flag = '||jai_retro_line_change_rec.receipt_processed_flag);
2778: FND_FILE.PUT_LINE(fnd_file.log, 'excise_action = '||jai_retro_line_change_rec.excise_action );
2779: FND_FILE.PUT_LINE(fnd_file.log, 'vat_action = '||jai_retro_line_change_rec.vat_action );
2780: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_no = '||jai_retro_line_change_rec.excise_invoice_no );

Line 2777: FND_FILE.PUT_LINE(fnd_file.log, 'receipt_processed_flag = '||jai_retro_line_change_rec.receipt_processed_flag);

2773: FND_FILE.PUT_LINE(fnd_file.log, 'inventory_item_id = '||jai_retro_line_change_rec.inventory_item_id );
2774: FND_FILE.PUT_LINE(fnd_file.log, 'organization_id = '||jai_retro_line_change_rec.organization_id );
2775: FND_FILE.PUT_LINE(fnd_file.log, 'original_unit_price = '||jai_retro_line_change_rec.original_unit_price );
2776: FND_FILE.PUT_LINE(fnd_file.log, 'modified_unit_price = '||jai_retro_line_change_rec.modified_unit_price );
2777: FND_FILE.PUT_LINE(fnd_file.log, 'receipt_processed_flag = '||jai_retro_line_change_rec.receipt_processed_flag);
2778: FND_FILE.PUT_LINE(fnd_file.log, 'excise_action = '||jai_retro_line_change_rec.excise_action );
2779: FND_FILE.PUT_LINE(fnd_file.log, 'vat_action = '||jai_retro_line_change_rec.vat_action );
2780: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_no = '||jai_retro_line_change_rec.excise_invoice_no );
2781: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_date = '||jai_retro_line_change_rec.excise_invoice_date );

Line 2778: FND_FILE.PUT_LINE(fnd_file.log, 'excise_action = '||jai_retro_line_change_rec.excise_action );

2774: FND_FILE.PUT_LINE(fnd_file.log, 'organization_id = '||jai_retro_line_change_rec.organization_id );
2775: FND_FILE.PUT_LINE(fnd_file.log, 'original_unit_price = '||jai_retro_line_change_rec.original_unit_price );
2776: FND_FILE.PUT_LINE(fnd_file.log, 'modified_unit_price = '||jai_retro_line_change_rec.modified_unit_price );
2777: FND_FILE.PUT_LINE(fnd_file.log, 'receipt_processed_flag = '||jai_retro_line_change_rec.receipt_processed_flag);
2778: FND_FILE.PUT_LINE(fnd_file.log, 'excise_action = '||jai_retro_line_change_rec.excise_action );
2779: FND_FILE.PUT_LINE(fnd_file.log, 'vat_action = '||jai_retro_line_change_rec.vat_action );
2780: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_no = '||jai_retro_line_change_rec.excise_invoice_no );
2781: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_date = '||jai_retro_line_change_rec.excise_invoice_date );
2782: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_no = '||jai_retro_line_change_rec.vat_invoice_no );

Line 2779: FND_FILE.PUT_LINE(fnd_file.log, 'vat_action = '||jai_retro_line_change_rec.vat_action );

2775: FND_FILE.PUT_LINE(fnd_file.log, 'original_unit_price = '||jai_retro_line_change_rec.original_unit_price );
2776: FND_FILE.PUT_LINE(fnd_file.log, 'modified_unit_price = '||jai_retro_line_change_rec.modified_unit_price );
2777: FND_FILE.PUT_LINE(fnd_file.log, 'receipt_processed_flag = '||jai_retro_line_change_rec.receipt_processed_flag);
2778: FND_FILE.PUT_LINE(fnd_file.log, 'excise_action = '||jai_retro_line_change_rec.excise_action );
2779: FND_FILE.PUT_LINE(fnd_file.log, 'vat_action = '||jai_retro_line_change_rec.vat_action );
2780: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_no = '||jai_retro_line_change_rec.excise_invoice_no );
2781: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_date = '||jai_retro_line_change_rec.excise_invoice_date );
2782: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_no = '||jai_retro_line_change_rec.vat_invoice_no );
2783: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_date = '||jai_retro_line_change_rec.vat_invoice_date );

Line 2780: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_no = '||jai_retro_line_change_rec.excise_invoice_no );

2776: FND_FILE.PUT_LINE(fnd_file.log, 'modified_unit_price = '||jai_retro_line_change_rec.modified_unit_price );
2777: FND_FILE.PUT_LINE(fnd_file.log, 'receipt_processed_flag = '||jai_retro_line_change_rec.receipt_processed_flag);
2778: FND_FILE.PUT_LINE(fnd_file.log, 'excise_action = '||jai_retro_line_change_rec.excise_action );
2779: FND_FILE.PUT_LINE(fnd_file.log, 'vat_action = '||jai_retro_line_change_rec.vat_action );
2780: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_no = '||jai_retro_line_change_rec.excise_invoice_no );
2781: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_date = '||jai_retro_line_change_rec.excise_invoice_date );
2782: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_no = '||jai_retro_line_change_rec.vat_invoice_no );
2783: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_date = '||jai_retro_line_change_rec.vat_invoice_date );
2784: FND_FILE.PUT_LINE(fnd_file.log, 'retro_request_id = '||jai_retro_line_change_rec.retro_request_id );

Line 2781: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_date = '||jai_retro_line_change_rec.excise_invoice_date );

2777: FND_FILE.PUT_LINE(fnd_file.log, 'receipt_processed_flag = '||jai_retro_line_change_rec.receipt_processed_flag);
2778: FND_FILE.PUT_LINE(fnd_file.log, 'excise_action = '||jai_retro_line_change_rec.excise_action );
2779: FND_FILE.PUT_LINE(fnd_file.log, 'vat_action = '||jai_retro_line_change_rec.vat_action );
2780: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_no = '||jai_retro_line_change_rec.excise_invoice_no );
2781: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_date = '||jai_retro_line_change_rec.excise_invoice_date );
2782: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_no = '||jai_retro_line_change_rec.vat_invoice_no );
2783: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_date = '||jai_retro_line_change_rec.vat_invoice_date );
2784: FND_FILE.PUT_LINE(fnd_file.log, 'retro_request_id = '||jai_retro_line_change_rec.retro_request_id );
2785: FND_FILE.PUT_LINE(fnd_file.log, 'doc_number = '||jai_retro_line_change_rec.doc_number );

Line 2782: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_no = '||jai_retro_line_change_rec.vat_invoice_no );

2778: FND_FILE.PUT_LINE(fnd_file.log, 'excise_action = '||jai_retro_line_change_rec.excise_action );
2779: FND_FILE.PUT_LINE(fnd_file.log, 'vat_action = '||jai_retro_line_change_rec.vat_action );
2780: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_no = '||jai_retro_line_change_rec.excise_invoice_no );
2781: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_date = '||jai_retro_line_change_rec.excise_invoice_date );
2782: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_no = '||jai_retro_line_change_rec.vat_invoice_no );
2783: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_date = '||jai_retro_line_change_rec.vat_invoice_date );
2784: FND_FILE.PUT_LINE(fnd_file.log, 'retro_request_id = '||jai_retro_line_change_rec.retro_request_id );
2785: FND_FILE.PUT_LINE(fnd_file.log, 'doc_number = '||jai_retro_line_change_rec.doc_number );
2786: FND_FILE.PUT_LINE(fnd_file.log, 'vendor_id = '||jai_retro_line_change_rec.vendor_id );

Line 2783: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_date = '||jai_retro_line_change_rec.vat_invoice_date );

2779: FND_FILE.PUT_LINE(fnd_file.log, 'vat_action = '||jai_retro_line_change_rec.vat_action );
2780: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_no = '||jai_retro_line_change_rec.excise_invoice_no );
2781: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_date = '||jai_retro_line_change_rec.excise_invoice_date );
2782: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_no = '||jai_retro_line_change_rec.vat_invoice_no );
2783: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_date = '||jai_retro_line_change_rec.vat_invoice_date );
2784: FND_FILE.PUT_LINE(fnd_file.log, 'retro_request_id = '||jai_retro_line_change_rec.retro_request_id );
2785: FND_FILE.PUT_LINE(fnd_file.log, 'doc_number = '||jai_retro_line_change_rec.doc_number );
2786: FND_FILE.PUT_LINE(fnd_file.log, 'vendor_id = '||jai_retro_line_change_rec.vendor_id );
2787: FND_FILE.PUT_LINE(fnd_file.log, 'vendor_site_id = '||jai_retro_line_change_rec.vendor_site_id );

Line 2784: FND_FILE.PUT_LINE(fnd_file.log, 'retro_request_id = '||jai_retro_line_change_rec.retro_request_id );

2780: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_no = '||jai_retro_line_change_rec.excise_invoice_no );
2781: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_date = '||jai_retro_line_change_rec.excise_invoice_date );
2782: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_no = '||jai_retro_line_change_rec.vat_invoice_no );
2783: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_date = '||jai_retro_line_change_rec.vat_invoice_date );
2784: FND_FILE.PUT_LINE(fnd_file.log, 'retro_request_id = '||jai_retro_line_change_rec.retro_request_id );
2785: FND_FILE.PUT_LINE(fnd_file.log, 'doc_number = '||jai_retro_line_change_rec.doc_number );
2786: FND_FILE.PUT_LINE(fnd_file.log, 'vendor_id = '||jai_retro_line_change_rec.vendor_id );
2787: FND_FILE.PUT_LINE(fnd_file.log, 'vendor_site_id = '||jai_retro_line_change_rec.vendor_site_id );
2788: END;

Line 2785: FND_FILE.PUT_LINE(fnd_file.log, 'doc_number = '||jai_retro_line_change_rec.doc_number );

2781: FND_FILE.PUT_LINE(fnd_file.log, 'excise_invoice_date = '||jai_retro_line_change_rec.excise_invoice_date );
2782: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_no = '||jai_retro_line_change_rec.vat_invoice_no );
2783: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_date = '||jai_retro_line_change_rec.vat_invoice_date );
2784: FND_FILE.PUT_LINE(fnd_file.log, 'retro_request_id = '||jai_retro_line_change_rec.retro_request_id );
2785: FND_FILE.PUT_LINE(fnd_file.log, 'doc_number = '||jai_retro_line_change_rec.doc_number );
2786: FND_FILE.PUT_LINE(fnd_file.log, 'vendor_id = '||jai_retro_line_change_rec.vendor_id );
2787: FND_FILE.PUT_LINE(fnd_file.log, 'vendor_site_id = '||jai_retro_line_change_rec.vendor_site_id );
2788: END;
2789:

Line 2786: FND_FILE.PUT_LINE(fnd_file.log, 'vendor_id = '||jai_retro_line_change_rec.vendor_id );

2782: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_no = '||jai_retro_line_change_rec.vat_invoice_no );
2783: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_date = '||jai_retro_line_change_rec.vat_invoice_date );
2784: FND_FILE.PUT_LINE(fnd_file.log, 'retro_request_id = '||jai_retro_line_change_rec.retro_request_id );
2785: FND_FILE.PUT_LINE(fnd_file.log, 'doc_number = '||jai_retro_line_change_rec.doc_number );
2786: FND_FILE.PUT_LINE(fnd_file.log, 'vendor_id = '||jai_retro_line_change_rec.vendor_id );
2787: FND_FILE.PUT_LINE(fnd_file.log, 'vendor_site_id = '||jai_retro_line_change_rec.vendor_site_id );
2788: END;
2789:
2790: ln_skip_rcpt_cnt := 0; --This is to count the number of receipts which are not processed for this Shipment

Line 2787: FND_FILE.PUT_LINE(fnd_file.log, 'vendor_site_id = '||jai_retro_line_change_rec.vendor_site_id );

2783: FND_FILE.PUT_LINE(fnd_file.log, 'vat_invoice_date = '||jai_retro_line_change_rec.vat_invoice_date );
2784: FND_FILE.PUT_LINE(fnd_file.log, 'retro_request_id = '||jai_retro_line_change_rec.retro_request_id );
2785: FND_FILE.PUT_LINE(fnd_file.log, 'doc_number = '||jai_retro_line_change_rec.doc_number );
2786: FND_FILE.PUT_LINE(fnd_file.log, 'vendor_id = '||jai_retro_line_change_rec.vendor_id );
2787: FND_FILE.PUT_LINE(fnd_file.log, 'vendor_site_id = '||jai_retro_line_change_rec.vendor_site_id );
2788: END;
2789:
2790: ln_skip_rcpt_cnt := 0; --This is to count the number of receipts which are not processed for this Shipment
2791: ln_receipt_processed_no :=0 ;--Initial vaiable for counting receipt processed number for a shipment

Line 2804: FND_FILE.PUT_LINE(fnd_file.log, ' ');

2800: jai_rcv_transactions_rec := Get_Jai_Rcv_Trans_Record(rcv_transactions_rec.transaction_id);
2801: jai_rcv_lines_rec := Get_Jai_Rcv_Lines_Record(rcv_transactions_rec.transaction_id);
2802:
2803: BEGIN
2804: FND_FILE.PUT_LINE(fnd_file.log, ' ');
2805: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
2806: FND_FILE.PUT_LINE(fnd_file.log, ' LOOP through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
2807: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);
2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);

Line 2805: FND_FILE.PUT_LINE(fnd_file.log, ' ++');

2801: jai_rcv_lines_rec := Get_Jai_Rcv_Lines_Record(rcv_transactions_rec.transaction_id);
2802:
2803: BEGIN
2804: FND_FILE.PUT_LINE(fnd_file.log, ' ');
2805: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
2806: FND_FILE.PUT_LINE(fnd_file.log, ' LOOP through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
2807: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);
2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);
2809: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );

Line 2806: FND_FILE.PUT_LINE(fnd_file.log, ' LOOP through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);

2802:
2803: BEGIN
2804: FND_FILE.PUT_LINE(fnd_file.log, ' ');
2805: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
2806: FND_FILE.PUT_LINE(fnd_file.log, ' LOOP through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
2807: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);
2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);
2809: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );
2810: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);

Line 2807: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);

2803: BEGIN
2804: FND_FILE.PUT_LINE(fnd_file.log, ' ');
2805: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
2806: FND_FILE.PUT_LINE(fnd_file.log, ' LOOP through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
2807: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);
2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);
2809: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );
2810: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);
2811: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);

Line 2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);

2804: FND_FILE.PUT_LINE(fnd_file.log, ' ');
2805: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
2806: FND_FILE.PUT_LINE(fnd_file.log, ' LOOP through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
2807: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);
2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);
2809: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );
2810: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);
2811: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);
2812: FND_FILE.PUT_LINE(fnd_file.log, '');

Line 2809: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );

2805: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
2806: FND_FILE.PUT_LINE(fnd_file.log, ' LOOP through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
2807: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);
2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);
2809: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );
2810: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);
2811: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);
2812: FND_FILE.PUT_LINE(fnd_file.log, '');
2813: END;

Line 2810: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);

2806: FND_FILE.PUT_LINE(fnd_file.log, ' LOOP through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
2807: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);
2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);
2809: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );
2810: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);
2811: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);
2812: FND_FILE.PUT_LINE(fnd_file.log, '');
2813: END;
2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL

Line 2811: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);

2807: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);
2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);
2809: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );
2810: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);
2811: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);
2812: FND_FILE.PUT_LINE(fnd_file.log, '');
2813: END;
2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'

Line 2812: FND_FILE.PUT_LINE(fnd_file.log, '');

2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);
2809: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );
2810: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);
2811: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);
2812: FND_FILE.PUT_LINE(fnd_file.log, '');
2813: END;
2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'

Line 2832: FND_FILE.PUT_LINE(fnd_file.log, ' Vat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');

2828: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2829: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2830: )
2831: THEN
2832: FND_FILE.PUT_LINE(fnd_file.log, ' Vat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');
2833: END IF;
2834:
2835: IF( jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2836: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'

Line 2841: FND_FILE.PUT_LINE(fnd_file.log, ' Cenvat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');

2837: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2838: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2839: )
2840: THEN
2841: FND_FILE.PUT_LINE(fnd_file.log, ' Cenvat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');
2842: END IF;
2843:
2844: FND_FILE.PUT_LINE(fnd_file.log, ' Please Claim it before running the concurrent JAI Retroactive price Update');
2845: ln_skip_rcpt_cnt := ln_skip_rcpt_cnt + 1;

Line 2844: FND_FILE.PUT_LINE(fnd_file.log, ' Please Claim it before running the concurrent JAI Retroactive price Update');

2840: THEN
2841: FND_FILE.PUT_LINE(fnd_file.log, ' Cenvat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');
2842: END IF;
2843:
2844: FND_FILE.PUT_LINE(fnd_file.log, ' Please Claim it before running the concurrent JAI Retroactive price Update');
2845: ln_skip_rcpt_cnt := ln_skip_rcpt_cnt + 1;
2846: ELSE
2847: --get the retro line change id the receipt from a sequence
2848: SELECT

Line 2857: FND_FILE.PUT_LINE(fnd_file.log, ' ln_retro_line_changes_id : '|| ln_retro_line_changes_id);

2853: DUAL;
2854:
2855: IF (ln_proc_level >= ln_dbg_level)
2856: THEN
2857: FND_FILE.PUT_LINE(fnd_file.log, ' ln_retro_line_changes_id : '|| ln_retro_line_changes_id);
2858: END IF; --l_proc_level>=l_dbg_level
2859:
2860: --get the version number of retro tax line for the receipt
2861: --starting from 0

Line 2874: FND_FILE.PUT_LINE(fnd_file.log, ' ln_retro_line_changes_version : '|| ln_retro_line_changes_version);

2870: AND doc_type = 'RECEIPT';
2871:
2872: IF (ln_proc_level >= ln_dbg_level)
2873: THEN
2874: FND_FILE.PUT_LINE(fnd_file.log, ' ln_retro_line_changes_version : '|| ln_retro_line_changes_version);
2875: END IF; --l_proc_level>=l_dbg_level
2876:
2877: --insert data into jai_retro_line_changes table
2878: INSERT INTO jai_retro_line_changes

Line 2943: FND_FILE.PUT_LINE(fnd_file.log, ' Table jai_retro_line_changes inserted ');

2939: );
2940:
2941: IF (ln_proc_level >= ln_dbg_level)
2942: THEN
2943: FND_FILE.PUT_LINE(fnd_file.log, ' Table jai_retro_line_changes inserted ');
2944: END IF; --l_proc_level>=l_dbg_level
2945:
2946: FOR jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur (rcv_transactions_rec.transaction_id)
2947: LOOP

Line 2993: FND_FILE.PUT_LINE(fnd_file.log, ' Table jai_retro_tax_changes inserted ');

2989: END LOOP;-- (jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur)
2990:
2991: IF (ln_proc_level >= ln_dbg_level)
2992: THEN
2993: FND_FILE.PUT_LINE(fnd_file.log, ' Table jai_retro_tax_changes inserted ');
2994: END IF; --l_proc_level>=l_dbg_level
2995:
2996: --calc_new_line_amount
2997: ln_recv_line_amount := jai_retro_line_change_rec.modified_unit_price

Line 3004: FND_FILE.PUT_LINE(fnd_file.log, ' ln_recv_line_amount : '|| ln_recv_line_amount);

3000: ln_recv_tax_amount := ln_recv_line_amount;
3001:
3002: IF (ln_proc_level >= ln_dbg_level)
3003: THEN
3004: FND_FILE.PUT_LINE(fnd_file.log, ' ln_recv_line_amount : '|| ln_recv_line_amount);
3005: FND_FILE.PUT_LINE(fnd_file.log, ' ln_recv_tax_amount : '|| ln_recv_tax_amount);
3006: END IF; --l_proc_level>=l_dbg_level
3007:
3008: --get_assessable_value

Line 3005: FND_FILE.PUT_LINE(fnd_file.log, ' ln_recv_tax_amount : '|| ln_recv_tax_amount);

3001:
3002: IF (ln_proc_level >= ln_dbg_level)
3003: THEN
3004: FND_FILE.PUT_LINE(fnd_file.log, ' ln_recv_line_amount : '|| ln_recv_line_amount);
3005: FND_FILE.PUT_LINE(fnd_file.log, ' ln_recv_tax_amount : '|| ln_recv_tax_amount);
3006: END IF; --l_proc_level>=l_dbg_level
3007:
3008: --get_assessable_value
3009: ln_assessable_value := jai_cmn_setup_pkg.get_po_assessable_value

Line 3018: FND_FILE.PUT_LINE(fnd_file.log, ' ln_assessable_value : '|| ln_assessable_value);

3014: );
3015:
3016: IF (ln_proc_level >= ln_dbg_level)
3017: THEN
3018: FND_FILE.PUT_LINE(fnd_file.log, ' ln_assessable_value : '|| ln_assessable_value);
3019: END IF; --l_proc_level>=l_dbg_level
3020:
3021: IF NVL( ln_assessable_value, 0 ) <= 0
3022: THEN

Line 3030: FND_FILE.PUT_LINE(fnd_file.log, ' ln_assessable_value :=ln_assessable_value*quantity : '|| ln_assessable_value);

3026: END IF;
3027:
3028: IF (ln_proc_level >= ln_dbg_level)
3029: THEN
3030: FND_FILE.PUT_LINE(fnd_file.log, ' ln_assessable_value :=ln_assessable_value*quantity : '|| ln_assessable_value);
3031: END IF; --l_proc_level>=l_dbg_level
3032:
3033: --get_vat_assessable_value
3034: ln_vat_assess_value := jai_general_pkg.ja_in_vat_assessable_value

Line 3046: FND_FILE.PUT_LINE(fnd_file.log, ' ln_vat_assess_value : '|| ln_vat_assess_value);

3042: );
3043:
3044: IF (ln_proc_level >= ln_dbg_level)
3045: THEN
3046: FND_FILE.PUT_LINE(fnd_file.log, ' ln_vat_assess_value : '|| ln_vat_assess_value);
3047: END IF; --l_proc_level>=l_dbg_level
3048:
3049:
3050: ln_vat_assess_value := ln_vat_assess_value * rcv_transactions_rec.quantity;

Line 3054: FND_FILE.PUT_LINE(fnd_file.log, ' ln_vat_assess_value :=ln_vat_assess_value*quantity : '|| ln_vat_assess_value);

3050: ln_vat_assess_value := ln_vat_assess_value * rcv_transactions_rec.quantity;
3051:
3052: IF (ln_proc_level >= ln_dbg_level)
3053: THEN
3054: FND_FILE.PUT_LINE(fnd_file.log, ' ln_vat_assess_value :=ln_vat_assess_value*quantity : '|| ln_vat_assess_value);
3055: END IF; --l_proc_level>=l_dbg_level
3056:
3057: JAI_PO_TAX_PKG.Calculate_Tax
3058: ( p_type => 'RECEIPTS'

Line 3075: Fnd_File.Put_Line(FND_FILE.LOG,' New total tax amount of the receipt '||jai_rcv_lines_rec.receipt_num||' IS :' ||ln_recv_tax_amount);

3071: , pv_called_from => 'RETROACTIVE' -- New parameter
3072: );
3073:
3074: -- print the new total tax amount of the receipt
3075: Fnd_File.Put_Line(FND_FILE.LOG,' New total tax amount of the receipt '||jai_rcv_lines_rec.receipt_num||' IS :' ||ln_recv_tax_amount);
3076:
3077: -- After recalculating the tax ,updat the modified_tax_amount of jai_retro_tax_changes table
3078: FOR jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur (rcv_transactions_rec.transaction_id)
3079: LOOP

Line 3095: Fnd_File.Put_Line(FND_FILE.LOG,' New tax has been updated to the table jai_retro_tax_changes ');

3091: AND tax_line_no = jai_rcv_line_taxes_rec.tax_line_no
3092: AND tax_id = jai_rcv_line_taxes_rec.tax_id ;
3093: END LOOP; --jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur
3094:
3095: Fnd_File.Put_Line(FND_FILE.LOG,' New tax has been updated to the table jai_retro_tax_changes ');
3096:
3097: Get_Vat_CenVat_Amount
3098: ( pn_line_change_id => ln_retro_line_changes_id
3099: , xn_re_vat_amount => ln_re_vat_amount

Line 3124: Fnd_File.Put_Line(FND_FILE.LOG,' New VAT tax amount is : '|| ln_modif_re_vat_amount|| ', the difference from old vat tax is :'|| ln_diff_re_vat_amount);

3120: );
3121: ----------------------------------------------------------------------------------------------
3122: --eric added for bug 6957519/6958938/6968839 on Apr 10,2008,end
3123:
3124: Fnd_File.Put_Line(FND_FILE.LOG,' New VAT tax amount is : '|| ln_modif_re_vat_amount|| ', the difference from old vat tax is :'|| ln_diff_re_vat_amount);
3125: Fnd_File.Put_Line(FND_FILE.LOG,' New CENVAT tax amount is : '|| ln_modif_re_cenvat_amount|| ', the difference from old cenvat tax is :'|| ln_diff_re_cenvat_amount);
3126: Fnd_File.Put_Line(FND_FILE.LOG,' New NonRecoverable Tax is : '|| ln_modif_nonre_tax_amount|| ', the difference from old NonRecoverable tax is :'|| ln_diff_nonre_tax_amount);
3127:
3128: lv_cenvat_action := pv_cenvat_action ;

Line 3125: Fnd_File.Put_Line(FND_FILE.LOG,' New CENVAT tax amount is : '|| ln_modif_re_cenvat_amount|| ', the difference from old cenvat tax is :'|| ln_diff_re_cenvat_amount);

3121: ----------------------------------------------------------------------------------------------
3122: --eric added for bug 6957519/6958938/6968839 on Apr 10,2008,end
3123:
3124: Fnd_File.Put_Line(FND_FILE.LOG,' New VAT tax amount is : '|| ln_modif_re_vat_amount|| ', the difference from old vat tax is :'|| ln_diff_re_vat_amount);
3125: Fnd_File.Put_Line(FND_FILE.LOG,' New CENVAT tax amount is : '|| ln_modif_re_cenvat_amount|| ', the difference from old cenvat tax is :'|| ln_diff_re_cenvat_amount);
3126: Fnd_File.Put_Line(FND_FILE.LOG,' New NonRecoverable Tax is : '|| ln_modif_nonre_tax_amount|| ', the difference from old NonRecoverable tax is :'|| ln_diff_nonre_tax_amount);
3127:
3128: lv_cenvat_action := pv_cenvat_action ;
3129: lv_vat_action := pv_vat_action ;

Line 3126: Fnd_File.Put_Line(FND_FILE.LOG,' New NonRecoverable Tax is : '|| ln_modif_nonre_tax_amount|| ', the difference from old NonRecoverable tax is :'|| ln_diff_nonre_tax_amount);

3122: --eric added for bug 6957519/6958938/6968839 on Apr 10,2008,end
3123:
3124: Fnd_File.Put_Line(FND_FILE.LOG,' New VAT tax amount is : '|| ln_modif_re_vat_amount|| ', the difference from old vat tax is :'|| ln_diff_re_vat_amount);
3125: Fnd_File.Put_Line(FND_FILE.LOG,' New CENVAT tax amount is : '|| ln_modif_re_cenvat_amount|| ', the difference from old cenvat tax is :'|| ln_diff_re_cenvat_amount);
3126: Fnd_File.Put_Line(FND_FILE.LOG,' New NonRecoverable Tax is : '|| ln_modif_nonre_tax_amount|| ', the difference from old NonRecoverable tax is :'|| ln_diff_nonre_tax_amount);
3127:
3128: lv_cenvat_action := pv_cenvat_action ;
3129: lv_vat_action := pv_vat_action ;
3130:

Line 3153: Fnd_File.Put_Line(FND_FILE.LOG,' ');

3149: , pn_version_number => ln_retro_line_changes_version -- current version of the receipt i.e previous version plus one
3150: , pn_line_change_id => ln_retro_line_changes_id
3151: );
3152:
3153: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3154: Fnd_File.Put_Line(FND_FILE.LOG,' Do_Accounting() Invoked. ');
3155: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3156: -- print a message stating that accounting is done
3157: -- Call the procedure to Claim or Unclaim Cenvat do its accounting

Line 3154: Fnd_File.Put_Line(FND_FILE.LOG,' Do_Accounting() Invoked. ');

3150: , pn_line_change_id => ln_retro_line_changes_id
3151: );
3152:
3153: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3154: Fnd_File.Put_Line(FND_FILE.LOG,' Do_Accounting() Invoked. ');
3155: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3156: -- print a message stating that accounting is done
3157: -- Call the procedure to Claim or Unclaim Cenvat do its accounting
3158:

Line 3155: Fnd_File.Put_Line(FND_FILE.LOG,' ');

3151: );
3152:
3153: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3154: Fnd_File.Put_Line(FND_FILE.LOG,' Do_Accounting() Invoked. ');
3155: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3156: -- print a message stating that accounting is done
3157: -- Call the procedure to Claim or Unclaim Cenvat do its accounting
3158:
3159: -- if its UNCLAIMED then amount is already uncalimed during DELIVER in do_accounting

Line 3171: Fnd_File.Put_Line(FND_FILE.LOG,' ');

3167: , pd_supp_exc_inv_date => ld_supp_exc_inv_date
3168: , pn_version_number => ln_retro_line_changes_version -- current version of the receipt
3169: , pn_line_change_id => ln_retro_line_changes_id
3170: );
3171: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3172: Fnd_File.Put_Line(FND_FILE.LOG,' Do_Cenvat_Claim() Invoked. ');
3173: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3174:
3175: --Print a message stating that the receipt cenvat is claimed or unclaimed depending on value of lv_cenvat_action

Line 3172: Fnd_File.Put_Line(FND_FILE.LOG,' Do_Cenvat_Claim() Invoked. ');

3168: , pn_version_number => ln_retro_line_changes_version -- current version of the receipt
3169: , pn_line_change_id => ln_retro_line_changes_id
3170: );
3171: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3172: Fnd_File.Put_Line(FND_FILE.LOG,' Do_Cenvat_Claim() Invoked. ');
3173: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3174:
3175: --Print a message stating that the receipt cenvat is claimed or unclaimed depending on value of lv_cenvat_action
3176: ELSE

Line 3173: Fnd_File.Put_Line(FND_FILE.LOG,' ');

3169: , pn_line_change_id => ln_retro_line_changes_id
3170: );
3171: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3172: Fnd_File.Put_Line(FND_FILE.LOG,' Do_Cenvat_Claim() Invoked. ');
3173: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3174:
3175: --Print a message stating that the receipt cenvat is claimed or unclaimed depending on value of lv_cenvat_action
3176: ELSE
3177: Fnd_File.Put_Line(FND_FILE.LOG,' Cenvat_action = '|| lv_cenvat_action);

Line 3177: Fnd_File.Put_Line(FND_FILE.LOG,' Cenvat_action = '|| lv_cenvat_action);

3173: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3174:
3175: --Print a message stating that the receipt cenvat is claimed or unclaimed depending on value of lv_cenvat_action
3176: ELSE
3177: Fnd_File.Put_Line(FND_FILE.LOG,' Cenvat_action = '|| lv_cenvat_action);
3178: Fnd_File.Put_Line(FND_FILE.LOG,' Diff Cenvat_Amount = '|| ln_diff_re_cenvat_amount);
3179: Fnd_File.Put_Line(FND_FILE.LOG,' Did not invoke DO_CENVAT_CLAIM() subroutine');
3180: END IF;--(lv_cenvat_action <> 'UNCLAIMED' AND ln_cenvat_amount <> 0 )
3181:

Line 3178: Fnd_File.Put_Line(FND_FILE.LOG,' Diff Cenvat_Amount = '|| ln_diff_re_cenvat_amount);

3174:
3175: --Print a message stating that the receipt cenvat is claimed or unclaimed depending on value of lv_cenvat_action
3176: ELSE
3177: Fnd_File.Put_Line(FND_FILE.LOG,' Cenvat_action = '|| lv_cenvat_action);
3178: Fnd_File.Put_Line(FND_FILE.LOG,' Diff Cenvat_Amount = '|| ln_diff_re_cenvat_amount);
3179: Fnd_File.Put_Line(FND_FILE.LOG,' Did not invoke DO_CENVAT_CLAIM() subroutine');
3180: END IF;--(lv_cenvat_action <> 'UNCLAIMED' AND ln_cenvat_amount <> 0 )
3181:
3182: -- Call the procedure to Claim or Unclaim VAT and do its accounting

Line 3179: Fnd_File.Put_Line(FND_FILE.LOG,' Did not invoke DO_CENVAT_CLAIM() subroutine');

3175: --Print a message stating that the receipt cenvat is claimed or unclaimed depending on value of lv_cenvat_action
3176: ELSE
3177: Fnd_File.Put_Line(FND_FILE.LOG,' Cenvat_action = '|| lv_cenvat_action);
3178: Fnd_File.Put_Line(FND_FILE.LOG,' Diff Cenvat_Amount = '|| ln_diff_re_cenvat_amount);
3179: Fnd_File.Put_Line(FND_FILE.LOG,' Did not invoke DO_CENVAT_CLAIM() subroutine');
3180: END IF;--(lv_cenvat_action <> 'UNCLAIMED' AND ln_cenvat_amount <> 0 )
3181:
3182: -- Call the procedure to Claim or Unclaim VAT and do its accounting
3183:

Line 3196: Fnd_File.Put_Line(FND_FILE.LOG,' ');

3192: pn_version_number => ln_retro_line_changes_version -- current version of the receipt
3193: , pn_line_change_id => ln_retro_line_changes_id
3194: );
3195:
3196: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3197: Fnd_File.Put_Line(FND_FILE.LOG,' Do_Vat_Claim() Invoked. ');
3198: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3199:
3200: --Print a message stating that the receipt vat is claimed or unclaimed depending on value of lv_vat_action

Line 3197: Fnd_File.Put_Line(FND_FILE.LOG,' Do_Vat_Claim() Invoked. ');

3193: , pn_line_change_id => ln_retro_line_changes_id
3194: );
3195:
3196: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3197: Fnd_File.Put_Line(FND_FILE.LOG,' Do_Vat_Claim() Invoked. ');
3198: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3199:
3200: --Print a message stating that the receipt vat is claimed or unclaimed depending on value of lv_vat_action
3201: ELSE

Line 3198: Fnd_File.Put_Line(FND_FILE.LOG,' ');

3194: );
3195:
3196: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3197: Fnd_File.Put_Line(FND_FILE.LOG,' Do_Vat_Claim() Invoked. ');
3198: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3199:
3200: --Print a message stating that the receipt vat is claimed or unclaimed depending on value of lv_vat_action
3201: ELSE
3202: Fnd_File.Put_Line(FND_FILE.LOG,' lv_vat_action = '|| lv_vat_action);

Line 3202: Fnd_File.Put_Line(FND_FILE.LOG,' lv_vat_action = '|| lv_vat_action);

3198: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3199:
3200: --Print a message stating that the receipt vat is claimed or unclaimed depending on value of lv_vat_action
3201: ELSE
3202: Fnd_File.Put_Line(FND_FILE.LOG,' lv_vat_action = '|| lv_vat_action);
3203: Fnd_File.Put_Line(FND_FILE.LOG,' Diff Vat Amount = '|| ln_diff_re_vat_amount);
3204: Fnd_File.Put_Line(FND_FILE.LOG,' Did not invoke DO_VAT_CLAIM() subroutine');
3205: END IF; --(lv_vat_action <> 'UNCLAIMED' AND ln_vat_amount <> 0)
3206:

Line 3203: Fnd_File.Put_Line(FND_FILE.LOG,' Diff Vat Amount = '|| ln_diff_re_vat_amount);

3199:
3200: --Print a message stating that the receipt vat is claimed or unclaimed depending on value of lv_vat_action
3201: ELSE
3202: Fnd_File.Put_Line(FND_FILE.LOG,' lv_vat_action = '|| lv_vat_action);
3203: Fnd_File.Put_Line(FND_FILE.LOG,' Diff Vat Amount = '|| ln_diff_re_vat_amount);
3204: Fnd_File.Put_Line(FND_FILE.LOG,' Did not invoke DO_VAT_CLAIM() subroutine');
3205: END IF; --(lv_vat_action <> 'UNCLAIMED' AND ln_vat_amount <> 0)
3206:
3207: --Increaset the total processed receipt number;

Line 3204: Fnd_File.Put_Line(FND_FILE.LOG,' Did not invoke DO_VAT_CLAIM() subroutine');

3200: --Print a message stating that the receipt vat is claimed or unclaimed depending on value of lv_vat_action
3201: ELSE
3202: Fnd_File.Put_Line(FND_FILE.LOG,' lv_vat_action = '|| lv_vat_action);
3203: Fnd_File.Put_Line(FND_FILE.LOG,' Diff Vat Amount = '|| ln_diff_re_vat_amount);
3204: Fnd_File.Put_Line(FND_FILE.LOG,' Did not invoke DO_VAT_CLAIM() subroutine');
3205: END IF; --(lv_vat_action <> 'UNCLAIMED' AND ln_vat_amount <> 0)
3206:
3207: --Increaset the total processed receipt number;
3208: ln_receipt_processed_no :=ln_receipt_processed_no+1;

Line 3211: FND_FILE.PUT_LINE(fnd_file.log, ' The Receipt :'||jai_rcv_lines_rec.receipt_num||' processing is done.');

3207: --Increaset the total processed receipt number;
3208: ln_receipt_processed_no :=ln_receipt_processed_no+1;
3209: END IF; -- IF ( jai_rcv_transactions_rec.process_vat_status IS NULL )
3210:
3211: FND_FILE.PUT_LINE(fnd_file.log, ' The Receipt :'||jai_rcv_lines_rec.receipt_num||' processing is done.');
3212: FND_FILE.PUT_LINE(fnd_file.log, ' End loop through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
3213: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
3214: END LOOP; --rcv_transactions_rec IN get_rcv_transactions_cur
3215:

Line 3212: FND_FILE.PUT_LINE(fnd_file.log, ' End loop through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);

3208: ln_receipt_processed_no :=ln_receipt_processed_no+1;
3209: END IF; -- IF ( jai_rcv_transactions_rec.process_vat_status IS NULL )
3210:
3211: FND_FILE.PUT_LINE(fnd_file.log, ' The Receipt :'||jai_rcv_lines_rec.receipt_num||' processing is done.');
3212: FND_FILE.PUT_LINE(fnd_file.log, ' End loop through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
3213: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
3214: END LOOP; --rcv_transactions_rec IN get_rcv_transactions_cur
3215:
3216: IF (ln_skip_rcpt_cnt =0)

Line 3213: FND_FILE.PUT_LINE(fnd_file.log, ' ++');

3209: END IF; -- IF ( jai_rcv_transactions_rec.process_vat_status IS NULL )
3210:
3211: FND_FILE.PUT_LINE(fnd_file.log, ' The Receipt :'||jai_rcv_lines_rec.receipt_num||' processing is done.');
3212: FND_FILE.PUT_LINE(fnd_file.log, ' End loop through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
3213: FND_FILE.PUT_LINE(fnd_file.log, ' ++');
3214: END LOOP; --rcv_transactions_rec IN get_rcv_transactions_cur
3215:
3216: IF (ln_skip_rcpt_cnt =0)
3217: THEN

Line 3229: FND_FILE.PUT_LINE(fnd_file.log, 'Total receipt number for current shipment is: '||ln_tot_receipt_no);

3225:
3226: --increase the number of total receipt processed
3227: ln_tot_receipt_processed_no := ln_tot_receipt_processed_no + ln_receipt_processed_no ;
3228:
3229: FND_FILE.PUT_LINE(fnd_file.log, 'Total receipt number for current shipment is: '||ln_tot_receipt_no);
3230: FND_FILE.PUT_LINE(fnd_file.log, 'Total processed receipt for current shipment number is: '||ln_receipt_processed_no);
3231: FND_FILE.PUT_LINE(fnd_file.log, 'End loop for the shipment line, line_change_id ='||jai_retro_line_change_rec.line_change_id );
3232: FND_FILE.PUT_LINE(fnd_file.log, '++++');
3233: END LOOP;--jai_retro_line_change_rec IN get_jai_retro_line_change_cur

Line 3230: FND_FILE.PUT_LINE(fnd_file.log, 'Total processed receipt for current shipment number is: '||ln_receipt_processed_no);

3226: --increase the number of total receipt processed
3227: ln_tot_receipt_processed_no := ln_tot_receipt_processed_no + ln_receipt_processed_no ;
3228:
3229: FND_FILE.PUT_LINE(fnd_file.log, 'Total receipt number for current shipment is: '||ln_tot_receipt_no);
3230: FND_FILE.PUT_LINE(fnd_file.log, 'Total processed receipt for current shipment number is: '||ln_receipt_processed_no);
3231: FND_FILE.PUT_LINE(fnd_file.log, 'End loop for the shipment line, line_change_id ='||jai_retro_line_change_rec.line_change_id );
3232: FND_FILE.PUT_LINE(fnd_file.log, '++++');
3233: END LOOP;--jai_retro_line_change_rec IN get_jai_retro_line_change_cur
3234:

Line 3231: FND_FILE.PUT_LINE(fnd_file.log, 'End loop for the shipment line, line_change_id ='||jai_retro_line_change_rec.line_change_id );

3227: ln_tot_receipt_processed_no := ln_tot_receipt_processed_no + ln_receipt_processed_no ;
3228:
3229: FND_FILE.PUT_LINE(fnd_file.log, 'Total receipt number for current shipment is: '||ln_tot_receipt_no);
3230: FND_FILE.PUT_LINE(fnd_file.log, 'Total processed receipt for current shipment number is: '||ln_receipt_processed_no);
3231: FND_FILE.PUT_LINE(fnd_file.log, 'End loop for the shipment line, line_change_id ='||jai_retro_line_change_rec.line_change_id );
3232: FND_FILE.PUT_LINE(fnd_file.log, '++++');
3233: END LOOP;--jai_retro_line_change_rec IN get_jai_retro_line_change_cur
3234:
3235: IF ( ln_skip_rcpt_cnt IS NULL OR ln_tot_receipt_processed_no = 0)

Line 3232: FND_FILE.PUT_LINE(fnd_file.log, '++++');

3228:
3229: FND_FILE.PUT_LINE(fnd_file.log, 'Total receipt number for current shipment is: '||ln_tot_receipt_no);
3230: FND_FILE.PUT_LINE(fnd_file.log, 'Total processed receipt for current shipment number is: '||ln_receipt_processed_no);
3231: FND_FILE.PUT_LINE(fnd_file.log, 'End loop for the shipment line, line_change_id ='||jai_retro_line_change_rec.line_change_id );
3232: FND_FILE.PUT_LINE(fnd_file.log, '++++');
3233: END LOOP;--jai_retro_line_change_rec IN get_jai_retro_line_change_cur
3234:
3235: IF ( ln_skip_rcpt_cnt IS NULL OR ln_tot_receipt_processed_no = 0)
3236: THEN

Line 3237: Fnd_File.Put_Line(FND_FILE.LOG,' ');

3233: END LOOP;--jai_retro_line_change_rec IN get_jai_retro_line_change_cur
3234:
3235: IF ( ln_skip_rcpt_cnt IS NULL OR ln_tot_receipt_processed_no = 0)
3236: THEN
3237: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3238: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3239: Fnd_File.Put_Line(FND_FILE.LOG,'No valid data found for processing');
3240: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3241: Fnd_File.Put_Line(FND_FILE.LOG,' ');

Line 3238: Fnd_File.Put_Line(FND_FILE.LOG,' ');

3234:
3235: IF ( ln_skip_rcpt_cnt IS NULL OR ln_tot_receipt_processed_no = 0)
3236: THEN
3237: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3238: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3239: Fnd_File.Put_Line(FND_FILE.LOG,'No valid data found for processing');
3240: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3241: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3242: END IF ;

Line 3239: Fnd_File.Put_Line(FND_FILE.LOG,'No valid data found for processing');

3235: IF ( ln_skip_rcpt_cnt IS NULL OR ln_tot_receipt_processed_no = 0)
3236: THEN
3237: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3238: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3239: Fnd_File.Put_Line(FND_FILE.LOG,'No valid data found for processing');
3240: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3241: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3242: END IF ;
3243: --logging for debug

Line 3240: Fnd_File.Put_Line(FND_FILE.LOG,' ');

3236: THEN
3237: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3238: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3239: Fnd_File.Put_Line(FND_FILE.LOG,'No valid data found for processing');
3240: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3241: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3242: END IF ;
3243: --logging for debug
3244: IF (ln_proc_level >= ln_dbg_level)

Line 3241: Fnd_File.Put_Line(FND_FILE.LOG,' ');

3237: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3238: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3239: Fnd_File.Put_Line(FND_FILE.LOG,'No valid data found for processing');
3240: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3241: Fnd_File.Put_Line(FND_FILE.LOG,' ');
3242: END IF ;
3243: --logging for debug
3244: IF (ln_proc_level >= ln_dbg_level)
3245: THEN