446:
447: /*
448: || make a call to the INR check package.
449: */
450: IF jai_cmn_utils_pkg.check_jai_exists(P_CALLING_OBJECT => 'JAI_AP_ILA_ARIUD_T1', p_set_of_books_id => :new.set_of_books_id ) = FALSE THEN
451: RETURN;
452: END IF;
453:
454: /*
501: WHERE invoice_line_number = :OLD.line_number
502: AND invoice_id = :NEW.invoice_id;
503: END IF;
504: IF ( :NEW.discarded_flag <> :OLD.discarded_flag and :NEW.discarded_flag = 'Y' and :NEW.line_type_lookup_code ='ITEM') Then --Added condition for bug # 12832424
505: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Going inside condition of discarded flag');
506: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Value of invoice_id is'||:NEW.invoice_id);
507: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Value of invoice_line_number is'||:NEW.line_number);
508: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Value of line_type_lookup_code is'||:NEW.line_type_lookup_code);
509:
502: AND invoice_id = :NEW.invoice_id;
503: END IF;
504: IF ( :NEW.discarded_flag <> :OLD.discarded_flag and :NEW.discarded_flag = 'Y' and :NEW.line_type_lookup_code ='ITEM') Then --Added condition for bug # 12832424
505: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Going inside condition of discarded flag');
506: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Value of invoice_id is'||:NEW.invoice_id);
507: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Value of invoice_line_number is'||:NEW.line_number);
508: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Value of line_type_lookup_code is'||:NEW.line_type_lookup_code);
509:
510: JAI_AP_ILA_TRIGGER_PKG.ARU_T1
503: END IF;
504: IF ( :NEW.discarded_flag <> :OLD.discarded_flag and :NEW.discarded_flag = 'Y' and :NEW.line_type_lookup_code ='ITEM') Then --Added condition for bug # 12832424
505: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Going inside condition of discarded flag');
506: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Value of invoice_id is'||:NEW.invoice_id);
507: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Value of invoice_line_number is'||:NEW.line_number);
508: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Value of line_type_lookup_code is'||:NEW.line_type_lookup_code);
509:
510: JAI_AP_ILA_TRIGGER_PKG.ARU_T1
511: ( pr_old => t_old_rec
504: IF ( :NEW.discarded_flag <> :OLD.discarded_flag and :NEW.discarded_flag = 'Y' and :NEW.line_type_lookup_code ='ITEM') Then --Added condition for bug # 12832424
505: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Going inside condition of discarded flag');
506: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Value of invoice_id is'||:NEW.invoice_id);
507: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Value of invoice_line_number is'||:NEW.line_number);
508: jai_cmn_utils_pkg.write_fnd_log_msg('trigger_on_lines_all','Value of line_type_lookup_code is'||:NEW.line_type_lookup_code);
509:
510: JAI_AP_ILA_TRIGGER_PKG.ARU_T1
511: ( pr_old => t_old_rec
512: , pr_new => t_new_rec