DBA Data[Home] [Help]

APPS.BEN_PCP_BUS dependencies on HR_UTILITY

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

46: l_api_updating boolean;
47: --
48: Begin
49: --
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: l_api_updating := ben_pcp_shd.api_updating
53: (p_pl_pcp_id => p_pl_pcp_id,
54: p_object_version_number => p_object_version_number);

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

74: end if;
75: --
76: end if;
77: --
78: hr_utility.set_location('Leaving:'||l_proc, 10);
79: --
80: End chk_pl_pcp_id;
81: --
82: -- ----------------------------------------------------------------------------

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

119: ;
120:
121: --
122: Begin
123: hr_utility.set_location('Entering:'||l_proc, 5);
124: --
125: open c1;
126: fetch c1 into l_dummy;
127: if c1%found then

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

132: fnd_message.raise_error;
133: end if;
134: close c1;
135:
136: hr_utility.set_location('Leaving:'||l_proc, 15);
137: End chk_pl_pcp_rec_exists;
138: --
139: -- ----------------------------------------------------------------------------
140: -- |------< chk_pcp_strt_dt_cd >------|

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

171: l_api_updating boolean;
172: --
173: Begin
174: --
175: hr_utility.set_location('Entering:'||l_proc, 5);
176: --
177: l_api_updating := ben_pcp_shd.api_updating
178: (p_pl_pcp_id => p_pl_pcp_id,
179: p_object_version_number => p_object_version_number);

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

205: end if;
206: --
207: end if;
208: --
209: hr_utility.set_location('Leaving:'||l_proc,10);
210: --
211: end chk_pcp_strt_dt_cd;
212: --
213: --

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

247: l_api_updating boolean;
248: --
249: Begin
250: --
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: l_api_updating := ben_pcp_shd.api_updating
254: (p_pl_pcp_id => p_pl_pcp_id,
255: p_object_version_number => p_object_version_number);

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

282: end if;
283: --
284: end if;
285: --
286: hr_utility.set_location('Leaving:'||l_proc,10);
287: --
288: end chk_pcp_dsgn_cd;
289: --
290: --

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

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

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

358: end if;
359: --
360: end if;
361: --
362: hr_utility.set_location('Leaving:'||l_proc,10);
363: --
364: end chk_pcp_dpnt_dsgn_cd;
365: --
366: --

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

399: l_api_updating boolean;
400: --
401: Begin
402: --
403: hr_utility.set_location('Entering:'||l_proc, 5);
404: --
405: l_api_updating := ben_pcp_shd.api_updating
406: (p_pl_pcp_id => p_pl_pcp_id,
407: p_object_version_number => p_object_version_number);

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

429: end if;
430: --
431: end if;
432: --
433: hr_utility.set_location('Leaving:'||l_proc,10);
434: --
435: end chk_pcp_rpstry_flag;
436: --
437: --

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

470: l_api_updating boolean;
471: --
472: Begin
473: --
474: hr_utility.set_location('Entering:'||l_proc, 5);
475: --
476: l_api_updating := ben_pcp_shd.api_updating
477: (p_pl_pcp_id => p_pl_pcp_id,
478: p_object_version_number => p_object_version_number);

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

500: end if;
501: --
502: end if;
503: --
504: hr_utility.set_location('Leaving:'||l_proc,10);
505: --
506: end chk_pcp_can_keep_flag;
507: --
508: --

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

541: l_api_updating boolean;
542: --
543: Begin
544: --
545: hr_utility.set_location('Entering:'||l_proc, 5);
546: --
547: l_api_updating := ben_pcp_shd.api_updating
548: (p_pl_pcp_id => p_pl_pcp_id,
549: p_object_version_number => p_object_version_number);

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

571: end if;
572: --
573: end if;
574: --
575: hr_utility.set_location('Leaving:'||l_proc,10);
576: --
577: end chk_pcp_radius_warn_flag;
578: --
579: -- ----------------------------------------------------------------------------

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

612: l_proc varchar2(72) := g_package||'chk_pl_pcp_radius_parm';
613: --
614: Begin
615: --
616: hr_utility.set_location('Entering:'||l_proc, 5);
617: --
618: --
619: --
620: if p_pcp_rpstry_flag = 'N' then

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

626: fnd_message.raise_error;
627: end if;
628: end if;
629:
630: hr_utility.set_location('Leaving:'||l_proc, 10);
631: --
632: End chk_pl_pcp_radius_parm;
633: --
634: -- ----------------------------------------------------------------------------

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

674: effective_end_date;
675:
676: --
677: Begin
678: hr_utility.set_location('Entering:'||l_proc, 5);
679: --
680: --- when the rate is imputing chek the plan in imputing
681: open c1;
682: fetch c1 into l_svgs_pl_flag, l_imptd_incm_calc_cd, l_invk_flx_cr_pl_flag, l_invk_dcln_prtn_pl_flag;

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

688: or (l_invk_dcln_prtn_pl_flag = 'Y')) then
689: fnd_message.set_name('BEN','BEN_92562_SVG_INC');
690: fnd_message.raise_error;
691: end if;
692: hr_utility.set_location('Leaving:'||l_proc, 15);
693: End chk_pl_pcp_record;
694:
695: -- ----------------------------------------------------------------------------
696: -- |------< 4 chk_pl_pcp_cds >------|

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

723: l_proc varchar2(72) := g_package||'chk_pcp_cds';
724: --
725: Begin
726: --
727: hr_utility.set_location('Entering:'||l_proc, 5);
728: --
729: --
730: -- check if pcp_dsgn_cd, pcp_dpnt_dsgn_cd is not null
731: --

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

736: fnd_message.set_name('BEN','BEN_92563_DSGN_REQ');
737: fnd_message.raise_error;
738: end if;
739:
740: hr_utility.set_location('Leaving:'||l_proc, 10);
741: --
742: End chk_pl_pcp_cds;
743: --
744: --

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

778: from ben_popl_org_f
779: Where pl_id = p_pl_id;
780: --
781: Begin
782: hr_utility.set_location('Entering:'||l_proc, 5);
783: --
784: IF p_pcp_rpstry_flag = 'Y' then
785: open c1;
786: fetch c1 into l_dummy;

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

790: end if;
791: close c1;
792: END IF;
793:
794: hr_utility.set_location('Leaving:'||l_proc, 15);
795: End chk_pl_pcp_rpstry;
796: --
797: -- ---------------------------------------------------------------------------
798: -- |----------------------< set_security_group_id >--------------------------|

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

817: l_proc varchar2(72) := g_package||'set_security_group_id';
818: --
819: begin
820: --
821: hr_utility.set_location('Entering:'|| l_proc, 10);
822: --
823: -- Ensure that all the mandatory parameter are not null
824: --
825: hr_api.mandatory_arg_error

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

848: hr_api.set_security_group_id
849: (p_security_group_id => l_security_group_id
850: );
851: --
852: hr_utility.set_location(' Leaving:'|| l_proc, 20);
853: --
854: end set_security_group_id;
855: --
856: -- ---------------------------------------------------------------------------

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

877: l_proc varchar2(72) := g_package||'return_legislation_code';
878: --
879: Begin
880: --
881: hr_utility.set_location('Entering:'|| l_proc, 10);
882: --
883: -- Ensure that all the mandatory parameter are not null
884: --
885: hr_api.mandatory_arg_error

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

895: -- call to this function. Just return the value in the global
896: -- variable.
897: --
898: l_legislation_code := ben_pcp_bus.g_legislation_code;
899: hr_utility.set_location(l_proc, 20);
900: else
901: --
902: -- The ID is different to the last call to this function
903: -- or this is the first call to this function.

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

912: close csr_leg_code;
913: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
914: fnd_message.raise_error;
915: end if;
916: hr_utility.set_location(l_proc,30);
917: --
918: -- Set the global variables so the values are
919: -- available for the next call to this function.
920: --

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

921: close csr_leg_code;
922: ben_pcp_bus.g_pl_pcp_id := p_pl_pcp_id;
923: ben_pcp_bus.g_legislation_code := l_legislation_code;
924: end if;
925: hr_utility.set_location(' Leaving:'|| l_proc, 40);
926: return l_legislation_code;
927: end return_legislation_code;
928: --
929: -- ----------------------------------------------------------------------------

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

960: --
961: l_proc varchar2(72) := g_package || 'chk_df';
962: --
963: begin
964: hr_utility.set_location('Entering:'||l_proc,10);
965: --
966: if ((p_rec.pl_pcp_id is not null) and (
967: nvl(ben_pcp_shd.g_old_rec.pcp_attribute_category, hr_api.g_varchar2) <>
968: nvl(p_rec.pcp_attribute_category, hr_api.g_varchar2) or

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

1099: ,p_attribute30_value => p_rec.pcp_attribute30
1100: );
1101: end if;
1102: --
1103: hr_utility.set_location(' Leaving:'||l_proc,20);
1104: end chk_df;
1105: --
1106: -- ----------------------------------------------------------------------------
1107: -- |-----------------------< chk_non_updateable_args >------------------------|

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

1174: --
1175: l_proc varchar2(72) := g_package||'insert_validate';
1176: --
1177: Begin
1178: hr_utility.set_location('Entering:'||l_proc, 5);
1179: --
1180: -- Call all supporting business operations
1181: --
1182:

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

1240: --
1241:
1242: --ben_pcp_bus.chk_df(p_rec);
1243: --
1244: hr_utility.set_location(' Leaving:'||l_proc, 10);
1245: End insert_validate;
1246: --
1247: -- ----------------------------------------------------------------------------
1248: -- |---------------------------< update_validate >----------------------------|

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

1253: --
1254: l_proc varchar2(72) := g_package||'update_validate';
1255: --
1256: Begin
1257: hr_utility.set_location('Entering:'||l_proc, 5);
1258: --
1259: -- Call all supporting business operations
1260: --
1261: chk_pl_pcp_id(p_pl_pcp_id => p_rec.pl_pcp_id,

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

1317: --
1318: --
1319: --ben_pcp_bus.chk_df(p_rec);
1320: --
1321: hr_utility.set_location(' Leaving:'||l_proc, 10);
1322: End update_validate;
1323: --
1324: -- ----------------------------------------------------------------------------
1325: -- |---------------------------< delete_validate >----------------------------|

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

1330: --
1331: l_proc varchar2(72) := g_package||'delete_validate';
1332: --
1333: Begin
1334: hr_utility.set_location('Entering:'||l_proc, 5);
1335: --
1336: -- Call all supporting business operations
1337: --
1338: --chk_pl_pcp_rec_exists ( p_pl_id => p_rec.pl_id);

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

1337: --
1338: --chk_pl_pcp_rec_exists ( p_pl_id => p_rec.pl_id);
1339:
1340:
1341: hr_utility.set_location(' Leaving:'||l_proc, 10);
1342: End delete_validate;
1343: --
1344: end ben_pcp_bus;