[Home] [Help]
1: PACKAGE BODY hxt_time_detail AS
2: /* $Header: hxttdet.pkb 120.49.12020000.2 2013/02/18 11:14:02 jnerella ship $ */
3: --
4: -- Global variables for package
5: -- Used for parameters received that are not changed
492: g_debug := hr_utility.debug_enabled;
493:
494: IF g_debug
495: THEN
496: hr_utility.set_location ('hxt_time_detail.GENERATE_SPECIAL', 10);
497: hr_utility.TRACE ( 'p_time_in :'
498: || TO_CHAR (p_time_in, 'DD-MON-YYYY HH24:MI:SS')
499: );
500: hr_utility.TRACE ( 'p_time_out :'
561:
562: -- g_GROUP_ID := p_GROUP_ID; -- HXT11i1
563: IF g_debug
564: THEN
565: hr_utility.set_location ('hxt_time_detail.GENERATE_SPECIAL', 20);
566: END IF;
567:
568: -- Bug 12967677
569: -- Ignore Negative hours
572:
573: /*
574: IF g_hours < 0
575: THEN
576: hr_utility.set_location('hxt_time_detail.generate_special ', 25);
577: hr_utility.trace('G_hours is negative - '||g_hours);
578: hr_utility.trace(' Not exploding and returning 0 to ignore the hours ');
579: RETURN 0;
580: END IF;
590: );
591:
592: IF g_debug
593: THEN
594: hr_utility.set_location ('hxt_time_detail.GENERATE_SPECIAL', 30);
595: END IF;
596: -- parameters used for compatibility with this version of gen special
597: END;
598:
1753: l_proc VARCHAR2 (250);
1754: BEGIN
1755: IF g_debug
1756: THEN
1757: l_proc := 'hxt_time_detail.adjust_for_hdp_shortage';
1758: hr_utility.set_location (l_proc, 10);
1759: END IF;
1760:
1761: -- Bug 7359347
2375: l_sdp_start DATE;
2376: l_sdp_stop DATE;
2377: l_sdp_carryover DATE;
2378: l_proc VARCHAR2 (250)
2379: := 'hxt_time_detail.adjust_hours_for_premium';
2380: BEGIN
2381: FOR l_sdp_rule IN sdp_rule_cursor
2382: LOOP
2383: hxt_time_summary.time_in_dates (l_sdp_rule.start_time,
3248: deduct_prem_hours NUMBER := 0;
3249: current_dtl_row current_dtl%ROWTYPE;
3250: l_prem_adjusted BOOLEAN := FALSE;
3251: l_proc VARCHAR2 (250)
3252: := 'hxt_time_detail.adjust_hours_for_hdp';
3253: BEGIN
3254: IF g_debug
3255: THEN
3256: hr_utility.set_location (l_proc, 10);
4105: l_proc VARCHAR2 (250);
4106: BEGIN
4107: IF g_debug
4108: THEN
4109: l_proc := 'hxt_time_detail.adjust_for_hdp';
4110: hr_utility.set_location (l_proc, 10);
4111: hr_utility.TRACE ('g_hdp_id :' || g_hdp_id);
4112: END IF;
4113:
4421: l_proc VARCHAR2 (200);
4422: BEGIN
4423: IF g_debug
4424: THEN
4425: l_proc := 'hxt_time_detail.GetConsecutiveDaysWorked';
4426: hr_utility.set_location (l_proc, 10);
4427: END IF;
4428:
4429: -- Bug 7359347
4611: l_proc VARCHAR2 (200);
4612: BEGIN
4613: IF g_debug
4614: THEN
4615: l_proc := 'hxt_time_detail.ConsecutiveDaysWorked_for_SPC';
4616: hr_utility.set_location (l_proc, 10);
4617: END IF;
4618:
4619: -- Bug 7359347
5131: l_proc VARCHAR2 (200);
5132: BEGIN
5133: IF g_debug
5134: THEN
5135: l_proc := 'hxt_time_detail.adjust_abs_hrs_on_prev_days';
5136: hr_utility.set_location (l_proc, 10);
5137: hr_utility.TRACE ('c_tim_id:' || c_tim_id);
5138: hr_utility.TRACE ( 'c_date_worked :'
5139: || TO_CHAR (c_date_worked,
6713: l_proc VARCHAR2 (200);
6714: BEGIN
6715: IF g_debug
6716: THEN
6717: l_proc := 'hxt_time_detail.adjust_for_absence';
6718: hr_utility.set_location (l_proc, 10);
6719: hr_utility.TRACE ('a_ep_id:' || a_ep_id);
6720: hr_utility.TRACE ( 'a_date_worked :'
6721: || TO_CHAR (a_date_worked,
8178: l_proc VARCHAR2 (50);
8179: BEGIN
8180: IF g_debug
8181: THEN
8182: l_proc := 'HXT_TIME_DETAIL.init_for_wkl_combine_pts_cal';
8183: hr_utility.set_location (l_proc, 10);
8184: END IF;
8185:
8186: OPEN weekly_earn_category_total; --('REG');
8414:
8415:
8416: IF g_debug
8417: THEN
8418: l_proc := 'hxt_time_detail.use_points_to_select_rule_hrs';
8419: hr_utility.set_location (l_proc, 10);
8420: END IF;
8421:
8422: -- Populate the g_daily_earn_category plsql table with element type, hrs
11885: -- debug only --HXT115
11886: IF g_debug
11887: THEN
11888: hr_utility.TRACE ('--------------Gen Special-----------------');
11889: hr_utility.set_location ('hxt_time_detail.gen_special', 1);
11890: hr_utility.TRACE ( 'p_time_in :'
11891: || TO_CHAR (p_time_in, 'DD-MON-YYYY HH24:MI:SS')
11892: );
11893: hr_utility.TRACE ( 'p_time_out :'
11983: THEN
11984: hr_utility.TRACE ( 'summary_earning_category :'
11985: || summary_earning_category
11986: );
11987: hr_utility.set_location ('hxt_time_detail.gen_special', 2);
11988: END IF;
11989:
11990: IF summary_earning_category IS NULL
11991: THEN --- regular hours worked
12040: IF rule_type_to_pay = 'ABS'
12041: THEN
12042: IF g_debug
12043: THEN
12044: hr_utility.set_location ('hxt_time_detail.gen_special', 3);
12045: hr_utility.TRACE
12046: ('-----------Entering rule_type_to_pay = ABS------------');
12047: END IF;
12048:
12128: END IF;
12129:
12130: IF g_debug
12131: THEN
12132: hr_utility.set_location ('hxt_time_detail.gen_special', 4);
12133: END IF;
12134:
12135: IF ERROR_CODE <> 0
12136: THEN
12154: END IF;
12155:
12156: IF g_debug
12157: THEN
12158: hr_utility.set_location ('hxt_time_detail.gen_special', 4.2);
12159: hr_utility.TRACE ( 'date_worked :'
12160: || TO_CHAR (g_date_worked, 'DD/MON/YY')
12161: );
12162: hr_utility.TRACE ('g_call_adjust_abs :' || g_call_adjust_abs);
12167: IF g_call_adjust_abs = 'Y'
12168: THEN
12169: IF g_debug
12170: THEN
12171: hr_utility.set_location ('hxt_time_detail.gen_special', 4.3);
12172: END IF;
12173:
12174: -- begin 688072
12175: IF g_ep_type IN ('WEEKLY', 'SPECIAL')
12176: THEN
12177: -- Bug 2795054
12178: IF g_debug
12179: THEN
12180: hr_utility.set_location ('hxt_time_detail.gen_special',
12181: 4.4);
12182: END IF;
12183:
12184: -- Bug 2795054
12202: IF (l_abs_in_eg IS NOT NULL)
12203: THEN
12204: IF g_debug
12205: THEN
12206: hr_utility.set_location ('hxt_time_detail.gen_special',
12207: 4.5
12208: );
12209: END IF;
12210:
12212: adjust_for_absence (g_tim_id, g_ep_id, g_date_worked);
12213:
12214: IF g_debug
12215: THEN
12216: hr_utility.set_location ('hxt_time_detail.gen_special',
12217: 5
12218: );
12219: hr_utility.TRACE ('error_code :' || ERROR_CODE);
12220: END IF;
12224: THEN
12225: IF g_debug
12226: THEN
12227: hr_utility.set_location
12228: ('hxt_time_detail.gen_special',
12229: 5.1
12230: );
12231: END IF;
12232:
12243: THEN
12244: IF g_debug
12245: THEN
12246: hr_utility.set_location
12247: ('hxt_time_detail.gen_special',
12248: 5.2
12249: );
12250: END IF;
12251:
12264: THEN
12265: IF g_debug
12266: THEN
12267: hr_utility.set_location
12268: ('hxt_time_detail.gen_special',
12269: 5.3
12270: );
12271: END IF;
12272:
12290: THEN
12291: IF g_debug
12292: THEN
12293: hr_utility.set_location
12294: ('hxt_time_detail.gen_special',
12295: 6
12296: );
12297: END IF;
12298:
12308:
12309: --SIR491 END
12310: IF g_debug
12311: THEN
12312: hr_utility.set_location ('hxt_time_detail.gen_special',
12313: 6.1
12314: );
12315: END IF;
12316: END IF;
12316: END IF;
12317:
12318: IF g_debug
12319: THEN
12320: hr_utility.set_location ('hxt_time_detail.gen_special',
12321: 6.2);
12322: END IF;
12323: END IF;
12324:
12323: END IF;
12324:
12325: IF g_debug
12326: THEN
12327: hr_utility.set_location ('hxt_time_detail.gen_special', 6.3);
12328: END IF;
12329: -- end 688072
12330: END IF;
12331: ELSE -- rule_type_to_pay <> ABS
12330: END IF;
12331: ELSE -- rule_type_to_pay <> ABS
12332: IF g_debug
12333: THEN
12334: hr_utility.set_location ('hxt_time_detail.gen_special', 7);
12335: hr_utility.TRACE
12336: ('------------rule_type_to_pay <> ABS------------');
12337: END IF;
12338:
12372: IF ERROR_CODE > l_error_return
12373: THEN
12374: IF g_debug
12375: THEN
12376: hr_utility.set_location ('hxt_time_detail.gen_special', 10);
12377: END IF;
12378:
12379: l_error_return := ERROR_CODE;
12380: hxt_util.DEBUG ( 'Loc F. Return code is '
12400: -- rules.
12401: -- Weekly set to 999 if none found.
12402: IF g_debug
12403: THEN
12404: hr_utility.set_location ('hxt_time_detail.gen_special', 11);
12405: END IF;
12406:
12407: seven_day_cal_rule := FALSE;
12408: five_day_cal_rule := FALSE;
12428: IF daily_earn_rules_cur%FOUND
12429: THEN
12430: IF g_debug
12431: THEN
12432: hr_utility.set_location ('hxt_time_detail.gen_special', 12);
12433: END IF;
12434:
12435: -- Now that we know there is at least one day rule, determine how many
12436: -- consecutive days worked. Use the rule with the highest day number
12500: IF spc_earn_rules_cur%FOUND
12501: THEN
12502: IF g_debug
12503: THEN
12504: hr_utility.set_location ('hxt_time_detail.gen_special', 13);
12505: END IF;
12506:
12507: FETCH spc_earn_rules_cur
12508: INTO special_daily_cap2, special_earning_type2,
12511: IF consecutive_days_limit <> consecutive_days_limit2
12512: THEN
12513: IF g_debug
12514: THEN
12515: hr_utility.set_location ('hxt_time_detail.gen_special',
12516: 14
12517: );
12518: END IF;
12519:
12524: IF consec_days_worked >= consecutive_days_limit
12525: THEN
12526: IF g_debug
12527: THEN
12528: hr_utility.set_location ('hxt_time_detail.gen_special',
12529: 15
12530: );
12531: END IF;
12532:
12533: consecutive_days_reached := TRUE;
12534: ELSE
12535: IF g_debug
12536: THEN
12537: hr_utility.set_location ('hxt_time_detail.gen_special',
12538: 16
12539: );
12540: END IF;
12541:
12545: IF consecutive_days_limit = 7
12546: THEN
12547: IF g_debug
12548: THEN
12549: hr_utility.set_location ('hxt_time_detail.gen_special',
12550: 17
12551: );
12552: END IF;
12553:
12555: ELSIF consecutive_days_limit = 5
12556: THEN
12557: IF g_debug
12558: THEN
12559: hr_utility.set_location ('hxt_time_detail.gen_special',
12560: 18
12561: );
12562: END IF;
12563:
12586: END IF;
12587: ELSE -- spc_earn_rules_cur NOT FOUND
12588: IF g_debug
12589: THEN
12590: hr_utility.set_location ('hxt_time_detail.gen_special', 19);
12591: END IF;
12592:
12593: special_daily_cap := 99;
12594: special_earning_type := NULL;
12597: END IF;
12598: ELSE -- daily_earn_rules_cur NOT FOUND (NO SPECIAL (DAYS) RULE)
12599: IF g_debug
12600: THEN
12601: hr_utility.set_location ('hxt_time_detail.gen_special', 20);
12602: END IF;
12603:
12604: CLOSE daily_earn_rules_cur;
12605: END IF;
12624: IF (daily_earn_rules_cur%NOTFOUND AND (g_ep_type = 'WEEKLY'))
12625: THEN
12626: IF g_debug
12627: THEN
12628: hr_utility.set_location ('hxt_time_detail.gen_special', 21);
12629: hr_utility.TRACE
12630: ('daily_earn_rules_cur NOTFOUND and EP_TYPE = WEEKLY');
12631: END IF;
12632:
12637: IF (daily_earn_rules_cur%NOTFOUND AND (g_ep_type <> 'WEEKLY'))
12638: THEN
12639: IF g_debug
12640: THEN
12641: hr_utility.set_location ('hxt_time_detail.gen_special', 22);
12642: hr_utility.TRACE
12643: ('daily_earn_rules_cur NOTFOUND and EP_TYPE<>WEEKLY');
12644: END IF;
12645:
12683: IF rule_type_to_pay <> 'DAY'
12684: THEN -- for now only HOL
12685: IF g_debug
12686: THEN
12687: hr_utility.set_location ('hxt_time_detail.gen_special', 23);
12688: END IF;
12689:
12690: CLOSE daily_earn_rules_cur; -- opened with parameter DAY
12691:
12698: IF daily_earn_rules_cur%NOTFOUND
12699: THEN
12700: IF g_debug
12701: THEN
12702: hr_utility.set_location ('hxt_time_detail.gen_special', 24);
12703: END IF;
12704:
12705: end_of_day_rules := TRUE;
12706: END IF;
12733: IF weekly_earn_rules_cur%NOTFOUND
12734: THEN
12735: IF g_debug
12736: THEN
12737: hr_utility.set_location ('hxt_time_detail.gen_special', 25);
12738: END IF;
12739:
12740: IF g_ep_type = 'WEEKLY'
12741: THEN
12740: IF g_ep_type = 'WEEKLY'
12741: THEN
12742: IF g_debug
12743: THEN
12744: hr_utility.set_location ('hxt_time_detail.gen_special', 26);
12745: END IF;
12746:
12747: fnd_message.set_name ('HXT', 'HXT_39311_WKLY_ERN_RULES_NF');
12748: ERROR_CODE :=
12757: IF ERROR_CODE > l_error_return
12758: THEN
12759: IF g_debug
12760: THEN
12761: hr_utility.set_location ('hxt_time_detail.gen_special',
12762: 27
12763: );
12764: END IF;
12765:
12770: END IF; --SIR014
12771: ELSE
12772: IF g_debug
12773: THEN
12774: hr_utility.set_location ('hxt_time_detail.gen_special', 28);
12775: END IF;
12776:
12777: weekly_rule_cap := 999;
12778: hours_paid_weekly_rule := 0;
12843: IF hours_paid_weekly_rule >= weekly_rule_cap
12844: THEN
12845: IF g_debug
12846: THEN
12847: hr_utility.set_location ('hxt_time_detail.gen_special', 29);
12848: END IF;
12849:
12850: first_weekly_cap_reached := TRUE;
12851: END IF;
12872: -- bug 2956224 fix.
12873: LOOP
12874: IF g_debug
12875: THEN
12876: hr_utility.set_location ('hxt_time_detail.gen_special', 30);
12877: END IF;
12878:
12879: IF g_ep_type = 'WEEKLY' AND rule_type_to_pay <> 'HOL'
12880: THEN
12879: IF g_ep_type = 'WEEKLY' AND rule_type_to_pay <> 'HOL'
12880: THEN
12881: IF g_debug
12882: THEN
12883: hr_utility.set_location ('hxt_time_detail.gen_special', 31);
12884: END IF;
12885:
12886: select_weekly_hours (rule_to_pay,
12887: hours_to_pay_this_rule,
12889: );
12890:
12891: IF g_debug
12892: THEN
12893: hr_utility.set_location ('hxt_time_detail.gen_special',
12894: 31.5
12895: );
12896: END IF;
12897:
12898: IF ERROR_CODE > l_error_return
12899: THEN
12900: IF g_debug
12901: THEN
12902: hr_utility.set_location ('hxt_time_detail.gen_special',
12903: 32
12904: );
12905: END IF;
12906:
12913: AND rule_type_to_pay = 'HOL'
12914: THEN
12915: IF g_debug
12916: THEN
12917: hr_utility.set_location ('hxt_time_detail.gen_special',
12918: 32.1
12919: );
12920: END IF;
12921:
12934: IF ERROR_CODE > l_error_return
12935: THEN
12936: IF g_debug
12937: THEN
12938: hr_utility.set_location ('hxt_time_detail.gen_special',
12939: 32.5
12940: );
12941: END IF;
12942:
12949: -- Bug 13082996
12950: -- Added a couple of debug messages.
12951: IF g_debug
12952: THEN
12953: hr_utility.set_location ('hxt_time_detail.gen_special', 33);
12954: hr_utility.trace('g_hours '||g_hours);
12955: hr_utility.trace('g_date_worked '||g_date_worked);
12956: hr_utility.trace('g_time_in '||g_time_in);
12957: hr_utility.trace('g_time_out '||g_time_out);
12986: IF l_use_points_assigned = 'N' OR l_use_points_assigned IS NULL
12987: THEN
12988: IF g_debug
12989: THEN
12990: hr_utility.set_location ('hxt_time_detail.gen_special',
12991: 33.1
12992: );
12993: END IF;
12994:
13008: ELSIF l_use_points_assigned = 'Y'
13009: THEN
13010: IF g_debug
13011: THEN
13012: hr_utility.set_location ('hxt_time_detail.gen_special',
13013: 33.2
13014: );
13015: END IF;
13016:
13021: );
13022:
13023: IF g_debug
13024: THEN
13025: hr_utility.set_location ('hxt_time_detail.gen_special',
13026: 33.3
13027: );
13028: END IF;
13029: END IF;
13031: IF ERROR_CODE > l_error_return
13032: THEN
13033: IF g_debug
13034: THEN
13035: hr_utility.set_location ('hxt_time_detail.gen_special',
13036: 34
13037: );
13038: END IF;
13039:
13054: IF g_hours >= 0
13055: THEN
13056: IF g_debug
13057: THEN
13058: hr_utility.set_location ('hxt_time_detail.gen_special',
13059: 35
13060: );
13061: hr_utility.TRACE ( 'hours_to_pay_this_rule :'
13062: || hours_to_pay_this_rule
13086: )
13087: THEN
13088: IF g_debug
13089: THEN
13090: hr_utility.set_location ('hxt_time_detail.gen_special', 36);
13091: hr_utility.TRACE ( 'l_time_in :'
13092: || TO_CHAR (l_time_in, 'HH24:MI')
13093: );
13094: hr_utility.TRACE ( 'l_time_out:'
13184: IF ERROR_CODE <> 0
13185: THEN
13186: IF g_debug
13187: THEN
13188: hr_utility.set_location ('hxt_time_detail.gen_special',
13189: 37
13190: );
13191: END IF;
13192:
13194: THEN
13195: IF g_debug
13196: THEN
13197: hr_utility.set_location
13198: ('hxt_time_detail.gen_special',
13199: 38
13200: );
13201: END IF;
13202:
13211: END IF;
13212:
13213: IF g_debug
13214: THEN
13215: hr_utility.set_location ('hxt_time_detail.gen_special', 39);
13216: hr_utility.TRACE ( 'hours_left_to_pay :'
13217: || TO_CHAR (hours_left_to_pay)
13218: );
13219: END IF;
13237: IF l_use_points_assigned = 'N' OR l_use_points_assigned IS NULL
13238: THEN
13239: IF g_debug
13240: THEN
13241: hr_utility.set_location ('hxt_time_detail.gen_special',
13242: 39.5
13243: );
13244: END IF;
13245:
13248: END IF;
13249:
13250: IF g_debug
13251: THEN
13252: hr_utility.set_location ('hxt_time_detail.gen_special', 40);
13253: hr_utility.TRACE ( 'hours_left_to_pay :'
13254: || TO_CHAR (hours_left_to_pay)
13255: );
13256: END IF;
13267: IF hours_left_to_pay >= 0 AND ERROR_CODE = 0
13268: THEN
13269: IF g_debug
13270: THEN
13271: hr_utility.set_location ('hxt_time_detail.gen_special',
13272: 41
13273: );
13274: END IF;
13275:
13288: THEN
13289: IF g_debug
13290: THEN
13291: hr_utility.set_location
13292: ('hxt_time_detail.gen_special',
13293: 41.5
13294: );
13295: END IF;
13296:
13301: THEN
13302: IF g_debug
13303: THEN
13304: hr_utility.set_location
13305: ('hxt_time_detail.gen_special',
13306: 42
13307: );
13308: END IF;
13309:
13325: THEN
13326: IF g_debug
13327: THEN
13328: hr_utility.set_location
13329: ('hxt_time_detail.gen_special',
13330: 43
13331: );
13332: END IF;
13333:
13339: THEN
13340: IF g_debug
13341: THEN
13342: hr_utility.set_location
13343: ('hxt_time_detail.gen_special',
13344: 44
13345: );
13346: END IF;
13347:
13406: THEN
13407: IF g_debug
13408: THEN
13409: hr_utility.set_location
13410: ('hxt_time_detail.gen_special',
13411: 45
13412: );
13413: END IF;
13414:
13418: ELSIF hours_left_to_pay < 0
13419: THEN
13420: IF g_debug
13421: THEN
13422: hr_utility.set_location ('hxt_time_detail.gen_special',
13423: 46
13424: );
13425: END IF;
13426:
13428: THEN
13429: IF g_debug
13430: THEN
13431: hr_utility.set_location
13432: ('hxt_time_detail.gen_special',
13433: 47
13434: );
13435: END IF;
13436:
13450: THEN
13451: IF g_debug
13452: THEN
13453: hr_utility.set_location
13454: ('hxt_time_detail.gen_special',
13455: 48
13456: );
13457: END IF;
13458:
13464: ELSE
13465: IF g_debug
13466: THEN
13467: hr_utility.set_location
13468: ('hxt_time_detail.gen_special',
13469: 49
13470: );
13471: END IF;
13472:
13474: END IF;
13475:
13476: IF g_debug
13477: THEN
13478: hr_utility.set_location ('hxt_time_detail.gen_special',
13479: 50
13480: );
13481: END IF;
13482: END IF; --hours_left_to_pay > 0 and error_code = 0
13487: IF loop_counter > 50
13488: THEN
13489: IF g_debug
13490: THEN
13491: hr_utility.set_location ('hxt_time_detail.gen_special', 52);
13492: END IF;
13493:
13494: fnd_message.set_name ('HXT', 'HXT_39305_LOOP_LIMIT_EXC');
13495: ERROR_CODE :=
13504: IF ERROR_CODE > l_error_return
13505: THEN
13506: IF g_debug
13507: THEN
13508: hr_utility.set_location ('hxt_time_detail.gen_special',
13509: 53
13510: );
13511: END IF;
13512:
13519: END IF;
13520:
13521: IF g_debug
13522: THEN
13523: hr_utility.set_location ('hxt_time_detail.gen_special', 54);
13524: END IF;
13525: END LOOP; -- While hours_left_to_pay <> 0 AND error_code = 0
13526:
13527: CLOSE daily_earn_rules_cur;
13533: AND ERROR_CODE = 0
13534: THEN
13535: IF g_debug
13536: THEN
13537: hr_utility.set_location ('hxt_time_detail.gen_special', 54.5);
13538: END IF;
13539:
13540: l_day_total := get_daily_total;
13541:
13547: IF l_day_total > 12
13548: THEN
13549: IF g_debug
13550: THEN
13551: hr_utility.set_location ('hxt_time_detail.gen_special', 55);
13552: END IF;
13553:
13554: ERROR_CODE := adjust_for_double_time (l_day_total);
13555:
13556: IF ERROR_CODE = 0
13557: THEN
13558: IF g_debug
13559: THEN
13560: hr_utility.set_location ('hxt_time_detail.gen_special',
13561: 56
13562: );
13563: END IF;
13564:
13566: ELSIF ERROR_CODE = 1
13567: THEN
13568: IF g_debug
13569: THEN
13570: hr_utility.set_location ('hxt_time_detail.gen_special',
13571: 57
13572: );
13573: END IF;
13574:
13584: ELSIF ERROR_CODE = 2
13585: THEN
13586: IF g_debug
13587: THEN
13588: hr_utility.set_location ('hxt_time_detail.gen_special',
13589: 58
13590: );
13591: END IF;
13592:
13602: ELSIF ERROR_CODE = 3
13603: THEN
13604: IF g_debug
13605: THEN
13606: hr_utility.set_location ('hxt_time_detail.gen_special',
13607: 59
13608: );
13609: END IF;
13610:
13620: ELSIF ERROR_CODE = 4
13621: THEN
13622: IF g_debug
13623: THEN
13624: hr_utility.set_location ('hxt_time_detail.gen_special',
13625: 60
13626: );
13627: END IF;
13628:
13638: ELSIF ERROR_CODE = 5
13639: THEN
13640: IF g_debug
13641: THEN
13642: hr_utility.set_location ('hxt_time_detail.gen_special',
13643: 61
13644: );
13645: END IF;
13646:
13658: IF ERROR_CODE > l_error_return
13659: THEN
13660: IF g_debug
13661: THEN
13662: hr_utility.set_location ('hxt_time_detail.gen_special',
13663: 62
13664: );
13665: END IF;
13666:
13671: END IF;
13672:
13673: IF g_debug
13674: THEN
13675: hr_utility.set_location ('hxt_time_detail.gen_special', 63);
13676: END IF;
13677: END IF;
13678:
13679: IF g_debug
13677: END IF;
13678:
13679: IF g_debug
13680: THEN
13681: hr_utility.set_location ('hxt_time_detail.gen_special', 64);
13682: END IF;
13683: END IF;
13684:
13685: IF g_debug
13740: IF ERROR_CODE > l_error_return
13741: THEN
13742: IF g_debug
13743: THEN
13744: hr_utility.set_location ('hxt_time_detail.gen_special', 65);
13745: END IF;
13746:
13747: l_error_return := ERROR_CODE;
13748: hxt_util.DEBUG ('Loc F. Return code is ' || TO_CHAR (l_error_return));
13894: LOCATION VARCHAR2 (120) := g_location || ':DDTL';
13895: BEGIN
13896: IF g_debug
13897: THEN
13898: hr_utility.set_location ('hxt_time_detail.delete_zero_hour_details',
13899: 10
13900: );
13901: END IF;
13902:
13912: LOOP -- through detail rows and delete zero hour rows
13913: IF g_debug
13914: THEN
13915: hr_utility.set_location
13916: ('hxt_time_detail.delete_zero_hour_details',
13917: 20
13918: );
13919: END IF;
13920:
13938: -- for a day. Flat amount Day Premium should be paid only once a day.
13939: IF g_debug
13940: THEN
13941: hr_utility.set_location
13942: ('hxt_time_detail.delete_zero_hour_details',
13943: 30
13944: );
13945: END IF;
13946:
13956: END LOOP;
13957:
13958: IF g_debug
13959: THEN
13960: hr_utility.set_location ('hxt_time_detail.delete_zero_hour_details',
13961: 40
13962: );
13963: END IF;
13964:
14049: l_proc VARCHAR2 (250);
14050: BEGIN
14051: IF g_debug
14052: THEN
14053: l_proc := 'hxt_time_detail.combine_contig_chunks';
14054: hr_utility.set_location (l_proc, 10);
14055: hr_utility.TRACE ('g_id:' || g_id);
14056: END IF;
14057:
14561:
14562: BEGIN
14563: IF g_debug
14564: THEN
14565: l_proc := 'hxt_time_detail.pay';
14566: hr_utility.set_location (l_proc, 10);
14567: hr_utility.TRACE ( 'a_time_in :'
14568: || TO_CHAR (a_time_in, 'DD-MON-YYYY HH24:MI:SS')
14569: );
15351: /* Main Function */
15352: BEGIN
15353: IF g_debug
15354: THEN
15355: l_proc := 'hxt_time_detail.Overtime_Hoursoverride';
15356: hr_utility.set_location (l_proc, 10);
15357: END IF;
15358:
15359: -- Bug 7359347