APPS.CS_SR_PURGE_CP dependencies on FND_FILE

Line 7129: fnd_file.put_line

7125: , 'Getting number of SRs submitted for purge'
7126: );
7127: END IF;
7128:
7129: fnd_file.put_line
7130: (
7131: FND_FILE.OUTPUT
7132: , ''
7133: );

Line 7131: FND_FILE.OUTPUT

7127: END IF;
7128:
7129: fnd_file.put_line
7130: (
7131: FND_FILE.OUTPUT
7132: , ''
7133: );
7134: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7135: THEN

Line 7149: fnd_file.put_line

7145: (
7146: 'CS'
7147: , 'CS_SR_PURGE_RESULT'
7148: );
7149: fnd_file.put_line
7150: (
7151: FND_FILE.OUTPUT
7152: , '

' || l_report_caption
7153: || '

Line 7151: FND_FILE.OUTPUT

7147: , 'CS_SR_PURGE_RESULT'
7148: );
7149: fnd_file.put_line
7150: (
7151: FND_FILE.OUTPUT
7152: , '

' || l_report_caption
7153: || '

Line 7184: fnd_file.put_line

7180: cs_incidents_purge_staging s
7181: WHERE
7182: s.worker_id = NVL(p_worker_id, s.worker_id);
7183:
7184: fnd_file.put_line
7185: (
7186: FND_FILE.OUTPUT
7187: , '

Line 7186: FND_FILE.OUTPUT

7182: s.worker_id = NVL(p_worker_id, s.worker_id);
7183:
7184: fnd_file.put_line
7185: (
7186: FND_FILE.OUTPUT
7187: , '

Line 7242: fnd_file.put_line

7238: WHERE
7239: purge_status = 'S'
7240: AND s.worker_id = NVL(p_worker_id, s.worker_id);
7241:
7242: fnd_file.put_line
7243: (
7244: FND_FILE.OUTPUT
7245: , '

Line 7244: FND_FILE.OUTPUT

7240: AND s.worker_id = NVL(p_worker_id, s.worker_id);
7241:
7242: fnd_file.put_line
7243: (
7244: FND_FILE.OUTPUT
7245: , '

Line 7306: fnd_file.put_line

7302: -- if there were some rows that were not
7303: -- processed, display that too in the report.
7304:
7305: THEN
7306: fnd_file.put_line
7307: (
7308: FND_FILE.OUTPUT
7309: , '

Line 7375: fnd_file.put_line

7371: -- if there were some rows that failed during
7372: -- processing, display that in the report.
7373:
7374: THEN
7375: fnd_file.put_line
7376: (
7377: FND_FILE.OUTPUT
7378: , '

Line 7427: fnd_file.put_line

7423:
7424: -- Starting to print the report on all the SRs that failed
7425: -- purge due to business reasons along with the vital details
7426:
7427: fnd_file.put_line
7428: (
7429: FND_FILE.OUTPUT
7430: , '

'
7431: );

Line 7429: FND_FILE.OUTPUT

7425: -- purge due to business reasons along with the vital details
7426:
7427: fnd_file.put_line
7428: (
7429: FND_FILE.OUTPUT
7430: , '

'
7431: );
7432: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7433: THEN

Line 7447: fnd_file.put_line

7443: (
7444: 'CS'
7445: , 'CS_SR_FAILED_SRS_REPORT'
7446: );
7447: fnd_file.put_line
7448: (
7449: FND_FILE.OUTPUT
7450: , l_report_caption
7451: );

Line 7449: FND_FILE.OUTPUT

7445: , 'CS_SR_FAILED_SRS_REPORT'
7446: );
7447: fnd_file.put_line
7448: (
7449: FND_FILE.OUTPUT
7450: , l_report_caption
7451: );
7452: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7453: THEN

Line 7462: fnd_file.put_line

7458: , l_report_caption
7459: );
7460: END IF;
7461:
7462: fnd_file.put_line
7463: (
7464: FND_FILE.OUTPUT
7465: , ''
7466: );

Line 7464: FND_FILE.OUTPUT

7460: END IF;
7461:
7462: fnd_file.put_line
7463: (
7464: FND_FILE.OUTPUT
7465: , ''
7466: );
7467: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7468: THEN

Line 7479: fnd_file.put_line

7475: END IF;
7476:
7477: ---
7478:
7479: fnd_file.put_line
7480: (
7481: FND_FILE.OUTPUT
7482: , ''
7483: );

Line 7481: FND_FILE.OUTPUT

7477: ---
7478:
7479: fnd_file.put_line
7480: (
7481: FND_FILE.OUTPUT
7482: , '

'
7483: );
7484: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7485: THEN

Line 7499: fnd_file.put_line

7495: (
7496: 'CS'
7497: , 'CS_SR_FAILED_SRS_RPT_HEAD'
7498: );
7499: fnd_file.put_line
7500: (
7501: FND_FILE.OUTPUT
7502: , l_report_caption
7503: );

Line 7501: FND_FILE.OUTPUT

7497: , 'CS_SR_FAILED_SRS_RPT_HEAD'
7498: );
7499: fnd_file.put_line
7500: (
7501: FND_FILE.OUTPUT
7502: , l_report_caption
7503: );
7504: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7505: THEN

Line 7514: fnd_file.put_line

7510: , l_report_caption
7511: );
7512: END IF;
7513:
7514: fnd_file.put_line
7515: (
7516: FND_FILE.OUTPUT
7517: , '

'
7518: );

Line 7516: FND_FILE.OUTPUT

7512: END IF;
7513:
7514: fnd_file.put_line
7515: (
7516: FND_FILE.OUTPUT
7517: , ''
7518: );
7519: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7520: THEN

Line 7572: fnd_file.put_line

7568: -- the message dictionary.
7569:
7570: FOR j IN l_incident_number_arr.FIRST..l_incident_number_arr.LAST
7571: LOOP
7572: fnd_file.put_line
7573: (
7574: FND_FILE.OUTPUT
7575: , '

'
7576: );

Line 7574: FND_FILE.OUTPUT

7570: FOR j IN l_incident_number_arr.FIRST..l_incident_number_arr.LAST
7571: LOOP
7572: fnd_file.put_line
7573: (
7574: FND_FILE.OUTPUT
7575: , '

'
7576: );
7577:
7578: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 7701: fnd_file.put_line

7697: END IF;
7698:
7699: l_text := l_text || NVL(l_error_message_text, '-') || '';
7700:
7701: fnd_file.put_line
7702: (
7703: FND_FILE.OUTPUT
7704: , l_text
7705: );

Line 7703: FND_FILE.OUTPUT

7699: l_text := l_text || NVL(l_error_message_text, '-') || '';
7700:
7701: fnd_file.put_line
7702: (
7703: FND_FILE.OUTPUT
7704: , l_text
7705: );
7706:
7707: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 7717: fnd_file.put_line

7713: , l_text
7714: );
7715: END IF;
7716:
7717: fnd_file.put_line
7718: (
7719: FND_FILE.OUTPUT
7720: , '

'
7721: );

Line 7719: FND_FILE.OUTPUT

7715: END IF;
7716:
7717: fnd_file.put_line
7718: (
7719: FND_FILE.OUTPUT
7720: , ''
7721: );
7722:
7723: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 7751: fnd_file.put_line

7747: );
7748: END IF;
7749: END IF;
7750:
7751: fnd_file.put_line
7752: (
7753: FND_FILE.OUTPUT
7754: , '

'
7755: );

Line 7753: FND_FILE.OUTPUT

7749: END IF;
7750:
7751: fnd_file.put_line
7752: (
7753: FND_FILE.OUTPUT
7754: , ''
7755: );
7756: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7757: THEN