DBA Data[Home] [Help]

APPS.JG_ZZ_AR_AUTO_INVOICE dependencies on JA_TW_SH_GUI_UTILS

Line 153: l_debug_loc := 'ja_tw_sh_gui_utils.get_trx_src_info';

149: Into l_batch_source_id
150: From fnd_concurrent_requests cr
151: Where request_id = p_request_id;
152:
153: l_debug_loc := 'ja_tw_sh_gui_utils.get_trx_src_info';
154: ja_tw_sh_gui_utils.get_trx_src_info(
155: l_batch_source_id
156: ,l_auto_trx_num_flag
157: ,l_inv_word

Line 154: ja_tw_sh_gui_utils.get_trx_src_info(

150: From fnd_concurrent_requests cr
151: Where request_id = p_request_id;
152:
153: l_debug_loc := 'ja_tw_sh_gui_utils.get_trx_src_info';
154: ja_tw_sh_gui_utils.get_trx_src_info(
155: l_batch_source_id
156: ,l_auto_trx_num_flag
157: ,l_inv_word
158: ,l_init_trx_num

Line 164: l_seq_name := ja_tw_sh_gui_utils.get_seq_name(l_batch_source_id);

160: ,l_last_trx_date
161: ,l_adv_days
162: ,l_org_id);
163:
164: l_seq_name := ja_tw_sh_gui_utils.get_seq_name(l_batch_source_id);
165:
166: BEGIN
167: SELECT COPY_DOC_NUMBER_FLAG INTO l_copy_doc_num_flag FROM RA_BATCH_SOURCES_ALL
168: WHERE BATCH_SOURCE_ID = l_batch_source_id

Line 177: l_debug_loc := 'ja_tw_sh_gui_utils.val_trx_num';

173: END;
174:
175: If trx_number.count > 0 and l_copy_doc_num_flag <> 'Y' Then
176: For i in customer_trx_id.FIRST .. customer_trx_id.LAST Loop
177: l_debug_loc := 'ja_tw_sh_gui_utils.val_trx_num';
178: If ja_tw_sh_gui_utils.val_trx_num(
179: NULL
180: ,l_batch_source_id
181: ,l_fin_trx_num

Line 178: If ja_tw_sh_gui_utils.val_trx_num(

174:
175: If trx_number.count > 0 and l_copy_doc_num_flag <> 'Y' Then
176: For i in customer_trx_id.FIRST .. customer_trx_id.LAST Loop
177: l_debug_loc := 'ja_tw_sh_gui_utils.val_trx_num';
178: If ja_tw_sh_gui_utils.val_trx_num(
179: NULL
180: ,l_batch_source_id
181: ,l_fin_trx_num
182: ,'RAXTRX') = 'FATAL' Then

Line 185: ja_tw_sh_gui_utils.get_next_seq_num(

181: ,l_fin_trx_num
182: ,'RAXTRX') = 'FATAL' Then
183: Exit;
184: Else
185: ja_tw_sh_gui_utils.get_next_seq_num(
186: l_seq_name
187: ,l_seq_number
188: ,l_err_code);
189: l_trx_number := l_inv_word || LPAD(l_seq_number,8,'0');

Line 468: ja_tw_sh_gui_utils.get_trx_src_info(

464: FROM RA_BATCH_SOURCES_ALL
465: WHERE batch_source_id = l_batch_source_id;
466:
467: l_debug_loc := 'Getting Transaction Source details';
468: ja_tw_sh_gui_utils.get_trx_src_info(
469: l_batch_source_id
470: ,l_auto_trx_num_flag
471: ,l_inv_word
472: ,l_init_trx_num

Line 478: l_seq_name := ja_tw_sh_gui_utils.get_seq_name(l_batch_source_id);

474: ,l_last_trx_date
475: ,l_adv_days
476: ,l_org_id);
477:
478: l_seq_name := ja_tw_sh_gui_utils.get_seq_name(l_batch_source_id);
479: l_last_trx_num := ja_tw_sh_gui_utils.get_last_trx_num(l_seq_name);
480:
481: --fnd_message.set_name( 'JA','JA_TW_GUI_NUM_OVERLIMIT_CHQ');
482: fnd_message.set_name( 'JA','JA_TW_AR_GUI_NUM_OUT_OF_RANGE');

Line 479: l_last_trx_num := ja_tw_sh_gui_utils.get_last_trx_num(l_seq_name);

475: ,l_adv_days
476: ,l_org_id);
477:
478: l_seq_name := ja_tw_sh_gui_utils.get_seq_name(l_batch_source_id);
479: l_last_trx_num := ja_tw_sh_gui_utils.get_last_trx_num(l_seq_name);
480:
481: --fnd_message.set_name( 'JA','JA_TW_GUI_NUM_OVERLIMIT_CHQ');
482: fnd_message.set_name( 'JA','JA_TW_AR_GUI_NUM_OUT_OF_RANGE');
483: fnd_message.set_token('BATCH_SOURCE_NAME',l_batch_source_name);