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

Line 45: g_debug := hr_utility.debug_enabled;

41:
42: --
43: BEGIN
44: --
45: g_debug := hr_utility.debug_enabled;
46:
47: l_proc := g_package||'get_gre_loc';
48:
49: IF g_debug THEN

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

46:
47: l_proc := g_package||'get_gre_loc';
48:
49: IF g_debug THEN
50: hr_utility.set_location('Entering:'|| l_proc, 10);
51: END IF;
52:
53: OPEN csr_get_gre_location;
54: FETCH csr_get_gre_location INTO l_location_id, l_scl_gre;

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

57: hr_mx_assignment_api.g_old_location := l_location_id;
58: hr_mx_assignment_api.g_old_gre := l_scl_gre;
59:
60: IF g_debug THEN
61: hr_utility.set_location('Leaving: '||l_proc, 20);
62: END IF;
63: --
64: END get_gre_loc;
65:

Line 112: g_debug := hr_utility.debug_enabled;

108: AND rownum < 2;
109: --
110: BEGIN
111: --
112: g_debug := hr_utility.debug_enabled;
113:
114: l_proc := g_package||'chk_loc_gre_for_leav_reason';
115:
116: IF g_debug THEN

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

113:
114: l_proc := g_package||'chk_loc_gre_for_leav_reason';
115:
116: IF g_debug THEN
117: hr_utility.set_location('Entering:'|| l_proc, 10);
118: END IF;
119:
120: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
121:

Line 120: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN

116: IF g_debug THEN
117: hr_utility.set_location('Entering:'|| l_proc, 10);
118: END IF;
119:
120: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
121:
122: IF g_debug THEN
123: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
124: END IF;

Line 123: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');

119:
120: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
121:
122: IF g_debug THEN
123: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
124: END IF;
125: RETURN;
126: END IF;
127:

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

142: FETCH csr_fetch_bg INTO l_bg_id;
143: CLOSE csr_fetch_bg;
144:
145: IF g_debug THEN
146: hr_utility.set_location(l_proc, 20);
147: END IF;
148:
149: ---------------------
150: -- Fetch the Old GRE.

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

158: l_dummy2)
159: );
160:
161: IF g_debug THEN
162: hr_utility.set_location(l_proc, 30);
163: END IF;
164:
165: --------------------------------------------------------------------------
166: -- Use the old location and old SCL GRE values, if the parameters are

Line 176: hr_utility.set_location(l_proc, 35);

172: l_location_id
173: FROM DUAL;
174:
175: IF g_debug THEN
176: hr_utility.set_location(l_proc, 35);
177: END IF;
178:
179: --------------------------------------------------------------------------
180: -- Determine the NEW gre for the given assignment_id.

Line 192: hr_utility.set_location(l_proc, 40);

188: l_dummy2)
189: );
190:
191: IF g_debug THEN
192: hr_utility.set_location(l_proc, 40);
193: END IF;
194:
195: --------------------------------------------------------------------------
196: -- Check the new GRE and compare with old GRE and location to determine

Line 210: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');

206: -- raise an error. Else, insert an Assignment EIT record using the API.
207: --------------------------------------------------------------------------
208: IF hr_mx_assignment_api.g_leaving_reason IS NULL THEN
209:
210: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');
211: -- hr_utility.raise_error;
212: null;
213:
214: ELSE

Line 211: -- hr_utility.raise_error;

207: --------------------------------------------------------------------------
208: IF hr_mx_assignment_api.g_leaving_reason IS NULL THEN
209:
210: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');
211: -- hr_utility.raise_error;
212: null;
213:
214: ELSE
215:

Line 221: hr_utility.set_location(l_proc, 50);

217: FETCH csr_fetch_bg INTO l_bg_id;
218: CLOSE csr_fetch_bg;
219:
220: IF g_debug THEN
221: hr_utility.set_location(l_proc, 50);
222: END IF;
223:
224: fnd_profile.put('PER_BUSINESS_GROUP_ID', l_bg_id);
225:

Line 238: hr_utility.set_location(l_proc, 60);

234: p_object_version_number => l_dummy4
235: );
236:
237: IF g_debug THEN
238: hr_utility.set_location(l_proc, 60);
239: END IF;
240:
241: hr_mx_assignment_api.g_leaving_reason := null;
242:

Line 248: hr_utility.set_location('Leaving: '||l_proc, 70);

244:
245: END IF;
246:
247: IF g_debug THEN
248: hr_utility.set_location('Leaving: '||l_proc, 70);
249: END IF;
250:
251: --
252: END chk_loc_gre_for_leav_reason;

Line 297: g_debug := hr_utility.debug_enabled;

293: AND rownum < 2;
294: --
295: BEGIN
296: --
297: g_debug := hr_utility.debug_enabled;
298:
299: l_proc := g_package||'chk_gre_for_leav_reason';
300:
301: IF g_debug THEN

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

298:
299: l_proc := g_package||'chk_gre_for_leav_reason';
300:
301: IF g_debug THEN
302: hr_utility.set_location('Entering:'|| l_proc, 10);
303: END IF;
304:
305: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
306:

Line 305: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN

301: IF g_debug THEN
302: hr_utility.set_location('Entering:'|| l_proc, 10);
303: END IF;
304:
305: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
306:
307: IF g_debug THEN
308: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
309: END IF;

Line 308: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');

304:
305: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
306:
307: IF g_debug THEN
308: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
309: END IF;
310: RETURN;
311: END IF;
312:

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

331: FETCH csr_fetch_bg INTO l_bg_id;
332: CLOSE csr_fetch_bg;
333:
334: IF g_debug THEN
335: hr_utility.set_location(l_proc, 20);
336: END IF;
337:
338: l_gre_old := nvl( to_number(l_scl_gre),
339:

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

344: l_dummy2)
345: );
346:
347: IF g_debug THEN
348: hr_utility.set_location(l_proc, 30);
349: END IF;
350:
351: --------------------------------------------------------------------------
352: -- Use the old SCL GRE value, if the value of p_segment1 is system

Line 360: hr_utility.set_location(l_proc, 35);

356: INTO l_segment1
357: FROM DUAL;
358:
359: IF g_debug THEN
360: hr_utility.set_location(l_proc, 35);
361: END IF;
362:
363: --------------------------------------------------------------------------
364: -- Determine the NEW gre for the given assignment_id.

Line 392: hr_utility.set_location(l_proc, 40);

388: --------------------------------------------------------------------------
389: IF hr_mx_assignment_api.g_leaving_reason IS NULL THEN
390:
391: IF g_debug THEN
392: hr_utility.set_location(l_proc, 40);
393: END IF;
394:
395: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');
396: -- hr_utility.raise_error;

Line 395: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');

391: IF g_debug THEN
392: hr_utility.set_location(l_proc, 40);
393: END IF;
394:
395: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');
396: -- hr_utility.raise_error;
397: null;
398:
399: ELSE

Line 396: -- hr_utility.raise_error;

392: hr_utility.set_location(l_proc, 40);
393: END IF;
394:
395: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');
396: -- hr_utility.raise_error;
397: null;
398:
399: ELSE
400:

Line 402: hr_utility.set_location(l_proc, 50);

398:
399: ELSE
400:
401: IF g_debug THEN
402: hr_utility.set_location(l_proc, 50);
403: END IF;
404:
405: fnd_profile.put('PER_BUSINESS_GROUP_ID', l_bg_id);
406:

Line 421: hr_utility.set_location(l_proc, 60);

417:
418: hr_mx_assignment_api.g_leaving_reason := null;
419:
420: IF g_debug THEN
421: hr_utility.set_location(l_proc, 60);
422: END IF;
423:
424: END IF;
425:

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

425:
426: END IF;
427:
428: IF g_debug THEN
429: hr_utility.set_location('Leaving: '||l_proc, 70);
430: END IF;
431:
432: END chk_gre_for_leav_reason;
433:

Line 474: g_debug := hr_utility.debug_enabled;

470: AND rownum < 2;
471: --
472: BEGIN
473: --
474: g_debug := hr_utility.debug_enabled;
475:
476: l_proc := g_package||'chk_leav_reason_for_del_asg';
477: IF g_debug THEN
478: hr_utility.set_location('Entering:'|| l_proc, 10);

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

474: g_debug := hr_utility.debug_enabled;
475:
476: l_proc := g_package||'chk_leav_reason_for_del_asg';
477: IF g_debug THEN
478: hr_utility.set_location('Entering:'|| l_proc, 10);
479: END IF;
480:
481: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
482:

Line 481: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN

477: IF g_debug THEN
478: hr_utility.set_location('Entering:'|| l_proc, 10);
479: END IF;
480:
481: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
482:
483: IF g_debug THEN
484: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
485: END IF;

Line 484: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');

480:
481: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
482:
483: IF g_debug THEN
484: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
485: END IF;
486: RETURN;
487: END IF;
488:

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

513: fnd_profile.put('PER_BUSINESS_GROUP_ID', l_bg_id);
514:
515:
516: IF g_debug THEN
517: hr_utility.set_location(l_proc, 20);
518: END IF;
519:
520: --------------------------------------------------------------------------
521: -- Fetch the GRE for the assignment record being deleted.

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

529: l_dummy2)
530: );
531:
532: IF g_debug THEN
533: hr_utility.set_location(l_proc, 30);
534: END IF;
535:
536: --------------------------------------------------------------------------
537: -- Check the leaving reason Global Variable. If it's null,

Line 543: hr_utility.set_location(l_proc, 40);

539: --------------------------------------------------------------------------
540: IF hr_mx_assignment_api.g_leaving_reason IS NULL THEN
541:
542: IF g_debug THEN
543: hr_utility.set_location(l_proc, 40);
544: END IF;
545:
546: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');
547: -- hr_utility.raise_error;

Line 546: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');

542: IF g_debug THEN
543: hr_utility.set_location(l_proc, 40);
544: END IF;
545:
546: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');
547: -- hr_utility.raise_error;
548: null;
549:
550: ELSE

Line 547: -- hr_utility.raise_error;

543: hr_utility.set_location(l_proc, 40);
544: END IF;
545:
546: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');
547: -- hr_utility.raise_error;
548: null;
549:
550: ELSE
551:

Line 553: hr_utility.set_location(l_proc, 50);

549:
550: ELSE
551:
552: IF g_debug THEN
553: hr_utility.set_location(l_proc, 50);
554: END IF;
555:
556: hr_assignment_extra_info_api.create_assignment_extra_info
557: (p_assignment_id => p_assignment_id,

Line 570: hr_utility.set_location(l_proc, 60);

566:
567: hr_mx_assignment_api.g_leaving_reason := null;
568:
569: IF g_debug THEN
570: hr_utility.set_location(l_proc, 60);
571: END IF;
572:
573: END IF;
574:

Line 576: hr_utility.set_location('Leaving: '||l_proc, 70);

572:
573: END IF;
574:
575: IF g_debug THEN
576: hr_utility.set_location('Leaving: '||l_proc, 70);
577: END IF;
578:
579: --
580: END chk_leav_reason_for_del_asg;

Line 609: g_debug := hr_utility.debug_enabled;

605: ld_effective_date DATE;
606: --
607: BEGIN
608: --
609: g_debug := hr_utility.debug_enabled;
610: l_dummy := p_object_version_number;
611:
612: l_proc := g_package||'chk_leav_reason_for_del_emp';
613: IF g_debug THEN

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

610: l_dummy := p_object_version_number;
611:
612: l_proc := g_package||'chk_leav_reason_for_del_emp';
613: IF g_debug THEN
614: hr_utility.set_location('Entering:'|| l_proc, 10);
615: END IF;
616:
617: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
618:

Line 617: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN

613: IF g_debug THEN
614: hr_utility.set_location('Entering:'|| l_proc, 10);
615: END IF;
616:
617: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
618:
619: IF g_debug THEN
620: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
621: END IF;

Line 620: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');

616:
617: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
618:
619: IF g_debug THEN
620: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
621: END IF;
622: RETURN;
623: END IF;
624:

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

628: --------------------------------------------------------------------------
629: IF hr_mx_assignment_api.g_leaving_reason IS NULL THEN
630:
631: IF g_debug THEN
632: hr_utility.set_location(l_proc, 20);
633: END IF;
634:
635: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');
636: -- hr_utility.raise_error;

Line 635: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');

631: IF g_debug THEN
632: hr_utility.set_location(l_proc, 20);
633: END IF;
634:
635: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');
636: -- hr_utility.raise_error;
637: null;
638:
639: ELSE

Line 636: -- hr_utility.raise_error;

632: hr_utility.set_location(l_proc, 20);
633: END IF;
634:
635: -- hr_utility.set_message(800,'HR_MX_MISSING_LEAVING_REASON');
636: -- hr_utility.raise_error;
637: null;
638:
639: ELSE
640:

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

638:
639: ELSE
640:
641: IF g_debug THEN
642: hr_utility.set_location(l_proc, 30);
643: END IF;
644:
645: BEGIN
646:

Line 671: hr_utility.set_location(l_proc, 40);

667:
668: hr_mx_assignment_api.g_leaving_reason := null;
669:
670: IF g_debug THEN
671: hr_utility.set_location(l_proc, 40);
672: END IF;
673:
674: END IF;
675:

Line 677: hr_utility.set_location('Leaving: '||l_proc, 50);

673:
674: END IF;
675:
676: IF g_debug THEN
677: hr_utility.set_location('Leaving: '||l_proc, 50);
678: END IF;
679:
680: --
681: END chk_leav_reason_for_del_emp;