eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_CTU_BUS dependencies on FND_MESSAGE

Line 63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'CATEGORY_USAGE_ID')
67: );

Line 144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --

Line 145: fnd_message.raise_error;

141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are

Line 346: fnd_message.set_name ( 'OTA','OTA_13742_CTU_PAR_CAT_DATES');

342: IF ( l_par_cat_start_date > p_start_date
343: or l_par_cat_end_date < nvl(p_end_date, hr_api.g_eot)
344: ) THEN
345: --
346: fnd_message.set_name ( 'OTA','OTA_13742_CTU_PAR_CAT_DATES');
347: fnd_message.raise_error;
348: --
349: End IF;
350: ELSE

Line 347: fnd_message.raise_error;

343: or l_par_cat_end_date < nvl(p_end_date, hr_api.g_eot)
344: ) THEN
345: --
346: fnd_message.set_name ( 'OTA','OTA_13742_CTU_PAR_CAT_DATES');
347: fnd_message.raise_error;
348: --
349: End IF;
350: ELSE
351: CLOSE cur_par_cat_start_end_date;

Line 424: fnd_message.set_name( 'OTA','OTA_443166_OBJ_CHILD_DATE');

420: , v_end_date ) then
421: --
422: l_obj_cat := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','C',810);
423: l_obj_child_cat := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','CHC',810);
424: fnd_message.set_name( 'OTA','OTA_443166_OBJ_CHILD_DATE');
425: fnd_message.set_token('OBJECT_NAME', l_obj_cat );
426: fnd_message.set_token('CHILD_OBJECT', l_obj_child_cat);
427: fnd_message.raise_error;
428: --

Line 425: fnd_message.set_token('OBJECT_NAME', l_obj_cat );

421: --
422: l_obj_cat := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','C',810);
423: l_obj_child_cat := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','CHC',810);
424: fnd_message.set_name( 'OTA','OTA_443166_OBJ_CHILD_DATE');
425: fnd_message.set_token('OBJECT_NAME', l_obj_cat );
426: fnd_message.set_token('CHILD_OBJECT', l_obj_child_cat);
427: fnd_message.raise_error;
428: --
429: End if;

Line 426: fnd_message.set_token('CHILD_OBJECT', l_obj_child_cat);

422: l_obj_cat := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','C',810);
423: l_obj_child_cat := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','CHC',810);
424: fnd_message.set_name( 'OTA','OTA_443166_OBJ_CHILD_DATE');
425: fnd_message.set_token('OBJECT_NAME', l_obj_cat );
426: fnd_message.set_token('CHILD_OBJECT', l_obj_child_cat);
427: fnd_message.raise_error;
428: --
429: End if;
430: --

Line 427: fnd_message.raise_error;

423: l_obj_child_cat := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','CHC',810);
424: fnd_message.set_name( 'OTA','OTA_443166_OBJ_CHILD_DATE');
425: fnd_message.set_token('OBJECT_NAME', l_obj_cat );
426: fnd_message.set_token('CHILD_OBJECT', l_obj_child_cat);
427: fnd_message.raise_error;
428: --
429: End if;
430: --
431: Fetch cur_child_cat_dates into v_start_date

Line 516: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');

512: --
513:
514: l_obj_cat := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','C',810);
515: l_obj_act := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','H',810);
516: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
517: fnd_message.set_token('OBJECT_NAME', l_obj_cat );
518: fnd_message.set_token('CHILD_OBJECT', l_obj_act);
519: fnd_message.raise_error;
520: --

Line 517: fnd_message.set_token('OBJECT_NAME', l_obj_cat );

513:
514: l_obj_cat := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','C',810);
515: l_obj_act := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','H',810);
516: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
517: fnd_message.set_token('OBJECT_NAME', l_obj_cat );
518: fnd_message.set_token('CHILD_OBJECT', l_obj_act);
519: fnd_message.raise_error;
520: --
521: End if;

Line 518: fnd_message.set_token('CHILD_OBJECT', l_obj_act);

514: l_obj_cat := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','C',810);
515: l_obj_act := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','H',810);
516: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
517: fnd_message.set_token('OBJECT_NAME', l_obj_cat );
518: fnd_message.set_token('CHILD_OBJECT', l_obj_act);
519: fnd_message.raise_error;
520: --
521: End if;
522: --

Line 519: fnd_message.raise_error;

515: l_obj_act := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','H',810);
516: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
517: fnd_message.set_token('OBJECT_NAME', l_obj_cat );
518: fnd_message.set_token('CHILD_OBJECT', l_obj_act);
519: fnd_message.raise_error;
520: --
521: End if;
522: --
523: Fetch cur_act_dates into v_start_date

Line 609: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');

605: --
606:
607: l_obj_cat := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','C',810);
608: l_obj_lp := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','CLP',810);
609: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
610: fnd_message.set_token('OBJECT_NAME', l_obj_cat );
611: fnd_message.set_token('CHILD_OBJECT', l_obj_lp);
612: fnd_message.raise_error;
613: --

Line 610: fnd_message.set_token('OBJECT_NAME', l_obj_cat );

606:
607: l_obj_cat := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','C',810);
608: l_obj_lp := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','CLP',810);
609: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
610: fnd_message.set_token('OBJECT_NAME', l_obj_cat );
611: fnd_message.set_token('CHILD_OBJECT', l_obj_lp);
612: fnd_message.raise_error;
613: --
614: End if;

Line 611: fnd_message.set_token('CHILD_OBJECT', l_obj_lp);

607: l_obj_cat := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','C',810);
608: l_obj_lp := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','CLP',810);
609: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
610: fnd_message.set_token('OBJECT_NAME', l_obj_cat );
611: fnd_message.set_token('CHILD_OBJECT', l_obj_lp);
612: fnd_message.raise_error;
613: --
614: End if;
615: --

Line 612: fnd_message.raise_error;

608: l_obj_lp := ota_utility.Get_lookup_meaning('OTA_CATALOG_OBJECT_TYPE','CLP',810);
609: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
610: fnd_message.set_token('OBJECT_NAME', l_obj_cat );
611: fnd_message.set_token('CHILD_OBJECT', l_obj_lp);
612: fnd_message.raise_error;
613: --
614: End if;
615: --
616: Fetch cur_lp_dates into v_start_date

Line 672: fnd_message.set_name ( 'OTA' ,'OTA_443103_ROOT_OBJ_EXISTS');

668: FETCH cur_root_category into l_root_cat_flag;
669:
670: IF cur_root_category%FOUND then
671: CLOSE cur_root_category;
672: fnd_message.set_name ( 'OTA' ,'OTA_443103_ROOT_OBJ_EXISTS');
673: fnd_message.raise_error;
674: ELSE
675: CLOSE cur_root_category;
676: END IF;

Line 673: fnd_message.raise_error;

669:
670: IF cur_root_category%FOUND then
671: CLOSE cur_root_category;
672: fnd_message.set_name ( 'OTA' ,'OTA_443103_ROOT_OBJ_EXISTS');
673: fnd_message.raise_error;
674: ELSE
675: CLOSE cur_root_category;
676: END IF;
677:

Line 753: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');

749: --
750:
751: l_obj_dm := ota_utility.Get_lookup_meaning('CATEGORY_TYPE','DM',800);
752: l_obj_off := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','OFS',810);
753: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
754: fnd_message.set_token('OBJECT_NAME', l_obj_dm );
755: fnd_message.set_token('CHILD_OBJECT', l_obj_off);
756: fnd_message.raise_error;
757: --

Line 754: fnd_message.set_token('OBJECT_NAME', l_obj_dm );

750:
751: l_obj_dm := ota_utility.Get_lookup_meaning('CATEGORY_TYPE','DM',800);
752: l_obj_off := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','OFS',810);
753: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
754: fnd_message.set_token('OBJECT_NAME', l_obj_dm );
755: fnd_message.set_token('CHILD_OBJECT', l_obj_off);
756: fnd_message.raise_error;
757: --
758: End if;

Line 755: fnd_message.set_token('CHILD_OBJECT', l_obj_off);

751: l_obj_dm := ota_utility.Get_lookup_meaning('CATEGORY_TYPE','DM',800);
752: l_obj_off := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','OFS',810);
753: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
754: fnd_message.set_token('OBJECT_NAME', l_obj_dm );
755: fnd_message.set_token('CHILD_OBJECT', l_obj_off);
756: fnd_message.raise_error;
757: --
758: End if;
759: --

Line 756: fnd_message.raise_error;

752: l_obj_off := ota_utility.Get_lookup_meaning('OTA_OBJECT_TYPE','OFS',810);
753: fnd_message.set_name ( 'OTA','OTA_443166_OBJ_CHILD_DATE');
754: fnd_message.set_token('OBJECT_NAME', l_obj_dm );
755: fnd_message.set_token('CHILD_OBJECT', l_obj_off);
756: fnd_message.raise_error;
757: --
758: End if;
759: --
760: Fetch cur_off_dates into v_start_date

Line 814: fnd_message.set_name ( 'OTA' ,'OTA_443269_CTU_FLG_OFF_EXISTS');

810: FETCH cur_dm_offerings into l_off_flag;
811:
812: IF cur_dm_offerings%FOUND then
813: CLOSE cur_dm_offerings;
814: fnd_message.set_name ( 'OTA' ,'OTA_443269_CTU_FLG_OFF_EXISTS');
815: fnd_message.raise_error;
816: ELSE
817: CLOSE cur_dm_offerings;
818: END IF;

Line 815: fnd_message.raise_error;

811:
812: IF cur_dm_offerings%FOUND then
813: CLOSE cur_dm_offerings;
814: fnd_message.set_name ( 'OTA' ,'OTA_443269_CTU_FLG_OFF_EXISTS');
815: fnd_message.raise_error;
816: ELSE
817: CLOSE cur_dm_offerings;
818: END IF;
819:

Line 880: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

876: IF NOT ota_ctu_shd.api_updating
877: (p_category_usage_id => p_rec.category_usage_id
878: ,p_object_version_number => p_rec.object_version_number
879: ) THEN
880: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
881: fnd_message.set_token('PROCEDURE ', l_proc);
882: fnd_message.set_token('STEP ', '5');
883: fnd_message.raise_error;
884: END IF;

Line 881: fnd_message.set_token('PROCEDURE ', l_proc);

877: (p_category_usage_id => p_rec.category_usage_id
878: ,p_object_version_number => p_rec.object_version_number
879: ) THEN
880: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
881: fnd_message.set_token('PROCEDURE ', l_proc);
882: fnd_message.set_token('STEP ', '5');
883: fnd_message.raise_error;
884: END IF;
885: --

Line 882: fnd_message.set_token('STEP ', '5');

878: ,p_object_version_number => p_rec.object_version_number
879: ) THEN
880: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
881: fnd_message.set_token('PROCEDURE ', l_proc);
882: fnd_message.set_token('STEP ', '5');
883: fnd_message.raise_error;
884: END IF;
885: --
886: --

Line 883: fnd_message.raise_error;

879: ) THEN
880: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
881: fnd_message.set_token('PROCEDURE ', l_proc);
882: fnd_message.set_token('STEP ', '5');
883: fnd_message.raise_error;
884: END IF;
885: --
886: --
887: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 939: fnd_message.set_name('OTA','OTA_443388_CTU_DUP_DM');

935: -- The category name cannot be duplicated therefore we must error
936: --
937: close csr_cat_name;
938: if l_dup_cat_type = 'DM' then
939: fnd_message.set_name('OTA','OTA_443388_CTU_DUP_DM');
940: else
941: fnd_message.set_name('OTA','OTA_443337_CTU_DUP_NAME');
942: end if;
943: hr_utility.set_location(l_proc,20);

Line 941: fnd_message.set_name('OTA','OTA_443337_CTU_DUP_NAME');

937: close csr_cat_name;
938: if l_dup_cat_type = 'DM' then
939: fnd_message.set_name('OTA','OTA_443388_CTU_DUP_DM');
940: else
941: fnd_message.set_name('OTA','OTA_443337_CTU_DUP_NAME');
942: end if;
943: hr_utility.set_location(l_proc,20);
944: fnd_message.raise_error;
945: end if;

Line 944: fnd_message.raise_error;

940: else
941: fnd_message.set_name('OTA','OTA_443337_CTU_DUP_NAME');
942: end if;
943: hr_utility.set_location(l_proc,20);
944: fnd_message.raise_error;
945: end if;
946: hr_utility.set_location(l_proc,30);
947: --
948: -- Set the global variables so the values are

Line 1257: fnd_message.set_name ( 'OTA' ,'OTA_443200_CTU_CHILD_EXITS');

1253: --
1254: --
1255:
1256: IF (p_category_usage_id = p_parent_cat_usage_id) THEN
1257: fnd_message.set_name ( 'OTA' ,'OTA_443200_CTU_CHILD_EXITS');
1258: fnd_message.raise_error;
1259: ELSE
1260:
1261: OPEN cur_parent_categories;

Line 1258: fnd_message.raise_error;

1254: --
1255:
1256: IF (p_category_usage_id = p_parent_cat_usage_id) THEN
1257: fnd_message.set_name ( 'OTA' ,'OTA_443200_CTU_CHILD_EXITS');
1258: fnd_message.raise_error;
1259: ELSE
1260:
1261: OPEN cur_parent_categories;
1262: FETCH cur_parent_categories into l_cat_flag;

Line 1266: fnd_message.set_name ( 'OTA' ,'OTA_443200_CTU_CHILD_EXITS');

1262: FETCH cur_parent_categories into l_cat_flag;
1263:
1264: IF cur_parent_categories%FOUND then
1265: CLOSE cur_parent_categories;
1266: fnd_message.set_name ( 'OTA' ,'OTA_443200_CTU_CHILD_EXITS');
1267: fnd_message.raise_error;
1268: ELSE
1269: CLOSE cur_parent_categories;
1270: END IF;

Line 1267: fnd_message.raise_error;

1263:
1264: IF cur_parent_categories%FOUND then
1265: CLOSE cur_parent_categories;
1266: fnd_message.set_name ( 'OTA' ,'OTA_443200_CTU_CHILD_EXITS');
1267: fnd_message.raise_error;
1268: ELSE
1269: CLOSE cur_parent_categories;
1270: END IF;
1271: END IF;

Line 1318: fnd_message.set_name ( 'OTA' ,'OTA_443273_CTU_CHLD_CAT_EXISTS');

1314: FETCH cur_child_categories into l_cat_flag;
1315:
1316: IF cur_child_categories%FOUND then
1317: CLOSE cur_child_categories;
1318: fnd_message.set_name ( 'OTA' ,'OTA_443273_CTU_CHLD_CAT_EXISTS');
1319: fnd_message.raise_error;
1320: ELSE
1321: CLOSE cur_child_categories;
1322: END IF;

Line 1319: fnd_message.raise_error;

1315:
1316: IF cur_child_categories%FOUND then
1317: CLOSE cur_child_categories;
1318: fnd_message.set_name ( 'OTA' ,'OTA_443273_CTU_CHLD_CAT_EXISTS');
1319: fnd_message.raise_error;
1320: ELSE
1321: CLOSE cur_child_categories;
1322: END IF;
1323:

Line 1375: fnd_message.set_name ( 'OTA' ,'OTA_443272_CTU_ACT_EXISTS');

1371: FETCH cur_cat_activities into l_act_flag;
1372:
1373: IF cur_cat_activities%FOUND then
1374: CLOSE cur_cat_activities;
1375: fnd_message.set_name ( 'OTA' ,'OTA_443272_CTU_ACT_EXISTS');
1376: fnd_message.raise_error;
1377: ELSE
1378: CLOSE cur_cat_activities;
1379: END IF;

Line 1376: fnd_message.raise_error;

1372:
1373: IF cur_cat_activities%FOUND then
1374: CLOSE cur_cat_activities;
1375: fnd_message.set_name ( 'OTA' ,'OTA_443272_CTU_ACT_EXISTS');
1376: fnd_message.raise_error;
1377: ELSE
1378: CLOSE cur_cat_activities;
1379: END IF;
1380:

Line 1426: fnd_message.set_name ( 'OTA' ,'OTA_443271_CTU_OFF_EXISTS');

1422: FETCH cur_dm_offerings into l_off_flag;
1423:
1424: IF cur_dm_offerings%FOUND then
1425: CLOSE cur_dm_offerings;
1426: fnd_message.set_name ( 'OTA' ,'OTA_443271_CTU_OFF_EXISTS');
1427: fnd_message.raise_error;
1428: ELSE
1429: CLOSE cur_dm_offerings;
1430: END IF;

Line 1427: fnd_message.raise_error;

1423:
1424: IF cur_dm_offerings%FOUND then
1425: CLOSE cur_dm_offerings;
1426: fnd_message.set_name ( 'OTA' ,'OTA_443271_CTU_OFF_EXISTS');
1427: fnd_message.raise_error;
1428: ELSE
1429: CLOSE cur_dm_offerings;
1430: END IF;
1431:

Line 1457: fnd_message.set_name ( 'OTA' ,'OTA_443268_CTU_ONLINE_FLAG');

1453: --
1454:
1455: IF p_type = 'DM' THEN
1456: IF p_online_flag is null THEN
1457: fnd_message.set_name ( 'OTA' ,'OTA_443268_CTU_ONLINE_FLAG');
1458: fnd_message.raise_error;
1459: END IF;
1460: END IF;
1461:

Line 1458: fnd_message.raise_error;

1454:
1455: IF p_type = 'DM' THEN
1456: IF p_online_flag is null THEN
1457: fnd_message.set_name ( 'OTA' ,'OTA_443268_CTU_ONLINE_FLAG');
1458: fnd_message.raise_error;
1459: END IF;
1460: END IF;
1461:
1462: --

Line 1496: fnd_message.set_name ( 'OTA' ,'OTA_443268_CTU_ONLINE_FLAG');

1492: --
1493:
1494: IF p_type = 'DM' THEN
1495: IF p_synchronous_flag is null THEN
1496: fnd_message.set_name ( 'OTA' ,'OTA_443268_CTU_ONLINE_FLAG');
1497: fnd_message.raise_error;
1498: END IF;
1499: END IF;
1500:

Line 1497: fnd_message.raise_error;

1493:
1494: IF p_type = 'DM' THEN
1495: IF p_synchronous_flag is null THEN
1496: fnd_message.set_name ( 'OTA' ,'OTA_443268_CTU_ONLINE_FLAG');
1497: fnd_message.raise_error;
1498: END IF;
1499: END IF;
1500:
1501: --

Line 1539: fnd_message.set_name ( 'OTA' ,'OTA_13312_GEN_DATE_ORDER');

1535: --
1536: if (p_start_date
1537: > nvl (p_end_date, to_date ('31-12-4712', 'DD-MM-YYYY'))) then
1538:
1539: fnd_message.set_name ( 'OTA' ,'OTA_13312_GEN_DATE_ORDER');
1540: fnd_message.raise_error;
1541:
1542: end if;
1543: --

Line 1540: fnd_message.raise_error;

1536: if (p_start_date
1537: > nvl (p_end_date, to_date ('31-12-4712', 'DD-MM-YYYY'))) then
1538:
1539: fnd_message.set_name ( 'OTA' ,'OTA_13312_GEN_DATE_ORDER');
1540: fnd_message.raise_error;
1541:
1542: end if;
1543: --
1544: hr_utility.set_location (' leaving:' || l_proc, 10);

Line 1591: fnd_message.set_name ( 'OTA' ,'OTA_443350_CTU_LP_EXISTS');

1587: FETCH cur_cat_learning_paths into l_lp_flag;
1588:
1589: IF cur_cat_learning_paths%FOUND then
1590: CLOSE cur_cat_learning_paths;
1591: fnd_message.set_name ( 'OTA' ,'OTA_443350_CTU_LP_EXISTS');
1592: fnd_message.raise_error;
1593: ELSE
1594: CLOSE cur_cat_learning_paths;
1595: END IF;

Line 1592: fnd_message.raise_error;

1588:
1589: IF cur_cat_learning_paths%FOUND then
1590: CLOSE cur_cat_learning_paths;
1591: fnd_message.set_name ( 'OTA' ,'OTA_443350_CTU_LP_EXISTS');
1592: fnd_message.raise_error;
1593: ELSE
1594: CLOSE cur_cat_learning_paths;
1595: END IF;
1596:

Line 1649: fnd_message.set_name ( 'OTA','OTA_443097_CAT_TP_EXISTS');

1645: FETCH cur_act_def_org_tp into l_act_def_name;
1646:
1647: IF cur_act_def_org_tp%FOUND then
1648: CLOSE cur_act_def_org_tp;
1649: fnd_message.set_name ( 'OTA','OTA_443097_CAT_TP_EXISTS');
1650: fnd_message.set_token('ACT_DEF_NAME', l_act_def_name);
1651: fnd_message.raise_error;
1652: ELSE
1653: CLOSE cur_act_def_org_tp;

Line 1650: fnd_message.set_token('ACT_DEF_NAME', l_act_def_name);

1646:
1647: IF cur_act_def_org_tp%FOUND then
1648: CLOSE cur_act_def_org_tp;
1649: fnd_message.set_name ( 'OTA','OTA_443097_CAT_TP_EXISTS');
1650: fnd_message.set_token('ACT_DEF_NAME', l_act_def_name);
1651: fnd_message.raise_error;
1652: ELSE
1653: CLOSE cur_act_def_org_tp;
1654: END IF;

Line 1651: fnd_message.raise_error;

1647: IF cur_act_def_org_tp%FOUND then
1648: CLOSE cur_act_def_org_tp;
1649: fnd_message.set_name ( 'OTA','OTA_443097_CAT_TP_EXISTS');
1650: fnd_message.set_token('ACT_DEF_NAME', l_act_def_name);
1651: fnd_message.raise_error;
1652: ELSE
1653: CLOSE cur_act_def_org_tp;
1654: END IF;
1655: --