DBA Data[Home] [Help]

APPS.IGS_RU_ITEM_PKG dependencies on FND_MESSAGE

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

36: -- Populate Old Values.
37: Open cur_old_ref_values;
38: Fetch cur_old_ref_values INTO old_references;
39: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
40: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
41: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_ITEM : P_ACTION INSERT VALIDATE_INSERT : IGSUI07B.PLS');
42: IGS_GE_MSG_STACK.ADD;
43: App_Exception.Raise_Exception;
44: Close cur_old_ref_values;

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

87: END IF ;
88:
89: IF upper(Column_name) = 'RUL_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
90: IF new_references.RUL_SEQUENCE_NUMBER < 0 or new_references.RUL_SEQUENCE_NUMBER > 999999 then
91: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
92: IGS_GE_MSG_STACK.ADD;
93: App_Exception.Raise_Exception ;
94: END IF;
95:

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

96: END IF ;
97:
98: IF upper(Column_name) = 'SET_NUMBER' OR COLUMN_NAME IS NULL THEN
99: IF new_references.SET_NUMBER < 0 or new_references.SET_NUMBER > 999999 then
100: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
101: IGS_GE_MSG_STACK.ADD;
102: App_Exception.Raise_Exception ;
103: END IF;
104:

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

105: END IF ;
106:
107: IF upper(Column_name) = 'ITEM' OR COLUMN_NAME IS NULL THEN
108: IF new_references.ITEM < 0 or new_references.ITEM > 999999 then
109: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception ;
112: END IF;
113:

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

123: ELSE
124: IF NOT IGS_RU_NAMED_RULE_PKG.Get_PK_For_Validation (
125: new_references.named_rule
126: ) THEN
127: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
128: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_NAMED_RULE : P_ACTION Check_Parent_Existance named_rule : IGSUI07B.PLS');
129: IGS_GE_MSG_STACK.ADD;
130: App_Exception.Raise_Exception;
131: END IF;

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

137: ELSE
138: IF NOT IGS_RU_RULE_PKG.Get_PK_For_Validation (
139: new_references.rul_sequence_number
140: ) THEN
141: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
142: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_RULE : P_ACTION Check_Parent_Existance rul_sequence_number : IGSUI07B.PLS');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;

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

151: ELSE
152: IF NOT IGS_RU_RULE_PKG.Get_PK_For_Validation (
153: new_references.rule_number
154: ) THEN
155: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
156: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_RULE : P_ACTION Check_Parent_Existance rule_number : IGSUI07B.PLS');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;

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

165: ELSE
166: IF NOT IGS_RU_SET_PKG.Get_PK_For_Validation (
167: new_references.set_number
168: ) THEN
169: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
170: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_SET : P_ACTION Check_Parent_Existance set_number : IGSUI07B.PLS');
171: IGS_GE_MSG_STACK.ADD;
172: App_Exception.Raise_Exception;
173: END IF;

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

179: ELSE
180: IF NOT IGS_RU_CALL_PKG.Get_UK1_For_Validation (
181: new_references.derived_rule
182: ) THEN
183: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
184: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_CALL : P_ACTION Check_Parent_Existance derived_rule : IGSUI07B.PLS');
185: IGS_GE_MSG_STACK.ADD;
186: App_Exception.Raise_Exception;
187: END IF;

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

193: ELSE
194: IF NOT IGS_RU_TURIN_FNC_PKG.Get_PK_For_Validation (
195: new_references.turin_function
196: ) THEN
197: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
198: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_TURIN_FNC : P_ACTION Check_Parent_Existance turin_function : IGSUI07B.PLS');
199: IGS_GE_MSG_STACK.ADD;
200: App_Exception.Raise_Exception;
201: END IF;

Line 250: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUI_NR_FK');

246: Open cur_rowid;
247: Fetch cur_rowid INTO lv_rowid;
248: IF (cur_rowid%FOUND) THEN
249: Close cur_rowid;
250: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUI_NR_FK');
251: IGS_GE_MSG_STACK.ADD;
252: App_Exception.Raise_Exception;
253: Return;
254: END IF;

Line 277: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUI_RUL_FK');

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

Line 303: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUI_RUL_FK');

299: Open cur_rowid;
300: Fetch cur_rowid INTO lv_rowid;
301: IF (cur_rowid%FOUND) THEN
302: Close cur_rowid;
303: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUI_RUL_FK');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: Return;
307: END IF;

Line 329: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUI_SRC_FK');

325: Open cur_rowid;
326: Fetch cur_rowid INTO lv_rowid;
327: IF (cur_rowid%FOUND) THEN
328: Close cur_rowid;
329: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUI_SRC_FK');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: Return;
333: END IF;

Line 355: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUI_STF_FK');

351: Open cur_rowid;
352: Fetch cur_rowid INTO lv_rowid;
353: IF (cur_rowid%FOUND) THEN
354: Close cur_rowid;
355: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RUI_STF_FK');
356: IGS_GE_MSG_STACK.ADD;
357: App_Exception.Raise_Exception;
358: Return;
359: END IF;

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

403: IF Get_PK_For_Validation (
404: new_references.rul_sequence_number,
405: new_references.item
406: ) THEN
407: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
408: IGS_GE_MSG_STACK.ADD;
409: App_Exception.Raise_Exception;
410: END IF;
411: Check_Constraints;

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

418: IF Get_PK_For_Validation (
419: new_references.rul_sequence_number,
420: new_references.item
421: ) THEN
422: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
423: IGS_GE_MSG_STACK.ADD;
424: App_Exception.Raise_Exception;
425: END IF;
426: Check_Constraints;

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

471: if X_LAST_UPDATE_LOGIN is NULL then
472: X_LAST_UPDATE_LOGIN := -1;
473: end if;
474: else
475: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
476: IGS_GE_MSG_STACK.ADD;
477: app_exception.raise_exception;
478: end if;
479:

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

564: begin
565: open c1;
566: fetch c1 into tlinfo;
567: if (c1%notfound) then
568: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
569: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_ITEM : P_ACTION LOCK_ROW : IGSUI07B.PLS');
570: IGS_GE_MSG_STACK.ADD;
571: app_exception.raise_exception;
572: close c1;

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

594: AND (X_DERIVED_RULE is null)))
595: ) then
596: null;
597: else
598: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
599: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_ITEM : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI07B.PLS');
600: IGS_GE_MSG_STACK.ADD;
601: app_exception.raise_exception;
602: end if;

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

632: if X_LAST_UPDATE_LOGIN is NULL then
633: X_LAST_UPDATE_LOGIN := -1;
634: end if;
635: else
636: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
637: IGS_GE_MSG_STACK.ADD;
638: app_exception.raise_exception;
639: end if;
640: