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.12000000.1 2007/04/24 06:44:17 rsahai noship $ */
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 1294: hr_utility.set_location (' Entering Procedure ARCHIVE_CODE', 380);

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

Line 3253: hr_utility.set_location

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

Line 3263: hr_utility.set_location

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

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

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

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

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

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

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

Line 3329: hr_utility.set_location ( 'ORA_ERR: '

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

Line 3356: hr_utility.set_location

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

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

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

Line 3402: hr_utility.set_location

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

Line 3428: hr_utility.set_location

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

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

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

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

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

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

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

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

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

Line 3575: hr_utility.raise_error;

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

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

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

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

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