APPS.IGS_CO_SUBMIT dependencies on FND_FILE

Line 79: fnd_file.put_line (fnd_file.output, '');

75: l_mouse_over_text := 'onMouseOver="window.status='''
76: || l_user_function_name
77: || '''; return true"';
78: -- Start writing out HTML output
79: fnd_file.put_line (fnd_file.output, '');
80: fnd_file.put_line (fnd_file.output, ' ');
81: -- write out the auto-refresh URL metatag
82: fnd_file.put (
83: fnd_file.output,

Line 80: fnd_file.put_line (fnd_file.output, ' ');

76: || l_user_function_name
77: || '''; return true"';
78: -- Start writing out HTML output
79: fnd_file.put_line (fnd_file.output, '');
80: fnd_file.put_line (fnd_file.output, ' ');
81: -- write out the auto-refresh URL metatag
82: fnd_file.put (
83: fnd_file.output,
84: ' ');

Line 86: fnd_file.put (fnd_file.output, l_url);

82: fnd_file.put (
83: fnd_file.output,
84: ' ');
88: -- Finish of header section and start on the body
89: fnd_file.put_line (fnd_file.output, '

Line 87: fnd_file.put_line (fnd_file.output, '">');

83: fnd_file.output,
84: ' ');
88: -- Finish of header section and start on the body
89: fnd_file.put_line (fnd_file.output, '

Line 89: fnd_file.put_line (fnd_file.output, ' ');

85: );
86: fnd_file.put (fnd_file.output, l_url);
87: fnd_file.put_line (fnd_file.output, '">');
88: -- Finish of header section and start on the body
89: fnd_file.put_line (fnd_file.output, '

Line 90: fnd_file.put_line (fnd_file.output, ' ');

86: fnd_file.put (fnd_file.output, l_url);
87: fnd_file.put_line (fnd_file.output, '">');
88: -- Finish of header section and start on the body
89: fnd_file.put_line (fnd_file.output, '

102: ) -- click here if not autotmatically taken to correspondence workbench
103: || ''
104: );
105: -- finialize the html output
106: fnd_file.put_line (fnd_file.output, ' ');
107: fnd_file.put_line (fnd_file.output, '');
108: END IF;
109: /* --** proc level logging.
110: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 107: fnd_file.put_line (fnd_file.output, '');

103: || ''
104: );
105: -- finialize the html output
106: fnd_file.put_line (fnd_file.output, ' ');
107: fnd_file.put_line (fnd_file.output, '');
108: END IF;
109: /* --** proc level logging.
110: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
111: IF (l_log_request_id IS NULL) THEN

Line 300: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

296: OR p_sender_email IS NOT NULL
297: OR p_cc_email IS NOT NULL THEN
298: IF INSTR (l_delivery_type, 'EMAIL') <= 0 THEN -- Email option not chosen
299: fnd_message.set_name ('IGS', 'IGS_CO_EMAIL_REQ');
300: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
301: fnd_msg_pub.ADD;
302: RAISE fnd_api.g_exc_error;
303: END IF;
304: END IF;

Line 315: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

311: l_printer_name := fnd_profile.VALUE ('IGS_CO_DESTINATION_NAME');
312: ELSE
313: fnd_message.set_name ('IGS', 'IGS_CO_DEST_INF_REQ');
314: fnd_message.set_token ('DELTYPE', l_delivery_type);
315: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
316: fnd_msg_pub.ADD;
317: RAISE fnd_api.g_exc_error;
318: END IF;
319: END IF;

Line 331: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

327: );
328: ELSE
329: fnd_message.set_name ('IGS', 'IGS_CO_DEST_INF_REQ');
330: fnd_message.set_token ('DELTYPE', l_delivery_type);
331: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
332: fnd_msg_pub.ADD;
333: RAISE fnd_api.g_exc_error;
334: END IF;
335: ELSE

Line 389: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());

385:
386: IF l_user IS NULL THEN
387: -- log a message that the current user is not a valid CRM resource
388: fnd_message.set_name ('IGS', 'IGS_CO_INVALID_JTF_RES');
389: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
390: fnd_file.put_line (fnd_file.LOG, ' ');
391: retcode := 2;
392: RETURN;
393: ELSE

Line 390: fnd_file.put_line (fnd_file.LOG, ' ');

386: IF l_user IS NULL THEN
387: -- log a message that the current user is not a valid CRM resource
388: fnd_message.set_name ('IGS', 'IGS_CO_INVALID_JTF_RES');
389: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
390: fnd_file.put_line (fnd_file.LOG, ' ');
391: retcode := 2;
392: RETURN;
393: ELSE
394: -- do not need to pass server id.

Line 404: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());

400: END IF;
401:
402: IF (l_crm_user_id IS NULL) THEN
403: fnd_message.set_name ('JTF', 'JTF_FM_API_MISSING_USER_ID');
404: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
405: fnd_file.put_line (fnd_file.LOG, ' ');
406: retcode := 0;
407: RETURN;
408: END IF;

Line 405: fnd_file.put_line (fnd_file.LOG, ' ');

401:
402: IF (l_crm_user_id IS NULL) THEN
403: fnd_message.set_name ('JTF', 'JTF_FM_API_MISSING_USER_ID');
404: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
405: fnd_file.put_line (fnd_file.LOG, ' ');
406: retcode := 0;
407: RETURN;
408: END IF;
409:

Line 486: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());

482:
483: IF c_avail_del_channel%NOTFOUND THEN
484: fnd_message.set_name ('IGS', 'IGS_CO_UNAVAIL_DEL_TYPE');
485: fnd_message.set_token ('CHANNEL ', l_del_desc);
486: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
487: retcode := 2;
488: RETURN;
489: END IF;
490:

Line 504: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());

500:
501: IF c_avail_del_channel%NOTFOUND THEN
502: fnd_message.set_name ('IGS', 'IGS_CO_UNAVAIL_DEL_TYPE');
503: fnd_message.set_token ('CHANNEL ', l_del_desc);
504: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
505: retcode := 2;
506: RETURN;
507: END IF;
508:

Line 522: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());

518:
519: IF c_avail_del_channel%NOTFOUND THEN
520: fnd_message.set_name ('IGS', 'IGS_CO_UNAVAIL_DEL_TYPE');
521: fnd_message.set_token ('CHANNEL ', l_del_desc);
522: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
523: retcode := 2;
524: RETURN;
525: END IF;
526:

Line 907: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

903: fnd_message.set_token (
904: 'STUDENT',
905: l_person_number || ' - ' || l_full_name
906: );
907: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
908: ELSE
909: IF l_sys_ltr_code IN ('FAAWARD', 'FAMISTM', 'FADISBT')
910: AND (l_letter_type = 'SYSTEM') THEN
911: --** exec level logging.

Line 1167: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());

1163: build_preview_html (fnd_global.conc_request_id);
1164: END IF;
1165: ELSE
1166: fnd_message.set_name ('IGS', 'IGS_CO_NO_REC');
1167: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
1168: fnd_file.put_line (fnd_file.LOG, ' ');
1169: RETURN;
1170: END IF;
1171:

Line 1168: fnd_file.put_line (fnd_file.LOG, ' ');

1164: END IF;
1165: ELSE
1166: fnd_message.set_name ('IGS', 'IGS_CO_NO_REC');
1167: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
1168: fnd_file.put_line (fnd_file.LOG, ' ');
1169: RETURN;
1170: END IF;
1171:
1172: IF l_person_processed = 0 THEN

Line 1174: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());

1170: END IF;
1171:
1172: IF l_person_processed = 0 THEN
1173: fnd_message.set_name ('IGS', 'IGS_CO_NO_REC');
1174: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
1175: fnd_file.put_line (fnd_file.LOG, ' ');
1176:
1177: --fnd_file.put_line(FND_FILE.LOG,l_sql_stmt);
1178:

Line 1175: fnd_file.put_line (fnd_file.LOG, ' ');

1171:
1172: IF l_person_processed = 0 THEN
1173: fnd_message.set_name ('IGS', 'IGS_CO_NO_REC');
1174: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
1175: fnd_file.put_line (fnd_file.LOG, ' ');
1176:
1177: --fnd_file.put_line(FND_FILE.LOG,l_sql_stmt);
1178:
1179: --** exec level logging.

Line 1177: --fnd_file.put_line(FND_FILE.LOG,l_sql_stmt);

1173: fnd_message.set_name ('IGS', 'IGS_CO_NO_REC');
1174: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
1175: fnd_file.put_line (fnd_file.LOG, ' ');
1176:
1177: --fnd_file.put_line(FND_FILE.LOG,l_sql_stmt);
1178:
1179: --** exec level logging.
1180: IF fnd_log.test (fnd_log.level_exception, l_prog_label) THEN
1181: IF (l_log_request_id IS NULL) THEN

Line 1470: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

1466: fnd_message.set_token (
1467: 'STUDENT',
1468: l_person_number || ' - ' || l_full_name
1469: );
1470: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
1471: ELSE
1472: IF l_sys_ltr_code NOT IN ('FAAWARD', 'FAMISTM', 'FADISTM') THEN
1473: igs_co_process.corp_check_interaction_history (
1474: p_person_id => l_person_id_dy,

Line 1764: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());

1760:
1761:
1762: ELSE
1763: fnd_message.set_name ('IGS', 'IGS_CO_NO_REC');
1764: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
1765: fnd_file.put_line (fnd_file.LOG, ' ');
1766: RETURN;
1767: END IF;
1768:

Line 1765: fnd_file.put_line (fnd_file.LOG, ' ');

1761:
1762: ELSE
1763: fnd_message.set_name ('IGS', 'IGS_CO_NO_REC');
1764: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
1765: fnd_file.put_line (fnd_file.LOG, ' ');
1766: RETURN;
1767: END IF;
1768:
1769: IF l_person_processed = 0 THEN

Line 1771: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());

1767: END IF;
1768:
1769: IF l_person_processed = 0 THEN
1770: fnd_message.set_name ('IGS', 'IGS_CO_NO_REC');
1771: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
1772: fnd_file.put_line (fnd_file.LOG, ' ');
1773:
1774: --fnd_file.put_line(FND_FILE.LOG,l_sql_stmt);
1775: --** exec level logging.

Line 1772: fnd_file.put_line (fnd_file.LOG, ' ');

1768:
1769: IF l_person_processed = 0 THEN
1770: fnd_message.set_name ('IGS', 'IGS_CO_NO_REC');
1771: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
1772: fnd_file.put_line (fnd_file.LOG, ' ');
1773:
1774: --fnd_file.put_line(FND_FILE.LOG,l_sql_stmt);
1775: --** exec level logging.
1776: IF fnd_log.test (fnd_log.level_exception, l_prog_label) THEN

Line 1774: --fnd_file.put_line(FND_FILE.LOG,l_sql_stmt);

1770: fnd_message.set_name ('IGS', 'IGS_CO_NO_REC');
1771: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
1772: fnd_file.put_line (fnd_file.LOG, ' ');
1773:
1774: --fnd_file.put_line(FND_FILE.LOG,l_sql_stmt);
1775: --** exec level logging.
1776: IF fnd_log.test (fnd_log.level_exception, l_prog_label) THEN
1777: IF (l_log_request_id IS NULL) THEN
1778: l_log_request_id := fnd_global.conc_request_id;

Line 1975: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

1971: fnd_message.set_token (
1972: 'STDNT',
1973: l_person_number || ' - ' || l_full_name
1974: );
1975: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
1976: fnd_message.set_name ('IGS', 'IGS_CO_REQ_INFO');
1977: fnd_message.set_token ('REQUEST_ID', l_ff_request_hist_id);
1978: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
1979: CLOSE c_per_processed;

Line 1978: fnd_file.put_line (fnd_file.LOG, fnd_message.get);

1974: );
1975: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
1976: fnd_message.set_name ('IGS', 'IGS_CO_REQ_INFO');
1977: fnd_message.set_token ('REQUEST_ID', l_ff_request_hist_id);
1978: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
1979: CLOSE c_per_processed;
1980: OPEN c_content_version (
1981: l_current_content_id,
1982: l_currentversion_id

Line 2020: fnd_file.put_line (fnd_file.LOG, l_tmp_var1);

2016: );
2017: l_tmp_var1 := l_tmp_var1 || l_tmp_var;
2018: END LOOP;
2019:
2020: fnd_file.put_line (fnd_file.LOG, l_tmp_var1);
2021: ELSE
2022: fnd_file.put_line (
2023: fnd_file.LOG,
2024: l_msg_data || '-' || l_msg_count

Line 2022: fnd_file.put_line (

2018: END LOOP;
2019:
2020: fnd_file.put_line (fnd_file.LOG, l_tmp_var1);
2021: ELSE
2022: fnd_file.put_line (
2023: fnd_file.LOG,
2024: l_msg_data || '-' || l_msg_count
2025: );
2026: END IF;

Line 2023: fnd_file.LOG,

2019:
2020: fnd_file.put_line (fnd_file.LOG, l_tmp_var1);
2021: ELSE
2022: fnd_file.put_line (
2023: fnd_file.LOG,
2024: l_msg_data || '-' || l_msg_count
2025: );
2026: END IF;
2027: END IF;

Line 2063: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());

2059: CLOSE c_preview_requests;
2060: ELSE
2061: -- log message "Invalid distribution identifier supplied"
2062: fnd_message.set_name ('IGS', 'IGS_CO_ERR_INVLD_DIST_ID');
2063: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
2064: fnd_file.put_line (fnd_file.LOG, ' ');
2065: retcode := 2;
2066: RETURN;
2067: END IF;

Line 2064: fnd_file.put_line (fnd_file.LOG, ' ');

2060: ELSE
2061: -- log message "Invalid distribution identifier supplied"
2062: fnd_message.set_name ('IGS', 'IGS_CO_ERR_INVLD_DIST_ID');
2063: fnd_file.put_line (fnd_file.LOG, fnd_message.get ());
2064: fnd_file.put_line (fnd_file.LOG, ' ');
2065: retcode := 2;
2066: RETURN;
2067: END IF;
2068: EXCEPTION