APPS.CS_KB_TRACKING_PKG dependencies on FND_FILE

Line 37: -- FND_FILE.PUT_LINE(FND_FILE.LOG,

33:
34: --ERRBUF = err messages
35: --RETCODE = 0=success, 1=warning, 2=error
36:
37: -- FND_FILE.PUT_LINE(FND_FILE.LOG,
38: -- 'Starting Concurrent Program to purge tracking history at: '|| to_char(sysdate,'DD-MON-YY HH24:MI:SS'));
39:
40: -- "Tracking history of invalid ICX session will be deleted."
41: FND_FILE.PUT_LINE(FND_FILE.LOG,

Line 41: FND_FILE.PUT_LINE(FND_FILE.LOG,

37: -- FND_FILE.PUT_LINE(FND_FILE.LOG,
38: -- 'Starting Concurrent Program to purge tracking history at: '|| to_char(sysdate,'DD-MON-YY HH24:MI:SS'));
39:
40: -- "Tracking history of invalid ICX session will be deleted."
41: FND_FILE.PUT_LINE(FND_FILE.LOG,
42: fnd_message.get_string('CS', 'CS_KB_DEL_TRACKING_DATA'));
43:
44: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
45:

Line 44: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

40: -- "Tracking history of invalid ICX session will be deleted."
41: FND_FILE.PUT_LINE(FND_FILE.LOG,
42: fnd_message.get_string('CS', 'CS_KB_DEL_TRACKING_DATA'));
43:
44: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
45:
46: -- LOGIC START
47:
48: open get_session_attr_count;

Line 57: FND_FILE.PUT_LINE(FND_FILE.LOG,

53: fetch get_session_count into l_session_count;
54: close get_session_count;
55:
56: -- "Number of session attributes to be deleted:"
57: FND_FILE.PUT_LINE(FND_FILE.LOG,
58: fnd_message.get_string('CS', 'CS_KB_NUM_SES_ATTR_DEL') || l_session_attr_count);
59:
60: -- "Number of sessions to be deleted:"
61: FND_FILE.PUT_LINE(FND_FILE.LOG,

Line 61: FND_FILE.PUT_LINE(FND_FILE.LOG,

57: FND_FILE.PUT_LINE(FND_FILE.LOG,
58: fnd_message.get_string('CS', 'CS_KB_NUM_SES_ATTR_DEL') || l_session_attr_count);
59:
60: -- "Number of sessions to be deleted:"
61: FND_FILE.PUT_LINE(FND_FILE.LOG,
62: fnd_message.get_string('CS', 'CS_KB_NUM_SES_DEL') || l_session_count);
63:
64: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Purging data...');
65:

Line 64: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Purging data...');

60: -- "Number of sessions to be deleted:"
61: FND_FILE.PUT_LINE(FND_FILE.LOG,
62: fnd_message.get_string('CS', 'CS_KB_NUM_SES_DEL') || l_session_count);
63:
64: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Purging data...');
65:
66: delete cs_kb_session_attrs b
67: where b.session_id in (
68: select a.session_id

Line 90: FND_FILE.PUT_LINE(FND_FILE.LOG,

86: fetch get_session_count into l_session_count;
87: close get_session_count;
88:
89: -- "Number of session attributes to be deleted:"
90: FND_FILE.PUT_LINE(FND_FILE.LOG,
91: fnd_message.get_string('CS', 'CS_KB_NUM_SES_ATTR_DEL') || l_session_attr_count);
92:
93: -- "Number of sessions to be deleted:"
94: FND_FILE.PUT_LINE(FND_FILE.LOG,

Line 94: FND_FILE.PUT_LINE(FND_FILE.LOG,

90: FND_FILE.PUT_LINE(FND_FILE.LOG,
91: fnd_message.get_string('CS', 'CS_KB_NUM_SES_ATTR_DEL') || l_session_attr_count);
92:
93: -- "Number of sessions to be deleted:"
94: FND_FILE.PUT_LINE(FND_FILE.LOG,
95: fnd_message.get_string('CS', 'CS_KB_NUM_SES_DEL') || l_session_count);
96:
97: -- LOGIC END
98:

Line 100: -- FND_FILE.PUT_LINE(FND_FILE.LOG,

96:
97: -- LOGIC END
98:
99:
100: -- FND_FILE.PUT_LINE(FND_FILE.LOG,
101: -- 'Finished Concurrent Program to purge tracking history at: '|| to_char(sysdate,'DD-MON-YY HH24:MI:SS'));
102:
103: COMMIT;
104:

Line 115: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);

111: RETCODE := 2;
112:
113: -- "Execution failed due to unexpected error."
114: ERRBUF := fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;
115: FND_FILE.PUT_LINE(FND_FILE.LOG, ERRBUF);
116:
117: END PURGE_TRACKING_HISTORY;
118:
119: END CS_KB_TRACKING_PKG;