DBA Data[Home] [Help]

APPS.IGS_PE_PERSID_GROUP_PKG dependencies on FND_MESSAGE

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

137: Fetch cur_old_ref_values INTO old_references;
138:
139: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
140:
141: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
142:
143: IGS_GE_MSG_STACK.ADD;
144:
145: Close cur_old_ref_values;

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

241:
242: IF upper(column_name) = 'GROUP_CD' OR
243: column_name is null Then
244: IF new_references.group_cd <>UPPER(new_references.group_cd)Then
245: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
246: IGS_GE_MSG_STACK.ADD;
247: App_Exception.Raise_Exception;
248: END IF;
249: END IF;

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

250:
251: IF upper(column_name) = 'CLOSED_IND' OR
252: column_name is null Then
253: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
254: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
255: IGS_GE_MSG_STACK.ADD;
256: App_Exception.Raise_Exception;
257: END IF;
258: END IF;

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

258: END IF;
259: IF upper(column_name) = 'GROUP_ID' OR
260: column_name is null Then
261: IF new_references.group_id < 1 OR new_references.group_id > 999999 Then
262: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
263: IGS_GE_MSG_STACK.ADD;
264: App_Exception.Raise_Exception;
265: END IF;
266: END IF;

Line 285: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

281: BEGIN
282: IF get_uk_for_validation (
283: new_references.group_cd
284: ) THEN
285: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
286: IGS_GE_MSG_STACK.ADD;
287: app_exception.raise_exception;
288: END IF;
289: END Check_Uniqueness ;

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

303:
304: ELSE
305: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
306: new_references.creator_person_id) THEN
307: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
308: IGS_GE_MSG_STACK.ADD;
309: App_Exception.Raise_Exception;
310: END IF;
311: END IF;

Line 453: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PIG_PE_FK');

449: Fetch cur_rowid INTO lv_rowid;
450:
451: IF (cur_rowid%FOUND) THEN
452:
453: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PIG_PE_FK');
454:
455: IGS_GE_MSG_STACK.ADD;
456:
457: Close cur_rowid;

Line 597: Fnd_Message.Set_Name ('IGS', 'IGS_PE_CRT_PRSN_DECEASED');

593:
594: IF (p_action in ('INSERT','UPDATE')) THEN
595: OPEN is_creator_deceased; FETCH is_creator_deceased INTO l_deceased_ind; CLOSE is_creator_deceased;
596: IF(NVL(l_deceased_ind,'N')='Y')THEN
597: Fnd_Message.Set_Name ('IGS', 'IGS_PE_CRT_PRSN_DECEASED');
598: IGS_GE_MSG_STACK.ADD;
599: App_Exception.Raise_Exception;
600: END IF;
601: OPEN is_creator_too_young; FETCH is_creator_too_young INTO l_date_of_birth; CLOSE is_creator_too_young;

Line 603: Fnd_Message.Set_Name ('IGS', 'IGS_PE_DOB_LT_CRT_DT');

599: App_Exception.Raise_Exception;
600: END IF;
601: OPEN is_creator_too_young; FETCH is_creator_too_young INTO l_date_of_birth; CLOSE is_creator_too_young;
602: IF(l_date_of_birth IS NOT NULL AND l_date_of_birth > x_create_dt ) THEN
603: Fnd_Message.Set_Name ('IGS', 'IGS_PE_DOB_LT_CRT_DT');
604: IGS_GE_MSG_STACK.ADD;
605: App_Exception.Raise_Exception;
606: END IF;
607: END IF;

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

608: IF (p_action = 'INSERT') THEN
609: -- Call all the procedures related to Before Insert.
610: IF Get_PK_For_Validation (
611: new_references.group_id ) THEN
612: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
613: IGS_GE_MSG_STACK.ADD;
614: App_Exception.Raise_Exception;
615: END IF;
616: check_uniqueness;

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

623: Check_Parent_Existance; -- if procedure present
624: ELSIF (p_action = 'VALIDATE_INSERT') THEN
625: IF Get_PK_For_Validation (
626: new_references.group_id ) THEN
627: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
628: IGS_GE_MSG_STACK.ADD;
629: App_Exception.Raise_Exception;
630: END IF;
631: Check_Constraints; -- if procedure present

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

757: X_PROGRAM_UPDATE_DATE := SYSDATE;
758:
759: end if;
760: else
761: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
762: IGS_GE_MSG_STACK.ADD;
763: app_exception.raise_exception;
764: end if;
765:

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

997: begin
998: open c1;
999: fetch c1 into tlinfo;
1000: if (c1%notfound) then
1001: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1002:
1003: close c1;
1004: App_Exception.Raise_Exception;
1005: return;

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

1039:
1040: ) then
1041: null;
1042: else
1043: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1044: app_exception.raise_exception;
1045: end if;
1046: return;
1047: end LOCK_ROW;

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

1105: if X_LAST_UPDATE_LOGIN is NULL then
1106: X_LAST_UPDATE_LOGIN := -1;
1107: end if;
1108: else
1109: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1110: IGS_GE_MSG_STACK.ADD;
1111: app_exception.raise_exception;
1112: end if;
1113: