DBA Data[Home] [Help]

APPS.IGS_TR_TYPE_STEP_PKG dependencies on FND_MESSAGE

Line 43: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

39: -- Populate Old Values.
40: OPEN cur_old_ref_values;
41: FETCH cur_old_ref_values INTO old_references;
42: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
43: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
44: igs_ge_msg_stack.add;
45: app_exception.raise_exception;
46: CLOSE cur_old_ref_values;
47: RETURN;

Line 88: Fnd_Message.Set_Name('IGS', v_message_name);

84:
85: IF (p_inserting OR (p_updating AND (old_references.tracking_type <> new_references.tracking_type))) THEN
86: IF NOT IGS_TR_VAL_TRI.TRKP_VAL_TRI_TYPE (new_references.tracking_type,
87: v_message_name) THEN
88: Fnd_Message.Set_Name('IGS', v_message_name);
89: IGS_GE_MSG_STACK.ADD;
90: App_Exception.Raise_Exception;
91: END IF;
92: END IF;

Line 97: Fnd_Message.Set_Name('IGS', v_message_name);

93:
94: IF (p_inserting OR (p_updating AND (old_references.step_catalog_cd <> new_references.step_catalog_cd))) THEN
95: IF NOT IGS_TR_VAL_TRI.val_tr_step_ctlg (new_references.step_catalog_cd,
96: v_message_name) THEN
97: Fnd_Message.Set_Name('IGS', v_message_name);
98: IGS_GE_MSG_STACK.ADD;
99: App_Exception.Raise_Exception;
100: END IF;
101: END IF;

Line 126: fnd_message.set_name('IGS',v_message_name);

122: new_references.s_tracking_step_type,
123: new_references.tracking_type,
124: v_message_name) = FALSE THEN
125:
126: fnd_message.set_name('IGS',v_message_name);
127: igs_ge_msg_stack.add;
128: app_exception.raise_exception;
129: END IF;
130: END IF;

Line 147: fnd_message.set_name('FND','FORM_RECORD_DELETED');

143:
144: IF NOT igs_pe_person_pkg.get_pk_for_validation (
145: new_references.recipient_id
146: )THEN
147: fnd_message.set_name('FND','FORM_RECORD_DELETED');
148: igs_ge_msg_stack.add;
149: app_exception.raise_exception;
150: END IF;
151: END IF;

Line 158: fnd_message.set_name('FND','FORM_RECORD_DELETED');

154: ((new_references.s_tracking_step_type IS NULL))) THEN
155: NULL;
156: ELSE
157: IF NOT igs_lookups_view_pkg.get_pk_for_validation('TRACKING_STEP_TYPE',new_references.s_tracking_step_type)THEN
158: fnd_message.set_name('FND','FORM_RECORD_DELETED');
159: igs_ge_msg_stack.add;
160: app_exception.raise_exception;
161: END IF;
162: END IF;

Line 171: fnd_message.set_name('FND','FORM_RECORD_DELETED');

167: ELSE
168: IF NOT igs_tr_type_pkg.get_pk_for_validation (
169: new_references.tracking_type
170: )THEN
171: fnd_message.set_name('FND','FORM_RECORD_DELETED');
172: igs_ge_msg_stack.add;
173: app_exception.raise_exception;
174: END IF;
175: END IF;

Line 184: fnd_message.set_name('FND','FORM_RECORD_DELETED');

180: ELSE
181: IF NOT igs_tr_step_ctlg_pkg.get_uk_for_validation (
182: new_references.step_catalog_cd
183: )THEN
184: fnd_message.set_name('FND','FORM_RECORD_DELETED');
185: igs_ge_msg_stack.add;
186: app_exception.raise_exception;
187: END IF;
188: END IF;

Line 247: fnd_message.set_name ('IGS', 'IGS_TR_TTS_PE_FK');

243: OPEN cur_rowid;
244: FETCH cur_rowid INTO lv_rowid;
245: IF (cur_rowid%FOUND) THEN
246: CLOSE cur_rowid;
247: fnd_message.set_name ('IGS', 'IGS_TR_TTS_PE_FK');
248: igs_ge_msg_stack.add;
249: app_exception.raise_exception;
250: RETURN;
251: END IF;

Line 273: fnd_message.set_name ('IGS', 'IGS_TR_TTS_STST_FK');

269: OPEN cur_rowid;
270: FETCH cur_rowid INTO lv_rowid;
271: IF (cur_rowid%FOUND) THEN
272: CLOSE cur_rowid;
273: fnd_message.set_name ('IGS', 'IGS_TR_TTS_STST_FK');
274: igs_ge_msg_stack.add;
275: app_exception.raise_exception;
276: RETURN;
277: END IF;

Line 304: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

300: END IF;
301:
302: IF UPPER(column_name) = 'TRACKING_TYPE_STEP_NUMBER' OR column_name IS NULL THEN
303: IF (new_references.tracking_type_step_number < 1 OR new_references.tracking_type_step_number > 99 )THEN
304: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
305: igs_ge_msg_stack.add;
306: app_exception.raise_exception;
307: END IF;
308: END IF;

Line 313: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

309:
310: --kumma, 2702342, increased the constant value from 999 to 9999
311: IF UPPER(column_name) = 'ACTION_DAYS' OR column_name IS NULL THEN
312: IF (new_references.action_days < 0 OR new_references.action_days > 9999 )THEN
313: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
314: igs_ge_msg_stack.add;
315: app_exception.raise_exception;
316: END IF;
317: END IF;

Line 321: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

317: END IF;
318:
319: IF UPPER(column_name) = 'S_TRACKING_STEP_TYPE' OR column_name IS NULL THEN
320: IF new_references.s_tracking_step_type <> UPPER(new_references.s_tracking_step_type) THEN
321: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325: END IF;

Line 329: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

325: END IF;
326:
327: IF UPPER(column_name) = 'TRACKING_TYPE' OR column_name IS NULL THEN
328: IF new_references.tracking_type <> UPPER(new_references.tracking_type) THEN
329: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
330: igs_ge_msg_stack.add;
331: app_exception.raise_exception;
332: END IF;
333: END IF;

Line 337: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

333: END IF;
334:
335: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN
336: IF new_references.publish_ind <> UPPER(new_references.publish_ind) THEN
337: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
338: igs_ge_msg_stack.add;
339: app_exception.raise_exception;
340: END IF;
341: END IF;

Line 345: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');

341: END IF;
342:
343: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN
344: IF new_references.publish_ind NOT IN ('Y','N') THEN
345: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
346: igs_ge_msg_stack.add;
347: app_exception.raise_exception;
348: END IF;
349: END IF;

Line 405: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

401: IF get_pk_for_validation(
402: new_references.tracking_type,
403: new_references.tracking_type_step_id
404: )THEN
405: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
406: igs_ge_msg_stack.add;
407: app_exception.raise_exception;
408: END IF;
409: check_constraints;

Line 430: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

426: IF get_pk_for_validation(
427: new_references.tracking_type,
428: new_references.tracking_type_step_id
429: )THEN
430: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
431: igs_ge_msg_stack.add;
432: app_exception.raise_exception;
433: END IF;
434: check_constraints;

Line 502: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

498: x_last_update_login := -1;
499: END IF;
500:
501: ELSE
502: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
503: igs_ge_msg_stack.add;
504: app_exception.raise_exception;
505: END IF;
506:

Line 606: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

602:
603: OPEN c1;
604: FETCH c1 INTO tlinfo;
605: IF (c1%NOTFOUND) THEN
606: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
607: igs_ge_msg_stack.add;
608: app_exception.raise_exception;
609: CLOSE c1;
610: RETURN;

Line 635: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

631: AND (x_step_catalog_cd IS NULL)))
632: ) THEN
633: NULL;
634: ELSE
635: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
636: igs_ge_msg_stack.add;
637: app_exception.raise_exception;
638: END IF;
639: RETURN;

Line 682: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');

678: IF x_last_update_login IS NULL THEN
679: x_last_update_login := -1;
680: END IF;
681: ELSE
682: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
683: igs_ge_msg_stack.add;
684: app_exception.raise_exception;
685: END IF;
686: