APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on JAI_CONSTANTS

Line 39: WHERE regime_code = jai_constants.service_regime

35: select to_date(attribute_value, 'DD/MM/YYYY')
36: from JAI_RGM_ORG_REGNS_V
37: where regime_id IN (SELECT regime_id
38: FROM jai_rgm_definitions
39: WHERE regime_code = jai_constants.service_regime
40: )
41: and organization_id = p_organization_id
42: and location_id = p_location_id
43: AND attribute_code = 'EFF_DATE_ST_PT'

Line 51: WHERE regime_code = jai_constants.service_regime

47: (select '1'
48: from JAI_RGM_ORG_REGNS_V
49: where regime_id IN (SELECT regime_id
50: FROM jai_rgm_definitions
51: WHERE regime_code = jai_constants.service_regime
52: )
53: and attribute_code IN 'INV_ORG_CLASSIFICATION'
54: and attribute_value <> 'ORGANIZATION'
55: and organization_id = p_organization_id

Line 63: WHERE regime_code = jai_constants.service_regime

59: (select '1'
60: from JAI_RGM_ORG_REGNS_V
61: where regime_id IN (SELECT regime_id
62: FROM jai_rgm_definitions
63: WHERE regime_code = jai_constants.service_regime
64: )
65: and attribute_code IN 'SERVICE TYPE'
66: and attribute_value <> 'OTHER'
67: and organization_id = p_organization_id

Line 515: p_process_flag := jai_constants.SUCCESSFUL;

511:
512: BEGIN
513: lv_member_name := 'EXTRACT_ST_REVERSAL_TRXS';
514: set_debug_context;
515: p_process_flag := jai_constants.SUCCESSFUL;
516: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
517: , pn_reg_id => ln_reg_id
518: );
519:

Line 622: p_process_flag := jai_constants.EXPECTED_ERROR;

618: CLOSE c_max_prepayment_date;
619:
620: IF ld_max_prepayment_date IS NULL AND ld_max_payment_date IS NULL THEN
621: p_process_message := 'When payment status is Y but neither payment nor prepayment.';
622: p_process_flag := jai_constants.EXPECTED_ERROR;
623: return;
624:
625: END IF;
626: ld_max_payment_date := get_max_date(ld_max_payment_date,ld_max_prepayment_date);

Line 722: p_process_flag := jai_constants.EXPECTED_ERROR;

718: CLOSE c_max_prepayment_date;
719:
720: IF ld_max_prepayment_date IS NULL AND ld_max_payment_date IS NULL THEN
721: p_process_message := 'When payment status is Y but neither payment nor prepayment.';
722: p_process_flag := jai_constants.EXPECTED_ERROR;
723: return;
724:
725: END IF;
726: ld_max_payment_date := get_max_date(ld_max_payment_date,ld_max_prepayment_date);

Line 872: p_process_flag := jai_constants.unexpected_error;

868: END LOOP;
869: END IF;
870: exception
871: when others then
872: p_process_flag := jai_constants.unexpected_error;
873: p_process_message := lv_context||'->'||sqlerrm;
874: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
875: jai_cmn_debug_contexts_pkg.print_stack;
876: END extract_reversal_trxs;