DBA Data[Home] [Help]

APPS.IGS_CA_DA_INST_PKG dependencies on IGS_GE_MSG_STACK

Line 49: IGS_GE_MSG_STACK.ADD;

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;
53: Close cur_old_ref_values;

Line 107: IGS_GE_MSG_STACK.ADD;

103: IF IGS_CA_VAL_DAI.calp_val_holiday_cat (new_references.cal_type,
104: v_message_name) = TRUE
105: THEN
106: Fnd_Message.Set_Name('IGS',v_message_name);
107: IGS_GE_MSG_STACK.ADD;
108: APP_EXCEPTION.RAISE_EXCEPTION;
109: END IF;
110: END IF;
111: END IF;

Line 149: IGS_GE_MSG_STACK.ADD;

145: NVL (new_references.ci_sequence_number, old_references.ci_sequence_number),
146: v_message_name) = FALSE
147: THEN
148: Fnd_Message.Set_Name('IGS',v_message_name);
149: IGS_GE_MSG_STACK.ADD;
150: APP_EXCEPTION.RAISE_EXCEPTION;
151: END IF;
152: IF p_inserting
153: THEN

Line 160: IGS_GE_MSG_STACK.ADD;

156: NVL (new_references.cal_type, old_references.cal_type),
157: v_message_name) = FALSE
158: THEN
159: Fnd_Message.Set_Name('IGS',v_message_name);
160: IGS_GE_MSG_STACK.ADD;
161: APP_EXCEPTION.RAISE_EXCEPTION;
162: END IF;
163: END IF;
164: END IF;

Line 184: IGS_GE_MSG_STACK.ADD;

180: end if;
181: if upper(column_name) = 'CAL_TYPE' or column_name is null Then
182: if new_references.cal_type <> UPPER( new_references.cal_type) then
183: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
184: IGS_GE_MSG_STACK.ADD;
185: App_Exception.Raise_Exception;
186: end if;
187: end if;
188: if upper(column_name) = 'DT_ALIAS' or column_name is null Then

Line 191: IGS_GE_MSG_STACK.ADD;

187: end if;
188: if upper(column_name) = 'DT_ALIAS' or column_name is null Then
189: if new_references.dt_alias <> UPPER( new_references.dt_alias) then
190: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
191: IGS_GE_MSG_STACK.ADD;
192: App_Exception.Raise_Exception;
193: end if;
194: end if;
195:

Line 213: IGS_GE_MSG_STACK.ADD;

209: new_references.cal_type,
210: new_references.ci_sequence_number
211: ) THEN
212: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
213: IGS_GE_MSG_STACK.ADD;
214: App_Exception.Raise_Exception;
215: END IF;
216: END IF;
217: IF (((old_references.dt_alias = new_references.dt_alias)) OR

Line 225: IGS_GE_MSG_STACK.ADD;

221: IF NOT IGS_CA_DA_PKG.Get_PK_For_Validation (
222: new_references.dt_alias
223: ) THEN
224: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228: END IF;
229:

Line 384: IGS_GE_MSG_STACK.ADD;

380: Fetch cur_rowid INTO lv_rowid;
381: IF (cur_rowid%FOUND) THEN
382: Close cur_rowid;
383: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DAI_CI_FK');
384: IGS_GE_MSG_STACK.ADD;
385: App_Exception.Raise_Exception;
386: Return;
387: END IF;
388: Close cur_rowid;

Line 410: IGS_GE_MSG_STACK.ADD;

406: Fetch cur_rowid INTO lv_rowid;
407: IF (cur_rowid%FOUND) THEN
408: Close cur_rowid;
409: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DAI_DA_FK');
410: IGS_GE_MSG_STACK.ADD;
411: App_Exception.Raise_Exception;
412: Return;
413: END IF;
414: Close cur_rowid;

Line 473: IGS_GE_MSG_STACK.ADD;

469: new_references.sequence_number ,
470: new_references.cal_type ,
471: new_references.ci_sequence_number ) THEN
472: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
473: IGS_GE_MSG_STACK.ADD;
474: App_Exception.Raise_Exception;
475: END IF;
476: CHECK_CONSTRAINTS;
477: Check_Parent_Existance;

Line 485: IGS_GE_MSG_STACK.ADD;

481: new_references.sequence_number ,
482: new_references.cal_type ,
483: new_references.ci_sequence_number ) THEN
484: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
485: IGS_GE_MSG_STACK.ADD;
486: App_Exception.Raise_Exception;
487: END IF;
488: CHECK_CONSTRAINTS;
489: ELSIF (p_action = 'UPDATE') THEN

Line 584: IGS_GE_MSG_STACK.ADD;

580: X_LAST_UPDATE_LOGIN := -1;
581: end if;
582: else
583: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
584: IGS_GE_MSG_STACK.ADD;
585: app_exception.raise_exception;
586: end if;
587: Before_DML (
588: p_action =>'INSERT',

Line 659: IGS_GE_MSG_STACK.ADD;

655: fetch c1 into tlinfo;
656: if (c1%notfound) then
657: close c1;
658: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
659: IGS_GE_MSG_STACK.ADD;
660: app_exception.raise_exception;
661: return;
662: end if;
663: close c1;

Line 672: IGS_GE_MSG_STACK.ADD;

668: ) then
669: null;
670: else
671: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
672: IGS_GE_MSG_STACK.ADD;
673: app_exception.raise_exception;
674: end if;
675: return;
676: end LOCK_ROW;

Line 706: IGS_GE_MSG_STACK.ADD;

702: X_LAST_UPDATE_LOGIN := -1;
703: end if;
704: else
705: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
706: IGS_GE_MSG_STACK.ADD;
707: app_exception.raise_exception;
708: end if;
709: Before_DML (
710: p_action =>'UPDATE',