394: SELECT bim_r_resp_int_grades_s.NEXTVAL
395: FROM dual;
396:
397: CURSOR c_reason_id IS
398: SELECT bim_r_resp_int_reason_s.NEXTVAL
399: FROM dual;
400:
401: CURSOR c_source_code_ids (c_source_code IN Varchar2) IS
402: SELECT source_code_id ,source_code_for_id ,arc_source_code_for
694: END IF;
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: END IF;
697:
698: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason '||l_interface_reason_id);
699: --dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid reason'||l_local_resp_invalid_table(j) );
700: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid responses'||l_local_resp_inv_count_table(j) );
701:
702: INSERT INTO bim_r_resp_int_reason
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: END IF;
697:
698: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason '||l_interface_reason_id);
699: --dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid reason'||l_local_resp_invalid_table(j) );
700: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid responses'||l_local_resp_inv_count_table(j) );
701:
702: INSERT INTO bim_r_resp_int_reason
703: (
696: END IF;
697:
698: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason '||l_interface_reason_id);
699: --dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid reason'||l_local_resp_invalid_table(j) );
700: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid responses'||l_local_resp_inv_count_table(j) );
701:
702: INSERT INTO bim_r_resp_int_reason
703: (
704: creation_date,
698: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason '||l_interface_reason_id);
699: --dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid reason'||l_local_resp_invalid_table(j) );
700: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid responses'||l_local_resp_inv_count_table(j) );
701:
702: INSERT INTO bim_r_resp_int_reason
703: (
704: creation_date,
705: last_update_date,
706: created_by,
727: );
728:
729: END LOOP;
730:
731: --dbms_output.put_line('end inserting into bim_r_resp_int_reason');
732: END IF;
733:
734: -- Check for commit
735: IF FND_API.to_boolean(p_commit) THEN