[Home] [Help]
1534: IF g_debug then
1535: hr_utility.set_location('hxt_time_summary.insert_non_explodable_hrs', 30);
1536: END IF;
1537: -- Insert record in error table.
1538: FND_MESSAGE.SET_NAME('HXT','HXT_39421_GET_RETRO_ERR');
1539: END IF;
1540:
1541: EXCEPTION
1542: WHEN OTHERS THEN
1544: hr_utility.set_location('hxt_time_summary.insert_non_explodable_hrs', 40);
1545: END IF;
1546: hr_utility.trace(dbms_utility.format_error_backtrace);
1547: -- Insert record in error table.
1548: FND_MESSAGE.SET_NAME('HXT','HXT_39313_OR_ERR_INS_REC');
1549:
1550: END insert_non_explodable_hrs;
1551:
1552: Function check_non_explosion_entry (p_element_type_id IN NUMBER, p_date_worked DATE)
1910: if g_debug then
1911: hr_utility.set_location('hxt_time_summary.generate_details',180);
1912: end if;
1913: hr_utility.trace(dbms_utility.format_error_backtrace);
1914: FND_MESSAGE.SET_NAME('HXT','HXT_39269_ORACLE_ERROR');
1915: RETURN call_hxthxc_gen_error('HXT','HXT_39269_ORACLE_ERROR',NULL,l_location, '', sqlerrm);
1916: --2278400 RETURN call_gen_error(l_location, '', sqlerrm);
1917: END; -- generate_details
1918:
2173:
2174: if g_debug then
2175: hr_utility.set_location('hxt_time_summary.valid_data',20);
2176: end if;
2177: FND_MESSAGE.SET_NAME('HXT','HXT_39327_TIME_IN_OT_REQ');
2178: RETURN call_hxthxc_gen_error('HXT','HXT_39327_TIME_IN_OT_REQ',NULL,location, '');
2179:
2180: END IF;
2181:
2183:
2184: if g_debug then
2185: hr_utility.set_location('hxt_time_summary.valid_data',30);
2186: end if;
2187: FND_MESSAGE.SET_NAME('HXT','HXT_39327_TIME_IN_OT_REQ');
2188: RETURN call_hxthxc_gen_error('HXT','HXT_39327_TIME_IN_OT_REQ',NULL,location, '');
2189:
2190: END IF;
2191:
2193:
2194: if g_debug then
2195: hr_utility.set_location('hxt_time_summary.valid_data',40);
2196: end if;
2197: FND_MESSAGE.SET_NAME('HXT','HXT_39328_TIME_OR_TOT_HRS_REQ');
2198: RETURN call_hxthxc_gen_error('HXT','HXT_39328_TIME_OR_TOT_HRS_REQ',NULL,location, '');
2199:
2200: END IF;
2201:
2290: IF error_code = 1 THEN
2291: if g_debug then
2292: hr_utility.set_location('hxt_time_summary.valid_data',100);
2293: end if;
2294: FND_MESSAGE.SET_NAME('HXT','HXT_39329_INC_TIM_HR_ENTRIES');
2295:
2296: END IF;
2297:
2298: RETURN error_code;
2303: if g_debug then
2304: hr_utility.set_location('hxt_time_summary.valid_data',110);
2305: end if;
2306: hr_utility.trace(dbms_utility.format_error_backtrace);
2307: FND_MESSAGE.SET_NAME('HXT','HXT_39269_ORACLE_ERROR');
2308: RETURN call_hxthxc_gen_error('HXT','HXT_39269_ORACLE_ERROR',NULL,location, '', sqlerrm);
2309:
2310: END; -- valid_data
2311: -------------------------------------------------------------------------------
2383: hr_utility.set_location('hxt_time_summary.Delete_Details',40);
2384: end if;
2385: hr_utility.trace(dbms_utility.format_error_backtrace);
2386: -- Write to error table - do not generate details
2387: FND_MESSAGE.SET_NAME('HXT','HXT_39269_ORACLE_ERROR'); -- HXT11
2388: p_error_code := call_hxthxc_gen_error('HXT','HXT_39269_ORACLE_ERROR',NULL,l_location, '', sqlerrm); -- HXT11
2389: --p_error_code := call_gen_error(l_location, '', sqlerrm); -- HXT11
2390: END; -- delete details
2391:
2547: if g_debug then
2548: hr_utility.set_location('hxt_time_summary.Rebuild_Details',70);
2549: end if;
2550: hr_utility.trace(dbms_utility.format_error_backtrace);
2551: FND_MESSAGE.SET_NAME('HXT','HXT_39269_ORACLE_ERROR'); -- HXT11
2552: p_error_code := call_hxthxc_gen_error('HXT','HXT_39269_ORACLE_ERROR',NULL,l_location, '', sqlerrm); -- HXT11
2553: --2278400 p_error_code := call_gen_error(l_location, '', sqlerrm); -- HXT11
2554: END; -- rebuild details
2555: -------------------------------------------------------------------------------
3593: IF p_segment_stop_time IS NULL THEN
3594: if g_debug then
3595: hr_utility.set_location('hxt_time_summary.set_stop_and_hours',100);
3596: end if;
3597: FND_MESSAGE.SET_NAME('HXT','HXT_39314_SEG_STOP_TIME_NF'); -- HXT11
3598: RETURN call_hxthxc_gen_error('HXT','HXT_39314_SEG_STOP_TIME_NF',NULL,location, ''); -- HXT11
3599: --2278400 RETURN call_gen_error(location, ''); -- HXT11
3600: END IF;
3601:
3661: IF l_stop_time IS NULL THEN
3662: if g_debug then
3663: hr_utility.set_location('hxt_time_summary.set_stop_at_rule',40);
3664: end if;
3665: FND_MESSAGE.SET_NAME('HXT','HXT_39314_SEG_STOP_TIME_NF'); -- HXT11
3666: RETURN call_hxthxc_gen_error('HXT','HXT_39314_SEG_STOP_TIME_NF',NULL,location, ''); -- HXT11
3667: --2278400 RETURN call_gen_error(location, ''); -- HXT11
3668: END IF;
3669:
4162: IF loop_count > 50 THEN
4163: if g_debug then
4164: hr_utility.set_location('hxt_time_summary.gen_details',90);
4165: end if;
4166: FND_MESSAGE.SET_NAME('HXT','HXT_39300_GEN_DTAIL_EXC_LOOP'); -- HXT11
4167: return_code := call_gen_error(location, ''); -- HXT11
4168: END IF;
4169: IF return_code > 0 THEN
4170: if g_debug then
4192: if g_debug then
4193: hr_utility.set_location('hxt_time_summary.gen_details',110);
4194: end if;
4195: hr_utility.trace(dbms_utility.format_error_backtrace);
4196: FND_MESSAGE.SET_NAME('HXT','HXT_39269_ORACLE_ERROR'); -- HXT11
4197: RETURN call_hxthxc_gen_error('HXT','HXT_39269_ORACLE_ERROR',NULL,location, '', sqlerrm); -- HXT11
4198: --2278400 RETURN call_gen_error(location, '', sqlerrm); -- HXT11
4199:
4200: END;
4263: if g_debug then
4264: hr_utility.set_location('hxt_time_summary.Get_Include',50);
4265: end if;
4266: hr_utility.trace(dbms_utility.format_error_backtrace);
4267: FND_MESSAGE.SET_NAME('HXT','HXT_39270_OR_ERR_G_GROUP'); -- HXT11
4268: l_error_code := call_hxthxc_gen_error('HXT','HXT_39270_OR_ERR_G_GROUP',l_location,'', sqlerrm); -- HXT11
4269: --2278400 l_error_code := call_gen_error(l_location,'', sqlerrm); -- HXT11
4270: RETURN 'E';
4271:
4383:
4384:
4385: IF l_total_hours > g_daily_cap(TO_CHAR(g_ep_id))
4386: THEN
4387: fnd_message.set_name ('HXT', 'HXT_39577_NO_HOURS_ADJUST');
4388: RETURN call_hxthxc_gen_error ('HXT',
4389: 'HXT_39577_NO_HOURS_ADJUST',
4390: NULL,
4391: 'hxt_time_sum.gen_special',