APPS.IGS_FI_GEN_001 dependencies on FND_NEW_MESSAGES

Line 1128: v_message_name fnd_new_messages.message_name%TYPE;

1124: cst_discount CONSTANT VARCHAR2(10) := 'DISCOUNT';
1125: v_fp_total NUMBER;
1126: v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1127: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1128: v_message_name fnd_new_messages.message_name%TYPE;
1129:
1130: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1131: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1132: SELECT SUM(fas.transaction_amount/fas.exchange_rate)

Line 1207: v_message_name fnd_new_messages.message_name%TYPE;

1203: cst_hecs CONSTANT VARCHAR2(4) := 'HECS';
1204: v_fp_total NUMBER;
1205: v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1206: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1207: v_message_name fnd_new_messages.message_name%TYPE;
1208: --modification to the Cursor c_fp_total to point to the table IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.
1209: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1210: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1211: SELECT SUM(fadv.transaction_amount/fadv.exchange_rate) local_assessment_amount

Line 1369: v_message_name fnd_new_messages.message_name%TYPE;

1365: cst_tuition VARCHAR2(7) := 'TUTNFEE';
1366: v_loc_ass_amt NUMBER;
1367: v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1368: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1369: v_message_name fnd_new_messages.message_name%TYPE;
1370:
1371: CURSOR c_local_ass_amt(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1372: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1373: SELECT SUM(fadv.transaction_amount/fadv.exchange_rate) local_assessment_amount

Line 1447: p_message_name OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE)

1443: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1444: p_cal_category IN igs_ca_type.s_cal_cat%TYPE,
1445: p_ret_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
1446: p_ret_ci_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1447: p_message_name OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_NAME%TYPE)
1448: RETURN BOOLEAN AS
1449: -- To derive the subordinate Load Calendar Instance uniquely linked
1450: -- to the passed superior Fee calendar Instance
1451:

Line 1521: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

1517: RETURN VARCHAR2 AS
1518:
1519: l_cal_type igs_ca_inst.cal_type%TYPE;
1520: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1521: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1522:
1523: BEGIN
1524: IF igs_fi_gen_001.FINP_GET_LFCI_RELN(
1525: p_cal_type,

Line 1541: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)

1537: APP_EXCEPTION.RAISE_EXCEPTION;
1538: END finp_chk_lfci_reln;
1539:
1540: FUNCTION finp_get_planned_credits_ind(
1541: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)
1542:
1543: RETURN VARCHAR2 AS
1544: /******************************************************************
1545: Created By : SYkrishn

Line 1587: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)

1583:
1584: p_person_id IN igs_fi_parties_v.person_id%TYPE,
1585: p_start_date IN DATE,
1586: p_end_date IN DATE,
1587: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)
1588:
1589: RETURN NUMBER AS
1590: /******************************************************************
1591: Created By : SYkrishn