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_XPRT_IMPORT_PVT dependencies on FND_FILE

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

140: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
141: END IF;
142:
143: -- log file
144: fnd_file.put_line(FND_FILE.LOG,' ');
145: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
146: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
147: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
148:

Line 145: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

141: END IF;
142:
143: -- log file
144: fnd_file.put_line(FND_FILE.LOG,' ');
145: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
146: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
147: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
148:
149: /*

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

142:
143: -- log file
144: fnd_file.put_line(FND_FILE.LOG,' ');
145: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
146: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
147: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
148:
149: /*
150: Step 1: Update current request Id for all rules to be published

Line 147: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);

143: -- log file
144: fnd_file.put_line(FND_FILE.LOG,' ');
145: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
146: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
147: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
148:
149: /*
150: Step 1: Update current request Id for all rules to be published
151: */

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

149: /*
150: Step 1: Update current request Id for all rules to be published
151: */
152:
153: fnd_file.put_line(FND_FILE.LOG,' ');
154: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
155: fnd_file.put_line(FND_FILE.LOG,'Step 1: Updating request_id for rules to be published ');
156: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
157: fnd_file.put_line(FND_FILE.LOG,' ');

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

150: Step 1: Update current request Id for all rules to be published
151: */
152:
153: fnd_file.put_line(FND_FILE.LOG,' ');
154: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
155: fnd_file.put_line(FND_FILE.LOG,'Step 1: Updating request_id for rules to be published ');
156: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
157: fnd_file.put_line(FND_FILE.LOG,' ');
158:

Line 155: fnd_file.put_line(FND_FILE.LOG,'Step 1: Updating request_id for rules to be published ');

151: */
152:
153: fnd_file.put_line(FND_FILE.LOG,' ');
154: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
155: fnd_file.put_line(FND_FILE.LOG,'Step 1: Updating request_id for rules to be published ');
156: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
157: fnd_file.put_line(FND_FILE.LOG,' ');
158:
159: -- Update request_id for all Rules in Pending Publication for current org id

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

152:
153: fnd_file.put_line(FND_FILE.LOG,' ');
154: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
155: fnd_file.put_line(FND_FILE.LOG,'Step 1: Updating request_id for rules to be published ');
156: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
157: fnd_file.put_line(FND_FILE.LOG,' ');
158:
159: -- Update request_id for all Rules in Pending Publication for current org id
160: UPDATE okc_xprt_rule_hdrs_all

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

153: fnd_file.put_line(FND_FILE.LOG,' ');
154: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
155: fnd_file.put_line(FND_FILE.LOG,'Step 1: Updating request_id for rules to be published ');
156: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
157: fnd_file.put_line(FND_FILE.LOG,' ');
158:
159: -- Update request_id for all Rules in Pending Publication for current org id
160: UPDATE okc_xprt_rule_hdrs_all
161: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,

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

174:
175: -- Check If any rules are to be processed else exit
176: IF SQL%NOTFOUND THEN
177: -- exit as no rules to be processed
178: fnd_file.put_line(FND_FILE.LOG,' ');
179: fnd_file.put_line(FND_FILE.LOG,'No Rules to be processed ');
180: fnd_file.put_line(FND_FILE.LOG,' ');
181:
182: retcode := 0;

Line 179: fnd_file.put_line(FND_FILE.LOG,'No Rules to be processed ');

175: -- Check If any rules are to be processed else exit
176: IF SQL%NOTFOUND THEN
177: -- exit as no rules to be processed
178: fnd_file.put_line(FND_FILE.LOG,' ');
179: fnd_file.put_line(FND_FILE.LOG,'No Rules to be processed ');
180: fnd_file.put_line(FND_FILE.LOG,' ');
181:
182: retcode := 0;
183: errbuf := '';

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

176: IF SQL%NOTFOUND THEN
177: -- exit as no rules to be processed
178: fnd_file.put_line(FND_FILE.LOG,' ');
179: fnd_file.put_line(FND_FILE.LOG,'No Rules to be processed ');
180: fnd_file.put_line(FND_FILE.LOG,' ');
181:
182: retcode := 0;
183: errbuf := '';
184: RETURN;

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

191: /*
192: Step 1.1: Rules QA checks
193: */
194:
195: fnd_file.put_line(FND_FILE.LOG,' ');
196: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
197: fnd_file.put_line(FND_FILE.LOG,'Step 1.1: Rules QA Checks ');
198: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
199: fnd_file.put_line(FND_FILE.LOG,' ');

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

192: Step 1.1: Rules QA checks
193: */
194:
195: fnd_file.put_line(FND_FILE.LOG,' ');
196: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
197: fnd_file.put_line(FND_FILE.LOG,'Step 1.1: Rules QA Checks ');
198: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
199: fnd_file.put_line(FND_FILE.LOG,' ');
200:

Line 197: fnd_file.put_line(FND_FILE.LOG,'Step 1.1: Rules QA Checks ');

193: */
194:
195: fnd_file.put_line(FND_FILE.LOG,' ');
196: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
197: fnd_file.put_line(FND_FILE.LOG,'Step 1.1: Rules QA Checks ');
198: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
199: fnd_file.put_line(FND_FILE.LOG,' ');
200:
201: OKC_XPRT_UTIL_PVT.check_rules_validity

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

194:
195: fnd_file.put_line(FND_FILE.LOG,' ');
196: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
197: fnd_file.put_line(FND_FILE.LOG,'Step 1.1: Rules QA Checks ');
198: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
199: fnd_file.put_line(FND_FILE.LOG,' ');
200:
201: OKC_XPRT_UTIL_PVT.check_rules_validity
202: (

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

195: fnd_file.put_line(FND_FILE.LOG,' ');
196: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
197: fnd_file.put_line(FND_FILE.LOG,'Step 1.1: Rules QA Checks ');
198: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
199: fnd_file.put_line(FND_FILE.LOG,' ');
200:
201: OKC_XPRT_UTIL_PVT.check_rules_validity
202: (
203: p_qa_mode => 'PUBLISH',

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

208: x_msg_data => x_msg_data,
209: x_msg_count => x_msg_count
210: ) ;
211:
212: fnd_file.put_line(FND_FILE.LOG,' ');
213: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');
214: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
215: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);
216: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);

Line 213: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');

209: x_msg_count => x_msg_count
210: ) ;
211:
212: fnd_file.put_line(FND_FILE.LOG,' ');
213: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');
214: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
215: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);
216: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);
217: fnd_file.put_line(FND_FILE.LOG,' ');

Line 214: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

210: ) ;
211:
212: fnd_file.put_line(FND_FILE.LOG,' ');
213: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');
214: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
215: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);
216: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);
217: fnd_file.put_line(FND_FILE.LOG,' ');
218:

Line 215: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);

211:
212: fnd_file.put_line(FND_FILE.LOG,' ');
213: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');
214: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
215: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);
216: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);
217: fnd_file.put_line(FND_FILE.LOG,' ');
218:
219: --- If any errors happen abort API

Line 216: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);

212: fnd_file.put_line(FND_FILE.LOG,' ');
213: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');
214: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
215: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);
216: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);
217: fnd_file.put_line(FND_FILE.LOG,' ');
218:
219: --- If any errors happen abort API
220: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

213: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');
214: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
215: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);
216: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);
217: fnd_file.put_line(FND_FILE.LOG,' ');
218:
219: --- If any errors happen abort API
220: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

225:
226: -- Check If any rules had QA errors and abort
227: IF l_qa_status <> 'S' THEN
228: -- exit as no rules had QA errors
229: fnd_file.put_line(FND_FILE.LOG,' ');
230: fnd_file.put_line(FND_FILE.LOG,'Rules QA Check failed');
231: fnd_file.put_line(FND_FILE.LOG,' ');
232:
233:

Line 230: fnd_file.put_line(FND_FILE.LOG,'Rules QA Check failed');

226: -- Check If any rules had QA errors and abort
227: IF l_qa_status <> 'S' THEN
228: -- exit as no rules had QA errors
229: fnd_file.put_line(FND_FILE.LOG,' ');
230: fnd_file.put_line(FND_FILE.LOG,'Rules QA Check failed');
231: fnd_file.put_line(FND_FILE.LOG,' ');
232:
233:
234: -- Added for Bug 4103931

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

227: IF l_qa_status <> 'S' THEN
228: -- exit as no rules had QA errors
229: fnd_file.put_line(FND_FILE.LOG,' ');
230: fnd_file.put_line(FND_FILE.LOG,'Rules QA Check failed');
231: fnd_file.put_line(FND_FILE.LOG,' ');
232:
233:
234: -- Added for Bug 4103931
235: FOR csr_pub_rule_rec IN csr_pub_rule_list

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

257: /*
258: Step 2: Import Variable Model
259: */
260:
261: fnd_file.put_line(FND_FILE.LOG,' ');
262: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
263: fnd_file.put_line(FND_FILE.LOG,'Step 2: Importing Variable Model');
264: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
265: fnd_file.put_line(FND_FILE.LOG,' ');

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

258: Step 2: Import Variable Model
259: */
260:
261: fnd_file.put_line(FND_FILE.LOG,' ');
262: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
263: fnd_file.put_line(FND_FILE.LOG,'Step 2: Importing Variable Model');
264: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
265: fnd_file.put_line(FND_FILE.LOG,' ');
266:

Line 263: fnd_file.put_line(FND_FILE.LOG,'Step 2: Importing Variable Model');

259: */
260:
261: fnd_file.put_line(FND_FILE.LOG,' ');
262: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
263: fnd_file.put_line(FND_FILE.LOG,'Step 2: Importing Variable Model');
264: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
265: fnd_file.put_line(FND_FILE.LOG,' ');
266:
267: OKC_XPRT_IMPORT_VARIABLES_PVT.import_variables

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

260:
261: fnd_file.put_line(FND_FILE.LOG,' ');
262: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
263: fnd_file.put_line(FND_FILE.LOG,'Step 2: Importing Variable Model');
264: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
265: fnd_file.put_line(FND_FILE.LOG,' ');
266:
267: OKC_XPRT_IMPORT_VARIABLES_PVT.import_variables
268: (

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

261: fnd_file.put_line(FND_FILE.LOG,' ');
262: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
263: fnd_file.put_line(FND_FILE.LOG,'Step 2: Importing Variable Model');
264: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
265: fnd_file.put_line(FND_FILE.LOG,' ');
266:
267: OKC_XPRT_IMPORT_VARIABLES_PVT.import_variables
268: (
269: p_api_version => 1,

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

274: x_msg_data => x_msg_data,
275: x_msg_count => x_msg_count
276: ) ;
277:
278: fnd_file.put_line(FND_FILE.LOG,' ');
279: fnd_file.put_line(FND_FILE.LOG,'After Importing Variable Model');
280: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
281: fnd_file.put_line(FND_FILE.LOG,' ');
282:

Line 279: fnd_file.put_line(FND_FILE.LOG,'After Importing Variable Model');

275: x_msg_count => x_msg_count
276: ) ;
277:
278: fnd_file.put_line(FND_FILE.LOG,' ');
279: fnd_file.put_line(FND_FILE.LOG,'After Importing Variable Model');
280: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
281: fnd_file.put_line(FND_FILE.LOG,' ');
282:
283: --- If any errors happen abort API

Line 280: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

276: ) ;
277:
278: fnd_file.put_line(FND_FILE.LOG,' ');
279: fnd_file.put_line(FND_FILE.LOG,'After Importing Variable Model');
280: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
281: fnd_file.put_line(FND_FILE.LOG,' ');
282:
283: --- If any errors happen abort API
284: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

277:
278: fnd_file.put_line(FND_FILE.LOG,' ');
279: fnd_file.put_line(FND_FILE.LOG,'After Importing Variable Model');
280: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
281: fnd_file.put_line(FND_FILE.LOG,' ');
282:
283: --- If any errors happen abort API
284: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
285: -- Added for Bug 4757731

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

316: /*
317: Step 3: Import Clause Model
318: */
319:
320: fnd_file.put_line(FND_FILE.LOG,' ');
321: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
322: fnd_file.put_line(FND_FILE.LOG,'Step 3: Importing Clause Model');
323: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
324: fnd_file.put_line(FND_FILE.LOG,' ');

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

317: Step 3: Import Clause Model
318: */
319:
320: fnd_file.put_line(FND_FILE.LOG,' ');
321: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
322: fnd_file.put_line(FND_FILE.LOG,'Step 3: Importing Clause Model');
323: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
324: fnd_file.put_line(FND_FILE.LOG,' ');
325:

Line 322: fnd_file.put_line(FND_FILE.LOG,'Step 3: Importing Clause Model');

318: */
319:
320: fnd_file.put_line(FND_FILE.LOG,' ');
321: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
322: fnd_file.put_line(FND_FILE.LOG,'Step 3: Importing Clause Model');
323: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
324: fnd_file.put_line(FND_FILE.LOG,' ');
325:
326: OKC_XPRT_IMPORT_CLAUSES_PVT.import_clauses

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

319:
320: fnd_file.put_line(FND_FILE.LOG,' ');
321: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
322: fnd_file.put_line(FND_FILE.LOG,'Step 3: Importing Clause Model');
323: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
324: fnd_file.put_line(FND_FILE.LOG,' ');
325:
326: OKC_XPRT_IMPORT_CLAUSES_PVT.import_clauses
327: (

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

320: fnd_file.put_line(FND_FILE.LOG,' ');
321: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
322: fnd_file.put_line(FND_FILE.LOG,'Step 3: Importing Clause Model');
323: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
324: fnd_file.put_line(FND_FILE.LOG,' ');
325:
326: OKC_XPRT_IMPORT_CLAUSES_PVT.import_clauses
327: (
328: p_api_version => 1,

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

333: x_msg_data => x_msg_data,
334: x_msg_count => x_msg_count
335: ) ;
336:
337: fnd_file.put_line(FND_FILE.LOG,' ');
338: fnd_file.put_line(FND_FILE.LOG,'After Importing Clause Model');
339: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
340: fnd_file.put_line(FND_FILE.LOG,' ');
341:

Line 338: fnd_file.put_line(FND_FILE.LOG,'After Importing Clause Model');

334: x_msg_count => x_msg_count
335: ) ;
336:
337: fnd_file.put_line(FND_FILE.LOG,' ');
338: fnd_file.put_line(FND_FILE.LOG,'After Importing Clause Model');
339: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
340: fnd_file.put_line(FND_FILE.LOG,' ');
341:
342: --- If any errors happen abort API

Line 339: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

335: ) ;
336:
337: fnd_file.put_line(FND_FILE.LOG,' ');
338: fnd_file.put_line(FND_FILE.LOG,'After Importing Clause Model');
339: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
340: fnd_file.put_line(FND_FILE.LOG,' ');
341:
342: --- If any errors happen abort API
343: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

336:
337: fnd_file.put_line(FND_FILE.LOG,' ');
338: fnd_file.put_line(FND_FILE.LOG,'After Importing Clause Model');
339: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
340: fnd_file.put_line(FND_FILE.LOG,' ');
341:
342: --- If any errors happen abort API
343: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
344: -- Added for Bug 4757731

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

374: /*
375: Step 4: Import Template Model(s)
376: */
377:
378: fnd_file.put_line(FND_FILE.LOG,' ');
379: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
380: fnd_file.put_line(FND_FILE.LOG,'Step 4: Importing Template Models');
381: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
382: fnd_file.put_line(FND_FILE.LOG,' ');

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

375: Step 4: Import Template Model(s)
376: */
377:
378: fnd_file.put_line(FND_FILE.LOG,' ');
379: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
380: fnd_file.put_line(FND_FILE.LOG,'Step 4: Importing Template Models');
381: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
382: fnd_file.put_line(FND_FILE.LOG,' ');
383:

Line 380: fnd_file.put_line(FND_FILE.LOG,'Step 4: Importing Template Models');

376: */
377:
378: fnd_file.put_line(FND_FILE.LOG,' ');
379: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
380: fnd_file.put_line(FND_FILE.LOG,'Step 4: Importing Template Models');
381: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
382: fnd_file.put_line(FND_FILE.LOG,' ');
383:
384: OKC_XPRT_IMPORT_TEMPLATE_PVT.rebuild_tmpl_pub_disable

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

377:
378: fnd_file.put_line(FND_FILE.LOG,' ');
379: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
380: fnd_file.put_line(FND_FILE.LOG,'Step 4: Importing Template Models');
381: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
382: fnd_file.put_line(FND_FILE.LOG,' ');
383:
384: OKC_XPRT_IMPORT_TEMPLATE_PVT.rebuild_tmpl_pub_disable
385: (

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

378: fnd_file.put_line(FND_FILE.LOG,' ');
379: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
380: fnd_file.put_line(FND_FILE.LOG,'Step 4: Importing Template Models');
381: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
382: fnd_file.put_line(FND_FILE.LOG,' ');
383:
384: OKC_XPRT_IMPORT_TEMPLATE_PVT.rebuild_tmpl_pub_disable
385: (
386: x_return_status => x_return_status,

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

387: x_msg_data => x_msg_data,
388: x_msg_count => x_msg_count
389: ) ;
390:
391: fnd_file.put_line(FND_FILE.LOG,' ');
392: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Models');
393: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
394: fnd_file.put_line(FND_FILE.LOG,' ');
395:

Line 392: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Models');

388: x_msg_count => x_msg_count
389: ) ;
390:
391: fnd_file.put_line(FND_FILE.LOG,' ');
392: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Models');
393: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
394: fnd_file.put_line(FND_FILE.LOG,' ');
395:
396: --- If any errors happen abort API

Line 393: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

389: ) ;
390:
391: fnd_file.put_line(FND_FILE.LOG,' ');
392: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Models');
393: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
394: fnd_file.put_line(FND_FILE.LOG,' ');
395:
396: --- If any errors happen abort API
397: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

390:
391: fnd_file.put_line(FND_FILE.LOG,' ');
392: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Models');
393: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
394: fnd_file.put_line(FND_FILE.LOG,' ');
395:
396: --- If any errors happen abort API
397: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
398: -- Added for Bug 4757731

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

429: /*
430: Step 5: Populate cz_imp_rules
431: */
432:
433: fnd_file.put_line(FND_FILE.LOG,' ');
434: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
435: fnd_file.put_line(FND_FILE.LOG,'Step 5: Populating cz_imp_rules ');
436: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
437: fnd_file.put_line(FND_FILE.LOG,' ');

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

430: Step 5: Populate cz_imp_rules
431: */
432:
433: fnd_file.put_line(FND_FILE.LOG,' ');
434: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
435: fnd_file.put_line(FND_FILE.LOG,'Step 5: Populating cz_imp_rules ');
436: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
437: fnd_file.put_line(FND_FILE.LOG,' ');
438:

Line 435: fnd_file.put_line(FND_FILE.LOG,'Step 5: Populating cz_imp_rules ');

431: */
432:
433: fnd_file.put_line(FND_FILE.LOG,' ');
434: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
435: fnd_file.put_line(FND_FILE.LOG,'Step 5: Populating cz_imp_rules ');
436: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
437: fnd_file.put_line(FND_FILE.LOG,' ');
438:
439: OKC_XPRT_IMPORT_RULES_PVT.import_rules_publish

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

432:
433: fnd_file.put_line(FND_FILE.LOG,' ');
434: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
435: fnd_file.put_line(FND_FILE.LOG,'Step 5: Populating cz_imp_rules ');
436: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
437: fnd_file.put_line(FND_FILE.LOG,' ');
438:
439: OKC_XPRT_IMPORT_RULES_PVT.import_rules_publish
440: (

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

433: fnd_file.put_line(FND_FILE.LOG,' ');
434: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
435: fnd_file.put_line(FND_FILE.LOG,'Step 5: Populating cz_imp_rules ');
436: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
437: fnd_file.put_line(FND_FILE.LOG,' ');
438:
439: OKC_XPRT_IMPORT_RULES_PVT.import_rules_publish
440: (
441: x_run_id => G_RUN_ID,

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

443: x_msg_data => x_msg_data,
444: x_msg_count => x_msg_count
445: );
446:
447: fnd_file.put_line(FND_FILE.LOG,' ');
448: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
449: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
450: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
451: fnd_file.put_line(FND_FILE.LOG,' ');

Line 448: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');

444: x_msg_count => x_msg_count
445: );
446:
447: fnd_file.put_line(FND_FILE.LOG,' ');
448: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
449: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
450: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
451: fnd_file.put_line(FND_FILE.LOG,' ');
452:

Line 449: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

445: );
446:
447: fnd_file.put_line(FND_FILE.LOG,' ');
448: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
449: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
450: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
451: fnd_file.put_line(FND_FILE.LOG,' ');
452:
453: --- If any errors happen abort API

Line 450: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);

446:
447: fnd_file.put_line(FND_FILE.LOG,' ');
448: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
449: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
450: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
451: fnd_file.put_line(FND_FILE.LOG,' ');
452:
453: --- If any errors happen abort API
454: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

447: fnd_file.put_line(FND_FILE.LOG,' ');
448: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
449: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
450: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
451: fnd_file.put_line(FND_FILE.LOG,' ');
452:
453: --- If any errors happen abort API
454: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
455: -- Added for Bug 4757731

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

488: If there are no records in cz_imp_rules then there were no expert enabled templates
489: attached to the rule. Just change the status of the rule to ACTIVE
490: */
491:
492: fnd_file.put_line(FND_FILE.LOG,' ');
493: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
494: fnd_file.put_line(FND_FILE.LOG,'Step 5.1:Count Rules to be imported');
495: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
496: fnd_file.put_line(FND_FILE.LOG,' ');

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

489: attached to the rule. Just change the status of the rule to ACTIVE
490: */
491:
492: fnd_file.put_line(FND_FILE.LOG,' ');
493: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
494: fnd_file.put_line(FND_FILE.LOG,'Step 5.1:Count Rules to be imported');
495: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
496: fnd_file.put_line(FND_FILE.LOG,' ');
497:

Line 494: fnd_file.put_line(FND_FILE.LOG,'Step 5.1:Count Rules to be imported');

490: */
491:
492: fnd_file.put_line(FND_FILE.LOG,' ');
493: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
494: fnd_file.put_line(FND_FILE.LOG,'Step 5.1:Count Rules to be imported');
495: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
496: fnd_file.put_line(FND_FILE.LOG,' ');
497:
498: OPEN csr_cz_imp_rules_cnt;

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

491:
492: fnd_file.put_line(FND_FILE.LOG,' ');
493: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
494: fnd_file.put_line(FND_FILE.LOG,'Step 5.1:Count Rules to be imported');
495: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
496: fnd_file.put_line(FND_FILE.LOG,' ');
497:
498: OPEN csr_cz_imp_rules_cnt;
499: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;

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

492: fnd_file.put_line(FND_FILE.LOG,' ');
493: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
494: fnd_file.put_line(FND_FILE.LOG,'Step 5.1:Count Rules to be imported');
495: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
496: fnd_file.put_line(FND_FILE.LOG,' ');
497:
498: OPEN csr_cz_imp_rules_cnt;
499: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
500: CLOSE csr_cz_imp_rules_cnt;

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

498: OPEN csr_cz_imp_rules_cnt;
499: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
500: CLOSE csr_cz_imp_rules_cnt;
501:
502: fnd_file.put_line(FND_FILE.LOG,' ');
503: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);
504: fnd_file.put_line(FND_FILE.LOG,' ');
505:
506:

Line 503: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);

499: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
500: CLOSE csr_cz_imp_rules_cnt;
501:
502: fnd_file.put_line(FND_FILE.LOG,' ');
503: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);
504: fnd_file.put_line(FND_FILE.LOG,' ');
505:
506:
507: IF l_rules_cnt = 0 THEN

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

500: CLOSE csr_cz_imp_rules_cnt;
501:
502: fnd_file.put_line(FND_FILE.LOG,' ');
503: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);
504: fnd_file.put_line(FND_FILE.LOG,' ');
505:
506:
507: IF l_rules_cnt = 0 THEN
508:

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

513: x_msg_data => x_msg_data,
514: x_msg_count => x_msg_count
515: );
516:
517: fnd_file.put_line(FND_FILE.LOG,' ');
518: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl');
519: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
520: fnd_file.put_line(FND_FILE.LOG,' ');
521:

Line 518: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl');

514: x_msg_count => x_msg_count
515: );
516:
517: fnd_file.put_line(FND_FILE.LOG,' ');
518: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl');
519: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
520: fnd_file.put_line(FND_FILE.LOG,' ');
521:
522: --- If any errors happen abort API

Line 519: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

515: );
516:
517: fnd_file.put_line(FND_FILE.LOG,' ');
518: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl');
519: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
520: fnd_file.put_line(FND_FILE.LOG,' ');
521:
522: --- If any errors happen abort API
523: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

516:
517: fnd_file.put_line(FND_FILE.LOG,' ');
518: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl');
519: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
520: fnd_file.put_line(FND_FILE.LOG,' ');
521:
522: --- If any errors happen abort API
523: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
524: -- Added for Bug 4757731

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

550: -- Added for Bug 4757731
551: RAISE FND_API.G_EXC_ERROR;
552: END IF;
553:
554: fnd_file.put_line(FND_FILE.LOG,' ');
555: fnd_file.put_line(FND_FILE.LOG,'Rules has No expert template attached');
556: fnd_file.put_line(FND_FILE.LOG,' ');
557:
558: retcode := 0;

Line 555: fnd_file.put_line(FND_FILE.LOG,'Rules has No expert template attached');

551: RAISE FND_API.G_EXC_ERROR;
552: END IF;
553:
554: fnd_file.put_line(FND_FILE.LOG,' ');
555: fnd_file.put_line(FND_FILE.LOG,'Rules has No expert template attached');
556: fnd_file.put_line(FND_FILE.LOG,' ');
557:
558: retcode := 0;
559: errbuf := '';

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

552: END IF;
553:
554: fnd_file.put_line(FND_FILE.LOG,' ');
555: fnd_file.put_line(FND_FILE.LOG,'Rules has No expert template attached');
556: fnd_file.put_line(FND_FILE.LOG,' ');
557:
558: retcode := 0;
559: errbuf := '';
560: RETURN;

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

565: /*
566: Step 6: Insert Extension Rules
567: */
568:
569: fnd_file.put_line(FND_FILE.LOG,' ');
570: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
571: fnd_file.put_line(FND_FILE.LOG,'Step 6: Calling API to insert extension rule records');
572: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
573: fnd_file.put_line(FND_FILE.LOG,' ');

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

566: Step 6: Insert Extension Rules
567: */
568:
569: fnd_file.put_line(FND_FILE.LOG,' ');
570: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
571: fnd_file.put_line(FND_FILE.LOG,'Step 6: Calling API to insert extension rule records');
572: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
573: fnd_file.put_line(FND_FILE.LOG,' ');
574:

Line 571: fnd_file.put_line(FND_FILE.LOG,'Step 6: Calling API to insert extension rule records');

567: */
568:
569: fnd_file.put_line(FND_FILE.LOG,' ');
570: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
571: fnd_file.put_line(FND_FILE.LOG,'Step 6: Calling API to insert extension rule records');
572: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
573: fnd_file.put_line(FND_FILE.LOG,' ');
574:
575: OKC_XPRT_IMPORT_RULES_PVT.attach_extension_rule

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

568:
569: fnd_file.put_line(FND_FILE.LOG,' ');
570: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
571: fnd_file.put_line(FND_FILE.LOG,'Step 6: Calling API to insert extension rule records');
572: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
573: fnd_file.put_line(FND_FILE.LOG,' ');
574:
575: OKC_XPRT_IMPORT_RULES_PVT.attach_extension_rule
576: (

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

569: fnd_file.put_line(FND_FILE.LOG,' ');
570: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
571: fnd_file.put_line(FND_FILE.LOG,'Step 6: Calling API to insert extension rule records');
572: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
573: fnd_file.put_line(FND_FILE.LOG,' ');
574:
575: OKC_XPRT_IMPORT_RULES_PVT.attach_extension_rule
576: (
577: p_api_version => 1,

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

581: x_msg_data => x_msg_data,
582: x_msg_count => x_msg_count
583: );
584:
585: fnd_file.put_line(FND_FILE.LOG,' ');
586: fnd_file.put_line(FND_FILE.LOG,'Step 6: After Calling API to insert extension rule records');
587: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
588: fnd_file.put_line(FND_FILE.LOG,' ');
589:

Line 586: fnd_file.put_line(FND_FILE.LOG,'Step 6: After Calling API to insert extension rule records');

582: x_msg_count => x_msg_count
583: );
584:
585: fnd_file.put_line(FND_FILE.LOG,' ');
586: fnd_file.put_line(FND_FILE.LOG,'Step 6: After Calling API to insert extension rule records');
587: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
588: fnd_file.put_line(FND_FILE.LOG,' ');
589:
590: /*

Line 587: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

583: );
584:
585: fnd_file.put_line(FND_FILE.LOG,' ');
586: fnd_file.put_line(FND_FILE.LOG,'Step 6: After Calling API to insert extension rule records');
587: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
588: fnd_file.put_line(FND_FILE.LOG,' ');
589:
590: /*
591: Step 7: Call the CZ Rule Import Concurrent Program

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

584:
585: fnd_file.put_line(FND_FILE.LOG,' ');
586: fnd_file.put_line(FND_FILE.LOG,'Step 6: After Calling API to insert extension rule records');
587: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
588: fnd_file.put_line(FND_FILE.LOG,' ');
589:
590: /*
591: Step 7: Call the CZ Rule Import Concurrent Program
592: CZ Pgm: Import Configuration Rules (CZRULEIMPORTCP)

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

591: Step 7: Call the CZ Rule Import Concurrent Program
592: CZ Pgm: Import Configuration Rules (CZRULEIMPORTCP)
593: */
594:
595: fnd_file.put_line(FND_FILE.LOG,' ');
596: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
597: fnd_file.put_line(FND_FILE.LOG,'Step 7: Calling the CZ Rule Import Concurrent Program');
598: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
599: fnd_file.put_line(FND_FILE.LOG,' ');

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

592: CZ Pgm: Import Configuration Rules (CZRULEIMPORTCP)
593: */
594:
595: fnd_file.put_line(FND_FILE.LOG,' ');
596: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
597: fnd_file.put_line(FND_FILE.LOG,'Step 7: Calling the CZ Rule Import Concurrent Program');
598: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
599: fnd_file.put_line(FND_FILE.LOG,' ');
600: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);

Line 597: fnd_file.put_line(FND_FILE.LOG,'Step 7: Calling the CZ Rule Import Concurrent Program');

593: */
594:
595: fnd_file.put_line(FND_FILE.LOG,' ');
596: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
597: fnd_file.put_line(FND_FILE.LOG,'Step 7: Calling the CZ Rule Import Concurrent Program');
598: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
599: fnd_file.put_line(FND_FILE.LOG,' ');
600: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);
601:

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

594:
595: fnd_file.put_line(FND_FILE.LOG,' ');
596: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
597: fnd_file.put_line(FND_FILE.LOG,'Step 7: Calling the CZ Rule Import Concurrent Program');
598: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
599: fnd_file.put_line(FND_FILE.LOG,' ');
600: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);
601:
602:

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

595: fnd_file.put_line(FND_FILE.LOG,' ');
596: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
597: fnd_file.put_line(FND_FILE.LOG,'Step 7: Calling the CZ Rule Import Concurrent Program');
598: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
599: fnd_file.put_line(FND_FILE.LOG,' ');
600: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);
601:
602:
603: FND_MESSAGE.set_name('OKC','OKC_XPRT_RULE_CCPRG_ACT_MSG');

Line 600: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);

596: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
597: fnd_file.put_line(FND_FILE.LOG,'Step 7: Calling the CZ Rule Import Concurrent Program');
598: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
599: fnd_file.put_line(FND_FILE.LOG,' ');
600: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);
601:
602:
603: FND_MESSAGE.set_name('OKC','OKC_XPRT_RULE_CCPRG_ACT_MSG');
604: l_conc_pgm_desc := FND_MESSAGE.get;

Line 615: fnd_file.put_line(FND_FILE.LOG,'Request Id of CZ Rule Concurrent Pgm : '||G_REQUEST_ID);

611: sub_request => TRUE,
612: argument1 => G_RUN_ID
613: );
614:
615: fnd_file.put_line(FND_FILE.LOG,'Request Id of CZ Rule Concurrent Pgm : '||G_REQUEST_ID);
616:
617: -- commit the data
618: COMMIT WORK;
619:

Line 623: fnd_file.put_line(FND_FILE.LOG,'Could NOT submit CZ Concurrent Program');

619:
620: IF NVL(G_REQUEST_ID,0) = 0 THEN
621: -- Could Not submit Conc Pgm
622: fnd_message.set_name('OKC','OKC_XPRT_SUB_CZ_RUL_PGM');
623: fnd_file.put_line(FND_FILE.LOG,'Could NOT submit CZ Concurrent Program');
624:
625: -- Added for Bug 4757731
626: FOR csr_pub_rule_rec IN csr_pub_rule_list
627: LOOP

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

669: x_dev_status,
670: x_message
671: );
672:
673: fnd_file.put_line(FND_FILE.LOG,' ');
674: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
675: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
676: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
677: fnd_file.put_line(FND_FILE.LOG,'Results ');

Line 674: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);

670: x_message
671: );
672:
673: fnd_file.put_line(FND_FILE.LOG,' ');
674: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
675: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
676: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
677: fnd_file.put_line(FND_FILE.LOG,'Results ');
678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 675: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);

671: );
672:
673: fnd_file.put_line(FND_FILE.LOG,' ');
674: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
675: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
676: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
677: fnd_file.put_line(FND_FILE.LOG,'Results ');
678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
679: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);

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

672:
673: fnd_file.put_line(FND_FILE.LOG,' ');
674: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
675: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
676: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
677: fnd_file.put_line(FND_FILE.LOG,'Results ');
678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
679: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
680: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);

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

673: fnd_file.put_line(FND_FILE.LOG,' ');
674: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
675: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
676: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
677: fnd_file.put_line(FND_FILE.LOG,'Results ');
678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
679: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
680: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
681: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);

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

674: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
675: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
676: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
677: fnd_file.put_line(FND_FILE.LOG,'Results ');
678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
679: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
680: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
681: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
682: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);

Line 679: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);

675: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
676: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
677: fnd_file.put_line(FND_FILE.LOG,'Results ');
678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
679: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
680: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
681: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
682: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
683: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));

Line 680: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);

676: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
677: fnd_file.put_line(FND_FILE.LOG,'Results ');
678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
679: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
680: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
681: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
682: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
683: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
684: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 681: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);

677: fnd_file.put_line(FND_FILE.LOG,'Results ');
678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
679: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
680: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
681: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
682: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
683: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
684: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
685: fnd_file.put_line(FND_FILE.LOG,' ');

Line 682: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);

678: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
679: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
680: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
681: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
682: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
683: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
684: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
685: fnd_file.put_line(FND_FILE.LOG,' ');
686:

Line 683: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));

679: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
680: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
681: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
682: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
683: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
684: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
685: fnd_file.put_line(FND_FILE.LOG,' ');
686:
687: IF x_dev_phase <> 'COMPLETED' AND

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

680: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
681: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
682: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
683: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
684: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
685: fnd_file.put_line(FND_FILE.LOG,' ');
686:
687: IF x_dev_phase <> 'COMPLETED' AND
688: x_dev_status NOT IN ('NORMAL','WARNING') THEN

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

681: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
682: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
683: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
684: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
685: fnd_file.put_line(FND_FILE.LOG,' ');
686:
687: IF x_dev_phase <> 'COMPLETED' AND
688: x_dev_status NOT IN ('NORMAL','WARNING') THEN
689: -- error in CZ Concurrent Program

Line 690: fnd_file.put_line(FND_FILE.LOG, 'Error in CZ Rule Import Concurrent Program ');

686:
687: IF x_dev_phase <> 'COMPLETED' AND
688: x_dev_status NOT IN ('NORMAL','WARNING') THEN
689: -- error in CZ Concurrent Program
690: fnd_file.put_line(FND_FILE.LOG, 'Error in CZ Rule Import Concurrent Program ');
691: fnd_file.put_line(FND_FILE.LOG, 'Request Id :'||G_REQUEST_ID);
692: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);
693:
694: -- Added for Bug 4757731

Line 691: fnd_file.put_line(FND_FILE.LOG, 'Request Id :'||G_REQUEST_ID);

687: IF x_dev_phase <> 'COMPLETED' AND
688: x_dev_status NOT IN ('NORMAL','WARNING') THEN
689: -- error in CZ Concurrent Program
690: fnd_file.put_line(FND_FILE.LOG, 'Error in CZ Rule Import Concurrent Program ');
691: fnd_file.put_line(FND_FILE.LOG, 'Request Id :'||G_REQUEST_ID);
692: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);
693:
694: -- Added for Bug 4757731
695: FOR csr_pub_rule_rec IN csr_pub_rule_list

Line 692: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);

688: x_dev_status NOT IN ('NORMAL','WARNING') THEN
689: -- error in CZ Concurrent Program
690: fnd_file.put_line(FND_FILE.LOG, 'Error in CZ Rule Import Concurrent Program ');
691: fnd_file.put_line(FND_FILE.LOG, 'Request Id :'||G_REQUEST_ID);
692: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);
693:
694: -- Added for Bug 4757731
695: FOR csr_pub_rule_rec IN csr_pub_rule_list
696: LOOP

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

710: /*
711: Step 8: Check status of Rules Imported
712: */
713:
714: fnd_file.put_line(FND_FILE.LOG,' ');
715: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
716: fnd_file.put_line(FND_FILE.LOG,'Step 8: Checking Status of Rules imported');
717: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
718: fnd_file.put_line(FND_FILE.LOG,' ');

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

711: Step 8: Check status of Rules Imported
712: */
713:
714: fnd_file.put_line(FND_FILE.LOG,' ');
715: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
716: fnd_file.put_line(FND_FILE.LOG,'Step 8: Checking Status of Rules imported');
717: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
718: fnd_file.put_line(FND_FILE.LOG,' ');
719:

Line 716: fnd_file.put_line(FND_FILE.LOG,'Step 8: Checking Status of Rules imported');

712: */
713:
714: fnd_file.put_line(FND_FILE.LOG,' ');
715: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
716: fnd_file.put_line(FND_FILE.LOG,'Step 8: Checking Status of Rules imported');
717: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
718: fnd_file.put_line(FND_FILE.LOG,' ');
719:
720: OKC_XPRT_UTIL_PVT.check_import_status

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

713:
714: fnd_file.put_line(FND_FILE.LOG,' ');
715: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
716: fnd_file.put_line(FND_FILE.LOG,'Step 8: Checking Status of Rules imported');
717: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
718: fnd_file.put_line(FND_FILE.LOG,' ');
719:
720: OKC_XPRT_UTIL_PVT.check_import_status
721: (

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

714: fnd_file.put_line(FND_FILE.LOG,' ');
715: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
716: fnd_file.put_line(FND_FILE.LOG,'Step 8: Checking Status of Rules imported');
717: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
718: fnd_file.put_line(FND_FILE.LOG,' ');
719:
720: OKC_XPRT_UTIL_PVT.check_import_status
721: (
722: p_run_id => G_RUN_ID,

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

726: x_msg_data => x_msg_data,
727: x_msg_count => x_msg_count
728: );
729:
730: fnd_file.put_line(FND_FILE.LOG,' ');
731: fnd_file.put_line(FND_FILE.LOG,'After checking import status');
732: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
733: fnd_file.put_line(FND_FILE.LOG,' ');
734:

Line 731: fnd_file.put_line(FND_FILE.LOG,'After checking import status');

727: x_msg_count => x_msg_count
728: );
729:
730: fnd_file.put_line(FND_FILE.LOG,' ');
731: fnd_file.put_line(FND_FILE.LOG,'After checking import status');
732: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
733: fnd_file.put_line(FND_FILE.LOG,' ');
734:
735: --- If any errors happen abort API

Line 732: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

728: );
729:
730: fnd_file.put_line(FND_FILE.LOG,' ');
731: fnd_file.put_line(FND_FILE.LOG,'After checking import status');
732: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
733: fnd_file.put_line(FND_FILE.LOG,' ');
734:
735: --- If any errors happen abort API
736: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

729:
730: fnd_file.put_line(FND_FILE.LOG,' ');
731: fnd_file.put_line(FND_FILE.LOG,'After checking import status');
732: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
733: fnd_file.put_line(FND_FILE.LOG,' ');
734:
735: --- If any errors happen abort API
736: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
737: -- Added for Bug 4757731

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

768: /*
769: Step 9: Call the Test Publication API
770: */
771:
772: fnd_file.put_line(FND_FILE.LOG,' ');
773: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
774: fnd_file.put_line(FND_FILE.LOG,'Step 9: Calling the Test Publication API');
775: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
776: fnd_file.put_line(FND_FILE.LOG,' ');

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

769: Step 9: Call the Test Publication API
770: */
771:
772: fnd_file.put_line(FND_FILE.LOG,' ');
773: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
774: fnd_file.put_line(FND_FILE.LOG,'Step 9: Calling the Test Publication API');
775: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
776: fnd_file.put_line(FND_FILE.LOG,' ');
777:

Line 774: fnd_file.put_line(FND_FILE.LOG,'Step 9: Calling the Test Publication API');

770: */
771:
772: fnd_file.put_line(FND_FILE.LOG,' ');
773: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
774: fnd_file.put_line(FND_FILE.LOG,'Step 9: Calling the Test Publication API');
775: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
776: fnd_file.put_line(FND_FILE.LOG,' ');
777:
778: OKC_XPRT_UTIL_PVT.create_test_publication

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

771:
772: fnd_file.put_line(FND_FILE.LOG,' ');
773: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
774: fnd_file.put_line(FND_FILE.LOG,'Step 9: Calling the Test Publication API');
775: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
776: fnd_file.put_line(FND_FILE.LOG,' ');
777:
778: OKC_XPRT_UTIL_PVT.create_test_publication
779: (

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

772: fnd_file.put_line(FND_FILE.LOG,' ');
773: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
774: fnd_file.put_line(FND_FILE.LOG,'Step 9: Calling the Test Publication API');
775: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
776: fnd_file.put_line(FND_FILE.LOG,' ');
777:
778: OKC_XPRT_UTIL_PVT.create_test_publication
779: (
780: x_return_status => x_return_status,

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

781: x_msg_data => x_msg_data,
782: x_msg_count => x_msg_count
783: );
784:
785: fnd_file.put_line(FND_FILE.LOG,' ');
786: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
787: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
788: fnd_file.put_line(FND_FILE.LOG,' ');
789:

Line 786: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');

782: x_msg_count => x_msg_count
783: );
784:
785: fnd_file.put_line(FND_FILE.LOG,' ');
786: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
787: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
788: fnd_file.put_line(FND_FILE.LOG,' ');
789:
790: --- If any errors happen abort API

Line 787: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

783: );
784:
785: fnd_file.put_line(FND_FILE.LOG,' ');
786: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
787: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
788: fnd_file.put_line(FND_FILE.LOG,' ');
789:
790: --- If any errors happen abort API
791: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

784:
785: fnd_file.put_line(FND_FILE.LOG,' ');
786: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
787: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
788: fnd_file.put_line(FND_FILE.LOG,' ');
789:
790: --- If any errors happen abort API
791: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
792: -- Added for Bug 4757731

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

821: /*
822: Step 10: Call the Production Publication API
823: */
824:
825: fnd_file.put_line(FND_FILE.LOG,' ');
826: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
827: fnd_file.put_line(FND_FILE.LOG,'Step 9: Calling the Production Publication API');
828: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
829: fnd_file.put_line(FND_FILE.LOG,' ');

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

822: Step 10: Call the Production Publication API
823: */
824:
825: fnd_file.put_line(FND_FILE.LOG,' ');
826: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
827: fnd_file.put_line(FND_FILE.LOG,'Step 9: Calling the Production Publication API');
828: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
829: fnd_file.put_line(FND_FILE.LOG,' ');
830:

Line 827: fnd_file.put_line(FND_FILE.LOG,'Step 9: Calling the Production Publication API');

823: */
824:
825: fnd_file.put_line(FND_FILE.LOG,' ');
826: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
827: fnd_file.put_line(FND_FILE.LOG,'Step 9: Calling the Production Publication API');
828: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
829: fnd_file.put_line(FND_FILE.LOG,' ');
830:
831: OKC_XPRT_UTIL_PVT.create_production_publication

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

824:
825: fnd_file.put_line(FND_FILE.LOG,' ');
826: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
827: fnd_file.put_line(FND_FILE.LOG,'Step 9: Calling the Production Publication API');
828: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
829: fnd_file.put_line(FND_FILE.LOG,' ');
830:
831: OKC_XPRT_UTIL_PVT.create_production_publication
832: (

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

825: fnd_file.put_line(FND_FILE.LOG,' ');
826: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
827: fnd_file.put_line(FND_FILE.LOG,'Step 9: Calling the Production Publication API');
828: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
829: fnd_file.put_line(FND_FILE.LOG,' ');
830:
831: OKC_XPRT_UTIL_PVT.create_production_publication
832: (
833: p_calling_mode => 'PUBLISH',

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

836: x_msg_data => x_msg_data,
837: x_msg_count => x_msg_count
838: );
839:
840: fnd_file.put_line(FND_FILE.LOG,' ');
841: fnd_file.put_line(FND_FILE.LOG,'After Calling the Production Publication API ');
842: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
843: fnd_file.put_line(FND_FILE.LOG,' ');
844:

Line 841: fnd_file.put_line(FND_FILE.LOG,'After Calling the Production Publication API ');

837: x_msg_count => x_msg_count
838: );
839:
840: fnd_file.put_line(FND_FILE.LOG,' ');
841: fnd_file.put_line(FND_FILE.LOG,'After Calling the Production Publication API ');
842: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
843: fnd_file.put_line(FND_FILE.LOG,' ');
844:
845: --- If any errors happen abort API

Line 842: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

838: );
839:
840: fnd_file.put_line(FND_FILE.LOG,' ');
841: fnd_file.put_line(FND_FILE.LOG,'After Calling the Production Publication API ');
842: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
843: fnd_file.put_line(FND_FILE.LOG,' ');
844:
845: --- If any errors happen abort API
846: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

839:
840: fnd_file.put_line(FND_FILE.LOG,' ');
841: fnd_file.put_line(FND_FILE.LOG,'After Calling the Production Publication API ');
842: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
843: fnd_file.put_line(FND_FILE.LOG,' ');
844:
845: --- If any errors happen abort API
846: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
847: -- Added for Bug 4757731

Line 919: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);

915:
916: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
917: retcode := 2;
918: errbuf := x_msg_data;
919: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
920: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
921: fnd_file.put_line(FND_FILE.LOG,' ');
922:
923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 920: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

916: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
917: retcode := 2;
918: errbuf := x_msg_data;
919: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
920: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
921: fnd_file.put_line(FND_FILE.LOG,' ');
922:
923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
924: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

917: retcode := 2;
918: errbuf := x_msg_data;
919: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
920: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
921: fnd_file.put_line(FND_FILE.LOG,' ');
922:
923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
924: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
925: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 933: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);

929:
930: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
931: retcode := 2;
932: errbuf := x_msg_data;
933: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
934: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
935: fnd_file.put_line(FND_FILE.LOG,' ');
936:
937: WHEN OTHERS THEN

Line 934: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

930: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
931: retcode := 2;
932: errbuf := x_msg_data;
933: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
934: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
935: fnd_file.put_line(FND_FILE.LOG,' ');
936:
937: WHEN OTHERS THEN
938: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

931: retcode := 2;
932: errbuf := x_msg_data;
933: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
934: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
935: fnd_file.put_line(FND_FILE.LOG,' ');
936:
937: WHEN OTHERS THEN
938: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
939: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 947: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);

943:
944: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
945: retcode := 2;
946: errbuf := SQLERRM;
947: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
948: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
949: fnd_file.put_line(FND_FILE.LOG,' ');
950:
951: END publish_rules;

Line 948: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

944: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
945: retcode := 2;
946: errbuf := SQLERRM;
947: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
948: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
949: fnd_file.put_line(FND_FILE.LOG,' ');
950:
951: END publish_rules;
952:

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

945: retcode := 2;
946: errbuf := SQLERRM;
947: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
948: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
949: fnd_file.put_line(FND_FILE.LOG,' ');
950:
951: END publish_rules;
952:
953: ---------------------------------------------------

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

1014: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1015: END IF;
1016:
1017: -- log file
1018: fnd_file.put_line(FND_FILE.LOG,' ');
1019: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1020: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1021: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
1022:

Line 1019: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

1015: END IF;
1016:
1017: -- log file
1018: fnd_file.put_line(FND_FILE.LOG,' ');
1019: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1020: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1021: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
1022:
1023: /*

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

1016:
1017: -- log file
1018: fnd_file.put_line(FND_FILE.LOG,' ');
1019: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1020: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1021: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
1022:
1023: /*
1024: Step 1: Update current request Id for all rules to be published

Line 1021: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);

1017: -- log file
1018: fnd_file.put_line(FND_FILE.LOG,' ');
1019: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1020: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1021: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
1022:
1023: /*
1024: Step 1: Update current request Id for all rules to be published
1025: */

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

1023: /*
1024: Step 1: Update current request Id for all rules to be published
1025: */
1026:
1027: fnd_file.put_line(FND_FILE.LOG,' ');
1028: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1029: fnd_file.put_line(FND_FILE.LOG,'Step 1: Updating request_id for rules to be published ');
1030: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1031: fnd_file.put_line(FND_FILE.LOG,' ');

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

1024: Step 1: Update current request Id for all rules to be published
1025: */
1026:
1027: fnd_file.put_line(FND_FILE.LOG,' ');
1028: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1029: fnd_file.put_line(FND_FILE.LOG,'Step 1: Updating request_id for rules to be published ');
1030: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1031: fnd_file.put_line(FND_FILE.LOG,' ');
1032:

Line 1029: fnd_file.put_line(FND_FILE.LOG,'Step 1: Updating request_id for rules to be published ');

1025: */
1026:
1027: fnd_file.put_line(FND_FILE.LOG,' ');
1028: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1029: fnd_file.put_line(FND_FILE.LOG,'Step 1: Updating request_id for rules to be published ');
1030: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1031: fnd_file.put_line(FND_FILE.LOG,' ');
1032:
1033: -- Update request_id for all Rules in Pending Publication for current org id

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

1026:
1027: fnd_file.put_line(FND_FILE.LOG,' ');
1028: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1029: fnd_file.put_line(FND_FILE.LOG,'Step 1: Updating request_id for rules to be published ');
1030: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1031: fnd_file.put_line(FND_FILE.LOG,' ');
1032:
1033: -- Update request_id for all Rules in Pending Publication for current org id
1034: UPDATE okc_xprt_rule_hdrs_all

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

1027: fnd_file.put_line(FND_FILE.LOG,' ');
1028: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1029: fnd_file.put_line(FND_FILE.LOG,'Step 1: Updating request_id for rules to be published ');
1030: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1031: fnd_file.put_line(FND_FILE.LOG,' ');
1032:
1033: -- Update request_id for all Rules in Pending Publication for current org id
1034: UPDATE okc_xprt_rule_hdrs_all
1035: SET request_id = FND_GLOBAL.CONC_REQUEST_ID,

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

1048:
1049: -- Check If any rules are to be processed else exit
1050: IF SQL%NOTFOUND THEN
1051: -- exit as no rules to be processed
1052: fnd_file.put_line(FND_FILE.LOG,' ');
1053: fnd_file.put_line(FND_FILE.LOG,'No Rules to be processed ');
1054: fnd_file.put_line(FND_FILE.LOG,' ');
1055:
1056: retcode := 0;

Line 1053: fnd_file.put_line(FND_FILE.LOG,'No Rules to be processed ');

1049: -- Check If any rules are to be processed else exit
1050: IF SQL%NOTFOUND THEN
1051: -- exit as no rules to be processed
1052: fnd_file.put_line(FND_FILE.LOG,' ');
1053: fnd_file.put_line(FND_FILE.LOG,'No Rules to be processed ');
1054: fnd_file.put_line(FND_FILE.LOG,' ');
1055:
1056: retcode := 0;
1057: errbuf := '';

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

1050: IF SQL%NOTFOUND THEN
1051: -- exit as no rules to be processed
1052: fnd_file.put_line(FND_FILE.LOG,' ');
1053: fnd_file.put_line(FND_FILE.LOG,'No Rules to be processed ');
1054: fnd_file.put_line(FND_FILE.LOG,' ');
1055:
1056: retcode := 0;
1057: errbuf := '';
1058: RETURN;

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

1065: /*
1066: Step 2: Import Template Model(s)
1067: */
1068:
1069: fnd_file.put_line(FND_FILE.LOG,' ');
1070: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1071: fnd_file.put_line(FND_FILE.LOG,'Step 2: Importing Template Models');
1072: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1073: fnd_file.put_line(FND_FILE.LOG,' ');

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

1066: Step 2: Import Template Model(s)
1067: */
1068:
1069: fnd_file.put_line(FND_FILE.LOG,' ');
1070: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1071: fnd_file.put_line(FND_FILE.LOG,'Step 2: Importing Template Models');
1072: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1073: fnd_file.put_line(FND_FILE.LOG,' ');
1074:

Line 1071: fnd_file.put_line(FND_FILE.LOG,'Step 2: Importing Template Models');

1067: */
1068:
1069: fnd_file.put_line(FND_FILE.LOG,' ');
1070: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1071: fnd_file.put_line(FND_FILE.LOG,'Step 2: Importing Template Models');
1072: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1073: fnd_file.put_line(FND_FILE.LOG,' ');
1074:
1075: OKC_XPRT_IMPORT_TEMPLATE_PVT.rebuild_tmpl_pub_disable

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

1068:
1069: fnd_file.put_line(FND_FILE.LOG,' ');
1070: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1071: fnd_file.put_line(FND_FILE.LOG,'Step 2: Importing Template Models');
1072: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1073: fnd_file.put_line(FND_FILE.LOG,' ');
1074:
1075: OKC_XPRT_IMPORT_TEMPLATE_PVT.rebuild_tmpl_pub_disable
1076: (

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

1069: fnd_file.put_line(FND_FILE.LOG,' ');
1070: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1071: fnd_file.put_line(FND_FILE.LOG,'Step 2: Importing Template Models');
1072: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1073: fnd_file.put_line(FND_FILE.LOG,' ');
1074:
1075: OKC_XPRT_IMPORT_TEMPLATE_PVT.rebuild_tmpl_pub_disable
1076: (
1077: x_return_status => x_return_status,

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

1078: x_msg_data => x_msg_data,
1079: x_msg_count => x_msg_count
1080: ) ;
1081:
1082: fnd_file.put_line(FND_FILE.LOG,' ');
1083: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Models');
1084: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1085: fnd_file.put_line(FND_FILE.LOG,' ');
1086:

Line 1083: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Models');

1079: x_msg_count => x_msg_count
1080: ) ;
1081:
1082: fnd_file.put_line(FND_FILE.LOG,' ');
1083: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Models');
1084: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1085: fnd_file.put_line(FND_FILE.LOG,' ');
1086:
1087: --- If any errors happen abort API

Line 1084: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

1080: ) ;
1081:
1082: fnd_file.put_line(FND_FILE.LOG,' ');
1083: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Models');
1084: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1085: fnd_file.put_line(FND_FILE.LOG,' ');
1086:
1087: --- If any errors happen abort API
1088: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

1081:
1082: fnd_file.put_line(FND_FILE.LOG,' ');
1083: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Models');
1084: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1085: fnd_file.put_line(FND_FILE.LOG,' ');
1086:
1087: --- If any errors happen abort API
1088: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1089: -- Added for Bug 4757731

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

1120: /*
1121: Step 3: Populate cz_imp_rules
1122: */
1123:
1124: fnd_file.put_line(FND_FILE.LOG,' ');
1125: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1126: fnd_file.put_line(FND_FILE.LOG,'Step 3: Populating cz_imp_rules ');
1127: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1128: fnd_file.put_line(FND_FILE.LOG,' ');

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

1121: Step 3: Populate cz_imp_rules
1122: */
1123:
1124: fnd_file.put_line(FND_FILE.LOG,' ');
1125: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1126: fnd_file.put_line(FND_FILE.LOG,'Step 3: Populating cz_imp_rules ');
1127: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1128: fnd_file.put_line(FND_FILE.LOG,' ');
1129:

Line 1126: fnd_file.put_line(FND_FILE.LOG,'Step 3: Populating cz_imp_rules ');

1122: */
1123:
1124: fnd_file.put_line(FND_FILE.LOG,' ');
1125: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1126: fnd_file.put_line(FND_FILE.LOG,'Step 3: Populating cz_imp_rules ');
1127: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1128: fnd_file.put_line(FND_FILE.LOG,' ');
1129:
1130: OKC_XPRT_IMPORT_RULES_PVT.import_rules_disable

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

1123:
1124: fnd_file.put_line(FND_FILE.LOG,' ');
1125: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1126: fnd_file.put_line(FND_FILE.LOG,'Step 3: Populating cz_imp_rules ');
1127: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1128: fnd_file.put_line(FND_FILE.LOG,' ');
1129:
1130: OKC_XPRT_IMPORT_RULES_PVT.import_rules_disable
1131: (

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

1124: fnd_file.put_line(FND_FILE.LOG,' ');
1125: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1126: fnd_file.put_line(FND_FILE.LOG,'Step 3: Populating cz_imp_rules ');
1127: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1128: fnd_file.put_line(FND_FILE.LOG,' ');
1129:
1130: OKC_XPRT_IMPORT_RULES_PVT.import_rules_disable
1131: (
1132: x_run_id => G_RUN_ID,

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

1134: x_msg_data => x_msg_data,
1135: x_msg_count => x_msg_count
1136: );
1137:
1138: fnd_file.put_line(FND_FILE.LOG,' ');
1139: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
1140: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1141: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
1142: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1139: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');

1135: x_msg_count => x_msg_count
1136: );
1137:
1138: fnd_file.put_line(FND_FILE.LOG,' ');
1139: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
1140: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1141: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
1142: fnd_file.put_line(FND_FILE.LOG,' ');
1143:

Line 1140: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

1136: );
1137:
1138: fnd_file.put_line(FND_FILE.LOG,' ');
1139: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
1140: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1141: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
1142: fnd_file.put_line(FND_FILE.LOG,' ');
1143:
1144: --- If any errors happen abort API

Line 1141: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);

1137:
1138: fnd_file.put_line(FND_FILE.LOG,' ');
1139: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
1140: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1141: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
1142: fnd_file.put_line(FND_FILE.LOG,' ');
1143:
1144: --- If any errors happen abort API
1145: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

1138: fnd_file.put_line(FND_FILE.LOG,' ');
1139: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
1140: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1141: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
1142: fnd_file.put_line(FND_FILE.LOG,' ');
1143:
1144: --- If any errors happen abort API
1145: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1146: -- Added for Bug 4757731

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

1178: If there are no records in cz_imp_rules then there were no expert enabled templates
1179: attached to the rule. Just change the status of the rule to INACTIVE
1180: */
1181:
1182: fnd_file.put_line(FND_FILE.LOG,' ');
1183: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1184: fnd_file.put_line(FND_FILE.LOG,'Step 3.1:Count Rules to be imported');
1185: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1186: fnd_file.put_line(FND_FILE.LOG,' ');

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

1179: attached to the rule. Just change the status of the rule to INACTIVE
1180: */
1181:
1182: fnd_file.put_line(FND_FILE.LOG,' ');
1183: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1184: fnd_file.put_line(FND_FILE.LOG,'Step 3.1:Count Rules to be imported');
1185: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1186: fnd_file.put_line(FND_FILE.LOG,' ');
1187:

Line 1184: fnd_file.put_line(FND_FILE.LOG,'Step 3.1:Count Rules to be imported');

1180: */
1181:
1182: fnd_file.put_line(FND_FILE.LOG,' ');
1183: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1184: fnd_file.put_line(FND_FILE.LOG,'Step 3.1:Count Rules to be imported');
1185: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1186: fnd_file.put_line(FND_FILE.LOG,' ');
1187:
1188: OPEN csr_cz_imp_rules_cnt;

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

1181:
1182: fnd_file.put_line(FND_FILE.LOG,' ');
1183: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1184: fnd_file.put_line(FND_FILE.LOG,'Step 3.1:Count Rules to be imported');
1185: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1186: fnd_file.put_line(FND_FILE.LOG,' ');
1187:
1188: OPEN csr_cz_imp_rules_cnt;
1189: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;

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

1182: fnd_file.put_line(FND_FILE.LOG,' ');
1183: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1184: fnd_file.put_line(FND_FILE.LOG,'Step 3.1:Count Rules to be imported');
1185: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1186: fnd_file.put_line(FND_FILE.LOG,' ');
1187:
1188: OPEN csr_cz_imp_rules_cnt;
1189: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
1190: CLOSE csr_cz_imp_rules_cnt;

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

1188: OPEN csr_cz_imp_rules_cnt;
1189: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
1190: CLOSE csr_cz_imp_rules_cnt;
1191:
1192: fnd_file.put_line(FND_FILE.LOG,' ');
1193: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);
1194: fnd_file.put_line(FND_FILE.LOG,' ');
1195:
1196:

Line 1193: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);

1189: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
1190: CLOSE csr_cz_imp_rules_cnt;
1191:
1192: fnd_file.put_line(FND_FILE.LOG,' ');
1193: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);
1194: fnd_file.put_line(FND_FILE.LOG,' ');
1195:
1196:
1197: IF l_rules_cnt = 0 THEN

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

1190: CLOSE csr_cz_imp_rules_cnt;
1191:
1192: fnd_file.put_line(FND_FILE.LOG,' ');
1193: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);
1194: fnd_file.put_line(FND_FILE.LOG,' ');
1195:
1196:
1197: IF l_rules_cnt = 0 THEN
1198:

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

1203: x_msg_data => x_msg_data,
1204: x_msg_count => x_msg_count
1205: );
1206:
1207: fnd_file.put_line(FND_FILE.LOG,' ');
1208: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl');
1209: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1210: fnd_file.put_line(FND_FILE.LOG,' ');
1211:

Line 1208: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl');

1204: x_msg_count => x_msg_count
1205: );
1206:
1207: fnd_file.put_line(FND_FILE.LOG,' ');
1208: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl');
1209: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1210: fnd_file.put_line(FND_FILE.LOG,' ');
1211:
1212: --- If any errors happen abort API

Line 1209: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

1205: );
1206:
1207: fnd_file.put_line(FND_FILE.LOG,' ');
1208: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl');
1209: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1210: fnd_file.put_line(FND_FILE.LOG,' ');
1211:
1212: --- If any errors happen abort API
1213: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

1206:
1207: fnd_file.put_line(FND_FILE.LOG,' ');
1208: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.publish_rule_with_no_tmpl');
1209: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1210: fnd_file.put_line(FND_FILE.LOG,' ');
1211:
1212: --- If any errors happen abort API
1213: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1214: -- Added for Bug 4757731

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

1240: -- Added for Bug 4757731
1241: RAISE FND_API.G_EXC_ERROR;
1242: END IF;
1243:
1244: fnd_file.put_line(FND_FILE.LOG,' ');
1245: fnd_file.put_line(FND_FILE.LOG,'Rules has No expert template attached');
1246: fnd_file.put_line(FND_FILE.LOG,' ');
1247:
1248: retcode := 0;

Line 1245: fnd_file.put_line(FND_FILE.LOG,'Rules has No expert template attached');

1241: RAISE FND_API.G_EXC_ERROR;
1242: END IF;
1243:
1244: fnd_file.put_line(FND_FILE.LOG,' ');
1245: fnd_file.put_line(FND_FILE.LOG,'Rules has No expert template attached');
1246: fnd_file.put_line(FND_FILE.LOG,' ');
1247:
1248: retcode := 0;
1249: errbuf := '';

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

1242: END IF;
1243:
1244: fnd_file.put_line(FND_FILE.LOG,' ');
1245: fnd_file.put_line(FND_FILE.LOG,'Rules has No expert template attached');
1246: fnd_file.put_line(FND_FILE.LOG,' ');
1247:
1248: retcode := 0;
1249: errbuf := '';
1250: RETURN;

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

1255: Step 4: Call the CZ Rule Import Concurrent Program
1256: CZ Pgm: Import Configuration Rules (CZRULEIMPORTCP)
1257: */
1258:
1259: fnd_file.put_line(FND_FILE.LOG,' ');
1260: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1261: fnd_file.put_line(FND_FILE.LOG,'Step 4: Calling the CZ Rule Import Concurrent Program');
1262: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1263: fnd_file.put_line(FND_FILE.LOG,' ');

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

1256: CZ Pgm: Import Configuration Rules (CZRULEIMPORTCP)
1257: */
1258:
1259: fnd_file.put_line(FND_FILE.LOG,' ');
1260: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1261: fnd_file.put_line(FND_FILE.LOG,'Step 4: Calling the CZ Rule Import Concurrent Program');
1262: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1263: fnd_file.put_line(FND_FILE.LOG,' ');
1264: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);

Line 1261: fnd_file.put_line(FND_FILE.LOG,'Step 4: Calling the CZ Rule Import Concurrent Program');

1257: */
1258:
1259: fnd_file.put_line(FND_FILE.LOG,' ');
1260: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1261: fnd_file.put_line(FND_FILE.LOG,'Step 4: Calling the CZ Rule Import Concurrent Program');
1262: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1263: fnd_file.put_line(FND_FILE.LOG,' ');
1264: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);
1265:

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

1258:
1259: fnd_file.put_line(FND_FILE.LOG,' ');
1260: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1261: fnd_file.put_line(FND_FILE.LOG,'Step 4: Calling the CZ Rule Import Concurrent Program');
1262: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1263: fnd_file.put_line(FND_FILE.LOG,' ');
1264: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);
1265:
1266: FND_MESSAGE.set_name('OKC','OKC_XPRT_RULE_CCPRG_DIS_MSG');

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

1259: fnd_file.put_line(FND_FILE.LOG,' ');
1260: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1261: fnd_file.put_line(FND_FILE.LOG,'Step 4: Calling the CZ Rule Import Concurrent Program');
1262: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1263: fnd_file.put_line(FND_FILE.LOG,' ');
1264: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);
1265:
1266: FND_MESSAGE.set_name('OKC','OKC_XPRT_RULE_CCPRG_DIS_MSG');
1267: l_conc_pgm_desc := FND_MESSAGE.get;

Line 1264: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);

1260: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1261: fnd_file.put_line(FND_FILE.LOG,'Step 4: Calling the CZ Rule Import Concurrent Program');
1262: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1263: fnd_file.put_line(FND_FILE.LOG,' ');
1264: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);
1265:
1266: FND_MESSAGE.set_name('OKC','OKC_XPRT_RULE_CCPRG_DIS_MSG');
1267: l_conc_pgm_desc := FND_MESSAGE.get;
1268:

Line 1278: fnd_file.put_line(FND_FILE.LOG,'Request Id of CZ Rule Concurrent Pgm : '||G_REQUEST_ID);

1274: sub_request => TRUE,
1275: argument1 => G_RUN_ID
1276: );
1277:
1278: fnd_file.put_line(FND_FILE.LOG,'Request Id of CZ Rule Concurrent Pgm : '||G_REQUEST_ID);
1279:
1280: -- commit the data
1281: COMMIT WORK;
1282:

Line 1286: fnd_file.put_line(FND_FILE.LOG,'Could NOT submit CZ Concurrent Program');

1282:
1283: IF NVL(G_REQUEST_ID,0) = 0 THEN
1284: -- Could Not submit Conc Pgm
1285: fnd_message.set_name('OKC','OKC_XPRT_SUB_CZ_RUL_PGM');
1286: fnd_file.put_line(FND_FILE.LOG,'Could NOT submit CZ Concurrent Program');
1287: FOR csr_dis_rule_rec IN csr_dis_rule_list
1288: LOOP
1289: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1290: UPDATE okc_xprt_rule_hdrs_all

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

1330: x_dev_status,
1331: x_message
1332: );
1333:
1334: fnd_file.put_line(FND_FILE.LOG,' ');
1335: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
1336: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
1337: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1338: fnd_file.put_line(FND_FILE.LOG,'Results ');

Line 1335: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);

1331: x_message
1332: );
1333:
1334: fnd_file.put_line(FND_FILE.LOG,' ');
1335: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
1336: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
1337: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1338: fnd_file.put_line(FND_FILE.LOG,'Results ');
1339: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 1336: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);

1332: );
1333:
1334: fnd_file.put_line(FND_FILE.LOG,' ');
1335: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
1336: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
1337: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1338: fnd_file.put_line(FND_FILE.LOG,'Results ');
1339: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1340: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);

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

1333:
1334: fnd_file.put_line(FND_FILE.LOG,' ');
1335: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
1336: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
1337: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1338: fnd_file.put_line(FND_FILE.LOG,'Results ');
1339: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1340: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
1341: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);

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

1334: fnd_file.put_line(FND_FILE.LOG,' ');
1335: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
1336: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
1337: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1338: fnd_file.put_line(FND_FILE.LOG,'Results ');
1339: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1340: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
1341: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
1342: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);

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

1335: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
1336: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
1337: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1338: fnd_file.put_line(FND_FILE.LOG,'Results ');
1339: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1340: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
1341: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
1342: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
1343: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);

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

1336: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
1337: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1338: fnd_file.put_line(FND_FILE.LOG,'Results ');
1339: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1340: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
1341: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
1342: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
1343: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
1344: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));

Line 1341: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);

1337: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1338: fnd_file.put_line(FND_FILE.LOG,'Results ');
1339: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1340: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
1341: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
1342: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
1343: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
1344: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
1345: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 1342: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);

1338: fnd_file.put_line(FND_FILE.LOG,'Results ');
1339: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1340: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
1341: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
1342: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
1343: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
1344: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
1345: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1346: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1343: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);

1339: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1340: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
1341: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
1342: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
1343: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
1344: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
1345: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1346: fnd_file.put_line(FND_FILE.LOG,' ');
1347:

Line 1344: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));

1340: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
1341: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
1342: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
1343: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
1344: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
1345: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1346: fnd_file.put_line(FND_FILE.LOG,' ');
1347:
1348: IF x_dev_phase <> 'COMPLETED' AND

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

1341: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
1342: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
1343: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
1344: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
1345: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1346: fnd_file.put_line(FND_FILE.LOG,' ');
1347:
1348: IF x_dev_phase <> 'COMPLETED' AND
1349: x_dev_status NOT IN ('NORMAL','WARNING') THEN

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

1342: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
1343: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
1344: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
1345: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1346: fnd_file.put_line(FND_FILE.LOG,' ');
1347:
1348: IF x_dev_phase <> 'COMPLETED' AND
1349: x_dev_status NOT IN ('NORMAL','WARNING') THEN
1350: -- error in CZ Concurrent Program

Line 1351: fnd_file.put_line(FND_FILE.LOG, 'Error in CZ Rule Import Concurrent Program ');

1347:
1348: IF x_dev_phase <> 'COMPLETED' AND
1349: x_dev_status NOT IN ('NORMAL','WARNING') THEN
1350: -- error in CZ Concurrent Program
1351: fnd_file.put_line(FND_FILE.LOG, 'Error in CZ Rule Import Concurrent Program ');
1352: fnd_file.put_line(FND_FILE.LOG, 'Request Id :'||G_REQUEST_ID);
1353: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);
1354: FOR csr_dis_rule_rec IN csr_dis_rule_list
1355: LOOP

Line 1352: fnd_file.put_line(FND_FILE.LOG, 'Request Id :'||G_REQUEST_ID);

1348: IF x_dev_phase <> 'COMPLETED' AND
1349: x_dev_status NOT IN ('NORMAL','WARNING') THEN
1350: -- error in CZ Concurrent Program
1351: fnd_file.put_line(FND_FILE.LOG, 'Error in CZ Rule Import Concurrent Program ');
1352: fnd_file.put_line(FND_FILE.LOG, 'Request Id :'||G_REQUEST_ID);
1353: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);
1354: FOR csr_dis_rule_rec IN csr_dis_rule_list
1355: LOOP
1356: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);

Line 1353: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);

1349: x_dev_status NOT IN ('NORMAL','WARNING') THEN
1350: -- error in CZ Concurrent Program
1351: fnd_file.put_line(FND_FILE.LOG, 'Error in CZ Rule Import Concurrent Program ');
1352: fnd_file.put_line(FND_FILE.LOG, 'Request Id :'||G_REQUEST_ID);
1353: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);
1354: FOR csr_dis_rule_rec IN csr_dis_rule_list
1355: LOOP
1356: l_rule_exists_flag := check_rule_active(csr_dis_rule_rec.rule_id);
1357: UPDATE okc_xprt_rule_hdrs_all

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

1368: /*
1369: Step 5: Check status of Rules Imported
1370: */
1371:
1372: fnd_file.put_line(FND_FILE.LOG,' ');
1373: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1374: fnd_file.put_line(FND_FILE.LOG,'Step 5: Checking Status of Rules imported');
1375: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1376: fnd_file.put_line(FND_FILE.LOG,' ');

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

1369: Step 5: Check status of Rules Imported
1370: */
1371:
1372: fnd_file.put_line(FND_FILE.LOG,' ');
1373: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1374: fnd_file.put_line(FND_FILE.LOG,'Step 5: Checking Status of Rules imported');
1375: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1376: fnd_file.put_line(FND_FILE.LOG,' ');
1377:

Line 1374: fnd_file.put_line(FND_FILE.LOG,'Step 5: Checking Status of Rules imported');

1370: */
1371:
1372: fnd_file.put_line(FND_FILE.LOG,' ');
1373: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1374: fnd_file.put_line(FND_FILE.LOG,'Step 5: Checking Status of Rules imported');
1375: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1376: fnd_file.put_line(FND_FILE.LOG,' ');
1377:
1378: OKC_XPRT_UTIL_PVT.check_import_status

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

1371:
1372: fnd_file.put_line(FND_FILE.LOG,' ');
1373: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1374: fnd_file.put_line(FND_FILE.LOG,'Step 5: Checking Status of Rules imported');
1375: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1376: fnd_file.put_line(FND_FILE.LOG,' ');
1377:
1378: OKC_XPRT_UTIL_PVT.check_import_status
1379: (

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

1372: fnd_file.put_line(FND_FILE.LOG,' ');
1373: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1374: fnd_file.put_line(FND_FILE.LOG,'Step 5: Checking Status of Rules imported');
1375: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1376: fnd_file.put_line(FND_FILE.LOG,' ');
1377:
1378: OKC_XPRT_UTIL_PVT.check_import_status
1379: (
1380: p_run_id => G_RUN_ID,

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

1384: x_msg_data => x_msg_data,
1385: x_msg_count => x_msg_count
1386: );
1387:
1388: fnd_file.put_line(FND_FILE.LOG,' ');
1389: fnd_file.put_line(FND_FILE.LOG,'After checking import status');
1390: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1391: fnd_file.put_line(FND_FILE.LOG,' ');
1392:

Line 1389: fnd_file.put_line(FND_FILE.LOG,'After checking import status');

1385: x_msg_count => x_msg_count
1386: );
1387:
1388: fnd_file.put_line(FND_FILE.LOG,' ');
1389: fnd_file.put_line(FND_FILE.LOG,'After checking import status');
1390: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1391: fnd_file.put_line(FND_FILE.LOG,' ');
1392:
1393: --- If any errors happen abort API

Line 1390: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

1386: );
1387:
1388: fnd_file.put_line(FND_FILE.LOG,' ');
1389: fnd_file.put_line(FND_FILE.LOG,'After checking import status');
1390: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1391: fnd_file.put_line(FND_FILE.LOG,' ');
1392:
1393: --- If any errors happen abort API
1394: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

1387:
1388: fnd_file.put_line(FND_FILE.LOG,' ');
1389: fnd_file.put_line(FND_FILE.LOG,'After checking import status');
1390: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1391: fnd_file.put_line(FND_FILE.LOG,' ');
1392:
1393: --- If any errors happen abort API
1394: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1395: -- Added for Bug 4757731

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

1425: /*
1426: Step 6: Call the Test Publication API
1427: */
1428:
1429: fnd_file.put_line(FND_FILE.LOG,' ');
1430: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1431: fnd_file.put_line(FND_FILE.LOG,'Step 6: Calling the Test Publication API');
1432: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1433: fnd_file.put_line(FND_FILE.LOG,' ');

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

1426: Step 6: Call the Test Publication API
1427: */
1428:
1429: fnd_file.put_line(FND_FILE.LOG,' ');
1430: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1431: fnd_file.put_line(FND_FILE.LOG,'Step 6: Calling the Test Publication API');
1432: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1433: fnd_file.put_line(FND_FILE.LOG,' ');
1434:

Line 1431: fnd_file.put_line(FND_FILE.LOG,'Step 6: Calling the Test Publication API');

1427: */
1428:
1429: fnd_file.put_line(FND_FILE.LOG,' ');
1430: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1431: fnd_file.put_line(FND_FILE.LOG,'Step 6: Calling the Test Publication API');
1432: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1433: fnd_file.put_line(FND_FILE.LOG,' ');
1434:
1435:

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

1428:
1429: fnd_file.put_line(FND_FILE.LOG,' ');
1430: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1431: fnd_file.put_line(FND_FILE.LOG,'Step 6: Calling the Test Publication API');
1432: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1433: fnd_file.put_line(FND_FILE.LOG,' ');
1434:
1435:
1436: OKC_XPRT_UTIL_PVT.create_test_publication

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

1429: fnd_file.put_line(FND_FILE.LOG,' ');
1430: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1431: fnd_file.put_line(FND_FILE.LOG,'Step 6: Calling the Test Publication API');
1432: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1433: fnd_file.put_line(FND_FILE.LOG,' ');
1434:
1435:
1436: OKC_XPRT_UTIL_PVT.create_test_publication
1437: (

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

1439: x_msg_data => x_msg_data,
1440: x_msg_count => x_msg_count
1441: );
1442:
1443: fnd_file.put_line(FND_FILE.LOG,' ');
1444: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
1445: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1446: fnd_file.put_line(FND_FILE.LOG,' ');
1447:

Line 1444: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');

1440: x_msg_count => x_msg_count
1441: );
1442:
1443: fnd_file.put_line(FND_FILE.LOG,' ');
1444: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
1445: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1446: fnd_file.put_line(FND_FILE.LOG,' ');
1447:
1448: --- If any errors happen abort API

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

1441: );
1442:
1443: fnd_file.put_line(FND_FILE.LOG,' ');
1444: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
1445: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1446: fnd_file.put_line(FND_FILE.LOG,' ');
1447:
1448: --- If any errors happen abort API
1449: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

1442:
1443: fnd_file.put_line(FND_FILE.LOG,' ');
1444: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
1445: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1446: fnd_file.put_line(FND_FILE.LOG,' ');
1447:
1448: --- If any errors happen abort API
1449: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1450: -- Added for Bug 4757731

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

1480: /*
1481: Step 7: Call the Production Publication API
1482: */
1483:
1484: fnd_file.put_line(FND_FILE.LOG,' ');
1485: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1486: fnd_file.put_line(FND_FILE.LOG,'Step 7: Calling the Production Publication API');
1487: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1488: fnd_file.put_line(FND_FILE.LOG,' ');

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

1481: Step 7: Call the Production Publication API
1482: */
1483:
1484: fnd_file.put_line(FND_FILE.LOG,' ');
1485: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1486: fnd_file.put_line(FND_FILE.LOG,'Step 7: Calling the Production Publication API');
1487: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1488: fnd_file.put_line(FND_FILE.LOG,' ');
1489:

Line 1486: fnd_file.put_line(FND_FILE.LOG,'Step 7: Calling the Production Publication API');

1482: */
1483:
1484: fnd_file.put_line(FND_FILE.LOG,' ');
1485: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1486: fnd_file.put_line(FND_FILE.LOG,'Step 7: Calling the Production Publication API');
1487: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1488: fnd_file.put_line(FND_FILE.LOG,' ');
1489:
1490: OKC_XPRT_UTIL_PVT.create_production_publication

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

1483:
1484: fnd_file.put_line(FND_FILE.LOG,' ');
1485: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1486: fnd_file.put_line(FND_FILE.LOG,'Step 7: Calling the Production Publication API');
1487: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1488: fnd_file.put_line(FND_FILE.LOG,' ');
1489:
1490: OKC_XPRT_UTIL_PVT.create_production_publication
1491: (

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

1484: fnd_file.put_line(FND_FILE.LOG,' ');
1485: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1486: fnd_file.put_line(FND_FILE.LOG,'Step 7: Calling the Production Publication API');
1487: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1488: fnd_file.put_line(FND_FILE.LOG,' ');
1489:
1490: OKC_XPRT_UTIL_PVT.create_production_publication
1491: (
1492: p_calling_mode => 'DISABLE',

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

1495: x_msg_data => x_msg_data,
1496: x_msg_count => x_msg_count
1497: );
1498:
1499: fnd_file.put_line(FND_FILE.LOG,' ');
1500: fnd_file.put_line(FND_FILE.LOG,'After Calling the Production Publication API ');
1501: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1502: fnd_file.put_line(FND_FILE.LOG,' ');
1503:

Line 1500: fnd_file.put_line(FND_FILE.LOG,'After Calling the Production Publication API ');

1496: x_msg_count => x_msg_count
1497: );
1498:
1499: fnd_file.put_line(FND_FILE.LOG,' ');
1500: fnd_file.put_line(FND_FILE.LOG,'After Calling the Production Publication API ');
1501: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1502: fnd_file.put_line(FND_FILE.LOG,' ');
1503:
1504: --- If any errors happen abort API

Line 1501: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

1497: );
1498:
1499: fnd_file.put_line(FND_FILE.LOG,' ');
1500: fnd_file.put_line(FND_FILE.LOG,'After Calling the Production Publication API ');
1501: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1502: fnd_file.put_line(FND_FILE.LOG,' ');
1503:
1504: --- If any errors happen abort API
1505: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

1498:
1499: fnd_file.put_line(FND_FILE.LOG,' ');
1500: fnd_file.put_line(FND_FILE.LOG,'After Calling the Production Publication API ');
1501: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1502: fnd_file.put_line(FND_FILE.LOG,' ');
1503:
1504: --- If any errors happen abort API
1505: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1506: -- Added for Bug 4757731

Line 1576: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);

1572:
1573: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1574: retcode := 2;
1575: errbuf := x_msg_data;
1576: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
1577: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1578: fnd_file.put_line(FND_FILE.LOG,' ');
1579:
1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1577: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

1573: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1574: retcode := 2;
1575: errbuf := x_msg_data;
1576: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
1577: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1578: fnd_file.put_line(FND_FILE.LOG,' ');
1579:
1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1581: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1574: retcode := 2;
1575: errbuf := x_msg_data;
1576: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
1577: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1578: fnd_file.put_line(FND_FILE.LOG,' ');
1579:
1580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1581: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1582: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1590: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);

1586:
1587: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1588: retcode := 2;
1589: errbuf := x_msg_data;
1590: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
1591: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1592: fnd_file.put_line(FND_FILE.LOG,' ');
1593:
1594: WHEN OTHERS THEN

Line 1591: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

1587: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1588: retcode := 2;
1589: errbuf := x_msg_data;
1590: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
1591: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1592: fnd_file.put_line(FND_FILE.LOG,' ');
1593:
1594: WHEN OTHERS THEN
1595: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1588: retcode := 2;
1589: errbuf := x_msg_data;
1590: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
1591: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1592: fnd_file.put_line(FND_FILE.LOG,' ');
1593:
1594: WHEN OTHERS THEN
1595: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1596: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1604: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);

1600:
1601: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1602: retcode := 2;
1603: errbuf := SQLERRM;
1604: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
1605: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1606: fnd_file.put_line(FND_FILE.LOG,' ');
1607:
1608: END disable_rules;

Line 1605: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

1601: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1602: retcode := 2;
1603: errbuf := SQLERRM;
1604: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
1605: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1606: fnd_file.put_line(FND_FILE.LOG,' ');
1607:
1608: END disable_rules;
1609:

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

1602: retcode := 2;
1603: errbuf := SQLERRM;
1604: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
1605: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1606: fnd_file.put_line(FND_FILE.LOG,' ');
1607:
1608: END disable_rules;
1609:
1610: ---------------------------------------------------

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

1650: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1651: END IF;
1652:
1653: -- log file
1654: fnd_file.put_line(FND_FILE.LOG,' ');
1655: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1656: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1657: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
1658: fnd_file.put_line(FND_FILE.LOG,'Intent : '||p_intent);

Line 1655: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

1651: END IF;
1652:
1653: -- log file
1654: fnd_file.put_line(FND_FILE.LOG,' ');
1655: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1656: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1657: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
1658: fnd_file.put_line(FND_FILE.LOG,'Intent : '||p_intent);
1659: fnd_file.put_line(FND_FILE.LOG,'Template Id : '||p_template_id);

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

1652:
1653: -- log file
1654: fnd_file.put_line(FND_FILE.LOG,' ');
1655: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1656: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1657: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
1658: fnd_file.put_line(FND_FILE.LOG,'Intent : '||p_intent);
1659: fnd_file.put_line(FND_FILE.LOG,'Template Id : '||p_template_id);
1660:

Line 1657: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);

1653: -- log file
1654: fnd_file.put_line(FND_FILE.LOG,' ');
1655: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1656: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1657: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
1658: fnd_file.put_line(FND_FILE.LOG,'Intent : '||p_intent);
1659: fnd_file.put_line(FND_FILE.LOG,'Template Id : '||p_template_id);
1660:
1661: -- Validate Parameters if p_template_id IS NOT NULL

Line 1658: fnd_file.put_line(FND_FILE.LOG,'Intent : '||p_intent);

1654: fnd_file.put_line(FND_FILE.LOG,' ');
1655: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1656: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1657: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
1658: fnd_file.put_line(FND_FILE.LOG,'Intent : '||p_intent);
1659: fnd_file.put_line(FND_FILE.LOG,'Template Id : '||p_template_id);
1660:
1661: -- Validate Parameters if p_template_id IS NOT NULL
1662: OPEN csr_tmpl_dtls;

Line 1659: fnd_file.put_line(FND_FILE.LOG,'Template Id : '||p_template_id);

1655: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1656: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1657: fnd_file.put_line(FND_FILE.LOG,'Org Id : '||p_org_id);
1658: fnd_file.put_line(FND_FILE.LOG,'Intent : '||p_intent);
1659: fnd_file.put_line(FND_FILE.LOG,'Template Id : '||p_template_id);
1660:
1661: -- Validate Parameters if p_template_id IS NOT NULL
1662: OPEN csr_tmpl_dtls;
1663: FETCH csr_tmpl_dtls INTO l_dummy;

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

1663: FETCH csr_tmpl_dtls INTO l_dummy;
1664: IF csr_tmpl_dtls%NOTFOUND THEN
1665: -- exit as no templates to be processed
1666: CLOSE csr_tmpl_dtls;
1667: fnd_file.put_line(FND_FILE.LOG,' ');
1668: fnd_file.put_line(FND_FILE.LOG,'No Templates to be synchronized ');
1669: fnd_file.put_line(FND_FILE.LOG,' ');
1670: retcode := 0;
1671: errbuf := '';

Line 1668: fnd_file.put_line(FND_FILE.LOG,'No Templates to be synchronized ');

1664: IF csr_tmpl_dtls%NOTFOUND THEN
1665: -- exit as no templates to be processed
1666: CLOSE csr_tmpl_dtls;
1667: fnd_file.put_line(FND_FILE.LOG,' ');
1668: fnd_file.put_line(FND_FILE.LOG,'No Templates to be synchronized ');
1669: fnd_file.put_line(FND_FILE.LOG,' ');
1670: retcode := 0;
1671: errbuf := '';
1672: RETURN;

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

1665: -- exit as no templates to be processed
1666: CLOSE csr_tmpl_dtls;
1667: fnd_file.put_line(FND_FILE.LOG,' ');
1668: fnd_file.put_line(FND_FILE.LOG,'No Templates to be synchronized ');
1669: fnd_file.put_line(FND_FILE.LOG,' ');
1670: retcode := 0;
1671: errbuf := '';
1672: RETURN;
1673: END IF; -- no rows to be processed

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

1679: CLOSE csr_active_rules_cnt;
1680:
1681: IF l_rule_count = 0 THEN
1682: -- no active rules
1683: fnd_file.put_line(FND_FILE.LOG,' ');
1684: fnd_file.put_line(FND_FILE.LOG,'No Active Rules for the Org and Intent');
1685: fnd_file.put_line(FND_FILE.LOG,' ');
1686: retcode := 0;
1687: errbuf := '';

Line 1684: fnd_file.put_line(FND_FILE.LOG,'No Active Rules for the Org and Intent');

1680:
1681: IF l_rule_count = 0 THEN
1682: -- no active rules
1683: fnd_file.put_line(FND_FILE.LOG,' ');
1684: fnd_file.put_line(FND_FILE.LOG,'No Active Rules for the Org and Intent');
1685: fnd_file.put_line(FND_FILE.LOG,' ');
1686: retcode := 0;
1687: errbuf := '';
1688: RETURN;

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

1681: IF l_rule_count = 0 THEN
1682: -- no active rules
1683: fnd_file.put_line(FND_FILE.LOG,' ');
1684: fnd_file.put_line(FND_FILE.LOG,'No Active Rules for the Org and Intent');
1685: fnd_file.put_line(FND_FILE.LOG,' ');
1686: retcode := 0;
1687: errbuf := '';
1688: RETURN;
1689: END IF; -- no active rules

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

1691: /*
1692: Step 1: Import Template Model(s)
1693: */
1694:
1695: fnd_file.put_line(FND_FILE.LOG,' ');
1696: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1697: fnd_file.put_line(FND_FILE.LOG,'Step 1: Importing Template Models');
1698: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1699: fnd_file.put_line(FND_FILE.LOG,' ');

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

1692: Step 1: Import Template Model(s)
1693: */
1694:
1695: fnd_file.put_line(FND_FILE.LOG,' ');
1696: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1697: fnd_file.put_line(FND_FILE.LOG,'Step 1: Importing Template Models');
1698: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1699: fnd_file.put_line(FND_FILE.LOG,' ');
1700:

Line 1697: fnd_file.put_line(FND_FILE.LOG,'Step 1: Importing Template Models');

1693: */
1694:
1695: fnd_file.put_line(FND_FILE.LOG,' ');
1696: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1697: fnd_file.put_line(FND_FILE.LOG,'Step 1: Importing Template Models');
1698: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1699: fnd_file.put_line(FND_FILE.LOG,' ');
1700:
1701: OKC_XPRT_IMPORT_TEMPLATE_PVT.rebuild_tmpl_sync

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

1694:
1695: fnd_file.put_line(FND_FILE.LOG,' ');
1696: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1697: fnd_file.put_line(FND_FILE.LOG,'Step 1: Importing Template Models');
1698: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1699: fnd_file.put_line(FND_FILE.LOG,' ');
1700:
1701: OKC_XPRT_IMPORT_TEMPLATE_PVT.rebuild_tmpl_sync
1702: (

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

1695: fnd_file.put_line(FND_FILE.LOG,' ');
1696: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1697: fnd_file.put_line(FND_FILE.LOG,'Step 1: Importing Template Models');
1698: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1699: fnd_file.put_line(FND_FILE.LOG,' ');
1700:
1701: OKC_XPRT_IMPORT_TEMPLATE_PVT.rebuild_tmpl_sync
1702: (
1703: p_org_id => p_org_id,

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

1707: x_msg_data => x_msg_data,
1708: x_msg_count => x_msg_count
1709: ) ;
1710:
1711: fnd_file.put_line(FND_FILE.LOG,' ');
1712: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Models');
1713: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1714: fnd_file.put_line(FND_FILE.LOG,' ');
1715:

Line 1712: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Models');

1708: x_msg_count => x_msg_count
1709: ) ;
1710:
1711: fnd_file.put_line(FND_FILE.LOG,' ');
1712: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Models');
1713: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1714: fnd_file.put_line(FND_FILE.LOG,' ');
1715:
1716: --- If any errors happen abort API

Line 1713: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

1709: ) ;
1710:
1711: fnd_file.put_line(FND_FILE.LOG,' ');
1712: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Models');
1713: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1714: fnd_file.put_line(FND_FILE.LOG,' ');
1715:
1716: --- If any errors happen abort API
1717: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

1710:
1711: fnd_file.put_line(FND_FILE.LOG,' ');
1712: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Models');
1713: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1714: fnd_file.put_line(FND_FILE.LOG,' ');
1715:
1716: --- If any errors happen abort API
1717: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1725: /*
1726: Step 2: Call the Test Publication API
1727: */
1728:
1729: fnd_file.put_line(FND_FILE.LOG,' ');
1730: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1731: fnd_file.put_line(FND_FILE.LOG,'Step 2: Calling the Test Publication API');
1732: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1733: fnd_file.put_line(FND_FILE.LOG,' ');

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

1726: Step 2: Call the Test Publication API
1727: */
1728:
1729: fnd_file.put_line(FND_FILE.LOG,' ');
1730: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1731: fnd_file.put_line(FND_FILE.LOG,'Step 2: Calling the Test Publication API');
1732: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1733: fnd_file.put_line(FND_FILE.LOG,' ');
1734:

Line 1731: fnd_file.put_line(FND_FILE.LOG,'Step 2: Calling the Test Publication API');

1727: */
1728:
1729: fnd_file.put_line(FND_FILE.LOG,' ');
1730: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1731: fnd_file.put_line(FND_FILE.LOG,'Step 2: Calling the Test Publication API');
1732: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1733: fnd_file.put_line(FND_FILE.LOG,' ');
1734:
1735: OKC_XPRT_UTIL_PVT.create_test_publication

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

1728:
1729: fnd_file.put_line(FND_FILE.LOG,' ');
1730: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1731: fnd_file.put_line(FND_FILE.LOG,'Step 2: Calling the Test Publication API');
1732: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1733: fnd_file.put_line(FND_FILE.LOG,' ');
1734:
1735: OKC_XPRT_UTIL_PVT.create_test_publication
1736: (

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

1729: fnd_file.put_line(FND_FILE.LOG,' ');
1730: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1731: fnd_file.put_line(FND_FILE.LOG,'Step 2: Calling the Test Publication API');
1732: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1733: fnd_file.put_line(FND_FILE.LOG,' ');
1734:
1735: OKC_XPRT_UTIL_PVT.create_test_publication
1736: (
1737: x_return_status => x_return_status,

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

1738: x_msg_data => x_msg_data,
1739: x_msg_count => x_msg_count
1740: );
1741:
1742: fnd_file.put_line(FND_FILE.LOG,' ');
1743: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
1744: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1745: fnd_file.put_line(FND_FILE.LOG,' ');
1746:

Line 1743: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');

1739: x_msg_count => x_msg_count
1740: );
1741:
1742: fnd_file.put_line(FND_FILE.LOG,' ');
1743: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
1744: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1745: fnd_file.put_line(FND_FILE.LOG,' ');
1746:
1747: --- If any errors happen abort API

Line 1744: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

1740: );
1741:
1742: fnd_file.put_line(FND_FILE.LOG,' ');
1743: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
1744: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1745: fnd_file.put_line(FND_FILE.LOG,' ');
1746:
1747: --- If any errors happen abort API
1748: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

1741:
1742: fnd_file.put_line(FND_FILE.LOG,' ');
1743: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
1744: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1745: fnd_file.put_line(FND_FILE.LOG,' ');
1746:
1747: --- If any errors happen abort API
1748: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1755: /*
1756: Step 3: Call the Production Publication API
1757: */
1758:
1759: fnd_file.put_line(FND_FILE.LOG,' ');
1760: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1761: fnd_file.put_line(FND_FILE.LOG,'Step 3: Calling the Production Publication API');
1762: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1763: fnd_file.put_line(FND_FILE.LOG,' ');

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

1756: Step 3: Call the Production Publication API
1757: */
1758:
1759: fnd_file.put_line(FND_FILE.LOG,' ');
1760: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1761: fnd_file.put_line(FND_FILE.LOG,'Step 3: Calling the Production Publication API');
1762: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1763: fnd_file.put_line(FND_FILE.LOG,' ');
1764:

Line 1761: fnd_file.put_line(FND_FILE.LOG,'Step 3: Calling the Production Publication API');

1757: */
1758:
1759: fnd_file.put_line(FND_FILE.LOG,' ');
1760: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1761: fnd_file.put_line(FND_FILE.LOG,'Step 3: Calling the Production Publication API');
1762: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1763: fnd_file.put_line(FND_FILE.LOG,' ');
1764:
1765: OKC_XPRT_UTIL_PVT.create_production_publication

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

1758:
1759: fnd_file.put_line(FND_FILE.LOG,' ');
1760: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1761: fnd_file.put_line(FND_FILE.LOG,'Step 3: Calling the Production Publication API');
1762: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1763: fnd_file.put_line(FND_FILE.LOG,' ');
1764:
1765: OKC_XPRT_UTIL_PVT.create_production_publication
1766: (

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

1759: fnd_file.put_line(FND_FILE.LOG,' ');
1760: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1761: fnd_file.put_line(FND_FILE.LOG,'Step 3: Calling the Production Publication API');
1762: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1763: fnd_file.put_line(FND_FILE.LOG,' ');
1764:
1765: OKC_XPRT_UTIL_PVT.create_production_publication
1766: (
1767: p_calling_mode => 'SYNC',

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

1770: x_msg_data => x_msg_data,
1771: x_msg_count => x_msg_count
1772: );
1773:
1774: fnd_file.put_line(FND_FILE.LOG,' ');
1775: fnd_file.put_line(FND_FILE.LOG,'After Calling the Production Publication API ');
1776: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1777: fnd_file.put_line(FND_FILE.LOG,' ');
1778:

Line 1775: fnd_file.put_line(FND_FILE.LOG,'After Calling the Production Publication API ');

1771: x_msg_count => x_msg_count
1772: );
1773:
1774: fnd_file.put_line(FND_FILE.LOG,' ');
1775: fnd_file.put_line(FND_FILE.LOG,'After Calling the Production Publication API ');
1776: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1777: fnd_file.put_line(FND_FILE.LOG,' ');
1778:
1779: --- If any errors happen abort API

Line 1776: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

1772: );
1773:
1774: fnd_file.put_line(FND_FILE.LOG,' ');
1775: fnd_file.put_line(FND_FILE.LOG,'After Calling the Production Publication API ');
1776: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1777: fnd_file.put_line(FND_FILE.LOG,' ');
1778:
1779: --- If any errors happen abort API
1780: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

1773:
1774: fnd_file.put_line(FND_FILE.LOG,' ');
1775: fnd_file.put_line(FND_FILE.LOG,'After Calling the Production Publication API ');
1776: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1777: fnd_file.put_line(FND_FILE.LOG,' ');
1778:
1779: --- If any errors happen abort API
1780: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1824: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);

1820:
1821: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1822: retcode := 2;
1823: errbuf := x_msg_data;
1824: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
1825: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1826: fnd_file.put_line(FND_FILE.LOG,' ');
1827:
1828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1825: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

1821: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1822: retcode := 2;
1823: errbuf := x_msg_data;
1824: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
1825: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1826: fnd_file.put_line(FND_FILE.LOG,' ');
1827:
1828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1829: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1822: retcode := 2;
1823: errbuf := x_msg_data;
1824: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
1825: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1826: fnd_file.put_line(FND_FILE.LOG,' ');
1827:
1828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1829: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1830: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1838: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);

1834:
1835: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1836: retcode := 2;
1837: errbuf := x_msg_data;
1838: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
1839: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1840: fnd_file.put_line(FND_FILE.LOG,' ');
1841:
1842: WHEN OTHERS THEN

Line 1839: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

1835: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1836: retcode := 2;
1837: errbuf := x_msg_data;
1838: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
1839: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1840: fnd_file.put_line(FND_FILE.LOG,' ');
1841:
1842: WHEN OTHERS THEN
1843: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1836: retcode := 2;
1837: errbuf := x_msg_data;
1838: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
1839: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1840: fnd_file.put_line(FND_FILE.LOG,' ');
1841:
1842: WHEN OTHERS THEN
1843: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1844: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1852: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);

1848:
1849: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1850: retcode := 2;
1851: errbuf := SQLERRM;
1852: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
1853: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1854: fnd_file.put_line(FND_FILE.LOG,' ');
1855:
1856: END rebuild_templates;

Line 1853: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

1849: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1850: retcode := 2;
1851: errbuf := SQLERRM;
1852: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
1853: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1854: fnd_file.put_line(FND_FILE.LOG,' ');
1855:
1856: END rebuild_templates;
1857:

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

1850: retcode := 2;
1851: errbuf := SQLERRM;
1852: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
1853: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
1854: fnd_file.put_line(FND_FILE.LOG,' ');
1855:
1856: END rebuild_templates;
1857:
1858: ---------------------------------------------------

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

1916: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1917: END IF;
1918:
1919: -- log file
1920: fnd_file.put_line(FND_FILE.LOG,' ');
1921: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1922: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1923: fnd_file.put_line(FND_FILE.LOG,'Template Id : '||p_template_id);
1924:

Line 1921: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

1917: END IF;
1918:
1919: -- log file
1920: fnd_file.put_line(FND_FILE.LOG,' ');
1921: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1922: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1923: fnd_file.put_line(FND_FILE.LOG,'Template Id : '||p_template_id);
1924:
1925: /*

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

1918:
1919: -- log file
1920: fnd_file.put_line(FND_FILE.LOG,' ');
1921: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1922: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1923: fnd_file.put_line(FND_FILE.LOG,'Template Id : '||p_template_id);
1924:
1925: /*
1926: Step 0: Template Rules QA checks

Line 1923: fnd_file.put_line(FND_FILE.LOG,'Template Id : '||p_template_id);

1919: -- log file
1920: fnd_file.put_line(FND_FILE.LOG,' ');
1921: fnd_file.put_line(FND_FILE.LOG,'Current Concurrent Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1922: fnd_file.put_line(FND_FILE.LOG,'Parameters ');
1923: fnd_file.put_line(FND_FILE.LOG,'Template Id : '||p_template_id);
1924:
1925: /*
1926: Step 0: Template Rules QA checks
1927: */

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

1925: /*
1926: Step 0: Template Rules QA checks
1927: */
1928:
1929: fnd_file.put_line(FND_FILE.LOG,' ');
1930: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1931: fnd_file.put_line(FND_FILE.LOG,'Step 0: Template Rules QA Checks ');
1932: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1933: fnd_file.put_line(FND_FILE.LOG,' ');

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

1926: Step 0: Template Rules QA checks
1927: */
1928:
1929: fnd_file.put_line(FND_FILE.LOG,' ');
1930: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1931: fnd_file.put_line(FND_FILE.LOG,'Step 0: Template Rules QA Checks ');
1932: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1933: fnd_file.put_line(FND_FILE.LOG,' ');
1934:

Line 1931: fnd_file.put_line(FND_FILE.LOG,'Step 0: Template Rules QA Checks ');

1927: */
1928:
1929: fnd_file.put_line(FND_FILE.LOG,' ');
1930: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1931: fnd_file.put_line(FND_FILE.LOG,'Step 0: Template Rules QA Checks ');
1932: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1933: fnd_file.put_line(FND_FILE.LOG,' ');
1934:
1935: OKC_XPRT_UTIL_PVT.check_rules_validity

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

1928:
1929: fnd_file.put_line(FND_FILE.LOG,' ');
1930: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1931: fnd_file.put_line(FND_FILE.LOG,'Step 0: Template Rules QA Checks ');
1932: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1933: fnd_file.put_line(FND_FILE.LOG,' ');
1934:
1935: OKC_XPRT_UTIL_PVT.check_rules_validity
1936: (

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

1929: fnd_file.put_line(FND_FILE.LOG,' ');
1930: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1931: fnd_file.put_line(FND_FILE.LOG,'Step 0: Template Rules QA Checks ');
1932: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1933: fnd_file.put_line(FND_FILE.LOG,' ');
1934:
1935: OKC_XPRT_UTIL_PVT.check_rules_validity
1936: (
1937: p_qa_mode => 'APPROVAL',

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

1942: x_msg_data => x_msg_data,
1943: x_msg_count => x_msg_count
1944: ) ;
1945:
1946: fnd_file.put_line(FND_FILE.LOG,' ');
1947: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');
1948: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1949: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);
1950: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);

Line 1947: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');

1943: x_msg_count => x_msg_count
1944: ) ;
1945:
1946: fnd_file.put_line(FND_FILE.LOG,' ');
1947: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');
1948: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1949: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);
1950: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);
1951: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1948: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

1944: ) ;
1945:
1946: fnd_file.put_line(FND_FILE.LOG,' ');
1947: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');
1948: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1949: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);
1950: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);
1951: fnd_file.put_line(FND_FILE.LOG,' ');
1952:

Line 1949: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);

1945:
1946: fnd_file.put_line(FND_FILE.LOG,' ');
1947: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');
1948: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1949: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);
1950: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);
1951: fnd_file.put_line(FND_FILE.LOG,' ');
1952:
1953: --- If any errors happen abort API

Line 1950: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);

1946: fnd_file.put_line(FND_FILE.LOG,' ');
1947: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');
1948: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1949: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);
1950: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);
1951: fnd_file.put_line(FND_FILE.LOG,' ');
1952:
1953: --- If any errors happen abort API
1954: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

1947: fnd_file.put_line(FND_FILE.LOG,'After OKC_XPRT_UTIL_PVT.check_rules_validity');
1948: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1949: fnd_file.put_line(FND_FILE.LOG,'x_qa_status: '||l_qa_status);
1950: fnd_file.put_line(FND_FILE.LOG,'x_sequence_id: '||l_sequence_id);
1951: fnd_file.put_line(FND_FILE.LOG,' ');
1952:
1953: --- If any errors happen abort API
1954: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1959:
1960: -- Check If any rules had QA errors and abort
1961: IF l_qa_status <> 'S' THEN
1962: -- exit as no rules had QA errors
1963: fnd_file.put_line(FND_FILE.LOG,' ');
1964: fnd_file.put_line(FND_FILE.LOG,'Template Rules QA Check failed');
1965: fnd_file.put_line(FND_FILE.LOG,' ');
1966:
1967: retcode := 2;

Line 1964: fnd_file.put_line(FND_FILE.LOG,'Template Rules QA Check failed');

1960: -- Check If any rules had QA errors and abort
1961: IF l_qa_status <> 'S' THEN
1962: -- exit as no rules had QA errors
1963: fnd_file.put_line(FND_FILE.LOG,' ');
1964: fnd_file.put_line(FND_FILE.LOG,'Template Rules QA Check failed');
1965: fnd_file.put_line(FND_FILE.LOG,' ');
1966:
1967: retcode := 2;
1968: errbuf := '';

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

1961: IF l_qa_status <> 'S' THEN
1962: -- exit as no rules had QA errors
1963: fnd_file.put_line(FND_FILE.LOG,' ');
1964: fnd_file.put_line(FND_FILE.LOG,'Template Rules QA Check failed');
1965: fnd_file.put_line(FND_FILE.LOG,' ');
1966:
1967: retcode := 2;
1968: errbuf := '';
1969: RETURN;

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

1975: /*
1976: Step 1: Import Template Model
1977: */
1978:
1979: fnd_file.put_line(FND_FILE.LOG,' ');
1980: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1981: fnd_file.put_line(FND_FILE.LOG,'Step 1: Importing Template Model');
1982: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1983: fnd_file.put_line(FND_FILE.LOG,' ');

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

1976: Step 1: Import Template Model
1977: */
1978:
1979: fnd_file.put_line(FND_FILE.LOG,' ');
1980: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1981: fnd_file.put_line(FND_FILE.LOG,'Step 1: Importing Template Model');
1982: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1983: fnd_file.put_line(FND_FILE.LOG,' ');
1984:

Line 1981: fnd_file.put_line(FND_FILE.LOG,'Step 1: Importing Template Model');

1977: */
1978:
1979: fnd_file.put_line(FND_FILE.LOG,' ');
1980: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1981: fnd_file.put_line(FND_FILE.LOG,'Step 1: Importing Template Model');
1982: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1983: fnd_file.put_line(FND_FILE.LOG,' ');
1984:
1985: OKC_XPRT_IMPORT_TEMPLATE_PVT.import_template

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

1978:
1979: fnd_file.put_line(FND_FILE.LOG,' ');
1980: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1981: fnd_file.put_line(FND_FILE.LOG,'Step 1: Importing Template Model');
1982: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1983: fnd_file.put_line(FND_FILE.LOG,' ');
1984:
1985: OKC_XPRT_IMPORT_TEMPLATE_PVT.import_template
1986: (

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

1979: fnd_file.put_line(FND_FILE.LOG,' ');
1980: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1981: fnd_file.put_line(FND_FILE.LOG,'Step 1: Importing Template Model');
1982: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1983: fnd_file.put_line(FND_FILE.LOG,' ');
1984:
1985: OKC_XPRT_IMPORT_TEMPLATE_PVT.import_template
1986: (
1987: p_api_version => 1,

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

1992: x_msg_data => x_msg_data,
1993: x_msg_count => x_msg_count
1994: ) ;
1995:
1996: fnd_file.put_line(FND_FILE.LOG,' ');
1997: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Model');
1998: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1999: fnd_file.put_line(FND_FILE.LOG,' ');
2000:

Line 1997: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Model');

1993: x_msg_count => x_msg_count
1994: ) ;
1995:
1996: fnd_file.put_line(FND_FILE.LOG,' ');
1997: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Model');
1998: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1999: fnd_file.put_line(FND_FILE.LOG,' ');
2000:
2001: --- If any errors happen abort API

Line 1998: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

1994: ) ;
1995:
1996: fnd_file.put_line(FND_FILE.LOG,' ');
1997: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Model');
1998: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1999: fnd_file.put_line(FND_FILE.LOG,' ');
2000:
2001: --- If any errors happen abort API
2002: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

1995:
1996: fnd_file.put_line(FND_FILE.LOG,' ');
1997: fnd_file.put_line(FND_FILE.LOG,'After Importing Template Model');
1998: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1999: fnd_file.put_line(FND_FILE.LOG,' ');
2000:
2001: --- If any errors happen abort API
2002: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2009: /*
2010: Step 2: Populate cz_imp_rules
2011: */
2012:
2013: fnd_file.put_line(FND_FILE.LOG,' ');
2014: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2015: fnd_file.put_line(FND_FILE.LOG,'Step 2: Populating cz_imp_rules ');
2016: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2017: fnd_file.put_line(FND_FILE.LOG,' ');

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

2010: Step 2: Populate cz_imp_rules
2011: */
2012:
2013: fnd_file.put_line(FND_FILE.LOG,' ');
2014: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2015: fnd_file.put_line(FND_FILE.LOG,'Step 2: Populating cz_imp_rules ');
2016: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2017: fnd_file.put_line(FND_FILE.LOG,' ');
2018:

Line 2015: fnd_file.put_line(FND_FILE.LOG,'Step 2: Populating cz_imp_rules ');

2011: */
2012:
2013: fnd_file.put_line(FND_FILE.LOG,' ');
2014: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2015: fnd_file.put_line(FND_FILE.LOG,'Step 2: Populating cz_imp_rules ');
2016: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2017: fnd_file.put_line(FND_FILE.LOG,' ');
2018:
2019: OKC_XPRT_IMPORT_RULES_PVT.import_rule_temp_approval

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

2012:
2013: fnd_file.put_line(FND_FILE.LOG,' ');
2014: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2015: fnd_file.put_line(FND_FILE.LOG,'Step 2: Populating cz_imp_rules ');
2016: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2017: fnd_file.put_line(FND_FILE.LOG,' ');
2018:
2019: OKC_XPRT_IMPORT_RULES_PVT.import_rule_temp_approval
2020: (

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

2013: fnd_file.put_line(FND_FILE.LOG,' ');
2014: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2015: fnd_file.put_line(FND_FILE.LOG,'Step 2: Populating cz_imp_rules ');
2016: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2017: fnd_file.put_line(FND_FILE.LOG,' ');
2018:
2019: OKC_XPRT_IMPORT_RULES_PVT.import_rule_temp_approval
2020: (
2021: p_template_id => p_template_id,

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

2024: x_msg_data => x_msg_data,
2025: x_msg_count => x_msg_count
2026: );
2027:
2028: fnd_file.put_line(FND_FILE.LOG,' ');
2029: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
2030: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2031: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
2032: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);

Line 2029: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');

2025: x_msg_count => x_msg_count
2026: );
2027:
2028: fnd_file.put_line(FND_FILE.LOG,' ');
2029: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
2030: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2031: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
2032: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
2033: fnd_file.put_line(FND_FILE.LOG,' ');

Line 2030: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

2026: );
2027:
2028: fnd_file.put_line(FND_FILE.LOG,' ');
2029: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
2030: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2031: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
2032: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
2033: fnd_file.put_line(FND_FILE.LOG,' ');
2034:

Line 2031: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);

2027:
2028: fnd_file.put_line(FND_FILE.LOG,' ');
2029: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
2030: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2031: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
2032: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
2033: fnd_file.put_line(FND_FILE.LOG,' ');
2034:
2035: --- If any errors happen abort API

Line 2032: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);

2028: fnd_file.put_line(FND_FILE.LOG,' ');
2029: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
2030: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2031: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
2032: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
2033: fnd_file.put_line(FND_FILE.LOG,' ');
2034:
2035: --- If any errors happen abort API
2036: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

2029: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
2030: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2031: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
2032: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
2033: fnd_file.put_line(FND_FILE.LOG,' ');
2034:
2035: --- If any errors happen abort API
2036: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2046: If there are no records in cz_imp_rules then Template has no rules attached
2047: Skip the rule import process
2048: */
2049:
2050: fnd_file.put_line(FND_FILE.LOG,' ');
2051: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2052: fnd_file.put_line(FND_FILE.LOG,'Step 2.1:Count Rules to be imported');
2053: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2054: fnd_file.put_line(FND_FILE.LOG,' ');

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

2047: Skip the rule import process
2048: */
2049:
2050: fnd_file.put_line(FND_FILE.LOG,' ');
2051: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2052: fnd_file.put_line(FND_FILE.LOG,'Step 2.1:Count Rules to be imported');
2053: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2054: fnd_file.put_line(FND_FILE.LOG,' ');
2055:

Line 2052: fnd_file.put_line(FND_FILE.LOG,'Step 2.1:Count Rules to be imported');

2048: */
2049:
2050: fnd_file.put_line(FND_FILE.LOG,' ');
2051: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2052: fnd_file.put_line(FND_FILE.LOG,'Step 2.1:Count Rules to be imported');
2053: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2054: fnd_file.put_line(FND_FILE.LOG,' ');
2055:
2056: OPEN csr_cz_imp_rules_cnt;

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

2049:
2050: fnd_file.put_line(FND_FILE.LOG,' ');
2051: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2052: fnd_file.put_line(FND_FILE.LOG,'Step 2.1:Count Rules to be imported');
2053: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2054: fnd_file.put_line(FND_FILE.LOG,' ');
2055:
2056: OPEN csr_cz_imp_rules_cnt;
2057: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;

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

2050: fnd_file.put_line(FND_FILE.LOG,' ');
2051: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2052: fnd_file.put_line(FND_FILE.LOG,'Step 2.1:Count Rules to be imported');
2053: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2054: fnd_file.put_line(FND_FILE.LOG,' ');
2055:
2056: OPEN csr_cz_imp_rules_cnt;
2057: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
2058: CLOSE csr_cz_imp_rules_cnt;

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

2056: OPEN csr_cz_imp_rules_cnt;
2057: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
2058: CLOSE csr_cz_imp_rules_cnt;
2059:
2060: fnd_file.put_line(FND_FILE.LOG,' ');
2061: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);
2062: fnd_file.put_line(FND_FILE.LOG,' ');
2063:
2064:

Line 2061: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);

2057: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
2058: CLOSE csr_cz_imp_rules_cnt;
2059:
2060: fnd_file.put_line(FND_FILE.LOG,' ');
2061: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);
2062: fnd_file.put_line(FND_FILE.LOG,' ');
2063:
2064:
2065: IF l_rules_cnt = 0 THEN

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

2058: CLOSE csr_cz_imp_rules_cnt;
2059:
2060: fnd_file.put_line(FND_FILE.LOG,' ');
2061: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);
2062: fnd_file.put_line(FND_FILE.LOG,' ');
2063:
2064:
2065: IF l_rules_cnt = 0 THEN
2066:

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

2063:
2064:
2065: IF l_rules_cnt = 0 THEN
2066:
2067: fnd_file.put_line(FND_FILE.LOG,' ');
2068: fnd_file.put_line(FND_FILE.LOG,'Template has no Rules attached');
2069: fnd_file.put_line(FND_FILE.LOG,' ');
2070:
2071: retcode := 0;

Line 2068: fnd_file.put_line(FND_FILE.LOG,'Template has no Rules attached');

2064:
2065: IF l_rules_cnt = 0 THEN
2066:
2067: fnd_file.put_line(FND_FILE.LOG,' ');
2068: fnd_file.put_line(FND_FILE.LOG,'Template has no Rules attached');
2069: fnd_file.put_line(FND_FILE.LOG,' ');
2070:
2071: retcode := 0;
2072: errbuf := '';

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

2065: IF l_rules_cnt = 0 THEN
2066:
2067: fnd_file.put_line(FND_FILE.LOG,' ');
2068: fnd_file.put_line(FND_FILE.LOG,'Template has no Rules attached');
2069: fnd_file.put_line(FND_FILE.LOG,' ');
2070:
2071: retcode := 0;
2072: errbuf := '';
2073: RETURN;

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

2077: /*
2078: Step 2.2: Insert Extension Rules in Template Approval Flow
2079: */
2080:
2081: fnd_file.put_line(FND_FILE.LOG,' ');
2082: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2083: fnd_file.put_line(FND_FILE.LOG,'Step 2.2: Calling API to insert extension rule records');
2084: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2085: fnd_file.put_line(FND_FILE.LOG,' ');

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

2078: Step 2.2: Insert Extension Rules in Template Approval Flow
2079: */
2080:
2081: fnd_file.put_line(FND_FILE.LOG,' ');
2082: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2083: fnd_file.put_line(FND_FILE.LOG,'Step 2.2: Calling API to insert extension rule records');
2084: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2085: fnd_file.put_line(FND_FILE.LOG,' ');
2086:

Line 2083: fnd_file.put_line(FND_FILE.LOG,'Step 2.2: Calling API to insert extension rule records');

2079: */
2080:
2081: fnd_file.put_line(FND_FILE.LOG,' ');
2082: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2083: fnd_file.put_line(FND_FILE.LOG,'Step 2.2: Calling API to insert extension rule records');
2084: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2085: fnd_file.put_line(FND_FILE.LOG,' ');
2086:
2087: OKC_XPRT_IMPORT_RULES_PVT.attach_extension_rule_tmpl

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

2080:
2081: fnd_file.put_line(FND_FILE.LOG,' ');
2082: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2083: fnd_file.put_line(FND_FILE.LOG,'Step 2.2: Calling API to insert extension rule records');
2084: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2085: fnd_file.put_line(FND_FILE.LOG,' ');
2086:
2087: OKC_XPRT_IMPORT_RULES_PVT.attach_extension_rule_tmpl
2088: (

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

2081: fnd_file.put_line(FND_FILE.LOG,' ');
2082: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2083: fnd_file.put_line(FND_FILE.LOG,'Step 2.2: Calling API to insert extension rule records');
2084: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2085: fnd_file.put_line(FND_FILE.LOG,' ');
2086:
2087: OKC_XPRT_IMPORT_RULES_PVT.attach_extension_rule_tmpl
2088: (
2089: p_api_version => 1,

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

2094: x_msg_data => x_msg_data,
2095: x_msg_count => x_msg_count
2096: );
2097:
2098: fnd_file.put_line(FND_FILE.LOG,' ');
2099: fnd_file.put_line(FND_FILE.LOG,'Step 2.2: After Calling API to insert extension rule records');
2100: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2101: fnd_file.put_line(FND_FILE.LOG,' ');
2102:

Line 2099: fnd_file.put_line(FND_FILE.LOG,'Step 2.2: After Calling API to insert extension rule records');

2095: x_msg_count => x_msg_count
2096: );
2097:
2098: fnd_file.put_line(FND_FILE.LOG,' ');
2099: fnd_file.put_line(FND_FILE.LOG,'Step 2.2: After Calling API to insert extension rule records');
2100: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2101: fnd_file.put_line(FND_FILE.LOG,' ');
2102:
2103:

Line 2100: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

2096: );
2097:
2098: fnd_file.put_line(FND_FILE.LOG,' ');
2099: fnd_file.put_line(FND_FILE.LOG,'Step 2.2: After Calling API to insert extension rule records');
2100: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2101: fnd_file.put_line(FND_FILE.LOG,' ');
2102:
2103:
2104:

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

2097:
2098: fnd_file.put_line(FND_FILE.LOG,' ');
2099: fnd_file.put_line(FND_FILE.LOG,'Step 2.2: After Calling API to insert extension rule records');
2100: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2101: fnd_file.put_line(FND_FILE.LOG,' ');
2102:
2103:
2104:
2105: /*

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

2106: Step 3: Call the CZ Rule Import Concurrent Program
2107: CZ Pgm: Import Configuration Rules (CZRULEIMPORTCP)
2108: */
2109:
2110: fnd_file.put_line(FND_FILE.LOG,' ');
2111: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2112: fnd_file.put_line(FND_FILE.LOG,'Step 3: Calling the CZ Rule Import Concurrent Program');
2113: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2114: fnd_file.put_line(FND_FILE.LOG,' ');

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

2107: CZ Pgm: Import Configuration Rules (CZRULEIMPORTCP)
2108: */
2109:
2110: fnd_file.put_line(FND_FILE.LOG,' ');
2111: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2112: fnd_file.put_line(FND_FILE.LOG,'Step 3: Calling the CZ Rule Import Concurrent Program');
2113: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2114: fnd_file.put_line(FND_FILE.LOG,' ');
2115: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);

Line 2112: fnd_file.put_line(FND_FILE.LOG,'Step 3: Calling the CZ Rule Import Concurrent Program');

2108: */
2109:
2110: fnd_file.put_line(FND_FILE.LOG,' ');
2111: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2112: fnd_file.put_line(FND_FILE.LOG,'Step 3: Calling the CZ Rule Import Concurrent Program');
2113: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2114: fnd_file.put_line(FND_FILE.LOG,' ');
2115: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);
2116:

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

2109:
2110: fnd_file.put_line(FND_FILE.LOG,' ');
2111: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2112: fnd_file.put_line(FND_FILE.LOG,'Step 3: Calling the CZ Rule Import Concurrent Program');
2113: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2114: fnd_file.put_line(FND_FILE.LOG,' ');
2115: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);
2116:
2117: FND_MESSAGE.set_name('OKC','OKC_XPRT_RULE_CCPRG_TMPL_MSG');

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

2110: fnd_file.put_line(FND_FILE.LOG,' ');
2111: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2112: fnd_file.put_line(FND_FILE.LOG,'Step 3: Calling the CZ Rule Import Concurrent Program');
2113: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2114: fnd_file.put_line(FND_FILE.LOG,' ');
2115: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);
2116:
2117: FND_MESSAGE.set_name('OKC','OKC_XPRT_RULE_CCPRG_TMPL_MSG');
2118: l_conc_pgm_desc := FND_MESSAGE.get;

Line 2115: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);

2111: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2112: fnd_file.put_line(FND_FILE.LOG,'Step 3: Calling the CZ Rule Import Concurrent Program');
2113: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2114: fnd_file.put_line(FND_FILE.LOG,' ');
2115: fnd_file.put_line(FND_FILE.LOG,'Parameter Run Id : '||G_RUN_ID);
2116:
2117: FND_MESSAGE.set_name('OKC','OKC_XPRT_RULE_CCPRG_TMPL_MSG');
2118: l_conc_pgm_desc := FND_MESSAGE.get;
2119:

Line 2129: fnd_file.put_line(FND_FILE.LOG,'Request Id of CZ Rule Concurrent Pgm : '||G_REQUEST_ID);

2125: sub_request => TRUE,
2126: argument1 => G_RUN_ID
2127: );
2128:
2129: fnd_file.put_line(FND_FILE.LOG,'Request Id of CZ Rule Concurrent Pgm : '||G_REQUEST_ID);
2130:
2131: -- commit the data
2132: COMMIT WORK;
2133:

Line 2138: fnd_file.put_line(FND_FILE.LOG,'Could NOT submit CZ Concurrent Program');

2134:
2135: IF NVL(G_REQUEST_ID,0) = 0 THEN
2136: -- Could Not submit Conc Pgm
2137: fnd_message.set_name('OKC','OKC_XPRT_SUB_CZ_RUL_PGM');
2138: fnd_file.put_line(FND_FILE.LOG,'Could NOT submit CZ Concurrent Program');
2139: RAISE FND_API.G_EXC_ERROR;
2140: ELSE
2141: -- child submission successful, pause the parent program
2142: fnd_conc_global.set_req_globals

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

2171: x_dev_status,
2172: x_message
2173: );
2174:
2175: fnd_file.put_line(FND_FILE.LOG,' ');
2176: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
2177: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
2178: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2179: fnd_file.put_line(FND_FILE.LOG,'Results ');

Line 2176: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);

2172: x_message
2173: );
2174:
2175: fnd_file.put_line(FND_FILE.LOG,' ');
2176: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
2177: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
2178: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2179: fnd_file.put_line(FND_FILE.LOG,'Results ');
2180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 2177: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);

2173: );
2174:
2175: fnd_file.put_line(FND_FILE.LOG,' ');
2176: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
2177: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
2178: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2179: fnd_file.put_line(FND_FILE.LOG,'Results ');
2180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2181: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);

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

2174:
2175: fnd_file.put_line(FND_FILE.LOG,' ');
2176: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
2177: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
2178: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2179: fnd_file.put_line(FND_FILE.LOG,'Results ');
2180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2181: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
2182: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);

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

2175: fnd_file.put_line(FND_FILE.LOG,' ');
2176: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
2177: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
2178: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2179: fnd_file.put_line(FND_FILE.LOG,'Results ');
2180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2181: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
2182: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
2183: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);

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

2176: fnd_file.put_line(FND_FILE.LOG,'After Completing CZ Rule Conc Pgm with request id :'||G_REQUEST_ID);
2177: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
2178: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2179: fnd_file.put_line(FND_FILE.LOG,'Results ');
2180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2181: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
2182: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
2183: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
2184: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);

Line 2181: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);

2177: fnd_file.put_line(FND_FILE.LOG,'Run Id : '||G_RUN_ID);
2178: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2179: fnd_file.put_line(FND_FILE.LOG,'Results ');
2180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2181: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
2182: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
2183: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
2184: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
2185: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));

Line 2182: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);

2178: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2179: fnd_file.put_line(FND_FILE.LOG,'Results ');
2180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2181: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
2182: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
2183: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
2184: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
2185: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
2186: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 2183: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);

2179: fnd_file.put_line(FND_FILE.LOG,'Results ');
2180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2181: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
2182: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
2183: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
2184: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
2185: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
2186: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2187: fnd_file.put_line(FND_FILE.LOG,' ');

Line 2184: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);

2180: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2181: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
2182: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
2183: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
2184: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
2185: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
2186: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2187: fnd_file.put_line(FND_FILE.LOG,' ');
2188:

Line 2185: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));

2181: fnd_file.put_line(FND_FILE.LOG,'Phase : '||x_phase);
2182: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
2183: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
2184: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
2185: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
2186: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2187: fnd_file.put_line(FND_FILE.LOG,' ');
2188:
2189: IF x_dev_phase <> 'COMPLETED' AND

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

2182: fnd_file.put_line(FND_FILE.LOG,'Status : '||x_status);
2183: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
2184: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
2185: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
2186: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2187: fnd_file.put_line(FND_FILE.LOG,' ');
2188:
2189: IF x_dev_phase <> 'COMPLETED' AND
2190: x_dev_status NOT IN ('NORMAL','WARNING') THEN

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

2183: fnd_file.put_line(FND_FILE.LOG,'dev_phase : '||x_dev_phase);
2184: fnd_file.put_line(FND_FILE.LOG,'dev_status : '||x_dev_status);
2185: fnd_file.put_line(FND_FILE.LOG,'Message : '||substr(x_message,1,100));
2186: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2187: fnd_file.put_line(FND_FILE.LOG,' ');
2188:
2189: IF x_dev_phase <> 'COMPLETED' AND
2190: x_dev_status NOT IN ('NORMAL','WARNING') THEN
2191: -- error in CZ Concurrent Program

Line 2192: fnd_file.put_line(FND_FILE.LOG, 'Error in CZ Rule Import Concurrent Program ');

2188:
2189: IF x_dev_phase <> 'COMPLETED' AND
2190: x_dev_status NOT IN ('NORMAL','WARNING') THEN
2191: -- error in CZ Concurrent Program
2192: fnd_file.put_line(FND_FILE.LOG, 'Error in CZ Rule Import Concurrent Program ');
2193: fnd_file.put_line(FND_FILE.LOG, 'Request Id :'||G_REQUEST_ID);
2194: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);
2195: RAISE FND_API.G_EXC_ERROR;
2196: END IF;

Line 2193: fnd_file.put_line(FND_FILE.LOG, 'Request Id :'||G_REQUEST_ID);

2189: IF x_dev_phase <> 'COMPLETED' AND
2190: x_dev_status NOT IN ('NORMAL','WARNING') THEN
2191: -- error in CZ Concurrent Program
2192: fnd_file.put_line(FND_FILE.LOG, 'Error in CZ Rule Import Concurrent Program ');
2193: fnd_file.put_line(FND_FILE.LOG, 'Request Id :'||G_REQUEST_ID);
2194: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);
2195: RAISE FND_API.G_EXC_ERROR;
2196: END IF;
2197:

Line 2194: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);

2190: x_dev_status NOT IN ('NORMAL','WARNING') THEN
2191: -- error in CZ Concurrent Program
2192: fnd_file.put_line(FND_FILE.LOG, 'Error in CZ Rule Import Concurrent Program ');
2193: fnd_file.put_line(FND_FILE.LOG, 'Request Id :'||G_REQUEST_ID);
2194: fnd_file.put_line(FND_FILE.LOG, 'Run Id :'||G_RUN_ID);
2195: RAISE FND_API.G_EXC_ERROR;
2196: END IF;
2197:
2198:

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

2199: /*
2200: Step 4: Check status of Rules Imported
2201: */
2202:
2203: fnd_file.put_line(FND_FILE.LOG,' ');
2204: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2205: fnd_file.put_line(FND_FILE.LOG,'Step 4: Checking Status of Rules imported');
2206: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2207: fnd_file.put_line(FND_FILE.LOG,' ');

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

2200: Step 4: Check status of Rules Imported
2201: */
2202:
2203: fnd_file.put_line(FND_FILE.LOG,' ');
2204: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2205: fnd_file.put_line(FND_FILE.LOG,'Step 4: Checking Status of Rules imported');
2206: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2207: fnd_file.put_line(FND_FILE.LOG,' ');
2208:

Line 2205: fnd_file.put_line(FND_FILE.LOG,'Step 4: Checking Status of Rules imported');

2201: */
2202:
2203: fnd_file.put_line(FND_FILE.LOG,' ');
2204: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2205: fnd_file.put_line(FND_FILE.LOG,'Step 4: Checking Status of Rules imported');
2206: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2207: fnd_file.put_line(FND_FILE.LOG,' ');
2208:
2209: OKC_XPRT_UTIL_PVT.check_import_status

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

2202:
2203: fnd_file.put_line(FND_FILE.LOG,' ');
2204: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2205: fnd_file.put_line(FND_FILE.LOG,'Step 4: Checking Status of Rules imported');
2206: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2207: fnd_file.put_line(FND_FILE.LOG,' ');
2208:
2209: OKC_XPRT_UTIL_PVT.check_import_status
2210: (

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

2203: fnd_file.put_line(FND_FILE.LOG,' ');
2204: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2205: fnd_file.put_line(FND_FILE.LOG,'Step 4: Checking Status of Rules imported');
2206: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2207: fnd_file.put_line(FND_FILE.LOG,' ');
2208:
2209: OKC_XPRT_UTIL_PVT.check_import_status
2210: (
2211: p_run_id => G_RUN_ID,

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

2215: x_msg_data => x_msg_data,
2216: x_msg_count => x_msg_count
2217: );
2218:
2219: fnd_file.put_line(FND_FILE.LOG,' ');
2220: fnd_file.put_line(FND_FILE.LOG,'After checking import status');
2221: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2222: fnd_file.put_line(FND_FILE.LOG,' ');
2223:

Line 2220: fnd_file.put_line(FND_FILE.LOG,'After checking import status');

2216: x_msg_count => x_msg_count
2217: );
2218:
2219: fnd_file.put_line(FND_FILE.LOG,' ');
2220: fnd_file.put_line(FND_FILE.LOG,'After checking import status');
2221: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2222: fnd_file.put_line(FND_FILE.LOG,' ');
2223:
2224: --- If any errors happen abort API

Line 2221: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

2217: );
2218:
2219: fnd_file.put_line(FND_FILE.LOG,' ');
2220: fnd_file.put_line(FND_FILE.LOG,'After checking import status');
2221: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2222: fnd_file.put_line(FND_FILE.LOG,' ');
2223:
2224: --- If any errors happen abort API
2225: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

2218:
2219: fnd_file.put_line(FND_FILE.LOG,' ');
2220: fnd_file.put_line(FND_FILE.LOG,'After checking import status');
2221: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2222: fnd_file.put_line(FND_FILE.LOG,' ');
2223:
2224: --- If any errors happen abort API
2225: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2232: /*
2233: Step 5: Call the Test Publication API
2234: */
2235:
2236: fnd_file.put_line(FND_FILE.LOG,' ');
2237: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2238: fnd_file.put_line(FND_FILE.LOG,'Step 5: Calling the Test Publication API');
2239: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2240: fnd_file.put_line(FND_FILE.LOG,' ');

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

2233: Step 5: Call the Test Publication API
2234: */
2235:
2236: fnd_file.put_line(FND_FILE.LOG,' ');
2237: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2238: fnd_file.put_line(FND_FILE.LOG,'Step 5: Calling the Test Publication API');
2239: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2240: fnd_file.put_line(FND_FILE.LOG,' ');
2241:

Line 2238: fnd_file.put_line(FND_FILE.LOG,'Step 5: Calling the Test Publication API');

2234: */
2235:
2236: fnd_file.put_line(FND_FILE.LOG,' ');
2237: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2238: fnd_file.put_line(FND_FILE.LOG,'Step 5: Calling the Test Publication API');
2239: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2240: fnd_file.put_line(FND_FILE.LOG,' ');
2241:
2242: OKC_XPRT_UTIL_PVT.create_test_publication

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

2235:
2236: fnd_file.put_line(FND_FILE.LOG,' ');
2237: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2238: fnd_file.put_line(FND_FILE.LOG,'Step 5: Calling the Test Publication API');
2239: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2240: fnd_file.put_line(FND_FILE.LOG,' ');
2241:
2242: OKC_XPRT_UTIL_PVT.create_test_publication
2243: (

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

2236: fnd_file.put_line(FND_FILE.LOG,' ');
2237: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2238: fnd_file.put_line(FND_FILE.LOG,'Step 5: Calling the Test Publication API');
2239: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2240: fnd_file.put_line(FND_FILE.LOG,' ');
2241:
2242: OKC_XPRT_UTIL_PVT.create_test_publication
2243: (
2244: x_return_status => x_return_status,

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

2245: x_msg_data => x_msg_data,
2246: x_msg_count => x_msg_count
2247: );
2248:
2249: fnd_file.put_line(FND_FILE.LOG,' ');
2250: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
2251: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2252: fnd_file.put_line(FND_FILE.LOG,' ');
2253:

Line 2250: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');

2246: x_msg_count => x_msg_count
2247: );
2248:
2249: fnd_file.put_line(FND_FILE.LOG,' ');
2250: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
2251: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2252: fnd_file.put_line(FND_FILE.LOG,' ');
2253:
2254: --- If any errors happen abort API

Line 2251: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);

2247: );
2248:
2249: fnd_file.put_line(FND_FILE.LOG,' ');
2250: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
2251: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2252: fnd_file.put_line(FND_FILE.LOG,' ');
2253:
2254: --- If any errors happen abort API
2255: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

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

2248:
2249: fnd_file.put_line(FND_FILE.LOG,' ');
2250: fnd_file.put_line(FND_FILE.LOG,'After Calling the Test Publication API ');
2251: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2252: fnd_file.put_line(FND_FILE.LOG,' ');
2253:
2254: --- If any errors happen abort API
2255: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2285: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);

2281:
2282: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2283: retcode := 2;
2284: errbuf := x_msg_data;
2285: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
2286: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
2287: fnd_file.put_line(FND_FILE.LOG,' ');
2288:
2289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2286: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

2282: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2283: retcode := 2;
2284: errbuf := x_msg_data;
2285: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
2286: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
2287: fnd_file.put_line(FND_FILE.LOG,' ');
2288:
2289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2290: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2283: retcode := 2;
2284: errbuf := x_msg_data;
2285: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_ERROR);
2286: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
2287: fnd_file.put_line(FND_FILE.LOG,' ');
2288:
2289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2290: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2291: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 2299: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);

2295:
2296: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2297: retcode := 2;
2298: errbuf := x_msg_data;
2299: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
2300: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
2301: fnd_file.put_line(FND_FILE.LOG,' ');
2302:
2303: WHEN OTHERS THEN

Line 2300: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

2296: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2297: retcode := 2;
2298: errbuf := x_msg_data;
2299: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
2300: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
2301: fnd_file.put_line(FND_FILE.LOG,' ');
2302:
2303: WHEN OTHERS THEN
2304: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2297: retcode := 2;
2298: errbuf := x_msg_data;
2299: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
2300: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
2301: fnd_file.put_line(FND_FILE.LOG,' ');
2302:
2303: WHEN OTHERS THEN
2304: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2305: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 2313: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);

2309:
2310: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2311: retcode := 2;
2312: errbuf := SQLERRM;
2313: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
2314: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
2315: fnd_file.put_line(FND_FILE.LOG,' ');
2316:
2317: END tmpl_approval_publish_rules;

Line 2314: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);

2310: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2311: retcode := 2;
2312: errbuf := SQLERRM;
2313: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
2314: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
2315: fnd_file.put_line(FND_FILE.LOG,' ');
2316:
2317: END tmpl_approval_publish_rules;
2318:

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

2311: retcode := 2;
2312: errbuf := SQLERRM;
2313: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||G_RET_STS_UNEXP_ERROR);
2314: fnd_file.put_line(FND_FILE.LOG,'errbuf : '||errbuf);
2315: fnd_file.put_line(FND_FILE.LOG,' ');
2316:
2317: END tmpl_approval_publish_rules;
2318:
2319: END OKC_XPRT_IMPORT_PVT ;