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 HR_UTILITY

Line 43: hr_utility.set_location('Entering:'|| l_proc, 10);

39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

Line 83: hr_utility.set_location(' Leaving:'|| l_proc, 20);

79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------

Line 112: hr_utility.set_location('Entering:'|| l_proc, 10);

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

Line 130: hr_utility.set_location(l_proc, 20);

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := ota_ctu_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

Line 147: hr_utility.set_location(l_proc,30);

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
150: -- available for the next call to this function.
151: --

Line 156: hr_utility.set_location(' Leaving:'|| l_proc, 40);

152: close csr_leg_code;
153: ota_ctu_bus.g_category_usage_id := p_category_usage_id;
154: ota_ctu_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

Line 195: hr_utility.set_location('Entering:'||l_proc,10);

191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193: --
194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.category_usage_id is not null) and (
198: nvl(ota_ctu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

Line 294: hr_utility.set_location(' Leaving:'||l_proc,20);

290: ,p_attribute20_value => p_rec.attribute20
291: );
292: end if;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc,20);
295: end chk_df;
296: --
297: -- ----------------------------------------------------------------------------
298: -- ----------------------< Chk_Parent_Category_Dates >------------------------|

Line 328: hr_utility.set_location(' Entering:' || l_proc,10);

324: l_par_cat_start_date date;
325: l_par_cat_end_date date;
326:
327: Begin
328: hr_utility.set_location(' Entering:' || l_proc,10);
329: --
330: IF hr_multi_message.no_exclusive_error
331: (p_check_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
332: ,p_check_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'

Line 355: hr_utility.set_location(' Leaving:' || l_proc,10);

351: CLOSE cur_par_cat_start_end_date;
352: End IF;
353: End IF;
354: --
355: hr_utility.set_location(' Leaving:' || l_proc,10);
356: Exception
357: when app_exception.application_exception then
358: IF hr_multi_message.exception_add
359: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'

Line 362: hr_utility.set_location(' Leaving:'|| l_proc,20);

358: IF hr_multi_message.exception_add
359: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
360: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
361: ) THEN
362: hr_utility.set_location(' Leaving:'|| l_proc,20);
363: raise;
364: END IF;
365:
366: hr_utility.set_location(' Leaving:'|| l_proc,30);

Line 366: hr_utility.set_location(' Leaving:'|| l_proc,30);

362: hr_utility.set_location(' Leaving:'|| l_proc,20);
363: raise;
364: END IF;
365:
366: hr_utility.set_location(' Leaving:'|| l_proc,30);
367: --
368: End Chk_Parent_Category_Dates;
369: --
370: -- ----------------------------------------------------------------------------

Line 401: hr_utility.set_location(' Entering:' || l_proc,10);

397: l_obj_cat varchar2(80);
398: l_obj_child_cat varchar2(80);
399:
400: Begin
401: hr_utility.set_location(' Entering:' || l_proc,10);
402: --
403: OPEN cur_child_cat_dates;
404: FETCH cur_child_cat_dates into v_start_date,
405: v_end_date;

Line 437: hr_utility.set_location(' Leaving:' || l_proc,10);

433: End loop;
434: --
435: Close cur_child_cat_dates;
436: --
437: hr_utility.set_location(' Leaving:' || l_proc,10);
438: Exception
439: when app_exception.application_exception then
440: IF hr_multi_message.exception_add
441: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'

Line 444: hr_utility.set_location(' Leaving:'|| l_proc,20);

440: IF hr_multi_message.exception_add
441: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
442: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
443: ) THEN
444: hr_utility.set_location(' Leaving:'|| l_proc,20);
445: raise;
446: END IF;
447:
448: hr_utility.set_location(' Leaving:'|| l_proc,30);

Line 448: hr_utility.set_location(' Leaving:'|| l_proc,30);

444: hr_utility.set_location(' Leaving:'|| l_proc,20);
445: raise;
446: END IF;
447:
448: hr_utility.set_location(' Leaving:'|| l_proc,30);
449: --
450: End Chk_Child_Category_Dates;
451: --
452: -- ----------------------------------------------------------------------------

Line 486: hr_utility.set_location(' Entering:' || l_proc,10);

482: l_obj_cat varchar2(80);
483: l_obj_act varchar2(80);
484:
485: Begin
486: hr_utility.set_location(' Entering:' || l_proc,10);
487: --
488: OPEN cur_act_dates;
489: FETCH cur_act_dates into v_start_date,
490: v_end_date;

Line 530: hr_utility.set_location(' Leaving:' || l_proc,10);

526: --
527: Close cur_act_dates;
528:
529:
530: hr_utility.set_location(' Leaving:' || l_proc,10);
531: Exception
532: when app_exception.application_exception then
533: IF hr_multi_message.exception_add
534: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'

Line 537: hr_utility.set_location(' Leaving:'|| l_proc,20);

533: IF hr_multi_message.exception_add
534: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
535: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
536: ) THEN
537: hr_utility.set_location(' Leaving:'|| l_proc,20);
538: raise;
539: END IF;
540:
541: hr_utility.set_location(' Leaving:'|| l_proc,30);

Line 541: hr_utility.set_location(' Leaving:'|| l_proc,30);

537: hr_utility.set_location(' Leaving:'|| l_proc,20);
538: raise;
539: END IF;
540:
541: hr_utility.set_location(' Leaving:'|| l_proc,30);
542: --
543: End Chk_Act_Start_End_Date;
544: --
545: -- ----------------------------------------------------------------------------

Line 579: hr_utility.set_location(' Entering:' || l_proc,10);

575: l_obj_cat varchar2(80);
576: l_obj_lp varchar2(80);
577:
578: Begin
579: hr_utility.set_location(' Entering:' || l_proc,10);
580: --
581: OPEN cur_lp_dates;
582: FETCH cur_lp_dates into v_start_date,
583: v_end_date;

Line 623: hr_utility.set_location(' Leaving:' || l_proc,10);

619: --
620: Close cur_lp_dates;
621:
622:
623: hr_utility.set_location(' Leaving:' || l_proc,10);
624: Exception
625: when app_exception.application_exception then
626: IF hr_multi_message.exception_add
627: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'

Line 630: hr_utility.set_location(' Leaving:'|| l_proc,20);

626: IF hr_multi_message.exception_add
627: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
628: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
629: ) THEN
630: hr_utility.set_location(' Leaving:'|| l_proc,20);
631: raise;
632: END IF;
633:
634: hr_utility.set_location(' Leaving:'|| l_proc,30);

Line 634: hr_utility.set_location(' Leaving:'|| l_proc,30);

630: hr_utility.set_location(' Leaving:'|| l_proc,20);
631: raise;
632: END IF;
633:
634: hr_utility.set_location(' Leaving:'|| l_proc,30);
635: --
636: End Chk_lp_Start_End_Date;
637: --
638: -- ----------------------------------------------------------------------------

Line 664: hr_utility.set_location(' Entering:' || l_proc,10);

660: l_proc varchar2(72) := g_package ||'Chk_Root_Cat';
661: l_root_cat_flag varchar2(10);
662:
663: Begin
664: hr_utility.set_location(' Entering:' || l_proc,10);
665: --
666:
667: OPEN cur_root_category;
668: FETCH cur_root_category into l_root_cat_flag;

Line 679: hr_utility.set_location(' Leaving:' || l_proc,10);

675: CLOSE cur_root_category;
676: END IF;
677:
678: --
679: hr_utility.set_location(' Leaving:' || l_proc,10);
680: Exception
681: when app_exception.application_exception then
682: IF hr_multi_message.exception_add
683: (p_associated_column1 => 'OTA_CATEGORY_USAGES.BUSINESS_GROUP_ID'

Line 685: hr_utility.set_location(' Leaving:'|| l_proc,20);

681: when app_exception.application_exception then
682: IF hr_multi_message.exception_add
683: (p_associated_column1 => 'OTA_CATEGORY_USAGES.BUSINESS_GROUP_ID'
684: ) THEN
685: hr_utility.set_location(' Leaving:'|| l_proc,20);
686: raise;
687: END IF;
688:
689: hr_utility.set_location(' Leaving:'|| l_proc,30);

Line 689: hr_utility.set_location(' Leaving:'|| l_proc,30);

685: hr_utility.set_location(' Leaving:'|| l_proc,20);
686: raise;
687: END IF;
688:
689: hr_utility.set_location(' Leaving:'|| l_proc,30);
690: --
691: End Chk_Root_Cat;
692: --
693: -- ----------------------------------------------------------------------------

Line 723: hr_utility.set_location(' Entering:' || l_proc,10);

719: l_obj_dm VARCHAR2(80);
720: l_obj_off VARCHAR2(80);
721:
722: Begin
723: hr_utility.set_location(' Entering:' || l_proc,10);
724: --
725:
726: OPEN cur_off_dates;
727: FETCH cur_off_dates into v_start_date,

Line 767: hr_utility.set_location(' Leaving:' || l_proc,10);

763: --
764: Close cur_off_dates;
765:
766:
767: hr_utility.set_location(' Leaving:' || l_proc,10);
768: Exception
769: when app_exception.application_exception then
770: IF hr_multi_message.exception_add
771: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'

Line 774: hr_utility.set_location(' Leaving:'|| l_proc,20);

770: IF hr_multi_message.exception_add
771: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
772: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
773: ) THEN
774: hr_utility.set_location(' Leaving:'|| l_proc,20);
775: raise;
776: END IF;
777:
778: hr_utility.set_location(' Leaving:'|| l_proc,30);

Line 778: hr_utility.set_location(' Leaving:'|| l_proc,30);

774: hr_utility.set_location(' Leaving:'|| l_proc,20);
775: raise;
776: END IF;
777:
778: hr_utility.set_location(' Leaving:'|| l_proc,30);
779: --
780: End Chk_Off_Start_End_Date;
781: --
782: -- ----------------------------------------------------------------------------

Line 806: hr_utility.set_location(' Entering:' || l_proc,10);

802: l_proc varchar2(72) := g_package ||'Chk_Sync_Online_Flag';
803: l_off_flag varchar2(10);
804:
805: Begin
806: hr_utility.set_location(' Entering:' || l_proc,10);
807: --
808:
809: OPEN cur_dm_offerings;
810: FETCH cur_dm_offerings into l_off_flag;

Line 821: hr_utility.set_location(' Leaving:' || l_proc,10);

817: CLOSE cur_dm_offerings;
818: END IF;
819:
820: --
821: hr_utility.set_location(' Leaving:' || l_proc,10);
822: --
823: Exception
824: when app_exception.application_exception then
825: IF hr_multi_message.exception_add

Line 829: hr_utility.set_location(' Leaving:'|| l_proc,20);

825: IF hr_multi_message.exception_add
826: (p_associated_column1 => 'OTA_CATEGORY_USAGES.ONLINE_FLAG'
827: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.SYNCHRONOUS_FLAG'
828: ) THEN
829: hr_utility.set_location(' Leaving:'|| l_proc,20);
830: raise;
831: END IF;
832:
833: hr_utility.set_location(' Leaving:'|| l_proc,30);

Line 833: hr_utility.set_location(' Leaving:'|| l_proc,30);

829: hr_utility.set_location(' Leaving:'|| l_proc,20);
830: raise;
831: END IF;
832:
833: hr_utility.set_location(' Leaving:'|| l_proc,30);
834: --
835: End Chk_Sync_Online_Flag;
836: --
837: -- ----------------------------------------------------------------------------

Line 928: hr_utility.set_location('Entering:'|| l_proc, 10);

924: l_proc varchar2(72) := g_package||'Chk_unique_category';
925: --
926: Begin
927: --
928: hr_utility.set_location('Entering:'|| l_proc, 10);
929: --
930: open csr_cat_name;
931: fetch csr_cat_name into l_dup_cat_type;
932: --

Line 943: hr_utility.set_location(l_proc,20);

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;
946: hr_utility.set_location(l_proc,30);
947: --

Line 946: hr_utility.set_location(l_proc,30);

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
949: -- available for the next call to this function.
950: --

Line 953: hr_utility.set_location(' Leaving:'|| l_proc, 40);

949: -- available for the next call to this function.
950: --
951: close csr_cat_name;
952:
953: hr_utility.set_location(' Leaving:'|| l_proc, 40);
954: --
955: end Chk_unique_category;
956: --
957: -- ----------------------------------------------------------------------------

Line 968: hr_utility.set_location('Entering:'||l_proc, 5);

964: --
965: l_proc varchar2(72) := g_package||'insert_validate';
966: --
967: Begin
968: hr_utility.set_location('Entering:'||l_proc, 5);
969: --
970: -- Call all supporting business operations
971: --
972: hr_api.validate_bus_grp_id

Line 1037: hr_utility.set_location(' Leaving:'||l_proc, 10);

1033: ota_ctu_bus.chk_df(p_rec);
1034: end if;
1035:
1036: --
1037: hr_utility.set_location(' Leaving:'||l_proc, 10);
1038: End insert_validate;
1039: --
1040: -- ----------------------------------------------------------------------------
1041: -- |---------------------------< update_validate >----------------------------|

Line 1051: hr_utility.set_location('Entering:'||l_proc, 5);

1047: --
1048: l_proc varchar2(72) := g_package||'update_validate';
1049: --
1050: Begin
1051: hr_utility.set_location('Entering:'||l_proc, 5);
1052: --
1053: -- Call all supporting business operations
1054: --
1055: hr_api.validate_bus_grp_id

Line 1154: hr_utility.set_location(' Leaving:'||l_proc, 10);

1150: ota_ctu_bus.chk_df(p_rec);
1151: end if;
1152:
1153: --
1154: hr_utility.set_location(' Leaving:'||l_proc, 10);
1155: End update_validate;
1156: --
1157: -- ----------------------------------------------------------------------------
1158: -- |---------------------------< delete_validate >----------------------------|

Line 1176: hr_utility.set_location('Entering:'||l_proc, 5);

1172: l_proc varchar2(72) := g_package||'delete_validate';
1173: l_cat_type varchar2(30);
1174: --
1175: Begin
1176: hr_utility.set_location('Entering:'||l_proc, 5);
1177: --
1178: -- Call all supporting business operations
1179: --
1180: OPEN cur_category_type;

Line 1212: hr_utility.set_location(' Leaving:'||l_proc, 10);

1208: );
1209: --
1210: END IF;
1211: --
1212: hr_utility.set_location(' Leaving:'||l_proc, 10);
1213: End delete_validate;
1214: -- ----------------------------------------------------------------------------
1215: -- |---------------------< Chk_valid_parent_category >------------------------|
1216: -- ----------------------------------------------------------------------------

Line 1252: hr_utility.set_location('Entering:'|| l_proc, 10);

1248: l_result boolean := FALSE;
1249: --
1250: --
1251: begin
1252: hr_utility.set_location('Entering:'|| l_proc, 10);
1253: --
1254: --
1255:
1256: IF (p_category_usage_id = p_parent_cat_usage_id) THEN

Line 1273: hr_utility.set_location(' Leaving:'||l_proc, 10);

1269: CLOSE cur_parent_categories;
1270: END IF;
1271: END IF;
1272: --
1273: hr_utility.set_location(' Leaving:'||l_proc, 10);
1274: Exception
1275: when app_exception.application_exception then
1276: IF hr_multi_message.exception_add
1277: (p_associated_column1 => 'OTA_CATEGORY_USAGES_TL.CATEGORY'

Line 1279: hr_utility.set_location(' Leaving:'|| l_proc,20);

1275: when app_exception.application_exception then
1276: IF hr_multi_message.exception_add
1277: (p_associated_column1 => 'OTA_CATEGORY_USAGES_TL.CATEGORY'
1278: ) THEN
1279: hr_utility.set_location(' Leaving:'|| l_proc,20);
1280: raise;
1281: END IF;
1282: hr_utility.set_location(' Leaving:'|| l_proc,30);
1283: --

Line 1282: hr_utility.set_location(' Leaving:'|| l_proc,30);

1278: ) THEN
1279: hr_utility.set_location(' Leaving:'|| l_proc,20);
1280: raise;
1281: END IF;
1282: hr_utility.set_location(' Leaving:'|| l_proc,30);
1283: --
1284: End Chk_valid_parent_category;
1285: --
1286: -- ----------------------------------------------------------------------------

Line 1310: hr_utility.set_location(' Entering:' || l_proc,10);

1306: l_proc varchar2(72) := g_package ||'Chk_child_category';
1307: l_cat_flag varchar2(10);
1308:
1309: Begin
1310: hr_utility.set_location(' Entering:' || l_proc,10);
1311: --
1312:
1313: OPEN cur_child_categories;
1314: FETCH cur_child_categories into l_cat_flag;

Line 1325: hr_utility.set_location(' Leaving:' || l_proc,10);

1321: CLOSE cur_child_categories;
1322: END IF;
1323:
1324: --
1325: hr_utility.set_location(' Leaving:' || l_proc,10);
1326: --
1327:
1328: Exception
1329: when app_exception.application_exception then

Line 1334: hr_utility.set_location(' Leaving:'|| l_proc,20);

1330: IF hr_multi_message.exception_add
1331: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'
1332: ,p_same_associated_columns => 'Y'
1333: ) THEN
1334: hr_utility.set_location(' Leaving:'|| l_proc,20);
1335: raise;
1336: END IF;
1337:
1338: hr_utility.set_location(' Leaving:'|| l_proc,30);

Line 1338: hr_utility.set_location(' Leaving:'|| l_proc,30);

1334: hr_utility.set_location(' Leaving:'|| l_proc,20);
1335: raise;
1336: END IF;
1337:
1338: hr_utility.set_location(' Leaving:'|| l_proc,30);
1339: --
1340:
1341: End Chk_child_category;
1342: --

Line 1367: hr_utility.set_location(' Entering:' || l_proc,10);

1363: l_proc varchar2(72) := g_package ||'Chk_act_association';
1364: l_act_flag varchar2(10);
1365:
1366: Begin
1367: hr_utility.set_location(' Entering:' || l_proc,10);
1368: --
1369:
1370: OPEN cur_cat_activities;
1371: FETCH cur_cat_activities into l_act_flag;

Line 1382: hr_utility.set_location(' Leaving:' || l_proc,10);

1378: CLOSE cur_cat_activities;
1379: END IF;
1380:
1381: --
1382: hr_utility.set_location(' Leaving:' || l_proc,10);
1383: Exception
1384: when app_exception.application_exception then
1385: IF hr_multi_message.exception_add
1386: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'

Line 1389: hr_utility.set_location(' Leaving:'|| l_proc,20);

1385: IF hr_multi_message.exception_add
1386: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'
1387: ,p_same_associated_columns => 'Y'
1388: ) THEN
1389: hr_utility.set_location(' Leaving:'|| l_proc,20);
1390: raise;
1391: END IF;
1392:
1393: hr_utility.set_location(' Leaving:'|| l_proc,30);

Line 1393: hr_utility.set_location(' Leaving:'|| l_proc,30);

1389: hr_utility.set_location(' Leaving:'|| l_proc,20);
1390: raise;
1391: END IF;
1392:
1393: hr_utility.set_location(' Leaving:'|| l_proc,30);
1394: --
1395: End Chk_act_association;
1396: --
1397: -- ----------------------------------------------------------------------------

Line 1418: hr_utility.set_location(' Entering:' || l_proc,10);

1414: l_proc varchar2(72) := g_package ||'Chk_offering_association';
1415: l_off_flag varchar2(10);
1416:
1417: Begin
1418: hr_utility.set_location(' Entering:' || l_proc,10);
1419: --
1420:
1421: OPEN cur_dm_offerings;
1422: FETCH cur_dm_offerings into l_off_flag;

Line 1433: hr_utility.set_location(' Leaving:' || l_proc,10);

1429: CLOSE cur_dm_offerings;
1430: END IF;
1431:
1432: --
1433: hr_utility.set_location(' Leaving:' || l_proc,10);
1434: --
1435: End Chk_offering_association;
1436: --
1437: -- ----------------------------------------------------------------------------

Line 1452: hr_utility.set_location(' Entering:' || l_proc,10);

1448: --
1449: l_proc varchar2(72) := g_package ||'Chk_online_flag';
1450:
1451: Begin
1452: hr_utility.set_location(' Entering:' || l_proc,10);
1453: --
1454:
1455: IF p_type = 'DM' THEN
1456: IF p_online_flag is null THEN

Line 1463: hr_utility.set_location(' Leaving:' || l_proc,10);

1459: END IF;
1460: END IF;
1461:
1462: --
1463: hr_utility.set_location(' Leaving:' || l_proc,10);
1464: --
1465: Exception
1466: when app_exception.application_exception then
1467: if hr_multi_message.exception_add

Line 1470: hr_utility.set_location(' Leaving:'|| l_proc,20);

1466: when app_exception.application_exception then
1467: if hr_multi_message.exception_add
1468: (p_associated_column1 => 'OTA_CATEGORY_USAGES.ONLINE_FLAG'
1469: ) then
1470: hr_utility.set_location(' Leaving:'|| l_proc,20);
1471: raise;
1472: end if;
1473: hr_utility.set_location(' Leaving:'|| l_proc,30);
1474: End Chk_online_flag;

Line 1473: hr_utility.set_location(' Leaving:'|| l_proc,30);

1469: ) then
1470: hr_utility.set_location(' Leaving:'|| l_proc,20);
1471: raise;
1472: end if;
1473: hr_utility.set_location(' Leaving:'|| l_proc,30);
1474: End Chk_online_flag;
1475: --
1476: -- ----------------------------------------------------------------------------
1477: -- |------------------------< Chk_synchronous_flag >----------------------------|

Line 1491: hr_utility.set_location(' Entering:' || l_proc,10);

1487: --
1488: l_proc varchar2(72) := g_package ||'Chk_synchronous_flag';
1489:
1490: Begin
1491: hr_utility.set_location(' Entering:' || l_proc,10);
1492: --
1493:
1494: IF p_type = 'DM' THEN
1495: IF p_synchronous_flag is null THEN

Line 1502: hr_utility.set_location(' Leaving:' || l_proc,10);

1498: END IF;
1499: END IF;
1500:
1501: --
1502: hr_utility.set_location(' Leaving:' || l_proc,10);
1503: --
1504: Exception
1505: when app_exception.application_exception then
1506: if hr_multi_message.exception_add

Line 1509: hr_utility.set_location(' Leaving:'|| l_proc,70);

1505: when app_exception.application_exception then
1506: if hr_multi_message.exception_add
1507: (p_associated_column1 => 'OTA_CATEGORY_USAGES.SYNCHRONOUS_FLAG'
1508: ) then
1509: hr_utility.set_location(' Leaving:'|| l_proc,70);
1510: raise;
1511: end if;
1512: hr_utility.set_location(' Leaving:'|| l_proc,80);
1513: End Chk_synchronous_flag;

Line 1512: hr_utility.set_location(' Leaving:'|| l_proc,80);

1508: ) then
1509: hr_utility.set_location(' Leaving:'|| l_proc,70);
1510: raise;
1511: end if;
1512: hr_utility.set_location(' Leaving:'|| l_proc,80);
1513: End Chk_synchronous_flag;
1514: --
1515:
1516: -- ----------------------------------------------------------------------------

Line 1534: hr_utility.set_location ('entering:' || l_proc, 5);

1530: --
1531: --
1532: begin
1533: --
1534: hr_utility.set_location ('entering:' || l_proc, 5);
1535: --
1536: if (p_start_date
1537: > nvl (p_end_date, to_date ('31-12-4712', 'DD-MM-YYYY'))) then
1538:

Line 1544: hr_utility.set_location (' leaving:' || l_proc, 10);

1540: fnd_message.raise_error;
1541:
1542: end if;
1543: --
1544: hr_utility.set_location (' leaving:' || l_proc, 10);
1545: --
1546: Exception
1547: when app_exception.application_exception then
1548: IF hr_multi_message.exception_add

Line 1551: hr_utility.set_location(' Leaving:'|| l_proc,20);

1547: when app_exception.application_exception then
1548: IF hr_multi_message.exception_add
1549: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
1550: ) THEN
1551: hr_utility.set_location(' Leaving:'|| l_proc,20);
1552: raise;
1553: END IF;
1554: hr_utility.set_location(' Leaving:'|| l_proc,30);
1555: --

Line 1554: hr_utility.set_location(' Leaving:'|| l_proc,30);

1550: ) THEN
1551: hr_utility.set_location(' Leaving:'|| l_proc,20);
1552: raise;
1553: END IF;
1554: hr_utility.set_location(' Leaving:'|| l_proc,30);
1555: --
1556:
1557: End Chk_start_end_dates;
1558: --

Line 1583: hr_utility.set_location(' Entering:' || l_proc,10);

1579: l_proc varchar2(72) := g_package ||'Chk_lp_association';
1580: l_lp_flag varchar2(10);
1581:
1582: Begin
1583: hr_utility.set_location(' Entering:' || l_proc,10);
1584: --
1585:
1586: OPEN cur_cat_learning_paths;
1587: FETCH cur_cat_learning_paths into l_lp_flag;

Line 1598: hr_utility.set_location(' Leaving:' || l_proc,10);

1594: CLOSE cur_cat_learning_paths;
1595: END IF;
1596:
1597: --
1598: hr_utility.set_location(' Leaving:' || l_proc,10);
1599: Exception
1600: when app_exception.application_exception then
1601: IF hr_multi_message.exception_add
1602: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'

Line 1605: hr_utility.set_location(' Leaving:'|| l_proc,20);

1601: IF hr_multi_message.exception_add
1602: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'
1603: ,p_same_associated_columns => 'Y'
1604: ) THEN
1605: hr_utility.set_location(' Leaving:'|| l_proc,20);
1606: raise;
1607: END IF;
1608:
1609: hr_utility.set_location(' Leaving:'|| l_proc,30);

Line 1609: hr_utility.set_location(' Leaving:'|| l_proc,30);

1605: hr_utility.set_location(' Leaving:'|| l_proc,20);
1606: raise;
1607: END IF;
1608:
1609: hr_utility.set_location(' Leaving:'|| l_proc,30);
1610: --
1611: End Chk_lp_association;
1612: --
1613: -- ----------------------------------------------------------------------------

Line 1641: hr_utility.set_location(' Entering:' || l_proc,10);

1637: l_proc varchar2(72) := g_package ||'Chk_act_def_for_org_tp';
1638: l_act_def_name varchar2(240);
1639:
1640: Begin
1641: hr_utility.set_location(' Entering:' || l_proc,10);
1642: --
1643:
1644: OPEN cur_act_def_org_tp;
1645: FETCH cur_act_def_org_tp into l_act_def_name;

Line 1656: hr_utility.set_location(' Leaving:' || l_proc,10);

1652: ELSE
1653: CLOSE cur_act_def_org_tp;
1654: END IF;
1655: --
1656: hr_utility.set_location(' Leaving:' || l_proc,10);
1657: Exception
1658: when app_exception.application_exception then
1659: IF hr_multi_message.exception_add
1660: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'

Line 1663: hr_utility.set_location(' Leaving:'|| l_proc,20);

1659: IF hr_multi_message.exception_add
1660: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'
1661: ,p_same_associated_columns => 'Y'
1662: ) THEN
1663: hr_utility.set_location(' Leaving:'|| l_proc,20);
1664: raise;
1665: END IF;
1666:
1667: hr_utility.set_location(' Leaving:'|| l_proc,30);

Line 1667: hr_utility.set_location(' Leaving:'|| l_proc,30);

1663: hr_utility.set_location(' Leaving:'|| l_proc,20);
1664: raise;
1665: END IF;
1666:
1667: hr_utility.set_location(' Leaving:'|| l_proc,30);
1668: --
1669: End Chk_act_def_for_org_tp;
1670: --
1671: end ota_ctu_bus;