DBA Data[Home] [Help]

APPS.IGF_DB_SF_INTEGRATION dependencies on IGF_AW_COA_GEN

Line 1696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_sf_integration.transfer_disb_dtls_to_sf.debug','calling igf_aw_coa_gen.doLock for person_id '||l_cur_person.person_id);

1692: --lock COA at the student level
1693: IF lv_profile_value = 'TRANSFER' THEN
1694:
1695: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1696: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_sf_integration.transfer_disb_dtls_to_sf.debug','calling igf_aw_coa_gen.doLock for person_id '||l_cur_person.person_id);
1697: END IF;
1698:
1699: OPEN cur_base(l_cur_person.person_id,l_cal_type,l_sequence_number);
1700: FETCH cur_base INTO l_cur_base;

Line 1703: IF NOT igf_aw_coa_gen.isCOALocked(l_cur_base.base_id) THEN

1699: OPEN cur_base(l_cur_person.person_id,l_cal_type,l_sequence_number);
1700: FETCH cur_base INTO l_cur_base;
1701: CLOSE cur_base;
1702:
1703: IF NOT igf_aw_coa_gen.isCOALocked(l_cur_base.base_id) THEN
1704: lv_locking_success := igf_aw_coa_gen.doLock(l_cur_base.base_id);
1705:
1706: IF lv_locking_success = 'Y' THEN
1707: fnd_message.set_name('IGF','IGF_AW_STUD_COA_LOCK');

Line 1704: lv_locking_success := igf_aw_coa_gen.doLock(l_cur_base.base_id);

1700: FETCH cur_base INTO l_cur_base;
1701: CLOSE cur_base;
1702:
1703: IF NOT igf_aw_coa_gen.isCOALocked(l_cur_base.base_id) THEN
1704: lv_locking_success := igf_aw_coa_gen.doLock(l_cur_base.base_id);
1705:
1706: IF lv_locking_success = 'Y' THEN
1707: fnd_message.set_name('IGF','IGF_AW_STUD_COA_LOCK');
1708: fnd_message.set_token('PERSON_NUM',igf_gr_gen.get_per_num (l_cur_base.base_id));

Line 1758: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_sf_integration.transfer_disb_dtls_to_sf.debug','calling igf_aw_coa_gen.doLock for person_id '||l_n_person_id);

1754: --lock COA at the student level
1755: IF lv_profile_value = 'TRANSFER' THEN
1756:
1757: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1758: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_sf_integration.transfer_disb_dtls_to_sf.debug','calling igf_aw_coa_gen.doLock for person_id '||l_n_person_id);
1759: END IF;
1760:
1761: OPEN cur_base(l_n_person_id,l_cal_type,l_sequence_number);
1762: FETCH cur_base INTO l_cur_base;

Line 1765: IF NOT igf_aw_coa_gen.isCOALocked(l_cur_base.base_id) THEN

1761: OPEN cur_base(l_n_person_id,l_cal_type,l_sequence_number);
1762: FETCH cur_base INTO l_cur_base;
1763: CLOSE cur_base;
1764:
1765: IF NOT igf_aw_coa_gen.isCOALocked(l_cur_base.base_id) THEN
1766: lv_locking_success := igf_aw_coa_gen.doLock(l_cur_base.base_id);
1767:
1768: IF lv_locking_success = 'Y' THEN
1769: fnd_message.set_name('IGF','IGF_AW_STUD_COA_LOCK');

Line 1766: lv_locking_success := igf_aw_coa_gen.doLock(l_cur_base.base_id);

1762: FETCH cur_base INTO l_cur_base;
1763: CLOSE cur_base;
1764:
1765: IF NOT igf_aw_coa_gen.isCOALocked(l_cur_base.base_id) THEN
1766: lv_locking_success := igf_aw_coa_gen.doLock(l_cur_base.base_id);
1767:
1768: IF lv_locking_success = 'Y' THEN
1769: fnd_message.set_name('IGF','IGF_AW_STUD_COA_LOCK');
1770: fnd_message.set_token('PERSON_NUM',igf_gr_gen.get_per_num (l_cur_base.base_id));

Line 1803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_sf_integration.transfer_disb_dtls_to_sf.debug','calling igf_aw_coa_gen.doLock for person_id '||lv_person_id);

1799:
1800: --lock COA at the student level
1801: IF lv_profile_value = 'TRANSFER' THEN
1802: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1803: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_sf_integration.transfer_disb_dtls_to_sf.debug','calling igf_aw_coa_gen.doLock for person_id '||lv_person_id);
1804: END IF;
1805:
1806: OPEN cur_base(lv_person_id,l_cal_type,l_sequence_number);
1807: FETCH cur_base INTO l_cur_base;

Line 1810: IF NOT igf_aw_coa_gen.isCOALocked(l_cur_base.base_id) THEN

1806: OPEN cur_base(lv_person_id,l_cal_type,l_sequence_number);
1807: FETCH cur_base INTO l_cur_base;
1808: CLOSE cur_base;
1809:
1810: IF NOT igf_aw_coa_gen.isCOALocked(l_cur_base.base_id) THEN
1811: lv_locking_success := igf_aw_coa_gen.doLock(l_cur_base.base_id);
1812:
1813: IF lv_locking_success = 'Y' THEN
1814: fnd_message.set_name('IGF','IGF_AW_STUD_COA_LOCK');

Line 1811: lv_locking_success := igf_aw_coa_gen.doLock(l_cur_base.base_id);

1807: FETCH cur_base INTO l_cur_base;
1808: CLOSE cur_base;
1809:
1810: IF NOT igf_aw_coa_gen.isCOALocked(l_cur_base.base_id) THEN
1811: lv_locking_success := igf_aw_coa_gen.doLock(l_cur_base.base_id);
1812:
1813: IF lv_locking_success = 'Y' THEN
1814: fnd_message.set_name('IGF','IGF_AW_STUD_COA_LOCK');
1815: fnd_message.set_token('PERSON_NUM',igf_gr_gen.get_per_num (l_cur_base.base_id));