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_ZA_UIF_REFUND_MARCH_2008 dependencies on FND_FILE

Line 1208: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1204: **********************************/
1205:
1206: if l_diff_ee_contr <>0 or l_diff_er_contr <>0 or l_diff_excs_er_contr <>0 then
1207: if l_header_printed = false then
1208: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1209: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following Assignments have been processed for the below mentioned calendar months -');
1210: l_header_printed := true ;
1211: end if;
1212: if l_last_printed_asg <> l_asg_id then

Line 1209: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following Assignments have been processed for the below mentioned calendar months -');

1205:
1206: if l_diff_ee_contr <>0 or l_diff_er_contr <>0 or l_diff_excs_er_contr <>0 then
1207: if l_header_printed = false then
1208: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1209: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following Assignments have been processed for the below mentioned calendar months -');
1210: l_header_printed := true ;
1211: end if;
1212: if l_last_printed_asg <> l_asg_id then
1213: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 1213: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1209: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following Assignments have been processed for the below mentioned calendar months -');
1210: l_header_printed := true ;
1211: end if;
1212: if l_last_printed_asg <> l_asg_id then
1213: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1214: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------');
1215: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1216: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Number : '||rec_assact(rec_count).assignment_number);
1217: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment ID : '||l_asg_id);

Line 1214: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------');

1210: l_header_printed := true ;
1211: end if;
1212: if l_last_printed_asg <> l_asg_id then
1213: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1214: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------');
1215: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1216: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Number : '||rec_assact(rec_count).assignment_number);
1217: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment ID : '||l_asg_id);
1218: end if ;

Line 1215: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1211: end if;
1212: if l_last_printed_asg <> l_asg_id then
1213: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1214: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------');
1215: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1216: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Number : '||rec_assact(rec_count).assignment_number);
1217: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment ID : '||l_asg_id);
1218: end if ;
1219: l_last_printed_asg := l_asg_id ;

Line 1216: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Number : '||rec_assact(rec_count).assignment_number);

1212: if l_last_printed_asg <> l_asg_id then
1213: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1214: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------');
1215: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1216: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Number : '||rec_assact(rec_count).assignment_number);
1217: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment ID : '||l_asg_id);
1218: end if ;
1219: l_last_printed_asg := l_asg_id ;
1220: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 1217: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment ID : '||l_asg_id);

1213: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1214: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------');
1215: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1216: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Number : '||rec_assact(rec_count).assignment_number);
1217: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment ID : '||l_asg_id);
1218: end if ;
1219: l_last_printed_asg := l_asg_id ;
1220: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1221: FND_FILE.PUT_LINE(FND_FILE.LOG,'Duration :' || rec_assact(rec_count).month_yr);

Line 1220: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1216: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment Number : '||rec_assact(rec_count).assignment_number);
1217: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment ID : '||l_asg_id);
1218: end if ;
1219: l_last_printed_asg := l_asg_id ;
1220: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1221: FND_FILE.PUT_LINE(FND_FILE.LOG,'Duration :' || rec_assact(rec_count).month_yr);
1222: FND_FILE.PUT_LINE(FND_FILE.LOG,lpad(' ',32,' ')|| lpad('Existing Value',25,' ')||lpad('Expected Value',25,' ')||lpad('Retro Element Entry Amount',30,' ') );
1223: end if ;
1224:

Line 1221: FND_FILE.PUT_LINE(FND_FILE.LOG,'Duration :' || rec_assact(rec_count).month_yr);

1217: FND_FILE.PUT_LINE(FND_FILE.LOG,'Assignment ID : '||l_asg_id);
1218: end if ;
1219: l_last_printed_asg := l_asg_id ;
1220: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1221: FND_FILE.PUT_LINE(FND_FILE.LOG,'Duration :' || rec_assact(rec_count).month_yr);
1222: FND_FILE.PUT_LINE(FND_FILE.LOG,lpad(' ',32,' ')|| lpad('Existing Value',25,' ')||lpad('Expected Value',25,' ')||lpad('Retro Element Entry Amount',30,' ') );
1223: end if ;
1224:
1225: if l_diff_ee_contr<>0 then

Line 1222: FND_FILE.PUT_LINE(FND_FILE.LOG,lpad(' ',32,' ')|| lpad('Existing Value',25,' ')||lpad('Expected Value',25,' ')||lpad('Retro Element Entry Amount',30,' ') );

1218: end if ;
1219: l_last_printed_asg := l_asg_id ;
1220: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1221: FND_FILE.PUT_LINE(FND_FILE.LOG,'Duration :' || rec_assact(rec_count).month_yr);
1222: FND_FILE.PUT_LINE(FND_FILE.LOG,lpad(' ',32,' ')|| lpad('Existing Value',25,' ')||lpad('Expected Value',25,' ')||lpad('Retro Element Entry Amount',30,' ') );
1223: end if ;
1224:
1225: if l_diff_ee_contr<>0 then
1226: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Employee Contributions :',32,' ') ||lpad(l_prev_ee_cntr,25,' ')|| lpad((l_prev_ee_cntr+l_diff_ee_contr),25,' ')|| lpad(l_diff_ee_contr,30,' '));

Line 1226: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Employee Contributions :',32,' ') ||lpad(l_prev_ee_cntr,25,' ')|| lpad((l_prev_ee_cntr+l_diff_ee_contr),25,' ')|| lpad(l_diff_ee_contr,30,' '));

1222: FND_FILE.PUT_LINE(FND_FILE.LOG,lpad(' ',32,' ')|| lpad('Existing Value',25,' ')||lpad('Expected Value',25,' ')||lpad('Retro Element Entry Amount',30,' ') );
1223: end if ;
1224:
1225: if l_diff_ee_contr<>0 then
1226: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Employee Contributions :',32,' ') ||lpad(l_prev_ee_cntr,25,' ')|| lpad((l_prev_ee_cntr+l_diff_ee_contr),25,' ')|| lpad(l_diff_ee_contr,30,' '));
1227: end if ;
1228:
1229: if l_diff_er_contr <> 0 then
1230: -- Bug 7175221

Line 1234: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Employer Contributions :',32,' ')||lpad(l_prev_er_cntr,25,' ')|| lpad((l_prev_er_cntr+l_diff_er_contr),25,' ')|| lpad(l_diff_er_contr,30,' '));

1230: -- Bug 7175221
1231: -- Empr Contr balance = empr contribution + Excess empr contribution
1232: -- hence subtract excess empr contribution from Empr Contr Bal to get the actual Empr Contribution
1233: l_prev_er_cntr := l_prev_er_cntr - nvl(l_prev_excs_er_cntr,0);
1234: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Employer Contributions :',32,' ')||lpad(l_prev_er_cntr,25,' ')|| lpad((l_prev_er_cntr+l_diff_er_contr),25,' ')|| lpad(l_diff_er_contr,30,' '));
1235: end if ;
1236:
1237: if l_diff_excs_er_contr <> 0 then
1238: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Excess Employer Contributions :',32,' ')||lpad(l_prev_excs_er_cntr,25,' ')|| lpad((l_prev_excs_er_cntr+l_diff_excs_er_contr),25,' ')|| lpad(l_diff_excs_er_contr,30,' '));

Line 1238: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Excess Employer Contributions :',32,' ')||lpad(l_prev_excs_er_cntr,25,' ')|| lpad((l_prev_excs_er_cntr+l_diff_excs_er_contr),25,' ')|| lpad(l_diff_excs_er_contr,30,' '));

1234: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Employer Contributions :',32,' ')||lpad(l_prev_er_cntr,25,' ')|| lpad((l_prev_er_cntr+l_diff_er_contr),25,' ')|| lpad(l_diff_er_contr,30,' '));
1235: end if ;
1236:
1237: if l_diff_excs_er_contr <> 0 then
1238: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Excess Employer Contributions :',32,' ')||lpad(l_prev_excs_er_cntr,25,' ')|| lpad((l_prev_excs_er_cntr+l_diff_excs_er_contr),25,' ')|| lpad(l_diff_excs_er_contr,30,' '));
1239: end if ;
1240:
1241: else
1242: hr_utility.trace('Process already run for assignment_id :'||l_asg_id);

Line 1257: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1253: end loop;
1254:
1255: -- Print unprocessed assignments in the log file
1256: if unprocessed_asgn_count > 0 then
1257: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1258: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',120,'-'));
1259: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',120,'-'));
1260: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1261: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following Assignments were not processed for the below mentioned calendar months,');

Line 1258: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',120,'-'));

1254:
1255: -- Print unprocessed assignments in the log file
1256: if unprocessed_asgn_count > 0 then
1257: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1258: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',120,'-'));
1259: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',120,'-'));
1260: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1261: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following Assignments were not processed for the below mentioned calendar months,');
1262: FND_FILE.PUT_LINE(FND_FILE.LOG,'as UIF contributions for these have been manually adjusted.');

Line 1259: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',120,'-'));

1255: -- Print unprocessed assignments in the log file
1256: if unprocessed_asgn_count > 0 then
1257: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1258: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',120,'-'));
1259: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',120,'-'));
1260: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1261: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following Assignments were not processed for the below mentioned calendar months,');
1262: FND_FILE.PUT_LINE(FND_FILE.LOG,'as UIF contributions for these have been manually adjusted.');
1263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please review the same and perform the adjustments as required.');

Line 1260: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1256: if unprocessed_asgn_count > 0 then
1257: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1258: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',120,'-'));
1259: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',120,'-'));
1260: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1261: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following Assignments were not processed for the below mentioned calendar months,');
1262: FND_FILE.PUT_LINE(FND_FILE.LOG,'as UIF contributions for these have been manually adjusted.');
1263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please review the same and perform the adjustments as required.');
1264: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 1261: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following Assignments were not processed for the below mentioned calendar months,');

1257: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1258: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',120,'-'));
1259: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',120,'-'));
1260: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1261: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following Assignments were not processed for the below mentioned calendar months,');
1262: FND_FILE.PUT_LINE(FND_FILE.LOG,'as UIF contributions for these have been manually adjusted.');
1263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please review the same and perform the adjustments as required.');
1264: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1265: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Assignment Number',50)|| rpad('Calendar Month',20));

Line 1262: FND_FILE.PUT_LINE(FND_FILE.LOG,'as UIF contributions for these have been manually adjusted.');

1258: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',120,'-'));
1259: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',120,'-'));
1260: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1261: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following Assignments were not processed for the below mentioned calendar months,');
1262: FND_FILE.PUT_LINE(FND_FILE.LOG,'as UIF contributions for these have been manually adjusted.');
1263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please review the same and perform the adjustments as required.');
1264: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1265: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Assignment Number',50)|| rpad('Calendar Month',20));
1266: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',45,'-')|| rpad(' ',5,' ')||rpad('-',20,'-'));

Line 1263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please review the same and perform the adjustments as required.');

1259: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',120,'-'));
1260: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1261: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following Assignments were not processed for the below mentioned calendar months,');
1262: FND_FILE.PUT_LINE(FND_FILE.LOG,'as UIF contributions for these have been manually adjusted.');
1263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please review the same and perform the adjustments as required.');
1264: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1265: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Assignment Number',50)|| rpad('Calendar Month',20));
1266: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',45,'-')|| rpad(' ',5,' ')||rpad('-',20,'-'));
1267: for asgn_count in unprocessed_assignments.first .. unprocessed_assignments.last

Line 1264: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1260: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1261: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following Assignments were not processed for the below mentioned calendar months,');
1262: FND_FILE.PUT_LINE(FND_FILE.LOG,'as UIF contributions for these have been manually adjusted.');
1263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please review the same and perform the adjustments as required.');
1264: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1265: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Assignment Number',50)|| rpad('Calendar Month',20));
1266: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',45,'-')|| rpad(' ',5,' ')||rpad('-',20,'-'));
1267: for asgn_count in unprocessed_assignments.first .. unprocessed_assignments.last
1268: loop

Line 1265: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Assignment Number',50)|| rpad('Calendar Month',20));

1261: FND_FILE.PUT_LINE(FND_FILE.LOG,'The following Assignments were not processed for the below mentioned calendar months,');
1262: FND_FILE.PUT_LINE(FND_FILE.LOG,'as UIF contributions for these have been manually adjusted.');
1263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please review the same and perform the adjustments as required.');
1264: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1265: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Assignment Number',50)|| rpad('Calendar Month',20));
1266: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',45,'-')|| rpad(' ',5,' ')||rpad('-',20,'-'));
1267: for asgn_count in unprocessed_assignments.first .. unprocessed_assignments.last
1268: loop
1269: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad(unprocessed_assignments(asgn_count).assignment_number,50)|| rpad(unprocessed_assignments(asgn_count).month_yr,'20'));

Line 1266: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',45,'-')|| rpad(' ',5,' ')||rpad('-',20,'-'));

1262: FND_FILE.PUT_LINE(FND_FILE.LOG,'as UIF contributions for these have been manually adjusted.');
1263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please review the same and perform the adjustments as required.');
1264: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1265: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Assignment Number',50)|| rpad('Calendar Month',20));
1266: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',45,'-')|| rpad(' ',5,' ')||rpad('-',20,'-'));
1267: for asgn_count in unprocessed_assignments.first .. unprocessed_assignments.last
1268: loop
1269: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad(unprocessed_assignments(asgn_count).assignment_number,50)|| rpad(unprocessed_assignments(asgn_count).month_yr,'20'));
1270: end loop ;

Line 1269: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad(unprocessed_assignments(asgn_count).assignment_number,50)|| rpad(unprocessed_assignments(asgn_count).month_yr,'20'));

1265: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('Assignment Number',50)|| rpad('Calendar Month',20));
1266: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad('-',45,'-')|| rpad(' ',5,' ')||rpad('-',20,'-'));
1267: for asgn_count in unprocessed_assignments.first .. unprocessed_assignments.last
1268: loop
1269: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad(unprocessed_assignments(asgn_count).assignment_number,50)|| rpad(unprocessed_assignments(asgn_count).month_yr,'20'));
1270: end loop ;
1271: end if;
1272:
1273: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 1273: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

1269: FND_FILE.PUT_LINE(FND_FILE.LOG,rpad(unprocessed_assignments(asgn_count).assignment_number,50)|| rpad(unprocessed_assignments(asgn_count).month_yr,'20'));
1270: end loop ;
1271: end if;
1272:
1273: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1274: -- Clear PL/SQL table
1275: --rec_assact.DELETE ;
1276: commit ;
1277: