219: fetch c_dup_task_type into l_dummy_var;
220:
221: if l_dummy_var is not null then
222: close c_dup_task_type;
223: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SKILLTYPE');
224: raise_application_error(-20110,fnd_message.get);
225: end if;
226:
227: close c_dup_task_type;
220:
221: if l_dummy_var is not null then
222: close c_dup_task_type;
223: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SKILLTYPE');
224: raise_application_error(-20110,fnd_message.get);
225: end if;
226:
227: close c_dup_task_type;
228:
414: fetch c_ovn into l_rec;
415: if c_ovn%notfound
416: then
417: close c_ovn;
418: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
419: app_exception.raise_exception;
420: end if;
421: close c_ovn;
422:
423: if l_rec.object_version_number = x_object_version_number
424: then
425: null;
426: else
427: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
428: app_exception.raise_exception;
429: end if;
430:
431: for i in c_tl
437: or ( i.description is null and x_description is null ) )
438: then
439: null;
440: else
441: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
442: app_exception.raise_exception;
443: end if;
444: end if;
445: end loop;
488: fetch c_dup_task_type into l_dummy_var;
489:
490: if l_dummy_var is not null then
491: close c_dup_task_type;
492: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SKILLTYPE');
493: raise_application_error(-20110, fnd_message.get);
494: end if;
495:
496: close c_dup_task_type;
489:
490: if l_dummy_var is not null then
491: close c_dup_task_type;
492: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SKILLTYPE');
493: raise_application_error(-20110, fnd_message.get);
494: end if;
495:
496: close c_dup_task_type;
497:
691: fetch c_dup_skill_type into l_dummy_var;
692:
693: if l_dummy_var is not null then
694: close c_dup_skill_type;
695: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SKILL');
696: raise_application_error(-20110, fnd_message.get);
697: end if;
698:
699: close c_dup_skill_type;
692:
693: if l_dummy_var is not null then
694: close c_dup_skill_type;
695: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SKILL');
696: raise_application_error(-20110, fnd_message.get);
697: end if;
698:
699: close c_dup_skill_type;
700:
831: fetch c_ovn into l_rec;
832: if c_ovn%notfound
833: then
834: close c_ovn;
835: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
836: app_exception.raise_exception;
837: end if;
838: close c_ovn;
839:
840: if l_rec.object_version_number = x_object_version_number
841: then
842: null;
843: else
844: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
845: app_exception.raise_exception;
846: end if;
847:
848: for i in c_tl
854: or ( i.description is null and x_description is null ) )
855: then
856: null;
857: else
858: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
859: app_exception.raise_exception;
860: end if;
861: end if;
862: end loop;
906: fetch c_dup_skill_type into l_dummy_var;
907:
908: if l_dummy_var is not null then
909: close c_dup_skill_type;
910: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SKILL');
911: raise_application_error(-20110, fnd_message.get);
912: end if;
913:
914: close c_dup_skill_type;
907:
908: if l_dummy_var is not null then
909: close c_dup_skill_type;
910: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SKILL');
911: raise_application_error(-20110, fnd_message.get);
912: end if;
913:
914: close c_dup_skill_type;
915:
1107: fetch c_dup_scale_type into l_dummy_var;
1108:
1109: if l_dummy_var is not null then
1110: close c_dup_scale_type;
1111: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SCALE');
1112: raise_application_error(-20110,fnd_message.get);
1113: end if;
1114:
1115: close c_dup_scale_type;
1108:
1109: if l_dummy_var is not null then
1110: close c_dup_scale_type;
1111: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SCALE');
1112: raise_application_error(-20110,fnd_message.get);
1113: end if;
1114:
1115: close c_dup_scale_type;
1116:
1243: fetch c_ovn into l_rec;
1244: if c_ovn%notfound
1245: then
1246: close c_ovn;
1247: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1248: app_exception.raise_exception;
1249: end if;
1250: close c_ovn;
1251:
1252: if l_rec.object_version_number = x_object_version_number
1253: then
1254: null;
1255: else
1256: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1257: app_exception.raise_exception;
1258: end if;
1259:
1260: for i in c_tl
1266: or ( i.description is null and x_description is null ) )
1267: then
1268: null;
1269: else
1270: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1271: app_exception.raise_exception;
1272: end if;
1273: end if;
1274: end loop;
1316: fetch c_dup_scale_type into l_dummy_var;
1317:
1318: if l_dummy_var is not null then
1319: close c_dup_scale_type;
1320: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SCALE');
1321: raise_application_error(-20110,fnd_message.get);
1322: end if;
1323:
1324: close c_dup_scale_type;
1317:
1318: if l_dummy_var is not null then
1319: close c_dup_scale_type;
1320: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SCALE');
1321: raise_application_error(-20110,fnd_message.get);
1322: end if;
1323:
1324: close c_dup_scale_type;
1325:
1535: open c_dup_order;
1536: fetch c_dup_order into l_dummy_var;
1537:
1538: if l_dummy_var is not null then
1539: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_ORDER');
1540: raise_application_error(-20120,fnd_message.get);
1541: end if;
1542:
1543: close c_dup_order;
1536: fetch c_dup_order into l_dummy_var;
1537:
1538: if l_dummy_var is not null then
1539: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_ORDER');
1540: raise_application_error(-20120,fnd_message.get);
1541: end if;
1542:
1543: close c_dup_order;
1544:
1546: open c_dup_name;
1547: fetch c_dup_name into l_dummy_var;
1548:
1549: if l_dummy_var is not null then
1550: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_LEVEL');
1551: raise_application_error(-20110,fnd_message.get);
1552: end if;
1553:
1554: close c_dup_name;
1547: fetch c_dup_name into l_dummy_var;
1548:
1549: if l_dummy_var is not null then
1550: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_LEVEL');
1551: raise_application_error(-20110,fnd_message.get);
1552: end if;
1553:
1554: close c_dup_name;
1555:
1688: fetch c_ovn into l_rec;
1689: if c_ovn%notfound
1690: then
1691: close c_ovn;
1692: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1693: app_exception.raise_exception;
1694: end if;
1695: close c_ovn;
1696:
1697: if l_rec.object_version_number = x_object_version_number
1698: then
1699: null;
1700: else
1701: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1702: app_exception.raise_exception;
1703: end if;
1704:
1705: for i in c_tl
1711: or ( i.description is null and x_description is null ) )
1712: then
1713: null;
1714: else
1715: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1716: app_exception.raise_exception;
1717: end if;
1718: end if;
1719: end loop;
1781: open c_dup_order;
1782: fetch c_dup_order into l_dummy_var;
1783:
1784: if l_dummy_var is not null then
1785: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_ORDER');
1786: raise_application_error(-20120,fnd_message.get);
1787: end if;
1788:
1789: close c_dup_order;
1782: fetch c_dup_order into l_dummy_var;
1783:
1784: if l_dummy_var is not null then
1785: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_ORDER');
1786: raise_application_error(-20120,fnd_message.get);
1787: end if;
1788:
1789: close c_dup_order;
1790:
1792: open c_dup_name;
1793: fetch c_dup_name into l_dummy_var;
1794:
1795: if l_dummy_var is not null then
1796: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_LEVEL');
1797: raise_application_error(-20110,fnd_message.get);
1798: end if;
1799:
1800: close c_dup_name;
1793: fetch c_dup_name into l_dummy_var;
1794:
1795: if l_dummy_var is not null then
1796: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_LEVEL');
1797: raise_application_error(-20110,fnd_message.get);
1798: end if;
1799:
1800: close c_dup_name;
1801:
1999: fetch c_resSkill into l_dummy_var;
2000:
2001: if l_dummy_var is not null then
2002: close c_resSkill;
2003: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_RS_SKILL_DATE');
2004: raise_application_error(-20110,fnd_message.get);
2005: end if;
2006:
2007: close c_resSkill;
2000:
2001: if l_dummy_var is not null then
2002: close c_resSkill;
2003: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_RS_SKILL_DATE');
2004: raise_application_error(-20110,fnd_message.get);
2005: end if;
2006:
2007: close c_resSkill;
2008:
2102: fetch c_ovn into l_rec;
2103: if c_ovn%notfound
2104: then
2105: close c_ovn;
2106: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
2107: app_exception.raise_exception;
2108: end if;
2109: close c_ovn;
2110:
2111: if l_rec.object_version_number = x_object_version_number
2112: then
2113: null;
2114: else
2115: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2116: app_exception.raise_exception;
2117: end if;
2118: END lock_resource_skill;
2119:
2163: fetch c_resSkill into l_dummy_var;
2164:
2165: if l_dummy_var is not null then
2166: close c_resSkill;
2167: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_RS_SKILL_DATE');
2168: raise_application_error(-20110,fnd_message.get);
2169: end if;
2170:
2171: close c_resSkill;
2164:
2165: if l_dummy_var is not null then
2166: close c_resSkill;
2167: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_RS_SKILL_DATE');
2168: raise_application_error(-20110,fnd_message.get);
2169: end if;
2170:
2171: close c_resSkill;
2172:
2292: if l_dummy_var is not null then
2293: close c_reqSkill;
2294:
2295: if x_has_skill_type='TASK' then
2296: fnd_message.set_name('CSF','CSF_DUPLICATE_RECORD');
2297: raise_application_error(-20110,fnd_message.get);
2298: elsIf x_has_skill_type='TASK TEMPLATE' then
2299: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_TASK_TEMPLATE');
2300: raise_application_error(-20110,fnd_message.get);
2293: close c_reqSkill;
2294:
2295: if x_has_skill_type='TASK' then
2296: fnd_message.set_name('CSF','CSF_DUPLICATE_RECORD');
2297: raise_application_error(-20110,fnd_message.get);
2298: elsIf x_has_skill_type='TASK TEMPLATE' then
2299: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_TASK_TEMPLATE');
2300: raise_application_error(-20110,fnd_message.get);
2301: end if;
2295: if x_has_skill_type='TASK' then
2296: fnd_message.set_name('CSF','CSF_DUPLICATE_RECORD');
2297: raise_application_error(-20110,fnd_message.get);
2298: elsIf x_has_skill_type='TASK TEMPLATE' then
2299: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_TASK_TEMPLATE');
2300: raise_application_error(-20110,fnd_message.get);
2301: end if;
2302: end if;
2303:
2296: fnd_message.set_name('CSF','CSF_DUPLICATE_RECORD');
2297: raise_application_error(-20110,fnd_message.get);
2298: elsIf x_has_skill_type='TASK TEMPLATE' then
2299: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_TASK_TEMPLATE');
2300: raise_application_error(-20110,fnd_message.get);
2301: end if;
2302: end if;
2303:
2304: close c_reqSkill;
2405: fetch c_ovn into l_rec;
2406: if c_ovn%notfound
2407: then
2408: close c_ovn;
2409: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
2410: app_exception.raise_exception;
2411: end if;
2412: close c_ovn;
2413:
2414: if l_rec.object_version_number = x_object_version_number
2415: then
2416: null;
2417: else
2418: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2419: app_exception.raise_exception;
2420: end if;
2421: END lock_required_skill;
2422: