DBA Data[Home] [Help]

APPS.IGS_FI_PRC_SP_FEES dependencies on FND_LOG

Line 769: -- If FND logging is enabled, then send message to the FND log table

765: EXCEPTION
766: WHEN e_expected_error THEN
767: ROLLBACK;
768: x_return_status := 'E';
769: -- If FND logging is enabled, then send message to the FND log table
770: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
771:
772: -- Get the message from fnd_msg_pub and put it onto fnd_message stack so that it is logged in fnd_log_messages.
773: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 770: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN

766: WHEN e_expected_error THEN
767: ROLLBACK;
768: x_return_status := 'E';
769: -- If FND logging is enabled, then send message to the FND log table
770: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
771:
772: -- Get the message from fnd_msg_pub and put it onto fnd_message stack so that it is logged in fnd_log_messages.
773: fnd_msg_pub.count_and_get(p_count => x_msg_count,
774: p_data => x_msg_data);

Line 772: -- Get the message from fnd_msg_pub and put it onto fnd_message stack so that it is logged in fnd_log_messages.

768: x_return_status := 'E';
769: -- If FND logging is enabled, then send message to the FND log table
770: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
771:
772: -- Get the message from fnd_msg_pub and put it onto fnd_message stack so that it is logged in fnd_log_messages.
773: fnd_msg_pub.count_and_get(p_count => x_msg_count,
774: p_data => x_msg_data);
775: IF (x_msg_count = 1) THEN
776: fnd_message.set_encoded(x_msg_data);

Line 783: fnd_log.message(fnd_log.level_error, 'igs.patch.115.sql.igs_fi_prc_sp_fees.assess_fees_pvt',FALSE);

779: fnd_message.set_encoded(x_msg_data);
780: END IF;
781:
782: -- Log message in FND tables, but do not pop the message from the Stack, hence pass False
783: fnd_log.message(fnd_log.level_error, 'igs.patch.115.sql.igs_fi_prc_sp_fees.assess_fees_pvt',FALSE);
784: ELSE
785: fnd_msg_pub.count_and_get(p_count => x_msg_count,
786: p_data => x_msg_data);
787: END IF;

Line 791: -- If FND logging is enabled, log message as Unexpected error

787: END IF;
788: WHEN OTHERS THEN
789: ROLLBACK;
790: x_return_status := 'U';
791: -- If FND logging is enabled, log message as Unexpected error
792: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
793: -- Get the message from fnd_msg_pub and put it onto fnd_message stack so that it is logged in fnd_log_messages.
794: fnd_msg_pub.count_and_get(p_count => x_msg_count,
795: p_data => x_msg_data);

Line 792: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

788: WHEN OTHERS THEN
789: ROLLBACK;
790: x_return_status := 'U';
791: -- If FND logging is enabled, log message as Unexpected error
792: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
793: -- Get the message from fnd_msg_pub and put it onto fnd_message stack so that it is logged in fnd_log_messages.
794: fnd_msg_pub.count_and_get(p_count => x_msg_count,
795: p_data => x_msg_data);
796: IF (x_msg_count = 1) THEN

Line 793: -- Get the message from fnd_msg_pub and put it onto fnd_message stack so that it is logged in fnd_log_messages.

789: ROLLBACK;
790: x_return_status := 'U';
791: -- If FND logging is enabled, log message as Unexpected error
792: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
793: -- Get the message from fnd_msg_pub and put it onto fnd_message stack so that it is logged in fnd_log_messages.
794: fnd_msg_pub.count_and_get(p_count => x_msg_count,
795: p_data => x_msg_data);
796: IF (x_msg_count = 1) THEN
797: fnd_message.set_encoded(x_msg_data);

Line 802: fnd_log.message(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_fi_prc_sp_fees.assess_fees_pvt',FALSE);

798: ELSIF (x_msg_count > 1) THEN
799: x_msg_data := fnd_msg_pub.get(p_msg_index=>fnd_msg_pub.G_LAST);
800: fnd_message.set_encoded(x_msg_data);
801: END IF;
802: fnd_log.message(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_fi_prc_sp_fees.assess_fees_pvt',FALSE);
803: fnd_log.string(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_fi_prc_sp_fees.assess_fees_pvt',SQLERRM);
804: ELSE
805: fnd_msg_pub.count_and_get(p_count => x_msg_count,
806: p_data => x_msg_data);

Line 803: fnd_log.string(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_fi_prc_sp_fees.assess_fees_pvt',SQLERRM);

799: x_msg_data := fnd_msg_pub.get(p_msg_index=>fnd_msg_pub.G_LAST);
800: fnd_message.set_encoded(x_msg_data);
801: END IF;
802: fnd_log.message(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_fi_prc_sp_fees.assess_fees_pvt',FALSE);
803: fnd_log.string(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_fi_prc_sp_fees.assess_fees_pvt',SQLERRM);
804: ELSE
805: fnd_msg_pub.count_and_get(p_count => x_msg_count,
806: p_data => x_msg_data);
807: END IF;

Line 1186: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

1182: END IF;
1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: retcode := 2;
1186: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1187: fnd_log.string(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_fi_prc_sp_fees.assess_fees',SQLERRM);
1188: END IF;
1189: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
1190: igs_ge_msg_stack.conc_exception_hndl;

Line 1187: fnd_log.string(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_fi_prc_sp_fees.assess_fees',SQLERRM);

1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: retcode := 2;
1186: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1187: fnd_log.string(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_fi_prc_sp_fees.assess_fees',SQLERRM);
1188: END IF;
1189: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
1190: igs_ge_msg_stack.conc_exception_hndl;
1191: END assess_fees;

Line 1597: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

1593: RETURN TRUE;
1594:
1595: EXCEPTION
1596: WHEN OTHERS THEN
1597: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1598: fnd_log.string(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_fi_prc_sp_fees.fisp_insert_record',SQLERRM);
1599: END IF;
1600: RETURN FALSE;
1601:

Line 1598: fnd_log.string(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_fi_prc_sp_fees.fisp_insert_record',SQLERRM);

1594:
1595: EXCEPTION
1596: WHEN OTHERS THEN
1597: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1598: fnd_log.string(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_fi_prc_sp_fees.fisp_insert_record',SQLERRM);
1599: END IF;
1600: RETURN FALSE;
1601:
1602: END fisp_insert_record;

Line 1677: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

1673: END IF; -- End if for cursor cur_fee_spa NOTFOUND
1674:
1675: EXCEPTION
1676: WHEN OTHERS THEN
1677: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1678: fnd_log.string(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_fi_prc_sp_fees.fisp_lock_records',SQLERRM);
1679: END IF;
1680: RETURN FALSE;
1681:

Line 1678: fnd_log.string(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_fi_prc_sp_fees.fisp_lock_records',SQLERRM);

1674:
1675: EXCEPTION
1676: WHEN OTHERS THEN
1677: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1678: fnd_log.string(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_fi_prc_sp_fees.fisp_lock_records',SQLERRM);
1679: END IF;
1680: RETURN FALSE;
1681:
1682: END fisp_lock_records;