83: p_message_name := 'IGS_TR_ITEM_STEP_NOTE_LOCKED';
84: RETURN FALSE;
85:
86: WHEN OTHERS THEN
87: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
88: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tsn'||'-'||SQLERRM);
89: igs_ge_msg_stack.ADD;
90: lv_param_values:= TO_CHAR(lp_tracking_id);
91: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
84: RETURN FALSE;
85:
86: WHEN OTHERS THEN
87: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
88: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tsn'||'-'||SQLERRM);
89: igs_ge_msg_stack.ADD;
90: lv_param_values:= TO_CHAR(lp_tracking_id);
91: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
92: fnd_message.set_token('VALUE',lv_param_values);
87: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
88: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tsn'||'-'||SQLERRM);
89: igs_ge_msg_stack.ADD;
90: lv_param_values:= TO_CHAR(lp_tracking_id);
91: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
92: fnd_message.set_token('VALUE',lv_param_values);
93: igs_ge_msg_stack.ADD;
94: app_exception.raise_exception;
95:
88: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tsn'||'-'||SQLERRM);
89: igs_ge_msg_stack.ADD;
90: lv_param_values:= TO_CHAR(lp_tracking_id);
91: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
92: fnd_message.set_token('VALUE',lv_param_values);
93: igs_ge_msg_stack.ADD;
94: app_exception.raise_exception;
95:
96: END trkpl_del_tsn;
128: p_message_name := 'IGS_TR_STEP_RECORD_LOCKED';
129: RETURN FALSE;
130:
131: WHEN OTHERS THEN
132: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
133: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_ts'||'-'||SQLERRM);
134: igs_ge_msg_stack.ADD;
135: lv_param_values:= TO_CHAR(lp_tracking_id);
136: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
129: RETURN FALSE;
130:
131: WHEN OTHERS THEN
132: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
133: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_ts'||'-'||SQLERRM);
134: igs_ge_msg_stack.ADD;
135: lv_param_values:= TO_CHAR(lp_tracking_id);
136: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
137: fnd_message.set_token('VALUE',lv_param_values);
132: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
133: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_ts'||'-'||SQLERRM);
134: igs_ge_msg_stack.ADD;
135: lv_param_values:= TO_CHAR(lp_tracking_id);
136: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
137: fnd_message.set_token('VALUE',lv_param_values);
138: igs_ge_msg_stack.ADD;
139: app_exception.raise_exception;
140:
133: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_ts'||'-'||SQLERRM);
134: igs_ge_msg_stack.ADD;
135: lv_param_values:= TO_CHAR(lp_tracking_id);
136: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
137: fnd_message.set_token('VALUE',lv_param_values);
138: igs_ge_msg_stack.ADD;
139: app_exception.raise_exception;
140:
141: END trkpl_del_ts;
171: p_message_name := 'IGS_TR_GRP_RECORD_LOCKED';
172: RETURN FALSE;
173:
174: WHEN OTHERS THEN
175: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
176: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tgm'||'-'||SQLERRM);
177: igs_ge_msg_stack.ADD;
178: lv_param_values:= TO_CHAR(lp_tracking_id);
179: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
172: RETURN FALSE;
173:
174: WHEN OTHERS THEN
175: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
176: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tgm'||'-'||SQLERRM);
177: igs_ge_msg_stack.ADD;
178: lv_param_values:= TO_CHAR(lp_tracking_id);
179: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
180: fnd_message.set_token('VALUE',lv_param_values);
175: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
176: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tgm'||'-'||SQLERRM);
177: igs_ge_msg_stack.ADD;
178: lv_param_values:= TO_CHAR(lp_tracking_id);
179: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
180: fnd_message.set_token('VALUE',lv_param_values);
181: igs_ge_msg_stack.ADD;
182: app_exception.raise_exception;
183:
176: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tgm'||'-'||SQLERRM);
177: igs_ge_msg_stack.ADD;
178: lv_param_values:= TO_CHAR(lp_tracking_id);
179: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
180: fnd_message.set_token('VALUE',lv_param_values);
181: igs_ge_msg_stack.ADD;
182: app_exception.raise_exception;
183:
184: END trkpl_del_tgm;
223: p_message_name := 'IGS_TR_ITEM_NOTE_REC_LOCKED';
224: RETURN FALSE;
225:
226: WHEN OTHERS THEN
227: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
228: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tin'||'-'||SQLERRM);
229: igs_ge_msg_stack.ADD;
230: lv_param_values:= TO_CHAR(lp_tracking_id);
231: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
224: RETURN FALSE;
225:
226: WHEN OTHERS THEN
227: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
228: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tin'||'-'||SQLERRM);
229: igs_ge_msg_stack.ADD;
230: lv_param_values:= TO_CHAR(lp_tracking_id);
231: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
232: fnd_message.set_token('VALUE',lv_param_values);
227: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
228: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tin'||'-'||SQLERRM);
229: igs_ge_msg_stack.ADD;
230: lv_param_values:= TO_CHAR(lp_tracking_id);
231: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
232: fnd_message.set_token('VALUE',lv_param_values);
233: igs_ge_msg_stack.ADD;
234: app_exception.raise_exception;
235:
228: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tin'||'-'||SQLERRM);
229: igs_ge_msg_stack.ADD;
230: lv_param_values:= TO_CHAR(lp_tracking_id);
231: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
232: fnd_message.set_token('VALUE',lv_param_values);
233: igs_ge_msg_stack.ADD;
234: app_exception.raise_exception;
235:
236: END trkpl_del_tin;
267: p_message_name := 'IGS_TR_ITEM_RECORD_LOCKED';
268: RETURN FALSE;
269:
270: WHEN OTHERS THEN
271: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
272: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tri'||'-'||SQLERRM);
273: igs_ge_msg_stack.ADD;
274: lv_param_values:= TO_CHAR(lp_tracking_id);
275: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
268: RETURN FALSE;
269:
270: WHEN OTHERS THEN
271: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
272: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tri'||'-'||SQLERRM);
273: igs_ge_msg_stack.ADD;
274: lv_param_values:= TO_CHAR(lp_tracking_id);
275: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
276: fnd_message.set_token('VALUE',lv_param_values);
271: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
272: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tri'||'-'||SQLERRM);
273: igs_ge_msg_stack.ADD;
274: lv_param_values:= TO_CHAR(lp_tracking_id);
275: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
276: fnd_message.set_token('VALUE',lv_param_values);
277: igs_ge_msg_stack.ADD;
278: app_exception.raise_exception;
279:
272: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tri'||'-'||SQLERRM);
273: igs_ge_msg_stack.ADD;
274: lv_param_values:= TO_CHAR(lp_tracking_id);
275: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
276: fnd_message.set_token('VALUE',lv_param_values);
277: igs_ge_msg_stack.ADD;
278: app_exception.raise_exception;
279:
280: END trkpl_del_tri;
314: p_message_name := 'IGS_TR_LIMIT_RECORD_LOCKED';
315: RETURN FALSE;
316:
317: WHEN OTHERS THEN
318: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
319: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_grp_lmt'||'-'||SQLERRM);
320: igs_ge_msg_stack.add;
321: lv_param_values:= TO_CHAR(lp_tracking_id);
322: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
315: RETURN FALSE;
316:
317: WHEN OTHERS THEN
318: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
319: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_grp_lmt'||'-'||SQLERRM);
320: igs_ge_msg_stack.add;
321: lv_param_values:= TO_CHAR(lp_tracking_id);
322: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
323: fnd_message.set_token('VALUE',lv_param_values);
318: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
319: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_grp_lmt'||'-'||SQLERRM);
320: igs_ge_msg_stack.add;
321: lv_param_values:= TO_CHAR(lp_tracking_id);
322: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
323: fnd_message.set_token('VALUE',lv_param_values);
324: igs_ge_msg_stack.add;
325: app_exception.raise_exception;
326:
319: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_grp_lmt'||'-'||SQLERRM);
320: igs_ge_msg_stack.add;
321: lv_param_values:= TO_CHAR(lp_tracking_id);
322: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
323: fnd_message.set_token('VALUE',lv_param_values);
324: igs_ge_msg_stack.add;
325: app_exception.raise_exception;
326:
327: END trkpl_del_grp_lmt; /* End of the procedure */
352: END;
353:
354: EXCEPTION
355: WHEN OTHERS THEN
356: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
357: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_del_tri'||'-'||SQLERRM);
358: igs_ge_msg_stack.ADD;
359: lv_param_values:= TO_CHAR(p_tracking_id);
360: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
353:
354: EXCEPTION
355: WHEN OTHERS THEN
356: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
357: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_del_tri'||'-'||SQLERRM);
358: igs_ge_msg_stack.ADD;
359: lv_param_values:= TO_CHAR(p_tracking_id);
360: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
361: fnd_message.set_token('VALUE',lv_param_values);
356: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
357: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_del_tri'||'-'||SQLERRM);
358: igs_ge_msg_stack.ADD;
359: lv_param_values:= TO_CHAR(p_tracking_id);
360: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
361: fnd_message.set_token('VALUE',lv_param_values);
362: igs_ge_msg_stack.ADD;
363: app_exception.raise_exception;
364:
357: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_del_tri'||'-'||SQLERRM);
358: igs_ge_msg_stack.ADD;
359: lv_param_values:= TO_CHAR(p_tracking_id);
360: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
361: fnd_message.set_token('VALUE',lv_param_values);
362: igs_ge_msg_stack.ADD;
363: app_exception.raise_exception;
364:
365: END trkp_del_tri;
623: DECLARE
624: l_message_name VARCHAR2(30);
625: l_app VARCHAR2(50);
626: BEGIN
627: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
628: IF l_message_name = 'IGS_TR_STEP_CTLG_CLOSED' THEN
629: fnd_message.set_name('IGS',l_message_name);
630: igs_ge_msg_stack.ADD;
631: app_exception.raise_exception;
625: l_app VARCHAR2(50);
626: BEGIN
627: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
628: IF l_message_name = 'IGS_TR_STEP_CTLG_CLOSED' THEN
629: fnd_message.set_name('IGS',l_message_name);
630: igs_ge_msg_stack.ADD;
631: app_exception.raise_exception;
632: ELSE
633: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
629: fnd_message.set_name('IGS',l_message_name);
630: igs_ge_msg_stack.ADD;
631: app_exception.raise_exception;
632: ELSE
633: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
634: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_ins_ts_rec'||'-'||SQLERRM);
635: igs_ge_msg_stack.ADD;
636: lv_param_values:=TO_CHAR(p_tracking_id)||','||TO_CHAR(p_tracking_step_id);
637: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
630: igs_ge_msg_stack.ADD;
631: app_exception.raise_exception;
632: ELSE
633: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
634: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_ins_ts_rec'||'-'||SQLERRM);
635: igs_ge_msg_stack.ADD;
636: lv_param_values:=TO_CHAR(p_tracking_id)||','||TO_CHAR(p_tracking_step_id);
637: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
638: fnd_message.set_token('VALUE',lv_param_values);
633: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
634: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_ins_ts_rec'||'-'||SQLERRM);
635: igs_ge_msg_stack.ADD;
636: lv_param_values:=TO_CHAR(p_tracking_id)||','||TO_CHAR(p_tracking_step_id);
637: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
638: fnd_message.set_token('VALUE',lv_param_values);
639: igs_ge_msg_stack.ADD;
640: lv_param_values:=TO_CHAR(p_tracking_step_number)||','||p_description;
641: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
634: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_ins_ts_rec'||'-'||SQLERRM);
635: igs_ge_msg_stack.ADD;
636: lv_param_values:=TO_CHAR(p_tracking_id)||','||TO_CHAR(p_tracking_step_id);
637: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
638: fnd_message.set_token('VALUE',lv_param_values);
639: igs_ge_msg_stack.ADD;
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);
637: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
638: fnd_message.set_token('VALUE',lv_param_values);
639: igs_ge_msg_stack.ADD;
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');
638: fnd_message.set_token('VALUE',lv_param_values);
639: igs_ge_msg_stack.ADD;
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);
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 );
649: 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 );
649: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
650: fnd_message.set_token('VALUE',lv_param_values);
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 );
649: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
650: fnd_message.set_token('VALUE',lv_param_values);
651: igs_ge_msg_stack.ADD;
652: lv_param_values:=p_s_tracking_step_type;
653: 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 );
649: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
650: fnd_message.set_token('VALUE',lv_param_values);
651: igs_ge_msg_stack.ADD;
652: lv_param_values:=p_s_tracking_step_type;
653: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
654: fnd_message.set_token('VALUE',lv_param_values);
649: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
650: fnd_message.set_token('VALUE',lv_param_values);
651: igs_ge_msg_stack.ADD;
652: lv_param_values:=p_s_tracking_step_type;
653: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
654: fnd_message.set_token('VALUE',lv_param_values);
655: igs_ge_msg_stack.ADD;
656: app_exception.raise_exception;
657: END IF;
650: fnd_message.set_token('VALUE',lv_param_values);
651: igs_ge_msg_stack.ADD;
652: lv_param_values:=p_s_tracking_step_type;
653: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
654: fnd_message.set_token('VALUE',lv_param_values);
655: igs_ge_msg_stack.ADD;
656: app_exception.raise_exception;
657: END IF;
658: END;
693:
694: /* CALL ROUTINE TO COPY OLE DATA HERE */
695: EXCEPTION
696: WHEN OTHERS THEN
697: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
698: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_dup_note_rec'||'-'||SQLERRM);
699: igs_ge_msg_stack.ADD;
700: lv_param_values:=TO_CHAR(p_reference_number);
701: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
694: /* CALL ROUTINE TO COPY OLE DATA HERE */
695: EXCEPTION
696: WHEN OTHERS THEN
697: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
698: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_dup_note_rec'||'-'||SQLERRM);
699: igs_ge_msg_stack.ADD;
700: lv_param_values:=TO_CHAR(p_reference_number);
701: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
702: fnd_message.set_token('VALUE',lv_param_values);
697: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
698: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_dup_note_rec'||'-'||SQLERRM);
699: igs_ge_msg_stack.ADD;
700: lv_param_values:=TO_CHAR(p_reference_number);
701: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
702: fnd_message.set_token('VALUE',lv_param_values);
703: igs_ge_msg_stack.ADD;
704: app_exception.raise_exception;
705:
698: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_dup_note_rec'||'-'||SQLERRM);
699: igs_ge_msg_stack.ADD;
700: lv_param_values:=TO_CHAR(p_reference_number);
701: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
702: fnd_message.set_token('VALUE',lv_param_values);
703: igs_ge_msg_stack.ADD;
704: app_exception.raise_exception;
705:
706: END trkpl_dup_note_rec;
728: );
729:
730: EXCEPTION
731: WHEN OTHERS THEN
732: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
733: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_ins_tsn_rec'||'-'||SQLERRM);
734: igs_ge_msg_stack.ADD;
735: lv_param_values:=TO_CHAR(p_tracking_id)||','||TO_CHAR(p_tracking_step_id)||','||TO_CHAR(p_reference_number);
736: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
729:
730: EXCEPTION
731: WHEN OTHERS THEN
732: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
733: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_ins_tsn_rec'||'-'||SQLERRM);
734: igs_ge_msg_stack.ADD;
735: lv_param_values:=TO_CHAR(p_tracking_id)||','||TO_CHAR(p_tracking_step_id)||','||TO_CHAR(p_reference_number);
736: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
737: fnd_message.set_token('VALUE',lv_param_values);
732: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
733: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_ins_tsn_rec'||'-'||SQLERRM);
734: igs_ge_msg_stack.ADD;
735: lv_param_values:=TO_CHAR(p_tracking_id)||','||TO_CHAR(p_tracking_step_id)||','||TO_CHAR(p_reference_number);
736: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
737: fnd_message.set_token('VALUE',lv_param_values);
738: igs_ge_msg_stack.ADD;
739: lv_param_values:=p_trk_note_type;
740: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
733: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_ins_tsn_rec'||'-'||SQLERRM);
734: igs_ge_msg_stack.ADD;
735: lv_param_values:=TO_CHAR(p_tracking_id)||','||TO_CHAR(p_tracking_step_id)||','||TO_CHAR(p_reference_number);
736: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
737: fnd_message.set_token('VALUE',lv_param_values);
738: igs_ge_msg_stack.ADD;
739: lv_param_values:=p_trk_note_type;
740: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
741: fnd_message.set_token('VALUE',lv_param_values);
736: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
737: fnd_message.set_token('VALUE',lv_param_values);
738: igs_ge_msg_stack.ADD;
739: lv_param_values:=p_trk_note_type;
740: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
741: fnd_message.set_token('VALUE',lv_param_values);
742: igs_ge_msg_stack.ADD;
743: app_exception.raise_exception;
744: END trkpl_ins_tsn_rec;
737: fnd_message.set_token('VALUE',lv_param_values);
738: igs_ge_msg_stack.ADD;
739: lv_param_values:=p_trk_note_type;
740: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
741: fnd_message.set_token('VALUE',lv_param_values);
742: igs_ge_msg_stack.ADD;
743: app_exception.raise_exception;
744: END trkpl_ins_tsn_rec;
745:
765: );
766:
767: EXCEPTION
768: WHEN OTHERS THEN
769: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
770: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_ins_ts_grp_lmt'||'-'||SQLERRM);
771: igs_ge_msg_stack.add;
772: lv_param_values:=TO_CHAR(p_tracking_id)||','||TO_CHAR(p_step_group_id)||','||TO_CHAR(p_step_group_limit);
773: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
766:
767: EXCEPTION
768: WHEN OTHERS THEN
769: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
770: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_ins_ts_grp_lmt'||'-'||SQLERRM);
771: igs_ge_msg_stack.add;
772: lv_param_values:=TO_CHAR(p_tracking_id)||','||TO_CHAR(p_step_group_id)||','||TO_CHAR(p_step_group_limit);
773: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
774: fnd_message.set_token('VALUE',lv_param_values);
769: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
770: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_ins_ts_grp_lmt'||'-'||SQLERRM);
771: igs_ge_msg_stack.add;
772: lv_param_values:=TO_CHAR(p_tracking_id)||','||TO_CHAR(p_step_group_id)||','||TO_CHAR(p_step_group_limit);
773: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
774: fnd_message.set_token('VALUE',lv_param_values);
775: igs_ge_msg_stack.add;
776: app_exception.raise_exception;
777:
770: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_ins_ts_grp_lmt'||'-'||SQLERRM);
771: igs_ge_msg_stack.add;
772: lv_param_values:=TO_CHAR(p_tracking_id)||','||TO_CHAR(p_step_group_id)||','||TO_CHAR(p_step_group_limit);
773: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
774: fnd_message.set_token('VALUE',lv_param_values);
775: igs_ge_msg_stack.add;
776: app_exception.raise_exception;
777:
778: END trkpl_ins_ts_grp_lmt; /* End of the procedure */
863: DECLARE
864: l_message_name VARCHAR2(30);
865: l_app VARCHAR2(50);
866: BEGIN
867: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
868: --kumma,2989286 , if l_message_name is not null then show message else unhandled
869: IF l_message_name IS NOT NULL THEN
870: FND_MESSAGE.SET_NAME('IGS',l_message_name);
871: IGS_GE_MSG_STACK.ADD;
866: BEGIN
867: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);
868: --kumma,2989286 , if l_message_name is not null then show message else unhandled
869: IF l_message_name IS NOT NULL THEN
870: FND_MESSAGE.SET_NAME('IGS',l_message_name);
871: IGS_GE_MSG_STACK.ADD;
872: APP_EXCEPTION.RAISE_EXCEPTION;
873: ELSE
874: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
870: FND_MESSAGE.SET_NAME('IGS',l_message_name);
871: IGS_GE_MSG_STACK.ADD;
872: APP_EXCEPTION.RAISE_EXCEPTION;
873: ELSE
874: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
875: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_ins_dflt_trst'||'-'||SQLERRM);
876: igs_ge_msg_stack.ADD;
877: lv_param_values:=TO_CHAR(p_tracking_id);
878: lv_param_values:=fnd_message.get;
871: IGS_GE_MSG_STACK.ADD;
872: APP_EXCEPTION.RAISE_EXCEPTION;
873: ELSE
874: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
875: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_ins_dflt_trst'||'-'||SQLERRM);
876: igs_ge_msg_stack.ADD;
877: lv_param_values:=TO_CHAR(p_tracking_id);
878: lv_param_values:=fnd_message.get;
879: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
874: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
875: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_ins_dflt_trst'||'-'||SQLERRM);
876: igs_ge_msg_stack.ADD;
877: lv_param_values:=TO_CHAR(p_tracking_id);
878: lv_param_values:=fnd_message.get;
879: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
880: fnd_message.set_token('VALUE',lv_param_values);
881: igs_ge_msg_stack.ADD;
882: app_exception.raise_exception;
875: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_ins_dflt_trst'||'-'||SQLERRM);
876: igs_ge_msg_stack.ADD;
877: lv_param_values:=TO_CHAR(p_tracking_id);
878: lv_param_values:=fnd_message.get;
879: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
880: fnd_message.set_token('VALUE',lv_param_values);
881: igs_ge_msg_stack.ADD;
882: app_exception.raise_exception;
883: END IF;
876: igs_ge_msg_stack.ADD;
877: lv_param_values:=TO_CHAR(p_tracking_id);
878: lv_param_values:=fnd_message.get;
879: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
880: fnd_message.set_token('VALUE',lv_param_values);
881: igs_ge_msg_stack.ADD;
882: app_exception.raise_exception;
883: END IF;
884: END;
1087: END;
1088:
1089: EXCEPTION
1090: WHEN OTHERS THEN
1091: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1092: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_ins_trk_item'||'-'||SQLERRM);
1093: igs_ge_msg_stack.ADD;
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');
1088:
1089: EXCEPTION
1090: WHEN OTHERS THEN
1091: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1092: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_ins_trk_item'||'-'||SQLERRM);
1093: igs_ge_msg_stack.ADD;
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);
1091: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1092: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_ins_trk_item'||'-'||SQLERRM);
1093: igs_ge_msg_stack.ADD;
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');
1092: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_ins_trk_item'||'-'||SQLERRM);
1093: igs_ge_msg_stack.ADD;
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);
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 ;
1103: 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 ;
1103: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1104: fnd_message.set_token('VALUE',lv_param_values);
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 ;
1103: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1104: fnd_message.set_token('VALUE',lv_param_values);
1105: igs_ge_msg_stack.ADD;
1106: app_exception.raise_exception;
1107:
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 ;
1103: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1104: fnd_message.set_token('VALUE',lv_param_values);
1105: igs_ge_msg_stack.ADD;
1106: app_exception.raise_exception;
1107:
1108: END trkp_ins_trk_item;
1219: END IF;
1220:
1221: EXCEPTION
1222: WHEN OTHERS THEN
1223: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1224: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_next_step_cmplt'||'-'||SQLERRM);
1225: igs_ge_msg_stack.ADD;
1226: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number)||','||TO_CHAR(p_step_group_id);
1227: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1220:
1221: EXCEPTION
1222: WHEN OTHERS THEN
1223: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1224: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_next_step_cmplt'||'-'||SQLERRM);
1225: igs_ge_msg_stack.ADD;
1226: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number)||','||TO_CHAR(p_step_group_id);
1227: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1228: fnd_message.set_token('VALUE',lv_param_values);
1223: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1224: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_next_step_cmplt'||'-'||SQLERRM);
1225: igs_ge_msg_stack.ADD;
1226: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number)||','||TO_CHAR(p_step_group_id);
1227: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1228: fnd_message.set_token('VALUE',lv_param_values);
1229: igs_ge_msg_stack.ADD;
1230: app_exception.raise_exception;
1231: END trkp_next_step_cmplt;
1224: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_next_step_cmplt'||'-'||SQLERRM);
1225: igs_ge_msg_stack.ADD;
1226: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number)||','||TO_CHAR(p_step_group_id);
1227: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1228: fnd_message.set_token('VALUE',lv_param_values);
1229: igs_ge_msg_stack.ADD;
1230: app_exception.raise_exception;
1231: END trkp_next_step_cmplt;
1232:
1342: END IF;
1343:
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1347: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_next_grp_step_cmplt'||'-'||SQLERRM);
1348: igs_ge_msg_stack.ADD;
1349: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number)||','||TO_CHAR(p_step_group_id);
1350: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1343:
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1347: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_next_grp_step_cmplt'||'-'||SQLERRM);
1348: igs_ge_msg_stack.ADD;
1349: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number)||','||TO_CHAR(p_step_group_id);
1350: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1351: fnd_message.set_token('VALUE',lv_param_values);
1346: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1347: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_next_grp_step_cmplt'||'-'||SQLERRM);
1348: igs_ge_msg_stack.ADD;
1349: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number)||','||TO_CHAR(p_step_group_id);
1350: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1351: fnd_message.set_token('VALUE',lv_param_values);
1352: igs_ge_msg_stack.ADD;
1353: app_exception.raise_exception;
1354: END trkp_next_grp_step_cmplt;
1347: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_next_grp_step_cmplt'||'-'||SQLERRM);
1348: igs_ge_msg_stack.ADD;
1349: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number)||','||TO_CHAR(p_step_group_id);
1350: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1351: fnd_message.set_token('VALUE',lv_param_values);
1352: igs_ge_msg_stack.ADD;
1353: app_exception.raise_exception;
1354: END trkp_next_grp_step_cmplt;
1355:
1417: CLOSE c_grp_limit;
1418:
1419: EXCEPTION
1420: WHEN OTHERS THEN
1421: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1422: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_check_step_group_limit'||'-'||SQLERRM);
1423: igs_ge_msg_stack.add;
1424: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number)||','||TO_CHAR(p_step_group_id);
1425: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1418:
1419: EXCEPTION
1420: WHEN OTHERS THEN
1421: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1422: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_check_step_group_limit'||'-'||SQLERRM);
1423: igs_ge_msg_stack.add;
1424: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number)||','||TO_CHAR(p_step_group_id);
1425: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1426: fnd_message.set_token('VALUE',lv_param_values);
1421: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1422: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_check_step_group_limit'||'-'||SQLERRM);
1423: igs_ge_msg_stack.add;
1424: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number)||','||TO_CHAR(p_step_group_id);
1425: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1426: fnd_message.set_token('VALUE',lv_param_values);
1427: igs_ge_msg_stack.add;
1428: app_exception.raise_exception;
1429:
1422: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_check_step_group_limit'||'-'||SQLERRM);
1423: igs_ge_msg_stack.add;
1424: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number)||','||TO_CHAR(p_step_group_id);
1425: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1426: fnd_message.set_token('VALUE',lv_param_values);
1427: igs_ge_msg_stack.add;
1428: app_exception.raise_exception;
1429:
1430: END trkp_check_step_group_limit;
1504: END IF;
1505:
1506: EXCEPTION
1507: WHEN OTHERS THEN
1508: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1509: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_next_grp_step_cmplt'||'-'||SQLERRM);
1510: igs_ge_msg_stack.ADD;
1511: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number);
1512: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1505:
1506: EXCEPTION
1507: WHEN OTHERS THEN
1508: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1509: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_next_grp_step_cmplt'||'-'||SQLERRM);
1510: igs_ge_msg_stack.ADD;
1511: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number);
1512: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1513: fnd_message.set_token('VALUE',lv_param_values);
1508: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1509: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_next_grp_step_cmplt'||'-'||SQLERRM);
1510: igs_ge_msg_stack.ADD;
1511: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number);
1512: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1513: fnd_message.set_token('VALUE',lv_param_values);
1514: igs_ge_msg_stack.ADD;
1515: app_exception.raise_exception;
1516: END trkp_prev_step_cmplt;
1509: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_next_grp_step_cmplt'||'-'||SQLERRM);
1510: igs_ge_msg_stack.ADD;
1511: lv_param_values:= TO_CHAR(p_tracking_id) ||','||TO_CHAR(p_tracking_step_number);
1512: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
1513: fnd_message.set_token('VALUE',lv_param_values);
1514: igs_ge_msg_stack.ADD;
1515: app_exception.raise_exception;
1516: END trkp_prev_step_cmplt;
1517:
1772: RETURN TRUE;
1773: EXCEPTION
1774:
1775: WHEN OTHERS THEN
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)
1773: EXCEPTION
1774:
1775: WHEN OTHERS THEN
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);
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;
1786: END validate_date;
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;
1786: END validate_date;
1787:
1878: p_message_name := 'IGS_TR_CANNOT_UPDATE_STEP';
1879: RETURN FALSE;
1880:
1881: WHEN OTHERS THEN
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);
1879: RETURN FALSE;
1880:
1881: WHEN OTHERS THEN
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');
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;
1891: END process_date;
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;
1891: END process_date;
1892:
2343: RETURN TRUE;
2344:
2345: EXCEPTION
2346: WHEN OTHERS THEN
2347: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2348: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_upd_trst'||'-'||SQLERRM);
2349: igs_ge_msg_stack.ADD;
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');
2344:
2345: EXCEPTION
2346: WHEN OTHERS THEN
2347: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2348: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_upd_trst'||'-'||SQLERRM);
2349: igs_ge_msg_stack.ADD;
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);
2347: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2348: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_upd_trst'||'-'||SQLERRM);
2349: igs_ge_msg_stack.ADD;
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');
2348: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_upd_trst'||'-'||SQLERRM);
2349: igs_ge_msg_stack.ADD;
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);
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);
2359: 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);
2359: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
2360: fnd_message.set_token('VALUE',lv_param_values);
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);
2359: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
2360: fnd_message.set_token('VALUE',lv_param_values);
2361: igs_ge_msg_stack.ADD;
2362: app_exception.raise_exception;
2363:
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);
2359: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
2360: fnd_message.set_token('VALUE',lv_param_values);
2361: igs_ge_msg_stack.ADD;
2362: app_exception.raise_exception;
2363:
2364: END trkp_upd_trst;
2495: END LOOP;
2496:
2497: EXCEPTION
2498: WHEN OTHERS THEN
2499: fnd_message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2500: fnd_message.set_token('NAME','IGS_TR_GEN_002.sync_trk_type_grplmt'||'-'||SQLERRM);
2501: IGS_GE_MSG_STACK.ADD;
2502: App_Exception.Raise_Exception;
2503:
2496:
2497: EXCEPTION
2498: WHEN OTHERS THEN
2499: fnd_message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2500: fnd_message.set_token('NAME','IGS_TR_GEN_002.sync_trk_type_grplmt'||'-'||SQLERRM);
2501: IGS_GE_MSG_STACK.ADD;
2502: App_Exception.Raise_Exception;
2503:
2504: END sync_trk_type_grplmt;
2707: END LOOP;
2708:
2709: EXCEPTION
2710: WHEN OTHERS THEN
2711: fnd_message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2712: fnd_message.set_token('NAME','IGS_TR_GEN_002.sync_trk_item_grplmt'||'-'||SQLERRM);
2713: IGS_GE_MSG_STACK.ADD;
2714: App_Exception.Raise_Exception;
2715:
2708:
2709: EXCEPTION
2710: WHEN OTHERS THEN
2711: fnd_message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2712: fnd_message.set_token('NAME','IGS_TR_GEN_002.sync_trk_item_grplmt'||'-'||SQLERRM);
2713: IGS_GE_MSG_STACK.ADD;
2714: App_Exception.Raise_Exception;
2715:
2716: END sync_trk_item_grplmt;
2851: RETURN (TRUE);
2852:
2853: EXCEPTION
2854: WHEN OTHERS THEN
2855: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2856: fnd_message.set_token('NAME','IGS_TR_GEN_002.validate_completion_status'||'-'||SQLERRM);
2857: igs_ge_msg_stack.ADD;
2858: app_exception.raise_exception;
2859:
2852:
2853: EXCEPTION
2854: WHEN OTHERS THEN
2855: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2856: fnd_message.set_token('NAME','IGS_TR_GEN_002.validate_completion_status'||'-'||SQLERRM);
2857: igs_ge_msg_stack.ADD;
2858: app_exception.raise_exception;
2859:
2860: END validate_completion_status;