eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_QP_UPGRADE_PUB dependencies on FND_FILE

Line 87: fnd_file.put_line(FND_FILE.LOG,'Trace Mode is Enabled');

83: END IF;
84:
85: IF NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y' THEN
86: okc_util.init_trace;
87: fnd_file.put_line(FND_FILE.LOG,'Trace Mode is Enabled');
88: END IF;
89:
90: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
91: fnd_file.put_line(FND_FILE.LOG,' Starting Concurrent Program ... ');

Line 90: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');

86: okc_util.init_trace;
87: fnd_file.put_line(FND_FILE.LOG,'Trace Mode is Enabled');
88: END IF;
89:
90: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
91: fnd_file.put_line(FND_FILE.LOG,' Starting Concurrent Program ... ');
92: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
93: fnd_file.put_line(FND_FILE.LOG,' ');
94: fnd_file.put_line(FND_FILE.LOG,' ');

Line 91: fnd_file.put_line(FND_FILE.LOG,' Starting Concurrent Program ... ');

87: fnd_file.put_line(FND_FILE.LOG,'Trace Mode is Enabled');
88: END IF;
89:
90: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
91: fnd_file.put_line(FND_FILE.LOG,' Starting Concurrent Program ... ');
92: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
93: fnd_file.put_line(FND_FILE.LOG,' ');
94: fnd_file.put_line(FND_FILE.LOG,' ');
95:

Line 92: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');

88: END IF;
89:
90: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
91: fnd_file.put_line(FND_FILE.LOG,' Starting Concurrent Program ... ');
92: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
93: fnd_file.put_line(FND_FILE.LOG,' ');
94: fnd_file.put_line(FND_FILE.LOG,' ');
95:
96: IF (l_debug = 'Y') THEN

Line 93: fnd_file.put_line(FND_FILE.LOG,' ');

89:
90: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
91: fnd_file.put_line(FND_FILE.LOG,' Starting Concurrent Program ... ');
92: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
93: fnd_file.put_line(FND_FILE.LOG,' ');
94: fnd_file.put_line(FND_FILE.LOG,' ');
95:
96: IF (l_debug = 'Y') THEN
97: okc_debug.Log('20: p_dflt_price_list_id : '||p_dflt_price_list_id,2);

Line 94: fnd_file.put_line(FND_FILE.LOG,' ');

90: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
91: fnd_file.put_line(FND_FILE.LOG,' Starting Concurrent Program ... ');
92: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
93: fnd_file.put_line(FND_FILE.LOG,' ');
94: fnd_file.put_line(FND_FILE.LOG,' ');
95:
96: IF (l_debug = 'Y') THEN
97: okc_debug.Log('20: p_dflt_price_list_id : '||p_dflt_price_list_id,2);
98: okc_debug.Log('20: p_category_code : '||p_category_code,2);

Line 116: fnd_file.put_line(FND_FILE.LOG,' DATABASE TRACE INFORMATION***** ');

112: okc_debug.Log('25: Conc Req ID : '||fnd_global.conc_request_id,2);
113: END IF;
114:
115: -- log session details
116: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');
117: fnd_file.put_line(FND_FILE.LOG,'Session id : '||l_sessionid);
118: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
119: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);
120: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');

Line 117: fnd_file.put_line(FND_FILE.LOG,'Session id : '||l_sessionid);

113: END IF;
114:
115: -- log session details
116: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');
117: fnd_file.put_line(FND_FILE.LOG,'Session id : '||l_sessionid);
118: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
119: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);
120: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
121: fnd_file.put_line(FND_FILE.LOG,' ');

Line 118: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);

114:
115: -- log session details
116: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');
117: fnd_file.put_line(FND_FILE.LOG,'Session id : '||l_sessionid);
118: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
119: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);
120: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
121: fnd_file.put_line(FND_FILE.LOG,' ');
122: fnd_file.put_line(FND_FILE.LOG,' ');

Line 119: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);

115: -- log session details
116: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');
117: fnd_file.put_line(FND_FILE.LOG,'Session id : '||l_sessionid);
118: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
119: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);
120: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
121: fnd_file.put_line(FND_FILE.LOG,' ');
122: fnd_file.put_line(FND_FILE.LOG,' ');
123:

Line 120: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');

116: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');
117: fnd_file.put_line(FND_FILE.LOG,'Session id : '||l_sessionid);
118: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
119: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);
120: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
121: fnd_file.put_line(FND_FILE.LOG,' ');
122: fnd_file.put_line(FND_FILE.LOG,' ');
123:
124: -- log messages with parameters

Line 121: fnd_file.put_line(FND_FILE.LOG,' ');

117: fnd_file.put_line(FND_FILE.LOG,'Session id : '||l_sessionid);
118: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
119: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);
120: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
121: fnd_file.put_line(FND_FILE.LOG,' ');
122: fnd_file.put_line(FND_FILE.LOG,' ');
123:
124: -- log messages with parameters
125: fnd_file.put_line(FND_FILE.LOG,' ********* Program Parameters **************** ');

Line 122: fnd_file.put_line(FND_FILE.LOG,' ');

118: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
119: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);
120: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
121: fnd_file.put_line(FND_FILE.LOG,' ');
122: fnd_file.put_line(FND_FILE.LOG,' ');
123:
124: -- log messages with parameters
125: fnd_file.put_line(FND_FILE.LOG,' ********* Program Parameters **************** ');
126: fnd_file.put_line(FND_FILE.LOG,'Default Price List : '||p_dflt_price_list_id);

Line 125: fnd_file.put_line(FND_FILE.LOG,' * Program Parameters ******** ');

121: fnd_file.put_line(FND_FILE.LOG,' ');
122: fnd_file.put_line(FND_FILE.LOG,' ');
123:
124: -- log messages with parameters
125: fnd_file.put_line(FND_FILE.LOG,' ********* Program Parameters **************** ');
126: fnd_file.put_line(FND_FILE.LOG,'Default Price List : '||p_dflt_price_list_id);
127: fnd_file.put_line(FND_FILE.LOG,'Category Code : '||p_category_code);
128: fnd_file.put_line(FND_FILE.LOG,'Enable QP Profile : '||p_enable_qp_profile);
129: fnd_file.put_line(FND_FILE.LOG,'Upgrade Status Rpt : '||p_rpt_upgrade_status);

Line 126: fnd_file.put_line(FND_FILE.LOG,'Default Price List : '||p_dflt_price_list_id);

122: fnd_file.put_line(FND_FILE.LOG,' ');
123:
124: -- log messages with parameters
125: fnd_file.put_line(FND_FILE.LOG,' ********* Program Parameters **************** ');
126: fnd_file.put_line(FND_FILE.LOG,'Default Price List : '||p_dflt_price_list_id);
127: fnd_file.put_line(FND_FILE.LOG,'Category Code : '||p_category_code);
128: fnd_file.put_line(FND_FILE.LOG,'Enable QP Profile : '||p_enable_qp_profile);
129: fnd_file.put_line(FND_FILE.LOG,'Upgrade Status Rpt : '||p_rpt_upgrade_status);
130: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');

Line 127: fnd_file.put_line(FND_FILE.LOG,'Category Code : '||p_category_code);

123:
124: -- log messages with parameters
125: fnd_file.put_line(FND_FILE.LOG,' ********* Program Parameters **************** ');
126: fnd_file.put_line(FND_FILE.LOG,'Default Price List : '||p_dflt_price_list_id);
127: fnd_file.put_line(FND_FILE.LOG,'Category Code : '||p_category_code);
128: fnd_file.put_line(FND_FILE.LOG,'Enable QP Profile : '||p_enable_qp_profile);
129: fnd_file.put_line(FND_FILE.LOG,'Upgrade Status Rpt : '||p_rpt_upgrade_status);
130: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
131: fnd_file.put_line(FND_FILE.LOG,' ');

Line 128: fnd_file.put_line(FND_FILE.LOG,'Enable QP Profile : '||p_enable_qp_profile);

124: -- log messages with parameters
125: fnd_file.put_line(FND_FILE.LOG,' ********* Program Parameters **************** ');
126: fnd_file.put_line(FND_FILE.LOG,'Default Price List : '||p_dflt_price_list_id);
127: fnd_file.put_line(FND_FILE.LOG,'Category Code : '||p_category_code);
128: fnd_file.put_line(FND_FILE.LOG,'Enable QP Profile : '||p_enable_qp_profile);
129: fnd_file.put_line(FND_FILE.LOG,'Upgrade Status Rpt : '||p_rpt_upgrade_status);
130: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
131: fnd_file.put_line(FND_FILE.LOG,' ');
132: fnd_file.put_line(FND_FILE.LOG,' ');

Line 129: fnd_file.put_line(FND_FILE.LOG,'Upgrade Status Rpt : '||p_rpt_upgrade_status);

125: fnd_file.put_line(FND_FILE.LOG,' ********* Program Parameters **************** ');
126: fnd_file.put_line(FND_FILE.LOG,'Default Price List : '||p_dflt_price_list_id);
127: fnd_file.put_line(FND_FILE.LOG,'Category Code : '||p_category_code);
128: fnd_file.put_line(FND_FILE.LOG,'Enable QP Profile : '||p_enable_qp_profile);
129: fnd_file.put_line(FND_FILE.LOG,'Upgrade Status Rpt : '||p_rpt_upgrade_status);
130: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
131: fnd_file.put_line(FND_FILE.LOG,' ');
132: fnd_file.put_line(FND_FILE.LOG,' ');
133:

Line 130: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');

126: fnd_file.put_line(FND_FILE.LOG,'Default Price List : '||p_dflt_price_list_id);
127: fnd_file.put_line(FND_FILE.LOG,'Category Code : '||p_category_code);
128: fnd_file.put_line(FND_FILE.LOG,'Enable QP Profile : '||p_enable_qp_profile);
129: fnd_file.put_line(FND_FILE.LOG,'Upgrade Status Rpt : '||p_rpt_upgrade_status);
130: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
131: fnd_file.put_line(FND_FILE.LOG,' ');
132: fnd_file.put_line(FND_FILE.LOG,' ');
133:
134: -- assign the global variable value for default price list

Line 131: fnd_file.put_line(FND_FILE.LOG,' ');

127: fnd_file.put_line(FND_FILE.LOG,'Category Code : '||p_category_code);
128: fnd_file.put_line(FND_FILE.LOG,'Enable QP Profile : '||p_enable_qp_profile);
129: fnd_file.put_line(FND_FILE.LOG,'Upgrade Status Rpt : '||p_rpt_upgrade_status);
130: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
131: fnd_file.put_line(FND_FILE.LOG,' ');
132: fnd_file.put_line(FND_FILE.LOG,' ');
133:
134: -- assign the global variable value for default price list
135: g_dflt_price_list_id := p_dflt_price_list_id;

Line 132: fnd_file.put_line(FND_FILE.LOG,' ');

128: fnd_file.put_line(FND_FILE.LOG,'Enable QP Profile : '||p_enable_qp_profile);
129: fnd_file.put_line(FND_FILE.LOG,'Upgrade Status Rpt : '||p_rpt_upgrade_status);
130: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
131: fnd_file.put_line(FND_FILE.LOG,' ');
132: fnd_file.put_line(FND_FILE.LOG,' ');
133:
134: -- assign the global variable value for default price list
135: g_dflt_price_list_id := p_dflt_price_list_id;
136:

Line 185: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');

181: END IF;
182:
183:
184:
185: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
186: fnd_file.put_line(FND_FILE.LOG,'Completed Concurrent Program. ');
187: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
188:
189: IF (l_debug = 'Y') THEN

Line 186: fnd_file.put_line(FND_FILE.LOG,'Completed Concurrent Program. ');

182:
183:
184:
185: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
186: fnd_file.put_line(FND_FILE.LOG,'Completed Concurrent Program. ');
187: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
188:
189: IF (l_debug = 'Y') THEN
190: okc_debug.Log('500: Calling Stop Trace and Leaving ',2);

Line 187: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');

183:
184:
185: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
186: fnd_file.put_line(FND_FILE.LOG,'Completed Concurrent Program. ');
187: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
188:
189: IF (l_debug = 'Y') THEN
190: okc_debug.Log('500: Calling Stop Trace and Leaving ',2);
191: okc_debug.Log('1000: Leaving ',2);

Line 196: fnd_file.put_line(FND_FILE.LOG,' ');

192: END IF;
193:
194: IF NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y' THEN
195: -- print debug information
196: fnd_file.put_line(FND_FILE.LOG,' ');
197: fnd_file.put_line(FND_FILE.LOG,' ');
198: fnd_file.put_line(FND_FILE.LOG,' ');
199: fnd_file.put_line(FND_FILE.LOG,' ');
200: fnd_file.put_line(FND_FILE.LOG,' ********** Debug Messages ********************* ');

Line 197: fnd_file.put_line(FND_FILE.LOG,' ');

193:
194: IF NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y' THEN
195: -- print debug information
196: fnd_file.put_line(FND_FILE.LOG,' ');
197: fnd_file.put_line(FND_FILE.LOG,' ');
198: fnd_file.put_line(FND_FILE.LOG,' ');
199: fnd_file.put_line(FND_FILE.LOG,' ');
200: fnd_file.put_line(FND_FILE.LOG,' ********** Debug Messages ********************* ');
201: fnd_file.put_line(FND_FILE.LOG,'For Debug Messages run the following SQL : ');

Line 198: fnd_file.put_line(FND_FILE.LOG,' ');

194: IF NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y' THEN
195: -- print debug information
196: fnd_file.put_line(FND_FILE.LOG,' ');
197: fnd_file.put_line(FND_FILE.LOG,' ');
198: fnd_file.put_line(FND_FILE.LOG,' ');
199: fnd_file.put_line(FND_FILE.LOG,' ');
200: fnd_file.put_line(FND_FILE.LOG,' ********** Debug Messages ********************* ');
201: fnd_file.put_line(FND_FILE.LOG,'For Debug Messages run the following SQL : ');
202: fnd_file.put_line(FND_FILE.LOG,'SELECT * FROM fnd_log_messages WHERE user_id = '||fnd_global.user_id||

Line 199: fnd_file.put_line(FND_FILE.LOG,' ');

195: -- print debug information
196: fnd_file.put_line(FND_FILE.LOG,' ');
197: fnd_file.put_line(FND_FILE.LOG,' ');
198: fnd_file.put_line(FND_FILE.LOG,' ');
199: fnd_file.put_line(FND_FILE.LOG,' ');
200: fnd_file.put_line(FND_FILE.LOG,' ********** Debug Messages ********************* ');
201: fnd_file.put_line(FND_FILE.LOG,'For Debug Messages run the following SQL : ');
202: fnd_file.put_line(FND_FILE.LOG,'SELECT * FROM fnd_log_messages WHERE user_id = '||fnd_global.user_id||
203: ' AND session_id = '||l_sessionid||' ORDER BY log_sequence; ');

Line 200: fnd_file.put_line(FND_FILE.LOG,' Debug Messages *********** ');

196: fnd_file.put_line(FND_FILE.LOG,' ');
197: fnd_file.put_line(FND_FILE.LOG,' ');
198: fnd_file.put_line(FND_FILE.LOG,' ');
199: fnd_file.put_line(FND_FILE.LOG,' ');
200: fnd_file.put_line(FND_FILE.LOG,' ********** Debug Messages ********************* ');
201: fnd_file.put_line(FND_FILE.LOG,'For Debug Messages run the following SQL : ');
202: fnd_file.put_line(FND_FILE.LOG,'SELECT * FROM fnd_log_messages WHERE user_id = '||fnd_global.user_id||
203: ' AND session_id = '||l_sessionid||' ORDER BY log_sequence; ');
204: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

Line 201: fnd_file.put_line(FND_FILE.LOG,'For Debug Messages run the following SQL : ');

197: fnd_file.put_line(FND_FILE.LOG,' ');
198: fnd_file.put_line(FND_FILE.LOG,' ');
199: fnd_file.put_line(FND_FILE.LOG,' ');
200: fnd_file.put_line(FND_FILE.LOG,' ********** Debug Messages ********************* ');
201: fnd_file.put_line(FND_FILE.LOG,'For Debug Messages run the following SQL : ');
202: fnd_file.put_line(FND_FILE.LOG,'SELECT * FROM fnd_log_messages WHERE user_id = '||fnd_global.user_id||
203: ' AND session_id = '||l_sessionid||' ORDER BY log_sequence; ');
204: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
205: fnd_file.put_line(FND_FILE.LOG,' ');

Line 202: fnd_file.put_line(FND_FILE.LOG,'SELECT * FROM fnd_log_messages WHERE user_id = '||fnd_global.user_id||

198: fnd_file.put_line(FND_FILE.LOG,' ');
199: fnd_file.put_line(FND_FILE.LOG,' ');
200: fnd_file.put_line(FND_FILE.LOG,' ********** Debug Messages ********************* ');
201: fnd_file.put_line(FND_FILE.LOG,'For Debug Messages run the following SQL : ');
202: fnd_file.put_line(FND_FILE.LOG,'SELECT * FROM fnd_log_messages WHERE user_id = '||fnd_global.user_id||
203: ' AND session_id = '||l_sessionid||' ORDER BY log_sequence; ');
204: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
205: fnd_file.put_line(FND_FILE.LOG,' ');
206: fnd_file.put_line(FND_FILE.LOG,' ');

Line 204: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

200: fnd_file.put_line(FND_FILE.LOG,' ********** Debug Messages ********************* ');
201: fnd_file.put_line(FND_FILE.LOG,'For Debug Messages run the following SQL : ');
202: fnd_file.put_line(FND_FILE.LOG,'SELECT * FROM fnd_log_messages WHERE user_id = '||fnd_global.user_id||
203: ' AND session_id = '||l_sessionid||' ORDER BY log_sequence; ');
204: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
205: fnd_file.put_line(FND_FILE.LOG,' ');
206: fnd_file.put_line(FND_FILE.LOG,' ');
207: -- stop trace mode
208: okc_util.stop_trace;

Line 205: fnd_file.put_line(FND_FILE.LOG,' ');

201: fnd_file.put_line(FND_FILE.LOG,'For Debug Messages run the following SQL : ');
202: fnd_file.put_line(FND_FILE.LOG,'SELECT * FROM fnd_log_messages WHERE user_id = '||fnd_global.user_id||
203: ' AND session_id = '||l_sessionid||' ORDER BY log_sequence; ');
204: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
205: fnd_file.put_line(FND_FILE.LOG,' ');
206: fnd_file.put_line(FND_FILE.LOG,' ');
207: -- stop trace mode
208: okc_util.stop_trace;
209: END IF;

Line 206: fnd_file.put_line(FND_FILE.LOG,' ');

202: fnd_file.put_line(FND_FILE.LOG,'SELECT * FROM fnd_log_messages WHERE user_id = '||fnd_global.user_id||
203: ' AND session_id = '||l_sessionid||' ORDER BY log_sequence; ');
204: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
205: fnd_file.put_line(FND_FILE.LOG,' ');
206: fnd_file.put_line(FND_FILE.LOG,' ');
207: -- stop trace mode
208: okc_util.stop_trace;
209: END IF;
210:

Line 267: fnd_file.put_line(FND_FILE.LOG,' ');

263: okc_debug.Set_Indentation(l_proc);
264: okc_debug.Log('10: Entering ',2);
265: END IF;
266: /*
267: fnd_file.put_line(FND_FILE.LOG,' ');
268: fnd_file.put_line(FND_FILE.LOG,' ');
269: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
270: fnd_file.put_line(FND_FILE.LOG,' ins_summary_rec ');
271: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

Line 268: fnd_file.put_line(FND_FILE.LOG,' ');

264: okc_debug.Log('10: Entering ',2);
265: END IF;
266: /*
267: fnd_file.put_line(FND_FILE.LOG,' ');
268: fnd_file.put_line(FND_FILE.LOG,' ');
269: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
270: fnd_file.put_line(FND_FILE.LOG,' ins_summary_rec ');
271: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
272: fnd_file.put_line(FND_FILE.LOG,' ');

Line 269: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

265: END IF;
266: /*
267: fnd_file.put_line(FND_FILE.LOG,' ');
268: fnd_file.put_line(FND_FILE.LOG,' ');
269: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
270: fnd_file.put_line(FND_FILE.LOG,' ins_summary_rec ');
271: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
272: fnd_file.put_line(FND_FILE.LOG,' ');
273: fnd_file.put_line(FND_FILE.LOG,' ');

Line 270: fnd_file.put_line(FND_FILE.LOG,' ins_summary_rec ');

266: /*
267: fnd_file.put_line(FND_FILE.LOG,' ');
268: fnd_file.put_line(FND_FILE.LOG,' ');
269: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
270: fnd_file.put_line(FND_FILE.LOG,' ins_summary_rec ');
271: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
272: fnd_file.put_line(FND_FILE.LOG,' ');
273: fnd_file.put_line(FND_FILE.LOG,' ');
274: */

Line 271: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

267: fnd_file.put_line(FND_FILE.LOG,' ');
268: fnd_file.put_line(FND_FILE.LOG,' ');
269: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
270: fnd_file.put_line(FND_FILE.LOG,' ins_summary_rec ');
271: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
272: fnd_file.put_line(FND_FILE.LOG,' ');
273: fnd_file.put_line(FND_FILE.LOG,' ');
274: */
275:

Line 272: fnd_file.put_line(FND_FILE.LOG,' ');

268: fnd_file.put_line(FND_FILE.LOG,' ');
269: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
270: fnd_file.put_line(FND_FILE.LOG,' ins_summary_rec ');
271: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
272: fnd_file.put_line(FND_FILE.LOG,' ');
273: fnd_file.put_line(FND_FILE.LOG,' ');
274: */
275:
276: OPEN csr_summary_rec;

Line 273: fnd_file.put_line(FND_FILE.LOG,' ');

269: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
270: fnd_file.put_line(FND_FILE.LOG,' ins_summary_rec ');
271: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
272: fnd_file.put_line(FND_FILE.LOG,' ');
273: fnd_file.put_line(FND_FILE.LOG,' ');
274: */
275:
276: OPEN csr_summary_rec;
277: FETCH csr_summary_rec INTO l_qp_upgrade_rec;

Line 316: -- fnd_file.put_line(FND_FILE.LOG,'Inserted Summary Record');

312:
313: IF (l_debug = 'Y') THEN
314: okc_debug.Log('30: Inserted Summary Record ',2);
315: END IF;
316: -- fnd_file.put_line(FND_FILE.LOG,'Inserted Summary Record');
317:
318: ELSE
319: -- Summary Record found, don't insert
320: IF (l_debug = 'Y') THEN

Line 323: -- fnd_file.put_line(FND_FILE.LOG,'Summary Record Already Exits');

319: -- Summary Record found, don't insert
320: IF (l_debug = 'Y') THEN
321: okc_debug.Log('40: Summary Record FOUND, skipping insert ',2);
322: END IF;
323: -- fnd_file.put_line(FND_FILE.LOG,'Summary Record Already Exits');
324: END IF; -- record does not exist
325: CLOSE csr_summary_rec;
326:
327:

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

338: END IF;
339: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
340: fnd_message.set_token('ROUTINE',l_proc);
341: fnd_message.set_token('REASON',SQLERRM);
342: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
343: raise g_error_exception;
344: END ins_summary_rec;
345:
346:

Line 406: fnd_file.put_line(FND_FILE.LOG,' ');

402: okc_debug.Log('10: Entering ',2);
403: okc_debug.Log('15: Category Code : '||p_category_code ,2);
404: END IF;
405: /*
406: fnd_file.put_line(FND_FILE.LOG,' ');
407: fnd_file.put_line(FND_FILE.LOG,' ');
408: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
409: fnd_file.put_line(FND_FILE.LOG,' ins_category_rec ');
410: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

Line 407: fnd_file.put_line(FND_FILE.LOG,' ');

403: okc_debug.Log('15: Category Code : '||p_category_code ,2);
404: END IF;
405: /*
406: fnd_file.put_line(FND_FILE.LOG,' ');
407: fnd_file.put_line(FND_FILE.LOG,' ');
408: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
409: fnd_file.put_line(FND_FILE.LOG,' ins_category_rec ');
410: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
411: fnd_file.put_line(FND_FILE.LOG,' ');

Line 408: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

404: END IF;
405: /*
406: fnd_file.put_line(FND_FILE.LOG,' ');
407: fnd_file.put_line(FND_FILE.LOG,' ');
408: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
409: fnd_file.put_line(FND_FILE.LOG,' ins_category_rec ');
410: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
411: fnd_file.put_line(FND_FILE.LOG,' ');
412: fnd_file.put_line(FND_FILE.LOG,' ');

Line 409: fnd_file.put_line(FND_FILE.LOG,' ins_category_rec ');

405: /*
406: fnd_file.put_line(FND_FILE.LOG,' ');
407: fnd_file.put_line(FND_FILE.LOG,' ');
408: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
409: fnd_file.put_line(FND_FILE.LOG,' ins_category_rec ');
410: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
411: fnd_file.put_line(FND_FILE.LOG,' ');
412: fnd_file.put_line(FND_FILE.LOG,' ');
413: */

Line 410: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

406: fnd_file.put_line(FND_FILE.LOG,' ');
407: fnd_file.put_line(FND_FILE.LOG,' ');
408: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
409: fnd_file.put_line(FND_FILE.LOG,' ins_category_rec ');
410: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
411: fnd_file.put_line(FND_FILE.LOG,' ');
412: fnd_file.put_line(FND_FILE.LOG,' ');
413: */
414:

Line 411: fnd_file.put_line(FND_FILE.LOG,' ');

407: fnd_file.put_line(FND_FILE.LOG,' ');
408: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
409: fnd_file.put_line(FND_FILE.LOG,' ins_category_rec ');
410: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
411: fnd_file.put_line(FND_FILE.LOG,' ');
412: fnd_file.put_line(FND_FILE.LOG,' ');
413: */
414:
415: OPEN csr_category_rec;

Line 412: fnd_file.put_line(FND_FILE.LOG,' ');

408: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
409: fnd_file.put_line(FND_FILE.LOG,' ins_category_rec ');
410: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
411: fnd_file.put_line(FND_FILE.LOG,' ');
412: fnd_file.put_line(FND_FILE.LOG,' ');
413: */
414:
415: OPEN csr_category_rec;
416: FETCH csr_category_rec INTO l_qp_upgrade_rec;

Line 463: -- fnd_file.put_line(FND_FILE.LOG,'Starting Upgrade For Category : '||p_category_code);

459:
460: -- populate the global variable with this cat_code it is processing
461: g_category_code := p_category_code ;
462:
463: -- fnd_file.put_line(FND_FILE.LOG,'Starting Upgrade For Category : '||p_category_code);
464:
465: -- call upgrade for this category
466: start_category_upgrade
467: (

Line 485: fnd_file.put_line(FND_FILE.LOG,'Completed Upgrade For Category : '||p_category_code);

481: );
482: IF (l_debug = 'Y') THEN
483: okc_debug.set_trace_off;
484: END IF;
485: fnd_file.put_line(FND_FILE.LOG,'Completed Upgrade For Category : '||p_category_code);
486:
487: ELSE
488: -- Category Record found, don't insert
489:

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

501: okc_debug.Log('50: Skipping as category is already Upgraded : '||p_category_code,2);
502: END IF;
503: fnd_message.set_name('OKC','OKC_CATEGORY_UPGRADED');
504: fnd_message.set_token('CATEGORY',p_category_code);
505: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
506:
507: ELSIF l_qp_upgrade_rec.completion_flag = 'N' THEN
508: /*
509: Case 2 : completion_flag = 'N'

Line 530: -- fnd_file.put_line(FND_FILE.LOG,'3: Starting Upgrade For Category : '||p_category_code);

526: -- populate the global variable with this cat_code it is processing
527: g_category_code := p_category_code ;
528:
529:
530: -- fnd_file.put_line(FND_FILE.LOG,'3: Starting Upgrade For Category : '||p_category_code);
531:
532: -- 3. Call the upgrade of K for this category.
533: start_category_upgrade
534: (

Line 553: fnd_file.put_line(FND_FILE.LOG,':Completed Upgrade For Category : '||p_category_code);

549: );
550: IF (l_debug = 'Y') THEN
551: okc_debug.set_trace_off;
552: END IF;
553: fnd_file.put_line(FND_FILE.LOG,':Completed Upgrade For Category : '||p_category_code);
554:
555: ELSE
556: /*
557: Case 3 : completion_flag = 'P'

Line 566: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

562: IF (l_debug = 'Y') THEN
563: okc_debug.Log('80: Another conc pgm IN PROGRESS for : '||p_category_code,2);
564: okc_debug.Log('100: Skipping Category : '||p_category_code,2);
565: END IF;
566: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
567: fnd_message.set_name('OKC','OKC_CATEGORY_UPG_PROGESS');
568: fnd_message.set_token('CATEGORY',p_category_code);
569: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
570: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

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

565: END IF;
566: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
567: fnd_message.set_name('OKC','OKC_CATEGORY_UPG_PROGESS');
568: fnd_message.set_token('CATEGORY',p_category_code);
569: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
570: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
571:
572: END IF; -- completion_flag
573:

Line 570: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

566: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
567: fnd_message.set_name('OKC','OKC_CATEGORY_UPG_PROGESS');
568: fnd_message.set_token('CATEGORY',p_category_code);
569: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
570: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
571:
572: END IF; -- completion_flag
573:
574: END IF; -- record does not exist

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

588: END IF;
589: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
590: fnd_message.set_token('ROUTINE',l_proc);
591: fnd_message.set_token('REASON',SQLERRM);
592: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
593: raise g_error_exception;
594: END ins_category_rec;
595:
596:

Line 685: fnd_file.put_line(FND_FILE.LOG,' ');

681: okc_debug.Set_Indentation(l_proc);
682: okc_debug.Log('10: Entering ',2);
683: END IF;
684: /*
685: fnd_file.put_line(FND_FILE.LOG,' ');
686: fnd_file.put_line(FND_FILE.LOG,' ');
687: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
688: fnd_file.put_line(FND_FILE.LOG,' start_category_upgrade ');
689: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

Line 686: fnd_file.put_line(FND_FILE.LOG,' ');

682: okc_debug.Log('10: Entering ',2);
683: END IF;
684: /*
685: fnd_file.put_line(FND_FILE.LOG,' ');
686: fnd_file.put_line(FND_FILE.LOG,' ');
687: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
688: fnd_file.put_line(FND_FILE.LOG,' start_category_upgrade ');
689: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
690: fnd_file.put_line(FND_FILE.LOG,' ');

Line 687: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

683: END IF;
684: /*
685: fnd_file.put_line(FND_FILE.LOG,' ');
686: fnd_file.put_line(FND_FILE.LOG,' ');
687: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
688: fnd_file.put_line(FND_FILE.LOG,' start_category_upgrade ');
689: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
690: fnd_file.put_line(FND_FILE.LOG,' ');
691: fnd_file.put_line(FND_FILE.LOG,' ');

Line 688: fnd_file.put_line(FND_FILE.LOG,' start_category_upgrade ');

684: /*
685: fnd_file.put_line(FND_FILE.LOG,' ');
686: fnd_file.put_line(FND_FILE.LOG,' ');
687: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
688: fnd_file.put_line(FND_FILE.LOG,' start_category_upgrade ');
689: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
690: fnd_file.put_line(FND_FILE.LOG,' ');
691: fnd_file.put_line(FND_FILE.LOG,' ');
692: */

Line 689: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

685: fnd_file.put_line(FND_FILE.LOG,' ');
686: fnd_file.put_line(FND_FILE.LOG,' ');
687: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
688: fnd_file.put_line(FND_FILE.LOG,' start_category_upgrade ');
689: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
690: fnd_file.put_line(FND_FILE.LOG,' ');
691: fnd_file.put_line(FND_FILE.LOG,' ');
692: */
693:

Line 690: fnd_file.put_line(FND_FILE.LOG,' ');

686: fnd_file.put_line(FND_FILE.LOG,' ');
687: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
688: fnd_file.put_line(FND_FILE.LOG,' start_category_upgrade ');
689: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
690: fnd_file.put_line(FND_FILE.LOG,' ');
691: fnd_file.put_line(FND_FILE.LOG,' ');
692: */
693:
694: --for all the contracts selected, rollup list prices and get pricelists for lines

Line 691: fnd_file.put_line(FND_FILE.LOG,' ');

687: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
688: fnd_file.put_line(FND_FILE.LOG,' start_category_upgrade ');
689: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
690: fnd_file.put_line(FND_FILE.LOG,' ');
691: fnd_file.put_line(FND_FILE.LOG,' ');
692: */
693:
694: --for all the contracts selected, rollup list prices and get pricelists for lines
695: FOR chr_rec IN chr_cursor LOOP --#1

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

1074: END IF;
1075: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
1076: fnd_message.set_token('ROUTINE',l_proc);
1077: fnd_message.set_token('REASON',SQLERRM);
1078: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1079: raise g_error_exception;
1080: END start_category_upgrade;
1081:
1082:

Line 1123: fnd_file.put_line(FND_FILE.LOG,'Processed Contract : '||p_contract_number||

1119: okc_debug.Log('70: Default Price List Id : '||g_k_price_list_id,2);
1120: END IF;
1121:
1122: /*
1123: fnd_file.put_line(FND_FILE.LOG,'Processed Contract : '||p_contract_number||
1124: ' '|| p_contract_number_modifier||' '||p_chr_id);
1125: */
1126:
1127: -- insert

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

1172: END IF;
1173: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
1174: fnd_message.set_token('ROUTINE',l_proc);
1175: fnd_message.set_token('REASON',SQLERRM);
1176: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1177: raise g_error_exception;
1178: END ins_contract_rec;
1179:
1180:

Line 1228: fnd_file.put_line(FND_FILE.LOG,' ');

1224: okc_debug.Set_Indentation(l_proc);
1225: okc_debug.Log('10: Entering ',2);
1226: END IF;
1227: /*
1228: fnd_file.put_line(FND_FILE.LOG,' ');
1229: fnd_file.put_line(FND_FILE.LOG,' ');
1230: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1231: fnd_file.put_line(FND_FILE.LOG,' call_qp_upgrade ');
1232: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

Line 1229: fnd_file.put_line(FND_FILE.LOG,' ');

1225: okc_debug.Log('10: Entering ',2);
1226: END IF;
1227: /*
1228: fnd_file.put_line(FND_FILE.LOG,' ');
1229: fnd_file.put_line(FND_FILE.LOG,' ');
1230: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1231: fnd_file.put_line(FND_FILE.LOG,' call_qp_upgrade ');
1232: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1233: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1230: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

1226: END IF;
1227: /*
1228: fnd_file.put_line(FND_FILE.LOG,' ');
1229: fnd_file.put_line(FND_FILE.LOG,' ');
1230: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1231: fnd_file.put_line(FND_FILE.LOG,' call_qp_upgrade ');
1232: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1233: fnd_file.put_line(FND_FILE.LOG,' ');
1234: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1231: fnd_file.put_line(FND_FILE.LOG,' call_qp_upgrade ');

1227: /*
1228: fnd_file.put_line(FND_FILE.LOG,' ');
1229: fnd_file.put_line(FND_FILE.LOG,' ');
1230: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1231: fnd_file.put_line(FND_FILE.LOG,' call_qp_upgrade ');
1232: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1233: fnd_file.put_line(FND_FILE.LOG,' ');
1234: fnd_file.put_line(FND_FILE.LOG,' ');
1235: */

Line 1232: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

1228: fnd_file.put_line(FND_FILE.LOG,' ');
1229: fnd_file.put_line(FND_FILE.LOG,' ');
1230: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1231: fnd_file.put_line(FND_FILE.LOG,' call_qp_upgrade ');
1232: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1233: fnd_file.put_line(FND_FILE.LOG,' ');
1234: fnd_file.put_line(FND_FILE.LOG,' ');
1235: */
1236:

Line 1233: fnd_file.put_line(FND_FILE.LOG,' ');

1229: fnd_file.put_line(FND_FILE.LOG,' ');
1230: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1231: fnd_file.put_line(FND_FILE.LOG,' call_qp_upgrade ');
1232: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1233: fnd_file.put_line(FND_FILE.LOG,' ');
1234: fnd_file.put_line(FND_FILE.LOG,' ');
1235: */
1236:
1237: IF (l_debug = 'Y') THEN

Line 1234: fnd_file.put_line(FND_FILE.LOG,' ');

1230: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1231: fnd_file.put_line(FND_FILE.LOG,' call_qp_upgrade ');
1232: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1233: fnd_file.put_line(FND_FILE.LOG,' ');
1234: fnd_file.put_line(FND_FILE.LOG,' ');
1235: */
1236:
1237: IF (l_debug = 'Y') THEN
1238: okc_debug.Log('20: p_category_code : '||p_category_code,2);

Line 1274: fnd_file.put_line(FND_FILE.LOG,' ');

1270: ELSE -- csr_summary_rec FOUND, upgrade already done abort
1271: IF (l_debug = 'Y') THEN
1272: okc_debug.Log('500: Aborting as the Upgrade is already Done ... ',2);
1273: END IF;
1274: fnd_file.put_line(FND_FILE.LOG,' ');
1275: fnd_file.put_line(FND_FILE.LOG,' ');
1276: fnd_message.set_name('OKC','OKC_QP_ALREADY_DONE');
1277: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1278: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1275: fnd_file.put_line(FND_FILE.LOG,' ');

1271: IF (l_debug = 'Y') THEN
1272: okc_debug.Log('500: Aborting as the Upgrade is already Done ... ',2);
1273: END IF;
1274: fnd_file.put_line(FND_FILE.LOG,' ');
1275: fnd_file.put_line(FND_FILE.LOG,' ');
1276: fnd_message.set_name('OKC','OKC_QP_ALREADY_DONE');
1277: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1278: fnd_file.put_line(FND_FILE.LOG,' ');
1279: fnd_file.put_line(FND_FILE.LOG,' ');

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

1273: END IF;
1274: fnd_file.put_line(FND_FILE.LOG,' ');
1275: fnd_file.put_line(FND_FILE.LOG,' ');
1276: fnd_message.set_name('OKC','OKC_QP_ALREADY_DONE');
1277: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1278: fnd_file.put_line(FND_FILE.LOG,' ');
1279: fnd_file.put_line(FND_FILE.LOG,' ');
1280: END IF;
1281:

Line 1278: fnd_file.put_line(FND_FILE.LOG,' ');

1274: fnd_file.put_line(FND_FILE.LOG,' ');
1275: fnd_file.put_line(FND_FILE.LOG,' ');
1276: fnd_message.set_name('OKC','OKC_QP_ALREADY_DONE');
1277: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1278: fnd_file.put_line(FND_FILE.LOG,' ');
1279: fnd_file.put_line(FND_FILE.LOG,' ');
1280: END IF;
1281:
1282:

Line 1279: fnd_file.put_line(FND_FILE.LOG,' ');

1275: fnd_file.put_line(FND_FILE.LOG,' ');
1276: fnd_message.set_name('OKC','OKC_QP_ALREADY_DONE');
1277: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1278: fnd_file.put_line(FND_FILE.LOG,' ');
1279: fnd_file.put_line(FND_FILE.LOG,' ');
1280: END IF;
1281:
1282:
1283: IF (l_debug = 'Y') THEN

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

1293: END IF;
1294: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
1295: fnd_message.set_token('ROUTINE',l_proc);
1296: fnd_message.set_token('REASON',SQLERRM);
1297: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1298: raise g_error_exception;
1299: END call_qp_upgrade;
1300:
1301:

Line 1339: fnd_file.put_line(FND_FILE.LOG,' ');

1335: okc_debug.Log('10: Entering ',2);
1336: END IF;
1337:
1338: /*
1339: fnd_file.put_line(FND_FILE.LOG,' ');
1340: fnd_file.put_line(FND_FILE.LOG,' ');
1341: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1342: fnd_file.put_line(FND_FILE.LOG,' upd_category_rec ');
1343: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

Line 1340: fnd_file.put_line(FND_FILE.LOG,' ');

1336: END IF;
1337:
1338: /*
1339: fnd_file.put_line(FND_FILE.LOG,' ');
1340: fnd_file.put_line(FND_FILE.LOG,' ');
1341: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1342: fnd_file.put_line(FND_FILE.LOG,' upd_category_rec ');
1343: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1344: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1341: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

1337:
1338: /*
1339: fnd_file.put_line(FND_FILE.LOG,' ');
1340: fnd_file.put_line(FND_FILE.LOG,' ');
1341: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1342: fnd_file.put_line(FND_FILE.LOG,' upd_category_rec ');
1343: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1344: fnd_file.put_line(FND_FILE.LOG,' ');
1345: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1342: fnd_file.put_line(FND_FILE.LOG,' upd_category_rec ');

1338: /*
1339: fnd_file.put_line(FND_FILE.LOG,' ');
1340: fnd_file.put_line(FND_FILE.LOG,' ');
1341: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1342: fnd_file.put_line(FND_FILE.LOG,' upd_category_rec ');
1343: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1344: fnd_file.put_line(FND_FILE.LOG,' ');
1345: fnd_file.put_line(FND_FILE.LOG,' ');
1346: */

Line 1343: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

1339: fnd_file.put_line(FND_FILE.LOG,' ');
1340: fnd_file.put_line(FND_FILE.LOG,' ');
1341: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1342: fnd_file.put_line(FND_FILE.LOG,' upd_category_rec ');
1343: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1344: fnd_file.put_line(FND_FILE.LOG,' ');
1345: fnd_file.put_line(FND_FILE.LOG,' ');
1346: */
1347:

Line 1344: fnd_file.put_line(FND_FILE.LOG,' ');

1340: fnd_file.put_line(FND_FILE.LOG,' ');
1341: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1342: fnd_file.put_line(FND_FILE.LOG,' upd_category_rec ');
1343: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1344: fnd_file.put_line(FND_FILE.LOG,' ');
1345: fnd_file.put_line(FND_FILE.LOG,' ');
1346: */
1347:
1348: OPEN csr_category_rec;

Line 1345: fnd_file.put_line(FND_FILE.LOG,' ');

1341: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1342: fnd_file.put_line(FND_FILE.LOG,' upd_category_rec ');
1343: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1344: fnd_file.put_line(FND_FILE.LOG,' ');
1345: fnd_file.put_line(FND_FILE.LOG,' ');
1346: */
1347:
1348: OPEN csr_category_rec;
1349: LOOP

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

1382: END IF;
1383: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
1384: fnd_message.set_token('ROUTINE',l_proc);
1385: fnd_message.set_token('REASON',SQLERRM);
1386: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1387: raise g_error_exception;
1388: END upd_category_rec;
1389:
1390:

Line 1439: fnd_file.put_line(FND_FILE.LOG,' ');

1435: okc_debug.Log('10: Entering ',2);
1436: END IF;
1437:
1438: /*
1439: fnd_file.put_line(FND_FILE.LOG,' ');
1440: fnd_file.put_line(FND_FILE.LOG,' ');
1441: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1442: fnd_file.put_line(FND_FILE.LOG,' upd_summary_rec ');
1443: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

Line 1440: fnd_file.put_line(FND_FILE.LOG,' ');

1436: END IF;
1437:
1438: /*
1439: fnd_file.put_line(FND_FILE.LOG,' ');
1440: fnd_file.put_line(FND_FILE.LOG,' ');
1441: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1442: fnd_file.put_line(FND_FILE.LOG,' upd_summary_rec ');
1443: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1444: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1441: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

1437:
1438: /*
1439: fnd_file.put_line(FND_FILE.LOG,' ');
1440: fnd_file.put_line(FND_FILE.LOG,' ');
1441: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1442: fnd_file.put_line(FND_FILE.LOG,' upd_summary_rec ');
1443: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1444: fnd_file.put_line(FND_FILE.LOG,' ');
1445: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1442: fnd_file.put_line(FND_FILE.LOG,' upd_summary_rec ');

1438: /*
1439: fnd_file.put_line(FND_FILE.LOG,' ');
1440: fnd_file.put_line(FND_FILE.LOG,' ');
1441: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1442: fnd_file.put_line(FND_FILE.LOG,' upd_summary_rec ');
1443: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1444: fnd_file.put_line(FND_FILE.LOG,' ');
1445: fnd_file.put_line(FND_FILE.LOG,' ');
1446: */

Line 1443: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

1439: fnd_file.put_line(FND_FILE.LOG,' ');
1440: fnd_file.put_line(FND_FILE.LOG,' ');
1441: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1442: fnd_file.put_line(FND_FILE.LOG,' upd_summary_rec ');
1443: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1444: fnd_file.put_line(FND_FILE.LOG,' ');
1445: fnd_file.put_line(FND_FILE.LOG,' ');
1446: */
1447:

Line 1444: fnd_file.put_line(FND_FILE.LOG,' ');

1440: fnd_file.put_line(FND_FILE.LOG,' ');
1441: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1442: fnd_file.put_line(FND_FILE.LOG,' upd_summary_rec ');
1443: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1444: fnd_file.put_line(FND_FILE.LOG,' ');
1445: fnd_file.put_line(FND_FILE.LOG,' ');
1446: */
1447:
1448: OPEN csr_total_categories;

Line 1445: fnd_file.put_line(FND_FILE.LOG,' ');

1441: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1442: fnd_file.put_line(FND_FILE.LOG,' upd_summary_rec ');
1443: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1444: fnd_file.put_line(FND_FILE.LOG,' ');
1445: fnd_file.put_line(FND_FILE.LOG,' ');
1446: */
1447:
1448: OPEN csr_total_categories;
1449: FETCH csr_total_categories INTO l_total_categories;

Line 1455: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

1451:
1452: IF (l_debug = 'Y') THEN
1453: okc_debug.Log('50: Total Categories : '||l_total_categories,2);
1454: END IF;
1455: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1456: fnd_message.set_name('OKC','OKC_TOT_CONTRACT_CATS');
1457: fnd_message.set_token('TOTCATS',l_total_categories);
1458: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1459:

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

1454: END IF;
1455: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1456: fnd_message.set_name('OKC','OKC_TOT_CONTRACT_CATS');
1457: fnd_message.set_token('TOTCATS',l_total_categories);
1458: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1459:
1460: OPEN csr_categories_done;
1461: FETCH csr_categories_done INTO l_categories_done;
1462: CLOSE csr_categories_done;

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

1465: okc_debug.Log('100: Categories Upgraded : '||l_categories_done,2);
1466: END IF;
1467: fnd_message.set_name('OKC','OKC_TOT_CATEGORIES_UPG');
1468: fnd_message.set_token('TOTUPG',l_categories_done);
1469: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1470: fnd_file.put_line(FND_FILE.LOG,' ');
1471: fnd_file.put_line(FND_FILE.LOG,' ');
1472: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1473:

Line 1470: fnd_file.put_line(FND_FILE.LOG,' ');

1466: END IF;
1467: fnd_message.set_name('OKC','OKC_TOT_CATEGORIES_UPG');
1468: fnd_message.set_token('TOTUPG',l_categories_done);
1469: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1470: fnd_file.put_line(FND_FILE.LOG,' ');
1471: fnd_file.put_line(FND_FILE.LOG,' ');
1472: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1473:
1474: IF NVL(l_total_categories,0) <> NVL(l_categories_done,0) THEN

Line 1471: fnd_file.put_line(FND_FILE.LOG,' ');

1467: fnd_message.set_name('OKC','OKC_TOT_CATEGORIES_UPG');
1468: fnd_message.set_token('TOTUPG',l_categories_done);
1469: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1470: fnd_file.put_line(FND_FILE.LOG,' ');
1471: fnd_file.put_line(FND_FILE.LOG,' ');
1472: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1473:
1474: IF NVL(l_total_categories,0) <> NVL(l_categories_done,0) THEN
1475: -- cannot enable profile as all categories are not processed

Line 1472: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

1468: fnd_message.set_token('TOTUPG',l_categories_done);
1469: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1470: fnd_file.put_line(FND_FILE.LOG,' ');
1471: fnd_file.put_line(FND_FILE.LOG,' ');
1472: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1473:
1474: IF NVL(l_total_categories,0) <> NVL(l_categories_done,0) THEN
1475: -- cannot enable profile as all categories are not processed
1476: IF (l_debug = 'Y') THEN

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

1476: IF (l_debug = 'Y') THEN
1477: okc_debug.Log('200: cannot enable profile as all categories are not processed ',2);
1478: END IF;
1479: fnd_message.set_name('OKC','OKC_QP_PROFILE_FAIL');
1480: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1481: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1482: fnd_file.put_line(FND_FILE.LOG,' ');
1483: fnd_file.put_line(FND_FILE.LOG,' ');
1484: ELSE

Line 1481: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

1477: okc_debug.Log('200: cannot enable profile as all categories are not processed ',2);
1478: END IF;
1479: fnd_message.set_name('OKC','OKC_QP_PROFILE_FAIL');
1480: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1481: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1482: fnd_file.put_line(FND_FILE.LOG,' ');
1483: fnd_file.put_line(FND_FILE.LOG,' ');
1484: ELSE
1485: -- update the SUMMARY Record

Line 1482: fnd_file.put_line(FND_FILE.LOG,' ');

1478: END IF;
1479: fnd_message.set_name('OKC','OKC_QP_PROFILE_FAIL');
1480: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1481: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1482: fnd_file.put_line(FND_FILE.LOG,' ');
1483: fnd_file.put_line(FND_FILE.LOG,' ');
1484: ELSE
1485: -- update the SUMMARY Record
1486: OPEN csr_summary_rec;

Line 1483: fnd_file.put_line(FND_FILE.LOG,' ');

1479: fnd_message.set_name('OKC','OKC_QP_PROFILE_FAIL');
1480: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1481: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1482: fnd_file.put_line(FND_FILE.LOG,' ');
1483: fnd_file.put_line(FND_FILE.LOG,' ');
1484: ELSE
1485: -- update the SUMMARY Record
1486: OPEN csr_summary_rec;
1487: IF (l_debug = 'Y') THEN

Line 1526: fnd_file.put_line(FND_FILE.LOG,' ');

1522: commit;
1523: IF (l_debug = 'Y') THEN
1524: okc_debug.Log('500: OKC_ADVANCED_PRICING Successfully Set to Y',2);
1525: END IF;
1526: fnd_file.put_line(FND_FILE.LOG,' ');
1527: fnd_file.put_line(FND_FILE.LOG,' ');
1528: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1529: fnd_message.set_name('OKC','OKC_QP_PROFILE_SUCCESS');
1530: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

Line 1527: fnd_file.put_line(FND_FILE.LOG,' ');

1523: IF (l_debug = 'Y') THEN
1524: okc_debug.Log('500: OKC_ADVANCED_PRICING Successfully Set to Y',2);
1525: END IF;
1526: fnd_file.put_line(FND_FILE.LOG,' ');
1527: fnd_file.put_line(FND_FILE.LOG,' ');
1528: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1529: fnd_message.set_name('OKC','OKC_QP_PROFILE_SUCCESS');
1530: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1531: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

Line 1528: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

1524: okc_debug.Log('500: OKC_ADVANCED_PRICING Successfully Set to Y',2);
1525: END IF;
1526: fnd_file.put_line(FND_FILE.LOG,' ');
1527: fnd_file.put_line(FND_FILE.LOG,' ');
1528: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1529: fnd_message.set_name('OKC','OKC_QP_PROFILE_SUCCESS');
1530: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1531: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1532: fnd_file.put_line(FND_FILE.LOG,' ');

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

1526: fnd_file.put_line(FND_FILE.LOG,' ');
1527: fnd_file.put_line(FND_FILE.LOG,' ');
1528: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1529: fnd_message.set_name('OKC','OKC_QP_PROFILE_SUCCESS');
1530: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1531: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1532: fnd_file.put_line(FND_FILE.LOG,' ');
1533: fnd_file.put_line(FND_FILE.LOG,' ');
1534: ELSE

Line 1531: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

1527: fnd_file.put_line(FND_FILE.LOG,' ');
1528: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1529: fnd_message.set_name('OKC','OKC_QP_PROFILE_SUCCESS');
1530: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1531: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1532: fnd_file.put_line(FND_FILE.LOG,' ');
1533: fnd_file.put_line(FND_FILE.LOG,' ');
1534: ELSE
1535: -- give error here

Line 1532: fnd_file.put_line(FND_FILE.LOG,' ');

1528: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1529: fnd_message.set_name('OKC','OKC_QP_PROFILE_SUCCESS');
1530: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1531: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1532: fnd_file.put_line(FND_FILE.LOG,' ');
1533: fnd_file.put_line(FND_FILE.LOG,' ');
1534: ELSE
1535: -- give error here
1536: IF (l_debug = 'Y') THEN

Line 1533: fnd_file.put_line(FND_FILE.LOG,' ');

1529: fnd_message.set_name('OKC','OKC_QP_PROFILE_SUCCESS');
1530: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1531: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1532: fnd_file.put_line(FND_FILE.LOG,' ');
1533: fnd_file.put_line(FND_FILE.LOG,' ');
1534: ELSE
1535: -- give error here
1536: IF (l_debug = 'Y') THEN
1537: okc_debug.Log('600: Error Setting OKC_ADVANCED_PRICING to Y');

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

1538: END IF;
1539: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
1540: fnd_message.set_token('ROUTINE',l_proc);
1541: fnd_message.set_token('REASON',SQLERRM);
1542: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1543: APP_EXCEPTION.RAISE_EXCEPTION;
1544: END IF; -- for setting profile
1545:
1546:

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

1564: END IF;
1565: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
1566: fnd_message.set_token('ROUTINE',l_proc);
1567: fnd_message.set_token('REASON',SQLERRM);
1568: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1569: raise;
1570: END upd_summary_rec;
1571:
1572:

Line 1595: fnd_file.put_line(FND_FILE.LOG,' ');

1591: okc_debug.Log('10: Entering ',2);
1592: END IF;
1593:
1594: /*
1595: fnd_file.put_line(FND_FILE.LOG,' ');
1596: fnd_file.put_line(FND_FILE.LOG,' ');
1597: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1598: fnd_file.put_line(FND_FILE.LOG,' process_report ');
1599: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

Line 1596: fnd_file.put_line(FND_FILE.LOG,' ');

1592: END IF;
1593:
1594: /*
1595: fnd_file.put_line(FND_FILE.LOG,' ');
1596: fnd_file.put_line(FND_FILE.LOG,' ');
1597: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1598: fnd_file.put_line(FND_FILE.LOG,' process_report ');
1599: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1600: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1597: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

1593:
1594: /*
1595: fnd_file.put_line(FND_FILE.LOG,' ');
1596: fnd_file.put_line(FND_FILE.LOG,' ');
1597: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1598: fnd_file.put_line(FND_FILE.LOG,' process_report ');
1599: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1600: fnd_file.put_line(FND_FILE.LOG,' ');
1601: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1598: fnd_file.put_line(FND_FILE.LOG,' process_report ');

1594: /*
1595: fnd_file.put_line(FND_FILE.LOG,' ');
1596: fnd_file.put_line(FND_FILE.LOG,' ');
1597: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1598: fnd_file.put_line(FND_FILE.LOG,' process_report ');
1599: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1600: fnd_file.put_line(FND_FILE.LOG,' ');
1601: fnd_file.put_line(FND_FILE.LOG,' ');
1602: */

Line 1599: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

1595: fnd_file.put_line(FND_FILE.LOG,' ');
1596: fnd_file.put_line(FND_FILE.LOG,' ');
1597: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1598: fnd_file.put_line(FND_FILE.LOG,' process_report ');
1599: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1600: fnd_file.put_line(FND_FILE.LOG,' ');
1601: fnd_file.put_line(FND_FILE.LOG,' ');
1602: */
1603:

Line 1600: fnd_file.put_line(FND_FILE.LOG,' ');

1596: fnd_file.put_line(FND_FILE.LOG,' ');
1597: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1598: fnd_file.put_line(FND_FILE.LOG,' process_report ');
1599: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1600: fnd_file.put_line(FND_FILE.LOG,' ');
1601: fnd_file.put_line(FND_FILE.LOG,' ');
1602: */
1603:
1604: IF (l_debug = 'Y') THEN

Line 1601: fnd_file.put_line(FND_FILE.LOG,' ');

1597: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1598: fnd_file.put_line(FND_FILE.LOG,' process_report ');
1599: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1600: fnd_file.put_line(FND_FILE.LOG,' ');
1601: fnd_file.put_line(FND_FILE.LOG,' ');
1602: */
1603:
1604: IF (l_debug = 'Y') THEN
1605: okc_debug.Log('50: Calling upgrade_status_rpt ',2);

Line 1607: fnd_file.put_line(FND_FILE.LOG,'Processing Upgrade Status report');

1603:
1604: IF (l_debug = 'Y') THEN
1605: okc_debug.Log('50: Calling upgrade_status_rpt ',2);
1606: END IF;
1607: fnd_file.put_line(FND_FILE.LOG,'Processing Upgrade Status report');
1608: upgrade_status_rpt;
1609:
1610: IF (l_debug = 'Y') THEN
1611: okc_debug.Log('1000: Leaving ',2);

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

1620: END IF;
1621: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
1622: fnd_message.set_token('ROUTINE',l_proc);
1623: fnd_message.set_token('REASON',SQLERRM);
1624: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1625: raise;
1626: END process_report;
1627:
1628:

Line 1702: fnd_file.put_line(FND_FILE.LOG,' ');

1698: okc_debug.Log('10: Entering ',2);
1699: END IF;
1700:
1701: /*
1702: fnd_file.put_line(FND_FILE.LOG,' ');
1703: fnd_file.put_line(FND_FILE.LOG,' ');
1704: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1705: fnd_file.put_line(FND_FILE.LOG,' upgrade_status_rpt ');
1706: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

Line 1703: fnd_file.put_line(FND_FILE.LOG,' ');

1699: END IF;
1700:
1701: /*
1702: fnd_file.put_line(FND_FILE.LOG,' ');
1703: fnd_file.put_line(FND_FILE.LOG,' ');
1704: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1705: fnd_file.put_line(FND_FILE.LOG,' upgrade_status_rpt ');
1706: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1707: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1704: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

1700:
1701: /*
1702: fnd_file.put_line(FND_FILE.LOG,' ');
1703: fnd_file.put_line(FND_FILE.LOG,' ');
1704: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1705: fnd_file.put_line(FND_FILE.LOG,' upgrade_status_rpt ');
1706: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1707: fnd_file.put_line(FND_FILE.LOG,' ');
1708: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1705: fnd_file.put_line(FND_FILE.LOG,' upgrade_status_rpt ');

1701: /*
1702: fnd_file.put_line(FND_FILE.LOG,' ');
1703: fnd_file.put_line(FND_FILE.LOG,' ');
1704: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1705: fnd_file.put_line(FND_FILE.LOG,' upgrade_status_rpt ');
1706: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1707: fnd_file.put_line(FND_FILE.LOG,' ');
1708: fnd_file.put_line(FND_FILE.LOG,' ');
1709: */

Line 1706: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');

1702: fnd_file.put_line(FND_FILE.LOG,' ');
1703: fnd_file.put_line(FND_FILE.LOG,' ');
1704: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1705: fnd_file.put_line(FND_FILE.LOG,' upgrade_status_rpt ');
1706: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1707: fnd_file.put_line(FND_FILE.LOG,' ');
1708: fnd_file.put_line(FND_FILE.LOG,' ');
1709: */
1710:

Line 1707: fnd_file.put_line(FND_FILE.LOG,' ');

1703: fnd_file.put_line(FND_FILE.LOG,' ');
1704: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1705: fnd_file.put_line(FND_FILE.LOG,' upgrade_status_rpt ');
1706: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1707: fnd_file.put_line(FND_FILE.LOG,' ');
1708: fnd_file.put_line(FND_FILE.LOG,' ');
1709: */
1710:
1711: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);

Line 1708: fnd_file.put_line(FND_FILE.LOG,' ');

1704: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1705: fnd_file.put_line(FND_FILE.LOG,' upgrade_status_rpt ');
1706: fnd_file.put_line(FND_FILE.LOG,' ================================================ ');
1707: fnd_file.put_line(FND_FILE.LOG,' ');
1708: fnd_file.put_line(FND_FILE.LOG,' ');
1709: */
1710:
1711: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1712: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

Line 1711: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);

1707: fnd_file.put_line(FND_FILE.LOG,' ');
1708: fnd_file.put_line(FND_FILE.LOG,' ');
1709: */
1710:
1711: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1712: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1713: fnd_file.put_line(FND_FILE.OUTPUT,' UPGRADE STATUS REPORT ');
1714: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1715: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);

Line 1712: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1708: fnd_file.put_line(FND_FILE.LOG,' ');
1709: */
1710:
1711: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1712: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1713: fnd_file.put_line(FND_FILE.OUTPUT,' UPGRADE STATUS REPORT ');
1714: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1715: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1716: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

Line 1713: fnd_file.put_line(FND_FILE.OUTPUT,' UPGRADE STATUS REPORT ');

1709: */
1710:
1711: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1712: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1713: fnd_file.put_line(FND_FILE.OUTPUT,' UPGRADE STATUS REPORT ');
1714: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1715: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1716: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1717:

Line 1714: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1710:
1711: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1712: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1713: fnd_file.put_line(FND_FILE.OUTPUT,' UPGRADE STATUS REPORT ');
1714: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1715: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1716: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1717:
1718: -- Successful Categories

Line 1715: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);

1711: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1712: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1713: fnd_file.put_line(FND_FILE.OUTPUT,' UPGRADE STATUS REPORT ');
1714: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1715: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1716: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1717:
1718: -- Successful Categories
1719:

Line 1716: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1712: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1713: fnd_file.put_line(FND_FILE.OUTPUT,' UPGRADE STATUS REPORT ');
1714: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1715: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1716: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1717:
1718: -- Successful Categories
1719:
1720: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);

Line 1720: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);

1716: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1717:
1718: -- Successful Categories
1719:
1720: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1721: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title1);
1722: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1723: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1724: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);

Line 1721: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title1);

1717:
1718: -- Successful Categories
1719:
1720: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1721: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title1);
1722: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1723: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1724: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1725: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_comp_header);

Line 1722: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);

1718: -- Successful Categories
1719:
1720: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1721: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title1);
1722: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1723: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1724: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1725: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_comp_header);
1726: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);

Line 1723: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1719:
1720: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1721: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title1);
1722: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1723: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1724: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1725: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_comp_header);
1726: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1727:

Line 1724: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);

1720: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1721: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title1);
1722: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1723: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1724: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1725: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_comp_header);
1726: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1727:
1728: OPEN category_compeleted_csr;

Line 1725: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_comp_header);

1721: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title1);
1722: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1723: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1724: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1725: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_comp_header);
1726: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1727:
1728: OPEN category_compeleted_csr;
1729: LOOP

Line 1726: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);

1722: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1723: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1724: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1725: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_comp_header);
1726: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1727:
1728: OPEN category_compeleted_csr;
1729: LOOP
1730: FETCH category_compeleted_csr INTO l_category_name, l_start_date, l_end_date;

Line 1732: fnd_file.put_line(FND_FILE.OUTPUT, l_category_name);

1728: OPEN category_compeleted_csr;
1729: LOOP
1730: FETCH category_compeleted_csr INTO l_category_name, l_start_date, l_end_date;
1731: EXIT WHEN category_compeleted_csr%NOTFOUND;
1732: fnd_file.put_line(FND_FILE.OUTPUT, l_category_name);
1733: END LOOP;
1734: CLOSE category_compeleted_csr;
1735:
1736: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

Line 1736: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1732: fnd_file.put_line(FND_FILE.OUTPUT, l_category_name);
1733: END LOOP;
1734: CLOSE category_compeleted_csr;
1735:
1736: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1737: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1738: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1739:
1740: -- blank lines

Line 1737: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1733: END LOOP;
1734: CLOSE category_compeleted_csr;
1735:
1736: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1737: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1738: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1739:
1740: -- blank lines
1741: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

Line 1738: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);

1734: CLOSE category_compeleted_csr;
1735:
1736: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1737: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1738: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1739:
1740: -- blank lines
1741: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1742: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

Line 1741: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1737: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1738: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1739:
1740: -- blank lines
1741: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1742: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1743: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1744: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1745: -- end blank lines

Line 1742: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1738: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1739:
1740: -- blank lines
1741: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1742: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1743: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1744: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1745: -- end blank lines
1746:

Line 1743: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1739:
1740: -- blank lines
1741: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1742: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1743: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1744: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1745: -- end blank lines
1746:
1747: -- Incomplete Categories

Line 1744: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1740: -- blank lines
1741: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1742: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1743: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1744: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1745: -- end blank lines
1746:
1747: -- Incomplete Categories
1748:

Line 1749: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);

1745: -- end blank lines
1746:
1747: -- Incomplete Categories
1748:
1749: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1750: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title2);
1751: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1752: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1753: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

Line 1750: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title2);

1746:
1747: -- Incomplete Categories
1748:
1749: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1750: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title2);
1751: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1752: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1753: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1754: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);

Line 1751: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);

1747: -- Incomplete Categories
1748:
1749: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1750: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title2);
1751: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1752: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1753: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1754: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1755: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_incomp_header);

Line 1752: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1748:
1749: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1750: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title2);
1751: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1752: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1753: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1754: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1755: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_incomp_header);
1756: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);

Line 1753: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1749: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1750: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title2);
1751: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1752: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1753: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1754: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1755: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_incomp_header);
1756: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1757:

Line 1754: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);

1750: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title2);
1751: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1752: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1753: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1754: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1755: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_incomp_header);
1756: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1757:
1758: OPEN category_incompeleted_csr;

Line 1755: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_incomp_header);

1751: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1752: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1753: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1754: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1755: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_incomp_header);
1756: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1757:
1758: OPEN category_incompeleted_csr;
1759: LOOP

Line 1756: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);

1752: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1753: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1754: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1755: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_incomp_header);
1756: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1757:
1758: OPEN category_incompeleted_csr;
1759: LOOP
1760: FETCH category_incompeleted_csr INTO l_category_name;

Line 1762: fnd_file.put_line(FND_FILE.OUTPUT, l_category_name);

1758: OPEN category_incompeleted_csr;
1759: LOOP
1760: FETCH category_incompeleted_csr INTO l_category_name;
1761: EXIT WHEN category_incompeleted_csr%NOTFOUND;
1762: fnd_file.put_line(FND_FILE.OUTPUT, l_category_name);
1763: END LOOP;
1764: CLOSE category_incompeleted_csr;
1765:
1766: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

Line 1766: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1762: fnd_file.put_line(FND_FILE.OUTPUT, l_category_name);
1763: END LOOP;
1764: CLOSE category_incompeleted_csr;
1765:
1766: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1767: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1768: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1769:
1770: -- blank lines

Line 1767: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1763: END LOOP;
1764: CLOSE category_incompeleted_csr;
1765:
1766: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1767: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1768: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1769:
1770: -- blank lines
1771: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

Line 1768: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);

1764: CLOSE category_incompeleted_csr;
1765:
1766: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1767: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1768: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1769:
1770: -- blank lines
1771: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1772: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

Line 1771: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1767: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1768: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1769:
1770: -- blank lines
1771: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1772: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1773: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1774: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1775: -- end blank lines

Line 1772: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1768: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1769:
1770: -- blank lines
1771: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1772: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1773: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1774: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1775: -- end blank lines
1776:

Line 1773: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1769:
1770: -- blank lines
1771: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1772: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1773: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1774: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1775: -- end blank lines
1776:
1777: -- Categories not upgraded

Line 1774: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1770: -- blank lines
1771: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1772: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1773: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1774: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1775: -- end blank lines
1776:
1777: -- Categories not upgraded
1778: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);

Line 1778: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);

1774: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1775: -- end blank lines
1776:
1777: -- Categories not upgraded
1778: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1779: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title3);
1780: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1781: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1782: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

Line 1779: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title3);

1775: -- end blank lines
1776:
1777: -- Categories not upgraded
1778: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1779: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title3);
1780: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1781: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1782: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1783: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);

Line 1780: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);

1776:
1777: -- Categories not upgraded
1778: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1779: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title3);
1780: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1781: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1782: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1783: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1784: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_incomp_header);

Line 1781: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1777: -- Categories not upgraded
1778: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1779: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title3);
1780: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1781: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1782: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1783: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1784: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_incomp_header);
1785: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);

Line 1782: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1778: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1779: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title3);
1780: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1781: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1782: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1783: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1784: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_incomp_header);
1785: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1786:

Line 1783: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);

1779: fnd_file.put_line(FND_FILE.OUTPUT,l_rpt_title3);
1780: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1781: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1782: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1783: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1784: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_incomp_header);
1785: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1786:
1787: OPEN category_pending_csr;

Line 1784: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_incomp_header);

1780: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1781: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1782: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1783: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1784: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_incomp_header);
1785: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1786:
1787: OPEN category_pending_csr;
1788: LOOP

Line 1785: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);

1781: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1782: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1783: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1784: fnd_file.put_line(FND_FILE.OUTPUT,l_cat_incomp_header);
1785: fnd_file.put_line(FND_FILE.OUTPUT,l_dash_line);
1786:
1787: OPEN category_pending_csr;
1788: LOOP
1789: FETCH category_pending_csr INTO l_category_name;

Line 1791: fnd_file.put_line(FND_FILE.OUTPUT, l_category_name);

1787: OPEN category_pending_csr;
1788: LOOP
1789: FETCH category_pending_csr INTO l_category_name;
1790: EXIT WHEN category_pending_csr%NOTFOUND;
1791: fnd_file.put_line(FND_FILE.OUTPUT, l_category_name);
1792: END LOOP;
1793: CLOSE category_pending_csr;
1794:
1795: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

Line 1795: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1791: fnd_file.put_line(FND_FILE.OUTPUT, l_category_name);
1792: END LOOP;
1793: CLOSE category_pending_csr;
1794:
1795: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1796: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1797: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1798:
1799: -- blank lines

Line 1796: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1792: END LOOP;
1793: CLOSE category_pending_csr;
1794:
1795: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1796: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1797: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1798:
1799: -- blank lines
1800: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

Line 1797: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);

1793: CLOSE category_pending_csr;
1794:
1795: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1796: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1797: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1798:
1799: -- blank lines
1800: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1801: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

Line 1800: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1796: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1797: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1798:
1799: -- blank lines
1800: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1801: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1802: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1803: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1804: -- end blank lines

Line 1801: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1797: fnd_file.put_line(FND_FILE.OUTPUT,l_star_line);
1798:
1799: -- blank lines
1800: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1801: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1802: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1803: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1804: -- end blank lines
1805:

Line 1802: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1798:
1799: -- blank lines
1800: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1801: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1802: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1803: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1804: -- end blank lines
1805:
1806: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);

Line 1803: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1799: -- blank lines
1800: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1801: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1802: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1803: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1804: -- end blank lines
1805:
1806: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1807: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

Line 1806: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);

1802: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1803: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1804: -- end blank lines
1805:
1806: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1807: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1808: fnd_file.put_line(FND_FILE.OUTPUT,' END UPGRADE STATUS REPORT ');
1809: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1810: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);

Line 1807: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1803: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1804: -- end blank lines
1805:
1806: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1807: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1808: fnd_file.put_line(FND_FILE.OUTPUT,' END UPGRADE STATUS REPORT ');
1809: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1810: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1811: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

Line 1808: fnd_file.put_line(FND_FILE.OUTPUT,' END UPGRADE STATUS REPORT ');

1804: -- end blank lines
1805:
1806: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1807: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1808: fnd_file.put_line(FND_FILE.OUTPUT,' END UPGRADE STATUS REPORT ');
1809: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1810: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1811: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1812:

Line 1809: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1805:
1806: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1807: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1808: fnd_file.put_line(FND_FILE.OUTPUT,' END UPGRADE STATUS REPORT ');
1809: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1810: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1811: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1812:
1813:

Line 1810: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);

1806: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1807: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1808: fnd_file.put_line(FND_FILE.OUTPUT,' END UPGRADE STATUS REPORT ');
1809: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1810: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1811: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1812:
1813:
1814:

Line 1811: fnd_file.put_line(FND_FILE.OUTPUT,l_space);

1807: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1808: fnd_file.put_line(FND_FILE.OUTPUT,' END UPGRADE STATUS REPORT ');
1809: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1810: fnd_file.put_line(FND_FILE.OUTPUT,l_equl_line);
1811: fnd_file.put_line(FND_FILE.OUTPUT,l_space);
1812:
1813:
1814:
1815: IF (l_debug = 'Y') THEN

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

1825: END IF;
1826: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
1827: fnd_message.set_token('ROUTINE',l_proc);
1828: fnd_message.set_token('REASON',SQLERRM);
1829: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1830: raise;
1831: END upgrade_status_rpt;
1832:
1833: /*----------------------------------------------------------------------------

Line 1868: fnd_file.put_line(FND_FILE.LOG,' ');

1864: -- upgrade already done, abort
1865: IF (l_debug = 'Y') THEN
1866: okc_debug.Log('200: Aborting as the Upgrade is already Done ... ',2);
1867: END IF;
1868: fnd_file.put_line(FND_FILE.LOG,' ');
1869: fnd_file.put_line(FND_FILE.LOG,' ');
1870: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1871: fnd_message.set_name('OKC','OKC_QP_ALREADY_DONE');
1872: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

Line 1869: fnd_file.put_line(FND_FILE.LOG,' ');

1865: IF (l_debug = 'Y') THEN
1866: okc_debug.Log('200: Aborting as the Upgrade is already Done ... ',2);
1867: END IF;
1868: fnd_file.put_line(FND_FILE.LOG,' ');
1869: fnd_file.put_line(FND_FILE.LOG,' ');
1870: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1871: fnd_message.set_name('OKC','OKC_QP_ALREADY_DONE');
1872: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1873: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

Line 1870: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

1866: okc_debug.Log('200: Aborting as the Upgrade is already Done ... ',2);
1867: END IF;
1868: fnd_file.put_line(FND_FILE.LOG,' ');
1869: fnd_file.put_line(FND_FILE.LOG,' ');
1870: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1871: fnd_message.set_name('OKC','OKC_QP_ALREADY_DONE');
1872: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1873: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1874: fnd_file.put_line(FND_FILE.LOG,' ');

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

1868: fnd_file.put_line(FND_FILE.LOG,' ');
1869: fnd_file.put_line(FND_FILE.LOG,' ');
1870: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1871: fnd_message.set_name('OKC','OKC_QP_ALREADY_DONE');
1872: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1873: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1874: fnd_file.put_line(FND_FILE.LOG,' ');
1875: fnd_file.put_line(FND_FILE.LOG,' ');
1876: END IF;

Line 1873: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

1869: fnd_file.put_line(FND_FILE.LOG,' ');
1870: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1871: fnd_message.set_name('OKC','OKC_QP_ALREADY_DONE');
1872: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1873: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1874: fnd_file.put_line(FND_FILE.LOG,' ');
1875: fnd_file.put_line(FND_FILE.LOG,' ');
1876: END IF;
1877:

Line 1874: fnd_file.put_line(FND_FILE.LOG,' ');

1870: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1871: fnd_message.set_name('OKC','OKC_QP_ALREADY_DONE');
1872: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1873: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1874: fnd_file.put_line(FND_FILE.LOG,' ');
1875: fnd_file.put_line(FND_FILE.LOG,' ');
1876: END IF;
1877:
1878: IF (l_debug = 'Y') THEN

Line 1875: fnd_file.put_line(FND_FILE.LOG,' ');

1871: fnd_message.set_name('OKC','OKC_QP_ALREADY_DONE');
1872: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1873: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
1874: fnd_file.put_line(FND_FILE.LOG,' ');
1875: fnd_file.put_line(FND_FILE.LOG,' ');
1876: END IF;
1877:
1878: IF (l_debug = 'Y') THEN
1879: okc_debug.Log('1000: Leaving ',2);

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

1890: END IF;
1891: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
1892: fnd_message.set_token('ROUTINE',l_proc);
1893: fnd_message.set_token('REASON',SQLERRM);
1894: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1895: RETURN l_prof_val;
1896: END check_qp_profile;
1897:
1898: /*----------------------------------------------------------------------------

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

1949: END IF;
1950: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
1951: fnd_message.set_token('ROUTINE',l_proc);
1952: fnd_message.set_token('REASON',SQLERRM);
1953: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
1954: RETURN NVL(l_estimated_amt,0);
1955: raise;
1956: END compute_estimated_amt;
1957:

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

2136: END IF;
2137: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
2138: fnd_message.set_token('ROUTINE',l_proc);
2139: fnd_message.set_token('REASON',SQLERRM);
2140: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
2141: raise;
2142: END create_manual_adjustment;
2143:
2144:

Line 2187: fnd_file.put_line(FND_FILE.LOG,' ');

2183: IF csr_list_lines%NOTFOUND THEN
2184: IF (l_debug = 'Y') THEN
2185: okc_debug.Log('100: Aborting as the Modifier OKC_QP_UPGRADE is not defined ',2);
2186: END IF;
2187: fnd_file.put_line(FND_FILE.LOG,' ');
2188: fnd_file.put_line(FND_FILE.LOG,' ');
2189: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
2190: fnd_message.set_name('OKC','OKC_MOD_NOT_DEFINED');
2191: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

Line 2188: fnd_file.put_line(FND_FILE.LOG,' ');

2184: IF (l_debug = 'Y') THEN
2185: okc_debug.Log('100: Aborting as the Modifier OKC_QP_UPGRADE is not defined ',2);
2186: END IF;
2187: fnd_file.put_line(FND_FILE.LOG,' ');
2188: fnd_file.put_line(FND_FILE.LOG,' ');
2189: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
2190: fnd_message.set_name('OKC','OKC_MOD_NOT_DEFINED');
2191: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
2192: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

Line 2189: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

2185: okc_debug.Log('100: Aborting as the Modifier OKC_QP_UPGRADE is not defined ',2);
2186: END IF;
2187: fnd_file.put_line(FND_FILE.LOG,' ');
2188: fnd_file.put_line(FND_FILE.LOG,' ');
2189: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
2190: fnd_message.set_name('OKC','OKC_MOD_NOT_DEFINED');
2191: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
2192: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
2193: fnd_file.put_line(FND_FILE.LOG,' ');

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

2187: fnd_file.put_line(FND_FILE.LOG,' ');
2188: fnd_file.put_line(FND_FILE.LOG,' ');
2189: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
2190: fnd_message.set_name('OKC','OKC_MOD_NOT_DEFINED');
2191: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
2192: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
2193: fnd_file.put_line(FND_FILE.LOG,' ');
2194: fnd_file.put_line(FND_FILE.LOG,' ');
2195: l_status := 'N';

Line 2192: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');

2188: fnd_file.put_line(FND_FILE.LOG,' ');
2189: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
2190: fnd_message.set_name('OKC','OKC_MOD_NOT_DEFINED');
2191: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
2192: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
2193: fnd_file.put_line(FND_FILE.LOG,' ');
2194: fnd_file.put_line(FND_FILE.LOG,' ');
2195: l_status := 'N';
2196: ELSE

Line 2193: fnd_file.put_line(FND_FILE.LOG,' ');

2189: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
2190: fnd_message.set_name('OKC','OKC_MOD_NOT_DEFINED');
2191: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
2192: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
2193: fnd_file.put_line(FND_FILE.LOG,' ');
2194: fnd_file.put_line(FND_FILE.LOG,' ');
2195: l_status := 'N';
2196: ELSE
2197: -- modifier is defined

Line 2194: fnd_file.put_line(FND_FILE.LOG,' ');

2190: fnd_message.set_name('OKC','OKC_MOD_NOT_DEFINED');
2191: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
2192: fnd_file.put_line(FND_FILE.LOG,' *********************************************** ');
2193: fnd_file.put_line(FND_FILE.LOG,' ');
2194: fnd_file.put_line(FND_FILE.LOG,' ');
2195: l_status := 'N';
2196: ELSE
2197: -- modifier is defined
2198: l_status := 'Y';

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

2216: END IF;
2217: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
2218: fnd_message.set_token('ROUTINE',l_proc);
2219: fnd_message.set_token('REASON',SQLERRM);
2220: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
2221: RETURN l_status;
2222: END check_modifier;
2223:
2224: /*----------------------------------------------------------------------------

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

2255: END IF;
2256: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
2257: fnd_message.set_token('ROUTINE',l_proc);
2258: fnd_message.set_token('REASON',SQLERRM);
2259: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
2260: RETURN l_id;
2261: END get_seq_id;
2262:
2263:

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

2306: END IF;
2307: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
2308: fnd_message.set_token('ROUTINE',l_proc);
2309: fnd_message.set_token('REASON',SQLERRM);
2310: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
2311: RETURN l_flag;
2312: END get_item_to_price_flag;
2313:
2314: