DBA Data[Home] [Help]

APPS.IGS_PR_RU_APPL_PKG dependencies on FND_MESSAGE

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

54: -- Populate Old Values.
55: Open cur_old_ref_values;
56: Fetch cur_old_ref_values INTO old_references;
57: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
58: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
59: IGS_GE_MSG_STACK.ADD;
60: Close cur_old_ref_values;
61: App_Exception.Raise_Exception;
62: Return;

Line 127: Fnd_Message.Set_Name('IGS',v_message_name);

123: NVL(old_references.course_type,'NULL')) THEN
124: IF IGS_as_VAL_acot.crsp_val_cty_closed (
125: new_references.course_type,
126: v_message_name) = FALSE THEN
127: Fnd_Message.Set_Name('IGS',v_message_name);
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131: END IF;

Line 142: Fnd_Message.Set_Name('IGS',v_message_name);

138: IF IGS_PR_VAL_PRA.crsp_val_crv_active (
139: new_references.crv_course_cd,
140: new_references.crv_version_number,
141: v_message_name) = FALSE THEN
142: Fnd_Message.Set_Name('IGS',v_message_name);
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;
146: END IF;

Line 157: Fnd_Message.Set_Name('IGS',v_message_name);

153: IF IGS_PR_VAL_SOPC.prgp_val_ou_active (
154: new_references.ou_org_unit_cd,
155: new_references.ou_start_dt,
156: v_message_name) = FALSE THEN
157: Fnd_Message.Set_Name('IGS',v_message_name);
158: IGS_GE_MSG_STACK.ADD;
159: App_Exception.Raise_Exception;
160: END IF;
161: END IF;

Line 167: Fnd_Message.Set_Name('IGS',v_message_name);

163: IF p_inserting THEN
164: IF IGS_PR_VAL_PRA.prgp_val_prgc_closed (
165: new_references.progression_rule_cat,
166: v_message_name) = FALSE THEN
167: Fnd_Message.Set_Name('IGS',v_message_name);
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: END IF;
171: END IF;

Line 179: Fnd_Message.Set_Name('IGS',v_message_name);

175: NVL(old_references.progression_rule_cd,'NULL'))) THEN
176: IF IGS_PR_VAL_PRA.prgp_val_prr_closed (
177: new_references.progression_rule_cd,
178: v_message_name) = FALSE THEN
179: Fnd_Message.Set_Name('IGS',v_message_name);
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183: END IF;

Line 197: Fnd_Message.Set_Name('IGS',v_message_name);

193: --
194: IF IGS_EN_VAL_PEE.enrp_val_att_closed (
195: new_references.attendance_type,
196: v_message_name) = FALSE THEN
197: Fnd_Message.Set_Name('IGS',v_message_name);
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: END IF;

Line 223: Fnd_Message.Set_Name('IGS',v_message_name);

219: new_references.spo_course_cd,
220: new_references.spo_sequence_number,
221: v_message_name) = FALSE THEN
222:
223: Fnd_Message.Set_Name('IGS',v_message_name);
224: IGS_GE_MSG_STACK.ADD;
225: App_Exception.Raise_Exception;
226: END IF;
227: END IF;

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

238: ELSE
239: IF NOT IGS_EN_ATD_TYPE_PKG.Get_PK_For_Validation (
240: new_references.attendance_type
241: ) THEN
242: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
243: IGS_GE_MSG_STACK.ADD;
244: App_Exception.Raise_Exception;
245:
246: END IF;

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

257: new_references.crv_course_cd,
258: new_references.crv_version_number
259: ) THEN
260:
261: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264:
265: END IF;

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

273: IF NOT IGS_PS_TYPE_PKG.Get_PK_For_Validation (
274: new_references.course_type
275: ) THEN
276:
277: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
278: IGS_GE_MSG_STACK.ADD;
279: App_Exception.Raise_Exception;
280: END IF;
281:

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

291: new_references.ou_org_unit_cd,
292: new_references.ou_start_dt
293: ) THEN
294:
295: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
296: IGS_GE_MSG_STACK.ADD;
297: App_Exception.Raise_Exception;
298:
299: END IF;

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

307: IF NOT IGS_PR_RU_CAT_PKG.Get_PK_For_Validation (
308: new_references.progression_rule_cat
309: ) THEN
310:
311: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
312: IGS_GE_MSG_STACK.ADD;
313: App_Exception.Raise_Exception;
314:
315: END IF;

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

329: new_references.pro_pra_sequence_number,
330: new_references.pro_sequence_number
331: ) THEN
332:
333: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
334: IGS_GE_MSG_STACK.ADD;
335: App_Exception.Raise_Exception;
336:
337: END IF;

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

347: IF NOT IGS_PR_RULE_PKG.Get_PK_For_Validation (
348: new_references.progression_rule_cat,
349: new_references.progression_rule_cd
350: ) THEN
351: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
352: IGS_GE_MSG_STACK.ADD;
353: App_Exception.Raise_Exception;
354:
355: END IF;

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

366: new_references.sca_person_id,
367: new_references.sca_course_cd
368: ) THEN
369:
370: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
371: IGS_GE_MSG_STACK.ADD;
372: App_Exception.Raise_Exception;
373:
374: END IF;

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

388: new_references.spo_course_cd,
389: new_references.spo_sequence_number
390: ) THEN
391:
392: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
393: IGS_GE_MSG_STACK.ADD;
394: App_Exception.Raise_Exception;
395:
396: END IF;

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

406: IF NOT IGS_PR_CLASS_STD_PKG.Get_PK_For_Validation (
407: new_references.igs_pr_class_std_id
408: ) THEN
409:
410: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
411: IGS_GE_MSG_STACK.ADD;
412: App_Exception.Raise_Exception;
413:
414: END IF;

Line 483: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_PCS_FK');

479:
480: Open cur_rowid;
481: Fetch cur_rowid INTO lv_rowid;
482: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
483: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_PCS_FK');
484: IGS_GE_MSG_STACK.ADD;
485: Close cur_rowid;
486: App_Exception.Raise_Exception;
487: Return;

Line 509: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_ATT_FK');

505:
506: Open cur_rowid;
507: Fetch cur_rowid INTO lv_rowid;
508: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null ) THEN
509: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_ATT_FK');
510: IGS_GE_MSG_STACK.ADD;
511: Close cur_rowid;
512: App_Exception.Raise_Exception;
513: Return;

Line 537: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_CRV_FK');

533:
534: Open cur_rowid;
535: Fetch cur_rowid INTO lv_rowid;
536: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
537: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_CRV_FK');
538: IGS_GE_MSG_STACK.ADD;
539: Close cur_rowid;
540: App_Exception.Raise_Exception;
541: Return;

Line 566: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_OU_FK');

562:
563: Open cur_rowid;
564: Fetch cur_rowid INTO lv_rowid;
565: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
566: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_OU_FK');
567: IGS_GE_MSG_STACK.ADD;
568: Close cur_rowid;
569: App_Exception.Raise_Exception;
570: Return;

Line 592: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_PRGC_FK');

588:
589: Open cur_rowid;
590: Fetch cur_rowid INTO lv_rowid;
591: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
592: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_PRGC_FK');
593: IGS_GE_MSG_STACK.ADD;
594: Close cur_rowid;
595: App_Exception.Raise_Exception;
596:

Line 623: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_PRO_FK');

619:
620: Open cur_rowid;
621: Fetch cur_rowid INTO lv_rowid;
622: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
623: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_PRO_FK');
624: IGS_GE_MSG_STACK.ADD;
625: Close cur_rowid;
626: App_Exception.Raise_Exception;
627:

Line 652: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_PRR_FK');

648:
649: Open cur_rowid;
650: Fetch cur_rowid INTO lv_rowid;
651: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
652: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_PRR_FK');
653: IGS_GE_MSG_STACK.ADD;
654: Close cur_rowid;
655: App_Exception.Raise_Exception;
656:

Line 681: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_SCA_FK');

677:
678: Open cur_rowid;
679: Fetch cur_rowid INTO lv_rowid;
680: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
681: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_SCA_FK');
682: IGS_GE_MSG_STACK.ADD;
683: Close cur_rowid;
684: App_Exception.Raise_Exception;
685:

Line 712: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_SPO_FK');

708:
709: Open cur_rowid;
710: Fetch cur_rowid INTO lv_rowid;
711: IF (cur_rowid%FOUND and lv_rowid.logical_delete_dt is null) THEN
712: Fnd_Message.Set_Name ('IGS', 'IGS_PR_PRA_SPO_FK');
713: IGS_GE_MSG_STACK.ADD;
714: Close cur_rowid;
715: App_Exception.Raise_Exception;
716:

Line 754: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

750: OPEN c_parent( new_references.pro_progression_rule_cat, new_references.pro_pra_sequence_number, new_references.pro_sequence_number );
751: FETCH c_parent INTO l_dummy;
752: IF c_parent%NOTFOUND THEN
753: CLOSE c_parent;
754: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
755: IGS_GE_MSG_STACK.ADD;
756: APP_EXCEPTION.RAISE_EXCEPTION;
757: END IF;
758: CLOSE c_parent;

Line 767: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

763: OPEN c_parent( new_references.pro_progression_rule_cat, new_references.pro_pra_sequence_number, new_references.pro_sequence_number );
764: FETCH c_parent INTO l_dummy;
765: IF c_parent%NOTFOUND THEN
766: CLOSE c_parent;
767: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
768: IGS_GE_MSG_STACK.ADD;
769: APP_EXCEPTION.RAISE_EXCEPTION;
770: END IF;
771: CLOSE c_parent;

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

865: IF Get_PK_For_Validation (
866: new_references.progression_rule_cat,
867: new_references.sequence_number
868: ) THEN
869: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
870: IGS_GE_MSG_STACK.ADD;
871: App_Exception.Raise_Exception;
872: END IF;
873: CHECK_CONSTRAINTS;

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

891: IF Get_PK_For_Validation (
892: new_references.progression_rule_cat,
893: new_references.sequence_number
894: ) THEN
895: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
896: IGS_GE_MSG_STACK.ADD;
897: App_Exception.Raise_Exception;
898: END IF;
899: CHECK_CONSTRAINTS;

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

960: if X_LAST_UPDATE_LOGIN is NULL then
961: X_LAST_UPDATE_LOGIN := -1;
962: end if;
963: else
964: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
965: IGS_GE_MSG_STACK.ADD;
966: app_exception.raise_exception;
967: end if;
968:

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

1136: begin
1137: open c1;
1138: fetch c1 into tlinfo;
1139: if (c1%notfound) then
1140: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1141: IGS_GE_MSG_STACK.ADD;
1142: close c1;
1143: app_exception.raise_exception;
1144:

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

1215: AND (X_MESSAGE is null)))
1216: ) then
1217: null;
1218: else
1219: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1220: IGS_GE_MSG_STACK.ADD;
1221: app_exception.raise_exception;
1222: end if;
1223: return;

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

1269: if X_LAST_UPDATE_LOGIN is NULL then
1270: X_LAST_UPDATE_LOGIN := -1;
1271: end if;
1272: else
1273: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1274: IGS_GE_MSG_STACK.ADD;
1275: app_exception.raise_exception;
1276: end if;
1277: Before_DML (

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

1520: END IF ;
1521:
1522: IF upper(Column_name) = 'ATTENDANCE_TYPE' OR COLUMN_NAME IS NULL THEN
1523: IF new_references.ATTENDANCE_TYPE<> upper(new_references.ATTENDANCE_TYPE) then
1524: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1525: IGS_GE_MSG_STACK.ADD;
1526: App_Exception.Raise_Exception ;
1527: END IF;
1528:

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

1529: END IF ;
1530:
1531: IF upper(Column_name) = 'COURSE_TYPE' OR COLUMN_NAME IS NULL THEN
1532: IF new_references.COURSE_TYPE<> upper(new_references.COURSE_TYPE) then
1533: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1534: IGS_GE_MSG_STACK.ADD;
1535: App_Exception.Raise_Exception ;
1536: END IF;
1537:

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

1538: END IF ;
1539:
1540: IF upper(Column_name) = 'CRV_COURSE_CD' OR COLUMN_NAME IS NULL THEN
1541: IF new_references.CRV_COURSE_CD<> upper(new_references.CRV_COURSE_CD) then
1542: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1543: IGS_GE_MSG_STACK.ADD;
1544: App_Exception.Raise_Exception ;
1545: END IF;
1546:

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

1548:
1549:
1550: IF upper(Column_name) = 'PROGRESSION_RULE_CAT' OR COLUMN_NAME IS NULL THEN
1551: IF new_references.PROGRESSION_RULE_CAT<> upper(new_references.PROGRESSION_RULE_CAT) then
1552: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1553: IGS_GE_MSG_STACK.ADD;
1554: App_Exception.Raise_Exception ;
1555: END IF;
1556:

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

1557: END IF ;
1558:
1559: IF upper(Column_name) = 'PROGRESSION_RULE_CD' OR COLUMN_NAME IS NULL THEN
1560: IF new_references.PROGRESSION_RULE_CD<> upper(new_references.PROGRESSION_RULE_CD) then
1561: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1562: IGS_GE_MSG_STACK.ADD;
1563: App_Exception.Raise_Exception ;
1564: END IF;
1565:

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

1566: END IF ;
1567:
1568: IF upper(Column_name) = 'REFERENCE_CD' OR COLUMN_NAME IS NULL THEN
1569: IF new_references.REFERENCE_CD<> upper(new_references.REFERENCE_CD) then
1570: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1571: IGS_GE_MSG_STACK.ADD;
1572: App_Exception.Raise_Exception ;
1573: END IF;
1574:

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

1575: END IF ;
1576:
1577: IF upper(Column_name) = 'SCA_COURSE_CD' OR COLUMN_NAME IS NULL THEN
1578: IF new_references.SCA_COURSE_CD<> upper(new_references.SCA_COURSE_CD) then
1579: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1580: IGS_GE_MSG_STACK.ADD;
1581: App_Exception.Raise_Exception ;
1582: END IF;
1583:

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

1584: END IF ;
1585:
1586: IF upper(Column_name) = 'SPO_COURSE_CD' OR COLUMN_NAME IS NULL THEN
1587: IF new_references.SPO_COURSE_CD<> upper(new_references.SPO_COURSE_CD) then
1588: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1589: IGS_GE_MSG_STACK.ADD;
1590: App_Exception.Raise_Exception ;
1591: END IF;
1592:

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

1593: END IF ;
1594:
1595: IF upper(Column_name) = 'PRO_PROGRESSION_RULE_CAT' OR COLUMN_NAME IS NULL THEN
1596: IF new_references.PRO_PROGRESSION_RULE_CAT<> upper(new_references.PRO_PROGRESSION_RULE_CAT) then
1597: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1598: IGS_GE_MSG_STACK.ADD;
1599: App_Exception.Raise_Exception ;
1600: END IF;
1601:

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

1602: END IF ;
1603:
1604: IF upper(Column_name) = 'S_RELATION_TYPE' OR COLUMN_NAME IS NULL THEN
1605: IF new_references.S_RELATION_TYPE<> upper(new_references.S_RELATION_TYPE) then
1606: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1607: IGS_GE_MSG_STACK.ADD;
1608: App_Exception.Raise_Exception ;
1609: END IF;
1610:

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

1608: App_Exception.Raise_Exception ;
1609: END IF;
1610:
1611: IF new_references.S_RELATION_TYPE not in ('OU' , 'CTY' , 'CRV' , 'SCA' , 'PRR' , 'PRGC' , 'SPO' , 'PRO' ) then
1612: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1613: IGS_GE_MSG_STACK.ADD;
1614: App_Exception.Raise_Exception ;
1615: END IF;
1616:

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

1617: END IF ;
1618:
1619: IF upper(Column_name) = 'PRO_PRA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
1620: IF new_references.PRO_PRA_SEQUENCE_NUMBER < 1 or new_references.PRO_PRA_SEQUENCE_NUMBER > 999999 then
1621: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1622: IGS_GE_MSG_STACK.ADD;
1623: App_Exception.Raise_Exception ;
1624: END IF;
1625:

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

1626: END IF ;
1627:
1628: IF upper(Column_name) = 'PRO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
1629: IF new_references.PRO_SEQUENCE_NUMBER < 1 or new_references.PRO_SEQUENCE_NUMBER > 999999 then
1630: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1631: IGS_GE_MSG_STACK.ADD;
1632: App_Exception.Raise_Exception ;
1633: END IF;
1634:

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

1635: END IF ;
1636:
1637: IF upper(Column_name) = 'SPO_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
1638: IF new_references.SPO_SEQUENCE_NUMBER < 1 or new_references.SPO_SEQUENCE_NUMBER > 999999 then
1639: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1640: IGS_GE_MSG_STACK.ADD;
1641: App_Exception.Raise_Exception ;
1642: END IF;
1643: