DBA Data[Home] [Help]

APPS.HR_GENERAL dependencies on HR_UTILITY

Line 617: -- in calls to hr_utility.set_message.

613: where fa.application_id = p_app_id ;
614: begin
615:
616: -- Special case the most common ones. This is to save a select
617: -- in calls to hr_utility.set_message.
618: if ( p_application_id = 800 )
619: then
620: l_return_value := 'PER' ;
621: elsif ( p_application_id = 801 )

Line 662: hr_utility.set_location ('HR_GENERAL.LOCATION_VALID',1);

658: v_location_valid boolean;
659: --
660: begin
661: --
662: hr_utility.set_location ('HR_GENERAL.LOCATION_VALID',1);
663: --
664: open csr_location;
665: fetch csr_location into g_dummy;
666: v_location_valid := csr_location%found;

Line 670: hr_utility.set_message (801, 'HR_7104_LOC_LOCATION_INVALID');

666: v_location_valid := csr_location%found;
667: close csr_location;
668: --
669: if (not v_location_valid) and p_error_if_invalid then
670: hr_utility.set_message (801, 'HR_7104_LOC_LOCATION_INVALID');
671: hr_utility.raise_error;
672: end if;
673: --
674: return v_location_valid;

Line 671: hr_utility.raise_error;

667: close csr_location;
668: --
669: if (not v_location_valid) and p_error_if_invalid then
670: hr_utility.set_message (801, 'HR_7104_LOC_LOCATION_INVALID');
671: hr_utility.raise_error;
672: end if;
673: --
674: return v_location_valid;
675: --

Line 746: hr_utility.set_location ('hr_general.default_currency_code',1);

742: --
743: v_default_currency varchar2(255) := null;
744: --
745: begin
746: hr_utility.set_location ('hr_general.default_currency_code',1);
747: --
748: -- Find the user-specified default currency
749: --
750: open csr_legislation;

Line 763: hr_utility.set_message(801, 'HR_7989_HR_DEFAULT_CURRENCY');

759: -- If no currency is available, then return an error
760: --
761: if csr_currency%notfound then
762: close csr_currency;
763: hr_utility.set_message(801, 'HR_7989_HR_DEFAULT_CURRENCY');
764: hr_utility.raise_error;
765: else
766: close csr_currency;
767: end if;

Line 764: hr_utility.raise_error;

760: --
761: if csr_currency%notfound then
762: close csr_currency;
763: hr_utility.set_message(801, 'HR_7989_HR_DEFAULT_CURRENCY');
764: hr_utility.raise_error;
765: else
766: close csr_currency;
767: end if;
768: --

Line 1341: ' hr_utility.set_message (801, ''HR_7345_INVALID_FILE'');'||

1337: -- The text below will be run dynamically after substituting the parameters
1338: l_text varchar2 (2000) :=
1339: 'begin '||
1340: 'if hr_version. != '''' then'||
1341: ' hr_utility.set_message (801, ''HR_7345_INVALID_FILE'');'||
1342: ' hr_utility.set_message_token (''FILENAME'','''');'||
1343: ' hr_utility.set_message_token (''OLD_VERSION'', '''');'||
1344: ' hr_utility.set_message_token (''LATEST_VERSION'', hr_version.);'||
1345: ' hr_utility.raise_error;'||

Line 1342: ' hr_utility.set_message_token (''FILENAME'','''');'||

1338: l_text varchar2 (2000) :=
1339: 'begin '||
1340: 'if hr_version. != '''' then'||
1341: ' hr_utility.set_message (801, ''HR_7345_INVALID_FILE'');'||
1342: ' hr_utility.set_message_token (''FILENAME'','''');'||
1343: ' hr_utility.set_message_token (''OLD_VERSION'', '''');'||
1344: ' hr_utility.set_message_token (''LATEST_VERSION'', hr_version.);'||
1345: ' hr_utility.raise_error;'||
1346: 'end if;'||

Line 1343: ' hr_utility.set_message_token (''OLD_VERSION'', '''');'||

1339: 'begin '||
1340: 'if hr_version. != '''' then'||
1341: ' hr_utility.set_message (801, ''HR_7345_INVALID_FILE'');'||
1342: ' hr_utility.set_message_token (''FILENAME'','''');'||
1343: ' hr_utility.set_message_token (''OLD_VERSION'', '''');'||
1344: ' hr_utility.set_message_token (''LATEST_VERSION'', hr_version.);'||
1345: ' hr_utility.raise_error;'||
1346: 'end if;'||
1347: 'end;';

Line 1344: ' hr_utility.set_message_token (''LATEST_VERSION'', hr_version.);'||

1340: 'if hr_version. != '''' then'||
1341: ' hr_utility.set_message (801, ''HR_7345_INVALID_FILE'');'||
1342: ' hr_utility.set_message_token (''FILENAME'','''');'||
1343: ' hr_utility.set_message_token (''OLD_VERSION'', '''');'||
1344: ' hr_utility.set_message_token (''LATEST_VERSION'', hr_version.);'||
1345: ' hr_utility.raise_error;'||
1346: 'end if;'||
1347: 'end;';
1348: --

Line 1345: ' hr_utility.raise_error;'||

1341: ' hr_utility.set_message (801, ''HR_7345_INVALID_FILE'');'||
1342: ' hr_utility.set_message_token (''FILENAME'','''');'||
1343: ' hr_utility.set_message_token (''OLD_VERSION'', '''');'||
1344: ' hr_utility.set_message_token (''LATEST_VERSION'', hr_version.);'||
1345: ' hr_utility.raise_error;'||
1346: 'end if;'||
1347: 'end;';
1348: --
1349: begin

Line 1444: hr_utility.set_message('801', 'HR_6153_ALL_PROCEDURE_FAIL');

1440: from per_business_groups b
1441: where b.business_group_id = p_business_group_id;
1442: exception
1443: when no_data_found then
1444: hr_utility.set_message('801', 'HR_6153_ALL_PROCEDURE_FAIL');
1445: hr_utility.set_message_token('PROCEDURE', 'INIT_FORMS');
1446: hr_utility.set_message_token('STEP', '1');
1447: hr_utility.raise_error;
1448: when too_many_rows then

Line 1445: hr_utility.set_message_token('PROCEDURE', 'INIT_FORMS');

1441: where b.business_group_id = p_business_group_id;
1442: exception
1443: when no_data_found then
1444: hr_utility.set_message('801', 'HR_6153_ALL_PROCEDURE_FAIL');
1445: hr_utility.set_message_token('PROCEDURE', 'INIT_FORMS');
1446: hr_utility.set_message_token('STEP', '1');
1447: hr_utility.raise_error;
1448: when too_many_rows then
1449: hr_utility.set_message('801', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1446: hr_utility.set_message_token('STEP', '1');

1442: exception
1443: when no_data_found then
1444: hr_utility.set_message('801', 'HR_6153_ALL_PROCEDURE_FAIL');
1445: hr_utility.set_message_token('PROCEDURE', 'INIT_FORMS');
1446: hr_utility.set_message_token('STEP', '1');
1447: hr_utility.raise_error;
1448: when too_many_rows then
1449: hr_utility.set_message('801', 'HR_6153_ALL_PROCEDURE_FAIL');
1450: hr_utility.set_message_token('PROCEDURE', 'INIT_FORMS');

Line 1447: hr_utility.raise_error;

1443: when no_data_found then
1444: hr_utility.set_message('801', 'HR_6153_ALL_PROCEDURE_FAIL');
1445: hr_utility.set_message_token('PROCEDURE', 'INIT_FORMS');
1446: hr_utility.set_message_token('STEP', '1');
1447: hr_utility.raise_error;
1448: when too_many_rows then
1449: hr_utility.set_message('801', 'HR_6153_ALL_PROCEDURE_FAIL');
1450: hr_utility.set_message_token('PROCEDURE', 'INIT_FORMS');
1451: hr_utility.set_message_token('STEP', '2');

Line 1449: hr_utility.set_message('801', 'HR_6153_ALL_PROCEDURE_FAIL');

1445: hr_utility.set_message_token('PROCEDURE', 'INIT_FORMS');
1446: hr_utility.set_message_token('STEP', '1');
1447: hr_utility.raise_error;
1448: when too_many_rows then
1449: hr_utility.set_message('801', 'HR_6153_ALL_PROCEDURE_FAIL');
1450: hr_utility.set_message_token('PROCEDURE', 'INIT_FORMS');
1451: hr_utility.set_message_token('STEP', '2');
1452: hr_utility.raise_error;
1453: end;

Line 1450: hr_utility.set_message_token('PROCEDURE', 'INIT_FORMS');

1446: hr_utility.set_message_token('STEP', '1');
1447: hr_utility.raise_error;
1448: when too_many_rows then
1449: hr_utility.set_message('801', 'HR_6153_ALL_PROCEDURE_FAIL');
1450: hr_utility.set_message_token('PROCEDURE', 'INIT_FORMS');
1451: hr_utility.set_message_token('STEP', '2');
1452: hr_utility.raise_error;
1453: end;
1454: -- check that the security profile business group matches the

Line 1451: hr_utility.set_message_token('STEP', '2');

1447: hr_utility.raise_error;
1448: when too_many_rows then
1449: hr_utility.set_message('801', 'HR_6153_ALL_PROCEDURE_FAIL');
1450: hr_utility.set_message_token('PROCEDURE', 'INIT_FORMS');
1451: hr_utility.set_message_token('STEP', '2');
1452: hr_utility.raise_error;
1453: end;
1454: -- check that the security profile business group matches the
1455: -- set business group.

Line 1452: hr_utility.raise_error;

1448: when too_many_rows then
1449: hr_utility.set_message('801', 'HR_6153_ALL_PROCEDURE_FAIL');
1450: hr_utility.set_message_token('PROCEDURE', 'INIT_FORMS');
1451: hr_utility.set_message_token('STEP', '2');
1452: hr_utility.raise_error;
1453: end;
1454: -- check that the security profile business group matches the
1455: -- set business group.
1456: l_security_profile_id:=fnd_profile.value('PER_SECURITY_PROFILE_ID');

Line 1463: hr_utility.set_message('800', 'PER_52803_SEC_INV_BG');

1459: fetch sec_bg into l_security_business_group_id;
1460: if sec_bg%notfound then
1461: close sec_bg;
1462: -- the security profile does not exist, so raise an error.
1463: hr_utility.set_message('800', 'PER_52803_SEC_INV_BG');
1464: hr_utility.raise_error;
1465: else
1466: close sec_bg;
1467: if nvl(l_security_business_group_id,p_business_group_id)

Line 1464: hr_utility.raise_error;

1460: if sec_bg%notfound then
1461: close sec_bg;
1462: -- the security profile does not exist, so raise an error.
1463: hr_utility.set_message('800', 'PER_52803_SEC_INV_BG');
1464: hr_utility.raise_error;
1465: else
1466: close sec_bg;
1467: if nvl(l_security_business_group_id,p_business_group_id)
1468: <>p_business_group_id then

Line 1471: hr_utility.set_message('800', 'PER_52803_SEC_INV_BG');

1467: if nvl(l_security_business_group_id,p_business_group_id)
1468: <>p_business_group_id then
1469: -- the security profile business group id is not null and
1470: -- it dies not match our business group id so raise an error.
1471: hr_utility.set_message('800', 'PER_52803_SEC_INV_BG');
1472: hr_utility.raise_error;
1473: end if;
1474: end if;
1475: --

Line 1472: hr_utility.raise_error;

1468: <>p_business_group_id then
1469: -- the security profile business group id is not null and
1470: -- it dies not match our business group id so raise an error.
1471: hr_utility.set_message('800', 'PER_52803_SEC_INV_BG');
1472: hr_utility.raise_error;
1473: end if;
1474: end if;
1475: --
1476: else -- p_business_group_id is null

Line 1519: hr_utility.trace_on('F','PID');

1515: --
1516: -- Enable HR trace. This is done as each form starts up
1517: --
1518: if ( p_enable_hr_trace ) then
1519: hr_utility.trace_on('F','PID');
1520: hr_utility.set_trace_options('TRACE_DEST:'||p_hr_trace_dest);
1521: end if;
1522:
1523:

Line 1520: hr_utility.set_trace_options('TRACE_DEST:'||p_hr_trace_dest);

1516: -- Enable HR trace. This is done as each form starts up
1517: --
1518: if ( p_enable_hr_trace ) then
1519: hr_utility.trace_on('F','PID');
1520: hr_utility.set_trace_options('TRACE_DEST:'||p_hr_trace_dest);
1521: end if;
1522:
1523:
1524: -- DK 22-DEC-1996 Ideally we should remove p_commit_flag altogether

Line 1559: hr_utility.set_location('Entering:'|| l_proc, 1);

1555: --
1556: -- Fix for bug 3355231 ends here.
1557: --
1558: begin
1559: hr_utility.set_location('Entering:'|| l_proc, 1);
1560: --
1561: -- Check if any rows exist in the pay_us_city_names
1562: --
1563: open csr_get_us_city_names;

Line 1572: hr_utility.set_location(' Leaving:'|| l_proc, 3);

1568: return 'N';
1569: end if;
1570: close csr_get_us_city_names;
1571: --
1572: hr_utility.set_location(' Leaving:'|| l_proc, 3);
1573: --
1574: end chk_geocodes_installed;
1575: -- --------------------------------------------------------------------------
1576: -- This function will be called to determine if we need to maintain tax record

Line 1590: hr_utility.set_location('Entering:'|| l_proc, 1);

1586: l_proc varchar2(72) := 'hr_general.chk_maintain_tax_records';
1587: --
1588: l_dtw4_profile_option_value VARCHAR2(3);
1589: begin
1590: hr_utility.set_location('Entering:'|| l_proc, 1);
1591: --
1592: -- Get the profile value for the PER_ENABLE_DTW4.
1593: --
1594: FND_PROFILE.GET('PER_ENABLE_DTW4',

Line 1597: IF hr_utility.chk_product_install(p_product =>'Oracle Payroll',

1593: --
1594: FND_PROFILE.GET('PER_ENABLE_DTW4',
1595: l_dtw4_profile_option_value);
1596: --
1597: IF hr_utility.chk_product_install(p_product =>'Oracle Payroll',
1598: p_legislation => 'US') OR
1599: (hr_general.chk_geocodes_installed ='Y' and
1600: NVL(l_dtw4_profile_option_value,'Y') = 'Y' ) THEN
1601: return 'Y';

Line 1608: hr_utility.set_location(' Leaving:'|| l_proc, 3);

1604: end if;
1605:
1606:
1607: --
1608: hr_utility.set_location(' Leaving:'|| l_proc, 3);
1609: --
1610: end chk_maintain_tax_records;
1611: -- --------------------------------------------------------------------------
1612: --