DBA Data[Home] [Help]

APPS.IGS_FI_PRC_STDNT_DPSTS dependencies on FND_NEW_MESSAGES

Line 301: p_c_message_name fnd_new_messages.message_name%TYPE,

297: p_c_credit_number igs_fi_credits.credit_number%TYPE,
298: p_n_amount igs_fi_credits.amount%TYPE,
299: p_c_action VARCHAR2,
300: p_c_payment_cr_num igs_fi_credits.credit_number%TYPE,
301: p_c_message_name fnd_new_messages.message_name%TYPE,
302: p_c_sca_att_status igs_lookup_values.lookup_code%TYPE) AS
303: /******************************************************************
304: Created By : Vinay Chappidi
305: Date Created By : 05-DEC-2002

Line 333: l_c_message_text fnd_new_messages.message_text%TYPE;

329:
330: rec_cur_cr_type_names cur_cr_type_names%ROWTYPE;
331:
332: l_c_person c_person%ROWTYPE;
333: l_c_message_text fnd_new_messages.message_text%TYPE;
334:
335: BEGIN
336:
337: OPEN c_person(p_n_person_id);

Line 416: l_v_message_text fnd_new_messages.message_text%TYPE;

412: credit_class = p_c_credit_class;
413:
414: l_b_return_val BOOLEAN := FALSE;
415: l_c_credit_type c_credit_type%ROWTYPE;
416: l_v_message_text fnd_new_messages.message_text%TYPE;
417: BEGIN
418: OPEN c_credit_type(p_c_credit_type_id);
419: FETCH c_credit_type INTO l_c_credit_type;
420: IF c_credit_type%NOTFOUND THEN

Line 455: l_v_message_text fnd_new_messages.message_text%TYPE;

451: vchappid 09-Jan-2003 Bug# 2729935, Invalid Value token is removed from all parameters when the
452: input parameter is an invalid value
453: ******************************************************************/
454:
455: l_v_message_text fnd_new_messages.message_text%TYPE;
456: l_b_return_val BOOLEAN;
457: BEGIN
458: IF p_c_credit_class NOT IN (g_c_enrdeposit, g_c_othdeposit) THEN
459: l_b_return_val := FALSE;

Line 501: l_v_message_text fnd_new_messages.message_text%TYPE;

497: FROM hz_parties
498: WHERE party_id = cp_n_person_id;
499:
500: l_c_person_number hz_parties.party_number%TYPE;
501: l_v_message_text fnd_new_messages.message_text%TYPE;
502: l_b_return_val BOOLEAN;
503:
504: BEGIN
505: OPEN c_person(p_n_person_id);

Line 552: l_v_message_text fnd_new_messages.message_text%TYPE;

548: closed_ind = 'N';
549: l_c_group_cd igs_pe_persid_group.group_cd%TYPE;
550:
551: l_b_return_val BOOLEAN;
552: l_v_message_text fnd_new_messages.message_text%TYPE;
553:
554: BEGIN
555: OPEN c_check_prsn_grp;
556: FETCH c_check_prsn_grp INTO l_c_group_cd;

Line 605: l_c_message_text fnd_new_messages.message_text%TYPE;

601:
602: l_rec_c_cal_inst c_cal_inst%ROWTYPE;
603:
604: l_b_ret_status BOOLEAN;
605: l_c_message_text fnd_new_messages.message_text%TYPE;
606:
607: BEGIN
608:
609: IF (p_c_load_cal_type IS NULL OR p_n_load_seq_number IS NULL ) THEN

Line 639: p_c_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE) AS

635:
636:
637: PROCEDURE validate_gl_date(p_d_gl_date IN DATE,
638: p_b_ret_status OUT NOCOPY BOOLEAN,
639: p_c_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE) AS
640: /******************************************************************
641: Created By : Vinay Chappidi
642: Date Created By : 05-DEC-2002
643: Purpose : validates GL Date

Line 654: l_v_message_name fnd_new_messages.message_name%TYPE;

650: input parameter is an invalid value
651: ******************************************************************/
652:
653: l_v_closing_status igs_fi_gl_periods_v.closing_status%TYPE;
654: l_v_message_name fnd_new_messages.message_name%TYPE;
655: l_v_message_text fnd_new_messages.message_text%TYPE;
656: l_b_ret_status BOOLEAN := TRUE;
657: BEGIN
658: --Validate the GL Date.

Line 655: l_v_message_text fnd_new_messages.message_text%TYPE;

651: ******************************************************************/
652:
653: l_v_closing_status igs_fi_gl_periods_v.closing_status%TYPE;
654: l_v_message_name fnd_new_messages.message_name%TYPE;
655: l_v_message_text fnd_new_messages.message_text%TYPE;
656: l_b_ret_status BOOLEAN := TRUE;
657: BEGIN
658: --Validate the GL Date.
659: igs_fi_gen_gl.get_period_status_for_date(p_d_date => p_d_gl_date,

Line 699: l_v_message_text fnd_new_messages.message_text%TYPE;

695: input parameter is an invalid value
696: ******************************************************************/
697:
698: l_b_return_val BOOLEAN;
699: l_v_message_text fnd_new_messages.message_text%TYPE;
700: BEGIN
701: IF p_c_test_mode NOT IN (g_c_yes,g_c_no) THEN
702: l_b_return_val := FALSE;
703: ELSE

Line 743: l_c_message_name fnd_new_messages.message_name%TYPE;

739: ******************************************************************/
740:
741: l_b_ret_status BOOLEAN := TRUE;
742: l_b_temp BOOLEAN := TRUE;
743: l_c_message_name fnd_new_messages.message_name%TYPE;
744:
745: BEGIN
746:
747: fnd_message.set_name('IGS','IGS_FI_PROCESS_PARAM');

Line 859: p_c_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)

855: PROCEDURE take_action(p_n_credit_id igs_fi_credits_all.credit_id%TYPE,
856: p_d_gl_date DATE,
857: p_c_action igs_lookup_values.lookup_code%TYPE,
858: p_c_credit_number OUT NOCOPY igs_fi_credits.credit_number%TYPE,
859: p_c_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE)
860: AS
861: /******************************************************************
862: Created By : Vinay Chappidi
863: Date Created By : 05-DEC-2002

Line 873: l_c_message_name fnd_new_messages.message_name%TYPE;

869: Who When What
870: ******************************************************************/
871:
872: l_b_ret_status BOOLEAN;
873: l_c_message_name fnd_new_messages.message_name%TYPE;
874: l_c_receipt_number igs_fi_credits.credit_number%TYPE;
875: BEGIN
876: IF p_c_action = g_c_transfer THEN
877: BEGIN

Line 963: l_c_message_name fnd_new_messages.message_name%TYPE;

959: )
960: ) AND
961: crd.status = 'CLEARED';
962:
963: l_c_message_name fnd_new_messages.message_name%TYPE;
964: l_c_credit_number igs_fi_credits.credit_number%TYPE;
965: l_b_othdep_exists BOOLEAN := FALSE;
966: BEGIN
967: FOR l_rec_c_oth_dpsts IN c_oth_dpsts(p_n_person_id,l_rec_input_param.credit_type_id,l_rec_input_param.fee_cal_type, l_rec_input_param.fee_cal_seq_num)

Line 1172: l_c_message_name fnd_new_messages.message_name%TYPE;

1168: l_c_outcome igs_lookup_values.lookup_code%TYPE := g_c_forfeit;
1169: l_c_criteria igs_lookup_values.lookup_code%TYPE;
1170: l_c_sca_att_status igs_lookup_values.lookup_code%TYPE;
1171:
1172: l_c_message_name fnd_new_messages.message_name%TYPE;
1173: l_c_credit_number igs_fi_credits.credit_number%TYPE;
1174:
1175: BEGIN
1176:

Line 1487: l_c_message_name fnd_new_messages.message_name%TYPE := NULL;

1483: l_n_fee_ci_seq_num igs_ca_inst.sequence_number%TYPE;
1484:
1485: l_b_ret_status BOOLEAN;
1486:
1487: l_c_message_name fnd_new_messages.message_name%TYPE := NULL;
1488:
1489: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
1490:
1491: BEGIN