DBA Data[Home] [Help]

APPS.PAY_US_DEF_COMP_457 dependencies on FND_GLOBAL

Line 166: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

162: AND ppf.business_group_id = l_business_group_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 = '

Line 183: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

179: ' Includable Comp is ' || TO_CHAR(l_includable_comp) || ' in Business Group Id = ' || TO_CHAR(l_business_group_id), 15);
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

Line 197: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

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

Line 285: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

281:
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) ||

Line 363: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

359:
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)

Line 464: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

460:
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

Line 476: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

472: END IF;
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);

Line 555: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

551: p_ovn_number := 0;
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

Line 897: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

893: END IF;
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 ));

Line 940: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

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

Line 1073: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

1069: l_first_time := FALSE ;
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

Line 1086: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

1082: END IF;
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));

Line 1103: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

1099: END IF;
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

Line 1127: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

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

Line 1133: IF (FND_GLOBAL.CONC_REQUEST_ID <> -1 ) THEN

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 ' ||
1135: l_proc || ' ' || TO_CHAR(SQLCODE));
1136: ELSE
1137: hr_utility.set_location(substr(SQLERRM, 1, 128) || ' in ' ||