DBA Data[Home] [Help]

APPS.BEN_XDF_BUS dependencies on HR_UTILITY

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

31: l_proc varchar2(72) := g_package||'set_security_group_id';
32: --
33: begin
34: --
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Ensure that all the mandatory parameter are not null
38: --
39: hr_api.mandatory_arg_error

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

62: hr_api.set_security_group_id
63: (p_security_group_id => l_security_group_id
64: );
65: --
66: hr_utility.set_location(' Leaving:'|| l_proc, 20);
67: --
68: end set_security_group_id;
69: --
70: -- ----------------------------------------------------------------------------

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

100: l_api_updating boolean;
101: --
102: Begin
103: --
104: hr_utility.set_location('Entering:'||l_proc, 5);
105: --
106: l_api_updating := ben_xdf_shd.api_updating
107: (p_ext_dfn_id => p_ext_dfn_id,
108: p_object_version_number => p_object_version_number);

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

128: end if;
129: --
130: end if;
131: --
132: hr_utility.set_location('Leaving:'||l_proc, 10);
133: --
134: End chk_ext_dfn_id;
135: --
136: -- ----------------------------------------------------------------------------

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

172: where a.ext_file_id = p_ext_file_id;
173: --
174: Begin
175: --
176: hr_utility.set_location('Entering:'||l_proc,5);
177: --
178: l_api_updating := ben_xdf_shd.api_updating
179: (p_ext_dfn_id => p_ext_dfn_id,
180: p_object_version_number => p_object_version_number);

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

204: close c1;
205: --
206: end if;
207: --
208: hr_utility.set_location('Leaving:'||l_proc,10);
209: --
210: End chk_ext_file_id;
211: --
212: -- ----------------------------------------------------------------------------

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

248: where a.ext_crit_prfl_id = p_ext_crit_prfl_id;
249: --
250: Begin
251: --
252: hr_utility.set_location('Entering:'||l_proc,5);
253: --
254: l_api_updating := ben_xdf_shd.api_updating
255: (p_ext_dfn_id => p_ext_dfn_id,
256: p_object_version_number => p_object_version_number);

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

280: close c1;
281: --
282: end if;
283: --
284: hr_utility.set_location('Leaving:'||l_proc,10);
285: --
286: End chk_ext_crit_prfl_id;
287: --
288: -- ----------------------------------------------------------------------------

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

322: l_api_updating boolean;
323: --
324: Begin
325: --
326: hr_utility.set_location('Entering:'||l_proc, 5);
327: --
328: l_api_updating := ben_xdf_shd.api_updating
329: (p_ext_dfn_id => p_ext_dfn_id,
330: p_object_version_number => p_object_version_number);

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

383: end if;
384: end if;
385: end if;
386: --
387: hr_utility.set_location('Leaving:'||l_proc,10);
388: --
389: end chk_data_typ_cd;
390: --
391: -- ----------------------------------------------------------------------------

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

425: l_api_updating boolean;
426: --
427: Begin
428: --
429: hr_utility.set_location('Entering:'||l_proc, 5);
430: --
431: l_api_updating := ben_xdf_shd.api_updating
432: (p_ext_dfn_id => p_ext_dfn_id,
433: p_object_version_number => p_object_version_number);

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

485: end if;
486: end if;
487:
488: --
489: hr_utility.set_location('Leaving:'||l_proc,10);
490: --
491: end chk_apnd_rqst_id_flag;
492: --
493: -- ----------------------------------------------------------------------------

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

525: l_api_updating boolean;
526: --
527: Begin
528: --
529: hr_utility.set_location('Entering:'||l_proc, 5);
530: --
531: l_api_updating := ben_xdf_shd.api_updating
532: (p_ext_dfn_id => p_ext_dfn_id,
533: p_object_version_number => p_object_version_number);

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

574: --
575: end if;
576: end if;
577: --
578: hr_utility.set_location('Leaving:'||l_proc,10);
579: --
580: end chk_kickoff_wrt_prc_flag;
581: --
582: -- ----------------------------------------------------------------------------

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

614: l_api_updating boolean;
615: --
616: Begin
617: --
618: hr_utility.set_location('Entering:'||l_proc, 5);
619: --
620: l_api_updating := ben_xdf_shd.api_updating
621: (p_ext_dfn_id => p_ext_dfn_id,
622: p_object_version_number => p_object_version_number);

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

663: --
664: end if;
665: end if;
666: --
667: hr_utility.set_location('Leaving:'||l_proc,10);
668: --
669: end chk_spcl_hndl_flag;
670: --
671:

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

681: l_api_updating boolean;
682: --
683: Begin
684: --
685: hr_utility.set_location('Entering:'||l_proc, 5);
686: --
687: l_api_updating := ben_xdf_shd.api_updating
688: (p_ext_dfn_id => p_ext_dfn_id,
689: p_object_version_number => p_object_version_number);

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

730: --
731: end if;
732: end if;
733: --
734: hr_utility.set_location('Leaving:'||l_proc,10);
735: --
736: end chk_ext_global_flag;
737:
738:

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

748: l_api_updating boolean;
749: --
750: Begin
751: --
752: hr_utility.set_location('Entering:'||l_proc, 5);
753: --
754: l_api_updating := ben_xdf_shd.api_updating
755: (p_ext_dfn_id => p_ext_dfn_id,
756: p_object_version_number => p_object_version_number);

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

797: --
798: end if;
799: end if;
800: --
801: hr_utility.set_location('Leaving:'||l_proc,10);
802: --
803: end chk_cm_display_flag;
804:
805:

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

838: l_api_updating boolean;
839: --
840: Begin
841: --
842: hr_utility.set_location('Entering:'||l_proc, 5);
843: --
844: l_api_updating := ben_xdf_shd.api_updating
845: (p_ext_dfn_id => p_ext_dfn_id,
846: p_object_version_number => p_object_version_number);

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

887: --
888: end if;
889: end if;
890: --
891: hr_utility.set_location('Leaving:'||l_proc,10);
892: --
893: end chk_upd_cm_sent_dt_flag;
894: --
895: /*

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

928: l_api_updating boolean;
929: --
930: Begin
931: --
932: hr_utility.set_location('Entering:'||l_proc, 5);
933: --
934: l_api_updating := ben_xdf_shd.api_updating
935: (p_ext_dfn_id => p_ext_dfn_id,
936: p_object_version_number => p_object_version_number);

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

977: --
978: end if;
979: end if;
980: --
981: hr_utility.set_location('Leaving:'||l_proc,10);
982: --
983: end chk_use_eff_dt_for_chgs_flag;
984: --
985: */

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

1029: l_dummy date;
1030: --
1031: Begin
1032: --
1033: hr_utility.set_location('Entering:'||l_proc, 5);
1034: --
1035: l_api_updating := ben_xdf_shd.api_updating
1036: (p_ext_dfn_id => p_ext_dfn_id,
1037: p_object_version_number => p_object_version_number);

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

1162: end if;
1163: --
1164: end if;
1165: end if;
1166: hr_utility.set_location('Leaving:'||l_proc,10);
1167: --
1168: end chk_dates;
1169:
1170: --

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

1200: l_proc varchar2(72) := g_package||'chk_output_file';
1201: l_dummy char(1);
1202: --
1203: Begin
1204: hr_utility.set_location('Entering:'||l_proc, 5);
1205: --
1206: if instr(p_output_name,' ') > 0 or instr(p_drctry_name,' ') > 0 then
1207: fnd_message.set_name('BEN','BEN_91955_NAME_HAS_SPACE');
1208: fnd_message.raise_error;

Line 1211: hr_utility.set_location('Leaving:'||l_proc, 15);

1207: fnd_message.set_name('BEN','BEN_91955_NAME_HAS_SPACE');
1208: fnd_message.raise_error;
1209: end if;
1210: --
1211: hr_utility.set_location('Leaving:'||l_proc, 15);
1212: End chk_output_file;
1213:
1214:
1215:

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

1230:
1231: l_source_code xdo_templates_b.data_source_code%type ;
1232:
1233: Begin
1234: hr_utility.set_location('Entering:'||l_proc, 5);
1235: --
1236: if ( (not nvl(p_output_type,'F') in ( 'F' , 'X' ) ) and p_xdo_template_id is null )
1237: or ( p_xdo_template_id is not null and ( p_output_type in ('F' , 'X') ) )
1238: then

Line 1270: hr_utility.set_location('Leaving:'||l_proc, 15);

1266:
1267:
1268: end if ;
1269: --
1270: hr_utility.set_location('Leaving:'||l_proc, 15);
1271: End chk_xdo_template_id;
1272:
1273:
1274: --

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

1316: (business_group_id is not null and
1317: business_group_id = p_business_group_id));
1318: --
1319: Begin
1320: hr_utility.set_location('Entering:'||l_proc, 5);
1321: --
1322: if p_name is null then
1323: fnd_message.set_name('BEN','BEN_91783_NAME_NULL');
1324: fnd_message.raise_error;

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

1330: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1331: fnd_message.raise_error;
1332: end if;
1333: --
1334: hr_utility.set_location('Leaving:'||l_proc, 15);
1335: End chk_name_unique;
1336: --
1337: --
1338: -- ----------------------------------------------------------------------------

Line 1373: hr_utility.trace('Call hr_startup_data_api_support.chk_upd_del_startup_action');

1369: ELSE
1370: --
1371: -- Call procedure to check startup_action for updates and deletes.
1372: --
1373: hr_utility.trace('Call hr_startup_data_api_support.chk_upd_del_startup_action');
1374: hr_utility.trace('BG = '||to_char(p_business_group_id));
1375: hr_utility.trace('LC = '||p_legislation_code);
1376:
1377: hr_startup_data_api_support.chk_upd_del_startup_action

Line 1374: hr_utility.trace('BG = '||to_char(p_business_group_id));

1370: --
1371: -- Call procedure to check startup_action for updates and deletes.
1372: --
1373: hr_utility.trace('Call hr_startup_data_api_support.chk_upd_del_startup_action');
1374: hr_utility.trace('BG = '||to_char(p_business_group_id));
1375: hr_utility.trace('LC = '||p_legislation_code);
1376:
1377: hr_startup_data_api_support.chk_upd_del_startup_action
1378: (p_generic_allowed => TRUE

Line 1375: hr_utility.trace('LC = '||p_legislation_code);

1371: -- Call procedure to check startup_action for updates and deletes.
1372: --
1373: hr_utility.trace('Call hr_startup_data_api_support.chk_upd_del_startup_action');
1374: hr_utility.trace('BG = '||to_char(p_business_group_id));
1375: hr_utility.trace('LC = '||p_legislation_code);
1376:
1377: hr_startup_data_api_support.chk_upd_del_startup_action
1378: (p_generic_allowed => TRUE
1379: ,p_startup_allowed => TRUE

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

1402:
1403: --
1404: Begin
1405: --
1406: hr_utility.set_location('Entering:'||l_proc, 5);
1407: --
1408: open c_ext_rslt;
1409: fetch c_ext_rslt into l_dummy ;
1410: close c_ext_rslt;

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

1416:
1417: end if;
1418:
1419: --
1420: hr_utility.set_location('Leaving:'||l_proc,10);
1421: --
1422: end chk_child_recs;
1423:
1424:

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

1430: --
1431: l_proc varchar2(72) := g_package||'insert_validate';
1432: --
1433: Begin
1434: hr_utility.set_location('Entering:'||l_proc, 5);
1435: --
1436: chk_startup_action(True
1437: ,p_rec.business_group_id
1438: ,p_rec.legislation_code);

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

1546: ,p_xdo_template_id =>p_rec.xdo_template_id
1547: ,p_cm_display_flag =>p_rec.cm_display_flag
1548: );
1549:
1550: hr_utility.set_location(' Leaving:'||l_proc, 10);
1551: End insert_validate;
1552: --
1553: -- ----------------------------------------------------------------------------
1554: -- |---------------------------< update_validate >----------------------------|

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

1558: --
1559: l_proc varchar2(72) := g_package||'update_validate';
1560: --
1561: Begin
1562: hr_utility.set_location('Entering:'||l_proc, 5);
1563: --
1564:
1565: chk_startup_action(False
1566: ,p_rec.business_group_id

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

1674: ,p_xdo_template_id =>p_rec.xdo_template_id
1675: ,p_cm_display_flag =>p_rec.cm_display_flag
1676: );
1677:
1678: hr_utility.set_location(' Leaving:'||l_proc, 10);
1679: End update_validate;
1680: --
1681: -- ----------------------------------------------------------------------------
1682: -- |---------------------------< delete_validate >----------------------------|

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

1686: --
1687: l_proc varchar2(72) := g_package||'delete_validate';
1688: --
1689: Begin
1690: hr_utility.set_location('Entering:'||l_proc, 5);
1691: --
1692: chk_child_recs ( p_rec.ext_dfn_id);
1693: -- Call all supporting business operations
1694: --

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

1695: chk_startup_action(False
1696: ,ben_xdf_shd.g_old_rec.business_group_id
1697: ,ben_xdf_shd.g_old_rec.legislation_code);
1698:
1699: hr_utility.set_location(' Leaving:'||l_proc, 10);
1700: End delete_validate;
1701: --
1702: --
1703: -- ---------------------------------------------------------------------------

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

1722: l_proc varchar2(72) := g_package||'return_legislation_code';
1723: --
1724: begin
1725: --
1726: hr_utility.set_location('Entering:'|| l_proc, 10);
1727: --
1728: -- Ensure that all the mandatory parameter are not null
1729: --
1730: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1744: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

1740: close csr_leg_code;
1741: --
1742: -- The primary key is invalid therefore we must error
1743: --
1744: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1745: hr_utility.raise_error;
1746: --
1747: end if;
1748: l_legislation_code := hr_api.return_legislation_code(l_business_group_id) ;

Line 1745: hr_utility.raise_error;

1741: --
1742: -- The primary key is invalid therefore we must error
1743: --
1744: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1745: hr_utility.raise_error;
1746: --
1747: end if;
1748: l_legislation_code := hr_api.return_legislation_code(l_business_group_id) ;
1749:

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

1749:
1750: --
1751: close csr_leg_code;
1752: --
1753: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1754: --
1755: return l_legislation_code;
1756: --
1757: end return_legislation_code;