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_ECU_BUS dependencies on HR_UTILITY

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

39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

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

79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------

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

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

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

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := pay_ecu_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

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

143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

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

152: close csr_leg_code;
153: pay_ecu_bus.g_element_class_usage_id := p_element_class_usage_id;
154: pay_ecu_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: -- ----------------------------------------------------------------------------
160: -- |---------------------------< chk_run_type_id >----------------------------|

Line 256: hr_utility.set_location(l_proc, 15);

252: );
253:
254: IF (p_run_type_id is not null) then
255: IF hr_startup_data_api_support.g_startup_mode = 'GENERIC' THEN
256: hr_utility.set_location(l_proc, 15);
257: OPEN csr_chk_generic_run_type;
258: FETCH csr_chk_generic_run_type INTO l_exists;
259: IF csr_chk_generic_run_type%NOTFOUND THEN
260: --

Line 262: hr_utility.set_message(801, 'HR_33587_INVALID_RT_FOR_MODE');

258: FETCH csr_chk_generic_run_type INTO l_exists;
259: IF csr_chk_generic_run_type%NOTFOUND THEN
260: --
261: CLOSE csr_chk_generic_run_type;
262: hr_utility.set_message(801, 'HR_33587_INVALID_RT_FOR_MODE');
263: hr_utility.raise_error;
264: --
265: END IF;
266: CLOSE csr_chk_generic_run_type;

Line 263: hr_utility.raise_error;

259: IF csr_chk_generic_run_type%NOTFOUND THEN
260: --
261: CLOSE csr_chk_generic_run_type;
262: hr_utility.set_message(801, 'HR_33587_INVALID_RT_FOR_MODE');
263: hr_utility.raise_error;
264: --
265: END IF;
266: CLOSE csr_chk_generic_run_type;
267: --

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

265: END IF;
266: CLOSE csr_chk_generic_run_type;
267: --
268: ELSIF hr_startup_data_api_support.g_startup_mode = 'STARTUP' THEN
269: hr_utility.set_location(l_proc, 20);
270: OPEN csr_chk_startup_run_type;
271: FETCH csr_chk_startup_run_type INTO l_exists;
272: IF csr_chk_startup_run_type%NOTFOUND THEN
273: --

Line 275: hr_utility.set_message(801, 'HR_33587_INVALID_RT_FOR_MODE');

271: FETCH csr_chk_startup_run_type INTO l_exists;
272: IF csr_chk_startup_run_type%NOTFOUND THEN
273: --
274: CLOSE csr_chk_startup_run_type;
275: hr_utility.set_message(801, 'HR_33587_INVALID_RT_FOR_MODE');
276: hr_utility.raise_error;
277: END IF;
278: CLOSE csr_chk_startup_run_type;
279: --

Line 276: hr_utility.raise_error;

272: IF csr_chk_startup_run_type%NOTFOUND THEN
273: --
274: CLOSE csr_chk_startup_run_type;
275: hr_utility.set_message(801, 'HR_33587_INVALID_RT_FOR_MODE');
276: hr_utility.raise_error;
277: END IF;
278: CLOSE csr_chk_startup_run_type;
279: --
280: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN

Line 281: hr_utility.set_location(l_proc, 25);

277: END IF;
278: CLOSE csr_chk_startup_run_type;
279: --
280: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN
281: hr_utility.set_location(l_proc, 25);
282: IF (p_element_class_usage_id is not null) then
283: l_legislation_code := return_legislation_code(p_element_class_usage_id);
284: ELSE
285: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);

Line 292: hr_utility.set_message(801, 'PAY_33407_ECU_INVALID');

288: FETCH csr_chk_user_run_type INTO l_exists;
289: IF csr_chk_user_run_type%NOTFOUND THEN
290: --
291: CLOSE csr_chk_user_run_type;
292: hr_utility.set_message(801, 'PAY_33407_ECU_INVALID');
293: hr_utility.raise_error;
294: --
295: END IF;
296: CLOSE csr_chk_user_run_type;

Line 293: hr_utility.raise_error;

289: IF csr_chk_user_run_type%NOTFOUND THEN
290: --
291: CLOSE csr_chk_user_run_type;
292: hr_utility.set_message(801, 'PAY_33407_ECU_INVALID');
293: hr_utility.raise_error;
294: --
295: END IF;
296: CLOSE csr_chk_user_run_type;
297: END IF;

Line 412: hr_utility.set_location(l_proc, 15);

408: ,p_argument_value => p_classification_id
409: );
410: IF (p_classification_id is not null) then
411: IF hr_startup_data_api_support.g_startup_mode = 'GENERIC' THEN
412: hr_utility.set_location(l_proc, 15);
413: OPEN csr_chk_generic_ele_class;
414: FETCH csr_chk_generic_ele_class INTO l_exists;
415: IF csr_chk_generic_ele_class%NOTFOUND THEN
416: --

Line 418: hr_utility.set_message(801, 'PAY_33408_INV_ELE_CLS_FOR_MODE');

414: FETCH csr_chk_generic_ele_class INTO l_exists;
415: IF csr_chk_generic_ele_class%NOTFOUND THEN
416: --
417: CLOSE csr_chk_generic_ele_class;
418: hr_utility.set_message(801, 'PAY_33408_INV_ELE_CLS_FOR_MODE');
419: hr_utility.raise_error;
420: --
421: END IF;
422: CLOSE csr_chk_generic_ele_class;

Line 419: hr_utility.raise_error;

415: IF csr_chk_generic_ele_class%NOTFOUND THEN
416: --
417: CLOSE csr_chk_generic_ele_class;
418: hr_utility.set_message(801, 'PAY_33408_INV_ELE_CLS_FOR_MODE');
419: hr_utility.raise_error;
420: --
421: END IF;
422: CLOSE csr_chk_generic_ele_class;
423: --

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

421: END IF;
422: CLOSE csr_chk_generic_ele_class;
423: --
424: ELSIF hr_startup_data_api_support.g_startup_mode = 'STARTUP' THEN
425: hr_utility.set_location(l_proc, 20);
426: OPEN csr_chk_startup_ele_class;
427: FETCH csr_chk_startup_ele_class INTO l_exists;
428: IF csr_chk_startup_ele_class%NOTFOUND THEN
429: --

Line 431: hr_utility.set_message(801, 'PAY_33408_INV_ELE_CLS_FOR_MODE');

427: FETCH csr_chk_startup_ele_class INTO l_exists;
428: IF csr_chk_startup_ele_class%NOTFOUND THEN
429: --
430: CLOSE csr_chk_startup_ele_class;
431: hr_utility.set_message(801, 'PAY_33408_INV_ELE_CLS_FOR_MODE');
432: hr_utility.raise_error;
433: END IF;
434: CLOSE csr_chk_startup_ele_class;
435: --

Line 432: hr_utility.raise_error;

428: IF csr_chk_startup_ele_class%NOTFOUND THEN
429: --
430: CLOSE csr_chk_startup_ele_class;
431: hr_utility.set_message(801, 'PAY_33408_INV_ELE_CLS_FOR_MODE');
432: hr_utility.raise_error;
433: END IF;
434: CLOSE csr_chk_startup_ele_class;
435: --
436: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN

Line 437: hr_utility.set_location(l_proc, 25);

433: END IF;
434: CLOSE csr_chk_startup_ele_class;
435: --
436: ELSIF hr_startup_data_api_support.g_startup_mode = 'USER' THEN
437: hr_utility.set_location(l_proc, 25);
438: IF (p_element_class_usage_id is not null) then
439: l_legislation_code := return_legislation_code(p_element_class_usage_id);
440: ELSE
441: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);

Line 448: hr_utility.set_message(801, 'PAY_33407_ECU_INVALID');

444: FETCH csr_chk_user_ele_class INTO l_exists;
445: IF csr_chk_user_ele_class%NOTFOUND THEN
446: --
447: CLOSE csr_chk_user_ele_class;
448: hr_utility.set_message(801, 'PAY_33407_ECU_INVALID');
449: hr_utility.raise_error;
450: --
451: END IF;
452: CLOSE csr_chk_user_ele_class;

Line 449: hr_utility.raise_error;

445: IF csr_chk_user_ele_class%NOTFOUND THEN
446: --
447: CLOSE csr_chk_user_ele_class;
448: hr_utility.set_message(801, 'PAY_33407_ECU_INVALID');
449: hr_utility.raise_error;
450: --
451: END IF;
452: CLOSE csr_chk_user_ele_class;
453: END IF;

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

512: l_exists varchar2(1);
513: l_proc varchar2(100) := g_package || 'chk_legislation_code';
514: begin
515: --
516: hr_utility.set_location('Entering:'|| l_proc, 10);
517:
518: open csr_legislation_code;
519: fetch csr_legislation_code into l_exists ;
520:

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

524: fnd_message.raise_error;
525: end if;
526: close csr_legislation_code;
527:
528: hr_utility.set_location(' Leaving:'|| l_proc, 20);
529: --
530: exception
531: when app_exception.application_exception then
532: if hr_multi_message.exception_add

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

580: --
581: -- Only proceed with the validation if a row exists for the current
582: -- record in the HR Schema.
583: --
584: hr_utility.set_location('Entering : '||l_proc, 5);
585: IF NOT pay_ecu_shd.api_updating
586: (p_element_class_usage_id => p_rec.element_class_usage_id
587: ,p_effective_date => p_effective_date
588: ,p_object_version_number => p_rec.object_version_number

Line 616: hr_utility.set_location('Leaving : '||l_proc, 100);

612: ,p_argument => 'LEGISLATION_CODE'
613: ,p_base_table => pay_ecu_shd.g_tab_nam
614: );
615: end if;
616: hr_utility.set_location('Leaving : '||l_proc, 100);
617:
618: End chk_non_updateable_args;
619: --
620: -- ----------------------------------------------------------------------------

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

852: l_proc varchar2(72) := g_package||'insert_validate';
853: l_mode varchar2(10);
854: --
855: Begin
856: hr_utility.set_location('Entering:'||l_proc, 5);
857: --
858: -- Call all supporting business operations
859: --
860: --

Line 887: hr_utility.set_location('chk_run_type : '||l_proc,10);

883: END IF;
884: --
885: --
886: -- Validate Dependent Attributes
887: hr_utility.set_location('chk_run_type : '||l_proc,10);
888: if(p_rec.legislation_code is not null) then
889: chk_legislation_code(p_legislation_code => p_rec.legislation_code);
890: end if;
891: --

Line 892: hr_utility.set_location('chk_classification_id : '||l_proc, 15);

888: if(p_rec.legislation_code is not null) then
889: chk_legislation_code(p_legislation_code => p_rec.legislation_code);
890: end if;
891: --
892: hr_utility.set_location('chk_classification_id : '||l_proc, 15);
893: chk_classification_id(p_effective_date => p_effective_date
894: ,p_element_class_usage_id => p_rec.element_class_usage_id
895: ,p_classification_id => p_rec.classification_id
896: ,p_business_group_id => p_rec.business_group_id

Line 900: hr_utility.set_location('chk_run_type : '||l_proc, 20);

896: ,p_business_group_id => p_rec.business_group_id
897: ,p_legislation_code => p_rec.legislation_code);
898:
899:
900: hr_utility.set_location('chk_run_type : '||l_proc, 20);
901: chk_run_type_id(p_effective_date => p_effective_date
902: ,p_element_class_usage_id => p_rec.element_class_usage_id
903: ,p_run_type_id => p_rec.run_type_id
904: ,p_business_group_id => p_rec.business_group_id

Line 908: hr_utility.set_location('chk_classification_id : '|| l_proc, 20);

904: ,p_business_group_id => p_rec.business_group_id
905: ,p_legislation_code => p_rec.legislation_code);
906:
907: --
908: hr_utility.set_location('chk_classification_id : '|| l_proc, 20);
909:
910: --
911: hr_utility.set_location(' Leaving:'||l_proc, 100);
912: End insert_validate;

Line 911: hr_utility.set_location(' Leaving:'||l_proc, 100);

907: --
908: hr_utility.set_location('chk_classification_id : '|| l_proc, 20);
909:
910: --
911: hr_utility.set_location(' Leaving:'||l_proc, 100);
912: End insert_validate;
913: --
914: -- ----------------------------------------------------------------------------
915: -- |---------------------------< update_validate >----------------------------|

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

925: l_proc varchar2(72) := g_package||'update_validate';
926: l_mode varchar2(10);
927: --
928: Begin
929: hr_utility.set_location('Entering:'||l_proc, 5);
930: --
931: -- Call all supporting business operations
932: --
933: --

Line 974: hr_utility.set_location('chk_run_type : '||l_proc,10);

970: (p_effective_date => p_effective_date
971: ,p_rec => p_rec
972: );
973: --
974: hr_utility.set_location('chk_run_type : '||l_proc,10);
975: if(p_rec.legislation_code is not null) then
976: chk_legislation_code(p_legislation_code => p_rec.legislation_code);
977: end if;
978: --

Line 979: hr_utility.set_location('chk_run_type : '||l_proc,15);

975: if(p_rec.legislation_code is not null) then
976: chk_legislation_code(p_legislation_code => p_rec.legislation_code);
977: end if;
978: --
979: hr_utility.set_location('chk_run_type : '||l_proc,15);
980: chk_run_type_id(p_effective_date => p_effective_date
981: ,p_element_class_usage_id => p_rec.element_class_usage_id
982: ,p_run_type_id => p_rec.run_type_id
983: ,p_business_group_id => p_rec.business_group_id

Line 987: hr_utility.set_location('chk_classification_id : '|| l_proc, 20);

983: ,p_business_group_id => p_rec.business_group_id
984: ,p_legislation_code => p_rec.legislation_code);
985:
986: --
987: hr_utility.set_location('chk_classification_id : '|| l_proc, 20);
988: chk_classification_id(p_effective_date => p_effective_date
989: ,p_element_class_usage_id => p_rec.element_class_usage_id
990: ,p_classification_id => p_rec.classification_id
991: ,p_business_group_id => p_rec.business_group_id

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

992: ,p_legislation_code => p_rec.legislation_code);
993:
994: --
995: --
996: hr_utility.set_location(' Leaving:'||l_proc, 10);
997: End update_validate;
998: --
999: -- ----------------------------------------------------------------------------
1000: -- |---------------------------< delete_validate >----------------------------|

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

1009: --
1010: l_proc varchar2(72) := g_package||'delete_validate';
1011: --
1012: Begin
1013: hr_utility.set_location('Entering:'||l_proc, 5);
1014: --
1015: --
1016: chk_startup_action(false
1017: ,pay_ecu_shd.g_old_rec.business_group_id

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

1038: ,p_validation_end_date => p_validation_end_date
1039: ,p_element_class_usage_id => p_rec.element_class_usage_id
1040: );
1041: --
1042: hr_utility.set_location(' Leaving:'||l_proc, 10);
1043: End delete_validate;
1044: --
1045: end pay_ecu_bus;