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

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

28: l_api_updating boolean;
29: l_valid varchar2(1);
30: --
31: Begin
32: hr_utility.set_location('Entering:'||l_proc, 5);
33: open csr_get_template_info;
34: fetch csr_get_template_info
35: into p_business_group_id
36: , p_template_type;

Line 38: hr_utility.set_location(' Leaving:'||l_proc, 15);

34: fetch csr_get_template_info
35: into p_business_group_id
36: , p_template_type;
37: close csr_get_template_info;
38: hr_utility.set_location(' Leaving:'||l_proc, 15);
39: End get_template_info;
40: -- ----------------------------------------------------------------------------
41: -- |-----------------------< chk_non_updateable_args >------------------------|
42: -- ----------------------------------------------------------------------------

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

67: l_argument varchar2(30);
68: l_disallow varchar2(1);
69: --
70: Begin
71: hr_utility.set_location('Entering:'||l_proc, 5);
72: l_api_updating := pay_sbt_shd.api_updating
73: (p_balance_type_id => p_rec.balance_type_id
74: ,p_object_version_number => p_rec.object_version_number
75: );

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

73: (p_balance_type_id => p_rec.balance_type_id
74: ,p_object_version_number => p_rec.object_version_number
75: );
76: if not l_api_updating then
77: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
78: hr_utility.set_message_token('PROCEDURE', l_proc);
79: hr_utility.set_message_token('STEP', '10');
80: hr_utility.raise_error;
81: end if;

Line 78: hr_utility.set_message_token('PROCEDURE', l_proc);

74: ,p_object_version_number => p_rec.object_version_number
75: );
76: if not l_api_updating then
77: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
78: hr_utility.set_message_token('PROCEDURE', l_proc);
79: hr_utility.set_message_token('STEP', '10');
80: hr_utility.raise_error;
81: end if;
82: --

Line 79: hr_utility.set_message_token('STEP', '10');

75: );
76: if not l_api_updating then
77: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
78: hr_utility.set_message_token('PROCEDURE', l_proc);
79: hr_utility.set_message_token('STEP', '10');
80: hr_utility.raise_error;
81: end if;
82: --
83: hr_utility.set_location(l_proc, 20);

Line 80: hr_utility.raise_error;

76: if not l_api_updating then
77: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
78: hr_utility.set_message_token('PROCEDURE', l_proc);
79: hr_utility.set_message_token('STEP', '10');
80: hr_utility.raise_error;
81: end if;
82: --
83: hr_utility.set_location(l_proc, 20);
84: --

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

79: hr_utility.set_message_token('STEP', '10');
80: hr_utility.raise_error;
81: end if;
82: --
83: hr_utility.set_location(l_proc, 20);
84: --
85: -- Check that the update is actually allowed.
86: --
87: open csr_disallow_update;

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

86: --
87: open csr_disallow_update;
88: fetch csr_disallow_update into l_disallow;
89: if csr_disallow_update%found then
90: hr_utility.set_location(l_proc, 25);
91: close csr_disallow_update;
92: fnd_message.set_name('PAY', 'PAY_50113_SBT_CORE_ROW_EXISTS');
93: fnd_message.raise_error;
94: end if;

Line 135: hr_utility.set_location('Leaving:'||l_proc, 25);

131: l_argument := 'input_value_id';
132: raise l_error;
133: end if;
134: --
135: hr_utility.set_location('Leaving:'||l_proc, 25);
136: exception
137: when l_error then
138: hr_utility.set_location('Leaving:'||l_proc, 30);
139: hr_api.argument_changed_error

Line 138: hr_utility.set_location('Leaving:'||l_proc, 30);

134: --
135: hr_utility.set_location('Leaving:'||l_proc, 25);
136: exception
137: when l_error then
138: hr_utility.set_location('Leaving:'||l_proc, 30);
139: hr_api.argument_changed_error
140: (p_api_name => l_proc
141: ,p_argument => l_argument);
142: when others then

Line 143: hr_utility.set_location('Leaving:'||l_proc, 35);

139: hr_api.argument_changed_error
140: (p_api_name => l_proc
141: ,p_argument => l_argument);
142: when others then
143: hr_utility.set_location('Leaving:'||l_proc, 35);
144: raise;
145: End chk_non_updateable_args;
146: -- ----------------------------------------------------------------------------
147: -- |---------------------------< chk_template_id >----------------------------|

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

160: l_proc varchar2(72) := g_package||'chk_template_id';
161: l_valid varchar2(1);
162: --
163: Begin
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: -- Check that template_id is not null.
167: --
168: hr_api.mandatory_arg_error

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

175: --
176: open csr_template_id_valid;
177: fetch csr_template_id_valid into l_valid;
178: if csr_template_id_valid%notfound then
179: hr_utility.set_location(' Leaving:'||l_proc, 10);
180: close csr_template_id_valid;
181: fnd_message.set_name('PAY', 'PAY_50114_ETM_INVALID_TEMPLATE');
182: fnd_message.raise_error;
183: end if;

Line 185: hr_utility.set_location(' Leaving:'||l_proc, 15);

181: fnd_message.set_name('PAY', 'PAY_50114_ETM_INVALID_TEMPLATE');
182: fnd_message.raise_error;
183: end if;
184: close csr_template_id_valid;
185: hr_utility.set_location(' Leaving:'||l_proc, 15);
186: End chk_template_id;
187: -- ----------------------------------------------------------------------------
188: -- |---------------------------< chk_balance_name >---------------------------|
189: -- ----------------------------------------------------------------------------

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

226: l_nullok varchar2(2000);
227: l_api_updating boolean;
228: --
229: Begin
230: hr_utility.set_location('Entering:'||l_proc, 5);
231: l_api_updating := pay_sbt_shd.api_updating
232: (p_balance_type_id => p_balance_type_id
233: ,p_object_version_number => p_object_version_number
234: );

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

275: open csr_T_balance_name_exists;
276: fetch csr_T_balance_name_exists into l_exists;
277: if csr_T_balance_name_exists%found then
278: close csr_T_balance_name_exists;
279: hr_utility.set_location(' Leaving:'||l_proc, 10);
280: fnd_message.set_name('PAY', 'PAY_50115_SBT_BALANCE_EXISTS');
281: fnd_message.set_token('BALANCE_NAME', p_balance_name);
282: fnd_message.raise_error;
283: end if;

Line 293: hr_utility.set_location(' Leaving:'||l_proc, 15);

289: open csr_U_balance_name_exists;
290: fetch csr_U_balance_name_exists into l_exists;
291: if csr_U_balance_name_exists%found then
292: close csr_U_balance_name_exists;
293: hr_utility.set_location(' Leaving:'||l_proc, 15);
294: fnd_message.set_name('PAY', 'PAY_50115_SBT_BALANCE_EXISTS');
295: fnd_message.set_token('BALANCE_NAME', p_balance_name);
296: fnd_message.raise_error;
297: end if;

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

297: end if;
298: close csr_U_balance_name_exists;
299: end if;
300: end if;
301: hr_utility.set_location(' Leaving:'||l_proc, 20);
302: End chk_balance_name;
303: -- ----------------------------------------------------------------------------
304: -- |----------------------< chk_asg_remuneration_flag >-----------------------|
305: -- ----------------------------------------------------------------------------

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

313: l_proc varchar2(72) := g_package||'chk_asg_remuneration_flag';
314: l_api_updating boolean;
315: --
316: Begin
317: hr_utility.set_location('Entering:'||l_proc, 5);
318: l_api_updating := pay_sbt_shd.api_updating
319: (p_balance_type_id => p_balance_type_id
320: ,p_object_version_number => p_object_version_number
321: );

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

341: ,p_lookup_type => 'YES_NO'
342: ,p_lookup_code => p_assignment_remuneration_flag
343: )
344: then
345: hr_utility.set_location(' Leaving:'||l_proc, 10);
346: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
347: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
348: fnd_message.set_token('COLUMN', 'ASSIGNMENT_REMUNERATION_FLAG');
349: fnd_message.raise_error;

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

348: fnd_message.set_token('COLUMN', 'ASSIGNMENT_REMUNERATION_FLAG');
349: fnd_message.raise_error;
350: end if;
351: end if;
352: hr_utility.set_location(' Leaving:'||l_proc, 20);
353: End chk_asg_remuneration_flag;
354: -- ----------------------------------------------------------------------------
355: -- |--------------------------< chk_balance_uom >-----------------------------|
356: -- ----------------------------------------------------------------------------

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

374: where siv.input_value_id = p_input_value_id
375: and upper(siv.uom) = upper(p_balance_uom);
376: --
377: Begin
378: hr_utility.set_location('Entering:'||l_proc, 5);
379: l_api_updating := pay_sbt_shd.api_updating
380: (p_balance_type_id => p_balance_type_id
381: ,p_object_version_number => p_object_version_number
382: );

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

400: ,p_lookup_type => 'UNITS'
401: ,p_lookup_code => p_balance_uom
402: )
403: then
404: hr_utility.set_location(' Leaving:'||l_proc, 10);
405: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
406: fnd_message.set_token('LOOKUP_TYPE', 'UNITS');
407: fnd_message.set_token('COLUMN', 'BALANCE_UOM');
408: fnd_message.raise_error;

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

417: --
418: open csr_chk_uom;
419: fetch csr_chk_uom into l_exists;
420: if csr_chk_uom%notfound then
421: hr_utility.set_location(' Leaving:'||l_proc, 10);
422: close csr_chk_uom;
423: fnd_message.set_name('PAY', 'PAY_51522_SBT_UOM_MISMATCH');
424: fnd_message.raise_error;
425: end if;

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

425: end if;
426: close csr_chk_uom;
427: end if;
428: --
429: hr_utility.set_location(' Leaving:'||l_proc, 20);
430: End chk_balance_uom;
431: -- ----------------------------------------------------------------------------
432: -- |-----------------------------< chk_currency_code >------------------------|
433: -- ----------------------------------------------------------------------------

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

450: l_api_updating boolean;
451: l_valid varchar2(1);
452: --
453: Begin
454: hr_utility.set_location('Entering:'||l_proc, 5);
455: l_api_updating := pay_sbt_shd.api_updating
456: (p_balance_type_id => p_balance_type_id
457: ,p_object_version_number => p_object_version_number
458: );

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

463: if p_currency_code is not null then
464: open csr_valid_currency_code;
465: fetch csr_valid_currency_code into l_valid;
466: if csr_valid_currency_code%notfound then
467: hr_utility.set_location(' Leaving:'||l_proc, 10);
468: close csr_valid_currency_code;
469: fnd_message.set_name('PAY', 'HR_51855_QUA_CCY_INV');
470: fnd_message.raise_error;
471: end if;

Line 474: hr_utility.set_location(' Leaving:'||l_proc, 15);

470: fnd_message.raise_error;
471: end if;
472: close csr_valid_currency_code;
473: end if;
474: hr_utility.set_location(' Leaving:'||l_proc, 15);
475: end if;
476: End chk_currency_code;
477: -- ----------------------------------------------------------------------------
478: -- |-------------------------< chk_exclusion_rule_id >------------------------|

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

496: l_api_updating boolean;
497: l_valid varchar2(1);
498: --
499: Begin
500: hr_utility.set_location('Entering:'||l_proc, 5);
501: l_api_updating := pay_sbt_shd.api_updating
502: (p_balance_type_id => p_balance_type_id
503: ,p_object_version_number => p_object_version_number
504: );

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

509: if p_exclusion_rule_id is not null then
510: open csr_exclusion_rule_id_valid;
511: fetch csr_exclusion_rule_id_valid into l_valid;
512: if csr_exclusion_rule_id_valid%notfound then
513: hr_utility.set_location('Leaving:'||l_proc, 10);
514: close csr_exclusion_rule_id_valid;
515: fnd_message.set_name('PAY', 'PAY_50100_ETM_INVALID_EXC_RULE');
516: fnd_message.raise_error;
517: end if;

Line 521: hr_utility.set_location(' Leaving:'||l_proc, 15);

517: end if;
518: close csr_exclusion_rule_id_valid;
519: end if;
520: end if;
521: hr_utility.set_location(' Leaving:'||l_proc, 15);
522: End chk_exclusion_rule_id;
523: -- ----------------------------------------------------------------------------
524: -- |-----------------------< chk_base_balance_type_id >-----------------------|
525: -- ----------------------------------------------------------------------------

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

547: start with balance_type_id = p_base_balance_type_id
548: connect by prior base_balance_type_id = balance_type_id
549: ;
550: Begin
551: hr_utility.set_location('Entering: '||l_proc, 5);
552: --
553: l_api_updating := pay_sbt_shd.api_updating
554: (p_balance_type_id => p_balance_type_id
555: ,p_object_version_number => p_object_version_number

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

575: --
576: open csr_chk_template;
577: fetch csr_chk_template into l_exists;
578: if csr_chk_template%notfound then
579: hr_utility.set_location(' Leaving:'||l_proc, 20);
580: close csr_chk_template;
581: fnd_message.set_name('PAY', 'PAY_51524_SBT_INVALID_BASENAME');
582: fnd_message.raise_error;
583: end if;

Line 605: hr_utility.set_location(' Leaving:'||l_proc, 30);

601: end loop;
602: end if;
603: end if;
604: end if;
605: hr_utility.set_location(' Leaving:'||l_proc, 30);
606: End chk_base_balance_type_id;
607: -- ----------------------------------------------------------------------------
608: -- |---------------------------< chk_input_value_id >-------------------------|
609: -- ----------------------------------------------------------------------------

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

634: l_proc varchar2(72) := g_package||'chk_input_value_id';
635: l_exists varchar2(1);
636: --
637: Begin
638: hr_utility.set_location('Entering:'||l_proc, 5);
639: --
640: -- Check that the input value exists.
641: --
642: if p_input_value_id is not null then

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

642: if p_input_value_id is not null then
643: open csr_input_value_exists;
644: fetch csr_input_value_exists into l_exists;
645: if csr_input_value_exists%notfound then
646: hr_utility.set_location(' Leaving:'||l_proc, 10);
647: close csr_input_value_exists;
648: fnd_message.set_name('PAY', 'PAY_50098_ETM_INVALID_INP_VAL');
649: fnd_message.raise_error;
650: end if;

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

654: --
655: open csr_chk_uom;
656: fetch csr_chk_uom into l_exists;
657: if csr_chk_uom%notfound then
658: hr_utility.set_location(' Leaving:'||l_proc, 10);
659: close csr_chk_uom;
660: fnd_message.set_name('PAY', 'PAY_51522_SBT_UOM_MISMATCH');
661: fnd_message.raise_error;
662: end if;

Line 666: hr_utility.set_location(' Leaving:'||l_proc, 15);

662: end if;
663: close csr_chk_uom;
664: end if;
665: --
666: hr_utility.set_location(' Leaving:'||l_proc, 15);
667: End chk_input_value_id;
668: -- ----------------------------------------------------------------------------
669: -- |------------------------------< chk_delete >------------------------------|
670: -- ----------------------------------------------------------------------------

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

709: l_error exception;
710: l_exists varchar2(1);
711: --
712: Begin
713: hr_utility.set_location('Entering:'||l_proc, 5);
714: --
715: open csr_defined_balances;
716: fetch csr_defined_balances into l_exists;
717: if csr_defined_balances%found then

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

714: --
715: open csr_defined_balances;
716: fetch csr_defined_balances into l_exists;
717: if csr_defined_balances%found then
718: hr_utility.set_location(' Leaving:'||l_proc, 10);
719: close csr_defined_balances;
720: raise l_error;
721: end if;
722: close csr_defined_balances;

Line 727: hr_utility.set_location(' Leaving:'||l_proc, 15);

723: --
724: open csr_core_objects;
725: fetch csr_core_objects into l_exists;
726: if csr_core_objects%found then
727: hr_utility.set_location(' Leaving:'||l_proc, 15);
728: close csr_core_objects;
729: raise l_error;
730: end if;
731: close csr_core_objects;

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

732: --
733: open csr_balance_feeds;
734: fetch csr_balance_feeds into l_exists;
735: if csr_balance_feeds%found then
736: hr_utility.set_location(' Leaving:'||l_proc, 20);
737: close csr_balance_feeds;
738: raise l_error;
739: end if;
740: close csr_balance_feeds;

Line 745: hr_utility.set_location(' Leaving:'||l_proc, 25);

741: --
742: open csr_balance_classis;
743: fetch csr_balance_classis into l_exists;
744: if csr_balance_classis%found then
745: hr_utility.set_location(' Leaving:'||l_proc, 25);
746: close csr_balance_classis;
747: raise l_error;
748: end if;
749: close csr_balance_classis;

Line 754: hr_utility.set_location(' Leaving:'||l_proc, 30);

750: --
751: open csr_gu_bal_exclusions;
752: fetch csr_gu_bal_exclusions into l_exists;
753: if csr_gu_bal_exclusions%found then
754: hr_utility.set_location(' Leaving:'||l_proc, 30);
755: close csr_gu_bal_exclusions;
756: raise l_error;
757: end if;
758: close csr_gu_bal_exclusions;

Line 763: hr_utility.set_location(' Leaving:'||l_proc, 35);

759: --
760: open csr_balance_types;
761: fetch csr_balance_types into l_exists;
762: if csr_balance_types%found then
763: hr_utility.set_location(' Leaving:'||l_proc, 35);
764: close csr_balance_types;
765: raise l_error;
766: end if;
767: close csr_balance_types;

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

764: close csr_balance_types;
765: raise l_error;
766: end if;
767: close csr_balance_types;
768: hr_utility.set_location(' Leaving:'||l_proc, 100);
769: exception
770: when l_error then
771: fnd_message.set_name('PAY', 'PAY_50117_SBT_INVALID_DELETE');
772: fnd_message.raise_error;

Line 774: hr_utility.set_location(' Leaving:'||l_proc, 110);

770: when l_error then
771: fnd_message.set_name('PAY', 'PAY_50117_SBT_INVALID_DELETE');
772: fnd_message.raise_error;
773: when others then
774: hr_utility.set_location(' Leaving:'||l_proc, 110);
775: raise;
776: End chk_delete;
777: -- ----------------------------------------------------------------------------
778: -- |---------------------------< insert_validate >----------------------------|

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

786: l_business_group_id number;
787: l_template_type varchar2(2000);
788: --
789: Begin
790: hr_utility.set_location('Entering:'||l_proc, 5);
791: --
792: -- Call all supporting business operations
793: --
794: chk_template_id(p_rec.template_id);

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

849: ,p_balance_uom => p_rec.balance_uom
850: ,p_template_id => p_rec.template_id
851: );
852: --
853: hr_utility.set_location(' Leaving:'||l_proc, 10);
854: End insert_validate;
855: --
856: -- ----------------------------------------------------------------------------
857: -- |---------------------------< update_validate >----------------------------|

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

865: l_business_group_id number;
866: l_template_type varchar2(2000);
867: --
868: Begin
869: hr_utility.set_location('Entering:'||l_proc, 5);
870: --
871: -- Call all supporting business operations
872: --
873: chk_non_updateable_args(p_rec);

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

922: ,p_balance_type_id => p_rec.balance_type_id
923: ,p_object_version_number => p_rec.object_version_number
924: );
925: --
926: hr_utility.set_location(' Leaving:'||l_proc, 10);
927: End update_validate;
928: --
929: -- ----------------------------------------------------------------------------
930: -- |---------------------------< delete_validate >----------------------------|

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

933: --
934: l_proc varchar2(72) := g_package||'delete_validate';
935: --
936: Begin
937: hr_utility.set_location('Entering:'||l_proc, 5);
938: --
939: -- Call all supporting business operations
940: --
941: chk_delete(p_rec.balance_type_id);

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

939: -- Call all supporting business operations
940: --
941: chk_delete(p_rec.balance_type_id);
942: --
943: hr_utility.set_location(' Leaving:'||l_proc, 10);
944: End delete_validate;
945: --
946: end pay_sbt_bus;