201:
202: -- Sanity Validation of the input parameters to raise exception
203: -- We know that this is a function invoked by igsfi071- hence the validation to raise exception only
204: IF (p_d_start_date IS NULL) OR (p_d_end_date IS NULL) THEN
205: app_exception.raise_exception;
206: END IF;
207:
208: IF TRUNC(p_d_start_date) > TRUNC(p_d_end_date) THEN
209: app_exception.raise_exception;
205: app_exception.raise_exception;
206: END IF;
207:
208: IF TRUNC(p_d_start_date) > TRUNC(p_d_end_date) THEN
209: app_exception.raise_exception;
210: END IF;
211:
212: OPEN cur_acct_mth(p_v_accounting_mthd);
213: FETCH cur_acct_mth INTO l_v_accounting_method;
212: OPEN cur_acct_mth(p_v_accounting_mthd);
213: FETCH cur_acct_mth INTO l_v_accounting_method;
214: IF cur_acct_mth%NOTFOUND THEN
215: CLOSE cur_acct_mth;
216: app_exception.raise_exception;
217: END IF;
218: CLOSE cur_acct_mth;
219: -- Sanity Validation of the input parameters to raise exception
220:
371:
372: -- Sanity Validation of the input parameters to raise exception
373: -- We know that this is a function invoked by applications form - hence the validation to raise exception only and not give proper error messages.
374: IF (p_d_gl_date IS NULL) OR (p_n_invoice_id IS NULL) OR (p_n_credit_id IS NULL) THEN
375: app_exception.raise_exception;
376: END IF;
377: -- Sanity Validation of the input parameters to raise exception
378:
379: OPEN cur_inv (p_n_invoice_id);
442: BEGIN
443: -- Sanity Validation of the input parameters to raise exception
444: -- We know that this is a function invoked internally - hence the validation to raise exception only and not give proper error messages.
445: IF (p_n_invoice_id IS NULL) THEN
446: app_exception.raise_exception;
447: END IF;
448: -- Sanity Validation of the input parameters to raise exception
449:
450: -- Loop across the applied credit ids to check if any of them is a neg chag adjustment.