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

Line 95: -- hr_utility.trace_on(null,'bpk1');

91: l_nationality hr_lookups.meaning%type;
92: l_nationality_person per_all_people_f.nationality%type;
93: begin
94:
95: -- hr_utility.trace_on(null,'bpk1');
96: -- hr_utility.set_location('Entering: ' , 10);
97:
98: Select person_id
99: Into l_person_id

Line 96: -- hr_utility.set_location('Entering: ' , 10);

92: l_nationality_person per_all_people_f.nationality%type;
93: begin
94:
95: -- hr_utility.trace_on(null,'bpk1');
96: -- hr_utility.set_location('Entering: ' , 10);
97:
98: Select person_id
99: Into l_person_id
100: From PER_ALL_ASSIGNMENTS_F

Line 103: hr_utility.set_location('l_person_id: '||l_person_id , 10);

99: Into l_person_id
100: From PER_ALL_ASSIGNMENTS_F
101: Where ASSIGNMENT_ID = p_assignment_id
102: AND p_date_earned between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
103: hr_utility.set_location('l_person_id: '||l_person_id , 10);
104:
105: Select PER_INFORMATION18
106: Into l_nationality_person
107: From PER_ALL_PEOPLE_F

Line 111: hr_utility.set_location('l_nationality_person: '||l_nationality_person , 10);

107: From PER_ALL_PEOPLE_F
108: Where PERSON_ID = l_person_id
109: AND p_date_earned between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
110:
111: hr_utility.set_location('l_nationality_person: '||l_nationality_person , 10);
112:
113: l_nationality := hr_general.decode_lookup('AE_NATIONALITY',l_nationality_person);
114: hr_utility.set_location('l_nationality: '||l_nationality , 10);
115:

Line 114: hr_utility.set_location('l_nationality: '||l_nationality , 10);

110:
111: hr_utility.set_location('l_nationality_person: '||l_nationality_person , 10);
112:
113: l_nationality := hr_general.decode_lookup('AE_NATIONALITY',l_nationality_person);
114: hr_utility.set_location('l_nationality: '||l_nationality , 10);
115:
116: RETURN l_nationality;
117: END get_person_nationality;
118: -----------------------------------------------------------------------

Line 166: hr_utility.set_location('Entered '||l_proc,5);

162: begin
163: g_package := 'pay_ae_general';
164: l_proc := g_package||'.get_message';
165: --
166: hr_utility.set_location('Entered '||l_proc,5);
167: hr_utility.set_location('. Message Name: '||p_message_name,40);
168: fnd_message.set_name(p_product, p_message_name);
169: if p_token1 is not null then
170: -- Obtain token 1 name and value

Line 167: hr_utility.set_location('. Message Name: '||p_message_name,40);

163: g_package := 'pay_ae_general';
164: l_proc := g_package||'.get_message';
165: --
166: hr_utility.set_location('Entered '||l_proc,5);
167: hr_utility.set_location('. Message Name: '||p_message_name,40);
168: fnd_message.set_name(p_product, p_message_name);
169: if p_token1 is not null then
170: -- Obtain token 1 name and value
171: l_colon_position := instr(p_token1,':');

Line 175: hr_utility.set_location('. Token1: '||l_token_name||'. Value: '||l_token_value,50);

171: l_colon_position := instr(p_token1,':');
172: l_token_name := substr(p_token1,1,l_colon_position-1);
173: l_token_value := substr(p_token1,l_colon_position+1,length(p_token1));
174: fnd_message.set_token(l_token_name, l_token_value);
175: hr_utility.set_location('. Token1: '||l_token_name||'. Value: '||l_token_value,50);
176: end if;
177: if p_token2 is not null then
178: -- Obtain token 2 name and value
179: l_colon_position := instr(p_token2,':');

Line 183: hr_utility.set_location('. Token2: '||l_token_name||'. Value: '||l_token_value,60);

179: l_colon_position := instr(p_token2,':');
180: l_token_name := substr(p_token2,1,l_colon_position-1);
181: l_token_value := substr(p_token2,l_colon_position+1,length(p_token2));
182: fnd_message.set_token(l_token_name, l_token_value);
183: hr_utility.set_location('. Token2: '||l_token_name||'. Value: '||l_token_value,60);
184: end if;
185: if p_token3 is not null then
186: -- Obtain token 3 name and value
187: l_colon_position := instr(p_token3,':');

Line 191: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);

187: l_colon_position := instr(p_token3,':');
188: l_token_name := substr(p_token3,1,l_colon_position-1);
189: l_token_value := substr(p_token3,l_colon_position+1,length(p_token3));
190: fnd_message.set_token(l_token_name, l_token_value);
191: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);
192: end if;
193: l_message := substr(fnd_message.get,1,254);
194: hr_utility.set_location('leaving '||l_proc,100);
195: return l_message;

Line 194: hr_utility.set_location('leaving '||l_proc,100);

190: fnd_message.set_token(l_token_name, l_token_value);
191: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);
192: end if;
193: l_message := substr(fnd_message.get,1,254);
194: hr_utility.set_location('leaving '||l_proc,100);
195: return l_message;
196: end get_message;
197: ------------------------------------------------------------------------
198: -- Function GET_TABLE_BANDS

Line 237: hr_utility.set_location('Entered '||l_proc,5);

233: begin
234: g_package := 'pay_ae_general';
235: l_proc := g_package||'.get_table_bands';
236: --
237: hr_utility.set_location('Entered '||l_proc,5);
238: -- Get the User Table ID
239: OPEN csr_get_user_table_id(p_table_name);
240: FETCH csr_get_user_table_id INTO l_table_id;
241: CLOSE csr_get_user_table_id;

Line 633: hr_utility.set_location('--In Formula ',20);

629: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
630: l_inputs ff_exec.inputs_t;
631: l_outputs ff_exec.outputs_t;
632: BEGIN
633: hr_utility.set_location('--In Formula ',20);
634: --
635: -- Initialize the formula
636: --
637: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);

Line 639: hr_utility.trace('after ff_exec');

635: -- Initialize the formula
636: --
637: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
638: --
639: hr_utility.trace('after ff_exec');
640: -- Set up the input values
641: --
642: IF l_inputs.count > 0 and p_inputs.count > 0 THEN
643: FOR i IN l_inputs.first..l_inputs.last LOOP

Line 655: hr_utility.trace('about to exec');

651: END IF;
652: --
653: -- Run the formula
654: --
655: hr_utility.trace('about to exec');
656: ff_exec.run_formula(l_inputs,l_outputs);
657: --
658: -- Populate the output table
659: --

Line 988: hr_utility.set_location('Entered pay_ae_general',10);

984: l_c_wage_2 NUMBER;
985: l_old_date_earned DATE;
986:
987: BEGIN
988: hr_utility.set_location('Entered pay_ae_general',10);
989: l_diff_exist := 0;
990: l_ref_earnings_id := NULL;
991: OPEN csr_get_def_bal_id( 'CONTRIBUTORY_SALARY_ASG_YTD');
992: FETCH csr_get_def_bal_id INTO l_ref_earnings_id;

Line 993: hr_utility.set_location('l_ref_earnings_id'|| l_ref_earnings_id,10);

989: l_diff_exist := 0;
990: l_ref_earnings_id := NULL;
991: OPEN csr_get_def_bal_id( 'CONTRIBUTORY_SALARY_ASG_YTD');
992: FETCH csr_get_def_bal_id INTO l_ref_earnings_id;
993: hr_utility.set_location('l_ref_earnings_id'|| l_ref_earnings_id,10);
994: CLOSE csr_get_def_bal_id;
995:
996: l_subject_gosi_id := NULL;
997: OPEN csr_get_def_bal_id( 'SUBJECT_TO_SOCIAL_INSURANCE_ASG_RUN');

Line 999: hr_utility.set_location('l_subject_gosi_id'|| l_subject_gosi_id,10);

995:
996: l_subject_gosi_id := NULL;
997: OPEN csr_get_def_bal_id( 'SUBJECT_TO_SOCIAL_INSURANCE_ASG_RUN');
998: FETCH csr_get_def_bal_id INTO l_subject_gosi_id;
999: hr_utility.set_location('l_subject_gosi_id'|| l_subject_gosi_id,10);
1000: CLOSE csr_get_def_bal_id;
1001:
1002: l_old_assact_id := NULL;
1003:

Line 1009: hr_utility.set_location('rec_get_assact_id.assignment_action_id'||rec_get_assact_id.assignment_action_id,10);

1005: OPEN csr_get_assact_id;
1006: LOOP
1007: FETCH csr_get_assact_id INTO rec_get_assact_id;
1008: EXIT WHEN csr_get_assact_id%NOTFOUND;
1009: hr_utility.set_location('rec_get_assact_id.assignment_action_id'||rec_get_assact_id.assignment_action_id,10);
1010: IF l_old_assact_id IS NULL THEN
1011: IF TRUNC(rec_get_assact_id.date_earned,'YYYY') < TRUNC(p_date_earned, 'YYYY') THEN
1012: hr_utility.set_location('rec_get_assact_id.assignment_action_id'||rec_get_assact_id.assignment_action_id,20);
1013: l_old_assact_id := rec_get_assact_id.assignment_action_id;

Line 1012: hr_utility.set_location('rec_get_assact_id.assignment_action_id'||rec_get_assact_id.assignment_action_id,20);

1008: EXIT WHEN csr_get_assact_id%NOTFOUND;
1009: hr_utility.set_location('rec_get_assact_id.assignment_action_id'||rec_get_assact_id.assignment_action_id,10);
1010: IF l_old_assact_id IS NULL THEN
1011: IF TRUNC(rec_get_assact_id.date_earned,'YYYY') < TRUNC(p_date_earned, 'YYYY') THEN
1012: hr_utility.set_location('rec_get_assact_id.assignment_action_id'||rec_get_assact_id.assignment_action_id,20);
1013: l_old_assact_id := rec_get_assact_id.assignment_action_id;
1014: l_old_date_earned := rec_get_assact_id.date_earned;
1015: l_old_wage := pay_balance_pkg.get_value(l_ref_earnings_id,l_old_assact_id);
1016: hr_utility.set_location('l_old_assact_id'|| l_old_assact_id,10);

Line 1016: hr_utility.set_location('l_old_assact_id'|| l_old_assact_id,10);

1012: hr_utility.set_location('rec_get_assact_id.assignment_action_id'||rec_get_assact_id.assignment_action_id,20);
1013: l_old_assact_id := rec_get_assact_id.assignment_action_id;
1014: l_old_date_earned := rec_get_assact_id.date_earned;
1015: l_old_wage := pay_balance_pkg.get_value(l_ref_earnings_id,l_old_assact_id);
1016: hr_utility.set_location('l_old_assact_id'|| l_old_assact_id,10);
1017: hr_utility.set_location('l_old_date_earned'|| l_old_date_earned,10);
1018: hr_utility.set_location('l_old_wage'|| l_old_wage,10);
1019: ELSE
1020: /*Exit if the earlier run is in the same year. This indicates there is no need to calculate contributory wage*/

Line 1017: hr_utility.set_location('l_old_date_earned'|| l_old_date_earned,10);

1013: l_old_assact_id := rec_get_assact_id.assignment_action_id;
1014: l_old_date_earned := rec_get_assact_id.date_earned;
1015: l_old_wage := pay_balance_pkg.get_value(l_ref_earnings_id,l_old_assact_id);
1016: hr_utility.set_location('l_old_assact_id'|| l_old_assact_id,10);
1017: hr_utility.set_location('l_old_date_earned'|| l_old_date_earned,10);
1018: hr_utility.set_location('l_old_wage'|| l_old_wage,10);
1019: ELSE
1020: /*Exit if the earlier run is in the same year. This indicates there is no need to calculate contributory wage*/
1021: EXIT;

Line 1018: hr_utility.set_location('l_old_wage'|| l_old_wage,10);

1014: l_old_date_earned := rec_get_assact_id.date_earned;
1015: l_old_wage := pay_balance_pkg.get_value(l_ref_earnings_id,l_old_assact_id);
1016: hr_utility.set_location('l_old_assact_id'|| l_old_assact_id,10);
1017: hr_utility.set_location('l_old_date_earned'|| l_old_date_earned,10);
1018: hr_utility.set_location('l_old_wage'|| l_old_wage,10);
1019: ELSE
1020: /*Exit if the earlier run is in the same year. This indicates there is no need to calculate contributory wage*/
1021: EXIT;
1022: END IF;

Line 1029: hr_utility.set_location('l_old_wage'|| l_old_wage,10);

1025: /*Check if there is any salary change in the previous year*/
1026: IF TRUNC(l_old_date_earned ,'YYYY') = TRUNC(rec_get_assact_id.date_earned,'YYYY') THEN
1027: /*Bug No6976224*/
1028: /*IF l_prev_salary <> p_subject_to_gosi THEN*/
1029: hr_utility.set_location('l_old_wage'|| l_old_wage,10);
1030: hr_utility.set_location('p_subject_to_gosi'|| p_subject_to_gosi,10);
1031: IF l_old_wage <> p_subject_to_gosi THEN
1032: l_diff_exist := 1;
1033: EXIT;

Line 1030: hr_utility.set_location('p_subject_to_gosi'|| p_subject_to_gosi,10);

1026: IF TRUNC(l_old_date_earned ,'YYYY') = TRUNC(rec_get_assact_id.date_earned,'YYYY') THEN
1027: /*Bug No6976224*/
1028: /*IF l_prev_salary <> p_subject_to_gosi THEN*/
1029: hr_utility.set_location('l_old_wage'|| l_old_wage,10);
1030: hr_utility.set_location('p_subject_to_gosi'|| p_subject_to_gosi,10);
1031: IF l_old_wage <> p_subject_to_gosi THEN
1032: l_diff_exist := 1;
1033: EXIT;
1034: END IF;

Line 1042: hr_utility.set_location('p_subject_to_gosi'|| p_subject_to_gosi,10);

1038: CLOSE csr_get_assact_id;
1039:
1040: IF (l_diff_exist = 1) AND (l_old_assact_id IS NOT NULL) THEN
1041: /*Calculate contributory wage if there is any change*/
1042: hr_utility.set_location('p_subject_to_gosi'|| p_subject_to_gosi,10);
1043: hr_utility.set_location('l_prev_salary'|| l_prev_salary,10);
1044: l_diff_salary := p_subject_to_gosi - l_prev_salary;
1045: hr_utility.set_location('l_diff_salary'|| l_diff_salary,10);
1046: /*Bug No 6976224*/

Line 1043: hr_utility.set_location('l_prev_salary'|| l_prev_salary,10);

1039:
1040: IF (l_diff_exist = 1) AND (l_old_assact_id IS NOT NULL) THEN
1041: /*Calculate contributory wage if there is any change*/
1042: hr_utility.set_location('p_subject_to_gosi'|| p_subject_to_gosi,10);
1043: hr_utility.set_location('l_prev_salary'|| l_prev_salary,10);
1044: l_diff_salary := p_subject_to_gosi - l_prev_salary;
1045: hr_utility.set_location('l_diff_salary'|| l_diff_salary,10);
1046: /*Bug No 6976224*/
1047: /*l_c_wage_1 := ((p_pct_value/100) * (l_diff_salary)) + l_old_wage;*/

Line 1045: hr_utility.set_location('l_diff_salary'|| l_diff_salary,10);

1041: /*Calculate contributory wage if there is any change*/
1042: hr_utility.set_location('p_subject_to_gosi'|| p_subject_to_gosi,10);
1043: hr_utility.set_location('l_prev_salary'|| l_prev_salary,10);
1044: l_diff_salary := p_subject_to_gosi - l_prev_salary;
1045: hr_utility.set_location('l_diff_salary'|| l_diff_salary,10);
1046: /*Bug No 6976224*/
1047: /*l_c_wage_1 := ((p_pct_value/100) * (l_diff_salary)) + l_old_wage;*/
1048: l_c_wage_1 := ((p_pct_value/100) * (l_old_wage)) + l_old_wage;
1049: l_c_wage_2 := p_subject_to_gosi;

Line 1050: hr_utility.set_location('l_c_wage_1'|| l_c_wage_1,10);

1046: /*Bug No 6976224*/
1047: /*l_c_wage_1 := ((p_pct_value/100) * (l_diff_salary)) + l_old_wage;*/
1048: l_c_wage_1 := ((p_pct_value/100) * (l_old_wage)) + l_old_wage;
1049: l_c_wage_2 := p_subject_to_gosi;
1050: hr_utility.set_location('l_c_wage_1'|| l_c_wage_1,10);
1051: hr_utility.set_location('l_c_wage_2'|| l_c_wage_2,10);
1052:
1053: RETURN (LEAST(l_c_wage_1, l_c_wage_2));
1054: END IF;

Line 1051: hr_utility.set_location('l_c_wage_2'|| l_c_wage_2,10);

1047: /*l_c_wage_1 := ((p_pct_value/100) * (l_diff_salary)) + l_old_wage;*/
1048: l_c_wage_1 := ((p_pct_value/100) * (l_old_wage)) + l_old_wage;
1049: l_c_wage_2 := p_subject_to_gosi;
1050: hr_utility.set_location('l_c_wage_1'|| l_c_wage_1,10);
1051: hr_utility.set_location('l_c_wage_2'|| l_c_wage_2,10);
1052:
1053: RETURN (LEAST(l_c_wage_1, l_c_wage_2));
1054: END IF;
1055: