DBA Data[Home] [Help]

APPS.IGS_TR_GEN_002 dependencies on FND_MESSAGE

Line 87: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 88: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tsn'||'-'||SQLERRM);

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);

Line 91: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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:

Line 92: fnd_message.set_token('VALUE',lv_param_values);

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;

Line 132: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 133: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_ts'||'-'||SQLERRM);

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);

Line 136: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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:

Line 137: fnd_message.set_token('VALUE',lv_param_values);

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;

Line 175: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 176: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tgm'||'-'||SQLERRM);

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);

Line 179: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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:

Line 180: fnd_message.set_token('VALUE',lv_param_values);

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;

Line 227: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 228: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tin'||'-'||SQLERRM);

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);

Line 231: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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:

Line 232: fnd_message.set_token('VALUE',lv_param_values);

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;

Line 271: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 272: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_tri'||'-'||SQLERRM);

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);

Line 275: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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:

Line 276: fnd_message.set_token('VALUE',lv_param_values);

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;

Line 318: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 319: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_del_grp_lmt'||'-'||SQLERRM);

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);

Line 322: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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:

Line 323: fnd_message.set_token('VALUE',lv_param_values);

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 */

Line 356: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 357: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_del_tri'||'-'||SQLERRM);

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);

Line 360: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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:

Line 361: fnd_message.set_token('VALUE',lv_param_values);

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;

Line 627: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

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;

Line 629: fnd_message.set_name('IGS',l_message_name);

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');

Line 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');

Line 634: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_ins_ts_rec'||'-'||SQLERRM);

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);

Line 637: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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');

Line 638: fnd_message.set_token('VALUE',lv_param_values);

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);

Line 641: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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');

Line 642: fnd_message.set_token('VALUE',lv_param_values);

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);

Line 645: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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');

Line 646: fnd_message.set_token('VALUE',lv_param_values);

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);

Line 649: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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');

Line 650: fnd_message.set_token('VALUE',lv_param_values);

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);

Line 653: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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;

Line 654: fnd_message.set_token('VALUE',lv_param_values);

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;

Line 697: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 698: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_dup_note_rec'||'-'||SQLERRM);

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);

Line 701: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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:

Line 702: fnd_message.set_token('VALUE',lv_param_values);

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;

Line 732: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 733: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_ins_tsn_rec'||'-'||SQLERRM);

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);

Line 736: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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');

Line 737: fnd_message.set_token('VALUE',lv_param_values);

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);

Line 740: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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;

Line 741: fnd_message.set_token('VALUE',lv_param_values);

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:

Line 769: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 770: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkpl_ins_ts_grp_lmt'||'-'||SQLERRM);

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);

Line 773: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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:

Line 774: fnd_message.set_token('VALUE',lv_param_values);

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 */

Line 867: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED, l_app, l_message_name);

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;

Line 870: FND_MESSAGE.SET_NAME('IGS',l_message_name);

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');

Line 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;

Line 875: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_ins_dflt_trst'||'-'||SQLERRM);

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');

Line 878: lv_param_values:=fnd_message.get;

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;

Line 879: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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;

Line 880: fnd_message.set_token('VALUE',lv_param_values);

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;

Line 1091: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 1092: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_ins_trk_item'||'-'||SQLERRM);

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);

Line 1095: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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');

Line 1096: fnd_message.set_token('VALUE',lv_param_values);

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);

Line 1099: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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');

Line 1100: fnd_message.set_token('VALUE',lv_param_values);

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);

Line 1103: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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:

Line 1104: fnd_message.set_token('VALUE',lv_param_values);

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;

Line 1223: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 1224: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_next_step_cmplt'||'-'||SQLERRM);

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);

Line 1227: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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;

Line 1228: fnd_message.set_token('VALUE',lv_param_values);

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:

Line 1346: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 1347: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_next_grp_step_cmplt'||'-'||SQLERRM);

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);

Line 1350: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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;

Line 1351: fnd_message.set_token('VALUE',lv_param_values);

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:

Line 1421: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 1422: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_check_step_group_limit'||'-'||SQLERRM);

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);

Line 1425: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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:

Line 1426: fnd_message.set_token('VALUE',lv_param_values);

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;

Line 1508: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 1509: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_next_grp_step_cmplt'||'-'||SQLERRM);

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);

Line 1512: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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;

Line 1513: fnd_message.set_token('VALUE',lv_param_values);

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:

Line 1776: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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)

Line 1777: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_upd_trst.process_date.validate_date'||'-'||SQLERRM);

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);

Line 1782: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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;

Line 1783: fnd_message.set_token('VALUE',lv_param_values);

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:

Line 1882: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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);

Line 1883: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_upd_trst.process_date'||'-'||SQLERRM);

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');

Line 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;

Line 1888: fnd_message.set_token('VALUE',lv_param_values);

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:

Line 2347: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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');

Line 2348: fnd_message.set_token('NAME','IGS_TR_GEN_002.trkp_upd_trst'||'-'||SQLERRM);

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);

Line 2351: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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');

Line 2352: fnd_message.set_token('VALUE',lv_param_values);

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);

Line 2355: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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');

Line 2356: fnd_message.set_token('VALUE',lv_param_values);

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);

Line 2359: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

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:

Line 2360: fnd_message.set_token('VALUE',lv_param_values);

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;

Line 2499: fnd_message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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:

Line 2500: fnd_message.set_token('NAME','IGS_TR_GEN_002.sync_trk_type_grplmt'||'-'||SQLERRM);

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;

Line 2711: fnd_message.Set_Name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

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:

Line 2712: fnd_message.set_token('NAME','IGS_TR_GEN_002.sync_trk_item_grplmt'||'-'||SQLERRM);

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;

Line 2855: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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:

Line 2856: fnd_message.set_token('NAME','IGS_TR_GEN_002.validate_completion_status'||'-'||SQLERRM);

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;