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.PAY_PUR_BUS dependencies on HR_UTILITY

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

37: l_proc varchar2(72) := g_package||'set_security_group_id';
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error

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

72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --
76: hr_utility.set_location(' Leaving:'|| l_proc, 20);
77: --
78: end set_security_group_id;
79: --
80: -- ---------------------------------------------------------------------------

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

101: l_proc varchar2(72) := g_package||'return_legislation_code';
102: --
103: Begin
104: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error

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

119: -- call to this function. Just return the value in the global
120: -- variable.
121: --
122: l_legislation_code := pay_pur_bus.g_legislation_code;
123: hr_utility.set_location(l_proc, 20);
124: else
125: --
126: -- The ID is different to the last call to this function
127: -- or this is the first call to this function.

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

136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are
143: -- available for the next call to this function.
144: --

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

145: close csr_leg_code;
146: pay_pur_bus.g_user_row_id := p_user_row_id;
147: pay_pur_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
152: --
153: --

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

189: l_exists varchar2(1);
190: l_proc varchar2(100) := g_package || 'chk_legislation_code';
191: begin
192: --
193: hr_utility.set_location('Entering:'|| l_proc, 10);
194:
195: open csr_legislation_code;
196: fetch csr_legislation_code into l_exists ;
197:

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

201: fnd_message.raise_error;
202: end if;
203: close csr_legislation_code;
204:
205: hr_utility.set_location(' Leaving:'|| l_proc, 20);
206: --
207: exception
208: when app_exception.application_exception then
209: if hr_multi_message.exception_add

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

235: l_proc varchar2(100) := g_package || 'return_user_key_units';
236: --
237: begin
238:
239: hr_utility.set_location('Entering:'||l_proc, 10);
240:
241: if g_user_key_units is null then
242:
243: --

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

264: close csr_user_key_units;
265:
266: end if;
267:
268: hr_utility.set_location(' Leaving:'|| l_proc, 20);
269:
270: return g_user_key_units;
271:
272: end return_user_key_units;

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

288: l_proc varchar2(100) := g_package || 'return_range_or_match';
289: --
290: begin
291:
292: hr_utility.set_location('Entering:'||l_proc, 10);
293:
294: if g_range_or_match is null then
295:
296: --

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

317: close csr_range_or_match;
318:
319: end if;
320:
321: hr_utility.set_location(' Leaving:'|| l_proc, 20);
322:
323: return g_range_or_match;
324:
325: end return_range_or_match;

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

367:
368: l_proc varchar2(100) := g_package || 'chk_user_table_id';
369: begin
370:
371: hr_utility.set_location('Entering:'|| l_proc, 10);
372: --
373: -- USER_TABLE_ID is mandatory.
374: --
375: hr_api.mandatory_arg_error

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

403: fnd_message.set_token('PARENT' , 'User Table');
404: fnd_message.raise_error;
405: end if;
406:
407: hr_utility.set_location(' Leaving:'|| l_proc, 20);
408:
409: exception
410: when app_exception.application_exception then
411: if hr_multi_message.exception_add

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

463: l_proc varchar2(100) := g_package || 'chk_format';
464: --
465: begin
466: --
467: hr_utility.set_location('Entering:'|| l_proc, 10);
468:
469: if p_format_code = 'D' then
470: l_format := 'DATE' ;
471: elsif p_format_code = 'T' then

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

486: null
487: );
488: l_return := TRUE;
489:
490: hr_utility.set_location(' Leaving:'|| l_proc, 20);
491:
492: return l_return;
493:
494: exception

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

589: l_oracle_scheema varchar2(30);
590:
591: begin
592:
593: hr_utility.set_location('Entering:'|| l_proc, 10);
594:
595: if hr_multi_message.no_exclusive_error
596: (p_check_column1 => 'PAY_USER_ROWS_F.USER_TABLE_ID'
597: ,p_associated_column1 => 'PAY_USER_ROWS_F.ROW_LOW_RANGE_OR_NAME'

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

677: end if;
678:
679: end if;
680:
681: hr_utility.set_location(' Leaving:'|| l_proc, 20);
682:
683: exception
684:
685: when app_exception.application_exception then

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

744: l_result boolean;
745: --
746: begin
747:
748: hr_utility.set_location('Entering:'|| l_proc, 10);
749:
750: if hr_multi_message.no_exclusive_error
751: (p_check_column1 => 'PAY_USER_ROWS_F.USER_TABLE_ID'
752: ,p_associated_column1 => 'PAY_USER_ROWS_F.ROW_HIGH_RANGE'

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

786: end if;
787: end if;
788: end if;
789:
790: hr_utility.set_location(' Leaving:'|| l_proc, 20);
791:
792: exception
793:
794: when app_exception.application_exception then

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

898: l_oracle_scheema varchar2(30);
899:
900: begin
901:
902: hr_utility.set_location('Entering:'|| l_proc, 10);
903:
904: if hr_multi_message.no_exclusive_error
905: ( p_check_column1 => 'PAY_USER_ROWS_F.ROW_LOW_RANGE_OR_NAME'
906: ,p_check_column2 => 'PAY_USER_ROWS_F.ROW_HIGH_RANGE'

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

970: end if;
971: end if;
972: end if;
973:
974: hr_utility.set_location(' Leaving:'|| l_proc, 20);
975:
976: exception
977:
978: when app_exception.application_exception then

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

1022: l_proc varchar2(100) := g_package || 'chk_display_sequence';
1023: --
1024: Begin
1025:
1026: hr_utility.set_location('Entering:'|| l_proc, 10);
1027: /* Bug fix: 4661747 : Added the if condition to this call */
1028: if(p_display_sequence is not NULL) then
1029: hr_dbchkfmt.is_db_format( p_display_sequence , 'DISPLAY_SEQUENCE' , 'I' );
1030: end if;

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

1028: if(p_display_sequence is not NULL) then
1029: hr_dbchkfmt.is_db_format( p_display_sequence , 'DISPLAY_SEQUENCE' , 'I' );
1030: end if;
1031:
1032: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1033:
1034: Exception
1035:
1036: when app_exception.application_exception then

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

1173:
1174: --
1175: Begin
1176:
1177: hr_utility.set_location('Entering:'|| l_proc, 10);
1178:
1179: if p_disable_range_overlap_check is null then
1180: fnd_message.set_name('PAY', 'HR_7207_API_MANDATORY_ARG');
1181: fnd_message.set_token('API_NAME', l_proc);

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

1253: close csr_row_overlap;
1254: end if;
1255: end if;
1256:
1257: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1258: Exception
1259:
1260: when app_exception.application_exception then
1261: if hr_multi_message.exception_add

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

1319: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1320: --
1321: Begin
1322:
1323: hr_utility.set_location('Entering:'|| l_proc, 10);
1324: --
1325: -- Only proceed with the validation if a row exists for the current
1326: -- record in the HR Schema.
1327: --

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

1363: ,p_base_table => pay_pur_shd.g_tab_nam
1364: );
1365: end if;
1366: --
1367: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1368:
1369: End chk_non_updateable_args;
1370: --
1371: -- ----------------------------------------------------------------------------

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

1605: --
1606: l_proc varchar2(72) := g_package||'insert_validate';
1607: --
1608: Begin
1609: hr_utility.set_location('Entering:'||l_proc, 5);
1610:
1611: --
1612: -- Clearing the Global variables since the record may have changed.
1613: --

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

1703: ,p_validation_end_date => p_validation_end_date
1704: );
1705: --
1706: --
1707: hr_utility.set_location(' Leaving:'||l_proc, 10);
1708: End insert_validate;
1709: --
1710: -- ----------------------------------------------------------------------------
1711: -- |---------------------------< update_validate >----------------------------|

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

1722: --
1723: l_proc varchar2(72) := g_package||'update_validate';
1724: --
1725: Begin
1726: hr_utility.set_location('Entering:'||l_proc, 5);
1727: --
1728: --
1729: -- Clearing the Global variables since the record may have changed.
1730: --

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

1814: ,p_validation_end_date => p_validation_end_date
1815: );
1816: --
1817: --
1818: hr_utility.set_location(' Leaving:'||l_proc, 10);
1819: End update_validate;
1820: --
1821: -- ----------------------------------------------------------------------------
1822: -- |---------------------------< delete_validate >----------------------------|

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

1832: --
1833: l_proc varchar2(72) := g_package||'delete_validate';
1834: --
1835: Begin
1836: hr_utility.set_location('Entering:'||l_proc, 5);
1837: --
1838: -- Clearing the Global variables since the record may have changed.
1839: --
1840: g_user_key_units := NULL;

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

1880: ,p_validation_start_date => p_validation_start_date
1881: ,p_validation_end_date => p_validation_end_date
1882: );
1883:
1884: hr_utility.set_location(' Leaving:'||l_proc, 10);
1885: End delete_validate;
1886: --
1887: end pay_pur_bus;