DBA Data[Home] [Help]

APPS.IGS_PS_OCCUP_TITLES_PKG dependencies on FND_MESSAGE

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

46: Open cur_old_ref_values;
47: Fetch cur_old_ref_values INTO old_references;
48: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
49: Close cur_old_ref_values;
50: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
51: IGS_GE_MSG_STACK.ADD;
52: App_Exception.Raise_Exception;
53: Return;
54: END IF;

Line 123: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

119: IF Get_Uk_For_Validation (
120: new_references.occupational_title_code
121: ,new_references.program_code
122: ) THEN
123: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
124: IGS_GE_MSG_STACK.ADD;
125: app_exception.raise_exception;
126: END IF;
127: END Check_Uniqueness ;

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

154: NULL;
155: ELSIF NOT Igs_Ps_Dic_Occ_Titls_Pkg.Get_PK_For_Validation (
156: new_references.occupational_title_code
157: ) 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:

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

163: Open cur_rowid;
164: Fetch cur_rowid INTO lv_rowid;
165: IF (cur_rowid%NOTFOUND) THEN
166: Close cur_rowid;
167: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171:

Line 278: Fnd_Message.Set_Name ('IGS', 'IGS_PS_OCT_DOT_FK');

274: Open cur_rowid;
275: Fetch cur_rowid INTO lv_rowid;
276: IF (cur_rowid%FOUND) THEN
277: Close cur_rowid;
278: Fnd_Message.Set_Name ('IGS', 'IGS_PS_OCT_DOT_FK');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: Return;
282: END IF;

Line 315: Fnd_Message.Set_Name ('IGS', 'IGS_PS_OCT_CRV_FK');

311: Open cur_rowid;
312: Fetch cur_rowid INTO lv_rowid;
313: IF (cur_rowid%FOUND) THEN
314: Close cur_rowid;
315: Fnd_Message.Set_Name ('IGS', 'IGS_PS_OCT_CRV_FK');
316: IGS_GE_MSG_STACK.ADD;
317: App_Exception.Raise_Exception;
318: Return;
319: END IF;

Line 373: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

369: -- Call all the procedures related to Before Insert.
370: Null;
371: IF Get_Pk_For_Validation(
372: new_references.program_occupational_title_id) THEN
373: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
374: IGS_GE_MSG_STACK.ADD;
375: App_Exception.Raise_Exception;
376: END IF;
377: Check_Uniqueness;

Line 393: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

389: ELSIF (p_action = 'VALIDATE_INSERT') THEN
390: -- Call all the procedures related to Before Insert.
391: IF Get_PK_For_Validation (
392: new_references.program_occupational_title_id) THEN
393: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
394: IGS_GE_MSG_STACK.ADD;
395: App_Exception.Raise_Exception;
396: END IF;
397: Check_Uniqueness;

Line 486: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

482: if X_LAST_UPDATE_LOGIN is NULL then
483: X_LAST_UPDATE_LOGIN := -1;
484: end if;
485: else
486: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
487: IGS_GE_MSG_STACK.ADD;
488: app_exception.raise_exception;
489: end if;
490:

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

562: begin
563: open c1;
564: fetch c1 into tlinfo;
565: if (c1%notfound) then
566: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
567: IGS_GE_MSG_STACK.ADD;
568: close c1;
569: app_exception.raise_exception;
570: return;

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

574: AND (tlinfo.OCCUPATIONAL_TITLE_CODE = X_OCCUPATIONAL_TITLE_CODE)
575: ) then
576: null;
577: else
578: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
579: IGS_GE_MSG_STACK.ADD;
580: app_exception.raise_exception;
581: end if;
582: return;

Line 620: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

616: if X_LAST_UPDATE_LOGIN is NULL then
617: X_LAST_UPDATE_LOGIN := -1;
618: end if;
619: else
620: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
621: IGS_GE_MSG_STACK.ADD;
622: app_exception.raise_exception;
623: end if;
624: Before_DML(