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.

[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on JAI_AR_TRX_INS_LINES_T

Line 29: lv_source JAI_AR_TRX_INS_LINES_T.source%TYPE ; --rchandan for bug#4428980

25: var_error_invoice CHAR(1);
26: error_from_called_unit EXCEPTION;
27: var_error_mesg VARCHAR2(1996);
28: v_org_id NUMBER; -- added by sriram - Bug # 2779967
29: lv_source JAI_AR_TRX_INS_LINES_T.source%TYPE ; --rchandan for bug#4428980
30:
31: ln_org_id number ; -- Harshita for Bug 5490479
32: lv_debug varchar2(1) ;
33: lv_process_status VARCHAR2(2);

Line 88: JAI_AR_TRX_INS_LINES_T table . If due to some reason the error message is

84: to write logs from concurrent program.
85: 3 24-May-2002 Sriram. Set the Code so that it works in the batch mode .
86: 4. 09-JAN-2003 Sriram - Bug # 2740546 - File Version is 615.1
87: Added the substr function to the update statement that updates the
88: JAI_AR_TRX_INS_LINES_T table . If due to some reason the error message is
89: very long ,then it can be a potential problem.Because of this the program
90: should not halt.
91: 5. 08/04/2003 Sriram - Bug # 2779967
92: Added logic to see that only records that belong to the current operating unit need

Line 94: JAI_AR_TRX_INS_LINES_T table from various 'India Local Receivables' responsibility

90: should not halt.
91: 5. 08/04/2003 Sriram - Bug # 2779967
92: Added logic to see that only records that belong to the current operating unit need
93: to be picked up for processing.This was done because records are inserted into the
94: JAI_AR_TRX_INS_LINES_T table from various 'India Local Receivables' responsibility
95: attached to various org ids , The concurrent program is not scheduled , but run by
96: the user , it picks up the records not only for the current org id but also for other
97: org ids as well which causes the problem.
98:

Line 269: FROM JAI_AR_TRX_INS_LINES_T

265: lv_source := 'RAXTRX';
266: FOR temp_rec IN
267: (
268: SELECT DISTINCT customer_trx_id
269: FROM JAI_AR_TRX_INS_LINES_T
270: WHERE source = lv_source
271: AND org_id = nvl(ln_org_id, org_id)
272: MINUS
273: SELECT customer_trx_id

Line 274: FROM JAI_AR_TRX_INS_LINES_T temp_dtl

270: WHERE source = lv_source
271: AND org_id = nvl(ln_org_id, org_id)
272: MINUS
273: SELECT customer_trx_id
274: FROM JAI_AR_TRX_INS_LINES_T temp_dtl
275: WHERE source = 'RAXTRX'
276: AND org_id = nvl(ln_org_id, org_id)
277: AND error_flag IN ('R','D')
278: )

Line 378: delete from jai_ar_trx_ins_lines_t

374: END IF; -- lv_process_status <> 'SS'
375: -----------------------------------------------------------------------
376: -- Added by Jia Li for Tax Inclusive Computations on 2007/11/30, End
377: /* ssumaith bug# 6685976(6766561) */
378: delete from jai_ar_trx_ins_lines_t
379: WHERE customer_trx_id = temp_rec.customer_trx_id;
380:
381: END IF;
382:

Line 393: UPDATE JAI_AR_TRX_INS_LINES_T

389: END IF;
390:
391: ROLLBACK;
392:
393: UPDATE JAI_AR_TRX_INS_LINES_T
394: SET ERROR_FLAG = 'R' ,
395: ERR_MESG = SUBSTR(ERRBUF,1,230) -- substr added by sriram Bug # 2740546
396: WHERE CUSTOMER_TRX_ID = var_cust_trx_id;
397:

Line 426: UPDATE JAI_AR_TRX_INS_LINES_T

422: EXCEPTION
423: WHEN OTHERS THEN
424: ROLLBACK;
425:
426: UPDATE JAI_AR_TRX_INS_LINES_T
427: SET ERROR_FLAG = 'R' ,
428: ERR_MESG = SUBSTR(ERRBUF,1,230) -- substr added by sriram Bug # 2740546
429: WHERE CUSTOMER_TRX_ID = var_cust_trx_id;
430:

Line 1069: --get the data from JAI_AR_TRX_INS_LINES_T for customer_trx_id and link_to_cust_trx_line_id

1065: FROM ra_cust_trx_line_gl_dist_all
1066: WHERE customer_trx_id = cp_customer_trx_id
1067: AND account_class IN (lv_account_class_tax,lv_account_class_freight);
1068:
1069: --get the data from JAI_AR_TRX_INS_LINES_T for customer_trx_id and link_to_cust_trx_line_id
1070: CURSOR cur_temp_lines_insert( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1071: cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL)
1072: IS
1073: SELECT *

Line 1071: cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL)

1067: AND account_class IN (lv_account_class_tax,lv_account_class_freight);
1068:
1069: --get the data from JAI_AR_TRX_INS_LINES_T for customer_trx_id and link_to_cust_trx_line_id
1070: CURSOR cur_temp_lines_insert( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1071: cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL)
1072: IS
1073: SELECT *
1074: FROM JAI_AR_TRX_INS_LINES_T
1075: WHERE customer_trx_id = cp_customer_trx_id

Line 1074: FROM JAI_AR_TRX_INS_LINES_T

1070: CURSOR cur_temp_lines_insert( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1071: cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL)
1072: IS
1073: SELECT *
1074: FROM JAI_AR_TRX_INS_LINES_T
1075: WHERE customer_trx_id = cp_customer_trx_id
1076: AND link_to_cust_trx_line_id = NVL(cp_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
1077: ORDER BY link_to_cust_trx_line_id,
1078: customer_trx_line_id;

Line 1258: --get the data from JAI_AR_TRX_INS_LINES_T for customer_trx_id and link_to_cust_trx_line_id

1254: FROM ra_cust_trx_line_gl_dist_all
1255: WHERE customer_trx_id = cp_customer_trx_id
1256: AND account_class IN (lv_account_class_tax,lv_account_class_freight);
1257:
1258: --get the data from JAI_AR_TRX_INS_LINES_T for customer_trx_id and link_to_cust_trx_line_id
1259: CURSOR cur_temp_lines_insert( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1260: cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL)
1261: IS
1262: SELECT *

Line 1260: cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL)

1256: AND account_class IN (lv_account_class_tax,lv_account_class_freight);
1257:
1258: --get the data from JAI_AR_TRX_INS_LINES_T for customer_trx_id and link_to_cust_trx_line_id
1259: CURSOR cur_temp_lines_insert( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1260: cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL)
1261: IS
1262: SELECT *
1263: FROM JAI_AR_TRX_INS_LINES_T
1264: WHERE customer_trx_id = cp_customer_trx_id

Line 1263: FROM JAI_AR_TRX_INS_LINES_T

1259: CURSOR cur_temp_lines_insert( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1260: cp_link_to_cust_trx_line_id JAI_AR_TRX_INS_LINES_T.link_to_cust_trx_line_id%TYPE DEFAULT NULL)
1261: IS
1262: SELECT *
1263: FROM JAI_AR_TRX_INS_LINES_T
1264: WHERE customer_trx_id = cp_customer_trx_id
1265: AND link_to_cust_trx_line_id = NVL(cp_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
1266: ORDER BY link_to_cust_trx_line_id,
1267: customer_trx_line_id;

Line 1328: --Lock all the rows from JAI_AR_TRX_INS_LINES_T for a customer_trx_id, which are to be processed

1324: FROM ra_customer_trx_all
1325: WHERE customer_trx_id = cp_customer_trx_id;
1326:
1327:
1328: --Lock all the rows from JAI_AR_TRX_INS_LINES_T for a customer_trx_id, which are to be processed
1329: CURSOR cur_lock_temp(cp_customer_trx_id JAI_AR_TRX_INS_LINES_T.customer_trx_id%TYPE)
1330: IS
1331: SELECT *
1332: FROM JAI_AR_TRX_INS_LINES_T

Line 1329: CURSOR cur_lock_temp(cp_customer_trx_id JAI_AR_TRX_INS_LINES_T.customer_trx_id%TYPE)

1325: WHERE customer_trx_id = cp_customer_trx_id;
1326:
1327:
1328: --Lock all the rows from JAI_AR_TRX_INS_LINES_T for a customer_trx_id, which are to be processed
1329: CURSOR cur_lock_temp(cp_customer_trx_id JAI_AR_TRX_INS_LINES_T.customer_trx_id%TYPE)
1330: IS
1331: SELECT *
1332: FROM JAI_AR_TRX_INS_LINES_T
1333: WHERE customer_trx_id = cp_customer_trx_id

Line 1332: FROM JAI_AR_TRX_INS_LINES_T

1328: --Lock all the rows from JAI_AR_TRX_INS_LINES_T for a customer_trx_id, which are to be processed
1329: CURSOR cur_lock_temp(cp_customer_trx_id JAI_AR_TRX_INS_LINES_T.customer_trx_id%TYPE)
1330: IS
1331: SELECT *
1332: FROM JAI_AR_TRX_INS_LINES_T
1333: WHERE customer_trx_id = cp_customer_trx_id
1334: FOR UPDATE NOWAIT;
1335:
1336:

Line 1504: --Lock all the rows from JAI_AR_TRX_INS_LINES_T for a customer_trx_id, which are to be processed

1500: BEGIN
1501:
1502: fnd_file.put_line(FND_FILE.LOG, 'START process_imported_invoice');
1503:
1504: --Lock all the rows from JAI_AR_TRX_INS_LINES_T for a customer_trx_id, which are to be processed
1505: FOR i IN cur_lock_temp(p_customer_trx_id)
1506: LOOP
1507: EXIT;
1508: END LOOP;

Line 2329: UPDATE JAI_AR_TRX_INS_LINES_T

2325: fnd_file.put_line(FND_FILE.LOG,sqlerrm);
2326: p_process_status := jai_constants.unexpected_error;
2327: p_process_message :=SUBSTR(SQLERRM,1,120);
2328:
2329: UPDATE JAI_AR_TRX_INS_LINES_T
2330: SET error_flag = 'R',
2331: err_mesg = p_process_message
2332: WHERE customer_trx_id = p_customer_trx_id;
2333: END process_from_order_line;

Line 2364: SELECT count(customer_trx_line_id) FROM JAI_AR_TRX_INS_LINES_T

2360: lv_acc_class_rev CONSTANT varchar2(10) := 'REV';--rchandan for bug#4428980
2361: lv_acc_class_rec CONSTANT varchar2(10) := 'REC';--rchandan for bug#4428980
2362:
2363: CURSOR count_cur IS
2364: SELECT count(customer_trx_line_id) FROM JAI_AR_TRX_INS_LINES_T
2365: WHERE customer_trx_id = P_CUSTOMER_TRX_ID;
2366:
2367: CURSOR ORG_CUR IS
2368: SELECT ORG_ID, CREATED_FROM

Line 2377: FROM JAI_AR_TRX_INS_LINES_T

2373: SELECT EXTENDED_AMOUNT,CUSTOMER_TRX_LINE_ID,CUSTOMER_TRX_ID ,SET_OF_BOOKS_ID,
2374: LINK_TO_CUST_TRX_LINE_ID,LINE_TYPE ,UOM_CODE,VAT_TAX_ID,ACCTD_AMOUNT,AMOUNT,
2375: CODE_COMBINATION_ID,CUST_TRX_LINE_SALES_REP_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
2376: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,INSERT_UPDATE_FLAG
2377: FROM JAI_AR_TRX_INS_LINES_T
2378: WHERE customer_trx_id = P_CUSTOMER_TRX_ID and
2379: link_to_cust_trx_line_id = p_link_line_id
2380: order by CUSTOMER_TRX_LINE_ID;
2381:

Line 2396: WHERE CUSTOMER_TRX_LINE_ID IN (SELECT LINK_TO_CUST_TRX_LINE_ID FROM JAI_AR_TRX_INS_LINES_T

2392:
2393: CURSOR GL_DATE_CUR IS
2394: SELECT DISTINCT gl_date
2395: FROM RA_CUST_TRX_LINE_GL_DIST_ALL
2396: WHERE CUSTOMER_TRX_LINE_ID IN (SELECT LINK_TO_CUST_TRX_LINE_ID FROM JAI_AR_TRX_INS_LINES_T
2397: WHERE customer_trx_id = P_CUSTOMER_TRX_ID);
2398:
2399:
2400: CURSOR MAX_LINE_CUR(p_cust_link_line_id IN NUMBER, p_line_type IN VARCHAR2) IS

Line 2409: FROM JAI_AR_TRX_INS_LINES_T

2405:
2406:
2407: CURSOR LINK_LINE_CUR IS
2408: SELECT LINK_TO_CUST_TRX_LINE_ID,ERROR_FLAG --added the error_flag condition to process the records,which got stuck up
2409: FROM JAI_AR_TRX_INS_LINES_T
2410: WHERE customer_trx_id = P_CUSTOMER_TRX_ID AND LINK_TO_CUST_TRX_LINE_ID = p_link_line_id;
2411:
2412: CURSOR PREVIOUS_AMOUNT_CUR IS
2413: SELECT A.AMOUNT , A.ACCTD_AMOUNT

Line 2414: FROM RA_CUST_TRX_LINE_GL_DIST_ALL A, RA_CUSTOMER_TRX_LINES_ALL B, JAI_AR_TRX_INS_LINES_T C

2410: WHERE customer_trx_id = P_CUSTOMER_TRX_ID AND LINK_TO_CUST_TRX_LINE_ID = p_link_line_id;
2411:
2412: CURSOR PREVIOUS_AMOUNT_CUR IS
2413: SELECT A.AMOUNT , A.ACCTD_AMOUNT
2414: FROM RA_CUST_TRX_LINE_GL_DIST_ALL A, RA_CUSTOMER_TRX_LINES_ALL B, JAI_AR_TRX_INS_LINES_T C
2415: WHERE A.CUSTOMER_TRX_LINE_ID = B.CUSTOMER_TRX_LINE_ID
2416: AND B.LINK_TO_CUST_TRX_LINE_ID = C.LINK_TO_CUST_TRX_LINE_ID
2417: AND C.CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
2418: AND A.ACCOUNT_CLASS IN (lv_tax_const,lv_freight_acc_class)

Line 2691: DELETE JAI_AR_TRX_INS_LINES_T

2687: -- AND v_reason_code = 'RETURN' THEN --commented for the BUG#2247013 as the reason_code can be anything.
2688: FOR tax_type_rec IN tax_type
2689: LOOP
2690: IF tax_type_rec.t_type <> 'Freight' THEN
2691: DELETE JAI_AR_TRX_INS_LINES_T
2692: WHERE customer_trx_id = P_CUSTOMER_TRX_ID
2693: and link_to_cust_trx_line_id = P_LINK_LINE_ID
2694: and customer_trx_line_id = tax_type_rec.line_id
2695: and tax_type_rec.t_type <> jai_constants.tax_type_freight;

Line 3130: DELETE JAI_AR_TRX_INS_LINES_T

3126: end if; --END 22-MAR-02 FOR PROPER UPDATION
3127:
3128: v_sql_num :=33;
3129:
3130: DELETE JAI_AR_TRX_INS_LINES_T
3131: WHERE customer_trx_id = P_CUSTOMER_TRX_ID and
3132: link_to_cust_trx_line_id = P_LINK_LINE_ID;
3133: v_sql_num :=34;
3134:

Line 3148: UPDATE JAI_AR_TRX_INS_LINES_T SET ERROR_FLAG = 'R',ERR_MESG = ERRBUF WHERE

3144: when others then
3145: ERRBUF :=SUBSTR(SQLERRM,1,230);
3146: ROLLBACK TO TEMP_CUR_BLK_SVP;
3147:
3148: UPDATE JAI_AR_TRX_INS_LINES_T SET ERROR_FLAG = 'R',ERR_MESG = ERRBUF WHERE
3149: CUSTOMER_TRX_ID=P_CUSTOMER_TRX_ID
3150: AND LINK_TO_CUST_TRX_LINE_ID = P_LINK_LINE_ID;
3151:
3152: COMMIT;

Line 3299: UPDATE JAI_AR_TRX_INS_LINES_T SET ERROR_FLAG = 'R',ERR_MESG=ERRBUF WHERE CUSTOMER_TRX_ID=P_CUSTOMER_TRX_ID

3295:
3296: WHEN OTHERS THEN
3297:
3298: ERRBUF :=SUBSTR(SQLERRM,1,230);
3299: UPDATE JAI_AR_TRX_INS_LINES_T SET ERROR_FLAG = 'R',ERR_MESG=ERRBUF WHERE CUSTOMER_TRX_ID=P_CUSTOMER_TRX_ID
3300: AND LINK_TO_CUST_TRX_LINE_ID = P_LINK_LINE_ID;
3301: COMMIT;
3302: -- retcode := 7;
3303: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);