eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_XEL_BUS dependencies on HR_UTILITY

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

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

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

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

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_xel_shd.api_updating
107: (p_ext_data_elmt_id => p_ext_data_elmt_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_data_elmt_id;
135: --
136: -- ----------------------------------------------------------------------------

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

177: --
178:
179: Begin
180: --
181: hr_utility.set_location('Entering:'||l_proc, 5);
182: --
183: l_api_updating := ben_xel_shd.api_updating
184: (p_ext_data_elmt_id => p_ext_data_elmt_id,
185: p_object_version_number => p_object_version_number);

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

249: end if;
250: end if;
251: end if;
252: --
253: hr_utility.set_location('Leaving:'||l_proc,10);
254: --
255: Exception
256: When invalid_frmt1 or invalid_frmt2 then
257: fnd_message.set_name('BEN','BEN_91959_INVLD_FRMT_MSK');

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

325: ;
326: --
327: Begin
328: --
329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: l_api_updating := ben_xel_shd.api_updating
332: (p_ext_data_elmt_id => p_ext_data_elmt_id,
333: p_object_version_number => p_object_version_number);

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

362: close c1;
363: --
364: end if;
365: --
366: hr_utility.set_location('Leaving:'||l_proc,10);
367: --
368: end chk_data_elmt_rl;
369: --
370: -- ----------------------------------------------------------------------------

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

402: where bed.ext_data_elmt_id = p_ext_data_elmt_id;
403: --
404: Begin
405: --
406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: open c1;
409: --
410: fetch c1 into l_dummy;

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

420: end if;
421: --
422: close c1;
423: --
424: hr_utility.set_location('Leaving:'||l_proc,10);
425: --
426: end chk_delete_allowed;
427: -- ----------------------------------------------------------------------------
428: -- |------< chk_max_length_num >------|

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

451: l_proc varchar2(72) := g_package||'chk_max_length_num';
452: --
453: Begin
454: --
455: hr_utility.set_location('Entering:'||l_proc, 5);
456: --
457: --
458: if p_max_length_num =0 or p_max_length_num <0 then
459: fnd_message.set_name('BEN','BEN_91865_INVLD_MAX_NUM');

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

467: fnd_message.raise_error;
468: end if;
469: end if;
470: end if;
471: hr_utility.set_location('Leaving:'||l_proc,10);
472: --
473: end chk_max_length_num;
474: --
475: -- ----------------------------------------------------------------------------

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

513: l_api_updating boolean;
514: --
515: Begin
516: --
517: hr_utility.set_location('Entering:'||l_proc, 5);
518: --
519: l_api_updating := ben_xel_shd.api_updating
520: (p_ext_data_elmt_id => p_ext_data_elmt_id,
521: p_object_version_number => p_object_version_number);

Line 536: hr_utility.set_location('update mode :' || p_string_val ||' '|| ben_xel_shd.g_old_rec.string_val, 5);

532: and p_data_elmt_typ_cd is not null then
533: --
534: -- check if value of lookup falls within lookup type.
535: --
536: hr_utility.set_location('update mode :' || p_string_val ||' '|| ben_xel_shd.g_old_rec.string_val, 5);
537: if p_business_group_id is not null then
538: if hr_api.not_exists_in_hr_lookups
539: (p_lookup_type => 'BEN_EXT_DATA_ELMT_TYP',
540: p_lookup_code => p_data_elmt_typ_cd,

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

604:
605:
606: end if;
607: --
608: hr_utility.set_location('Leaving:'||l_proc,10);
609: --
610: end chk_data_elmt_typ_cd;
611: --
612: -- ----------------------------------------------------------------------------

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

645: l_api_updating boolean;
646: --
647: Begin
648: --
649: hr_utility.set_location('Entering:'||l_proc, 5);
650: --
651: l_api_updating := ben_xel_shd.api_updating
652: (p_ext_data_elmt_id => p_ext_data_elmt_id,
653: p_object_version_number => p_object_version_number);

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

693: end if;
694: --
695: end if;
696: --
697: hr_utility.set_location('Leaving:'||l_proc,10);
698: --
699: end chk_just_cd;
700:
701:

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

742: ;
743: l_dummy varchar2(1) ;
744: Begin
745: --
746: hr_utility.set_location('Entering:'||l_proc, 5);
747: --
748: l_api_updating := ben_xel_shd.api_updating
749: (p_ext_data_elmt_id => p_ext_data_elmt_id,
750: p_object_version_number => p_object_version_number);

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

768: close c ;
769: --
770: end if;
771: --
772: hr_utility.set_location('Leaving:'||l_proc,10);
773: --
774: end chk_defined_balance;
775:
776: -- ----------------------------------------------------------------------------

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

782: rgeflg varchar2(1);
783: l_proc varchar2(72) := g_package||'chk_xml_name_format';
784: --
785: Begin
786: hr_utility.set_location('Entering:'||l_proc, 5);
787: --
788:
789: if p_xml_tag_name is not null then
790: begin

Line 795: when hr_utility.hr_error then

791: -- Check if name legal format eg no spaces, or special characters
792: hr_chkfmt.checkformat (p_xml_tag_name, 'DB_ITEM_NAME', p_xml_tag_name,
793: null,null,'Y',rgeflg,null);
794: exception
795: when hr_utility.hr_error then
796: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');
797: hr_utility.set_message_token(802,'VALUE_NAME','XML Tag');
798: hr_utility.raise_error;
799: end;

Line 796: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');

792: hr_chkfmt.checkformat (p_xml_tag_name, 'DB_ITEM_NAME', p_xml_tag_name,
793: null,null,'Y',rgeflg,null);
794: exception
795: when hr_utility.hr_error then
796: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');
797: hr_utility.set_message_token(802,'VALUE_NAME','XML Tag');
798: hr_utility.raise_error;
799: end;
800: end if ;

Line 797: hr_utility.set_message_token(802,'VALUE_NAME','XML Tag');

793: null,null,'Y',rgeflg,null);
794: exception
795: when hr_utility.hr_error then
796: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');
797: hr_utility.set_message_token(802,'VALUE_NAME','XML Tag');
798: hr_utility.raise_error;
799: end;
800: end if ;
801: --

Line 798: hr_utility.raise_error;

794: exception
795: when hr_utility.hr_error then
796: hr_utility.set_message (802, 'FFHR_6016_ALL_RES_WORDS');
797: hr_utility.set_message_token(802,'VALUE_NAME','XML Tag');
798: hr_utility.raise_error;
799: end;
800: end if ;
801: --
802: hr_utility.set_location('Leaving:'||l_proc, 15);

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

798: hr_utility.raise_error;
799: end;
800: end if ;
801: --
802: hr_utility.set_location('Leaving:'||l_proc, 15);
803: End chk_xml_name_format;
804: --
805:
806: -- ----------------------------------------------------------------------------

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

856: rgeflg varchar2(1);
857:
858: --
859: Begin
860: hr_utility.set_location('Entering:'||l_proc, 5);
861: --
862: open c1;
863: fetch c1 into l_dummy;
864: if c1%found then

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

867: fnd_message.raise_error;
868: end if;
869:
870: --
871: hr_utility.set_location('Leaving:'||l_proc, 15);
872: End chk_name_unique;
873: --
874: -- ----------------------------------------------------------------------------
875: -- |------------------------< chk_ttl_cond >---------------------------------|

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

913: l_proc varchar2(72) := g_package||'chk_ttl_cond';
914: l_api_updating boolean;
915: --
916: Begin
917: hr_utility.set_location('Entering:'||l_proc, 5);
918: --
919: l_api_updating := ben_xel_shd.api_updating
920: (p_ext_data_elmt_id => p_ext_data_elmt_id,
921: p_object_version_number => p_object_version_number);

Line 923: hr_utility.set_location('p_ttl_fnctn_cd:'||p_ttl_fnctn_cd, 15);

919: l_api_updating := ben_xel_shd.api_updating
920: (p_ext_data_elmt_id => p_ext_data_elmt_id,
921: p_object_version_number => p_object_version_number);
922: --
923: hr_utility.set_location('p_ttl_fnctn_cd:'||p_ttl_fnctn_cd, 15);
924: if (l_api_updating
925: and nvl(p_ttl_fnctn_cd,hr_api.g_varchar2)
926: <> nvl(ben_xel_shd.g_old_rec.ttl_fnctn_cd,hr_api.g_varchar2)
927: or not l_api_updating) then

Line 986: hr_utility.set_location('p_ttl_fnctn_cd:'||p_ttl_fnctn_cd, 15);

982: fnd_message.raise_error;
983: end if;
984:
985: end if;
986: hr_utility.set_location('p_ttl_fnctn_cd:'||p_ttl_fnctn_cd, 15);
987: hr_utility.set_location('p_ttl_cond_ext_data_elmt_id:'||p_ttl_cond_ext_data_elmt_id, 15);
988: if (l_api_updating
989: and nvl(p_ttl_cond_ext_data_elmt_id,hr_api.g_number)
990: <> nvl(ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id,hr_api.g_number)

Line 987: hr_utility.set_location('p_ttl_cond_ext_data_elmt_id:'||p_ttl_cond_ext_data_elmt_id, 15);

983: end if;
984:
985: end if;
986: hr_utility.set_location('p_ttl_fnctn_cd:'||p_ttl_fnctn_cd, 15);
987: hr_utility.set_location('p_ttl_cond_ext_data_elmt_id:'||p_ttl_cond_ext_data_elmt_id, 15);
988: if (l_api_updating
989: and nvl(p_ttl_cond_ext_data_elmt_id,hr_api.g_number)
990: <> nvl(ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id,hr_api.g_number)
991: or not l_api_updating) then

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

997: end if;
998: end if;
999: end if;
1000: --
1001: hr_utility.set_location('Leaving:'||l_proc, 15);
1002: End chk_ttl_cond;
1003: --
1004: -- ----------------------------------------------------------------------------
1005: -- |----------------------< chk_startup_action >------------------------------|

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

1059: -- Added for Bug fix 2091110
1060: l_legislation_code per_business_groups.legislation_code%TYPE;
1061: --
1062: Begin
1063: hr_utility.set_location('Entering:'||l_proc, 5);
1064: --
1065: -- Call all supporting business operations
1066: --
1067: --

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

1153: p_effective_date => p_effective_date ,
1154: p_business_group_id => p_rec.business_group_id ,
1155: p_object_version_number => p_rec.object_version_number ) ;
1156:
1157: hr_utility.set_location(' Leaving:'||l_proc, 10);
1158: End insert_validate;
1159: --
1160: -- ----------------------------------------------------------------------------
1161: -- |---------------------------< update_validate >----------------------------|

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

1168: -- Added for bug fix 2091110
1169: l_legislation_code per_business_groups.legislation_code%TYPE;
1170: --
1171: Begin
1172: hr_utility.set_location('Entering:'||l_proc, 5);
1173: --
1174: -- Call all supporting business operations
1175: --
1176: --

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

1263: p_business_group_id => p_rec.business_group_id ,
1264: p_object_version_number => p_rec.object_version_number ) ;
1265:
1266: --
1267: hr_utility.set_location(' Leaving:'||l_proc, 10);
1268: End update_validate;
1269: --
1270: -- ----------------------------------------------------------------------------
1271: -- |---------------------------< delete_validate >----------------------------|

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

1278: -- Added for Bug fix 2091110
1279: l_legislation_code per_business_groups.legislation_code%TYPE;
1280: --
1281: Begin
1282: hr_utility.set_location('Entering:'||l_proc, 5);
1283: --
1284: -- Call all supporting business operations
1285: --
1286: --

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

1305: -- ,ben_xel_shd.g_old_rec.legislation_code);
1306: --
1307: chk_delete_allowed(p_ext_data_elmt_id => p_rec.ext_data_elmt_id);
1308: --
1309: hr_utility.set_location(' Leaving:'||l_proc, 10);
1310: End delete_validate;
1311: --
1312: --
1313: -- ---------------------------------------------------------------------------

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

1332: l_proc varchar2(72) := g_package||'return_legislation_code';
1333: --
1334: begin
1335: --
1336: hr_utility.set_location('Entering:'|| l_proc, 10);
1337: --
1338: -- Ensure that all the mandatory parameter are not null
1339: --
1340: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1357: end if;
1358: --
1359: close csr_leg_code;
1360: --
1361: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1362: --
1363: return l_legislation_code;
1364: --
1365: end return_legislation_code;