64: exception
65: when app_exception.application_exception then
66: if hr_multi_message.exception_add
67: (p_associated_column1 => 'QUERY_STRING') then
68: hr_utility.set_location(' Leaving:'|| l_proc, 50);
69: raise;
70: end if;
71: hr_utility.set_location(' Leaving:'|| l_proc, 60);
72: return(null);
67: (p_associated_column1 => 'QUERY_STRING') then
68: hr_utility.set_location(' Leaving:'|| l_proc, 50);
69: raise;
70: end if;
71: hr_utility.set_location(' Leaving:'|| l_proc, 60);
72: return(null);
73: end inputToCanonStaticCurUsage;
74: -- ---------------------------------------------------------------------
75: -- |---------------------------< isNumber >----------------------------|
158: exception
159: when app_exception.application_exception then
160: if hr_multi_message.exception_add
161: (p_associated_column1 => 'APPLICATION_ID') then
162: hr_utility.set_location(' Leaving:'|| l_proc, 50);
163: raise;
164: end if;
165: hr_utility.set_location(' Leaving:'|| l_proc, 60);
166: end chk_attribute_item_class;
161: (p_associated_column1 => 'APPLICATION_ID') then
162: hr_utility.set_location(' Leaving:'|| l_proc, 50);
163: raise;
164: end if;
165: hr_utility.set_location(' Leaving:'|| l_proc, 60);
166: end chk_attribute_item_class;
167: --
168: --
169: -- ---------------------------------------------------------------------------
228: exception
229: when app_exception.application_exception then
230: if hr_multi_message.exception_add
231: (p_associated_column1 => 'APPLICATION_ID') then
232: hr_utility.set_location(' Leaving:'|| l_proc, 50);
233: raise;
234: end if;
235: hr_utility.set_location(' Leaving:'|| l_proc, 60);
236:
231: (p_associated_column1 => 'APPLICATION_ID') then
232: hr_utility.set_location(' Leaving:'|| l_proc, 50);
233: raise;
234: end if;
235: hr_utility.set_location(' Leaving:'|| l_proc, 60);
236:
237: end chk_attribute_approver_type;
238: --
239: --
262: exception
263: when app_exception.application_exception then
264: if hr_multi_message.exception_add
265: (p_associated_column1 => 'VALUE_SET_ID') then
266: hr_utility.set_location(' Leaving:'|| l_proc, 50);
267: raise;
268: end if;
269: hr_utility.set_location(' Leaving:'|| l_proc, 60);
270: end chk_value_set_id;
265: (p_associated_column1 => 'VALUE_SET_ID') then
266: hr_utility.set_location(' Leaving:'|| l_proc, 50);
267: raise;
268: end if;
269: hr_utility.set_location(' Leaving:'|| l_proc, 60);
270: end chk_value_set_id;
271:
272: --
273:
318: exception
319: when app_exception.application_exception then
320: if hr_multi_message.exception_add
321: (p_associated_column1 => 'ATTRIBUTE_ID') then
322: hr_utility.set_location(' Leaving:'|| l_proc, 50);
323: raise;
324: end if;
325: hr_utility.set_location(' Leaving:'|| l_proc, 60);
326: end chk_attr_type_val_set_id_comb;
321: (p_associated_column1 => 'ATTRIBUTE_ID') then
322: hr_utility.set_location(' Leaving:'|| l_proc, 50);
323: raise;
324: end if;
325: hr_utility.set_location(' Leaving:'|| l_proc, 60);
326: end chk_attr_type_val_set_id_comb;
327: --
328: --
329:
385: exception
386: when app_exception.application_exception then
387: if hr_multi_message.exception_add
388: (p_associated_column1 => 'ATTRIBUTE_ID') then
389: hr_utility.set_location(' Leaving:'|| l_proc, 50);
390: raise;
391: end if;
392: hr_utility.set_location(' Leaving:'|| l_proc, 60);
393: end chk_attribute_id;
388: (p_associated_column1 => 'ATTRIBUTE_ID') then
389: hr_utility.set_location(' Leaving:'|| l_proc, 50);
390: raise;
391: end if;
392: hr_utility.set_location(' Leaving:'|| l_proc, 60);
393: end chk_attribute_id;
394: -- ---------------------------------------------------------------------------
395: -- |----------------------
396: -- ---------------------------------------------------------------------------
446: exception
447: when app_exception.application_exception then
448: if hr_multi_message.exception_add
449: (p_associated_column1 => 'APPLICATION_ID') then
450: hr_utility.set_location(' Leaving:'|| l_proc, 50);
451: raise;
452: end if;
453: hr_utility.set_location(' Leaving:'|| l_proc, 60);
454: end chk_application_id;
449: (p_associated_column1 => 'APPLICATION_ID') then
450: hr_utility.set_location(' Leaving:'|| l_proc, 50);
451: raise;
452: end if;
453: hr_utility.set_location(' Leaving:'|| l_proc, 60);
454: end chk_application_id;
455: --
456: -- ---------------------------------------------------------------------------
457: -- |----------------------
516: exception
517: when app_exception.application_exception then
518: if hr_multi_message.exception_add
519: (p_associated_column1 => 'APPLICATION_ID') then
520: hr_utility.set_location(' Leaving:'|| l_proc, 50);
521: raise;
522: end if;
523: hr_utility.set_location(' Leaving:'|| l_proc, 60);
524: end chk_primary_key;
519: (p_associated_column1 => 'APPLICATION_ID') then
520: hr_utility.set_location(' Leaving:'|| l_proc, 50);
521: raise;
522: end if;
523: hr_utility.set_location(' Leaving:'|| l_proc, 60);
524: end chk_primary_key;
525: -- ---------------------------------------------------------------------------
526: -- |----------------------
527: -- ---------------------------------------------------------------------------
564: exception
565: when app_exception.application_exception then
566: if hr_multi_message.exception_add
567: (p_associated_column1 => 'IS_STATIC') then
568: hr_utility.set_location(' Leaving:'|| l_proc, 50);
569: raise;
570: end if;
571: hr_utility.set_location(' Leaving:'|| l_proc, 60);
572: end chk_is_static;
567: (p_associated_column1 => 'IS_STATIC') then
568: hr_utility.set_location(' Leaving:'|| l_proc, 50);
569: raise;
570: end if;
571: hr_utility.set_location(' Leaving:'|| l_proc, 60);
572: end chk_is_static;
573: -- ---------------------------------------------------------------------------
574: -- |----------------------
575: -- ---------------------------------------------------------------------------
661: exception
662: when app_exception.application_exception then
663: if hr_multi_message.exception_add
664: (p_associated_column1 => 'QUERY_STRING_IS_STATIC') then
665: hr_utility.set_location(' Leaving:'|| l_proc, 50);
666: raise;
667: end if;
668: hr_utility.set_location(' Leaving:'|| l_proc, 60);
669: end chk_qry_string_is_static_comb;
664: (p_associated_column1 => 'QUERY_STRING_IS_STATIC') then
665: hr_utility.set_location(' Leaving:'|| l_proc, 50);
666: raise;
667: end if;
668: hr_utility.set_location(' Leaving:'|| l_proc, 60);
669: end chk_qry_string_is_static_comb;
670: -- ---------------------------------------------------------------------------
671: -- |----------------------< chk_qry_str_static_attr_comb >--------------------|
672: -- ---------------------------------------------------------------------------
837: exception
838: when app_exception.application_exception then
839: if hr_multi_message.exception_add
840: (p_associated_column1 => 'chk_qry_str_static_attr_comb') then
841: hr_utility.set_location(' Leaving:'|| l_proc, 50);
842: raise;
843: end if;
844: hr_utility.set_location(' Leaving:'|| l_proc, 60);
845: end;
840: (p_associated_column1 => 'chk_qry_str_static_attr_comb') then
841: hr_utility.set_location(' Leaving:'|| l_proc, 50);
842: raise;
843: end if;
844: hr_utility.set_location(' Leaving:'|| l_proc, 60);
845: end;
846: end if;
847: else /* dynamic usage (actual query string) */
848: l_columns := 1;
888: exception
889: when app_exception.application_exception then
890: if hr_multi_message.exception_add
891: (p_associated_column1 => 'chk_qry_str_static_attr_comb') then
892: hr_utility.set_location(' Leaving:'|| l_proc, 50);
893: raise;
894: end if;
895: hr_utility.set_location(' Leaving:'|| l_proc, 60);
896: end chk_qry_str_static_attr_comb;
891: (p_associated_column1 => 'chk_qry_str_static_attr_comb') then
892: hr_utility.set_location(' Leaving:'|| l_proc, 50);
893: raise;
894: end if;
895: hr_utility.set_location(' Leaving:'|| l_proc, 60);
896: end chk_qry_str_static_attr_comb;
897: -- ---------------------------------------------------------------------------
898: -- |----------------------
899: -- ---------------------------------------------------------------------------
934: exception
935: when app_exception.application_exception then
936: if hr_multi_message.exception_add
937: (p_associated_column1 => 'USE_COUNT') then
938: hr_utility.set_location(' Leaving:'|| l_proc, 50);
939: raise;
940: end if;
941: hr_utility.set_location(' Leaving:'|| l_proc, 60);
942: end chk_use_count;
937: (p_associated_column1 => 'USE_COUNT') then
938: hr_utility.set_location(' Leaving:'|| l_proc, 50);
939: raise;
940: end if;
941: hr_utility.set_location(' Leaving:'|| l_proc, 60);
942: end chk_use_count;
943: -- ---------------------------------------------------------------------------
944: -- |----------------------
945: -- ---------------------------------------------------------------------------
982: exception
983: when app_exception.application_exception then
984: if hr_multi_message.exception_add
985: (p_associated_column1 => 'USER_EDITABLE') then
986: hr_utility.set_location(' Leaving:'|| l_proc, 50);
987: raise;
988: end if;
989: hr_utility.set_location(' Leaving:'|| l_proc, 60);
990: end chk_user_editable;
985: (p_associated_column1 => 'USER_EDITABLE') then
986: hr_utility.set_location(' Leaving:'|| l_proc, 50);
987: raise;
988: end if;
989: hr_utility.set_location(' Leaving:'|| l_proc, 60);
990: end chk_user_editable;
991: --
992: -- ----------------------------------------------------------------------------
993: -- |-----------------------< chk_non_updateable_args >------------------------|
1181: exception
1182: when app_exception.application_exception then
1183: if hr_multi_message.exception_add
1184: (p_associated_column1 => 'ATTRIBUTE_ID') then
1185: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1186: raise;
1187: end if;
1188: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1189: end chk_delete;
1184: (p_associated_column1 => 'ATTRIBUTE_ID') then
1185: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1186: raise;
1187: end if;
1188: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1189: end chk_delete;
1190: -- ----------------------------------------------------------------------------
1191: -- |--------------------------< dt_update_validate >--------------------------|
1192: -- ----------------------------------------------------------------------------
1375: --
1376: l_proc varchar2(72) := g_package||'insert_validate';
1377: --
1378: Begin
1379: hr_utility.set_location('Entering:'||l_proc, 5);
1380:
1381: chk_attribute_id (p_attribute_id => p_rec.attribute_id,
1382: p_effective_date => p_effective_date);
1383:
1412: chk_user_editable (p_user_editable => p_rec.user_editable);
1413:
1414: chk_use_count (p_use_count => p_rec.use_count);
1415:
1416: hr_utility.set_location(' Leaving:'||l_proc, 10);
1417: End insert_validate;
1418: --
1419: -- ----------------------------------------------------------------------------
1420: -- |---------------------------< update_validate >----------------------------|
1429: --
1430: l_proc varchar2(72) := g_package||'update_validate';
1431: --
1432: Begin
1433: hr_utility.set_location('Entering:'||l_proc, 5);
1434: --
1435: -- Validate Dependent Attributes
1436: --
1437: -- Call the datetrack update integrity operation
1465: p_effective_date => p_effective_date);
1466:
1467:
1468: --
1469: hr_utility.set_location(' Leaving:'||l_proc, 10);
1470: End update_validate;
1471: --
1472: -- ----------------------------------------------------------------------------
1473: -- |---------------------------< delete_validate >----------------------------|
1482: --
1483: l_proc varchar2(72) := g_package||'delete_validate';
1484: --
1485: Begin
1486: hr_utility.set_location('Entering:'||l_proc, 5);
1487: --
1488: -- Call all supporting business operations
1489: --
1490: dt_delete_validate
1499: p_application_id => p_rec.application_id,
1500: p_object_version_number => p_rec.object_version_number,
1501: p_effective_date => p_effective_date);
1502: --
1503: hr_utility.set_location(' Leaving:'||l_proc, 10);
1504: End delete_validate;
1505: --
1506: end ame_atu_bus;