3274: PROCEDURE show_errors(p_messages IN OUT NOCOPY message_table) IS
3275:
3276: l_message_count NUMBER;
3277: l_error_message VARCHAR2(4000);
3278: l_fnd_separator VARCHAR2(5) := FND_GLOBAL.LOCAL_CHR(0);
3279: l_token_table hxc_deposit_wrapper_utilities.t_simple_table;
3280:
3281: BEGIN
3282: --
3914: l_message_count NUMBER;
3915: l_mode VARCHAR2(30) := 'UPDATE';
3916: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
3917: l_resubmitted VARCHAR2(3);
3918: l_fnd_separator VARCHAR2(5) := FND_GLOBAL.LOCAL_CHR(0);
3919: l_error_message VARCHAR2(4000);
3920: l_temp_temp_name hxc_time_Attributes.attribute1%type;
3921: l_transaction_tab hxc_deposit_wrapper_utilities.t_transaction;
3922: l_overall_status varchar2(7) := 'SUCCESS';
4169:
4170: IF recipt_rec.application_update_process IS NOT NULL THEN
4171: IF code_chk(recipt_rec.application_update_process) THEN
4172:
4173: l_upd_sql := 'BEGIN '||fnd_global.newline
4174: ||recipt_rec.application_update_process ||fnd_global.newline
4175: ||'(p_operation => :1);'||fnd_global.newline
4176: ||'END;';
4177:
4170: IF recipt_rec.application_update_process IS NOT NULL THEN
4171: IF code_chk(recipt_rec.application_update_process) THEN
4172:
4173: l_upd_sql := 'BEGIN '||fnd_global.newline
4174: ||recipt_rec.application_update_process ||fnd_global.newline
4175: ||'(p_operation => :1);'||fnd_global.newline
4176: ||'END;';
4177:
4178: EXECUTE IMMEDIATE l_upd_sql
4171: IF code_chk(recipt_rec.application_update_process) THEN
4172:
4173: l_upd_sql := 'BEGIN '||fnd_global.newline
4174: ||recipt_rec.application_update_process ||fnd_global.newline
4175: ||'(p_operation => :1);'||fnd_global.newline
4176: ||'END;';
4177:
4178: EXECUTE IMMEDIATE l_upd_sql
4179: using IN OUT l_mode;
4219:
4220: IF recipt_rec.appl_validation_process IS NOT NULL THEN
4221: IF code_chk(recipt_rec.appl_validation_process) THEN
4222:
4223: l_val_sql := 'BEGIN '||fnd_global.newline
4224: ||recipt_rec.appl_validation_process ||fnd_global.newline
4225: ||'(p_operation => :1);'||fnd_global.newline
4226: ||'END;';
4227:
4220: IF recipt_rec.appl_validation_process IS NOT NULL THEN
4221: IF code_chk(recipt_rec.appl_validation_process) THEN
4222:
4223: l_val_sql := 'BEGIN '||fnd_global.newline
4224: ||recipt_rec.appl_validation_process ||fnd_global.newline
4225: ||'(p_operation => :1);'||fnd_global.newline
4226: ||'END;';
4227:
4228: EXECUTE IMMEDIATE l_val_sql
4221: IF code_chk(recipt_rec.appl_validation_process) THEN
4222:
4223: l_val_sql := 'BEGIN '||fnd_global.newline
4224: ||recipt_rec.appl_validation_process ||fnd_global.newline
4225: ||'(p_operation => :1);'||fnd_global.newline
4226: ||'END;';
4227:
4228: EXECUTE IMMEDIATE l_val_sql
4229: using IN OUT l_mode;