DBA Data[Home] [Help]

APPS.IGS_AD_IMP_003 dependencies on IGS_AD_IMP_001

Line 203: igs_ad_imp_001.logerrormessage(c_acadint_rec.interface_acadint_id,l_msg_data);

199: error_text = l_error_text
200: WHERE rowid = c_acadint_rec.rowid;
201:
202: IF l_enable_log = 'Y' THEN
203: igs_ad_imp_001.logerrormessage(c_acadint_rec.interface_acadint_id,l_msg_data);
204: END IF;
205:
206: ELSIF l_type = 'S' THEN
207: UPDATE igs_ad_acadint_int

Line 214: igs_ad_imp_001.logerrormessage(c_acadint_rec.interface_acadint_id,l_msg_data);

210: error_text = l_error_text
211: WHERE rowid = c_acadint_rec.rowid;
212:
213: IF l_enable_log = 'Y' THEN
214: igs_ad_imp_001.logerrormessage(c_acadint_rec.interface_acadint_id,l_msg_data);
215: END IF;
216:
217: ELSIF l_type IS NULL THEN
218: UPDATE igs_ad_acadint_int

Line 268: igs_ad_imp_001.logerrormessage(c_acadint_rec.interface_acadint_id,l_msg_data);

264: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
265:
266: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
267: IF l_enable_log = 'Y' THEN
268: igs_ad_imp_001.logerrormessage(c_acadint_rec.interface_acadint_id,l_msg_data);
269: END IF;
270: ELSE
271:
272: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

Line 509: igs_ad_imp_001.logerrormessage(l_appint_rec.interface_appint_id,l_msg_data);

505: error_text = l_error_text
506: WHERE rowid = l_appint_rec.rowid;
507:
508: IF l_enable_log = 'Y' THEN
509: igs_ad_imp_001.logerrormessage(l_appint_rec.interface_appint_id,l_msg_data);
510: END IF;
511:
512: ELSIF l_type = 'S' THEN
513: UPDATE igs_ad_appint_int

Line 520: igs_ad_imp_001.logerrormessage(l_appint_rec.interface_appint_id,l_msg_data);

516: error_text = l_error_text
517: WHERE rowid = l_appint_rec.rowid;
518:
519: IF l_enable_log = 'Y' THEN
520: igs_ad_imp_001.logerrormessage(l_appint_rec.interface_appint_id,l_msg_data);
521: END IF;
522:
523: ELSIF l_type IS NULL THEN
524: UPDATE igs_ad_appint_int

Line 572: igs_ad_imp_001.logerrormessage(l_appint_rec.interface_appint_id,l_msg_data);

568: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
569:
570: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
571: IF l_enable_log = 'Y' THEN
572: igs_ad_imp_001.logerrormessage(l_appint_rec.interface_appint_id,l_msg_data);
573: END IF;
574:
575: ELSE
576:

Line 768: igs_ad_imp_001.logerrormessage(l_oth_inst_rec.interface_othinst_id,l_msg_data);

764: error_text = l_error_text
765: WHERE rowid = l_oth_inst_rec.rowid;
766:
767: IF l_enable_log = 'Y' THEN
768: igs_ad_imp_001.logerrormessage(l_oth_inst_rec.interface_othinst_id,l_msg_data);
769: END IF;
770:
771: ELSIF l_type = 'S' THEN
772: UPDATE igs_ad_othinst_int

Line 779: igs_ad_imp_001.logerrormessage(l_oth_inst_rec.interface_othinst_id,l_msg_data);

775: error_text = l_error_text
776: WHERE rowid = l_oth_inst_rec.rowid;
777:
778: IF l_enable_log = 'Y' THEN
779: igs_ad_imp_001.logerrormessage(l_oth_inst_rec.interface_othinst_id,l_msg_data);
780: END IF;
781:
782: ELSIF l_type IS NULL THEN
783: UPDATE igs_ad_othinst_int

Line 830: igs_ad_imp_001.logerrormessage(l_oth_inst_rec.interface_othinst_id,l_msg_data);

826: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
827:
828: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
829: IF l_enable_log = 'Y' THEN
830: igs_ad_imp_001.logerrormessage(l_oth_inst_rec.interface_othinst_id,l_msg_data);
831: END IF;
832: ELSE
833: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
834: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_oth_inst_apld.exception '||'E322';

Line 1004: igs_ad_imp_001.logerrormessage(l_spl_intrst_rec.interface_splint_id,l_msg_data);

1000: error_text = l_error_text
1001: WHERE rowid = l_spl_intrst_rec.rowid;
1002:
1003: IF l_enable_log = 'Y' THEN
1004: igs_ad_imp_001.logerrormessage(l_spl_intrst_rec.interface_splint_id,l_msg_data);
1005: END IF;
1006:
1007:
1008: ELSIF l_type = 'S' THEN

Line 1016: igs_ad_imp_001.logerrormessage(l_spl_intrst_rec.interface_splint_id,l_msg_data);

1012: error_text = l_error_text
1013: WHERE rowid = l_spl_intrst_rec.rowid;
1014:
1015: IF l_enable_log = 'Y' THEN
1016: igs_ad_imp_001.logerrormessage(l_spl_intrst_rec.interface_splint_id,l_msg_data);
1017: END IF;
1018:
1019: ELSIF l_type IS NULL THEN
1020: UPDATE IGS_AD_SPLINT_INT

Line 1068: igs_ad_imp_001.logerrormessage(l_spl_intrst_rec.interface_splint_id,l_msg_data);

1064: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
1065:
1066: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
1067: IF l_enable_log = 'Y' THEN
1068: igs_ad_imp_001.logerrormessage(l_spl_intrst_rec.interface_splint_id,l_msg_data);
1069: END IF;
1070:
1071: ELSE
1072:

Line 1241: igs_ad_imp_001.logerrormessage(l_spl_tal_rec.interface_spltal_id,l_msg_data);

1237: error_text = l_error_text
1238: WHERE rowid = l_spl_tal_rec.rowid;
1239:
1240: IF l_enable_log = 'Y' THEN
1241: igs_ad_imp_001.logerrormessage(l_spl_tal_rec.interface_spltal_id,l_msg_data);
1242: END IF;
1243:
1244:
1245: ELSIF l_type = 'S' THEN

Line 1253: igs_ad_imp_001.logerrormessage(l_spl_tal_rec.interface_spltal_id,l_msg_data);

1249: error_text = l_error_text
1250: WHERE rowid = l_SPL_TAL_REC.rowid;
1251:
1252: IF l_enable_log = 'Y' THEN
1253: igs_ad_imp_001.logerrormessage(l_spl_tal_rec.interface_spltal_id,l_msg_data);
1254: END IF;
1255:
1256: ELSIF l_type IS NULL THEN
1257: UPDATE igs_ad_spltal_int

Line 1304: igs_ad_imp_001.logerrormessage(l_spl_tal_rec.interface_spltal_id,l_msg_data);

1300: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
1301:
1302: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
1303: IF l_enable_log = 'Y' THEN
1304: igs_ad_imp_001.logerrormessage(l_spl_tal_rec.interface_spltal_id,l_msg_data);
1305: END IF;
1306:
1307: ELSE
1308:

Line 1455: igs_ad_imp_001.logerrormessage(l_appl_pers_rec.interface_perstmt_id,l_msg_data);

1451: error_text = l_error_text
1452: WHERE rowid = l_appl_pers_rec.rowid;
1453:
1454: IF l_enable_log = 'Y' THEN
1455: igs_ad_imp_001.logerrormessage(l_appl_pers_rec.interface_perstmt_id,l_msg_data);
1456: END IF;
1457:
1458: ELSIF l_type = 'S' THEN
1459: UPDATE igs_ad_perstmt_int

Line 1466: igs_ad_imp_001.logerrormessage(l_appl_pers_rec.interface_perstmt_id,l_msg_data);

1462: error_text = l_error_text
1463: WHERE rowid = l_appl_pers_rec.rowid;
1464:
1465: IF l_enable_log = 'Y' THEN
1466: igs_ad_imp_001.logerrormessage(l_appl_pers_rec.interface_perstmt_id,l_msg_data);
1467: END IF;
1468:
1469: ELSIF l_type IS NULL THEN
1470: UPDATE igs_ad_perstmt_int

Line 1499: igs_ad_imp_001.logerrormessage(l_appl_pers_rec.interface_perstmt_id,l_msg_data);

1495: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
1496:
1497: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
1498: IF l_enable_log = 'Y' THEN
1499: igs_ad_imp_001.logerrormessage(l_appl_pers_rec.interface_perstmt_id,l_msg_data);
1500: END IF;
1501:
1502: ELSE
1503:

Line 1775: igs_ad_imp_001.logerrormessage(l_fee_int_rec.interface_fee_id,l_msg_data);

1771: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
1772:
1773: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
1774: IF l_enable_log = 'Y' THEN
1775: igs_ad_imp_001.logerrormessage(l_fee_int_rec.interface_fee_id,l_msg_data);
1776: END IF;
1777:
1778: ELSE
1779: