DBA Data[Home] [Help]

APPS.JAI_AR_CR_PKG dependencies on JAI_CONSTANTS

Line 30: p_process_flag := jai_constants.successful;

26: AND r_method.receipt_method_id = cp_receipt_method_id
27: );
28: lv_regime_code varchar2(50);
29: BEGIN
30: p_process_flag := jai_constants.successful;
31:
32: /*Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952 Begin*/
33: OPEN c_get_regime_code (p_new.receipt_method_id);
34: FETCH c_get_regime_code INTO lv_regime_code;

Line 36: IF upper(nvl(lv_regime_code,'####')) = jai_constants.tcs_regime THEN

32: /*Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952 Begin*/
33: OPEN c_get_regime_code (p_new.receipt_method_id);
34: FETCH c_get_regime_code INTO lv_regime_code;
35: CLOSE c_get_regime_code;
36: IF upper(nvl(lv_regime_code,'####')) = jai_constants.tcs_regime THEN
37: jai_ar_tcs_rep_pkg.process_transactions(
38: p_acra => p_new,
39: p_event => p_event,
40: p_process_flag => lv_process_flag,

Line 42: ELSIF upper(nvl(lv_regime_code,'####')) = jai_constants.service_regime THEN

38: p_acra => p_new,
39: p_event => p_event,
40: p_process_flag => lv_process_flag,
41: p_process_message => lv_process_message);
42: ELSIF upper(nvl(lv_regime_code,'####')) = jai_constants.service_regime THEN
43: jai_ar_rgm_processing_pkg.process_st_advance_receipts(
44: p_acra => p_new,
45: p_event => p_event,
46: p_process_flag => lv_process_flag,

Line 51: IF NVL(lv_process_flag,'XX') <> jai_constants.successful THEN

47: p_process_message => lv_process_message);
48: END IF;
49: /*Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952 End*/
50:
51: IF NVL(lv_process_flag,'XX') <> jai_constants.successful THEN
52: raise_application_error(-20011, lv_process_message);
53: END IF;
54: EXCEPTION
55: WHEN OTHERS THEN

Line 56: p_process_flag := jai_constants.unexpected_error;

52: raise_application_error(-20011, lv_process_message);
53: END IF;
54: EXCEPTION
55: WHEN OTHERS THEN
56: p_process_flag := jai_constants.unexpected_error;
57: p_process_message := SUBSTR(SQLERRM,1,100);
58: END process_cm_dm;
59:
60: END;