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 608: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

604: --
605:
606:
607: -- end debug log
608: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
609: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
610: G_MODULE||l_api_name,
611: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
612: END IF;

Line 609: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

605:
606:
607: -- end debug log
608: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
609: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
610: G_MODULE||l_api_name,
611: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
612: END IF;
613:

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

612: END IF;
613:
614: EXCEPTION
615: WHEN FND_API.G_EXC_ERROR THEN
616: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
618: G_MODULE||l_api_name,
619: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
620: END IF;

Line 617: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

613:
614: EXCEPTION
615: WHEN FND_API.G_EXC_ERROR THEN
616: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
617: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
618: G_MODULE||l_api_name,
619: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
620: END IF;
621:

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

628:
629: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
630:
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
633: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
634: G_MODULE||l_api_name,
635: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
636: END IF;

Line 633: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

629: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
630:
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
633: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
634: G_MODULE||l_api_name,
635: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
636: END IF;
637:

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

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

Line 648: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

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

750:
751:
752: BEGIN
753: -- start debug log
754: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
755: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
756: G_MODULE||l_api_name,
757: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
758: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 755: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

751:
752: BEGIN
753: -- start debug log
754: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
755: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
756: G_MODULE||l_api_name,
757: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
758: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
759: G_MODULE||l_api_name,

Line 758: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

754: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
755: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
756: G_MODULE||l_api_name,
757: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
758: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
759: G_MODULE||l_api_name,
760: '100: Parameters ');
761: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
762: G_MODULE||l_api_name,

Line 761: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

757: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
758: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
759: G_MODULE||l_api_name,
760: '100: Parameters ');
761: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
762: G_MODULE||l_api_name,
763: '100: p_rule_id : '||p_rule_id);
764: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
765: G_MODULE||l_api_name,

Line 764: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

760: '100: Parameters ');
761: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
762: G_MODULE||l_api_name,
763: '100: p_rule_id : '||p_rule_id);
764: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
765: G_MODULE||l_api_name,
766: '100: p_template_id : '||p_template_id);
767: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
768: G_MODULE||l_api_name,

Line 767: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

763: '100: p_rule_id : '||p_rule_id);
764: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
765: G_MODULE||l_api_name,
766: '100: p_template_id : '||p_template_id);
767: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
768: G_MODULE||l_api_name,
769: '100: p_run_id : '||p_run_id);
770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
771: G_MODULE||l_api_name,

Line 770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

766: '100: p_template_id : '||p_template_id);
767: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
768: G_MODULE||l_api_name,
769: '100: p_run_id : '||p_run_id);
770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
771: G_MODULE||l_api_name,
772: '100: p_mode : '||p_mode);
773: END IF;
774:

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

791: l_template_id;
792:
793: IF csr_template_dtls%NOTFOUND THEN
794: -- debug Log
795: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
796: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
797: G_MODULE||l_api_name,
798: '110: Invalid Template Id: '||p_template_id);
799: END IF;

Line 796: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

792:
793: IF csr_template_dtls%NOTFOUND THEN
794: -- debug Log
795: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
796: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
797: G_MODULE||l_api_name,
798: '110: Invalid Template Id: '||p_template_id);
799: END IF;
800: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TEMPLATE');

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

818: FETCH csr_template_model_id INTO l_model_id, l_model_osr;
819:
820: IF csr_template_model_id%NOTFOUND THEN
821: -- debug Log
822: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
823: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
824: G_MODULE||l_api_name,
825: '110: Template Model Does Not Exists : '||l_template_name);
826: END IF;

Line 823: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

819:
820: IF csr_template_model_id%NOTFOUND THEN
821: -- debug Log
822: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
823: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
824: G_MODULE||l_api_name,
825: '110: Template Model Does Not Exists : '||l_template_name);
826: END IF;
827: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TMPL_MODEL');

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

831:
832: CLOSE csr_template_model_id;
833:
834: -- debug Log
835: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
836: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
837: G_MODULE||l_api_name,
838: '120: Template Name : '||l_template_name);
839: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 836: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

832: CLOSE csr_template_model_id;
833:
834: -- debug Log
835: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
836: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
837: G_MODULE||l_api_name,
838: '120: Template Name : '||l_template_name);
839: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
840: G_MODULE||l_api_name,

Line 839: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

835: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
836: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
837: G_MODULE||l_api_name,
838: '120: Template Name : '||l_template_name);
839: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
840: G_MODULE||l_api_name,
841: '120: Derived Template Id : '||l_template_id);
842: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
843: G_MODULE||l_api_name,

Line 842: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

838: '120: Template Name : '||l_template_name);
839: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
840: G_MODULE||l_api_name,
841: '120: Derived Template Id : '||l_template_id);
842: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
843: G_MODULE||l_api_name,
844: '120: Template Model Id : '||l_model_id);
845: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
846: G_MODULE||l_api_name,

Line 845: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

841: '120: Derived Template Id : '||l_template_id);
842: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
843: G_MODULE||l_api_name,
844: '120: Template Model Id : '||l_model_id);
845: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
846: G_MODULE||l_api_name,
847: '120: Template Model OSR : '||l_model_osr);
848: END IF;
849:

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

1149: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1150:
1151:
1152: -- end debug log
1153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1155: G_MODULE||l_api_name,
1156: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1157: END IF;

Line 1154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1150:
1151:
1152: -- end debug log
1153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1155: G_MODULE||l_api_name,
1156: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1157: END IF;
1158:

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

1157: END IF;
1158:
1159: EXCEPTION
1160: WHEN FND_API.G_EXC_ERROR THEN
1161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1162: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1163: G_MODULE||l_api_name,
1164: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1165: END IF;

Line 1162: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1158:
1159: EXCEPTION
1160: WHEN FND_API.G_EXC_ERROR THEN
1161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1162: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1163: G_MODULE||l_api_name,
1164: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1165: END IF;
1166:

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

1172: x_msg_data := SQLERRM;
1173: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1174:
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1176: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1178: G_MODULE||l_api_name,
1179: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1180: END IF;

Line 1177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1173: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1174:
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1176: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1178: G_MODULE||l_api_name,
1179: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1180: END IF;
1181:

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

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

Line 1192: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

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

1310:
1311:
1312: BEGIN
1313: -- start debug log
1314: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1315: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1316: G_MODULE||l_api_name,
1317: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1318: END IF;

Line 1315: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1311:
1312: BEGIN
1313: -- start debug log
1314: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1315: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1316: G_MODULE||l_api_name,
1317: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1318: END IF;
1319:

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

1324: FETCH csr_cz_run_id INTO x_run_id;
1325: CLOSE csr_cz_run_id;
1326:
1327: -- 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: '110: Rule Import x_run_id : '|| x_run_id);
1332: END IF;

Line 1329: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1325: CLOSE csr_cz_run_id;
1326:
1327: -- 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: '110: Rule Import x_run_id : '|| x_run_id);
1332: END IF;
1333:

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

1406: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1407:
1408:
1409: -- end debug log
1410: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1411: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1412: G_MODULE||l_api_name,
1413: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1414: END IF;

Line 1411: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1407:
1408:
1409: -- end debug log
1410: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1411: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1412: G_MODULE||l_api_name,
1413: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1414: END IF;
1415:

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

1414: END IF;
1415:
1416: EXCEPTION
1417: WHEN FND_API.G_EXC_ERROR THEN
1418: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1419: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1420: G_MODULE||l_api_name,
1421: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1422: END IF;

Line 1419: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1415:
1416: EXCEPTION
1417: WHEN FND_API.G_EXC_ERROR THEN
1418: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1419: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1420: G_MODULE||l_api_name,
1421: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1422: END IF;
1423:

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

1424: x_return_status := G_RET_STS_ERROR ;
1425: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1426:
1427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1428: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1429: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1430: G_MODULE||l_api_name,
1431: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1432: END IF;

Line 1429: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1425: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1426:
1427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1428: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1429: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1430: G_MODULE||l_api_name,
1431: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1432: END IF;
1433:

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

1434: x_return_status := G_RET_STS_UNEXP_ERROR ;
1435: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1436:
1437: WHEN OTHERS THEN
1438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1440: G_MODULE||l_api_name,
1441: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1442: END IF;

Line 1439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1435: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1436:
1437: WHEN OTHERS THEN
1438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1440: G_MODULE||l_api_name,
1441: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1442: END IF;
1443:

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

1499:
1500:
1501: BEGIN
1502: -- start debug log
1503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1504: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1505: G_MODULE||l_api_name,
1506: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1507: END IF;

Line 1504: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1500:
1501: BEGIN
1502: -- start debug log
1503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1504: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1505: G_MODULE||l_api_name,
1506: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1507: END IF;
1508:

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

1513: FETCH csr_cz_run_id INTO x_run_id;
1514: CLOSE csr_cz_run_id;
1515:
1516: -- 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: '110: Rule Import x_run_id : '|| x_run_id);
1521: END IF;

Line 1518: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1514: CLOSE csr_cz_run_id;
1515:
1516: -- 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: '110: Rule Import x_run_id : '|| x_run_id);
1521: END IF;
1522:

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

1563: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1564:
1565:
1566: -- end debug log
1567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1568: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1569: G_MODULE||l_api_name,
1570: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1571: END IF;

Line 1568: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1564:
1565:
1566: -- end debug log
1567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1568: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1569: G_MODULE||l_api_name,
1570: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1571: END IF;
1572:

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

1571: END IF;
1572:
1573: EXCEPTION
1574: WHEN FND_API.G_EXC_ERROR THEN
1575: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1576: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1577: G_MODULE||l_api_name,
1578: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1579: END IF;

Line 1576: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1572:
1573: EXCEPTION
1574: WHEN FND_API.G_EXC_ERROR THEN
1575: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1576: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1577: G_MODULE||l_api_name,
1578: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1579: END IF;
1580:

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

1581: x_return_status := G_RET_STS_ERROR ;
1582: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1583:
1584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1585: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1586: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1587: G_MODULE||l_api_name,
1588: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1589: END IF;

Line 1586: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1582: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1583:
1584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1585: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1586: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1587: G_MODULE||l_api_name,
1588: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1589: END IF;
1590:

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

1591: x_return_status := G_RET_STS_UNEXP_ERROR ;
1592: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
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 ,
1597: G_MODULE||l_api_name,
1598: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1599: END IF;

Line 1596: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1592: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
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 ,
1597: G_MODULE||l_api_name,
1598: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1599: END IF;
1600:

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

1684:
1685:
1686: BEGIN
1687: -- start debug log
1688: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1689: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1690: G_MODULE||l_api_name,
1691: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1692: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1689: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1685:
1686: BEGIN
1687: -- start debug log
1688: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1689: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1690: G_MODULE||l_api_name,
1691: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1692: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1693: G_MODULE||l_api_name,

Line 1692: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1688: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1689: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1690: G_MODULE||l_api_name,
1691: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1692: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1693: G_MODULE||l_api_name,
1694: '100: Parameters ');
1695: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1696: G_MODULE||l_api_name,

Line 1695: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1691: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1692: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1693: G_MODULE||l_api_name,
1694: '100: Parameters ');
1695: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1696: G_MODULE||l_api_name,
1697: '100: p_template_id : '||p_template_id);
1698: END IF;
1699:

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

1711: FETCH csr_template_dtls INTO l_parent_template_id;
1712:
1713: IF csr_template_dtls%NOTFOUND THEN
1714: -- Log Error
1715: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1716: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1717: G_MODULE||l_api_name,
1718: '110: Invalid Template Id: '||p_template_id);
1719: END IF;

Line 1716: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1712:
1713: IF csr_template_dtls%NOTFOUND THEN
1714: -- Log Error
1715: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1716: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1717: G_MODULE||l_api_name,
1718: '110: Invalid Template Id: '||p_template_id);
1719: END IF;
1720: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TEMPLATE');

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

1725:
1726:
1727:
1728: -- debug log
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: Rule Import x_run_id : '|| x_run_id);
1733: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1730: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1726:
1727:
1728: -- debug log
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: Rule Import x_run_id : '|| x_run_id);
1733: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1734: G_MODULE||l_api_name,

Line 1733: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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: Rule Import x_run_id : '|| x_run_id);
1733: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1734: G_MODULE||l_api_name,
1735: '110: p_template_id : '|| p_template_id);
1736: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1737: G_MODULE||l_api_name,

Line 1736: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1732: '110: Rule Import x_run_id : '|| x_run_id);
1733: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1734: G_MODULE||l_api_name,
1735: '110: p_template_id : '|| p_template_id);
1736: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1737: G_MODULE||l_api_name,
1738: '110: l_parent_template_id '|| l_parent_template_id);
1739: END IF;
1740:

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

1794: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1795:
1796:
1797: -- end debug log
1798: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1799: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1800: G_MODULE||l_api_name,
1801: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1802: END IF;

Line 1799: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1795:
1796:
1797: -- end debug log
1798: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1799: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1800: G_MODULE||l_api_name,
1801: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1802: END IF;
1803:

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

1802: END IF;
1803:
1804: EXCEPTION
1805: WHEN FND_API.G_EXC_ERROR THEN
1806: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1807: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1808: G_MODULE||l_api_name,
1809: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1810: END IF;

Line 1807: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1803:
1804: EXCEPTION
1805: WHEN FND_API.G_EXC_ERROR THEN
1806: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1807: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1808: G_MODULE||l_api_name,
1809: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1810: END IF;
1811:

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

1816: x_return_status := G_RET_STS_ERROR ;
1817: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1818:
1819: WHEN FND_API.G_EXC_UNEXPECTED_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: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1824: END IF;

Line 1821: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1817: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1818:
1819: WHEN FND_API.G_EXC_UNEXPECTED_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: '3000: 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_UNEXP_ERROR ;
1831: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1832:
1833: WHEN OTHERS 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: '4000: 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 OTHERS 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: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1838: END IF;
1839:

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

1967: l_cz_imp_rules cz_imp_rules%ROWTYPE;
1968:
1969: BEGIN
1970: -- start debug log
1971: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1972: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1973: G_MODULE||l_api_name,
1974: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1975: END IF;

Line 1972: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1968:
1969: BEGIN
1970: -- start debug log
1971: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1972: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1973: G_MODULE||l_api_name,
1974: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1975: END IF;
1976:

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

1989: LOOP
1990: FETCH csr_intents INTO l_intent,l_org_id;
1991: EXIT WHEN csr_intents%NOTFOUND;
1992:
1993: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1994: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1995: G_MODULE||l_api_name,
1996: '110: l_intent ' || '='||l_intent);
1997: END IF;

Line 1994: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1990: FETCH csr_intents INTO l_intent,l_org_id;
1991: EXIT WHEN csr_intents%NOTFOUND;
1992:
1993: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1994: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1995: G_MODULE||l_api_name,
1996: '110: l_intent ' || '='||l_intent);
1997: END IF;
1998:

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

2003: RAISE FND_API.G_EXC_ERROR;
2004: END IF;
2005: CLOSE csr_get_cla_model_dtl;
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: '120: l_model_id ' || '='||l_model_id);
2011: END IF;

Line 2008: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2004: END IF;
2005: CLOSE csr_get_cla_model_dtl;
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: '120: l_model_id ' || '='||l_model_id);
2011: END IF;
2012:

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

2009: G_MODULE||l_api_name,
2010: '120: l_model_id ' || '='||l_model_id);
2011: END IF;
2012:
2013: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2014: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2015: G_MODULE||l_api_name,
2016: '130: l_model_osr ' || '='||l_model_osr);
2017: END IF;

Line 2014: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2010: '120: l_model_id ' || '='||l_model_id);
2011: END IF;
2012:
2013: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2014: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2015: G_MODULE||l_api_name,
2016: '130: l_model_osr ' || '='||l_model_osr);
2017: END IF;
2018:

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

2290: l_cz_imp_rules.IMPORT_PROG_VERSION,
2291: l_cz_imp_rules.FSK_COMPONENT_ID,
2292: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2293: );
2294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2296: G_MODULE||l_api_name,
2297: '170: After Insert into cz_imp_rules' || '='||l_intent);
2298: END IF;

Line 2295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2291: l_cz_imp_rules.FSK_COMPONENT_ID,
2292: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2293: );
2294: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2295: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2296: G_MODULE||l_api_name,
2297: '170: After Insert into cz_imp_rules' || '='||l_intent);
2298: END IF;
2299:

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

2307: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2308:
2309:
2310: -- end debug log
2311: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2312: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2313: G_MODULE||l_api_name,
2314: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2315: END IF;

Line 2312: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2308:
2309:
2310: -- end debug log
2311: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2312: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2313: G_MODULE||l_api_name,
2314: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2315: END IF;
2316:

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

2315: END IF;
2316:
2317: EXCEPTION
2318: WHEN FND_API.G_EXC_ERROR THEN
2319: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2321: G_MODULE||l_api_name,
2322: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2323: END IF;

Line 2320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2316:
2317: EXCEPTION
2318: WHEN FND_API.G_EXC_ERROR THEN
2319: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2321: G_MODULE||l_api_name,
2322: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2323: END IF;
2324:

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

2325: x_return_status := G_RET_STS_ERROR ;
2326: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2327:
2328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2329: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2330: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2331: G_MODULE||l_api_name,
2332: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2333: END IF;

Line 2330: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2326: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2327:
2328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2329: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2330: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2331: G_MODULE||l_api_name,
2332: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2333: END IF;
2334:

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

2335: x_return_status := G_RET_STS_UNEXP_ERROR ;
2336: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2337:
2338: WHEN OTHERS THEN
2339: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2340: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2341: G_MODULE||l_api_name,
2342: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2343: END IF;

Line 2340: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2336: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2337:
2338: WHEN OTHERS THEN
2339: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2340: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2341: G_MODULE||l_api_name,
2342: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2343: END IF;
2344:

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

2406: l_cz_imp_rules cz_imp_rules%ROWTYPE;
2407:
2408: BEGIN
2409: -- start debug log
2410: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2411: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2412: G_MODULE||l_api_name,
2413: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2414: END IF;

Line 2411: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2407:
2408: BEGIN
2409: -- start debug log
2410: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2411: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2412: G_MODULE||l_api_name,
2413: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2414: END IF;
2415:

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

2428: LOOP
2429: FETCH csr_intents INTO l_intent,l_org_id;
2430: EXIT WHEN csr_intents%NOTFOUND;
2431:
2432: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2434: G_MODULE||l_api_name,
2435: '110: l_intent ' || '='||l_intent);
2436: END IF;

Line 2433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2429: FETCH csr_intents INTO l_intent,l_org_id;
2430: EXIT WHEN csr_intents%NOTFOUND;
2431:
2432: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2434: G_MODULE||l_api_name,
2435: '110: l_intent ' || '='||l_intent);
2436: END IF;
2437:

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

2442: RAISE FND_API.G_EXC_ERROR;
2443: END IF;
2444: CLOSE csr_get_cla_model_dtl;
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: '120: l_model_id ' || '='||l_model_id);
2450: END IF;

Line 2447: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2443: END IF;
2444: CLOSE csr_get_cla_model_dtl;
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: '120: l_model_id ' || '='||l_model_id);
2450: END IF;
2451:

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

2448: G_MODULE||l_api_name,
2449: '120: l_model_id ' || '='||l_model_id);
2450: END IF;
2451:
2452: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2453: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2454: G_MODULE||l_api_name,
2455: '130: l_model_osr ' || '='||l_model_osr);
2456: END IF;

Line 2453: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2449: '120: l_model_id ' || '='||l_model_id);
2450: END IF;
2451:
2452: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2453: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2454: G_MODULE||l_api_name,
2455: '130: l_model_osr ' || '='||l_model_osr);
2456: END IF;
2457:

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

2729: l_cz_imp_rules.IMPORT_PROG_VERSION,
2730: l_cz_imp_rules.FSK_COMPONENT_ID,
2731: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2732: );
2733: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2735: G_MODULE||l_api_name,
2736: '170: After Insert into cz_imp_rules' || '='||l_intent);
2737: END IF;

Line 2734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2730: l_cz_imp_rules.FSK_COMPONENT_ID,
2731: l_cz_imp_rules.FSK_MODEL_REF_EXPL_ID
2732: );
2733: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2735: G_MODULE||l_api_name,
2736: '170: After Insert into cz_imp_rules' || '='||l_intent);
2737: END IF;
2738:

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

2746: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2747:
2748:
2749: -- end debug log
2750: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2751: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2752: G_MODULE||l_api_name,
2753: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2754: END IF;

Line 2751: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2747:
2748:
2749: -- end debug log
2750: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2751: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2752: G_MODULE||l_api_name,
2753: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2754: END IF;
2755:

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

2754: END IF;
2755:
2756: EXCEPTION
2757: WHEN FND_API.G_EXC_ERROR THEN
2758: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2759: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2760: G_MODULE||l_api_name,
2761: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2762: END IF;

Line 2759: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2755:
2756: EXCEPTION
2757: WHEN FND_API.G_EXC_ERROR THEN
2758: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2759: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2760: G_MODULE||l_api_name,
2761: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2762: END IF;
2763:

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

2764: x_return_status := G_RET_STS_ERROR ;
2765: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2766:
2767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2768: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2769: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2770: G_MODULE||l_api_name,
2771: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2772: END IF;

Line 2769: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2765: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2766:
2767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2768: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2769: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2770: G_MODULE||l_api_name,
2771: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2772: END IF;
2773:

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

2774: x_return_status := G_RET_STS_UNEXP_ERROR ;
2775: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2776:
2777: WHEN OTHERS THEN
2778: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2779: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2780: G_MODULE||l_api_name,
2781: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2782: END IF;

Line 2779: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2775: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2776:
2777: WHEN OTHERS THEN
2778: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2779: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2780: G_MODULE||l_api_name,
2781: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2782: END IF;
2783: