DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_SS_PKG dependencies on FND_FILE

Line 5830: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');

5826: --
5827: insert_session(l_effective_date);
5828: commit;
5829: --
5830: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5831: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5832: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5833: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5834: --

Line 5831: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');

5827: insert_session(l_effective_date);
5828: commit;
5829: --
5830: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5831: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5832: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5833: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5834: --
5835: for l_rec in csr_assact loop

Line 5832: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');

5828: commit;
5829: --
5830: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5831: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5832: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5833: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5834: --
5835: for l_rec in csr_assact loop
5836: --

Line 5833: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');

5829: --
5830: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5831: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5832: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5833: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5834: --
5835: for l_rec in csr_assact loop
5836: --
5837: begin

Line 5846: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));

5842: p_user_comments => p_user_comments);
5843: --
5844: commit;
5845: --
5846: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5847: --
5848: exception
5849: when others then
5850: --

Line 5851: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));

5847: --
5848: exception
5849: when others then
5850: --
5851: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5852: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5853: --
5854: end;
5855: --

Line 5852: fnd_file.put_line(fnd_file.log, get_sqlerrm);

5848: exception
5849: when others then
5850: --
5851: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5852: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5853: --
5854: end;
5855: --
5856: end loop;

Line 5915: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');

5911: --
5912: insert_session(l_effective_date);
5913: commit;
5914: --
5915: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5916: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5917: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5918: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5919: --

Line 5916: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');

5912: insert_session(l_effective_date);
5913: commit;
5914: --
5915: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5916: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5917: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5918: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5919: --
5920: for l_rec in csr_assact loop

Line 5917: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');

5913: commit;
5914: --
5915: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5916: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5917: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5918: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5919: --
5920: for l_rec in csr_assact loop
5921: --

Line 5918: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');

5914: --
5915: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5916: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5917: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5918: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5919: --
5920: for l_rec in csr_assact loop
5921: --
5922: begin

Line 5930: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));

5926: p_object_version_number => l_rec.object_version_number);
5927: --
5928: commit;
5929: --
5930: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5931: --
5932: exception
5933: when others then
5934: --

Line 5935: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));

5931: --
5932: exception
5933: when others then
5934: --
5935: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5936: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5937: --
5938: end;
5939: --

Line 5936: fnd_file.put_line(fnd_file.log, get_sqlerrm);

5932: exception
5933: when others then
5934: --
5935: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5936: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5937: --
5938: end;
5939: --
5940: end loop;

Line 6006: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');

6002: --
6003: insert_session(l_effective_date);
6004: commit;
6005: --
6006: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
6007: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
6008: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
6009: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
6010: --

Line 6007: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');

6003: insert_session(l_effective_date);
6004: commit;
6005: --
6006: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
6007: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
6008: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
6009: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
6010: --
6011: for l_rec in csr_assact loop

Line 6008: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');

6004: commit;
6005: --
6006: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
6007: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
6008: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
6009: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
6010: --
6011: for l_rec in csr_assact loop
6012: --

Line 6009: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');

6005: --
6006: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
6007: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
6008: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
6009: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
6010: --
6011: for l_rec in csr_assact loop
6012: --
6013: begin

Line 6024: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));

6020: p_expire_after_transfer => p_expire_after_transfer);
6021: --
6022: commit;
6023: --
6024: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
6025: --
6026: exception
6027: when others then
6028: --

Line 6029: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));

6025: --
6026: exception
6027: when others then
6028: --
6029: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
6030: fnd_file.put_line(fnd_file.log, get_sqlerrm);
6031: --
6032: end;
6033: --

Line 6030: fnd_file.put_line(fnd_file.log, get_sqlerrm);

6026: exception
6027: when others then
6028: --
6029: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
6030: fnd_file.put_line(fnd_file.log, get_sqlerrm);
6031: --
6032: end;
6033: --
6034: end loop;

Line 6100: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');

6096: --
6097: insert_session(l_effective_date);
6098: commit;
6099: --
6100: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
6101: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
6102: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
6103: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
6104: --

Line 6101: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');

6097: insert_session(l_effective_date);
6098: commit;
6099: --
6100: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
6101: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
6102: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
6103: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
6104: --
6105: for l_rec in csr_assact loop

Line 6102: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');

6098: commit;
6099: --
6100: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
6101: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
6102: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
6103: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
6104: --
6105: for l_rec in csr_assact loop
6106: --

Line 6103: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');

6099: --
6100: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
6101: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
6102: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
6103: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
6104: --
6105: for l_rec in csr_assact loop
6106: --
6107: begin

Line 6118: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));

6114: p_mode => p_mode);
6115: --
6116: commit;
6117: --
6118: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
6119: --
6120: exception
6121: when others then
6122: --

Line 6123: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));

6119: --
6120: exception
6121: when others then
6122: --
6123: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
6124: fnd_file.put_line(fnd_file.log, get_sqlerrm);
6125: --
6126: end;
6127: --

Line 6124: fnd_file.put_line(fnd_file.log, get_sqlerrm);

6120: exception
6121: when others then
6122: --
6123: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
6124: fnd_file.put_line(fnd_file.log, get_sqlerrm);
6125: --
6126: end;
6127: --
6128: end loop;