DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_SS_PKG dependencies on FND_FILE

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

4900: --
4901: insert_session(l_effective_date);
4902: commit;
4903: --
4904: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4905: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4906: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4907: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4908: --

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

4901: insert_session(l_effective_date);
4902: commit;
4903: --
4904: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4905: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4906: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4907: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4908: --
4909: for l_rec in csr_assact loop

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

4902: commit;
4903: --
4904: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4905: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4906: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4907: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4908: --
4909: for l_rec in csr_assact loop
4910: --

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

4903: --
4904: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4905: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4906: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4907: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4908: --
4909: for l_rec in csr_assact loop
4910: --
4911: begin

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

4916: p_user_comments => p_user_comments);
4917: --
4918: commit;
4919: --
4920: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
4921: --
4922: exception
4923: when others then
4924: --

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

4921: --
4922: exception
4923: when others then
4924: --
4925: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
4926: fnd_file.put_line(fnd_file.log, get_sqlerrm);
4927: --
4928: end;
4929: --

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

4922: exception
4923: when others then
4924: --
4925: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
4926: fnd_file.put_line(fnd_file.log, get_sqlerrm);
4927: --
4928: end;
4929: --
4930: end loop;

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

4985: --
4986: insert_session(l_effective_date);
4987: commit;
4988: --
4989: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4990: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4991: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4992: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4993: --

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

4986: insert_session(l_effective_date);
4987: commit;
4988: --
4989: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4990: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4991: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4992: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4993: --
4994: for l_rec in csr_assact loop

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

4987: commit;
4988: --
4989: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4990: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4991: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4992: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4993: --
4994: for l_rec in csr_assact loop
4995: --

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

4988: --
4989: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4990: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4991: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4992: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4993: --
4994: for l_rec in csr_assact loop
4995: --
4996: begin

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

5000: p_object_version_number => l_rec.object_version_number);
5001: --
5002: commit;
5003: --
5004: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5005: --
5006: exception
5007: when others then
5008: --

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

5005: --
5006: exception
5007: when others then
5008: --
5009: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5010: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5011: --
5012: end;
5013: --

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

5006: exception
5007: when others then
5008: --
5009: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5010: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5011: --
5012: end;
5013: --
5014: end loop;

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

5076: --
5077: insert_session(l_effective_date);
5078: commit;
5079: --
5080: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5081: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5082: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5083: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5084: --

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

5077: insert_session(l_effective_date);
5078: commit;
5079: --
5080: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5081: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5082: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5083: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5084: --
5085: for l_rec in csr_assact loop

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

5078: commit;
5079: --
5080: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5081: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5082: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5083: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5084: --
5085: for l_rec in csr_assact loop
5086: --

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

5079: --
5080: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5081: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5082: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5083: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5084: --
5085: for l_rec in csr_assact loop
5086: --
5087: begin

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

5094: p_expire_after_transfer => p_expire_after_transfer);
5095: --
5096: commit;
5097: --
5098: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5099: --
5100: exception
5101: when others then
5102: --

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

5099: --
5100: exception
5101: when others then
5102: --
5103: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5104: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5105: --
5106: end;
5107: --

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

5100: exception
5101: when others then
5102: --
5103: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5104: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5105: --
5106: end;
5107: --
5108: end loop;

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

5170: --
5171: insert_session(l_effective_date);
5172: commit;
5173: --
5174: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5175: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5176: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5177: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5178: --

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

5171: insert_session(l_effective_date);
5172: commit;
5173: --
5174: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5175: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5176: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5177: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5178: --
5179: for l_rec in csr_assact loop

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

5172: commit;
5173: --
5174: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5175: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5176: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5177: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5178: --
5179: for l_rec in csr_assact loop
5180: --

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

5173: --
5174: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5175: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5176: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5177: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5178: --
5179: for l_rec in csr_assact loop
5180: --
5181: begin

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

5188: p_mode => p_mode);
5189: --
5190: commit;
5191: --
5192: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5193: --
5194: exception
5195: when others then
5196: --

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

5193: --
5194: exception
5195: when others then
5196: --
5197: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5198: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5199: --
5200: end;
5201: --

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

5194: exception
5195: when others then
5196: --
5197: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5198: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5199: --
5200: end;
5201: --
5202: end loop;