127: /* End - BUG 14364091 - Logging */
128:
129: select next_voucher_number
130: into l_next_voucher_number
131: from ap_inv_selection_criteria_all
132: where checkrun_id = p_checkrun_id
133: for update;
134:
135: if l_next_voucher_number is null then
153:
154:
155: end loop;
156: /* Start - BUG 14364091 - Logging */
157: l_debug_info := 'updating ap_inv_selection_criteria_all with voucher number ';
158: /* End - BUG 14364091 - Logging */
159: update ap_inv_selection_criteria_all
160: set next_voucher_number = l_next_voucher_number
161: where checkrun_id = p_checkrun_id;
155: end loop;
156: /* Start - BUG 14364091 - Logging */
157: l_debug_info := 'updating ap_inv_selection_criteria_all with voucher number ';
158: /* End - BUG 14364091 - Logging */
159: update ap_inv_selection_criteria_all
160: set next_voucher_number = l_next_voucher_number
161: where checkrun_id = p_checkrun_id;
162:
163: /* Start - BUG 14364091 - Logging */
606: p_rejected_docs_group_id IN NUMBER) IS
607:
608:
609: l_checkrun_id number;
610: l_checkrun_name ap_inv_selection_criteria_all.checkrun_name%type;
611: l_check_date date;
612: l_debug_info varchar2(200);
613: /* Start - BUG 14364091 - Logging */
614: l_api_name varchar2(30);
671: BEGIN
672:
673: select checkrun_name, check_date
674: into l_checkrun_name, l_check_date
675: from ap_inv_selection_criteria_all
676: where checkrun_id = l_checkrun_id;
677:
678: OPEN c_sel_invs;
679:
1155: l_transfer_priority,
1156: l_check_date, --use this for the exchange date also, PM confirmed
1157: l_checkrun_name,
1158: l_first_voucher_number
1159: FROM ap_inv_selection_criteria_all
1160: WHERE checkrun_id = l_checkrun_id;
1161:
1162: l_debug_info := 'get_terms';
1163: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);