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

Line 869: FND_FILE.put_line(FND_FILE.log, '^Trx Post Processor');

865:
866: BEGIN
867:
868:
869: FND_FILE.put_line(FND_FILE.log, '^Trx Post Processor');
870:
871: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'receipt_transactions_pkg.trx_post_proc', 'START');
872:
873: OPEN c_trx(p_transaction_id);

Line 877: FND_FILE.put_line(FND_FILE.log, '1. Inside ^Trx Post Processor');

873: OPEN c_trx(p_transaction_id);
874: FETCH c_trx INTO r_trx;
875: CLOSE c_trx;
876:
877: FND_FILE.put_line(FND_FILE.log, '1. Inside ^Trx Post Processor');
878:
879: IF r_trx.transaction_type IN ('RECEIVE','MATCH') THEN
880:
881: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath);

Line 892: FND_FILE.put_line(FND_FILE.log, '2. updating JAI_RCV_CENVAT_CLAIMS cenvat amounts');

888: ln_cenvat_amount := 0;
889: ln_cenvat_claimed_ptg := 0;
890: END IF;
891:
892: FND_FILE.put_line(FND_FILE.log, '2. updating JAI_RCV_CENVAT_CLAIMS cenvat amounts');
893:
894: UPDATE JAI_RCV_CENVAT_CLAIMS
895: SET cenvat_amount = nvl(ln_cenvat_amount, cenvat_amount),
896: other_cenvat_amt = nvl(ln_cenvat_amount, other_cenvat_amt),

Line 924: FND_FILE.put_line(FND_FILE.log, '3. before updating JAI_RCV_CENVAT_CLAIMS');

920: end if;
921: */
922: end if;
923:
924: FND_FILE.put_line(FND_FILE.log, '3. before updating JAI_RCV_CENVAT_CLAIMS');
925:
926: --Uncommented and added for bug #14308585
927: IF r_trx.transaction_type = 'DELIVER' THEN
928:

Line 929: FND_FILE.put_line(FND_FILE.log, '4. updating JAI_RCV_CENVAT_CLAIMS, r_trx.loc_subinv_type : '||r_trx.loc_subinv_type);

925:
926: --Uncommented and added for bug #14308585
927: IF r_trx.transaction_type = 'DELIVER' THEN
928:
929: FND_FILE.put_line(FND_FILE.log, '4. updating JAI_RCV_CENVAT_CLAIMS, r_trx.loc_subinv_type : '||r_trx.loc_subinv_type);
930: -- meaning non bonded
931: IF r_trx.loc_subinv_type = 'N' THEN
932:
933: FND_FILE.put_line(FND_FILE.log, '5. updating JAI_RCV_CENVAT_CLAIMS for shipment line : '||r_trx.shipment_line_id);

Line 933: FND_FILE.put_line(FND_FILE.log, '5. updating JAI_RCV_CENVAT_CLAIMS for shipment line : '||r_trx.shipment_line_id);

929: FND_FILE.put_line(FND_FILE.log, '4. updating JAI_RCV_CENVAT_CLAIMS, r_trx.loc_subinv_type : '||r_trx.loc_subinv_type);
930: -- meaning non bonded
931: IF r_trx.loc_subinv_type = 'N' THEN
932:
933: FND_FILE.put_line(FND_FILE.log, '5. updating JAI_RCV_CENVAT_CLAIMS for shipment line : '||r_trx.shipment_line_id);
934:
935: UPDATE JAI_RCV_CENVAT_CLAIMS
936: SET non_bonded_delivery_flag = 'Y',
937: cenvat_claimed_ptg = 100,

Line 997: fnd_file.put_line(FND_FILE.LOG, 'Check_57F4_transaction->57F4 challan doesnot exist ' );

993: OPEN c_check_57F4_for_po;
994: FETCH c_check_57F4_for_po INTO ln_line_id;
995: IF c_check_57F4_for_po%NOTFOUND THEN
996: ln_ret_value := 'NO';
997: fnd_file.put_line(FND_FILE.LOG, 'Check_57F4_transaction->57F4 challan doesnot exist ' );
998: ELSE
999: ln_ret_value := 'YES';
1000: fnd_file.put_line(FND_FILE.LOG, 'Check_57F4_transaction->57F4 challan exists ' );
1001: END IF ;

Line 1000: fnd_file.put_line(FND_FILE.LOG, 'Check_57F4_transaction->57F4 challan exists ' );

996: ln_ret_value := 'NO';
997: fnd_file.put_line(FND_FILE.LOG, 'Check_57F4_transaction->57F4 challan doesnot exist ' );
998: ELSE
999: ln_ret_value := 'YES';
1000: fnd_file.put_line(FND_FILE.LOG, 'Check_57F4_transaction->57F4 challan exists ' );
1001: END IF ;
1002: CLOSE c_check_57F4_for_po;
1003: RETURN ln_ret_value;
1004: END check_57f4_transaction;

Line 1123: FND_FILE.put_line(FND_FILE.log, 'trx_id:'||temp_rec.transaction_id||', flag:'||temp_rec.process_flag);

1119:
1120: SAVEPOINT start_deferred_claim;
1121:
1122: IF lb_debug THEN
1123: FND_FILE.put_line(FND_FILE.log, 'trx_id:'||temp_rec.transaction_id||', flag:'||temp_rec.process_flag);
1124: END IF;
1125:
1126: IF temp_rec.process_flag = 'M' THEN
1127:

Line 1205: FND_FILE.put_line(FND_FILE.log, '*** Common Error for Transaction_id:'||r_trx.transaction_id

1201: -- flag value 'X' is removed from the following ELSIF conditions because it is not an ERROR Status. MYXZ
1202: IF lv_common_err_mesg IS NOT NULL THEN
1203: -- A common error occured. So, Whole Processing for Transaction should be stopped
1204: ROLLBACK TO start_deferred_claim;
1205: FND_FILE.put_line(FND_FILE.log, '*** Common Error for Transaction_id:'||r_trx.transaction_id
1206: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- Error:'||lv_common_err_mesg
1207: );
1208: lv_codepath := jai_general_pkg.plot_codepath(11, lv_codepath);
1209:

Line 1212: FND_FILE.put_line(FND_FILE.log, '* FLAGS ERROR * Transaction_id:'||r_trx.transaction_id

1208: lv_codepath := jai_general_pkg.plot_codepath(11, lv_codepath);
1209:
1210: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
1211: lv_codepath := jai_general_pkg.plot_codepath(12, lv_codepath);
1212: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||r_trx.transaction_id
1213: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
1214: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
1215: );
1216: /*dbms_output.put_line( '*** FLAGS ERROR *** Transaction_id:'||r_trx.transaction_id

Line 1222: FND_FILE.put_line(FND_FILE.log, '* PROCESS ERROR * Transaction_id:'||r_trx.transaction_id

1218: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message );
1219: */
1220: ELSIF lv_process_flag IN ('E') THEN
1221: lv_codepath := jai_general_pkg.plot_codepath(13, lv_codepath);
1222: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||r_trx.transaction_id
1223: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message
1224: );
1225: /*dbms_output.put_line('*** PROCESS ERROR *** Transaction_id:'||r_trx.transaction_id
1226: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message );

Line 1230: FND_FILE.put_line(FND_FILE.log, '* CENVAT ERROR * Transaction_id:'||r_trx.transaction_id

1226: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message );
1227: */
1228: ELSIF lv_cenvat_rg_flag IN ('E') THEN
1229: lv_codepath := jai_general_pkg.plot_codepath(14, lv_codepath);
1230: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||r_trx.transaction_id
1231: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message
1232: );
1233: /*dbms_output.put_line('*** CENVAT ERROR *** Transaction_id:'||r_trx.transaction_id
1234: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message

Line 1240: FND_FILE.put_line(FND_FILE.log, ' Transaction Cant be processed for trx:'||r_trx.transaction_id

1236: END IF;
1237:
1238: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN
1239: lv_codepath := jai_general_pkg.plot_codepath(15, lv_codepath);
1240: FND_FILE.put_line(FND_FILE.log, ' Transaction Cant be processed for trx:'||r_trx.transaction_id
1241: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
1242: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
1243: );
1244: /*dbms_output.put_line('M: Err2: Transaction Cant be processed for trx:'||r_trx.transaction_id

Line 1250: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);

1246: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message);
1247: */
1248: ELSIF lv_process_flag IN ('X') THEN
1249: lv_codepath := jai_general_pkg.plot_codepath(16, lv_codepath);
1250: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);
1251: /*dbms_output.put_line('M: Err4:'||lv_process_message);*/
1252: ELSIF lv_cenvat_rg_flag IN ('X') THEN
1253: lv_codepath := jai_general_pkg.plot_codepath(17, lv_codepath);
1254: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);

Line 1254: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);

1250: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);
1251: /*dbms_output.put_line('M: Err4:'||lv_process_message);*/
1252: ELSIF lv_cenvat_rg_flag IN ('X') THEN
1253: lv_codepath := jai_general_pkg.plot_codepath(17, lv_codepath);
1254: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);
1255: /*dbms_output.put_line('M: Err3:'||lv_cenvat_rg_message);*/
1256: END IF;
1257:
1258: IF lv_process_flag = 'E' OR lv_cenvat_rg_flag = 'E' THEN

Line 1262: fnd_file.put_line(fnd_file.log, 'M: Err5:'||p_process_message);

1258: IF lv_process_flag = 'E' OR lv_cenvat_rg_flag = 'E' THEN
1259: lv_codepath := jai_general_pkg.plot_codepath(18, lv_codepath);
1260: p_process_flag := lv_cenvat_rg_flag;
1261: p_process_message := lv_cenvat_rg_message;
1262: fnd_file.put_line(fnd_file.log, 'M: Err5:'||p_process_message);
1263: END IF;
1264:
1265: -- UNCLAIM PROCESSING
1266: -- following Unclaim Processing will not happen for

Line 1296: FND_FILE.put_line(FND_FILE.log, 'Unclaim before jai_rcv_trx_processing_pkg.get_ancestor_id loop_trx.transaction_id '||loop_trx.transaction_id

1292: );
1293:
1294: --start additions by vkaranam for bug#12817175
1295:
1296: FND_FILE.put_line(FND_FILE.log, 'Unclaim before jai_rcv_trx_processing_pkg.get_ancestor_id loop_trx.transaction_id '||loop_trx.transaction_id
1297: ||' r_trx.shipment_line_id '||r_trx.shipment_line_id);
1298: ln_dlry_trx_id := jai_rcv_trx_processing_pkg.get_ancestor_id
1299: (
1300: loop_trx.transaction_id,

Line 1305: FND_FILE.put_line(FND_FILE.log, 'Unclaim after jai_rcv_trx_processing_pkg.get_ancestor_id ln_dlry_trx_id '||ln_dlry_trx_id);

1301: r_trx.shipment_line_id,
1302: 'DELIVER'
1303: );
1304:
1305: FND_FILE.put_line(FND_FILE.log, 'Unclaim after jai_rcv_trx_processing_pkg.get_ancestor_id ln_dlry_trx_id '||ln_dlry_trx_id);
1306: open c_trx(ln_dlry_trx_id);
1307: fetch c_trx into r_dlry_trx;
1308: close c_trx;
1309: FND_FILE.put_line(FND_FILE.log, 'Unclaim r_dlry_trx.attribute1 '||r_dlry_trx.attribute1);

Line 1309: FND_FILE.put_line(FND_FILE.log, 'Unclaim r_dlry_trx.attribute1 '||r_dlry_trx.attribute1);

1305: FND_FILE.put_line(FND_FILE.log, 'Unclaim after jai_rcv_trx_processing_pkg.get_ancestor_id ln_dlry_trx_id '||ln_dlry_trx_id);
1306: open c_trx(ln_dlry_trx_id);
1307: fetch c_trx into r_dlry_trx;
1308: close c_trx;
1309: FND_FILE.put_line(FND_FILE.log, 'Unclaim r_dlry_trx.attribute1 '||r_dlry_trx.attribute1);
1310: /*if the receipt is delivered then the attribute_1 will be 'CENVAT_COSTED_FLAG',
1311: --unclaim accounting shall happen based on the below conditions
1312: Case 1:
1313: Event 1:receive

Line 1346: fnd_file.put_line(fnd_file.log,'unclaim lv_include_cenvat_in_costing '||lv_include_cenvat_in_costing);

1342: p_process_status => lv_process_flag,
1343: p_codepath => lv_codepath
1344: );
1345:
1346: fnd_file.put_line(fnd_file.log,'unclaim lv_include_cenvat_in_costing '||lv_include_cenvat_in_costing);
1347:
1348: if nvl(lv_include_cenvat_in_costing,'N')='Y' and nvl(r_tax.non_cenvat,0)<0 and ln_dlry_trx_id is not null
1349: /*item delivered and is delivered to non bonded subinventory then the inclusive amt is not considered in the accounting*/
1350:

Line 1356: fnd_file.put_line(fnd_file.log,'unclaim lv_include_cenvat_in_costing '||lv_include_cenvat_in_costing);

1352: ln_inclusive_amt:= nvl(r_tax.non_cenvat,0);
1353: else
1354: ln_inclusive_amt:=0;
1355: end if;
1356: fnd_file.put_line(fnd_file.log,'unclaim lv_include_cenvat_in_costing '||lv_include_cenvat_in_costing);
1357: --end additions by vkaranam for bug#12817175
1358:
1359:
1360:

Line 1396: FND_FILE.put_line(FND_FILE.log, 'Unclaim PRC_FLG_Error: RollingBack to process_trxn_flag');

1392: );
1393:
1394: IF p_process_flag IN ('E', 'X') THEN
1395: lv_codepath := jai_general_pkg.plot_codepath(23, lv_codepath);
1396: FND_FILE.put_line(FND_FILE.log, 'Unclaim PRC_FLG_Error: RollingBack to process_trxn_flag');
1397: /*dbms_output.put_line('Unclaim PRC_FLG_Error: RollingBack to process_trxn_flag');*/
1398: --p_codepath := jai_general_pkg.plot_codepath(6, p_codepath);
1399: ROLLBACK TO start_unclaim;
1400: -- following is to take care that if one transaction of RECEIVE childs fail, then loop should not

Line 1407: FND_FILE.put_line(FND_FILE.log, 'Unclaim#PRC_FLG#'||p_process_flag);

1403: ElSIF p_process_flag = 'Y' THEN
1404: --p_codepath := jai_general_pkg.plot_codepath(7, p_codepath);
1405: p_process_message := 'Successful';
1406: ELSE
1407: FND_FILE.put_line(FND_FILE.log, 'Unclaim#PRC_FLG#'||p_process_flag);
1408: --p_codepath := jai_general_pkg.plot_codepath(8, p_codepath);
1409: /*dbms_output.put_line('Unclaim#PRC_FLG#'||p_process_flag);*/
1410: END IF;
1411:

Line 1547: fnd_file.put_line(fnd_file.log, 'Trx_id:'||temp_rec.transaction_id||'. Codepath:'||lv_codepath);

1543:
1544: END IF;
1545:
1546: lv_codepath := jai_general_pkg.plot_codepath(30, lv_codepath);
1547: fnd_file.put_line(fnd_file.log, 'Trx_id:'||temp_rec.transaction_id||'. Codepath:'||lv_codepath);
1548: /*dbms_output.put_line('Trx_id:'||temp_rec.transaction_id||'. Codepath:'||lv_codepath);*/
1549:
1550: END LOOP;
1551:

Line 1555: fnd_file.put_line(fnd_file.log, 'DeferredClaimError Cnt>0:'||p_process_message);

1551:
1552: IF ln_errored_cnt > 0 THEN
1553: p_process_flag := jai_constants.unexpected_error;
1554: p_process_message := 'Errored Record Count:'||ln_errored_cnt;
1555: fnd_file.put_line(fnd_file.log, 'DeferredClaimError Cnt>0:'||p_process_message);
1556: END IF;
1557:
1558: EXCEPTION
1559: WHEN OTHERS THEN

Line 1562: fnd_file.put_line(fnd_file.log, 'ErrorCodepath:'||lv_codepath);

1558: EXCEPTION
1559: WHEN OTHERS THEN
1560: ROLLBACK TO start_deferred_claim;
1561: p_process_flag := 'E';
1562: fnd_file.put_line(fnd_file.log, 'ErrorCodepath:'||lv_codepath);
1563: p_process_message := 'Processed Count:'||ln_processed_cnt||', Errored Cnt:'||ln_errored_cnt||'. Error Message:'||SQLERRM;
1564: fnd_file.put_line(fnd_file.log, 'DeferredClaimError6:'||p_process_message);
1565: END process_deferred_cenvat_claim;
1566:

Line 1564: fnd_file.put_line(fnd_file.log, 'DeferredClaimError6:'||p_process_message);

1560: ROLLBACK TO start_deferred_claim;
1561: p_process_flag := 'E';
1562: fnd_file.put_line(fnd_file.log, 'ErrorCodepath:'||lv_codepath);
1563: p_process_message := 'Processed Count:'||ln_processed_cnt||', Errored Cnt:'||ln_errored_cnt||'. Error Message:'||SQLERRM;
1564: fnd_file.put_line(fnd_file.log, 'DeferredClaimError6:'||p_process_message);
1565: END process_deferred_cenvat_claim;
1566:
1567:
1568: /*============================== MAIN PROCEDURE ==============================*/

Line 2060: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||

2056: dev_status => lv_dev_status,
2057: message => lv_message) ;
2058:
2059: IF not ln_req_status THEN
2060: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
2061: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
2062: FND_FILE.put_line(FND_FILE.log, 'Problem in Completion of Receiving Transaction Processor - Request Id ' || p_request_id || '. Exiting from India - Receicing Transaction Processor ');
2063: RETURN ;
2064: END IF ;

Line 2062: FND_FILE.put_line(FND_FILE.log, 'Problem in Completion of Receiving Transaction Processor - Request Id ' || p_request_id || '. Exiting from India - Receicing Transaction Processor ');

2058:
2059: IF not ln_req_status THEN
2060: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
2061: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
2062: FND_FILE.put_line(FND_FILE.log, 'Problem in Completion of Receiving Transaction Processor - Request Id ' || p_request_id || '. Exiting from India - Receicing Transaction Processor ');
2063: RETURN ;
2064: END IF ;
2065: END IF ;
2066:

Line 2069: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||

2065: END IF ;
2066:
2067: EXCEPTION
2068: WHEN OTHERS THEN
2069: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
2070: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
2071: FND_FILE.put_line(FND_FILE.log, 'Error in the Call to The fnd_concurrent.wait_for_request for Request Id ' || p_request_id || '. Returning... ');
2072: RETURN ;
2073: END;

Line 2071: FND_FILE.put_line(FND_FILE.log, 'Error in the Call to The fnd_concurrent.wait_for_request for Request Id ' || p_request_id || '. Returning... ');

2067: EXCEPTION
2068: WHEN OTHERS THEN
2069: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
2070: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
2071: FND_FILE.put_line(FND_FILE.log, 'Error in the Call to The fnd_concurrent.wait_for_request for Request Id ' || p_request_id || '. Returning... ');
2072: RETURN ;
2073: END;
2074:
2075:

Line 2097: FND_FILE.put_line(FND_FILE.log, SQLERRM) ;

2093: END LOOP ;
2094: END IF ;
2095: EXCEPTION
2096: WHEN OTHERS THEN
2097: FND_FILE.put_line(FND_FILE.log, SQLERRM) ;
2098: RETURN ;
2099: END;
2100:
2101: --ended, CSahoo for Bug 5344225

Line 2103: FND_FILE.put_line( FND_FILE.log, 'Start of Batch. Date:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss') );

2099: END;
2100:
2101: --ended, CSahoo for Bug 5344225
2102:
2103: FND_FILE.put_line( FND_FILE.log, 'Start of Batch. Date:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss') );
2104:
2105: lv_request_id := FND_PROFILE.value('CONC_REQUEST_ID');
2106: FND_FILE.put_line( FND_FILE.log, 'Inputs. OrgnId:'||nvl(p_organization_id,-1)
2107: ||', TrxFrom->'||nvl(p_transaction_from, to_date('1-01-1700', 'dd-mm-yyyy'))

Line 2106: FND_FILE.put_line( FND_FILE.log, 'Inputs. OrgnId:'||nvl(p_organization_id,-1)

2102:
2103: FND_FILE.put_line( FND_FILE.log, 'Start of Batch. Date:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss') );
2104:
2105: lv_request_id := FND_PROFILE.value('CONC_REQUEST_ID');
2106: FND_FILE.put_line( FND_FILE.log, 'Inputs. OrgnId:'||nvl(p_organization_id,-1)
2107: ||', TrxFrom->'||nvl(p_transaction_from, to_date('1-01-1700', 'dd-mm-yyyy'))
2108: ||', Trxto->'||nvl(p_transaction_to, to_date('1-01-1700', 'dd-mm-yyyy'))
2109: ||', TrxType->'||nvl(p_transaction_type, 'XXX')
2110: ||', RecptNum->'||nvl(p_receipt_num, 'ABCD')

Line 2133: FND_FILE.put_line(FND_FILE.log, 'TraceFile Name = '||lower(lv_dbname)||'_ora_'||lv_spid||'.trc');

2129: OPEN c_get_dbname;
2130: FETCH c_get_dbname INTO lv_dbname;
2131: CLOSE c_get_dbname;
2132:
2133: FND_FILE.put_line(FND_FILE.log, 'TraceFile Name = '||lower(lv_dbname)||'_ora_'||lv_spid||'.trc');
2134:
2135: EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ''10046 trace name context forever, level 4''';
2136:
2137: END IF;

Line 2140: FND_FILE.put_line(FND_FILE.log, '%%%Problem in Trace Generation%%%');

2136:
2137: END IF;
2138: EXCEPTION
2139: WHEN OTHERS THEN
2140: FND_FILE.put_line(FND_FILE.log, '%%%Problem in Trace Generation%%%');
2141: END;
2142:
2143: /*----------------------------- START of Business Logic ----------------------*/
2144:

Line 2153: FND_FILE.put_line( FND_FILE.log, '~ Start of Deferred Claim ~. Batch:'||ln_batch_id);

2149:
2150: -- value contained in p_shipment_header_id when called from JAINMVAT is batch_id of Claim/Unclaim
2151: ln_batch_id := p_shipment_header_id;
2152:
2153: FND_FILE.put_line( FND_FILE.log, '~~~~~ Start of Deferred Claim ~~~~~. Batch:'||ln_batch_id);
2154: process_deferred_cenvat_claim(
2155: p_batch_id => ln_batch_id,
2156: p_called_from => p_called_from,
2157: p_simulate_flag => p_simulate_flag,

Line 2162: FND_FILE.put_line( FND_FILE.log, '~ End of Deferred Claim ~');

2158: p_process_flag => lv_process_flag,
2159: p_process_message => lv_process_message
2160: );
2161:
2162: FND_FILE.put_line( FND_FILE.log, '~~~~~ End of Deferred Claim ~~~~~');
2163: IF lv_process_flag IN (jai_constants.unexpected_error, jai_constants.expected_error) THEN
2164: FND_FILE.put_line(fnd_file.log, 'PROCESS_DEFERRED_CENVAT_CLAIM. Err Message - '||lv_process_message);
2165: FND_FILE.put_line(fnd_file.log, 'For details, Please refer to JAI_RCV_CENVAT_CLAIMS table with batch_id = '||ln_batch_id);
2166: retcode := jai_constants.request_warning;

Line 2164: FND_FILE.put_line(fnd_file.log, 'PROCESS_DEFERRED_CENVAT_CLAIM. Err Message - '||lv_process_message);

2160: );
2161:
2162: FND_FILE.put_line( FND_FILE.log, '~~~~~ End of Deferred Claim ~~~~~');
2163: IF lv_process_flag IN (jai_constants.unexpected_error, jai_constants.expected_error) THEN
2164: FND_FILE.put_line(fnd_file.log, 'PROCESS_DEFERRED_CENVAT_CLAIM. Err Message - '||lv_process_message);
2165: FND_FILE.put_line(fnd_file.log, 'For details, Please refer to JAI_RCV_CENVAT_CLAIMS table with batch_id = '||ln_batch_id);
2166: retcode := jai_constants.request_warning;
2167: END IF;
2168:

Line 2165: FND_FILE.put_line(fnd_file.log, 'For details, Please refer to JAI_RCV_CENVAT_CLAIMS table with batch_id = '||ln_batch_id);

2161:
2162: FND_FILE.put_line( FND_FILE.log, '~~~~~ End of Deferred Claim ~~~~~');
2163: IF lv_process_flag IN (jai_constants.unexpected_error, jai_constants.expected_error) THEN
2164: FND_FILE.put_line(fnd_file.log, 'PROCESS_DEFERRED_CENVAT_CLAIM. Err Message - '||lv_process_message);
2165: FND_FILE.put_line(fnd_file.log, 'For details, Please refer to JAI_RCV_CENVAT_CLAIMS table with batch_id = '||ln_batch_id);
2166: retcode := jai_constants.request_warning;
2167: END IF;
2168:
2169: GOTO end_of_batch;

Line 2176: FND_file.put_line(fnd_file.log, 'Error Message:'||SQLERRM);

2172:
2173: EXCEPTION
2174: WHEN OTHERS THEN
2175: ROLLBACK;
2176: FND_file.put_line(fnd_file.log, 'Error Message:'||SQLERRM);
2177: /*dbms_output.put_line('MainProc-DeferredClaim:Err:'||SQLERRM);*/
2178: retcode := jai_constants.request_error;
2179: RETURN;
2180: END;

Line 2186: FND_FILE.put_line( FND_FILE.log, 'p_called_from:'||p_called_from);

2182:
2183: -- Start, Vijay Shankar for Bug#3940588
2184: -- Following has to be executed as and when it is submitted from Receipts Localization form
2185: jai_cmn_utils_pkg.print_log('tax_mod.log','In transaction processing p_called_from:'||p_called_from);
2186: FND_FILE.put_line( FND_FILE.log, 'p_called_from:'||p_called_from);
2187:
2188: IF p_called_from = 'JAINPORE' THEN
2189: FND_FILE.put_line( FND_FILE.log, '~~~~~ Updating JAI_RCV_LINES.tax_modified_flag to N ~~~~~');
2190:

Line 2189: FND_FILE.put_line( FND_FILE.log, '~ Updating JAI_RCV_LINES.tax_modified_flag to N ~');

2185: jai_cmn_utils_pkg.print_log('tax_mod.log','In transaction processing p_called_from:'||p_called_from);
2186: FND_FILE.put_line( FND_FILE.log, 'p_called_from:'||p_called_from);
2187:
2188: IF p_called_from = 'JAINPORE' THEN
2189: FND_FILE.put_line( FND_FILE.log, '~~~~~ Updating JAI_RCV_LINES.tax_modified_flag to N ~~~~~');
2190:
2191: UPDATE JAI_RCV_LINES a
2192: SET tax_modified_flag = 'N',
2193: last_update_date = SYSDATE,

Line 2210: FND_FILE.put_line( FND_FILE.log, '~ Start Populate Details ~');

2206: END IF;
2207: -- End, Vijay Shankar for Bug#3940588
2208:
2209:
2210: FND_FILE.put_line( FND_FILE.log, '~~~~~ Start Populate Details ~~~~~');
2211: -- populate_details should be called only once and that too when the trxn is processed for the first time
2212:
2213: ja_in_populate_details ; -- added by Sanjikum for bug#4929410
2214:

Line 2222: FND_FILE.put_line( FND_FILE.log, 'Recpt:'||trx.receipt_num||', TrxId:'||trx.transaction_id);

2218: BEGIN -- Added by nprashar for bug # 13880102
2219: SAVEPOINT start_trx_population; /*Uncommented by nprashar for bug # 13880102 */
2220: lv_codepath := '';
2221:
2222: FND_FILE.put_line( FND_FILE.log, 'Recpt:'||trx.receipt_num||', TrxId:'||trx.transaction_id);
2223: populate_details(
2224: p_transaction_id => trx.transaction_id,
2225: p_process_status => lv_process_flag,
2226: p_process_message => lv_process_message,

Line 2280: FND_FILE.put_line( FND_FILE.log, '* List of Transactions whose processing is skipped due to the below errors *');

2276:
2277: END LOOP;
2278: IF process_msg_tab.COUNT > 0 THEN
2279:
2280: FND_FILE.put_line( FND_FILE.log, '*** List of Transactions whose processing is skipped due to the below errors ***');
2281:
2282: FOR err_trx in process_msg_tab.FIRST..process_msg_tab.LAST
2283: LOOP
2284: FND_FILE.put_line( FND_FILE.log,process_msg_tab(err_trx));

Line 2284: FND_FILE.put_line( FND_FILE.log,process_msg_tab(err_trx));

2280: FND_FILE.put_line( FND_FILE.log, '*** List of Transactions whose processing is skipped due to the below errors ***');
2281:
2282: FOR err_trx in process_msg_tab.FIRST..process_msg_tab.LAST
2283: LOOP
2284: FND_FILE.put_line( FND_FILE.log,process_msg_tab(err_trx));
2285: END LOOP;
2286:
2287: END IF;
2288: --Addtions ends here for bug # 13880102

Line 2294: FND_FILE.put_line( FND_FILE.log, '* POPULATE_DETAILS Error *:'||lv_process_message);

2290: -- IF UPPER(p_called_from) <> 'APPLICATION' THEN
2291: --Commented by nprashar for bug # 13880102
2292: /*IF lv_process_flag = 'E' THEN
2293: ROLLBACK;
2294: FND_FILE.put_line( FND_FILE.log, '*** POPULATE_DETAILS Error ***:'||lv_process_message);
2295: errbuf := lv_process_message;
2296: retcode := jai_constants.request_error;
2297: RETURN;
2298: ELSIF p_commit_switch = 'Y' THEN

Line 2318: FND_FILE.put_line(FND_FILE.log, '+++ Start of ReceiptNo, Transaction_id:'||trx.receipt_num||','||trx.transaction_id

2314: lv_common_err_mesg := null;
2315: lv_codepath := '';
2316: r_trx_after_processing := null;
2317:
2318: FND_FILE.put_line(FND_FILE.log, '+++ Start of ReceiptNo, Transaction_id:'||trx.receipt_num||','||trx.transaction_id
2319: ||', trxn_type:'||trx.transaction_type
2320: ||', parent_trxn_type:'||trx.parent_transaction_type
2321: ||', process_status:'||trx.process_flag
2322: ||', cenvat_rg_status:'||trx.cenvat_rg_flag

Line 2368: FND_FILE.put_line(FND_FILE.log, '*** Common Error for Transaction_id:'||trx.transaction_id

2364: -- 'X' flag is removed from the following ELSIF conditions because it is not an ERROR Status. MYXZ
2365: IF lv_common_err_mesg IS NOT NULL THEN
2366: -- A common error occured. So, Whole Processing for Transaction should be stopped
2367: ROLLBACK TO process_trxn;
2368: FND_FILE.put_line(FND_FILE.log, '*** Common Error for Transaction_id:'||trx.transaction_id
2369: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- Error:'||lv_common_err_mesg
2370: );
2371: retcode := 1;
2372: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN

Line 2373: FND_FILE.put_line(FND_FILE.log, '* FLAGS ERROR * Transaction_id:'||trx.transaction_id

2369: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- Error:'||lv_common_err_mesg
2370: );
2371: retcode := 1;
2372: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
2373: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||trx.transaction_id
2374: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
2375: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
2376: );
2377: ELSIF lv_process_flag IN ('E') THEN

Line 2378: FND_FILE.put_line(FND_FILE.log, '* PROCESS ERROR * Transaction_id:'||trx.transaction_id

2374: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
2375: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
2376: );
2377: ELSIF lv_process_flag IN ('E') THEN
2378: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||trx.transaction_id
2379: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message
2380: );
2381: ELSIF lv_cenvat_rg_flag IN ('E') THEN
2382: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||trx.transaction_id

Line 2382: FND_FILE.put_line(FND_FILE.log, '* CENVAT ERROR * Transaction_id:'||trx.transaction_id

2378: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||trx.transaction_id
2379: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message
2380: );
2381: ELSIF lv_cenvat_rg_flag IN ('E') THEN
2382: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||trx.transaction_id
2383: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message
2384: );
2385:
2386: /* added for VAT Impl. Vijay Shankar for Bug#4250236(4245089) */

Line 2389: FND_FILE.put_line(FND_FILE.log, '* VAT Message * Transaction_id:'||trx.transaction_id

2385:
2386: /* added for VAT Impl. Vijay Shankar for Bug#4250236(4245089) */
2387: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. ELSIF r_trx_after_processing.process_vat_status <> jai_constants.successful THEN
2388: ELSIF r_trx_after_processing.process_vat_status in ('E', jai_constants.unexpected_error, jai_constants.expected_error) then
2389: FND_FILE.put_line(FND_FILE.log, '*** VAT Message *** Transaction_id:'||trx.transaction_id
2390: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||', Flag:'||r_trx_after_processing.process_vat_status
2391: ||' - ErrorMessage:'||r_trx_after_processing.process_vat_message
2392: );
2393: END IF;

Line 2397: FND_FILE.put_line(FND_FILE.log, 'Transaction_Id:'||trx.transaction_id

2393: END IF;
2394:
2395: -- Start, 3927371
2396: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN
2397: FND_FILE.put_line(FND_FILE.log, 'Transaction_Id:'||trx.transaction_id
2398: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
2399: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
2400: );
2401: ELSIF lv_process_flag IN ('X') THEN

Line 2402: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);

2398: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
2399: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
2400: );
2401: ELSIF lv_process_flag IN ('X') THEN
2402: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);
2403: ELSIF lv_cenvat_rg_flag IN ('X') THEN
2404: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);
2405: END IF;
2406:

Line 2404: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);

2400: );
2401: ELSIF lv_process_flag IN ('X') THEN
2402: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);
2403: ELSIF lv_cenvat_rg_flag IN ('X') THEN
2404: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);
2405: END IF;
2406:
2407: IF lv_process_flag = 'E' OR lv_cenvat_rg_flag = 'E' THEN
2408: retcode := 1;

Line 2426: FND_FILE.put_line(FND_FILE.log, 'Error:Transaction_postprocessor. MSG:'||lv_process_message);

2422: -- End, Vijay Shankar for Bug#3940588
2423:
2424: if lv_process_flag = 'E' then
2425: ROLLBACK TO process_trxn;
2426: FND_FILE.put_line(FND_FILE.log, 'Error:Transaction_postprocessor. MSG:'||lv_process_message);
2427: end if;
2428:
2429: IF p_simulate_flag = 'Y' THEN
2430: FND_FILE.put_line(FND_FILE.log, 'Codepath->'||lv_codepath);

Line 2430: FND_FILE.put_line(FND_FILE.log, 'Codepath->'||lv_codepath);

2426: FND_FILE.put_line(FND_FILE.log, 'Error:Transaction_postprocessor. MSG:'||lv_process_message);
2427: end if;
2428:
2429: IF p_simulate_flag = 'Y' THEN
2430: FND_FILE.put_line(FND_FILE.log, 'Codepath->'||lv_codepath);
2431: ELSE
2432: UPDATE JAI_RCV_TRANSACTIONS
2433: SET codepath = lv_codepath
2434: --WHERE rowid = trx.row_id

Line 2456: FND_FILE.put_line( FND_FILE.log, 'Rolled Back Processing in RECEIPT_TRANSACTIONS_PKG.process_batch: Error->'||SQLERRM);

2452:
2453: EXCEPTION
2454: WHEN OTHERS THEN
2455: ROLLBACK TO process_trxn;
2456: FND_FILE.put_line( FND_FILE.log, 'Rolled Back Processing in RECEIPT_TRANSACTIONS_PKG.process_batch: Error->'||SQLERRM);
2457: retcode := 1;
2458: END;
2459:
2460: END LOOP;

Line 2473: FND_FILE.put_line( FND_FILE.log, 'Error:'||SQLERRM);

2469: /* added by Vijay Shankar for Bug#3940588 */
2470: EXCEPTION
2471: WHEN OTHERS THEN
2472: ROLLBACK;
2473: FND_FILE.put_line( FND_FILE.log, 'Error:'||SQLERRM);
2474: FND_FILE.put_line( FND_FILE.log, 'Error Path:'||lv_codepath);
2475: RAISE;
2476: END process_batch;
2477:

Line 2474: FND_FILE.put_line( FND_FILE.log, 'Error Path:'||lv_codepath);

2470: EXCEPTION
2471: WHEN OTHERS THEN
2472: ROLLBACK;
2473: FND_FILE.put_line( FND_FILE.log, 'Error:'||SQLERRM);
2474: FND_FILE.put_line( FND_FILE.log, 'Error Path:'||lv_codepath);
2475: RAISE;
2476: END process_batch;
2477:
2478: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. */

Line 2604: fnd_file.put_line(fnd_file.log, 'Input Params. pn_batch_num:'||pn_batch_num

2600: begin
2601:
2602: lv_statement_id := '0';
2603: if lb_debug then
2604: fnd_file.put_line(fnd_file.log, 'Input Params. pn_batch_num:'||pn_batch_num
2605: ||', pn_min_transaction_id:'||pn_min_transaction_id
2606: ||', pn_max_transaction_id:'||pn_max_transaction_id
2607: ||', pv_called_from:'||pv_called_from
2608: ||', pv_commit_switch:'||pv_commit_switch

Line 2628: fnd_file.put_line(fnd_file.log, '1. INSIDE MAIN LOOP');

2624: ld_excise_invoice_date := null;
2625: lv_vat_invoice_no := null;
2626: ld_vat_invoice_date := null;
2627:
2628: fnd_file.put_line(fnd_file.log, '1. INSIDE MAIN LOOP');
2629:
2630: -- excise invoice number will be generated if the following grouping condition changes
2631: if ln_organization_id <> rtv_rec.organization_id
2632: OR ln_location_id <> rtv_rec.location_id

Line 2668: fnd_file.put_line(fnd_file.log, '~~~ ReceiptNum:'||rtv_rec.receipt_num||', TrxId:'||rtv_rec.transaction_id

2664: end if;
2665:
2666: lv_statement_id := '5.1';
2667: if lb_debug then
2668: fnd_file.put_line(fnd_file.log, '~~~ ReceiptNum:'||rtv_rec.receipt_num||', TrxId:'||rtv_rec.transaction_id
2669: ||', SameFlg:'||lv_same_invoice_no_flag
2670: ||', ExBatch:'||rtv_rec.excise_batch_num ||', VatBatch:'||rtv_rec.vat_batch_num
2671: ||', ExAct:'||rtv_rec.excise_invoice_action ||', VatAct:'||rtv_rec.vat_invoice_action
2672: );

Line 2683: fnd_file.put_line(fnd_file.log, '2. INSIDE IF');

2679: /*bug 8410609 - excise invoice not to be generated for OSP items*/
2680: AND Check_57F4_transaction(rtv_rec.transaction_id) <>'YES'
2681: then
2682:
2683: fnd_file.put_line(fnd_file.log, '2. INSIDE IF');
2684:
2685: lv_statement_id := '7';
2686: if lv_same_invoice_no_flag = jai_constants.yes then
2687: lv_statement_id := '8';

Line 2766: fnd_file.put_line(fnd_file.log, 'VAT Inv Gen Error. Params- RgmId:'||ln_regime_id

2762: );
2763:
2764: lv_statement_id := '21';
2765: if lv_process_flag in (jai_constants.expected_error, jai_constants.unexpected_error) then
2766: fnd_file.put_line(fnd_file.log, 'VAT Inv Gen Error. Params- RgmId:'||ln_regime_id
2767: ||', OrgnId:'||ln_organization_id ||', LocId:'||ln_location_id
2768: ||', InvDate:'||ld_gen_vat_invoice_date||', TrxId:'|| rtv_rec.transaction_id );
2769: fnd_file.put_line(fnd_file.log, 'ErrorCode:'||lv_process_flag
2770: ||', ErrMsg:'||lv_process_message);

Line 2769: fnd_file.put_line(fnd_file.log, 'ErrorCode:'||lv_process_flag

2765: if lv_process_flag in (jai_constants.expected_error, jai_constants.unexpected_error) then
2766: fnd_file.put_line(fnd_file.log, 'VAT Inv Gen Error. Params- RgmId:'||ln_regime_id
2767: ||', OrgnId:'||ln_organization_id ||', LocId:'||ln_location_id
2768: ||', InvDate:'||ld_gen_vat_invoice_date||', TrxId:'|| rtv_rec.transaction_id );
2769: fnd_file.put_line(fnd_file.log, 'ErrorCode:'||lv_process_flag
2770: ||', ErrMsg:'||lv_process_message);
2771: raise_application_error( -20112, 'VAT Inv Gen Error. Code:'||lv_process_flag
2772: ||', MSG:'||lv_process_message);
2773: end if;

Line 2791: fnd_file.put_line(fnd_file.log, '~~~ ExInvNo:'||lv_excise_invoicE_no ||', ld_excise_invoice_Date:'||ld_excise_invoice_date

2787: /* End. VAT Inv. Gen. */
2788:
2789: lv_statement_id := '23.1';
2790: if lb_debug then
2791: fnd_file.put_line(fnd_file.log, '~~~ ExInvNo:'||lv_excise_invoicE_no ||', ld_excise_invoice_Date:'||ld_excise_invoice_date
2792: ||', VatInvNo:'||lv_vat_invoice_no ||', ld_vat_invoice_Date:'||ld_vat_invoice_date
2793: );
2794: end if;
2795:

Line 2919: fnd_file.put_line(fnd_file.log, '3. BEFORE PROCESS TRANSACTION');

2915: else
2916: lv_vat_processing_reqd := jai_constants.no;
2917: end if;
2918:
2919: fnd_file.put_line(fnd_file.log, '3. BEFORE PROCESS TRANSACTION');
2920:
2921: /* call to process the transactions */
2922: process_transaction(
2923: p_transaction_id => rtv_rec.transaction_id,

Line 2943: FND_FILE.put_line(FND_FILE.log, '*** Common Error for Transaction_id:'||rtv_rec.transaction_id

2939: CLOSE c_trx;
2940:
2941: lv_statement_id := '29';
2942: IF lv_common_err_mesg IS NOT NULL THEN
2943: FND_FILE.put_line(FND_FILE.log, '*** Common Error for Transaction_id:'||rtv_rec.transaction_id
2944: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- Error:'||lv_common_err_mesg
2945: );
2946: lb_err_flag := true;
2947: goto end_of_trx;

Line 2950: FND_FILE.put_line(FND_FILE.log, '* FLAGS ERROR * Transaction_id:'||rtv_rec.transaction_id

2946: lb_err_flag := true;
2947: goto end_of_trx;
2948: -- lv_err_mesg := lv_common_err_mesg;
2949: ELSIF lv_process_flag IN ('E') AND lv_cenvat_rg_flag IN ('E') THEN
2950: FND_FILE.put_line(FND_FILE.log, '*** FLAGS ERROR *** Transaction_id:'||rtv_rec.transaction_id
2951: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessErr:'||lv_process_message
2952: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatErr:'||lv_cenvat_rg_message
2953: );
2954: lb_err_flag := true;

Line 2957: FND_FILE.put_line(FND_FILE.log, '* PROCESS ERROR * Transaction_id:'||rtv_rec.transaction_id

2953: );
2954: lb_err_flag := true;
2955: goto end_of_trx;
2956: ELSIF lv_process_flag IN ('E') THEN
2957: FND_FILE.put_line(FND_FILE.log, '*** PROCESS ERROR *** Transaction_id:'||rtv_rec.transaction_id
2958: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_process_message
2959: );
2960: lb_err_flag := true;
2961: goto end_of_trx;

Line 2963: FND_FILE.put_line(FND_FILE.log, '* CENVAT ERROR * Transaction_id:'||rtv_rec.transaction_id

2959: );
2960: lb_err_flag := true;
2961: goto end_of_trx;
2962: ELSIF lv_cenvat_rg_flag IN ('E') THEN
2963: FND_FILE.put_line(FND_FILE.log, '*** CENVAT ERROR *** Transaction_id:'||rtv_rec.transaction_id
2964: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ErrorMessage:'||lv_cenvat_rg_message
2965: );
2966: lb_err_flag := true;
2967: goto end_of_trx;

Line 2969: FND_FILE.put_line(FND_FILE.log, '* VAT Message * Transaction_id:'||rtv_rec.transaction_id

2965: );
2966: lb_err_flag := true;
2967: goto end_of_trx;
2968: ELSIF r_trx_after_processing.process_vat_status in ('E', jai_constants.unexpected_error, jai_constants.expected_error) THEN
2969: FND_FILE.put_line(FND_FILE.log, '*** VAT Message *** Transaction_id:'||rtv_rec.transaction_id
2970: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||', Flag:'||r_trx_after_processing.process_vat_status
2971: ||' - ErrorMessage:'||r_trx_after_processing.process_vat_message
2972: );
2973: lb_err_flag := true;

Line 2979: FND_FILE.put_line(FND_FILE.log, 'Transaction_Id:'||rtv_rec.transaction_id

2975: END IF;
2976:
2977: lv_statement_id := '30';
2978: IF lv_process_flag IN ('X') AND lv_cenvat_rg_flag IN ('X') THEN
2979: FND_FILE.put_line(FND_FILE.log, 'Transaction_Id:'||rtv_rec.transaction_id
2980: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
2981: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
2982: );
2983: ELSIF lv_process_flag IN ('X') THEN

Line 2984: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);

2980: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- ProcessMessage(X):'||lv_process_message
2981: ||fnd_global.local_chr(10)||fnd_global.local_chr(9)||'- CenvatMessgae(X):'||lv_cenvat_rg_message
2982: );
2983: ELSIF lv_process_flag IN ('X') THEN
2984: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);
2985: ELSIF lv_cenvat_rg_flag IN ('X') THEN
2986: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);
2987: END IF;
2988:

Line 2986: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);

2982: );
2983: ELSIF lv_process_flag IN ('X') THEN
2984: FND_FILE.put_line(FND_FILE.log, 'Process Message(X):'||lv_process_message);
2985: ELSIF lv_cenvat_rg_flag IN ('X') THEN
2986: FND_FILE.put_line(FND_FILE.log, 'Cenvat Messgae(X):'||lv_cenvat_rg_message);
2987: END IF;
2988:
2989: lv_statement_id := '31';
2990: IF lv_process_flag = 'E' OR lv_cenvat_rg_flag = 'E' THEN

Line 3021: FND_FILE.put_line(FND_FILE.log, 'process_rtv call to jai_rcv_transactions_pkg.update_inv_stat_and_no rtv_rec.transaction_id '||rtv_rec.transaction_id

3017: p_attribute2 => lv_vat_inv_gen_action
3018: );*/
3019:
3020: --added for bug 13364465
3021: FND_FILE.put_line(FND_FILE.log, 'process_rtv call to jai_rcv_transactions_pkg.update_inv_stat_and_no rtv_rec.transaction_id '||rtv_rec.transaction_id
3022: ||' lv_excise_inv_gen_action '||lv_excise_inv_gen_action||' lv_vat_inv_gen_action '||lv_vat_inv_gen_action );
3023:
3024: jai_rcv_transactions_pkg.update_inv_stat_and_no(
3025: p_transaction_id => rtv_rec.transaction_id,

Line 3030: fnd_file.put_line(fnd_file.log, '4. BEFORE CREATE 57F4');

3026: p_excise_inv_gen_status => lv_excise_inv_gen_action,
3027: p_vat_inv_gen_status => lv_vat_inv_gen_action
3028: );
3029:
3030: fnd_file.put_line(fnd_file.log, '4. BEFORE CREATE 57F4');
3031:
3032: lv_statement_id := '32';
3033: /* Following code is a replacement for removal of ja_in_create_rcv_57f4_trg trigger
3034: as part of RTV DFF Elimination */

Line 3048: FND_FILE.put_line(FND_FILE.log, 'Error in Call to jai_po_osp_pkg.create_rcv_57f4. Mesg:'||lv_process_message);

3044: end if;
3045:
3046: lv_statement_id := '33';
3047: if lv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error) then
3048: FND_FILE.put_line(FND_FILE.log, 'Error in Call to jai_po_osp_pkg.create_rcv_57f4. Mesg:'||lv_process_message);
3049: lv_process_flag := 'E';
3050: lb_err_flag := true;
3051: goto end_of_trx;
3052: end if;

Line 3062: fnd_file.put_line( fnd_file.log, 'ErrCodepath:'||lv_codepath);

3058: WHERE current of c_rtv_trxs;
3059:
3060: <>
3061: if lb_err_flag then
3062: fnd_file.put_line( fnd_file.log, 'ErrCodepath:'||lv_codepath);
3063: raise_application_error( -20012, 'Error during RTV Processing. Look at the log for details');
3064: end if;
3065:
3066: ln_processed_cnt := ln_processed_cnt + 1;

Line 3081: FND_FILE.put_line( FND_FILE.log, pv_errbuf);

3077: WHEN OTHERS THEN
3078: ROLLBACK;
3079: pv_retcode := jai_constants.request_error;
3080: pv_errbuf := 'Error(StmtId:'||lv_statement_id||')-'||SQLERRM;
3081: FND_FILE.put_line( FND_FILE.log, pv_errbuf);
3082: -- FND_FILE.put_line( FND_FILE.log, 'Error Path:'||lv_codepath);
3083: end process_rtv;
3084:
3085:

Line 3082: -- FND_FILE.put_line( FND_FILE.log, 'Error Path:'||lv_codepath);

3078: ROLLBACK;
3079: pv_retcode := jai_constants.request_error;
3080: pv_errbuf := 'Error(StmtId:'||lv_statement_id||')-'||SQLERRM;
3081: FND_FILE.put_line( FND_FILE.log, pv_errbuf);
3082: -- FND_FILE.put_line( FND_FILE.log, 'Error Path:'||lv_codepath);
3083: end process_rtv;
3084:
3085:
3086: PROCEDURE process_transaction(

Line 3150: FND_FILE.put_line(FND_FILE.log, '^Start of Trx:'||p_transaction_id||'. Time:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss')

3146:
3147: -- this is to identify the path in SQL TRACE file if any problem occured
3148: SELECT to_char(sysdate,'dd/mm/yyyy hh24:mi:ss')||'-jirt_pkg.process_transaction-'||p_transaction_id INTO lv_temp FROM DUAL;
3149:
3150: FND_FILE.put_line(FND_FILE.log, '^Start of Trx:'||p_transaction_id||'. Time:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss')
3151: ||', PrcSpecialReason:'||p_process_special_reason||', PrcSplQty:'||p_process_special_qty
3152: );
3153:
3154: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'receipt_transactions_pkg.process_transaction', 'START');

Line 3212: FND_FILE.put_line(FND_FILE.log, lv_object_code||'Localization doesnot support this transaction type');

3208:
3209: -- "MATCH" included by Vijay Shankar for Bug#3940588
3210: IF lv_transaction_type NOT IN ( 'RECEIVE', 'DELIVER', 'RETURN TO RECEIVING', 'RETURN TO VENDOR', 'MATCH' ) THEN
3211: -- Localization donot support these transactions. So, Pls return back
3212: FND_FILE.put_line(FND_FILE.log, lv_object_code||'Localization doesnot support this transaction type');
3213: RETURN;
3214: END IF;
3215:
3216: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath);

Line 3258: FND_FILE.put_line( FND_FILE.log, '1 No Codepath ');

3254: p_process_message => p_process_message
3255: );
3256:
3257: ELSE
3258: FND_FILE.put_line( FND_FILE.log, '1****** No Codepath ******');
3259: END IF;
3260:
3261: lv_execution_point := 'END_PROCESS_FLAG';
3262:

Line 3265: FND_FILE.put_line(FND_FILE.log, 'PRC_FLG_Error: RollingBack to process_trxn_flag');

3261: lv_execution_point := 'END_PROCESS_FLAG';
3262:
3263: lv_statement_id := '6';
3264: IF p_process_flag IN ('E', 'X') THEN
3265: FND_FILE.put_line(FND_FILE.log, 'PRC_FLG_Error: RollingBack to process_trxn_flag');
3266: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath);
3267: ROLLBACK TO process_trxn_flag;
3268: ElSIF p_process_flag = 'Y' THEN
3269: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath);

Line 3272: FND_FILE.put_line(FND_FILE.log, '1#PRC_FLG#'||p_process_flag);

3268: ElSIF p_process_flag = 'Y' THEN
3269: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath);
3270: p_process_message := 'Successful';
3271: ELSE
3272: FND_FILE.put_line(FND_FILE.log, '1#PRC_FLG#'||p_process_flag);
3273: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath);
3274: END IF;
3275:
3276: END IF;

Line 3278: FND_FILE.put_line(FND_FILE.log, '2#PRC_FLG#'||p_process_flag);

3274: END IF;
3275:
3276: END IF;
3277:
3278: FND_FILE.put_line(FND_FILE.log, '2#PRC_FLG#'||p_process_flag);
3279: ------------ End of PROCESS_FLAG Execution ----------
3280:
3281: lv_statement_id := '7';
3282: ln_cenvat_claimed_ptg := r_trx.cenvat_claimed_ptg;

Line 3283: FND_FILE.put_line(FND_FILE.log, 'r_trx.item_class:'||r_trx.item_class);

3279: ------------ End of PROCESS_FLAG Execution ----------
3280:
3281: lv_statement_id := '7';
3282: ln_cenvat_claimed_ptg := r_trx.cenvat_claimed_ptg;
3283: FND_FILE.put_line(FND_FILE.log, 'r_trx.item_class:'||r_trx.item_class);
3284: FND_FILE.put_line(FND_FILE.log, 'lv_online_qty_flag:'||lv_online_qty_flag);
3285:
3286: /*bgowrava for forward porting Bug#5756676..start*/
3287: IF lv_online_qty_flag = 'Y' THEN

Line 3284: FND_FILE.put_line(FND_FILE.log, 'lv_online_qty_flag:'||lv_online_qty_flag);

3280:
3281: lv_statement_id := '7';
3282: ln_cenvat_claimed_ptg := r_trx.cenvat_claimed_ptg;
3283: FND_FILE.put_line(FND_FILE.log, 'r_trx.item_class:'||r_trx.item_class);
3284: FND_FILE.put_line(FND_FILE.log, 'lv_online_qty_flag:'||lv_online_qty_flag);
3285:
3286: /*bgowrava for forward porting Bug#5756676..start*/
3287: IF lv_online_qty_flag = 'Y' THEN
3288:

Line 3301: FND_FILE.put_line(FND_FILE.log, 'Calling ja_in_receipt_cenvat_rg_pkg.rg_i_entry');

3297: *//*commented and added the below if condition for bug#10036144*/
3298: IF (r_base_trx.source_document_Code in ('RMA','INVENTORY') AND r_trx.item_class IN ('FGIN', 'FGEX', 'CCIN', 'CCEX')) THEN
3299:
3300:
3301: FND_FILE.put_line(FND_FILE.log, 'Calling ja_in_receipt_cenvat_rg_pkg.rg_i_entry');
3302:
3303: /*bug 7662347*/
3304: IF lv_transaction_type = 'RETURN TO VENDOR'
3305: OR lv_transaction_type = 'DELIVER' /* Added for bug #12818250 by vkavulur */

Line 3325: FND_FILE.put_line(FND_FILE.log, 'ln_part_i_register_id:'||ln_part_i_register_id);

3321: p_simulate_flag => p_simulate_flag,
3322: p_codepath => p_codepath
3323: );
3324:
3325: FND_FILE.put_line(FND_FILE.log, 'ln_part_i_register_id:'||ln_part_i_register_id);
3326:
3327: ELSIF r_trx.item_class IN ('RMIN', 'RMEX', 'CCIN', 'CCEX', 'CGIN', 'CGEX') THEN
3328:
3329: lv_register_type := jai_general_pkg.get_rg_register_type( p_item_class => r_trx.item_class);

Line 3331: FND_FILE.put_line(FND_FILE.log, 'Register Type:'||lv_register_type);

3327: ELSIF r_trx.item_class IN ('RMIN', 'RMEX', 'CCIN', 'CCEX', 'CGIN', 'CGEX') THEN
3328:
3329: lv_register_type := jai_general_pkg.get_rg_register_type( p_item_class => r_trx.item_class);
3330:
3331: FND_FILE.put_line(FND_FILE.log, 'Register Type:'||lv_register_type);
3332:
3333: -- to determine the way in which CGIN Items are Processed
3334: IF lv_register_type = 'C' THEN
3335: jai_rcv_excise_processing_pkg.derive_cgin_scenario(

Line 3343: FND_FILE.put_line(FND_FILE.log, 'CGIN_CODE->'||lv_cgin_code);

3339: p_process_message => lv_process_message,
3340: p_codepath => p_codepath
3341: );
3342:
3343: FND_FILE.put_line(FND_FILE.log, 'CGIN_CODE->'||lv_cgin_code);
3344: END IF;
3345: -- RG23 Part I Entry is already made during first Claim, in case of CGIN Items
3346: -- So no need of another entry during Second 50% Claim of CENVAT
3347: IF nvl(lv_cgin_code, 'XXX') <> 'REGULAR-HALF' THEN

Line 3349: FND_FILE.put_line(FND_FILE.log, 'Calling ja_in_receipt_cenvat_rg_pkg.rg23_part_i_entry');

3345: -- RG23 Part I Entry is already made during first Claim, in case of CGIN Items
3346: -- So no need of another entry during Second 50% Claim of CENVAT
3347: IF nvl(lv_cgin_code, 'XXX') <> 'REGULAR-HALF' THEN
3348:
3349: FND_FILE.put_line(FND_FILE.log, 'Calling ja_in_receipt_cenvat_rg_pkg.rg23_part_i_entry');
3350:
3351: /*bug 7662347*/
3352: --ADDED in clause 'DELIVER' for bug#16306678
3353: IF lv_transaction_type in ('RETURN TO VENDOR','DELIVER') THEN

Line 3373: FND_FILE.put_line( FND_FILE.log, 'No Call to RG23_PART_I_ENTRY');

3369:
3370: --lv_qty_register := 'RG23';
3371:
3372: ELSE
3373: FND_FILE.put_line( FND_FILE.log, 'No Call to RG23_PART_I_ENTRY');
3374: END IF;
3375:
3376: END IF;
3377:

Line 3429: FND_FILE.put_line( FND_FILE.log, lv_object_code||'Transaction type Not supported for cenvat Entries');

3425: p_process_special_qty => p_process_special_qty
3426: );
3427:
3428: ELSE
3429: FND_FILE.put_line( FND_FILE.log, lv_object_code||'Transaction type Not supported for cenvat Entries');
3430: END IF;
3431:
3432: lv_execution_point := 'END_CENVAT_FLAG';
3433:

Line 3436: FND_FILE.put_line(FND_FILE.log, 'CEN_FLG_Error: RollingBack to process_cenvat_rg_flag');

3432: lv_execution_point := 'END_CENVAT_FLAG';
3433:
3434: lv_statement_id := '9';
3435: IF p_cenvat_rg_flag IN ('E', 'X') THEN
3436: FND_FILE.put_line(FND_FILE.log, 'CEN_FLG_Error: RollingBack to process_cenvat_rg_flag');
3437: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath);
3438: ROLLBACK TO process_cenvat_rg_flag;
3439: ElSIF p_cenvat_rg_flag = 'Y' THEN
3440: p_cenvat_rg_message := 'Successful';

Line 3443: FND_FILE.put_line(FND_FILE.log, '1#CENVAT_FLG#'||p_cenvat_rg_flag);

3439: ElSIF p_cenvat_rg_flag = 'Y' THEN
3440: p_cenvat_rg_message := 'Successful';
3441: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath);
3442: ELSE
3443: FND_FILE.put_line(FND_FILE.log, '1#CENVAT_FLG#'||p_cenvat_rg_flag);
3444: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath);
3445: END IF;
3446:
3447: END IF;

Line 3449: FND_FILE.put_line(FND_FILE.log, '2#CENVAT_FLG#'||p_cenvat_rg_flag);

3445: END IF;
3446:
3447: END IF;
3448:
3449: FND_FILE.put_line(FND_FILE.log, '2#CENVAT_FLG#'||p_cenvat_rg_flag);
3450: /* End of CENVAT_RG_FLAG Execution */
3451:
3452: lv_statement_id := '10';
3453: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath);

Line 3482: FND_FILE.put_line( FND_FILE.log, lv_object_code||'Trxn not supported for VAT processing');

3478: p_process_message => lv_process_vat_message
3479: );
3480:
3481: ELSE
3482: FND_FILE.put_line( FND_FILE.log, lv_object_code||'Trxn not supported for VAT processing');
3483: END IF;
3484:
3485: lv_execution_point := 'END_PROCESS_VAT';
3486:

Line 3492: FND_FILE.put_line(FND_FILE.log, 'PrcVatFlg Err: RollingBack to process_vat_flag. Mesg:'||lv_process_vat_message);

3488: IF lv_process_vat_flag = jai_constants.successful THEN
3489: lv_process_vat_message := 'Successful';
3490: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath);
3491: ELSIF lv_process_vat_flag <> jai_constants.successful THEN
3492: FND_FILE.put_line(FND_FILE.log, 'PrcVatFlg Err: RollingBack to process_vat_flag. Mesg:'||lv_process_vat_message);
3493: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath);
3494: ROLLBACK TO process_vat_flag;
3495: ELSE
3496: FND_FILE.put_line(FND_FILE.log, '1#PrcVatFlg#'||lv_process_vat_flag);

Line 3496: FND_FILE.put_line(FND_FILE.log, '1#PrcVatFlg#'||lv_process_vat_flag);

3492: FND_FILE.put_line(FND_FILE.log, 'PrcVatFlg Err: RollingBack to process_vat_flag. Mesg:'||lv_process_vat_message);
3493: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath);
3494: ROLLBACK TO process_vat_flag;
3495: ELSE
3496: FND_FILE.put_line(FND_FILE.log, '1#PrcVatFlg#'||lv_process_vat_flag);
3497: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath);
3498: END IF;
3499:
3500: END IF;

Line 3502: FND_FILE.put_line(FND_FILE.log, '2#PrcVatFlg#'||lv_process_vat_flag);

3498: END IF;
3499:
3500: END IF;
3501:
3502: FND_FILE.put_line(FND_FILE.log, '2#PrcVatFlg#'||lv_process_vat_flag);
3503: /* End of VAT Execution */
3504:
3505: lv_statement_id := '14';
3506: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath);

Line 3527: FND_FILE.put_line(FND_FILE.log, '$End of Trx:'||p_transaction_id||'. Time:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss'));

3523:
3524: END IF;
3525: <>
3526:
3527: FND_FILE.put_line(FND_FILE.log, '$End of Trx:'||p_transaction_id||'. Time:'||to_char(SYSDATE,'dd/mm/yyyy hh24:mi:ss'));
3528:
3529: p_codepath := jai_general_pkg.plot_codepath(99, p_codepath, null, 'END');
3530:
3531: EXCEPTION

Line 3534: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_common_err_mesg);

3530:
3531: EXCEPTION
3532: WHEN OTHERS THEN
3533: p_common_err_mesg := 'RECEIPT_TRANSACTIONS_PKG.process_transaction(StmtId:'||lv_statement_id||'). Error:'||SQLERRM;
3534: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_common_err_mesg);
3535: IF p_process_flag <> 'Y' THEN
3536: p_process_flag := 'E';
3537: p_process_message := p_common_err_mesg;
3538: ELSIF p_cenvat_rg_flag <> 'Y' THEN

Line 3688: FND_FILE.put_line(FND_FILE.log, '^ POPULATE_DETAILS');

3684:
3685: BEGIN
3686:
3687: IF lb_debug THEN
3688: FND_FILE.put_line(FND_FILE.log, '^ POPULATE_DETAILS');
3689: END IF;
3690:
3691: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'populate_details', 'START');
3692:

Line 3959: FND_FILE.put_line(FND_FILE.log, '... RecNum:'||r_shp_hdr_dtls.receipt_num ||',p_cenvat_amount:'||ln_cenvat_amount );

3955: END IF;
3956: -- End, added by Vijay Shankar for Bug#3940588
3957:
3958: IF lb_debug THEN
3959: FND_FILE.put_line(FND_FILE.log, '... RecNum:'||r_shp_hdr_dtls.receipt_num ||',p_cenvat_amount:'||ln_cenvat_amount );
3960: END IF;
3961:
3962: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath);
3963: jai_rcv_transactions_pkg.update_row(

Line 4010: FND_FILE.put_line(FND_FILE.log, '$ POPULATE_DETAILS');

4006:
4007: p_codepath := jai_general_pkg.plot_codepath(20, p_codepath, 'populate_details', 'END');
4008:
4009: IF lb_debug THEN
4010: FND_FILE.put_line(FND_FILE.log, '$ POPULATE_DETAILS');
4011: END IF;
4012:
4013: /* Added by Ramananda for bug#4407165 */
4014: EXCEPTION

Line 4259: FND_FILE.put_line(FND_FILE.log, '^VALIDATE_TRANSACTION. Prc_Flag->'||p_process_flag||', Cen_Flag->'||p_cenvat_rg_flag);

4255: lv_codepath := '';
4256:
4257: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'cenvat_rg_pkg.validate_trx', 'START');
4258: IF lb_debug THEN
4259: FND_FILE.put_line(FND_FILE.log, '^VALIDATE_TRANSACTION. Prc_Flag->'||p_process_flag||', Cen_Flag->'||p_cenvat_rg_flag);
4260: END IF;
4261:
4262: IF p_process_flag IS NULL THEN
4263: p_process_message := NULL;

Line 4301: FND_FILE.put_line(FND_FILE.log, 'r_base_trx.currency_code ->'||r_base_trx.currency_code);

4297: LOOP
4298: FETCH ship_cur INTO v_ship_rec;
4299: EXIT WHEN ship_cur % NOTFOUND;
4300:
4301: FND_FILE.put_line(FND_FILE.log, 'r_base_trx.currency_code ->'||r_base_trx.currency_code);
4302:
4303: v_conv_factor := nvl(r_base_trx.currency_conversion_rate,1);
4304:
4305: FND_FILE.put_line(FND_FILE.log, 'v_conv_factor ->'||v_conv_factor);

Line 4305: FND_FILE.put_line(FND_FILE.log, 'v_conv_factor ->'||v_conv_factor);

4301: FND_FILE.put_line(FND_FILE.log, 'r_base_trx.currency_code ->'||r_base_trx.currency_code);
4302:
4303: v_conv_factor := nvl(r_base_trx.currency_conversion_rate,1);
4304:
4305: FND_FILE.put_line(FND_FILE.log, 'v_conv_factor ->'||v_conv_factor);
4306:
4307: FND_FILE.put_line(FND_FILE.log, '2. v_ship_rec.tax_amount ->'||v_ship_rec.tax_amount||'v_conv_factor - '||v_conv_factor);
4308:
4309: v_tax_sum := NVL(v_tax_sum, 0) + NVL(v_ship_rec.tax_amount * v_conv_factor, 0);

Line 4307: FND_FILE.put_line(FND_FILE.log, '2. v_ship_rec.tax_amount ->'||v_ship_rec.tax_amount||'v_conv_factor - '||v_conv_factor);

4303: v_conv_factor := nvl(r_base_trx.currency_conversion_rate,1);
4304:
4305: FND_FILE.put_line(FND_FILE.log, 'v_conv_factor ->'||v_conv_factor);
4306:
4307: FND_FILE.put_line(FND_FILE.log, '2. v_ship_rec.tax_amount ->'||v_ship_rec.tax_amount||'v_conv_factor - '||v_conv_factor);
4308:
4309: v_tax_sum := NVL(v_tax_sum, 0) + NVL(v_ship_rec.tax_amount * v_conv_factor, 0);
4310:
4311: END LOOP;

Line 4314: FND_FILE.put_line(FND_FILE.log, 'v_tax_sum ->'||v_tax_sum);

4310:
4311: END LOOP;
4312: CLOSE ship_cur;
4313:
4314: FND_FILE.put_line(FND_FILE.log, 'v_tax_sum ->'||v_tax_sum);
4315:
4316: IF NVL(v_tax_sum, 0) > 0
4317: THEN
4318:

Line 4325: FND_FILE.put_line(FND_FILE.log, 'v_applied_amt ->'||v_applied_amt);

4321: CLOSE rcp_cur;
4322:
4323: v_applied_amt := NVL(ROUND(v_applied_amt, 2),0);
4324:
4325: FND_FILE.put_line(FND_FILE.log, 'v_applied_amt ->'||v_applied_amt);
4326:
4327: IF ROUND(NVL(v_tax_sum, 0), 2) > NVL(v_applied_amt, 0) and r_base_trx.transaction_type = 'RECEIVE'
4328: Then
4329: p_process_message := 'BOE is not Completely applied for Receipt'||r_receipt_line.receipt_num;

Line 4333: FND_FILE.put_line(FND_FILE.log, 'Error '||p_process_message);

4329: p_process_message := 'BOE is not Completely applied for Receipt'||r_receipt_line.receipt_num;
4330: p_process_flag := 'E';
4331: p_cenvat_rg_flag := 'X';
4332: p_cenvat_rg_message :=' BOE is not Completely applied for Receipt'||r_receipt_line.receipt_num;
4333: FND_FILE.put_line(FND_FILE.log, 'Error '||p_process_message);
4334: GOTO end_of_cenvat_flag_validation;
4335: END IF;
4336:
4337: END IF;

Line 4379: --FND_FILE.put_line(fnd_file.log, 'Shp_lineId:'||r_trx.shipment_line_id||', Cnt:'||SQL%ROWCOUNT

4375: /*OPEN c_receipt_line_dtls(r_trx.shipment_line_id);
4376: FETCH c_receipt_line_dtls into r_receipt_line;
4377: CLOSE c_receipt_line_dtls;*/
4378:
4379: --FND_FILE.put_line(fnd_file.log, 'Shp_lineId:'||r_trx.shipment_line_id||', Cnt:'||SQL%ROWCOUNT
4380: -- ||', Cnt:'||SQL%ROWCOUNT||', exNo:'||r_receipt_line.excise_invoice_no);
4381:
4382: lv_statement_id := '4';
4383: /* Fetch the Tax count */

Line 4417: FND_file.put_line( fnd_file.log, 'Quantity Update Event:'||lv_qty_upd_event);

4413: FETCH cur_qty_setup INTO lv_qty_upd_event;
4414: END IF;
4415: CLOSE cur_qty_setup;
4416:
4417: FND_file.put_line( fnd_file.log, 'Quantity Update Event:'||lv_qty_upd_event);
4418:
4419: OPEN cur_item_excise_flag(r_trx.organization_id,r_trx.inventory_item_id );
4420: FETCH cur_item_excise_flag INTO lv_excise_flag;
4421: CLOSE cur_item_excise_flag;

Line 4423: FND_file.put_line( fnd_file.log, 'Item Excisable:'||lv_excise_flag);

4419: OPEN cur_item_excise_flag(r_trx.organization_id,r_trx.inventory_item_id );
4420: FETCH cur_item_excise_flag INTO lv_excise_flag;
4421: CLOSE cur_item_excise_flag;
4422:
4423: FND_file.put_line( fnd_file.log, 'Item Excisable:'||lv_excise_flag);
4424: FND_file.put_line( fnd_file.log, 'Excisable Taxes Count:'||r_taxes.excise_cnt);
4425:
4426: FND_file.put_line( fnd_file.log, 'Transaction Type:'||lv_transaction_type);
4427:

Line 4424: FND_file.put_line( fnd_file.log, 'Excisable Taxes Count:'||r_taxes.excise_cnt);

4420: FETCH cur_item_excise_flag INTO lv_excise_flag;
4421: CLOSE cur_item_excise_flag;
4422:
4423: FND_file.put_line( fnd_file.log, 'Item Excisable:'||lv_excise_flag);
4424: FND_file.put_line( fnd_file.log, 'Excisable Taxes Count:'||r_taxes.excise_cnt);
4425:
4426: FND_file.put_line( fnd_file.log, 'Transaction Type:'||lv_transaction_type);
4427:
4428: /*Bug 8538155 (FP for bug 8466620) - Do not hit the quantity register when there are no recoverable

Line 4426: FND_file.put_line( fnd_file.log, 'Transaction Type:'||lv_transaction_type);

4422:
4423: FND_file.put_line( fnd_file.log, 'Item Excisable:'||lv_excise_flag);
4424: FND_file.put_line( fnd_file.log, 'Excisable Taxes Count:'||r_taxes.excise_cnt);
4425:
4426: FND_file.put_line( fnd_file.log, 'Transaction Type:'||lv_transaction_type);
4427:
4428: /*Bug 8538155 (FP for bug 8466620) - Do not hit the quantity register when there are no recoverable
4429: * taxes and delivery is to expense location. Reason - when there are no recoverable taxes, the entry
4430: * will not be reversed during deliver.*/

Line 4448: FND_file.put_line( fnd_file.log, 'Quantity Register would be hit independent of Amount register');

4444: ) THEN
4445:
4446: lv_online_qty_flag := 'Y';
4447:
4448: FND_file.put_line( fnd_file.log, 'Quantity Register would be hit independent of Amount register');
4449:
4450: END IF;
4451: else
4452: lv_online_qty_flag := 'N';

Line 4454: FND_file.put_line( fnd_file.log, 'Quantity Register will not hit as the item is not excisable');

4450: END IF;
4451: else
4452: lv_online_qty_flag := 'N';
4453:
4454: FND_file.put_line( fnd_file.log, 'Quantity Register will not hit as the item is not excisable');
4455: end if; --14346451
4456: END IF;
4457:
4458: /*bgowrava for forward porting Bug#5756676..end*/

Line 4575: FND_file.put_line( fnd_file.log, '54321 ttype:'||r_trx.transaction_type||',exno:'||r_receipt_line.excise_invoice_no

4571: goto end_of_cenvat_flag_validation;
4572: END IF;
4573:
4574: -- following condition is false if the call to this procedure happened from JAINMVAT (i.e deferred Claim Scree)
4575: FND_file.put_line( fnd_file.log, '54321 ttype:'||r_trx.transaction_type||',exno:'||r_receipt_line.excise_invoice_no
4576: ||',exda:'||r_receipt_line.excise_invoice_date||',onClFlg:'||r_receipt_cenvat_dtl.online_claim_flag
4577: ||',CenAmt:'||r_receipt_cenvat_dtl.cenvat_amount||',calFrm:'||p_called_from);
4578:
4579: lv_statement_id := '15';

Line 5081: fnd_file.put_line(FND_FILE.LOG, ' transaction id ' || p_transaction_id);

5077: | Check whether 57F4 transaction has been created for PO
5078: | before updating Excise invoice action. If so we need to set
5079: | the value to 'PENDING' instead of 'NOT_APPLICABLE
5080: */
5081: fnd_file.put_line(FND_FILE.LOG, ' transaction id ' || p_transaction_id);
5082:
5083: IF ( Check_57F4_transaction( p_transaction_id ) = 'YES' ) THEN
5084: lv_excise_inv_gen_action := INV_GEN_STATUS_PENDING;
5085: END IF ;

Line 5110: FND_FILE.put_line( fnd_file.log, '$ VALIDATE_TRANSACTION PrcFlg:'||p_process_flag||', Msg:'||p_process_message

5106: lv_statement_id := '49';
5107: p_codepath := jai_general_pkg.plot_codepath(lv_codepath||',49', p_codepath, 'cenvat_rg_pkg.validate_trx', 'END');
5108: -- p_codepath := substr(p_codepath||lv_codepath, 1, 2000);
5109:
5110: FND_FILE.put_line( fnd_file.log, '$ VALIDATE_TRANSACTION PrcFlg:'||p_process_flag||', Msg:'||p_process_message
5111: ||', CenvatRgFlg:'||p_cenvat_rg_flag ||', Msg:'||p_cenvat_rg_message
5112: ||', PrcVatFlg:'||p_process_vat_flag ||', Msg:'||p_process_vat_message
5113: ||', localPath:'||lv_codepath
5114: );

Line 5120: FND_FILE.put_line( fnd_file.log, 'Error in '||p_process_message||'. localErrorPath:'||lv_codepath );

5116: EXCEPTION
5117: when others then
5118: p_process_flag := 'E';
5119: p_process_message := 'RECEIPT_TRANSACTION_PKG.Validate_transaction:'||SQLERRM||', Statement_id:'||lv_statement_id;
5120: FND_FILE.put_line( fnd_file.log, 'Error in '||p_process_message||'. localErrorPath:'||lv_codepath );
5121: p_codepath := jai_general_pkg.plot_codepath(lv_codepath||',-999', p_codepath, 'cenvat_rg_pkg.validate_trx', 'END');
5122:
5123: END validate_transaction;
5124: