APPS.JAI_JAP_TY_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 21: pv_return_code := jai_constants.successful ;

17: v_leg_org_tan_num jai_ap_tds_org_tan_v.org_tan_num%TYPE;--- 4323338
18: v_opt_unit_id NUMBER;
19:
20: BEGIN
21: pv_return_code := jai_constants.successful ;
22: /*------------------------------------------------------------------------------------------------------------
23: Trigger Functionality:
24: When a new TDS year is defined, then this trigger gets fired and inserts data into JAI_AP_TDS_CERT_NUMS for
25: any organization (legal entity/operating unit) in which tan number is defined. If tan number is not defined for

Line 73: pv_return_code := jai_constants.successful ;

69:
70:
71: -- Start, Vijay Shankar for Bug# 2762636
72: BEGIN
73: pv_return_code := jai_constants.successful ;
74: /*
75: SELECT org_tan_num
76: INTO v_leg_org_tan_num
77: FROM jai_ap_tds_org_tan_v --4323338

Line 187: Pv_return_code := jai_constants.expected_error;

183: EXCEPTION
184: WHEN NO_DATA_FOUND THEN
185: --RAISE_APPLICATION_ERROR(-20009, 'Tan Number has not been defined for this legal entity / operating unit->'||v_opt_unit_id);
186: /* Added an exception block by Ramananda for bug#4570303 */
187: Pv_return_code := jai_constants.expected_error;
188: Pv_return_message := 'Tan Number has not been defined for this legal entity / operating unit->'||v_opt_unit_id ;
189:
190: WHEN OTHERS THEN
191: --RAISE_APPLICATION_ERROR(-20008, 'Exception from ja_in_fin_year_cert_trg :' || LTRIM(RTRIM(SQLERRM)));

Line 193: Pv_return_code := jai_constants.unexpected_error;

189:
190: WHEN OTHERS THEN
191: --RAISE_APPLICATION_ERROR(-20008, 'Exception from ja_in_fin_year_cert_trg :' || LTRIM(RTRIM(SQLERRM)));
192: /* Added an exception block by Ramananda for bug#4570303 */
193: Pv_return_code := jai_constants.unexpected_error;
194: Pv_return_message := 'Encountered an error in JAI_JAP_TY_TRIGGER_PKG.ARI_T1 ' || substr(sqlerrm,1,1900);
195:
196:
197: END ARI_T1 ;