DBA Data[Home] [Help]

APPS.IGS_PE_HZ_LOCATIONS_PKG dependencies on FND_MESSAGE

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

44: OPEN cur_old_ref_values;
45: FETCH cur_old_ref_values INTO old_references;
46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;

Line 165: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

161: IF ( get_pk_for_validation(
162: new_references.location_id
163: )
164: ) THEN
165: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
166: igs_ge_msg_stack.add;
167: app_exception.raise_exception;
168: END IF;
169: ELSIF (p_action = 'UPDATE') THEN

Line 178: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

174: IF ( get_pk_for_validation (
175: new_references.location_id
176: )
177: ) THEN
178: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
179: igs_ge_msg_stack.add;
180: app_exception.raise_exception;
181: END IF;
182: END IF;

Line 214: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

210:
211: Open cur_rowid;
212: Fetch cur_rowid INTO lv_rowid;
213: IF (cur_rowid%NOTFOUND) THEN
214: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
215: IGS_GE_MSG_STACK.ADD;
216: App_Exception.Raise_Exception;
217: END IF;
218: Close cur_rowid;

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

280: ELSE
281: x_program_update_date := SYSDATE;
282: END IF;
283: ELSE
284: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
285: igs_ge_msg_stack.add;
286: app_exception.raise_exception;
287: END IF;
288:

Line 358: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

354:
355: EXCEPTION
356: WHEN OTHERS THEN
357: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
358: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
359: fnd_message.set_token ('ERR_CD', SQLCODE);
360: igs_ge_msg_stack.add;
361: igs_sc_gen_001.unset_ctx('R');
362: app_exception.raise_exception;

Line 359: fnd_message.set_token ('ERR_CD', SQLCODE);

355: EXCEPTION
356: WHEN OTHERS THEN
357: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
358: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
359: fnd_message.set_token ('ERR_CD', SQLCODE);
360: igs_ge_msg_stack.add;
361: igs_sc_gen_001.unset_ctx('R');
362: app_exception.raise_exception;
363: ELSE

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

402:
403: OPEN c1;
404: FETCH c1 INTO tlinfo;
405: IF (c1%notfound) THEN
406: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
407: igs_ge_msg_stack.add;
408: CLOSE c1;
409: app_exception.raise_exception;
410: RETURN;

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

419: AND ((tlinfo.contact_person = x_contact_person) OR ((tlinfo.contact_person IS NULL) AND (X_contact_person IS NULL)))
420: ) THEN
421: NULL;
422: ELSE
423: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
424: igs_ge_msg_stack.add;
425: app_exception.raise_exception;
426: END IF;
427:

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

472: IF (x_last_update_login IS NULL) THEN
473: x_last_update_login := -1;
474: END IF;
475: ELSE
476: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
477: igs_ge_msg_stack.add;
478: app_exception.raise_exception;
479: END IF;
480:

Line 531: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

527: program_update_date = x_program_update_date
528: WHERE rowid = x_rowid;
529:
530: IF (SQL%NOTFOUND) THEN
531: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
532: igs_ge_msg_stack.add;
533: igs_sc_gen_001.unset_ctx('R');
534: app_exception.raise_exception;
535: END IF;

Line 545: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

541:
542: EXCEPTION
543: WHEN OTHERS THEN
544: IF (SQLCODE = (-28115)) THEN
545: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
546: fnd_message.set_token ('ERR_CD', SQLCODE);
547: igs_ge_msg_stack.add;
548: igs_sc_gen_001.unset_ctx('R');
549: app_exception.raise_exception;

Line 546: fnd_message.set_token ('ERR_CD', SQLCODE);

542: EXCEPTION
543: WHEN OTHERS THEN
544: IF (SQLCODE = (-28115)) THEN
545: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
546: fnd_message.set_token ('ERR_CD', SQLCODE);
547: igs_ge_msg_stack.add;
548: igs_sc_gen_001.unset_ctx('R');
549: app_exception.raise_exception;
550: ELSE

Line 643: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

639: DELETE FROM igs_pe_hz_locations
640: WHERE rowid = x_rowid;
641:
642: IF (SQL%NOTFOUND) THEN
643: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
644: igs_ge_msg_stack.add;
645: igs_sc_gen_001.unset_ctx('R');
646: app_exception.raise_exception;
647: END IF;