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.

[Home] [Help]

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 680: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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