APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on FND_LOG

Line 15: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

11: ------------------------------------------------------------------------------
12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_XPRT_IMPORT_RULES_PVT';
13: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
14:
15: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
17: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
18:
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

Line 152: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

148:
149: BEGIN
150:
151: -- start debug log
152: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
154: G_MODULE||l_api_name,
155: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
156: END IF;

Line 153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

149: BEGIN
150:
151: -- start debug log
152: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
154: G_MODULE||l_api_name,
155: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
156: END IF;
157:

Line 170: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

166: FETCH csr_rule_dtls INTO l_org_id, l_intent, l_condition_expr_code,l_rule_type;
167: CLOSE csr_rule_dtls;
168:
169: -- debug log
170: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
172: G_MODULE||l_api_name,
173: '150: p_rule_id :'||p_rule_id);
174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

167: CLOSE csr_rule_dtls;
168:
169: -- debug log
170: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
172: G_MODULE||l_api_name,
173: '150: p_rule_id :'||p_rule_id);
174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
175: G_MODULE||l_api_name,

Line 174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

170: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
172: G_MODULE||l_api_name,
173: '150: p_rule_id :'||p_rule_id);
174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
175: G_MODULE||l_api_name,
176: '150: p_template_id :'||p_template_id);
177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
178: G_MODULE||l_api_name,

Line 177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

173: '150: p_rule_id :'||p_rule_id);
174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
175: G_MODULE||l_api_name,
176: '150: p_template_id :'||p_template_id);
177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
178: G_MODULE||l_api_name,
179: '150: l_org_id :'||l_org_id);
180: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
181: G_MODULE||l_api_name,

Line 180: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

176: '150: p_template_id :'||p_template_id);
177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
178: G_MODULE||l_api_name,
179: '150: l_org_id :'||l_org_id);
180: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
181: G_MODULE||l_api_name,
182: '150: l_intent :'||l_intent);
183: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
184: G_MODULE||l_api_name,

Line 183: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

179: '150: l_org_id :'||l_org_id);
180: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
181: G_MODULE||l_api_name,
182: '150: l_intent :'||l_intent);
183: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
184: G_MODULE||l_api_name,
185: '150: l_condition_expr_code :'||l_condition_expr_code);
186: END IF;
187:

Line 224: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

220: */
221:
222:
223: -- debug log
224: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
225: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
226: G_MODULE||l_api_name,
227: '200: l_clause_prefix :'||l_clause_prefix);
228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 225: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

221:
222:
223: -- debug log
224: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
225: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
226: G_MODULE||l_api_name,
227: '200: l_clause_prefix :'||l_clause_prefix);
228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
229: G_MODULE||l_api_name,

Line 228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

224: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
225: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
226: G_MODULE||l_api_name,
227: '200: l_clause_prefix :'||l_clause_prefix);
228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
229: G_MODULE||l_api_name,
230: '200: l_system_var_prefix :'||l_system_var_prefix);
231: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
232: G_MODULE||l_api_name,

Line 231: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

227: '200: l_clause_prefix :'||l_clause_prefix);
228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
229: G_MODULE||l_api_name,
230: '200: l_system_var_prefix :'||l_system_var_prefix);
231: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
232: G_MODULE||l_api_name,
233: '200: l_question_prefix :'||l_question_prefix);
234: END IF;
235:

Line 249: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

245: l_object_value_type;
246: EXIT WHEN csr_rule_conditions%NOTFOUND;
247:
248: -- debug log
249: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
251: G_MODULE||l_api_name,
252: '250: ******* Condition *********');
253: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

246: EXIT WHEN csr_rule_conditions%NOTFOUND;
247:
248: -- debug log
249: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
251: G_MODULE||l_api_name,
252: '250: ******* Condition *********');
253: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
254: G_MODULE||l_api_name,

Line 253: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

249: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
251: G_MODULE||l_api_name,
252: '250: ******* Condition *********');
253: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
254: G_MODULE||l_api_name,
255: '250: l_rule_condition_id :'||l_rule_condition_id);
256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
257: G_MODULE||l_api_name,

Line 256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

252: '250: ******* Condition *********');
253: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
254: G_MODULE||l_api_name,
255: '250: l_rule_condition_id :'||l_rule_condition_id);
256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
257: G_MODULE||l_api_name,
258: '250: l_object_type :'||l_object_type);
259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
260: G_MODULE||l_api_name,

Line 259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

255: '250: l_rule_condition_id :'||l_rule_condition_id);
256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
257: G_MODULE||l_api_name,
258: '250: l_object_type :'||l_object_type);
259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
260: G_MODULE||l_api_name,
261: '250:l_object_code :'||l_object_code);
262: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
263: G_MODULE||l_api_name,

Line 262: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

258: '250: l_object_type :'||l_object_type);
259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
260: G_MODULE||l_api_name,
261: '250:l_object_code :'||l_object_code);
262: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
263: G_MODULE||l_api_name,
264: '250: l_object_code_datatype :'||l_object_code_datatype);
265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
266: G_MODULE||l_api_name,

Line 265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

261: '250:l_object_code :'||l_object_code);
262: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
263: G_MODULE||l_api_name,
264: '250: l_object_code_datatype :'||l_object_code_datatype);
265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
266: G_MODULE||l_api_name,
267: '250: l_operator :'||l_operator);
268: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
269: G_MODULE||l_api_name,

Line 268: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

264: '250: l_object_code_datatype :'||l_object_code_datatype);
265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
266: G_MODULE||l_api_name,
267: '250: l_operator :'||l_operator);
268: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
269: G_MODULE||l_api_name,
270: '250: l_object_value_type :'||l_object_value_type);
271: END IF;
272:

Line 332: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

328: FETCH csr_rule_cond_vals INTO l_object_value_code;
329: EXIT WHEN csr_rule_cond_vals%NOTFOUND;
330:
331: -- debug log
332: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
334: G_MODULE||l_api_name,
335: '350: ####### Condition Values #######');
336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

329: EXIT WHEN csr_rule_cond_vals%NOTFOUND;
330:
331: -- debug log
332: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
334: G_MODULE||l_api_name,
335: '350: ####### Condition Values #######');
336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
337: G_MODULE||l_api_name,

Line 336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

332: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
333: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
334: G_MODULE||l_api_name,
335: '350: ####### Condition Values #######');
336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
337: G_MODULE||l_api_name,
338: '350: l_object_value_code :'||l_object_value_code);
339: END IF;
340:

Line 521: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

517: CLOSE csr_rule_conditions;
518:
519:
520: -- debug log
521: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
522: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
523: G_MODULE||l_api_name,
524: '600: Building Outcome String');
525: END IF;

Line 522: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

518:
519:
520: -- debug log
521: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
522: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
523: G_MODULE||l_api_name,
524: '600: Building Outcome String');
525: END IF;
526:

Line 586: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

582: CLOSE csr_rule_outcomes;
583: END IF;
584:
585: -- debug log
586: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
588: G_MODULE||l_api_name,
589: '750: After Building Outcome String ');
590: END IF;

Line 587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

583: END IF;
584:
585: -- debug log
586: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
587: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
588: G_MODULE||l_api_name,
589: '750: After Building Outcome String ');
590: END IF;
591:

Line 622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

618: --
619:
620:
621: -- end debug log
622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
624: G_MODULE||l_api_name,
625: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
626: END IF;

Line 623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

619:
620:
621: -- end debug log
622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
624: G_MODULE||l_api_name,
625: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
626: END IF;
627:

Line 630: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

626: END IF;
627:
628: EXCEPTION
629: WHEN FND_API.G_EXC_ERROR THEN
630: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
631: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
632: G_MODULE||l_api_name,
633: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
634: END IF;

Line 631: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

627:
628: EXCEPTION
629: WHEN FND_API.G_EXC_ERROR THEN
630: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
631: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
632: G_MODULE||l_api_name,
633: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
634: END IF;
635:

Line 646: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

642:
643: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
644:
645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
646: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
647: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
648: G_MODULE||l_api_name,
649: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
650: END IF;

Line 647: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

643: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
644:
645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
646: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
647: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
648: G_MODULE||l_api_name,
649: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
650: END IF;
651:

Line 661: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

657: x_msg_data := SQLERRM;
658: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
659:
660: WHEN OTHERS THEN
661: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
663: G_MODULE||l_api_name,
664: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
665: END IF;

Line 662: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

658: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
659:
660: WHEN OTHERS THEN
661: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
663: G_MODULE||l_api_name,
664: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
665: END IF;
666:

Line 768: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

764:
765:
766: BEGIN
767: -- start debug log
768: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
769: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
770: G_MODULE||l_api_name,
771: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
772: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 769: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

765:
766: BEGIN
767: -- start debug log
768: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
769: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
770: G_MODULE||l_api_name,
771: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
772: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
773: G_MODULE||l_api_name,

Line 772: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

768: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
769: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
770: G_MODULE||l_api_name,
771: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
772: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
773: G_MODULE||l_api_name,
774: '100: Parameters ');
775: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
776: G_MODULE||l_api_name,

Line 775: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

771: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
772: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
773: G_MODULE||l_api_name,
774: '100: Parameters ');
775: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
776: G_MODULE||l_api_name,
777: '100: p_rule_id : '||p_rule_id);
778: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
779: G_MODULE||l_api_name,

Line 778: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

774: '100: Parameters ');
775: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
776: G_MODULE||l_api_name,
777: '100: p_rule_id : '||p_rule_id);
778: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
779: G_MODULE||l_api_name,
780: '100: p_template_id : '||p_template_id);
781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
782: G_MODULE||l_api_name,

Line 781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

777: '100: p_rule_id : '||p_rule_id);
778: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
779: G_MODULE||l_api_name,
780: '100: p_template_id : '||p_template_id);
781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
782: G_MODULE||l_api_name,
783: '100: p_run_id : '||p_run_id);
784: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
785: G_MODULE||l_api_name,

Line 784: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

780: '100: p_template_id : '||p_template_id);
781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
782: G_MODULE||l_api_name,
783: '100: p_run_id : '||p_run_id);
784: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
785: G_MODULE||l_api_name,
786: '100: p_mode : '||p_mode);
787: END IF;
788:

Line 809: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

805: l_template_id;
806:
807: IF csr_template_dtls%NOTFOUND THEN
808: -- debug Log
809: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
810: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
811: G_MODULE||l_api_name,
812: '110: Invalid Template Id: '||p_template_id);
813: END IF;

Line 810: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

806:
807: IF csr_template_dtls%NOTFOUND THEN
808: -- debug Log
809: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
810: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
811: G_MODULE||l_api_name,
812: '110: Invalid Template Id: '||p_template_id);
813: END IF;
814: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TEMPLATE');

Line 836: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

832: FETCH csr_template_model_id INTO l_model_id, l_model_osr;
833:
834: IF csr_template_model_id%NOTFOUND THEN
835: -- debug Log
836: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
837: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
838: G_MODULE||l_api_name,
839: '110: Template Model Does Not Exists : '||l_template_name);
840: END IF;

Line 837: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

833:
834: IF csr_template_model_id%NOTFOUND THEN
835: -- debug Log
836: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
837: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
838: G_MODULE||l_api_name,
839: '110: Template Model Does Not Exists : '||l_template_name);
840: END IF;
841: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TMPL_MODEL');

Line 849: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

845:
846: CLOSE csr_template_model_id;
847:
848: -- debug Log
849: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
850: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
851: G_MODULE||l_api_name,
852: '120: Template Name : '||l_template_name);
853: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 850: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

846: CLOSE csr_template_model_id;
847:
848: -- debug Log
849: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
850: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
851: G_MODULE||l_api_name,
852: '120: Template Name : '||l_template_name);
853: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
854: G_MODULE||l_api_name,

Line 853: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

849: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
850: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
851: G_MODULE||l_api_name,
852: '120: Template Name : '||l_template_name);
853: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
854: G_MODULE||l_api_name,
855: '120: Derived Template Id : '||l_template_id);
856: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
857: G_MODULE||l_api_name,

Line 856: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

852: '120: Template Name : '||l_template_name);
853: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
854: G_MODULE||l_api_name,
855: '120: Derived Template Id : '||l_template_id);
856: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
857: G_MODULE||l_api_name,
858: '120: Template Model Id : '||l_model_id);
859: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
860: G_MODULE||l_api_name,

Line 859: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

855: '120: Derived Template Id : '||l_template_id);
856: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
857: G_MODULE||l_api_name,
858: '120: Template Model Id : '||l_model_id);
859: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
860: G_MODULE||l_api_name,
861: '120: Template Model OSR : '||l_model_osr);
862: END IF;
863:

Line 1167: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1163: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1164:
1165:
1166: -- end debug log
1167: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1168: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1169: G_MODULE||l_api_name,
1170: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1171: END IF;

Line 1168: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1164:
1165:
1166: -- end debug log
1167: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1168: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1169: G_MODULE||l_api_name,
1170: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1171: END IF;
1172:

Line 1175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1171: END IF;
1172:
1173: EXCEPTION
1174: WHEN FND_API.G_EXC_ERROR THEN
1175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1177: G_MODULE||l_api_name,
1178: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1179: END IF;

Line 1176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1172:
1173: EXCEPTION
1174: WHEN FND_API.G_EXC_ERROR THEN
1175: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1177: G_MODULE||l_api_name,
1178: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1179: END IF;
1180:

Line 1190: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1186: x_msg_data := SQLERRM;
1187: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1188:
1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1190: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1191: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1192: G_MODULE||l_api_name,
1193: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1194: END IF;

Line 1191: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1187: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1188:
1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1190: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1191: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1192: G_MODULE||l_api_name,
1193: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1194: END IF;
1195:

Line 1205: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1201: x_msg_data := SQLERRM;
1202: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1203:
1204: WHEN OTHERS THEN
1205: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1206: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1207: G_MODULE||l_api_name,
1208: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1209: END IF;

Line 1206: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1202: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1203:
1204: WHEN OTHERS THEN
1205: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1206: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1207: G_MODULE||l_api_name,
1208: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1209: END IF;
1210:

Line 1328: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1324:
1325:
1326: BEGIN
1327: -- start debug log
1328: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1329: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1330: G_MODULE||l_api_name,
1331: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1332: END IF;

Line 1329: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1325:
1326: BEGIN
1327: -- start debug log
1328: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1329: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1330: G_MODULE||l_api_name,
1331: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1332: END IF;
1333:

Line 1342: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1338: FETCH csr_cz_run_id INTO x_run_id;
1339: CLOSE csr_cz_run_id;
1340:
1341: -- debug log
1342: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1343: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1344: G_MODULE||l_api_name,
1345: '110: Rule Import x_run_id : '|| x_run_id);
1346: END IF;

Line 1343: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1339: CLOSE csr_cz_run_id;
1340:
1341: -- debug log
1342: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1343: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1344: G_MODULE||l_api_name,
1345: '110: Rule Import x_run_id : '|| x_run_id);
1346: END IF;
1347:

Line 1424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1420: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1421:
1422:
1423: -- end debug log
1424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1425: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1426: G_MODULE||l_api_name,
1427: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1428: END IF;

Line 1425: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1421:
1422:
1423: -- end debug log
1424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1425: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1426: G_MODULE||l_api_name,
1427: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1428: END IF;
1429:

Line 1432: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1428: END IF;
1429:
1430: EXCEPTION
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1434: G_MODULE||l_api_name,
1435: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1436: END IF;

Line 1433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1429:
1430: EXCEPTION
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1434: G_MODULE||l_api_name,
1435: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1436: END IF;
1437:

Line 1442: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1438: x_return_status := G_RET_STS_ERROR ;
1439: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1440:
1441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1442: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1444: G_MODULE||l_api_name,
1445: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1446: END IF;

Line 1443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1439: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1440:
1441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1442: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1443: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1444: G_MODULE||l_api_name,
1445: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1446: END IF;
1447:

Line 1452: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1448: x_return_status := G_RET_STS_UNEXP_ERROR ;
1449: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1450:
1451: WHEN OTHERS THEN
1452: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1453: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1454: G_MODULE||l_api_name,
1455: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1456: END IF;

Line 1453: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1449: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1450:
1451: WHEN OTHERS THEN
1452: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1453: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1454: G_MODULE||l_api_name,
1455: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1456: END IF;
1457:

Line 1517: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1513:
1514:
1515: BEGIN
1516: -- start debug log
1517: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1518: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1519: G_MODULE||l_api_name,
1520: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1521: END IF;

Line 1518: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1514:
1515: BEGIN
1516: -- start debug log
1517: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1518: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1519: G_MODULE||l_api_name,
1520: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1521: END IF;
1522:

Line 1531: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1527: FETCH csr_cz_run_id INTO x_run_id;
1528: CLOSE csr_cz_run_id;
1529:
1530: -- debug log
1531: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1532: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1533: G_MODULE||l_api_name,
1534: '110: Rule Import x_run_id : '|| x_run_id);
1535: END IF;

Line 1532: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1528: CLOSE csr_cz_run_id;
1529:
1530: -- debug log
1531: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1532: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1533: G_MODULE||l_api_name,
1534: '110: Rule Import x_run_id : '|| x_run_id);
1535: END IF;
1536:

Line 1581: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1577: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1578:
1579:
1580: -- end debug log
1581: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1582: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1583: G_MODULE||l_api_name,
1584: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1585: END IF;

Line 1582: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1578:
1579:
1580: -- end debug log
1581: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1582: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1583: G_MODULE||l_api_name,
1584: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1585: END IF;
1586:

Line 1589: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1585: END IF;
1586:
1587: EXCEPTION
1588: WHEN FND_API.G_EXC_ERROR THEN
1589: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1591: G_MODULE||l_api_name,
1592: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1593: END IF;

Line 1590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1586:
1587: EXCEPTION
1588: WHEN FND_API.G_EXC_ERROR THEN
1589: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1590: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1591: G_MODULE||l_api_name,
1592: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1593: END IF;
1594:

Line 1599: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1595: x_return_status := G_RET_STS_ERROR ;
1596: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1597:
1598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1599: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1600: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1601: G_MODULE||l_api_name,
1602: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1603: END IF;

Line 1600: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1596: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1597:
1598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1599: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1600: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1601: G_MODULE||l_api_name,
1602: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1603: END IF;
1604:

Line 1609: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1605: x_return_status := G_RET_STS_UNEXP_ERROR ;
1606: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1607:
1608: WHEN OTHERS THEN
1609: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1610: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1611: G_MODULE||l_api_name,
1612: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1613: END IF;

Line 1610: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1606: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1607:
1608: WHEN OTHERS THEN
1609: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1610: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1611: G_MODULE||l_api_name,
1612: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1613: END IF;
1614:

Line 1702: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1698:
1699:
1700: BEGIN
1701: -- start debug log
1702: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1704: G_MODULE||l_api_name,
1705: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1706: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1699:
1700: BEGIN
1701: -- start debug log
1702: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1704: G_MODULE||l_api_name,
1705: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1706: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1707: G_MODULE||l_api_name,

Line 1706: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1702: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1704: G_MODULE||l_api_name,
1705: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1706: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1707: G_MODULE||l_api_name,
1708: '100: Parameters ');
1709: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1710: G_MODULE||l_api_name,

Line 1709: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1705: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1706: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1707: G_MODULE||l_api_name,
1708: '100: Parameters ');
1709: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1710: G_MODULE||l_api_name,
1711: '100: p_template_id : '||p_template_id);
1712: END IF;
1713:

Line 1729: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1725: FETCH csr_template_dtls INTO l_parent_template_id;
1726:
1727: IF csr_template_dtls%NOTFOUND THEN
1728: -- Log Error
1729: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1730: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1731: G_MODULE||l_api_name,
1732: '110: Invalid Template Id: '||p_template_id);
1733: END IF;

Line 1730: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1726:
1727: IF csr_template_dtls%NOTFOUND THEN
1728: -- Log Error
1729: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1730: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1731: G_MODULE||l_api_name,
1732: '110: Invalid Template Id: '||p_template_id);
1733: END IF;
1734: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TEMPLATE');

Line 1743: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1739:
1740:
1741:
1742: -- debug log
1743: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1744: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1745: G_MODULE||l_api_name,
1746: '110: Rule Import x_run_id : '|| x_run_id);
1747: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1744: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1740:
1741:
1742: -- debug log
1743: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1744: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1745: G_MODULE||l_api_name,
1746: '110: Rule Import x_run_id : '|| x_run_id);
1747: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1748: G_MODULE||l_api_name,

Line 1747: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1743: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1744: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1745: G_MODULE||l_api_name,
1746: '110: Rule Import x_run_id : '|| x_run_id);
1747: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1748: G_MODULE||l_api_name,
1749: '110: p_template_id : '|| p_template_id);
1750: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1751: G_MODULE||l_api_name,

Line 1750: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1746: '110: Rule Import x_run_id : '|| x_run_id);
1747: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1748: G_MODULE||l_api_name,
1749: '110: p_template_id : '|| p_template_id);
1750: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1751: G_MODULE||l_api_name,
1752: '110: l_parent_template_id '|| l_parent_template_id);
1753: END IF;
1754:

Line 1812: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1808: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1809:
1810:
1811: -- end debug log
1812: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1813: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1814: G_MODULE||l_api_name,
1815: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1816: END IF;

Line 1813: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1809:
1810:
1811: -- end debug log
1812: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1813: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1814: G_MODULE||l_api_name,
1815: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1816: END IF;
1817:

Line 1820: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1816: END IF;
1817:
1818: EXCEPTION
1819: WHEN FND_API.G_EXC_ERROR THEN
1820: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1821: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1822: G_MODULE||l_api_name,
1823: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1824: END IF;

Line 1821: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1817:
1818: EXCEPTION
1819: WHEN FND_API.G_EXC_ERROR THEN
1820: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1821: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1822: G_MODULE||l_api_name,
1823: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1824: END IF;
1825:

Line 1834: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1830: x_return_status := G_RET_STS_ERROR ;
1831: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1832:
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1834: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1835: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1836: G_MODULE||l_api_name,
1837: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1838: END IF;

Line 1835: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1831: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1832:
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1834: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1835: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1836: G_MODULE||l_api_name,
1837: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1838: END IF;
1839:

Line 1848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1844: x_return_status := G_RET_STS_UNEXP_ERROR ;
1845: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1846:
1847: WHEN OTHERS THEN
1848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1849: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1850: G_MODULE||l_api_name,
1851: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1852: END IF;

Line 1849: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1845: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1846:
1847: WHEN OTHERS THEN
1848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1849: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1850: G_MODULE||l_api_name,
1851: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1852: END IF;
1853:

Line 1985: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1981: l_cz_imp_rules cz_imp_rules%ROWTYPE;
1982:
1983: BEGIN
1984: -- start debug log
1985: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1986: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1987: G_MODULE||l_api_name,
1988: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1989: END IF;

Line 1986: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1982:
1983: BEGIN
1984: -- start debug log
1985: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1986: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1987: G_MODULE||l_api_name,
1988: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1989: END IF;
1990:

Line 2007: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2003: LOOP
2004: FETCH csr_intents INTO l_intent,l_org_id;
2005: EXIT WHEN csr_intents%NOTFOUND;
2006:
2007: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2008: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2009: G_MODULE||l_api_name,
2010: '110: l_intent ' || '='||l_intent);
2011: END IF;

Line 2008: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2004: FETCH csr_intents INTO l_intent,l_org_id;
2005: EXIT WHEN csr_intents%NOTFOUND;
2006:
2007: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2008: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2009: G_MODULE||l_api_name,
2010: '110: l_intent ' || '='||l_intent);
2011: END IF;
2012:

Line 2021: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2017: RAISE FND_API.G_EXC_ERROR;
2018: END IF;
2019: CLOSE csr_get_cla_model_dtl;
2020:
2021: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2022: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2023: G_MODULE||l_api_name,
2024: '120: l_model_id ' || '='||l_model_id);
2025: END IF;

Line 2022: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2018: END IF;
2019: CLOSE csr_get_cla_model_dtl;
2020:
2021: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2022: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2023: G_MODULE||l_api_name,
2024: '120: l_model_id ' || '='||l_model_id);
2025: END IF;
2026:

Line 2027: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2023: G_MODULE||l_api_name,
2024: '120: l_model_id ' || '='||l_model_id);
2025: END IF;
2026:
2027: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2028: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2029: G_MODULE||l_api_name,
2030: '130: l_model_osr ' || '='||l_model_osr);
2031: END IF;

Line 2028: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2024: '120: l_model_id ' || '='||l_model_id);
2025: END IF;
2026:
2027: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2028: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2029: G_MODULE||l_api_name,
2030: '130: l_model_osr ' || '='||l_model_osr);
2031: END IF;
2032:

Line 2308: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2304: l_cz_imp_rules.IMPORT_PROG_VERSION,
2305: l_cz_imp_rules.FSK_COMPONENT_ID,
2306: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2307: );
2308: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2309: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2310: G_MODULE||l_api_name,
2311: '170: After Insert into cz_imp_rules' || '='||l_intent);
2312: END IF;

Line 2309: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2305: l_cz_imp_rules.FSK_COMPONENT_ID,
2306: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2307: );
2308: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2309: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2310: G_MODULE||l_api_name,
2311: '170: After Insert into cz_imp_rules' || '='||l_intent);
2312: END IF;
2313:

Line 2325: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2321: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2322:
2323:
2324: -- end debug log
2325: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2327: G_MODULE||l_api_name,
2328: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2329: END IF;

Line 2326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2322:
2323:
2324: -- end debug log
2325: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2327: G_MODULE||l_api_name,
2328: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2329: END IF;
2330:

Line 2333: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2329: END IF;
2330:
2331: EXCEPTION
2332: WHEN FND_API.G_EXC_ERROR THEN
2333: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2334: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2335: G_MODULE||l_api_name,
2336: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2337: END IF;

Line 2334: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2330:
2331: EXCEPTION
2332: WHEN FND_API.G_EXC_ERROR THEN
2333: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2334: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2335: G_MODULE||l_api_name,
2336: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2337: END IF;
2338:

Line 2343: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2339: x_return_status := G_RET_STS_ERROR ;
2340: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2341:
2342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2343: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2344: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2345: G_MODULE||l_api_name,
2346: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2347: END IF;

Line 2344: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2340: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2341:
2342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2343: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2344: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2345: G_MODULE||l_api_name,
2346: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2347: END IF;
2348:

Line 2353: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2349: x_return_status := G_RET_STS_UNEXP_ERROR ;
2350: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2351:
2352: WHEN OTHERS THEN
2353: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2354: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2355: G_MODULE||l_api_name,
2356: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2357: END IF;

Line 2354: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2350: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2351:
2352: WHEN OTHERS THEN
2353: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2354: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2355: G_MODULE||l_api_name,
2356: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2357: END IF;
2358:

Line 2424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2420: l_cz_imp_rules cz_imp_rules%ROWTYPE;
2421:
2422: BEGIN
2423: -- start debug log
2424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2425: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2426: G_MODULE||l_api_name,
2427: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2428: END IF;

Line 2425: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2421:
2422: BEGIN
2423: -- start debug log
2424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2425: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2426: G_MODULE||l_api_name,
2427: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2428: END IF;
2429:

Line 2446: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2442: LOOP
2443: FETCH csr_intents INTO l_intent,l_org_id;
2444: EXIT WHEN csr_intents%NOTFOUND;
2445:
2446: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2447: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2448: G_MODULE||l_api_name,
2449: '110: l_intent ' || '='||l_intent);
2450: END IF;

Line 2447: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2443: FETCH csr_intents INTO l_intent,l_org_id;
2444: EXIT WHEN csr_intents%NOTFOUND;
2445:
2446: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2447: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2448: G_MODULE||l_api_name,
2449: '110: l_intent ' || '='||l_intent);
2450: END IF;
2451:

Line 2460: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2456: RAISE FND_API.G_EXC_ERROR;
2457: END IF;
2458: CLOSE csr_get_cla_model_dtl;
2459:
2460: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2461: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2462: G_MODULE||l_api_name,
2463: '120: l_model_id ' || '='||l_model_id);
2464: END IF;

Line 2461: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2457: END IF;
2458: CLOSE csr_get_cla_model_dtl;
2459:
2460: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2461: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2462: G_MODULE||l_api_name,
2463: '120: l_model_id ' || '='||l_model_id);
2464: END IF;
2465:

Line 2466: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2462: G_MODULE||l_api_name,
2463: '120: l_model_id ' || '='||l_model_id);
2464: END IF;
2465:
2466: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2467: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2468: G_MODULE||l_api_name,
2469: '130: l_model_osr ' || '='||l_model_osr);
2470: END IF;

Line 2467: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2463: '120: l_model_id ' || '='||l_model_id);
2464: END IF;
2465:
2466: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2467: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2468: G_MODULE||l_api_name,
2469: '130: l_model_osr ' || '='||l_model_osr);
2470: END IF;
2471:

Line 2747: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2743: l_cz_imp_rules.IMPORT_PROG_VERSION,
2744: l_cz_imp_rules.FSK_COMPONENT_ID,
2745: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2746: );
2747: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2748: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2749: G_MODULE||l_api_name,
2750: '170: After Insert into cz_imp_rules' || '='||l_intent);
2751: END IF;

Line 2748: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2744: l_cz_imp_rules.FSK_COMPONENT_ID,
2745: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2746: );
2747: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2748: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2749: G_MODULE||l_api_name,
2750: '170: After Insert into cz_imp_rules' || '='||l_intent);
2751: END IF;
2752:

Line 2764: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2760: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2761:
2762:
2763: -- end debug log
2764: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2765: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2766: G_MODULE||l_api_name,
2767: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2768: END IF;

Line 2765: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2761:
2762:
2763: -- end debug log
2764: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2765: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2766: G_MODULE||l_api_name,
2767: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2768: END IF;
2769:

Line 2772: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2768: END IF;
2769:
2770: EXCEPTION
2771: WHEN FND_API.G_EXC_ERROR THEN
2772: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2774: G_MODULE||l_api_name,
2775: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2776: END IF;

Line 2773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2769:
2770: EXCEPTION
2771: WHEN FND_API.G_EXC_ERROR THEN
2772: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2774: G_MODULE||l_api_name,
2775: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2776: END IF;
2777:

Line 2782: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2778: x_return_status := G_RET_STS_ERROR ;
2779: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2780:
2781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2782: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2783: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2784: G_MODULE||l_api_name,
2785: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2786: END IF;

Line 2783: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2779: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2780:
2781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2782: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2783: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2784: G_MODULE||l_api_name,
2785: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2786: END IF;
2787:

Line 2792: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2788: x_return_status := G_RET_STS_UNEXP_ERROR ;
2789: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2790:
2791: WHEN OTHERS THEN
2792: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2793: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2794: G_MODULE||l_api_name,
2795: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2796: END IF;

Line 2793: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2789: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2790:
2791: WHEN OTHERS THEN
2792: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2793: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2794: G_MODULE||l_api_name,
2795: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2796: END IF;
2797: