[Home] [Help]
157: p_validation := FALSE;
158:
159: -- Setting the status of the interface record to failed and the appropriate
160: -- error code meant for the particular column.
161: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E318', 8405);
162: UPDATE igr_i_info_int
163: SET
164: ERROR_CODE = 'E318',
165: STATUS = '3',
208: l_msg_at_index NUMBER := 0;
209: l_return_status VARCHAR2(1);
210: l_msg_count NUMBER;
211: l_msg_data VARCHAR2(2000);
212: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
213:
214: l_records_processed NUMBER := 0;
215:
216: -----------------------------End Variable Declaration-----------------------------------------
230: x_person_id => p_inq_info_rec.person_id,
231: x_enquiry_appl_number => p_inq_info_rec.enquiry_appl_number,
232: x_info_type_id => p_inq_info_rec.info_type_id);
233:
234: igs_ad_gen_016.extract_msg_from_stack (
235: p_msg_at_index => l_msg_at_index,
236: p_return_status => l_return_status,
237: p_msg_count => l_msg_count,
238: p_msg_data => l_msg_data,
284:
285: l_status := '3';
286: l_error_code := 'E322';
287:
288: igs_ad_gen_016.extract_msg_from_stack (
289: p_msg_at_index => l_msg_at_index,
290: p_return_status => l_return_status,
291: p_msg_count => l_msg_count,
292: p_msg_data => l_msg_data,
421: p_validation := FALSE;
422:
423: -- Setting the status of the interface record to failed and the appropriate
424: -- error code meant for the particular column.
425: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E319', 8405);
426: UPDATE igr_i_char_int
427: SET
428: error_code = 'E319',
429: status = '3',
470: l_msg_at_index NUMBER := 0;
471: l_return_status VARCHAR2(1);
472: l_msg_count NUMBER;
473: l_msg_data VARCHAR2(2000);
474: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
475:
476: l_records_processed NUMBER := 0;
477:
478: BEGIN -- create_inq_char
491: x_enquiry_characteristic_type => p_inq_char_rec.inquiry_characteristic_type,
492: x_mode => 'R');
493:
494: -- If the Insert succeeds then update the Interface records as completed.
495: igs_ad_gen_016.extract_msg_from_stack (
496: p_msg_at_index => l_msg_at_index,
497: p_return_status => l_return_status,
498: p_msg_count => l_msg_count,
499: p_msg_data => l_msg_data,
545:
546: l_status := '3';
547: l_error_code := 'E322';
548:
549: igs_ad_gen_016.extract_msg_from_stack (
550: p_msg_at_index => l_msg_at_index,
551: p_return_status => l_return_status,
552: p_msg_count => l_msg_count,
553: p_msg_data => l_msg_data,
718:
719: OPEN c_package_item(p_inq_pkg_rec.sales_lead_id,l_appl_int_rec.inquiry_type_id,l_appl_int_rec.pkg_reduct_ind);
720: FETCH c_package_item INTO l_exists;
721: IF c_package_item%NOTFOUND THEN
722: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E321', 8405);
723: UPDATE
724: igr_i_pkg_int
725: SET
726: status = '3', -- 'Error'
771: l_msg_at_index NUMBER := 0;
772: l_return_status VARCHAR2(1);
773: l_msg_count NUMBER;
774: l_msg_data VARCHAR2(2000);
775: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
776:
777: -------------------End variable declarations-----------------------------------
778: BEGIN -- create_inq_pkg
779:
843: error_code = NULL,
844: error_text = NULL
845: WHERE rowid = p_inq_pkg_rec.rowid;
846: ELSE
847: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E322', 8405);
848: ROLLBACK TO inqpkg_save;
849: UPDATE igr_i_pkg_int
850: SET status = '3',
851: error_code = 'E322',
857: END IF; -- lb_validation
858: EXCEPTION
859: WHEN OTHERS THEN
860:
861: igs_ad_gen_016.extract_msg_from_stack (
862: p_msg_at_index => l_msg_at_index,
863: p_return_status => l_return_status,
864: p_msg_count => l_msg_count,
865: p_msg_data => l_msg_data,
867:
868: IF l_msg_data IS NOT NULL THEN
869: l_error_text := l_msg_data;
870: ELSE
871: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E322', 8405);
872: END IF;
873:
874: ROLLBACK TO inqpkg_save;
875: UPDATE igr_i_pkg_int