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 2002: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_RES_SKILL');

1998: fetch c_resSkill into l_dummy_var;
1999:
2000: if l_dummy_var is not null then
2001: close c_resSkill;
2002: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_RES_SKILL');
2003: raise_application_error(-20110,fnd_message.get);
2004: end if;
2005:
2006: close c_resSkill;

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

1999:
2000: if l_dummy_var is not null then
2001: close c_resSkill;
2002: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_RES_SKILL');
2003: raise_application_error(-20110,fnd_message.get);
2004: end if;
2005:
2006: close c_resSkill;
2007:

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

2101: fetch c_ovn into l_rec;
2102: if c_ovn%notfound
2103: then
2104: close c_ovn;
2105: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
2106: app_exception.raise_exception;
2107: end if;
2108: close c_ovn;
2109:

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

2110: if l_rec.object_version_number = x_object_version_number
2111: then
2112: null;
2113: else
2114: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2115: app_exception.raise_exception;
2116: end if;
2117: END lock_resource_skill;
2118:

Line 2165: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_RES_SKILL');

2161: fetch c_resSkill into l_dummy_var;
2162:
2163: if l_dummy_var is not null then
2164: close c_resSkill;
2165: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_RES_SKILL');
2166: raise_application_error(-20110,fnd_message.get);
2167: end if;
2168:
2169: close c_resSkill;

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

2162:
2163: if l_dummy_var is not null then
2164: close c_resSkill;
2165: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_RES_SKILL');
2166: raise_application_error(-20110,fnd_message.get);
2167: end if;
2168:
2169: close c_resSkill;
2170:

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

2290: if l_dummy_var is not null then
2291: close c_reqSkill;
2292:
2293: if x_has_skill_type='TASK' then
2294: fnd_message.set_name('CSF','CSF_DUPLICATE_RECORD');
2295: raise_application_error(-20110,fnd_message.get);
2296: elsIf x_has_skill_type='TASK TEMPLATE' then
2297: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_TASK_TEMPLATE');
2298: raise_application_error(-20110,fnd_message.get);

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

2291: close c_reqSkill;
2292:
2293: if x_has_skill_type='TASK' then
2294: fnd_message.set_name('CSF','CSF_DUPLICATE_RECORD');
2295: raise_application_error(-20110,fnd_message.get);
2296: elsIf x_has_skill_type='TASK TEMPLATE' then
2297: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_TASK_TEMPLATE');
2298: raise_application_error(-20110,fnd_message.get);
2299: end if;

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

2293: if x_has_skill_type='TASK' then
2294: fnd_message.set_name('CSF','CSF_DUPLICATE_RECORD');
2295: raise_application_error(-20110,fnd_message.get);
2296: elsIf x_has_skill_type='TASK TEMPLATE' then
2297: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_TASK_TEMPLATE');
2298: raise_application_error(-20110,fnd_message.get);
2299: end if;
2300: end if;
2301:

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

2294: fnd_message.set_name('CSF','CSF_DUPLICATE_RECORD');
2295: raise_application_error(-20110,fnd_message.get);
2296: elsIf x_has_skill_type='TASK TEMPLATE' then
2297: fnd_message.set_name('CSF','CSF_DC_DUPLICATE_TASK_TEMPLATE');
2298: raise_application_error(-20110,fnd_message.get);
2299: end if;
2300: end if;
2301:
2302: close c_reqSkill;

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

2403: fetch c_ovn into l_rec;
2404: if c_ovn%notfound
2405: then
2406: close c_ovn;
2407: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
2408: app_exception.raise_exception;
2409: end if;
2410: close c_ovn;
2411:

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

2412: if l_rec.object_version_number = x_object_version_number
2413: then
2414: null;
2415: else
2416: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2417: app_exception.raise_exception;
2418: end if;
2419: END lock_required_skill;
2420: