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.IGS_FI_PRC_SP_FEES dependencies on FND_MSG_PUB

Line 72: fnd_msg_pub.add;

68: BEGIN
69: -- Seperator: ------------
70: fnd_message.set_name('IGS','IGS_FI_END_DATE');
71: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
72: fnd_msg_pub.add;
73: -- Person Number:
74: fnd_message.set_name('IGS','IGS_FI_END_DATE');
75: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||p_v_person_number);
76: fnd_msg_pub.add;

Line 76: fnd_msg_pub.add;

72: fnd_msg_pub.add;
73: -- Person Number:
74: fnd_message.set_name('IGS','IGS_FI_END_DATE');
75: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||p_v_person_number);
76: fnd_msg_pub.add;
77: --Logging Fee Assessment Period.
78: fnd_message.set_name('IGS','IGS_FI_END_DATE');
79: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_ASS_PERIOD')||': '|| p_v_fee_period );
80: fnd_msg_pub.add;

Line 80: fnd_msg_pub.add;

76: fnd_msg_pub.add;
77: --Logging Fee Assessment Period.
78: fnd_message.set_name('IGS','IGS_FI_END_DATE');
79: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_ASS_PERIOD')||': '|| p_v_fee_period );
80: fnd_msg_pub.add;
81: -- Unit Section:
82: fnd_message.set_name('IGS','IGS_FI_END_DATE');
83: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','USEC')||': '||p_v_unit_section_desc);
84: fnd_msg_pub.add;

Line 84: fnd_msg_pub.add;

80: fnd_msg_pub.add;
81: -- Unit Section:
82: fnd_message.set_name('IGS','IGS_FI_END_DATE');
83: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','USEC')||': '||p_v_unit_section_desc);
84: fnd_msg_pub.add;
85: -- Fee Type:
86: IF p_v_fee_type IS NOT NULL THEN
87: fnd_message.set_name('IGS','IGS_FI_END_DATE');
88: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||': '||p_v_fee_type);

Line 89: fnd_msg_pub.add;

85: -- Fee Type:
86: IF p_v_fee_type IS NOT NULL THEN
87: fnd_message.set_name('IGS','IGS_FI_END_DATE');
88: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_TYPE')||': '||p_v_fee_type);
89: fnd_msg_pub.add;
90: END IF;
91: END log_details;
92:
93:

Line 405: fnd_msg_pub.initialize;

401: x_return_status := 'S';
402:
403: -- Initialize the stack if log messages = True
404: IF p_b_log_messages THEN
405: fnd_msg_pub.initialize;
406: END IF;
407:
408: -- If any of the mandatory parameters have not been provided, log the message
409: IF (p_n_person_id IS NULL) OR(p_v_course_cd IS NULL) OR (p_n_uoo_id IS NULL) OR

Line 415: fnd_msg_pub.add;

411: (p_v_load_cal_type IS NULL) OR (p_n_load_ci_sequence_number IS NULL) OR
412: (p_d_gl_date IS NULL) OR (p_b_log_messages IS NULL) THEN
413: IF p_b_log_messages THEN
414: fnd_message.set_name('IGS','IGS_FI_PARAMETER_NULL');
415: fnd_msg_pub.add;
416: END IF;
417: RAISE e_expected_error;
418: END IF;
419:

Line 432: fnd_msg_pub.add;

428: p_v_message_name => l_v_message_name);
429: IF l_v_message_name IS NOT NULL THEN
430: IF p_b_log_messages THEN
431: fnd_message.set_name('IGS',l_v_message_name);
432: fnd_msg_pub.add;
433: END IF;
434: RAISE e_expected_error;
435: END IF;
436:

Line 562: fnd_msg_pub.add;

558: IF p_b_log_messages THEN
559: -- Message that the fee has been declined, so no further processing would happen
560: fnd_message.set_name('IGS','IGS_FI_SP_FEE_DECLINED');
561: fnd_message.set_token('INVOICE_NUM',l_v_invoice_number);
562: fnd_msg_pub.add;
563: END IF;
564: ELSE
565: -- Charge not reversed or declined.
566: -- Continue normal processing for charges that are not declined

Line 638: fnd_msg_pub.add;

634: IF l_v_ret_status <> 'S' THEN
635: -- Message that no transactions have been carried out due to some error
636: fnd_message.set_name('IGS','IGS_FI_SP_NO_CHARGE');
637: fnd_message.set_token('PERSON_NUMBER',p_v_person_number);
638: fnd_msg_pub.add;
639: RAISE e_expected_error;
640: END IF;
641:
642: -- After creation of retention charge, insert a record into the Special Fees table

Line 691: fnd_msg_pub.add;

687: IF l_v_ret_status <> 'S' THEN
688: -- Message that no transactions have been carried out due to some error
689: fnd_message.set_name('IGS','IGS_FI_SP_NO_CHARGE');
690: fnd_message.set_token('PERSON_NUMBER',p_v_person_number);
691: fnd_msg_pub.add;
692: RAISE e_expected_error;
693: END IF;
694:
695: -- After creation of a special charge, insert a record into the Special Fees table

Line 721: fnd_msg_pub.add;

717: -- Message that a new charge has been created
718: fnd_message.set_name('IGS','IGS_FI_SPECIAL_FEE_CREATED');
719: fnd_message.set_token('INVOICE_NUMBER',igs_fi_gen_008.get_invoice_number(l_n_invoice_id));
720: fnd_message.set_token('AMT',l_n_net_amount);
721: fnd_msg_pub.add;
722: ELSIF l_n_net_amount < 0.0 THEN
723: -- Message that the charge has been reversed
724: fnd_message.set_name('IGS','IGS_FI_SPECIAL_FEE_REVERSED');
725: fnd_message.set_token('INVOICE_NUMBER',igs_fi_gen_008.get_invoice_number(l_sp_fees_tbl(l_n_tbl_cnt).invoice_id));

Line 727: fnd_msg_pub.add;

723: -- Message that the charge has been reversed
724: fnd_message.set_name('IGS','IGS_FI_SPECIAL_FEE_REVERSED');
725: fnd_message.set_token('INVOICE_NUMBER',igs_fi_gen_008.get_invoice_number(l_sp_fees_tbl(l_n_tbl_cnt).invoice_id));
726: fnd_message.set_token('AMT',l_sp_fees_tbl(l_n_tbl_cnt).old_amount);
727: fnd_msg_pub.add;
728: IF l_n_retention_amt > 0.0 THEN
729: -- Message that a retention charge has been created
730: fnd_message.set_name('IGS','IGS_FI_RET_TRANSACTION_AMT');
731: fnd_message.set_token('AMOUNT',l_n_retention_amt);

Line 732: fnd_msg_pub.add;

728: IF l_n_retention_amt > 0.0 THEN
729: -- Message that a retention charge has been created
730: fnd_message.set_name('IGS','IGS_FI_RET_TRANSACTION_AMT');
731: fnd_message.set_token('AMOUNT',l_n_retention_amt);
732: fnd_msg_pub.add;
733: END IF;
734: END IF; -- End of check for l_n_net_amount
735: END IF; -- End of log_messages = 'TRUE'
736:

Line 741: fnd_msg_pub.add;

737: ELSE
738: IF p_b_log_messages THEN
739: -- Message that there is no change in the charge amount
740: fnd_message.set_name('IGS','IGS_FI_SP_FEE_NO_CHANGE');
741: fnd_msg_pub.add;
742: END IF;
743: END IF; -- End for net_amount <> 0
744:
745: END IF; -- End for l_b_chg_decl_rev

Line 758: fnd_msg_pub.add;

754: p_v_fee_period => p_v_fee_period,
755: p_v_unit_section_desc => l_v_unit_section_desc,
756: p_v_fee_type => NULL);
757: fnd_message.set_name('IGF', 'IGF_AP_NO_DATA_FOUND');
758: fnd_msg_pub.add;
759: END IF;
760: END IF; -- End for tbl count > 0
761:
762: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 762: fnd_msg_pub.count_and_get(p_count => x_msg_count,

758: fnd_msg_pub.add;
759: END IF;
760: END IF; -- End for tbl count > 0
761:
762: fnd_msg_pub.count_and_get(p_count => x_msg_count,
763: p_data => x_msg_data);
764:
765: EXCEPTION
766: WHEN e_expected_error THEN

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 773: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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);
777: ELSIF (x_msg_count > 1) THEN

Line 778: x_msg_data := fnd_msg_pub.get(p_msg_index=>fnd_msg_pub.G_LAST);

774: p_data => x_msg_data);
775: IF (x_msg_count = 1) THEN
776: fnd_message.set_encoded(x_msg_data);
777: ELSIF (x_msg_count > 1) THEN
778: x_msg_data := fnd_msg_pub.get(p_msg_index=>fnd_msg_pub.G_LAST);
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

Line 785: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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;
788: WHEN OTHERS THEN
789: ROLLBACK;

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 794: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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);
798: ELSIF (x_msg_count > 1) THEN

Line 799: x_msg_data := fnd_msg_pub.get(p_msg_index=>fnd_msg_pub.G_LAST);

795: p_data => x_msg_data);
796: IF (x_msg_count = 1) THEN
797: fnd_message.set_encoded(x_msg_data);
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);

Line 805: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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;
808: END assess_fees_pvt;
809:

Line 1494: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');

1490: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
1491: fnd_file.put_line(fnd_file.log,fnd_message.get);
1492: ELSIF l_n_msg_count <> 0 THEN
1493: FOR l_count IN 1 .. l_n_msg_count LOOP
1494: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');
1495: fnd_message.set_encoded(l_msg);
1496: fnd_file.put_line(fnd_file.log,fnd_message.get);
1497: END LOOP;
1498: fnd_message.set_name('IGS','IGS_FI_END_DATE');