DBA Data[Home] [Help]

APPS.JAI_PA_COSTING_PKG dependencies on FND_FILE

Line 718: FND_FILE.put_line(FND_FILE.log, 'Post Process Parameters: ' || p_transaction_source || ':' || p_batch || ':' || p_xface_id);

714: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
715: , pn_reg_id => ln_reg_id
716: );
717:
718: FND_FILE.put_line(FND_FILE.log, 'Post Process Parameters: ' || p_transaction_source || ':' || p_batch || ':' || p_xface_id);
719:
720: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' ||
721: ' p_transaction_source='|| p_transaction_source ||
722: ' p_batch ='|| p_batch ||

Line 742: FND_FILE.put_line(FND_FILE.log, 'Deleting records with transaction_status_code R');

738:
739: for r_pa_trx_xface_rec_status in c_pa_trx_xface_receipt
740: loop
741:
742: FND_FILE.put_line(FND_FILE.log, 'Deleting records with transaction_status_code R');
743:
744: delete from pa_transaction_interface_all
745: where attribute10 = 'INDIA LOCALIZATION'
746: and transaction_status_code not in ('I', 'A')

Line 754: FND_FILE.put_line(FND_FILE.log, 'Updating Request ID: ' || fnd_global.conc_request_id());

750:
751: for r_upd_req_id in c_upd_req_id
752: loop
753:
754: FND_FILE.put_line(FND_FILE.log, 'Updating Request ID: ' || fnd_global.conc_request_id());
755:
756: update jai_pa_tax_trxs
757: set request_id = fnd_global.conc_request_id()
758: where current of c_upd_req_id;

Line 1003: FND_FILE.put_line(FND_FILE.log, 'r_check_if_tax_exists.tax_exist: ' || r_check_if_tax_exists.cdl_system_reference4 || ':'

999: -- Check if the Tax lines already exist in JAI_PA_TAX_TRXS
1000: ------------------------------------------------------------------------------------
1001: open c_check_if_tax_exists (r_po_rcpt.cdl_system_reference4, rec_get_non_rec_taxes.tax_id);
1002: fetch c_check_if_tax_exists into r_check_if_tax_exists;
1003: FND_FILE.put_line(FND_FILE.log, 'r_check_if_tax_exists.tax_exist: ' || r_check_if_tax_exists.cdl_system_reference4 || ':'
1004: || r_check_if_tax_exists.attribute9);
1005: exit when c_check_if_tax_exists%FOUND;
1006: close c_check_if_tax_exists;
1007: ------------------------------------------------------------------------------------

Line 1266: FND_FILE.put_line(FND_FILE.log, 'Inserting into jai_pa_tax_trxs');

1262: -- Added by Jia for FP Bug#9863751, Begin
1263: -- Insert into jai_pa_tax_trxs before inserting into pa_transaction_interface_all
1264: -- This is done to prevent duplicate Tax lines from getting interfaced to Projects
1265: ------------------------------------------------------------------------------------
1266: FND_FILE.put_line(FND_FILE.log, 'Inserting into jai_pa_tax_trxs');
1267:
1268: INSERT INTO jai_pa_tax_trxs(
1269: TRANSACTION_SOURCE ,
1270: BATCH_NAME ,

Line 1521: FND_FILE.put_line(FND_FILE.log, 'Inserting into pa_transaction_interface_all :' || ln_txn_interface_id);

1517: SELECT pa_txn_interface_s.nextval
1518: INTO ln_txn_interface_id
1519: FROM dual;
1520:
1521: FND_FILE.put_line(FND_FILE.log, 'Inserting into pa_transaction_interface_all :' || ln_txn_interface_id);
1522: FND_FILE.put_line(FND_FILE.log, 'Debugs Values: ' || R_JAI_PA_TAX_TRXS.TRANSACTION_SOURCE || ':' || R_JAI_PA_TAX_TRXS.BATCH_NAME || ':'
1523: || R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ||
1524: ':' || R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE10 || ':' || R_JAI_PA_TAX_TRXS.INTERFACE_ID
1525: || ':' || R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE9);

Line 1522: FND_FILE.put_line(FND_FILE.log, 'Debugs Values: ' || R_JAI_PA_TAX_TRXS.TRANSACTION_SOURCE || ':' || R_JAI_PA_TAX_TRXS.BATCH_NAME || ':'

1518: INTO ln_txn_interface_id
1519: FROM dual;
1520:
1521: FND_FILE.put_line(FND_FILE.log, 'Inserting into pa_transaction_interface_all :' || ln_txn_interface_id);
1522: FND_FILE.put_line(FND_FILE.log, 'Debugs Values: ' || R_JAI_PA_TAX_TRXS.TRANSACTION_SOURCE || ':' || R_JAI_PA_TAX_TRXS.BATCH_NAME || ':'
1523: || R_JAI_PA_TAX_TRXS.TRANSACTION_STATUS_CODE ||
1524: ':' || R_JAI_PA_TAX_TRXS.SYSTEM_LINKAGE || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE10 || ':' || R_JAI_PA_TAX_TRXS.INTERFACE_ID
1525: || ':' || R_JAI_PA_TAX_TRXS.CDL_SYSTEM_REFERENCE4 || ':' || R_JAI_PA_TAX_TRXS.ATTRIBUTE9);
1526:

Line 2046: FND_FILE.put_line(FND_FILE.log, '1');

2042: FETCH cur_get_cenvat_dtls INTO lv_cenvat_rg_flag, lv_cenvat_rg_message;
2043: CLOSE cur_get_cenvat_dtls;
2044:
2045: IF (nvl(lv_cenvat_rg_flag,'P') <> 'X' OR nvl(lv_cenvat_rg_message,'$$$') <> 'Cenvat Unclaimed') THEN
2046: FND_FILE.put_line(FND_FILE.log, '1');
2047: RETURN;
2048: END IF;
2049: END IF;
2050:

Line 2064: FND_FILE.put_line(FND_FILE.log, 'LN_REQUEST_ID '|| LN_REQUEST_ID);

2060: lv_transaction_rejection_code :='';
2061:
2062: LN_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID();
2063:
2064: FND_FILE.put_line(FND_FILE.log, 'LN_REQUEST_ID '|| LN_REQUEST_ID);
2065:
2066: SELECT org_id
2067: INTO ln_org_id
2068: FROM pa_implementations;

Line 2097: FND_FILE.put_line(FND_FILE.log, 'ln_apportion_factor '|| ln_apportion_factor);

2093: ln_apportion_factor := rec_get_deliver_trx.quantity / rec_rcv_receipts.quantity;
2094: else
2095: ln_apportion_factor := 1;
2096: end if;
2097: FND_FILE.put_line(FND_FILE.log, 'ln_apportion_factor '|| ln_apportion_factor);
2098: lv_batch_name := NULL;
2099:
2100: FOR rec_get_tax_amount IN cur_get_tax_amount (p_transaction_id,
2101: rec_rcv_receipts.CURRENCY_CONVERSION_RATE,

Line 2118: FND_FILE.put_line(FND_FILE.log, 'ln_apportioned_func_tax_amt '|| ln_apportioned_func_tax_amt||

2114:
2115: ln_apportioned_func_tax_amt := rec_get_tax_amount.functional_tax_amount * ln_apportion_factor;
2116: ln_apportioned_trx_tax_amt := rec_get_tax_amount.transaction_tax_amount * ln_apportion_factor;
2117:
2118: FND_FILE.put_line(FND_FILE.log, 'ln_apportioned_func_tax_amt '|| ln_apportioned_func_tax_amt||
2119: ' rec_get_tax_amount.functional_tax_amount '|| rec_get_tax_amount.functional_tax_amount ||
2120: ' ln_apportioned_trx_tax_amt '|| ln_apportioned_trx_tax_amt ||
2121: ' rec_get_tax_amount.transaction_tax_amount '|| rec_get_tax_amount.transaction_tax_amount);
2122: