APPS.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on HR_UTILITY

Line 9: g_debug boolean :=hr_utility.debug_enabled;

5: g_separator VARCHAR2(2) := '|';
6: g_pref_sep VARCHAR2(2) := '#';
7: g_package VARCHAR2(50) := 'hxc_deposit_wrapper_utilities';
8:
9: g_debug boolean :=hr_utility.debug_enabled;
10:
11: -- globals for caching the hours type poplist
12: g_ht_resource_id varchar2(20) :=null;
13: g_ht_start_time varchar2(30) :=null;

Line 1320: hr_utility.set_message(809,'HXC_S2B_DO_NOT_MATCH');

1316:
1317: end loop;
1318:
1319: if(l_bad=TRUE) then
1320: hr_utility.set_message(809,'HXC_S2B_DO_NOT_MATCH');
1321: hr_utility.raise_error;
1322: end if;
1323:
1324: */

Line 1321: hr_utility.raise_error;

1317: end loop;
1318:
1319: if(l_bad=TRUE) then
1320: hr_utility.set_message(809,'HXC_S2B_DO_NOT_MATCH');
1321: hr_utility.raise_error;
1322: end if;
1323:
1324: */
1325: RETURN l_blocks2;

Line 1489: hr_utility.set_message(809,'HXC_S2A_DO_NOT_MATCH');

1485:
1486: end loop;
1487:
1488: if(l_bad=TRUE) then
1489: hr_utility.set_message(809,'HXC_S2A_DO_NOT_MATCH');
1490: hr_utility.raise_error;
1491: end if;
1492: */
1493: RETURN l_attributes2;

Line 1490: hr_utility.raise_error;

1486: end loop;
1487:
1488: if(l_bad=TRUE) then
1489: hr_utility.set_message(809,'HXC_S2A_DO_NOT_MATCH');
1490: hr_utility.raise_error;
1491: end if;
1492: */
1493: RETURN l_attributes2;
1494:

Line 1832: hr_utility.set_message(809,'HXC_S2BA_DO_NOT_MATCH');

1828:
1829: end loop;
1830:
1831: if(l_bad=TRUE) then
1832: hr_utility.set_message(809,'HXC_S2BA_DO_NOT_MATCH');
1833: hr_utility.raise_error;
1834: end if;
1835: */
1836:

Line 1833: hr_utility.raise_error;

1829: end loop;
1830:
1831: if(l_bad=TRUE) then
1832: hr_utility.set_message(809,'HXC_S2BA_DO_NOT_MATCH');
1833: hr_utility.raise_error;
1834: end if;
1835: */
1836:
1837:

Line 2206: hr_utility.set_message(809,'HXC_LPS');

2202: l_loop_count:=l_loop_count+1;
2203: EXIT WHEN l_index_next = 0;
2204:
2205: if(l_loop_count>30000) then
2206: hr_utility.set_message(809,'HXC_LPS');
2207: hr_utility.raise_error;
2208: end if;
2209:
2210:

Line 2207: hr_utility.raise_error;

2203: EXIT WHEN l_index_next = 0;
2204:
2205: if(l_loop_count>30000) then
2206: hr_utility.set_message(809,'HXC_LPS');
2207: hr_utility.raise_error;
2208: end if;
2209:
2210:
2211: END LOOP;

Line 2514: g_debug:=hr_utility.debug_enabled;

2510:
2511:
2512: BEGIN
2513:
2514: g_debug:=hr_utility.debug_enabled;
2515: l_time_diff := 24*60*(sysdate - g_ht_time);
2516:
2517: IF g_debug THEN
2518: hr_utility.trace(' In HXC_DEPOSIT_WRAPPER_UTILITIES.TIMECARD_HOURS_TYPE_LIST procedure');

Line 2518: hr_utility.trace(' In HXC_DEPOSIT_WRAPPER_UTILITIES.TIMECARD_HOURS_TYPE_LIST procedure');

2514: g_debug:=hr_utility.debug_enabled;
2515: l_time_diff := 24*60*(sysdate - g_ht_time);
2516:
2517: IF g_debug THEN
2518: hr_utility.trace(' In HXC_DEPOSIT_WRAPPER_UTILITIES.TIMECARD_HOURS_TYPE_LIST procedure');
2519:
2520: hr_utility.trace(' ****************Initial Information************************ ');
2521:
2522: hr_utility.trace(' ****************Start of Local values************************ ');

Line 2520: hr_utility.trace(' ****************Initial Information************************ ');

2516:
2517: IF g_debug THEN
2518: hr_utility.trace(' In HXC_DEPOSIT_WRAPPER_UTILITIES.TIMECARD_HOURS_TYPE_LIST procedure');
2519:
2520: hr_utility.trace(' ****************Initial Information************************ ');
2521:
2522: hr_utility.trace(' ****************Start of Local values************************ ');
2523: hr_utility.trace(' p_resource_id ::'||p_resource_id);
2524: hr_utility.trace(' p_start_time ::'||p_start_time);

Line 2522: hr_utility.trace(' ****************Start of Local values************************ ');

2518: hr_utility.trace(' In HXC_DEPOSIT_WRAPPER_UTILITIES.TIMECARD_HOURS_TYPE_LIST procedure');
2519:
2520: hr_utility.trace(' ****************Initial Information************************ ');
2521:
2522: hr_utility.trace(' ****************Start of Local values************************ ');
2523: hr_utility.trace(' p_resource_id ::'||p_resource_id);
2524: hr_utility.trace(' p_start_time ::'||p_start_time);
2525: hr_utility.trace(' p_stop_time ::'||p_stop_time);
2526: hr_utility.trace(' p_alias_or_element_id ::'||p_alias_or_element_id);

Line 2523: hr_utility.trace(' p_resource_id ::'||p_resource_id);

2519:
2520: hr_utility.trace(' ****************Initial Information************************ ');
2521:
2522: hr_utility.trace(' ****************Start of Local values************************ ');
2523: hr_utility.trace(' p_resource_id ::'||p_resource_id);
2524: hr_utility.trace(' p_start_time ::'||p_start_time);
2525: hr_utility.trace(' p_stop_time ::'||p_stop_time);
2526: hr_utility.trace(' p_alias_or_element_id ::'||p_alias_or_element_id);
2527: hr_utility.trace(' fnd_global.resp_id ::'||fnd_global.resp_id);

Line 2524: hr_utility.trace(' p_start_time ::'||p_start_time);

2520: hr_utility.trace(' ****************Initial Information************************ ');
2521:
2522: hr_utility.trace(' ****************Start of Local values************************ ');
2523: hr_utility.trace(' p_resource_id ::'||p_resource_id);
2524: hr_utility.trace(' p_start_time ::'||p_start_time);
2525: hr_utility.trace(' p_stop_time ::'||p_stop_time);
2526: hr_utility.trace(' p_alias_or_element_id ::'||p_alias_or_element_id);
2527: hr_utility.trace(' fnd_global.resp_id ::'||fnd_global.resp_id);
2528: hr_utility.trace(' ****************End of Local values************************ ');

Line 2525: hr_utility.trace(' p_stop_time ::'||p_stop_time);

2521:
2522: hr_utility.trace(' ****************Start of Local values************************ ');
2523: hr_utility.trace(' p_resource_id ::'||p_resource_id);
2524: hr_utility.trace(' p_start_time ::'||p_start_time);
2525: hr_utility.trace(' p_stop_time ::'||p_stop_time);
2526: hr_utility.trace(' p_alias_or_element_id ::'||p_alias_or_element_id);
2527: hr_utility.trace(' fnd_global.resp_id ::'||fnd_global.resp_id);
2528: hr_utility.trace(' ****************End of Local values************************ ');
2529:

Line 2526: hr_utility.trace(' p_alias_or_element_id ::'||p_alias_or_element_id);

2522: hr_utility.trace(' ****************Start of Local values************************ ');
2523: hr_utility.trace(' p_resource_id ::'||p_resource_id);
2524: hr_utility.trace(' p_start_time ::'||p_start_time);
2525: hr_utility.trace(' p_stop_time ::'||p_stop_time);
2526: hr_utility.trace(' p_alias_or_element_id ::'||p_alias_or_element_id);
2527: hr_utility.trace(' fnd_global.resp_id ::'||fnd_global.resp_id);
2528: hr_utility.trace(' ****************End of Local values************************ ');
2529:
2530: hr_utility.trace(' ****************Start of Global values************************ ');

Line 2527: hr_utility.trace(' fnd_global.resp_id ::'||fnd_global.resp_id);

2523: hr_utility.trace(' p_resource_id ::'||p_resource_id);
2524: hr_utility.trace(' p_start_time ::'||p_start_time);
2525: hr_utility.trace(' p_stop_time ::'||p_stop_time);
2526: hr_utility.trace(' p_alias_or_element_id ::'||p_alias_or_element_id);
2527: hr_utility.trace(' fnd_global.resp_id ::'||fnd_global.resp_id);
2528: hr_utility.trace(' ****************End of Local values************************ ');
2529:
2530: hr_utility.trace(' ****************Start of Global values************************ ');
2531: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);

Line 2528: hr_utility.trace(' ****************End of Local values************************ ');

2524: hr_utility.trace(' p_start_time ::'||p_start_time);
2525: hr_utility.trace(' p_stop_time ::'||p_stop_time);
2526: hr_utility.trace(' p_alias_or_element_id ::'||p_alias_or_element_id);
2527: hr_utility.trace(' fnd_global.resp_id ::'||fnd_global.resp_id);
2528: hr_utility.trace(' ****************End of Local values************************ ');
2529:
2530: hr_utility.trace(' ****************Start of Global values************************ ');
2531: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);
2532: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);

Line 2530: hr_utility.trace(' ****************Start of Global values************************ ');

2526: hr_utility.trace(' p_alias_or_element_id ::'||p_alias_or_element_id);
2527: hr_utility.trace(' fnd_global.resp_id ::'||fnd_global.resp_id);
2528: hr_utility.trace(' ****************End of Local values************************ ');
2529:
2530: hr_utility.trace(' ****************Start of Global values************************ ');
2531: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);
2532: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);
2533: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);
2534: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);

Line 2531: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);

2527: hr_utility.trace(' fnd_global.resp_id ::'||fnd_global.resp_id);
2528: hr_utility.trace(' ****************End of Local values************************ ');
2529:
2530: hr_utility.trace(' ****************Start of Global values************************ ');
2531: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);
2532: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);
2533: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);
2534: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);
2535: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);

Line 2532: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);

2528: hr_utility.trace(' ****************End of Local values************************ ');
2529:
2530: hr_utility.trace(' ****************Start of Global values************************ ');
2531: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);
2532: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);
2533: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);
2534: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);
2535: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);
2536: hr_utility.trace(' ****************End of Global values************************ ');

Line 2533: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);

2529:
2530: hr_utility.trace(' ****************Start of Global values************************ ');
2531: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);
2532: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);
2533: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);
2534: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);
2535: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);
2536: hr_utility.trace(' ****************End of Global values************************ ');
2537:

Line 2534: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);

2530: hr_utility.trace(' ****************Start of Global values************************ ');
2531: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);
2532: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);
2533: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);
2534: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);
2535: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);
2536: hr_utility.trace(' ****************End of Global values************************ ');
2537:
2538: hr_utility.trace(' sysdate ::'||sysdate);

Line 2535: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);

2531: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);
2532: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);
2533: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);
2534: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);
2535: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);
2536: hr_utility.trace(' ****************End of Global values************************ ');
2537:
2538: hr_utility.trace(' sysdate ::'||sysdate);
2539: hr_utility.trace(' g_ht_time ::'||g_ht_time);

Line 2536: hr_utility.trace(' ****************End of Global values************************ ');

2532: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);
2533: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);
2534: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);
2535: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);
2536: hr_utility.trace(' ****************End of Global values************************ ');
2537:
2538: hr_utility.trace(' sysdate ::'||sysdate);
2539: hr_utility.trace(' g_ht_time ::'||g_ht_time);
2540: hr_utility.trace(' l_time_diff ::'||l_time_diff);

Line 2538: hr_utility.trace(' sysdate ::'||sysdate);

2534: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);
2535: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);
2536: hr_utility.trace(' ****************End of Global values************************ ');
2537:
2538: hr_utility.trace(' sysdate ::'||sysdate);
2539: hr_utility.trace(' g_ht_time ::'||g_ht_time);
2540: hr_utility.trace(' l_time_diff ::'||l_time_diff);
2541:
2542: hr_utility.trace(' ****************End of Initial Information************************ ');

Line 2539: hr_utility.trace(' g_ht_time ::'||g_ht_time);

2535: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);
2536: hr_utility.trace(' ****************End of Global values************************ ');
2537:
2538: hr_utility.trace(' sysdate ::'||sysdate);
2539: hr_utility.trace(' g_ht_time ::'||g_ht_time);
2540: hr_utility.trace(' l_time_diff ::'||l_time_diff);
2541:
2542: hr_utility.trace(' ****************End of Initial Information************************ ');
2543: END IF;

Line 2540: hr_utility.trace(' l_time_diff ::'||l_time_diff);

2536: hr_utility.trace(' ****************End of Global values************************ ');
2537:
2538: hr_utility.trace(' sysdate ::'||sysdate);
2539: hr_utility.trace(' g_ht_time ::'||g_ht_time);
2540: hr_utility.trace(' l_time_diff ::'||l_time_diff);
2541:
2542: hr_utility.trace(' ****************End of Initial Information************************ ');
2543: END IF;
2544:

Line 2542: hr_utility.trace(' ****************End of Initial Information************************ ');

2538: hr_utility.trace(' sysdate ::'||sysdate);
2539: hr_utility.trace(' g_ht_time ::'||g_ht_time);
2540: hr_utility.trace(' l_time_diff ::'||l_time_diff);
2541:
2542: hr_utility.trace(' ****************End of Initial Information************************ ');
2543: END IF;
2544:
2545: -- check to see if we can use a cached result
2546:

Line 2557: hr_utility.trace(' IF l_time_diff < 5 then RETURN g_hours_type_list ::'||g_hours_type_list);

2553: g_ht_resp_id = fnd_global.resp_id )
2554: THEN
2555:
2556: IF g_debug THEN
2557: hr_utility.trace(' IF l_time_diff < 5 then RETURN g_hours_type_list ::'||g_hours_type_list);
2558: END IF;
2559:
2560: return g_hours_type_list;
2561:

Line 2576: hr_utility.trace(' if not able to use cached result, need to generate. Store params so that we could cache next time');

2572: g_ht_resp_id := fnd_global.resp_id;
2573: g_ht_time := sysdate;
2574:
2575: IF g_debug THEN
2576: hr_utility.trace(' if not able to use cached result, need to generate. Store params so that we could cache next time');
2577: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);
2578: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);
2579: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);
2580: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);

Line 2577: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);

2573: g_ht_time := sysdate;
2574:
2575: IF g_debug THEN
2576: hr_utility.trace(' if not able to use cached result, need to generate. Store params so that we could cache next time');
2577: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);
2578: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);
2579: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);
2580: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);
2581: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);

Line 2578: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);

2574:
2575: IF g_debug THEN
2576: hr_utility.trace(' if not able to use cached result, need to generate. Store params so that we could cache next time');
2577: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);
2578: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);
2579: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);
2580: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);
2581: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);
2582: hr_utility.trace(' g_ht_time ::'||g_ht_time);

Line 2579: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);

2575: IF g_debug THEN
2576: hr_utility.trace(' if not able to use cached result, need to generate. Store params so that we could cache next time');
2577: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);
2578: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);
2579: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);
2580: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);
2581: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);
2582: hr_utility.trace(' g_ht_time ::'||g_ht_time);
2583: hr_utility.trace(' end of caced items.');

Line 2580: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);

2576: hr_utility.trace(' if not able to use cached result, need to generate. Store params so that we could cache next time');
2577: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);
2578: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);
2579: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);
2580: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);
2581: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);
2582: hr_utility.trace(' g_ht_time ::'||g_ht_time);
2583: hr_utility.trace(' end of caced items.');
2584: END IF;

Line 2581: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);

2577: hr_utility.trace(' g_ht_resource_id ::'||g_ht_resource_id);
2578: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);
2579: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);
2580: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);
2581: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);
2582: hr_utility.trace(' g_ht_time ::'||g_ht_time);
2583: hr_utility.trace(' end of caced items.');
2584: END IF;
2585:

Line 2582: hr_utility.trace(' g_ht_time ::'||g_ht_time);

2578: hr_utility.trace(' g_ht_start_time ::'||g_ht_start_time);
2579: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);
2580: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);
2581: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);
2582: hr_utility.trace(' g_ht_time ::'||g_ht_time);
2583: hr_utility.trace(' end of caced items.');
2584: END IF;
2585:
2586:

Line 2583: hr_utility.trace(' end of caced items.');

2579: hr_utility.trace(' g_ht_stop_time ::'||g_ht_stop_time);
2580: hr_utility.trace(' g_ht_alias_or_element_id ::'||g_ht_alias_or_element_id);
2581: hr_utility.trace(' g_ht_resp_id ::'||g_ht_resp_id);
2582: hr_utility.trace(' g_ht_time ::'||g_ht_time);
2583: hr_utility.trace(' end of caced items.');
2584: END IF;
2585:
2586:
2587: -- convert params

Line 2593: hr_utility.trace(' Get list of valid aliases for this period.');

2589: --l_start_time := FND_DATE.CANONICAL_TO_DATE(p_start_time);
2590: --l_stop_time := FND_DATE.CANONICAL_TO_DATE(p_stop_time);
2591:
2592: IF g_debug THEN
2593: hr_utility.trace(' Get list of valid aliases for this period.');
2594: END IF;
2595:
2596: -- get list of valid aliases for this period
2597:

Line 2615: --hr_utility.trace('p_alias_or_element_id '||p_alias_or_element_id);

2611: ,p_stop_time => p_stop_time
2612: ,p_resource_id => l_resource_id );
2613:
2614: --if g_debug then
2615: --hr_utility.trace('p_alias_or_element_id '||p_alias_or_element_id);
2616: --end if;
2617:
2618: END IF;
2619:

Line 2626: hr_utility.trace(' RESOURCE_ID : '||l_aliases(l_index).RESOURCE_ID);

2622: l_index := l_aliases.FIRST;
2623: LOOP
2624: EXIT WHEN NOT l_aliases.exists(l_index);
2625:
2626: hr_utility.trace(' RESOURCE_ID : '||l_aliases(l_index).RESOURCE_ID);
2627: hr_utility.trace(' PREF_START_DATE : '||l_aliases(l_index).PREF_START_DATE);
2628: hr_utility.trace(' PREF_END_DATE : '||l_aliases(l_index).PREF_END_DATE);
2629: hr_utility.trace(' ALIAS_DEFINITION_ID : '||l_aliases(l_index).ALIAS_DEFINITION_ID);
2630: hr_utility.trace(' ITEM_ATTRIBUTE_CATEGORY : '||l_aliases(l_index).ITEM_ATTRIBUTE_CATEGORY);

Line 2627: hr_utility.trace(' PREF_START_DATE : '||l_aliases(l_index).PREF_START_DATE);

2623: LOOP
2624: EXIT WHEN NOT l_aliases.exists(l_index);
2625:
2626: hr_utility.trace(' RESOURCE_ID : '||l_aliases(l_index).RESOURCE_ID);
2627: hr_utility.trace(' PREF_START_DATE : '||l_aliases(l_index).PREF_START_DATE);
2628: hr_utility.trace(' PREF_END_DATE : '||l_aliases(l_index).PREF_END_DATE);
2629: hr_utility.trace(' ALIAS_DEFINITION_ID : '||l_aliases(l_index).ALIAS_DEFINITION_ID);
2630: hr_utility.trace(' ITEM_ATTRIBUTE_CATEGORY : '||l_aliases(l_index).ITEM_ATTRIBUTE_CATEGORY);
2631: hr_utility.trace(' LAYOUT_ID : '||l_aliases(l_index).LAYOUT_ID);

Line 2628: hr_utility.trace(' PREF_END_DATE : '||l_aliases(l_index).PREF_END_DATE);

2624: EXIT WHEN NOT l_aliases.exists(l_index);
2625:
2626: hr_utility.trace(' RESOURCE_ID : '||l_aliases(l_index).RESOURCE_ID);
2627: hr_utility.trace(' PREF_START_DATE : '||l_aliases(l_index).PREF_START_DATE);
2628: hr_utility.trace(' PREF_END_DATE : '||l_aliases(l_index).PREF_END_DATE);
2629: hr_utility.trace(' ALIAS_DEFINITION_ID : '||l_aliases(l_index).ALIAS_DEFINITION_ID);
2630: hr_utility.trace(' ITEM_ATTRIBUTE_CATEGORY : '||l_aliases(l_index).ITEM_ATTRIBUTE_CATEGORY);
2631: hr_utility.trace(' LAYOUT_ID : '||l_aliases(l_index).LAYOUT_ID);
2632: hr_utility.trace(' ALIAS_LABEL : '||l_aliases(l_index).ALIAS_LABEL);

Line 2629: hr_utility.trace(' ALIAS_DEFINITION_ID : '||l_aliases(l_index).ALIAS_DEFINITION_ID);

2625:
2626: hr_utility.trace(' RESOURCE_ID : '||l_aliases(l_index).RESOURCE_ID);
2627: hr_utility.trace(' PREF_START_DATE : '||l_aliases(l_index).PREF_START_DATE);
2628: hr_utility.trace(' PREF_END_DATE : '||l_aliases(l_index).PREF_END_DATE);
2629: hr_utility.trace(' ALIAS_DEFINITION_ID : '||l_aliases(l_index).ALIAS_DEFINITION_ID);
2630: hr_utility.trace(' ITEM_ATTRIBUTE_CATEGORY : '||l_aliases(l_index).ITEM_ATTRIBUTE_CATEGORY);
2631: hr_utility.trace(' LAYOUT_ID : '||l_aliases(l_index).LAYOUT_ID);
2632: hr_utility.trace(' ALIAS_LABEL : '||l_aliases(l_index).ALIAS_LABEL);
2633:

Line 2630: hr_utility.trace(' ITEM_ATTRIBUTE_CATEGORY : '||l_aliases(l_index).ITEM_ATTRIBUTE_CATEGORY);

2626: hr_utility.trace(' RESOURCE_ID : '||l_aliases(l_index).RESOURCE_ID);
2627: hr_utility.trace(' PREF_START_DATE : '||l_aliases(l_index).PREF_START_DATE);
2628: hr_utility.trace(' PREF_END_DATE : '||l_aliases(l_index).PREF_END_DATE);
2629: hr_utility.trace(' ALIAS_DEFINITION_ID : '||l_aliases(l_index).ALIAS_DEFINITION_ID);
2630: hr_utility.trace(' ITEM_ATTRIBUTE_CATEGORY : '||l_aliases(l_index).ITEM_ATTRIBUTE_CATEGORY);
2631: hr_utility.trace(' LAYOUT_ID : '||l_aliases(l_index).LAYOUT_ID);
2632: hr_utility.trace(' ALIAS_LABEL : '||l_aliases(l_index).ALIAS_LABEL);
2633:
2634: l_index := l_aliases.NEXT(l_index);

Line 2631: hr_utility.trace(' LAYOUT_ID : '||l_aliases(l_index).LAYOUT_ID);

2627: hr_utility.trace(' PREF_START_DATE : '||l_aliases(l_index).PREF_START_DATE);
2628: hr_utility.trace(' PREF_END_DATE : '||l_aliases(l_index).PREF_END_DATE);
2629: hr_utility.trace(' ALIAS_DEFINITION_ID : '||l_aliases(l_index).ALIAS_DEFINITION_ID);
2630: hr_utility.trace(' ITEM_ATTRIBUTE_CATEGORY : '||l_aliases(l_index).ITEM_ATTRIBUTE_CATEGORY);
2631: hr_utility.trace(' LAYOUT_ID : '||l_aliases(l_index).LAYOUT_ID);
2632: hr_utility.trace(' ALIAS_LABEL : '||l_aliases(l_index).ALIAS_LABEL);
2633:
2634: l_index := l_aliases.NEXT(l_index);
2635: END LOOP;

Line 2632: hr_utility.trace(' ALIAS_LABEL : '||l_aliases(l_index).ALIAS_LABEL);

2628: hr_utility.trace(' PREF_END_DATE : '||l_aliases(l_index).PREF_END_DATE);
2629: hr_utility.trace(' ALIAS_DEFINITION_ID : '||l_aliases(l_index).ALIAS_DEFINITION_ID);
2630: hr_utility.trace(' ITEM_ATTRIBUTE_CATEGORY : '||l_aliases(l_index).ITEM_ATTRIBUTE_CATEGORY);
2631: hr_utility.trace(' LAYOUT_ID : '||l_aliases(l_index).LAYOUT_ID);
2632: hr_utility.trace(' ALIAS_LABEL : '||l_aliases(l_index).ALIAS_LABEL);
2633:
2634: l_index := l_aliases.NEXT(l_index);
2635: END LOOP;
2636: END IF;

Line 2659: hr_utility.trace(' l_loop_count ::'||l_loop_count);

2655:
2656: --dbms_output.put_line('Alais defn id:'||l_pref_table(l_index).attribute1);
2657:
2658: IF g_debug THEN
2659: hr_utility.trace(' l_loop_count ::'||l_loop_count);
2660: END IF;
2661:
2662: FOR l_hours_type in csr_hours_type(p_person_id => l_resource_id,
2663: p_start_date => l_aliases(l_index).pref_start_date,

Line 2678: hr_utility.trace(' l_hours_type.alias_value_id ::'||l_hours_type.alias_value_id);

2674: l_hours_type_list(l_hours_type.alias_value_id).alias_value_id := l_hours_type.alias_value_id;
2675: l_hours_type_list(l_hours_type.alias_value_id).display_value := l_hours_type.display_value;
2676:
2677: IF g_debug THEN
2678: hr_utility.trace(' l_hours_type.alias_value_id ::'||l_hours_type.alias_value_id);
2679: hr_utility.trace(' l_hours_type.element_id ::'||l_hours_type.element_id);
2680: hr_utility.trace(' l_hours_type.alias_value_id ::'||l_hours_type.alias_value_id);
2681: hr_utility.trace(' l_hours_type.display_value ::'||l_hours_type.display_value);
2682: END IF;

Line 2679: hr_utility.trace(' l_hours_type.element_id ::'||l_hours_type.element_id);

2675: l_hours_type_list(l_hours_type.alias_value_id).display_value := l_hours_type.display_value;
2676:
2677: IF g_debug THEN
2678: hr_utility.trace(' l_hours_type.alias_value_id ::'||l_hours_type.alias_value_id);
2679: hr_utility.trace(' l_hours_type.element_id ::'||l_hours_type.element_id);
2680: hr_utility.trace(' l_hours_type.alias_value_id ::'||l_hours_type.alias_value_id);
2681: hr_utility.trace(' l_hours_type.display_value ::'||l_hours_type.display_value);
2682: END IF;
2683:

Line 2680: hr_utility.trace(' l_hours_type.alias_value_id ::'||l_hours_type.alias_value_id);

2676:
2677: IF g_debug THEN
2678: hr_utility.trace(' l_hours_type.alias_value_id ::'||l_hours_type.alias_value_id);
2679: hr_utility.trace(' l_hours_type.element_id ::'||l_hours_type.element_id);
2680: hr_utility.trace(' l_hours_type.alias_value_id ::'||l_hours_type.alias_value_id);
2681: hr_utility.trace(' l_hours_type.display_value ::'||l_hours_type.display_value);
2682: END IF;
2683:
2684: END LOOP;

Line 2681: hr_utility.trace(' l_hours_type.display_value ::'||l_hours_type.display_value);

2677: IF g_debug THEN
2678: hr_utility.trace(' l_hours_type.alias_value_id ::'||l_hours_type.alias_value_id);
2679: hr_utility.trace(' l_hours_type.element_id ::'||l_hours_type.element_id);
2680: hr_utility.trace(' l_hours_type.alias_value_id ::'||l_hours_type.alias_value_id);
2681: hr_utility.trace(' l_hours_type.display_value ::'||l_hours_type.display_value);
2682: END IF;
2683:
2684: END LOOP;
2685:

Line 2699: hr_utility.trace('Printing values in l_hours_type_list before mid-period preference change logic starts..');

2695:
2696: -- Adding logic to handle mid-period preference change, fix for bug 10006152
2697:
2698: IF g_debug THEN
2699: hr_utility.trace('Printing values in l_hours_type_list before mid-period preference change logic starts..');
2700: l_index := l_hours_type_list.FIRST;
2701: LOOP
2702: EXIT WHEN NOT l_hours_type_list.exists(l_index);
2703:

Line 2704: hr_utility.trace(' element_id : '||l_hours_type_list(l_index).element_id);

2700: l_index := l_hours_type_list.FIRST;
2701: LOOP
2702: EXIT WHEN NOT l_hours_type_list.exists(l_index);
2703:
2704: hr_utility.trace(' element_id : '||l_hours_type_list(l_index).element_id);
2705: hr_utility.trace(' alias_value_id : '||l_hours_type_list(l_index).alias_value_id);
2706: hr_utility.trace(' display_value : '||l_hours_type_list(l_index).display_value);
2707:
2708: l_index := l_hours_type_list.NEXT(l_index);

Line 2705: hr_utility.trace(' alias_value_id : '||l_hours_type_list(l_index).alias_value_id);

2701: LOOP
2702: EXIT WHEN NOT l_hours_type_list.exists(l_index);
2703:
2704: hr_utility.trace(' element_id : '||l_hours_type_list(l_index).element_id);
2705: hr_utility.trace(' alias_value_id : '||l_hours_type_list(l_index).alias_value_id);
2706: hr_utility.trace(' display_value : '||l_hours_type_list(l_index).display_value);
2707:
2708: l_index := l_hours_type_list.NEXT(l_index);
2709: END LOOP;

Line 2706: hr_utility.trace(' display_value : '||l_hours_type_list(l_index).display_value);

2702: EXIT WHEN NOT l_hours_type_list.exists(l_index);
2703:
2704: hr_utility.trace(' element_id : '||l_hours_type_list(l_index).element_id);
2705: hr_utility.trace(' alias_value_id : '||l_hours_type_list(l_index).alias_value_id);
2706: hr_utility.trace(' display_value : '||l_hours_type_list(l_index).display_value);
2707:
2708: l_index := l_hours_type_list.NEXT(l_index);
2709: END LOOP;
2710: hr_utility.trace('End of values in l_hours_type_list');

Line 2710: hr_utility.trace('End of values in l_hours_type_list');

2706: hr_utility.trace(' display_value : '||l_hours_type_list(l_index).display_value);
2707:
2708: l_index := l_hours_type_list.NEXT(l_index);
2709: END LOOP;
2710: hr_utility.trace('End of values in l_hours_type_list');
2711: END IF;
2712:
2713:
2714: l_temp1_hours_type_list := l_hours_type_list;

Line 2759: hr_utility.trace('Printing values in l_hours_type_list after mid-period preference logic ...');

2755:
2756: l_hours_type_list := l_temp2_hours_type_list;
2757:
2758: IF g_debug THEN
2759: hr_utility.trace('Printing values in l_hours_type_list after mid-period preference logic ...');
2760: l_index := l_hours_type_list.FIRST;
2761: LOOP
2762: EXIT WHEN NOT l_hours_type_list.exists(l_index);
2763:

Line 2764: hr_utility.trace(' element_id : '||l_hours_type_list(l_index).element_id);

2760: l_index := l_hours_type_list.FIRST;
2761: LOOP
2762: EXIT WHEN NOT l_hours_type_list.exists(l_index);
2763:
2764: hr_utility.trace(' element_id : '||l_hours_type_list(l_index).element_id);
2765: hr_utility.trace(' alias_value_id : '||l_hours_type_list(l_index).alias_value_id);
2766: hr_utility.trace(' display_value : '||l_hours_type_list(l_index).display_value);
2767:
2768: l_index := l_hours_type_list.NEXT(l_index);

Line 2765: hr_utility.trace(' alias_value_id : '||l_hours_type_list(l_index).alias_value_id);

2761: LOOP
2762: EXIT WHEN NOT l_hours_type_list.exists(l_index);
2763:
2764: hr_utility.trace(' element_id : '||l_hours_type_list(l_index).element_id);
2765: hr_utility.trace(' alias_value_id : '||l_hours_type_list(l_index).alias_value_id);
2766: hr_utility.trace(' display_value : '||l_hours_type_list(l_index).display_value);
2767:
2768: l_index := l_hours_type_list.NEXT(l_index);
2769: END LOOP;

Line 2766: hr_utility.trace(' display_value : '||l_hours_type_list(l_index).display_value);

2762: EXIT WHEN NOT l_hours_type_list.exists(l_index);
2763:
2764: hr_utility.trace(' element_id : '||l_hours_type_list(l_index).element_id);
2765: hr_utility.trace(' alias_value_id : '||l_hours_type_list(l_index).alias_value_id);
2766: hr_utility.trace(' display_value : '||l_hours_type_list(l_index).display_value);
2767:
2768: l_index := l_hours_type_list.NEXT(l_index);
2769: END LOOP;
2770: hr_utility.trace('End of values in l_hours_type_list');

Line 2770: hr_utility.trace('End of values in l_hours_type_list');

2766: hr_utility.trace(' display_value : '||l_hours_type_list(l_index).display_value);
2767:
2768: l_index := l_hours_type_list.NEXT(l_index);
2769: END LOOP;
2770: hr_utility.trace('End of values in l_hours_type_list');
2771: END IF;
2772:
2773: -- End of fix for bug 10006152
2774:

Line 2819: hr_utility.trace(' element_id : '||l_hours_type_list(l_index).element_id);

2815: l_index := l_hours_type_list.FIRST;
2816: LOOP
2817: EXIT WHEN NOT l_hours_type_list.exists(l_index);
2818:
2819: hr_utility.trace(' element_id : '||l_hours_type_list(l_index).element_id);
2820: hr_utility.trace(' alias_value_id : '||l_hours_type_list(l_index).alias_value_id);
2821: hr_utility.trace(' display_value : '||l_hours_type_list(l_index).display_value);
2822:
2823: l_index := l_hours_type_list.NEXT(l_index);

Line 2820: hr_utility.trace(' alias_value_id : '||l_hours_type_list(l_index).alias_value_id);

2816: LOOP
2817: EXIT WHEN NOT l_hours_type_list.exists(l_index);
2818:
2819: hr_utility.trace(' element_id : '||l_hours_type_list(l_index).element_id);
2820: hr_utility.trace(' alias_value_id : '||l_hours_type_list(l_index).alias_value_id);
2821: hr_utility.trace(' display_value : '||l_hours_type_list(l_index).display_value);
2822:
2823: l_index := l_hours_type_list.NEXT(l_index);
2824: END LOOP;

Line 2821: hr_utility.trace(' display_value : '||l_hours_type_list(l_index).display_value);

2817: EXIT WHEN NOT l_hours_type_list.exists(l_index);
2818:
2819: hr_utility.trace(' element_id : '||l_hours_type_list(l_index).element_id);
2820: hr_utility.trace(' alias_value_id : '||l_hours_type_list(l_index).alias_value_id);
2821: hr_utility.trace(' display_value : '||l_hours_type_list(l_index).display_value);
2822:
2823: l_index := l_hours_type_list.NEXT(l_index);
2824: END LOOP;
2825: END IF;

Line 2863: hr_utility.trace(' l_ht_list_string ::'||l_ht_list_string);

2859:
2860: g_hours_type_list := substr(l_ht_list_string,1,length(l_ht_list_string)-1);
2861:
2862: IF g_debug THEN
2863: hr_utility.trace(' l_ht_list_string ::'||l_ht_list_string);
2864: hr_utility.trace(' g_hours_type_list ::'||g_hours_type_list);
2865: hr_utility.trace(' RETURN THE LIST');
2866: hr_utility.trace('10006152> Debug END');
2867: END IF;

Line 2864: hr_utility.trace(' g_hours_type_list ::'||g_hours_type_list);

2860: g_hours_type_list := substr(l_ht_list_string,1,length(l_ht_list_string)-1);
2861:
2862: IF g_debug THEN
2863: hr_utility.trace(' l_ht_list_string ::'||l_ht_list_string);
2864: hr_utility.trace(' g_hours_type_list ::'||g_hours_type_list);
2865: hr_utility.trace(' RETURN THE LIST');
2866: hr_utility.trace('10006152> Debug END');
2867: END IF;
2868:

Line 2865: hr_utility.trace(' RETURN THE LIST');

2861:
2862: IF g_debug THEN
2863: hr_utility.trace(' l_ht_list_string ::'||l_ht_list_string);
2864: hr_utility.trace(' g_hours_type_list ::'||g_hours_type_list);
2865: hr_utility.trace(' RETURN THE LIST');
2866: hr_utility.trace('10006152> Debug END');
2867: END IF;
2868:
2869: RETURN g_hours_type_list;

Line 2866: hr_utility.trace('10006152> Debug END');

2862: IF g_debug THEN
2863: hr_utility.trace(' l_ht_list_string ::'||l_ht_list_string);
2864: hr_utility.trace(' g_hours_type_list ::'||g_hours_type_list);
2865: hr_utility.trace(' RETURN THE LIST');
2866: hr_utility.trace('10006152> Debug END');
2867: END IF;
2868:
2869: RETURN g_hours_type_list;
2870:

Line 2874: hr_utility.trace('if (l_index is not null) then');

2870:
2871: else
2872:
2873: IF g_debug THEN
2874: hr_utility.trace('if (l_index is not null) then');
2875: hr_utility.trace(' RETURN null ');
2876: END IF;
2877:
2878: g_hours_type_list := null; -- added for bug 8814955

Line 2875: hr_utility.trace(' RETURN null ');

2871: else
2872:
2873: IF g_debug THEN
2874: hr_utility.trace('if (l_index is not null) then');
2875: hr_utility.trace(' RETURN null ');
2876: END IF;
2877:
2878: g_hours_type_list := null; -- added for bug 8814955
2879:

Line 2887: hr_utility.trace('IF ( l_index IS NOT NULL )');

2883:
2884: ELSE -- l_index for alias list is null v115.23
2885:
2886: IF g_debug THEN
2887: hr_utility.trace('IF ( l_index IS NOT NULL )');
2888: hr_utility.trace(' RETURN null ');
2889: END IF;
2890:
2891: g_hours_type_list := null; -- added for bug 8814955

Line 2888: hr_utility.trace(' RETURN null ');

2884: ELSE -- l_index for alias list is null v115.23
2885:
2886: IF g_debug THEN
2887: hr_utility.trace('IF ( l_index IS NOT NULL )');
2888: hr_utility.trace(' RETURN null ');
2889: END IF;
2890:
2891: g_hours_type_list := null; -- added for bug 8814955
2892:

Line 2972: g_debug:=hr_utility.debug_enabled;

2968: l_array_index NUMBER := 0;
2969: l_attribute_index NUMBER;
2970: l_proc VARCHAR2(50);
2971: BEGIN
2972: g_debug:=hr_utility.debug_enabled;
2973: if g_debug then
2974: l_proc := 'attributes_to_array';
2975: hr_utility.set_location ( g_package||l_proc, 10);
2976: end if;

Line 2975: hr_utility.set_location ( g_package||l_proc, 10);

2971: BEGIN
2972: g_debug:=hr_utility.debug_enabled;
2973: if g_debug then
2974: l_proc := 'attributes_to_array';
2975: hr_utility.set_location ( g_package||l_proc, 10);
2976: end if;
2977: --initialize attribute array
2978: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
2979:

Line 3035: hr_utility.set_location ( g_package||l_proc, 20);

3031: l_attribute_index := p_attributes.next(l_attribute_index);
3032: END LOOP;
3033:
3034: if g_debug then
3035: hr_utility.set_location ( g_package||l_proc, 20);
3036: end if;
3037: RETURN l_attribute_array;
3038: END attributes_to_array;
3039: --

Line 3115: g_debug:=hr_utility.debug_enabled;

3111: l_proc VARCHAR2(50);
3112: -- l_block HXC_BLOCK_TYPE;
3113:
3114: BEGIN
3115: g_debug:=hr_utility.debug_enabled;
3116: if g_debug then
3117: l_proc := 'blocks_to_array';
3118: hr_utility.set_location ( g_package||l_proc, 10);
3119: end if;

Line 3118: hr_utility.set_location ( g_package||l_proc, 10);

3114: BEGIN
3115: g_debug:=hr_utility.debug_enabled;
3116: if g_debug then
3117: l_proc := 'blocks_to_array';
3118: hr_utility.set_location ( g_package||l_proc, 10);
3119: end if;
3120: l_block_array := HXC_BLOCK_TABLE_TYPE();
3121:
3122: l_block_index := p_blocks.first;

Line 3160: hr_utility.set_location ( g_package||l_proc, 140);

3156: l_block_index := p_blocks.next(l_block_index);
3157: END LOOP;
3158:
3159: if g_debug then
3160: hr_utility.set_location ( g_package||l_proc, 140);
3161: end if;
3162: RETURN l_block_array;
3163: END blocks_to_array;
3164:

Line 3206: hr_utility.trace('transaction details are ');

3202:
3203: BEGIN
3204: if g_debug then
3205: l_proc := g_package||'.maintain_errors';
3206: hr_utility.trace('transaction details are ');
3207: end if;
3208: /*
3209: FOR x in p_transactions.FIRST .. p_transactions.LAST
3210: LOOP

Line 3212: hr_utility.trace('txd tbb id is '||to_char(p_transactions(x).tbb_id));

3208: /*
3209: FOR x in p_transactions.FIRST .. p_transactions.LAST
3210: LOOP
3211: if g_debug then
3212: hr_utility.trace('txd tbb id is '||to_char(p_transactions(x).tbb_id));
3213: hr_utility.trace('txd txd id is '||to_char(p_transactions(x).txd_id));
3214: end if;
3215: END LOOP;
3216:

Line 3213: hr_utility.trace('txd txd id is '||to_char(p_transactions(x).txd_id));

3209: FOR x in p_transactions.FIRST .. p_transactions.LAST
3210: LOOP
3211: if g_debug then
3212: hr_utility.trace('txd tbb id is '||to_char(p_transactions(x).tbb_id));
3213: hr_utility.trace('txd txd id is '||to_char(p_transactions(x).txd_id));
3214: end if;
3215: END LOOP;
3216:
3217: if g_debug then

Line 3218: hr_utility.trace('');

3214: end if;
3215: END LOOP;
3216:
3217: if g_debug then
3218: hr_utility.trace('');
3219: hr_utility.trace('messages are ');
3220: end if;
3221:
3222: FOR x in p_messages.FIRST .. p_messages.LAST

Line 3219: hr_utility.trace('messages are ');

3215: END LOOP;
3216:
3217: if g_debug then
3218: hr_utility.trace('');
3219: hr_utility.trace('messages are ');
3220: end if;
3221:
3222: FOR x in p_messages.FIRST .. p_messages.LAST
3223: LOOP

Line 3225: hr_utility.trace('message name is '||p_messages(x).message_name);

3221:
3222: FOR x in p_messages.FIRST .. p_messages.LAST
3223: LOOP
3224: if g_debug then
3225: hr_utility.trace('message name is '||p_messages(x).message_name);
3226: hr_utility.trace('tbb id is '||to_char(p_messages(x).time_building_block_id));
3227: hr_utility.trace('tbb ovn is '||to_char(p_messages(x).time_building_block_ovn));
3228: end if;
3229: END LOOP;

Line 3226: hr_utility.trace('tbb id is '||to_char(p_messages(x).time_building_block_id));

3222: FOR x in p_messages.FIRST .. p_messages.LAST
3223: LOOP
3224: if g_debug then
3225: hr_utility.trace('message name is '||p_messages(x).message_name);
3226: hr_utility.trace('tbb id is '||to_char(p_messages(x).time_building_block_id));
3227: hr_utility.trace('tbb ovn is '||to_char(p_messages(x).time_building_block_ovn));
3228: end if;
3229: END LOOP;
3230: */

Line 3227: hr_utility.trace('tbb ovn is '||to_char(p_messages(x).time_building_block_ovn));

3223: LOOP
3224: if g_debug then
3225: hr_utility.trace('message name is '||p_messages(x).message_name);
3226: hr_utility.trace('tbb id is '||to_char(p_messages(x).time_building_block_id));
3227: hr_utility.trace('tbb ovn is '||to_char(p_messages(x).time_building_block_ovn));
3228: end if;
3229: END LOOP;
3230: */
3231:

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

3229: END LOOP;
3230: */
3231:
3232: if g_debug then
3233: hr_utility.set_location('Entering '||l_proc, 10);
3234: end if;
3235:
3236: -- parse the transaction table to produce a mapping of time building blocks
3237: -- to transaction details id- this will save traversing the table for every message

Line 3247: hr_utility.set_location('Processing '||l_proc, 20);

3243: WHILE l_tx_ind IS NOT NULL
3244: LOOP
3245:
3246: if g_debug then
3247: hr_utility.set_location('Processing '||l_proc, 20);
3248: end if;
3249:
3250: t_tbb_vs_txds(p_transactions(l_tx_ind).tbb_id).txd_id := p_transactions(l_tx_ind).txd_id;
3251:

Line 3257: hr_utility.set_location('Processing '||l_proc, 30);

3253:
3254: END LOOP;
3255:
3256: if g_debug then
3257: hr_utility.set_location('Processing '||l_proc, 30);
3258: end if;
3259:
3260: -- if the timecard has just been inserted need to map dummy ids to new ids
3261:

Line 3267: hr_utility.set_location('Processing '||l_proc, 40);

3263:
3264: WHILE ( l_msg_ind IS NOT NULL )
3265: LOOP
3266: if g_debug then
3267: hr_utility.set_location('Processing '||l_proc, 40);
3268: end if;
3269: -- assign to variables (makes it easier to read the following code)
3270:
3271: l_tbb_id := p_messages(l_msg_ind).time_building_block_id;

Line 3277: hr_utility.set_location('Processing '||l_proc, 50);

3273:
3274: IF ( ( l_tbb_id IS NOT NULL ) AND ( p_translated_bb_ids_tab.COUNT <> 0 ) )
3275: THEN
3276: if g_debug then
3277: hr_utility.set_location('Processing '||l_proc, 50);
3278: end if;
3279: -- this may not be a new building block
3280:
3281: IF ( p_translated_bb_ids_tab.EXISTS(l_tbb_id) )

Line 3284: hr_utility.set_location('Processing '||l_proc, 60);

3280:
3281: IF ( p_translated_bb_ids_tab.EXISTS(l_tbb_id) )
3282: THEN
3283: if g_debug then
3284: hr_utility.set_location('Processing '||l_proc, 60);
3285: end if;
3286: p_messages(l_msg_ind).time_building_block_id :=
3287: p_translated_bb_ids_tab(l_tbb_id).actual_bb_id;
3288:

Line 3299: hr_utility.set_location('Processing '||l_proc, 70);

3295:
3296: END IF;
3297:
3298: if g_debug then
3299: hr_utility.set_location('Processing '||l_proc, 70);
3300: end if;
3301: -- now the attribute
3302:
3303: IF ( ( l_ta_id IS NOT NULL ) AND ( p_translated_ta_ids_tab.COUNT <> 0 ) )

Line 3317: hr_utility.set_location('Processing '||l_proc, 75);

3313:
3314: END IF;
3315:
3316: if g_debug then
3317: hr_utility.set_location('Processing '||l_proc, 75);
3318: end if;
3319: -- find the ovn of the tbb
3320: OPEN c_max_ovn(p_messages(l_msg_ind).time_building_block_id);
3321: FETCH c_max_ovn INTO l_tbb_ovn;

Line 3366: hr_utility.set_location('Leaving '||l_proc, 80);

3362:
3363: END LOOP;
3364:
3365: if g_debug then
3366: hr_utility.set_location('Leaving '||l_proc, 80);
3367: end if;
3368: END maintain_errors;
3369:
3370: /*This function obtains the PAEXPITDFF code from the PAEXPITDFF name.

Line 3413: hr_utility.set_message(809,'HXC_DFF_SYSTEM_CONTEXT');

3409:
3410: IF l_code IS NULL
3411: THEN
3412:
3413: hr_utility.set_message(809,'HXC_DFF_SYSTEM_CONTEXT');
3414: l_message := hr_utility.get_message;
3415: OPEN get_code(p_dupdff_name,l_message);
3416: FETCH get_code INTO l_code;
3417:

Line 3414: l_message := hr_utility.get_message;

3410: IF l_code IS NULL
3411: THEN
3412:
3413: hr_utility.set_message(809,'HXC_DFF_SYSTEM_CONTEXT');
3414: l_message := hr_utility.get_message;
3415: OPEN get_code(p_dupdff_name,l_message);
3416: FETCH get_code INTO l_code;
3417:
3418: if l_code is null then

Line 3482: hr_utility.set_message (809, 'HXC_DFF_SYSTEM_CONTEXT');

3478: RETURN(l_name);
3479:
3480: ELSE
3481:
3482: hr_utility.set_message (809, 'HXC_DFF_SYSTEM_CONTEXT');
3483: l_message := hr_utility.GET_MESSAGE;
3484: OPEN get_name (p_dupdff_code, l_message);
3485: FETCH get_name INTO l_name;
3486:

Line 3483: l_message := hr_utility.GET_MESSAGE;

3479:
3480: ELSE
3481:
3482: hr_utility.set_message (809, 'HXC_DFF_SYSTEM_CONTEXT');
3483: l_message := hr_utility.GET_MESSAGE;
3484: OPEN get_name (p_dupdff_code, l_message);
3485: FETCH get_name INTO l_name;
3486:
3487: IF l_name IS NULL