DBA Data[Home] [Help]

APPS.HR_GENERAL dependencies on HR_UTILITY

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

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

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

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

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

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

Line 673: hr_utility.raise_error;

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

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

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

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

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

Line 766: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 1347: ' hr_utility.raise_error;'||

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

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

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

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

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

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

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

Line 1449: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 1454: hr_utility.raise_error;

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

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

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

Line 1466: hr_utility.raise_error;

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

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

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

Line 1474: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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