DBA Data[Home] [Help]

APPS.PAY_SE_WAGES_SALARIES dependencies on HR_UTILITY

Line 3: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_SE_WAGES_SALARIES AS
2: /* $Header: pysewssa.pkb 120.0.12010000.2 2008/11/03 08:56:37 abraghun ship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4:
5: TYPE lock_rec IS RECORD (
6: archive_assact_id NUMBER
7: );

Line 62: hr_utility.set_location (' Entering Function GET_PARAMETER', 10);

58: BEGIN
59: --
60: IF g_debug
61: THEN
62: hr_utility.set_location (' Entering Function GET_PARAMETER', 10);
63: END IF;
64:
65: l_start_pos :=
66: INSTR (' ' || p_parameter_string, l_delimiter || p_token || '=');

Line 105: hr_utility.set_location (' Leaving Function GET_PARAMETER', 20);

101:
102: --
103: IF g_debug
104: THEN
105: hr_utility.set_location (' Leaving Function GET_PARAMETER', 20);
106: END IF;
107:
108: RETURN l_parameter;
109: END;

Line 197: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS'

193:
194:
195: IF g_debug
196: THEN
197: hr_utility.set_location (' Leaving Procedure GET_ALL_PARAMETERS'
198: , 30);
199: END IF;
200: END get_all_parameters;
201:

Line 636: hr_utility.set_location (' Entering Procedure RANGE_CODE', 40);

632:
633:
634: IF g_debug
635: THEN
636: hr_utility.set_location (' Entering Procedure RANGE_CODE', 40);
637: END IF;
638:
639: p_sql :=
640: 'SELECT DISTINCT person_id

Line 721: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);

717: -- END IF;
718: --END IF;
719: IF g_debug
720: THEN
721: hr_utility.set_location (' Leaving Procedure RANGE_CODE', 50);
722: END IF;
723: EXCEPTION
724: WHEN OTHERS
725: THEN

Line 1295: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);

1291:
1292: BEGIN
1293: IF g_debug
1294: THEN
1295: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);
1296: END IF;
1297:
1298: /* TCDP --> Total of variable add.pay excl. of comp for on-call duties and payment in kind (SEK)
1299: TCOW --> Total variable, compensation for overtime worked (SEK)

Line 3254: hr_utility.set_location

3250:
3251: /* BEGIN
3252: IF g_debug
3253: THEN
3254: hr_utility.set_location
3255: (' Entering Procedure ASSIGNMENT_ACTION_CODE'
3256: , 60
3257: );
3258: END IF;

Line 3264: hr_utility.set_location

3260: fnd_file.put_line(fnd_file.LOG,'I am assignment here');
3261:
3262: IF g_debug
3263: THEN
3264: hr_utility.set_location
3265: (' Leaving Procedure ASSIGNMENT_ACTION_CODE'
3266: , 70
3267: );
3268: END IF;*/

Line 3274: hr_utility.set_location ('error raised assignment_action_code '

3270: WHEN OTHERS
3271: THEN
3272: IF g_debug
3273: THEN
3274: hr_utility.set_location ('error raised assignment_action_code '
3275: , 5
3276: );
3277: END IF;
3278:

Line 3300: hr_utility.set_location (' Entering Procedure INITIALIZATION_CODE'

3296: l_prev_prepay NUMBER := 0;
3297: BEGIN
3298: IF g_debug
3299: THEN
3300: hr_utility.set_location (' Entering Procedure INITIALIZATION_CODE'
3301: , 80
3302: );
3303: END IF;
3304:

Line 3319: hr_utility.set_location (' Leaving Procedure INITIALIZATION_CODE'

3315:
3316:
3317: IF g_debug
3318: THEN
3319: hr_utility.set_location (' Leaving Procedure INITIALIZATION_CODE'
3320: , 90
3321: );
3322: END IF;
3323: EXCEPTION

Line 3330: hr_utility.set_location ( 'ORA_ERR: '

3326: g_err_num := SQLCODE;
3327:
3328: IF g_debug
3329: THEN
3330: hr_utility.set_location ( 'ORA_ERR: '
3331: || g_err_num
3332: || 'In INITIALIZATION_CODE'
3333: , 180
3334: );

Line 3357: hr_utility.set_location

3353: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
3354: BEGIN
3355: IF g_debug
3356: THEN
3357: hr_utility.set_location
3358: (' Entering Function GET_DEFINED_BALANCE_ID'
3359: , 240
3360: );
3361: END IF;

Line 3374: hr_utility.set_location (' Leaving Function GET_DEFINED_BALANCE_ID'

3370: RETURN l_defined_balance_id;
3371:
3372: IF g_debug
3373: THEN
3374: hr_utility.set_location (' Leaving Function GET_DEFINED_BALANCE_ID'
3375: , 250
3376: );
3377: END IF;
3378: END get_defined_balance_id;

Line 3403: hr_utility.set_location

3399: l_return_balance_value NUMBER;
3400: BEGIN
3401: IF g_debug
3402: THEN
3403: hr_utility.set_location
3404: (' Entering Function GET_DEFINED_BALANCE_VALUE'
3405: , 240
3406: );
3407: END IF;

Line 3429: hr_utility.set_location

3425: RETURN l_return_balance_value;
3426:
3427: IF g_debug
3428: THEN
3429: hr_utility.set_location
3430: (' Leaving Function GET_DEFINED_BALANCE_VALUE'
3431: , 250
3432: );
3433: END IF;

Line 3446: hr_utility.set_location (' Leaving Procedure ARCHIVE_CODE', 390);

3442: begin
3443:
3444: IF g_debug
3445: THEN
3446: hr_utility.set_location (' Leaving Procedure ARCHIVE_CODE', 390);
3447: END IF;
3448: END archive_code;
3449:
3450: --- Report XML generating code

Line 3470: -- hr_utility.set_location ('Entering WritetoCLOB ', 70);

3466: l_iana_charset VARCHAR2 (50);
3467: BEGIN
3468: l_iana_charset := hr_se_utility.get_iana_charset;
3469:
3470: -- hr_utility.set_location ('Entering WritetoCLOB ', 70);
3471: l_str1 :=
3472: ' 3473: || l_iana_charset
3474: || '"?> ';

Line 3571: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);

3567: ELSE
3568: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
3569: END IF;
3570: p_xfdf_clob := l_xfdf_string;
3571: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
3572: EXCEPTION
3573: WHEN OTHERS
3574: THEN
3575: hr_utility.TRACE ('sqlerrm ' || SQLERRM);

Line 3575: hr_utility.TRACE ('sqlerrm ' || SQLERRM);

3571: -- hr_utility.set_location ('Leaving WritetoCLOB ', 40);
3572: EXCEPTION
3573: WHEN OTHERS
3574: THEN
3575: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
3576: hr_utility.raise_error;
3577: END writetoclob;
3578:
3579: -----------------------------------------------------------------------------------

Line 3576: hr_utility.raise_error;

3572: EXCEPTION
3573: WHEN OTHERS
3574: THEN
3575: hr_utility.TRACE ('sqlerrm ' || SQLERRM);
3576: hr_utility.raise_error;
3577: END writetoclob;
3578:
3579: -----------------------------------------------------------------------------------
3580: -- POPULATE_DATA_DETAIL generates xml for the reports.

Line 4122: hr_utility.set_location('Entered Procedure GETDATA',10);

4118: , g_retroactive_payment_to
4119: );
4120:
4121:
4122: hr_utility.set_location('Entered Procedure GETDATA',10);
4123:
4124: /* xml_tab(l_counter).TagName :='LU_DETAILS';
4125: xml_tab(l_counter).TagValue :='LU_DETAILS';*/
4126: /* l_counter:=l_counter+1;*/

Line 4129: hr_utility.set_location('Before populating pl/sql table',20);

4125: xml_tab(l_counter).TagValue :='LU_DETAILS';*/
4126: /* l_counter:=l_counter+1;*/
4127:
4128: /* Get the File Header Information */
4129: hr_utility.set_location('Before populating pl/sql table',20);
4130: l_lu_salary:=0;
4131: FOR csr_local IN csr_local_unit(p_payroll_action_id) LOOP
4132:
4133: l_local_unit_id:=csr_local.local_unit_id;