DBA Data[Home] [Help]

APPS.CS_KB_TRACKING_PKG dependencies on FND_MESSAGE

Line 42: fnd_message.get_string('CS', 'CS_KB_DEL_TRACKING_DATA'));

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:
46: -- LOGIC START

Line 58: fnd_message.get_string('CS', 'CS_KB_NUM_SES_ATTR_DEL') || l_session_attr_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,
62: fnd_message.get_string('CS', 'CS_KB_NUM_SES_DEL') || l_session_count);

Line 62: fnd_message.get_string('CS', 'CS_KB_NUM_SES_DEL') || l_session_count);

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:
66: delete cs_kb_session_attrs b

Line 91: fnd_message.get_string('CS', 'CS_KB_NUM_SES_ATTR_DEL') || l_session_attr_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,
95: fnd_message.get_string('CS', 'CS_KB_NUM_SES_DEL') || l_session_count);

Line 95: fnd_message.get_string('CS', 'CS_KB_NUM_SES_DEL') || l_session_count);

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:
99:

Line 114: ERRBUF := fnd_message.GET_STRING('CS','CS_KB_C_UNEXP_ERR')||' '||SQLERRM;

110: WHEN OTHERS THEN
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: