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_US_DEF_COMP_457 dependencies on HR_UTILITY

Line 65: hr_utility.set_location('Entering:'||l_proc, 5);

61: TYPE c_cursor_type1 IS REF CURSOR
62: RETURN l_rec_type;
63: Business_Rule_Proc_cur c_cursor_type1;
64: BEGIN
65: hr_utility.set_location('Entering:'||l_proc, 5);
66:
67: /* In the SQLs belwo the MAX(NVL(max_contr_allowed, 0)) = 0 OR
68: SUM(NVL(includable_comp, 0)) = 0) have been used, these are because it is a
69: kind of an exception. Includable comp should not be zero and as well

Line 91: hr_utility.set_location('Opened cursor Business_Rule_Proc_cur' , 10);

87: HAVING (MAX(NVL(max_contr_allowed, 0)) < SUM(NVL(amt_contr, 0)) OR
88: MAX(NVL(max_contr_allowed, 0)) = 0 OR
89: SUM(NVL(includable_comp, 0)) = 0) ;
90:
91: hr_utility.set_location('Opened cursor Business_Rule_Proc_cur' , 10);
92:
93: ELSIF (p_person_id IS NOT NULL AND p_gre_id IS NULL) THEN
94:
95: OPEN Business_Rule_Proc_cur FOR

Line 111: hr_utility.set_location('Opened cursor Business_Rule_Proc_cur' , 11);

107: HAVING (MAX(NVL(max_contr_allowed, 0)) < SUM(NVL(amt_contr, 0)) OR
108: MAX(NVL(max_contr_allowed, 0)) = 0 OR
109: SUM(NVL(includable_comp, 0)) = 0) ;
110:
111: hr_utility.set_location('Opened cursor Business_Rule_Proc_cur' , 11);
112:
113: ELSIF (p_person_id IS NOT NULL AND p_gre_id IS NOT NULL) THEN
114:
115: OPEN Business_Rule_Proc_cur FOR

Line 132: hr_utility.set_location('Opened cursor Business_Rule_Proc_cur' , 12);

128: HAVING (MAX(NVL(max_contr_allowed, 0)) < SUM(NVL(amt_contr, 0)) OR
129: MAX(NVL(max_contr_allowed, 0)) = 0 OR
130: SUM(NVL(includable_comp, 0)) = 0) ;
131:
132: hr_utility.set_location('Opened cursor Business_Rule_Proc_cur' , 12);
133:
134: END IF;
135:
136: LOOP

Line 174: hr_utility.set_location('Person Id = ' ||

170: ' Maximum contribution allowed for ' || ' for the Year = '
171: || TO_CHAR(p_year) || ' is ' || TO_CHAR(l_max_contr_allowed) ||
172: ' Includable Comp is ' || TO_CHAR(l_includable_comp) || ' in Business Group Id = ' || TO_CHAR(l_business_group_id));
173: ELSE
174: hr_utility.set_location('Person Id = ' ||
175: TO_CHAR(l_person_id) || ', Name = ' || l_full_name || ' has '
176: || 'contribution of ' || TO_CHAR(l_amt_contr) ||
177: ' Maximum contribution allowed for ' || ' for the Year = '
178: || TO_CHAR(p_year) || ' is ' || TO_CHAR(l_max_contr_allowed) ||

Line 187: hr_utility.set_location('Error occured ' || l_proc

183: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
184: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
185: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE));
186: ELSE
187: hr_utility.set_location('Error occured ' || l_proc
188: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE) , 15);
189: END IF;
190: END;
191: END LOOP;

Line 193: hr_utility.set_location('Leaving:'||l_proc, 999);

189: END IF;
190: END;
191: END LOOP;
192: CLOSE Business_Rule_Proc_cur;
193: hr_utility.set_location('Leaving:'||l_proc, 999);
194:
195: EXCEPTION
196: WHEN OTHERS THEN
197: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

Line 201: hr_utility.set_location('Error occured ' || l_proc

197: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
198: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
199: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE));
200: ELSE
201: hr_utility.set_location('Error occured ' || l_proc
202: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE) , 15);
203: END IF;
204: END Business_Rule_Proc;
205:

Line 255: hr_utility.set_location('Entering:'||l_proc, 5);

251: l_object_version_number OUT NOCOPY NUMBER
252: ) IS
253: l_proc VARCHAR2(72) := g_package || 'Pay_Contrb_Ins';
254: BEGIN
255: hr_utility.set_location('Entering:'||l_proc, 5);
256:
257: pay_contribution_history_api.create_contribution_history
258: (
259: p_validate => false ,

Line 277: hr_utility.set_location('Leaving:'||l_proc, 1000);

273: p_source_system => 'PAY' ,
274: p_object_version_number => l_object_version_number
275: );
276:
277: hr_utility.set_location('Leaving:'||l_proc, 1000);
278:
279: EXCEPTION
280: WHEN OTHERS THEN
281:

Line 292: hr_utility.set_location('Error occured while inserting in ' ||

288: TO_CHAR(l_person_id) || ' GRE = ' || TO_CHAR(l_tax_unit_id)
289: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE) ||
290: ' in ' || l_proc);
291: ELSE
292: hr_utility.set_location('Error occured while inserting in ' ||
293: ' PAY_US_CONTRIBUTION_HISTORY table for Person id = ' ||
294: TO_CHAR(l_person_id) || ' GRE = ' || TO_CHAR(l_tax_unit_id)
295: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE) ||
296: ' in ' || l_proc, 15);

Line 340: hr_utility.set_location('Entering:'||l_proc, 5);

336: l_proc VARCHAR2(72) := g_package || 'Pay_Contrb_Upd';
337: l_history_id NUMBER;
338: l_ovn NUMBER;
339: BEGIN
340: hr_utility.set_location('Entering:'||l_proc, 5);
341:
342: l_history_id := l_contr_history_id;
343: l_ovn := l_object_version_number;
344:

Line 355: hr_utility.set_location('Leaving:'||l_proc, 1000);

351: p_includable_comp => l_includable_comp ,
352: p_object_version_number => l_object_version_number
353: );
354:
355: hr_utility.set_location('Leaving:'||l_proc, 1000);
356:
357: EXCEPTION
358: WHEN OTHERS THEN
359:

Line 371: hr_utility.set_location('Error occured while Updating in ' ||

367: TO_CHAR(l_object_version_number)
368: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE) ||
369: ' in ' || l_proc);
370: ELSE
371: hr_utility.set_location('Error occured while Updating in ' ||
372: ' PAY_US_CONTRIBUTION_HISTORY table for Contr_history_id = ' ||
373: TO_CHAR(l_contr_history_id) || ' Object Version Number = ' ||
374: TO_CHAR(l_object_version_number)
375: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE) ||

Line 421: hr_utility.set_location('Entering:'||l_proc, 5);

417: l_balance NUMBER ;
418: l_proc VARCHAR2(72) := g_package || 'Get_bal';
419: BEGIN
420:
421: hr_utility.set_location('Entering:'||l_proc, 5);
422:
423: g_get_bal_flag := 'CORRECT';
424: pay_balance_pkg.set_context('tax_unit_id', p_tax_unit_id );
425: pay_balance_pkg.set_context('date_earned', p_effective_date);

Line 453: hr_utility.set_location('Balance = ' || p_balance_name || ' ' ||

449: AND pbd.balance_dimension_id = pdb.balance_dimension_id
450: AND pbd.dimension_name = p_dimension_name;
451: END IF;
452:
453: hr_utility.set_location('Balance = ' || p_balance_name || ' ' ||
454: TO_CHAR(l_defined_balance_id) || ' ' || TO_CHAR(p_assignment_id), 15);
455:
456: l_balance := NVL(pay_balance_pkg.get_value(l_defined_balance_id,
457: p_assignment_id ,

Line 459: hr_utility.set_location('Leaving:'||l_proc, 1000);

455:
456: l_balance := NVL(pay_balance_pkg.get_value(l_defined_balance_id,
457: p_assignment_id ,
458: p_effective_date ), 0);
459: hr_utility.set_location('Leaving:'||l_proc, 1000);
460:
461: RETURN l_balance;
462: EXCEPTION
463: WHEN NO_DATA_FOUND THEN

Line 469: hr_utility.set_location(p_balance_name ||

465: FND_FILE.PUT_LINE(FND_FILE.LOG,p_balance_name ||
466: ' not found for Assignment Id ' || TO_CHAR(p_assignment_id) ||
467: ' in ' || TO_CHAR(p_business_group_id) || ' ' || l_proc);
468: ELSE
469: hr_utility.set_location(p_balance_name ||
470: ' not found for Assignment Id ' || TO_CHAR(p_assignment_id) ||
471: ' in ' || l_proc, 10);
472: END IF;
473: g_get_bal_flag := 'ERROR';

Line 482: hr_utility.set_location('Error occured while calculating ' ||

478: p_balance_name || ' for Assignment Id ' || TO_CHAR(p_assignment_id)
479: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE) ||
480: ' in ' || l_proc);
481: ELSE
482: hr_utility.set_location('Error occured while calculating ' ||
483: p_balance_name || ' for Assignment Id ' || TO_CHAR(p_assignment_id)||
484: SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE) || ' in '
485: || l_proc, 15);
486: END IF;

Line 532: hr_utility.set_location('Entering:'||l_proc, 5);

528: p_business_group_id IN NUMBER ) IS
529: l_contr_history_id NUMBER := 0;
530: l_proc VARCHAR2(72) := g_package || 'person_exists';
531: BEGIN
532: hr_utility.set_location('Entering:'||l_proc, 5);
533:
534: SELECT contr_history_id ,
535: object_version_number
536: INTO p_contr_history_id,

Line 546: hr_utility.set_location('Leaving:'||l_proc, 1000);

542: AND tax_unit_id = p_tax_unit_id
543: AND person_id = p_person_id
544: AND business_group_id = p_business_group_id;
545:
546: hr_utility.set_location('Leaving:'||l_proc, 1000);
547:
548: EXCEPTION
549: WHEN NO_DATA_FOUND THEN
550: p_contr_history_id := 0;

Line 560: hr_utility.set_location('Error occured in WHEN OTHER for Person Id '||

556: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occured in WHEN OTHER for
557: Person Id ' || TO_CHAR(p_person_id) || ' for Year = ' || TO_CHAR(p_year) ||
558: ' in ' || l_proc || SUBSTR(SQLERRM, 1, 128) || TO_CHAR(SQLCODE));
559: ELSE
560: hr_utility.set_location('Error occured in WHEN OTHER for Person Id '||
561: TO_CHAR(p_person_id) || ' for Year = ' || TO_CHAR(p_year) || ' in ' || l_proc ||
562: SUBSTR(SQLERRM, 1, 128) || TO_CHAR(SQLCODE), 10);
563: END IF;
564: END person_exists;

Line 654: hr_utility.set_location(' Entering:'||l_proc, 5);

650: RETURN g_rec_type;
651: C_All_Emp c_cursor_type;
652:
653: BEGIN
654: hr_utility.set_location(' Entering:'||l_proc, 5);
655: l_get_bal_flag(1) := 'CORRECT';
656: l_get_bal_flag(2) := 'CORRECT';
657: l_get_bal_flag(3) := 'CORRECT';
658:

Line 677: hr_utility.set_location(' Deciding the cursor to be used', 10);

673: p_argument_value => p_gre_id
674: );
675: END IF;
676:
677: hr_utility.set_location(' Deciding the cursor to be used', 10);
678:
679: IF (p_person_id IS NULL) THEN
680:
681: OPEN C_All_Emp FOR

Line 749: hr_utility.set_location(' Opened the cursor', 15);

745: ORDER BY paa.person_id ,
746: paa.assignment_id ,
747: UPPER(pet.element_name) ;
748:
749: hr_utility.set_location(' Opened the cursor', 15);
750:
751: ELSIF (p_person_id IS NOT NULL AND p_gre_id IS NULL) THEN
752: OPEN C_All_Emp FOR
753: SELECT DISTINCT paa.person_id ,

Line 816: hr_utility.set_location(' Opened the cursor', 15);

812: paa.person_id ,
813: paa.assignment_id ,
814: UPPER(pet.element_name) ;
815:
816: hr_utility.set_location(' Opened the cursor', 15);
817:
818: ELSIF (p_person_id IS NOT NULL AND p_gre_id IS NOT NULL) THEN
819: OPEN C_ALL_Emp FOR
820: SELECT DISTINCT paa.person_id ,

Line 884: hr_utility.set_location(' Opened the cursor', 15);

880: paa.person_id ,
881: paa.assignment_id ,
882: UPPER(pet.element_name) ;
883:
884: hr_utility.set_location(' Opened the cursor', 15);
885:
886: END IF;
887:
888: l_override_mode := UPPER(p_override_mode);

Line 904: hr_utility.set_location('Parameters received ----> ' , 20);

900: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Year : ' || TO_CHAR(p_year));
901: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GRE : ' || TO_CHAR(p_gre_id ));
902: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Override Mode : ' || p_override_mode);
903: ELSE
904: hr_utility.set_location('Parameters received ----> ' , 20);
905: hr_utility.set_location('Person Id : ' || TO_CHAR(p_person_id), 25);
906: hr_utility.set_location('Year : ' || TO_CHAR(p_year), 30);
907: hr_utility.set_location('GRE : ' || TO_CHAR(p_gre_id ), 35);
908: hr_utility.set_location('Override Mode : ' || p_override_mode, 40);

Line 905: hr_utility.set_location('Person Id : ' || TO_CHAR(p_person_id), 25);

901: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GRE : ' || TO_CHAR(p_gre_id ));
902: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Override Mode : ' || p_override_mode);
903: ELSE
904: hr_utility.set_location('Parameters received ----> ' , 20);
905: hr_utility.set_location('Person Id : ' || TO_CHAR(p_person_id), 25);
906: hr_utility.set_location('Year : ' || TO_CHAR(p_year), 30);
907: hr_utility.set_location('GRE : ' || TO_CHAR(p_gre_id ), 35);
908: hr_utility.set_location('Override Mode : ' || p_override_mode, 40);
909: END IF;

Line 906: hr_utility.set_location('Year : ' || TO_CHAR(p_year), 30);

902: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Override Mode : ' || p_override_mode);
903: ELSE
904: hr_utility.set_location('Parameters received ----> ' , 20);
905: hr_utility.set_location('Person Id : ' || TO_CHAR(p_person_id), 25);
906: hr_utility.set_location('Year : ' || TO_CHAR(p_year), 30);
907: hr_utility.set_location('GRE : ' || TO_CHAR(p_gre_id ), 35);
908: hr_utility.set_location('Override Mode : ' || p_override_mode, 40);
909: END IF;
910:

Line 907: hr_utility.set_location('GRE : ' || TO_CHAR(p_gre_id ), 35);

903: ELSE
904: hr_utility.set_location('Parameters received ----> ' , 20);
905: hr_utility.set_location('Person Id : ' || TO_CHAR(p_person_id), 25);
906: hr_utility.set_location('Year : ' || TO_CHAR(p_year), 30);
907: hr_utility.set_location('GRE : ' || TO_CHAR(p_gre_id ), 35);
908: hr_utility.set_location('Override Mode : ' || p_override_mode, 40);
909: END IF;
910:
911:

Line 908: hr_utility.set_location('Override Mode : ' || p_override_mode, 40);

904: hr_utility.set_location('Parameters received ----> ' , 20);
905: hr_utility.set_location('Person Id : ' || TO_CHAR(p_person_id), 25);
906: hr_utility.set_location('Year : ' || TO_CHAR(p_year), 30);
907: hr_utility.set_location('GRE : ' || TO_CHAR(p_gre_id ), 35);
908: hr_utility.set_location('Override Mode : ' || p_override_mode, 40);
909: END IF;
910:
911:
912: hr_utility.set_location('Fetching from C_All_Emp cursor ', 45);

Line 912: hr_utility.set_location('Fetching from C_All_Emp cursor ', 45);

908: hr_utility.set_location('Override Mode : ' || p_override_mode, 40);
909: END IF;
910:
911:
912: hr_utility.set_location('Fetching from C_All_Emp cursor ', 45);
913:
914: LOOP
915: BEGIN
916: FETCH C_All_Emp INTO g_old_rec;

Line 937: hr_utility.set_location('Multiple Element IF', 50);

933: (UPPER(g_old_rec.element_information1) =
934: UPPER(l_element_information1) ) AND
935: C_All_Emp%FOUND = TRUE )
936: THEN
937: hr_utility.set_location('Multiple Element IF', 50);
938:
939: IF (l_multiple_rec_flag = FALSE) THEN
940: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
941: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Id = ' ||

Line 946: hr_utility.set_location('Person Id = ' ||

942: to_char(g_old_rec.person_id) || ', Name ' ||
943: g_old_rec.full_name ||
944: ' not selected as this person has multiple elements of same type');
945: ELSE
946: hr_utility.set_location('Person Id = ' ||
947: TO_CHAR(g_old_rec.person_id) || ', Name ' ||
948: g_old_rec.full_name ||
949: ' not selected as this person has multiple elements of same type', 55);
950: END IF;

Line 957: hr_utility.set_location('Multiple Element ELSE ', 60);

953: -- elements attached. The message above does not get printed more than once.
954: END IF;
955: ELSE
956:
957: hr_utility.set_location('Multiple Element ELSE ', 60);
958:
959: IF (l_multiple_rec_flag = FALSE AND l_first_time = FALSE) THEN
960:
961: l_balance_name := l_element_name || ' Eligible Comp';

Line 965: hr_utility.set_location('Calling Get_bal for ' ||

961: l_balance_name := l_element_name || ' Eligible Comp';
962: l_dimension :=
963: 'Person within Government Reporting Entity Year to Date';
964:
965: hr_utility.set_location('Calling Get_bal for ' ||
966: l_balance_name, 65);
967:
968: l_Includable_comp := NVL(Get_bal(
969: l_effective_date ,

Line 980: hr_utility.set_location('Calling Get_bal for ' ||

976: l_balance_name := 'Def Comp 457';
977: l_dimension :=
978: 'Person within Government Reporting Entity Year to Date';
979:
980: hr_utility.set_location('Calling Get_bal for ' ||
981: l_balance_name, 70);
982:
983: l_Def_457_Contribution_balance := NVL(Get_bal(
984: l_effective_date ,

Line 995: hr_utility.set_location('Calling Get_bal for ' ||

991: l_balance_name := 'Calc 457 Limit';
992: l_dimension :=
993: 'Person within Government Reporting Entity Year to Date';
994:
995: hr_utility.set_location('Calling Get_bal for ' ||
996: l_balance_name, 75);
997:
998: l_max_457_contrb_allowed := NVL(Get_bal( l_effective_date ,
999: l_assignment_id ,

Line 1006: hr_utility.set_location('Calling person_Exists '

1002: l_dimension ,
1003: l_business_group_id), 0);
1004: l_get_bal_flag(3) := g_get_bal_flag;
1005:
1006: hr_utility.set_location('Calling person_Exists '
1007: || TO_CHAR(l_person_id), 80);
1008:
1009: person_exists(l_person_id ,
1010: l_tax_unit_id ,

Line 1025: hr_utility.set_location('Inserting into PAY_US_CONTRIBUTION_HISTORY', 85);

1021: -- l_get_bal_flag stores if the calls to Get_Bal proc were successful or not
1022: -- l_contr_history_id = 0 ensures that this person_id is not having a record
1023: -- for the partucular year
1024:
1025: hr_utility.set_location('Inserting into PAY_US_CONTRIBUTION_HISTORY', 85);
1026: Pay_Contrb_Ins(
1027: l_business_group_id => l_business_group_id ,
1028: l_amt_contr => l_Def_457_Contribution_balance ,
1029: l_max_contr_allowed => l_max_457_contrb_allowed ,

Line 1045: hr_utility.set_location('Updating PAY_US_CONTRIBUTION_HISTORY', 90);

1041: l_get_bal_flag(1) = 'CORRECT' AND
1042: l_get_bal_flag(2) = 'CORRECT' AND
1043: l_get_bal_flag(3) = 'CORRECT') THEN
1044:
1045: hr_utility.set_location('Updating PAY_US_CONTRIBUTION_HISTORY', 90);
1046: Pay_contrb_Upd(
1047: l_contr_history_id => l_contr_history_id,
1048: l_object_version_number => l_ovn_number ,
1049: l_amt_contr => l_Def_457_Contribution_balance,

Line 1058: hr_utility.set_location('Assigning g_old_rec values to the local variables ' , 95);

1054: END IF;
1055: l_multiple_rec_flag := FALSE;
1056: END IF;
1057:
1058: hr_utility.set_location('Assigning g_old_rec values to the local variables ' , 95);
1059:
1060: l_person_id := g_old_rec.person_id ;
1061: l_assignment_id := g_old_rec.assignment_id ;
1062: l_element_name := g_old_rec.element_name ;

Line 1078: hr_utility.set_location('No record found for Year = ' ||

1074: FND_FILE.PUT_LINE(FND_FILE.LOG,'No record found for Year = '
1075: || TO_CHAR(p_year) ||' GRE = ' || TO_CHAR(p_gre_id) ||
1076: ' Business Group Id = ' || TO_CHAR(l_business_group_id));
1077: ELSE
1078: hr_utility.set_location('No record found for Year = ' ||
1079: TO_CHAR(p_year) ||' GRE = ' || TO_CHAR(p_gre_id) ||
1080: ' Business Group Id = ' || TO_CHAR(l_business_group_id), 80);
1081: END IF;
1082: END IF;

Line 1092: hr_utility.set_location('No record found for person Id = ' ||

1088: 'person Id = ' || TO_CHAR(p_person_id) || ' Year = ' ||
1089: TO_CHAR(p_year) || ' Tax Unit Id = ' || TO_CHAR(p_gre_id) ||
1090: ' Business Group Id = ' || TO_CHAR(l_business_group_id));
1091: ELSE
1092: hr_utility.set_location('No record found for person Id = ' ||
1093: TO_CHAR(p_person_id) || ' Year = ' || TO_CHAR(p_year) ||
1094: ' Tax Unit Id = ' || TO_CHAR(p_gre_id) || ' Business Group Id
1095: = ' || TO_CHAR(l_business_group_id), 85);
1096: END IF;

Line 1108: hr_utility.set_location(substr(SQLERRM, 1, 255) || ' in ' ||

1104: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(SQLERRM, 1, 255) || ' in ' ||
1105: l_proc || ' ' || TO_CHAR(SQLCODE) || ' in cursor for Person id = ' ||
1106: TO_CHAR(g_old_rec.person_id) || ' ' || g_old_rec.full_name);
1107: ELSE
1108: hr_utility.set_location(substr(SQLERRM, 1, 255) || ' in ' ||
1109: l_proc || ' ' || TO_CHAR(SQLCODE) || ' in cursor for Person id = ' ||
1110: TO_CHAR(g_old_rec.person_id) || ' ' || g_old_rec.full_name, 1000);
1111: END IF;
1112: END;

Line 1114: hr_utility.set_location('Closing the cursor ', 100);

1110: TO_CHAR(g_old_rec.person_id) || ' ' || g_old_rec.full_name, 1000);
1111: END IF;
1112: END;
1113: END LOOP;
1114: hr_utility.set_location('Closing the cursor ', 100);
1115: Close C_All_Emp;
1116: hr_utility.set_location('Calling Business_rule_proc ', 150);
1117:
1118: -- The proc takes care of the case when p_person_id is null. Then it finds

Line 1116: hr_utility.set_location('Calling Business_rule_proc ', 150);

1112: END;
1113: END LOOP;
1114: hr_utility.set_location('Closing the cursor ', 100);
1115: Close C_All_Emp;
1116: hr_utility.set_location('Calling Business_rule_proc ', 150);
1117:
1118: -- The proc takes care of the case when p_person_id is null. Then it finds
1119: -- out all the persons.
1120:

Line 1124: hr_utility.set_location(' Leaving:'||l_proc, 1500);

1120:
1121: Business_rule_proc(p_year,
1122: p_person_id,
1123: p_gre_id);
1124: hr_utility.set_location(' Leaving:'||l_proc, 1500);
1125: EXCEPTION
1126: WHEN NO_DATA_FOUND THEN
1127: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
1128: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found ');

Line 1130: hr_utility.set_location('No records found ', 95);

1126: WHEN NO_DATA_FOUND THEN
1127: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
1128: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found ');
1129: ELSE
1130: hr_utility.set_location('No records found ', 95);
1131: END IF;
1132: WHEN OTHERS THEN
1133: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
1134: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(SQLERRM, 1, 128) || ' in ' ||

Line 1137: hr_utility.set_location(substr(SQLERRM, 1, 128) || ' in ' ||

1133: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
1134: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(SQLERRM, 1, 128) || ' in ' ||
1135: l_proc || ' ' || TO_CHAR(SQLCODE));
1136: ELSE
1137: hr_utility.set_location(substr(SQLERRM, 1, 128) || ' in ' ||
1138: l_proc || ' ' || TO_CHAR(SQLCODE), 100);
1139: END IF;
1140: END rollover_process;
1141: END pay_us_def_comp_457;