DBA Data[Home] [Help]

APPS.IGS_AD_IMP_NEAR_MTCH_PKG dependencies on FND_MESSAGE

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

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

Line 116: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

112: -- The following code checks for check constraints on the Columns.
113: IF Upper(Column_Name) = 'ACTION' OR
114: Column_Name IS NULL THEN
115: IF NOT (new_references.action IN ('I','D')) THEN
116: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120: END IF;

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

141: NULL;
142: ELSIF NOT Igs_Ad_Interface_Pkg.Get_PK_For_Validation (
143: new_references.interface_id
144: ) THEN
145: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END IF;
149:

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

152: NULL;
153: ELSIF NOT Igs_Pe_Person_Id_Typ_Pkg.Get_PK_For_Validation (
154: new_references.person_id_type
155: ) THEN
156: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160:

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

163: NULL;
164: ELSIF NOT Igs_Co_Addr_Type_Pkg.Get_PK_For_Validation (
165: new_references.addr_type
166: ) THEN
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 178: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');

174: NULL;
175: ELSIF NOT Igs_Pe_Match_Sets_Pkg.Get_PK_For_Validation (
176: new_references.match_set_id
177: ) THEN
178: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182:

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

185: NULL;
186: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
187: new_references.person_id
188: ) THEN
189: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
190: IGS_GE_MSG_STACK.ADD;
191: App_Exception.Raise_Exception;
192: END IF;
193:

Line 260: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AINM_AINT_FK');

256: Open cur_rowid;
257: Fetch cur_rowid INTO lv_rowid;
258: IF (cur_rowid%FOUND) THEN
259: Close cur_rowid;
260: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AINM_AINT_FK');
261: IGS_GE_MSG_STACK.ADD;
262: App_Exception.Raise_Exception;
263: Return;
264: END IF;

Line 297: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AINM_ADT_FK');

293: Open cur_rowid;
294: Fetch cur_rowid INTO lv_rowid;
295: IF (cur_rowid%FOUND) THEN
296: Close cur_rowid;
297: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AINM_ADT_FK');
298: IGS_GE_MSG_STACK.ADD;
299: App_Exception.Raise_Exception;
300: Return;
301: END IF;

Line 334: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AINM_PMS_FK');

330: Open cur_rowid;
331: Fetch cur_rowid INTO lv_rowid;
332: IF (cur_rowid%FOUND) THEN
333: Close cur_rowid;
334: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AINM_PMS_FK');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: Return;
338: END IF;

Line 371: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AINM_PE_FK');

367: Open cur_rowid;
368: Fetch cur_rowid INTO lv_rowid;
369: IF (cur_rowid%FOUND) THEN
370: Close cur_rowid;
371: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AINM_PE_FK');
372: IGS_GE_MSG_STACK.ADD;
373: App_Exception.Raise_Exception;
374: Return;
375: END IF;

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

434:
435: IF (p_action = 'INSERT') THEN
436: -- Call all the procedures related to Before Insert.
437: IF Get_Pk_For_Validation(new_references.near_mtch_id) THEN
438: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
439: IGS_GE_MSG_STACK.ADD;
440: App_Exception.Raise_Exception;
441: END IF;
442: Check_Constraints;

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

452: ELSIF (p_action = 'VALIDATE_INSERT') THEN
453: -- Call all the procedures related to Before Insert.
454: IF Get_PK_For_Validation (
455: new_references.near_mtch_id) THEN
456: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
457: IGS_GE_MSG_STACK.ADD;
458: App_Exception.Raise_Exception;
459: END IF;
460: Check_Constraints;

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

561: else
562: X_PROGRAM_UPDATE_DATE := SYSDATE;
563: end if;
564: else
565: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
566: IGS_GE_MSG_STACK.ADD;
567: app_exception.raise_exception;
568: end if;
569:

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

688: begin
689: open c1;
690: fetch c1 into tlinfo;
691: if (c1%notfound) then
692: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
693: IGS_GE_MSG_STACK.ADD;
694: close c1;
695: app_exception.raise_exception;
696: return;

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

711: AND (tlinfo.INTERFACE_RELATIONS_ID = X_INTERFACE_RELATIONS_ID OR (tlinfo.INTERFACE_RELATIONS_ID IS NULL AND X_INTERFACE_RELATIONS_ID IS NULL ) )
712: ) then
713: NULL;
714: else
715: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
716: IGS_GE_MSG_STACK.ADD;
717: app_exception.raise_exception;
718: end if;
719: return;

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

765: if X_LAST_UPDATE_LOGIN is NULL then
766: X_LAST_UPDATE_LOGIN := -1;
767: end if;
768: else
769: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
770: IGS_GE_MSG_STACK.ADD;
771: app_exception.raise_exception;
772: end if;
773: