[Home] [Help]
400: p_globals.create_detailed_dist_flag_t,
401: p_globals.default_rct_mthd_for_lc_inv_t
402: from
403: gl_sets_of_books sob,
404: fnd_currencies fc,
405: jtf_rs_salesreps rs,
406: ar_system_parameters sp,
407: zx_product_options zxpo
408: where sp.set_of_books_id = sob.set_of_books_id
734: p_globals.create_detailed_dist_flag_t,
735: p_globals.default_rct_mthd_for_lc_inv_t
736: from
737: gl_sets_of_books sob,
738: fnd_currencies fc,
739: jtf_rs_salesreps rs,
740: ar_system_parameters sp,
741: zx_product_options zxpo
742: where sp.set_of_books_id = sob.set_of_books_id
781: APP_EXCEPTION.raise_exception;
782: RAISE;
783: end;
784: /* ---------------------------------------------
785: Check row exists in fnd_currencies
786: ---------------------------------------------- */
787: begin
788: SELECT 'x' into l_sob_test
789: FROM ar_system_parameters sp, gl_sets_of_books sob, fnd_currencies c
785: Check row exists in fnd_currencies
786: ---------------------------------------------- */
787: begin
788: SELECT 'x' into l_sob_test
789: FROM ar_system_parameters sp, gl_sets_of_books sob, fnd_currencies c
790: WHERE sob.set_of_books_id = sp.set_of_books_id
791: and sp.org_id = REC.org_id
792: and sob.currency_code = c.currency_code;
793:
794: exception when no_data_found then
795: IF PG_DEBUG in ('Y', 'C') THEN
796: arp_util.debug('EXCEPTION: NO_DATA_FOUND IN CURRENCIES - ar_mo_cache_utils.retrieve_globals' );
797: END IF;
798: FND_MESSAGE.set_name('AR','AR_NO_ROW_IN_FND_CURRENCIES');
799: APP_EXCEPTION.raise_exception;
800: RAISE; --end of WHEN NO DATA FOUND
801: end;
802: