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 235: P_return_code := jai_constants.successful;

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

Line 368: P_return_code := jai_constants.unexpected_error;

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

Line 463: P_return_code := jai_constants.unexpected_error;

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

Line 477: P_return_code := jai_constants.unexpected_error;

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