DBA Data[Home] [Help]

APPS.AME_ATU_BUS dependencies on HR_UTILITY

Line 68: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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

Line 71: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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

Line 162: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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;

Line 165: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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: -- ---------------------------------------------------------------------------

Line 232: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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:

Line 235: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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: --

Line 266: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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;

Line 269: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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:

Line 322: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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;

Line 325: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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:

Line 389: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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;

Line 392: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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: -- ---------------------------------------------------------------------------

Line 450: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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;

Line 453: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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: -- |------------------------------------------------|

Line 520: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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;

Line 523: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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: -- ---------------------------------------------------------------------------

Line 568: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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;

Line 571: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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: -- ---------------------------------------------------------------------------

Line 665: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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;

Line 668: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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: -- ---------------------------------------------------------------------------

Line 841: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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;

Line 844: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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;

Line 892: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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;

Line 895: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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: -- ---------------------------------------------------------------------------

Line 938: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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;

Line 941: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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: -- ---------------------------------------------------------------------------

Line 986: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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;

Line 989: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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

Line 1185: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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;

Line 1188: hr_utility.set_location(' Leaving:'|| l_proc, 60);

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: -- ----------------------------------------------------------------------------

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

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:

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

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

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

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

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

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

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

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

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

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;