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 FND_FILE

Line 167: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Id = ' ||

163: AND ppf.person_type_id = ppt.person_type_id
164: AND ppt.system_person_type = 'EMP' ;
165:
166: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
167: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Id = ' ||
168: TO_CHAR(l_person_id) || ', Name = ' || l_full_name || ' has '
169: || 'contribution of ' || TO_CHAR(l_amt_contr) ||
170: ' Maximum contribution allowed for ' || ' for the Year = '
171: || TO_CHAR(p_year) || ' is ' || TO_CHAR(l_max_contr_allowed) ||

Line 184: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc

180: END IF;
181: EXCEPTION
182: WHEN OTHERS THEN
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);

Line 198: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc

194:
195: EXCEPTION
196: WHEN OTHERS THEN
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);

Line 286: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured while inserting in' ||

282: l_contr_history_id := 0;
283: l_object_version_number := 0;
284:
285: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
286: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured while inserting in' ||
287: ' PAY_US_CONTRIBUTION_HISTORY table for Person id = ' ||
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);

Line 364: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured while Updating in' ||

360: l_contr_history_id := l_history_id;
361: l_object_version_number := l_ovn;
362:
363: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
364: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured while Updating in' ||
365: ' PAY_US_CONTRIBUTION_HISTORY table for Contr_history_id = ' ||
366: TO_CHAR(l_contr_history_id) || ' Object Version Number = ' ||
367: TO_CHAR(l_object_version_number)
368: || SUBSTR(SQLERRM, 1, 128) || ' ' || TO_CHAR(SQLCODE) ||

Line 465: FND_FILE.PUT_LINE(FND_FILE.LOG,p_balance_name ||

461: RETURN l_balance;
462: EXCEPTION
463: WHEN NO_DATA_FOUND THEN
464: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
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 ||

Line 477: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured while calculating ' ||

473: g_get_bal_flag := 'ERROR';
474: RETURN 0;
475: WHEN OTHERS THEN
476: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
477: FND_FILE.PUT_LINE(FND_FILE.LOG,'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

Line 556: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occured in WHEN OTHER for

552: WHEN OTHERS THEN
553: p_contr_history_id := 0;
554: p_ovn_number := 0;
555: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
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 '||

Line 898: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameters received ----> ' );

894:
895: -- Defaults the override mode to 'NO'
896:
897: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
898: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameters received ----> ' );
899: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Person Id : ' || TO_CHAR(p_person_id));
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);

Line 899: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Person Id : ' || TO_CHAR(p_person_id));

895: -- Defaults the override mode to 'NO'
896:
897: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
898: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameters received ----> ' );
899: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Person Id : ' || TO_CHAR(p_person_id));
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

Line 900: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Year : ' || TO_CHAR(p_year));

896:
897: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
898: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameters received ----> ' );
899: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Person Id : ' || TO_CHAR(p_person_id));
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);

Line 901: FND_FILE.PUT_LINE(FND_FILE.LOG, 'GRE : ' || TO_CHAR(p_gre_id ));

897: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
898: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameters received ----> ' );
899: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Person Id : ' || TO_CHAR(p_person_id));
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);

Line 902: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Override Mode : ' || p_override_mode);

898: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameters received ----> ' );
899: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Person Id : ' || TO_CHAR(p_person_id));
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);

Line 941: FND_FILE.PUT_LINE(FND_FILE.LOG,'Person Id = ' ||

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 = ' ||
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

Line 1074: FND_FILE.PUT_LINE(FND_FILE.LOG,'No record found for Year = '

1070:
1071: IF (p_person_id IS NULL) THEN
1072: IF (l_person_id IS NULL) THEN
1073: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
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 = ' ||

Line 1087: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No record found for ' ||

1083: EXIT WHEN C_All_Emp%NOTFOUND;
1084: ELSE
1085: IF (l_person_id IS NULL) THEN
1086: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
1087: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No record found for ' ||
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

Line 1104: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(SQLERRM, 1, 255) || ' in ' ||

1100: EXCEPTION
1101:
1102: WHEN OTHERS THEN
1103: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN
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 ' ||

Line 1128: FND_FILE.PUT_LINE(FND_FILE.LOG,'No records found ');

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 ');
1129: ELSE
1130: hr_utility.set_location('No records found ', 95);
1131: END IF;
1132: WHEN OTHERS THEN

Line 1134: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(SQLERRM, 1, 128) || ' in ' ||

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 ' ||
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);