eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on FND_LOG

Line 67: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

63: RETURN TO_NUMBER(col_value);
64:
65: EXCEPTION
66: WHEN others THEN
67: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
68: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.convert_int.exception','The exception is : ' || SQLERRM );
69: END IF;
70: RETURN col_value;
71: END convert_int ;

Line 68: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.convert_int.exception','The exception is : ' || SQLERRM );

64:
65: EXCEPTION
66: WHEN others THEN
67: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
68: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.convert_int.exception','The exception is : ' || SQLERRM );
69: END IF;
70: RETURN col_value;
71: END convert_int ;
72:

Line 158: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

154: END IF;
155: END IF;
156: EXCEPTION
157: WHEN others THEN
158: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
159: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_person_info.exception','The exception is : ' || SQLERRM );
160: END IF;
161: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
162: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_person_info');

Line 159: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_person_info.exception','The exception is : ' || SQLERRM );

155: END IF;
156: EXCEPTION
157: WHEN others THEN
158: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
159: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_person_info.exception','The exception is : ' || SQLERRM );
160: END IF;
161: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
162: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_person_info');
163: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);

Line 198: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

194: p_email_rec.email_format := 'MAILHTML';
195: p_email_rec.email_address := g_cur_data.r_s_email_address;
196:
197: p_contact_points_rec.primary_flag := NULL;
198: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.create_email_address.debug','Before creating Email Address' );
200: END IF;
201: HZ_CONTACT_POINT_V2PUB.create_contact_point(
202: p_init_msg_list => FND_API.G_FALSE,

Line 199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.create_email_address.debug','Before creating Email Address' );

195: p_email_rec.email_address := g_cur_data.r_s_email_address;
196:
197: p_contact_points_rec.primary_flag := NULL;
198: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.create_email_address.debug','Before creating Email Address' );
200: END IF;
201: HZ_CONTACT_POINT_V2PUB.create_contact_point(
202: p_init_msg_list => FND_API.G_FALSE,
203: p_contact_point_rec => p_contact_points_rec,

Line 212: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

208: x_msg_data => l_msg_data,
209: x_contact_point_id => l_contact_point_id
210: );
211:
212: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
213: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.create_email_address.debug','After creating Email Address' );
214: END IF;
215: END IF;
216:

Line 213: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.create_email_address.debug','After creating Email Address' );

209: x_contact_point_id => l_contact_point_id
210: );
211:
212: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
213: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.create_email_address.debug','After creating Email Address' );
214: END IF;
215: END IF;
216:
217: EXCEPTION

Line 219: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

215: END IF;
216:
217: EXCEPTION
218: WHEN others THEN
219: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
220: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_email_address.exception','The exception is : ' || SQLERRM );
221: END IF;
222: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
223: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_email_address');

Line 220: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_email_address.exception','The exception is : ' || SQLERRM );

216:
217: EXCEPTION
218: WHEN others THEN
219: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
220: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_email_address.exception','The exception is : ' || SQLERRM );
221: END IF;
222: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
223: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_email_address');
224: igs_ge_msg_stack.add;

Line 585: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

581:
582: END LOOP;
583: EXCEPTION
584: WHEN others THEN
585: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
586: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.make_profile_inactive.exception','The exception is : ' || SQLERRM );
587: END IF;
588: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
589: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' );

Line 586: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.make_profile_inactive.exception','The exception is : ' || SQLERRM );

582: END LOOP;
583: EXCEPTION
584: WHEN others THEN
585: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
586: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.make_profile_inactive.exception','The exception is : ' || SQLERRM );
587: END IF;
588: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
589: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' );
590: igs_ge_msg_stack.add;

Line 616: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

612: ln_ssn := TRANSLATE (pv_ssn,'1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ`~!@#$%^&*_+=-,./?><():; ','1234567890');
613: RETURN ln_ssn;
614: EXCEPTION
615: WHEN others THEN
616: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
617: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.remove_spl_chr.exception','The exception is : ' || SQLERRM );
618: END IF;
619: RETURN '-1';
620: END remove_spl_chr;

Line 617: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.remove_spl_chr.exception','The exception is : ' || SQLERRM );

613: RETURN ln_ssn;
614: EXCEPTION
615: WHEN others THEN
616: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
617: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.remove_spl_chr.exception','The exception is : ' || SQLERRM );
618: END IF;
619: RETURN '-1';
620: END remove_spl_chr;
621:

Line 849: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

845: END IF;
846:
847: EXCEPTION
848: WHEN others THEN
849: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
850: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.calculate_match_score.exception','The exception is : ' || SQLERRM );
851: END IF;
852: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
853: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' );

Line 850: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.calculate_match_score.exception','The exception is : ' || SQLERRM );

846:
847: EXCEPTION
848: WHEN others THEN
849: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
850: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.calculate_match_score.exception','The exception is : ' || SQLERRM );
851: END IF;
852: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
853: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' );
854: igs_ge_msg_stack.add;

Line 1107: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1103: END IF;
1104: END LOOP;
1105: EXCEPTION
1106: WHEN OTHERS THEN
1107: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1108: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_fa_base_record.exception','The exception is : ' || SQLERRM );
1109: END IF;
1110: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1111: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_MATCHING_PROCESS_PKG.CREATE_FA_BASE_REC:');

Line 1108: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_fa_base_record.exception','The exception is : ' || SQLERRM );

1104: END LOOP;
1105: EXCEPTION
1106: WHEN OTHERS THEN
1107: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1108: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_fa_base_record.exception','The exception is : ' || SQLERRM );
1109: END IF;
1110: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1111: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_MATCHING_PROCESS_PKG.CREATE_FA_BASE_REC:');
1112: IGS_GE_MSG_STACK.ADD;

Line 1546: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1542: END LOOP;
1543:
1544: EXCEPTION
1545: WHEN others THEN
1546: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1547: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_fnar_data.exception','The exception is : ' || SQLERRM );
1548: END IF;
1549: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1550: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data');

Line 1547: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_fnar_data.exception','The exception is : ' || SQLERRM );

1543:
1544: EXCEPTION
1545: WHEN others THEN
1546: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1547: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_fnar_data.exception','The exception is : ' || SQLERRM );
1548: END IF;
1549: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1550: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data');
1551: IGS_GE_MSG_STACK.ADD;

Line 1598: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1594: l_object_version_number NUMBER;
1595: BEGIN
1596:
1597: IF FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
1598: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1599: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_person_record','Profile value for HZ_GENERATE_PARTY_NUMBER is set to N' );
1600: END IF;
1601: fnd_message.set_name ('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');
1602: IF p_called_from = 'FORM' THEN

Line 1599: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_person_record','Profile value for HZ_GENERATE_PARTY_NUMBER is set to N' );

1595: BEGIN
1596:
1597: IF FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
1598: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1599: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_person_record','Profile value for HZ_GENERATE_PARTY_NUMBER is set to N' );
1600: END IF;
1601: fnd_message.set_name ('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');
1602: IF p_called_from = 'FORM' THEN
1603: pv_mesg_data := fnd_message.get;

Line 1701: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1697: EXCEPTION
1698: WHEN SKIP_PERSON THEN
1699: RAISE SKIP_PERSON;
1700: WHEN others THEN
1701: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1702: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_person_record.exception','The exception is : ' || SQLERRM );
1703: END IF;
1704: IF pn_person_id IS NULL THEN
1705: g_bad_rec := nvl(g_bad_rec,0) + 1;

Line 1702: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_person_record.exception','The exception is : ' || SQLERRM );

1698: WHEN SKIP_PERSON THEN
1699: RAISE SKIP_PERSON;
1700: WHEN others THEN
1701: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1702: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_person_record.exception','The exception is : ' || SQLERRM );
1703: END IF;
1704: IF pn_person_id IS NULL THEN
1705: g_bad_rec := nvl(g_bad_rec,0) + 1;
1706: END IF;

Line 1807: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1803: END IF;
1804:
1805: EXCEPTION
1806: WHEN others THEN
1807: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1808: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_person_addr_record.exception','The exception is : ' || SQLERRM );
1809: END IF;
1810: -- FND_FILE.PUT_LINE(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'Status:'||lv_return_status);
1811: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

Line 1808: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_person_addr_record.exception','The exception is : ' || SQLERRM );

1804:
1805: EXCEPTION
1806: WHEN others THEN
1807: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1808: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_person_addr_record.exception','The exception is : ' || SQLERRM );
1809: END IF;
1810: -- FND_FILE.PUT_LINE(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'Status:'||lv_return_status);
1811: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1812: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_person_addr_record');

Line 1856: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1852: lv_rowid ROWID;
1853:
1854: BEGIN
1855:
1856: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1857: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.debug','Beginning processing of TODO Items for BASE ID: ' || p_base_id || ', Active Profile: ' || g_active_profile );
1858: END IF;
1859:
1860: log_debug_message(' Processing TODO items.... ');

Line 1857: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.debug','Beginning processing of TODO Items for BASE ID: ' || p_base_id || ', Active Profile: ' || g_active_profile );

1853:
1854: BEGIN
1855:
1856: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1857: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.debug','Beginning processing of TODO Items for BASE ID: ' || p_base_id || ', Active Profile: ' || g_active_profile );
1858: END IF;
1859:
1860: log_debug_message(' Processing TODO items.... ');
1861: -- populate the variable with the status to be updated for the records

Line 1882: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1878:
1879: IF check_todo_exists_inst_cur%NOTFOUND THEN
1880:
1881: log_debug_message(' Attaching new ISIR with item_sequence_number : ' || todo_items_for_profile_rec.todo_number || ' and TODO status : ' || l_todo_status || ' for Base ID: ' || p_base_id);
1882: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.debug','Attaching new ISIR with item_sequence_number : ' || todo_items_for_profile_rec.todo_number || ' for Base ID: ' || p_base_id);
1884: END IF;
1885:
1886: -- insert new row

Line 1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.debug','Attaching new ISIR with item_sequence_number : ' || todo_items_for_profile_rec.todo_number || ' for Base ID: ' || p_base_id);

1879: IF check_todo_exists_inst_cur%NOTFOUND THEN
1880:
1881: log_debug_message(' Attaching new ISIR with item_sequence_number : ' || todo_items_for_profile_rec.todo_number || ' and TODO status : ' || l_todo_status || ' for Base ID: ' || p_base_id);
1882: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1883: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.debug','Attaching new ISIR with item_sequence_number : ' || todo_items_for_profile_rec.todo_number || ' for Base ID: ' || p_base_id);
1884: END IF;
1885:
1886: -- insert new row
1887: lv_rowid := NULL;

Line 1908: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1904: );
1905: ELSE
1906:
1907: log_debug_message(' Update TODO Items to Status : ' || l_todo_status);
1908: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1909: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.debug','Processing TODO status to : ' || l_todo_status || ' for Base ID: ' || p_base_id);
1910: END IF;
1911:
1912: -- update the status to complete

Line 1909: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.debug','Processing TODO status to : ' || l_todo_status || ' for Base ID: ' || p_base_id);

1905: ELSE
1906:
1907: log_debug_message(' Update TODO Items to Status : ' || l_todo_status);
1908: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1909: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.debug','Processing TODO status to : ' || l_todo_status || ' for Base ID: ' || p_base_id);
1910: END IF;
1911:
1912: -- update the status to complete
1913: igf_ap_td_item_inst_pkg.update_row (

Line 1936: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1932:
1933: CLOSE check_todo_exists_inst_cur;
1934:
1935: log_debug_message('Successfully processed TODO processing.');
1936: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1937: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.debug','Item No.: ' || todo_items_for_profile_rec.todo_number);
1938: END IF;
1939: END LOOP;
1940:

Line 1937: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.debug','Item No.: ' || todo_items_for_profile_rec.todo_number);

1933: CLOSE check_todo_exists_inst_cur;
1934:
1935: log_debug_message('Successfully processed TODO processing.');
1936: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1937: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.debug','Item No.: ' || todo_items_for_profile_rec.todo_number);
1938: END IF;
1939: END LOOP;
1940:
1941: EXCEPTION

Line 1943: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1939: END LOOP;
1940:
1941: EXCEPTION
1942: WHEN OTHERS THEN
1943: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1944: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.exception','The exception is : ' || SQLERRM );
1945: END IF;
1946:
1947: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');

Line 1944: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.exception','The exception is : ' || SQLERRM );

1940:
1941: EXCEPTION
1942: WHEN OTHERS THEN
1943: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1944: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.exception','The exception is : ' || SQLERRM );
1945: END IF;
1946:
1947: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
1948: igs_ge_msg_stack.add;

Line 2323: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2319: END LOOP;
2320:
2321: EXCEPTION
2322: WHEN others THEN
2323: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2324: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_profile_matched.exception','The exception is : ' || SQLERRM );
2325: END IF;
2326: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2327: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched:');

Line 2324: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_profile_matched.exception','The exception is : ' || SQLERRM );

2320:
2321: EXCEPTION
2322: WHEN others THEN
2323: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2324: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_profile_matched.exception','The exception is : ' || SQLERRM );
2325: END IF;
2326: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2327: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched:');
2328: IGS_GE_MSG_STACK.ADD;

Line 2373: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2369: END LOOP;
2370: RETURN FALSE;
2371: EXCEPTION
2372: WHEN others THEN
2373: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2374: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.is_fa_base_record_present.exception','The exception is : ' || SQLERRM );
2375: END IF;
2376: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2377: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.is_fa_base_record_present:');

Line 2374: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.is_fa_base_record_present.exception','The exception is : ' || SQLERRM );

2370: RETURN FALSE;
2371: EXCEPTION
2372: WHEN others THEN
2373: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2374: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.is_fa_base_record_present.exception','The exception is : ' || SQLERRM );
2375: END IF;
2376: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2377: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.is_fa_base_record_present:');
2378: IGS_GE_MSG_STACK.ADD;

Line 3133: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3129: END LOOP ;
3130:
3131: EXCEPTION
3132: WHEN others THEN
3133: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3134: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_css_interface.exception','The exception is : ' || SQLERRM );
3135: END IF;
3136: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3137: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_css_interface:');

Line 3134: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_css_interface.exception','The exception is : ' || SQLERRM );

3130:
3131: EXCEPTION
3132: WHEN others THEN
3133: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3134: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_css_interface.exception','The exception is : ' || SQLERRM );
3135: END IF;
3136: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3137: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_css_interface:');
3138: IGS_GE_MSG_STACK.ADD;

Line 3331: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3327: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
3328: END IF;
3329: EXCEPTION
3330: WHEN OTHERS THEN
3331: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3332: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_admission_rec.exception','The exception is : ' || SQLERRM );
3333: END IF;
3334: IF cur_adm_cal_conf%ISOPEN THEN
3335: CLOSE cur_adm_cal_conf;

Line 3332: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_admission_rec.exception','The exception is : ' || SQLERRM );

3328: END IF;
3329: EXCEPTION
3330: WHEN OTHERS THEN
3331: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3332: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_admission_rec.exception','The exception is : ' || SQLERRM );
3333: END IF;
3334: IF cur_adm_cal_conf%ISOPEN THEN
3335: CLOSE cur_adm_cal_conf;
3336: END IF;

Line 3394: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3390: END LOOP ;
3391:
3392: EXCEPTION
3393: WHEN others THEN
3394: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3395: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_person_match.exception','The exception is : ' || SQLERRM );
3396: END IF;
3397: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3398: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_person_match:');

Line 3395: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_person_match.exception','The exception is : ' || SQLERRM );

3391:
3392: EXCEPTION
3393: WHEN others THEN
3394: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3395: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_person_match.exception','The exception is : ' || SQLERRM );
3396: END IF;
3397: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3398: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_person_match:');
3399: IGS_GE_MSG_STACK.ADD;

Line 3554: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3550: );
3551: END LOOP ;
3552: EXCEPTION
3553: WHEN OTHERS THEN
3554: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3555: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_fa_base_rec.exception','The exception is : ' || SQLERRM );
3556: END IF;
3557: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3558: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.UPDATE_FA_BASE_REC:');

Line 3555: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_fa_base_rec.exception','The exception is : ' || SQLERRM );

3551: END LOOP ;
3552: EXCEPTION
3553: WHEN OTHERS THEN
3554: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3555: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_fa_base_rec.exception','The exception is : ' || SQLERRM );
3556: END IF;
3557: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3558: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.UPDATE_FA_BASE_REC:');
3559: IGS_GE_MSG_STACK.ADD;

Line 3723: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3719: RAISE SKIP_PERSON;
3720: WHEN INVALID_PROFILE_ERROR THEN
3721: RAISE INVALID_PROFILE_ERROR;
3722: WHEN others THEN
3723: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3724: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.unmatched_rec.exception','The exception is : ' || SQLERRM );
3725: END IF;
3726: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3727: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec');

Line 3724: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.unmatched_rec.exception','The exception is : ' || SQLERRM );

3720: WHEN INVALID_PROFILE_ERROR THEN
3721: RAISE INVALID_PROFILE_ERROR;
3722: WHEN others THEN
3723: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3724: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.unmatched_rec.exception','The exception is : ' || SQLERRM );
3725: END IF;
3726: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3727: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec');
3728: IGS_GE_MSG_STACK.ADD;

Line 3785: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3781: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
3782:
3783: EXCEPTION
3784: WHEN others THEN
3785: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3786: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.rvw_fa_rec.exception','The exception is : ' || SQLERRM );
3787: END IF;
3788: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3789: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.rvw_fa_rec');

Line 3786: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.rvw_fa_rec.exception','The exception is : ' || SQLERRM );

3782:
3783: EXCEPTION
3784: WHEN others THEN
3785: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3786: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.rvw_fa_rec.exception','The exception is : ' || SQLERRM );
3787: END IF;
3788: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3789: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.rvw_fa_rec');
3790: IGS_GE_MSG_STACK.ADD;

Line 3857: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3853: -- Cursor for updating the active_profile of all the old profile records of the student to 'N'
3854: make_profile_inactive(lv_base_id);
3855: g_active_profile := 'Y';
3856: -- To insert the record into igf_ap_css_profile
3857: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3858: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: create_profile_matched' );
3859: END IF;
3860:
3861: process_todo_items(lv_base_id);

Line 3858: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: create_profile_matched' );

3854: make_profile_inactive(lv_base_id);
3855: g_active_profile := 'Y';
3856: -- To insert the record into igf_ap_css_profile
3857: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3858: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: create_profile_matched' );
3859: END IF;
3860:
3861: process_todo_items(lv_base_id);
3862: create_profile_matched(pn_css_id => g_cur_data.css_id,

Line 3869: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3865: pn_system_record_type => 'ORIGINAL'
3866: );
3867:
3868: -- To Insert the record into igf_ap_css_fnar table.
3869: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3870: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: create_fnar_data' );
3871: END IF;
3872: create_fnar_data(pn_css_id => g_cur_data.css_id,
3873: pn_cssp_id => lv_cssp_id

Line 3870: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: create_fnar_data' );

3866: );
3867:
3868: -- To Insert the record into igf_ap_css_fnar table.
3869: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3870: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: create_fnar_data' );
3871: END IF;
3872: create_fnar_data(pn_css_id => g_cur_data.css_id,
3873: pn_cssp_id => lv_cssp_id
3874: ) ;

Line 3878: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3874: ) ;
3875:
3876:
3877: -- To update the fields profile_status ,profile_status_date ,profile_fc
3878: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3879: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: update_fa_base_rec' );
3880: END IF;
3881: update_fa_base_rec(p_base_id => lv_base_id );
3882:

Line 3879: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: update_fa_base_rec' );

3875:
3876:
3877: -- To update the fields profile_status ,profile_status_date ,profile_fc
3878: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3879: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: update_fa_base_rec' );
3880: END IF;
3881: update_fa_base_rec(p_base_id => lv_base_id );
3882:
3883: -- Added following call to update_person_info() as bug fix 3944249 (IGS.M)

Line 3888: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3884: -- Update Email address
3885: update_person_info(p_person_id);
3886:
3887: -- Delete the detals from person match amd match details.
3888: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3889: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: igf_ap_profile_gen_pkg.delete_person_match' );
3890: END IF;
3891: igf_ap_profile_gen_pkg.delete_person_match ( p_css_id => g_cur_data.css_id);
3892:

Line 3889: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: igf_ap_profile_gen_pkg.delete_person_match' );

3885: update_person_info(p_person_id);
3886:
3887: -- Delete the detals from person match amd match details.
3888: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3889: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: igf_ap_profile_gen_pkg.delete_person_match' );
3890: END IF;
3891: igf_ap_profile_gen_pkg.delete_person_match ( p_css_id => g_cur_data.css_id);
3892:
3893: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'

Line 3894: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3890: END IF;
3891: igf_ap_profile_gen_pkg.delete_person_match ( p_css_id => g_cur_data.css_id);
3892:
3893: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'
3894: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: update_css_interface' );
3896: END IF;
3897: update_css_interface(pn_css_id => g_cur_data.css_id,
3898: pv_record_status => 'MATCHED',

Line 3895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: update_css_interface' );

3891: igf_ap_profile_gen_pkg.delete_person_match ( p_css_id => g_cur_data.css_id);
3892:
3893: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'
3894: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.debug','Calling Method: update_css_interface' );
3896: END IF;
3897: update_css_interface(pn_css_id => g_cur_data.css_id,
3898: pv_record_status => 'MATCHED',
3899: pv_match_code => g_match_code

Line 3905: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3901: g_matched_rec := g_matched_rec + 1 ;
3902:
3903: EXCEPTION
3904: WHEN others THEN
3905: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3906: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.exception','The exception is : ' || SQLERRM );
3907: END IF;
3908: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3909: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.auto_fa_rec');

Line 3906: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.exception','The exception is : ' || SQLERRM );

3902:
3903: EXCEPTION
3904: WHEN others THEN
3905: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3906: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.exception','The exception is : ' || SQLERRM );
3907: END IF;
3908: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3909: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.auto_fa_rec');
3910: IGS_GE_MSG_STACK.ADD;

Line 4141: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4137: match_details_rec.birth_date := t_dob_tab(l_row);
4138: match_details_rec.gender_txt := t_gender(l_row);
4139:
4140: -- call the procedure to match the attributes, compute score and insert rec into match details table
4141: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4142: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.perform_record_matching.debug','Calling Method: calculate_match_score' );
4143: END IF;
4144: calculate_match_score(p_match_setup => g_setup_score,
4145: p_match_dtls_rec => match_details_rec,

Line 4142: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.perform_record_matching.debug','Calling Method: calculate_match_score' );

4138: match_details_rec.gender_txt := t_gender(l_row);
4139:
4140: -- call the procedure to match the attributes, compute score and insert rec into match details table
4141: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4142: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.perform_record_matching.debug','Calling Method: calculate_match_score' );
4143: END IF;
4144: calculate_match_score(p_match_setup => g_setup_score,
4145: p_match_dtls_rec => match_details_rec,
4146: p_apm_id => p_out_apm_id,

Line 4158: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

4154: END IF;
4155: END LOOP;
4156: EXCEPTION
4157: WHEN others THEN
4158: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4159: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.perform_record_matching.exception','The exception is : ' || SQLERRM );
4160: END IF;
4161: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4162: fnd_message.set_token('NAME','igf_ap_profile_matching_pkg.perform_record_matching');

Line 4159: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.perform_record_matching.exception','The exception is : ' || SQLERRM );

4155: END LOOP;
4156: EXCEPTION
4157: WHEN others THEN
4158: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4159: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.perform_record_matching.exception','The exception is : ' || SQLERRM );
4160: END IF;
4161: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4162: fnd_message.set_token('NAME','igf_ap_profile_matching_pkg.perform_record_matching');
4163: igs_ge_msg_stack.add;

Line 4198: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4194:
4195: BEGIN
4196: -- Unidentified ISIR. Hence first need to perform person match.
4197: -- call procedure for performing person match.
4198: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.debug','calling method: perform_record_matching');
4200: END IF;
4201: perform_record_matching(p_out_apm_id => ln_apm_id); -- OUT parameter
4202:

Line 4199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.debug','calling method: perform_record_matching');

4195: BEGIN
4196: -- Unidentified ISIR. Hence first need to perform person match.
4197: -- call procedure for performing person match.
4198: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.debug','calling method: perform_record_matching');
4200: END IF;
4201: perform_record_matching(p_out_apm_id => ln_apm_id); -- OUT parameter
4202:
4203: ln_match_score := 0;

Line 4210: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4206: FETCH cur_get_max_data INTO lv_person_id, ln_match_score;
4207: CLOSE cur_get_max_data;
4208:
4209: g_person_id := lv_person_id;
4210: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4211: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.debug','Match Score:' || TO_CHAR(ln_match_score));
4212: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.debug','Min Score for Auto Creation:' || TO_CHAR(g_setup_score.min_score_auto_fa));
4213: END IF;
4214:

Line 4211: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.debug','Match Score:' || TO_CHAR(ln_match_score));

4207: CLOSE cur_get_max_data;
4208:
4209: g_person_id := lv_person_id;
4210: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4211: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.debug','Match Score:' || TO_CHAR(ln_match_score));
4212: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.debug','Min Score for Auto Creation:' || TO_CHAR(g_setup_score.min_score_auto_fa));
4213: END IF;
4214:
4215: -- compare total score against the setup scores

Line 4212: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.debug','Min Score for Auto Creation:' || TO_CHAR(g_setup_score.min_score_auto_fa));

4208:
4209: g_person_id := lv_person_id;
4210: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4211: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.debug','Match Score:' || TO_CHAR(ln_match_score));
4212: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.debug','Min Score for Auto Creation:' || TO_CHAR(g_setup_score.min_score_auto_fa));
4213: END IF;
4214:
4215: -- compare total score against the setup scores
4216: IF ln_match_score >= g_setup_score.min_score_auto_fa THEN

Line 4241: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

4237: RAISE SKIP_PERSON;
4238: WHEN INVALID_PROFILE_ERROR THEN
4239: RAISE INVALID_PROFILE_ERROR;
4240: WHEN OTHERS THEN
4241: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4242: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.exception','The exception is : ' || SQLERRM );
4243: END IF;
4244: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4245: fnd_message.set_token('NAME','igf_ap_profile_matching_pkg.process_unidentified_isir_rec');

Line 4242: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.exception','The exception is : ' || SQLERRM );

4238: WHEN INVALID_PROFILE_ERROR THEN
4239: RAISE INVALID_PROFILE_ERROR;
4240: WHEN OTHERS THEN
4241: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4242: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.exception','The exception is : ' || SQLERRM );
4243: END IF;
4244: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4245: fnd_message.set_token('NAME','igf_ap_profile_matching_pkg.process_unidentified_isir_rec');
4246: igs_ge_msg_stack.add;

Line 4303: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4299: ELSIF g_rec_type = 'O' THEN
4300:
4301: g_active_profile :='N';
4302: -- To insert the record into igf_ap_css_profile
4303: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4304: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','Processing Old Rec:calling method: create_profile_matched');
4305: END IF;
4306:
4307: process_todo_items(g_base_id);

Line 4304: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','Processing Old Rec:calling method: create_profile_matched');

4300:
4301: g_active_profile :='N';
4302: -- To insert the record into igf_ap_css_profile
4303: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4304: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','Processing Old Rec:calling method: create_profile_matched');
4305: END IF;
4306:
4307: process_todo_items(g_base_id);
4308: create_profile_matched(pn_css_id => g_cur_data.css_id,

Line 4315: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4311: pn_system_record_type => 'ORIGINAL'
4312: );
4313:
4314: -- To Insert the record into igf_ap_css_fnar table.
4315: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4316: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','Processing Old Rec:calling method: create_fnar_data');
4317: END IF;
4318: create_fnar_data(pn_css_id => g_cur_data.css_id,
4319: pn_cssp_id => lv_cssp_id

Line 4316: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','Processing Old Rec:calling method: create_fnar_data');

4312: );
4313:
4314: -- To Insert the record into igf_ap_css_fnar table.
4315: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4316: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','Processing Old Rec:calling method: create_fnar_data');
4317: END IF;
4318: create_fnar_data(pn_css_id => g_cur_data.css_id,
4319: pn_cssp_id => lv_cssp_id
4320: ) ;

Line 4328: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4324: --
4325: make_profile_inactive(g_base_id);
4326: g_active_profile := 'Y';
4327: -- To insert the record into igf_ap_css_profile
4328: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4329: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','Processing New Rec:calling method: create_profile_matched');
4330: END IF;
4331:
4332: process_todo_items(g_base_id);

Line 4329: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','Processing New Rec:calling method: create_profile_matched');

4325: make_profile_inactive(g_base_id);
4326: g_active_profile := 'Y';
4327: -- To insert the record into igf_ap_css_profile
4328: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4329: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','Processing New Rec:calling method: create_profile_matched');
4330: END IF;
4331:
4332: process_todo_items(g_base_id);
4333: -- add the call for todo processing

Line 4341: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4337: pn_system_record_type => 'ORIGINAL'
4338: );
4339:
4340: -- To Insert the record into igf_ap_css_fnar table.
4341: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4342: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','Processing New Rec:calling method: create_fnar_data');
4343: END IF;
4344: create_fnar_data(pn_css_id => g_cur_data.css_id,
4345: pn_cssp_id => lv_cssp_id

Line 4342: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','Processing New Rec:calling method: create_fnar_data');

4338: );
4339:
4340: -- To Insert the record into igf_ap_css_fnar table.
4341: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4342: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','Processing New Rec:calling method: create_fnar_data');
4343: END IF;
4344: create_fnar_data(pn_css_id => g_cur_data.css_id,
4345: pn_cssp_id => lv_cssp_id
4346: ) ;

Line 4364: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4360: g_matched_rec := g_matched_rec + 1 ;
4361: END IF;
4362:
4363: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'
4364: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4365: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','calling method: update_css_interface');
4366: END IF;
4367: update_css_interface(pn_css_id => g_cur_data.css_id,
4368: pv_record_status => 'MATCHED',

Line 4365: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','calling method: update_css_interface');

4361: END IF;
4362:
4363: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'
4364: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4365: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.debug','calling method: update_css_interface');
4366: END IF;
4367: update_css_interface(pn_css_id => g_cur_data.css_id,
4368: pv_record_status => 'MATCHED',
4369: pv_match_code => g_match_code

Line 4374: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

4370: );
4371:
4372: EXCEPTION
4373: WHEN others THEN
4374: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4375: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.exception','The exception is : ' || SQLERRM );
4376: END IF;
4377: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4378: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.process_old_new_dup_records');

Line 4375: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.exception','The exception is : ' || SQLERRM );

4371:
4372: EXCEPTION
4373: WHEN others THEN
4374: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4375: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.exception','The exception is : ' || SQLERRM );
4376: END IF;
4377: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4378: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.process_old_new_dup_records');
4379: IGS_GE_MSG_STACK.ADD;

Line 4604: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4600: IF NVL(rec_css_id_number.max_stu_record_type,'0') <> '0' THEN
4601: g_base_id := rec_css_id_number.base_id;
4602: IF (rec_css_id_number.max_stu_record_type = g_cur_data.STU_RECORD_TYPE) THEN
4603: g_rec_type := 'D';
4604: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4605: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : D - Duplicate' );
4606: END IF;
4607:
4608: ELSIF (rec_css_id_number.max_stu_record_type < g_cur_data.STU_RECORD_TYPE) THEN

Line 4605: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : D - Duplicate' );

4601: g_base_id := rec_css_id_number.base_id;
4602: IF (rec_css_id_number.max_stu_record_type = g_cur_data.STU_RECORD_TYPE) THEN
4603: g_rec_type := 'D';
4604: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4605: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : D - Duplicate' );
4606: END IF;
4607:
4608: ELSIF (rec_css_id_number.max_stu_record_type < g_cur_data.STU_RECORD_TYPE) THEN
4609: g_rec_type := 'N';

Line 4610: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4606: END IF;
4607:
4608: ELSIF (rec_css_id_number.max_stu_record_type < g_cur_data.STU_RECORD_TYPE) THEN
4609: g_rec_type := 'N';
4610: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4611: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : N - New' );
4612: END IF;
4613: ELSIF (rec_css_id_number.max_stu_record_type > g_cur_data.STU_RECORD_TYPE) THEN
4614: l_duplicate := NULL;

Line 4611: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : N - New' );

4607:
4608: ELSIF (rec_css_id_number.max_stu_record_type < g_cur_data.STU_RECORD_TYPE) THEN
4609: g_rec_type := 'N';
4610: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4611: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : N - New' );
4612: END IF;
4613: ELSIF (rec_css_id_number.max_stu_record_type > g_cur_data.STU_RECORD_TYPE) THEN
4614: l_duplicate := NULL;
4615: OPEN cur_check_duplicate(l_profile_year,g_cur_data.css_id_number,g_cur_data.STU_RECORD_TYPE);

Line 4620: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4616: FETCH cur_check_duplicate INTO l_duplicate;
4617: CLOSE cur_check_duplicate;
4618: IF l_duplicate IS NULL THEN
4619: g_rec_type := 'O';
4620: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4621: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : O - Old' );
4622: END IF;
4623: ELSE
4624: g_rec_type := 'D';

Line 4621: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : O - Old' );

4617: CLOSE cur_check_duplicate;
4618: IF l_duplicate IS NULL THEN
4619: g_rec_type := 'O';
4620: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4621: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : O - Old' );
4622: END IF;
4623: ELSE
4624: g_rec_type := 'D';
4625: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 4625: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4621: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : O - Old' );
4622: END IF;
4623: ELSE
4624: g_rec_type := 'D';
4625: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4626: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : D - Duplicate' );
4627: END IF;
4628: END IF;
4629:

Line 4626: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : D - Duplicate' );

4622: END IF;
4623: ELSE
4624: g_rec_type := 'D';
4625: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4626: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : D - Duplicate' );
4627: END IF;
4628: END IF;
4629:
4630: END IF;

Line 4631: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4627: END IF;
4628: END IF;
4629:
4630: END IF;
4631: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4632: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','calling method: process_old_new_dup_records' );
4633: END IF;
4634: process_old_new_dup_records;
4635:

Line 4632: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','calling method: process_old_new_dup_records' );

4628: END IF;
4629:
4630: END IF;
4631: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4632: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','calling method: process_old_new_dup_records' );
4633: END IF;
4634: process_old_new_dup_records;
4635:
4636: ELSE

Line 4638: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4634: process_old_new_dup_records;
4635:
4636: ELSE
4637: g_rec_type := 'U';
4638: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4639: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : U - Unidentified' );
4640: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','calling method: process_unidentified_isir_rec' );
4641: END IF;
4642: process_unidentified_isir_rec;

Line 4639: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : U - Unidentified' );

4635:
4636: ELSE
4637: g_rec_type := 'U';
4638: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4639: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : U - Unidentified' );
4640: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','calling method: process_unidentified_isir_rec' );
4641: END IF;
4642: process_unidentified_isir_rec;
4643:

Line 4640: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','calling method: process_unidentified_isir_rec' );

4636: ELSE
4637: g_rec_type := 'U';
4638: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4639: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','Record type is : U - Unidentified' );
4640: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.main.debug','calling method: process_unidentified_isir_rec' );
4641: END IF;
4642: process_unidentified_isir_rec;
4643:
4644: END IF;

Line 4656: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

4652: fnd_file.put_line (FND_FILE.LOG, fnd_message.get);
4653:
4654: WHEN INVALID_PROFILE_ERROR THEN
4655: ROLLBACK TO IGFAP16_MAIN_SP1;
4656: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4657: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.main.exception','The exception is :The profile option "HZ: Generate Party Number" is set to No.');
4658: END IF;
4659: fnd_message.set_name ('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');
4660: fnd_file.put_line (FND_FILE.LOG, fnd_message.get);

Line 4657: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.main.exception','The exception is :The profile option "HZ: Generate Party Number" is set to No.');

4653:
4654: WHEN INVALID_PROFILE_ERROR THEN
4655: ROLLBACK TO IGFAP16_MAIN_SP1;
4656: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4657: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.main.exception','The exception is :The profile option "HZ: Generate Party Number" is set to No.');
4658: END IF;
4659: fnd_message.set_name ('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');
4660: fnd_file.put_line (FND_FILE.LOG, fnd_message.get);
4661: WHEN OTHERS THEN

Line 4663: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

4659: fnd_message.set_name ('IGF','IGF_AP_HZ_GEN_PARTY_NUMBER');
4660: fnd_file.put_line (FND_FILE.LOG, fnd_message.get);
4661: WHEN OTHERS THEN
4662: ROLLBACK TO IGFAP16_MAIN_SP1; -- already error message is printed
4663: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4664: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.main.exception','The exception in main inner begin others, for skipping student');
4665: END IF;
4666: log_debug_message ('igf.plsql.igf_ap_profile_matching_pkg.main.exception'|| SQLERRM);
4667: END;

Line 4664: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.main.exception','The exception in main inner begin others, for skipping student');

4660: fnd_file.put_line (FND_FILE.LOG, fnd_message.get);
4661: WHEN OTHERS THEN
4662: ROLLBACK TO IGFAP16_MAIN_SP1; -- already error message is printed
4663: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4664: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.main.exception','The exception in main inner begin others, for skipping student');
4665: END IF;
4666: log_debug_message ('igf.plsql.igf_ap_profile_matching_pkg.main.exception'|| SQLERRM);
4667: END;
4668: END LOOP;

Line 4720: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

4716: WHEN INVALID_PARAMETER THEN
4717: NULL; --bcoz message is already printed before raising
4718:
4719: WHEN others THEN
4720: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4721: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.main.exception','The exception is : ' || SQLERRM );
4722: END IF;
4723: IF cur_css_interface%ISOPEN THEN
4724: CLOSE cur_css_interface;

Line 4721: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.main.exception','The exception is : ' || SQLERRM );

4717: NULL; --bcoz message is already printed before raising
4718:
4719: WHEN others THEN
4720: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4721: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.main.exception','The exception is : ' || SQLERRM );
4722: END IF;
4723: IF cur_css_interface%ISOPEN THEN
4724: CLOSE cur_css_interface;
4725: END IF;

Line 4816: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

4812: unmatched_rec(l_apm_id);
4813:
4814: EXCEPTION
4815: WHEN others THEN
4816: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4817: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.unmatched_rec.exception','The exception is : ' || SQLERRM );
4818: END IF;
4819: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec'|| SQLERRM);
4820: app_exception.raise_exception;

Line 4817: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.unmatched_rec.exception','The exception is : ' || SQLERRM );

4813:
4814: EXCEPTION
4815: WHEN others THEN
4816: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4817: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.unmatched_rec.exception','The exception is : ' || SQLERRM );
4818: END IF;
4819: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec'|| SQLERRM);
4820: app_exception.raise_exception;
4821: END ss_wrap_create_person_record;

Line 4888: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

4884: process_unidentified_isir_rec;
4885:
4886: EXCEPTION
4887: WHEN others THEN
4888: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4889: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.ss_wrap_refresh_matches.exception','The exception is : ' || SQLERRM );
4890: END IF;
4891: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4892: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_refresh_matches');

Line 4889: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.ss_wrap_refresh_matches.exception','The exception is : ' || SQLERRM );

4885:
4886: EXCEPTION
4887: WHEN others THEN
4888: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4889: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.ss_wrap_refresh_matches.exception','The exception is : ' || SQLERRM );
4890: END IF;
4891: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4892: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_refresh_matches');
4893: IGS_GE_MSG_STACK.ADD;

Line 4990: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

4986: -- To update the fields profile_status ,profile_status_datae ,profile_fc
4987: update_fa_base_rec(p_base_id => lv_base_id );
4988: EXCEPTION
4989: WHEN others THEN
4990: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4991: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.ss_wrap_create_base_record.exception','The exception is : ' || SQLERRM );
4992: END IF;
4993: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_create_base_record'|| SQLERRM);
4994: app_exception.raise_exception;

Line 4991: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.ss_wrap_create_base_record.exception','The exception is : ' || SQLERRM );

4987: update_fa_base_rec(p_base_id => lv_base_id );
4988: EXCEPTION
4989: WHEN others THEN
4990: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4991: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.ss_wrap_create_base_record.exception','The exception is : ' || SQLERRM );
4992: END IF;
4993: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_create_base_record'|| SQLERRM);
4994: app_exception.raise_exception;
4995: END ss_wrap_create_base_record;

Line 5113: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

5109: -- Process new or duplicate record
5110: process_old_new_dup_records;
5111:
5112: EXCEPTION WHEN OTHERS THEN
5113: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5114: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.ss_upload_profile.exception','The exception is : ' || SQLERRM );
5115: END IF;
5116: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5117: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.ss_upload_profile');

Line 5114: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.ss_upload_profile.exception','The exception is : ' || SQLERRM );

5110: process_old_new_dup_records;
5111:
5112: EXCEPTION WHEN OTHERS THEN
5113: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5114: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.ss_upload_profile.exception','The exception is : ' || SQLERRM );
5115: END IF;
5116: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5117: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.ss_upload_profile');
5118: fnd_file.put_line(fnd_file.log,fnd_message.get);