DBA Data[Home] [Help]

APPS.JAI_AP_TOLERANCE_PKG dependencies on JAI_CONSTANTS

Line 156: P_return_code := jai_constants.successful;

152: (p_calling_object => 'apaprvlb.pls',
153: p_org_id => p_org_id,
154: p_set_of_books_id => p_set_of_books_id) = FALSE
155: then
156: P_return_code := jai_constants.successful;
157: P_return_message := 'No need to create adjustment line as IL functionality is used';
158: return;
159: end if;
160:

Line 161: --p_return_code := jai_constants.successful ;

157: P_return_message := 'No need to create adjustment line as IL functionality is used';
158: return;
159: end if;
160:
161: --p_return_code := jai_constants.successful ;
162:
163: lv_vat_code := 'ROUNDING';
164: lv_description := 'Commercial Rounding Off Distribution';
165: ln_user_id := fnd_global.user_id;

Line 211: P_return_code := jai_constants.successful;

207: (for_functional_currency_rec.currency_code <> p_invoice_currency_code) OR
208: (NVL(set_up_values_rec.tolerance_flag,'X') = 'X')
209: ) THEN --0
210: -- there is no diff in header and distribution amount / currency is not INR / tolerance not setup
211: P_return_code := jai_constants.successful;
212: P_return_message := ' No difference found and so no adjustment line created';
213: RETURN;
214: END IF; --1
215:

Line 234: P_return_code := jai_constants.successful;

230: SET amount = 0
231: WHERE invoice_id = p_invoice_id
232: AND line_number = ln_invc_line_num;
233:
234: P_return_code := jai_constants.successful;
235: P_return_message := ' Updated existing rounding line';
236:
237: RETURN;
238:

Line 367: P_return_code := jai_constants.unexpected_error;

363: WHEN OTHERS THEN
364:
365: fnd_file.put_line(FND_FILE.LOG,' Error while inserting JAI Rounding
366: adjustment in ail'|| SQLERRM);
367: P_return_code := jai_constants.unexpected_error;
368: P_return_message := 'Encountered an error in JAI_AP_IA_TRIGGER_PKG.ARUID_T1 ' || substr(sqlerrm,1,1900);
369: END;
370: END IF;
371:

Line 462: P_return_code := jai_constants.unexpected_error;

458: EXCEPTION
459: when others then
460:
461: fnd_file.put_line(FND_FILE.LOG,' Error while inserting JAI Rounding adjustment in aid'|| SQLERRM);
462: P_return_code := jai_constants.unexpected_error;
463: P_return_message := 'Encountered an error in JAI_AP_IA_TRIGGER_PKG.ARUID_T1 ' || substr(sqlerrm,1,1900);
464: END;
465: END IF;
466: -- 5(b)

Line 476: P_return_code := jai_constants.unexpected_error;

472:
473: WHEN OTHERS THEN
474: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AP_IA_TRIGGER_PKG.ARUID_T1 '|| SQLERRM);
475:
476: P_return_code := jai_constants.unexpected_error;
477: P_return_message := 'Encountered an error in JAI_AP_IA_TRIGGER_PKG.ARUID_T1 ' || substr(sqlerrm,1,1900);
478:
479: END inv_holds_check;
480: