DBA Data[Home] [Help]

APPS.OTA_CTU_BUS dependencies on HR_MULTI_MESSAGE

Line 64: hr_multi_message.add

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

Line 330: IF hr_multi_message.no_exclusive_error

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'
333: ,p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
334: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'

Line 358: IF hr_multi_message.exception_add

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'
360: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
361: ) THEN
362: hr_utility.set_location(' Leaving:'|| l_proc,20);

Line 440: IF hr_multi_message.exception_add

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'
442: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
443: ) THEN
444: hr_utility.set_location(' Leaving:'|| l_proc,20);

Line 533: IF hr_multi_message.exception_add

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'
535: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
536: ) THEN
537: hr_utility.set_location(' Leaving:'|| l_proc,20);

Line 626: IF hr_multi_message.exception_add

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'
628: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
629: ) THEN
630: hr_utility.set_location(' Leaving:'|| l_proc,20);

Line 682: IF hr_multi_message.exception_add

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'
684: ) THEN
685: hr_utility.set_location(' Leaving:'|| l_proc,20);
686: raise;

Line 770: IF hr_multi_message.exception_add

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'
772: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
773: ) THEN
774: hr_utility.set_location(' Leaving:'|| l_proc,20);

Line 825: IF hr_multi_message.exception_add

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

Line 981: hr_multi_message.end_validation_set;

977: -- After validating the set of important attributes,
978: -- if Multiple Message detection is enabled and at least
979: -- one error has been found then abort further validation.
980: --
981: hr_multi_message.end_validation_set;
982: --
983: -- Validate Dependent Attributes
984: --
985: --

Line 1064: hr_multi_message.end_validation_set;

1060: -- After validating the set of important attributes,
1061: -- if Multiple Message detection is enabled and at least
1062: -- one error has been found then abort further validation.
1063: --
1064: hr_multi_message.end_validation_set;
1065: --
1066: -- Validate Dependent Attributes
1067: --
1068: -- Validating category name to be unique

Line 1276: IF hr_multi_message.exception_add

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'
1278: ) THEN
1279: hr_utility.set_location(' Leaving:'|| l_proc,20);
1280: raise;

Line 1330: IF hr_multi_message.exception_add

1326: --
1327:
1328: Exception
1329: when app_exception.application_exception then
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);

Line 1385: IF hr_multi_message.exception_add

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'
1387: ,p_same_associated_columns => 'Y'
1388: ) THEN
1389: hr_utility.set_location(' Leaving:'|| l_proc,20);

Line 1467: if hr_multi_message.exception_add

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
1468: (p_associated_column1 => 'OTA_CATEGORY_USAGES.ONLINE_FLAG'
1469: ) then
1470: hr_utility.set_location(' Leaving:'|| l_proc,20);
1471: raise;

Line 1506: if hr_multi_message.exception_add

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
1507: (p_associated_column1 => 'OTA_CATEGORY_USAGES.SYNCHRONOUS_FLAG'
1508: ) then
1509: hr_utility.set_location(' Leaving:'|| l_proc,70);
1510: raise;

Line 1548: IF hr_multi_message.exception_add

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
1549: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
1550: ) THEN
1551: hr_utility.set_location(' Leaving:'|| l_proc,20);
1552: raise;

Line 1601: IF hr_multi_message.exception_add

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'
1603: ,p_same_associated_columns => 'Y'
1604: ) THEN
1605: hr_utility.set_location(' Leaving:'|| l_proc,20);

Line 1659: IF hr_multi_message.exception_add

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'
1661: ,p_same_associated_columns => 'Y'
1662: ) THEN
1663: hr_utility.set_location(' Leaving:'|| l_proc,20);