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_AP_ILA_TRIGGER_PKG dependencies on JAI_CMN_UTILS_PKG

Line 32: jai_cmn_utils_pkg.write_fnd_log_msg('After update trigger','Inside trigger after update');

28: where invoice_id = pr_new.invoice_id
29: and invoice_line_number = pr_new.line_number
30: and po_distribution_id is null;
31:
32: jai_cmn_utils_pkg.write_fnd_log_msg('After update trigger','Inside trigger after update');
33: /*bug 8425058
34: *Issue - "To Insert Tax Distributions" concurrent is not firing when invoice is
35: *matched to PO using the "Quick Match" option in the invoice workbench.
36: *Reason - po_distribution_id is null when row is inserted in ap_invoice_lines_all.

Line 40: jai_cmn_utils_pkg.write_fnd_log_msg('After update trigger','Value of invoice_id'||pr_new.invoice_id);

36: *Reason - po_distribution_id is null when row is inserted in ap_invoice_lines_all.
37: *So the procedure ARI_T1 exits without firing the program.
38: *Fix - Call the ARI_T1 procedure from ARU_T1 when the invoice source is not ERS.*/
39:
40: jai_cmn_utils_pkg.write_fnd_log_msg('After update trigger','Value of invoice_id'||pr_new.invoice_id);
41: SELECT source INTO lv_source
42: FROM ap_invoices_all
43: WHERE invoice_id = pr_new.invoice_id;
44:

Line 45: jai_cmn_utils_pkg.write_fnd_log_msg('After update trigger','Value of source is'||lv_source);

41: SELECT source INTO lv_source
42: FROM ap_invoices_all
43: WHERE invoice_id = pr_new.invoice_id;
44:
45: jai_cmn_utils_pkg.write_fnd_log_msg('After update trigger','Value of source is'||lv_source);
46:
47: --Added this IF condition to process only Discard of ERS invoices for bug # 12832424
48: IF ( Nvl(lv_source,'XX') = 'ERS' and pr_new.discarded_flag ='Y' and pr_new.discarded_flag <> nvl(pr_old.discarded_flag,'N') and pr_new.line_type_lookup_code ='ITEM') then
49: ari_t1 (pr_old, pr_new, pv_action, pv_return_code, pv_return_message);

Line 51: jai_cmn_utils_pkg.write_fnd_log_msg('After update trigger','Calling After insert trigger');

47: --Added this IF condition to process only Discard of ERS invoices for bug # 12832424
48: IF ( Nvl(lv_source,'XX') = 'ERS' and pr_new.discarded_flag ='Y' and pr_new.discarded_flag <> nvl(pr_old.discarded_flag,'N') and pr_new.line_type_lookup_code ='ITEM') then
49: ari_t1 (pr_old, pr_new, pv_action, pv_return_code, pv_return_message);
50: Elsif Nvl(lv_source,'XX') <> 'ERS' THEN
51: jai_cmn_utils_pkg.write_fnd_log_msg('After update trigger','Calling After insert trigger');
52: ari_t1 (pr_old, pr_new, pv_action, pv_return_code, pv_return_message);
53: END IF;
54:
55: /*end bug 8425058*/

Line 326: --IF JAI_CMN_UTILS_PKG.CHECK_JAI_EXISTS( p_calling_object => 'JAIN_TDSTEMP_AFTERINSERT_TRG',

322:
323: added the pr_new.po_header_id is not null condition for PO matched debit memo
324:
325: ------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
326: --IF JAI_CMN_UTILS_PKG.CHECK_JAI_EXISTS( p_calling_object => 'JAIN_TDSTEMP_AFTERINSERT_TRG',
327: -- p_set_of_books_id => pr_new.set_of_books_id) = FALSE
328: --THEN
329: -- RETURN;
330: --END IF;

Line 354: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside after insert trigger');

350: END;
351:
352: END IF;
353:
354: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside after insert trigger');
355: OPEN fetch_recpt_num_cur;
356: FETCH fetch_recpt_num_cur INTO v_receipt_num, v_source;
357: CLOSE fetch_recpt_num_cur;
358:

Line 359: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of receipt_num is '||v_receipt_num);

355: OPEN fetch_recpt_num_cur;
356: FETCH fetch_recpt_num_cur INTO v_receipt_num, v_source;
357: CLOSE fetch_recpt_num_cur;
358:
359: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of receipt_num is '||v_receipt_num);
360: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of source is '||v_source);
361: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of invoice_id is '||pr_new.invoice_id);
362:
363: OPEN vend_info(pr_new.invoice_id);

Line 360: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of source is '||v_source);

356: FETCH fetch_recpt_num_cur INTO v_receipt_num, v_source;
357: CLOSE fetch_recpt_num_cur;
358:
359: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of receipt_num is '||v_receipt_num);
360: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of source is '||v_source);
361: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of invoice_id is '||pr_new.invoice_id);
362:
363: OPEN vend_info(pr_new.invoice_id);
364: FETCH vend_info INTO vend_info_rec;

Line 361: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of invoice_id is '||pr_new.invoice_id);

357: CLOSE fetch_recpt_num_cur;
358:
359: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of receipt_num is '||v_receipt_num);
360: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of source is '||v_source);
361: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of invoice_id is '||pr_new.invoice_id);
362:
363: OPEN vend_info(pr_new.invoice_id);
364: FETCH vend_info INTO vend_info_rec;
365: CLOSE vend_info;

Line 508: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of invoice_id is '|| pr_new.invoice_id);

504: ||', v_count_tax_dist -> ' || v_count_tax_dist
505: ||', v_source -> ' || v_source
506: );
507:
508: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of invoice_id is '|| pr_new.invoice_id);
509: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of po_distribution_id -> is '||pr_new.po_distribution_id);
510: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of rcv_transacion_id -> is '||pr_new.rcv_transaction_id);
511: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of match_type -> is '||pr_new.match_type);
512: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of line_type_lookup_code -> '||pr_new.line_type_lookup_code);

Line 509: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of po_distribution_id -> is '||pr_new.po_distribution_id);

505: ||', v_source -> ' || v_source
506: );
507:
508: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of invoice_id is '|| pr_new.invoice_id);
509: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of po_distribution_id -> is '||pr_new.po_distribution_id);
510: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of rcv_transacion_id -> is '||pr_new.rcv_transaction_id);
511: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of match_type -> is '||pr_new.match_type);
512: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of line_type_lookup_code -> '||pr_new.line_type_lookup_code);
513: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of v_count_tax_dist -> '||v_count_tax_dist);

Line 510: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of rcv_transacion_id -> is '||pr_new.rcv_transaction_id);

506: );
507:
508: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of invoice_id is '|| pr_new.invoice_id);
509: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of po_distribution_id -> is '||pr_new.po_distribution_id);
510: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of rcv_transacion_id -> is '||pr_new.rcv_transaction_id);
511: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of match_type -> is '||pr_new.match_type);
512: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of line_type_lookup_code -> '||pr_new.line_type_lookup_code);
513: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of v_count_tax_dist -> '||v_count_tax_dist);
514:

Line 511: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of match_type -> is '||pr_new.match_type);

507:
508: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of invoice_id is '|| pr_new.invoice_id);
509: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of po_distribution_id -> is '||pr_new.po_distribution_id);
510: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of rcv_transacion_id -> is '||pr_new.rcv_transaction_id);
511: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of match_type -> is '||pr_new.match_type);
512: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of line_type_lookup_code -> '||pr_new.line_type_lookup_code);
513: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of v_count_tax_dist -> '||v_count_tax_dist);
514:
515: /* Bug 5361931. Added by Lakshmi Gopalsami

Line 512: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of line_type_lookup_code -> '||pr_new.line_type_lookup_code);

508: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of invoice_id is '|| pr_new.invoice_id);
509: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of po_distribution_id -> is '||pr_new.po_distribution_id);
510: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of rcv_transacion_id -> is '||pr_new.rcv_transaction_id);
511: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of match_type -> is '||pr_new.match_type);
512: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of line_type_lookup_code -> '||pr_new.line_type_lookup_code);
513: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of v_count_tax_dist -> '||v_count_tax_dist);
514:
515: /* Bug 5361931. Added by Lakshmi Gopalsami
516: * Instead of blindly checking for po_distribution_id is not null

Line 513: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of v_count_tax_dist -> '||v_count_tax_dist);

509: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of po_distribution_id -> is '||pr_new.po_distribution_id);
510: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of rcv_transacion_id -> is '||pr_new.rcv_transaction_id);
511: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of match_type -> is '||pr_new.match_type);
512: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of line_type_lookup_code -> '||pr_new.line_type_lookup_code);
513: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Value of v_count_tax_dist -> '||v_count_tax_dist);
514:
515: /* Bug 5361931. Added by Lakshmi Gopalsami
516: * Instead of blindly checking for po_distribution_id is not null
517: * split the condition depending on match_type.

Line 553: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition 1');

549: pr_new.amount >= 0 and
550: v_count_tax_dist = 0
551: THEN
552:
553: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition 1');
554: v_rematching := 'PAY_ON_RECEIPT';
555:
556: INSERT INTO JAI_AP_MATCH_ERS_T
557: (

Line 604: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition 2');

600: )
601: OR (v_source = 'SUPPLEMENT')
602:
603: THEN
604: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition 2');
605: v_rematching := 'RCV_MATCHING';
606: result := Fnd_Request.set_mode(TRUE);
607: req_id := Fnd_Request.submit_request
608: (

Line 645: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition 3');

641: /* Added above or condition for bug 16100273 */
642: v_source NOT IN ('ERS', 'ASBN')
643: )
644: THEN
645: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition 3');
646: v_rematching := 'RCV_MATCHING';
647: result := Fnd_Request.set_mode(TRUE);
648: req_id := Fnd_Request.submit_request
649: (

Line 681: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition 4');

677: (pr_new.PO_DISTRIBUTION_ID IS NOT NULL OR pr_new.po_header_id IS NOT NULL) /*bug 9346307*/
678: AND (v_source NOT IN ('ERS', 'ASBN')) -- cbabu for bug # 2665306
679: )
680: THEN
681: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition 4');
682: v_rematching := 'PO_MATCHING';
683: result := Fnd_Request.set_mode(TRUE);
684: req_id := Fnd_Request.submit_request
685: (

Line 719: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition 5');

715: (vend_info_rec.invoice_type_lookup_code = 'DEBIT' ) AND
716: (vend_info_rec.cancelled_date IS NULL)
717: )
718: THEN
719: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition 5');
720:
721: IF v_source = 'RTS' THEN
722: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition of RTS');
723: v_receipt_code := 'RECEIPT';

Line 722: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition of RTS');

718: THEN
719: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition 5');
720:
721: IF v_source = 'RTS' THEN
722: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition of RTS');
723: v_receipt_code := 'RECEIPT';
724: v_rematching := 'PAY_ON_RECEIPT';
725: INSERT INTO JAI_AP_MATCH_ERS_T (
726: invoice_id, invoice_line_number, -- Bug# 4445989

Line 743: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition of Manual entry');

739: );
740:
741: ELSIF v_source = 'Manual Invoice Entry' THEN -- this code will be fired if v_source (i.e AP_INVOICES_ALL.source) is 'Manual Invoice Entry'
742:
743: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition of Manual entry');
744:
745: v_rematching := null;
746: IF (pr_new.match_type = 'ITEM_TO_PO' )
747: /* OR (pr_new.match_type IS NULL AND pr_new.parent_invoice_id IS NOT NULL) -- cbabu for Bug# 2717471 */