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.PQP_UTILITIES dependencies on HR_UTILITY

Line 49: hr_utility.set_location(l_trace_message, p_trace_location);

45: ELSE
46: l_trace_message := SUBSTR(p_trace_message,1,250);
47: END IF;
48:
49: hr_utility.set_location(l_trace_message, p_trace_location);
50: ELSE
51: IF NOT g_debug_entry_exits_only
52: THEN
53: hr_utility.TRACE(SUBSTR(p_trace_message, 1, 250));

Line 53: hr_utility.TRACE(SUBSTR(p_trace_message, 1, 250));

49: hr_utility.set_location(l_trace_message, p_trace_location);
50: ELSE
51: IF NOT g_debug_entry_exits_only
52: THEN
53: hr_utility.TRACE(SUBSTR(p_trace_message, 1, 250));
54: END IF;
55: END IF;
56: END debug;
57:

Line 561: IF SQLCODE <> hr_utility.hr_error_number

557: WHEN OTHERS
558: THEN
559: --clear_cache;
560:
561: IF SQLCODE <> hr_utility.hr_error_number
562: THEN
563: debug_others(l_proc_name, l_proc_step);
564:
565: IF g_debug

Line 699: g_debug := hr_utility.debug_enabled;

695: TYPE ref_csr_typ IS REF CURSOR;
696:
697: c_column ref_csr_typ;
698: BEGIN
699: g_debug := hr_utility.debug_enabled;
700: IF g_debug THEN
701: debug_enter(l_proc_name);
702: END IF;
703: p_error_code := 0;

Line 836: g_debug := hr_utility.debug_enabled;

832: l_data_type fnd_columns.column_type%TYPE;
833: l_proc_name VARCHAR2(61)
834: := g_package_name || 'get_data_type';
835: BEGIN
836: g_debug := hr_utility.debug_enabled;
837: IF g_debug THEN
838: debug_enter(l_proc_name);
839: END IF;
840: p_error_code := 0;

Line 904: g_debug := hr_utility.debug_enabled;

900: l_where VARCHAR2(1000);
901: l_proc_name VARCHAR2(61)
902: := g_package_name || 'get_ddf_value';
903: BEGIN
904: g_debug := hr_utility.debug_enabled;
905: IF g_debug THEN
906: debug_enter(l_proc_name);
907: END IF;
908:

Line 1067: g_debug := hr_utility.debug_enabled;

1063: c_context context_ref_csr_typ;
1064: l_proc_name VARCHAR2(61)
1065: := g_package_name || 'get_df_value';
1066: BEGIN
1067: g_debug := hr_utility.debug_enabled;
1068: IF g_debug THEN
1069: debug_enter(l_proc_name);
1070: END IF;
1071: p_error_code := 0;

Line 1165: g_debug := hr_utility.debug_enabled;

1161: l_col_name VARCHAR2(30);
1162: l_proc_name VARCHAR2(61)
1163: := g_package_name || 'get_segment_name';
1164: BEGIN
1165: g_debug := hr_utility.debug_enabled;
1166: IF g_debug THEN
1167: debug_enter(l_proc_name);
1168: END IF;
1169: p_error_code := 0;

Line 1240: g_debug := hr_utility.debug_enabled;

1236: l_concat_string VARCHAR2(2000);
1237: l_proc_name VARCHAR2(61)
1238: := g_package_name || 'pqp_get_concat_value';
1239: BEGIN
1240: g_debug := hr_utility.debug_enabled;
1241: IF g_debug THEN
1242: debug_enter(l_proc_name);
1243: END IF;
1244: OPEN c_rowid FOR ' SELECT rowid FROM '

Line 1309: g_debug := hr_utility.debug_enabled;

1305: c_value col_value_ref_csr_typ;
1306: l_proc_name VARCHAR2(61)
1307: := g_package_name || 'pqp_get_extra_element_mult';
1308: BEGIN
1309: g_debug := hr_utility.debug_enabled;
1310: IF g_debug THEN
1311: debug_enter(l_proc_name);
1312: END IF;
1313: l_col_name :=

Line 1401: g_debug := hr_utility.debug_enabled;

1397:
1398: l_proc_name VARCHAR2(61)
1399: := g_package_name || 'pqp_get_extra_element_info';
1400: BEGIN
1401: g_debug := hr_utility.debug_enabled;
1402: IF g_debug THEN
1403: debug_enter(l_proc_name);
1404: END IF;
1405: OPEN csr_mult_occur(p_information_type => p_information_type);

Line 1528: g_debug := hr_utility.debug_enabled;

1524: l_proc_name VARCHAR2(61)
1525: := g_package_name || 'pqp_get_extra_element_info_det';
1526: l_error_code NUMBER;
1527: BEGIN
1528: g_debug := hr_utility.debug_enabled;
1529: IF g_debug THEN
1530: debug_enter(l_proc_name);
1531: END IF;
1532: --

Line 1668: g_debug := hr_utility.debug_enabled;

1664: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1665: l_proc_name VARCHAR2(61)
1666: := g_package_name || 'pqp_get_element_type_id';
1667: BEGIN
1668: g_debug := hr_utility.debug_enabled;
1669: IF g_debug THEN
1670: debug_enter(l_proc_name);
1671: END IF;
1672: p_error_code := 0;

Line 1729: g_debug := hr_utility.debug_enabled;

1725: l_proc_name VARCHAR2(61)
1726: := g_package_name || 'pqp_get_element_extra_info';
1727: l_legislation_code per_business_groups.legislation_code%TYPE;
1728: BEGIN
1729: g_debug := hr_utility.debug_enabled;
1730: IF g_debug THEN
1731: debug_enter(l_proc_name);
1732: END IF;
1733: IF g_debug THEN

Line 1816: g_debug := hr_utility.debug_enabled;

1812: := g_package_name || 'pqp_get_element_extra_info_det';
1813: l_legislation_code per_business_groups.legislation_code%TYPE;
1814: l_error_code NUMBER;
1815: BEGIN
1816: g_debug := hr_utility.debug_enabled;
1817: IF g_debug THEN
1818: debug_enter(l_proc_name);
1819: END IF;
1820: --

Line 2014: g_debug := hr_utility.debug_enabled;

2010: l_proc_name VARCHAR2(60)
2011: := g_package_name || 'delete_udt_data';
2012: i NUMBER;
2013: BEGIN
2014: g_debug := hr_utility.debug_enabled;
2015: IF g_debug THEN
2016: debug_enter(l_proc_name);
2017: debug('p_table_name' || p_table_name);
2018: END IF;

Line 2125: g_debug := hr_utility.debug_enabled;

2121: l_proc_name VARCHAR2(61)
2122: := g_package_name || 'pqp_get_legislation_code';
2123: l_legislation_code VARCHAR2(30);
2124: BEGIN
2125: g_debug := hr_utility.debug_enabled;
2126: IF g_debug THEN
2127: debug_enter(l_proc_name);
2128: END IF;
2129: --

Line 2235: g_debug := hr_utility.debug_enabled;

2231: := g_package_name || 'get_udt_data';
2232: l_row_high_range pay_user_rows_f.row_high_range%TYPE;
2233: l_column_name VARCHAR2(240);
2234: BEGIN
2235: g_debug := hr_utility.debug_enabled;
2236: IF g_debug THEN
2237: debug_enter(l_proc_name);
2238: debug('p_column_name '||p_column_name);
2239: END IF;

Line 2346: g_debug := hr_utility.debug_enabled;

2342: l_proc_name VARCHAR2(70)
2343: := g_package_name || 'get_udt_value';
2344: i NUMBER;
2345: BEGIN
2346: g_debug := hr_utility.debug_enabled;
2347: IF g_debug THEN
2348: debug_enter(l_proc_name);
2349: END IF;
2350: OPEN csr_get_range_match(p_table_name => p_table_name);

Line 2399: -- Function to Set Trace on. This is a wrapper around hr_utility.trace_on

2395: RETURN l_return_value;
2396: END get_udt_value;
2397:
2398:
2399: -- Function to Set Trace on. This is a wrapper around hr_utility.trace_on
2400: -- Procedure.
2401: FUNCTION set_trace_on(
2402: p_trace_destination IN VARCHAR2
2403: ,p_trace_coverage IN VARCHAR2

Line 2409: hr_utility.trace_on(

2405: )
2406: RETURN NUMBER
2407: IS
2408: BEGIN
2409: hr_utility.trace_on(
2410: trace_mode => p_trace_coverage
2411: ,session_identifier => p_trace_destination
2412: );
2413: RETURN 0;

Line 2426: hr_utility.trace_on(trace_mode => 'F', session_identifier => 'REQID');

2422: FUNCTION set_request_trace_on(p_error_message OUT NOCOPY VARCHAR2)
2423: RETURN NUMBER
2424: IS
2425: BEGIN
2426: hr_utility.trace_on(trace_mode => 'F', session_identifier => 'REQID');
2427: RETURN 0;
2428: EXCEPTION
2429: WHEN OTHERS
2430: THEN

Line 2435: -- Function to Set Trace off. A Wrapper for hr_utility.trace_off.

2431: p_error_message := SQLERRM;
2432: RETURN -1;
2433: END set_request_trace_on;
2434:
2435: -- Function to Set Trace off. A Wrapper for hr_utility.trace_off.
2436: FUNCTION set_trace_off(p_error_message OUT NOCOPY VARCHAR2)
2437: RETURN NUMBER
2438: IS
2439: l_trace_status NUMBER := 0;

Line 2441: hr_utility.trace_off;

2437: RETURN NUMBER
2438: IS
2439: l_trace_status NUMBER := 0;
2440: BEGIN
2441: hr_utility.trace_off;
2442: RETURN l_trace_status;
2443: EXCEPTION
2444: WHEN OTHERS
2445: THEN

Line 2463: g_debug := hr_utility.debug_enabled;

2459: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
2460: l_proc_name VARCHAR2(61)
2461: := g_package_name || 'get_lookup_code';
2462: BEGIN
2463: g_debug := hr_utility.debug_enabled;
2464: IF g_debug THEN
2465: debug_enter(l_proc_name);
2466: END IF;
2467: OPEN csr_lookup_code(

Line 2529: g_debug := hr_utility.debug_enabled;

2525: := g_package_name || 'delete_formula';
2526: l_formula_rowid ROWID;
2527: l_return_code NUMBER := 0;
2528: BEGIN
2529: g_debug := hr_utility.debug_enabled;
2530: IF g_debug THEN
2531: debug_enter(l_proc_name);
2532: END IF;
2533: p_error_code := 0;

Line 2687: g_debug := hr_utility.debug_enabled;

2683: l_itr NUMBER;
2684: l_proc_name VARCHAR2(61)
2685: := g_package_name || 'get_events';
2686: BEGIN
2687: g_debug := hr_utility.debug_enabled;
2688: IF g_debug THEN
2689: debug_enter(l_proc_name);
2690: END IF;
2691: l_event_group_id :=

Line 2807: g_debug := hr_utility.debug_enabled;

2803: l_itr NUMBER;
2804: l_proc_name VARCHAR2(61)
2805: := g_package_name || 'get_events';
2806: BEGIN
2807: g_debug := hr_utility.debug_enabled;
2808: IF g_debug THEN
2809: debug_enter(l_proc_name);
2810: END IF;
2811: l_event_group_id :=

Line 2878: g_debug := hr_utility.debug_enabled;

2874: l_proc_name VARCHAR2(61):=
2875: g_package_name || 'check_error_code';
2876:
2877: BEGIN
2878: g_debug := hr_utility.debug_enabled;
2879: IF g_debug THEN
2880: debug_enter(l_proc_name);
2881: debug('p_error_code:' ||fnd_number.number_to_canonical(p_error_code));
2882: debug('p_error_message:'||p_error_message);

Line 2888: --IF p_error_code <> hr_utility.hr_error_number

2884:
2885: IF p_error_code < 0
2886: THEN
2887:
2888: --IF p_error_code <> hr_utility.hr_error_number
2889: --THEN
2890: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
2891: fnd_message.set_token('TOKEN', p_error_message);
2892: fnd_message.raise_error;

Line 2988: g_debug := hr_utility.debug_enabled;

2984: l_proc_name VARCHAR2(61) := g_package_name || 'round_value_up_down';
2985:
2986: BEGIN
2987:
2988: g_debug := hr_utility.debug_enabled;
2989:
2990: IF g_debug THEN
2991: debug_enter(l_proc_name);
2992: debug('p_value_to_round:'||p_value_to_round);

Line 3134: g_debug := hr_utility.debug_enabled;

3130: l_proc_name VARCHAR2(61)
3131: := g_package_name || 'pqp_get_ele_type_extra_info_id';
3132:
3133: BEGIN
3134: g_debug := hr_utility.debug_enabled;
3135: IF g_debug THEN
3136: debug_enter(l_proc_name);
3137: END IF;
3138:

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

3335:
3336: l_query VARCHAR2(4000); -- Dynamically constructed query
3337:
3338: BEGIN
3339: hr_utility.set_location('Entering '||l_proc,10);
3340: IF (p_entity_name is not null) AND
3341: (p_key_column_name is not null) AND
3342: (p_key_column_value is not null) THEN
3343:

Line 3354: hr_utility.trace('l_query: '||l_query);

3350:
3351: l_query := l_query||
3352: ' FROM '||p_entity_name||' '||
3353: 'WHERE '||p_key_column_name||' = '||p_key_column_value;
3354: hr_utility.trace('l_query: '||l_query);
3355: hr_utility.trace('Before opening dynamic query');
3356:
3357: OPEN c_base_table FOR l_query;
3358: FETCH c_base_table INTO p_segment_column_values;

Line 3355: hr_utility.trace('Before opening dynamic query');

3351: l_query := l_query||
3352: ' FROM '||p_entity_name||' '||
3353: 'WHERE '||p_key_column_name||' = '||p_key_column_value;
3354: hr_utility.trace('l_query: '||l_query);
3355: hr_utility.trace('Before opening dynamic query');
3356:
3357: OPEN c_base_table FOR l_query;
3358: FETCH c_base_table INTO p_segment_column_values;
3359: CLOSE c_base_table;

Line 3360: hr_utility.trace('After precessing dynamic query');

3356:
3357: OPEN c_base_table FOR l_query;
3358: FETCH c_base_table INTO p_segment_column_values;
3359: CLOSE c_base_table;
3360: hr_utility.trace('After precessing dynamic query');
3361: END IF; -- IF (p_entity_name is not null) AND..
3362: hr_utility.set_location('Leaving '||l_proc,10);
3363: END get_kflex_value;
3364: ---

Line 3362: hr_utility.set_location('Leaving '||l_proc,10);

3358: FETCH c_base_table INTO p_segment_column_values;
3359: CLOSE c_base_table;
3360: hr_utility.trace('After precessing dynamic query');
3361: END IF; -- IF (p_entity_name is not null) AND..
3362: hr_utility.set_location('Leaving '||l_proc,10);
3363: END get_kflex_value;
3364: ---
3365: -- ----------------------------------------------------------------------------
3366: -- |-------------------------< get_kflex_value >-----------------------------|

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

3383: c_base_table base_table_ref_csr_typ;
3384:
3385: l_query VARCHAR2(4000); -- Dynamically constructed query
3386: BEGIN
3387: hr_utility.set_location('Entering '||l_proc,10);
3388: l_query := 'SELECT '|| p_segment_column_name ||'
3389: FROM '|| p_entity_name ||'
3390: WHERE '||p_key_column_name||' = '|| p_key_column_value;
3391:

Line 3396: hr_utility.set_location('Leaving '||l_proc,10);

3392: OPEN c_base_table FOR l_query;
3393: FETCH c_base_table INTO p_segment_column_value;
3394: CLOSE c_base_table;
3395:
3396: hr_utility.set_location('Leaving '||l_proc,10);
3397: END get_kflex_value;
3398: --
3399: /*---------------------------------------------------------------/
3400: /--Description: This is a wrapper procedure on pay_interpreter_pkg.entries_affected

Line 3536: hr_utility.trace('Entering: '||l_proc);

3532: AND ppe.effective_date BETWEEN p_start_date AND p_end_date;
3533:
3534:
3535: BEGIN
3536: hr_utility.trace('Entering: '||l_proc);
3537: hr_utility.trace('Entered get_element_entries_for_eg: EG_Id:'||to_char(p_event_group_id));
3538: hr_utility.trace('Assignment Id:'||to_char(p_assignment_id));
3539: hr_utility.trace('Start Date:'||to_char(p_start_date, 'DD/MM/YYYY'));
3540: hr_utility.trace('End Date:'||to_char(p_end_date, 'DD/MM/YYYY'));

Line 3537: hr_utility.trace('Entered get_element_entries_for_eg: EG_Id:'||to_char(p_event_group_id));

3533:
3534:
3535: BEGIN
3536: hr_utility.trace('Entering: '||l_proc);
3537: hr_utility.trace('Entered get_element_entries_for_eg: EG_Id:'||to_char(p_event_group_id));
3538: hr_utility.trace('Assignment Id:'||to_char(p_assignment_id));
3539: hr_utility.trace('Start Date:'||to_char(p_start_date, 'DD/MM/YYYY'));
3540: hr_utility.trace('End Date:'||to_char(p_end_date, 'DD/MM/YYYY'));
3541:

Line 3538: hr_utility.trace('Assignment Id:'||to_char(p_assignment_id));

3534:
3535: BEGIN
3536: hr_utility.trace('Entering: '||l_proc);
3537: hr_utility.trace('Entered get_element_entries_for_eg: EG_Id:'||to_char(p_event_group_id));
3538: hr_utility.trace('Assignment Id:'||to_char(p_assignment_id));
3539: hr_utility.trace('Start Date:'||to_char(p_start_date, 'DD/MM/YYYY'));
3540: hr_utility.trace('End Date:'||to_char(p_end_date, 'DD/MM/YYYY'));
3541:
3542: p_element_entries_tab.element_entry_id.DELETE;

Line 3539: hr_utility.trace('Start Date:'||to_char(p_start_date, 'DD/MM/YYYY'));

3535: BEGIN
3536: hr_utility.trace('Entering: '||l_proc);
3537: hr_utility.trace('Entered get_element_entries_for_eg: EG_Id:'||to_char(p_event_group_id));
3538: hr_utility.trace('Assignment Id:'||to_char(p_assignment_id));
3539: hr_utility.trace('Start Date:'||to_char(p_start_date, 'DD/MM/YYYY'));
3540: hr_utility.trace('End Date:'||to_char(p_end_date, 'DD/MM/YYYY'));
3541:
3542: p_element_entries_tab.element_entry_id.DELETE;
3543: p_element_entries_tab.datetracked_event_id.DELETE;

Line 3540: hr_utility.trace('End Date:'||to_char(p_end_date, 'DD/MM/YYYY'));

3536: hr_utility.trace('Entering: '||l_proc);
3537: hr_utility.trace('Entered get_element_entries_for_eg: EG_Id:'||to_char(p_event_group_id));
3538: hr_utility.trace('Assignment Id:'||to_char(p_assignment_id));
3539: hr_utility.trace('Start Date:'||to_char(p_start_date, 'DD/MM/YYYY'));
3540: hr_utility.trace('End Date:'||to_char(p_end_date, 'DD/MM/YYYY'));
3541:
3542: p_element_entries_tab.element_entry_id.DELETE;
3543: p_element_entries_tab.datetracked_event_id.DELETE;
3544:

Line 3553: hr_utility.trace('Count:'||to_char(l_element_set_ids_tab.COUNT));

3549:
3550: OPEN csr_get_element_set (p_event_group_id => p_event_group_id);
3551: FETCH csr_get_element_set BULK COLLECT INTO l_element_set_ids_tab;
3552: CLOSE csr_get_element_set;
3553: hr_utility.trace('Count:'||to_char(l_element_set_ids_tab.COUNT));
3554: FOR i IN 1..l_element_set_ids_tab.COUNT LOOP
3555: OPEN csr_element_entries
3556: (p_element_set_id => l_element_set_ids_tab(i)
3557: ,p_event_group_id => p_event_group_id

Line 3564: hr_utility.trace('Count:'||to_char(l_element_entries_tab.element_entry_id.COUNT));

3560: ,p_end_date => p_end_date
3561: );
3562: FETCH csr_element_entries BULK COLLECT INTO l_element_entries_tab;
3563: CLOSE csr_element_entries;
3564: hr_utility.trace('Count:'||to_char(l_element_entries_tab.element_entry_id.COUNT));
3565:
3566:
3567: IF csr_get_purge_events_on_eg%FOUND THEN
3568: -- if there are purge events in the event group

Line 3569: hr_utility.trace('There are puge events on element entries table in the eg.');

3565:
3566:
3567: IF csr_get_purge_events_on_eg%FOUND THEN
3568: -- if there are purge events in the event group
3569: hr_utility.trace('There are puge events on element entries table in the eg.');
3570: OPEN csr_get_purged_ee_ids(l_element_set_ids_tab(i));
3571: FETCH csr_get_purged_ee_ids BULK COLLECT INTO l_purge_ee_ids;
3572: CLOSE csr_get_purged_ee_ids;
3573:

Line 3574: hr_utility.trace('Fill the values in the element entries collection.');

3570: OPEN csr_get_purged_ee_ids(l_element_set_ids_tab(i));
3571: FETCH csr_get_purged_ee_ids BULK COLLECT INTO l_purge_ee_ids;
3572: CLOSE csr_get_purged_ee_ids;
3573:
3574: hr_utility.trace('Fill the values in the element entries collection.');
3575: FOR i IN 1..l_purge_ee_ids.COUNT
3576: LOOP
3577: hr_utility.trace('l_purge_ee_ids(i): '||l_purge_ee_ids(i));
3578: -- bug fix 5368066. nvl is added for this bug fix.

Line 3577: hr_utility.trace('l_purge_ee_ids(i): '||l_purge_ee_ids(i));

3573:
3574: hr_utility.trace('Fill the values in the element entries collection.');
3575: FOR i IN 1..l_purge_ee_ids.COUNT
3576: LOOP
3577: hr_utility.trace('l_purge_ee_ids(i): '||l_purge_ee_ids(i));
3578: -- bug fix 5368066. nvl is added for this bug fix.
3579: l_next := nvl(l_element_entries_tab.element_entry_id.LAST,0) + 1;
3580: l_element_entries_tab.element_entry_id(l_next) := fnd_number.canonical_to_number(l_purge_ee_ids(i));
3581: l_element_entries_tab.datetracked_event_id(l_next) := l_purge_dte_id;

Line 3612: hr_utility.trace('Count:'||to_char(p_element_entries_tab.element_entry_id.COUNT));

3608: END LOOP; -- i loop
3609:
3610: END LOOP; -- element set loop ...
3611: CLOSE csr_get_purge_events_on_eg;
3612: hr_utility.trace('Count:'||to_char(p_element_entries_tab.element_entry_id.COUNT));
3613:
3614: hr_utility.trace('Leaving: '||l_proc);
3615: RETURN p_element_entries_tab.element_entry_id.COUNT;
3616:

Line 3614: hr_utility.trace('Leaving: '||l_proc);

3610: END LOOP; -- element set loop ...
3611: CLOSE csr_get_purge_events_on_eg;
3612: hr_utility.trace('Count:'||to_char(p_element_entries_tab.element_entry_id.COUNT));
3613:
3614: hr_utility.trace('Leaving: '||l_proc);
3615: RETURN p_element_entries_tab.element_entry_id.COUNT;
3616:
3617: EXCEPTION
3618: WHEN OTHERS THEN

Line 3626: hr_utility.trace('Entering: '||l_proc);

3622: RAISE;
3623: END get_element_entries_for_eg;
3624: ---------
3625: BEGIN --entries_effected
3626: hr_utility.trace('Entering: '||l_proc);
3627: hr_utility.trace('Get the element entries for the assignment id');
3628:
3629: -- Bugfix 4739067: Performance enhancement
3630: -- Checking if the event group has element entries or

Line 3627: hr_utility.trace('Get the element entries for the assignment id');

3623: END get_element_entries_for_eg;
3624: ---------
3625: BEGIN --entries_effected
3626: hr_utility.trace('Entering: '||l_proc);
3627: hr_utility.trace('Get the element entries for the assignment id');
3628:
3629: -- Bugfix 4739067: Performance enhancement
3630: -- Checking if the event group has element entries or
3631: -- element entry values table before trying to fetch events

Line 3655: hr_utility.trace('Our procedure');

3651: -- entry_affected and entries_affected - kkarri
3652: pay_interpreter_pkg.t_distinct_tab := pay_interpreter_pkg.glo_monitored_events;
3653: -----
3654: IF l_count > 0 THEN
3655: hr_utility.trace('Our procedure');
3656: hr_utility.trace('Setup the global area');
3657: pay_interpreter_pkg.initialise_global(l_global_env);
3658: pay_interpreter_pkg.event_group_tables
3659: (p_event_group_id => p_event_group_id

Line 3656: hr_utility.trace('Setup the global area');

3652: pay_interpreter_pkg.t_distinct_tab := pay_interpreter_pkg.glo_monitored_events;
3653: -----
3654: IF l_count > 0 THEN
3655: hr_utility.trace('Our procedure');
3656: hr_utility.trace('Setup the global area');
3657: pay_interpreter_pkg.initialise_global(l_global_env);
3658: pay_interpreter_pkg.event_group_tables
3659: (p_event_group_id => p_event_group_id
3660: ,p_distinct_tab => pay_interpreter_pkg.glo_monitored_events

Line 3676: hr_utility.trace('----------------------------------');

3672: l_global_env.validate_run_actions := FALSE;
3673:
3674: FOR i IN l_datetrack_ee_tab.element_entry_id.FIRST..l_datetrack_ee_tab.element_entry_id.LAST
3675: LOOP
3676: hr_utility.trace('----------------------------------');
3677: hr_utility.trace('i: '||i);
3678: hr_utility.trace('datetracked_event_id: '||l_datetrack_ee_tab.datetracked_event_id(i));
3679: hr_utility.trace('element_entry_id: '||l_datetrack_ee_tab.element_entry_id(i));
3680: pay_interpreter_pkg.add_datetrack_event_to_entry

Line 3677: hr_utility.trace('i: '||i);

3673:
3674: FOR i IN l_datetrack_ee_tab.element_entry_id.FIRST..l_datetrack_ee_tab.element_entry_id.LAST
3675: LOOP
3676: hr_utility.trace('----------------------------------');
3677: hr_utility.trace('i: '||i);
3678: hr_utility.trace('datetracked_event_id: '||l_datetrack_ee_tab.datetracked_event_id(i));
3679: hr_utility.trace('element_entry_id: '||l_datetrack_ee_tab.element_entry_id(i));
3680: pay_interpreter_pkg.add_datetrack_event_to_entry
3681: (p_datetracked_evt_id => l_datetrack_ee_tab.datetracked_event_id(i)

Line 3678: hr_utility.trace('datetracked_event_id: '||l_datetrack_ee_tab.datetracked_event_id(i));

3674: FOR i IN l_datetrack_ee_tab.element_entry_id.FIRST..l_datetrack_ee_tab.element_entry_id.LAST
3675: LOOP
3676: hr_utility.trace('----------------------------------');
3677: hr_utility.trace('i: '||i);
3678: hr_utility.trace('datetracked_event_id: '||l_datetrack_ee_tab.datetracked_event_id(i));
3679: hr_utility.trace('element_entry_id: '||l_datetrack_ee_tab.element_entry_id(i));
3680: pay_interpreter_pkg.add_datetrack_event_to_entry
3681: (p_datetracked_evt_id => l_datetrack_ee_tab.datetracked_event_id(i)
3682: ,p_element_entry_id => l_datetrack_ee_tab.element_entry_id(i)

Line 3679: hr_utility.trace('element_entry_id: '||l_datetrack_ee_tab.element_entry_id(i));

3675: LOOP
3676: hr_utility.trace('----------------------------------');
3677: hr_utility.trace('i: '||i);
3678: hr_utility.trace('datetracked_event_id: '||l_datetrack_ee_tab.datetracked_event_id(i));
3679: hr_utility.trace('element_entry_id: '||l_datetrack_ee_tab.element_entry_id(i));
3680: pay_interpreter_pkg.add_datetrack_event_to_entry
3681: (p_datetracked_evt_id => l_datetrack_ee_tab.datetracked_event_id(i)
3682: ,p_element_entry_id => l_datetrack_ee_tab.element_entry_id(i)
3683: ,p_global_env => l_global_env

Line 3686: hr_utility.trace('Entered all the dte_id X ee_ids');

3682: ,p_element_entry_id => l_datetrack_ee_tab.element_entry_id(i)
3683: ,p_global_env => l_global_env
3684: );
3685: END LOOP;
3686: hr_utility.trace('Entered all the dte_id X ee_ids');
3687:
3688: BEGIN
3689: --call entries_effected
3690: pay_interpreter_pkg.entries_affected

Line 3702: hr_utility.trace('No payroll run for the assignment');

3698: ,p_process_mode => p_process_mode
3699: );
3700: EXCEPTION
3701: WHEN NO_DATA_FOUND THEN
3702: hr_utility.trace('No payroll run for the assignment');
3703: hr_utility.set_message(8303,'BEN_94629_NO_ASG_ACTION_ID');
3704: hr_utility.raise_error;
3705: END;
3706: -- reset l_global_env

Line 3703: hr_utility.set_message(8303,'BEN_94629_NO_ASG_ACTION_ID');

3699: );
3700: EXCEPTION
3701: WHEN NO_DATA_FOUND THEN
3702: hr_utility.trace('No payroll run for the assignment');
3703: hr_utility.set_message(8303,'BEN_94629_NO_ASG_ACTION_ID');
3704: hr_utility.raise_error;
3705: END;
3706: -- reset l_global_env
3707: pay_interpreter_pkg.clear_dt_event_for_entry

Line 3704: hr_utility.raise_error;

3700: EXCEPTION
3701: WHEN NO_DATA_FOUND THEN
3702: hr_utility.trace('No payroll run for the assignment');
3703: hr_utility.set_message(8303,'BEN_94629_NO_ASG_ACTION_ID');
3704: hr_utility.raise_error;
3705: END;
3706: -- reset l_global_env
3707: pay_interpreter_pkg.clear_dt_event_for_entry
3708: (p_global_env => l_global_env);

Line 3710: hr_utility.trace('Normal call to entries_effected');

3706: -- reset l_global_env
3707: pay_interpreter_pkg.clear_dt_event_for_entry
3708: (p_global_env => l_global_env);
3709: ELSE
3710: hr_utility.trace('Normal call to entries_effected');
3711: --call entry_affected
3712: pay_interpreter_pkg.entry_affected(
3713: p_element_entry_id => NULL
3714: ,p_assignment_action_id => NULL

Line 3728: hr_utility.trace('Leaving: '||l_proc);

3724: ,t_proration_change_type => l_proration_changes -- OUT
3725: ,t_proration_type => l_pro_type_tab -- OUT
3726: );
3727: END IF;
3728: hr_utility.trace('Leaving: '||l_proc);
3729: END entries_affected;
3730: --
3731: END pqp_utilities;