DBA Data[Home] [Help]

APPS.CSF_SKILLS_PKG dependencies on FND_MESSAGE

Line 223: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SKILLTYPE');

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;

Line 224: raise_application_error(-20110,fnd_message.get);

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:

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

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:

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

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

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

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;

Line 492: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SKILLTYPE');

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;

Line 493: raise_application_error(-20110, fnd_message.get);

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:

Line 695: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SKILL');

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;

Line 696: raise_application_error(-20110, fnd_message.get);

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:

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

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:

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

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

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

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;

Line 910: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SKILL');

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;

Line 911: raise_application_error(-20110, fnd_message.get);

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:

Line 1111: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SCALE');

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;

Line 1112: raise_application_error(-20110,fnd_message.get);

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:

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

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:

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

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

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

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;

Line 1320: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_SCALE');

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;

Line 1321: raise_application_error(-20110,fnd_message.get);

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:

Line 1539: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_ORDER');

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;

Line 1540: raise_application_error(-20120,fnd_message.get);

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:

Line 1550: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_LEVEL');

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;

Line 1551: raise_application_error(-20110,fnd_message.get);

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:

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

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:

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

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

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

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;

Line 1785: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_ORDER');

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;

Line 1786: raise_application_error(-20120,fnd_message.get);

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:

Line 1796: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_LEVEL');

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;

Line 1797: raise_application_error(-20110,fnd_message.get);

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:

Line 2003: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_RS_SKILL_DATE');

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;

Line 2004: raise_application_error(-20110,fnd_message.get);

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:

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

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:

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

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:

Line 2167: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_RS_SKILL_DATE');

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;

Line 2168: raise_application_error(-20110,fnd_message.get);

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:

Line 2296: fnd_message.set_name('CSF','CSF_DUPLICATE_RECORD');

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);

Line 2297: 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;

Line 2299: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_TASK_TEMPLATE');

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:

Line 2300: raise_application_error(-20110,fnd_message.get);

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;

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

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:

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

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: