DBA Data[Home] [Help]

APPS.IGS_TR_GEN_002 dependencies on IGS_GE_DATE

Line 644: lv_param_values:=igs_ge_date.igschar (p_completion_dt)||','||TO_CHAR(p_action_days);

640: lv_param_values:=TO_CHAR(p_tracking_step_number)||','||p_description;
641: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
642: fnd_message.set_token('VALUE',lv_param_values);
643: igs_ge_msg_stack.ADD;
644: lv_param_values:=igs_ge_date.igschar (p_completion_dt)||','||TO_CHAR(p_action_days);
645: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
646: fnd_message.set_token('VALUE',lv_param_values);
647: igs_ge_msg_stack.ADD;
648: lv_param_values:=p_step_completion_ind||','||p_by_pass_ind||','||TO_CHAR(p_recipient_id );

Line 1098: lv_param_values:= igs_ge_date.igschar (p_start_dt)||','|| TO_CHAR(p_target_days)||','||p_sequence_ind ;

1094: lv_param_values:= p_tracking_status ||','||p_tracking_type||','||TO_CHAR(p_source_person_id );
1095: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1096: fnd_message.set_token('VALUE',lv_param_values);
1097: igs_ge_msg_stack.ADD;
1098: lv_param_values:= igs_ge_date.igschar (p_start_dt)||','|| TO_CHAR(p_target_days)||','||p_sequence_ind ;
1099: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1100: fnd_message.set_token('VALUE',lv_param_values);
1101: igs_ge_msg_stack.ADD;
1102: lv_param_values:= p_business_days_ind ||','||TO_CHAR(p_originator_person_id )||','||p_s_created_ind ;

Line 1780: ||','||p_date_type||','||igs_ge_date.igschar (p_start_dt)

1776: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1777: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_upd_trst.process_date.validate_date'||'-'||SQLERRM);
1778: igs_ge_msg_stack.ADD;
1779: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number)||','||TO_CHAR(p_action_days)
1780: ||','||p_date_type||','||igs_ge_date.igschar (p_start_dt)
1781: ||','||igs_ge_date.igschar (p_end_dt);
1782: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1783: fnd_message.set_token('VALUE',lv_param_values);
1784: igs_ge_msg_stack.ADD;

Line 1781: ||','||igs_ge_date.igschar (p_end_dt);

1777: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_upd_trst.process_date.validate_date'||'-'||SQLERRM);
1778: igs_ge_msg_stack.ADD;
1779: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number)||','||TO_CHAR(p_action_days)
1780: ||','||p_date_type||','||igs_ge_date.igschar (p_start_dt)
1781: ||','||igs_ge_date.igschar (p_end_dt);
1782: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1783: fnd_message.set_token('VALUE',lv_param_values);
1784: igs_ge_msg_stack.ADD;
1785: app_exception.raise_exception;

Line 1886: ','||igs_ge_date.igschar (p_end_dt)||','||TO_CHAR(p_action_days);

1882: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1883: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_upd_trst.process_date'||'-'||SQLERRM);
1884: igs_ge_msg_stack.ADD;
1885: lv_param_values:= p_date_type||','||TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number)||
1886: ','||igs_ge_date.igschar (p_end_dt)||','||TO_CHAR(p_action_days);
1887: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1888: fnd_message.set_token('VALUE',lv_param_values);
1889: igs_ge_msg_stack.ADD;
1890: app_exception.raise_exception;

Line 2354: lv_param_values:= igs_ge_date.igschar (p_action_dt)||','||igs_ge_date.igschar (p_completion_dt);

2350: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_id)||','||p_s_tracking_step_type;
2351: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
2352: fnd_message.set_token('VALUE',lv_param_values);
2353: igs_ge_msg_stack.ADD;
2354: lv_param_values:= igs_ge_date.igschar (p_action_dt)||','||igs_ge_date.igschar (p_completion_dt);
2355: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
2356: fnd_message.set_token('VALUE',lv_param_values);
2357: igs_ge_msg_stack.ADD;
2358: lv_param_values:= p_step_completion_ind ||','||p_by_pass_ind ||','||TO_CHAR(p_recipient_id);