DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_VER_HIST_PKG dependencies on FND_MESSAGE

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

118: Open cur_old_ref_values;
119: Fetch cur_old_ref_values INTO old_references;
120: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
121: Close cur_old_ref_values;
122: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: Return;
126: END IF;

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

283: END IF;
284:
285: IF Upper(Column_Name)='ABBREVIATION' OR Column_Name IS NULL Then
286: IF New_References.abbreviation <> UPPER(New_References.abbreviation) Then
287: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
288: IGS_GE_MSG_STACK.ADD;
289: App_Exception.Raise_Exception;
290: END IF;
291: END IF;

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

291: END IF;
292:
293: IF Upper(Column_Name)='ASSESSABLE_IND' OR Column_Name IS NULL Then
294: IF New_References.Assessable_Ind NOT IN ( 'Y' , 'N' ) Then
295: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
296: IGS_GE_MSG_STACK.ADD;
297: App_Exception.Raise_Exception;
298: END IF;
299: END IF;

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

299: END IF;
300:
301: IF Upper(Column_Name)='AWARD_COURSE_ONLY_IND' OR Column_Name IS NULL Then
302: IF New_References.Award_Course_Only_Ind NOT IN ( 'Y' , 'N' ) Then
303: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: END IF;
307: END IF;

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

307: END IF;
308:
309: IF Upper(Column_Name)='CREDIT_POINT_DESCRIPTOR' OR Column_Name IS NULL Then
310: IF New_References.Credit_Point_Descriptor <> UPPER(New_References.Credit_Point_Descriptor) Then
311: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
312: IGS_GE_MSG_STACK.ADD;
313: App_Exception.Raise_Exception;
314: END IF;
315: END IF;

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

315: END IF;
316:
317: IF Upper(Column_Name)='INDUSTRIAL_IND' OR Column_Name IS NULL Then
318: IF New_References.Industrial_Ind NOT IN ( 'Y' , 'N' ) Then
319: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
320: IGS_GE_MSG_STACK.ADD;
321: App_Exception.Raise_Exception;
322: END IF;
323:

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

325:
326: IF Upper(Column_Name)='POINTS_OVERRIDE_IND' OR Column_Name IS NULL Then
327:
328: IF New_References.Points_Override_Ind NOT IN ( 'Y' , 'N' ) Then
329: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: END IF;
333:

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

335: END IF;
336:
337: IF Upper(Column_Name)='PRACTICAL_IND' OR Column_Name IS NULL Then
338: IF New_References.Practical_Ind <> UPPER(New_References.Practical_Ind) Then
339: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
340: IGS_GE_MSG_STACK.ADD;
341: App_Exception.Raise_Exception;
342: END IF;
343: END IF;

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

344:
345: IF Upper(Column_Name)='REPEATABLE_IND' OR Column_Name IS NULL Then
346:
347: IF New_References.Repeatable_Ind NOT IN ( 'Y' , 'N','X' ) Then
348: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
349: IGS_GE_MSG_STACK.ADD;
350: App_Exception.Raise_Exception;
351: END IF;
352:

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

355:
356: IF Upper(Column_Name)='RESEARCH_UNIT_IND' OR Column_Name IS NULL Then
357:
358: IF New_References.Research_Unit_Ind NOT IN ( 'Y' , 'N' ) Then
359: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
360: IGS_GE_MSG_STACK.ADD;
361: App_Exception.Raise_Exception;
362: END IF;
363:

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

367:
368: IF Upper(Column_Name)='SUPP_EXAM_PERMITTED_IND' OR Column_Name IS NULL Then
369:
370: IF New_References.Supp_Exam_Permitted_Ind NOT IN ( 'Y' , 'N' ) Then
371: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
372: IGS_GE_MSG_STACK.ADD;
373: App_Exception.Raise_Exception;
374: END IF;
375:

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

379:
380: IF Upper(Column_Name)='TITLE_OVERRIDE_IND' OR Column_Name IS NULL Then
381:
382: IF New_References.Title_Override_Ind NOT IN ( 'Y' , 'N' ) Then
383: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
384: IGS_GE_MSG_STACK.ADD;
385: App_Exception.Raise_Exception;
386: END IF;
387:

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

389: END IF;
390:
391: IF Upper(Column_Name)='AUDITABLE_IND' OR Column_Name IS NULL Then
392: IF New_References.auditable_Ind NOT IN ( 'Y' , 'N' ) Then
393: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
394: IGS_GE_MSG_STACK.ADD;
395: App_Exception.Raise_Exception;
396: END IF;
397: END IF;

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

397: END IF;
398:
399: IF Upper(Column_Name)='AUDIT_PERMISSION_IND' OR Column_Name IS NULL Then
400: IF New_References.audit_permission_Ind NOT IN ( 'Y' , 'N' ) Then
401: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
402: IGS_GE_MSG_STACK.ADD;
403: App_Exception.Raise_Exception;
404: END IF;
405: END IF;

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

405: END IF;
406:
407: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then
408: IF New_References.Unit_Cd <> UPPER(New_References.Unit_CD) Then
409: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
410: IGS_GE_MSG_STACK.ADD;
411: App_Exception.Raise_Exception;
412: END IF;
413: END IF;

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

413: END IF;
414:
415: IF Upper(Column_Name)='UNIT_INT_COURSE_LEVEL_CD' OR Column_Name IS NULL Then
416: IF New_References.Unit_Int_Course_Level_Cd <> UPPER(New_References.Unit_Int_Course_Level_Cd) Then
417: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
418: IGS_GE_MSG_STACK.ADD;
419: App_Exception.Raise_Exception;
420: END IF;
421: END IF;

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

421: END IF;
422:
423: IF Upper(Column_Name)='UNIT_LEVEL' OR Column_Name IS NULL Then
424: IF New_References.Unit_Level <> UPPER(New_References.Unit_Level) Then
425: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
426: IGS_GE_MSG_STACK.ADD;
427: App_Exception.Raise_Exception;
428: END IF;
429: END IF;

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

429: END IF;
430:
431: IF Upper(Column_Name)='UNIT_STATUS' OR Column_Name IS NULL Then
432: IF New_References.Unit_Status <> UPPER(New_References.Unit_Status) Then
433: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
434: IGS_GE_MSG_STACK.ADD;
435: App_Exception.Raise_Exception;
436: END IF;
437: END IF;

Line 442: Fnd_Message.Set_Name('IGS', 'IGS_PS_ONE_UNIT_ENR_MTHD');

438:
439: -- check that atleast one enrollemnt method is selected
440: IF (Upper(Column_name)='SS_ENROL_IND' OR Upper(Column_name)='IVR_ENROL_IND') OR Column_name IS NULL THEN
441: IF NOT (New_References.ss_enrol_ind = 'Y' OR New_references.ivr_enrol_ind = 'Y') THEN
442: Fnd_Message.Set_Name('IGS', 'IGS_PS_ONE_UNIT_ENR_MTHD');
443: IGS_GE_MSG_STACK.ADD;
444: App_Exception.Raise_Exception;
445: END IF;
446: END IF;

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

446: END IF;
447:
448: IF Upper(Column_Name)='BILLING_HRS' OR Column_Name IS NULL Then
449: IF New_References.billing_hrs < 0 OR New_References.billing_hrs > 999.999 Then
450: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
451: IGS_GE_MSG_STACK.ADD;
452: App_Exception.Raise_Exception;
453: END IF;
454: END IF;

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

734: ELSIF (p_action = 'VALIDATE_INSERT') THEN
735: IF Get_PK_For_Validation (New_References.unit_cd,
736: New_References.version_number,
737: New_References.hist_start_dt) THEN
738: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
739: IGS_GE_MSG_STACK.ADD;
740: App_Exception.Raise_Exception;
741: END IF;
742: Check_Constraints;

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

874: if X_LAST_UPDATE_LOGIN is NULL then
875: X_LAST_UPDATE_LOGIN := -1;
876: end if;
877: else
878: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
879: IGS_GE_MSG_STACK.ADD;
880: app_exception.raise_exception;
881: end if;
882:

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

1375: open c1;
1376: fetch c1 into tlinfo;
1377: if (c1%notfound) then
1378: close c1;
1379: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1380: IGS_GE_MSG_STACK.ADD;
1381: app_exception.raise_exception;
1382: return;
1383: end if;

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

1638: AND (X_BILLING_HRS IS NULL)))
1639: ) THEN
1640: NULL;
1641: else
1642: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1643: IGS_GE_MSG_STACK.ADD;
1644: app_exception.raise_exception;
1645: end if;
1646: return;

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

1756: if X_LAST_UPDATE_LOGIN is NULL then
1757: X_LAST_UPDATE_LOGIN := -1;
1758: end if;
1759: else
1760: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1761: IGS_GE_MSG_STACK.ADD;
1762: app_exception.raise_exception;
1763: end if;
1764: Before_DML(