APPS.CS_SR_PURGE_CP dependencies on FND_FILE

Line 7124: fnd_file.put_line

7120: , 'Getting number of SRs submitted for purge'
7121: );
7122: END IF;
7123:
7124: fnd_file.put_line
7125: (
7126: FND_FILE.OUTPUT
7127: , ''
7128: );

Line 7126: FND_FILE.OUTPUT

7122: END IF;
7123:
7124: fnd_file.put_line
7125: (
7126: FND_FILE.OUTPUT
7127: , ''
7128: );
7129: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7130: THEN

Line 7144: fnd_file.put_line

7140: (
7141: 'CS'
7142: , 'CS_SR_PURGE_RESULT'
7143: );
7144: fnd_file.put_line
7145: (
7146: FND_FILE.OUTPUT
7147: , '

' || l_report_caption
7148: || '

Line 7146: FND_FILE.OUTPUT

7142: , 'CS_SR_PURGE_RESULT'
7143: );
7144: fnd_file.put_line
7145: (
7146: FND_FILE.OUTPUT
7147: , '

' || l_report_caption
7148: || '

Line 7179: fnd_file.put_line

7175: cs_incidents_purge_staging s
7176: WHERE
7177: s.worker_id = NVL(p_worker_id, s.worker_id);
7178:
7179: fnd_file.put_line
7180: (
7181: FND_FILE.OUTPUT
7182: , '

Line 7181: FND_FILE.OUTPUT

7177: s.worker_id = NVL(p_worker_id, s.worker_id);
7178:
7179: fnd_file.put_line
7180: (
7181: FND_FILE.OUTPUT
7182: , '

Line 7237: fnd_file.put_line

7233: WHERE
7234: purge_status = 'S'
7235: AND s.worker_id = NVL(p_worker_id, s.worker_id);
7236:
7237: fnd_file.put_line
7238: (
7239: FND_FILE.OUTPUT
7240: , '

Line 7239: FND_FILE.OUTPUT

7235: AND s.worker_id = NVL(p_worker_id, s.worker_id);
7236:
7237: fnd_file.put_line
7238: (
7239: FND_FILE.OUTPUT
7240: , '

Line 7301: fnd_file.put_line

7297: -- if there were some rows that were not
7298: -- processed, display that too in the report.
7299:
7300: THEN
7301: fnd_file.put_line
7302: (
7303: FND_FILE.OUTPUT
7304: , '

Line 7370: fnd_file.put_line

7366: -- if there were some rows that failed during
7367: -- processing, display that in the report.
7368:
7369: THEN
7370: fnd_file.put_line
7371: (
7372: FND_FILE.OUTPUT
7373: , '

Line 7422: fnd_file.put_line

7418:
7419: -- Starting to print the report on all the SRs that failed
7420: -- purge due to business reasons along with the vital details
7421:
7422: fnd_file.put_line
7423: (
7424: FND_FILE.OUTPUT
7425: , '

'
7426: );

Line 7424: FND_FILE.OUTPUT

7420: -- purge due to business reasons along with the vital details
7421:
7422: fnd_file.put_line
7423: (
7424: FND_FILE.OUTPUT
7425: , '

'
7426: );
7427: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7428: THEN

Line 7442: fnd_file.put_line

7438: (
7439: 'CS'
7440: , 'CS_SR_FAILED_SRS_REPORT'
7441: );
7442: fnd_file.put_line
7443: (
7444: FND_FILE.OUTPUT
7445: , l_report_caption
7446: );

Line 7444: FND_FILE.OUTPUT

7440: , 'CS_SR_FAILED_SRS_REPORT'
7441: );
7442: fnd_file.put_line
7443: (
7444: FND_FILE.OUTPUT
7445: , l_report_caption
7446: );
7447: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7448: THEN

Line 7457: fnd_file.put_line

7453: , l_report_caption
7454: );
7455: END IF;
7456:
7457: fnd_file.put_line
7458: (
7459: FND_FILE.OUTPUT
7460: , ''
7461: );

Line 7459: FND_FILE.OUTPUT

7455: END IF;
7456:
7457: fnd_file.put_line
7458: (
7459: FND_FILE.OUTPUT
7460: , ''
7461: );
7462: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7463: THEN

Line 7474: fnd_file.put_line

7470: END IF;
7471:
7472: ---
7473:
7474: fnd_file.put_line
7475: (
7476: FND_FILE.OUTPUT
7477: , ''
7478: );

Line 7476: FND_FILE.OUTPUT

7472: ---
7473:
7474: fnd_file.put_line
7475: (
7476: FND_FILE.OUTPUT
7477: , '

'
7478: );
7479: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7480: THEN

Line 7494: fnd_file.put_line

7490: (
7491: 'CS'
7492: , 'CS_SR_FAILED_SRS_RPT_HEAD'
7493: );
7494: fnd_file.put_line
7495: (
7496: FND_FILE.OUTPUT
7497: , l_report_caption
7498: );

Line 7496: FND_FILE.OUTPUT

7492: , 'CS_SR_FAILED_SRS_RPT_HEAD'
7493: );
7494: fnd_file.put_line
7495: (
7496: FND_FILE.OUTPUT
7497: , l_report_caption
7498: );
7499: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7500: THEN

Line 7509: fnd_file.put_line

7505: , l_report_caption
7506: );
7507: END IF;
7508:
7509: fnd_file.put_line
7510: (
7511: FND_FILE.OUTPUT
7512: , '

'
7513: );

Line 7511: FND_FILE.OUTPUT

7507: END IF;
7508:
7509: fnd_file.put_line
7510: (
7511: FND_FILE.OUTPUT
7512: , ''
7513: );
7514: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7515: THEN

Line 7567: fnd_file.put_line

7563: -- the message dictionary.
7564:
7565: FOR j IN l_incident_number_arr.FIRST..l_incident_number_arr.LAST
7566: LOOP
7567: fnd_file.put_line
7568: (
7569: FND_FILE.OUTPUT
7570: , '

'
7571: );

Line 7569: FND_FILE.OUTPUT

7565: FOR j IN l_incident_number_arr.FIRST..l_incident_number_arr.LAST
7566: LOOP
7567: fnd_file.put_line
7568: (
7569: FND_FILE.OUTPUT
7570: , '

'
7571: );
7572:
7573: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 7696: fnd_file.put_line

7692: END IF;
7693:
7694: l_text := l_text || NVL(l_error_message_text, '-') || '';
7695:
7696: fnd_file.put_line
7697: (
7698: FND_FILE.OUTPUT
7699: , l_text
7700: );

Line 7698: FND_FILE.OUTPUT

7694: l_text := l_text || NVL(l_error_message_text, '-') || '';
7695:
7696: fnd_file.put_line
7697: (
7698: FND_FILE.OUTPUT
7699: , l_text
7700: );
7701:
7702: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 7712: fnd_file.put_line

7708: , l_text
7709: );
7710: END IF;
7711:
7712: fnd_file.put_line
7713: (
7714: FND_FILE.OUTPUT
7715: , '

'
7716: );

Line 7714: FND_FILE.OUTPUT

7710: END IF;
7711:
7712: fnd_file.put_line
7713: (
7714: FND_FILE.OUTPUT
7715: , ''
7716: );
7717:
7718: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 7746: fnd_file.put_line

7742: );
7743: END IF;
7744: END IF;
7745:
7746: fnd_file.put_line
7747: (
7748: FND_FILE.OUTPUT
7749: , '

'
7750: );

Line 7748: FND_FILE.OUTPUT

7744: END IF;
7745:
7746: fnd_file.put_line
7747: (
7748: FND_FILE.OUTPUT
7749: , ''
7750: );
7751: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
7752: THEN