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 IGF_AP_PROFILE_MATCHING_PKG

Line 1: PACKAGE BODY IGF_AP_PROFILE_MATCHING_PKG AS

1: PACKAGE BODY IGF_AP_PROFILE_MATCHING_PKG AS
2: /* $Header: IGFAP16B.pls 120.9 2006/06/30 07:55:34 rajagupt ship $ */
3:
4: g_setup_score igf_ap_record_match%ROWTYPE ;
5: -- #2376750 made cur_data global

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 162: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_person_info');

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);
164: igs_ge_msg_stack.add;
165: app_exception.raise_exception;
166: END update_person_info;

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 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 223: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_email_address');

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;
225: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
226: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_email_address' || SQLERRM);
227: END create_email_address;

Line 226: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_email_address' || SQLERRM);

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;
225: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
226: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_email_address' || SQLERRM);
227: END create_email_address;
228:
229: PROCEDURE make_profile_inactive( cp_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
230: /*

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 589: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' );

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;
591: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
592: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' || SQLERRM);
593: app_exception.raise_exception;

Line 592: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' || SQLERRM);

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;
591: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
592: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' || SQLERRM);
593: app_exception.raise_exception;
594: END make_profile_inactive;
595:
596: FUNCTION remove_spl_chr(pv_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE)

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 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 853: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' );

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;
855: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
856: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score 1' || SQLERRM);
857: app_exception.raise_exception;

Line 856: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score 1' || SQLERRM);

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;
855: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
856: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score 1' || SQLERRM);
857: app_exception.raise_exception;
858: END calculate_match_score;
859:
860: PROCEDURE create_ssn(cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,

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 1114: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.CREATE_FA_BASE_REC' || SQLERRM);

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;
1113: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1114: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.CREATE_FA_BASE_REC' || SQLERRM);
1115: app_exception.raise_exception;
1116: END create_fa_base_record;
1117:
1118:

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 1550: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data');

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;
1552: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1553: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data'||SQLERRM);
1554: app_exception.raise_exception;

Line 1553: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data'||SQLERRM);

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;
1552: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1553: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data'||SQLERRM);
1554: app_exception.raise_exception;
1555: END create_fnar_data;
1556:
1557:

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 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 1713: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_person_record');

1709: ELSIF fnd_msg_pub.count_msg > 1 THEN
1710: pv_mesg_data := SQLERRM;
1711: END IF ;
1712: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1713: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_person_record');
1714: IGS_GE_MSG_STACK.ADD;
1715: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1716: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_person_record'||SQLERRM);
1717: app_exception.raise_exception;

Line 1716: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_person_record'||SQLERRM);

1712: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1713: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_person_record');
1714: IGS_GE_MSG_STACK.ADD;
1715: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1716: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_person_record'||SQLERRM);
1717: app_exception.raise_exception;
1718:
1719: END create_person_record;
1720:

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 1812: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_person_addr_record');

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');
1813: IGS_GE_MSG_STACK.ADD;
1814: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1815: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_person_addr_record'|| SQLERRM);
1816: END create_person_addr_record;

Line 1815: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_person_addr_record'|| SQLERRM);

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');
1813: IGS_GE_MSG_STACK.ADD;
1814: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1815: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_person_addr_record'|| SQLERRM);
1816: END create_person_addr_record;
1817:
1818: PROCEDURE process_todo_items(p_base_id NUMBER)
1819: IS

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 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 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 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 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 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 2327: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched:');

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;
2329: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2330: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched:'||SQLERRM);
2331: app_exception.raise_exception;

Line 2330: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched:'||SQLERRM);

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;
2329: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2330: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched:'||SQLERRM);
2331: app_exception.raise_exception;
2332: END create_profile_matched;
2333:
2334:

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 2377: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.is_fa_base_record_present:');

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;
2379: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2380: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.is_fa_base_record_present:'||SQLERRM);
2381: app_exception.raise_exception;

Line 2380: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.is_fa_base_record_present:'||SQLERRM);

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;
2379: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2380: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.is_fa_base_record_present:'||SQLERRM);
2381: app_exception.raise_exception;
2382: END is_fa_base_record_present;
2383:
2384: PROCEDURE update_css_interface(pn_css_id igf_ap_css_interface_all.css_id%TYPE,

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 3137: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_css_interface:');

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;
3139: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3140: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.update_css_interface:'||SQLERRM);
3141: app_exception.raise_exception;

Line 3140: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.update_css_interface:'||SQLERRM);

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;
3139: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3140: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.update_css_interface:'||SQLERRM);
3141: app_exception.raise_exception;
3142: END update_css_interface;
3143:
3144: PROCEDURE create_admission_rec(

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 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 3398: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_person_match:');

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;
3400: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3401: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.update_person_match:'|| SQLERRM);
3402: app_exception.raise_exception;

Line 3401: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.update_person_match:'|| SQLERRM);

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;
3400: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3401: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.update_person_match:'|| SQLERRM);
3402: app_exception.raise_exception;
3403: END update_person_match;
3404:
3405:

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 3558: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.UPDATE_FA_BASE_REC:');

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;
3560: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3561: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.UPDATE_FA_BASE_REC:'||SQLERRM );
3562: app_exception.raise_exception;

Line 3561: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.UPDATE_FA_BASE_REC:'||SQLERRM );

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;
3560: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3561: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.UPDATE_FA_BASE_REC:'||SQLERRM );
3562: app_exception.raise_exception;
3563: END update_fa_base_rec ;
3564:
3565: PROCEDURE unmatched_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE) IS

Line 3609: IGF_AP_PROFILE_MATCHING_PKG.create_person_addr_record(pn_css_id => g_cur_data.css_id,

3605: -- Incrementing the total no of person records created
3606: g_unmatched_added := g_unmatched_added + 1;
3607:
3608: -- Creation of Person address record for the unmatched record
3609: IGF_AP_PROFILE_MATCHING_PKG.create_person_addr_record(pn_css_id => g_cur_data.css_id,
3610: pn_person_id => lv_person_id ) ;
3611:
3612: --Creation of admission record to be checked
3613: IF NOT igf_ap_matching_process_pkg.check_ptyp_code(lv_person_id) AND g_create_inquiry = 'Y' THEN

Line 3628: IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched(pn_css_id => g_cur_data.css_id,

3624: );
3625: -- Inserting the record into igf_ap_css_profile with system_record_type as 'ORIGINAL'
3626: g_active_profile := 'Y';
3627: process_todo_items(lv_base_id);
3628: IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched(pn_css_id => g_cur_data.css_id,
3629: pn_cssp_id => lv_cssp_id ,
3630: pn_base_id => lv_base_id ,
3631: pn_system_record_type => 'ORIGINAL'
3632: );

Line 3634: IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data(pn_css_id => g_cur_data.css_id,

3630: pn_base_id => lv_base_id ,
3631: pn_system_record_type => 'ORIGINAL'
3632: );
3633: -- To insert the record into igf_ap_css_fnar
3634: IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data(pn_css_id => g_cur_data.css_id,
3635: pn_cssp_id => lv_cssp_id
3636: ) ;
3637:
3638: --Opening the cursor to update the record_status field to MATCHED

Line 3655: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,

3651: x_mode => 'R'
3652: );
3653: END LOOP ;
3654: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'
3655: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,
3656: pv_record_status => 'MATCHED',
3657: pv_match_code => g_match_code
3658: );
3659: g_matched_rec := g_matched_rec + 1 ;

Line 3683: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,

3679: x_mode => 'R'
3680: );
3681: END LOOP ;
3682: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'UNMATCHED'
3683: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,
3684: pv_record_status => 'UNMATCHED',
3685: pv_match_code => g_match_code);
3686: END IF;
3687: ELSE

Line 3709: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,

3705: x_mode => 'R'
3706: );
3707: END LOOP ;
3708: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'UNMATCHED'
3709: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,
3710: pv_record_status => 'UNMATCHED',
3711: pv_match_code => g_match_code
3712: );
3713: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_REC_STATUS');

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 3727: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec');

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;
3729: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3730: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec'|| SQLERRM);
3731: app_exception.raise_exception;

Line 3730: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec'|| SQLERRM);

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;
3729: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3730: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec'|| SQLERRM);
3731: app_exception.raise_exception;
3732: END unmatched_rec ;
3733:
3734: PROCEDURE rvw_fa_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE ) IS

Line 3773: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,

3769: );
3770: END LOOP ;
3771:
3772: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'REVIEW'
3773: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,
3774: pv_record_status => 'REVIEW',
3775: pv_match_code => g_match_code
3776: );
3777: g_total_rvw := g_total_rvw +1;

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 3789: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.rvw_fa_rec');

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;
3791: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3792: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.rvw_fa_rec'|| SQLERRM);
3793: app_exception.raise_exception;

Line 3792: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.rvw_fa_rec'|| SQLERRM);

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;
3791: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3792: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.rvw_fa_rec'|| SQLERRM);
3793: app_exception.raise_exception;
3794: END rvw_fa_rec ;
3795:
3796: PROCEDURE auto_fa_rec(p_person_id igf_ap_match_details.person_id%TYPE ,

Line 3840: fa_base_found := IGF_AP_PROFILE_MATCHING_PKG.is_fa_base_record_present(pn_person_id => p_person_id,

3836: WHERE base_id = x_base_id FOR UPDATE NOWAIT ;
3837:
3838:
3839: BEGIN
3840: fa_base_found := IGF_AP_PROFILE_MATCHING_PKG.is_fa_base_record_present(pn_person_id => p_person_id,
3841: pn_cal_type => p_cal_type,
3842: pn_sequence_number => p_seq_num ,
3843: pn_base_id => lv_base_id
3844: );

Line 3846: IGF_AP_PROFILE_MATCHING_PKG.create_fa_base_record(pn_css_id => g_cur_data.css_id,

3842: pn_sequence_number => p_seq_num ,
3843: pn_base_id => lv_base_id
3844: );
3845: IF NOT(fa_base_found) THEN
3846: IGF_AP_PROFILE_MATCHING_PKG.create_fa_base_record(pn_css_id => g_cur_data.css_id,
3847: pn_person_id => p_person_id ,
3848: pn_base_id => lv_base_id
3849: );
3850: FND_MESSAGE.SET_NAME('IGF','IGF_AP_ISIR_FA_BASE_CREATED');

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 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 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 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 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 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 3909: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.auto_fa_rec');

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;
3911: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3912: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.auto_fa_rec'|| SQLERRM);
3913: app_exception.raise_exception;

Line 3912: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.auto_fa_rec'|| SQLERRM);

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;
3911: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3912: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.auto_fa_rec'|| SQLERRM);
3913: app_exception.raise_exception;
3914: END auto_fa_rec ;
3915:
3916: PROCEDURE perform_record_matching(p_out_apm_id OUT NOCOPY igf_ap_person_match_all.apm_id%TYPE)

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 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 4162: fnd_message.set_token('NAME','igf_ap_profile_matching_pkg.perform_record_matching');

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;
4164: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
4165: log_debug_message('igf_ap_profile_matching_pkg.perform_record_matching'|| SQLERRM);
4166: app_exception.raise_exception;

Line 4165: log_debug_message('igf_ap_profile_matching_pkg.perform_record_matching'|| SQLERRM);

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;
4164: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
4165: log_debug_message('igf_ap_profile_matching_pkg.perform_record_matching'|| SQLERRM);
4166: app_exception.raise_exception;
4167: END perform_record_matching ;
4168:
4169: PROCEDURE process_unidentified_isir_rec IS

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 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 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 4245: fnd_message.set_token('NAME','igf_ap_profile_matching_pkg.process_unidentified_isir_rec');

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;
4247: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get||' '||SQLERRM);
4248: log_debug_message('igf_ap_profile_matching_pkg.process_unidentified_isir_rec'|| SQLERRM);
4249: app_exception.raise_exception;

Line 4248: log_debug_message('igf_ap_profile_matching_pkg.process_unidentified_isir_rec'|| SQLERRM);

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;
4247: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get||' '||SQLERRM);
4248: log_debug_message('igf_ap_profile_matching_pkg.process_unidentified_isir_rec'|| SQLERRM);
4249: app_exception.raise_exception;
4250: END process_unidentified_isir_rec;
4251:
4252: PROCEDURE process_old_new_dup_records IS

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 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 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 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 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 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 4378: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.process_old_new_dup_records');

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;
4380: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get||' '||SQLERRM);
4381: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.process_old_new_dup_records'|| SQLERRM);
4382: app_exception.raise_exception;

Line 4381: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.process_old_new_dup_records'|| SQLERRM);

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;
4380: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get||' '||SQLERRM);
4381: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.process_old_new_dup_records'|| SQLERRM);
4382: app_exception.raise_exception;
4383: END process_old_new_dup_records ;
4384:
4385: PROCEDURE main(

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 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 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 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 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 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 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 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 4666: log_debug_message ('igf.plsql.igf_ap_profile_matching_pkg.main.exception'|| SQLERRM);

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;
4669:
4670: retcode := 0;

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 4740: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.main');

4736: CLOSE cur_batch_aw_map;
4737: END IF;
4738:
4739: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4740: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.main');
4741: IGS_GE_MSG_STACK.ADD;
4742: retcode := 2;
4743: errbuf:= FND_MESSAGE.GET;
4744: rollback;

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 4819: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec'|| SQLERRM);

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;
4822:
4823:

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 4892: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_refresh_matches');

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;
4894: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
4895: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_refresh_matches'||SQLERRM);
4896: -- app_exception.raise_exception;

Line 4895: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_refresh_matches'||SQLERRM);

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;
4894: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
4895: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_refresh_matches'||SQLERRM);
4896: -- app_exception.raise_exception;
4897: END ss_wrap_refresh_matches;
4898:
4899: PROCEDURE ss_wrap_create_base_record ( p_css_id IN NUMBER,

Line 4953: IF NOT igf_ap_profile_matching_pkg.is_fa_base_record_present ( pn_person_id => p_person_id,

4949: OPEN cur_css_interface(p_css_id);
4950: FETCH cur_css_interface INTO g_cur_data;
4951: CLOSE cur_css_interface;
4952:
4953: IF NOT igf_ap_profile_matching_pkg.is_fa_base_record_present ( pn_person_id => p_person_id,
4954: pn_cal_type => g_ci_cal_type,
4955: pn_sequence_number => g_ci_sequence_number ,
4956: pn_base_id => lv_base_id
4957: ) THEN

Line 4971: IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched(pn_css_id => g_cur_data.css_id,

4967: -- Inserting the record into igf_ap_css_profile with system_record_type as 'ORIGINAL'
4968: make_profile_inactive(lv_base_id);
4969: g_active_profile:= 'Y';
4970: process_todo_items(lv_base_id);
4971: IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched(pn_css_id => g_cur_data.css_id,
4972: pn_cssp_id => lv_cssp_id ,
4973: pn_base_id => lv_base_id ,
4974: pn_system_record_type => 'ORIGINAL'
4975: );

Line 4977: IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data(pn_css_id => g_cur_data.css_id,

4973: pn_base_id => lv_base_id ,
4974: pn_system_record_type => 'ORIGINAL'
4975: );
4976: -- To insert the record into igf_ap_css_fnar
4977: IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data(pn_css_id => g_cur_data.css_id,
4978: pn_cssp_id => lv_cssp_id
4979: ) ;
4980:
4981: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'

Line 4982: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,

4978: pn_cssp_id => lv_cssp_id
4979: ) ;
4980:
4981: -- PROCEDURE to update the record_status of igf_ap_css_interface to 'MATCHED'
4982: IGF_AP_PROFILE_MATCHING_PKG.update_css_interface(pn_css_id => g_cur_data.css_id,
4983: pv_record_status => 'MATCHED',
4984: pv_match_code => g_match_code
4985: );
4986: -- To update the fields profile_status ,profile_status_datae ,profile_fc

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 4993: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_create_base_record'|| SQLERRM);

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;
4996:
4997: PROCEDURE ss_wrap_upload_Profile ( p_css_id IN NUMBER,

Line 5126: END IGF_AP_PROFILE_MATCHING_PKG;

5122:
5123:
5124:
5125:
5126: END IGF_AP_PROFILE_MATCHING_PKG;