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.HXT_GEN_AAI dependencies on HXT_GEN_AAI

Line 1: PACKAGE BODY HXT_GEN_AAI AS

1: PACKAGE BODY HXT_GEN_AAI AS
2: /* $Header: hxtgenai.pkb 120.3.12010000.4 2009/09/29 11:26:09 asrajago ship $ */
3:
4: -------------------------------------------------------------------------------
5:

Line 216: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',10);

212: BEGIN
213:
214: g_debug :=hr_utility.debug_enabled;
215: if g_debug then
216: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',10);
217: end if;
218:
219: /* Get the assignment business group id */
220: OPEN c_asg_bus_grp_id;

Line 232: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',20);

228: /* IF AUTOGEN_HOURS_YN is 'Y', then ROTATION_PLAN_NAME is required */
229: IF p_autogen_hours_yn = 'Y' and p_rotation_plan IS NULL THEN
230: --
231: if g_debug then
232: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',20);
233: end if;
234: -- FND_MESSAGE.SET_NAME('HXT','HXT_39496_ROT_PLAN_REQD');
235: -- FND_MESSAGE.ERROR;
236: hr_utility.set_message(809, 'HXT_39496_ROT_PLAN_REQD');

Line 244: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',25);

240:
241: /* Check for rotation plan */
242: IF p_rotation_plan is NOT NULL THEN
243: if g_debug then
244: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',25);
245: end if;
246: OPEN chk_rot_plan;
247: FETCH chk_rot_plan INTO l_rtp_compatible;
248: CLOSE chk_rot_plan;

Line 252: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',30);

248: CLOSE chk_rot_plan;
249: IF l_rtp_compatible IS NULL THEN
250: --
251: if g_debug then
252: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',30);
253: end if;
254: -- FND_MESSAGE.SET_NAME('HXT','HXT_xxxxx_ROT_PLAN_ERR');
255: -- FND_MESSAGE.ERROR;
256: hr_utility.set_message(809, 'HXT_xxxxx_ROT_PLAN_ERR');

Line 273: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',40);

269: CLOSE chk_earning_policy;
270: IF l_egp_compatible IS NULL THEN
271: --
272: if g_debug then
273: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',40);
274: end if;
275: -- FND_MESSAGE.SET_NAME('HXT','HXT_xxxxx_EARN_POL_ERR');
276: -- FND_MESSAGE.ERROR;
277: hr_utility.set_message(809,'HXT_xxxxx_EARN_POL_ERR');

Line 285: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',45);

281:
282: /* Check whether Shift Differential Policy and Assignment are compatible */
283: IF p_shift_differential_policy is NOT NULL THEN
284: if g_debug then
285: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',45);
286: end if;
287: OPEN chk_shift_diff_policy;
288: FETCH chk_shift_diff_policy into l_sdp_compatible;
289: CLOSE chk_shift_diff_policy;

Line 293: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',50);

289: CLOSE chk_shift_diff_policy;
290: IF l_sdp_compatible IS NULL THEN
291: --
292: if g_debug then
293: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',50);
294: end if;
295: -- FND_MESSAGE.SET_NAME('HXT','HXT_xxxxx_SDP_ERR');
296: -- FND_MESSAGE.ERROR;
297: hr_utility.set_message(809,'HXT_xxxxx_SDP_ERR');

Line 306: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',55);

302:
303: /* Check whether Hour Deduction Policy and Assignment are compatible */
304: IF p_hour_deduction_policy is NOT NULL THEN
305: if g_debug then
306: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',55);
307: end if;
308: OPEN chk_hour_deduct_policy;
309: FETCH chk_hour_deduct_policy into l_hdp_compatible;
310: CLOSE chk_hour_deduct_policy;

Line 314: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',60);

310: CLOSE chk_hour_deduct_policy;
311: IF l_hdp_compatible IS NULL THEN
312: --
313: if g_debug then
314: hr_utility.set_location('HXT_GEN_AAI.AAI_VALIDATIONS',60);
315: end if;
316: -- FND_MESSAGE.SET_NAME('HXT','HXT_xxxxx_HDP_ERR');
317: -- FND_MESSAGE.ERROR;
318: hr_utility.set_message(809,'HXT_xxxxx_HDP_ERR');

Line 414: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',10);

410:
411: BEGIN
412: g_debug :=hr_utility.debug_enabled;
413: if g_debug then
414: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',10);
415: end if;
416:
417: /* First, make sure AAI row doesn't already exist for this assignment */
418: OPEN dup_aai;

Line 422: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',20);

418: OPEN dup_aai;
419: FETCH dup_aai into l_duplicate_row;
420: IF dup_aai%FOUND THEN
421: if g_debug then
422: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',20);
423: end if;
424: -- FND_MESSAGE.SET_NAME('HXT','HXT_39481_INFO_EXST_FOR_ASSIGN');
425: -- FND_MESSAGE.Error;
426: hr_utility.set_message(809,'HXT_39481_INFO_EXST_FOR_ASSIGN');

Line 433: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',30);

429: END IF;
430: CLOSE dup_aai;
431:
432: if g_debug then
433: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',30);
434: end if;
435: HXT_GEN_AAI.AAI_VALIDATIONS
436: (p_assignment_id => p_assignment_id
437: ,p_earning_policy => p_earning_policy

Line 435: HXT_GEN_AAI.AAI_VALIDATIONS

431:
432: if g_debug then
433: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',30);
434: end if;
435: HXT_GEN_AAI.AAI_VALIDATIONS
436: (p_assignment_id => p_assignment_id
437: ,p_earning_policy => p_earning_policy
438: ,p_rotation_plan => p_rotation_plan
439: ,p_shift_differential_policy => p_shift_differential_policy

Line 445: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',40);

441: ,p_autogen_hours_yn => p_autogen_hours_yn
442: ,p_effective_start_date => p_effective_start_date
443: );
444: if g_debug then
445: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',40);
446: end if;
447:
448: /* Create unique ID for AAI row */
449: IF (p_id is null) THEN

Line 451: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',50);

447:
448: /* Create unique ID for AAI row */
449: IF (p_id is null) THEN
450: if g_debug then
451: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',50);
452: end if;
453: OPEN create_unique_id;
454: FETCH create_unique_id into l_id;
455: if g_debug then

Line 460: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',60);

456: hr_utility.trace('l_id is :'|| l_id);
457: end if;
458: IF create_unique_id%NOTFOUND THEN
459: if g_debug then
460: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',60);
461: end if;
462: -- fnd_message.set_name('HXT', 'HXT_39124_ROW_IN_DUAL_NF');
463: -- fnd_message.error;
464: hr_utility.set_message(809,'HXT_39124_ROW_IN_DUAL_NF');

Line 471: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',70);

467: CLOSE create_unique_id;
468: END IF;
469:
470: if g_debug then
471: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',70);
472: end if;
473:
474: INSERT into HXT_ADD_ASSIGN_INFO_F
475: (id

Line 567: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',80);

563: ,p_attribute29
564: ,p_attribute30);
565:
566: if g_debug then
567: hr_utility.set_location('HXT_GEN_AAI.Create_Otlr_Add_Assign_Info ',80);
568: end if;
569:
570: END Create_Otlr_Add_Assign_Info ;
571:

Line 700: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',10);

696:
697: BEGIN
698: g_debug :=hr_utility.debug_enabled;
699: if g_debug then
700: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',10);
701: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',20);
702: end if;
703:
704: -- Bug 8938280

Line 701: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',20);

697: BEGIN
698: g_debug :=hr_utility.debug_enabled;
699: if g_debug then
700: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',10);
701: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',20);
702: end if;
703:
704: -- Bug 8938280
705: -- Validation call here is wrong, commenting this out.

Line 707: HXT_GEN_AAI.AAI_VALIDATIONS

703:
704: -- Bug 8938280
705: -- Validation call here is wrong, commenting this out.
706: /*
707: HXT_GEN_AAI.AAI_VALIDATIONS
708: (p_assignment_id => p_assignment_id
709: ,p_earning_policy => p_earning_policy
710: ,p_rotation_plan => p_rotation_plan
711: ,p_shift_differential_policy => p_shift_differential_policy

Line 719: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',30);

715: );
716: */
717:
718: if g_debug then
719: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',30);
720: end if;
721:
722: OPEN c2;
723: FETCH c2 into p_rowid,l_effective_start_date,l_effective_end_date;

Line 769: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',40);

765: hr_utility.trace('Rowid is :'|| p_rowid);
766: end if;
767: IF l_datetrack_mode = 'CORRECTION' THEN
768: if g_debug then
769: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',40);
770: end if;
771:
772: -- Bug 8938280
773: -- Added this validation call here. Parameters are same as

Line 775: HXT_GEN_AAI.AAI_VALIDATIONS

771:
772: -- Bug 8938280
773: -- Added this validation call here. Parameters are same as
774: -- the commented one above.
775: HXT_GEN_AAI.AAI_VALIDATIONS
776: (p_assignment_id => p_assignment_id
777: ,p_earning_policy => p_earning_policy
778: ,p_rotation_plan => p_rotation_plan
779: ,p_shift_differential_policy => p_shift_differential_policy

Line 838: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',50);

834: /* end date the existing record and then create a new record if an
835: existing record found */
836:
837: if g_debug then
838: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',50);
839: end if;
840:
841: -- Bug 8938280
842: -- Added this validation call here. Parameter for effective

Line 844: HXT_GEN_AAI.AAI_VALIDATIONS

840:
841: -- Bug 8938280
842: -- Added this validation call here. Parameter for effective
843: -- start date should be the passed p_effective_date.
844: HXT_GEN_AAI.AAI_VALIDATIONS
845: (p_assignment_id => p_assignment_id
846: ,p_earning_policy => p_earning_policy
847: ,p_rotation_plan => p_rotation_plan
848: ,p_shift_differential_policy => p_shift_differential_policy

Line 878: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',60);

874:
875: IF (idtab.COUNT >0)
876: THEN
877: if g_debug then
878: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',60);
879: end if;
880:
881: -- Bug 8327591
882: -- Not required anymore.

Line 911: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',70);

907: WHERE rowid = p_rowid;
908: END IF;
909:
910: if g_debug then
911: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',70);
912: hr_utility.trace('p_id is :'||p_id);
913: end if;
914:
915: INSERT into HXT_ADD_ASSIGN_INFO_F

Line 1009: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',80);

1005: ,p_attribute29
1006: ,p_attribute30);
1007:
1008: if g_debug then
1009: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',80);
1010: end if;
1011:
1012: ELSE
1013: /* INVALID datetrack_mode */

Line 1019: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',90);

1015: hr_utility.raise_error;
1016: END IF;
1017:
1018: if g_debug then
1019: hr_utility.set_location('HXT_GEN_AAI.Update_Otlr_Add_Assign_Info ',90);
1020: end if;
1021: END IF;
1022:
1023: END Update_Otlr_Add_Assign_Info ;

Line 1029: END HXT_GEN_AAI;

1025: -------------------------------------------------------------------------------
1026: --begin
1027: --hr_utility.trace_on(null,'mhanda');
1028:
1029: END HXT_GEN_AAI;