APPS.CS_CP_TERMINATION_PKG dependencies on FND_FILE

Line 29: fnd_file.put_line(fnd_file.log, 'Executing pkg body ('||

25: WHERE trunc(sysdate) >= trunc(nvl(end_date_active, sysdate+1));
26:
27: --
28: BEGIN
29: fnd_file.put_line(fnd_file.log, 'Executing pkg body ('||
30: to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss')||')');
31: --
32: IF (G_DEBUG) THEN
33: fnd_file.put_names('status.log', 'status.out',

Line 33: fnd_file.put_names('status.log', 'status.out',

29: fnd_file.put_line(fnd_file.log, 'Executing pkg body ('||
30: to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss')||')');
31: --
32: IF (G_DEBUG) THEN
33: fnd_file.put_names('status.log', 'status.out',
34: '/home/sadiga/work/11i/bapi');
35: END IF;
36: --
37: --

Line 39: fnd_file.put_line(fnd_file.log, 'Fetched cp_id to terminate '||

35: END IF;
36: --
37: --
38: FOR cp_term_cur_rec IN cp_term_cur LOOP
39: fnd_file.put_line(fnd_file.log, 'Fetched cp_id to terminate '||
40: to_char(cp_term_cur_rec.customer_product_id));
41:
42: -- later on, see if we can get the status name instead of printing out
43: -- the status_id.

Line 45: fnd_file.put_line(fnd_file.log, 'Updating the status of this product to '||g_default_term_status_id);

41:
42: -- later on, see if we can get the status name instead of printing out
43: -- the status_id.
44:
45: fnd_file.put_line(fnd_file.log, 'Updating the status of this product to '||g_default_term_status_id);
46:
47: -- see if we call use the Update APis instead.
48:
49: UPDATE cs_customer_products

Line 58: fnd_file.put_line(fnd_file.log, 'Finished execution. Exiting... ('||

54: commit;
55: END LOOP;
56: --
57: --
58: fnd_file.put_line(fnd_file.log, 'Finished execution. Exiting... ('||
59: to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss')||')');
60: --
61: -- Return 0 for successful completion, 1 for warnings, 2 for error
62: errbuf := '';

Line 66: fnd_file.close;

62: errbuf := '';
63: retcode := 0;
64: --
65: IF (G_DEBUG) THEN
66: fnd_file.close;
67: END IF;
68: --
69: --
70: --

Line 75: fnd_file.close;

71: EXCEPTION
72: WHEN OTHERS THEN
73: ROLLBACK;
74: IF (G_DEBUG) THEN
75: fnd_file.close;
76: END IF;
77:
78: -- Retrieve error message into errbuf
79: errbuf := sqlerrm;