DBA Data[Home] [Help]

APPS.IGS_AD_IMP_ADM_DES dependencies on FND_NEW_MESSAGES

Line 35: p_error_msg IN fnd_new_messages.message_text%TYPE, -- Replaced error_code with error_msg Bug 3297241

31:
32:
33: PROCEDURE update_int_table (
34: p_status IN igs_ad_admde_int.status%TYPE,
35: p_error_msg IN fnd_new_messages.message_text%TYPE, -- Replaced error_code with error_msg Bug 3297241
36: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
37: p_outcome_status IN igs_ad_admde_int.adm_outcome_status%TYPE
38: )
39: IS

Line 76: p_error_msg OUT NOCOPY fnd_new_messages.message_name%TYPE, -- Replaced error_code with error_msg Bug 3297241

72: p_decision_reason_id OUT NOCOPY igs_ad_ps_appl_inst.decision_reason_id%TYPE,
73: p_pending_reason_id OUT NOCOPY igs_ad_ps_appl_inst.pending_reason_id%TYPE,
74: p_offer_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_dt%TYPE,
75: p_offer_response_dt OUT NOCOPY igs_ad_ps_appl_inst.offer_response_dt%TYPE,
76: p_error_msg OUT NOCOPY fnd_new_messages.message_name%TYPE, -- Replaced error_code with error_msg Bug 3297241
77: p_return_status OUT NOCOPY VARCHAR2,
78: p_prpsd_commencement_date IN igs_ad_admde_int_all.prpsd_commencement_date%TYPE DEFAULT NULL
79: )
80: IS

Line 266: p_error_message OUT NOCOPY fnd_new_messages.message_text%TYPE,

262: p_s_admission_process_type IN igs_ad_appl.s_admission_process_type%TYPE,
263: p_batch_id IN igs_ad_admde_int.batch_id%TYPE,
264: p_interface_run_id IN igs_ad_admde_int.interface_run_id%TYPE,
265: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
266: p_error_message OUT NOCOPY fnd_new_messages.message_text%TYPE,
267: p_return_status OUT NOCOPY VARCHAR2,
268: p_ucas_transaction IN VARCHAR2,
269: p_reconsideration IN VARCHAR2,
270: p_prpsd_commencement_date IN igs_ad_admde_int_all.prpsd_commencement_date%TYPE

Line 380: l_error_msg FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

376: AND s_admission_step_type = 'RECONSIDER';
377:
378: l_check_reconsider VARCHAR2(1);
379: l_uc_tran_id igs_uc_transactions.uc_tran_id%TYPE;
380: l_error_msg FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
381: l_err_msg FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
382: l_return_status VARCHAR2(1);
383: l_msg_data VARCHAR2(2000);
384: l_msg_count NUMBER;

Line 381: l_err_msg FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

377:
378: l_check_reconsider VARCHAR2(1);
379: l_uc_tran_id igs_uc_transactions.uc_tran_id%TYPE;
380: l_error_msg FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
381: l_err_msg FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
382: l_return_status VARCHAR2(1);
383: l_msg_data VARCHAR2(2000);
384: l_msg_count NUMBER;
385:

Line 585: l_error_msg fnd_new_messages.message_text%TYPE;

581: AND nominated_course_cd = cp_nominated_course_cd
582: AND sequence_number = cp_sequence_number;
583:
584: l_old_adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;
585: l_error_msg fnd_new_messages.message_text%TYPE;
586:
587: BEGIN
588: DECLARE
589: l_gather_status VARCHAR2(5);