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.

[Home] [Help]

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 2450: g_debug:=hr_utility.debug_enabled;

2446:
2447:
2448: BEGIN
2449:
2450: g_debug:=hr_utility.debug_enabled;
2451: l_time_diff := 24*60*(sysdate - g_ht_time);
2452:
2453: -- check to see if we can use a cached result
2454:

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

2501: ,p_stop_time => p_stop_time
2502: ,p_resource_id => l_resource_id );
2503:
2504: --if g_debug then
2505: --hr_utility.trace('p_alias_or_element_id '||p_alias_or_element_id);
2506: --end if;
2507:
2508: END IF;
2509:

Line 2716: g_debug:=hr_utility.debug_enabled;

2712: l_array_index NUMBER := 0;
2713: l_attribute_index NUMBER;
2714: l_proc VARCHAR2(50);
2715: BEGIN
2716: g_debug:=hr_utility.debug_enabled;
2717: if g_debug then
2718: l_proc := 'attributes_to_array';
2719: hr_utility.set_location ( g_package||l_proc, 10);
2720: end if;

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

2715: BEGIN
2716: g_debug:=hr_utility.debug_enabled;
2717: if g_debug then
2718: l_proc := 'attributes_to_array';
2719: hr_utility.set_location ( g_package||l_proc, 10);
2720: end if;
2721: --initialize attribute array
2722: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
2723:

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

2775: l_attribute_index := p_attributes.next(l_attribute_index);
2776: END LOOP;
2777:
2778: if g_debug then
2779: hr_utility.set_location ( g_package||l_proc, 20);
2780: end if;
2781: RETURN l_attribute_array;
2782: END attributes_to_array;
2783: --

Line 2859: g_debug:=hr_utility.debug_enabled;

2855: l_proc VARCHAR2(50);
2856: -- l_block HXC_BLOCK_TYPE;
2857:
2858: BEGIN
2859: g_debug:=hr_utility.debug_enabled;
2860: if g_debug then
2861: l_proc := 'blocks_to_array';
2862: hr_utility.set_location ( g_package||l_proc, 10);
2863: end if;

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

2858: BEGIN
2859: g_debug:=hr_utility.debug_enabled;
2860: if g_debug then
2861: l_proc := 'blocks_to_array';
2862: hr_utility.set_location ( g_package||l_proc, 10);
2863: end if;
2864: l_block_array := HXC_BLOCK_TABLE_TYPE();
2865:
2866: l_block_index := p_blocks.first;

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

2900: l_block_index := p_blocks.next(l_block_index);
2901: END LOOP;
2902:
2903: if g_debug then
2904: hr_utility.set_location ( g_package||l_proc, 140);
2905: end if;
2906: RETURN l_block_array;
2907: END blocks_to_array;
2908:

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

2946:
2947: BEGIN
2948: if g_debug then
2949: l_proc := g_package||'.maintain_errors';
2950: hr_utility.trace('transaction details are ');
2951: end if;
2952: /*
2953: FOR x in p_transactions.FIRST .. p_transactions.LAST
2954: LOOP

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

2952: /*
2953: FOR x in p_transactions.FIRST .. p_transactions.LAST
2954: LOOP
2955: if g_debug then
2956: hr_utility.trace('txd tbb id is '||to_char(p_transactions(x).tbb_id));
2957: hr_utility.trace('txd txd id is '||to_char(p_transactions(x).txd_id));
2958: end if;
2959: END LOOP;
2960:

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

2953: FOR x in p_transactions.FIRST .. p_transactions.LAST
2954: LOOP
2955: if g_debug then
2956: hr_utility.trace('txd tbb id is '||to_char(p_transactions(x).tbb_id));
2957: hr_utility.trace('txd txd id is '||to_char(p_transactions(x).txd_id));
2958: end if;
2959: END LOOP;
2960:
2961: if g_debug then

Line 2962: hr_utility.trace('');

2958: end if;
2959: END LOOP;
2960:
2961: if g_debug then
2962: hr_utility.trace('');
2963: hr_utility.trace('messages are ');
2964: end if;
2965:
2966: FOR x in p_messages.FIRST .. p_messages.LAST

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

2959: END LOOP;
2960:
2961: if g_debug then
2962: hr_utility.trace('');
2963: hr_utility.trace('messages are ');
2964: end if;
2965:
2966: FOR x in p_messages.FIRST .. p_messages.LAST
2967: LOOP

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

2965:
2966: FOR x in p_messages.FIRST .. p_messages.LAST
2967: LOOP
2968: if g_debug then
2969: hr_utility.trace('message name is '||p_messages(x).message_name);
2970: hr_utility.trace('tbb id is '||to_char(p_messages(x).time_building_block_id));
2971: hr_utility.trace('tbb ovn is '||to_char(p_messages(x).time_building_block_ovn));
2972: end if;
2973: END LOOP;

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

2966: FOR x in p_messages.FIRST .. p_messages.LAST
2967: LOOP
2968: if g_debug then
2969: hr_utility.trace('message name is '||p_messages(x).message_name);
2970: hr_utility.trace('tbb id is '||to_char(p_messages(x).time_building_block_id));
2971: hr_utility.trace('tbb ovn is '||to_char(p_messages(x).time_building_block_ovn));
2972: end if;
2973: END LOOP;
2974: */

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

2967: LOOP
2968: if g_debug then
2969: hr_utility.trace('message name is '||p_messages(x).message_name);
2970: hr_utility.trace('tbb id is '||to_char(p_messages(x).time_building_block_id));
2971: hr_utility.trace('tbb ovn is '||to_char(p_messages(x).time_building_block_ovn));
2972: end if;
2973: END LOOP;
2974: */
2975:

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

2973: END LOOP;
2974: */
2975:
2976: if g_debug then
2977: hr_utility.set_location('Entering '||l_proc, 10);
2978: end if;
2979:
2980: -- parse the transaction table to produce a mapping of time building blocks
2981: -- to transaction details id- this will save traversing the table for every message

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

2987: WHILE l_tx_ind IS NOT NULL
2988: LOOP
2989:
2990: if g_debug then
2991: hr_utility.set_location('Processing '||l_proc, 20);
2992: end if;
2993:
2994: t_tbb_vs_txds(p_transactions(l_tx_ind).tbb_id).txd_id := p_transactions(l_tx_ind).txd_id;
2995:

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

2997:
2998: END LOOP;
2999:
3000: if g_debug then
3001: hr_utility.set_location('Processing '||l_proc, 30);
3002: end if;
3003:
3004: -- if the timecard has just been inserted need to map dummy ids to new ids
3005:

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

3007:
3008: WHILE ( l_msg_ind IS NOT NULL )
3009: LOOP
3010: if g_debug then
3011: hr_utility.set_location('Processing '||l_proc, 40);
3012: end if;
3013: -- assign to variables (makes it easier to read the following code)
3014:
3015: l_tbb_id := p_messages(l_msg_ind).time_building_block_id;

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

3017:
3018: IF ( ( l_tbb_id IS NOT NULL ) AND ( p_translated_bb_ids_tab.COUNT <> 0 ) )
3019: THEN
3020: if g_debug then
3021: hr_utility.set_location('Processing '||l_proc, 50);
3022: end if;
3023: -- this may not be a new building block
3024:
3025: IF ( p_translated_bb_ids_tab.EXISTS(l_tbb_id) )

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

3024:
3025: IF ( p_translated_bb_ids_tab.EXISTS(l_tbb_id) )
3026: THEN
3027: if g_debug then
3028: hr_utility.set_location('Processing '||l_proc, 60);
3029: end if;
3030: p_messages(l_msg_ind).time_building_block_id :=
3031: p_translated_bb_ids_tab(l_tbb_id).actual_bb_id;
3032:

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

3039:
3040: END IF;
3041:
3042: if g_debug then
3043: hr_utility.set_location('Processing '||l_proc, 70);
3044: end if;
3045: -- now the attribute
3046:
3047: IF ( ( l_ta_id IS NOT NULL ) AND ( p_translated_ta_ids_tab.COUNT <> 0 ) )

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

3057:
3058: END IF;
3059:
3060: if g_debug then
3061: hr_utility.set_location('Processing '||l_proc, 75);
3062: end if;
3063: -- find the ovn of the tbb
3064: OPEN c_max_ovn(p_messages(l_msg_ind).time_building_block_id);
3065: FETCH c_max_ovn INTO l_tbb_ovn;

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

3106:
3107: END LOOP;
3108:
3109: if g_debug then
3110: hr_utility.set_location('Leaving '||l_proc, 80);
3111: end if;
3112: END maintain_errors;
3113:
3114: /*This function obtains the PAEXPITDFF code from the PAEXPITDFF name.

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

3153:
3154: IF l_code IS NULL
3155: THEN
3156:
3157: hr_utility.set_message(809,'HXC_DFF_SYSTEM_CONTEXT');
3158: l_message := hr_utility.get_message;
3159: OPEN get_code(p_dupdff_name,l_message);
3160: FETCH get_code INTO l_code;
3161:

Line 3158: l_message := hr_utility.get_message;

3154: IF l_code IS NULL
3155: THEN
3156:
3157: hr_utility.set_message(809,'HXC_DFF_SYSTEM_CONTEXT');
3158: l_message := hr_utility.get_message;
3159: OPEN get_code(p_dupdff_name,l_message);
3160: FETCH get_code INTO l_code;
3161:
3162: if l_code is null then

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

3222: RETURN(l_name);
3223:
3224: ELSE
3225:
3226: hr_utility.set_message (809, 'HXC_DFF_SYSTEM_CONTEXT');
3227: l_message := hr_utility.GET_MESSAGE;
3228: OPEN get_name (p_dupdff_code, l_message);
3229: FETCH get_name INTO l_name;
3230:

Line 3227: l_message := hr_utility.GET_MESSAGE;

3223:
3224: ELSE
3225:
3226: hr_utility.set_message (809, 'HXC_DFF_SYSTEM_CONTEXT');
3227: l_message := hr_utility.GET_MESSAGE;
3228: OPEN get_name (p_dupdff_code, l_message);
3229: FETCH get_name INTO l_name;
3230:
3231: IF l_name IS NULL